| Jheald added a comment. |
Example query (view in query editor):
SELECT ?int_lon ?int_lat (COUNT(?item) AS ?count) WHERE {
?item wdt:P3616 [].
?item p:P625/psv:P625 ?coords .
?coords wikibase:geoLatitude ?lat .
?coords wikibase:geoLongitude ?long .
BIND(floor(?lat) AS ?int_lat) .
BIND(floor(?long) AS ?int_lon) .
FILTER(?int_lon < 5)
} GROUP BY ?int_lat ?int_lon
ORDER BY DESC (?count)Switching to scatterplot display, the points plotted bear little relation to the values that were in the columns.
Mousing over the points, one gets triples like:
`int_lon: -5, int_lon: -45, int lat: 267` (plotted at -45, 267)
The first value of the triple may be correct, but is being ignored. Goodness knows where the second value is coming from. And -- while of similar size to some of the counts -- comparison shows that the third value does not match any of the counts in the third column.
TASK DETAIL
EMAIL PREFERENCES
To: Jheald
Cc: Aklapper, Jheald, EBjune, merbst, Avner, debt, Gehel, D3r1ck01, Jonas, FloNight, Xmlizer, Izno, jkroll, Smalyshev, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, Mbch331
Cc: Aklapper, Jheald, EBjune, merbst, Avner, debt, Gehel, D3r1ck01, Jonas, FloNight, Xmlizer, Izno, jkroll, Smalyshev, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, Mbch331
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
