Generates a list of all the suburbs and regions (with lat/lngs in NZ). Uses a timeout interval to prevent issues with the google geocoder. If you're too lazy to wait for that script to run, the SQL is attached below. I accept no responsibility for the acc

export.sql

# ************************************************************
# Sequel Pro SQL dump
# Version 3348
#
# http://www.sequelpro.com/
# http://code.google.com/p/sequel-pro/
#
# Host: localhost (MySQL 5.1.54)
# Generation Time: 2011-07-10 19:08:36 +1200
# ************************************************************


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


# Dump of table Locality
# ------------------------------------------------------------

CREATE TABLE `Locality` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Type` enum('Region','District','Suburb') CHARACTER SET utf8 DEFAULT 'Region',
  `Title` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `RegionID` int(11) NOT NULL DEFAULT '0',
  `DistrictID` int(11) NOT NULL DEFAULT '0',
  `Lat` float NOT NULL DEFAULT '0',
  `Lng` float NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `RegionID` (`RegionID`),
  KEY `DistrictID` (`DistrictID`)
) ENGINE=MyISAM AUTO_INCREMENT=5740 DEFAULT CHARSET=latin1;

LOCK TABLES `Locality` WRITE;
/*!40000 ALTER TABLE `Locality` DISABLE KEYS */;

INSERT INTO `Locality` (`ID`, `Type`, `Title`, `RegionID`, `DistrictID`, `Lat`, `Lng`)
VALUES
	(34,'Region','Northland',0,0,-35.5795,173.762),
	(35,'Region','Auckland',0,0,-36.8485,174.763),
	(48,'Region','Coromandel',0,0,-36.7613,175.498),
	(36,'Region','Waikato',0,0,-37.7467,175.421),
	(37,'Region','Bay of Plenty',0,0,-38.0933,176.419),
	(38,'Region','Gisborne',0,0,-38.6623,178.018),
	(55,'Region','Central North Island',0,0,-36.0083,174.263),
	(39,'Region','Hawkes Bay',0,0,-39.7712,176.742),
	(40,'Region','Taranaki',0,0,-39.3538,174.438),
	(56,'Region','Manawatu / Wanganui',0,0,-40.2245,175.569),
	(52,'Region','Wairarapa',0,0,-41.2129,175.241),
	(42,'Region','Wellington',0,0,-41.2925,174.773),
	(43,'Region','Nelson & Bays',0,0,-41.269,173.284),
	(44,'Region','West Coast',0,0,-42.4064,171.691),
	(51,'Region','Marlborough',0,0,-41.5727,173.422),
	(45,'Region','Canterbury',0,0,-43.7542,171.164),
	(50,'Region','Central Otago / Lakes District',0,0,-45.2828,169.657),
	(46,'Region','Otago',0,0,-44.828,169.635),
	(47,'Region','Southland',0,0,-45.8489,167.676),
	(220,'District','Far North',34,0,-35.3799,174.065),
	(221,'District','Kaipara',34,0,-35.9409,173.868),
	(222,'District','Whangarei',34,0,-35.7251,174.324),
	(225,'District','Auckland City',35,0,-36.8485,174.763),
	(224,'District','Franklin',35,0,-37.2019,174.902),
	(294,'District','Hauraki Gulf Islands',35,0,-41.7009,172.907),
	(223,'District','Manukau City',35,0,-36.9941,174.873),
	(226,'District','North Shore City',35,0,-36.7863,174.757),
	(227,'District','Papakura',35,0,-37.0677,174.944),
	(228,'District','Rodney',35,0,-36.5877,174.687),
	(297,'District','Waiheke Island',35,0,-36.7995,175.096),
	(230,'District','Waitakere City',35,0,-36.877,174.612),
	(239,'District','Hauraki',48,0,-36.4263,175.189),
	(229,'District','Thames-Coromandel',48,0,-36.7613,175.498),
	(237,'District','Hamilton City',36,0,-37.787,175.279),
	(238,'District','Matamata-Piako',36,0,-37.8289,175.769),
	(236,'District','Otorohanga',36,0,-38.1888,175.21),
	(235,'District','South Waikato',36,0,-38.2184,175.87),
	(234,'District','Waikato',36,0,-37.7467,175.421),
	(231,'District','Waipa',36,0,-37.9781,175.52),
	(232,'District','Waitomo',36,0,-38.2333,175.044),
	(240,'District','Kawerau',37,0,-38.0846,176.699),
	(241,'District','Opotiki',37,0,-38.0072,177.287),
	(242,'District','Rotorua',37,0,-38.1368,176.25),
	(243,'District','Tauranga',37,0,-37.6878,176.165),
	(244,'District','Western Bay Of Plenty',37,0,-37.7826,176.323),
	(245,'District','Whakatane',37,0,-37.965,176.974),
	(246,'District','Gisborne',38,0,-38.6623,178.018),
	(257,'District','Ruapehu',55,0,-38.6871,176.072),
	(233,'District','Taupo',55,0,-38.6857,176.07),
	(248,'District','Central Hawkes Bay',39,0,-39.9962,176.557),
	(247,'District','Hastings',39,0,-39.6396,176.839),
	(249,'District','Napier City',39,0,-39.4928,176.912),
	(250,'District','Wairoa',39,0,-39.0352,177.418),
	(253,'District','New Plymouth',40,0,-39.0556,174.075),
	(251,'District','South Taranaki',40,0,-39.5866,174.251),
	(252,'District','Stratford',40,0,-39.3371,174.284),
	(260,'District','Horowhenua',56,0,-40.3854,175.713),
	(259,'District','Manawatu',56,0,-40.2245,175.569),
	(255,'District','Palmerston North City',56,0,-40.3523,175.608),
	(254,'District','Rangitikei',56,0,-40.0007,175.584),
	(258,'District','Wanganui',56,0,-39.7273,175.438),
	(264,'District','Carterton',52,0,-41.0292,175.524),
	(262,'District','Masterton',52,0,-40.9469,175.674),
	(267,'District','South Wairarapa',52,0,-41.2129,175.241),
	(256,'District','Tararua',52,0,-41.2129,175.241),
	(261,'District','Kapiti Coast',42,0,-40.9192,174.983),
	(263,'District','Lower Hutt City',42,0,-41.2092,174.908),
	(268,'District','Porirua City',42,0,-41.1339,174.841),
	(266,'District','Upper Hutt City',42,0,-41.1333,175.051),
	(265,'District','Wellington City',42,0,-41.2925,174.773),
	(271,'District','Nelson',43,0,-41.269,173.284),
	(269,'District','Tasman',43,0,-41.269,173.284),
	(274,'District','Buller',44,0,-41.746,171.684),
	(273,'District','Grey',44,0,-42.4781,171.604),
	(275,'District','Westland',44,0,-42.7123,170.971),
	(272,'District','Kaikoura',51,0,-42.4008,173.681),
	(270,'District','Marlborough',51,0,-41.5727,173.422),
	(281,'District','Ashburton',45,0,-43.9084,171.749),
	(280,'District','Banks Peninsula',45,0,-43.75,173),
	(282,'District','Christchurch City',45,0,-43.5321,172.636),
	(283,'District','Hurunui',45,0,-42.8797,172.754),
	(284,'District','Mackenzie',45,0,-44.2824,170.089),
	(279,'District','Selwyn',45,0,-43.6411,172.475),
	(278,'District','Timaru',45,0,-44.397,171.255),
	(276,'District','Waimakariri',45,0,-43.3041,172.59),
	(277,'District','Waimate',45,0,-44.7326,171.048),
	(287,'District','Central Otago',50,0,-45.2273,169.374),
	(288,'District','Queenstown-Lakes District',50,0,-44.828,169.635),
	(285,'District','Clutha',46,0,-46.239,169.737),
	(286,'District','Dunedin City',46,0,-45.8788,170.503),
	(289,'District','Waitaki',46,0,-45.098,170.971),
	(291,'District','Gore',47,0,-46.0988,168.946),
	(292,'District','Invercargill City',47,0,-46.4131,168.364),
	(290,'District','Southland',47,0,-45.8627,167.974),
	(5129,'Suburb','Tongaporutu',40,253,-38.8198,174.598),
	(5128,'Suburb','Tikorangi',40,253,-39.0338,174.28),
	(5127,'Suburb','Tarurutangi',40,253,-39.0796,174.174),
	(5126,'Suburb','Tarata',40,253,-39.1517,174.364),
	(5125,'Suburb','Strandon',40,253,-39.0538,174.094),
	(5124,'Suburb','Spotswood',40,253,-39.0722,174.035),
	(5123,'Suburb','Omata',40,253,-39.0936,174.02),
	(5122,'Suburb','Okoki',40,253,-39.0132,174.485),
	(5121,'Suburb','Okato',40,253,-39.1918,173.879),
	(5120,'Suburb','Oakura',40,253,-39.1146,173.953),
	(5119,'Suburb','New Plymouth Coastal',40,253,-39.0433,174.1),
	(5118,'Suburb','New Plymouth City Surrounds',40,253,-39.0556,174.075),
	(5117,'Suburb','New Plymouth Central',40,253,-39.0563,174.076),
	(5116,'Suburb','New Plymouth Area Surrounds',40,253,-39.0556,174.075),
	(5115,'Suburb','Moturoa',40,253,-39.0643,174.035),
	(5114,'Suburb','Motumahanga (Saddleback)',40,253,-39.0556,174.075),
	(5113,'Suburb','Mokau',40,253,-38.9272,174.542),
	(5112,'Suburb','Merrilands',40,253,-39.0678,174.098),
	(5111,'Suburb','Marfell',40,253,-39.0763,174.044),
	(5110,'Suburb','Lynmouth',40,253,-39.0638,174.054),
	(5109,'Suburb','Lepperton',40,253,-39.0604,174.21),
	(5108,'Suburb','Inglewood',40,253,-39.1559,174.206),
	(5107,'Suburb','Hurworth',40,253,-39.1335,174.069),
	(5106,'Suburb','Hurdon',40,253,-39.0872,174.053),
	(5105,'Suburb','Hillsborough',40,253,-39.0712,174.143),
	(5104,'Suburb','Highlands Park',40,253,-39.0802,174.1),
	(5103,'Suburb','Glen Avon',40,253,-39.0547,174.109),
	(5102,'Suburb','Frankleigh Park',40,253,-39.0799,174.07),
	(5101,'Suburb','Fitzroy',40,253,-39.0494,174.102),
	(5100,'Suburb','Ferndale',40,253,-39.0858,174.065),
	(5099,'Suburb','Egmont Village',40,253,-39.1456,174.145),
	(5098,'Suburb','Brooklands',40,253,-39.0734,174.082),
	(5097,'Suburb','Blagdon',40,253,-39.0675,174.042),
	(5096,'Suburb','Bell Block',40,253,-39.0359,174.146),
	(5095,'Suburb','Wairoa Country',39,250,-39.0352,177.418),
	(5094,'Suburb','Wairoa',39,250,-39.0352,177.418),
	(5093,'Suburb','Tuai/Ohuka',39,250,-38.8117,177.148),
	(5092,'Suburb','Ruakituri',39,250,-38.7699,177.41),
	(5091,'Suburb','Raupunga',39,250,-39.0744,177.146),
	(5090,'Suburb','Nuhaka/Morere',39,250,-39.0425,177.741),
	(5089,'Suburb','Mahia',39,250,-39.0866,177.917),
	(5088,'Suburb','Kotemaori',39,250,-39.0618,177.041),
	(5087,'Suburb','Westshore',39,249,-39.4778,176.882),
	(5086,'Suburb','Te Awa',39,249,-39.5114,176.915),
	(5085,'Suburb','Taradale',39,249,-39.5366,176.849),
	(5084,'Suburb','Tamatea',39,249,-39.5114,176.869),
	(5083,'Suburb','Puketapu',39,249,-39.5097,176.79),
	(5082,'Suburb','Poraiti',39,249,-39.4892,176.836),
	(5081,'Suburb','Pirimai',39,249,-39.5132,176.883),
	(5080,'Suburb','Pandora',39,249,-39.4892,176.889),
	(5079,'Suburb','Onekawa',39,249,-39.5084,176.89),
	(5078,'Suburb','Napier Port',39,249,-39.4769,176.915),
	(5077,'Suburb','Napier Hill',39,249,-39.5343,176.868),
	(5076,'Suburb','Napier City Surrounds',39,249,-39.4928,176.912),
	(5075,'Suburb','Napier Central',39,249,-39.5592,176.854),
	(5074,'Suburb','Meeanee',39,249,-39.5432,176.888),
	(5073,'Suburb','Marewa',39,249,-39.5007,176.902),
	(5072,'Suburb','Maraenui',39,249,-39.515,176.904),
	(5071,'Suburb','Jervoistown',39,249,-39.5398,176.865),
	(5070,'Suburb','Greenmeadows',39,249,-39.5256,176.862),
	(5069,'Suburb','Bluff Hill',39,249,-39.4849,176.913),
	(5068,'Suburb','Bay View',39,249,-39.4204,176.867),
	(5067,'Suburb','Awatoto',39,249,-39.5448,176.919),
	(5066,'Suburb','Ahuriri',39,249,-39.4809,176.898),
	(5065,'Suburb','Woolwich',39,247,-39.6162,176.802),
	(5064,'Suburb','Whanawhana',39,247,-39.5432,176.437),
	(5063,'Suburb','Whakatu',39,247,-39.6037,176.892),
	(5062,'Suburb','Waiwhare',39,247,-39.4377,176.48),
	(5061,'Suburb','Waipatu',39,247,-39.6295,176.873),
	(5060,'Suburb','Waimarama',39,247,-39.8159,176.989),
	(5059,'Suburb','Twyford',39,247,-39.6012,176.796),
	(5058,'Suburb','Tutira',39,247,-39.2077,176.881),
	(5057,'Suburb','Tomoana',39,247,-39.6094,176.863),
	(5056,'Suburb','Te Haroto',39,247,-39.1253,176.606),
	(5055,'Suburb','Te Awanga',39,247,-39.6337,176.98),
	(5054,'Suburb','Tangoio',39,247,-39.3261,176.908),
	(5053,'Suburb','Sherenden',39,247,-39.5051,176.575),
	(5052,'Suburb','Saint Leonards',39,247,-39.6334,176.834),
	(5051,'Suburb','Roys Hill',39,247,-39.6252,176.724),
	(5050,'Suburb','Raureka',39,247,-39.6447,176.828),
	(5049,'Suburb','Puketitiri',39,247,-39.2824,176.538),
	(5048,'Suburb','Poukawa',39,247,-39.761,176.727),
	(5047,'Suburb','Parkvale',39,247,-39.6509,176.859),
	(5046,'Suburb','Pakowhai',39,247,-39.5804,176.866),
	(5045,'Suburb','Pakipaki',39,247,-39.691,176.794),
	(5044,'Suburb','Otamauri',39,247,-39.5022,176.5),
	(5043,'Suburb','Omahu',39,247,-39.5819,176.756),
	(5042,'Suburb','Mayfair',39,247,-39.6364,176.856),
	(5041,'Suburb','Maraekakaho',39,247,-39.6517,176.618),
	(5040,'Suburb','Mangateretere',39,247,-39.6174,176.893),
	(5039,'Suburb','Mahora',39,247,-39.6279,176.85),
	(5038,'Suburb','Longlands',39,247,-39.6669,176.815),
	(5037,'Suburb','Kuripapango',39,247,-39.3954,176.33),
	(5036,'Suburb','Karamu',39,247,-39.6355,176.879),
	(5035,'Suburb','Hawkes Bay Area',39,247,-39.6396,176.839),
	(5034,'Suburb','Havelock North',39,247,-39.6704,176.876),
	(5033,'Suburb','Haumoana',39,247,-39.6035,176.947),
	(5032,'Suburb','Hastings Country',39,247,-39.6396,176.839),
	(5031,'Suburb','Hastings',39,247,-39.6396,176.839),
	(5030,'Suburb','Frimley',39,247,-39.6218,176.827),
	(5029,'Suburb','Flaxmere',39,247,-39.6215,176.784),
	(5028,'Suburb','Fernhill',39,247,-39.5896,176.762),
	(5027,'Suburb','Eskdale',39,247,-39.3948,176.845),
	(5026,'Suburb','Dartmoor',39,247,-39.4812,176.696),
	(5025,'Suburb','Crownthorpe',39,247,-39.5546,176.667),
	(5024,'Suburb','Clive',39,247,-39.5837,176.916),
	(5023,'Suburb','Camberley',39,247,-39.6282,176.822),
	(5022,'Suburb','Bridge Pa',39,247,-39.6495,176.757),
	(5021,'Suburb','Akina',39,247,-39.651,176.845),
	(5020,'Suburb','Waipukurau and Surrounds',39,248,-39.9962,176.557),
	(5019,'Suburb','Waipawa',39,248,-39.9416,176.59),
	(5018,'Suburb','Porangahau',39,248,-40.3019,176.612),
	(5017,'Suburb','Otane',39,248,-39.8966,176.628),
	(5016,'Suburb','Ormondville',39,248,-40.1102,176.265),
	(5015,'Suburb','Ongaonga',39,248,-39.9135,176.419),
	(5014,'Suburb','Mangaorapa',39,248,-40.2929,176.505),
	(5013,'Suburb','Elsthorpe',39,248,-39.9167,176.815),
	(5012,'Suburb','Central Hawkes Bay Country',39,248,-39.9962,176.557),
	(5011,'Suburb','Central Hawkes Bay Coastal',39,248,-39.9962,176.557),
	(5010,'Suburb','Wharewaka',55,233,-38.7412,176.082),
	(5009,'Suburb','Waitahanui',55,233,-38.7412,176.082),
	(5008,'Suburb','Wairakei and Surrounds',55,233,-38.6857,176.07),
	(5007,'Suburb','Turangi',55,233,-38.7931,175.971),
	(5006,'Suburb','Taupo Surrounds',55,233,-38.6857,176.07),
	(5005,'Suburb','Taupo',55,233,-38.6857,176.07),
	(5004,'Suburb','Tauhara',55,233,-38.6859,176.071),
	(5003,'Suburb','Tahorakuri',55,233,-38.6857,176.07),
	(5002,'Suburb','Richmond Heights',55,233,-38.6859,176.071),
	(5001,'Suburb','Omori',55,233,-38.7931,175.971),
	(5000,'Suburb','Nukuhau',55,233,-38.6859,176.071),
	(4999,'Suburb','Maunganamu',55,233,-38.7412,176.082),
	(4998,'Suburb','Mangakino',55,233,-38.6857,176.07),
	(4997,'Suburb','Lake Taupo (West)',55,233,-38.6859,176.071),
	(4996,'Suburb','Lake Taupo (East)',55,233,-38.6859,176.071),
	(4995,'Suburb','Lake Taupo',55,233,-38.6857,176.07),
	(4994,'Suburb','Kuratau',55,233,-38.7931,175.971),
	(4993,'Suburb','Kinloch',55,233,-38.7931,175.971),
	(4992,'Suburb','Iwitahi',55,233,-38.7412,176.082),
	(4991,'Suburb','Hilltop',55,233,-38.6859,176.071),
	(4990,'Suburb','Acacia Bay',55,233,-38.6859,176.071),
	(4989,'Suburb','Waiouru',55,257,-37.8965,175.602),
	(4988,'Suburb','Waimiha-Ongarue',55,257,-37.8965,175.602),
	(4987,'Suburb','Tongariro',55,257,-37.8965,175.602),
	(4986,'Suburb','Taumarunui',55,257,-37.8965,175.602),
	(4985,'Suburb','Ruapehu-King Country Surrounds',55,257,-37.8965,175.602),
	(4984,'Suburb','Raetihi',55,257,-37.8965,175.602),
	(4983,'Suburb','Owhango',55,257,-37.8965,175.602),
	(4982,'Suburb','Ohura',55,257,-37.8965,175.602),
	(4981,'Suburb','Ohakune',55,257,-37.8965,175.602),
	(4980,'Suburb','National Park',55,257,-37.8965,175.602),
	(4979,'Suburb','Manunui',55,257,-37.8965,175.602),
	(4978,'Suburb','Kakahi',55,257,-37.8965,175.602),
	(4977,'Suburb','Whataupoko',38,246,-38.6586,178.029),
	(4976,'Suburb','Whatatutu',38,246,-38.3825,177.834),
	(4975,'Suburb','Wainui',38,246,-38.6885,178.07),
	(4974,'Suburb','Tolaga Bay',38,246,-38.3726,178.297),
	(4973,'Suburb','Tokomaru Bay',38,246,-38.1291,178.316),
	(4972,'Suburb','Tiniroto',38,246,-38.7743,177.566),
	(4971,'Suburb','Te Karaka',38,246,-38.4695,177.866),
	(4970,'Suburb','Te Hapara',38,246,-38.6519,177.999),
	(4969,'Suburb','Te Araroa',38,246,-37.6352,178.369),
	(4968,'Suburb','Taruheru',38,246,-38.6434,177.982),
	(4967,'Suburb','Tamarau',38,246,-38.6933,178.058),
	(4966,'Suburb','Ruatoria and Surrounds',38,246,-38.6623,178.018),
	(4965,'Suburb','Riverdale',38,246,-38.6432,178.002),
	(4964,'Suburb','Pouawa',38,246,-38.6086,178.182),
	(4963,'Suburb','Patutahi',38,246,-38.6227,177.89),
	(4962,'Suburb','Outer Kaiti',38,246,-38.6736,178.051),
	(4961,'Suburb','Okitu',38,246,-38.6745,178.085),
	(4960,'Suburb','Ngatapa',38,246,-38.5857,177.793),
	(4959,'Suburb','Muriwai',38,246,-38.756,177.921),
	(4958,'Suburb','Matokitoki',38,246,-38.6224,178.006),
	(4957,'Suburb','Matawai',38,246,-38.3573,177.536),
	(4956,'Suburb','Manutuke',38,246,-38.6819,177.912),
	(4955,'Suburb','Mangapapa',38,246,-38.6456,178.014),
	(4954,'Suburb','Makaraka',38,246,-38.6494,177.965),
	(4953,'Suburb','Inner Kaiti',38,246,-38.6707,178.035),
	(4952,'Suburb','Hicks Bay',38,246,-37.5935,178.292),
	(4951,'Suburb','Hexton',38,246,-38.6141,177.975),
	(4950,'Suburb','Gisborne Country',38,246,-38.6623,178.018),
	(4949,'Suburb','Gisborne Coastal',38,246,-38.6623,178.018),
	(4948,'Suburb','Gisborne City Surrounds',38,246,-38.6623,178.018),
	(4947,'Suburb','Gisborne',38,246,-38.6623,178.018),
	(4946,'Suburb','Elgin',38,246,-38.6611,177.994),
	(4945,'Suburb','East Cape',38,246,-37.6406,178.464),
	(4944,'Suburb','Awapuni',38,246,-38.6614,177.982),
	(4943,'Suburb','Whakatane Surrounds',37,245,-37.965,176.974),
	(4942,'Suburb','Whakatane',37,245,-37.965,176.974),
	(4941,'Suburb','Waimana',37,245,-38.1425,177.073),
	(4940,'Suburb','Thornton',37,245,-37.9228,176.916),
	(4939,'Suburb','Te Teko',37,245,-38.0364,176.793),
	(4938,'Suburb','Taneatua',37,245,-38.0649,177.003),
	(4937,'Suburb','Rotoma',37,245,-38.0241,176.714),
	(4936,'Suburb','Otakiri',37,245,-37.9854,176.765),
	(4935,'Suburb','Ohope',37,245,-37.9673,177.046),
	(4934,'Suburb','Murupara and Surrounds',37,245,-37.965,176.974),
	(4933,'Suburb','Matata',37,245,-37.8869,176.751),
	(4932,'Suburb','Matahi',37,245,-38.2541,177.11),
	(4931,'Suburb','Manawahe',37,245,-38.0003,176.641),
	(4930,'Suburb','Edgecumbe',37,245,-37.9764,176.828),
	(4929,'Suburb','Coastlands',37,245,-37.934,176.973),
	(4928,'Suburb','Whakamarama',37,244,-37.7291,175.989),
	(4927,'Suburb','Western BOP Surrounds',37,244,-37.7826,176.323),
	(4926,'Suburb','Wairoa',37,244,-37.7128,176.09),
	(4925,'Suburb','Waihi Beach',37,244,-37.4124,175.945),
	(4924,'Suburb','Te Puna',37,244,-37.6958,176.073),
	(4923,'Suburb','Te Puke',37,244,-37.7862,176.325),
	(4922,'Suburb','Pukehina',37,244,-37.8228,176.525),
	(4921,'Suburb','Pongakawa',37,244,-37.8369,176.475),
	(4920,'Suburb','Paengaroa',37,244,-37.8224,176.411),
	(4919,'Suburb','Oropi',37,244,-37.8382,176.157),
	(4918,'Suburb','Omokoroa',37,244,-37.6398,176.041),
	(4917,'Suburb','Ohauiti',37,244,-37.7656,176.176),
	(4916,'Suburb','Matakana Island',37,244,-37.592,176.072),
	(4915,'Suburb','Maketu',37,244,-37.7596,176.452),
	(4914,'Suburb','Katikati',37,244,-37.5519,175.92),
	(4913,'Suburb','Kaimai',37,244,-37.8001,176.04),
	(4912,'Suburb','Athenree',37,244,-37.4452,175.962),
	(4911,'Suburb','Aongatete',37,244,-37.6092,175.944),
	(4910,'Suburb','Welcome Bay',37,243,-37.7257,176.185),
	(4909,'Suburb','Tauriko',37,243,-37.7419,176.095),
	(4908,'Suburb','Tauranga Surrounds',37,243,-37.6878,176.165),
	(4907,'Suburb','Tauranga South',37,243,-37.7052,176.155),
	(4906,'Suburb','Tauranga Central',37,243,-37.6878,176.165),
	(4905,'Suburb','Pyes Pa',37,243,-37.8141,176.125),
	(4904,'Suburb','Poike',37,243,-37.7323,176.15),
	(4903,'Suburb','Parkvale',37,243,-37.7244,176.144),
	(4902,'Suburb','Papamoa',37,243,-37.7329,176.298),
	(4901,'Suburb','Otumoetai',37,243,-37.6701,176.15),
	(4900,'Suburb','Mount Maunganui',37,243,-37.6387,176.184),
	(4899,'Suburb','Maungatapu',37,243,-37.7209,176.176),
	(4898,'Suburb','Matua',37,243,-37.6665,176.128),
	(4897,'Suburb','Matapihi',37,243,-37.6966,176.191),
	(4896,'Suburb','Judea',37,243,-37.6964,176.134),
	(4895,'Suburb','Hairini',37,243,-37.7265,176.168),
	(4894,'Suburb','Greerton',37,243,-37.731,176.128),
	(4893,'Suburb','Gate Pa',37,243,-37.7109,176.146),
	(4892,'Suburb','Brookfield',37,243,-37.6898,176.136),
	(4891,'Suburb','Bethlehem',37,243,-37.7008,176.113),
	(4890,'Suburb','Bellevue',37,243,-37.6825,176.129),
	(4889,'Suburb','Avenues',37,243,-37.6878,176.165),
	(4888,'Suburb','Whakarewarewa',37,242,-38.1628,176.251),
	(4887,'Suburb','Western Heights',37,242,-38.1261,176.213),
	(4886,'Suburb','Westbrook',37,242,-38.1521,176.215),
	(4885,'Suburb','Waikite Valley',37,242,-38.3388,176.271),
	(4884,'Suburb','Victoria',37,242,-38.1446,176.25),
	(4883,'Suburb','Utuhina',37,242,-38.1436,176.231),
	(4882,'Suburb','Tikitere',37,242,-38.0654,176.359),
	(4881,'Suburb','Tihiotonga',37,242,-38.1725,176.243),
	(4880,'Suburb','Springfield',37,242,-38.1604,176.236),
	(4879,'Suburb','Selwyn Heights',37,242,-38.1179,176.221),
	(4878,'Suburb','Rotorua Surrounds',37,242,-38.1368,176.25),
	(4877,'Suburb','Rotorua Central',37,242,-38.1368,176.25),
	(4876,'Suburb','Rotoiti Forest',37,242,-38.0539,176.473),
	(4875,'Suburb','Rerewhakaaitu',37,242,-38.316,176.495),
	(4874,'Suburb','Reporoa and Surrounds',37,242,-38.1368,176.25),
	(4873,'Suburb','Pukehangi',37,242,-38.1363,176.208),
	(4872,'Suburb','Owhata',37,242,-38.1324,176.298),
	(4871,'Suburb','Okere Falls',37,242,-38.017,176.345),
	(4870,'Suburb','Ohinemutu',37,242,-38.1273,176.246),
	(4869,'Suburb','Ngongotaha',37,242,-38.0809,176.213),
	(4868,'Suburb','Ngapuna',37,242,-38.1467,176.275),
	(4867,'Suburb','Ngakuru',37,242,-38.3212,176.193),
	(4866,'Suburb','Mourea',37,242,-38.0483,176.329),
	(4865,'Suburb','Mangakakahi',37,242,-38.1333,176.234),
	(4864,'Suburb','Mamaku',37,242,-38.0927,176.079),
	(4863,'Suburb','Lynmore',37,242,-38.1454,176.286),
	(4862,'Suburb','Lake Tarawera',37,242,-38.2081,176.366),
	(4861,'Suburb','Lake Rotoma',37,242,-38.0479,176.557),
	(4860,'Suburb','Lake Okareka',37,242,-38.17,176.345),
	(4859,'Suburb','Lake Areas',37,242,-38.1368,176.25),
	(4858,'Suburb','Koutu',37,242,-38.1196,176.238),
	(4857,'Suburb','Kawaha Point',37,242,-38.1107,176.237),
	(4856,'Suburb','Horohoro',37,242,-38.2373,176.169),
	(4855,'Suburb','Holdens Bay',37,242,-38.1195,176.303),
	(4854,'Suburb','Hillcrest',37,242,-38.1495,176.236),
	(4853,'Suburb','Hannahs Bay',37,242,-38.1169,176.307),
	(4852,'Suburb','Hamurana',37,242,-38.0332,176.263),
	(4851,'Suburb','Glenholme',37,242,-38.1486,176.247),
	(4850,'Suburb','Fordlands',37,242,-38.1444,176.224),
	(4849,'Suburb','Fenton Park',37,242,-38.1512,176.259),
	(4848,'Suburb','Fairy Springs',37,242,-38.1185,176.228),
	(4847,'Suburb','Broadlands',37,242,-38.5122,176.332),
	(4846,'Suburb','Atiamuri',37,242,-38.3511,176.128),
	(4845,'Suburb','Waihau Bay',37,241,-37.6179,177.909),
	(4844,'Suburb','Te Kaha',37,241,-37.7399,177.676),
	(4843,'Suburb','Opotiki Surrounds',37,241,-38.0072,177.287),
	(4842,'Suburb','Opotiki Coastal',37,241,-38.0072,177.287),
	(4841,'Suburb','Opotiki and Surrounds',37,241,-38.0072,177.287),
	(4840,'Suburb','Kawerau',37,240,-38.0846,176.699),
	(4839,'Suburb','Waitomo',36,232,-38.2333,175.044),
	(4838,'Suburb','Te Kuiti',36,232,-38.333,175.163),
	(4837,'Suburb','Piopio',36,232,-38.4658,175.017),
	(4836,'Suburb','Marokopa',36,232,-38.3021,174.721),
	(4835,'Suburb','Mahoenui',36,232,-38.5794,174.84),
	(4834,'Suburb','Benneydale',36,232,-38.5206,175.361),
	(4833,'Suburb','Awakino',36,232,-38.6531,174.629),
	(4832,'Suburb','Aria',36,232,-38.5571,174.983),
	(4831,'Suburb','Wharepapa South',36,231,-38.1435,175.534),
	(4830,'Suburb','Waipa Surrounds',36,231,-37.9781,175.52),
	(4829,'Suburb','Tokanui',36,231,-38.0591,175.316),
	(4828,'Suburb','Te Pahu',36,231,-37.9352,175.173),
	(4827,'Suburb','Te Miro',36,231,-37.8076,175.546),
	(4826,'Suburb','Te Awamutu',36,231,-38.0059,175.313),
	(4825,'Suburb','Rukuhia',36,231,-37.8522,175.306),
	(4824,'Suburb','Rotoorangi',36,231,-37.9788,175.46),
	(4823,'Suburb','Pirongia',36,231,-37.9958,175.203),
	(4822,'Suburb','Ohaupo',36,231,-37.9185,175.307),
	(4821,'Suburb','Ngahinapouri',36,231,-37.8972,175.206),
	(4820,'Suburb','Leamington',36,231,-37.9078,175.475),
	(4819,'Suburb','Kihikihi',36,231,-38.0374,175.345),
	(4818,'Suburb','Cambridge',36,231,-37.8911,175.467),
	(4817,'Suburb','Whitikahu',36,234,-37.6126,175.345),
	(4816,'Suburb','Whatawhata',36,234,-37.7978,175.154),
	(4815,'Suburb','Waiterimu',36,234,-37.4733,175.274),
	(4814,'Suburb','Waikato Surrounds',36,234,-37.7467,175.421),
	(4813,'Suburb','Waerenga',36,234,-37.3683,175.245),
	(4812,'Suburb','Te Kowhai',36,234,-37.7383,175.154),
	(4811,'Suburb','Te Kauwhata',36,234,-37.404,175.144),
	(4810,'Suburb','Te Hoe',36,234,-37.5138,175.335),
	(4809,'Suburb','Te Akau',36,234,-37.6783,174.852),
	(4808,'Suburb','Taupiri',36,234,-37.6122,175.187),
	(4807,'Suburb','Ruawaro',36,234,-37.5276,175.041),
	(4806,'Suburb','Rotongaro',36,234,-37.5344,175.085),
	(4805,'Suburb','Rangiriri West',36,234,-37.4364,175.131),
	(4804,'Suburb','Rangiriri',36,234,-37.4306,175.131),
	(4803,'Suburb','Raglan',36,234,-37.8014,174.872),
	(4802,'Suburb','Orini',36,234,-37.5558,175.309),
	(4801,'Suburb','Ngaruawahia',36,234,-37.6674,175.149),
	(4800,'Suburb','Meremere',36,234,-37.319,175.069),
	(4799,'Suburb','Maramarua',36,234,-37.2508,175.229),
	(4798,'Suburb','Huntly',36,234,-37.5573,175.159),
	(4797,'Suburb','Horotiu',36,234,-37.6999,175.197),
	(4796,'Suburb','Hampton Downs',36,234,-37.3558,175.082),
	(4795,'Suburb','Gordonton',36,234,-37.6708,175.306),
	(4794,'Suburb','Glen Massey',36,234,-37.6727,175.076),
	(4793,'Suburb','Eureka',36,234,-37.7467,175.421),
	(4792,'Suburb','Churchill',36,234,-37.4227,175.074),
	(4791,'Suburb','Tokoroa',36,235,-38.218,175.871),
	(4790,'Suburb','Tirau',36,235,-37.9783,175.757),
	(4789,'Suburb','Tapapa',36,235,-37.9868,175.842),
	(4788,'Suburb','South Waikato Surrounds',36,235,-38.2184,175.87),
	(4787,'Suburb','Putaruru',36,235,-38.049,175.78),
	(4786,'Suburb','Lichfield',36,235,-38.1088,175.82),
	(4785,'Suburb','Kinleith',36,235,-38.2777,175.881),
	(4784,'Suburb','Taharoa',36,236,-38.1507,174.739),
	(4783,'Suburb','Otorohanga Surrounds',36,236,-38.1888,175.21),
	(4782,'Suburb','Otorohanga',36,236,-38.1888,175.21),
	(4781,'Suburb','Oparau',36,236,-38.0497,174.927),
	(4780,'Suburb','Maihiihi',36,236,-38.2146,175.384),
	(4779,'Suburb','Kawhia',36,236,-38.0685,174.816),
	(4778,'Suburb','Wardville',36,238,-37.7148,175.787),
	(4777,'Suburb','Waitoa',36,238,-37.5987,175.632),
	(4776,'Suburb','Waharoa',36,238,-37.7603,175.753),
	(4775,'Suburb','Turangaomoana',36,238,-37.7579,175.826),
	(4774,'Suburb','Te Poi',36,238,-37.8725,175.843),
	(4773,'Suburb','Te Aroha',36,238,-37.5426,175.712),
	(4772,'Suburb','Tahuna',36,238,-37.5014,175.494),
	(4771,'Suburb','Richmond Downs',36,238,-37.7866,175.666),
	(4770,'Suburb','Okauia',36,238,-37.7885,175.839),
	(4769,'Suburb','Ngarua',36,238,-37.6709,175.677),
	(4768,'Suburb','Morrinsville',36,238,-37.6572,175.53),
	(4767,'Suburb','Matamata',36,238,-37.8109,175.776),
	(4766,'Suburb','Manawaru',36,238,-37.6333,175.765),
	(4765,'Suburb','Gordon',36,238,-37.6917,175.822),
	(4764,'Suburb','Whitiora',36,237,-37.7775,175.274),
	(4763,'Suburb','Western Heights',36,237,-37.7906,175.23),
	(4762,'Suburb','Temple View',36,237,-37.8217,175.226),
	(4761,'Suburb','Te Rapa Park',36,237,-37.7395,175.222),
	(4760,'Suburb','Te Rapa',36,237,-37.7577,175.246),
	(4759,'Suburb','Tauwhare',36,237,-37.8225,175.374),
	(4758,'Suburb','Tamahere',36,237,-37.355,174.76),
	(4757,'Suburb','Silverdale',36,237,-37.7997,175.327),
	(4756,'Suburb','Saint Andrews',36,237,-37.7523,175.255),
	(4755,'Suburb','Ruakura',36,237,-37.7753,175.31),
	(4754,'Suburb','Rototuna North',36,237,-37.7306,175.266),
	(4753,'Suburb','Rototuna',36,237,-37.7332,175.268),
	(4752,'Suburb','Rotokauri',36,237,-37.7704,175.208),
	(4751,'Suburb','Riverlea',36,237,-37.8064,175.322),
	(4750,'Suburb','Queenwood',36,237,-37.749,175.266),
	(4749,'Suburb','Pukete',36,237,-37.7426,175.239),
	(4748,'Suburb','Puketaha',36,237,-37.72,175.328),
	(4747,'Suburb','Pukemoremore',36,237,-37.8895,175.462),
	(4746,'Suburb','Northgate',36,237,-37.7476,175.232),
	(4745,'Suburb','Newstead',36,237,-37.7829,175.351),
	(4744,'Suburb','Nawton',36,237,-37.777,175.235),
	(4743,'Suburb','Melville',36,237,-37.811,175.282),
	(4742,'Suburb','Maeroa',36,237,-37.7782,175.259),
	(4741,'Suburb','Huntington',36,237,-37.7311,175.28),
	(4740,'Suburb','Horsham Downs',36,237,-37.6993,175.249),
	(4739,'Suburb','Hillcrest',36,237,-37.7905,175.318),
	(4738,'Suburb','Harrowfield',36,237,-37.7425,175.256),
	(4737,'Suburb','Hamilton Surrounds',36,237,-37.787,175.279),
	(4736,'Suburb','Hamilton Lake',36,237,-37.7981,175.281),
	(4735,'Suburb','Hamilton East',36,237,-37.7904,175.292),
	(4734,'Suburb','Hamilton Central',36,237,-37.787,175.279),
	(4733,'Suburb','Grandview Heights',36,237,-37.7826,175.226),
	(4732,'Suburb','Glenview',36,237,-37.8231,175.29),
	(4731,'Suburb','Frankton',36,237,-37.789,175.26),
	(4730,'Suburb','Forest Lake',36,237,-37.7712,175.257),
	(4729,'Suburb','Flagstaff',36,237,-37.7397,175.255),
	(4728,'Suburb','Fitzroy',36,237,-37.8145,175.301),
	(4727,'Suburb','Fairview Downs',36,237,-37.7625,175.304),
	(4726,'Suburb','Fairfield',36,237,-37.7701,175.282),
	(4725,'Suburb','Enderley',36,237,-37.7704,175.298),
	(4724,'Suburb','Dinsdale',36,237,-37.7967,175.24),
	(4723,'Suburb','Deanwell',36,237,-37.8208,175.277),
	(4722,'Suburb','Claudelands',36,237,-37.7761,175.286),
	(4721,'Suburb','Chedworth',36,237,-37.752,175.286),
	(4720,'Suburb','Chartwell',36,237,-37.7583,175.277),
	(4719,'Suburb','Burbush',36,237,-37.7504,175.205),
	(4718,'Suburb','Beerescourt',36,237,-37.7683,175.262),
	(4717,'Suburb','Baverstock',36,237,-37.7665,175.218),
	(4716,'Suburb','Bader',36,237,-37.8087,175.293),
	(4715,'Suburb','Avalon',36,237,-37.759,175.232),
	(4714,'Suburb','Whitianga',48,229,-36.7362,175.759),
	(4713,'Suburb','Whiritoa',48,229,-37.2923,175.865),
	(4712,'Suburb','Whenuakite',48,229,-37.0683,175.664),
	(4711,'Suburb','Whangapoua',48,229,-36.7568,175.52),
	(4710,'Suburb','Whangamata',48,229,-37.2037,175.71),
	(4709,'Suburb','Whakatete Bay',48,229,-37.138,175.54),
	(4708,'Suburb','Waitete Bay',48,229,-37.3675,175.791),
	(4707,'Suburb','Waiomu',48,229,-37.0683,175.664),
	(4706,'Suburb','Waikawau',48,229,-36.5312,175.386),
	(4705,'Suburb','Tuateawa',48,229,-36.6393,175.535),
	(4704,'Suburb','Thornton Bay',48,229,-37.0683,175.664),
	(4703,'Suburb','Thames Surrounds',48,229,-36.7613,175.498),
	(4702,'Suburb','Thames Coast',48,229,-37.105,175.518),
	(4701,'Suburb','Thames',48,229,-37.138,175.54),
	(4700,'Suburb','Te Puru',48,229,-37.0683,175.664),
	(4699,'Suburb','Te Mata',48,229,-37.0683,175.664),
	(4698,'Suburb','Te Kouma',48,229,-36.8053,175.474),
	(4697,'Suburb','Tapu',48,229,-37.0683,175.664),
	(4696,'Suburb','Tairua',48,229,-37.05,175.867),
	(4695,'Suburb','Puriri',48,229,-37.2037,175.71),
	(4694,'Suburb','Port Charles',48,229,-36.5291,175.468),
	(4693,'Suburb','Pauanui',48,229,-37.0683,175.664),
	(4692,'Suburb','Opoutere',48,229,-36.7613,175.498),
	(4691,'Suburb','Opito Bay',48,229,-36.7362,175.759),
	(4690,'Suburb','Onemana',48,229,-36.7613,175.498),
	(4689,'Suburb','Motutapere Island',48,229,-36.7791,175.429),
	(4688,'Suburb','Matatoki',48,229,-37.0683,175.664),
	(4687,'Suburb','Matarangi',48,229,-36.7613,175.498),
	(4686,'Suburb','Kuaotunu',48,229,-36.7362,175.759),
	(4685,'Suburb','Kopu',48,229,-37.0683,175.664),
	(4684,'Suburb','Kaimarama',48,229,-36.8333,175.583),
	(4683,'Suburb','Hot Water Beach',48,229,-36.7613,175.498),
	(4682,'Suburb','Hikutaia',48,229,-37.2037,175.71),
	(4681,'Suburb','Hikuai',48,229,-37.0683,175.664),
	(4680,'Suburb','Hahei',48,229,-37.0683,175.664),
	(4679,'Suburb','East Coast Surrounds',48,229,-36.7613,175.498),
	(4678,'Suburb','Coromandel Surrounds',48,229,-36.7613,175.498),
	(4677,'Suburb','Coromandel Coast',48,229,-37.105,175.518),
	(4676,'Suburb','Coromandel',48,229,-36.7683,175.496),
	(4675,'Suburb','Coroglen',48,229,-37,175.667),
	(4674,'Suburb','Cooks Beach',48,229,-36.7613,175.498),
	(4673,'Suburb','Waitakaruru',48,239,-36.7613,175.498),
	(4672,'Suburb','Waikino',48,239,-37.4103,175.776),
	(4671,'Suburb','Waihi',48,239,-37.3913,175.841),
	(4670,'Suburb','Turua',48,239,-37.2372,175.566),
	(4669,'Suburb','Pipiroa',48,239,-37.2161,175.485),
	(4668,'Suburb','Paeroa',48,239,-37.3821,175.673),
	(4667,'Suburb','Ngatea',48,239,-36.7613,175.498),
	(4666,'Suburb','Mangatarata',48,239,-36.7613,175.498),
	(4665,'Suburb','Karangahake',48,239,-37.4226,175.722),
	(4664,'Suburb','Kaihere',48,239,-36.7613,175.498),
	(4663,'Suburb','Hauraki Surrounds',48,239,-36.7613,175.498),
	(4662,'Suburb','Whenuapai',35,230,-36.7893,174.622),
	(4661,'Suburb','West Harbour',35,230,-36.8188,174.63),
	(4660,'Suburb','Waitakere',35,230,-36.877,174.612),
	(4659,'Suburb','Waiatarua',35,230,-36.9339,174.578),
	(4658,'Suburb','Titirangi',35,230,-36.9382,174.654),
	(4657,'Suburb','Te Atatu South',35,230,-36.8656,174.647),
	(4656,'Suburb','Te Atatu Peninsula',35,230,-36.8412,174.652),
	(4655,'Suburb','Swanson',35,230,-36.8657,174.58),
	(4654,'Suburb','Sunnyvale',35,230,-36.8981,174.632),
	(4653,'Suburb','Ranui',35,230,-36.8639,174.602),
	(4652,'Suburb','Piha',35,230,-36.953,174.469),
	(4651,'Suburb','Parau',35,230,-36.9682,174.614),
	(4650,'Suburb','Oratia',35,230,-36.913,174.618),
	(4649,'Suburb','Nihotupu',35,230,-36.9566,174.599),
	(4648,'Suburb','New Lynn',35,230,-36.9055,174.686),
	(4647,'Suburb','Massey',35,230,-36.8222,174.614),
	(4646,'Suburb','Laingholm',35,230,-36.9779,174.632),
	(4645,'Suburb','Kelston',35,230,-36.8983,174.664),
	(4644,'Suburb','Karekare',35,230,-36.9866,174.48),
	(4643,'Suburb','Huia',35,230,-36.9984,174.566),
	(4642,'Suburb','Hobsonville',35,230,-36.7984,174.647),
	(4641,'Suburb','Herald Island',35,230,-36.7787,174.655),
	(4640,'Suburb','Henderson Valley',35,230,-36.897,174.596),
	(4639,'Suburb','Henderson',35,230,-36.8739,174.628),
	(4638,'Suburb','Green Bay',35,230,-36.9312,174.676),
	(4637,'Suburb','Glendene',35,230,-36.8905,174.656),
	(4636,'Suburb','Glen Eden',35,230,-36.9099,174.651),
	(4635,'Suburb','Cornwallis',35,230,-37.0125,174.604),
	(4634,'Suburb','Bethells Beach',35,230,-36.8922,174.449),
	(4633,'Suburb','Waiheke Island',35,297,-36.7995,175.096),
	(4632,'Suburb','Surfdale',35,297,-36.7949,175.029),
	(4631,'Suburb','Palm Beach',35,297,-36.781,175.044),
	(4630,'Suburb','Ostend',35,297,-36.7844,175.045),
	(4629,'Suburb','Onetangi',35,297,-36.7879,175.081),
	(4628,'Suburb','Oneroa',35,297,-36.7873,175.022),
	(4627,'Suburb','Omiha',35,297,-36.8191,175.058),
	(4626,'Suburb','Woodhill Forest',35,228,-36.4866,174.231),
	(4625,'Suburb','Wharehine',35,228,-36.3262,174.409),
	(4624,'Suburb','Whangateau',35,228,-36.3116,174.769),
	(4623,'Suburb','Whangaripo',35,228,-36.2859,174.632),
	(4622,'Suburb','Whangaparaoa',35,228,-36.6457,174.739),
	(4621,'Suburb','Wellsford',35,228,-36.294,174.524),
	(4620,'Suburb','Wayby Valley',35,228,-36.3021,174.558),
	(4619,'Suburb','Warkworth',35,228,-36.3987,174.661),
	(4618,'Suburb','Waiwera',35,228,-36.5434,174.704),
	(4617,'Suburb','Waitoki',35,228,-36.6346,174.551),
	(4616,'Suburb','Wainui',35,228,-36.6009,174.592),
	(4615,'Suburb','Waimauku',35,228,-36.7685,174.492),
	(4614,'Suburb','Topuni',35,228,-36.2126,174.468),
	(4613,'Suburb','Tomarata',35,228,-36.2314,174.632),
	(4612,'Suburb','Tindalls Beach',35,228,-36.6214,174.773),
	(4611,'Suburb','Ti Point',35,228,-36.3172,174.79),
	(4610,'Suburb','Te Hana',35,228,-36.2555,174.509),
	(4609,'Suburb','Te Arai',35,228,-36.1982,174.581),
	(4608,'Suburb','Tawharanui Peninsula',35,228,-36.3809,174.76),
	(4607,'Suburb','Taupaki',35,228,-36.8192,174.561),
	(4606,'Suburb','Tauhoa',35,228,-36.3773,174.452),
	(4605,'Suburb','Tapora',35,228,-36.3511,174.302),
	(4604,'Suburb','Stillwater',35,228,-36.6367,174.713),
	(4603,'Suburb','Stanmore Bay',35,228,-36.6258,174.73),
	(4602,'Suburb','South Head',35,228,-36.4603,174.258),
	(4601,'Suburb','Snells Beach',35,228,-36.4205,174.724),
	(4600,'Suburb','Silverdale',35,228,-36.6188,174.677),
	(4599,'Suburb','Sandspit',35,228,-36.3928,174.722),
	(4598,'Suburb','Rodney Surrounds',35,228,-36.5877,174.687),
	(4597,'Suburb','Riverhead',35,228,-36.758,174.592),
	(4596,'Suburb','Redvale',35,228,-36.6821,174.698),
	(4595,'Suburb','Red Beach',35,228,-36.6025,174.695),
	(4594,'Suburb','Puhoi',35,228,-36.5151,174.663),
	(4593,'Suburb','Port Albert',35,228,-36.2829,174.434),
	(4592,'Suburb','Point Wells',35,228,-36.3235,174.756),
	(4591,'Suburb','Parakai',35,228,-36.6582,174.43),
	(4590,'Suburb','Pakiri',35,228,-36.2642,174.727),
	(4589,'Suburb','Orewa',35,228,-36.5816,174.69),
	(4588,'Suburb','Omaha',35,228,-36.3302,174.775),
	(4587,'Suburb','Muriwai',35,228,-36.8362,174.434),
	(4586,'Suburb','Matakatia',35,228,-36.6239,174.774),
	(4585,'Suburb','Matakana',35,228,-36.3522,174.718),
	(4584,'Suburb','Manly',35,228,-36.6297,174.759),
	(4583,'Suburb','Makarau',35,228,-36.5508,174.493),
	(4582,'Suburb','Mahurangi West',35,228,-36.4992,174.698),
	(4581,'Suburb','Mahurangi East',35,228,-36.4753,174.733),
	(4580,'Suburb','Leigh',35,228,-36.2914,174.803),
	(4579,'Suburb','Kumeu',35,228,-36.7773,174.559),
	(4578,'Suburb','Kaukapakapa',35,228,-36.6162,174.491),
	(4577,'Suburb','Kaipara Flats',35,228,-36.4065,174.546),
	(4576,'Suburb','Hibiscus Coast Surrounds',35,228,-36.5877,174.687),
	(4575,'Suburb','Helensville',35,228,-36.6775,174.45),
	(4574,'Suburb','Hatfields Beach',35,228,-36.5693,174.692),
	(4573,'Suburb','Gulf Harbour',35,228,-36.6139,174.791),
	(4572,'Suburb','Dairy Flat',35,228,-36.6665,174.639),
	(4571,'Suburb','Coatesville',35,228,-36.7162,174.643),
	(4570,'Suburb','Army Bay',35,228,-36.6036,174.802),
	(4569,'Suburb','Arkles Bay',35,228,-36.6383,174.746),
	(4568,'Suburb','Algies Bay',35,228,-36.432,174.738),
	(4567,'Suburb','Albany Heights',35,228,-36.7226,174.699),
	(4566,'Suburb','Takanini',35,227,-37.0397,174.924),
	(4565,'Suburb','Runciman',35,227,-37.1241,174.952),
	(4564,'Suburb','Rosehill',35,227,-37.0779,174.937),
	(4563,'Suburb','Red Hill',35,227,-37.0717,174.977),
	(4562,'Suburb','Papakura',35,227,-37.0677,174.944),
	(4561,'Suburb','Pahurehure',35,227,-37.0679,174.931),
	(4560,'Suburb','Opaheke',35,227,-37.0862,174.962),
	(4559,'Suburb','Drury',35,227,-37.1028,174.952),
	(4558,'Suburb','Conifer Grove',35,227,-37.0445,174.912),
	(4557,'Suburb','Ardmore',35,227,-37.0321,174.979),
	(4556,'Suburb','Alfriston',35,227,-37.0167,174.939),
	(4555,'Suburb','Windsor Park',35,226,-36.7448,174.737),
	(4554,'Suburb','Wairau Valley',35,226,-36.7702,174.737),
	(4553,'Suburb','Waiake',35,226,-36.7071,174.75),
	(4552,'Suburb','Unsworth Heights',35,226,-36.7531,174.721),
	(4551,'Suburb','Totara Vale',35,226,-36.7596,174.733),
	(4550,'Suburb','Torbay',35,226,-36.696,174.752),
	(4549,'Suburb','Takapuna',35,226,-36.7879,174.769),
	(4548,'Suburb','Sunnynook',35,226,-36.7583,174.739),
	(4547,'Suburb','Stanley Point',35,226,-36.8287,174.788),
	(4546,'Suburb','Schnapper Rock',35,226,-36.755,174.696),
	(4545,'Suburb','Rothesay Bay',35,226,-36.7263,174.741),
	(4544,'Suburb','Rosedale',35,226,-36.7465,174.736),
	(4543,'Suburb','Pinehill',35,226,-36.7275,174.72),
	(4542,'Suburb','Paremoremo',35,226,-36.7582,174.651),
	(4541,'Suburb','Oteha',35,226,-36.7202,174.717),
	(4540,'Suburb','Okura',35,226,-36.6756,174.72),
	(4539,'Suburb','Northcross',35,226,-36.7092,174.728),
	(4538,'Suburb','Northcote Point',35,226,-36.8156,174.745),
	(4537,'Suburb','Northcote',35,226,-36.8027,174.744),
	(4536,'Suburb','Narrow Neck',35,226,-36.8141,174.793),
	(4535,'Suburb','Murrays Bay',35,226,-36.7301,174.752),
	(4534,'Suburb','Milford',35,226,-36.7724,174.764),
	(4533,'Suburb','Mairangi Bay',35,226,-36.7384,174.753),
	(4532,'Suburb','Lucas Heights',35,226,-36.7422,174.674),
	(4531,'Suburb','Long Bay',35,226,-36.6775,174.739),
	(4530,'Suburb','Hillcrest',35,226,-36.7875,174.743),
	(4529,'Suburb','Hauraki',35,226,-36.7974,174.779),
	(4528,'Suburb','Greenhithe',35,226,-36.7729,174.676),
	(4527,'Suburb','Glenfield',35,226,-36.782,174.721),
	(4526,'Suburb','Forrest Hill',35,226,-36.7632,174.748),
	(4525,'Suburb','Fairview Heights',35,226,-36.717,174.714),
	(4524,'Suburb','Devonport',35,226,-36.8274,174.797),
	(4523,'Suburb','Chatswood',35,226,-36.817,174.71),
	(4522,'Suburb','Castor Bay',35,226,-36.7579,174.767),
	(4521,'Suburb','Campbells Bay',35,226,-36.7468,174.761),
	(4520,'Suburb','Browns Bay',35,226,-36.7144,174.747),
	(4519,'Suburb','Birkenhead',35,226,-36.8099,174.728),
	(4518,'Suburb','Birkdale',35,226,-36.7967,174.701),
	(4517,'Suburb','Belmont',35,226,-36.8051,174.789),
	(4516,'Suburb','Beach Haven',35,226,-36.792,174.687),
	(4515,'Suburb','Bayview',35,226,-36.7729,174.709),
	(4514,'Suburb','Bayswater',35,226,-36.813,174.78),
	(4513,'Suburb','Albany',35,226,-36.7259,174.698),
	(4512,'Suburb','Wiri',35,223,-37.0023,174.865),
	(4511,'Suburb','Whitford',35,223,-36.9456,174.964),
	(4510,'Suburb','Weymouth',35,223,-37.0468,174.863),
	(4509,'Suburb','Wattle Downs',35,223,-37.0499,174.882),
	(4508,'Suburb','Totara Park',35,223,-36.9973,174.923),
	(4507,'Suburb','Totara Heights',35,223,-37.0021,174.901),
	(4506,'Suburb','The Gardens',35,223,-37.0122,174.914),
	(4505,'Suburb','Sunnyhills',35,223,-36.9034,174.883),
	(4504,'Suburb','Somerville',35,223,-36.9133,174.928),
	(4503,'Suburb','Shelly Park',35,223,-36.9103,174.945),
	(4502,'Suburb','Shamrock Park',35,223,-36.9236,174.932),
	(4501,'Suburb','Randwick Park',35,223,-37.0192,174.913),
	(4500,'Suburb','Papatoetoe',35,223,-36.9794,174.856),
	(4499,'Suburb','Pakuranga Heights',35,223,-36.9161,174.889),
	(4498,'Suburb','Pakuranga',35,223,-36.9116,174.871),
	(4497,'Suburb','Otara',35,223,-36.9625,174.872),
	(4496,'Suburb','Orere Point',35,223,-36.9609,175.24),
	(4495,'Suburb','Northpark',35,223,-36.9291,174.914),
	(4494,'Suburb','Ness Valley',35,223,-36.9943,175.126),
	(4493,'Suburb','Middlemore Hospital',35,223,-36.9634,174.84),
	(4492,'Suburb','Mellons Bay',35,223,-36.8905,174.937),
	(4491,'Suburb','Maraetai',35,223,-36.8798,175.035),
	(4490,'Suburb','Manurewa East',35,223,-37.0218,174.904),
	(4489,'Suburb','Manurewa',35,223,-37.0237,174.898),
	(4488,'Suburb','Manukau Heights',35,223,-36.9922,174.879),
	(4487,'Suburb','Manukau',35,223,-36.9941,174.873),
	(4486,'Suburb','Mangere East',35,223,-36.9661,174.826),
	(4485,'Suburb','Mangere Bridge',35,223,-36.9457,174.783),
	(4484,'Suburb','Mangere',35,223,-36.9686,174.794),
	(4483,'Suburb','Kawakawa Bay',35,223,-36.9482,175.169),
	(4482,'Suburb','Huntington Park',35,223,-36.9326,174.906),
	(4481,'Suburb','Howick',35,223,-36.8929,174.924),
	(4480,'Suburb','Highland Park',35,223,-36.8999,174.906),
	(4479,'Suburb','Half Moon Bay',35,223,-36.8897,174.899),
	(4478,'Suburb','Goodwood Heights',35,223,-36.9971,174.895),
	(4477,'Suburb','Golflands',35,223,-36.9256,174.909),
	(4476,'Suburb','Flat Bush',35,223,-36.961,174.926),
	(4475,'Suburb','Favona',35,223,-36.9525,174.8),
	(4474,'Suburb','Farm Cove',35,223,-36.8963,174.888),
	(4473,'Suburb','Eastern Beach',35,223,-36.8772,174.912),
	(4472,'Suburb','East Tamaki Heights',35,223,-36.9413,174.918),
	(4471,'Suburb','East Tamaki',35,223,-36.9432,174.894),
	(4470,'Suburb','Dannemora',35,223,-36.9293,174.922),
	(4469,'Suburb','Cockle Bay',35,223,-36.9044,174.938),
	(4468,'Suburb','Clover Park',35,223,-36.9825,174.894),
	(4467,'Suburb','Clevedon',35,223,-36.9947,175.036),
	(4466,'Suburb','Clendon Park',35,223,-37.0272,174.866),
	(4465,'Suburb','Burswood',35,223,-36.9263,174.894),
	(4464,'Suburb','Bucklands Beach',35,223,-36.8689,174.906),
	(4463,'Suburb','Brookby',35,223,-36.9834,174.991),
	(4462,'Suburb','Botany Downs',35,223,-36.9093,174.917),
	(4461,'Suburb','Beachlands',35,223,-36.8876,175.003),
	(4460,'Suburb','Auckland Airport',35,223,-36.9993,174.788),
	(4459,'Suburb','Rakino Island',35,294,-36.8485,174.763),
	(4458,'Suburb','Other Islands',35,294,-36.8485,174.763),
	(4457,'Suburb','Kawau Island',35,294,-41.7009,172.907),
	(4456,'Suburb','Great Barrier Island',35,294,-36.8485,174.763),
	(4455,'Suburb','Whangape',35,224,-37.4688,175.052),
	(4454,'Suburb','Whakatiwai',35,224,-37.0893,175.302),
	(4453,'Suburb','Waiuku',35,224,-37.2479,174.734),
	(4452,'Suburb','Waiau Pa',35,224,-37.1376,174.753),
	(4451,'Suburb','Tuakau',35,224,-37.2702,174.944),
	(4450,'Suburb','Te Kohanga',35,224,-37.3139,174.846),
	(4449,'Suburb','Ramarama',35,224,-37.144,174.96),
	(4448,'Suburb','Puni',35,224,-37.2333,174.859),
	(4447,'Suburb','Pukekohe East',35,224,-37.1955,174.95),
	(4446,'Suburb','Pukekohe',35,224,-37.2021,174.904),
	(4445,'Suburb','Pukekawa',35,224,-37.3267,174.986),
	(4444,'Suburb','Port Waikato',35,224,-37.3902,174.729),
	(4443,'Suburb','Pollok',35,224,-37.139,174.618),
	(4442,'Suburb','Pokeno',35,224,-37.2449,175.021),
	(4441,'Suburb','Patumahoe',35,224,-37.1878,174.829),
	(4440,'Suburb','Paerata',35,224,-37.1698,174.898),
	(4439,'Suburb','Otaua',35,224,-37.3064,174.741),
	(4438,'Suburb','Onewhero',35,224,-37.3278,174.915),
	(4437,'Suburb','Miranda',35,224,-37.1841,175.307),
	(4436,'Suburb','Mercer',35,224,-37.2791,175.048),
	(4435,'Suburb','Mauku',35,224,-37.2047,174.82),
	(4434,'Suburb','Manukau Heads',35,224,-37.0507,174.562),
	(4433,'Suburb','Mangatawhiri',35,224,-37.2151,175.123),
	(4432,'Suburb','Mangatangi',35,224,-37.2012,175.199),
	(4431,'Suburb','Kingseat',35,224,-37.1305,174.804),
	(4430,'Suburb','Karaka',35,224,-37.1003,174.877),
	(4429,'Suburb','Kaiaua',35,224,-37.1108,175.297),
	(4428,'Suburb','Hunua',35,224,-37.0783,175.071),
	(4427,'Suburb','Glenbrook',35,224,-37.2028,174.754),
	(4426,'Suburb','Clarks Beach',35,224,-37.1355,174.702),
	(4425,'Suburb','Buckland',35,224,-37.2278,174.927),
	(4424,'Suburb','Bombay',35,224,-37.1855,174.997),
	(4423,'Suburb','Awhitu',35,224,-37.0828,174.636),
	(4422,'Suburb','Ararimu',35,224,-37.1405,175.038),
	(4421,'Suburb','Aka Aka',35,224,-37.2933,174.793),
	(4420,'Suburb','Westmere',35,225,-36.8555,174.72),
	(4419,'Suburb','Western Springs',35,225,-36.8682,174.726),
	(4418,'Suburb','Waterview',35,225,-36.8797,174.702),
	(4417,'Suburb','Three Kings',35,225,-36.9094,174.756),
	(4416,'Suburb','Sandringham',35,225,-36.8836,174.739),
	(4415,'Suburb','Saint Marys Bay',35,225,-36.8452,174.748),
	(4414,'Suburb','Saint Johns',35,225,-36.8745,174.842),
	(4413,'Suburb','Saint Heliers',35,225,-36.8513,174.858),
	(4412,'Suburb','Royal Oak',35,225,-36.9118,174.776),
	(4411,'Suburb','Remuera',35,225,-36.8807,174.798),
	(4410,'Suburb','Ponsonby',35,225,-36.8473,174.744),
	(4409,'Suburb','Point England',35,225,-36.8847,174.857),
	(4408,'Suburb','Point Chevalier',35,225,-36.8622,174.709),
	(4407,'Suburb','Penrose',35,225,-36.9074,174.812),
	(4406,'Suburb','Parnell',35,225,-36.8541,174.78),
	(4405,'Suburb','Panmure',35,225,-36.9016,174.854),
	(4404,'Suburb','Otahuhu',35,225,-36.9453,174.845),
	(4403,'Suburb','Orakei',35,225,-36.8575,174.81),
	(4402,'Suburb','Onehunga',35,225,-36.9228,174.785),
	(4401,'Suburb','One Tree Hill',35,225,-36.9052,174.789),
	(4400,'Suburb','Newmarket',35,225,-36.8698,174.778),
	(4399,'Suburb','New Windsor',35,225,-36.9071,174.713),
	(4398,'Suburb','Mount Wellington',35,225,-36.9085,174.839),
	(4397,'Suburb','Mount Roskill',35,225,-36.9047,174.742),
	(4396,'Suburb','Mount Eden',35,225,-36.8802,174.762),
	(4395,'Suburb','Mount Albert',35,225,-36.8841,174.716),
	(4394,'Suburb','Mission Bay',35,225,-36.8482,174.832),
	(4393,'Suburb','Meadowbank',35,225,-36.8701,174.827),
	(4392,'Suburb','Lynfield',35,225,-36.9286,174.72),
	(4391,'Suburb','Kohimarama',35,225,-36.8505,174.845),
	(4390,'Suburb','Kingsland',35,225,-36.8707,174.747),
	(4389,'Suburb','Hillsborough',35,225,-36.9222,174.754),
	(4388,'Suburb','Herne Bay',35,225,-36.8483,174.73),
	(4387,'Suburb','Grey Lynn',35,225,-36.8651,174.737),
	(4386,'Suburb','Greenlane',35,225,-36.8916,174.792),
	(4385,'Suburb','Grafton',35,225,-36.8604,174.767),
	(4384,'Suburb','Glendowie',35,225,-36.8603,174.869),
	(4383,'Suburb','Glen Innes',35,225,-36.8779,174.857),
	(4382,'Suburb','Freemans Bay',35,225,-36.8515,174.749),
	(4381,'Suburb','Epsom',35,225,-36.8936,174.774),
	(4380,'Suburb','Ellerslie',35,225,-36.8978,174.809),
	(4379,'Suburb','Eden Terrace',35,225,-36.8661,174.758),
	(4378,'Suburb','Blockhouse Bay',35,225,-36.9234,174.7),
	(4377,'Suburb','Avondale',35,225,-36.8945,174.697),
	(4376,'Suburb','Auckland Central',35,225,-36.8485,174.763),
	(4375,'Suburb','Woodhill',34,222,-35.7315,174.311),
	(4374,'Suburb','Whau Valley',34,222,-35.6995,174.313),
	(4373,'Suburb','Whareora',34,222,-35.6857,174.399),
	(4372,'Suburb','Whangarei Surrounds',34,222,-35.7251,174.324),
	(4371,'Suburb','Whangarei Heads',34,222,-35.815,174.505),
	(4370,'Suburb','Whangarei Central',34,222,-35.7251,174.324),
	(4369,'Suburb','Whangarei Area',34,222,-35.7251,174.324),
	(4368,'Suburb','Whananaki',34,222,-35.5081,174.467),
	(4367,'Suburb','Whakapara',34,222,-35.5396,174.274),
	(4366,'Suburb','Waipu',34,222,-35.9847,174.447),
	(4365,'Suburb','Tutukaka',34,222,-35.6104,174.524),
	(4364,'Suburb','Tikipunga',34,222,-35.6845,174.328),
	(4363,'Suburb','Tamaterau',34,222,-35.7716,174.401),
	(4362,'Suburb','Ruatangata',34,222,-35.6271,174.104),
	(4361,'Suburb','Ruakaka',34,222,-35.9064,174.447),
	(4360,'Suburb','Riverside',34,222,-35.7235,174.327),
	(4359,'Suburb','Regent',34,222,-35.7162,174.323),
	(4358,'Suburb','Raumanga',34,222,-35.7449,174.306),
	(4357,'Suburb','Port Whangarei',34,222,-35.7435,174.344),
	(4356,'Suburb','Poroti',34,222,-35.7383,174.129),
	(4355,'Suburb','Pataua',34,222,-35.7188,174.524),
	(4354,'Suburb','Parua Bay',34,222,-35.7653,174.461),
	(4353,'Suburb','Parahaki',34,222,-35.7312,174.344),
	(4352,'Suburb','Otangarei',34,222,-35.695,174.319),
	(4351,'Suburb','Otaika',34,222,-35.7862,174.306),
	(4350,'Suburb','Onerahi',34,222,-35.7641,174.366),
	(4349,'Suburb','One Tree Point',34,222,-35.8228,174.458),
	(4348,'Suburb','Okara',34,222,-35.7321,174.327),
	(4347,'Suburb','Oakura Coast',34,222,-35.7251,174.324),
	(4346,'Suburb','Ngunguru',34,222,-35.628,174.507),
	(4345,'Suburb','Morningside',34,222,-35.7347,174.32),
	(4344,'Suburb','Maunu',34,222,-35.7432,174.277),
	(4343,'Suburb','Maungatapere',34,222,-35.755,174.208),
	(4342,'Suburb','Matapouri',34,222,-35.5658,174.504),
	(4341,'Suburb','Marsden Point',34,222,-35.8431,174.487),
	(4340,'Suburb','Mangapai and Surrounds',34,222,-35.7251,174.324),
	(4339,'Suburb','Langs Beach',34,222,-36.0452,174.533),
	(4338,'Suburb','Kokopu',34,222,-35.7066,174.145),
	(4337,'Suburb','Kiripaka',34,222,-35.6435,174.428),
	(4336,'Suburb','Kensington',34,222,-35.7102,174.313),
	(4335,'Suburb','Kauri',34,222,-35.6441,174.301),
	(4334,'Suburb','Kamo',34,222,-35.6818,174.3),
	(4333,'Suburb','Hukerenui and Surrounds',34,222,-35.7251,174.324),
	(4332,'Suburb','Horahora',34,222,-35.7341,174.291),
	(4331,'Suburb','Hikurangi',34,222,-35.596,174.286),
	(4330,'Suburb','Glenbervie',34,222,-35.6755,174.349),
	(4329,'Suburb','Avenues',34,222,-35.7249,174.312),
	(4328,'Suburb','Whakapirau',34,221,-36.1578,174.237),
	(4327,'Suburb','Waipoua',34,221,-35.6487,173.502),
	(4326,'Suburb','Tinopai',34,221,-36.2545,174.246),
	(4325,'Suburb','Te Kopuru',34,221,-36.0282,173.92),
	(4324,'Suburb','Tangiteroria',34,221,-35.8213,174.046),
	(4323,'Suburb','Ruawai Surrounds',34,221,-35.9409,173.868),
	(4322,'Suburb','Ruawai',34,221,-36.1355,174.023),
	(4321,'Suburb','Pouto',34,221,-36.3634,174.18),
	(4320,'Suburb','Pahi',34,221,-36.157,174.228),
	(4319,'Suburb','Otamatea Surrounds',34,221,-35.9409,173.868),
	(4318,'Suburb','Maungaturoto',34,221,-36.1096,174.356),
	(4317,'Suburb','Mareretu',34,221,-36.0399,174.279),
	(4316,'Suburb','Mangawhai Heads',34,221,-36.0911,174.584),
	(4315,'Suburb','Mangawhai',34,221,-36.1262,174.574),
	(4314,'Suburb','Kaiwaka',34,221,-36.1612,174.443),
	(4313,'Suburb','Dargaville Surrounds',34,221,-35.9409,173.868),
	(4312,'Suburb','Dargaville',34,221,-35.9401,173.869),
	(4311,'Suburb','Arapohue',34,221,-35.9848,173.958),
	(4310,'Suburb','Whangaroa/Kaeo Surrounds',34,220,-35.0464,173.745),
	(4309,'Suburb','Whangaroa',34,220,-35.0464,173.745),
	(4308,'Suburb','Waitangi',34,220,-35.2706,174.08),
	(4307,'Suburb','Waiomio',34,220,-35.4106,174.073),
	(4306,'Suburb','Waimate North',34,220,-35.3134,173.887),
	(4305,'Suburb','Towai',34,220,-35.4989,174.129),
	(4304,'Suburb','Taupo Bay/Totara North',34,220,-34.9921,173.709),
	(4303,'Suburb','Taipa',34,220,-34.9962,173.467),
	(4302,'Suburb','South Hokianga',34,220,-35.407,173.491),
	(4301,'Suburb','Russell Surrounds',34,220,-35.3799,174.065),
	(4300,'Suburb','Russell',34,220,-35.2623,174.122),
	(4299,'Suburb','Rawene',34,220,-35.4022,173.504),
	(4298,'Suburb','Punakitere Valley',34,220,-35.4714,173.869),
	(4297,'Suburb','Pukewharariki',34,220,-35.3868,173.728),
	(4296,'Suburb','Pipiwai',34,220,-35.6188,174.015),
	(4295,'Suburb','Peria',34,220,-35.1005,173.486),
	(4294,'Suburb','Pakotai',34,220,-35.6884,173.9),
	(4293,'Suburb','Pakaraka',34,220,-35.3586,173.955),
	(4292,'Suburb','Paihia Surrounds',34,220,-35.3799,174.065),
	(4291,'Suburb','Paihia',34,220,-35.2807,174.091),
	(4290,'Suburb','Paewhenua Island',34,220,-35.0065,173.548),
	(4289,'Suburb','Opua',34,220,-35.313,174.113),
	(4288,'Suburb','Opononi',34,220,-35.5051,173.391),
	(4287,'Suburb','Omapere',34,220,-35.5351,173.388),
	(4286,'Suburb','Ohaeawai',34,220,-35.352,173.882),
	(4285,'Suburb','Nukutawhiti',34,220,-35.6444,173.861),
	(4284,'Suburb','North Hokianga',34,220,-35.407,173.491),
	(4283,'Suburb','Ngawha Springs',34,220,-35.408,173.858),
	(4282,'Suburb','Motatau',34,220,-35.49,174.036),
	(4281,'Suburb','Moerewa',34,220,-35.3879,174.014),
	(4280,'Suburb','Matawaia',34,220,-35.5069,173.95),
	(4279,'Suburb','Matauri Bay',34,220,-35.0428,173.903),
	(4278,'Suburb','Maromaku',34,220,-35.4813,174.096),
	(4277,'Suburb','Mangonui Surrounds',34,220,-35.3799,174.065),
	(4276,'Suburb','Mangonui',34,220,-34.9941,173.529),
	(4275,'Suburb','Mangamuka',34,220,-35.21,173.54),
	(4274,'Suburb','Kohukohu',34,220,-35.3599,173.545),
	(4273,'Suburb','Kerikeri Surrounds',34,220,-35.3799,174.065),
	(4272,'Suburb','Kerikeri',34,220,-35.2286,173.948),
	(4271,'Suburb','Kawakawa Surrounds',34,220,-35.3799,174.065),
	(4270,'Suburb','Kawakawa',34,220,-35.3795,174.065),
	(4269,'Suburb','Karikari Peninsula',34,220,-34.87,173.379),
	(4268,'Suburb','Kaitaia Surrounds',34,220,-35.3799,174.065),
	(4267,'Suburb','Kaitaia',34,220,-35.1173,173.268),
	(4266,'Suburb','Kaingaroa',34,220,-35.0278,173.326),
	(4265,'Suburb','Kaikohe West',34,220,-35.4072,173.804),
	(4264,'Suburb','Kaikohe Surrounds',34,220,-35.3799,174.065),
	(4263,'Suburb','Kaikohe',34,220,-35.4072,173.804),
	(4262,'Suburb','Kaeo',34,220,-35.1003,173.78),
	(4261,'Suburb','Houhora',34,220,-34.7957,173.103),
	(4260,'Suburb','Horeke',34,220,-35.3561,173.593),
	(4259,'Suburb','Hokianga Surrounds',34,220,-35.3799,174.065),
	(4258,'Suburb','Herekino',34,220,-35.2659,173.211),
	(4257,'Suburb','Haruru',34,220,-35.2814,174.058),
	(4256,'Suburb','Coopers Beach',34,220,-34.9925,173.508),
	(4255,'Suburb','Cable Bay',34,220,-34.9929,173.493),
	(4254,'Suburb','Awarua',34,220,-35.5767,173.836),
	(4253,'Suburb','Awanui',34,220,-35.0464,173.256),
	(4252,'Suburb','Ahipara',34,220,-35.1713,173.153),
	(5130,'Suburb','Urenui',40,253,-38.9977,174.39),
	(5131,'Suburb','Uruti',40,253,-38.9443,174.528),
	(5132,'Suburb','Vogeltown',40,253,-39.079,174.081),
	(5133,'Suburb','Waitara',40,253,-39.0011,174.238),
	(5134,'Suburb','Welbourn',40,253,-39.0722,174.091),
	(5135,'Suburb','Westown',40,253,-39.0711,174.062),
	(5136,'Suburb','Whalers Gate',40,253,-39.0842,174.035),
	(5137,'Suburb','Eltham',40,251,-39.4305,174.299),
	(5138,'Suburb','Hawera',40,251,-39.5883,174.28),
	(5139,'Suburb','Manaia',40,251,-39.5513,174.128),
	(5140,'Suburb','Manutahi',40,251,-39.6604,174.396),
	(5141,'Suburb','Matemateaonga',40,251,-39.4116,174.523),
	(5142,'Suburb','Normanby',40,251,-39.5399,174.274),
	(5143,'Suburb','Ohangai',40,251,-39.585,174.389),
	(5144,'Suburb','Okaiawa',40,251,-39.5277,174.2),
	(5145,'Suburb','Opunake',40,251,-39.4539,173.858),
	(5146,'Suburb','Patea',40,251,-39.7548,174.473),
	(5147,'Suburb','Rahotu',40,251,-39.3274,173.804),
	(5148,'Suburb','South Taranaki Surrounds',40,251,-39.5866,174.251),
	(5149,'Suburb','Waitotara',40,251,-39.806,174.736),
	(5150,'Suburb','Waverley',40,251,-39.7644,174.629),
	(5151,'Suburb','Douglas',40,252,-39.306,174.466),
	(5152,'Suburb','Midhirst',40,252,-39.2933,174.266),
	(5153,'Suburb','Pohokura and Surrounds',40,252,-39.3371,174.284),
	(5154,'Suburb','Stratford',40,252,-39.3371,174.284),
	(5155,'Suburb','Stratford Surrounds',40,252,-39.3371,174.284),
	(5156,'Suburb','Tahora',40,252,-39.0281,174.804),
	(5157,'Suburb','Foxton',56,260,-40.4725,175.286),
	(5158,'Suburb','Foxton Beach',56,260,-40.4585,175.224),
	(5159,'Suburb','Horowhenua Surrounds',56,260,0,0),
	(5160,'Suburb','Levin',56,260,-40.6222,175.286),
	(5161,'Suburb','Manakau',56,260,-40.7153,175.216),
	(5162,'Suburb','Moutoa',56,260,-40.5069,175.395),
	(5163,'Suburb','Ohau',56,260,-40.6611,175.25),
	(5164,'Suburb','Shannon',56,260,-40.5457,175.413),
	(5165,'Suburb','Tokomaru',56,260,-40.4736,175.511),
	(5166,'Suburb','Waitarere',56,260,-40.5553,175.215),
	(5167,'Suburb','Waitarere Beach',56,260,-40.5496,175.199),
	(5168,'Suburb','Apiti',56,259,-39.973,175.871),
	(5169,'Suburb','Bunnythorpe',56,259,-40.2824,175.631),
	(5170,'Suburb','Cheltenham',56,259,-40.1384,175.661),
	(5171,'Suburb','Feilding',56,259,-40.2253,175.567),
	(5172,'Suburb','Halcombe',56,259,-40.1451,175.494),
	(5173,'Suburb','Himatangi',56,259,-40.3913,175.315),
	(5174,'Suburb','Himatangi Beach',56,259,-40.37,175.232),
	(5175,'Suburb','Kairanga',56,259,-40.3481,175.532),
	(5176,'Suburb','Kimbolton',56,259,-40.0544,175.779),
	(5177,'Suburb','Longburn',56,259,-40.3845,175.541),
	(5178,'Suburb','Manawatu Surrounds',56,259,0,0),
	(5179,'Suburb','Newbury',56,259,-40.3153,175.57),
	(5180,'Suburb','Ohakea',56,259,-40.1938,175.378),
	(5181,'Suburb','Ohingaiti',56,259,-39.8624,175.708),
	(5182,'Suburb','Opiki',56,259,-40.3854,175.713),
	(5183,'Suburb','Pohangina',56,259,-40.1723,175.793),
	(5184,'Suburb','Rangiwahia',56,259,-39.8992,175.901),
	(5185,'Suburb','Rongotea',56,259,-40.2918,175.423),
	(5186,'Suburb','Sanson',56,259,-40.219,175.425),
	(5187,'Suburb','Tangimoana',56,259,-40.2969,175.247),
	(5188,'Suburb','Tiakitahuna',56,259,-40.4028,175.5),
	(5189,'Suburb','Waituna West',56,259,-40.0409,175.638),
	(5190,'Suburb','Aokautere',56,255,-40.3673,175.664),
	(5191,'Suburb','Ashhurst',56,255,-40.2946,175.753),
	(5192,'Suburb','Awapuni',56,255,-40.3769,175.583),
	(5193,'Suburb','Cloverlea',56,255,-40.3457,175.585),
	(5194,'Suburb','Highbury',56,255,-40.3615,175.58),
	(5195,'Suburb','Hokowhitu',56,255,-40.3624,175.633),
	(5196,'Suburb','Kelvin Grove',56,255,-40.3288,175.651),
	(5197,'Suburb','Linton',56,255,-40.4309,175.561),
	(5198,'Suburb','Massey University',56,255,-40.3851,175.614),
	(5199,'Suburb','Milson',56,255,-40.3274,175.61),
	(5200,'Suburb','Palmerston North Central',56,255,-40.3523,175.608),
	(5201,'Suburb','Palmerston North Surrounds',56,255,-40.3523,175.608),
	(5202,'Suburb','Roslyn',56,255,-40.3394,175.622),
	(5203,'Suburb','Summerhill',56,255,-40.3814,175.63),
	(5204,'Suburb','Takaro',56,255,-40.3573,175.59),
	(5205,'Suburb','Terrace End',56,255,-40.3491,175.639),
	(5206,'Suburb','Turitea',56,255,-40.4078,175.655),
	(5207,'Suburb','West End',56,255,-40.3649,175.601),
	(5208,'Suburb','Westbrook',56,255,-40.3568,175.572),
	(5209,'Suburb','Whakarongo',56,255,-40.3328,175.668),
	(5210,'Suburb','Bulls',56,254,-40.1743,175.385),
	(5211,'Suburb','Hunterville',56,254,-39.9365,175.569),
	(5212,'Suburb','Koitiata',56,254,-40.0715,175.139),
	(5213,'Suburb','Lake Alice',56,254,-40.1239,175.334),
	(5214,'Suburb','Mangaweka',56,254,-39.8069,175.795),
	(5215,'Suburb','Marton',56,254,-40.0689,175.378),
	(5216,'Suburb','Parewanui',56,254,-40.0007,175.584),
	(5217,'Suburb','Rangitikei Surrounds',56,254,0,0),
	(5218,'Suburb','Ratana',56,254,-40.0399,175.178),
	(5219,'Suburb','Taihape and Surrounds',56,254,-39.6777,175.799),
	(5220,'Suburb','Turakina',56,254,-40.047,175.214),
	(5221,'Suburb','Aramoho',56,258,-39.902,175.065),
	(5222,'Suburb','Bastia Hill',56,258,-39.9279,175.066),
	(5223,'Suburb','Brunswick',56,258,-39.8425,175.024),
	(5224,'Suburb','Castlecliff',56,258,-39.9432,174.994),
	(5225,'Suburb','College Estate',56,258,-39.9347,175.037),
	(5226,'Suburb','Durie Hill',56,258,-39.9354,175.066),
	(5227,'Suburb','Fordell',56,258,-39.9606,175.204),
	(5228,'Suburb','Gonville',56,258,-39.9387,175.046),
	(5229,'Suburb','Kai Iwi',56,258,-39.8487,174.928),
	(5230,'Suburb','Kaitoke',56,258,-39.959,175.09),
	(5231,'Suburb','Kakatahi',56,258,-39.6228,175.418),
	(5232,'Suburb','Mangamahu',56,258,-39.818,175.365),
	(5233,'Suburb','Marybank',56,258,-39.9564,175.064),
	(5234,'Suburb','Matahiwi',56,258,-39.6068,175.165),
	(5235,'Suburb','Okoia',56,258,-39.9305,175.133),
	(5236,'Suburb','Otamatea',56,258,-39.9125,175.027),
	(5237,'Suburb','Papaiti',56,258,-39.8743,175.109),
	(5238,'Suburb','Parikino',56,258,-39.8109,175.149),
	(5239,'Suburb','Putiki',56,258,-39.9489,175.052),
	(5240,'Suburb','Saint Johns Hill',56,258,-39.9165,175.037),
	(5241,'Suburb','Springvale',56,258,-39.9234,175.026),
	(5242,'Suburb','Tawhero',56,258,-39.9375,175.016),
	(5243,'Suburb','Wanganui Central',56,258,-39.9301,175.048),
	(5244,'Suburb','Wanganui East',56,258,-39.9173,175.062),
	(5245,'Suburb','Wanganui Surrounds',56,258,-39.9301,175.048),
	(5246,'Suburb','Westmere',56,258,-39.8968,174.995),
	(5247,'Suburb','Whangaehu',56,258,-40.0081,175.168),
	(5248,'Suburb','Carterton',52,264,-41.0292,175.524),
	(5249,'Suburb','Carterton Surrounds',52,264,-41.0292,175.524),
	(5250,'Suburb','Gladstone',52,264,-41.079,175.655),
	(5251,'Suburb','Masterton Surrounds',52,264,-41.0292,175.524),
	(5252,'Suburb','Te Wharau',52,264,-41.1788,175.831),
	(5253,'Suburb','Bideford',52,262,-40.8681,175.861),
	(5254,'Suburb','Blairlogie',52,262,-40.9322,175.923),
	(5255,'Suburb','Kiriwhakapapa',52,262,-40.8103,175.576),
	(5256,'Suburb','Mangapakeha',52,262,-40.9049,176.008),
	(5257,'Suburb','Masterton',52,262,-40.9511,175.657),
	(5258,'Suburb','Matahiwi',52,262,-40.8828,175.595),
	(5259,'Suburb','Mauriceville',52,262,-40.7749,175.702),
	(5260,'Suburb','Opaki',52,262,-40.8928,175.661),
	(5261,'Suburb','Riversdale Beach',52,262,-41.0916,176.07),
	(5262,'Suburb','Solway',52,262,-40.9618,175.632),
	(5263,'Suburb','Te Whiti',52,262,-41.0064,175.672),
	(5264,'Suburb','Tinui',52,262,-40.878,176.076),
	(5265,'Suburb','Upper Plain',52,262,-40.9215,175.585),
	(5266,'Suburb','Wainuioru',52,262,-41.0366,175.81),
	(5267,'Suburb','Whanaehu Valley',52,262,-40.963,175.808),
	(5268,'Suburb','Cape Palliser',52,267,-41.6119,175.29),
	(5269,'Suburb','Featherston',52,267,-41.1168,175.323),
	(5270,'Suburb','Greytown',52,267,-41.0848,175.456),
	(5271,'Suburb','Hinakura',52,267,-41.2933,175.645),
	(5272,'Suburb','Martinborough',52,267,-41.2191,175.46),
	(5273,'Suburb','Pirinoa',52,267,-41.3528,175.205),
	(5274,'Suburb','Tuturumuri',52,267,-41.4153,175.489),
	(5275,'Suburb','Dannevirke',52,256,-40.2053,176.1),
	(5276,'Suburb','Eketahuna',52,256,-40.6462,175.704),
	(5277,'Suburb','Norsewood',52,256,-40.0729,176.217),
	(5278,'Suburb','Pahiatua',52,256,-40.4597,175.835),
	(5279,'Suburb','Pongaroa',52,256,-40.5414,176.195),
	(5280,'Suburb','Tiraumea',52,256,-40.6331,176.046),
	(5281,'Suburb','Woodville',52,256,-40.3361,175.863),
	(5282,'Suburb','Kapiti Coast Surrounds',42,261,-40.9192,174.983),
	(5283,'Suburb','Otaihanga',42,261,-40.8779,175.015),
	(5284,'Suburb','Otaki',42,261,-40.7606,175.156),
	(5285,'Suburb','Otaki Beach',42,261,-40.7413,175.117),
	(5286,'Suburb','Paekakariki',42,261,-40.9881,174.951),
	(5287,'Suburb','Paraparaumu',42,261,-40.9142,175.008),
	(5288,'Suburb','Paraparaumu Beach',42,261,-40.8932,174.98),
	(5289,'Suburb','Peka Peka',42,261,-40.8328,175.058),
	(5290,'Suburb','Raumati Beach',42,261,-40.919,174.982),
	(5291,'Suburb','Raumati South',42,261,-40.9371,174.976),
	(5292,'Suburb','Te Horo',42,261,-40.7995,175.123),
	(5293,'Suburb','Waikanae',42,261,-40.8755,175.067),
	(5294,'Suburb','Waikanae Beach',42,261,-40.8638,175.021),
	(5295,'Suburb','Alicetown',42,263,-41.2154,174.892),
	(5296,'Suburb','Avalon',42,263,-41.1934,174.944),
	(5297,'Suburb','Belmont',42,263,-41.1943,174.923),
	(5298,'Suburb','Boulcott',42,263,-41.2011,174.917),
	(5299,'Suburb','Central Hutt',42,263,-41.209,174.907),
	(5300,'Suburb','Days Bay',42,263,-41.2816,174.907),
	(5301,'Suburb','Eastbourne',42,263,-41.2917,174.898),
	(5302,'Suburb','Epuni',42,263,-41.1993,174.935),
	(5303,'Suburb','Fairfield',42,263,-41.2101,174.934),
	(5304,'Suburb','Gracefield',42,263,-41.2353,174.918),
	(5305,'Suburb','Harbour View',42,263,-41.2028,174.899),
	(5306,'Suburb','Haywards',42,263,-41.1493,174.979),
	(5307,'Suburb','Hutt Valley Surrounds',42,263,-41.2092,174.908),
	(5308,'Suburb','Kelson',42,263,-41.1795,174.933),
	(5309,'Suburb','Korokoro',42,263,-41.2199,174.87),
	(5310,'Suburb','Lower Hutt',42,263,-41.2092,174.908),
	(5311,'Suburb','Lowry Bay',42,263,-41.2569,174.912),
	(5312,'Suburb','Mahina Bay',42,263,-41.2694,174.908),
	(5313,'Suburb','Manor Park',42,263,-41.1568,174.979),
	(5314,'Suburb','Maungaraki',42,263,-41.212,174.881),
	(5315,'Suburb','Melling',42,263,-41.209,174.898),
	(5316,'Suburb','Moera',42,263,-41.2277,174.905),
	(5317,'Suburb','Naenae',42,263,-41.2024,174.942),
	(5318,'Suburb','Normandale',42,263,-41.2005,174.888),
	(5319,'Suburb','Pencarrow Head',42,263,-41.3595,174.848),
	(5320,'Suburb','Petone',42,263,-41.227,174.885),
	(5321,'Suburb','Point Howard',42,263,-41.2529,174.903),
	(5322,'Suburb','Seaview',42,263,-41.2424,174.905),
	(5323,'Suburb','Sorrento Bay',42,263,-41.254,174.909),
	(5324,'Suburb','Stokes Valley',42,263,-41.1745,174.982),
	(5325,'Suburb','Taita',42,263,-41.1798,174.961),
	(5326,'Suburb','Tirohanga',42,263,-41.1975,174.905),
	(5327,'Suburb','Wainuiomata',42,263,-41.2634,174.948),
	(5328,'Suburb','Waiwhetu',42,263,-41.2251,174.915),
	(5329,'Suburb','Waterloo',42,263,-41.216,174.925),
	(5330,'Suburb','Woburn',42,263,-41.2205,174.907),
	(5331,'Suburb','York Bay',42,263,-41.2645,174.91),
	(5332,'Suburb','Aotea',42,268,-41.1224,174.868),
	(5333,'Suburb','Ascot Park',42,268,-41.1225,174.876),
	(5334,'Suburb','Camborne',42,268,-41.0891,174.874),
	(5335,'Suburb','Cannons Creek',42,268,-41.1409,174.865),
	(5336,'Suburb','Elsdon',42,268,-41.1297,174.837),
	(5337,'Suburb','Judgeford',42,268,-41.117,174.954),
	(5338,'Suburb','Mana',42,268,-41.0928,174.869),
	(5339,'Suburb','Papakowhai',42,268,-41.1194,174.859),
	(5340,'Suburb','Paremata',42,268,-41.1045,174.875),
	(5341,'Suburb','Pauatahanui',42,268,-41.1034,174.918),
	(5342,'Suburb','Plimmerton',42,268,-41.0845,174.867),
	(5343,'Suburb','Porirua',42,268,-41.1339,174.841),
	(5344,'Suburb','Porirua East',42,268,-41.1398,174.852),
	(5345,'Suburb','Pukerua Bay',42,268,-41.0359,174.886),
	(5346,'Suburb','Ranui Heights',42,268,-41.1428,174.848),
	(5347,'Suburb','Takapuwahia',42,268,-41.1251,174.833),
	(5348,'Suburb','Titahi Bay',42,268,-41.1062,174.839),
	(5349,'Suburb','Waitangirua',42,268,-41.1259,174.881),
	(5350,'Suburb','Whitby',42,268,-41.1116,174.889),
	(5351,'Suburb','Akatarawa',42,266,-41.0791,175.107),
	(5352,'Suburb','Birchville',42,266,-41.0911,175.098),
	(5353,'Suburb','Blue Mountains',42,266,-41.1729,175.034),
	(5354,'Suburb','Brown Owl',42,266,-41.1044,175.098),
	(5355,'Suburb','Clouston Park',42,266,-41.1169,175.088),
	(5356,'Suburb','Craigs Flat',42,266,-41.1002,175.07),
	(5357,'Suburb','Ebdentown',42,266,-41.1201,175.073),
	(5358,'Suburb','Elderslea',42,266,-41.1231,175.059),
	(5359,'Suburb','Heretaunga',42,266,-41.1433,175.02),
	(5360,'Suburb','Kingsley Heights',42,266,-41.1232,175.082),
	(5361,'Suburb','Mangaroa',42,266,-41.1197,175.11),
	(5362,'Suburb','Maoribank',42,266,-41.1105,175.101),
	(5363,'Suburb','Maymorn',42,266,-41.1089,175.134),
	(5364,'Suburb','Moonshine Valley',42,266,-41.0915,175),
	(5365,'Suburb','Pakuratahi',42,266,-41.0797,175.204),
	(5366,'Suburb','Pinehaven',42,266,-41.1609,175.014),
	(5367,'Suburb','Rimutaka Hill',42,266,-41.1159,175.229),
	(5368,'Suburb','Riverstone Terraces',42,266,-41.1188,175.038),
	(5369,'Suburb','Silverstream',42,266,-41.1479,175.012),
	(5370,'Suburb','Te Marua',42,266,-41.0934,175.129),
	(5371,'Suburb','Timberlea',42,266,-41.1065,175.104),
	(5372,'Suburb','Totara Park',42,266,-41.1107,175.082),
	(5373,'Suburb','Trentham',42,266,-41.126,175.041),
	(5374,'Suburb','Upper Hutt',42,266,-41.1333,175.051),
	(5375,'Suburb','Upper Hutt Surrounds',42,266,-41.1333,175.051),
	(5376,'Suburb','Wallaceville',42,266,-41.1296,175.064),
	(5377,'Suburb','Whitemans Valley',42,266,-41.167,175.084),
	(5378,'Suburb','Aro Valley',42,265,-41.2954,174.767),
	(5379,'Suburb','Berhampore',42,265,-41.3215,174.775),
	(5380,'Suburb','Breaker Bay',42,265,-41.3359,174.824),
	(5381,'Suburb','Broadmeadows',42,265,-41.2357,174.796),
	(5382,'Suburb','Brooklyn',42,265,-41.3061,174.763),
	(5383,'Suburb','Churton Park',42,265,-41.207,174.808),
	(5384,'Suburb','Crofton Downs',42,265,-41.2559,174.765),
	(5385,'Suburb','Glenside',42,265,-41.2039,174.818),
	(5386,'Suburb','Grenada North',42,265,-41.1859,174.837),
	(5387,'Suburb','Grenada Village',42,265,-41.2075,174.82),
	(5388,'Suburb','Hataitai',42,265,-41.3041,174.794),
	(5389,'Suburb','Highbury',42,265,-41.2924,174.755),
	(5390,'Suburb','Horokiwi',42,265,-41.206,174.849),
	(5391,'Suburb','Houghton Bay',42,265,-41.3416,174.785),
	(5392,'Suburb','Island Bay',42,265,-41.3357,174.773),
	(5393,'Suburb','Johnsonville',42,265,-41.2226,174.805),
	(5394,'Suburb','Kaiwharawhara',42,265,-41.2602,174.79),
	(5395,'Suburb','Karaka Bays',42,265,-41.3044,174.831),
	(5396,'Suburb','Karori',42,265,-41.2838,174.741),
	(5397,'Suburb','Kelburn',42,265,-41.2893,174.762),
	(5398,'Suburb','Khandallah',42,265,-41.2443,174.791),
	(5399,'Suburb','Kilbirnie',42,265,-41.3191,174.796),
	(5400,'Suburb','Kingston',42,265,-41.3233,174.763),
	(5401,'Suburb','Lyall Bay',42,265,-41.3269,174.795),
	(5402,'Suburb','Makara',42,265,-41.2688,174.705),
	(5403,'Suburb','Maupuia',42,265,-41.3034,174.82),
	(5404,'Suburb','Melrose',42,265,-41.3231,174.789),
	(5405,'Suburb','Miramar',42,265,-41.3169,174.818),
	(5406,'Suburb','Mornington',42,265,-41.3184,174.766),
	(5407,'Suburb','Mount Cook',42,265,-41.3014,174.774),
	(5408,'Suburb','Mount Victoria',42,265,-41.2965,174.785),
	(5409,'Suburb','Newlands',42,265,-41.2237,174.823),
	(5410,'Suburb','Newtown',42,265,-41.3109,174.779),
	(5411,'Suburb','Ngaio',42,265,-41.2513,174.773),
	(5412,'Suburb','Ngauranga',42,265,-41.2486,174.812),
	(5413,'Suburb','Northland',42,265,-41.2816,174.759),
	(5414,'Suburb','Ohariu',42,265,-41.2085,174.773),
	(5415,'Suburb','Oriental Bay',42,265,-41.2913,174.794),
	(5416,'Suburb','Owhiro Bay',42,265,-41.3444,174.759),
	(5417,'Suburb','Paparangi',42,265,-41.2142,174.817),
	(5418,'Suburb','Rongotai',42,265,-41.3235,174.804),
	(5419,'Suburb','Roseneath',42,265,-41.2877,174.802),
	(5420,'Suburb','Seatoun',42,265,-41.3246,174.832),
	(5421,'Suburb','Southgate',42,265,-41.3351,174.782),
	(5422,'Suburb','Strathmore Park',42,265,-41.3284,174.818),
	(5423,'Suburb','Tawa',42,265,-41.1703,174.825),
	(5424,'Suburb','Te Aro',42,265,-41.2955,174.777),
	(5425,'Suburb','Thorndon',42,265,-41.2766,174.778),
	(5426,'Suburb','Vogeltown',42,265,-41.3139,174.769),
	(5427,'Suburb','Wadestown',42,265,-41.2618,174.774),
	(5428,'Suburb','Wellington Central',42,265,-41.2864,174.776),
	(5429,'Suburb','Wilton',42,265,-41.2678,174.761),
	(5430,'Suburb','Annesbrook',43,271,-41.3002,173.244),
	(5431,'Suburb','Atawhai',43,271,-41.2365,173.318),
	(5432,'Suburb','Beachville',43,271,-41.2691,173.274),
	(5433,'Suburb','Bishopdale',43,271,-41.295,173.266),
	(5434,'Suburb','Britannia Heights',43,271,-41.276,173.261),
	(5435,'Suburb','Cable Bay',43,271,-41.162,173.413),
	(5436,'Suburb','Delaware Bay',43,271,-41.1593,173.476),
	(5437,'Suburb','Enner Glynn',43,271,-41.3057,173.254),
	(5438,'Suburb','Glenduan',43,271,-41.1865,173.362),
	(5439,'Suburb','Hira',43,271,-41.2171,173.396),
	(5440,'Suburb','Maitai',43,271,-41.269,173.284),
	(5441,'Suburb','Marybank',43,271,-41.2275,173.322),
	(5442,'Suburb','Moana',43,271,-41.2799,173.255),
	(5443,'Suburb','Monaco',43,271,-41.3044,173.213),
	(5444,'Suburb','Nelson City',43,271,-41.269,173.284),
	(5445,'Suburb','Nelson South',43,271,-41.2865,173.274),
	(5446,'Suburb','Nelson Surrounds',43,271,-41.269,173.284),
	(5447,'Suburb','Port Nelson',43,271,-41.264,173.278),
	(5448,'Suburb','Stepneyville',43,271,-41.2688,173.27),
	(5449,'Suburb','Stoke',43,271,-41.3183,173.227),
	(5450,'Suburb','Tahunanui',43,271,-41.2871,173.247),
	(5451,'Suburb','The Brook',43,271,-41.2823,173.291),
	(5452,'Suburb','The Wood',43,271,-41.2678,173.284),
	(5453,'Suburb','Todds Valley',43,271,-41.2165,173.34),
	(5454,'Suburb','Toi Toi',43,271,-41.2843,173.262),
	(5455,'Suburb','Wakapuaka',43,271,-41.2052,173.354),
	(5456,'Suburb','Wakatu',43,271,-41.2968,173.245),
	(5457,'Suburb','Washington Valley',43,271,-41.2718,173.272),
	(5458,'Suburb','Whangamoa',43,271,-41.1589,173.528),
	(5459,'Suburb','Abel Tasman',43,269,-41.1155,172.475),
	(5460,'Suburb','Aniseed Valley',43,269,-41.3907,173.183),
	(5461,'Suburb','Appleby',43,269,-41.3176,173.137),
	(5462,'Suburb','Atapo',43,269,-41.1155,172.475),
	(5463,'Suburb','Brightwater',43,269,-41.3781,173.116),
	(5464,'Suburb','Collingwood',43,269,-40.7143,172.684),
	(5465,'Suburb','Dovedale',43,269,-41.269,173.284),
	(5466,'Suburb','Golden Downs',43,269,-41.269,173.284),
	(5467,'Suburb','Hope',43,269,-41.3544,173.154),
	(5468,'Suburb','Kaiteriteri',43,269,-41.1155,172.475),
	(5469,'Suburb','Mahana',43,269,-41.269,173.284),
	(5470,'Suburb','Mapua',43,269,-41.269,173.284),
	(5471,'Suburb','Motueka',43,269,-41.2876,173.27),
	(5472,'Suburb','Murchison',43,269,-41.1155,172.475),
	(5473,'Suburb','Nelson Bays Coastal',43,269,-41.269,173.284),
	(5474,'Suburb','Nelson Country',43,269,-41.269,173.284),
	(5475,'Suburb','Ngatimoti',43,269,-41.1155,172.475),
	(5476,'Suburb','Parapara',43,269,-40.7143,172.684),
	(5477,'Suburb','Redwood Valley',43,269,-41.269,173.284),
	(5478,'Suburb','Richmond',43,269,-41.3385,173.184),
	(5479,'Suburb','St Arnaud',43,269,-41.9643,172.692),
	(5480,'Suburb','Takaka',43,269,-41.1155,172.475),
	(5481,'Suburb','Tapawera',43,269,-41.1155,172.475),
	(5482,'Suburb','Tasman',43,269,-41.269,173.284),
	(5483,'Suburb','Thorpe',43,269,-41.1155,172.475),
	(5484,'Suburb','Upper Moutere',43,269,-41.1155,172.475),
	(5485,'Suburb','Wakefield',43,269,-41.2665,173.266),
	(5486,'Suburb','Woodstock',43,269,-41.322,173.222),
	(5487,'Suburb','Buller Surrounds',44,274,-41.746,171.684),
	(5488,'Suburb','Cape Foulwind',44,274,-41.7497,171.482),
	(5489,'Suburb','Carters Beach',44,274,-41.7478,171.562),
	(5490,'Suburb','Charleston',44,274,-41.9058,171.439),
	(5491,'Suburb','Denniston',44,274,-41.7384,171.795),
	(5492,'Suburb','Hector',44,274,-41.6049,171.879),
	(5493,'Suburb','Inangahua',44,274,-41.8567,171.953),
	(5494,'Suburb','Kahurangi National Park',44,274,-41.1155,172.475),
	(5495,'Suburb','Karamea',44,274,-41.2476,172.111),
	(5496,'Suburb','Punakaiki',44,274,-42.1084,171.336),
	(5497,'Suburb','Reefton',44,274,-42.1146,171.863),
	(5498,'Suburb','Seddonville',44,274,-41.551,171.987),
	(5499,'Suburb','Stockton',44,274,-41.6283,171.893),
	(5500,'Suburb','Waimangaroa',44,274,-41.7143,171.762),
	(5501,'Suburb','Westport',44,274,-41.7545,171.606),
	(5502,'Suburb','Westport Surrounds',44,274,-41.746,171.684),
	(5503,'Suburb','Ahaura',44,273,-42.3494,171.54),
	(5504,'Suburb','Atarau',44,273,-42.3371,171.486),
	(5505,'Suburb','Barrytown',44,273,-42.2438,171.327),
	(5506,'Suburb','Blackball',44,273,-42.3655,171.412),
	(5507,'Suburb','Blaketown',44,273,-42.4537,171.196),
	(5508,'Suburb','Coal Creek',44,273,-42.443,171.237),
	(5509,'Suburb','Cobden',44,273,-42.4434,171.213),
	(5510,'Suburb','Dobson',44,273,-42.4494,171.312),
	(5511,'Suburb','Dunollie',44,273,-42.3936,171.258),
	(5512,'Suburb','Greymouth',44,273,-42.4545,171.206),
	(5513,'Suburb','Greymouth Surrounds',44,273,-42.4781,171.604),
	(5514,'Suburb','Haupiri',44,273,-42.5623,171.811),
	(5515,'Suburb','Hohonu',44,273,-42.6904,171.272),
	(5516,'Suburb','Ikamatua',44,273,-42.2697,171.686),
	(5517,'Suburb','Kaiata',44,273,-42.4648,171.259),
	(5518,'Suburb','Lake Brunner',44,273,-42.6119,171.439),
	(5519,'Suburb','Marsden',44,273,-42.5578,171.223),
	(5520,'Suburb','Ngahere',44,273,-42.3939,171.445),
	(5521,'Suburb','Nine Mile',44,273,-42.3488,171.259),
	(5522,'Suburb','Runanga',44,273,-42.4021,171.247),
	(5523,'Suburb','South Beach',44,273,-42.4912,171.178),
	(5524,'Suburb','Stillwater',44,273,-42.4379,171.347),
	(5525,'Suburb','Taylorville',44,273,-42.4403,171.314),
	(5526,'Suburb','Totara Flat',44,273,-42.3005,171.61),
	(5527,'Suburb','Bruce Bay',44,275,-43.6376,169.598),
	(5528,'Suburb','Fox Glacier',44,275,-43.4645,170.018),
	(5529,'Suburb','Franz Josef Glacier',44,275,-43.366,170.193),
	(5530,'Suburb','Gladstone',44,275,-42.5317,171.156),
	(5531,'Suburb','Haast',44,275,-43.8811,169.042),
	(5532,'Suburb','Harihari',44,275,-43.1483,170.551),
	(5533,'Suburb','Hokitika',44,275,-42.7174,170.967),
	(5534,'Suburb','Jackson Bay',44,275,-43.9721,168.612),
	(5535,'Suburb','Kaniere',44,275,-42.7453,171.002),
	(5536,'Suburb','Kokatahi',44,275,-42.8327,171.033),
	(5537,'Suburb','Kumara',44,275,-42.6301,171.186),
	(5538,'Suburb','Otira',44,275,-42.8302,171.565),
	(5539,'Suburb','Ross',44,275,-42.8976,170.816),
	(5540,'Suburb','Westland Area',44,275,-42.7123,170.971),
	(5541,'Suburb','Westland Surrounds',44,275,-42.7123,170.971),
	(5542,'Suburb','Whataroa',44,275,-43.2616,170.359),
	(5543,'Suburb','Clarence',51,272,-42,174),
	(5544,'Suburb','Hapuku',51,272,-41.5727,173.422),
	(5545,'Suburb','Kaikoura',51,272,-42.4008,173.681),
	(5546,'Suburb','Kaikoura Surrounds',51,272,-41.5727,173.422),
	(5547,'Suburb','Oaro',51,272,-41.5727,173.422),
	(5548,'Suburb','Stag And Spey',51,272,-41.5727,173.422),
	(5549,'Suburb','Anakiwa and Surrounds',51,270,-41.5727,173.422),
	(5550,'Suburb','Awatere Valley',51,270,-42.0852,173.261),
	(5551,'Suburb','Blenheim Central',51,270,-41.5134,173.961),
	(5552,'Suburb','Burleigh',51,270,-41.5334,173.928),
	(5553,'Suburb','Fairhall',51,270,-41.531,173.897),
	(5554,'Suburb','Grovetown',51,270,-41.4813,173.966),
	(5555,'Suburb','Havelock',51,270,-41.2846,173.767),
	(5556,'Suburb','Islington',51,270,-41.5083,173.962),
	(5557,'Suburb','Kenepuru Sound',51,270,-41.2332,173.904),
	(5558,'Suburb','Mahau Sound',51,270,-41.2384,173.898),
	(5559,'Suburb','Marlborough Country',51,270,-41.5727,173.422),
	(5560,'Suburb','Marlborough Sounds',51,270,-41.2384,173.898),
	(5561,'Suburb','Mayfield',51,270,-41.508,173.958),
	(5562,'Suburb','Okiwi Bay',51,270,-41.1113,173.662),
	(5563,'Suburb','Omaka',51,270,-41.561,173.924),
	(5564,'Suburb','Pelorous Sounds',51,270,-41.5727,173.422),
	(5565,'Suburb','Picton',51,270,-41.2906,174.001),
	(5566,'Suburb','Queen Charlotte Sound',51,270,-41.2886,173.902),
	(5567,'Suburb','Rai Valley',51,270,-41.2274,173.583),
	(5568,'Suburb','Rapaura',51,270,-41.472,173.901),
	(5569,'Suburb','Rarangi',51,270,-41.3943,174.046),
	(5570,'Suburb','Redwoodtown',51,270,-41.5287,173.951),
	(5571,'Suburb','Renwick',51,270,-41.5081,173.827),
	(5572,'Suburb','Riverlands',51,270,-41.5227,173.983),
	(5573,'Suburb','Riversdale',51,270,-41.5043,173.967),
	(5574,'Suburb','Seddon',51,270,-41.6696,174.072),
	(5575,'Suburb','Spring Creek',51,270,-41.4606,173.962),
	(5576,'Suburb','Springlands',51,270,-41.5088,173.938),
	(5577,'Suburb','Stephens Island (Takapourewa)',51,270,-40.6702,173.997),
	(5578,'Suburb','Tennyson Inlet',51,270,-41.1211,173.761),
	(5579,'Suburb','Tuamarina',51,270,-41.4293,173.961),
	(5580,'Suburb','Waihopai Valley',51,270,-41.6365,173.647),
	(5581,'Suburb','Waikawa',51,270,-41.2721,174.036),
	(5582,'Suburb','Wairau Valley',51,270,-41.5654,173.529),
	(5583,'Suburb','Ward',51,270,-41.8289,174.132),
	(5584,'Suburb','Witherlea',51,270,-41.5385,173.955),
	(5585,'Suburb','Woodbourne',51,270,-41.5123,173.867),
	(5586,'Suburb','Allenton',45,281,-43.8877,171.743),
	(5587,'Suburb','Ashburton',45,281,-43.9084,171.749),
	(5588,'Suburb','Ashburton Surrounds',45,281,-43.9084,171.749),
	(5589,'Suburb','Chertsey',45,281,-43.8026,171.935),
	(5590,'Suburb','Eiffelton',45,281,-44.0264,171.68),
	(5591,'Suburb','Elgin',45,281,-43.9013,171.802),
	(5592,'Suburb','Fairton',45,281,-43.8703,171.817),
	(5593,'Suburb','Hampstead',45,281,-43.9123,171.757),
	(5594,'Suburb','Hinds',45,281,-44.0023,171.57),
	(5595,'Suburb','Huntingdon',45,281,-43.9869,171.737),
	(5596,'Suburb','Lauriston',45,281,-43.7286,171.784),
	(5597,'Suburb','Lismore',45,281,-43.915,171.49),
	(5598,'Suburb','Mayfield',45,281,-43.8212,171.422),
	(5599,'Suburb','Methven',45,281,-43.6337,171.647),
	(5600,'Suburb','Mount Somers',45,281,-43.7043,171.4),
	(5601,'Suburb','Netherby',45,281,-43.8959,171.761),
	(5602,'Suburb','Rakaia',45,281,-43.7561,172.023),
	(5603,'Suburb','Tinwald',45,281,-43.9185,171.723),
	(5604,'Suburb','Westerfield',45,281,-43.8365,171.615),
	(5605,'Suburb','Winchmore',45,281,-43.8273,171.714),
	(5606,'Suburb','Winslow',45,281,-43.9531,171.658),
	(5607,'Suburb','Akaroa',45,280,-43.7542,171.164),
	(5608,'Suburb','Banks Peninsula Surrounds',45,280,-43.7542,171.164),
	(5609,'Suburb','Birdlings Flat',45,280,-43.7542,171.164),
	(5610,'Suburb','Cass Bay',45,280,-43.7542,171.164),
	(5611,'Suburb','Charteris Bay',45,280,-43.7542,171.164),
	(5612,'Suburb','Corsair Bay',45,280,-43.7542,171.164),
	(5613,'Suburb','Diamond Harbour',45,280,-43.7542,171.164),
	(5614,'Suburb','Duvauchelle',45,280,-43.75,173),
	(5615,'Suburb','French Farm',45,280,-43.7542,171.164),
	(5616,'Suburb','Governors Bay',45,280,-43.7542,171.164),
	(5617,'Suburb','Le Bons Bay',45,280,-43.75,173),
	(5618,'Suburb','Little Akaloa',45,280,-43.7542,171.164),
	(5619,'Suburb','Little River',45,280,-43.7542,171.164),
	(5620,'Suburb','Lyttelton',45,280,-43.7542,171.164),
	(5621,'Suburb','Motukarara',45,280,-43.7542,171.164),
	(5622,'Suburb','Okains Bay',45,280,-43.75,173),
	(5623,'Suburb','Pigeon Bay',45,280,-43.7542,171.164),
	(5624,'Suburb','Port Levy',45,280,-43.7542,171.164),
	(5625,'Suburb','Purau',45,280,-43.7542,171.164),
	(5626,'Suburb','Robinsons Bay',45,280,-43.75,173),
	(5627,'Suburb','Takamatua',45,280,-43.75,173),
	(5628,'Suburb','Wainui',45,280,-43.7542,171.164),
	(5629,'Suburb','Addington',45,282,-43.5441,172.611),
	(5630,'Suburb','Aranui',45,282,-43.5103,172.707),
	(5631,'Suburb','Avondale',45,282,-43.5038,172.687),
	(5632,'Suburb','Avonhead',45,282,-43.5147,172.554),
	(5633,'Suburb','Avonside',45,282,-43.5217,172.666),
	(5634,'Suburb','Beckenham',45,282,-43.565,172.643),
	(5635,'Suburb','Belfast',45,282,-43.4512,172.628),
	(5636,'Suburb','Bexley',45,282,-43.5122,172.714),
	(5637,'Suburb','Bishopdale',45,282,-43.4878,172.587),
	(5638,'Suburb','Bromley',45,282,-43.5362,172.694),
	(5639,'Suburb','Brooklands',45,282,-43.3994,172.696),
	(5640,'Suburb','Broomfield',45,282,-43.1184,172.686),
	(5641,'Suburb','Bryndwr',45,282,-43.5049,172.592),
	(5642,'Suburb','Burnside',45,282,-43.5096,172.576),
	(5643,'Suburb','Burwood',45,282,-43.4996,172.683),
	(5644,'Suburb','Casebrook',45,282,-43.4773,172.607),
	(5645,'Suburb','Cashmere',45,282,-43.5679,172.627),
	(5646,'Suburb','Christchurch Airport',45,282,-43.4887,172.539),
	(5647,'Suburb','Christchurch Central',45,282,-43.5321,172.636),
	(5648,'Suburb','Christchurch Surrounds',45,282,-43.5321,172.636),
	(5649,'Suburb','Clifton',45,282,-43.5701,172.753),
	(5650,'Suburb','Coutts Island',45,282,-43.4273,172.623),
	(5651,'Suburb','Cracroft',45,282,-43.5822,172.611),
	(5652,'Suburb','Dallington',45,282,-43.5135,172.674),
	(5653,'Suburb','Edgeware',45,282,-43.5134,172.647),
	(5654,'Suburb','Fendalton',45,282,-43.5195,172.601),
	(5655,'Suburb','Ferrymead',45,282,-43.5672,172.703),
	(5656,'Suburb','Halswell',45,282,-43.5854,172.571),
	(5657,'Suburb','Harewood',45,282,-43.4733,172.564),
	(5658,'Suburb','Heathcote Valley',45,282,-43.5782,172.711),
	(5659,'Suburb','Hei Hei',45,282,-43.5331,172.525),
	(5660,'Suburb','Hillmorton',45,282,-43.557,172.583),
	(5661,'Suburb','Hillsborough',45,282,-43.5625,172.676),
	(5662,'Suburb','Hoon Hay',45,282,-43.5645,172.609),
	(5663,'Suburb','Hornby',45,282,-43.5433,172.527),
	(5664,'Suburb','Huntsbury',45,282,-43.5678,172.653),
	(5665,'Suburb','Ilam',45,282,-43.5168,172.572),
	(5666,'Suburb','Islington',45,282,-43.5409,172.512),
	(5667,'Suburb','Kainga',45,282,-43.411,172.663),
	(5668,'Suburb','Kennedys Bush',45,282,-43.6033,172.581),
	(5669,'Suburb','Linwood',45,282,-43.5324,172.674),
	(5670,'Suburb','Mairehau',45,282,-43.4977,172.643),
	(5671,'Suburb','Marshland',45,282,-43.4745,172.655),
	(5672,'Suburb','Merivale',45,282,-43.5118,172.622),
	(5673,'Suburb','Middleton',45,282,-43.5442,172.591),
	(5674,'Suburb','Moncks Bay',45,282,-43.5658,172.743),
	(5675,'Suburb','Mount Pleasant',45,282,-43.563,172.716),
	(5676,'Suburb','New Brighton',45,282,-43.5073,172.729),
	(5677,'Suburb','North New Brighton',45,282,-43.4913,172.719),
	(5678,'Suburb','Northcote',45,282,-43.4841,172.606),
	(5679,'Suburb','Northwood',45,282,-43.4608,172.615),
	(5680,'Suburb','Opawa',45,282,-43.5551,172.662),
	(5681,'Suburb','Papanui',45,282,-43.4971,172.608),
	(5682,'Suburb','Parklands',45,282,-43.4812,172.705),
	(5683,'Suburb','Phillipstown',45,282,-43.5355,172.664),
	(5684,'Suburb','Redcliffs',45,282,-43.5611,172.738),
	(5685,'Suburb','Redwood',45,282,-43.4737,172.617),
	(5686,'Suburb','Riccarton',45,282,-43.53,172.597),
	(5687,'Suburb','Richmond',45,282,-43.5176,172.656),
	(5688,'Suburb','Richmond Hill',45,282,-43.5732,172.755),
	(5689,'Suburb','Russley',45,282,-43.5173,172.536),
	(5690,'Suburb','Saint Albans',45,282,-43.5052,172.627),
	(5691,'Suburb','Saint Martins',45,282,-43.5555,172.652),
	(5692,'Suburb','Shirley',45,282,-43.508,172.665),
	(5693,'Suburb','Sockburn',45,282,-43.5329,172.557),
	(5694,'Suburb','Somerfield',45,282,-43.5593,172.633),
	(5695,'Suburb','South New Brighton',45,282,-43.5301,172.74),
	(5696,'Suburb','Southshore',45,282,-43.5489,172.747),
	(5697,'Suburb','Spreydon',45,282,-43.5568,172.618),
	(5698,'Suburb','Strowan',45,282,-43.5101,172.607),
	(5699,'Suburb','Styx',45,282,-43.4464,172.657),
	(5700,'Suburb','Sumner',45,282,-43.5754,172.763),
	(5701,'Suburb','Sydenham',45,282,-43.5471,172.637),
	(5702,'Suburb','Templeton',45,282,-43.5531,172.478),
	(5703,'Suburb','Upper Riccarton',45,282,-43.532,172.574),
	(5704,'Suburb','Waimairi Beach',45,282,-43.4821,172.72),
	(5705,'Suburb','Wainoni',45,282,-43.5176,172.686),
	(5706,'Suburb','Waltham',45,282,-43.5483,172.653),
	(5707,'Suburb','Westmorland',45,282,-43.5801,172.603),
	(5708,'Suburb','Wigram',45,282,-43.5509,172.567),
	(5709,'Suburb','Woolston',45,282,-43.5474,172.679),
	(5710,'Suburb','Yaldhurst',45,282,-43.5127,172.509),
	(5711,'Suburb','Amberley',45,283,-43.1564,172.73),
	(5712,'Suburb','Balcairn',45,283,-43.2007,172.698),
	(5713,'Suburb','Cheviot',45,283,-42.8121,173.274),
	(5714,'Suburb','Culverden',45,283,-42.7726,172.849),
	(5715,'Suburb','Gore Bay',45,283,-42.8335,173.28),
	(5716,'Suburb','Hanmer Springs',45,283,-42.5262,172.829),
	(5717,'Suburb','Hawarden',45,283,-42.9233,172.641),
	(5718,'Suburb','Hundalee',45,283,-42.5988,173.42),
	(5719,'Suburb','Hurunui',45,283,-42.8797,172.754),
	(5720,'Suburb','Hurunui Surrounds',45,283,-42.8797,172.754),
	(5721,'Suburb','Leithfield',45,283,-43.1937,172.739),
	(5722,'Suburb','Leslie Hills',45,283,-42.6712,172.848),
	(5723,'Suburb','Lewis Pass',45,283,-42.5918,172.575),
	(5724,'Suburb','MacDonald Downs',45,283,-43.0203,172.519),
	(5725,'Suburb','Motunau',45,283,-43.0387,173.082),
	(5726,'Suburb','Pyramid Valley',45,283,-42.9693,172.605),
	(5727,'Suburb','Rotherham',45,283,-42.6963,172.947),
	(5728,'Suburb','Scargill',45,283,-42.9344,172.947),
	(5729,'Suburb','Virginia',45,283,-42.9133,172.354),
	(5730,'Suburb','Waiau',45,283,-42.6557,173.04),
	(5731,'Suburb','Waikari',45,283,-42.9694,172.706),
	(5732,'Suburb','Waipara',45,283,-43.0548,172.761),
	(5733,'Suburb','Albury',45,284,-44.2303,170.874),
	(5734,'Suburb','Fairlie',45,284,-44.0991,170.829),
	(5735,'Suburb','Lake Tekapo',45,284,-44.0051,170.477),
	(5736,'Suburb','Mackenzie Surrounds',45,284,-44.2824,170.089),
	(5737,'Suburb','Mt Cook',45,284,-43.9105,170.122),
	(5738,'Suburb','Twizel',45,284,-44.2599,170.104),
	(5739,'Suburb','Arthur\'s Pass',45,279,-43.0278,171.647);

/*!40000 ALTER TABLE `Locality` ENABLE KEYS */;
UNLOCK TABLES;



/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

nz-regions-and-suburbs.html

<!doctype html>

<head>
		<title>NZ Suburbs and Regions.</title>
		<script type="text/javascript">
			var realObject = {
				locations: {}
			};
		</script>
		<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js" type="text/javascript"></script>
		<script src="http://maps.google.com/maps/api/js?sensor=false" type="text/javascript"></script>
		<script src="http://www.realestate.co.nz/js-dynamic/datastore.js" type="text/javascript"></script>
</head>

<body>
	<div id="result"></div>
	
	<script type="text/javascript">

	$(document).ready(function() {
		function Output() {
			var self = this;
			this.container = $("#result");
			this.print = function(obj) {
				var regID, disID, subID;

				if(obj.hasOwnProperty("region")) {
					regID = obj.region.id;
				}
				if(obj.hasOwnProperty("district")) {
					disID = obj.district.id;
				}

				self.sql_insert(obj.id, obj.title, obj.type, obj.lat, obj.lng, regID, disID);
			};
			
			this.sql_insert = function(id, title, type, lat, lng, RegionID, DistrictID) {
				var cols = "ID, Title, Type";
				var vals = "'"+ id +"','"+title +"','"+type +"'";
				
				if(typeof lat !== "undefined") {
					cols += ", Lat";
					vals += ", "+lat;
				}
				if(typeof lng !== "undefined") {
					cols += ", Lng";
					vals += ", "+lng;
				}
				if(RegionID) {
					cols += ", RegionID";
					vals += ", "+ RegionID;
				}
				if(DistrictID) {
					cols += ", DistrictID";
					vals += ", "+ DistrictID;
				}

				self.container.append("INSERT INTO Locality ("+ cols +") VALUES("+ vals +"); <br />");
			};
		}

		
		function Parser(results) {
			var self = this;
			
			this.results = results;
			this.regions = {};
			this.districts = {};
			this.suburbs = {};
			
			this.clean = function(t) {
				if(t.indexOf('/') > 0) t = t.substr(0, t.indexOf('/'));
				if(t.indexOf('&') > 0) t = t.substr(0, t.indexOf('&'));

				return $.trim(t);
			};
			
			this.loader = {
				init: function() {
					var region, x, id, title;

					for(x in self.results.regions) {
						region = self.results.regions[x];

						id = region[0];
						title = region[1];
						
						if(title == "Pacific Islands") continue;
						
						sanitized = self.clean(title);

						self.regions[x] = {
							id: id,
							title: title,
							sanitized: sanitized,
							type: "Region"
						};
						
						this.districts(self.regions[x]);
					}
				},
				districts: function(r) {
					var x, district, id, title;

					for(x in self.results.districts[r.id]) {
						district = self.results.districts[r.id][x];
						
						id = district[0];
						title = district[1];
						
						sanitized = self.clean(title);
						
						key = r.id+"-"+x;
						
						self.districts[key] = {
							id: id,
							title: title,
							sanitized: sanitized,
							region: r,
							type: "District"
						};
						
						this.suburbs(r, self.districts[key]);
					}
				},
				suburbs: function(r, d) {
					var x, suburb, id, title;

					for(x in self.results.suburbs[d.id]) {
						suburb = self.results.suburbs[d.id][x];

						id = suburb[0];
						title = suburb[1];
						sanitized = self.clean(title);
						
						key = r.id+"-"+d.id+"-"+x;
						
						self.suburbs[key] = {
							id: id,
							title: title,
							sanitized: sanitized,
							region: r,
							type: "Suburb",
							district: d
						};
					}
				}
			};
			
			this.loader.init();
		}
		
		
		function GeocodeAddresses(addresses) {
			var self = this;
			
			this.addresses = addresses;
			this.pointerIndex = 0;
			this.limit = 20;
			this.wait = 1000; // wait between georequests
			this.geocoder = new google.maps.Geocoder();
			this.output = new Output();
			
			this.pointers = {};
			
			this.resultsSize = function() {
				var size = 0, key;
				
				for (key in this.addresses) {
					if (this.addresses.hasOwnProperty(key)) size++;
				}
				
				return size;
			};
			
			this.setupPointers = function() {
				var i = 0, key;
				
				for (key in this.addresses) {
					if (this.addresses.hasOwnProperty(key)) {
						this.pointers[i] = key;
						
						i++;
					}
				}
			};
			
			this.getPointerForIndex = function() {
				var pointer = this.pointers[this.pointerIndex];
				if(typeof pointer == "undefined") return false;
				
				return pointer;
			}

			
			this.geocode = function() {
				setTimeout(function() {
					var address, geocode_address;
					if(self.pointer >= self.resultsSize()) return;
					
					// address object, either suburb, region or district
					address = self.addresses[self.getPointerForIndex()];
					
					// create an address for this location, if it's a suburb
					// then add on the region
					geocode_address = address.sanitized;
					
					if(address.hasOwnProperty("district")) {
						geocode_address += ", " + address.district.sanitized;
					}
					if(address.hasOwnProperty("region") && (address.region.sanitized != "Manawatu" && address.region.sanitized != "Wairarapa")) {
						geocode_address += ", "+ address.region.sanitized;
					}
					
					geocode_address += ", New Zealand";
				
					self.geocoder.geocode( { 'address': geocode_address}, function(results, status) {
						if (status == google.maps.GeocoderStatus.OK) {
							var loc = results[0].geometry.location;
							address.lat = loc.lat();
							address.lng = loc.lng();
							
							self.addresses[self.getPointerForIndex()] = address;
							
							self.output.print(address);
						}
						else {
							console.log("ERROR: "+ status +" ("+ geocode_address+ ")");
							
							self.addresses[self.getPointerForIndex()] = address;
							self.output.print(address);
						}
						
						self.pointerIndex++;
						self.geocode();
					});
				
				}, this.wait);
			};
			this.setupPointers();
			this.geocode();
		}
		
		parser = new Parser(realObject.locations);
		
	//	regions = new GeocodeAddresses(parser.regions);
	//	districts = new GeocodeAddresses(parser.districts);
		suburbs = new GeocodeAddresses(parser.suburbs);


	});
</script>
</body>
</html>