REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug, s_phone_code, s_name_native, s_currency) VALUES 
('ZA', 'South Africa', 'south-africa', '27', 'South Africa', 'ZAR');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000938, 'ZA', 'Eastern Cape', 1, 'eastern-cape');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1131015, 1000938, 'ZA', 'Adelaide', 1, 'adelaide', -32.70747000, 26.29564000),
(1131018, 1000938, 'ZA', 'Alfred Nzo District Municipality', 1, 'alfred-nzo-district-municipality', -30.66803000, 29.15490000),
(1131019, 1000938, 'ZA', 'Alice', 1, 'alice', -32.78749000, 26.83440000),
(1131020, 1000938, 'ZA', 'Aliwal North', 1, 'aliwal-north', -30.69366000, 26.71141000),
(1131023, 1000938, 'ZA', 'Amathole District Municipality', 1, 'amathole-district-municipality', -32.55895000, 27.45919000),
(1131037, 1000938, 'ZA', 'Bhisho', 1, 'bhisho', -32.84721000, 27.44218000),
(1131052, 1000938, 'ZA', 'Buffalo City Metropolitan Municipality', 1, 'buffalo-city-metropolitan-municipality', -32.95141000, 27.61164000),
(1131053, 1000938, 'ZA', 'Burgersdorp', 1, 'burgersdorp', -30.99766000, 26.32862000),
(1131054, 1000938, 'ZA', 'Butterworth', 1, 'butterworth', -32.33083000, 28.14981000),
(1131055, 1000938, 'ZA', 'Cacadu District Municipality', 1, 'cacadu-district-municipality', -33.06583000, 24.77583000),
(1131068, 1000938, 'ZA', 'Chris Hani District Municipality', 1, 'chris-hani-district-municipality', -31.79033000, 26.43965000),
(1131078, 1000938, 'ZA', 'Cradock', 1, 'cradock', -32.16422000, 25.61918000),
(1131086, 1000938, 'ZA', 'Dordrecht', 1, 'dordrecht', -31.37200000, 27.04878000),
(1131093, 1000938, 'ZA', 'East London', 1, 'east-london', -33.01529000, 27.91162000),
(1131103, 1000938, 'ZA', 'Elliot', 1, 'elliot', -31.33333000, 27.85000000),
(1131109, 1000938, 'ZA', 'Fort Beaufort', 1, 'fort-beaufort', -32.77477000, 26.63376000),
(1131119, 1000938, 'ZA', 'Graaff-Reinet', 1, 'graaff-reinet', -32.25215000, 24.53075000),
(1131121, 1000938, 'ZA', 'Grahamstown', 1, 'grahamstown', -33.30422000, 26.53276000),
(1131133, 1000938, 'ZA', 'Ilinge', 1, 'ilinge', -31.97676000, 27.04267000),
(1131135, 1000938, 'ZA', 'Joe Gqabi District Municipality', 1, 'joe-gqabi-district-municipality', -30.94178000, 27.06053000),
(1131141, 1000938, 'ZA', 'Kirkwood', 1, 'kirkwood', -33.39829000, 25.44279000),
(1131152, 1000938, 'ZA', 'Kruisfontein', 1, 'kruisfontein', -34.00333000, 24.73142000),
(1131157, 1000938, 'ZA', 'Lady Frere', 1, 'lady-frere', -31.70312000, 27.23290000),
(1131174, 1000938, 'ZA', 'Middelburg', 1, 'middelburg', -31.49285000, 25.00633000),
(1131182, 1000938, 'ZA', 'Molteno', 1, 'molteno', -31.39675000, 26.36246000),
(1131191, 1000938, 'ZA', 'Mthatha', 1, 'mthatha', -31.58893000, 28.78443000),
(1131197, 1000938, 'ZA', 'Nelson Mandela Bay Metropolitan Municipality', 1, 'nelson-mandela-bay-metropolitan-municipality', -33.80399000, 25.49213000),
(1131206, 1000938, 'ZA', 'OR Tambo District Municipality', 1, 'or-tambo-district-municipality', -31.46740000, 29.05247000),
(1131224, 1000938, 'ZA', 'Port Alfred', 1, 'port-alfred', -33.58601000, 26.88329000),
(1131225, 1000938, 'ZA', 'Port Elizabeth', 1, 'port-elizabeth', -33.96109000, 25.61494000),
(1131226, 1000938, 'ZA', 'Port Saint John’s', 1, 'port-saint-john-s', -31.62291000, 29.54477000),
(1131233, 1000938, 'ZA', 'Queensdale', 1, 'queensdale', -31.87101000, 26.97862000),
(1131234, 1000938, 'ZA', 'Queenstown', 1, 'queenstown', -31.89756000, 26.87533000),
(1131259, 1000938, 'ZA', 'Somerset East', 1, 'somerset-east', -32.72173000, 25.58804000),
(1131266, 1000938, 'ZA', 'Stutterheim', 1, 'stutterheim', -32.57076000, 27.42396000),
(1131279, 1000938, 'ZA', 'Uitenhage', 1, 'uitenhage', -33.75757000, 25.39710000),
(1131308, 1000938, 'ZA', 'Whittlesea', 1, 'whittlesea', -32.17588000, 26.82437000),
(1131309, 1000938, 'ZA', 'Willowmore', 1, 'willowmore', -33.29265000, 23.48954000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000932, 'ZA', 'Free State', 1, 'free-state');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1131021, 1000932, 'ZA', 'Allanridge', 1, 'allanridge', -27.75431000, 26.64382000),
(1131036, 1000932, 'ZA', 'Bethlehem', 1, 'bethlehem', -28.23078000, 28.30707000),
(1131038, 1000932, 'ZA', 'Bloemfontein', 1, 'bloemfontein', -29.12107000, 26.21400000),
(1131043, 1000932, 'ZA', 'Bothaville', 1, 'bothaville', -27.38870000, 26.61701000),
(1131044, 1000932, 'ZA', 'Botshabelo', 1, 'botshabelo', -29.26737000, 26.72595000),
(1131046, 1000932, 'ZA', 'Brandfort', 1, 'brandfort', -28.70008000, 26.45968000),
(1131075, 1000932, 'ZA', 'Clocolan', 1, 'clocolan', -28.91367000, 27.56555000),
(1131084, 1000932, 'ZA', 'Deneysville', 1, 'deneysville', -26.89080000, 28.09707000),
(1131107, 1000932, 'ZA', 'Fezile Dabi District Municipality', 1, 'fezile-dabi-district-municipality', -27.33918000, 27.71927000),
(1131111, 1000932, 'ZA', 'Frankfort', 1, 'frankfort', -27.27888000, 28.49696000),
(1131124, 1000932, 'ZA', 'Harrismith', 1, 'harrismith', -28.27276000, 29.12946000),
(1131126, 1000932, 'ZA', 'Heilbron', 1, 'heilbron', -27.28115000, 27.97090000),
(1131128, 1000932, 'ZA', 'Hennenman', 1, 'hennenman', -27.97654000, 27.02423000),
(1131131, 1000932, 'ZA', 'Hoopstad', 1, 'hoopstad', -27.83273000, 25.90833000),
(1131146, 1000932, 'ZA', 'Koppies', 1, 'koppies', -27.24179000, 27.57422000),
(1131150, 1000932, 'ZA', 'Kroonstad', 1, 'kroonstad', -27.65036000, 27.23488000),
(1131154, 1000932, 'ZA', 'Kutloanong', 1, 'kutloanong', -27.83333000, 26.75000000),
(1131158, 1000932, 'ZA', 'Ladybrand', 1, 'ladybrand', -29.19448000, 27.45739000),
(1131161, 1000932, 'ZA', 'Lejweleputswa District Municipality', 1, 'lejweleputswa-district-municipality', -28.23982000, 26.12649000),
(1131163, 1000932, 'ZA', 'Lindley', 1, 'lindley', -27.87910000, 27.91348000),
(1131170, 1000932, 'ZA', 'Mangaung Metropolitan Municipality', 1, 'mangaung-metropolitan-municipality', -29.15627000, 26.35116000),
(1131173, 1000932, 'ZA', 'Marquard', 1, 'marquard', -28.66449000, 27.43048000),
(1131214, 1000932, 'ZA', 'Parys', 1, 'parys', -26.90330000, 27.45727000),
(1131216, 1000932, 'ZA', 'Phuthaditjhaba', 1, 'phuthaditjhaba', -28.52423000, 28.81582000),
(1131237, 1000932, 'ZA', 'Reitz', 1, 'reitz', -27.80138000, 28.42726000),
(1131249, 1000932, 'ZA', 'Sasolburg', 1, 'sasolburg', -26.81358000, 27.81695000),
(1131255, 1000932, 'ZA', 'Senekal', 1, 'senekal', -28.31971000, 27.62082000),
(1131271, 1000932, 'ZA', 'Thaba Nchu', 1, 'thaba-nchu', -29.20932000, 26.83898000),
(1131273, 1000932, 'ZA', 'Thabo Mofutsanyana District Municipality', 1, 'thabo-mofutsanyana-district-municipality', -28.24378000, 28.34077000),
(1131274, 1000932, 'ZA', 'Theunissen', 1, 'theunissen', -28.41098000, 26.70107000),
(1131285, 1000932, 'ZA', 'Ventersburg', 1, 'ventersburg', -28.08561000, 27.13814000),
(1131288, 1000932, 'ZA', 'Viljoenskroon', 1, 'viljoenskroon', -27.20841000, 26.94855000),
(1131289, 1000932, 'ZA', 'Villiers', 1, 'villiers', -27.03026000, 28.60061000),
(1131290, 1000932, 'ZA', 'Virginia', 1, 'virginia', -28.10391000, 26.86593000),
(1131292, 1000932, 'ZA', 'Vrede', 1, 'vrede', -27.42573000, 29.16585000),
(1131293, 1000932, 'ZA', 'Vredefort', 1, 'vredefort', -27.00805000, 27.36460000),
(1131301, 1000932, 'ZA', 'Welkom', 1, 'welkom', -27.97742000, 26.73506000),
(1131303, 1000932, 'ZA', 'Wesselsbron', 1, 'wesselsbron', -27.85490000, 26.36583000),
(1131310, 1000932, 'ZA', 'Winburg', 1, 'winburg', -28.51805000, 27.00933000),
(1131314, 1000932, 'ZA', 'Xhariep District Municipality', 1, 'xhariep-district-municipality', -29.84311000, 25.83286000),
(1131315, 1000932, 'ZA', 'Zastron', 1, 'zastron', -30.30225000, 27.08395000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000936, 'ZA', 'Gauteng', 1, 'gauteng');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1131017, 1000936, 'ZA', 'Alberton', 1, 'alberton', -26.26786000, 28.12225000),
(1131032, 1000936, 'ZA', 'Benoni', 1, 'benoni', -26.18848000, 28.32078000),
(1131042, 1000936, 'ZA', 'Boksburg', 1, 'boksburg', -26.21197000, 28.25958000),
(1131045, 1000936, 'ZA', 'Brakpan', 1, 'brakpan', -26.23656000, 28.36938000),
(1131051, 1000936, 'ZA', 'Bronkhorstspruit', 1, 'bronkhorstspruit', -25.81015000, 28.74248000),
(1131062, 1000936, 'ZA', 'Carletonville', 1, 'carletonville', -26.36094000, 27.39767000),
(1131066, 1000936, 'ZA', 'Centurion', 1, 'centurion', -25.85891000, 28.18577000),
(1131071, 1000936, 'ZA', 'City of Johannesburg Metropolitan Municipality', 1, 'city-of-johannesburg-metropolitan-municipality', -26.17673000, 27.96353000),
(1131072, 1000936, 'ZA', 'City of Tshwane Metropolitan Municipality', 1, 'city-of-tshwane-metropolitan-municipality', -25.65985000, 28.44343000),
(1131079, 1000936, 'ZA', 'Cullinan', 1, 'cullinan', -25.67088000, 28.52364000),
(1131085, 1000936, 'ZA', 'Diepsloot', 1, 'diepsloot', -25.93312000, 28.01213000),
(1131094, 1000936, 'ZA', 'Eastleigh', 1, 'eastleigh', -26.12965000, 28.15541000),
(1131096, 1000936, 'ZA', 'Eden Glen', 1, 'eden-glen', -26.13230000, 28.16859000),
(1131097, 1000936, 'ZA', 'Eden Glen Ext 60', 1, 'eden-glen-ext-60', -26.12593000, 28.16500000),
(1131098, 1000936, 'ZA', 'Edenvale', 1, 'edenvale', -26.14095000, 28.15247000),
(1131100, 1000936, 'ZA', 'Ekangala', 1, 'ekangala', -25.69619000, 28.74918000),
(1131101, 1000936, 'ZA', 'Ekurhuleni Metropolitan Municipality', 1, 'ekurhuleni-metropolitan-municipality', -26.19890000, 28.31262000),
(1131125, 1000936, 'ZA', 'Heidelberg', 1, 'heidelberg', -26.50476000, 28.35921000),
(1131136, 1000936, 'ZA', 'Johannesburg', 1, 'johannesburg', -26.20227000, 28.04363000),
(1131151, 1000936, 'ZA', 'Krugersdorp', 1, 'krugersdorp', -26.08577000, 27.77515000),
(1131166, 1000936, 'ZA', 'Mabopane', 1, 'mabopane', -25.49768000, 28.10065000),
(1131176, 1000936, 'ZA', 'Midrand', 1, 'midrand', -25.98953000, 28.12843000),
(1131177, 1000936, 'ZA', 'Midstream', 1, 'midstream', -25.91849000, 28.19881000),
(1131179, 1000936, 'ZA', 'Modderfontein', 1, 'modderfontein', -26.08909000, 28.16534000),
(1131193, 1000936, 'ZA', 'Muldersdriseloop', 1, 'muldersdriseloop', -26.03673000, 27.83798000),
(1131202, 1000936, 'ZA', 'Nigel', 1, 'nigel', -26.43138000, 28.47713000),
(1131207, 1000936, 'ZA', 'Orange Farm', 1, 'orange-farm', -26.48333000, 27.86667000),
(1131230, 1000936, 'ZA', 'Pretoria', 1, 'pretoria', -25.74486000, 28.18783000),
(1131235, 1000936, 'ZA', 'Randburg', 1, 'randburg', -26.09410000, 28.00123000),
(1131236, 1000936, 'ZA', 'Randfontein', 1, 'randfontein', -26.18440000, 27.70203000),
(1131245, 1000936, 'ZA', 'Roodepoort', 1, 'roodepoort', -26.16250000, 27.87250000),
(1131253, 1000936, 'ZA', 'Sedibeng District Municipality', 1, 'sedibeng-district-municipality', -26.56686000, 28.18277000),
(1131260, 1000936, 'ZA', 'Soweto', 1, 'soweto', -26.26781000, 27.85849000),
(1131262, 1000936, 'ZA', 'Springs', 1, 'springs', -26.25000000, 28.40000000),
(1131270, 1000936, 'ZA', 'Tembisa', 1, 'tembisa', -25.99636000, 28.22680000),
(1131284, 1000936, 'ZA', 'Vanderbijlpark', 1, 'vanderbijlpark', -26.71171000, 27.83795000),
(1131286, 1000936, 'ZA', 'Vereeniging', 1, 'vereeniging', -26.67313000, 27.92615000),
(1131305, 1000936, 'ZA', 'West Rand District Municipality', 1, 'west-rand-district-municipality', -26.24565000, 27.55538000),
(1131306, 1000936, 'ZA', 'Westonaria', 1, 'westonaria', -26.31905000, 27.64860000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000935, 'ZA', 'KwaZulu-Natal', 1, 'kwazulu-natal');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1131022, 1000935, 'ZA', 'Amajuba District Municipality', 1, 'amajuba-district-municipality', -27.73558000, 30.13537000),
(1131027, 1000935, 'ZA', 'Ballito', 1, 'ballito', -29.53897000, 31.21439000),
(1131033, 1000935, 'ZA', 'Berea', 1, 'berea', -29.85185000, 30.99337000),
(1131091, 1000935, 'ZA', 'Dundee', 1, 'dundee', -28.16678000, 30.23371000),
(1131092, 1000935, 'ZA', 'Durban', 1, 'durban', -29.85790000, 31.02920000),
(1131102, 1000935, 'ZA', 'Ekuvukeni', 1, 'ekuvukeni', -28.46752000, 30.15513000),
(1131320, 1000935, 'ZA', 'eMkhomazi', 1, 'emkhomazi', -30.20674000, 30.79776000),
(1131104, 1000935, 'ZA', 'Empangeni', 1, 'empangeni', -28.76197000, 31.89329000),
(1131106, 1000935, 'ZA', 'Eshowe', 1, 'eshowe', -28.88649000, 31.46990000),
(1131321, 1000935, 'ZA', 'eSikhaleni', 1, 'esikhaleni', -28.87097000, 31.89961000),
(1131322, 1000935, 'ZA', 'eThekwini Metropolitan Municipality', 1, 'ethekwini-metropolitan-municipality', -29.86670000, 31.01670000),
(1131118, 1000935, 'ZA', 'Glencoe', 1, 'glencoe', -28.17827000, 30.14702000),
(1131122, 1000935, 'ZA', 'Greytown', 1, 'greytown', -29.06415000, 30.59279000),
(1131130, 1000935, 'ZA', 'Hluhluwe', 1, 'hluhluwe', -28.01895000, 32.26762000),
(1131132, 1000935, 'ZA', 'Howick', 1, 'howick', -29.47795000, 30.23057000),
(1131323, 1000935, 'ZA', 'iLembe District Municipality', 1, 'ilembe-district-municipality', -29.27326000, 31.14253000),
(1131144, 1000935, 'ZA', 'Kokstad', 1, 'kokstad', -30.54723000, 29.42412000),
(1131155, 1000935, 'ZA', 'KwaDukuza', 1, 'kwadukuza', -29.32816000, 31.28954000),
(1131172, 1000935, 'ZA', 'Margate', 1, 'margate', -30.86360000, 30.37052000),
(1131183, 1000935, 'ZA', 'Mondlo', 1, 'mondlo', -27.98299000, 30.71769000),
(1131185, 1000935, 'ZA', 'Mooirivier', 1, 'mooirivier', -29.20824000, 29.99460000),
(1131189, 1000935, 'ZA', 'Mpophomeni', 1, 'mpophomeni', -29.56822000, 30.18618000),
(1131190, 1000935, 'ZA', 'Mpumalanga', 1, 'mpumalanga', -29.81292000, 30.63646000),
(1131192, 1000935, 'ZA', 'Mtubatuba', 1, 'mtubatuba', -28.41789000, 32.18483000),
(1131196, 1000935, 'ZA', 'Ndwedwe', 1, 'ndwedwe', -29.51686000, 30.92687000),
(1131199, 1000935, 'ZA', 'Newcastle', 1, 'newcastle', -27.75796000, 29.93180000),
(1131218, 1000935, 'ZA', 'Pietermaritzburg', 1, 'pietermaritzburg', -29.61679000, 30.39278000),
(1131227, 1000935, 'ZA', 'Port Shepstone', 1, 'port-shepstone', -30.74137000, 30.45499000),
(1131239, 1000935, 'ZA', 'Richards Bay', 1, 'richards-bay', -28.78301000, 32.03768000),
(1131240, 1000935, 'ZA', 'Richmond', 1, 'richmond', -29.87196000, 30.27235000),
(1131251, 1000935, 'ZA', 'Scottburgh', 1, 'scottburgh', -30.28666000, 30.75316000),
(1131256, 1000935, 'ZA', 'Sisonke District Municipality', 1, 'sisonke-district-municipality', -30.11082000, 29.66009000),
(1131267, 1000935, 'ZA', 'Sundumbili', 1, 'sundumbili', -29.13371000, 31.39752000),
(1131278, 1000935, 'ZA', 'Ugu District Municipality', 1, 'ugu-district-municipality', -30.54365000, 30.27480000),
(1131280, 1000935, 'ZA', 'Ulundi', 1, 'ulundi', -28.33523000, 31.41617000),
(1131324, 1000935, 'ZA', 'uMgungundlovu District Municipality', 1, 'umgungundlovu-district-municipality', -29.50927000, 30.19838000),
(1131325, 1000935, 'ZA', 'uMkhanyakude District Municipality', 1, 'umkhanyakude-district-municipality', -27.62236000, 32.32945000),
(1131326, 1000935, 'ZA', 'uMzinyathi District Municipality', 1, 'umzinyathi-district-municipality', -28.58570000, 30.55883000),
(1131327, 1000935, 'ZA', 'uThukela District Municipality', 1, 'uthukela-district-municipality', -28.71920000, 29.65799000),
(1131328, 1000935, 'ZA', 'uThungulu District Municipality', 1, 'uthungulu-district-municipality', -28.70046000, 31.51527000),
(1131282, 1000935, 'ZA', 'Utrecht', 1, 'utrecht', -27.65862000, 30.32166000),
(1131297, 1000935, 'ZA', 'Vryheid', 1, 'vryheid', -27.76952000, 30.79165000),
(1131318, 1000935, 'ZA', 'Zululand District Municipality', 1, 'zululand-district-municipality', -27.81139000, 31.29426000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000933, 'ZA', 'Limpopo', 1, 'limpopo');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1131040, 1000933, 'ZA', 'Bochum', 1, 'bochum', -23.28609000, 29.13964000),
(1131061, 1000933, 'ZA', 'Capricorn District Municipality', 1, 'capricorn-district-municipality', -23.48163000, 29.18350000),
(1131090, 1000933, 'ZA', 'Duiwelskloof', 1, 'duiwelskloof', -23.69339000, 30.14002000),
(1131113, 1000933, 'ZA', 'Ga-Kgapane', 1, 'ga-kgapane', -23.64378000, 30.22324000),
(1131117, 1000933, 'ZA', 'Giyani', 1, 'giyani', -23.30246000, 30.71868000),
(1131160, 1000933, 'ZA', 'Lebowakgomo', 1, 'lebowakgomo', -24.20000000, 29.50000000),
(1131164, 1000933, 'ZA', 'Louis Trichardt', 1, 'louis-trichardt', -23.04385000, 29.90319000),
(1131171, 1000933, 'ZA', 'Mankoeng', 1, 'mankoeng', -23.90000000, 29.81667000),
(1131180, 1000933, 'ZA', 'Modimolle', 1, 'modimolle', -24.70000000, 28.40000000),
(1131181, 1000933, 'ZA', 'Mokopane', 1, 'mokopane', -24.19436000, 29.00974000),
(1131187, 1000933, 'ZA', 'Mopani District Municipality', 1, 'mopani-district-municipality', -23.76661000, 30.83600000),
(1131194, 1000933, 'ZA', 'Musina', 1, 'musina', -22.34881000, 30.04074000),
(1131204, 1000933, 'ZA', 'Nkowakowa', 1, 'nkowakowa', -23.88782000, 30.28708000),
(1131215, 1000933, 'ZA', 'Phalaborwa', 1, 'phalaborwa', -23.94299000, 31.14107000),
(1131223, 1000933, 'ZA', 'Polokwane', 1, 'polokwane', -23.90449000, 29.46885000),
(1131254, 1000933, 'ZA', 'Sekhukhune District Municipality', 1, 'sekhukhune-district-municipality', -24.82806000, 29.83803000),
(1131272, 1000933, 'ZA', 'Thabazimbi', 1, 'thabazimbi', -24.59165000, 27.41155000),
(1131275, 1000933, 'ZA', 'Thohoyandou', 1, 'thohoyandou', -22.94564000, 30.48497000),
(1131276, 1000933, 'ZA', 'Thulamahashi', 1, 'thulamahashi', -24.72459000, 31.19939000),
(1131277, 1000933, 'ZA', 'Tzaneen', 1, 'tzaneen', -23.83322000, 30.16351000),
(1131287, 1000933, 'ZA', 'Vhembe District Municipality', 1, 'vhembe-district-municipality', -22.75467000, 30.19360000),
(1131298, 1000933, 'ZA', 'Warmbaths', 1, 'warmbaths', -24.88333000, 28.28333000),
(1131300, 1000933, 'ZA', 'Waterberg District Municipality', 1, 'waterberg-district-municipality', -24.20514000, 27.97870000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000937, 'ZA', 'Mpumalanga', 1, 'mpumalanga');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1131026, 1000937, 'ZA', 'Balfour', 1, 'balfour', -26.66331000, 28.59016000),
(1131028, 1000937, 'ZA', 'Barberton', 1, 'barberton', -25.78842000, 31.05319000),
(1131031, 1000937, 'ZA', 'Belfast', 1, 'belfast', -25.68991000, 30.03504000),
(1131035, 1000937, 'ZA', 'Bethal', 1, 'bethal', -26.45794000, 29.46553000),
(1131049, 1000937, 'ZA', 'Breyten', 1, 'breyten', -26.30176000, 29.98696000),
(1131064, 1000937, 'ZA', 'Carolina', 1, 'carolina', -26.06927000, 30.11489000),
(1131083, 1000937, 'ZA', 'Delmas', 1, 'delmas', -26.14660000, 28.68322000),
(1131089, 1000937, 'ZA', 'Driefontein', 1, 'driefontein', -27.01770000, 30.44979000),
(1131099, 1000937, 'ZA', 'Ehlanzeni District', 1, 'ehlanzeni-district', -25.35100000, 31.36100000),
(1131319, 1000937, 'ZA', 'eMbalenhle', 1, 'embalenhle', -26.53333000, 29.06667000),
(1131105, 1000937, 'ZA', 'Ermelo', 1, 'ermelo', -26.53333000, 29.98333000),
(1131116, 1000937, 'ZA', 'Gert Sibande District Municipality', 1, 'gert-sibande-district-municipality', -26.67100000, 29.92953000),
(1131127, 1000937, 'ZA', 'Hendrina', 1, 'hendrina', -26.15881000, 29.71528000),
(1131145, 1000937, 'ZA', 'Komatipoort', 1, 'komatipoort', -25.43321000, 31.95478000),
(1131149, 1000937, 'ZA', 'Kriel', 1, 'kriel', -26.27391000, 29.22530000),
(1131165, 1000937, 'ZA', 'Lydenburg', 1, 'lydenburg', -25.09598000, 30.44393000),
(1131175, 1000937, 'ZA', 'Middelburg', 1, 'middelburg', -25.77507000, 29.46482000),
(1131198, 1000937, 'ZA', 'Nelspruit', 1, 'nelspruit', -25.47448000, 30.97033000),
(1131203, 1000937, 'ZA', 'Nkangala District Municipality', 1, 'nkangala-district-municipality', -25.71222000, 29.42431000),
(1131217, 1000937, 'ZA', 'Piet Retief', 1, 'piet-retief', -27.00706000, 30.81323000),
(1131252, 1000937, 'ZA', 'Secunda', 1, 'secunda', -26.55000000, 29.16667000),
(1131257, 1000937, 'ZA', 'Siyabuswa', 1, 'siyabuswa', -25.11319000, 29.04454000),
(1131263, 1000937, 'ZA', 'Standerton', 1, 'standerton', -26.93366000, 29.24152000),
(1131291, 1000937, 'ZA', 'Volksrust', 1, 'volksrust', -27.36541000, 29.88175000),
(1131307, 1000937, 'ZA', 'White River', 1, 'white-river', -25.33177000, 31.01166000),
(1131311, 1000937, 'ZA', 'Witbank', 1, 'witbank', -25.87133000, 29.23323000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000934, 'ZA', 'North West', 1, 'north-west');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1131039, 1000934, 'ZA', 'Bloemhof', 1, 'bloemhof', -27.64685000, 25.60697000),
(1131041, 1000934, 'ZA', 'Bojanala Platinum District Municipality', 1, 'bojanala-platinum-district-municipality', -25.42612000, 27.22430000),
(1131050, 1000934, 'ZA', 'Brits', 1, 'brits', -25.63473000, 27.78022000),
(1131069, 1000934, 'ZA', 'Christiana', 1, 'christiana', -27.91402000, 25.16111000),
(1131087, 1000934, 'ZA', 'Dr Kenneth Kaunda District Municipality', 1, 'dr-kenneth-kaunda-district-municipality', -26.80678000, 26.56926000),
(1131088, 1000934, 'ZA', 'Dr Ruth Segomotsi Mompati District Municipality', 1, 'dr-ruth-segomotsi-mompati-district-municipality', -26.63765000, 24.27462000),
(1131108, 1000934, 'ZA', 'Fochville', 1, 'fochville', -26.48862000, 27.49387000),
(1131114, 1000934, 'ZA', 'Ga-Rankuwa', 1, 'ga-rankuwa', -25.61692000, 27.99471000),
(1131134, 1000934, 'ZA', 'Jan Kempdorp', 1, 'jan-kempdorp', -27.92246000, 24.83051000),
(1131142, 1000934, 'ZA', 'Klerksdorp', 1, 'klerksdorp', -26.85213000, 26.66672000),
(1131147, 1000934, 'ZA', 'Koster', 1, 'koster', -25.86301000, 26.89756000),
(1131162, 1000934, 'ZA', 'Lichtenburg', 1, 'lichtenburg', -26.15200000, 26.15968000),
(1131167, 1000934, 'ZA', 'Mahikeng', 1, 'mahikeng', -25.86522000, 25.64421000),
(1131168, 1000934, 'ZA', 'Maile', 1, 'maile', -25.44152000, 27.28165000),
(1131178, 1000934, 'ZA', 'Mmabatho', 1, 'mmabatho', -25.85000000, 25.63333000),
(1131201, 1000934, 'ZA', 'Ngaka Modiri Molema District Municipality', 1, 'ngaka-modiri-molema-district-municipality', -25.95559000, 25.80782000),
(1131209, 1000934, 'ZA', 'Orkney', 1, 'orkney', -26.98023000, 26.67272000),
(1131229, 1000934, 'ZA', 'Potchefstroom', 1, 'potchefstroom', -26.71667000, 27.10000000),
(1131247, 1000934, 'ZA', 'Rustenburg', 1, 'rustenburg', -25.66756000, 27.24208000),
(1131250, 1000934, 'ZA', 'Schweizer-Reneke', 1, 'schweizer-reneke', -27.18871000, 25.32931000),
(1131265, 1000934, 'ZA', 'Stilfontein', 1, 'stilfontein', -26.84493000, 26.76829000),
(1131296, 1000934, 'ZA', 'Vryburg', 1, 'vryburg', -26.95659000, 24.72840000),
(1131312, 1000934, 'ZA', 'Wolmaransstad', 1, 'wolmaransstad', -27.19740000, 25.98311000),
(1131316, 1000934, 'ZA', 'Zeerust', 1, 'zeerust', -25.53695000, 26.07512000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000931, 'ZA', 'Northern Cape', 1, 'northern-cape');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1131029, 1000931, 'ZA', 'Barkly West', 1, 'barkly-west', -28.53537000, 24.52151000),
(1131047, 1000931, 'ZA', 'Brandvlei', 1, 'brandvlei', -30.46532000, 20.48659000),
(1131058, 1000931, 'ZA', 'Calvinia', 1, 'calvinia', -31.47069000, 19.77601000),
(1131063, 1000931, 'ZA', 'Carnarvon', 1, 'carnarvon', -30.96827000, 22.13303000),
(1131076, 1000931, 'ZA', 'Colesberg', 1, 'colesberg', -30.71999000, 25.09718000),
(1131080, 1000931, 'ZA', 'Daniëlskuil', 1, 'danielskuil', -28.18873000, 23.53951000),
(1131081, 1000931, 'ZA', 'De Aar', 1, 'de-aar', -30.64966000, 24.01230000),
(1131110, 1000931, 'ZA', 'Frances Baard District Municipality', 1, 'frances-baard-district-municipality', -28.30003000, 24.38188000),
(1131112, 1000931, 'ZA', 'Fraserburg', 1, 'fraserburg', -31.91566000, 21.51335000),
(1131137, 1000931, 'ZA', 'John Taolo Gaetsewe District Municipality', 1, 'john-taolo-gaetsewe-district-municipality', -27.04549000, 23.04706000),
(1131138, 1000931, 'ZA', 'Kathu', 1, 'kathu', -27.69569000, 23.04929000),
(1131139, 1000931, 'ZA', 'Kenhardt', 1, 'kenhardt', -29.34574000, 21.15786000),
(1131140, 1000931, 'ZA', 'Kimberley', 1, 'kimberley', -28.73226000, 24.76232000),
(1131153, 1000931, 'ZA', 'Kuruman', 1, 'kuruman', -27.45240000, 23.43246000),
(1131195, 1000931, 'ZA', 'Namakwa District Municipality', 1, 'namakwa-district-municipality', -30.53561000, 19.42892000),
(1131205, 1000931, 'ZA', 'Noupoort', 1, 'noupoort', -31.18736000, 24.94991000),
(1131208, 1000931, 'ZA', 'Orania', 1, 'orania', -29.81381000, 24.41205000),
(1131213, 1000931, 'ZA', 'Pampierstad', 1, 'pampierstad', -27.78324000, 24.68768000),
(1131220, 1000931, 'ZA', 'Pixley ka Seme District Municipality', 1, 'pixley-ka-seme-district-municipality', -30.28920000, 23.25818000),
(1131222, 1000931, 'ZA', 'Pofadder', 1, 'pofadder', -29.12830000, 19.39492000),
(1131228, 1000931, 'ZA', 'Postmasburg', 1, 'postmasburg', -28.33392000, 23.06541000),
(1131231, 1000931, 'ZA', 'Prieska', 1, 'prieska', -29.66803000, 22.74251000),
(1131241, 1000931, 'ZA', 'Ritchie', 1, 'ritchie', -29.03801000, 24.60278000),
(1131258, 1000931, 'ZA', 'Siyanda District Municipality', 1, 'siyanda-district-municipality', -28.00013000, 21.18459000),
(1131261, 1000931, 'ZA', 'Springbok', 1, 'springbok', -29.66434000, 17.88650000),
(1131281, 1000931, 'ZA', 'Upington', 1, 'upington', -28.44776000, 21.25612000),
(1131283, 1000931, 'ZA', 'Van Wyksvlei', 1, 'van-wyksvlei', -30.35101000, 21.82498000),
(1131299, 1000931, 'ZA', 'Warrenton', 1, 'warrenton', -28.11396000, 24.84753000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000939, 'ZA', 'Western Cape', 1, 'western-cape');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1131016, 1000939, 'ZA', 'Albertina', 1, 'albertina', -34.20544000, 21.58001000),
(1131024, 1000939, 'ZA', 'Arniston', 1, 'arniston', -34.66739000, 20.23086000),
(1131025, 1000939, 'ZA', 'Atlantis', 1, 'atlantis', -33.56668000, 18.48335000),
(1131030, 1000939, 'ZA', 'Beaufort West', 1, 'beaufort-west', -32.35671000, 22.58295000),
(1131034, 1000939, 'ZA', 'Bergvliet', 1, 'bergvliet', -34.04746000, 18.45250000),
(1131048, 1000939, 'ZA', 'Bredasdorp', 1, 'bredasdorp', -34.53215000, 20.04031000),
(1131056, 1000939, 'ZA', 'Caledon', 1, 'caledon', -34.22997000, 19.42650000),
(1131057, 1000939, 'ZA', 'Calitzdorp', 1, 'calitzdorp', -33.52755000, 21.67620000),
(1131059, 1000939, 'ZA', 'Cape Town', 1, 'cape-town', -33.92584000, 18.42322000),
(1131060, 1000939, 'ZA', 'Cape Winelands District Municipality', 1, 'cape-winelands-district-municipality', -33.32249000, 19.68998000),
(1131065, 1000939, 'ZA', 'Central Karoo District Municipality', 1, 'central-karoo-district-municipality', -32.62812000, 22.21192000),
(1131067, 1000939, 'ZA', 'Ceres', 1, 'ceres', -33.36889000, 19.31095000),
(1131070, 1000939, 'ZA', 'City of Cape Town', 1, 'city-of-cape-town', -33.91667000, 18.41667000),
(1131073, 1000939, 'ZA', 'Clanwilliam', 1, 'clanwilliam', -32.18173000, 18.89217000),
(1131074, 1000939, 'ZA', 'Claremont', 1, 'claremont', -33.98056000, 18.46528000),
(1131077, 1000939, 'ZA', 'Constantia', 1, 'constantia', -34.03139000, 18.41833000),
(1131082, 1000939, 'ZA', 'De Rust', 1, 'de-rust', -33.49035000, 22.53523000),
(1131095, 1000939, 'ZA', 'Eden District Municipality', 1, 'eden-district-municipality', -33.82139000, 22.01263000),
(1131115, 1000939, 'ZA', 'George', 1, 'george', -33.96300000, 22.46173000),
(1131120, 1000939, 'ZA', 'Grabouw', 1, 'grabouw', -34.15152000, 19.01509000),
(1131123, 1000939, 'ZA', 'Hardys Memories of Africa', 1, 'hardys-memories-of-africa', -33.90539000, 20.71690000),
(1131129, 1000939, 'ZA', 'Hermanus', 1, 'hermanus', -34.41870000, 19.23446000),
(1131143, 1000939, 'ZA', 'Knysna', 1, 'knysna', -34.03627000, 23.04713000),
(1131148, 1000939, 'ZA', 'Kraaifontein', 1, 'kraaifontein', -33.84808000, 18.71723000),
(1131156, 1000939, 'ZA', 'Ladismith', 1, 'ladismith', -33.49331000, 21.26755000),
(1131159, 1000939, 'ZA', 'Lansdowne', 1, 'lansdowne', -33.98735000, 18.49746000),
(1131169, 1000939, 'ZA', 'Malmesbury', 1, 'malmesbury', -33.46080000, 18.72714000),
(1131184, 1000939, 'ZA', 'Montagu', 1, 'montagu', -33.78664000, 20.12106000),
(1131186, 1000939, 'ZA', 'Moorreesburg', 1, 'moorreesburg', -33.15388000, 18.66031000),
(1131188, 1000939, 'ZA', 'Mossel Bay', 1, 'mossel-bay', -34.18307000, 22.14605000),
(1131200, 1000939, 'ZA', 'Newlands', 1, 'newlands', -33.97846000, 18.44810000),
(1131210, 1000939, 'ZA', 'Oudtshoorn', 1, 'oudtshoorn', -33.60047000, 22.19955000),
(1131211, 1000939, 'ZA', 'Overberg District Municipality', 1, 'overberg-district-municipality', -34.26131000, 19.93985000),
(1131212, 1000939, 'ZA', 'Paarl', 1, 'paarl', -33.73378000, 18.97523000),
(1131219, 1000939, 'ZA', 'Piketberg', 1, 'piketberg', -32.90323000, 18.75704000),
(1131221, 1000939, 'ZA', 'Plettenberg Bay', 1, 'plettenberg-bay', -34.05274000, 23.37160000),
(1131232, 1000939, 'ZA', 'Prince Albert', 1, 'prince-albert', -33.22476000, 22.02673000),
(1131238, 1000939, 'ZA', 'Retreat', 1, 'retreat', -34.05515000, 18.47617000),
(1131242, 1000939, 'ZA', 'Riversdale', 1, 'riversdale', -34.09345000, 21.25725000),
(1131243, 1000939, 'ZA', 'Robertson', 1, 'robertson', -33.80342000, 19.88537000),
(1131244, 1000939, 'ZA', 'Rondebosch', 1, 'rondebosch', -33.96333000, 18.47639000),
(1131246, 1000939, 'ZA', 'Rosebank', 1, 'rosebank', -33.95556000, 18.47417000),
(1131248, 1000939, 'ZA', 'Saldanha', 1, 'saldanha', -33.01167000, 17.94420000),
(1131264, 1000939, 'ZA', 'Stellenbosch', 1, 'stellenbosch', -33.93462000, 18.86676000),
(1131268, 1000939, 'ZA', 'Sunset Beach', 1, 'sunset-beach', -33.85395000, 18.49231000),
(1131269, 1000939, 'ZA', 'Swellendam', 1, 'swellendam', -34.02262000, 20.44171000),
(1131294, 1000939, 'ZA', 'Vredenburg', 1, 'vredenburg', -32.90719000, 17.98997000),
(1131295, 1000939, 'ZA', 'Vredendal', 1, 'vredendal', -31.66833000, 18.50119000),
(1131302, 1000939, 'ZA', 'Wellington', 1, 'wellington', -33.63981000, 19.01120000),
(1131304, 1000939, 'ZA', 'West Coast District Municipality', 1, 'west-coast-district-municipality', -32.09506000, 18.62695000),
(1131313, 1000939, 'ZA', 'Worcester', 1, 'worcester', -33.64651000, 19.44852000),
(1131317, 1000939, 'ZA', 'Zoar', 1, 'zoar', -33.49560000, 21.44373000);

