query-8891975637030d69a7c694e5bb7ba7d5
Can I query items that their geolocation is in a given polygon ?Is there a way to query over a polygon area and not a bounding box or a radius? 16:21, 14 August 2020 (UTC)) talk (Bouzinac), I encounter a timeout, could you help improving that query ? logs • contribs • talk (Dipsacus fullonum and run this query... Re (Q4115189)Wikidata Sandbox 1 to (P1335)coordinates of westernmost point (P1334)coordinates of easternmost point (P1333)coordinates of southernmost point (P1332)coordinates of northernmost point Hello there, I think there could be a workaround. Input your polygon data into 18:05, 13 August 2020 (UTC)) talk (Dipsacus fullonum: Not to my knowledge, but you can make outer bounding box or outer cicle around the polygon, and then check every found point if it is in the polygon. --Tazary4@
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:Q4115189 } . #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:Q4115189"])
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