The Teradata Database has 3 Geospatial data types:
| Teradata Database Data Type | Description |
|---|---|
| ST_Geometry | Represents any of the following geometry types: ST_Point, ST_LineString, ST_Polygon, ST_GeomCollection, ST_MultiPoint, ST_MultiLineString, ST_MultiPolygon and GeoSequence. |
| MBR | Providers a way to obtain the minimum bounding rectangle (MBR) of a geometry for tessellation purposes. |
| MBB | Providers a way to obtain the minimum bounding box (MBB) of a geometry. |
The Teradata Database "SQL Geospatial Types" manual describes each type in detail. This sections shows how the Teradata Database Geospatial types map to the .NET Framework type system.
The Teradata Database transforms ST_Geometry, MBR, MBB data types to CLOB, VarChar(256) and VarChar(340) respectively. CLOB and VarChar data types are mapped to the following Base Class Library (BCL) types:
The .NET Data Provider for Teradata converts the Teradata Database Geospatial types to the BCL types and/or TdClob Provider Specific Types:
| Teradata Database Type | BCL Type | Provider Specific Type |
|---|---|---|
| MBR, MBB | System.Char[] | NA |
| System.String | ||
| ST_Geometry | System.Char[] | TdClob |
| System.String |