posted on 2018-02-12, 15:09authored byN. Attygalla, Kokila Ranasinghe, A.M. Adikari, W.M. Tilakaratne, A.D. Ranasooriya, T. Senanayake
In 1999 National Water Supply and Drainage Board (NWSDB) commenced developing a Water Utility GIS for the Greater
Colombo(GC) area with the objective of improving its operations and maintenance activities. National Survey Department
of Sri Lanka was contracted out to produce 1:1000 scale 3D digital base maps from Air Photographs. Available water utility
maps were digitized using Autocad Map GIS and updated using Global Positioning Systems and other survey methods. Due
to voluminous nature of base maps and utility data it is impractical to store them as a one seamless coverage. Storing these
data as separate map tiles leads to several practical constraints such as updating difficulties, searching delays and data
retrieval problems. Therefore it is required to develop a Geo-database to efficiently manage these data. It is not feasible
to utilize available commercial Geo-databases for this purpose due to their high purchasing and maintenance costs. As a
solution PostgreSql, a free Open Source Object Relational Database Management System(ORDBMS) was selected. PostgreSql
has a module called PostGIS which handles spatial data and is used by hundreds of similar organization around the
world. The software successfully runs on Linux Operating System, which also is a freeware. Geo-database was established
in PostgreSQL ORDBMS with necessary table structures, relations etc., to store and manage geometric/attribute data of
water features including 3D basemap data. A user friendly interface was developed within Autocad Map GIS to handle
data uploading and retrievals. All necessary procedures were introduced to the organization for the efficient management
of the Geo-database. Further, an Intranet Web Map Browser was developed to browse the data. Currently the system has
18 themes with total objects of around 800,000 and successfully used by all Water Manager Regions in GC area for their
day-to-day activities. This implemented solution provides an excellent platform for the NWSDB to do advance geo data
management for low cost.
History
School
Architecture, Building and Civil Engineering
Research Unit
Water, Engineering and Development Centre (WEDC)
Published in
WEDC Conference
Citation
ATTYGALLA, N. ... et al, 2006. Low cost GIS data base solution for water utility network in Sri Lanka. IN: Fisher, J. (ed). Sustainable development of water resources, water supply and environmental sanitation: Proceedings of the 32nd WEDC International Conference, Colombo, Sri Lanka, 13-17 November 2006, pp. 231-234.
This work is made available according to the conditions of the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International (CC BY-NC-ND 4.0) licence. Full details of this licence are available at: https://creativecommons.org/licenses/by-nc-nd/4.0/