Name: Initial Fatal Crashes

Display Field: ST_ACDT

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 10000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 239090.690288708
YMin: 93027.8120078743
XMax: 2258937.88484251
YMax: 1633897.58234908
Spatial Reference: 2992 (2992)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[163,139,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"label":"","description":""},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ST_ACDT (type: esriFieldTypeInteger, alias: CAR Fatal Crash #, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ACDT_DT (type: esriFieldTypeDate, alias: Crash Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ACDT_TM (type: esriFieldTypeInteger, alias: Crash Time (24 hr), SQL Type: sqlTypeOther, nullable: true, editable: true)
• ACDT_TM_DSPLY (type: esriFieldTypeString, alias: Crash Time (display), SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• CITY (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• COUNTY (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• ODOT_DIST (type: esriFieldTypeString, alias: ODOT Maintenance District, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ODOT_REG (type: esriFieldTypeString, alias: ODOT Region, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• R_U (type: esriFieldTypeString, alias: Rural/Urban, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• HWYNUMB (type: esriFieldTypeString, alias: ODOT Highway #, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• LRM_KEY (type: esriFieldTypeString, alias: Linear Reference Method Key, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MP (type: esriFieldTypeDouble, alias: Milepoint, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROAD (type: esriFieldTypeString, alias: Road, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• ROAD_INT (type: esriFieldTypeString, alias: Intersecting Road, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• DIR (type: esriFieldTypeString, alias: Travel Direction, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• INTERSECTION (type: esriFieldTypeString, alias: Intersection Related, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• LOCATION (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LAT (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LONGTD (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AGENCY (type: esriFieldTypeString, alias: Reporting Agency, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• CASE_NUM (type: esriFieldTypeString, alias: Agency Case #, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• P_CRASH_RPT (type: esriFieldTypeString, alias: Police Crash Report Received by CAR, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• CNSTRC_ZN (type: esriFieldTypeString, alias: Work Zone, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SCHL_ZN (type: esriFieldTypeString, alias: School Zone, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• CMV (type: esriFieldTypeString, alias: Commercial Motor Vehicle, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• HIT_RUN (type: esriFieldTypeString, alias: Hit & Run, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• RAILROAD (type: esriFieldTypeString, alias: Railroad, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• DISTRACT (type: esriFieldTypeString, alias: Distracted, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• DRG_ALCHL (type: esriFieldTypeString, alias: Drugs / Alcohol, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• HARMFUL (type: esriFieldTypeString, alias: Most Harmful Event, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• HARMFUL_O (type: esriFieldTypeString, alias: Other Harmful Event, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• NUM_FATALS (type: esriFieldTypeInteger, alias: Number of Fatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GENDERS (type: esriFieldTypeString, alias: Fatality Gender(s), SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• AGES (type: esriFieldTypeString, alias: Fatality Age(s), SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• AGE_RNGS (type: esriFieldTypeString, alias: Fatality Age Range(s), SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• VHCL_TYPS (type: esriFieldTypeString, alias: Fatality Vehicle Category, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• POSs (type: esriFieldTypeString, alias: Fatality Position(s), SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• RSTRNTS (type: esriFieldTypeString, alias: Fatality Restraints Used, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ABGS (type: esriFieldTypeString, alias: Fatality Airbag Use, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• EJS (type: esriFieldTypeString, alias: Fatality Ejected, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• BIKE (type: esriFieldTypeString, alias: Bicyclist, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• PED (type: esriFieldTypeString, alias: Pedestrian, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• REMARKS (type: esriFieldTypeString, alias: Crash Note, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ADD_DT (type: esriFieldTypeDate, alias: Date Added, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• REMOVED (type: esriFieldTypeInteger, alias: Removed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RMVD_DT (type: esriFieldTypeDate, alias: Date Removed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SPEED (type: esriFieldTypeSmallInteger, alias: Posted Speed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SIGNED_RTE (type: esriFieldTypeString, alias: Route, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• DMV_NUM (type: esriFieldTypeString, alias: DMV #, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)

Templates:

Name: DMZ_GIS_WORK.SDE.InitialFatal_Public_Crash
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• P_CRASH_RPT: 0
• CNSTRC_ZN: U
• SCHL_ZN: U
• DISTRACT: U
• ADD_DT: -2209161600000
• ST_ACDT: 0
• CMV: U
• DRG_ALCHL: U
• REMOVED: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/29/2026 8:46:37 PM

Schema Last Edit Date: 6/29/2026 8:46:37 PM

Data Last Edit Date: 6/29/2026 8:46:37 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat