Skip to main content

MSP - Crash Indicator Logic

The article summarizes the custom filters for MSP and the associated logic.

Written by Greg Olsen

Aggressive Driving Involved

The Aggressive Driving Involved filter searches the Crash Table for the following criteria:

Party Type = D

AND

Hazardous Action = 1, 3, 4, 7, 8, 12, 15, or 16


Alcohol Involved

The Alcohol Involved filter searches the Crash Table for the following criteria:

Party Type = D, B, P, E

AND

Alcohol Suspected = Yes


Amish Involved

The Amish Involved filter searches the Crash Table for the following criteria:

Unit Type = P

AND

The Crash Narrative contains any of the following words: AMISH, BUGGY, BUGGIE, or

HORSE


Drug Involved

The Drug Involved filter searches the Crash Table for the following criteria:

Party Type = D, B, P, or E

AND

Drug Suspected = Yes


Bicycle Involved

The Bicycle Involved filter searches the Crash Table for the following criteria:

Unit Type = B


Motorcycle Involved

The Motorcycle Involved filter searches the Crash Table for the following criteria:

Vehicle Type = 5


Distracted Driving Involved

The Distracted Driving Involved filter searches the Crash Table for the following criteria:

Party Type = D

AND

Driver Distracted is between 2 and 8


Elderly Driver Involved

The Elderly Driver Involved filter searches the Crash Table for the following criteria:

Party Type = D

AND

Age > 59


Emergency Vehicle Involved

The Emergency Vehicle Involved filter searches the Crash Table for the following criteria:

Special Vehicle = 1, 2, or 4


Farm Equipment Involved

The Farm Equipment Involved filter searches the Crash Table for the following criteria:

Special Vehicle = 5


Intersection Involved

The Intersection Involved filter searches the Crash Table for the following criteria:

Roadway Area = 7, 8, 9, or 21


No Belts Involved

The No Belts Involved filter searches the Crash Table for the following criteria:

Party Type = D, B, P, or E

AND

Restraint Use = 5


ORV Involved

The ORV Involved filter searches the Crash Table for the following criteria:

Vehicle Type = 9


Pedestrian Involved

The Pedestrian Involved filter searches the Crash Table for the following criteria:

Unit Type = P


Q-Line Involved

The Q-Line Involved filter searches the Crash Table for the following criteria:

Unit Type = E

AND

The Crash Narrative contains any of the following words: Q-LINE, QLINE, or STEETCAR


Red Light Running Involved

The Red Line Running Involved filter searches the Crash Table for the following criteria:

Party Type = D, B, P, or E

AND

Hazardous Action = 4

AND

Roadway Area = 7, 8, 9, or 21

AND

Traffic Control = 1, 2, or 3


Snowmobile Involved

The Snowmobile Involved filter searches the Crash Table for the following criteria:

Vehicle Type = 8


Speeding Involved

The Speeding Involved filter searches the Crash Table for the following criteria:

Party Type = D

AND

Hazardous Action = 1


Train Involved

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

Unit Type = E


Truck/Bus Involved

The Truck/Bus Involved filter searches the Crash Table for the following criteria:

Vehicle Type = 11


Wrong Way Involved

The Wrong Way Involved filter searches the Crash Table for the following criteria:

Party Type = D

AND

Hazardous Action = 5


Young Driver Involved

The Young Driver Involved filter searches the Crash Table for the following criteria:

Party Type = D

AND

Age is between 15 and 24

Did this answer your question?