Package index • duckspatial

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 Predicates

ddbs_predicate(): Spatial predicate operations
ddbs_contains(): Spatial contains predicate
ddbs_contains_properly(): Spatial contains properly predicate
ddbs_covered_by(): Spatial covered by predicate
ddbs_covers(): Spatial covers predicate
ddbs_crosses(): Spatial crosses predicate
ddbs_disjoint(): Spatial disjoint predicate
ddbs_equals(): Spatial equals predicate
ddbs_intersects(): Spatial intersects predicate
ddbs_intersects_extent(): Spatial intersects extent predicate
ddbs_overlaps(): Spatial overlaps predicate
ddbs_touches(): Spatial touches predicate
ddbs_within(): Spatial within predicate
ddbs_within_properly(): Spatial within properly predicate

Spatial operations (binary)

ddbs_difference(): Calculates the difference of two geometries
ddbs_filter(): Performs spatial filter of two geometries
ddbs_intersection(): Calculates the intersection of two geometries
ddbs_join(): Performs spatial joins of two geometries
ddbs_interpolate_aw(): Areal-Weighted Interpolation using DuckDB

Spatial operations (unary)

ddbs_bbox(): Returns the minimal bounding box enclosing the input geometry
ddbs_boundary(): Returns the boundary of geometries
ddbs_buffer(): Creates a buffer around geometries
ddbs_centroid(): Calculates the centroid of geometries
ddbs_concave_hull(): Returns the concave hull enclosing the geometry
ddbs_convex_hull(): Returns the convex hull enclosing the geometry
ddbs_is_simple(): Check if geometries are simple
ddbs_is_valid(): Check if geometries are valid
ddbs_make_valid(): Make invalid geometries valid
ddbs_simplify(): Simplify geometries

Spatial operations (measures)

ddbs_area(): Calculates the area of geometries
ddbs_length(): Calculates the length of 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