SS - Analysis of Soil Solution

Form: PSS - Plot based information

Active since: 1984 Last change: 2016

Tests

Changes

!Sequence; country; plot; latitude; longitude; altitude; sampler_id; sampler_type; layer; depth; samplers; date_monitoring_first; date_monitoring_last; periods; other_observations

POSITION FIELD DESCRIPTION
1 Sequence

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

DB Column: code_country
Description: ID of the country
Format: I
Dictionary: d_country
3 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
4 latitude (+DDMMSS)
M

Description: Latitude in Degrees Minutes Seconds (WGS84)
Remarks: E.g. '+505852' = 50 Degree, 58 Minutes, 52 Seconds
Format: C
Explanatory Item: 4
5 longitude (+/-DDMMSS)
M

Description: Longitude in Degrees Minutes Seconds (WGS84)
Remarks: E.g. '+035531' = 3 Degree, 55 Minutes, 31 Seconds
Format: C
Explanatory Item: 4
6 altitude (m)
M

DB Column: code_altitude
Description: Altitude above sea level in 50 meter classes
Format: I
Dictionary: d_altitude
7 sampler_id
M K

DB Column: sampler_number
Description: Sampler ID
Format: I
8 sampler_type
M

DB Column: code_soil_sampler_type
Description: Sampler Type
Format: I
Dictionary: d_sampler_ss
9 layer
M

DB Column: code_layer_type
Format: C
Dictionary: d_layer
10 depth (m)
M

DB Column: sample_depth
Description: Sampling depth
Remarks: In meters below surface
Format: F
Explanatory Item: 149
11 samplers

DB Column: samplers_number
Description: Number of used samplers
Format: I
Explanatory Item: 150
12 date_monitoring_first (DDMMYY)
M K

Description: 1st period start date
Remarks: E.g. '9th October 2012' = '091012'
Format: Date
Explanatory Item: 142
13 date_monitoring_last (DDMMYY)
M

Description: Last period final date
Remarks: E.g. '9th October 2012' = '091012'
Format: Date
Explanatory Item: 142
14 periods
M

DB Column: periods_number
Description: Number of (equal) measuring periods
Format: I
15 other_observations (FREE TEXT)

DB Column: other_obs
Description: Supplementary comments
Format: C