Querying: Difference between revisions

Line 24: Line 24:
== Federated query with Wikidata ==
== Federated query with Wikidata ==


This is not working. [https://tinyurl.com/2lo9yejm run]
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/2hwkfuza run]


  PREFIX wd: <https://ottgaz.org/entity/>
  PREFIX wd: <https://ottgaz.org/entity/>
Line 31: Line 31:
  PREFIX wd-wdt: <http://www.wikidata.org/prop/direct/>
  PREFIX wd-wdt: <http://www.wikidata.org/prop/direct/>
   
   
  SELECT ?sancak ?vilayet
  SELECT ?sancak ?sancakLabel ?vilayet ?vilayetLabel
  WHERE  
  WHERE {
{
  ?sancak wdt:P6 wd:Q4 . # item must be a sanjak
   ?sancak wdt:P4 ?link .  
   ?sancak wdt:P4 ?c . # finds reference URL to wikidata
    SERVICE <https://query.wikidata.org/sparql> {
  BIND(IRI(REPLACE(REPLACE(REPLACE(STR(?c), "Property:", ""), "/wiki/", "/entity/"), "https://", "http://")) AS ?wd_c) # produces proper URL for query form
      ?link wd-wdt:P131 ?vilayet .
  SERVICE <https://query.wikidata.org/sparql> {
    ?wd_c wd-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
  }
  }
  }