SO - Sampling and Analysis of Soil - Level II
Form: SOM - Contents of datafile with soil analysis information (Mandatory and optional as required by the BioSoil project) Level II
Form introduced: 2002
Last change: 2007
!Sequence; country; plot; layer; repetition; layer_superior; layer_inferior; subsamples; date_analysis; moisture_content; clay; silt; sand; texture; bulk_density_dry_fine_earth; coarse_fragments_vol; organic_layer_dry_weight; pH_CaCl; pH_H2O; total_organic_carbon; total_nitrogen; carbonates; exchange_acidity; exchange_Al; exchange_Ca; exchange_Fe; exchange_K; exchange_Mg; exchange_Mn; exchange_Na; Free_H_acidity; extract_Al; extract_Ca; extract_Cd; extract_Cr; extract_Cu; extract_Fe; extract_Hg; extract_K; extract_Mg; extract_Mn; extract_Na; extract_Ni; extract_P; extract_Pb; extract_S; extract_Zn; total_Al; total_Ca; total_Fe; total_K; total_Mg; total_Mn; total_Na; reactive_Al; reactive_Fe; P_ox; 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 | layer M K |
DB Column: code_layer Description: Code layer Format: C Dictionary: d_depth_level_soil |
| 5 | repetition M K |
Missing value (NULL): -9999 Remarks: E.g. 1, or more in case several samples have been analysed with the same layer Format: I Introduced: 2007 |
| 6 | layer_superior M K |
DB Column: layer_limit_superior Description: Layer limit superior Missing value (NULL): -9999 Format: F Explanatory Item: 128 Introduced: 2007 |
| 7 | layer_inferior (M) |
DB Column: layer_limit_inferior Description: Layer limit inferior Mandatory for: organic layers Format: F Explanatory Item: 128 Introduced: 2007 |
| 8 | subsamples |
Description: Number of subsamples in the composite Remarks: N° in the composite Format: I Introduced: 2007 |
| 9 | date_analysis (DDMMYY) M K |
DB Column: date_labor_analyses Description: Date laboratory analysis of most recent analysis on the concerning sample Missing value (NULL): 1900-01-01 Remarks: E.g. ‘9th October 2012’ = ‘091012’ Format: Date |
| 10 | moisture_content (%) |
Description: Moisture content Remarks: Difference between air dry and oven dry moisture Format: F |
| 11 | clay (%) (M) |
DB Column: part_size_clay Mandatory for: mineral layers Remarks: 0 - 2 micrometer fraction Format: F Explanatory Item: 220 |
| 12 | silt (%) (M) |
DB Column: part_size_silt Mandatory for: mineral layers Remarks: 2 - 63 micrometer fraction Format: F Explanatory Item: 220 |
| 13 | sand (%) (M) |
DB Column: part_size_sand Mandatory for: mineral layers Remarks: 63 - 2000 micrometer fraction Format: F Explanatory Item: 220 |
| 14 | texture (M) |
DB Column: code_texture_class Description: Texture class Mandatory for: mineral layers Format: C Dictionary: d_texture_class |
| 15 | bulk_density_dry_fine_earth (kg/m³) (M) |
DB Column: bulk_density Description: Mean dry bulk density of the fine earth Mandatory for: mineral fixed depth layers 0-10, 10-20 and 20-40 cm Format: F |
| 16 | coarse_fragments_vol (%) (M) |
DB Column: coarse_fragment_vol Description: Volume coarse fragments Mandatory for: mineral fixed depth layers 0-10, 10-20 and 20-40 cm Remarks: Volume % Format: I |
| 17 | organic_layer_dry_weight (kg/m²) |
DB Column: organic_layer_weight Description: Total dry weight of the organic layer Format: F |
| 18 | pH_CaCl (M) |
DB Column: ph_cacl2 Description: PH(CaCl2) Mandatory for: all layers except OL Format: F |
| 19 | pH_H2O |
Description: PH(H2O) Format: F |
| 20 | total_organic_carbon (g/kg) (M) |
DB Column: organic_carbon_total Description: Total Organic Carbon Mandatory for: all layers except OL Format: F |
| 21 | total_nitrogen (g/kg) (M) |
DB Column: n_total Description: Total Nitrogen Mandatory for: all layers except OL Format: F |
| 22 | carbonates (g/kg) (M) |
Mandatory for: calcareous soils (pH_CaCl2 > 5.5) in forest floor, 0-10 and 10-20 cm depth layer Format: F |
| 23 | exchange_acidity (cmol(+)/kg) (M) |
DB Column: exch_acidiy Description: Exchangeable acidity Mandatory for: non-calcareous soils (pH_CaCl2 <= 5.5) Format: F |
| 24 | exchange_Al (cmol(+)/kg) (M) |
DB Column: exch_al Description: Exchangeable Al Mandatory for: non-calcareous soils (pH_CaCl2 <= 5.5) Format: F |
| 25 | exchange_Ca (cmol(+)/kg) (M) |
DB Column: exch_ca Description: Exchangeable Ca Mandatory for: all layers except OL Format: F |
| 26 | exchange_Fe (cmol(+)/kg) (M) |
DB Column: exch_fe Description: Exchangeable Fe Mandatory for: non-calcareous soils (pH_CaCl2 <= 5.5) Format: F |
| 27 | exchange_K (cmol(+)/kg) (M) |
DB Column: exch_k Description: Exchangeable K Mandatory for: all layers except OL Format: F |
| 28 | exchange_Mg (cmol(+)/kg) (M) |
DB Column: exch_mg Description: Exchangeable Mg Mandatory for: all layers except OL Format: F |
| 29 | exchange_Mn (cmol(+)/kg) (M) |
DB Column: exch_mn Description: Exchangeable Mn Mandatory for: non-calcareous soils (pH_CaCl2 <= 5.5) Format: F |
| 30 | exchange_Na (cmol(+)/kg) (M) |
DB Column: exch_na Description: Exchangeable Na Mandatory for: all layers except OL Format: F |
| 31 | Free_H_acidity (cmol(+)/kg) (M) |
DB Column: free_h Description: Free H+ acidity Mandatory for: non-calcareous soils (pH_CaCl2 <= 5.5) Format: F |
| 32 | extract_Al (mg/kg) |
DB Column: extrac_al Description: Extractable Al Format: F |
| 33 | extract_Ca (mg/kg) (M) |
DB Column: extrac_ca Description: Extractable Ca Mandatory for: forest floor Format: F |
| 34 | extract_Cd (mg/kg) (M) |
DB Column: extrac_cd Description: Extractable Cd Mandatory for: forest floor or in 0-10 cm depth layer Format: F |
| 35 | extract_Cr (mg/kg) |
DB Column: extrac_cr Description: Extractable Cr Format: F |
| 36 | extract_Cu (mg/kg) (M) |
DB Column: extrac_cu Description: Extractable Cu Mandatory for: forest floor or in 0-10 cm depth layer Format: F |
| 37 | extract_Fe (mg/kg) |
DB Column: extrac_fe Description: Extractable Fe Format: F |
| 38 | extract_Hg (mg/kg) |
DB Column: extrac_hg Description: Extractable Hg Format: F |
| 39 | extract_K (mg/kg) (M) |
DB Column: extrac_k Description: Extractable K Mandatory for: forest floor Format: F |
| 40 | extract_Mg (mg/kg) (M) |
DB Column: extrac_mg Description: Extractable Mg Mandatory for: forest floor Format: F |
| 41 | extract_Mn (mg/kg) (M) |
DB Column: extrac_mn Description: Extractable Mn Mandatory for: forest floor Format: F |
| 42 | extract_Na (mg/kg) |
DB Column: extrac_na Description: Extractable Na Format: F |
| 43 | extract_Ni (mg/kg) |
DB Column: extrac_ni Description: Extractable Ni Format: F |
| 44 | extract_P (mg/kg) (M) |
DB Column: extrac_p Description: Extractable P Mandatory for: forest floor Format: F |
| 45 | extract_Pb (mg/kg) (M) |
DB Column: extrac_pb Description: Extractable Pb Mandatory for: forest floor or in 0-10 cm depth layer Format: F |
| 46 | extract_S (mg/kg) |
DB Column: extrac_s Description: Extractable S Format: F |
| 47 | extract_Zn (mg/kg) (M) |
DB Column: extrac_zn Description: Extractable Zn Mandatory for: forest floor or in 0-10 cm depth layer Format: F |
| 48 | total_Al (mg/kg) |
DB Column: tot_al Description: Total Al Format: F |
| 49 | total_Ca (mg/kg) |
DB Column: tot_ca Description: Total Ca Format: F |
| 50 | total_Fe (mg/kg) |
DB Column: tot_fe Description: Total Fe Format: F |
| 51 | total_K (mg/kg) |
DB Column: tot_k Description: Total K Format: F |
| 52 | total_Mg (mg/kg) |
DB Column: tot_mg Description: Total Mg Format: F |
| 53 | total_Mn (mg/kg) |
DB Column: tot_mn Description: Total Mn Format: F |
| 54 | total_Na (mg/kg) |
DB Column: tot_na Description: Total Na Format: F |
| 55 | reactive_Al (mg/kg) (M) |
DB Column: rea_al Description: Reactive Al Mandatory for: mineral layers Remarks: Acid oxalate extractable Al Format: F |
| 56 | reactive_Fe (mg/kg) (M) |
DB Column: rea_fe Description: Reactive Fe Mandatory for: mineral layers Remarks: Acid oxalate extractable Fe Format: F |
| 57 | P_ox (mg/kg) |
Description: Acid ammonium oxalate extractable P Remarks: Acid oxalate extractable P Format: F Introduced: 2007 |
| 58 | other_observations (FREE TEXT) |
DB Column: other_obs Description: Supplementary comments Format: C |