[Gdal-dev] RE: ogr2ogr geodatabase translation

[Chapman, Martin]

Randy,

 

I don't know about your geodatabase but the line files I downloaded from
the ftp link you gave are geometry type 13 or PolylineZ.  Which is an
OGR wkbLineString25D.  Perhaps you have to pass a command switch to
ogr2ogr to flatten the object to 2D like the function call flatten2D(),
much like you did in your own translator.  Maybe try the -nlt option to
set the geometry to GEOMETRY or POLYGON to force the conversion. 

 

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/5da9661b/attachment.html