Geospatial Single-Table Predicate Syntax | Teradata Vantage - Geospatial Single-Table Predicate Syntax - Advanced SQL Engine - Teradata Database

Single-Table Predicate

For single-table predicates except distance methods ST_Distance and ST_3DDistance:

SELECT a, b FROM TableName WHERE {
  TableName.GeoCol.SupportedGeoMethod (GeospatialLiteralExpression) = 1 |
  GeospatialLiteralExpression.SupportedGeoMethod (TableName.GeoCol) = 1 |
  TableName.GeoCol IS NULL
}

Single-Table Distance Predicate

For distance methods ST_Distance and ST_3DDistance:

SELECT a, b FROM TableName WHERE {
  TableName.GeoCol.SupportedGeoDistanceMethod (GeospatialLiteralExpression)
    { < | <= } DistanceLiteral |

  GeospatialLiteralExpression.SupportedGeoDistanceMethod(TableName.GeoCol)
    { < | <= } DistanceLiteral
}

Syntax Elements

TableName

Table containing a geospatial data column.

GeoCol

Geospatial data column defined as one of the ST_GEOMETRY types.

SupportedGeoMethod

One of the geospatial methods listed above, excluding ST_Distance and ST_3DDistance.

SupportedGeoDistanceMethod

Either ST_Distance or ST_3DDistance.

GeospatialLiteralExpression

An arbitrary geospatial literal expression that can be folded (simplified) in to a geospatial literal value.

DistanceLiteral

A floating point value representing a distance.