Layers:

Layer: Crashes (0)


Name: Crashes

Display Field: StName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 1771659.74898086
YMin: 752569.874686327
XMax: 1807761.48589862
YMax: 799023.500586444
Spatial Reference: 102723 (3735)


Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"Severity","defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[130,130,130,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,0,0,153],"size":8,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}},"value":"0","label":"NA"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[230,0,0,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}},"value":"1","label":"Fatal"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[230,152,0,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}},"value":"2","label":"Serious Injury Suspected"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,255,0,255],"size":9,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}},"value":"3","label":"Minor Injury Suspected"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[170,255,0,255],"size":9,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}},"value":"4","label":"Injury Possible"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[56,168,0,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}},"value":"5","label":"PDO"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,234,184,255],"toColor":[252,234,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,179,252,255],"toColor":[179,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,205,255],"toColor":[252,179,205,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,246,255],"toColor":[179,252,246,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,252,182,255],"toColor":[182,252,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[210,223,252,255],"toColor":[210,223,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[244,179,252,255],"toColor":[244,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,216,207,255],"toColor":[252,216,207,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,251,255],"toColor":[252,215,251,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[220,252,204,255],"toColor":[220,252,204,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,183,179,255],"toColor":[252,183,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[215,246,252,255],"toColor":[215,246,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[244,252,179,255],"toColor":[244,252,179,255]}]}}},"scaleSymbols":true,"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: GlobalID

