All Forums Extensibility
TDshyam 3 posts Joined 09/12
02 Oct 2012
Error while exporting data into ESRI shapefile using TDGeoExport

Hi,
I am trying to Export data from a table to shapefile(i.e  .shp file) using TDGEOIMPORTEXPORT which runs through java,  When I am running this ( C:\TdGeoImportExport\bin>java -Xms256m -Xmx512m  -classpath .;"c:\Program Files\
Teradata\Tdat\LTDBMS\bin\terajdbc4.jar";"c:\Program Files\Teradata\Tdat\LTDBMS\b
in\tdgssjava.jar";"c:\Program Files\Teradata\Tdat\LTDBMS\bin\tdgssconfig.jar";.
com.teradata.geo.TDGeoExport -l 127.0.0.1/dbc,dbc -s tpch -t shapes_sam  -f "ESR
I Shapefile" multipolygon -o C:\GEOSPATIAL_FOLDER -n shapes_sam)
  from my CMD prompt,  I am running into below issue, can some one suggest how to over come this issue. FYI..here is the table structure from which I am trying to import data from:
 
CREATE SET TABLE tpch.TERR_GEO ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT
     (
      TERRITORY_CODE VARCHAR(8) CHARACTER SET LATIN NOT CASESPECIFIC,
      ZIP VARCHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC,
      GEOM SYSUDTLIB.ST_Geometry)
PRIMARY INDEX ( ZIP );

 
C:\TdGeoImportExport\bin>java -Xms256m -Xmx512m  -classpath .;"c:\Program Files\
Teradata\Tdat\LTDBMS\bin\terajdbc4.jar";"c:\Program Files\Teradata\Tdat\LTDBMS\b
in\tdgssjava.jar";"c:\Program Files\Teradata\Tdat\LTDBMS\bin\tdgssconfig.jar";.
com.teradata.geo.TDGeoExport -l 127.0.0.1/dbc,dbc -s tpch -t shapes_sam  -f "ESR
I Shapefile" multipolygon -o C:\GEOSPATIAL_FOLDER -n shapes_sam
Coordinate System defaulting to NAD83.
WARNING: There is data in the directory C:\GEOSPATIAL_FOLDER which was specified
.
If you continue, and there is pre-existing data for layer SHAPES_SAM,
all data for that layer will be OVERWRITTEN.
Would you like to continue? [y,n] y
Logon        = 127.0.0.1/dbc,dbc
DatabaseName = TPCH
Table Name   = SHAPES_SAM
Export to    = C:\GEOSPATIAL_FOLDER\SHAPES_SAM
File Format  = ESRI Shapefile
Shape Type   = MULTIPOLYGON
Only 1 Type  = FALSE
-------------------------------------------
connecting to 127.0.0.1 ... connected!
-------------------------------------------
exporting table SHAPES_SAM to layer SHAPES_SAM ...
java.sql.SQLException: TPCH.SHAPES_SAM has below un-supported data types:
 Column geometry is OTHER

        at com.teradata.geo.TabDef.getOFTTypes(TabDef.java:201)
        at com.teradata.geo.TabDef.<init>(TabDef.java:86)
        at com.teradata.geo.TDGeoExport.Processtable(TDGeoExport. java:468)
        at com.teradata.geo.TDGeoExport.main(TDGeoExport.java: 718)
Exporting data failed.
===========================================
Data exporting failed!
 
Thank you and Appreciate your help .......Shyam

You must sign in to leave a comment.