Name: IMARSVehicle

Display Field: IMARS_Record_No

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)
• IMARS_Record_No (type: esriFieldTypeString, alias: IMARS_Record_No, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Crash_Date_Time (type: esriFieldTypeString, alias: Crash_Date_Time, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Vehicle_Number (type: esriFieldTypeDouble, alias: Vehicle_Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Number_of_Occupants (type: esriFieldTypeDouble, alias: Number_of_Occupants, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Vehicle_Towed (type: esriFieldTypeString, alias: Vehicle_Towed, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Insurance_verified (type: esriFieldTypeString, alias: Insurance_verified, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Initial_Impact_Point (type: esriFieldTypeString, alias: Initial_Impact_Point, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Most_Damaged_Area (type: esriFieldTypeString, alias: Most_Damaged_Area, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Extent_of_Damage (type: esriFieldTypeString, alias: Extent_of_Damage, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Direction_of_Travel_Prior_to_Cr (type: esriFieldTypeString, alias: Direction_of_Travel_Prior_to_Crash, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Posted_Speed (type: esriFieldTypeString, alias: Posted_Speed, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• First_Event_Type (type: esriFieldTypeString, alias: First_Event_Type, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• First_Event (type: esriFieldTypeString, alias: First_Event, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Second_Event_Type (type: esriFieldTypeString, alias: Second_Event_Type, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Second_Event (type: esriFieldTypeString, alias: Second_Event, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Third_Event_Type (type: esriFieldTypeString, alias: Third_Event_Type, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Third_Event (type: esriFieldTypeString, alias: Third_Event, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Fourth_Event_Type (type: esriFieldTypeString, alias: Fourth_Event_Type, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Fourth_Event (type: esriFieldTypeString, alias: Fourth_Event, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Motor_Vehicle_Unit_Type (type: esriFieldTypeString, alias: Motor_Vehicle_Unit_Type, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Vehicle_Owner (type: esriFieldTypeString, alias: Vehicle_Owner, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Vehicle_Type (type: esriFieldTypeString, alias: Vehicle_Type, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Non_Commercial_Trailer_Style (type: esriFieldTypeString, alias: Non_Commercial_Trailer_Style, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Emergency_Vehicle_Use (type: esriFieldTypeString, alias: Emergency_Vehicle_Use, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Emergency_Equipment_Activated (type: esriFieldTypeString, alias: Emergency_Equipment_Activated, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Special_Function_of_MV_in_Trans (type: esriFieldTypeString, alias: Special_Function_of_MV_in_Transport, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Motor_Vehicle_Contributing_Circ (type: esriFieldTypeString, alias: Motor_Vehicle_Contributing_Circumstance, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Vehicle_Maneuver_Action_Prior_t (type: esriFieldTypeString, alias: Vehicle_Maneuver_Action_Prior_to_Crash, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Road_Surface (type: esriFieldTypeString, alias: Road_Surface, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Grade (type: esriFieldTypeString, alias: Grade, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Roadway_Alignment (type: esriFieldTypeString, alias: Roadway_Alignment, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Total_Number_of_Lanes (type: esriFieldTypeDouble, alias: Total_Number_of_Lanes, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Traffic_Control (type: esriFieldTypeString, alias: Traffic_Control, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Traffic_Control_Working_Properl (type: esriFieldTypeString, alias: Traffic_Control_Working_Properly, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Roadway_Description (type: esriFieldTypeString, alias: Roadway_Description, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Commercial_Non_Commercial (type: esriFieldTypeString, alias: Commercial_Non_Commercial, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Number_of_Axles (type: esriFieldTypeString, alias: Number_of_Axles, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Gross_Vehicle_Weight (type: esriFieldTypeString, alias: Gross_Vehicle_Weight, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Combination_GVW (type: esriFieldTypeString, alias: Combination_GVW, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Commercial_Cargo_Body_Type (type: esriFieldTypeString, alias: Commercial_Cargo_Body_Type, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Commercial_Cargo (type: esriFieldTypeString, alias: Commercial_Cargo, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Commercial_MV_Configuration (type: esriFieldTypeString, alias: Commercial_MV_Configuration, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Identification_Number_Type (type: esriFieldTypeString, alias: Identification_Number_Type, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Hazmat_1_Class (type: esriFieldTypeString, alias: Hazmat_1_Class, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Hazmat_1_ID (type: esriFieldTypeString, alias: Hazmat_1_ID, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Hazmat_2_Class (type: esriFieldTypeString, alias: Hazmat_2_Class, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Hazmat_2_ID (type: esriFieldTypeString, alias: Hazmat_2_ID, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Hazmat_3_Class (type: esriFieldTypeString, alias: Hazmat_3_Class, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Hazmat_3_ID (type: esriFieldTypeString, alias: Hazmat_3_ID, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Hazmat_4_Class (type: esriFieldTypeString, alias: Hazmat_4_Class, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Hazmat_4_ID (type: esriFieldTypeString, alias: Hazmat_4_ID, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Park (type: esriFieldTypeString, alias: Park, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• CRASH_DATE (type: esriFieldTypeDate, alias: CRASH_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CRASH_TIME (type: esriFieldTypeInteger, alias: CRASH_TIME, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CRASH_YEAR (type: esriFieldTypeInteger, alias: CRASH_YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: IMARSVehicle
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• IMARSCrashDetailPnt (3) -- Related To: IMARSCrashDetailPnt (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/6/2022 7:00:15 PM

Schema Last Edit Date: 5/6/2022 7:00:15 PM

Data Last Edit Date: 5/6/2022 7:00:15 PM

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