This is an outdated version published on November 7, 2024. Read the most recent version.

SentemQC - A novel and cost-efficient method for quality assurance and quality control of high-resolution frequency sensor data in fresh waters

List of Authors

  1. Sofie Gyritia Madsen van't Veen ,  
  2. Brian Kronvang ,  
  3. Joachim Audet ,  
  4. Thomas Alexander Davidson ,  
  5. Erik Jeppesen ,  
  6. Esben Astrup Kristensen
    ,  
  7. Søren Erik Larsen
    ,  
  8. Jane Rosenstand Laugesen
    ,  
  9. Eti Ester Levi ,  
  10. Anders Nielsen
    ,  
  11. Peter Mejlhede Andersen
Article Authors & roles Authors Peer review record Peer review Metrics
Cite

Abstract

The growing use of sensors in fresh waters for water quality measurements generates an increasingly large amount of data that requires quality assurance (QA)/quality control (QC) before the results can be exploited. Such a process is often resource-intensive and may not be consistent across users and sensors. SentemQC (QA-QC of high temporal resolution sensor data) is a cost-efficient, and open-source Python approach developed to ensure the quality of sensor data by performing data QA and QC on large volumes of high-frequency (HF) sensor data. The SentemQC method is computationally efficient and features a six-step user-friendly setup for anomaly detection. The method marks anomalies in data using five moving windows. These windows connect each data point to neighboring points, including those further away in the moving window. As a result, the method can mark not only individual outliers but also clusters of anomalies. Our analysis shows that the method is robust for detecting anomalies in HF sensor data from multiple water quality sensors measuring nitrate, turbidity, oxygen, and pH. The sensors were installed in three different freshwater ecosystems (two streams and one lake) and experimental lake mesocosms. Sensor data from the stream stations yielded anomaly percentages of 0.1%, 0.1%, and 0.2%, which were lower than the anomaly percentages of 0.5%, 0.6%, and 0.8% for the sensors in Lake and mesocosms, respectively. While the sensors in this study contained relatively few anomalies (<2%), they may represent a best-case scenario in terms of use and maintenance. SentemQC allows the user to include the individual sensor uncertainty/accuracy when performing QA-QC. However, SentemQC cannot function independently. Additional QA-QC steps are crucial, including calibration of the sensor data to correct for zero offsets and implementation of gap-filling methods prior to the use of the sensor data for determination of final real-time concentrations and load calculations.

Plain Language Summary

SentemQC is an open-source Python tool designed to ensure the quality of high-frequency sensor data. The purpose of the method is to clean and perform quality assurance (QA) and quality control (QC) on large volumes of data such as high-frequency data with data points down to every minute. SentemQC is computationally efficient and user-friendly, making it suitable for processing extensive datasets quickly. At the same time, SentemQC features a straightforward five-step setup, making it accessible even for non-experts to perform anomaly detection. The method identifies anomalies using five moving windows calculating the mean or median in each window which is used to detect and mark the anomalies in the dataset. Our results show that the method works well for water quality data (nitrate, turbidity, oxygen, and pH) in various freshwater ecosystems such as lakes, streams, and experimental ponds. This means that the method is robust. However, SentemQC is not standalone as additional steps like calibration and gap-filling in the dataset are necessary for the final cleaning of the data to perform for example load calculations. In summary, SentemQC is a valuable tool for maintaining data quality, however, it should be considered as a part of a broader QA-QC process.

Corresponding author
Sofie Gyritia Madsen van't Veen
0000-0003-0867-044X
Grant information

This project has received funding from the European Union’s Horizon 2020 research and innovation programme under grant agreement No 101060020 (Nitrogen and phosphorus load reduction approach within safe ecological boundaries for the Nordic-Baltic region [NORDBALT-ECOSAFE]), grant agreement No 731065 (Network of Leading European AQUAtic MesoCOSM Facilities Connecting Mountains to Oceans from the Arctic to the Mediterranean [AQUACOSM]), and grant agreement No 871081 (Network of Leading Ecosystem Scale Experimental AQUAtic MesoCOSM Facilities Connecting Rivers, Lakes, Estuaries and Oceans in Europe and beyond [AQUACOSM-plus]), and from the Innovation Fund Denmark from the Industrial Researcher programme under grant agreement No 0153-00078B (Sensors application for high temporal resolution monitoring in Danish streams [SENTEM]), and by AnaEE, Denmark.

