15.10 - Data Unloading - 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 a ST_Geometry column. The base data type will be 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 will be BLOB.

Teradata provides an efficient data unloading tool called TDGeoExport that you can use to convert Teradata geospatial data 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/).

The following pages provide details on the TDGeoExport tool.