Skip to content

SDG Knowledge Organization System

Szymon Klarman edited this page Jan 8, 2020 · 2 revisions

The SDG Knowledge Organization System is a linked data-based vocabulary describing Sustainable Development Goals and related concepts. It is published on Dag Hammarskjöld Library metadata platform and consists of two parts:

The SDG ontology formalizes the basic schema of the SDG goal-target-indicator-series hierarchy, as depicted in the following diagram:

SDG ontology.

To further increase semantic interoperability, the SDG ontology is aligned with the SKOS Core Vocabulary -- one of most broadly adopted, lightweight W3C standards, intended for representing taxonomies and thesauri. This alignment rests on the following set of sub-class and sub-property axioms:

  • sdgo:Goal rdfs:subClassOf skos:Concept
  • sdgo:Target rdfs:subClassOf skos:Concept
  • sdgo:Indicator rdfs:subClassOf skos:Concept
  • sdgo:Series rdfs:subClassOf skos:Concept
  • sdgo:hasTarget rdfs:subPropertyOf skos:narrower
  • sdgo:hasIndicator rdfs:subPropertyOf skos:narrower
  • sdgo:hasSeries rdfs:subPropertyOf skos:narrower
  • sdgo:isTargetOf rdfs:subPropertyOf skos:broader
  • sdgo:isIndicatorOf rdfs:subPropertyOf skos:broader
  • sdgo:isSeriesOf rdfs:subPropertyOf skos:broader

The SDG taxonomy describes the individual SDG entities in the goal-target-indicator-series hierarchy, i.e., goals, targets, indicators & series. Further, it includes a selection of mappings to external vocabularies:

The following JSON-LD object presents an example description of an SDG target 1.1 in SDG KOS dataset:

{
    "@context": {
        "dct": "http://purl.org/dc/terms/",
        "skos": "http://www.w3.org/2004/02/skos/core#",
        "sdgo": "http://metadata.un.org/sdg/ontology#"
    },
    "@id": "http://metadata.un.org/sdg/1.1",
    "@type": [
        "sdgo:Target",
        "skos:Concept"
    ],
    "skos:prefLabel": [
        {
            "@value": "By 2030, eradicate extreme poverty for all people everywhere, currently measured as people living on less than $1.25 a day",
            "@language": "en"
        },
        {
            "@value": "De aquí a 2030, erradicar para todas las personas y en todo el mundo la pobreza extrema (actualmente se considera que sufren pobreza extrema las personas que viven con menos de 1,25 dólares de los Estados Unidos al día)",
            "@language": "es"
        },
        {
            "@value": "D’ici à 2030, éliminer complètement l’extrême pauvreté dans le monde entier (s’entend actuellement du fait de vivre avec moins de 1,25 dollar des États‑Unis par jour)",
            "@language": "fr"
        }
    ],
    "skos:altLabel": [
        {
            "@value": "Target 1.1",
            "@language": "en"
        },
        {
            "@value": "Meta 1.1",
            "@language": "es"
        },
        {
            "@value": "Cible 1.1",
            "@language": "fr"
        }
    ],
    "sdgo:hasIndicator": [
        {
            "@id": "http://metadata.un.org/sdg/C010101"
        }
    ],
    "sdgo:isTargetOf": [
        {
            "@id": "http://metadata.un.org/sdg/1"
        }
    ],
    "skos:narrower": [
        {
            "@id": "http://metadata.un.org/sdg/C010101"
        }
    ],
    "skos:broader": [
        {
            "@id": "http://metadata.un.org/sdg/1"
        }
    ],
    "skos:exactMatch": [
        {
            "@id": "http://purl.unep.org/sdg/SDGIO_00000057"
        }
    ],
    "dct:subject": [
        {
            "@id": "http://metadata.un.org/thesaurus/1005064"
        },
        {
            "@id": "http://eurovoc.europa.eu/2281"
        },
        {
            "@id": "http://eurovoc.europa.eu/2062"
        },
        {
            "@id": "http://metadata.un.org/thesaurus/1000544"
        },
        {
            "@id": "http://eurovoc.europa.eu/6781"
        },
        {
            "@id": "http://metadata.un.org/thesaurus/1006166"
        }
    ],
    "skos:notation": [
        "01.01",
        "1.1"
    ],
    "skos:inScheme": {
        "@id": "http://metadata.un.org/sdg"
    }
}

skos:exactMatch mappings

Some of the SDG entities are mapped to external resources representing the same concepts in other vocabularies (currently SDGIO and Wikidata). The designated property for representing such mappings is skos:exactMatch. For example, the following are the mappings for all SDG goals:

