Postcodes of Australia & New Zealand

Postcode Database Australia & New Zealand

Details (Data of: 2024)

The Australia & New Zealand postcode database includes all Australia & New Zealand Postcodes plus city and region plus latitude/longitude. The Australia & New Zealand postcode database includes all Australia & New Zealand Postcodes plus location and region plus latitude/longitude and also all locations (long/lat) of all New Zealand Suburbs / Districts / Regions.

Database content Australia

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

Database content NZ

Regions Level 1	16
Regions Level 2	67
Localities	521
Suburbs	3277
Streets	70948
Unique Postcodes	1304
Geocoded locations	100 %
Number of records	72149

Available Formats:

Comma-separated values (CSV) ~1.5 MB ZIP compressed

Easy to import into all popular database management systems:

MySQL

MS SQL

Oracle

Postgre SQL

Microsoft Access

DB Structure Australia

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)

DB Structure NZ (Streetlevel)

countrycode	varchar(2)
postcode	varchar(4)
region1	varchar(48)
region2	varchar(48)
locality	varchar(48)
suburb	varchar(48)
street	varchar(48)
numbers	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.