sfdbi
sfdbi copied to clipboard
DBI interface to sf
This is exactly the the package I've been looking for, it looks great. Do you plan on adding support for two-table functions like `st_join()` and `st_intersects()`?
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.
Google's BigQuery supports spatial queries https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions
`SFSQL()` wraps the basic sql query to `read_sf()`, passing in the DSN argument in the usual way (file, url, connection string) with a dummy `layer` value. `SFSQL_PG()` adds another level...