DREAMS

Dreams:report: Difference between revisions

Page Discussion

Dreams:report (view source)

Revision as of 16:21, 10 March 2023

1,159 bytes added ,  1 year ago
→‎Rapportdata
 
(23 intermediate revisions by the same user not shown)
Line 1: Line 1:
== Report data ==
== Rapportdata ==
{{SPARQL | query=
{{SPARQL | query=


Line 6: Line 6:
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
SELECT DISTINCT ?beskrivelse
   ?value ?valueLabel ?valueUrl
   ?værdi ?værdiLabel ?værdiUrl
WHERE {
WHERE {
   BIND(target: AS ?work)
   BIND(target: AS ?work)
   {
   {
     BIND(1 AS ?order)
     BIND(1 AS ?order)
     BIND("Title" AS ?description)
     BIND("Titel" AS ?beskrivelse)
     ?work dreamst:P1 ?value .
     ?work dreamst:P1 ?værdi .
   }
   }
   UNION
   UNION
   {
   {
     BIND(2 AS ?order)
     BIND(2 AS ?order)
     BIND("Author" AS ?description)
     BIND("Forfatter" AS ?beskrivelse)
     target: dreamst:P24 ?iri .
     target: dreamst:P24 ?iri .
     BIND(SUBSTR(STR(?iri), 38) AS ?q)  
     BIND(SUBSTR(STR(?iri), 38) AS ?q)  
     ?iri rdfs:label ?value .  
     ?iri rdfs:label ?værdi .  
     FILTER (LANG(?value) = 'da')
     FILTER (LANG(?værdi) = 'da')
     BIND(CONCAT("#author/", ?q) AS ?valueUrl)
     BIND(CONCAT("#author/", ?q) AS ?værdiUrl)
   }
   }
   UNION
   UNION
   {
   {
     BIND(2.5 AS ?order)
     BIND(2.5 AS ?order)
     BIND("Language" AS ?description)
     BIND("Sprog" AS ?beskrivelse)
     ?work dreamst:P11 ?iri .
     ?work dreamst:P11 ?iri .
     ?iri rdfs:label ?value_string .
     ?iri rdfs:label ?værdi_string .
     FILTER (LANG(?value_string) = 'da')
     FILTER (LANG(?værdi_string) = 'da')
     BIND(STR(?value_string) AS ?value)
     BIND(STR(?værdi_string) AS ?værdi)
   }
   }
   UNION
   UNION
   {
   {
     BIND(6 AS ?order)
     BIND(6 AS ?order)
     BIND("Publication date" AS ?description)
     BIND("Udgivelsesdato" AS ?beskrivelse)
     ?work dreamsp:P6 / dreamspsv:P6 ?publication_date_value .
     ?work dreamsp:P6 / dreamspsv:P6 ?publication_date_værdi .
     ?publication_date_value wikibase:timePrecision ?time_precision ;
     ?publication_date_værdi wikibase:timePrecision ?time_precision ;
                             wikibase:timeValue ?publication_date .
                             wikibase:timeValue ?publication_date .
     BIND(IF(?time_precision = 9, YEAR(?publication_date), xsd:date(?publication_date)) AS ?value)
     BIND(IF(?time_precision = 9, YEAR(?publication_date), xsd:date(?publication_date)) AS ?værdi)
   }
   }
   UNION
   UNION
   {
   {
     BIND(7 AS ?order)
     BIND(7 AS ?order)
     BIND("Publisher" AS ?description)
     BIND("Udgiver" AS ?beskrivelse)
     ?work dreamst:P26 ?iri .
     ?work dreamst:P26 ?iri .
     BIND(SUBSTR(STR(?iri), 38) AS ?q)  
     BIND(SUBSTR(STR(?iri), 38) AS ?q)  
     ?iri rdfs:label ?value_string .  
     ?iri rdfs:label ?værdi_string .  
     FILTER (LANG(?value_string) = 'da')
     FILTER (LANG(?værdi_string) = 'da')
     BIND(COALESCE(?value_string, ?q) AS ?value)
     BIND(COALESCE(?værdi_string, ?q) AS ?værdi)
     BIND(CONCAT("#publisher/", ?q) AS ?valueUrl)
     BIND(CONCAT("#publisher/", ?q) AS ?værdiUrl)
   }
   }
   UNION
   UNION
   {
   {
     BIND(10 AS ?order)
     BIND(10 AS ?order)
     BIND("Project type" AS ?description)
     BIND("Projekttype" AS ?beskrivelse)
     ?work dreamst:P16 ?value .
     ?work dreamst:P16 ?værdi .
     BIND(CONCAT("#projecttype/", SUBSTR(STR(?value), 38)) AS ?valueUrl)
     BIND(CONCAT("#projecttype/", SUBSTR(STR(?værdi), 38)) AS ?værdiUrl)
   }
   }
   UNION
   UNION
   {
   {
     BIND(21 AS ?order)
     BIND(21 AS ?order)
     BIND("Scholia" AS ?description)
     BIND("Scholia" AS ?beskrivelse)
     ?work dreamst:P3 ?value_ .
     ?work dreamst:P3 ?værdi_ .
     BIND(CONCAT(STR(?value_), " ↗") AS ?value)
     BIND(CONCAT(STR(?værdi_), " ↗") AS ?værdi)
     BIND(CONCAT("https://scholia.toolforge.org/work/", STR(?value_)) AS ?valueUrl)
     BIND(CONCAT("https://scholia.toolforge.org/work/", STR(?værdi_)) AS ?værdiUrl)
   }
   }
   UNION
   UNION
   {
   {
     BIND(22 AS ?order)
     BIND(22 AS ?order)
     BIND("Miljøportal" AS ?description)
     BIND("Miljøportal" AS ?beskrivelse)
     ?work dreamst:P40 ?value_ .
     ?work dreamst:P40 ?værdi_ .
     BIND(CONCAT(STR(?value_), " ↗") AS ?value)
     BIND(CONCAT(STR(?værdi_), " ↗") AS ?værdi)
     BIND(CONCAT("https://daieproddreamspdfsto.blob.core.windows.net/files/", STR(?value_)) AS ?valueUrl)
     BIND(CONCAT("https://daieproddreamspdfsto.blob.core.windows.net/files/", STR(?værdi_)) AS ?værdiUrl)
  }
  UNION
  {
    BIND(100 AS ?order)
    BIND("Andre rapporter" AS ?beskrivelse)
    BIND("🔍" AS ?værdi)
    BIND(CONCAT("#report/", SUBSTR(STR(target:), 38), "/report") AS ?værdiUrl)
   }
   }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],da,en". }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],da,en". }
Line 84: Line 91:
}}
}}


