Package: dbSpatial 0.1.2

Edward C. Ruiz

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>.

Authors:Edward C. Ruiz [aut, cre], Jiaji George Chen [aut], Ruben Dries [aut, rev]

dbSpatial_0.1.2.tar.gz
dbSpatial_0.1.2.zip(r-4.7)dbSpatial_0.1.2.zip(r-4.6)dbSpatial_0.1.2.zip(r-4.5)
dbSpatial_0.1.2.tgz(r-4.6-any)dbSpatial_0.1.2.tgz(r-4.5-any)
dbSpatial_0.1.2.tar.gz(r-4.7-any)dbSpatial_0.1.2.tar.gz(r-4.6-any)
dbSpatial_0.1.2.tgz(r-4.6-emscripten)
manual.pdf |manual.html
DESCRIPTION |NEWS
card.svg |card.png
dbSpatial/json (API)

# Install 'dbSpatial' in R:
install.packages('dbSpatial', repos = c('https://dbverse-org.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/dbverse-org/dbspatial-r/issues

Pkgdown/docs site:https://dbverse-org.github.io

On CRAN:

Conda:

5.66 score 2 stars 11 scripts 514 downloads 14 exports 56 dependencies

Last updated from:b027088c71. Checks:9 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-x86_64OK272
source / vignettesOK253
linux-release-x86_64OK279
macos-release-arm64OK160
macos-oldrel-arm64OK170
windows-develOK202
windows-releaseOK191
windows-oldrelOK174
wasm-releaseOK130

Exports:as_dbSpatialdbSpatialheadloadSpatialst_as_geojsonst_geometrytypest_npointsst_translatest_xst_xmaxst_yst_ymaxtailvect

Dependencies:askpassbackportsblobcheckmateclassclassIntcliconnectionscpp11crayoncurlDBIdbplyrdbProjectdigestdplyrduckdbe1071fsgenericsgluehttrjsonliteKernSmoothlifecyclemagrittrMASSmimeopensslpillarpinspkgconfigproxypurrrR6rappdirsRcpprlangrscontracts2sfstringistringrsysterratibbletidyrtidyselectunitsutf8uuidvctrswhiskerwithrwkyaml

Class Structure
Minimal example

Last update: 2026-06-23
Started: 2024-01-03

Getting Started
Introduction | Creating a DuckDB connection | Reading in spatial data from various sources | From data.frames | From .csv file | From {terra} objects: SpatVector

Last update: 2026-06-23
Started: 2024-01-03

Spatial Operations
Setup | Geometry Operations | Measurements | Spatial Joins | Convert to sf

Last update: 2026-06-23
Started: 2024-01-03

Readme and manuals

Help Manual

Help pageTopics
Column extraction for dbSpatial$,dbSpatial-method
Convert an sf or terra object to a 'dbSpatial' objectas_dbSpatial
Create a 'dbSpatial' object with geometry data typedbSpatial dbSpatial-class
dbSpatial Package Global OptionsdbSpatial-options dbSpatial_options
head method for dbSpatialhead,dbSpatial-method
Install and/or load DuckDB spatial extensionloadSpatial
show method for dbSpatialshow,dbSpatial-method
Get area of geometriesst_area
Convert to GeoJSONst_as_geojson st_as_geojson.dbSpatial
Convert dbSpatial objects to sf objectsst_as_sf.dbSpatial
Convert to WKTst_as_text
Compute bounding box for dbSpatial objectst_bbox st_bbox.dbSpatial
Compute buffer around geometryst_buffer
Compute centroid of geometryst_centroid
Get geometry types (DuckDB-native)st_geometrytype
Spatial join for dbSpatial objectsst_join.dbSpatial
Get length of geometriesst_length
Get number of pointsst_npoints st_npoints,dbSpatial-method
Get perimeter of geometriesst_perimeter
Simplify geometryst_simplify
Translate x, y coordinates by delta x, delta y for point geometriesst_translate st_translate,dbSpatial-method
Get X coordinatest_x st_x,dbSpatial-method
Get maximum x coordinatest_xmax st_xmax,dbSpatial-method
Get Y coordinatest_y st_y,dbSpatial-method
Get maximum y coordinatest_ymax st_ymax,dbSpatial-method
tail method for dbSpatialtail,dbSpatial-method
Create SpatVector objectsvect,dbSpatial-method