New table in worldCities

Starting with this update, we’ll include a new table in the worldCities database, which will make it much more easy to use for most cases.

In short, that new table (called “flatfile”) contains the most used columns and pieces of data from all of the other tables in worldCities, which will allow you to write much more simple SQL queries.

Specifically, it contains:

  • the countries and all included administrative divisions (in columns with labels beginning with “adm1” to “adm4”), as well as the individual populated places (cities, towns, villages, etc…)
  • all names in English when available, or else in their official local language(s)
  • IDs (feature_id) are included for each and every pieces of data, be it country, administrative division or populated place, so it’s very easy to link it any other table for more detailed data, whether in the main worldCities database or in any of the worldCities Extensions

Since it is easier to work with short codes than with undescriptive integer ID, we also now include for free 2- or 3-character codes for the countries and all levels of administrative divisions. More codes are still available in the Standard Codes extension.