Joins city rankings from Natural Earth into OSM data with fuzzy matching.
- Create a PostGIS-enabled PostgreSQL database if you do not have one. By default this script assumes it is named 'osm'.
- Import the Natural Earth cities information included here. Eg:
psql -U postgres -f ne_cities.sql -d osm
- Import OSM places with Imposm if you have not already. These can be from a full planet dump, a regional extract, an Overpass API query...
- Make sure the Python package 'unidecode' is installed. Eg:
sudo pip install unidecode
python rank-places.py | psql -U <pg_user> <pg_database>