From: Dispenser <dispenser@toolserver.org>

Date: Fri, 29 Jul 2011 12:42:55

• ghel - Weekly updated MySQL dumps and designed to be JOINed against other (WMF) tables and a fast spacial search. Effectively a "raw" data set and the base for other repackaging efforts such as...
• Wikipedia-World - One large combined CSV file combining 40+ languages article (excluding inline coordinates?) and includes lots of metadata. Updated every 2-6 months.

From: Jsncochran <jsncochran@gmail.com>

Date: Sat, 30 Jul 2011 18:44:42

Not sure what that means. Does the wiki world have this info?

From: DaB. <dab@ts.wikimedia.org>

Date: Sat, 30 Jul 2011 18:52:53

It is not possible to get these data from a normale database-query, because this data is not stored. But you may be interrested at http://de.wikipedia.org/wiki/Wikipedia:WikiProjekt_Vorlagenauswertung/en where a user collected these data from database-dumps.

From: Dispenser <dispenser@toolserver.org>

Date: Fri, 05 Aug 2011 05:16:37

DaB, I actually maintain a database updated daily (dumps, working on hourly incremental updates), but I assume that the reporter wants a simple point cloud and is uninterested JOINing to categories, templates, or hyperlinks tables. To that extent Wikipedia-World (dump) would be sufficient for his needs.

From: Jsncochran <jsncochran@gmail.com>

Date: Fri, 05 Aug 2011 07:34:19

Hi Dispenser

Thanks for the comment. I went out to your website and downloaded the sql but can not import it into mysql because of file encoding issue.

From: Dispenser <dispenser@toolserver.org>

Date: Fri, 05 Aug 2011 15:39:41

I use a varbinary data type so we cannot have any database related encoding issues and we also check to make sure the byte sequence are valid UTF-8. I also successfully tested importing into a MySQL 5.1.53 database using the following command:

gunzip coord_enwiki.sql.gz -c | mysql --verbose -h sql-s2-user -D u_dispenser_test

This bug was imported as RESOLVED. The original assignee has therefore not been
set, and the original reporters/responders have not been added as CC, to
prevent bugspam.

If you re-open this bug, please consider adding these people to the CC list:
Original assignee: hoo@online.de
CC list: dispenser@toolserver.org, hoo@online.de, wikimedia-bugzilla@dabpunkt.eu