Name: Vehicle

Display Field: CID

Type: Table

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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• CID (type: esriFieldTypeString, alias: Crash ID, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• CID_UID (type: esriFieldTypeString, alias: Crash ID - Vehicle ID, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• NO_OCC (type: esriFieldTypeInteger, alias: Number Of Occupants, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VEHT (type: esriFieldTypeInteger, alias: Vehicle Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Passenger car], [2: Pickup truck], [3: Van, mini-van], ... 20 more ...)
• VEHU (type: esriFieldTypeInteger, alias: Vehicle Use, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Not in use], [2: Personal], [3: Driver education], ... 23 more ...)
• VEHD (type: esriFieldTypeInteger, alias: Vehicle Direction, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: None], [2: Brakes], [3: Steering], ... 15 more ...)
• MANV (type: esriFieldTypeInteger, alias: Vehicle Maneuver, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Straight ahead], [2: Passing, overtaking], [3: Turning left], ... 25 more ...)
• DIRP (type: esriFieldTypeInteger, alias: Vehicle Direction, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: North], [2: Northeast], [3: East], ... 7 more ...)
• TOW (type: esriFieldTypeInteger, alias: Is Vehicle Towed, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• FIRE_IND (type: esriFieldTypeInteger, alias: Vehicle Fire, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• HAZMAT (type: esriFieldTypeInteger, alias: Hazard Material, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• CV_IND (type: esriFieldTypeInteger, alias: Commercial Vehicle, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• FRST_CONT (type: esriFieldTypeInteger, alias: First Contact, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: Front], [2: Right front quarter panel], ... 12 more ...)
• EXC_SPL (type: esriFieldTypeInteger, alias: Exceed Speed Limit, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• MHE (type: esriFieldTypeInteger, alias: Most Harmful Event, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Ran off the roadway], [2: Overturn], [3: Fire, explosion], ... 42 more ...)
• MHE_LOC (type: esriFieldTypeInteger, alias: Most Harmful Event Location, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: On pavement (roadway)], [2: Off pavement left], [3: Off pavement right], ... 6 more ...)
• MHE_NO (type: esriFieldTypeInteger, alias: Most Harmful Event Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EVNT1 (type: esriFieldTypeInteger, alias: Event 1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Ran off the roadway], [2: Overturn], [3: Fire, explosion], ... 42 more ...)
• EVNT2 (type: esriFieldTypeInteger, alias: Event 2, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Ran off the roadway], [2: Overturn], [3: Fire, explosion], ... 42 more ...)
• EVNT3 (type: esriFieldTypeInteger, alias: Event 3, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Ran off the roadway], [2: Overturn], [3: Fire, explosion], ... 42 more ...)
• LOC1 (type: esriFieldTypeInteger, alias: Event 1 Location, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: On pavement (roadway)], [2: Off pavement left], [3: Off pavement right], ... 6 more ...)
• LOC2 (type: esriFieldTypeInteger, alias: Event 2 Location, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: On pavement (roadway)], [2: Off pavement left], [3: Off pavement right], ... 6 more ...)
• LOC3 (type: esriFieldTypeInteger, alias: Event 3 Location, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: On pavement (roadway)], [2: Off pavement left], [3: Off pavement right], ... 6 more ...)
• V_YEAR (type: esriFieldTypeString, alias: Vehicle Year, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• V_MAKE (type: esriFieldTypeString, alias: Vehicle Year, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• V_MODEL (type: esriFieldTypeString, alias: Vehicle Model, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
• YEAR (type: esriFieldTypeInteger, alias: Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPD_CODE (type: esriFieldTypeString, alias: Vehicle Speed, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• TowedDueTo (type: esriFieldTypeString, alias: Towed Due To, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• AutomationInVehicle (type: esriFieldTypeString, alias: Automation In Vehicle, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• LevelOfAutomationDuringCrash (type: esriFieldTypeString, alias: Level Of Automation During Crash, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• ExtentOfDamage (type: esriFieldTypeString, alias: Extent Of Damage, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)

Templates:

Name: Vehicle
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• Crash (0) -- Related To: Crash (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/18/2023 7:15:14 PM

Schema Last Edit Date: 1/18/2023 7:15:14 PM

Data Last Edit Date: 1/18/2023 7:15:14 PM

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