Query layer information of the cover for recordings (relevé) from INBOVEG

This function queries the INBOVEG database for layer information (layer and cover) on recordings for one or more surveys.

Usage

get_inboveg_layer_cover(connection, survey_name, multiple = FALSE)

Arguments

connection

dbconnection with the database 'Cydonia' on the inbo-sql07-prd server

survey_name

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.

multiple

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

Value

A dataframe with variables Name (of the survey), RecordingGivid (unique Id), UserReference, LayerCode, LayerDescription, CoverCode, Coverpercentage and Mean height (cm)

See also

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()

Examples

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)
} # }