Supplementing Tap Water Quality Monitoring Through Customer Feedback: A GIS-Centered Approach
Abstract
1. Introduction
2. Materials and Methods
2.1. Study Area
2.2. Proposed Framework for Dynamic DWQ Monitoring
- Defining an initial DWQ monitoring program. The existing utility sampling plan was reviewed to identify current sampling locations, frequency, and monitored parameters. This formed a theoretical baseline against which subsequent refinements could be assessed.
- Setting up a data-gathering framework. A survey form was created in ArcGIS Survey123 v3.16 to collect customer feedback on perceived DWQ.
- Performing geospatial processing and analysis. Address-level responses were imported into ArcGIS Pro v3.5.4 for georeferencing, categorization, and hotspot detection.
- Refining the DWQ monitoring program. The identified hotspots were used to revise the initial sampling plan, prioritizing areas with recurring or clustered complaints.
- Resolving customer complaints through proactive interventions. Field inspections and targeted maintenance activities were initiated based on the spatial clustering of feedback. For example, flushing was prioritized in zones where discoloration and turbidity complaints were concentrated, while infrastructure renewal was considered for persistent hotspots associated with aging pipes.
- Deriving a new system baseline. The updated sampling results and maintenance records were reintegrated into the GIS environment to establish a new operational baseline. Following these interventions, customers were asked to provide feedback again through a second survey phase, enabling the comparison of perceptions before and after corrective actions.
2.3. GIS-Based Survey for Gathering Structured User Feedback
- Data export and pre-processing. Address-level survey responses were exported from ArcGIS Survey123 into ArcGIS Pro for geoprocessing and analysis. Each response was reprojected from the Web Mercator coordinate system (EPSG:3857, WGS84) to the Latvian Transverse Mercator coordinate system (EPSG:3059, LKS-92) to ensure spatial consistency with other datasets. Since no free-text responses were submitted by survey participants (only predefined issue types were used), no extensive data cleaning was required, as the dataset was already uniform.
- Categorization of reported issues. Reported problems were classified into predefined categories based on the type of issue reported by the customers and filtered to isolate distinct types for spatial analysis. In cases where multiple issues were reported in a single response, each complaint type was treated as an individual record to enable independent spatial assessment.
- Hotspot and density mapping. Hotspot analysis was applied to identify spatial clusters of reported water quality issues. Kernel Density Estimation (KDE) was conducted using the ArcGIS Pro Spatial Analyst toolbox with a cell size of 50 m and a search radius of 250 m, balancing spatial sensitivity and data sparsity. Areas exceeding the 90th percentile of density values were classified as hotspots of perceived water quality problems.
- Integration with other datasets. Identified hotspots were linked to the corresponding neighborhood polygons and associated with specific WDN pipe segments based on the utility’s asset data and expert input.
3. Results
3.1. Initial Baseline
3.2. User Feedback and Problem Hotspots
3.3. Targeted Monitoring
3.4. Focused Interventions
4. Discussion
5. Conclusions
Author Contributions
Funding
Data Availability Statement
Acknowledgments
Conflicts of Interest
References
- OECD (The Organisation for Economic Co-operation and Development). Infrastructure to 2030 (Volume 2): Mapping Policy for Electricity, Water and Transport; OECD: Paris, France, 2007; p. 510.
- Water Europe. Socio-Economic Study on the Value of EU Investing in Water; Water Europe: Brussels, Belgium, 2024; p. 324. [Google Scholar]
- Abu-Samra, S.; Ahmed, M.; Amador, L. Asset Management Framework for Integrated Municipal Infrastructure. J. Infrastruct. Syst. 2020, 26, 04020039. [Google Scholar] [CrossRef]
- Semadeni-Davies, A.; Hernebring, C.; Svensson, G.; Gustafsson, L.-G. The Impacts of Climate Change and Urbanisation on Drainage in Helsingborg, Sweden: Combined Sewer System. J. Hydrol. 2008, 350, 100–113. [Google Scholar] [CrossRef]
- Wang, X.; Zhang, J.; Shahid, S.; Guan, E.; Wu, Y.; Gao, J.; He, R. Adaptation to Climate Change Impacts on Water Demand. Mitig. Adapt. Strateg. Glob. Change 2016, 21, 81–99. [Google Scholar] [CrossRef]
- Kourtis, I.M.; Tsihrintzis, V.A. Adaptation of Urban Drainage Networks to Climate Change: A Review. Sci. Total Environ. 2021, 771, 145431. [Google Scholar] [CrossRef]
- Quitana, G.; Molinos-Senante, M.; Chamorro, A. Resilience of Critical Infrastructure to Natural Hazards: A Review Focused on Drinking Water Systems. Int. J. Disaster Risk Reduct. 2020, 48, 101575. [Google Scholar] [CrossRef]
- Kloosterman, R.A.; Herder, P.; van de Hoek, J.P. Enhancing the Resilience of Drinking Water Infrastructures. Int. J. Crit. Infrastruct. 2022, 18, 336–365. [Google Scholar] [CrossRef]
- Mays, L.W. (Ed.) Water Distribution System Handbook, 1st ed.; McGraw-Hill Education: New York, NY, USA, 2000; ISBN 978-0-07-134213-1. [Google Scholar]
- Brandt, M.J.; Johnson, K.M.; Elphinston, A.; Ratnayaka, D.D. Twort’s Water Supply, 7th ed.; Elsevier Ltd.: Amsterdam, The Netherlands; Butterworth-Heinemann: Boston, MA, USA, 2017; ISBN 978-0-08-100025-0. [Google Scholar]
- InfraGuide. Monitoring Water Quality in the Distribution System; A Best Practice by the National Guide to Sustainable Municipal Infrastructure; Federation of Canadian Municipalities and National Research Council: Ottawa, ON, Canada, 2004. [Google Scholar]
- ISO 5667-5:2006; Water Quality—Sampling—Part 5: Guidance on Sampling of Drinking Water from Treatment Works and Piped Distribution Systems. ISO: Geneva, Switzerland, 2006.
- Woo, H.-M.; Yoon, J.-H.; Choi, D.-Y. Optimal Monitoring Sites Based on Water Quality and Quantity in Water Distribution Systems. In Bridging the Gap: Meeting the World’s Water and Environmental Resources Challenges; ASCE: Reston, VA, USA, 2012; pp. 1–9. [Google Scholar] [CrossRef]
- Storey, M.V.; van der Gaag, B.; Burns, B.P. Advances in On-Line Drinking Water Quality Monitoring and Early Warning Systems. Water Res. 2011, 45, 741–747. [Google Scholar] [CrossRef]
- Salcedo, C.; Boccelli, D.L. An Integrated Framework for Supplementing Online Water Quality Monitoring in the Detection of Contamination Events in Water Distribution Networks. Eng. Proc. 2024, 69, 10. [Google Scholar] [CrossRef]
- Agresta, A.; Fattoruso, G.; Lanza, B.; Fabbricino, M.; Trifuoggi, M.; De Vito, S.; Di Francia, G. Applying Numerical Models and Optimized Sensor Networks for Drinking Water Quality Control. Procedia Eng. 2015, 119, 918–926. [Google Scholar] [CrossRef]
- Cahn, A.; Katz, D.; Ghermandi, A.; Prevos, P. Adoption of Data-as-a-Service by Water and Wastewater Utilities. Util. Policy 2023, 81, 101492. [Google Scholar] [CrossRef]
- Dietrich, A.M.; Phetxumphou, K.; Gallagher, D.L. Systematic Tracking, Visualizing, and Interpreting of Consumer Feedback for Drinking Water Quality. Water Res. 2014, 66, 63–74. [Google Scholar] [CrossRef]
- Delpla, I.; Legay, C.; Proulx, F.; Rodriguez, M.J. Perception of Tap Water Quality: Assessment of the Factors Modifying the Links between Satisfaction and Water Consumption Behavior. Sci. Total Environ. 2020, 722, 137786. [Google Scholar] [CrossRef]
- Rolston, A.; Jennings, E.; Linnane, S. Water Matters: An Assessment of Opinion on Water Management and Community Engagement in the Republic of Ireland and the United Kingdom. PLoS ONE 2017, 12, e0174957. [Google Scholar] [CrossRef]
- Mariani, L.; Trivellato, B.; Martini, M.; Marafioti, E. Achieving Sustainable Development Goals Through Collaborative Innovation: Evidence from Four European Initiatives. J. Bus. Ethics 2022, 180, 1075–1095. [Google Scholar] [CrossRef] [PubMed]
- ISO 31000:2018; Risk Management—Guidelines. ISO: Geneva, Switzerland, 2018.
- Sarkar, M.; SP Group LLC. Perceptions of Drinking Water Quality—A Review of the Literature and Surveys Covering the Topic; Office of Policy Development and Research (PD&R): Washington, DC, USA, 2022; p. 41.
- Balta Kaç, S.; Eken, S. Customer Complaints-Based Water Quality Analysis. Water 2023, 15, 3171. [Google Scholar] [CrossRef]
- Lambert, L.H.; Bir, C. Evaluating Water Quality Using Social Media and Federal Agency Data. J. Water Health 2021, 19, 959–974. [Google Scholar] [CrossRef]
- Rapousis, N.; Papadopouli, M. Performance Analysis of a User-Centric Crowd-Sensing Water Quality Assessment System. In Proceedings of the 2016 International Workshop on Cyber-Physical Systems for Smart Water Networks (CySWater), Vienna, Austria, 11 April 2016; pp. 13–18. [Google Scholar] [CrossRef]
- Rapousis, N.; Katsarakis, M.; Papadopouli, M. QoWater: A Crowd-Sourcing Approach for Assessing the Water Quality. In Proceedings of the 1st ACM International Workshop on Cyber-Physical Systems for Smart Water Networks, Seattle, WA, USA, 13–16 April 2015; p. 11. [Google Scholar] [CrossRef]
- Whelton, A.J.; Dietrich, A.M.; Gallagher, D.L.; Roberson, J.A. Using Customer Feedback for Improved Water Quality and Infrastructure Monitoring. J.-Am. Water Works Assoc. 2007, 99, 62–76. [Google Scholar] [CrossRef]
- U.S. Environmental Protection Agency. Response Protocol Toolbox: Planning for and Responding to Drinking Water Contamination Threats and Incidents: Response Guidelines; Environmental Protection Agency: Washington, DC, USA, 2004; p. 69.
- Hasan, J.; Goldbloom-Helzner, D.; Ichida, A.; Rouse, T.; Gibson, M. Technologies and Techniques for Early Warning Systems to Monitor and Evaluate Drinking Water Quality: A State-of-the-Art Review; Environmental Protection Agency: Washington, DC, USA, 2005; p. 236.
- Montenegro, P.; Rodriguez, M.J.; Miranda, L.F.; Joerin, F.; Proulx, F. Occurrence of Citizen Complaints Concerning Drinking Water: A Case Study in Quebec City. J. Water Supply Res. Technol.-AQUA 2009, 58, 257–266. [Google Scholar] [CrossRef]
- Lee, J.; Nam, S.-H.; Koo, J.-W.; Shin, Y.; Kim, E.; Song, J.; Hwang, T.-M. Detecting Clusters and Tracing Management of Water Distribution System Using Space–Time Scan Statistics and Utility Network Modeling. Process Saf. Environ. Prot. 2024, 187, 249–258. [Google Scholar] [CrossRef]
- Oficiālās Statistikas Portāls. Iedzīvotāju Skaits gada Sākumā, tā Izmaiņas un Dabiskās Kustības Galvenie Rādītāji Reģionos, Pilsētās un Novados 2012–2023. Available online: https://data.stat.gov.lv:443/pxweb/lv/OSP_PUB/START__POP__IR__IRS/IRS031/ (accessed on 18 March 2024).
- Oficiālās Statistikas Portāls. Pastāvīgo Iedzīvotāju Blīvums Reģionos, Pilsētās, Novados un Pagastos gada Sākumā 2022–2023. Available online: https://data.stat.gov.lv:443/pxweb/lv/OSP_PUB/START__POP__IR__IRD/IRD062/ (accessed on 18 March 2024).
- Ūdenssaimniecības Pakalpojumu Sniedzēju 2016.–2022.gada Darbības Rādītāju Salīdzinājums. Available online: https://www.sprk.gov.lv/content/nozares-raditaji-0 (accessed on 18 March 2024).
- Gibson, J.; Karney, B.; Guo, Y. Water Quality and Fire Protection Trade-Offs in Water Distribution Networks. J. AWWA 2019, 111, 44–52. [Google Scholar] [CrossRef]
- Latvijas Republikas Ministru kabinets. Dzeramā ūdens Obligātās Nekaitīguma un Kvalitātes Prasības, Monitoringa un Kontroles Kārtība [Mandatory Harmlessness and Quality Requirements for Drinking Water, and the Procedures for Monitoring and Control Thereof]; Latvijas Republikas Ministru kabinets: Riga, Latvia, 2023; Volume OP 2023/188.7.
- Tscheikner-Gratl, F.; Caradot, N.; Cherqui, F.; Leitão, J.P.; Ahmadi, M.; Langeveld, J.G.; Le Gat, Y.; Scholten, L.; Roghani, B.; Rodríguez, J.P.; et al. Sewer Asset Management–State of the Art and Research Needs. Urban Water J. 2019, 16, 662–675. [Google Scholar] [CrossRef]
- Le Gat, Y.; Curt, C.; Werey, C.; Caillaud, K.; Rulleau, B.; Taillandier, F. Water Infrastructure Asset Management: State of the Art and Emerging Research Themes. Struct. Infrastruct. Eng. 2023, 21, 539–562. [Google Scholar] [CrossRef]
- Okwori, E.; Viklander, M.; Hedström, A. Data Integration in Asset Management of Municipal Pipe Networks in Sweden: Challenges, Gaps, and Potential Drivers. Util. Policy 2024, 86, 101689. [Google Scholar] [CrossRef]
- de França Doria, M. Factors Influencing Public Perception of Drinking Water Quality. Water Policy 2009, 12, 1–19. [Google Scholar] [CrossRef]
- Pierce, G.; Gonzalez, S. Mistrust at the Tap? Factors Contributing to Public Drinking Water (Mis)Perception across US Households. Water Policy 2016, 19, 1–12. [Google Scholar] [CrossRef]
- Robak, A.; Robak, A. Perceived vs Measured Water Supply Service: Evidence from New Zealand. Int. J. Water Resour. Dev. 2021, 38, 938–963. [Google Scholar] [CrossRef]
- Karmakar, D.; Sarkar, B.; Islam, N. Drinking Water Quality in Cooch Behar Municipality, West Bengal, India: Assessment Using WQI and Public Perception. Environ. Qual. Manag. 2024, 34, e22226. [Google Scholar] [CrossRef]
- Lucas, S.A.; Coombes, P.J.; Sharma, A.K. The Impact of Diurnal Water Use Patterns, Demand Management and Rainwater Tanks on Water Supply Network Design. Water Supply 2010, 10, 69–80. [Google Scholar] [CrossRef]
- Loureiro, D.; Mamade, A.; Cabral, M.; Amado, C.; Covas, D. A Comprehensive Approach for Spatial and Temporal Water Demand Profiling to Improve Management in Network Areas. Water Resour. Manag. 2016, 30, 3443–3457. [Google Scholar] [CrossRef]
- Faure, J.C.; Faust, K.M. Socioeconomic Characteristics versus Density Changes: The Operational Effects of Population Dynamics on Water Systems. Sustain. Resilient Infrastruct. 2023, 8, 3–16. [Google Scholar] [CrossRef]
- Zhuang, J.; Sela, L. Network Effects of Evolving Water Demand Patterns. In Proceedings of the World Environmental and Water Resources Congress 2018, Minneapolis, MN, USA, 3–7 June 2018; pp. 93–104. [Google Scholar] [CrossRef]
- Zhuang, J.; Sela, L. Impact of Emerging Water Savings Scenarios on Performance of Urban Water Networks. J. Water Resour. Plan. Manag. 2020, 146, 04019063. [Google Scholar] [CrossRef]
- Hatam, F.; Ebacher, G.; Prévost, M. Stringency of Water Conservation Determines Drinking Water Quality Trade-Offs: Lessons Learned from a Full-Scale Water Distribution System. Water 2021, 13, 2579. [Google Scholar] [CrossRef]
- Pesantez, J.E.; Alghamdi, F.; Sabu, S.; Mahinthakumar, G.; Berglund, E.Z. Using a Digital Twin to Explore Water Infrastructure Impacts during the COVID-19 Pandemic. Sustain. Cities Soc. 2022, 77, 103520. [Google Scholar] [CrossRef] [PubMed]
- Vizanko, B.; Kadinski, L.; Ostfeld, A.; Berglund, E.Z. Social Distancing, Water Demand Changes, and Quality of Drinking Water during the COVID-19 Pandemic. Sustain. Cities Soc. 2024, 102, 105210. [Google Scholar] [CrossRef]
- Baird, G.M. New U.S. and International Water Main Break Studies: More Detailed Pipe Analysis but What Are We Doing with the Data? In Proceedings of the Pipelines 2020, San Antonio, TX, USA, 9–12 August 2020; pp. 316–325. [Google Scholar]
- Okwori, E.; Pericault, Y.; Ugarelli, R.; Viklander, M.; Hedström, A. Data-Driven Asset Management in Urban Water Pipe Networks: A Proposed Conceptual Framework. J. Hydroinform. 2021, 23, 1014–1029. [Google Scholar] [CrossRef]





