Thank you Jan for the swift answer (I wish I had known before this morning's first data input...)
allow me 2 follow-up questions: Is there an elegant way to get data out of wikidata in a format that you can then fill back into another Wikibase without the pain of such conversions (like splitting coordinates, changing columns, changing the prefixes...) Question 2 is related: When you extract dates with the QueryService that will change just years like 1971 from 1971-00-00 into 1971-01-01 dates. I felt unable to tell whether such a date was just a year or actually a January 1 entry. Is there a way to get the exact date as it has been put in to Wikibase back from the QueryService? All my thanks, Olaf > Jan Macura <[email protected]> hat am 2. September 2019 um 12:20 > geschrieben: > > > 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 > <https://en.wikipedia.org/wiki/Well-known_text_representation_of_geometry>, > 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 <[email protected]> > 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 > > [email protected] > > https://lists.wikimedia.org/mailman/listinfo/wikidata > > > _______________________________________________ > Wikidata mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/wikidata 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 [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata
