Queries: Difference between revisions

From Semantic Name Authority Repository Cymru
Jump to navigation Jump to search
No edit summary
m (Jason.nlw moved page Querries to Queries: spelling)
(No difference)

Revision as of 11:24, 26 November 2022

Enghreifftiau o queries a ddefnyddiwyd i dynnu data o'r gronfa / Examples of queries used to extract data from the database

SNARC Queries

Federated query with Wikidata

Occupations from SNARC with additional information on Subclass from Wikidata (Library of congress ID from both)

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:P7 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". }
}