17.00 - Teradata GeoImport Process - Geospatial Utilities

Teradata® Geospatial Utilities User Guide

prodname
Geospatial Utilities
vrm_release
17.00
created_date
June 2020
category
User Guide
featnum
B035-2519-220K

The following steps and examples describe how to import with the Teradata GeoImport utility.

  1. Drop the customers table from the database:

    DROP TABLE customers;

  2. Run TDGeoImport to import the ESRI shape files into the database:
    Include the terajdbc4.jar, tdgssconfig.jar, and tdgeospatial.jar in the classpath.
    • 32-bit path:
      cd c:\temp\TdGeoImportExport\bin
      java -Xms256m -Xmx512m -classpath
      .;"c:\Program Files\Teradata\Tdat\LTDBMS\bin\terajdbc4.jar";
      "c:\Program Files\Teradata\Tdat\LTDBMS\bin\tdgssconfig.jar";
      "C:\Program Files(x86)\Teradata\Client\<version>\bin\tdgeospatial.jar"; 
      com.teradata.geo.TDGeoImport -l hyvm20/ geouser, geouser -s geouser
      -f c:\temp\geodata -n customers
      
    • 64-bit path:
      cd c:\temp\TdGeoImportExport\bin
      java -Xms256m -Xmx512m -classpath
      .;"c:\Program Files\Teradata\Tdat\LTDBMS\bin\terajdbc4.jar";
      "c:\Program Files\Teradata\Tdat\LTDBMS\bin\tdgssconfig.jar";
      "C:\Program Files\Teradata\Client\<version>\bin\tdgeospatial.jar"; 
      com.teradata.geo.TDGeoImport -l hyvm20/ geouser, geouser -s geouser
      -f c:\temp\geodata -n customers 
      
  3. Validate that shape files were loaded into customers table:
    SEL pkey, point (FORMAT 'X(20)'), cust_name (FORMAT 'X(20)'), 
    cust_zipco
FROM customers 
ORDER BY 1;