REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('BW', 'Botswana', 'Botswana', 'botswana', '267', 'BWP');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(3933043, 'BW', 'Ngwaketsi', 1, 'ngwaketsi'),
(3933044, 'BW', 'South-East', 1, 'south-east'),
(3933210, 'BW', 'North-East', 1, 'north-east'),
(3933230, 'BW', 'North-West', 1, 'north-west'),
(3933562, 'BW', 'Kweneng', 1, 'kweneng'),
(3933654, 'BW', 'Kgatleng', 1, 'kgatleng'),
(3933657, 'BW', 'Kgalagadi', 1, 'kgalagadi'),
(3933758, 'BW', 'Ghanzi', 1, 'ghanzi'),
(3933840, 'BW', 'Chobe', 1, 'chobe'),
(3933851, 'BW', 'Central', 1, 'central'),
(14778168, 'BW', 'City of Francistown', 1, 'city-of-francistown'),
(14778169, 'BW', 'Gaborone', 1, 'gaborone'),
(14778170, 'BW', 'Jwaneng', 1, 'jwaneng'),
(14778171, 'BW', 'Lobatse', 1, 'lobatse'),
(14778172, 'BW', 'Selibe Phikwe', 1, 'selibe-phikwe'),
(14778173, 'BW', 'Sowa Town', 1, 'sowa-town');

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 
(3932947, 3933758, 'BW', 'Zuwe', 1, 'zuwe', -23.05, 24.83333),
(3932960, 3933657, 'BW', 'Werda', 1, 'werda', -25.26667, 23.28333),
(3932963, 3933043, 'BW', 'Vlei', 1, 'vlei', -25.13333, 25.46667),
(3932976, 3933851, 'BW', 'Tsipi', 1, 'tsipi', -21.8, 25.88333),
(3932977, 3933851, 'BW', 'Tshimoyapula', 1, 'tshimoyapula', -22.1151, 26.92685),
(3932979, 3933851, 'BW', 'Tsigara', 1, 'tsigara', -20.33333, 25.81667),
(3932980, 3933758, 'BW', 'Tshwane', 1, 'tshwane', -22.4, 22.05),
(3932981, 3933851, 'BW', 'Tshoroga', 1, 'tshoroga', -20.35, 25.16667),
(3932983, 3933851, 'BW', 'Tshapatain', 1, 'tshapatain', -20.36667, 25.15),
(3932984, 3933657, 'BW', 'Tshane', 1, 'tshane', -24.03333, 21.9),
(3932987, 3933657, 'BW', 'Tshabong', 1, 'tshabong', -26.05, 22.45),
(3932993, 3933230, 'BW', 'Tsau', 1, 'tsau', -20.16458, 22.45573),
(3932996, 3933043, 'BW', 'Totoru', 1, 'totoru', -25.65, 25.01667),
(3932999, 3933851, 'BW', 'Toping', 1, 'toping', -21.93333, 28.1),
(3933000, 3933851, 'BW', 'Tonota', 1, 'tonota', -21.44236, 27.46153),
(3933001, 3933043, 'BW', 'Tobgat', 1, 'tobgat', -24.76667, 25.65),
(3933002, 3933851, 'BW', 'Tobane', 1, 'tobane', -21.95, 27.9),
(3933003, 3933851, 'BW', 'Tloupye', 1, 'tloupye', -22.35, 27.65),
(3933004, 3933044, 'BW', 'Tlokweng', 1, 'tlokweng', -24.66861, 25.97111),
(3933007, 3933043, 'BW', 'Tlhareselele', 1, 'tlhareselele', -25.50639, 25.63625),
(3933009, 3933851, 'BW', 'Tlala Mabeli', 1, 'tlala-mabeli', -21.26667, 26.3),
(3933010, 3933851, 'BW', 'Tlabala', 1, 'tlabala', -22.48333, 26.31667),
(3933018, 3933562, 'BW', 'Thamaga', 1, 'thamaga', -24.67014, 25.53975),
(3933019, 3933851, 'BW', 'Thabatskudu', 1, 'thabatskudu', -20.73333, 25.76667),
(3933021, 3933851, 'BW', 'Manaledi', 1, 'manaledi', -22.68733, 27.47713),
(3933029, 3933210, 'BW', 'Thantabana', 1, 'thantabana', -20.84078, 27.57961),
(3933030, 3933851, 'BW', 'Tamasane', 1, 'tamasane', -22.4184, 27.40127),
(3933034, 3933758, 'BW', 'Takachu', 1, 'takachu', -22.55, 21.91667),
(3933035, 3933851, 'BW', 'Tagu', 1, 'tagu', -20.73333, 24.86667),
(3933037, 3933758, 'BW', 'Sunnyside', 1, 'sunnyside', -21.66667, 22.05),
(3933038, 3933851, 'BW', 'Sukwane', 1, 'sukwane', -20.83333, 24.36667),
(3933040, 3933851, 'BW', 'Sua', 1, 'sua', -20.05, 26.2),
(3933047, 3933851, 'BW', 'Sofala', 1, 'sofala', -23.03333, 27.46667),
(3933054, 3933840, 'BW', 'Simati', 1, 'simati', -18.15, 24.06667),
(3933055, 3933043, 'BW', 'Selokolela', 1, 'selokolela', -24.9491, 25.11101),
(3933056, 3933851, 'BW', 'Sihoro', 1, 'sihoro', -20.48333, 24.5),
(3933064, 3933851, 'BW', 'Shoshong', 1, 'shoshong', -23.0389, 26.51),
(3933075, 3933851, 'BW', 'Shakse', 1, 'shakse', -22.41667, 26.73333),
(3933076, 3933851, 'BW', 'Shakgwe', 1, 'shakgwe', -23.10719, 27.15205),
(3933077, 3933230, 'BW', 'Shakawe', 1, 'shakawe', -18.36536, 21.84219),
(3933083, 3933851, 'BW', 'Sesume', 1, 'sesume', -21.00392, 24.36688),
(3933084, 3933851, 'BW', 'Sesaloa', 1, 'sesaloa', -21.66667, 25.71667),
(3933086, 3933851, 'BW', 'Serule', 1, 'serule', -22.3276, 27.49356),
(3933088, 3933851, 'BW', 'Serowe', 1, 'serowe', -22.38754, 26.71077),
(3933091, 3933851, 'BW', 'Serokhe', 1, 'serokhe', -23.05, 27.36667),
(3933092, 3933851, 'BW', 'Seokane', 1, 'seokane', -22.01704, 27.39913),
(3933096, 3933851, 'BW', 'Selika', 1, 'selika', -23.01667, 27.76667),
(3933099, 14778172, 'BW', 'Selebi-Phikwe', 1, 'selebi-phikwe', -21.97895, 27.84296),
(3933102, 3933043, 'BW', 'Sekoma', 1, 'sekoma', -24.4, 23.88333),
(3933105, 3933043, 'BW', 'Segwagwa', 1, 'segwagwa', -25.18941, 25.1732),
(3933109, 3933230, 'BW', 'Sehithwa', 1, 'sehithwa', -20.46667, 22.71667),
(3933112, 3933851, 'BW', 'Sefophe', 1, 'sefophe', -22.18333, 27.96667),
(3933113, 3933043, 'BW', 'Sefhetla', 1, 'sefhetla', -25.35, 25.36667),
(3933116, 3933840, 'BW', 'Sebutu', 1, 'sebutu', -18.71667, 25.7),
(3933117, 3933210, 'BW', 'Sebina', 1, 'sebina', -20.86667, 27.25),
(3933119, 3933840, 'BW', 'Sebe', 1, 'sebe', -18.8, 25.51667),
(3933124, 3933851, 'BW', 'Sansake', 1, 'sansake', -21.95, 28.18333),
(3933137, 3933851, 'BW', 'Ratholo', 1, 'ratholo', -22.72454, 27.57199),
(3933141, 3933044, 'BW', 'Ramotswa', 1, 'ramotswa', -24.87158, 25.86989),
(3933148, 3933851, 'BW', 'Ramokgonami', 1, 'ramokgonami', -22.8645, 27.42391),
(3933151, 3933851, 'BW', 'Rakops', 1, 'rakops', -21.02257, 24.36052),
(3933162, 3933851, 'BW', 'Pilikwe', 1, 'pilikwe', -22.79904, 27.19376),
(3933164, 3933654, 'BW', 'Pilane', 1, 'pilane', -24.45, 26.13333),
(3933166, 3933851, 'BW', 'Phukumakahu', 1, 'phukumakahu', -20.7, 24.41667),
(3933175, 3933840, 'BW', 'Paranatungu', 1, 'paranatungu', -18.05, 24.26667),
(3933178, 3933230, 'BW', 'Pandamatenga', 1, 'pandamatenga', -18.52779, 25.62698),
(3933179, 3933851, 'BW', 'Pamashaba', 1, 'pamashaba', -22.43333, 26.76667),
(3933182, 3933851, 'BW', 'Palapye', 1, 'palapye', -22.54605, 27.12507),
(3933184, 3933044, 'BW', 'Otse', 1, 'otse', -25.01667, 25.73333),
(3933186, 3933851, 'BW', 'Orapa', 1, 'orapa', -21.3115, 25.37642),
(3933190, 3933851, 'BW', 'Omajaha', 1, 'omajaha', -20.36667, 24.31667),
(3933191, 3933851, 'BW', 'Omagaga', 1, 'omagaga', -20.35, 24.31667),
(3933193, 3933210, 'BW', 'Old Tati', 1, 'old-tati', -21.51667, 27.8),
(3933194, 3933851, 'BW', 'Old Palapye', 1, 'old-palapye', -22.56667, 27.3),
(3933201, 3933851, 'BW', 'Odanakumadona', 1, 'odanakumadona', -20.88333, 24.75),
(3933206, 3933758, 'BW', 'Nwali', 1, 'nwali', -23.08333, 20.21667),
(3933211, 3933230, 'BW', 'Nokaneng', 1, 'nokaneng', -19.66667, 22.26667),
(3933212, 3933758, 'BW', 'Nojane', 1, 'nojane', -23.16667, 20.26667),
(3933218, 3933840, 'BW', 'Ngwezumba', 1, 'ngwezumba', -18.45, 24.86667),
(3933221, 3933851, 'BW', 'Ngwala', 1, 'ngwala', -20.46667, 24.51667),
(3933238, 3933851, 'BW', 'Nata', 1, 'nata', -20.21667, 26.18333),
(3933249, 3933851, 'BW', 'Mumungwe', 1, 'mumungwe', -21.98333, 26.4),
(3933252, 3933840, 'BW', 'Muchenje', 1, 'muchenje', -17.98475, 24.64938),
(3933253, 3933851, 'BW', 'Mswazi Village', 1, 'mswazi-village', -20.6, 27.21667),
(3933255, 3933851, 'BW', 'Mpechukudu', 1, 'mpechukudu', -21.81667, 25.78333),
(3933264, 3933851, 'BW', 'Motloutse', 1, 'motloutse', -21.55068, 27.3916),
(3933268, 3933851, 'BW', 'Mosveng', 1, 'mosveng', -23.03333, 27.11667),
(3933271, 3933043, 'BW', 'Mosopa', 1, 'mosopa', -24.7718, 25.42156),
(3933276, 3933043, 'BW', 'Moshwana', 1, 'moshwana', -25.38333, 25.3),
(3933277, 3933851, 'BW', 'Mosetse', 1, 'mosetse', -20.75, 26.65),
(3933280, 3933043, 'BW', 'Morwamosu', 1, 'morwamosu', -24.08588, 23.07867),
(3933284, 3933851, 'BW', 'Moremi', 1, 'moremi', -22.57234, 27.45058),
(3933288, 3933851, 'BW', 'Mopipi', 1, 'mopipi', -21.18333, 24.88333),
(3933290, 3933851, 'BW', 'Mookane', 1, 'mookane', -23.68805, 26.65948),
(3933292, 3933851, 'BW', 'Maunatlala', 1, 'maunatlala', -22.59701, 27.63006),
(3933298, 3933851, 'BW', 'Molusi', 1, 'molusi', -20.4, 24.31667),
(3933303, 3933851, 'BW', 'Molibatsi', 1, 'molibatsi', -22.53333, 27.51667),
(3933304, 3933851, 'BW', 'Malete', 1, 'malete', -22.88921, 27.51945),
(3933305, 3933562, 'BW', 'Molepolole', 1, 'molepolole', -24.40659, 25.49508),
(3933312, 3933851, 'BW', 'Mokokwane', 1, 'mokokwane', -22.64623, 27.63507),
(3933313, 3933851, 'BW', 'Makobeng', 1, 'makobeng', -22.99637, 27.66766),
(3933321, 3933851, 'BW', 'Mogapinyana', 1, 'mogapinyana', -22.37114, 27.58575),
(3933327, 3933851, 'BW', 'Mokatani', 1, 'mokatani', -22.15, 25.86667),
(3933328, 3933043, 'BW', 'Mojane', 1, 'mojane', -25.61667, 25.05),
(3933329, 3933851, 'BW', 'Moijabana', 1, 'moijabana', -22.62716, 26.41135),
(3933331, 3933562, 'BW', 'Mogoditshane', 1, 'mogoditshane', -24.62694, 25.86556),
(3933333, 3933851, 'BW', 'Mogapi', 1, 'mogapi', -22.32301, 27.83492),
(3933334, 3933851, 'BW', 'Moeng', 1, 'moeng', -22.68054, 27.61139),
(3933339, 3933210, 'BW', 'Mochumi', 1, 'mochumi', -20.83333, 27.65),
(3933340, 3933654, 'BW', 'Mochudi', 1, 'mochudi', -24.41667, 26.15),
(3933345, 3933043, 'BW', 'Moakhi', 1, 'moakhi', -25.58333, 25.08333),
(3933347, 3933654, 'BW', 'Mmathubudukwane', 1, 'mmathubudukwane', -24.6, 26.43333),
(3933354, 3933851, 'BW', 'Micawber', 1, 'micawber', -23.73333, 26.7),
(3933365, 3933851, 'BW', 'Mmatshumo', 1, 'mmatshumo', -21.14722, 25.68834),
(3933366, 3933230, 'BW', 'Maun', 1, 'maun', -19.98333, 23.41667),
(3933377, 3933851, 'BW', 'Mathakola', 1, 'mathakola', -22.72125, 27.31057),
(3933383, 3933851, 'BW', 'Mathathane', 1, 'mathathane', -22.26875, 28.74946),
(3933385, 3933851, 'BW', 'Matoposane', 1, 'matoposane', -22.51978, 27.54019),
(3933386, 3933758, 'BW', 'Matapa', 1, 'matapa', -23.18333, 24.61667),
(3933387, 3933851, 'BW', 'Mathambgwane', 1, 'mathambgwane', -20.99075, 27.33158),
(3933390, 3933210, 'BW', 'Masunga', 1, 'masunga', -20.62455, 27.44875),
(3933392, 3933758, 'BW', 'Massering', 1, 'massering', -23.21667, 21.81667),
(3933396, 3933851, 'BW', 'Mosopha', 1, 'mosopha', -22.95135, 27.37496),
(3933400, 3933840, 'BW', 'Maseme', 1, 'maseme', -18.75, 25.06667),
(3933403, 3933851, 'BW', 'Masame', 1, 'masame', -22.43338, 26.8414),
(3933413, 3933851, 'BW', 'Maope', 1, 'maope', -22.24934, 27.24708),
(3933416, 3933043, 'BW', 'Manyana', 1, 'manyana', -24.77361, 25.59278),
(3933432, 3933851, 'BW', 'Malaka', 1, 'malaka', -22.6155, 27.3294),
(3933436, 3933851, 'BW', 'Makwata East', 1, 'makwata-east', -23.31667, 27.31667),
(3933437, 3933851, 'BW', 'Makwata', 1, 'makwata', -23.28333, 27.3),
(3933438, 3933851, 'BW', 'Makwa', 1, 'makwa', -21.74386, 26.63762),
(3933442, 3933851, 'BW', 'Makoro', 1, 'makoro', -22.18143, 26.57299),
(3933456, 3933210, 'BW', 'Makaleng', 1, 'makaleng', -20.9, 27.28333),
(3933466, 3933851, 'BW', 'Maike', 1, 'maike', -21.96723, 28.181),
(3933471, 3933851, 'BW', 'Mahalapye', 1, 'mahalapye', -23.10407, 26.81421),
(3933472, 3933851, 'BW', 'Mhalapitsa', 1, 'mhalapitsa', -22.7941, 27.23297),
(3933479, 3933851, 'BW', 'Maditsenyane', 1, 'maditsenyane', -21.03333, 25.15),
(3933487, 3933043, 'BW', 'Moshaneng', 1, 'moshaneng', -24.90808, 25.23856),
(3933488, 3933851, 'BW', 'Machaneng', 1, 'machaneng', -23.18621, 27.48856),
(3933493, 3933851, 'BW', 'Mabosi Stadt', 1, 'mabosi-stadt', -23.23333, 27.08333),
(3933498, 3933851, 'BW', 'Maapi', 1, 'maapi', -22.75785, 27.35001),
(3933502, 3933851, 'BW', 'Leupane', 1, 'leupane', -22.59154, 27.031),
(3933506, 3933043, 'BW', 'Lotlhakane', 1, 'lotlhakane', -25.08612, 25.4586),
(3933509, 3933043, 'BW', 'Lolale', 1, 'lolale', -24.63333, 23.51667),
(3933514, 3933654, 'BW', 'Lokala Drift', 1, 'lokala-drift', -23.98333, 26.68333),
(3933515, 3933851, 'BW', 'Lohoklane', 1, 'lohoklane', -21.88333, 25.76667),
(3933521, 14778171, 'BW', 'Lobatse', 1, 'lobatse', -25.22435, 25.67728),
(3933531, 3933851, 'BW', 'Likolwalo', 1, 'likolwalo', -20.5, 24.48333),
(3933533, 3933851, 'BW', 'Letsili', 1, 'letsili', -21.96667, 28.51667),
(3933534, 3933562, 'BW', 'Letlhakeng', 1, 'letlhakeng', -24.09442, 25.02977),
(3933535, 3933851, 'BW', 'Letlhakane', 1, 'letlhakane', -21.41494, 25.59263),
(3933538, 3933840, 'BW', 'Lesoane', 1, 'lesoane', -18.08333, 24.41667),
(3933541, 3933562, 'BW', 'Lenchwe Le Tau', 1, 'lenchwe-le-tau', -24.38333, 25.85),
(3933546, 3933851, 'BW', 'Lekala', 1, 'lekala', -22.78333, 27.61667),
(3933548, 3933657, 'BW', 'Lehututu', 1, 'lehututu', -23.96667, 21.86667),
(3933551, 3933043, 'BW', 'Leftka', 1, 'leftka', -24.78333, 25.66667),
(3933553, 3933840, 'BW', 'Lefase', 1, 'lefase', -18.16667, 24.06667),
(3933555, 3933851, 'BW', 'Letsheng', 1, 'letsheng', -22.66384, 27.2239),
(3933564, 3933851, 'BW', 'Kwaraga', 1, 'kwaraga', -20.41667, 24.5),
(3933567, 3933758, 'BW', 'Kwakhanai', 1, 'kwakhanai', -21.75, 21.28333),
(3933576, 3933840, 'BW', 'Kumba Pits', 1, 'kumba-pits', -18.71667, 24.68333),
(3933578, 3933758, 'BW', 'Kuli', 1, 'kuli', -23.05, 20.06667),
(3933579, 3933758, 'BW', 'Kukumane Kraal', 1, 'kukumane-kraal', -23.01667, 24.18333),
(3933596, 3933044, 'BW', 'Kopong', 1, 'kopong', -24.48333, 25.88333),
(3933621, 3933758, 'BW', 'Kkhoutsiri', 1, 'kkhoutsiri', -21.41667, 22.08333),
(3933622, 3933758, 'BW', 'Kkhoutsa', 1, 'kkhoutsa', -21.58333, 21.56667),
(3933624, 3933851, 'BW', 'Kkhobi', 1, 'kkhobi', -21.76667, 27.2),
(3933625, 3933851, 'BW', 'Kitsuhele', 1, 'kitsuhele', -20.51667, 24.46667),
(3933629, 3933851, 'BW', 'Ki-e-Wonga', 1, 'ki-e-wonga', -20.33333, 24.31667),
(3933633, 3933562, 'BW', 'Khudumelapye', 1, 'khudumelapye', -23.88333, 24.75),
(3933638, 3933758, 'BW', 'Khomodimo Village', 1, 'khomodimo-village', -22.71667, 23.86667),
(3933640, 3933851, 'BW', 'Xumo', 1, 'xumo', -21.16667, 24.58333),
(3933643, 3933758, 'BW', 'Khnaitso', 1, 'khnaitso', -21.75, 21.48333),
(3933644, 3933758, 'BW', 'Khemsbok', 1, 'khemsbok', -21.68333, 21.63333),
(3933645, 3933851, 'BW', 'Khasebake', 1, 'khasebake', -20.7, 24.43333),
(3933649, 3933043, 'BW', 'Khakhea', 1, 'khakhea', -24.68954, 23.49403),
(3933651, 3933043, 'BW', 'Khakalashwe', 1, 'khakalashwe', -24.7, 25.38333),
(3933652, 3933758, 'BW', 'Kgomofatsha', 1, 'kgomofatsha', -23.26667, 21.76667),
(3933662, 3933840, 'BW', 'Kavimba', 1, 'kavimba', -18.01667, 24.6),
(3933674, 3933840, 'BW', 'Kataba', 1, 'kataba', -18.16667, 24.41667),
(3933675, 3933840, 'BW', 'Kasinka', 1, 'kasinka', -18.2, 24.31667),
(3933677, 3933840, 'BW', 'Kasane', 1, 'kasane', -17.80165, 25.16024),
(3933681, 3933851, 'BW', 'Karamechen', 1, 'karamechen', -21.61667, 27.75),
(3933683, 3933758, 'BW', 'Karaka', 1, 'karaka', -21.78333, 21.38333),
(3933685, 3933043, 'BW', 'Kanye', 1, 'kanye', -24.96675, 25.33273),
(3933692, 3933657, 'BW', 'Kang', 1, 'kang', -23.67518, 22.78762),
(3933695, 3933758, 'BW', 'Kalkfontein', 1, 'kalkfontein', -22.11667, 20.9),
(3933696, 3933851, 'BW', 'Kalamare', 1, 'kalamare', -22.93369, 26.57032),
(3933698, 3933210, 'BW', 'Kalakamati', 1, 'kalakamati', -20.59235, 27.31069),
(3933702, 3933840, 'BW', 'Kakoaka', 1, 'kakoaka', -18.66667, 24.36667),
(3933704, 3933851, 'BW', 'Kgagodi', 1, 'kgagodi', -22.37995, 27.56518),
(3933711, 3933840, 'BW', 'Kachikau', 1, 'kachikau', -18.16667, 24.46667),
(3933712, 3933840, 'BW', 'Kabulabula', 1, 'kabulabula', -17.83333, 24.96667),
(3933713, 3933758, 'BW', 'Kabakai', 1, 'kabakai', -21.71667, 21.68333),
(3933719, 3933044, 'BW', 'Janeng', 1, 'janeng', -25.41667, 25.55),
(3933720, 3933851, 'BW', 'Jakops', 1, 'jakops', -21.03333, 24.36667),
(3933723, 3933562, 'BW', 'Inkangwe', 1, 'inkangwe', -24.01667, 25.8),
(3933726, 3933657, 'BW', 'Hukuntsi', 1, 'hukuntsi', -23.9988, 21.77962),
(3933732, 3933210, 'BW', 'Habangan', 1, 'habangan', -20.53804, 27.58901),
(3933734, 3933851, 'BW', 'Gweta', 1, 'gweta', -20.18333, 25.23333),
(3933735, 3933851, 'BW', 'Gwaraha', 1, 'gwaraha', -20.76667, 24.83333),
(3933736, 3933851, 'BW', 'Gutta', 1, 'gutta', -20.71667, 24.96667),
(3933742, 3933851, 'BW', 'Gucta', 1, 'gucta', -20.4, 25.1),
(3933753, 3933851, 'BW', 'Gobojango', 1, 'gobojango', -21.8327, 28.72882),
(3933759, 3933758, 'BW', 'Ghanzi', 1, 'ghanzi', -21.69785, 21.64581),
(3933763, 3933840, 'BW', 'Gehumdi', 1, 'gehumdi', -18.78333, 25.41667),
(3933773, 14778169, 'BW', 'Gaborone', 1, 'gaborone', -24.65451, 25.90859),
(3933774, 3933044, 'BW', 'Gaberones Camp', 1, 'gaberones-camp', -24.66667, 25.91667),
(3933777, 3933562, 'BW', 'Gabane', 1, 'gabane', -24.66667, 25.78222),
(3933778, 14778168, 'BW', 'Francistown', 1, 'francistown', -21.17, 27.50778),
(3933786, 3933851, 'BW', 'Dwaha', 1, 'dwaha', -20.93333, 24.65),
(3933787, 3933562, 'BW', 'Dutlwe', 1, 'dutlwe', -23.98333, 23.9),
(3933790, 3933210, 'BW', 'Dukwe', 1, 'dukwe', -20.58333, 26.41667),
(3933795, 3933840, 'BW', 'Dodo', 1, 'dodo', -18.75, 25.4),
(3933797, 3933851, 'BW', 'Ditsinane', 1, 'ditsinane', -21.41667, 25.83333),
(3933798, 3933851, 'BW', 'Ditauana', 1, 'ditauana', -21.93333, 26.95),
(3933801, 3933851, 'BW', 'Dinokana', 1, 'dinokana', -22.91667, 27.56667),
(3933812, 3933851, 'BW', 'Dibete Station', 1, 'dibete-station', -23.7476, 26.47028),
(3933813, 3933851, 'BW', 'Detoie', 1, 'detoie', -21.55, 25.66667),
(3933815, 3933758, 'BW', 'Dekar', 1, 'dekar', -21.53333, 21.93333),
(3933818, 3933851, 'BW', 'Dauga', 1, 'dauga', -20.76905, 24.38087),
(3933827, 3933851, 'BW', 'Chuma', 1, 'chuma', -20.65, 24.91667),
(3933831, 3933758, 'BW', 'Chukudu Kraal', 1, 'chukudu-kraal', -22.45, 23.38333),
(3933836, 3933043, 'BW', 'Chuaning', 1, 'chuaning', -25.55, 24.95),
(3933837, 3933851, 'BW', 'Chor-he-samuke', 1, 'chor-he-samuke', -20.73333, 24.41667),
(3933854, 3933043, 'BW', 'Bulukubalo', 1, 'bulukubalo', -24.23333, 23.31667),
(3933855, 3933758, 'BW', 'Buitsivango', 1, 'buitsivango', -21.9, 21.38333),
(3933862, 3933562, 'BW', 'Botlhapatlou', 1, 'botlhapatlou', -24.02591, 25.48976),
(3933872, 3933562, 'BW', 'Borakalalop Camp', 1, 'borakalalop-camp', -24.4, 25.51667),
(3933875, 3933851, 'BW', 'Bonwapitse', 1, 'bonwapitse', -23.03918, 26.63774),
(3933881, 3933654, 'BW', 'Bokaa', 1, 'bokaa', -24.45, 26.01667),
(3933885, 3933851, 'BW', 'Bobonong', 1, 'bobonong', -21.96554, 28.43625),
(3933895, 3933758, 'BW', 'Barachu', 1, 'barachu', -23.01667, 21.81667),
(3933897, 3933851, 'BW', 'Bakwena', 1, 'bakwena', -23.76667, 26.6),
(3933902, 3933851, 'BW', 'Raphiri', 1, 'raphiri', -22.592, 27.58737),
(4106195, 3933562, 'BW', 'Mmokolodi', 1, 'mmokolodi', -24.69611, 25.80111),
(4106203, 3933562, 'BW', 'Gaphatshwe', 1, 'gaphatshwe', -24.57389, 25.83417),
(4106204, 3933562, 'BW', 'Mononyane', 1, 'mononyane', -24.54194, 25.77139),
(4106205, 3933562, 'BW', 'Galekgatshwane', 1, 'galekgatshwane', -24.51917, 25.8075),
(4106206, 3933562, 'BW', 'Metsemotlhaba', 1, 'metsemotlhaba', -24.55139, 25.80306),
(4106211, 3933562, 'BW', 'Kgaphamadi', 1, 'kgaphamadi', -24.53778, 25.9275),
(4106213, 3933562, 'BW', 'Mmopone', 1, 'mmopone', -24.56694, 25.87417),
(4106214, 3933562, 'BW', 'Dumadumana', 1, 'dumadumana', -24.58722, 25.87444),
(4106215, 3933562, 'BW', 'Nkoyaphiri', 1, 'nkoyaphiri', -24.63222, 25.83139),
(10543370, 3933210, 'BW', 'Letsholathebe', 1, 'letsholathebe', -20.68007, 27.43847),
(10543392, 3933210, 'BW', 'Mulambakwena', 1, 'mulambakwena', -20.57136, 27.46042),
(10543394, 3933210, 'BW', 'Zwenshambe', 1, 'zwenshambe', -20.50594, 27.43592),
(10543397, 3933210, 'BW', 'Gambule', 1, 'gambule', -20.51781, 27.3856),
(10543403, 3933210, 'BW', 'Shashe Drift', 1, 'shashe-drift', -20.57433, 27.3063),
(10570723, 3933851, 'BW', 'Matombo Mashaba', 1, 'matombo-mashaba', -20.60168, 27.01339),
(10570732, 3933851, 'BW', 'Matobo', 1, 'matobo', -20.55973, 27.11541),
(10570736, 3933562, 'BW', 'Nswazwi', 1, 'nswazwi', -20.65796, 27.23134),
(10570738, 3933562, 'BW', 'Old Nswazwi', 1, 'old-nswazwi', -20.58852, 27.22595),
(10570750, 3933210, 'BW', 'Nzendami', 1, 'nzendami', -20.76113, 27.26493),
(10570751, 3933210, 'BW', 'Toteng', 1, 'toteng', -20.76346, 27.25054),
(10570919, 3933851, 'BW', 'Marapong', 1, 'marapong', -20.89285, 27.07206),
(10570923, 3933851, 'BW', 'Marlbela', 1, 'marlbela', -20.86343, 27.22943),
(10570924, 3933851, 'BW', 'Chizwina', 1, 'chizwina', -20.83406, 27.22296),
(10570925, 3933851, 'BW', 'Nshakashokwe', 1, 'nshakashokwe', -20.78967, 27.18422),
(10571016, 3933210, 'BW', 'Nlhakwane', 1, 'nlhakwane', -20.51066, 27.52059),
(10571020, 3933210, 'BW', 'Mosojane', 1, 'mosojane', -20.62278, 27.51927),
(10571023, 3933210, 'BW', 'Tshesebe', 1, 'tshesebe', -20.7265, 27.58516),
(10571024, 3933210, 'BW', 'Pole', 1, 'pole', -20.60973, 27.58017),
(10571030, 3933210, 'BW', 'Ramokgwebane', 1, 'ramokgwebane', -20.57663, 27.64157),
(10571346, 3933210, 'BW', 'Matenge', 1, 'matenge', -20.85315, 27.26287),
(10571347, 3933210, 'BW', 'Madwaleng', 1, 'madwaleng', -20.8969, 27.29944),
(10571349, 3933210, 'BW', 'Gulubane', 1, 'gulubane', -20.91994, 27.30872),
(10571350, 3933210, 'BW', 'Matshingitshi', 1, 'matshingitshi', -20.93475, 27.31847),
(10571354, 3933210, 'BW', 'Masingwaneng', 1, 'masingwaneng', -20.84835, 27.32536),
(10571355, 3933210, 'BW', 'Mambo', 1, 'mambo', -20.79626, 27.33386),
(10571357, 3933210, 'BW', 'Sechele', 1, 'sechele', -20.75906, 27.36067),
(10571467, 3933210, 'BW', 'Moroka', 1, 'moroka', -20.53362, 27.65053),
(10571469, 3933210, 'BW', 'Butale', 1, 'butale', -20.71545, 27.70511),
(10571471, 3933210, 'BW', 'Jakalasi Number One', 1, 'jakalasi-number-one', -20.56952, 27.71018),
(10573760, 3933210, 'BW', 'Dabgwi', 1, 'dabgwi', -20.22493, 27.24986),
(10573761, 3933851, 'BW', 'Madziba', 1, 'madziba', -20.25858, 27.05092),
(10573780, 3933210, 'BW', 'Mpapho', 1, 'mpapho', -20.14364, 27.10886),
(10573781, 3933851, 'BW', 'Nkange', 1, 'nkange', -20.29888, 27.13559),
(10573790, 3933210, 'BW', 'Mengwe', 1, 'mengwe', -20.08916, 27.17941),
(10573791, 3933851, 'BW', 'Changate', 1, 'changate', -20.32482, 27.22909),
(10573795, 3933210, 'BW', 'Maitengwe', 1, 'maitengwe', -20.12889, 27.20997),
(10573800, 3933210, 'BW', 'Mazuwe', 1, 'mazuwe', -20.18031, 27.24364),
(10573801, 3933851, 'BW', 'Senete', 1, 'senete', -20.32562, 27.13016),
(10573808, 3933210, 'BW', 'Mafote', 1, 'mafote', -20.24804, 27.28288),
(10573818, 3933851, 'BW', 'Tutume', 1, 'tutume', -20.4943, 27.03479),
(10575001, 3933851, 'BW', 'Iyaka', 1, 'iyaka', -21.22245, 26.08786),
(10575003, 3933851, 'BW', 'Gootshaa', 1, 'gootshaa', -21.00154, 26.27199),
(10575004, 3933851, 'BW', 'Ramokgweng', 1, 'ramokgweng', -21.32382, 26.00756),
(10575012, 3933851, 'BW', 'Mosu', 1, 'mosu', -21.21195, 26.02201),
(10575014, 3933851, 'BW', 'Leruti', 1, 'leruti', -21.37137, 26.06492),
(10575016, 3933851, 'BW', 'Mmai', 1, 'mmai', -21.01281, 26.46407),
(10575017, 3933851, 'BW', 'Ntane', 1, 'ntane', -21.27351, 26.16599),
(10575019, 3933851, 'BW', 'Tsorotsaro', 1, 'tsorotsaro', -21.10424, 26.3672),
(10575020, 3933851, 'BW', 'Gootsha', 1, 'gootsha', -21.27408, 26.23547),
(10575025, 3933851, 'BW', 'Thapana', 1, 'thapana', -21.13889, 26.25927),
(10575027, 3933851, 'BW', 'Khalaphuduhudu', 1, 'khalaphuduhudu', -21.19665, 26.45278),
(10575029, 3933851, 'BW', 'Modimotsebe', 1, 'modimotsebe', -21.23114, 26.4287),
(10575063, 3933851, 'BW', 'Mboyu', 1, 'mboyu', -20.01143, 26.92387),
(10575064, 3933851, 'BW', 'Ntshwailo', 1, 'ntshwailo', -20.12546, 26.89909),
(10575083, 3933840, 'BW', 'Lesomo', 1, 'lesomo', -17.8958, 25.23409),
(10651392, 3933851, 'BW', 'Kweneng', 1, 'kweneng', -21.96128, 28.3366),
(10653986, 3933851, 'BW', 'Paje', 1, 'paje', -22.26534, 26.79185),
(10654630, 3933851, 'BW', 'Moiyabana', 1, 'moiyabana', -22.6318, 26.40449),
(10654688, 3933851, 'BW', 'Mosolotsane', 1, 'mosolotsane', -22.93703, 26.38109),
(10659475, 3933851, 'BW', 'Mmokwe', 1, 'mmokwe', -22.32361, 26.74634),
(10659479, 3933851, 'BW', 'Chamme', 1, 'chamme', -22.37955, 26.63823),
(10659492, 3933851, 'BW', 'Mogorosi', 1, 'mogorosi', -22.43869, 26.56532),
(10659495, 3933851, 'BW', 'Majeadinare', 1, 'majeadinare', -22.3698, 26.54191),
(10659507, 3933851, 'BW', 'Setekwane', 1, 'setekwane', -22.34759, 26.58251),
(10659509, 3933851, 'BW', 'Ghosha', 1, 'ghosha', -22.32275, 26.61927),
(10659514, 3933851, 'BW', 'Mahatane', 1, 'mahatane', -22.28353, 26.5148),
(10663130, 3933851, 'BW', 'Mabeleapodi', 1, 'mabeleapodi', -22.21355, 26.83312),
(10663145, 3933851, 'BW', 'Maila', 1, 'maila', -22.12758, 26.84501),
(10663287, 3933851, 'BW', 'Mohatane', 1, 'mohatane', -22.11206, 27.1411),
(10663503, 3933851, 'BW', 'Majwana', 1, 'majwana', -22.99758, 26.99038),
(10663544, 3933851, 'BW', 'Lose', 1, 'lose', -22.92082, 26.90533),
(10663550, 3933851, 'BW', 'Tewane', 1, 'tewane', -22.85335, 26.90555),
(10663552, 3933851, 'BW', 'Radisele', 1, 'radisele', -22.80202, 26.99804),
(10663555, 3933851, 'BW', 'Mogome', 1, 'mogome', -22.78443, 26.9),
(10663558, 3933851, 'BW', 'Matrakosi', 1, 'matrakosi', -22.76702, 26.84604),
(10663559, 3933851, 'BW', 'Matsisadikgang', 1, 'matsisadikgang', -22.75985, 26.8895),
(10663565, 3933851, 'BW', 'Mokgware', 1, 'mokgware', -22.76979, 26.79604),
(10666304, 3933851, 'BW', 'Kolojwana', 1, 'kolojwana', -22.25124, 27.36243),
(10669383, 3933044, 'BW', 'Isang', 1, 'isang', -24.66212, 25.9216),
(10683653, 3933851, 'BW', 'Sematshwane', 1, 'sematshwane', -22.18868, 27.43168),
(10683657, 3933851, 'BW', 'Majweng', 1, 'majweng', -22.23056, 27.35051),
(10685725, 3933851, 'BW', 'Shate', 1, 'shate', -21.24853, 26.8899),
(10685726, 3933851, 'BW', 'Chamene', 1, 'chamene', -21.0801, 26.81283),
(10685727, 3933851, 'BW', 'Lekoba', 1, 'lekoba', -21.15235, 26.89292),
(10685728, 3933851, 'BW', 'Pijina', 1, 'pijina', -21.12966, 26.78671),
(10686124, 3933851, 'BW', 'Shalako', 1, 'shalako', -22.32034, 27.17852),
(10688518, 3933851, 'BW', 'Poloka', 1, 'poloka', -21.47324, 26.53095),
(10691112, 3933851, 'BW', 'Nkowane', 1, 'nkowane', -21.74768, 26.00757),
(10694647, 3933851, 'BW', 'Mabolwe', 1, 'mabolwe', -21.82117, 28.82004),
(10694657, 3933851, 'BW', 'Semolale', 1, 'semolale', -21.8677, 28.8244),
(10697027, 3933654, 'BW', 'Artesia', 1, 'artesia', -24.01242, 26.31957),
(10732949, 3933230, 'BW', 'Seronga', 1, 'seronga', -18.8129, 22.4164),
(10732950, 3933230, 'BW', 'Beetsha', 1, 'beetsha', -18.7188, 22.7634),
(10732954, 3933230, 'BW', 'Gudigwa', 1, 'gudigwa', -19.3692, 22.1617),
(10732957, 3933230, 'BW', 'Satau', 1, 'satau', -18.0104, 24.4061),
(10732958, 3933230, 'BW', 'Parakarungu', 1, 'parakarungu', -18.0352, 24.3241),
(10732983, 3933230, 'BW', 'Lesoma', 1, 'lesoma', -17.9058, 25.2374),
(10736928, 3933043, 'BW', 'Diabo', 1, 'diabo', -25.19975, 25.36576),
(10737589, 3933043, 'BW', 'Mogojwagojwe', 1, 'mogojwagojwe', -25.29246, 25.47551),
(10739123, 3933043, 'BW', 'Mmathete', 1, 'mmathete', -25.32189, 25.26911),
(10739134, 3933043, 'BW', 'Gathwane', 1, 'gathwane', -25.39194, 25.49939),
(10739153, 3933043, 'BW', 'Magoriapitse', 1, 'magoriapitse', -25.44332, 25.28958),
(10739165, 3933043, 'BW', 'Good Hope', 1, 'good-hope', -25.46712, 25.43921),
(10741601, 3933043, 'BW', 'Mokatako', 1, 'mokatako', -25.75493, 25.22061),
(10741606, 3933043, 'BW', 'Mokgomane', 1, 'mokgomane', -25.55442, 25.2432),
(10742857, 3933043, 'BW', 'Mabelane', 1, 'mabelane', -24.90395, 25.22165),
(10745149, 3933044, 'BW', 'Boatle', 1, 'boatle', -24.8275, 25.80437),
(10745696, 3933043, 'BW', 'Dialane', 1, 'dialane', -24.83026, 25.59668),
(10745698, 3933043, 'BW', 'Ramating', 1, 'ramating', -24.82003, 25.59752),
(10745720, 3933043, 'BW', 'Lekgolobotlo', 1, 'lekgolobotlo', -24.90923, 25.62498),
(10745742, 3933044, 'BW', 'Mogobane', 1, 'mogobane', -24.98418, 25.69691),
(10745751, 3933043, 'BW', 'Matsatsi', 1, 'matsatsi', -24.95829, 25.60662),
(10745754, 3933043, 'BW', 'Ntlhantlhe', 1, 'ntlhantlhe', -24.96317, 25.59398),
(10745760, 3933043, 'BW', 'Magotlhwane', 1, 'magotlhwane', -24.99919, 25.58559),
(10746207, 3933043, 'BW', 'Ranaka', 1, 'ranaka', -24.91081, 25.47105),
(10751774, 3933851, 'BW', 'Puongwe', 1, 'puongwe', -21.7832, 26.78356),
(10751775, 3933851, 'BW', 'Tlapana', 1, 'tlapana', -21.98942, 26.83853),
(10751776, 3933851, 'BW', 'Bolelapudi', 1, 'bolelapudi', -21.92084, 26.95264),
(10751777, 3933851, 'BW', 'Makobaese', 1, 'makobaese', -21.84532, 26.98435),
(10751778, 3933851, 'BW', 'Dimaje', 1, 'dimaje', -21.77229, 26.83413),
(10751782, 3933851, 'BW', 'Kobe', 1, 'kobe', -21.75928, 26.79763),
(10752436, 3933851, 'BW', 'Natale', 1, 'natale', -21.10274, 27.22561),
(10752562, 3933562, 'BW', 'Gakgatla', 1, 'gakgatla', -24.54303, 25.61745),
(10752563, 3933562, 'BW', 'Gamodubu', 1, 'gamodubu', -24.50186, 25.7018),
(10752587, 3933562, 'BW', 'Kumakwane', 1, 'kumakwane', -24.65522, 25.69918),
(10752616, 3933562, 'BW', 'Mmankgodi', 1, 'mmankgodi', -24.72601, 25.64963),
(10754328, 3933851, 'BW', 'Thalogang', 1, 'thalogang', -21.1059, 27.33802),
(10754329, 3933851, 'BW', 'Chadibe', 1, 'chadibe', -21.06532, 27.34786),
(10754332, 3933851, 'BW', 'Shashe Mooke', 1, 'shashe-mooke', -21.18794, 27.37868),
(10754750, 3933210, 'BW', 'Sikukwe', 1, 'sikukwe', -21.15469, 27.65202),
(10754752, 3933210, 'BW', 'Matshelagabedi', 1, 'matshelagabedi', -21.12164, 27.66477),
(10756496, 3933851, 'BW', 'Motsaena', 1, 'motsaena', -21.8459, 26.22665),
(10756497, 3933851, 'BW', 'Moselesejana', 1, 'moselesejana', -21.80629, 26.17595),
(10756498, 3933851, 'BW', 'Tsepe', 1, 'tsepe', -21.78436, 26.13736),
(10756499, 3933851, 'BW', 'Motsena', 1, 'motsena', -21.79048, 26.04899),
(10756500, 3933851, 'BW', 'Nkoane', 1, 'nkoane', -21.99572, 26.19958),
(10756501, 3933851, 'BW', 'Tlotsago', 1, 'tlotsago', -21.94259, 26.1406),
(10758672, 3933851, 'BW', 'Mamala', 1, 'mamala', -21.77774, 26.47332),
(10758675, 3933851, 'BW', 'Mmashoro', 1, 'mmashoro', -21.86688, 26.44119),
(10759598, 3933851, 'BW', 'Gaithwa', 1, 'gaithwa', -21.52807, 26.58385),
(10759599, 3933851, 'BW', 'Dzerudwana', 1, 'dzerudwana', -21.56057, 26.63799),
(10759600, 3933851, 'BW', 'Solwane', 1, 'solwane', -21.5111, 26.68249),
(10759601, 3933851, 'BW', 'Jwagore', 1, 'jwagore', -21.55463, 26.71912),
(10759602, 3933851, 'BW', 'Mahibitwane', 1, 'mahibitwane', -21.63248, 26.69878),
(10759603, 3933851, 'BW', 'Xalagena', 1, 'xalagena', -21.66821, 26.57825),
(10764430, 3933851, 'BW', 'Kolokome', 1, 'kolokome', -22.04004, 26.62176),
(10769312, 3933851, 'BW', 'Maoko', 1, 'maoko', -22.73773, 27.10014),
(10779281, 3933043, 'BW', 'Ramatlabama', 1, 'ramatlabama', -25.63529, 25.55092),
(10845080, 3933851, 'BW', 'Gootau', 1, 'gootau', -22.72675, 27.4226),
(10845082, 3933851, 'BW', 'Sekgweng', 1, 'sekgweng', -22.72389, 27.39316),
(10845560, 3933851, 'BW', 'Lesenepole', 1, 'lesenepole', -22.58554, 27.56737),
(10845566, 3933851, 'BW', 'Seolwane', 1, 'seolwane', -22.65329, 27.69444),
(10845567, 3933851, 'BW', 'Goomosweu', 1, 'goomosweu', -22.65506, 27.64999),
(10845580, 3933851, 'BW', 'Sekhiting', 1, 'sekhiting', -22.74805, 27.63506),
(10845671, 3933851, 'BW', 'Masidie', 1, 'masidie', -22.85359, 27.33904),
(10845687, 3933851, 'BW', 'Pupya', 1, 'pupya', -22.88871, 27.49937),
(10846939, 3933851, 'BW', 'Masiadieme', 1, 'masiadieme', -22.06394, 28.35665),
(10846961, 3933851, 'BW', 'Thune Number One', 1, 'thune-number-one', -22.09445, 28.29494),
(10847878, 3933851, 'BW', 'Tsetsebjwe', 1, 'tsetsebjwe', -22.41595, 28.39797),
(10849580, 3933851, 'BW', 'Palamaokuwe', 1, 'palamaokuwe', -23.07753, 26.43817),
(10849582, 3933851, 'BW', 'Ikongwe', 1, 'ikongwe', -23.13563, 26.42269),
(10850005, 3933851, 'BW', 'Tsepheahela', 1, 'tsepheahela', -23.32592, 26.26994),
(10850241, 3933851, 'BW', 'Letlhakeng', 1, 'letlhakeng', -23.45146, 26.47372),
(10857090, 3933851, 'BW', 'Dinokwe', 1, 'dinokwe', -23.4271, 26.68235),
(10857102, 3933851, 'BW', 'Sethokge', 1, 'sethokge', -23.30056, 26.73632),
(10859156, 3933851, 'BW', 'Monate', 1, 'monate', -23.26781, 26.90075),
(10859161, 3933851, 'BW', 'Serojane', 1, 'serojane', -23.42963, 26.76495),
(10859761, 3933851, 'BW', 'Ramoselwana', 1, 'ramoselwana', -23.57635, 26.08012),
(10859764, 3933851, 'BW', 'Swanthane', 1, 'swanthane', -23.51286, 26.23994),
(10859766, 3933851, 'BW', 'Sepone', 1, 'sepone', -23.53744, 26.24364),
(10860537, 3933851, 'BW', 'Bolawe', 1, 'bolawe', -23.54974, 26.38613),
(10863926, 3933654, 'BW', 'Nokana', 1, 'nokana', -23.81917, 26.42981),
(10863927, 3933654, 'BW', 'Leshibitse', 1, 'leshibitse', -23.83249, 26.46373),
(10863929, 3933654, 'BW', 'Mmamagwaile', 1, 'mmamagwaile', -23.82684, 26.26717),
(10863985, 3933654, 'BW', 'Lentsweng', 1, 'lentsweng', -23.86333, 26.29279),
(10863986, 3933654, 'BW', 'Temesele', 1, 'temesele', -23.89683, 26.45105),
(10863991, 3933654, 'BW', 'Pitsetshweu', 1, 'pitsetshweu', -23.97365, 26.36192),
(10863996, 3933654, 'BW', 'Masama', 1, 'masama', -23.8638, 26.40209),
(10867063, 3933851, 'BW', 'Mokgowane', 1, 'mokgowane', -23.05029, 27.26996),
(10867068, 3933851, 'BW', 'Mookametsana', 1, 'mookametsana', -23.15763, 27.27935),
(10867073, 3933851, 'BW', 'Masekari', 1, 'masekari', -23.15108, 27.40683),
(10867559, 3933043, 'BW', 'Kokong', 1, 'kokong', -24.34496, 23.11971),
(10883456, 3933851, 'BW', 'Seleka', 1, 'seleka', -22.88077, 27.52889),
(10884240, 3933851, 'BW', 'Masokwe', 1, 'masokwe', -23.31166, 26.14971),
(10884242, 3933851, 'BW', 'Kgodikwe', 1, 'kgodikwe', -23.25276, 26.23552),
(10884249, 3933851, 'BW', 'Selinya', 1, 'selinya', -23.42368, 26.09359),
(10884390, 3933851, 'BW', 'Mmutlana', 1, 'mmutlana', -23.04379, 26.58015),
(10884587, 3933851, 'BW', 'Mokgatusheng', 1, 'mokgatusheng', -23.13665, 26.92001),
(10884589, 3933851, 'BW', 'Tautswe', 1, 'tautswe', -23.13234, 26.95971),
(10884617, 3933851, 'BW', 'Moko', 1, 'moko', -23.05641, 26.84872),
(10884618, 3933851, 'BW', 'Tapalamonong', 1, 'tapalamonong', -23.04832, 26.85561),
(10888464, 3933654, 'BW', 'Lerula', 1, 'lerula', -23.96217, 26.59439),
(10889033, 3933043, 'BW', 'Serumolwe', 1, 'serumolwe', -24.02296, 23.09078),
(10889036, 3933043, 'BW', 'Ramokapane', 1, 'ramokapane', -24.16354, 23.07024),
(10889490, 3933043, 'BW', 'Nyetse', 1, 'nyetse', -24.30505, 23.56892),
(10889491, 3933043, 'BW', 'Bokhutlo', 1, 'bokhutlo', -24.41675, 23.53645),
(10889492, 3933043, 'BW', 'Gasekhukhu', 1, 'gasekhukhu', -24.42245, 23.55758),
(10889493, 3933043, 'BW', 'Mabutsane', 1, 'mabutsane', -24.38646, 23.57486),
(10889494, 3933043, 'BW', 'Palamaokuwe', 1, 'palamaokuwe', -24.4045, 23.60302),
(10889495, 3933043, 'BW', 'Matlhaba', 1, 'matlhaba', -24.43013, 23.60403),
(10889496, 3933043, 'BW', 'Kanaku', 1, 'kanaku', -24.36801, 23.6358),
(10892001, 3933043, 'BW', 'Keng', 1, 'keng', -24.59905, 23.75522),
(10893425, 3933043, 'BW', 'Kobamni', 1, 'kobamni', -24.76053, 23.5393),
(10893426, 3933043, 'BW', 'Radigole', 1, 'radigole', -24.76594, 23.51558),
(10893427, 3933043, 'BW', 'Mamohumela', 1, 'mamohumela', -24.7798, 23.52151),
(10893428, 3933043, 'BW', 'Thari', 1, 'thari', -24.78027, 23.50182),
(10908685, 3933562, 'BW', 'Dikgatlong', 1, 'dikgatlong', -24.21936, 25.89919),
(10908686, 3933562, 'BW', 'Lentsweletau', 1, 'lentsweletau', -24.24863, 25.85215),
(10908931, 3933043, 'BW', 'Kgome', 1, 'kgome', -24.58921, 24.65811),
(10908933, 3933043, 'BW', 'Mogobewadinonyane', 1, 'mogobewadinonyane', -24.64902, 24.70736),
(10908936, 3933043, 'BW', 'Lepapa', 1, 'lepapa', -24.74582, 24.65776),
(10909161, 3933562, 'BW', 'Maratswene', 1, 'maratswene', -24.0084, 25.25719),
(10909169, 3933562, 'BW', 'Tswaane', 1, 'tswaane', -24.18404, 25.27604),
(10909170, 3933562, 'BW', 'Mantswabisi', 1, 'mantswabisi', -24.20023, 25.30526),
(10909172, 3933562, 'BW', 'Moshaweng', 1, 'moshaweng', -24.17892, 25.48864),
(10926644, 3933210, 'BW', 'Senyawe', 1, 'senyawe', -20.78169, 27.68922),
(10926646, 3933210, 'BW', 'Siviya', 1, 'siviya', -20.8564, 27.67437),
(10926647, 3933210, 'BW', 'Sekgophane', 1, 'sekgophane', -20.82127, 27.59516),
(10926648, 3933210, 'BW', 'Mabudzane', 1, 'mabudzane', -20.90677, 27.63389),
(10926650, 3933210, 'BW', 'Jakalasi Number Two', 1, 'jakalasi-number-two', -20.95429, 27.68417),
(13941922, 14778172, 'BW', 'Botshabelo North', 1, 'botshabelo-north', -21.98219, 27.841),
(14204609, 3933043, 'BW', 'Molapowabojang', 1, 'molapowabojang', -25.20703, 25.53017),
(14204683, 3933230, 'BW', 'Etsha', 1, 'etsha', -19.13099, 22.29254),
(14204768, 3933758, 'BW', 'Charles Hill', 1, 'charles-hill', -22.27639, 20.09278),
(14204902, 3933851, 'BW', 'Zoroga', 1, 'zoroga', -20.16472, 25.82639),
(14204929, 3933044, 'BW', 'Phakalane', 1, 'phakalane', -24.56078, 25.95159),
(14205029, 3933654, 'BW', 'Dikwididi', 1, 'dikwididi', -24.59639, 26.21917),
(14205055, 3933210, 'BW', 'Tati Siding', 1, 'tati-siding', -21.27345, 27.49002),
(14205090, 3933230, 'BW', 'Shorobe', 1, 'shorobe', -19.76194, 23.67694),
(14205116, 3933210, 'BW', 'Mbalambi', 1, 'mbalambi', -20.49472, 27.37833),
(14205124, 3933562, 'BW', 'Motokwe', 1, 'motokwe', -24.05791, 23.28187),
(14205127, 3933851, 'BW', 'Semitwe', 1, 'semitwe', -20.94083, 27.08028),
(14205142, 3933851, 'BW', 'Topisi', 1, 'topisi', -22.18313, 27.24165),
(14205201, 3933044, 'BW', 'Oodi', 1, 'oodi', -24.57306, 26.03389),
(14205277, 3933230, 'BW', 'Gumare', 1, 'gumare', -19.36917, 22.16167),
(14205511, 3933851, 'BW', 'Motshegaletau', 1, 'motshegaletau', -22.5627, 26.4111),
(14205567, 3933210, 'BW', 'Themashanga', 1, 'themashanga', -20.80083, 27.55139),
(14205725, 3933230, 'BW', 'Chanoga', 1, 'chanoga', -20.15558, 23.65705),
(14231378, 3933851, 'BW', 'Lentswelemoriti', 1, 'lentswelemoriti', -22.20997, 29.03996),
(14238061, 3933043, 'BW', 'Musi', 1, 'musi', -25.64999, 25.12743),
(14258235, 3933043, 'BW', 'Sese', 1, 'sese', -24.6561, 24.8063),
(14258456, 3933851, 'BW', 'Borolong', 1, 'borolong', -21.10361, 27.33611),
(14258590, 14778168, 'BW', 'Minestone', 1, 'minestone', -21.16994, 27.51659),
(14258593, 3933851, 'BW', 'Thomadithotse', 1, 'thomadithotse', -23.10407, 26.81421),
(14279711, 3933851, 'BW', 'Tidimalo', 1, 'tidimalo', -23.09174, 26.81639),
(14280521, 3933562, 'BW', 'Phuting', 1, 'phuting', -24.66679, 25.55373),
(14280563, 3933851, 'BW', 'Madisakwana', 1, 'madisakwana', -21.45, 27.47389),
(14280721, 3933851, 'BW', 'Manyanda', 1, 'manyanda', -21.42217, 27.4538),
(14281615, 3933851, 'BW', 'Dilaene', 1, 'dilaene', -23.11393, 26.78918),
(14282018, 3933562, 'BW', 'Malakana Ward', 1, 'malakana-ward', -24.67182, 25.54115),
(14287036, 3933758, 'BW', 'Ncojane', 1, 'ncojane', -23.13389, 20.295),
(14287513, 3933851, 'BW', 'Mokubilo', 1, 'mokubilo', -21.33556, 26.47472),
(14287829, 3933758, 'BW', 'West Hanahai', 1, 'west-hanahai', -22.103, 21.773),
(14288059, 3933758, 'BW', 'Tshootsha', 1, 'tshootsha', -22.14921, 20.85638),
(14288136, 3933230, 'BW', 'Xhauga', 1, 'xhauga', -18.44686, 21.89434),
(14288138, 3933043, 'BW', 'Digawana', 1, 'digawana', -25.342, 25.5595),
(14288141, 3933044, 'BW', 'Modipane', 1, 'modipane', -24.621, 26.125),
(14288838, 3933562, 'BW', 'Metsimotlhabe', 1, 'metsimotlhabe', -24.554, 25.8095),
(14352132, 3933230, 'BW', 'Habu', 1, 'habu', -19.84, 22.38472),
(14352358, 3933562, 'BW', 'Salajwe', 1, 'salajwe', -23.69637, 24.71748),
(14353058, 3933654, 'BW', 'Rasesa', 1, 'rasesa', -24.37306, 26.07287),
(14353104, 3933851, 'BW', 'Motlhabaneng', 1, 'motlhabaneng', -22.17755, 28.87859),
(14353119, 3933851, 'BW', 'Goshwe', 1, 'goshwe', -20.50572, 27.20568),
(14395651, 3933851, 'BW', 'Mmakgabo', 1, 'mmakgabo', -22.79897, 27.76966),
(14395950, 3933044, 'BW', 'Medie', 1, 'medie', -24.57543, 25.90441),
(14395977, 3933654, 'BW', 'Malolwane', 1, 'malolwane', -24.53621, 26.47327),
(14396022, 3933851, 'BW', 'Kudumatse', 1, 'kudumatse', -23.43742, 27.17915),
(14398139, 3933851, 'BW', 'Lethekane', 1, 'lethekane', -23.4271, 26.68235),
(14398412, 3933851, 'BW', 'Ngwapa', 1, 'ngwapa', -23.0089, 27.751),
(14405428, 3933043, 'BW', 'Pitsane Siding', 1, 'pitsane-siding', -25.4625, 25.59528),
(14427990, 3933562, 'BW', 'Ramaphatle', 1, 'ramaphatle', -24.6972, 25.5962),
(14428030, 3933210, 'BW', 'Jackalas 2', 1, 'jackalas-2', -20.95451, 27.68198),
(14428095, 3933851, 'BW', 'Mmamadila', 1, 'mmamadila', -22.66521, 27.21998),
(14428218, 3933562, 'BW', 'Sorilatholo', 1, 'sorilatholo', -23.63667, 24.96528),
(14428707, 3933562, 'BW', 'Ditshegwane', 1, 'ditshegwane', -24.16667, 24.96167),
(14428729, 3933230, 'BW', 'Nxamaseri', 1, 'nxamaseri', -18.57879, 21.97231),
(14428872, 3933562, 'BW', 'Morope', 1, 'morope', -23.83672, 25.28376),
(14429061, 3933851, 'BW', 'Mmadikola', 1, 'mmadikola', -21.04011, 24.46649),
(14429198, 3933230, 'BW', 'Sepopa', 1, 'sepopa', -18.75, 22.18333),
(14437204, 3933230, 'BW', 'Nxamasere', 1, 'nxamasere', -18.6, 22.06667),
(14467688, 3933851, 'BW', 'Mhawaneng', 1, 'mhawaneng', -22.07369, 28.59825),
(14467814, 3933851, 'BW', 'Mathangwane', 1, 'mathangwane', -21, 27.33333),
(14467931, 3933043, 'BW', 'Galosabanyana', 1, 'galosabanyana', -24.96675, 25.33273),
(14468280, 3933654, 'BW', 'Morwa', 1, 'morwa', -24.43694, 26.07278),
(14495930, 3933758, 'BW', 'Kacgae', 1, 'kacgae', -22.85722, 22.2075),
(14495932, 3933210, 'BW', 'Kgari', 1, 'kgari', -20.58329, 27.60322),
(14593974, 14778173, 'BW', 'Sowa', 1, 'sowa', -20.564, 26.224),
(14611133, 3933562, 'BW', 'Tshwaane', 1, 'tshwaane', -23.87813, 23.67398),
(14776146, 3933654, 'BW', 'Mosomane', 1, 'mosomane', -24.01543, 26.31629);