[Gdal-dev] RE: ogr2ogr geodatabase translation

[Randy George]

This question didn't seem go through to the list. Here's a second try.

 

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";"GE
OMETRY"

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

"8009194";"''";"public";"NHDFlowline";"wkb_geometry";"2";"32767";"GEOMETRY"

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

"8012359";"''";"public";"NHDLineEventFC";"wkb_geometry";"2";"32767";"GEOMETR
Y"

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

"8012372";"''";"public";"NHDPointEventFC";"wkb_geometry";"2";"32767";"GEOMET
RY"

"8009181";"''";"public";"NHDWaterbody";"wkb_geometry";"2";"32767";"GEOMETRY"

"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";"GEOMETRY"

"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/20070131/de21492e/attachment.html