city profiles should show a geographic aggregation level in between it and its country

[melteng]

Ex. "Gary," Indiana where apparently the Jackson 5 came from.

The page title (in the tab) should say Gary, Indiana (like on wikipedia).

Where is says "United States" underneath the big "Gary" profile title, it should say "Indiana, United States."

[alexandersimoes]

I definitely agree, but this would require some extra data from @crisjf as well as a slightly altered database structure. Currently there is no concept of a "state level" geography. @melteng were you imagining this only for US cities? Or in the case of cities outside the US supporting the province or other mid-geographic component? For example, would the Belo Horizonte page say "Belo Horizonte, Minas Gerais, Brazil"?

[crisjf]

Getting this data for US cities is relatively easy, but as @alexandersimoes mentions, it would involve altering the database structure. How important is this?

[crisjf]

Maybe we can do it only for the US, since most of the characters are American born anyways?

[alexandersimoes]

If you can send me a new cities.tsv file with a display_name or long_name field that would have "Chicago, Illinois" I can use that in the profile in some places.

Also, would it be possible to get the wikipedia URL slugs that they use as another field in that file?

If you update that file please annotate the wiki as well 😄 - https://github.com/MacroConnections/pantheon2/wiki/Places

[melteng]

@alexandersimoes @crisjf Hmm I do think having provincial/state info is useful in larger countries, plus it'd avoid the user having to click out of the site to google the city name. But yeah for now, let's do the US first. Then we can look at the data and see what other large countries have a lot of representation and should include regions/provinces?