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)
  • ST_Distance returns NULL if the geometry value passed to it is the empty set.
  • 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_Distance(otherGeom) < 10

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