Dreams:effect: Difference between revisions

From DREAMS
Jump to navigation Jump to search
 
(14 intermediate revisions by the same user not shown)
Line 1: Line 1:
== Effect data ==
== Effektdata ==
{{SPARQL | query=
{{SPARQL | query=
PREFIX target: <https://dreams.wikibase.cloud/entity/Q179>
PREFIX target: <https://dreams.wikibase.cloud/entity/Q179>
Line 5: Line 5:
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
PREFIX dreamsp: <https://dreams.wikibase.cloud/prop/>
PREFIX dreamsp: <https://dreams.wikibase.cloud/prop/>
PREFIX dreamspsv: <https://dreams.wikibase.cloud/prop/statement/value/>  
PREFIX dreamspsv: <https://dreams.wikibase.cloud/prop/statement/værdi/>  


SELECT DISTINCT (?description AS ?beskrivelse) ?value ?valueLabel ?valueUrl
SELECT DISTINCT (?description AS ?beskrivelse) ?værdi ?værdiLabel ?værdiUrl
WHERE {
WHERE {
   BIND(target: AS ?effect)
   BIND(target: AS ?effect)
Line 13: Line 13:
     BIND(1 AS ?order)
     BIND(1 AS ?order)
     BIND("Effekt" AS ?description)
     BIND("Effekt" AS ?description)
     BIND(target: AS ?value) .
     BIND(target: AS ?værdi) .
   }
   }
   UNION
   UNION
Line 19: Line 19:
     BIND(5 AS ?order)
     BIND(5 AS ?order)
     BIND("Overbegreb" AS ?description)
     BIND("Overbegreb" AS ?description)
     target: dreamst:P10 ?value .
     target: dreamst:P10 ?værdi .
     BIND(SUBSTR(STR(?value), 38) AS ?q)  
     BIND(SUBSTR(STR(?værdi), 38) AS ?q)  
     BIND(CONCAT("#effect/", ?q) AS ?valueUrl)
     BIND(CONCAT("#effect/", ?q) AS ?værdiUrl)
   }
   }
   UNION
   UNION
   {
   {
     BIND(6 AS ?order)
     BIND(6 AS ?order)
     BIND("Overbegreb" AS ?description)
     BIND("Underbegreb" AS ?description)
     target: ^dreamst:P10 ?value .
     target: ^dreamst:P10 ?værdi .
     BIND(SUBSTR(STR(?value), 38) AS ?q)  
     BIND(SUBSTR(STR(?værdi), 38) AS ?q)  
     BIND(CONCAT("#effect/", ?q) AS ?valueUrl)
     BIND(CONCAT("#effect/", ?q) AS ?værdiUrl)
   }
   }
   UNION
   UNION
Line 35: Line 35:
     BIND(6 AS ?order)
     BIND(6 AS ?order)
     BIND("Påvirker" AS ?description)
     BIND("Påvirker" AS ?description)
     target: dreamst:P9 ?value .
     target: dreamst:P9 ?værdi .
     BIND(CONCAT("#effect/", SUBSTR(STR(?value), 38)) AS ?valueUrl)
     BIND(CONCAT("#effect/", SUBSTR(STR(?værdi), 38)) AS ?værdiUrl)
   }
   }
   UNION
   UNION
Line 42: Line 42:
     BIND(2 AS ?order)
     BIND(2 AS ?order)
     BIND("Er påvirket af" AS ?description)
     BIND("Er påvirket af" AS ?description)
     target: ^dreamst:P9 ?value .
     target: ^dreamst:P9 ?værdi .
     BIND(CONCAT("#effect/", SUBSTR(STR(?value), 38)) AS ?valueUrl)
     BIND(CONCAT("#effect/", SUBSTR(STR(?værdi), 38)) AS ?værdiUrl)
   }
   }
   UNION
   UNION
