Dreams:projecttype: Difference between revisions

From DREAMS
Jump to navigation Jump to search
(→‎Mønster: staveret)
 
(2 intermediate revisions by the same user not shown)
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),  

Latest revision as of 13:24, 9 December 2022

Projekttype-data

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

SELECT DISTINCT 
  ?beskrivelse
  ?værdi ?værdiLabel ?værdiUrl
WHERE {
  BIND(target: AS ?effect)
  {
    BIND(1 AS ?order)
    BIND("Projekttype" AS ?beskrivelse)
    BIND(target: AS ?værdi) .
  }
  UNION
  {
    BIND(5 AS ?order)
    BIND("Overbegreb" AS ?beskrivelse)
    target: dreamst:P10 ?værdi .
    BIND(SUBSTR(STR(?værdi), 38) AS ?q) 
    BIND(CONCAT("#projecttype/", ?q) AS ?værdiUrl)
  }
  UNION
  {
    BIND(6 AS ?order)
    BIND("Underbegreb" AS ?beskrivelse)
    target: ^dreamst:P10 ?værdi .
    BIND(SUBSTR(STR(?værdi), 38) AS ?q) 
    BIND(CONCAT("#projecttype/", ?q) AS ?værdiUrl)
  }
  UNION
  {
    BIND(10 AS ?order)
    BIND("Ekstern beskrivelse" AS ?beskrivelse)
    target: dreamst:P29 ?værdi .
    BIND(?værdi AS ?værdiUrl)
  }
  UNION
  {
    BIND(100 AS ?order)
    BIND("Rapporter" AS ?beskrivelse)
    BIND("🔍" AS ?værdi)
    BIND(CONCAT("#projecttype/", SUBSTR(STR(target:), 38), "/report") AS ?værdiUrl)
  }
  UNION
  {
    BIND(101 AS ?order)
    BIND("Effekter" AS ?beskrivelse)
    BIND("🔍" AS ?værdi)
    BIND(CONCAT("#projecttype/", SUBSTR(STR(target:), 38), "/effect") AS ?værdiUrl)
  }

  SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
}
ORDER BY ?order


Mønstre

PREFIX target: <https://dreams.wikibase.cloud/entity/Q321>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
PREFIX dreamsp: <https://dreams.wikibase.cloud/prop/>
PREFIX dreamspsv: <https://dreams.wikibase.cloud/prop/statement/value/> 

SELECT
  DISTINCT
  ?mønster ("🔍" AS ?mønsterLabel)
  (CONCAT("#pattern/", SUBSTR(STR(?mønster), 38)) AS ?mønsterUrl)  

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

  ?subjekt ?subjektLabel ?subjektUrl

  ?påvirkning ?påvirkningLabel ?påvirkningUrl

  ?recipient ?recipientLabel ?recipientUrl

  ?signifikans ?signifikansLabel

  ?afbødning ?afbødningLabel ?afbødningUrl

  ?citat 

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

  ?link ?linkUrl

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

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

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

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

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

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

  OPTIONAL {
    ?mønster dreamst:P20 ?rapport .
    ?rapport dreamst:P40 ?miljøportal .
    OPTIONAL { ?mønster dreamst:P46 ?page }
    BIND(IF(BOUND(?page), CONCAT(?page, " ↗"), " ↗") AS ?link)
    BIND(CONCAT("https://daieproddreamspdfsto.blob.core.windows.net/files/", STR(?miljøportal), 
                IF(BOUND(?page), CONCAT("#page=", ?page), "")) AS ?linkUrl)
  }


  SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
}