Development of a multicriteria model for crises in urban water supply and its application to the case of Brasilia, Brazil.
Decision support system
Decision-making
Integrated urban water management
Water scarcity
Journal
Integrated environmental assessment and management
ISSN: 1551-3793
Titre abrégé: Integr Environ Assess Manag
Pays: United States
ID NLM: 101234521
Informations de publication
Date de publication:
Jan 2023
Jan 2023
Historique:
revised:
12
08
2022
received:
24
08
2021
accepted:
15
08
2022
pubmed:
20
8
2022
medline:
24
12
2022
entrez:
19
8
2022
Statut:
ppublish
Résumé
The expansion of urban water supply crisis (UWC) cases, a context characterized by an inadequate ratio between water consumption and supply capacity, has motivated researchers to search for tools to solve the problem. The objective of this study is to develop a multicriteria tool to help select the solution alternative for UWC cases. The tool (called UWC-MCDA) is based on obtaining consensus on various multicriteria methods for selecting alternatives to solve UWC cases. The proposed methodology consists of the following steps: (1) defining the criteria, (2) defining weights, (3) defining the alternative, (4) defining multicriterial decision support methods, (5) coding the UWC solution alternative selection model, (6) evaluation of the model coding, (7) application of the model coding, and (8) sensitivity analysis. The methods PROMETHEE II, TOPSIS, ELECTRE III, and Consensus ranking are used. The case study considered was the Administrative Region of Brasilia, in the Federal District of Brazil. A multicriteria tool to help select the solution alternative for UWC cases was developed in an easy-to-use environment (Visual Basic for Applications, MS Excel). The UWC-MCDA is able to identify and prioritize, among a set of possible alternatives, the most appropriate solution for the case in question. For the case study, the UWC-MCDA indicated the best alternatives for regulating water consumption, strengthening sanitation service operators and good water conservation practices. Integr Environ Assess Manag 2023;19:99-113. © 2022 SETAC.
Types de publication
Journal Article
Langues
eng
Sous-ensembles de citation
IM
Pagination
99-113Subventions
Organisme : Conselho Nacional de Desenvolvimento Científico e Tecnológico
ID : Project Nº 556084/2009-8
Informations de copyright
© 2022 SETAC.
Références
Abrishamchi, A., Ebrahimian, A., Tajrishi, M., & Mariño, M. A. (2005). Case study: Application of multicriteria decision making to urban supply. Journal of Water Resource Planning and Management, 131(4), 326-335. https://doi.org/10.1061/(ASCE)0733-9496(2005)131:4(326)
Agência Reguladora de Águas, Energia e Saneamento Básico do Distrito Federal (ADASA). (2016). Nota Técnica n° 61/2016-SRH/ADASA. Retrieved September 16, 2020, from: http://www.adasa.df.gov.br/images/stories/anexos/3Consumidor/2AudienciasPublicas/2016/AP005-2016/NTn612016_simulacaoSantaMariaSISGED5199.pdf
Albuquerque, T. M. A. (2004). Multicriteria selection of alternatives for managing water demand at the neighborhood scale [MSc Thesis, Federal University of Campina Grande (UFCG)].
Alegre, H., Hirner, W., Baptista, J. M., & Parena, R. (2000). Performance indicators for water supply services (p. 160). IWA Publishing.
Athanasiadis, I. N., Mentes, A. K., Mitkas, P. A., & Mylopoulos, Y. A. (2005). A hybrid agent-based model for estimating residential water demand. Journal Simulation, 83(3), 175-187. https://doi.org/10.1177/0037549705053172
Ayala, N. F., & Frank, A. G. (2013). Multi-criteria analysis methods: A review of strengths and weaknesses. XIII SEPROSUL. Retrieved January 4, 2022, from: https://www.lume.ufrgs.br/bitstream/handle/10183/196504/000903880.pdf?sequence=1
Beinat, E. (1997). Value functions for environmental management. Kluwer Academeic Publishers.
Brans, J. P., & Mareschal, B. (2005). Promethee methods. In J. Figueira, S. Greco, & M. Ehrogott (Eds.), Multiple criteria decision analysis: State of the art surveys (Vol. 78, pp. 164-195). Springer. https://doi.org/10.1007/0-387-23081-5_5
Brans, J. P., & Vincke, P. (1985). A preference ranking organization method: The PROMETHEE method for MCDM. Management Science, 31(6), 612-620. https://doi.org/10.1287/mnsc.31.6.647
Brasil. Ministério da Economia. Secretaria Especial de Produtividade e Competitividade. Secretaria de Desenvolvimento da Infraestrutura. (2021). General guide for socio-economic cost-benefit analysis of infrastructure investment projects. Retrieved January 5, 2022, from: https://www.gov.br/economia/pt-br/centrais-de-conteudo/publicacoes/guias-e-manuais/guia_acb.pdf/view
Brasil. Ministério das Cidades. Secretaria Nacional de Saneamento Ambiental. Sistema Nacional de Informações sobre Saneamento (SNIS). (2010). Service Diagnostics Water And Sewage-2010. Retrieved January 5, 2022, from: http://snis.gov.br/diagnostico-anual-agua-e-esgotos/diagnostico-ae-2010
Brasil. Ministério do Planejamento, Orçamento e Gestão. Instituto Brasileiro de Geografia e Estatística (IBGE). (2012). Sustainable Development Indicators. Retrieved January 5, 2022, from: https://biblioteca.ibge.gov.br/visualizacao/livros/liv59908.pdf
Brasil. Tribunal de Contas da União (TCU). (2009). Construction public: Basic recommendations for the contracting and inspection of works of public buildings. Retrieved January 5, 2022, from: https://portal.tcu.gov.br/data/files/1E/26/8A/06/23DEF610F5680BF6F18818A8/Obras_publicas_recomendacoes_basicas_contratacao_fiscalizacao_obras_edificacoes_publicas_4_edicao.PDF
Buchanan, J., Sheppard, P., & Vanderpooten, D. (1999). Project ranking using ELECTRE III. Retrieved June 7, 2018, from: http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.493.6585%26rep=rep1%26type=pdf
California Urban Water Agency (CUWA). (1992). BMP Performance Evaluation-Executive Summary. Retrieved February 18, 2018, from: http://www.cuwa.org/library/BMP_PerformanceEvaluation.pdf
Capodeferro, M. W., Smiderle, J. J., Oliveira, L. A. D., & Diniz, D. T. L. (2018). Mechanisms adopted by the Federal District to combat the water crisis. In: XXXVI Congreso Interamericano de Ingeniería Sanitaria y Ambiental. https://aidisnet.org/wp-content/uploads/2020/02/AIDIS-2018_Memorias-Trabajos-T%C3%A9cnicos-Orales__.pdf
Cinelli, M., Coles, S. R., & Kirwan, K. (2014). Analysis of the potentials of multi criteria decision analysis methods to conduct sustainability assessment. Ecological Indicators, 46, 138-148. https://doi.org/10.1016/j.ecolind.2014.06.011
Cinto, A. F., & Goes, W. M. (2008). Excel avançado [Advanced Excel]. Editora Navatec.
Companhia de Planejamento do Distrito Federal (CODEPLAN). (2018). Text for discussion: The crisis and water consumption in Brasilia. Retrieved August 4, 2020, from: http://www.codeplan.df.gov.br/wp-content/uploads/2018/02/TD-39-A-crise-e-o-consumo-de-%C3%A1gua-em-Bras%C3%ADlia.pdf
Companhia de Saneamento Ambiental do Distrito Federal (CAESB). (2017). Drought in DF: Water rotation. Retrieved June 5, 2018, from: https://www.caesb.df.gov.br/seca-rodizio
Cook, W. D., Kress, M., & Seiford, L. M. (1996). A general framework for distance-based consensus in ordinal ranking models. European Journal of Operational Research, 96(2), 392-397. https://doi.org/10.1016/0377-2217(95)00322-3
Cook, W. D., & Seiford, L. M. (1978). Priority ranking and consensus formation. Management Science, 24(16), 1721-1732. https://doi.org/10.1287/mnsc.24.16.1721
Department for Communities and Local Government (DCLG). (2009). Multi-criteria analysis: A manual. Retrieved January 24, 2018, from: http://eprints.lse.ac.uk/12761/1/Multi-criteria_Analysis.pdf
Duckstein, L., & Opricovic, S. (1980). Multiobjective optimization in river basin development. Water Resources Research, 16(1), 14-20. https://doi.org/10.1029/WR016i001p00014
Duckstein, L., Treichel, W., & Magnouni, S. E. (1994). Ranking ground-water management alternatives by multicriterion analysis. Journal of Water Resources Planning and Management, 120(4), 546-572. https://doi.org/10.1061/(ASCE)0733-9496(1994)120:4(546)
Dymova, L., Sevastjanov, P., & Tikhonenko, A. (2013). A direct interval extension of TOPSIS method. Expert Systems with Applications, 40, 4841-4847. https://doi.org/10.1016/j.eswa.2013.02.022
Esmail, B. A., & Genelett, D. (2018). Multi-criteria decision analysis for nature conservation: A review of 20 years of applications. Methods in Ecology and Evolution, 9, 42-53. https://doi.org/10.1111/2041-210X.12899
Froukh, M. L. (2001). Decision-support system for domestic water demand forecasting and management. Water Resources Management, 15, 367-382. https://doi.org/10.1023/A:1015527117823
Fullerton, T. M., Jr. Tinajero, R., & Cota, J. E. M. (2007). An empirical analysis of Tijuana consumption. Atlantic Economic, 35, 357-359. https://doi.org/10.1007/s11293-007-9074-x
Glass, N. (2010). The Water Crisis in Yemen: Causes. Consequences and Solutions. Global Majority, 1(1), 17-30.
Gleik, P. H. (1998). Water in crisis: Paths to sustainable water use. Ecological Applications, 8(3), 571-579. https://doi.org/10.1890/1051-0761(1998)008[0571:WICPTS]2.0.CO;2
Goicoechea, A., Hansen, D. R., & Duckstein, L. (1982). Multiobjective decision analysis with engineering and business applications (p. 519). John Wiley & Sons.
Governo do Distrito Federal (GDF). (2015). Federal District: Synthesis of socioeconomic and geographical information. Retrieved June 5, 2018, from: http://www.codeplan.df.gov.br/wp-content/uploads/2018/02/S%C3%ADntese-de-Informa%C3%A7%C3%B5es-Socioecon%C3%B4micas-e-Geogr%C3%A1ficas-2014.pdf
Governo do Distrito Federal (GDF). (2018). Integrated plan to deal with the water crisis. Retrieved August 4, 2020, from: http://www.ibram.df.gov.br/wp-content/uploads/2018/03/Plano-27%C2%AA-ciea.pdf
Hobbs, B. F., Chankong, V., Hamadeh, W., & Stakhiv, E. Z. (1992). Does choice of multicriteria method matter? An experiment in water resources planning. Water Resources Research, 28(7), 1767-1779. https://doi.org/10.1029/92WR00712
Hokkanen, J., & Salminen, P. (1997). ELECTRE III and IV decision aids in an environmental problem. Journal of Multi-Criteria Decision Analysis, 6, 215-226. https://doi.org/10.1002/(SICI)1099-1360(199707)6:4%3C215::AID-MCDA139%3E3.0.CO;2-P
Jato-Espino, D., Castillo-Lopez, E., Rodriguez-Hernandez, J., & Canteras-Jordana, J. C. (2014). A review of application of multi-criteria decision making methods in construction. Automation in Construction, 45, 151-162. https://doi.org/10.1016/j.autcon.2014.05.013
Jelen, B., & Syrstad, T. (2009). VBA and macros for Microsoft Office Excel 2007. Pearson Prentice Hall.
Kabir, G., Sadiq, R., & Tesfamariam, S. (2014). A review of multi-criteria decision-making methods for infrastructure management. Structure and Infrastructure Engineering, 10(9), 1176-1210. https://doi.org/10.1080/15732479.2013.795978
Kiker, G. A., Bridges, T. S., Varghese, A., Seager, T. P., & Linkov, I. (2005). Application of multicriteria decision analysis in environmental decision making. Integrated Environmental Assessment and Management, 1(2), 95-108. https://doi.org/10.1897/IEAM_2004a-015.1
Kostuch, M. (2010). Consensus Decision-Making Toolkit. Retrieved January 4, 2022, from: https://www.casahome.org/uploads/source/PDF/CDM-toolkit-web.pdf
Kruger, H. A., & Kearney, W. D. (2008). Consensus ranking-An ICT security awareness case study. Computers & Security, 27(7-8), 254-259. https://doi.org/10.1016/j.cose.2008.07.001
Lai, Y. J., Liu, T. Y., & Hwang, C. L. (1994). TOPSIS for MODM. European Journal of Operational Research, 76(3), 486-500. https://doi.org/10.1016/0377-2217(94)90282-8
Lima, J. E. F. W., Freitas, G. K., Pinto, M. A. T., & Salles, P. S. B. A. (2018). Water Crisis Management 2016-2018: Experiences of the Federal District, Adasa, Caesb, Seagri, Emater, Brasilia. Retrieved June 9, 2022, from: https://www.adasa.df.gov.br/images/banners/alta.pdf
Loucks, D. P., & Beek, E. V. (2017). Water resource systems planning and management: An introduction to methods, models, and applications (p. 624). Deltares/UNESCO-IHE/Springer. https://doi.org/10.1007/978-3-319-44234-1
Ma, J., Harstvedt, J. D., Jaradat, R., & Smith, B. (2020). Sustainability driven multi-criteria project portfolio selection under uncertain decision-making environment. Computers & Industrial Engineering, 140, 106236. https://doi.org/10.1016/j.cie.2019.106236
Makropoulos, C. K., Natsis, K., Liu, S., Mittas, K., & Butler, D. (2008). Decision support for sustainable option selection in integrated urban water management. Environmental Modelling & Software, 23, 1448-1460. https://doi.org/10.1016/j.envsoft.2008.04.010
Martin, D. M., & Mazzotta, M. (2018). Non-monetary valuation using Multi-Criteria Decision Analysis: Sensitivity of additive aggregation methods to scaling and compensation assumptions. Ecosystem Services, 29, 13-22. https://doi.org/10.1016/j.ecoser.2017.10.022
Marttunen, M., Lienert, J., & Belton, V. (2017). Structuring problems for multi-criteria decision analysis in practice: A literature review of method combinations. European Journal of Operational Research, 263(1), 1-17. https://doi.org/10.1016/j.ejor.2017.04.041
Millington, N. (2018). Producing water scarcity in São Paulo, Brazil: The 2014-2015 water crisis and the binding politics of infrastructure. Political Geography, 65, 26-34, https://doi.org/10.1016/j.polgeo.2018.04.007
Miser, H. J. (1993). A foundation concept of science appropriate for validation in operation research. European Journal of Operational Research, 66(2), 204-215. https://doi.org/10.1016/0377-2217(93)90313-C
Mitchell, B. (2005). Integrated water resource management, institutional arrangements, and land-use planning. Environment and Planning A: Economy and Space, 37, 1335-1352. https://doi.org/10.1068/a37224
Mitchell, D. L., Cubed, M., Illingworth, W., & Foster Associates Inc. (1997). BMP performance evaluation, executive summary: Draft final. Retrieved October 10, 2020, from: https://static1.squarespace.com/static/5a565e93b07869c78112e2e5/t/5a99e97e652deabe1bb8f579/1520036434427/BMP_PerformanceEvaluation.pdf
Morais, D. C., & Almeida, A. T. (2006). Group decision model to manage water losses. Pesquisa Operacional, 26(3), 567-584. https://doi.org/10.1590/S0101-74382006000300007
Morckel, V. (2017). Why the Flint, Michigan, USA water crisis is an urban planning failure. Cities, 62, 23-27. https://doi.org/10.1016/j.cities.2016.12.002
Mullin, M., & Rubado, M. E. (2017). Local response to water crisis: Explaining variation in usage restrictions during a Texas drought. Urban Affairs Review, 54(4), 752-774. https://doi.org/10.1177/1078087416657199
Oertlé, E., Mueller, S. R., Choukr-Allah, R., & Jaouani, A. (2020). Decision support tool for water reclamation beyond technical considerations-Egyptian, Moroccan, and Tunisian case studies. Integrated Environmental Assessment and Management, 16(6), 885-897. https://doi.org/10.1002/ieam.4303
Olson, D. L. (2004). Comparison of weights in TOPSIS Models. Mathematical and Computer Modelling, 40, 721-727. https://doi.org/10.1016/j.mcm.2004.10.003
Patlitzianas, K. D., Pappa, A., & Psarras, J. (2008). An information decision support system towards the formulation of a modern energy companies' environment. Renewable and Sustainable Energy Reviews, 12, 790-806. https://doi.org/10.1016/j.rser.2006.10.014
Pinto, A. L. C., & Araujo Neto, M. D. (2009). Preliminary study of public supply to subsidize water resource use in the Federal District. XVIII Simpósio Brasileiro de Recursos Hídricos.
Poh, K. L. (1998). A knowledge-based guidance system for multi-attribute decision making. Artificial Intelligence in Engineering, 12, 315-326. https://doi.org/10.1016/S0954-1810(97)10001-2
Ramos, A. M., Santos, L. A. R., & Fortes, L. T. G. (2009). Climatological norms of Brazil 1961-1990. INMET.
Roy, B. (1991). The outranking approach and the foundations of ELECTRE methods. Theory and Decision, 31, 49-73. https://doi.org/10.1007/BF00134132
Schutt, R. (2001). Notes on consensus decision-making. Retrieved January 3, 2022, from: http://www.vernalproject.org/papers/process/ConsensNotes.pdf
Seeds for Change (SFC). (2010). Consensus decision making: A guide to collaborative decision-making for activist groups, co-ops and communities. Retrieved May 28, 2022, from: https://www.seedsforchange.org.uk/consensus.pdf
Silva, W. T. P. (2012). Model for prioritizing guidelines to combat urban water supply crises [DSc. Thesis, University of Brasilia (UnB)].
Silva, W. T. P., & Souza, M. A. A. (2017). A decision support model to aid the management of crises in urban water supply systems (the UWC-MODEL). Urban Water Journal, 14(6), 647-656. https://doi.org/10.1080/1573062X.2016.1223861
Silva, W. T. P., & Souza, M. A. A. (2018). Expert system for selecting and prioritizing projects for handling urban water supply crises. Urban Water Journal, 15(6), 561-567. https://doi.org/10.1080/1573062X.2018.1529806
Tillman, D. E., Larsen, T. A., Pahl-Wostl, C., & Gujer, W. (2005). Simulating development strategies for water supply. Journal Hydroinformatics, 7(1), 41-51. https://doi.org/10.2166/hydro.2005.0005
Tomić, V., Marinković, C., & Janošević, D. (2011). PROMETHEE method implementation with multi-criteria decisions. FACTA UNIVERSITATIS, Series: Mechanical Engineering, 9(2), 193-202.
Triantaphyllou, E. (2000). Multi-criteria decision making methods: A comparative study (p. 288). Kluwer Academic Publishers.
Velasquez, M., & Hester, P. T. (2013). An analysis of multi-criteria decision making methods. International Journal of Operations Research, 10(2), 56-66.
Walkenbach, J. (2007). Excel® 2007 Bible (p. 866). Wiley Publishing Inc.
Zarghami, M., Abrishamchi, A., & Ardakanian, R. (2008). Multi-criteria decision making for integrated urban water management. Water Resource Management, 22, 1017-1029. https://doi.org/10.1007/s11269-007-9207-7
Zavadskas, E. K., Mardani, A., Turskis, Z., Jusoh, A., & Nor, K. M. D. (2016). Development of TOPSIS method to solve complicated decision-making problems: An overview on developments from 2000 to 2015. International Journal of Information Technology & Decision Making, 15(3), 645-682. https://doi.org/10.1142/S0219622016300019
Zhaoxu, S., & Min, H. (2010). Multi-criteria decision making based on PROMETHEE method. In Proc. International Conference on Computing, Control and Industrial Engineering, Wuhan, Los Alamitos (pp. 416-418). IEEE. https://doi.org/10.1109/CCIE.2010.110
Zlaugotne, B., Zihare, L., Balode, B., Kalnbalkite, A., Khabdullin, A., & Blumberga, D. (2020). Multi-criteria decision analysis methods comparison. Environmental and Climate Technologies, 24(1), 454-471. https://doi.org/10.2478/rtuect-2020-0028