Last modified: 2014-01-03 16:03:57 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-147. Summary: Location Data (GPS coordinates) Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: Hoo man <hoo@online.de> ------------------------------------------------------------------------------- From: Jsncochran <jsncochran@gmail.com> Date: Thu, 28 Jul 2011 22:50:47 ------------------------------------------------------------------------------- I am working for a client who is trying to develop an app that holds all the coordinate locations within wiki. Here is a link to what I am looking for (http://en.wikipedia.org/wiki/Atlanta,ga). Top right corner displays the GPS coordinates. I would like to get a list of all GPS coordinates within wiki and possibly the articles as well.Is this doable?
------------------------------------------------------------------------------- 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