query-ac0b0d26e24188f8cb3618881ea9edb8

rq turtle/ttl

Discussion Request process 23:54, 13 October 2017 (UTC)) talk (Pasleim the remaining items have actually no precision set but the query service assigns the arbitrary precision of 1/3600. -- Done18:49, 16 October 2017 (UTC)) talk (Jarekt , This is great. Thank you. Any chance with no precision set can be changed to prec =1 degree? Also below I have query for finding items that should have their precision increased to an arcminute. Any chance you can tackle that challenge. I found some cases where coordinates imported from different Wikipedias differed only by precision and fixing it made them identical. That might be a subject of a new query and bot job, but eventually such coordinates should be merged. --Pasleim

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?coord ?prec
WHERE
{
 ?item p:P625 ?coordinate.
 ?coordinate ps:P625 ?coord.
 ?coordinate psv:P625 ?coordinate_node.
 ?coordinate_node wikibase:geoLongitude ?lon.
 ?coordinate_node wikibase:geoLatitude ?lat.  
 ?coordinate_node wikibase:geoPrecision ?prec.  
 FILTER (?lat=ROUND(?lat*60)/60) . # latitude  with 1 minute precision
 FILTER (?lon=ROUND(?lon*60)/60) . # longitude with 1 minute precision
 FILTER (?prec<1/60) .         # measurement precision less then one arcminute
 SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } 
} limit 5000

Query found at

• https://www.wikidata.org/wiki/Wikidata:Bot_requests/Archive/2017/10