The funders had no role in study design, data collection and analysis, decision to publish, or preparation of the manuscript.

Copyright
© 2024 Sofie Gyritia Madsen van't Veen (Corresponding Author, Co-Author); Brian Kronvang (Co-Author); Joachim Audet (Co-Author); Thomas Alexander Davidson (Co-Author); Erik Jeppesen (Co-Author); Esben Astrup Kristensen (Co-Author); Søren Erik Larsen (Co-Author); Jane Rosenstand Laugesen (Co-Author); Eti Ester Levi (Co-Author); Anders Nielsen (Co-Author); Peter Mejlhede Andersen (Co-Author) Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

First version published
Latest version published

Comments

Authors & roles

Sofie Gyritia Madsen van't Veen

Nature and water environment, Envidan A/S, Silkeborg, DK-8600, Denmark

Department of Ecoscience, Aarhus University, Aarhus, DK-8000, Denmark

Roles
Corresponding Author, Co-Author, Conceptualization, Data Curation, Formal Analysis, Methodology, Resources, Software, Validation, Visualization, Writing – Original Draft Preparation, Writing – Review & Editing
0000-0003-0867-044X

Brian Kronvang

Department of Ecoscience, Aarhus University, Aarhus, DK-8000, Denmark

Roles
Co-Author, Conceptualization, Funding Acquisition, Investigation, Methodology, Project Administration, Supervision, Validation, Writing – Review & Editing
0000-0003-1165-1354

Joachim Audet

Department of Ecoscience, Aarhus University, Aarhus, DK-8000, Denmark

Roles
Co-Author, Conceptualization, Investigation, Methodology, Supervision, Writing – Review & Editing
0000-0001-5839-8793

Thomas Alexander Davidson

Department of Ecoscience, Aarhus University, Aarhus, DK-8000, Denmark

Roles
Co-Author, Data Curation, Project Administration, Resources, Writing – Review & Editing
0000-0003-2326-1564

Erik Jeppesen

Department of Ecoscience, Aarhus University, Aarhus, DK-8000, Denmark

Roles
Co-Author, Project Administration, Resources, Supervision, Writing – Review & Editing
0000-0002-0542-369X

Esben Astrup Kristensen

Nature and water environment, Envidan A/S, Silkeborg, DK-8600, Denmark

Roles
Co-Author, Funding Acquisition, Project Administration, Supervision, Writing – Review & Editing

Søren Erik Larsen

Department of Ecoscience, Aarhus University, Aarhus, DK-8000, Denmark

Roles
Co-Author, Methodology, Software, Supervision, Validation, Writing – Review & Editing

Jane Rosenstand Laugesen

Nature and water environment, Envidan A/S, Silkeborg, DK-8600, Denmark

Roles
Co-Author, Funding Acquisition, Project Administration, Supervision, Writing – Review & Editing

Eti Ester Levi

Department of Ecoscience, Aarhus University, Aarhus, DK-8000, Denmark

Roles
Co-Author, Resources, Writing – Review & Editing
0000-0001-9038-7285

Anders Nielsen

WaterITech Aps, Skanderborg, DK-8660, Denmark

Roles
Co-Author, Conceptualization, Formal Analysis, Funding Acquisition, Investigation, Methodology, Resources, Software, Writing – Review & Editing

Peter Mejlhede Andersen

Department of Ecoscience, Aarhus University, Aarhus, DK-8000, Denmark

Roles
Co-Author, Conceptualization, Formal Analysis, Investigation, Methodology, Resources, Software, Supervision, Validation, Visualization, Writing – Review & Editing

Downloads over the last 12 months:

Cited by

via Crossref

View citing articles