[Bug 59407] DBQ-147 Location Data (GPS coordinates)
https://bugzilla.wikimedia.org/show_bug.cgi?id=59407 --- Comment #1 from Bugzilla Bug Importer (valhallasw) --- --- From: Dispenser 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. -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 59407] DBQ-147 Location Data (GPS coordinates)
https://bugzilla.wikimedia.org/show_bug.cgi?id=59407 --- Comment #5 from Bugzilla Bug Importer (valhallasw) --- --- From: Jsncochran 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. -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 59407] DBQ-147 Location Data (GPS coordinates)
https://bugzilla.wikimedia.org/show_bug.cgi?id=59407 --- Comment #6 from Bugzilla Bug Importer (valhallasw) --- --- From: Dispenser 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` -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 59407] DBQ-147 Location Data (GPS coordinates)
https://bugzilla.wikimedia.org/show_bug.cgi?id=59407 Bugzilla Bug Importer (valhallasw) changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #7 from Bugzilla Bug Importer (valhallasw) --- 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: h...@online.de CC list: dispen...@toolserver.org, h...@online.de, wikimedia-bugzi...@dabpunkt.eu -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 59407] DBQ-147 Location Data (GPS coordinates)
https://bugzilla.wikimedia.org/show_bug.cgi?id=59407 --- Comment #4 from Bugzilla Bug Importer (valhallasw) --- --- From: Dispenser 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. -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 59407] DBQ-147 Location Data (GPS coordinates)
https://bugzilla.wikimedia.org/show_bug.cgi?id=59407 --- Comment #3 from Bugzilla Bug Importer (valhallasw) --- --- From: DaB. 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. -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 59407] DBQ-147 Location Data (GPS coordinates)
https://bugzilla.wikimedia.org/show_bug.cgi?id=59407 --- Comment #2 from Bugzilla Bug Importer (valhallasw) --- --- From: Jsncochran Date: Sat, 30 Jul 2011 18:44:42 --- Not sure what that means. Does the wiki world have this info? -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l