Data for: A participatory multi-criteria decision analysis framework reveals transition potential towards non‐grid wastewater management

Many public environmental decisions are wicked problems due to high complexity and uncertainty. We test a participatory value-based framework based on multi-criteria decision analysis (MCDA) to tackle such problems. Our framework addresses two important gaps identified in reviews of MCDA applications to environmental problems: including stakeholders and treating uncertainty. We applied our framework in two complex real-world cases concerning a paradigm shift in the wastewater sector; the transition from centralized wastewater systems to decentralized non-grid systems. Non-grid systems may solve some problems of centralized systems by reducing costs, increasing flexibility, and addressing growing demands on environmental issues, especially in rural areas. But non-grid systems have rarely been implemented in OECD countries, because it is unclear whether a transition is recommendable, and whether stakeholders would accept this shift. This problem allows addressing several fundamental research questions. As theoretical contribution, we found that stakeholder participation in MCDA is necessary, because different preferences of stakeholders can lead to different best-performing options in the assessments. Compared to the typical integrated assessment (IA) approach that excludes stakeholders' preferences, the MCDA process led to clearer outcomes. Results indicate that including the uncertainty of predicted consequences of options with Monte Carlo simulation helped discriminate between options and identify best-performing options. Challenging the uncertainty of elicited stakeholder preferences with sensitivity analyses, we found that best-performing options were especially sensitive to the MCDA aggregation model. Despite the high uncertainty, it was possible to suggest robust consensus options that would perform reasonably well for all stakeholders. As practical contribution, results indicated that a transition from the centralized to decentralized non-grid systems seems feasible. Most stakeholders assigned highest weights to environmental protection objectives in decision-making workshops. These stakeholder preferences implemented in MCDA led to a generally better assessment of innovative non-grid systems, especially when including urine source separation. Stakeholders perceived the MCDA process as beneficial and found results plausible. We conclude that the proposed participatory value-based framework is rigorous, but still feasible in practice. The framework is certainly transferable to any context and is open to testing and refinement in various applications to wicked decision problems.