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.