Query Tool Changes and Improvements

October 2023

  • Added commercial motor vehicle queries to the Simple Queries tool

September 2023

  • 2022 licensed driver and VMT rates available on County Maps output

June 2023

  • Crash data from 2022 now available
  • Road Segment and Intersection selection updated to use Michigan Linear Referencing System (LRS) v22

February 2023

  • Added automation to View Crashes by Timeframe on the Crash Map
  • Added sections for other land transport vehicles and the Northern Lower Peninsula to the Simple Queries tool

January 2023

  • Added support for Tribal Region Geographic Location Selection
  • Added a section for distracted drivers to the Simple Queries tool

September 2022

  • Added Advanced Filtering with "OR group" selection available
  • Added View Crashes by Timeframe for Time of Day, Month, or Year to Crash Map output with option to enable range selection
  • Added Trend output with focused value selection

June 2022

  • Crash data from 2021 now available
  • New filter updates for Driver Aggressive, Vehicle Automation, Rural/Urban and Drug Test Results
  • Michigan Demographic Variable information available in Chart, Table and Crash Map Outputs
  • Road Segment and Intersection selection updated to use Michigan Linear Referencing System (LRS) v21

October 2021

  • 2020 VMT rates available on County Maps output

June 2021

  • Crash data from 2020 now available
  • Driver License Indicator, Driver License Type - Operator License, Driver License Type - Chauffeur License, and Driver License Type - Moped License filters are now available on the Data Query Tool
  • Road Segment and Intersection selection updated to use Michigan Linear Referencing System (LRS) v20
  • 2020 licensed driver rates available on County Maps output

May 2021

  • Added additional queries for Michigan State Police Districts and Posts to two new sections of the Simple Queries tool

December 2020

  • Added additional queries to multiple sections of the Simple Queries tool

November 2020

  • Added additional queries for Metropolitan Planning Organizations under a new section of the Simple Queries tool

September 2020

  • 2019 licensed driver and VMT rates available on County Maps output
  • Added additional queries under the Young Drivers and Senior Drivers sections of the Simple Queries tool

July 2020

  • Added sections for young drivers and senior drivers to the Simple Queries tool

June 2020

  • Crash data from 2019 now available
  • Mile Marker selection updated for improved accuracy

September 2019

  • 2018 VMT rates available on County Maps output
  • Added ability to embed a unique Query Tool output to a 3rd-party website; available for Table, Chart and Crash Map Outputs
  • Added support for shape borders of city, township and smaller regional geographic selections covering majority of the state

August 2019

  • Added quick link to jump to Crash Map marker from List output
  • Added series filter option to Bar Chart output (including views for Side by Side and Stacked)

July 2019

  • 2018 licensed driver rates available on County Maps output

May 2019

  • Crash data from 2018 now available

March 2019

  • Improved export options in Table output including new PDF export
  • Added image export option in County Map output
  • Added county borders on Crash Map output for county based queries

February 2019

  • Updated Crash Map output layout and enhanced dynamic heatmap grid
  • Crashes in Crash Map output can restrict map category markers to one or more selections
  • Added new Road Segment heatmap view in Crash Map output
  • Added additional queries under multiple sections of the Simple Queries tool

December 2018

  • Updated Intersection selection to use Framework roadways for improved accuracy
  • Improved Map Area selection tool - including new Circular Area selection
  • Improved accuracy of "Crashes Near Me"
  • Added visual aids in Crash Map output for queries using Intersection, Map Area, or "Crashes Near Me"
  • Added ability to search for specific locations in maps during selection for Intersection, Map Area, or Road Segments

October 2018

  • Added sections for commercial motor vehicles and the Upper Peninsula to the Simple Queries tool
  • Added additional queries under the Restraint Use section of the Simple Queries tool

August 2018

  • Added Geographic Location Sorting Output
  • 2017 licensed driver and VMT rates available on County Maps output

May 2018

  • Crash data from 2017 now available
  • Road Segment selection updated to Michigan Framework 17a

February 2018

  • Added County Maps output with support for licensed driver and VMT rates

January 2018

  • Added a section for non-motorists (pedestrians and bicyclists) to the Simple Queries tool

October 2017

  • Updated 2016 data to reconcile alcohol-involved and drug-involved crash counts
    (alcohol-involved crashes increased from 9,636 to 9,769; drug-involved crashes increased from 2,574 to 2,667) - More info
  • Highway Performance Monitoring System (HPMS) data is now displayed in the Map Output for segments where this data is available

August 2017

  • Added support for Mile Marker selection
  • Added Simple Queries for motorcycles

May 2017

  • Crash data from 2016 now available
  • Road Segment selection updated to Michigan Framework 16a

March 2017

  • Added support for Road Segment selection using Michigan Framework 15a
  • Added support for Map Area selection

January 2017

  • Added support for Michigan State Police Posts changed in 2016

September 2016

  • Added 1-way tabling
  • Corrected numbers outputted in Excel export
  • Tables remember their settings

August 2016

  • Improvements for mobile view in the Data Query Tool
  • Table improvements for adding and removing variables
  • List improvements for navigating output

July 2016

  • Added support for MDOT Regions changed in 2015
  • Publications links show for TSN

June 2016

  • Crash data from 2015 now available
  • Additional information added for filters that changed with 2015 data

May 2016

  • Added new feature: Crashes Near Me which uses user's GPS location if available

April 2016

  • Added support for Metropolitan Planning Organization Geographic Region

March 2016

  • Launch of new modern and mobile friendly MTCF Website with sections for Publications and the Data Query Tool