Expressions.expr-primary-location

Location string, used to define a location using latitude and longitude within a query.

LOCATION <location string>

Format

LOCATION { 'Location string' | ? | ( Location expression ) }

The Location string format is defined as follows:

Latitude, Longitude [, Accuracy] [ALT Altitude [, Altitude-Accuracy]] [DIR Heading, Speed] [TS yyyy-MM-dd [HH:mm:ss.SSS]]

where components (see Accuracy and Altitude) in [ ] are optional.

The following are examples of the how the components maybe combined within the Location string:

Latitude, Longitude

Latitude, Longitude [, Accuracy]

Latitude, Longitude [ALT Altitude]

Latitude, Longitude [ALT Altitude [, Altitude Accuracy]]

Latitude, Longitude [DIR Heading, Speed]

Latitude, Longitude [TS yyyy-MM-dd]

Latitude, Longitude [TS yyyy-MM-dd [HH:mm:ss.SSS]]

Latitude, Longitude [, Accuracy] [ALT Altitude [, Altitude Accuracy]] [DIR Heading, Speed] [TS yyyy-MM-dd [HH:mm:ss.SSS]]

The following table describes the required format for each component:

Remarks

Location values are defined using the LOCATION keyword followed by a Location value.

The Location value can be one of the following:

• A string literal containing the standard location format
• A parameter marker.
• A string expression enclosed in parentheses that evaluates to a string containing the standard location format.

Comparison operators IN, NULLIF and CAST functions can be used with LOCATION literals and location database fields.

CAST supports LOCATION AS STRING and STRING AS LOCATION (string containing the standard location format).

Comparison operators can compare LOCATION with LOCATION, LOCATION with STRING and vice versa.