Skip to contents

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
)

Arguments

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.

Value

a remote tibble tbl_sql class object

Details

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

Examples

if (FALSE) { # interactive()


gbif <- gbif_local(gbif_example_data())
}