Street Milepost/Street Address Query

Top  Previous  Next

This query is for users that can locate their database collisions by street and milepost or address

 

The following parameters are used in the where clause:

FristDate: This is the first date parameter of the Date range field in the Node Study Settings tab.

 

LastDate: This is the last date parameter of the Date range field in the Node Study Settings tab.

 

Route: This is the street name or route that the collisions occurred on.

 

The milepost study will also use the following two parameters:

 

FisrtMilepost: This is the starting address

 

LastMilepost: This is the ending address

 

Example where clause for milepost queries:

(Crash.CrashDate BETWEEN :FirstDate AND :LastDate)

AND(St1.StreetName = :Route)

AND(Crash.Milepost >= :FirstMilepost)

AND(Crash.Milepost <= :LastMilepost)

 

 

 

The address study will use the following two parameters:

 

FisrtAddress: This is the starting address

 

LastAddress: This is the ending address

 

Example where clause for address queries:

(Crash.CrashDate BETWEEN :FirstDate AND :LastDate)

AND(St1.StreetName = :Route)

AND(Crash.Block1 >= :FirstAddress)

AND(Crash.Block1 <= :LastAddress)