[wp-meta] [Making WordPress.org] #3728: Some city names shown incorrectly in Events API

[Making WordPress.org]

#3728: Some city names shown incorrectly in Events API
-------------------------+-------------------------
 Reporter:  Presskopp    |       Owner:  dryanpress
     Type:  defect       |      Status:  reopened
 Priority:  normal       |   Milestone:
Component:  Events API   |  Resolution:
 Keywords:  needs-patch  |
-------------------------+-------------------------

Comment (by dd32):

 It looks like this is no longer an encoding issue, but a data-source
 issue.

 > Gießen -> Giesen

 The data-source lists both of those as separate cities, Giesen having a
 much larger population and an alternate-name (not primary name) of Gießen.
 The co-ordinates are also slightly different (but quite obviously the same
 place) so it's really just an issue that the data had two cities that
 should've been combined.

 > Bad Gottleuba-Berggießhübel -> Bad

 That city doesn't exist in the data-set, nor does a city that starts with
 that, which is why it gets truncated back to `Bad` which is an alt-name
 for `Badou, Togo`.


 I think updating the source-data might help here, I don't think it's been
 updated in about 2 years.
 We don't use a proper GIS here, just a very bland lookup table that has
 ~750k city names for ~150k unique cities around the world, it 100% doesn't
 match every city the world has to offer (let alone even 80% of them) but
 it does include some obscure places such as `Grytviken` which has between
 2 and 30 people living there depending on the time of year.

-- 
Ticket URL: <https://meta.trac.wordpress.org/ticket/3728#comment:13>
Making WordPress.org <https://meta.trac.wordpress.org/>
Making WordPress.org