Main Page: Difference between revisions

From DREAMS
Jump to navigation Jump to search
(→‎Object class quickstatements: Recipient class quickstatements)
 
(53 intermediate revisions by the same user not shown)
Line 1: Line 1:
== Dokuments ==  
== Items ==
=== Dokuments ===
* [[Item:Q5|Nye vindmøller og solceller ved Veddum Kær]]
* [[Item:Q5|Nye vindmøller og solceller ved Veddum Kær]]
* [[Item:Q1|Udvidelse af det Nationale Testcenter for Vindmøller i Østerild]]
* [[Item:Q1|Udvidelse af det Nationale Testcenter for Vindmøller i Østerild]]
* [[Item:Q19|Opgradering af rostadion på Bagsværd Sø]]
* [[Item:Q19|Opgradering af rostadion på Bagsværd Sø]]
* [[Item:Q134|Miljøkonsekvensrapport Baltic Pipe. Gasrørledning i Nordsøen]]
=== Projects ===
* [[Item:Q101|Hillerødmotorvejens Forlængelse]]
=== Effect patterns ===
* [[Item:Q196|direction boring at Viking Link]]
* [[Item:Q197|boremudder opsugning ved Viking Link]]
* [[Item:Q200|Viking link underboring under klitter]]
[https://dreams.wikibase.cloud/query/index.html#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%0A%20%20%23%3Fsubject%0A%20%20%3FsubjectLabel%0A%20%20%23%3Fobject%0A%20%20%3FobjectLabel%0A%20%20%23%3Fproject%0A%20%20%3FprojectLabel%0A%20%20%23%3Fphase%0A%20%20%3FphaseLabel%0A%20%20%3Freport%20%0A%20%20%3Fquote%20%0AWHERE%20%7B%0A%20%20%3Fpattern%20dreamst%3AP33%20%3Fsubject%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20dreamst%3AP34%20%3Fobject%20.%0A%20%20OPTIONAL%20%7B%20%3Fpattern%20dreamst%3AP16%20%3Fproject%20.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fpattern%20dreamst%3AP20%20%3Freport%20.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fpattern%20dreamst%3AP18%20%3Fquote%20.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fpattern%20dreamst%3AP19%20%3Fphase%20.%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22da%2Cen%22.%20%7D%0A%7D Query]


== Ontology ==  
== Ontology ==  
Line 15: Line 27:


== Queries ==
== Queries ==
* Endpoint: https://dreams.wiki.opencura.com/query/
* Endpoint: https://dreams.wikibase.cloud/query/
* [tinyurl.com/y7jzsap9 All items and properties]
* All items and properties: [https://dreams.wikibase.cloud/query/index.html#%23defaultView%3AGraph%0ASELECT%20%3Fitem1%20%3Fitem1Label%20%3Fitem2%20%3Fitem2Label%20%3FedgeLabel%20%20%7B%0A%20%20%3Fitem1%20%3Fproperty%20%3Fitem2%20.%0A%20%20%3Fproperty_item%20wikibase%3AdirectClaim%20%3Fproperty%20.%0A%20%20%3Fproperty_item%20rdfs%3Alabel%20%3FedgeLabel%20.%0A%20%20FILTER%28LANG%28%3FedgeLabel%29%20%3D%20%27da%27%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cda%2Cen%22.%20%7D%0A%7D] tinyurl.com/2pocudcq
* [tinyurl.com/yhvzw8p7 Geographical map]
* [tinyurl.com/yhvzw8p7 Geographical map]


=== graph example ===
== Subclass graph ==
<pre>
#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 "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%20%3Fconcept2%20%3Fconcept2Label%20%3Fconcept1%20%3Fconcept1Label%20%7B%0A%20%20%3Fconcept2%20dreamst%3AP10%20%3Fconcept1%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22da%2Cen%22.%20%7D%0A%7D Query]
 
=== Graph example ===
<pre>
<pre>
#defaultView:Map
#defaultView:Map
PREFIX dreams: <http://dreams.wiki.opencura.com/entity/>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <http://dreams.wiki.opencura.com/prop/direct/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>


SELECT ?report ?reportLabel ?location ?locationLabel ?geo {
SELECT ?report ?reportLabel ?location ?locationLabel ?geo {
Line 32: Line 58:
</pre>
</pre>


== Sustainable Development Goals ==
=== Sustainable Development Goals ===
 
<pre>
<pre>
PREFIX dreams: <http://dreams.wiki.opencura.com/entity/>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <http://dreams.wiki.opencura.com/prop/direct/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>


SELECT ?sdg ?sdgLabel {
SELECT ?sdg ?sdgLabel {
Line 42: Line 67:
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
}
</pre>
=== Impact graph from ontology ===
<pre>
#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". }
}
</pre>
=== Subactivities ontology ===
<pre>
#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". }
}
</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 ===
<pre>
#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". }
}
</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 ===
<pre>
#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". }
}
</pre>
[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 ===
<pre>
#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". }
}
</pre>
[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 ===
<pre>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
SELECT DISTINCT
  ?pattern
  ?quote
WHERE {
  ?pattern dreamst:P18 ?quote .
}
</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%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]
== Quickstatements generation ==
=== Subject text count ===
<pre>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
SELECT
  (COUNT(?pattern) AS ?count) ?text
WHERE {
    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P47 ?text .
    MINUS { ?pattern dreamst:P33 [] }
GROUP BY ?text
ORDER BY DESC(?count)
</pre>
=== Object text count ===
<pre>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
SELECT
  (COUNT(?pattern) AS ?count) ?text
WHERE {
    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P49 ?text .
    MINUS { ?pattern dreamst:P34 [] }
GROUP BY ?text
ORDER BY DESC(?count)
</pre>
=== Recipient text count ===
<pre>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
SELECT
  (COUNT(?pattern) AS ?count) ?text
WHERE {
    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P54 ?text .
    MINUS { ?pattern dreamst:P55 [] }
GROUP BY ?text
ORDER BY DESC(?count)
</pre>
=== Mitigation text count ===
<pre>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
SELECT
  (COUNT(?pattern) AS ?count) ?text
WHERE {
    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P53 ?text .
    MINUS { ?pattern dreamst:P56 [] }
GROUP BY ?text
ORDER BY DESC(?count)
</pre>
=== Subject class quickstatements ===
<pre>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
SELECT
  ?qs
  # (COUNT(?pattern) AS ?count) ?object_text
WHERE {
  { BIND("qid,P33" AS ?qs) }
  UNION
  {
    BIND(dreams:Q113 AS ?target)
    { ?target rdfs:label ?target_text . }
    UNION
    { ?target skos:altLabel ?target_text . }
    FILTER(LANG(?target_text) = 'da')
    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P47 ?target_text .
    MINUS { ?pattern dreamst:P33 [] }
    BIND(CONCAT(SUBSTR(STR(?pattern), 38), ',', SUBSTR(STR(?target) , 38)) AS ?qs)
  }
}
</pre>
=== Object class quickstatements ===
<pre>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
SELECT
  ?qs
  # (COUNT(?pattern) AS ?count) ?object_text
WHERE {
  { BIND("qid,P34" AS ?qs) }
  UNION
  {
    BIND(dreams:Q2450 AS ?target)
    { ?target rdfs:label ?target_text . }
    UNION
    { ?target skos:altLabel ?target_text . }
    FILTER(LANG(?target_text) = 'da')
    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P49 ?target_text .
    MINUS { ?pattern dreamst:P34 [] }
    BIND(CONCAT(SUBSTR(STR(?pattern), 38), ',', SUBSTR(STR(?target) , 38)) AS ?qs)
  }
}
</pre>
=== Recipient class quickstatements ===
<pre>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
SELECT
  ?qs
  # (COUNT(?pattern) AS ?count) ?object_text
WHERE {
  { BIND("qid,P55" AS ?qs) }
  UNION
  {
    BIND(dreams:Q951 AS ?target)
    { ?target rdfs:label ?target_text . }
    UNION
    { ?target skos:altLabel ?target_text . }
    FILTER(LANG(?target_text) = 'da')
    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P54 ?target_text .
    MINUS { ?pattern dreamst:P55 [] }
    BIND(CONCAT(SUBSTR(STR(?pattern), 38), ',', SUBSTR(STR(?target) , 38)) AS ?qs)
  }
}
</pre>
=== Mitigation class quickstatements ===
<pre>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
SELECT
  ?qs
  # (COUNT(?pattern) AS ?count) ?object_text
WHERE {
  { BIND("qid,P56" AS ?qs) }
  UNION
  {
    BIND(dreams:Q825 AS ?target)
    { ?target rdfs:label ?target_text . }
    UNION
    { ?target skos:altLabel ?target_text . }
    FILTER(LANG(?target_text) = 'da')
    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P53 ?target_text .
    MINUS { ?pattern dreamst:P56 [] }
    BIND(CONCAT(SUBSTR(STR(?pattern), 38), ',', SUBSTR(STR(?target) , 38)) AS ?qs)
  }
}
</pre>
== 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>
</pre>

Latest revision as of 20:39, 24 November 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 "da,en". }
}

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

Quickstatements generation

Subject text count

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

SELECT
  (COUNT(?pattern) AS ?count) ?text
WHERE {

    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P47 ?text .
    MINUS { ?pattern dreamst:P33 [] }
}   
GROUP BY ?text
ORDER BY DESC(?count) 

Object text count

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

SELECT
  (COUNT(?pattern) AS ?count) ?text
WHERE {

    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P49 ?text .
    MINUS { ?pattern dreamst:P34 [] }
}   
GROUP BY ?text
ORDER BY DESC(?count) 

Recipient text count

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

SELECT
  (COUNT(?pattern) AS ?count) ?text
WHERE {

    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P54 ?text .
    MINUS { ?pattern dreamst:P55 [] }
}   
GROUP BY ?text
ORDER BY DESC(?count) 

Mitigation text count

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

SELECT
  (COUNT(?pattern) AS ?count) ?text
WHERE {

    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P53 ?text .
    MINUS { ?pattern dreamst:P56 [] }
}   
GROUP BY ?text
ORDER BY DESC(?count) 

Subject class quickstatements

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

SELECT
  ?qs
  # (COUNT(?pattern) AS ?count) ?object_text
WHERE {
  { BIND("qid,P33" AS ?qs) }
  UNION
  {
    BIND(dreams:Q113 AS ?target) 
    { ?target rdfs:label ?target_text . }
    UNION
    { ?target skos:altLabel ?target_text . }
    FILTER(LANG(?target_text) = 'da')
    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P47 ?target_text .
    MINUS { ?pattern dreamst:P33 [] }
    BIND(CONCAT(SUBSTR(STR(?pattern), 38), ',', SUBSTR(STR(?target) , 38)) AS ?qs)
  } 
}

Object class quickstatements

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

SELECT
  ?qs
  # (COUNT(?pattern) AS ?count) ?object_text
WHERE {
  { BIND("qid,P34" AS ?qs) }
  UNION
  {
    BIND(dreams:Q2450 AS ?target) 
    { ?target rdfs:label ?target_text . }
    UNION
    { ?target skos:altLabel ?target_text . }
    FILTER(LANG(?target_text) = 'da')
    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P49 ?target_text .
    MINUS { ?pattern dreamst:P34 [] }
    BIND(CONCAT(SUBSTR(STR(?pattern), 38), ',', SUBSTR(STR(?target) , 38)) AS ?qs)
  } 
}

Recipient class quickstatements

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

SELECT
  ?qs
  # (COUNT(?pattern) AS ?count) ?object_text
WHERE {
  { BIND("qid,P55" AS ?qs) }
  UNION
  {
    BIND(dreams:Q951 AS ?target) 
    { ?target rdfs:label ?target_text . }
    UNION
    { ?target skos:altLabel ?target_text . }
    FILTER(LANG(?target_text) = 'da')
    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P54 ?target_text .
    MINUS { ?pattern dreamst:P55 [] }
    BIND(CONCAT(SUBSTR(STR(?pattern), 38), ',', SUBSTR(STR(?target) , 38)) AS ?qs)
  } 
}

Mitigation class quickstatements

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

SELECT
  ?qs
  # (COUNT(?pattern) AS ?count) ?object_text
WHERE {
  { BIND("qid,P56" AS ?qs) }
  UNION
  {
    BIND(dreams:Q825 AS ?target) 
    { ?target rdfs:label ?target_text . }
    UNION
    { ?target skos:altLabel ?target_text . }
    FILTER(LANG(?target_text) = 'da')
    ?pattern dreamst:P2 dreams:Q263 .
    ?pattern dreamst:P53 ?target_text .
    MINUS { ?pattern dreamst:P56 [] }
    BIND(CONCAT(SUBSTR(STR(?pattern), 38), ',', SUBSTR(STR(?target) , 38)) AS ?qs)
  } 
}

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