|Top Previous Next|
This query is used to create a High Crash Location list. It can also be used for a data range studies that include all crash data for a time period.
FristDate: This is the first date parameter of the "First Date" field in the Node Study Settings tab.
LastDate: This is the last date parameter of the "Last Date" field in the Node Study Settings tab.
Example where clause:
(Crash.CRASH_DATE BETWEEN :FirstDate AND :LastDate)
In this example CRASH_DATE is a field in a client's collision database. :FirstDate and :LastDate will be entered by the node study.