The Crash Query application allows users to run custom crash queries and displays the results in real time. Users can view the results of their queries using a GIS map interface, tables, custom graphs and charts, or downloadable CSV and PDF reports. The Crash Query application is broken into 8 sections: Date Extents, Map, Advanced Search Bar, Crash Flyout, Metrics, Chart Builder, Raw Table, and Reports Download. Each of these sections will be discussed in more detail below.

The map section of Crash Query displays the currently filtered data in either a satellite, or map overlay. The map view will display the crashes in either a heat map, or a map point view. By default the map will display a heat map which provides a more complete summary of crash density, with the more crash-dense areas displayed in dark blue.

(The heat map view of the Crash Query map displaying all pedestrian involved crashes for a given county.)

Crash query will automatically switch from the heat map view, to the cluster view, and a satellite map, when the map zooms in, allowing greater detail in specific crash locations. In cluster view, crashes occupying the same geolocation are grouped into crash clusters, and color coded according to the most severe crash in the cluster. The number on the cluster indicates the number of crashes contained in the cluster. Clicking on a cluster will zoom the map to that location, and breakout all crashes contained in the cluster.

(A heat map view of the Crash Query map, zoomed in to reveal crash clusters.)

Additionally, users can hide all of the crashes on a map using the Hide Crashes button, located at the top of the screen, next to the total number of crashes being displayed. This can be useful when configuring a query, or zooming in on a map to a specific location.

(The Show/Hide crash icon, with all crashes hidden)

The Line Tool allows Crash Query users to select a section of a roadway by selecting the road on a map, and defining the beginning/ending boundaries of the desired section. Read more about the Line Tool here.

(The line tool being used to select a route)

Users can scroll, zoom, and rotate the map to see the data they are interested in. As search terms are entered into the advanced search bar, the map updates in real time to reflect the current search criteria. Users can also filter the map using our polygon and circle filters to define geo boundaries on the map. Users can use these tools to exclude the selected area from the Crash Query.

(The Outside Circle filter option displaying all crashes outside the selected area.)

(A custom geo boundary filter applied to the map using the polygon tool; users can select Inside or Outside to choose which areas to filter.)

Users can use the Map Search tool to find a specific location on the map. Click the Map Search icon (the magnifying glass), then enter the address, or name of the city, county, street, business, or any other location into the search box, and the results will be displayed below.

(The Map Search displaying the results for the given location)

Select your desired location from the list, and the map will zoom to that location with a pin placed on the specific location. Note that this will only zoom the map to the desired location, no filters are applied based on the map search results.

(The map zoomed to the Utah state Capitol, with a pin placed on the location)

Users can use the Measure Tool to measure distances on the map. Click the Measure Tool icon, then click points on the map. The measure tool will measure the distance on the map between the points (Note: you can measure different shapes by clicking on the map to add more measurement points). The total distance will be displayed at the top of the map in both Feet and Miles.

(A stretch of road, measuring 6,301.8 ft, or 1.194 miles)

When zoomed into a location on the map, users can use the Filter to View button to set a filter around the area of the map currently displayed.

Additionally, when zoomed in or out, users can use the Zoom to Extents button to return the map to display the current filter area (zooming in or out).

Users can also use the Download Map button to download an image file of the current map display.

In the Map Settings, users can customize various map settings, including visualizations, zoom controls, and layers.

Users can manually toggle between the heat map, and a map point views if desired by clicking on the gear icon located under the map zoom controls. In the map point view, each crash is represented by a dot on a map, color coded according to severity. There is no grouping or clustering of crashes in the map point view. These settings will be saved, and will be applied to all map interfaces each time the user logs in.

(The map settings view of a given county. Note that the map has been changed to display dots rather than the heatmap)

Under the zoom controls, users can toggle the auto-zoom, and switch to satellite setting. When enabled, Auto-zoom will automatically zoom the map in or out to match the extents of the available data. This can help users zoom to a specific location, or view a given subset of the crash data. When disabled, the user will have manual control over all map zooming.

When enabled, the Switch to Sattelite feature will automatically toggle the map view to a satellite view when zoomed in close on the map. Inversely, the map will automatically toggle to a map view when zoomed out.

