DICTIONARY:
DATABASE DICTIONARY OF
THE SOIL PROFILE ANALYTICAL DATA BASE OF EUROPE
VERSION 2.1.0.0, 29/03/1999
Last date modified: 25/05/1998 by Joël Daroussin.
29/03/1999 by Joël Daroussin.
See also:For a full description of the database, first read the Metadata, then when needed, read the Attribute coding file.
How to read this file: each object is described by:
Object type> <OBJECT_NAME
{More about object type}.
<Description of object>.
{Sources of data}.
{Contents, including description of attributes for Info files}.
N.B.: Angle brackets enclose a required field.
{} Braces enclose an optional field.
CONTENTS:
$PROFHOME
SPA DBE_README SPADBE_METADATA SPADBE_DICTIONA SPADBE_ATTRICOD EST_REJ
.DOC .DOC .DOC .DOC .LNK
INFO
MEAS_PROF
EST_PROF EST_HOR EST_PROF2STU.LNK
country 1 country 2 ... country n
Excel file(s) Excel file(s) Excel file(s)
1 - Directory $PROFHOME
1.1 - File SPADBE_Readme.doc
1.2 - File SPADBE_Metadata.doc
1.3 - File SPADBE_Dictiona.doc
1.4 - File SPADBE_Attricod.doc
1.5 - File EST_REJ.LNK
2 - Directory INFO
2.1 - Info file EST_PROF
2.2 - Info file EST_HOR
2.3 - Info file EST_PROF2STU.LNK
3 - Directory MEAS_PROF
3.1 - Directories country 1 to n
3.1.1 - Excel file(s)
1 - Directory $PROFHOME
System directory.
Project root directory.
1.1 - File SPADBE_Readme.doc
Word 6 for Windows document.
Delivery of the Soil Profile Analytical Data Base of Europe.
First things first read-me file for installing the database.
1.2 - File SPADBE_Metadata.doc
Word 6 for Windows document.
Data about the Soil Profile Analytical Data Base of Europe (identification, overview, quality, administrative...).
This file complies to the CEN (European Committee for Standardisation) project for a standard meta data description for geographic information, prEN 287009, April 1996.
1.3 - File SPADBE_Dictiona.doc
Word 6 for Windows document.
Database dictionary of the Soil Profile Analytical Data Base of Europe.
This file.
1.4 - File SPADBE_Attricod.doc
Word 6 for Windows document.
Attribute coding description for Info file attributes of the Soil Profile Analytical Data Base of Europe.
1.5 - File EST_REJ.LNK
Flat ASCII system file.
Rejected links in the estimated profile-to-STU linking process (see also Annex in file SPADBE_METADATA.DOC).
2 - Directory INFO
Info database directory.
This directory and its content can be accessed only with Arc/Info or Info software.
2.1 - Info file EST_PROF
Table describing general characteristics of estimed profiles.
Source: Contributing Organisations from each participating country.
Key attribute: PROF_NUM.
Sorted on: PROF_NUM (ascending order).
COLUMN / ITEM NAME / WIDTH / OUTPUT / TYPE / N.DEC / INDEXED?1 / PROF_NUM / 4 / 4 / I / - / -
5 / COUNTRY / 2 / 2 / C / - / -
7 / SOIL / 4 / 4 / C / - / -
11 / SOIL90 / 4 / 4 / C / 0 / -
15 / TEXT1 / 1 / 1 / I / - / -
16 / TEXT2 / 1 / 1 / I / - / -
17 / PM / 120 / 120 / C / - / -
137 / SMU / 7 / 7 / I / - / -
144 / STU / 7 / 7 / I / - / -
151 / LU / 40 / 40 / C / - / -
191 / GWL_HI / 4 / 4 / I / - / -
195 / GWL_LO / 4 / 4 / I / - / -
199 / DEPTH_ROO_EFF_A / 4 / 4 / I / - / -
203 / DEPTH_ROO_EFF_BE / 4 / 4 / I / - / -
207 / DEPTH_ROO_EFF_CO / 4 / 4 / I / - / -
211 / DEPTH_ROO_EFF_MA / 4 / 4 / I / - / -
215 / DEPTH_ROO_EFF_OL / 4 / 4 / I / - / -
219 / DEPTH_ROO_EFF_SC / 4 / 4 / I / - / -
223 / DEPTH_ROO_EFF_SG / 4 / 4 / I / - / -
227 / DEPTH_ROO_EFF_WC / 4 / 4 / I / - / -
231 / DEPTH_ROO_TOT_A / 4 / 4 / I / - / -
235 / DEPTH_ROO_TOT_BE / 4 / 4 / I / - / -
239 / DEPTH_ROO_TOT_CO / 4 / 4 / I / - / -
243 / DEPTH_ROO_TOT_MA / 4 / 4 / I / - / -
247 / DEPTH_ROO_TOT_OL / 4 / 4 / I / - / -
251 / DEPTH_ROO_TOT_SC / 4 / 4 / I / - / -
255 / DEPTH_ROO_TOT_SG / 4 / 4 / I / - / -
259 / DEPTH_ROO_TOT_WC / 4 / 4 / I / - / -
263 / DEPTH_HOR_O / 4 / 4 / I / - / -
267 / AR_NA_O / 4 / 4 / I / - / -
271 / BD_O / 4 / 4 / I / - / -
275 / BS_O / 4 / 4 / I / - / -
279 / C/N_O / 4 / 4 / I / - / -
283 / CACO3_ACT_O / 4 / 4 / I / - / -
287 / CACO3_TOT_O / 4 / 4 / I / - / -
291 / CASO4_O / 4 / 4 / I / - / -
295 / CEC_O / 4 / 4 / I / - / -
299 / EC_O / 4 / 4 / I / - / -
303 / EXCH_CA_O / 4 / 4 / I / - / -
307 / EXCH_K_O / 4 / 4 / I / - / -
311 / EXCH_MG_O / 4 / 4 / I / - / -
315 / EXCH_NA_O / 4 / 4 / I / - / -
319 / EXCH_NA_P_O / 4 / 4 / I / - / -
323 / GRAVEL_O / 4 / 4 / I / - / -
327 / OM_O / 4 / 4 / I / - / -
331 / PH_O / 4 / 4 / I / - / -
335 / POR_O / 4 / 4 / I / - / -
339 / STRUCT_O / 4 / 4 / I / - / -
343 / TEXT_2_O / 4 / 4 / I / - / -
347 / TEXT_20_O / 4 / 4 / I / - / -
351 / TEXT_50_O / 4 / 4 / I / - / -
355 / TEXT_200_O / 4 / 4 / I / - / -
359 / TEXT_2000_O / 4 / 4 / I / - / -
363 / WC_1_O / 4 / 4 / I / - / -
367 / WC_10_O / 4 / 4 / I / - / -
371 / WC_100_O / 4 / 4 / I / - / -
375 / WC_1500_O / 4 / 4 / I / - / -
379 / WC_FC_O / 4 / 4 / I / - / -
PROF_NUM / Profile unique identifier
COUNTRY / Country code
SOIL / Full 1974 (modified CEC 1985) FAO legend soil name
TEXT1 / Dominant surface textural class
TEXT2 / Secondary surface textural class
PM / Dominant parent material
SMU / Soil Mapping Unit identifier to which the profile refers (as given by author)
STU / Soil Typogical Unit identifier to which the profile refers (as given by author)
LU / Dominant land use
GWL_HI / Mean highest level of a permanent or perched groundwater table
GWL_LO / Mean lowest level of a permanent or perched groundwater table
DEPTH_ROO_EFF_A / Mean effective root depth for A??? (cm)
DEPTH_ROO_EFF_BE / Mean effective root depth for Beets (cm)
DEPTH_ROO_EFF_CO / Mean effective root depth for Cotton (cm)
DEPTH_ROO_EFF_MA / Mean effective root depth for Maize (cm)
DEPTH_ROO_EFF_OL / Mean effective root depth for Olives (cm)
DEPTH_ROO_EFF_SC / Mean effective root depth for Spring cereals (cm)
DEPTH_ROO_EFF_SG / Mean effective root depth for Short grass (cm)
DEPTH_ROO_EFF_WC / Mean effective root depth for Winter cereals (cm)
DEPTH_ROO_TOT_A / Mean total root depth for A??? (cm)
DEPTH_ROO_TOT_BE / Mean total root depth for Beets (cm)
DEPTH_ROO_TOT_CO / Mean total root depth for Cotton (cm)
DEPTH_ROO_TOT_MA / Mean total root depth for Maize (cm)
DEPTH_ROO_TOT_OL / Mean total root depth for Olives (cm)
DEPTH_ROO_TOT_SC / Mean total root depth for Spring cereals (cm)
DEPTH_ROO_TOT_SG / Mean total root depth for Short grass (cm)
DEPTH_ROO_TOT_WC / Mean total root depth for Winter cereals (cm)
DEPTH_HOR_O / Origin of data for horizons depths
AR_NA_O / Origin of data for Sodium adsorption ratio
BD_O / Origin of data for Bulk density
BS_O / Origin of data for Base saturation
C/N_O / Origin of data for Carbon/Nitrogen ratio
CACO3_ACT_O / Origin of data for Active calcium carbonate
CACO3_TOT_O / Origin of data for Calcium carbonate equivalent
CASO4_O / Origin of data for Gypsum
CEC_O / Origin of data for Cation exchange capacity
EC_O / Origin of data for Electrical Conductivity
EXCH_CA_O / Origin of data for Calcium exchangeable base
EXCH_K_O / Origin of data for Potassium exchangeable base
EXCH_MG_O / Origin of data for Magnesium exchangeable base
EXCH_NA_O / Origin of data for Sodium exchangeable base
EXCH_NA_P_O / Origin of data for Exchangeable sodium percentage of the CEC
GRAVEL_O / Origin of data for Class percentage of stones and gravel in the soil
OM_O / Origin of data for Organic matter content
PH_O / Origin of data for Acidity pH
POR_O / Origin of data for Total porosity
STRUCT_O / Origin of data for Structure type
TEXT_2_O / Origin of data for Proportion of particles with size below 2 µm
TEXT_20_O / Origin of data for Proportion of particles with size 2-20 µm
TEXT_50_O / Origin of data for Proportion of particles with size 20-50 µm
TEXT_200_O / Origin of data for Proportion of particles with size 50-200 µm
TEXT_2000_O / Origin of data for Proportion of particles with size 200-2000 µm
WC_1_O / Origin of data for Soil water retention at -1 kPa
WC_10_O / Origin of data for Soil water retention at -10 kPa
WC_100_O / Origin of data for Soil water retention at -100 kPa
WC_1500_O / Origin of data for Soil water retention at -1500 kPa
WC_FC_O / Origin of data for Soil water retention at field capacity
2.2 - Info file EST_HOR
Table describing the horizons of estimed profiles.
Source: Contributing Organisations from each participating country.
Key attribute: PROF_NUM and HOR_NUM.
Sorted on: PROF_NUM and HOR_NUM (ascending order).
COLUMN / ITEM NAME / WIDTH / OUTPUT / TYPE / N.DEC / INDEXED?1 / PROF_NUM / 4 / 4 / I / - / -
5 / HOR_NUM / 1 / 1 / I / - / -
6 / HOR_NAME / 6 / 6 / C / - / -
12 / DEPTH_HOR_START / 4 / 4 / I / - / -
16 / DEPTH_HOR_END / 4 / 4 / I / - / -
20 / AR_NA / 4 / 4 / I / - / -
24 / BD / 4 / 7 / F / 2 / -
28 / BS / 4 / 4 / I / - / -
32 / C/N / 4 / 4 / I / - / -
36 / CACO3_ACT / 4 / 4 / I / - / -
40 / CACO3_TOT / 4 / 4 / I / - / -
44 / CASO4 / 4 / 4 / I / - / -
48 / CEC / 4 / 6 / F / 1 / -
52 / EC / 4 / 4 / I / - / -
56 / EXCH_CA / 4 / 7 / F / 2 / -
60 / EXCH_K / 4 / 7 / F / 2 / -
64 / EXCH_MG / 4 / 7 / F / 2 / -
68 / EXCH_NA / 4 / 7 / F / 2 / -
72 / EXCH_NA_P / 4 / 4 / I / - / -
76 / GRAVEL / 4 / 4 / I / - / -
80 / OM / 4 / 6 / F / 1 / -
84 / PH / 4 / 6 / F / 1 / -
88 / POR / 4 / 4 / I / - / -
92 / STRUCT / 4 / 4 / I / - / -
96 / TEXT_2 / 4 / 4 / I / - / -
100 / TEXT_20 / 4 / 4 / I / - / -
104 / TEXT_50 / 4 / 4 / I / - / -
108 / TEXT_200 / 4 / 4 / I / - / -
112 / TEXT_2000 / 4 / 4 / I / - / -
116 / WC_1 / 4 / 4 / I / - / -
120 / WC_10 / 4 / 4 / I / - / -
124 / WC_100 / 4 / 4 / I / - / -
128 / WC_1500 / 4 / 4 / I / - / -
132 / WC_FC / 4 / 4 / I / - / -
PROF_NUM / Profile unique identifier
HOR_NUM / Horizon sequential number within profile
HOR_NAME / Horizon name according to the FAO system
DEPTH_HOR_START / Start (appearance) depth of horizon (cm)
DEPTH_HOR_END / End (disappearance) depth of horizon (cm)
AR_NA / Sodium adsorption ratio (%)
BD / Bulk density (g/cm3)
BS / Base saturation (%) as a proportion of the CEC taken up by exchangeable bases (TEB/CEC)
C/N / Carbon/Nitrogen ratio (%)
CACO3_ACT / Active calcium carbonate (%)
CACO3_TOT / Calcium carbonate equivalent (weight %)
CASO4 / Gypsum (weight %)
CEC / Cation exchange capacity (cmol+/kg)
EC / Electrical conductivity class (dS/m range at 25 °C)
EXCH_CA / Calcium exchangeable base (cmol+/kg)
EXCH_K / Potassium exchangeable base (cmol+/kg)
EXCH_MG / Magnesium exchangeable base (cmol+/kg)
EXCH_NA / Sodium exchangeable base (cmol+/kg)
EXCH_NA_P / Exchangeable sodium percentage of the CEC (%)
GRAVEL / Class percentage of stones and gravel in the soil
OM / Organic matter content in organo-mineral layers (weight %)
PH / Acidity pH (in water 1:2.5)
POR / Total porosity (%)
STRUCT / Structure type
TEXT_2 / Proportion (%) of particles with size below 2 µm
TEXT_20 / Proportion (%) of particles with size 2-20 µm
TEXT_50 / Proportion (%) of particles with size 20-50 µm
TEXT_200 / Proportion (%) of particles with size 50-200 µm
TEXT_2000 / Proportion (%) of particles with size 200-2000 µm
WC_1 / Soil water retention at -1 kPa (volume percentage of water)
WC_10 / Soil water retention at -10 kPa (volume percentage of water)
WC_100 / Soil water retention at -100 kPa (volume percentage of water)
WC_1500 / Soil water retention at -1500 kPa (volume percentage of water)
WC_FC / Soil water retention at field capacity (volume percentage of water)
2.3 - Info file EST_PROF2STU.LNK
Table describing the links between estimated profiles and Soil Typological Units (STUs).
Source: generated by program. See Annex in file METADATA.DOC.
Key attribute: PROF_NUM and STU.
Sorted on PROF_NUM and STU (ascending order).
COLUMN / ITEM NAME / WIDTH / OUTPUT / TYPE / N.DEC / INDEXED?1 / PROF_NUM / 7 / 7 / I / - / -
8 / STU / 7 / 7 / I / - / -
15 / LINK_O / 1 / 1 / I / - / -
PROF_NUM / Profile unique identifier
STU / Soil Typogical Unit identifier to which the profile refers (as given by author)
LINK_O / Origin of the link from profile to Soil Typological Unit (STU)
3 - Directory MEAS_PROF
System directory.
This directory contains one sub-directory for each contributing country to hold its measured profile descriptions.
3.1 - Directory country n
System directory.
The name of the directory is the 2 characters country code (see COUNTRY in attricod.doc).
This directory contains the country’s measured profile descriptions.
3.1.1 - Excel file(s)
The country’s measured profile descriptions are in the form of raw, unstructured Excel version 5 files as they were provided by the Contributing Organisations.
There is no naming convention for the Excel files.
There may be one Excel file only, holding the data for all the measured profiles for that country, one profile description per Excel sheet, or there may be one single sheet file per profile description.
1