Water Consumption Range Prediction in Huelva’s Households Using Classification and Regression Trees
Abstract
:1. Introduction
- Understand water and its context. It could be understood as the knowledge about water.
- Value water through emotions and the development of positive attitudes, such as:
- Support for alternative sources of water.
- Pro-environmental perspective: the environmental identity of the home.
- Support the smartest daily behavior regarding water in different spheres,
- Public:
- Through the influence on political processes.
- Support and pressure to repair damaged waterways.
- Private:
- By saving and using water efficiently.
- Using water-saving devices.
- Reducing water pollution.
- the attitudes about “Efficient use in cleaning.”
- the components associated with water literacy. Fundamental is the household knowledge about the water cycle and Education variables.
2. Materials and Methods
- Evaluate the degree of knowledge of consumers about the challenges associated with water’s sustainable use.
- Identify their needs and values as consumers.
- Evaluate attitudes towards different aspects of water:
- Attitude towards consumption efficiency.
- Attitude towards the adoption of technological devices in the home related to water.
- Attitude towards reclaimed water in the home.
- Determine prototype solutions that help raise awareness and value water use sustainability, proposing specific actions to consumers that address part of their needs at the same time.
- Demographic characteristics: such as age, gender, education, annual income, and professional occupation. For the purposes of this paper, we would like to highlight the independent qualitative variables:
- “Education”, which measures the educational level of households, with the following possible values:
- No studies.
- Basic studies.
- Bachelor.
- University studies.
- “Professional occupation”, which measures the origin of income sources, with the following values:
- Unemployed.
- Employed.
- Self-Employed.
- Retired.
- “Income”, which measures the range of household income, with the following values:
- Less than 10,302 €/year.
- From 10,302 € to 25,000 €/year.
- From 25,000 € to 50,000 €/year
- From 50,000 € to 100,000 €/year.
- Home characteristics: Number of people in the household, children in the home, surface area, age.
- Life experiences and psychosocial factors: Household activities around the city water, active participation in any social organization, and if they have suffered any water restriction.
- Needs, values, and identity regarding water: The importance of different aspects of water, consumption concerning neighbors, identification of better use of water within the home, the possibility of the investment amount in water-saving devices, and acceptance of water regenerated in the home (support to alternative sources of water, basically regenerated rain water).
- Knowledge of the home regarding the integral water cycle, ordered in the following blocks: uptake, treatment, distribution, sewerage networks, purification, and regeneration.
- Huelva area to which the home belongs: Six possible areas that correspond to the social districts that Huelva’s City Council applies to the city.
- Average consumption per person within the home: liters/person/day. They correspond to the average of the year 2018.
- Consumption range of each household, according to this classification agreed with Aguas de Huelva:
- Less than 100 L/person/day is low consumption.
- Between 100 and 130 L/person/day is a medium consumption [34].
- More than 130 L/person/day is high consumption.
- The average consumption per inhabitant per day in households managed by Aguas de Huelva is 126.5 L/inhabitant/day.
- The minimum vital water consumption set by the World Health Organization is set to 50 L/inhabitant/day [39].
- Low knowledge range: Scores lower than 4 (minimum is 0 points).
- Medium knowledge range: Scores between 4 and 6.
- High knowledge range: Scores equal to or greater than 7 (maximum is 10 points).
- Component 1 = Quality of service/health. This component explains what households value most. They are aspects related to water quality and its impact on health.
- Component 2 = Quality of infrastructure. Aspects related to the water network’s infrastructure, such as breakdowns in the network, cuts in the water service in the home, low water pressure in the home, and flood management.
- Component 3 = Customer Relationship Management (CRM). It is the value of the household’s relationship with the water company. It shows the importance of the service brand of Aguas de Huelva among households. It is significant because it is useful to characterize the trust households could have in the service company. It is the beginning to predict reaction to engagement issues proposed to them in the later stages of the project.
- Component 1 = General efficient use to improve the efficiency consume of water in the home. “There is an association of variables that would explain a general use to improve the efficiency of water in the home” [1]. Households show a positive attitude to improve water use in this field.
- Component 2 = Efficient use in cleaning for personal or household purposes. “A group associated with a field of improvement in water use in personal or household cleaning tasks” [1].
- Component 3 = Water saving devices.
- Component 4 = Reclaimed water for washing machine, toilet, garden, and no case.
- Component 5 = All previous cases at a lower price.
3. Results
- Component 1 = Quality of service/health.
- Component 2 = Quality of infrastructure.
- Component 3 = CRM.
- General efficient use.
- Efficient use in cleaning.
- Water-saving devices.
- Reclaimed water for washing machine, toilet, garden, and no case.
- All previous cases at a lower price.
4. Discussion
Author Contributions
Funding
Institutional Review Board Statement
Informed Consent Statement
Data Availability Statement
Acknowledgments
Conflicts of Interest
Abbreviations
AMI | Advanced Metering Infrastructures. |
CART | Classification and Regression Trees |
CRM | Customer Relationship Management |
DT | Design Thinking |
ETSII | Escuela Técnica Superior de Ingenieros Industriales |
ICT | Information and Communication Technology |
IPO | Initial Public Offering |
LDA | Linear Discriminant Analysis |
SDG | Sustainable Development Goals |
UP4 | Network of Spanish Technical Universities |
UPM | Universidad Politécnica de Madrid |
WDM | Water Demand Management |
References
- Bermejo-Martín, G.; Rodríguez-Monroy, C.; Núñez-Guerrero, Y.M. Design Thinking for Urban Water Sustainability in Huelva’s Households: Needfinding and Synthesis through Statistic Clustering. Sustainability 2020, 12, 9163. [Google Scholar] [CrossRef]
- Habitat III. The United Nations Conference on Housing and Sustainable Urban Development. Quito, Ecuador, from 17–20 October 2016. Available online: https://unhabitat.org/habitat-iii (accessed on 15 December 2020).
- Fourth Global Report on Decentralization and Local Democracy. Co-Creating the Urban Future the Agenda of Metropolises, Cities and Territories 2016. Available online: https://www.gold.uclg.org/sites/default/files/GOLDIV_ENG.pdf (accessed on 15 December 2020).
- Veenhoven, R. Happy life-expectancy. Soc. Indic. Res. 1996, 39, 1–58. [Google Scholar] [CrossRef] [Green Version]
- Brundtland, G.H. World Commission on Environment and Development (WCED). Our Common Future 1987, 17, 1–91. Available online: http://www.un-documents.net/wced-ocf.htm (accessed on 15 December 2020).
- Bermejo-Martín, G.; Rodríguez-Monroy, C. Design Thinking Methodology to Achieve Household Engagement in Urban Water Sustainability in the City of Huelva (Andalusia). Water 2020, 12, 1943. [Google Scholar] [CrossRef]
- De Haan, F.J.; Ferguson, B.C.; Adamowicz, R.C.; Johnstone, P.; Brown, R.R.; Wong, T.H.F. The needs of society: A new understanding of transitions, sustainability and liveability. Technol. Forecast. Soc. Chang. 2014, 85, 121–132. [Google Scholar] [CrossRef]
- Dean, A.J.; Lindsay, J.; Fielding, K.S.; Smith, L.D.G. Fostering water sensitive citizenship—Community profiles of engagement in water-related issues. Environ. Sci. Policy 2016, 55, 238–247. [Google Scholar] [CrossRef]
- Popat, S.; Emmanuel, M. Review and comparative study of clustering techniques. Int. J. Comput. Sci. Inf. Tech. 2014, 5, 805–812. [Google Scholar]
- Kujawin’ska, A.; Rogalewicz, M.; Diering, M. Application of expectation maximization method for purchase decision-making support in welding branch. Manag. Prod. Eng. Rev. 2016, 7, 29–33. [Google Scholar]
- Wierzbicka, W. Socio-economic potential of cities belonging to the Polish National Cittaslow Network. Oeconomia Copernic. 2020, 11, 203–224. [Google Scholar] [CrossRef]
- Potthoff, T.; Siemon, D.; Wilms, K.; Möser, S.; Hellmann, M.; Stieglitz, S.; Robra-Bissantz, S. Collaborative Service Blueprinting for Design Thinking: Evaluation of a Digital Prototype. In Proceedings of the 51st Hawaii International Conference on System Sciences, Waikoloa Village, HI, USA, 3–6 January 2018; Available online: http://hdl.handle.net/10125/50467 (accessed on 15 December 2020).
- ME310. ME310 Design Innovation at Stanford University. 2010. Available online: https://web.stanford.edu/group/me310/me310_2016/ (accessed on 15 December 2020).
- Lee, M.; Tansel, B.; Balbin, M. Urban Sustainability Incentives for Residential Water Conservation: Adoption of Multiple High Efficiency Appliances. Water Resour. Manag. 2013, 27, 2531–2540. [Google Scholar] [CrossRef]
- Loh, W.-Y. Fifty Years of Classification and Regression Trees. Int. Stat. Rev. 2014, 82, 329–348. [Google Scholar] [CrossRef] [Green Version]
- Rusch, T.; Zeileis, A. Fifty Years of Classification and Regression Trees. Discussions. Int. Stat. Rev. 2014, 82, 361–367. [Google Scholar] [CrossRef] [Green Version]
- Kass, G.V. An exploratory technique for investigating large quantities of categorical data. Ann. Appl. Stat. 1980, 29, 119–127. [Google Scholar] [CrossRef]
- Quinlan, J.R. Learning with continuous classes. In Proceedings of the 5th Australian Joint Conference on Artificial Intelligence; World Scientific: Singapore, 1992; pp. 343–348. [Google Scholar]
- Quinlan, J.R. Induction of decision trees. Mach. Learn. 1986, 1, 81–106. [Google Scholar] [CrossRef] [Green Version]
- Loh, W.-Y.; Vanichsetakul, N. Tree-structured classification via generalized discriminant analysis (with discussion). J. Amer. Statist. Assoc. 1988, 83, 715–728. [Google Scholar] [CrossRef]
- Loh, W.-Y.; Shih, Y.-S. Split selection methods for classification trees. Stat. Sin. 1997, 7, 815–840. [Google Scholar]
- Kim, H.; Loh, W.-Y. Classification trees with unbiased multiway splits. J. Amer. Statist. Assoc. 2001, 96, 589–604. [Google Scholar] [CrossRef] [Green Version]
- Loh, W.-Y. Improving the precision of classification trees. Ann. Appl. Stat. 2009, 3, 1710–1737. [Google Scholar] [CrossRef] [Green Version]
- Hothorn, T.; Hornik, K.; Zeileis, A. Unbiased recursive partitioning: A conditional inference framework. J. Comput. Graph. Stat. 2006, 15, 651–674. [Google Scholar] [CrossRef] [Green Version]
- Reto 2: Uso Sostenible Agua. Available online: http://i2t.webs.upv.es/documentos/Reto2SUEZ.pdf (accessed on 15 December 2020). (In Spanish).
- Aguas de Huelva. Available online: https://www.aguashuelva.com/retos-sociales-retos-compartidos/ (accessed on 15 December 2020). (In Spanish).
- Tannian, M.F. Embracing Quality with Design Thinking. In The Future of Software Quality Assurance; Goericke, S., Ed.; Springer: Cham, Switzerland, 2020; pp. 161–174. [Google Scholar]
- Newton, P.; Meyer, D. Exploring the Attitudes-Action Gap in Household Resource Consumption: Does Environmental Lifestyle Segmentation Align with Consumer Behaviour? Sustainability 2013, 5, 1211–1233. [Google Scholar] [CrossRef] [Green Version]
- Dean, A.J.; Fielding, K.S.; Newton, F.J. Community Knowledge about Water: Who Has Better Knowledge and Is This Associated with Water-Related Behaviors and Support for Water-Related Policies? PLoS ONE 2016, 11, e0159063. [Google Scholar] [CrossRef] [Green Version]
- Willis, R.M.; Stewart, R.A.; Giurco, D.P.; Talebpour, M.R.; Mousavinejad, A. End Use Water Consumption in Households: Impact of Socio-Demographic Factors and Efficient Devices. J. Clean. Prod. 2013, 60, 107–115. [Google Scholar] [CrossRef] [Green Version]
- Beal, C.D.; Flynn, J. Toward the digital water age: Survey and case studies of Australian water utility smart-metering programs. Util. Policy 2015, 32, 29–37. [Google Scholar] [CrossRef] [Green Version]
- Fielding, K.S.; van Kasteren, Y.; Louis, W.; McKenna, B.; Russell, S.; Spinks, A. Using individual householder survey responses to predict household environmental outcomes: The cases of recycling and water conservation. Resour. Conserv. Recycl. 2016, 106, 90–97. [Google Scholar] [CrossRef]
- Willis, R.M.; Stewart, R.A.; Panuwatwanich, K.; Williams, P.R.; Hollingsworth, A.L. Quantifying the influence of environmental and water conservation attitudes on household end use water consumption. J. Environ. Manag. 2011, 92, 1996–2009. [Google Scholar] [CrossRef] [Green Version]
- Hehn, J.; Uebernickel, F.; Herterich, M. “Design Thinking Methods for Service Innovation—A Delphi Study–” (2018). PACIS 2018 Proceedings. 126. Available online: https://aisel.aisnet.org/pacis2018/126 (accessed on 15 December 2020).
- Depiné, Á.; de Azevedo, I.S.C.; Santos, V.C.; Eleutheriou, C.S.T. Smart Cities and Design Thinking: Sustainable development from the citizen’s perspective. In Proceedings of the February 2017 Conference: IV Regional Planning Conference, Aveiro, Portugal, 23–24 February 2017. [Google Scholar]
- Van Waas, R.P. Designing an Integrative Approach to Regional Water Schemes in South Africa. Ph.D. Thesis, TU Delft, Delft University of Technology, Delft, The Netherlands, 2015. [Google Scholar]
- Blanco, T.; Casas, R.; Asensio, A.; Tamargo, A. Diseño de la gestión del ciclo del agua en pequeños núcleos urbanos mediante Design Thinking. Dyna 2018, 93, 114–119. [Google Scholar]
- Pruneau, D.; El Jai, B.; Khattabi, A.; Benbrahim, S.; Langis, J. Using design thinking and Facebook to accompany women in solving water problems in Morocco. In Handbook of Sustainability Science and Research; World Sustainability Series; Filho, W., Ed.; Springer: Berlin, Germany, 2018. [Google Scholar]
- United Nations Department of Economic and Social Affairs (UNDESA). Available online: https://www.un.org/waterforlifedecade/index.shtml (accessed on 15 December 2020).
- Quinlan, J.R. C4.5: Programs for Machine Learning; Morgan Kaufmann: San Mateo, CA, USA, 1993. [Google Scholar]
- Wu, X.; Kumar, V.; Quinlan, R.; Ghosh, J.; Yang, Q.; Motoda, H.; McLachlan, G.; Ng, A.; Liu, B.; Philip, Y.; et al. Top 10 algorithms in data mining. Knowl. Inf. Syst. 2008, 14, 1–37. [Google Scholar] [CrossRef] [Green Version]
- Breiman, L.; Friedman, J.H.; Olshen, R.A.; Stone, C.J. Classification and Regression Trees, 1st ed.; CRC Press: Boca Raton, FL, USA, 1984. [Google Scholar] [CrossRef]
- Morgan, J.N.; Sonquist, J.A. Problems in the analysis of survey data, and a proposal. J. Amer. Statist. Assoc. 1963, 58, 415–434. [Google Scholar] [CrossRef]
- Messenger, R.; Mandell, L. A modal search technique for predictive nominal scale multivariate analysis. J. Amer. Statist. Assoc. 1972, 67, 768–772. [Google Scholar] [CrossRef]
- Kucukkocaoglu, G.; Sezgin Alp, O. IPO mechanism selection by using Classification and Regression Trees. Qual. Quant. 2012, 46, 873–888. [Google Scholar] [CrossRef]
- Boonamnuay, S.; Kerdprasop, N.; Kerdprasop, K. Classification and Regression Tree with Resampling for Classifying Imbalanced Data. Int. J. Mach. Learn. Comput. 2018, 8, 336–340. [Google Scholar] [CrossRef]
- Lemon, S.C.; Roy, J.; Clark, M.A.; Friendmann, P.D.; Rakowski, W. Classification and regression tree analysis in public health: Methodological review and comparison with logistic regression. Ann. Behav. Med. 2003, 26, 172–181. [Google Scholar] [CrossRef] [PubMed]
- Trujillano, J.; Sarria-Santamera, A.; Esquerda, A.; Badia, M.; Palma, M.; March, J. Aproximación a la metodología basada en árboles de decisión (CART). Mortalidad hospitalaria del infarto agudo de miocardio. Gac. Sanit. 2008, 22, 65–72. [Google Scholar] [CrossRef] [Green Version]
- Kuhn, L.; Page, K.; Ward, J.; Worrall-Carter, L. The process and utility of classification and regression tree methodology in nursing research. J. Adv. Nurs. 2004, 70, 1276–1286. [Google Scholar] [CrossRef] [PubMed]
- Irimia-Dieguez, A.I.; Blanco-Oliver, A.; Vazques-Cueto, M.J. A comparison of classification/regression trees and logistic regression in failure models. Procedia Econ. Financ. 2015, 23, 9–14. [Google Scholar] [CrossRef] [Green Version]
- Zhao, Y.; Li, Y.; Zhang, L.; Wang, Q. Groundwater level prediction of landslide based on classification and regression tree. Geodesy Geodyn. 2016, 7, 348–355. [Google Scholar] [CrossRef] [Green Version]
- Choubin, B.; Rahmati, O.; Soleimani, F.; Alilou, H.; Moradi, E.; Alamdari, N. Regional Groundwater Potential Analysis Using Classification and Regression Trees. In Spatial Modeling in GIS and R for Earth and Environmental Sciences; Elsevier BV: Amsterdam, The Netherlands, 2019; pp. 485–498. [Google Scholar]
- Yohannes, Y.; Hoddinott, J. Classification and Regression Trees: An Introduction-Technical Guide; International Food Policy Research Institute (IIFPRI): Washington, DC, USA, 1999. [Google Scholar]
- Okwir, S.; Ulfvengren, P.; Angelis, J.; Ruiz, F.; Guerrero, Y.M.N. Managing turnaround performance through Collaborative Decision Making. J. Air Transp. Manag. 2017, 58, 183–196. [Google Scholar] [CrossRef]
- March, H.; Morote, Á.-F.; Rico, A.-M.; Saurí, D. Household Smart Water Metering in Spain: Insights from the Experience of Remote Meter Reading in Alicante. Sustainability 2017, 9, 582. [Google Scholar] [CrossRef] [Green Version]
- Boyle, T.; Giurco, D.; Mukheibir, P.; Liu, A.; Moy, C.; White, S.; Stewart, R. Intelligent Metering for Urban Water: A Review. Water 2013, 5, 1052–1081. [Google Scholar] [CrossRef] [Green Version]
- Gangale, F.; Mengolini, A.; Onyeji, I. Consumer engagement: An insight from smart grid projects in Europe. Energy Policy 2013, 60, 621–628. [Google Scholar] [CrossRef]
- Giurco, D.P.; White, S.B.; Stewart, R.A. Smart Metering and Water End-Use Data: Conservation Benefits and Privacy Risks. Water 2010, 2, 461–467. [Google Scholar] [CrossRef] [Green Version]
- Krishnamurti, T.; Schwartz, D.; Davis, A.; Fischhoff, B.; De Bruin, W.B.; Lave, L.B.; Wang, J. Preparing for smart grid technologies: A behavioral decision research approach to understanding consumer expectations about smart meters. Energy Policy 2012, 41, 790–797. [Google Scholar] [CrossRef]
- Sønderlund, A.; Smith, J.; Hutton, C.; Kapelan, Z. Using Smart Meters for Household Water Consumption Feedback: Knowns and Unknowns. Procedia Eng. 2014, 89, 990–997. [Google Scholar] [CrossRef] [Green Version]
- Willis, R.M.; Stewart, R.A.; Panuwatwanich, K.; Jones, S.; Kyriakides, A. Alarming visual display monitors affecting shower end use water and energy conservation in Australian residential households. Resour. Conserv. Recycl. 2010, 54, 1117–1127. [Google Scholar] [CrossRef] [Green Version]
- Anda, M.; Temmen, J. Smart metering for residential energy efficiency: The use of community based social marketing for behavioural change and smart grid introduction. Renew. Energy 2014, 67, 119–127. [Google Scholar] [CrossRef]
- Jorgensen, B.; Graymore, M.; O’Toole, K. Household water use behavior: An integrated model. J. Environ. Manag. 2009, 91, 227–236. [Google Scholar] [CrossRef]
- Kumar, A.; Lodha, D.; Mahalingam, A.; Prasad, V.; Sahasranaman, A. Using’ Design Thinking’ to enhance urban re-development: A case study from India. Eng. Proj. Organ. J. 2016, 6, 155–165. [Google Scholar] [CrossRef]
- IDEO. Human-Centered Design Toolkit. 2015. Available online: https://www.ideo.com/post/design-kit/ (accessed on 15 December 2020).
- Mailchimp. Available online: https://mailchimp.com/?gclid=35d8aa53495b13fc99fbf5815a67e5fe&gclsrc=3p.ds&ds_rl=1276838&msclkid=35d8aa53495b13fc99fbf5815a67e5fe (accessed on 15 December 2020).
- Google Analytics. Available online: https://analytics.google.com (accessed on 15 December 2020).
Independent Variable | Normalized Importance |
---|---|
Efficient use in cleaning | 100.0% |
Quality of infrastructure | 15.6% |
CRM | 13.1% |
Reclaimed water for washing machine, toilet, garden, and no case | 11.5% |
Quality of service/health | 10.3% |
Independent Variable | Normalized Importance |
---|---|
Efficient use in cleaning | 100.0% |
Knowledge Global Score | 33.7% |
Quality of infrastructure | 15.6% |
CRM | 13.1% |
Reclaimed water for washing machine, toilet, garden, and no case | 11.5% |
Quality of service/health | 10.3% |
Independent Variable | Normalized Importance |
---|---|
Efficient use in cleaning | 100.0% |
Knowledge Global Score | 33.7% |
Education | 26.6% |
Quality of infrastructure | 15.6% |
CRM | 13.1% |
Reclaimed water for washing machine, toilet, garden, and no case | 11.5% |
Quality of service/health | 10.3% |
Publisher’s Note: MDPI stays neutral with regard to jurisdictional claims in published maps and institutional affiliations. |
© 2021 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 (http://creativecommons.org/licenses/by/4.0/).
Share and Cite
Bermejo-Martín, G.; Rodríguez-Monroy, C.; Núñez-Guerrero, Y.M. Water Consumption Range Prediction in Huelva’s Households Using Classification and Regression Trees. Water 2021, 13, 506. https://doi.org/10.3390/w13040506
Bermejo-Martín G, Rodríguez-Monroy C, Núñez-Guerrero YM. Water Consumption Range Prediction in Huelva’s Households Using Classification and Regression Trees. Water. 2021; 13(4):506. https://doi.org/10.3390/w13040506
Chicago/Turabian StyleBermejo-Martín, Gustavo, Carlos Rodríguez-Monroy, and Yilsy M. Núñez-Guerrero. 2021. "Water Consumption Range Prediction in Huelva’s Households Using Classification and Regression Trees" Water 13, no. 4: 506. https://doi.org/10.3390/w13040506
APA StyleBermejo-Martín, G., Rodríguez-Monroy, C., & Núñez-Guerrero, Y. M. (2021). Water Consumption Range Prediction in Huelva’s Households Using Classification and Regression Trees. Water, 13(4), 506. https://doi.org/10.3390/w13040506