The database management framework for combined sewerage system of Phu Loc river basin in Danang city by GIS

Nowadays, Geographic Information Systems (GIS) applications have provided tools to integrate information, visualize scenarios, present powerful ideas, and develop effective solutions like never before so that it supports strategic decision making. Based on the advantages of GIS applications, the main goal of database management framework is simulation and visualization combined sewerage system and water quality data of Phu Loc river, Da Nang city via QGIS software. Although the length of the river is only 1.9 km, the Phu Loc river was discharge point of drainage basin in the northwest area of Da Nang city with a total area of more than 3500 hectars, which included 5 urban lakes, the municipal wastewater treatment plant with capacity over 40000 m3/d. After transform and organize data from other source to QGIS, the researchers created a database management framework for sewerage system with relation model for each group of data. Based on process digitalization data of water quality, QGIS software should presented type of digital map of Phuloc basin area with construction of combined sewerage system for basin area and water quality index for river and urban lakes.