MSP - Crash Indicator Logic

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

G
Written by Gentry White
Updated over a week ago

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?