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 spatial vector data from DuckDB into R
ddbs_write_vector()
Write an SF Object to a DuckDB Database
ddbs_register_vector()
Register an SF Object as an Arrow Table in DuckDB

Spatial operations (binary)

ddbs_difference()
Calculates the difference of two geometries
ddbs_intersection()
Calculates the intersection of two geometries
ddbs_join()
Performs spatial joins of two geometries

Spatial operations (unary)

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

Spatial operations (measures)

ddbs_area()
Calculates the area of geometries
ddbs_length()
Calculates the length of geometries

Data manipulation

ddbs_filter()
Spatial Filter
ddbs_join()
Performs spatial joins of two geometries

SQL wrappers

ddbs_create_conn()
Create a duckdb connection
ddbs_stop_conn()
Close a duckdb connection
ddbs_create_schema()
Check and create schema
ddbs_crs()
Check CRS of a table
ddbs_drivers()
Get list of GDAL drivers and file formats
ddbs_glimpse()
Check first rows of the data
ddbs_list_tables()
Check tables and schemas inside a database