Skip to content

Preprocessing US Census TIGER data for Nominatim geocoder

License

Notifications You must be signed in to change notification settings

GROUP-Bank-eu/TIGER-data

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

US TIGER address data for Nominatim

Convert TIGER/Line dataset of the US Census Bureau to SQL files which can be imported by Nominatim. In Nominatim the created tables are separate from OpenStreetMap tables and get queried at search time separately.

The dataset gets updated once per year. Downloading is prone to be slow (can take a full day) and converting them can take hours as well. There's a mirror on https://downloads.opencagedata.com/public/

Replace '2020' with the current year throughout.

  1. Install the GDAL library and python bindings and the unzip tool

    Ubuntu:

    sudo apt-get install python3-gdal unzip pip3 install ogr

  2. Get the TIGER 2020 data. You will need the EDGES files (3,234 zip files, 11GB total).

    wget -r ftp://ftp2.census.gov/geo/tiger/TIGER2020/EDGES/
    
  3. Convert the data into SQL statements. Adjust the file paths in the scripts as needed

    ./convert.sh

  4. Maybe: package the created files

    tar -czf tiger2020-nominatim-preprocessed.tar.gz tiger

License

The source code is available under a GPLv2 license.

About

Preprocessing US Census TIGER data for Nominatim geocoder

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Python 96.4%
  • Shell 3.6%