Main Page
Jump to navigation
Jump to search
Items
Dokuments
- Nye vindmøller og solceller ved Veddum Kær
- Udvidelse af det Nationale Testcenter for Vindmøller i Østerild
- Opgradering af rostadion på Bagsværd Sø
- Miljøkonsekvensrapport Baltic Pipe. Gasrørledning i Nordsøen
Projects
Effect patterns
- direction boring at Viking Link
- boremudder opsugning ved Viking Link
- Viking link underboring under klitter
Ontology
Items
Properties
Queries
- Endpoint: https://dreams.wikibase.cloud/query/
- All items and properties: [1] tinyurl.com/2pocudcq
- [tinyurl.com/yhvzw8p7 Geographical map]
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". } }
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: <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". } }
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". } }
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". } }
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 . }
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
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