Wikidata:WikiProject Sustainable Development

The Sustainable Development Goals were the theme of Wikimania 2019 but the engagement of Wikimedians goes back much further and continues in multiple ways

About

WikiProject Sustainable Development (Q56507949) is concerned with curating information about sustainable development (Q131201) and related topics. We are just getting started, and you are most welcome to join in.

Items

• sustainable development (Q131201)
• Millennium Development Goal (Q81737)
• Sustainable Development Goals (Q7649586)
  • Sustainable Development Goal (Q53580881)
    • Sustainable Development Goal 6 (Q48741129)
  • Sustainable Development Goal Target (Q56724848)
    • Target 6.4 of the Sustainable Development Goals (Q56725726)
    • Sustainable Development Goal Indicator (Q56726345)
      • Indicator 6.4.2 of the Sustainable Development Goals (Q56726276)
        • Physical water scarcity metrics for monitoring progress towards SDG target 6.4: An evaluation of indicator 6.4.2 "Level of water stress". (Q46306401)
• Category:Sustainable development (Q6314770)

Sustainable Development Goal Target (Q56724848) items should be connected to their Sustainable Development Goal (Q53580881) counterparts as facet of (P1269). Example:

⟨ Target 6.4 of the Sustainable Development Goals (Q56725726)    ⟩ facet of (P1269) ⟨ Sustainable Development Goal 6 (Q48741129)    ⟩

The same goes for Sustainable Development Goal Indicator (Q56726345) and Sustainable Development Goal Target (Q56724848), example:

⟨ Indicator 6.4.2 of the Sustainable Development Goals (Q56726276)    ⟩ facet of (P1269) ⟨ Target 6.4 of the Sustainable Development Goals (Q56725726)    ⟩

Properties

General

• IUCN protected areas category (P814)
• Human Development Index (P1081)
• number of children (P1971)
• disease burden (P2854)
• located in protected area (P3018)
• compulsory education (minimum age) (P3270)
• compulsory education (maximum age) (P3271)
• significant environmental impact (P3643)
• WFD Ecological status (P4002)
• total fertility rate (P4841)

External identifiers

• ÚSOP code (P677)
• WDPA ID (P809)
• protected areas INPN Code (P1848)
• Danish protected area ID (P2763)
• DRÚSOP ID (P3296)
• Canadian Environmental Sustainability Indicators ID (Protected areas) (P3412)
• Natura 2000 site ID (P3425)
• NPCA ID (P3515)
• National Park Foundation ID (P3516)
• Danish ancient monument ID (P3596)
• protected heritage site in Brussels ID (P3600)
• Naturvårdsregistret ID (P3613)
• Parks.it ID (P3810)
• Latvian Protected Nature Territory URL (P4001)
• Latvian Protected Nature Territory ID (P4029)
• Czech Monument Catalogue Number (P4075)
• Rivers.gov protected area ID (P4190)
• Protected Buildings Register in Finland ID (P5310)
• EUAP ID (P4800)

Queries

Line chart of Human Development Index over time for a set of countries

The following query uses these:

• Items: country (Q6256)   , Finland (Q33)   , United States of America (Q30)   , China (Q148)   , India (Q668)   , Saudi Arabia (Q851)   , Russia (Q159)   , Norway (Q20)   , Central African Republic (Q929)   

• Properties: instance of (P31)   , Human Development Index (P1081)   , point in time (P585)   

  #defaultView:LineChart
  # The following implementation was inspired by the code here: https://stackoverflow.com/questions/49066390/how-to-get-only-the-most-recent-value-from-a-wikidata-property
  # Read https://en.wikipedia.org/wiki/Human_Development_Index for more on the Human Development Index.
  
  SELECT ?year ?hdiValue ?country ?countryLabel WHERE {
    ?country wdt:P31 wd:Q6256.
    OPTIONAL {
      ?country p:P1081 ?hdi.
      ?hdi pq:P585 ?hdiDate.
      ?hdi ps:P1081 ?hdiValue.
    }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    BIND(STR(YEAR(?hdiDate)) AS ?year).
    FILTER (?country IN (wd:Q33, wd:Q30, wd:Q148, wd:Q668, wd:Q851, wd:Q159, wd:Q20, wd:Q929))
  }
  

Try it!

List of Sustainable Development Goals

The following query uses these:

• Items: Sustainable Development Goals (Q7649586)   

• Properties: part of (P361)   

  SELECT ?item ?label ?itemDescription
  WHERE {
    ?item wdt:P361 wd:Q7649586.
    SERVICE wikibase:label {
      bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
      ?item rdfs:label ?label.
    }
  }
  

Try it!

Fields of work of the Sustainable Development Goals

• to do

List of Sustainable Development Goal Targets

The following query uses these:

• Items: Sustainable Development Goal Target (Q56724848)   

• Properties: instance of (P31)   

  SELECT ?item ?label ?itemDescription
  WHERE {
    ?item wdt:P31 wd:Q56724848.
    SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". ?item rdfs:label ?label.}
  }
  ORDER BY (?label)
  

Try it!

Ordered List of Sustainable Development Goal Targets

