15.10 - Data Loading - Teradata Database

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 UDF

ST_Geometry.ST_WKTToSql method

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 UDF

ST_Geometry.ST_WKBToSql method

Teradata provides an efficient data loading tool called TDGeoImport that you can use to convert geospatial data into a format that is compatible with the Teradata geospatial UDTs. TDGeoImport converts layers from ESRI, MapInfo, and TIGER/Line data sources and loads them directly into the database.

The TDGeoImport data loading tool is available from Teradata Developer Exchange (developer.teradata.com/).

The following pages provide details on the TDGeoImport data loading tool.