Skip to content
This repository was archived by the owner on Jan 26, 2026. It is now read-only.

Soil Data Example Discussion from UC2

Jump to bottom
Paul van Genuchten edited this page Sep 19, 2025 · 14 revisions

Measurements at 1 point, 1 date :

Soil characteristics - Greece (eco2adapt)

https://entrepot.recherche.data.gouv.fr/dataset.xhtml?persistentId=doi:10.57745/QJNQVN

Evaluation: Poor organization, no spatial info, no procedural info.

Contents:

  • Excel Data File
    • No spatial information
    • Depth info in Excel (upper_lower)
    • Contains conversion factors for specific properties
    • UoM as additional row under ObsProps
    • No procedural information
  • Metadata file
    • Only administrative info, responsibles

Structure:

  • classic CSV, columns for spatial, then ObsProp

Measurements at multiple points (x,y are there), 1 date :

Large variability of soil microbial diversity and functions in an over 20-year old Eucalyptus grandis plantation

https://dataverse.cirad.fr/dataset.xhtml?persistentId=doi:10.18167/DVN1/QN22CM

Evaluation: Poor, only relative spatial information, no real coordinates. UoM difficult as mixing in Property. Does include procedure

Contents:

  • Excel Data File
    • readme tab contains all columns with description, UoM and methodology
      • includes depth information for all locations
      • Site location is not provided in readme, only name of site "Itatinga Experimental Station, University of São Paulo"
      • spatial information provided in m, but no information on the origin
      • issues with UoM as usually includes compound, should be shifted to ObsProp.
        • Not UoM "mg C g-1 soil DW h-1", ObsProp "Glucose-induced respiration rate"
        • Should be UoM "mg g-1 h-1", ObsProp "Glucose-induced respiration rate as C in soil DW"
    • data file: fairly normal
      • one column includes %, other just provide a fraction, though UoM same
  • Metadata file
    • in addition to administrative metadata, quite a bit of descriptive content.
    • Includes keywords, partially even from AgroVoc.

Structure:

  • Classic CSV

Dataset of soil and cacao leaf samples collected in all regions of Côte d'Ivoire

https://dataverse.cirad.fr/dataset.xhtml?persistentId=doi:10.18167/DVN1/PWM9WW

Evaluation: Good!

Contents:

  • CIV_Cacao_sols Nguessan.txt - metadata
    • Contains ObsProp, UoM and method for all columns
  • CIV_Cacao_sols Nguessan.xlsx - data
    • coordinates seem to be WGS84 (or related)
    • some values are colored (red or green), unclear what this means

Structure:

  • Classic CSV (explained in accompanying txt file):
    • first columns spatial (text and Lat/Lon)
    • ObsProps

Soil characteristics - Finland (eco2adapt)

https://entrepot.recherche.data.gouv.fr/dataset.xhtml?persistentId=doi:10.57745/USNIMD

  • same as Greek monitoring (eco2adapt)

Evaluation: Poor, no spatial info, no procedural info

Contents:

  • dataset
    • many values include "<", e.g. "< 1"
  • metadata
    • administrative data full stop

Structure:

  • classic CSV, columns for spatial, then ObsProp

Measurements at different times, at 1 point (no spatial info) :

Soil 4-m profile data

https://zenodo.org/records/14524990

Evaluation: Poor, no spatial info, no procedural info

Contents:

  • dataset
    • no spatial information, only sample ID
    • ObsProps explained for first table, other tables without explaination
  • No additional metadata provided

Structure:

  • first 2 tabs classic CSV: sample_id followed by diverse ObsProps (first table even has names for column headers in a further column)
  • 2nd 2 tabs are quite strange (fungal and bacterial data). Assumption:
    • the first header row is sample_id (and "Taxonomy" at the end)
    • each column contains "ASV" values for a different bacterium or fungus, indicated in the last column with the header "Taxonomy"

Measurements at multiple points and multiple times (will we have this situation in the Mission Soil projects ? I can investigate during MS week the 5-6 nevember) :

Long term monitoring of near surface soil temperature in the french Alps part of ORCHAMP observatory

https://entrepot.recherche.data.gouv.fr/dataset.xhtml?persistentId=doi:10.57745/TVAHUQ

Evaluation: Excellent!!! Only issue is that some bits are nested in further files, some in french

Contents:

  • data
    • additional metadata file in data, includes valuable information, e.g. CRS
      • links to further metadata files, includes
        • measurement design
        • information on the sensor model
        • accuracy
        • UoM is hidden, but there
    • file with spatial information of all locations (CRS described above)

    • Data file clean, ID, Timestamp, Value

  • metadata
    • mostly administrative, but does include keywords, more than others

