Abstract Geografisk Tidsskrift, Danish Journal of Geography 106(1):71–85, 2006 The Soil Profile Analytical Database of Europe of Measured profiles (SPADE/M) was created to provide a common structure for storing harmonized information on typical soil profile properties of European soils. The main difficulty encountered in constructing the database was the transfer of the source data from individual electronic spreadsheet pages to the more rigid structure of a relational database. The data in spreadsheet format had been collected more than 12 years earlier but pressure was mounting for the capability to link these data to the Soil Map of Europe. A semi-automatic process was implemented to transfer data from nominal positions on the spreadsheet page to an intermediate structure highlighting any deviations from expected values. Conflicting situations were solved by manual intervention and expert judgement. Data in the intermediate structure were subjected to a validation procedure with the aim of storing uniform data in the database. The validation checks cover format authentication, restricting entries to permissible values and those passing plausibility tests. In cases where a horizon property could not be represented consistently following the field specifications, the database structure was adapted to accommodate those conditions. The database model was extended to allow data from multiple samples taken at the same plot and from the analysis of samples from different laboratories to be stored.
[1]
N. Batjes,et al.
World Inventory of Soil Emission Potentials: Development of a Global Soil Data Base of Process-Controlling Factors
,
1995
.
[2]
Robert J. A. Jones,et al.
Soil Profile Analytical Database for the European Union
,
1995
.
[3]
N. Batjes,et al.
A homogenized soil data file for global environmental research: A subset of FAO, ISRIC and NRCS profiles (Version 1.0)
,
1995
.
[4]
N. Batjes.
A world dataset of derived soil properties by FAO–UNESCO soil unit for global modelling
,
1997
.
[5]
V. W. P. van Engelen,et al.
Global and national soils and terrain digital databases (SOTER): procedures manual.
,
1993
.
[6]
E. F. Codd,et al.
A relational model of data for large shared data banks
,
1970,
CACM.
[7]
Eric Van Ranst,et al.
Elaboration of an extended knowledge database to interpret the 1:1.000.000 EU soil map for environmental purposes
,
1995
.