X Y Query

Top  Previous  Next

This query allows users to retrieve collisions based on the X and Y coordinates of a collision. Users are able to specify a rectangle based on the top, bottom, minimum and maximum coordinate. The coordinates specify a box, and any collision with in the box is contained in the study.

 

The following parameters are used in the where clause:

 

FristDate: This is the first date parameter of the "First Date" field in the Study Settings tab of the X,Y Coords Study.

 

LastDate: This is the first date parameter of the "Last Date" field in the Study Settings tab of the X,Y Coords Study.

 

Xmin: This is the X minimum parameter of the "X Min: field in the in the Study Settings tab of the X,Y Coords Study.

 

XMax: This is the X maximum parameter of the "X Max: field in the in the Study Settings tab of the X,Y Coords Study.

 

YMin: This is the Y minimum parameter of the "Y Min: field in the in the Study Settings tab of the X,Y Coords Study.

 

YMax: This is the Y maximum parameter of the "Y Max: field in the in the Study Settings tab of the X,Y Coords Study.

 

 

Example where clause:

(Crash.XCoordinate BETWEEN :XMin AND :XMax)

AND(Crash.YCoordinate BETWEEN :YMin AND :YMax)

AND(Crash.Accidentdatetime BETWEEN :FirstDate AND :LastDate)