REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('KI', 'Kiribati', 'Kiribati', 'kiribati', '686', 'AUD');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(5110215, 'KI', 'Gilbert Islands', 1, 'gilbert-islands'),
(7030940, 'KI', 'Line Islands', 1, 'line-islands'),
(10521379, 'KI', 'Phoenix Islands', 1, 'phoenix-islands');

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 
(5110023, 5110215, 'KI', 'Utiroa Village', 1, 'utiroa-village', -1.21424, 174.75866),
(5110026, 5110215, 'KI', 'Toboiaki Village', 1, 'toboiaki-village', -0.73842, 174.45422),
(5110029, 5110215, 'KI', 'Ukiangang Village', 1, 'ukiangang-village', 3.04983, 172.76247),
(5110030, 5110215, 'KI', 'Ubanteman Village', 1, 'ubanteman-village', 1.93501, 172.93141),
(5110033, 5110215, 'KI', 'Tuarabu Village', 1, 'tuarabu-village', 1.79808, 173.039),
(5110035, 5110215, 'KI', 'Tewai Village', 1, 'tewai-village', -1.44484, 175.01169),
(5110039, 5110215, 'KI', 'Teteirio Village', 1, 'teteirio-village', -1.34313, 175.99926),
(5110041, 5110215, 'KI', 'Temotu Village', 1, 'temotu-village', 2.03535, 173.25847),
(5110043, 5110215, 'KI', 'Terikiai Village', 1, 'terikiai-village', -1.16466, 174.71881),
(5110044, 5110215, 'KI', 'Katabanga Village', 1, 'katabanga-village', -1.50088, 175.06954),
(5110050, 5110215, 'KI', 'Matang Village', 1, 'matang-village', -0.67058, 174.44954),
(5110053, 5110215, 'KI', 'Tekuanga Village', 1, 'tekuanga-village', 2.03004, 173.2855),
(5110054, 5110215, 'KI', 'Tekatirirake Village', 1, 'tekatirirake-village', 0.46667, 173.86667),
(5110055, 5110215, 'KI', 'Tekarakan Village', 1, 'tekarakan-village', 1.99312, 173.25191),
(5110056, 5110215, 'KI', 'Aiwa Village', 1, 'aiwa-village', -1.38825, 174.90226),
(5110060, 5110215, 'KI', 'Tebunginako Village', 1, 'tebunginako-village', 1.91657, 172.94588),
(5110063, 5110215, 'KI', 'Tebikerai Village', 1, 'tebikerai-village', 1.00789, 173.00392),
(5110067, 5110215, 'KI', 'Tebanga Village', 1, 'tebanga-village', 1.71546, 173.00624),
(5110069, 5110215, 'KI', 'Tearinibai Village', 1, 'tearinibai-village', 1.59039, 172.96973),
(5110070, 5110215, 'KI', 'Teaoraereke Village', 1, 'teaoraereke-village', 1.33309, 173.01162),
(5110076, 5110215, 'KI', 'Taratai Village', 1, 'taratai-village', 1.5488, 172.99183),
(5110078, 5110215, 'KI', 'Temanoku Village', 1, 'temanoku-village', -0.59909, 174.3783),
(5110082, 5110215, 'KI', 'Tabontebike Village', 1, 'tabontebike-village', 0.42351, 173.91151),
(5110083, 5110215, 'KI', 'Tanimaiaki Village', 1, 'tanimaiaki-village', 3.10106, 172.87764),
(5110085, 5110215, 'KI', 'Tanaeang Village', 1, 'tanaeang-village', -1.13765, 174.67741),
(5110086, 5110215, 'KI', 'Tamaroa Village', 1, 'tamaroa-village', -2.63211, 176.81625),
(5110088, 5110215, 'KI', 'Taku Village', 1, 'taku-village', -1.52304, 175.06544),
(5110091, 5110215, 'KI', 'Takarano Village', 1, 'takarano-village', 1.94987, 172.91227),
(5110092, 5110215, 'KI', 'Tabutoa Village', 1, 'tabutoa-village', -1.33176, 176.42374),
(5110093, 5110215, 'KI', 'Taburao Village', 1, 'taburao-village', 1.85372, 172.99744),
(5110095, 5110215, 'KI', 'Tabukiniberu Village', 1, 'tabukiniberu-village', -1.33781, 175.98449),
(5110096, 5110215, 'KI', 'Tabuiroa Village', 1, 'tabuiroa-village', 1.8071, 173.03591),
(5110097, 5110215, 'KI', 'Tabuarorae Village', 1, 'tabuarorae-village', -1.94232, 175.57616),
(5110098, 5110215, 'KI', 'Taborio Village', 1, 'taborio-village', 1.52009, 173.00302),
(5110099, 5110215, 'KI', 'Tabonuea Village', 1, 'tabonuea-village', 3.09612, 172.82312),
(5110102, 5110215, 'KI', 'Tabomatang Village', 1, 'tabomatang-village', -1.39711, 176.48118),
(5110103, 5110215, 'KI', 'Taboiaki Village', 1, 'taboiaki-village', -1.36804, 176.01362),
(5110106, 5110215, 'KI', 'Tabiteuea Village', 1, 'tabiteuea-village', 1.42301, 173.09988),
(5110108, 5110215, 'KI', 'Tabiauea Village', 1, 'tabiauea-village', 0.92746, 173.02772),
(5110109, 5110215, 'KI', 'Tabiang Village', 1, 'tabiang-village', -1.29499, 175.95935),
(5110110, 5110215, 'KI', 'Antereen Village', 1, 'antereen-village', -0.86451, 169.52841),
(5110121, 5110215, 'KI', 'Rungata', 1, 'rungata', -1.34244, 176.43567),
(5110122, 5110215, 'KI', 'Rotuma Village', 1, 'rotuma-village', -0.63125, 174.41433),
(5110124, 5110215, 'KI', 'Roreti Village', 1, 'roreti-village', -2.65512, 176.83302),
(5110125, 5110215, 'KI', 'Norauea Village', 1, 'norauea-village', 1.9998, 173.29218),
(5110126, 5110215, 'KI', 'Rongorongo Village', 1, 'rongorongo-village', -1.32041, 175.99223),
(5110131, 5110215, 'KI', 'Rawannawi Village', 1, 'rawannawi-village', 2.05379, 173.26354),
(5110133, 5110215, 'KI', 'Abamakoro Village', 1, 'abamakoro-village', -0.54652, 174.24865),
(5110135, 5110215, 'KI', 'Tabewa Village', 1, 'tabewa-village', -0.85414, 169.52233),
(5110141, 5110215, 'KI', 'Umwa Village', 1, 'umwa-village', -0.87054, 169.54192),
(5110147, 5110215, 'KI', 'Tekabwibwi Village', 1, 'tekabwibwi-village', -1.11824, 174.66317),
(5110150, 5110215, 'KI', 'Nuka Village', 1, 'nuka-village', -1.33045, 175.99513),
(5110151, 5110215, 'KI', 'Nuatabu Village', 1, 'nuatabu-village', 1.56146, 172.97581),
(5110157, 5110215, 'KI', 'Nikutoru Village', 1, 'nikutoru-village', -1.48223, 175.06819),
(5110159, 5110215, 'KI', 'Nikumanu Village', 1, 'nikumanu-village', -1.38369, 176.47431),
(5110166, 5110215, 'KI', 'Benuaroa Village', 1, 'benuaroa-village', -0.56369, 174.30848),
(5110171, 5110215, 'KI', 'Nabeina Village', 1, 'nabeina-village', 1.4358, 173.07918),
(5110174, 5110215, 'KI', 'Muribenua Village', 1, 'muribenua-village', -1.32417, 176.41581),
(5110175, 5110215, 'KI', 'Morikao Village', 1, 'morikao-village', 1.86018, 172.99072),
(5110179, 5110215, 'KI', 'Marenanuka Village', 1, 'marenanuka-village', 1.48735, 173.02637),
(5110182, 5110215, 'KI', 'Manriki Village', 1, 'manriki-village', -1.35567, 176.45098),
(5110183, 5110215, 'KI', 'Manoku Village', 1, 'manoku-village', 0.33198, 173.93818),
(5110190, 5110215, 'KI', 'Kuria Village', 1, 'kuria-village', 1.8576, 172.99257),
(5110193, 5110215, 'KI', 'Kuma Village', 1, 'kuma-village', 3.17315, 172.95972),
(5110195, 5110215, 'KI', 'Koinawa Village', 1, 'koinawa-village', 1.8655, 172.98774),
(5110199, 5110215, 'KI', 'Keuea Village', 1, 'keuea-village', 3.13124, 172.90442),
(5110204, 5110215, 'KI', 'Eriko Village', 1, 'eriko-village', -1.35925, 176.00224),
(5110205, 5110215, 'KI', 'Kariatebike Village', 1, 'kariatebike-village', 0.40456, 173.91988),
(5110206, 5110215, 'KI', 'Teuabu Village', 1, 'teuabu-village', -0.58113, 174.35091),
(5110208, 5110215, 'KI', 'Kabangaki Village', 1, 'kabangaki-village', 0.31373, 173.92941),
(5110210, 5110215, 'KI', 'Aiaki', 1, 'aiaki', -1.89417, 175.61507),
(5110221, 5110215, 'KI', 'Eita Village', 1, 'eita-village', -1.178, 174.72788),
(5110228, 5110215, 'KI', 'Buota Village', 1, 'buota-village', 2.01543, 173.26007),
(5110230, 5110215, 'KI', 'Buariki Village', 1, 'buariki-village', 1.60909, 172.95526),
(5110235, 5110215, 'KI', 'Borotiam Village', 1, 'borotiam-village', 1.89521, 172.97102),
(5110239, 5110215, 'KI', 'Binoinano', 1, 'binoinano', 0.40868, 173.91622),
(5110248, 5110215, 'KI', 'Betio Village', 1, 'betio-village', 1.35797, 172.92105),
(5110253, 5110215, 'KI', 'Baretoa Village', 1, 'baretoa-village', 0.43012, 173.90597),
(5110254, 5110215, 'KI', 'Banraeaba Village', 1, 'banraeaba-village', 1.3454, 173.03464),
(5110257, 5110215, 'KI', 'Tarawa', 1, 'tarawa', 1.3278, 172.97696),
(5110260, 5110215, 'KI', 'Autukia Village', 1, 'autukia-village', -0.65078, 174.43715),
(5110262, 5110215, 'KI', 'Autokia Village', 1, 'autokia-village', -1.29682, 175.97009),
(5110273, 5110215, 'KI', 'Aonobuaka Village', 1, 'aonobuaka-village', 1.87901, 172.98506),
(5110274, 5110215, 'KI', 'Aoniman Village', 1, 'aoniman-village', -1.30923, 175.98555),
(5110275, 5110215, 'KI', 'Antai Village', 1, 'antai-village', 2.03773, 173.28219),
(5110282, 5110215, 'KI', 'Abatao Village', 1, 'abatao-village', 1.39914, 173.11836),
(5110285, 5110215, 'KI', 'Abaokoro Village', 1, 'abaokoro-village', 1.49702, 173.01528),
(7030892, 7030940, 'KI', 'Tanekore Village', 1, 'tanekore-village', 4.69683, -160.40557),
(7030912, 7030940, 'KI', 'Fareturaina - Gilberts Village', 1, 'fareturaina-gilberts-village', 3.81386, -159.3115),
(7030924, 7030940, 'KI', 'Napia Village', 1, 'napia-village', 3.8549, -159.36023),
(7030926, 7030940, 'KI', 'Napari Village', 1, 'napari-village', 3.90806, -159.38832),
(7030939, 7030940, 'KI', 'London Village', 1, 'london-village', 1.98487, -157.47502),
(10521823, 7030940, 'KI', 'Abaiang Village', 1, 'abaiang-village', 4.68883, -160.36597),
(10521824, 7030940, 'KI', 'Tekaitara Village', 1, 'tekaitara-village', 4.69717, -160.38724),
(10521825, 7030940, 'KI', 'Uteute Village', 1, 'uteute-village', 4.69384, -160.37814),
(10521826, 7030940, 'KI', 'Kauamwmwe Village', 1, 'kauamwmwe-village', 4.69053, -160.37121),
(10521827, 7030940, 'KI', 'Arabata Village', 1, 'arabata-village', 4.67951, -160.39743),
(10521828, 7030940, 'KI', 'Onouea Village', 1, 'onouea-village', 4.67053, -160.37597),
(10521829, 7030940, 'KI', 'Makeitari Village', 1, 'makeitari-village', 4.67229, -160.38084),
(10521843, 7030940, 'KI', 'Aramari Gilberts Village', 1, 'aramari-gilberts-village', 3.81773, -159.32555),
(10521875, 7030940, 'KI', 'Tereitaki Village', 1, 'tereitaki-village', 3.90365, -159.3875),
(10521883, 7030940, 'KI', 'Aontena Gilberts Village', 1, 'aontena-gilberts-village', 3.85049, -159.36083),
(10521898, 7030940, 'KI', 'Poland Village', 1, 'poland-village', 1.8648, -157.55154),
(10521902, 7030940, 'KI', 'Tabwakea Village', 1, 'tabwakea-village', 2.01643, -157.48773),
(10521903, 7030940, 'KI', 'Banana Village', 1, 'banana-village', 1.98329, -157.36526),
(10576145, 10521379, 'KI', 'Kanton Village', 1, 'kanton-village', -2.77677, -171.71679),
(10576334, 5110215, 'KI', 'Bakaka Village', 1, 'bakaka-village', -2.50016, 175.9798),
(10576335, 5110215, 'KI', 'Barebuka Village', 1, 'barebuka-village', -2.49252, 175.96983),
(10576338, 5110215, 'KI', 'Bakarawa Village', 1, 'bakarawa-village', -2.51001, 175.9876),
(10576349, 5110215, 'KI', 'Tekawa Village', 1, 'tekawa-village', -1.80065, 175.52548),
(10576351, 5110215, 'KI', 'Temao Village', 1, 'temao-village', -1.83356, 175.54998),
(10576352, 5110215, 'KI', 'Tanaeag Village', 1, 'tanaeag-village', -1.80768, 175.53626),
(10576355, 5110215, 'KI', 'Otowae Village', 1, 'otowae-village', -1.86934, 175.58329),
(10576468, 7030940, 'KI', 'Matanibike Village', 1, 'matanibike-village', 4.69048, -160.40895),
(10576469, 7030940, 'KI', 'Tereitannano Village', 1, 'tereitannano-village', 3.83401, -159.34753),
(10576470, 7030940, 'KI', 'Tenenebo Village', 1, 'tenenebo-village', 3.84418, -159.3527),
(10576471, 7030940, 'KI', 'Betania Village', 1, 'betania-village', 3.89526, -159.38612),
(10576540, 5110215, 'KI', 'Tekaman Village', 1, 'tekaman-village', -1.13064, 174.6633),
(10576545, 5110215, 'KI', 'Bangai Village', 1, 'bangai-village', -1.35622, 174.87231),
(10576548, 5110215, 'KI', 'Tenatorua Village', 1, 'tenatorua-village', -1.34226, 174.85152),
(10576551, 5110215, 'KI', 'Kabuna Village', 1, 'kabuna-village', -1.28832, 174.79831),
(10576554, 5110215, 'KI', 'Tauma Village', 1, 'tauma-village', -1.2379, 174.78423),
(10576567, 5110215, 'KI', 'Taungaeaka Village', 1, 'taungaeaka-village', -1.45584, 175.03271),
(10576711, 5110215, 'KI', 'Takaeang Village', 1, 'takaeang-village', 0.17097, 173.56183),
(10576712, 5110215, 'KI', 'Baurua Village', 1, 'baurua-village', 0.1272, 173.61556),
(10576761, 5110215, 'KI', 'Oneeke Village', 1, 'oneeke-village', 0.25123, 173.39321),
(10576763, 5110215, 'KI', 'Manenaua Village', 1, 'manenaua-village', 0.24617, 173.39874),
(10576767, 5110215, 'KI', 'Bouatoa Village', 1, 'bouatoa-village', 0.20237, 173.4195),
(10576769, 5110215, 'KI', 'Abatiku Village', 1, 'abatiku-village', 0.38843, 173.77701),
(10576772, 5110215, 'KI', 'Bike Village', 1, 'bike-village', 0.34478, 173.84823),
(10576781, 5110215, 'KI', 'Bangotantekabaia Village', 1, 'bangotantekabaia-village', 0.37881, 173.92731),
(10576798, 5110215, 'KI', 'Kauma Village', 1, 'kauma-village', 0.46166, 173.87358),
(10576828, 5110215, 'KI', 'Tekaranga Village', 1, 'tekaranga-village', 1.00099, 173.03198),
(10576830, 5110215, 'KI', 'Tematantongo Village', 1, 'tematantongo-village', 0.99252, 173.04556),
(10576832, 5110215, 'KI', 'Bubutei Village', 1, 'bubutei-village', 0.87222, 173.00394),
(10576833, 5110215, 'KI', 'Raweai Village', 1, 'raweai-village', 0.8995, 173.01838),
(10576839, 5110215, 'KI', 'Aobike Village', 1, 'aobike-village', 0.98483, 173.05351),
(10576841, 5110215, 'KI', 'Temwangaua Village', 1, 'temwangaua-village', 0.9642, 173.06367),
(10576842, 5110215, 'KI', 'Toora Village', 1, 'toora-village', 0.95956, 173.06285),
(10576843, 5110215, 'KI', 'Tebwangetua Village', 1, 'tebwangetua-village', 0.93847, 173.03969),
(10576844, 5110215, 'KI', 'Teitai Village', 1, 'teitai-village', 0.93525, 173.03587),
(10576851, 5110215, 'KI', 'Bainuna Village', 1, 'bainuna-village', 1.98638, 173.29798),
(10576909, 5110215, 'KI', 'Makin Village', 1, 'makin-village', 3.3644, 172.98352),
(10576912, 5110215, 'KI', 'Kiebu Village', 1, 'kiebu-village', 3.32342, 172.97462),
(10576955, 5110215, 'KI', 'Bikati Village', 1, 'bikati-village', 3.26, 172.68804),
(10576961, 5110215, 'KI', 'Tanimainiku Village', 1, 'tanimainiku-village', 3.09911, 172.89538),
(10576989, 5110215, 'KI', 'Nuotaea Village', 1, 'nuotaea-village', 1.88623, 172.8068),
(10576993, 5110215, 'KI', 'Ribono Village', 1, 'ribono-village', 1.96245, 172.86302),
(10577004, 5110215, 'KI', 'Aoneaba Village', 1, 'aoneaba-village', 1.71895, 173.01948),
(10577007, 5110215, 'KI', 'Tebero Village', 1, 'tebero-village', 1.82077, 173.02136),
(10577063, 5110215, 'KI', 'Tebangaroi Village', 1, 'tebangaroi-village', 1.55535, 172.98559),
(10577069, 5110215, 'KI', 'Tanaea Village', 1, 'tanaea-village', 1.38831, 173.13421),
(10577077, 5110215, 'KI', 'Kainaba Village', 1, 'kainaba-village', 1.45383, 173.06095),
(10577078, 5110215, 'KI', 'Tabonibara Village', 1, 'tabonibara-village', 1.47811, 173.02974),
(10601762, 5110215, 'KI', 'Bairiki Village', 1, 'bairiki-village', 1.32924, 172.97522),
(10601763, 5110215, 'KI', 'Nanikai Village', 1, 'nanikai-village', 1.33015, 172.9978),
(10601765, 5110215, 'KI', 'Ambo Village', 1, 'ambo-village', 1.35317, 173.04259),
(10601768, 5110215, 'KI', 'Bonriki Village', 1, 'bonriki-village', 1.38081, 173.13887),
(10601770, 5110215, 'KI', 'Temaiku Village', 1, 'temaiku-village', 1.36292, 173.16226),
(10601771, 5110215, 'KI', 'Nawerewere Village', 1, 'nawerewere-village', 1.36362, 173.13935),
(10601774, 5110215, 'KI', 'Bikenibeu Village', 1, 'bikenibeu-village', 1.3673, 173.12415),
(10601777, 5110215, 'KI', 'Tangintebu Village', 1, 'tangintebu-village', 1.35769, 173.07029),
(10601778, 5110215, 'KI', 'Abarao Village', 1, 'abarao-village', 1.36301, 173.10965),
(10601779, 5110215, 'KI', 'Antebuka Village', 1, 'antebuka-village', 1.34009, 173.02698);