S1 - Sampling and Analysis of Soil - Level I
Form: PRF - Soil profile description
Form introduced: 2009
Last change: 2009
!Sequence; country; plot; profile_pit; date_profile_desc; latitude; longitude; elevation; soil_group; qualifier_1; specifier_1; qualifier_2; specifier_2; qualifier_3; specifier_3; qualifier_4; specifier_4; qualifier_5; specifier_5; qualifier_6; specifier_6; classification_full_name; diagnostic_1; diagnostic_depth_1; diagnostic_2; diagnostic_depth_2; diagnostic_3; diagnostic_depth_3; diagnostic_4; diagnostic_depth_4; diagnostic_5; diagnostic_depth_5; diagnostic_6; diagnostic_depth_6; diagnostic_7; diagnostic_depth_7; diagnostic_8; diagnostic_depth_8; diagnostic_9; diagnostic_depth_9; diagnostic_10; diagnostic_depth_10; WRB_publication; parent_material_1; parent_material_2; ground_water_highest; ground_water_lowest; water_table; water; humus; eff_soil_depth; 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 | profile_pit M K |
DB Column: profile_pit_id Description: Profile pit ID Remarks: If already sampled in BioSoil, keep on using initial code Format: C |
| 5 | date_profile_desc (DDMMYY) M K |
Description: Date profile description Remarks: E.g. ‘9th October 2012’ = ‘091012’ Format: Date |
| 6 | 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 |
| 7 | 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 |
| 8 | elevation (m) |
DB Column: elevation_profile Description: Elevation of profile pit Remarks: In metres above sea level Format: I |
| 9 | soil_group |
DB Column: code_wrb_soil_group Description: Code of WRB Reference Soil Group Remarks: The newest version of the WRB should be used Format: C Dictionary: d_soil_group |
| 10 | qualifier_1 |
DB Column: code_wrb_qualifier_1 Description: WRB Qualifier 1 Remarks: Qualifiers should be added in order of importance (1 = most important) Format: C Dictionary: d_soil_adjective |
| 11 | specifier_1 |
DB Column: code_wrb_spezifier_1 Description: WRB Specifier 1 Remarks: No value if no specifier is needed Format: C Dictionary: d_soil_specifier |
| 12 | qualifier_2 |
DB Column: code_wrb_qualifier_2 Description: WRB Qualifier 2 Remarks: Qualifiers should be added in order of importance (1 = most important) Format: C Dictionary: d_soil_adjective |
| 13 | specifier_2 |
DB Column: code_wrb_spezifier_2 Description: WRB Specifier 2 Remarks: No value if no specifier is needed Format: C Dictionary: d_soil_specifier |
| 14 | qualifier_3 |
DB Column: code_wrb_qualifier_3 Description: WRB Qualifier 3 Remarks: Qualifiers should be added in order of importance (1 = most important) Format: C Dictionary: d_soil_adjective |
| 15 | specifier_3 |
DB Column: code_wrb_spezifier_3 Description: WRB Specifier 3 Remarks: No value if no specifier is needed Format: C Dictionary: d_soil_specifier |
| 16 | qualifier_4 |
DB Column: code_wrb_qualifier_4 Description: WRB Qualifier 4 Remarks: Qualifiers should be added in order of importance (1 = most important) Format: C Dictionary: d_soil_adjective |
| 17 | specifier_4 |
DB Column: code_wrb_spezifier_4 Description: WRB Specifier 4 Remarks: No value if no specifier is needed Format: C Dictionary: d_soil_specifier |
| 18 | qualifier_5 |
DB Column: code_wrb_qualifier_5 Description: WRB Qualifier 5 Remarks: Qualifiers should be added in order of importance (1 = most important) Format: C Dictionary: d_soil_adjective |
| 19 | specifier_5 |
DB Column: code_wrb_spezifier_5 Description: WRB Specifier 5 Remarks: No value if no specifier is needed Format: C Dictionary: d_soil_specifier |
| 20 | qualifier_6 |
DB Column: code_wrb_qualifier_6 Description: WRB Qualifier 6 Remarks: Qualifiers should be added in order of importance (1 = most important) Format: C Dictionary: d_soil_adjective |
| 21 | specifier_6 |
DB Column: code_wrb_spezifier_6 Description: WRB Specifier 6 Remarks: No value if no specifier is needed Format: C Dictionary: d_soil_specifier |
| 22 | classification_full_name |
Description: Full name of soil classification, e.g. Lixic Vetic Ferralsol (Ferric, Rhodic) Format: C |
| 23 | diagnostic_1 |
Description: Diagnostic 1 Format: C Dictionary: d_wrb_diagnostics Explanatory Item: 124 |
| 24 | diagnostic_depth_1 |
DB Column: depth_diagnostic_1 Description: Depth of appearance of diagnostic 1 Format: I Explanatory Item: 125 |
| 25 | diagnostic_2 |
Description: Diagnostic 2 Format: C Dictionary: d_wrb_diagnostics Explanatory Item: 124 |
| 26 | diagnostic_depth_2 |
DB Column: depth_diagnostic_2 Description: Depth diagnostic 2 Format: I Explanatory Item: 125 |
| 27 | diagnostic_3 |
Description: Diagnostic 3 Format: C Dictionary: d_wrb_diagnostics Explanatory Item: 124 |
| 28 | diagnostic_depth_3 |
DB Column: depth_diagnostic_3 Description: Depth diagnostic 3 Format: I Explanatory Item: 125 |
| 29 | diagnostic_4 |
Description: Diagnostic 4 Format: C Dictionary: d_wrb_diagnostics Explanatory Item: 124 |
| 30 | diagnostic_depth_4 |
DB Column: depth_diagnostic_4 Description: Depth diagnostic 4 Format: I Explanatory Item: 125 |
| 31 | diagnostic_5 |
Description: Diagnostic 5 Format: C Dictionary: d_wrb_diagnostics Explanatory Item: 124 |
| 32 | diagnostic_depth_5 |
DB Column: depth_diagnostic_5 Description: Depth diagnostic 5 Format: I Explanatory Item: 125 |
| 33 | diagnostic_6 |
Description: Diagnostic 6 Format: C Dictionary: d_wrb_diagnostics Explanatory Item: 124 |
| 34 | diagnostic_depth_6 |
DB Column: depth_diagnostic_6 Description: Depth diagnostic 6 Format: I Explanatory Item: 125 |
| 35 | diagnostic_7 |
Description: Diagnostic 7 Format: C Dictionary: d_wrb_diagnostics Explanatory Item: 124 |
| 36 | diagnostic_depth_7 |
DB Column: depth_diagnostic_7 Description: Depth diagnostic 7 Format: I Explanatory Item: 125 |
| 37 | diagnostic_8 |
Description: Diagnostic 8 Format: C Dictionary: d_wrb_diagnostics Explanatory Item: 124 |
| 38 | diagnostic_depth_8 |
DB Column: depth_diagnostic_8 Description: Depth diagnostic 8 Format: I Explanatory Item: 125 |
| 39 | diagnostic_9 |
Description: Diagnostic 9 Format: C Dictionary: d_wrb_diagnostics Explanatory Item: 124 |
| 40 | diagnostic_depth_9 |
DB Column: depth_diagnostic_9 Description: Depth diagnostic 9 Format: I Explanatory Item: 125 |
| 41 | diagnostic_10 |
Description: Diagnostic 10 Format: C Dictionary: d_wrb_diagnostics Explanatory Item: 124 |
| 42 | diagnostic_depth_10 |
DB Column: depth_diagnostic_10 Description: Depth diagnostic 10 Format: I Explanatory Item: 125 |
| 43 | WRB_publication M |
DB Column: code_wrb_publication Description: WRB publication code Format: C Dictionary: d_wrb_pub Explanatory Item: 126 |
| 44 | parent_material_1 |
DB Column: code_parent_material_1 Description: Parent Material Code 1 Format: I Dictionary: d_parent_material Explanatory Item: 120 |
| 45 | parent_material_2 |
DB Column: code_parent_material_2 Description: Parent Material Code 2 Format: I Dictionary: d_parent_material Explanatory Item: 120 |
| 46 | ground_water_highest |
DB Column: code_water_level_high Description: Mean highest ground water level Format: I Dictionary: d_ground_water_table |
| 47 | ground_water_lowest |
DB Column: code_water_level_low Description: Mean lowest ground water level Format: I Dictionary: d_ground_water_table |
| 48 | water_table |
DB Column: code_water_type Description: Type of water table Format: I Dictionary: d_water_table_type |
| 49 | water |
DB Column: code_water Description: Water availability Format: I Dictionary: d_water |
| 50 | humus |
DB Column: code_humus Description: Humus type Format: I Dictionary: d_humus |
| 51 | eff_soil_depth (cm) (M) |
Description: Effective soil depth from top of mineral soil to the continuous rock Mandatory for: survey years since 2003 Remarks: Use “999” to report depths known to be deeper than 100cm without knowing the exact depth Format: I |
| 52 | other_observations (FREE TEXT) |
DB Column: other_obs Description: Supplementary comments Format: C |