New Zealand cities list with latitude and longitude in CSV format

New_Zealand
New Zealand
CSV, SQL, XML, JSON

Last update : 18 September 2024.

Country
New Zealand
Capitale
Wellington
Number of cities
2501
Download
Click here

This is the best list of 2501 cities in the New Zealand available in 4 formats ( CSV, Json, SQL, XML ). We have cleaned up the Geoname database to leave only the towns, capitals and villages. All are all associated with regions and sub-regions (where available).

Each file contains the following data: Geoname_ID, City, Alternate_Name, Country_Code, Region, Sub_region, Latitude, Longitude, Elevation, Population, Timezone, Fcode_Name. See the FAQ below for a detailed explanation.

Here is an example of the data from the New Zealand file that you are going to retrieve. The data is displayed here in the form of a table:


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
2194035Albert TownNewcastleNZOtagoQueenstown-Lakes District-44.68333169.20Pacific/Aucklandpopulated place
2194067Aka AkaNZWaikatoWaikato District-37.29355174.792350Pacific/Aucklandpopulated place
2188001MahutaNZWaikatoWaikato District-37.58333175.083330Pacific/Aucklandpopulated place
11352307Tuki TukiNZHawke’s BayHastings District-39.70857176.937860Pacific/Aucklandpopulated place
2188740KohumaruNZNorthlandFar North District-35.06667173.533330Pacific/Aucklandpopulated place
2189000KauangaroaNZManawatu-WanganuiWhanganui District-39.92438175.282920Pacific/Aucklandpopulated place
2192340ClaremontNZCanterburyTimaru District-44.4171.083330Pacific/Aucklandpopulated place
2186733MoengawahineNZNorthlandWhangarei-35.63333174.050Pacific/Aucklandpopulated place
2187072MaungaweraNZOtagoQueenstown-Lakes District-44.63333169.20Pacific/Aucklandpopulated place
2184555PipiroaNZWaikatoHauraki District-37.21667175.483330Pacific/Aucklandpopulated place
2190450GreertonNZBay of PlentyTauranga City-37.72541176.133464128Pacific/Aucklandpopulated place
2187911MakeokeoNZWaikatoOtorohanga District-38.03333175.133330Pacific/Aucklandpopulated place
6236085Te RangiitaNZWaikatoTaupo District-38.9095175.909090Pacific/Aucklandpopulated place
2187952MakarakaNZGisborneGisborne District-38.65177.966670Pacific/Aucklandpopulated place
2183628RaukokoreNZBay of PlentyOpotiki District-37.65177.883330Pacific/Aucklandpopulated place
2179742Waiwera SouthWaiweraNZOtagoClutha District-46.21667169.50Pacific/Aucklandpopulated place
2191665DorieNZCanterburyAshburton District-43.88333172.150Pacific/Aucklandpopulated place
2183620Raumati BeachRaumatiNZWellingtonKapiti Coast District-40.91667174.983335241Pacific/Aucklandpopulated place
2184358Port RobinsonNZCanterburyHurunui District-42.86667173.30Pacific/Aucklandpopulated place
2187191MataparaNZWaikatoOtorohanga District-38.21667175.550Pacific/Aucklandpopulated place
2192941BrooklynNZWellingtonWellington City-41.30586174.762573855Pacific/Aucklandpopulated place
2181805TataramoaNZManawatu-Wanganui-40.1345176.147880Pacific/Aucklandpopulated place
2185512OpononiNZNorthlandFar North District-35.5173.40Pacific/Aucklandpopulated place
2187350MarakerakeNZOtago-45.06667170.750Pacific/Aucklandpopulated place
2185162Owen RiverNZTasmanTasman District-41.65172.450Pacific/Aucklandpopulated place
2190199HaunuiNZManawatu-Wanganui-40.60848176.046340Pacific/Aucklandpopulated place
2192389CheltenhamNZManawatu-WanganuiManawatu District-40.15175.666670Pacific/Aucklandpopulated place
2179023WindwhistleNZCanterburySelwyn District-43.5171.683330Pacific/Aucklandpopulated place
2191736DiptonNZSouthlandSouthland District-45.9168.366670Pacific/Aucklandpopulated place
6245062OhauitiNZBay of PlentyWestern Bay of Plenty District-37.76559176.176370Pacific/Aucklandpopulated place
2193703AvondaleNZAucklandAuckland-36.88333174.721400Pacific/Aucklandpopulated place
2181782TaumangiNZWaikatoSouth Waikato District-38.03333175.766670Pacific/Aucklandpopulated place
2179581WaverleyWaverley Town DistrictNZTaranakiSouth Taranaki District-39.76667174.63333819Pacific/Aucklandpopulated place
2187908MaketuNZBay of PlentyWestern Bay of Plenty District-37.76667176.451197Pacific/Aucklandpopulated place
2189881Ho HoBlue SpurNZWest CoastWestland District-42.71667171.033330Pacific/Aucklandpopulated place
6236685Te TekoNZBay of PlentyWhakatane District-38.03653176.79358441Pacific/Aucklandpopulated place
8128798PukehangiNZBay of PlentyRotorua District-38.13635176.207870Pacific/Aucklandpopulated place
10126014PembrokeNZTaranakiStratford District-39.32367174.229090Pacific/Aucklandpopulated place
2186617MorereNZHawke’s BayWairoa District-38.98333177.80Pacific/Aucklandpopulated place
2179287Whangarei HeadsNZNorthlandWhangarei-35.81667174.51392Pacific/Aucklandpopulated place
2207724DevonportNZAucklandAuckland-36.82972174.799440Pacific/Aucklandpopulated place
2188865KerrytownNZCanterburyTimaru District-44.28333171.20Pacific/Aucklandpopulated place
2192467CavershamNZOtagoDunedin City-45.9170.483330Pacific/Aucklandpopulated place
2183728RangiririNZWaikatoWaikato District-37.4305175.129711833Pacific/Aucklandpopulated place
2191614DrummondNZSouthlandSouthland District-46.15168.150Pacific/Aucklandpopulated place
2184355Port WaikatoNZWaikatoWaikato District-37.39014174.72755783Pacific/Aucklandpopulated place
2189900HobsonvilleNZAucklandAuckland-36.79823174.648070Pacific/Aucklandpopulated place
2189457JacksonsJacksonNZWest CoastWestland District-42.75171.516670Pacific/Aucklandpopulated place
2189777HoropitoNZManawatu-WanganuiRuapehu District-39.35175.383330Pacific/Aucklandpopulated place
2184477PohokuraNZTaranakiStratford District-39.16938174.671740Pacific/Aucklandpopulated place
2179198WhatanihiNZMarlboroughMarlborough District-41.23333173.850Pacific/Aucklandpopulated place
6618896Cooks BeachNZWaikatoThames-Coromandel District-36.83828175.744510Pacific/Aucklandpopulated place
2188706Komata NorthNZWaikatoHauraki District-37.33333175.666670Pacific/Aucklandpopulated place
2187406ManukauNZNorthlandFar North District-35.23333173.216670Pacific/Aucklandpopulated place
2187170MatatokiNZWaikatoThames-Coromandel District-37.21667175.616670Pacific/Aucklandpopulated place
2193765Ashley ClintonNZHawke’s BayCentral Hawke’s Bay District-39.95176.250Pacific/Aucklandpopulated place
2185785Okains BayOkainsNZCanterburyChristchurch City-43.71667173.033330Pacific/Aucklandpopulated place
2192391ChattonNZSouthlandGore District-45.98333168.916670Pacific/Aucklandpopulated place
2190705Massey GlenNZWaikatoWaikato District-37.68333175.066670Pacific/Aucklandpopulated place
2182020TainuiNZWest CoastWestland District-42.76667170.916670Pacific/Aucklandpopulated place
2182524SouthbrookNZCanterburyWaimakariri District-43.33333172.60Pacific/Aucklandpopulated place
2183681RapahoeNZWest CoastGrey District-42.36667171.250Pacific/Aucklandpopulated place
2184343Potters CreekNZWest CoastWestland District-43.35170.216670Pacific/Aucklandpopulated place
6248934Riverton/AparimaNZSouthlandSouthland District-46.34842168.010080Pacific/Aucklandpopulated place
2186503MotupipiNZTasmanTasman District-40.85172.850Pacific/Aucklandpopulated place
2187813ManaroaNZMarlboroughMarlborough District-41.11667174.033330Pacific/Aucklandpopulated place
2185863OhauNZManawatu-WanganuiHorowhenua District-40.66667175.250Pacific/Aucklandpopulated place
2189616HurleyvilleNZTaranakiSouth Taranaki District-39.63333174.50Pacific/Aucklandpopulated place
2180158Waimea WestNZTasmanTasman District-41.33333173.10Pacific/Aucklandpopulated place
2189347KaawaNZWaikatoWaikato District-37.51082174.883630Pacific/Aucklandpopulated place
2185259OtokiaNZOtagoDunedin City-45.95170.20Pacific/Aucklandpopulated place
2193627BainesseNZManawatu-WanganuiManawatu District-40.41004175.379870Pacific/Aucklandpopulated place
2187469MangawhataNZManawatu-WanganuiManawatu District-40.4175.433330Pacific/Aucklandpopulated place
2179856WaitaneNZSouthlandSouthland District-46.18333168.70Pacific/Aucklandpopulated place
2192614CardiffNZTaranakiStratford District-39.36667174.233330Pacific/Aucklandpopulated place
2189146KakanuiNZOtago-45.18333170.9443Pacific/Aucklandpopulated place
2187175MatataNZBay of PlentyWhakatane District-37.88333176.75681Pacific/Aucklandpopulated place
2207740TakapunaNZAucklandAuckland-36.79167174.775838900Pacific/Aucklandpopulated place
2185448Orere PointNZAucklandAuckland-36.96667175.25345Pacific/Aucklandpopulated place
2184373Port CraigNZSouthlandSouthland District-46.21667167.350Pacific/Aucklandpopulated place
2179627Warwick JunctionNZWest CoastBuller District-42.13333172.233330Pacific/Aucklandpopulated place
2193473BecksNZOtagoCentral Otago District-45169.733330Pacific/Aucklandpopulated place
2192380CheviotMackenzie,McKenzieNZCanterburyHurunui District-42.81667173.26667425Pacific/Aucklandpopulated place
2189630HuntervilleHunterville Town DistrictNZManawatu-WanganuiRangitikei District-39.93656175.56835411Pacific/Aucklandpopulated place
2189921HinueraNZWaikatoMatamata-Piako District-37.88333175.766670Pacific/Aucklandpopulated place
2188689KoputaroaNZManawatu-WanganuiHorowhenua District-40.57785175.338360Pacific/Aucklandpopulated place
2184811PatangataNZHawke’s BayCentral Hawke’s Bay District-39.91667176.716670Pacific/Aucklandpopulated place
2188851KikiwaNZTasmanTasman District-41.65172.866670Pacific/Aucklandpopulated place
2188737KohuratahiNZTaranakiStratford District-39.0899174.774410Pacific/Aucklandpopulated place
2179241WharekuriNZCanterbury-44.69971170.435140Pacific/Aucklandpopulated place
2181589Te AwangaNZHawke’s BayHastings District-39.63333176.98333768Pacific/Aucklandpopulated place
6232192New LynnNZAucklandAuckland-36.90694174.6870421670Pacific/Aucklandpopulated place
2180928TotaraTotaratahiNZOtago-45.13333170.866670Pacific/Aucklandpopulated place
2185434OrmondvilleNZManawatu-WanganuiTararua District-40.10906176.264050Pacific/Aucklandpopulated place
2179417WhakamaramaNZBay of PlentyWestern Bay of Plenty District-37.733331760Pacific/Aucklandpopulated place
2194046AlbanyAlbani,Albany Village,Okahukura,Olmpani,Ōkahukura,Όλμπανι,Албани,البانی، نیوزی لینڈNZAucklandAuckland-36.71667174.710850Pacific/Aucklandpopulated place
2206359Hawerahauera,havera,ჰავერა,ハウェラNZTaranakiSouth Taranaki District-39.59167174.2833310400Pacific/Aucklandpopulated place
2186367MurimotuNZManawatu-WanganuiRangitikei District-39.55175.683330Pacific/Aucklandpopulated place
2184078PuketapuNZHawke’s BayHastings District-39.51667176.80Pacific/Aucklandpopulated place
2191913DarfieldHorndonNZCanterburySelwyn District-43.48333172.116673120Pacific/Aucklandpopulated place

