Teradata GeoImport Process - Geospatial Utilities

Teradata Geospatial Utilities User Guide

Product
Geospatial Utilities
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-07-02
dita:mapPath
nth1488824663194.ditamap
dita:ditavalPath
Audience_PDF_include.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 DBS:

    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\tdgssjava.jar";
"c:\Program Files\Teradata\Tdat\LTDBMS\bin\tdgssconfig.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;