I just did some minor updates to this repository and added a PHP import script.

Australian Post Codes

A community sourced comprehensive database of Australian Post Codes with geolocation data.

How it started

Some years ago, Australia Post used to publish a full list of Australian Postal Codes including state and location data, in a raw data format, completely free.

They have since stopped doing this, instead preferring to charge for data that is arguably public domain, or at least available publicly in many different forms from many different providers.

I've needed this data for a number of projects over the years, and have collated as much publicly-available postal data as I could find. There are a bunch of files out on the internet with this data, but they are all missing data or detail, so I've tried to collate them as best I can.

You can learn more about this at http://www.matthewproctor.com/australian_postcodes

Data Files

The postcode data files are stored as CSV, and available on my site in XLS, XLSX and other formats. Column definitions are shown below.

Fieldname	Description
postcode	The postcode in numerical format - 0000 to 9999 3000
locality	The locality of the postcode - typically the city/suburb or postal distribution centre
state	The Australian state in which the locality is situated
long	The longitude of the locality - defaults to 0 when not available
lat	The latitude of the locality - defaults to 0 when not available
dc1	The Australia Post distribution Centre servicing this postcode - defaults to blank when not available
type1	The type of locality, such as a delivery area, post office or a "Large Volume Recipient" such as a GPO, defaults to blank when not available
SA3	The SA3 Statistical Area code
SA3 Name	The name of the SA3 Statistical Area
SA4	The SA4 Statistical Area code
SA4 Name	The name of the SA4 Statistical Area
Region	Designated Regional Area
status	A note indicating whether the data is new, removed or updated
CED	The Commonwealth Electroal Division
Altitude	Altitude/Elevation (meters)
Charge Zone	Australia Post Charge Zones
PHN Code	Primary Health Network Code
PHN Code	Primary Health Network Name
Lat Google	Latitude from Google Maps API
Long Google	Longitude from Google Maps API
SA1 Maincode 2011	Statistical Area 1 2011 Code
SA1 Maincode 2016	Statistical Area 1 2016 Code
SA2 Maincode 2016	Statistical Area 2 2016 Code
SA2 Name 2016	Statistical Area 2 2016 Name
RA 2011	Remoteness Area - 2011 Dataset
RA 2016	Remoteness Area - 2016 Dataset
MMM 2016	Modified Monash Model - 2016 Dataset
MMM 2019	Modified Monash Model - 2019 Dataset
LGA Region	Local Government Area
Electorate	Federal Government Electorate
Electorate Rating	Federal Government Demographic Rating

How to contribute

All contributions are welcome!!! You have a few options:

Submit a Pull Request
Lodge an Issue on this repo, and I'll update the file
Send me a message (email, twitter dm, etc.)

Pull Requests

Please submit any pull requests that you feel are useful to add, edit or delete data from this database. Your contributions are essential to help keep this database up to date.

Australia Post Databases

From time to time, friendly people help submit changes that they see from the official Australia Post database. I dont have the funds to buy this database myself, and technically it's not meant to be republished, but I'm confident this repository has the most up to date publically sourced set of postal data available.

NOTES on the SQL File

As long and type are reserved words in MySQL, it's been addressed directly in the insert query, so you may need to update that in insert script in the php import tool.

Also, you may need to clean the data a little more that comes from the original CSV source as it contained multiple entries of ""NAME"" instead of "NAME", which tends to break things like this on CSV imports.

peterstavrou / australianpostcodes Goto Github PK