search

rouault / dump_gdbtable

Python script to dump the content of a .gdbtable
138 stars 24 forks source link

Un-parseable file db #4

Closed forkandwait closed 10 years ago

forkandwait commented 10 years ago

Hi there,

I have been using the excellent ogr2ogr gdb extension, but I found a database that it can't open, the Washington state soils database downloads (both statewide and per-county):

https://fortress.wa.gov/dnr/app1/dataweb/dmmatrix.html#Soils

Note that I found geometry problems even after opening in ESRI and exporting to shapefile and playing with that using ogr2ogr.

Not sure where else to post this, will also post to the GDAL trac site.

Thanks!

rouault commented 10 years ago

Works for me with https://fortress.wa.gov/dnr/app1/data/itd/Asotin_soils.zip :

and python dump_gdbtable/dump_gdbtable.py Asotin_soils/soils.gdb/a00000027.gdbtable

forkandwait commented 10 years ago

Here is what I just ran that generated errors (silly windows machine at work via mingw). (I don't have python in my path yet, so I haven't experimented with the python scripts):

GDAL_experiments/ (j=0,r=1)$ ogrinfo --version GDAL 1.12dev, released 2014/04/16

GDAL_experiments/ (j=0,r=1)$ ogrinfo -al 'C:\Users\webbs\Desktop\GDAL_experiments\Asotin_soils\Asotin_soils\soils.gdb' ERROR 1: Error: Failed to open Geodatabase (This release of the GeoDatabase is either invalid or out of date.)

ERROR 1: Error: Failed to open Geodatabase (This release of the GeoDatabase is either invalid or out of date.)

FAILURE: Unable to open datasource `C:\Users\webbs\Desktop\GDAL_experiments\Asotin_soils\Asotin_soils\soils.gdb' with the following drivers. -> FileGDB

Thanks!
rouault commented 10 years ago

It looks like you don't have the OpenFileGDB driver configured for some reason. Try adding "-ro" to your ogrinfo command line.

forkandwait commented 10 years ago

I tried add "-ro" and it still fails. ... (edit:) until I uninstall the file GDB add in based on ESRI's SDK (must have been defaulting to that)! Good work on your part!

Getting my binaries here:

http://www.gisinternals.com/sdk/PackageList.aspx?file=release-1600-x64-gdal-mapserver.zip

rouault commented 10 years ago

Does OpenFileGDB appears in "ogrinfo --formats" ? It should normally. If it doesn't then it is likely a configuration problem.

forkandwait commented 10 years ago

Yes, it does now. I think ogrXXX was hitting FileGDB first. I am inexperienced with GDAL, so I don't know why.