Soil Geospatial Intelligence
The Munsell 10YR hue — the color of knowledge about what lies beneath.
Lab10YR delivers soil and geospatial intelligence for infrastructure operators, land investors, and conservation professionals — built on SSURGO and authoritative spatial data, interpreted by pedologists who know where the data holds and where it doesn't.
Interactive maps, NYT-style data journalism, a live SQL explorer, and a complete SSURGO schema reference — all built on America's most comprehensive soil database.
| Tool | Description |
|---|---|
| Soil Atlas | 7 intelligence story modes — live SDA profiles, texture triangle, 3D terrain |
| Data Stories | 7-chapter data journalism — carbon banks, drought resilience, karst risk |
| SQL Explorer | 258 production scripts across 14 categories, live SDA test runner |
| Data Models | D3 ER diagram of 134 SSURGO tables, sortable column browser |
| Regen Ag Map | County choropleth — Fragile Soil Index vs. Organic Matter Depletion |
| SHAPE Curves | KSSL lab data explorer — all states & territories |
A complete beginner-to-expert curriculum for SSURGO and the Soil Data Access REST API. Every lesson runs live against the real SDA database — no data files, no installs.
| Track | Content |
|---|---|
| Beginner SQL | SELECT · WHERE · COUNT · dominant component queries |
| Intermediate SQL | JOINs · GROUP BY · CTEs · Available Water Storage |
| Expert SQL | Soil Organic Carbon formula · NCCPI · FSI · spatial AOI |
| Python API | requests · pandas · batch queries · matplotlib pipeline |
| JavaScript API | fetch() · live tables · MapLibre GL · SDAClient module |
| Query Lab | Live SDA sandbox — 8 preloaded examples, run any SQL instantly |
Every query in this ecosystem follows this spine:
FROM legend l
INNER JOIN mapunit mu ON mu.lkey = l.lkey
INNER JOIN component c ON c.mukey = mu.mukey
LEFT JOIN chorizon ch ON ch.cokey = c.cokey
WHERE l.areasymbol = 'WI025' -- survey area
AND c.majcompflag = 'Yes' -- dominant soil onlyinfo@lab10yr.com · lab10yr.com
Soil corrosivity · Hydric soils · Geohazard scoring · Prime farmland · Due diligence · Custom SDA modeling