== Patterns ==
== Mønstre ==
{{SPARQL | query=  
{{SPARQL | query=  
PREFIX target: <https://dreams.wikibase.cloud/entity/Q676>
PREFIX target: <https://dreams.wikibase.cloud/entity/Q406>
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 93: Line 100:


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


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


   ?object ?objectLabel ?objectUrl
   ?påvirkning ?påvirkningLabel ?påvirkningUrl


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


   ?significance ?significanceLabel
   ?signifikans ?signifikansLabel


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


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


   ?project_type ?project_typeLabel
   ?projektfase ?projektfaseLabel
   (CONCAT("#projecttype/", SUBSTR(STR(?project_type), 38)) AS ?project_typeUrl)   
  (CONCAT("#projectphase/", SUBSTR(STR(?projektfase), 38)) AS ?projektfaseUrl) 
 
  ?projekttype ?projekttypeLabel
   (CONCAT("#projecttype/", SUBSTR(STR(?projekttype), 38)) AS ?projekttypeUrl)   


   ?link ?linkUrl
   ?link ?linkUrl


WITH {
WITH {
   SELECT  
   SELECT DISTINCT
     ?pattern
     ?mønster
     ?subject ?subjectLabel ?subjectUrl
     ?subjekt ?subjektLabel ?subjektUrl
     ?object ?objectLabel ?objectUrl
     ?påvirkning ?påvirkningLabel ?påvirkningUrl
     ?recipient ?recipientLabel ?recipientUrl
     ?recipient ?recipientLabel ?recipientUrl
     ?significance
     ?signifikans ?signifikansLabel
     ?quote
    ?afbødning ?afbødningLabel ?afbødningUrl
     ?project_phase
     ?citat
     ?project_type
     ?projektfase
     ?projekttype
     ?link ?linkUrl
     ?link ?linkUrl
   WHERE {
   WHERE {
     ?pattern dreamst:P2 dreams:Q263 ;
     ?mønster dreamst:P2 dreams:Q263 ;
          dreamst:P20 target: .
            dreamst:P20 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(COALESCE(?subject_label, ""), ' ("', ?subject_text, '")') AS ?subjectLabel)
     BIND(CONCAT(?subjekt_text, " (", COALESCE(?subjekt_label, ""), ")") AS ?subjektLabel)
      
      
     OPTIONAL {
     OPTIONAL {
       OPTIONAL {
       ?mønster dreamst:P34 ?påvirkning .  
        ?pattern dreamst:P34 ?object .  
      ?påvirkning rdfs:label ?påvirkning_label .
        ?object rdfs:label ?object_label .
      FILTER (LANG(?påvirkning_label) = 'da')
        FILTER (LANG(?object_label) = 'da')
      BIND(CONCAT("#effect/", SUBSTR(STR(?påvirkning), 38)) AS ?påvirkningUrl)
        BIND(CONCAT("#effect/", SUBSTR(STR(?object), 38)) AS ?objectUrl)
      }
      OPTIONAL { ?pattern dreamst:P49 ?object_text }
      BIND(COALESCE(?object, ?object_text) AS ?object)
      BIND(CONCAT(COALESCE(?object_label, ""), ' ("', ?object_text, '")') AS ?objectLabel)
     }
     }
    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 {
     OPTIONAL {
       OPTIONAL {
       ?mønster dreamst:P55 ?recipient .
        ?pattern 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 { ?mønster dreamst:P54 ?recipient_text }
      OPTIONAL { ?pattern 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(COALESCE(?recipient_label, ""), ' ("', ?recipient_text, '")') AS ?recipientLabel)
    }
    
    
     OPTIONAL { ?pattern dreamst:P18 ?quote . }
     OPTIONAL {
    OPTIONAL { ?pattern dreamst:P19 ?project_phase . }
      ?mønster dreamst:P56 ?afbødning .
     OPTIONAL { ?pattern dreamst:P16 ?project_type . }
      ?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 { ?pattern dreamst:P21 ?significance } # / dreamst:P44 ?symbol . }
     OPTIONAL { ?mønster dreamst:P18 ?citat . }
    # BIND(IF(BOUND(?symbol), ?symbol, "❓") AS ?significance)
 
    OPTIONAL { ?mønster dreamst:P19 ?projektfase . }
   
    OPTIONAL { ?mønster dreamst:P16 ?projekttype1 . }
    OPTIONAL { ?mønster dreamst:P20 / dreamst:P16 ?projekttype2 . }
    BIND(COALESCE(?projekttype1, ?projekttype2) AS ?projekttype)
               
    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 {
     OPTIONAL {
       ?pattern dreamst:P20 ?report .
       ?mønster dreamst:P20 ?report .
       ?report dreamst:P40 ?miljøportal .
       ?report 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),  
Line 186: Line 212:
}}
}}


== Locations ==
== Steder ==
SPARQL | query=
{{SPARQL | query=
PREFIX target: <https://dreams.wikibase.cloud/entity/Q158>
PREFIX target: <https://dreams.wikibase.cloud/entity/Q158>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
Line 197: Line 223:


SELECT  
SELECT  
   ?location ?locationLabel
   ?sted ?stedLabel
   (CONCAT("#location/", SUBSTR(STR(?location), 38)) AS ?locationUrl)
   (CONCAT("#location/", SUBSTR(STR(?sted), 38)) AS ?stedUrl)
   ?locationDescription
   ?stedDescription


   ?quote
   ?citat
WHERE {
WHERE {
   target: dreamsp:P12 ?location_statement .
   target: dreamsp:P12 ?sted_statement .
   ?location_statement dreamsps:P12 ?location .
   ?sted_statement dreamsps:P12 ?sted .
   OPTIONAL {
   OPTIONAL {
     ?location_statement prov:wasDerivedFrom / dreamspr:P18 ?quote .
     ?sted_statement prov:wasDerivedFrom / dreamspr:P18 ?citat .
   }
   }
    
    
Line 213: Line 239:
}}
}}


== Citations ==
Citations
SPARQL | query=
SPARQL | query=
PREFIX target: <https://dreams.wikibase.cloud/entity/Q100>
PREFIX target: <https://dreams.wikibase.cloud/entity/Q100>
Line 240: Line 266:
}}
}}


== Related works from co-citations ==
Related works from co-citations  
SPARQL | query=
SPARQL | query=
PREFIX target: <https://dreams.wikibase.cloud/entity/Q100>
PREFIX target: <https://dreams.wikibase.cloud/entity/Q100>
Retrieved from "https://dreams.wikibase.cloud/wiki/Special:MobileDiff/7842...17590"