Step 1
Build a guided query
This prototype uses curated SQL through a local proxy. The API seam
is ready for a server-side R soilDB worker once that
runtime is containerized.
R-first soil data lab
Start an R session in your browser, edit and run a soil-profile
example, then inspect the soilDB::SDA_query() pattern
this prototype is preparing to run through a server-side R worker.
> library(soilDB) > soils <- SDA_query(sql) > head(soils) areasymbol musym muname 1 UT621 1000 Parleys loam
Interactive R session
A pinned webR runtime executes base R locally. This first example turns horizon observations into a small soil profile summary—no server execution and no data upload.
Browser R is not initialized. Select “Initialize browser R” to start the local runtime.
The server-R destination
soilDB query recipeThis is the R workflow the web wrapper is designed to expose safely. It uses a bounded area-symbol query and returns an R data frame from USDA Soil Data Access.
soilDB package and its compiled dependencies
belong in the planned server-side R worker. Browser R above supports
the local base-R experiment today.
soilDB installed.
area_symbol <- "UT621"
sql <- sprintf("
SELECT TOP 25
l.areasymbol, mu.musym, mu.muname, mu.mukey
FROM legend AS l
INNER JOIN mapunit AS mu ON l.lkey = mu.lkey
WHERE l.areasymbol = '%s'
ORDER BY mu.musym
", area_symbol)
soils <- soilDB::SDA_query(sql)
head(soils)
Guided web workflow
Choose a county or survey code below. The local API validates the input, sends curated SQL to USDA, and returns the records with provenance.
Step 1
This prototype uses curated SQL through a local proxy. The API seam
is ready for a server-side R soilDB worker once that
runtime is containerized.
Step 2
Step 3