R/get_inboveg_layer_cover.R
get_inboveg_layer_cover.RdThis function queries the INBOVEG database for layer information (layer and cover) on recordings for one or more surveys.
get_inboveg_layer_cover(connection, survey_name, multiple = FALSE)dbconnection with the database 'Cydonia'
on the inbo-sql07-prd server
A character string or a character vector, depending on multiple parameter, giving the name or names of the survey(s) for which you want to extract recordings information. If missing, all surveys are returned.
If TRUE, survey_name can take a character vector with multiple survey names that must match exactly. If FALSE (the default), survey_name must be a single character string (one survey name) that can include wildcards to allow partial matches
A dataframe with variables
Name (of the survey),
RecordingGivid (unique Id),
UserReference,
LayerCode,
LayerDescription,
CoverCode,
Coverpercentage and
Mean height (cm)
Other inboveg:
get_inboveg_classification(),
get_inboveg_header(),
get_inboveg_layer_qualifier(),
get_inboveg_ppa(),
get_inboveg_qualifier(),
get_inboveg_recording(),
get_inboveg_relation_recording(),
get_inboveg_survey()
if (FALSE) { # \dontrun{
library(inbodb)
con <- connect_inbo_dbase("D0010_00_Cydonia")
# get the layer information from one survey
layerinfo_heischraal2012 <- get_inboveg_layer_cover(con, survey_name =
"MILKLIM_Heischraal2012")
# get all layer qualifiers from MILKLIM surveys (partial matching)
layerinfo_milkim <- get_inboveg_layer_cover(con, survey_name = "%MILKLIM%")
# get layer qualifiers from several specific surveys
layerinfo_severalsurveys <- get_inboveg_layer_cover(con, survey_name =
c("MILKLIM_Heischraal2012", "NICHE Vlaanderen"), multiple = TRUE)
# get all layer qualifiers of all surveys
all_layerinfo <- get_inboveg_layer_cover(con)
# Close the connection when done
dbDisconnect(con)
rm(con)
} # }