Teradata Geospatial Import/Export Utilities 1.2

Teradata Geospatial Import/Export Utilities 1.2 for Teradata 13.0 (Windows / Linux). For background information on Geospatial, see What can I do with Teradata’s Geospatial Support? And for community support, visit the Connectivity & Extensibility forum.

README

Teradata TDGeoImportExport Release 1.2 for Teradata 13.0

Change History
==========================================

Release 1.2
-----------
- Fixed a bug where the statement of a fastload connect was set
  to the logon user instead of the target DB, which resulted in
  a failure.
- Fixed a bug where the program would fail because the following
  two libraries weren't found: MSVCP80D.dll and MSVCR80D.DLL.


Release 1.1
-----------
- Install directory changed from TDGeoImport to TDGeoImportExport
- Added TDGeoExport to export geometries from the database

Release 1.0
-----------
- Initial release


Documentation
==========================================================
Please see document B035-1181-098A, SQL Geospatial Types,
for program documentation.  Chapter 4, Data Loading and
Formats describes TDGeoImport.  A description of TDGeoExport
is contained within this file

Platforms
==========================================================
This version of TDGeoImport/TdGeoExport runs on Windows 32-bit clients only.

Software
==========================================================
The Teradata Driver for the JDBC Interface on Windows must
be installed.

Example Run - TDGeoImport
==========================================================

Assume an input file exists named co99_d00.shp in the directory c:\data\demo\load.  Also assume that there is a user
named geo_user and a database called mydb on a system called geo_system.

Change to the TdGeoImportExport\bin directory and execute the following to load the layer named c099_d00 into the database:

java -Xms256m -Xmx512m -classpath .;"c:\Program Files\Teradata\Tdat\LTDBMS\bin\terajdbc4.jar";"c:\Program Files\Teradata\Tdat\LTDBMS\bin\tdgssconfig.jar";. com.teradata.geo.TDGeoImport -l geo_system/geo_user,geo_pw -s mydb
-f c:\data\demo\load -n co99_d00

Note that some large data files may exceed the Java Heap memory.  In the above command, the -Xms option is used to set the
initial Java heap size to 256MB.  The -Xmx option is used to set the maximum Java heap size to 512MB.

Example Run - TDGeoExport
==========================================================

Assume a table named co99_d00 exists in the database mydb.  It contains a column of type ST_Geometry.  Also assume that there is a user
named geo_user and a database called mydb on a system called geo_system.

Change to the TdGeoImportExport\bin directory and execute the following to export the table to an ESRI shapefile named c099_d00 in the c:\data\demo\load directory.  Note that this will overwrite any files of the same name in that directory:

java -Xms256m -Xmx1024m  -classpath .;"c:\Program Files\Teradata\Tdat\LTDBMS\bin\terajdbc4.jar";"c:\Program Files\Teradata\Tdat\LTDBMS\bin\tdgssconfig.jar";. com.teradata.geo.TDGeoExport -l geo_system/geo_user,geo_pw -s mydb -t co99_d00 -f "ESRI Shapefile" -o c:\data\demo\load -n co99_d00

Note that some large data files may exceed the Java Heap memory.  In the above command, the -Xms option is used to set the
initial Java heap size to 256MB.  The -Xmx option is used to set the maximum Java heap size to 512MB.


TDGeoExport Documentation
==========================================================

TDGeoExport Data Export Program

Purpose

    Convert geospatial data from the database into ESRI and TIGER/Line data.

Syntax

    TDGeoExport -l logon_string -s database_name -t table_name
                -f format_name -o output_directory_name [-n layer_name] 

Where:

    -l logon_string: the Teradata Database logon string, where the format
                     of logon_string is:

                     Database/User,Password

    -s database_name: the database name that contains the table to convert

    -t table_name: the table name (or view) to convert

    -f format_name: Output file format name.  The possible values are as follows:
                    -f "ESRI Shapefile"
                    -f "TIGER"
                    -f "MapInfo File"

    -o output_directory_name: the directory where the output data files will be generated

    -n layer_name: the name of the layer to create (defaults to the table name)

Usage Notes

    The table or view should consist of a single geometry column of type ST_Geometry and
    one or more additional columns which represent the feature attributes.  Each row of
    the table is considered a feature and the entire table is considered a layer.  All
    columns in the table will be converted to the layer.  If a subset of columns in the
    table is desired instead of the entire table, a view that represents this subset
    should be created.

    The program will place the output file(s) in the directory specified by the
    -o output_directory_name parameter.

Restrictions

    There can be at most one geospatial column in the table.  BLOB/CLOB columns and UDT
    columns other than the ST_Geometry column are not supported.