I needed to geocode around 20 million addresses. Normally I could just pay geocod.io to do this for me, but because of the contractual confidentiality requirements around these addresses, it had to be done offline. So I went hunting for an offline geocoder and decided to go with Nominatim, though a blog post I found after I had mostly completed the install suggested that there may be better options: according to this helpful blog, Nominatim is most accurate within the range of addresses it geocodes, but it doesn’t geocode many addresses.
I built Nominatim 3.2.0 on my Ubuntu 18.04 system following these instructions. I didn’t intend to install Nominatim on a fresh system, but since I accidentally wiped out my old OS remotely (oops), that is what happened.
Modifications to installation procedure
The tutorial is quite good, but there are a few things that I had to figure out and/or do differently:
- It wasn’t totally obvious when to switch over to nominatim user, but it seems clear that the import should be done while logged in to that account.
- Also had to set a password with
sudo passwd nominatimbefore I could log into the account to install
- The Apache configuration instructions are a little premature, need to actually install Nominatim first
- I installed osmium to merge files (
sudo apt-get install osmium-tool)
- `osmium merge file1.pbf file2.pbf file3.pbf…
- Modified the code to set up the Apache webserver to point to the correct Nominatim directory
- Skipped special key phrases
- Note that TIGER setup script (and some other scripts) need to be run from within the
- Did not install any update capability (I want a static db)
Also, a useful hint: If you screw up the database import or just want to redo it, you can drop the database using
My server has 24 cores, 128GB memory, and a 500GB SSD. These are the settings in
/etc/postgresql/10/main/postgresql.conf that I used:
shared_buffers (4GB) maintenance_work_mem (16GB) work_mem (50MB) effective_cache_size (24GB) synchronous_commit = off checkpoint_timeout = 10min checkpoint_completion_target = 0.9 fsync (off) -- (for import only, then set to on) full_page_writes (off) -- (for import only, then set to on)
Script to call Nominatim (python)
The underlying address data (and Nominatim itself) is not perfect. To try to account for possible missing responses, I resend queries as necessary until some response is obtained. The script I use in python and uses geopy, pointed at my local Nominatim install.
Note that Nominatim will return no result if it has an excess of information. For example, 729 Oneida Pl., Madison WI 53713 returns no result (bad ZIP), but 729 Oneida Pl., Madison WI works. Search hierarchy:
- NUMBER, ADDRESS, CITY, STATE, ZIP
- NUMBER, ADDRESS, ZIP
- NUMBER, ADDRESS, CITY, STATE
- CITY, STATE
Note also that if you feed it a bad number (e.g., 600 Oneida Pl., Madison WI 53711, which does not exist) it will pick the centroid of the street.