Problem statement
Water utilities use multiple heterogeneous data sources (SCADA, customer meters, external weather data) that are only weakly linked to the physical network model. This makes it difficult for operators and analysts to formulate integrated spatio-temporal queries and to visually explore data in its geographic and topological context.
Project objectives
Adapt and implement an existing Neo4j graph database schema for a new water distribution network to integrate:
-
network assets and topology,
-
time series from SCADA and customer meters,
-
external factors such as weather and soil properties.
Modify an existing web-based GIS application for the new dataset (Python backend, JavaScript frontend) so that it:
-
visualizes the network and measurement locations,
-
allows users to define and execute parameterized queries,
-
shows query results on the map and as time-series plots.
Evaluate the system with respect to query performance and usability (e.g. response times, query complexity, and a small user study with operators or students).
(Optional) Generalize the code so that future networks with slightly different structures can be imported with minimal changes.
Expected timeframe: 3–6 months.
Expected deliverables: Modified codebase, final report, and presentation talk.
Contact: mohammad.moataz@fau.de