R Interface to 'DuckDB' Database with Spatial Extension
Converts from data frame to sf using WKB conversion
Converts from data frame to sf
Check if a supported DuckDB connection
Calculates the area of geometries
Convert geometries to hexadecimal Well-Known Binary (HEXWKB) format
Convert geometries to Well-Known Text (WKT) format
Convert geometries to Well-Known Binary (WKB) format
Returns the minimal bounding box enclosing the input geometry
Returns the boundary of geometries
Creates a buffer around geometries
Calculates the centroid of geometries
Combine geometries into a single MULTI-geometry
Returns the concave hull enclosing the geometry
Spatial contains properly predicate
Spatial contains predicate
Returns the convex hull enclosing the geometry
Spatial covered by predicate
Spatial covers predicate
Create a DuckDB connection with spatial extension
Check and create schema
Spatial crosses predicate
Check CRS of a table
Calculates the difference of two geometries
Spatial disjoint predicate
Returns the distance between two geometries
Get list of GDAL drivers and file formats
Returns the envelope (bounding box) of geometries
Spatial equals predicate
Extracts the exterior ring of polygon geometries
Performs spatial filter of two geometries
Flip geometries horizontally or vertically
Generate random points within geometries
Check first rows of the data
Checks and installs the Spatial extension
Areal-Weighted Interpolation using DuckDB
Calculates the intersection of two geometries
Spatial intersects extent predicate
Spatial intersects predicate
Check if geometries are simple
Check if geometries are valid
Within Distance predicate
Performs spatial joins of two geometries
Calculates the length of geometries
Check tables and schemas inside a database
Loads the Spatial extension
Creates polygons from linestring geometries
Make invalid geometries valid
Spatial overlaps predicate
Spatial predicate operations
Convert geometries to QuadKey tiles
Load spatial vector data from DuckDB into R
Register an SF Object as an Arrow Table in DuckDB
Rotate 3D geometries around an axis
Rotate geometries around centroid
Scale geometries by X and Y factors
Shear geometries
Shift geometries by X and Y offsets
Simplify geometries
Close a duckdb connection
Spatial touches predicate
Transform coordinate reference system of geometries
Union of geometries
Spatial within properly predicate
Spatial within predicate
Write an SF Object to a DuckDB Database
Feedback for query success
Get column names in a DuckDB database
Get names for the query
Gets predicate name
Feedback for overwrite argument
Fast & memory-efficient functions to analyze and manipulate large spatial data data sets. It leverages the fast analytical capabilities of 'DuckDB' and its spatial extension (see <https://duckdb.org/docs/stable/core_extensions/spatial/overview>) while maintaining compatibility with R’s spatial data ecosystem to work with spatial vector data.
Useful links