query-9bb46f4e73568309e101cd5f1acac3a5
Elements that are inside a rectangle (East/West/North/South)
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 psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
#defaultView:Map
SELECT ?item ?country ?coord {
VALUES ?country { wd:Q258 } . #select a country here, works also with any item having east, west, south and north bounds
?country p:P1332 [ ps:P1332 ?north; psv:P1332 ?nValue ];
p:P1333 [ ps:P1333 ?south; psv:P1333 ?sValue ];
p:P1334 [ ps:P1334 ?east; psv:P1334 ?eValue ];
p:P1335 [ ps:P1335 ?west; psv:P1335 ?wValue ].
?nValue wikibase:geoLatitude ?nLat .
?sValue wikibase:geoLatitude ?sLat .
?eValue wikibase:geoLongitude ?eLon .
?wValue wikibase:geoLongitude ?wLon .
?item p:P625 [ a wikibase:BestRank; ps:P625 ?coord; psv:P625 ?cValue ] .
?cValue wikibase:geoLatitude ?lat .
?cValue wikibase:geoLongitude ?lon .
?cValue wikibase:geoGlobe ?globe .
BIND(COALESCE(?globe,wd:Q2) as ?Globe)
FILTER (?Globe =wd:Q2) #select only Earth-like coordinates
MINUS { ?item wdt:P17 [] } . #has the item any P17 value ?
MINUS { ?item (wdt:P31/wdt:P279*) wd:Q4830453. } # exclude ENTREPRISES
MINUS { ?item (wdt:P31/wdt:P279*) wd:Q15893266. } # exclude old entities
MINUS { ?item wdt:P576 _:b2. } # remove items with P576 (dissolved, abolished or demolished) as a main property
FILTER( ?sLat < ?lat && ?lat < ?nLat ) . #modify here to
FILTER( ?wLon < ?lon && ?lon < ?eLon ) .
} limit 100
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v21("?Globe")
v18("?cValue")
v17("?coord"):::projected
v8("?country"):::projected
v3("?eLon")
v14("?eValue")
v13("?east")
v20("?globe")
v19("?item"):::projected
v5("?lat")
v2("?lon")
v6("?nLat")
v10("?nValue")
v9("?north")
v4("?sLat")
v12("?sValue")
v11("?south")
v1("?wLon")
v16("?wValue")
v15("?west")
a1((" "))
a2((" "))
a3((" "))
a4((" "))
a5((" "))
a7((" "))
a8((" "))
a6((" "))
a9((" "))
c26(["wd:Q15893266"]):::iri
c25(["wd:Q4830453"]):::iri
c17(["wikibase:BestRank"]):::iri
f0[["?wLon < ?lon?lon < ?eLon"]]
f0 --> v1
f0 --> v2
f0 --> v3
f1[["?sLat < ?lat?lat < ?nLat"]]
f1 --> v4
f1 --> v5
f1 --> v6
f2[["?Globe = 'wd:Q2'"]]
f2 --> v21
bind3[/VALUES ?country/]
bind3-->v8
bind30(["wd:Q258"])
bind30 --> bind3
a1 --"p:statement/P1332"--> v9
a1 --"p:statement/value/P1332"--> v10
v8 --"p:P1332"--> a1
a2 --"p:statement/P1333"--> v11
a2 --"p:statement/value/P1333"--> v12
v8 --"p:P1333"--> a2
a3 --"p:statement/P1334"--> v13
a3 --"p:statement/value/P1334"--> v14
v8 --"p:P1334"--> a3
a4 --"p:statement/P1335"--> v15
a4 --"p:statement/value/P1335"--> v16
v8 --"p:P1335"--> a4
v10 --"wikibase:geoLatitude"--> v6
v12 --"wikibase:geoLatitude"--> v4
v14 --"wikibase:geoLongitude"--> v3
v16 --"wikibase:geoLongitude"--> v1
a5 --"a"--> c17
a5 --"p:statement/P625"--> v17
a5 --"p:statement/value/P625"--> v18
v19 --"p:P625"--> a5
v18 --"wikibase:geoLatitude"--> v5
v18 --"wikibase:geoLongitude"--> v2
v18 --"wikibase:geoGlobe"--> v20
bind4[/"?globe'wd:Q2'"/]
v20 --o bind4
bind4 --as--o v21
subgraph minus5["MINUS"]
style minus5 stroke-width:6px,fill:pink,stroke:red;
v19 --"p:direct/P17"--> a6
end
subgraph minus6["MINUS"]
style minus6 stroke-width:6px,fill:pink,stroke:red;
v19 --"p:direct/P31"--> a7
a7 --"p:direct/P279"--> c25
end
subgraph minus7["MINUS"]
style minus7 stroke-width:6px,fill:pink,stroke:red;
v19 --"p:direct/P31"--> a8
a8 --"p:direct/P279"--> c26
end
subgraph minus8["MINUS"]
style minus8 stroke-width:6px,fill:pink,stroke:red;
v19 --"p:direct/P576"--> a9
end