REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug, s_phone_code, s_name_native, s_currency) VALUES 
('UA', 'Ukraine', 'ukraine', '380', 'Україна', 'UAH');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004689, 'UA', 'Autonomous Republic of Crimea', 1, 'autonomous-republic-of-crimea');

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 
(1109305, 1004689, 'UA', 'Abrikosovka', 1, 'abrikosovka', 45.10759000, 35.10139000),
(1109306, 1004689, 'UA', 'Abrikosovo', 1, 'abrikosovo', 45.69236000, 34.10156000),
(1109308, 1004689, 'UA', 'Aeroflotskiy', 1, 'aeroflotskiy', 45.01816000, 33.99961000),
(1109309, 1004689, 'UA', 'Agrarnoye', 1, 'agrarnoye', 45.01596000, 34.05725000),
(1109310, 1004689, 'UA', 'Akimovka', 1, 'akimovka', 45.51981000, 34.82438000),
(1109313, 1004689, 'UA', 'Aleksandrovka', 1, 'aleksandrovka', 45.57654000, 34.09947000),
(1109314, 1004689, 'UA', 'Alekseyevka', 1, 'alekseyevka', 45.58194000, 33.62980000),
(1109315, 1004689, 'UA', 'Alupka', 1, 'alupka', 44.41808000, 34.04531000),
(1109316, 1004689, 'UA', 'Alushta', 1, 'alushta', 44.67728000, 34.40970000),
(1109317, 1004689, 'UA', 'Amurskoye', 1, 'amurskoye', 45.27822000, 34.12823000),
(1109327, 1004689, 'UA', 'Armyansk', 1, 'armyansk', 46.10919000, 33.69206000),
(1109328, 1004689, 'UA', 'Aromatnoye', 1, 'aromatnoye', 45.03678000, 34.39921000),
(1109336, 1004689, 'UA', 'Azovskoye', 1, 'azovskoye', 45.58604000, 34.56680000),
(1109338, 1004689, 'UA', 'Baherove', 1, 'baherove', 45.37417000, 36.29705000),
(1109339, 1004689, 'UA', 'Bakhchysarai', 1, 'bakhchysarai', 44.75525000, 33.85782000),
(1109340, 1004689, 'UA', 'Bakhchysarai Raion', 1, 'bakhchysarai-raion', 44.75002000, 33.86330000),
(1109356, 1004689, 'UA', 'Batal’noye', 1, 'batal-noye', 45.19402000, 35.61583000),
(1109363, 1004689, 'UA', 'Belinskoye', 1, 'belinskoye', 45.37465000, 36.08212000),
(1109364, 1004689, 'UA', 'Beloglinka', 1, 'beloglinka', 44.99490000, 34.04167000),
(1109365, 1004689, 'UA', 'Belogorskiy rayon', 1, 'belogorskiy-rayon', 45.06300000, 34.55675000),
(1109372, 1004689, 'UA', 'Beregovoye', 1, 'beregovoye', 45.09470000, 35.43385000),
(1109384, 1004689, 'UA', 'Berezovka', 1, 'berezovka', 45.57471000, 33.34397000),
(1109399, 1004689, 'UA', 'Bilohirsk', 1, 'bilohirsk', 45.05462000, 34.60185000),
(1109412, 1004689, 'UA', 'Blizhneye', 1, 'blizhneye', 45.05694000, 35.33056000),
(1109417, 1004689, 'UA', 'Bogatoye', 1, 'bogatoye', 45.02933000, 34.76732000),
(1109438, 1004689, 'UA', 'Botanicheskoye', 1, 'botanicheskoye', 45.78656000, 33.54856000),
(1109444, 1004689, 'UA', 'Bratskoye', 1, 'bratskoye', 45.83170000, 33.92151000),
(1109470, 1004689, 'UA', 'Chapayevka', 1, 'chapayevka', 45.28119000, 34.89428000),
(1109474, 1004689, 'UA', 'Chaykino', 1, 'chaykino', 45.08223000, 34.08673000),
(1109476, 1004689, 'UA', 'Chelyadinovo', 1, 'chelyadinovo', 45.20729000, 36.37620000),
(1109489, 1004689, 'UA', 'Chernomorskiy rayon', 1, 'chernomorskiy-rayon', 45.48798000, 32.92614000),
(1109490, 1004689, 'UA', 'Chernomorskoye', 1, 'chernomorskoye', 45.50657000, 32.69776000),
(1109491, 1004689, 'UA', 'Chernopolye', 1, 'chernopolye', 45.04399000, 34.63916000),
(1109492, 1004689, 'UA', 'Chernovo', 1, 'chernovo', 45.50833000, 33.93397000),
(1109493, 1004689, 'UA', 'Chernozemnoye', 1, 'chernozemnoye', 45.40808000, 34.81990000),
(1109497, 1004689, 'UA', 'Chernyshevo', 1, 'chernyshevo', 45.78202000, 33.42825000),
(1109503, 1004689, 'UA', 'Chervonoye', 1, 'chervonoye', 45.12294000, 33.68662000),
(1109505, 1004689, 'UA', 'Chisten’koye', 1, 'chisten-koye', 44.88152000, 34.04716000),
(1109506, 1004689, 'UA', 'Chistopolye', 1, 'chistopolye', 45.36541000, 36.18312000),
(1109507, 1004689, 'UA', 'Chkalovo', 1, 'chkalovo', 45.60474000, 34.83395000),
(1109527, 1004689, 'UA', 'Dachnoye', 1, 'dachnoye', 44.88448000, 34.98333000),
(1109528, 1004689, 'UA', 'Dalekoye', 1, 'dalekoye', 45.66006000, 33.08059000),
(1109543, 1004689, 'UA', 'Dmitrovka', 1, 'dmitrovka', 45.48411000, 35.05880000),
(1109547, 1004689, 'UA', 'Dneprovka', 1, 'dneprovka', 45.71373000, 34.36256000),
(1109560, 1004689, 'UA', 'Dobroye', 1, 'dobroye', 44.86632000, 34.22661000),
(1109561, 1004689, 'UA', 'Dobrushino', 1, 'dobrushino', 45.37441000, 33.36547000),
(1109564, 1004689, 'UA', 'Dolinnoye', 1, 'dolinnoye', 44.75320000, 33.77766000),
(1109571, 1004689, 'UA', 'Donskoye', 1, 'donskoye', 45.04509000, 34.21413000),
(1109577, 1004689, 'UA', 'Drofino', 1, 'drofino', 45.28629000, 34.61589000),
(1109582, 1004689, 'UA', 'Dubki', 1, 'dubki', 44.93581000, 34.02355000),
(1109592, 1004689, 'UA', 'Dzhankoy', 1, 'dzhankoy', 45.71168000, 34.39274000),
(1109593, 1004689, 'UA', 'Dzhankoyskiy rayon', 1, 'dzhankoyskiy-rayon', 45.78706000, 34.39197000),
(1109599, 1004689, 'UA', 'Feodosiya', 1, 'feodosiya', 45.03677000, 35.37789000),
(1109600, 1004689, 'UA', 'Filatovka', 1, 'filatovka', 46.08192000, 33.78510000),
(1109602, 1004689, 'UA', 'Fontany', 1, 'fontany', 44.89717000, 34.07297000),
(1109603, 1004689, 'UA', 'Foros', 1, 'foros', 44.39214000, 33.78798000),
(1109604, 1004689, 'UA', 'Frunze', 1, 'frunze', 45.02688000, 33.62956000),
(1109605, 1004689, 'UA', 'Gaspra', 1, 'gaspra', 44.43364000, 34.10297000),
(1109606, 1004689, 'UA', 'Geroyskoye', 1, 'geroyskoye', 45.13857000, 33.74675000),
(1109607, 1004689, 'UA', 'Glazovka', 1, 'glazovka', 45.38792000, 36.57965000),
(1109608, 1004689, 'UA', 'Golubinka', 1, 'golubinka', 44.59382000, 33.91521000),
(1109609, 1004689, 'UA', 'Gornostayevka', 1, 'gornostayevka', 45.27819000, 36.18601000),
(1109610, 1004689, 'UA', 'Gorodskoy okrug Alushta', 1, 'gorodskoy-okrug-alushta', 44.67256000, 34.41467000),
(1109611, 1004689, 'UA', 'Gorodskoy okrug Armyansk', 1, 'gorodskoy-okrug-armyansk', 46.10871000, 33.69095000),
(1109612, 1004689, 'UA', 'Gorodskoy okrug Dzhankoy', 1, 'gorodskoy-okrug-dzhankoy', 45.70810000, 34.39407000),
(1109613, 1004689, 'UA', 'Gorodskoy okrug Feodosiya', 1, 'gorodskoy-okrug-feodosiya', 45.04612000, 35.37289000),
(1109614, 1004689, 'UA', 'Gorodskoy okrug Krasnoperekopsk', 1, 'gorodskoy-okrug-krasnoperekopsk', 45.95330000, 33.79669000),
(1109615, 1004689, 'UA', 'Gorodskoy okrug Saki', 1, 'gorodskoy-okrug-saki', 45.12780000, 33.60134000),
(1109616, 1004689, 'UA', 'Gorodskoy okrug Simferopol', 1, 'gorodskoy-okrug-simferopol', 44.94803000, 34.10912000),
(1109617, 1004689, 'UA', 'Gorodskoy okrug Sudak', 1, 'gorodskoy-okrug-sudak', 44.91667000, 35.00202000),
(1109618, 1004689, 'UA', 'Gorodskoy okrug Yalta', 1, 'gorodskoy-okrug-yalta', 44.49638000, 34.16336000),
(1109619, 1004689, 'UA', 'Gorodskoy okrug Yevpatoriya', 1, 'gorodskoy-okrug-yevpatoriya', 45.19559000, 33.36342000),
(1109620, 1004689, 'UA', 'Gresovskiy', 1, 'gresovskiy', 45.00804000, 34.02657000),
(1109621, 1004689, 'UA', 'Grishino', 1, 'grishino', 45.64219000, 33.83098000),
(1109622, 1004689, 'UA', 'Grushevka', 1, 'grushevka', 45.02281000, 34.97301000),
(1109623, 1004689, 'UA', 'Gurzuf', 1, 'gurzuf', 44.54624000, 34.27841000),
(1109664, 1004689, 'UA', 'Hvardiiske', 1, 'hvardiiske', 45.11692000, 34.02188000),
(1109669, 1004689, 'UA', 'Ilychyovo', 1, 'ilychyovo', 45.28348000, 35.73864000),
(1109670, 1004689, 'UA', 'Ilyichevo', 1, 'ilyichevo', 45.24524000, 35.07127000),
(1109671, 1004689, 'UA', 'Ilyinka', 1, 'ilyinka', 45.81784000, 33.79482000),
(1109676, 1004689, 'UA', 'Ishun’', 1, 'ishun', 45.92403000, 33.82364000),
(1109685, 1004689, 'UA', 'Ivanovka', 1, 'ivanovka', 45.07200000, 33.66130000),
(1109688, 1004689, 'UA', 'Izobil’noye', 1, 'izobil-noye', 44.70276000, 34.35357000),
(1109689, 1004689, 'UA', 'Izumrudnoye', 1, 'izumrudnoye', 45.73704000, 34.41299000),
(1109692, 1004689, 'UA', 'Izyumovka', 1, 'izyumovka', 45.04437000, 35.13717000),
(1109700, 1004689, 'UA', 'Kalinino', 1, 'kalinino', 45.59521000, 34.22030000),
(1109701, 1004689, 'UA', 'Kalinovka', 1, 'kalinovka', 45.31658000, 35.74643000),
(1109707, 1004689, 'UA', 'Kamenolomnya', 1, 'kamenolomnya', 45.24804000, 33.41773000),
(1109718, 1004689, 'UA', 'Kashtanovoye', 1, 'kashtanovoye', 44.83210000, 34.05912000),
(1109719, 1004689, 'UA', 'Kashtany', 1, 'kashtany', 44.86760000, 33.78995000),
(1109725, 1004689, 'UA', 'Kerch', 1, 'kerch', 45.35310000, 36.47429000),
(1109726, 1004689, 'UA', 'Kerchens\'ka Mis\'ka Rada', 1, 'kerchens-ka-mis-ka-rada', 45.35307000, 36.47414000),
(1109734, 1004689, 'UA', 'Kholmovka', 1, 'kholmovka', 44.65830000, 33.75456000),
(1109750, 1004689, 'UA', 'Kirovo', 1, 'kirovo', 45.22106000, 35.84227000),
(1109752, 1004689, 'UA', 'Kirovske Raion', 1, 'kirovske-raion', 45.15522000, 35.17696000),
(1109753, 1004689, 'UA', 'Kirovskoye', 1, 'kirovskoye', 45.22967000, 35.19987000),
(1109761, 1004689, 'UA', 'Klepinino', 1, 'klepinino', 45.52800000, 34.18315000),
(1109771, 1004689, 'UA', 'Koktebel', 1, 'koktebel', 44.96155000, 35.24660000),
(1109780, 1004689, 'UA', 'Kol’chugino', 1, 'kol-chugino', 44.94367000, 33.78865000),
(1109781, 1004689, 'UA', 'Kol’tsovo', 1, 'kol-tsovo', 45.32807000, 33.44992000),
(1109774, 1004689, 'UA', 'Kolodeznoye', 1, 'kolodeznoye', 45.22682000, 34.33698000),
(1109779, 1004689, 'UA', 'Koloski', 1, 'koloski', 45.26936000, 33.29386000),
(1109784, 1004689, 'UA', 'Komsomol’skoye', 1, 'komsomol-skoye', 45.01900000, 34.03049000),
(1109788, 1004689, 'UA', 'Kondratyevo', 1, 'kondratyevo', 45.63125000, 34.47387000),
(1109790, 1004689, 'UA', 'Konstantinovka', 1, 'konstantinovka', 44.85511000, 34.12069000),
(1109794, 1004689, 'UA', 'Koreiz', 1, 'koreiz', 44.43374000, 34.08516000),
(1109796, 1004689, 'UA', 'Kormovoye', 1, 'kormovoye', 45.50001000, 33.61192000),
(1109812, 1004689, 'UA', 'Kostochkovka', 1, 'kostochkovka', 45.31747000, 34.67418000),
(1109818, 1004689, 'UA', 'Kotel’nikovo', 1, 'kotel-nikovo', 45.36584000, 34.02575000),
(1109822, 1004689, 'UA', 'Kovyl’noye', 1, 'kovyl-noye', 45.69028000, 33.52775000),
(1109830, 1004689, 'UA', 'Krasna Zor\'ka', 1, 'krasna-zor-ka', 45.13432000, 34.04015000),
(1109831, 1004689, 'UA', 'Krasnaya Polyana', 1, 'krasnaya-polyana', 45.48241000, 32.93790000),
(1109834, 1004689, 'UA', 'Krasnoarmeyskoye', 1, 'krasnoarmeyskoye', 45.99103000, 34.03037000),
(1109835, 1004689, 'UA', 'Krasnoflotskoye', 1, 'krasnoflotskoye', 45.31572000, 34.94756000),
(1109836, 1004689, 'UA', 'Krasnogorka', 1, 'krasnogorka', 45.24513000, 35.80739000),
(1109837, 1004689, 'UA', 'Krasnogvardeyskoye', 1, 'krasnogvardeyskoye', 45.50271000, 34.30134000),
(1109839, 1004689, 'UA', 'Krasnohvardiiske Raion', 1, 'krasnohvardiiske-raion', 45.40230000, 34.25464000),
(1109840, 1004689, 'UA', 'Krasnokamenka', 1, 'krasnokamenka', 44.56383000, 34.28877000),
(1109842, 1004689, 'UA', 'Krasnolesye', 1, 'krasnolesye', 44.83259000, 34.23086000),
(1109845, 1004689, 'UA', 'Krasnoperekops’k', 1, 'krasnoperekops-k', 45.95716000, 33.79650000),
(1109844, 1004689, 'UA', 'Krasnoperekopsk Raion', 1, 'krasnoperekopsk-raion', 45.96992000, 33.87990000),
(1109849, 1004689, 'UA', 'Krasnoyarskoye', 1, 'krasnoyarskoye', 45.50661000, 33.26641000),
(1109850, 1004689, 'UA', 'Krasnoye', 1, 'krasnoye', 45.13999000, 34.09452000),
(1109851, 1004689, 'UA', 'Krasnoznamenka', 1, 'krasnoznamenka', 45.28676000, 34.00036000),
(1109852, 1004689, 'UA', 'Krasnyi Mak', 1, 'krasnyi-mak', 44.64218000, 33.78130000),
(1109857, 1004689, 'UA', 'Krayneye', 1, 'krayneye', 45.22993000, 33.83239000),
(1109861, 1004689, 'UA', 'Krest’yanovka', 1, 'krest-yanovka', 45.72268000, 33.93938000),
(1109863, 1004689, 'UA', 'Krinichnoye', 1, 'krinichnoye', 45.02428000, 34.61202000),
(1109869, 1004689, 'UA', 'Krymka', 1, 'krymka', 45.70453000, 34.18782000),
(1109870, 1004689, 'UA', 'Krymskaya Roza', 1, 'krymskaya-roza', 45.05776000, 34.35631000),
(1109871, 1004689, 'UA', 'Krymskoye', 1, 'krymskoye', 45.18836000, 33.80106000),
(1109881, 1004689, 'UA', 'Kuibyshevo', 1, 'kuibyshevo', 44.62900000, 33.86895000),
(1109882, 1004689, 'UA', 'Kukushkino', 1, 'kukushkino', 45.71924000, 33.39030000),
(1109890, 1004689, 'UA', 'Kurskoye', 1, 'kurskoye', 45.02908000, 34.93623000),
(1109968, 1004689, 'UA', 'L’govskoye', 1, 'l-govskoye', 45.09801000, 34.95770000),
(1109910, 1004689, 'UA', 'Lekarstvennoye', 1, 'lekarstvennoye', 44.94194000, 33.82229000),
(1109912, 1004689, 'UA', 'Lenine Raion', 1, 'lenine-raion', 45.24693000, 36.00540000),
(1109913, 1004689, 'UA', 'Lenino', 1, 'lenino', 45.29857000, 35.77708000),
(1109914, 1004689, 'UA', 'Leninskoye', 1, 'leninskoye', 45.26844000, 34.05023000),
(1109915, 1004689, 'UA', 'Lesnovka', 1, 'lesnovka', 45.15350000, 33.61889000),
(1109917, 1004689, 'UA', 'Levadki', 1, 'levadki', 44.87083000, 34.04278000),
(1109919, 1004689, 'UA', 'Listvennoye', 1, 'listvennoye', 45.48086000, 34.81087000),
(1109920, 1004689, 'UA', 'Litvinenkovo', 1, 'litvinenkovo', 45.08648000, 34.31107000),
(1109926, 1004689, 'UA', 'Livadia', 1, 'livadia', 44.47021000, 34.14272000),
(1109927, 1004689, 'UA', 'Lobanovo', 1, 'lobanovo', 45.77552000, 34.24236000),
(1109933, 1004689, 'UA', 'Lozovoye', 1, 'lozovoye', 44.90600000, 34.16414000),
(1109935, 1004689, 'UA', 'Luchistoye', 1, 'luchistoye', 44.73646000, 34.40063000),
(1109936, 1004689, 'UA', 'Luganskoye', 1, 'luganskoye', 45.80190000, 34.23786000),
(1109937, 1004689, 'UA', 'Lugovoye', 1, 'lugovoye', 45.23469000, 35.72202000),
(1109969, 1004689, 'UA', 'Magazinka', 1, 'magazinka', 45.86312000, 34.04969000),
(1109982, 1004689, 'UA', 'Malen’koye', 1, 'malen-koye', 45.07585000, 33.99942000),
(1109985, 1004689, 'UA', 'Malorechenskoye', 1, 'malorechenskoye', 44.75888000, 34.55789000),
(1109987, 1004689, 'UA', 'Maly Mayak', 1, 'maly-mayak', 44.61356000, 34.36469000),
(1110005, 1004689, 'UA', 'Mar’yanovka', 1, 'mar-yanovka', 45.44627000, 34.29474000),
(1109998, 1004689, 'UA', 'Marfovka', 1, 'marfovka', 45.19853000, 36.09144000),
(1110004, 1004689, 'UA', 'Maryevka', 1, 'maryevka', 45.11330000, 36.23992000),
(1110006, 1004689, 'UA', 'Maslovo', 1, 'maslovo', 45.79197000, 34.36298000),
(1110007, 1004689, 'UA', 'Massandra', 1, 'massandra', 44.50958000, 34.18817000),
(1110010, 1004689, 'UA', 'Mayskoye', 1, 'mayskoye', 45.59555000, 34.55213000),
(1110011, 1004689, 'UA', 'Mazanka', 1, 'mazanka', 45.00550000, 34.25581000),
(1110013, 1004689, 'UA', 'Medvedevka', 1, 'medvedevka', 45.88389000, 34.55562000),
(1110014, 1004689, 'UA', 'Medvedevo', 1, 'medvedevo', 45.38597000, 33.00400000),
(1110020, 1004689, 'UA', 'Mel’nichnoye', 1, 'mel-nichnoye', 45.19885000, 34.42012000),
(1110026, 1004689, 'UA', 'Mezhvodnoye', 1, 'mezhvodnoye', 45.58751000, 32.84501000),
(1110027, 1004689, 'UA', 'Michurinskoye', 1, 'michurinskoye', 45.07430000, 34.70672000),
(1110028, 1004689, 'UA', 'Mikhaylovka', 1, 'mikhaylovka', 45.11325000, 33.61071000),
(1110032, 1004689, 'UA', 'Mirnovka', 1, 'mirnovka', 45.69083000, 34.30966000),
(1110033, 1004689, 'UA', 'Mirnoye', 1, 'mirnoye', 44.98330000, 34.06160000),
(1110034, 1004689, 'UA', 'Mirny', 1, 'mirny', 45.30788000, 33.03501000),
(1110036, 1004689, 'UA', 'Mitrofanovka', 1, 'mitrofanovka', 45.45114000, 34.67883000),
(1110037, 1004689, 'UA', 'Mityayevo', 1, 'mityayevo', 45.23423000, 33.70150000),
(1110046, 1004689, 'UA', 'Molochnoye', 1, 'molochnoye', 45.19960000, 33.22233000),
(1110050, 1004689, 'UA', 'Molodyozhnoye', 1, 'molodyozhnoye', 45.00354000, 34.05634000),
(1110053, 1004689, 'UA', 'Morskoye', 1, 'morskoye', 44.82593000, 34.80314000),
(1110061, 1004689, 'UA', 'Muromskoye', 1, 'muromskoye', 45.09051000, 34.84900000),
(1110064, 1004689, 'UA', 'Muskatnoye', 1, 'muskatnoye', 45.46586000, 34.54316000),
(1110077, 1004689, 'UA', 'Mysovoe', 1, 'mysovoe', 45.44788000, 35.83528000),
(1110083, 1004689, 'UA', 'Nasypnoe', 1, 'nasypnoe', 45.05285000, 35.29415000),
(1110085, 1004689, 'UA', 'Naydenovka', 1, 'naydenovka', 45.27088000, 34.44898000),
(1110088, 1004689, 'UA', 'Nekrasovka', 1, 'nekrasovka', 45.44085000, 34.98584000),
(1110089, 1004689, 'UA', 'Nekrasovo', 1, 'nekrasovo', 45.42453000, 34.28545000),
(1110095, 1004689, 'UA', 'Nikita', 1, 'nikita', 44.51564000, 34.23840000),
(1110096, 1004689, 'UA', 'Nikolayevka', 1, 'nikolayevka', 44.96213000, 33.61061000),
(1110099, 1004689, 'UA', 'Nizhnegorskiy', 1, 'nizhnegorskiy', 45.44789000, 34.73839000),
(1110100, 1004689, 'UA', 'Nizhnegorskiy rayon', 1, 'nizhnegorskiy-rayon', 45.48430000, 34.76798000),
(1110118, 1004689, 'UA', 'Novoandreyevka', 1, 'novoandreyevka', 45.19904000, 34.09384000),
(1110124, 1004689, 'UA', 'Novoestoniya', 1, 'novoestoniya', 45.49960000, 34.24298000),
(1110126, 1004689, 'UA', 'Novofedorovka', 1, 'novofedorovka', 45.09473000, 33.57211000),
(1110127, 1004689, 'UA', 'Novogrigoryevka', 1, 'novogrigoryevka', 45.45200000, 34.60378000),
(1110129, 1004689, 'UA', 'Novoivanovka', 1, 'novoivanovka', 45.44914000, 33.09833000),
(1110130, 1004689, 'UA', 'Novokrymskoye', 1, 'novokrymskoye', 45.78007000, 34.15543000),
(1110136, 1004689, 'UA', 'Novonikolayevka', 1, 'novonikolayevka', 45.30855000, 36.05749000),
(1110138, 1004689, 'UA', 'Novoozyornoye', 1, 'novoozyornoye', 45.38314000, 33.11715000),
(1110139, 1004689, 'UA', 'Novopavlovka', 1, 'novopavlovka', 45.86634000, 33.89018000),
(1110140, 1004689, 'UA', 'Novopokrovka', 1, 'novopokrovka', 45.16517000, 35.25304000),
(1110147, 1004689, 'UA', 'Novosel’skoye', 1, 'novosel-skoye', 45.50357000, 32.72250000),
(1110144, 1004689, 'UA', 'Novoselovskoye', 1, 'novoselovskoye', 45.44276000, 33.59795000),
(1110148, 1004689, 'UA', 'Novostepnoye', 1, 'novostepnoye', 45.66206000, 34.38700000),
(1110149, 1004689, 'UA', 'Novosyolovka', 1, 'novosyolovka', 44.99377000, 33.83525000),
(1110155, 1004689, 'UA', 'Novozhilovka', 1, 'novozhilovka', 45.15960000, 34.23270000),
(1110156, 1004689, 'UA', 'Novy Svet', 1, 'novy-svet', 44.83087000, 34.91370000),
(1110178, 1004689, 'UA', 'Okhotnikovo', 1, 'okhotnikovo', 45.23985000, 33.59405000),
(1110179, 1004689, 'UA', 'Okhotskoye', 1, 'okhotskoye', 45.48612000, 34.86401000),
(1110182, 1004689, 'UA', 'Oktyabr\'skoye', 1, 'oktyabr-skoye', 45.36215000, 36.36803000),
(1110183, 1004689, 'UA', 'Oktyabr’skoye', 1, 'oktyabr-skoye', 45.28866000, 34.13521000),
(1110184, 1004689, 'UA', 'Okunevka', 1, 'okunevka', 45.36855000, 32.76357000),
(1110191, 1004689, 'UA', 'Olenevka', 1, 'olenevka', 45.38333000, 32.53333000),
(1110201, 1004689, 'UA', 'Ordzhonikidze', 1, 'ordzhonikidze', 44.96401000, 35.35576000),
(1110202, 1004689, 'UA', 'Orekhovo', 1, 'orekhovo', 45.12944000, 33.63180000),
(1110204, 1004689, 'UA', 'Orlovskoye', 1, 'orlovskoye', 45.81070000, 33.97308000),
(1110206, 1004689, 'UA', 'Ostanino', 1, 'ostanino', 45.32731000, 35.91295000),
(1110209, 1004689, 'UA', 'Ostrovskoye', 1, 'ostrovskoye', 45.74232000, 34.06607000),
(1110220, 1004689, 'UA', 'Pakharevka', 1, 'pakharevka', 45.83472000, 34.16129000),
(1110223, 1004689, 'UA', 'Partenit', 1, 'partenit', 44.57800000, 34.34464000),
(1110224, 1004689, 'UA', 'Partizanskoye', 1, 'partizanskoye', 44.83379000, 34.08465000),
(1110225, 1004689, 'UA', 'Partizany', 1, 'partizany', 45.14373000, 35.15509000),
(1110243, 1004689, 'UA', 'Pereval\'noye', 1, 'pereval-noye', 44.84838000, 34.31271000),
(1110245, 1004689, 'UA', 'Perovo', 1, 'perovo', 44.92513000, 34.05753000),
(1110248, 1004689, 'UA', 'Pervomayskiy rayon', 1, 'pervomayskiy-rayon', 45.59825000, 33.83249000),
(1110249, 1004689, 'UA', 'Pervomayskoye', 1, 'pervomayskoye', 45.71744000, 33.85596000),
(1110254, 1004689, 'UA', 'Peschanoye', 1, 'peschanoye', 44.84342000, 33.60921000),
(1110260, 1004689, 'UA', 'Petrovka', 1, 'petrovka', 45.49776000, 34.28816000),
(1110272, 1004689, 'UA', 'Pionerskoye', 1, 'pionerskoye', 44.88083000, 34.20194000),
(1110277, 1004689, 'UA', 'Plodovoye', 1, 'plodovoye', 44.87156000, 33.85615000),
(1110280, 1004689, 'UA', 'Pobednoye', 1, 'pobednoye', 45.70109000, 34.44805000),
(1110283, 1004689, 'UA', 'Pochetnoye', 1, 'pochetnoye', 45.99495000, 33.76588000),
(1110295, 1004689, 'UA', 'Poltavka', 1, 'poltavka', 45.35133000, 34.18371000),
(1110305, 1004689, 'UA', 'Poshtove', 1, 'poshtove', 44.83540000, 33.96159000),
(1110307, 1004689, 'UA', 'Pozharskoye', 1, 'pozharskoye', 44.93554000, 33.87109000),
(1110308, 1004689, 'UA', 'Pravda', 1, 'pravda', 45.77903000, 33.84649000),
(1110310, 1004689, 'UA', 'Primorskiy', 1, 'primorskiy', 45.11904000, 35.48025000),
(1110311, 1004689, 'UA', 'Priozyornoye', 1, 'priozyornoye', 45.26990000, 36.33405000),
(1110312, 1004689, 'UA', 'Privetnoye', 1, 'privetnoye', 45.11969000, 35.05960000),
(1110314, 1004689, 'UA', 'Prostornoye', 1, 'prostornoye', 45.65597000, 34.69837000),
(1110315, 1004689, 'UA', 'Prudovoye', 1, 'prudovoye', 44.90424000, 33.78114000),
(1110316, 1004689, 'UA', 'Prudy', 1, 'prudy', 45.23922000, 34.70217000),
(1110326, 1004689, 'UA', 'Pshenichnoye', 1, 'pshenichnoye', 45.64627000, 34.83767000),
(1110329, 1004689, 'UA', 'Pushkino', 1, 'pushkino', 45.20373000, 34.97642000),
(1110333, 1004689, 'UA', 'Pyatikhatka', 1, 'pyatikhatka', 45.32347000, 34.25516000),
(1110348, 1004689, 'UA', 'Razdol’nenskiy rayon', 1, 'razdol-nenskiy-rayon', 45.67086000, 33.44075000),
(1110349, 1004689, 'UA', 'Razdol’noye', 1, 'razdol-noye', 45.77083000, 33.48777000),
(1110358, 1004689, 'UA', 'Rodnikovo', 1, 'rodnikovo', 45.04296000, 33.95407000),
(1110367, 1004689, 'UA', 'Romashkino', 1, 'romashkino', 45.25647000, 33.25517000),
(1110371, 1004689, 'UA', 'Roshchino', 1, 'roshchino', 45.60916000, 34.37992000),
(1110372, 1004689, 'UA', 'Roskoshnoye', 1, 'roskoshnoye', 45.65187000, 34.11552000),
(1110375, 1004689, 'UA', 'Rovnoye', 1, 'rovnoye', 45.35134000, 34.35230000),
(1110389, 1004689, 'UA', 'Ruch’i', 1, 'ruch-i', 45.78564000, 33.66093000),
(1110392, 1004689, 'UA', 'Rusakovka', 1, 'rusakovka', 45.12369000, 34.47458000),
(1110395, 1004689, 'UA', 'Rybach\'e', 1, 'rybach-e', 44.77331000, 34.59609000),
(1110399, 1004689, 'UA', 'Sadovoye', 1, 'sadovoye', 45.31037000, 34.65260000),
(1110402, 1004689, 'UA', 'Saki', 1, 'saki', 45.13424000, 33.59996000),
(1110403, 1004689, 'UA', 'Sakskiy rayon', 1, 'sakskiy-rayon', 45.27799000, 33.52911000),
(1110409, 1004689, 'UA', 'Sary-Bash', 1, 'sary-bash', 45.57142000, 33.78728000),
(1110416, 1004689, 'UA', 'Semisotka', 1, 'semisotka', 45.24676000, 35.56500000),
(1110418, 1004689, 'UA', 'Senokosnoye', 1, 'senokosnoye', 45.73277000, 33.51552000),
(1110421, 1004689, 'UA', 'Serebryanka', 1, 'serebryanka', 45.63937000, 33.49632000),
(1110434, 1004689, 'UA', 'Shchebetovka', 1, 'shchebetovka', 44.93821000, 35.15800000),
(1110437, 1004689, 'UA', 'Shchyolkino', 1, 'shchyolkino', 45.42985000, 35.82250000),
(1110439, 1004689, 'UA', 'Shelkovichnoye', 1, 'shelkovichnoye', 45.18748000, 33.68807000),
(1110446, 1004689, 'UA', 'Shirokoye', 1, 'shirokoye', 45.20029000, 34.05069000),
(1110448, 1004689, 'UA', 'Shkol’noye', 1, 'shkol-noye', 45.05758000, 33.89737000),
(1110452, 1004689, 'UA', 'Shtormovoye', 1, 'shtormovoye', 45.26717000, 33.08693000),
(1110459, 1004689, 'UA', 'Simeiz', 1, 'simeiz', 44.40646000, 34.00704000),
(1110461, 1004689, 'UA', 'Simferopol', 1, 'simferopol', 44.95719000, 34.11079000),
(1110462, 1004689, 'UA', 'Simferopol Raion', 1, 'simferopol-raion', 44.95690000, 34.10225000),
(1110463, 1004689, 'UA', 'Sinitsyno', 1, 'sinitsyno', 45.23862000, 35.24659000),
(1110465, 1004689, 'UA', 'Sizovka', 1, 'sizovka', 45.34892000, 33.87669000),
(1110469, 1004689, 'UA', 'Skalistoye', 1, 'skalistoye', 44.81686000, 33.97791000),
(1110473, 1004689, 'UA', 'Skvortsovo', 1, 'skvortsovo', 45.07542000, 33.82084000),
(1110477, 1004689, 'UA', 'Slavnoye', 1, 'slavnoye', 45.72176000, 33.23689000),
(1110481, 1004689, 'UA', 'Slavyanskoye', 1, 'slavyanskoye', 45.72768000, 33.32165000),
(1110497, 1004689, 'UA', 'Sofiivka', 1, 'sofiivka', 45.08985000, 33.99887000),
(1110501, 1004689, 'UA', 'Sokolinoye', 1, 'sokolinoye', 44.55041000, 33.95897000),
(1110504, 1004689, 'UA', 'Solnechnaya Dolina', 1, 'solnechnaya-dolina', 44.87185000, 35.10622000),
(1110505, 1004689, 'UA', 'Solnechnogorskoye', 1, 'solnechnogorskoye', 44.74722000, 34.53999000),
(1110506, 1004689, 'UA', 'Solnechnoye', 1, 'solnechnoye', 45.04767000, 34.08380000),
(1110517, 1004689, 'UA', 'Sovetskiy', 1, 'sovetskiy', 45.34267000, 34.92463000),
(1110518, 1004689, 'UA', 'Sovietskyi Raion', 1, 'sovietskyi-raion', 45.31516000, 34.92914000),
(1110519, 1004689, 'UA', 'Sovkhoznoye', 1, 'sovkhoznoye', 45.96005000, 33.77155000),
(1110523, 1004689, 'UA', 'Stakhanovka', 1, 'stakhanovka', 45.37062000, 33.94883000),
(1110524, 1004689, 'UA', 'Stal’noye', 1, 'stal-noye', 45.70814000, 34.56238000),
(1110536, 1004689, 'UA', 'Stary Krym', 1, 'stary-krym', 45.02887000, 35.09174000),
(1110549, 1004689, 'UA', 'Stepnoye', 1, 'stepnoye', 45.65212000, 33.77441000),
(1110553, 1004689, 'UA', 'Stolbovoye', 1, 'stolbovoye', 45.36270000, 33.49584000),
(1110556, 1004689, 'UA', 'Strogonovka', 1, 'strogonovka', 44.94970000, 34.17924000),
(1110560, 1004689, 'UA', 'Sudak', 1, 'sudak', 44.84924000, 34.97471000),
(1110565, 1004689, 'UA', 'Susanino', 1, 'susanino', 45.49898000, 33.69854000),
(1110567, 1004689, 'UA', 'Suvorovo', 1, 'suvorovo', 46.08865000, 33.68800000),
(1110568, 1004689, 'UA', 'Suvorovskoye', 1, 'suvorovskoye', 45.25171000, 33.37194000),
(1110576, 1004689, 'UA', 'Svetloye', 1, 'svetloye', 45.63320000, 34.66264000),
(1110586, 1004689, 'UA', 'Tabachnoye', 1, 'tabachnoye', 44.90175000, 33.67638000),
(1110588, 1004689, 'UA', 'Tankovoye', 1, 'tankovoye', 44.65829000, 33.80929000),
(1110596, 1004689, 'UA', 'Tenistoye', 1, 'tenistoye', 44.74303000, 33.66812000),
(1110599, 1004689, 'UA', 'Teplovka', 1, 'teplovka', 45.03239000, 33.69588000),
(1110610, 1004689, 'UA', 'Tokarevo', 1, 'tokarevo', 45.28367000, 35.15244000),
(1110622, 1004689, 'UA', 'Trudovoye', 1, 'trudovoye', 44.99133000, 34.20311000),
(1110628, 1004689, 'UA', 'Tselinnoye', 1, 'tselinnoye', 45.90633000, 34.18063000),
(1110630, 1004689, 'UA', 'Tsvetochnoye', 1, 'tsvetochnoye', 45.08655000, 34.38521000),
(1110638, 1004689, 'UA', 'Turgenevka', 1, 'turgenevka', 44.69747000, 33.83007000),
(1110648, 1004689, 'UA', 'Uglovoye', 1, 'uglovoye', 44.82146000, 33.60452000),
(1110652, 1004689, 'UA', 'Ukrainka', 1, 'ukrainka', 44.88730000, 34.13973000),
(1110653, 1004689, 'UA', 'Ukromnoye', 1, 'ukromnoye', 45.04272000, 34.00312000),
(1110658, 1004689, 'UA', 'Urozhaynoye', 1, 'urozhaynoye', 45.04522000, 34.13511000),
(1110664, 1004689, 'UA', 'Uvarovka', 1, 'uvarovka', 45.45108000, 34.78812000),
(1110665, 1004689, 'UA', 'Uvarovo', 1, 'uvarovo', 45.26260000, 35.66506000),
(1110666, 1004689, 'UA', 'Uyutnoye', 1, 'uyutnoye', 45.19769000, 33.29796000),
(1110676, 1004689, 'UA', 'Vasilyevka', 1, 'vasilyevka', 45.13938000, 34.72291000),
(1110703, 1004689, 'UA', 'Veresayevo', 1, 'veresayevo', 45.30551000, 33.50004000),
(1110711, 1004689, 'UA', 'Verkhorechye', 1, 'verkhorechye', 44.69738000, 33.98696000),
(1110714, 1004689, 'UA', 'Vesele', 1, 'vesele', 44.85807000, 34.87952000),
(1110715, 1004689, 'UA', 'Veselovka', 1, 'veselovka', 45.37733000, 33.21385000),
(1110717, 1004689, 'UA', 'Vilino', 1, 'vilino', 44.84560000, 33.67161000),
(1110721, 1004689, 'UA', 'Vinnitskoye', 1, 'vinnitskoye', 44.98129000, 33.73920000),
(1110723, 1004689, 'UA', 'Vinogradnoye', 1, 'vinogradnoye', 44.48149000, 34.12973000),
(1110724, 1004689, 'UA', 'Vinogradovo', 1, 'vinogradovo', 45.39264000, 33.64668000),
(1110725, 1004689, 'UA', 'Vishennoye', 1, 'vishennoye', 45.14509000, 34.59691000),
(1110726, 1004689, 'UA', 'Vishnyovka', 1, 'vishnyovka', 45.95966000, 33.95289000),
(1110728, 1004689, 'UA', 'Vladimirovka', 1, 'vladimirovka', 45.14760000, 33.57583000),
(1110729, 1004689, 'UA', 'Vladislavovka', 1, 'vladislavovka', 45.16828000, 35.37658000),
(1110731, 1004689, 'UA', 'Voinka', 1, 'voinka', 45.86990000, 33.99138000),
(1110739, 1004689, 'UA', 'Vol’noye', 1, 'vol-noye', 45.56570000, 34.30360000),
(1110740, 1004689, 'UA', 'Vorobyovo', 1, 'vorobyovo', 45.32895000, 33.24654000),
(1110746, 1004689, 'UA', 'Voskhod', 1, 'voskhod', 45.50999000, 34.39355000),
(1110748, 1004689, 'UA', 'Voykovo', 1, 'voykovo', 45.38329000, 36.43739000),
(1110778, 1004689, 'UA', 'Yalta', 1, 'yalta', 44.50218000, 34.16624000),
(1110782, 1004689, 'UA', 'Yantarnoye', 1, 'yantarnoye', 45.43473000, 34.22134000),
(1110785, 1004689, 'UA', 'Yarkoye', 1, 'yarkoye', 45.69120000, 34.26323000),
(1110786, 1004689, 'UA', 'Yarkoye Pole', 1, 'yarkoye-pole', 45.20581000, 35.19848000),
(1110789, 1004689, 'UA', 'Yasnopolyanskoye', 1, 'yasnopolyanskoye', 45.94097000, 34.35262000),
(1110794, 1004689, 'UA', 'Yemelyanovka', 1, 'yemelyanovka', 45.53287000, 34.89624000),
(1110798, 1004689, 'UA', 'Yermakovo', 1, 'yermakovo', 45.85364000, 34.48644000),
(1110800, 1004689, 'UA', 'Yevpatoriya', 1, 'yevpatoriya', 45.20091000, 33.36655000),
(1110813, 1004689, 'UA', 'Zalesye', 1, 'zalesye', 44.88687000, 34.10168000),
(1110819, 1004689, 'UA', 'Zaozyornoye', 1, 'zaozyornoye', 45.15816000, 33.27866000),
(1110822, 1004689, 'UA', 'Zarechnoye', 1, 'zarechnoye', 44.85048000, 34.26426000),
(1110829, 1004689, 'UA', 'Zavet-Leninskiy', 1, 'zavet-leninskiy', 45.86258000, 34.39160000),
(1110830, 1004689, 'UA', 'Zavetnoye', 1, 'zavetnoye', 45.32697000, 34.80837000),
(1110835, 1004689, 'UA', 'Zelenogorskoye', 1, 'zelenogorskoye', 45.01249000, 34.46848000),
(1110836, 1004689, 'UA', 'Zelyonoye', 1, 'zelyonoye', 44.59583000, 34.00921000),
(1110837, 1004689, 'UA', 'Zemlyanichnoye', 1, 'zemlyanichnoye', 44.97444000, 34.83553000),
(1110838, 1004689, 'UA', 'Zernovoye', 1, 'zernovoye', 45.32364000, 34.48099000),
(1110841, 1004689, 'UA', 'Zheleznodorozhnoye', 1, 'zheleznodorozhnoye', 44.71710000, 33.80417000),
(1110842, 1004689, 'UA', 'Zhelyabovka', 1, 'zhelyabovka', 45.39877000, 34.75776000),
(1110843, 1004689, 'UA', 'Zhemchuzhina', 1, 'zhemchuzhina', 45.27466000, 34.65778000),
(1110848, 1004689, 'UA', 'Zhuravki', 1, 'zhuravki', 45.12629000, 35.21513000),
(1110849, 1004689, 'UA', 'Zhuravli', 1, 'zhuravli', 45.25246000, 33.64104000),
(1110850, 1004689, 'UA', 'Zhuravlyovka', 1, 'zhuravlyovka', 45.17680000, 33.99680000),
(1110855, 1004689, 'UA', 'Zimino', 1, 'zimino', 45.50797000, 33.51431000),
(1110862, 1004689, 'UA', 'Zolotoye Pole', 1, 'zolotoye-pole', 45.12774000, 34.99148000),
(1110864, 1004689, 'UA', 'Zorkino', 1, 'zorkino', 45.54762000, 34.71028000),
(1110868, 1004689, 'UA', 'Zuya', 1, 'zuya', 45.05418000, 34.32152000),
(1110870, 1004689, 'UA', 'Zybiny', 1, 'zybiny', 45.23674000, 34.64987000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004680, 'UA', 'Cherkasy Oblast', 1, 'cherkasy-oblast');

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 
(1109337, 1004680, 'UA', 'Babanka', 1, 'babanka', 48.70971000, 30.44827000),
(1109459, 1004680, 'UA', 'Buky', 1, 'buky', 49.09252000, 30.40355000),
(1109477, 1004680, 'UA', 'Cherkasy', 1, 'cherkasy', 49.42854000, 32.06207000),
(1109498, 1004680, 'UA', 'Chervona Sloboda', 1, 'chervona-sloboda', 49.37281000, 32.15742000),
(1109510, 1004680, 'UA', 'Chornobay', 1, 'chornobay', 49.66644000, 32.32932000),
(1109524, 1004680, 'UA', 'Chyhyryn', 1, 'chyhyryn', 49.08376000, 32.65549000),
(1109575, 1004680, 'UA', 'Drabiv', 1, 'drabiv', 49.96029000, 32.14070000),
(1109651, 1004680, 'UA', 'Horodyshche', 1, 'horodyshche', 49.28489000, 31.44513000),
(1109709, 1004680, 'UA', 'Kamianka', 1, 'kamianka', 49.03180000, 32.10396000),
(1109714, 1004680, 'UA', 'Kaniv', 1, 'kaniv', 49.75182000, 31.46004000),
(1109741, 1004680, 'UA', 'Khrystynivka', 1, 'khrystynivka', 48.81577000, 29.97703000),
(1109805, 1004680, 'UA', 'Korsun-Shevchenkivskyi', 1, 'korsun-shevchenkivskyi', 49.41894000, 31.25865000),
(1109909, 1004680, 'UA', 'Lebedyn', 1, 'lebedyn', 48.96242000, 31.52696000),
(1109959, 1004680, 'UA', 'Lysianka', 1, 'lysianka', 49.25229000, 30.82946000),
(1109995, 1004680, 'UA', 'Mankivka', 1, 'mankivka', 48.96349000, 30.33366000),
(1110042, 1004680, 'UA', 'Mliiv', 1, 'mliiv', 49.33691000, 31.51704000),
(1110051, 1004680, 'UA', 'Monastyryshche', 1, 'monastyryshche', 48.99090000, 29.80470000),
(1110054, 1004680, 'UA', 'Moshny', 1, 'moshny', 49.52754000, 31.73708000),
(1110112, 1004680, 'UA', 'Nove-Misto', 1, 'nove-misto', 48.98113000, 29.82813000),
(1110393, 1004680, 'UA', 'Ruska Poliana', 1, 'ruska-poliana', 49.41700000, 31.92009000),
(1110451, 1004680, 'UA', 'Shpola', 1, 'shpola', 49.00687000, 31.39471000),
(1110488, 1004680, 'UA', 'Smila', 1, 'smila', 49.22242000, 31.88714000),
(1110546, 1004680, 'UA', 'Stebliv', 1, 'stebliv', 49.40186000, 31.09764000),
(1110587, 1004680, 'UA', 'Talne', 1, 'talne', 48.88877000, 30.69482000),
(1110629, 1004680, 'UA', 'Tsibulev', 1, 'tsibulev', 49.07907000, 29.84727000),
(1110631, 1004680, 'UA', 'Tsvitkove', 1, 'tsvitkove', 49.15231000, 31.53739000),
(1110656, 1004680, 'UA', 'Uman', 1, 'uman', 48.74838000, 30.22184000),
(1110681, 1004680, 'UA', 'Vatutine', 1, 'vatutine', 49.01502000, 31.06211000),
(1110704, 1004680, 'UA', 'Verkhniachka', 1, 'verkhniachka', 48.82849000, 30.03957000),
(1110797, 1004680, 'UA', 'Yerky', 1, 'yerky', 48.99062000, 30.98818000),
(1110802, 1004680, 'UA', 'Yurkivka', 1, 'yurkivka', 49.01082000, 31.08797000),
(1110840, 1004680, 'UA', 'Zhashkiv', 1, 'zhashkiv', 49.24545000, 30.11020000),
(1110861, 1004680, 'UA', 'Zolotonosha', 1, 'zolotonosha', 49.66832000, 32.04047000),
(1110869, 1004680, 'UA', 'Zvenihorodka', 1, 'zvenihorodka', 49.07866000, 30.96755000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004692, 'UA', 'Chernihiv Oblast', 1, 'chernihiv-oblast');

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 
(1109334, 1004692, 'UA', 'Avdiyivka', 1, 'avdiyivka', 51.77660000, 32.79988000),
(1109341, 1004692, 'UA', 'Bakhmach', 1, 'bakhmach', 51.18144000, 32.83463000),
(1109358, 1004692, 'UA', 'Baturyn', 1, 'baturyn', 51.34567000, 32.87794000),
(1109381, 1004692, 'UA', 'Berezna', 1, 'berezna', 51.57160000, 31.78456000),
(1109415, 1004692, 'UA', 'Bobrovytsya', 1, 'bobrovytsya', 50.74693000, 31.39480000),
(1109437, 1004692, 'UA', 'Borzna', 1, 'borzna', 51.25464000, 32.42690000),
(1109480, 1004692, 'UA', 'Chernihiv', 1, 'chernihiv', 51.50551000, 31.28487000),
(1109481, 1004692, 'UA', 'Chernihiv Raion', 1, 'chernihiv-raion', 51.58333000, 31.33333000),
(1109483, 1004692, 'UA', 'Chernihivs’ka Mis’krada', 1, 'chernihivs-ka-mis-krada', 51.49923000, 31.28805000),
(1109540, 1004692, 'UA', 'Desna', 1, 'desna', 50.92731000, 30.76048000),
(1109542, 1004692, 'UA', 'Dihtyari', 1, 'dihtyari', 50.58264000, 32.77012000),
(1109562, 1004692, 'UA', 'Dobryanka', 1, 'dobryanka', 52.06314000, 31.18567000),
(1109645, 1004692, 'UA', 'Horodnya', 1, 'horodnya', 51.89085000, 31.59741000),
(1109666, 1004692, 'UA', 'Ichnya', 1, 'ichnya', 50.86258000, 32.39425000),
(1109735, 1004692, 'UA', 'Kholmy', 1, 'kholmy', 51.87096000, 32.60063000),
(1109766, 1004692, 'UA', 'Kobyzhcha', 1, 'kobyzhcha', 50.82854000, 31.50439000),
(1109800, 1004692, 'UA', 'Korop', 1, 'korop', 51.56638000, 32.95861000),
(1109806, 1004692, 'UA', 'Koryukivka', 1, 'koryukivka', 51.76877000, 32.24813000),
(1109824, 1004692, 'UA', 'Kozelets’', 1, 'kozelets', 50.91334000, 31.12140000),
(1109868, 1004692, 'UA', 'Kruty', 1, 'kruty', 51.05974000, 32.10634000),
(1109885, 1004692, 'UA', 'Kulykivka', 1, 'kulykivka', 51.37345000, 31.64661000),
(1109901, 1004692, 'UA', 'Ladan', 1, 'ladan', 50.51959000, 32.58178000),
(1109918, 1004692, 'UA', 'Lisovi Sorochyntsi', 1, 'lisovi-sorochyntsi', 50.68920000, 32.32919000),
(1109963, 1004692, 'UA', 'Lyubech', 1, 'lyubech', 51.70260000, 30.65692000),
(1110021, 1004692, 'UA', 'Mena', 1, 'mena', 51.52170000, 32.21568000),
(1110022, 1004692, 'UA', 'Mens’kyy Rayon', 1, 'mens-kyy-rayon', 51.52148000, 32.02166000),
(1110101, 1004692, 'UA', 'Nizhyn', 1, 'nizhyn', 51.04801000, 31.88688000),
(1110102, 1004692, 'UA', 'Nosivka', 1, 'nosivka', 50.93152000, 31.58282000),
(1110113, 1004692, 'UA', 'Novhorod-Sivers’kyy', 1, 'novhorod-sivers-kyy', 52.00577000, 33.26150000),
(1110196, 1004692, 'UA', 'Olyshivka', 1, 'olyshivka', 51.22266000, 31.33314000),
(1110207, 1004692, 'UA', 'Oster', 1, 'oster', 50.95060000, 30.88229000),
(1110320, 1004692, 'UA', 'Pryluky', 1, 'pryluky', 50.59323000, 32.38761000),
(1110353, 1004692, 'UA', 'Ripky', 1, 'ripky', 51.80105000, 31.08383000),
(1110412, 1004692, 'UA', 'Sedniv', 1, 'sedniv', 51.64473000, 31.56497000),
(1110415, 1004692, 'UA', 'Semenivka', 1, 'semenivka', 52.17827000, 32.58183000),
(1110436, 1004692, 'UA', 'Shchors', 1, 'shchors', 51.81865000, 31.94504000),
(1110494, 1004692, 'UA', 'Snovs\'kyy Rayon', 1, 'snovs-kyy-rayon', 51.83333000, 32.00000000),
(1110516, 1004692, 'UA', 'Sosnytsya', 1, 'sosnytsya', 51.52387000, 32.49985000),
(1110522, 1004692, 'UA', 'Sribne', 1, 'sribne', 50.66384000, 32.91867000),
(1110673, 1004692, 'UA', 'Varva', 1, 'varva', 50.49503000, 32.71968000),
(1110847, 1004692, 'UA', 'Zhuravka', 1, 'zhuravka', 50.48108000, 32.59490000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004678, 'UA', 'Chernivtsi Oblast', 1, 'chernivtsi-oblast');

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 
(1109348, 1004678, 'UA', 'Banyliv', 1, 'banyliv', 48.36612000, 25.34549000),
(1109374, 1004678, 'UA', 'Berehomet', 1, 'berehomet', 48.17882000, 25.34855000),
(1109439, 1004678, 'UA', 'Boyany', 1, 'boyany', 48.27077000, 26.12624000),
(1109486, 1004678, 'UA', 'Chernivtsi', 1, 'chernivtsi', 48.29149000, 25.94034000),
(1109487, 1004678, 'UA', 'Chernivtsi Municipality', 1, 'chernivtsi-municipality', 48.31932000, 25.94104000),
(1109519, 1004678, 'UA', 'Chudey', 1, 'chudey', 48.05247000, 25.62208000),
(1109531, 1004678, 'UA', 'Davydivka', 1, 'davydivka', 48.12099000, 25.56461000),
(1109633, 1004678, 'UA', 'Hlyboka', 1, 'hlyboka', 48.08971000, 25.92933000),
(1109677, 1004678, 'UA', 'Ispas', 1, 'ispas', 48.29734000, 25.27406000),
(1109694, 1004678, 'UA', 'Kadubivtsi', 1, 'kadubivtsi', 48.58337000, 25.76871000),
(1109740, 1004678, 'UA', 'Khotyn', 1, 'khotyn', 48.50693000, 26.49121000),
(1109763, 1004678, 'UA', 'Klishkivtsi', 1, 'klishkivtsi', 48.43161000, 26.26231000),
(1109814, 1004678, 'UA', 'Kostryzhivka', 1, 'kostryzhivka', 48.65455000, 25.71316000),
(1109947, 1004678, 'UA', 'Luzhany', 1, 'luzhany', 48.36492000, 25.77173000),
(1110003, 1004678, 'UA', 'Marshintsy', 1, 'marshintsy', 48.21751000, 26.29133000),
(1110047, 1004678, 'UA', 'Molodiya', 1, 'molodiya', 48.22326000, 26.02139000),
(1110067, 1004678, 'UA', 'Myhove', 1, 'myhove', 48.15749000, 25.37904000),
(1110122, 1004678, 'UA', 'Novodnistrovs’k', 1, 'novodnistrovs-k', 48.58303000, 27.44070000),
(1110145, 1004678, 'UA', 'Novoselytsya', 1, 'novoselytsya', 48.21931000, 26.26531000),
(1110164, 1004678, 'UA', 'Nyzhni Petrivtsi', 1, 'nyzhni-petrivtsi', 48.02847000, 25.72327000),
(1110331, 1004678, 'UA', 'Putyla Raion', 1, 'putyla-raion', 48.00000000, 25.00000000),
(1110370, 1004678, 'UA', 'Ropcha', 1, 'ropcha', 48.11988000, 25.77421000),
(1110453, 1004678, 'UA', 'Shypyntsi', 1, 'shypyntsi', 48.37677000, 25.74664000),
(1110502, 1004678, 'UA', 'Sokyryany', 1, 'sokyryany', 48.44747000, 27.41678000),
(1110675, 1004678, 'UA', 'Vashkivtsi', 1, 'vashkivtsi', 48.38491000, 25.51023000),
(1110702, 1004678, 'UA', 'Verenchanka', 1, 'verenchanka', 48.54653000, 25.74533000),
(1110736, 1004678, 'UA', 'Voloka', 1, 'voloka', 48.19225000, 25.93074000),
(1110769, 1004678, 'UA', 'Vyzhnytsya', 1, 'vyzhnytsya', 48.24801000, 25.19452000),
(1110801, 1004678, 'UA', 'Yizhivtsi', 1, 'yizhivtsi', 48.03962000, 25.66232000),
(1110825, 1004678, 'UA', 'Zastavna', 1, 'zastavna', 48.52307000, 25.84369000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004675, 'UA', 'Dnipropetrovsk Oblast', 1, 'dnipropetrovsk-oblast');

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 
(1109325, 1004675, 'UA', 'Apostolove', 1, 'apostolove', 47.66003000, 33.71369000),
(1109332, 1004675, 'UA', 'Auly', 1, 'auly', 48.56660000, 34.46111000),
(1109335, 1004675, 'UA', 'Aviatorske', 1, 'aviatorske', 48.36714000, 35.08132000),
(1109501, 1004675, 'UA', 'Chervonohryhorivka', 1, 'chervonohryhorivka', 47.62298000, 34.53887000),
(1109518, 1004675, 'UA', 'Chortomlyk', 1, 'chortomlyk', 47.62315000, 34.14198000),
(1109548, 1004675, 'UA', 'Dnipro', 1, 'dnipro', 48.45930000, 35.03865000),
(1109549, 1004675, 'UA', 'Dnipro Raion', 1, 'dnipro-raion', 48.45608000, 35.02167000),
(1109553, 1004675, 'UA', 'Dniprovs’ka Mis’ka Rada', 1, 'dniprovs-ka-mis-ka-rada', 48.46726000, 34.99898000),
(1109659, 1004675, 'UA', 'Hubynykha', 1, 'hubynykha', 48.80980000, 35.25602000),
(1109661, 1004675, 'UA', 'Hupalivka', 1, 'hupalivka', 49.11139000, 34.73556000),
(1109710, 1004675, 'UA', 'Kamianske', 1, 'kamianske', 48.51134000, 34.60210000),
(1109721, 1004675, 'UA', 'Kaydaki', 1, 'kaydaki', 48.37678000, 35.12398000),
(1109872, 1004675, 'UA', 'Krynychky', 1, 'krynychky', 48.37551000, 34.46701000),
(1109876, 1004675, 'UA', 'Kryvoriz’ka Mis’krada', 1, 'kryvoriz-ka-mis-krada', 47.94730000, 33.42489000),
(1109877, 1004675, 'UA', 'Kryvyi Rih', 1, 'kryvyi-rih', 47.90966000, 33.38044000),
(1109949, 1004675, 'UA', 'Lykhivka', 1, 'lykhivka', 48.68735000, 33.92279000),
(1109970, 1004675, 'UA', 'Mahdalynivka', 1, 'mahdalynivka', 48.92111000, 34.91491000),
(1109971, 1004675, 'UA', 'Mahdalynivs’kyy Rayon', 1, 'mahdalynivs-kyy-rayon', 48.97612000, 34.96762000),
(1109999, 1004675, 'UA', 'Marhanets’', 1, 'marhanets', 47.63543000, 34.62769000),
(1110017, 1004675, 'UA', 'Melioratyvne', 1, 'melioratyvne', 48.63009000, 35.41558000),
(1110025, 1004675, 'UA', 'Mezhova', 1, 'mezhova', 48.25318000, 36.73468000),
(1110098, 1004675, 'UA', 'Nikopol', 1, 'nikopol', 47.57119000, 34.39637000),
(1110132, 1004675, 'UA', 'Novomoskovs’k', 1, 'novomoskovs-k', 48.63799000, 35.24548000),
(1110131, 1004675, 'UA', 'Novomoskovsk Raion', 1, 'novomoskovsk-raion', 48.66667000, 35.41667000),
(1110134, 1004675, 'UA', 'Novomykolayivka', 1, 'novomykolayivka', 48.55625000, 34.37399000),
(1110142, 1004675, 'UA', 'Novopokrovka', 1, 'novopokrovka', 48.05918000, 34.60619000),
(1110200, 1004675, 'UA', 'Ordzhonikidze', 1, 'ordzhonikidze', 47.66763000, 34.05957000),
(1110226, 1004675, 'UA', 'Partyzans’ke', 1, 'partyzans-ke', 48.58680000, 34.80948000),
(1110232, 1004675, 'UA', 'Pavlohrad', 1, 'pavlohrad', 48.53426000, 35.87098000),
(1110258, 1004675, 'UA', 'Petropavlivka', 1, 'petropavlivka', 48.45643000, 36.43670000),
(1110261, 1004675, 'UA', 'Petrykivka', 1, 'petrykivka', 48.72933000, 34.63358000),
(1110262, 1004675, 'UA', 'Petrykivs’kyy Rayon', 1, 'petrykivs-kyy-rayon', 48.68914000, 34.61098000),
(1110263, 1004675, 'UA', 'Piatykhatky', 1, 'piatykhatky', 48.41333000, 33.71056000),
(1110268, 1004675, 'UA', 'Pidhorodne', 1, 'pidhorodne', 48.57528000, 35.10680000),
(1110449, 1004675, 'UA', 'Sholokhove', 1, 'sholokhove', 47.69453000, 34.03119000),
(1110455, 1004675, 'UA', 'Shyroke', 1, 'shyroke', 47.69173000, 33.25715000),
(1110456, 1004675, 'UA', 'Shyroke Raion', 1, 'shyroke-raion', 47.66667000, 33.33333000),
(1110498, 1004675, 'UA', 'Sofiyivka', 1, 'sofiyivka', 48.04865000, 33.87618000),
(1110508, 1004675, 'UA', 'Solone', 1, 'solone', 48.20805000, 34.87208000),
(1110509, 1004675, 'UA', 'Solone Raion', 1, 'solone-raion', 48.16667000, 35.00000000),
(1110521, 1004675, 'UA', 'Spas’ke', 1, 'spas-ke', 48.66667000, 35.05385000),
(1110564, 1004675, 'UA', 'Surs’ko-Mykhaylivka', 1, 'surs-ko-mykhaylivka', 48.27202000, 34.72759000),
(1110583, 1004675, 'UA', 'Synel’nykove', 1, 'synel-nykove', 48.32044000, 35.51792000),
(1110613, 1004675, 'UA', 'Tomakivka', 1, 'tomakivka', 47.81569000, 34.74137000),
(1110626, 1004675, 'UA', 'Tsarychanka', 1, 'tsarychanka', 48.93697000, 34.47860000),
(1110627, 1004675, 'UA', 'Tsarychans’kyy Rayon', 1, 'tsarychans-kyy-rayon', 48.93329000, 34.53043000),
(1110710, 1004675, 'UA', 'Verkhn’odniprovs’k', 1, 'verkhn-odniprovs-k', 48.65242000, 34.33457000),
(1110719, 1004675, 'UA', 'Vil’ne', 1, 'vil-ne', 47.63645000, 34.81387000),
(1110761, 1004675, 'UA', 'Vyshchetarasivka', 1, 'vyshchetarasivka', 47.56851000, 34.88096000),
(1110766, 1004675, 'UA', 'Vyshneve', 1, 'vyshneve', 48.43611000, 33.91556000),
(1110803, 1004675, 'UA', 'Yur”yivs’kyy Rayon', 1, 'yur-yivs-kyy-rayon', 48.80743000, 35.91325000),
(1110846, 1004675, 'UA', 'Zhovti Vody', 1, 'zhovti-vody', 48.34493000, 33.50374000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004691, 'UA', 'Donetsk Oblast', 1, 'donetsk-oblast');

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 
(1109318, 1004691, 'UA', 'Amvrosiivka Raion', 1, 'amvrosiivka-raion', 47.75000000, 38.50000000),
(1109319, 1004691, 'UA', 'Amvrosiyivka', 1, 'amvrosiyivka', 47.79348000, 38.47768000),
(1109333, 1004691, 'UA', 'Avdiyivka', 1, 'avdiyivka', 48.13989000, 37.74255000),
(1109342, 1004691, 'UA', 'Bakhmut', 1, 'bakhmut', 48.59559000, 37.99987000),
(1109343, 1004691, 'UA', 'Bakhmut Raion', 1, 'bakhmut-raion', 48.58333000, 38.00000000),
(1109389, 1004691, 'UA', 'Bezimenne', 1, 'bezimenne', 47.10716000, 37.93815000),
(1109407, 1004691, 'UA', 'Bilyts’ke', 1, 'bilyts-ke', 48.40642000, 37.18111000),
(1109410, 1004691, 'UA', 'Blahodatne', 1, 'blahodatne', 47.87928000, 38.48492000),
(1109441, 1004691, 'UA', 'Boykivske', 1, 'boykivske', 47.40994000, 38.02476000),
(1109442, 1004691, 'UA', 'Boykivske Raion', 1, 'boykivske-raion', 47.41667000, 38.00000000),
(1109473, 1004691, 'UA', 'Chasiv Yar', 1, 'chasiv-yar', 48.59348000, 37.85724000),
(1109526, 1004691, 'UA', 'Chystyakove', 1, 'chystyakove', 48.03876000, 38.59685000),
(1109532, 1004691, 'UA', 'Debal’tseve', 1, 'debal-tseve', 48.34072000, 38.40490000),
(1109546, 1004691, 'UA', 'Dmytrivka', 1, 'dmytrivka', 47.93611000, 38.93661000),
(1109556, 1004691, 'UA', 'Dobropillia Raion', 1, 'dobropillia-raion', 48.41667000, 37.16667000),
(1109557, 1004691, 'UA', 'Dobropillya', 1, 'dobropillya', 48.46147000, 37.08524000),
(1109563, 1004691, 'UA', 'Dokuchayevs’k', 1, 'dokuchayevs-k', 47.75046000, 37.67936000),
(1109570, 1004691, 'UA', 'Donetsk', 1, 'donetsk', 48.02300000, 37.80224000),
(1109581, 1004691, 'UA', 'Druzhkivka', 1, 'druzhkivka', 48.63013000, 37.55259000),
(1109641, 1004691, 'UA', 'Horlivka', 1, 'horlivka', 48.33576000, 38.05325000),
(1109668, 1004691, 'UA', 'Ilovays’k', 1, 'ilovays-k', 47.92498000, 38.20235000),
(1109728, 1004691, 'UA', 'Khartsyz’k', 1, 'khartsyz-k', 48.04243000, 38.14728000),
(1109811, 1004691, 'UA', 'Kostiantynivka Raion', 1, 'kostiantynivka-raion', 48.50000000, 37.75000000),
(1109817, 1004691, 'UA', 'Kostyantynivka', 1, 'kostyantynivka', 48.52770000, 37.70690000),
(1109828, 1004691, 'UA', 'Kramators’k', 1, 'kramators-k', 48.72305000, 37.55629000),
(1109848, 1004691, 'UA', 'Krasnotorka', 1, 'krasnotorka', 48.68204000, 37.53266000),
(1109862, 1004691, 'UA', 'Krinichnaya', 1, 'krinichnaya', 48.12899000, 38.02597000),
(1109888, 1004691, 'UA', 'Kurakhovo', 1, 'kurakhovo', 47.98522000, 37.28210000),
(1109893, 1004691, 'UA', 'Kuteynykove', 1, 'kuteynykove', 47.81227000, 38.28822000),
(1109940, 1004691, 'UA', 'Luhans’ke', 1, 'luhans-ke', 48.44574000, 38.26153000),
(1109950, 1004691, 'UA', 'Lyman', 1, 'lyman', 48.98837000, 37.80225000),
(1109952, 1004691, 'UA', 'Lyman Raion', 1, 'lyman-raion', 49.00000000, 37.83333000),
(1109976, 1004691, 'UA', 'Makiyivka', 1, 'makiyivka', 48.04782000, 37.92576000),
(1109977, 1004691, 'UA', 'Makiyivs’ka Mis’krada', 1, 'makiyivs-ka-mis-krada', 48.06287000, 38.03075000),
(1109994, 1004691, 'UA', 'Manhush', 1, 'manhush', 47.05582000, 37.31068000),
(1109997, 1004691, 'UA', 'Mar\'yinka', 1, 'mar-yinka', 47.94527000, 37.50544000),
(1110000, 1004691, 'UA', 'Mariupol', 1, 'mariupol', 47.09514000, 37.54131000),
(1110016, 1004691, 'UA', 'Melekyne', 1, 'melekyne', 46.95957000, 37.39981000),
(1110055, 1004691, 'UA', 'Mospyne', 1, 'mospyne', 47.89081000, 38.06395000),
(1110075, 1004691, 'UA', 'Myrnohrad', 1, 'myrnohrad', 48.30523000, 37.26091000),
(1110097, 1004691, 'UA', 'Nikolske Raion', 1, 'nikolske-raion', 47.25000000, 37.25000000),
(1110120, 1004691, 'UA', 'Novoazovs\'k', 1, 'novoazovs-k', 47.11389000, 38.08599000),
(1110123, 1004691, 'UA', 'Novodonets’ke', 1, 'novodonets-ke', 48.63526000, 36.98477000),
(1110161, 1004691, 'UA', 'Novyy Svit', 1, 'novyy-svit', 47.80591000, 38.02112000),
(1110167, 1004691, 'UA', 'Nyzhnya Krynka', 1, 'nyzhnya-krynka', 48.11350000, 38.16064000),
(1110219, 1004691, 'UA', 'P\'yatypill\'ya', 1, 'p-yatypill-ya', 48.01590000, 38.09979000),
(1110291, 1004691, 'UA', 'Pokrovsk', 1, 'pokrovsk', 48.28198000, 37.17585000),
(1110292, 1004691, 'UA', 'Pokrovsk Raion', 1, 'pokrovsk-raion', 48.25000000, 37.16667000),
(1110359, 1004691, 'UA', 'Rodyns’ke', 1, 'rodyns-ke', 48.35199000, 37.20602000),
(1110385, 1004691, 'UA', 'Rozsypne', 1, 'rozsypne', 48.14966000, 38.57619000),
(1110408, 1004691, 'UA', 'Sartana', 1, 'sartana', 47.17436000, 37.69266000),
(1110413, 1004691, 'UA', 'Selydivs’ka Mis’krada', 1, 'selydivs-ka-mis-krada', 48.14530000, 37.29962000),
(1110414, 1004691, 'UA', 'Selydove', 1, 'selydove', 48.14708000, 37.30032000),
(1110420, 1004691, 'UA', 'Serebryanka', 1, 'serebryanka', 48.91917000, 38.13494000),
(1110428, 1004691, 'UA', 'Shakhtars’k', 1, 'shakhtars-k', 48.05657000, 38.43826000),
(1110435, 1004691, 'UA', 'Shcherbynivka', 1, 'shcherbynivka', 48.39489000, 37.79102000),
(1110454, 1004691, 'UA', 'Shyroke', 1, 'shyroke', 47.95711000, 38.23160000),
(1110464, 1004691, 'UA', 'Sivers’k', 1, 'sivers-k', 48.86699000, 38.10007000),
(1110486, 1004691, 'UA', 'Sloviansk', 1, 'sloviansk', 48.86667000, 37.61667000),
(1110487, 1004691, 'UA', 'Sloviansk Raion', 1, 'sloviansk-raion', 48.91667000, 37.50000000),
(1110493, 1004691, 'UA', 'Snizhne', 1, 'snizhne', 48.02612000, 38.77225000),
(1110503, 1004691, 'UA', 'Soledar', 1, 'soledar', 48.67935000, 38.08902000),
(1110531, 1004691, 'UA', 'Starobesheve', 1, 'starobesheve', 47.75038000, 38.03051000),
(1110539, 1004691, 'UA', 'Staryy Krym', 1, 'staryy-krym', 47.16146000, 37.48934000),
(1110552, 1004691, 'UA', 'Stizhkivs’ke', 1, 'stizhkivs-ke', 48.11333000, 38.49250000),
(1110575, 1004691, 'UA', 'Svetlodarsk', 1, 'svetlodarsk', 48.43374000, 38.22331000),
(1110579, 1004691, 'UA', 'Svyatogorsk', 1, 'svyatogorsk', 49.03333000, 37.56667000),
(1110581, 1004691, 'UA', 'Syedove', 1, 'syedove', 47.07678000, 38.15602000),
(1110595, 1004691, 'UA', 'Temriuk', 1, 'temriuk', 47.26857000, 36.98115000),
(1110616, 1004691, 'UA', 'Toretsk', 1, 'toretsk', 48.39869000, 37.84787000),
(1110659, 1004691, 'UA', 'Urzuf', 1, 'urzuf', 46.91562000, 37.09961000),
(1110732, 1004691, 'UA', 'Volnovakha', 1, 'volnovakha', 47.60103000, 37.49674000),
(1110753, 1004691, 'UA', 'Vuhlehirs’k', 1, 'vuhlehirs-k', 48.31474000, 38.27423000),
(1110777, 1004691, 'UA', 'Yalta', 1, 'yalta', 46.96279000, 37.27365000),
(1110790, 1004691, 'UA', 'Yasynuvata', 1, 'yasynuvata', 48.12980000, 37.85940000),
(1110791, 1004691, 'UA', 'Yasynuvata Raion', 1, 'yasynuvata-raion', 48.16667000, 37.83333000),
(1110796, 1004691, 'UA', 'Yenakiyeve', 1, 'yenakiyeve', 48.23331000, 38.21137000),
(1110867, 1004691, 'UA', 'Zuhres', 1, 'zuhres', 48.01140000, 38.26444000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004682, 'UA', 'Ivano-Frankivsk Oblast', 1, 'ivano-frankivsk-oblast');

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 
(1109397, 1004682, 'UA', 'Bili Oslavy', 1, 'bili-oslavy', 48.48722000, 24.70078000),
(1109405, 1004682, 'UA', 'Bilshivtsi', 1, 'bilshivtsi', 49.18333000, 24.75000000),
(1109420, 1004682, 'UA', 'Bohorodchans’kyy Rayon', 1, 'bohorodchans-kyy-rayon', 48.72278000, 24.38042000),
(1109421, 1004682, 'UA', 'Bohorodchany', 1, 'bohorodchany', 48.80700000, 24.53834000),
(1109423, 1004682, 'UA', 'Bolekhiv', 1, 'bolekhiv', 49.06607000, 23.86435000),
(1109424, 1004682, 'UA', 'Bolekhivs’ka Mis’krada', 1, 'bolekhivs-ka-mis-krada', 49.06255000, 23.84339000),
(1109433, 1004682, 'UA', 'Borshchevskiy Rayon', 1, 'borshchevskiy-rayon', 48.75000000, 26.00000000),
(1109447, 1004682, 'UA', 'Broshniv-Osada', 1, 'broshniv-osada', 48.99621000, 24.19748000),
(1109461, 1004682, 'UA', 'Burshtyn', 1, 'burshtyn', 49.25867000, 24.62777000),
(1109462, 1004682, 'UA', 'Burshtyns’ka Mis’krada', 1, 'burshtyns-ka-mis-krada', 49.25217000, 24.63320000),
(1109466, 1004682, 'UA', 'Bystrytsya', 1, 'bystrytsya', 48.45931000, 24.24545000),
(1109467, 1004682, 'UA', 'Bytkiv', 1, 'bytkiv', 48.62968000, 24.47398000),
(1109478, 1004682, 'UA', 'Chernelytsya', 1, 'chernelytsya', 48.81207000, 25.42477000),
(1109488, 1004682, 'UA', 'Cherniyiv', 1, 'cherniyiv', 48.85658000, 24.71388000),
(1109496, 1004682, 'UA', 'Chernyatyn', 1, 'chernyatyn', 48.66034000, 25.44832000),
(1109512, 1004682, 'UA', 'Chornoliztsi', 1, 'chornoliztsi', 48.83034000, 24.89576000),
(1109533, 1004682, 'UA', 'Delyatyn', 1, 'delyatyn', 48.52354000, 24.62466000),
(1109565, 1004682, 'UA', 'Dolyna', 1, 'dolyna', 48.97330000, 24.00944000),
(1109567, 1004682, 'UA', 'Dolyns’kyy Rayon', 1, 'dolyns-kyy-rayon', 48.89148000, 23.84343000),
(1109625, 1004682, 'UA', 'Halych', 1, 'halych', 49.12179000, 24.72578000),
(1109626, 1004682, 'UA', 'Halyts’kyy Rayon', 1, 'halyts-kyy-rayon', 49.16169000, 24.71797000),
(1109643, 1004682, 'UA', 'Horodenka', 1, 'horodenka', 48.67274000, 25.50163000),
(1109644, 1004682, 'UA', 'Horodenkivs’kyy Rayon', 1, 'horodenkivs-kyy-rayon', 48.70617000, 25.42008000),
(1109665, 1004682, 'UA', 'Hvizd', 1, 'hvizd', 48.68517000, 24.55055000),
(1109683, 1004682, 'UA', 'Ivano-Frankivs’ka Mis’krada', 1, 'ivano-frankivs-ka-mis-krada', 48.91177000, 24.72831000),
(1109682, 1004682, 'UA', 'Ivano-Frankivsk', 1, 'ivano-frankivsk', 48.92150000, 24.70972000),
(1109703, 1004682, 'UA', 'Kalus’kyy Rayon', 1, 'kalus-kyy-rayon', 49.06088000, 24.38766000),
(1109702, 1004682, 'UA', 'Kalush', 1, 'kalush', 49.01187000, 24.37308000),
(1109745, 1004682, 'UA', 'Khymchyn', 1, 'khymchyn', 48.38639000, 25.14803000),
(1109776, 1004682, 'UA', 'Kolomyia', 1, 'kolomyia', 48.53115000, 25.03649000),
(1109777, 1004682, 'UA', 'Kolomyys’kyy Rayon', 1, 'kolomyys-kyy-rayon', 48.58586000, 24.99300000),
(1109807, 1004682, 'UA', 'Kosiv', 1, 'kosiv', 48.31071000, 25.09575000),
(1109808, 1004682, 'UA', 'Kosivs’kyy Rayon', 1, 'kosivs-kyy-rayon', 48.32569000, 24.98641000),
(1109809, 1004682, 'UA', 'Kosmach', 1, 'kosmach', 48.75089000, 24.36731000),
(1109829, 1004682, 'UA', 'Krasna', 1, 'krasna', 48.57571000, 24.70027000),
(1109894, 1004682, 'UA', 'Kuty', 1, 'kuty', 48.25868000, 25.17946000),
(1109903, 1004682, 'UA', 'Lanchyn', 1, 'lanchyn', 48.55781000, 24.75622000),
(1109996, 1004682, 'UA', 'Manyava', 1, 'manyava', 48.65541000, 24.37537000),
(1110002, 1004682, 'UA', 'Markova', 1, 'markova', 48.67576000, 24.41382000),
(1110078, 1004682, 'UA', 'Nadvirna', 1, 'nadvirna', 48.63480000, 24.56936000),
(1110079, 1004682, 'UA', 'Nadvirnyans’kyy Rayon', 1, 'nadvirnyans-kyy-rayon', 48.55387000, 24.50381000),
(1110086, 1004682, 'UA', 'Nebyliv', 1, 'nebyliv', 48.81526000, 24.21657000),
(1110158, 1004682, 'UA', 'Novytsya', 1, 'novytsya', 48.96345000, 24.33542000),
(1110170, 1004682, 'UA', 'Obertyn', 1, 'obertyn', 48.70032000, 25.17012000),
(1110212, 1004682, 'UA', 'Otyniya', 1, 'otyniya', 48.73767000, 24.86111000),
(1110229, 1004682, 'UA', 'Pasichna', 1, 'pasichna', 48.57152000, 24.43003000),
(1110234, 1004682, 'UA', 'Pechenizhyn', 1, 'pechenizhyn', 48.51551000, 24.89423000),
(1110255, 1004682, 'UA', 'Petranka', 1, 'petranka', 48.90246000, 24.30347000),
(1110279, 1004682, 'UA', 'Pniv', 1, 'pniv', 48.61783000, 24.52872000),
(1110303, 1004682, 'UA', 'Porohy', 1, 'porohy', 48.68755000, 24.26322000),
(1110335, 1004682, 'UA', 'Radcha', 1, 'radcha', 48.85023000, 24.65502000),
(1110350, 1004682, 'UA', 'Rechka', 1, 'rechka', 48.28034000, 24.93330000),
(1110360, 1004682, 'UA', 'Rohatyn', 1, 'rohatyn', 49.40900000, 24.60927000),
(1110361, 1004682, 'UA', 'Rohatyns’kyy Rayon', 1, 'rohatyns-kyy-rayon', 49.38025000, 24.57111000),
(1110378, 1004682, 'UA', 'Rozhniativ', 1, 'rozhniativ', 48.93576000, 24.16379000),
(1110379, 1004682, 'UA', 'Rozhniv', 1, 'rozhniv', 48.36597000, 25.22580000),
(1110380, 1004682, 'UA', 'Rozhnyativs’kyy Rayon', 1, 'rozhnyativs-kyy-rayon', 48.75890000, 24.07588000),
(1110400, 1004682, 'UA', 'Sadzhavka', 1, 'sadzhavka', 48.56603000, 24.78820000),
(1110441, 1004682, 'UA', 'Sheshory', 1, 'sheshory', 48.33197000, 24.98329000),
(1110491, 1004682, 'UA', 'Sniatyn', 1, 'sniatyn', 48.44692000, 25.56937000),
(1110495, 1004682, 'UA', 'Snyatyns’kyy Rayon', 1, 'snyatyns-kyy-rayon', 48.47674000, 25.41153000),
(1110512, 1004682, 'UA', 'Solotvyn', 1, 'solotvyn', 48.70212000, 24.42212000),
(1110520, 1004682, 'UA', 'Spas', 1, 'spas', 48.88992000, 24.06293000),
(1110529, 1004682, 'UA', 'Stari Bohorodchany', 1, 'stari-bohorodchany', 48.83361000, 24.52430000),
(1110530, 1004682, 'UA', 'Stari Kuty', 1, 'stari-kuty', 48.27093000, 25.17293000),
(1110551, 1004682, 'UA', 'Stetseva', 1, 'stetseva', 48.52767000, 25.57572000),
(1110571, 1004682, 'UA', 'Svarychiv', 1, 'svarychiv', 48.96220000, 24.19658000),
(1110593, 1004682, 'UA', 'Tatariv', 1, 'tatariv', 48.34558000, 24.57836000),
(1110608, 1004682, 'UA', 'Tlumach', 1, 'tlumach', 48.86403000, 25.00325000),
(1110609, 1004682, 'UA', 'Tlumats’kyy Rayon', 1, 'tlumats-kyy-rayon', 48.82924000, 25.09055000),
(1110644, 1004682, 'UA', 'Tysmenychany', 1, 'tysmenychany', 48.77168000, 24.66626000),
(1110646, 1004682, 'UA', 'Tysmenyts’kyy Rayon', 1, 'tysmenyts-kyy-rayon', 48.92246000, 24.74486000),
(1110645, 1004682, 'UA', 'Tysmenytsya', 1, 'tysmenytsya', 48.90219000, 24.84482000),
(1110650, 1004682, 'UA', 'Uhryniv', 1, 'uhryniv', 48.95520000, 24.69292000),
(1110697, 1004682, 'UA', 'Velykyy Klyuchiv', 1, 'velykyy-klyuchiv', 48.47092000, 24.94677000),
(1110707, 1004682, 'UA', 'Verkhniy Yasenov', 1, 'verkhniy-yasenov', 48.16156000, 24.94532000),
(1110712, 1004682, 'UA', 'Verkhovyna', 1, 'verkhovyna', 48.15571000, 24.79112000),
(1110741, 1004682, 'UA', 'Vorokhta', 1, 'vorokhta', 48.28459000, 24.56536000),
(1110770, 1004682, 'UA', 'Yabluniv', 1, 'yabluniv', 48.40418000, 24.93874000),
(1110771, 1004682, 'UA', 'Yablunytsya', 1, 'yablunytsya', 48.31742000, 24.48448000),
(1110779, 1004682, 'UA', 'Yamnytsya', 1, 'yamnytsya', 48.98972000, 24.70750000),
(1110783, 1004682, 'UA', 'Yaremchans’ks Mis’krada', 1, 'yaremchans-ks-mis-krada', 48.33234000, 24.57426000),
(1110784, 1004682, 'UA', 'Yaremche', 1, 'yaremche', 48.45157000, 24.55436000),
(1110806, 1004682, 'UA', 'Zabolotiv', 1, 'zabolotiv', 48.47054000, 25.28571000),
(1110809, 1004682, 'UA', 'Zahvizdya', 1, 'zahvizdya', 48.91836000, 24.65275000),
(1110823, 1004682, 'UA', 'Zarichchya', 1, 'zarichchya', 48.52144000, 24.64857000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004686, 'UA', 'Kharkiv Oblast', 1, 'kharkiv-oblast');

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 
(1109344, 1004686, 'UA', 'Balakliya', 1, 'balakliya', 49.46270000, 36.85951000),
(1109352, 1004686, 'UA', 'Barvinkove', 1, 'barvinkove', 48.90970000, 37.02051000),
(1109380, 1004686, 'UA', 'Berezivka', 1, 'berezivka', 49.43935000, 35.70736000),
(1109390, 1004686, 'UA', 'Bezlyudivka', 1, 'bezlyudivka', 49.87547000, 36.26539000),
(1109413, 1004686, 'UA', 'Blyznyuky', 1, 'blyznyuky', 48.85775000, 36.55505000),
(1109419, 1004686, 'UA', 'Bohodukhiv', 1, 'bohodukhiv', 50.16466000, 35.52765000),
(1109432, 1004686, 'UA', 'Borova', 1, 'borova', 49.37770000, 37.62136000),
(1109458, 1004686, 'UA', 'Budy', 1, 'budy', 49.89133000, 36.02096000),
(1109469, 1004686, 'UA', 'Chapayeve', 1, 'chapayeve', 49.36625000, 35.87486000),
(1109504, 1004686, 'UA', 'Chervonyy Oskil', 1, 'chervonyy-oskil', 49.17906000, 37.42593000),
(1109522, 1004686, 'UA', 'Chuhuyiv', 1, 'chuhuyiv', 49.83588000, 36.68803000),
(1109539, 1004686, 'UA', 'Derhachi', 1, 'derhachi', 50.10659000, 36.12112000),
(1109590, 1004686, 'UA', 'Dvorichna', 1, 'dvorichna', 49.85019000, 37.68262000),
(1109596, 1004686, 'UA', 'Eskhar', 1, 'eskhar', 49.79614000, 36.59047000),
(1109663, 1004686, 'UA', 'Huty', 1, 'huty', 50.13322000, 35.34394000),
(1109691, 1004686, 'UA', 'Izyum', 1, 'izyum', 49.20875000, 37.24849000),
(1109724, 1004686, 'UA', 'Kehychivka', 1, 'kehychivka', 49.28656000, 35.76153000),
(1109727, 1004686, 'UA', 'Kharkiv', 1, 'kharkiv', 49.98081000, 36.25272000),
(1109736, 1004686, 'UA', 'Khorosheve', 1, 'khorosheve', 49.85413000, 36.21704000),
(1109757, 1004686, 'UA', 'Kivsharivka', 1, 'kivsharivka', 49.63096000, 37.68821000),
(1109767, 1004686, 'UA', 'Kochetok', 1, 'kochetok', 49.88005000, 36.73723000),
(1109775, 1004686, 'UA', 'Kolomak', 1, 'kolomak', 49.83987000, 35.30441000),
(1109804, 1004686, 'UA', 'Korotych', 1, 'korotych', 49.94737000, 36.03736000),
(1109838, 1004686, 'UA', 'Krasnohrad', 1, 'krasnohrad', 49.38009000, 35.44186000),
(1109841, 1004686, 'UA', 'Krasnokuts’k', 1, 'krasnokuts-k', 50.06602000, 35.16275000),
(1109843, 1004686, 'UA', 'Krasnopavlivka', 1, 'krasnopavlivka', 49.13643000, 36.31911000),
(1109886, 1004686, 'UA', 'Kulynychi', 1, 'kulynychi', 49.98178000, 36.38283000),
(1109887, 1004686, 'UA', 'Kupjansk', 1, 'kupjansk', 49.71055000, 37.61517000),
(1109932, 1004686, 'UA', 'Lozova', 1, 'lozova', 48.88937000, 36.31755000),
(1109951, 1004686, 'UA', 'Lyman', 1, 'lyman', 49.59769000, 36.47030000),
(1109966, 1004686, 'UA', 'Lyubotyn', 1, 'lyubotyn', 49.94691000, 35.92907000),
(1109979, 1004686, 'UA', 'Mala Danylivka', 1, 'mala-danylivka', 50.06354000, 36.16564000),
(1109990, 1004686, 'UA', 'Malynivka', 1, 'malynivka', 49.81667000, 36.73333000),
(1109991, 1004686, 'UA', 'Manchenky', 1, 'manchenky', 49.97982000, 35.85835000),
(1110023, 1004686, 'UA', 'Merefa', 1, 'merefa', 49.82302000, 36.05069000),
(1110110, 1004686, 'UA', 'Nova Vodolaha', 1, 'nova-vodolaha', 49.71901000, 35.86578000),
(1110141, 1004686, 'UA', 'Novopokrovka', 1, 'novopokrovka', 49.83349000, 36.54771000),
(1110222, 1004686, 'UA', 'Panyutyne', 1, 'panyutyne', 48.93692000, 36.27563000),
(1110242, 1004686, 'UA', 'Peresichna', 1, 'peresichna', 50.02452000, 35.97871000),
(1110247, 1004686, 'UA', 'Pervomaiskyi Raion', 1, 'pervomaiskyi-raion', 49.41667000, 36.33333000),
(1110252, 1004686, 'UA', 'Pervomays’kyy', 1, 'pervomays-kyy', 49.38742000, 36.21471000),
(1110257, 1004686, 'UA', 'Petrivs’ke', 1, 'petrivs-ke', 49.17695000, 36.89999000),
(1110275, 1004686, 'UA', 'Pivdenne', 1, 'pivdenne', 49.88315000, 36.06785000),
(1110290, 1004686, 'UA', 'Pokotylivka', 1, 'pokotylivka', 49.91343000, 36.17511000),
(1110317, 1004686, 'UA', 'Prudyanka', 1, 'prudyanka', 50.23606000, 36.16835000),
(1110319, 1004686, 'UA', 'Prykolotne', 1, 'prykolotne', 50.16273000, 37.34524000),
(1110401, 1004686, 'UA', 'Sakhnovshchyna', 1, 'sakhnovshchyna', 49.15166000, 35.87198000),
(1110411, 1004686, 'UA', 'Savyntsi', 1, 'savyntsi', 49.40257000, 37.06266000),
(1110445, 1004686, 'UA', 'Shevchenkove', 1, 'shevchenkove', 49.69585000, 37.17348000),
(1110476, 1004686, 'UA', 'Slatyne', 1, 'slatyne', 50.21041000, 36.15376000),
(1110484, 1004686, 'UA', 'Slobozhans’ke', 1, 'slobozhans-ke', 49.59701000, 36.52618000),
(1110511, 1004686, 'UA', 'Solonytsivka', 1, 'solonytsivka', 49.99682000, 36.03464000),
(1110540, 1004686, 'UA', 'Staryy Merchyk', 1, 'staryy-merchyk', 49.98147000, 35.75904000),
(1110541, 1004686, 'UA', 'Staryy Saltiv', 1, 'staryy-saltiv', 50.07619000, 36.78852000),
(1110558, 1004686, 'UA', 'Studenok', 1, 'studenok', 49.09107000, 37.48697000),
(1110663, 1004686, 'UA', 'Utkivka', 1, 'utkivka', 49.78583000, 36.07528000),
(1110670, 1004686, 'UA', 'Valky', 1, 'valky', 49.83597000, 35.61223000),
(1110680, 1004686, 'UA', 'Vasyshcheve', 1, 'vasyshcheve', 49.82852000, 36.32691000),
(1110696, 1004686, 'UA', 'Velykyy Burluk', 1, 'velykyy-burluk', 50.06170000, 37.38373000),
(1110699, 1004686, 'UA', 'Verbivka', 1, 'verbivka', 49.41667000, 35.53333000),
(1110747, 1004686, 'UA', 'Vovchans’k', 1, 'vovchans-k', 50.29078000, 36.94108000),
(1110754, 1004686, 'UA', 'Vvedenka', 1, 'vvedenka', 49.82372000, 36.50264000),
(1110768, 1004686, 'UA', 'Vysokyy', 1, 'vysokyy', 49.89156000, 36.12175000),
(1110807, 1004686, 'UA', 'Zachepylivka', 1, 'zachepylivka', 49.19385000, 35.23943000),
(1110857, 1004686, 'UA', 'Zmiyiv', 1, 'zmiyiv', 49.67453000, 36.34775000),
(1110859, 1004686, 'UA', 'Zolochiv', 1, 'zolochiv', 50.27985000, 35.98179000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004684, 'UA', 'Kherson Oblast', 1, 'kherson-oblast');

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 
(1109331, 1004684, 'UA', 'Askaniya-Nova', 1, 'askaniya-nova', 46.45135000, 33.86889000),
(1109361, 1004684, 'UA', 'Bekhtery', 1, 'bekhtery', 46.24790000, 32.29123000),
(1109388, 1004684, 'UA', 'Beryslav', 1, 'beryslav', 46.84152000, 33.42838000),
(1109404, 1004684, 'UA', 'Bilozerka', 1, 'bilozerka', 46.62480000, 32.44251000),
(1109454, 1004684, 'UA', 'Brylivka', 1, 'brylivka', 46.42476000, 33.14721000),
(1109472, 1004684, 'UA', 'Chaplynka', 1, 'chaplynka', 46.36507000, 33.54027000),
(1109511, 1004684, 'UA', 'Chornobayivka', 1, 'chornobayivka', 46.69411000, 32.55371000),
(1109516, 1004684, 'UA', 'Chornyanka', 1, 'chornyanka', 46.65222000, 33.35904000),
(1109523, 1004684, 'UA', 'Chulakivka', 1, 'chulakivka', 46.35763000, 32.35140000),
(1109554, 1004684, 'UA', 'Dnipryany', 1, 'dnipryany', 46.74631000, 33.27288000),
(1109587, 1004684, 'UA', 'Dudchany', 1, 'dudchany', 47.18557000, 33.76390000),
(1109628, 1004684, 'UA', 'Heniches’k', 1, 'heniches-k', 46.17592000, 34.80340000),
(1109629, 1004684, 'UA', 'Heniches’kyy Rayon', 1, 'heniches-kyy-rayon', 46.26451000, 34.74488000),
(1109636, 1004684, 'UA', 'Hola Prystan’', 1, 'hola-prystan', 46.52719000, 32.52417000),
(1109642, 1004684, 'UA', 'Hornostayivka', 1, 'hornostayivka', 47.00777000, 33.72899000),
(1109679, 1004684, 'UA', 'Ivanivka', 1, 'ivanivka', 46.72082000, 34.55298000),
(1109697, 1004684, 'UA', 'Kakhovka', 1, 'kakhovka', 46.81371000, 33.48698000),
(1109698, 1004684, 'UA', 'Kalanchak', 1, 'kalanchak', 46.25623000, 33.29070000),
(1109722, 1004684, 'UA', 'Kayiry', 1, 'kayiry', 46.94537000, 33.70591000),
(1109729, 1004684, 'UA', 'Kherson', 1, 'kherson', 46.65581000, 32.61780000),
(1109786, 1004684, 'UA', 'Komyshany', 1, 'komyshany', 46.63716000, 32.50719000),
(1109823, 1004684, 'UA', 'Kozachi Laheri', 1, 'kozachi-laheri', 46.70372000, 32.97760000),
(1109833, 1004684, 'UA', 'Krasne', 1, 'krasne', 46.13088000, 32.76910000),
(1109907, 1004684, 'UA', 'Lazurne', 1, 'lazurne', 46.08400000, 32.52955000),
(1109967, 1004684, 'UA', 'Lyubymivka', 1, 'lyubymivka', 46.81063000, 33.56862000),
(1109983, 1004684, 'UA', 'Malokakhovka', 1, 'malokakhovka', 46.78142000, 33.44790000),
(1110104, 1004684, 'UA', 'Nova Kakhovka', 1, 'nova-kakhovka', 46.75451000, 33.34864000),
(1110105, 1004684, 'UA', 'Nova Mayachka', 1, 'nova-mayachka', 46.59996000, 33.22707000),
(1110125, 1004684, 'UA', 'Novofedorivka', 1, 'novofedorivka', 46.17128000, 32.31781000),
(1110137, 1004684, 'UA', 'Novooleksiyivka', 1, 'novooleksiyivka', 46.22472000, 34.64031000),
(1110153, 1004684, 'UA', 'Novovorontsovka', 1, 'novovorontsovka', 47.50035000, 33.91748000),
(1110165, 1004684, 'UA', 'Nyzhni Sirohozy', 1, 'nyzhni-sirohozy', 46.84842000, 34.38044000),
(1110227, 1004684, 'UA', 'Partyzany', 1, 'partyzany', 46.33383000, 34.75314000),
(1110336, 1004684, 'UA', 'Radens’k', 1, 'radens-k', 46.54860000, 32.92787000),
(1110466, 1004684, 'UA', 'Skadovs’k', 1, 'skadovs-k', 46.11610000, 32.91124000),
(1110525, 1004684, 'UA', 'Stanislav', 1, 'stanislav', 46.56909000, 32.14777000),
(1110634, 1004684, 'UA', 'Tsyurupyns’k', 1, 'tsyurupyns-k', 46.61842000, 32.71890000),
(1110685, 1004684, 'UA', 'Velyka Lepetykha', 1, 'velyka-lepetykha', 47.17572000, 33.94362000),
(1110687, 1004684, 'UA', 'Velyka Oleksandrivka', 1, 'velyka-oleksandrivka', 47.31969000, 33.30373000),
(1110690, 1004684, 'UA', 'Velyki Kopani', 1, 'velyki-kopani', 46.48684000, 32.97498000),
(1110706, 1004684, 'UA', 'Verkhniy Rohachyk', 1, 'verkhniy-rohachyk', 47.25053000, 34.33797000),
(1110760, 1004684, 'UA', 'Vynohradove', 1, 'vynohradove', 46.36957000, 32.93980000),
(1110767, 1004684, 'UA', 'Vysokopillya', 1, 'vysokopillya', 47.49187000, 33.53061000),
(1110817, 1004684, 'UA', 'Zaliznyy Port', 1, 'zaliznyy-port', 46.12337000, 32.29892000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004681, 'UA', 'Khmelnytsky Oblast', 1, 'khmelnytsky-oblast');

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 
(1109322, 1004681, 'UA', 'Antoniny', 1, 'antoniny', 49.80974000, 26.87714000),
(1109360, 1004681, 'UA', 'Bazaliya', 1, 'bazaliya', 49.71267000, 26.47331000),
(1109537, 1004681, 'UA', 'Derazhnya', 1, 'derazhnya', 49.26920000, 27.43382000),
(1109538, 1004681, 'UA', 'Derazhnyans’kyy Rayon', 1, 'derazhnyans-kyy-rayon', 49.22676000, 27.46603000),
(1109589, 1004681, 'UA', 'Dunaivtsi', 1, 'dunaivtsi', 48.88909000, 26.85636000),
(1109650, 1004681, 'UA', 'Horodok', 1, 'horodok', 49.16374000, 26.58394000),
(1109690, 1004681, 'UA', 'Izyaslav', 1, 'izyaslav', 50.11947000, 26.82125000),
(1109708, 1004681, 'UA', 'Kamianets-Podilskyi', 1, 'kamianets-podilskyi', 48.68450000, 26.58559000),
(1109731, 1004681, 'UA', 'Khmel’nyts’kyy Rayon', 1, 'khmel-nyts-kyy-rayon', 49.44511000, 26.93268000),
(1109730, 1004681, 'UA', 'Khmelnytskyi', 1, 'khmelnytskyi', 49.42161000, 26.99653000),
(1109856, 1004681, 'UA', 'Krasyliv', 1, 'krasyliv', 49.65186000, 26.97253000),
(1109916, 1004681, 'UA', 'Letychiv', 1, 'letychiv', 49.38263000, 27.63051000),
(1109975, 1004681, 'UA', 'Makiv', 1, 'makiv', 48.79487000, 26.69188000),
(1110015, 1004681, 'UA', 'Medzhybizh', 1, 'medzhybizh', 49.43748000, 27.40487000),
(1110080, 1004681, 'UA', 'Narkevychi', 1, 'narkevychi', 49.51717000, 26.64178000),
(1110093, 1004681, 'UA', 'Netishyn', 1, 'netishyn', 50.34004000, 26.64171000),
(1110109, 1004681, 'UA', 'Nova Ushytsya', 1, 'nova-ushytsya', 48.83716000, 27.27434000),
(1110146, 1004681, 'UA', 'Novoselytsya', 1, 'novoselytsya', 50.07030000, 27.51955000),
(1110294, 1004681, 'UA', 'Polonne', 1, 'polonne', 50.12424000, 27.51087000),
(1110299, 1004681, 'UA', 'Poninka', 1, 'poninka', 50.18492000, 27.53629000),
(1110440, 1004681, 'UA', 'Shepetivka', 1, 'shepetivka', 50.18545000, 27.06365000),
(1110479, 1004681, 'UA', 'Slavuta', 1, 'slavuta', 50.30155000, 26.86506000),
(1110489, 1004681, 'UA', 'Smotrych', 1, 'smotrych', 48.66149000, 26.56031000),
(1110490, 1004681, 'UA', 'Smyga', 1, 'smyga', 50.23910000, 25.76575000),
(1110527, 1004681, 'UA', 'Stara Syniava', 1, 'stara-syniava', 49.60318000, 27.61909000),
(1110533, 1004681, 'UA', 'Starokostiantyniv', 1, 'starokostiantyniv', 49.75764000, 27.20342000),
(1110787, 1004681, 'UA', 'Yarmolyntsi', 1, 'yarmolyntsi', 49.19236000, 26.83725000),
(1110811, 1004681, 'UA', 'Zakupne', 1, 'zakupne', 49.11944000, 26.33756000),
(1110851, 1004681, 'UA', 'Zhvanets', 1, 'zhvanets', 48.54968000, 26.48744000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004676, 'UA', 'Kiev', 1, 'kiev');

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 
(1109529, 1004676, 'UA', 'Darnytsia Raion', 1, 'darnytsia-raion', 50.41333000, 30.69305000),
(1109541, 1004676, 'UA', 'Desnyans’kyy Rayon', 1, 'desnyans-kyy-rayon', 50.53550000, 30.60875000),
(1109550, 1004676, 'UA', 'Dnipro Raion', 1, 'dnipro-raion', 50.46756000, 30.63194000),
(1109637, 1004676, 'UA', 'Holosiiv Raion', 1, 'holosiiv-raion', 50.32749000, 30.56740000),
(1109819, 1004676, 'UA', 'Kotsyubyns’ke', 1, 'kotsyubyns-ke', 50.48836000, 30.32957000),
(1109897, 1004676, 'UA', 'Kyiv', 1, 'kyiv', 50.45466000, 30.52380000),
(1110235, 1004676, 'UA', 'Pechersk Raion', 1, 'pechersk-raion', 50.41902000, 30.56602000),
(1110286, 1004676, 'UA', 'Podil’s’kyy Rayon', 1, 'podil-s-kyy-rayon', 50.45000000, 30.53333000),
(1110313, 1004676, 'UA', 'Prolisky', 1, 'prolisky', 50.39118000, 30.78000000),
(1110442, 1004676, 'UA', 'Shevchenkivs’kyy Rayon', 1, 'shevchenkivs-kyy-rayon', 50.43333000, 30.51667000),
(1110507, 1004676, 'UA', 'Solomianka Rayon', 1, 'solomianka-rayon', 50.42886000, 30.45135000),
(1110580, 1004676, 'UA', 'Svyatoshyns’kyy Rayon', 1, 'svyatoshyns-kyy-rayon', 50.48533000, 30.38050000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004677, 'UA', 'Kirovohrad Oblast', 1, 'kirovohrad-oblast');

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 
(1109307, 1004677, 'UA', 'Adzhamka', 1, 'adzhamka', 48.54245000, 32.53542000),
(1109411, 1004677, 'UA', 'Blahovishchenske Raion', 1, 'blahovishchenske-raion', 48.25000000, 30.25000000),
(1109416, 1004677, 'UA', 'Bobrynets', 1, 'bobrynets', 48.05896000, 32.16641000),
(1109544, 1004677, 'UA', 'Dmytrivka', 1, 'dmytrivka', 48.79690000, 32.71645000),
(1109558, 1004677, 'UA', 'Dobrovelychkivka', 1, 'dobrovelychkivka', 48.38778000, 31.18028000),
(1109559, 1004677, 'UA', 'Dobrovelychkivs’kyy Rayon', 1, 'dobrovelychkivs-kyy-rayon', 48.36935000, 31.16354000),
(1109566, 1004677, 'UA', 'Dolyns\'ka', 1, 'dolyns-ka', 48.11041000, 32.76449000),
(1109568, 1004677, 'UA', 'Dolyns’kyy Rayon', 1, 'dolyns-kyy-rayon', 48.16327000, 32.88318000),
(1109627, 1004677, 'UA', 'Hayvoron', 1, 'hayvoron', 48.33958000, 29.86791000),
(1109715, 1004677, 'UA', 'Kapitanivka', 1, 'kapitanivka', 48.91719000, 31.71671000),
(1109751, 1004677, 'UA', 'Kirovohrads’ka Mis’krada', 1, 'kirovohrads-ka-mis-krada', 48.52185000, 32.24367000),
(1109783, 1004677, 'UA', 'Kompaniyivka', 1, 'kompaniyivka', 48.25115000, 32.20795000),
(1109867, 1004677, 'UA', 'Kropyvnytskyi', 1, 'kropyvnytskyi', 48.51320000, 32.25970000),
(1109934, 1004677, 'UA', 'Lozuvatka', 1, 'lozuvatka', 48.05710000, 33.28581000),
(1109955, 1004677, 'UA', 'Lypnyazhka', 1, 'lypnyazhka', 48.44694000, 31.07611000),
(1109981, 1004677, 'UA', 'Mala Vyska', 1, 'mala-vyska', 48.64308000, 31.63657000),
(1109986, 1004677, 'UA', 'Malovyskivs’kyy Rayon', 1, 'malovyskivs-kyy-rayon', 48.57680000, 31.57594000),
(1110048, 1004677, 'UA', 'Molodizhne', 1, 'molodizhne', 48.17732000, 32.66015000),
(1110107, 1004677, 'UA', 'Nova Praha', 1, 'nova-praha', 48.56821000, 32.90273000),
(1110114, 1004677, 'UA', 'Novhorodka', 1, 'novhorodka', 48.36506000, 32.65785000),
(1110119, 1004677, 'UA', 'Novoarkhanhel’s’k', 1, 'novoarkhanhel-s-k', 48.65803000, 30.81821000),
(1110135, 1004677, 'UA', 'Novomyrhorod', 1, 'novomyrhorod', 48.78105000, 31.64204000),
(1110150, 1004677, 'UA', 'Novoukrayinka', 1, 'novoukrayinka', 48.32635000, 31.52852000),
(1110160, 1004677, 'UA', 'Novyy Starodub', 1, 'novyy-starodub', 48.51580000, 33.17329000),
(1110186, 1004677, 'UA', 'Oleksandrivka', 1, 'oleksandrivka', 48.96336000, 32.23492000),
(1110189, 1004677, 'UA', 'Oleksandriya', 1, 'oleksandriya', 48.66961000, 33.11593000),
(1110190, 1004677, 'UA', 'Oleksandriys’ke', 1, 'oleksandriys-ke', 48.60767000, 32.98347000),
(1110198, 1004677, 'UA', 'Onufriyivka', 1, 'onufriyivka', 48.90716000, 33.44869000),
(1110221, 1004677, 'UA', 'Pantayivka', 1, 'pantayivka', 48.67400000, 32.88410000),
(1110233, 1004677, 'UA', 'Pavlysh', 1, 'pavlysh', 48.91762000, 33.35691000),
(1110238, 1004677, 'UA', 'Perehonivka', 1, 'perehonivka', 48.53552000, 30.51923000),
(1110259, 1004677, 'UA', 'Petrove', 1, 'petrove', 48.32467000, 33.25617000),
(1110281, 1004677, 'UA', 'Pobugskoye', 1, 'pobugskoye', 48.16579000, 30.59274000),
(1110297, 1004677, 'UA', 'Pomichna', 1, 'pomichna', 48.24222000, 31.41583000),
(1110325, 1004677, 'UA', 'Pryyutivka', 1, 'pryyutivka', 48.72094000, 33.07078000),
(1110355, 1004677, 'UA', 'Rivne', 1, 'rivne', 48.24742000, 31.75432000),
(1110559, 1004677, 'UA', 'Subottsi', 1, 'subottsi', 48.65545000, 32.52093000),
(1110577, 1004677, 'UA', 'Svitlovods’k', 1, 'svitlovods-k', 49.04894000, 33.24106000),
(1110643, 1004677, 'UA', 'Tyshkivka', 1, 'tyshkivka', 48.49665000, 30.94229000),
(1110662, 1004677, 'UA', 'Ustynivka', 1, 'ustynivka', 47.95507000, 32.53674000),
(1110793, 1004677, 'UA', 'Yelyzavethradka', 1, 'yelyzavethradka', 48.80381000, 32.40460000),
(1110828, 1004677, 'UA', 'Zavallya', 1, 'zavallya', 48.21354000, 30.01558000),
(1110856, 1004677, 'UA', 'Zlynka', 1, 'zlynka', 48.48521000, 31.53906000),
(1110858, 1004677, 'UA', 'Znomenka', 1, 'znomenka', 48.71278000, 32.66472000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004671, 'UA', 'Kyiv Oblast', 1, 'kyiv-oblast');

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 
(1109353, 1004671, 'UA', 'Baryshivka', 1, 'baryshivka', 50.36098000, 31.32173000),
(1109354, 1004671, 'UA', 'Baryshivs’kyy Rayon', 1, 'baryshivs-kyy-rayon', 50.36919000, 31.34896000),
(1109393, 1004671, 'UA', 'Bila Tserkva', 1, 'bila-tserkva', 49.80939000, 30.11209000),
(1109394, 1004671, 'UA', 'Bila Tserkva Raion', 1, 'bila-tserkva-raion', 49.75000000, 30.08333000),
(1109422, 1004671, 'UA', 'Bohuslav', 1, 'bohuslav', 49.54939000, 30.87440000),
(1109426, 1004671, 'UA', 'Borispol’skiy Rayon', 1, 'borispol-skiy-rayon', 50.33450000, 31.02470000),
(1109427, 1004671, 'UA', 'Borodianka', 1, 'borodianka', 50.64484000, 29.92010000),
(1109429, 1004671, 'UA', 'Borodyans’kyy Rayon', 1, 'borodyans-kyy-rayon', 50.65889000, 29.88556000),
(1109431, 1004671, 'UA', 'Borova', 1, 'borova', 50.17625000, 30.10429000),
(1109436, 1004671, 'UA', 'Boryspil’', 1, 'boryspil', 50.35269000, 30.95501000),
(1109440, 1004671, 'UA', 'Boyarka', 1, 'boyarka', 50.31911000, 30.29728000),
(1109449, 1004671, 'UA', 'Brovary', 1, 'brovary', 50.51809000, 30.80671000),
(1109450, 1004671, 'UA', 'Brovary Raion', 1, 'brovary-raion', 50.58333000, 31.00000000),
(1109456, 1004671, 'UA', 'Bucha', 1, 'bucha', 50.54345000, 30.21201000),
(1109468, 1004671, 'UA', 'Chabany', 1, 'chabany', 50.34071000, 30.42356000),
(1109494, 1004671, 'UA', 'Chernyakhivka', 1, 'chernyakhivka', 50.21882000, 31.93082000),
(1109591, 1004671, 'UA', 'Dymer', 1, 'dymer', 50.78647000, 30.30260000),
(1109597, 1004671, 'UA', 'Fastiv', 1, 'fastiv', 50.07670000, 29.91770000),
(1109598, 1004671, 'UA', 'Fastiv Raion', 1, 'fastiv-raion', 50.08333000, 30.00000000),
(1109631, 1004671, 'UA', 'Hlevakha', 1, 'hlevakha', 50.27423000, 30.32706000),
(1109635, 1004671, 'UA', 'Hnidyn', 1, 'hnidyn', 50.32899000, 30.71059000),
(1109639, 1004671, 'UA', 'Horenka', 1, 'horenka', 50.55731000, 30.33217000),
(1109655, 1004671, 'UA', 'Hostomel', 1, 'hostomel', 50.56841000, 30.26510000),
(1109672, 1004671, 'UA', 'Irpin', 1, 'irpin', 50.52175000, 30.25055000),
(1109673, 1004671, 'UA', 'Irpins’ka Mis’krada', 1, 'irpins-ka-mis-krada', 50.51585000, 30.24099000),
(1109680, 1004671, 'UA', 'Ivankiv', 1, 'ivankiv', 50.93865000, 29.89426000),
(1109681, 1004671, 'UA', 'Ivankiv Raion', 1, 'ivankiv-raion', 51.00000000, 29.91667000),
(1109695, 1004671, 'UA', 'Kaharlyk', 1, 'kaharlyk', 49.86233000, 30.82815000),
(1109696, 1004671, 'UA', 'Kaharlyk Raion', 1, 'kaharlyk-raion', 49.91667000, 30.75000000),
(1109705, 1004671, 'UA', 'Kalynove', 1, 'kalynove', 49.38179000, 30.45137000),
(1109716, 1004671, 'UA', 'Karapyshi', 1, 'karapyshi', 49.64237000, 30.79002000),
(1109720, 1004671, 'UA', 'Katyuzhanka', 1, 'katyuzhanka', 50.80595000, 30.13763000),
(1109739, 1004671, 'UA', 'Khotiv', 1, 'khotiv', 50.33069000, 30.46836000),
(1109749, 1004671, 'UA', 'Kirove', 1, 'kirove', 50.36890000, 31.12066000),
(1109758, 1004671, 'UA', 'Klavdiyevo-Tarasove', 1, 'klavdiyevo-tarasove', 50.58416000, 30.01134000),
(1109764, 1004671, 'UA', 'Knyazhichi', 1, 'knyazhichi', 50.46275000, 30.78369000),
(1109768, 1004671, 'UA', 'Kodra', 1, 'kodra', 50.59488000, 29.55873000),
(1109797, 1004671, 'UA', 'Korniyivka', 1, 'korniyivka', 50.41661000, 31.46261000),
(1109825, 1004671, 'UA', 'Kozhanka', 1, 'kozhanka', 49.97231000, 29.76424000),
(1109855, 1004671, 'UA', 'Krasyatychi', 1, 'krasyatychi', 51.07636000, 29.64899000),
(1109865, 1004671, 'UA', 'Kriukivschina', 1, 'kriukivschina', 50.37153000, 30.36861000),
(1109874, 1004671, 'UA', 'Kryva Hora', 1, 'kryva-hora', 51.38495000, 30.19978000),
(1109900, 1004671, 'UA', 'Kyyevo-Svyatoshyns’kyy Rayon', 1, 'kyyevo-svyatoshyns-kyy-rayon', 50.38530000, 30.23129000),
(1109925, 1004671, 'UA', 'Liutizh', 1, 'liutizh', 50.68350000, 30.39324000),
(1109972, 1004671, 'UA', 'Makariv', 1, 'makariv', 50.46408000, 29.81128000),
(1109973, 1004671, 'UA', 'Makariv Raion', 1, 'makariv-raion', 50.50000000, 29.75000000),
(1110035, 1004671, 'UA', 'Mirovka', 1, 'mirovka', 49.93126000, 30.62309000),
(1110057, 1004671, 'UA', 'Motovylivka', 1, 'motovylivka', 50.15821000, 30.07421000),
(1110076, 1004671, 'UA', 'Myronivka', 1, 'myronivka', 49.66007000, 30.98225000),
(1110116, 1004671, 'UA', 'Novi Petrivtsi', 1, 'novi-petrivtsi', 50.62754000, 30.44310000),
(1110173, 1004671, 'UA', 'Obukhiv', 1, 'obukhiv', 50.10689000, 30.61848000),
(1110174, 1004671, 'UA', 'Obukhiv Raion', 1, 'obukhiv-raion', 50.16667000, 30.66667000),
(1110175, 1004671, 'UA', 'Obukhivs’ka Mis’krada', 1, 'obukhivs-ka-mis-krada', 50.11425000, 30.63293000),
(1110239, 1004671, 'UA', 'Pereiaslav-Khmelnytskyi', 1, 'pereiaslav-khmelnytskyi', 50.06739000, 31.44969000),
(1110240, 1004671, 'UA', 'Pereiaslav-Khmelnytskyi Raion', 1, 'pereiaslav-khmelnytskyi-raion', 50.08333000, 31.50000000),
(1110274, 1004671, 'UA', 'Piskivka', 1, 'piskivka', 50.69378000, 29.61934000),
(1110287, 1004671, 'UA', 'Pohreby', 1, 'pohreby', 50.55453000, 30.64455000),
(1110327, 1004671, 'UA', 'Pukhivka', 1, 'pukhivka', 50.60970000, 30.71770000),
(1110363, 1004671, 'UA', 'Rokytne', 1, 'rokytne', 49.68665000, 30.47384000),
(1110365, 1004671, 'UA', 'Rokytne Raion', 1, 'rokytne-raion', 49.75000000, 30.50000000),
(1110373, 1004671, 'UA', 'Roskoshnyy', 1, 'roskoshnyy', 49.37087000, 30.18471000),
(1110398, 1004671, 'UA', 'Rzhyshchiv', 1, 'rzhyshchiv', 49.96886000, 31.04628000),
(1110417, 1004671, 'UA', 'Semypolky', 1, 'semypolky', 50.72627000, 30.93441000),
(1110474, 1004671, 'UA', 'Skvyra', 1, 'skvyra', 49.73177000, 29.66569000),
(1110475, 1004671, 'UA', 'Skvyrs’kyy Rayon', 1, 'skvyrs-kyy-rayon', 49.74177000, 29.70043000),
(1110480, 1004671, 'UA', 'Slavutych', 1, 'slavutych', 51.52250000, 30.71806000),
(1110499, 1004671, 'UA', 'Sofiyivska Borschagivka', 1, 'sofiyivska-borschagivka', 50.41005000, 30.36724000),
(1110543, 1004671, 'UA', 'Stavyshche', 1, 'stavyshche', 49.39124000, 30.19022000),
(1110545, 1004671, 'UA', 'Stayki', 1, 'stayki', 50.07818000, 30.90380000),
(1110590, 1004671, 'UA', 'Tarashcha', 1, 'tarashcha', 49.55832000, 30.49259000),
(1110606, 1004671, 'UA', 'Tetiiv', 1, 'tetiiv', 49.37670000, 29.66474000),
(1110620, 1004671, 'UA', 'Trebukhiv', 1, 'trebukhiv', 50.48432000, 30.90304000),
(1110624, 1004671, 'UA', 'Trypillia', 1, 'trypillia', 50.11802000, 30.78141000),
(1110632, 1004671, 'UA', 'Tsybli', 1, 'tsybli', 49.99484000, 31.56281000),
(1110651, 1004671, 'UA', 'Ukrainka', 1, 'ukrainka', 50.14317000, 30.74612000),
(1110669, 1004671, 'UA', 'Uzyn', 1, 'uzyn', 49.82619000, 30.41487000),
(1110678, 1004671, 'UA', 'Vasylkiv', 1, 'vasylkiv', 50.18693000, 30.31346000),
(1110679, 1004671, 'UA', 'Vasylkiv Raion', 1, 'vasylkiv-raion', 50.16667000, 30.33333000),
(1110684, 1004671, 'UA', 'Velyka Dymerka', 1, 'velyka-dymerka', 50.59333000, 30.90313000),
(1110733, 1004671, 'UA', 'Volodarka', 1, 'volodarka', 49.52484000, 29.91222000),
(1110742, 1004671, 'UA', 'Voronkov', 1, 'voronkov', 50.22235000, 30.89967000),
(1110745, 1004671, 'UA', 'Vorzel’', 1, 'vorzel', 50.54440000, 30.15305000),
(1110762, 1004671, 'UA', 'Vyshgorodskiy Rayon', 1, 'vyshgorodskiy-rayon', 50.58333000, 30.50000000),
(1110763, 1004671, 'UA', 'Vyshhorod', 1, 'vyshhorod', 50.58476000, 30.48980000),
(1110765, 1004671, 'UA', 'Vyshneve', 1, 'vyshneve', 50.38913000, 30.37050000),
(1110773, 1004671, 'UA', 'Yahotyn', 1, 'yahotyn', 50.27975000, 31.76246000),
(1110774, 1004671, 'UA', 'Yahotyns’kyy Rayon', 1, 'yahotyns-kyy-rayon', 50.25722000, 31.89456000),
(1110872, 1004671, 'UA', 'Z·hurivs’kyy Rayon', 1, 'z-hurivs-kyy-rayon', 50.47192000, 31.79423000),
(1110839, 1004671, 'UA', 'Zgurovka', 1, 'zgurovka', 50.50276000, 31.78492000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004673, 'UA', 'Luhansk Oblast', 1, 'luhansk-oblast');

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 
(1109311, 1004673, 'UA', 'Alchevs’k', 1, 'alchevs-k', 48.46893000, 38.81669000),
(1109312, 1004673, 'UA', 'Alchevs’ka Mis’krada', 1, 'alchevs-ka-mis-krada', 48.48029000, 38.79690000),
(1109323, 1004673, 'UA', 'Antratsyt', 1, 'antratsyt', 48.11503000, 39.09128000),
(1109324, 1004673, 'UA', 'Antratsytivs’kyy Rayon', 1, 'antratsytivs-kyy-rayon', 48.12450000, 39.05683000),
(1109329, 1004673, 'UA', 'Artemivs’k', 1, 'artemivs-k', 48.44061000, 38.73200000),
(1109359, 1004673, 'UA', 'Bayrachky', 1, 'bayrachky', 48.39200000, 38.60174000),
(1109395, 1004673, 'UA', 'Bile', 1, 'bile', 48.49523000, 39.05051000),
(1109400, 1004673, 'UA', 'Bilohorivka', 1, 'bilohorivka', 48.92503000, 38.24822000),
(1109401, 1004673, 'UA', 'Bilokurakyne', 1, 'bilokurakyne', 49.53410000, 38.73067000),
(1109403, 1004673, 'UA', 'Bilovods\'k', 1, 'bilovods-k', 49.20846000, 39.58975000),
(1109408, 1004673, 'UA', 'Biryukove', 1, 'biryukove', 47.95631000, 39.73843000),
(1109453, 1004673, 'UA', 'Bryanka', 1, 'bryanka', 48.51100000, 38.67222000),
(1109460, 1004673, 'UA', 'Buran', 1, 'buran', 48.30003000, 39.61526000),
(1109502, 1004673, 'UA', 'Chervonopartyzans’k', 1, 'chervonopartyzans-k', 48.07613000, 39.79618000),
(1109515, 1004673, 'UA', 'Chornukhyne', 1, 'chornukhyne', 48.32339000, 38.52272000),
(1109574, 1004673, 'UA', 'Dovzhanskyy Rayon', 1, 'dovzhanskyy-rayon', 48.00000000, 39.66667000),
(1109630, 1004673, 'UA', 'Hirs’ke', 1, 'hirs-ke', 48.73468000, 38.49541000),
(1109693, 1004673, 'UA', 'Kadiyivka', 1, 'kadiyivka', 48.56818000, 38.64352000),
(1109754, 1004673, 'UA', 'Kirovs’k', 1, 'kirovs-k', 48.63751000, 38.64280000),
(1109755, 1004673, 'UA', 'Kirovs’ka Mis’krada', 1, 'kirovs-ka-mis-krada', 48.63485000, 38.64753000),
(1109760, 1004673, 'UA', 'Klenovyy', 1, 'klenovyy', 48.11934000, 39.45880000),
(1109853, 1004673, 'UA', 'Krasnyy Kut', 1, 'krasnyy-kut', 48.20138000, 38.79765000),
(1109854, 1004673, 'UA', 'Krasnyy Luch', 1, 'krasnyy-luch', 48.13954000, 38.93715000),
(1109860, 1004673, 'UA', 'Kreminna', 1, 'kreminna', 49.04950000, 38.21792000),
(1109864, 1004673, 'UA', 'Kripens’kyy', 1, 'kripens-kyy', 48.07709000, 39.05800000),
(1109911, 1004673, 'UA', 'Lenina', 1, 'lenina', 48.42944000, 39.14556000),
(1109931, 1004673, 'UA', 'Lozno-Oleksandrivka', 1, 'lozno-oleksandrivka', 49.83910000, 38.74098000),
(1109939, 1004673, 'UA', 'Luhans’ka Mis’krada', 1, 'luhans-ka-mis-krada', 48.58083000, 39.35478000),
(1109938, 1004673, 'UA', 'Luhansk', 1, 'luhansk', 48.56705000, 39.31706000),
(1109945, 1004673, 'UA', 'Lutuhyne', 1, 'lutuhyne', 48.40507000, 39.22675000),
(1109946, 1004673, 'UA', 'Lutuhyns’kyy Rayon', 1, 'lutuhyns-kyy-rayon', 48.38509000, 39.21209000),
(1109960, 1004673, 'UA', 'Lysychans’k', 1, 'lysychans-k', 48.90485000, 38.44207000),
(1109974, 1004673, 'UA', 'Makariv Yar', 1, 'makariv-yar', 48.57768000, 39.71944000),
(1110001, 1004673, 'UA', 'Markivka', 1, 'markivka', 49.52290000, 39.57055000),
(1110030, 1004673, 'UA', 'Millerovo', 1, 'millerovo', 48.16829000, 39.16537000),
(1110031, 1004673, 'UA', 'Milove', 1, 'milove', 49.37528000, 40.13222000),
(1110038, 1004673, 'UA', 'Miusyns’k', 1, 'miusyns-k', 48.07750000, 38.90364000),
(1110049, 1004673, 'UA', 'Molodohvardiys’k', 1, 'molodohvardiys-k', 48.34511000, 39.65244000),
(1110143, 1004673, 'UA', 'Novopskov', 1, 'novopskov', 49.54640000, 39.08987000),
(1110166, 1004673, 'UA', 'Nyzhnya Duvanka', 1, 'nyzhnya-duvanka', 49.58464000, 38.17429000),
(1110231, 1004673, 'UA', 'Pavlivka', 1, 'pavlivka', 49.60864000, 38.70917000),
(1110244, 1004673, 'UA', 'Pereval’s’k', 1, 'pereval-s-k', 48.43779000, 38.84384000),
(1110250, 1004673, 'UA', 'Pervomays’k', 1, 'pervomays-k', 48.62988000, 38.54806000),
(1110300, 1004673, 'UA', 'Popasna', 1, 'popasna', 48.63328000, 38.37804000),
(1110324, 1004673, 'UA', 'Pryvillya', 1, 'pryvillya', 49.01501000, 38.30457000),
(1110374, 1004673, 'UA', 'Roven’ky', 1, 'roven-ky', 48.08331000, 39.37764000),
(1110384, 1004673, 'UA', 'Rozkishne', 1, 'rozkishne', 48.48959000, 39.27881000),
(1110387, 1004673, 'UA', 'Rubizhans’ka Mis’krada', 1, 'rubizhans-ka-mis-krada', 49.01460000, 38.38909000),
(1110388, 1004673, 'UA', 'Rubizhne', 1, 'rubizhne', 49.01229000, 38.37967000),
(1110433, 1004673, 'UA', 'Shchastya', 1, 'shchastya', 48.73963000, 39.23230000),
(1110460, 1004673, 'UA', 'Simeykyne', 1, 'simeykyne', 48.32643000, 39.53366000),
(1110485, 1004673, 'UA', 'Slov`yanoserbsk', 1, 'slov-yanoserbsk', 48.69779000, 38.98133000),
(1110514, 1004673, 'UA', 'Sorokyne', 1, 'sorokyne', 48.29235000, 39.73921000),
(1110515, 1004673, 'UA', 'Sorokyns\'kyi Rayon', 1, 'sorokyns-kyi-rayon', 48.33333000, 39.75000000),
(1110526, 1004673, 'UA', 'Stanytsya Luhans’ka', 1, 'stanytsya-luhans-ka', 48.65433000, 39.47943000),
(1110532, 1004673, 'UA', 'Starobil’s’k', 1, 'starobil-s-k', 49.27832000, 38.91069000),
(1110572, 1004673, 'UA', 'Svatove', 1, 'svatove', 49.41029000, 38.15035000),
(1110573, 1004673, 'UA', 'Sverdlovs’k', 1, 'sverdlovs-k', 48.08964000, 39.65243000),
(1110574, 1004673, 'UA', 'Sverdlovs’ka Mis’krada', 1, 'sverdlovs-ka-mis-krada', 48.06850000, 39.58057000),
(1110582, 1004673, 'UA', 'Syevyerodonets’k', 1, 'syevyerodonets-k', 48.94832000, 38.49166000),
(1110597, 1004673, 'UA', 'Teple', 1, 'teple', 48.31245000, 39.56284000),
(1110618, 1004673, 'UA', 'Toshkivka', 1, 'toshkivka', 48.77914000, 38.57903000),
(1110625, 1004673, 'UA', 'Tr’okhizbenka', 1, 'tr-okhizbenka', 48.75751000, 38.96333000),
(1110657, 1004673, 'UA', 'Uralo-Kavkaz', 1, 'uralo-kavkaz', 48.32110000, 39.80302000),
(1110661, 1004673, 'UA', 'Uspenka', 1, 'uspenka', 48.39077000, 39.16284000),
(1110812, 1004673, 'UA', 'Zalesnoye', 1, 'zalesnoye', 48.03104000, 38.80934000),
(1110866, 1004673, 'UA', 'Zoryns’k', 1, 'zoryns-k', 48.41194000, 38.62361000),
(1110871, 1004673, 'UA', 'Zymohiria', 1, 'zymohiria', 48.58528000, 38.93750000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004672, 'UA', 'Lviv Oblast', 1, 'lviv-oblast');

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 
(1109366, 1004672, 'UA', 'Belz', 1, 'belz', 50.38226000, 24.00642000),
(1109391, 1004672, 'UA', 'Bibrka', 1, 'bibrka', 49.64093000, 24.28874000),
(1109435, 1004672, 'UA', 'Boryslav', 1, 'boryslav', 49.28672000, 23.43238000),
(1109446, 1004672, 'UA', 'Brody', 1, 'brody', 50.08791000, 25.15027000),
(1109455, 1004672, 'UA', 'Bryukhovychi', 1, 'bryukhovychi', 49.90467000, 23.95969000),
(1109500, 1004672, 'UA', 'Chervonohrad', 1, 'chervonohrad', 50.39105000, 24.23514000),
(1109534, 1004672, 'UA', 'Demnya', 1, 'demnya', 49.56738000, 23.94607000),
(1109555, 1004672, 'UA', 'Dobromyl’', 1, 'dobromyl', 49.57193000, 22.78629000),
(1109578, 1004672, 'UA', 'Drohobych', 1, 'drohobych', 49.34991000, 23.50561000),
(1109583, 1004672, 'UA', 'Dublyany', 1, 'dublyany', 49.90411000, 24.08637000),
(1109588, 1004672, 'UA', 'Duliby', 1, 'duliby', 49.23134000, 23.81532000),
(1109594, 1004672, 'UA', 'Dzvinogrud', 1, 'dzvinogrud', 49.73333000, 24.25000000),
(1109634, 1004672, 'UA', 'Hlyns\'k', 1, 'hlyns-k', 50.06033000, 23.89956000),
(1109648, 1004672, 'UA', 'Horodok', 1, 'horodok', 49.78465000, 23.64806000),
(1109684, 1004672, 'UA', 'Ivano-Frankove', 1, 'ivano-frankove', 49.91978000, 23.72913000),
(1109733, 1004672, 'UA', 'Khodoriv', 1, 'khodoriv', 49.40993000, 24.30470000),
(1109746, 1004672, 'UA', 'Khyriv', 1, 'khyriv', 49.53417000, 22.85538000),
(1109782, 1004672, 'UA', 'Komarno', 1, 'komarno', 49.62739000, 23.69952000),
(1109832, 1004672, 'UA', 'Krasne', 1, 'krasne', 49.91447000, 24.61340000),
(1109884, 1004672, 'UA', 'Kulykiv', 1, 'kulykiv', 49.97954000, 24.07817000),
(1109929, 1004672, 'UA', 'Lopatyn', 1, 'lopatyn', 50.22022000, 24.84831000),
(1109948, 1004672, 'UA', 'Lviv', 1, 'lviv', 49.83826000, 24.02324000),
(1110012, 1004672, 'UA', 'Medenychi', 1, 'medenychi', 49.43055000, 23.75073000),
(1110052, 1004672, 'UA', 'Morshyn', 1, 'morshyn', 49.15652000, 23.87232000),
(1110056, 1004672, 'UA', 'Mostys\'ka', 1, 'mostys-ka', 49.79467000, 23.15077000),
(1110062, 1004672, 'UA', 'Murovane', 1, 'murovane', 49.52143000, 22.93670000),
(1110070, 1004672, 'UA', 'Mykolaiv', 1, 'mykolaiv', 49.52372000, 23.98522000),
(1110084, 1004672, 'UA', 'Navaria', 1, 'navaria', 49.74952000, 23.92746000),
(1110154, 1004672, 'UA', 'Novoyavorivs\'k', 1, 'novoyavorivs-k', 49.93023000, 23.57357000),
(1110157, 1004672, 'UA', 'Novyi Yarychiv', 1, 'novyi-yarychiv', 49.90444000, 24.30523000),
(1110172, 1004672, 'UA', 'Obroshyne', 1, 'obroshyne', 49.78333000, 23.86667000),
(1110193, 1004672, 'UA', 'Olesko', 1, 'olesko', 49.96233000, 24.89336000),
(1110241, 1004672, 'UA', 'Peremyshlyany', 1, 'peremyshlyany', 49.66523000, 24.55846000),
(1110264, 1004672, 'UA', 'Pidbuzh', 1, 'pidbuzh', 49.33483000, 23.24887000),
(1110266, 1004672, 'UA', 'Pidhirtsi', 1, 'pidhirtsi', 49.94611000, 24.97950000),
(1110269, 1004672, 'UA', 'Pidkamin’', 1, 'pidkamin', 49.94599000, 25.31672000),
(1110278, 1004672, 'UA', 'Pnikut', 1, 'pnikut', 49.71104000, 23.13826000),
(1110298, 1004672, 'UA', 'Pomoriany', 1, 'pomoriany', 49.64092000, 24.93070000),
(1110306, 1004672, 'UA', 'Potelych', 1, 'potelych', 50.20804000, 23.54674000),
(1110330, 1004672, 'UA', 'Pustomyty', 1, 'pustomyty', 49.71532000, 23.91295000),
(1110344, 1004672, 'UA', 'Ralivka', 1, 'ralivka', 49.49982000, 23.23739000),
(1110347, 1004672, 'UA', 'Rava-Rus’ka', 1, 'rava-rus-ka', 50.23079000, 23.62825000),
(1110352, 1004672, 'UA', 'Richky', 1, 'richky', 50.27706000, 23.64617000),
(1110357, 1004672, 'UA', 'Rodatychi', 1, 'rodatychi', 49.79862000, 23.53336000),
(1110376, 1004672, 'UA', 'Rozdil', 1, 'rozdil', 49.46144000, 24.06230000),
(1110386, 1004672, 'UA', 'Rozvadiv', 1, 'rozvadiv', 49.50323000, 23.96200000),
(1110390, 1004672, 'UA', 'Rudky', 1, 'rudky', 49.65306000, 23.48702000),
(1110391, 1004672, 'UA', 'Rudne', 1, 'rudne', 49.83333000, 23.90000000),
(1110397, 1004672, 'UA', 'Rykhtychi', 1, 'rykhtychi', 49.38511000, 23.55662000),
(1110405, 1004672, 'UA', 'Sambir', 1, 'sambir', 49.51830000, 23.19752000),
(1110438, 1004672, 'UA', 'Shchyrets', 1, 'shchyrets', 49.65096000, 23.87426000),
(1110447, 1004672, 'UA', 'Shklo', 1, 'shklo', 49.95675000, 23.54408000),
(1110458, 1004672, 'UA', 'Silets’', 1, 'silets', 50.29712000, 24.20462000),
(1110470, 1004672, 'UA', 'Skelivka', 1, 'skelivka', 49.53728000, 22.96467000),
(1110471, 1004672, 'UA', 'Skhidnytsya', 1, 'skhidnytsya', 49.22827000, 23.35016000),
(1110472, 1004672, 'UA', 'Skole', 1, 'skole', 49.03717000, 23.51346000),
(1110478, 1004672, 'UA', 'Slavske', 1, 'slavske', 48.84734000, 23.44587000),
(1110500, 1004672, 'UA', 'Sokal’', 1, 'sokal', 50.47438000, 24.28288000),
(1110510, 1004672, 'UA', 'Solonka', 1, 'solonka', 49.75621000, 24.01028000),
(1110535, 1004672, 'UA', 'Staroye Selo', 1, 'staroye-selo', 49.71037000, 24.18950000),
(1110537, 1004672, 'UA', 'Starychi', 1, 'starychi', 49.98001000, 23.55848000),
(1110538, 1004672, 'UA', 'Staryy Dobrotvir', 1, 'staryy-dobrotvir', 50.23154000, 24.37701000),
(1110542, 1004672, 'UA', 'Staryy Sambir', 1, 'staryy-sambir', 49.43856000, 23.00056000),
(1110547, 1004672, 'UA', 'Stebnyk', 1, 'stebnyk', 49.29416000, 23.56357000),
(1110557, 1004672, 'UA', 'Stryi', 1, 'stryi', 49.26223000, 23.85609000),
(1110561, 1004672, 'UA', 'Sudova Vyshnya', 1, 'sudova-vyshnya', 49.78892000, 23.37218000),
(1110562, 1004672, 'UA', 'Sukhovolya', 1, 'sukhovolya', 49.82426000, 23.83770000),
(1110623, 1004672, 'UA', 'Truskavets’', 1, 'truskavets', 49.27837000, 23.50618000),
(1110635, 1004672, 'UA', 'Tukhlia', 1, 'tukhlia', 48.91218000, 23.47303000),
(1110639, 1004672, 'UA', 'Turka', 1, 'turka', 49.15411000, 23.02967000),
(1110649, 1004672, 'UA', 'Uhniv', 1, 'uhniv', 50.36811000, 23.74895000),
(1110655, 1004672, 'UA', 'Ulychne', 1, 'ulychne', 49.23385000, 23.65111000),
(1110700, 1004672, 'UA', 'Verblyany', 1, 'verblyany', 50.04747000, 23.42189000),
(1110701, 1004672, 'UA', 'Verchnia Rozhanka', 1, 'verchnia-rozhanka', 48.78050000, 23.51545000),
(1110705, 1004672, 'UA', 'Verkhnie Synevydne', 1, 'verkhnie-synevydne', 49.10307000, 23.59099000),
(1110709, 1004672, 'UA', 'Verkhnyaya Belka', 1, 'verkhnyaya-belka', 49.81575000, 24.30328000),
(1110749, 1004672, 'UA', 'Voyutychi', 1, 'voyutychi', 49.55135000, 23.10579000),
(1110792, 1004672, 'UA', 'Yavoriv', 1, 'yavoriv', 49.93864000, 23.38254000),
(1110845, 1004672, 'UA', 'Zhovkva', 1, 'zhovkva', 50.05825000, 23.97260000),
(1110852, 1004672, 'UA', 'Zhydachiv', 1, 'zhydachiv', 49.38468000, 24.14254000),
(1110860, 1004672, 'UA', 'Zolochiv', 1, 'zolochiv', 49.80597000, 24.89436000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004679, 'UA', 'Mykolaiv Oblast', 1, 'mykolaiv-oblast');

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 
(1109326, 1004679, 'UA', 'Arbuzynka', 1, 'arbuzynka', 47.90972000, 31.31963000),
(1109355, 1004679, 'UA', 'Bashtanka', 1, 'bashtanka', 47.40719000, 32.43868000),
(1109378, 1004679, 'UA', 'Berezanka', 1, 'berezanka', 46.85262000, 31.38802000),
(1109382, 1004679, 'UA', 'Bereznehuvate', 1, 'bereznehuvate', 47.30783000, 32.84993000),
(1109569, 1004679, 'UA', 'Domanivka', 1, 'domanivka', 47.63192000, 30.98851000),
(1109723, 1004679, 'UA', 'Kazanka', 1, 'kazanka', 47.84625000, 32.82177000),
(1109765, 1004679, 'UA', 'Kobleve', 1, 'kobleve', 46.66499000, 31.20804000),
(1109815, 1004679, 'UA', 'Kostyantynivka', 1, 'kostyantynivka', 47.82660000, 31.13551000),
(1109875, 1004679, 'UA', 'Kryve Ozero', 1, 'kryve-ozero', 47.95242000, 30.34928000),
(1109958, 1004679, 'UA', 'Lysa Hora', 1, 'lysa-hora', 48.17059000, 31.10994000),
(1110066, 1004679, 'UA', 'Myhiya', 1, 'myhiya', 48.03719000, 30.95153000),
(1110071, 1004679, 'UA', 'Mykolayiv', 1, 'mykolayiv', 46.96591000, 31.99740000),
(1110106, 1004679, 'UA', 'Nova Odesa', 1, 'nova-odesa', 47.30778000, 31.78506000),
(1110159, 1004679, 'UA', 'Novyy Buh', 1, 'novyy-buh', 47.69308000, 32.52160000),
(1110176, 1004679, 'UA', 'Ochakiv', 1, 'ochakiv', 46.61283000, 31.54982000),
(1110185, 1004679, 'UA', 'Ol\'shanskoye', 1, 'ol-shanskoye', 47.18411000, 31.79375000),
(1110187, 1004679, 'UA', 'Oleksandrivka', 1, 'oleksandrivka', 46.83826000, 32.76116000),
(1110228, 1004679, 'UA', 'Parutyne', 1, 'parutyne', 46.70538000, 31.89709000),
(1110251, 1004679, 'UA', 'Pervomays’k', 1, 'pervomays-k', 48.04433000, 30.85073000),
(1110267, 1004679, 'UA', 'Pidhorodna', 1, 'pidhorodna', 48.10704000, 30.88953000),
(1110396, 1004679, 'UA', 'Rybakivka', 1, 'rybakivka', 46.61712000, 31.34995000),
(1110443, 1004679, 'UA', 'Shevchenkove', 1, 'shevchenkove', 46.86289000, 32.20387000),
(1110492, 1004679, 'UA', 'Snihurivka', 1, 'snihurivka', 47.07579000, 32.80516000),
(1110716, 1004679, 'UA', 'Veselynove', 1, 'veselynove', 47.35666000, 31.23488000),
(1110751, 1004679, 'UA', 'Voznesensk', 1, 'voznesensk', 47.56494000, 31.33078000),
(1110752, 1004679, 'UA', 'Vradiyivka', 1, 'vradiyivka', 47.86195000, 30.59195000),
(1110805, 1004679, 'UA', 'Yuzhnoukrains\'k', 1, 'yuzhnoukrains-k', 47.81777000, 31.18263000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004688, 'UA', 'Odessa Oblast', 1, 'odessa-oblast');

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 
(1109330, 1004688, 'UA', 'Artsyz', 1, 'artsyz', 45.99194000, 29.41824000),
(1109346, 1004688, 'UA', 'Balta', 1, 'balta', 47.93548000, 29.61982000),
(1109347, 1004688, 'UA', 'Balts’kyy Rayon', 1, 'balts-kyy-rayon', 47.99828000, 29.64835000),
(1109379, 1004688, 'UA', 'Berezivka', 1, 'berezivka', 47.20429000, 30.90780000),
(1109386, 1004688, 'UA', 'Berezyne', 1, 'berezyne', 46.22968000, 29.20436000),
(1109396, 1004688, 'UA', 'Bilhorod-Dnistrovskyi', 1, 'bilhorod-dnistrovskyi', 46.19520000, 30.34938000),
(1109406, 1004688, 'UA', 'Bilyayivka', 1, 'bilyayivka', 46.48319000, 30.21678000),
(1109425, 1004688, 'UA', 'Bolhrad', 1, 'bolhrad', 45.68262000, 28.61487000),
(1109428, 1004688, 'UA', 'Borodino', 1, 'borodino', 46.30250000, 29.24167000),
(1109448, 1004688, 'UA', 'Broska', 1, 'broska', 45.37327000, 28.78300000),
(1109513, 1004688, 'UA', 'Chornomors’k', 1, 'chornomors-k', 46.30495000, 30.65478000),
(1109545, 1004688, 'UA', 'Dmytrivka', 1, 'dmytrivka', 45.97167000, 28.98639000),
(1109601, 1004688, 'UA', 'Fontanka', 1, 'fontanka', 46.56646000, 30.85965000),
(1109646, 1004688, 'UA', 'Horodnye', 1, 'horodnye', 45.89083000, 28.84833000),
(1109678, 1004688, 'UA', 'Ivanivka', 1, 'ivanivka', 46.97569000, 30.46998000),
(1109687, 1004688, 'UA', 'Izmayil', 1, 'izmayil', 45.34929000, 28.84079000),
(1109699, 1004688, 'UA', 'Kalcheva', 1, 'kalcheva', 45.73746000, 28.81441000),
(1109713, 1004688, 'UA', 'Kamyshevka Vtoraya', 1, 'kamyshevka-vtoraya', 46.23333000, 29.83333000),
(1109717, 1004688, 'UA', 'Karolino-Buhaz', 1, 'karolino-buhaz', 46.14492000, 30.52609000),
(1109747, 1004688, 'UA', 'Kiliya', 1, 'kiliya', 45.45518000, 29.26367000),
(1109769, 1004688, 'UA', 'Kodyma', 1, 'kodyma', 48.09875000, 29.12463000),
(1109770, 1004688, 'UA', 'Kodyms’kyy Rayon', 1, 'kodyms-kyy-rayon', 48.02284000, 29.14010000),
(1109847, 1004688, 'UA', 'Krasnosilka', 1, 'krasnosilka', 46.62258000, 30.77421000),
(1109859, 1004688, 'UA', 'Kremidivka', 1, 'kremidivka', 46.73351000, 30.78472000),
(1109878, 1004688, 'UA', 'Kryzhanivka', 1, 'kryzhanivka', 46.56167000, 30.79487000),
(1109880, 1004688, 'UA', 'Kuchurhan', 1, 'kuchurhan', 47.16302000, 29.78937000),
(1109883, 1004688, 'UA', 'Kulevcha', 1, 'kulevcha', 46.03034000, 29.93614000),
(1109889, 1004688, 'UA', 'Kurisove', 1, 'kurisove', 46.96951000, 30.95914000),
(1109953, 1004688, 'UA', 'Lymanske', 1, 'lymanske', 46.65570000, 29.96722000),
(1109962, 1004688, 'UA', 'Lyubashivka', 1, 'lyubashivka', 47.83716000, 30.25976000),
(1110009, 1004688, 'UA', 'Mayaky', 1, 'mayaky', 46.41748000, 30.27413000),
(1110072, 1004688, 'UA', 'Mykolayivka', 1, 'mykolayivka', 47.54135000, 30.75615000),
(1110073, 1004688, 'UA', 'Mykolayivs’kyy Rayon', 1, 'mykolayivs-kyy-rayon', 47.46720000, 30.60283000),
(1110117, 1004688, 'UA', 'Novi Troyany', 1, 'novi-troyany', 45.94275000, 28.85628000),
(1110177, 1004688, 'UA', 'Odessa', 1, 'odessa', 46.47747000, 30.73262000),
(1110181, 1004688, 'UA', 'Okny', 1, 'okny', 47.54044000, 29.46001000),
(1110188, 1004688, 'UA', 'Oleksandrivka', 1, 'oleksandrivka', 46.32893000, 30.63481000),
(1110213, 1004688, 'UA', 'Ovidiopol', 1, 'ovidiopol', 46.24998000, 30.44127000),
(1110218, 1004688, 'UA', 'Ozerne', 1, 'ozerne', 45.40300000, 28.67546000),
(1110253, 1004688, 'UA', 'Peschana', 1, 'peschana', 48.12918000, 29.73086000),
(1110276, 1004688, 'UA', 'Plakhtiyivka', 1, 'plakhtiyivka', 46.10060000, 29.72169000),
(1110285, 1004688, 'UA', 'Podil’s’k', 1, 'podil-s-k', 47.75305000, 29.53205000),
(1110284, 1004688, 'UA', 'Podilsk Raion', 1, 'podilsk-raion', 47.71642000, 29.54509000),
(1110351, 1004688, 'UA', 'Reni', 1, 'reni', 45.45623000, 28.27914000),
(1110377, 1004688, 'UA', 'Rozdil’na', 1, 'rozdil-na', 46.84334000, 30.07919000),
(1110404, 1004688, 'UA', 'Salhany', 1, 'salhany', 46.14881000, 30.34601000),
(1110406, 1004688, 'UA', 'Sarata', 1, 'sarata', 46.01966000, 29.66567000),
(1110410, 1004688, 'UA', 'Savran', 1, 'savran', 48.13219000, 30.08247000),
(1110425, 1004688, 'UA', 'Serhiyivka', 1, 'serhiyivka', 46.02720000, 30.37682000),
(1110426, 1004688, 'UA', 'Serpneve', 1, 'serpneve', 46.30094000, 29.01958000),
(1110427, 1004688, 'UA', 'Shabo', 1, 'shabo', 46.13262000, 30.38595000),
(1110444, 1004688, 'UA', 'Shevchenkove', 1, 'shevchenkove', 45.55604000, 29.33357000),
(1110457, 1004688, 'UA', 'Shyryayeve', 1, 'shyryayeve', 47.38052000, 30.19638000),
(1110482, 1004688, 'UA', 'Slobidka', 1, 'slobidka', 47.88694000, 29.34611000),
(1110534, 1004688, 'UA', 'Starokozache', 1, 'starokozache', 46.33722000, 29.98528000),
(1110548, 1004688, 'UA', 'Stepanivka', 1, 'stepanivka', 46.79489000, 29.98684000),
(1110550, 1004688, 'UA', 'Stepove', 1, 'stepove', 46.70385000, 30.07919000),
(1110591, 1004688, 'UA', 'Tarutyne', 1, 'tarutyne', 46.18636000, 29.15203000),
(1110592, 1004688, 'UA', 'Tatarbunary', 1, 'tatarbunary', 45.83731000, 29.61424000),
(1110594, 1004688, 'UA', 'Tayirove', 1, 'tayirove', 46.36313000, 30.64891000),
(1110598, 1004688, 'UA', 'Teplodar', 1, 'teplodar', 46.50585000, 30.32521000),
(1110660, 1004688, 'UA', 'Usatove', 1, 'usatove', 46.53296000, 30.65960000),
(1110686, 1004688, 'UA', 'Velyka Mykhaylivka', 1, 'velyka-mykhaylivka', 47.07971000, 29.85753000),
(1110693, 1004688, 'UA', 'Velykoploske', 1, 'velykoploske', 47.01254000, 29.67171000),
(1110755, 1004688, 'UA', 'Vylkove', 1, 'vylkove', 45.40214000, 29.58595000),
(1110759, 1004688, 'UA', 'Vynohradivka', 1, 'vynohradivka', 45.68119000, 28.57138000),
(1110804, 1004688, 'UA', 'Yuzhne', 1, 'yuzhne', 46.62211000, 31.10131000),
(1110808, 1004688, 'UA', 'Zagnitkiv', 1, 'zagnitkiv', 48.04878000, 28.89234000),
(1110810, 1004688, 'UA', 'Zakharivka', 1, 'zakharivka', 47.33232000, 29.75903000),
(1110815, 1004688, 'UA', 'Zaliznychne', 1, 'zaliznychne', 45.74890000, 28.61466000),
(1110826, 1004688, 'UA', 'Zatoka', 1, 'zatoka', 46.07251000, 30.46538000),
(1110827, 1004688, 'UA', 'Zatyshshya', 1, 'zatyshshya', 47.33351000, 29.87327000),
(1110865, 1004688, 'UA', 'Zorya', 1, 'zorya', 45.99080000, 29.69672000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004683, 'UA', 'Rivne Oblast', 1, 'rivne-oblast');

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 
(1109535, 1004683, 'UA', 'Demydivs’kyy Rayon', 1, 'demydivs-kyy-rayon', 50.44302000, 25.29061000),
(1109584, 1004683, 'UA', 'Dubno', 1, 'dubno', 50.41694000, 25.73432000),
(1109586, 1004683, 'UA', 'Dubrovytsya', 1, 'dubrovytsya', 51.57438000, 26.56503000),
(1109652, 1004683, 'UA', 'Horodyshche', 1, 'horodyshche', 50.63965000, 26.36573000),
(1109654, 1004683, 'UA', 'Hoshcha', 1, 'hoshcha', 50.60030000, 26.67435000),
(1109762, 1004683, 'UA', 'Klevan', 1, 'klevan', 50.74305000, 25.97628000),
(1109773, 1004683, 'UA', 'Kolodenka', 1, 'kolodenka', 50.58561000, 26.31601000),
(1109778, 1004683, 'UA', 'Koloniya Zastav’ye', 1, 'koloniya-zastav-ye', 50.81667000, 27.03333000),
(1109795, 1004683, 'UA', 'Korets', 1, 'korets', 50.61655000, 27.16055000),
(1109813, 1004683, 'UA', 'Kostopil’', 1, 'kostopil', 50.87841000, 26.45192000),
(1110041, 1004683, 'UA', 'Mizoch', 1, 'mizoch', 50.40000000, 26.15000000),
(1110043, 1004683, 'UA', 'Mlyniv', 1, 'mlyniv', 50.50900000, 25.61675000),
(1110044, 1004683, 'UA', 'Mlynivs’kyy Rayon', 1, 'mlynivs-kyy-rayon', 50.55726000, 25.57715000),
(1110205, 1004683, 'UA', 'Orzhiv', 1, 'orzhiv', 50.80000000, 26.12000000),
(1110208, 1004683, 'UA', 'Ostroh', 1, 'ostroh', 50.32942000, 26.51425000),
(1110210, 1004683, 'UA', 'Ostroz’ka Mis’krada', 1, 'ostroz-ka-mis-krada', 50.32726000, 26.51765000),
(1110339, 1004683, 'UA', 'Radyvyliv', 1, 'radyvyliv', 50.12994000, 25.25576000),
(1110354, 1004683, 'UA', 'Rivne', 1, 'rivne', 50.62308000, 26.22743000),
(1110356, 1004683, 'UA', 'Rivnens’ka Mis’krada', 1, 'rivnens-ka-mis-krada', 50.61300000, 26.24588000),
(1110364, 1004683, 'UA', 'Rokytne', 1, 'rokytne', 51.27960000, 27.21400000),
(1110407, 1004683, 'UA', 'Sarny', 1, 'sarny', 51.33795000, 26.60191000),
(1110589, 1004683, 'UA', 'Tarakaniv', 1, 'tarakaniv', 50.37961000, 25.70843000),
(1110642, 1004683, 'UA', 'Tynne', 1, 'tynne', 50.60145000, 26.18486000),
(1110672, 1004683, 'UA', 'Varash', 1, 'varash', 51.35090000, 25.84738000),
(1110691, 1004683, 'UA', 'Velyki Mezhyrichi', 1, 'velyki-mezhyrichi', 50.65431000, 26.86626000),
(1110735, 1004683, 'UA', 'Volodymyrets’', 1, 'volodymyrets', 51.42130000, 26.14469000),
(1110824, 1004683, 'UA', 'Zarichne', 1, 'zarichne', 51.81260000, 26.12902000),
(1110833, 1004683, 'UA', 'Zdolbuniv', 1, 'zdolbuniv', 50.52060000, 26.24251000),
(1110834, 1004683, 'UA', 'Zdovbytsya', 1, 'zdovbytsya', 50.49607000, 26.24111000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004685, 'UA', 'Sumy Oblast', 1, 'sumy-oblast');

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 
(1109402, 1004685, 'UA', 'Bilopillya', 1, 'bilopillya', 51.15016000, 34.31287000),
(1109430, 1004685, 'UA', 'Boromlya', 1, 'boromlya', 50.61839000, 34.97042000),
(1109463, 1004685, 'UA', 'Buryn’', 1, 'buryn', 51.19912000, 33.83523000),
(1109580, 1004685, 'UA', 'Druzhba', 1, 'druzhba', 52.04545000, 33.94517000),
(1109632, 1004685, 'UA', 'Hlukhiv', 1, 'hlukhiv', 51.67822000, 33.91620000),
(1109789, 1004685, 'UA', 'Konotop', 1, 'konotop', 51.24032000, 33.20263000),
(1109846, 1004685, 'UA', 'Krasnopillya', 1, 'krasnopillya', 50.77458000, 35.25965000),
(1109866, 1004685, 'UA', 'Krolevets’', 1, 'krolevets', 51.54775000, 33.38475000),
(1109898, 1004685, 'UA', 'Kyrykivka', 1, 'kyrykivka', 50.36408000, 35.11490000),
(1109908, 1004685, 'UA', 'Lebedyn', 1, 'lebedyn', 50.58518000, 34.48490000),
(1109956, 1004685, 'UA', 'Lypova Dolyna', 1, 'lypova-dolyna', 50.56428000, 33.79793000),
(1110024, 1004685, 'UA', 'Mezenivka', 1, 'mezenivka', 50.63486000, 35.31340000),
(1110087, 1004685, 'UA', 'Nedryhayliv', 1, 'nedryhayliv', 50.83398000, 33.87626000),
(1110169, 1004685, 'UA', 'Nyzy', 1, 'nyzy', 50.78281000, 34.78441000),
(1110180, 1004685, 'UA', 'Okhtyrka', 1, 'okhtyrka', 50.31036000, 34.89879000),
(1110332, 1004685, 'UA', 'Putyvl’', 1, 'putyvl', 51.33745000, 33.87066000),
(1110368, 1004685, 'UA', 'Romens’ka Mis’krada', 1, 'romens-ka-mis-krada', 50.74306000, 33.48284000),
(1110369, 1004685, 'UA', 'Romny', 1, 'romny', 50.75104000, 33.47471000),
(1110424, 1004685, 'UA', 'Seredyna-Buda', 1, 'seredyna-buda', 52.18903000, 34.03639000),
(1110429, 1004685, 'UA', 'Shalyhyne', 1, 'shalyhyne', 51.57167000, 34.12167000),
(1110450, 1004685, 'UA', 'Shostka', 1, 'shostka', 51.86296000, 33.46980000),
(1110483, 1004685, 'UA', 'Sloboda', 1, 'sloboda', 51.19806000, 33.60695000),
(1110563, 1004685, 'UA', 'Sumy', 1, 'sumy', 50.92160000, 34.80029000),
(1110604, 1004685, 'UA', 'Terny', 1, 'terny', 50.98916000, 33.97070000),
(1110621, 1004685, 'UA', 'Trostyanets’', 1, 'trostyanets', 50.48478000, 34.96567000),
(1110688, 1004685, 'UA', 'Velyka Pysarivka', 1, 'velyka-pysarivka', 50.42430000, 35.47989000),
(1110708, 1004685, 'UA', 'Verkhnya Syrovatka', 1, 'verkhnya-syrovatka', 50.82902000, 34.95861000),
(1110744, 1004685, 'UA', 'Vorozhba', 1, 'vorozhba', 51.17334000, 34.21917000),
(1110781, 1004685, 'UA', 'Yampil’', 1, 'yampil', 51.94765000, 33.78759000),
(1110799, 1004685, 'UA', 'Yesman’', 1, 'yesman', 51.77006000, 34.06729000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004674, 'UA', 'Ternopil Oblast', 1, 'ternopil-oblast');

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 
(1109362, 1004674, 'UA', 'Belaya', 1, 'belaya', 49.02900000, 25.77059000),
(1109434, 1004674, 'UA', 'Borshchiv', 1, 'borshchiv', 48.80332000, 26.04347000),
(1109457, 1004674, 'UA', 'Buchach', 1, 'buchach', 49.06254000, 25.38798000),
(1109517, 1004674, 'UA', 'Chortkiv', 1, 'chortkiv', 49.01709000, 25.79804000),
(1109579, 1004674, 'UA', 'Druzhba', 1, 'druzhba', 49.04251000, 25.45055000),
(1109657, 1004674, 'UA', 'Hrymayliv', 1, 'hrymayliv', 49.33208000, 26.01112000),
(1109662, 1004674, 'UA', 'Husiatyn', 1, 'husiatyn', 49.07290000, 26.18480000),
(1109738, 1004674, 'UA', 'Khorostkiv', 1, 'khorostkiv', 49.21114000, 25.92165000),
(1109793, 1004674, 'UA', 'Kopychyntsi', 1, 'kopychyntsi', 49.10441000, 25.91026000),
(1109826, 1004674, 'UA', 'Kozova', 1, 'kozova', 49.43544000, 25.15086000),
(1109858, 1004674, 'UA', 'Kremenets', 1, 'kremenets', 50.09693000, 25.72459000),
(1109904, 1004674, 'UA', 'Lanivtsi', 1, 'lanivtsi', 49.86328000, 26.09082000),
(1110029, 1004674, 'UA', 'Mikulintsy', 1, 'mikulintsy', 49.39600000, 25.60518000),
(1110163, 1004674, 'UA', 'Nyrkiv', 1, 'nyrkiv', 48.81492000, 25.59989000),
(1110216, 1004674, 'UA', 'Ozerna', 1, 'ozerna', 49.62891000, 25.32895000),
(1110256, 1004674, 'UA', 'Petrikov', 1, 'petrikov', 49.53122000, 25.57901000),
(1110265, 1004674, 'UA', 'Pidhaytsi', 1, 'pidhaytsi', 49.26853000, 25.13341000),
(1110270, 1004674, 'UA', 'Pidvolochysk', 1, 'pidvolochysk', 49.53472000, 26.14585000),
(1110282, 1004674, 'UA', 'Pochaiv', 1, 'pochaiv', 50.00509000, 25.51183000),
(1110467, 1004674, 'UA', 'Skala-Podil’s’ka', 1, 'skala-podil-s-ka', 48.85149000, 26.19909000),
(1110468, 1004674, 'UA', 'Skalat', 1, 'skalat', 49.42732000, 25.97869000),
(1110601, 1004674, 'UA', 'Terebovlya', 1, 'terebovlya', 49.30187000, 25.70997000),
(1110602, 1004674, 'UA', 'Ternopil', 1, 'ternopil', 49.55342000, 25.58918000),
(1110619, 1004674, 'UA', 'Tovste', 1, 'tovste', 48.84663000, 25.72621000),
(1110682, 1004674, 'UA', 'Velikiye Borki', 1, 'velikiye-borki', 49.52363000, 25.75753000),
(1110772, 1004674, 'UA', 'Yahil’nytsya', 1, 'yahil-nytsya', 48.94248000, 25.74375000),
(1110814, 1004674, 'UA', 'Zalishchyky', 1, 'zalishchyky', 48.64331000, 25.73794000),
(1110818, 1004674, 'UA', 'Zaliztsi', 1, 'zaliztsi', 49.79188000, 25.37297000),
(1110831, 1004674, 'UA', 'Zbarazh', 1, 'zbarazh', 49.66357000, 25.77616000),
(1110832, 1004674, 'UA', 'Zboriv', 1, 'zboriv', 49.66484000, 25.14097000),
(1110863, 1004674, 'UA', 'Zolotyy Potik', 1, 'zolotyy-potik', 48.90950000, 25.33926000),
(1110873, 1004674, 'UA', 'Бережани', 1, 'n-a', 49.45000000, 24.93333000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004669, 'UA', 'Vinnytsia Oblast', 1, 'vinnytsia-oblast');

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 
(1109349, 1004669, 'UA', 'Bar', 1, 'bar', 49.07717000, 27.68256000),
(1109351, 1004669, 'UA', 'Barskiy Rayon', 1, 'barskiy-rayon', 49.06667000, 27.68333000),
(1109387, 1004669, 'UA', 'Bershad', 1, 'bershad', 48.36782000, 29.51726000),
(1109443, 1004669, 'UA', 'Brailiv', 1, 'brailiv', 49.10986000, 28.17459000),
(1109445, 1004669, 'UA', 'Bratslav', 1, 'bratslav', 48.82257000, 28.94070000),
(1109475, 1004669, 'UA', 'Chechelnyk', 1, 'chechelnyk', 48.21509000, 29.36728000),
(1109484, 1004669, 'UA', 'Chernivets’kyy Rayon', 1, 'chernivets-kyy-rayon', 48.51106000, 28.14191000),
(1109485, 1004669, 'UA', 'Chernivtsi', 1, 'chernivtsi', 48.54225000, 28.11473000),
(1109530, 1004669, 'UA', 'Dashiv', 1, 'dashiv', 49.00449000, 29.42559000),
(1109624, 1004669, 'UA', 'Haisyn', 1, 'haisyn', 48.81143000, 29.38977000),
(1109667, 1004669, 'UA', 'Illintsi', 1, 'illintsi', 49.10479000, 29.21773000),
(1109704, 1004669, 'UA', 'Kalynivka', 1, 'kalynivka', 49.45389000, 28.52608000),
(1109732, 1004669, 'UA', 'Khmilnyk', 1, 'khmilnyk', 49.55979000, 27.95754000),
(1109759, 1004669, 'UA', 'Klembivka', 1, 'klembivka', 48.39037000, 28.41092000),
(1109792, 1004669, 'UA', 'Kopayhorod', 1, 'kopayhorod', 48.85917000, 27.79690000),
(1109827, 1004669, 'UA', 'Kozyatyn', 1, 'kozyatyn', 49.71431000, 28.83385000),
(1109879, 1004669, 'UA', 'Kryzhopil’', 1, 'kryzhopil', 48.38289000, 28.86622000),
(1109902, 1004669, 'UA', 'Ladyzhyn', 1, 'ladyzhyn', 48.68496000, 29.23679000),
(1109921, 1004669, 'UA', 'Lityn', 1, 'lityn', 49.32509000, 28.08094000),
(1109922, 1004669, 'UA', 'Lityns’kyy Rayon', 1, 'lityns-kyy-rayon', 49.37138000, 28.07033000),
(1109957, 1004669, 'UA', 'Lypovets’kyy Rayon', 1, 'lypovets-kyy-rayon', 49.28006000, 28.93205000),
(1110045, 1004669, 'UA', 'Mohyliv-Podilskyi', 1, 'mohyliv-podilskyi', 48.44598000, 27.79820000),
(1110060, 1004669, 'UA', 'Murafa', 1, 'murafa', 48.76763000, 28.21569000),
(1110063, 1004669, 'UA', 'Murovani Kurylivtsi', 1, 'murovani-kurylivtsi', 48.72348000, 27.51892000),
(1110091, 1004669, 'UA', 'Nemyriv', 1, 'nemyriv', 48.97076000, 28.83779000),
(1110108, 1004669, 'UA', 'Nova Pryluka', 1, 'nova-pryluka', 49.37488000, 28.69955000),
(1110171, 1004669, 'UA', 'Obodivka', 1, 'obodivka', 48.40514000, 29.24775000),
(1110199, 1004669, 'UA', 'Orativ', 1, 'orativ', 49.18889000, 29.52697000),
(1110230, 1004669, 'UA', 'Pavlivka', 1, 'pavlivka', 49.44143000, 28.45956000),
(1110288, 1004669, 'UA', 'Pohrebyshche', 1, 'pohrebyshche', 49.48639000, 29.26361000),
(1110289, 1004669, 'UA', 'Pohrebyshchens’kyy Rayon', 1, 'pohrebyshchens-kyy-rayon', 49.48126000, 29.25953000),
(1110419, 1004669, 'UA', 'Serebriya', 1, 'serebriya', 48.45593000, 27.71923000),
(1110430, 1004669, 'UA', 'Sharhorod', 1, 'sharhorod', 48.75587000, 28.07507000),
(1110496, 1004669, 'UA', 'Sobolivka', 1, 'sobolivka', 49.33604000, 28.65096000),
(1110566, 1004669, 'UA', 'Sutysky', 1, 'sutysky', 49.04245000, 28.41733000),
(1110600, 1004669, 'UA', 'Teplyk', 1, 'teplyk', 48.66566000, 29.74504000),
(1110614, 1004669, 'UA', 'Tomashpil’', 1, 'tomashpil', 48.54256000, 28.51684000),
(1110617, 1004669, 'UA', 'Torkanivka', 1, 'torkanivka', 48.32462000, 29.14746000),
(1110633, 1004669, 'UA', 'Tsybulevka', 1, 'tsybulevka', 48.38719000, 29.10288000),
(1110636, 1004669, 'UA', 'Tulchyn', 1, 'tulchyn', 48.67448000, 28.84641000),
(1110637, 1004669, 'UA', 'Turbiv', 1, 'turbiv', 49.34788000, 28.72117000),
(1110647, 1004669, 'UA', 'Tyvriv', 1, 'tyvriv', 49.01404000, 28.50846000),
(1110654, 1004669, 'UA', 'Ulaniv', 1, 'ulaniv', 49.69512000, 28.13298000),
(1110671, 1004669, 'UA', 'Vapnyarka', 1, 'vapnyarka', 48.53479000, 28.74358000),
(1110698, 1004669, 'UA', 'Vendychany', 1, 'vendychany', 48.61176000, 27.79324000),
(1110720, 1004669, 'UA', 'Vinnitskiy Rayon', 1, 'vinnitskiy-rayon', 49.23531000, 28.47588000),
(1110722, 1004669, 'UA', 'Vinnytsia', 1, 'vinnytsia', 49.23278000, 28.48097000),
(1110727, 1004669, 'UA', 'Viytivka', 1, 'viytivka', 48.42603000, 29.54291000),
(1110743, 1004669, 'UA', 'Voronovytsya', 1, 'voronovytsya', 49.10954000, 28.68078000),
(1110780, 1004669, 'UA', 'Yampil’', 1, 'yampil', 48.24240000, 28.28195000),
(1110844, 1004669, 'UA', 'Zhmerynka', 1, 'zhmerynka', 49.03705000, 28.11201000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004690, 'UA', 'Volyn Oblast', 1, 'volyn-oblast');

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 
(1109377, 1004690, 'UA', 'Berestechko', 1, 'berestechko', 50.36047000, 25.11071000),
(1109409, 1004690, 'UA', 'Blahodatne', 1, 'blahodatne', 50.66365000, 24.24918000),
(1109656, 1004690, 'UA', 'Hołoby', 1, 'holoby', 51.08651000, 25.00767000),
(1109653, 1004690, 'UA', 'Horokhiv', 1, 'horokhiv', 50.50186000, 24.76149000),
(1109712, 1004690, 'UA', 'Kamin-Kashyrskyi', 1, 'kamin-kashyrskyi', 51.62412000, 24.95864000),
(1109756, 1004690, 'UA', 'Kivertsi', 1, 'kivertsi', 50.83425000, 25.45821000),
(1109820, 1004690, 'UA', 'Kovel', 1, 'kovel', 51.21526000, 24.70867000),
(1109821, 1004690, 'UA', 'Kovel’s’ka Mis’krada', 1, 'kovel-s-ka-mis-krada', 51.21198000, 24.70163000),
(1109924, 1004690, 'UA', 'Liuboml', 1, 'liuboml', 51.22601000, 24.03727000),
(1109928, 1004690, 'UA', 'Lokachi', 1, 'lokachi', 50.73700000, 24.64944000),
(1109943, 1004690, 'UA', 'Lukiv', 1, 'lukiv', 51.05210000, 25.40059000),
(1109944, 1004690, 'UA', 'Lutsk', 1, 'lutsk', 50.75932000, 25.34244000),
(1109964, 1004690, 'UA', 'Lyubeshivs’kyy Rayon', 1, 'lyubeshivs-kyy-rayon', 51.79639000, 25.33133000),
(1109965, 1004690, 'UA', 'Lyuboml’s’kyy Rayon', 1, 'lyuboml-s-kyy-rayon', 51.25062000, 24.01161000),
(1109992, 1004690, 'UA', 'Manevychi', 1, 'manevychi', 51.29405000, 25.53436000),
(1109993, 1004690, 'UA', 'Manevyts’kyy Rayon', 1, 'manevyts-kyy-rayon', 51.24513000, 25.60945000),
(1110152, 1004690, 'UA', 'Novovolyns’k', 1, 'novovolyns-k', 50.72576000, 24.16265000),
(1110162, 1004690, 'UA', 'Nuyno', 1, 'nuyno', 51.54628000, 24.91018000),
(1110195, 1004690, 'UA', 'Olyka', 1, 'olyka', 50.71855000, 25.81251000),
(1110273, 1004690, 'UA', 'Pishcha', 1, 'pishcha', 51.60928000, 23.82079000),
(1110342, 1004690, 'UA', 'Rakiv Lis', 1, 'rakiv-lis', 51.62174000, 24.92427000),
(1110345, 1004690, 'UA', 'Ratne', 1, 'ratne', 51.66830000, 24.53030000),
(1110346, 1004690, 'UA', 'Ratnivs’kyy Rayon', 1, 'ratnivs-kyy-rayon', 51.71712000, 24.51959000),
(1110381, 1004690, 'UA', 'Rozhyshche', 1, 'rozhyshche', 50.91542000, 25.26906000),
(1110431, 1004690, 'UA', 'Shats’k', 1, 'shats-k', 51.50208000, 23.93806000),
(1110432, 1004690, 'UA', 'Shats’kyy Rayon', 1, 'shats-kyy-rayon', 51.52237000, 23.86522000),
(1110528, 1004690, 'UA', 'Stara Vyzhivka', 1, 'stara-vyzhivka', 51.43762000, 24.43997000),
(1110578, 1004690, 'UA', 'Svityaz’', 1, 'svityaz', 51.48211000, 23.85904000),
(1110734, 1004690, 'UA', 'Volodymyr-Volynskyi', 1, 'volodymyr-volynskyi', 50.85253000, 24.32364000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004670, 'UA', 'Zakarpattia Oblast', 1, 'zakarpattia-oblast');

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 
(1109357, 1004670, 'UA', 'Batiovo', 1, 'batiovo', 48.36166000, 22.39970000),
(1109373, 1004670, 'UA', 'Berehivs’ka Mis’krada', 1, 'berehivs-ka-mis-krada', 48.21255000, 22.65536000),
(1109375, 1004670, 'UA', 'Berehove', 1, 'berehove', 48.20555000, 22.64418000),
(1109376, 1004670, 'UA', 'Berehove Raion', 1, 'berehove-raion', 48.16667000, 22.66667000),
(1109383, 1004670, 'UA', 'Bereznyky', 1, 'bereznyky', 48.51407000, 23.21982000),
(1109385, 1004670, 'UA', 'Berezovo', 1, 'berezovo', 48.30943000, 23.47400000),
(1109398, 1004670, 'UA', 'Bilky', 1, 'bilky', 48.31503000, 23.13248000),
(1109414, 1004670, 'UA', 'Bobovo', 1, 'bobovo', 48.07166000, 22.89585000),
(1109418, 1004670, 'UA', 'Bohdan', 1, 'bohdan', 48.04122000, 24.35222000),
(1109464, 1004670, 'UA', 'Bushtyno', 1, 'bushtyno', 48.05121000, 23.48579000),
(1109508, 1004670, 'UA', 'Chop', 1, 'chop', 48.43198000, 22.20555000),
(1109525, 1004670, 'UA', 'Chynadiyovo', 1, 'chynadiyovo', 48.48179000, 22.82170000),
(1109573, 1004670, 'UA', 'Dovhe', 1, 'dovhe', 48.36527000, 23.27904000),
(1109576, 1004670, 'UA', 'Drahovo', 1, 'drahovo', 48.23573000, 23.54914000),
(1109585, 1004670, 'UA', 'Dubove', 1, 'dubove', 48.17205000, 23.88954000),
(1109640, 1004670, 'UA', 'Horinchovo', 1, 'horinchovo', 48.27076000, 23.43475000),
(1109674, 1004670, 'UA', 'Irshava', 1, 'irshava', 48.31667000, 23.03846000),
(1109675, 1004670, 'UA', 'Irshava Raion', 1, 'irshava-raion', 48.33333000, 23.08333000),
(1109686, 1004670, 'UA', 'Iza', 1, 'iza', 48.21525000, 23.32867000),
(1109706, 1004670, 'UA', 'Kalyny', 1, 'kalyny', 48.14078000, 23.87380000),
(1109711, 1004670, 'UA', 'Kamianytsia', 1, 'kamianytsia', 48.69343000, 22.39570000),
(1109742, 1004670, 'UA', 'Khust', 1, 'khust', 48.17930000, 23.29909000),
(1109743, 1004670, 'UA', 'Khust Raion', 1, 'khust-raion', 48.25000000, 23.41667000),
(1109744, 1004670, 'UA', 'Khusts’ka Mis’krada', 1, 'khusts-ka-mis-krada', 48.19058000, 23.30322000),
(1109772, 1004670, 'UA', 'Kolochava', 1, 'kolochava', 48.42851000, 23.69590000),
(1109791, 1004670, 'UA', 'Kopashnovo', 1, 'kopashnovo', 48.21970000, 23.48457000),
(1109799, 1004670, 'UA', 'Korolevo', 1, 'korolevo', 48.15247000, 23.13659000),
(1109810, 1004670, 'UA', 'Koson’', 1, 'koson', 48.25505000, 22.45597000),
(1109873, 1004670, 'UA', 'Kryva', 1, 'kryva', 48.17234000, 23.23647000),
(1109891, 1004670, 'UA', 'Kushnytsya', 1, 'kushnytsya', 48.43988000, 23.25816000),
(1109896, 1004670, 'UA', 'Kvasy', 1, 'kvasy', 48.14973000, 24.27995000),
(1109905, 1004670, 'UA', 'Lazeshchyna', 1, 'lazeshchyna', 48.26852000, 24.42010000),
(1109906, 1004670, 'UA', 'Lazi', 1, 'lazi', 48.06667000, 24.23333000),
(1109930, 1004670, 'UA', 'Lopukhiv', 1, 'lopukhiv', 48.36527000, 23.96382000),
(1109954, 1004670, 'UA', 'Lypcha', 1, 'lypcha', 48.26107000, 23.38336000),
(1109961, 1004670, 'UA', 'Lysychovo', 1, 'lysychovo', 48.49677000, 23.28992000),
(1110039, 1004670, 'UA', 'Mizhhirya', 1, 'mizhhirya', 48.52458000, 23.50563000),
(1110040, 1004670, 'UA', 'Mizhhirya Raion', 1, 'mizhhirya-raion', 48.58333000, 23.50000000),
(1110058, 1004670, 'UA', 'Mukacheve', 1, 'mukacheve', 48.43919000, 22.71779000),
(1110059, 1004670, 'UA', 'Mukachevo Raion', 1, 'mukachevo-raion', 48.41667000, 22.66667000),
(1110065, 1004670, 'UA', 'Muzhiyevo', 1, 'muzhiyevo', 48.17959000, 22.69943000),
(1110074, 1004670, 'UA', 'Mynay', 1, 'mynay', 48.58880000, 22.27502000),
(1110090, 1004670, 'UA', 'Nelipyno', 1, 'nelipyno', 48.56101000, 23.03146000),
(1110092, 1004670, 'UA', 'Neresnytsya', 1, 'neresnytsya', 48.11814000, 23.76588000),
(1110094, 1004670, 'UA', 'Nevyts’ke', 1, 'nevyts-ke', 48.67472000, 22.38813000),
(1110111, 1004670, 'UA', 'Nove Davydkovo', 1, 'nove-davydkovo', 48.44133000, 22.62164000),
(1110168, 1004670, 'UA', 'Nyzhnye Selyshche', 1, 'nyzhnye-selyshche', 48.19911000, 23.44757000),
(1110192, 1004670, 'UA', 'Oleshnyk', 1, 'oleshnyk', 48.16406000, 22.96167000),
(1110197, 1004670, 'UA', 'Onokivtsi', 1, 'onokivtsi', 48.65763000, 22.34183000),
(1110236, 1004670, 'UA', 'Perechyn', 1, 'perechyn', 48.73616000, 22.48200000),
(1110237, 1004670, 'UA', 'Perechyn Raion', 1, 'perechyn-raion', 48.75000000, 22.66667000),
(1110271, 1004670, 'UA', 'Pidvynohradiv', 1, 'pidvynohradiv', 48.13947000, 22.97194000),
(1110304, 1004670, 'UA', 'Poroshkovo', 1, 'poroshkovo', 48.66832000, 22.75328000),
(1110334, 1004670, 'UA', 'Pylypets', 1, 'pylypets', 48.65899000, 23.28346000),
(1110340, 1004670, 'UA', 'Rakhiv', 1, 'rakhiv', 48.05260000, 24.20089000),
(1110341, 1004670, 'UA', 'Rakhiv Raion', 1, 'rakhiv-raion', 48.08333000, 24.33333000),
(1110343, 1004670, 'UA', 'Rakoshyno', 1, 'rakoshyno', 48.46713000, 22.59687000),
(1110362, 1004670, 'UA', 'Rokosovo', 1, 'rokosovo', 48.21018000, 23.17624000),
(1110422, 1004670, 'UA', 'Serednye', 1, 'serednye', 48.54043000, 22.50696000),
(1110423, 1004670, 'UA', 'Serednye Vodyane', 1, 'serednye-vodyane', 47.98159000, 23.91041000),
(1110513, 1004670, 'UA', 'Solotvyno', 1, 'solotvyno', 47.94604000, 23.87035000),
(1110554, 1004670, 'UA', 'Storozhnytsya', 1, 'storozhnytsya', 48.60403000, 22.23269000),
(1110555, 1004670, 'UA', 'Strabychovo', 1, 'strabychovo', 48.39247000, 22.54308000),
(1110569, 1004670, 'UA', 'Svaliava Raion', 1, 'svaliava-raion', 48.55000000, 23.00000000),
(1110570, 1004670, 'UA', 'Svalyava', 1, 'svalyava', 48.54853000, 22.99578000),
(1110584, 1004670, 'UA', 'Synevyr', 1, 'synevyr', 48.48745000, 23.62575000),
(1110585, 1004670, 'UA', 'Synevyrska Poliana', 1, 'synevyrska-poliana', 48.58484000, 23.68910000),
(1110607, 1004670, 'UA', 'Tiachiv Raion', 1, 'tiachiv-raion', 48.08333000, 23.58333000),
(1110640, 1004670, 'UA', 'Tyachiv', 1, 'tyachiv', 48.01179000, 23.57061000),
(1110667, 1004670, 'UA', 'Uzhgorod', 1, 'uzhgorod', 48.61667000, 22.30000000),
(1110668, 1004670, 'UA', 'Uzhhorod Raion', 1, 'uzhhorod-raion', 48.58333000, 22.33333000),
(1110674, 1004670, 'UA', 'Vary', 1, 'vary', 48.12207000, 22.71281000),
(1110689, 1004670, 'UA', 'Velyki Berehy', 1, 'velyki-berehy', 48.23187000, 22.74591000),
(1110694, 1004670, 'UA', 'Velykyi Bereznyi', 1, 'velykyi-bereznyi', 48.88831000, 22.46052000),
(1110695, 1004670, 'UA', 'Velykyi Bereznyi Raion', 1, 'velykyi-bereznyi-raion', 48.91667000, 22.58333000),
(1110737, 1004670, 'UA', 'Volovets', 1, 'volovets', 48.71090000, 23.18510000),
(1110738, 1004670, 'UA', 'Volovets Raion', 1, 'volovets-raion', 48.75000000, 23.08333000),
(1110756, 1004670, 'UA', 'Vylok', 1, 'vylok', 48.10915000, 22.83865000),
(1110757, 1004670, 'UA', 'Vynohradiv', 1, 'vynohradiv', 48.14135000, 23.02666000),
(1110758, 1004670, 'UA', 'Vynohradiv Raion', 1, 'vynohradiv-raion', 48.16667000, 23.00000000),
(1110764, 1004670, 'UA', 'Vyshkovo', 1, 'vyshkovo', 48.04911000, 23.42113000),
(1110788, 1004670, 'UA', 'Yasinya', 1, 'yasinya', 48.27937000, 24.36042000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004687, 'UA', 'Zaporizhzhya Oblast', 1, 'zaporizhzhya-oblast');

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 
(1109345, 1004687, 'UA', 'Balky', 1, 'balky', 47.38336000, 34.94396000),
(1109367, 1004687, 'UA', 'Berdiansk Raion', 1, 'berdiansk-raion', 46.83333000, 36.75000000),
(1109369, 1004687, 'UA', 'Berdyans’ka Mis’krada', 1, 'berdyans-ka-mis-krada', 46.81565000, 36.77049000),
(1109368, 1004687, 'UA', 'Berdyansk', 1, 'berdyansk', 46.76644000, 36.79872000),
(1109471, 1004687, 'UA', 'Chapayevka', 1, 'chapayevka', 47.47114000, 36.34507000),
(1109482, 1004687, 'UA', 'Chernihivka Raion', 1, 'chernihivka-raion', 47.16667000, 36.25000000),
(1109551, 1004687, 'UA', 'Dniprorudne', 1, 'dniprorudne', 47.38169000, 34.97652000),
(1109552, 1004687, 'UA', 'Dniprovka', 1, 'dniprovka', 47.42945000, 34.61805000),
(1109595, 1004687, 'UA', 'Energodar', 1, 'energodar', 47.49865000, 34.65740000),
(1109660, 1004687, 'UA', 'Hulyaypole', 1, 'hulyaypole', 47.66389000, 36.25633000),
(1109748, 1004687, 'UA', 'Kirove', 1, 'kirove', 47.65311000, 35.69512000),
(1109785, 1004687, 'UA', 'Komysh-Zorya', 1, 'komysh-zorya', 47.32755000, 36.69298000),
(1109787, 1004687, 'UA', 'Komyshuvakha', 1, 'komyshuvakha', 47.71598000, 35.52981000),
(1109816, 1004687, 'UA', 'Kostyantynivka', 1, 'kostyantynivka', 46.81673000, 35.42287000),
(1109892, 1004687, 'UA', 'Kushuhum', 1, 'kushuhum', 47.71278000, 35.20917000),
(1109895, 1004687, 'UA', 'Kuybysheve', 1, 'kuybysheve', 47.35800000, 36.64908000),
(1109899, 1004687, 'UA', 'Kyrylivka', 1, 'kyrylivka', 46.37592000, 35.36753000),
(1109978, 1004687, 'UA', 'Mala Bilozerka', 1, 'mala-bilozerka', 47.24737000, 34.93457000),
(1109980, 1004687, 'UA', 'Mala Tokmachka', 1, 'mala-tokmachka', 47.53563000, 35.89293000),
(1109984, 1004687, 'UA', 'Malokaterynivka', 1, 'malokaterynivka', 47.65550000, 35.25649000),
(1110008, 1004687, 'UA', 'Matviyivka', 1, 'matviyivka', 47.07473000, 35.14444000),
(1110018, 1004687, 'UA', 'Melitopol', 1, 'melitopol', 46.84891000, 35.36533000),
(1110019, 1004687, 'UA', 'Melitopol’s’kyy Rayon', 1, 'melitopol-s-kyy-rayon', 46.90326000, 35.34616000),
(1110068, 1004687, 'UA', 'Mykhaylivka', 1, 'mykhaylivka', 47.27235000, 35.22235000),
(1110069, 1004687, 'UA', 'Mykhaylivs’kyy Rayon', 1, 'mykhaylivs-kyy-rayon', 47.22111000, 35.26580000),
(1110121, 1004687, 'UA', 'Novobohdanivka', 1, 'novobohdanivka', 47.08524000, 35.32945000),
(1110133, 1004687, 'UA', 'Novomykolayivka', 1, 'novomykolayivka', 47.97810000, 35.91020000),
(1110151, 1004687, 'UA', 'Novovasylivka', 1, 'novovasylivka', 46.83021000, 35.75136000),
(1110203, 1004687, 'UA', 'Orikhiv', 1, 'orikhiv', 47.56731000, 35.78575000),
(1110211, 1004687, 'UA', 'Osypenko', 1, 'osypenko', 46.91360000, 36.82530000),
(1110293, 1004687, 'UA', 'Polohy', 1, 'polohy', 47.48444000, 36.25361000),
(1110309, 1004687, 'UA', 'Preobrazhenka', 1, 'preobrazhenka', 47.57194000, 35.81667000),
(1110318, 1004687, 'UA', 'Pryazovske Raion', 1, 'pryazovske-raion', 46.66667000, 35.66667000),
(1110322, 1004687, 'UA', 'Prymors’k', 1, 'prymors-k', 46.73479000, 36.34425000),
(1110321, 1004687, 'UA', 'Prymorsk Raion', 1, 'prymorsk-raion', 46.83333000, 36.25000000),
(1110323, 1004687, 'UA', 'Pryshyb', 1, 'pryshyb', 47.25927000, 35.31953000),
(1110382, 1004687, 'UA', 'Rozivka', 1, 'rozivka', 47.38484000, 37.06792000),
(1110383, 1004687, 'UA', 'Rozivs’kyy Rayon', 1, 'rozivs-kyy-rayon', 47.46956000, 36.97192000),
(1110603, 1004687, 'UA', 'Ternuvate', 1, 'ternuvate', 47.83049000, 36.12761000),
(1110605, 1004687, 'UA', 'Terpinnya', 1, 'terpinnya', 46.96942000, 35.42100000),
(1110611, 1004687, 'UA', 'Tokmak', 1, 'tokmak', 47.25522000, 35.71238000),
(1110612, 1004687, 'UA', 'Tokmak Raion', 1, 'tokmak-raion', 47.25000000, 35.75000000),
(1110641, 1004687, 'UA', 'Tymoshivka', 1, 'tymoshivka', 47.18410000, 35.11625000),
(1110677, 1004687, 'UA', 'Vasylivka', 1, 'vasylivka', 47.43694000, 35.27417000),
(1110683, 1004687, 'UA', 'Velyka Bilozerka', 1, 'velyka-bilozerka', 47.27756000, 34.70616000),
(1110692, 1004687, 'UA', 'Velykobilozers’kyy Rayon', 1, 'velykobilozers-kyy-rayon', 47.24341000, 34.66137000),
(1110713, 1004687, 'UA', 'Vesele', 1, 'vesele', 47.01479000, 34.91504000),
(1110718, 1004687, 'UA', 'Vilniansk Raion', 1, 'vilniansk-raion', 48.00000000, 35.41667000),
(1110730, 1004687, 'UA', 'Vodyane', 1, 'vodyane', 47.48746000, 34.49235000),
(1110750, 1004687, 'UA', 'Voznesenka', 1, 'voznesenka', 46.87165000, 35.46458000),
(1110775, 1004687, 'UA', 'Yakymivka', 1, 'yakymivka', 46.69972000, 35.15916000),
(1110776, 1004687, 'UA', 'Yakymivka Raion', 1, 'yakymivka-raion', 46.58333000, 35.00000000),
(1110816, 1004687, 'UA', 'Zaliznychne', 1, 'zaliznychne', 47.65238000, 36.16524000),
(1110821, 1004687, 'UA', 'Zaporiz’ka Mis’krada', 1, 'zaporiz-ka-mis-krada', 47.84634000, 35.16824000),
(1110820, 1004687, 'UA', 'Zaporizhia', 1, 'zaporizhia', 47.82289000, 35.19031000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1004668, 'UA', 'Zhytomyr Oblast', 1, 'zhytomyr-oblast');

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 
(1109320, 1004668, 'UA', 'Andrushivka', 1, 'andrushivka', 50.02288000, 29.02023000),
(1109321, 1004668, 'UA', 'Andrushivs’kyy Rayon', 1, 'andrushivs-kyy-rayon', 50.01709000, 29.03215000),
(1109350, 1004668, 'UA', 'Baranivka', 1, 'baranivka', 50.29691000, 27.66220000),
(1109370, 1004668, 'UA', 'Berdychiv', 1, 'berdychiv', 49.89928000, 28.60235000),
(1109371, 1004668, 'UA', 'Berdychivskyy Rayon', 1, 'berdychivskyy-rayon', 49.91667000, 28.58333000),
(1109392, 1004668, 'UA', 'Bila Krynytsya', 1, 'bila-krynytsya', 50.63982000, 29.47041000),
(1109451, 1004668, 'UA', 'Brusyliv', 1, 'brusyliv', 50.28449000, 29.52626000),
(1109452, 1004668, 'UA', 'Brusylivs’kyy Rayon', 1, 'brusylivs-kyy-rayon', 50.25638000, 29.48742000),
(1109465, 1004668, 'UA', 'Bykivka', 1, 'bykivka', 50.29285000, 27.98314000),
(1109479, 1004668, 'UA', 'Cherniakhiv', 1, 'cherniakhiv', 50.45652000, 28.67018000),
(1109495, 1004668, 'UA', 'Chernyakhivskyy Rayon', 1, 'chernyakhivskyy-rayon', 50.41667000, 28.66667000),
(1109499, 1004668, 'UA', 'Chervone', 1, 'chervone', 49.94975000, 28.86874000),
(1109509, 1004668, 'UA', 'Chopovychi', 1, 'chopovychi', 50.83325000, 28.95334000),
(1109514, 1004668, 'UA', 'Chornorudka', 1, 'chornorudka', 49.84640000, 29.06062000),
(1109520, 1004668, 'UA', 'Chudniv', 1, 'chudniv', 50.05204000, 28.11745000),
(1109521, 1004668, 'UA', 'Chudniv Raion', 1, 'chudniv-raion', 50.00000000, 28.16667000),
(1109536, 1004668, 'UA', 'Denyshi', 1, 'denyshi', 50.21415000, 28.40395000),
(1109572, 1004668, 'UA', 'Dovbysh', 1, 'dovbysh', 50.37332000, 27.98742000),
(1109638, 1004668, 'UA', 'Holovyne', 1, 'holovyne', 50.47118000, 28.82530000),
(1109647, 1004668, 'UA', 'Horodnytsya', 1, 'horodnytsya', 50.80697000, 27.31676000),
(1109649, 1004668, 'UA', 'Horodok', 1, 'horodok', 50.59483000, 29.46070000),
(1109658, 1004668, 'UA', 'Hryshkivtsi', 1, 'hryshkivtsi', 49.93529000, 28.60383000),
(1109737, 1004668, 'UA', 'Khoroshiv Raion', 1, 'khoroshiv-raion', 50.66667000, 28.50000000),
(1109798, 1004668, 'UA', 'Kornyn', 1, 'kornyn', 50.09530000, 29.53581000),
(1109801, 1004668, 'UA', 'Korosten’', 1, 'korosten', 50.95937000, 28.63855000),
(1109802, 1004668, 'UA', 'Korostyshiv', 1, 'korostyshiv', 50.31723000, 29.05630000),
(1109803, 1004668, 'UA', 'Korostyshiv Raion', 1, 'korostyshiv-raion', 50.33333000, 29.08333000),
(1109923, 1004668, 'UA', 'Liubar', 1, 'liubar', 49.92045000, 27.75918000),
(1109941, 1004668, 'UA', 'Luhyny', 1, 'luhyny', 51.08203000, 28.40057000),
(1109942, 1004668, 'UA', 'Luhyny Raion', 1, 'luhyny-raion', 51.08333000, 28.33333000),
(1109988, 1004668, 'UA', 'Malyn', 1, 'malyn', 50.77233000, 29.23833000),
(1109989, 1004668, 'UA', 'Malyn Raion', 1, 'malyn-raion', 50.83084000, 29.19926000),
(1110081, 1004668, 'UA', 'Narodychi', 1, 'narodychi', 51.20286000, 29.08228000),
(1110082, 1004668, 'UA', 'Narodychi Raion', 1, 'narodychi-raion', 51.25000000, 29.08333000),
(1110103, 1004668, 'UA', 'Nova Borova', 1, 'nova-borova', 50.69296000, 28.63446000),
(1110115, 1004668, 'UA', 'Novi Bilokorovychi', 1, 'novi-bilokorovychi', 51.11548000, 28.05463000),
(1110128, 1004668, 'UA', 'Novohrad-Volynskyi', 1, 'novohrad-volynskyi', 50.59412000, 27.61650000),
(1110194, 1004668, 'UA', 'Olevs’k', 1, 'olevs-k', 51.22482000, 27.65228000),
(1110214, 1004668, 'UA', 'Ovruch', 1, 'ovruch', 51.32460000, 28.80351000),
(1110215, 1004668, 'UA', 'Ovruch Raion', 1, 'ovruch-raion', 51.33333000, 28.83333000),
(1110217, 1004668, 'UA', 'Ozerne', 1, 'ozerne', 50.17816000, 28.73384000),
(1110246, 1004668, 'UA', 'Pershotravneve', 1, 'pershotravneve', 51.39287000, 28.86837000),
(1110296, 1004668, 'UA', 'Polyanka', 1, 'polyanka', 50.25836000, 27.68809000),
(1110301, 1004668, 'UA', 'Popilnia', 1, 'popilnia', 49.95320000, 29.45265000),
(1110302, 1004668, 'UA', 'Popilnia Raion', 1, 'popilnia-raion', 49.91667000, 29.50000000),
(1110328, 1004668, 'UA', 'Pulyny Raion', 1, 'pulyny-raion', 50.50000000, 28.25000000),
(1110337, 1004668, 'UA', 'Radomyshl', 1, 'radomyshl', 50.49613000, 29.22911000),
(1110338, 1004668, 'UA', 'Radomyshl Raion', 1, 'radomyshl-raion', 50.50000000, 29.25000000),
(1110366, 1004668, 'UA', 'Romaniv', 1, 'romaniv', 50.14802000, 27.93124000),
(1110394, 1004668, 'UA', 'Ruzhyn', 1, 'ruzhyn', 49.72280000, 29.20455000),
(1110544, 1004668, 'UA', 'Stavyshche', 1, 'stavyshche', 50.40051000, 29.52796000),
(1110615, 1004668, 'UA', 'Topory', 1, 'topory', 49.65186000, 29.31741000),
(1110795, 1004668, 'UA', 'Yemil’chyne', 1, 'yemil-chyne', 50.87349000, 27.80604000),
(1110853, 1004668, 'UA', 'Zhytomyr', 1, 'zhytomyr', 50.26487000, 28.67669000),
(1110854, 1004668, 'UA', 'Zhytomyr Raion', 1, 'zhytomyr-raion', 50.25000000, 28.58333000);

