Process
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\binjava -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_zipcoFROM customers ORDER BY 1;
TDGeoImport Command
Syntax
where
Parameter |
Description |
-l logon_string |
Teradata Database logon string, where the format of logon_string is: Database/User,Password |
-s database_name |
Database name where the data will be imported to |
-f data_source_name |
File or directory with data files. Supports the following input file formats: o ESRI Shapefiles o MapInfo data sets in native TAB format o U.S. Census Bureau TIGER/Line files o KML files. |
-m |
f present, tables created will be MULTISET; if NOT, tables will be SET. |
-c char_mapping |
Text file containing a mapping of illegal characters found in data source to legal characters for the database. The file should contain one entry per line in the form: illegal_character => legal_character Example character map file: $ => S " " => "" Note: relative / exact path of file should be char_mapping. |
-k keyword_mapping |
ext file containing a mapping of illegal keywords found in data source to legal keywords for the database. The file should contain one entry per line in the form: illegal_keyword => legal_keyword Example keyword map file: FILE => _FILE PRIVATE => _PRIVATE PRECISION => _PRECISION table => _table select => _select RTSQ => _myRTSQ Note: relative / exact path of file should be keyword_mapping. |
-p primary_index_mapping |
Text file containing a mapping of user defined primary indexes for a certain layer. The file should contain one entry per line in the form: layer_name => primary_index Example Primary Index file: landmarks => MODULE,LAND AltName => TLID,RTSQ Note: relative / exact path of file should be primary_index_mapping. |
-a_srs coordinate_system |
Coordinate system for imported geospatial data. Note that no transform is performed; the SRID of the GeoSpatial field is set to the value of this parameter. Default is NAD83. |
-FLOAD load_type |
Specifies FastLoad used while logging to database or not. 0 = fastload off; FastLoad not used while logging to database. 1 = fastload on; FastLoad is used while logging to database. 2= fastload on, FastLoad used and logging option turned on. |
-BSIZE rows_in_batch |
Number of bytes of data in a batch inserts. If not present, 30000000 bytes of data are in a batch insert. |
-CSET charset_name |
Specifies the client character set while logging onto Teradata Database Note: Applicable values are UTF8. |
Note: Some large data files may exceed Java heap memory. In the example, the -Xms option sets the initial Java heap size to 256MB. The -Xmx option sets the maximum Java heap size to 1024 MB.