WKT Format
- CLOB or VARCHAR constant in the WKT format
- NEW expression with the VARCHAR or CLOB form of the ST_Geometry constructor
- SYSSPATIAL.ST_GeomFromText function
- ST_Geometry.ST_WKTToSql method
Applications that require geospatial data in the WKT format can select directly from an ST_Geometry column using the default transform group for the ST_Geometry type. The returned data type is CLOB.
Alternatively, you can use one of the other provided transform groups to load and unload geospatial data as other types or formats. For more information, see ST_Geometry Type Transforms.
WKB Format
- NEW expression with the VARBYTE or BLOB form of the ST_Geometry constructor
- SYSSPATIAL.ST_GeomFromWKB function
- ST_Geometry.ST_WKBToSql method
Applications that require geospatial data in the WKB format can directly select from a ST_Geometry column using the ST_AsBinary method using the default transform group for the ST_Geometry type. The returned data type is BLOB.
Alternatively, you can use one of the other provided transform groups to load and unload geospatial data as other types or formats. For more information, see ST_Geometry Type Transforms.
TDGeoImport and TDGeoExport Utilities
TDGeoImport and TDGeoExport are utilities that Teradata provides to interconvert between the database representation of geospatial data and formats compatible with the ESRI, MapInfo, and TIGER/Line data formats. For more information on these utilities, see Teradata® Geospatial Utilities User Guide, B035-2519.