Loading the GeoNames

Note: The GeoNames geographical database covers all countries and contains over eleven million place names that are available for download free of charge.

The website offers online querying, and all the data is made available to download and use. As is often the case, it comes in an ad hoc format and requires some processing and normalization before it’s usable in a PostgreSQL database.