Snapshot of ingested metadata records from the SoilWiseHE Data & Knowledge repository

This dataset contains 20.000 metadata records of datasets and knowledge sources related to Soil Health, which are imported from various repositories and, if needed, harmonised to the Dublin Core or ISO19139:2007 schema.

This is a dump of key fields in the postgres database used by the pycsw software used in this project.

Fields:

- identifier: Either a uuid or DOI

- schema: Either iso19139:2007 (indicated as http://www.isotc211.org/2005/gmd) or Dublin Core (indicated as http://www.opengis.net/cat/csw/2.0.2)

- xml: The actual imported (or harmonised content)

Sources:

Esdac

EEA

FAO

ISRIC

Bonares

Inspire

Prepsoil

Impact4soil

Cordis

OpenAire

EJP Soil

Islandr

SQL to extract the data: 

SELECT 

   identifier, schema, regexp_replace(xml, E'[\\n\\r]+', ' ', 'g' ) as xml

FROM

   public.recordsORDER BY

   identifier ASC

The SoilWise project received funding from the European Union’s HORIZON Innovation Actions 2022 under grant agreement No. 101112838.