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(a)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/Wikipe…
for more detials.
Regards,
Neil