<http://metadata.un.org/sdg/1> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://purl.unep.org/sdg/SDGIO_00000035> .
<http://metadata.un.org/sdg/1> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://www.wikidata.org/entity/Q50214636> .
<http://metadata.un.org/sdg/2> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://purl.unep.org/sdg/SDGIO_00000036> .
<http://metadata.un.org/sdg/2> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://www.wikidata.org/entity/Q50215926> .
<http://metadata.un.org/sdg/3> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://purl.unep.org/sdg/SDGIO_00000037> .
<http://metadata.un.org/sdg/3> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://www.wikidata.org/entity/Q50216838> .
<http://metadata.un.org/sdg/4> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://purl.unep.org/sdg/SDGIO_00000038> .
<http://metadata.un.org/sdg/4> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://www.wikidata.org/entity/Q53581209> .
<http://metadata.un.org/sdg/5> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://purl.unep.org/sdg/SDGIO_00000039> .
<http://metadata.un.org/sdg/5> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://www.wikidata.org/entity/Q53581210> .
<http://metadata.un.org/sdg/6> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://purl.unep.org/sdg/SDGIO_00000040> .
<http://metadata.un.org/sdg/6> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://www.wikidata.org/entity/Q48741129> .
<http://metadata.un.org/sdg/7> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://purl.unep.org/sdg/SDGIO_00000041> .
<http://metadata.un.org/sdg/7> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://www.wikidata.org/entity/Q53581213> .
<http://metadata.un.org/sdg/8> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://purl.unep.org/sdg/SDGIO_00000042> .
<http://metadata.un.org/sdg/8> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://www.wikidata.org/entity/Q53581217> .
<http://metadata.un.org/sdg/9> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://purl.unep.org/sdg/SDGIO_00000043> .
<http://metadata.un.org/sdg/9> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://www.wikidata.org/entity/Q53581219> .
<http://metadata.un.org/sdg/10> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://purl.unep.org/sdg/SDGIO_00000044> .
<http://metadata.un.org/sdg/10> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://www.wikidata.org/entity/Q53581222> .
<http://metadata.un.org/sdg/11> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://purl.unep.org/sdg/SDGIO_00000045> .
<http://metadata.un.org/sdg/11> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://www.wikidata.org/entity/Q53581228> .
<http://metadata.un.org/sdg/12> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://purl.unep.org/sdg/SDGIO_00000046> .
<http://metadata.un.org/sdg/12> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://www.wikidata.org/entity/Q53581232> .
<http://metadata.un.org/sdg/13> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://purl.unep.org/sdg/SDGIO_00000047> .
<http://metadata.un.org/sdg/13> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://www.wikidata.org/entity/Q53581236> .
<http://metadata.un.org/sdg/14> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://purl.unep.org/sdg/SDGIO_00000048> .
<http://metadata.un.org/sdg/14> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://www.wikidata.org/entity/Q53581239> .
<http://metadata.un.org/sdg/15> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://purl.unep.org/sdg/SDGIO_00000049> .
<http://metadata.un.org/sdg/15> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://www.wikidata.org/entity/Q53581245> .
<http://metadata.un.org/sdg/16> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://purl.unep.org/sdg/SDGIO_00000050> .
<http://metadata.un.org/sdg/16> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://www.wikidata.org/entity/Q53581248> .
<http://metadata.un.org/sdg/17> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://purl.unep.org/sdg/SDGIO_00000051> .
<http://metadata.un.org/sdg/17> <http://www.w3.org/2004/02/skos/core#exactMatch> <http://www.wikidata.org/entity/Q53581254> .

The mappings are part of the KOS file: sdg-kos-goals-targets-indicators.ttl.

The presence of mappings allows for exploring/fetching additional data from external RDF graphs, following the fundamental concept of the linked open data. The following federated SPARQL query associates each goal in the SDG KOS with the corresponding subject descriptions and images for those goals in Wikidata:

PREFIX sdgo: <http://metadata.un.org/sdg/ontology#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX dct: <http://purl.org/dc/terms/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT * WHERE {
	  GRAPH <http://metadata.un.org/sdg> {  
        ?x a sdgo:Goal .
        ?x skos:exactMatch ?y .
        FILTER(CONTAINS(str(?y), "wikidata"))
    }
    
    SERVICE <https://query.wikidata.org/bigdata/namespace/wdq/sparql> {
        ?y <http://www.wikidata.org/prop/direct/P921> ?wikiSubject .
        ?wikiSubject rdfs:label ?lab .
        FILTER (lang(?lab)="en")
        ?y <http://www.wikidata.org/prop/direct/P18> ?image .
    }
}

Results:

