Adaptation: Strategy definition and calculation CB ratio

[MatthiasHauthDeltares]

Inputs

• A csv file link_measure.csv which states which option ID to be applied to which link in the network. This csv contains 2 columns:
  - link_id: ID of the link in the network
  - option_id: one of the ID of the considered adaptation measures. 0 is for no option

This is an optional input!

Requirements:

Both the cost and the benefit have been calculated and the results are stored in AdaptationOptionCollection (for the cost part) and in the GeoPackage "benefits.gpkg".

• For the entire network which has a hazard overlaid: compute length_segment * EV_1_fr (=Exposed segment length). this is the complex graph because of the segment level of detail.
• Aggregate to simplified network (link level of detail)
• Compute adaptation costs for the entire network for all the options. This is simply the unit cost of the option multiplied by the exposed length.
• Apply AdaptationStrategy and return a GeoPackage with a column benefit_strategy and a column cost_strategy.
  • For links with no adaptation option. Set 0 for both benefit and cost
  • For links with adaptation option {ID}, set the benefit from "benefit_option_{ID}" and cost for option ID
• Add a column CBR_strategy which is benefit_strategy / cost_strategy. (Cost-Befenit Ratio)
• Add a column NPV_strategy which is benefit_strategy - cost_strategy. (Net Present Value)

Output:

the final GeoPackage CBA.gpkg has the following columns:
costs_option_ID, benefit_option_ID, benefit_strategy, cost_strategy, CB_ratio_strategy.

comments

AdaptationStrategy is by default: all option_ID applied everywhere. Otherwise when specified, use the table provided by user.
Maybe allow a list of AdaptationStrategy?