Type ID Field: Severity

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ReportNum (type: esriFieldTypeString, alias: ReportNum, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true)
• CrashDate (type: esriFieldTypeDate, alias: Crash Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Time (type: esriFieldTypeString, alias: Time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DistanceFrom (type: esriFieldTypeSmallInteger, alias: Distance from, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ReferenceSt (type: esriFieldTypeString, alias: Reference, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SpeedLimit (type: esriFieldTypeSmallInteger, alias: Posted Speed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• District (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Units (type: esriFieldTypeSmallInteger, alias: Units, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Injuries (type: esriFieldTypeSmallInteger, alias: Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Fatality (type: esriFieldTypeSmallInteger, alias: Fatal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Manner (type: esriFieldTypeSmallInteger, alias: Harmful Event, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Not Collsn Between 2 Veh in Transpt], [2: Rear-End], [3: Head-On], ... 7 more ...)
• Lighting (type: esriFieldTypeSmallInteger, alias: Lighting, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Daylight], [2: Dawn/Dusk], [3: Dark - Lighted Roadway], ... 4 more ...)
• RdConditions (type: esriFieldTypeSmallInteger, alias: Road Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Dry], [2: Wet], [3: Snow], ... 6 more ...)
• TrafficControl (type: esriFieldTypeSmallInteger, alias: Traffic Control, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Roundabout], [2: Signal], [3: Flasher], ... 4 more ...)
• RdConfig (type: esriFieldTypeSmallInteger, alias: Crash Location Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: NA], [1: On Roadway], [2: On Shoulder], ... 13 more ...)
• AlcoholTestStatus (type: esriFieldTypeSmallInteger, alias: Alcohol Test Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: NA], [1: None], [2: Test Refused], ... 3 more ...)
• AlcoholDrugSuspected (type: esriFieldTypeSmallInteger, alias: Alcohol Drugs Suspected, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Alcohol], [2: Marijuana], [3: Other Drug], ... 5 more ...)
• OffenseDescription (type: esriFieldTypeString, alias: Offense Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OffenseCharged (type: esriFieldTypeString, alias: Offense Charge, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DamageScale (type: esriFieldTypeSmallInteger, alias: Damage Scale, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: None], [2: Minor], [3: Functional], ... 3 more ...)
• DirTravel (type: esriFieldTypeSmallInteger, alias: Veh Travel Direction, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: North], [2: South], ... 64 more ...)
• IntersectNo (type: esriFieldTypeSmallInteger, alias: Intersection Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Severity (type: esriFieldTypeSmallInteger, alias: Severity, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [1: Fatal], [2: Serious Injury Suspected], [3: Minor Injury Suspected], ... 3 more ...)
• UnitNum (type: esriFieldTypeSmallInteger, alias: Unit Number, SQL Type: sqlTypeOther, nullable: false, editable: true)
• InjuryClass (type: esriFieldTypeSmallInteger, alias: Injury Type, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [5: No Apparent Injury], [4: Injury Possible], [3: Suspected Minor Injury], ... 3 more ...)
• VehicleType (type: esriFieldTypeSmallInteger, alias: Type of Unit, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [1: Passenger Car], [2: Passenger Van (Minivan)], [3: Sport Utility Vehicle], ... 25 more ...)
• PreCrashAction (type: esriFieldTypeSmallInteger, alias: PreCrash Action, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [1: Straight Ahead], [2: Backing], [3: Changing Lanes], ... 20 more ...)
• Narrative (type: esriFieldTypeString, alias: Narrative, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true)
• PDF (type: esriFieldTypeString, alias: PDF, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true)
• NLFID (type: esriFieldTypeString, alias: NLFID, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true)
• LogPoint (type: esriFieldTypeDouble, alias: Log Point, SQL Type: sqlTypeOther, nullable: false, editable: true)
• Age (type: esriFieldTypeSmallInteger, alias: Driver Age, SQL Type: sqlTypeOther, nullable: false, editable: true)
• DriverDistraction (type: esriFieldTypeSmallInteger, alias: Distraction, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: NA], [1: Not Distracted], [2: Manually operating an electronic communication device (Texting, Typing, Dialing)], ... 7 more ...)
• UnitInError (type: esriFieldTypeSmallInteger, alias: Unit in Error (Animal), SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [1: Unit 1], [2: Unit 2], [3: Unit 3], ... 3 more ...)
• ContributingCircumstances (type: esriFieldTypeString, alias: Contributing Circumstances, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true, Coded Values: [NONE: None], [FAILURE TO YIELD: Failure to Yield], [RAN RED LIGHT: Ran Red Light], ... 21 more ...)
• Lat (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Completely (type: esriFieldTypeString, alias: Crash Reviewed Completely, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• DOW (type: esriFieldTypeString, alias: Day of Week, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [MON: Monday], [TUE: Tuesday], [WED: Wednesday], ... 5 more ...)
• DistanceUnits (type: esriFieldTypeString, alias: Distance Units, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [0: NA], [FT: Feet], [MI: Miles], ... 1 more ...)
• DirectionReference (type: esriFieldTypeString, alias: Direction from Intersecting, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [0: NA], [E: East], [N: North], ... 6 more ...)
• InterOrSeg (type: esriFieldTypeString, alias: Intersection or Segment, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Intersection: Intersection], [Segment: Segment], [NA: NA])
• StName (type: esriFieldTypeString, alias: St Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• PrivateProperty (type: esriFieldTypeInteger, alias: Private Property, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• BikePed (type: esriFieldTypeSmallInteger, alias: Bike or Ped, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Passenger Car], [2: Passenger Van (Minivan)], [3: Sport Utility Vehicle], ... 25 more ...)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Weather (type: esriFieldTypeInteger, alias: Weather, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Clear], [2: Cloudy], [4: Rain], ... 8 more ...)
• HourOfDay (type: esriFieldTypeInteger, alias: Hour, SQL Type: sqlTypeOther, nullable: true, editable: true)

Types:

ID: 0
Name: NA
Domains:

• Field Name: Manner
  Inherited
  
• Field Name: Lighting
  Inherited
  
• Field Name: RdConditions
  Inherited
  
• Field Name: Weather
  Inherited
  
• Field Name: TrafficControl
  Inherited
  
• Field Name: RdConfig
  Inherited
  
• Field Name: AlcoholTestStatus
  Inherited
  
• Field Name: AlcoholDrugSuspected
  Inherited
  
• Field Name: DamageScale
  Inherited
  
• Field Name: DirTravel
  Inherited
  
• Field Name: Severity
  Inherited
  
• Field Name: InjuryClass
  Inherited
  
• Field Name: VehicleType
  Inherited
  
• Field Name: PreCrashAction
  Inherited
  
• Field Name: DriverDistraction
  Inherited
  
• Field Name: UnitInError
  Inherited
  
• Field Name: ContributingCircumstances
  Inherited
  
• Field Name: Completely
  Inherited
  
• Field Name: DOW
  Inherited
  
• Field Name: DistanceUnits
  Inherited
  
• Field Name: DirectionReference
  Inherited
  
• Field Name: InterOrSeg
  Inherited
  
• Field Name: PrivateProperty
  Inherited
  
• Field Name: BikePed
  Inherited
  
Templates:

Name: NA
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Severity: 0

---

ID: 1
Name: Fatal
Domains:

• Field Name: Manner
  Inherited
  
• Field Name: Lighting
  Inherited
  
• Field Name: RdConditions
  Inherited
  
• Field Name: Weather
  Inherited
  
• Field Name: TrafficControl
  Inherited
  
• Field Name: RdConfig
  Inherited
  
• Field Name: AlcoholTestStatus
  Inherited
  
• Field Name: AlcoholDrugSuspected
  Inherited
  
• Field Name: DamageScale
  Inherited
  
• Field Name: DirTravel
  Inherited
  
• Field Name: Severity
  Inherited
  
• Field Name: InjuryClass
  Inherited
  
• Field Name: VehicleType
  Inherited
  
• Field Name: PreCrashAction
  Inherited
  
• Field Name: DriverDistraction
  Inherited
  
• Field Name: UnitInError
  Inherited
  
• Field Name: ContributingCircumstances
  Inherited
  
• Field Name: Completely
  Inherited
  
• Field Name: DOW
  Inherited
  
• Field Name: DistanceUnits
  Inherited
  
• Field Name: DirectionReference
  Inherited
  
• Field Name: InterOrSeg
  Inherited
  
• Field Name: PrivateProperty
  Inherited
  
• Field Name: BikePed
  Inherited
  
Templates:

Name: Fatal
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Severity: 1

---

ID: 2
Name: Serious Injury Suspected
Domains:

• Field Name: Manner
  Inherited
  
• Field Name: Lighting
  Inherited
  
• Field Name: RdConditions
  Inherited
  
• Field Name: Weather
  Inherited
  
• Field Name: TrafficControl
  Inherited
  
• Field Name: RdConfig
  Inherited
  
• Field Name: AlcoholTestStatus
  Inherited
  
• Field Name: AlcoholDrugSuspected
  Inherited
  
• Field Name: DamageScale
  Inherited
  
• Field Name: DirTravel
  Inherited
  
• Field Name: Severity
  Inherited
  
• Field Name: InjuryClass
  Inherited
  
• Field Name: VehicleType
  Inherited
  
• Field Name: PreCrashAction
  Inherited
  
• Field Name: DriverDistraction
  Inherited
  
• Field Name: UnitInError
  Inherited
  
• Field Name: ContributingCircumstances
  Inherited
  
• Field Name: Completely
  Inherited
  
• Field Name: DOW
  Inherited
  
• Field Name: DistanceUnits
  Inherited
  
• Field Name: DirectionReference
  Inherited
  
• Field Name: InterOrSeg
  Inherited
  
• Field Name: PrivateProperty
  Inherited
  
• Field Name: BikePed
  Inherited
  
Templates:

Name: Serious Injury Suspected
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Severity: 2

---

ID: 3
Name: Minor Injury Suspected
Domains:

• Field Name: Manner
  Inherited
  
• Field Name: Lighting
  Inherited
  
• Field Name: RdConditions
  Inherited
  
• Field Name: Weather
  Inherited
  
• Field Name: TrafficControl
  Inherited
  
• Field Name: RdConfig
  Inherited
  
• Field Name: AlcoholTestStatus
  Inherited
  
• Field Name: AlcoholDrugSuspected
  Inherited
  
• Field Name: DamageScale
  Inherited
  
• Field Name: DirTravel
  Inherited
  
• Field Name: Severity
  Inherited
  
• Field Name: InjuryClass
  Inherited
  
• Field Name: VehicleType
  Inherited
  
• Field Name: PreCrashAction
  Inherited
  
• Field Name: DriverDistraction
  Inherited
  
• Field Name: UnitInError
  Inherited
  
• Field Name: ContributingCircumstances
  Inherited
  
• Field Name: Completely
  Inherited
  
• Field Name: DOW
  Inherited
  
• Field Name: DistanceUnits
  Inherited
  
• Field Name: DirectionReference
  Inherited
  
• Field Name: InterOrSeg
  Inherited
  
• Field Name: PrivateProperty
  Inherited
  
• Field Name: BikePed
  Inherited
  
Templates:

Name: Minor Injury Suspected
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Severity: 3

---

ID: 4
Name: Injury Possible
Domains:

• Field Name: Manner
  Inherited
  
• Field Name: Lighting
  Inherited
  
• Field Name: RdConditions
  Inherited
  
• Field Name: Weather
  Inherited
  
• Field Name: TrafficControl
  Inherited
  
• Field Name: RdConfig
  Inherited
  
• Field Name: AlcoholTestStatus
  Inherited
  
• Field Name: AlcoholDrugSuspected
  Inherited
  
• Field Name: DamageScale
  Inherited
  
• Field Name: DirTravel
  Inherited
  
• Field Name: Severity
  Inherited
  
• Field Name: InjuryClass
  Inherited
  
• Field Name: VehicleType
  Inherited
  
• Field Name: PreCrashAction
  Inherited
  
• Field Name: DriverDistraction
  Inherited
  
• Field Name: UnitInError
  Inherited
  
• Field Name: ContributingCircumstances
  Inherited
  
• Field Name: Completely
  Inherited
  
• Field Name: DOW
  Inherited
  
• Field Name: DistanceUnits
  Inherited
  
• Field Name: DirectionReference
  Inherited
  
• Field Name: InterOrSeg
  Inherited
  
• Field Name: PrivateProperty
  Inherited
  
• Field Name: BikePed
  Inherited
  
Templates:

Name: Injury Possible
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Severity: 4

---

ID: 5
Name: PDO
Domains:

• Field Name: Manner
  Inherited
  
• Field Name: Lighting
  Inherited
  
• Field Name: RdConditions
  Inherited
  
• Field Name: Weather
  Inherited
  
• Field Name: TrafficControl
  Inherited
  
• Field Name: RdConfig
  Inherited
  
• Field Name: AlcoholTestStatus
  Inherited
  
• Field Name: AlcoholDrugSuspected
  Inherited
  
• Field Name: DamageScale
  Inherited
  
• Field Name: DirTravel
  Inherited
  
• Field Name: Severity
  Inherited
  
• Field Name: InjuryClass
  Inherited
  
• Field Name: VehicleType
  Inherited
  
• Field Name: PreCrashAction
  Inherited
  
• Field Name: DriverDistraction
  Inherited
  
• Field Name: UnitInError
  Inherited
  
• Field Name: ContributingCircumstances
  Inherited
  
• Field Name: Completely
  Inherited
  
• Field Name: DOW
  Inherited
  
• Field Name: DistanceUnits
  Inherited
  
• Field Name: DirectionReference
  Inherited
  
• Field Name: InterOrSeg
  Inherited
  
• Field Name: PrivateProperty
  Inherited
  
• Field Name: BikePed
  Inherited
  
Templates:

Name: PDO
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Severity: 5

---


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/29/2026 4:23:13 PM

Schema Last Edit Date: 6/24/2026 5:27:50 PM

Data Last Edit Date: 6/29/2026 4:23:13 PM

Tables:

Crashes Table (1)


Name: Crashes Table

Display Field: StName

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True


Global ID Field: GlobalID

Type ID Field:

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ReportNum (type: esriFieldTypeString, alias: Report Number, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true)
• CrashDate (type: esriFieldTypeDate, alias: Crash Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Time (type: esriFieldTypeString, alias: Time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• StName (type: esriFieldTypeString, alias: Crash Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DistanceFrom (type: esriFieldTypeSmallInteger, alias: Distance from, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ReferenceSt (type: esriFieldTypeString, alias: Reference, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SpeedLimit (type: esriFieldTypeSmallInteger, alias: Posted Speed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• District (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Units (type: esriFieldTypeSmallInteger, alias: Units, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Injuries (type: esriFieldTypeSmallInteger, alias: Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Fatality (type: esriFieldTypeSmallInteger, alias: Fatal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Manner (type: esriFieldTypeSmallInteger, alias: Harmful Event, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Not Collsn Between 2 Veh in Transpt], [2: Rear-End], [3: Head-On], ... 7 more ...)
• Lighting (type: esriFieldTypeSmallInteger, alias: Lighting, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Daylight], [2: Dawn/Dusk], [3: Dark - Lighted Roadway], ... 4 more ...)
• RdConditions (type: esriFieldTypeSmallInteger, alias: Road Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Dry], [2: Wet], [3: Snow], ... 6 more ...)
• Weather (type: esriFieldTypeSmallInteger, alias: Weather, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Clear], [2: Cloudy], [4: Rain], ... 8 more ...)
• TrafficControl (type: esriFieldTypeSmallInteger, alias: Traffic Control, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Roundabout], [2: Signal], [3: Flasher], ... 4 more ...)
• RdConfig (type: esriFieldTypeSmallInteger, alias: Crash Location Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: NA], [1: On Roadway], [2: On Shoulder], ... 13 more ...)
• AlcoholTestStatus (type: esriFieldTypeSmallInteger, alias: Alcohol Test Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: NA], [1: None], [2: Test Refused], ... 3 more ...)
• AlcoholDrugSuspected (type: esriFieldTypeSmallInteger, alias: Alcohol Drugs Suspected, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Alcohol], [2: Marijuana], [3: Other Drug], ... 5 more ...)
• OffenseDescription (type: esriFieldTypeString, alias: Offense Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OffenseCharged (type: esriFieldTypeString, alias: Offense Charged, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DamageScale (type: esriFieldTypeSmallInteger, alias: Damage Scale, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: None], [2: Minor], [3: Functional], ... 3 more ...)
• DirTravel (type: esriFieldTypeSmallInteger, alias: Veh Travel Direction, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: North], [2: South], ... 64 more ...)
• IntersectNo (type: esriFieldTypeSmallInteger, alias: Intersection Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Severity (type: esriFieldTypeSmallInteger, alias: Severity, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Fatal], [2: Serious Injury Suspected], [3: Minor Injury Suspected], ... 3 more ...)
• PrivateProperty (type: esriFieldTypeSmallInteger, alias: Private Property, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• UnitNum (type: esriFieldTypeSmallInteger, alias: Unit Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InjuryClass (type: esriFieldTypeSmallInteger, alias: Injury Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: No Apparent Injury], [4: Injury Possible], [3: Suspected Minor Injury], ... 3 more ...)
• VehicleType (type: esriFieldTypeSmallInteger, alias: Type of Unit, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Passenger Car], [2: Passenger Van (Minivan)], [3: Sport Utility Vehicle], ... 25 more ...)
• PreCrashAction (type: esriFieldTypeSmallInteger, alias: PreCrash Action, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Straight Ahead], [2: Backing], [3: Changing Lanes], ... 20 more ...)
• Narrative (type: esriFieldTypeString, alias: Narrative, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PDF (type: esriFieldTypeString, alias: PDF, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NLFID (type: esriFieldTypeString, alias: NLFID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LogPoint (type: esriFieldTypeDouble, alias: Log Point, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Age (type: esriFieldTypeSmallInteger, alias: Driver Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DriverDistraction (type: esriFieldTypeSmallInteger, alias: Distraction, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: NA], [1: Not Distracted], [2: Manually operating an electronic communication device (Texting, Typing, Dialing)], ... 7 more ...)
• UnitInError (type: esriFieldTypeSmallInteger, alias: Unit in Error (Animal), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Unit 1], [2: Unit 2], [3: Unit 3], ... 3 more ...)
• ContributingCircumstances (type: esriFieldTypeString, alias: Contributing Circumstances, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true, Coded Values: [NONE: None], [FAILURE TO YIELD: Failure to Yield], [RAN RED LIGHT: Ran Red Light], ... 21 more ...)
• DOW (type: esriFieldTypeString, alias: Day of Week, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [MON: Monday], [TUE: Tuesday], [WED: Wednesday], ... 5 more ...)
• DistanceUnits (type: esriFieldTypeString, alias: Distance Units, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [0: NA], [FT: Feet], [MI: Miles], ... 1 more ...)
• DirectionReference (type: esriFieldTypeString, alias: Direction from Intersecting, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [0: NA], [E: East], [N: North], ... 6 more ...)
• InterOrSeg (type: esriFieldTypeString, alias: Intersection Segment, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Intersection: Intersection], [Segment: Segment], [NA: NA])
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Crashes Table Edit
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• ReportNum:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/29/2026 4:23:13 PM

Schema Last Edit Date: 6/24/2026 5:30:32 PM

Data Last Edit Date: 6/29/2026 4:22:57 PM