{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Measures","Policy matrix @ threat","References","Categories vs. Stages","Drop down lists","Stats","Tables","Track record"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Measures","index":0,"n_rows":554,"n_cols":26,"rows_kept":554,"cut":false,"hidden":false,"merged":[]}
["Nr.","Main threat","Specific threat","Climate parameter","Adaptation measure","Asset type","Policy","Category of measure","Stage","Scale","Qualitative score on criteria",null,null,null,null,"Green","Contribution to sustainability criteria",null,null,null,null,null,null,"Extra information about the measure","Comments","Ref.no."]
[null,null,null,null,null,null,null,null,null,null,"Availability","Safety","Impact on network","Direct cost","Reputation",null,"General / Management","Climate change and Energy","People and Communities","Ecology / Biodiversity","Physical resources","Quality of Life","Safety, Health & Equity"]
[1,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C3,climate_par_table,2)","v":{"$error":"#NAME?"}},"Access restriction","Mobility services","Extreme event management","Traffic management","Response","Stretch",2,0,-2,2,-1,"YES",2,2,1,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures "]
[2,"01 Flooding of road surface (assuming no traffic is possible)","01-1 Flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C4,climate_par_table,2)","v":{"$error":"#NAME?"}},"Avoid deforestation in the catchment area","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Resilient construction","Pro-action","Object - stretch - network",3,1,0,-1,2,"YES",0,3,3,3,0,2,2]
[3,"01 Flooding of road surface (assuming no traffic is possible)","01-1 Flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C5,climate_par_table,2)","v":{"$error":"#NAME?"}},"Build dams, reservoirs and retaining ponds to buffer the water","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","Object - stretch - network",2,0,0,-1,2,"YES",1,0,0,2,-1,0,0]
[4,"01 Flooding of road surface (assuming no traffic is possible)","01-1 Flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C6,climate_par_table,2)","v":{"$error":"#NAME?"}},"Build flood walls to protect the road from flooding","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","Object - stretch - network",2,1,0,-2,-1,"YES",-1,-1,2,-2,-1,-1,0,null,null,47]
[5,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C7,climate_par_table,2)","v":{"$error":"#NAME?"}},"Carriageway cross-over","All road infrastructure","Extreme event management","Traffic management","Response","Stretch",-2,-1,0,-2,-2,"YES",0,0,0,0,1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","If dual carriageway "]
[6,"01 Flooding of road surface (assuming no traffic is possible)","01-1 Flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C8,climate_par_table,2)","v":{"$error":"#NAME?"}},"Carrying out risk assessment of  identified areas","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Object - stretch - network",1,2,1,-2,2,"YES",-2,-1,1,0,0,0,0,null,null,47]
[7,"01 Flooding of road surface (assuming no traffic is possible)","01-1 Flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C9,climate_par_table,2)","v":{"$error":"#NAME?"}},"Clear natural blockages such as shrubs and weeds","Drainage of earthworks and pavements, sewers","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Object",1,0,-1,2,-1,"YES",0,1,0,0,1,0,0]
[8,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C10,climate_par_table,2)","v":{"$error":"#NAME?"}},"Construction of (temporary) flood barriers along road","All road infrastructure","Extreme event management","Robust construction","Response","Stretch",2,1,1,-2,1,"NO",0,0,0,0,0,0,1,null,null,"-"]
[9,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C11,climate_par_table,2)","v":{"$error":"#NAME?"}},"Develop plans and routines for the priority of securing areas prone to flooding","All road infrastructure","Pro-active attitude","Planning","Pro-action","Object - stretch - network",1,2,-1,-1,2,"YES",0,0,0,0,0,0,0,null,null,47]
[10,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C12,climate_par_table,2)","v":{"$error":"#NAME?"}},"Drainage of road embankment for fast lowering of groundwater table after flood retreats","Drainage of earthworks and pavements, sewers","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",1,0,0,-1,1,"YES",-2,-1,-1,-1,0,0,0]
[11,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C13,climate_par_table,2)","v":{"$error":"#NAME?"}},"Dredge to increase depths and/or straighten the stream","All road infrastructure","Pro-active attitude","Robust construction","Pro-action","National network",1,-1,0,-1,-1,"YES",-2,-1,1,-2,0,0,0,null,null,56]
[12,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C14,climate_par_table,2)","v":{"$error":"#NAME?"}},"Elevated roads above High Water Level","All road infrastructure","Prevention","Robust construction","Prevention","Stretch - network",2,2,2,-3,1,"NO",2,0,0,0,-2,0,2,null,null,1]
[13,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C15,climate_par_table,2)","v":{"$error":"#NAME?"}},"Install sign posts warning for flooding in threatened areas","Mobility services","Traffic management","Traffic management","Preparation","Object - stretch - network",3,2,-1,-1,0,"NO",0,0,0,0,0,0,0]
[14,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C16,climate_par_table,2)","v":{"$error":"#NAME?"}},"Integration of infrastructure development and land use planning ","All road infrastructure","Pro-active attitude","Planning","Pro-action","Regional network",2,2,2,2,1,"YES",2,0,0,2,2,0,2,null,"Applies to all threats",10]
[15,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C17,climate_par_table,2)","v":{"$error":"#NAME?"}},"Keeping in-house GIS up to date","All road infrastructure","Pro-active attitude","Planning","Pro-action","Regional network",3,2,0,-1,2,"YES",-1,0,0,0,0,0,0,null,null,47]
[16,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C18,climate_par_table,2)","v":{"$error":"#NAME?"}},"Keeping records of flooding events and locations","All road infrastructure","Monitoring and prediction","Monitoring","Pro-action","Regional network",2,1,0,-1,1,"YES",-2,0,0,0,0,0,0,null,null,47]
[17,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C19,climate_par_table,2)","v":{"$error":"#NAME?"}},"Lane closure","All road infrastructure","Extreme event management","Traffic management","Response","Stretch",-2,3,0,-2,-2,"YES",0,1,-1,1,0,-1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","If a traffic lane still available"]
[18,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C20,climate_par_table,2)","v":{"$error":"#NAME?"}},"Make strategies for temporary rerouting","Mobility services","Pro-active attitude","Planning","Prevention","Regional network",3,1,2,-1,2,"YES",-2,-1,-1,0,0,-1,0]
[19,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C21,climate_par_table,2)","v":{"$error":"#NAME?"}},"Mapping areas prone to flooding (Blue spot analysis)","All road infrastructure","Monitoring and prediction","Monitoring","Pro-action","Regional network",2,1,0,-1,2,"YES",-1,0,0,0,0,0,0,null,null,47]
[20,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C22,climate_par_table,2)","v":{"$error":"#NAME?"}},"Prepare and educate road users for flooding","All road infrastructure","Capacity building","Capacity building","Pro-action","Object - stretch - network",0,2,2,-1,2,"YES",2,2,2,0,1,0,2,null,null,26]
[21,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C23,climate_par_table,2)","v":{"$error":"#NAME?"}},"Prepare and educate staff for flooding","All road infrastructure","Capacity building","Capacity building","Pro-action","Object - stretch - network",0,1,2,-1,0,"YES",2,0,0,0,1,0,1,null,null,26]
[22,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C24,climate_par_table,2)","v":{"$error":"#NAME?"}},"Prepare contingency / emergency plans","All road infrastructure","Pro-active attitude","Planning","Pro-action","Regional network",0,3,1,0,-1,"YES",2,0,0,0,0,0,2,null,null,47]
[23,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C25,climate_par_table,2)","v":{"$error":"#NAME?"}},"Prepare Traffic Management Plans","Mobility services","Traffic management","Traffic management","Prevention","TEN-T - national - regional",2,1,3,-1,2,"YES",2,2,2,0,0,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures "," Prevention in Traffic Management domain…"]
[24,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C26,climate_par_table,2)","v":{"$error":"#NAME?"}},"Preventive information","All road infrastructure","Research","Research ","Response","TEN-T - national - regional",2,2,2,-1,1,"YES",2,0,0,0,0,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,48]
[25,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C27,climate_par_table,2)","v":{"$error":"#NAME?"}},"Rebuild stretches of the road on safe ground","All road infrastructure","Prevention","Robust construction","Prevention","Stretch",1,1,-1,-2,-1,"NO",-2,-2,-2,-1,-2,0,0]
[26,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C28,climate_par_table,2)","v":{"$error":"#NAME?"}},"Relocation of road","All road infrastructure","Prevention","Robust construction","Prevention","Stretch - network",2,2,2,-3,2,"NO",2,0,0,0,0,0,2,null,null,"-"]
[27,"01 Flooding of road surface (assuming no traffic is possible)","01-1 Flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C29,climate_par_table,2)","v":{"$error":"#NAME?"}},"Remove large obstructions (such as fallen trees or rubbish which restrict flow","Drainage of earthworks and pavements, sewers","Corrective maintenance and replacement","Maintenance and replacement","Preparation","Object",3,2,0,1,1,"YES",1,0,1,-1,0,0,1]
[28,"01 Flooding of road surface (assuming no traffic is possible)","01-1 Flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C30,climate_par_table,2)","v":{"$error":"#NAME?"}},"Remove recent accumulations of debris which create obstructions to flow","Drainage of earthworks and pavements, sewers","Corrective maintenance and replacement","Maintenance and replacement","Preparation","Object",2,1,0,-1,1,"YES",2,0,0,0,0,0,0]
[29,"01 Flooding of road surface (assuming no traffic is possible)","01-1 Flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C31,climate_par_table,2)","v":{"$error":"#NAME?"}},"Reroute the traffic","Mobility services","Extreme event management","Traffic management","Response","Stretch - network",2,0,-3,-2,1,"NO",0,-2,-3,0,-1,0,0]
[30,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C32,climate_par_table,2)","v":{"$error":"#NAME?"}},"Rerouting and guidance","Mobility services","Extreme event management","Traffic management","Response","TEN-T - national - regional",2,0,3,-2,-1,"YES",1,2,2,0,-1,-1,1,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures "]
[31,"01 Flooding of road surface (assuming no traffic is possible)","01-1 Flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C33,climate_par_table,2)","v":{"$error":"#NAME?"}},"Resize drainage systems to meet threats","Drainage of earthworks and pavements, sewers","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch - network",3,1,-1,-2,2,"YES",-1,0,2,-1,-1,0,0,null,null,47]
[32,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C34,climate_par_table,2)","v":{"$error":"#NAME?"}},"Revised standards for road design, avoiding buildup of water level differences","All road infrastructure","Prevention","Legislation , regulations","Preparation","Object - stretch - network",1,0,1,-1,0,"NO",2,0,0,0,1,0,0,null,null,14]
[33,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C35,climate_par_table,2)","v":{"$error":"#NAME?"}},"Shelter locations with facilities and life supplies, evacuation routes","All road infrastructure","Prevention","Resilient construction","Preparation","Regional network",0,3,0,-2,2,"NO",2,0,0,0,0,0,2,null,null,1]
[34,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C36,climate_par_table,2)","v":{"$error":"#NAME?"}},"Speed limits ","Mobility services","Extreme event management","Traffic management","Response","Stretch",2,3,0,-1,-1,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","Only for limited flooding"]
[35,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C37,climate_par_table,2)","v":{"$error":"#NAME?"}},"Use geosynthetics for improving slope stability and erosion protection","Geotechnics, including landslips and rock falls, cuts","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",2,0,1,-2,0,"NO",2,0,0,0,1,0,0]
[36,"01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C38,climate_par_table,2)","v":{"$error":"#NAME?"}},"Use vegetation for improving slope stability and erosion protection","Geotechnics, including landslips and rock falls, cuts","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",2,0,1,-2,0,"YES",2,0,0,2,1,0,0]
[37,"01 Flooding of road surface (assuming no traffic is possible)","01-1 Flooding due to failure of flood defence system of rivers and canals",{"$f":"VLOOKUP(C39,climate_par_table,2)","v":{"$error":"#NAME?"}},"Wetland restoration as part of a strategy of multiply lines of flood defences","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","Regional network",1,1,0,-2,2,"YES",0,1,2,3,0,2,0,null,null,"#"]
[38,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$f":"VLOOKUP(C40,climate_par_table,2)","v":{"$error":"#NAME?"}},"Access restriction","Mobility services","Extreme event management","Traffic management","Response","Stretch",2,0,-2,2,-1,"YES",2,2,1,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures "]
[39,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Avoid deforestation in the catchment area","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Resilient construction","Pro-action","Object - stretch - network",3,1,0,-1,2,"YES",0,3,3,3,0,2,2]
[40,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Build flood walls to protect the road from flooding","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","National network",2,1,0,-2,-1,"YES",-1,-1,2,-2,-1,-1,0,null,null,47]
[41,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Build flood walls to protect the road from flooding","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","National network",2,1,0,-2,-1,"YES",-1,-1,2,-2,-1,-1,0,null,null,47]
[42,"01 Flooding of road surface (assuming no traffic is possible)","01-2 pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Carriageway cross-over","All road infrastructure","Extreme event management","Traffic management","Response","Stretch",-2,-1,0,-2,-2,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","If dual carriageway "]
[43,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Carriageway cross-over","All road infrastructure","Extreme event management","Traffic management","Response","Stretch",-2,-1,0,-2,-2,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","If dual carriageway "]
[44,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Carrying out risk assessment of  identified areas ","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",1,2,1,-2,2,"YES",-2,-1,1,0,0,0,0,null,null,47]
[45,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Cleaning out watercourses and structures of flood prone areas ahead of predicted heavy rainfall","Drainage of earthworks and pavements, sewers","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Object - stretch",3,2,0,-1,2,"YES",-2,0,1,1,0,0,0,null,null,47]
[46,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Clear natural blockages such as shrubs and weeds","Drainage of earthworks and pavements, sewers","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Object",1,0,-1,2,-1,"YES",0,1,0,0,1,0,0]
[47,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Construct detention storages ","Drainage of earthworks and pavements, sewers","Pro-active attitude","Robust construction","Pro-action","Object - stretch - network",2,0,0,-1,2,"YES",1,0,0,2,-1,0,0,null,null,55]
[48,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Cover slope with vegetation","Geotechnics, including landslips and rock falls, cuttings","Prevention","Resilient construction","Prevention","Regional network",3,2,1,-2,0,"YES",2,0,0,0,0,0,0]
[49,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Develop plans and routines for the priority of securing areas prone to flooding","All road infrastructure","Pro-active attitude","Planning","Pro-action","Regional network",1,2,-1,-1,2,"YES",0,0,0,0,0,0,0,null,null,47]
[50,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Drainage of road embankment for fast lowering of groundwater table after flood retreats","Drainage of earthworks and pavements, sewers","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",1,0,0,-1,1,"YES",-2,-1,-1,-1,0,0,0]
[51,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Dredge to increase depths and/or straighten the stream","All road infrastructure","Pro-active attitude","Robust construction","Pro-action","National network",1,-1,0,-1,-1,"YES",-2,-1,1,-2,0,0,0,null,null,56]
[52,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Establish a guideline for standardized inspection of drainage system","Drainage of earthworks and pavements, sewers","Pro-active attitude","Legislation , regulations","Pro-action","Regional network",3,2,1,-2,0,"YES",2,0,0,0,0,0,0]
[53,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Inspect blue spots areas adjacent to heavy rainfalls","Drainage of earthworks and pavements, sewers","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Regional network",2,1,0,-1,1,"YES",-2,0,0,0,0,0,0,null,null,57]
[54,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Inspect watercourses regularly","Drainage of earthworks and pavements, sewers","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Regional network",2,1,0,-1,1,"YES",-2,0,0,0,0,0,0,null,null,55]
[55,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Install sign posts warning for flooding in threatened areas","Mobility services","Traffic management","Traffic management","Preparation","Object - stretch - network",3,2,-1,-1,0,"NO",0,0,0,0,0,0,0]
[56,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Keeping in-house GIS up to date","All road infrastructure","Pro-active attitude","Planning","Pro-action","Regional network",3,2,0,-1,2,"YES",-1,0,0,0,0,0,0,null,null,47]
[57,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Keeping records of flooding events and locations","All road infrastructure","Monitoring and prediction","Monitoring","Pro-action","Regional network",2,1,0,-1,1,"YES",-2,0,0,0,0,0,0,null,"Applies to all threats",47]
[58,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Keeping the road drainage in good condition","Drainage of earthworks and pavements, sewers","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Regional network",2,2,0,0,0,"NO",0,0,0,0,0,0,0]
[59,"01 Flooding of road surface (assuming no traffic is possible)","01-2 pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Lane closure","All road infrastructure","Extreme event management","Traffic management","Response","Stretch",-2,3,0,-2,-2,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","If a traffic lane still available"]
[60,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Make strategies for temporary rerouting","Mobility services","Pro-active attitude","Planning","Prevention","Regional network",3,1,2,-1,2,"YES",-2,-1,-1,0,0,-1,0]
[61,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Mapping areas prone to flooding (Blue spot analysis)","All road infrastructure","Monitoring and prediction","Monitoring","Pro-action","Regional network",2,1,0,-1,2,"YES",-1,0,0,0,0,0,0,null,null,47]
[62,"01 Flooding of road surface (assuming no traffic is possible)","01-2 pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Modal shift","Mobility services","Extreme event management","Traffic management","Response","TEN-T - national - regional",2,2,2,-1,1,"YES",2,0,0,0,0,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,48]
[63,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Organize weirs/overflow towards storage facilities","Drainage of earthworks and pavements, sewers","Pro-active attitude","Resilient construction","Pro-action","Object - stretch - network",3,3,2,-2,0,"YES",2,0,0,0,0,0,0]
[64,"01 Flooding of road surface (assuming no traffic is possible)","01-2 pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Prepare and educate road users for flooding","All road infrastructure","Capacity building","Capacity building","Pro-action","Object - stretch - network",0,2,2,-1,2,"YES",2,2,2,0,1,0,2,null,null,26]
[65,"01 Flooding of road surface (assuming no traffic is possible)","01-2 pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$f":"VLOOKUP(C67,climate_par_table,2)","v":{"$error":"#NAME?"}},"Prepare and educate staff for flooding","All road infrastructure","Capacity building","Capacity building","Pro-action","Object - stretch - network",0,1,2,-1,0,"YES",2,0,0,0,1,0,1,null,null,26]
[66,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Prepare contingency / emergency plans","All road infrastructure","Pro-active attitude","Planning","Pro-action","National network",3,2,-1,-1,2,"YES",0,0,0,0,0,0,0,null,"Applies to all threats"]
[67,"01 Flooding of road surface (assuming no traffic is possible)","01-2 pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Prepare Traffic Management Plans","Mobility services","Traffic management","Traffic management","Prevention","TEN-T - national - regional",2,1,3,-1,2,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","MC: Prevention in Traffic Management domain…"]
[68,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Prevent the clogging of pipes/culverts on connecting roads","Drainage of earthworks and pavements, sewers","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Regional network",2,2,0,-1,0,"YES",0,0,0,0,0,0,0]
[69,"01 Flooding of road surface (assuming no traffic is possible)","01-2 pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Preventive information","All road infrastructure","Research","Research ","Response","TEN-T - national - regional",2,2,2,-1,1,"YES",2,0,0,0,0,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,48]
[70,"01 Flooding of road surface (assuming no traffic is possible)","01-2 pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Real time traffic information","All road infrastructure","Traffic management","Traffic management","Response","TEN-T - national - regional",2,2,2,-1,1,"YES",2,0,0,0,0,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,48]
[71,"01 Flooding of road surface (assuming no traffic is possible)","01-2 pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Real time weather and traffic forecast","All road infrastructure","Traffic management","Traffic management","Response","TEN-T - national - regional",2,2,2,-1,1,"YES",2,0,0,0,0,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,48]
[72,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Rebuild stretches of the road on safe ground","All road infrastructure","Prevention","Robust construction","Prevention","Stretch",1,1,-1,-2,-1,"NO",-2,-2,-2,-1,-2,0,0]
[73,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Remove large obstructions (such as fallen trees or rubbish which restrict flow","Drainage of earthworks and pavements, sewers","Corrective maintenance and replacement","Maintenance and replacement","Preparation","Object",3,2,0,1,1,"YES",1,0,1,-1,0,0,1]
[74,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Remove recent accumulations of debris which create obstructions to flow","Drainage of earthworks and pavements, sewers","Corrective maintenance and replacement","Maintenance and replacement","Preparation","Object",2,1,0,-1,1,"YES",2,0,0,0,0,0,0]
[75,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Reroute the traffic","Mobility services","Extreme event management","Traffic management","Response","Stretch - network",2,0,-3,-2,1,"NO",0,-2,-3,0,-1,0,0]
[76,"01 Flooding of road surface (assuming no traffic is possible)","01-2 pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Rerouting and guidance","Mobility services","Extreme event management","Traffic management","Response","TEN-T - national - regional",2,2,2,-1,1,"YES",2,0,0,0,0,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,47]
[77,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Resize drainage systems to meet threats","Drainage of earthworks and pavements, sewers","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch - network",3,1,-1,-2,2,"YES",-1,0,2,-1,-1,0,0,null,null,47]
[78,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Reviewing design storm return periods in the light of new weather information","Drainage of earthworks and pavements, sewers","Monitoring and prediction","Monitoring","Pro-action","Regional network",1,0,0,-1,2,"YES",1,0,0,0,0,1,2,null,"Apply to all flooding",47]
[79,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Revised standards for road design, avoiding buildup of water level differences","All road infrastructure","Prevention","Legislation , regulations","Preparation","Object - stretch - network",1,0,1,-1,0,"NO",2,0,0,0,1,0,0,null,null,14]
[80,"01 Flooding of road surface (assuming no traffic is possible)","01-2 pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Speed limits","Mobility services","Extreme event management","Traffic management","Response","Stretch",2,3,0,-1,-1,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","Only for limited flooding"]
[81,"01 Flooding of road surface (assuming no traffic is possible)","01-2 pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Use geosynthetics for improving slope stability and erosion protection","Geotechnics, including landslips and rock falls, cuts","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",2,0,1,-2,0,"NO",2,0,0,0,1,0,0]
[82,"01 Flooding of road surface (assuming no traffic is possible)","01-2 pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Use vegetation for improving slope stability and erosion protection","Geotechnics, including landslips and rock falls, cuts","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",2,0,1,-2,0,"YES",2,0,0,2,1,0,0]
[83,"01 Flooding of road surface (assuming no traffic is possible)","01-2 Pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$error":"#NAME?"},"Wetland restoration as part of a strategy of multiply lines of flood defences","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","Regional network",1,1,0,-2,2,"YES",0,1,2,3,0,2,0,null,null,"#"]
[84,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Access restriction","Mobility services","Extreme event management","Traffic management","Response","Stretch",2,0,-2,2,-1,"YES",2,2,1,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures "]
[85,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Carrying out risk assessment of  identified areas","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",1,2,1,-2,2,"YES",-2,-1,1,0,0,0,0,null,null,47]
[86,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Construction of (temporary) flood barriers along road","All road infrastructure","Extreme event management","Robust construction","Response","Stretch",2,1,1,-2,1,"NO",0,0,0,0,0,0,1,null,null,"-"]
[87,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Develop plans and routines for the priority of securing areas prone to flooding","All road infrastructure","Pro-active attitude","Planning","Pro-action","Regional network",1,2,-1,-1,2,"YES",0,0,0,0,0,0,0,null,null,47]
[88,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Drainage of road embankment for fast lowering of groundwater table after flood retreats","Drainage of earthworks and pavements, sewers","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",1,0,0,-1,1,"YES",-2,-1,-1,-1,0,0,0]
[89,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Elevated roads above High Water Level","All road infrastructure","Prevention","Robust construction","Prevention","Stretch - network",2,2,2,-3,1,"NO",2,0,0,0,-2,0,2,null,null,1]
[90,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Inspect and clean drainage systems regularly","Drainage of earthworks and pavements, sewers","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Object",3,2,0,2,2,"YES",-1,0,1,0,0,0,0,null,null,47]
[91,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Install sign posts warning for flooding in threatened areas","Mobility services","Traffic management","Traffic management","Preparation","Object - stretch - network",3,2,-1,-1,0,"NO",0,0,0,0,0,0,0]
[92,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Integration of infrastructure development and land use planning ","All road infrastructure","Pro-active attitude","Planning","Pro-action","Regional network",2,2,2,2,1,"YES",2,0,0,2,2,0,2,null,"Applies to all threats",10]
[93,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Keeping in-house GIS up to date","All road infrastructure","Pro-active attitude","Planning","Pro-action","Regional network",3,2,0,-1,2,"YES",-1,0,0,0,0,0,0,null,null,47]
[94,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Keeping records of flooding events and locations","All road infrastructure","Monitoring and prediction","Monitoring","Pro-action","Regional network",2,1,0,-1,1,"YES",-2,0,0,0,0,0,0,null,"Applies to all threats",47]
[95,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Lane closure","All road infrastructure","Extreme event management","Traffic management","Response","Stretch",-2,3,0,-2,-2,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","If a traffic lane still available"]
[96,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Make strategies for temporary rerouting","Mobility services","Pro-active attitude","Planning","Prevention","Regional network",3,1,2,-1,2,"YES",-2,-1,-1,0,0,-1,0]
[97,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Mangroves restoration to reduce wave run-up and shore erosion","All road infrastructure","Pro-active attitude","Robust construction","Pro-action","Regional network",1,0,0,1,1,"YES",-1,2,2,3,2,1,2,null,null,"#"]
[98,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Mapping areas prone to flooding (Blue spot analysis)","All road infrastructure","Monitoring and prediction","Monitoring","Pro-action","Regional network",2,1,0,-1,2,"YES",-1,0,0,0,0,0,0,null,null,47]
[99,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Physical reinforcement of the coast line to protect against wave action","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","Object - stretch",2,0,0,-2,-1,"NO",1,0,-3,-3,-2,-1,0]
[100,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Prepare and educate road users for flooding","All road infrastructure","Capacity building","Capacity building","Pro-action","Object - stretch - network",0,2,2,-1,2,"YES",2,2,2,0,1,0,2,null,null,26]
[101,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Prepare and educate staff for flooding","All road infrastructure","Capacity building","Capacity building","Pro-action","Object - stretch - network",0,1,2,-1,0,"YES",2,0,0,0,1,0,1,null,null,26]
[102,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Prepare contingency / emergency plans","All road infrastructure","Pro-active attitude","Planning","Pro-action","Regional network",0,3,1,0,-1,"YES",2,0,0,0,0,0,2,null,null,47]
[103,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Prepare Traffic Management Plans","Mobility services","Traffic management","Traffic management","Prevention","TEN-T - national - regional",2,1,3,-1,2,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures "]
[104,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Preventive information","All road infrastructure","Research","Research ","Response","TEN-T - national - regional",2,2,2,-1,1,"YES",2,0,0,0,0,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,48]
[105,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Rebuild stretches of the road on safe ground","All road infrastructure","Prevention","Robust construction","Prevention","Stretch",1,1,-1,-2,-1,"NO",-2,-2,-2,-1,-2,0,0]
[106,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Relocation of road","All road infrastructure","Prevention","Robust construction","Prevention","Stretch - network",2,2,2,-3,2,"NO",2,0,0,0,0,0,2,null,null,"-"]
[107,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Reroute the traffic","Mobility services","Extreme event management","Traffic management","Response","Stretch - network",2,0,-3,-2,1,"NO",0,-2,-3,0,-1,0,0]
[108,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Rerouting and guidance","Mobility services","Extreme event management","Traffic management","Response","TEN-T - national - regional",2,0,3,-2,-1,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures "]
[109,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Resize drainage systems to meet threats","Drainage of earthworks and pavements, sewers","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch - network",3,1,-1,-2,2,"YES",-1,0,2,-1,-1,0,0,null,null,47]
[110,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Reviewing design storm return periods in the light of new weather information","All road infrastructure","Monitoring and prediction","Monitoring","Preparation","Regional network",0,0,0,0,0,"YES",0,0,0,0,0,0,0,null,"Apply to all flooding",47]
[111,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Revised standards for road design, avoiding buildup of water level differences","All road infrastructure","Prevention","Legislation , regulations","Preparation","Object - stretch - network",1,0,1,-1,0,"NO",2,0,0,0,1,0,0,null,null,14]
[112,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Sand nourishment to reduce wave run-up and shore erosion","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","Regional network",1,0,0,2,1,"YES",-2,-1,1,-1,-2,0,0,null,null,"#"]
[113,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Shelter locations with facilities and life supplies, evacuation routes","All road infrastructure","Prevention","Resilient construction","Preparation","Regional network",0,3,0,-2,2,"NO",2,0,0,0,0,0,2,null,null,1]
[114,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Speed limits","Mobility services","Extreme event management","Traffic management","Response","Stretch",2,3,0,-1,-1,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","Only for limited flooding"]
[115,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Use geosynthetics for improving slope stability and erosion protection","Geotechnics, including landslips and rock falls, cuts","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",2,0,1,-2,0,"NO",2,0,0,0,1,0,0]
[116,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Use vegetation for improving slope stability and erosion protection","Geotechnics, including landslips and rock falls, cuts","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",2,0,1,-2,0,"YES",2,0,0,2,1,0,0]
[117,"01 Flooding of road surface (assuming no traffic is possible)","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$error":"#NAME?"},"Wetland restoration as part of a strategy of multiply lines of flood defences","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","Regional network",1,1,0,-2,2,"YES",0,1,2,3,0,2,0,null,null,"#"]
[118,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Access restriction","Mobility services","Extreme event management","Traffic management","Response","Stretch",2,0,-2,2,-1,"YES",2,2,1,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures "]
[119,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Build flood walls to protect the road from flooding","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","National network",2,1,0,-2,-1,"YES",-1,-1,2,-2,-1,-1,0,null,null,47]
[120,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Carrying out risk assessment of  identified areas ","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",1,2,1,-2,2,"YES",-2,-1,1,0,0,0,0,null,null,47]
[121,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Cleaning out watercourses and structures of flood prone areas ahead of predicted snow melt","Drainage of earthworks and pavements, sewers","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Object - stretch",3,2,0,-1,2,"YES",-2,0,1,1,0,0,0,null,null,47]
[122,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Clear natural blockages such as shrubs and weeds","Drainage of earthworks and pavements, sewers","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Object",1,0,-1,2,-1,"YES",0,1,0,0,1,0,0]
[123,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Construct detention storages ","Drainage of earthworks and pavements, sewers","Pro-active attitude","Robust construction","Pro-action","Object - stretch - network",2,0,0,-1,2,"YES",1,0,0,2,-1,0,0,null,null,55]
[124,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Develop plans and routines for the priority of securing areas prone to flooding","All road infrastructure","Pro-active attitude","Planning","Pro-action","Regional network",1,2,-1,-1,2,"YES",0,0,0,0,0,0,0,null,null,47]
[125,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Drainage of road embankment for fast lowering of groundwater table after flood retreats","Drainage of earthworks and pavements, sewers","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",1,0,0,-1,1,"YES",-2,-1,-1,-1,0,0,0]
[126,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Dredge to increase depths and/or straighten the stream","All road infrastructure","Pro-active attitude","Robust construction","Pro-action","National network",1,-1,0,-1,-1,"YES",-2,-1,1,-2,0,0,0,null,null,56]
[127,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Inspect blue spots areas adjacent to snow melt","Drainage of earthworks and pavements, sewers","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Regional network",2,1,0,-1,1,"YES",-2,0,0,0,0,0,0,null,null,57]
[128,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Inspect watercourses regularly","Drainage of earthworks and pavements, sewers","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Regional network",2,1,0,-1,1,"YES",-2,0,0,0,0,0,0,null,null,55]
[129,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$f":"VLOOKUP(C131,climate_par_table,2)","v":{"$error":"#NAME?"}},"Install sign posts warning for flooding in threatened areas","Mobility services","Traffic management","Traffic management","Preparation","Object - stretch - network",3,2,-1,-1,0,"NO",0,0,0,0,0,0,0]
[130,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Keeping in-house GIS up to date","All road infrastructure","Pro-active attitude","Planning","Pro-action","Regional network",3,2,0,-1,2,"YES",-1,0,0,0,0,0,0,null,null,47]
[131,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Keeping records of flooding events and locations","All road infrastructure","Monitoring and prediction","Monitoring","Pro-action","Regional network",2,1,0,-1,1,"YES",-2,0,0,0,0,0,0,null,"Applies to all threats",47]
[132,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Make strategies for temporary rerouting","Mobility services","Pro-active attitude","Planning","Prevention","Regional network",3,1,2,-1,2,"YES",-2,-1,-1,0,0,-1,0]
[133,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Mapping areas prone to flooding (Blue spot analysis)","All road infrastructure","Monitoring and prediction","Monitoring","Pro-action","Regional network",2,1,0,-1,2,"YES",-1,0,0,0,0,0,0,null,null,47]
[134,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Prepare and educate road users for flooding","All road infrastructure","Capacity building","Capacity building","Pro-action","Object - stretch - network",0,2,2,-1,2,"YES",2,2,2,0,1,0,2,null,null,26]
[135,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Prepare and educate staff for flooding","All road infrastructure","Capacity building","Capacity building","Pro-action","Object - stretch - network",0,1,2,-1,0,"YES",2,0,0,0,1,0,1,null,null,26]
[136,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Prepare contingency / emergency plans","All road infrastructure","Pro-active attitude","Planning","Pro-action","National network",3,2,-1,-1,2,"YES",0,0,0,0,0,0,0,null,"Applies to all threats"]
[137,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Preventive information","All road infrastructure","Research","Research ","Response","TEN-T - national - regional",2,2,2,-1,1,"YES",2,0,0,0,0,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,48]
[138,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Rebuild stretches of the road on safe ground","All road infrastructure","Prevention","Robust construction","Prevention","Stretch",1,1,-1,-2,-1,"NO",-2,-2,-2,-1,-2,0,0]
[139,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Remove large obstructions (such as fallen trees or rubbish which restrict flow","Drainage of earthworks and pavements, sewers","Corrective maintenance and replacement","Maintenance and replacement","Preparation","Object",3,2,0,1,1,"YES",1,0,1,-1,0,0,1]
[140,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Remove recent accumulations of debris and ice which create obstructions to flow","Drainage of earthworks and pavements, sewers","Corrective maintenance and replacement","Maintenance and replacement","Preparation","Object",2,1,0,-1,1,"YES",2,0,0,0,0,0,0]
[141,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Remove snow and ice from the road","Drainage of earthworks and pavements, sewers","Corrective maintenance and replacement","Maintenance and replacement","Preparation","National network",2,1,1,-1,2,"YES",-2,-1,2,-1,0,0,0]
[142,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Reroute the traffic","Mobility services","Extreme event management","Traffic management","Response","Stretch - network",2,0,-3,-2,1,"NO",0,-2,-3,0,-1,0,0]
[143,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Resize drainage systems to meet threats","Drainage of earthworks and pavements, sewers","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch - network",3,1,-1,-2,2,"YES",-1,0,2,-1,-1,0,0,null,null,47]
[144,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Reviewing design storm return periods in the light of new weather information","Drainage of earthworks and pavements, sewers","Monitoring and prediction","Monitoring","Pro-action","Regional network",1,0,0,-1,2,"YES",1,0,0,0,0,1,2,null,"Apply to all flooding",47]
[145,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Use geosynthetics for improving slope stability and erosion protection","Geotechnics, including landslips and rock falls, cuts","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",2,0,1,-2,0,"NO",2,0,0,0,1,0,0]
[146,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Use vegetation for improving slope stability and erosion protection","Geotechnics, including landslips and rock falls, cuts","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",2,0,1,-2,0,"YES",2,0,0,2,1,0,0]
[147,"01 Flooding of road surface (assuming no traffic is possible)","01-4 Flooding from snow melt (overland flow after snow melt)",{"$error":"#NAME?"},"Wetland restoration as part of a strategy of multiply lines of flood defences","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","Regional network",1,1,0,-2,2,"YES",0,1,2,3,0,2,0,null,null,"#"]
[148,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Avoid deforestation in the catchment area","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Resilient construction","Pro-action","Object - stretch - network",3,1,0,-1,2,"YES",0,3,3,3,0,2,2]
[149,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Avoid urbanisation and watersheds diversions in vulnerable areas","All road infrastructure","Pro-active attitude","Planning","Pro-action","Object - stretch",3,1,0,-1,0,"YES",0,2,-1,3,1,0,0]
[150,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Build dams, reservoirs and retaining ponds to buffer the water","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Resilient construction","Pro-action","Object - stretch - network",2,0,0,-1,2,"YES",1,0,0,2,-1,0,0]
[151,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Build flood walls to protect the road from flooding","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","National network",2,1,0,-2,-1,"YES",-1,-1,2,-2,-1,-1,0,null,null,47]
[152,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Carriageway cross-over","All road infrastructure","Traffic management","Traffic management","Response","Stretch",-2,-1,0,-2,-2,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","If dual carriageway "]
[153,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Carrying out risk assessment of  identified areas","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",1,2,1,-2,2,"YES",-2,-1,1,0,0,0,0,null,null,47]
[154,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Cleaning out watercourses and structures of flood prone areas ahead of predicted heavy rainfall","Drainage of earthworks and pavements, sewers","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Object - stretch",3,2,0,-1,2,"YES",-2,0,1,1,0,0,0,null,null,47]
[155,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Clear natural blockages such as shrubs and weeds","Drainage of earthworks and pavements, sewers","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Object",1,0,-1,2,-1,"YES",0,1,0,0,1,0,0]
[156,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Cover road embankment with geotextile","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Prevention","Object - stretch",3,1,0,2,1,"NO",2,0,-1,-1,-1,-1,0,null,null,47]
[157,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Cover slope with rock blanket","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Prevention","Object - stretch",2,3,-1,2,2,"NO",2,-1,-1,-3,-3,0,0,null,null,47]
[158,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Cover slope with vegetation","Geotechnics, including landslips and rock falls, cuttings","Prevention","Resilient construction","Prevention","Regional network",3,2,1,-2,0,"YES",2,0,0,0,0,0,0]
[159,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Develop plans and routines for the priority of securing areas prone to overloaded hydraulic systems","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",1,2,-1,-1,2,"YES",0,0,0,0,0,0,0,null,null,47]
[160,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Dredge to increase depths and/or straighten the stream","All road infrastructure","Pro-active attitude","Robust construction","Pro-action","National network",1,-1,0,-1,-1,"YES",-2,-1,1,-2,0,0,0,null,null,56]
[161,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Establish a guideline for standardized inspection of culverts","Geotechnics, including landslips and rock falls, cuts","Preventive maintenance and replacement","Legislation , regulations","Pro-action","Object - stretch - network",3,1,1,-2,0,"YES",2,0,0,0,0,0,0]
[162,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Inspect and clean watercourses regularly","Geotechnics, including landslips and rock falls, cuts","Preventive maintenance and replacement","Maintenance and replacement","Prevention","Object",3,2,0,2,2,"YES",-1,0,1,0,0,0,0,null,null,47]
[163,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Inspect blue spots areas adjacent to heavy rainfalls","Drainage of earthworks and pavements, sewers","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Regional network",2,1,0,-1,1,"YES",-2,0,0,0,0,0,0,null,null,57]
[164,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Install sign posts warning for flooding in threatened areas","Mobility services","Traffic management","Traffic management","Preparation","Object - stretch - network",3,2,-1,-1,0,"NO",0,0,0,0,0,0,0]
[165,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Keeping in-house GIS up to date","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",3,1,0,0,1,"YES",-1,0,0,0,0,0,0,null,null,47]
[166,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Keeping records of  events and locations of overloaded hydraulic systems","All road infrastructure","Pro-active attitude","Planning","Pro-action","Regional network",2,1,0,-1,1,"YES",-2,0,0,0,0,0,0,null,"Applies to all threats",47]
[167,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Keeping records of flooding events and locations","All road infrastructure","Monitoring and prediction","Monitoring","Pro-action","Regional network",2,1,0,-1,1,"YES",-2,0,0,0,0,0,0,null,"Applies to all threats",47]
[168,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Lane closure","All road infrastructure","Traffic management","Traffic management","Response","Stretch",-2,3,0,-2,-2,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","If a traffic lane still available"]
[169,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Make strategies for temporary rerouting","Geotechnics, including landslips and rock falls, cuts","Traffic management","Planning","Prevention","Regional network",3,1,2,-1,2,"YES",-2,-1,-1,0,0,-1,0]
[170,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Mapping areas prone to flooding (Blue spot analysis)","All road infrastructure","Monitoring and prediction","Monitoring","Pro-action","Regional network",2,1,0,-1,2,"YES",-1,0,0,0,0,0,0,null,null,47]
[171,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Modal shift","Mobility services","Extreme event management","Traffic management","Response","TEN-T - national - regional",2,2,2,-1,1,"YES",2,0,0,0,0,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,48]
[172,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Organize weirs/overflow towards storage facilities","Drainage of earthworks and pavements, sewers","Pro-active attitude","Resilient construction","Pro-action","Object - stretch - network",3,3,2,-2,0,"YES",2,0,0,0,0,0,0]
[173,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Pave the inlet and the outlet of the culvert","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Prevention","Object - stretch",2,3,-1,-2,2,"NO",2,-1,-1,-3,-3,0,0,null,null,49]
[174,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Prepare and educate road users for flooding","All road infrastructure","Capacity building","Capacity building","Pro-action","Object - stretch - network",0,2,2,-1,2,"YES",2,2,2,0,1,0,2,null,null,26]
[175,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Prepare and educate staff for flooding","All road infrastructure","Capacity building","Capacity building","Pro-action","Object - stretch - network",0,1,2,-1,0,"YES",2,0,0,0,1,0,1,null,null,26]
[176,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Prepare Traffic Management Plans","All road infrastructure","Traffic management","Traffic management","Prevention","TEN-T - national - regional",2,1,3,-1,2,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures "]
[177,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Protect entrance  embankment  with rock blanket ","Geotechnics, including landslips and rock falls, cuttings","Prevention","Robust construction","Prevention","Object",2,1,0,-1,0,"NO",-1,-1,-1,-1,-1,0,0]
[178,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Protect entrance against floating debris","Geotechnics, including landslips and rock falls, cuttings","Prevention","Robust construction","Prevention","Object",2,1,0,-1,0,"NO",-1,-1,-1,-1,-1,0,0]
[179,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Real time traffic information","All road infrastructure","Traffic management","Traffic management","Response","TEN-T - national - regional",2,2,2,-1,1,"YES",2,0,0,0,0,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,48]
[180,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Real time weather and traffic forecast","All road infrastructure","Traffic management","Traffic management","Response","TEN-T - national - regional",2,2,2,-1,1,"YES",2,0,0,0,0,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,48]
[181,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Rebuild stretches of the road on safe ground","All road infrastructure","Prevention","Robust construction","Prevention","Stretch",1,1,-1,-2,-1,"NO",-2,-2,-2,-1,-2,0,0]
[182,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Replace the culvert with a small bridge","Drainage of earthworks and pavements, sewers","Upgrade / retrofitting / new construction","Resilient construction","Prevention","Object",2,1,0,-2,0,"NO",-1,-1,-1,-1,-1,0,0]
[183,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Reroute the traffic","Geotechnics, including landslips and rock falls, cuts","Extreme event management","Traffic management","Response","Stretch - network",2,0,-3,-2,1,"NO",0,-2,-3,0,-1,0,0]
[184,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Rerouting and guidance","All road infrastructure","Traffic management","Traffic management","Response","TEN-T - national - regional",2,0,3,-2,-1,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures "]
[185,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Resize drainage systems to meet threats","Drainage of earthworks and pavements, sewers","Upgrade / retrofitting / new construction","Resilient construction","Pro-action","Object - stretch - network",3,1,-1,-2,2,"YES",-1,0,2,-1,-1,0,0,null,null,47]
[186,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Reviewing design storm return periods in the light of new weather information","Drainage of earthworks and pavements, sewers","Monitoring and prediction","Monitoring","Pro-action","Regional network",1,0,0,-1,2,"YES",1,0,0,0,0,1,2,null,"Apply to all flooding",47]
[187,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Revised standards for design of culverts","Geotechnics, including landslips and rock falls, cuttings","Prevention","Legislation , regulations","Preparation","National network",1,2,0,-2,0,"NO",2,0,0,0,1,0,1]
[188,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Revised standards for road design, avoiding buildup of water level differences","All road infrastructure","Prevention","Legislation , regulations","Preparation","Object - stretch - network",1,0,1,-1,0,"NO",2,0,0,0,1,0,0,null,null,14]
[189,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Speed limits","All road infrastructure","Traffic management","Traffic management","Response","Stretch",2,3,0,-1,-1,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","Only for limited flooding"]
[190,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Take measures to reduce downstream sedimentation and clean debris and sediment from the outlet ditch afterwards.","Geotechnics, including landslips and rock falls, cuts","Prevention","Maintenance and replacement","Pro-action","Object",2,1,0,-2,1,"NO",2,-1,-1,-3,-3,0,0,null,null,49]
[191,"02 Erosion of road embankments and foundations","02-1 Overloading of hydraulic systems crossing the road",{"$error":"#NAME?"},"Wetland restoration as part of a strategy of multiply lines of flood defences","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","Regional network",1,1,0,-2,2,"YES",0,1,2,3,0,2,0,null,null,"#"]
[192,"02 Erosion of road embankments and foundations","02-2 Erosion of road bases",{"$error":"#NAME?"},"Build flood walls to protect the road from flooding","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","National network",2,1,0,-2,-1,"YES",-1,-1,2,-2,-1,-1,0,null,null,47]
[193,"02 Erosion of road embankments and foundations","02-2 Erosion of road bases",{"$f":"VLOOKUP(C195,climate_par_table,2)","v":{"$error":"#NAME?"}},"Carrying out risk assessment of  identified areas","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",1,2,1,-2,2,"YES",-2,-1,1,0,0,0,0,null,null,47]
[194,"02 Erosion of road embankments and foundations","02-2 Erosion of road bases",{"$error":"#NAME?"},"Cleaning out watercourses and structures of flood prone areas ahead of predicted heavy rainfall","Drainage of earthworks and pavements, sewers","Prevention","Planning","Preparation","Object - stretch",3,2,0,-1,2,"YES",-2,0,1,1,0,0,0,null,null,47]
[195,"02 Erosion of road embankments and foundations","02-2 Erosion of road bases",{"$error":"#NAME?"},"Construct detention storages ","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Resilient construction","Pro-action","Object - stretch - network",2,0,0,-1,2,"YES",1,0,0,2,-1,0,0,null,null,55]
[196,"02 Erosion of road embankments and foundations","02-2 Erosion of road bases",{"$error":"#NAME?"},"Cover road embankment with geotextile","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Prevention","Object - stretch",3,1,0,2,1,"NO",2,0,-1,-1,-1,-1,0,null,null,47]
[197,"02 Erosion of road embankments and foundations","02-2 Erosion of road bases",{"$error":"#NAME?"},"Cover slope with rock blanket","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Prevention","Object - stretch",2,3,-1,2,2,"NO",2,-1,-1,-3,-3,0,0,null,null,47]
[198,"02 Erosion of road embankments and foundations","02-2 Erosion of road bases",{"$error":"#NAME?"},"Cover slope with vegetation","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Prevention","Object - stretch",3,1,0,-1,1,"YES",-1,1,0,2,1,0,0,null,null,15]
[199,"02 Erosion of road embankments and foundations","02-2 Erosion of road bases",{"$error":"#NAME?"},"Cover the road embankment with hard protection to reduce wave action","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Prevention","Object - stretch",2,3,-1,2,2,"NO",2,-1,-1,-3,-3,0,0,null,null,47]
[200,"02 Erosion of road embankments and foundations","02-2 Erosion of road bases",{"$error":"#NAME?"},"Develop plans and routines for the priority of securing areas prone to be affected by sea level rise","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",1,2,-1,-1,2,"YES",0,0,0,0,0,0,0,null,null,47]
[201,"02 Erosion of road embankments and foundations","02-2 Erosion of road bases",{"$error":"#NAME?"},"Flatten the road embankment","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Prevention","Object - stretch",1,1,0,-1,1,"NO",3,0,-1,0,0,0,0]
[202,"02 Erosion of road embankments and foundations","02-2 Erosion of road bases",{"$error":"#NAME?"},"Inspect watercourses regularly","Drainage of earthworks and pavements, sewers","Preventive maintenance and replacement","Maintenance and replacement","Prevention","Regional network",2,1,0,-1,1,"YES",-2,0,0,0,0,0,0,null,null,55]
[203,"02 Erosion of road embankments and foundations","02-2 Erosion of road bases",{"$error":"#NAME?"},"Install or raise the level of existing protecting wall outside the road","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Pro-action","Object - stretch",1,1,0,-2,0,"NO",1,0,0,-1,-1,0,0]
[204,"02 Erosion of road embankments and foundations","02-2 Erosion of road bases",{"$error":"#NAME?"},"Keeping in-house GIS up to date","All road infrastructure","Pro-active attitude","Planning","Pro-action","Regional network",3,2,0,-1,2,"YES",-1,0,0,0,0,0,0,null,null,47]
[205,"02 Erosion of road embankments and foundations","02-2 Erosion of road bases",{"$error":"#NAME?"},"Keeping records of flooding events and locations","All road infrastructure","Pro-active attitude","Planning","Pro-action","Regional network",2,1,0,-1,1,"YES",-2,0,0,0,0,0,0,null,"Applies to all threats",47]
[206,"02 Erosion of road embankments and foundations","02-2 Erosion of road bases",{"$error":"#NAME?"},"Make strategies for temporary rerouting","Geotechnics, including landslips and rock falls, cuts","Traffic management","Planning","Prevention","Regional network",3,1,2,-1,2,"YES",-2,-1,-1,0,0,-1,0]
[207,"02 Erosion of road embankments and foundations","02-2 Erosion of road bases",{"$error":"#NAME?"},"Mapping areas prone to flooding (Blue spot analysis)","All road infrastructure","Pro-active attitude","Planning","Pro-action","Regional network",2,1,0,-1,2,"YES",-1,0,0,0,0,0,0,null,null,47]
[208,"02 Erosion of road embankments and foundations","02-2 Erosion of road bases",{"$error":"#NAME?"},"Rebuild stretches of the road on safe ground","Geotechnics, including landslips and rock falls, cuts","Upgrade / retrofitting / new construction","Maintenance and replacement","Response","Stretch",1,1,-1,-2,-1,"NO",-2,-2,-2,-1,-2,0,0]
[209,"02 Erosion of road embankments and foundations","02-2 Erosion of road bases",{"$error":"#NAME?"},"Reroute the traffic","Geotechnics, including landslips and rock falls, cuts","Extreme event management","Traffic management","Response","Stretch - network",2,0,-3,-2,1,"NO",0,-2,-3,0,-1,0,0]
[210,"02 Erosion of road embankments and foundations","02-2 Erosion of road bases",{"$error":"#NAME?"},"Resize drainage systems to meet threats","Drainage of earthworks and pavements, sewers","Upgrade / retrofitting / new construction","Maintenance and replacement","Pro-action","Object - stretch - network",3,1,-1,-2,2,"YES",-1,0,2,-1,-1,0,0,null,null,47]
[211,"02 Erosion of road embankments and foundations","02-2 Erosion of road bases",{"$error":"#NAME?"},"Reviewing design storm return periods in the light of new weather information","Drainage of earthworks and pavements, sewers","Research","Research ","Pro-action","Regional network",1,0,0,-1,2,"YES",1,0,0,0,0,1,2,null,"Apply to all flooding",47]
[212,"02 Erosion of road embankments and foundations","02-2 Erosion of road bases",{"$error":"#NAME?"},"Vegetation along the slope of the road embankment to reduce wave action and stream velocity","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Prevention","Regional network",1,1,0,-1,1,"YES",-1,1,0,1,0,0,0,null,null,15]
[213,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Check dams - installing sills or drop structures","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Resilient construction","Pro-action","Object - stretch",2,0,0,-2,1,"YES",0,-1,1,1,2,0,0,null,null,49]
[214,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Cleaning out watercourses and structures of flood prone areas ahead of predicted heavy rainfall","Drainage of earthworks and pavements, sewers","Prevention","Planning","Preparation","Object - stretch",3,2,0,-1,2,"YES",-2,0,1,1,0,0,0,null,null,47]
[215,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Dredge the channel to increase the width and/or depth","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Prevention","Object - stretch",3,1,-2,-2,-1,"YES",-1,0,-1,-2,0,-1,0,null,null,49]
[216,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Extend the footing to support the slope or protect it from erosion","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Prevention","Object",2,1,0,-1,1,"NO",2,0,0,-1,-1,0,0,null,null,49]
[217,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Increase span/relief bridge","Geotechnics, including landslips and rock falls, cuts","Upgrade / retrofitting / new construction","Robust construction","Prevention","Object",1,1,1,-3,1,"NO",3,-1,1,0,-1,0,0]
[218,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Inspect bridge foundations and surroundings (over and under water) regularly","Geotechnics, including landslips and rock falls, cuts","Preventive maintenance and replacement","Maintenance and replacement","Prevention","Object",3,2,0,2,2,"YES",-1,0,1,0,0,0,0]
[219,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Install a bulkhead to support the slope and protect it from erosion","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Prevention","Object",2,2,-1,-2,2,"NO",2,-1,-1,-3,-3,0,0,null,null,49]
[220,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Install debris basins to collect debris","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Preparation","Object",2,1,0,-1,0,"NO",2,-1,-1,-3,-3,0,0,null,null,49]
[221,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Install flexible revetment as artifical armoring","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Prevention","Object",0,1,0,1,0,"NO",1,0,-1,-1,0,-1,0,null,null,49]
[222,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Install flow deflecting plates to deflect flow","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Prevention","Object",-1,0,0,1,0,"NO",-1,0,-1,-1,-1,-1,0,null,null,49]
[223,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Install jetties to support the slope or protect bank from erosion","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Prevention","Object - stretch",2,3,-1,-2,2,"NO",2,-1,-1,-3,-3,0,0,null,null,49]
[224,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Install vanes upstreams to reduce flow","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Prevention","Object",-1,0,0,1,0,"YES",-1,0,0,-1,-1,0,0,null,null,49]
[225,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Keeping in-house GIS up to date","All road infrastructure","Pro-active attitude","Planning","Pro-action","Regional network",3,2,0,-1,2,"YES",-1,0,0,0,0,0,0,null,null,47]
[226,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Make strategies for temporary rerouting","Geotechnics, including landslips and rock falls, cuts","Traffic management","Planning","Prevention","Regional network",3,1,2,-1,2,"YES",-2,-1,-1,0,0,-1,0]
[227,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Plant vegetation to prevent bank erosion","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Prevention","Object - stretch",2,1,0,-1,1,"YES",1,1,2,3,0,2,1,null,null,49]
[228,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Protect  foundation and surroundings with gabions/ reno mattress","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Pro-action","Object",2,3,-1,-2,2,"NO",2,-1,-1,-3,-3,0,0,null,null,49]
[229,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Protect foundations and surroundings with bituminous concrete pavement","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Pro-action","Object",2,3,-1,-2,2,"NO",2,-1,-1,-3,-3,0,0,null,null,49]
[230,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Protect foundations and surroundings with fabric bags filled with concrete and stacked to produce a protective layer","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Pro-action","Object",2,2,-1,-2,-2,"NO",-1,-1,-1,-3,-3,-1,0,null,null,49]
[231,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Protect foundations and surroundings with guide banks (spurs/dyke)","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Pro-action","Object",2,3,-1,-2,2,"NO",2,-1,-1,-3,-3,0,0,null,null,49]
[232,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Protect foundations and surroundings with rock or gravel blankets","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Pro-action","Object",2,3,-1,-2,2,"NO",2,-1,-1,-3,-3,0,0,null,null,49]
[233,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Protect foundations or surroundings with artificial riprap or tetrapods /toskanes","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Pro-action","Object",2,3,-1,-2,2,"NO",2,-1,-1,-3,-3,0,0,null,null,49]
[234,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Protect foundations or surroundings with cable-tied blocks","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Pro-action","Object",2,3,-1,-2,2,"NO",2,-1,-1,-3,-3,0,0,null,null,49]
[235,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Protect foundations or surroundings with concrete grouted riprap","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Pro-action","Object",2,3,-1,-2,2,"NO",2,-1,-1,-3,-3,0,0,null,null,49]
[236,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Protect foundations or surroundings with precast concrete blocks with retard (timber & sheet piles) ","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Pro-action","Object",2,3,-1,-2,2,"NO",2,-1,-1,-3,-3,0,0,null,null,49]
[237,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Protect foundations or surroundings with sacrificial piles upstream to reduce velocity","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Pro-action","Object",0,1,0,-1,0,"NO",1,0,-1,-3,-3,0,0,null,null,49]
[238,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Protect foundations with structures that dissipate energy in the water","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Pro-action","Object",0,1,0,-1,0,"NO",1,0,-1,-3,-3,0,0,null,null,49]
[239,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Reroute the traffic","Geotechnics, including landslips and rock falls, cuts","Extreme event management","Traffic management","Response","Stretch - network",2,0,-3,-2,1,"NO",0,-2,-3,0,-1,0,0]
[240,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Rerouting and guidance","All road infrastructure","Traffic management","Traffic management","Response","TEN-T - national - regional",2,0,3,-2,-1,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures "]
[241,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Resize drainage systems to meet threats","Drainage of earthworks and pavements, sewers","Upgrade / retrofitting / new construction","Maintenance and replacement","Pro-action","Object - stretch - network",3,1,-1,-2,2,"YES",-1,0,2,-1,-1,0,0,null,null,47]
[242,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Reviewing design storm return periods in the light of new weather information","Drainage of earthworks and pavements, sewers","Research","Research ","Pro-action","Regional network",1,0,0,-1,2,"YES",1,0,0,0,0,1,2,null,"Apply to all flooding",47]
[243,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Stabilize the slope with soil cement","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Prevention","Object - stretch",3,2,0,-2,1,"NO",2,-1,-1,-3,-3,0,0,null,null,49]
[244,"02 Erosion of road embankments and foundations","02-3 Bridge scour",{"$error":"#NAME?"},"Underpinning to stengthening the columns","Geotechnics, including landslips and rock falls, cuts","Upgrade / retrofitting / new construction","Robust construction","Response","Object",2,2,0,-3,1,"NO",2,0,0,0,0,0,0,null,null,49]
[245,"03 Landslips and avalanches","03-1 External slides affecting the road",{"$error":"#NAME?"},"Assess the risk of landslides based on pore pressure","Geotechnics, including landslips and rock falls, cuts","Research","Research ","Pro-action","National network",-3,-1,0,-2,-1,"YES",0,0,1,0,0,0,0,null,null,47]
[246,"03 Landslips and avalanches","03-1 External slides affecting the road",{"$error":"#NAME?"},"Avoid deforestation on slopes ","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Resilient construction","Pro-action","Object - stretch - network",3,1,0,-1,2,"YES",0,3,3,3,0,2,2]
[247,"03 Landslips and avalanches","03-1 External slides affecting the road",{"$error":"#NAME?"},"Carriageway cross-over","All road infrastructure","Traffic management","Traffic management","Response","Stretch",-2,-1,0,-2,-2,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","If dual carriageway "]
[248,"03 Landslips and avalanches","03-1 External slides affecting the road",{"$error":"#NAME?"},"Carrying out risk assessment of  identified areas","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",1,2,1,-2,2,"YES",-2,-1,1,0,0,0,0,null,null,47]
[249,"03 Landslips and avalanches","03-1 External slides affecting the road",{"$error":"#NAME?"},"Continuously measure the pore pressure in the slope ","Geotechnics, including landslips and rock falls, cuts","Monitoring and prediction","Monitoring","Pro-action","Object - stretch",3,1,0,-2,1,"YES",-2,0,0,0,0,0,0]
[250,"03 Landslips and avalanches","03-1 External slides affecting the road",{"$error":"#NAME?"},"Cover slope with rock blanket","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Prevention","Object",2,3,-1,2,2,"NO",2,-1,-1,-3,-3,0,0,null,null,47]
[251,"03 Landslips and avalanches","03-1 External slides affecting the road",{"$error":"#NAME?"},"Cover slope with vegetation","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Prevention","Object",3,1,0,-1,1,"YES",-1,1,0,2,1,0,0]
[252,"03 Landslips and avalanches","03-1 External slides affecting the road",{"$error":"#NAME?"},"Cutting back the slope to a shallower angle","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Prevention","Object",1,2,-1,-1,2,"YES",-1,0,-1,-1,0,0,0,null,null,47]
[253,"03 Landslips and avalanches","03-1 External slides affecting the road",{"$error":"#NAME?"},"Develop plans and routines for the priority of securing areas prone to landslides","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",1,2,-1,-1,2,"YES",0,0,0,0,0,0,0,null,null,47]
[254,"03 Landslips and avalanches","03-1 External slides affecting the road",{"$error":"#NAME?"},"Implement a system of geotechnical risk management","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Legislation , regulations","Pro-action","National network",2,1,0,1,1,"YES",-1,0,0,0,0,0,0,null,null,47]
[255,"03 Landslips and avalanches","03-1 External slides affecting the road",{"$error":"#NAME?"},"Implement a system of geotechnical risk management","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Legislation , regulations","Pro-action","National network",2,1,0,1,1,"YES",-1,0,0,0,0,0,0,null,null,47]
[256,"03 Landslips and avalanches","03-1 External slides affecting the road",{"$error":"#NAME?"},"Inspect and clean watercourses regularly","Drainage of earthworks and pavements, sewers","Preventive maintenance and replacement","Maintenance and replacement","Pro-action","Object - stretch - network",3,2,0,2,2,"YES",-1,0,1,0,0,0,0,null,null,47]
[257,"03 Landslips and avalanches","03-1 External slides affecting the road",{"$f":"VLOOKUP(C259,climate_par_table,2)","v":{"$error":"#NAME?"}},"Install erosion barriers soon after the wildfire","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","Object",3,2,0,-1,1,"YES",1,0,0,1,-1,1,1,null,null,50]
[258,"03 Landslips and avalanches","03-1 External slides affecting the road",{"$error":"#NAME?"},"Lane closure","All road infrastructure","Traffic management","Traffic management","Response","Stretch",-2,3,0,-2,-2,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","If a traffic lane still available"]
[259,"03 Landslips and avalanches","03-1 External slides affecting the road",{"$error":"#NAME?"},"Make strategies for temporary rerouting","Geotechnics, including landslips and rock falls, cuts","Traffic management","Planning","Pro-action","Regional network",3,1,2,-1,2,"YES",-2,-1,-1,0,0,-1,0]
[260,"03 Landslips and avalanches","03-1 External slides affecting the road",{"$error":"#NAME?"},"Mapping areas prone to landslides","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",2,1,0,-1,1,"YES",0,0,0,0,0,0,0,null,null,47]
[261,"03 Landslips and avalanches","03-1 External slides affecting the road",{"$error":"#NAME?"},"Mapping sites of occurred  landslides","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",0,0,0,0,0,"YES",0,0,0,0,0,0,0,null,null,47]
[262,"03 Landslips and avalanches","03-1 External slides affecting the road",{"$error":"#NAME?"},"Rebuild stretches of the road on safe ground","Geotechnics, including landslips and rock falls, cuts","Upgrade / retrofitting / new construction","Maintenance and replacement","Response","Stretch",1,1,-1,-2,-1,"NO",-2,-2,-2,-1,-2,0,0]
[263,"03 Landslips and avalanches","03-1 External slides affecting the road",{"$error":"#NAME?"},"Resize drainage systems to meet threats","Drainage of earthworks and pavements, sewers","Upgrade / retrofitting / new construction","Resilient construction","Pro-action","Object - stretch - network",3,1,-1,-2,2,"YES",-1,0,2,-1,-1,0,0,null,null,47]
[264,"03 Landslips and avalanches","03-1 External slides affecting the road",{"$error":"#NAME?"},"Spread mulch over the soil to protect it","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Pro-action","Object",3,1,0,-1,1,"YES",0,0,1,2,0,1,0,null,null,50]
[265,"03 Landslips and avalanches","03-1 External slides affecting the road",{"$error":"#NAME?"},"Stabilize the surrounding area","Geotechnics, including landslips and rock falls, cuts","Extreme event management","Robust construction","Recovery","Object",2,2,1,-2,2,"NO",-1,0,0,0,0,0,0]
[266,"03 Landslips and avalanches","03-1 External slides affecting the road",{"$error":"#NAME?"},"Study the relationship between intense rainfalls and landslides to create threshold levels of when to expect landslides","Geotechnics, including landslips and rock falls, cuts","Research","Research ","Pro-action","National network",1,1,0,-1,2,"YES",-2,0,0,0,0,0,0,null,null,60]
[267,"03 Landslips and avalanches","03-1 External slides affecting the road",{"$error":"#NAME?"},"Support the slope with a retaining structure","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Prevention","Object",3,0,0,-2,2,"YES",-2,0,-1,-2,-2,0,0,null,null,47]
[268,"03 Landslips and avalanches","03-2 Slides of the road embankment",{"$error":"#NAME?"},"Assess the risk of landslides based on pore pressure","Geotechnics, including landslips and rock falls, cuts","Research","Research ","Pro-action","National network",-3,-1,0,-2,-1,"YES",0,0,1,0,0,0,0,null,null,47]
[269,"03 Landslips and avalanches","03-2 Slides of the road embankment",{"$error":"#NAME?"},"Carrying out risk assessment of  identified areas","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",1,2,1,-2,2,"YES",-2,-1,1,0,0,0,0,null,null,47]
[270,"03 Landslips and avalanches","03-2 Slides of the road embankment",{"$error":"#NAME?"},"Continuously measure the pore pressure in the slope ","Geotechnics, including landslips and rock falls, cuts","Monitoring and prediction","Monitoring","Pro-action","Object - stretch",3,1,0,-2,1,"YES",-2,0,0,0,0,0,0]
[271,"03 Landslips and avalanches","03-2 Slides of the road embankment",{"$error":"#NAME?"},"Cover slope with rock blanket","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Prevention","Object",2,3,-1,2,2,"NO",2,-1,-1,-3,-3,0,0,null,null,47]
[272,"03 Landslips and avalanches","03-2 Slides of the road embankment",{"$error":"#NAME?"},"Cover slope with vegetation","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Prevention","Object",3,1,0,-1,1,"YES",-1,1,0,2,1,0,0]
[273,"03 Landslips and avalanches","03-2 Slides of the road embankment",{"$error":"#NAME?"},"Cutting back the slope to a shallower angle","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Prevention","Object",1,2,-1,-1,2,"YES",-1,0,-1,-1,0,0,0,null,null,47]
[274,"03 Landslips and avalanches","03-2 Slides of the road embankment",{"$error":"#NAME?"},"Develop plans and routines for the priority of securing areas prone to landslides","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",1,2,-1,-1,2,"YES",0,0,0,0,0,0,0,null,null,47]
[275,"03 Landslips and avalanches","03-2 Slides of the road embankment",{"$error":"#NAME?"},"Ensure efficient drainage systems","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","Object - stretch",1,0,0,-1,1,"YES",0,0,0,0,0,0,0]
[276,"03 Landslips and avalanches","03-2 Slides of the road embankment",{"$error":"#NAME?"},"Implement a system of geotechnical risk management","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Legislation , regulations","Pro-action","National network",2,1,0,1,1,"YES",-1,0,0,0,0,0,0,null,null,47]
[277,"03 Landslips and avalanches","03-2 Slides of the road embankment",{"$error":"#NAME?"},"Inspect and clean watercourses regularly","Drainage of earthworks and pavements, sewers","Preventive maintenance and replacement","Maintenance and replacement","Pro-action","Object - stretch - network",3,2,0,2,2,"YES",-1,0,1,0,0,0,0,null,null,47]
[278,"03 Landslips and avalanches","03-2 Slides of the road embankment",{"$error":"#NAME?"},"Install erosion barriers soon after the wildfire","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","Object",3,2,0,-1,1,"YES",1,0,0,1,-1,1,1,null,null,50]
[279,"03 Landslips and avalanches","03-2 Slides of the road embankment",{"$error":"#NAME?"},"Lane closure","All road infrastructure","Traffic management","Traffic management","Response","Stretch",-2,3,0,-2,-2,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","If a traffic lane still available"]
[280,"03 Landslips and avalanches","03-2 Slides of the road embankment",{"$error":"#NAME?"},"Make strategies for temporary rerouting","Geotechnics, including landslips and rock falls, cuts","Traffic management","Planning","Pro-action","Regional network",3,1,2,-1,2,"YES",-2,-1,-1,0,0,-1,0]
[281,"03 Landslips and avalanches","03-2 Slides of the road embankment",{"$error":"#NAME?"},"Mapping areas prone to landslides","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",2,1,0,-1,1,"YES",0,0,0,0,0,0,0,null,null,47]
[282,"03 Landslips and avalanches","03-2 Slides of the road embankment",{"$error":"#NAME?"},"Mapping sites of occurred  landslides","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",0,0,0,0,0,"YES",0,0,0,0,0,0,0,null,null,47]
[283,"03 Landslips and avalanches","03-2 Slides of the road embankment",{"$error":"#NAME?"},"Rebuild stretches of the road on safe ground","Geotechnics, including landslips and rock falls, cuts","Upgrade / retrofitting / new construction","Maintenance and replacement","Response","Stretch",1,1,-1,-2,-1,"NO",-2,-2,-2,-1,-2,0,0]
[284,"03 Landslips and avalanches","03-2 Slides of the road embankment",{"$error":"#NAME?"},"Reroute the traffic","All road infrastructure","Extreme event management","Traffic management","Response","Stretch - network",2,0,-3,-2,1,"NO",0,-2,-3,0,-1,0,0]
[285,"03 Landslips and avalanches","03-2 Slides of the road embankment",{"$error":"#NAME?"},"Resize drainage systems to meet threats","Drainage of earthworks and pavements, sewers","Upgrade / retrofitting / new construction","Resilient construction","Pro-action","Object - stretch - network",3,1,-1,-2,2,"YES",-1,0,2,-1,-1,0,0,null,null,47]
[286,"03 Landslips and avalanches","03-2 Slides of the road embankment",{"$error":"#NAME?"},"Stabilize the surrounding area","Geotechnics, including landslips and rock falls, cuts","Extreme event management","Robust construction","Recovery","Object",2,2,1,-2,2,"NO",-1,0,0,0,0,0,0]
[287,"03 Landslips and avalanches","03-2 Slides of the road embankment",{"$error":"#NAME?"},"Study the relationship between intense rainfalls and landslides to create threshold levels of when to expect landslides","Geotechnics, including landslips and rock falls, cuts","Research","Research ","Pro-action","National network",1,1,0,-1,2,"YES",-2,0,0,0,0,0,0,null,null,60]
[288,"03 Landslips and avalanches","03-2 Slides of the road embankment",{"$error":"#NAME?"},"Support the slope with a retaining structure","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Prevention","Object",3,0,0,-2,2,"YES",-2,0,-1,-2,-2,0,0,null,null,47]
[289,"03 Landslips and avalanches","03-3 Debris flow",{"$error":"#NAME?"},"Avoid deforestation on slopes ","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Resilient construction","Pro-action","Object - stretch - network",3,1,0,-1,2,"YES",0,3,3,3,0,2,2]
[290,"03 Landslips and avalanches","03-3 Debris flow",{"$error":"#NAME?"},"Build channels or deflection walls to direct the flow","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Preparation","Object",2,2,0,-2,2,"NO",2,0,-1,-1,-2,0,0,null,null,53]
[291,"03 Landslips and avalanches","03-3 Debris flow",{"$error":"#NAME?"},"Carrying out risk assessment of  identified areas","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",1,2,1,-2,2,"YES",-2,-1,1,0,0,0,0,null,null,47]
[292,"03 Landslips and avalanches","03-3 Debris flow",{"$error":"#NAME?"},"Construct a catch ditch at the toe of the slope","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","Object - stretch - network",2,1,0,-1,1,"YES",-1,0,1,0,0,0,0,null,null,54]
[293,"03 Landslips and avalanches","03-3 Debris flow",{"$error":"#NAME?"},"Develop plans and routines for the priority of securing areas prone to debris flows","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",1,2,-1,-1,2,"YES",0,0,0,0,0,0,0,null,null,47]
[294,"03 Landslips and avalanches","03-3 Debris flow",{"$error":"#NAME?"},"Ensure efficient drainage systems","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","Object - stretch",1,0,0,-1,1,"YES",0,0,0,0,0,0,0]
[295,"03 Landslips and avalanches","03-3 Debris flow",{"$error":"#NAME?"},"Implement a system of geotechnical risk management","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Legislation , regulations","Pro-action","Regional network",1,2,1,-2,2,"YES",-2,-1,1,0,0,0,0,null,null,47]
[296,"03 Landslips and avalanches","03-3 Debris flow",{"$error":"#NAME?"},"Inspect and clean watercourses regularly","Drainage of earthworks and pavements, sewers","Preventive maintenance and replacement","Maintenance and replacement","Pro-action","Object - stretch - network",3,2,0,2,2,"YES",-1,0,1,0,0,0,0,null,null,47]
[297,"03 Landslips and avalanches","03-3 Debris flow",{"$error":"#NAME?"},"Install barriers to catch material in debris flows","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","Object - stretch - network",3,1,0,-1,2,"YES",0,3,3,3,0,2,2,null,null,58]
[298,"03 Landslips and avalanches","03-3 Debris flow",{"$error":"#NAME?"},"Install dams to arrest and store debris","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","Object - stretch - network",3,1,0,-1,2,"YES",0,3,3,3,0,2,2,null,null,58]
[299,"03 Landslips and avalanches","03-3 Debris flow",{"$error":"#NAME?"},"Install protective walls/barriers to divert masses","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","Object",2,1,0,-1,1,"NO",0,-1,-2,-2,-1,0,0,null,null,59]
[300,"03 Landslips and avalanches","03-3 Debris flow",{"$error":"#NAME?"},"Install sheds or walls to protect roads","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","Object - stretch - network",2,1,0,-1,1,"NO",0,-1,-2,-2,-1,0,0,null,null,59]
[301,"03 Landslips and avalanches","03-3 Debris flow",{"$error":"#NAME?"},"Lane closure","All road infrastructure","Traffic management","Traffic management","Response","Stretch",-2,3,0,-2,-2,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","If a traffic lane still available"]
[302,"03 Landslips and avalanches","03-3 Debris flow",{"$error":"#NAME?"},"Make strategies for temporary rerouting","Geotechnics, including landslips and rock falls, cuts","Traffic management","Planning","Pro-action","Regional network",3,1,2,-1,2,"YES",-2,-1,-1,0,0,-1,0]
[303,"03 Landslips and avalanches","03-3 Debris flow",{"$error":"#NAME?"},"Make strategies for temporary rerouting","Geotechnics, including landslips and rock falls, cuts","Traffic management","Planning","Pro-action","Regional network",3,1,2,-1,2,"YES",-2,-1,-1,0,0,-1,0]
[304,"03 Landslips and avalanches","03-3 Debris flow",{"$error":"#NAME?"},"Mapping areas prone to debris flows","All road infrastructure","Pro-active attitude","Planning","Pro-action","Regional network",2,1,0,-1,2,"YES",-1,0,0,0,0,0,0]
[305,"03 Landslips and avalanches","03-3 Debris flow",{"$error":"#NAME?"},"Mapping sites of occurred  debris flows","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",2,1,0,-1,1,"YES",0,0,0,0,0,0,0]
[306,"03 Landslips and avalanches","03-3 Debris flow",{"$error":"#NAME?"},"Rebuild stretches of the road on safe ground","Geotechnics, including landslips and rock falls, cuts","Upgrade / retrofitting / new construction","Maintenance and replacement","Response","Stretch",1,1,-1,-2,-1,"NO",-2,-2,-2,-1,-2,0,0]
[307,"03 Landslips and avalanches","03-3 Debris flow",{"$error":"#NAME?"},"Reroute the traffic","All road infrastructure","Extreme event management","Traffic management","Response","Stretch - network",2,0,-3,-2,1,"NO",0,-2,-3,0,-1,0,0]
[308,"03 Landslips and avalanches","03-3 Debris flow",{"$error":"#NAME?"},"Resize drainage systems to meet threats","Drainage of earthworks and pavements, sewers","Upgrade / retrofitting / new construction","Resilient construction","Pro-action","Object - stretch - network",3,1,-1,-2,2,"YES",-1,0,2,-1,-1,0,0,null,null,47]
[309,"03 Landslips and avalanches","03-3 Debris flow",{"$error":"#NAME?"},"Study the relationship between intense rainfalls and debris flows to create threshold levels of when to expect a failure","Geotechnics, including landslips and rock falls, cuts","Research","Research ","Pro-action","National network",1,1,0,-1,2,"YES",-2,0,0,0,0,0,0,null,null,60]
[310,"03 Landslips and avalanches","03-3 Debris flow",{"$error":"#NAME?"},"Use sensitive seismographs to detect debris flows that have already started moving","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Monitoring","Pro-action","Object - stretch - network",-1,0,0,-2,1,"YES",-1,0,0,0,0,0,0]
[311,"03 Landslips and avalanches","03-4 Rock fall",{"$error":"#NAME?"},"Apply Rockfall Hazard Rating System (RHRS) on the slope","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Object - stretch",0,1,0,-1,0,"YES",0,0,0,0,0,0,0,null,null,51]
[312,"03 Landslips and avalanches","03-4 Rock fall",{"$error":"#NAME?"},"Carrying out risk assessment of  identified areas","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",1,2,1,-2,2,"YES",-2,-1,1,0,0,0,0,null,null,47]
[313,"03 Landslips and avalanches","03-4 Rock fall",{"$error":"#NAME?"},"Construct a catch ditch at the toe of the slope","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","Object - stretch - network",2,1,0,-1,1,"YES",-1,0,1,0,0,0,0,null,null,54]
[314,"03 Landslips and avalanches","03-4 Rock fall",{"$error":"#NAME?"},"Develop plans and routines for the priority of securing areas prone to rock falls","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",1,2,-1,-1,2,"YES",0,0,0,0,0,0,0,null,null,47]
[315,"03 Landslips and avalanches","03-4 Rock fall",{"$error":"#NAME?"},"Ensure efficient drainage systems","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","Object - stretch",1,0,0,-1,1,"YES",0,0,0,0,0,0,0]
[316,"03 Landslips and avalanches","03-4 Rock fall",{"$error":"#NAME?"},"Implement a system of geotechnical risk management","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Legislation , regulations","Pro-action","Regional network",1,2,1,-2,2,"YES",-2,-1,1,0,0,0,0,null,null,47]
[317,"03 Landslips and avalanches","03-4 Rock fall",{"$error":"#NAME?"},"Install active protection systems to prevent rock detachments.","Geotechnics, including landslips and rock falls, cuts","Prevention","Robust construction","Prevention","Object - stretch - network",-1,2,0,-2,2,"YES",-2,0,0,0,0,0,0,null,null,58]
[318,"03 Landslips and avalanches","03-4 Rock fall",{"$error":"#NAME?"},"Install passive protection systems to protect infrastructure below the slope","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","Object - stretch - network",2,1,0,-1,1,"NO",0,-1,-2,-2,-1,0,0,null,null,59]
[319,"03 Landslips and avalanches","03-4 Rock fall",{"$error":"#NAME?"},"Install sheds or walls to protect roads","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","Object - stretch - network",2,1,0,-1,1,"NO",0,-1,-2,-2,-1,0,0,null,null,59]
[320,"03 Landslips and avalanches","03-4 Rock fall",{"$error":"#NAME?"},"Lane closure","All road infrastructure","Traffic management","Traffic management","Response","Stretch",-2,3,0,-2,-2,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","If a traffic lane still available"]
[321,"03 Landslips and avalanches","03-4 Rock fall",{"$f":"VLOOKUP(C323,climate_par_table,2)","v":{"$error":"#NAME?"}},"Make strategies for temporary rerouting","Geotechnics, including landslips and rock falls, cuts","Traffic management","Planning","Pro-action","Regional network",3,1,2,-1,2,"YES",-2,-1,-1,0,0,-1,0]
[322,"03 Landslips and avalanches","03-4 Rock fall",{"$error":"#NAME?"},"Mapping areas prone to rock falls","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",2,1,0,-1,1,"YES",0,0,0,0,0,0,0]
[323,"03 Landslips and avalanches","03-4 Rock fall",{"$error":"#NAME?"},"Mapping sites of occurred  rock falls","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",3,1,0,-1,2,"YES",-1,0,0,0,0,0,0]
[324,"03 Landslips and avalanches","03-4 Rock fall",{"$error":"#NAME?"},"Perform controlled explosions or other measures to remove loose rocks","Geotechnics, including landslips and rock falls, cuts","Preventive maintenance and replacement","Maintenance and replacement","Prevention","Object - stretch - network",2,-1,-1,-2,1,"NO",-1,-1,-1,-2,-2,0,0]
[325,"03 Landslips and avalanches","03-4 Rock fall",{"$error":"#NAME?"},"Perform regular laser monitoring to detect movement of rocks","Geotechnics, including landslips and rock falls, cuts","Monitoring and prediction","Monitoring","Pro-action","Object - stretch - network",2,-1,-1,-2,1,"NO",-1,-1,-1,-2,-2,0,0]
[326,"03 Landslips and avalanches","03-4 Rock fall",{"$error":"#NAME?"},"Rebuild stretches of the road on safe ground","Geotechnics, including landslips and rock falls, cuts","Upgrade / retrofitting / new construction","Maintenance and replacement","Response","Stretch",1,1,-1,-2,-1,"NO",-2,-2,-2,-1,-2,0,0]
[327,"03 Landslips and avalanches","03-4 Rock fall",{"$error":"#NAME?"},"Reroute the traffic","All road infrastructure","Extreme event management","Traffic management","Response","Stretch - network",2,0,-3,-2,1,"NO",0,-2,-3,0,-1,0,0]
[328,"03 Landslips and avalanches","03-4 Rock fall",{"$error":"#NAME?"},"Study the relationsship between rock fall and precipitation","Geotechnics, including landslips and rock falls, cuts","Research","Research ","Pro-action","Regional network",1,0,0,-1,1,"YES",-1,0,0,0,0,0,0]
[329,"03 Landslips and avalanches","03-5 Snow avalanches",{"$error":"#NAME?"},"Artificial triggering (active control) of avalanches","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Maintenance and replacement","Prevention","Object - stretch - network",3,-1,-1,-2,2,"NO",-2,-2,1,-1,-1,-1,0,null,null,52]
[330,"03 Landslips and avalanches","03-5 Snow avalanches",{"$error":"#NAME?"},"Avoid deforestation on slopes ","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Resilient construction","Pro-action","Object - stretch - network",3,1,0,-1,2,"YES",0,3,3,3,0,2,2]
[331,"03 Landslips and avalanches","03-5 Snow avalanches",{"$error":"#NAME?"},"Carrying out risk assessment of  identified areas","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",1,2,1,-2,2,"YES",-2,-1,1,0,0,0,0,null,null,47]
[332,"03 Landslips and avalanches","03-5 Snow avalanches",{"$error":"#NAME?"},"Develop plans and routines for the priority of securing areas prone to avalanches","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",1,2,-1,-1,2,"YES",0,0,0,0,0,0,0,null,null,47]
[333,"03 Landslips and avalanches","03-5 Snow avalanches",{"$error":"#NAME?"},"Install dams to arrest and store snow","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Preparation","Object - stretch - network",2,1,0,-1,1,"NO",0,-1,-1,1,-1,0,0,null,null,58]
[334,"03 Landslips and avalanches","03-5 Snow avalanches",{"$error":"#NAME?"},"Install sheds or walls to protect roads","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Pro-action","Object - stretch - network",2,1,0,-1,1,"NO",0,-1,-2,-2,-1,0,0,null,null,59]
[335,"03 Landslips and avalanches","03-5 Snow avalanches",{"$error":"#NAME?"},"Install supporting structures in the starting zone","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Robust construction","Prevention","Object - stretch - network",2,1,0,-1,1,"NO",0,-1,-2,-2,-1,0,0,null,null,59]
[336,"03 Landslips and avalanches","03-5 Snow avalanches",{"$error":"#NAME?"},"Lane closure","All road infrastructure","Traffic management","Traffic management","Response","Stretch",-2,3,0,-2,-2,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","If a traffic lane still available"]
[337,"03 Landslips and avalanches","03-5 Snow avalanches",{"$error":"#NAME?"},"Make strategies for temporary rerouting","Geotechnics, including landslips and rock falls, cuts","Traffic management","Planning","Pro-action","Regional network",3,1,2,-1,2,"YES",-2,-1,-1,0,0,-1,0]
[338,"03 Landslips and avalanches","03-5 Snow avalanches",{"$error":"#NAME?"},"Mapping areas prone to avalanches","All road infrastructure","Pro-active attitude","Planning","Pro-action","Regional network",2,1,0,-1,2,"YES",-1,0,0,0,0,0,0]
[339,"03 Landslips and avalanches","03-5 Snow avalanches",{"$error":"#NAME?"},"Mapping sites of occurred avalanches ","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude","Planning","Pro-action","Regional network",3,1,0,-1,2,"YES",-1,0,0,0,0,0,0]
[340,"03 Landslips and avalanches","03-5 Snow avalanches",{"$error":"#NAME?"},"Rebuild stretches of the road on safe ground","Geotechnics, including landslips and rock falls, cuts","Upgrade / retrofitting / new construction","Maintenance and replacement","Response","Stretch",1,1,-1,-2,-1,"NO",-2,-2,-2,-1,-2,0,0]
[341,"03 Landslips and avalanches","03-5 Snow avalanches",{"$error":"#NAME?"},"Reroute the traffic","All road infrastructure","Extreme event management","Traffic management","Response","Stretch - network",2,0,-3,-2,1,"NO",0,-2,-3,0,-1,0,0]
[342,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels",{"$error":"#NAME?"},"Access restriction","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","Stretch",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","MC: to certain categories of vehicles (e.g. HGV, vehicles with trailers, non-equipped vehicles …) ",26]
[343,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels",{"$error":"#NAME?"},"Application of geotextiles in (sub)base","Pavements: bituminous, concrete, semi-rigid","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Stretch",1,0,0,-1,0,"NO",2,0,0,0,1,0,0,null,null,"4, 39"]
[344,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels",{"$error":"#NAME?"},"Develop binders that are more resilient to stripping","Pavements: bituminous, concrete, semi-rigid","Research","Research ","Preparation","Object - stretch - network",1,1,0,-1,0,"NO",2,0,0,0,1,0,1,null,null,3]
[345,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels",{"$error":"#NAME?"},"Full depth patches","Pavements: bituminous, concrete, semi-rigid","Corrective maintenance and replacement","Maintenance and replacement","Recovery","Object",0,0,0,0,0,"NO",0,0,0,0,-1,0,0,null,null,7]
[346,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels",{"$error":"#NAME?"},"Improving drainage of the area","Pavements: bituminous, concrete, semi-rigid","Prevention","Robust construction","Prevention","Regional network",2,0,2,-1,-1,"NO",2,0,0,0,0,0,0,null,null,"4, 26"]
[347,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels",{"$error":"#NAME?"},"Improved models for bearing capacity of pavements after flooding","Pavements: bituminous, concrete, semi-rigid","Research","Research ","Preparation","Object - stretch - network",2,0,2,-1,1,"NO",2,0,0,0,1,0,0,null,null,48]
[348,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels",{"$error":"#NAME?"},"In situ strengthening of granular (sub)bases and subgrade soils, using articificial or natural cements","Pavements: bituminous, concrete, semi-rigid","Research","Research","Preparation","Stretch",1,0,1,-2,0,"NO",2,0,0,0,0,0,0,null,null,"4, 26"]
[349,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels",{"$error":"#NAME?"},"Increase the thickness of structural layers","Pavements: bituminous, concrete, semi-rigid","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",1,0,1,-1,0,"NO",2,0,0,0,0,0,0,null,null,"4, 26"]
[350,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels",{"$error":"#NAME?"},"Keeping the road drainage in good condition","Pavements: bituminous, concrete, semi-rigid","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Regional network",0,0,0,0,0,"NO",0,0,0,0,0,0,0,null,null,"4, 26"]
[351,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels",{"$error":"#NAME?"},"Lowering the groundwater table within the road embankment with deeper drainage","Pavements: bituminous, concrete, semi-rigid","Prevention","Robust construction","Prevention","Object - stretch",1,0,1,-1,0,"NO",2,0,0,0,0,0,0,null,null,"4, 26"]
[352,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels",{"$error":"#NAME?"},"Modal shift","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","Stretch",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[353,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels",{"$error":"#NAME?"},"Monitoring to detect potential problem areas,  establish cause-impact relationships; maintain specific construction and maintenance records","Pavements: bituminous, concrete, semi-rigid","Monitoring and prediction","Monitoring","All","Stretch",0,0,0,0,0,"NO",1,0,0,0,1,0,0,null,null,"4, 26"]
[552,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels",{"$error":"#NAME?"},"Monitoring of water levels in the road embankment after flooding","Pavements: bituminous, concrete, semi-rigid","Monitoring and prediction","Monitoring","Response","Stretch",1,0,1,0,1,"NO",1,0,0,0,1,0,0,"Monitoring of water levels will help decide on imposing access restrictions for HGV to prevent pavement damage"]
[354,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels",{"$error":"#NAME?"},"Preventive information","Pavements: bituminous, concrete, semi-rigid","Research","Research","Response","Object - stretch - network",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[355,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels",{"$error":"#NAME?"},"Real time traffic information","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","Stretch",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[356,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels",{"$error":"#NAME?"},"Real time weather and traffic forecast","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","Stretch",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[357,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels",{"$error":"#NAME?"},"Rerouting and guidance","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","TEN-T - national - regional",2,0,3,-2,-1,"Yes",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","Need  to be implemented with fixed signalling if electronic system not available…"]
[358,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels",{"$error":"#NAME?"},"Revised standards for binder course, (sub)base and subgrade materials, drainage","Pavements: bituminous, concrete, semi-rigid","Prevention","Legislation , regulations","Preparation","Object - stretch - network",1,0,1,-1,0,"NO",2,0,0,0,1,0,0,null,null,"26, 39"]
[359,"04 Loss of road structure integrity","04-2 Weakening of the road base by standing water",{"$error":"#NAME?"},"Access restriction","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","Stretch",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","MC: to certain categories of vehicles (e.g. HGV, vehicles with trailers, non-equipped vehicles …) ",26]
[360,"04 Loss of road structure integrity","04-2 Weakening of the road base by standing water",{"$error":"#NAME?"},"Appropriate maintenance of cracked pavements, structural measures for underlying causes","Pavements: bituminous, concrete, semi-rigid","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Stretch - network",0,0,0,0,0,"NO",0,0,0,0,0,0,0,null,null,"26, 33, 39"]
[361,"04 Loss of road structure integrity","04-2 Weakening of the road base by standing water",{"$error":"#NAME?"},"Appropriate maintenance of joint seals, structural measures for underlying causes","Concrete pavements","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Stretch - network",0,0,0,0,0,"NO",0,0,0,0,0,0,0,null,null,"26, 33, 39"]
[362,"04 Loss of road structure integrity","04-2 Weakening of the road base by standing water",{"$error":"#NAME?"},"Full depth patches","Pavements: bituminous, concrete, semi-rigid","Corrective maintenance and replacement","Maintenance and replacement","Recovery","Object",0,0,0,0,0,"NO",0,0,0,0,-1,0,0,null,null,7]
[363,"04 Loss of road structure integrity","04-2 Weakening of the road base by standing water",{"$error":"#NAME?"},"In situ strengthening of granular (sub)bases and subgrade soils, using articificial or natural cements","Pavements: bituminous, concrete, semi-rigid","Research","Research","Preparation","Stretch",1,0,1,-2,0,"Yes",2,0,0,0,0,0,0,null,null,"4, 26"]
[364,"04 Loss of road structure integrity","04-2 Weakening of the road base by standing water",{"$error":"#NAME?"},"Increase the thickness of structural layers","Pavements: bituminous, concrete, semi-rigid","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",1,0,1,-1,0,"NO",2,0,0,0,0,0,0,null,null,"4, 26"]
[365,"04 Loss of road structure integrity","04-2 Weakening of the road base by standing water",{"$error":"#NAME?"},"Keeping the road drainage in good condition","Pavements: bituminous, concrete, semi-rigid","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Regional network",0,0,0,0,0,"NO",0,0,0,0,0,0,0,null,null,"4, 26"]
[366,"04 Loss of road structure integrity","04-2 Weakening of the road base by standing water",{"$error":"#NAME?"},"Modal shift","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","Stretch",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[367,"04 Loss of road structure integrity","04-2 Weakening of the road base by standing water",{"$error":"#NAME?"},"Monitoring to detect potential problem areas,  establish cause-impact relationships; maintain specific construction and maintenance records","Pavements: bituminous, concrete, semi-rigid","Monitoring and prediction","Monitoring","All","Stretch",0,0,0,0,0,"NO",0,0,0,0,1,0,0,null,null,"4, 26"]
[368,"04 Loss of road structure integrity","04-2 Weakening of the road base by standing water",{"$error":"#NAME?"},"Prevention of reflection cracking by fibre reinforcement or dedicated interface layers","Semi-rigid pavements","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Stretch - network",1,0,1,-1,0,"NO",2,0,0,0,0,0,0,null,null,4]
[369,"04 Loss of road structure integrity","04-2 Weakening of the road base by standing water",{"$error":"#NAME?"},"Preventive information","Pavements: bituminous, concrete, semi-rigid","Research","Research","Response","Object - stretch - network",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[370,"04 Loss of road structure integrity","04-2 Weakening of the road base by standing water",{"$error":"#NAME?"},"Real time traffic information","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","Stretch",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[371,"04 Loss of road structure integrity","04-2 Weakening of the road base by standing water",{"$error":"#NAME?"},"Real time weather and traffic forecast","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","Stretch",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[372,"04 Loss of road structure integrity","04-2 Weakening of the road base by standing water",{"$error":"#NAME?"},"Rerouting and guidance","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","Stretch",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[373,"04 Loss of road structure integrity","04-2 Weakening of the road base by standing water",{"$error":"#NAME?"},"Rerouting and guidance","All road infrastructure","Traffic management","Traffic management","Response","TEN-T - national - regional",2,0,3,-2,-1,"Yes",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","AV: measure refers to pavements on bridges"]
[374,"04 Loss of road structure integrity","04-2 Weakening of the road base by standing water",{"$error":"#NAME?"},"Revised standards for binder course, (sub)base and subgrade materials, drainage","Pavements: bituminous, concrete, semi-rigid","Prevention","Legislation , regulations","Preparation","Object - stretch - network",1,0,1,-1,0,"NO",2,0,0,0,1,0,0,null,null,"26, 39"]
[375,"04 Loss of road structure integrity","04-3 (Unequal) settlements of roads by consolidation",{"$error":"#NAME?"},"In situ strengthening of granular (sub)bases and subgrade soils, using articificial or natural cements","Pavements: bituminous, concrete, semi-rigid","Research","Research","Preparation","Stretch",1,0,1,-2,0,"YES",2,0,0,0,0,0,0,null,null,"4, 26"]
[376,"04 Loss of road structure integrity","04-3 (Unequal) settlements of roads by consolidation",{"$error":"#NAME?"},"Lowering the groundwater table within the road embankment with deeper drainage","Pavements: bituminous, concrete, semi-rigid","Prevention","Robust construction","Prevention","Object - stretch",1,0,1,-2,0,"NO",2,0,0,0,0,0,0,null,null,"4, 26"]
[377,"04 Loss of road structure integrity","04-3 (Unequal) settlements of roads by consolidation",{"$error":"#NAME?"},"Monitoring to detect potential problem areas,  establish cause-impact relationships; maintain specific construction and maintenance records","Pavements: bituminous, concrete, semi-rigid","Monitoring and prediction","Monitoring","All","Stretch",0,0,0,0,0,"NO",0,0,0,0,1,0,0,null,null,"4, 26"]
[378,"04 Loss of road structure integrity","04-3 (Unequal) settlements of roads by consolidation",{"$error":"#NAME?"},"Replace by less sensitive material, stabilise sensitive material","Pavements: bituminous, concrete, semi-rigid","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch - network",1,0,1,-2,0,"NO",2,0,0,0,-1,0,0,null,null,"26, 39"]
[379,"04 Loss of road structure integrity","04-3 (Unequal) settlements of roads by consolidation",{"$error":"#NAME?"},"Rerouting and guidance","All road infrastructure","Traffic management","Traffic management","Response","TEN-T - national - regional",2,0,3,-2,-1,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures "]
[380,"04 Loss of road structure integrity","04-3 (Unequal) settlements of roads by consolidation",{"$error":"#NAME?"},"Revised standards for binder course, (sub)base and subgrade materials, drainage","Pavements: bituminous, concrete, semi-rigid","Prevention","Legislation , regulations","Preparation","Object - stretch - network",0,0,0,-1,0,"NO",2,0,0,0,1,0,0,null,null,"26, 39"]
[381,"04 Loss of road structure integrity","04-3 (Unequal) settlements of roads by consolidation",{"$error":"#NAME?"},"Revised standards for roadside vegetation","Pavements: bituminous, concrete, semi-rigid","Prevention","Legislation , regulations","Prevention","National network",0,0,0,0,0,"NO",2,0,0,0,1,0,0,null,null,7]
[382,"04 Loss of road structure integrity","04-3 (Unequal) settlements of roads by consolidation",{"$error":"#NAME?"},"Speed limits","All road infrastructure","Traffic management","Traffic management","Response","Object - stretch - network",-1,1,0,0,0,"YES",2,-2,0,0,1,0,1,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","Applies to all threats",10]
[383,"04 Loss of road structure integrity","04-4 Instability / subsidence of roads by thawing of permafrost",{"$error":"#NAME?"},"Access restriction","All road infrastructure","Traffic management","Traffic management","Response","Object - stretch - network",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","Applies to all threats; MC: To certain categories of vehicles (e.g. HGV, vehicles with trailers, non-equipped vehicles …) ",10]
[384,"04 Loss of road structure integrity","04-4 Instability / subsidence of roads by thawing of permafrost",{"$error":"#NAME?"},"Artificial cooling and/or extracting heat from the embankment","Pavements: bituminous, concrete, semi-rigid","Prevention","Robust construction","Prevention","Object - stretch",2,0,1,-2,1,"NO",2,-2,0,0,0,0,0,null,null,47]
[385,"04 Loss of road structure integrity","04-4 Instability / subsidence of roads by thawing of permafrost",{"$f":"VLOOKUP(C388,climate_par_table,2)","v":{"$error":"#NAME?"}},"Designing and repairing frost damaged roads in accordance with ROADEX guidelines for roads suffering from spring thaw weakening","Pavements: bituminous, concrete, semi-rigid","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Object - stretch",1,0,1,-1,0,"NO",0,0,0,0,0,0,0,null,null,47]
[386,"04 Loss of road structure integrity","04-4 Instability / subsidence of roads by thawing of permafrost",{"$error":"#NAME?"},"Designing and repairing frost damaged roads in accordance with ROADEX guidelines for roads suffering from spring thaw weakening","Pavements: bituminous, concrete, semi-rigid","Upgrade / retrofitting / new construction","Legislation , regulations","Preparation","Object - stretch",2,0,2,-2,1,"NO",2,0,0,0,0,0,0,null,null,47]
[387,"04 Loss of road structure integrity","04-4 Instability / subsidence of roads by thawing of permafrost",{"$error":"#NAME?"},"Excavating the frozen icy material and replacing it with thaw-stable fill","Pavements: bituminous, concrete, semi-rigid","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",2,0,1,-3,0,"YES",2,0,0,0,-1,0,0,null,null,47]
[388,"04 Loss of road structure integrity","04-4 Instability / subsidence of roads by thawing of permafrost",{"$error":"#NAME?"},"Increase the thickness of structural layers","Pavements: bituminous, concrete, semi-rigid","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",2,0,2,-2,1,"NO",2,0,0,0,0,0,0,null,null,47]
[389,"04 Loss of road structure integrity","04-4 Instability / subsidence of roads by thawing of permafrost",{"$error":"#NAME?"},"Increase width of lane for removal of snow","Pavements: bituminous, concrete, semi-rigid","Corrective maintenance and replacement","Maintenance and replacement","Response","Regional network",1,0,1,0,1,"NO",0,0,0,0,0,0,0,null,null,4]
[390,"04 Loss of road structure integrity","04-4 Instability / subsidence of roads by thawing of permafrost",{"$error":"#NAME?"},"Increasing the reflectivity (albedo) of dark surfaces","Pavements: bituminous, concrete, semi-rigid","Prevention","Robust construction","Prevention","Object - stretch",1,0,1,0,0,"NO",2,0,0,0,0,0,0,null,null,47]
[391,"04 Loss of road structure integrity","04-4 Instability / subsidence of roads by thawing of permafrost",{"$error":"#NAME?"},"Installing insulation into the embankment","Pavements: bituminous, concrete, semi-rigid","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",1,0,1,-2,1,"NO",2,0,0,0,-1,0,0,null,null,47]
[392,"04 Loss of road structure integrity","04-4 Instability / subsidence of roads by thawing of permafrost",{"$error":"#NAME?"},"Modal shift","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","Object - stretch - network",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[393,"04 Loss of road structure integrity","04-4 Instability / subsidence of roads by thawing of permafrost",{"$error":"#NAME?"},"Monitoring to detect potential problem areas,  establish cause-impact relationships; maintain specific construction and maintenance records","Pavements: bituminous, concrete, semi-rigid","Monitoring and prediction","Monitoring","All","National network",0,0,0,0,0,"NO",0,0,0,0,1,0,0,null,null,47]
[394,"04 Loss of road structure integrity","04-4 Instability / subsidence of roads by thawing of permafrost",{"$error":"#NAME?"},"Partial reconstruction of pavement","Pavements: bituminous, concrete, semi-rigid","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",2,0,2,-2,1,"NO",2,0,0,0,0,0,0,null,null,4]
[395,"04 Loss of road structure integrity","04-4 Instability / subsidence of roads by thawing of permafrost",{"$error":"#NAME?"},"Preventive information","Pavements: bituminous, concrete, semi-rigid","Research","Research","Response","Object - stretch - network",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[396,"04 Loss of road structure integrity","04-4 Instability / subsidence of roads by thawing of permafrost",{"$error":"#NAME?"},"Real time traffic information","All road infrastructure","Traffic management","Traffic management","Response","Object - stretch - network",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[397,"04 Loss of road structure integrity","04-4 Instability / subsidence of roads by thawing of permafrost",{"$error":"#NAME?"},"Real time weather and traffic forecast","All road infrastructure","Traffic management","Traffic management","Response","Object - stretch - network",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[398,"04 Loss of road structure integrity","04-4 Instability / subsidence of roads by thawing of permafrost",{"$error":"#NAME?"},"Rerouting and guidance","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","TEN-T - national - regional",2,0,3,-2,-1,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures "]
[399,"04 Loss of road structure integrity","04-4 Instability / subsidence of roads by thawing of permafrost",{"$error":"#NAME?"},"Revised standards for pavement design","Pavements: bituminous, concrete, semi-rigid","Prevention","Legislation , regulations","Preparation","National network",2,0,2,-2,1,"NO",2,0,0,0,1,0,0,null,null,"4, 43"]
[400,"04 Loss of road structure integrity","04-4 Instability / subsidence of roads by thawing of permafrost",{"$error":"#NAME?"},"Using open graded rockfill in embankments to improve heat transfer","Pavements: bituminous, concrete, semi-rigid","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",1,0,1,0,0,"NO",2,0,0,0,1,0,0,null,null,47]
[401,"04 Loss of road structure integrity","04-5 Uplift of tunnels or light weight construction materials by increasing water levels",{"$error":"#NAME?"},"Adapt drainage system to control ground water table","Tunnels, low lying stretches and light weight embankments","Upgrade / retrofitting / new construction","Robust construction","Prevention","Object - stretch",2,1,2,-2,0,"NO",2,0,0,0,1,0,0,null,null,38]
[402,"04 Loss of road structure integrity","04-5 Uplift of tunnels or light weight construction materials by increasing water levels",{"$error":"#NAME?"},"Apply structural surcharge to counter uplift","Tunnels, low lying stretches and light weight embankments","Upgrade / retrofitting / new construction","Robust construction","Prevention","Object - stretch",2,1,2,-2,0,"NO",2,"-2",0,"-2","-2",0,0,null,null,38]
[403,"04 Loss of road structure integrity","04-5 Uplift of tunnels or light weight construction materials by increasing water levels",{"$error":"#NAME?"},"Apply surcharge to counter uplift as emergency measure","Tunnels, low lying stretches and light weight embankments","Extreme event management","Planning","Response","Object - stretch",1,0,0,-1,0,"NO",2,-1,0,-1,-1,0,2,null,null,38]
[404,"04 Loss of road structure integrity","04-5 Uplift of tunnels or light weight construction materials by increasing water levels",{"$error":"#NAME?"},"Appropriate inspection and maintenance of drainage, pumping and waterproofing systems","Tunnels, low lying stretches and light weight embankments","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Object - stretch",1,0,0,1,0,"NO",0,0,0,0,0,0,0,null,null,38]
[405,"04 Loss of road structure integrity","04-5 Uplift of tunnels or light weight construction materials by increasing water levels",{"$error":"#NAME?"},"Collect relevant construction data","Tunnels, low lying stretches and light weight embankments","Pro-active attitude","Planning","Pro-action","Object - stretch",0,0,0,0,0,"NO",0,0,0,0,1,0,0,null,null,38]
[406,"04 Loss of road structure integrity","04-5 Uplift of tunnels or light weight construction materials by increasing water levels",{"$error":"#NAME?"},"Install pumping systems to control ground water table","Tunnels, low lying stretches and light weight embankments","Upgrade / retrofitting / new construction","Robust construction","Prevention","Object - stretch",2,1,2,-2,0,"NO",2,"-2",0,"-2",-1,0,0,null,null,38]
[407,"04 Loss of road structure integrity","04-5 Uplift of tunnels or light weight construction materials by increasing water levels",{"$error":"#NAME?"},"Modal shift","Tunnels, low lying stretches and light weight embankments","Traffic management","Traffic management","Response","Regional network",1,0,0,-1,0,"NO",2,0,0,0,1,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,38]
[408,"04 Loss of road structure integrity","04-5 Uplift of tunnels or light weight construction materials by increasing water levels",{"$error":"#NAME?"},"Monitor ground water table","Tunnels, low lying stretches and light weight embankments","Monitoring and prediction","Monitoring","Prevention","Object - stretch",0,0,0,-1,0,"NO",0,0,0,0,1,0,0,null,null,38]
[409,"04 Loss of road structure integrity","04-5 Uplift of tunnels or light weight construction materials by increasing water levels",{"$error":"#NAME?"},"Prepare contingency / emergency plans","Tunnels, low lying stretches and light weight embankments","Pro-active attitude","Planning","Pro-action","Object - stretch",0,2,0,0,0,"YES",2,-2,0,0,1,0,2,null,null,38]
[410,"04 Loss of road structure integrity","04-5 Uplift of tunnels or light weight construction materials by increasing water levels",{"$error":"#NAME?"},"Preventive information","Tunnels, low lying stretches and light weight embankments","Research","Research","Response","Object - stretch - network",1,0,0,-1,0,"NO",2,0,0,0,1,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,38]
[411,"04 Loss of road structure integrity","04-5 Uplift of tunnels or light weight construction materials by increasing water levels",{"$error":"#NAME?"},"Real time traffic information","Tunnels, low lying stretches and light weight embankments","Traffic management","Traffic management","Response","Regional network",1,0,0,-1,0,"NO",2,0,0,0,1,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,38]
[412,"04 Loss of road structure integrity","04-5 Uplift of tunnels or light weight construction materials by increasing water levels",{"$error":"#NAME?"},"Rerouting and guidance","Tunnels, low lying stretches and light weight embankments","Traffic management","Traffic management","Response","Regional network",1,0,0,-1,0,"NO",2,0,0,0,1,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,38]
[413,"04 Loss of road structure integrity","04-5 Uplift of tunnels or light weight construction materials by increasing water levels",{"$error":"#NAME?"},"Revised standards for design of excavations and light weight fills","Tunnels, low lying stretches and light weight embankments","Prevention","Legislation , regulations","Preparation","Object - stretch",2,1,2,0,0,"NO",2,0,0,0,1,0,0,null,null,38]
[414,"04 Loss of road structure integrity","04-5 Uplift of tunnels or light weight construction materials by increasing water levels",{"$error":"#NAME?"},"Strengthen tension piles of excavations","Tunnels, low lying stretches and light weight embankments","Upgrade / retrofitting / new construction","Robust construction","Prevention","Object - stretch",2,1,2,-2,0,"NO",2,0,0,0,1,0,0,null,null,38]
[415,"05 Loss of pavement integrity","05-1 Cracking, rutting, embrittlement",{"$error":"#NAME?"},"Access restriction","All road infrastructure","Traffic management","Traffic management","Response","Object - stretch - network",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[416,"05 Loss of pavement integrity","05-1 Cracking, rutting, embrittlement",{"$error":"#NAME?"},"Anti-oxidation additives","Pavements: bituminous, semi-rigid","Research","Research","Preparation","National network",1,0,0,0,0,"NO",2,0,0,0,1,0,2,null,null,"4, 39"]
[417,"05 Loss of pavement integrity","05-1 Cracking, rutting, embrittlement",{"$error":"#NAME?"},"Cold mill and overlay, thin surface patches","Pavements: bituminous, semi-rigid","Corrective maintenance and replacement","Maintenance and replacement","Recovery","Stretch",-1,1,0,-1,0,"NO",0,0,0,0,-1,0,2,null,null,"7, 39"]
[418,"05 Loss of pavement integrity","05-1 Cracking, rutting, embrittlement",{"$error":"#NAME?"},"Harvesting of heat energy from the pavement","Pavements: bituminous, semi-rigid","Research","Research","Prevention","Object - stretch",1,1,0,0,0,"YES",2,2,0,0,1,0,2,null,null,10]
[419,"05 Loss of pavement integrity","05-1 Cracking, rutting, embrittlement",{"$error":"#NAME?"},"High albedo pavements, heat shield pavements, water retention pavements","Pavements: bituminous, semi-rigid","Research","Research","Prevention","Stretch - network",1,1,0,-1,0,"NO",2,0,0,0,1,0,1,null,null,"4, 10, 39"]
[420,"05 Loss of pavement integrity","05-1 Cracking, rutting, embrittlement",{"$error":"#NAME?"},"Keep construction records","Pavements: bituminous, concrete, semi-rigid","Monitoring and prediction","Monitoring","All","Stretch - network",0,0,0,0,0,"NO",0,0,0,0,0,0,0,null,null,39]
[421,"05 Loss of pavement integrity","05-1 Cracking, rutting, embrittlement",{"$error":"#NAME?"},"Modal shift","All road infrastructure","Traffic management","Traffic management","Response","Object - stretch - network",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[422,"05 Loss of pavement integrity","05-1 Cracking, rutting, embrittlement",{"$error":"#NAME?"},"Placing warning signs","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Preparation","Stretch - network",0,2,0,-1,0,"YES",2,-2,0,0,1,0,2,null,null,39]
[423,"05 Loss of pavement integrity","05-1 Cracking, rutting, embrittlement",{"$error":"#NAME?"},"Prepare contingency / emergency plans","Pavements: bituminous, concrete, semi-rigid","Pro-active attitude","Planning","Pro-action","Stretch - network",0,2,0,0,0,"YES",2,-2,0,0,1,0,2,null,null,39]
[424,"05 Loss of pavement integrity","05-1 Cracking, rutting, embrittlement",{"$error":"#NAME?"},"Preventive information","Pavements: bituminous, concrete, semi-rigid","Research","Research","Response","Object - stretch - network",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[425,"05 Loss of pavement integrity","05-1 Cracking, rutting, embrittlement",{"$error":"#NAME?"},"Real time traffic information","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","Object - stretch - network",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[426,"05 Loss of pavement integrity","05-1 Cracking, rutting, embrittlement",{"$error":"#NAME?"},"Real time weather and traffic forecast","Pavements: bituminous, semi-rigid","Research","Research","Response","Object - stretch - network",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","Applies to all threats",10]
[427,"05 Loss of pavement integrity","05-1 Cracking, rutting, embrittlement",{"$error":"#NAME?"},"Replace by more temperature resilient material","Pavements: bituminous, semi-rigid","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Stretch - network",1,1,0,0,0,"NO",2,0,0,0,1,0,1,null,null,39]
[428,"05 Loss of pavement integrity","05-1 Cracking, rutting, embrittlement",{"$error":"#NAME?"},"Rerouting and guidance","Bituminous pavements","Traffic management","Traffic management","Response","TEN-T - national - regional",2,0,3,-2,-1,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","Applies to all threats"]
[429,"05 Loss of pavement integrity","05-1 Cracking, rutting, embrittlement",{"$error":"#NAME?"},"Revised standards for materials in surface courses","Pavements: bituminous, semi-rigid","Prevention","Legislation , regulations","Preparation","National network",1,1,0,0,0,"NO",2,0,0,0,1,0,1,null,null,42]
[430,"05 Loss of pavement integrity","05-1 Cracking, rutting, embrittlement",{"$error":"#NAME?"},"Treat with hot fine aggregate","Pavements: bituminous, semi-rigid","Corrective maintenance and replacement","Maintenance and replacement","Recovery","Stretch",-1,1,0,-1,0,"NO",0,0,0,0,-1,0,2,null,null,39]
[431,"05 Loss of pavement integrity","05-2 Frost heave",{"$error":"#NAME?"},"Access restriction","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","Stretch - network",-1,0,-1,2,0,"YES",2,-2,0,0,1,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","MC: to certain categories of vehicles (e.g. HGV, vehicles with trailers, non-equipped vehicles …) ",47]
[432,"05 Loss of pavement integrity","05-2 Frost heave",{"$error":"#NAME?"},"Improving the asphalt specification to increase its failure strain","Pavements: bituminous, concrete, semi-rigid","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",1,0,1,-1,0,"NO",2,0,0,0,1,0,0,null,null,47]
[433,"05 Loss of pavement integrity","05-2 Frost heave",{"$error":"#NAME?"},"Increase the thickness of structural layers","Pavements: bituminous, concrete, semi-rigid","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Stretch - network",1,0,1,-1,0,"NO",2,0,0,0,0,0,0,null,null,47]
[434,"05 Loss of pavement integrity","05-2 Frost heave",{"$error":"#NAME?"},"Installing insulation into the embankment","Pavements: bituminous, concrete, semi-rigid","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",1,0,1,-2,1,"NO",2,0,0,0,0,0,0,null,null,47]
[435,"05 Loss of pavement integrity","05-2 Frost heave",{"$error":"#NAME?"},"Installing steel grids in the road structure","Pavements: bituminous, concrete, semi-rigid","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",1,0,1,-1,0,"NO",2,0,0,0,0,0,0,null,null,47]
[436,"05 Loss of pavement integrity","05-2 Frost heave",{"$error":"#NAME?"},"Keeping ditches and culverts free of snow and ice by means of good winter maintenance practices","Pavements: bituminous, concrete, semi-rigid","Preventive maintenance and replacement","Maintenance and replacement","Response","Regional network",1,0,1,0,0,"NO",0,0,0,0,0,0,0,null,null,47]
[437,"05 Loss of pavement integrity","05-2 Frost heave",{"$error":"#NAME?"},"Keeping the road drainage in good condition","Pavements: bituminous, concrete, semi-rigid","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Regional network",1,0,1,0,0,"NO",0,0,0,0,0,0,0,null,null,47]
[438,"05 Loss of pavement integrity","05-2 Frost heave",{"$error":"#NAME?"},"Lowering the groundwater table within the road embankment with deeper drainage","Pavements: bituminous, concrete, semi-rigid","Prevention","Robust construction","Prevention","Object - stretch",1,0,1,-2,1,"NO",2,0,0,0,0,0,0,null,null,47]
[439,"05 Loss of pavement integrity","05-2 Frost heave",{"$error":"#NAME?"},"Monitoring to detect potential problem areas,  establish cause-impact relationships; maintain specific construction and maintenance records","Pavements: bituminous, concrete, semi-rigid","Monitoring and prediction","Monitoring","All","Stretch",0,0,0,0,0,"NO",0,0,0,0,1,0,0,null,null,"4, 26"]
[440,"05 Loss of pavement integrity","05-2 Frost heave",{"$error":"#NAME?"},"Raising the carriageway out of the snow field","Pavements: bituminous, concrete, semi-rigid","Prevention","Robust construction","Prevention","Object - stretch",2,0,2,-3,1,"NO",2,0,0,0,-2,0,0,null,null,47]
[441,"05 Loss of pavement integrity","05-2 Frost heave",{"$error":"#NAME?"},"Replacing any frost susceptible materials in the road structure with non-frost susceptible materials","Pavements: bituminous, concrete, semi-rigid","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",1,0,1,-2,1,"NO",2,0,0,0,-2,0,0,null,null,47]
[442,"05 Loss of pavement integrity","05-2 Frost heave",{"$error":"#NAME?"},"Rerouting and guidance","All road infrastructure","Traffic management","Traffic management","Response","TEN-T - national - regional",2,0,3,-2,-1,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures "]
[443,"05 Loss of pavement integrity","05-2 Frost heave",{"$error":"#NAME?"},"Sealing pavement cracks immediately after the winter period","Pavements: bituminous, concrete, semi-rigid","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Stretch - network",0,0,0,-1,0,"NO",0,0,0,0,1,0,0,null,null,47]
[444,"05 Loss of pavement integrity","05-2 Frost heave",{"$error":"#NAME?"},"Soil stabilization/homogenization","Pavements: bituminous, concrete, semi-rigid","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",1,0,1,-2,1,"NO",2,0,0,0,0,0,0,null,null,47]
[445,"05 Loss of pavement integrity","05-2 Frost heave",{"$error":"#NAME?"},"Speed limits ","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","Stretch",2,3,0,-1,-1,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures "]
[446,"05 Loss of pavement integrity","05-2 Frost heave",{"$error":"#NAME?"},"Strengthening and rehabilitating weak road sections","Pavements: bituminous, concrete, semi-rigid","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",1,0,1,-2,1,"NO",2,0,0,0,1,0,0,null,null,47]
[447,"05 Loss of pavement integrity","05-2 Frost heave",{"$error":"#NAME?"},"Weight limits","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","Stretch",-2,2,-2,-1,-2,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures "]
[448,"05 Loss of pavement integrity","05-3 Aggregate loss and detachment of pavement layers",{"$error":"#NAME?"},"Converting the paved road back to a gravel road","Pavements: bituminous, concrete, semi-rigid","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",-2,0,-2,2,-1,"NO",2,0,0,0,1,0,0,null,null,47]
[449,"05 Loss of pavement integrity","05-3 Aggregate loss and detachment of pavement layers",{"$f":"VLOOKUP(C452,climate_par_table,2)","v":{"$error":"#NAME?"}},"Emergency repairs","Pavements: bituminous, semi-rigid","Corrective maintenance and replacement","Maintenance and replacement","Recovery","Stretch",-1,2,0,-2,0,"NO",0,0,0,0,-1,0,2,null,null,"3, 5"]
[450,"05 Loss of pavement integrity","05-3 Aggregate loss and detachment of pavement layers",{"$error":"#NAME?"},"New techniques for all weather emergency repairs","Pavements: bituminous, semi-rigid","Research","Research ","Recovery","Object - stretch",0,2,0,-1,0,"NO",2,0,0,0,1,0,2,null,null,39]
[451,"05 Loss of pavement integrity","05-3 Aggregate loss and detachment of pavement layers",{"$error":"#NAME?"},"Placing warning signs","Pavements: bituminous, semi-rigid","Traffic management","Traffic management","Preparation","Stretch - network",0,2,0,-1,0,"YES",2,-2,0,0,1,0,2,null,null,39]
[452,"05 Loss of pavement integrity","05-3 Aggregate loss and detachment of pavement layers",{"$error":"#NAME?"},"Rerouting and guidance","All road infrastructure","Traffic management","Traffic management","Response","TEN-T - national - regional",2,0,3,-2,-1,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures "]
[453,"05 Loss of pavement integrity","05-3 Aggregate loss and detachment of pavement layers",{"$error":"#NAME?"},"Revised standards for materials in surface courses","Pavements: bituminous, semi-rigid","Prevention","Legislation , regulations","Preparation","National network",1,1,0,0,0,"NO",2,0,0,0,1,0,1,null,null,"3, 5, 39"]
[454,"05 Loss of pavement integrity","05-3 Aggregate loss and detachment of pavement layers",{"$error":"#NAME?"},"Surface treatment or thin overlay","Pavements: bituminous, semi-rigid","Corrective maintenance and replacement","Maintenance and replacement","Recovery","Stretch",0,0,0,-2,0,"NO",0,0,0,0,-1,0,0,null,null,"3, 5"]
[455,"05 Loss of pavement integrity","05-4 Cracking due to weakening of the road base by thaw",{"$error":"#NAME?"},"Access restriction","Unpaved roads","Traffic management","Traffic management","Response","Regional network",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","MC: to certain categories of vehicles (e.g. HGV, vehicles with trailers, non-equipped vehicles …) ",26]
[456,"05 Loss of pavement integrity","05-4 Cracking due to weakening of the road base by thaw",{"$error":"#NAME?"},"Artificial cooling and/or extracting heat from the embankment","Unpaved roads","Prevention","Robust construction","Prevention","Object - stretch",2,0,1,-2,1,"NO",2,-2,0,0,0,0,0,null,null,47]
[457,"05 Loss of pavement integrity","05-4 Cracking due to weakening of the road base by thaw",{"$error":"#NAME?"},"Preventive maintenance before winter such as increase the width of lane for removal of snow","Unpaved roads","Corrective maintenance and replacement","Maintenance and replacement","Response","Regional network",1,0,1,-1,1,"NO",0,0,0,0,0,0,0,null,null,4]
[458,"05 Loss of pavement integrity","05-4 Cracking due to weakening of the road base by thaw",{"$error":"#NAME?"},"Increase the thickness of structural layers, using a more compact wearing course layer (SMA for example)","Pavements: bituminous, semi-rigid","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Stretch - network",1,0,1,-1,0,"NO",2,0,0,0,0,0,0,null,null,"4, 26"]
[459,"05 Loss of pavement integrity","05-4 Cracking due to weakening of the road base by thaw",{"$error":"#NAME?"},"Emergency repairs","Pavements: bituminous, semi-rigid","Corrective maintenance and replacement","Maintenance and replacement","Recovery","Stretch",-1,2,0,-2,0,"NO",0,0,0,0,-1,0,2,null,null,"3, 5"]
[460,"05 Loss of pavement integrity","05-4 Cracking due to weakening of the road base by thaw",{"$error":"#NAME?"},"Keeping the road drainage in good condition","Pavements: bituminous, concrete, semi-rigid","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Regional network",1,0,1,0,0,"NO",0,0,0,0,0,0,0,null,null,47]
[461,"05 Loss of pavement integrity","05-4 Cracking due to weakening of the road base by thaw",{"$error":"#NAME?"},"Keeping ditches and culverts free of snow and ice by means of good winter maintenance practices","Pavements: bituminous, concrete, semi-rigid","Preventive maintenance and replacement","Maintenance and replacement","Response","Regional network",1,0,1,0,0,"NO",0,0,0,0,0,0,0,null,null,47]
[462,"05 Loss of pavement integrity","05-4 Cracking due to weakening of the road base by thaw",{"$error":"#NAME?"},"Modal shift","Unpaved roads","Traffic management","Traffic management","Response","Object - stretch - network",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[463,"05 Loss of pavement integrity","05-4 Cracking due to weakening of the road base by thaw",{"$error":"#NAME?"},"Monitoring to detect potential problem areas,  establish cause-impact relationships; maintain specific construction and maintenance records","Unpaved roads","Monitoring and prediction","Monitoring","All","National network",0,0,0,0,0,"NO",0,0,0,0,1,0,0,null,null,47]
[464,"05 Loss of pavement integrity","05-4 Cracking due to weakening of the road base by thaw",{"$error":"#NAME?"},"Partial reconstruction of pavement","Unpaved roads","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",2,0,2,-2,1,"NO",2,0,0,0,0,0,0,null,null,4]
[465,"05 Loss of pavement integrity","05-4 Cracking due to weakening of the road base by thaw",{"$error":"#NAME?"},"Preventive information","Unpaved roads","Research","Research","Response","Object - stretch - network",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[466,"05 Loss of pavement integrity","05-4 Cracking due to weakening of the road base by thaw",{"$error":"#NAME?"},"Real time traffic information","All road infrastructure","Traffic management","Traffic management","Response","Object - stretch - network",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[467,"05 Loss of pavement integrity","05-4 Cracking due to weakening of the road base by thaw",{"$error":"#NAME?"},"Real time weather and traffic forecast","All road infrastructure","Research","Research","Response","Object - stretch - network",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[468,"05 Loss of pavement integrity","05-4 Cracking due to weakening of the road base by thaw",{"$error":"#NAME?"},"Rerouting and guidance","All road infrastructure","Traffic management","Traffic management","Response","TEN-T - national - regional",2,0,3,-2,-1,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[469,"05 Loss of pavement integrity","05-4 Cracking due to weakening of the road base by thaw",{"$error":"#NAME?"},"Revised standards materials in all layers, drainage","Unpaved roads","Prevention","Legislation , regulations","Preparation","National network",1,0,1,0,0,"NO",2,0,0,0,1,0,0,null,null,7]
[470,"05 Loss of pavement integrity","05-4 Cracking due to weakening of the road base by thaw",{"$error":"#NAME?"},"Speed limits ","Unpaved roads","Traffic management","Traffic management","Response","Stretch",2,3,0,-1,-1,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures "]
[471,"05 Loss of pavement integrity","05-5 Thermal expansion of pavements",{"$error":"#NAME?"},"Access restriction","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Preparation","Stretch - network",-2,0,-1,1,0,"YES",2,-2,0,0,1,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","MC: to certain categories of vehicles (e.g. HGV, vehicles with trailers, non-equipped vehicles …) ",39]
[472,"05 Loss of pavement integrity","05-5 Thermal expansion of pavements",{"$error":"#NAME?"},"Appropriate maintenance of joint seals to prevent clogging of joints","Concrete pavements","Preventive maintenance and replacement","Maintenance and replacement","Preparation","National network",1,0,0,1,0,"NO",0,0,0,0,0,0,0,null,null,"26, 39"]
[473,"05 Loss of pavement integrity","05-5 Thermal expansion of pavements",{"$error":"#NAME?"},"Harvesting of heat energy from the pavement","Concrete pavements","Research","Research","Prevention","Object",1,1,0,0,0,"YES",2,2,0,0,1,0,2,null,null,10]
[474,"05 Loss of pavement integrity","05-5 Thermal expansion of pavements",{"$error":"#NAME?"},"Heat resistant concrete fixings","Concrete pavements","Research","Research","Preparation","Object",1,0,1,0,0,"NO",2,0,0,0,0,0,0,null,null,10]
[475,"05 Loss of pavement integrity","05-5 Thermal expansion of pavements",{"$error":"#NAME?"},"Prevention of reflection cracking by fibre reinforcement or dedicated interface layers","Semi-rigid pavements","Upgrade / retrofitting / new construction","Resilient construction","Prevention","Stretch",1,0,1,0,0,"NO",2,0,0,0,1,0,1,null,null,7]
[476,"05 Loss of pavement integrity","05-5 Thermal expansion of pavements",{"$error":"#NAME?"},"Rerouting and guidance","Concrete pavements","Traffic management","Traffic management","Response","TEN-T - national - regional",2,0,3,-2,-1,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","Maybe only during day hours"]
[477,"05 Loss of pavement integrity","05-5 Thermal expansion of pavements",{"$error":"#NAME?"},"Revised standards for heat resilient pavements, including effects of dark surface courses,  joint width in JCP, terminal joint design in CRCP","Concrete pavements","Prevention","Legislation , regulations","Preparation","National network",1,0,1,0,0,"NO",2,0,0,0,1,0,0,null,null,"26, 33, 39"]
[478,"05 Loss of pavement integrity","05-5 Thermal expansion of pavements",{"$error":"#NAME?"},"Upgrade joint seal composition","Concrete pavements","Prevention","Resilient construction","Preparation","National network",1,0,1,0,0,"NO",2,0,0,0,1,0,0,null,null,"26, 33, 39"]
[479,"05 Loss of pavement integrity","05-5 Thermal expansion of pavements",{"$error":"#NAME?"},"Use a low coefficient of expansion coarse aggregates in the mixture","Concrete pavements","Prevention","Resilient construction","Preparation","National network",1,0,1,0,0,"NO",2,0,0,0,1,0,0,null,null,"26, 33, 39"]
[480,"06 Loss of driving ability due to extreme weather events","06-2 Reduced visibility during snowfall, heavy rain including splash and spray",{"$error":"#NAME?"},"Apply porous asphalt surface course","All road infrastructure","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch - network",1,0,1,-3,2,"NO",2,0,0,0,-2,2,0,null,"Applies to all threats",10]
[481,"06 Loss of driving ability due to extreme weather events","06-2 Reduced visibility during snowfall, heavy rain including splash and spray",{"$error":"#NAME?"},"Appropriate inspection and maintenance of in-pavement and road edge drainage","All road infrastructure","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Object - stretch - network",0,0,0,0,0,"NO",0,0,0,0,0,0,0,null,"Applies to all threats",10]
[482,"06 Loss of driving ability due to extreme weather events","06-2 Reduced visibility during snowfall, heavy rain including splash and spray",{"$error":"#NAME?"},"Increasing self-reliance of road users","All road infrastructure","Capacity building","Capacity building","Preparation","Object - stretch - network",1,2,2,1,-1,"NO",2,0,0,0,0,0,2,null,"Applies to all threats",1]
[483,"06 Loss of driving ability due to extreme weather events","06-2 Reduced visibility during snowfall, heavy rain including splash and spray",{"$error":"#NAME?"},"Real time traffic information","All road infrastructure","Traffic management","Traffic management","Response","Object - stretch - network",1,1,1,-1,0,"YES",2,1,0,0,0,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[484,"06 Loss of driving ability due to extreme weather events","06-2 Reduced visibility during snowfall, heavy rain including splash and spray",{"$error":"#NAME?"},"Real time weather and traffic forecast","All road infrastructure","Traffic management","Traffic management","Response","Object - stretch - network",-1,2,-1,2,-1,"NO",2,-2,0,0,1,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","Applies to all threats",10]
[485,"06 Loss of driving ability due to extreme weather events","06-2 Reduced visibility during snowfall, heavy rain including splash and spray",{"$error":"#NAME?"},"Speed limits","All road infrastructure","Traffic management","Traffic management","Response","Object - stretch - network",-1,2,0,0,0,"YES",2,-2,0,0,1,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","Applies to all threats",10]
[486,"06 Loss of driving ability due to extreme weather events","06-2 Reduced visibility during snowfall, heavy rain including splash and spray",{"$error":"#NAME?"},"Training of road owners for emergency situations","All road infrastructure","Capacity building","Capacity building","Preparation","Object - stretch - network",0,2,1,0,1,"NO",2,0,0,0,0,0,2,null,"Applies to all threats",1]
[487,"06 Loss of driving ability due to extreme weather events","06-3 Reduced vehicle control",{"$error":"#NAME?"},"Access restriction ","All road infrastructure","Traffic management","Traffic management","Response","Stretch",-3,2,-2,-2,-3,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","Can be for HGV only or some vehicle categories "]
[488,"06 Loss of driving ability due to extreme weather events","06-3 Reduced vehicle control",{"$error":"#NAME?"},"HGV Storage","All road infrastructure","Traffic management","Traffic management","Response","Stretch",-3,3,2,-3,-3,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures "]
[489,"06 Loss of driving ability due to extreme weather events","06-3 Reduced vehicle control",{"$error":"#NAME?"},"Increasing self-reliance of road users","All road infrastructure","Capacity building","Capacity building","Preparation","Object - stretch - network",1,2,2,1,-1,"NO",2,0,0,0,0,0,2,null,"Applies to all threats",1]
[490,"06 Loss of driving ability due to extreme weather events","06-3 Reduced vehicle control",{"$error":"#NAME?"},"Modal shift","All road infrastructure","Traffic management","Traffic management","Response","Object - stretch - network",-1,2,-1,2,-1,"YES",2,-2,0,0,1,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[491,"06 Loss of driving ability due to extreme weather events","06-3 Reduced vehicle control",{"$error":"#NAME?"},"Prepare contingency / emergency plans","All road infrastructure","Pro-active attitude","Planning","Pro-action","Regional network",0,2,1,0,-1,"NO",2,0,0,0,0,0,2,null,"Applies to all threats",1]
[492,"06 Loss of driving ability due to extreme weather events","06-3 Reduced vehicle control",{"$error":"#NAME?"},"Raising awareness among road owners and road users about climate change adaptation","All road infrastructure","Capacity building","Capacity building","All","Object - stretch - network",0,0,0,-1,1,"NO",2,0,0,0,0,0,0,null,"Applies to all threats",1]
[493,"06 Loss of driving ability due to extreme weather events","06-3 Reduced vehicle control",{"$error":"#NAME?"},"Real time traffic information","All road infrastructure","Traffic management","Traffic management","Response","Object - stretch - network",1,1,1,-1,0,"YES",2,1,0,0,0,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[494,"06 Loss of driving ability due to extreme weather events","06-3 Reduced vehicle control",{"$error":"#NAME?"},"Real time weather and traffic forecast","All road infrastructure","Research","Research","Response","Object - stretch - network",-1,2,-1,2,-1,"YES",2,-2,0,0,1,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[495,"06 Loss of driving ability due to extreme weather events","06-3 Reduced vehicle control",{"$error":"#NAME?"},"Rerouting and guidance","All road infrastructure","Traffic management","Traffic management","Response","TEN-T - national - regional",2,0,3,-2,-1,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","Can be for HGV only.",10]
[496,"06 Loss of driving ability due to extreme weather events","06-3 Reduced vehicle control",{"$error":"#NAME?"},"Speed limits ","All road infrastructure","Traffic management","Traffic management","Response","Stretch",2,3,0,-1,-1,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","Speed limits can be for certain vehicle categoires only (HGV, car with trailers, ..) "]
[497,"06 Loss of driving ability due to extreme weather events","06-3 Reduced vehicle control",{"$error":"#NAME?"},"Training of road owners for emergency situations","All road infrastructure","Capacity building","Capacity building","Preparation","Object - stretch - network",0,2,1,0,1,"NO",2,0,0,0,0,0,2,null,"Applies to all threats",1]
[498,"06 Loss of driving ability due to extreme weather events","06-4 Decrease in skid resistance on pavements from slight rain after a dry period",{"$error":"#NAME?"},"Apply exposed aggregate concrete surfacing","Concrete pavements","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch - network",1,0,0,-1,0,"NO",2,0,0,0,0,2,0,null,null,"26, 39"]
[499,"06 Loss of driving ability due to extreme weather events","06-4 Decrease in skid resistance on pavements from slight rain after a dry period",{"$error":"#NAME?"},"Cleaning pavement","Pavements: bituminous, concrete, semi-rigid","Corrective maintenance and replacement","Maintenance and replacement","Recovery","Stretch - network",0,1,0,-2,0,"NO",0,0,0,0,-1,0,1,null,null,26]
[500,"06 Loss of driving ability due to extreme weather events","06-4 Decrease in skid resistance on pavements from slight rain after a dry period",{"$error":"#NAME?"},"Placing warning signs","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Preparation","Stretch",0,2,0,-1,0,"YES",0,-2,0,0,0,0,2,null,null,26]
[501,"06 Loss of driving ability due to extreme weather events","06-4 Decrease in skid resistance on pavements from slight rain after a dry period",{"$error":"#NAME?"},"Revised standards for polishing resistance of aggregates in surface courses","Pavements: bituminous, concrete, semi-rigid","Prevention","Legislation , regulations","Preparation","Object - stretch - network",0,1,0,-1,0,"NO",2,0,0,0,1,0,1,null,null,39]
[502,"06 Loss of driving ability due to extreme weather events","06-4 Decrease in skid resistance on pavements from slight rain after a dry period",{"$error":"#NAME?"},"Speed limits","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","Stretch - network",-1,1,0,0,0,"YES",2,-2,0,0,1,0,1,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,26]
[503,"06 Loss of driving ability due to extreme weather events","06-5 Aquaplaning in ruts due to precipitation on the road, splash and spray",{"$error":"#NAME?"},"Appropriate inspection and maintenance of in-pavement and road edge drainage","Pavements: bituminous, concrete, semi-rigid","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Object - stretch - network",0,0,0,0,0,"NO",0,0,0,0,0,0,0,null,null,26]
[504,"06 Loss of driving ability due to extreme weather events","06-5 Aquaplaning in ruts due to precipitation on the road, splash and spray",{"$error":"#NAME?"},"Carriageway cross-over","All road infrastructure","Traffic management","Traffic management","Response","Stretch",-2,-1,0,-2,-2,"YES",1,2,2,0,-1,-1,1,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","If dual carriageway "]
[505,"06 Loss of driving ability due to extreme weather events","06-5 Aquaplaning in ruts due to precipitation on the road, splash and spray",{"$error":"#NAME?"},"Lane closure","All road infrastructure","Traffic management","Traffic management","Response","Stretch",-2,3,0,-2,-2,"YES",1,2,2,0,-1,-1,1,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","If a traffic lane still available"]
[506,"06 Loss of driving ability due to extreme weather events","06-5 Aquaplaning in ruts due to precipitation on the road, splash and spray",{"$error":"#NAME?"},"Placing warning signs","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Preparation","Stretch",0,2,0,1,0,"YES",0,-2,0,0,0,0,2,null,null,26]
[507,"06 Loss of driving ability due to extreme weather events","06-5 Aquaplaning in ruts due to precipitation on the road, splash and spray",{"$error":"#NAME?"},"Prepare Traffic Management Plans","All road infrastructure","Traffic management","Traffic management","Pro-action","TEN-T - national - regional",2,1,3,-1,2,"YES",1,2,2,0,-1,-1,1,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures "]
[508,"06 Loss of driving ability due to extreme weather events","06-5 Aquaplaning in ruts due to precipitation on the road, splash and spray",{"$error":"#NAME?"},"Preventive information","Pavements: bituminous, concrete, semi-rigid","Research","Research ","Response","Object - stretch - network",-1,2,-1,2,-1,"YES",2,-2,0,0,1,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[509,"06 Loss of driving ability due to extreme weather events","06-5 Aquaplaning in ruts due to precipitation on the road, splash and spray",{"$error":"#NAME?"},"Real time traffic information","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","Object - stretch - network",-1,2,-1,2,-1,"YES",2,-2,0,0,1,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[510,"06 Loss of driving ability due to extreme weather events","06-5 Aquaplaning in ruts due to precipitation on the road, splash and spray",{"$error":"#NAME?"},"Real time weather and traffic forecast","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","Object - stretch - network",-1,2,-1,2,-1,"YES",2,-2,0,0,1,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[511,"06 Loss of driving ability due to extreme weather events","06-5 Aquaplaning in ruts due to precipitation on the road, splash and spray",{"$error":"#NAME?"},"Rerouting and guidance","All road infrastructure","Traffic management","Traffic management","Response","TEN-T - national - regional",2,0,3,-2,-1,"YES",1,2,2,0,-1,-1,1,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures "]
[512,"06 Loss of driving ability due to extreme weather events","06-5 Aquaplaning in ruts due to precipitation on the road, splash and spray",{"$error":"#NAME?"},"Reservoir pavements for hydrograph attenuation","Pavements: bituminous, concrete, semi-rigid","Research","Research","Preparation","Stretch - network",1,0,1,-3,2,"NO",2,0,0,0,0,0,0,null,null,3]
[513,"06 Loss of driving ability due to extreme weather events","06-5 Aquaplaning in ruts due to precipitation on the road, splash and spray",{"$f":"VLOOKUP(C516,climate_par_table,2)","v":{"$error":"#NAME?"}},"Reservoir pavements for water quality improvement","Pavements: bituminous, concrete, semi-rigid","Research","Research","Prevention","Stretch - network",0,0,0,-3,0,"YES",2,0,0,2,0,0,0,null,"Not climate related?",3]
[514,"06 Loss of driving ability due to extreme weather events","06-5 Aquaplaning in ruts due to precipitation on the road, splash and spray",{"$error":"#NAME?"},"Revised standards for in-pavement and road edge drainage","Pavements: bituminous, concrete, semi-rigid","Prevention","Legislation , regulations","Preparation","Object - stretch - network",1,2,0,-1,0,"NO",2,0,0,0,1,0,2,null,null,26]
[515,"06 Loss of driving ability due to extreme weather events","06-5 Aquaplaning in ruts due to precipitation on the road, splash and spray",{"$error":"#NAME?"},"Revised standards for materials in surface courses","Pavements: bituminous, concrete, semi-rigid","Prevention","Legislation , regulations","Preparation","Object - stretch - network",1,2,0,0,0,"NO",2,0,0,0,1,0,2,null,null,26]
[516,"06 Loss of driving ability due to extreme weather events","06-5 Aquaplaning in ruts due to precipitation on the road, splash and spray",{"$error":"#NAME?"},"Speed limits","All road infrastructure","Traffic management","Traffic management","Response","Stretch",2,3,0,-1,-1,"YES",1,2,1,1,-1,1,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","Only for limited flooding"]
[517,"06 Loss of driving ability due to extreme weather events","06-5 Aquaplaning in ruts due to precipitation on the road, splash and spray",{"$error":"#NAME?"},"Systems for pavement surface drainage that are more reliable, and easier to inspect and maintain","Pavements: bituminous, concrete, semi-rigid","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch - network",1,0,1,1,0,"NO",2,0,0,0,1,0,0,null,null,26]
[520,"06 Loss of driving ability due to extreme weather events","06-6 Decrease in skid resistance on pavements from migration of liquid bitumen",{"$error":"#NAME?"},"Harvesting of heat energy from the pavement","Pavements: bituminous, concrete, semi-rigid","Research","Research","Prevention","Object - stretch",0,2,0,0,1,"YES",2,2,0,0,1,0,2,null,null,10]
[522,"06 Loss of driving ability due to extreme weather events","06-6 Decrease in skid resistance on pavements from migration of liquid bitumen",{"$error":"#NAME?"},"Placing warning signs","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Preparation","Stretch - network",0,2,0,-1,0,"YES",2,-2,0,0,1,0,2,null,null,39]
[523,"06 Loss of driving ability due to extreme weather events","06-6 Decrease in skid resistance on pavements from migration of liquid bitumen",{"$error":"#NAME?"},"Prepare contingency / emergency plans","Pavements: bituminous, semi-rigid","Pro-active attitude","Planning","Pro-action","Stretch - network",0,2,0,0,0,"YES",2,-2,0,0,1,0,2,null,null,39]
[518,"06 Loss of driving ability due to extreme weather events","06-6 Decrease in skid resistance on pavements from migration of liquid bitumen",{"$error":"#NAME?"},"Anti-oxidation additives","Pavements: bituminous, concrete, semi-rigid","Research","Research","Preparation","National network",1,0,0,0,0,"NO",2,0,0,0,1,0,2,null,null,"4, 39"]
[524,"06 Loss of driving ability due to extreme weather events","06-6 Decrease in skid resistance on pavements from migration of liquid bitumen",{"$error":"#NAME?"},"Real time traffic information","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","Object - stretch - network",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,null,null,10]
[521,"06 Loss of driving ability due to extreme weather events","06-6 Decrease in skid resistance on pavements from migration of liquid bitumen",{"$error":"#NAME?"},"High albedo pavements, heat shield pavements, water retention pavements","Pavements: bituminous, concrete, semi-rigid","Research","Research","Prevention","Stretch - network",1,1,0,-1,0,"NO",2,0,0,0,1,0,1,null,null,"4, 10, 39"]
[525,"06 Loss of driving ability due to extreme weather events","06-6 Decrease in skid resistance on pavements from migration of liquid bitumen",{"$error":"#NAME?"},"Replace by more temperature resilient material","Pavements: bituminous, concrete, semi-rigid","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Stretch - network",1,1,0,0,0,"NO",2,0,0,0,1,0,1,null,null,39]
[526,"06 Loss of driving ability due to extreme weather events","06-6 Decrease in skid resistance on pavements from migration of liquid bitumen",{"$error":"#NAME?"},"Rerouting and guidance","Bituminous pavements","Traffic management","Traffic management","Recovery","TEN-T - national - regional",2,0,3,-2,-1,"YES",1,2,2,0,-1,-1,1,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ","Applies to all threats"]
[519,"06 Loss of driving ability due to extreme weather events","06-6 Decrease in skid resistance on pavements from migration of liquid bitumen",{"$error":"#NAME?"},"Cold mill and overlay, thin surface patches","Pavements: bituminous, concrete, semi-rigid","Corrective maintenance and replacement","Maintenance and replacement","Recovery","Stretch",-1,1,0,-1,0,"NO",0,0,0,0,-1,0,2,null,null,"7, 39"]
[528,"06 Loss of driving ability due to extreme weather events","06-6 Decrease in skid resistance on pavements from migration of liquid bitumen",{"$error":"#NAME?"},"Speed limits","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","Stretch - network",-1,0,-1,2,-1,"YES",2,-2,0,0,1,0,0,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,39]
[527,"06 Loss of driving ability due to extreme weather events","06-6 Decrease in skid resistance on pavements from migration of liquid bitumen",{"$error":"#NAME?"},"Revised standards for materials in surface courses","Pavements: bituminous, concrete, semi-rigid","Prevention","Legislation , regulations","Preparation","National network",1,1,0,0,0,"NO",2,0,0,0,1,0,1,null,null,42]
[529,"06 Loss of driving ability due to extreme weather events","06-6 Decrease in skid resistance on pavements from migration of liquid bitumen",{"$error":"#NAME?"},"Treat with hot fine aggregate","Pavements: bituminous, concrete, semi-rigid","Corrective maintenance and replacement","Maintenance and replacement","Recovery","Stretch",-1,1,0,-1,0,"NO",0,0,0,0,-1,0,2,null,null,39]
[530,"06 Loss of driving ability due to extreme weather events","06-7 Icing and snow",{"$error":"#NAME?"},"De-icing agents that cause less damage to pavements and the environment","Pavements: bituminous, concrete, semi-rigid","Research","Research","Preparation","Regional network",1,0,0,0,0,"NO",2,0,0,2,0,0,0,null,null,"-"]
[531,"06 Loss of driving ability due to extreme weather events","06-7 Icing and snow",{"$error":"#NAME?"},"Deployment of de-icing agents","Pavements: bituminous, concrete, semi-rigid","Corrective maintenance and replacement","Maintenance and replacement","Response","Regional network",0,0,0,0,0,"NO",0,0,0,0,-1,0,0,null,null,"-"]
[532,"06 Loss of driving ability due to extreme weather events","06-7 Icing and snow",{"$error":"#NAME?"},"Deployment of snow moving equipment","Pavements: bituminous, concrete, semi-rigid","Corrective maintenance and replacement","Maintenance and replacement","Response","Regional network",0,0,0,0,0,"NO",0,0,0,0,-1,0,0,null,null,"-"]
[533,"06 Loss of driving ability due to extreme weather events","06-7 Icing and snow",{"$error":"#NAME?"},"Increasing self-reliance of road users","All road infrastructure","Capacity building","Capacity building","Preparation","Object - stretch - network",1,2,2,1,-1,"NO",2,0,0,0,0,0,2,null,"Applies to all threats",1]
[534,"06 Loss of driving ability due to extreme weather events","06-7 Icing and snow",{"$error":"#NAME?"},"Modal shift","All road infrastructure","Traffic management","Traffic management","Response","Regional network",1,2,1,-1,-1,"YES",2,1,0,0,0,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[535,"06 Loss of driving ability due to extreme weather events","06-7 Icing and snow",{"$error":"#NAME?"},"Preventive information","All road infrastructure","Research","Research","Response","Object - stretch - network",1,2,1,-1,-1,"YES",2,1,0,0,0,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[536,"06 Loss of driving ability due to extreme weather events","06-7 Icing and snow",{"$error":"#NAME?"},"Real time traffic information","All road infrastructure","Traffic management","Traffic management","Response","Regional network",1,2,1,-1,-1,"YES",2,1,0,0,0,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[537,"06 Loss of driving ability due to extreme weather events","06-7 Icing and snow",{"$error":"#NAME?"},"Real time weather and traffic forecast","All road infrastructure","Research","Research ","Response","Regional network",1,2,1,-1,-1,"YES",2,1,0,0,0,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[538,"06 Loss of driving ability due to extreme weather events","06-7 Icing and snow",{"$error":"#NAME?"},"Rerouting and guidance","All road infrastructure","Traffic management","Traffic management","Response","Regional network",1,2,1,-1,-1,"YES",2,1,0,0,0,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[539,"06 Loss of driving ability due to extreme weather events","06-7 Icing and snow",{"$error":"#NAME?"},"Speed limits","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","Stretch - network",1,2,1,-1,-1,"YES",2,1,0,0,0,0,2,"Real time weather and traffic forecasts, preventive information, real time traffic info, modal shift, are parts of all traffic management adaptation measures ",null,10]
[540,"06 Loss of driving ability due to extreme weather events","06-7 Icing and snow",{"$error":"#NAME?"},"Supplying heat to the pavement, harvested in summer and stored underground","Pavements: bituminous, concrete, semi-rigid","Research","Research","Prevention","Stretch",1,1,1,-2,0,"YES",2,2,0,0,0,0,1,null,null,10]
[541,"06 Loss of driving ability due to extreme weather events","06-7 Icing and snow",{"$error":"#NAME?"},"Training of road owners for emergency situations","All road infrastructure","Capacity building","Capacity building","Preparation","Object - stretch - network",0,2,1,0,1,"NO",2,0,0,0,0,0,2,null,"Applies to all threats",1]
[542,"07 Reduced ability for maintenance","07-2 Ice removal costs",{"$error":"#NAME?"},"De-icing agents that cause less damage to pavements and the environment","Pavements: bituminous, concrete, semi-rigid","Research","Research","Preparation","Regional network",1,0,0,0,0,"NO",2,0,0,2,0,0,0,null,null,"-"]
[543,"07 Reduced ability for maintenance","07-2 Ice removal costs",{"$error":"#NAME?"},"Supplying heat to the pavement, harvested in summer and stored underground","Pavements: bituminous, concrete, semi-rigid","Research","Research","Prevention","Stretch",1,1,1,-2,0,"YES",2,2,0,0,0,0,1,null,null,10]
[544,"07 Reduced ability for maintenance","07-3 Impact on road works: decreased time window for paving",{"$error":"#NAME?"},"Alternative mixtures for bituminous pavements and surface courses","Bituminous pavements","Research","Research","Preparation","Stretch",1,0,0,-1,0,"NO",2,0,0,0,1,0,2,null,null,26]
[547,"07 Reduced ability for maintenance","07-3 Impact on road works: decreased time window for paving",{"$error":"#NAME?"},"Restrict working in high temperatures","Bituminous pavements","Prevention","Resilient construction","Prevention","Stretch",1,0,1,-1,0,"NO",0,0,0,0,1,0,1,null,null,39]
[545,"07 Reduced ability for maintenance","07-3 Impact on road works: decreased time window for paving",{"$error":"#NAME?"},"Alternative mixtures for concrete pavements","Concrete pavements","Research","Research","Preparation","Stretch",1,0,0,-1,0,"NO",2,0,0,0,1,0,2,null,null,26]
[546,"07 Reduced ability for maintenance","07-3 Impact on road works: decreased time window for paving",{"$error":"#NAME?"},"Modify the concrete mixture to ensure adequate workability and curing time","Concrete pavements","Prevention","Resilient construction","Prevention","Stretch",1,0,0,-1,0,"NO",2,0,0,0,1,0,2,null,null,26]
[548,"07 Reduced ability for maintenance","07-3 Impact on road works: decreased time window for paving",{"$error":"#NAME?"},"Restrict working in high temperatures","Concrete pavements","Prevention","Resilient construction","Prevention","Stretch",1,0,1,-1,0,"NO",0,0,0,0,1,0,1,null,null,39]
[549,"07 Reduced ability for maintenance","07-3 Impact on road works: decreased time window for paving",{"$error":"#NAME?"},"Restrict concrete paving during periods of heavy rain","Concrete pavements","Prevention","Resilient construction","Prevention","Stretch",1,0,1,-1,0,"NO",0,0,0,0,1,0,1,null,null,39]
[550,"07 Reduced ability for maintenance","07-3 Impact on road works: decreased time window for paving",{"$error":"#NAME?"},"Working during the night","Bituminous pavements","Prevention","Resilient construction","Prevention","Stretch",1,0,1,-1,0,"NO",0,0,0,0,1,0,-1,null,null,26]
[551,"07 Reduced ability for maintenance","07-3 Impact on road works: decreased time window for paving",{"$error":"#NAME?"},"Working during the night","Concrete pavements","Prevention","Resilient construction","Prevention","Stretch",1,0,1,-1,0,"NO",0,0,0,0,1,0,-1,null,null,26]

{"sheet":"Policy matrix @ threat","index":1,"n_rows":87,"n_cols":21,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
[null,"Threat main category :",{"$f":"B28","v":"04 Loss of road structure integrity"},null,"‘Do minimum’ and ‘Develop contingency plans’ strategy"]
[null,"Threat sub category :",{"$f":"C28","v":"04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels"},null,"‘Future-proof designs’, ‘Retrofit solutions’ and ‘Update operating procedures’ strategies"]
[null,"Climate parameter :",{"$f":"D28","v":"Seasonal and annual average rainfall, sea level rise, extreme wind speed, wind direction (-> storm surge)"},null,"‘Monitoring’ strategy"]
[null,null,null,null,"‘Research’ strategy"]
[]
[null,"STAGES","PRO-ACTION","PREVENTION","PREPARATION",null,"RESPONSE",null,"RECOVERY"]
[null,null,null,null,"In preparation of an extreme event","Just before an extreme event","During an extreme event","Just after an extreme event","After an extreme event"]
[null,"OBJECTIVES","Enable smooth and safe traffic",null,"Support disaster consequence reduction","Evacuation route, life supply route","Minimizing loss of functions","Supply route for repairs and humanitarian aid","Supply route for recovery of affected area"]
["CATEGORY OF ADAPTATION MEASURE","Planning for CCI&EWE",{"$f":"IF(LEN(L25)>0,\"PRO-ACTIVE ATTITUDE: \"&LEFT(L25,LEN(L25)-2),\"\")","v":{"$error":"#NAME?"}},null,null,{"$f":"IF(LEN(R25)>0,\"EXTREME EVENT MANAGEMENT: \"&LEFT(R25,LEN(R25)-2),\"\")","v":{"$error":"#NAME?"}}]
[null,"Robust construction",null,{"$f":"IF(LEN(M25)>0,\"PREVENTION: \"&LEFT(M25,LEN(M25)-2),\"\")","v":{"$error":"#NAME?"}}]
[null,"Legislation , regulations"]
[null,"Resilient construction",null,{"$f":"IF(LEN(N25)>0,\"UPGRADE, RETROFIT, NEW CONSTRUCTION: \"&LEFT(N25,LEN(N25)-2),\"\")","v":{"$error":"#NAME?"}}]
[null,"Maintenance and management",null,null,{"$f":"IF(LEN(O25)>0,\"PREVENTIVE MAINTENANCE AND REPLACEMENT: \"&LEFT(O25,LEN(O25)-2),\"\")","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(LEN(P25)>0,\"CORRECTIVE MAINTENANCE AND REPLACEMENT: \"&LEFT(P25,LEN(P25)-2),\"\")","v":{"$error":"#NAME?"}}]
[null,"Traffic management for CCI&EWE",null,{"$f":"IF(LEN(Q25)>0,\"TRAFFIC MANAGEMENT: \"&LEFT(Q25,LEN(Q25)-2),\"\")","v":{"$error":"#NAME?"}}]
[null,"Capacity building",{"$f":"IF(LEN(S25)>0,\"CAPACITY BUILDING: \"&LEFT(S25,LEN(S25)-2),\"\")","v":{"$error":"#NAME?"}}]
[null,"Monitoring",{"$f":"IF(LEN(T25)>0,\"MONITORING AND PREDICTION: \"&LEFT(T25,LEN(T25)-2),\"\")","v":{"$error":"#NAME?"}}]
[null,"Research ",{"$f":"IF(LEN(U25)>0,\"RESEARCH: \"&LEFT(U25,LEN(U25)-2),\"\")","v":{"$error":"#NAME?"}}]
[]
[null,"CCI&EWE = Climate Change Impacts and Extreme Weather Events","PRO-ACTION phase: aims to rule out the possibility of an extreme event, e.g. flood defences to prevent flooding","PREVENTION phase: aims to eliminate vulnerability, e.g. raising a road above the High Water Level","PREPARATION phase 1: aims to reduce consequences, e.g. erosion proofing of a road","PREPARATION phase 2: aims to support evacuation, e.g. provide shelter locations","RESPONSE phase 1: aims to minimize damage, e.g. shutting down systems","RESPONSE phase 2: aims to guide emergency transport, e.g. restricting heavy traffic on saturated roads","RECOVERY phase: aims to restore transport functionality, e.g. deployment of repairs"]
[null,"SHIFT+CTRL+F:","format for Step 6 tables"]
[null,"CTRL+R:","remove all selections and filters, unhide hidden data"]
[null,"CTRL+Y: ","fill with measures selected in column A in worksheet Measures"]
[]
[null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"L24+1","v":2},{"$f":"M24+1","v":3},{"$f":"N24+1","v":4},{"$f":"O24+1","v":5},{"$f":"P24+1","v":6},{"$f":"Q24+1","v":7},{"$f":"R24+1","v":8},{"$f":"S24+1","v":9},{"$f":"T24+1","v":10}]
[null,null,null,null,null,null,null,null,null,null,"summary of measures ->",{"$f":"CONCATENATE(L28,L29,L30,L31,L32,L33,L34,L35,L36,L37,L38,L39,L40,L41,L42,L43,L44,L45,L46,L47)&CONCATENATE(L48,L49,L50,L51,L52,L53,L54,L55,L56,L57,L58,L59,L60,L61,L62,L63,L64,L65,L66,L67)&CONCATENATE(L68,L69,L70,L71,L72,L73,L74,L75,L76,L77,L78,L79,L80,L81,L82,L83,L84,L85,L86,L87)","v":{"$error":"#NAME?"}},{"$f":"CONCATENATE(M28,M29,M30,M31,M32,M33,M34,M35,M36,M37,M38,M39,M40,M41,M42,M43,M44,M45,M46,M47)&CONCATENATE(M48,M49,M50,M51,M52,M53,M54,M55,M56,M57,M58,M59,M60,M61,M62,M63,M64,M65,M66,M67)&CONCATENATE(M68,M69,M70,M71,M72,M73,M74,M75,M76,M77,M78,M79,M80,M81,M82,M83,M84,M85,M86,M87)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,"Scale","Strategy code","Pro-active attitude","Prevention","Upgrade / retrofitting / new construction","Preventive maintenance and replacement","Corrective maintenance and replacement","Traffic management","Extreme event management","Capacity building","Monitoring and prediction","Research"]
[]
[342,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels","Seasonal and annual average rainfall, sea level rise, extreme wind speed, wind direction (-> storm surge)","Access restriction","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","Stretch",{"$f":"IF(ISBLANK(A28),0,MATCH(G28,Strat_table,0))","v":{"$error":"#NAME?"}},{"$f":"IF($K28=L$24,$E28&\" / \",\"\")","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[343,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels","Seasonal and annual average rainfall, sea level rise, extreme wind speed, wind direction (-> storm surge)","Application of geotextiles in (sub)base","Pavements: bituminous, concrete, semi-rigid","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Stretch",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[344,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels","Seasonal and annual average rainfall, sea level rise, extreme wind speed, wind direction (-> storm surge)","Develop binders that are more resilient to stripping","Pavements: bituminous, concrete, semi-rigid","Research","Research ","Preparation","Object - stretch - network",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[345,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels","Seasonal and annual average rainfall, sea level rise, extreme wind speed, wind direction (-> storm surge)","Full depth patches","Pavements: bituminous, concrete, semi-rigid","Corrective maintenance and replacement","Maintenance and replacement","Recovery","Object",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[346,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels","Seasonal and annual average rainfall, sea level rise, extreme wind speed, wind direction (-> storm surge)","Improving drainage of the area","Pavements: bituminous, concrete, semi-rigid","Prevention","Robust construction","Prevention","Regional network",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[347,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels","Seasonal and annual average rainfall, sea level rise, extreme wind speed, wind direction (-> storm surge)","Improved models for bearing capacity of pavements after flooding","Pavements: bituminous, concrete, semi-rigid","Research","Research ","Preparation","Object - stretch - network",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[348,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels","Seasonal and annual average rainfall, sea level rise, extreme wind speed, wind direction (-> storm surge)","In situ strengthening of granular (sub)bases and subgrade soils, using articificial or natural cements","Pavements: bituminous, concrete, semi-rigid","Research","Research","Preparation","Stretch",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[349,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels","Seasonal and annual average rainfall, sea level rise, extreme wind speed, wind direction (-> storm surge)","Increase the thickness of structural layers","Pavements: bituminous, concrete, semi-rigid","Upgrade / retrofitting / new construction","Resilient construction","Preparation","Object - stretch",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[350,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels","Seasonal and annual average rainfall, sea level rise, extreme wind speed, wind direction (-> storm surge)","Keeping the road drainage in good condition","Pavements: bituminous, concrete, semi-rigid","Preventive maintenance and replacement","Maintenance and replacement","Preparation","Regional network",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[351,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels","Seasonal and annual average rainfall, sea level rise, extreme wind speed, wind direction (-> storm surge)","Lowering the groundwater table within the road embankment with deeper drainage","Pavements: bituminous, concrete, semi-rigid","Prevention","Robust construction","Prevention","Object - stretch",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[352,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels","Seasonal and annual average rainfall, sea level rise, extreme wind speed, wind direction (-> storm surge)","Modal shift","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","Stretch",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[353,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels","Seasonal and annual average rainfall, sea level rise, extreme wind speed, wind direction (-> storm surge)","Monitoring to detect potential problem areas,  establish cause-impact relationships; maintain specific construction and maintenance records","Pavements: bituminous, concrete, semi-rigid","Monitoring and prediction","Monitoring","All","Stretch",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[552,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels","Seasonal and annual average rainfall, sea level rise, extreme wind speed, wind direction (-> storm surge)","Monitoring of water levels in the road embankment after flooding","Pavements: bituminous, concrete, semi-rigid","Monitoring and prediction","Monitoring","Response","Stretch",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[354,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels","Seasonal and annual average rainfall, sea level rise, extreme wind speed, wind direction (-> storm surge)","Preventive information","Pavements: bituminous, concrete, semi-rigid","Research","Research","Response","Object - stretch - network",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[355,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels","Seasonal and annual average rainfall, sea level rise, extreme wind speed, wind direction (-> storm surge)","Real time traffic information","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","Stretch",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[356,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels","Seasonal and annual average rainfall, sea level rise, extreme wind speed, wind direction (-> storm surge)","Real time weather and traffic forecast","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","Stretch",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[357,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels","Seasonal and annual average rainfall, sea level rise, extreme wind speed, wind direction (-> storm surge)","Rerouting and guidance","Pavements: bituminous, concrete, semi-rigid","Traffic management","Traffic management","Response","TEN-T - national - regional",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[358,"04 Loss of road structure integrity","04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels","Seasonal and annual average rainfall, sea level rise, extreme wind speed, wind direction (-> storm surge)","Revised standards for binder course, (sub)base and subgrade materials, drainage","Pavements: bituminous, concrete, semi-rigid","Prevention","Legislation , regulations","Preparation","Object - stretch - network",{"$error":"#NAME?"},{"$f":"IF($K45=L$24,$E45&\" / \",\"\")","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF($K69=L$24,$E69&\" / \",\"\")","v":""},"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(A78),0,MATCH(G78,Strat_table,0))","v":0},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF($K85=L$24,$E85&\" / \",\"\")","v":""},"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","",""]

{"sheet":"References","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Categories vs. Stages","index":3,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"STAGES","PRO-ACTION","PREVENTION","PREPARATION",null,"RESPONSE",null,"RECOVERY"]
[null,null,null,null,null,"In preparation of an extreme event","Just before an extreme event","During an extreme event","Just after an extreme event","After an extreme event"]
[null,"Activity category","OBJECTIVES","Enable smooth and safe traffic",null,"Support disaster consequence reduction","Evacuation route, life supply route","Minimizing loss of functions","Supply route for repairs and humanitarian aid","Supply route for recovery of affected area"]
["CATEGORY OF ADAPTATION MEASURE","SP Defining and managing network strategy and planning","Planning for CCI&EWE","Pro-active attitude",null,null,"Extreme event management"]
[null,"DC Design and construction of new and replacement assets","Robust construction",null,"Prevention"]
[null,null,"Legislation , regulations"]
[null,null,"Resilient construction",null,"Upgrade, retrofit, new construction"]
[null,"MM Maintenance and management of existing assets","Maintenance and management",null,null,"Preventive Maintenance and Replacement",null,null,null,"Corrective Maintenance and Replacement"]
[null,"NW managing network operation","Traffic management for CCI&EWE",null,"Traffic management"]
[null,null,"Capacity building","Capacity buIlding"]
[null,null,"Monitoring","Monitoring and prediction"]
[null,null,"Research ","Research"]
[]
[null,null,"CCI&EWE = Climate Change Impacts and Extreme Weather Events","PRO-ACTION phase: aims to rule out the possibility of an extreme event, e.g. flood defences to prevent flooding","PREVENTION phase: aims to eliminate vulnerability, e.g. raising a road above the High Water Level","PREPARATION phase 1: aims to reduce consequences, e.g. erosion proofing of a road","PREPARATION phase 2: aims to support evacuation, e.g. provide shelter locations","RESPONSE phase 1: aims to minimize damage, e.g. shutting down systems","RESPONSE phase 2: aims to guide emergency transport, e.g. restricting heavy traffic on saturated roads","RECOVERY phase: aims to restore transport functionality, e.g. deployment of repairs"]
[null,"Highway Agency generic options:"]

{"sheet":"Drop down lists","index":4,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[]
["RIMAROCC Guideline Flipped Table 1 v2","RIMAROCC Guideline Table 1","ROADAPT WP description","ROADAPT meeting Sep 2013",null,"ROADAPT meeting Sep 2013","ROADAPT meeting Sep 2013","RIMAROCC Guideline","ROADAPT meeting September 2013","ROADAPT meeting April 2013"]
["Threat main category","Threat sub category","Asset type","Policy",null,"Categorie of measure","Stage","Scale","Qualitative score on criteria / Contribution to sustainability criteria","Green"]
["01 Flooding of road surface (assuming no traffic is possible)","01-1 flooding due to failure of flood defence system of rivers and canals","Geotechnics, including landslips and rock falls, cuts","Pro-active attitude",1,"Capacity building","Pro-action","Object - stretch - network","-3","YES"]
["02 Erosion of road embankments and foundations","01-2 pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)","Drainage of earthworks and pavements, sewers","Prevention",2,"Legislation , regulations","Prevention","TEN-T EU network","-2","NO"]
["03 Landslips and avalanches","01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges","Pavements: bituminous, concrete, semi-rigid","Upgrade / retrofitting / new construction",3,"Maintenance and replacement","Preparation","TEN-T - national - regional",-1]
["04 Loss of road structure integrity","01-4 Flooding from snow melt (overland flow after snow melt)","Pavements: bituminous, semi-rigid","Preventive maintenance and replacement",4,"Monitoring","Response","National network","0"]
["05 Loss of pavement integrity","02-1 Overloading of hydraulic systems crossing the road","Bituminous pavements","Corrective maintenance and replacement",5,"Planning","Recovery","Regional network",1]
["06 Loss of driving ability due to extreme weather events","02-2 Erosion of road bases","Concrete pavements","Traffic management",6,"Research ","All","Stretch - network","2"]
["07 Reduced ability for maintenance","02-3 Bridge scour","Semi-rigid pavements","Extreme event management",7,"Resilient construction",null,"Stretch","3"]
["08 Susceptibility to wildfires that threaten the transportation infrastructure directly","03-1 External slides affecting the road","Brick pavement","Capacity building",8,"Robust construction",null,"Object - stretch"]
["09 Damage to signs, lighting fixtures and supports","03-2 Slides of the road embankment","Unpaved roads","Monitoring and prediction",9,"Traffic management",null,"Object"]
["10 Trees falling on the road","03-3 Debris flow","Mobility services","Research"]
[null,"03-4 Rock fall","All road infrastructure"]
[null,"03-5 Snow avalanches","Tunnels, low lying stretches and light weight embankments"]
[null,"04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels","Structures: bridges, culverts, tunnels, retaining walls, restraint systems, gantries, masts"]
[null,"04-2 Weakening of the road base by standing water","Signs and signals, CCTV systems, emergency systems, lighting, roadmarkings"]
[null,"04-3 (Unequal) settlements of roads by consolidation","Non motorized users facilities"]
[null,"04-4 Instability / subsidence of roads by thawing of permafrost"]
[null,"04-5 Uplift of tunnels or light weight construction materials by increasing water levels"]
[null,"05-1 Cracking, rutting, embrittlement"]
[null,"05-2 Frost heave"]
[null,"05-3 Aggregate loss and detachment of pavement layers"]
[null,"05-4 Cracking due to weakening of the road base by thaw"]
[null,"05-5 Thermal expansion of pavements"]
[null,"05-6 Decreased utility of (unimproved) roads that rely on frozen ground"]
[null,"06-1 Reduced visibility"]
[null,"06-2 Reduced visibility during snowfall, heavy rain including splash and spray"]
[null,"06-3 Reduced vehicle control"]
[null,"06-4 Decrease in skid resistance on pavements from slight rain after a dry period"]
[null,"06-5 Aquaplaning in ruts due to precipitation on the road, splash and spray"]
[null,"06-6 Decrease in skid resistance on pavements from migration of liquid bitumen"]
[null,"06-7 Icing and snow"]
[null,"07-1 Snow removal costs"]
[null,"07-2 Ice removal costs"]
[null,"07-3 Impact on road works: decreased time window for paving"]
[null,"08-1 Susceptibility to wildfires that threaten the transportation infrastructure directly"]
[null,"09-1 Damage to signs, lighting fixtures and supports"]
[null,"10-1 Trees falling on the road"]

{"sheet":"Stats","index":5,"n_rows":40,"n_cols":18,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["yellow = NOT considered in measures database"]
[]
["RIMAROCC Guideline Flipped Table 1 v2",null,"RIMAROCC Guideline Table 1",null,"ROADAPT WP description",null,"ROADAPT meeting Sep 2013",null,"ROADAPT meeting Sep 2013",null,"ROADAPT meeting Sep 2013",null,"RIMAROCC Guideline",null,"ROADAPT meeting September 2013",null,"ROADAPT meeting April 2013"]
["Threat main category","no","Threat sub category","no","Asset type","no","Policy","no","Categorie of measure","no","Stage","no","Scale","no","Qualitative score on criteria / Contribution to sustainability criteria","no","Green","no"]
["01 Flooding of road surface (assuming no traffic is possible)",{"$f":"COUNTIF(Measures!$B$4:$B$554,Stats!A5)","v":146},"01-1 flooding due to failure of flood defence system of rivers and canals",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C5)","v":36},"Geotechnics, including landslips and rock falls, cuttings",{"$f":"COUNTIF(Measures!$F$4:$F$554,Stats!E5)","v":5},"Pro-active attitude",{"$f":"COUNTIF(Measures!$G$4:$G$554,Stats!G5)","v":122},"Planning",{"$f":"COUNTIF(Measures!$H$4:$H$554,Stats!I5)","v":71},"Pro-action",{"$f":"COUNTIF(Measures!$I$4:$I$554,Stats!K5)","v":173},"Object - stretch - network",{"$f":"COUNTIF(Measures!$J$4:$J$554,Stats!M5)","v":114},"-3",{"$f":"COUNTIF(Measures!$Q$4:$W$554,Stats!O5)","v":57},"YES",{"$f":"COUNTIF(Measures!$P$4:$P$554,Stats!Q5)","v":332}]
["02 Erosion of road embankments and foundations",{"$f":"COUNTIF(Measures!$B$4:$B$554,Stats!A6)","v":97},"01-2 pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C6)","v":46},"Drainage of earthworks and pavements, sewers",{"$f":"COUNTIF(Measures!$F$4:$F$554,Stats!E6)","v":53},"Prevention",{"$f":"COUNTIF(Measures!$G$4:$G$554,Stats!G6)","v":88},"Robust construction",{"$f":"COUNTIF(Measures!$H$4:$H$554,Stats!I6)","v":108},"Prevention",{"$f":"COUNTIF(Measures!$I$4:$I$554,Stats!K6)","v":88},"TEN-T EU network",{"$f":"COUNTIF(Measures!$J$4:$J$554,Stats!M6)","v":0},"-2",{"$f":"COUNTIF(Measures!$Q$4:$W$554,Stats!O6)","v":212},"NO",{"$f":"COUNTIF(Measures!$P$4:$P$554,Stats!Q6)","v":219}]
["03 Landslips and avalanches",{"$f":"COUNTIF(Measures!$B$4:$B$554,Stats!A7)","v":97},"01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C7)","v":34},"Pavements: bituminous, concrete, semi-rigid",{"$f":"COUNTIF(Measures!$F$4:$F$554,Stats!E7)","v":108},"Upgrade / retrofitting / new construction",{"$f":"COUNTIF(Measures!$G$4:$G$554,Stats!G7)","v":62},"Legislation , regulations",{"$f":"COUNTIF(Measures!$H$4:$H$554,Stats!I7)","v":27},"Preparation",{"$f":"COUNTIF(Measures!$I$4:$I$554,Stats!K7)","v":134},"TEN-T - national - regional",{"$f":"COUNTIF(Measures!$J$4:$J$554,Stats!M7)","v":32},-1,{"$f":"COUNTIF(Measures!$Q$4:$W$554,Stats!O7)","v":394}]
["04 Loss of road structure integrity",{"$f":"COUNTIF(Measures!$B$4:$B$554,Stats!A8)","v":74},"01-4 Flooding from snow melt (overland flow after snow melt)",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C8)","v":30},"Pavements: bituminous, semi-rigid",{"$f":"COUNTIF(Measures!$F$4:$F$554,Stats!E8)","v":16},"Preventive maintenance and replacement",{"$f":"COUNTIF(Measures!$G$4:$G$554,Stats!G8)","v":37},"Resilient construction",{"$f":"COUNTIF(Measures!$H$4:$H$554,Stats!I8)","v":70},"Response",{"$f":"COUNTIF(Measures!$I$4:$I$554,Stats!K8)","v":134},"National network",{"$f":"COUNTIF(Measures!$J$4:$J$554,Stats!M8)","v":35},"0",{"$f":"COUNTIF(Measures!$Q$4:$W$554,Stats!O8)","v":2214}]
["05 Loss of pavement integrity",{"$f":"COUNTIF(Measures!$B$4:$B$554,Stats!A9)","v":65},"02-1 Overloading of hydraulic systems crossing the road",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C9)","v":44},"Bituminous pavements",{"$f":"COUNTIF(Measures!$F$4:$F$554,Stats!E9)","v":5},"Corrective maintenance and replacement",{"$f":"COUNTIF(Measures!$G$4:$G$554,Stats!G9)","v":21},"Maintenance and replacement",{"$f":"COUNTIF(Measures!$H$4:$H$554,Stats!I9)","v":67},"Recovery",{"$f":"COUNTIF(Measures!$I$4:$I$554,Stats!K9)","v":14},"Regional network",{"$f":"COUNTIF(Measures!$J$4:$J$554,Stats!M9)","v":119},1,{"$f":"COUNTIF(Measures!$Q$4:$W$554,Stats!O9)","v":450}]
["06 Loss of driving ability due to extreme weather events",{"$f":"COUNTIF(Measures!$B$4:$B$554,Stats!A10)","v":62},"02-2 Erosion of road bases",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C10)","v":21},"Concrete pavements",{"$f":"COUNTIF(Measures!$F$4:$F$554,Stats!E10)","v":14},"Traffic management",{"$f":"COUNTIF(Measures!$G$4:$G$554,Stats!G10)","v":99},"Traffic management",{"$f":"COUNTIF(Measures!$H$4:$H$554,Stats!I10)","v":118},"All",{"$f":"COUNTIF(Measures!$I$4:$I$554,Stats!K10)","v":8},"Stretch - network",{"$f":"COUNTIF(Measures!$J$4:$J$554,Stats!M10)","v":39},"2",{"$f":"COUNTIF(Measures!$Q$4:$W$554,Stats!O10)","v":496}]
["07 Reduced ability for maintenance",{"$f":"COUNTIF(Measures!$B$4:$B$554,Stats!A11)","v":10},"02-3 Bridge scour",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C11)","v":32},"Semi-rigid pavements",{"$f":"COUNTIF(Measures!$F$4:$F$554,Stats!E11)","v":2},"Extreme event management",{"$f":"COUNTIF(Measures!$G$4:$G$554,Stats!G11)","v":33},"Capacity building",{"$f":"COUNTIF(Measures!$H$4:$H$554,Stats!I11)","v":17},null,null,"Stretch",{"$f":"COUNTIF(Measures!$J$4:$J$554,Stats!M11)","v":81},"3",{"$f":"COUNTIF(Measures!$Q$4:$W$554,Stats!O11)","v":34}]
["08 Susceptibility to wildfires that threaten the transportation infrastructure directly",{"$f":"COUNTIF(Measures!$B$4:$B$554,Stats!A12)","v":0},"03-1 External slides affecting the road",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C12)","v":23},"Brick pavement",{"$f":"COUNTIF(Measures!$F$4:$F$554,Stats!E12)","v":0},"Capacity building",{"$f":"COUNTIF(Measures!$G$4:$G$554,Stats!G12)","v":17},"Monitoring",{"$f":"COUNTIF(Measures!$H$4:$H$554,Stats!I12)","v":27},null,null,"Object - stretch",{"$f":"COUNTIF(Measures!$J$4:$J$554,Stats!M12)","v":76}]
["09 Damage to signs, lighting fixtures and supports",{"$f":"COUNTIF(Measures!$B$4:$B$554,Stats!A13)","v":0},"03-2 Slides of the road embankment",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C13)","v":21},"Unpaved roads",{"$f":"COUNTIF(Measures!$F$4:$F$554,Stats!E13)","v":9},"Monitoring and prediction",{"$f":"COUNTIF(Measures!$G$4:$G$554,Stats!G13)","v":26},"Research ",{"$f":"COUNTIF(Measures!$H$4:$H$554,Stats!I13)","v":17},null,null,"Object",{"$f":"COUNTIF(Measures!$J$4:$J$554,Stats!M13)","v":55}]
["10 Trees falling on the road",{"$f":"COUNTIF(Measures!$B$4:$B$554,Stats!A14)","v":0},"03-3 Debris flow",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C14)","v":22},"Traffic management",{"$f":"COUNTIF(Measures!$F$4:$F$554,Stats!E14)","v":0},"Research",{"$f":"COUNTIF(Measures!$G$4:$G$554,Stats!G14)","v":46}]
[null,null,"03-4 Rock fall",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C15)","v":18},"All road infrastructure",{"$f":"COUNTIF(Measures!$F$4:$F$554,Stats!E15)","v":138}]
[null,null,"03-5 Snow avalanches",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C16)","v":13},"Tunnels. Low lying stretches and leight weight embankments",{"$f":"COUNTIF(Measures!$F$4:$F$554,Stats!E16)","v":0}]
[null,null,"04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C17)","v":18},"Structures: bridges, culverts, tunnels, retaining walls, restraint systems, gantries, masts",{"$f":"COUNTIF(Measures!$F$4:$F$554,Stats!E17)","v":0}]
[null,null,"04-2 Weakening of the road base by standing water",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C18)","v":16},"Signs and signals, CCTV systems, emergency systems, lighting, roadmarkings",{"$f":"COUNTIF(Measures!$F$4:$F$554,Stats!E18)","v":0}]
[null,null,"04-3 (Unequal) settlements of roads by consolidation",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C19)","v":8},"Non motorized users facilities",{"$f":"COUNTIF(Measures!$F$4:$F$554,Stats!E19)","v":0}]
[null,null,"04-4 Instability / subsidence of roads by thawing of permafrost",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C20)","v":18}]
[null,null,"04-5 Uplift of tunnels or light weight construction materials by increasing water levels",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C21)","v":14}]
[null,null,"05-1 Cracking, rutting, embrittlement",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C22)","v":16}]
[null,null,"05-2 Frost heave",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C23)","v":17}]
[null,null,"05-3 Aggregate loss and detachment of pavement layers",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C24)","v":7}]
[null,null,"05-4 Cracking due to weakening of the road base by thaw",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C25)","v":16}]
[null,null,"05-5 Thermal expansion of pavements",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C26)","v":9}]
[null,null,"05-6 Decreased utility of (unimproved) roads that rely on frozen ground",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C27)","v":0}]
[null,null,"06-1 Reduced visibility",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C28)","v":0}]
[null,null,"06-2 Reduced visibility during snowfall, heavy rain including splash and spray",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C29)","v":7}]
[null,null,"06-3 Reduced vehicle control",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C30)","v":11}]
[null,null,"06-4 Decrease in skid resistance on pavements from slight rain after a dry period",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C31)","v":5}]
[null,null,"06-5 Aquaplaning in ruts due to precipitation on the road, splash and spray",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C32)","v":15}]
[null,null,"06-6 Decrease in skid resistance on pavements from migration of liquid bitumen",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C33)","v":12}]
[null,null,"06-7 Icing and snow",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C34)","v":12}]
[null,null,"07-1 Snow removal costs",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C35)","v":0}]
[null,null,"07-2 Ice removal costs",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C36)","v":2}]
[null,null,"07-3 Impact on road works: decreased time window for paving",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C37)","v":8}]
[null,null,"08-1 Susceptibility to wildfires that threaten the transportation infrastructure directly",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C38)","v":0}]
[null,null,"09-1 Damage to signs, lighting fixtures and supports",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C39)","v":0}]
[null,null,"10-1 Trees falling on the road",{"$f":"COUNTIF(Measures!$C$4:$C$554,Stats!C40)","v":0}]

{"sheet":"Tables","index":6,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["Threat sub category","Climate parameter"]
["01-1 flooding due to failure of flood defence system of rivers and canals","Snowmelt , rainfall in the catchment area, extreme wind speed, wind direction",null,"AV",7]
["01-2 pluvial flooding (overland flow after precipitation, increase of groundwater levels, increase of aquifer hydraulic heads)","Extreme rainfall events (heavy showers, long periods of rain)",null,"MC",8]
["01-3 Inundation of roads in coastal areas, combining the effects of sea level rise and storm surges","Sea level rise, extreme wind speed, wind direction (-> storm surge)",null,"MK",6]
["01-4 Flooding from snow melt (overland flow after snow melt)","Temperature",null,"WP6 LB",6]
["02-1 Overloading of hydraulic systems crossing the road","Extreme rainfall events (heavy showers, long periods of rain)"]
["02-2 Erosion of road bases","Sea level rise, extreme wind speed, wind direction (-> storm surge), extreme rainfall events (heavy showers, long periods of rain) "]
["02-3 Bridge scour","Sea level rise, extreme wind speed, wind direction (-> storm surge), extreme rainfall events (heavy showers, long periods of rain) "]
["03-1 External slides affecting the road","Extreme rainfall events (heavy showers, long periods of rain), after drought (consecutive dry days)"]
["03-2 Slides of the road embankment","Extreme rainfall events (heavy showers, long periods of rain), after drought (consecutive dry days)"]
["03-3 Debris flow","Extreme rainfall events (long periods of rain) "]
["03-4 Rock fall","Extreme rainfall events (heavy showers, long periods of rain), frost-thaw cycles (number of days with temperature zero-crossings)"]
["03-5 Snow avalanches","Frost-thaw cycles (number of days with temperature zero-crossings), snowfall"]
["04-1 Impact on soil moisture levels, affecting the structural integrity of roads, bridges and tunnels","Seasonal and annual average rainfall, sea level rise, extreme wind speed, wind direction (-> storm surge)"]
["04-2 Weakening of the road base by standing water","Seasonal and annual average rainfall"]
["04-3 (Unequal) settlements of roads by consolidation","Drought (consecutive dry days)"]
["04-4 Instability / subsidence of roads by thawing of permafrost","Thaw (number of days with temperature zero-crossings)"]
["04-5 Uplift of tunnels or light weight construction materials by increasing water levels","Extreme rainfall events (long periods of rain), seasonal and annual average rainfall, sea level rise, extreme wind speed, wind direction (-> storm surge)"]
["05-1 Cracking, rutting, embrittlement",""]
["05-2 Frost heave","Frost"]
["05-3 Aggregate loss and detachment of pavement layers",""]
["05-4 Cracking due to weakening of the road base by thaw","Frost-thaw cycles (number of days with temperature zero-crossings)"]
["05-5 Thermal expansion of pavements","Maximum temperature and number of consecutive hot days (heat waves)"]
["05-6 Decreased utility of (unimproved) roads that rely on frozen ground","Frost-thaw cycles (number of days with temperature zero-crossings)"]
["06-1 Reduced visibility","Fog days"]
["06-2 Reduced visibility during snowfall, heavy rain including splash and spray",""]
["06-3 Reduced vehicle control",""]
["06-4 Decrease in skid resistance on pavements from slight rain after a dry period","Drought (consecutive dry days)"]
["06-5 Aquaplaning in ruts due to precipitation on the road, splash and spray","Extreme rainfall events (heavy showers) "]
["06-6 Decrease in skid resistance on pavements from migration of liquid bitumen",""]
["06-7 Icing and snow","Snowfall, frost and rainfall"]
["07-1 Snow removal costs","Snowfall"]
["07-2 Ice removal costs","Frost"]
["07-3 Impact on road works: decreased time window for paving",""]
["08-1 Susceptibility to wildfires that threaten the transportation infrastructure directly","Drought (consecutive dry days)"]
["09-1 Damage to signs, lighting fixtures and supports",""]
["10-1 Trees falling on the road",""]

{"sheet":"Track record","index":7,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
["version","WP","changes","modified by","date"]
["1.0","6-7-8","first proposal","AV",{"$f":"NA()","v":{"$error":"#N/A"}}]
["1.1","6-7-8","inserted column for Phase","AV",{"$f":"NA()","v":{"$error":"#N/A"}}]
["2.0","6-7-8","format according to flipped table 1","AV","2013-07-29"]
["2.1","6-7-8","Inserted column for Owner; integrated measures from WP6 by LB","AV","2013-07-30"]
["2.2","6-7-8","some changes to measures of LB","AV","2013-08-12"]
[null,null,"EGIS traffic management measures","MC","2013-09-02"]
[null,null,"comments by YE","YE","2013-09-02"]
["2.3","6-7-8","Some cleaning up","AV","2013-09-06"]
["2.4","6-7-8","Inserted draft columns for Criteria and Sustainability","AV","2013-09-07"]
["3.0","6-7-8","Terminology of Categories vs. Stages table","MC","2013-09-12"]
["3.1","6-7-8","Cleaning up, including comments in Remark column; inserted columns for Criteria and Sustainability","AV","2013-09-19"]
["4.0","6-7-8","Modification according to minutes of Paris meeting","AV","2013-12-17"]
["4.1","6-7-8","Sustainability theme 'General / management' added","AV","2014-01-09"]
["4.2","6-7-8","Sorted and split table","AV","2014-01-13"]
["4.3","7","Completed table for WP7","AV","2014-01-22"]
[null,null,"included strategy plot"]
["4.4","7","Changed terminology for traffic management measures","AV","2014-01-29"]
[null,null,"Included weighted average of scores"]
["4.5","7","Changed 'strategy' to 'policy'","AV","2014-02-13"]
[null,null,"Deleted weighted average of scores"]
["4.6","7","Deleted Aggregate loss and detachment of pavement layers as a result of consequtive hot days","AV","2014-02-19"]
[null,null,"Added measures for threat 4-5 Uplift of tunnels and light weight fills","AV","2014-02-26"]
["5.0","8","Change in vocabulary + criteria ","MC","2014-01-26"]
["6","6","Added measures for WP6","LB","2014-02-25"]
["7.0a","6-7-8","Integrated measures for WP6-7-8:","AV","2014-02-28"]
[null,null,"- Database of adaptation techniques - v6 WP6"]
[null,null,"- Database of adaptation techniques - v4.6 WP7"]
[null,null,"- Database of adaptation techniques - v5 WP8_MC"]
["7.0b","6-7-8","Integrated measures for WP6-7-8, condensed climate parameters","AV","2014-02-28"]
["8.0","6-7-8","Included SGI modifications from Database of adaptation techniques - v7.0b WP6-7-8_SGI2.0","AV","2014-03-25"]
[null,null,"Additional measures in Deltares threats","AV"]
[null,null,"Changed threat 05-6 to 05-4 following discussion with LB","AV"]
["8.1","6-7-8","Changed some policies, measure categories and stages for flooding measures","AV","2014-03-27"]
[null,null,"Changed maximum number of measures in policy matrix to 60","AV"]
[null,null,"Added some measures for flooding","AV"]
[null,null,"Merged literature lists of LB and AV","AV"]
["9.0","6-7-8","Changed + 0 - to numbers in consequence tables","AV","2014-10-24"]
[null,null,"Included additional measures by LF and OF","AV"]
["9.1","6-7-8","Changed 'Traffic management' to ' Mobility services' as 'Asset type' ","AV","2014-10-26"]
["9.2","6-7-8","Added measure 552","AV","2015-04-24"]