query-ce1cb67dd84e616ff7a9a7696b443a1f
Archaeological sites of all kinds in a lat/long box placing them in the British Isles
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
#defaultView:Map
SELECT ?label ?loc ?subj
WHERE
{
?subj wdt:P31/wdt:P279* wd:Q839954 ; # site or subtype
wdt:P625 ?loc ; # location to plot on map
p:P625/psv:P625 ?coord; # coordinate-location statement
rdfs:label ?label filter (lang(?label) = "en").
?coord wikibase:geoLatitude ?lat .
?coord wikibase:geoLongitude ?long .
FILTER (?lat > 49) FILTER (?lat < 63)
FILTER (?long > -10.5) FILTER (?long < 2.02)
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v6("?coord")
v3("?label"):::projected
v2("?lat")
v5("?loc"):::projected
v1("?long")
v4("?subj"):::projected
a1((" "))
a2((" "))
c8(["wd:Q839954"]):::iri
f0[["?long < '2.02^^xsd:decimal'"]]
f0 --> v1
f1[["?long > '-10.5^^xsd:decimal'"]]
f1 --> v1
f2[["?lat < '63^^xsd:integer'"]]
f2 --> v2
f3[["?lat > '49^^xsd:integer'"]]
f3 --> v2
f4[["?label = 'en'"]]
f4 --> v3
v4 --"p:direct/P31"--> a1
a1 --"p:direct/P279"--> c8
v4 --"p:direct/P625"--> v5
v4 --"p:P625"--> a2
a2 --"p:statement/value/P625"--> v6
v4 --"rdfs:label"--> v3
v6 --"wikibase:geoLatitude"--> v2
v6 --"wikibase:geoLongitude"--> v1