Giswater

Welcome to the Giswater Project - QGIS Plugin

Water management has traditionally been complex and costly, making it difficult to efficiently plan or control water supply networks without further investments. However, with the inception of Giswater in 2014, the first open-source software specifically designed for water supply and water management, this complexity is now manageable.

Giswater integrates various IT solutions and pre-existing databases, enabling high-performance management systems combined with hydraulic software such as EPANET and SWMM.

Giswater is the first open-source tool for integral water cycle management, created for city councils, municipal administrations, water and sewerage service providers, and hydraulic professionals. As a driver, it connects hydraulic analysis tools and spatial databases, allowing user access from any GIS. Compatible with EPANET, EPA SWMM, GIS, WMS, SCADA, and more, Giswater integrates seamlessly into water management entities’ ecosystems, amplifying their operational capabilities.

Additionally, Giswater can be connected with business management tools like ERP, CRM, Business Intelligence software, and corporate mobile devices.

Developed in Python (QGIS plugin) and PL/SQL (PostgreSQL database), the project is organized across three main repositories: QGIS-PLUGIN, DB-MODEL, and DOCS.

---

Table of Contents

1. Requirements
2. Install
3. Test
4. Deployment
5. Wiki
6. FAQ
7. Code Repositories
8. Versioning
9. Third-Party Libraries
10. License
11. Acknowledgments

---

Requirements

To work with Giswater, you will need:

• PostgreSQL: Ensure to select the pgAdmin component (Database Manager) and PostGIS (Spatial Extension) during installation.
• QGIS: Required geoprocessing software.

Install

Since Giswater functions as server-client software, installation is done across two environments.

Backend Environment

Compatible with Windows, Mac, and Linux OS.

• Install PostgreSQL (versions 9.5 to 17).

• Install PostGIS, pgRouting, and other required PostgreSQL extensions:

  CREATE EXTENSION postgis;
  CREATE EXTENSION pgrouting;
  CREATE EXTENSION tablefunc;
  CREATE EXTENSION unaccent;
  CREATE EXTENSION postgis_raster;
  CREATE EXTENSION fuzzystrmatch;
  

Frontend environment:

Compatible with Windows, Mac, and Linux, but EPA models are only supported on Windows.

• Install the latest Long-Term Release (LTR) of QGIS.
• Install SWMM (5.1) and EPANET (2.2). Note: EPA SWMM and EPANET may not work on Linux front-end environments.
• On Linux systems, you may need to install the PostgreSQL Qt driver for database connectivity. On Ubuntu:

  sudo apt install libqt5sql5-psql
  

Test

Use the provided example projects, pre-loaded with datasets for testing. Find setup videos below:

• Install the plugin
• Setup connection
• Create DB schema example
• Create QGIS project

Deployment

Requirements

Ensure you have the permissions to connect to PostgreSQL and that your user has superuser rights for database administration tasks (e.g., creating schemas, roles, backups).

Project Setup

• Define catalogs with at least the mandatory categories ([materials, node, arc]) and create map zones ([macroexploitation, exploitation, municipality, sector, dma]).
• To get started, refer to Start from Scratch for guidance.
• Tip: Once map zones and catalogs are defined, you can begin adding network nodes and arcs.

For more configuration options, see the Giswater configuration guide.

Wiki

Explore additional documentation on the Giswater Wiki.

FAQs

Find answers to common questions in the Giswater FAQs.

Code Repositories

• Docs: Documentation repository
• QGIS Plugin: QGIS Plugin repository
• Database Model: Database Model repository

Other repositories may exist but are either deprecated or inactive.

Versioning

Giswater follows a three-level release system:

• Major: New architecture with significant updates (no forward compatibility).
• Minor: Bug fixes and new features (forward compatible).
• Build: Minor fixes and updates (forward compatible).

Release frequency:

• Build: Monthly (12 builds/year)
• Minor: Annually
• Major: No fixed schedule

Third-Party Libraries

Giswater uses the following third-party libraries:

• WNTR: WNTR GitHub WNTR is an open-source Python package for analyzing water distribution systems using hydraulic and water quality models. The WNTR license can be found in the LICENSE file or in their repository.

• swmm-api: swmm-api GitLab swmm-api provides a Pythonic interface to the EPA SWMM5 software, enabling advanced scripting, simulation control, and access to simulation results. The license and further details can be found in the LICENSE or in their repository.

• tqdm: tqdm GitHub tqdm is a fast, extensible progress bar library for Python, supporting console, GUI, and notebook environments. The tqdm license can be viewed in the LICENSE or in their repository.

• PyPDF2: PyPDF2 GitHub PyPDF2 is a Python library for working with PDF files, offering functionalities such as splitting, merging, and text extraction. The PyPDF2 license is available in the LICENSE or in their repository.

• osmnx: OSMnx GitHub OSMnx is a Python package to easily download, model, analyze, and visualize street networks and other geospatial features from OpenStreetMap. You can download and model walking, driving, or biking networks with a single line of code then analyze and visualize them. You can just as easily work with urban amenities/points of interest, building footprints, transit stops, elevation data, street orientations, speed/travel time, and routing. The OSMnx license can be viewed in the LICENSE or in their repository

License

This program is free software, licensed under the GNU General Public License (GPL) version 3 or later. Refer to the LICENSE file for details.

Acknowledgments

Special thanks to our founding contributors:

• GITS-BarcelonaTech University
• Aigües de Mataró
• Cicle de l'Aigua del Ter S.A
• Aigües de Blanes
• Aigües del Prat
• Aigües de Vic
• Aigües de Castellbisbal
• Aigües de Banyoles
• Figueres de Serveis, S.A
• Prodaisa
• Sabemsa
• Consorci Aigües de Tarragona
• BGEO OPEN GIS S.L.