80,516
edits
(map of sancak seats) |
|||
(6 intermediate revisions by the same user not shown) | |||
Line 78: | Line 78: | ||
ORDER BY desc(?count) | ORDER BY desc(?count) | ||
=== | ===Number of kazas between 1800 and 1900=== | ||
*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 | PREFIX wdt: <http://www.wikidata.org/prop/direct/> | ||
FILTER (?number >= | SELECT ?number (count(*) as ?count) { | ||
? | SERVICE <https://query.wikidata.org/sparql> { | ||
? | ?year wdt:P31 wd:Q21199 ; wdt:P1181 ?number | ||
?statement ogps:P15 og: | 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 == |