G-NAF Load

Scripts to create, load, and index an SQLite database with official Australian government Geocoded National Address File (G-NAF) data. This will result in a database file (gnaf-data/gnaf.db) of about 15GB.

Installation and load

Prerequisites

• A bash shell command line to run the load scripts.
• An installed SQLite runtime.
• A clone or download of this repository.

Prepare

• Fetch the G_NAF zipped data file and extract it into the gnaf-data/ directory.
• Edit the gnaf-import.sh script and change the variables in the 2 lines below as appropriate.

GNAF_PATH="gnaf-data/g-naf_nov24_allstates_gda2020_psv_1017/G-NAF"
GNAF_DATA_PATH="gnaf-data/g-naf_nov24_allstates_gda2020_psv_1017/G-NAF/G-NAF NOVEMBER 2024"

Run

• Run the edited script ./gnaf-import.sh. It will take about 30 minutes to complete.

References

• GeocodeEarth, Exploring G-NAF with SQLite