TDGeoImport Command - Geospatial Utilities

Syntax

where:

-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:

• ESRI Shapefiles
• MapInfo data sets in native TAB format
• U.S. Census Bureau TIGER/Line files

-m

if 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

Relative / exact path of file should be char_mapping.

Character Map File

$ => S

" " => ""

-k keyword_mapping

Text 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

Relative / exact path of file should be keyword_mapping.

Keyword Map File

FILE => _FILE

PRIVATE => _PRIVATE

PRECISION => _PRECISION

table => _table

select => _select

RTSQ => _myRTSQ

-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

Relative / exact path of file should be primary_index_mapping.

Primary Index File

landmarks => MODULE,LAND

AltName => TLID,RTSQ

-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
If this parameter is not present, the default character set is assumed (ASCII for N/W clients).

Applicable values are UTF8.

Geospatial will rename the column name as POINT for point type geometry and GEOM for all other types of geometry if it doesn’t receive a column name from the GDAL layer during import.