[Gdal-dev] RE: ogr2ogr geodatabase translation

[Chapman, Martin]

Randy, 

 

I may have experienced a similar problem not too long ago.  I solved the
issue but can't remember exactly how I did it.  I will download the
dataset and let you know if how I handle the data works for your
problem.  If so, I will send you the answer on how to do it.  It's
basically a wkb geometry type thing if I remember correctly.  I have
PostgreSQL 8.2 on my system.  What version are you importing to? 

 

Martin Chapman

SANZ Inc.

Software Developer

http://www.earthwhere.com

W - 303.495.6326

C  - 303.898.0397

________________________________

From: gdal-dev-bounces at lists.maptools.org
[mailto:gdal-dev-bounces at lists.maptools.org] On Behalf Of Randy George
Sent: Tuesday, February 06, 2007 12:45 PM
To: gdal-dev at lists.maptools.org
Subject: RE: [Gdal-dev] RE: ogr2ogr geodatabase translation

 

Hi,

 

            Revisiting the problem I'm experiencing using ogr2ogr 1.4.0
in FWTools 1.1.3 to translate USGS NHD data into PostGIS.

 

Looking at a typical NHDArea table of the geodatabase mdb it appears
that the Shape field's internal 'Shape Type' is listed as 19. Unless
there has been a recent change, I don't think the shp format has a type
19. I ran a test conversion to svg with my own translator forcing .shp
type 19 to a type 5 (Polygon) and I get valid polygon <paths>?

 

Has ESRI added an additional "Shape Type" to the list? 

 

If shp type 19 is unknown to the ogr translator that would explain the
empty geometry columns and sporadic empty geometry fields.

 

thanks

randy

 

________________________________

From: gdal-dev-bounces at lists.maptools.org
[mailto:gdal-dev-bounces at lists.maptools.org] On Behalf Of Randy George
Sent: Wednesday, January 31, 2007 8:33 AM
To: gdal-dev at lists.maptools.org
Subject: [Gdal-dev] RE: ogr2ogr geodatabase translation

 

 

Hi,

 

            I am attempting to translate some NHD data from
ftp://nhdftp.usgs.gov/SubRegions/ using ogr2ogr 1.4.0 in FWTools 1.1.3,
but having some problems.

 

The NHD data comes as ESRI geodatabase .mdb files. I was excited to see
that ogr2ogr now supportsESRI geodatabase mdb format and ran the
following:

 

ogr2ogr -f PostgreSQL PG:"user=user dbname=NHD host=localhost
password=password port=5432" D:\NHD\NHDH0101\NHDH0101.mdb

 

The translation went smoothly without apparent error resulting in a set
of tables with geometry_columns entries:

"8012398";"''";"public";"Basin";"wkb_geometry";"2";"32767";"GEOMETRY"

"8012493";"''";"public";"HYDRO_NET_Junctions";"wkb_geometry";"2";"32767"
;"GEOMETRY"

"8009168";"''";"public";"NHDArea";"wkb_geometry";"2";"32767";"GEOMETRY"

"8009194";"''";"public";"NHDFlowline";"wkb_geometry";"2";"32767";"GEOMET
RY"

"8012333";"''";"public";"NHDLine";"wkb_geometry";"2";"32767";"GEOMETRY"

"8012359";"''";"public";"NHDLineEventFC";"wkb_geometry";"2";"32767";"GEO
METRY"

"8012346";"''";"public";"NHDPoint";"wkb_geometry";"2";"32767";"GEOMETRY"

"8012372";"''";"public";"NHDPointEventFC";"wkb_geometry";"2";"32767";"GE
OMETRY"

"8009181";"''";"public";"NHDWaterbody";"wkb_geometry";"2";"32767";"GEOME
TRY"

"8012385";"''";"public";"Region";"wkb_geometry";"2";"32767";"GEOMETRY"

"8012436";"''";"public";"Subbasin";"wkb_geometry";"2";"32767";"GEOMETRY"

"8012417";"''";"public";"Subregion";"wkb_geometry";"2";"32767";"GEOMETRY
"

"8012480";"''";"public";"Subwatershed";"wkb_geometry";"2";"32767";"GEOME
TRY"

"8012467";"''";"public";"Watershed";"wkb_geometry";"2";"32767";"GEOMETRY
"

 

However, several of the tables, not all, have empty wkb_geometry
columns. In addition a couple of tables have incompletely translated
wkb_geometry with only some rows containing data.

 

I then tried using an ODBC DSN:

ogr2ogr -f PostgreSQL -update -overwrite PG:"user=user dbname=NHD
host=localhost password=password port=5432" PGeo:NHD Basin 

but the Basin.wkb_geometry was still empty. The Access mdb file appears
to have long binary data in a Shape column.

 

Perhaps individual tables need to be translated with a specified geom
column? 

 

Is a log generated by an ogr2ogr translation?

 

Thanks

randy

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20070206/ee758f10/attachment.html