UrbanWater: Integrating EPANET 2 in a PostgreSQL/PostGIS-Based Geospatial Database Management System
Open Access
- 21 October 2020
- journal article
- research article
- Published by MDPI AG in ISPRS International Journal of Geo-Information
- Vol. 9 (11), 613
- https://doi.org/10.3390/ijgi9110613
Abstract
Incorporating data stored in a geographical information system (GIS) within the development of hydraulic simulation models is crucial for operating, updating, and hence redesigning water supply systems (WSS). Building and updating hydraulic models can be both time and resource consuming; moreover, the need to update infrastructure cadastral information makes the model itself outdated. In addition, typical dispersion of data across several databases requires extra effort to maintain the whole system and ensure it is properly assembled. Albeit there are some GIS-based hydraulic modelling solutions available, they typically use external connections to assemble all components resulting in additional costs and less flexibility. In order to be able to establish a single fully integrated data model towards global characterization of a WSS and associate hydraulic simulation, this paper proposes the specific implementation of an EPANET 2 model in PostgreSQL along with PostGIS extension. The system developed enables the construction of the model, hydraulic simulation, and storage of results within a single database. Required procedures and functions were coded either in pgSQL or Python and their execution were carried out using SQL statements. Finally, a case study was selected in order to test the system proposed. Results show that an integrated approach indeed allows the expedited creation of more realistic hydraulic models based on the stored cadastral information.Keywords
This publication has 18 references indexed in Scilit:
- Smart GIS platform that facilitates the digitalization of the integrated urban drainage systemEnvironmental Modelling & Software, 2020
- Smart Water Management towards Future Water Sustainable NetworksWater, 2019
- An Integrated BIM–GIS Method for Planning of Water Distribution SystemISPRS International Journal of Geo-Information, 2019
- Reviewing the Long-Term Sustainability of Urban Water System Rehabilitation Strategies with an Alternative ApproachSustainability, 2018
- Exploring critical pathways for urban water management to identify robust strategies under deep uncertaintiesWater Research, 2014
- Mapping Urban Water Demands Using Multi-Criteria Analysis and GISWater Resources Management, 2012
- Urban water demand modeling: Review of concepts, methods, and organizing principlesWater Resources Research, 2011
- Online modelling of water distribution systems: a UK case studyDrinking Water Engineering and Science, 2010
- Linking GIS and water resources management models: an object-oriented methodEnvironmental Modelling & Software, 2002
- Topology revisited: representing spatial relationsInternational Journal of Geographical Information Science, 2001