Layer: Main Crashes 2019 2023 (ID:2)

View In: Map Viewer

Name: Main Crashes 2019 2023

Display Field: agency_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[113,62,142,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: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)
collision_id (type: esriFieldTypeString, alias: collision_id, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
agency_name (type: esriFieldTypeString, alias: agency_name, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
col_date (type: esriFieldTypeString, alias: col_date, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
col_year (type: esriFieldTypeInteger, alias: col_year, SQL Type: sqlTypeOther, nullable: true, editable: true)
col_day_of_week (type: esriFieldTypeString, alias: col_day_of_week, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
primary_road (type: esriFieldTypeString, alias: primary_road, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
num_lanes (type: esriFieldTypeString, alias: num_lanes, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
owned_by (type: esriFieldTypeString, alias: owned_by, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
intersecting_road (type: esriFieldTypeString, alias: intersecting_road, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
intersection_name (type: esriFieldTypeString, alias: intersection_name, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
county (type: esriFieldTypeString, alias: county, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
city (type: esriFieldTypeString, alias: city, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
crash_severity (type: esriFieldTypeString, alias: crash_severity, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
crash_severity_long (type: esriFieldTypeString, alias: crash_severity_long, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
fsi_flag (type: esriFieldTypeString, alias: fsi_flag, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
num_fatalities (type: esriFieldTypeString, alias: num_fatalities, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
num_serious_injuries (type: esriFieldTypeString, alias: num_serious_injuries, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
num_visible_injuries (type: esriFieldTypeString, alias: num_visible_injuries, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
num_complaint_injuries (type: esriFieldTypeString, alias: num_complaint_injuries, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
num_injuries (type: esriFieldTypeString, alias: num_injuries, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
num_non_motorized_fatalities (type: esriFieldTypeString, alias: num_non_motorized_fatalities, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
num_non_motorized_serious_injur (type: esriFieldTypeString, alias: num_non_motorized_serious_injuries, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
num_pedestrians (type: esriFieldTypeString, alias: num_pedestrians, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
num_vehicles (type: esriFieldTypeString, alias: num_vehicles, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
manner_collision (type: esriFieldTypeString, alias: manner_collision, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
location_at_impact (type: esriFieldTypeString, alias: location_at_impact, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
lighting_condition (type: esriFieldTypeString, alias: lighting_condition, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
weather_condition (type: esriFieldTypeString, alias: weather_condition, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
road_condition (type: esriFieldTypeString, alias: road_condition, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
unit1_safety_equip (type: esriFieldTypeString, alias: unit1_safety_equip, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
unit2_safety_equip (type: esriFieldTypeString, alias: unit2_safety_equip, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
veh1_type (type: esriFieldTypeString, alias: veh1_type, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
veh2_type (type: esriFieldTypeString, alias: veh2_type, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
veh1_direction (type: esriFieldTypeString, alias: veh1_direction, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
veh2_direction (type: esriFieldTypeString, alias: veh2_direction, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
veh1_maneuver (type: esriFieldTypeString, alias: veh1_maneuver, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
veh2_maneuver (type: esriFieldTypeString, alias: veh2_maneuver, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
unit1_first_harmful_event (type: esriFieldTypeString, alias: unit1_first_harmful_event, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
unit2_first_harmful_event (type: esriFieldTypeString, alias: unit2_first_harmful_event, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
driver1_contrib_factor (type: esriFieldTypeString, alias: driver1_contrib_factor, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
driver2_contrib_factor (type: esriFieldTypeString, alias: driver2_contrib_factor, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
unit1_road_contrib_factor (type: esriFieldTypeString, alias: unit1_road_contrib_factor, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
unit2_road_contrib_factor (type: esriFieldTypeString, alias: unit2_road_contrib_factor, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
aggressive_driving (type: esriFieldTypeSmallInteger, alias: aggressive_driving, SQL Type: sqlTypeOther, nullable: true, editable: true)
distracted_driving (type: esriFieldTypeSmallInteger, alias: distracted_driving, SQL Type: sqlTypeOther, nullable: true, editable: true)
impaired_driving (type: esriFieldTypeSmallInteger, alias: impaired_driving, SQL Type: sqlTypeOther, nullable: true, editable: true)
driver1_condition (type: esriFieldTypeString, alias: driver1_condition, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
driver2_condition (type: esriFieldTypeString, alias: driver2_condition, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
speed_related (type: esriFieldTypeSmallInteger, alias: speed_related, SQL Type: sqlTypeOther, nullable: true, editable: true)
hit_and_run (type: esriFieldTypeSmallInteger, alias: hit_and_run, SQL Type: sqlTypeOther, nullable: true, editable: true)
roadway_departure (type: esriFieldTypeSmallInteger, alias: roadway_departure, SQL Type: sqlTypeOther, nullable: true, editable: true)
holiday_period (type: esriFieldTypeString, alias: holiday_period, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
large_truck_related (type: esriFieldTypeSmallInteger, alias: large_truck_related, SQL Type: sqlTypeOther, nullable: true, editable: true)
motorcycle_related (type: esriFieldTypeSmallInteger, alias: motorcycle_related, SQL Type: sqlTypeOther, nullable: true, editable: true)
bicycle_related (type: esriFieldTypeSmallInteger, alias: bicycle_related, SQL Type: sqlTypeOther, nullable: true, editable: true)
pedestrian_related (type: esriFieldTypeSmallInteger, alias: pedestrian_related, SQL Type: sqlTypeOther, nullable: true, editable: true)
left_vs_straight (type: esriFieldTypeSmallInteger, alias: left_vs_straight, SQL Type: sqlTypeOther, nullable: true, editable: true)
elem_school_quarter_mi (type: esriFieldTypeString, alias: elem_school_quarter_mi, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
elem_school_1mi (type: esriFieldTypeString, alias: elem_school_1mi, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
mid_school_quarter_mi (type: esriFieldTypeString, alias: mid_school_quarter_mi, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
mid_school_1mi (type: esriFieldTypeString, alias: mid_school_1mi, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
hi_school_quarter_mi (type: esriFieldTypeString, alias: hi_school_quarter_mi, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
hi_school_1mi (type: esriFieldTypeString, alias: hi_school_1mi, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
school_level_quarter_mi (type: esriFieldTypeString, alias: school_level_quarter_mi, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
school_level_1mi (type: esriFieldTypeString, alias: school_level_1mi, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
signalized_intersection (type: esriFieldTypeSmallInteger, alias: signalized_intersection, SQL Type: sqlTypeOther, nullable: true, editable: true)
unit1_lrsp_emphasis_area (type: esriFieldTypeString, alias: unit1_lrsp_emphasis_area, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
unit2_lrsp_emphasis_area (type: esriFieldTypeString, alias: unit2_lrsp_emphasis_area, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
unit1_gdot_emphasis_area (type: esriFieldTypeString, alias: unit1_gdot_emphasis_area, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
unit2_gdot_emphasis_area (type: esriFieldTypeString, alias: unit2_gdot_emphasis_area, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
countermeasure (type: esriFieldTypeString, alias: countermeasure, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
signed_bike_route (type: esriFieldTypeSmallInteger, alias: signed_bike_route, SQL Type: sqlTypeOther, nullable: true, editable: true)
freight_corridor (type: esriFieldTypeSmallInteger, alias: freight_corridor, SQL Type: sqlTypeOther, nullable: true, editable: true)
bus_route (type: esriFieldTypeSmallInteger, alias: bus_route, SQL Type: sqlTypeOther, nullable: true, editable: true)
transit_system (type: esriFieldTypeString, alias: transit_system, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
route_type (type: esriFieldTypeString, alias: route_type, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
crash_mode (type: esriFieldTypeString, alias: crash_mode, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
crash_location (type: esriFieldTypeString, alias: crash_location, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
ksi_flag (type: esriFieldTypeSmallInteger, alias: ksi_flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
class (type: esriFieldTypeString, alias: class, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
speedlimit (type: esriFieldTypeString, alias: speedlimit, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
speedlimit_min (type: esriFieldTypeInteger, alias: speedlimit_min, SQL Type: sqlTypeOther, nullable: true, editable: true)
speedlimit_max (type: esriFieldTypeInteger, alias: speedlimit_max, SQL Type: sqlTypeOther, nullable: true, editable: true)
int_control (type: esriFieldTypeString, alias: int_control, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
transit_500_ft (type: esriFieldTypeSmallInteger, alias: transit_500_ft, SQL Type: sqlTypeOther, nullable: true, editable: true)
parks_500_ft (type: esriFieldTypeSmallInteger, alias: parks_500_ft, SQL Type: sqlTypeOther, nullable: true, editable: true)
col_month (type: esriFieldTypeString, alias: col_month, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
hour (type: esriFieldTypeInteger, alias: hour, SQL Type: sqlTypeOther, nullable: true, editable: true)
hour_bin (type: esriFieldTypeString, alias: hour_bin, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
aadt (type: esriFieldTypeInteger, alias: aadt, SQL Type: sqlTypeOther, nullable: true, editable: true)
aadt_source (type: esriFieldTypeString, alias: aadt_source, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
aadt_bin (type: esriFieldTypeString, alias: aadt_bin, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
owned_by_tdg (type: esriFieldTypeString, alias: owned_by_tdg, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
ksi_counts (type: esriFieldTypeInteger, alias: ksi_counts, SQL Type: sqlTypeOther, nullable: true, editable: true)
num_lanes_min (type: esriFieldTypeInteger, alias: num_lanes_min, SQL Type: sqlTypeOther, nullable: true, editable: true)
num_lanes_max (type: esriFieldTypeInteger, alias: num_lanes_max, SQL Type: sqlTypeOther, nullable: true, editable: true)
rd_ownership_tdg (type: esriFieldTypeString, alias: rd_ownership_tdg, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
crash_dynamic (type: esriFieldTypeString, alias: crash_dynamic, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
col_time (type: esriFieldTypeString, alias: col_time, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
narrative (type: esriFieldTypeString, alias: narrative, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
landuse (type: esriFieldTypeString, alias: landuse, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/19/2025 1:22:41 PM

Schema Last Edit Date: 8/19/2025 1:22:41 PM

Data Last Edit Date: 8/19/2025 1:22:41 PM

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