Skip to main content

MDT - Custom Filter Logic

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

Written by Greg Olsen

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?