This guide helps Arizona DOT users move from ACIS to AASHTOWare Safety. It shows where to find the information from each ACIS report in Crash Query, how to set the date range, filter, and narrow crashes to a location, how to download data and reports, and how to use the templates the Arizona DOT team built to match common ACIS reports.
​

The information in the following ACIS reports is available in Crash Query:

The date range in the top-right corner of the screen shows which dates your query includes. Crashes outside the date range aren't filtered or shown in your query. To include them, change the date range.
​

(The date range in Crash Query)
​

(Editing the date range)
​

Learn more in Date Range and Filter Bar.
​

The Filter Bar lets you refine your query by any data point in the available crash data. You can 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 roadway and location attributes (roadway functional class, city, county, route, block of route, etc.).

1. Click Add Filter in the Filter Bar.
​

(Add Filter in Crash Query)
​

2. Type in the search bar, or scroll down to find the filter you want. Click the filter to see its values.
​

(Searching for a filter by name)
​

(Scrolling through the list of available filters)
​

3. Select the values you want, then click Apply.
​

(Selecting filter values)
​

Learn more about the Filter Bar in Date Range and Filter Bar.
​

There are several ways to filter crash data to a specific location in Crash Query. Each option is described below.
​

Use the following filters to filter crash data to a specific location:

For local roads, select routes from the map with the Line Tool. For divided routes, select the route with the Line Tool in each direction. The Line Tool uses the Dominant Route ID filter in Crash Query. Learn more in Crash Query - Line Tool Overview.
​

(Selecting a route with the Line Tool)
​

Use the Dominant Route ID or Dominant Route ID (Decoded) filter with the Milepost and Offset filters to find non-local routes in Crash Query.
​

To filter to an area on the map, draw a polygon or a circle (radius) to set its boundaries. Only crashes inside the shape are included.

Learn more about the Polygon Tool and the Circle Tool in Map Toolbar Overview.
​

(Polygon Tool in the Map Toolbar)
​

(Circle Tool in the Map Toolbar)
​

You can upload a polygon shapefile to Crash Query to analyze crashes within a custom area, such as an exact project boundary or study area. Learn more in Crash Query - App Overview.
​

(Upload Shapefile on the Crash Query home page)
​

The Metrics tab in the Sidebar breaks down the crashes in your current query by crash attribute. The first column shows the crash attribute, and the second shows how many crashes in your query match it. When available, a third column shows the percentage of crashes that match. Learn more in Crash Query - Metrics.
​

(Metrics tab columns: crash attribute in green, number of crashes in orange, and percentage of crashes in blue)
​

You can change which metrics appear in the Metrics tab.

1. Click the gear icon in the top-right corner of the Metrics tab.
​

(The gear icon in the Metrics tab)
​

2. In the Manage Metrics pop-up window, select a dataset (Crash, Person, or Vehicle) from the dropdown menu.
​

(The Crash dataset)
​

(The Person dataset)
​

(The Vehicle dataset)
​

3. Click the plus icon to the left of each metric you want to add.

4. Click Apply in the bottom-right corner to update the Metrics tab.

The Manage Metrics window also has two shortcuts:

(Restore to Default in the Manage Metrics pop-up window)
​

(Clear All in the Manage Metrics pop-up window)
​

(The Raw Table tab and Download button)
​

(The .csv and .xml download options)
​

The download includes every included row, not just the 500 shown in the table, and only the columns added to the table. Learn more in Crash Query - Raw Table.
​

Crash Query includes three pre-built reports: Crash Summary, Before/After, and Over-representation. Use them to export your query results as an easy-to-share PDF. Reports include a summary of the report parameters (report title, date created, created by, and report date range), the filters applied to generate the report, and any data in the Metrics tab of the current query.

1. Click the Download icon in the top-right corner of the screen.
​

(The Download icon in Crash Query)
​

2. Select the report you want to download.
​

(Report options in Crash Query)
​

Learn more about each report:

To view charts built in a saved query, click the Chart Builder tab in the Sidebar. The charts update to reflect the crashes in your query's current search criteria. Scroll down the Sidebar to view all charts. To download a chart as a PNG file, hover over the chart and click the download button. Learn more in Crash Query - Chart Builder Overview.
​

(The Chart Builder tab in a saved query)
​

(A chart in the Chart Builder tab)
​

To support the move from ACIS, the Arizona DOT team created templates for common crash data processes. A template can include preset metrics, Raw Table columns formatted for download, and pre-built charts.

The templates replicate many of the queries and downloads you used in ACIS, but they're a starting point, not a limitation. AASHTOWare Safety is a self-service analysis tool: you can query, analyze, and explore the data however your work needs, rather than only reproducing the downloads and reports you ran in ACIS.
​

1. From Crash Query, click the Home icon in the top-left corner of the screen.
​

(The Home icon in Crash Query)
​

2. Select Templates in the left-hand menu to view the available templates.
​

(The Templates category on the Crash Query home page)
​

3. Click a template name to open it.

4. Click Make a Copy in the top-right toolbar.

Make a copy before you change the template. Your edits are saved to your copy, and the original template doesn't change. Learn more about your library of saved queries in Navigating Applications and Managing Saved Projects.
​

(The Make a Copy button in a saved query)
​

Template: Collision Manner - TEMPLATE

This template includes a pre-built table, Manner of Collision by Severity. To view it, click the Chart Builder tab in the Sidebar. Charts and tables in the Chart Builder update to reflect the crashes in your query's current search criteria. Learn more in Crash Query - Chart Builder Overview.

This template also includes the following metrics by default:

Find and use a template
​

Template: First Harmful Event Template

This template includes the following metrics by default:

Find and use a template
​

Template: None needed

The default Raw Table in a new Crash Query is already set up to match the Incident Level Detail and Standard Detail reports.

1. Click the Raw Table tab in the Sidebar.
​

(The Raw Table tab in Crash Query)
​

2. To change the dataset, click the table icon at the bottom of the Raw Table and select a dataset.
​

(Changing the Raw Table dataset)
​

(The available datasets for the Raw Table)
​

The Crash dataset matches the ACIS Incident Level Detail report. Open a new Crash Query and download the Crash dataset Raw Table. It includes these columns by default:

The Vehicle dataset matches the ACIS Standard Detail report. Open a new Crash Query and download the Vehicle dataset Raw Table. It includes these columns by default:

The Person dataset includes the same columns as the Vehicle dataset, plus passenger data. Open a new Crash Query and download the Person dataset Raw Table. It includes these Person dataset columns by default:

Template: Injury Severity Template

This template includes the following metrics by default:

Find and use a template
​

Template: Data Export - TEMPLATE

The Data Export template's Raw Table follows the format of the ACIS Incident Level Data, Unit Level Data, and Person Level Data reports, so you can quickly download XML data for your analysis area. It includes the following columns by default:

Find and use a template
​

Template: Site Summary -TEMPLATE

This template includes the following pre-built charts:

To view and download the charts, open the template and click the Chart Builder tab, as described in View Charts in the Chart Builder.

Find and use a template