| Habitat Baseline Total Area |
|
12.82
hectare
|
🛈
sum(table('Habitat_Baseline')/Area)
|
| Habitat Baseline Area Canopy |
|
7.89
hectare
|
🛈
sum(table('Habitat_Baseline')[Habitat= ("Urban tree","Rural tree") or
contains(Habitat,"green wall")]/Area)
|
| Habitat Baseline Net Area |
🛈
Excluding area of individual trees and Green walls
|
4.93
hectare
|
🛈
$self/Habitat_Baseline_Total_Area - $self/Habitat_Baseline_Area_Canopy
|
| Habitat Baseline Retained Area |
|
3.92
hectare
|
🛈
sum(table('Habitat_Baseline')/Area_retained)
|
| Habitat Baseline Enhanced Area |
|
2.0
hectare
|
🛈
sum(table('Habitat_Baseline')/Area_enhanced)
|
| Habitat Baseline Area Lost |
|
6.90
hectare
|
🛈
sum(table('Habitat_Baseline')/Area_lost)
|
| Habitat Created Total Area |
|
34.58
hectare
|
🛈
sum(table('Habitat_Creation')/Area)
|
| Habitat Enhanced Total Area |
|
2.0
hectare
|
🛈
sum(table('Habitat_Enhancement')/Area)
|
| On-site Habitat Baseline Units Total |
|
107.89
Unit
|
🛈
sum(table('Habitat_Baseline')[On-off-site="On-site"]/Total_habitat_units)
|
| On-site Habitat Baseline Units Retained |
|
32.36
Unit
|
🛈
sum(table('Habitat_Baseline')[On-off-site="On-site"]/Baseline_units_retained)
|
| On-site Habitat Created Total Units |
|
67.81
Unit
|
🛈
sum(table('Habitat_Creation')[On-off-site="On-site"]/Habitat_units_delivered)
|
| On-site Habitat Enhanced Total Units |
|
0.0
Unit
|
🛈
sum(table('Habitat_Enhancement')[On-off-site="On-site"]/Habitat_units_delivered)
|
| On-site Habitat Post-intervention Total Units |
|
100.17
Unit
|
🛈
$self/On-site_Habitat_Baseline_Units_Retained + $self/On-site_Habitat_Created_Total_Units
+ $self/On-site_Habitat_Enhanced_Total_Units
|
| On-site Net Change |
|
-7.72
Unit
|
🛈
$self/On-site_Habitat_Post-intervention_Total_Units -
$self/On-site_Habitat_Baseline_Units_Total
|
| Off-site Habitat Baseline Units Total |
|
0.0
Unit
|
🛈
sum(table('Habitat_Baseline')[On-off-site="Off-site"]/Total_habitat_units)
|
| Off-site Habitat Baseline Units Retained |
|
0.0
Unit
|
🛈
sum(table('Habitat_Baseline')[On-off-site="Off-site"]/Baseline_units_retained)
|
| Off-site Habitat Created Total Units |
|
0.0
Unit
|
🛈
sum(table('Habitat_Creation')[On-off-site="Off-site"]/Habitat_units_delivered)
|
| Off-site Habitat Enhanced Total Units |
|
0.0
Unit
|
🛈
sum(table('Habitat_Enhancement')[On-off-site="Off-site"]/Habitat_units_delivered_SS)
|
| Off-site Habitat Post-intervention Total Units |
|
0.0
Unit
|
🛈
$self/Off-site_Habitat_Baseline_Units_Retained +
$self/Off-site_Habitat_Created_Total_Units +
$self/Off-site_Habitat_Enhanced_Total_Units
|
| Off-site Net Change |
|
0.0
Unit
|
🛈
$self/Off-site_Habitat_Post-intervention_Total_Units -
$self/Off-site_Habitat_Baseline_Units_Total
|
| Habitat Baseline Units Total |
|
107.89
Unit
|
🛈
sum(table('Habitat_Baseline')/Total_habitat_units)
|
| Habitat Baseline Units Target |
|
118.68
Unit
|
🛈
$self/Habitat_Baseline_Units_Total * (100 + table('Project')/Net_Gain_Target_pc ) div 100
|
| Habitat Baseline Units Retained |
|
32.36
Unit
|
🛈
sum(table('Habitat_Baseline')/Baseline_units_retained)
|
| Habitat Baseline Units Enhanced |
|
17.60
Unit
|
🛈
sum(table('Habitat_Baseline')/Baseline_units_enhanced)
|
| Habitat Baseline Units Lost |
|
57.93
Unit
|
🛈
sum(table('Habitat_Baseline')/Units_lost)
|
| Habitat Baseline Units Lost Canopy |
|
16.22
Unit
|
🛈
sum(table('Habitat_Baseline')[Habitat= ("Urban tree","Rural tree") or
contains(Habitat,"green wall")]/Units_lost)
|
| Habitat Baseline Units Lost Net |
🛈
Excluding area of individual trees and Green walls
|
41.71
Unit
|
🛈
$self/Habitat_Baseline_Units_Lost - $self/Habitat_Baseline_Units_Lost_Canopy
|
| Habitat Created Total Units |
|
0.0
Unit
|
🛈
sum(table('Habitat_Creation')[On-off-site="Off-site"]/Habitat_units_delivered)
|
| Habitat Enhanced Total Units |
|
0.0
Unit
|
🛈
sum(table('Habitat_Enhancement')/Habitat_units_delivered_SS)
|
| Habitat Post-intervention Total Units |
|
100.17
Unit
|
🛈
$self/On-site_Habitat_Post-intervention_Total_Units +
$self/Off-site_Habitat_Post-intervention_Total_Units
|
| Net-change |
|
-7.72
Unit
|
🛈
$self/Habitat_Post-intervention_Total_Units -
$self/Habitat_Baseline_Units_Total
|
| Target Net change |
|
-18.51
Unit
|
🛈
$self/Habitat_Post-intervention_Total_Units - $self/Habitat_Baseline_Units_Target
|
| Fairly Check |
🛈
see User Guide 5.3.6
|
OK - No Fairly Conditions in Baseline Habitat
|
🛈
if (some $condition in table('Habitat_Baseline')/Habitat_Condition satisfies
starts-with($condition,"Fairly")) then "Warning : 'Fairly' Conditions should only be
used through application of ecological expertise and any deviation from a
standardised condition assessment must be explained against specific condition
criterion" else "OK - No Fairly Conditions in Baseline Habitat"
|