[OSM-talk] POIs from wikipedia

[Robin Paulson]

On 08/01/2008, Robin Paulson <robin.paulson at gmail.com> wrote:
> while i was looking up some info on wikipedia [1], i noticed that a
> lot of pages have a lat/lon value to describe their location; this
> strikes me as something we could use to increase the amount of data in
> OSM
>
> it would require a mass download of data from all the pages that
> contain these values, matching to relevant tags and importing into
> OSM.
>
> dos anyone here have the experience to query the wikipedia db in a way
> that could pull out just those pages with location info?
>
> [1] http://en.wikipedia.org/wiki/Southdown_Train_Station

bad i know, but replying to my own mail:

http://de.wikipedia.org/wiki/Wikipedia:WikiProjekt_Georeferenzierung/Wikipedia-World/en

has a database of all georeferenced POIs in SQL format

i realise a lot of these will be in OSM already, so there would need
to be some cross-referencing/filtering to prevent duplication

suggestions, comments? has this been done already?