Australian Street Names, Suburb, State Database with Longitude and Latitude GEO Data

Latest release: v2.1 on 26th Jan 2015

Hi Guys,

For one of my projects I needed this data to offer and auto suggestion box for my Users so that they can select their Street Name, Suburb and State in one Hit while they type. So I researched around and did not find any thing that suits me. The address correction software provided by Australian post was way too expensive for me. So then I found many Open source from where I can get pieces of data. Finally I was able to join that data to make it meaningful. Now this database stands at over 231,000+ unique records and has been validated manually with well known mapping solutions to see if database rows are valid.

I chose to have few different variations for this database, and all variations are explained below. They are all priced accordingly.

First lets take a look at the Entity Relationship Diagram (indication only, You can structure it as you like)

There is nothing much to explain in the above ER but I will try to explain a bit. As you can see the we have Country table with all Countries in it but because this database only deals with Australian Street thus I introduced a column called active which have two possible values ‘Yes’ and ‘No’, You guessed it right, with this database even though I am providing list of all countries Only Australia is Active

So Country has 1-Many relation with States and this Tables lists all Australian states e.g. Victoria, NSW, SA etc. In Other words Australia has many states and this is the relationship I am highlighting.

As you see in diagram above that State has 1->Many relationship with Cities in other words Suburbs. Same relationship applies when to try to relate Suburbs with Street Names. i.e. A Suburb can have many states thus 1->Many Relationship.

A current version auto suggestion example is available from here 

The data in this demo is a few months old and carry many invalid records. I’ve re-verified the current version which will be available soon on Demo page, I agree that data demos page needs some improvement that I will look into when I get some time.

Please note that databases are released by jaspreetchahal.org, and does contains 11 dummy records.

Quick Note: This database is not complete list of street names, I can assure you however, that most of the street names are in over 230,000 unique records. So you will need to try the database from data demos before buying it. No Refund will be issued because of Accidental or “Do not like” purchase. And I can only assure 96-97% accuracy. An update will be available every 6-12 months because it takes time to re-asses the data and verify it.

Once you buy a product and pay for it you will get a Zip file that will have CSV and SQL files along with the License file.

Each SKU have 11 invalid records put in intentionally for detection if this data is being sold or used somewhere without permission or License.

It takes weeks to compile this sort of data so your support will be much appreciated.

Ask as many questions as you like by contacting me using the contact form before you buy any License. I will be happy to help you out. The prices are RRP so I can manage some discount for you being good.

Meta Info:

Current version

Database version: 2.1
Compilation start date: 1st January 2015
Compilation release date: 26th January 2015
Includes verification time: 10 days:
Data Source: Open data
Verified with: Known mapping solutions. 

Historic versions

Database version: 1.1
Compilation start date: 10th March
Compilation end date: 24th March
Verification time: 10 days
Data Source: Open data
Verified with: Known mapping solutions.

I hope this data will be useful to you. Rest assured that I am and will work continuously on this data set to make it more complete.

Questions? Ask me.

Cheers.