Query definitions for the SHSP Dashboard
Impaired Driving
- Persons with "Non-fatal injury - Incapacitating" or "Suspected Serious Injury (A)" injuries involved in a crash where one or more drivers has the "Alcohol Suspected" flag reported as "Yes".
Intersection Related
- Persons with "Non-fatal injury - Incapacitating" or "Suspected Serious Injury (A)" injuries involved in a crash where the Roadway Junction Type is reported to be "Four-way intersection", "T-intersection", "Y-intersection", or "Five-point or more".
Lane Departure
- Persons with "Non-fatal injury - Incapacitating" or "Suspected Serious Injury (A)" injuries involved in a crash where the first Sequence of Events for the crash is one of the following attributes: "Collision with curb", "Collision with tree", "Collision with utility pole", "Collision with light pole or other post/support", "Collision with guardrail", "Collision with highway traffic sign post", "Collision with fence", "Collision with mail box", "Collision with impact attenuator/crash cushion", "Collision with bridge", "Collision with other fixed object (wall, building, tunnel, etc.)", "Collision with unknown fixed object", "Ran off the road right", " Ran off the road left", or "Cross median/centerline".
Occupant Protection
- Persons with "Non-fatal injury - Incapacitating" or "Suspected Serious Injury (A)" injuries, and the "Person Type" field is either "Driver" or "Passenger", and the "Protective System Use" field is "No", and the "Vehicle Configuration" field for one or more of the vehicles involved in the crash includes "Passenger car" or "Light truck (van, mini-van, pick-up or sport utility)".
Speeding Related
- Persons with "Non-fatal injury - Incapacitating" or "Suspected Serious Injury (A)" injuries involved in a crash in which one or more of the drivers is reported with a "Driver Contributing Circumstance" of "Exceeded authorized speed limit".
Young Driver
- Persons with "Non-fatal injury - Incapacitating" or "Suspected Serious Injury (A)" injuries involved in a crash in which one or more of the drivers is between the ages of 15 and 20.
Older Driver
- Persons with "Non-fatal injury - Incapacitating" or "Suspected Serious Injury (A)" injuries involved in a crash in which one or more of the drivers is between the ages of 65 and 110.
Pedestrian
- Persons with "Non-fatal injury - Incapacitating" or "Suspected Serious Injury (A)" injuries involved in a crash where the Person Type is "Non-motorist" and the Non-motorist Type is "Pedestrian".
Bicycle
- Persons with "Non-fatal injury - Incapacitating" or "Suspected Serious Injury (A)" injuries involved in a crash where the Person Type is "Non-motorist" and the Non-motorist Type is "Cyclist".
Motorcycle
- Persons with "Non-fatal injury - Incapacitating" or "Suspected Serious Injury (A)" injuries involved in a crash in which the person was a rider or passenger on a Vehicle Configuration Code of "Motorcycle".
Truck Involved
- Persons with "Non-fatal injury - Incapacitating" or "Suspected Serious Injury (A)" injuries involved in a crash in which one or more of the vehicles has a Vehicle Configuration Code of "Bus (seats for 16 or more, including driver)", "Bus (seats for 9-15 people, including driver)", "Single-unit truck (2-axle, 6-tires)", "Single-unit truck (3-or-more axles)", "Truck/trailer", "Truck tractor (bobtail)", "Tractor/semi-trailer", "Tractor/doubles", "Tractor/triples", or "Unknown heavy truck, cannot classify"
Distracted Driving
- Persons with "Non-fatal injury - Incapacitating" or "Suspected Serious Injury (A)" injuries involved in a crash in which one or more of the drivers is reported with a "Driver Distracted Type" of "Manually operating an electronic device", "Talking on hands-free electronic device", "Talking on hand-held electronic device", "Other activity, electronic device", "Other activity (searching, eating, personal hygiene, etc.)", "Passenger", or "External distraction (outside the vehicle)".
Grade Crossing
- Persons with "Non-fatal injury - Incapacitating" or "Suspected Serious Injury (A)" injuries involved in a crash in which the Roadway Junction Type is "Railway grade crossing".
Work Zone
- Persons with "Non-fatal injury - Incapacitating" or "Suspected Serious Injury (A)" injuries involved in a crash in which the Work Zone Related flag is reported as "Yes".
Non-Motorist
- Persons with "Non-fatal injury - Incapacitating" or "Suspected Serious Injury (A)" injuries involved in a crash where the Person Type is "Non-motorist" and the Non-motorist Type is "Pedestrian", "Cyclist", "Skater", or "Other".
Query definitions for the Risk based Network Screening and Test of Proportions
Lane Departure
- Any crash resulting in which a vehicle’s first event in the "Vehicle Sequence of Events" field is one of the following attributes: "Collision with curb", "Collision with tree", "Collision with utility pole", "Collision with light pole or other post/support", "Collision with guardrail", "Collision with highway traffic sign post", "Collision with fence", "Collision with mail box", "Collision with impact attenuator/crash cushion", "Collision with bridge", "Collision with other fixed object (wall, building, tunnel, etc.)", "Collision with unknown fixed object", "Ran off the road right"," Ran off the road left", or "Cross median/centerline".
Older Driver
- Any crash involving a driver aged 65 or older based on the "Age of Driver – Oldest Known" field.
Truck Related
- Any crash involving a single-unit or larger truck or a bus, based on the "Vehicle Configuration" field and the attributes: "Bus (seats for 16 or more, including the driver)", "Bus (seats 9-15 people, including the driver)", "Single unit truck (2 axles, 6 tires)", "Single-unit truck (3-or-more axles)", "Truck/trailer", "Truck tractor (bobtail)", "Tractor/semi-trailer", "Tractor/doubles", "Tractor/triples", "Unknown heavy truck, cannot classify".
Intersection
- Any crash which occurs at a "Four-way intersection", "T-intersection", "Y-intersection", "Traffic circle", or "Five-point or more", based on the "Roadway Junction Type" field.
Younger Driver
- Any crash involving a driver aged 15 to 20 based on the "Age of Driver – Youngest Known" field.
Motorcycle
- Any crash involving a motorcycle based on the "Vehicle Configuration" field.
Pedestrian
- Any crash involving "Non-motorist" in the "Person Type" field and a "pedestrian" in the "Non-Motorist Type’ field.
Bicyclist
- Related Any crash involving a "Non-motorist" in the "Person Type" field and a "Cyclist" in the "Non-Motorist Type’ field.
Distracted Driving
- Any crash in which a "Driver" is reported in the "Person type" field and the "Driver Distracted Type" field includes one of the following attributes: "Manually operating an electronic device", "Talking on hands-free electronic device", "Talking on hand-held electronic device", "Other activity, electronic device", "Other activity (searching, eating, personal hygiene, etc.)", "Passenger", "External distraction (outside the vehicle)".
Impaired Driving
- Any crash in which a "Driver" is reported in the "Person type" and the "Alcohol Suspected" field equals "yes".
Occupant Protection
- Any crash in which "Person Type" field is either "Driver" or "Passenger" and the "Vehicle Configuration" field includes "passenger car" or "Light truck (van, mini-van, pick-up or sport utility) and "Protective System Use" field is "No".
Speeding
- Any crash in which a "Driver" is reported in the "Person type" field and the "Driver Contributing Circumstances" field reads "exceeding the speed limit".