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

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 300,000+ unique records and has been verified with the likes of Google and other 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 under my registered Company PediaSoft I.T. Pty Ltd which is a registered Australian Company.

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.

 

 

SKU/Features Over 230,000 rows with 97% accuracy verified. Description
Please note: This is not complete list of Street Names and may never be. 
City Table State Table Country Table Long/Lat Columns License covers
AUSSTREETALL
(buy now)
Contains Australian Streets with Longitude and Latitude, City, State and Country table Yes Yes Yes Yes Single Site
AUSSTREETNOLL
(buy now) 
Contains Australian Streets without Longitude and Latitude, City, State and Country table Yes Yes Yes Yes Single Site
AUSSTREETALLMULTI
(buy now) 
Contains Australian Streets with Longitude and Latitude, City, State and Country table Yes Yes Yes Yes Unlimited Sites Owned by you
AUSSTREETNOLLMULTI
(buy now) 
Contains Australian Streets without Longitude and Latitude, City, State and Country table Yes Yes Yes Yes Unlimited Sites Owned by you
AUSSTREETNAMESALL
(buy now)
Contact me for Multi Site License Quote
Contains One table with these columns

  1. Street Name
  2. City Name
  3. State Name
  4. Longitude
  5. Latitude
  6. Display Name
No No No Yes Single Site
AUSSTREETNAMESNOLL
(buy now)
Contact me for Multi Site License Quote
Contains One table with these columns

  1. Street Name
  2. City Name
  3. State Name
  4. Display Name
No No No No Single Site

 

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 5-10 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:

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 dataset to make it more complete. I am expecting to add atleast few hundreds rows when I release an update.

Questions? Ask me.

 

 

Cheers.

 

VN:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Trackbacks

  1. [...] Do you have an Australian Street database as well? Yes, it has over 230,000+ (and adding) rows. More details here [...]

Speak Your Mind

*

CommentLuv badge