dbSpatial: Spatial Data Operations for Database-Backed Geometries

Provides database-backed spatial geometry classes and methods for working with vector spatial data in 'DuckDB'. The package supports loading, converting, querying, joining, and measuring spatial geometries through familiar 'sf'-style interfaces while keeping geometry columns lazy inside the database. It integrates with 'dbProject' to preserve database paths, live connections, and spatial table metadata across interactive sessions. The package follows the Simple Features framework described by Pebesma (2018) <doi:10.32614/RJ-2018-009> and uses DuckDB's spatial extension <https://duckdb.org/docs/stable/core_extensions/spatial/overview.html>.

Version:	0.1.1
Depends:	R (≥ 4.1.0)
Imports:	methods, tools, DBI, duckdb (≥ 1.4.0), dplyr, dbplyr, terra, sf, e1071, lifecycle, crayon, checkmate, cli, rlang, glue, tidyselect, dbProject
Suggests:	knitr, rmarkdown, testthat (≥ 3.0.0)
Published:	2026-05-27
DOI:	10.32614/CRAN.package.dbSpatial
Author:	Edward C. Ruiz [aut, cre], Jiaji George Chen [aut], Ruben Dries [aut, rev]
Maintainer:	Edward C. Ruiz <ecr7407 at gmail.com>
BugReports:	https://github.com/dbverse-org/dbspatial-r/issues
License:	GPL-3 | MIT + file LICENSE
URL:	https://github.com/dbverse-org/dbspatial-r, https://dbverse-org.github.io/dbspatial-r/
NeedsCompilation:	no
Materials:	README, NEWS
CRAN checks:	dbSpatial results

Documentation:

Reference manual:	dbSpatial.html , dbSpatial.pdf
Vignettes:	Class Structure (source, R code) Getting Started (source, R code) Spatial Operations (source, R code)

Downloads:

Package source:	dbSpatial_0.1.1.tar.gz
Windows binaries:	r-devel: dbSpatial_0.1.1.zip, r-release: dbSpatial_0.1.1.zip, r-oldrel: dbSpatial_0.1.1.zip
macOS binaries:	r-release (arm64): dbSpatial_0.1.1.tgz, r-oldrel (arm64): dbSpatial_0.1.1.tgz, r-release (x86_64): dbSpatial_0.1.1.tgz, r-oldrel (x86_64): dbSpatial_0.1.1.tgz

Linking:

Please use the canonical form https://CRAN.R-project.org/package=dbSpatial to link to this page.