locality_postcodes_lookup

locality postcodes lookup

based off https://github.com/matthewproctor/australianpostcodes

Important Notice: There is absolutely no guarantees as to its accuracy, but please feel free to let us know of any fixes or updates you see. Source data is community generated from https://github.com/matthewproctor/australianpostcodes/blob/master/australian_postcodes.csv

Whats different:

1. id renamed to australianpostcodes_id
2. 4 new columns at the start: "id", "state_code", "latitude", "longitude"
3. Add a new line for the ‘health check record' like below:

id "_ _HEALTH CHECK"

state_code "" (blank)

latitude "0"

longitude "0"

australianpostcodes_id "" (blank)

postcode "" (blank)

locality "Health Check"

state "" (blank)

long "149.119"

lat "-35.2777"

1. Then in the fields below, use the following excel formula to build the new columns and drag down for all rows:

id =UPPER(TEXTJOIN("_",FALSE,H2,F2,G2)) (column join state, postcode, locality

state_code =H2 (column state)

latitude =J2 (column lat)

longitude =I2 (column long)

Alternative locations for data:

• https://www.abs.gov.au/statistics/standards/australian-statistical-geography-standard-asgs-edition-3/jul2021-jun2026/access-and-downloads/digital-boundary-files#downloads-for-gda2020-digital-boundary-files

• https://placenames.fsdf.org.au/

• (QLD Department Use only: https://github.com/qld-gov-au/PLSplus-QG-spec/ )