DREAMS

Dreams:projecttype: Difference between revisions

Page Discussion

Dreams:projecttype (view source)

Revision as of 13:24, 9 December 2022

1,996 bytes added ,  1 year ago
→‎Mønstre
(data panel)
 
(34 intermediate revisions by the same user not shown)
Line 1: Line 1:
== Projekttype-data ==
{{SPARQL | query=
{{SPARQL | query=
PREFIX target: <https://dreams.wikibase.cloud/entity/Q264>
PREFIX target: <https://dreams.wikibase.cloud/entity/Q264>
Line 4: Line 5:
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>


SELECT DISTINCT ?description ?value ?valueLabel ?valueUrl
SELECT DISTINCT  
  ?beskrivelse
  ?værdi ?værdiLabel ?værdiUrl
WHERE {
WHERE {
   BIND(target: AS ?effect)
   BIND(target: AS ?effect)
   {
   {
     BIND(1 AS ?order)
     BIND(1 AS ?order)
     BIND("Project type" AS ?description)
     BIND("Projekttype" AS ?beskrivelse)
     BIND(target: AS ?value) .
     BIND(target: AS ?værdi) .
   }
   }
   UNION
   UNION
   {
   {
     BIND(5 AS ?order)
     BIND(5 AS ?order)
     BIND("Supertype" AS ?description)
     BIND("Overbegreb" AS ?beskrivelse)
     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("#project-type/", ?q) AS ?valueUrl)
     BIND(CONCAT("#projecttype/", ?q) AS ?værdiUrl)
   }
   }
   UNION
   UNION
   {
   {
     BIND(6 AS ?order)
     BIND(6 AS ?order)
     BIND("Subtype" AS ?description)
     BIND("Underbegreb" AS ?beskrivelse)
     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("#project-type/", ?q) AS ?valueUrl)
     BIND(CONCAT("#projecttype/", ?q) AS ?værdiUrl)
   }
   }
   UNION
   UNION
   {
   {
     BIND(10 AS ?order)
     BIND(10 AS ?order)
     BIND("External description" AS ?description)
     BIND("Ekstern beskrivelse" AS ?beskrivelse)
     target: dreamst:P29 ?value .
     target: dreamst:P29 ?værdi .
     BIND(?value AS ?valueUrl)
     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". }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
}
}
ORDER BY ?order
ORDER BY ?order}}
}}


== Effects ==
== Mønstre ==
{{SPARQL | query=
{{SPARQL | query=  
PREFIX target: <https://dreams.wikibase.cloud/entity/Q264>
PREFIX target: <https://dreams.wikibase.cloud/entity/Q321>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
Line 50: Line 66:


SELECT
SELECT
   ?number_of_patterns
  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


   ?effect ?effectLabel
WHERE {
  (CONCAT("#effect/", SUBSTR(STR(?effect), 38)) AS ?effectUrl) 
   ?mønster dreamst:P2 dreams:Q263 ;
          dreamst:P20? / dreamst:P16 / dreamst:P10* target: .


   ?example_pattern ?example_patternLabel
   OPTIONAL {
  (CONCAT("#pattern/", SUBSTR(STR(?example_pattern), 38)) AS ?example_patternUrl) 
    ?mønster dreamst:P33 ?subjekt .
    ?subjekt rdfs:label ?subjekt_label .
WITH {
    FILTER(LANG(?subjekt_label) = 'da')
  SELECT
    BIND(CONCAT("#effect/", SUBSTR(STR(?subjekt), 38)) AS ?subjektUrl)
    (COUNT(?pattern) AS ?number_of_patterns)
    (SAMPLE(?pattern) AS ?example_pattern)
    ?effect
  WHERE {
    ?pattern dreamst:P2 dreams:Q263 ;
            dreamst:P16 / dreamst:P10* target: ;
            dreamst:P33 | dreamst:P34 ?effect .
   }
   }
   GROUP BY ?effect
   OPTIONAL { ?mønster dreamst:P47 ?subjekt_text }
} AS %result
  BIND(COALESCE(?subjekt, ?subjekt_text, "") AS ?subjekt)
WHERE {
  BIND(CONCAT(?subjekt_text, " (", COALESCE(?subjekt_label, ""), ")") AS ?subjektLabel)
  INCLUDE %result
   
   SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
   OPTIONAL {
}
    ?mønster dreamst:P34 ?påvirkning .
ORDER BY DESC(?number_of_patterns)
    ?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)


== Reports ==
  OPTIONAL {
{{SPARQL | query=
    ?mønster dreamst:P55 ?recipient .
PREFIX target: <https://dreams.wikibase.cloud/entity/Q170>
    ?recipient rdfs:label ?recipient_label .
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
    FILTER (LANG(?recipient_label) = 'da')
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
    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)


SELECT
  OPTIONAL {
  ?project_type ?project_typeLabel
    ?mønster dreamst:P56 ?afbødning .
  (CONCAT("#project-type/", SUBSTR(STR(?project_type), 38)) AS ?project_typeUrl)
    ?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)


   ?report ?reportLabel
   OPTIONAL { ?mønster dreamst:P18 ?citat . }
   (CONCAT("#report/", SUBSTR(STR(?report), 38)) AS ?reportUrl)
   OPTIONAL { ?mønster dreamst:P19 ?projektfase . }
  OPTIONAL { ?mønster dreamst:P20 ?rapport . }


WHERE {
  OPTIONAL {
  ?project_type dreamst:P10* target: .
    ?mønster dreamst:P21 ?signifikans .
  ?report dreamst:P2 / dreamst:P10* dreams:Q8 ; 
    ?signifikans rdfs:label ?signifikans_text .
          dreamst:P16 ?project_type .
    FILTER (LANG(?signifikans_text) = 'da')
  SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en,it". }
    OPTIONAL { ?signifikans dreamst:P44 ?symbol . }
}
    BIND(IF(BOUND(?symbol), ?symbol, "❓") AS ?signifikans_symbol)
}}
    BIND(CONCAT(?signifikans_symbol, " ", ?signifikans_text) AS ?signifikansLabel)
  }


== Patterns ==
  OPTIONAL {
{{SPARQL | query=
    ?mønster dreamst:P20 ?rapport .
PREFIX target: <https://dreams.wikibase.cloud/entity/Q170>
    ?rapport dreamst:P40 ?miljøportal .
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
    OPTIONAL { ?mønster dreamst:P46 ?page }
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
    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)
  }


SELECT
  ?pattern ?patternLabel
  (CONCAT("#pattern/", SUBSTR(STR(?pattern), 38)) AS ?patternUrl)


WHERE { 
   SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
  ?pattern dreamst:P2 dreams:Q263 . 
  ?pattern dreamst:P16 / dreamst:P10* target:
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en,da". }
}
}
}}
}}
Retrieved from "https://dreams.wikibase.cloud/wiki/Special:MobileDiff/2826...16448"