/*!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 civicrm_geonames_lookup
# ------------------------------------------------------------

DROP TABLE IF EXISTS `civicrm_geonames_lookup`;

CREATE TABLE `civicrm_geonames_lookup` (
  `country` varchar(255) DEFAULT NULL,
  `postal_code` varchar(11) NOT NULL DEFAULT '',
  `city` varchar(255) DEFAULT NULL,
  `latitude` varchar(255) DEFAULT NULL,
  `longitude` varchar(255) DEFAULT NULL,
  KEY `postal_code` (`postal_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `civicrm_geonames_lookup` (`country`, `postal_code`, `city`, `latitude`, `longitude`)
VALUES
  ('NZ','0112','Whau Valley','-35.693','174.3001'),
  ('NZ','0114','Waro','-35.5909','174.2815'),
  ('NZ','0116','Ruakaka','-35.892','174.4644'),
  ('NZ','0140','Riverside','-35.7245','174.3213'),
  ('NZ','0141','Otangarei','-35.6834','174.3007'),
  ('NZ','0142','Sherwood Rise','-35.7546','174.3681'),
  ('NZ','0143','Morningside','-35.7343','174.3054'),
  ('NZ','0144','Tikipunga','-35.6866','174.3266'),
  ('NZ','0145','Kensington','-35.7085','174.3207'),
  ('NZ','0146','Maungakaramea','-35.8451','174.2048'),
  ('NZ','0147','Woodhill','-35.7429','174.308'),
  ('NZ','0148','Woodhill','-35.7512','174.3151'),
  ('NZ','0149','Riverside','-35.7247','174.3259'),
  ('NZ','0150','Hikurangi','-35.5979','174.2863'),
  ('NZ','0151','Ruakaka','-35.8751','174.4554'),
  ('NZ','0152','Maungatapere','-35.7549','174.2081'),
  ('NZ','0153','Tutukaka','-35.6129','174.522'),
  ('NZ','0154','Ngunguru','-35.6297','174.5041'),
  ('NZ','0170','Puwera','-35.7762','174.268'),
  ('NZ','0171','Mata','-35.8556','174.3925'),
  ('NZ','0172','Parakao','-35.7039','173.9353'),
  ('NZ','0173','Kiripaka','-35.6147','174.4391'),
  ('NZ','0174','Whangarei Heads','-35.8069','174.4823'),
  ('NZ','0175','Tahere','-35.6943','174.4312'),
  ('NZ','0176','Moengawahine','-35.6306','174.1057'),
  ('NZ','0178','Maungakaramea','-35.852','174.2236'),
  ('NZ','0179','Maungatapere','-35.7562','174.1728'),
  ('NZ','0181','Marua','-35.5606','174.3839'),
  ('NZ','0182','Hukerenui','-35.4967','174.1879'),
  ('NZ','0184','Whangaruru North','-35.3593','174.3023'),
  ('NZ','0185','Ruatangata East','-35.6304','174.216'),
  ('NZ','0192','Rukuwai','-35.7429','174.4705'),
  ('NZ','0193','Waiotira','-35.9554','174.196'),
  ('NZ','0200','Opua','-35.3073','174.0975'),
  ('NZ','0202','Russell','-35.2557','174.1233'),
  ('NZ','0210','Kawakawa','-35.3838','174.0668'),
  ('NZ','0211','Moerewa','-35.3867','174.0249'),
  ('NZ','0230','Kerikeri','-35.2336','173.9593'),
  ('NZ','0241','Opua','-35.3124','174.1206'),
  ('NZ','0242','Russell','-35.2629','174.1227'),
  ('NZ','0243','Kawakawa','-35.3799','174.0672'),
  ('NZ','0244','Moerewa','-35.3875','174.0144'),
  ('NZ','0245','Kerikeri','-35.2289','173.9487'),
  ('NZ','0246','Waipapa','-35.206','173.9167'),
  ('NZ','0247','Paihia','-35.282','174.0915'),
  ('NZ','0271','Haruru','-35.2851','174.0397'),
  ('NZ','0272','Manawaora','-35.2844','174.1759'),
  ('NZ','0281','Pokere','-35.4904','174.0032'),
  ('NZ','0282','Karetu','-35.375','174.1364'),
  ('NZ','0283','Waihaha','-35.3488','174.1925'),
  ('NZ','0293','Puketona','-35.2621','173.9724'),
  ('NZ','0294','Purerua','-35.1578','174.0225'),
  ('NZ','0295','Waipapa','-35.1769','173.876'),
  ('NZ','0310','Dargaville','-35.9542','173.8785'),
  ('NZ','0340','Dargaville','-35.9413','173.8697'),
  ('NZ','0341','Te Kopura','-36.0309','173.923'),
  ('NZ','0370','Arapohue','-36.0004','174.0199'),
  ('NZ','0371','Redhill','-36.0523','173.8603'),
  ('NZ','0372','Kairara','-35.8194','173.8585'),
  ('NZ','0373','Mamaranui','-35.8591','173.7106'),
  ('NZ','0374','Arapohue','-35.9673','173.9916'),
  ('NZ','0376','Tutamoe','-35.6467','173.6147'),
  ('NZ','0377','Baylys Beach','-35.9515','173.7818'),
  ('NZ','0379','Whatoro','-35.7555','173.6729'),
  ('NZ','0381','Kirikopuni','-35.8384','174.0082'),
  ('NZ','0391','Tangaihe','-36.2126','174.038'),
  ('NZ','0405','Kaikohe','-35.401','173.7896'),
  ('NZ','0410','Kaitaia','-35.1134','173.2502'),
  ('NZ','0420','Taipa','-35.0008','173.4958'),
  ('NZ','0440','Kaikohe','-35.4081','173.7986'),
  ('NZ','0441','Kaitaia','-35.114','173.2637'),
  ('NZ','0442','Mangonui','-34.9896','173.5367'),
  ('NZ','0443','Rawene','-35.3932','173.5057'),
  ('NZ','0444','Omapere','-35.5367','173.3862'),
  ('NZ','0445','Opononi','-35.5046','173.3924'),
  ('NZ','0446','Waimamaku','-35.556','173.4759'),
  ('NZ','0447','Okaihau','-35.3201','173.7713'),
  ('NZ','0448','Kaeo','-35.1006','173.7805'),
  ('NZ','0449','Ahipara','-35.1709','173.1534'),
  ('NZ','0451','Awanui','-35.048','173.2565'),
  ('NZ','0453','Kohukohu','-35.3582','173.5461'),
  ('NZ','0460','Pukenui','-34.8149','173.1179'),
  ('NZ','0462','Broadwood','-35.2592','173.3896'),
  ('NZ','0472','Pakaraka','-35.3618','173.9337'),
  ('NZ','0473','Waima','-35.4963','173.5549'),
  ('NZ','0474','Tautoro','-35.5071','173.8144'),
  ('NZ','0475','Marangai','-35.3278','173.6987'),
  ('NZ','0476','Umawera','-35.2385','173.6264'),
  ('NZ','0478','Kaeo','-35.0974','173.7895'),
  ('NZ','0479','Saies','-35.0791','173.6798'),
  ('NZ','0481','Manukau','-35.2366','173.2382'),
  ('NZ','0482','Kaiaka','-35.1122','173.4133'),
  ('NZ','0483','Lake Ohia','-34.9593','173.3595'),
  ('NZ','0484','Te Kao','-34.6874','172.924'),
  ('NZ','0486','Waiharera','-34.9757','173.2179'),
  ('NZ','0491','Broadwood','-35.2764','173.4408'),
  ('NZ','0492','Panguru','-35.4197','173.3623'),
  ('NZ','0494','Paraoanui','-35.0088','173.621'),
  ('NZ','0496','Pawarenga','-35.3437','173.3046'),
  ('NZ','0505','Mangawhai Heads','-36.0858','174.5842'),
  ('NZ','0510','Waipu','-35.9822','174.4508'),
  ('NZ','0520','Rowsells','-36.1077','174.3568'),
  ('NZ','0530','Ruawai','-36.1322','174.0277'),
  ('NZ','0540','Mangawhai','-36.1258','174.5746'),
  ('NZ','0541','Mangawhai Heads','-36.0946','174.5874'),
  ('NZ','0542','Kaiwaka','-36.1642','174.4428'),
  ('NZ','0543','Paparoa','-36.103','174.2315'),
  ('NZ','0545','Waipu','-35.9842','174.4453'),
  ('NZ','0547','Rowsells','-36.1101','174.3537'),
  ('NZ','0549','Ruawai','-36.1365','174.0233'),
  ('NZ','0550','Matakohe','-36.1298','174.1825'),
  ('NZ','0571','Mareretu','-36.053','174.2547'),
  ('NZ','0573','Kaiwaka','-36.1881','174.429'),
  ('NZ','0582','Waipu','-36.0052','174.4499'),
  ('NZ','0583','Marohemo','-36.1641','174.2892'),
  ('NZ','0587','Ranganui','-36.1441','174.4093'),
  ('NZ','0588','Maungaturoto','-36.0723','174.3737'),
  ('NZ','0589','Huarau','-36.0601','174.3167'),
  ('NZ','0591','Ruawai','-36.1195','174.0709'),
  ('NZ','0592','Rehia','-36.0549','174.0388'),
  ('NZ','0593','Pahi','-36.1962','174.2067'),
  ('NZ','0594','Matakohe','-36.0672','174.1446'),
  ('NZ','0600','Blockhouse Bay','-36.9158','174.6921'),
  ('NZ','0602','Kelston','-36.9042','174.6474'),
  ('NZ','0604','Huia','-36.9808','174.5827'),
  ('NZ','0610','Te Atatu South','-36.8531','174.6466'),
  ('NZ','0612','McLaren Park','-36.8989','174.5918'),
  ('NZ','0614','Swanson','-36.8546','174.5839'),
  ('NZ','0618','Hobsonville','-36.7987','174.6378'),
  ('NZ','0620','Forrest Hill','-36.7661','174.7548'),
  ('NZ','0622','Belmont','-36.801','174.778'),
  ('NZ','0624','Devonport','-36.8236','174.7918'),
  ('NZ','0626','Chatswood','-36.8058','174.7083'),
  ('NZ','0627','North Shore','-36.798','174.7462'),
  ('NZ','0629','Marlborough','-36.7753','174.7199'),
  ('NZ','0630','Browns Bay','-36.7215','174.7447'),
  ('NZ','0632','Greenhithe','-36.7443','174.6947'),
  ('NZ','0640','New Lynn','-36.9079','174.6831'),
  ('NZ','0641','Glen Eden','-36.9118','174.652'),
  ('NZ','0642','Titirangi','-36.9378','174.6575'),
  ('NZ','0643','Green Bay','-36.9306','174.6801'),
  ('NZ','0644','Blockhouse Bay','-36.9234','174.7015'),
  ('NZ','0645','Glendene','-36.8869','174.6446'),
  ('NZ','0650','Sunnyvale','-36.881','174.6347'),
  ('NZ','0651','Te Atatu','-36.8422','174.6515'),
  ('NZ','0652','Te Atatu South','-36.865','174.6463'),
  ('NZ','0653','Swanson','-36.8655','174.58'),
  ('NZ','0654','Te Atatu South','-36.8557','174.6298'),
  ('NZ','0655','Swanson','-36.8639','174.6011'),
  ('NZ','0656','Massey East','-36.8332','174.6224'),
  ('NZ','0657','West Harbour','-36.8222','174.6105'),
  ('NZ','0660','Waitakere','-36.8492','174.5447'),
  ('NZ','0661','Te Atatu Peninsula','-36.8107','174.6446'),
  ('NZ','0662','Brighams Creek','-36.7935','174.6163'),
  ('NZ','0663','Massey East','-36.8185','174.6292'),
  ('NZ','0740','Hauraki','-36.7875','174.7729'),
  ('NZ','0741','Milford','-36.7728','174.7661'),
  ('NZ','0742','Torbay','-36.6949','174.7506'),
  ('NZ','0743','Forrest Hill','-36.7512','174.7467'),
  ('NZ','0744','Devenport','-36.8303','174.7969'),
  ('NZ','0745','Glenfield','-36.768','174.7395'),
  ('NZ','0746','Birkenhead','-36.8123','174.7254'),
  ('NZ','0747','Marlborough','-36.782','174.7216'),
  ('NZ','0748','North Shore','-36.8017','174.7446'),
  ('NZ','0749','Birkdale','-36.7925','174.6872'),
  ('NZ','0750','Takapuna','-36.7969','174.7782'),
  ('NZ','0751','Glenfield','-36.7513','174.7139'),
  ('NZ','0752','Albany','-36.7313','174.7075'),
  ('NZ','0753','Browns Bay','-36.7155','174.7484'),
  ('NZ','0754','Mairangi Bay','-36.7384','174.7534'),
  ('NZ','0755','Albany','-36.7246','174.6952'),
  ('NZ','0756','Paremoremo','-36.7758','174.6702'),
  ('NZ','0757','Forrest Hill','-36.743','174.7248'),
  ('NZ','0758','Mairangi Bay','-36.7397','174.7419'),
  ('NZ','0772','Karekare','-36.9656','174.4894'),
  ('NZ','0781','Piha','-36.8981','174.4855'),
  ('NZ','0782','Waitakere','-36.8333','174.5225'),
  ('NZ','0792','Red Vale','-36.6884','174.6927'),
  ('NZ','0793','Coatesville','-36.7222','174.6236'),
  ('NZ','0794','Dairy Flat','-36.6687','174.6549'),
  ('NZ','0800','Helensville','-36.6765','174.4527'),
  ('NZ','0810','Huapai','-36.7726','174.5488'),
  ('NZ','0812','Waimauku','-36.7661','174.4923'),
  ('NZ','0814','West Harbour','-36.8061','174.5993'),
  ('NZ','0820','Riverhead','-36.7582','174.5898'),
  ('NZ','0830','Parakai','-36.6596','174.434'),
  ('NZ','0840','Helensville','-36.6764','174.4505'),
  ('NZ','0841','Huapai','-36.7754','174.5548'),
  ('NZ','0842','Pahitoa','-36.7687','174.4925'),
  ('NZ','0843','Kaukapakapa','-36.6164','174.4933'),
  ('NZ','0871','Kaukapakapa','-36.6354','174.5287'),
  ('NZ','0873','Parakakau','-36.5611','174.5841'),
  ('NZ','0874','Parkhurst','-36.5652','174.3028'),
  ('NZ','0875','Helensville','-36.6868','174.4557'),
  ('NZ','0881','Woodhill','-36.7829','174.4262'),
  ('NZ','0882','Waimauku','-36.7176','174.5263'),
  ('NZ','0883','Pahitoa','-36.7604','174.4673'),
  ('NZ','0891','Huapai','-36.7875','174.5296'),
  ('NZ','0892','Kumeu','-36.7596','174.571'),
  ('NZ','0900','Wellsford','-36.2914','174.5168'),
  ('NZ','0910','Warkworth','-36.4018','174.6626'),
  ('NZ','0920','Leigh','-36.308','174.9148'),
  ('NZ','0930','Whangaparaoa','-36.6172','174.7966'),
  ('NZ','0931','Orewa','-36.58','174.6853'),
  ('NZ','0932','Red Beach','-36.6232','174.7063'),
  ('NZ','0940','Wellsford','-36.2938','174.5238'),
  ('NZ','0941','Warkworth','-36.3978','174.6639'),
  ('NZ','0942','Snells Beach','-36.4204','174.7235'),
  ('NZ','0943','Whangaparaoa','-36.6366','174.748'),
  ('NZ','0944','Silverdale','-36.6178','174.6778'),
  ('NZ','0945','Red Beach','-36.6056','174.6978'),
  ('NZ','0946','Orewa','-36.5856','174.6943'),
  ('NZ','0947','Leigh','-36.2905','174.8047'),
  ('NZ','0948','Matakana','-36.3519','174.7169'),
  ('NZ','0950','Waiwera','-36.5447','174.7058'),
  ('NZ','0951','Puhoi','-36.5121','174.661'),
  ('NZ','0960','Okiwi','-36.1556','175.3935'),
  ('NZ','0961','Okupu','-36.2427','175.462'),
  ('NZ','0962','Tryphena','-36.3015','175.4883'),
  ('NZ','0963','Port Fitzroy','-36.1639','175.3624'),
  ('NZ','0972','Wayby','-36.3001','174.6127'),
  ('NZ','0973','Wharehine','-36.315','174.447'),
  ('NZ','0974','Te Hana','-36.2485','174.6008'),
  ('NZ','0975','Topuni','-36.1895','174.5252'),
  ('NZ','0977','Wharehine','-36.3561','174.3225'),
  ('NZ','0981','Woodcocks','-36.4243','174.5979'),
  ('NZ','0982','Algies Bay','-36.4404','174.7235'),
  ('NZ','0983','Pohuehue','-36.4709','174.6573'),
  ('NZ','0984','Ahuroa','-36.501','174.5307'),
  ('NZ','0985','Big Omaha','-36.3249','174.7381'),
  ('NZ','0986','Tawharanui','-36.3544','174.8003'),
  ('NZ','0991','Whangapara','-36.2','175.4287'),
  ('NZ','0992','Silverdale','-36.5992','174.6619'),
  ('NZ','0993','Red Beach','-36.6373','174.693'),
  ('NZ','1010','Auckland','-36.85','174.765'),
  ('NZ','1011','Herne Bay','-36.8447','174.7336'),
  ('NZ','1021','Arch Hill','-36.863','174.7432'),
  ('NZ','1022','Point Chevalier','-36.8585','174.7053'),
  ('NZ','1023','Epsom','-36.8872','174.7709'),
  ('NZ','1024','Epsom','-36.8877','174.7529'),
  ('NZ','1025','Sandringham','-36.8844','174.7238'),
  ('NZ','1026','Waterview','-36.876','174.6829'),
  ('NZ','1041','Mount Roskill','-36.9125','174.7335'),
  ('NZ','1042','Hillsborough','-36.9213','174.7393'),
  ('NZ','1050','Remuera','-36.8768','174.8042'),
  ('NZ','1051','Ellerslie','-36.8917','174.8071'),
  ('NZ','1052','Point Resolution','-36.857','174.7914'),
  ('NZ','1060','Penrose','-36.9177','174.8356'),
  ('NZ','1061','Te Papapa','-36.9155','174.7991'),
  ('NZ','1062','OTAHUHU','-36.941','174.8483'),
  ('NZ','1071','Kohimarama','-36.8565','174.8482'),
  ('NZ','1072','Tamaki','-36.8873','174.8528'),
  ('NZ','1081','Surfdale','-36.7911','175.0257'),
  ('NZ','1081','Ostend','-36.7932','175.0362'),
  ('NZ','1140','Mechanics Bay','-36.8472','174.7692'),
  ('NZ','1141','Newmarket','-36.8507','174.7632'),
  ('NZ','1142','Newton','-36.8478','174.7577'),
  ('NZ','1143','Mechanics Bay','-36.8451','174.7675'),
  ('NZ','1144','Freemans Bay','-36.8481','174.7437'),
  ('NZ','1145','Grafton','-36.8578','174.7579'),
  ('NZ','1147','Herne Bay','-36.846','174.7339'),
  ('NZ','1148','Auckland','-36.8609','174.7695'),
  ('NZ','1149','Parnell','-36.8731','174.7773'),
  ('NZ','1150','Auckland','-36.8641','174.7621'),
  ('NZ','1151','Point Resolution','-36.8568','174.7811'),
  ('NZ','1245','Western Springs','-36.8654','174.7378'),
  ('NZ','1246','Mount Albert','-36.8702','174.7107'),
  ('NZ','1340','Wesley','-36.9004','174.72'),
  ('NZ','1342','Balmoral','-36.8885','174.7472'),
  ('NZ','1344','One Tree Hill','-36.8918','174.7745'),
  ('NZ','1345','Royal Oak','-36.9117','174.7763'),
  ('NZ','1346','Sandringham','-36.8837','174.733'),
  ('NZ','1347','One Tree Hill','-36.9001','174.7734'),
  ('NZ','1348','Avondale','-36.8878','174.6845'),
  ('NZ','1349','Epsom','-36.8823','174.7619'),
  ('NZ','1350','Owairaka','-36.8849','174.715'),
  ('NZ','1351','Balmoral','-36.893','174.7363'),
  ('NZ','1352','Mount Eden','-36.8724','174.744'),
  ('NZ','1440','Three Kings','-36.9032','174.742'),
  ('NZ','1443','Lynfield','-36.9262','174.7231'),
  ('NZ','1445','Waikowhai','-36.9202','174.7367'),
  ('NZ','1446','Mount Eden','-36.8801','174.7495'),
  ('NZ','1541','Greenlane','-36.8804','174.798'),
  ('NZ','1542','Ellerslie','-36.898','174.8092'),
  ('NZ','1543','Greenlane','-36.8823','174.7849'),
  ('NZ','1544','Ellerslie','-36.8992','174.8053'),
  ('NZ','1545','Panmure','-36.8961','174.8324'),
  ('NZ','1546','Ellerslie','-36.895','174.8001'),
  ('NZ','1640','Otahuhu','-36.9444','174.8441'),
  ('NZ','1641','Panmure','-36.9079','174.838'),
  ('NZ','1642','Mount Wellington','-36.9097','174.8145'),
  ('NZ','1643','Onehunga','-36.9205','174.7861'),
  ('NZ','1740','Saint Heliers','-36.8507','174.8577'),
  ('NZ','1741','Panmure','-36.9005','174.8557'),
  ('NZ','1742','Meadowbank','-36.8757','174.8277'),
  ('NZ','1743','Point England','-36.8791','174.8552'),
  ('NZ','1744','Mission Bay','-36.8493','174.8288'),
  ('NZ','1745','Orakei','-36.856','174.8147'),
  ('NZ','1746','New Windsor','-36.8975','174.6973'),
  ('NZ','1840','Oneroa','-36.7834','175.0105'),
  ('NZ','1841','Onetangi','-36.792','175.0798'),
  ('NZ','1842','Blackpool','-36.7938','175.026'),
  ('NZ','1843','Ostend','-36.796','175.0465'),
  ('NZ','1971','Onetangi','-36.7931','175.0922'),
  ('NZ','2010','Pakuranga Heights','-36.9104','174.8925'),
  ('NZ','2012','Eastern Beach','-36.8714','174.8979'),
  ('NZ','2013','East Tamaki','-36.9373','174.8935'),
  ('NZ','2014','Shelly Park','-36.898','174.9308'),
  ('NZ','2016','East Tamaki','-36.9647','174.9241'),
  ('NZ','2018','Beachlands','-36.8818','175.0134'),
  ('NZ','2022','Mangere','-36.9784','174.7817'),
  ('NZ','2023','Wiri','-36.969','174.8822'),
  ('NZ','2024','Mangere East','-36.9559','174.8184'),
  ('NZ','2025','Wiri','-36.9915','174.8466'),
  ('NZ','2102','Manurewa','-37.0234','174.8856'),
  ('NZ','2103','Weymouth','-37.0408','174.8752'),
  ('NZ','2104','Wiri','-37.0011','174.8672'),
  ('NZ','2105','Manurewa East','-37.0135','174.9183'),
  ('NZ','2110','Red Hill','-37.0609','174.9656'),
  ('NZ','2112','Takanini','-37.045','174.9202'),
  ('NZ','2113','Papakura','-37.0874','174.9409'),
  ('NZ','2120','Pukekohe','-37.2088','174.8945'),
  ('NZ','2121','Tuakau','-37.2674','174.9395'),
  ('NZ','2122','Waiau Pa','-37.1379','174.6979'),
  ('NZ','2123','Waiuku','-37.2484','174.7359'),
  ('NZ','2140','Pakuranga','-36.9121','174.8708'),
  ('NZ','2141','East Tamaki','-36.9311','174.8971'),
  ('NZ','2142','East Tamaki','-36.9322','174.9122'),
  ('NZ','2143','Botany Downs','-36.8983','174.9069'),
  ('NZ','2144','Eastern Beach','-36.8681','174.904'),
  ('NZ','2145','Shelly Park','-36.8937','174.9315'),
  ('NZ','2146','Shelly Park','-36.9041','174.9392'),
  ('NZ','2147','Beachlands','-36.8825','174.9969'),
  ('NZ','2148','Maraetai','-36.8803','175.0343'),
  ('NZ','2149','Whitford','-36.9455','174.965'),
  ('NZ','2150','Mangere','-36.9986','174.7885'),
  ('NZ','2151','Favona','-36.9422','174.7875'),
  ('NZ','2153','Mangere','-36.9702','174.7993'),
  ('NZ','2154','Mangere','-36.9699','174.7856'),
  ('NZ','2155','Papatoetoe','-36.9714','174.8621'),
  ('NZ','2156','Papatoetoe','-36.9797','174.8541'),
  ('NZ','2157','Wiri','-36.9805','174.8767'),
  ('NZ','2158','Mangere East','-36.9665','174.8251'),
  ('NZ','2159','Otara','-36.9611','174.8732'),
  ('NZ','2160','Wiri','-36.9774','174.8967'),
  ('NZ','2240','Homai','-37.0068','174.875'),
  ('NZ','2241','Wiri','-36.992','174.8815'),
  ('NZ','2242','Weymouth','-37.0333','174.8692'),
  ('NZ','2243','Manurewa East','-37.0221','174.8966'),
  ('NZ','2244','Pahurehure','-37.0616','174.9417'),
  ('NZ','2245','Takanini','-37.0392','174.9198'),
  ('NZ','2246','Pahurehure','-37.0487','174.9282'),
  ('NZ','2247','Drury','-37.1023','174.9514'),
  ('NZ','2248','Clevedon','-36.9927','175.0373'),
  ('NZ','2340','Pukekohe','-37.1999','174.9058'),
  ('NZ','2341','Waiuku','-37.251','174.7286'),
  ('NZ','2342','Tuakau','-37.258','174.9466'),
  ('NZ','2343','Bombay','-37.1862','174.9912'),
  ('NZ','2344','Patumahoe','-37.1871','174.829'),
  ('NZ','2345','Waiau Pa','-37.1495','174.7647'),
  ('NZ','2440','Pokeno','-37.2457','175.0215'),
  ('NZ','2441','Meremere','-37.3231','175.0694'),
  ('NZ','2471','Kopuku','-37.2445','175.1648'),
  ('NZ','2472','Pokeno','-37.2225','175.0053'),
  ('NZ','2473','Kaiaua','-37.1222','175.2316'),
  ('NZ','2474','Mercer','-37.2798','175.0728'),
  ('NZ','2571','Waikopua','-36.9162','174.9911'),
  ('NZ','2576','Whitford','-36.9781','174.9855'),
  ('NZ','2577','Drury','-37.1147','174.9742'),
  ('NZ','2578','Ramarama','-37.1313','174.935'),
  ('NZ','2579','Ararimu','-37.1435','175.0191'),
  ('NZ','2580','Weymouth','-37.1032','174.8609'),
  ('NZ','2582','Clevedon','-36.9738','175.0179'),
  ('NZ','2583','Paparimu','-37.0996','175.1194'),
  ('NZ','2584','Opaheke','-37.1003','175.0012'),
  ('NZ','2585','Whakatiri','-36.9896','175.1647'),
  ('NZ','2675','Ararimu','-37.185','175.0338'),
  ('NZ','2676','Paerata','-37.1735','174.8913'),
  ('NZ','2677','Pukekohe East','-37.216','174.9333'),
  ('NZ','2678','Mauku','-37.2305','174.8412'),
  ('NZ','2679','Waiau Pa','-37.1394','174.7893'),
  ('NZ','2681','Glenbrook','-37.2045','174.7561'),
  ('NZ','2682','Otaua','-37.3092','174.7493'),
  ('NZ','2683','Waipipi','-37.2288','174.6664'),
  ('NZ','2684','Pollok','-37.1187','174.6161'),
  ('NZ','2693','Te Kohanga','-37.3001','174.8746'),
  ('NZ','2694','Tuakau','-37.2626','174.9591'),
  ('NZ','2695','Kaawa','-37.4521','174.8611'),
  ('NZ','2696','Opuatia','-37.3556','175.0016'),
  ('NZ','2697','Te Kohanga','-37.3909','174.871'),
  ('NZ','3010','Ohinemutu','-38.1178','176.2514'),
  ('NZ','3015','Sunnybrook','-38.1483','176.2067'),
  ('NZ','3020','Mamaku','-38.0956','176.0755'),
  ('NZ','3025','Murupara','-38.4571','176.709'),
  ('NZ','3040','Ngapuna','-38.1377','176.2507'),
  ('NZ','3041','Ngongotaha','-38.0805','176.2124'),
  ('NZ','3042','Owhata','-38.1345','176.2952'),
  ('NZ','3043','Whakarewarewa','-38.1591','176.2567'),
  ('NZ','3044','Glenholme','-38.1448','176.2375'),
  ('NZ','3045','Ngapuna','-38.14','176.2516'),
  ('NZ','3046','Koutu','-38.1294','176.2337'),
  ('NZ','3047','Mangakakahi','-38.1291','176.2195'),
  ('NZ','3048','Tihiotonga','-38.1602','176.2355'),
  ('NZ','3049','Mamaku','-38.0953','176.0768'),
  ('NZ','3060','Reporoa','-38.436','176.3411'),
  ('NZ','3062','Murupara','-38.4562','176.7041'),
  ('NZ','3072','Tarukenga','-38.062','176.1258'),
  ('NZ','3073','Waimangu','-38.2904','176.4731'),
  ('NZ','3074','Tikitere','-38.0913','176.4142'),
  ('NZ','3076','Punaroma','-38.1809','176.362'),
  ('NZ','3077','Guthrie','-38.3201','176.2239'),
  ('NZ','3078','Atiamuri','-38.4262','175.9947'),
  ('NZ','3079','Ruatahuna','-38.5567','176.8892'),
  ('NZ','3081','Tahorakui','-38.6353','176.4422'),
  ('NZ','3083','Tahorakui','-38.4805','176.2263'),
  ('NZ','3110','Tauranga','-37.6686','176.2664'),
  ('NZ','3112','Hairini','-37.7273','176.1538'),
  ('NZ','3114','Omokoroa Beach','-37.6348','176.0467'),
  ('NZ','3116','Omanu','-37.6536','176.2044'),
  ('NZ','3118','Papamoa Beach','-37.7146','176.3294'),
  ('NZ','3119','Te Puke','-37.7775','176.3267'),
  ('NZ','3120','Poroporo','-37.9555','176.9225'),
  ('NZ','3121','Ohope Beach','-37.97','177.084'),
  ('NZ','3122','Opotiki','-38.0138','177.2788'),
  ('NZ','3123','Taneatua','-38.0646','177.0066'),
  ('NZ','3127','Kawerau','-38.0905','176.6964'),
  ('NZ','3129','Katikati','-37.5499','175.9175'),
  ('NZ','3140','Tauranga','-37.6934','176.1622'),
  ('NZ','3141','Tauranga','-37.685','176.1682'),
  ('NZ','3142','Greerton','-37.7267','176.1332'),
  ('NZ','3143','Tauranga','-37.6739','176.1649'),
  ('NZ','3144','Tauranga','-37.6982','176.1597'),
  ('NZ','3145','Otumoetai','-37.6684','176.1405'),
  ('NZ','3146','Judea','-37.6898','176.1352'),
  ('NZ','3147','Bethlehem','-37.6959','176.1094'),
  ('NZ','3148','Hairini','-37.7162','176.1793'),
  ('NZ','3149','Omanu','-37.6553','176.2004'),
  ('NZ','3150','Mount Maunganui','-37.6381','176.1836'),
  ('NZ','3151','Kairua','-37.7006','176.2838'),
  ('NZ','3152','Omanu Beach','-37.676','176.223'),
  ('NZ','3153','Te Puke','-37.7849','176.3275'),
  ('NZ','3154','Omokoroa Beach','-37.6326','176.0523'),
  ('NZ','3158','Whakatane','-37.9524','176.9959'),
  ('NZ','3159','Poroporo','-37.9621','176.9819'),
  ('NZ','3160','Edgecumbe','-37.9752','176.8264'),
  ('NZ','3161','Ohope Beach','-37.9642','177.0361'),
  ('NZ','3162','Opotiki','-38.0057','177.2847'),
  ('NZ','3163','Taneatua','-38.0653','177.0034'),
  ('NZ','3164','Waimana','-38.1431','177.0767'),
  ('NZ','3166','Katikati','-37.5528','175.9174'),
  ('NZ','3167','Te Teko','-38.0362','176.7976'),
  ('NZ','3168','Matata','-37.8886','176.7586'),
  ('NZ','3169','Kawerau','-38.0867','176.7012'),
  ('NZ','3171','Lower Kaimai','-37.8097','176.025'),
  ('NZ','3172','Omokoroa Beach','-37.5886','176.0675'),
  ('NZ','3173','Oropi','-37.8386','176.1706'),
  ('NZ','3175','Upper Papamoa','-37.7411','176.2216'),
  ('NZ','3176','Whakamarama','-37.7138','176.0076'),
  ('NZ','3177','Athenree','-37.4922','175.9169'),
  ('NZ','3178','Katikati','-37.5826','175.8646'),
  ('NZ','3182','Te Puke','-37.8464','176.2895'),
  ('NZ','3183','Upper Papamoa','-37.8103','176.2666'),
  ('NZ','3186','Ohinepanea','-37.8915','176.4704'),
  ('NZ','3187','Papamoa','-37.74','176.3135'),
  ('NZ','3188','Ngawaro','-37.8957','176.1919'),
  ('NZ','3189','Paengaroa','-37.8464','176.413'),
  ('NZ','3191','Otangihaku','-38.0615','176.9708'),
  ('NZ','3192','Kawerau','-38.1218','176.7807'),
  ('NZ','3193','Edgecumbe','-37.963','176.8355'),
  ('NZ','3194','Awakaponga','-37.9481','176.7675'),
  ('NZ','3196','Waimana','-38.2072','177.1206'),
  ('NZ','3197','Toatoa','-38.172','177.4113'),
  ('NZ','3198','Waimana','-38.1269','177.1553'),
  ('NZ','3199','Omaio','-37.8634','177.8537'),
  ('NZ','3200','Te Rapa','-37.761','175.2474'),
  ('NZ','3204','Frankton Junction','-37.7974','175.2604'),
  ('NZ','3206','Melville','-37.8198','175.2865'),
  ('NZ','3210','Claudelands','-37.7463','175.2707'),
  ('NZ','3214','Hamilton','-37.7709','175.2985'),
  ('NZ','3216','Hamilton East','-37.7961','175.3088'),
  ('NZ','3218','Temple View','-37.8198','175.2282'),
  ('NZ','3225','Raglan','-37.8109','174.8709'),
  ('NZ','3240','Hamilton West','-37.7849','175.276'),
  ('NZ','3241','Te Rapa','-37.7571','175.2475'),
  ('NZ','3242','Hamilton West','-37.7881','175.2644'),
  ('NZ','3243','Frankton Junction','-37.7955','175.2458'),
  ('NZ','3244','Hamilton','-37.7852','175.2802'),
  ('NZ','3245','Melville','-37.8175','175.2825'),
  ('NZ','3246','Melville','-37.8224','175.2876'),
  ('NZ','3247','Hamilton East','-37.7914','175.2944'),
  ('NZ','3248','Claudelands','-37.7514','175.2799'),
  ('NZ','3249','Te Rapa','-37.738','175.253'),
  ('NZ','3251','Hamilton East','-37.7985','175.3157'),
  ('NZ','3252','Claudelands','-37.7723','175.2934'),
  ('NZ','3253','Newstead','-37.8017','175.3223'),
  ('NZ','3254','Newstead','-37.7899','175.3261'),
  ('NZ','3255','Hamilton East','-37.7876','175.3166'),
  ('NZ','3256','Claudelands','-37.729','175.2734'),
  ('NZ','3257','Claudelands','-37.7651','175.2534'),
  ('NZ','3260','Matangi','-37.8043','175.395'),
  ('NZ','3261','Whatawhata','-37.7974','175.1535'),
  ('NZ','3262','Horotiu','-37.6941','175.19'),
  ('NZ','3263','Te Kowhai','-37.7433','175.1526'),
  ('NZ','3264','Gordonton','-37.6696','175.3041'),
  ('NZ','3265','Raglan','-37.8003','174.87'),
  ('NZ','3266','Te Uku','-37.8289','174.957'),
  ('NZ','3281','Gordonton','-37.6905','175.3075'),
  ('NZ','3282','Rukuhia','-37.843','175.2852'),
  ('NZ','3283','Tamahere','-37.8514','175.3865'),
  ('NZ','3284','Eureka','-37.7576','175.3961'),
  ('NZ','3285','Aramiro','-37.9049','175.0829'),
  ('NZ','3288','Te Kowhai','-37.7355','175.174'),
  ('NZ','3289','Whatawhata','-37.7794','175.136'),
  ('NZ','3290','Temple View','-37.8461','175.1942'),
  ('NZ','3293','Waitetuna','-37.8177','175.0743'),
  ('NZ','3295','Te Uku','-37.8321','174.9795'),
  ('NZ','3296','Ruapuke','-37.8766','174.8145'),
  ('NZ','3297','Raglan','-37.8324','174.8054'),
  ('NZ','3300','Morrinsville','-37.6521','175.5293'),
  ('NZ','3310','Waitoa','-37.6','175.6334'),
  ('NZ','3320','Te Aroha','-37.5391','175.7098'),
  ('NZ','3330','Wharewaka','-38.7037','176.0589'),
  ('NZ','3332','Wairakei','-38.6195','176.103'),
  ('NZ','3334','Turangi','-39.0028','175.8069'),
  ('NZ','3340','Morrinsville','-37.6577','175.5275'),
  ('NZ','3341','Waitoa','-37.6015','175.6281'),
  ('NZ','3342','Te Aroha','-37.5429','175.7124'),
  ('NZ','3343','Te Aroha','-37.5523','175.7039'),
  ('NZ','3351','Taupo','-38.6868','176.0718'),
  ('NZ','3352','Taupo','-38.6828','176.0709'),
  ('NZ','3353','Turangi','-38.9887','175.8087'),
  ('NZ','3360','Tarawera','-39.0266','176.5734'),
  ('NZ','3371','Kiwitahi','-37.7378','175.5598'),
  ('NZ','3372','Motumaoho','-37.6875','175.4797'),
  ('NZ','3373','Tahuna','-37.4989','175.4546'),
  ('NZ','3374','Te Puninga','-37.5777','175.5857'),
  ('NZ','3375','Morrinsville','-37.602','175.445'),
  ('NZ','3377','Oruanui','-38.6226','176.0015'),
  ('NZ','3378','Waipahihi','-38.7041','176.1355'),
  ('NZ','3379','Rangitaiki','-38.887','176.3747'),
  ('NZ','3380','Waitoa','-37.5909','175.6224'),
  ('NZ','3381','Kuratau','-38.8184','175.7096'),
  ('NZ','3382','Turangi','-39.0284','175.9471'),
  ('NZ','3391','Manawaru','-37.6407','175.7962'),
  ('NZ','3392','Mangaiti','-37.5085','175.6909'),
  ('NZ','3393','Mangaiti','-37.4947','175.6061'),
  ('NZ','3400','Matamata','-37.8152','175.7832'),
  ('NZ','3401','Waharoa','-37.759','175.7491'),
  ('NZ','3410','Tirau','-37.9879','175.7524'),
  ('NZ','3411','Putaruru','-38.0505','175.7793'),
  ('NZ','3415','Arapuni','-38.0715','175.6498'),
  ('NZ','3420','Tokoroa','-38.2229','175.8685'),
  ('NZ','3421','Mangakino','-38.3696','175.7737'),
  ('NZ','3432','Leamington','-37.9096','175.4781'),
  ('NZ','3434','Leamington','-37.8867','175.469'),
  ('NZ','3440','Matamata','-37.8111','175.7725'),
  ('NZ','3441','Waharoa','-37.7591','175.7525'),
  ('NZ','3442','Tirau','-37.9781','175.7568'),
  ('NZ','3443','Putaruru','-38.0516','175.7788'),
  ('NZ','3444','Tokoroa','-38.2176','175.8717'),
  ('NZ','3445','Mangakino','-38.3704','175.774'),
  ('NZ','3450','Leamington','-37.895','175.4719'),
  ('NZ','3451','Hautapu','-37.8605','175.4531'),
  ('NZ','3471','Okauia','-37.7686','175.8421'),
  ('NZ','3472','Hinuera','-37.8526','175.6993'),
  ('NZ','3473','Kaimai','-37.8507','175.8962'),
  ('NZ','3474','Waharoa','-37.7272','175.7515'),
  ('NZ','3475','Walton','-37.7656','175.6599'),
  ('NZ','3481','Te Waotu','-38.1162','175.6938'),
  ('NZ','3482','Ngatira','-38.1275','175.8195'),
  ('NZ','3483','Putaruru','-38.0474','175.8289'),
  ('NZ','3484','Tirau','-37.9592','175.7208'),
  ('NZ','3485','Okoroire','-37.9758','175.8676'),
  ('NZ','3491','Kinleith','-38.2644','175.9126'),
  ('NZ','3492','Mangakino','-38.5067','175.696'),
  ('NZ','3493','Bruntwood','-37.8344','175.4448'),
  ('NZ','3494','Pukeatua','-37.9944','175.5804'),
  ('NZ','3495','Leamington','-37.9615','175.4494'),
  ('NZ','3496','Whitehall','-37.8541','175.5666'),
  ('NZ','3500','Thames','-37.1355','175.5456'),
  ('NZ','3503','Ngatea','-37.2735','175.4893'),
  ('NZ','3506','Whangapoua','-36.6993','175.6601'),
  ('NZ','3508','Tairua','-36.9977','175.848'),
  ('NZ','3510','Whitianga','-36.817','175.6913'),
  ('NZ','3540','Thames','-37.139','175.542'),
  ('NZ','3541','Ngatea','-37.2763','175.4971'),
  ('NZ','3542','Whitianga','-36.8358','175.7045'),
  ('NZ','3543','Coromandel','-36.7586','175.4984'),
  ('NZ','3544','Tairua','-37.002','175.8482'),
  ('NZ','3545','Turua','-37.2378','175.5664'),
  ('NZ','3546','Pauanui','-37.0206','175.8587'),
  ('NZ','3547','Colville','-36.6345','175.4767'),
  ('NZ','3574','Turua','-37.2269','175.5535'),
  ('NZ','3575','Tapu','-36.9856','175.4922'),
  ('NZ','3576','Waitakaruru','-37.2732','175.3863'),
  ('NZ','3577','Parawai','-37.131','175.6008'),
  ('NZ','3578','Nevesville','-37.1959','175.6659'),
  ('NZ','3579','Hikuai','-37.0865','175.8125'),
  ('NZ','3581','Ahimia','-36.8134','175.4844'),
  ('NZ','3582','Te Rerenga','-36.7533','175.6141'),
  ('NZ','3583','Kennedys Bay','-36.6805','175.5537'),
  ('NZ','3584','Colville','-36.6061','175.4532'),
  ('NZ','3591','Coroglen','-36.8959','175.7144'),
  ('NZ','3592','Coroglen','-36.9317','175.6572'),
  ('NZ','3597','Ngatea','-37.2926','175.4673'),
  ('NZ','3600','Paeroa','-37.3735','175.6712'),
  ('NZ','3610','Waihi','-37.3865','175.8446'),
  ('NZ','3611','Waihi Beach','-37.4039','175.9432'),
  ('NZ','3620','Whangamata','-37.1974','175.869'),
  ('NZ','3640','Paeroa','-37.381','175.671'),
  ('NZ','3641','Waihi','-37.3923','175.8413'),
  ('NZ','3642','Waihi Beach','-37.4117','175.9424'),
  ('NZ','3643','Whangamata','-37.2071','175.8715'),
  ('NZ','3671','Netherton','-37.3374','175.585'),
  ('NZ','3672','Netherton','-37.3715','175.6157'),
  ('NZ','3673','Tirohia','-37.4191','175.6648'),
  ('NZ','3674','Komata','-37.3376','175.7408'),
  ('NZ','3681','Waihi','-37.3714','175.8798'),
  ('NZ','3682','Waihi','-37.4057','175.8178'),
  ('NZ','3691','Whangamata','-37.1833','175.8231'),
  ('NZ','3700','Starrtown','-37.5596','175.1583'),
  ('NZ','3710','Te Kauwhata','-37.4039','175.1466'),
  ('NZ','3720','Ngaruawahia','-37.6691','175.1522'),
  ('NZ','3721','Taupiri','-37.6191','175.1894'),
  ('NZ','3740','Starrtown','-37.558','175.1589'),
  ('NZ','3741','Te Kauwhata','-37.4039','175.144'),
  ('NZ','3742','Ngaruawahia','-37.6659','175.1482'),
  ('NZ','3771','Pukekapia','-37.5358','175.1096'),
  ('NZ','3772','Ruawaro','-37.5172','175.0108'),
  ('NZ','3781','Waerenga','-37.3573','175.2623'),
  ('NZ','3782','Whangamarino','-37.3589','175.1326'),
  ('NZ','3784','Waiterimu','-37.4617','175.2925'),
  ('NZ','3791','Komakorau','-37.6355','175.2398'),
  ('NZ','3792','Orini','-37.5777','175.2696'),
  ('NZ','3793','Waingaro','-37.7088','174.9803'),
  ('NZ','3794','Pepepe','-37.6266','174.9202'),
  ('NZ','3800','Te Awamutu','-38.0195','175.3305'),
  ('NZ','3802','Pirongia','-37.9915','175.2051'),
  ('NZ','3803','Ohaupo','-37.9178','175.3066'),
  ('NZ','3840','Te Awamutu','-38.0104','175.3237'),
  ('NZ','3841','Kihikihi','-38.0377','175.3453'),
  ('NZ','3843','Kawhia','-38.0639','174.8229'),
  ('NZ','3872','Wharepuhunga','-38.0733','175.4515'),
  ('NZ','3873','Te Kawa','-38.138','175.3535'),
  ('NZ','3874','Matapara','-38.2716','175.5108'),
  ('NZ','3875','Te Mawhai','-38.0405','175.29'),
  ('NZ','3876','Pirongia','-38.0036','175.1763'),
  ('NZ','3877','Matapara','-38.1874','175.538'),
  ('NZ','3878','Hauturu','-38.0811','174.9754'),
  ('NZ','3879','Kihikihi','-38.0134','175.4174'),
  ('NZ','3880','Pukeatua','-38.1016','175.5796'),
  ('NZ','3881','Ohaupo','-37.9081','175.3486'),
  ('NZ','3882','Rukuhia','-37.8832','175.2463'),
  ('NZ','3883','Ngaroto','-37.9539','175.2811'),
  ('NZ','3885','Oparau','-38.0142','174.9774'),
  ('NZ','3886','Owhiro','-38.153','174.9098'),
  ('NZ','3889','Kawhia','-38.0416','174.8313'),
  ('NZ','3894','Te Papatapu','-37.9577','174.8386'),
  ('NZ','3895','Moerangi','-37.9508','174.9124'),
  ('NZ','3900','Otorohanga','-38.1807','175.223'),
  ('NZ','3910','Te Kuiti','-38.3353','175.1654'),
  ('NZ','3912','Piopio','-38.4671','175.0126'),
  ('NZ','3920','Taumarunui','-38.8765','175.2729'),
  ('NZ','3924','Manunui','-38.8965','175.3202'),
  ('NZ','3926','Ohura','-38.8467','174.9669'),
  ('NZ','3940','Otorohanga','-38.1864','175.2115'),
  ('NZ','3941','Te Kuiti','-38.3344','175.1656'),
  ('NZ','3942','Piopio','-38.4665','175.016'),
  ('NZ','3943','Hangatiki','-38.2521','175.1787'),
  ('NZ','3944','Benneydale','-38.5204','175.3638'),
  ('NZ','3945','Mahoenui','-38.5784','174.8403'),
  ('NZ','3946','Taumarunui','-38.8844','175.2639'),
  ('NZ','3947','Ohura','-38.8418','174.9827'),
  ('NZ','3948','National Park','-39.1771','175.4022'),
  ('NZ','3949','Tongariro','-39.046','175.6038'),
  ('NZ','3970','Wairere Falls','-38.5064','174.971'),
  ('NZ','3971','Waitanguru','-38.4019','174.9066'),
  ('NZ','3972','Maihiihi','-38.2227','175.3551'),
  ('NZ','3973','Honikiwi','-38.1305','175.1012'),
  ('NZ','3974','Te Kawa','-38.1444','175.2717'),
  ('NZ','3975','Maihiihi','-38.2977','175.3483'),
  ('NZ','3976','Hangatiki','-38.2537','175.2194'),
  ('NZ','3977','Hangatiki','-38.2342','175.1494'),
  ('NZ','3978','Mahoenui','-38.5532','174.8526'),
  ('NZ','3979','Waitewhenua','-38.6529','174.9724'),
  ('NZ','3980','Tatu','-38.8981','174.9306'),
  ('NZ','3981','Arapae','-38.4221','175.1026'),
  ('NZ','3982','Puketutu','-38.3575','175.2779'),
  ('NZ','3983','Kopaki','-38.4905','175.2096'),
  ('NZ','3985','Waitanguru','-38.4444','174.9009'),
  ('NZ','3986','Te Kuiti','-38.2923','175.1961'),
  ('NZ','3987','Benneydale','-38.4993','175.512'),
  ('NZ','3988','Owhiro','-38.2017','174.8979'),
  ('NZ','3989','Oio','-39.0775','175.4805'),
  ('NZ','3990','Upper Ruatiti','-39.1517','175.2283'),
  ('NZ','3991','Aukopae','-38.9138','175.1103'),
  ('NZ','3992','Hikumutu','-38.9432','175.2684'),
  ('NZ','3993','Kirikau','-39.0204','175.1751'),
  ('NZ','3994','Ngapuke','-38.8637','175.4107'),
  ('NZ','3995','Matiere','-38.7469','175.0987'),
  ('NZ','3996','Okahukura','-38.8026','175.2329'),
  ('NZ','3997','Ongarue','-38.7362','175.3731'),
  ('NZ','3998','Waimiha','-38.6202','175.3978'),
  ('NZ','4010','Kaiti','-38.6673','178.0286'),
  ('NZ','4022','Te Karaka','-38.4678','177.866'),
  ('NZ','4032','Ruatoria','-37.8926','178.32'),
  ('NZ','4040','Kaiti','-38.6641','178.025'),
  ('NZ','4041','Tamarau','-38.6751','178.0449'),
  ('NZ','4042','Te Karaka','-38.4695','177.8638'),
  ('NZ','4043','Ruatoria','-37.8902','178.3191'),
  ('NZ','4044','Tiniroto','-38.7742','177.5665'),
  ('NZ','4045','Patutahi','-38.624','177.8904'),
  ('NZ','4046','Tolaga Bay','-38.3727','178.2971'),
  ('NZ','4047','Tokomaru','-38.1303','178.315'),
  ('NZ','4048','Te Puia','-38.0558','178.3065'),
  ('NZ','4049','Rangitukia','-37.7963','178.4107'),
  ('NZ','4050','Te Araroa','-37.6336','178.3693'),
  ('NZ','4051','Matawai','-38.3576','177.5345'),
  ('NZ','4052','Motu','-38.2569','177.5479'),
  ('NZ','4071','Waerengaahika','-38.576','177.9556'),
  ('NZ','4072','Pehiri','-38.66','177.623'),
  ('NZ','4073','Whangara','-38.5389','178.1478'),
  ('NZ','4075','Rakauroa','-38.426','177.4494'),
  ('NZ','4077','Tolaga Bay','-38.2809','178.1521'),
  ('NZ','4078','Tiniroto','-38.8266','177.6647'),
  ('NZ','4079','Tokomaru','-38.1207','178.1236'),
  ('NZ','4081','Waitakaro','-37.9512','178.2583'),
  ('NZ','4082','Ruatoria','-37.8629','178.3902'),
  ('NZ','4083','Pakihiroa','-37.8432','178.165'),
  ('NZ','4086','Whakaangiangi','-37.7749','178.355'),
  ('NZ','4087','Te Araroa','-37.6653','178.3229'),
  ('NZ','4091','Ahititi','-38.365','177.9638'),
  ('NZ','4092','Otoko','-38.3389','177.6316'),
  ('NZ','4093','Te Karaka','-38.4817','177.8868'),
  ('NZ','4094','Whatatutu','-38.3066','177.8005'),
  ('NZ','4102','Haumoana','-39.613','176.9451'),
  ('NZ','4104','Petane','-39.4185','176.8765'),
  ('NZ','4108','North Clyde','-39.0278','177.4054'),
  ('NZ','4110','Onekawa','-39.498','176.8799'),
  ('NZ','4112','Puk-kura','-39.5268','176.8511'),
  ('NZ','4120','HASTINGS','-39.6279','176.8137'),
  ('NZ','4122','Akina','-39.6462','176.8502'),
  ('NZ','4130','Havelock North','-39.6806','176.8867'),
  ('NZ','4140','Onekawa','-39.4909','176.9182'),
  ('NZ','4141','Taradale','-39.5357','176.8487'),
  ('NZ','4142','Pirimai','-39.5073','176.8821'),
  ('NZ','4143','Napier South','-39.5002','176.9031'),
  ('NZ','4144','Ahuriri','-39.4809','176.8981'),
  ('NZ','4145','Greenmeadows','-39.5264','176.8614'),
  ('NZ','4146','Pirimai','-39.5081','176.8868'),
  ('NZ','4147','Tamatea','-39.5106','176.8696'),
  ('NZ','4148','Clive','-39.5839','176.9148'),
  ('NZ','4149','Petane','-39.419','176.8665'),
  ('NZ','4153','Saint Leonards','-39.6312','176.8314'),
  ('NZ','4154','Flaxmere','-39.6254','176.7866'),
  ('NZ','4155','Parkvale','-39.6284','176.8498'),
  ('NZ','4156','Parkvale','-39.6408','176.8425'),
  ('NZ','4157','Havelock North','-39.6694','176.8783'),
  ('NZ','4158','Parkvale','-39.6397','176.8466'),
  ('NZ','4159','Mayfair','-39.6378','176.8527'),
  ('NZ','4160','Wairoa','-39.0333','177.419'),
  ('NZ','4161','Pahowai','-39.6038','176.8928'),
  ('NZ','4162','Tutira','-39.204','176.8815'),
  ('NZ','4163','Frasertown','-38.9666','177.4102'),
  ('NZ','4164','Tuai','-38.8194','177.1439'),
  ('NZ','4165','Nuhaka','-39.0425','177.7403'),
  ('NZ','4166','Mahia','-39.0869','177.9185'),
  ('NZ','4171','Blackburn','-39.8865','176.292'),
  ('NZ','4172','Te Awanga','-39.6588','176.9405'),
  ('NZ','4174','Te Hauke','-39.7357','176.6463'),
  ('NZ','4175','Flaxmere','-39.6232','176.7618'),
  ('NZ','4178','Poukawa','-39.772','176.7544'),
  ('NZ','4179','Puketitiri','-39.3382','176.3562'),
  ('NZ','4181','Tutira','-39.2293','176.9144'),
  ('NZ','4182','Te Pohue','-39.1869','176.6716'),
  ('NZ','4183','Taradale','-39.5439','176.8176'),
  ('NZ','4184','Puketitiri','-39.3051','176.5916'),
  ('NZ','4186','Patoka','-39.3916','176.631'),
  ('NZ','4188','Kotemaori','-39.0869','177.0019'),
  ('NZ','4189','Kotemaori','-38.9813','176.9956'),
  ('NZ','4191','Raupunga','-38.9823','177.2238'),
  ('NZ','4193','Wairoa','-39.0076','177.343'),
  ('NZ','4195','Tuai','-38.7742','177.2002'),
  ('NZ','4196','Opoiti','-38.9559','177.5408'),
  ('NZ','4197','Raupunga','-39.063','177.2422'),
  ('NZ','4198','Waitaniwha','-39.0721','177.8021'),
  ('NZ','4200','Waipukurau','-39.9973','176.5591'),
  ('NZ','4202','Otane','-39.898','176.6275'),
  ('NZ','4203','Takapau','-40.0222','176.3499'),
  ('NZ','4210','Waipawa','-39.9289','176.5855'),
  ('NZ','4240','Waipawa','-39.9442','176.5868'),
  ('NZ','4241','Otane','-39.8966','176.6287'),
  ('NZ','4242','Waipukurau','-39.9954','176.5563'),
  ('NZ','4243','Takapau','-40.0282','176.3484'),
  ('NZ','4244','Onga Onga','-39.913','176.4185'),
  ('NZ','4245','Porangahau','-40.3024','176.6101'),
  ('NZ','4271','Patangata','-40.0457','176.7528'),
  ('NZ','4272','Ruataniwha','-39.9184','176.5078'),
  ('NZ','4273','Argyll East','-39.8672','176.5055'),
  ('NZ','4274','Tikokino','-39.7683','176.3925'),
  ('NZ','4275','Waipawa','-39.9644','176.5872'),
  ('NZ','4276','Pukehou','-39.8517','176.5974'),
  ('NZ','4277','Patangata','-39.8817','176.7075'),
  ('NZ','4278','Blackburn','-39.8701','176.3054'),
  ('NZ','4279','Blackburn','-39.8275','176.332'),
  ('NZ','4281','Maharakeke','-40.0431','176.4391'),
  ('NZ','4282','Wanstead','-40.1206','176.4449'),
  ('NZ','4283','Ruataniwha','-39.9519','176.4761'),
  ('NZ','4284','Wallingford','-40.1509','176.6552'),
  ('NZ','4285','Waipukurau','-40.007','176.623'),
  ('NZ','4286','Ashley Clinton','-39.9488','176.2699'),
  ('NZ','4287','Norsewood','-40.0526','176.2563'),
  ('NZ','4288','Maharakeke','-39.9737','176.402'),
  ('NZ','4291','Porangahau','-40.3086','176.5164'),
  ('NZ','4292','Porangahau','-40.3623','176.5533'),
  ('NZ','4293','Porangahau','-40.3501','176.6207'),
  ('NZ','4294','Waimarama','-39.7714','176.9602'),
  ('NZ','4295','Elsthorpe','-39.8729','176.8721'),
  ('NZ','4310','Westown','-39.0725','174.0554'),
  ('NZ','4312','Fitzroy','-39.052','174.1191'),
  ('NZ','4314','Oakura','-39.115','173.9504'),
  ('NZ','4320','Waitara','-38.9976','174.2367'),
  ('NZ','4322','Eltham','-39.429','174.2996'),
  ('NZ','4330','Inglewood','-39.157','174.2029'),
  ('NZ','4332','Stratford','-39.3377','174.2802'),
  ('NZ','4335','Okato','-39.1936','173.8777'),
  ('NZ','4340','Brooklands','-39.0586','174.0682'),
  ('NZ','4341','Fitzroy','-39.05','174.1017'),
  ('NZ','4342','New Plymouth','-39.0572','174.0741'),
  ('NZ','4343','Frankleigh Park','-39.0708','174.0628'),
  ('NZ','4344','Moturoa','-39.0628','174.0452'),
  ('NZ','4345','Oakura','-39.1157','173.9574'),
  ('NZ','4346','Waitara','-39.0021','174.2361'),
  ('NZ','4347','Inglewood','-39.1568','174.2072'),
  ('NZ','4348','Okato','-39.191','173.8794'),
  ('NZ','4349','Urenui','-38.9979','174.3907'),
  ('NZ','4350','Mokau','-38.6991','174.621'),
  ('NZ','4351','Bell Block','-39.0355','174.1432'),
  ('NZ','4352','Stratford','-39.3393','174.283'),
  ('NZ','4353','Eltham','-39.4298','174.2994'),
  ('NZ','4360','Merrilands','-39.0666','174.1028'),
  ('NZ','4371','Mangorei','-39.1487','174.0832'),
  ('NZ','4372','Hillsborough','-39.0917','174.1506'),
  ('NZ','4373','Lepperton','-39.0487','174.2197'),
  ('NZ','4374','Oakura','-39.1464','173.9507'),
  ('NZ','4375','Okoki','-39.0529','174.5077'),
  ('NZ','4376','Awakino','-38.6827','174.7513'),
  ('NZ','4377','Uruti','-38.9421','174.4819'),
  ('NZ','4378','Okau','-38.9105','174.6847'),
  ('NZ','4379','Uruti','-38.9415','174.5497'),
  ('NZ','4381','Okato','-39.2227','173.8775'),
  ('NZ','4382','Sentry Hill','-39.0139','174.2171'),
  ('NZ','4383','Tikorangi','-39.0507','174.3067'),
  ('NZ','4386','Kaimiro','-39.2077','174.1435'),
  ('NZ','4387','Tarata','-39.155','174.3796'),
  ('NZ','4388','Te Tawa','-39.179','174.2446'),
  ('NZ','4389','Waiongona','-39.1194','174.2335'),
  ('NZ','4390','Ratapiko','-39.207','174.3078'),
  ('NZ','4391','Dawson Falls','-39.3216','174.1399'),
  ('NZ','4392','Puniwhakau','-39.3023','174.7213'),
  ('NZ','4393','Huinga','-39.3746','174.3671'),
  ('NZ','4394','Tuna','-39.2797','174.2973'),
  ('NZ','4395','Matau','-39.1747','174.6005'),
  ('NZ','4396','Tahora','-39.0277','174.7836'),
  ('NZ','4397','Tahora','-38.973','174.7784'),
  ('NZ','4398','Eltham','-39.4577','174.3421'),
  ('NZ','4399','Moeroa','-39.4309','174.6351'),
  ('NZ','4410','Summerhill','-40.3691','175.6288'),
  ('NZ','4412','Awapuni','-40.3658','175.5885'),
  ('NZ','4414','Kelvin Grove','-40.3326','175.63'),
  ('NZ','4440','Hokowhitu','-40.3581','175.6107'),
  ('NZ','4441','Terrace End','-40.3476','175.6277'),
  ('NZ','4442','Takaro','-40.3454','175.5952'),
  ('NZ','4443','West End','-40.3622','175.5984'),
  ('NZ','4444','Terrace End','-40.3555','175.6123'),
  ('NZ','4445','Awapuni','-40.3726','175.593'),
  ('NZ','4446','Hokowhitu','-40.3632','175.6337'),
  ('NZ','4448','Summerhill','-40.3874','175.6393'),
  ('NZ','4470','Ashhurst','-40.2905','175.7029'),
  ('NZ','4471','Aokautere','-40.3626','175.7135'),
  ('NZ','4473','Carnarvon','-40.3156','175.3397'),
  ('NZ','4474','Tokomaru','-40.5035','175.5456'),
  ('NZ','4475','Kairanga','-40.3307','175.5202'),
  ('NZ','4476','Rongotea','-40.2862','175.4393'),
  ('NZ','4477','Mangawhata','-40.3989','175.4478'),
  ('NZ','4478','Milson','-40.2979','175.5922'),
  ('NZ','4479','Sanson','-40.2317','175.4358'),
  ('NZ','4481','Bunnythorpe','-40.2755','175.6657'),
  ('NZ','4500','Aramoho','-39.9146','175.0547'),
  ('NZ','4501','Gonville','-39.9401','175.0133'),
  ('NZ','4510','Waverley','-39.7628','174.6317'),
  ('NZ','4520','White Tank','-39.7584','174.4695'),
  ('NZ','4540','Wanganui','-39.9344','175.0532'),
  ('NZ','4541','Wanganui','-39.9295','175.0466'),
  ('NZ','4542','Wanganui East','-39.9096','175.0533'),
  ('NZ','4543','Gonville','-39.9428','175.0226'),
  ('NZ','4544','Waverley','-39.7637','174.6343'),
  ('NZ','4545','White Tank','-39.756','174.4737'),
  ('NZ','4547','Turakina South','-40.0467','175.2138'),
  ('NZ','4548','Ratana','-40.0394','175.1756'),
  ('NZ','4549','Waitotara','-39.8069','174.734'),
  ('NZ','4571','Brunswick','-39.8193','175.0205'),
  ('NZ','4572','Wiritoa','-39.9823','175.1163'),
  ('NZ','4573','Kakatahi','-39.674','175.2513'),
  ('NZ','4574','Mowhanau','-39.8531','174.8924'),
  ('NZ','4575','Upokonui','-39.7918','175.1865'),
  ('NZ','4576','Matahiwi','-39.6251','175.1175'),
  ('NZ','4577','Kauangaroa','-39.8951','175.3413'),
  ('NZ','4578','Ahuiti','-39.6577','175.0021'),
  ('NZ','4581','Turakina','-40.0084','175.2327'),
  ('NZ','4582','Okoia','-39.9118','175.1679'),
  ('NZ','4584','Whakaihuwaka','-39.7719','175.0626'),
  ('NZ','4585','Kakatahi','-39.599','175.4148'),
  ('NZ','4586','Kakatahi','-39.7307','175.4134'),
  ('NZ','4587','Nukumaru','-39.8064','174.8084'),
  ('NZ','4588','Tawhiwhi','-39.6228','174.8503'),
  ('NZ','4591','Nukuhau','-39.6418','174.6316'),
  ('NZ','4592','Mangawhio','-39.7201','174.7245'),
  ('NZ','4597','Matukuroa','-39.7038','174.5409'),
  ('NZ','4598','Hurleyville','-39.6331','174.4858'),
  ('NZ','4610','Hawera','-39.5854','174.2825'),
  ('NZ','4612','Manaia','-39.5512','174.1251'),
  ('NZ','4614','Normanby','-39.5417','174.2726'),
  ('NZ','4616','Opunake','-39.4523','173.8572'),
  ('NZ','4625','Ohakune','-39.4103','175.4031'),
  ('NZ','4632','Raetihi','-39.4286','175.2878'),
  ('NZ','4640','Hawera','-39.59','174.2837'),
  ('NZ','4641','Manaia','-39.5515','174.125'),
  ('NZ','4642','Kaponga','-39.4293','174.1506'),
  ('NZ','4645','Opunake','-39.4539','173.8585'),
  ('NZ','4646','Raetihi','-39.4259','175.2765'),
  ('NZ','4660','Ohakune','-39.4176','175.3987'),
  ('NZ','4671','Okaiawa','-39.5534','174.1949'),
  ('NZ','4672','Meremere','-39.5673','174.3894'),
  ('NZ','4673','Te Roti','-39.4856','174.2924'),
  ('NZ','4674','Ararata','-39.528','174.3533'),
  ('NZ','4675','Matapu','-39.5065','174.2201'),
  ('NZ','4678','Kaupokonui','-39.5139','174.079'),
  ('NZ','4679','Riverlea','-39.4256','174.0879'),
  ('NZ','4681','Oaonui','-39.3861','173.8804'),
  ('NZ','4682','Waiteika','-39.4564','173.9364'),
  ('NZ','4684','Upper Kahui','-39.3292','173.8783'),
  ('NZ','4685','Parihaka Pa','-39.2895','173.825'),
  ('NZ','4691','Rangataua','-39.3296','175.5523'),
  ('NZ','4694','Raetihi','-39.477','175.1922'),
  ('NZ','4696','Te Ranga','-39.2854','175.1762'),
  ('NZ','4702','FEILDING','-40.2171','175.5663'),
  ('NZ','4710','Marton','-40.0724','175.3798'),
  ('NZ','4720','Taihape','-39.6828','175.7899'),
  ('NZ','4730','Hunterville','-39.9337','175.5688'),
  ('NZ','4740','FEILDING','-40.2267','175.5654'),
  ('NZ','4741','Marton','-40.0668','175.3787'),
  ('NZ','4742','Taihape','-39.6773','175.7982'),
  ('NZ','4744','Kimbolton','-40.0574','175.7794'),
  ('NZ','4745','Hunterville','-39.9371','175.5685'),
  ('NZ','4746','Mangaweka','-39.8096','175.7887'),
  ('NZ','4771','Umutoi','-39.9989','175.9452'),
  ('NZ','4774','Apiti','-39.9336','175.8575'),
  ('NZ','4775','Colyton','-40.213','175.6339'),
  ('NZ','4777','Kiwitea','-40.0927','175.7361'),
  ('NZ','4779','Waituna West','-40.0865','175.5853'),
  ('NZ','4780','Rewa','-39.9915','175.6315'),
  ('NZ','4781','Silverhope','-39.9089','175.4387'),
  ('NZ','4782','Pukeroa','-39.8123','175.5464'),
  ('NZ','4783','Pakihikura','-39.9228','175.7'),
  ('NZ','4784','Silverhope','-39.9478','175.5212'),
  ('NZ','4785','Poukiore','-39.8467','175.6335'),
  ('NZ','4786','Rewa','-39.956','175.6052'),
  ('NZ','4787','Cliff Road','-40.0513','175.4852'),
  ('NZ','4788','Marton','-40.0079','175.3642'),
  ('NZ','4789','Marton','-40.0996','175.3098'),
  ('NZ','4791','Raketapauma','-39.6042','175.5897'),
  ('NZ','4792','Erehwon','-39.5457','175.9477'),
  ('NZ','4793','Ohotu','-39.6785','175.9334'),
  ('NZ','4794','Utiku','-39.7557','175.8942'),
  ('NZ','4795','Waiouru Military Camp','-39.471','175.8029'),
  ('NZ','4796','Taihape','-39.7189','175.7107'),
  ('NZ','4797','Ruahine','-39.8068','175.8736'),
  ('NZ','4810','Ashhurst','-40.2927','175.7565'),
  ('NZ','4814','Foxton','-40.4708','175.2874'),
  ('NZ','4815','Foxton Beach','-40.464','175.2318'),
  ('NZ','4816','Ohakea','-40.2026','175.3808'),
  ('NZ','4817','Sanson','-40.2188','175.4228'),
  ('NZ','4818','Bulls','-40.1775','175.3863'),
  ('NZ','4820','Longburn','-40.4054','175.5855'),
  ('NZ','4821','Shannon','-40.5425','175.4181'),
  ('NZ','4822','Tangimoana','-40.2929','175.2564'),
  ('NZ','4825','Waiouru Military Camp','-39.4009','175.6798'),
  ('NZ','4826','Waiouru Military Camp','-39.4712','175.6851'),
  ('NZ','4847','Ashhurst','-40.2903','175.7552'),
  ('NZ','4848','Foxton','-40.4749','175.2812'),
  ('NZ','4849','Foxton Beach','-40.4683','175.2382'),
  ('NZ','4860','Shannon','-40.5496','175.4138'),
  ('NZ','4861','Waiouru','-39.4759','175.6686'),
  ('NZ','4862','Sanson','-40.2198','175.4241'),
  ('NZ','4863','Bulls','-40.174','175.3864'),
  ('NZ','4864','Tokomaru','-40.4745','175.5097'),
  ('NZ','4865','Rongotea','-40.293','175.4249'),
  ('NZ','4866','Longburn','-40.383','175.5453'),
  ('NZ','4867','Bunnythorpe','-40.2825','175.6311'),
  ('NZ','4884','Pohangina','-40.1382','175.8664'),
  ('NZ','4891','Himatangi','-40.3928','175.2974'),
  ('NZ','4893','Marotiri','-40.485','175.3291'),
  ('NZ','4894','Bulls','-40.1941','175.293'),
  ('NZ','4900','Eketahuna','-40.6497','175.7023'),
  ('NZ','4910','Pahiatua','-40.4549','175.8395'),
  ('NZ','4920','Woodville','-40.3337','175.8663'),
  ('NZ','4930','Dannevirke','-40.209','176.1022'),
  ('NZ','4940','Eketahuna','-40.6454','175.7031'),
  ('NZ','4941','Pahiatua','-40.4521','175.8422'),
  ('NZ','4942','Dannevirke','-40.2098','176.0966'),
  ('NZ','4943','Norsewood','-40.0694','176.2163'),
  ('NZ','4944','Pongaroa','-40.5426','176.1906'),
  ('NZ','4945','Woodville','-40.3378','175.8689'),
  ('NZ','4970','Ti-tree Point','-40.3934','176.4123'),
  ('NZ','4971','Waipatiki','-40.355','176.1816'),
  ('NZ','4972','Kiritaki','-40.2398','176.006'),
  ('NZ','4973','Waipatiki','-40.2554','176.2901'),
  ('NZ','4974','Ngamoko','-40.0491','176.1951'),
  ('NZ','4975','Tahoraiti','-40.3019','176.0999'),
  ('NZ','4976','Raumati','-40.1995','176.1673'),
  ('NZ','4977','Makotuku','-40.124','176.2232'),
  ('NZ','4978','Piripiri','-40.1409','176.0556'),
  ('NZ','4979','Waione','-40.4364','176.301'),
  ('NZ','4981','Kaitawa','-40.5303','175.8807'),
  ('NZ','4982','Ngaturi','-40.4288','175.9762'),
  ('NZ','4983','Ballance','-40.3984','175.767'),
  ('NZ','4984','Konini','-40.5081','175.7673'),
  ('NZ','4985','Makuri','-40.4982','176.0472'),
  ('NZ','4986','Haunui','-40.5926','175.958'),
  ('NZ','4987','Konini','-40.5221','175.7835'),
  ('NZ','4988','Mangamaire','-40.5086','175.6967'),
  ('NZ','4989','Makuri','-40.5302','176.0492'),
  ('NZ','4990','Waimiro','-40.4787','176.1541'),
  ('NZ','4991','Aohanga','-40.6126','176.3283'),
  ('NZ','4992','Waione','-40.5133','176.2536'),
  ('NZ','4993','Tane','-40.5785','175.791'),
  ('NZ','4994','Eketahuna','-40.6634','175.6726'),
  ('NZ','4995','Nireaha','-40.5863','175.6436'),
  ('NZ','4996','Tiraumea','-40.6679','175.9936'),
  ('NZ','4997','Hopelands','-40.3625','175.9945'),
  ('NZ','4998','Papatawa','-40.2855','175.9108'),
  ('NZ','4999','Woodville','-40.3205','175.834'),
  ('NZ','5010','Avalon','-41.1971','174.9198'),
  ('NZ','5011','Taita','-41.1943','174.9522'),
  ('NZ','5012','Petone','-41.2338','174.8757'),
  ('NZ','5013','Muritai','-41.3154','174.8854'),
  ('NZ','5014','Wainuiomata','-41.2634','174.9483'),
  ('NZ','5016','Korokoro','-41.2128','174.8499'),
  ('NZ','5018','Maoribank','-41.1195','175.0935'),
  ('NZ','5019','Pinehaven','-41.1703','174.9949'),
  ('NZ','5022','Elsdon','-41.1245','174.8198'),
  ('NZ','5024','Waitangirua','-41.1303','174.8787'),
  ('NZ','5026','Karehana Bay','-41.0629','174.8705'),
  ('NZ','5028','Grenada North','-41.175','174.8503'),
  ('NZ','5032','Paraparaumu Beach','-40.8948','174.9695'),
  ('NZ','5034','Paekakariki','-40.9769','174.9682'),
  ('NZ','5036','Waikanae','-40.8733','175.0507'),
  ('NZ','5040','Alicetown','-41.2095','174.9015'),
  ('NZ','5041','Taita','-41.1986','174.9476'),
  ('NZ','5042','Lower Hutt','-41.2148','174.922'),
  ('NZ','5043','Gracefield','-41.2271','174.9053'),
  ('NZ','5044','Naenae','-41.1988','174.9358'),
  ('NZ','5045','Petone','-41.2253','174.8662'),
  ('NZ','5046','Petone','-41.2255','174.8795'),
  ('NZ','5047','Eastbourne','-41.2906','174.8985'),
  ('NZ','5048','Wainuiomata','-41.2608','174.9457'),
  ('NZ','5049','Homedale','-41.2725','174.9546'),
  ('NZ','5050','Maungaraki','-41.209','174.8783'),
  ('NZ','5140','Kingsley Heights','-41.124','175.0737'),
  ('NZ','5141','Stokes Valley','-41.1745','174.9816'),
  ('NZ','5142','Silverstream','-41.148','175.012'),
  ('NZ','5143','Trentham','-41.138','175.0342'),
  ('NZ','5240','Ranui Heights','-41.1349','174.8403'),
  ('NZ','5242','Onepoto','-41.1086','174.838'),
  ('NZ','5243','Cannons Creek','-41.1416','174.8654'),
  ('NZ','5245','Whitby','-41.1178','174.8933'),
  ('NZ','5247','Paremata','-41.0933','174.8686'),
  ('NZ','5249','Linden','-41.1703','174.8247'),
  ('NZ','5250','Waikanae','-40.8767','175.0642'),
  ('NZ','5252','Paraparaumu Beach','-40.8939','174.9811'),
  ('NZ','5254','Paraparaumu','-40.9165','175.0055'),
  ('NZ','5255','Raumati Beach','-40.9189','174.9822'),
  ('NZ','5258','Paekakariki','-40.9884','174.9515'),
  ('NZ','5371','Upper Hutt','-41.1669','175.088'),
  ('NZ','5372','Kaitoke','-41.0519','175.1665'),
  ('NZ','5373','Homedale','-41.277','175.0608'),
  ('NZ','5381','Pukerua Bay','-41.0521','174.9695'),
  ('NZ','5391','Reikorangi','-40.9005','175.1072'),
  ('NZ','5510','Levin','-40.5963','175.2511'),
  ('NZ','5512','Otaki','-40.7402','175.1404'),
  ('NZ','5540','Levin','-40.6222','175.2866'),
  ('NZ','5541','Manakau','-40.7124','175.2168'),
  ('NZ','5542','Otaki','-40.7526','175.1389'),
  ('NZ','5543','Otaki','-40.7621','175.156'),
  ('NZ','5544','Te Horo','-40.804','175.1192'),
  ('NZ','5570','Ohau','-40.6766','175.2619'),
  ('NZ','5571','Levin','-40.621','175.3004'),
  ('NZ','5572','Waitarere','-40.5336','175.2628'),
  ('NZ','5573','Manakau','-40.7073','175.2017'),
  ('NZ','5574','Waitarere','-40.5584','175.2388'),
  ('NZ','5575','Koputaroa','-40.5666','175.3219'),
  ('NZ','5581','Manakau','-40.7911','175.3732'),
  ('NZ','5710','Featherston','-41.1169','175.2937'),
  ('NZ','5711','Martinborough','-41.2205','175.4593'),
  ('NZ','5712','Greytown','-41.0824','175.4599'),
  ('NZ','5713','Carterton','-41.0281','175.5229'),
  ('NZ','5740','Featherston','-41.117','175.3248'),
  ('NZ','5741','Martinborough','-41.2191','175.4583'),
  ('NZ','5742','Greytown','-41.0802','175.4603'),
  ('NZ','5743','Carterton','-41.0251','175.5276'),
  ('NZ','5771','Kahutara','-41.1711','175.3549'),
  ('NZ','5772','Pirinoa','-41.4073','175.2716'),
  ('NZ','5773','Cross Creek','-41.2346','175.2043'),
  ('NZ','5781','Pahautea','-41.3133','175.3866'),
  ('NZ','5782','Waipawa','-41.4322','175.5092'),
  ('NZ','5783','Martinborough','-41.1867','175.432'),
  ('NZ','5784','Hinakura','-41.3109','175.6286'),
  ('NZ','5791','Carterton','-40.9663','175.5024'),
  ('NZ','5792','Parkvale','-41.1168','175.5423'),
  ('NZ','5794','Greytown','-41.1065','175.4291'),
  ('NZ','5810','Masterton','-40.9516','175.6535'),
  ('NZ','5840','Masterton','-40.9497','175.6614'),
  ('NZ','5842','Masterton','-40.9581','175.6487'),
  ('NZ','5871','Bideford','-40.8459','175.8391'),
  ('NZ','5872','Riversdale Beach','-41.0602','176.0402'),
  ('NZ','5881','Kopuaranga','-40.8215','175.5948'),
  ('NZ','5882','Mauriceville','-40.7872','175.7584'),
  ('NZ','5883','Homewood','-41.215','175.8129'),
  ('NZ','5884','Gladstone','-41.116','175.6531'),
  ('NZ','5885','Masterton','-40.983','175.6525'),
  ('NZ','5886','Upper Tauheru','-40.8768','175.7476'),
  ('NZ','5887','Clareville','-41.0162','175.6125'),
  ('NZ','5888','Solway','-40.9051','175.5684'),
  ('NZ','5889','Tinui','-40.8671','176.0156'),
  ('NZ','5890','Tauweru','-41.0722','175.8675'),
  ('NZ','5894','Tinui','-40.7768','176.0837'),
  ('NZ','6011','Mount Victoria','-41.2829','174.7842'),
  ('NZ','6012','Karori','-41.2869','174.7405'),
  ('NZ','6021','Wellington','-41.3053','174.779'),
  ('NZ','6022','Miramar','-41.3155','174.8166'),
  ('NZ','6023','Owhiro Bay','-41.3375','174.7506'),
  ('NZ','6035','Khandallah','-41.2466','174.7942'),
  ('NZ','6037','Ohariu','-41.1951','174.7805'),
  ('NZ','6140','Mount Victoria','-41.2809','174.7794'),
  ('NZ','6141','Mount Victoria','-41.2942','174.7763'),
  ('NZ','6142','Mount Victoria','-41.2902','174.7757'),
  ('NZ','6143','Kelburn','-41.2825','174.775'),
  ('NZ','6144','Kaiwharawhara','-41.2759','174.778'),
  ('NZ','6145','Kelburn','-41.2798','174.7761'),
  ('NZ','6146','Mount Victoria','-41.2838','174.7763'),
  ('NZ','6147','Karori','-41.2851','174.7368'),
  ('NZ','6148','Mount Victoria','-41.2842','174.7752'),
  ('NZ','6149','Wellington','-41.2942','174.7831'),
  ('NZ','6150','Kelburn','-41.289','174.7618'),
  ('NZ','6160','Kelburn','-41.2776','174.7775'),
  ('NZ','6241','Rongotai','-41.3194','174.7943'),
  ('NZ','6242','Berhampore','-41.3133','174.7795'),
  ('NZ','6243','Miramar','-41.316','174.8159'),
  ('NZ','6244','Strathmore Park','-41.3331','174.8103'),
  ('NZ','6440','Newlands','-41.223','174.807'),
  ('NZ','6441','Ngaio','-41.2464','174.7909'),
  ('NZ','6442','Newlands','-41.2227','174.8229'),
  ('NZ','6443','Ngaio','-41.2512','174.7731'),
  ('NZ','6972','Karori West','-41.2839','174.6811'),
  ('NZ','7005','Mapua','-41.2456','173.0951'),
  ('NZ','7007','Murchison','-41.8066','172.3292'),
  ('NZ','7010','Nelson East','-41.2881','173.3357'),
  ('NZ','7011','Stoke','-41.3097','173.2432'),
  ('NZ','7020','Richmond','-41.3437','173.185'),
  ('NZ','7022','Brightwater','-41.3743','173.1066'),
  ('NZ','7025','Wakefield','-41.406','173.0398'),
  ('NZ','7040','Nelson East','-41.271','173.2837'),
  ('NZ','7041','Stoke','-41.3146','173.2328'),
  ('NZ','7042','Nelson South','-41.2744','173.2766'),
  ('NZ','7043','Port Nelson','-41.265','173.2774'),
  ('NZ','7044','Wakatu','-41.301','173.2426'),
  ('NZ','7045','Nelson','-41.2833','173.2772'),
  ('NZ','7046','Nelson South','-41.281','173.2699'),
  ('NZ','7047','Nelson East','-41.269','173.2944'),
  ('NZ','7048','Mapua','-41.2532','173.0958'),
  ('NZ','7049','Murchison','-41.8003','172.3257'),
  ('NZ','7050','Richmond','-41.3385','173.1848'),
  ('NZ','7051','Brightwater','-41.3765','173.1101'),
  ('NZ','7052','Wakefield','-41.4062','173.0428'),
  ('NZ','7053','Saint Arnaud','-41.8025','172.8462'),
  ('NZ','7054','Collingwood','-40.6764','172.6823'),
  ('NZ','7055','Tapawera','-41.389','172.8237'),
  ('NZ','7071','Hira','-41.1983','173.4167'),
  ('NZ','7072','Lake Rotoroa','-41.8618','172.678'),
  ('NZ','7073','Baton','-41.1442','172.5673'),
  ('NZ','7077','Matakitaki','-41.941','172.433'),
  ('NZ','7081','Richmond','-41.3498','173.1862'),
  ('NZ','7091','Brightwater','-41.4317','173.1111'),
  ('NZ','7095','Hiwipango','-41.5222','172.9527'),
  ('NZ','7096','Motupiko','-41.4449','172.8166'),
  ('NZ','7100','Havelock','-41.2818','173.7574'),
  ('NZ','7110','Takaka','-40.8562','172.8102'),
  ('NZ','7120','Port Motueka','-41.1187','173.0119'),
  ('NZ','7142','Takaka','-40.8595','172.8059'),
  ('NZ','7143','Port Motueka','-41.1127','173.0112'),
  ('NZ','7144','Upper Moutere','-41.2696','173.0061'),
  ('NZ','7145','Rai Valley','-41.228','173.5831'),
  ('NZ','7146','Riwaka','-41.085','172.9971'),
  ('NZ','7150','Havelock','-41.2786','173.767'),
  ('NZ','7173','Mahana','-41.2375','173.0318'),
  ('NZ','7175','Braeburn','-41.2153','172.9868'),
  ('NZ','7178','Havelock','-41.3084','173.7316'),
  ('NZ','7182','Onekaka','-40.7728','172.737'),
  ('NZ','7183','East Takaka','-40.9481','172.8863'),
  ('NZ','7192','Tinline','-41.2755','173.5246'),
  ('NZ','7193','Kapowai','-40.9131','173.8039'),
  ('NZ','7194','Rai Valley','-41.1742','173.6329'),
  ('NZ','7195','Tira-ora','-41.1272','173.8206'),
  ('NZ','7196','Ngatimoti','-41.2123','172.8726'),
  ('NZ','7197','Sandy Bay','-41.0172','172.9848'),
  ('NZ','7198','Kairuru','-41.0303','172.9351'),
  ('NZ','7201','Witherlea','-41.5456','173.9572'),
  ('NZ','7202','Grovetown','-41.4767','173.9649'),
  ('NZ','7204','Renwick','-41.5056','173.8293'),
  ('NZ','7206','Renwick','-41.5149','173.8649'),
  ('NZ','7210','Seddon','-41.6695','174.071'),
  ('NZ','7220','Picton','-41.2933','174.0192'),
  ('NZ','7240','Witherlea','-41.5137','173.9573'),
  ('NZ','7241','Blenheim','-41.5093','173.9353'),
  ('NZ','7242','Witherlea','-41.5301','173.9552'),
  ('NZ','7243','Renwick','-41.5077','173.8276'),
  ('NZ','7244','Spring Creek','-41.4611','173.9618'),
  ('NZ','7246','Tuamarina','-41.4301','173.9632'),
  ('NZ','7247','Seddon','-41.6735','174.0761'),
  ('NZ','7248','Ward','-41.8293','174.1308'),
  ('NZ','7250','Picton','-41.2913','174.007'),
  ('NZ','7251','Waikawa','-41.2669','174.0483'),
  ('NZ','7260','Kekerengu','-42.0033','174.0105'),
  ('NZ','7271','Hillersden','-41.7462','173.4386'),
  ('NZ','7272','Renwick','-41.5682','173.8533'),
  ('NZ','7273','Tuamarina','-41.4053','173.9265'),
  ('NZ','7274','Upcot','-41.9176','173.5384'),
  ('NZ','7275','Te Rou','-41.467','173.3531'),
  ('NZ','7276','Avondale','-41.7268','173.5091'),
  ('NZ','7281','Waikawa','-41.2286','174.0824'),
  ('NZ','7282','Manaroa','-41.1392','174.0599'),
  ('NZ','7284','Whakatahuri','-41.0251','174.083'),
  ('NZ','7285','Taimate','-41.7703','174.0725'),
  ('NZ','7300','Waioruarangi','-42.4066','173.6889'),
  ('NZ','7310','Cheviot','-42.8133','173.2755'),
  ('NZ','7332','Waiau','-42.6533','173.0461'),
  ('NZ','7334','Hanmer Springs','-42.5167','172.8221'),
  ('NZ','7340','Kaikoura Suburban','-42.3891','173.6637'),
  ('NZ','7341','Cheviot','-42.8123','173.2738'),
  ('NZ','7343','Waiau','-42.6555','173.0396'),
  ('NZ','7345','Culverden','-42.7747','172.8473'),
  ('NZ','7348','Hawarden','-42.9236','172.6428'),
  ('NZ','7360','Hanmer Springs','-42.5213','172.8294'),
  ('NZ','7371','Langridge','-42.1653','173.5325'),
  ('NZ','7373','Charwell Forks','-42.4375','173.3735'),
  ('NZ','7374','Goose Bay','-42.4831','173.5086'),
  ('NZ','7379','Waiau','-42.6926','173.0303'),
  ('NZ','7381','Spotswood','-42.7774','173.2883'),
  ('NZ','7382','Ethelton','-42.7904','173.1121'),
  ('NZ','7383','Domett','-42.885','173.2276'),
  ('NZ','7384','Hawkeswood','-42.6505','173.3387'),
  ('NZ','7385','Masons Flat','-42.7342','172.4233'),
  ('NZ','7387','Tormore','-42.9805','173.0928'),
  ('NZ','7391','Rotherham','-42.76','172.9548'),
  ('NZ','7392','Hanmer Springs','-42.5739','172.5659'),
  ('NZ','7395','Hanmer Springs','-42.4038','172.8612'),
  ('NZ','7400','Bells','-43.3058','172.5992'),
  ('NZ','7402','Waikuku Beach','-43.2838','172.7162'),
  ('NZ','7410','Amberley','-43.1451','172.7382'),
  ('NZ','7420','Waikari','-42.9673','172.692'),
  ('NZ','7430','Oxford','-43.2993','172.1896'),
  ('NZ','7440','Bells','-43.3035','172.5954'),
  ('NZ','7441','Amberley','-43.1546','172.7302'),
  ('NZ','7442','Waikari','-42.9672','172.6851'),
  ('NZ','7443','Oxford','-43.2977','172.194'),
  ('NZ','7444','Cust','-43.3113','172.3793'),
  ('NZ','7445','Sefton','-43.2486','172.6683'),
  ('NZ','7446','Leithfield','-43.2105','172.7539'),
  ('NZ','7447','Waipara','-43.0598','172.7558'),
  ('NZ','7448','Waikuku Beach','-43.2867','172.7164'),
  ('NZ','7471','West Eyreton','-43.356','172.3985'),
  ('NZ','7472','North Loburn','-43.1561','172.5438'),
  ('NZ','7473','Waikuku','-43.2928','172.6558'),
  ('NZ','7474','North Loburn','-43.2203','172.3884'),
  ('NZ','7481','Amberley','-43.1628','172.7248'),
  ('NZ','7482','Waipara','-43.101','172.6438'),
  ('NZ','7483','Omihi','-43.0041','172.8703'),
  ('NZ','7491','Waikari','-42.9729','172.6468'),
  ('NZ','7495','Oxford','-43.2101','172.1779'),
  ('NZ','7500','Sheffield','-43.3895','172.0202'),
  ('NZ','7510','Darfield','-43.4859','172.1154'),
  ('NZ','7520','Akaroa','-43.8126','172.9632'),
  ('NZ','7540','Sheffield','-43.3872','172.0163'),
  ('NZ','7541','Darfield','-43.4898','172.1106'),
  ('NZ','7542','Akaroa','-43.8053','172.9668'),
  ('NZ','7543','Kirwee','-43.5009','172.2168'),
  ('NZ','7544','Hororata','-43.5436','171.9775'),
  ('NZ','7545','Duvauchelle','-43.7503','172.9324'),
  ('NZ','7546','Little River','-43.7703','172.791'),
  ('NZ','7548','Doyleston','-43.748','172.3276'),
  ('NZ','7571','Hawkins','-43.4717','172.0706'),
  ('NZ','7572','Lake Coleridge','-43.2868','171.6069'),
  ('NZ','7580','Craigieburn','-43.1315','171.8273'),
  ('NZ','7581','Akaroa','-43.8041','172.9815'),
  ('NZ','7582','Wainui','-43.8233','172.9051'),
  ('NZ','7583','Robinsons Bay','-43.7354','172.9876'),
  ('NZ','7591','Ataahua','-43.7998','172.6341'),
  ('NZ','7600','Burnham','-43.6162','172.2987'),
  ('NZ','7602','Southbridge','-43.804','172.2416'),
  ('NZ','7604','Prebbleton','-43.5829','172.5143'),
  ('NZ','7608','Lincoln','-43.6416','172.4835'),
  ('NZ','7610','Woodend','-43.3206','172.6648'),
  ('NZ','7614','Rolleston','-43.6013','172.377'),
  ('NZ','7616','Springston','-43.6444','172.4224'),
  ('NZ','7630','Kaiapoi','-43.3848','172.6766'),
  ('NZ','7632','Leeston','-43.7612','172.2977'),
  ('NZ','7640','Lincoln','-43.6405','172.4841'),
  ('NZ','7641','Woodend','-43.3224','172.6659'),
  ('NZ','7642','Southbridge','-43.8115','172.2516'),
  ('NZ','7643','Rolleston','-43.5927','172.3759'),
  ('NZ','7644','Kaiapoi','-43.3825','172.6588'),
  ('NZ','7645','Tai Tapu','-43.6617','172.5484'),
  ('NZ','7646','Coalgate','-43.4833','171.9644'),
  ('NZ','7647','Lincoln','-43.643','172.4691'),
  ('NZ','7649','Springfield','-43.3371','171.9272'),
  ('NZ','7656','Leeston','-43.7636','172.296'),
  ('NZ','7657','Dunsandel','-43.6591','172.1964'),
  ('NZ','7670','Coutts Island','-43.4325','172.589'),
  ('NZ','7671','Aylesbury','-43.5419','172.2131'),
  ('NZ','7672','Motukarara','-43.7013','172.6222'),
  ('NZ','7673','Whitecliffs','-43.4603','171.8825'),
  ('NZ','7674','Springston South','-43.7046','172.4643'),
  ('NZ','7675','Rolleston','-43.5966','172.3476'),
  ('NZ','7676','Templeton','-43.5524','172.4437'),
  ('NZ','7681','Springfield','-43.3295','171.9412'),
  ('NZ','7682','Dunsandel','-43.6886','172.1913'),
  ('NZ','7683','Southbridge','-43.7963','172.2491'),
  ('NZ','7691','Flaxton','-43.3547','172.6477'),
  ('NZ','7692','Wetheral','-43.3948','172.5762'),
  ('NZ','7700','Allenton','-43.898','171.745'),
  ('NZ','7710','Rakaia','-43.7547','172.0272'),
  ('NZ','7730','Methven','-43.6323','171.6437'),
  ('NZ','7740','Hampstead','-43.903','171.7503'),
  ('NZ','7741','Tinwald','-43.92','171.7206'),
  ('NZ','7742','Allenton','-43.8874','171.7427'),
  ('NZ','7743','Rakaia','-43.7551','172.0207'),
  ('NZ','7745','Methven','-43.6332','171.6468'),
  ('NZ','7746','Mount Somers','-43.7058','171.402'),
  ('NZ','7747','Hinds','-44.0032','171.5687'),
  ('NZ','7748','Mayfield','-43.8208','171.4225'),
  ('NZ','7771','Staveley','-43.5078','171.1763'),
  ('NZ','7772','Mitcham','-43.7966','171.8593'),
  ('NZ','7773','Hinds','-44.0609','171.5171'),
  ('NZ','7774','Flemington','-44.0196','171.7093'),
  ('NZ','7775','Lismore','-43.9232','171.471'),
  ('NZ','7776','Lyndhurst','-43.7501','171.6736'),
  ('NZ','7777','Seafield','-43.9445','171.9202'),
  ('NZ','7778','Mayfield','-43.8003','171.4252'),
  ('NZ','7781','Dorie','-43.8524','172.0759'),
  ('NZ','7782','Highbank','-43.5682','171.7097'),
  ('NZ','7783','Te Pirita','-43.6771','171.9801'),
  ('NZ','7784','Somerton','-43.7301','171.9081'),
  ('NZ','7791','Lake Coleridge','-43.3864','171.332'),
  ('NZ','7802','Runanga','-42.4169','171.2586'),
  ('NZ','7803','Rewanui','-42.3888','171.2964'),
  ('NZ','7804','Roa','-42.382','171.372'),
  ('NZ','7805','Marsden','-42.5254','171.2455'),
  ('NZ','7810','Hokitika','-42.7183','170.9651'),
  ('NZ','7811','Kaniere','-42.7416','171.0127'),
  ('NZ','7812','Ross','-42.9461','170.8147'),
  ('NZ','7822','Hector','-41.6077','171.8763'),
  ('NZ','7823','Granity','-41.6302','171.8502'),
  ('NZ','7825','Carters Beach','-41.7486','171.5903'),
  ('NZ','7830','Reefton','-42.1122','171.8582'),
  ('NZ','7832','Kumara','-42.6217','171.1725'),
  ('NZ','7840','Cobden','-42.4491','171.2107'),
  ('NZ','7841','Runanga','-42.402','171.2522'),
  ('NZ','7842','Hokitika','-42.7172','170.9614'),
  ('NZ','7843','Ahaura','-42.3486','171.5407'),
  ('NZ','7844','Haast','-43.862','169.0035'),
  ('NZ','7845','Moana','-42.5722','171.483'),
  ('NZ','7846','Ikamatua','-42.2712','171.6849'),
  ('NZ','7847','Springs Junction','-42.3351','172.182'),
  ('NZ','7848','Waimangaroa','-41.714','171.7629'),
  ('NZ','7851','Reefton','-42.1194','171.8648'),
  ('NZ','7856','Franz Josef/Waiau','-43.3888','170.182'),
  ('NZ','7857','Whataroa','-43.262','170.3604'),
  ('NZ','7859','Weheka','-43.4655','170.0172'),
  ('NZ','7860','Ross','-42.8988','170.8167'),
  ('NZ','7861','Kumara','-42.63','171.1859'),
  ('NZ','7862','Maruia','-42.1885','172.2204'),
  ('NZ','7863','Harihari','-43.1491','170.5572'),
  ('NZ','7864','Market Cross','-41.2514','172.1284'),
  ('NZ','7865','Charleston','-41.9073','171.4381'),
  ('NZ','7866','Carters Beach','-41.7557','171.599'),
  ('NZ','7867','Hector','-41.6067','171.8779'),
  ('NZ','7871','Ikamatua','-42.2475','171.6635'),
  ('NZ','7872','Bell Hill','-42.5384','171.717'),
  ('NZ','7873','Barrytown','-42.2469','171.3227'),
  ('NZ','7875','Aickens','-42.8109','171.6001'),
  ('NZ','7881','Kowhitirangi','-42.907','171.1379'),
  ('NZ','7882','Goldsborough','-42.6852','171.1127'),
  ('NZ','7883','Kowhitirangi','-42.886','170.9152'),
  ('NZ','7884','Harihari','-43.1353','170.6262'),
  ('NZ','7885','Fergusons','-43.0658','170.8442'),
  ('NZ','7886','Mahitahi','-43.7673','169.3817'),
  ('NZ','7891','Mokihinui Mine','-41.5514','172.0406'),
  ('NZ','7892','Te Kuha','-41.8946','171.5678'),
  ('NZ','7893','Oparara','-41.2059','172.1609'),
  ('NZ','7895','Crushington','-42.1053','172.0272'),
  ('NZ','7901','Twizel','-44.262','170.0746'),
  ('NZ','7903','Pleasant Point','-44.2585','171.1305'),
  ('NZ','7910','Seaview','-44.3864','171.2285'),
  ('NZ','7912','Pareora','-44.4875','171.2097'),
  ('NZ','7920','Temuka','-44.2375','171.2852'),
  ('NZ','7924','Waimate','-44.7318','171.0476'),
  ('NZ','7925','Fairlie','-44.0947','170.8289'),
  ('NZ','7930','Geraldine','-44.0934','171.242'),
  ('NZ','7940','Timaru','-44.395','171.2532'),
  ('NZ','7941','Puhuka','-44.3563','171.238'),
  ('NZ','7942','Parkside','-44.3906','171.2445'),
  ('NZ','7943','Kensington','-44.4053','171.2344'),
  ('NZ','7944','Twizel','-44.258','170.1'),
  ('NZ','7945','Lake Tekapo','-44.0043','170.4772'),
  ('NZ','7946','Glentanner','-43.7327','170.0938'),
  ('NZ','7947','Pleasant Point','-44.2601','171.1275'),
  ('NZ','7948','Temuka','-44.244','171.2773'),
  ('NZ','7949','Fairlie','-44.0984','170.8295'),
  ('NZ','7956','Geraldine','-44.0912','171.2436'),
  ('NZ','7957','Cave','-44.3103','170.9523'),
  ('NZ','7958','Winchester','-44.1851','171.2782'),
  ('NZ','7960','Waimate','-44.7334','171.0476'),
  ('NZ','7971','Esk Valley','-44.53','171.0859'),
  ('NZ','7972','Southburn','-44.4575','171.0532'),
  ('NZ','7973','Seadown','-44.3175','171.2918'),
  ('NZ','7974','Claremont','-44.3314','171.124'),
  ('NZ','7977','Waihaorunga','-44.7324','170.8388'),
  ('NZ','7978','Waimate','-44.6945','171.0101'),
  ('NZ','7979','Waihao Forks','-44.8281','170.9906'),
  ('NZ','7980','Morven','-44.8219','171.1192'),
  ('NZ','7982','Hazelburn','-44.2151','170.9986'),
  ('NZ','7983','Sutherlands','-44.2887','171.0431'),
  ('NZ','7984','Mawaro','-44.3312','170.8526'),
  ('NZ','7985','Waitohi Flat','-44.204','171.1929'),
  ('NZ','7986','Orton','-44.1694','171.3866'),
  ('NZ','7987','Waikarua','-44.0577','170.8816'),
  ('NZ','7988','Esk Valley','-44.5216','171.0694'),
  ('NZ','7990','Sherwood Downs','-43.6686','170.9233'),
  ('NZ','7991','Te Moana','-44.0601','171.108'),
  ('NZ','7992','Arundel','-44.0184','171.2776'),
  ('NZ','7999','Glentanner','-43.9781','170.1682'),
  ('NZ','8011','Christchurch','-43.5341','172.637'),
  ('NZ','8013','Christchurch','-44.5772','175.5503'),
  ('NZ','8014','Saint Albans','-43.5136','172.6205'),
  ('NZ','8022','Cashmere Hills','-43.5831','172.6644'),
  ('NZ','8023','Hillsborough','-43.5559','172.6689'),
  ('NZ','8024','Spreydon','-43.5565','172.6024'),
  ('NZ','8025','Halswell','-43.5884','172.579'),
  ('NZ','8041','Fendalton','-43.5225','172.5813'),
  ('NZ','8042','Hei Hei','-43.5294','172.5174'),
  ('NZ','8051','Harewood','-43.4611','172.5247'),
  ('NZ','8052','Papanui','-43.5007','172.6257'),
  ('NZ','8053','Burnside','-43.4957','172.5679'),
  ('NZ','8061','Aranui','-43.5079','172.7021'),
  ('NZ','8062','Bromley','-43.541','172.71'),
  ('NZ','8081','Sumner','-43.5753','172.7589'),
  ('NZ','8082','Lyttelton','-43.6024','172.7241'),
  ('NZ','8083','Ouruhia','-43.4492','172.6875'),
  ('NZ','8140','Christchurch','-43.5319','172.6316'),
  ('NZ','8141','Christchurch','-43.5286','172.6392'),
  ('NZ','8142','Christchurch','-43.5352','172.6403'),
  ('NZ','8143','Saint Albans','-43.5136','172.6377'),
  ('NZ','8144','Christchurch','-43.5241','172.6307'),
  ('NZ','8145','Opawa','-43.5404','172.6585'),
  ('NZ','8146','Saint Albans','-43.5127','172.622'),
  ('NZ','8147','Linwood','-43.5302','172.6573'),
  ('NZ','8148','Avonside','-43.5177','172.6559'),
  ('NZ','8149','Spreydon','-43.5451','172.6083'),
  ('NZ','8240','Sydenham','-43.5452','172.6365'),
  ('NZ','8241','Woolston','-43.5498','172.6842'),
  ('NZ','8242','Beckenham','-43.5579','172.6366'),
  ('NZ','8243','Spreydon','-43.5457','172.6085'),
  ('NZ','8244','Somerfield','-43.5571','172.6189'),
  ('NZ','8245','Halswell','-43.5802','172.567'),
  ('NZ','8246','Hillsborough','-43.558','172.6542'),
  ('NZ','8247','Mount Pleasant','-43.5574','172.7026'),
  ('NZ','8440','Riccarton','-43.5298','172.6012'),
  ('NZ','8441','Hornby','-43.5432','172.5252'),
  ('NZ','8442','Upper Riccarton','-43.5318','172.5723'),
  ('NZ','8443','Wigram','-43.5384','172.5559'),
  ('NZ','8444','Ilam','-43.5167','172.5718'),
  ('NZ','8445','Templeton','-43.5533','172.4732'),
  ('NZ','8540','Fendalton','-43.5177','172.5884'),
  ('NZ','8542','Papanui','-43.4952','172.6088'),
  ('NZ','8543','Harewood','-43.489','172.5872'),
  ('NZ','8544','Harewood','-43.4884','172.5388'),
  ('NZ','8545','Burnside','-43.489','172.567'),
  ('NZ','8546','Belfast','-43.4454','172.6324'),
  ('NZ','8640','Dallington','-43.507','172.6631'),
  ('NZ','8641','New Brighton','-43.5073','172.7287'),
  ('NZ','8642','Bromley','-43.533','172.6735'),
  ('NZ','8643','Aranui','-43.5178','172.7005'),
  ('NZ','8840','Sumner','-43.569','172.7593'),
  ('NZ','8841','Lyttelton','-43.603','172.7223'),
  ('NZ','8842','North New Brighton','-43.4817','172.706'),
  ('NZ','8941','Diamond Harbour','-43.6252','172.7402'),
  ('NZ','8942','Diamond Harbour','-45.2397','178.0457'),
  ('NZ','8971','Allandale','-43.6438','172.6814'),
  ('NZ','8972','Pigeon Bay','-43.658','172.8054'),
  ('NZ','9010','Liberton','-45.8366','170.5074'),
  ('NZ','9011','Mornington','-45.8792','170.472'),
  ('NZ','9012','Saint Kilda','-45.9059','170.4912'),
  ('NZ','9013','Ocean Grove','-45.8962','170.5368'),
  ('NZ','9014','Broad Bay','-45.8447','170.6214'),
  ('NZ','9016','Waverley','-45.8714','170.5119'),
  ('NZ','9018','Sunnyvale','-45.9004','170.4259'),
  ('NZ','9019','Outram','-45.8603','170.2312'),
  ('NZ','9022','Maia','-45.8534','170.5626'),
  ('NZ','9023','Sawyers Bay','-45.8185','170.6084'),
  ('NZ','9024','Mosgiel','-45.8839','170.3552'),
  ('NZ','9035','Brighton','-45.9397','170.337'),
  ('NZ','9040','Maryhill','-45.881','170.4796'),
  ('NZ','9041','Opoho','-45.855','170.5192'),
  ('NZ','9042','Kaikorai','-45.8579','170.4783'),
  ('NZ','9043','North Dunedin','-45.8584','170.501'),
  ('NZ','9044','Saint Kilda','-45.8944','170.4994'),
  ('NZ','9045','Caversham','-45.8964','170.4806'),
  ('NZ','9046','Tainui','-45.9003','170.5041'),
  ('NZ','9047','Saint Clair','-45.9062','170.4874'),
  ('NZ','9048','Portobello','-45.8394','170.6511'),
  ('NZ','9049','Saint Kilda','-45.8976','170.5154'),
  ('NZ','9050','Port Chalmers','-45.8157','170.6218'),
  ('NZ','9052','Green Island','-45.9017','170.4297'),
  ('NZ','9053','Mosgiel','-45.8758','170.3489'),
  ('NZ','9054','Dunedin','-45.8777','170.5018'),
  ('NZ','9058','Dunedin','-45.8725','170.5036'),
  ('NZ','9059','Dunedin','-45.8661','170.5096'),
  ('NZ','9062','Outram','-45.8566','170.2312'),
  ('NZ','9067','Middlemarch','-45.507','170.119'),
  ('NZ','9069','Waitati','-45.7457','170.5681'),
  ('NZ','9073','Berwick','-45.9556','170.0903'),
  ('NZ','9074','Clarks','-45.7542','170.0897'),
  ('NZ','9076','Wingatui','-45.8904','170.3894'),
  ('NZ','9077','Portobello','-45.8414','170.6419'),
  ('NZ','9081','Mihiwaka','-45.7734','170.6412'),
  ('NZ','9082','Aramoana','-45.7887','170.6719'),
  ('NZ','9085','Mount Cargill','-45.7894','170.5411'),
  ('NZ','9091','Kuri Bush','-46.0502','170.2184'),
  ('NZ','9092','Mosgiel','-45.8778','170.3416'),
  ('NZ','9210','Kaitangata','-46.2799','169.8409'),
  ('NZ','9220','Milton','-46.1224','169.9704'),
  ('NZ','9230','Balclutha','-46.2388','169.7372'),
  ('NZ','9231','Stirling','-46.2489','169.7761'),
  ('NZ','9240','Balclutha','-46.2388','169.7388'),
  ('NZ','9241','Milton','-46.1225','169.9577'),
  ('NZ','9242','Clydevale','-46.1006','169.5278'),
  ('NZ','9271','Glenomaru','-46.3681','169.6834'),
  ('NZ','9272','Hillend','-46.1549','169.711'),
  ('NZ','9273','Warepa','-46.2563','169.5825'),
  ('NZ','9274','Greenfield','-46.1034','169.5665'),
  ('NZ','9281','Kaitangata','-46.2711','169.8161'),
  ('NZ','9282','Wangaloa','-46.2844','169.9177'),
  ('NZ','9291','Milburn','-46.0511','169.9467'),
  ('NZ','9292','Tokoiti','-46.1673','169.9725'),
  ('NZ','9300','Frankton','-45.0379','168.6879'),
  ('NZ','9302','Arrowtown','-44.9446','168.83'),
  ('NZ','9304','Lower Shotover','-45.002','168.7928'),
  ('NZ','9305','Wanaka','-44.6861','169.1275'),
  ('NZ','9310','Cromwell','-45.042','169.1991'),
  ('NZ','9320','Bridge Hill','-45.2502','169.3859'),
  ('NZ','9330','Clyde','-45.1907','169.3237'),
  ('NZ','9332','Ranfurly','-45.1272','170.1027'),
  ('NZ','9340','Bridge Hill','-45.2562','169.3928'),
  ('NZ','9341','Clyde','-45.187','169.3169'),
  ('NZ','9342','Cromwell','-45.037','169.1977'),
  ('NZ','9343','Wanaka','-44.6943','169.1392'),
  ('NZ','9344','Albert Town','-44.6826','169.1886'),
  ('NZ','9345','Lake Hawea','-44.6108','169.2564'),
  ('NZ','9346','Makarora','-44.2315','169.2322'),
  ('NZ','9347','Tarras','-44.8376','169.4117'),
  ('NZ','9348','Queenstown','-45.0319','168.6622'),
  ('NZ','9349','Frankton','-45.0159','168.731'),
  ('NZ','9350','Glenorchy','-44.8498','168.3841'),
  ('NZ','9351','Arrowtown','-44.9388','168.833'),
  ('NZ','9352','Omakau','-45.0939','169.6023'),
  ('NZ','9353','Ranfurly','-45.1301','170.0999'),
  ('NZ','9354','Naseby','-45.0232','170.1467'),
  ('NZ','9355','Wedderburn','-45.0301','170.01'),
  ('NZ','9356','Mataura','-46.1943','168.866'),
  ('NZ','9371','Upper Shotover','-44.8414','168.7167'),
  ('NZ','9372','Glenorchy','-44.7968','168.3693'),
  ('NZ','9376','Matakanui','-45.0071','169.5416'),
  ('NZ','9377','Becks','-44.9861','169.7227'),
  ('NZ','9381','Glendhu','-44.767','168.9844'),
  ('NZ','9382','Makarora Wharf','-44.4032','168.8713'),
  ('NZ','9383','Lindis Crossing','-44.9205','169.4594'),
  ('NZ','9384','Gibbston','-45.0464','169.0655'),
  ('NZ','9386','Saint Bathans','-44.8323','169.8647'),
  ('NZ','9387','Moa Creek','-45.2408','169.7576'),
  ('NZ','9391','Clyde','-45.192','169.294'),
  ('NZ','9392','Fruitlands','-45.3788','169.3765'),
  ('NZ','9393','Chatto Creek','-45.1166','169.4805'),
  ('NZ','9395','Gimmerburn','-45.1302','169.961'),
  ('NZ','9396','Naseby','-44.9052','170.1778'),
  ('NZ','9397','Kokonga','-45.2161','170.2615'),
  ('NZ','9398','Paerau','-45.3578','169.9176'),
  ('NZ','9400','Oamaru','-45.0928','170.9785'),
  ('NZ','9401','Waiareka Junction','-45.0941','170.931'),
  ('NZ','9410','Hampden','-45.3317','170.7353'),
  ('NZ','9412','Berwen','-44.4715','169.8719'),
  ('NZ','9430','Palmerston','-45.4816','170.7112'),
  ('NZ','9435','Wharekuri','-44.7296','170.334'),
  ('NZ','9441','Roxburgh','-45.5409','169.3153'),
  ('NZ','9442','Hampden','-45.3238','170.8172'),
  ('NZ','9443','Palmerston','-45.4854','170.7146'),
  ('NZ','9444','Oamaru','-45.0976','170.9701'),
  ('NZ','9445','Duntroon','-44.8538','170.6817'),
  ('NZ','9446','Kurow','-44.733','170.4698'),
  ('NZ','9447','Otematata','-44.6063','170.1929'),
  ('NZ','9448','Omarama','-44.4883','169.966'),
  ('NZ','9471','Seacliff','-45.6302','170.5342'),
  ('NZ','9472','Waikouaiti','-45.5521','170.646'),
  ('NZ','9481','Stoneburn','-45.4719','170.605'),
  ('NZ','9482','Katiki','-45.4259','170.7892'),
  ('NZ','9483','Macraes Flat','-45.3444','170.4595'),
  ('NZ','9491','Tokarahi','-45.017','170.6487'),
  ('NZ','9492','Kauru Hill','-45.1101','170.7251'),
  ('NZ','9493','Hilderthorpe','-44.9948','171.0596'),
  ('NZ','9494','Island Cliff','-44.9141','170.7018'),
  ('NZ','9495','Herbert','-45.2071','170.795'),
  ('NZ','9498','Kaingapai','-44.6013','170.5476'),
  ('NZ','9500','Roxburgh','-45.5421','169.2875'),
  ('NZ','9510','Waikouaiti','-45.5923','170.6938'),
  ('NZ','9522','Tapanui','-45.9434','169.2597'),
  ('NZ','9532','Lawrence','-45.9189','169.6862'),
  ('NZ','9534','Clinton','-46.202','169.379'),
  ('NZ','9535','Owaka','-46.4524','169.6592'),
  ('NZ','9541','Waikouaiti','-45.5958','170.6701'),
  ('NZ','9542','Tapanui','-45.9435','169.2613'),
  ('NZ','9543','Lawrence','-45.9129','169.6866'),
  ('NZ','9544','Millers Flat','-45.6629','169.4118'),
  ('NZ','9546','Owaka','-46.4511','169.6583'),
  ('NZ','9548','Clinton','-46.2023','169.3741'),
  ('NZ','9571','Roxburgh Hydro','-45.4504','169.4062'),
  ('NZ','9572','Millers Flat','-45.6087','169.517'),
  ('NZ','9583','Clinton','-46.312','169.2557'),
  ('NZ','9584','Clinton','-46.1678','169.3947'),
  ('NZ','9585','New Haven','-46.4584','169.7039'),
  ('NZ','9586','Puketiro','-46.4864','169.448'),
  ('NZ','9587','Park Hill','-45.7378','169.2347'),
  ('NZ','9588','Raes Junction','-45.7799','169.475'),
  ('NZ','9591','Beaumont','-45.7898','169.6184'),
  ('NZ','9593','Waitahuna','-45.9805','169.7257'),
  ('NZ','9596','Ngapuna','-45.4417','170.1501'),
  ('NZ','9597','Rocklands','-45.5953','170.0034'),
  ('NZ','9598','Ngapuna','-45.5065','170.2682'),
  ('NZ','9600','Te Anau','-45.4033','167.7195'),
  ('NZ','9610','Otautau','-46.1439','167.9955'),
  ('NZ','9620','Tuatapere','-46.1327','167.6766'),
  ('NZ','9630','Nightcaps','-45.9708','168.0264'),
  ('NZ','9635','Ohai','-45.9322','167.9562'),
  ('NZ','9640','Te Anau','-45.4151','167.7164'),
  ('NZ','9641','Otautau','-46.1435','167.9974'),
  ('NZ','9642','Tuatapere','-46.1332','167.6892'),
  ('NZ','9643','Manapouri','-45.5661','167.6092'),
  ('NZ','9644','Nightcaps','-45.9702','168.0321'),
  ('NZ','9645','Ohai','-45.9326','167.9568'),
  ('NZ','9672','The Key','-45.3207','168.0962'),
  ('NZ','9679','Te Anau','-45.0353','167.5133'),
  ('NZ','9682','Eastern Bush','-45.9426','167.7666'),
  ('NZ','9683','Fairfax','-46.1885','168.0818'),
  ('NZ','9689','Ngaro','-45.9004','167.9675'),
  ('NZ','9691','Wairoto','-45.8003','167.1138'),
  ('NZ','9710','East Gore','-46.0997','168.9357'),
  ('NZ','9712','Mataura','-46.1902','168.8673'),
  ('NZ','9720','Winton','-46.1414','168.3187'),
  ('NZ','9730','Lumsden','-45.7391','168.4462'),
  ('NZ','9740','East Gore','-46.1001','168.9448'),
  ('NZ','9741','Winton','-46.1428','168.3247'),
  ('NZ','9742','Lumsden','-45.7392','168.4415'),
  ('NZ','9743','Waikaka','-45.9215','169.0145'),
  ('NZ','9744','Riversdale','-45.9021','168.7426'),
  ('NZ','9745','Waikaia','-45.7249','168.8484'),
  ('NZ','9746','Balfour','-45.8377','168.5889'),
  ('NZ','9747','Mossburn','-45.6698','168.2389'),
  ('NZ','9748','Kingston','-45.3381','168.7237'),
  ('NZ','9749','Athol','-45.5095','168.5739'),
  ('NZ','9750','Garston','-45.467','168.6838'),
  ('NZ','9752','Dipton','-45.8989','168.3698'),
  ('NZ','9771','Conical Hills','-46.0435','169.22'),
  ('NZ','9772','Pukerau','-46.1897','169.0657'),
  ('NZ','9773','Wendon Valley','-45.9083','168.9263'),
  ('NZ','9774','Mataura','-46.1756','168.8082'),
  ('NZ','9775','Waikoikoi','-45.946','169.1213'),
  ('NZ','9776','Riversdale','-45.8847','168.7116'),
  ('NZ','9777','Waipounamu','-45.836','168.7523'),
  ('NZ','9778','Garston','-45.526','168.9769'),
  ('NZ','9779','Balfour','-45.8426','168.5269'),
  ('NZ','9781','Lochiel','-46.2018','168.3909'),
  ('NZ','9782','Otapiri Gorge','-46.0726','168.4668'),
  ('NZ','9783','South Hillend','-45.9932','168.1991'),
  ('NZ','9791','Dipton','-45.9097','168.4293'),
  ('NZ','9792','Mossburn','-45.6973','168.2036'),
  ('NZ','9793','Kingston','-45.3967','168.6723'),
  ('NZ','9794','Lumsden','-45.7516','168.4602'),
  ('NZ','9810','Waverley','-46.3894','168.3722'),
  ('NZ','9812','Tisbury','-46.4382','168.3764'),
  ('NZ','9814','Bluff','-46.6035','168.3309'),
  ('NZ','9816','Wallacetown','-46.339','168.2904'),
  ('NZ','9818','Halfmoon Bay (Oban)','-46.9877','167.8382'),
  ('NZ','9822','Riverton','-46.3631','168.0165'),
  ('NZ','9825','Edendale','-46.3084','168.7938'),
  ('NZ','9831','Wyndham','-46.3304','168.8438'),
  ('NZ','9840','Richmond','-46.4109','168.3511'),
  ('NZ','9841','Glengarry','-46.3982','168.3658'),
  ('NZ','9842','East End','-46.5991','168.3436'),
  ('NZ','9843','Waikiwi','-46.3772','168.3471'),
  ('NZ','9844','Strathern','-46.4276','168.3612'),
  ('NZ','9845','Hawthorndale','-46.4017','168.3853'),
  ('NZ','9846','Half-moon Bay','-46.8992','168.1292'),
  ('NZ','9847','Riverton','-46.3522','168.0136'),
  ('NZ','9848','Edendale','-46.3132','168.7842'),
  ('NZ','9849','Wyndham','-46.3322','168.8477'),
  ('NZ','9871','Woodlands','-46.3867','168.5511'),
  ('NZ','9872','Mabel Bush','-46.2616','168.5395'),
  ('NZ','9874','Waianiwa','-46.2773','168.2387'),
  ('NZ','9875','Fortrose','-46.553','168.722'),
  ('NZ','9876','Makarewa','-46.3136','168.4063'),
  ('NZ','9877','Awarua Plains','-46.5072','168.4056'),
  ('NZ','9879','Otatara','-46.4308','168.2429'),
  ('NZ','9881','Round Hill','-46.2657','167.8109'),
  ('NZ','9883','Gummies Bush','-46.2689','168.0316'),
  ('NZ','9884','Niagara','-46.5851','169.0999'),
  ('NZ','9891','Glenham','-46.4308','168.8784'),
  ('NZ','9892','Mokoreta','-46.3907','169.0861'),
  ('NZ','9893','Kamahi','-46.3644','168.7108');

/*!40000 ALTER TABLE `civicrm_geonames_lookup` 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 */;
