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