query-2a0dee560579ca74235e0baadb1f20a7
Time out despite query restricted to tiny area this will cost zero roaming money. WikiShootMeI want to create a GPX file containing all places missing a Wikidata image. A GPX file can be used by smartphone map apps like OsmAnd without using the Internet, so unlike obviously times out, so I thought I would divide the world into small portions and query them one after the other: naive queryThe
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?item WHERE {
?item p:P625 ?statement .
?statement psv:P625 ?coordinate_node .
?coordinate_node wikibase:geoLatitude ?lat .
?coordinate_node wikibase:geoLongitude ?long .
FILTER (ABS(?lat - 48.8738) < 0.001)
FILTER (ABS(?long - 2.2950) < 0.001)
MINUS {?item wdt:P18 ?image}
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?coordinate_node")
v6("?image")
v3("?item"):::projected
v2("?lat")
v1("?long")
v4("?statement")
f0[["numeric-abs(?long - '2.2950^^xsd:decimal') < '0.001^^xsd:decimal'"]]
f0 --> v1
f1[["numeric-abs(?lat - '48.8738^^xsd:decimal') < '0.001^^xsd:decimal'"]]
f1 --> v2
v3 --"p:P625"--> v4
v4 --"p:statement/value/P625"--> v5
v5 --"wikibase:geoLatitude"--> v2
v5 --"wikibase:geoLongitude"--> v1
subgraph minus2["MINUS"]
style minus2 stroke-width:6px,fill:pink,stroke:red;
v3 --"p:direct/P18"--> v6
end