--
-- Host: localhost    Database: laraclassified
-- ------------------------------------------------------


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

INSERT INTO `<<prefix>>subadmin1` VALUES (3928,'ZA.03','ZA','Orange Free State','Orange Free State',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3929,'ZA.02','ZA','KwaZulu-Natal','KwaZulu-Natal',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3930,'ZA.05','ZA','Eastern Cape','Eastern Cape',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3931,'ZA.06','ZA','Gauteng','Gauteng',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3932,'ZA.07','ZA','Mpumalanga','Mpumalanga',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3933,'ZA.08','ZA','Northern Cape','Northern Cape',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3934,'ZA.09','ZA','Limpopo','Limpopo',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3935,'ZA.10','ZA','North-West','North-West',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3936,'ZA.11','ZA','Western Cape','Western Cape',1);

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

INSERT INTO `<<prefix>>subadmin2` VALUES (44260,'ZA.07.DC32','ZA','ZA.07','Ehlanzeni District','Ehlanzeni District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44261,'ZA.02.ETH','ZA','ZA.02','eThekwini Metropolitan Municipality','eThekwini Metropolitan Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44262,'ZA.11.CPT','ZA','ZA.11','City of Cape Town','City of Cape Town',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44263,'ZA.05.BUF','ZA','ZA.05','Buffalo City Metropolitan Municipality','Buffalo City Metropolitan Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44264,'ZA.05.DC10','ZA','ZA.05','Cacadu District Municipality','Cacadu District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44265,'ZA.05.DC12','ZA','ZA.05','Amathole District Municipality','Amathole District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44266,'ZA.05.DC13','ZA','ZA.05','Chris Hani District Municipality','Chris Hani District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44267,'ZA.11.DC2','ZA','ZA.11','Cape Winelands District Municipality','Cape Winelands District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44268,'ZA.02.DC25','ZA','ZA.02','Amajuba District Municipality','Amajuba District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44269,'ZA.09.DC35','ZA','ZA.09','Capricorn District Municipality','Capricorn District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44270,'ZA.10.DC37','ZA','ZA.10','Bojanala Platinum District Municipality','Bojanala Platinum District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44271,'ZA.10.DC39','ZA','ZA.10','Dr Ruth Segomotsi Mompati District Municipality','Dr Ruth Segomotsi Mompati District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44272,'ZA.11.DC4','ZA','ZA.11','Eden District Municipality','Eden District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44273,'ZA.10.DC40','ZA','ZA.10','Dr Kenneth Kaunda District Municipality','Dr Kenneth Kaunda District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44274,'ZA.05.DC44','ZA','ZA.05','Alfred Nzo District Municipality','Alfred Nzo District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44275,'ZA.11.DC5','ZA','ZA.11','Central Karoo District Municipality','Central Karoo District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44276,'ZA.06.EKU','ZA','ZA.06','Ekurhuleni Metropolitan Municipality','Ekurhuleni Metropolitan Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44277,'ZA.06.JHB','ZA','ZA.06','City of Johannesburg Metropolitan Municipality','City of Johannesburg Metropolitan Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44278,'ZA.06.TSH','ZA','ZA.06','City of Tshwane Metropolitan Municipality','City of Tshwane Metropolitan Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44279,'ZA.11.DC1','ZA','ZA.11','West Coast District Municipality','West Coast District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44280,'ZA.05.DC14','ZA','ZA.05','Joe Gqabi District Municipality','Joe Gqabi District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44281,'ZA.05.DC15','ZA','ZA.05','OR Tambo District Municipality','OR Tambo District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44282,'ZA.03.DC16','ZA','ZA.03','Xhariep District Municipality','Xhariep District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44283,'ZA.03.DC18','ZA','ZA.03','Lejweleputswa District Municipality','Lejweleputswa District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44284,'ZA.03.DC19','ZA','ZA.03','Thabo Mofutsanyana District Municipality','Thabo Mofutsanyana District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44285,'ZA.03.DC20','ZA','ZA.03','Fezile Dabi District Municipality','Fezile Dabi District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44286,'ZA.02.DC21','ZA','ZA.02','Ugu District Municipality','Ugu District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44287,'ZA.02.DC22','ZA','ZA.02','uMgungundlovu District Municipality','uMgungundlovu District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44288,'ZA.02.DC23','ZA','ZA.02','uThukela District Municipality','uThukela District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44289,'ZA.02.DC24','ZA','ZA.02','uMzinyathi District Municipality','uMzinyathi District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44290,'ZA.02.DC26','ZA','ZA.02','Zululand District Municipality','Zululand District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44291,'ZA.02.DC28','ZA','ZA.02','uThungulu District Municipality','uThungulu District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44292,'ZA.02.DC29','ZA','ZA.02','iLembe District Municipality','iLembe District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44293,'ZA.11.DC3','ZA','ZA.11','Overberg District Municipality','Overberg District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44294,'ZA.07.DC30','ZA','ZA.07','Gert Sibande District Municipality','Gert Sibande District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44295,'ZA.07.DC31','ZA','ZA.07','Nkangala District Municipality','Nkangala District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44296,'ZA.09.DC33','ZA','ZA.09','Mopani District Municipality','Mopani District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44297,'ZA.09.DC34','ZA','ZA.09','Vhembe District Municipality','Vhembe District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44298,'ZA.09.DC36','ZA','ZA.09','Waterberg District Municipality','Waterberg District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44299,'ZA.10.DC38','ZA','ZA.10','Ngaka Modiri Molema District Municipality','Ngaka Modiri Molema District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44300,'ZA.06.DC42','ZA','ZA.06','Sedibeng District Municipality','Sedibeng District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44301,'ZA.02.DC43','ZA','ZA.02','Sisonke District Municipality','Sisonke District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44302,'ZA.08.DC45','ZA','ZA.08','John Taolo Gaetsewe District Municipality','John Taolo Gaetsewe District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44303,'ZA.09.DC47','ZA','ZA.09','Sekhukhune District Municipality','Sekhukhune District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44304,'ZA.06.DC48','ZA','ZA.06','West Rand District Municipality','West Rand District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44305,'ZA.08.DC6','ZA','ZA.08','Namakwa District Municipality','Namakwa District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44306,'ZA.08.DC7','ZA','ZA.08','Pixley ka Seme District Municipality','Pixley ka Seme District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44307,'ZA.08.DC8','ZA','ZA.08','Siyanda District Municipality','Siyanda District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44308,'ZA.08.DC9','ZA','ZA.08','Frances Baard District Municipality','Frances Baard District Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44309,'ZA.03.MAN','ZA','ZA.03','Mangaung Metropolitan Municipality','Mangaung Metropolitan Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44310,'ZA.05.NMA','ZA','ZA.05','Nelson Mandela Bay Metropolitan Municipality','Nelson Mandela Bay Metropolitan Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44311,'ZA.02.DC27','ZA','ZA.02','uMkhanyakude District Municipality','uMkhanyakude District Municipality',1);

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

