Install and/or load DuckDB spatial extension — loadSpatial • dbSpatial

Install and/or load DuckDB spatial extension

Usage

loadSpatial(
  conn,
  extension_directory = getOption("dbSpatial.extension_directory", file.path(tempdir(),
    "dbSpatial-duckdb-extensions"))
)

Arguments

conn: duckdb connection
extension_directory: Directory where DuckDB should install extensions. Defaults to a directory in the R session temporary directory. Set the dbSpatial.extension_directory option to use a different location.

Value

No return value, called for side effects. Installs and loads the DuckDB spatial extension for conn.

Examples

if (interactive() && requireNamespace("duckdb", quietly = TRUE)) {
  duckdb_conn = DBI::dbConnect(duckdb::duckdb(), ":memory:")
  DBI::dbExecute(duckdb_conn, "SET threads = 1")
  loadSpatial(conn = duckdb_conn)
  DBI::dbDisconnect(duckdb_conn, shutdown = TRUE)
}