query-ced70da7b38f514842f399aabd041e5e
Correct coordinate location precision Jarekt: Request date: 9 October 2017, byTask descriptionMany coordinate locations on Wikidata have incorrectly set "precision" parameter. The query below finds ~2000 items where latitude and longitude are integers (measured in degrees) while precision is set to a value less than a degree. Those locations should change the "precision" setting to +-1 degree. Latter we could do similar runs for precissions +- 1 arcminute, etc. Correct coordinate location precisionMany coordinate locations on Wikidata have incorrectly set "precision" parameter. The query below finds ~2000 items where latitude and longitude are integers (measured in degrees) while precision is set to a value less than a degree. Those locations should change the "precision" setting to +-1 degree. Latter we could do similar runs for precissions +- 1 arcminute, etc.
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
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/>
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)) . # integer latitude (in degrees)
FILTER (?lon=ROUND(?lon)) . # integer longitude (in degrees)
FILTER (?prec<1) . # measurement precision less then one degree
MINUS {?item p:P31 wd:Q146591} # not a circle of latitude
MINUS {?item p:P31 wd:Q32099 } # not a meridian
MINUS {?item p:P31 wd:Q17272482 } # not a time zone
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Query found at
- https://www.wikidata.org/wiki/User:Jarekt/queries
- https://www.wikidata.org/wiki/Wikidata:Bot_requests/Archive/2017/10