INSERT INTO `<<prefix>>cities` VALUES (936374,'ZA','Roodepoort','Roodepoort',-26.1625,27.8725,'P','PPL','ZA.06','ZA.06.JHB',225000,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (937136,'ZA','Zeerust','Zeerust',-25.5369,26.0751,'P','PPLA3','ZA.10','ZA.10.DC38',17708,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (937246,'ZA','Zastron','Zastron',-30.3022,27.084,'P','PPLA3','ZA.03','ZA.03.DC16',12449,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (938457,'ZA','Wolmaransstad','Wolmaransstad',-27.1974,25.9831,'P','PPLA3','ZA.10','ZA.10.DC40',49366,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (938694,'ZA','White River','White River',-25.3318,31.0117,'P','PPL','ZA.07','ZA.07.DC32',15954,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (939270,'ZA','Witbank','Witbank',-25.8713,29.2332,'P','PPLA3','ZA.07','ZA.07.DC31',262491,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (939608,'ZA','Winburg','Winburg',-28.518,27.0093,'P','PPL','ZA.03','ZA.03.DC18',11072,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (939676,'ZA','Willowmore','Willowmore',-33.2926,23.4895,'P','PPLA3','ZA.05','ZA.05.DC10',7100,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (940186,'ZA','Whittlesea','Whittlesea',-32.1759,26.8244,'P','PPL','ZA.05','ZA.05.DC13',12080,'Africa/Johannesburg',1,'2013-04-03 23:00:00','2013-04-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (940316,'ZA','Westonaria','Westonaria',-26.319,27.6486,'P','PPLA3','ZA.06','ZA.06.DC48',156831,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (940424,'ZA','Wesselsbron','Wesselsbron',-27.8549,26.3658,'P','PPL','ZA.03','ZA.03.DC18',42552,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (940909,'ZA','Welkom','Welkom',-27.9774,26.7351,'P','PPLA2','ZA.03','ZA.03.DC18',431944,'Africa/Johannesburg',1,'2013-11-02 23:00:00','2013-11-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (941931,'ZA','Warrenton','Warrenton',-28.114,24.8475,'P','PPLA3','ZA.08','ZA.08.DC9',17946,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (941966,'ZA','Warmbaths','Warmbaths',-24.8833,28.2833,'P','PPL','ZA.09','ZA.09.DC36',90210,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (942470,'ZA','Vryheid','Vryheid',-27.7695,30.7917,'P','PPLA3','ZA.02','ZA.02.DC26',150012,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (942511,'ZA','Vryburg','Vryburg',-26.9566,24.7284,'P','PPLA2','ZA.10','ZA.10.DC39',49588,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (942683,'ZA','Vredefort','Vredefort',-27.0081,27.3646,'P','PPL','ZA.03','ZA.03.DC20',10649,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (942701,'ZA','Vrede','Vrede',-27.4257,29.1658,'P','PPLA3','ZA.03','ZA.03.DC19',14622,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (943032,'ZA','Volksrust','Volksrust',-27.3654,29.8818,'P','PPLA3','ZA.07','ZA.07.DC30',43378,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (943882,'ZA','Virginia','Virginia',-28.1039,26.8659,'P','PPL','ZA.03','ZA.03.DC18',122502,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (943937,'ZA','Villiers','Villiers',-27.0303,28.6006,'P','PPL','ZA.03','ZA.03.DC20',11240,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (943960,'ZA','Viljoenskroon','Viljoenskroon',-27.2084,26.9485,'P','PPL','ZA.03','ZA.03.DC20',54955,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (944385,'ZA','Vereeniging','Vereeniging',-26.6731,27.9261,'P','PPLA2','ZA.06','ZA.06.DC42',474681,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (944540,'ZA','Ventersburg','Ventersburg',-28.0856,27.1381,'P','PPL','ZA.03','ZA.03.DC18',10698,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (944986,'ZA','Vanderbijlpark','Vanderbijlpark',-26.7117,27.8379,'P','PPLA3','ZA.06','ZA.06.DC42',246754,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (945945,'ZA','Upington','Upington',-28.4478,21.2561,'P','PPLA2','ZA.08','ZA.08.DC8',71373,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (946058,'ZA','Mthatha','Mthatha',-31.5889,28.7844,'P','PPL','ZA.05','ZA.05.DC15',78663,'Africa/Johannesburg',1,'2015-04-23 23:00:00','2015-04-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (946128,'ZA','Umkomaas','Umkomaas',-30.2067,30.7978,'P','PPL','ZA.02','ZA.02.ETH',20410,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (946257,'ZA','Ulundi','Ulundi',-28.3352,31.4162,'P','PPLA2','ZA.02','ZA.02.DC26',20753,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (946877,'ZA','Uitenhage','Uitenhage',-33.7576,25.3971,'P','PPL','ZA.05','ZA.05.NMA',228912,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (946973,'ZA','Tzaneen','Tzaneen',-23.8332,30.1635,'P','PPLA3','ZA.09','ZA.09.DC33',16954,'Africa/Johannesburg',1,'2013-11-02 23:00:00','2013-11-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (949026,'ZA','Thulamahashi','Thulamahashi',-24.7246,31.1994,'P','PPL','ZA.09',NULL,11655,'Africa/Johannesburg',1,'2011-04-18 23:00:00','2011-04-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (949224,'ZA','Thohoyandou','Thohoyandou',-22.9456,30.485,'P','PPLA2','ZA.09','ZA.09.DC34',44046,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (949282,'ZA','Theunissen','Theunissen',-28.411,26.7011,'P','PPLA3','ZA.03','ZA.03.DC18',34718,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (949683,'ZA','Thabazimbi','Thabazimbi',-24.5917,27.4116,'P','PPLA3','ZA.09','ZA.09.DC36',10365,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (949703,'ZA','Thaba Nchu','Thaba Nchu',-29.2093,26.839,'P','PPL','ZA.03','ZA.03.MAN',38616,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (949880,'ZA','Tembisa','Tembisa',-25.9964,28.2268,'P','PPL','ZA.06','ZA.06.EKU',511655,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (950709,'ZA','Swellendam','Swellendam',-34.0226,20.4417,'P','PPLA3','ZA.11','ZA.11.DC3',13674,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (951441,'ZA','Sundumbili','Sundumbili',-29.1337,31.3975,'P','PPL','ZA.02','ZA.02.DC29',12455,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (951650,'ZA','Stutterheim','Stutterheim',-32.5708,27.424,'P','PPLA3','ZA.05','ZA.05.DC12',35510,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (952192,'ZA','Stilfontein','Stilfontein',-26.8449,26.7683,'P','PPL','ZA.10','ZA.10.DC40',93110,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (952734,'ZA','Stanger','Stanger',-29.3282,31.2895,'P','PPL','ZA.02','ZA.02.DC29',59899,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (952747,'ZA','Standerton','Standerton',-26.9337,29.2415,'P','PPLA3','ZA.07','ZA.07.DC30',74021,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (952865,'ZA','Springs','Springs',-26.25,28.4,'P','PPLX','ZA.06','ZA.06.EKU',186394,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (953781,'ZA','Soweto','Soweto',-26.2678,27.8585,'P','PPL','ZA.06','ZA.06.JHB',1695047,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (954161,'ZA','Somerset East','Somerset East',-32.7217,25.588,'P','PPLA3','ZA.05','ZA.05.DC10',16155,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (955313,'ZA','Siyabuswa','Siyabuswa',-25.1132,29.0445,'P','PPLA3','ZA.07','ZA.07.DC31',26236,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (956507,'ZA','Senekal','Senekal',-28.3197,27.6208,'P','PPL','ZA.03','ZA.03.DC19',39584,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (956767,'ZA','Secunda','Secunda',-26.55,29.1667,'P','PPLA2','ZA.07','ZA.07.DC30',20418,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (956878,'ZA','Scottburgh','Scottburgh',-30.2867,30.7532,'P','PPLA3','ZA.02','ZA.02.DC21',23949,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (956907,'ZA','Schweizer-Reneke','Schweizer-Reneke',-27.1887,25.3293,'P','PPLA3','ZA.10','ZA.10.DC39',70214,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (957487,'ZA','Sasolburg','Sasolburg',-26.8136,27.8169,'P','PPLA2','ZA.03','ZA.03.DC20',77016,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (958724,'ZA','Rustenburg','Rustenburg',-25.6676,27.2421,'P','PPLA3','ZA.10','ZA.10.DC37',124064,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (961152,'ZA','Riversdale','Riversdale',-34.0934,21.2572,'P','PPLA3','ZA.11','ZA.11.DC4',16176,'Africa/Johannesburg',1,'2016-03-08 23:00:00','2016-03-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (961226,'ZA','Ritchie','Ritchie',-29.038,24.6028,'P','PPL','ZA.08','ZA.08.DC9',9960,'Africa/Johannesburg',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (962330,'ZA','Richmond','Richmond',-29.872,30.2724,'P','PPLA3','ZA.02','ZA.02.DC22',32445,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (962367,'ZA','Richards Bay','Richards Bay',-28.783,32.0377,'P','PPLA2','ZA.02','ZA.02.DC28',252968,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (962847,'ZA','Reitz','Reitz',-27.8014,28.4273,'P','PPLA3','ZA.03','ZA.03.DC19',16637,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (963230,'ZA','Randfontein','Randfontein',-26.1844,27.702,'P','PPLA2','ZA.06','ZA.06.DC48',133654,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (963241,'ZA','Randburg','Randburg',-26.0941,28.0012,'P','PPL','ZA.06','ZA.06.JHB',337053,'Africa/Johannesburg',1,'2017-12-05 23:00:00','2017-12-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (963516,'ZA','Queenstown','Queenstown',-31.8976,26.8753,'P','PPLA2','ZA.05','ZA.05.DC13',105309,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (963525,'ZA','Queensdale','Queensdale',-31.871,26.9786,'P','PPL','ZA.05','ZA.05.DC13',20009,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (964078,'ZA','Prince Albert','Prince Albert',-33.2248,22.0267,'P','PPLA3','ZA.11','ZA.11.DC5',13136,'Africa/Johannesburg',1,'2016-03-08 23:00:00','2016-03-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (964090,'ZA','Prieska','Prieska',-29.668,22.7425,'P','PPLA3','ZA.08','ZA.08.DC7',11236,'Africa/Johannesburg',1,'2014-11-07 23:00:00','2014-11-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (964137,'ZA','Pretoria','Pretoria',-25.7449,28.1878,'P','PPLC','ZA.06','ZA.06.TSH',1619438,'Africa/Johannesburg',1,'2016-07-16 23:00:00','2016-07-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (964315,'ZA','Mokopane','Mokopane',-24.1944,29.0097,'P','PPLA3','ZA.09','ZA.09.DC36',101090,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (964349,'ZA','Potchefstroom','Potchefstroom',-26.7167,27.1,'P','PPLA3','ZA.10','ZA.10.DC40',123669,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (964406,'ZA','Port Shepstone','Port Shepstone',-30.7414,30.455,'P','PPLA2','ZA.02','ZA.02.DC21',52793,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (964408,'ZA','Port Saint John’s','Port Saint John\'s',-31.6229,29.5448,'P','PPL','ZA.05','ZA.05.DC15',5939,'Africa/Johannesburg',1,'2017-07-08 23:00:00','2017-07-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (964420,'ZA','Port Elizabeth','Port Elizabeth',-33.9611,25.6149,'P','PPLA2','ZA.05','ZA.05.NMA',967677,'Africa/Johannesburg',1,'2018-01-07 23:00:00','2018-01-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (964432,'ZA','Port Alfred','Port Alfred',-33.586,26.8833,'P','PPLA3','ZA.05','ZA.05.DC10',17959,'Africa/Johannesburg',1,'2016-01-02 23:00:00','2016-01-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (964712,'ZA','Plettenberg Bay','Plettenberg Bay',-34.0527,23.3716,'P','PPLA3','ZA.11','ZA.11.DC4',19445,'Africa/Johannesburg',1,'2017-12-31 23:00:00','2017-12-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (965241,'ZA','Piet Retief','Piet Retief',-27.0071,30.8132,'P','PPLA3','ZA.07','ZA.07.DC30',84349,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (965289,'ZA','Polokwane','Polokwane',-23.9045,29.4688,'P','PPLA','ZA.09','ZA.09.DC35',123749,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (965301,'ZA','Pietermaritzburg','Pietermaritzburg',-29.6168,30.3928,'P','PPLA','ZA.02','ZA.02.DC22',750845,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (965401,'ZA','Phuthaditjhaba','Phuthaditjhaba',-28.5242,28.8158,'P','PPLA2','ZA.03','ZA.03.DC19',84258,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (965528,'ZA','Phalaborwa','Phalaborwa',-23.943,31.1411,'P','PPLA3','ZA.09','ZA.09.DC33',109468,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (966166,'ZA','Parys','Parys',-26.9033,27.4573,'P','PPLA3','ZA.03','ZA.03.DC20',71319,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (966380,'ZA','Pampierstad','Pampierstad',-27.7832,24.6877,'P','PPL','ZA.08','ZA.08.DC9',21800,'Africa/Johannesburg',1,'2016-07-17 23:00:00','2016-07-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (967106,'ZA','Oudtshoorn','Oudtshoorn',-33.6005,22.1996,'P','PPLA3','ZA.11','ZA.11.DC4',61507,'Africa/Johannesburg',1,'2016-03-08 23:00:00','2016-03-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (967476,'ZA','Orkney','Orkney',-26.9802,26.6727,'P','PPL','ZA.10','ZA.10.DC40',145801,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (967580,'ZA','Orange Farm','Orange Farm',-26.4833,27.8667,'P','PPLX','ZA.06','ZA.06.JHB',10000,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (968665,'ZA','Modimolle','Modimolle',-24.7,28.4,'P','PPLA2','ZA.09','ZA.09.DC36',20527,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (970341,'ZA','Nkowakowa','Nkowakowa',-23.8878,30.2871,'P','PPL','ZA.09','ZA.09.DC33',30138,'Africa/Johannesburg',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (970566,'ZA','Nigel','Nigel',-26.4314,28.4771,'P','PPL','ZA.06','ZA.06.EKU',140644,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (971421,'ZA','Newcastle','Newcastle',-27.758,29.9318,'P','PPLA2','ZA.02','ZA.02.DC25',404838,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (971534,'ZA','Nelspruit','Nelspruit',-25.4745,30.9703,'P','PPLA','ZA.07','ZA.07.DC32',110159,'Africa/Johannesburg',1,'2013-03-01 23:00:00','2013-03-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (973111,'ZA','Mpumalanga','Mpumalanga',-29.8129,30.6365,'P','PPL','ZA.02','ZA.02.ETH',140121,'Africa/Johannesburg',1,'2013-04-03 23:00:00','2013-04-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (973139,'ZA','Mpophomeni','Mpophomeni',-29.5682,30.1862,'P','PPL','ZA.02','ZA.02.DC22',26229,'Africa/Johannesburg',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (973709,'ZA','Mossel Bay','Mossel Bay',-34.1831,22.146,'P','PPLA3','ZA.11','ZA.11.DC4',59031,'Africa/Johannesburg',1,'2016-03-08 23:00:00','2016-03-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (974222,'ZA','Mooirivier','Mooirivier',-29.2082,29.9946,'P','PPL','ZA.02','ZA.02.DC22',10132,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (974611,'ZA','Montagu','Montagu',-33.7866,20.1211,'P','PPL','ZA.11','ZA.11.DC2',15176,'Africa/Johannesburg',1,'2017-12-12 23:00:00','2017-12-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (974670,'ZA','Mondlo','Mondlo',-27.983,30.7177,'P','PPL','ZA.02','ZA.02.DC26',44922,'Africa/Johannesburg',1,'2013-04-03 23:00:00','2013-04-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (974719,'ZA','Molteno','Molteno',-31.3967,26.3625,'P','PPLA3','ZA.05','ZA.05.DC13',10078,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (975436,'ZA','Mmabatho','Mmabatho',-25.85,25.6333,'P','PPLX','ZA.10','ZA.10.DC38',76754,'Africa/Johannesburg',1,'2018-01-13 23:00:00','2018-01-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (976358,'ZA','Middelburg','Middelburg',-31.4928,25.0063,'P','PPL','ZA.05','ZA.05.DC13',18164,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (976361,'ZA','Middelburg','Middelburg',-25.7751,29.4648,'P','PPLA2','ZA.07','ZA.07.DC31',154706,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (978677,'ZA','Marquard','Marquard',-28.6645,27.4305,'P','PPL','ZA.03','ZA.03.DC19',10839,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (978895,'ZA','Margate','Margate',-30.8636,30.3705,'P','PPL','ZA.02','ZA.02.DC21',34407,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (979365,'ZA','Mankoeng','Mankoeng',-23.9,29.8167,'P','PPL','ZA.09','ZA.09.DC35',12499,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (980595,'ZA','Mahikeng','Mahikeng',-25.8652,25.6442,'P','PPLA','ZA.10','ZA.10.DC38',14000,'Africa/Johannesburg',1,'2013-06-03 23:00:00','2013-06-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (980921,'ZA','Mabopane','Mabopane',-25.4977,28.1007,'P','PPL','ZA.06','ZA.06.TSH',97417,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (981158,'ZA','Lydenburg','Lydenburg',-25.096,30.4439,'P','PPLA3','ZA.07','ZA.07.DC32',21695,'Africa/Johannesburg',1,'2014-11-07 23:00:00','2014-11-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (981827,'ZA','Louis Trichardt','Louis Trichardt',-23.0438,29.9032,'P','PPLA3','ZA.09','ZA.09.DC34',86854,'Africa/Johannesburg',1,'2013-11-02 23:00:00','2013-11-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (982701,'ZA','Lindley','Lindley',-27.8791,27.9135,'P','PPL','ZA.03','ZA.03.DC19',12000,'Africa/Johannesburg',1,'2018-01-01 23:00:00','2018-01-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (982899,'ZA','Lichtenburg','Lichtenburg',-26.152,26.1597,'P','PPLA3','ZA.10','ZA.10.DC38',65863,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (984087,'ZA','Lebowakgomo','Lebowakgomo',-24.2,29.5,'P','PPL','ZA.09','ZA.09.DC35',33308,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (985011,'ZA','Lady Frere','Lady Frere',-31.7031,27.2329,'P','PPLA3','ZA.05','ZA.05.DC13',25041,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (985015,'ZA','Ladybrand','Ladybrand',-29.1945,27.4574,'P','PPLA3','ZA.03','ZA.03.DC19',17228,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (985020,'ZA','Ladismith','Ladismith',-33.4933,21.2675,'P','PPLA3','ZA.11','ZA.11.DC4',7127,'Africa/Johannesburg',1,'2016-03-08 23:00:00','2016-03-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (986083,'ZA','Kutloanong','Kutloanong',-27.8333,26.75,'P','PPL','ZA.03','ZA.03.DC18',95008,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (986134,'ZA','Kuruman','Kuruman',-27.4524,23.4325,'P','PPLA2','ZA.08','ZA.08.DC45',9093,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (986717,'ZA','Kruisfontein','Kruisfontein',-34.0033,24.7314,'P','PPL','ZA.05','ZA.05.DC10',18991,'Africa/Johannesburg',1,'2016-03-09 23:00:00','2016-03-09 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (986822,'ZA','Krugersdorp','Krugersdorp',-26.0858,27.7752,'P','PPLA3','ZA.06','ZA.06.DC48',378821,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (986846,'ZA','Kroonstad','Kroonstad',-27.6504,27.2349,'P','PPLA3','ZA.03','ZA.03.DC20',103992,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (987202,'ZA','Kriel','Kriel',-26.2739,29.2253,'P','PPL','ZA.07','ZA.07.DC31',15055,'Africa/Johannesburg',1,'2016-03-09 23:00:00','2016-03-09 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (987648,'ZA','Koster','Koster',-25.863,26.8976,'P','PPLA3','ZA.10','ZA.10.DC37',12126,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (987875,'ZA','Koppies','Koppies',-27.2418,27.5742,'P','PPL','ZA.03','ZA.03.DC20',11445,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (988290,'ZA','Komatipoort','Komatipoort',-25.4332,31.9548,'P','PPL','ZA.07','ZA.07.DC32',20508,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (988356,'ZA','Kokstad','Kokstad',-30.5472,29.4241,'P','PPLA3','ZA.02','ZA.02.DC43',25373,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (988698,'ZA','Knysna','Knysna',-34.0363,23.0471,'P','PPLA3','ZA.11','ZA.11.DC4',68659,'Africa/Johannesburg',1,'2016-03-08 23:00:00','2016-03-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (989921,'ZA','Klerksdorp','Klerksdorp',-26.8521,26.6667,'P','PPLA2','ZA.10','ZA.10.DC40',178921,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (990802,'ZA','Kirkwood','Kirkwood',-33.3983,25.4428,'P','PPLA3','ZA.05','ZA.05.DC10',10148,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (990930,'ZA','Kimberley','Kimberley',-28.7323,24.7623,'P','PPLA','ZA.08','ZA.08.DC9',142089,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (991664,'ZA','Kathu','Kathu',-27.6957,23.0493,'P','PPLA3','ZA.08','ZA.08.DC45',9219,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (993800,'ZA','Johannesburg','Johannesburg',-26.2023,28.0436,'P','PPLA','ZA.06','ZA.06.JHB',2026469,'Africa/Johannesburg',1,'2015-06-02 23:00:00','2015-06-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (993911,'ZA','Jeffrey’s Bay','Jeffrey\'s Bay',-34.0504,24.9077,'P','PPL','ZA.05','ZA.05.DC10',11698,'Africa/Johannesburg',1,'2015-12-13 23:00:00','2015-12-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (994023,'ZA','Jan Kempdorp','Jan Kempdorp',-27.9225,24.8305,'P','PPL','ZA.10',NULL,13485,'Africa/Johannesburg',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (994939,'ZA','Ilinge','Ilinge',-31.9768,27.0427,'P','PPL','ZA.05','ZA.05.DC13',10899,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (995202,'ZA','Howick','Howick',-29.4779,30.2306,'P','PPLA3','ZA.02','ZA.02.DC22',28725,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (995573,'ZA','Hoopstad','Hoopstad',-27.8327,25.9083,'P','PPL','ZA.03','ZA.03.DC18',12663,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (996918,'ZA','Hennenman','Hennenman',-27.9765,27.0242,'P','PPL','ZA.03','ZA.03.DC18',22847,'Africa/Johannesburg',1,'2012-07-10 23:00:00','2012-07-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (996930,'ZA','Hendrina','Hendrina',-26.1588,29.7153,'P','PPL','ZA.07','ZA.07.DC31',15871,'Africa/Johannesburg',1,'2013-04-03 23:00:00','2013-04-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (997140,'ZA','Heilbron','Heilbron',-27.2812,27.9709,'P','PPL','ZA.03','ZA.03.DC20',55196,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (997151,'ZA','Heidelberg','Heidelberg',-26.5048,28.3592,'P','PPLA3','ZA.06','ZA.06.DC42',64199,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (997751,'ZA','Harrismith','Harrismith',-28.2728,29.1295,'P','PPL','ZA.03','ZA.03.DC19',35108,'Africa/Johannesburg',1,'2013-11-02 23:00:00','2013-11-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1000006,'ZA','Greytown','Greytown',-29.0641,30.5928,'P','PPLA3','ZA.02','ZA.02.DC24',13912,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1000501,'ZA','Grahamstown','Grahamstown',-33.3042,26.5328,'P','PPLA3','ZA.05','ZA.05.DC10',91548,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1000543,'ZA','Graaff-Reinet','Graaff-Reinet',-32.2522,24.5308,'P','PPLA3','ZA.05','ZA.05.DC10',62896,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1001736,'ZA','Glencoe','Glencoe',-28.1783,30.147,'P','PPL','ZA.02','ZA.02.DC24',13547,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1001860,'ZA','Giyani','Giyani',-23.3025,30.7187,'P','PPLA2','ZA.09','ZA.09.DC33',37024,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1002145,'ZA','George','George',-33.963,22.4617,'P','PPLA2','ZA.11','ZA.11.DC4',12345,'Africa/Johannesburg',1,'2016-03-08 23:00:00','2016-03-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1002851,'ZA','Ga-Rankuwa','Ga-Rankuwa',-25.6169,27.9947,'P','PPL','ZA.10',NULL,68767,'Africa/Johannesburg',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1003462,'ZA','Ga-Kgapane','Ga-Kgapane',-23.6438,30.2232,'P','PPL','ZA.09','ZA.09.DC33',13000,'Africa/Johannesburg',1,'2013-03-05 23:00:00','2013-03-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1003953,'ZA','Fort Beaufort','Fort Beaufort',-32.7748,26.6338,'P','PPLA3','ZA.05','ZA.05.DC12',58419,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1004109,'ZA','Fochville','Fochville',-26.4886,27.4939,'P','PPL','ZA.10',NULL,62416,'Africa/Johannesburg',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1005029,'ZA','eSikhawini','eSikhawini',-28.871,31.8996,'P','PPL','ZA.02','ZA.02.DC28',49265,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1005040,'ZA','Eshowe','Eshowe',-28.8865,31.4699,'P','PPLA3','ZA.02','ZA.02.DC28',14786,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1005125,'ZA','Ermelo','Ermelo',-26.5333,29.9833,'P','PPLA3','ZA.07','ZA.07.DC30',41124,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1005544,'ZA','Empangeni','Empangeni',-28.762,31.8933,'P','PPL','ZA.02','ZA.02.DC28',28093,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1005646,'ZA','eMbalenhle','eMbalenhle',-26.5333,29.0667,'P','PPL','ZA.07','ZA.07.DC30',141741,'Africa/Johannesburg',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1005781,'ZA','Elliot','Elliot',-31.3333,27.85,'P','PPL','ZA.05','ZA.05.DC13',11836,'Africa/Johannesburg',1,'2013-04-03 23:00:00','2013-04-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1006420,'ZA','Ekuvukeni','Ekuvukeni',-28.4675,30.1551,'P','PPL','ZA.02','ZA.02.DC23',14331,'Africa/Johannesburg',1,'2013-04-03 23:00:00','2013-04-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1006834,'ZA','Edenvale','Edenvale',-26.1409,28.1525,'P','PPL','ZA.06','ZA.06.EKU',49292,'Africa/Johannesburg',1,'2017-01-11 23:00:00','2017-01-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1006984,'ZA','East London','East London',-33.0153,27.9116,'P','PPLA2','ZA.05','ZA.05.BUF',478676,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1007311,'ZA','Durban','Durban',-29.8579,31.0292,'P','PPLA2','ZA.02','ZA.02.ETH',3120282,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1007400,'ZA','Dundee','Dundee',-28.1668,30.2337,'P','PPLA2','ZA.02','ZA.02.DC24',84413,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1007514,'ZA','Duiwelskloof','Duiwelskloof',-23.6934,30.14,'P','PPL','ZA.09','ZA.09.DC33',24572,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1008261,'ZA','Driefontein','Driefontein',-27.0177,30.4498,'P','PPL','ZA.07','ZA.07.DC30',28127,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1008858,'ZA','Dordrecht','Dordrecht',-31.372,27.0488,'P','PPL','ZA.05','ZA.05.DC13',9123,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1010962,'ZA','Deneysville','Deneysville',-26.8908,28.0971,'P','PPL','ZA.03','ZA.03.DC20',12397,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1011031,'ZA','Delmas','Delmas',-26.1466,28.6832,'P','PPLA3','ZA.07','ZA.07.DC31',92046,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1011632,'ZA','De Aar','De Aar',-30.6497,24.0123,'P','PPLA2','ZA.08','ZA.08.DC7',32318,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1011918,'ZA','Daniëlskuil','Danielskuil',-28.1887,23.5395,'P','PPL','ZA.08','ZA.08.DC8',10123,'Africa/Johannesburg',1,'2013-04-03 23:00:00','2013-04-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1012413,'ZA','Cullinan','Cullinan',-25.6709,28.5236,'P','PPL','ZA.06','ZA.06.TSH',25490,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1012600,'ZA','Cradock','Cradock',-32.1642,25.6192,'P','PPLA3','ZA.05','ZA.05.DC13',32898,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1013076,'ZA','Colesberg','Colesberg',-30.72,25.0972,'P','PPLA3','ZA.08','ZA.08.DC7',12423,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1013266,'ZA','Clocolan','Clocolan',-28.9137,27.5655,'P','PPL','ZA.03','ZA.03.DC19',12318,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1013550,'ZA','Christiana','Christiana',-27.914,25.1611,'P','PPLA3','ZA.10','ZA.10.DC39',17523,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1014034,'ZA','Carnarvon','Carnarvon',-30.9683,22.133,'P','PPLA3','ZA.08','ZA.08.DC7',5785,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1014073,'ZA','Carletonville','Carletonville',-26.3609,27.3977,'P','PPLA3','ZA.06','ZA.06.DC48',182304,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1014489,'ZA','Butterworth','Butterworth',-32.3308,28.1498,'P','PPL','ZA.05','ZA.05.DC12',34353,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1014653,'ZA','Burgersdorp','Burgersdorp',-30.9977,26.3286,'P','PPLA3','ZA.05','ZA.05.DC14',12548,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1015504,'ZA','Bronkhorstspruit','Bronkhorstspruit',-25.8102,28.7425,'P','PPL','ZA.06','ZA.06.TSH',27343,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1015621,'ZA','Brits','Brits',-25.6347,27.7802,'P','PPLA3','ZA.10','ZA.10.DC37',122497,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1015694,'ZA','Breyten','Breyten',-26.3018,29.987,'P','PPL','ZA.07','ZA.07.DC30',12550,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1015776,'ZA','Bredasdorp','Bredasdorp',-34.5322,20.0403,'P','PPLA2','ZA.11','ZA.11.DC3',14936,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1015969,'ZA','Brandfort','Brandfort',-28.7001,26.4597,'P','PPL','ZA.03','ZA.03.DC18',12091,'Africa/Johannesburg',1,'2012-07-10 23:00:00','2012-07-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1016181,'ZA','Brakpan','Brakpan',-26.2366,28.3694,'P','PPL','ZA.06','ZA.06.EKU',305692,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1016670,'ZA','Botshabelo','Botshabelo',-29.2674,26.726,'P','PPL','ZA.03','ZA.03.MAN',309714,'Africa/Johannesburg',1,'2016-08-03 23:00:00','2016-08-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1016698,'ZA','Bothaville','Bothaville',-27.3887,26.617,'P','PPLA3','ZA.03','ZA.03.DC18',71934,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1017780,'ZA','Boksburg','Boksburg',-26.212,28.2596,'P','PPL','ZA.06','ZA.06.EKU',445168,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1018673,'ZA','Bloemhof','Bloemhof',-27.6469,25.607,'P','PPL','ZA.10','ZA.10.DC39',17122,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1018725,'ZA','Bloemfontein','Bloemfontein',-29.1211,26.214,'P','PPLA','ZA.03','ZA.03.MAN',463064,'Africa/Johannesburg',1,'2016-08-05 23:00:00','2016-08-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1019330,'ZA','Bhisho','Bhisho',-32.8472,27.4422,'P','PPLA','ZA.05','ZA.05.BUF',137287,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1019704,'ZA','Bethlehem','Bethlehem',-28.2308,28.3071,'P','PPLA3','ZA.03','ZA.03.DC19',83654,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1019760,'ZA','Bethal','Bethal',-26.4579,29.4655,'P','PPL','ZA.07','ZA.07.DC30',101919,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1020066,'ZA','Berea','Berea',-29.8519,30.9934,'P','PPL','ZA.02','ZA.02.ETH',15000,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1020098,'ZA','Benoni','Benoni',-26.1885,28.3208,'P','PPL','ZA.06','ZA.06.EKU',605344,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1020340,'ZA','Belfast','Belfast',-25.6899,30.035,'P','PPLA3','ZA.07','ZA.07.DC31',11916,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1020641,'ZA','Beaufort West','Beaufort West',-32.3567,22.583,'P','PPLA2','ZA.11','ZA.11.DC5',44737,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1021040,'ZA','Barkly West','Barkly West',-28.5354,24.5215,'P','PPLA3','ZA.08','ZA.08.DC9',11621,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1021086,'ZA','Barberton','Barberton',-25.7884,31.0532,'P','PPLA3','ZA.07','ZA.07.DC32',67927,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1021360,'ZA','Ballito','Ballito',-29.539,31.2144,'P','PPL','ZA.02','ZA.02.DC29',17218,'Africa/Johannesburg',1,'2017-01-12 23:00:00','2017-01-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1021396,'ZA','Balfour','Balfour',-26.6633,28.5902,'P','PPLA3','ZA.07','ZA.07.DC30',46008,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1023287,'ZA','Allanridge','Allanridge',-27.7543,26.6438,'P','PPL','ZA.03','ZA.03.DC18',31700,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1023309,'ZA','Aliwal North','Aliwal North',-30.6937,26.7114,'P','PPLA3','ZA.05','ZA.05.DC14',44436,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1023332,'ZA','Alice','Alice',-32.7875,26.8344,'P','PPL','ZA.05','ZA.05.DC12',9788,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1023441,'ZA','Alberton','Alberton',-26.2679,28.1222,'P','PPL','ZA.06','ZA.06.EKU',121536,'Africa/Johannesburg',1,'2017-12-05 23:00:00','2017-12-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1023445,'ZA','Albertina','Albertina',-34.2054,21.58,'P','PPL','ZA.11','ZA.11.DC4',6372,'Africa/Johannesburg',1,'2016-03-08 23:00:00','2016-03-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1023656,'ZA','Adelaide','Adelaide',-32.7075,26.2956,'P','PPLA3','ZA.05','ZA.05.DC12',12212,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1105726,'ZA','Ekangala','Ekangala',-25.6962,28.7492,'P','PPL','ZA.06','ZA.06.TSH',37650,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1105776,'ZA','Midrand','Midrand',-25.9895,28.1284,'P','PPL','ZA.06','ZA.06.JHB',173009,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1105777,'ZA','Centurion','Centurion',-25.8589,28.1858,'P','PPL','ZA.06','ZA.06.TSH',233386,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3359041,'ZA','Worcester','Worcester',-33.6465,19.4485,'P','PPLA2','ZA.11','ZA.11.DC2',127597,'Africa/Johannesburg',1,'2013-03-03 23:00:00','2013-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3359510,'ZA','Wellington','Wellington',-33.6398,19.0112,'P','PPL','ZA.11','ZA.11.DC2',55543,'Africa/Johannesburg',1,'2017-01-17 23:00:00','2017-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3359736,'ZA','Vredendal','Vredendal',-31.6683,18.5012,'P','PPLA3','ZA.11','ZA.11.DC1',14806,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3361025,'ZA','Stellenbosch','Stellenbosch',-33.9346,18.8668,'P','PPLA3','ZA.11','ZA.11.DC2',94263,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3361142,'ZA','Springbok','Springbok',-29.6643,17.8865,'P','PPLA2','ZA.08','ZA.08.DC6',10438,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3361934,'ZA','Saldanha','Saldanha',-33.0117,17.9442,'P','PPL','ZA.11','ZA.11.DC1',68284,'Africa/Johannesburg',1,'2017-01-26 23:00:00','2017-01-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3362024,'ZA','Rosebank','Rosebank',-33.9556,18.4742,'P','PPL','ZA.11','ZA.11.CPT',10000,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3362349,'ZA','Robertson','Robertson',-33.8034,19.8854,'P','PPL','ZA.11','ZA.11.DC2',27715,'Africa/Johannesburg',1,'2017-01-17 23:00:00','2017-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3363094,'ZA','Paarl','Paarl',-33.7338,18.9752,'P','PPLA3','ZA.11','ZA.11.DC2',190000,'Africa/Johannesburg',1,'2015-04-25 23:00:00','2015-04-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3364346,'ZA','Malmesbury','Malmesbury',-33.4608,18.7271,'P','PPLA3','ZA.11','ZA.11.DC1',34991,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3364682,'ZA','Lansdowne','Lansdowne',-33.9874,18.4975,'P','PPLX','ZA.11','ZA.11.CPT',17399,'Africa/Johannesburg',1,'2013-09-06 23:00:00','2013-09-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3365083,'ZA','Kraaifontein','Kraaifontein',-33.8481,18.7172,'P','PPL','ZA.11','ZA.11.CPT',57911,'Africa/Johannesburg',1,'2013-08-17 23:00:00','2013-08-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3366880,'ZA','Hermanus','Hermanus',-34.4187,19.2345,'P','PPLA3','ZA.11','ZA.11.DC3',25153,'Africa/Johannesburg',1,'2013-03-03 23:00:00','2013-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3367513,'ZA','Grabouw','Grabouw',-34.1515,19.0151,'P','PPL','ZA.11','ZA.11.DC3',29885,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3369056,'ZA','Constantia','Constantia',-34.0314,18.4183,'P','PPL','ZA.11','ZA.11.CPT',6922,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3369098,'ZA','Claremont','Claremont',-33.9806,18.4653,'P','PPL','ZA.11','ZA.11.CPT',14531,'Africa/Johannesburg',1,'2013-03-14 23:00:00','2013-03-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3369129,'ZA','Ceres','Ceres',-33.3689,19.3109,'P','PPLA3','ZA.11','ZA.11.DC2',41596,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3369157,'ZA','Cape Town','Cape Town',-33.9258,18.4232,'P','PPLA','ZA.11','ZA.11.CPT',3433441,'Africa/Johannesburg',1,'2016-08-05 23:00:00','2016-08-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3369174,'ZA','Calvinia','Calvinia',-31.4707,19.776,'P','PPLA3','ZA.08','ZA.08.DC6',8146,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3370352,'ZA','Atlantis','Atlantis',-33.5667,18.4834,'P','PPL','ZA.11','ZA.11.CPT',60266,'Africa/Johannesburg',1,'2012-07-11 23:00:00','2012-07-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7302797,'ZA','Eden Glen','Eden Glen',-26.1323,28.1686,'P','PPLX','ZA.06','ZA.06.EKU',7345,'Africa/Johannesburg',1,'2017-01-11 23:00:00','2017-01-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7302802,'ZA','Rondebosch','Rondebosch',-33.9633,18.4764,'P','PPL','ZA.11','ZA.11.CPT',15158,'Africa/Johannesburg',1,'2013-08-17 23:00:00','2013-08-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7506857,'ZA','Newlands','Newlands',-33.9785,18.4481,'P','PPL','ZA.11','ZA.11.CPT',5343,'Africa/Johannesburg',1,'2013-08-17 23:00:00','2013-08-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8030233,'ZA','Midstream','Midstream',-25.9185,28.1988,'P','PPL','ZA.06','ZA.06.EKU',25000,'Africa/Johannesburg',1,'2016-06-13 23:00:00','2016-06-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8604596,'ZA','Retreat','Retreat',-34.0551,18.4762,'P','PPL','ZA.11','ZA.11.CPT',32289,'Africa/Johannesburg',1,'2013-08-17 23:00:00','2013-08-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8764562,'ZA','Diepsloot','Diepsloot',-25.9331,28.0121,'P','PPLX','ZA.06','ZA.06.JHB',350000,'Africa/Johannesburg',1,'2014-04-07 23:00:00','2014-04-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (10295373,'ZA','Hardys Memories of Africa','Hardys Memories of Africa',-33.9054,20.7169,'P','PPLS','ZA.11','ZA.11.DC3',7500,'Africa/Johannesburg',1,'2015-05-30 23:00:00','2015-05-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (11204670,'ZA','Eastleigh','Eastleigh',-26.1297,28.1554,'P','PPLX','ZA.06','ZA.06.EKU',6988,'Africa/Johannesburg',1,'2017-01-11 23:00:00','2017-01-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (11205175,'ZA','Riverlea','Riverlea',-26.2119,27.9732,'P','PPLG','ZA.06','ZA.06.JHB',0,'Africa/Johannesburg',1,'2016-07-27 23:00:00','2016-07-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (11427405,'ZA','Eden Glen Ext 60','Eden Glen Ext 60',-26.1259,28.165,'P','PPLX','ZA.06','ZA.06.EKU',5494,'Africa/Johannesburg',1,'2017-01-11 23:00:00','2017-01-11 23:00:00');


