SO - Analysis of Soil

Form: PRF - Soil profile description

Active since: 1984 Last change: 2016

Tests

Changes

!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; 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; rooting_depth; rock_depth; obstacle_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: Same as used in BioSoil (max 4 characters)
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 diagnostic_1

Description: Diagnostic 1
Format: C
Dictionary: d_wrb_diagnostics
Explanatory Item: 124
23 diagnostic_depth_1

DB Column: depth_diagnostic_1
Description: Depth of appearance of diagnostic 1
Format: I
Explanatory Item: 125
24 diagnostic_2

Description: Diagnostic 2
Format: C
Dictionary: d_wrb_diagnostics
Explanatory Item: 124
25 diagnostic_depth_2

DB Column: depth_diagnostic_2
Description: Depth diagnostic 2
Format: I
Explanatory Item: 125
26 diagnostic_3

Description: Diagnostic 3
Format: C
Dictionary: d_wrb_diagnostics
Explanatory Item: 124
27 diagnostic_depth_3

DB Column: depth_diagnostic_3
Description: Depth diagnostic 3
Format: I
Explanatory Item: 125
28 diagnostic_4

Description: Diagnostic 4
Format: C
Dictionary: d_wrb_diagnostics
Explanatory Item: 124
29 diagnostic_depth_4

DB Column: depth_diagnostic_4
Description: Depth diagnostic 4
Format: I
Explanatory Item: 125
30 diagnostic_5

Description: Diagnostic 5
Format: C
Dictionary: d_wrb_diagnostics
Explanatory Item: 124
31 diagnostic_depth_5

DB Column: depth_diagnostic_5
Description: Depth diagnostic 5
Format: I
Explanatory Item: 125
32 diagnostic_6

Description: Diagnostic 6
Format: C
Dictionary: d_wrb_diagnostics
Explanatory Item: 124
33 diagnostic_depth_6

DB Column: depth_diagnostic_6
Description: Depth diagnostic 6
Format: I
Explanatory Item: 125
34 diagnostic_7

Description: Diagnostic 7
Format: C
Dictionary: d_wrb_diagnostics
Explanatory Item: 124
35 diagnostic_depth_7

DB Column: depth_diagnostic_7
Description: Depth diagnostic 7
Format: I
Explanatory Item: 125
36 diagnostic_8

Description: Diagnostic 8
Format: C
Dictionary: d_wrb_diagnostics
Explanatory Item: 124
37 diagnostic_depth_8

DB Column: depth_diagnostic_8
Description: Depth diagnostic 8
Format: I
Explanatory Item: 125
38 diagnostic_9

Description: Diagnostic 9
Format: C
Dictionary: d_wrb_diagnostics
Explanatory Item: 124
39 diagnostic_depth_9

DB Column: depth_diagnostic_9
Description: Depth diagnostic 9
Format: I
Explanatory Item: 125
40 diagnostic_10

Description: Diagnostic 10
Format: C
Dictionary: d_wrb_diagnostics
Explanatory Item: 124
41 diagnostic_depth_10

DB Column: depth_diagnostic_10
Description: Depth diagnostic 10
Format: I
Explanatory Item: 125
42 WRB_publication
M

DB Column: code_wrb_publication
Description: WRB publication code
Format: C
Dictionary: d_wrb_pub
Explanatory Item: 126
43 parent_material_1

DB Column: code_parent_material_1
Description: Parent Material Code 1
Format: I
Dictionary: d_parent_material
Explanatory Item: 120
44 parent_material_2

DB Column: code_parent_material_2
Description: Parent Material Code 2
Format: I
Dictionary: d_parent_material
Explanatory Item: 120
45 ground_water_highest

DB Column: code_water_level_high
Description: Mean highest ground water level
Format: I
Dictionary: d_ground_water_table
46 ground_water_lowest

DB Column: code_water_level_low
Description: Mean lowest ground water level
Format: I
Dictionary: d_ground_water_table
47 water_table

DB Column: code_water_type
Description: Type of water table
Format: I
Dictionary: d_water_table_type
48 rooting_depth (cm)

Description: Effective rooting depth
Remarks: In cm from mineral soil surface, in Text Forms mandatory if existing
Format: I
Explanatory Item: 140
49 rock_depth (cm)

Description: Rock depth of the soil profile
Remarks: In cm from mineral soil surface
Format: I
Explanatory Item: 140
50 obstacle_depth (cm)

Description: Obstacle depth of the soil profile
Remarks: In cm from mineral soil surface, in Text Forms mandatory if existing
Format: I
Explanatory Item: 140
51 other_observations (FREE TEXT)

DB Column: other_obs
Description: Supplementary comments
Format: C

results matching ""

    No results matching ""