Nebraska - Custom Filter Logic
Greg Olsen avatar
Written by Greg Olsen
Updated over a week ago

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

Did this answer your question?