Abstract
Water utilities have large amounts of data at their disposal, which are seldom being used to their full potential. Integrating water billing records with land-use and demographic data organizes information and makes inherent correlations easier to understand, facilitating communication to stakeholders. This data was integrated for three Ontario (Canada) municipalities, Barrie, Guelph, and London. A summary tool was created, with proposed metrics and charts, that facilitates comparisons between cities, definition of benchmarks, and identification of targets for conservation. More than 60% of consumption in these cities is residential, and mostly lies below the Ontario average of . Water user clusters were created through self-organizing maps, K-means, and hierarchical clustering, and selected according to their pseudo-F and Rand statistics. Users within the same or similar property codes were found to cluster together. The application of data-mining methods provides actionable information for utilities seeking to reduce demands and increase system sustainability.
Get full access to this article
View all available purchase options and get full access to this article.
Acknowledgments
This paper is partly based on case study research conducted within the project “Integrated Water Mapping: Enhancing Decision Support for Sustainable Water Planning with Municipal Data,” by Cities Centre and the Canadian Urban Institute, and funded by the Ontario Ministry of Environment through the Showcasing Water Innovations program. However, the findings, interpretations, and conclusions in this document are entirely those of the authors, and should not be attributed to the aforementioned organizations. The authors acknowledge the inputs of Tom Weatherburn, Kathryn Grond, Wayne Galliher, Matt Feldberg, and Barry Thompson.
References
Boyle, C. E., Eskaf, S., Tiger, M. W., and Hughes, J. A. (2011). “Mining water billing data to inform policy and communication strategies.” Am. Water Works Assoc. J., 103(11), 45–58.
Brooks, D. B. (2006). “An operational definition of water demand management.” Water Resour. Dev., 22(4), 521–528.
Brun, M., et al. (2007). “Model-based evaluation of clustering validation measures.” Pattern Recognit., 40(3), 807–824.
Cahill, R., and Lund, J. (2013). “Residential water conservation in Australia and California.” J. Water Resour. Plann. Manage., 117–121.
Donkor, E. A., Mazzuchi, T. A., Soyer, R., and Roberson, J. A. (2014). “Urban water demand and forecasting: Review of methods and models.” J. Water Resour. Plann. Manage., 146–159.
Dziegielewski, B., and Kiefer, J. C. (2010). Water conservation measurement metrics: Guidance report, AWWA, Denver, CO.
Environment Canada. (2010). “Municipal water use report: Municipal water use, 2006 statistics.” Gatineau, QC.
Gleick, P. H., et al. (2003). Waste not, want not: The potential for urban water conservation in California, Pacific Institute, Oakland, CA.
Hillenmeyer, M. (2005). “Machine learning.” Stanford Univ., Stanford, CA.
Hussey, K., and Pittock, J. (2012). “The energy–water nexus: Managing the links between energy and water for a sustainable future.” Ecol. Soc., 17(1), 31.
Jorgensen, B., Graymore, M., and O’Toole, K. (2009). “Household water use behavior: An integrated model.” J. Environ. Manage., 91(1), 227–236.
Lee, J. A., and Verleysen, M. (2002). “Self-organizing maps with recursive neighborhood adaptation.” Neural Networks, 15(8–9), 993–1003.
Morton, J. (2011). “Water management: A benchmark for Canadian office buildings.” Real Property Association of Canada, Toronto, ON.
Maas, C. (2009). “H2Ontario: A blueprint for a comprehensive water conservation strategy.” Water Sustainability Project, POLIS Project on Ecological Governance, Victoria, BC.
Maidment, D. R. (2008). “Bringing water data together.” J. Water Resour. Plann. Manage., 95–96.
Morales, M. A., Heaney, J. P., Friedman, K. R., and Martin, J. M. (2011). “Estimating commercial, industrial, and institutional water use on the basis of heated building area.” Am. Water Works Assoc. J., 103(6), 84–96.
Muste, M. V., et al. (2013). “End-to-end cyberinfrastructure for decision-making support in watershed management.” J. Water Resour. Plann. Manage., 565–573.
Ontario Water Works Association (OWWA). (2006). “Water efficiency: A guidebook for small & medium-sized municipalities in Canada.” Markham, ON.
Polebitski, A. S., and Palmer, R. N. (2010). “Seasonal residential water demand forecasting for census tracts.” J. Water Resour. Plann. Manage., 27–36.
Sahely, H. A., and Kennedy, C. A. (2007). “Water use model for quantifying environmental and economic sustainability indicators.” J. Water Resour. Plann. Manage., 550–559.
South East Water (SEW). (2006). Benchmarking Rep., Melbourne, Australia.
Shandas, V., and Parandvash, G. H. (2009). “Integrating urban form and demographics in water-demand management: An empirical case study of Portland, Oregon.” Environ. Plann. B Plann. Des., 37(1), 112–128.
Tan, P., Steinbach, M., and Kumar, V. (2006). “Cluster analysis: Basic concepts and algorithms.” Chapter 8, Introduction to data mining, Addison-Wesley, Boston, MA.
United Nations Conference on Environment, and Development. (1992). “Agenda 21.” Chapter 18, Protection of the quality and supply of freshwater resources: Application of integrated approaches to the development, management and use of water resources, Earth Summit.
United Nations Environmental Programme (UNEP). (2012). The UN Water Status Rep. on the Application of Integrated Approaches to Water Resources Management.
Vesanto, J., and Alhoniemi, E. (2000). “Clustering of the self-organizing map.” IEEE Trans. Neural Networks, 11(3), 586–600.
Xu, R., and Wunsch, D. C. (2009). “Clustering.” Chapter 2, Proximity measures, IEEE, Wiley, Piscataway, NJ.
Information & Authors
Information
Published In
Copyright
© 2014 American Society of Civil Engineers.
History
Received: Jan 22, 2014
Accepted: May 15, 2014
Published online: Jul 21, 2014
Discussion open until: Dec 21, 2014
Published in print: Apr 1, 2015
Authors
Metrics & Citations
Metrics
Citations
Download citation
If you have the appropriate software installed, you can download article citation data to the citation manager of your choice. Simply select your manager software from the list below and click Download.