Maintaining an Australian postcode database
I spent some tie over the weekend putting together a small project to keep my database of geographical coordinates on Australian postcodes up to date.
You can checkout the page at Australian Postcode database and you can check individual suburbs, postcodes and download the latest data in Excel format.
Simply, I am keeping a database of the postcode, with their latitude and longitude as defined by Google's free geocoding service. I am then checking each postcode once a month to see if the data has changed, and update it accordingly.
Currently there are about 700 postcodes that google isn't aware of, mostly because they are Delivery centres, Mail centres or places that are out in the bush.
Every now and again I will import the AusPost postcode datafile database and add / remove anything that is out of date.
Are you interested in the missing lat and longs for the database? The only concern might be that auto updates will overwrite them.
Steve - that would be great. The only way it will be overwritten is by Google finding a match.
OK. I am heading interstate today and will update them over the next (n) weeks :o)
