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, [email protected] wrote:
Message: 1
Date: Fri, 12 May 2017 16:03:52 +0000
From: Yuri Astrakhan <[email protected]>
To: OpenStreetMap talk mailing list <[email protected]>
Subject: [OSM-talk] new Wikidata+OSM data in one RDF database
Message-ID:
<CAJGfNe-tTkYs1zxA2n6w=awbSLE32gC86K=kspmxcnlwjgv...@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
[email protected]
https://lists.openstreetmap.org/listinfo/talk
_______________________________________________
talk mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/talk
