Modelling data of an urban drainage design using a Geographic Information System (GIS) database

This paper describes the development of a model to interface a planned urban drainage system with Geographic Information System (GIS)through the introduction of open-source tools; Auto Numbering and Get Elevation to extract essential data from GIS and Excel2GIS to bridge the output data between GIS and the drainage design program. Creating a range of essential data from digital database repositories aids the development of decision-support tools for urban planners in a simulation of different urban drainage scheme scenarios and moderates the interference with other infrastructure utilities. These tools, modelled with design software and GIS platform, are tested in two case studies; the results revealing essential improvements in accuracy of output, time taken to prepare and run the model and model presentation which visualised the hydraulic design results and global location of the drainage layout on an urban master plan. © 2019 Elsevier B.V.

[1]  U. Shamsi.  GIS Applications for Water, Wastewater, and Stormwater Systems , 2005 .

[2]  Albert S. Chen,et al.  A novel approach to model dynamic flow interactions between storm sewer system and overland surface for different land covers in urban areas , 2015 .

[3]  R. D. Johnson,et al.  A semi-distributed model for locating stormwater best management practices in coastal environments , 2017, Environ. Model. Softw..

[4]  Jyri Mustajoki,et al.  Comparison of multi-criteria decision analytical software for supporting environmental planning processes , 2017, Environ. Model. Softw..

[5]  Amlan Mukherjee,et al.  Modeling Blockage Failures in Sewer Systems to Support Maintenance Decision Making , 2010 .

[6]  Frank Kizito,et al.  Development of decision support tools for decentralised urban water supply management in Uganda: An Action Research approach , 2009, Comput. Environ. Urban Syst..

[7]  J. P. Leitão,et al.  Identifying the best locations to install flow control devices in sewer networks to enable in-sewer storage , 2018 .

[8]  Jorge Gironás,et al.  A GIS-based urban and peri-urban landscape representation toolbox for hydrological distributed modeling , 2017, Environ. Model. Softw..

[9]  Jiun-Huei Jang,et al.  Effect of inlet modelling on surface drainage in coupled urban flood simulation , 2018, Journal of Hydrology.

[10]  Jeffery S. Horsburgh,et al.  Design of a metadata framework for environmental models with an example hydrologic application in HydroShare , 2017, Environ. Model. Softw..

[11]  Jorge Gironás,et al.  Comparison of catchment and network delineation approaches in complex suburban environments: application to the Chaudanne catchment, France , 2013 .

[12]  Sa Sinske,et al.  Sewer-system analysis with the aid of a geographical information system , 2002 .

[13]  Adelino Ferreira,et al.  A GIS-based infrastructure management system for municipalities , 2006 .

[14]  Peter Steen Mikkelsen,et al.  A methodological approach to the design of optimising control strategies for sewer systems , 2016, Environ. Model. Softw..

[15]  Maria da Conceição Cunha,et al.  Optimal location and sizing of storage units in a drainage system , 2016, Environ. Model. Softw..

[16]  Antonio Francipane,et al.  Effect of raster resolution and polygon-conversion algorithm on landslide susceptibility mapping , 2016, Environ. Model. Softw..

[17]  Ashok Sharma,et al.  Urban drainage system planning and design--challenges with climate change and urbanization: a review. , 2015, Water science and technology : a journal of the International Association on Water Pollution Research.

[18]  Christopher J. Duffy,et al.  A tightly coupled GIS and distributed hydrologic modeling framework , 2014, Environ. Model. Softw..

[19]  J. Valiantzas.  Explicit power formula for the Darcy-Weisbach pipe flow equation: application in optimal pipeline design , 2008 .

[20]  Wolfgang Rauch,et al.  Importance of scenario analysis in urban development for urban water infrastructure planning and management , 2017, Comput. Environ. Urban Syst..

[21]  Yan Li,et al.  Geographic information system-based assessment of mitigating flash-flood disaster from green roof systems , 2017, Comput. Environ. Urban Syst..

