Database Details

Postcodes of New Zealand

Postcode Database New Zealand

Single License ?

199 AU$! Includes free lifetime updates!

Eneterprise License ?

399 AU$! Includes free lifetime updates!

Redistribution License ?

999 AU$! Includes free lifetime updates!

Postcode Database New Zealand

Details (Data of: 2024)

The New Zealand postcode database includes all 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

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) ~800 KB ZIP compressed


Easy to import into all popular database management systems:

MySQL

MS SQL

Oracle

Postgre SQL

Microsoft Access

DB Structure (Streetlevel)

  countrycodevarchar(2)
  postcodevarchar(4)
  region1varchar(48)
  region2varchar(48)
  localityvarchar(48)
  suburbvarchar(48)
  streetvarchar(48)
  numbersvarchar(48)
  latitudedecimal(13, 9)
  longitudedecimal(13, 9)
  isovarchar(48)
  fipsvarchar(48)
  hascvarchar(48)
  statvarchar(48)
  timezonevarchar(48)
  utcvarchar(48)
  dstvarchar(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;postcode;locality;suburb;street;numbers;latitude;longitude;iso;fips;hasc;stat;timezone;utc;dst
NZ;Northland;Whangarei;0110;Whangarei;Abbey Caves;Awaroa River Road;;-35.7329034;174.3670167;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Abbey Caves;Riverside Drive;;-35.7289768;174.3399422;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Avenues;Bernard Street;;-35.7315286;174.3131397;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Avenues;Cafler Avenue;;-35.7366320;174.3666441;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Avenues;Central Avenue;;-35.7259191;174.3140932;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Avenues;Cooke Street;;-35.7307162;174.3140794;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Avenues;Fifth Avenue;;-35.7233315;174.3121540;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Avenues;First Avenue;;-35.7282283;174.3141382;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Avenues;High Oaks Way;;-35.7216344;174.3131680;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Avenues;Kauika Road;;-35.7290294;174.3111434;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Avenues;Kauika Road West;;-35.7336090;174.3543165;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Avenues;Keays Road;;-35.7299243;174.3151188;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Avenues;Lovers Lane;;-35.7280771;174.3371654;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Avenues;Maunu Road;;-35.7345860;174.3086533;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Avenues;Porowini Avenue;;-35.7384832;174.3589590;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Avenues;Second Avenue;;-35.7271074;174.3140362;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Avenues;Selwyn Avenue;;-35.7222345;174.3151683;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Avenues;Third Avenue;;-35.7267324;174.3121584;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Avenues;Walton Street;;-35.7293182;174.3353156;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Avenues;Water Street;;-35.7279401;174.3267391;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Avenues;Western Hills Drive;;-35.7312880;174.4010944;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Avenues;Wilson Avenue;;-35.7252172;174.3110843;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Avenues;Woodhill Close;;-35.7247265;174.3101296;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Horahora;Hihi Rise;;-35.7503619;174.3839222;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Horahora;Hospital Road;;-35.7360306;174.3001493;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Horahora;Kokako Place;;-35.7325822;174.2889529;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Horahora;Maunu Road;;-35.7394789;174.3342067;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Horahora;Melody Lane;;-35.7324759;174.3010196;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Horahora;Ngahere Drive;;-35.7363042;174.2900207;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Horahora;Redwood Rise;;-35.7337274;174.2971338;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Horahora;Silverstream Road;;-35.7347060;174.2930294;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Horahora;Taiko Street;;-35.7337413;174.2888425;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Horahora;Tieke Place;;-35.7328571;174.2880612;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Horahora;Western View Heights;;-35.7354955;174.2990043;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Horahora;Westwood Lane;;-35.7321262;174.2941279;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00
NZ;Northland;Whangarei;0110;Whangarei;Horahora;Willow Place;;-35.7352146;174.2960716;NZ-NTL;NZF6;NZ.NO.WN;002;Pacific/Auckland;+12:00;+13:00

Other products

From 199 AU$
From 349 AU$
Free