15.10 - Unloading Geometry Data - Teradata Database

Teradata Database SQL Geospatial Types

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1181-151K

Applications that need geospatial data in the WKT format can directly select from an ST_Geometry column. The base data type is CLOB. Applications that need geospatial data in the WKB format can directly select from a ST_Geometry column using the ST_AsBinary method. The base data type is BLOB.

For details on WKT and WKB formats, see Chapter 13: “Data Loading, Data Unloading, and Formats.”

Teradata provides an efficient data unloading tool called TDGeoExport that you can use to convert the Teradata geospatial formats into a format that is compatible with the ESRI, MapInfo, and TIGER/Line data formats.

The TDGeoExport data unloading tool is available from Teradata Developer Exchange (developer.teradata.com/).