17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Geospatial Data Types

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)
  • Both geometries must include z coordinates.
  • Both geometries must use the same spatial reference system (have the same SRS ID).
  • If a geospatial index is defined on the geospatial data column to which this method is applied, the index will only be used if method appears in the WHERE clause of a query such that the distance between the geometries is less than or equal to a constant. For example:
    ... WHERE  geom.ST_3DDistance(otherGeom) < 10

    ... WHERE 10 >=  geom.ST_3DDistance(otherGeom)