
INSERT INTO `#__wj_portal_cities` ( `name`, `localname`, `internationalname`, `stateid`, `countryid`, `isedit`, `enabled`, `serverid`, `latitude`, `longitude`) VALUES 
("Sekondi-Takoradi", "Sekondi-Takoradi", "Sekondi-Takoradi", NULL, 161, 0, 1, NULL, "4.927456", "-1.7490216"),
("Cape Coast", "Cape Coast", "Cape Coast", NULL, 161, 0, 1, NULL, "5.107467", "-1.2430793"),
("Accra", "Accra", "Accra", NULL, 161, 0, 1, NULL, "5.5571096", "-0.2012376"),
("Obuasi", "Obuasi", "Obuasi", NULL, 161, 0, 1, NULL, "6.211542", "-1.6894045"),
("Kumasi", "Kumasi", "Kumasi", NULL, 161, 0, 1, NULL, "6.6985605", "-1.6233086"),
("Tema", "Tema", "Tema", NULL, 161, 0, 1, NULL, "5.6596441", "-0.0096592"),
("Koforidua", "Koforidua", "Koforidua", NULL, 161, 0, 1, NULL, "6.100334", "-0.2614572"),
("Sunyani", "Sunyani", "Sunyani", NULL, 161, 0, 1, NULL, "7.3384389", "-2.3309226"),
("Techiman", "Techiman", "Techiman", NULL, 161, 0, 1, NULL, "7.584971", "-1.936401"),
("Tamale", "Tamale", "Tamale", NULL, 161, 0, 1, NULL, "9.4051992", "-0.8423986"),
("Wa", "Wa", "Wa", NULL, 161, 0, 1, NULL, "10.0623261", "-2.5054273"),
("Bolgatanga", "Bolgatanga", "Bolgatanga", NULL, 161, 0, 1, NULL, "10.7853963", "-0.8487322"),
("Ho", "Ho", "Ho", NULL, 161, 0, 1, NULL, "6.6126598", "0.4688932"),
("Aboso", "Aboso", "Aboso", NULL, 161, 0, 1, NULL, "5.3633935", "-1.9477987"),
("Aburi", "Aburi", "Aburi", NULL, 161, 0, 1, NULL, "5.8511836", "-0.1729106"),
("Achiaman", "Achiaman", "Achiaman", NULL, 161, 0, 1, NULL, "5.6931346", "-0.0326531"),
("Agogo", "Agogo", "Agogo", NULL, 161, 0, 1, NULL, "6.7990626", "-1.0849592"),
("Akim Swedru", "Akim Swedru", "Akim Swedru", NULL, 161, 0, 1, NULL, "5.8925146", "-1.0155385"),
("Akropong", "Akropong", "Akropong", NULL, 161, 0, 1, NULL, "5.9779631", "-0.0886948"),
("Akwatia", "Akwatia", "Akwatia", NULL, 161, 0, 1, NULL, "5.5672991", "-0.235186"),
("Anloga", "Anloga", "Anloga", NULL, 161, 0, 1, NULL, "5.7872343", "0.8913523"),
("Apam", "Apam", "Apam", NULL, 161, 0, 1, NULL, "5.2941315", "-0.7390245"),
("Asamankese", "Asamankese", "Asamankese", NULL, 161, 0, 1, NULL, "5.8607314", "-0.6676865"),
("Axim", "Axim", "Axim", NULL, 161, 0, 1, NULL, "4.8665091", "-2.240888"),
("Bawku", "Bawku", "Bawku", NULL, 161, 0, 1, NULL, "11.0541118", "-0.2385387"),
("Bechem", "Bechem", "Bechem", NULL, 161, 0, 1, NULL, "7.0857832", "-2.029768"),
("Begoro", "Begoro", "Begoro", NULL, 161, 0, 1, NULL, "6.3916263", "-0.3795438"),
("Bekwai", "Bekwai", "Bekwai", NULL, 161, 0, 1, NULL, "6.4532257", "-1.5838477"),
("Berekum", "Berekum", "Berekum", NULL, 161, 0, 1, NULL, "7.4576765", "-2.5842062"),
("Bibiani", "Bibiani", "Bibiani", NULL, 161, 0, 1, NULL, "6.4610857", "-2.3172324"),
("Dom", "Dom", "Dom", NULL, 161, 0, 1, NULL, "14.4828718", "121.0326634"),
("Duayaw Nkwanta", "Duayaw Nkwanta", "Duayaw Nkwanta", NULL, 161, 0, 1, NULL, "7.1796355", "-2.1008486"),
("Dunkwa", "Dunkwa", "Dunkwa", NULL, 161, 0, 1, NULL, "5.7731083", "-2.5309352"),
("Ejura", "Ejura", "Ejura", NULL, 161, 0, 1, NULL, "7.3847202", "-1.3589807"),
("Elmina", "Elmina", "Elmina", NULL, 161, 0, 1, NULL, "5.1053378", "-1.3421032"),
("Foso", "Foso", "Foso", NULL, 161, 0, 1, NULL, "5.7022374", "-1.2842887"),
("Gbawe", "Gbawe", "Gbawe", NULL, 161, 0, 1, NULL, "5.5773983", "-0.3136781"),
("Hohoe", "Hohoe", "Hohoe", NULL, 161, 0, 1, NULL, "7.1518505", "0.4738293"),
("Keta", "Keta", "Keta", NULL, 161, 0, 1, NULL, "5.9031249", "0.9868468"),
("Kete Krachi", "Kete Krachi", "Kete Krachi", NULL, 161, 0, 1, NULL, "7.8014452", "-0.0513246"),
("Kibi", "Kibi", "Kibi", NULL, 161, 0, 1, NULL, "6.1683263", "-0.5494198"),
("Kintampo", "Kintampo", "Kintampo", NULL, 161, 0, 1, NULL, "8.0592612", "-1.7295503"),
("Konongo", "Konongo", "Konongo", NULL, 161, 0, 1, NULL, "6.6249454", "-1.2073261"),
("Kpandae", "Kpandae", "Kpandae", NULL, 161, 0, 1, NULL, "8.4705282", "-0.0116586"),
("Kpandu", "Kpandu", "Kpandu", NULL, 161, 0, 1, NULL, "6.990628", "0.2948797"),
("Madina", "Madina", "Madina", NULL, 161, 0, 1, NULL, "5.6731273", "-0.1663851"),
("Mampong", "Mampong", "Mampong", NULL, 161, 0, 1, NULL, "7.053137", "-1.3999969"),
("Mpraeso", "Mpraeso", "Mpraeso", NULL, 161, 0, 1, NULL, "6.6058668", "-0.7117137"),
("Mumford", "Mumford", "Mumford", NULL, 161, 0, 1, NULL, "5.262762", "-0.7580342"),
("Navrongo", "Navrongo", "Navrongo", NULL, 161, 0, 1, NULL, "10.8940247", "-1.0921473");
