Querying: Difference between revisions

Jump to navigation Jump to search

Querying (view source)

Revision as of 18:49, 15 March 2023

1,289 bytes added ,  1 year ago
map of sancak seats
(map of sancak seats)
(8 intermediate revisions by the same user not shown)
Line 18: Line 18:


=== Label ===
=== Label ===
All items that are vilayets, as well as their English language label. [https://tinyurl.com/2pren5e2 run]
All regions that had vilayet status, as well as their English language label. [https://tinyurl.com/2k4uq6u2 run]


  SELECT ?vilayet ?vilayetLabel
  SELECT ?vilayet ?vilayetLabel
  WHERE  
  WHERE  
  {
  {
   ?vilayet ogt:P6 og:Q5 .  
   ?vilayet ogt:P15 og:Q5.
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
  }
  }
Line 78: Line 78:
  ORDER BY desc(?count)
  ORDER BY desc(?count)


===How many kazas between 1800 and 1900?===
===Number of kazas between 1800 and 1900===
Not working yet. Thanks to [https://stackoverflow.com/users/7879193/stanislav-kralin Stanislav Kralin] for [https://stackoverflow.com/questions/75137894/counting-items-over-time-using-sparql help]. [ run]
*This query is not working yet.* The query below returns the number of vilayets between 1750 and 1760. Thanks to [https://stackoverflow.com/users/7879193/stanislav-kralin Stanislav Kralin] for [https://stackoverflow.com/questions/75137894/counting-items-over-time-using-sparql help]. [ run]


  SELECT ?number (count(*) as ?count)  {
PREFIX wd: <http://www.wikidata.org/entity/>
  ?year ogt:P6 og:Q15677 ; ogt:P24 ?number
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
  FILTER (?number >= 1800 && ?number <= 1900)
  SELECT ?number (count(*) as ?count)  {
  ?kaza ogt:P15 og:Q3.
  SERVICE <https://query.wikidata.org/sparql> {
  ?kaza ogp:P15 ?statement.
  ?year wdt:P31 wd:Q21199 ; wdt:P1181 ?number
  ?statement ogps:P15 og:Q3.
  FILTER (?number >= 1750 && ?number <= 1760)
}
  ?vilayet ogt:P15 og:Q5.
  ?vilayet ogp:P15 ?statement.
  ?statement ogps:P15 og:Q5.
  ?statement ogpq:P7 ?starttime.
  ?statement ogpq:P7 ?starttime.
  OPTIONAL{?statement ogpq:P8 ?endtime.}
  OPTIONAL{?statement ogpq:P8 ?endtime.}
Line 93: Line 97:
  BIND (YEAR(COALESCE(?endtime, NOW())) AS ?year2)
  BIND (YEAR(COALESCE(?endtime, NOW())) AS ?year2)
  FILTER (?number >= ?year1 && ?number <= ?year2)
  FILTER (?number >= ?year1 && ?number <= ?year2)
  }  
  }
  group by ?number
  group by ?number
  order by ?number
  order by ?number
===Sancak status ending between 1830 and 1840===
This query will return the region more than once, if it undergoes status change more than once during this time period. [https://tinyurl.com/2ew6y2vw run]
SELECT ?sancak ?sancakLabel (YEAR(?starttime) as ?start) (YEAR(?endtime) as ?end)
WHERE
{
  ?sancak ogt:P6 og:Q1.
  ?sancak ogp:P15 ?statement.
  ?statement ogps:P15 og:Q4.
  ?statement ogpq:P7 ?starttime.
  OPTIONAL{?statement ogpq:P8 ?endtime.}
  OPTIONAL{?statement ogpq:P22 ?endtime.}
  FILTER(YEAR(?endtime) >= 1830 && YEAR(?endtime) <= 1840) 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
ORDER BY (?endtime)
=== Map of sanjak seats ===
This shows only those sanjaks with seats designated and geolocated. [https://tinyurl.com/2hqpwoas run]
#defaultView:Map
SELECT ?sancakLabel ?seatLabel ?geo
WHERE
{
  ?sancak ogt:P15 og:Q4.
  ?sancak ogt:P14 ?seat.
  OPTIONAL {?seat ogt:P10 ?geo.}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}


== Federated query with Wikidata ==
== 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]
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/2eokop65 run]


  PREFIX og: <https://ottgaz.org/entity/>
  PREFIX og: <https://ottgaz.org/entity/>
Line 108: Line 143:
  SELECT ?sancak ?sancakLabel ?vilayet ?vilayetLabel
  SELECT ?sancak ?sancakLabel ?vilayet ?vilayetLabel
  WHERE {
  WHERE {
   ?sancak ogt:P6 og:Q4 . # item must be a sanjak
   ?sancak ogt:P15 og:Q4 . # item must be a sanjak
   ?sancak ogt:P4 ?c . # finds reference URL to wikidata
   ?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
   BIND(IRI(REPLACE(REPLACE(REPLACE(STR(?c), "Property:", ""), "/wiki/", "/entity/"), "https://", "http://")) AS ?wd_c) # produces proper URL for query form
Retrieved from "https://ottgaz.org/wiki/Special:MobileDiff/41098...44025"

Navigation menu