Name: Crashes
Display Field: SEVERITY
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:
XMin: 2774844.21198111
YMin: 310284.430270374
XMax: 2846857.9289114
YMax: 392177.714977875
Spatial Reference: 102720 (102720)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[107,158,53,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:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- INCIDENTID (type: esriFieldTypeDouble, alias: INCIDENTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CRASH_NO (type: esriFieldTypeDouble, alias: CRASH_NO, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SEVERITY (type: esriFieldTypeString, alias: Severity, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- DATE_TIME (type: esriFieldTypeDate, alias: DATE_TIME, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- DIAG_ORIG (type: esriFieldTypeInteger, alias: Diagram (Original), SQL Type: sqlTypeOther, nullable: true, editable: true)
- DIAG_BMI (type: esriFieldTypeString, alias: Diagram (BMI), SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
- DIAG_FLAG (type: esriFieldTypeSmallInteger, alias: Diagram Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
- FATAL_COUNT (type: esriFieldTypeSmallInteger, alias: Number of Fatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
- last_3_years (type: esriFieldTypeSmallInteger, alias: Crash in last 3 Years, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- last_5_years (type: esriFieldTypeSmallInteger, alias: Crash in last 5 Years, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- last_10_years (type: esriFieldTypeSmallInteger, alias: Crash in last 10 Years, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_fatal_or_serious_crash (type: esriFieldTypeSmallInteger, alias: Fatal or Serious, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_fatal_or_injury_crash (type: esriFieldTypeSmallInteger, alias: Fatal or Injury, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_fatal_crash (type: esriFieldTypeSmallInteger, alias: Fatal, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_serious_crash (type: esriFieldTypeSmallInteger, alias: Suspected Serious Injury, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_injury_crash (type: esriFieldTypeSmallInteger, alias: Injury Crashes, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_ped_bike_crash (type: esriFieldTypeSmallInteger, alias: Pedestrian/Bike, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_pedestrian_crash (type: esriFieldTypeSmallInteger, alias: Pedestrian, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_bike_crash (type: esriFieldTypeSmallInteger, alias: Bike, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_single_vehicle_runoff_crash (type: esriFieldTypeSmallInteger, alias: Single Vehicle Runoff, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_sideswipe_same_crash (type: esriFieldTypeSmallInteger, alias: Sideswipe Same Direction, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_rear_end_crash (type: esriFieldTypeSmallInteger, alias: Rear End, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_left_turn_crash (type: esriFieldTypeSmallInteger, alias: Left Turn, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_headon_crash (type: esriFieldTypeSmallInteger, alias: Headon/Sideswipe Opposing, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_teen_crash (type: esriFieldTypeSmallInteger, alias: Teen, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_older_crash (type: esriFieldTypeSmallInteger, alias: Older, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_workzone_crash (type: esriFieldTypeSmallInteger, alias: Workzone-Related, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_train_crash (type: esriFieldTypeSmallInteger, alias: Train, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_motorcycle_crash (type: esriFieldTypeSmallInteger, alias: Motorcycle, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_heavy_truck_crash (type: esriFieldTypeSmallInteger, alias: Heavy Vehicle-Involved, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_impaired_crash (type: esriFieldTypeSmallInteger, alias: Impaired Driver, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_aggressive_crash (type: esriFieldTypeSmallInteger, alias: Aggressive Driver, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_distracted_crash (type: esriFieldTypeSmallInteger, alias: Distracted Driver, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_speeding_crash (type: esriFieldTypeSmallInteger, alias: Speeding Driver, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_school_age_ped_bike_crash (type: esriFieldTypeSmallInteger, alias: School Age Ped/Bike, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_signalized_crash (type: esriFieldTypeSmallInteger, alias: Signalized, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_stopsign_crash (type: esriFieldTypeSmallInteger, alias: Stop-Controlled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_diag_other (type: esriFieldTypeSmallInteger, alias: Diagram Other, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- CRASHSEVERITY (type: esriFieldTypeDouble, alias: CRASHSEVERITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
- BASIC_TYPE (type: esriFieldTypeDouble, alias: BASIC TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AGEU1 (type: esriFieldTypeDouble, alias: AGEU1, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AGEU2 (type: esriFieldTypeDouble, alias: AGEU2, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AGEU3 (type: esriFieldTypeDouble, alias: AGEU3, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AGEU4 (type: esriFieldTypeDouble, alias: AGEU4, SQL Type: sqlTypeOther, nullable: true, editable: true)
- WORKZONETYPE (type: esriFieldTypeDouble, alias: WORKZONETYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- FIRSTHARMFULEVENT (type: esriFieldTypeDouble, alias: FIRSTHARMFULEVENT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- VEHICLETYPEU1 (type: esriFieldTypeDouble, alias: VEHICLETYPEU1, SQL Type: sqlTypeOther, nullable: true, editable: true)
- VEHICLETYPEU2 (type: esriFieldTypeDouble, alias: VEHICLETYPEU2, SQL Type: sqlTypeOther, nullable: true, editable: true)
- VEHICLETYPEU3 (type: esriFieldTypeDouble, alias: VEHICLETYPEU3, SQL Type: sqlTypeOther, nullable: true, editable: true)
- VEHICLETYPEU4 (type: esriFieldTypeDouble, alias: VEHICLETYPEU4, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PHYSICALCONDITIONU1 (type: esriFieldTypeDouble, alias: PHYSICALCONDITIONU1, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PHYSICALCONDITIONU2 (type: esriFieldTypeDouble, alias: PHYSICALCONDITIONU2, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PHYSICALCONDITIONU3 (type: esriFieldTypeDouble, alias: PHYSICALCONDITIONU3, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PHYSICALCONDITIONU4 (type: esriFieldTypeDouble, alias: PHYSICALCONDITIONU4, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CONTRIBFACTOR1U1 (type: esriFieldTypeDouble, alias: CONTRIBFACTOR1U1, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CONTRIBFACTOR1U2 (type: esriFieldTypeDouble, alias: CONTRIBFACTOR1U2, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CONTRIBFACTOR1U3 (type: esriFieldTypeDouble, alias: CONTRIBFACTOR1U3, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CONTRIBFACTOR1U4 (type: esriFieldTypeDouble, alias: CONTRIBFACTOR1U4, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CONTRIBFACTOR2U1 (type: esriFieldTypeDouble, alias: CONTRIBFACTOR2U1, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CONTRIBFACTOR2U2 (type: esriFieldTypeDouble, alias: CONTRIBFACTOR2U2, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CONTRIBFACTOR2U3 (type: esriFieldTypeDouble, alias: CONTRIBFACTOR2U3, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CONTRIBFACTOR2U4 (type: esriFieldTypeDouble, alias: CONTRIBFACTOR2U4, SQL Type: sqlTypeOther, nullable: true, editable: true)
- UNITTYPEU1 (type: esriFieldTypeDouble, alias: UNITTYPEU1, SQL Type: sqlTypeOther, nullable: true, editable: true)
- UNITTYPEU2 (type: esriFieldTypeDouble, alias: UNITTYPEU2, SQL Type: sqlTypeOther, nullable: true, editable: true)
- UNITTYPEU3 (type: esriFieldTypeDouble, alias: UNITTYPEU3, SQL Type: sqlTypeOther, nullable: true, editable: true)
- UNITTYPEU4 (type: esriFieldTypeDouble, alias: UNITTYPEU4, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TRAFFICCONTROLDEVICEU1 (type: esriFieldTypeDouble, alias: TRAFFICCONTROLDEVICEU1, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TRAFFICCONTROLDEVICEU2 (type: esriFieldTypeDouble, alias: TRAFFICCONTROLDEVICEU2, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TRAFFICCONTROLDEVICEU3 (type: esriFieldTypeDouble, alias: TRAFFICCONTROLDEVICEU3, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TRAFFICCONTROLDEVICEU4 (type: esriFieldTypeDouble, alias: TRAFFICCONTROLDEVICEU4, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CRASH_SEVERITY (type: esriFieldTypeDouble, alias: CRASH_SEVERITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
- FIRST_HARMFUL_EVNT (type: esriFieldTypeDouble, alias: FIRST_HARMFUL_EVNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MANNER_OF_COLL (type: esriFieldTypeInteger, alias: MANNER_OF_COLL, SQL Type: sqlTypeOther, nullable: true, editable: true)
- VEH_MOVEMENT_DESCR_V1 (type: esriFieldTypeString, alias: VEH_MOVEMENT_DESCR_V1, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
- VEH_MOVEMENT_DESCR_V2 (type: esriFieldTypeString, alias: VEH_MOVEMENT_DESCR_V2, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
- VEH_MOVEMENT_DESCR_V3 (type: esriFieldTypeString, alias: VEH_MOVEMENT_DESCR_V3, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
- OP_AGE_D1 (type: esriFieldTypeInteger, alias: OP_AGE_D1, SQL Type: sqlTypeOther, nullable: true, editable: true)
- OP_AGE_D2 (type: esriFieldTypeInteger, alias: OP_AGE_D2, SQL Type: sqlTypeOther, nullable: true, editable: true)
- OP_AGE_D3 (type: esriFieldTypeInteger, alias: OP_AGE_D3, SQL Type: sqlTypeOther, nullable: true, editable: true)
- WZR_TYPE_OF_ZONE_DESCR (type: esriFieldTypeString, alias: WZR_TYPE_OF_ZONE_DESCR, SQL Type: sqlTypeOther, length: 45, nullable: true, editable: true)
- UNIT_CONFIG_DESCR_V1 (type: esriFieldTypeString, alias: UNIT_CONFIG_DESCR_V1, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
- UNIT_CONFIG_DESCR_V2 (type: esriFieldTypeString, alias: UNIT_CONFIG_DESCR_V2, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
- UNIT_CONFIG_DESCR_V3 (type: esriFieldTypeString, alias: UNIT_CONFIG_DESCR_V3, SQL Type: sqlTypeOther, length: 33, nullable: true, editable: true)
- ALCOHOL_DRUG_DESCR_D1 (type: esriFieldTypeString, alias: ALCOHOL_DRUG_DESCR_D1, SQL Type: sqlTypeOther, length: 33, nullable: true, editable: true)
- ALCOHOL_DRUG_DESCR_D2 (type: esriFieldTypeString, alias: ALCOHOL_DRUG_DESCR_D2, SQL Type: sqlTypeOther, length: 33, nullable: true, editable: true)
- ALCOHOL_DRUG_DESCR_D3 (type: esriFieldTypeString, alias: ALCOHOL_DRUG_DESCR_D3, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- TRAFFIC_CONTROL_DESCR_V1 (type: esriFieldTypeString, alias: TRAFFIC_CONTROL_DESCR_V1, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
- TRAFFIC_CONTROL_DESCR_V2 (type: esriFieldTypeString, alias: TRAFFIC_CONTROL_DESCR_V2, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
- TRAFFIC_CONTROL_DESCR_V3 (type: esriFieldTypeString, alias: TRAFFIC_CONTROL_DESCR_V3, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
- is_angle_crash (type: esriFieldTypeSmallInteger, alias: Angle, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_single_vehicle_other_crash (type: esriFieldTypeSmallInteger, alias: Single Vehicle Other, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_inclement_road_crash (type: esriFieldTypeSmallInteger, alias: Inclement Road, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_inclement_weather_crash (type: esriFieldTypeSmallInteger, alias: Inclement Weather, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- is_single_vehicle_crash (type: esriFieldTypeSmallInteger, alias: Single Vehicle, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- RDWYSURFACE (type: esriFieldTypeDouble, alias: RDWYSURFACE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- WEATHERPRIMARY (type: esriFieldTypeDouble, alias: WEATHERPRIMARY, SQL Type: sqlTypeOther, nullable: true, editable: true)
- WEATHERSECONDARY (type: esriFieldTypeDouble, alias: WEATHERSECONDARY, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SURFACE_COND (type: esriFieldTypeInteger, alias: SURFACE_COND, SQL Type: sqlTypeOther, nullable: true, editable: true)
- WEATHER (type: esriFieldTypeInteger, alias: WEATHER, SQL Type: sqlTypeOther, nullable: true, editable: true)
- FunctionallyClassified (type: esriFieldTypeSmallInteger, alias: FunctionallyClassified, SQL Type: sqlTypeOther, nullable: true, editable: true)
Templates:
Name: GFEGF Crashes
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 2/5/2025 8:49:52 PM
Schema Last Edit Date: 2/5/2025 8:45:53 PM
Data Last Edit Date: 2/5/2025 8:49:52 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat