query-c21931807c44c36889b9797fec424d11
Organizations working towards SDGsTrying to link organizations (NGOs, non profits, international org, companies, etc) with SDGs through their work. a) A possible way could be through main subject of SDGs: ⟩ (Q174165)innovation ⟨ (P921)main subject ⟩ (Q53581219)Sustainable Development Goal 9 ⟨ These main subjects can be a set of 'SDG topics' or similar, that can afterwards be linked with organizations this way: ⟩ (Q174165)innovation ⟨ (P101)field of work ⟩ (Q59695802)PersonalData.IO ⟨ So if I want to search for all organizations working on topics that align to the SDGs, I could do the following query: Propertiesfield of work (P101)instance of (P31)subclass of (P279)part of (P361)main subject (P921)
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
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
Query found at
- https://www.wikidata.org/wiki/Wikidata:WikiProject_Sustainable_Development
- https://www.wikidata.org/wiki/Wikidata_talk:WikiProject_Sustainable_Development
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?s"):::projected
v3("?sdg"):::projected
v2("?subject"):::projected
a1((" "))
c9(["bd:serviceParam"]):::iri
c11(["en"]):::literal
c6(["wd:Q7649586"]):::iri
c4(["wd:Q43229"]):::iri
v1 --"wdt:P101"--> v2
v1 --"wdt:P31"--> a1
a1 --"wdt:P279"--> c4
v3 --"wdt:P361"--> c6
v3 --"wdt:P921"--> v2
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c9 --"wikibase:language"--> c11
end