3 ms·
Entering locations is notoriously difficult. Country + City is probably the best you could do, where country could be re-used for US States.
by alkonaut 11y ago
Entering locations is notoriously difficult. Country + City is probably the best you could do, where country could be re-used for US States.
- thaumasiotes 11y agoEh, I think in cases of ambiguity you might be better off just sticking the state into the name of the city. Like "USA - New York City" vs "USA - Springfield (IL)".
- alkonaut 11y agoYes that works too - at least if you have a preset list of locations it's perfect. Country: USA City: Springfield (IL) If you don't have a db of cities to choose from you likely end up with cleaner data by sticking state to country since you could make a db for that with just some 100-200 entries. Country/State: US/Illinois, City: Springfield The original point is still there though, having a single location field breaks down quickly.