Get the SDGs indexed in Wikidata

[Daniel-Mietchen]

• [x] SDGs
• [x] targets
• [x] indicators

Starting point: https://unstats.un.org/sdgs/indicators/indicators-list/

[Daniel-Mietchen]

Overview so far: https://tools.wmflabs.org/reasonator/?q=Q7649586&lang=en

Only one indexed so far is reducing maternal mortality: https://tools.wmflabs.org/reasonator/?&q=28545394 . So I'll use this for testing/demoing purposes.

[Daniel-Mietchen]

Useful corpus on out of school data: https://twitter.com/NavinoEvans/status/948169800991338496 .

[Daniel-Mietchen]

See also the SDG tracker at https://sdg-tracker.org/

[Daniel-Mietchen]

From http://www.ascleiden.nl/news/digital-sources-african-history-wikidata-elias-12-vienna :

Åsa Lund Moberg, Chief Librarian oft the Nordic Africa Institute (NAI) in Uppsala, covered quite a different subject: she demonstrated how the NAI has included the Sustainable Development Goals into the institute and its Library, and how this changed their view on certain topics.

[Daniel-Mietchen]

Here is how that inclusion of the SDGs looks like on their website: http://nai.uu.se/library/resources/thematicresources/africa-and-the-sdgs/ .

[Daniel-Mietchen]

Here's a first attempt at a Wikidata graph:

#defaultView:Graph
PREFIX target:           <http://www.wikidata.org/entity/Q53580881>

SELECT ?node ?nodeLabel ?nodeImage ?childNode ?childNodeLabel ?childNodeImage ?rgb WHERE {
  {
    BIND(target: AS ?node)
    ?node ?p ?i.
    OPTIONAL { ?node wdt:P18 ?nodeImage. }
    ?childNode ?x ?p.
    ?childNode rdf:type wikibase:Property.
    FILTER(STRSTARTS(STR(?i), "http://www.wikidata.org/entity/Q"))
    FILTER(STRSTARTS(STR(?childNode), "http://www.wikidata.org/entity/P"))
  }
  UNION
  {
    BIND("EFFBD8" AS ?rgb)
    target: ?p ?childNode.
    OPTIONAL { ?childNode wdt:P18 ?childNodeImage. }
    ?node ?x ?p.
    ?node rdf:type wikibase:Property.
    FILTER(STRSTARTS(STR(?childNode), "http://www.wikidata.org/entity/Q"))
  }
  OPTIONAL {
    ?node wdt:P18 ?nodeImage.
    ?childNode wdt:P18 ?childNodeImage.
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}

Needs a bit more work along the lines of https://tools.wmflabs.org/scholia/taxon/Q12024 to become useful.

[Daniel-Mietchen]

Here is a similar query that yields nice results for Berlin

but less so for the Zika virus,

for UVA

or the SDGs:

#defaultView:Graph
PREFIX target:           <http://www.wikidata.org/entity/Q64>
SELECT ?node ?nodeLabel ?nodeImage ?childNode ?childNodeLabel ?childNodeImage ?rgb WHERE {
  {
    BIND(target: AS ?node)
    ?node ?p ?i.
    OPTIONAL { ?node wdt:P18 ?nodeImage. }
    ?childNode ?x ?p.
    ?childNode rdf:type wikibase:Property.
    FILTER(STRSTARTS(STR(?i), "http://www.wikidata.org/entity/Q"))
    FILTER(STRSTARTS(STR(?childNode), "http://www.wikidata.org/entity/P"))
  }
  UNION
  {
    BIND("EFFBD8" AS ?rgb)
    target: ?p ?childNode.
    OPTIONAL { ?childNode wdt:P18 ?childNodeImage. }
    ?node ?x ?p.
    ?node rdf:type wikibase:Property.
    FILTER(STRSTARTS(STR(?childNode), "http://www.wikidata.org/entity/Q"))
  }
  OPTIONAL {
    ?node wdt:P18 ?nodeImage.
    ?childNode wdt:P18 ?childNodeImage.
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}

[Daniel-Mietchen]

The same for Jena

and Charlottesville

[Daniel-Mietchen]

There is now https://www.wikidata.org/wiki/Wikidata:WikiProject_Sustainable_Development .

[Daniel-Mietchen]

See also imports by Navino Evans on fertility et al., e.g. as per https://twitter.com/NavinoEvans/status/967072436834459648 .

[Daniel-Mietchen]

The SDGs are now all in, along with all targets and indicators. For further workon the matter, I will be using the above-mentioned WikiProject by default rather than this GitHub repo.