Quality Control and Analysis of Massachusetts Water Quality Data
Analyze trends by date in results file
Analyze results with maps
Analyze outliers in results file
Analyze outliers in results file for all parameters
Analyze seasonal trends in results file
Analyze data by sites in results file
Check data quality objective accuracy data
Check data quality objective frequency and completeness data
Check water quality monitoring results
Check site metadata file
Check water quality exchange (wqx) metadata input
Format data quality objective accuracy data
Format data quality objective frequency and completeness data
Format water quality monitoring results
Format WQX metadata input
Run quality control accuracy checks for water quality monitoring resul...
Run quality control completeness checks for water quality monitoring r...
Run quality control frequency checks for water quality monitoring resu...
Create the quality control review report
Read data quality objectives for accuracy from an external file
Read data quality objectives for frequency and completeness from an ex...
Read water quality monitoring results from an external file
Create summary spreadsheet of the water quality monitoring results
Read site metadata from an external file
Read water quality exchange (wqx) metadata input from an external file
Create a formatted table of quality control accuracy checks
Create a formatted table of quality control completeness checks
Create a formatted table of quality control frequency checks
Create and save tables in a single workbook for WQX upload
Filter results data by parameter, date range, site, result attributes,...
Filter results data to surface measurements
Prep results data for frequency checks
Load external file from remote source, fail gracefully
Utility function to import data as paths or data frames
Check if required inputs are present for a function
Fill results data as BDL or AQL with appropriate values
Identify outliers in a numeric vector
Verify summary function
Summarize a results data frame by a grouping variable
Get threshold lines from thresholdMWR
Format the title for analyze functions
Check if incomplete range in Value Range column
Get logical value for y axis scaling
Methods for quality control and exploratory analysis of surface water quality data collected in Massachusetts, USA. Functions are developed to facilitate data formatting for the Water Quality Exchange Network <https://www.epa.gov/waterdata/water-quality-data-upload-wqx> and reporting of data quality objectives to state agencies. Quality control methods are from Massachusetts Department of Environmental Protection (2020) <https://www.mass.gov/orgs/massachusetts-department-of-environmental-protection>.
Useful links