Skip to content

Instantly share code, notes, and snippets.

@wilr

wilr/export.sql

Created February 8, 2011 02:12
Show Gist options
  • Save wilr/815715 to your computer and use it in GitHub Desktop.
Save wilr/815715 to your computer and use it in GitHub Desktop.
Download ZIP
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
Raw
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 */;
Raw
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>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment