Loading (Importing) and Unloading (Exporting) Geospatial Data

Teradata Vantage™ Geospatial Data Types

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1181-162K

WKT Format

Applications that have geospatial data in the WKT format can insert the data into ST_Geometry columns by specifying the values as any of the following expressions:
  • 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

Applications that have geospatial data in the WKB format can insert the data into ST_Geometry columns by specifying the values as any of the following expressions:
  • 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.