Line 49: Line 49:
     BIND(10 AS ?order)
     BIND(10 AS ?order)
     BIND("SDG" AS ?description)
     BIND("SDG" AS ?description)
     target: dreamst:P42 ?value .
     target: dreamst:P10* / dreamst:P10* / dreamst:P42 ?værdi .
     BIND(CONCAT("#sdg/", SUBSTR(STR(?value), 38)) AS ?valueUrl)
     BIND(CONCAT("#sdg/", SUBSTR(STR(?værdi), 38)) AS ?værdiUrl)
   }
   }
   UNION
   UNION
Line 56: Line 56:
     BIND(11 AS ?order)
     BIND(11 AS ?order)
     BIND("arter.dk" AS ?description)
     BIND("arter.dk" AS ?description)
     target: dreamst:P45 ?value_ .
     target: dreamst:P45 ?værdi_ .
     BIND(CONCAT(?value_, " ↗") AS ?value)
     BIND(CONCAT(?værdi_, " ↗") AS ?værdi)
     BIND(CONCAT("https://arter.dk/taxa/taxon/details/", ?value_) AS ?valueUrl)
     BIND(CONCAT("https://arter.dk/taxa/taxon/details/", ?værdi_) AS ?værdiUrl)
   }
   }
   UNION
   UNION
Line 64: Line 64:
     BIND(20 AS ?order)
     BIND(20 AS ?order)
     BIND("Scholia" AS ?description)
     BIND("Scholia" AS ?description)
     target: dreamst:P3 ?value_ .
     target: dreamst:P3 ?værdi_ .
     BIND(CONCAT(?value_, " ↗") AS ?value)
     BIND(CONCAT(?værdi_, " ↗") AS ?værdi)
     BIND(CONCAT("https://scholia.toolforge.org/topic/", ?value_) AS ?valueUrl)
     BIND(CONCAT("https://scholia.toolforge.org/topic/", ?værdi_) AS ?værdiUrl)
   }
   }
    
    
Line 73: Line 73:
ORDER BY ?order}}
ORDER BY ?order}}


