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 Teradata Database. (Teradata Database 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);