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 <seav80(a)gmail.com> hat am 2.
September 2019 um 17:56 geschrieben:
On Mon, Sep 2, 2019, 11:39 PM Olaf Simons, <olaf.simons(a)pierre-marteau.com>
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
Wikidata(a)lists.wikimedia.org
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