Main Page: Difference between revisions

From DREAMS
Jump to navigation Jump to search
Line 93: Line 93:
}
}
</pre>
</pre>
[https://dreams.wikibase.cloud/query/embed.html#%23defaultView%3AGraph%0APREFIX%20dreams%3A%20%3Chttps%3A%2F%2Fdreams.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20dreamst%3A%20%3Chttps%3A%2F%2Fdreams.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0A%0ASELECT%20%3Fconcept1%20%3Fconcept1Label%20%3Frgb%20%3Fconcept2%20%3Fconcept2Label%20%20%7B%0A%20%20%20%20%3Fconcept1%20dreamst%3AP14%20%3Fconcept2%20.%0A%20%20%20%20%7B%20BIND%20%28dreams%3AQ106%20AS%20%3Fconcept2%29%20%7D%0A%20%20%20%20UNION%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%3Fconcept1%20dreamst%3AP14%2B%20dreams%3AQ106%20.%0A%20%20%20%20%7D%0A%20%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%3Fconcept1%20dreamst%3AP19%20%3Fproject_phase1%20.%20%0A%20%20%20%20%20%20BIND%28%20IF%28%3Fproject_phase1%20%3D%20dreams%3AQ97%2C%20%223182BD%22%2C%20%22E6550D%22%29%20AS%20%3Frgb%29%0A%20%20%20%20%7D%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22da%2Cen%22.%20%7D%0A%7D Query]


=== Effect graph ===
=== Effect graph ===

Revision as of 14:57, 14 June 2022

Items

Dokuments

Projects

Superpatterns

Query

Ontology

Items

Properties

Queries

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". }
}

Query

Effect graph

#defaultView:Graph
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/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". }
}