80,516
edits
Querying: Difference between revisions
Jump to navigation
Jump to search
map of sancak seats
(map of sancak seats) |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 102: | Line 102: | ||
===Sancak status ending between 1830 and 1840=== | ===Sancak status ending between 1830 and 1840=== | ||
This query will return | 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) | SELECT ?sancak ?sancakLabel (YEAR(?starttime) as ?start) (YEAR(?endtime) as ?end) | ||
| Line 117: | Line 117: | ||
} | } | ||
ORDER BY (?endtime) | 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 == | ||