Dreams:report: Difference between revisions

From DREAMS
Jump to navigation Jump to search
(→‎Patterns: Change recipient code)
 
(29 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/Q406>
PREFIX target: <https://dreams.wikibase.cloud/entity/Q406>
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
   ?subjekt ?subjektLabel ?subjektUrl
  (CONCAT("#effect/", SUBSTR(STR(?subject), 38)) AS ?subjectUrl) 


   ?object ?objectLabel
   ?påvirkning ?påvirkningLabel ?påvirkningUrl
  (CONCAT("#effect/", SUBSTR(STR(?object), 38)) AS ?objectUrl) 


   ?recipient ?recipientLabel
   ?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
     ?subjekt ?subjektLabel ?subjektUrl
     ?object
     ?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 { ?pattern dreamst:P33 ?subject . }
     OPTIONAL {
     OPTIONAL {
       ?pattern dreamst:P34 ?object .  
       ?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 {
     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 171: Line 212:
}}
}}


== Locations ==
== Steder ==
{{SPARQL | query=
{{SPARQL | query=
PREFIX target: <https://dreams.wikibase.cloud/entity/Q158>
PREFIX target: <https://dreams.wikibase.cloud/entity/Q158>
Line 182: 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 198: Line 239:
}}
}}


== Citations ==
Citations
{{SPARQL | query=
SPARQL | query=
PREFIX target: <https://dreams.wikibase.cloud/entity/Q100>
PREFIX target: <https://dreams.wikibase.cloud/entity/Q100>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
Line 225: 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>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>

Latest revision as of 16:21, 10 March 2023

Rapportdata

PREFIX target: <https://dreams.wikibase.cloud/entity/Q158>
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 ?beskrivelse
  ?værdi ?værdiLabel ?værdiUrl
WHERE {
  BIND(target: AS ?work)
  {
    BIND(1 AS ?order)
    BIND("Titel" AS ?beskrivelse)
    ?work dreamst:P1 ?værdi .
  }
  UNION
  {
    BIND(2 AS ?order)
    BIND("Forfatter" AS ?beskrivelse)
    target: dreamst:P24 ?iri .
    BIND(SUBSTR(STR(?iri), 38) AS ?q) 
    ?iri rdfs:label ?værdi . 
    FILTER (LANG(?værdi) = 'da')
    BIND(CONCAT("#author/", ?q) AS ?værdiUrl)
  }
  UNION
  {
    BIND(2.5 AS ?order)
    BIND("Sprog" AS ?beskrivelse)
    ?work dreamst:P11 ?iri .
    ?iri rdfs:label ?værdi_string .
    FILTER (LANG(?værdi_string) = 'da')
    BIND(STR(?værdi_string) AS ?værdi)
  }
  UNION
  {
    BIND(6 AS ?order)
    BIND("Udgivelsesdato" AS ?beskrivelse)
    ?work dreamsp:P6 / dreamspsv:P6 ?publication_date_værdi .
    ?publication_date_værdi wikibase:timePrecision ?time_precision ;
                            wikibase:timeValue ?publication_date .
    BIND(IF(?time_precision = 9, YEAR(?publication_date), xsd:date(?publication_date)) AS ?værdi)
  }
  UNION
  {
    BIND(7 AS ?order)
    BIND("Udgiver" AS ?beskrivelse)
    ?work dreamst:P26 ?iri .
    BIND(SUBSTR(STR(?iri), 38) AS ?q) 
    ?iri rdfs:label ?værdi_string . 
    FILTER (LANG(?værdi_string) = 'da')
    BIND(COALESCE(?værdi_string, ?q) AS ?værdi)
    BIND(CONCAT("#publisher/", ?q) AS ?værdiUrl)
  }
  UNION
  {
    BIND(10 AS ?order)
    BIND("Projekttype" AS ?beskrivelse)
    ?work dreamst:P16 ?værdi .
    BIND(CONCAT("#projecttype/", SUBSTR(STR(?værdi), 38)) AS ?værdiUrl)
  }
  UNION
  {
    BIND(21 AS ?order)
    BIND("Scholia" AS ?beskrivelse)
    ?work dreamst:P3 ?værdi_ .
    BIND(CONCAT(STR(?værdi_), " ↗") AS ?værdi)
    BIND(CONCAT("https://scholia.toolforge.org/work/", STR(?værdi_)) AS ?værdiUrl)
  }
  UNION
  {
    BIND(22 AS ?order)
    BIND("Miljøportal" AS ?beskrivelse)
    ?work dreamst:P40 ?værdi_ .
    BIND(CONCAT(STR(?værdi_), " ↗") AS ?værdi)
    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". }
} 
ORDER BY ?order


Mønstre

PREFIX target: <https://dreams.wikibase.cloud/entity/Q406>
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
  ?mønster ("🔍" AS ?mønsterLabel)
  (CONCAT("#pattern/", SUBSTR(STR(?mønster), 38)) AS ?mønsterUrl)  

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

  ?projekttype ?projekttypeLabel
  (CONCAT("#projecttype/", SUBSTR(STR(?projekttype), 38)) AS ?projekttypeUrl)  

  ?link ?linkUrl

WITH {
  SELECT DISTINCT 
    ?mønster
    ?subjekt ?subjektLabel ?subjektUrl
    ?påvirkning ?påvirkningLabel ?påvirkningUrl
    ?recipient ?recipientLabel ?recipientUrl
    ?signifikans ?signifikansLabel
    ?afbødning ?afbødningLabel ?afbødningUrl
    ?citat
    ?projektfase
    ?projekttype
    ?link ?linkUrl
  WHERE {
    ?mønster dreamst:P2 dreams:Q263 ;
             dreamst:P20 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: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 {
      ?mønster dreamst:P20 ?report .
      ?report 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)
    }
  }
} AS %result
WHERE {
  INCLUDE %result
  SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
}


Steder

PREFIX target: <https://dreams.wikibase.cloud/entity/Q158>
PREFIX dreams: <https://dreams.wikibase.cloud/entity/>
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>
PREFIX dreamsp: <https://dreams.wikibase.cloud/prop/>
PREFIX dreamspr: <https://dreams.wikibase.cloud/prop/reference/>
PREFIX dreamsps: <https://dreams.wikibase.cloud/prop/statement/> 
PREFIX prov: <http://www.w3.org/ns/prov#>

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

  ?citat
WHERE {
  target: dreamsp:P12 ?sted_statement .
  ?sted_statement dreamsps:P12 ?sted .
  OPTIONAL {
    ?sted_statement prov:wasDerivedFrom / dreamspr:P18 ?citat .
  }
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". }
}


Citations SPARQL | query= PREFIX target: <https://dreams.wikibase.cloud/entity/Q100> 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

 ?title
 ("Scholia ↗" AS ?scholia) 
 ?scholiaUrl

WHERE {

 target: dreamst:P3 ?wikidata_q .
 BIND(IRI(CONCAT("http://www.wikidata.org/entity/", ?wikidata_q)) AS ?wikidata)
 
 SERVICE <https://query.wikidata.org/sparql> {
   ?wikidata wdt:P2860 ?cited .
   OPTIONAL {
     ?cited wdt:P1476 ?title .
   }
   BIND(CONCAT("https://scholia.toolforge.org/work/", SUBSTR(STR(?cited), 32)) AS ?scholiaUrl)
 }

} }}

