This might be then the central thing to have in the next QueryService Version: In addition to the present download formats an option to get a csv or tsv output that can be put into QuickStatements for another Wikibase without tedious conversions.
We will have more and more people with Wikibase installations who will use Wikidata (or other Wikibases) as data source for their platforms. Maybe I can inspire Magnus... Thanks, Olaf > Eugene Alvin Villar <[email protected]> hat am 2. September 2019 um 17:56 > geschrieben: > > > On Mon, Sep 2, 2019, 11:39 PM Olaf Simons, <[email protected]> > wrote: > > > 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...) > > > > Depends on how elegant you want it to be but it won't be trivial. If you > want to get data from WDQS, you can use any of the available SPARQL > text/regex manipulation functions to convert the WKT format into a > different format. > > 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? > > > > Again, this is not trivial. You need to also query the datePrecision field > of the date value and that means querying for the actual date statement and > not just the simple value that the usual SPARQL queries provide. Then based > on the datePrecision value (I think 9 is for year precision vs. 11 for day > precision), you can then truncate the date to just the year. > > > > _______________________________________________ > 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
