clean_data: Clean data retrieved from AWQMS

In TravisPritchardODEQ/TMDLMrkdwn: Functions to support plots and summaries used for Oregon DEQ's TMDLs

Clean data retrieved from AWQMS

Description

Removes unnecessary variables, checks data for quality, converts ug/L to mg/L and degrees Fahrenheit to degrees Celsius, adds "sample_datetime" and "sample_id" columns. Updates 'Temp_Criteria' column to 13 during spawning period. Sorts data by 'MLocID', 'Char_Name', and 'sample_datetime' columns See DEQ09-LAB-006-QAG; Version 3.0 and https://www.oregon.gov/deq/wq/Documents/wqmAWQMSguide.pdf for explanation of DQLs and result status.

Usage

clean_data(
  data,
  dql = c("A", "B", "E"),
  result_status = c("Final", "Provisional")
)

Arguments

data	The result of an Oregon DEQ AWQMS query.
dql	Vector of acceptable data quality levels. Can be any of 'A', 'B', 'C', 'D', E', 'F', or NA
result_status	Vector of acceptable results tats. Can be any of 'Final', 'Preliminary', 'Rejected', 'Validated', or 'Provisional'.

Value

A slimmer data frame checked for quality.

TravisPritchardODEQ/TMDLMrkdwn documentation built on Jan. 17, 2024, 5:32 a.m.