[Bug 59407] DBQ-147 Location Data (GPS coordinates)

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59407

--- Comment #2 from Bugzilla Bug Importer (valhallasw) 
wmf.bugconver...@gmail.com ---
---
From: Jsncochran jsncoch...@gmail.com
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


[Bug 59407] DBQ-147 Location Data (GPS coordinates)

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59407

--- Comment #4 from Bugzilla Bug Importer (valhallasw) 
wmf.bugconver...@gmail.com ---
---
From: Dispenser dispen...@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.

-- 
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)

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59407

--- Comment #3 from Bugzilla Bug Importer (valhallasw) 
wmf.bugconver...@gmail.com ---
---
From: DaB. d...@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.

-- 
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)

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59407

--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
wmf.bugconver...@gmail.com ---
---
From: Dispenser dispen...@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.

-- 
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)

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59407

--- Comment #5 from Bugzilla Bug Importer (valhallasw) 
wmf.bugconver...@gmail.com ---
---
From: Jsncochran jsncoch...@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.

-- 
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)

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59407

--- Comment #6 from Bugzilla Bug Importer (valhallasw) 
wmf.bugconver...@gmail.com ---
---
From: Dispenser dispen...@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`

-- 
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)

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59407

Bugzilla Bug Importer (valhallasw) wmf.bugconver...@gmail.com changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |FIXED

--- Comment #7 from Bugzilla Bug Importer (valhallasw) 
wmf.bugconver...@gmail.com ---

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