Australian suburb boundaries database released


Its been a great pleasure for me to release Australian suburb boundaries database, A suburb boundary is represented in a polygon of longitude and latitude points.

More details can he found on product page which is located here

Product will have two files

  1. mySQL inserts
  2. CSV file for a quick import

Database schema is shown below

Australian suburb boundaries schema

Columns: city and org_name pretty much has same values, use city column value for corrected spelling mistakes.


Data is represented in polygons. In above picture, boundaries column will have polygon data for a suburb, if there are mulitple boundaries for a suburb then boundaries column will have mulitple polygons data delimited by a semicolon (;)

As you see that there is no country field because this is not a multi country suburb boundary database and only applies to Australia.

Currently there are over 7899+ records in this database covering major suburbs in all different states. However more will be added and will be released as upgrades priced around $99 for each upgrade and each upgrade will have at least 100 records.

Download size is around 100MB. 

Very important

Download demo data below


If you don’t like the demo data, Do Not Buy this product, because NO REFUNDS are given in case of accidental purchase syndrome or I didn’t like it syndrome


If you find any issue please let me know by contacting me I will sure fix it up in next version.


This product is not versioned, what you download is the latest version at the time of download. however Upgrades are sold separately and will be included on this page as a reference when they are available. Its a good idea if you end up purchasing this product, bookmark this page to check if there are any upgrades available

Release date

First release of this database is: 16th July 2014


None just yet.

Current status. Upgrade due around 4 weeks time.


Please let me know if you want a KML template file. This is not included within the download file.



I hope you enjoy this product and your feedback as always is very important






How to make xml_split, xml_merge, xml_pp, xml_grep, xml_spellcheck under XML-Twig tools work on Windows

XML twig

Large XML files could sometimes lead to overall slowness of your program. Thus it makes sense to sometimes split them to rearrange contents within to optimize querying your XML files. This post will touch base on how to split a large XML file on … [Continue reading]

Yii Framework Apply Custom layout to a controller or action

If you are using Yii PHP framework you are using one of the fastest PHP frameworks around. Sometimes there are minor things that we want to do and couldn't find a document that is to the point and precise in what you are looking after. This Quick … [Continue reading]

Installing Apache thrift, Cassandra 2.x and YACassandra-PDO on CentOS 6.5+

Hello, Well after a long time this is my in length article, the reason I am writing is because of all the stuff I have been gone through building thrift and cassandra-pdo on centOS 6.5 Versions I will be writing about installing latest version … [Continue reading]

Installing YAF php framework and getting /usr/include/php/ext/pcre/php_pcre.h:29:18: error: pcre.h: No such file or directory on Centos 6+

Hi Guys, Yaf framework appears to be the fastest framework around, logically so because its built with C and compiled in a PHP extension. While installing Yaf, I ran into a problem where it seems like make was complaining about pcre.h missing … [Continue reading]

Config file “/etc/amavisd.conf” does not exist

Hi guys, A quick tip If you get this error either trying to showkeys  or any other action using amavisd You can quickly fix that Generally amavisd.conf file reside under /etc/ but on many distros it can be found … [Continue reading]

Linux Find files newer than certain date and time

Yeah I know generally we pretty much always want to find older files but there are some use cases where finding newer files than a certain date time is a requirement. Ok being no where near to your Linux expertise, I will show you how I do it, you … [Continue reading]

Google MarkerClusterer Handling Multiple Markers On Same Geo Location

When you are dealing with addresses on Google Maps there are times when you have multiple addresses for a same location. For example if you live in a building with 200+ apartments, building address remains the same but you also add apartment number … [Continue reading]

How to clear DNS Cache in Windows small business server 2011 or windows 2008 r2

Clear DNS cache

G'day While I do not write on Windows server too often but here is that once in a blue moon article or you can assume a quick tip on how to clear DNS cache, Reason can be any but sometimes we have to do it. Locally we will just … [Continue reading]

5 best jQuery radio button and checkbox styling plugins


Sometimes its good to utilize great work done by different authors working in different fields rather than reinventing the wheel again and again. There are awesome Git projects that people are working collaboratively to produce something really … [Continue reading]