20251023
11523400
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=00022e684e4e636e6631624d33497566653746684f58694c666d3969486c647a5942556c4f426948435475713367733d2a00;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_CRASH_LOCATIONS</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>
AddIndex \\itcfs007\gis\TIMS\TEST\TST31.TIMS.TIMS.sde\TIMS.WGIS_CRASH_LOCATIONS DOCUMENT_NBR crash_doc_index UNIQUE NON_ASCENDING
CopyMultiple "C:\Users\klewis2\Documents\SDE\TST31.TIMS.TIMS.sde\TIMS.WGIS_CRASH_LOCATIONS FeatureClass" C:\Users\klewis2\Documents\SDE\PRD31.TIMS.sde WGIS_CRASH_LOCATIONS "TIMS.WGIS_CRASH_LOCATIONS FeatureClass TIMS.WGIS_CRASH_LOCATIONS #"
AddIndex C:\Users\klewis2\Documents\SDE\PRD31.TIMS.sde\TIMS.WGIS_CRASH_LOCATIONS CRASH_YR CRASH_YR NON_UNIQUE NON_ASCENDING
TIMS.WGIS_CRASH_LOCATIONS
-9458231.258200
-8947988.464700
4636765.670900
5156047.815700
1
Server=DOTICSQLP31; Service=sde:sqlserver:DOTICSQLP31;APPLICATIONINTENT=READWRITE;MULTISUBNETFAILOVER=YES; Database=TIMS; User=TIMS; Version=dbo.DEFAULT
ArcSDE Connection
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>
20250930
15435600
20251023
15120200
FGDC
5000000
5000
dataset
20251129
Enterprise Geodatabase Feature Class
Microsoft Windows 10 Version 10.0 (Build 26100) ; Esri ArcGIS 13.4.0.55405
2024 Crash Locations
1
-84.964737
-80.381148
41.967069
38.404774
<div style='text-align:Left;font-size:12pt'><div><div><p><span>Crash locations for the year 2024. ODOT’s crash data system uses the OH1 Report provided by DPS and law enforcement agencies around the state to compile crash data and break it down by different attributes. These attributes are used in AASHTOWare Safety crash analysis tool to summarize crash trends around the state. </span></p></div></div></div>
CRASH
SAFETY
OH1
<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>
https://tims.dot.state.oh.us/tims/api/glossary/dataset/b87e516f9efc44188541adf27be19c01
ODOT Highway Safety Program
https://www.transportation.ohio.gov/traveling/safety/data
1284604
EPSG
6.18.3(9.3.1.2)
TIMS.WGIS_CRASH_LOCATIONS
Feature Class
1284604
DOCUMENT_NBR
DOCUMENT_NBR
Unique number assigned to each crash. It will be the same for the crash level record, unit level record and people level record. The first four numbers will designate the crash year.
integer
CRASH_YR
CRASH_YR
Year of crash
integer
MONTH_OF_CRASH
MONTH_OF_CRASH
Month of crash
integer
DAY_IN_WEEK_CD
DAY_IN_WEEK_CD
Number associated with the day of week the crash occurred
integer
HOUR_OF_CRASH
HOUR_OF_CRASH
Hour of crash
integer
CRASH_SEVERITY_CD
CRASH_SEVERITY_CD
Code indicating the five-level severity of the crash
integer
CRASH_SEVERITY_TXT
CRASH_SEVERITY_TXT
Severity of the crash
text(50)
CRASH_TYPE_CD
CRASH_TYPE_CD
Code indicating ODOT's calculated crash type, similar to manner of collision but expanded for engineering purposes
integer
CRASH_TYPE_TXT
CRASH_TYPE_TXT
ODOT's calculated crash type
text(50)
ODOT_CRASH_LOCATION_CD
ODOT_CRASH_LOCATION_CD
Code indicating the type of location that best describes where the first event of the crash occurred
integer
ODOT_CRASH_LOCATION_TXT
ODOT_CRASH_LOCATION_TXT
Type of location that best describes where the first event of the crash occurred
text(50)
FUNCTIONAL_CLASS_CD
FUNCTIONAL_CLASS_CD
The roadway classes for the FHWA approved Functional Class system. This is based upon assignment of roads into systems according to the character of service they provide in relation to the total road network upon which the crash occurred.
integer
ODOT_LANES_NBR
ODOT_LANES_NBR
The number of lanes in both directions carrying through traffic upon which the crash occurred
integer
COUNTY_CD
COUNTY_CD
County abbreviation for the section of roadway in which the crash occurred
text(3)
ODOT_DISTRICT
ODOT_DISTRICT
ODOT District
text(2)
ODOT_LATITUDE_NBR
ODOT_LATITUDE_NBR
Latitude (Y) coordinate at which the crash occurred, in decimal degrees.
double(9,6)
ODOT_LONGITUDE_NBR
ODOT_LONGITUDE_NBR
Longitude (X) coordinate at which the crash occurred, in decimal degrees.
double(9,6)
iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO
xAAADsQBlSsOGwAAAqpJREFUeJzt1DENADAMwLAd5U+5o7BvimQjyJXZ3T0AAfM7AOCVYQEZhgVk
GBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFY
QIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZ
hgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgW
kGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECG
YQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYF
ZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBh
WECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEB
GYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQY
FpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhA
hmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmG
BWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQ
YVhAhmEBGYYFnIoLreIHHblfYqUAAAAASUVORK5CYII=