Neil,
I've been taking a look at toolserver and it looks really helpful. Thanks.
I have even downloaded a dump. There is only one table(wp_coords_red0) with a page_id field. But this page_id does not match the id field in the wikipedia database.
I have no idea how to join kolossos table with the page table on wikipedia. Is that even possible?
On 14/03/2012 19:45, Neil Harris wrote:
On 14/03/12 14:26, toni hernández wrote:
Hi all,
I have beem loooking at the wikipedia database scheme and I haven't found any field that suggest that some contents are geographical located. Am I wrong?
If it is possible I would like to download the geographical located contents of Wikipedia to do something similar to what googleearth does with the wikipedia layer Is that possible?
Thanks in advanced.
Xmldatadumps-l mailing list Xmldatadumps-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/xmldatadumps-l
Hi Toni,
The geographical locations are stored in the article text, using templates, and not (yet) available in the main database, although I believe there is long term work planned to remedy this.
However, there is a project that parses and consolidates all this data across all wikipedia languages. The simplest way to get this data is to get a toolserver account, and to access the kolossus database on the Wikipedia Toolserver. See http://de.wikipedia.org/wiki/Wikipedia:WikiProjekt_Georeferenzierung/Wikiped... for more detials.
Regards,
Neil