All Data

Top  Previous  Next

All data study definitions are used for studies that only contain date ranges. This study will append a where clause to the query selected for this study. For the All Data study to work a query must be used that identifies the following normalized field:

 

Date

 

Example where clause added to the all data query specified in the study definition

WHERE 

((   Crash.Accidentdate BETWEEN '1/1/2007' AND '12/31/2007 11:59:59 PM'))

In this example the Accidentdate field from the study query was labeled as the Normalized date field. Crash Magic add the date information based on the user dates selected in the All Data study.

 

 

Normalized fields required to produce Intersection High Crash Location lists with this study definition:

PrimaryStreet
CrossStreet

 

Optional fields that may be used depending on collision data:

PrimaryStreetUnique1
PrimaryStreetUnique2
CrossStreetUnique1
CrossStreetUnique2