17.10 - Geospatial UDFs - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Geospatial Data Types

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1181-171K
Language
English (United States)

This section describes the Vantage geospatial UDFs. These are geospatial functions that have been implemented by Teradata using the Vantage user-defined function infrastructure.

For best performance, follow these practices:
  • When ST_Geometry defines an instance method that performs the same functionality as a geospatial UDF, use the instance method instead of the UDF.
  • When a geospatial system function exists that performs the same functionality as a geospatial UDF, use the system function instead of the UDF.

If your SQL request specifies the name of a geospatial system function that is also the name of a geospatial UDF, Vantage calls the system function. To call the UDF, qualify the name of the UDF with the SYSSPATIAL database name.