80,516
edits
Querying: Difference between revisions
Jump to navigation
Jump to search
no edit summary
(Created page with "Declare these namespaces at the start of every query: ``` PREFIX wd: <https://ottgaz.org/entity/> PREFIX wdt: <https://ottgaz.org/prop/direct/> ```") |
No edit summary |
||
| (11 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
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. | |||
== Namespace == | |||
Declare these namespaces at the start of every query: | Declare these namespaces at the start of every query: | ||
PREFIX og: <https://ottgaz.org/entity/> | |||
PREFIX | PREFIX ogt: <https://ottgaz.org/prop/direct/> | ||
PREFIX | |||
== Sample queries == | |||
=== Label === | |||
All items that are vilayets, as well as their English language label. [https://tinyurl.com/2pren5e2 run] | |||
SELECT ?vilayet ?vilayetLabel | |||
WHERE | |||
{ | |||
?vilayet ogt:P6 og:Q5 . | |||
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 | |||
} | |||
} | |||