DREAMS

Dreams:report: Difference between revisions

Page Discussion

Dreams:report (view source)

Revision as of 13:26, 9 December 2022

33 bytes added ,  1 year ago
→‎Report data
(→‎Patterns: Changed appearance of significanec)
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("Title" 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("Author" 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("Language" 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("Publication date" 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("Publisher" 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("Project type" 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)
   }
   }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],da,en". }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],da,en". }
Retrieved from "https://dreams.wikibase.cloud/wiki/Special:MobileDiff/16450"