Query Builder
View Map
View Table
View List
View Chart
Crash Reports
Save QueryHelpful Stuff
Codebook
The Michigan Traffic Crash Facts Codebook contains descriptions of the variables available for use with the Data Query Tool.
DQT Handbook
The Handbook is an easy-to-digest overview of the Data Query Tool's features.
Tutorials
These video tutorials will give you an in-depth view of all of the Data Query Tool's features.
Common Mistakes
Nobody's perfect, but at least you can learn from the mistakes of others!
The Michigan Traffic Crash Facts Codebook contains descriptions of the variables available for use with the Data Query Tool.
DQT Handbook
The Handbook is an easy-to-digest overview of the Data Query Tool's features.
Tutorials
These video tutorials will give you an in-depth view of all of the Data Query Tool's features.
Common Mistakes
Nobody's perfect, but at least you can learn from the mistakes of others!
Help Topics
2011 MSP Districts
In 2011, the Michigan State Police district borders were redrawn. You now h...
Bar Chart Configuration When you want to view a bar chart you are given the option of what
variabl...
Chart Options There are two charting options available.
Pie Chart
When you choose one v...
Choose Filters/Variables - 1 help linkThe filters or variables that are available for you to choose from vary dep...
Choose List Variables - 1 help linkBefore you are able to view a list of the results of your query, you must p...
Cluster Markers - 1 help link
As you zoom out on the map, crash markers will appear to be closer
and c...
Common Mistakes - 1 help link1. Applying a crash (or vehicle) level variable to people. There are many ...
Crash Markers - 1 help linkMap Marker Colors
When you view your result set on a map, they are display...
Datasets - 1 help linkIn the Dataset box, use the Year control to choose the year(s)
for which y...
Filter Level Doesn't Match Analysis Level If you have chosen a filter or variable that doesn\'t match the Analysis Le...
Filters - 1 help linkWhile constructing a query, you can limit your result set by choosing value...
Geographic Area - 1 help linkWhile constructing a query, you can limit your result set by picking a geog...
Google Local Search Results The local search on the map is powered by Google. Because of this, the retu...
Highway Number Variable The Highway Number variable is not always unique, for example \"94\" design...
Intersection Lookup The Query Builder allows you to select an intersection as the geographic lo...
Map Performance Issues - 1 help linkUsing this tool it is possible to create maps that contain hundreds
of tho...
Moving Around the Map - 1 help link
Map navigation controls are in the top-left corner of the map. To
pan ...
Pie Graph Configuration - 1 help linkWhen you want to view a chart you are given the option of what variable you...
Results List - 1 help linkIn the List View results list, white columns are crash-level variables, blu...
Save Query - 1 help linkThe query manager allows you to save queries that you find useful.
After b...
Street View Images and Coverage The images available in the Street View option on the map page are dependan...
Table Variables - 1 help linkIn the Analysis Variables box, use the Column Variable and
Row Variable co...
Temporary Variables - 1 help linkWhen you use a link from a \"View Table\" cell, the variable values that ar...
Viewing Crash Data - 1 help link
You can click on any crash marker to open an info bubble that
contains...