Perhaps of interest.
Pine
---------- Forwarded message ----------
From: Yuri Astrakhan <yuriastrakhan(a)gmail.com>
Date: Fri, May 12, 2017 at 9:03 AM
Subject: [OSM-talk] new Wikidata+OSM data in one RDF database
To: OpenStreetMap talk mailing list <talk(a)openstreetmap.org>
TLDR: A SPARQL (rdf) database with both OSM and Wikidata data is up for
testing. Allows massive cross-referenced queries between two datasets. The
service is a test, and needs a permanent home to stay alive.
Overpass Turbo is awesome, but sadly it does not have data from Wikidata,
nor does it support some SQL-like conditions. I have setup a temporary RDF
database that has both OSM & Wikidata. You can use SPARQL queries to find:
* All OSM objects with wikidata tag that references a Wikipedia
disambiguation page. Get the name of the page in first available language
ru, fr, de, en.
http://tinyurl.com/mzlfb26
* OSM relations with wikidata tag pointing to a person (also tries multiple
language fallbacks).
http://tinyurl.com/m6fh3wx
* OSM relations with duplicate Wikidata IDs
http://tinyurl.com/mvhhogx
== OSM data structure ==
osmnode, osmway, osmrel - OSM object prefix, e.g. osmnode:1234
osmt - tag, e.g. osmt:name:en (only has tags with latin chars, -, _, :,
digits
osmm - meta data about the object -- type, isClosed, version.
I try to preserve OSM data without much changes. Every tag's value is
stored as a string, except for wikidata and wikipedia tags which are
converted to a URL, the same format as stored in Wikidata.
osmway:29453885
osmt:name "Samina";
osmt:waterway "river";
osmt:wikidata wd:Q156065;
osmt:wikipedia <https://de.wikipedia.org/wiki/Samina>;
osmm:type "w"; #### could be "r", "w", and
"n"
osmm:isClosed false; #### this meta property is only for OSM ways
osmm:version 24.
Wikidata data structure is identical to
https://query.wikidata.org (see
help)
== Current limitations ==
* Only includes OSM objects with either "wikidata" or "wikipedia"
tags
* The OSM data only contains tags with only Latin letters, digits and
symbols - : _
* OSM geometry info is not imported, e.g. no center point or bounding box,
except for osmm:isClosed (true/false) property for ways.
* Does not include OSM object inheritance data - e.g. cannot query for
"find a node that is part of a way which is part of a relation that has
wikidata tag that ..."
* Wikidata is updated every second, but OSM does not yet update at all,
imported from a full db dump as of a few days ago.
_______________________________________________
talk mailing list
talk(a)openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk