Abstract:The University of Zambia like any public institution has a lot of infrastructure which require maintenance and management. There’s however uncertainty of the utility lines locations and their depths. This causes destruction of water pipes and sewer lines when undertaking new constructions or any excavations. The lack of accurate location of underground and un-updated lines makes maintenance, management and planning of the utilities very difficult. Therefore this study aimed to build a framework for Managing Sewer and Water Networks Using Sensor Networks at the University of Zambia. The Resident Engineer’s office only has some old scanned pdf sketches of both sewer and water networks. The field engineers locate most lines and other facilities using memory and experience. The methodology involved understating the existing operations of the Resident engineer’s office to ascertain the user needs. These needs formed the basis of the research, the development and design of the prototype of the Webbased Framework. Data Collection tools included Records (old maps) and Secondary Data (satellite images), Field Observations, Interviews and field Surveys. A presurvey (Reconnaissance Survey) was done to have an idea of the existing infrastructure and a more accurate survey was done using GPS GNSS equipment. The raw data was processed and GIS software was used to merge the collected datasets and the existing data. Georeferencing of existing maps and the satellite images was done using the GPS field data in ArcMap. New shapefiles were created from the point data from the survey and from digitising the existing scanned maps. New maps of the water and sewer networks (using the new shapefiles) and satellite imagery were created. A 15 digit coding system was created and was used to assign unique identification numbers and extra attribute information to the water and sewer network shapefiles. A QR code was generated for each node and the serial number recorded. Tagging was done using the QR code for each structure. All the shapefiles were loaded into a PostGreSQL spatial database and were used as input in the Web GIS application. The web application had some tools imbedded in it including; query, measure, add point/vertex, zoom, view, search and identify. Using internet of things (IOT) technology, water level sensors were placed on some critical manholes to help with the monitoring of the sewerage network. The system can therefore be used for identification of any infrastructure by scanning the QR code and a map showing the structure is seen online by the field technicians. Monitoring of the sewer system can be done using the sensors and ultimately the framework will ease the management of the water and sewer systems at the University of Zambia.

Smart GIS platform that facilitates the digitalization of the integrated urban drainage system

Development of a Geospatial Data-Based Methodology for Stormwater Management in Urban Areas Using Freely-Available Software

Foul Sewer Model Development Using Geotagged Information and Smart Water Meter Data.

Combining small-scale sustainable drainage systems with real-time control systems

A GIS-based 3D Visual Simulation System for Flood Protection

MODCEL-MHUS: a comprehensive multilayer hydrodynamic unified simulation for stormwater, sanitary sewer systems, and urban surface

Designing a Spatially-explicit Urban Digital Twin Framework for Smart Water Infrastructure and Flood Management

A participatory system dynamics model to investigate sustainable urban water management in Ebbsfleet Garden City

A Spatial Framework for Managing Sewer and Water Networks Using Sensor Networks: A Case of the University of Zambia

Smart Water Management towards Future Water Sustainable Networks

Leveraging Urban Water Distribution Systems with Smart Sensors for Sustainable Cities

Socio-hydrological modelling using participatory System Dynamics modelling for enhancing urban flood resilience through Blue-Green Infrastructure

Urban Flood Risk and Economic Viability Analyses of a Smart Sustainable Drainage System

A digital water strategy based on the digital water service concept to support asset management in a real system

A Protocol to Convert Infrastructure Data from Computer-Aided Design (CAD) to Geographic Information Systems (GIS)

Urban pluvial flood modelling in the absence of sewer drainage network data: A physics-based approach

Integrated and Control-Oriented Simulation Tool for Optimizing Urban Drainage System Operation

Rainfall-Runoff Simulations to Assess the Potential of SuDS for Mitigating Flooding in Highly Urbanized Catchments

Performance simulation of wastewater networks. Case study of Nora-Noreña network in Asturias (Spain)

Smart Water Management System

Software Systems Approach to Multi-Scale GIS-BIM Utility Infrastructure Network Integration and Resource Flow Simulation