SI - System Instalment

Form: TCO - Tree coordinates

Active since: 2011 Last change: 2011

!Sequence; country; plot; date_survey; tree; tree_species; x_coordinate; y_coordinate; tree_within; tree_status; other_observations

POSITION FIELD DESCRIPTION
1 Sequence

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

DB Column: code_country
Description: ID of the country
Format: I
Dictionary: d_country
3 plot

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
4 date_survey (DDMMYY)
K

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

DB Column: tree_number
Description: Tree number
Format: C
Explanatory Item: 41
6 tree_species

DB Column: code_tree_species
Description: Coded tree species
Format: I
7 x_coordinate

DB Column: coordinate_x
Description: Relative plot coordinate (X)
Remarks: Metric system (west – east)
Format: F
Explanatory Item: 6
8 y_coordinate

DB Column: coordinate_y
Description: Relative plot coordinate (Y)
Remarks: Metric system (south – north)
Format: F
Explanatory Item: 6
9 tree_within (YES=Y, NO=N)

Description: Tree within Level II Plot in narrower sense
Format: C
Explanatory Item: 28
10 tree_status

DB Column: code_tree_status
Description: Status of Tree
Format: I
Dictionary: d_tree_status
11 other_observations (FREE TEXT)

DB Column: other_obs
Description: Supplementary comments
Format: C