Hello Olaf,

this is a simple one. As it is common in natural language to present the world coordinates in order of [latitude, longitude], WKT standard, which is used to represent coordinates in the SPARQL endpoint, on the other hand, expects an order of [x, y], which in this case means [longitude, latitude].

For more info, see https://en.wikipedia.org/wiki/OGC_GeoSPARQL and https://stackoverflow.com/questions/18636564/lat-long-or-long-lat

So it is a desired behaviour, not a bug ;-)

Best regards,

Jan

On Mon, 2 Sep 2019 at 12:06, Olaf Simons <olaf.simons@pierre-marteau.com> wrote:

I am trying to synchronise FactGrid data with Wikidata.

A strange question: If I run a SPARQL search such as this one:

https://query.wikidata.org/#SELECT%20%3FGemeinde_in_Deutschland%20%3FGemeinde_in_DeutschlandLabel%20%3Fgeographische_Koordinaten%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3FGemeinde_in_Deutschland%20wdt%3AP31%20wd%3AQ262166.%0A%20%20OPTIONAL%20%7B%20%3FGemeinde_in_Deutschland%20wdt%3AP625%20%3Fgeographische_Koordinaten.%20%7D%0A%7D

I get the coordinates with what looks like swapped values:

"Point(10.7183 50.9489)" on the QueryService table output
"50°56'56"N, 10°43'6"E" on P625 at the respective Wikidata Item Q6986

any idea why this is so?

Best,
Olaf

Dr. Olaf Simons
Forschungszentrum Gotha der Universität Erfurt
Schloss Friedenstein, Pagenhaus
99867 Gotha

Büro: +49-361-737-1722
Mobil: +49-179-5196880

Privat: Hauptmarkt 17b/ 99867 Gotha

_______________________________________________
Wikidata mailing list
Wikidata@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata