Skip to main content
MDT - Custom Filter Logic

This article summarizes the custom filters created for MDOT and the logic behind them.

Greg Olsen avatar
Written by Greg Olsen
Updated over a year ago

Roadway Departure

The Roadway Departure filter searches the Crash Table for the following criteria:

Collision Type = Fixed Object

OR

Collision Type = Roll Over

OR

Collision Type = Head On

OR

Collision Type = Side Swipe Opposite Direction Crashes


Non-Junction Roadway Departure

The Non-Junction Roadway Departure filter searches the Crash Table for the following criteria:

Collision Type = Fixed Object

OR

Collision Type = Roll Over

OR

Collision Type = Head On

OR

Collision Type = Side Swipe Opposite Direction Crashes

AND

First Harmful Event Relative to Junction ID = Intersection

OR

First Harmful Event Relation to Junction ID = Intersection Related

AND

Geonode ID = NULL


Train Collision

The Train Collision filter searches the Crash Table for the following criteria:

First Harmful Event Type = Railway Vehicle (Train Engine)

OR

Collision Type ID = Railway Vehicle

OR

First Harmful Event Detail = Railway Vehicle (Train Engine)

OR

Sequence of Events Details 1 = Railway Vehicle (Train Engine)

OR

Sequence of Events Details 2 = Railway Vehicle (Train Engine)

OR

Sequence of Events Details 3 = Railway Vehicle (Train Engine)

OR

Sequence of Events Details 4 = Railway Vehicle (Train Engine)


Railway Grade Crossing Related

The Railway Grade Crossing Related filter searches the Crash Table for the following criteria:

First Harmful Event Relation to Junction ID = Railway Grade Crossing

OR

Railway Crossing ID ≠ NULL

OR

Traffic Control Device Type = Railway Signal Lights

OR

Traffic Control Device Type = Railway Crossbucks Only

OR

Traffic Control Device Type = Railway Signal Lights and Gates


Site Study Request

The Site Study Request filter searches the Crash Table for the following criteria:

Site Study ID = Yes

OR

Roadway Site Record ≠ NULL


Work Zone Related

The Work Zone Related filter searches the Crash Table for the following criteria:

Work Zone Location Cras ID ≠ NULL

OR

Work Zone Worker is Present ID = Yes

OR

Work Zone Activity Type ID ≠ (SMS) None


Adverse Light Conditions

The Adverse Light Conditions Related filter searches the Crash Table for the following criteria:

Light Conditions = Dark-Not Lighted

OR

Light Conditions = Dark-Lighted

OR

Light Conditions = Dark-Unknown Lighting

OR

Light Conditions = Dawn

OR

Light Conditions = Dusk


Driver >= 65 (Fatal & Serious Injury Only)

The Driver >= 65 (Fatal & Serious Injury Only) filter searches the People Table for the following criteria:

Sitting Position Seat ID = Front Seat, Left or Cyclist

AND

Age ≥ 65

AND

Injury Severity ID = Fatal Injury

OR

Injury Severity ID = Suspected Serious Injury


Pedestrian >= 65 (Fatal & Serious Injury Only)

The Pedestrian >= 65 (Fatal & Serious Injury Only) filter searches the People Table for the following criteria:

Person Type Detection = Pedestrian

AND

Age ≥ 65

AND

Injury Severity ID = Fatal Injury

OR

Injury Severity ID = Suspected Serious Injury


Distracted Driver Related

The Distracted Driver Related filter searches the Crash Table for the following criteria:

Driver Distracted by ID ≠ Not Distracted

OR

Driver Action Crash One ID = Drove in Distracted, Inattentive or Careless Manner

OR

Driver Action Crash Two ID = Drove in Distracted, Inattentive or Careless Manner

OR

Driver Action Crash Three ID = Drove in Distracted, Inattentive or Careless Manner

OR

Driver Action Crash Four ID = Drove in Distracted, Inattentive or Careless Manner

OR

Impaired Driver = Yes


Pedestrian/Bicycle

The Pedestrian/Bicycle filter searches the Crash Table for the following criteria:

Collision Type ID = Pedestrian

OR

Collision Type ID = Bicycle


Wild Animal

The Wild Animal filter searches the Crash Table for the following criteria:

Collision Type ID = Wild Animal

OR

Contributing Circumstances (Environment) 1 = Animal(s) in Roadway

OR

Contributing Circumstances (Environment) 2 = Animal(s) in Roadway

OR

Contributing Circumstances (Environment) 3 = Animal(s) in Roadway

AND

Collision Type ID ≠ Domestic Animal

Did this answer your question?