CC - Visual Assessment of Crown Condition

Form: TRD - Damage parameters

Active since: 1984 Last change: 2016

Tests

Changes

!Sequence; plot; date_survey; tree; affected_part; symptom; symptom_spec; crown_loc; damage_age; cause; cause_sc_name; extent; other_observations

POSITION FIELD DESCRIPTION
1 Sequence

Description: Continuous number to identify the line of the submitted file
Format: I
2 plot
M

DB Column: code_plot
Description: Observation plot number
Remarks: A unique number (per country) given to the permanent plot during the selection or installation
Format: I
3 date_survey (DDMMYY)
M K

Description: Date of survey
Remarks: E.g. '9th October 2012' = '091012'
Format: Date
4 tree
M K

DB Column: tree_number
Description: Tree number (as marked during installation)
Format: I
Explanatory Item: 41
5 affected_part
M K

DB Column: code_affectpart
Description: Damage affected part of the tree
Format: I
Dictionary: d_affectpart
Explanatory Item: 54
6 symptom
K

DB Column: code_symptom
Description: Present damage symptom
Remarks: Should focus on important factors which may influence the condition of the tree
Format: I
Dictionary: d_symptom
Explanatory Item: 301
7 symptom_spec
K

DB Column: code_spec_symptom
Description: Specification of damage symptom
Format: I
Dictionary: d_spec_symptom
Explanatory Item: 301
8 crown_loc
K

DB Column: code_loccrown
Description: Location of damage in crown
Format: I
Dictionary: d_loccrown
9 damage_age
K

DB Column: code_damage_age
Description: Age of damage
Format: I
Dictionary: d_damage_age
10 cause
K

DB Column: code_cause
Description: Damage cause
Format: I
Dictionary: d_cause
Explanatory Item: 57
11 cause_sc_name
K

DB Column: code_cause_sc_name
Description: Scientific name of the damage cause
Format: C
Dictionary: d_cause_sc_name
Explanatory Item: 58
12 extent (%)

DB Column: code_extent
Description: Extent of the damage
Format: I
Dictionary: d_extent
Explanatory Item: 305
13 other_observations (FREE TEXT)

DB Column: other_obs
Description: Supplementary comments
Format: C