Geospatial information identifies the geographic location of features and boundaries on the planet. Vantage provides Geospatial types that address the need to store, manage, retrieve, manipulate, and analyze geospatial information by governmental bodies and commercial enterprises. For example, local governments might use geospatial data for city planning, traffic management, or accident investigation.
Vantage provides geospatial types to represent geometries with up to three dimensions. Vantage provides the ST_Geometry, MBB , and MBR data types for creating and manipulating geometric shapes in the database. ST_Geometry is implemented as a user-defined type (UDT). ST_Geometry can be used 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. |