DREAMS

Dreams:projecttype: Difference between revisions

Page Discussion

Dreams:projecttype (view source)

Revision as of 13:24, 9 December 2022

85 bytes added ,  1 year ago
→‎Mønstre
 
(3 intermediate revisions by the same user not shown)
Line 57: Line 57:
ORDER BY ?order}}
ORDER BY ?order}}


== Mønster ==
== Mønstre ==
{{SPARQL | query=  
{{SPARQL | query=  
PREFIX target: <https://dreams.wikibase.cloud/entity/Q321>
PREFIX target: <https://dreams.wikibase.cloud/entity/Q321>
Line 67: Line 67:
SELECT
SELECT
   DISTINCT
   DISTINCT
   ?pattern ("🔍" AS ?patternLabel)
   ?mønster ("🔍" AS ?mønsterLabel)
   (CONCAT("#pattern/", SUBSTR(STR(?pattern), 38)) AS ?patternUrl)   
   (CONCAT("#pattern/", SUBSTR(STR(?mønster), 38)) AS ?mønsterUrl)   


   ?report ?reportLabel
   ?rapport ?rapportLabel
   (CONCAT("#report/", SUBSTR(STR(?report), 38)) AS ?reportUrl)   
   (CONCAT("#report/", SUBSTR(STR(?rapport), 38)) AS ?rapportUrl)   


   ?subject ?subjectLabel ?subjectUrl
   ?subjekt ?subjektLabel ?subjektUrl


   ?impact ?impactLabel ?impactUrl
   ?påvirkning ?påvirkningLabel ?påvirkningUrl


   ?recipient ?recipientLabel ?recipientUrl
   ?recipient ?recipientLabel ?recipientUrl


   ?significance ?significanceLabel
   ?signifikans ?signifikansLabel


   ?mitigation ?mitigationLabel ?mitigationUrl
   ?afbødning ?afbødningLabel ?afbødningUrl


   ?quote
   ?citat


   ?project_phase ?project_phaseLabel
   ?projektfase ?projektfaseLabel
   (CONCAT("#projectphase/", SUBSTR(STR(?project_phase), 38)) AS ?project_phaseUrl)   
   (CONCAT("#projectphase/", SUBSTR(STR(?projektfase), 38)) AS ?projektfaseUrl)   


   ?link ?linkUrl
   ?link ?linkUrl


WHERE {
WHERE {
   ?pattern dreamst:P2 dreams:Q263 ;
   ?mønster dreamst:P2 dreams:Q263 ;
           dreamst:P20? / dreamst:P16 / dreamst:P10* target: .
           dreamst:P20? / dreamst:P16 / dreamst:P10* target: .


   OPTIONAL {
   OPTIONAL {
     ?pattern dreamst:P33 ?subject .
     ?mønster dreamst:P33 ?subjekt .
     ?subject rdfs:label ?subject_label .
     ?subjekt rdfs:label ?subjekt_label .
     FILTER(LANG(?subject_label) = 'da')
     FILTER(LANG(?subjekt_label) = 'da')
     BIND(CONCAT("#effect/", SUBSTR(STR(?subject), 38)) AS ?subjectUrl)
     BIND(CONCAT("#effect/", SUBSTR(STR(?subjekt), 38)) AS ?subjektUrl)
   }
   }
   OPTIONAL { ?pattern dreamst:P47 ?subject_text }
   OPTIONAL { ?mønster dreamst:P47 ?subjekt_text }
   BIND(COALESCE(?subject, ?subject_text, "") AS ?subject)
   BIND(COALESCE(?subjekt, ?subjekt_text, "") AS ?subjekt)
   BIND(CONCAT(?subject_text, " (", COALESCE(?subject_label, ""), ")") AS ?subjectLabel)
   BIND(CONCAT(?subjekt_text, " (", COALESCE(?subjekt_label, ""), ")") AS ?subjektLabel)
      
      
   OPTIONAL {
   OPTIONAL {
     ?pattern dreamst:P34 ?impact .  
     ?mønster dreamst:P34 ?påvirkning .  
     ?impact rdfs:label ?impact_label .
     ?påvirkning rdfs:label ?påvirkning_label .
     FILTER (LANG(?impact_label) = 'da')
     FILTER (LANG(?påvirkning_label) = 'da')
     BIND(CONCAT("#effect/", SUBSTR(STR(?impact), 38)) AS ?impactUrl)
     BIND(CONCAT("#effect/", SUBSTR(STR(?påvirkning), 38)) AS ?påvirkningUrl)
   }
   }
   OPTIONAL { ?pattern dreamst:P49 ?impact_text }
   OPTIONAL { ?mønster dreamst:P49 ?påvirkning_text }
   BIND(COALESCE(?impact, ?impact_text) AS ?impact)
   BIND(COALESCE(?påvirkning, ?påvirkning_text) AS ?påvirkning)
   BIND(CONCAT(?impact_text, " (", COALESCE(?impact_label, ""), ")") AS ?impactLabel)
   BIND(CONCAT(?påvirkning_text, " (", COALESCE(?påvirkning_label, ""), ")") AS ?påvirkningLabel)


   OPTIONAL {
   OPTIONAL {
     ?pattern dreamst:P55 ?recipient .
     ?mønster dreamst:P55 ?recipient .
     ?recipient rdfs:label ?recipient_label .
     ?recipient rdfs:label ?recipient_label .
     FILTER (LANG(?recipient_label) = 'da')
     FILTER (LANG(?recipient_label) = 'da')
     BIND(CONCAT("#effect/", SUBSTR(STR(?recipient), 38)) AS ?recipientUrl)
     BIND(CONCAT("#effect/", SUBSTR(STR(?recipient), 38)) AS ?recipientUrl)
   }
   }
   OPTIONAL { ?pattern dreamst:P54 ?recipient_text }
   OPTIONAL { ?mønster dreamst:P54 ?recipient_text }
   BIND(COALESCE(?recipient, ?recipient_text) AS ?recipient)
   BIND(COALESCE(?recipient, ?recipient_text) AS ?recipient)
   BIND(CONCAT(?recipient_text, " (", COALESCE(?recipient_label, ""), ")") AS ?recipientLabel)
   BIND(CONCAT(?recipient_text, " (", COALESCE(?recipient_label, ""), ")") AS ?recipientLabel)


   OPTIONAL {
   OPTIONAL {
     ?pattern dreamst:P56 ?mitigation .
     ?mønster dreamst:P56 ?afbødning .
     ?mitigation rdfs:label ?mitigation_label .
     ?afbødning rdfs:label ?afbødning_label .
     FILTER (LANG(?mitigation_label) = 'da')
     FILTER (LANG(?afbødning_label) = 'da')
     BIND(CONCAT("#effect/", SUBSTR(STR(?mitigation), 38)) AS ?mitigationUrl)
     BIND(CONCAT("#effect/", SUBSTR(STR(?afbødning), 38)) AS ?afbødningUrl)
   }
   }
   OPTIONAL { ?pattern dreamst:P53 ?mitigation_text }
   OPTIONAL { ?mønster dreamst:P53 ?afbødning_text }
   BIND(COALESCE(?mitigation, ?mitigation_text) AS ?mitigation)
   BIND(COALESCE(?afbødning, ?afbødning_text) AS ?afbødning)
   BIND(CONCAT(?mitigation_text, " (", COALESCE(?mitigation_label, ""), ")") AS ?mitigationLabel)
   BIND(CONCAT(?afbødning_text, " (", COALESCE(?afbødning_label, ""), ")") AS ?afbødningLabel)


   OPTIONAL { ?pattern dreamst:P18 ?quote . }
   OPTIONAL { ?mønster dreamst:P18 ?citat . }
   OPTIONAL { ?pattern dreamst:P19 ?project_phase . }
   OPTIONAL { ?mønster dreamst:P19 ?projektfase . }
   OPTIONAL { ?pattern dreamst:P20 ?report . }
   OPTIONAL { ?mønster dreamst:P20 ?rapport . }


   OPTIONAL {
   OPTIONAL {
     ?pattern dreamst:P21 ?significance .
     ?mønster dreamst:P21 ?signifikans .
     ?significance rdfs:label ?significance_text .
     ?signifikans rdfs:label ?signifikans_text .
     FILTER (LANG(?significance_text) = 'da')
     FILTER (LANG(?signifikans_text) = 'da')
     OPTIONAL { ?significance dreamst:P44 ?symbol . }
     OPTIONAL { ?signifikans dreamst:P44 ?symbol . }
     BIND(IF(BOUND(?symbol), ?symbol, "❓") AS ?significance_symbol)
     BIND(IF(BOUND(?symbol), ?symbol, "❓") AS ?signifikans_symbol)
     BIND(CONCAT(?significance_symbol, " ", ?significance_text) AS ?significanceLabel)
     BIND(CONCAT(?signifikans_symbol, " ", ?signifikans_text) AS ?signifikansLabel)
   }
   }


   OPTIONAL {
   OPTIONAL {
     ?pattern dreamst:P20 ?report .
     ?mønster dreamst:P20 ?rapport .
     ?report dreamst:P40 ?miljøportal .
     ?rapport dreamst:P40 ?miljøportal .
     OPTIONAL { ?pattern dreamst:P46 ?page }
     OPTIONAL { ?mønster dreamst:P46 ?page }
     BIND(IF(BOUND(?page), CONCAT(?page, " ↗"), " ↗") AS ?link)
     BIND(IF(BOUND(?page), CONCAT(?page, " ↗"), " ↗") AS ?link)
     BIND(CONCAT("https://daieproddreamspdfsto.blob.core.windows.net/files/", STR(?miljøportal),  
     BIND(CONCAT("https://daieproddreamspdfsto.blob.core.windows.net/files/", STR(?miljøportal),  
Retrieved from "https://dreams.wikibase.cloud/wiki/Special:MobileDiff/16440...16448"