Co-Creating GIS-Based Dashboards to Democratize Knowledge on Urban Resilience Strategies: Experience with Camerino Municipality

Abstract

Natural hazards are increasingly threatening our communities; hence it is imperative to provide communities with reliable information on possible impacts of such disasters, and on resilience measures that can be adopted to recover from disasters. To increase the engagement of various stakeholders in decision-making processes related to resilience to natural hazards, problem-specific information needs to be presented to them in a language understandable to non-experts in the field. To this end, this paper illustrates experimentation with low-code platforms for fast digitalization of resilience reports, incorporating the perspectives of various stakeholders in the analysis, thus making informed decision-making practicable. We present a co-creation-based approach to develop GIS-based user-friendly dashboards in support to the identification of resilience strategies against natural hazards; this approach has been developed within the framework of the European project ARCH. Urban areas are regarded as complex social-ecological systems whose various dimensions should be considered in this resilience endeavor, during all phases of the Disaster Risk Reduction and Climate Change Adaptation cycle. The work presented in this paper specifically targets the possible impacts and risks that might affect the cultural heritage subsystems of our cities, generally underrepresented in the international literature related to urban resilience assessment. We describe how we applied our approach to the Camerino municipality, a historic Italian town exposed to seismic risk, which was struck by a severe earthquake sequence in 2016–2017 and discuss the results of our experience.

1. Introduction

Natural hazards are increasingly threatening our communities; hence, measures to strengthen our communities’ resilience need to be assigned the highest priority for policy- makers. The first step is to provide communities with reliable information on the possible impacts, and on the resilience measures that can be adopted to prevent natural hazards from turning into disasters.

Among the various aspects of a city, historic areas, although extremely vulnerable to natural hazards, are often neglected in urban resilience assessment plans, as assessment of the vulnerabilities of these areas’ peculiar assets require tailored methods and expertise. The resilience concept itself needs to be specifically shaped for protection of cultural heritages by encompassing in preparations the social and ecological characteristics of these historic areas, with the objective of maintaining the historic district’s identity, integrity, and authenticity [1].

