Geocoding and Development of a Web-Based Water Distribution Geospatial Information System for Ilorin Metropolitan City, Kwara State Nigeria

Oseni Taiwo Amoo(1*), Habib Adedayo Salami(2), Olayinka Gafar Okeola(3), Abayomi Sunday(4), Taofeeq Sholagberu Abdulkadir(5), Adebayo Wahab Salami(6),

(1) Walter Sisulu University
(2) CIWAT Engineering Consultant, No 9 Umar Audi Road, Fate, Ilorin Kwara State, Nigeria
(3) University of Ilorin, Ilorin
(4) CIWAT Engineering Consultant, No 9 Umar Audi Road, Fate, Ilorin Kwara State, Nigeria
(5) University of Ilorin, Ilorin
(6) University of Ilorin
(*) Corresponding Author

Abstract


Water is essential for human life and activities, but its supply depends on the proximity and interconnection network with the populations or cities that need it. Moreso, the proper functioning of water supply systems (WSS) relies on the expertise and experience of field workers who rely on information from maps or field surveys, whose processes and mapping methods are labour-intensive, time-consuming, and are done relatively infrequently. This study explores modern spatial databases for meaningful technical progress using the Quantum Geographic information system (QGIS) server to host a web-based geocoding platform to view the production, transmission, and delivery of drinking water from the source to household users according to the capacities planned for by WSS. The resultant results met expert expectations on the designed web system and showed information on pipe network, road connection, drinking water distribution layout, catchment boundary, slope, and sub-catchment geometric properties demonstrating the utility of a web-based online Map plugin in the GIS environment as a data management, scenario analysis, and decision support tool in managing water infrastructure for an expanding metropolitan city like Ilorin, Kwara State.


Full Text:

PDF

References


[1] Beker, B.A. and Kansal, M.L., 2024. Complexities of the urban drinking water systems in Ethiopia and possible interventions for sustainability. Environment, Development and Sustainability, 26(2), pp.4629-4659.

[2] Agaja, T.M. and Towobola, D.O., 2022. Impact of Urban Land Use on Rainwater Quality: Case Study in Ilorin Metropolis, Nigeria. Journal of Environmental Geography, 15(1-4), pp.31-37.

[3] Mohanlal, C., Nagarajan, K. and Narwade, R., 2019. Applications of 4D GIS Model in Construction Management. International Journal of Innovative Technology and Exploring Engineering (IJITEE),(July-2019) ISSN, pp.2278-3075.

[4] Breunig, M., Bradley, P.E., Jahn, M., Kuper, P., Mazroob, N., Rösch, N., Al-Doori, M., Stefanakis, E. and Jadidi, M., 2020. Geospatial data management research: Progress and future directions. ISPRS International Journal of Geo-Information, 9(2), p.95.

[5] Asli, K.H. and Asli, K.H., 2023. Smart Water System and Internet of Things. Journal of Modern Industry and Manufacturing, 2.

[6] Zeng, Y., Cai, Y., Jia, P. and Jee, H., 2012. Development of a web-based decision support system for supporting integrated water resources management in Daegu City, South Korea. Expert Systems with Applications, 39(11), pp.10091-10102.

[7] Saravani, M.J., Saadatpour, M. and Shahvaran, A.R., 2024. A web GIS-based integrated water resources assessment tool for Javeh Reservoir. Expert Systems with Applications, 252, p.124198.

[8] Chen, W., He, B., Ma, J. and Wang, C., 2017. A WebGIS-based flood control management system for small reservoirs: a case study in the lower reaches of the Yangtze River. Journal of Hydroinformatics, 19(2), pp.299-314.

[9] Shrivastava, V., Jaiswal, A., Thakur, P.K., Agarwal, S.P., Kumar, P., Kota, G.K., Carrera, D., Dhasmana, M.K., Sharma, V. and Singh, S., 2018. Application of GIS for the design of potable water distribution system in IIRS. ISPRS Annals of the Photogrammetry, Remote Sensing and Spatial Information Sciences, 4, pp.87-94.

[10] Pérez-PadilPérez-Padillolo, J., Morillo, J.G., Poyato, E.C. and Montesinos, P., 2021. Open-source application for water supply system management: Implementation in a water transmission system in southern Spain. Water, 13(24), p.3652.

[11] Kadhim, N.R., Abdulrazzaq, K.A. and Mohammed, A.H., 2021, May. The management of water distribution network using GIS application case study: AL-Karada area. In Journal of Physics: Conference Series (Vol. 1895, No. 1, p. 012038). IOP Publishing.

[12] Luo, B., Zhang, F., Liu, X., Pan, Q. and Guo, P., 2021. Managing agricultural water considering water allocation priority based on remote sensing data. Remote Sensing, 13(8), p.1536.

[13] Dastres, R. and Soori, M., 2022. Advances in web-based decision support systems. International Journal of Engineering and Future Technology, 2021. hal-03367778f; Volume 19; Issue No. 1; ISSN 2455-6432

[14] Shah, D. and Shete, D., 2022. Attaining optimal sustainability for urban wastewater management using open-source tools like QGIS, EPANET and WATERNETGEN. In Water Resources Management and Sustainability (pp. 489-514). Singapore: Springer Nature Singapore.

