Recent Filter Changes in the MTCF Query Tool are detailed below by year. For more information about how the data elements are collected on the UD-10 crash report, see the Michigan State Police UD-10 Manuals located on the Resources page. For questions regarding specific changes to the crash codes, please contact Criminal Justice Information Center, Traffic Crash Reporting Unit (CrashTCRS@michigan.gov).
Advanced Filtering AND/OR Help
Introduction
As of September 2022 the MTCF Data Query Tool supports Advanced filtering options. Previously every filter variable was by default added as an "AND" criteria, however now a variable can alternatively be added as an "OR" criteria. By allowing for OR criteria a query can be designed to include crashes that may have otherwise been removed from the crash count by additional filters.
Example
To illustrate the difference the following scenario is provided: determining fatal crashes where either drinking or drugs were involved. Basic filtering allows for the following options:
(Crash: Fatal Crash) and (Crash: Drinking Involved)
(Crash: Fatal Crash) and (Crash: Drugs Involved)
(Crash: Fatal Crash) and (Crash: Drinking Involved) and (Crash: Drugs Involved)
Each of the above queries will miss crashes where one but not both of drinking or drugs were involved. With Advanced filtering the query can be constructed in the following way:
(Crash: Fatal Crash) and [ (Crash: Drinking Involved) or (Crash: Drugs Involved) ]
This query will produce a higher crash count than with Basic filtering since it will account for crashes where either drinking or drugs is true.
Note in the above Advanced scenario that the drinking and drugs filters are grouped together. This is considered an "OR Group".
Constructing an Advanced Query
To construct an Advanced Query the following steps are required:
Navigate to the "Filters" section of the Query Editor in the Data Query Tool
Click "Clear All Filters" if any previous filters exist (Note: this step is recommended but not strictly necessary. More information below)
Click "Advanced Filtering"
- a Select dropdown will appear
From the Select dropdown, scroll to "Crash: Drinking"
- an inactive Filter selection box will appear (this box is identical to Basic filtering)
- two new buttons will appear: "+ OR" and "+ AND"
Click the "+ OR" button
- a new Select dropdown will appear
From the Select dropdown, scroll to "Crash: Drug Use"
- an inactive Filter selection box will appear
- the first "+ OR" button will become an "OR" indication
- an additional "+ OR" button will appear under the Filter selection box
Click the "+ AND" button
- a new Select dropdown will appear
- the first "+ AND" button will become an "AND" indication
From the Select dropdown, scroll to "Crash: Fatal Crash"
- an inactive Filter selection box will appear
- two new buttons will appear: "+ OR" and "+ AND"
Select the respective filter values of interest: "Drinking Involved", "Drugs Involved", "Fatal Crash (may also be injuries)"
Either select "Apply Filter" individually for each filter or navigate to the top and click "Apply All Selected Filters".
The above will complete the example query using the Advanced functionality. Scroll to the top of the Query Editor and the "Current Query" description should reflect the language of the query layout.
If an "OR" or "AND" button has a "+" sign that indicates an action will be created to add an additional OR or AND filter respectively.
Filter Selection Layout: "OR Groups"
Filters that use the OR operation with other filters are considered an OR Group. Note that a single filter is also considered an OR Group. In Advanced filtering a green box will appear around each OR Group. In between each filter in an OR Group a green OR indication is provided to assist with visualizing the layout of the query.
OR Groups are intended to be "And-ed" with each other. In between OR Groups a white AND indication is provided. The Query Editor Current Query language will show OR Groups using square brackets ex: "[ Drinking or Drugs ]".
There is no limit to the number of OR Groups or how many filters can be added to an OR Group, HOWEVER every Query Tool filter can only be used once whether as an OR condition or an AND condition.
Switching Filter Modes
With Basic filtering all filters can be added quickly from the multi-selection since every filter will be an AND operation. Similarly every query constructed in Basic filtering can automatically be converted to Advanced filtering. Each filter will become its own OR Group with AND indications between them.
However with Advanced filtering multiple filters in an OR Group cannot be automatically converted to AND criteria, hence filter selection will be reset.
When using the 'Advanced Filter' option. It is recommended to start with no filters selected or only with filters that are not intended to be used in an OR Group. This is intended to avoid confusion.
If the Query Tool was in Advanced filtering mode and the query was constructed without any OR filters, then upon return to the Query Editor the Filter selection will default to Basic filtering. If however OR filters were selected, Advanced filtering will be the default. The same behavior will be applied when using Share Query.
2021 Changes
Driver Aggressive – This filter has been newly generated for all years of crash data based on Hazardous Action codes. These codes include: “speed too fast,” “failed to yield,” “disregard traffic control,” “improper passing,” “improper lane use,” “unable to stop in assured clear distance,” “reckless driving,” and “careless/negligent driving.”
Automation System Present in Vehicle (2021+) – This filter is new for 2021 data and indicates whether any automation system is present. All counts for years prior to 2021 have been coded to “Uncoded & errors.” This filter is based on what is reported by the police officer at the time of the crash.
Automation System Level in Vehicle (2021+) – This filter is new for 2021 data and indicates the highest level of automation the vehicle is equipped with (0-5). All counts for years prior to 2021 have been coded to “Uncoded & errors.” This filter is based on what is reported by the police officer at the time of the crash.
Automation System Level Engaged at Time of Crash (2021+) – This filter is new for 2021 data and indicates the highest level of automation that was active or engaged by the vehicle at the time of the crash (0-5). All counts for years prior to 2021 have been coded to “Uncoded & errors.” This filter is based on what is reported by the police officer at the time of the crash.
Person Race (2021+) – This filter is new for 2021 data. All counts for years prior to 2021 have been coded to “Uncoded & errors.” This filter is based on what is reported by the police officer at the time of the crash and is not based on driver’s license data.
Rural/Urban (2016+) – This filter is new for 2016 data beginning with the 2021 data release and was generated using Census tract data. All counts for years prior to 2016 have been coded to “Uncoded & errors.” More information about the new rural/urban filter is located on the MTCF Demographic Variables help page.
Test Result – Cannabinoid (2021+) – This filter is new for 2021 data and indicates whether or not a positive cannabinoid test result was reported. All counts for years prior to 2021 have been coded to “Uncoded & errors.” This filter is derived from any cannabinoid test results from Test Result – Drug, Test Result – Drug 2, or Test Result – Drug 3.
Test Result – Drug 1 (2021+) – This filter is new for 2021 data and indicates the first drug test result reported. All counts for years prior to 2021 have been coded to “Uncoded & errors.”
Test Result – Drug 2 (2021+) – This filter is new for 2021 data and indicates the second drug test result reported if multiple drugs are present. All counts for years prior to 2021 have been coded to “Uncoded & errors.”
Test Result – Drug 3 (2021+) – This filter is new for 2021 data and indicates the third drug test result reported if multiple drugs are present. All counts for years prior to 2021 have been coded to “Uncoded & errors.”
2016 Changes
CDL Restriction 28 (2004-2015) – This filter is no longer active starting with 2016 data and all counts have been coded to “Uncoded & errors.” “CDL Restriction” and “Non-truck, no data” will display counts of 0 when selected.
CDL Restriction 29 (2004-2015) – See CDL Restriction 28 (2004-2015).
CDL Restriction 30 (2004-2015) – See CDL Restriction 28 (2004-2015).
CDL Restriction 35 (2004-2015) – See CDL Restriction 28 (2004-2015).
CDL Restriction 36 (2004-2015) – See CDL Restriction 28 (2004-2015).
Commercial Motor Vehicle Configuration (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.”
Complaint Status (2004-2015) – This filter is no longer active starting with 2016 data and all counts have been coded to “Uncoded & errors.” “Open” and “Closed” will display counts of 0 when selected.
Construction Activity (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.”
Construction Crash Location (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.”
Construction Lane Closed (2004-2015) – This filter is no longer active starting with 2016 data and all counts have been coded to “Uncoded & errors.” “Lane open” and “Lane closed” will display counts of 0 when selected.
Construction Workers Present (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.”
Contributing Circumstances 1 (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.”
Contributing Circumstances 2 (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.”
Crash: Animal Type Involved/Associated (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.”
Crash: Driver Distracted (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.”
Drivable After Crash (2004-2015) – This filter is no longer active starting with 2016 data and all counts have been coded to “Uncoded & errors.” “Not drivable after crash” and “Drivable after crash” will display counts of 0 when selected.
Driver Airbag Deployed (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.” See Driver Airbag Deployed for driver airbag data for all years with less airbag deployment detail.
Driver Condition Emotional (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.”
Driver Condition Fatigue (2004-2015) – This filter is no longer active starting with 2016 data and all counts have been coded to “Uncoded & errors.” “No, driver was not fatigued” and “Yes, driver was fatigued” will display counts of 0 when selected. See Driver Condition Fatigued or Asleep (2016+) for driver fatigue data starting in 2016.
Driver Condition Fatigued or Asleep (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.” See Driver Condition Fatigue (2004-2015) or Driver Condition Asleep (2004-2014) for driver fatigue or driver asleep data prior to 2016.
Driver Condition Other (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.”
Driver Condition Physically Disabled (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.”
Driver Contributing Factor – Alcohol Use (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.”
Driver Contributing Factor – Drug Use (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.”
Driver Distraction (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.” See Driver Condition Distracted (2004-2014) for driver distraction data prior to 2016.
Driver Restraint (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.” See Driver Restraint for driver restraint data for all years with less child restraint detail.
Field Sobriety Test – Drug (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.”
Gross Vehicle Weight Rating Code – This filter is new starting with 2016 data. All counts for years prior to 2016 have also been added.
Inter/Intra State (2004-2015) – This filter is no longer active starting with 2016 data and all counts have been coded to “Uncoded & errors.” “Interstate only,” “Intrastate,” and “Non-truck, no data” will display counts of 0 when selected.
Person Airbag Deployed (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.” See Person Airbag Deployed for driver airbag data for all years with less airbag deployment detail.
Person Restraint (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.” See Person Restraint for driver restraint data for all years with less child restraint detail.
Refusal Information – Drug (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.”
Source of Carrier Information (2004-2015) – This filter is no longer active starting with 2016 data and all counts have been coded to “Uncoded & errors.”
Test Offered – Drug (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.”
Test Result Pending – Alcohol (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.”
Test Result Pending – Drug (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.”
Total Non-Motor Vehicles (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.”
Weather Conditions (2004-2015) – This filter is no longer active starting with 2016 data and all counts have been coded to “Uncoded & errors.” See Weather Conditions (2016+) for weather condition data starting with 2016 data.
Weather Conditions (2016+) – This filter is new for 2016 data. All counts for years prior to 2016 have been coded to “Uncoded & errors.” See Weather Conditions (2004-2015) for weather condition data prior to 2016 data.
2015 Changes
Construction Activity (2004-2014) – “On road” and “Off road” are no longer active filters and will display counts of 0 when selected.
Driver Condition Alcohol (2004-2014) – This filter is no longer active and all counts have been coded to “Uncoded & errors.” “No, driver was not drinking” and “Yes, driver was drinking” will display counts of 0 when selected.
Driver Condition Asleep (2004-2014) – This filter is no longer active and all counts have been coded to “Uncoded & errors.” “No, driver was not asleep” and “Yes, driver was asleep” will display counts of 0 when selected. See Driver Condition Fatigued or Asleep (2016+) for driver asleep data starting in 2016.
Driver Condition Cell Phone (2004-2014) – This filter is no longer active and all counts have been coded to “Uncoded & errors.” “No, driver was not using a cell phone” and “Yes, driver was using a cell phone” will display counts of 0 when selected.
Driver Condition Distracted (2004-2014) – This filter is no longer active and all counts have been coded to “Uncoded & errors.” “No, driver was not distracted” and “Yes, driver was distracted” will display counts of 0 when selected. See Driver Distraction (2016+) for driver distraction data beginning in 2016.
Driver Condition Drugs (2004-2014) – This filter is no longer active and all counts have been coded to “Uncoded & errors.” “No, driver was not using illegal drugs” and “Yes, driver was using illegal drugs” will display counts of 0 when selected.
Extent of Damage (2004-2014) – There are now two separate filters for extent of damage. The prior extent of damage filter is no longer active and all 2015 counts have been coded to “Uncoded & errors.” See Extent of Damage (2015+) for extent of damage data starting with 2015 data.
Extent of Damage (2015+) – This filter has a condensed scale from the previous seven levels in Extent of Damage (2004-2014) to the current four levels. Prior to 2015 data, all counts of the new filter will display values of 0 except for “Uncoded & errors.”
Most Harmful Event – “Collision With Fixed Object - Bridge parapet end” is no longer active and will display a count of 0 when selected. “Collision With Fixed Object - Utility pole” has been combined with “Collision With Fixed Object - Luminaire / light support” starting with 2015 data and will display a count of 0 when selected.
Sequence of Events 1 – See Most Harmful Event.
Sequence of Events 2 – See Most Harmful Event.
Sequence of Events 3 – See Most Harmful Event.
Sequence of Events 4 – See Most Harmful Event.