
INSERT INTO `#__wj_portal_cities` ( `name`, `localname`, `internationalname`, `stateid`, `countryid`, `isedit`, `enabled`, `serverid`, `latitude`, `longitude`) VALUES 
("Serowe", "Serowe", "Serowe", NULL, 145, 0, 1, NULL, "-22.39776", "26.703289"),
("Tsabong", "Tsabong", "Tsabong", NULL, 145, 0, 1, NULL, "-26.021746", "22.401006"),
("Kanye", "Kanye", "Kanye", NULL, 145, 0, 1, NULL, "-24.9766112", "25.3358859"),
("Gaborone", "Gaborone", "Gaborone", NULL, 145, 0, 1, NULL, "-24.6581357", "25.9088474"),
("Mochudi", "Mochudi", "Mochudi", NULL, 145, 0, 1, NULL, "-24.3828605", "26.1489495"),
("Ghanzi", "Ghanzi", "Ghanzi", NULL, 145, 0, 1, NULL, "-21.6968123", "21.6457062"),
("Maun", "Maun", "Maun", NULL, 145, 0, 1, NULL, "-19.9860951", "23.4224352"),
("Francistown", "Francistown", "Francistown", NULL, 145, 0, 1, NULL, "-21.16636", "27.502515"),
("Bokaa", "Bokaa", "Bokaa", NULL, 145, 0, 1, NULL, "-24.42787", "26.023656"),
("Botlapatla", "Botlapatla", "Botlapatla", NULL, 145, 0, 1, NULL, "-24.033333", "25.533333"),
("Dekar", "Dekar", "Dekar", NULL, 145, 0, 1, NULL, "-21.5237263", "21.9373445"),
("Dukwe", "Dukwe", "Dukwe", NULL, 145, 0, 1, NULL, "-20.583333", "26.416667"),
("Dutlwe", "Dutlwe", "Dutlwe", NULL, 145, 0, 1, NULL, "-23.9833329", "23.9"),
("Gabane", "Gabane", "Gabane", NULL, 145, 0, 1, NULL, "-24.664129", "25.78355"),
("Gaphatshwe", "Gaphatshwe", "Gaphatshwe", NULL, 145, 0, 1, NULL, "-24.5969612", "25.91226"),
("Gobojango", "Gobojango", "Gobojango", NULL, 145, 0, 1, NULL, "-21.816667", "28.783333"),
("Gweta", "Gweta", "Gweta", NULL, 145, 0, 1, NULL, "-20.2111684", "25.2541233"),
("Hukuntsi", "Hukuntsi", "Hukuntsi", NULL, 145, 0, 1, NULL, "-23.9931196", "21.7495419"),
("Janeng", "Janeng", "Janeng", NULL, 145, 0, 1, NULL, "-25.416667", "25.55"),
("Kalamare", "Kalamare", "Kalamare", NULL, 145, 0, 1, NULL, "-22.866667", "26.5"),
("Kang", "Kang", "Kang", NULL, 145, 0, 1, NULL, "-23.6719404", "22.7926759"),
("Kasane", "Kasane", "Kasane", NULL, 145, 0, 1, NULL, "-17.7952306", "25.1711298"),
("Khakhea", "Khakhea", "Khakhea", NULL, 145, 0, 1, NULL, "-24.700428", "23.507374"),
("Khudumelapye", "Khudumelapye", "Khudumelapye", NULL, 145, 0, 1, NULL, "-23.883333", "24.75"),
("Kopong", "Kopong", "Kopong", NULL, 145, 0, 1, NULL, "-24.4770763", "25.8906212"),
("Kurametsi", "Kurametsi", "Kurametsi", NULL, 145, 0, 1, NULL, "4.2593168", "72.9822258"),
("Lechen", "Lechen", "Lechen", NULL, 145, 0, 1, NULL, "47.33783", "16.01357"),
("Lehututu", "Lehututu", "Lehututu", NULL, 145, 0, 1, NULL, "-23.9338203", "21.8449346"),
("Lenchwe Le Tau", "Lenchwe Le Tau", "Lenchwe Le Tau", NULL, 145, 0, 1, NULL, "-24.383333", "25.85"),
("Letlhakane", "Letlhakane", "Letlhakane", NULL, 145, 0, 1, NULL, "-21.4096214", "25.5858711"),
("Letlhakeng", "Letlhakeng", "Letlhakeng", NULL, 145, 0, 1, NULL, "-24.097317", "25.0288051"),
("Lobatse", "Lobatse", "Lobatse", NULL, 145, 0, 1, NULL, "-25.2076148", "25.6805868"),
("Lokwabe", "Lokwabe", "Lokwabe", NULL, 145, 0, 1, NULL, "-24.166667", "21.833333"),
("Maapi", "Maapi", "Maapi", NULL, 145, 0, 1, NULL, "-22.766667", "27.333333"),
("Mabuli", "Mabuli", "Mabuli", NULL, 145, 0, 1, NULL, "-25.783333", "24.6"),
("Machaneng", "Machaneng", "Machaneng", NULL, 145, 0, 1, NULL, "-23.1862263", "27.4879378"),
("Magothla", "Magothla", "Magothla", NULL, 145, 0, 1, NULL, "-23.566667", "27"),
("Mahalapye", "Mahalapye", "Mahalapye", NULL, 145, 0, 1, NULL, "-23.107801", "26.8321332"),
("Makaleng", "Makaleng", "Makaleng", NULL, 145, 0, 1, NULL, "-20.9", "27.283333"),
("Makoba", "Makoba", "Makoba", NULL, 145, 0, 1, NULL, "-23.4833329", "27.116667"),
("Makwata", "Makwata", "Makwata", NULL, 145, 0, 1, NULL, "-23.313551", "27.283279"),
("Manyana", "Manyana", "Manyana", NULL, 145, 0, 1, NULL, "-24.7711226", "25.5897031"),
("Masunga", "Masunga", "Masunga", NULL, 145, 0, 1, NULL, "-20.666667", "27.416667"),
("Matangwan", "Matangwan", "Matangwan", NULL, 145, 0, 1, NULL, "-20.9977174", "27.3352044"),
("Mathathane", "Mathathane", "Mathathane", NULL, 145, 0, 1, NULL, "-22.2657604", "28.7460373"),
("Matlakola", "Matlakola", "Matlakola", NULL, 145, 0, 1, NULL, "-22.6", "27.366667"),
("Metsemotlhaba", "Metsemotlhaba", "Metsemotlhaba", NULL, 145, 0, 1, NULL, "-24.6646281", "25.9412706"),
("Mmathubudukwane", "Mmathubudukwane", "Mmathubudukwane", NULL, 145, 0, 1, NULL, "-24.6", "26.43"),
("Mmopone", "Mmopone", "Mmopone", NULL, 145, 0, 1, NULL, "-24.5685435", "25.8728782"),
("Mogapi", "Mogapi", "Mogapi", NULL, 145, 0, 1, NULL, "-22.3281412", "27.8252814");
