[gdal-dev] PGeo: Reading a single table from a .mdb file

[Frank Warmerdam]

Bob Cave wrote:
> I am using the PGeo reader in GDAL 1.7.1.  This reader always returns a layer
> for every feature class (spatial table) in the personal geodatabase, but I
> would like to be able to specify a list of tables to be returned.  The other
> OGR spatial database readers have this capability.
> 
> Is this something that is likely to be implemented soon?

Bob,

This is normally done as a performance optimization for RDBMSes which might
have a lot of tables, and for which initialization time can be significant
especially in a web mapping context.  Is your concern similar with
personal geodatabase?

I don't see any reason not to add such a capability to the PGEO driver,
but I'm not aware of anyone with this on their list of things to do.  A
patch might be well received or of course you could contract someone to
do this.

If it were to be implemented, it would mean extending the PGEO driver
to support multiple connection options, instead of just the .mdb file name.
If this were done, I'd like to see it use the same generic "wrapped options"
style of connection string as the Ingres driver.

eg.
   @driver=pgeo,file="C:\abc.mdb",tables=roads

I really ought to push this approach forward as a variety RFC to:

  http://trac.osgeo.org/gdal/wiki/rfc10_ogropen

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent