20240716
15564200
1.0
FALSE
CreateFeatureclass \\itcfs007\home\sde\TST31.TIMS.TIMS_Classic.sde WGIS_RI_NHFN Polyline \\itcfs007\home\sde\TST31.TIMS.TIMS_Classic.sde\TIMS_CLASSIC.TIMS.WGIS_RI_NATIONAL_TRUCK_NETWORK No No "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]];-20037700 -30241100 10000;-100000 10000;-100000 10000;0.001;0.001;0.001;IsHighPrecision" # 0 0 0 #
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/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e687851724f672f3770583253716e484f3151755a76634f73314b3938647356706a42626e6839636a306d70553d2a00;SERVER=DOTICSQLT31;INSTANCE="sde:sqlserver:DOTICSQLT31;APPLICATIONINTENT=READWRITE;MULTISUBNETFAILOVER=YES";DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES="DOTICSQLT31;APPLICATIONINTENT=READWRITE;MULTISUBNETFAILOVER=YES";DATABASE=TIMS_CLASSIC;USER=TIMS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>TIMS_CLASSIC.TIMS.WGIS_RI_NHFN</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>FAP_IND</field_name><new_field_name>FREIGHT_NETWORK_IND</new_field_name><field_alias>FREIGHT_NETWORK_IND</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence>
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/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e687851724f672f3770583253716e484f3151755a76634f73314b3938647356706a42626e6839636a306d70553d2a00;SERVER=DOTICSQLT31;INSTANCE="sde:sqlserver:DOTICSQLT31;APPLICATIONINTENT=READWRITE;MULTISUBNETFAILOVER=YES";DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES="DOTICSQLT31;APPLICATIONINTENT=READWRITE;MULTISUBNETFAILOVER=YES";DATABASE=TIMS_CLASSIC;USER=TIMS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>TIMS_CLASSIC.TIMS.WGIS_RI_NHFN</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><workflow><RegisterAsVersioned><edit_to_base>TRUE</edit_to_base></RegisterAsVersioned></workflow></operationSequence>
Append 'O:\Planning\Technical Services\RIGIS\NHFN\NHFN_2023.gdb\NHFN2023' \\itcfs007\home\sde\TST31.TIMS.TIMS_Classic.sde\TIMS_CLASSIC.TIMS.WGIS_RI_NHFN "Use the field map to reconcile field differences" "PERP_YEAR "PERP_YEAR" true true false 2 Short 0 5,First,#;ODOT_DISTRICT "ODOT_DISTRICT" true true false 2 Text 0 0,First,#;NLF_ID "NLF_ID" true false false 14 Text 0 0,First,#,O:\Planning\Technical Services\RIGIS\NHFN\NHFN_2023.gdb\NHFN2023,NLF_ID,0,14;JURISDICTION_CD "JURISDICTION_CD" true true false 1 Text 0 0,First,#;COUNTY_CD "COUNTY_CD" true true false 3 Text 0 0,First,#;ROUTE_TYPE "ROUTE_TYPE" true true false 2 Text 0 0,First,#;ROUTE_NBR "ROUTE_NBR" true true false 5 Text 0 0,First,#;ROUTE_SUFFIX "ROUTE_SUFFIX" true true false 1 Text 0 0,First,#;ROUTE_EXTENSION_CD "ROUTE_EXTENSION_CD" true true false 1 Text 0 0,First,#;CARDINALITY_CD "CARDINALITY_CD" true true false 1 Text 0 0,First,#;CTL_BEGIN_NBR "CTL_BEGIN_NBR" true false false 8 Double 8 38,First,#;CTL_END_NBR "CTL_END_NBR" true false false 8 Double 8 38,First,#;FREIGHT_NETWORK_IND "FREIGHT_NETWORK_IND" true true false 1 Text 0 0,First,#" # #
DeleteRows TIMS_CLASSIC.TIMS.WGIS_RI_NHFN
Append 'O:\Planning\Technical Services\RIGIS\NHFN\NHFN_2023.gdb\NHFN2023' TIMS_CLASSIC.TIMS.WGIS_RI_NHFN "Use the field map to reconcile field differences" "PERP_YEAR "PERP_YEAR" true true false 2 Short 0 5,First,#;ODOT_DISTRICT "ODOT_DISTRICT" true true false 2 Text 0 0,First,#;NLF_ID "NLF_ID" true false false 14 Text 0 0,First,#,O:\Planning\Technical Services\RIGIS\NHFN\NHFN_2023.gdb\NHFN2023,NLF_ID,0,14;JURISDICTION_CD "JURISDICTION_CD" true true false 1 Text 0 0,First,#;COUNTY_CD "COUNTY_CD" true true false 3 Text 0 0,First,#;ROUTE_TYPE "ROUTE_TYPE" true true false 2 Text 0 0,First,#;ROUTE_NBR "ROUTE_NBR" true true false 5 Text 0 0,First,#;ROUTE_SUFFIX "ROUTE_SUFFIX" true true false 1 Text 0 0,First,#;ROUTE_EXTENSION_CD "ROUTE_EXTENSION_CD" true true false 1 Text 0 0,First,#;CARDINALITY_CD "CARDINALITY_CD" true true false 1 Text 0 0,First,#;CTL_BEGIN_NBR "CTL_BEGIN_NBR" true false false 8 Double 8 38,First,#,O:\Planning\Technical Services\RIGIS\NHFN\NHFN_2023.gdb\NHFN2023,MEASURE_FROM,-1,-1;CTL_END_NBR "CTL_END_NBR" true false false 8 Double 8 38,First,#,O:\Planning\Technical Services\RIGIS\NHFN\NHFN_2023.gdb\NHFN2023,MEASURE_TO,-1,-1;FREIGHT_NETWORK_IND "FREIGHT_NETWORK_IND" true true false 1 Text 0 0,First,#" # #
CalculateField TIMS_CLASSIC.TIMS.WGIS_RI_NHFN PERP_YEAR 2023 "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField TIMS_CLASSIC.TIMS.WGIS_RI_NHFN JURISDICTION_CD !NLF_ID![0:1] "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField TIMS_CLASSIC.TIMS.WGIS_RI_NHFN COUNTY_CD !NLF_ID![1:4] "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField TIMS_CLASSIC.TIMS.WGIS_RI_NHFN COUNTY_CD !NLF_ID![4:6] "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField TIMS_CLASSIC.TIMS.WGIS_RI_NHFN COUNTY_CD !NLF_ID![1:4] "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField TIMS_CLASSIC.TIMS.WGIS_RI_NHFN ROUTE_TYPE !NLF_ID![4:6] "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField TIMS_CLASSIC.TIMS.WGIS_RI_NHFN ROUTE_NBR !NLF_ID![6:11] "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField TIMS_CLASSIC.TIMS.WGIS_RI_NHFN ROUTE_SUFFIX !NLF_ID![11:12] "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField TIMS_CLASSIC.TIMS.WGIS_RI_NHFN ROUTE_EXTENSION_CD !NLF_ID![12:13] "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField TIMS_CLASSIC.TIMS.WGIS_RI_NHFN CARDINALITY_CD !NLF_ID![13:14] "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField TIMS_CLASSIC.TIMS.WGIS_RI_NHFN FREIGHT_NETWORK_IND '1' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField TIMS_CLASSIC.TIMS.WGIS_RI_NHFN ODOT_DISTRICT '01' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField TIMS_CLASSIC.TIMS.WGIS_RI_NHFN ODOT_DISTRICT '02' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField TIMS_CLASSIC.TIMS.WGIS_RI_NHFN ODOT_DISTRICT '03' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField TIMS_CLASSIC.TIMS.WGIS_RI_NHFN ODOT_DISTRICT '04' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField TIMS_CLASSIC.TIMS.WGIS_RI_NHFN ODOT_DISTRICT '05' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField TIMS_CLASSIC.TIMS.WGIS_RI_NHFN ODOT_DISTRICT '06' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField TIMS_CLASSIC.TIMS.WGIS_RI_NHFN ODOT_DISTRICT '07' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField TIMS_CLASSIC.TIMS.WGIS_RI_NHFN ODOT_DISTRICT '07' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField TIMS_CLASSIC.TIMS.WGIS_RI_NHFN ODOT_DISTRICT '08' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField TIMS_CLASSIC.TIMS.WGIS_RI_NHFN ODOT_DISTRICT '10' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField TIMS_CLASSIC.TIMS.WGIS_RI_NHFN ODOT_DISTRICT '11' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField TIMS_CLASSIC.TIMS.WGIS_RI_NHFN ODOT_DISTRICT '12' "Python 3" # Text NO_ENFORCE_DOMAINS
CopyMultiple "\\itcfs007\home\sde\TST31.TIMS.TIMS_Classic.sde\TIMS_CLASSIC.TIMS.WGIS_RI_NHFN FeatureClass" \\itcfs007\home\sde\TST31.TIMS.TIMS.sde WGIS_RI_NHFN "TIMS_CLASSIC.TIMS.WGIS_RI_NHFN FeatureClass TIMS.WGIS_RI_NHFN #"
Server=DOTICSQLP31; Service=sde:sqlserver:DOTICSQLP31;ApplicationIntent=READWRITE;MultisubnetFailover=YES; Database=TIMS; User=TIMS; Version=dbo.DEFAULT
ArcSDE Connection
TIMS.WGIS_RI_NHFN
-9442139.607500
-8963329.058900
4732640.667800
5151562.536600
1
002
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.4.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>
FGDC
20250605
14221200
20250605
14221200
5000000
5000
dataset
20240711
Enterprise Geodatabase Feature Class
Sections of the Road Inventory that are on the Primary Highway Freight System (PHFS) and part of the National Highway Freight Network (NHFN). The NHFN for Ohio only contains routes on the PHFS. For more information on freight network designations, please visit: https://ops.fhwa.dot.gov/freight/infrastructure/nfn/index.htm
<div style='text-align:Left;'><div><div><p><span><span>Sections of the Road Inventory that are on the Primary Highway Freight System (PHFS) and part of the National Highway Freight Network (NHFN). The NHFN for Ohio only contains routes on the PHFS. For more information on freight network designations, please visit: https://ops.fhwa.dot.gov/freight/infrastructure/nfn/index.htm Update frequency: Annual.</span></span></p></div></div></div>
ODOT Office of Technical Services and Office of Data Governance
Road Inventory
Technical Services
National Highway Freight System
Network
PHFS
NHFN
<div style='text-align:Left;'><div><div><p><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></p></div></div></div>
Microsoft Windows 10 Version 10.0 (Build 26100) ; Esri ArcGIS 13.4.0.55405
National Highway Freight Network
National Highway Freight Network
1
-84.820183
-80.518955
41.937104
39.076536
https://tims.dot.state.oh.us/tims/api/glossary/dataset/504a97525e664cbcbd985d725119be34
ODOT Office of Technical Services
https://www.transportation.ohio.gov/programs/technical-services/welcome
165
EPSG
6.18.3(9.3.1.2)
TIMS.WGIS_RI_NHFN
Feature Class
165
PERP_YEAR
PERP_YEAR
Calendar year in which a RI event occurs (like new constructions, abandoning of roads, annexations, increase in speed limit, and so on) on a roadway and is recorded in ODOT’s RI database.
short int
ODOT_DISTRICT
ODOT_DISTRICT
From 1-12 plus Central Office – the counties are grouped into districts in Ohio for ease of maintenance and funding
text(2)
NLF_ID
NLF_ID
Network Linear Feature Identifier. Primary key field that allows ODOT’s graphic roadway network geometric segments to be linked to business data attributes.
text(14)
JURISDICTION_CD
JURISDICTION_CD
Type of jurisdiction to which the section of the route belongs. C-county, F-federal, M-municipal, P-private, S-state, T-township.
text(1)
COUNTY_CD
COUNTY_CD
The 3-letter code of the county within Ohio (88 counties total)
text(3)
ROUTE_TYPE
ROUTE_TYPE
Two letter code indicating the basic transportation grouping or system that the route belongs to - third component of the NLFID. IR-interstate, US-US route, SR-state route, etc
text(2)
ROUTE_NBR
ROUTE_NBR
Route number associated with the section of the route
text(5)
ROUTE_SUFFIX
ROUTE_SUFFIX
Route suffix used to differentiate routes with similar route numbers.
text(1)
ROUTE_EXTENSION_CD
ROUTE_EXTENSION_CD
Route suffix provides additional context or definition of route naming or usage.
text(1)
CARDINALITY_CD
CARDINALITY_CD
Cardinal/non-cardinal direction of the route. All roadways are inventoried in the predominant direction from south to north and west to east.
text(1)
CTL_BEGIN_NBR
CTL_BEGIN_NBR
The point of origin for a given section of road. All routes are county-based, generally beginning at 0.000 where a segment begins. CTL-county true log.
double(8, 3)
CTL_END_NBR
CTL_END_NBR
The terminus point for a given section of road. CTL-county true log
double(8, 3)
FREIGHT_NETWORK_IND
FREIGHT_NETWORK_IND
A value of 1 indicates whether the route is on the Primary Highway Freight System (PHFS) and is part of the National Highway Freight Network (NHFN). The NHFN for Ohio only contains routes on the PHFS. For more information on freight network designations, please visit: https://ops.fhwa.dot.gov/freight/infrastructure/nfn/index.htm
text(1)
iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO
xAAADsQBlSsOGwAAAqpJREFUeJzt1DENADAMwLAd5U+5o7BvimQjyJXZ3T0AAfM7AOCVYQEZhgVk
GBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFY
QIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZ
hgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgW
kGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECG
YQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYF
ZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBh
WECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEB
GYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQY
FpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhA
hmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmG
BWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQ
YVhAhmEBGYYFnIoLreIHHblfYqUAAAAASUVORK5CYII=