search

r-spatial / sfdbi

DBI interface to sf
https://r-spatial.github.io/sfdbi/
Other
53 stars 0 forks source link

Backend request: GDB #3

Open noamross opened 3 years ago

noamross commented 3 years ago

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 commented 3 years ago

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 commented 3 years ago

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.