Name: IMARS Crash No Locations

Display Field: Linked_Common_Name

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)
• Linked_Address_Classification (type: esriFieldTypeString, alias: Linked_Address_Classification, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Linked_Common_Name (type: esriFieldTypeString, alias: Linked_Common_Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• NEAR_Distance_to_MI (type: esriFieldTypeString, alias: NEAR_Distance_to_MI, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• NEAR_Direction_To (type: esriFieldTypeString, alias: NEAR_Direction_To, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• NEAR_Direction (type: esriFieldTypeString, alias: NEAR_Direction, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• NEAR_route_street_road_name (type: esriFieldTypeString, alias: NEAR_route_street_road_name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• NEAR_Road_Type (type: esriFieldTypeString, alias: NEAR_Road_Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AT_Intersection_route_street_ro (type: esriFieldTypeString, alias: AT_Intersection_route_street_road_DIRECTION, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• At_Intersecting_route_street_ro (type: esriFieldTypeString, alias: At_Intersecting_route_street_road_name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AT_Road_Type (type: esriFieldTypeString, alias: AT_Road_Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AT_Direction (type: esriFieldTypeString, alias: AT_Direction, 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)
• Road_Type_Classification (type: esriFieldTypeString, alias: Road_Type_Classification, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• index_right (type: esriFieldTypeString, alias: index_right, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Number_of_Vehicles_Involved (type: esriFieldTypeInteger, alias: Number_of_Vehicles_Involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Injury_or_Fatal_Crash (type: esriFieldTypeString, alias: Injury_or_Fatal_Crash, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Investigated_at_Scene (type: esriFieldTypeString, alias: Investigated_at_Scene, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Hit_and_Run (type: esriFieldTypeString, alias: Hit_and_Run, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Non_Motor_Vehicl_Property_Damag (type: esriFieldTypeString, alias: Non_Motor_Vehicl_Property_Damage, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Amount_of_Property_Damage (type: esriFieldTypeString, alias: Amount_of_Property_Damage, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• First_Harmful_Event_Type (type: esriFieldTypeString, alias: First_Harmful_Event_Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• First_Harmful_Event (type: esriFieldTypeString, alias: First_Harmful_Event, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Location_of_First_Harmful_Event (type: esriFieldTypeString, alias: Location_of_First_Harmful_Event, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Weather (type: esriFieldTypeString, alias: Weather, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Roadway_Condition (type: esriFieldTypeString, alias: Roadway_Condition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Lighting (type: esriFieldTypeString, alias: Lighting, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• School_Bus_related (type: esriFieldTypeString, alias: School_Bus_related, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AS_Road_Circumstance (type: esriFieldTypeString, alias: AS_Road_Circumstance, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Environmental_Contributing_Circ (type: esriFieldTypeString, alias: Environmental_Contributing_Circumstances, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Work_Zone_Related (type: esriFieldTypeString, alias: Work_Zone_Related, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Work_Zone_Workers_Present (type: esriFieldTypeString, alias: Work_Zone_Workers_Present, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Work_Zone_Location (type: esriFieldTypeString, alias: Work_Zone_Location, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Law_Enforcement_Present_at_Work (type: esriFieldTypeString, alias: Law_Enforcement_Present_at_Work_Zone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Relation_to_Junction (type: esriFieldTypeString, alias: Relation_to_Junction, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Type_of_Intersection (type: esriFieldTypeString, alias: Type_of_Intersection, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Manner_of_Collision (type: esriFieldTypeString, alias: Manner_of_Collision, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• INCID_NO (type: esriFieldTypeString, alias: INCID_NO, 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: IMARS Crash No Locations
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Relationships:

• IMARSPassenger (8) -- Related To: IMARS Passenger (7)
• IMARSVehicle (9) -- Related To: IMARS Vehicle (8)

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