Load Sanctuaries

TODO: load into single aois using hstore

Use PostgreSQL hstore to store the many varying fields of any given AOI feature into a single column, say keys.

See issue #13: load areas of interest into single aois table using hstore, starting with sanctuaries.

Sanctuaries

• Sanctuaries with spatial information — sanctuaries • onmsR

source(here::here("libs/db.R")) # defines variables: con, dir_gdrive
librarian::shelf(
  glue, here, mapview, sf)
mapviewOptions(fgb = FALSE)

# source: https://github.com/noaa-onms/onmsR/blob/master/data/sanctuaries.rda
# sanctuaries_rda <- "/share/data/ONMS-Sanctuaries/sanctuaries.rda"
sanctuaries_rda <- "~/Github/noaa-onms/onmsR/data/sanctuaries.rda"

load(file=sanctuaries_rda)
sanctuaries <- sanctuaries %>% select(-spatial)
mapview(sanctuaries)