SQL Tips – List of New Zealand Towns and Cities

Here is SQL and a text list of the towns and cities in New Zealand.

The list is free for all to use for any purpose.

The original data was sourced from Wikipedia on Saturday 31 January 2008.

If you need to modify it further, remember that you can always use The Worlds Simplest Code Generator.

Please post a comment if you find this useful.

SQL version:

INSERT INTO TABLE(townname)
VALUES
('Ahaura'),
('Ahipara'),
('Ahititi'),
('Ahuroa'),
('Akaroa'),
('Albert Town'),
('Albury'),
('Alexandra'),
('Amberley'),
('Aranga'),
('Arapohue'),
('Arrowtown'),
('Ashburton'),
('Ashhurst'),
('Auckland'),
('Auroa'),
('Awanui'),
('Balclutha'),
('Balfour'),
('Barrytown'),
('Beachlands'),
('Beaumont'),
('Bell Block'),
('Blackball'),
('Blenheim'),
('Bluff'),
('Brighton'),
('Brightwater'),
('Broadwood'),
('Bulls'),
('Bunnythorpe'),
('Cambridge'),
('Canvastown'),
('Carterton'),
('Cheviot'),
('Christchurch'),
('Clarksville'),
('Clive'),
('Coatesville'),
('Colville'),
('Coroglen'),
('Coromandel'),
('Cromwell'),
('Dairy Flat'),
('Dannevirke'),
('Darfield'),
('Dargaville'),
('Dobson'),
('Drury'),
('Dunedin'),
('Duntroon'),
('Eastbourne'),
('Edgecumbe'),
('Egmont Village'),
('Eketahuna'),
('Eltham'),
('Fairhall'),
('Fairlie'),
('Featherston'),
('Feilding'),
('Flaxmere'),
('Fox Glacier'),
('Foxton'),
('Foxton Beach'),
('Frankton'),
('Frankton'),
('Franz Josef'),
('Geraldine'),
('Gisborne'),
('Glenorchy'),
('Gore'),
('Granity'),
('Greymouth'),
('Greytown'),
('Grovetown'),
('Haast'),
('Hakataramea'),
('Hamilton'),
('Hanmer Springs'),
('Hari Hari'),
('Hastings'),
('Haupiri'),
('Havelock'),
('Havelock North'),
('Hawea'),
('Hawera'),
('Helensville'),
('Henley'),
('Herekino'),
('Hikuai'),
('Hikurangi'),
('Hikutaia'),
('Hinuera'),
('Hokitika'),
('Horeke'),
('Houhora'),
('Howick'),
('Huapai'),
('Huiakama'),
('Huirangi'),
('Hukerenui'),
('Huntly'),
('Hurleyville'),
('Inangahua Junction'),
('Inglewood'),
('Invercargill'),
('Jacobs River'),
('Kaiapoi'),
('Kaihu'),
('Kaikohe'),
('Kaikoura'),
('Kaimata'),
('Kaingaroa'),
('Kaipara Flats'),
('Kaitaia'),
('Kaitangata'),
('Kaiwaka'),
('Kakaramea'),
('Kaniere'),
('Kaponga'),
('Karamea'),
('Karetu'),
('Katikati'),
('Kaukapakapa'),
('Kauri'),
('Kawakawa'),
('Kawerau'),
('Kennedy Bay'),
('Kerikeri'),
('Kihikihi'),
('Kinloch'),
('Kokatahi'),
('Kokopu'),
('Koromiko'),
('Kumara'),
('Kumeu'),
('Kurow'),
('Kawhia'),
('Lawrence'),
('Leeston'),
('Leigh'),
('Lepperton'),
('Levin'),
('Lincoln'),
('Linkwater'),
('Little River'),
('Lower Hutt'),
('Lumsden'),
('Lyttelton'),
('Makahu'),
('Manaia'),
('Manaia'),
('Manakau'),
('Mangakino'),
('Mangamuka'),
('Mangatoki'),
('Mangawhai'),
('Manukau'),
('Manurewa'),
('Maraetai'),
('Marco'),
('Maromaku'),
('Marsden Bay'),
('Martinborough'),
('Marton'),
('Maruia'),
('Masterton'),
('Matakana'),
('Matakohe'),
('Matamata'),
('Matapu'),
('Matarau'),
('Matihetihe'),
('Maungakaramea'),
('Maungatapere'),
('Maungaturoto'),
('Mayfield'),
('Methven'),
('Middlemarch'),
('Midhirst'),
('Millers Flat'),
('Milton'),
('Mimi'),
('Moana'),
('Moenui'),
('Moeraki'),
('Moerewa'),
('Mokau'),
('Mokoia'),
('Morrinsville'),
('Mosgiel'),
('Mossburn'),
('Motatau'),
('Motueka'),
('Mount Maunganui'),
('Mount Somers'),
('Murchison'),
('Murupara'),
('Napier'),
('Naseby'),
('Nelson'),
('New Brighton'),
('New Plymouth'),
('Normanby'),
('Ngaere'),
('Ngamatapouri'),
('Ngapara'),
('Ngaruawahia'),
('Ngataki'),
('Ngongotaha'),
('Ngunguru'),
('Norfolk'),
('North Shore City'),
('Oakura'),
('Oamaru'),
('Oban'),
('Ohakune'),
('Ohaeawai'),
('Ohangai'),
('Ohoka'),
('Ohope Beach'),
('Ohura'),
('Okaihau'),
('Okato'),
('Omanaia'),
('Omarama'),
('Omata'),
('Omokoroa'),
('Opononi'),
('Opotiki'),
('Opua'),
('Opunake'),
('Oratia'),
('Orewa'),
('Oromahoe'),
('Oruaiti'),
('Otaika'),
('Otaki'),
('Otakou'),
('Otautau'),
('Otiria'),
('Otorohanga'),
('Oxford'),
('Paekakariki'),
('Paeroa'),
('Pahiatua'),
('Paihia'),
('Pakaraka'),
('Pakiri'),
('Pakotai'),
('Palmerston'),
('Palmerston North'),
('Pamapuria'),
('Panguru'),
('Papakura'),
('Papamoa'),
('Paparoa'),
('Papatoetoe'),
('Parakai'),
('Paraparaumu'),
('Paroa'),
('Parua Bay'),
('Patea'),
('Pauanui'),
('Pauatahanui'),
('Peka Peka'),
('Pembroke'),
('Peria'),
('Petone'),
('Picton'),
('Piopio'),
('Pipiwai'),
('Pirongia'),
('Pleasant Point'),
('Plimmerton'),
('Porirua'),
('Portland'),
('Poroti'),
('Port Chalmers'),
('Portobello'),
('Pukekohe'),
('Pukerua Bay'),
('Pukeuri'),
('Pukepoto'),
('Purua'),
('Putaruru'),
('Queenstown'),
('Raetihi'),
('Raglan'),
('Rahotu'),
('Rai Valley'),
('Ramarama'),
('Ranfurly'),
('Rangiora'),
('Rapaura'),
('Ratapiko'),
('Raumati'),
('Rawene'),
('Rawhitiroa'),
('Reefton'),
('Renwick'),
('Richmond'),
('Riverhead'),
('Riverlands'),
('Riversdale Beach'),
('Riverton'),
('Rolleston'),
('Ross'),
('Rotorua'),
('Roxburgh'),
('Ruatoria'),
('Ruawai'),
('Runanga'),
('Russell'),
('Sanson'),
('Seddon'),
('Sheffield and Waddington'),
('Shannon'),
('Snells Beach'),
('Springfield'),
('Stratford'),
('Silverdale'),
('Spring Creek'),
('Taharoa'),
('Taihape'),
('Taipa-Mangonui'),
('Tairua'),
('Takaka'),
('Tangiteroria'),
('Tapanui'),
('Tapu'),
('Tangowahine'),
('Tapora'),
('Taradale'),
('Tauhoa'),
('Taumarunui'),
('Taupaki'),
('Taupo'),
('Tauranga'),
('Tauraroa'),
('Tautoro'),
('Te Anau'),
('Te Arai'),
('Te Aroha'),
('Te Awamutu'),
('Te Hapua'),
('Te Horo'),
('Te Kao'),
('Te Kopuru'),
('Te Kuiti'),
('Te Puke'),
('Te Puru'),
('Temuka'),
('Te Rerenga'),
('Thames'),
('Tikorangi‎'),
('Timaru'),
('Tinopai'),
('Tinwald'),
('Tirau'),
('Titoki'),
('Tokarahi'),
('Toko'),
('Tokoroa'),
('Tolaga Bay'),
('Tomarata'),
('Towai'),
('Tuakau'),
('Tuamarina'),
('Turangi'),
('Twizel'),
('Umawera'),
('Upper Hutt'),
('Urenui'),
('Uruti'),
('Waiheke Island'),
('Waharoa'),
('Waiharara'),
('Waihi'),
('Waihi Beach'),
('Waihola'),
('Waikanae'),
('Waikawa'),
('Waikawa'),
('Waima'),
('Waimangaroa'),
('Waimate'),
('Waimate North'),
('Waimauku'),
('Wainui'),
('Wainuiomata'),
('Waioneke'),
('Waiouru'),
('Waiotira'),
('Waipawa'),
('Waipukurau'),
('Wairakei'),
('Wairau Valley'),
('Wairoa'),
('Waitahuna'),
('Waikouaiti'),
('Waikuku'),
('Waitakere'),
('Waitara'),
('Waitaria Bay'),
('Waitoa'),
('Waitoki'),
('Waitoriki'),
('Waitotara'),
('Waiuku'),
('Wakefield'),
('Wallacetown'),
('Walton'),
('Waverley'),
('Wanaka'),
('Wanganui'),
('Ward'),
('Wardville'),
('Warkworth'),
('Wellington'),
('Wellsford'),
('Westport'),
('Whakatane'),
('Whakamaru'),
('Whananaki'),
('Whangamata'),
('Whangamomona'),
('Whangarei'),
('Whangarei Heads'),
('Whangaruru'),
('Whataroa'),
('Whatuwhiwhi'),
('Whenuakite'),
('Whenuakura'),
('Whiritoa'),
('Whitford'),
('Whitby'),
('Whitianga'),
('Willowby'),
('Wimbledon'),
('Winscombe'),
('Winton'),
('Woodend'),
('Woodhill'),
('Woodville'),
('Wyndham');

