The Crash Query application allows users to run custom collision 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, Collision Diagrams, or an exportable and shareable crash report. The Crash Query application is broken into 5 sections: Map Point, Table, Charts, More Stats, and the Crash Report. Each of these sections will be discussed in more detail below.
The main screen of Crash Query is the Map Point tab. This displays all crashes that meet the current search criteria for the query on an easy-to-read GIS map interface. Each crash is color-coded to match the severity of the crash. 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.
The Stats sidebar quickly displays a high-level summary of the filtered crash data, allowing users to see key metrics related to the current query. Each element in the Stats sidebar is interactive, allowing users to click on a segment of a graph or chart, and apply that filter to the query.
Clicking on a crash displays the crash flyout, which contains 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).
The Table Tab displays all available data that meet the current search criteria for the query in a customizable, downloadable table.
Users can add and remove any columns of data from the table, and sort by any available column to display the data exactly how they want.
Users can download the table in CSV format with the click of a button.
The Charts tab allows users to create and download custom charts that visualize any datapoint from the selected query.
Users can select from the following chart types, pie chart, bar chart, stacked bar chart, grouped bar chart, and pivot table.
The More Stats Tab visualizes various key data points in the selected query through interactive charts. Users can use this tab to conduct a systemic analysis of all crashes identified in the query.
Additionally, users can click on any value in the chart to apply a real-time filter to the data. This filter will be applied to the entire query, allowing users to explore and interact with their data in real-time.
Crash Query comes with a pre-built Crash Report and Comparison report, which can be used to export the results of your crash 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, a summary of total and fatal crashes, a trend line of yearly crashes within the report range, and a detailed breakdown of the following data categories: types of crashes, severity of crashes, day of week, first harmful event, manner of collision, light conditions, road surface conditions, weather conditions, and any other key data points identified for the City.
Each datapoint in the crash report also includes the proportion of each crash type in relation to the city-wide average. This can be used to determine if there is an excess proportion of a specific crash type occurring within the crashes identified in the query.