The European-funded research project ARCH (Advancing Resilience of historic areas against Climate-related and other Hazards) [2], has been among the most relevant initiatives devoted to the development of methods and tools focused on the resilience enhancement of historic and cultural heritage areas. Among the tools defined and made available by the ARCH project via the ARCH HUB (ARCH HUB is accessible at https://websites.fraunhofer.de/arch/, accessed on 5 December 2022), the ARCH DSS (Decision Support System) aims at providing risk knowledge representations in the form of hazard scenarios and their impacts, exploiting the different vulnerabilities of historic areas. These were elicited for four pilot cities, namely: Hamburg (Germany), Bratislava (Slovakia), Valencia (Spain), and Camerino (Italy). Furthermore, within the ARCH DSS, the effects of selected resilience measures in relation to reduction of impacts for various hazard scenarios have been evaluated and compared. The final objective of the ARCH DSS has been to support informed decision-making processes for resilience building leveraging quantitative riskanalysis methods. The application of these methods required the setup of extensive information systems, such as the Historic Area Information Management System (HArIS) and the Threats and Hazard Information Management System (THIS) (ARCH HArIS and THIS are accessible from ARCH Geoportal—https://www.cs.ingv.it/ARCHPortal/, accessed on 5 December 2022), to collect, organize, aggregate and make available assets and threats data.

In this paper, we illustrate the development method of the ARCH DSS, a tool-set consisting of knowledge reports about selected impact scenarios and effectiveness of resilience measures for various cities. These reports have been built on the processing of data and information made available by HArIS and THIS. The application of the method is described for the Camerino municipality, a historic Italian town exposed to seismic risks that was struck by a severe earthquake sequence in 2016–2017. Aiming to increase the engagement of various stakeholders in the decision-making processes related to resilience to natural hazards, it is necessary to present them with synthetic and problem-specific information using superior language. For this aim, within ARCH we promoted the usage of low-code platforms for the fast digitalization of resilience reports, incorporating the perspectives of various stakeholders in the analysis, thus making informed decision-making processes practicable.

GIS-based tools are commonly used as base applications to support decision making processes for disaster mitigation and management (see, for example, [3,4,5,6]). Several GIS environments require specialized skills in both IT development and data analysis; these skills are used to implement information systems for performing in-depth studies. Moreover, these GIS environments enable the realization of interactive web pages and customized dashboards in the form of a WebGIS for public access from the Internet to make study results available to various users. However, such tools are not immediately adequate for the collaborative development of decision support services with end users.

On the other hand, the growing availability of easy-to-use cloud-based environments [7,8,9] has led to the concept of self-service business intelligence providing end users, for example, with the ability to customize the dashboards by themselves with ready-to-use code. As this technology can be fed by various data sources, including GIS datasets, it can also be explored to build custom geospatial data visualization user interfaces, effective for specific government policies, such as resilience planning and disaster response.

This paper contains the following key contributions. First, a replicable agile methodology to develop fit-to-use GIS-based DSS tools to support the identification of urban resilience strategies against natural hazards is detailed. The main feature of the methodology is a co-creation method to implement iterations of the DSS development process where representatives of local communities collaborate with expert analysts to turn resilience knowledge into DSS tools and to drive development toward usage-based tool validation. To this purpose, the adoption of a low code technological environment to visualize the analysis results allows adaptation directly from the end users.

The second contribution is the implementation of a conceptual model for the representation of impact scenarios and of resilience strategies and results, which can be adapted to the context of various cities and to different decision objectives.

In particular, the ARCH DSS dashboards have been conceived to be, to the greatest extent possible, in line with the principles, terminology, and metrics addressed by the Agenda 2030 for Sustainable Development [10] that recommends strengthening efforts to protect and safeguard the world’s cultural and natural heritage. Furthermore, the Sendai Framework for Disaster Risk Reduction 2015–2030 [11], which states the imperative need to incorporate cultural heritage into disaster resilience, has been considered a reference.

The third contribution is the application of the methodology and experimentation of the DSS on a real case study, i.e., the Camerino municipality. The result of our experience is discussed, including the positive feedback received from the relevant stakeholders and their indications for practical uses of the ARCH DSS as part of municipality practices and for future improvement of the ARCH DSS tool.

2. Related Works

The present work refers to a methodological and technological approach for GIS-based support to democratize knowledge for decision making targeting resilience of historic areas to natural hazards.

2.1. GIS-Based Tools to Support Resilience to Natural Hazards

Various GIS-based platforms for informing and supporting decision-making processes for building resilience to climate changes and other hazards can be identified in the international literature, e.g., Global Earthquake Model, GEM [12]; HAZUS-MH platform used by the US Federal Emergency Management Agency, FEMA [13]; CAPRA Probabilistic Risk Assessment Platform [14], and others [15,16,17,18,19,20,21]. However, generally speaking, commercially available GIS-based platforms lack the spatial analysis. They also lack the capability required in the design phase of the decision-making process that concerns assessing and analysing impact scenarios and a set of alternative decisions for responding to them. The intelligence behind these platforms has long been non-transparent and/or not immediately available and clear for the stakeholders, as it has been reported in technical reports or scientific papers accessible and understandable by subject-matter-experts only.

As for the types of analysis, the platforms above are generic and do not specifically target historic areas and characterization of risk for these areas.

2.2. Risk Analysis for Protection of Historic Areas

As described in [22], the actual complexity of the risk concept for a historic city, in terms of variables and indicators, leaves open various research challenges in vulnerability assessment methods, from data availability and collection to coverage, accuracy and usefulness of the results. To face such a complexity, artificial intelligence methods, such as machine learning, are investigated for automatic risk classification trained on historical data. In a complementary direction, the work [23] proposes an automatic approach to risks of POIs of a city, where both the complexity of the activity and the problem of data unavailability are faced by combining a formal representation of the problem domain, following the Vulnerability Upper Model [24] development method, with computational creativity techniques to obtain risk descriptions and preliminary ranking. From the perspective of specific aims and tool results, both of the above works are aimed toward methods of enriching GIS-platforms directed at risk analysts, and, as such, they require modelling and development effort. From a research perspective, the techniques above could be adopted to support co-creation activities that, as for the ARCH project, lead to the realization of the DSS tools. Indeed, a step forward from previous works [5] has been the fundamental interpretation of historic areas as complex social-ecological systems, which can only be achieved by direct involvement of relevant stakeholders in the development process of the tools. In this respect, none of the existing GIS-based systems allows for agile programming and development, thus enabling accommodation of the timeline and the modality of the co-creation process that was at the core of the ARCH project.

2.3. Knowledge Democratization Methods

The concept of democracy in terms of knowledge on resilience has recently emerged in the research community thanks to the availability of open data and cloud-based tools that may host geo-data analytics and visualization services for knowledge sharing. The usefulness of public dashboards during a disaster to enable local communities to gain knowledge and explain event evolution for the purpose of emergency management is discussed, for example, in [25]. The usage of WebGIS technology to publish interfaces for a more effective understanding of in-depth environmental studies to support territorial planning is promoted in [3]. WebGIS technology allows internet access of GIS layers built in desktop projects; therefore, it requires some development work at the code level. In this paper, the use of a low code environment is promoted on top of GIS-tools to allow for easy adaptation of the dashboards to user needs.

The potential and effectiveness of self-service business intelligence (BI) methods is being intensely considered in research [26,27,28]. The benefit of these tools for knowledge democratization is being demonstrated in the area of resilience engineering in safety-critical systems [29]. In such areas, the concept of safety intelligence has been introduced referring to the aim to transform raw data and information from incident archives into meaningful information for safety management [30]. Unlike these works, this paper describes a co-creation-driven methodology for urban resilience knowledge building by using both raw data and user-provided information, and delivery of such knowledge by means of BI tools.

3. Co-Creation for the Design of a GIS-Based Decision Support System

The work presented in this paper is framed by the European project ARCH. The main results of the ARCH project are briefly presented in Section 3.1, to contextualize the development method and the architecture of the GIS-based ARCH Decision Support System (ARCH DSS) presented in Section 3.2.

3.1. Overview of the ARCH Project: Methods and Results

3.1.1. The Resilience Concept of a Social-Ecological System

Resilience is a complex concept that is not uniquely defined as an abstract term, but it assumes different and precise meanings in specific application domains, such as ergonomic and urban contexts, industry/infrastructure, and information technology systems. With respect to the historic areas, this concept is new, and the ARCH project has provided the following definition for it [1]:

“The sustained ability of a historic area as a social-ecological system (including its social, cultural, political, economic, natural, and environmental dimensions) to cope with hazardous events by responding and adapting in socially just ways that maintain the historic area’s functions and heritage significance (including identity, integrity, and authenticity).”

Therefore, not only the physical assets of cultural heritage and artworks are elements exposed and at risk but also their significance for the local community that contribute to maintaining the sense of belonging and evolving the place identity. Such intangible value is hard to be found in urban data repositories but needs to be acquired directly by community groups by using participative methods [31] tailored to the topics of heritage management, climate change adaptation/mitigation, disaster risk management, and sustainable urban development. On the other hand, GIS-based tools targeting the resilience building of historic areas, not only do they need to combine tangible and intangible indicators in the analysis methods, but they should be accessible and co-developed with non-expert users in order to make the tools useful and usable.

3.1.2. The ARCH DRM/CCA Framework: Focus on Decision Support

The central result of the ARCH project is the definition of the Disaster Risk Reduction and Climate Change Adaptation cycle (DRR/CCA), a methodological framework for resilience building in cities, with special focus on historic areas, which has been the reference for the development of all the ARCH tools. The framework, detailed in [2], provides information and recommendations on a process model to be followed by historic areas aiming to become more resilient to natural hazards. The ARCH DRR/CCA follows an evolutionary process model as the urban system itself evolves and adapts with time to both internal variations and changing environmental conditions. As illustrated in Figure 1, the framework consists of ten steps within the three temporal phases of a disaster, such as pre-, during, and post-disaster. In the pre-disaster phase, preparation activities are performed, following requirements and recommendations to assess vulnerabilities and risks; then resilience measures are identified, assessed, selected and implemented; finally, monitoring processes of the indicators used for the risk assessment are established. During the disaster phase, emergency response procedures are conducted, and, in the post-disaster phase, the needs are assessed, the situation is stabilized, and the recovery process starts.

Figure 1. Illustration of the ARCH DRR/CCA framework [2] with the activities addressed by the ARCH DSS tool.

Various ARCH tools have been provided to perform these activities, in particular, the ARCH DSS addresses the activities indicated in steps 2, 3, 4 and 6 of the pre-disaster phases.

3.1.3. The ARCH Tools and Links with the ARCH DSS

The ARCH HUB [2] assembles the following innovative online tools developed as part of the project, which are briefly described below.

ARCH RAD: Resilience Assessment Dashboard for a multi-stakeholder self-assessment, by means of a questionnaire, of the current level of resilience of a historic area.

ARCH Risk Scenario Toolbox: to support co-creation activities and workshops for identifying vulnerabilities, hazards and cause-effect relationships represented by means of graphical impact chain models. These models are the basis for the ARCH DSS design.

ARCH Geoportal: a system consisting of two GIS-based tools, named HArIS and THIS. The first allows exploration of data on historic areas, and the second relates to data on hazards acquired both in real time by monitoring systems and from historic events and projections. These databases are the data sources for the ARCH-DSS dashboards.

ARCH RMI: Resilience Measures Inventory of over 250 measures to address climate-related and other natural events such as earthquakes. Different resilience measures can be compared and selected to develop resilience scenarios as part of the ARCH DSS design.

ARCH DSS: consisting of a set of dashboards developed according to the specific needs of each single historic area, as described Section 3.2.

ARCH RPVT: Resilience Pathway Visualization Tool allowing visual construction of implementation pathways for selected resilience measures, i.e., which resilience measures must be implemented in which sequence to raise the resilience to a certain level until a certain time.

3.2. The ARCH DSS

This section describes the development process of the ARCH DSS, from the aim and user requirements to the selection and elaboration of risk/impact indicators, and their representation by means of objective-based dashboards.

3.2.1. Democratizing the Resilience Knowledge

The aim of the ARCH DSS is to contribute to the sharing of knowledge about resilience of historic areas. An innovative aspect of the ARCH project has been the enactment of a co-creation-based methodology where different types of stakeholders for each city have actively contributed to the identification of decision objectives of interest for the city and of the risk indicators to be considered in the design of the DSS. On the other hand, the aim of the ARCH DSS for a city has been to target a wide audience when delivering the resilience assessment results, to strengthen the decision processes and increase the resilience capacity of the addressed community.

As every city has its own social-ecological characteristics, as well as specific vulnerabilities to different hazards, conceiving a unique system capable of addressing all types of resilience strategies for different cities would be quite challenging or ineffective if the tools were made too general. As a result, the ARCH DSS has been conceived as a set of independent tools in the form of interactive user-friendly dashboards, each devoted to a pilot city and to support specific decision-making objectives of the city.

These tools are aimed toward democratization of the resilience knowledge in the city and its building process. Therefore, the technical solution for the ARCH DSS has been an environment for agile development and operation of dashboards. The main technical features are described in Table 1.

Table 1. Features of the ARCH DSS environment.

Feature	Description
Readiness	The ARCH DSS allows developing a dashboard in a short time and this should be ready to use with minimum training
Interpretation	The ARCH DSS dashboard allows to visualize data/information about risks/impacts in a way that is easy to interpret by a general public, e.g., without specific skills on risk analysis, so to increase risk awareness of the population and to engage citizens in the decision-making processes
Engagement	The ARCH DSS dashboard displays the data in a focused and compact way to capture the user attention on the relevant messages for the decision objective at hand and enable its prompt usage during a focus group
Adaptation	The ARCH DSS is adaptable to changes, such as late availability of user requirements, updates of data and/or of visualization objects without re-coding, so to be capable to fast react on additional needs and/or on feedbacks by the end users
Transferability	The ARCH DSS is transferable to the end user environment and its maintenance handled leveraging on basic software development knowledge and of IT resources management
Replicability	The ARCH DSS allows easy replicability of a dashboard to other cities with similar characteristics and decision objectives

Figure 2 depicts the agile development process of ARCH DSS highlighting two aspects. The first is the central role of the co-creation activities with cross-functional stakeholders to enable effective collaboration in all (iterative) phases of the development: from the definition of the DSS objectives and of the data types, and the validation of the tools. This cycle has been realized for each pilot city. The second is the choice of a low code development environment to enable rapid prototyping of the tools as well as their adaptation to changes by the end users. Another advantage is to support self-service tool enhancement and maintenance for future deployment and operation in the end user environments.

Figure 2. ARCH DSS agile development model, encompassing co-creation activities, ARCH HArIS and THIS and the ARCH DSS hosted in a low-code environment for business intelligence.

The individual steps of the development method are detailed in the following subsections.

3.2.2. The Co-Creation Method

The ARCH co-creation activities have been targeting the following main goals.

-

Achieve a shared agreement on the definitions and approaches to be taken for performing risk and impact assessments;

-

Co-identify vulnerabilities, risk, and impact scenarios meaningful for the city’s specific decision-making processes that are relevant to the Disaster Risk Reduction/Climate Change Adaptation DRR/CCA cycle (Figure 1);

-

Co-create the scope and format of decision support tools and analysis of ARCH Decision Support System (DSS) dashboards for the visualization of the selected impact scenarios.

The co-creation process and supporting tools has been defined for:

-

Non-technical, non-expert stakeholders that must deal with the challenge to conduct co-creation activities related to risk and impact assessment within an historic area or within a wider urban area.

-

Expert in the field of risk and impact scenario assessment aiming to include co-creation in the process of conceiving and building a DSS of various kinds; the process of co-creation is deemed fundamental to avoid creating “black boxes” (non-transparent, non-replicable, not editable, etc.) and/or assessments and related tools not useful to inform any decision process and/or non-understandable by the stakeholders.

As a matter of fact, the lack or paucity of co-creation practices in the field of risk and impact scenario assessment has certainly contributed to the fact that tools created so far have not been taken up or have been adopted to a very limited extent by stakeholders and/or public administration. Figure 3 provides a schematic representation of the co-created impact and risk assessment process that was originally defined as part of the ARCH project.

Figure 3. Schematic representation of the co-created impact and risk assessment process that has been originally defined as part of the ARCH project.

As far as the first step of the co-creation process is concerned (Figure 3), i.e., “Achieve a shared understanding on risks and impacts and how to assess them”, reference is made to consolidated definitions and best-practices, which are presented avoiding scientific jargon and preferably using the country’s language [32]. As for the second step, i.e., “Co-identify risk and impact scenarios”, an ad-hoc supporting toolbox has been originally conceived and developed as part of the ARCH project [2], referred to as ARCH Risk Scenario Toolbox (Figure 2), made available through the ARCH HUB.

The ARCH Risk Scenario Toolbox is a set of tools and methods to support the co-identification, co-prioritization, and co-definition of risks, impacts, and the cause-effect relationships between them. The resulting toolbox consists of: (i) a risk profiling table; (ii) a scenario prioritization tool and; (iii) a Miro-Virual whiteboard (available at https://miro.com, accessed on 5 December 2022) template for the creation of Impact Chains [33]. These are (informal) conceptual models representing cause-effect chains linking factors and processes to describe climate risks in a specific context. The three elements of the toolbox build on each other. The risk profiling table should be filled in as a first step, then scenarios are prioritized using the prioritization tool, and finally, for the highest rated risk scenarios, Impact Chains are created. Finally, for the last step, devoted to validation by the stakeholders, the usability and usefulness of the co-created impact scenarios and of the ARCH DSS for their representation and use, ad hoc questionnaires have been created and distributed as reported in Appendix A.

Figure 3 summarizes each one of the aforementioned steps (that are reported in the blue boxes), a white box summarizes which elements have been introduced in the process, going beyond the regular (i.e., non-co-created) risk assessment process and including what “new” methodologies and tools (highlighted with the small arrows) have been introduced and implemented in the co-creative process.

3.2.3. Lift from Data and Information to Resilience Knowledge

The ARCH DSS outputs risks/impacts knowledge representations, achieved by organizing, conceptualizing and synthetizing contextual data and information, to enhance comprehension and awareness for informed decision-making on pre-specified objectives. Essentially, the ARCH DSS tool displays the risk/impact information as a combination of the relevant KPIs for its Hazard, Vulnerability and Exposure components, as a result of an analysis process. These KPIs were selected from those identified through the co-creation workshops and implemented by using the data of the city and the hazard scenarios provided by the ARCH Information System. With this meaning, the ARCH Information System and the ARCH DSS allow climbing of the Data Information Knowledge Wisdom (DIKW) pyramid [34] going from Data to Information and to Information to Knowledge, respectively. Data and information are collected, structured, and stored in the ARCH server repository and database to make them available in the information systems HArIS and THIS: depending on whether they concern elements for the characterization of HA aspects and their assets or of threats and hazards, respectively.

3.2.4. ARCH DSS Implementation

At high level of abstraction, the outputs of the ARCH DSS dashboards have been identified and classified in line with the types of data analytics works, as follows.

-

Context description: Summary of data and evidence on hazards, exposed elements and their vulnerability as well as of the impact factors of interest.

-

Predictive results: Estimation of risk maps and impact scenarios by combining hazard, exposure, and vulnerabilities.

-

Decision support: Resilience measures evaluated through estimation of modified impact scenarios.

From a software engineering perspective, the implementation of the ARCH DSS consists of three main steps: (1) definition of a data model devoted to the storage of the source data for the outputs above; (2) elaboration of the risk indicators and generation of the risk/impacts scenarios; (3) design of the user interfaces for the presentation of the results.

The data model, common to all the ARCH DSS dashboards, extends the risk conceptual model with entities related to time, geographical location, city contextual data and scenarios. To guide for the implementation of the data model in the PowerBI technology [7], these entities have been grouped in categories such as:

-

who (hazard),

-

what (object exposed to risk such as cultural heritage, population, buildings)

-

where (geographical location),

-

when (time/interval),

-

how (vulnerability indicators and impact types, risk matrix, resilience measures).

Figure 4 represents the followed data model for the dataset implementation.

Figure 4. Data model represented as a UML class diagram. The yellow color highlights the risk/resilience variables and definitions that are used to evaluate the scenarios (how). The Scenario-Results entity is a container for the Hazard-Scenario values, Exposure/Vulnerability values and the computed Impacts (what). Location refers to the geographic place of the objects exposed at risk (where) and Time to the time periods of reference for the scenarios (when), * stands for multiplicity.

For the developed prototypes, we realized an Excel dataset template, and created a new instance of it, with the specific data of each city and of its resilience aspects, when implementing a new dashboard.

The elaboration of the risk indicators (step 2) and the design of the user interfaces (step 3) are city-specific activities. Here we provide a general overview of these steps, whereas a detailed description for the city of Camerino is contained in Section 4.

For a case study, vulnerability and exposure indicators have been identified and elaborated on using the data available from the HArIS and THIS tools. Then, the most relevant impact scenarios for the given decision objective have been selected for representation in the ARCH DSS dashboard. Rules for data import, filtering, aggregation, and charts realization have been implemented using the PowerBI language and functionality, so that data updates in the source Excel file, such as new vulnerability indicators or types of impacts, are reflected in the interfaces by a refresh and a few graphical operations without essential re-coding. Impact and vulnerability functions assign a severity level to the object of the city under analysis (e.g., a district, population of a district, a historic building). These functions leverage on numerical thresholds to map the indicator values to an ordinal scale. Hence, following commonly used methods in qualitative risk assessment, risk levels for an object are obtained from a risk matrix, a two-dimensional table that combines severity of hazard and the impact/exposure level. Impact and vulnerability functions as well as the risk matrices used in the DSS tools are detailed in Section 4 describing the Camerino case study.

For the user interfaces, interactive visual objects, such as maps and basic statistics charts, to display and browse the data in a single page, have been preferred for a user friendly and essential presentation of the data. Each tool provides risk/impact maps as a main visualization means and one or two summary pages for exploration of quantitative aspects and elaboration details. The content of each dashboard has been organized to respond to user queries relevant for a given decision objective. To the aim of tools replicability to different cities, we have identified types of decision objectives, and we have defined corresponding interface structures. Examples of such objectives are “increase risk awareness of the population” and “planning the reconstruction of an historic centre.”

4. ARCH DSS for Camerino Case Study

This section details the activities of the ARCH DSS agile development process in Figure 2 accomplished for the municipality of Camerino.

4.1. Co-Creation Process and Results

The ARCH DSS co-creation process has been conceived as a four-step workshop (W1-W4) approach (following [35]); each workshop aimed to address specific questions as outlined below:

W1. Setting the scope, context, criteria: What is the overall scope of impact scenario assessment? More in detail: Why are you interested to know about potential impacts in your historic areas in the current situation, i.e., assessment of ex-ante scenario? Would it be beneficial for you to understand the extent of possible benefits arising from implementing mitigation strategies, i.e., assessment of ex-post scenarios? Which phase of the DRR/CCA should target the assessment (Figure 1)? What is the targeted decision-making process that this assessment is aiming to inform? Who are the stakeholders, decision makers and managers interested in this assessment and in the targeted decision-making process?

W2. Co-creating ex-ante impact scenarios and meaningful metrics/KPIs for ex-ante scenario representation: Which specific information/data/KPIs stakeholders might be interested in and/or might be more meaningful for them?

W3. Selection of resilience Strategies/Solutions, Co-creating ex-post impact scenarios and meaningful metrics/KPIs for ex-post scenario representation: Which are the resilience strategies and/or solutions that might support one specific or multiple phases of the DRR/CCA process, and to what extent might they be beneficial in supporting resilience? Which specific information/data/KPIs might be more meaningful/effective for representing resilience increase?

W4. Co-creating and testing of ARCH DSS’s functionalities: Which functionalities might facilitate the uptake, usability and usefulness of the ARCH DSS?

The targeted aims of each one of the workshops (W1–W4) are further outlined in Table 2.

Table 2. Structure of the ARCH DSS co-creation process.

	Co-Creation Aim
W1	To co-create the context of the DRR/CCA assessment for each foundation city—which crisis scenarios should be prioritized according to the local situation?
W2	To present the content of the DSS input informative layers (i.e., hazard, exposure, vulnerability) to be included in the DSS and co-creating metrics/KPI indicators for their representation; To present the simplified approaches adopting to assess impacts as a function of hazard, exposure, vulnerability; To present the content of the DSS output informative layers (i.e., severity of the expected impacts) and establishing thresholds and metrics/KPIs for the representation of ex-ante impact scenario results.
W3	To discuss and identify the more appropriate resilience solutions/strategies for the local situation among the possible resilience strategies, from ARCH RMI compatible with the crisis scenarios identified in W1; To present, discuss for and establish thresholds and metrics/KPIs for the assessment and representation of ex-post impact scenario (i.e., the possible evolution of impacts when specific resilience strategies are deployed and implemented).
W4	To showcase the use and development potentials of the DSS to the City Representatives, City Stakeholders, and Keystone City representatives and to collect their feedbacks on the usability and user-friendliness of the ARCH DSS for its final implementation and further improvements.

Table 3 below summarizes the key results that were achieved during each one of the ARCH DSS co-creation workshops W1-W4 in Camerino. These results are then further detailed in the following section, i.e., Section 4.2. Digital interactive boards were used to ease the collaborative work, as shown in Figure 5.

Table 3. Summary of key results after the ARCH DSS co-creation workshops W1-W4 in Camerino.

	Summary of Key Results of ARCH DSS Co-Creation Workshops in Camerino
W1	DRR/CCA phase: Emergency response and recover and building back better Stakeholders: Urban Planning, Civil Protection Office; Public and Private Reconstruction Office Hazard to be analysed: Earthquakes
W2	Context: Suggested Geographic Information System (GIS), layers to be included: urban plan; climate change plan; snow emergency plan, post-disaster reconstruction plan; reconstruction progress status quo Ex-ante Scenario to be analysed: Earthquake-induced impact scenarios for the built environment, population, artworks
W3	Selected resilience strategies: Post disaster reconstruction of building using seismic retrofitting interventions at different level of effectiveness Ex-post scenario: Earthquake-induced impact scenarios after the implementation of the different envisaged retrofitting interventions. Assessments of benefits in terms of reduced impacts on the built environment, population, artworks
W4	See Appendix A

Figure 5. On-line interactive board used to support co-creation related to the ARCH DSS Camerino activities in particular during Workshops W2 and W3.

4.2. Design of the DSS

A summary of the dashboard specification with the type of indicators selected and how the ARCH DSS dashboard links with the other ARCH tools is presented in Table 4.

Table 4. Requirements for Camerino ARCH DSS dashboard.

	ARCH DSS Camerino
Link	https://tinyurl.com/archDss-camerino-en (accessed on 5 December 2022)
Unit of analysis	Single building
Hazard under analysis (data in THIS)	Earthquake Hazard Indicators: IEMS-98, PGA
Exposed asset (data in HArIS)	Residential buildings, Monumental Buildings, Artworks contained in Monumental Building, People living in Residential Buildings
Assessed Vulnerabilities	Seismic Vulnerability of Residential buildings Seismic Vulnerability of cultural heritage buildings Vulnerability Indicators: V, Q
Assessed Physical Damage	Earthquake induced damage to Residential buildings and cultural heritage buildings Damage Indicators: Dk with k = 0–5
Assessed Impacts	Impacts on People: homeless, injured, dead Impacts on artworks: to be evacuated; damaged Direct Economic Losses: repair/reconstruction costs for buildings Impact Indicators: Ik with k = 0–5
RIO, resilience inventory option from ARCH RMI ARCH RMI—Resilience Measures Inventory	Structural interventions on buildings Vernacular constructive techniques
CCA/DRM phase of ARCH Resilience Framework	Conduct emergency response Recover and building back better

The first step for the development has been the identification and the collection in HArIS and THIS of the data deemed to be relevant for what is described next.

4.3. Data and Information from HArIS and THIS

ARCH DSS dashboards sourced data and information from ARCH THIS and HArIS for the characterization of the exposure and hazard respectively.

THIS combines different data sources to offer indicators about threats and hazards potentially affecting the historic areas. With reference to the earthquake hazard, different information is available in THIS including historical events, recent events and continuous and real-time monitoring, as described in Table 5.

Table 5. Information contained in THIS and available for the DSS.

Dataset\Information	Description
Historical Earthquakes	Database of moderate-to-severe historic earthquakes in Italy and Europe area [36,37,38,39]
Seismogenic Sources	Database of seismogenic sources in Italy and Europe [40,41]
Seismic Hazard Map	Expected mean peak ground acceleration (PGA) on rigid soils for 10% of probability of exceedance in 50 years in Italy and Europe [42,43]
Recent earthquakes	List of occurred earthquakes by national services in Italy [44]
Camerino Urban Seismic Network	Time-histories and ground motion parameters from recordings obtained by Real-Time Urban Seismic Network in Camerino [45,46]

For the hazard representation in Camerino, reference has been made to the Seismic Hazard Map and Historical earthquakes Database (first and third row in Table 5 above and Table 6 below).

Table 6. Information contained in HArIS and available for the DSS.

Asset	Information	Description
Building	General	construction name; cadastral refence; address; number of occupants; date of Construction; date of Renovation
	Structural	footprint and height; construction typology; number of basement and storeys; average stories height; building position in the aggregate; vertical and horizontal structures; type of roof
	Material	prevalent material; percentages of materials on the façade;
	Damage	damage level on the structural components; damage to the coverings; damage to objects; damage to hydraulic system; damage to Electric/gas supply systems
	Social/cultural values	historical; cultural, aesthetic, and symbolic; religious; spiritual value; recreational value
	Indices	usability classification; vulnerability index
Object (artworks)	General	artefact name; type and author; disciplinary sector; category (movable or immovable)
	Dimensional	width; height; length\diameter
	Position	storage area; storage sector (into the previous area)
	Other	participation in events; necessary intervention

A hazard map following earthquake events (e.g., [45,47]) can be realized by using the recordings from the Real-Time Urban Seismic Network deployed in and around the historic center of Camerino [46] (for seismic events causing acceleration peaks greater than 1 cm/s² [45] and accounting for the different amplification of the ground motion due to the different peculiar morphology and soil conditions of the inhabited areas in the municipal territory of Camerino). This map, coupled with the automatic implementation of the analytical functions described in Section 4.4.1 would allow for the elaboration of impact scenarios a few minutes after a seismic event.

HArIS stores and structures information about movable and immovable assets in the HA, therefore data have been collated on both buildings and artworks (cf. [45]). Table 6 reports the main information collected for each asset depending on its typology. In black color are those that have been actually used for the ARCH DSS Camerino dashboards, while in blue color are those ones that have not been used for this specific implementation.

4.4. Tool Realization in the BI Environment

The ARCH DSS has been realized and deployed as an MS PowerBI report. The HArIS and THIS data, described in Section 4.3, has allowed instantiation of the model in Figure 4, and it has been used for the resilience analysis as follows.

4.4.1. Assessment and Representation of Ex-Ante and Ex-Post Scenarios

Impacts and damages to the built and natural environment, as well as to the social, economic and intangible dimensions of the historic areas potentially induced by climate changes and other hazards, can be estimated by convoluting:

-

the assessment of the hazards that might potentially affect the location of the historic area;

-

the characterization of the elements, both tangible and intangible, included in the different dimensions of the historic area, exposed to those hazards;

-

the assessment of the vulnerabilities of the historic area’s exposed elements to each specific hazard identified.

In summary, the determinants of risk assessment are: hazard, exposure and vulnerability; impacts induced by earthquake events for the historic areas of Camerino have been estimated as a function of those determinants. The abovementioned concept, specifically customized for historic areas, is universally recognized [48,49,50,51,52,53] and can be summarized in the following Equation:

Impacts ≈ Hazard * Exposure * Vulnerability

(1)

where the symbol * has the meaning of convoluting and the symbol ≈ has the meaning of numerical approximations.

An important aspect to be highlighted about risk and impact scenario assessment is in fact the incomplete knowledge in each one of the three abovementioned determinates, i.e., hazard assessment, exposure characterization and vulnerability assessment; these uncertainties that necessarily combine into an expanded uncertainty affecting the impact assessment do not necessarily have to be quantified [54], and in the ARCH project has been quantified only to a certain extent. However, it is imperative to be aware and make any potential users aware of the gaps in knowledge and resulting uncertainties. Therefore, an impact assessment is just targeting the estimation of “the potential for adverse impacts and consequences”, where the word “potential” is used to make clear and explicit the uncertainty affecting the assessment.

Hazard. Two different seismic hazard scenarios have been considered and represented in the Camerino ARCH DSS, i.e., produced by a low and a very high seismic event; Table 7 below summarizes the characteristics of these events, while all the details are provided in the ARCH deliverable D5.1 [55], including the explanation of how the data included in THIS has been used and exploited to define the hazard scenarios.

Table 7. ARCH DSS Camerino, hazard scenarios.

ARCH DSS Legend	Macroseismic Intensity IEMS-98	PGA[g]	Return Period
Low	VII (Damaging)	0.065	81%
Devastating	XI (Very High)	0.35	2%

Vulnerability. Reference has been made to an index-based method for assessing the seismic vulnerability of both residential and monumental buildings, referred to as macroseismic-mechanical vulnerability, according to which the seismic vulnerability is measured in terms of a Vulnerability Index V ranging from 0 to 1 computed by accounting for different typological and constructive features of the building as well as its state of maintenance and any retrofitting intervention; data on the aforementioned features were sourced from HArIS as reported in D4.2 [56] and D5.2 [57]. The seismic Vulnerability Index V approach, implemented for the Camerino ARCH DSS, is a cross-validated observed-based/expert-based/mechanical-based approach. This approach can be implemented with different levels of data availability, starting from very basic data. Then, the reliability of the estimated seismic vulnerability index V can be improved when further data about the building and/or evidence on the seismic performance of similar typologies become available. This data may come from on-the ground observations, in-situ or laboratory tests as well as from numerical analysis simulations. All the details of the methods are reported in [58,59], and summarized in D5.2 [57].

Physical Damage Assessment. Equation (2), proposed by [58,59] has been implemented in the Camerino ARCH DSS for the assessment of earthquake-induced physical damage to both residential and monumental buildings:

μ_D = 2.5[1+tanh((I_(EMS-98)+αV-β)/Q)]

(2)

where, μ_D is the expected mean degree of damage for single buildings; the seismic hazard is represented using the macroseismic intensity IEMS-98, according to the European Macroseismic Scale EMS-98 [60]; the seismic vulnerability of single or sets of aggregated buildings and structures is assessed in terms of the Vulnerability Index V and Ductility Index Q; α and β are coefficients whose value can be assumed as follows: α = 6.25, β = 13.1, resulting by deriving Equation (2) from the damage probability matrices implicitly defined by EMS-98 [60] using a combined probabilistic and fuzzy-logic approach [58,59].

The level of damage to each building or group of buildings can be allocated based on the resulting μD according to the EMS-98 physical damage scale [60] that considers five damage levels, Dk i.e., D1, D2, D3, D4, D5, plus the absence of damage, D0, enabling the qualitative description of the earthquake-induced physical damage to building structural and non-structural components (Table 8).

Table 8. Attribution of damage level Dk (k = 0–5) based on μD ranges resulting from Equation (1).

Dk	Damage Levels	μD Ranges
D0	No damage	0 ≤ μD < 0.5
D1	Slight damage, cracking of non-structural elements	0.5 ≤ μD < 1.5
D2	Moderate damage, major damage to non-structural elements minor damage to load bearing ones	1.5 ≤ μD < 2.5
D3	Heavy damage, significant damage to load bearing elements	2.5 ≤ μD < 3.5
D4	Very heavy damage, partial structural collapse	3.5 ≤ μD < 4.5
D5	Destruction, serious destruction of structural and non-structural elements or total collapse	4.5 ≤ μD ≤ 5

Consequences on People. Starting from the level of earthquake-induced physical damage Dk (k = 0–5) estimated as for Equation (2) and Table 8 above, consequences, for each building and for the two different hazard scenarios estimated (Table 9), in terms of possible unavailability of the building and consequences for the people possibly present in the building and therefore exposed to the falls of non-structural elements, and/or the partial or global collapse of the structure have been estimated, as such:

Table 9. Consequences on People estimated based on physical damage levels Dk (k = 0–5).

Dk	Homeless	Potentially Injured People	Potentially Dead People
D0	NA	NA	NA
D1	NA	NA	NA
D2	NA	NA	NA
D3	ALL in the short term	NA	NA
D4	ALL in the long term	5%	1%
D5	ALL in the in the long term	30%	10%

• Injured people, 5% of the people who are in buildings damaged at level D4 and 30% of those who are in buildings damaged at level D5;
• Dead people, 1% of people who are in buildings damaged at level D4 and 10% of those who are in buildings damaged at level D5.
• To assess the consequences on people as above-mentioned, reference has been made to the approach adopted by the Italian national Department of Civil Protection for assessing the seismic risk in Italy at a national scale [61].

Consequences on Artworks. These have been assessed starting from the assessment of the “downtime” of the building, i.e., the time during which the building hosting the artwork cannot be accessed due to inspections, propping, repair, or reconstruction activities. According to the adopted approach [61] building downtime can be estimated (Table 10) as such:

Table 10. Assumed correlation between physical damage level Dk, the residual building usability and downtime, impacts on the artworks and loss of intangible value.

Dk	Building Usability	Downtime	Intangible Value Loss	To Be Evacuated	Potentially Damaged
D0	Usable	Immediate to days	No loss	NA	NA
D1	Temporally non usable for inspections	Within days to weeks	Minor loss	NA	NA
D2	Temporally non usable for inspections and propping	Within weeks to months	Partial/Moderate loss	NA	NA
D3	Non usable long term	Within month to a year	Significant Loss	ALL	1%
D4	Non usable long term	Within years to decades	Very Significant Loss	ALL	5%
D5	No longer usable	N/A	Highly significant/total Loss	ALL	30%

-

Buildings unusable in the short term for inspections and safety of non-structural elements or limited portions of the building: damaged buildings with a level of damage D1 and D2;

-

Buildings unusable in the long term for safety and repair or reconstruction work: buildings damaged with a damage level from D3 onwards.

As a function of the downtime levels, consequences on the artworks can be estimated (Table 10) as such:

-

Artworks to be evacuated, the ones contained in buildings unusable in the long term;

-

Artworks damaged: 1% of artworks contained in buildings damaged at level D3, 5% of the artworks contained in buildings damaged at level D4, and 30% of those that are in buildings damaged at level D5.

Furthermore, a more granular definition of downtime level and a first estimation in terms of the impact to intangible heritage attributes is proposed in Table 10.

Direct Economic Losses. These have been assessed limited to the costs of building repair and reconstruction calculating as a first step a value for each building (i.e., by multiplying the total surface area of each building by an assumed Unit Cost [euro/m²] equal to 1350 euro/m²); secondly the repair/replacement costs have been estimated by multiplying the resulting building value by the level Ck (ranging percentages from 0–100% of the building value) corresponding to the damage level Dk suffered by each building in the assessed scenario, as reported in Table 11.

Table 11. Assumed correlation between physical damage level Dk, and cost level Ck defined of [%] of building value required for repair or rebuilding interventions.

Dk	Homeless	Ck [%] of Building Value
D0	NA	0
D1	NA	2
D2	NA	10
D3	ALL in the Short term	30
D4	ALL in the Long term	60
D5	ALL in the in the Long term	100

The Impact levels I_k, (k = 1–5) used to provide a visual representation, further to the numerical one, in the ARCH DSS Camerino dashboard of the consequences on people, artworks and direct economic losses (i.e., repair/reconstruction costs for the damaged buildings) have been organized as reported in Table 12.

Table 12. Assumed impact levels Ik (k = 0–5) for the numerical ranges of the consequences estimated for people, artworks and direct losses in the ARCH DSS Camerino.

Ik	Consequences on People	Consequences on Artworks	Repair/Reconstruction Costs
I1	0–1 people	0–1 artworks	<10.000 euro (10 k)
I2	1–3 people	1–3 artworks	10 k euro–50 k
I3	3–5 people	3–5 artworks	50 k–100 k
I4	5–10 people	5–10 artworks	100 k–500 k
I5	>10 people	>10 artworks	>500 k

Ex post scenarios. After the implementation of solutions and strategies selected from the ARCH RMI, the positive effects of realizing structural interventions on buildings to reduce seismic vulnerability, adopted at the maximum possible extent, vernacular constructive techniques have been assessed and represented in the ARCH DSS Camerino. Two hypotheses of resilience strategies have been analyzed, i.e., heavy and light structural interventions on the buildings and the benefits have been represented in the ARCH DSS Camerino in terms of reduction of the impacts estimated for people, artworks and economic losses for the two hazard scenarios under analysis (i.e., low and devastating, as in Table 2) compared to the status-quo impact scenario. ARCH deliverables D5.2 [57] and ARCH D6.2 [62] report on how the vulnerability and ductility indexes, V and Q have been modified to reflect the implementation of the structural interventions on the buildings. Damages and Impacts for the ex-post scenarios have been assessed as a function of the updated V, Q by implementing Equation (2) and the following steps, as described above.

4.4.2. User Interfaces

The ARCH DSS user interfaces have been designed based on the objective of the decision processes of interest and the type and granularity of the information to be presented. Within the overall objective of the DSS, such as support planning resilience building of the historic area, two more specific objectives were agreed with the Camerino municipality stakeholders for the tool, namely: (OA) planning the reconstruction and (OB) preservation of the artworks. For each of these objectives, a set of design questions were defined to select and organize the information into a tool available for usage in a short time. These are:

(Q_OA) What earthquake scenarios are the most relevant? What is the impact for the city? Which building would be most affected if no intervention is planned? How do different structural interventions compare?

(Q_OB) Which buildings are the most vulnerable from the perspective of the CH preservation? What is the most effective intervention for CH?

From these questions, data visualization objects have been built by using the functions of PowerBI, and a sort of storytelling-based and interactive report has been realized. The first page of the report, shown in Figure 6, represents on a map some impact scenarios assuming the situation on the built environment as is (ex-ante as built). Impact levels for selected types are presented, that aggregate results from simulated earthquake scenarios of low and very high severity. The second page provides a view of two impact maps enabling a comparison between ex-ante (no intervention) and ex-post light structural interventions. The third page allows a comparison of impact scenarios after two different resilience strategies, such as light structural intervention and heavy structural intervention (see Figure A1 and Figure A2 in Appendix B). The fourth page provides more details on the results by means of data charts.

Figure 6. Visualization of ex ante impact scenarios.

As described in Table 1, the ARCH DSS Camerino dashboard has been designed to be adaptable to late requirements. In this respect, the following extensions are envisaged, which will be delivered in additional pages of the report without impact on the current interfaces:

-

“Calibration” where HARIS “Damage” information is used to compare and calibrate the damage scenarios estimated and already represented in ARCH DSS;

-

“Climate-change impact scenario” where HArIS data about “percentages of materials on the façade” is used to estimate the possible impacts in terms of erosion and material degradation exacerbated by extreme events induced by climate change; the idea is to depict and represent in ARCH DSS dashboards the cause-effect relationships between various stressors (sudden and/or extreme changes in temperature, precipitation, atmospheric moisture, and wind intensity) and their impacts on cultural heritage. This will allow other researchers, stakeholders, and possibly decision-makers to determine the potential impacts of climate change on a specific cultural heritage asset, with special focus on façades as a first step.

-

“Intangible values and intangible impacts” where HArIS data about “Social/cultural values” is used to support the prioritization of retrofitting interventions and/or post-disaster reconstruction based on the local communities’ intangible values, such as their wellbeing and sense of belonging.

Similarly, as the current version of the ARCH DSS dashboard supports only representation of static scenarios, temporal evolution of the resilience, that is by its nature a time-dependent characteristic, can be displayed as a future extension of the tool, following what envisaged in [5,63,64,65].

4.5. End Users Feedback

The ARCH DSS tool was first demonstrated at a co-creation workshop with stakeholders of the Camerino municipality, as described in Section 4.1. Then the tool was made publicly accessible on the Internet, and additional users from the municipality were invited to evaluate it off-line until the end of the project (period from May to July 2022). A survey, prepared for all case studies, was supplied to them to collect feedback. The survey is presented in Appendix A, together with the collected results. As shown, positive feedback has been received from users having different roles at the Camerino municipality, relevant for the case study, who also provided constructive suggestions for improvement, regarding both the tools’ functionality and the type of information presented.

5. Conclusions, Future Works and Practical Implications

The paper described an innovative fully co-creative-based approach to develop user friendly tools for democratizing the knowledge and awareness on possible impacts that might arise from natural hazards in the built environments, with special focus on historical areas. In particular, the possibilities and extent of the benefits that might arise, after significant resilience interventions, have been elaborated on for the tools to support informed decision making.

The paper showcases the process and implementation of the proposed methods on the case study of Camerino Municipality. This application has been focused on the possible impacts induced by earthquakes and on the benefits that can be obtained by the retrofitting of the building, at different level of strength, in terms of a significative reduction of the impacts expected on the population, built environment, as well as on the peculiar and precious artworks hosted by the several monumental buildings in Camerino.

The process activities, from requirements collection to the validation of the tools, which have been performed iteratively, have actively involved expert end-users at the Camerino Municipality.

Future aims for practical usage of the ARCH DSS dashboard have been envisaged in this process, including support to emergency management, with the possibility of handling and representing real time hazard mapping, and estimation of impacts, after real events. Capabilities to handle dynamic data (i.e., data that varies over time), to represent and update socio-economic KPIs and intangible impacts KPIs, can be added with low development effort within the same framework.

With respect to future research from a technological viewpoint, enhancing the decision support with methods of artificial intelligence or agent-based and/or of systems dynamics, could be investigated to face the complexity of human decisions in relation to the tangible and intangible dimensions of the historic areas.

This work provides several practical implications both from a technological and a methodological perspective. The first is related to the usability and potential benefits of the ARCH DSS, as conceived within the ARCH project, after the project itself, possibly extended to, or customized for, different end users. In this case, stakeholders as well as members of the community can refer to and use the ARCH DSS dashboards to inform and support all the phases of the DRR/CCA cycle. In the pre-disaster disaster phase, the ARCH DSS dashboards can be used to create awareness among the population of hazards, vulnerabilities, and impacts; in particular the ARCH DSS dashboards can be seen as an education supporting tool, starting from the primary school level, to create awareness among the young generations on the feasibility and effectiveness of implementing mitigation actions and on taking a proactive role in disaster prevention. For workers, managers and directors of civil protection offices, the ARCH DSS dashboards may inform, enrich and make readily available, consultable civil protection plans. For asset managers and urban planning and workers, the ARCH DSS dashboards may inform and complement urban plans, allowing to account for hazards and make wise decisions for post-disaster reconstruction and/or for business-as-usual urban planning so that any future growing and development of the city or conservation strategies for historic area can avoid or mitigate impacts.

No less important is the methodological implication. The detailed description of the experience of Camerino provided in this paper is exemplary for how to replicate the ARCH DSS development process in further case studies, e.g., different cities and/or different hazards and/or different resilience metrics. This would allow for gaining feedback and lessons-learnt that are useful for improving the methodology itself.