| Neighborhood | Population * | Total Pipe Length, km ** | Per Capita Pipe Length, m/pers. | Avg. Pipe Age, yrs. *** | 
|---|---|---|---|---|
| Majori (MA) | 4518 | 28.635 | 6.34 | 29.3 | 
| Dzintari (DZ) | 3045 | 35.070 | 11.52 | 20.6 | 
| Bulduri (BU) | 3700 | 24.341 | 6.58 | 36.5 | 
| Lielupe (LI) | 1949 | 22.182 | 11.38 | 29.1 | 
| Buļļuciems (BL) | 942 | 7.943 | 8.43 | 18.0 | 
| Total (Avg.) | 14,154 | 118.171 | (8.83) | (26.7) | 
| Parameter | Unit | Average | Range | Limit * | 
|---|---|---|---|---|
| pH | — | 7.7 | 7.5–7.8 | 6.5–9.5 | 
| Turbidity | NTU | 0.75 | 0.01–0.22 | A.B.C. ** | 
| Total iron | µg/L | 11 | 1–20 | 200 | 
| Hardness | mmol/L | 3.20 | 2.70–4.09 | – | 
| Sulfates | mg/L | 199 ± 8 | 189–214 | 250 | 
| Chlorides | mg/L | 165 ± 10 | 143–174 | 250 | 
| Electroconductivity | µS/cm | 1136 ± 27 | 1113–1218 | 2500 | 
| Permanganate index | mg O2/L | 0.29 ± 0.11 | 0.16–0.51 | 5 | 
| E. coli | 0 | 0 | 0 | 
| Neighborhood | Respondents | Engagement, % | Complaints, ‰ | |||
|---|---|---|---|---|---|---|
| Phase I | Phase II | Phase I | Phase II | Phase I | Phase II | |
| Majori (MA) | 33 | 13 | 2.2 | 0.9 | 5.8 | 1.8 | 
| Dzintari (DZ) | 25 | 10 | 2.9 | 1.1 | 6.9 | 2.0 | 
| Bulduri (BU) | 39 | 11 | 5.2 | 1.5 | 9.7 | 2.7 | 
| Lielupe (LI) | 25 | 4 | 3.8 | 0.6 | 12.3 | 2.1 | 
| Buļļuciems (BL) | 26 | 11 | 9.7 | 4.1 | 27.6 | 9.6 | 
| Total (Avg.) | 148 | 49 | (4.8) | (1.6) | (12.5) | (3.6) | 
| Disclaimer/Publisher’s Note: The statements, opinions and data contained in all publications are solely those of the individual author(s) and contributor(s) and not of MDPI and/or the editor(s). MDPI and/or the editor(s) disclaim responsibility for any injury to people or property resulting from any ideas, methods, instructions or products referred to in the content. | 
© 2025 by the authors. Licensee MDPI, Basel, Switzerland. This article is an open access article distributed under the terms and conditions of the Creative Commons Attribution (CC BY) license (https://creativecommons.org/licenses/by/4.0/).
Share and Cite
Dakša, G.; Kokina, K. Supplementing Tap Water Quality Monitoring Through Customer Feedback: A GIS-Centered Approach. Water 2025, 17, 3103. https://doi.org/10.3390/w17213103
Dakša G, Kokina K. Supplementing Tap Water Quality Monitoring Through Customer Feedback: A GIS-Centered Approach. Water. 2025; 17(21):3103. https://doi.org/10.3390/w17213103
Chicago/Turabian StyleDakša, Gints, and Kristīna Kokina. 2025. "Supplementing Tap Water Quality Monitoring Through Customer Feedback: A GIS-Centered Approach" Water 17, no. 21: 3103. https://doi.org/10.3390/w17213103
APA StyleDakša, G., & Kokina, K. (2025). Supplementing Tap Water Quality Monitoring Through Customer Feedback: A GIS-Centered Approach. Water, 17(21), 3103. https://doi.org/10.3390/w17213103
 
        


 
       