SW - Soil Water

Form: SWA - Sample analysis results on water retention

Active since: 1995 Last change: 2016

Tests

Changes

!Sequence; country; plot; date_sampling; SW_pit; depth_layer; replicate; water_content; matric_preasure; date_analysis; 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 date_sampling (DDMMYY)
M K

Description: Sampling date
Remarks: E.g. '9th October 2012' = '091012'
Format: Date
5 SW_pit
M K

DB Column: sw_id
Description: ID of soil water pit
Format: C
Explanatory Item: 175
6 depth_layer
M K

DB Column: code_depth_layer
Description: Code depth layer
Format: C
7 replicate
M K

Remarks: In case multiple samples are taken in one SW pit: '1, 2, 3'
Format: I
8 water_content (m³)
M

DB Column: water_content_vol
Description: Volumetric water content
Remarks: Volume at matric pressure (Attribute: „matric_pressure“)
Format: F
Explanatory Item: 201
9 matric_preasure (kPa)
M K

Description: Matric preasure
Remarks: E.g. value -5 indicating -5kPa, mandatory for new calculations under FutMon: 0kPa, -1kPa, -5kPa, -33kPa, -1500kPa
Format: F
Explanatory Item: 201
10 date_analysis (DDMMYY)

DB Column: date_labor_analyses
Description: Date laboratory analysis
Remarks: E.g. '9th October 2012' = '091012'
Format: Date
11 other_observations (FREE TEXT)

DB Column: other_obs
Description: Supplementary comments
Format: C