Utilize este identificador para referenciar este registo: https://hdl.handle.net/10316/92894
Título: UrbanWater: Integrating EPANET 2 in a PostgreSQL/PostGIS-Based Geospatial Database Management System
Autor: Martinho, Nuno 
Almeida, José-Paulo de 
Simões, Nuno E. 
Sá-Marques, Alfeu 
Palavras-chave: GIS; Connectivity; EPANET 2; Hydraulic modelling; Simulation; Integrated water supply management system
Data: 22-Out-2020
Editora: MDPI
Título da revista, periódico, livro ou evento: ISPRS International Journal of Geo-Information
Volume: 9
Número: 11
Resumo: 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.
URI: https://hdl.handle.net/10316/92894
ISSN: 2220-9964
DOI: 10.3390/ijgi9110613
cv-prod-2078219
cv-prod-2078219
Direitos: openAccess
Aparece nas coleções:I&D INESCC - Artigos em Revistas Internacionais

Ficheiros deste registo:
Ficheiro Descrição TamanhoFormato
2020-IJGI-09-00613.pdf5.58 MBAdobe PDFVer/Abrir
Mostrar registo em formato completo

Citações SCOPUSTM   

2
Visto em 25/mar/2024

Citações WEB OF SCIENCETM

2
Visto em 2/mar/2024

Visualizações de página

196
Visto em 26/mar/2024

Downloads

254
Visto em 26/mar/2024

Google ScholarTM

Verificar

Altmetric

Altmetric


Este registo está protegido por Licença Creative Commons Creative Commons