Structure:

  • classic CSV with headers, split across 2 files:
    • Spatial: points, ID, sensor_type, date
    • Measurements: point_ID, time, value

Long term monitoring of near surface soil temperature in the french Alps

https://entrepot.recherche.data.gouv.fr/dataset.xhtml?persistentId=doi:10.57745/JOZ1NA

Evaluation: Could be excellent if the data were actually provided

Contents:

  • Dataset
    • Same additional information as "Long term monitoring of near surface soil temperature in the french Alps part of ORCHAMP observatory" above
    • Missing the actual datasets
  • Metadata
    • Same as "Long term monitoring of near surface soil temperature in the french Alps part of ORCHAMP observatory" above

Measurements with no spatial and temporal information (located in the article probably):

Replication Data for: "Phosphorus sorption capacity and availability along a toposequence of agricultural soils: distinct effects of soil type and decadal fertilizer applications"

https://dataverse.cirad.fr/dataset.xhtml?persistentId=doi:10.18167/DVN1/CUII08

Evaluation: OK, much relevant information encoded in prose, no time as experimental

Contents:

  • Dataset
    • readme with additional info on ObsProps (name, procedure, UoM) as prose
  • Metadata
    • basic administrative
    • keywords from agrovoc
    • procedural information in prose

Structure:

  • column for location (not given)
  • additional columns per ObsProp
  • time in filename

Replication Data for: "Increased soil pH and dissolved organic matter after a decade of organic fertilizer application mitigates copper and zinc availability despite contamination"

https://dataverse.cirad.fr/dataset.xhtml?persistentId=doi:10.18167/DVN1/C7WTZB&version=2.0

Evaluation: OK, same as "Replication Data for: "Phosphorus sorption..." above, only different is ObsProp groups

Contents:

Structure:

  • column for location (not given)
  • additional columns per ObsProp
    • additional header row to indicate ObsProp/Treatment groups
  • time in filename
  • some UoM as column (Rate unit)

Replication Data for: “Phosphorus sorption and availability in an andosol after a decade of organic or mineral fertilizer applications: importance of pH and organic carbon modifications in soil as compared to phosphorus accumulation"

https://dataverse.cirad.fr/dataset.xhtml?persistentId=doi:10.18167/DVN1/L9SQVO&version=3.0 Evaluation: OK, too much in prose, no time as experimental

Contents:

  • Dataset
    • Time given as offset to treatment (6y & 10y)
    • readme with additional info on ObsProps (name, procedure, UoM) as prose, reference to "related paper" for details, incl. procedure
  • Metadata
    • uses concepts from AGRIS/CARIS, only reference to html doc, no concept links
    • Generally fairly complete, but moch im prose

Structure:

  • column for location (not given)
  • additional columns per ObsProp
    • additional header row to indicate time offset from treatment

Replication Data for: Does a decade of soil organic fertilization promote copper and zinc bioavailability to epi-endogeic earthworms?

https://dataverse.cirad.fr/dataset.xhtml?persistentId=doi:10.18167/DVN1/TU9DRY&version=1.1

Evaluation: OK, too much in prose, no time as experimental

Contents:

  • Dataset
    • readme with additional info on ObsProps (name, procedure, UoM) as prose, reference to "related paper" for details, incl. procedure
    • 2nd header row further indicating type of data, Unclear what "WHAM" column groups refer to
  • Metadata
    • Fairly complete

Structure:

  • column for location (not given)
  • additional columns per ObsProp
    • additional header row to indicate ObsProp/Treatment groups

Data for: Maize-cowpea intercropping as an ecological intensification option for low input systems in sub-humid Zimbabwe: productivity, biological N2-fixation and grain mineral content

https://dataverse.cirad.fr/dataset.xhtml?persistentId=doi:10.18167/DVN1/IJOA5J&version=2.1

Evaluation: Poor, user left to guess what isn't micro-encoded in the column headers

Contents:

  • Dataset
    • No info on columns
    • complex as covers diverse treatments
  • Metadata
    • Fairly complete

Structure:

  • Several columns for FoI
  • Time as column, offset from treatment
  • additional columns per ObsProp

Achievable agricultural soil carbon sequestration across Europe from country-­specific estimates: supplementary material

https://entrepot.recherche.data.gouv.fr/dataset.xhtml?persistentId=doi:10.57745/DPAL0I&version=1.0

Evaluation: Not relevant, questionnaire on MS estimations (not values, just X if they do). A small table with national averages in the accompanying docx, but I'm not going there now!

https://entrepot.recherche.data.gouv.fr/dataset.xhtml?persistentId=doi:10.57745/DPAL0I R

Evaluation: 404 Not Found

Clone this wiki locally