|x                            |y                                       |wikiSubject                             |lab                    |image                                                                                       |
|-----------------------------|----------------------------------------|----------------------------------------|-----------------------|--------------------------------------------------------------------------------------------|
|http://metadata.un.org/sdg/1 |http://www.wikidata.org/entity/Q50214636|http://www.wikidata.org/entity/Q10294   |poverty                |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%201.png |
|http://metadata.un.org/sdg/1 |http://www.wikidata.org/entity/Q50214636|http://www.wikidata.org/entity/Q131201  |sustainable development|http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%201.png |
|http://metadata.un.org/sdg/2 |http://www.wikidata.org/entity/Q50215926|http://www.wikidata.org/entity/Q165947  |hunger                 |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%202.png |
|http://metadata.un.org/sdg/2 |http://www.wikidata.org/entity/Q50215926|http://www.wikidata.org/entity/Q131201  |sustainable development|http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%202.png |
|http://metadata.un.org/sdg/3 |http://www.wikidata.org/entity/Q50216838|http://www.wikidata.org/entity/Q15854939|welfare                |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%203.png |
|http://metadata.un.org/sdg/3 |http://www.wikidata.org/entity/Q50216838|http://www.wikidata.org/entity/Q31207   |health care            |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%203.png |
|http://metadata.un.org/sdg/3 |http://www.wikidata.org/entity/Q50216838|http://www.wikidata.org/entity/Q131201  |sustainable development|http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%203.png |
|http://metadata.un.org/sdg/4 |http://www.wikidata.org/entity/Q53581209|http://www.wikidata.org/entity/Q131201  |sustainable development|http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%204.png |
|http://metadata.un.org/sdg/4 |http://www.wikidata.org/entity/Q53581209|http://www.wikidata.org/entity/Q8434    |education              |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%204.png |
|http://metadata.un.org/sdg/5 |http://www.wikidata.org/entity/Q53581210|http://www.wikidata.org/entity/Q113453  |gender equality        |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%205.png |
|http://metadata.un.org/sdg/6 |http://www.wikidata.org/entity/Q48741129|http://www.wikidata.org/entity/Q283     |water                  |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%206.png |
|http://metadata.un.org/sdg/6 |http://www.wikidata.org/entity/Q48741129|http://www.wikidata.org/entity/Q949149  |sanitation             |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%206.png |
|http://metadata.un.org/sdg/7 |http://www.wikidata.org/entity/Q53581213|http://www.wikidata.org/entity/Q3406659 |energy production      |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%207.png |
|http://metadata.un.org/sdg/8 |http://www.wikidata.org/entity/Q53581217|http://www.wikidata.org/entity/Q189833  |economic growth        |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%208.png |
|http://metadata.un.org/sdg/9 |http://www.wikidata.org/entity/Q53581219|http://www.wikidata.org/entity/Q8148    |industry               |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%209.png |
|http://metadata.un.org/sdg/9 |http://www.wikidata.org/entity/Q53581219|http://www.wikidata.org/entity/Q121359  |infrastructure         |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%209.png |
|http://metadata.un.org/sdg/9 |http://www.wikidata.org/entity/Q53581219|http://www.wikidata.org/entity/Q174165  |innovation             |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%209.png |
|http://metadata.un.org/sdg/10|http://www.wikidata.org/entity/Q53581222|http://www.wikidata.org/entity/Q13416790|social equality        |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%2010.png|
|http://metadata.un.org/sdg/11|http://www.wikidata.org/entity/Q53581228|http://www.wikidata.org/entity/Q515     |city                   |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%2011.png|
|http://metadata.un.org/sdg/11|http://www.wikidata.org/entity/Q53581228|http://www.wikidata.org/entity/Q486972  |human settlement       |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%2011.png|
|http://metadata.un.org/sdg/12|http://www.wikidata.org/entity/Q53581232|http://www.wikidata.org/entity/Q192270  |consumption            |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%2012.png|
|http://metadata.un.org/sdg/12|http://www.wikidata.org/entity/Q53581232|http://www.wikidata.org/entity/Q739302  |production             |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%2012.png|
|http://metadata.un.org/sdg/13|http://www.wikidata.org/entity/Q53581236|http://www.wikidata.org/entity/Q125928  |climate change         |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%2013.png|
|http://metadata.un.org/sdg/14|http://www.wikidata.org/entity/Q53581239|http://www.wikidata.org/entity/Q37813   |ecosystem              |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%2014.png|
|http://metadata.un.org/sdg/14|http://www.wikidata.org/entity/Q53581239|http://www.wikidata.org/entity/Q3       |life                   |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%2014.png|
|http://metadata.un.org/sdg/14|http://www.wikidata.org/entity/Q53581239|http://www.wikidata.org/entity/Q47041   |biodiversity           |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%2014.png|
|http://metadata.un.org/sdg/15|http://www.wikidata.org/entity/Q53581245|http://www.wikidata.org/entity/Q37813   |ecosystem              |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%2015.png|
|http://metadata.un.org/sdg/15|http://www.wikidata.org/entity/Q53581245|http://www.wikidata.org/entity/Q47041   |biodiversity           |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%2015.png|
|http://metadata.un.org/sdg/16|http://www.wikidata.org/entity/Q53581248|http://www.wikidata.org/entity/Q178706  |institution            |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%2016.png|
|http://metadata.un.org/sdg/16|http://www.wikidata.org/entity/Q53581248|http://www.wikidata.org/entity/Q454     |peace                  |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%2016.png|
|http://metadata.un.org/sdg/16|http://www.wikidata.org/entity/Q53581248|http://www.wikidata.org/entity/Q180684  |conflict               |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%2016.png|
|http://metadata.un.org/sdg/16|http://www.wikidata.org/entity/Q53581248|http://www.wikidata.org/entity/Q5167661 |justice                |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%2016.png|
|http://metadata.un.org/sdg/17|http://www.wikidata.org/entity/Q53581254|http://www.wikidata.org/entity/Q728646  |partnership            |http://commons.wikimedia.org/wiki/Special:FilePath/Sustainable%20Development%20Goal%2017.png|