Keep only cities, states, and countries with media

[bruvellu]

I was revising our translation pipeline and ran into an issue—the large number of cities in our database.

City names are currently translatable fields (New York, Nova Iorque) and these translatable model fields are synchronized with the locale PO files from time to time. With that many cities, this synchronization process takes very long.

That made me wonder, do we even need all these cities? Most will never have any media associated with them. It's just bloat to the database, making location queries slower.

We have all the Brazilian cities in the database for the metadata to be filled without mistakes. That works, but perhaps there's a better way?

There are probably libraries that provide this information. The metadata form can fetch this information dynamically and autocomplete. I'll compile the options here to see which might work best for our use case.

• https://github.com/ipeaGIT/geobr (Brazilian detailed data)
• https://github.com/geopy/geopy (general geocode data)
• https://github.com/somnathrakshit/geograpy3 (more of a location extractor)
• https://github.com/symerio/pgeocode (general geocode data)
• https://github.com/DinoTools/python-overpy (wrapper for OSM Overpass API)
• https://github.com/yaph/geonamescache (data from GeoNames)

Meanwhile, I'll just disable translations for cities, for now.

[bruvellu]

I'll keep this issue open as an improvement for the future