Name: IMARS Passenger

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: 8000, nullable: true, editable: true)
• Crash_Date_Time (type: esriFieldTypeString, alias: Crash_Date_Time, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Driver_Action (type: esriFieldTypeString, alias: Driver_Action, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Driver_Condition (type: esriFieldTypeString, alias: Driver_Condition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Driver_Distraction (type: esriFieldTypeString, alias: Driver_Distraction, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Suspect_Alcohol (type: esriFieldTypeString, alias: Suspect_Alcohol, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Alcohol_Test (type: esriFieldTypeString, alias: Alcohol_Test, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Alcohol_Test_Result_1 (type: esriFieldTypeString, alias: Alcohol_Test_Result_1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Alcohol_Test_Result_2 (type: esriFieldTypeString, alias: Alcohol_Test_Result_2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Suspect_Drugs (type: esriFieldTypeString, alias: Suspect_Drugs, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Drug_Test (type: esriFieldTypeString, alias: Drug_Test, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Violations_Issued (type: esriFieldTypeString, alias: Violations_Issued, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Seat_Position (type: esriFieldTypeString, alias: Seat_Position, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Injury_Severity (type: esriFieldTypeString, alias: Injury_Severity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Air_Bag_Deployed (type: esriFieldTypeString, alias: Air_Bag_Deployed, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Ejection (type: esriFieldTypeString, alias: Ejection, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Injury_Transported_By (type: esriFieldTypeString, alias: Injury_Transported_By, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Safety_Equipment_Used (type: esriFieldTypeString, alias: Safety_Equipment_Used, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Vehicle_number (type: esriFieldTypeString, alias: Vehicle_number, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Injured_transported_by (type: esriFieldTypeString, alias: Injured_transported_by, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Non_motorist_safety_equipment (type: esriFieldTypeString, alias: Non_motorist_safety_equipment, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Non_motorist_action_circumstanc (type: esriFieldTypeString, alias: Non_motorist_action_circumstance_prior_to_crash, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Non_motorist_action_circumsta_1 (type: esriFieldTypeString, alias: Non_motorist_action_circumstance_at_time_of_crash, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Non_motorist_condition_at_time_ (type: esriFieldTypeString, alias: Non_motorist_condition_at_time_of_crash, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Non_motorist_distraction (type: esriFieldTypeString, alias: Non_motorist_distraction, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Non_motorist_location_at_time_o (type: esriFieldTypeString, alias: Non_motorist_location_at_time_of_crash, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Pedestrian_Type (type: esriFieldTypeString, alias: Pedestrian_Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Pedestrian_Type_Detail (type: esriFieldTypeString, alias: Pedestrian_Type_Detail, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Involvement (type: esriFieldTypeString, alias: Involvement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• NUM_OCC (type: esriFieldTypeInteger, alias: NUM_OCC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INCID_NO (type: esriFieldTypeString, alias: INCID_NO, SQL Type: sqlTypeOther, length: 8000, 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: 8000, 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: IMARSPassenger
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Relationships:

• IMARSCrashPnts (4) -- Related To: IMARS Crash Locations (2)
• IMARSOutOfBounds (6) -- Related To: IMARS Locations Outside Boundary (3)
• IMARSCrashAndCrashDetailNoPnt (8) -- Related To: IMARS Crash No Locations (9)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/12/2022 6:32:48 PM

Schema Last Edit Date: 9/12/2022 6:32:48 PM

Data Last Edit Date: 9/12/2022 6:32:48 PM

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