Topological relations in water quality monitoring

Bruno Chaves Figueiredo,Maria Alexandra Oliveira,João Nuno Silva

2024-02-07

Abstract:The Alqueva Multi-Purpose Project (EFMA) is a massive abduction and storage infrastructure system in the Alentejo, which has a water quality monitoring network with almost thousands of water quality stations distributed across three subsystems: Alqueva, Pedrog\~ao, and Ardila. Identification of pollution sources in complex infrastructure systems, such as the EFMA, requires recognition of water flow direction and delimitation of areas being drained to specific sampling points. The transfer channels in the EFMA infrastructure artificially connect several water bodies that do not share drainage basins, which further complicates the interpretation of water quality data because the water does not flow exclusively downstream and is not restricted to specific basins. The existing user-friendly GIS tools do not facilitate the exploration and visualisation of water quality data in spatial-temporal dimensions, such as defining temporal relationships between monitoring campaigns, nor do they allow the establishment of topological and hydrological relationships between different sampling points. This thesis work proposes a framework capable of aggregating many types of information in a GIS environment, visualising large water quality-related datasets and, a graph data model to integrate and relate water quality between monitoring stations and land use. The graph model allows to exploit the relationship between water quality in a watercourse and reservoirs associated with infrastructures. The graph data model and the developed framework demonstrated encouraging results and has proven to be preferred when compared to relational databases.

Databases

What problem does this paper attempt to address?

This paper mainly focuses on establishing topology relationships in water quality monitoring. In the complex water infrastructure system of the Alqueva Multi-purpose Project (EFMA), identifying pollution sources requires determining the flow direction and defining the areas where specific sampling points are situated. However, in EFMA, the transport channels connect multiple water bodies with non-shared drainage basins, which complicates the interpretation of water quality data.

Existing user-friendly GIS tools fail to conveniently explore and visualize spatial-temporal water quality data, such as defining temporary relationships between monitoring activities or establishing topology and hydrological relationships between different sampling points. This paper proposes a framework that can aggregate multiple information in a GIS environment, visualize large-scale water quality-related data, and utilize graph data models to integrate and correlate water quality and land use between different monitoring stations. The graph data model allows for the utilization of water quality relationships in channels and reservoirs associated with the infrastructure.

The paper also points out that the current tools have limited capabilities in handling complex data and cannot adapt to new monitoring methods, standards, and criteria. Moreover, the increasing number of monitoring parameters and data volume require researchers and managers to find scalable and customized solutions. The proposed framework can detect water relationships between branch sites of rivers and associate them with water quality samples, which is an important tool for rapidly monitoring the spread of pollutants in river networks and water supply systems. Additionally, this solution provides a tool to migrate data from spreadsheets to databases, reducing data redundancy and providing data abstraction and advanced querying capabilities.

The paper also discusses existing work, including water pollution definition, the Alqueva Multi-purpose Project and its environmental monitoring, the application of Geographic Information Systems (GIS) in water quality management, and the advantages of graph databases in handling spatial-temporal data. In the data modeling section, the paper describes how to integrate information from different file types and proposes a graph data schema to represent the EFMA water quality system.

In the implementation part, the paper details the architecture of the developed web application, including the functionalities of the frontend and backend, such as file processing, interactive maps, data analysis tools, result export, and path finding tools. Finally, the paper evaluates and validates the implemented framework, testing its performance and functionality using the EFMA dataset.