Graph example
#defaultView:Map
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
SELECT ?report ?reportLabel ?location ?locationLabel ?geo {
?report dreamst:P12 ?location .
?location dreamst:P13 ?geo
SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
}
Sustainable Development Goals
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
SELECT ?sdg ?sdgLabel {
?sdg dreamst:P2 dreams:Q22 .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Impact graph from ontology
#defaultView:Graph
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
SELECT ?concept2 ?concept2Label ?concept1 ?concept1Label {
?concept2 dreamst:P14 ?concept1 .
{ BIND (dreams:Q49 AS ?concept1) }
UNION
{
?concept1 dreamst:P14+ dreams:Q49 .
?concept2 dreamst:P14+ dreams:Q49 .
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
}
Subactivities ontology
#defaultView:Graph
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
SELECT ?concept1 ?concept1Label ?rgb ?concept2 ?concept2Label {
?concept1 dreamst:P14 ?concept2 .
{ BIND (dreams:Q106 AS ?concept2) }
UNION
{
?concept1 dreamst:P14+ dreams:Q106 .
}
OPTIONAL {
?concept1 dreamst:P19 ?project_phase1 .
BIND( IF(?project_phase1 = dreams:Q97, "3182BD", "E6550D") AS ?rgb)
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
}
Effect graph
#defaultView:Graph
PREFIX dreams: <http://dreams.wiki.opencura.com/entity/>
PREFIX dreamst: <http://dreams.wiki.opencura.com/prop/direct/>
SELECT
?subactivity ?subactivityLabel ?rgb
?impact ?impactLabel
{
BIND( IF(EXISTS { ?subactivity dreamst:P14+ dreams:Q106 }, "3182BD", "E6550D") AS ?rgb)
# ?impact dreamst:P14+ dreams:Q49 .
?subactivity dreamst:P9 ?impact .
SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
}