20230927
06033800
1.0
FALSE
TIMS.WGIS_TRAFFIC_COUNT_STATIONS
002
-9442127.340500
-8963335.414500
4636926.709700
5156038.497600
1
Server=DOTICSQLT31; Service=sde:sqlserver:DOTICSQLT31;APPLICATIONINTENT=READWRITE;MULTISUBNETFAILOVER=YES; Database=TIMS; User=TIMS; Version=dbo.DEFAULT
ArcSDE Connection
Projected
GCS_WGS_1984
Linear Unit: Meter (1.000000)
WGS_1984_Web_Mercator_Auxiliary_Sphere
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.2.0'><WKT>PROJCS["WGS_1984_Web_Mercator_Auxiliary_Sphere",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Mercator_Auxiliary_Sphere"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",0.0],PARAMETER["Auxiliary_Sphere_Type",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",3857]]</WKT><XOrigin>-20037700</XOrigin><YOrigin>-30241100</YOrigin><XYScale>10000</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102100</WKID><LatestWKID>3857</LatestWKID></ProjectedCoordinateSystem>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.2.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b696d5451497961445563494e6b664f7a4b2f4958484c767432362b6f53495a7a41524e63473832476c513d2a00;ENCRYPTED_PASSWORD=00022e683268736c6b517934446e6a386c316659346d78782f56654843722f4439597536797475705a384e717145553d2a00;SERVER=DOTICSQLT31;INSTANCE="sde:sqlserver:DOTICSQLT31;APPLICATIONINTENT=READWRITE;MULTISUBNETFAILOVER=YES";DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES="DOTICSQLT31;APPLICATIONINTENT=READWRITE;MULTISUBNETFAILOVER=YES";DATABASE=TIMS;USER=TIMS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>TIMS.WGIS_TRAFFIC_COUNT_STATIONS</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><EnableEditorTracking><creator_field>created_user</creator_field><creation_date_field>created_date</creation_date_field><last_editor_field>last_edited_user</last_editor_field><last_edit_date_field>last_edited_date</last_edit_date_field><add_fields>TRUE</add_fields><record_dates_in>UTC</record_dates_in></EnableEditorTracking></workflow></operationSequence>
Append D:\TIMS\Connections\T31_TIMS.sde\TIMS.WGIS_TRAFFIC_COUNT_STATIONS D:\TIMS\Connections\TIMS.sde\TIMS.WGIS_TRAFFIC_COUNT_STATIONS "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY
20240503
12023500
20240729
15364600
625000
5000
FGDC
Microsoft Windows 10 Version 10.0 (Build 19045) ; Esri ArcGIS 13.2.0.49743
Traffic Count Stations
Traffic Count Stations
1
-84.820073
-80.519012
41.967007
38.405908
<div style='text-align:Left;'><div><div><p><span>ODOT maintained traffic count stations, including permanent stations and short term count data collection locations.</span></p></div></div></div>
ODOT Office of Technical Services
Traffic
AADT
Technical Services
<div style='text-align:Left;'><div><div><p><span><span>The information contained within this dataset is maintained by the Ohio Department of Transportation (ODOT), and is deemed to be public information. While every effort is made to assure the data is accurate and current, it must be accepted and used by the recipient with the understanding that no warranties, expressed or implied, concerning the accuracy, reliability or suitability of this data have been made. ODOT, its agents, and the developers of this data set assume no liability whatsoever associated with the use or misuse of the data contained herein.</span></span></p></div></div></div>
https://tims.dot.state.oh.us/tims/api/glossary/dataset/3ef47585481e42c6b148316d73c6544a
Enterprise Geodatabase Feature Class
dataset
EPSG
6.18.3(9.3.1.2)
50641
Simple
FALSE
50641
TRUE
FALSE
TIMS.WGIS_TRAFFIC_COUNT_STATIONS
Feature Class
50641
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
STATION_ID_NBR
STATION_ID_NBR
String
25
0
0
Unique Identifier for AADT Station
NLFID
NLFID
String
14
0
0
Primary key field that is the basis for identifying unique roadway segments in ODOT's graphic roadway network. The attribute is made up of seven components that describe administrative and other characteristics related to a route segment; Positions (1) - Jurisdiction, (2 thru 4) - County Code, (5 thru 6) - Route Type, (7 thru 11) - Route Number, (12) - Extension Code, (13) - Description Code, (14) - Direction Code; For further definitions of codes, please refer to the Roadway Information Manual
CTL_BEGIN_NBR
CTL_BEGIN_NBR
Double
8
38
8
GIS linear referencing information - location of Count Station
COUNTY_CD
COUNTY_CD
String
3
0
0
The 3-letter code of the county within Ohio (88 counties total)
COUNT_SOURCE
COUNT_SOURCE
String
100
0
0
Jurisdiction/organization count was taken for
IS_PERMANENT
IS_PERMANENT
String
3
0
0
Yes - permanent station, No - short term count location
ROUTE_TYPE
ROUTE_TYPE
String
2
0
0
Two letter code indicating the basic transportation grouping or system that the route belongs to - third component of the NLFID
ROUTE_NBR
ROUTE_NBR
String
5
0
0
Route number associated with the section of the route
AADT_YEAR
AADT_YEAR
Integer
4
10
0
Year original data was collected.
AADT
AADT
Integer
4
10
0
AADT_CARS
AADT_CARS
Integer
4
10
0
Annual Average Daily Traffic for passenger type vehicles
AADT_TRUCKS
AADT_TRUCKS
Integer
4
10
0
Annual Average Daily Traffic for type BC trucks. (B=Buses C= Commercial Trucks)
AADT_SINGLE_TRUCKS
AADT_SINGLE_TRUCKS
Integer
4
10
0
Annual Average Daily Traffic for single-unit trucks. (A truck tractor unit pulling other such units in a saddle mount configuration will be considered one single-unit truck)
AADT_COMBO_TRUCKS
AADT_COMBO_TRUCKS
Integer
4
10
0
Annual Average Daily Traffic for Combination Trucks. (Combination vehicles are vehicles with a tractor and multiple trailers, often trailers of different sizes and layouts.)
K_FACTOR
K_FACTOR
Double
8
38
8
30th highest hourly volume of the year (out of 8,760 possible hours in a calendar year) expressed as a percentage of the AADT volume. K Factors (also known as Design Hour Volumes) are commonly used in highway project assessments and/or design concept reports.
D_FACTOR
D_FACTOR
Double
8
38
8
D Factor is the percentage of traffic moving in the peak travel direction during the 30th highest hourly volume of the year. It is calculated by dividing the higher directional volume occurring in the 30th highest hour by the total roadway volume for that hour.
TRAFFIC_REPORTS
TRAFFIC_REPORTS
String
255
0
0
Link to corresponding traffic report
created_user
created_user
String
255
0
0
created_date
created_date
Date
8
0
0
last_edited_user
last_edited_user
String
255
0
0
last_edited_date
last_edited_date
Date
8
0
0
SHAPE
SHAPE
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
20250919
ODOT Office of Technical Services
https://www.transportation.ohio.gov/programs/technical-services/traffic-monitoring
iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO
xAAADsQBlSsOGwAAAqpJREFUeJzt1DENADAMwLAd5U+5o7BvimQjyJXZ3T0AAfM7AOCVYQEZhgVk
GBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFY
QIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZ
hgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgW
kGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECG
YQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYF
ZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBh
WECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEB
GYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQY
FpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhA
hmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmG
BWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQ
YVhAhmEBGYYFnIoLreIHHblfYqUAAAAASUVORK5CYII=