Quick Start Guide to Exploring Fruit City Crashes

Learn how to navigate the map interface and query crash records in Fruit City.

Disclaimer: The following guide is based on a real application I worked on. All data in the graphics use imaginary data.

---

This guide will go over the following:

1. Searching for a jurisdiction
2. Applying crash attributes to filter crashes
3. Exporting record data for further analysis

One workflow when exploring Fruit City crashes.

Searching for a Location

This section will go over searching and selecting a jurisdiction.

Search for a Jurisdiction

Jurisdictions including counties and municipalities can be searched in by using the Filter Menu or Search Bar.

Filter MenuSearch Bar

1. Click the Filter Menu located on the left side of the map.
2. Click the Jurisdiction Menu to open options for counties and municipalities.
3. Select one or more jurisdictions. The map will automatically display crashes based on your selections.

Info

You cannot select a mix of counties and municipalities. When selecting counties, all municipality options will be disabled and vice versa.

Jurisdiction select using the Filter Menu. Counties will be disabled when municipalities are selected and vice versa.

1. Type the jurisdiction in the Search Bar to view a list of options based on your query.
2. Click on a "COUNTY" or "MUNICIPALITY" option. The map will zoom to the jurisdition and display crashes based on your selection.

Info

The Search Bar can support one selection at a time. To select multiple jurisdictions, use the Jurisdiction Menu from the Filter Menu after selecting a "COUNTY" or "MUNICIPALITY" option.

Jurisdiction select using the Search Bar

Filter Crashes using Crash Attributes

Crash attributes are particular characteristics of a crash such as:

• Alcohol Use: yes, no
• Weather Condition: rain, snow, fog
• Contributing Factor: driver distracted, following too closely, fell asleep

To apply filters:

1. Click the Filter Menu to display various filter categories.
2. Click on a category to display a menu of individual filters.
3. Select any number of filters. Your selections will be highlighted in green and the map will automatically refresh to display crashes with your selected filters.

Selecting various filters from the Filter Menu will automatically refresh crashes within your map view.

How crashes are filtered when multiple crash attributes are selected

When individual filters under the same category are selected, crashes will be queried with the individual filters appended with an "OR" clause. For example:

• Selecting "Wet", "Snowy", and "Icy" under the Road Condition category will query crashes with Road Condition of "Wet" OR "Snowy" OR "Icy".

How crashes are queried when selecting filters under the same category.

When selecting filters across multiple categories, crashes will be queried with the individual filters within each category appended with an "AND" clause. For example:

• Selecting "Wet", "Snowy", and "Icy" under the Road Condition category and "Fatal Injury" and "Possible Injury" under the Pedestrian Physical Condition category will query crashes with (Road Condition of "Wet" OR "Snowy" OR "Icy") and (Pedestrian Physical Condition of "Fatal Injury" OR "Possible Injury").

How crashes are queried when selecting filters across multiple categories.

Export Crash Records to CSV

Crash records can be exported as a CSV file for further analysis. The exported crash records are based on the crashes currently visible in your map view. To export crash records:

1. Move your map view to encompass all crash records you want to export.
2. Open the Results Display on the bottom-left of the map interface.
3. Click Export Records. The application will take time preparing your export depending on how many crashes are in your map view.
4. Agree to the disclaimer to download a CSV file of crash record data.