--
-- Host: localhost    Database: Quickadclassified
-- ------------------------------------------------------


--
-- Dumping data for table `<<prefix>>subadmin1`
--

INSERT INTO `<<prefix>>subadmin1` VALUES (2487,'NZ.G2','NZ','Wellington','Wellington',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2488,'NZ.F3','NZ','Manawatu-Wanganui','Manawatu-Wanganui',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2489,'NZ.G1','NZ','Waikato','Waikato',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2490,'NZ.TAS','NZ','Tasman','Tasman',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2491,'NZ.F9','NZ','Taranaki','Taranaki',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2492,'NZ.F8','NZ','Southland','Southland',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2493,'NZ.E8','NZ','Bay of Plenty','Bay of Plenty',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2494,'NZ.F6','NZ','Northland','Northland',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2495,'NZ.F4','NZ','Marlborough','Marlborough',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2496,'NZ.F2','NZ','Hawke\'s Bay','Hawke\'s Bay',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2497,'NZ.F1','NZ','Gisborne','Gisborne',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2498,'NZ.E9','NZ','Canterbury','Canterbury',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2499,'NZ.E7','NZ','Auckland','Auckland',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2500,'NZ.10','NZ','Chatham Islands','Chatham Islands',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2501,'NZ.F5','NZ','Nelson','Nelson',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2502,'NZ.F7','NZ','Otago','Otago',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2503,'NZ.G3','NZ','West Coast','West Coast',1);

--
-- Dumping data for table `<<prefix>>subadmin2`
--

