Get NASIS Record IDs from Soil Data Access — get_SDA_NASIS

Query the Soil Data Access (SDA) API for NASIS record identifiers (nasiscoiid, nasischiid) associated with map units, components, or horizons. These identifiers are available in SDA beginning with NASIS version 7.4.3 and are useful for linking SDA data to NASIS backend records.

Usage

get_SDA_NASIS_key(
  x,
  by = "mukey",
  include_chorizon = FALSE,
  query_string = FALSE,
  dsn = NULL
)

Arguments

x: A character vector of keys to match (mukey, cokey, or chkey).
by: A character string indicating the type of key provided in x. Must be one of "mukey", "cokey", or "chkey".
include_chorizon: Logical. If TRUE, join results to chorizon table to include "nasischiid". Default: FALSE but always TRUE for by="chkey".
query_string: Logical. If TRUE, return the SQL query string instead of executing it. Default: FALSE.
dsn: Optional. Path to a local database or connection object. If NULL (default), the SDA web service is used.

Value

A data.frame containing mukey, cokey, chkey, nasiscoiid, and nasischiid, or a character string if query_string = TRUE.

Details

This function is intended for use with SDA (dsn = NULL). When used with local SSURGO snapshots or other data sources, these columns may not be present.

Note

These NASIS record ID columns are only available via SDA after the October 1, 2025 refresh. They are not included in SSURGO snapshot data from Web Soil Survey unless manually added by the user.

Examples

if (FALSE) { # \dontrun{
# Get NASIS component IDs for a set of map unit keys
get_SDA_NASIS_key(c("469093"), by = "mukey")

# Get NASIS component and chorizon IDs for a set of map unit keys
get_SDA_NASIS_key(c("469093"), by = "mukey", include_chorizon = TRUE)
} # }