query-b3aae2afc95ddb9125e3eb9b48bea682

rq turtle/ttl

Reports

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT 
  DISTINCT 
  ?year

  ?report ?reportLabel
  (CONCAT("#eiareport/", SUBSTR(STR(?report), 32)) AS ?reportUrl)

  ("Scholia ↗" AS ?scholia) 
  (CONCAT("https://scholia.toolforge.org/work/", SUBSTR(STR(?report), 32)) AS ?scholiaUrl)

  ("Full text ↗" AS ?full_text)
  ?full_textUrl

  ("Miljøportal ↗" AS ?miljøportal) ?miljøportalUrl
WHERE {
  ?report wdt:P31 wd:Q64548048 .
  OPTIONAL {
    ?report wdt:P577 ?publication_datetime .
    BIND(YEAR(?publication_datetime) AS ?year)        
  }

  OPTIONAL {
    ?report wdt:P953 ?full_textUrl
  }
  OPTIONAL {
    ?report wdt:P10930 ?miljøportalId .
    BIND(CONCAT("https://daieproddreamspdfsto.blob.core.windows.net/files/", STR(?miljøportalId)) AS ?miljøportalUrl)
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,da". }
}
ORDER BY DESC(?year)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v10("?full_text") v4("?full_textUrl"):::projected v11("?miljøportal") v5("?miljøportalId") v6("?miljøportalUrl"):::projected v3("?publication_datetime") v2("?report"):::projected v7("?reportUrl") v8("?scholia") v9("?scholiaUrl") v4("?year"):::projected c9(["#91;AUTO_LANGUAGE#93;,en,da"]):::literal c7(["bd:serviceParam"]):::iri c2(["wd:Q64548048"]):::iri v2 --"wdt:P31"--> c2 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P577".-> v3 bind0[/"year-from-dateTime(?publication_datetime)"/] v3 --o bind0 bind0 --as--o v4 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P953".-> v4 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P10930".-> v5 bind1[/"concat('https://daieproddreamspdfsto.blob.core.windows.net/files/',str(?miljøportalId))"/] v5 --o bind1 bind1 --as--o v6 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c7 --"wikibase:language"--> c9 end bind2[/"concat('#eiareport/',substring(str(?report),'32^^xsd:integer'))"/] v2 --o bind2 bind2 --as--o v7 bind3[/"'Scholia ↗'"/] bind3 --as--o v8 bind4[/"concat('https://scholia.toolforge.org/work/',substring(str(?report),'32^^xsd:integer'))"/] v2 --o bind4 bind4 --as--o v9 bind5[/"'Full text ↗'"/] bind5 --as--o v10 bind6[/"'Miljøportal ↗'"/] bind6 --as--o v11