R Observatory: Metrics for dbSpatial version 0.1.3

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

dbSpatial

0.1.3Package record

Spatial Data Operations for Database-Backed Geometries

0packages depend

1.9Kdownloads / year

48.8%test coverage

13/13flavors OK

Overview

About

Maintained by Edward C. RuizCRAN page ↗GitHub ↗Website ↗Issues ↗

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.

Changes in 0.1.3

Bug fixes

Skip DuckDB spatial vignette chunks on CRAN. Chunks are now evaluated only when NOT_CRAN is "true", fixing vignette re-building on platforms where DuckDB extension loading is disabled.

Documentation

Add \usage sections to the st_area(), st_as_text(), st_buffer(), st_centroid(), st_length(), st_perimeter() and st_simplify() method topics and document their actual arguments.

From NEWS.md in the release

Install

R (CRAN)pak (dev)Ubuntu (r2u)Fedora (COPR)openSUSE (OBS)

install.packages("dbSpatial", repos = "https://cloud.r-project.org/")

Installs the current CRAN release. Prebuilt binaries on Windows and macOS.

if (!requireNamespace("pak", quietly = TRUE))
  install.packages("pak", repos = "https://cloud.r-project.org/")
pak::pak("dbverse-org/dbspatial-r")

Development version from dbverse-org/dbspatial-r. Installs pak first if it is not already available.

Release

# enable cranapt (r2u) if it is not already set up, then install
grep -rqs r2u.stat.illinois.edu /etc/apt/sources.list /etc/apt/sources.list.d/ \
  || curl -fsSL https://raw.githubusercontent.com/eddelbuettel/r2u/master/inst/scripts/add_cranapt_noble.sh | sudo bash
sudo apt install -y r-cran-dbspatial

Fast Ubuntu binaries via r2u (no compilation). The cranapt setup runs once and is skipped when it is already enabled. We list this channel from recorded r2u download activity rather than from a live index of the repository, so treat it as last known rather than guaranteed.

bspm (used by r2u) also needs make: sudo apt install make

