GetData: Get data for water quality status and trends analysis

In donco/odeqstatusandtrends: Analyze and Report on Water Quality Status and Trends

Get data for water quality status and trends analysis

Description

Queries the Oregon DEQ AWQMS database for water quality monitoring data fitting the given parameters. Requires permissions to the VW_AWQMS_Results view in the AWQMS repository. This query is specific to the methods used in status and trends reporting. For a more comprehensive AWQMS query, see the AWQMS package by Travis Pritchard.

Usage

GetData(
  parameters = NULL,
  stations_AWQMS,
  stations_WQP = NULL,
  start.date,
  end.date,
  huc8,
  query_nwis = FALSE,
  stations_NWIS,
  awqms.channel.name = "AWQMS"
)

Arguments

parameters	A list of parameters to include in the query
stations_AWQMS	Stations dataframe from get_stations_AWQMS()
stations_WQP	Stations dataframe from get_stations_WQP()
start.date	The earliest date to include in the query. "YYYY-MM-DD"
end.date	The latest date to include in the query. "YYYY-MM-DD"
huc8	List of hucs within boundary
query_nwis	Logical. Should the function query the USGS NWIS database.
stations_NWIS	Stations dataframe from get_stations_NWIS()
awqms.channel.name	The name in quotes of the AWQMS ODBC connection. Defaults to "AWQMS".

Value

A dataframe of all available data within AWQMS that fit the query.

Examples

GetData(parameters = c("parameter1", "parameter2"),
stations_AWQMS = result-of-get_stations_AWQMS(),
stations_WQP = result-of-get_stations_WQP(),
stations_NWIS = result-of-get_stations_NWIS(),
start.date = "2010-01-01", end.date = "2019-01-01",
awqms.channel.name = "AWQMS")

donco/odeqstatusandtrends documentation built on April 20, 2024, 12:46 a.m.