Towards a water quality database for raw and validated data with emphasis on structured metadata

On-line continuous monitoring of water bodies produces large quantities of high frequency data. Long-term quality control and applicability of these data require rigorous storage and documentation. To carry out these activities successfully, a database has to be built. Such a database should provide the simplicity to store and document all relevant data and should be easy to use for further data evaluation and interpretation. In this paper, a comprehensive database structure for water quality data is proposed. Its goal is to centralize the data, standardize their format, provide easy access, and, especially, document all relevant information (metadata) associated with the measurements in an efficient way. The emphasis on data documentation enables the provision of detailed information not only on the history of the measurements (e.g., where, how, when and by whom was the value measured) but also on the history of the equipment (e.g., sensor maintenance, calibration/validation history), personnel (e.g., experience), projects, sampling sites, etc. As such, the proposed database structure provides a robust and efficient tool for functional data storage and access, allowing future use of data collected at great expense.

• Publication year

  2018

• Venue

  Water Quality Research Journal

• Publication date

  2018-11-14

• Fields of study

  Computer Science, Environmental Science

• Identifiers
  DOI 10.2166/WQRJ.2018.013
• External record

  Open on Semantic Scholar

• Source metadata

  Semantic Scholar

• No claims are published for this paper.

• No concepts are published for this paper.

• Open source software for visualization and quality control of continuous hydrologic and water quality sensor data

  2015cited by this paper
• Scientific Data Management with Open Source Tools – An Urban Drainage Example

  2012cited by this paper
• Towards the automation of water quality monitoring networks

  2010cited by this paper
• A relational model for environmental and water resources data

  2008cited by this paper
• monEAU: a platform for water quality monitoring networks.

  2008cited by this paper
• Scientific data management in the coming decade

  2005cited by this paper
• Computer-aided monitoring and operation of continuous measuring devices.

  2004cited by this paper

• Harmonization of aggregated freshwater biotic data to support continental and global assessment

  2026cites this paper
• Protocol for the use of an Optical Nitrate Nitrogen (NO3—N) sensor for measuring ground and surface water NO3—N concentrations

  2025cites this paper
• Space-temporal analysis of groundwater quality in three areas of the state of Yucatán, México, and its relationship with existing anthropogenic activity

  2024cites this paper
• Digital Twins for Wastewater Treatment: A Technical Review

  2024cites this paper
• About Some Aspects of Use of Optical Sensors for Monitoring the Aquatic Environment

  2023cites this paper
• A database application framework toward data-driven vertical connectivity analysis of rivers

  2023cites this paper
• Operationalizing Real-Time Monitoring Data in Simulation Models Using the Public Domain HEC-DSSVue Software Platform

  2023cites this paper
• Predicting water quality in Canada: mind the (data) gap

  2022cites this paper
• GRQA: Global River Water Quality Archive

  2021cites this paper
• A critical review of the data pipeline: how wastewater system operation flows from data to intelligence.

  2020cites this paper
• Technologies Enabling Situational Awareness During Disaster Response: A Systematic Review

  2020cites this paper
• Autonomous Systems for the Environmental Characterization of Lagoons

  2020cites this paper
• Challenges and Opportunities on Urban Water Quality in Mexico City

  2019cites this paper
• New Optical Tools for Water Quality Diagnostics

  2019cites this paper
• Reply letter to the second review of the preprint submitted to Earth System Science Data (ESSD) entitled: “GRQA: Global River Water Quality Archive”

  year unknowncites this paper