80,516
edits
Querying: Difference between revisions
Jump to navigation
Jump to search
no edit summary
No edit summary |
No edit summary |
||
| (9 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
Run SPARQL queries via the | Run SPARQL queries via the [https://ottgaz.org/query/ Ottgaz Query Service]. | ||
'''Remember:''' SPARQL is currently case sensitive, as elastic search is disabled in wikibase.cloud. | '''Remember:''' SPARQL is currently case sensitive, as elastic search is disabled in wikibase.cloud. | ||
| Line 7: | Line 7: | ||
Declare these namespaces at the start of every query: | Declare these namespaces at the start of every query: | ||
PREFIX | PREFIX og: <https://ottgaz.org/entity/> | ||
PREFIX | PREFIX ogt: <https://ottgaz.org/prop/direct/> | ||
== Sample queries == | == Sample queries == | ||
=== Label === | === Label === | ||
All items that are vilayets, as well as their English language label. [https://tinyurl.com/2pren5e2 run] | |||
SELECT ?vilayet ?vilayetLabel | SELECT ?vilayet ?vilayetLabel | ||
WHERE | WHERE | ||
{ | { | ||
?vilayet wdt:P6 | ?vilayet ogt:P6 og:Q5 . | ||
?vilayet rdfs:label ?vilayetLabel . | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } | ||
} | |||
== Federated query with Wikidata == | |||
For every sanjak in Ottgaz, this query fetches the vilayet or eyalet to which Wikidata says it belongs. Thanks to Lucas Werkmeister for help. [https://tinyurl.com/2ehssccv run] | |||
PREFIX og: <https://ottgaz.org/entity/> | |||
PREFIX ogt: <https://ottgaz.org/prop/direct/> | |||
PREFIX wd: <http://www.wikidata.org/entity/> | |||
PREFIX wdt: <http://www.wikidata.org/prop/direct/> | |||
SELECT ?sancak ?sancakLabel ?vilayet ?vilayetLabel | |||
WHERE { | |||
?sancak ogt:P6 og:Q4 . # item must be a sanjak | |||
?sancak ogt:P4 ?c . # finds reference URL to wikidata | |||
BIND(IRI(REPLACE(REPLACE(REPLACE(STR(?c), "Property:", ""), "/wiki/", "/entity/"), "https://", "http://")) AS ?wd_c) # produces proper URL for query form | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
?wd_c wdt:P131 ?vilayet . # finds containing vilayet in Wikidata | |||
SERVICE wikibase:label { | |||
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". | |||
?vilayet rdfs:label ?vilayetLabel. # finds label in Wikidata | |||
} | |||
} | |||
SERVICE wikibase:label { | |||
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". | |||
?sancak rdfs:label ?sancakLabel. # finds label in Ottgaz | |||
} | |||
} | } | ||