INSERT INTO `<<prefix>>subadmin2` VALUES (28450,'NZ.F6.002','NZ','NZ.F6','Whangarei','Whangarei',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28451,'NZ.E8.025','NZ','NZ.E8','Whakatane District','Whakatane District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28452,'NZ.G3.057','NZ','NZ.G3','Westland District','Westland District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28453,'NZ.G1.020','NZ','NZ.G1','Waitomo District','Waitomo District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28454,'NZ.F2.029','NZ','NZ.F2','Wairoa District','Wairoa District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28455,'NZ.E9.066','NZ','NZ.E9','Waimate District','Waimate District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28456,'NZ.E9.064','NZ','NZ.E9','Timaru District','Timaru District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28457,'NZ.G1.011','NZ','NZ.G1','Thames-Coromandel District','Thames-Coromandel District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28458,'NZ.G1.021','NZ','NZ.G1','Taupo District','Taupo District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28459,'NZ.F9.034','NZ','NZ.F9','Stratford District','Stratford District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28460,'NZ.E8.024','NZ','NZ.E8','Rotorua District','Rotorua District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28461,'NZ.F3.038','NZ','NZ.F3','Rangitikei District','Rangitikei District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28462,'NZ.G1.018','NZ','NZ.G1','Otorohanga District','Otorohanga District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28463,'NZ.E8.027','NZ','NZ.E8','Opotiki District','Opotiki District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28464,'NZ.F9.033','NZ','NZ.F9','New Plymouth District','New Plymouth District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28465,'NZ.G2.048','NZ','NZ.G2','Masterton District','Masterton District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28466,'NZ.E8.026','NZ','NZ.E8','Kawerau District','Kawerau District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28467,'NZ.F2.030','NZ','NZ.F2','Hastings District','Hastings District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28468,'NZ.F8.074','NZ','NZ.F8','Gore District','Gore District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28469,'NZ.F1.028','NZ','NZ.F1','Gisborne District','Gisborne District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28470,'NZ.G2.049','NZ','NZ.G2','Carterton District','Carterton District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28471,'NZ.E7.076','NZ','NZ.E7','Auckland','Auckland',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28472,'NZ.E9.063','NZ','NZ.E9','Ashburton District','Ashburton District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28473,'NZ.G3.055','NZ','NZ.G3','Buller District','Buller District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28474,'NZ.F2.032','NZ','NZ.F2','Central Hawke\'s Bay District','Central Hawke\'s Bay District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28475,'NZ.F7.069','NZ','NZ.F7','Central Otago District','Central Otago District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28476,'NZ.E9.060','NZ','NZ.E9','Christchurch City','Christchurch City',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28477,'NZ.F7.072','NZ','NZ.F7','Clutha District','Clutha District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28478,'NZ.F7.071','NZ','NZ.F7','Dunedin City','Dunedin City',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28479,'NZ.F6.001','NZ','NZ.F6','Far North District','Far North District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28480,'NZ.G3.056','NZ','NZ.G3','Grey District','Grey District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28481,'NZ.G1.016','NZ','NZ.G1','Hamilton City','Hamilton City',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28482,'NZ.G1.012','NZ','NZ.G1','Hauraki District','Hauraki District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28483,'NZ.F3.042','NZ','NZ.F3','Horowhenua District','Horowhenua District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28484,'NZ.E9.058','NZ','NZ.E9','Hurunui District','Hurunui District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28485,'NZ.F8.075','NZ','NZ.F8','Invercargill City','Invercargill City',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28486,'NZ.E9.054','NZ','NZ.E9','Kaikoura District','Kaikoura District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28487,'NZ.F6.003','NZ','NZ.F6','Kaipara District','Kaipara District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28488,'NZ.G2.043','NZ','NZ.G2','Kapiti Coast District','Kapiti Coast District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28489,'NZ.G2.046','NZ','NZ.G2','Lower Hutt City','Lower Hutt City',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28490,'NZ.E9.065','NZ','NZ.E9','Mackenzie District','Mackenzie District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28491,'NZ.F3.039','NZ','NZ.F3','Manawatu District','Manawatu District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28492,'NZ.F4.053','NZ','NZ.F4','Marlborough District','Marlborough District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28493,'NZ.G1.015','NZ','NZ.G1','Matamata-Piako District','Matamata-Piako District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28494,'NZ.F2.031','NZ','NZ.F2','Napier City','Napier City',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28495,'NZ.F5.052','NZ','NZ.F5','Nelson City','Nelson City',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28496,'NZ.F3.040','NZ','NZ.F3','Palmerston North City','Palmerston North City',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28497,'NZ.G2.044','NZ','NZ.G2','Porirua City','Porirua City',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28498,'NZ.F7.070','NZ','NZ.F7','Queenstown-Lakes District','Queenstown-Lakes District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28499,'NZ.F3.036','NZ','NZ.F3','Ruapehu District','Ruapehu District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28500,'NZ.E9.062','NZ','NZ.E9','Selwyn District','Selwyn District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28501,'NZ.F8.073','NZ','NZ.F8','Southland District','Southland District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28502,'NZ.F9.035','NZ','NZ.F9','South Taranaki District','South Taranaki District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28503,'NZ.G1.019','NZ','NZ.G1','South Waikato District','South Waikato District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28504,'NZ.G2.050','NZ','NZ.G2','South Wairarapa District','South Wairarapa District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28505,'NZ.TAS.051','NZ','NZ.TAS','Tasman District','Tasman District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28506,'NZ.E8.023','NZ','NZ.E8','Tauranga City','Tauranga City',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28507,'NZ.G2.045','NZ','NZ.G2','Upper Hutt City','Upper Hutt City',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28508,'NZ.G1.013','NZ','NZ.G1','Waikato District','Waikato District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28509,'NZ.E9.059','NZ','NZ.E9','Waimakariri District','Waimakariri District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28510,'NZ.G1.017','NZ','NZ.G1','Waipa District','Waipa District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28511,'NZ.F3.037','NZ','NZ.F3','Wanganui District','Wanganui District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28512,'NZ.G2.047','NZ','NZ.G2','Wellington City','Wellington City',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28513,'NZ.E8.022','NZ','NZ.E8','Western Bay of Plenty District','Western Bay of Plenty District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28514,'NZ.F3.041','NZ','NZ.F3','Tararua District','Tararua District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (28515,'NZ.E9.068','NZ','NZ.E9','Waitaki District','Waitaki District',1);

--
-- Dumping data for table `<<prefix>>cities`
--

INSERT INTO `<<prefix>>cities` VALUES (2179537,'NZ','Wellington','Wellington',-41.2866,174.776,'P','PPLC','NZ.G2','NZ.G2.047',381900,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2179670,'NZ','Wanganui','Wanganui',-39.9333,175.05,'P','PPL','NZ.F3','NZ.F3.037',40268,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2179756,'NZ','Waiuku','Waiuku',-37.2481,174.735,'P','PPL','NZ.E7','NZ.E7.076',7555,'Pacific/Auckland',1,'2015-03-16 23:00:00','2015-03-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2180995,'NZ','Tokoroa','Tokoroa',-38.2333,175.867,'P','PPL','NZ.G1','NZ.G1.019',14277,'Pacific/Auckland',1,'2014-11-02 23:00:00','2014-11-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2181133,'NZ','Timaru','Timaru',-44.3967,171.254,'P','PPL','NZ.E9','NZ.E9.064',28007,'Pacific/Auckland',1,'2015-04-30 23:00:00','2015-04-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2181742,'NZ','Taupo','Taupo',-38.6833,176.083,'P','PPL','NZ.G1','NZ.G1.021',22469,'Pacific/Auckland',1,'2017-09-14 23:00:00','2017-09-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2183472,'NZ','Richmond','Richmond',-41.3333,173.183,'P','PPLA','NZ.TAS','NZ.TAS.051',14000,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2184155,'NZ','Pukekohe East','Pukekohe East',-37.2,174.95,'P','PPL','NZ.E7','NZ.E7.076',21438,'Pacific/Auckland',1,'2015-03-04 23:00:00','2015-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2184361,'NZ','Motueka','Motueka',-41.1333,173.017,'P','PPL','NZ.TAS','NZ.TAS.051',7485,'Pacific/Auckland',1,'2017-06-04 23:00:00','2017-06-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2184397,'NZ','Porirua','Porirua',-41.1333,174.85,'P','PPL','NZ.G2','NZ.G2.044',50914,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2184904,'NZ','Paraparaumu','Paraparaumu',-40.9167,175.017,'P','PPL','NZ.G2','NZ.G2.043',25263,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2184943,'NZ','Papatowai','Papatowai',-46.5607,169.471,'P','PPL','NZ.F7','NZ.F7.072',6593,'Pacific/Auckland',1,'2015-03-05 23:00:00','2015-03-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2185018,'NZ','Palmerston North','Palmerston North',-40.3564,175.611,'P','PPLA','NZ.F3','NZ.F3.040',75996,'Pacific/Auckland',1,'2015-02-23 23:00:00','2015-02-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2185964,'NZ','North Shore','North Shore',-36.8,174.75,'P','PPLX','NZ.E7','NZ.E7.076',207865,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2186239,'NZ','New Plymouth','New Plymouth',-39.0667,174.083,'P','PPLA','NZ.F9','NZ.F9.033',49168,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2186280,'NZ','Nelson','Nelson',-41.2708,173.284,'P','PPLA','NZ.F5','NZ.F5.052',59200,'Pacific/Auckland',1,'2014-07-17 23:00:00','2014-07-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2186313,'NZ','Napier','Napier',-39.4926,176.912,'P','PPLA','NZ.F2','NZ.F2.031',56787,'Pacific/Auckland',1,'2017-05-23 23:00:00','2017-05-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2187404,'NZ','Manukau City','Manukau City',-36.9928,174.88,'P','PPL','NZ.E7','NZ.E7.076',362000,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2187454,'NZ','Mangere','Mangere',-36.9681,174.799,'P','PPL','NZ.E7','NZ.E7.076',55266,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2188164,'NZ','Lower Hutt','Lower Hutt',-41.2167,174.917,'P','PPL','NZ.G2','NZ.G2.046',101194,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2188874,'NZ','Kerikeri','Kerikeri',-35.2268,173.947,'P','PPL','NZ.F6','NZ.F6.001',5654,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2188942,'NZ','Kawerau','Kawerau',-38.1,176.7,'P','PPL','NZ.E8','NZ.E8.026',6702,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2189529,'NZ','Invercargill','Invercargill',-46.4,168.35,'P','PPLA','NZ.F8','NZ.F8.075',47287,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2190224,'NZ','Hastings','Hastings',-39.6381,176.849,'P','PPL','NZ.F2','NZ.F2.030',61696,'Pacific/Auckland',1,'2014-01-05 23:00:00','2014-01-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2190324,'NZ','Hamilton','Hamilton',-37.7833,175.283,'P','PPLA','NZ.G1','NZ.G1.016',152641,'Pacific/Auckland',1,'2017-09-16 23:00:00','2017-09-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2191562,'NZ','Dunedin','Dunedin',-45.8742,170.504,'P','PPLA','NZ.F7','NZ.F7.071',114347,'Pacific/Auckland',1,'2017-12-08 23:00:00','2017-12-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2192362,'NZ','Christchurch','Christchurch',-43.5333,172.633,'P','PPLA','NZ.E9','NZ.E9.060',363926,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2193733,'NZ','Auckland','Auckland',-36.8485,174.763,'P','PPLA','NZ.E7','NZ.E7.076',417910,'Pacific/Auckland',1,'2017-05-22 23:00:00','2017-05-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2206359,'NZ','Hawera','Hawera',-39.5917,174.283,'P','PPL','NZ.F9','NZ.F9.035',11068,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2206371,'NZ','Levin','Levin',-40.6333,175.275,'P','PPL','NZ.F3','NZ.F3.042',19789,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2206372,'NZ','Otaki','Otaki',-40.7583,175.15,'P','PPL','NZ.G2','NZ.G2.043',6086,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2206854,'NZ','Gisborne','Gisborne',-38.6533,178.004,'P','PPLA','NZ.F1','NZ.F1.028',34274,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2206890,'NZ','Masterton','Masterton',-40.9597,175.658,'P','PPL','NZ.G2','NZ.G2.048',20698,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2206895,'NZ','Greymouth','Greymouth',-42.4667,171.2,'P','PPLA','NZ.G3','NZ.G3.056',9419,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2208032,'NZ','Tauranga','Tauranga',-37.6861,176.167,'P','PPLA2','NZ.E8','NZ.E8.023',110338,'Pacific/Auckland',1,'2012-02-13 23:00:00','2012-02-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2208091,'NZ','Waitara','Waitara',-39.0016,174.238,'P','PPL','NZ.F9','NZ.F9.033',6318,'Pacific/Auckland',1,'2015-03-04 23:00:00','2015-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2208329,'NZ','Papakura','Papakura',-37.0657,174.944,'P','PPL','NZ.E7','NZ.E7.076',28010,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2208330,'NZ','Whakatane','Whakatane',-37.9585,176.985,'P','PPLA','NZ.E8','NZ.E8.025',18602,'Pacific/Auckland',1,'2012-02-12 23:00:00','2012-02-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2208333,'NZ','Thames','Thames',-37.1383,175.54,'P','PPL','NZ.G1','NZ.G1.011',7136,'Pacific/Auckland',1,'2014-09-27 23:00:00','2014-09-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (4032804,'NZ','Waitangi','Waitangi',-43.9535,-176.56,'P','PPLA','NZ.10',NULL,300,'Pacific/Chatham',1,'2011-11-05 23:00:00','2011-11-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6201424,'NZ','Gore','Gore',-46.1028,168.944,'P','PPL','NZ.F8','NZ.F8.074',12108,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6204696,'NZ','Queenstown','Queenstown',-45.0302,168.663,'P','PPL','NZ.F7','NZ.F7.070',10442,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6215045,'NZ','Oamaru','Oamaru',-45.0976,170.971,'P','PPL','NZ.F7',NULL,13000,'Pacific/Auckland',1,'2017-05-23 23:00:00','2017-05-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6217081,'NZ','Ashburton','Ashburton',-43.8983,171.73,'P','PPL','NZ.E9','NZ.E9.063',30100,'Pacific/Auckland',1,'2017-04-18 23:00:00','2017-04-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6220587,'NZ','Kaiapoi','Kaiapoi',-43.3783,172.64,'P','PPL','NZ.E9','NZ.E9.059',10200,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6230919,'NZ','Whangarei','Whangarei',-35.7317,174.324,'P','PPLA','NZ.F6','NZ.F6.002',50900,'Pacific/Auckland',1,'2011-02-27 23:00:00','2011-02-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6231568,'NZ','Takanini','Takanini',-37.0482,174.9,'P','PPL','NZ.E7','NZ.E7.076',10870,'Pacific/Auckland',1,'2014-07-02 23:00:00','2014-07-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6232082,'NZ','Pakuranga','Pakuranga',-36.8833,174.917,'P','PPL','NZ.E7','NZ.E7.076',8907,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6235764,'NZ','Matamata','Matamata',-37.8106,175.762,'P','PPL','NZ.G1','NZ.G1.015',6306,'Pacific/Auckland',1,'2017-02-03 23:00:00','2017-02-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6240770,'NZ','Cambridge','Cambridge',-37.8782,175.44,'P','PPL','NZ.G1','NZ.G1.017',15192,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6241325,'NZ','Rotorua','Rotorua',-38.1387,176.245,'P','PPLA2','NZ.E8','NZ.E8.024',65901,'Pacific/Auckland',1,'2017-09-14 23:00:00','2017-09-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6243926,'NZ','Blenheim','Blenheim',-41.516,173.953,'P','PPLA','NZ.F4','NZ.F4.053',26550,'Pacific/Auckland',1,'2014-07-15 23:00:00','2014-07-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6244864,'NZ','Petone','Petone',-41.2283,174.87,'P','PPLX','NZ.G2',NULL,6609,'Pacific/Auckland',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6244895,'NZ','Upper Hutt','Upper Hutt',-41.1383,175.05,'P','PPL','NZ.G2','NZ.G2.045',38400,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6246634,'NZ','Taradale','Taradale',-39.5333,176.85,'P','PPLX','NZ.F2','NZ.F2.031',16599,'Pacific/Auckland',1,'2011-07-31 23:00:00','2011-07-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6247826,'NZ','Ngaruawahia','Ngaruawahia',-37.6674,175.156,'P','PPL','NZ.G1','NZ.G1.013',5106,'Pacific/Auckland',1,'2015-03-17 23:00:00','2015-03-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7302484,'NZ','Waitakere','Waitakere',-36.9175,174.658,'P','PPL','NZ.E7','NZ.E7.076',208100,'Pacific/Auckland',1,'2012-05-16 23:00:00','2012-05-16 23:00:00');


