REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug, s_phone_code, s_name_native, s_currency) VALUES 
('UG', 'Uganda', 'uganda', '256', 'Uganda', 'UGX');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000329, 'UG', 'Abim District', 1, 'abim-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000361, 'UG', 'Adjumani District', 1, 'adjumani-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000392, 'UG', 'Agago District', 1, 'agago-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000344, 'UG', 'Alebtong District', 1, 'alebtong-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000416, 'UG', 'Amolatar District', 1, 'amolatar-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000353, 'UG', 'Amudat District', 1, 'amudat-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000352, 'UG', 'Amuria District', 1, 'amuria-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000335, 'UG', 'Amuru District', 1, 'amuru-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000328, 'UG', 'Apac District', 1, 'apac-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000447, 'UG', 'Arua District', 1, 'arua-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000441, 'UG', 'Budaka District', 1, 'budaka-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000349, 'UG', 'Bududa District', 1, 'bududa-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000387, 'UG', 'Bugiri District', 1, 'bugiri-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000391, 'UG', 'Buhweju District', 1, 'buhweju-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000377, 'UG', 'Buikwe District', 1, 'buikwe-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000343, 'UG', 'Bukedea District', 1, 'bukedea-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000375, 'UG', 'Bukomansimbi District', 1, 'bukomansimbi-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000385, 'UG', 'Bukwo District', 1, 'bukwo-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000428, 'UG', 'Bulambuli District', 1, 'bulambuli-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000389, 'UG', 'Buliisa District', 1, 'buliisa-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000419, 'UG', 'Bundibugyo District', 1, 'bundibugyo-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000381, 'UG', 'Bunyangabu District', 1, 'bunyangabu-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000386, 'UG', 'Bushenyi District', 1, 'bushenyi-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000431, 'UG', 'Busia District', 1, 'busia-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000365, 'UG', 'Butaleja District', 1, 'butaleja-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000384, 'UG', 'Butambala District', 1, 'butambala-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000388, 'UG', 'Butebo District', 1, 'butebo-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000414, 'UG', 'Buvuma District', 1, 'buvuma-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000380, 'UG', 'Buyende District', 1, 'buyende-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000396, 'UG', 'Central Region', 1, 'central-region');

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 
(1110880, 1000396, 'UG', 'Bukomansimbi District', 1, 'bukomansimbi-district', -0.12855000, 31.62527000),
(1110886, 1000396, 'UG', 'Buvuma District', 1, 'buvuma-district', -0.36744000, 33.20071000),
(1110888, 1000396, 'UG', 'Bweyogerere', 1, 'bweyogerere', 0.35773000, 32.66332000),
(1110890, 1000396, 'UG', 'Byakabanda', 1, 'byakabanda', -0.74250000, 31.40639000),
(1110891, 1000396, 'UG', 'Entebbe', 1, 'entebbe', 0.05621000, 32.47949000),
(1110893, 1000396, 'UG', 'Gomba District', 1, 'gomba-district', 0.20017000, 31.75023000),
(1110902, 1000396, 'UG', 'Kajansi', 1, 'kajansi', 0.21548000, 32.53453000),
(1110903, 1000396, 'UG', 'Kampala', 1, 'kampala', 0.31628000, 32.58219000),
(1110904, 1000396, 'UG', 'Kampala District', 1, 'kampala-district', 0.33508000, 32.58313000),
(1110907, 1000396, 'UG', 'Kanoni', 1, 'kanoni', 0.17722000, 31.88111000),
(1110911, 1000396, 'UG', 'Kayunga', 1, 'kayunga', 0.70250000, 32.88861000),
(1110913, 1000396, 'UG', 'Kiboga', 1, 'kiboga', 0.91611000, 31.77417000),
(1110917, 1000396, 'UG', 'Kireka', 1, 'kireka', 0.34750000, 32.64917000),
(1110924, 1000396, 'UG', 'Kyotera', 1, 'kyotera', -0.61556000, 31.51750000),
(1110926, 1000396, 'UG', 'Lugazi', 1, 'lugazi', 0.36788000, 32.93760000),
(1110927, 1000396, 'UG', 'Luwero', 1, 'luwero', 0.84917000, 32.47306000),
(1110928, 1000396, 'UG', 'Lyantonde', 1, 'lyantonde', -0.40306000, 31.15722000),
(1110930, 1000396, 'UG', 'Masaka', 1, 'masaka', -0.33379000, 31.73409000),
(1110936, 1000396, 'UG', 'Mityana', 1, 'mityana', 0.41750000, 32.02278000),
(1110939, 1000396, 'UG', 'Mpigi', 1, 'mpigi', 0.22500000, 32.31361000),
(1110940, 1000396, 'UG', 'Mubende', 1, 'mubende', 0.55849000, 31.39489000),
(1110941, 1000396, 'UG', 'Mubende District', 1, 'mubende-district', 0.50000000, 31.50000000),
(1110943, 1000396, 'UG', 'Mukono', 1, 'mukono', 0.35333000, 32.75528000),
(1110944, 1000396, 'UG', 'Nakasongola', 1, 'nakasongola', 1.30889000, 32.45639000),
(1110945, 1000396, 'UG', 'Namasuba', 1, 'namasuba', 0.68944000, 32.42139000),
(1110947, 1000396, 'UG', 'Njeru', 1, 'njeru', 0.44166000, 33.17917000),
(1110957, 1000396, 'UG', 'Sembabule', 1, 'sembabule', -0.07722000, 31.45667000),
(1110961, 1000396, 'UG', 'Wakiso', 1, 'wakiso', 0.40444000, 32.45944000),
(1110962, 1000396, 'UG', 'Wakiso District', 1, 'wakiso-district', 0.23763000, 32.47836000),
(1110963, 1000396, 'UG', 'Wobulenzi', 1, 'wobulenzi', 0.72833000, 32.51222000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000341, 'UG', 'Dokolo District', 1, 'dokolo-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000372, 'UG', 'Eastern Region', 1, 'eastern-region');

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 
(1110878, 1000372, 'UG', 'Bugembe', 1, 'bugembe', 0.48213000, 33.24065000),
(1110879, 1000372, 'UG', 'Bugiri', 1, 'bugiri', 0.57139000, 33.74167000),
(1110881, 1000372, 'UG', 'Bukwa District', 1, 'bukwa-district', 1.27115000, 34.66778000),
(1110882, 1000372, 'UG', 'Bulambuli District', 1, 'bulambuli-district', 1.32055000, 34.28062000),
(1110884, 1000372, 'UG', 'Busembatia', 1, 'busembatia', 0.77725000, 33.62364000),
(1110885, 1000372, 'UG', 'Busia', 1, 'busia', 0.46588000, 34.09221000),
(1110887, 1000372, 'UG', 'Buwenge', 1, 'buwenge', 0.64996000, 33.17128000),
(1110898, 1000372, 'UG', 'Iganga', 1, 'iganga', 0.60917000, 33.46861000),
(1110899, 1000372, 'UG', 'Jinja', 1, 'jinja', 0.43902000, 33.20317000),
(1110905, 1000372, 'UG', 'Kamuli', 1, 'kamuli', 0.94722000, 33.11972000),
(1110909, 1000372, 'UG', 'Kapchorwa', 1, 'kapchorwa', 1.40096000, 34.45038000),
(1110914, 1000372, 'UG', 'Kibuku District', 1, 'kibuku-district', 1.05000000, 33.80879000),
(1110922, 1000372, 'UG', 'Kumi', 1, 'kumi', 1.46083000, 33.93611000),
(1110933, 1000372, 'UG', 'Mayuge', 1, 'mayuge', 0.45972000, 33.48028000),
(1110934, 1000372, 'UG', 'Mbale', 1, 'mbale', 1.08209000, 34.17503000),
(1110955, 1000372, 'UG', 'Pallisa', 1, 'pallisa', 1.14500000, 33.70944000),
(1110958, 1000372, 'UG', 'Sironko', 1, 'sironko', 1.23132000, 34.24773000),
(1110959, 1000372, 'UG', 'Soroti', 1, 'soroti', 1.71464000, 33.61113000),
(1110960, 1000372, 'UG', 'Tororo', 1, 'tororo', 0.69299000, 34.18085000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000366, 'UG', 'Gomba District', 1, 'gomba-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000413, 'UG', 'Gulu District', 1, 'gulu-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000339, 'UG', 'Ibanda District', 1, 'ibanda-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000340, 'UG', 'Iganga District', 1, 'iganga-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000383, 'UG', 'Isingiro District', 1, 'isingiro-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000367, 'UG', 'Jinja District', 1, 'jinja-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000434, 'UG', 'Kaabong District', 1, 'kaabong-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000426, 'UG', 'Kabale District', 1, 'kabale-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000326, 'UG', 'Kabarole District', 1, 'kabarole-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000336, 'UG', 'Kaberamaido District', 1, 'kaberamaido-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000403, 'UG', 'Kagadi District', 1, 'kagadi-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000399, 'UG', 'Kakumiro District', 1, 'kakumiro-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000405, 'UG', 'Kalangala District', 1, 'kalangala-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000398, 'UG', 'Kaliro District', 1, 'kaliro-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000394, 'UG', 'Kalungu District', 1, 'kalungu-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000382, 'UG', 'Kampala District', 1, 'kampala-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000334, 'UG', 'Kamuli District', 1, 'kamuli-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000360, 'UG', 'Kamwenge District', 1, 'kamwenge-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000373, 'UG', 'Kanungu District', 1, 'kanungu-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000432, 'UG', 'Kapchorwa District', 1, 'kapchorwa-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000440, 'UG', 'Kasese District', 1, 'kasese-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000420, 'UG', 'Katakwi District', 1, 'katakwi-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000368, 'UG', 'Kayunga District', 1, 'kayunga-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000436, 'UG', 'Kibaale District', 1, 'kibaale-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000347, 'UG', 'Kiboga District', 1, 'kiboga-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000338, 'UG', 'Kibuku District', 1, 'kibuku-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000355, 'UG', 'Kiruhura District', 1, 'kiruhura-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000346, 'UG', 'Kiryandongo District', 1, 'kiryandongo-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000409, 'UG', 'Kisoro District', 1, 'kisoro-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000348, 'UG', 'Kitgum District', 1, 'kitgum-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000345, 'UG', 'Koboko District', 1, 'koboko-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000401, 'UG', 'Kole District', 1, 'kole-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000443, 'UG', 'Kotido District', 1, 'kotido-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000425, 'UG', 'Kumi District', 1, 'kumi-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000369, 'UG', 'Kween District', 1, 'kween-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000325, 'UG', 'Kyankwanzi District', 1, 'kyankwanzi-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000437, 'UG', 'Kyegegwa District', 1, 'kyegegwa-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000402, 'UG', 'Kyenjojo District', 1, 'kyenjojo-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000448, 'UG', 'Kyotera District', 1, 'kyotera-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000411, 'UG', 'Lamwo District', 1, 'lamwo-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000342, 'UG', 'Lira District', 1, 'lira-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000445, 'UG', 'Luuka District', 1, 'luuka-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000433, 'UG', 'Luwero District', 1, 'luwero-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000417, 'UG', 'Lwengo District', 1, 'lwengo-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000376, 'UG', 'Lyantonde District', 1, 'lyantonde-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000438, 'UG', 'Manafwa District', 1, 'manafwa-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000421, 'UG', 'Maracha District', 1, 'maracha-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000356, 'UG', 'Masaka District', 1, 'masaka-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000354, 'UG', 'Masindi District', 1, 'masindi-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000418, 'UG', 'Mayuge District', 1, 'mayuge-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000350, 'UG', 'Mbale District', 1, 'mbale-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000415, 'UG', 'Mbarara District', 1, 'mbarara-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000435, 'UG', 'Mitooma District', 1, 'mitooma-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000364, 'UG', 'Mityana District', 1, 'mityana-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000395, 'UG', 'Moroto District', 1, 'moroto-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000363, 'UG', 'Moyo District', 1, 'moyo-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000327, 'UG', 'Mpigi District', 1, 'mpigi-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000371, 'UG', 'Mubende District', 1, 'mubende-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000410, 'UG', 'Mukono District', 1, 'mukono-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000393, 'UG', 'Nakapiripirit District', 1, 'nakapiripirit-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000423, 'UG', 'Nakaseke District', 1, 'nakaseke-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000406, 'UG', 'Nakasongola District', 1, 'nakasongola-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000351, 'UG', 'Namayingo District', 1, 'namayingo-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000400, 'UG', 'Namisindwa District', 1, 'namisindwa-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000337, 'UG', 'Namutumba District', 1, 'namutumba-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000430, 'UG', 'Napak District', 1, 'napak-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000446, 'UG', 'Nebbi District', 1, 'nebbi-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000424, 'UG', 'Ngora District', 1, 'ngora-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000332, 'UG', 'Northern Region', 1, 'northern-region');

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 
(1110874, 1000332, 'UG', 'Adjumani', 1, 'adjumani', 3.37786000, 31.79090000),
(1110875, 1000332, 'UG', 'Amudat', 1, 'amudat', 1.95000000, 34.95000000),
(1110876, 1000332, 'UG', 'Apac', 1, 'apac', 1.97556000, 32.53861000),
(1110877, 1000332, 'UG', 'Arua', 1, 'arua', 3.02013000, 30.91105000),
(1110894, 1000332, 'UG', 'Gulu', 1, 'gulu', 2.77457000, 32.29899000),
(1110920, 1000332, 'UG', 'Kitgum', 1, 'kitgum', 3.27833000, 32.88667000),
(1110921, 1000332, 'UG', 'Kotido', 1, 'kotido', 2.98056000, 34.13306000),
(1110925, 1000332, 'UG', 'Lira', 1, 'lira', 2.24990000, 32.89985000),
(1110937, 1000332, 'UG', 'Moroto', 1, 'moroto', 2.53453000, 34.66659000),
(1110938, 1000332, 'UG', 'Moyo', 1, 'moyo', 3.66088000, 31.72474000),
(1110946, 1000332, 'UG', 'Nebbi', 1, 'nebbi', 2.47826000, 31.08893000),
(1110950, 1000332, 'UG', 'Otuke District', 1, 'otuke-district', 2.48372000, 33.34201000),
(1110951, 1000332, 'UG', 'Oyam District', 1, 'oyam-district', 2.38129000, 32.50071000),
(1110952, 1000332, 'UG', 'Pader', 1, 'pader', 3.05000000, 33.21667000),
(1110953, 1000332, 'UG', 'Pader Palwo', 1, 'pader-palwo', 2.80056000, 33.13500000),
(1110954, 1000332, 'UG', 'Paidha', 1, 'paidha', 2.41669000, 30.98551000),
(1110964, 1000332, 'UG', 'Yumbe', 1, 'yumbe', 3.46506000, 31.24689000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000422, 'UG', 'Ntoroko District', 1, 'ntoroko-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000404, 'UG', 'Ntungamo District', 1, 'ntungamo-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000378, 'UG', 'Nwoya District', 1, 'nwoya-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000374, 'UG', 'Omoro District', 1, 'omoro-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000390, 'UG', 'Otuke District', 1, 'otuke-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000397, 'UG', 'Oyam District', 1, 'oyam-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000408, 'UG', 'Pader District', 1, 'pader-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000357, 'UG', 'Pakwach District', 1, 'pakwach-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000412, 'UG', 'Pallisa District', 1, 'pallisa-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000439, 'UG', 'Rakai District', 1, 'rakai-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000358, 'UG', 'Rubanda District', 1, 'rubanda-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000442, 'UG', 'Rubirizi District', 1, 'rubirizi-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000331, 'UG', 'Rukiga District', 1, 'rukiga-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000324, 'UG', 'Rukungiri District', 1, 'rukungiri-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000427, 'UG', 'Sembabule District', 1, 'sembabule-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000333, 'UG', 'Serere District', 1, 'serere-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000407, 'UG', 'Sheema District', 1, 'sheema-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000429, 'UG', 'Sironko District', 1, 'sironko-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000444, 'UG', 'Soroti District', 1, 'soroti-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000359, 'UG', 'Tororo District', 1, 'tororo-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000362, 'UG', 'Wakiso District', 1, 'wakiso-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000370, 'UG', 'Western Region', 1, 'western-region');

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 
(1110883, 1000370, 'UG', 'Bundibugyo', 1, 'bundibugyo', 0.71117000, 30.06469000),
(1110889, 1000370, 'UG', 'Bwizibwera', 1, 'bwizibwera', -0.59167000, 30.62861000),
(1110892, 1000370, 'UG', 'Fort Portal', 1, 'fort-portal', 0.66174000, 30.27480000),
(1110895, 1000370, 'UG', 'Hoima', 1, 'hoima', 1.43314000, 31.35241000),
(1110896, 1000370, 'UG', 'Ibanda', 1, 'ibanda', -0.13398000, 30.49616000),
(1110897, 1000370, 'UG', 'Ibanda District', 1, 'ibanda-district', -0.08100000, 30.55600000),
(1110900, 1000370, 'UG', 'Kabale', 1, 'kabale', -1.24857000, 29.98993000),
(1110901, 1000370, 'UG', 'Kagadi', 1, 'kagadi', 0.93778000, 30.80889000),
(1110906, 1000370, 'UG', 'Kamwenge', 1, 'kamwenge', 0.18660000, 30.45393000),
(1110908, 1000370, 'UG', 'Kanungu', 1, 'kanungu', -0.95750000, 29.78972000),
(1110910, 1000370, 'UG', 'Kasese', 1, 'kasese', 0.18333000, 30.08333000),
(1110912, 1000370, 'UG', 'Kibale', 1, 'kibale', 0.80000000, 31.06667000),
(1110915, 1000370, 'UG', 'Kigorobya', 1, 'kigorobya', 1.61620000, 31.30890000),
(1110916, 1000370, 'UG', 'Kilembe', 1, 'kilembe', 0.19835000, 30.01302000),
(1110918, 1000370, 'UG', 'Kiruhura', 1, 'kiruhura', -0.19664000, 30.84446000),
(1110919, 1000370, 'UG', 'Kisoro', 1, 'kisoro', -1.28538000, 29.68497000),
(1110923, 1000370, 'UG', 'Kyenjojo', 1, 'kyenjojo', 0.63278000, 30.62139000),
(1110929, 1000370, 'UG', 'Margherita', 1, 'margherita', 0.41861000, 29.89111000),
(1110931, 1000370, 'UG', 'Masindi', 1, 'masindi', 1.67444000, 31.71500000),
(1110932, 1000370, 'UG', 'Masindi Port', 1, 'masindi-port', 1.69606000, 32.08608000),
(1110935, 1000370, 'UG', 'Mbarara', 1, 'mbarara', -0.60467000, 30.64851000),
(1110942, 1000370, 'UG', 'Muhororo', 1, 'muhororo', 0.93806000, 30.75944000),
(1110948, 1000370, 'UG', 'Ntungamo', 1, 'ntungamo', -0.87944000, 30.26417000),
(1110949, 1000370, 'UG', 'Nyachera', 1, 'nyachera', -0.90000000, 30.41667000),
(1110956, 1000370, 'UG', 'Rukungiri', 1, 'rukungiri', -0.84111000, 29.94194000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000330, 'UG', 'Yumbe District', 1, 'yumbe-district');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000379, 'UG', 'Zombo District', 1, 'zombo-district');