[22]  David M. Wheeler,et al.  A national-scale GIS-based system for modelling impacts of land use on water quality , 2016, Environ. Model. Softw..

[23]  Andrew Chadwick,et al.  Hydraulics in Civil and Environmental Engineering , 1993 .

[24]  Larry W. Mays,et al.  Stormwater Collection Systems Design Handbook , 2001 .

[25]  Yusheng Zhou,et al.  A GIS-based software for forecasting pollutant drift on coastal water surfaces using fractional Brownian motion: A case study on red tide drift , 2017, Environ. Model. Softw..

[26]  Jin Zhang,et al.  An integrated assessment of urban flooding mitigation strategies for robust decision making , 2017, Environ. Model. Softw..

[27]  M. Suidan,et al.  Modeling of Nitrification Under Substrate‐Inhibiting Conditions , 1990 .

[28]  W Rauch,et al.  GIS-based applications of sensitivity analysis for sewer models. , 2012, Water science and technology : a journal of the International Association on Water Pollution Research.

[29]  Scott Rayburg,et al.  A comparison of digital elevation models generated from different data sources , 2009 .

[30]  Iryna Dronova,et al.  Modeling stormwater management at the city district level in response to changes in land use and low impact development , 2017, Environ. Model. Softw..

[31]  Shuming Liu,et al.  Fully integrated approach: an alternative solution of coupling a GIS and diffuse pollution models , 2014, Frontiers of Environmental Science & Engineering.

[32]  Kathleen Stewart,et al.  Barrier dynamics for GIS: a design pattern for geospatial barriers , 2015, Int. J. Geogr. Inf. Sci..

[33]  Walter Collischonn,et al.  MGB-IPH model for hydrological and hydraulic simulation of large floodplain river systems coupled with open source GIS , 2017, Environ. Model. Softw..

[34]  Andrew J. Rettig,et al.  An open source software approach to geospatial sensor network standardization for urban runoff , 2014, Comput. Environ. Urban Syst..

[35]  Raghavan Srinivasan,et al.  Introducing a new open source GIS user interface for the SWAT model , 2016, Environ. Model. Softw..

[36]  Anders Nielsen,et al.  An open source QGIS-based workflow for model application and experimentation with aquatic ecosystems , 2017, Environ. Model. Softw..

[37]  Andrew Kingdon,et al.  A seamlessly coupled GIS and distributed groundwater flow model , 2016, Environ. Model. Softw..

[38]  Lidija Tadić,et al.  APPLICATION OF GIS IN THE WASTEWATER MANAGEMENT , 2014 .

[39]  G. V. Loganathan,et al.  GIS-Based Approach to Sewer System Design , 1999 .

[40]  David W. S. Wong,et al.  Effects of DEM sources on hydrologic applications , 2010, Comput. Environ. Urban Syst..

[41]  Baozhu Pan,et al.  An urban storm-inundation simulation method based on GIS , 2014 .

[42]  Juan Saldarriaga,et al.  A new methodology for the optimal design of series of pipes in sewer systems , 2016 .

[43]  Jason Luettinger,et al.  Geographic Information System-based Pipeline Route Selection Process , 2005 .

[44]  Nicanor Quijano,et al.  MatSWMM - An open-source toolbox for designing real-time control of urban drainage systems , 2016, Environ. Model. Softw..

[45]  Peter Steen Mikkelsen,et al.  A critical review of integrated urban water modelling - Urban drainage and beyond , 2014, Environ. Model. Softw..

[46]  Edward Burgess,et al.  Computer Tools for Sanitary Sewer System Capacity Analysis and Planning , 2008 .

[47]  P.M.M. van Daal-Rombouts,et al.  Design and performance evaluation of a simplified dynamic model for combined sewer overflows in pumped sewer systems , 2016 .

[48]  A. Roy,et al.  Assessing Impervious Surface Connectivity and Applications for Watershed Management 1 , 2009 .