# enable the iucar/cran COPR if it is not already present, then install
ls /etc/yum.repos.d/*iucar*cran*.repo >/dev/null 2>&1 \
  || sudo dnf copr enable -y iucar/cran
sudo dnf install -y R-CRAN-dbSpatial

RPMs from the iucar/cran COPR, rebuilt from CRAN.

For install.packages() integration in R, also: sudo dnf install R-CoprManager

# add the autoCRAN OBS repo (Tumbleweed) if it is missing, then install
zypper -q lr | grep -qi autoCRAN \
  || sudo zypper addrepo https://download.opensuse.org/repositories/devel:/languages:/R:/autoCRAN/openSUSE_Tumbleweed/devel:languages:R:autoCRAN.repo
sudo zypper install -y R-dbSpatial

RPMs auto-built from CRAN on openSUSE OBS (Tumbleweed). We list this channel from recorded autoCRAN download activity rather than from a live index of the repository, so treat it as last known rather than guaranteed.

Health

CRAN checks

13OK

CRAN check page ↗

Slowest check: 6.4 min · r-oldrel-macos-x86_64

Status changes

OK13 OK2026-10-17
NOTE11 OK, 2 NOTE2026-10-15
ERROR6 OK, 1 ERROR2026-05-28

Advisories

none known

How this is measured·How advisories are found

Documentation

In release 0.1.3

READMEYes · 127 wordsVignettesYes · 3 · evaluation depends on the environmentNEWSYes · 100% structured · mentions 0.1.3Citation fileNoWebsiteYes · pkgdown

Description cites an R Journal article

Help pages: 30 (3 internal)
Examples that run: 40%8 run in a plain check (7 of them under a condition) · 12 only when donttest examples are enabled (R CMD check --as-cran)
Exported functions with examples: 91%
Documented parameters: 93%
Return-value docs: 100%
Help pages citing references: 0%

Vignettes (3)

How these are measured

Downloads

1.9K

CRAN downloads in the past year

Rank #9,426 · ~5/day · ~155/mo

Releases R versions

Daily download trend is not available in this view yet.

39430 days

1K90 days

1.9K1 year

Compare downloads with other packages →

Also on30 r2u11 autocran

How downloads are counted

Repository

dbverse-org/dbspatial-r ↗Organization: dbverse-org

2Stars

0Forks

0Open issues

1Open PRs

0Releases

184Commits

1Commit identities

184 commits · Last activity 2026-06-23 · 0% stars, 30d

Responsiveness

How these are sampled

PRs merged (all time): 100%
Median days to close, 50 most recently updated closed issues: not measured
Median days to close, 50 most recently updated closed PRs: 0

Stars over time

2025-11-18 · 12026-07-07 · 2

How these are measured

PracticesBeta

8 development-tooling and community-health practices detected across 4 families in the upstream repository

Checks run against github.com/dbverse-org/dbspatial-r on 2026-10-11.

Continuous integration (1)

GitHub Actions

Docs source (4)

README.Rmdpkgdown

GitHub Pages site last deployed 2026-06-23 · The repository has a site deploy workflow

pkgdown site last built 2026-06-23, before release 0.1.3 (2026-10-14)

CRAN release process (2)

cran-comments.mdCRAN-SUBMISSION

Lint, format, editor (1)

RStudio project

How this is detected·Detection ruleset v3 (2026-09-26)

AI coding toolsBeta

This repository shows signs of AI coding tools.

GitHub Copilotfirst seen 2026-04-29
Commits: at least 11 crediting it in the message

Counts are commits, not lines of code. Commits by a tool's accounts count once across all of its accounts. Commits crediting it are the largest count among its credit lines, a minimum.How this is detected·Detection ruleset v4 (updated 2026-09-27)

Dependencies

Declared dependencies

18 external dependencies (excludes base and recommended)

Installing dbSpatial adds 53 packages (35 with compiled code, 48 MB of source tarballs). Heaviest: stringi 11 MB, sf 9.3 MB, duckdb 4.6 MB.

Depends (1)

R >= 4.1.0

Imports (17)

methodstoolsDBI duckdb dplyr dbplyr terra sf e1071 lifecycle crayon checkmate cli rlang glue tidyselect dbProject

LinkingTo (0)

none

Suggests (3)

knitr rmarkdown testthat

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

0direct

0indirect

Nothing depends on this yet.

How these are counted

Code & Tests

People & History

People (3)

Edward C. Ruiz

Author, Maintainer since 0.1.1 (2026)

Ruben Dries

Author, Reviewer

Jiaji George Chen

Author

Releases (3)

Pick two releases to compare their code metrics.

0.1.3Latest
record
2026-10-14 · current release · diff ↗ ·
listed once in CRAN's queue
Seen in one reading of CRAN's incoming queue, at 2026-10-14 19:53 UTC, so it stayed less than the time between readings.
0.1.2
record
2026-06-23 · diff ↗
0.1.1
record
2026-05-27
R
R 4.6.0 released · 2026-04-24

Across CRAN, the median accepted release of the past year spent 15 hours in the queue, 90% under 11 days.How queue time is measured

Package metadata

First published: 2026-05-27
Total releases: 3 / 1 yrs
License: GPL-3 | MIT + file LICENSE OSI
Minimum R: ≥ 4.1.0
Download size: 111 KB

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("dbSpatial")

Format

C. Ruiz, E., Dries, R., & George Chen, J. (2026). dbSpatial: Spatial Data Operations for Database-Backed Geometries (Version 0.1.3) [Computer software]. https://doi.org/10.32614/CRAN.package.dbSpatial

This package has no citation file, so citation() returns this entry built from DESCRIPTION.

Cite the R Observatory

For a number measured here: a download total, a coverage figure, an archival date.

Format

APA

Balamuta, J. J. (2026). R Observatory: Metrics for dbSpatial version 0.1.3 [Data set]. HJJB, LLC. Data release v2026-10-19. https://doi.org/10.5281/zenodo.21843040

From data release v2026-10-19, which the citation names so these numbers can be found later. More on citing and the projects behind them.

Report a problem with this page →