Teradata GeoImport Process - Geospatial 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:
   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\Client\17.20\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;