Roadway Departure
Still in Progress: Need to Verify Full List and Code Descriptions:
The Roadway Departure filter searches the Crash Table for the following criteria:
First Harmful Event = Overturn/Rollover
OR
First Harmful Event = Impact Attenuator/Crash Cushion
OR
First Harmful Event = Bridge Overhead Structure
OR
First Harmful Event = Bridge Pier or Support
OR
First Harmful Event = Bridge Rail
OR
First Harmful Event = Guardrail Face
OR
First Harmful Event = Guardrail End Terminal
OR
First Harmful Event = Concrete Traffic Barrier
OR
First Harmful Event = Traffic Sign Support
OR
First Harmful Event = Other Post, Pole or Support
OR
First Harmful Event = Utility Pole/Light Support
OR
First Harmful Event = Other Post, Pole or Support
OR
First Harmful Event = Culvert
OR
First Harmful Event = Curb
OR
First Harmful Event = Ditch
OR
First Harmful Event = Embankment
OR
First Harmful Event = Fence
OR
First Harmful Event = Mailbox
OR
First Harmful Event = Tree (standing)
OR
First Harmful Event = Other Fixed Object (wall, building, tunnel, etc.)
OR
First Harmful Event = Work Zone/Maintenance Equipment
OR
First Harmful Event = Unknown Fixed Object
OR
Manner of Collision = Front-To-Front
OR
Manner of Collison = Sideswipe Opposite
Intersection Related
The Intersection Related filter searches the Crash Table for the following criteria:
Specific Junction Location = Acceleration/Deceleration Lane
OR
Specific Junction Location = Crossover-Related
OR
Specific Junction Location = Driveway Access or Related
OR
Specific Junction Location = Entrance/Exit Ramp or Related
OR
Specific Junction Location = Intersection or Related
OR
Specific Junction Location = Other Location
OR
Within Interchange Area = Yes
Young Driver
The Young Driver filter searches the Person Table for the following criteria:
Age < 21
AND
Occupant Type = Driver
Older Driver
The Older Driver filter searches the Person Table for the following criteria:
Age >= 65
AND
Occupant Type = Driver
Impaired Driving
The Impaired Driving filter searches the Crash Table for the following criteria:
Alcohol Involved = Y
OR
Drug Involved = Y
Seat Belt Usage
The Seat Belt Usage filter searches the Person Table for the following criteria:
Restraint Use = Booster Seat
OR
Restraint Use = Child Restraint System - Forward Facing
OR
Restraint Use = Child Restraint System - Rear Facing
OR
Restraint Use = Child Restraint System - Type Unknown
OR
Restraint Use = Lap Belt Only Used
OR
Restraint Use = Restraint Used - Type Unknown
OR
Restraint Use = Shoulder & Lap Belt Used
OR
Restraint Use = Shoulder Belt Only Used
Rural Urban Designation
The Rural Urban Designation filter searches the Crash Table for the following criteria:
Rural Designation
RRL_URB_CDE = 1
Urban Designation
RRL_URB_CDE = 2, 3, or 4
Crash Time Category
The Crash Time Category filter searches the Crash Table for the following criteria:
Midnight to 02:59
When Time of Crash is Between 12:00 AM and 2:59 AM
03:00 to 05:59
When Time of Crash Is Between 3:00 AM and 5:59 AM
06:00 to 08:59
When Time of Crash is Between 6:00 AM and 8:59 AM
09:00 to 11:59
When Time of Crash is Between 9:00 AM and 11:59 AM
12:00 to 14:59
When Time of Crash is Between 12:00 PM and 2:59 PM
15:00 to 17:59
When Time of Crash is Between 3:00 PM and 5:59 PM
18:00 to 20:59
When Time of Crash is Between 6:00 PM and 8:59 PM
21:00 to 23:59
When Time of Crash is Between 9:00 PM and 11:59 PM
Railroad Involvement
The Railroad Involvement filter searches the Crash Table for the following criteria:
Specific Location = Rail Grade Crossing
OR
Most Harmful Event = Railway Vehicle (train, engine)
OR
First Harmful Event = Railway Vehicle (train, engine)
OR
Sequence of Events = Railway Vehicle (train, engine)
Pedestrian or Cyclist Involvement
The Pedestrian Or Cyclist Involvement filter searches the Person Table for the following criteria:
Person Type = Bicyclist
OR
Person Type = Other Cyclist
OR
Person Type = Pedestrian
OR
Person Type = Other Pedestrian (wheelchair, person in a building, parked vehicle, skater, personal conveyance, etc.)
PM-1 Non-Motorist Performance Measure
The PM-1 Non-Motorist Performance Measure filter searches the Person Table for the following criteria:
Person Type = Bicyclist
OR
Person Type = Other Cyclist
OR
Person Type = Pedestrian
OR
Person Type = Other Pedestrian (wheelchair, person in a building, parked vehicle, skater, personal conveyance, etc.)
OR
Person Type = Occupant of a Non-Motor Vehicle Transportation Device
OR
Person Type = Unknown Type of Non-Motorist
AND
Injury Status = Fatal Injury
OR
Injury Status = Suspected Serious Injury
Within Municipal Limits
The Within Municipal Limits filter searches the Crash Table for the following criteria:
City Name โ NULL
Sequence of Events
The Sewuence of Events filter combines the following fields, displayed as an array:
First Event, Second Event, Third Event, Fourth Event
Crash Type
The Crash Type filter searches the First Harmful Event for the following criteria:
Angle
Manner of Collision = Angle
Front-to-Rear
Manner of Collision = Front-to-Rear
Sideswipe Same
Manner of Collision = Sideswipe-Same Direction
Sideswipe Opposite
Manner of Collision = Sideswipe-Opposite Direction
Front-to-Front
Manner of Collision = Front-to-Front
Other Multi-Vehicle
Manner of Collision = Other, Not Stated, Unknown, Rear-to-Rear, Rear-to-Side
Collision with Train
Manner of Collision = Not a Collision Between Two Motor Vehicles
AND
First Harmful Event = Rail Vehicle (train, engine)
Collision with Pedestrian
Manner of Collision = Not a Collision Between Two Motor Vehicles
AND
First Harmful Event = Pedestrian
Collision with Bicycle
Manner of Collision = Not a Collision Between Two Motor Vehicles
AND
First Harmful Event = Pedalcycle
Collision with Animal
Manner of Collision = Not a Collision Between Two Motor Vehicles
AND
First Harmful Event = Animal (live)
Collision with Parked Vehicle
Manner of Collision = Not a Collision Between Two Motor Vehicles
AND
First Harmful Event = Parked Motor Vehicle
Collision with Fixed Object
Manner of Collision = Not a Collision Between Two Motor Vehicles
AND
First Harmful Event = Bridge Overhead Structure, Bridge Pier Or Support, Bridge Rail, Cable Barrier, Concrete Traffic Barrier, Culvert, Curb, Ditch, Embankment, Fence, Guardrail End Terminal, Guardrail Face, Impact Attentuator/Crash Cushion, Mailbox, Other Fixed Object (Wall, Building, Tunnel, etc), Other Post Pole or Support, Other Traffic Barrier, Traffic Sign Support, Tree (Standing), Utility Pole/Light Support, Unknown Fixed Object
Overturn
Manner of Collision = Not a Collision Between Two Motor Vehicles
AND
First Harmful Event = Overturn/Rollover
Other Single Vehicle
Manner of Collision = Not a Collision Between Two Motor Vehicles
AND
First Harmful Event Not = Rail Vehicle (train, engine), Pedestrian, Pedalcycle, Animal (live), Parked Motor Vehicle, Not a Collision Between Two Motor Vehicles
AND
First Harmful Event = Bridge Overhead Structure, Bridge Pier Or Support, Bridge Rail, Cable Barrier, Concrete Traffic Barrier, Culvert, Curb, Ditch, Embankment, Fence, Guardrail End Terminal, Guardrail Face, Impact Attentuator/Crash Cushion, Mailbox, Other Fixed Object (Wall, Building, Tunnel, etc), Other Post Pole or Support, Other Traffic Barrier, Traffic Sign Support, Tree (Standing), Utility Pole/Light Support, Unknown Fixed Object, Overturn/Rollover
Societal Collision Cost Type
The Societal Collision Cost Type filter searches the First Harmful Event for the following criteria:
Urban Angle
Within Municipal Limits = Y
AND
Crash Type = Angle
Urban Front-to-Rear
Within Municipal Limits = Y
AND
Crash Type = Front-to-Rear
Urban Sideswipe Same
Within Municipal Limits = Y
AND
Crash Type = Sideswipe Same
Urban Sideswipe Opposite
Within Municipal Limits = Y
AND
Crash Type = Sideswipe Opposite
Urban Front-to-Front
Within Municipal Limits = Y
AND
Crash Type = Front-to-Front
Urban Other Multi-Vehicle
Within Municipal Limits = Y
AND
Crash Type = Other Multi-Vehicle
Rural Angle
Within Municipal Limits = Y
AND
Crash Type = Angle
Rural Front-to-Rear
Within Municipal Limits = Y
AND
Crash Type = Front-to-Rear
Rural Sideswipe Same
Within Municipal Limits = Y
AND
Crash Type = Sideswipe Same
Rural Sideswipe Opposite
Within Municipal Limits = Y
AND
Crash Type = Sideswipe Opposite
Rural Front-to-Front
Within Municipal Limits = Y
AND
Crash Type = Front-to-Front
Rural Other Multi-Vehicle
Within Municipal Limits = Y
AND
Crash Type = Other Multi-Vehicle
Urban Collision with Train
Within Municipal Limits = Y
AND
Crash Type = Angle
Urban Collision with Pedestrian
Within Municipal Limits = Y
AND
Crash Type = Collision With Pedestrian
Urban Collision with Bicycle
Within Municipal Limits = Y
AND
Crash Type = Collision With Bicycle
Urban Collision with Animal
Within Municipal Limits = Y
AND
Crash Type = Collision With Animal
Urban Collision with Parked Vehicle
Within Municipal Limits = Y
AND
Crash Type = Collision With Parked Vehicle
Urban Collision with Fixed Object
Within Municipal Limits = Y
AND
Crash Type = Collision With Fixed Object
Urban Overturn
Within Municipal Limits = Y
AND
Crash Type = Overturn
Urban Other Single Vehicle
Within Municipal Limits = Y
AND
Crash Type = Other Single Vehicle
Rural Collision with Train
Within Municipal Limits = N
AND
Crash Type = Angle
Rural Collision with Pedestrian
Within Municipal Limits = N
AND
Crash Type = Collision With Pedestrian
Rural Collision with Bicycle
Within Municipal Limits = N
AND
Crash Type = Collision With Bicycle
Rural Collision with Animal
Within Municipal Limits = N
AND
Crash Type = Collision With Animal
Rural Collision with Parked Vehicle
Within Municipal Limits = N
AND
Crash Type = Collision With Parked Vehicle
Rural Collision with Fixed Object
Within Municipal Limits = N
AND
Crash Type = Collision With Fixed Object
Rural Overturn
Within Municipal Limits = N
AND
Crash Type = Overturn
Rural Other Single Vehicle
Within Municipal Limits = N
AND
Crash Type = Other Single Vehicle