17.00 - Executing TDGeoImport - Geospatial Utilities

Teradata® Geospatial Utilities User Guide

Geospatial Utilities
June 2020
User Guide
  1. Execute TDGeoImport:
    java -Xms256m -Xmx512m -classpath
    com.teradata.geo.TDGeoImport -l hyvm20/geouser, geouser -s geouser 
    -f D:\anuguraju\anuguraju\GeoSpatial\TestEnv\geodata -n customers

    The following figure shows execution of TDGeoImport.

    TDGeoImport Example

    If a user specifies -m, a MULTISET. SET table is created by default.

    It is always better to have a unique column in data because UDT expects uniqueness of the row. Because the database requires ordering functionality for UDTs, an ordering definition exists for the ST_Geometry type. In general, however, ordering ST_Geometry types by their ordering definitions is neither useful nor meaningful. Currently these tools support only one ST_Geometry column and for good results, keep it the same as the last column.

    If -CSET UTF8 is specified, data is exported as UTF8 characters for char / varchar data types. If there are any database or JDBC connectivity issues, stack trace is printed to the console. Refer to JDBC or Vantage documentation for troubleshooting. If there are any errors with GDAL libraries, see http://www.gdal.org/.

    If a user inserts a multipolygon shape type data into the geometry column of the table and exports successfully via TDGeoExport, then during import the GDAL library reads the data, and if it finds any invalid coordinates in the layer, it will insert geometry data as a Polygon shape type, instead of multipolygon, into the target table.

    The following figure shows the data imported from the import job.

    Imported Data Using BTEQ Example