HCL Query

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.