Dreams:effect: Difference between revisions
Jump to navigation
Jump to search
Line 87: | Line 87: | ||
(CONCAT("#pattern/", SUBSTR(STR(?mønster), 38)) AS ?mønsterUrl) | (CONCAT("#pattern/", SUBSTR(STR(?mønster), 38)) AS ?mønsterUrl) | ||
? | ?rapport ?rapportLabel | ||
(CONCAT("#report/", SUBSTR(STR(? | (CONCAT("#report/", SUBSTR(STR(?rapport), 38)) AS ?rapportUrl) | ||
? | ?subjekt ?subjektLabel ?subjektUrl | ||
?impact ?impactLabel ?impactUrl | ?impact ?impactLabel ?impactUrl | ||
Line 96: | Line 96: | ||
?recipient ?recipientLabel ?recipientUrl | ?recipient ?recipientLabel ?recipientUrl | ||
? | ?signifikans ?signifikansLabel | ||
? | ?afbødning ?afbødningLabel ?afbødningUrl | ||
?quote | ?quote | ||
? | ?projektfase ?projektfaseLabel | ||
(CONCAT("#projectphase/", SUBSTR(STR(? | (CONCAT("#projectphase/", SUBSTR(STR(?projektfase), 38)) AS ?projektfaseUrl) | ||
?link ?linkUrl | ?link ?linkUrl | ||
Line 112: | Line 112: | ||
OPTIONAL { | OPTIONAL { | ||
?mønster dreamst:P33 ? | ?mønster dreamst:P33 ?subjekt . | ||
? | ?subjekt rdfs:label ?subjekt_label . | ||
FILTER(LANG(? | FILTER(LANG(?subjekt_label) = 'da') | ||
BIND(CONCAT("#effect/", SUBSTR(STR(? | BIND(CONCAT("#effect/", SUBSTR(STR(?subjekt), 38)) AS ?subjektUrl) | ||
} | } | ||
OPTIONAL { ?mønster dreamst:P47 ? | OPTIONAL { ?mønster dreamst:P47 ?subjekt_text } | ||
BIND(COALESCE(? | BIND(COALESCE(?subjekt, ?subjekt_text, "") AS ?subjekt) | ||
BIND(CONCAT(? | BIND(CONCAT(?subjekt_text, " (", COALESCE(?subjekt_label, ""), ")") AS ?subjektLabel) | ||
OPTIONAL { | OPTIONAL { | ||
Line 142: | Line 142: | ||
OPTIONAL { | OPTIONAL { | ||
?mønster dreamst:P56 ? | ?mønster dreamst:P56 ?afbødning . | ||
? | ?afbødning rdfs:label ?afbødning_label . | ||
FILTER (LANG(? | FILTER (LANG(?afbødning_label) = 'da') | ||
BIND(CONCAT("#effect/", SUBSTR(STR(? | BIND(CONCAT("#effect/", SUBSTR(STR(?afbødning), 38)) AS ?afbødningUrl) | ||
} | } | ||
OPTIONAL { ?mønster dreamst:P53 ? | OPTIONAL { ?mønster dreamst:P53 ?afbødning_text } | ||
BIND(COALESCE(? | BIND(COALESCE(?afbødning, ?afbødning_text) AS ?afbødning) | ||
BIND(CONCAT(? | BIND(CONCAT(?afbødning_text, " (", COALESCE(?afbødning_label, ""), ")") AS ?afbødningLabel) | ||
OPTIONAL { ?mønster dreamst:P18 ?quote . } | OPTIONAL { ?mønster dreamst:P18 ?quote . } | ||
OPTIONAL { ?mønster dreamst:P19 ? | OPTIONAL { ?mønster dreamst:P19 ?projektfase . } | ||
OPTIONAL { ?mønster dreamst:P20 ? | OPTIONAL { ?mønster dreamst:P20 ?rapport . } | ||
OPTIONAL { | OPTIONAL { | ||
?mønster dreamst:P21 ? | ?mønster dreamst:P21 ?signifikans . | ||
? | ?signifikans rdfs:label ?signifikans_text . | ||
FILTER (LANG(? | FILTER (LANG(?signifikans_text) = 'da') | ||
OPTIONAL { ? | OPTIONAL { ?signifikans dreamst:P44 ?symbol . } | ||
BIND(IF(BOUND(?symbol), ?symbol, "❓") AS ? | BIND(IF(BOUND(?symbol), ?symbol, "❓") AS ?signifikans_symbol) | ||
BIND(CONCAT(? | BIND(CONCAT(?signifikans_symbol, " ", ?signifikans_text) AS ?signifikansLabel) | ||
} | } | ||
OPTIONAL { | OPTIONAL { | ||
?mønster dreamst:P20 ? | ?mønster dreamst:P20 ?rapport . | ||
? | ?rapport dreamst:P40 ?miljøportal . | ||
OPTIONAL { ?mønster 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) |
Revision as of 14:24, 9 December 2022
Effektdata
PREFIX target: <https://dreams.wikibase.cloud/entity/Q179> 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 DISTINCT (?description AS ?beskrivelse) ?value ?valueLabel ?valueUrl WHERE { BIND(target: AS ?effect) { BIND(1 AS ?order) BIND("Effekt" AS ?description) BIND(target: AS ?value) . } UNION { BIND(5 AS ?order) BIND("Overbegreb" AS ?description) target: dreamst:P10 ?value . BIND(SUBSTR(STR(?value), 38) AS ?q) BIND(CONCAT("#effect/", ?q) AS ?valueUrl) } UNION { BIND(6 AS ?order) BIND("Overbegreb" AS ?description) target: ^dreamst:P10 ?value . BIND(SUBSTR(STR(?value), 38) AS ?q) BIND(CONCAT("#effect/", ?q) AS ?valueUrl) } UNION { BIND(6 AS ?order) BIND("Påvirker" AS ?description) target: dreamst:P9 ?value . BIND(CONCAT("#effect/", SUBSTR(STR(?value), 38)) AS ?valueUrl) } UNION { BIND(2 AS ?order) BIND("Er påvirket af" AS ?description) target: ^dreamst:P9 ?value . BIND(CONCAT("#effect/", SUBSTR(STR(?value), 38)) AS ?valueUrl) } UNION { BIND(10 AS ?order) BIND("SDG" AS ?description) target: dreamst:P42 ?value . BIND(CONCAT("#sdg/", SUBSTR(STR(?value), 38)) AS ?valueUrl) } UNION { BIND(11 AS ?order) BIND("arter.dk" AS ?description) target: dreamst:P45 ?value_ . BIND(CONCAT(?value_, " ↗") AS ?value) BIND(CONCAT("https://arter.dk/taxa/taxon/details/", ?value_) AS ?valueUrl) } UNION { BIND(20 AS ?order) BIND("Scholia" AS ?description) target: dreamst:P3 ?value_ . BIND(CONCAT(?value_, " ↗") AS ?value) BIND(CONCAT("https://scholia.toolforge.org/topic/", ?value_) AS ?valueUrl) } SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". } } ORDER BY ?order
Mønstre
PREFIX target: <https://dreams.wikibase.cloud/entity/Q309> 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) ?rapport ?rapportLabel (CONCAT("#report/", SUBSTR(STR(?rapport), 38)) AS ?rapportUrl) ?subjekt ?subjektLabel ?subjektUrl ?impact ?impactLabel ?impactUrl ?recipient ?recipientLabel ?recipientUrl ?signifikans ?signifikansLabel ?afbødning ?afbødningLabel ?afbødningUrl ?quote ?projektfase ?projektfaseLabel (CONCAT("#projectphase/", SUBSTR(STR(?projektfase), 38)) AS ?projektfaseUrl) ?link ?linkUrl WHERE { ?mønster dreamst:P2 dreams:Q263 ; ( dreamst:P33