Skip to main content
Article thumbnail
Location of Repository

Soil Profile Analytical Database for Europe (SPADE): Reconstruction and Validation of the Measured Data (SPADE/M)

By Roland Hiederer, Robert J. A. Jones and J. Daroussin


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

Topics: soil properties, soil profile data, database design
Publisher: Royal Danish Geographical Society
Year: 2006
OAI identifier:
Provided by: Cranfield CERES

Suggested articles


  1. (1995a): The establishment of a soil profile analytical database for the European Union.
  2. (1995b): Guidelines for completing profile proformas.
  3. (1995). A homogenised soil data file for global environmental research: a subset of FAO,
  4. (1970). A Relational Model of Data for Large Shared Data Banks. doi
  5. (1997). A world data set of derived soil properties by FAO-UNESCO soil unit for global modelling. Soil Use and Management doi
  6. (1999). Attribute Coding for the Soil Profile Analytical Database of Europe, Version, 29/03/1999. Document available on: Site last accessed:
  7. (1995). Crop monitoring and yield forecasting activities of the MARS project.
  8. (1995). Elaboration of an extended knowledge database to interpret the 1:1,000,000 EU Soil Map for environmental purposes.
  9. (1998). European Soil Database: Information access and data distribution procedures:
  10. (1995). Extension of the EU database for the soils of Central and Eastern Europe.
  11. (1989). FAO-ISRIC Soil Database (SDB). World Soil Resources Reports No.64, Food and Agriculture Organisation of the United Nations,
  12. (1974). FAO–UNESCO Soil Map of the World. Volume I: Legend. doi
  13. (1995). Foreword. doi
  14. (1991). Mapping methods for the 1990s and beyond.
  15. (1999). Metadata: Soil Profile Analytical Database of Europe, Version, 29/03/1999. Document available on: Site last accessed:
  16. (1985). Soil Map of the doi
  17. (1995). Soil profile analytical database for the European Union. doi
  18. (1995). The EU Soil Geographic Database.
  19. (1998). Towards a European Soil Profile Analytical Database. doi
  20. (1995). World Inventory of Soil Emission Potentials: development of a global soil database of process-controlling factors. In: doi

To submit an update or takedown request for this paper, please submit an Update/Correction/Removal Request.