Output file format¶
The functions in this library generate two key output file types for the economics modelling:
A metrics summary file (saved by default in
econ_outputsas parquet files)A cost summary file (saved by default in
cost_outputsas a CSV file)
By default, for a single unique intervention ID (a unique intervention scenario run for any number of reps and any number of climate models), the above examples would generate 6 metric output files. This would include separate files for each of the 3 metrics (the RCI, RTI and RFI), and separate files for counterfactual and intervention scenarios. The cost sampling output would be a single file, as cost sampling is only done for intervention scenarios and all cost metrics are included in a single file.
Economics metric summary file structure¶
The following is an example metrics summary file generated to input to CREAM, for the RCI metric:
year_absolute |
year_relative |
Reef_ID |
reef_name |
not_zoned |
buffer |
commonwealth_island_GBRMPA |
conservation_park |
general_use |
habitat_protection |
marine_national_park |
preservation |
scientific_research |
total_area_nine_zones |
minimum_distance_to_nearest_port_m |
GBRMPA_management_area |
subregion |
qfish |
region_code |
sim_1 |
sim_2 |
sim_3 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2007 |
-18 |
1 |
U/N Reef |
0 |
0 |
0 |
0 |
0 |
0.83553108 |
0 |
0 |
0 |
0.83553108 |
46596.97332 |
Far Northern Management Area |
Torres Strait |
59057 |
E |
0 |
0 |
0 |
2008 |
-17 |
1 |
U/N Reef |
0 |
0 |
0 |
0 |
0 |
0.83553108 |
0 |
0 |
0 |
0.83553108 |
46596.97332 |
Far Northern Management Area |
Torres Strait |
59057 |
E |
0 |
0 |
0 |
2009 |
-16 |
1 |
U/N Reef |
0 |
0 |
0 |
0 |
0 |
0.83553108 |
0 |
0 |
0 |
0.83553108 |
46596.97332 |
Far Northern Management Area |
Torres Strait |
59057 |
E |
0 |
0 |
0 |
2010 |
-15 |
1 |
U/N Reef |
0 |
0 |
0 |
0 |
0 |
0.83553108 |
0 |
0 |
0 |
0.83553108 |
46596.97332 |
Far Northern Management Area |
Torres Strait |
59057 |
E |
0 |
0 |
0 |
2011 |
-14 |
1 |
U/N Reef |
0 |
0 |
0 |
0 |
0 |
0.83553108 |
0 |
0 |
0 |
0.83553108 |
46596.97332 |
Far Northern Management Area |
Torres Strait |
59057 |
E |
0 |
0 |
0 |
2012 |
-13 |
1 |
U/N Reef |
0 |
0 |
0 |
0 |
0 |
0.83553108 |
0 |
0 |
0 |
0.83553108 |
46596.97332 |
Far Northern Management Area |
Torres Strait |
59057 |
E |
0 |
0 |
0 |
2013 |
-12 |
1 |
U/N Reef |
0 |
0 |
0 |
0 |
0 |
0.83553108 |
0 |
0 |
0 |
0.83553108 |
46596.97332 |
Far Northern Management Area |
Torres Strait |
59057 |
E |
0 |
0 |
0 |
2014 |
-11 |
1 |
U/N Reef |
0 |
0 |
0 |
0 |
0 |
0.83553108 |
0 |
0 |
0 |
0.83553108 |
46596.97332 |
Far Northern Management Area |
Torres Strait |
59057 |
E |
0.83553108 |
0.83553108 |
0.83553108 |
2015 |
-10 |
1 |
U/N Reef |
0 |
0 |
0 |
0 |
0 |
0.83553108 |
0 |
0 |
0 |
0.83553108 |
46596.97332 |
Far Northern Management Area |
Torres Strait |
59057 |
E |
0.83553108 |
0.83553108 |
0.83553108 |
2016 |
-9 |
1 |
U/N Reef |
0 |
0 |
0 |
0 |
0 |
0.83553108 |
0 |
0 |
0 |
0.83553108 |
46596.97332 |
Far Northern Management Area |
Torres Strait |
59057 |
E |
0 |
0 |
0 |
2017 |
-8 |
1 |
U/N Reef |
0 |
0 |
0 |
0 |
0 |
0.83553108 |
0 |
0 |
0 |
0.83553108 |
46596.97332 |
Far Northern Management Area |
Torres Strait |
59057 |
E |
0.83553108 |
0.83553108 |
0.83553108 |
2018 |
-7 |
1 |
U/N Reef |
0 |
0 |
0 |
0 |
0 |
0.83553108 |
0 |
0 |
0 |
0.83553108 |
46596.97332 |
Far Northern Management Area |
Torres Strait |
59057 |
E |
0.83553108 |
0.83553108 |
0.83553108 |
2019 |
-6 |
1 |
U/N Reef |
0 |
0 |
0 |
0 |
0 |
0.83553108 |
0 |
0 |
0 |
0.83553108 |
46596.97332 |
Far Northern Management Area |
Torres Strait |
59057 |
E |
0.83553108 |
0.83553108 |
0.83553108 |
2020 |
-5 |
1 |
U/N Reef |
0 |
0 |
0 |
0 |
0 |
0.83553108 |
0 |
0 |
0 |
0.83553108 |
46596.97332 |
Far Northern Management Area |
Torres Strait |
59057 |
E |
0 |
0 |
0 |
2021 |
-4 |
1 |
U/N Reef |
0 |
0 |
0 |
0 |
0 |
0.83553108 |
0 |
0 |
0 |
0.83553108 |
46596.97332 |
Far Northern Management Area |
Torres Strait |
59057 |
E |
0 |
0 |
0 |
2022 |
-3 |
1 |
U/N Reef |
0 |
0 |
0 |
0 |
0 |
0.83553108 |
0 |
0 |
0 |
0.83553108 |
46596.97332 |
Far Northern Management Area |
Torres Strait |
59057 |
E |
0 |
0 |
0 |
2023 |
-2 |
1 |
U/N Reef |
0 |
0 |
0 |
0 |
0 |
0.83553108 |
0 |
0 |
0 |
0.83553108 |
46596.97332 |
Far Northern Management Area |
Torres Strait |
59057 |
E |
0.83553108 |
0.83553108 |
0.83553108 |
2024 |
-1 |
1 |
U/N Reef |
0 |
0 |
0 |
0 |
0 |
0.83553108 |
0 |
0 |
0 |
0.83553108 |
46596.97332 |
Far Northern Management Area |
Torres Strait |
59057 |
E |
0 |
0 |
0 |
2025 |
0 |
1 |
U/N Reef |
0 |
0 |
0 |
0 |
0 |
0.83553108 |
0 |
0 |
0 |
0.83553108 |
46596.97332 |
Far Northern Management Area |
Torres Strait |
59057 |
E |
0 |
0 |
0 |
2026 |
1 |
1 |
U/N Reef |
0 |
0 |
0 |
0 |
0 |
0.83553108 |
0 |
0 |
0 |
0.83553108 |
46596.97332 |
Far Northern Management Area |
Torres Strait |
59057 |
E |
0 |
0 |
0 |
2027 |
2 |
1 |
U/N Reef |
0 |
0 |
0 |
0 |
0 |
0.83553108 |
0 |
0 |
0 |
0.83553108 |
46596.97332 |
Far Northern Management Area |
Torres Strait |
59057 |
E |
0 |
0 |
0 |
A file such as the above is generated for each intervention run, i.e., for each unique
combination of deployment volume, enhancement level, deployment years etc. run in
ReefModEngine.jl, for each metric and for each counterfactual and intervention.
The outputs in the columns sim_1, sim_2 etc. represent different draws for the same
intervention scenario, which can be across multiple climate models. Each draw may sample
ecological, expert and other forms of uncertainty depending on the uncertainty settings
when the files were generated (see calculate_metrics.default_uncertainty_dict()).
The other columns summarize key information such year, year relative to the first
intervention year, reef name, distance to port, reef area in different management zones and
other spatial information.
Each intervention is identifiable through an intervention ID captured in the file name. For
a set of runs, an intervention ID key file (as a CSV) is also generated and saved in
intervention_keys, which links key intervention parameters to an intervention ID.
An example intervention ID key file is included below. Note that the number of 1YO corals
reported is the actual number of outplants recorded in ReefModEngine.jl, so it varies
slightly between climate model replicates due to slightly different space available for
coral growth in different climate scenarios. The input value for deployment volume will not
vary for the same intervention ID.
The functions here treat the varying number of outplants for a single intervention as a stochastic sample for that intervention in the cost model sampling. The intervention ID key files are necessary to assure scenario sampling IDs match between the cost and metrics samples, but also for future reference as a record of the intervention scenarios which were run for a particular set of economics input files.
ID |
results_filename |
intervention_years |
number_of_1YO_corals |
port_id |
distance_to_port_NM |
intervention_reef_id |
number_of_species |
start_year |
end_year |
rep |
|
|---|---|---|---|---|---|---|---|---|---|---|---|
0 |
1 |
intervention1_metric_name_ecol0_intervention.csv |
2027 |
823235.0 |
1 |
25.9326612742256 |
16-071 |
6 |
2025 |
2099 |
1.0 |
1 |
1 |
intervention1_metric_name_ecol0_intervention.csv |
2027 |
882794.0 |
1 |
25.9326612742256 |
16-071 |
6 |
2025 |
2099 |
2.0 |
2 |
1 |
intervention1_metric_name_ecol0_intervention.csv |
2028 |
140294.0 |
1 |
25.9326612742256 |
16-071 |
6 |
2025 |
2099 |
1.0 |
3 |
1 |
intervention1_metric_name_ecol0_intervention.csv |
2028 |
209118.0 |
1 |
25.9326612742256 |
16-071 |
6 |
2025 |
2099 |
2.0 |
4 |
1 |
intervention1_metric_name_ecol0_intervention.csv |
2029 |
133676.0 |
1 |
25.9326612742256 |
16-071 |
6 |
2025 |
2099 |
1.0 |
5 |
1 |
intervention1_metric_name_ecol0_intervention.csv |
2029 |
119779.0 |
1 |
25.9326612742256 |
16-071 |
6 |
2025 |
2099 |
2.0 |
6 |
2 |
intervention2_metric_name_ecol0_intervention.csv |
2027 |
833162.0 |
1 |
25.9326612742256 |
16-071 |
6 |
2025 |
2099 |
1.0 |
7 |
2 |
intervention2_metric_name_ecol0_intervention.csv |
2027 |
825221.0 |
1 |
25.9326612742256 |
16-071 |
6 |
2025 |
2099 |
2.0 |
8 |
2 |
intervention2_metric_name_ecol0_intervention.csv |
2028 |
101912.0 |
1 |
25.9326612742256 |
16-071 |
6 |
2025 |
2099 |
1.0 |
9 |
2 |
intervention2_metric_name_ecol0_intervention.csv |
2028 |
138309.0 |
1 |
25.9326612742256 |
16-071 |
6 |
2025 |
2099 |
2.0 |
10 |
2 |
intervention2_metric_name_ecol0_intervention.csv |
2029 |
95294.0 |
1 |
25.9326612742256 |
16-071 |
6 |
2025 |
2099 |
1.0 |
11 |
2 |
intervention2_metric_name_ecol0_intervention.csv |
2029 |
93309.0 |
1 |
25.9326612742256 |
16-071 |
6 |
2025 |
2099 |
2.0 |
Cost summary file structure¶
The cost files generated have the structure shown in the example below. The component column refers to 11 key cost codes:
CAPEX - sum of production and deployment cost
Contingency CAPEX - % of CAPEX
OPEX - sum of production and deployment cost
Sustaining capital OPEX - set to zero for now (assumed to be included in OPEX through contract)
Contingency OPEX - % of OPEX
Vessel fuel - only relevant if volunteer vessels are used - set to zero for now
CAPEX-monitoring - set to zero (assumed no monitoring cost)
Contingency CAPEX-monitoring - % of CAPEX-monitoring
OPEX-monitoring - set to zero (assumed no monitoring cost)
Sustaining capital OPEX-monitoring - set to zero (assumed no monitoring cost)
Contingency OPEX-monitoring - % of OPEX-monitoring
Each of the columns draw1, draw2 etc refer to unique samples drawn from the cost models for a particular
intervention scenario by varying key cost model parameters (specified in config.csv). The cost files and
metric summary files are linked by their intervention ID, as described in the intervention ID key file generated
when the metric summary files are produced. Cost files are only generated for the intervention scenarios, as counterfactual
scenario will have zero cost, so for a given unique intervention ID, one cost file is generated.
year |
component |
draw1 |
draw2 |
draw3 |
… |
draw5000 |
|---|---|---|---|---|---|---|
2025 |
1 |
200000 |
300000 |
… |
… |
… |
2025 |
2 |
400000 |
200000 |
… |
… |
… |
2025 |
3 |
500000 |
100000 |
… |
… |
… |
2025 |
4 |
300000 |
300000 |
… |
… |
… |
2025 |
5 |
… |
… |
… |
… |
… |
2025 |
6 |
… |
… |
… |
… |
… |
2025 |
7 |
… |
… |
… |
… |
… |
2025 |
8 |
… |
… |
… |
… |
… |
2025 |
9 |
… |
… |
… |
… |
… |
2025 |
10 |
… |
… |
… |
… |
… |
2025 |
11 |
… |
… |
… |
… |
… |
2026 |
1 |
… |
… |
… |
… |
… |
2026 |
2 |
… |
… |
… |
… |
… |
2026 |
3 |
… |
… |
… |
… |
… |