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.
|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);