== Affects ==
== Mønstre ==
{{SPARQL | query=
{{SPARQL | query=


Line 83: Line 83:
PREFIX dreamspsv: <https://dreams.wikibase.cloud/prop/statement/value/>  
PREFIX dreamspsv: <https://dreams.wikibase.cloud/prop/statement/value/>  


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


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


   ?significance ?significanceLabel
   ?subjekt ?subjektLabel ?subjektUrl


   ?quote
   ?påvirkning ?påvirkningLabel ?påvirkningUrl
 
  ?recipient ?recipientLabel ?recipientUrl
 
  ?signifikans ?signifikansLabel


   ?project_phase ?project_phaseLabel
   ?afbødning ?afbødningLabel ?afbødningUrl
  (CONCAT("#projectphase/", SUBSTR(STR(?project_phase), 38)) AS ?project_phaseUrl) 


   ?project_type ?project_typeLabel
   ?quote
  (CONCAT("#projecttype/", SUBSTR(STR(?project_type), 38)) AS ?project_typeUrl) 


   ?report ?reportLabel
   ?projektfase ?projektfaseLabel
   (CONCAT("#report/", SUBSTR(STR(?report), 38)) AS ?reportUrl)   
   (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:P33 / dreamst:P10* target: .
           ( dreamst:P33 | dreamst:P34 | dreamst:P55 | dreamst:P56  ) / dreamst:P10* target: .
  OPTIONAL { ?pattern dreamst:P34 ?affected . }
 
   OPTIONAL { ?pattern dreamst:P18 ?quote . }
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 {
   OPTIONAL {
     ?pattern dreamst:P20 ?report .
     ?mønster dreamst:P34 ?påvirkning .  
 
     ?påvirkning rdfs:label ?påvirkning_label .
     OPTIONAL {
    FILTER (LANG(?påvirkning_label) = 'da')
      ?report dreamst:P40 ?miljøportal .
     BIND(CONCAT("#effect/", SUBSTR(STR(?påvirkning), 38)) AS ?påvirkningUrl)
      BIND("↗" AS ?link1)
      BIND(CONCAT("https://daieproddreamspdfsto.blob.core.windows.net/files/", STR(?miljøportal)) AS ?link1Url)
    }
     OPTIONAL {
      ?report dreamst:P40 ?miljøportal .
      ?pattern dreamst:P46 ?page .
      BIND(CONCAT(?page, "&nbsp;↗") AS ?link2)
      BIND(CONCAT("https://daieproddreamspdfsto.blob.core.windows.net/files/", ?miljøportal,
                  "#page=", ?page) AS ?link2Url)
    }
     
    # This doesn't not make sense
    BIND(COALESCE(?link2, ?link1) AS ?link)
    BIND(COALESCE(?link2Url, ?link1Url) AS ?linkUrl)
   }
   }
  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 { ?pattern dreamst:P21 ?significance } # / dreamst:P44 ?symbol . }
   OPTIONAL {
   # BIND(IF(BOUND(?symbol), ?symbol, "") AS ?significance)
    ?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 { ?pattern dreamst:P19 ?project_phase . }
   OPTIONAL {
   OPTIONAL { ?pattern dreamst:P16 ?project_type . }
    ?mønster dreamst:P56 ?afbødning .
   SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
    ?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 ?quote . }
  OPTIONAL { ?mønster dreamst:P19 ?projektfase . }
  OPTIONAL { ?mønster dreamst:P20 ?rapport . }


== Is affected by ==
  OPTIONAL {
{{SPARQL | query=
    ?mønster dreamst:P21 ?signifikans .
PREFIX target: <https://dreams.wikibase.cloud/entity/Q6>
    ?signifikans rdfs:label ?signifikans_text .
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
    FILTER (LANG(?signifikans_text) = 'da')
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
    OPTIONAL { ?signifikans dreamst:P44 ?symbol . }
PREFIX dreamsp: <https://dreams.wikibase.cloud/prop/>
    BIND(IF(BOUND(?symbol), ?symbol, "") AS ?signifikans_symbol)
PREFIX dreamspsv: <https://dreams.wikibase.cloud/prop/statement/value/>
    BIND(CONCAT(?signifikans_symbol, " ", ?signifikans_text) AS ?signifikansLabel)
 
   }
SELECT
  ?pattern ?patternLabel
  (CONCAT("#pattern/", SUBSTR(STR(?pattern), 38)) AS ?patternUrl) 
 
  ?effect ?effectLabel
  (CONCAT("#effect/", SUBSTR(STR(?effect), 38)) AS ?effectUrl) 
 
  ?significance ?significanceLabel
 
  ?quote
 
  ?project_phase ?project_phaseLabel
  (CONCAT("#projectphase/", SUBSTR(STR(?project_phase), 38)) AS ?project_phaseUrl)
 
  ?project_type ?project_typeLabel
  (CONCAT("#projecttype/", SUBSTR(STR(?project_type), 38)) AS ?project_typeUrl) 
 
  ?report ?reportLabel
  (CONCAT("#report/", SUBSTR(STR(?report), 38)) AS ?reportUrl)
 
   ?link ?linkUrl
WHERE {
  ?pattern dreamst:P2 dreams:Q263 ;
          dreamst:P34 / dreamst:P10* target:
  OPTIONAL { ?pattern dreamst:P33 ?effect . }
  OPTIONAL { ?pattern dreamst:P18 ?quote . }


   OPTIONAL {
   OPTIONAL {
     ?pattern dreamst:P20 ?report .
     ?mønster dreamst:P20 ?rapport .
 
     ?rapport dreamst:P40 ?miljøportal .
     OPTIONAL {
     OPTIONAL { ?mønster dreamst:P46 ?page }
      ?report dreamst:P40 ?miljøportal .
    BIND(IF(BOUND(?page), CONCAT(?page, " ↗"), " ↗") AS ?link)
      BIND("↗" AS ?link1)
    BIND(CONCAT("https://daieproddreamspdfsto.blob.core.windows.net/files/", STR(?miljøportal),  
      BIND(CONCAT("https://daieproddreamspdfsto.blob.core.windows.net/files/", STR(?miljøportal)) AS ?link1Url)
                IF(BOUND(?page), CONCAT("#page=", ?page), "")) AS ?linkUrl)
    }
     OPTIONAL {
      ?report dreamst:P40 ?miljøportal .
      ?pattern dreamst:P46 ?page .
      BIND(CONCAT(?page, " ↗") AS ?link2)
      BIND(CONCAT("https://daieproddreamspdfsto.blob.core.windows.net/files/", ?miljøportal,  
                  "#page=", ?page) AS ?link2Url)
    }
 
    # This doesn't not make sense
    BIND(COALESCE(?link2, ?link1) AS ?link)
    BIND(COALESCE(?link2Url, ?link1Url) AS ?linkUrl)
   }
   }


  OPTIONAL { ?pattern dreamst:P21 ?significance }  # / dreamst:P44 ?symbol . }
  # BIND(IF(BOUND(?symbol), ?symbol, "❓") AS ?significance)
  OPTIONAL { ?pattern dreamst:P19 ?project_phase . }
  OPTIONAL { ?pattern dreamst:P16 ?project_type . }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
}
}
}}
}}

Latest revision as of 00:06, 16 December 2022

Effektdata

PREFIX target: <https://dreams.wikibase.cloud/entity/Q179>
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/værdi/> 

SELECT DISTINCT (?description AS ?beskrivelse) ?værdi ?værdiLabel ?værdiUrl
WHERE {
  BIND(target: AS ?effect)
  {
    BIND(1 AS ?order)
    BIND("Effekt" AS ?description)
    BIND(target: AS ?værdi) .
  }
  UNION
  {
    BIND(5 AS ?order)
    BIND("Overbegreb" AS ?description)
    target: dreamst:P10 ?værdi .
    BIND(SUBSTR(STR(?værdi), 38) AS ?q) 
    BIND(CONCAT("#effect/", ?q) AS ?værdiUrl)
  }
  UNION
  {
    BIND(6 AS ?order)
    BIND("Underbegreb" AS ?description)
    target: ^dreamst:P10 ?værdi .
    BIND(SUBSTR(STR(?værdi), 38) AS ?q) 
    BIND(CONCAT("#effect/", ?q) AS ?værdiUrl)
  }
  UNION
  {
    BIND(6 AS ?order)
    BIND("Påvirker" AS ?description)
    target: dreamst:P9 ?værdi .
    BIND(CONCAT("#effect/", SUBSTR(STR(?værdi), 38)) AS ?værdiUrl)
  }
  UNION
  {
    BIND(2 AS ?order)
    BIND("Er påvirket af" AS ?description)
    target: ^dreamst:P9 ?værdi .
    BIND(CONCAT("#effect/", SUBSTR(STR(?værdi), 38)) AS ?værdiUrl)
  }
  UNION
  {
    BIND(10 AS ?order)
    BIND("SDG" AS ?description)
    target:  dreamst:P10* / dreamst:P10* / dreamst:P42 ?værdi .
    BIND(CONCAT("#sdg/", SUBSTR(STR(?værdi), 38)) AS ?værdiUrl)
  }
  UNION
  {
    BIND(11 AS ?order)
    BIND("arter.dk" AS ?description)
    target: dreamst:P45 ?værdi_ .
    BIND(CONCAT(?værdi_, " ↗") AS ?værdi)
    BIND(CONCAT("https://arter.dk/taxa/taxon/details/", ?værdi_) AS ?værdiUrl)
  }
  UNION
  {
    BIND(20 AS ?order)
    BIND("Scholia" AS ?description)
    target: dreamst:P3 ?værdi_ .
    BIND(CONCAT(?værdi_, " ↗") AS ?værdi)
    BIND(CONCAT("https://scholia.toolforge.org/topic/", ?værdi_) AS ?værdiUrl)
  }
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
}
ORDER BY ?order


Mønstre

PREFIX target: <https://dreams.wikibase.cloud/entity/Q309>
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

  ?quote 

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

  ?link ?linkUrl

WHERE {
  ?mønster dreamst:P2 dreams:Q263 ;
           ( dreamst:P33