[OSM-talk] new Wikidata+OSM data in one RDF database

[Oleksiy Muzalyev]

Dear Rob and Yuri,

I have read your messages with great interest. I hope this work will 
lead eventually to a Wikipedia articles multi-language layer on the OSM 
map, to the navigation apps which are capable not only tell where to 
turn but also about places of interest and historical events one drives 
or walks by. Often it is not necessary to travel thousands of kilometers 
to see something interesting, a lot of amazing places are close to us.

I wrote a web-application which allows to locate Wikipedia articles with 
geographical coordinates in a selected language (or wikidata tags): 
http://ausleuchtung.ch/geo_wiki/ . It is based on the MediaWiki Api and 
the Overpass Api. Certainly, having a single united database would allow 
queries which are hard to imagine yet.

In my opinion the multi-language capabilities are essential for such 
OSM&Wikipedia tools. A lot of absolutely interesting articles with 
geographical coordinates exist only in one language [1]. Fortunately 
Wikipedia community subscribes to the idea that the true international 
language is translation, and there are Wikipedia tools to translate an 
article in any supported language relatively easily.

Please, keep me informed of further development of your projects.

[1] https://fr.wikipedia.org/wiki/Fort_du_Risoux
https://fr.wikipedia.org/wiki/Tuilerie_romaine_des_Bois_de_Chancy
etc.

Thank you and best regards,
Oleksiy

On 14.05.2017 20:10, Rob H Warren wrote:
> Yuri,
>
> There is a plan afoot to do something similar with the geometries from www.openhistoricalmap.org; let's keep in touch, I would really like to enable linkages across datasets.
>
> Keep up the good work! -rhw
>
>
>> On May 13, 2017, at 8:00 AM, talk-request at openstreetmap.org wrote:
>>
>>
>> Message: 1
>> Date: Fri, 12 May 2017 16:03:52 +0000
>> From: Yuri Astrakhan <yuriastrakhan at gmail.com>
>> To: OpenStreetMap talk mailing list <talk at openstreetmap.org>
>> Subject: [OSM-talk] new Wikidata+OSM data in one RDF database
>> Message-ID:
>> 	<CAJGfNe-tTkYs1zxA2n6w=awbSLE32gC86K=KSPMxcnLWjGVpMg at mail.gmail.com>
>> Content-Type: text/plain; charset="utf-8"
>>
>> 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 at openstreetmap.org
> https://lists.openstreetmap.org/listinfo/talk