
INSERT INTO `#__wj_portal_cities` ( `name`, `localname`, `internationalname`, `stateid`, `countryid`, `isedit`, `enabled`, `serverid`, `latitude`, `longitude`) VALUES 
("Tolagnaro", "Tolagnaro", "Tolanaro", NULL, 169, 0, 1, NULL, "-25.0290132", "46.9966565"),
("Toliara", "Toliara", "Toliara", NULL, 169, 0, 1, NULL, "-23.354173", "43.66966"),
("Fianarantsoa", "Fianarantsoa", "Fianarantsoa", NULL, 169, 0, 1, NULL, "-21.456444", "47.085149"),
("Antsirabe", "Antsirabe", "Antsirabe", NULL, 169, 0, 1, NULL, "-19.871403", "47.034667"),
("Antananarivo", "Antananarivo", "Antananarivo", NULL, 169, 0, 1, NULL, "-18.9100122", "47.5255809"),
("Toamasina", "Toamasina", "Toamasina", NULL, 169, 0, 1, NULL, "-18.1553985", "49.4098352"),
("Mahajanga", "Mahajanga", "Mahajanga", NULL, 169, 0, 1, NULL, "-15.7181492", "46.3172577"),
("Antsiranana", "Antsiranana", "Antsiranana", NULL, 169, 0, 1, NULL, "-12.2779134", "49.2913394"),
("Ambalavao", "Ambalavao", "Ambalavao", NULL, 169, 0, 1, NULL, "-21.8315657", "46.9368047"),
("Ambanja", "Ambanja", "Ambanja", NULL, 169, 0, 1, NULL, "-13.6635336", "48.4537424"),
("Ambato Boeny", "Ambato Boeny", "Ambato Boeny", NULL, 169, 0, 1, NULL, "-16.4708895", "46.7164256"),
("Ambatofinandrahana", "Ambatofinandrahana", "Ambatofinandrahana", NULL, 169, 0, 1, NULL, "-20.5501168", "46.8010727"),
("Ambatolampy", "Ambatolampy", "Ambatolampy", NULL, 169, 0, 1, NULL, "-19.3836846", "47.4392352"),
("Ambatondrazaka", "Ambatondrazaka", "Ambatondrazaka", NULL, 169, 0, 1, NULL, "-17.8336363", "48.4088007"),
("Ambilobe", "Ambilobe", "Ambilobe", NULL, 169, 0, 1, NULL, "-13.2026069", "49.0514094"),
("Amboasary", "Amboasary", "Amboasary", NULL, 169, 0, 1, NULL, "-18.391689", "48.270939"),
("Ambodifotatra", "Ambodifotatra", "Ambodifotatra", NULL, 169, 0, 1, NULL, "-18.3181877", "47.1118527"),
("Ambositra", "Ambositra", "Ambositra", NULL, 169, 0, 1, NULL, "-20.5362627", "47.2459749"),
("Ambovombe", "Ambovombe", "Ambovombe", NULL, 169, 0, 1, NULL, "-25.1720132", "46.0897124"),
("Ampanihy", "Ampanihy", "Ampanihy", NULL, 169, 0, 1, NULL, "-24.6930487", "44.7451765"),
("Amparafaravola", "Amparafaravola", "Amparafaravola", NULL, 169, 0, 1, NULL, "-17.5872806", "48.2219395"),
("Anakao", "Anakao", "Anakao", NULL, 169, 0, 1, NULL, "-23.661004", "43.6495264"),
("Andapa", "Andapa", "Andapa", NULL, 169, 0, 1, NULL, "-14.658228", "49.6452092"),
("Andilamena", "Andilamena", "Andilamena", NULL, 169, 0, 1, NULL, "-17.0127475", "48.571263"),
("Andoany", "Andoany", "Andoany", NULL, 169, 0, 1, NULL, "-13.3970988", "48.2667279"),
("Andovoranto", "Andovoranto", "Andovoranto", NULL, 169, 0, 1, NULL, "-21.1674808", "46.5957488"),
("Anjozorobe", "Anjozorobe", "Anjozorobe", NULL, 169, 0, 1, NULL, "-18.4001194", "47.8699039"),
("Ankazoabo", "Ankazoabo", "Ankazoabo", NULL, 169, 0, 1, NULL, "-21.503481", "45.20956"),
("Ankazobe", "Ankazobe", "Ankazobe", NULL, 169, 0, 1, NULL, "-18.3181877", "47.1118527"),
("Antalaha", "Antalaha", "Antalaha", NULL, 169, 0, 1, NULL, "-14.9061237", "50.2785486"),
("Antanifotsy", "Antanifotsy", "Antanifotsy", NULL, 169, 0, 1, NULL, "-19.6513424", "47.3266162"),
("Antsohihy", "Antsohihy", "Antsohihy", NULL, 169, 0, 1, NULL, "-14.8851268", "47.9960743"),
("Arivonimamo", "Arivonimamo", "Arivonimamo", NULL, 169, 0, 1, NULL, "-19.0098182", "47.1800893"),
("Bealanana", "Bealanana", "Bealanana", NULL, 169, 0, 1, NULL, "-14.5460011", "48.7542899"),
("Belo Tsiribihina", "Belo Tsiribihina", "Belo Tsiribihina", NULL, 169, 0, 1, NULL, "-19.6971554", "44.5431306"),
("Beloha", "Beloha", "Beloha", NULL, 169, 0, 1, NULL, "-20.266667", "48.483333"),
("Beroroha", "Beroroha", "Beroroha", NULL, 169, 0, 1, NULL, "-21.680817", "45.1658261"),
("Betafo", "Betafo", "Betafo", NULL, 169, 0, 1, NULL, "-19.8381858", "46.8567756"),
("Betioky", "Betioky", "Betioky", NULL, 169, 0, 1, NULL, "-23.7219872", "44.3827547"),
("Fandriana", "Fandriana", "Fandriana", NULL, 169, 0, 1, NULL, "-20.2384864", "47.375551"),
("Farafangana", "Farafangana", "Farafangana", NULL, 169, 0, 1, NULL, "-22.817412", "47.818038"),
("Faratsiho", "Faratsiho", "Faratsiho", NULL, 169, 0, 1, NULL, "-19.4021302", "46.9537969"),
("Fenoarivo Atsinanana", "Fenoarivo Atsinanana", "Fenoarivo Atsinanana", NULL, 169, 0, 1, NULL, "-20.083333", "47.95"),
("Fenoarivo Be", "Fenoarivo Be", "Fenoarivo Be", NULL, 169, 0, 1, NULL, "-17.3256545", "49.36706"),
("Fort Dauphin", "Fort Dauphin", "Fort Dauphin", NULL, 169, 0, 1, NULL, "-25.0225309", "46.9853688"),
("Ifanadiana", "Ifanadiana", "Ifanadiana", NULL, 169, 0, 1, NULL, "-21.3032134", "47.6381357"),
("Ihosy", "Ihosy", "Ihosy", NULL, 169, 0, 1, NULL, "-22.4008873", "46.127902"),
("Ikalamavony", "Ikalamavony", "Ikalamavony", NULL, 169, 0, 1, NULL, "-21.1674808", "46.5957488"),
("Ikongo", "Ikongo", "Ikongo", NULL, 169, 0, 1, NULL, "-21.766667", "43.55"),
("Mahanoro", "Mahanoro", "Mahanoro", NULL, 169, 0, 1, NULL, "-19.894468", "48.8070527");
