| Ref |
|
|
|
| On-off-site |
|
On-site
|
🛈
(<option>On-site</option>,<option>Off-site</option>)
|
| Baseline Hedge Type |
|
To be computed
|
🛈
table('Hedge_Baseline')[Ref=$self/Ref]/Hedge_Type
|
| Baseline Length |
|
To be computed
|
🛈
table('Hedge_Baseline')[Ref=$self/Ref]/Length
|
| Baseline Distinctiveness Category |
|
To be computed
|
🛈
table('Hedge_Baseline')[Ref=$self/Ref]/Distinctiveness_Category
|
| Baseline Distinctiveness Score |
|
To be computed
|
🛈
table('Hedge_Baseline')[Ref=$self/Ref]/Distinctiveness_Score
|
| Baseline Condition |
|
To be computed
|
🛈
table('Hedge_Baseline')[Ref=$self/Ref]/Condition
|
| Baseline Condition Score |
|
To be computed
|
🛈
table('Hedge_Baseline')[Ref=$self/Ref]/Condition_Score
|
| Baseline Strategic Significance Category |
|
To be computed
|
🛈
table('Hedge_Baseline')[Ref=$self/Ref]/Strategic_Significance_Category
|
| Baseline Strategic Significance Multiplier |
|
To be computed
|
🛈
table('Hedge_Baseline')[Ref=$self/Ref]/Strategic_Significance_Multiplier
|
| Baseline Hedgerow Units |
|
To be computed
|
🛈
table('Hedge_Baseline')[Ref=$self/Ref]/Total_Hedgerow_Units
|
| Required Action |
|
To be computed
|
🛈
table('Hedge_Baseline')[Ref=$self/Ref]/Required_Action
|
| Proposed Hedge Type |
|
To be computed
|
🛈
table('Hedgerow')/Hedge_Type
|
| Proposed Distinctiveness Category |
|
To be computed
|
🛈
table('Hedgerow')[Hedge_Type=$self/Proposed_Hedge_Type]/Distinctiveness_Category
|
| Proposed Distinctiveness Score |
|
To be computed
|
🛈
table('Hedgerow')[Hedge_Type=$self/Proposed_Hedge_Type]/Distinctiveness_Score
|
| Proposed Condition |
|
To be computed
|
🛈
table('Hedgerow_Condition')/Condition_Category
|
| Proposed Condition Score |
|
To be computed
|
🛈
table('Hedgerow_Condition')[Condition_Category=
$self/Proposed_Condition]/Condition_Score
|
| Distinctiveness Change |
|
To be computed
|
🛈
table('Hedgerow_Trading')[From_Hedge_Type=$self/Baseline_Hedge_Type][To_Hedge_Type=$self/Proposed_Hedge_Type]/Rule
|
| Condition Change |
|
-
|
🛈
concat($self/Baseline_Condition, " - " ,$self/Proposed_Condition)
|
| Change Check |
|
OK
|
🛈
if ($self/Baseline_Hedge_Type != $self/Proposed_Hedge_Type
and $self/Distinctiveness_Change="High - High")
then "Error - Not like for like â–²"
else if ($self/Baseline_Condition_Score > $self/Proposed_Condition_Score)
then "Error - Can not 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_Hedge_Type != $self/Proposed_Hedge_Type and
$self/Baseline_Distinctiveness_Score < $self/Proposed_Distinctiveness_Score)
then concat("Lower Distinctiveness Habitat", " - ", $self/Proposed_Condition)
else "OK"
|
| Proposed Length |
|
|
|
| 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 |
|
To be computed
|
🛈
table('Hedgerow_Creation_Time_to_Target')[Hedge_Type=$self/Proposed_Hedge_Type][Condition=$self/Proposed_Condition]/Years
|
| Advance Years |
🛈
Positive for Advance, Negative for delay
|
0
Year
|
|
| Standard or adjusted time to target condition |
|
Standard time to
target condition applied
|
🛈
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) then "Check details - Is there evidence habitat
creation started/in place?" else if (number($self/Advance_Years) lt 0) then "Check
details -Delay in starting habitat in required condition?" else "Standard time to
target condition applied"
|
| Final Time to Target |
|
To be computed
|
🛈
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 |
|
To be computed
|
🛈
table('Temporal_Multiplier')[Year=$self/Final_Time_to_Target]/Time_to_target_Multiplier
|
| Standard Difficulty of Creation |
|
To be computed
|
🛈
table('Hedgerow')[Hedge_Type =
$self/Proposed_Hedge_Type]/Technical_Difficulty_Creation
|
| Applied Difficulty multiplier |
|
To be computed
|
🛈
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 "Standard difficulty applied"
|
| Final Difficulty of Creation |
|
To be computed
|
🛈
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('Hedgerow')[Hedge_Type=$self/Proposed_Hedge_Type]/Technical_Difficulty_Creation
|
| Final Difficulty of Creation Multiplier |
|
To be computed
|
🛈
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
|
| Hedge Units Delivered |
|
To be computed
|
🛈
$self/Proposed_Length * $self/Proposed_Distinctiveness_Score * $self/Proposed_Condition_Score
* $self/Strategic_Significance_Multiplier * $self/Final_Time_to_Target_Multiplier *
$self/Final_Difficulty_of_Creation_Multiplier * $self/Spatial_Risk_Multiplier
|
| User comments |
|
|
|
| Consenting comments |
|
|
|
| GIS ref |
|
|
|
| Off-site ref |
|
|
|