← Back to all sparks
S

soilDBdata

ANALYTICS
Velocity0.0

R package soilDBdata by brownag — release notes from GitHub.

soilDBdata exists so soilDB's tests can run without a NASIS connection.

soil datatest fixturesnasisdata packager package
Current state
soilDBdata is a data-only package supplying NASIS and gSSURGO sample datasets as .sqlite assets, installed separately by soilDB's GitHub Actions so unit tests that would otherwise need database access can run. It began as a proof of concept carrying MT663 pedon and component tables used in soil survey coursework, and its most recent release adds a Marshall Islands FY26 gSSURGO dataset. Releases are infrequent and driven by what the parent package needs to test.
Where it's heading
Development follows soilDB rather than leading it: assets get bumped when a soilDB version changes, and purpose lists are updated when soilDB adds a table. The one release that changed what testing is possible was v0.1.1, which added selected-set _View_1 tables alongside whole tables so both SS=TRUE and SS=FALSE code paths could be exercised. Four-year gaps between releases are normal here and do not indicate abandonment — a fixture package only needs to move when the fixtures go stale.
Prediction
The recent addition is a new geography rather than a new table structure, so further releases most likely continue broadening dataset coverage as soilDB gains regions to test against.

Recent moves

  1. 3mo ago

    Marshall Islands FY26 gSSURGO dataset added

    Adds a Marshall Islands FY26 gSSURGO dataset, extending the fixtures past the continental US survey areas the package started with. The release spans five version numbers from v0.1.4, so the tag is a catch-up rather than a single change.

    View source ↗
  2. 1y ago

    MT663 fixtures refreshed for soilDB 2.8.3

    Refreshes the MT663 datasets against soilDB 2.8.3. A fixture bump keeping the sample assets aligned with the parent package, with no change to what they cover.

    View source ↗
  3. 1y ago

    NASIS purpose lists updated for siteothvegclass

    Updates the NASIS table purpose lists to match an upstream soilDB change, adding siteothvegclass and othvegclass to the default site and lookup lists. Mirrors a parent-package addition rather than introducing anything here.

    View source ↗
  4. 4y ago

    Selected-set _View_1 tables enable SS=TRUE/FALSE testing

    Adds selected-set _View_1 tables alongside the whole tables in the pedon and component .sqlite assets, which is what lets soilDB test both SS=TRUE and SS=FALSE code paths against the same fixture. Tables are also updated to NASIS data model 7.4.1.

    View source ↗
  5. 4y ago

    Proof of concept: MT663 pedon and component .sqlite fixtures

    The founding proof of concept: two .sqlite files of NASIS pedon and component tables for MT663, chosen because they appear in Stats for Soil Survey coursework and digital soil mapping exercises. It establishes the package's dual purpose — teaching material for people without NASIS access, and fixtures for soilDB tests skipped on CRAN.

    View source ↗