All Layers and Tables (IL_Crash_Dataset

Layers:

Layer: Crash (0)

Name:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[145,39,145,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

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)
NO_VEH (type: esriFieldTypeInteger, alias: Number Of Vehicles, SQL Type: sqlTypeOther, nullable: true, editable: true)
YEAR (type: esriFieldTypeInteger, alias: Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
DAYOFWEEK (type: esriFieldTypeString, alias: Day Of Week, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
KABCO (type: esriFieldTypeString, alias: KABCO, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
K (type: esriFieldTypeInteger, alias: Number Of Fatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
A (type: esriFieldTypeInteger, alias: Number of A Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
B (type: esriFieldTypeInteger, alias: Number of B Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
C (type: esriFieldTypeInteger, alias: Number of C Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
O (type: esriFieldTypeInteger, alias: Number of Persons with No Injury, SQL Type: sqlTypeOther, nullable: true, editable: true)
RT_NBR (type: esriFieldTypeString, alias: Route Number, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
INT_REL (type: esriFieldTypeInteger, alias: Intersection Related, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
FUNC_CLASS (type: esriFieldTypeInteger, alias: Functional Class, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Interstate], [2: Freeway and Expressway], [3: Other Principal Arterial], ... 15 more ...)
TWAY_CLASS (type: esriFieldTypeInteger, alias: Traffic Way Class, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unmarked Highway rural], [1: Controlled rural], [2: State numbered rural], ... 7 more ...)
TWAY_DESC (type: esriFieldTypeInteger, alias: Traffic Way Description, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Two Way: Not divided], [2: Two Way: Divided, with median barrier (not raised)], [3: Two Way: Divided, with median barrier], ... 20 more ...)
TCONT_DEV (type: esriFieldTypeInteger, alias: Traffic Control Device, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: No controls], [2: Stop sign], [3: Traffic signal], ... 17 more ...)
TCONT_CON (type: esriFieldTypeInteger, alias: Traffic Control Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: No controls], [2: Not functioning], [3: Functioning improperly], ... 6 more ...)
ALIGN (type: esriFieldTypeInteger, alias: Alignment Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Straight and level], [2: Straight on grade], [3: Straight on hillcrest], ... 5 more ...)
SURF_CON (type: esriFieldTypeInteger, alias: Surface Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Dry], [2: Wet], [3: Snow or slush], ... 5 more ...)
DEFECT (type: esriFieldTypeInteger, alias: Road Defects, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: No defects], [2: Construction zone], [3: Maintenance zone], ... 9 more ...)
LIGHT (type: esriFieldTypeInteger, alias: Light Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Daylight], [2: Dawn], [3: Dusk], ... 4 more ...)
WEATHER (type: esriFieldTypeInteger, alias: Weather Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Clear], [2: Rain], [3: Snow], ... 8 more ...)
COL_TYPE (type: esriFieldTypeInteger, alias: Collision Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Pedestrian], [2: Pedalcyclist], [3: Railway Train], ... 16 more ...)
CAUSE_1 (type: esriFieldTypeInteger, alias: Primary Cause, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Exceeding authorized speed limit], [2: Failing to yield right-of way], [3: Following too closely], ... 38 more ...)
CAUSE_2 (type: esriFieldTypeInteger, alias: Secondary Cause, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Exceeding authorized speed limit], [2: Failing to yield right-of way], [3: Following too closely], ... 38 more ...)
HIT_RUN (type: esriFieldTypeInteger, alias: Is Hit and Run, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
PROP_DESC1 (type: esriFieldTypeString, alias: Property Description 1, SQL Type: sqlTypeOther, length: 102, nullable: true, editable: true)
PROP_DESC2 (type: esriFieldTypeString, alias: Property Description 2, SQL Type: sqlTypeOther, length: 102, nullable: true, editable: true)
WZ_TYPE (type: esriFieldTypeInteger, alias: Work Zone Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Blank (Crash in Designated Work Zone was "No")], [2: Construction], [3: Maintenance], ... 3 more ...)
WZ_WORKER (type: esriFieldTypeInteger, alias: Workers Present, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
WZ_RELATED (type: esriFieldTypeInteger, alias: Work Zone Related, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
Pedestrian (type: esriFieldTypeInteger, alias: Pedestrian, SQL Type: sqlTypeOther, nullable: true, editable: true)
Pedalcyclist (type: esriFieldTypeInteger, alias: Pedalcyclist, SQL Type: sqlTypeOther, nullable: true, editable: true)
Younger_Driver__16_20_ (type: esriFieldTypeInteger, alias: Younger_Driver__16_20_, SQL Type: sqlTypeOther, nullable: true, editable: true)
Older_Driver__65__ (type: esriFieldTypeInteger, alias: Older_Driver__65__, SQL Type: sqlTypeOther, nullable: true, editable: true)
Unrestrained_Occupants (type: esriFieldTypeInteger, alias: Unrestrained_Occupants, SQL Type: sqlTypeOther, nullable: true, editable: true)
Impaired_Driver (type: esriFieldTypeInteger, alias: Impaired_Driver, SQL Type: sqlTypeOther, nullable: true, editable: true)
Distracted_Fatigued_Drowsy_Driv (type: esriFieldTypeInteger, alias: Distracted_Fatigued_Drowsy_Driver, SQL Type: sqlTypeOther, nullable: true, editable: true)
Speeding_Aggressive_Driver (type: esriFieldTypeInteger, alias: Speeding_Aggressive_Driver, SQL Type: sqlTypeOther, nullable: true, editable: true)
Wrong_Way_Driving (type: esriFieldTypeInteger, alias: Wrong_Way_Driving, SQL Type: sqlTypeOther, nullable: true, editable: true)
Roadway_Departure (type: esriFieldTypeInteger, alias: Roadway_Departure, SQL Type: sqlTypeOther, nullable: true, editable: true)
Highway_Railroad_Grade_Crossing (type: esriFieldTypeInteger, alias: Highway_Railroad_Grade_Crossings, SQL Type: sqlTypeOther, nullable: true, editable: true)
Work_Zone (type: esriFieldTypeInteger, alias: Work_Zone, SQL Type: sqlTypeOther, nullable: true, editable: true)
Animal (type: esriFieldTypeInteger, alias: Animal, SQL Type: sqlTypeOther, nullable: true, editable: true)
Heavy_Vehicle (type: esriFieldTypeInteger, alias: Heavy_Vehicle, SQL Type: sqlTypeOther, nullable: true, editable: true)
Motorcycle (type: esriFieldTypeInteger, alias: Motorcycle, SQL Type: sqlTypeOther, nullable: true, editable: true)
Intersection_Related (type: esriFieldTypeInteger, alias: Intersection_Related, SQL Type: sqlTypeOther, nullable: true, editable: true)
EA_List (type: esriFieldTypeString, alias: EA_List, SQL Type: sqlTypeOther, length: 292, nullable: true, editable: true)
DATE (type: esriFieldTypeDate, alias: Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)

Templates:

Relationships:

Vehicle (0) -- Related To: Vehicle (5)
Person (1) -- Related To: Person (4)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Tables:

Person (4)

Name:

Display Field:

Type:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

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: 30, nullable: true, editable: true)
CID_UID_PID (type: esriFieldTypeString, alias: Crash ID - Vehicle ID - Person ID, SQL Type: sqlTypeOther, length: 34, nullable: true, editable: true)
PER_TYPE (type: esriFieldTypeInteger, alias: Person Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Driver], [2: Pedestrian], [3: Pedalcyclist], ... 6 more ...)
SEAT_POS (type: esriFieldTypeInteger, alias: Seating Position, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Driver], [2: Center front], [3: Passenger], ... 10 more ...)
INJ_SEV (type: esriFieldTypeInteger, alias: Injury Severity, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No indication of injury], [1: C-injury], [2: B-injury], ... 2 more ...)
AGE (type: esriFieldTypeInteger, alias: Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
SEX (type: esriFieldTypeString, alias: Sex, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
SAF_EQI (type: esriFieldTypeInteger, alias: Safety Equipment, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: None Used/Not Applicable], [2: Shoulder and Lap Belt Used], [3: Seat Belts Not Used], ... 17 more ...)
AIRBAG (type: esriFieldTypeInteger, alias: Airbag Deployment, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: With seat belt], [2: Without seat belt], [3: Not applicable], ... 7 more ...)
EJECT (type: esriFieldTypeInteger, alias: Ejection, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: None], [2: Totally ejected], ... 3 more ...)
DR_CON (type: esriFieldTypeInteger, alias: Driver Physical Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Normal], [2: Impaired-alcohol], [3: Impaired-drugs], ... 12 more ...)
DR_VISION (type: esriFieldTypeInteger, alias: Driver Vision, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Not obscured], [2: Windshield (water, ice)], [3: Trees, plants], ... 12 more ...)
PD_VISION (type: esriFieldTypeInteger, alias: Pedestrian Visibility, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: No contrasting clothing], [2: Contrasting clothing], [3: Reflective material], ... 3 more ...)
DR_ACTION (type: esriFieldTypeInteger, alias: Driver Action, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: None], [2: Failed to Yield], [3: Disregarded control devices], ... 18 more ...)
PD_ACTION (type: esriFieldTypeInteger, alias: Pedestrian Action, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: Turning left], [4: Turning right], [20: Enter from drive or alley], ... 21 more ...)
PD_LOC (type: esriFieldTypeInteger, alias: Pedestrian Location, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: In roadway], [2: In crosswalk], [3: Not in available crosswalk], ... 8 more ...)
DR_LIC_ST (type: esriFieldTypeString, alias: Driver License State, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
YEAR (type: esriFieldTypeInteger, alias: Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
WasDistracted (type: esriFieldTypeString, alias: Was Distracted, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
DistractionReason (type: esriFieldTypeString, alias: Distraction Reason, SQL Type: sqlTypeOther, length: 98, nullable: true, editable: true)
IsIncidentResponder (type: esriFieldTypeString, alias: Is Incident Responder, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
IncidentResponder (type: esriFieldTypeString, alias: Incident Responder, SQL Type: sqlTypeOther, length: 160, nullable: true, editable: true)
EjectionPath (type: esriFieldTypeString, alias: Ejection Path, SQL Type: sqlTypeOther, length: 102, nullable: true, editable: true)

Templates:

Relationships:

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

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Vehicle (5)

Name:

Display Field:

Type:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

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:

Relationships:

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

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date: