Page MenuHomePhabricator

Too many values for wikibase:geoLatitude and wikibase:geoLongitude in WDQS
Closed, ResolvedPublic

Description

Wikidata item Q288 (Tours in France) have 1 value for P625 (coordinates): https://www.wikidata.org/wiki/Q288#P625

But in this WDQS query:

SELECT ?item ?coordinate ?coordinate_node ?latitude ?longitude WHERE
{
  VALUES ?item { wd:Q288 }
  ?item p:P625 ?coordinate.
  ?coordinate psv:P625 ?coordinate_node.
  ?coordinate_node wikibase:geoLatitude ?latitude. 
  ?coordinate_node wikibase:geoLongitude ?longitude.
}

Link: https://query.wikidata.org/#%20%20SELECT%20%3Fitem%20%3Fcoordinate%20%3Fcoordinate_node%20%3Flatitude%20%3Flongitude%20WHERE%0A%20%20%7B%0A%20%20%20%20VALUES%20%3Fitem%20%7B%20wd%3AQ288%20%7D%0A%20%20%20%20%3Fitem%20p%3AP625%20%3Fcoordinate.%0A%20%20%20%20%3Fcoordinate%20psv%3AP625%20%3Fcoordinate_node.%0A%20%20%20%20%3Fcoordinate_node%20wikibase%3AgeoLatitude%20%3Flatitude.%20%0A%20%20%20%20%3Fcoordinate_node%20wikibase%3AgeoLongitude%20%3Flongitude.%0A%20%20%7D%0A

you get results for ?latitude and ?longitude with both unrounded values (47.392777777778, 0.68833333333333) and values rounded to 4 decimals (47.3928, 0.6883), combined for a total of 4 results. There should only be 1 result.

Event Timeline

This is due to T174504 (see especially T174504#5534713) and should be resolved with the next full WDQS reload, which will hopefully happen soon (cf. T230588#5534626).

Gehel claimed this task.
Gehel subscribed.

This has been fixed by the latest WDQS data reload (T252068).