Main Page: Difference between revisions

From DREAMS
Jump to navigation Jump to search
(7 intermediate revisions by the same user not shown)
Line 126: Line 126:
}  
}  
</pre>
</pre>
Effect with "has effect" and effect patterns:
<pre>
#defaultView:Graph
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
SELECT
  ?effect1 ?effect1Label
  ?effect2 ?effect2Label
  # ?effect3 ?effect3Label
WHERE {
  {
    [] dreamst:P33 ?effect1 ;
      dreamst:P34 ?effect2 .
  }
  UNION
  {
    ?effect1 dreamst:P10* / dreamst:P9 ?effect2 .
  }
 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
}
</pre>
[https://dreams.wikibase.cloud/query/#%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%0A%20%20%3Feffect1%20%3Feffect1Label%0A%20%20%3Feffect2%20%3Feffect2Label%0A%20%20%23%20%3Feffect3%20%3Feffect3Label%0AWHERE%20%7B%0A%0A%20%20%7B%0A%20%20%20%20%5B%5D%20dreamst%3AP33%20%3Feffect1%20%3B%0A%20%20%20%20%20%20%20dreamst%3AP34%20%3Feffect2%20.%0A%20%20%7D%0A%20%20UNION%20%0A%20%20%7B%0A%20%20%20%20%3Feffect1%20dreamst%3AP10%2a%20%2F%20dreamst%3AP9%20%3Feffect2%20.%0A%20%20%7D%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22da%2Cen%22.%20%7D%0A%7D%20 Query]


=== Project types ===
=== Project types ===
Line 148: Line 174:
[https://dreams.wikibase.cloud/query/index.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%0A%20%20%3Fproject1%20%3Fproject1Label%0A%20%20%3Fproject2%20%3Fproject2Label%0AWHERE%20%7B%0A%20%20%7B%20%3Fproject1%20dreamst%3AP14%2B%20dreams%3AQ91%20.%0A%20%20%20%20%3Fproject2%20dreamst%3AP14%2B%20dreams%3AQ91%20%7D%0A%20%20UNION%0A%20%20%7B%20BIND%28dreams%3AQ91%20AS%20%3Fproject1%29%20%7D%0A%20%20%3Fproject2%20dreamst%3AP14%20%3Fproject1%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22da%2Cen%22.%20%7D%0A%7D%0A Query]
[https://dreams.wikibase.cloud/query/index.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%0A%20%20%3Fproject1%20%3Fproject1Label%0A%20%20%3Fproject2%20%3Fproject2Label%0AWHERE%20%7B%0A%20%20%7B%20%3Fproject1%20dreamst%3AP14%2B%20dreams%3AQ91%20.%0A%20%20%20%20%3Fproject2%20dreamst%3AP14%2B%20dreams%3AQ91%20%7D%0A%20%20UNION%0A%20%20%7B%20BIND%28dreams%3AQ91%20AS%20%3Fproject1%29%20%7D%0A%20%20%3Fproject2%20dreamst%3AP14%20%3Fproject1%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22da%2Cen%22.%20%7D%0A%7D%0A Query]


== Effect patterns subject-object graph ==
=== Effect patterns subject-object graph ===
<pre>
<pre>
#defaultView:Graph
#defaultView:Graph
Line 167: Line 193:
[https://dreams.wikibase.cloud/query/index.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%0A%20%20%3Fsubject%20%3FsubjectLabel%0A%20%20%3Fobject%20%3FobjectLabel%0AWHERE%20%7B%0A%20%20%5B%5D%20dreamst%3AP2%20dreams%3AQ263%20%3B%0A%20%20%20%20%20dreamst%3AP33%20%3Fsubject%20%3B%0A%20%20%20%20%20dreamst%3AP34%20%3Fobject%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22da%2Cen%22.%20%7D%0A%7D%0A Query]
[https://dreams.wikibase.cloud/query/index.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%0A%20%20%3Fsubject%20%3FsubjectLabel%0A%20%20%3Fobject%20%3FobjectLabel%0AWHERE%20%7B%0A%20%20%5B%5D%20dreamst%3AP2%20dreams%3AQ263%20%3B%0A%20%20%20%20%20dreamst%3AP33%20%3Fsubject%20%3B%0A%20%20%20%20%20dreamst%3AP34%20%3Fobject%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22da%2Cen%22.%20%7D%0A%7D%0A Query]


== Quotes ==
=== Quotes ===
<pre>
<pre>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
Line 180: Line 206:
</pre>
</pre>


[https://dreams.wikibase.cloud/query/#PREFIX%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%20DISTINCT%0A%20%20%3Fpattern%0A%20%20%3Fquote%0AWHERE%20%7B%0A%20%20%3Fpattern%20dreamst%3AP18%20%3Fquote%20.%0A%7D Quote]
[https://dreams.wikibase.cloud/query/#PREFIX%20dreams%3A%20%3Chttps%3A%2F%2Fdreams.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20dreamst%3A%20%3Chttps%3A%2F%2Fdreams.wikibase.cloud%2Fprop%2Fdirecthttps://dreams.wikibase.cloud/w/index.php?title=Main_Page&action=edit&section=17%2F%3E%0A%0ASELECT%20DISTINCT%0A%20%20%3Fpattern%0A%20%20%3Fquote%0AWHERE%20%7B%0A%20%20%3Fpattern%20dreamst%3AP18%20%3Fquote%20.%0A%7D Quote]
 
=== Number of pages through time ===
<pre>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
 
SELECT
  ?year
  ?pages
  ?report ?reportLabel
WHERE {
  ?report dreamst:P2 dreams:Q4 ;
          dreamst:P27 ?pages ;
          dreamst:P6 ?publication_datetime .
  BIND(STR(YEAR(?publication_datetime)) AS ?year)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?year
</pre>
 
[https://dreams.wikibase.cloud/query/#PREFIX%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%0A%20%20%3Fyear%0A%20%20%3Fpages%0A%20%20%3Freport%20%3FreportLabel%0AWHERE%20%7B%0A%20%20%3Freport%20dreamst%3AP2%20dreams%3AQ4%20%3B%0A%20%20%20%20%20%20%20%20%20%20dreamst%3AP27%20%3Fpages%20%3B%0A%20%20%20%20%20%20%20%20%20%20dreamst%3AP6%20%3Fpublication_datetime%20.%0A%20%20BIND%28STR%28YEAR%28%3Fpublication_datetime%29%29%20AS%20%3Fyear%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AORDER%20BY%20%3Fyear Quotes]
 
== Cradle queries ==
=== Reports ===
<pre>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
 
SELECT
  (GROUP_CONCAT(?q; separator=",") AS ?reports)
WHERE {
  ?report dreamst:P2 dreams:Q4 .
  BIND(SUBSTR(STR(?report), 38) AS ?q)
  BIND(1 AS ?dummy)
}
GROUP BY ?dummy
</pre>
 
=== Significance types ===
<pre>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
 
SELECT
  (GROUP_CONCAT(?q; separator=",") AS ?item)
WHERE {
  {
    SELECT
      ?item ?itemLabel
    WHERE {
      ?item dreamst:P2 dreams:Q177 .
      SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
    }
    ORDER BY ?itemLabel
  }
  BIND(SUBSTR(STR(?item), 38) AS ?q)
  BIND(1 AS ?dummy)
}
GROUP BY ?dummy
</pre>

Revision as of 11:46, 15 September 2022

Items

Dokuments

Projects

Effect patterns

Query

Ontology

Items

Properties

Queries

Subclass graph

#defaultView:Graph
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT ?concept2 ?concept2Label ?concept1 ?concept1Label {
  ?concept2 dreamst:P10 ?concept1 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en,da". }
}

Query

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

Effect with "has effect" and effect patterns:

#defaultView:Graph
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT
  ?effect1 ?effect1Label
  ?effect2 ?effect2Label
  # ?effect3 ?effect3Label
WHERE {

  {
    [] dreamst:P33 ?effect1 ;
       dreamst:P34 ?effect2 .
  }
  UNION 
  {
    ?effect1 dreamst:P10* / dreamst:P9 ?effect2 .
  }
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
} 

Query

Project types

#defaultView:Graph
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT
  ?project1 ?project1Label
  ?project2 ?project2Label
WHERE {
  { ?project1 dreamst:P14+ dreams:Q91 .
    ?project2 dreamst:P14+ dreams:Q91 }
  UNION
  { BIND(dreams:Q91 AS ?project1) }
  ?project2 dreamst:P14 ?project1 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
}

Query

Effect patterns subject-object graph

#defaultView:Graph
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT
  ?subject ?subjectLabel
  ?object ?objectLabel
WHERE {
  [] dreamst:P2 dreams:Q263 ;
     dreamst:P33 ?subject ;
     dreamst:P34 ?object .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
}

Query

Quotes

PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT DISTINCT
  ?pattern
  ?quote
WHERE {
  ?pattern dreamst:P18 ?quote .
}

Quote

Number of pages through time

PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT 
  ?year
  ?pages
  ?report ?reportLabel
WHERE {
  ?report dreamst:P2 dreams:Q4 ;
          dreamst:P27 ?pages ;
          dreamst:P6 ?publication_datetime .
  BIND(STR(YEAR(?publication_datetime)) AS ?year)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?year

Quotes

Cradle queries

Reports

PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT
  (GROUP_CONCAT(?q; separator=",") AS ?reports)
WHERE {
  ?report dreamst:P2 dreams:Q4 .
  BIND(SUBSTR(STR(?report), 38) AS ?q)
  BIND(1 AS ?dummy)
}
GROUP BY ?dummy

Significance types

PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT
  (GROUP_CONCAT(?q; separator=",") AS ?item)
WHERE {
  {
    SELECT 
      ?item ?itemLabel
    WHERE {
      ?item dreamst:P2 dreams:Q177 .
      SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
    }
    ORDER BY ?itemLabel
  }
  BIND(SUBSTR(STR(?item), 38) AS ?q)
  BIND(1 AS ?dummy)
}
GROUP BY ?dummy