1015512 - events service not returning dupe, null, or empty country/city data

Status: RESOLVED WONTFIX

(Webmaker Graveyard :: Events, defect)

Description

[William Duyck [:fuzzyfox]]

The events api is not returning the location of events correctly city + country are undefined.

Maybe we should run a 1 time pass w/ a reverse geocoder to get this information, as it helps produce pretty stats we want for a makerparty live infographic.

Example of possible output:
* https://pastebin.mozilla.org/5222440

// data set limited down as I don't want to run ~1857 reverse geocodes repeatedly while testing.

Comment 1

[William Duyck [:fuzzyfox]]

Update: looks like we also need to cleanup some of the data already set for these things:

https://pastebin.mozilla.org/5222749

Source = more compelete/realistic data based on current possibilities

Comment 2

[William Duyck [:fuzzyfox]]

Just a quick update that this problem still seems to be the case when refining the search down to more recent data (since april) https://pastebin.mozilla.org/5271550

Comment 3

[William Duyck [:fuzzyfox]]

Dupe: country stored w/ single char difference maybe? But when comparing against itself (i.e. Côte d’Ivoire and Côte d'Ivoire)

Comment 4

[William Duyck [:fuzzyfox]]

Attachment: cleandata.json

Comment 5

[William Duyck [:fuzzyfox]]

Attachment: cleandata.csv

Comment 6

[William Duyck [:fuzzyfox]]

Right I've taken the time to run our data (using lat,lng) against a geocoder and have generated the attached dataset to be merged w/ our own.

Its in both JSON (w/ all other publicly available event data), and CSV w/ only the new country data.

Comment 7

[Brett Gaylor [:brett]]

Can we decide on this for next train?

Comment 8

[Matt Thompson (@OpenMatt :OpenMatt)]

* Is this still needed? Fuzzy, this ticket has been kicking around a while -- please update?