983,963
edits
Queries: Difference between revisions
Jump to navigation
Jump to search
no edit summary
(Created page with "Enghreifftiau o querries a ddefnyddiwyd i dynnu data o'r gronfa / ''Examples of querries used to extract data from the database'' {{#tag:syntaxhighlight| SELECT ?a ?b ?c WHERE { x y ?a. m n ?b. ?b f ?c. } |lang=SPARQL }}") |
No edit summary |
||
| Line 1: | Line 1: | ||
Enghreifftiau o | Enghreifftiau o queries a ddefnyddiwyd i dynnu data o'r gronfa / ''Examples of queries used to extract data from the database'' | ||
== Federated query with Wikidata == | |||
# Occupations from SNARC with additional information on Subclass from Wikidata (Library of congress ID from both) | |||
{{#tag:syntaxhighlight| | {{#tag:syntaxhighlight| | ||
SELECT ? | PREFIX wikibase: <http://wikiba.se/ontology#> | ||
PREFIX snarcp: <https://snarc-llgc.wikibase.cloud/prop/direct/> | |||
{ | PREFIX snarcq: <https://snarc-llgc.wikibase.cloud/entity/> | ||
PREFIX wdt: <http://www.wikidata.org/prop/direct/> | |||
PREFIX wd: <http://www.wikidata.org/entity/> | |||
? | PREFIX bd: <http://www.bigdata.com/rdf#> | ||
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> | |||
SELECT DISTINCT ?item ?itemLabel ?wikidataid ?libcongid ?subclas ?subclaslabel ?libcongwikidata WHERE { | |||
?item snarcp:P45 snarcq:Q63 . | |||
?item snarcp:P62 ?wikidataid . | |||
?item snarcp:P11 ?libcongid | |||
SERVICE <https://query.wikidata.org/sparql>{ | |||
?wikidataid wdt:P279 ?subclas. | |||
?subclas rdfs:label ?subclaslabel . | |||
FILTER(LANG(?subclaslabel) = "en"). | |||
?subclas wdt:P244 ?libcongwikidata . | |||
} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } | |||
} | } | ||
}} | }} | ||