Skip to content

Latest commit

 

History

History
44 lines (36 loc) · 14 KB

mapping_SiteActivity2RDF.md

File metadata and controls

44 lines (36 loc) · 14 KB
Raw

Mapping of DEIMS-SDR Sites JSON onto Environmental Monitoring Facility Vocabulary SmOD.

Authors: Cristiano Fugazza, Alessandro Oggioni and Paolo Tagliolato. 1

Mapping based on the site https://deims.org/f30007c4-8a6e-4f11-ab87-569db54638fe

jsonPath JSON data item example Translation into SmOD Notes EMF XML example
1 $.concat($.id.prefix, $.id.suffix) "id": { "prefix": "https://deims.org/", "suffix": "f30007c4-8a6e-4f11-ab87-569db54638fe" } <https://deims.org/f30007c4-8a6e-4f11-ab87-569db54638fe> a ef:EnvironmentalMonitoringFacility ; The namespace value will be owned by the data provider of the spatial object and will be registered in the INSPIRE External Object Identifier Namespaces Register .
2 $.title "title": "Lago Maggiore - Italy" ef:name "Lago Maggiore - Italy" ; -
3 $.created "2012-12-25T18:53:38+0100" prov:startedAtTime "2012-12-25T18:53:38+0100"^^xsd:dateTime;
$.changed "2023-03-15T14:09:08+0100" "2023-03-15T14:09:08+0100"^^xsd:dateTime ;
4 $.attributes.general.abstract "general": {"abstract": "Lake Maggiore was studied since the beginning of last century although not systematically. Regular research started by the foundation in 1938 of the Italian Institute of Hydrobiology ... "} dct:description "Lake Maggiore was studied since the beginning of last century although not systematically. Regular research started by the foundation in 1938 of the Italian Institute of Hydrobiology ... " -
5 $.attributes.geographic.boundaries "attributes": {geographic": { "boundaries": "MULTIPOLYGON (((8.6159757984541 45.726276324811, 8.6144175920894 45.725807536395, 8.6139308395752 45.725576372661, 8.6129526013489 45.725568562495, …)))"}} geosparql:hasGeometry [ rdf:type sf:multipolygon ; geosparql:asWKT "urn:ogc:def:crs:EPSG::4283 MULTIPOLYGON (((8.6159757984541 45.726276324811, 8.6144175920894 45.725807536395, 8.6139308395752 45.725576372661, 8.6129526013489 45.725568562495, …)))}"^^geosparql:wktLiteral ; ] ; ef:geometry property is currently missing in SmOD# check the geometry most of the sites have polygon and some of theme have multipolygon, can be check this and change sf attribute?
6 $.attributes.geographic.coordinates "attributes": {geographic": {coordinates": "POINT (8.63403 45.9547)}} geo:lat "8.63403" ;geo:lon "45.9547" ; ef:representativePoint property is currently missing in SmOD ef:representativePoint <gml:Point gml:id="LTER_EU_IT_008_centroid" srsName="http://www.opengis.net/def/crs/EPSG/0/4326"> <gml:pos srsDimension="3"> 45.7236 8.91137 194.25 </gml:pos> </gml:Point></ef:representativePoint>
geosparql:hasGeometry [ a sf:Point ; geosparql:asWKT "urn:ogc:def:crs:EPSG::4283 POINT (8.63403 45.9547)"^^geosparql:wktLiteral
7 $.attributes.geographic.relatedLocations "attributes": "relatedLocations": [``{``"title": "Feresjön Catchment",``"id": {``"prefix": "``https://deims.org/locations/``",``"suffix": "af34c0c4-a55d-4b2f-9b68-538a1f72b6e5"``},``"changed": "2022-09-22T09:59:44+0200"``},``{``"title": "Lake Feresjön",``"id": {``"prefix": "``https://deims.org/locations/``",``"suffix": "d0b206a6-092d-468f-accf-e534ed0fdf7d"``},``"changed": "2022-08-23T12:15:19+0200"``},``{``"title": "Asa High-yield Experimental Forest ",``"id": {``"prefix": "``https://deims.org/locations/``",``"suffix": "f0f2d254-21c3-4ad3-beae-eab73cb909fa"``},``"changed": "2023-01-31T18:22:05+0100"``}``]
8 $.attributes.general.yearEstablished $.attributes.general.yearClosed "attributes": {"general":{"yearEstablished": 1960,``"yearClosed": null }``} dct:temporal [ a dct:PeriodOfTime ; dcat:startDate "1960"^^xsd:date ; dcat:endDate ""^^xsd:date ; ] ; ef:operationalActivityPeriod property is currently missing in SmOD <ef:operationalActivityPeriod xsi:nil="false"> <ef:OperationalActivityPeriod gml:id="oap01"> ef:activityTime <gml:TimePeriod gml:id="time_Period01"> gml:beginPosition1960-01-01</gml:beginPosition> <gml:endPosition indeterminatePosition="now"/> </gml:TimePeriod> </ef:activityTime> </ef:OperationalActivityPeriod> </ef:operationalActivityPeriod>
9 $.attributes.affiliation.projects[?(@.uri != null)].uri ["https://cordis.europa.eu/project/id/856506","https://cordis.europa.eu/project/id/654359","https://cordis.europa.eu/project/id/871128","https://cordis.europa.eu/project/id/871128","https://cordis.europa.eu/project/id/871128"] getit:involvedInProject "https://cordis.europa.eu/project/id/856506","https://cordis.europa.eu/project/id/654359","https://cordis.europa.eu/project/id/871128","https://cordis.europa.eu/project/id/871128","https://cordis.europa.eu/project/id/871128" ;
10 $.attributes.general.hierarchy.parent[*] [``{``"type"``:``"site"``,``"title"``:``"IT08-Southern Alpine Lakes - Italy"``,``"id"``:``{``"prefix"``:``"https://deims.org/"``,``"suffix"``:``"8ffe6c61-5473-4e56-9a6e-827baad941e5"``},``"changed"``:``"2021-11-23T11:14:44+0100"``}``] ef:broader <https://deims.org/"8ffe6c61-5473-4e56-9a6e-827baad941e5> ;
11 $.attributes.general.hierarchy.children[*] [] ef:narrower <> ;
12 $.attributes.environmentalCharacteristics.eunisHabitat[].label $.attributes.environmentalCharacteristics.geoBonBiome[] eunisHabitat[``{``"label"``:``"Inland surface waters (C)"``,``"uri"``:``null``},``{``"label"``:``"Permanent oligotrophic lakes, ponds and pools (C1.1)"``,``"uri"``:``null``},``{``"label"``:``"Surface standing waters (C1)"``,``"uri"``:``null``}``]geoBonBiome[``"Fresh water lakes"``] ef:mediaMonitored "Fresh water lakes", "Inland surface waters (C)", "Permanent oligotrophic lakes, ponds and pools (C1.1)", "Surface standing waters (C1)" mediaMonitored is from a codeList (http://inspire.ec.europa.eu/codeList/MediaValue) with some values: air, biota, landscape, sediment, soil/ground, waste, waterFor SmOD EF Ontology the media monitored is defined as: "This property specifies monitored environmental media." without use of codeList.
13 $.attributes.contact.siteManager[*] [ { "type": "person", "name": "Michela Rogora", "email": "michela.rogora@irsa.cnr.it", "orcid": null }] dcat:contactPoint [ rdf:type prov:Person , foaf:Person ; foaf:fullName "Michela Rogora" ; foaf:hasEmail "michela.rogora@irsa.cnr.it" ] ;
14 $.attributes.affiliation.networks[*].network.id.suffix ["1aa7ccb2-a14b-43d6-90ac-5e0a6bc1d65b","4742ffca-65ac-4aae-815f-83738500a1fc","7fef6b73-e5cb-4cd2-b438-ed32eb1504b3"] ef:belongsTo https://deims.org/network/7fef6b73-e5cb-4cd2-b438-ed32eb1504b3 , https://deims.org/network/4742ffca-65ac-4aae-815f-83738500a1fc , https://deims.org/network/1aa7ccb2-a14b-43d6-90ac-5e0a6bc1d65b ; link to network(s)
15 $.attributes.relatedResources[?(@.id.prefix=='https://deims.org/activity/')].id.suffix [] ef:involvedIn <> link to activity(ies)
16 $.attributes.relatedResources[?(@.id.prefix=='https://deims.org/sensors/')] [ { "id": { "prefix": "https://deims.org/sensors/", "suffix": 82635223-a4f4-498c-b283-9c95999d9d2f }, "title": "Moldaenke FluoroProbe sensor", "changed": "2022-05-19T21:02:49+0200" }] https://deims.org/sensors/82635223-a4f4-498c-b283-9c95999d9d2f rdf:type prov:Entity , ef:EnvironmentalMonitoringFacility ; ef:broader https://deims.org/8eda49e9-1f4e-4f3e-b58e-e0bb25dc32a6 ; ef:specialisedEMFType "sensor"@en . link to sensor(s)
17 concat($.attributes.relatedResources[?(@.id.prefix=="https://deims.org/dataset/")].id.prefix, $.attributes.relatedResources[?(@.id.prefix=="https://deims.org/dataset/")].id.suffix) [``{``"id"``:``{``"prefix"``:``"https://deims.org/dataset/"``,``"suffix"``:``"d9e94776-e7a8-11e2-a655-005056ab003f"``},``"title"``:``"Biovolume of Phytoplankton in Lake Maggiore site code IT_SI001137_within the period 1981 - 2010"``,``"changed"``:``"2021-08-25T16:38:25+0200"``},``{...}``] ef:hasObservation a rdf:Property; rdfs:domain ef:EnvironmentalMonitoringFacility; rdfs:range ef:EnvironmentalMonitoringFacility .ef:hasObservation <https://deims.org/dataset/d9e94776-e7a8-11e2-a655-005056ab003f> ef:hasObservation property is currently missing in SmODlink to dataset(s) <ef:hasObservation xlink:title="Biovolume of Phytoplankton in Lake Maggiore site code IT_SI001137_within the period 1981 - 2010" xlink:href="https://deims.org/dataset/d9e94776-e7a8-11e2-a655-005056ab003f" />

Mapping based on the Activity https://deims.org/activity/08dbd115-758e-4edc-ad26-2c820a32fb53

jsonPath JSON data item example Translation into SmOD Notes EMF XML example
1 $.concat($.id.prefix, $.id.suffix) "https://deims.org/activity/08dbd115-758e-4edc-ad26-2c820a32fb53" https://deims.org/activity/08dbd115-758e-4edc-ad26-2c820a32fb53 a ef:EnvironmentalMonitoringActivity, prov:Activity ;
2 $.title "Long-term ornithological monitoring Nationalpark … " ef:name "Long-term ornithological monitoring Nationalpark …"
3 $.attributes.general.abstract "Yearly counts of typical … " dct:description "Yearly counts of typical …"
4 $.attributes.geographic.boundaries "MULTIPOLYGON (((16.798697 47.736091, 16.808224 47.724198, 16.806507 47.722812, 16.808867 47.719637, 16.80994 47.715652, 16.812344 47.713862, 16.815262 47.712534, 16.817966 47.711812, 16.810584 47.705199, …)), ((...)), ((...)), ((...)), ((...)))" geosparql:hasGeometry [ a sf:multipolygon ; geosparql:asWKT "urn:ogc:def:crs:EPSG::4283 MULTIPOLYGON (((16.798697 47.736091, 16.808224 47.724198, 16.806507 47.722812, 16.808867 47.719637, 16.80994 47.715652, 16.812344 47.713862, 16.815262 47.712534, 16.817966 47.711812, 16.810584 47.705199, …)), ((...)), ((...)), ((...)), ((...)))"^^geosparql:wktLiteral ] ;
5 $.created "2020-09-18T14:11:19+0200" prov:startedAtTime "2020-09-18T14:11:19+0200"^^xsd:dateTime
6 $.changed "2022-06-27T13:05:38+0200" dct:modified "2022-06-27T13:05:38+0200"^^xsd:dateTime ;
7 $.attributes.general.keywords[*].label [``{``"label"``:``"Biology and Population Ecology"``,``"uri"``:``null``},``{...}``] dcat:keyword "Biology and Population Ecology" , "..." ;
8 $.attributes.contact.corresponding[*] [``{``"type": "person",``"name": "Thomas Dirnboeck",``"email": "thomas.dirnboeck@umweltbundesamt.at",``"orcid": "https://orcid.org/0000-0002-8294-0690"``}``]

Footnotes

  1. {fugazza.c, oggioni.a, tagliolato.p}@irea.cnr.it ↩