07-18, 15:30–16:00 (Europe/Sarajevo), CA01
Pipe leaks are a significant concern for water companies responsible for managing water infrastructures. In this context, anticipating these events is crucial not only for conserving water but also for ensuring that the infrastructure remains in optimal condition.
The FLUENT project presents a unique opportunity for water companies to study the probability of pipe leaks using artificial intelligence (AI), Linear Extended Yule Process (LEYP) , and logistic regression (LR) enabling them to predict and proactively address potential issues. The main goal of the project is to develop a predictive system for pipe leaks using advanced AI algorithms. To achieve this, four water companies, serving between 20,000 and 100,000 consumers, contributed their data to train the AI model. These companies also collaborated to establish common definitions of key concepts and to share valuable knowledge on how to tackle the challenges associated with leak detection and prevention.
The collected data was stored in a PostgreSQL database, and was processed using PL/pgSQL and PostGIS functions, allowing for efficient data manipulation and preparation before being used by the AI algorithms outside the database. This collaborative approach not only aims to improve the accuracy of leak predictions but also seeks to provide practical solutions to enhance infrastructure management and promote more sustainable water usage practices. By leveraging AI in this way, the project strives to advance the capabilities of water companies in addressing one of the most pressing challenges in water distribution networks today.
PostgreSQL
Assign a number between 1 and 3 indicating the level of technical complexity of your contribution. –2 - background knowledge helpful
Select at least one general theme that best defines your proposal –Data processing and analysis
I make my conference contribution available under the CC BY 4.0 license. The conference contribution comprises the abstract, the text contribution for the conference proceedings, the presentation materials as well as the video recording and live transmission of the presentation – yesGIS Analyst with a background of environmental sciences. Working at BGEO OPEN GIS with open-source projects based on QGIS-PostgreSQL-PostGIS.