Name: Fatal and Serious Crashes

Display Field: CRASH_YEAR

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -8665207.646
YMin: 4471198.0231
XMax: -8604744.2385
YMax: 4516750.3244
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"CRASH_SEVERITY","uniqueValueGroups":[{"heading":"Crash_Severity","classes":[{"label":"A","description":"A","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,170,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"values":[["A"]]},{"label":"K","description":"K","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[230,0,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"values":[["K"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,170,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"A","label":"A"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[230,0,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"K","label":"K"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[204,216,252,255],"toColor":[204,216,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[238,252,179,255],"toColor":[238,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,184,255],"toColor":[252,179,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,251,255],"toColor":[252,182,251,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,246,255],"toColor":[179,252,246,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,228,202,255],"toColor":[252,228,202,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,182,252,255],"toColor":[182,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[197,252,207,255],"toColor":[197,252,207,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,207,234,255],"toColor":[252,207,234,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[243,252,210,255],"toColor":[243,252,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,212,213,255],"toColor":[252,212,213,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[215,252,232,255],"toColor":[215,252,232,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,234,252,255],"toColor":[179,234,252,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: true

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field: CRASH_SEVERITY

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ROADWAY_SURFACE_TYPE (type: esriFieldTypeString, alias: Roadway Surface Type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ROADWAY_ALIGNMENT (type: esriFieldTypeString, alias: Roadway Alignment, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• RELATION_TO_ROADWAY (type: esriFieldTypeString, alias: Relation To Roadway, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ROADWAY_SURFACE_COND (type: esriFieldTypeString, alias: Roadway Surface Condition, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• RD_TYPE (type: esriFieldTypeString, alias: RoadDeparture Type, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• VEH_COUNT (type: esriFieldTypeSmallInteger, alias: Vehicle Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LIGHT_CONDITION (type: esriFieldTypeString, alias: Light Condition, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [0: Not Provided], [1: Dawn], [2: Daylight], ... 5 more ...)
• CRASH_SEVERITY (type: esriFieldTypeString, alias: Crash_Severity, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• COLLISION_TYPE (type: esriFieldTypeString, alias: Collision Type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [1: Rear End], [2: Angle], [3: Head On], ... 14 more ...)
• WEATHER_CONDITION (type: esriFieldTypeString, alias: Weather Condition, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [0: Not Provided], [1: No Adverse Condition], [3: Fog], ... 8 more ...)
• NIGHT (type: esriFieldTypeString, alias: Night?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• SENIOR_NOTSENIOR (type: esriFieldTypeString, alias: Senior Driver?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• YOUNG_NOTYOUNG (type: esriFieldTypeString, alias: Young Driver?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• SPEED_NOTSPEED (type: esriFieldTypeString, alias: Speed?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• DRUG_NODRUG (type: esriFieldTypeString, alias: Drug Related?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• ALCOHOL_NOTALCOHOL (type: esriFieldTypeString, alias: Alcohol?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• ANIMAL (type: esriFieldTypeString, alias: Animal Related?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• BIKE_NONBIKE (type: esriFieldTypeString, alias: Bike?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• PED_NONPED (type: esriFieldTypeString, alias: Pedestrian?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• PEDESTRIANS_INJURED (type: esriFieldTypeSmallInteger, alias: Pedestrians Injured, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PEDESTRIANS_KILLED (type: esriFieldTypeSmallInteger, alias: Pedestrians Killed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERSONS_INJURED (type: esriFieldTypeSmallInteger, alias: Persons Injured, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C_PEOPLE (type: esriFieldTypeSmallInteger, alias: C_People, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B_PEOPLE (type: esriFieldTypeSmallInteger, alias: B_People, SQL Type: sqlTypeOther, nullable: true, editable: true)
• A_PEOPLE (type: esriFieldTypeSmallInteger, alias: A_People, SQL Type: sqlTypeOther, nullable: true, editable: true)
• K_PEOPLE (type: esriFieldTypeSmallInteger, alias: K_People, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CRASH_DT (type: esriFieldTypeDate, alias: Crash Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MEDIAN_WIDTHMIN (type: esriFieldTypeInteger, alias: Median_WidthMin, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MEDIAN_WIDTHMAX (type: esriFieldTypeInteger, alias: Median_WidthMax, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MEDIAN_RIGHTSHOULDERWIDTH (type: esriFieldTypeDouble, alias: Median_RightShoulderWidth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MEDIAN_TYPEDESC (type: esriFieldTypeSmallInteger, alias: MedianTypeDesc, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MEDIAN_TYPE (type: esriFieldTypeSmallInteger, alias: Median_Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LEFTSHOULDERWIDTH (type: esriFieldTypeDouble, alias: Leftshoulderwidth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RIGHTSHOULDERWIDTH (type: esriFieldTypeDouble, alias: Rightshoulderwidth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PAVEMENT_WIDTH (type: esriFieldTypeInteger, alias: Pavement_Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROADWAY_DEFECT (type: esriFieldTypeString, alias: Roadway Defect, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• PAVEMENT_ROUGHNESSVALUE (type: esriFieldTypeInteger, alias: Pavement_Roughnessvalue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROADWAY_DESCRIPTION (type: esriFieldTypeString, alias: Roadway Description, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• TRAFFIC_CONTROL_TYPE (type: esriFieldTypeString, alias: Traffic Control Type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ROUTE_OR_STREET_NM (type: esriFieldTypeString, alias: Route or Street Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• AREA_TYPE (type: esriFieldTypeString, alias: Area Type, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• SCHOOL_ZONE (type: esriFieldTypeString, alias: School Zone, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• MOTOR_NONMOTOR (type: esriFieldTypeString, alias: Motorcycle?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LGTRUCK_NONLGTRUCK (type: esriFieldTypeString, alias: Large Vehicle?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• HITRUN_NOT_HITRUN (type: esriFieldTypeString, alias: Hit & Run?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• GR_NOGR (type: esriFieldTypeString, alias: Guardrail Related?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• DROWSY_NOTDROWSY (type: esriFieldTypeString, alias: Drowsy?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• DISTRACTED_NOTDISTRACTED (type: esriFieldTypeString, alias: Distracted?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• BELTED_UNBELTED (type: esriFieldTypeString, alias: UnBelted?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• FIRST_HARMFUL_EVENT_LOC (type: esriFieldTypeString, alias: First Harmful Event Loc, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• FIRST_HARMFUL_EVENT (type: esriFieldTypeString, alias: First Harmful Event, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• WORK_ZONE_TYPE (type: esriFieldTypeString, alias: Work Zone Type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• WORK_ZONE_LOCATION (type: esriFieldTypeString, alias: Work Zone Location, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• WORK_ZONE_RELATED (type: esriFieldTypeString, alias: Work Zone Related, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• TRFC_CTRL_STATUS_TYPE (type: esriFieldTypeString, alias: Traffic Control Status, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• INTERSECTION_TYPE (type: esriFieldTypeString, alias: Intersection Type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• PAVEMENT_CONDITIONVALUE (type: esriFieldTypeDouble, alias: Pavement_Conditionvalue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MEDIAN_LEFTSHOULDERWIDTH (type: esriFieldTypeDouble, alias: Median_LeftShoulderWidth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NUMBEROFLANE (type: esriFieldTypeSmallInteger, alias: Numberoflane, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MOST_HARMFUL_CRASH_EVENT_CD (type: esriFieldTypeString, alias: Most_Harmful_Crash_Event_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• FOURTH_CRASH_EVENT_CD (type: esriFieldTypeString, alias: Fourth_Crash_Event_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• THIRD_CRASH_EVENT_CD (type: esriFieldTypeString, alias: Third_Crash_Event_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• SECOND_CRASH_EVENT_CD (type: esriFieldTypeString, alias: Second_Crash_Event_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• FIRST_CRASH_EVENT_CD (type: esriFieldTypeString, alias: First_Crash_Event_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• VEHICLE_MODEL_NM (type: esriFieldTypeString, alias: Vehicle_Model_Nm, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VEHICLE_MANEUVER_TYPE_CD (type: esriFieldTypeString, alias: Vehicle_Maneuver_Type_Cd, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CARSPEEDLIMIT (type: esriFieldTypeSmallInteger, alias: Carspeedlimit, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VEHICLE_BODY_TYPE_CD (type: esriFieldTypeString, alias: Vehicle_Body_Type_Cd, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VEHICLENUMBER (type: esriFieldTypeString, alias: Vehiclenumber, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DRIVER_VIS_OBSCURED_TYPE_CD (type: esriFieldTypeString, alias: Driver_Vis_Obscured_Type_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• INITIAL_VEH_IMPACT_AREA_CD (type: esriFieldTypeString, alias: Initial_Veh_Impact_Area_Cd, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• DRIVER_DRUG_USE_CD (type: esriFieldTypeString, alias: Driver_Drug_Use_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DRIVER_DISTRACTION_TYPE_CD (type: esriFieldTypeString, alias: Driver_Distraction_Type_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DRIVER_CONDITION_TYPE_CD (type: esriFieldTypeString, alias: Driver_Condition_Type_Cd, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DRIVER_ACTION_TYPE_CD (type: esriFieldTypeString, alias: Driver_Action_Type_Cd, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DRIVER_GENDER (type: esriFieldTypeString, alias: Driver_Gender, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DRIVER_AGE (type: esriFieldTypeString, alias: Driver_Age, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• DRIVER_INJURYTYPE (type: esriFieldTypeString, alias: Driver_InjuryType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DRIVER_VEHICLENUMBER (type: esriFieldTypeString, alias: Driver_VehicleNumber, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CRASH_YEAR (type: esriFieldTypeString, alias: Crash_Year, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• PASS_INJURYTYPE (type: esriFieldTypeString, alias: Pass_InjuryType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIDEWALKDESC (type: esriFieldTypeString, alias: Sidewalkdesc, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• GOVCONDESC (type: esriFieldTypeString, alias: Govcondesc, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• SURFACEDESC (type: esriFieldTypeSmallInteger, alias: Surfacedesc, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ACCESS_CONTROL (type: esriFieldTypeSmallInteger, alias: Access_Control, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PASS_VEHICLENUMBER (type: esriFieldTypeString, alias: Pass_vehiclenumber, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RURALURBANDESC (type: esriFieldTypeSmallInteger, alias: Ruralurbandesc, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CURBGUTTERDESC (type: esriFieldTypeSmallInteger, alias: Curbgutterdesc, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BASETYPEDESC (type: esriFieldTypeString, alias: Basetypedesc, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• PED_DRUG (type: esriFieldTypeString, alias: Ped_Drug, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PED_AL_TEST (type: esriFieldTypeString, alias: Ped_Al_Test, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TRUCKCOMMR (type: esriFieldTypeString, alias: Truckcommr, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• PED_DRINK (type: esriFieldTypeString, alias: Ped_Drink, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BIKE_VEHICLENUMBER (type: esriFieldTypeString, alias: Bike_VehicleNumber, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• BIKE_INJURYTYPE (type: esriFieldTypeString, alias: Bike_InjuryType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BIKE_AGE (type: esriFieldTypeString, alias: Bike_Age, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• BIKE_GENDER (type: esriFieldTypeString, alias: Bike_Gender, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PED_NUMBER (type: esriFieldTypeString, alias: Ped_Number, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PED_COND (type: esriFieldTypeString, alias: Ped_Cond, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PED_INJURYTYPE (type: esriFieldTypeString, alias: Ped_InjuryType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PED_GENDER (type: esriFieldTypeString, alias: Ped_Gender, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PED_ACTION (type: esriFieldTypeString, alias: Ped_Action, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PED_AGE (type: esriFieldTypeString, alias: PED_Age, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)

Types:

ID: A
Name: A
Domains:

• Field Name: LIGHT_CONDITION
  Inherited
  
• Field Name: COLLISION_TYPE
  Inherited
  
• Field Name: WEATHER_CONDITION
  Inherited
  
Templates:

Name: A
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• CRASH_SEVERITY: A

---

ID: K
Name: K
Domains:

• Field Name: LIGHT_CONDITION
  Inherited
  
• Field Name: COLLISION_TYPE
  Inherited
  
• Field Name: WEATHER_CONDITION
  Inherited
  
Templates:

Name: K
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• CRASH_SEVERITY: K

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/5/2024 6:40:47 PM

Schema Last Edit Date: 6/5/2024 6:40:47 PM

Data Last Edit Date: 6/5/2024 6:40:47 PM

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