The following query uses these:

• Items: Sustainable Development Goals (Q7649586)   

• Properties: has part(s) (P527)   , series ordinal (P1545)   

  SELECT ?goal ?goalLabel ?serial ?goalDescription
  WHERE {
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
    wd:Q7649586 p:P527 ?goal_statement.
    ?goal_statement ps:P527 ?goal.
    OPTIONAL {
      ?goal_statement pq:P1545 ?serial.
    }
  }
  Order by xsd:integer(?serial)
  

Try it!

List of Sustainable Development Goal Indicators

The following query uses these:

• Items: Sustainable Development Goal Indicator (Q56726345)   

• Properties: instance of (P31)   

  SELECT ?item ?label ?itemDescription
  WHERE {
    ?item wdt:P31 wd:Q56726345.
    SERVICE wikibase:label {
      bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".
      ?item rdfs:label ?label.
    }
  }
  

Try it!

List of Sustainable Development Goals, their targets and indicators

The following query uses these:

• Items: Sustainable Development Goal Indicator (Q56726345)   , Sustainable Development Goals (Q7649586)   

• Properties: instance of (P31)   , facet of (P1269)   , part of (P361)   , series ordinal (P1545)   

  SELECT ?goalLabel ?goal ?targetLabel ?target ?indicatorLabel ?indicator WHERE {
    ?indicator wdt:P31 wd:Q56726345;
               wdt:P1269 ?target .
    ?target wdt:P1269 ?goal.
    ?goal p:P361 ?part.
    ?part ps:P361 wd:Q7649586;
          pq:P1545 ?order .
    SERVICE wikibase:label {
      bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . 
    }
  }
  ORDER BY ASC (xsd:integer(?order))
  

Try it!

Sustainable Development Goals and their topics

The following query uses these:

• Items: Sustainable Development Goals (Q7649586)   

• Properties: part of (P361)   , main subject (P921)   , image (P18)   

Features: Graph (Q24515287)   

#defaultView:Graph
SELECT ?item ?label ?_image ?topic ?topicLabel WHERE {
  ?item wdt:P361 wd:Q7649586.
  OPTIONAL {?item wdt:P921 ?topic.}.
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" . 
  }
  
OPTIONAL { ?item wdt:P18 ?_image. }
}
LIMIT 100

Try it!

Organizations working on topics of the SDGs

See discussion for more info

The following query uses these:

• Items: organization (Q43229)   , Sustainable Development Goals (Q7649586)   

• Properties: field of work (P101)   , instance of (P31)   , subclass of (P279)   , part of (P361)   , main subject (P921)   

  SELECT ?s ?sLabel ?subject ?subjectLabel ?sdg ?sdgLabel 
  WHERE { 
    ?s wdt:P101 ?subject. 
    ?s wdt:P31/wdt:P279* wd:Q43229. 
      { 
        SELECT DISTINCT ?subject WHERE { 
          ?sdg wdt:P361 wd:Q7649586. 
          ?sdg wdt:P921 ?subject. 
        } 
      } 
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en" .
                           } 
  } LIMIT 100
  

Try it!

Organizations whose field of work is any SDGs

See discussion for more info

The following query uses these:

• Items: Sustainable Development Goal (Q53580881)   

• Properties: instance of (P31)   , field of work (P101)   

  SELECT ?subjectLabel ?sdgLabel
  WHERE {
    ?sdg wdt:P31 wd:Q53580881.
    ?subject wdt:P101 ?sdg.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } 
  }
  

Try it!

Participants

[+] Add yourself to the list

The participants listed below can be notified using the following template in discussions:
{{Ping project|Sustainable Development}}

• Daniel Mietchen (talk) 21:28, 15 May 2018 (UTC)
• Gregor Hagedorn (talk) 15:38, 23 September 2018 (UTC)
• Ainali (talk) 08:00, 14 October 2018 (UTC)
• Michael Cieslik (talk) 13:52, 26 November 2018 (UTC)
• Pdehaye (talk) 00:50, 16 February 2019 (UTC)
• Cassandreces (talk) 17:22, 19 February 2019 (UTC)
• Pauljmackay (talk) 18:32, 2 March 2019 (UTC)
• Will (Wiki Ed) (talk) 16:31, 24 March 2020 (UTC)

Wikimania

Note that Wikimania 2019 (Q48010913) had the SDG's as its theme.

See also

• Wikidata:WikiProject Climate Change
• Scholia on
  • Sustainable Development Goals
  • maternal mortality
  • biodiversity
• m:Wikimedians for Sustainable Development
• m:WikiProject:United Nations
• Wikiproject for Education for Sustainable Development
• en:Portal:Sustainable development
• en:Wikipedia:WikiProject International Development
• en:Wikipedia:WikiProject Environment/Sustainability task force
• en:Wikipedia:WikiProject Water
• Wikipedia and sustainable development
• Wikidata:WikiProject Africa
• Knowledge management at the UN
• Development Initiative
• UN Stats spaces
• UN Data Interoperability guide
• indicators, targets, goals
• CSR indicators mapping
• Wikidata scholarly articles about SDGs