The Layer Settings allow users to toggle on or off various layers on the map, including boundaries (cities, counties, districts, etc.), as well as asset layers (if available for your agency).

(A crash map with all county boundaries displayed in green.)

Clicking on the Layers icon on the side of the map allows users to display any available layer on the map and customize the display properties of the layer visualization. When selected, each layer will be visibly drawn on the map in the selected color. To modify the display settings for a layer object, click on the color box next to the corresponding object.

From the object display settings flyout, users can customize the color of the object by clicking on the color bar at the top of the flyout. Additionally, users can customize the opacity (transparency) and width of the line for the selected object. Additionally, the zoom level can be defined. The zoom level defines when the selected object will be displayed as a layer on the map. Setting the Zoom to the State level means the object will be displayed when the map is zoomed to display the entire state. Decreasing the zoom level to a lower level will require the map to be zoomed in further in order for the object to be displayed. Users can define the upper and lower zoom levels for each object. The current map zoom level is represented with the vertical line on the zoom bar.

(The object display settings flyout for barriers and guardrails.)

The Advanced Search Bar allows users to refine their Query search by filtering by any datapoint in the available crash data. This allows users to filter by crash attributes (first harmful event, manner of collision, etc), vehicle attributes (vehicle type, vehicle maneuver, etc.), occupant attributes (severity, number of occupants, etc.), and even roadway and location attributes (roadway functional class, city, county, route, block of route, etc.).

(The Advanced Search bar for a given city, filtering for all crashes on the given extents of a city block.)

When more than five filters are present in the Advanced Search Bar, a Hide Filters option will be displayed in the Search Bar. Clicking this will hide the filters, and collapse the search bar. The Search Bar can then be expanded by clicking the Show Filters button.

(The advanced search bar, with the Hide Filters option available (top), and the advanced search bar with the filters hidden (bottom))

If the field you are filtering contains fewer than 24 values in the dropdown, you will be able to select multiple values from the filter dropdown. After selecting each value, click outside the filter box to apply the filters to the query.

(The Advanced Filter Bar with Suspected Serious and Fatal Injury Crash Severities selected)

To learn more about the Advanced Search Bar, see our Advanced Search Bar article.

Clicking on a crash in the map point view or in the raw table, will display the crash flyout. The Crash Flyout provides an in-depth analysis of a specific crash, including a Google Streetview of the crash location, crash, vehicle, and occupant level data, and a link out to any external documents available for that crash (e.g. collision report pdf, available images from the crash, or any other external resources that are available).

Additionally, the Crash Flyout contains the Exclude this Crash and Edit Attributes options. Clicking Exclude this Crash opens the Exclude Crash window. After selecting the exclusion reason, the crash will be filtered out of the query.

(The Exclude Crash window, with Inaccurate Crash Location selected as the exclusion reason.)

Any time a crash is excluded from a Query, a crash exclusion message will appear on the right side of the screen, above the metrics sidebar. Excluded crashes are only excluded from the current query. If the query is saved, all crash exclusions will be saved within that query only. A crash can be easily re-included in the query by clicking the Include button again from the crash flyout, or from within the crash exclusion notification above the metrics sidebar.

(The crash exclusion notification message, displayed above the metrics sidebar, indicating one crash has been excluded from the query).

Note that crashes can also be excluded by unchecking the selected crash from the Raw Table tab within Crash Query.

(The Stats Sidebar displayed for a crash selected from the Raw Table tab, note the crash is un-checked within the raw table, indicating this crash has been excluded.)

The Metrics tab displays a detailed breakdown of crash attributes that meet the current search criteria for the query. The first column of the Metrics table indicates the crash attribute, with the second column indicating the total number of crashes in the current search criteria that match the attribute. If available, a third column will indicate the percentage of crashes that match that attribute. Any attributes that have a value of zero will not be displayed in the Metrics tab.

Users can use the Metrics Tab to explore data related to the crash, click on any metric to add it as a filter to the current Query. When clicked, that metric will appear in the Advanced Search Bar, and the map, Metrics, Chart Builder, and Raw Table tabs will update accordingly.

(The Metrics Tab displaying the vehicle maneuver attribute metric, and part of the manner of collision attribute for all filtered crashes.)

Users can customize the metrics they would like displayed on each query. Any crash attribute available in the Dataset can be selected, and added to the Metrics tab. Any data contained in the Metrics tab will be included in any Crash Reports generated from the Query.

