Step 1 - Initialize

The first step is to initialize the query by defining several key parameters on which the query will be based. The image below illustrates the initialize panel for Step 1.

Date Range

A date range (based on crash date) is required for all queries. Use the From: and To: date pickers to select the desired date range for the query. The default range is the previous three years from the current date. The dates can be entered manually, or by clicking on the calendar icon () to use the date picker.

Crash Focus

The crash focus defines the universe of crashes to be queried. The default is ALL crashes, however the user can click the button to focus the query on only those crashes that occured at an intersection or only crashes that occurred along a mainline.

Query Level

Query Level specifies the number of records per crash that will be returned in the query results grid.

•Crash – returns one record per crash (Default)

•Vehicle – returns one record for each vehicle (per crash). Crash fields will be duplicated across rows in this case, with a separate row for each vehicle.

•Person – returns one record for each person (per crash). Crash and Vehicle fields will be duplicated across rows in this case, with a separate row for each person.

Result Fields

Specifies the fields that will be displayed in the query results grid. Click the Customize Result Fields button to customize the fields. The following dialog will be displayed.

The fields are grouped into several categories as follows:

•Basic Crash Details

•Extended Crash Details

•Crash Location Details

•Road Characteristics

•Vehicle Details (only shown if a vehicle or person level query is selected)

•Person Details (only shown if a person level query is selected)

To customize the fields:

•Check or uncheck individual fields

•To check ALL fields in a group, click the icon next to the group name (highlighted in red in image above)

•Click OK to save the fields selected, or Close to exit the form without saving changes

•Additionally, there are several buttons at the bottom of the form

oReset All -Checks/unchecks fields to include only the default included fields, ignoring your prior changes. Users will use this option if they decide their changes are inappropriate and want to get the default fields instead - without closing and re-opening this form without changes.

oUnselect All - Unselects all fields on the dialog, allowing the user to select only those fields they are interested in.

oSet as Default -  Sets the default fields for the logged-in user to the current fields for all queries in the future.

Use Selection Set to Limit Query

Once a query has been executed, generating records in the query results grid. A subsequent query can be run to select a SUBSET of records from the current query results. To use this option:

•Check the “Use Selection Set to Limit Query” box in Step 1 (disabled until a query is executed)

•Confirm Query Optimization at bottom of Step 2 form

•Define the rest of the query within the criteria form and execute the query

Reset All Button

The Reset All button resets all 3 steps of the query form and also clears all records from the query results grid)

Opening a Saved Query

This is the point at which a user should Open a Saved Query to fill out the Advanced Query automatically, using saved parameters. To learn more about this see the Opening a Saved Query help topic.

Next

Once all fields in Step 1 are completed, the user can select the 'Next' button in the bottom-right of the form to move onto Step 2 - Location.