Database Details
Postcodes of Australia
Postcode Database Australia
Details (Data of: 2024)
The Australia postcode database includes all Australia Postcodes plus city and region plus latitude/longitude.
Database content
Regions Level 1 | 11 |
Regions Level 2 | 63 |
Regions Level 3 (LGA's) | 567 |
Localities / Suburbs | 15823 |
Unique Postcodes | 3302 |
Geocoded locations | 100 % |
Number of records | 16539 |
Available Formats:
Comma-separated values (CSV) ~300 KB ZIP compressed
Easy to import into all popular database management systems:
MySQL
MS SQL
Oracle
Postgre SQL
Microsoft Access
DB Structure
countrycode | varchar(2) |
postcode | varchar(4) |
region1 | varchar(48) |
region2 | varchar(48) |
region3 | varchar(48) |
locality | varchar(48) |
latitude | decimal(13, 9) |
longitude | decimal(13, 9) |
iso | varchar(48) |
fips | varchar(48) |
hasc | varchar(48) |
stat | varchar(48) |
timezone | varchar(48) |
utc | varchar(48) |
dst | varchar(48) |
Delivery
Online Download
Programming
Having a database of localities with their latitudes and longitudes enables you to locate the closest cities to a set point (or within a radius of X).To help you to implement a postcode radius / distance search we offer free access to example codes in many scripting languages and programming languages like ASP, PHP, Coldfusion...
To achieve the highest accuracy the formulas in our example scripts take the earth's curvature into consideration.
Check out a working example.
Data Sample
countrycode;region1;region2;region3;postcode;locality;latitude;longitude;iso;fips;hasc;stat;timezone;utc;dst
AU;Australian Capital Territory;Canberra;Canberra;0200;Australian National University;-35.2777482;149.1187312;AU-ACT;AS01;AU.AC;ACT;Australia/Sydney;+10:00;+11:00
AU;Northern Territory;Northern Territory;Darwin;0800;Darwin;-12.4614331;130.8429455;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0801;Darwin;-12.4628421;130.8420036;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0803;Wagait Beach;-12.4355136;130.7488861;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0804;Parap;-12.4322752;130.8435559;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Alawa;-12.3789873;130.8745152;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Brinkin;-12.3678706;130.8708837;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Casuarina;-12.3731154;130.8836556;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Coconut Grove;-12.3976872;130.8523475;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Jingili;-12.3902617;130.8724996;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Lee Point;-12.3390029;130.8938503;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Lyons;-12.3577474;130.8892831;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Millner;-12.3913530;130.8646324;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Moil;-12.3898732;130.8802974;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Muirhead;-12.3578404;130.8910155;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Nakara;-12.3669509;130.8799252;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Nightcliff;-12.3880544;130.8511831;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Rapid Creek;-12.3810169;130.8600266;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Tiwi;-12.3648849;130.8817132;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Wagaman;-12.3793585;130.8867270;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Wanguri;-12.3729548;130.8880379;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0811;Casuarina;-12.3757241;130.8829941;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0812;Anula;-12.3919451;130.8905217;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0812;Buffalo Creek;-12.3379497;130.9086914;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0812;Holmes;-12.3880518;130.9261787;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0812;Karama;-12.4011806;130.9180577;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0812;Leanyer;-12.3744221;130.9018070;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0812;Malak;-12.3934097;130.9054082;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0812;Marrara;-12.3986890;130.8802240;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0812;Northlakes;-12.4004422;130.9010923;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0812;Woodleigh Gardens;-12.3740105;130.8981112;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0812;Wulagi;-12.3842294;130.8944504;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0813;Karama;-12.4008486;130.9152633;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0814;Nightcliff;-12.3854780;130.8535883;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0815;Charles Darwin University;-12.3722709;130.8698428;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0820;Bayview;-12.4357117;130.8588303;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Unincorporated NT;0820;Charles Darwin;-12.4324208;130.8738096;AU-NT;AS03;AU.NT;79399;Australia/Darwin;+09:30;+09:30
AU;Australian Capital Territory;Canberra;Canberra;0200;Australian National University;-35.2777482;149.1187312;AU-ACT;AS01;AU.AC;ACT;Australia/Sydney;+10:00;+11:00
AU;Northern Territory;Northern Territory;Darwin;0800;Darwin;-12.4614331;130.8429455;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0801;Darwin;-12.4628421;130.8420036;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0803;Wagait Beach;-12.4355136;130.7488861;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0804;Parap;-12.4322752;130.8435559;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Alawa;-12.3789873;130.8745152;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Brinkin;-12.3678706;130.8708837;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Casuarina;-12.3731154;130.8836556;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Coconut Grove;-12.3976872;130.8523475;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Jingili;-12.3902617;130.8724996;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Lee Point;-12.3390029;130.8938503;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Lyons;-12.3577474;130.8892831;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Millner;-12.3913530;130.8646324;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Moil;-12.3898732;130.8802974;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Muirhead;-12.3578404;130.8910155;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Nakara;-12.3669509;130.8799252;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Nightcliff;-12.3880544;130.8511831;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Rapid Creek;-12.3810169;130.8600266;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Tiwi;-12.3648849;130.8817132;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Wagaman;-12.3793585;130.8867270;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0810;Wanguri;-12.3729548;130.8880379;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0811;Casuarina;-12.3757241;130.8829941;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0812;Anula;-12.3919451;130.8905217;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0812;Buffalo Creek;-12.3379497;130.9086914;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0812;Holmes;-12.3880518;130.9261787;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0812;Karama;-12.4011806;130.9180577;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0812;Leanyer;-12.3744221;130.9018070;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0812;Malak;-12.3934097;130.9054082;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0812;Marrara;-12.3986890;130.8802240;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0812;Northlakes;-12.4004422;130.9010923;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0812;Woodleigh Gardens;-12.3740105;130.8981112;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0812;Wulagi;-12.3842294;130.8944504;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0813;Karama;-12.4008486;130.9152633;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0814;Nightcliff;-12.3854780;130.8535883;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0815;Charles Darwin University;-12.3722709;130.8698428;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Darwin;0820;Bayview;-12.4357117;130.8588303;AU-NT;AS03;AU.NT;71000;Australia/Darwin;+09:30;+09:30
AU;Northern Territory;Northern Territory;Unincorporated NT;0820;Charles Darwin;-12.4324208;130.8738096;AU-NT;AS03;AU.NT;79399;Australia/Darwin;+09:30;+09:30