How to report on the adaptation pillar using the JRC offline reporting template

Remember from Lesson 7.2, the JRC offline reporting template is essentially an Excel spreadsheet. When reporting on the adaptation pillar, there are three main exercise sheets to complete:

Sheet 1

Risk and Vulnerability Assessment

Sheet 2

Adaptation actions

Sheet 3

Adaptation planning process

These sheets are explained in more detail in the sections that follow.

Sheet 1

RVA

Sheet 1 consists of:

General RVA information

Step 1: Climate hazards in your local government (LG)

Step 2: Current risks

Step 3: Future hazards

Step 4: Vulnerable sectors

Step 4: Step 5: Vulnerable population groups

Step 6: Adaptive capacity

Let’s unpack these points one at a time.

General RVA information

Under “General RVA information”, you will need to input:

• Title
• Author(s)
• Year
• Description
• Boundary
• Method & Source(s)

Step 1: Climate hazards in your local government

• Make a list of the climate hazards that are applicable to your local government by selecting them from the list provided in the RVA sheet of the template.
• Write a brief description of each climate hazard.

Climate hazards listed in the offline template

• Extreme heat
• Extreme cold
• Heavy precipitation
• Rain storm
• Fog
• Hail
• Floods & sea level rise
• Flash / surface flood
• River flood
• Coastal flood
• Groundwater flood
• Permanent inundation
• Droughts & water scarcity
• Storms
• Severe wind
• Tornado
• Cyclone (hurricane/ typhoon)
• Tropical storm
• Extratropical storm
• Storm surge
• Mass movement
• Landslide
• Avalanche
• Rockfall
• Subsidence
• Mass movement
• Landslide
• Avalanche
• Rockfall
• Biological hazard
• Salt water intrusion
• Chemical change
• Other [please specify]

Step 2: Current risks

• Indicate the probability of each relevant climate hazard occurring by using the drop-down button provided to indicate this (scale is listed as low, moderate, high, not known).
• Indicate the consequence of the climate hazard when it does occur by using the drop-down button provided to indicate this (scale listed as low, moderate, high, not known).

Example from the offline template:

Step 3: Future hazards

• Indicate the expected change in intensity by using the drop-down button provided (scale is listed increase, decrease, no change, not known).
• Indicate the expected change in frequency by using the drop-down button provided (scale is listed increase, decrease, no change, not known).
• Indicate the timeframe of when the expected change in intensity and frequency is likely to occur by using the drop-down button provided (scale is listed short-term, medium-term, long-term, not known).
• Provide a description of the anticipated impacts of the future hazards.
• The description will be richer and more robust if you have heard from a diverse range of voices during the SEACAP process.

Example from the offline template:

Step 4: Vulnerable sectors

• Indicate the sectors which are considered to be the most vulnerable to climate hazards affecting your local government by selecting those that are applicable from the drop-down list.
• Indicate each sector’s vulnerability level to climate hazards by using the drop-down button provided to indicate this (scale is listed low, moderate, high, not known).
• Think about which of those sectors have a disproportionate representation or underrepresentation of women.
• Indicate each sector’s indicator level by selecting an “RV” code*.
• Once an indicator is selected from Annex 3, add a value for this indicator for each hazard/line (if possible).

*The meaning of each “RV” code is included in Annex 3 of the offline template and additional indicators can be added (last tab of the Excel document).

Example from the offline template:

• The hazard is extreme heat and the most vulnerable sector is health.
• The indicator selected is RV_S7 “Number of deaths related to heat waves”.
• The value for this indicator is 150 (deaths related to heat waves, per year).

Step 5: Vulnerable population groups

• Indicate the most vulnerable population group by selecting those that are applicable from the drop-down list.

Example from the offline template:



Step 6: Adaptive capacity

• Indicate the adaptive capacity factor by selecting that which is applicable from the drop-down list.
• Indicate the adaptive capacity level by selecting that which is applicable from the drop-down list.
• Indicate which indicators are relevant by selecting those that are applicable from the drop-down list. (Note the list will display a “RV-A” number, the meaning of which can be found in Annex 3.)
• Indicate the indicator value by adding this directly in the appropriate unit. (Note the units will display alongside their corresponding “RV-A” number, the meaning of which can be found in Annex 3.)
• Quantifying this adaptive capacity will enable the city to monitor progress.

Example from the offline template:


RV-A1 is the % of public funds available to address a climate hazard and its impacts (e.g. fire, flood, heatwave, etc). So in the example here, only 50% of public funds is available to address extreme heat hazards.

Sheet 2

Adaptation actions

Sheet 2 consists of the following:

General Adaptation Action Plan information

Step 1: Adaptation actions per sector

Step 2: Responsible parties and policy alignment

Step 3: Origin of the action, timeframe and status

Step 4: Links to other pillars, stakeholders, related indicators and outcomes

Step 5: Costs and key actions

Let’s unpack these points one at a time.

General Adaptation Action Plan information

The primary information to complete includes:

• Title
• Date of formal approval
• Desision body approving the plan
• Description
• Nature of the plan
• Boundary of the plan
• SEACAP webpage

Step 1: Adaptation actions per sector

• Indicate which sectors have been prioritised.
• Include an action title for that sector (max. 120 characters).
• Include an action description to further describe the action (max. 300 characters).
• Indicate which climate hazard the action addresses.

*Note you may have more than one action per sector, in which case, include this (see example).

Example from the offline template:



Step 2: Responsible parties and policy alignment

• Indicate a responsible body for implementing the action.
• Indicate which policies the action aligns to.

Example from the offline template:



Step 3: Origins of action, action timeframe and implementation status

• Indicate origins of action from the drop-down list provided.
• Indicate the start time of the action using the drop-down list provided.
• Indicate the end time of the action using the drop-down list provided.
• Indicate the implementation status of the action using the drop-down list provided.

Example from the offline template



Step 4: Links to other pillars, stakeholders, related indicators and outcomes

• Indicate whether the action also addresses a mitigation issue by marking with an x.
• Indicate whether the action also addresses an access to energy issue by marking with an x.
• Indicate stakeholder involvement from the drop-down list provided.
• Indicate the vulnerability tackled using the drop-down list provided.
• Describe whether there are any other related indicators as per the list in Annex 3.
• Describe the outcomes reached.

Example from the offline template:



Step 5: Costs and key actions

• Type in the numeric value of investments.
• Type in the numeric value of avoided costs.
• Type in the currency.
• Indicate whether or not the action is a key action using the option provided in the drop-down list.

Example from the offline template:



Sheet 3

Adaptation planning process

Sheet 3 consists of just one step:

Step 1: Progress in the implementation of the adaptation process

Example from the offline template: