Changelog

Source: NEWS.md

duckspatial 0.2.0999 dev

MAJOR CHANGES

• conn argument defaults now to NULL. This parameter is not mandatory anymore in spatial operations, and it will be handled internally. The argument has been moved after x and y arguments.

• ddbs_filter(): uses intersects for ST_Intersects instead of intersection.

• Allow the use of either sf object or a DuckDB table as input/output in every operation.

• Functions that use x and y arguments, can indistinctively use sf, DuckDB table name, or mixed.

NEW FEATURES

• ddbs_boundary(): returns the boundary of geometries.

• ddbs_concave_hull(): new function to create the concave hull enclosing a geometry.

• ddbs_convex_hull(): new function to create the convex hull enclosing a geometry.

• ddbs_create_conn(): new convenient function to create a DuckDB connection.

• ddbs_drivers(): get list of GDAL drivers and file formats supported by DuckDB spatial extension.

• ddbs_join(): new function to perform spatial join operations.

• ddbs_length(): adds a new column with the length of the geometries

• ddbs_area(): adds a new column with the area of the geometries

• ddbs_is_valid(): adds a new logical column asserting the simplicity of the geometries

• ddbs_is_valid(): adds a new logical column asserting the validity of the geometries

• ddbs_make_valid(): makes the geometries valid

• ddbs_simplify(): makes the geometries simple

• ddbs_bbox(): calculates the bounding box

• Spatial predicates: spatial predicates are all included in a function called ddbs_predicate(), where the user can specify the spatial predicate. Another option, it’s to use the spatial predicate function, such as ddbs_intersects(), ddbs_crosses(), ddbs_touches(), etc.

MINOR CHANGES

• All functions now have a parameter quiet that allows users to suppress informational messages. Closed #3

duckspatial 0.2.0

CRAN release: 2025-04-29

NEW FEATURES

• ddbs_read_vector(): gains a new argument clauses to modify the query from the table (e.g. “WHERE …”, “ORDER BY…”)

NEW FUNCTIONS

• ddbs_list_tables(): lists table schemas and tables inside the database

• ddbs_glimpse(): check first rows of a table

• ddbs_buffer(): calculates the buffer around the input geometry

• ddbs_centroid(): calculates the centroid of the input geometry

• ddbs_difference(): calculates the geometric difference between two objects

IMPROVEMENTS

• ddbs_intersection(): overwrite argument defaults to FALSE instead of NULL

• Better schemas management. Added support for all functions.

duckspatial 0.1.0

CRAN release: 2025-04-19

• Initial CRAN submission.