Skip to contents

Spatial extension

ddbs_install()
Checks and installs the Spatial extension
ddbs_load()
Loads the Spatial extension

Read/Write

ddbs_read_vector()
Load vectorial data from DuckDB into R
ddbs_write_vector()
Write an SF Object to a DuckDB Database

Binary operations

ddbs_difference()
Calculates the difference of two geometries
ddbs_filter()
Spatial Filter
ddbs_intersection()
Calculates the intersection of two geometries

Unary Operations

ddbs_buffer()
Creates a buffer around geometries
ddbs_centroid()
Calculates the centroid of geometries

SQL wrappers

ddbs_create_schema()
Check and create schema
ddbs_crs()
Check CRS of a table
ddbs_glimpse()
Check first rows of the data
ddbs_list_tables()
Check tables and schemas inside a database