[15] Schultz, G.A. and Engman, E.T. eds., 2012. Remote sensing in hydrology and water management. Springer Science & Business Media.

[16] Girgis, K., Clouse, N., Mushe, O., Morgan, P., Brooks, T. and Mahmoud, M., 2022, December. The applications of GIS in water resources. In 2022 International Conference on Computational Science and Computational Intelligence (CSCI) (pp. 1515-1520). IEEE.

[17] Mamai, L.M., Gachari, M. and Makokha, G. 2017. Developing a Web-Based Water Distribution Geospatial Information System for Nairobi Northern Region. Journal of Geographic Information System, 9, 34-46 https://doi.org/10.4236/jgis.2017.91003

[18] Sheffield, J., Wood, E.F., Pan, M., Beck, H., Coccia, G., Serrat‐Capdevila, A. and Verbist, K.J.W.R.R., 2018. Satellite remote sensing for water resources management: Potential for supporting sustainable development in data‐poor regions. Water Resources Research, 54(12), pp.9724-9758.

[19] Costantino, D.M.G.A., Angelini, M.G., Alfio, V.S., Claveri, M. and Settembrini, F., 2020. Implementation of a system WebGIS open source for the protection and sustainable management of rural heritage. Applied Geomatics, 12, pp.41-54.

[20] Martinho, N., Almeida, J.P.D., Simões, N.E. and Sá-Marques, A., 2020. UrbanWater: Integrating EPANET 2 in a PostgreSQL/PostGIS-based geospatial database management system. ISPRS International Journal of Geo-Information, 9(11), p.613.

[21] La Guardia, M., Koeva, M., D’ippolito, F. and Karam, S., 2022, October. 3D Data integration for web-based open source WebGL interactive visualisation. In 17th 3D GeoInfo Conference (pp. 89-94).

[22] Sadoun, B., Al-Bayari, O. and Al-Tawara, S., 2022. “Open-Source GIS Solution: An Overview of the Architecture of Free Open-Source Web GIS”.

[23] Xia, J., Huang, Q., Gui, Z. and Tu, W., 2024. Relational Databases. In Open GIS (pp. 97-141). Cham: Springer International Publishing.

[24] Nagarajan, K. and Charhate, S.B., 2018. Water Distribution Network: A Remote Sensing and GIS Approach. NFiCE, 2018, IIT Bombay, Author ID: ABC_1234

[25] Muller, A.L., Gericke, O.J. and Pietersen, J.P.J., 2020. Methodological approach for the compilation of a water distribution network model using QGIS and EPANET. Journal of the South African Institution of Civil Engineering, 62(4), pp.32-43.

[26] Rawlings, A. and Seghosime, S. (2022a) Design of a Water Distribution Network Using QGIS in Combination with EPANET: A Case Study of Agiliti Community in Kosofe LGA, Lagos State, Nigeria. USEP Journal of Research in Civil Engineering, Vol.18, No.4, 2021 4254-4280

[27] Rawlings, A. and Seghosime, S., 2022b. Evaluation of water supply, sanitation and hygiene facilities in Ekosodin community of Ovia North-East LGA, Benin City, Edo State, Nigeria. Nigerian Journal of Technology, 41(4), pp.632-643.

[28] Kah, E., Therry, N.T. and Innocent, N.M., 2019. GIS-Based Multi-Criteria Decision Analysis for the Sustainable Management of the Nkong Zem Pipe-Borne Water Network: West Region of Cameroon. Journal of Geographic Information System, 11(06), p.727.

[29] Solihu, H. and Bilewu, S.O., 2022. Assessment of anthropogenic activities impacts on the water quality of Asa River: A case study of Amilengbe area, Ilorin, Kwara state, Nigeria. Environmental Challenges, 7, p.100473.

[30] Kofo, A.A., 2012. Significance of 2006 head counts and house census to Nigerian sustainable development. International Journal of Academic Research in Economics and Management Sciences, 1(3), p.45.

[31] Etikan, I. and Bala, K. 2017. Sampling and sampling methods. Biometrics & Biostatistics International Journal, 5, 00149.

[32] Mitchell, A. and Education, A. E. A review of mixed methods, pragmatism, and abduction techniques. Proceedings of the European Conference on Research Methods for Business & Management Studies, 2018. 269-277.

[33] Sharma, G. 2017. Pros and cons of different sampling techniques. International journal of applied research, 3, 749-752.

[34] CIWAT (2024) Infrastructure report draft on water supply and sanitation master plan for Kwara State January 2024.

[35]Hammerle, R.J., 2001. The design of a Web-based distributed Geographic Information System. The University of New Brunswick.

[36]Pathak, D., Varde, A.S., De Melo, G. and Alo, C., 2020. Hydroinformatics and the web: Analytics and dissemination of hydrology data for climate change and sustainability. ACM SIGWEB Newsletter, 2020(Autumn), pp.1-17.

[37] Netek, R., Pohankova, T., Bittner, O. and Urban, D., 2023. Geospatial analysis in Web Browsers—Comparison study on WebGIS process-based applications. ISPRS International Journal of Geo-Information, 12(9), p.374.




DOI: https://doi.org/10.24071/ijasst.v7i1.10120

Refbacks

  • There are currently no refbacks.









Publisher : Faculty of Science and Technology

Society/Institution : Sanata Dharma University

 

 

 

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.