Related works from co-citations 

SPARQL | query= PREFIX target: <https://dreams.wikibase.cloud/entity/Q100> PREFIX dreams: <https://dreams.wikibase.cloud/entity/> PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/>

SELECT

 ?score
 ?title ?titleUrl
 ("Scholia ↗" AS ?scholia) ?scholiaUrl
 

WHERE {

 { 
   SELECT 
     (COUNT(*) AS ?score)
     ?work ?title
   WHERE {
     target: dreamst:P3 ?wikidata_q .
     BIND(IRI(CONCAT("http://www.wikidata.org/entity/", ?wikidata_q)) AS ?wikidata)
 
     SERVICE <https://query.wikidata.org/sparql> {
       ?wikidata (^wdt:P2860 | wdt:P2860) / (^wdt:P2860 | wdt:P2860)? ?work .
       FILTER (?wikidata != ?work)
       ?work wdt:P1476 ?title .
     }
   }
   GROUP BY ?work ?title 
   ORDER BY DESC(?count)
   LIMIT 500
 }
 BIND(CONCAT("https://scholia.toolforge.org/work/", SUBSTR(STR(?work), 32)) AS ?scholiaUrl)
 BIND(SUBSTR(STR(?work), 32) AS ?work_q)
 OPTIONAL {
   ?dreams_work dreamst:P3 ?work_q .
   BIND(CONCAT("#report/", SUBSTR(STR(?dreams_work), 38)) AS ?titleUrl)
 }

} ORDER BY DESC(?score) DESC(?titleUrl)

}}