Effective December 2020, Crash Query has supported the ability to display crash information from various data tables, including Crash data, Vehicle data, and People data. The addition of these data tables allows users the ability to view additional information and insight into the available crash data.
A list of the current data tables, as well as the fields associated with each data table, can be found in the UDOT Crash Data Fields by Data Table article.
While the Crash Map in Crash Query will still display Crash Level data (meaning each location on the map represents a single crash location), users have the ability to view Crash, Vehicle, or People level data in the Metrics Sidebar, Chart Builder, or Raw Table tabs of Crash Query.
(The map tab displaying the number of crashes in a given area.)
From the Metrics Sidebar, users can see the table of each datapoint displayed. The data table (Crash, Vehicle, People) is displayed to the right of the Metric name. Here for example, highlighted in green, we can see the UDOT Crash Summary, and Crash Severity metrics are being pulled from the Crashes dataset - meaning the numbers represent the numbers of crashes for each metric. However, the Injury Level metric is being pulled from the People dataset, meaning the numbers represent the number of people with each injury level (multiple injuries may have occurred for a single accident).
(The metrics sidebar highlighting in green the data tables for three given metrics.)
When adding and removing metrics from the sidebar, you must first select the data table for the metric, then select the desired metric to add to the sidebar. The data table can be selected from the data table dropdown menu in the top right corner. Note that each data table contains unique metrics. A list of each metric available for each data table can be found in the UDOT Crash Data Fields by Data Table article.
(The data table dropdown from the Manage Metrics window, highlighted in green.)
When building a chart in the Chart Builder tab, users have the ability to select various measures from the Crash, Vehicle, and People data tables.
When selecting the Crashes (Cost) measure, the cost estimate of each crash will be displayed as the vertical axis on the chart.
Selecting the Crashes (Count) measure, the total number of crashes will be displayed as the vertical axis on the chart.
Selecting the People (Count) measure, the total number of people involved in the crashes will be displayed as the vertical axis on the chart.
Selecting the Vehicle (Count) measure, the total number of vehicles involved in the crashes will be displayed as the vertical axis on the chart.
(The Measure dropdown menu in the Chart Builder.)
From the Raw Table tab, users have the ability to view the raw table of data for any of the available data tables. By default, the Raw Table will display the Crashes table (meaning each row in the Table represents a single crash). Users can toggle between the various data tables by clicking on the Select Table icon, in the bottom left corner of the Raw Table tab.
(The Raw Table tab with the Crashes table selected and highlighted in green.)
When the Vehicle table is selected, each row of the table represents a vehicle that has been involved in a crash.
(The Raw Table tab with the Vehicle table selected. Note the addition of the Vehicle Number column, when combined with the Crash ID provides a unique number representing each vehicle involved in the crash.)
When the People table is selected, each row of the table represents a person that has been involved in a crash.
(The Raw Table with the People table selected. Note the addition of the Person ID column, when combined with the Crash ID provides a unique number representing each person involved in a crash.)