See holes in grid for ideas on what might be going on. In many cases the source data in the cotaxmoistcl table is missing.
37.1951,-119.7879
37.0537,-117.8585
47.3549,-105.5705
36.4412,-84.1606
Think about extracting SMR from family-level taxa as backup plan.
library(soilDB)
library(SoilTaxonomy)
.sql <- "
SELECT mukey, co.cokey, compname, comppct_r, taxclname, taxmoistcl AS smr
FROM component AS co LEFT JOIN cotaxmoistcl AS ctxm ON co.cokey = ctxm.cokey
WHERE mukey = '463319'
ORDER BY comppct_r DESC;
"
x <- SDA_query(.sql)
x$ex_smr <- sapply(x$taxclname, function(i) {
unname(extractSMR(i))
})
x
See holes in grid for ideas on what might be going on. In many cases the source data in the
cotaxmoistcl
table is missing.Think about extracting SMR from family-level taxa as backup plan.