Name: CrashData_Details

Display Field: DOCUMENT_NBR

Type: Table

Has Views: true

Source Schema Changes Allowed: true

Views

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)
• DOCUMENT_NBR (type: esriFieldTypeInteger, alias: Document_Nbr, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CRASH_YEAR (type: esriFieldTypeString, alias: Crash_Year, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• CRASH_SEVERITY (type: esriFieldTypeString, alias: Crash_Severity, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [A: A. Severe Injury], [B: B. Visible Injury], [C: C. Nonvisible Injury], ... 2 more ...)
• DRIVER_VEHICLENUMBER (type: esriFieldTypeString, alias: Driver_VehicleNumber, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DRIVER_INJURYTYPE (type: esriFieldTypeString, alias: Driver_InjuryType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DRIVER_AGE (type: esriFieldTypeString, alias: Driver_Age, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• DRIVER_GENDER (type: esriFieldTypeString, alias: Driver_Gender, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DRIVER_ACTION_TYPE_CD (type: esriFieldTypeString, alias: Driver_Action_Type_Cd, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DRIVER_AIRBAG_DEPLOYMENT (type: esriFieldTypeString, alias: Driver_Airbag_Deployment, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DRIVER_ALCOHOL_TEST_TYPE_CD (type: esriFieldTypeString, alias: Driver_Alcohol_Test_Type_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DRIVER_CONDITION_TYPE_CD (type: esriFieldTypeString, alias: Driver_Condition_Type_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DRIVER_DISTRACTION_TYPE_CD (type: esriFieldTypeString, alias: Driver_Distraction_Type_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DRIVER_DRINKING_TYPE_CD (type: esriFieldTypeString, alias: Driver_Drinking_Type_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DRIVER_DRUG_USE_CD (type: esriFieldTypeString, alias: Driver_Drug_Use_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DRIVER_EJECTED_FROM_VEHICLE (type: esriFieldTypeString, alias: Driver_Ejected_From_Vehicle, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DRIVER_EMS_TRANSPORT_IND (type: esriFieldTypeString, alias: Driver_Ems_Transport_Ind, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DRIVER_FLED_SCENE_IND (type: esriFieldTypeString, alias: Driver_Fled_Scene_Ind, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DRIVER_SAFETY_EQUIP_USED (type: esriFieldTypeString, alias: Driver_Safety_Equip_Used, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DRIVER_VIS_OBSCURED_TYPE_CD (type: esriFieldTypeString, alias: Driver_Vis_Obscured_Type_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SUMMONS_ISSUED_CD (type: esriFieldTypeString, alias: Summons_Issued_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• VEHICLENUMBER (type: esriFieldTypeString, alias: Vehiclenumber, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VEHICLE_BODY_TYPE_CD (type: esriFieldTypeString, alias: Vehicle_Body_Type_Cd, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VEHICLE_MAKE_NM (type: esriFieldTypeString, alias: Vehicle_Make_Nm, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VEHICLE_MANEUVER_TYPE_CD (type: esriFieldTypeString, alias: Vehicle_Maneuver_Type_Cd, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VEHICLE_MODEL_NM (type: esriFieldTypeString, alias: Vehicle_Model_Nm, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VEHICLE_YEAR_NBR (type: esriFieldTypeString, alias: Vehicle_Year_Nbr, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• COMM_CARGO_BODY_TYPE_CD (type: esriFieldTypeString, alias: Comm_Cargo_Body_Type_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• COMM_VEHICLE_BODY_TYPE_CD (type: esriFieldTypeString, alias: Comm_Vehicle_Body_Type_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SPEED_BEFORE (type: esriFieldTypeString, alias: Speed_Before, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPEED_POSTED (type: esriFieldTypeString, alias: Speed_Posted, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPEED_MAX_SAFE (type: esriFieldTypeString, alias: Speed_Max_Safe, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FIRST_CRASH_EVENT_CD (type: esriFieldTypeString, alias: First_Crash_Event_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SECOND_CRASH_EVENT_CD (type: esriFieldTypeString, alias: Second_Crash_Event_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• THIRD_CRASH_EVENT_CD (type: esriFieldTypeString, alias: Third_Crash_Event_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• FOURTH_CRASH_EVENT_CD (type: esriFieldTypeString, alias: Fourth_Crash_Event_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MOST_HARMFUL_CRASH_EVENT_CD (type: esriFieldTypeString, alias: Most_Harmful_Crash_Event_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• INITIAL_VEH_IMPACT_AREA_CD (type: esriFieldTypeString, alias: Initial_Veh_Impact_Area_Cd, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• DIRECTION_OF_TRAVEL_CD (type: esriFieldTypeString, alias: Direction_Of_Travel_Cd, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PASS_VEHICLENUMBER (type: esriFieldTypeString, alias: Pass_vehiclenumber, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PASS_INJURYTYPE (type: esriFieldTypeString, alias: Pass_InjuryType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PASS_AGE (type: esriFieldTypeString, alias: Pass_age, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PASS_GENDER (type: esriFieldTypeString, alias: Pass_gender, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PASS_SAFETY_EQUIP_USED (type: esriFieldTypeString, alias: Pass_Safety_Equip_Used, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• PASS_AIRBAG_DEPLOYMENT (type: esriFieldTypeString, alias: Pass_Airbag_Deployment, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• PASS_EJECTED_FROM_VEHICLE (type: esriFieldTypeString, alias: Pass_Ejected_From_Vehicle, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• PASS_EMS_TRANSPORT_IND (type: esriFieldTypeString, alias: Pass_Ems_Transport_Ind, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• BIKE_VEHICLENUMBER (type: esriFieldTypeString, alias: Bike_VehicleNumber, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• BIKE_INJURYTYPE (type: esriFieldTypeString, alias: Bike_InjuryType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BIKE_AGE (type: esriFieldTypeString, alias: Bike_Age, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• BIKE_GENDER (type: esriFieldTypeString, alias: Bike_Gender, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PED_NUMBER (type: esriFieldTypeString, alias: Ped_Number, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PED_INJURYTYPE (type: esriFieldTypeString, alias: Ped_InjuryType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PED_AGE (type: esriFieldTypeString, alias: PED_Age, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PED_GENDER (type: esriFieldTypeString, alias: Ped_Gender, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PED_ACTION (type: esriFieldTypeString, alias: Ped_Action, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PED_DRINK (type: esriFieldTypeString, alias: Ped_Drink, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PED_COND (type: esriFieldTypeString, alias: Ped_Cond, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PED_AL_TEST (type: esriFieldTypeString, alias: Ped_Al_Test, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PED_DRUG (type: esriFieldTypeString, alias: Ped_Drug, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PED_RFLCT (type: esriFieldTypeString, alias: Ped_Rflct, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LOCAL_CASE_CD (type: esriFieldTypeString, alias: Local Case CD, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• ROUTE_OR_STREET_NM (type: esriFieldTypeString, alias: Route or Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: CrashData_Details
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/20/2026 4:47:45 PM

Schema Last Edit Date: 1/20/2026 4:47:45 PM

Data Last Edit Date: 1/20/2026 4:47:45 PM

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