GetData: Get data for water quality status and trends analysis

View source: R/GetData.R

GetDataR Documentation

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.