Queries: Difference between revisions

Queries (view source)

Revision as of 11:11, 26 November 2022

307 bytes added , 1 year ago

no edit summary

Jason.nlw

Bots, Bureaucrats, Administrators

988,120

edits

@@ Line 4: / Line 4: @@
 == Federated query with Wikidata ==
 # Occupations from SNARC with additional information on Subclass from Wikidata (Library of congress ID from both)
-{{SPARQL|query=#Returns a list of Wikidata items for a given list of Wikipedia article names
-#List of Wikipedia article names (lemma) is like "WIKIPEDIA ARTICLE NAME"@LANGUAGE CODE with de for German, en for English, etc.
-#Language version and project is defined in schema:isPartOF with de.wikipedia.org for German Wikipedia, es.wikivoyage for Spanish Wikivoyage, etc.
-SELECT ?lemma ?item WHERE {
+<syntaxhighlight lang="sparql">
-  VALUES ?lemma {
-    "Wikipedia"@de
+PREFIX wikibase: <http://wikiba.se/ontology#>
-    "Wikidata"@de
+PREFIX snarcp: <https://snarc-llgc.wikibase.cloud/prop/direct/>
-    "Berlin"@de
+PREFIX snarcq: <https://snarc-llgc.wikibase.cloud/entity/>
-    "Technische Universität Berlin"@de
+PREFIX wdt: <http://www.wikidata.org/prop/direct/>
-   }
+PREFIX wd: <http://www.wikidata.org/entity/>
-   ?sitelink schema:about ?item;
+PREFIX bd: <http://www.bigdata.com/rdf#>
-    schema:isPartOf <https://de.wikipedia.org/>;
+PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
-     schema:name ?lemma.
+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". }
 }
-}}
+</syntaxhighlight>