BEGIN:VCALENDAR VERSION:2.0 PRODID:-//pretalx//talks.staging.osgeo.org//foss4g-europe-2025//speaker//YH YA9Z BEGIN:VTIMEZONE TZID:CET BEGIN:STANDARD DTSTART:20001029T040000 RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10 TZNAME:CET TZOFFSETFROM:+0200 TZOFFSETTO:+0100 END:STANDARD BEGIN:DAYLIGHT DTSTART:20000326T030000 RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3 TZNAME:CEST TZOFFSETFROM:+0100 TZOFFSETTO:+0200 END:DAYLIGHT END:VTIMEZONE BEGIN:VEVENT UID:pretalx-foss4g-europe-2025-9C8SHN@talks.staging.osgeo.org DTSTART;TZID=CET:20250717T143000 DTEND;TZID=CET:20250717T150000 DESCRIPTION:Proprietary software capable of performing 1D/2D hydraulic mode ling often presents a significant financial barrier for individuals\, rese archers\, and public institutions\, limiting accessibility and hindering h ydrological studies. To overcome this challenge\, we have developed Digita l RAIN (DRAIN)\, an open-source QGIS plugin designed to facilitate 1D/2D h ydraulic modeling in urban environments.\n\nDRAIN leverages the combined s trengths of EPA SWMM and Iber\, two widely used hydraulic modeling tools\, to simulate rainfall events and their impact on drainage systems. The too l provides detailed simulation results\, including calculated hydrodynamic parameters for each element of the hydraulic infrastructure (processed by SWMM) and high-resolution raster outputs that depict accumulated rainfall and surface flow over time (generated by Iber).\n\nAt the core of DRAIN\, a GeoPackage-based data model ensures seamless integration between Iber a nd SWMM\, incorporating triggers and constraints to maintain data consiste ncy and accuracy. The plugin also features an intuitive graphical interfac e with interactive GIS tools\, allowing users to efficiently manage spatia l data\, define modeling parameters\, and execute simulations directly wit hin the QGIS environment.\n\nBy offering a free\, open-source alternative to proprietary hydraulic modeling software\, DRAIN promotes accessibility\ , reproducibility\, and innovation in urban hydrology studies. This tool h as the potential to support decision-making processes related to flood ris k management\, stormwater infrastructure design\, and climate resilience p lanning in urban areas. DTSTAMP:20260527T184226Z LOCATION:SA02 SUMMARY:DRAIN: QGIS Plugin for 1D/2D hydraulic modelling - Maria Guzmán URL:https://talks.staging.osgeo.org/foss4g-europe-2025/talk/9C8SHN/ END:VEVENT BEGIN:VEVENT UID:pretalx-foss4g-europe-2025-3Z8WAQ@talks.staging.osgeo.org DTSTART;TZID=CET:20250717T160000 DTEND;TZID=CET:20250717T163000 DESCRIPTION:Pipe leaks are a significant concern for water companies respon sible for managing water infrastructures. In this context\, anticipating t hese events is crucial not only for conserving water but also for ensuring that the infrastructure remains in optimal condition.\n\nThe FLUENT proje ct presents a unique opportunity for water companies to study the probabil ity of pipe leaks using artificial intelligence (AI)\, Linear Extended Yul e 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 comp anies also collaborated to establish common definitions of key concepts an d to share valuable knowledge on how to tackle the challenges associated w ith leak detection and prevention. \n\nThe collected data was stored in a PostgreSQL database\, and was processed using PL/pgSQL and PostGIS functio ns\, allowing for efficient data manipulation and preparation before being used by the AI algorithms outside the database. This collaborative approa ch not only aims to improve the accuracy of leak predictions but also seek s to provide practical solutions to enhance infrastructure management and promote more sustainable water usage practices. By leveraging AI in this w ay\, the project strives to advance the capabilities of water companies in addressing one of the most pressing challenges in water distribution netw orks today. DTSTAMP:20260527T184226Z LOCATION:SA02 SUMMARY:FLUENT: prediction of pipe leaks using IA\, LEYP and log regression . Data pipeline using PostgreSQL - Maria Guzmán URL:https://talks.staging.osgeo.org/foss4g-europe-2025/talk/3Z8WAQ/ END:VEVENT BEGIN:VEVENT UID:pretalx-foss4g-europe-2025-ETPJKW@talks.staging.osgeo.org DTSTART;TZID=CET:20250718T120000 DTEND;TZID=CET:20250718T123000 DESCRIPTION:Giswater is an open-source software platform available as a plu gin in QGIS that bridges the GIS with relational databases for the managem ent of water-related structures. It is specifically designed to manage wat er supply networks\, and urban drainage systems and integrate GIS with hyd raulic modelling tools like EPANET for water supply networks and SWMM for stormwater and sewer systems\, enabling simulations directly from QGIS. It also incorporates inventory management through PostgreSQL Database system s. \n\nThe design and operation of urban sanitation and drainage networks have always been largely overlooked in the integral water cycle. In this s ense\, Geographic Information Systems (GIS) and mathematical models for ne tworks play a key role in both the design and exploitation phases. This pr oject demonstrates the viability of carrying out a long-term strategy for asset management of urban sanitation and drainage networks with the use of open-source technologies. In the design phase\, a complete analysis of th e terrain can be carried out along with sizing and selection of materials\ , and design of auxiliary structures of network elements. In the exploitat ion phase\, this set of technologies working in solidarity will allow us t o efficiently work on the activities and processes necessary to maintain a nd operate the systems efficiently and effectively. This includes preventi ve and corrective maintenance\, monitoring and control\, emergency managem ent\, or resource optimization ensuring seamless operations. This project demonstrates the possibility of carrying out all the work professionally s tated with open-source technologies\, which opens the door to the universa lization of urban sanitation management\, regardless of the degree of matu rity or available capital since access to technology has become possible i n this regard. DTSTAMP:20260527T184226Z LOCATION:SA02 SUMMARY:Giswater 4 - Maria Guzmán URL:https://talks.staging.osgeo.org/foss4g-europe-2025/talk/ETPJKW/ END:VEVENT END:VCALENDAR