get_SDA_coecoclass: Get mapunit ecological sites from Soil Data Access

In soilDB: Soil Database Interface

Get mapunit ecological sites from Soil Data Access

Description

get_SDA_coecoclass() retrieves ecological site information from the Soil Data Access (SDA) database for a given set of map unit keys (mukeys). It returns a data frame containing ecological site IDs, names, and associated classification details, enabling users to link soil map units to ecological site concepts used in land management and conservation planning.

Usage

get_SDA_coecoclass(
  method = "None",
  areasymbols = NULL,
  mukeys = NULL,
  WHERE = NULL,
  query_string = FALSE,
  ecoclasstypename = c("NRCS Rangeland Site", "NRCS Forestland Site"),
  ecoclassref = "Ecological Site Description Database",
  not_rated_value = "Not assigned",
  miscellaneous_areas = TRUE,
  include_minors = TRUE,
  threshold = 0,
  dsn = NULL
)

Arguments

method	aggregation method. One of: "Dominant Component", "Dominant Condition", "All" or "None" (default). If method="all" multiple numbered columns represent site composition within each map unit e.g. site1..., site2.... If method="none" is selected one row will be returned per component; in all other cases one row will be returned per map unit.
areasymbols	vector of soil survey area symbols
mukeys	vector of map unit keys
WHERE	character containing SQL WHERE clause specified in terms of fields in legend, mapunit, component or coecosite tables, used in lieu of mukeys or areasymbols
query_string	Default: FALSE; if TRUE return a character string containing query that would be sent to SDA via SDA_query
ecoclasstypename	Default: c("NRCS Rangeland Site", "NRCS Forestland Site"). If NULL no constraint on ecoclasstypename is used in the query.
ecoclassref	Default: "Ecological Site Description Database". If NULL no constraint on ecoclassref is used in the query.
not_rated_value	Default: "Not assigned"
miscellaneous_areas	logical. Include miscellaneous areas (non-soil components)?
include_minors	logical. Include minor components? Default: TRUE.
threshold	integer. Default: 0. Minimum combined component percentage (RV) for inclusion of a mapunit's ecological site in wide-format tabular summary. Used only for method="all".
dsn	Path to local SQLite database or a DBIConnection object. If NULL (default) use Soil Data Access API via SDA_query().

Details

When method="Dominant Condition" an additional field ecoclasspct_r is returned in the result with the sum of comppct_r that have the dominant condition ecoclassid. The component with the greatest comppct_r is returned for the component and coecosite level information.

Note that if there are multiple coecoclasskey per ecoclassid there may be more than one record per component.

Examples

# Basic usage with a vector of mukeys
get_SDA_coecoclass(mukeys = c(463994, 463995))

# Using a custom WHERE clause (all "range" sites in Hawaii)
get_SDA_coecoclass(WHERE = "ecoclassid LIKE 'R%' AND areasymbol LIKE 'HI%'")

soilDB documentation built on Aug. 30, 2025, 1:08 a.m.