[zschuessler]

This is really neat. Well done on the UX and functionality.

I saw others already mentioned uniqueness of city names. In the US there is no guarantee a state, zip code, or even county won't have a duplicate city name. To solve this one must store the lat/lng coordinates instead. Then offer users a search list of matched cities, so they can select the right geographic location.

Good stuff - cheers!

[sirobg]

> This is really neat. Well done on the UX and functionality.

Thank you very much!

> To solve this one must store the lat/lng coordinates instead. Then offer users a search list of matched cities, so they can select the right geographic location.

I ended up doing this! Migrated all user and city data over to this new paradigm.