Hi Olaf
https://databus.dbpedia.org/dbpedia/wikidata/geo-coordinates/2019.08.01
has monthly (around the 7th) extractions of Wikidata's geo-coordinates.
The website still has a bug and the download links are currently not
displayed any more at the bottom. But you can query for the latest version.
https://databus.dbpedia.org/yasgui/
PREFIX dataid: <http://dataid.dbpedia.org/ns/core#>
PREFIX dct: <http://purl.org/dc/terms/>
PREFIX dcat: <http://www.w3.org/ns/dcat#>
SELECT ?downloadURL ?sha256sum WHERE {
?dataset dataid:artifact
<https://databus.dbpedia.org/dbpedia/wikidata/geo-coordinates> .
?dataset dcat:distribution/dcat:downloadURL ?downloadURL .
?dataset dcat:distribution/dataid:sha256sum ?sha256sum .
?dataset dct:hasVersion ?version .
} ORDER BY DESC (?version) LIMIT 1
-- Sebastian
On 02.09.19 17:56, Eugene Alvin Villar wrote:
On Mon, Sep 2, 2019, 11:39 PM Olaf Simons,
<olaf.sim...@pierre-marteau.com
<mailto:olaf.sim...@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@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata
--
All the best,
Sebastian Hellmann
Director of Knowledge Integration and Linked Data Technologies (KILT)
Competence Center
at the Institute for Applied Informatics (InfAI) at Leipzig University
Executive Director of the DBpedia Association
Projects: http://dbpedia.org, http://nlp2rdf.org,
http://linguistics.okfn.org, https://www.w3.org/community/ld4lt
<http://www.w3.org/community/ld4lt>
Homepage: http://aksw.org/SebastianHellmann
Research Group: http://aksw.org
_______________________________________________
Wikidata mailing list
Wikidata@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata