ST_Geometry Type Ordering | Geospatial Data Types | Teradata Vantage - Ordering - Teradata Vantage - Analytics Database

Geospatial Data Types

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-08-30
dita:mapPath
qgk1628112272483.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ghz1472251264557
lifecycle
latest
Product Category
Teradata Vantageā„¢

Because the database requires ordering functionality for UDTs, an ordering definition exists for the ST_Geometry type. In general, however, ordering ST_Geometry types by their ordering definitions is not useful or meaningful.

To determine spatial relationships between geometries, for example whether one ST_Geometry type is equal to another, the best practice is to use the ST_Geometry spatial methods, for example geom1.ST_Equals(geom2).

For more information on ordering functionality, see the CREATE ORDERING statement in Teradata Vantageā„¢ - SQL Data Definition Language Syntax and Examples, B035-1144.