get_site_data_from_NASIS_db {soilDB} | R Documentation |
Get Site Data from a local NASIS Database
Description
Get site-level data from a local NASIS database.
get_site_association_from_NASIS()
: Get Associated User Site IDs for each Site.
Usage
get_site_data_from_NASIS_db(
SS = TRUE,
include_pedon = TRUE,
nullFragsAreZero = TRUE,
stringsAsFactors = NULL,
dsn = NULL
)
get_site_association_from_NASIS(SS = TRUE, dsn = NULL)
Arguments
SS |
fetch data from Selected Set in NASIS or from the entire local
database (default: |
include_pedon |
Include pedon and transect data joined to site? (default: |
nullFragsAreZero |
should surface fragment cover percentages of |
stringsAsFactors |
deprecated |
dsn |
Optional: path to local SQLite database containing NASIS table structure; default: |
Details
It is possible to have multiple pedon records per site observation and multiple site observations
per site, which will result in multiple records per site. See argument include_pedon=FALSE
to
omit joins to pedon and transect tables.
The following aggregations of child table information are performed by this function:
Site Area Overlap for State, County and MLRA are returned for related area records, as specified in the site table, as the following column names:
site_state
,site_county
, andsite_mlra
.Site Observation Surface Fragment data are simplified (converted to wide format) using
simplifyFragmentData()
.The best Ecological Site History record is selected using
get_ecosite_history_from_NASIS_db(best = TRUE)
.Site Other Vegetation Class information is aggregated by class name, using
" & "
as the separator when multiple classes are assigned.When multiple Site Bedrock entries are present, only the shallowest is returned by this function. In lieu of bedrock depth the first record in the table is returned.
Value
A data.frame
Author(s)
Jay M. Skovlin, Dylan E. Beaudette, Andrew G. Brown, Greg Schmidt
See Also
get_hz_data_from_NASIS_db()
, fetchNASIS()
, fetchVegdata()