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

Simple item page
dc.contributor.authorHiederer, Roland
dc.contributor.authorJones, Robert J. A.
dc.contributor.authorDaroussin, J.
dc.date.accessioned2009-06-05T14:02:17Z
dc.date.available2009-06-05T14:02:17Z
dc.date.issued2006
dc.description.abstractThe 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.en_UK
dc.identifier.citationR. Hiederer, R.J.A. Jones, J. Daroussin, Soil Profile Analytical Database for Europe (SPADE): Reconstruction and Validation of the Measured Data (SPADE/M), Geografisk Tiddskrift - Danish Journal of Geography,2006, 106(1) 71-85.en_UK
dc.identifier.issn0016-7223
dc.identifier.urihttp://hdl.handle.net/1826/3418
dc.language.isoenen_UK
dc.publisherRoyal Danish Geographical Societyen_UK
dc.subjectsoil propertiesen_UK
dc.subjectsoil profile dataen_UK
dc.subjectdatabase designen_UK
dc.titleSoil Profile Analytical Database for Europe (SPADE): Reconstruction and Validation of the Measured Data (SPADE/M)en_UK
dc.typeArticleen_UK

Files

Original bundle
Now showing 1 - 1 of 1
Thumbnail Image
Name:
SoilProfileAnalyticalDatabaseforEurope(SPADE)-2006.pdf
Size:
648.54 KB
Format:
Adobe Portable Document Format
Download
License bundle
Now showing 1 - 1 of 1
No Thumbnail Available
Name:
license.txt
Size:
1.88 KB
Format:
Item-specific license agreed upon to submission
Description:
Download

Collections

Staff publications - Cranfield University at Silsoe