Text version:

Ahaura
Ahipara
Ahititi
Ahuroa
Akaroa
Albert Town
Albury
Alexandra
Amberley
Aranga
Arapohue
Arrowtown
Ashburton
Ashhurst
Auckland
Auroa
Awanui
Balclutha
Balfour
Barrytown
Beachlands
Beaumont
Bell Block
Blackball
Blenheim
Bluff
Brighton
Brightwater
Broadwood
Bulls
Bunnythorpe
Cambridge
Canvastown
Carterton
Cheviot
Christchurch
Clarksville
Clive
Coatesville
Colville
Coroglen
Coromandel
Cromwell
Dairy Flat
Dannevirke
Darfield
Dargaville
Dobson
Drury
Dunedin
Duntroon
Eastbourne
Edgecumbe
Egmont Village
Eketahuna
Eltham
Fairhall
Fairlie
Featherston
Feilding
Flaxmere
Fox Glacier
Foxton
Foxton Beach
Frankton, Otago
Frankton, Waikato
Franz Josef
Geraldine
Gisborne
Glenorchy
Gore
Granity
Greymouth
Greytown
Grovetown
Haast
Hakataramea
Hamilton
Hanmer Springs
Hari Hari
Hastings
Haupiri
Havelock
Havelock North
Hawea
Hawera
Helensville
Henley
Herekino
Hikuai
Hikurangi
Hikutaia
Hinuera
Hokitika
Horeke
Houhora
Howick
Huapai
Huiakama
Huirangi
Hukerenui
Huntly
Hurleyville
Inangahua Junction
Inglewood
Invercargill
Jacobs River
Kaiapoi
Kaihu
Kaikohe
Kaikoura
Kaimata
Kaingaroa
Kaipara Flats
Kaitaia
Kaitangata
Kaiwaka
Kakaramea
Kaniere
Kaponga
Karamea
Karetu
Katikati
Kaukapakapa
Kauri
Kawakawa
Kawerau
Kennedy Bay
Kerikeri
Kihikihi
Kinloch
Kokatahi
Kokopu
Koromiko
Kumara
Kumeu
Kurow
Kawhia
Lawrence
Leeston
Leigh
Lepperton
Levin
Lincoln
Linkwater
Little River
Lower Hutt
Lumsden
Lyttelton
Makahu
Manaia, South Taranaki
Manaia, Coromandel
Manakau
Mangakino
Mangamuka
Mangatoki
Mangawhai
Manukau
Manurewa
Maraetai
Marco
Maromaku
Marsden Bay
Martinborough
Marton
Maruia
Masterton
Matakana
Matakohe
Matamata
Matapu
Matarau
Matihetihe
Maungakaramea
Maungatapere
Maungaturoto
Mayfield
Methven
Middlemarch
Midhirst
Millers Flat
Milton
Mimi
Moana
Moenui
Moeraki
Moerewa
Mokau
Mokoia
Morrinsville
Mosgiel
Mossburn
Motatau
Motueka
Mount Maunganui
Mount Somers
Murchison
Murupara
Napier
Naseby
Nelson
New Brighton
New Plymouth
Normanby
Ngaere
Ngamatapouri
Ngapara
Ngaruawahia
Ngataki
Ngongotaha
Ngunguru
Norfolk
North Shore City
Oakura
Oamaru
Oban
Ohakune
Ohaeawai
Ohangai
Ohoka
Ohope Beach
Ohura
Okaihau
Okato
Omanaia
Omarama
Omata
Omokoroa
Opononi
Opotiki
Opua
Opunake
Oratia
Orewa
Oromahoe
Oruaiti
Otaika
Otaki
Otakou
Otautau
Otiria
Otorohanga
Oxford
Paekakariki
Paeroa
Pahiatua
Paihia
Pakaraka
Pakiri
Pakotai
Palmerston
Palmerston North
Pamapuria
Panguru
Papakura
Papamoa
Paparoa
Papatoetoe
Parakai
Paraparaumu
Paroa
Parua Bay
Patea
Pauanui
Pauatahanui
Peka Peka
Pembroke
Peria
Petone
Picton
Piopio
Pipiwai
Pirongia
Pleasant Point
Plimmerton
Porirua
Portland
Poroti
Port Chalmers
Portobello
Pukekohe
Pukerua Bay
Pukeuri
Pukepoto
Purua
Putaruru
Queenstown
Raetihi
Raglan
Rahotu
Rai Valley
Ramarama
Ranfurly
Rangiora
Rapaura
Ratapiko
Raumati
Rawene
Rawhitiroa
Reefton
Renwick
Richmond
Riverhead
Riverlands
Riversdale Beach
Riverton
Rolleston
Ross
Rotorua
Roxburgh
Ruatoria
Ruawai
Runanga
Russell
Sanson
Seddon
Sheffield and Waddington
Shannon
Snells Beach
Springfield
Stratford
Silverdale
Spring Creek
Taharoa
Taihape
Taipa-Mangonui
Tairua
Takaka
Tangiteroria
Tapanui
Tapu
Tangowahine
Tapora
Taradale
Tauhoa
Taumarunui
Taupaki
Taupo
Tauranga
Tauraroa
Tautoro
Te Anau
Te Arai
Te Aroha
Te Awamutu
Te Hapua
Te Horo
Te Kao
Te Kopuru
Te Kuiti
Te Puke
Te Puru
Temuka
Te Rerenga
Thames
Tikorangi‎
Timaru
Tinopai
Tinwald
Tirau
Titoki
Tokarahi
Toko
Tokoroa
Tolaga Bay
Tomarata
Towai
Tuakau
Tuamarina
Turangi
Twizel
Umawera
Upper Hutt
Urenui
Uruti
Waiheke Island
Waharoa
Waiharara
Waihi
Waihi Beach
Waihola
Waikanae
Waikawa, Marlborough
Waikawa, Southland
Waima
Waimangaroa
Waimate
Waimate North
Waimauku
Wainui
Wainuiomata
Waioneke
Waiouru
Waiotira
Waipawa
Waipukurau
Wairakei
Wairau Valley
Wairoa
Waitahuna
Waikouaiti
Waikuku
Waitakere
Waitara
Waitaria Bay
Waitoa
Waitoki
Waitoriki
Waitotara
Waiuku
Wakefield
Wallacetown
Walton
Waverley
Wanaka
Wanganui
Ward
Wardville
Warkworth
Wellington
Wellsford
Westport
Whakatane
Whakamaru
Whananaki
Whangamata
Whangamomona
Whangarei
Whangarei Heads
Whangaruru
Whataroa
Whatuwhiwhi
Whenuakite
Whenuakura
Whiritoa
Whitford
Whitby
Whitianga
Willowby
Wimbledon
Winscombe
Winton
Woodend
Woodhill
Woodville
Wyndham
Posted in SQL Tips, Tips
8 comments on “SQL Tips – List of New Zealand Towns and Cities
  1. I was just looking at making a similar list for my own use, I was going to do the same thing, pull the info from wikipedia.

    You certainly saved me a few minutes.

    Thanks

  2. michael says:

    hello, I know this is an oldish post. But wondering if you have the same list, but with regions attached to the data as well?

  3. Erik says:

    Typo: there are two “f”s in Bluff. Great list, though — thanks!

  4. Mike says:

    Very helpful. Thanks heaps for posting this

  5. Dave says:

    Do you have the associated shortcodes (abbreviations) for each town ? Am trying to track down if anyone has a list of nationally recognised town abbreviations that I can use in our systems.
    (Air New Zealand has a list of such town shortcodes but of course they only apply to the destinations that Air NZ flies into, not every NZ town & city).

  6. Natalie says:

    Dave – the telephone directories have abbreviated ‘codes’ for all towns.

  7. Jon says:

    Thank you for this, super helpful!

  8. Adel says:

    fantastic tool! thank you

Leave a Reply

Your email address will not be published. Required fields are marked *

*