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.