ST_Geometry | Geospatial Data Types | Teradata Vantage - 17.10 - ST_Geometry - 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)

Teradata provides the ST_Geometry data type for creating and manipulating geometric shapes in the database. ST_Geometry is implemented as a user-defined type (UDT). ST_Geometry is an instantiable type within Vantage. (Vantage UDTs do not support inheritance or subtyping.) You can use ST_Geometry as the data type of a table column to represent most of the geospatial types specified in the standard.

Type Description
ST_Point 0-dimensional geometry that represents a single location in two-dimensional coordinate space.
ST_LineString 1-dimensional geometry usually stored as a sequence of points with a linear interpolation between points.
ST_Polygon 2-dimensional geometry consisting of one exterior boundary and zero or more interior boundaries, where each interior boundary defines a hole.
ST_GeomCollection Collection of zero or more ST_Geometry values.
ST_MultiPoint 0-dimensional geometry collection where the elements are restricted to ST_Point values.
ST_MultiLineString 1-dimensional geometry collection where the elements are restricted to ST_LineString values.
ST_MultiPolygon 2-dimensional geometry collection where the elements are restricted to ST_Polygon values.
GeoSequence Extension of ST_LineString that can contain tracking information, such as time stamps, in addition to geospatial information.

GeoSequence is a Teradata extension to SQL/MM Spatial.

Here is an example of a table definition that has an ST_Geometry column:

CREATE TABLE sample_shapes (skey INTEGER, shape ST_Geometry);