| Ref |
|
[1]
See
|
🛈
table('Habitat_Baseline')[xs:float(Area_enhanced) > 0][not (Required_Action="Compensation Not Required")]/Ref
|
| On-off-site |
|
Off-site
|
🛈
(<option>On-site</option>,<option>Off-site</option>)
|
| Baseline Broad Habitat |
|
Individual trees
|
🛈
table('Habitat_Baseline')[Ref=$self/Ref]/Broad_Habitat
|
| Baseline Habitat |
|
Urban tree
See
|
🛈
table('Habitat_Baseline')[Ref=$self/Ref]/Habitat
|
| Baseline Area |
|
7
hectare
|
🛈
table('Habitat_Baseline')[Ref=$self/Ref]/Area
|
| Baseline Distinctiveness Category |
|
Medium
|
🛈
table('Habitat_Baseline')[Ref=$self/Ref]/Distinctiveness_Category
|
| Baseline Distinctiveness Score |
|
4
|
🛈
table('Habitat_Baseline')[Ref=$self/Ref]/Distinctiveness_Score
|
| Baseline Condition |
|
Moderate
|
🛈
table('Habitat_Baseline')[Ref=$self/Ref]/Habitat_Condition
|
| Baseline Condition Score |
|
2
|
🛈
table('Habitat_Baseline')[Ref=$self/Ref]/Habitat_Condition_Score
|
| Baseline Strategic significance description |
|
Location ecologically desirable but not in local strategy
|
🛈
table('Habitat_Baseline')[Ref=$self/Ref]/Strategic_significance_description
|
| Baseline Strategic significance |
|
Medium strategic significance
|
🛈
table('Habitat_Baseline')[Ref=$self/Ref]/Strategic_significance
|
| Strategic significance multiplier |
|
1.1
|
🛈
table('Habitat_Baseline')[Ref=$self/Ref]/Strategic_significance_multiplier
|
| Baseline habitat units |
|
61.60000000000001
Unit
|
🛈
table('Habitat_Baseline')[Ref=$self/Ref]/Total_habitat_units
|
| Baseline Required Action |
|
Same broad habitat or a higher distinctiveness habitat required
|
🛈
table('Habitat_Baseline')[Ref=$self/Ref]/Required_Action
|
| Area |
|
2
hectare
|
🛈
table('Habitat_Baseline')[Ref=$self/Ref]/Area_enhanced
|
| Proposed Habitat |
🛈
Restricted by Trading Rules in the BNG 4.0 User Guide Table
3.2
|
Urban tree
See
|
🛈
if ($self/Baseline_Required_Action = "Bespoke compensation likely to be required")
then $self/Baseline_Habitat
else if ($self/Baseline_Required_Action = "Same habitat required")
then $self/Baseline_Habitat
else if ($self/Baseline_Required_Action = "Same distinctiveness or better habitat required")
then table('Habitat')[xs:integer(Distinctiveness_Score) >= xs:integer($self/Baseline_Distinctiveness_Score)]/Habitat
else if ($self/Baseline_Required_Action = "Same broad habitat or a higher distinctiveness habitat required")
then (table('Habitat')[Broad_Habitat=$self/Baseline_Broad_Habitat and xs:integer(Distinctiveness_Score) = xs:integer($self/Baseline_Distinctiveness_Score)]/Habitat,
table('Habitat')[Broad_Habitat !=$self/Baseline_Broad_Habitat and xs:integer(Distinctiveness_Score) > xs:integer($self/Baseline_Distinctiveness_Score)]/Habitat
)
else ()
|
| Proposed Broad Habitat |
|
Individual trees
|
🛈
table('Habitat')[Habitat=$self/Proposed_Habitat]/Broad_Habitat
|
| Proposed Distinctiveness Category |
|
Medium
|
🛈
table('Habitat')[Habitat=$self/Proposed_Habitat]/Distinctiveness_Category
|
| Proposed Distinctiveness Score |
|
4
|
🛈
table('Habitat')[Habitat=$self/Proposed_Habitat]/Distinctiveness_Score
|
| Distinctiveness Change |
|
Medium - Medium
|
🛈
concat($self/Baseline_Distinctiveness_Category , " - " ,
$self/Proposed_Distinctiveness_Category)
|
| Trading Rule Validation |
🛈
Check that the change in Habitat and Habitat Distinctiveness as defined in
the User Guide 5.2 satisfies the Suggested action for the Baseline Habitat.
|
OK
|
🛈
if ($self/Baseline_Required_Action = "Bespoke compensation likely to be required")
then if ($self/Proposed_Habitat = $self/Baseline_Habitat) then "OK" else "Error - Trading rules not satisfied"
else if ($self/Baseline_Required_Action = "Same habitat required")
then if ($self/Proposed_Habitat = $self/Baseline_Habitat) then "OK" else "Error - Trading rules not satisfied"
else if ($self/Baseline_Required_Action = "Same distinctiveness or better habitat required")
then if ($self/Proposed_Distinctiveness_Score >= $self/Baseline_Distinctiveness_Score) then "OK" else "Error - Trading rules not satisfied"
else if ($self/Baseline_Required_Action = "Same broad habitat or a higher distinctiveness habitat required")
then if ($self/Proposed_Broad_Habitat = $self/Baseline_Broad_Habitat or $self/Proposed_Distinctiveness_Score > $self/Baseline_Distinctiveness_Score) then "OK" else "Error - Trading rules not satisfied"
else if ($self/Baseline_Required_Action = "Compensation Not Required") then "OK"
else concat("Error - Unknown Required action: ", $self/Baseline_Required_Action)
|
| Trading Valid |
|
1
|
🛈
if ($self/Trading_Rule_Validation="OK") then 1 else 0
|
| Proposed Condition |
🛈
restricted by BNG 4.0 User Guide 6.1.6, 6.1.7
|
Good
|
🛈
table('Habitat_Condition')[Habitat=$self/Proposed_Habitat][xs:float(Condition_Score) >= xs:float($self/Baseline_Condition_Score)]/Condition
|
| Proposed Condition Score |
|
3
|
🛈
table('Condition')[Condition = $self/Proposed_Condition]/Condition_Score
|
| Condition Change |
|
Moderate - Good
|
🛈
concat($self/Baseline_Condition," - ",
$self/Proposed_Condition)
|
| Condition Change Validation |
🛈
Cannot trace the rules for this validation and not sure its
correct
|
OK
|
🛈
if ($self/Baseline_Habitat != $self/Proposed_Habitat and $self/Distinctiveness_Change = "High - High")
then "Error - Not like for like"
else if ($self/Baseline_Distinctiveness_Score = $self/Proposed_Distinctiveness_Score
and $self/Baseline_Condition_Score > $self/Proposed_Condition_Score)
then "Error - Cannot reduce condition"
else if ($self/Baseline_Distinctiveness_Score = $self/Proposed_Distinctiveness_Score
and $self/Baseline_Condition_Score = $self/Proposed_Condition_Score)
then "Error - No Enhancement"
else if ($self/Baseline_Condition_Score > $self/Proposed_Condition_Score)
then "Error - Condition cannot be reduced"
else if ($self/Baseline_Distinctiveness_Score > $self/Proposed_Distinctiveness_Score)
then "Error - Trading down"
else if ($self/Baseline_Habitat != $self/Proposed_Habitat
and $self/Baseline_Distinctiveness_Score < $self/Proposed_Distinctiveness_Score)
then concat("OK - Lower Distinctiveness Habitat - " ,$self/Proposed_Condition)
else "OK"
|
| Strategic significance description |
|
Location ecologically desirable but not in local strategy
|
🛈
table('Strategic_Significance')/Description
|
| Strategic significance |
|
Medium strategic significance
|
🛈
table('Strategic_Significance')[Description =
$self/Strategic_significance_description]/Strategic_significance
|
| Strategic significance Multiplier |
|
1.1
|
🛈
table('Strategic_Significance')[Description =
$self/Strategic_significance_description]/Multiplier
|
| Standard time to target |
|
16
|
🛈
if ($self/Baseline_Habitat != $self/Proposed_Habitat
and xs:float($self/Baseline_Distinctiveness_Score) < xs:float($self/Proposed_Distinctiveness_Score))
then table('Habitat_Enhancement_Year')[Habitat=$self/Proposed_Habitat][Baseline_Condition="Lower Distinctiveness Habitat"][Proposed_Condition=$self/Proposed_Condition]/Year
else table('Habitat_Enhancement_Year')[Habitat=$self/Proposed_Habitat][Baseline_Condition=$self/Baseline_Condition][Proposed_Condition=$self/Proposed_Condition]/Year
|
| Advance Years |
🛈
Positive for advance, Negative for delay
|
0
Year
|
|
| Final time to target |
|
16
Year
|
🛈
if ($self/Standard_time_to_target castable as xs:integer or
$self/Standard_time_to_target = "30+") then let $Year_to_target := if
($self/Standard_time_to_target = "30+") then 30 else xs:integer($self/Standard_time_to_target)
return $Year_to_target - $self/Advance_Years else ()
|
| Final time to target Multiplier |
|
0.566
|
🛈
table('Temporal_Multiplier')[Year=$self/Final_time_to_target]/Time_to_target_Multiplier
|
| Final difficulty of Enhancement |
|
Low
|
🛈
table('Habitat')[Habitat=$self/Proposed_Habitat]/Technical_Difficulty_Enhancement
|
| Final difficulty of Enhancement Multiplier |
|
1
|
🛈
table('Habitat')[Habitat=$self/Proposed_Habitat]/Technical_Difficulty_Enhancement_Multiplier
|
| Spatial Risk |
|
Compensation outside LPA or NCA of impact site and neighbouring LPA or NCA
|
🛈
if ($self/On-off-site = "Off-site") then table('Spatial_Risk')/Spatial_Risk else
<Spatial_Risk>On-site</Spatial_Risk>
|
| Spatial Risk Multiplier |
|
0.5
|
🛈
if ($self/On-off-site ="Off-site") then
table('Spatial_Risk')[Spatial_Risk=$self/Spatial_Risk]/Multiplier else 1
|
| Habitat units delivered |
|
22.58
Unit
|
🛈
( ( ($self/Area * $self/Proposed_Distinctiveness_Score *
$self/Proposed_Condition_Score) - ($self/Area * $self/Baseline_Distinctiveness_Score *
$self/Baseline_Condition_Score) ) * ( $self/Final_difficulty_of_Enhancement_Multiplier
* $self/Final_time_to_target_Multiplier) + ($self/Area * $self/Baseline_Distinctiveness_Score *
$self/Baseline_Condition_Score) ) * $self/Strategic_significance_Multiplier *
$self/Trading_Valid
|
| Habitat units delivered with SRM |
|
11.29
Unit
|
🛈
( ( ($self/Area * $self/Proposed_Distinctiveness_Score *
$self/Proposed_Condition_Score) - ($self/Area * $self/Baseline_Distinctiveness_Score *
$self/Baseline_Condition_Score) ) * ( $self/Final_difficulty_of_Enhancement_Multiplier
* $self/Final_time_to_target_Multiplier) + ($self/Area * $self/Baseline_Distinctiveness_Score *
$self/Baseline_Condition_Score) ) * $self/Strategic_significance_Multiplier *
$self/Trading_Valid * $self/Spatial_Risk_Multiplier
|
| Habitat units delivered TA2 |
|
20.84
Unit
|
🛈
( ( ( ($self/Area * $self/Proposed_Distinctiveness_Score *
$self/Proposed_Condition_Score) - ($self/Baseline_Area *
$self/Baseline_Distinctiveness_Score * $self/Baseline_Condition_Score) ) * (
$self/Final_difficulty_of_Enhancement_Multiplier * $self/Final_time_to_target_Multiplier ) ) +
($self/Baseline_Area * $self/Baseline_Distinctiveness_Score *
$self/Baseline_Condition_Score) ) * ($self/Strategic_significance_Multiplier *
$self/Trading_Valid * $self/Spatial_Risk_Multiplier)
|
| User comments |
|
|
|
| Consenting comments |
|
|
|
| GIS ref |
|
|
|
| Of-site ref |
|
|
|