20251203
12212200
1.0
FALSE
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.4.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b696d5451497961445563494e6b664f7a4b2f4958484c767432362b6f53495a7a41524e63473832476c513d2a00;ENCRYPTED_PASSWORD=00022e686230686a6a76504c63356a625337384b386144703145386d334755696d423357563076557a5054314338303d2a00;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_TRANSIT_FIXED_ROUTE_SERVICE</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>
TruncateTable \\itcfs007\gis\TIMS\TEST\TST31.TIMS.TIMS.sde\WGIS_TRANSIT_FIXED_ROUTE_SERVICE
TruncateTable \\itcfs007\gis\TIMS\TEST\TST31.TIMS.TIMS.sde\WGIS_TRANSIT_FIXED_ROUTE_SERVICE
TruncateTable \\itcfs007\gis\TIMS\TEST\TST31.TIMS.TIMS.sde\WGIS_TRANSIT_FIXED_ROUTE_SERVICE
TruncateTable \\itcfs007\gis\TIMS\TEST\TST31.TIMS.TIMS.sde\WGIS_TRANSIT_FIXED_ROUTE_SERVICE
TruncateTable \\itcfs007\gis\TIMS\TEST\TST31.TIMS.TIMS.sde\WGIS_TRANSIT_FIXED_ROUTE_SERVICE
TruncateTable \\itcfs007\gis\TIMS\TEST\TST31.TIMS.TIMS.sde\WGIS_TRANSIT_FIXED_ROUTE_SERVICE
TruncateTable \\itcfs007\gis\TIMS\TEST\TST31.TIMS.TIMS.sde\WGIS_TRANSIT_FIXED_ROUTE_SERVICE
TruncateTable \\itcfs007\gis\TIMS\TEST\TST31.TIMS.TIMS.sde\WGIS_TRANSIT_FIXED_ROUTE_SERVICE
TruncateTable \\itcfs007\gis\TIMS\TEST\TST31.TIMS.TIMS.sde\WGIS_TRANSIT_FIXED_ROUTE_SERVICE
TruncateTable \\itcfs007\gis\TIMS\TEST\TST31.TIMS.TIMS.sde\WGIS_TRANSIT_FIXED_ROUTE_SERVICE
TruncateTable \\itcfs007\gis\TIMS\TEST\TST31.TIMS.TIMS.sde\WGIS_TRANSIT_FIXED_ROUTE_SERVICE
TruncateTable \\itcfs007\gis\TIMS\TEST\TST31.TIMS.TIMS.sde\WGIS_TRANSIT_FIXED_ROUTE_SERVICE
TruncateTable \\itcfs007\gis\TIMS\TEST\TST31.TIMS.TIMS.sde\WGIS_TRANSIT_FIXED_ROUTE_SERVICE
TruncateTable \\itcfs007\gis\TIMS\TEST\TST31.TIMS.TIMS.sde\WGIS_TRANSIT_FIXED_ROUTE_SERVICE
TruncateTable \\itcfs007\gis\TIMS\TEST\TST31.TIMS.TIMS.sde\WGIS_TRANSIT_FIXED_ROUTE_SERVICE
TruncateTable \\itcfs007\gis\TIMS\TEST\TST31.TIMS.TIMS.sde\WGIS_TRANSIT_FIXED_ROUTE_SERVICE
TruncateTable \\itcfs007\gis\TIMS\TEST\TST31.TIMS.TIMS.sde\WGIS_TRANSIT_FIXED_ROUTE_SERVICE
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.4.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b696d5451497961445563494e6b664f7a4b2f4958484c767432362b6f53495a7a41524e63473832476c513d2a00;ENCRYPTED_PASSWORD=00022e6865754643644341694a746a37576865487a75315648356d5276634a5655356e6f6277316165524b31516b343d2a00;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_TRANSIT_FIXED_ROUTE_SERVICE</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>service_id</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>10</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
TruncateTable \\itcfs007\gis\TIMS\TEST\TST31.TIMS.TIMS.sde\WGIS_TRANSIT_FIXED_ROUTE_SERVICE
DeleteRows \\itcfs007\gis\TIMS\TEST\TST31.TIMS.TIMS.sde\TIMS.WGIS_TRANSIT_FIXED_ROUTE_SERVICE
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.4.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b696d5451497961445563494e6b664f7a4b2f4958484c767432362b6f53495a7a41524e63473832476c513d2a00;ENCRYPTED_PASSWORD=00022e686753654c4369625a6442632b763246754b626b626959502b7553682b4231512f416a446d3543566c6d32493d2a00;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_TRANSIT_FIXED_ROUTE_SERVICE</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDefaultToField><field_name>shape_id</field_name><clear_value>True</clear_value></AssignDefaultToField><AlterField><field_name>shape_id</field_name><field_type>TEXT</field_type><field_length>80</field_length><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/3.4.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b696d5451497961445563494e6b664f7a4b2f4958484c767432362b6f53495a7a41524e63473832476c513d2a00;ENCRYPTED_PASSWORD=00022e686753654c4369625a6442632b763246754b626b626959502b7553682b4231512f416a446d3543566c6d32493d2a00;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_TRANSIT_FIXED_ROUTE_SERVICE</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>agency_id</field_name><field_type>TEXT</field_type><field_length>80</field_length><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>route_id</field_name><field_type>TEXT</field_type><field_length>80</field_length><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>service_id</field_name><field_type>TEXT</field_type><field_length>80</field_length><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence>
DeleteRows \\itcfs007\gis\TIMS\TEST\TST31.TIMS.TIMS.sde\WGIS_TRANSIT_FIXED_ROUTE_SERVICE
DeleteRows \\itcfs007\gis\TIMS\TEST\TST31.TIMS.TIMS.sde\WGIS_TRANSIT_FIXED_ROUTE_SERVICE
DeleteRows \\itcfs007\gis\TIMS\TEST\TST31.TIMS.TIMS.sde\WGIS_TRANSIT_FIXED_ROUTE_SERVICE
DeleteRows \\itcfs007\gis\TIMS\TEST\TST31.TIMS.TIMS.sde\WGIS_TRANSIT_FIXED_ROUTE_SERVICE
DeleteRows \\itcfs007\gis\TIMS\TEST\TST31.TIMS.TIMS.sde\WGIS_TRANSIT_FIXED_ROUTE_SERVICE
CopyMultiple "C:\Users\klewis2\Documents\SDE\TST31.TIMS.TIMS.sde\TIMS.WGIS_TRANSIT_FIXED_ROUTE_STOPS FeatureClass;C:\Users\klewis2\Documents\SDE\TST31.TIMS.TIMS.sde\TIMS.WGIS_TRANSIT_FIXED_ROUTE_SERVICE FeatureClass" C:\Users\klewis2\Documents\SDE\PRD31.TIMS.sde WGIS_TRANSIT_FIXED_ROUTE_STOPS;WGIS_TRANSIT_FIXED_ROUTE_SERVICE "TIMS.WGIS_TRANSIT_FIXED_ROUTE_STOPS FeatureClass TIMS.WGIS_TRANSIT_FIXED_ROUTE_STOPS #;TIMS.WGIS_TRANSIT_FIXED_ROUTE_SERVICE FeatureClass TIMS.WGIS_TRANSIT_FIXED_ROUTE_SERVICE #"
TIMS.WGIS_TRANSIT_FIXED_ROUTE_SERVICE
002
-9439335.219900
-8923633.096000
4636721.066000
5146011.679300
1
Server=DOTICSQLP31; Service=sde:sqlserver:DOTICSQLP31;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.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>
20251119
14170600
20251119
14221800
5000000
5000
FGDC
Microsoft Windows 10 Version 10.0 (Build 26200) ; Esri ArcGIS 13.4.0.55405
Transit Fixed Route Service
Transit Fixed Route Service
1
-84.794991
-80.162360
41.900000
38.404460
<div style='text-align:Left;'><div><div><p><span>Ohio's fixed-route transit service lines, submitted annually by local and regional transit authorities. </span></p></div></div></div>
TRANSIT
https://timstst.dot.state.oh.us/tims/api/glossary/dataset/b5d2b38a72e84422b8deaf9cb145e4c2
Enterprise Geodatabase Feature Class
dataset
EPSG
6.18.3(9.3.1.2)
2836
Simple
FALSE
2836
TRUE
FALSE
TIMS.WGIS_TRANSIT_FIXED_ROUTE_SERVICE
Feature Class
2836
agency_id
agency_id
String
80
0
0
Unique identifier for the transit agency that operates the service
agency_name
agency_name
String
255
0
0
Agency full name
route_id
route_id
String
80
0
0
Route identifier
route_short_name
route_short_name
String
255
0
0
Route short name
route_long_name
route_long_name
String
255
0
0
Route long name
stop_count
stop_count
Integer
4
10
0
Number of stops included in the route service
headway
headway
Integer
4
10
0
Headway is the average time between trips for a route/service, represented in minutes.
service_id
service_id
String
80
0
0
The service id groups together dates when a specific set of trips is available. For example, "weekday service" or "Saturday service" may differ for the same route.
shape_id
shape_id
String
80
0
0
The shape id ties a route service to a geometry path for mapping
20251119
ODOT Office of Transit
https://www.transportation.ohio.gov/programs/transit
iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO
xAAADsQBlSsOGwAAAqpJREFUeJzt1DENADAMwLAd5U+5o7BvimQjyJXZ3T0AAfM7AOCVYQEZhgVk
GBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFY
QIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZ
hgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgW
kGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECG
YQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYF
ZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBh
WECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEB
GYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQY
FpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhA
hmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmG
BWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQ
YVhAhmEBGYYFnIoLreIHHblfYqUAAAAASUVORK5CYII=