| Ref |
|
[1]
|
|
| On-off-site |
|
On-site
|
🛈
(<option>On-site</option>,<option>Off-site</option>)
|
| Broad Habitat |
|
Lakes
|
🛈
table('Broad_Habitat')/Broad_Habitat
|
| Habitat |
|
Marl lakes
|
🛈
table('Habitat')[Broad_Habitat=$self/Broad_Habitat]/Habitat
|
| Distinctiveness Category |
|
High
|
🛈
table('Habitat')[Habitat=$self/Habitat]/Distinctiveness_Category
|
| Distinctiveness Score |
|
6
|
🛈
table('Habitat')[Habitat=$self/Habitat]/Distinctiveness_Score
|
| Habitat Condition |
|
Good
|
🛈
table('Habitat_Condition')[Habitat=$self/Habitat]/Condition
|
| Habitat Condition Score |
|
3
|
🛈
table('Habitat_Condition')[Habitat=$self/Habitat][Condition=$self/Habitat_Condition]/Condition_Score
|
| 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 |
🛈
The average time taken between starting creation or enhancement of habitats
and that habitat reaching its target condition and or distinctiveness. (User Guide
2.1(
|
30
|
🛈
(table('Habitat_Creation_Year')[Habitat=$self/Habitat][Condition=$self/Habitat_Condition]/Target_Year,"Not
Possible")[1]
|
| Advance Years |
🛈
Positive for Advance, Negative for delay
|
0
Year
|
|
| Standard or adjusted time to target condition |
|
Standard time to target
condition applied
|
🛈
if ($self/Distinctiveness_Score = 0) then "Standard time to target condition
applied" else if ($self/Habitat_Condition = "N/A-Agricultural" and
number($self/Standard_time_to_target) le number($self/Advance_Years)) then "Check details - is
there evidence habitat creation in place?" else if (number($self/Standard_time_to_target)
le number($self/Advance_Years)) then "Check details - Is there evidence that habitat has
reached target condition?" else if (number($self/Advance_Years) gt 0 and
$self/Habitat_Condition = "Poor")then "Check details - is there evidence habitat creation
started and the threshold for Poor condition reached?" else if
(number($self/Advance_Years) lt 0) then "Check details -Delay in starting habitat in
required condition?" else if (number($self/Advance_Years) gt 0) then "Check details -Is
there evidence habitat creation started/in place?" else "Standard time to target
condition applied"
|
| Final time to target |
|
30
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.343
|
🛈
table('Temporal_Multiplier')[Year=$self/Final_time_to_target]/Time_to_target_Multiplier
|
| Standard difficulty of creation |
🛈
A measure which represents the uncertainty in the effectiveness of
management techniques used to enhance or create habitat.(User Guide
2.1)
|
High
|
🛈
table('Habitat')[Habitat=$self/Habitat]/Technical_Difficulty_Creation
|
| Applied difficulty multiplier |
|
Standard difficulty applied
|
🛈
if ($self/Standard_or_adjusted_time_to_target_condition = "Check details -Is there
evidence that habitat has reached target condition?") then "Low Difficulty - only
applicable if all habitat created before losses" else if
($self/Standard_or_adjusted_time_to_target_condition = "Check details - is there evidence
habitat creation started and the threshold for Poor condition reached?" and not (
$self/Habitat = ("Traditional orchards","Ornamental lake or pond", "Ponds (non-priority
habitat)","Ruderal/Ephemeral","Developed land;sealed surface"))) then "Enhancement
difficulty applied" else "Standard difficulty applied"
|
| Final difficulty of Creation |
|
High
|
🛈
if ($self/Applied_difficulty_multiplier = "Standard difficulty applied" and
number($self/Final_time_to_target)> 0) then $self/Standard_difficulty_of_creation else if
($self/Applied_difficulty_multiplier = "Low Difficulty - only applicable if all habitat
created before losses" and $self/Advance_Years ge $self/Standard_time_to_target) then "Low"
else table('Habitat')[Habitat=$self/Habitat]/Technical_Difficulty_Creation
|
| Final difficulty of Creation Multiplier |
|
0.33
|
🛈
table('Technical_Difficulty_Creation')[Technical_Difficulty_Creation=$self/Final_difficulty_of_Creation]/Technical_Difficulty_Creation_Multiplier
|
| Spatial Risk |
|
On-site
|
🛈
if ($self/On-off-site = "Off-site") then table('Spatial_Risk')/Spatial_Risk else
<Spatial_Risk>On-site</Spatial_Risk>
|
| Spatial Risk Multiplier |
|
1
|
🛈
if ($self/On-off-site ="Off-site") then
table('Spatial_Risk')[Spatial_Risk=$self/Spatial_Risk]/Multiplier else 1
|
| Total Multiplier |
|
2.2412
|
🛈
$self/Distinctiveness_Score * $self/Habitat_Condition_Score *
$self/Strategic_significance_Multiplier * $self/Final_time_to_target_Multiplier *
$self/Final_difficulty_of_Creation_Multiplier * $self/Spatial_Risk_Multiplier
|
| Required Habitat Units |
|
50
unit
|
|
| Net Gain Target pc |
|
10
pc
|
🛈
table('Project')/Net_Gain_Target_pc
|
| Target Habitat Units |
|
55
unit
|
🛈
$self/Required_Habitat_Units * (100 + $self/Net_Gain_Target_pc) div 100
|
| Required Area |
|
24.540840867371475
hectare
|
🛈
$self/Target_Habitat_Units div $self/Total_Multiplier
|
| Proposed Area |
|
|
|
| Area |
|
24.540840867371475
hectare
|
🛈
($self/Proposed_Area,$self/Required_Area)[1]
|
| Habitat units delivered |
|
55.0
Unit
|
🛈
$self/Area * $self/Total_Multiplier
|
| User comments |
|
|
|
| Consenting comments |
|
|
|
| GIS ref |
|
|
|
| Off-site ref |
|
|
|