{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,12,8]],"date-time":"2025-12-08T22:29:47Z","timestamp":1765232987925,"version":"build-2065373602"},"reference-count":31,"publisher":"MDPI AG","issue":"11","license":[{"start":{"date-parts":[[2020,10,22]],"date-time":"2020-10-22T00:00:00Z","timestamp":1603324800000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["IJGI"],"abstract":"<jats:p>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.<\/jats:p>","DOI":"10.3390\/ijgi9110613","type":"journal-article","created":{"date-parts":[[2020,10,22]],"date-time":"2020-10-22T10:27:58Z","timestamp":1603362478000},"page":"613","update-policy":"https:\/\/doi.org\/10.3390\/mdpi_crossmark_policy","source":"Crossref","is-referenced-by-count":3,"title":["UrbanWater: Integrating EPANET 2 in a PostgreSQL\/PostGIS-Based Geospatial Database Management System"],"prefix":"10.3390","volume":"9","author":[{"ORCID":"https:\/\/orcid.org\/0000-0001-9155-8023","authenticated-orcid":false,"given":"Nuno","family":"Martinho","sequence":"first","affiliation":[{"name":"Department of Mathematics (Geomatic Engineering Group), Faculty of Sciences &amp; Technology, University of Coimbra, 3030-290 Coimbra, Portugal"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-2532-2466","authenticated-orcid":false,"given":"Jos\u00e9-Paulo de","family":"Almeida","sequence":"additional","affiliation":[{"name":"Department of Mathematics (Geomatic Engineering Group), Faculty of Sciences &amp; Technology, University of Coimbra, 3030-290 Coimbra, Portugal"},{"name":"INESCC-Institute for Systems Engineering &amp; Computers at Coimbra, 3030-290 Coimbra, Portugal"}]},{"given":"Nuno E.","family":"Sim\u00f5es","sequence":"additional","affiliation":[{"name":"INESCC-Institute for Systems Engineering &amp; Computers at Coimbra, 3030-290 Coimbra, Portugal"},{"name":"Department of Civil Engineering, Faculty of Sciences &amp; Technology, University of Coimbra, 3030-290 Coimbra, Portugal"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-6859-6662","authenticated-orcid":false,"given":"Alfeu","family":"S\u00e1-Marques","sequence":"additional","affiliation":[{"name":"INESCC-Institute for Systems Engineering &amp; Computers at Coimbra, 3030-290 Coimbra, Portugal"},{"name":"Department of Civil Engineering, Faculty of Sciences &amp; Technology, University of Coimbra, 3030-290 Coimbra, Portugal"}]}],"member":"1968","published-online":{"date-parts":[[2020,10,22]]},"reference":[{"key":"ref_1","doi-asserted-by":"crossref","unstructured":"Bruaset, S., Rygg, H., and S\u00e6grov, S. (2018). Reviewing the Long-Term Sustainability of Urban Water System Rehabilitation Strategies with an Alternative Approach. Sustainability, 10.","DOI":"10.3390\/su10061987"},{"key":"ref_2","doi-asserted-by":"crossref","first-page":"104568","DOI":"10.1016\/j.envsoft.2019.104568","article-title":"Smart GIS platform that facilitates the digitalization of the integrated urban drainage system","volume":"123","author":"Martin","year":"2020","journal-title":"Environ. Model. Softw."},{"key":"ref_3","doi-asserted-by":"crossref","unstructured":"Shamsi, U. (2005). GIS Applications for Water, Wastewater and Stormwater Systems, CRC Press.","DOI":"10.1201\/9781420039252"},{"key":"ref_4","doi-asserted-by":"crossref","first-page":"413","DOI":"10.1016\/S1364-8152(02)00015-4","article-title":"Linking GIS and water resources management models: An object-oriented method","volume":"17","author":"McKinney","year":"2002","journal-title":"Environ. Model. Softw."},{"key":"ref_5","doi-asserted-by":"crossref","first-page":"374","DOI":"10.1016\/j.watres.2014.08.020","article-title":"Exploring critical pathways for urban water management to identify robust strategies under deep uncertainties","volume":"66","author":"Urich","year":"2014","journal-title":"Water Res."},{"key":"ref_6","unstructured":"Rossman, L. (2000). EPANET 2\u2014User\u2019s Manual, Office of Research and Development, U.S. Environmental Protection Agency. (EPA\/600\/R-00\/057)."},{"key":"ref_7","doi-asserted-by":"crossref","unstructured":"McPherson, T.N., and Witkowski, M. (2005). Modeling Urban Water Demand within a GIS Using a Population Mobility Model. Impacts of Global Climate Change, American Society of Civil Engineers.","DOI":"10.1061\/40792(173)33"},{"key":"ref_8","doi-asserted-by":"crossref","unstructured":"House-Peters, L.A., and Chang, H. (2011). Urban water demand modeling: Review of concepts, methods, and organizing principles. Water Resour. Res., 47.","DOI":"10.1029\/2010WR009624"},{"key":"ref_9","doi-asserted-by":"crossref","first-page":"1347","DOI":"10.1007\/s11269-011-9962-3","article-title":"Mapping urban water demands using multi-criteria analysis and GIS","volume":"26","author":"Panagopoulos","year":"2012","journal-title":"Water Resour. Manag."},{"key":"ref_10","unstructured":"U.S. Environmental Protection Agency (USEPA) (2005). Water Distribution System Analysis: Field Studies, Modelling and Management. A Reference Guide for Utilities, Office of Research and Development, U.S. Environmental Protection Agency. (EPA\/600\/R-06\/028)."},{"key":"ref_11","doi-asserted-by":"crossref","unstructured":"Ramos, H.M., McNabola, A., L\u00f3pez-Jim\u00e9nez, P.A., and P\u00e9rez-S\u00e1nchez, M. (2020). Smart Water Management towards Future Water Sustainable Networks. Water, 12.","DOI":"10.3390\/w12010058"},{"key":"ref_12","doi-asserted-by":"crossref","unstructured":"Zhao, L., Liu, Z., and Mbachu, J. (2019). An Integrated BIM\u2013GIS Method for Planning of Water Distribution System. ISPRS Int. J. Geo Inf., 8.","DOI":"10.3390\/ijgi8080331"},{"key":"ref_13","unstructured":"Schock, M.R., and Clement, J.A. (1994, January 21\u201323). You can\u2019t do that with these data! Or: Uses and abuses of tap water monitoring analyses. Proceedings of the National Conference on Environmental Problem-Solving with Geographic Information Systems (EPA\/625\/R-95\/004), Cincinnati, OH, USA."},{"key":"ref_14","doi-asserted-by":"crossref","first-page":"689","DOI":"10.1080\/13658810110074519","article-title":"Topology revisited: Representing spatial relations","volume":"15","author":"Theobald","year":"2001","journal-title":"Int. J. Geogr. Inf. Syst."},{"key":"ref_15","unstructured":"Mays, L.W. (2000). Computer Models\/Epanet. Water Distribution Systems Handbook, McGraw-Hill."},{"key":"ref_16","unstructured":"Ormsbee, L. (2006, January 27\u201330). The History of Water Distribution Network Analysis: The Computer Age. Proceedings of the 8th Water Distribution Systems Analysis Symposium, Cincinnati, OH, USA."},{"key":"ref_17","unstructured":"Walski, T., Chase, D., Savic, D., Grayman, W., Beckwith, S., and Koelle, E. (2007). Advanced Water Distribution Modelling and Management, Bentley Institute Press."},{"key":"ref_18","doi-asserted-by":"crossref","first-page":"21","DOI":"10.5194\/dwes-3-21-2010","article-title":"Online modelling of water distribution systems: A UK case study","volume":"3","author":"Machell","year":"2010","journal-title":"Drink. Water Eng. Sci."},{"key":"ref_19","doi-asserted-by":"crossref","first-page":"4527","DOI":"10.1007\/s11269-013-0424-y","article-title":"District Metered Areas design and different decision makers\u2019 options: Cost analysis","volume":"27","author":"Gomes","year":"2013","journal-title":"Water Resour. Manag."},{"key":"ref_20","doi-asserted-by":"crossref","first-page":"133","DOI":"10.1007\/s11269-006-4635-3","article-title":"Pressure Control for Leakage Minimization in Water Distribution Systems Management","volume":"20","author":"Ramos","year":"2006","journal-title":"Water Resour. Manag."},{"key":"ref_21","doi-asserted-by":"crossref","first-page":"43","DOI":"10.1080\/15730620601145899","article-title":"Estimating physical unaccounted for water (UFW) in distribution networks using simulation models and GIS","volume":"4","author":"Motiee","year":"2007","journal-title":"Urban Water J."},{"key":"ref_22","doi-asserted-by":"crossref","first-page":"65","DOI":"10.1080\/1573062X.2010.542820","article-title":"Estimation of the benefits yielded by pressure management in water distribution systems","volume":"8","author":"Gomes","year":"2011","journal-title":"Urban Water J."},{"key":"ref_23","doi-asserted-by":"crossref","first-page":"1378","DOI":"10.3390\/w7041378","article-title":"Locating Leaks with TrustRank Algorithm Support","volume":"7","author":"Ribeiro","year":"2015","journal-title":"Water"},{"key":"ref_24","doi-asserted-by":"crossref","first-page":"317","DOI":"10.17531\/ein.2017.3.1","article-title":"Case study of failure simulation of pipelines conducted in chosen water supply system","volume":"19","author":"Studzinski","year":"2017","journal-title":"Eksploat. Niezawodn"},{"key":"ref_25","doi-asserted-by":"crossref","first-page":"371","DOI":"10.1016\/j.engfailanal.2018.09.008","article-title":"Qualitative analysis of the failure risk of water pipes in terms of water supply safety","volume":"95","author":"Studzinski","year":"2019","journal-title":"Eng. Fail. Anal."},{"key":"ref_26","first-page":"152","article-title":"Failure risk analysis of water distributions systems using hydraulic models on real field data","volume":"68","author":"Studzinski","year":"2019","journal-title":"Ekonomia i \u015arodowisko"},{"key":"ref_27","first-page":"46","article-title":"GIS and modelling integration","volume":"13","author":"Shamsi","year":"2001","journal-title":"CE News"},{"key":"ref_28","unstructured":"Armstrong, L. (2012). Network connectivity. Hydraulic Modelling and GIS, ESRI Press."},{"key":"ref_29","first-page":"377","article-title":"A Relational Model of Data for Large Shared Data Banks","volume":"13","author":"Codd","year":"1970","journal-title":"Commun. Assoc. Comput. Mach."},{"key":"ref_30","unstructured":"Longley, P., Goodchild, M., Maguire, D., and Rhind, D. (2005). Relational databases and beyond. Geographical Information Systems: Principles, Technics, Management and Applications (Abridged ed.), John Wiley & Sons."},{"key":"ref_31","doi-asserted-by":"crossref","unstructured":"Rossman, L. (1999, January 6\u20139). The EPANET Programmer\u2019s Toolkit for Analysis of Water Distribution Systems. Proceedings of the Water Resources Planning and Management Conference, Tempe, AZ, USA.","DOI":"10.1061\/40430(1999)39"}],"container-title":["ISPRS International Journal of Geo-Information"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.mdpi.com\/2220-9964\/9\/11\/613\/pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,10,11]],"date-time":"2025-10-11T10:25:45Z","timestamp":1760178345000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.mdpi.com\/2220-9964\/9\/11\/613"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2020,10,22]]},"references-count":31,"journal-issue":{"issue":"11","published-online":{"date-parts":[[2020,11]]}},"alternative-id":["ijgi9110613"],"URL":"https:\/\/doi.org\/10.3390\/ijgi9110613","relation":{},"ISSN":["2220-9964"],"issn-type":[{"type":"electronic","value":"2220-9964"}],"subject":[],"published":{"date-parts":[[2020,10,22]]}}}