Crash Query is where you explore your agency's crash data. You can narrow crashes down with filters, see where they happened on the map, review breakdowns and charts, and then save, share, or download what you find. You can view results on the map, in tables and custom charts, or as downloadable CSV files and PDF reports. This article walks through the Crash Query screen, the map, and your download and Open In options, and it links to a short article for each of the other parts.
New to Crash Query? Start with Crash Query - Build Your First Query, a step-by-step tutorial for your first query.
ℹ️ Note: Numetric and AASHTOWare Safety are the same software. Agencies that license it through AASHTO know it as AASHTOWare Safety.
Open Crash Query
Open the application drop-down menu in the top-left corner and select Crash Query.
The Crash Query Screen
A query has four main areas. Everything works together: when you change a filter or the date range, the map, metrics, charts, and table all update to match.
(The four areas of Crash Query: 1 - Header, 2 - Filter Bar, 3 - Map, 4 - Sidebar)
1 - Header
The query name, date range, and buttons for reports, help, Open In, and Save.
2 - Filter Bar
The filters that decide which crashes are included.
3 - Map
Where the crashes happened, plus the map tools.
4 - Sidebar
Three tabs that summarize the same crashes: Metrics, Chart Builder, and Raw Table.
ℹ️ Note: The apps, filters, metrics, and map layers you see depend on your organization's setup and your permissions.
Header Buttons
(The header, from left to right: query name, date range, Download, Help, Open In, and Save)
Button | What it does |
Home  | The Home icon takes you to your Library of saved queries. |
Query name  | Shows the query's name. Click it to name and save the query. (By default it shows New Crash Query*) |
Date range  | Shows the dates included in the query. Click it to change them. |
Download  | Creates a report: Summary, Before/After, or Over-representation. Each report is covered in Reports, Downloads, and Open In below. |
Help  | Opens the Help Center article for Crash Query. |
Open In  | Starts a project in another app, such as Network Screening, with the same filters. Learn more in Open In Overview. |
Save   | Saves the query so you can come back to it or share it. Navigating Applications and Managing Saved Projects covers how to save, copy, share, or delete a query, or find it again later. |
💡 Tip: Save before you go to the home page or leave Crash Query. Unsaved changes aren't kept.
Map
The map shows where the crashes in your query happened. Zoom out to see patterns, zoom in to see individual crashes, and use the Map Toolbar to search for places, draw areas to filter by, and turn on extra layers.
Reading the Map
(The map zoomed out, showing crashes as a heat map)
Satellite / street map (top-left corner): Switches the base map.
Crash count (top center): How many crashes are in the current map view out of all the crashes in the query, for example "Showing 2,171 of 638,272 Crashes". Click the eye icon to hide or show crashes on the map. Hiding crashes is handy while you set up a query or move to a location.
Severity key (bottom-left corner): Shows which color stands for which severity level.
ℹ️ Note: Organization admins set the colors used for crash clusters and dots. The key in the bottom-left corner of the map always shows what each color means.
Crash Clusters and Dots
How crashes appear depends on the Visualization option in Map Settings:
Heatmap & Clusters (the default): When you're zoomed out, crashes appear as a heat map. The darkest blue areas have the most crashes. As you zoom in, the heat map turns into crash clusters. The number on a cluster is how many crashes it holds, and each cluster takes the color of the most severe crash in it. Click a cluster to zoom in and split it out.
Dots: Each crash shows up as a single dot, colored by its severity.
(Crash clusters after zooming in with Heatmap & Clusters on, with the crash count for the crashes in view)
Hover over a crash cluster or dot for a quick summary, or click it to open the Crash Flyout.
Map Toolbar
(The Map Toolbar)
ℹ️ Note: Map Toolbar Overview has more details on every tool.
Tool | What it does |
Map Settings | Changes how crashes are shown and how the map behaves. |
Layers | Turns extra map layers on or off, such as boundaries and assets. |
Map Search | Finds a place. Start typing, and then select a result from the list. |
Zoom Controls | Zooms the map. You can also scroll. |
Polygon Tool / Circle Tool | Draws an area. Only crashes inside it are included. |
Line Tool | Selects a stretch of road. Click the road at the start and end points, and a route filter with the beginning and ending milepoints is added. Crash Query - Line Tool Overview has the full steps. |
Measure Tool | Measures on the map. |
Filter to View | Filters the query to what's in the current map view. |
Zoom to Extents | Zooms out to fit all the crashes in the query. |
3D View | Shows the map in 3D. |
Download | Downloads the map as a PNG image or a shapefile (SHP). |
Reports, Downloads, and Open In
Create a Report
Click the Download icon in the header and select a report type.
Every report is a PDF that includes the report title, the date it was created, who created it, the report date range, the filters applied, and the data in the Metrics tab.
(The report types available from Download)
Report | What it shows | Overview, how to generate it, and details |
Summary | The metrics in your query, with your charts if you want them. | |
Before/After | A comparison of two date ranges, based on the metrics in your query. | |
Over-representation | Metrics that are over-represented in one area compared with the larger area around it. Needs one geo filter: a filter with (Geo) in its name. Drawn polygons don't count.Learn more in Location Filters: Geo vs. Non-Geo Filters. |
ℹ️ Note: Reports you create are kept in the Reports app under Reports > Archives, where you can download them again.
Download Data
Data | Where to download it | How to download it, and details |
Crash records | Raw Table > Download | |
Map | Map Toolbar > Download > PNG or SHP | |
Charts | The Download button on a chart card |
Open Your Crashes in Another App
Click Open In to start a project in Network Screening, Advanced Network Screening, or Safety Analysis with the same filters and date range. Each app has its own requirements.
Library of Saved Queries
To open your library of saved queries, select the Home icon in the top-left corner. This page lists the crash queries you've saved and any that have been shared with you.
From this page, users can also start a new query or upload a shapefile.
New Crash Query: Starts a new query.
Upload Shapefile: Uploads a custom area, such as a corridor or district boundary, to use as a location filter. The shape is saved only in the query you use it in.
(The Crash Query home page, with New Crash Query, Upload Shapefile, and saved queries)