FaQ about New Zealand

Once you have placed your order, you can download the product straight away! You'll also immediately receive an order confirmation email in which you can download your product. Remember to check your spam.
Don't panic, just log back in to the site and click on "your account" in the menu. You'll be able to find all your orders and re-download them whenever you like.
Yes, of course, click here to retrieve an archive containing an extract of the 4 CSV, XML, JSON and SQL files for a country.
Absolutely! You can pay with paypal or stripe in total security.
  • Geoname_ID: This is a unique identifier for each place or geographical name in the Geoname database.
  • City: The name of the place, which can be a town, village or any other form of human settlement.
  • Alternate_Name: Other names or appellations that the place may have. These alternative names may be in different languages, dialects or even local names.
  • Country_Code: This is the ISO 3166-1 alpha-2 code for the country in which the place is located. For example, "US" for the United States, "FR" for France.
  • Region: This represents the first-order administrative division in which the location is situated. For example, this could be a state, province or territory.
  • Sub_region: This is a second-order administrative division, such as a county or district, within the region.
  • Latitude: The geographical latitude of the location, usually in decimal degrees.
  • Longitude: The geographical longitude of the location, also usually in decimal degrees.
  • Elevation: The elevation or altitude of the location in relation to sea level, usually measured in metres.
  • Population: The estimated number of inhabitants or population of the location.
  • Timezone: The time zone in which the location is located, in accordance with global time zone standards.
  • Fcode_Name: This is a code that categorises the type of location. For example, "PPL" could mean a populated place, while "PPLC" could be the capital of a political entity.
You will retrieve a .rar archive containing the country files in csv, sql, xml and json formats.
Yes, you'll be able to download the content you've purchased whenever you want, with no time limit.
Make sure your Internet connection is stable, as some files can be quite large and take a long time to download.
Unfortunately we don't offer files in excel format, but it's really very easy to convert a csv file into excel. There are a plethora of free online sites that allow you to do this, here are a few: click here to convert csv to excel

List of countries :

h2020-flow.eu

With the aim of delivering reliable information, based on quality sources such as Geoname, we, a team of passionate geographers, have created this site. To enable you to obtain databases at very competitive prices.