Local connection to a downloaded GBIF Parquet database

Usage

gbif_local(
  dir = gbif_parquet_dir(version = gbif_version(local = TRUE)),
  tblname = "gbif",
  backend = "duckdb",
  safe = TRUE
)

dir: the directory containing all parquet files to be read
tblname: name of the table to be created in the duckdb VIEW
backend: Use arrow or duckdb as backend connection?
safe: logical, default TRUE. Should we exclude columns mediatype`` and issue`? varchar datatype on these columns substantially slows downs queries.

a remote tibble tbl_sql class object

A summary of this GBIF data, along with column meanings can be found at https://github.com/gbif/occurrence/blob/master/aws-public-data.md

if (FALSE) { # interactive()


gbif <- gbif_local(gbif_example_data())
}