Teradata GeoImport Process - Geospatial Utilities

Teradata® Geospatial Utilities User Guide

Product
Geospatial Utilities
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-19
dita:mapPath
oww1544831946763.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2519
lifecycle
previous
Product Category
Teradata Tools and Utilities

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;