Name: Crashes Table

Display Field: StName

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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:22:57 PM

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

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

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