Function to retrieve time series data with variablecode waterLevel from a specified sampling feature

Function to retrieve time series data with variablecode waterLevel from a specified sampling feature

db_get_water_level_ts(db, site_code)

Arguments

db	database connection object
site_code	site code to get water level time series for

Value

time series

Examples

# NOT RUN {
tsrv <- data.frame(
 Timestamp = c(
 "2018-06-27 13:45:00",
 "2018-06-27 13:55:00"),
  "wl" = c(1, 1.5))

db <- create_sqlite(filename = 'ts_example')

db_insert_results_ts(
  db = db,
  datavalues = tsrv,
  method = "pressureTransducer",
  site_code = "BB2",
 variables = list("wl" = list(column = "wl",
 name = "Water level",
 units = "Meter")),
  sampledmedium = "Liquid Aqueous")

 db_get_water_level_ts(db, "BB2")
# }