As with the Advanced Search Bar, any metrics selected for display will be saved when saving a Query.

Users can use the Chart Builder to create and download custom bar charts, stacked and grouped bar charts, line charts, pie charts, and pivot tables. Users can select from available measures and groupings to easily visualize any data available in the current Query. Each chart type can be downloaded as either a PNG image (bar, stacked bar, grouped bar, line, and pie), or as a CSV (pivot table).

Charts are saved with any Query, and can be easily referenced or downloaded from previously saved Crash Queries.

For more information on the Chart Builder, see our Crash Query - Chart Builder article.

(Using the Chart Builder to build a grouped bar chart displaying the cost of alcohol related crashes, grouped by county, displaying the top 10.)

The Raw Table tab provides users with a raw table of all data contained in the current query. Users can customize the columns of data that appear, and download the table in a CSV format.

(The Raw Table tab of Crash Query.)

Users can easily move a query from Crash Query to any Network Screening application through the Open In Icon, located in the menu bar at the top of the screen. With your crash filters added, click the Open In icon, and select the network screening application you would like to open.

(The Open In menu displaying a list of available Network Screening applications.)

After selecting the desired Network Screening application, all of your applied filters will be migrated to a new Network Screening. If the selected date extents for your query differ from the default date extents in Network Screening, you will be prompted to select which date extents to apply to your new Network Screening.

(A date selection window, prompting the user to select which date extents to use for the new Network Screening.)

A new Network Screening will then be created with all relevant filters from your initial query.

(A new Network Screening - Segments screening, with the selected filters and date extents, migrated over from Crash Query.)

Users can open intersections in Safety Analysis from Crash Query. To accomplish this, at least one Intersection ID and/or at least one Route ID must be applied to your query as a filter. Once either or both filters are applied, select the Open In icon in the top right of the screen and choose Safety Analysis. If Intersection ID and/or Route ID filters are not applied to the query, the Safety Analysis option will be grayed out.

NOTE: This feature may not function properly if:

(The Open In Safety Analysis option displayed in Crash Query with Intersection ID and Route ID filters applied.)

Crash Query comes with a pre-built Crash Summary Report and Comparison Report, which can be used to export the results of your query in an easy-to-share PDF, or printed report. Reports include a summary of the report parameters (Report title, date created, created by, date range of report), the filters applied to generate the report, as well as any data contained in the Metrics tab of the current Query.

To generate a report, click the Download icon in the menu bar, in the top right corner of the screen. You will then be prompted to select which report to download. Note that Over-representation reports are only available when a city, our county geo filter is applied to your query.

For more information on Crash Reports, see our Crash Query - Crash Summary Report, and Crash Query - Comparison Report articles.

(A Comparison Report for bicyclist crashes comparing two, three year periods. This report indicates a 42% reduction of serious crashes, a 33% reduction in fatal crashes, and a $34.2m reduction in crash costs.)

When conducting a Crash Query, it is easy to see the date range of crash data being displayed. By checking the Date Extents, located in the top right corner of the screen, you can see what dates of data are displayed in your Query.

To modify the dates, click on the Date Extents in the menu bar, and select the date range you would like to include in your query.

To save a query, select the “Save” button in the top right corner of your screen.

Name your query and indicate which category (or create a new one) to save the query in. Saved queries without assigned categories are saved to the "Uncategorized" category by default.

(Pop-up menu to save a query)

To access your saved queries, select the home button in the top left corner of your screen while in the Crash Query application.

(While in the Crash Query application, select the “Home” icon next to the applications menu)

This will take you to a page that displays queries you’ve saved as well as queries that have been shared with you.

(Saved queries page in Crash Query)

To share a query, select the three dots next to a query. From here, select “Share” and then “Add a user” and enter the emails of the users you’d like to share the query with in the pop-up box.

(Click the three dots next to a saved query to share the query, edit its name or category, or delete it)

Indicate what level of access you want shared users to have to the query, either edit or view access. Select "Done" when you’re finished.

(Use the drop-down menu next to shared user emails to choose if they have edit or view access)

If you’d like to share a query with someone who does not have an AASHTOWare Safety account, you will need to download a report PDF.