15.10 - Data Loading - Teradata Database

Teradata Database SQL Geospatial Types

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1181-151K

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.