queryDataSNOT: queryDataSNOT

In Rosalien/toolboxApps: Functions used for build shiny apps for SNO-Tourbières

Description

Sql query to extrat values of variable from site/station and period selected

Usage

queryDataSNOT(
  pool,
  variableSelected,
  siteSelected,
  periodeSelected,
  melted = TRUE
)

Arguments

pool	data base configuration (from confConnexion function)
variableSelected	String of variable code selected in application (ex. "FC" or c("FC","FCH4"))#'
siteSelected	String of site/station code selected in application (ex. "lgt/ec1" or c("lgt/ec1","lgt/bm1"))
periodeSelected	Vector string of period selected with "yyyy-mm-dd" format (ex. c("2008-01-15","2014-05-25"))
melted	Logical. If TRUE convert melt data.table. If FALSE, no melt (used for dataset-archive)

Value

data.table of values

Rosalien/toolboxApps documentation built on Oct. 30, 2020, 7:07 a.m.