Backend request: GDB

[noamross]

It would be great to be able to use a spatial query based on an sf object on a .gdb database without reading the whole thing from disk.

[edzer]

I'm not sure you can read .gdb with a DBI interface, but you can with GDAL; see https://github.com/mdsumner/lazysf from @mdsumner for a shot at this (using the query argument in sf::read_sf).

[mdsumner]

You can use dbConnect with GDB - lazysf() is a frontend - but fwiw it's not a "real database" from GDAL's perspective, it works through virtual translation, so GDAL's specials FID, OGR_GEOMETRY etc are available, there's no native SQL to pass through.