REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug, s_phone_code, s_name_native, s_currency) VALUES 
('HR', 'Croatia (Hrvatska)', 'croatia-hrvatska', '385', 'Hrvatska', 'HRK');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000734, 'HR', 'Bjelovar-Bilogora County', 1, 'bjelovar-bilogora-county');

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 
(1054404, 1000734, 'HR', 'Bjelovar', 1, 'bjelovar', 45.89861000, 16.84889000),
(1054418, 1000734, 'HR', 'Brezovac', 1, 'brezovac', 45.86750000, 16.84083000),
(1055017, 1000734, 'HR', 'Čazma', 1, 'cazma', 45.74818000, 16.61390000),
(1054449, 1000734, 'HR', 'Daruvar', 1, 'daruvar', 45.59056000, 17.22500000),
(1054453, 1000734, 'HR', 'Dežanovac', 1, 'dezanovac', 45.57056000, 17.08667000),
(1055025, 1000734, 'HR', 'Đulovac', 1, 'dulovac', 45.66588000, 17.42981000),
(1054489, 1000734, 'HR', 'Garešnica', 1, 'garesnica', 45.57444000, 16.94139000),
(1054505, 1000734, 'HR', 'Grad Bjelovar', 1, 'grad-bjelovar', 45.90172000, 16.84522000),
(1054571, 1000734, 'HR', 'Grad Čazma', 1, 'grad-cazma', 45.75000000, 16.61667000),
(1054508, 1000734, 'HR', 'Grad Daruvar', 1, 'grad-daruvar', 45.60000000, 17.23333000),
(1054515, 1000734, 'HR', 'Grad Garešnica', 1, 'grad-garesnica', 45.56667000, 16.93333000),
(1054517, 1000734, 'HR', 'Grad Grubišno Polje', 1, 'grad-grubisno-polje', 45.70000000, 17.16667000),
(1054588, 1000734, 'HR', 'Grubišno Polje', 1, 'grubisno-polje', 45.70214000, 17.17268000),
(1054589, 1000734, 'HR', 'Gudovac', 1, 'gudovac', 45.88028000, 16.78083000),
(1054593, 1000734, 'HR', 'Hercegovac', 1, 'hercegovac', 45.65861000, 17.01361000),
(1054607, 1000734, 'HR', 'Ivanska', 1, 'ivanska', 45.77889000, 16.81194000),
(1054630, 1000734, 'HR', 'Kapela', 1, 'kapela', 45.98543000, 16.85174000),
(1054658, 1000734, 'HR', 'Končanica', 1, 'koncanica', 45.63611000, 17.16639000),
(1054831, 1000734, 'HR', 'Predavac', 1, 'predavac', 45.93583000, 16.78333000),
(1054869, 1000734, 'HR', 'Rovišće', 1, 'rovisce', 45.94472000, 16.73500000),
(1055028, 1000734, 'HR', 'Šandrovac', 1, 'sandrovac', 45.90556000, 17.02111000),
(1054886, 1000734, 'HR', 'Severin', 1, 'severin', 45.84152000, 16.96950000),
(1054891, 1000734, 'HR', 'Sirač', 1, 'sirac', 45.52333000, 17.25500000),
(1054960, 1000734, 'HR', 'Velika Pisanica', 1, 'velika-pisanica', 45.80160000, 17.06551000),
(1054962, 1000734, 'HR', 'Veliki Grđevac', 1, 'veliki-grdevac', 45.75028000, 17.04750000),
(1055038, 1000734, 'HR', 'Ždralovi', 1, 'zdralovi', 45.87639000, 16.87500000),
(1055013, 1000734, 'HR', 'Zrinski Topolovac', 1, 'zrinski-topolovac', 46.02120000, 16.75509000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000737, 'HR', 'Brod-Posavina County', 1, 'brod-posavina-county');

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 
(1054387, 1000737, 'HR', 'Batrina', 1, 'batrina', 45.18944000, 17.66639000),
(1054425, 1000737, 'HR', 'Brodski Varoš', 1, 'brodski-varos', 45.18111000, 17.97861000),
(1054434, 1000737, 'HR', 'Bukovlje', 1, 'bukovlje', 45.18528000, 18.07000000),
(1054441, 1000737, 'HR', 'Cernik', 1, 'cernik', 45.28861000, 17.38194000),
(1054450, 1000737, 'HR', 'Davor', 1, 'davor', 45.11528000, 17.51639000),
(1054460, 1000737, 'HR', 'Donji Andrijevci', 1, 'donji-andrijevci', 45.18833000, 18.29972000),
(1054490, 1000737, 'HR', 'Garčin', 1, 'garcin', 45.18278000, 18.18306000),
(1054498, 1000737, 'HR', 'Gornji Bogićevci', 1, 'gornji-bogicevci', 45.25572000, 17.23454000),
(1054534, 1000737, 'HR', 'Grad Nova Gradiška', 1, 'grad-nova-gradiska', 45.26667000, 17.40000000),
(1054551, 1000737, 'HR', 'Grad Slavonski Brod', 1, 'grad-slavonski-brod', 45.16267000, 18.03062000),
(1054590, 1000737, 'HR', 'Gundinci', 1, 'gundinci', 45.15833000, 18.49139000),
(1054661, 1000737, 'HR', 'Korenica', 1, 'korenica', 45.22472000, 18.16556000),
(1054672, 1000737, 'HR', 'Kruševica', 1, 'krusevica', 45.07750000, 18.48278000),
(1054708, 1000737, 'HR', 'Lužani', 1, 'luzani', 45.16806000, 17.70694000),
(1054757, 1000737, 'HR', 'Nova Gradiška', 1, 'nova-gradiska', 45.25500000, 17.38306000),
(1054774, 1000737, 'HR', 'Okučani', 1, 'okucani', 45.26034000, 17.19925000),
(1054778, 1000737, 'HR', 'Oprisavci', 1, 'oprisavci', 45.15111000, 18.22972000),
(1054790, 1000737, 'HR', 'Oriovac', 1, 'oriovac', 45.16611000, 17.76000000),
(1054819, 1000737, 'HR', 'Podvinje', 1, 'podvinje', 45.19028000, 18.02694000),
(1054862, 1000737, 'HR', 'Rešetari', 1, 'resetari', 45.26232000, 17.42346000),
(1054874, 1000737, 'HR', 'Ruščica', 1, 'ruscica', 45.14667000, 18.07944000),
(1054887, 1000737, 'HR', 'Sibinj', 1, 'sibinj', 45.19167000, 17.90806000),
(1054889, 1000737, 'HR', 'Sikirevci', 1, 'sikirevci', 45.10889000, 18.46444000),
(1054897, 1000737, 'HR', 'Slavonski Brod', 1, 'slavonski-brod', 45.16028000, 18.01556000),
(1054899, 1000737, 'HR', 'Slobodnica', 1, 'slobodnica', 45.16222000, 17.93278000),
(1054910, 1000737, 'HR', 'Stari Perkovci', 1, 'stari-perkovci', 45.21750000, 18.34861000),
(1054957, 1000737, 'HR', 'Velika Kopanica', 1, 'velika-kopanica', 45.15611000, 18.39306000),
(1054995, 1000737, 'HR', 'Vrpolje', 1, 'vrpolje', 45.21056000, 18.40556000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000728, 'HR', 'Dubrovnik-Neretva County', 1, 'dubrovnik-neretva-county');

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 
(1054437, 1000728, 'HR', 'Cavtat', 1, 'cavtat', 42.58111000, 18.21806000),
(1055022, 1000728, 'HR', 'Čibača', 1, 'cibaca', 42.62889000, 18.17111000),
(1054471, 1000728, 'HR', 'Dubrovačko primorje', 1, 'dubrovacko-primorje', 42.78988000, 17.86240000),
(1054513, 1000728, 'HR', 'Grad Dubrovnik', 1, 'grad-dubrovnik', 42.64861000, 18.09397000),
(1054525, 1000728, 'HR', 'Grad Korčula', 1, 'grad-korcula', 42.95693000, 17.13181000),
(1054544, 1000728, 'HR', 'Grad Ploče', 1, 'grad-ploce', 43.06667000, 17.43333000),
(1054653, 1000728, 'HR', 'Komin', 1, 'komin', 43.04083000, 17.53694000),
(1054656, 1000728, 'HR', 'Konavle', 1, 'konavle', 42.54010000, 18.33944000),
(1054662, 1000728, 'HR', 'Korčula', 1, 'korcula', 42.96038000, 17.13525000),
(1054684, 1000728, 'HR', 'Lastovo', 1, 'lastovo', 42.76757000, 16.89708000),
(1054704, 1000728, 'HR', 'Lumbarda', 1, 'lumbarda', 42.92278000, 17.16722000),
(1054728, 1000728, 'HR', 'Metković', 1, 'metkovic', 43.05417000, 17.64833000),
(1054736, 1000728, 'HR', 'Mljet', 1, 'mljet', 42.74439000, 17.53645000),
(1054737, 1000728, 'HR', 'Mokošica', 1, 'mokosica', 42.67556000, 18.09028000),
(1054785, 1000728, 'HR', 'Općina Lastovo', 1, 'opcina-lastovo', 42.75000000, 16.90000000),
(1054780, 1000728, 'HR', 'Opuzen', 1, 'opuzen', 43.01528000, 17.56556000),
(1054787, 1000728, 'HR', 'Orebić', 1, 'orebic', 42.98556000, 17.17472000),
(1054813, 1000728, 'HR', 'Podgora', 1, 'podgora', 42.84861000, 17.83639000),
(1054821, 1000728, 'HR', 'Pojezerje', 1, 'pojezerje', 43.15741000, 17.45152000),
(1054898, 1000728, 'HR', 'Slivno', 1, 'slivno', 42.95864000, 17.54431000),
(1054900, 1000728, 'HR', 'Smokvica', 1, 'smokvica', 42.93056000, 16.89639000),
(1054914, 1000728, 'HR', 'Ston', 1, 'ston', 42.83861000, 17.69639000),
(1054954, 1000728, 'HR', 'Vela Luka', 1, 'vela-luka', 42.96333000, 16.72250000),
(1055007, 1000728, 'HR', 'Zažablje', 1, 'zazablje', 43.01113000, 17.65683000),
(1055041, 1000728, 'HR', 'Žrnovo', 1, 'zrnovo', 42.95111000, 17.11417000),
(1055042, 1000728, 'HR', 'Župa dubrovačka', 1, 'zupa-dubrovacka', 42.62683000, 18.19475000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000743, 'HR', 'Istria County', 1, 'istria-county');

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 
(1054384, 1000743, 'HR', 'Bale', 1, 'bale', 45.04056000, 13.78361000),
(1054385, 1000743, 'HR', 'Bale-Valle', 1, 'bale-valle', 45.04089000, 13.78565000),
(1054426, 1000743, 'HR', 'Brtonigla', 1, 'brtonigla', 45.38139000, 13.62944000),
(1054427, 1000743, 'HR', 'Brtonigla-Verteneglio', 1, 'brtonigla-verteneglio', 45.37918000, 13.62554000),
(1054432, 1000743, 'HR', 'Buje', 1, 'buje', 45.41000000, 13.66194000),
(1054433, 1000743, 'HR', 'Buje-Buie', 1, 'buje-buie', 45.40790000, 13.65914000),
(1054436, 1000743, 'HR', 'Buzet', 1, 'buzet', 45.40944000, 13.96667000),
(1054479, 1000743, 'HR', 'Fažana', 1, 'fazana', 44.92750000, 13.80361000),
(1054480, 1000743, 'HR', 'Fažana-Fasana', 1, 'fazana-fasana', 44.92822000, 13.80548000),
(1054483, 1000743, 'HR', 'Funtana', 1, 'funtana', 45.17472000, 13.60500000),
(1054484, 1000743, 'HR', 'Funtana-Fontane', 1, 'funtana-fontane', 45.17483000, 13.60627000),
(1054487, 1000743, 'HR', 'Galižana', 1, 'galizana', 44.93167000, 13.86861000),
(1054506, 1000743, 'HR', 'Grad Buzet', 1, 'grad-buzet', 45.41667000, 13.96667000),
(1054530, 1000743, 'HR', 'Grad Labin', 1, 'grad-labin', 45.08333000, 14.13333000),
(1054542, 1000743, 'HR', 'Grad Pazin', 1, 'grad-pazin', 45.23333000, 13.93333000),
(1054585, 1000743, 'HR', 'Grožnjan', 1, 'groznjan', 45.37889000, 13.72389000),
(1054586, 1000743, 'HR', 'Grožnjan-Grisignana', 1, 'groznjan-grisignana', 45.37728000, 13.72145000),
(1054629, 1000743, 'HR', 'Kanfanar', 1, 'kanfanar', 45.12194000, 13.83917000),
(1054634, 1000743, 'HR', 'Karojba', 1, 'karojba', 45.30083000, 13.82306000),
(1054644, 1000743, 'HR', 'Kaštelir-Labinci', 1, 'kastelir-labinci', 45.30277000, 13.68841000),
(1054681, 1000743, 'HR', 'Labin', 1, 'labin', 45.09500000, 14.11972000),
(1054691, 1000743, 'HR', 'Ližnjan', 1, 'liznjan', 44.82833000, 13.95694000),
(1054692, 1000743, 'HR', 'Ližnjan-Lisignano', 1, 'liznjan-lisignano', 44.82765000, 13.96028000),
(1054706, 1000743, 'HR', 'Lupoglav', 1, 'lupoglav', 45.35204000, 14.10846000),
(1054722, 1000743, 'HR', 'Marčana', 1, 'marcana', 44.95528000, 13.95389000),
(1054727, 1000743, 'HR', 'Medulin', 1, 'medulin', 44.82250000, 13.93500000),
(1054739, 1000743, 'HR', 'Motovun', 1, 'motovun', 45.33667000, 13.82861000),
(1054740, 1000743, 'HR', 'Motovun-Montona', 1, 'motovun-montona', 45.33633000, 13.82977000),
(1054761, 1000743, 'HR', 'Novigrad', 1, 'novigrad', 45.31500000, 13.55806000),
(1054763, 1000743, 'HR', 'Novigrad-Cittanova', 1, 'novigrad-cittanova', 45.31669000, 13.56155000),
(1054784, 1000743, 'HR', 'Općina Lanišće', 1, 'opcina-lanisce', 45.43520000, 14.08196000),
(1054779, 1000743, 'HR', 'Oprtalj-Portole', 1, 'oprtalj-portole', 45.38226000, 13.82406000),
(1054800, 1000743, 'HR', 'Pazin', 1, 'pazin', 45.24028000, 13.93667000),
(1054826, 1000743, 'HR', 'Poreč', 1, 'porec', 45.22567000, 13.59511000),
(1054827, 1000743, 'HR', 'Poreč-Parenzo', 1, 'porec-parenzo', 45.22717000, 13.59653000),
(1054844, 1000743, 'HR', 'Pula', 1, 'pula', 44.86833000, 13.84806000),
(1054845, 1000743, 'HR', 'Pula-Pola', 1, 'pula-pola', 44.86711000, 13.84882000),
(1054850, 1000743, 'HR', 'Rabac', 1, 'rabac', 45.07944000, 14.15750000),
(1054855, 1000743, 'HR', 'Raša', 1, 'rasa', 45.08028000, 14.07889000),
(1054867, 1000743, 'HR', 'Rovinj', 1, 'rovinj', 45.08000000, 13.64000000),
(1054868, 1000743, 'HR', 'Rovinj-Rovigno', 1, 'rovinj-rovigno', 45.08190000, 13.63970000),
(1054925, 1000743, 'HR', 'Sveta Nedelja', 1, 'sveta-nedelja', 45.14932000, 14.09889000),
(1054931, 1000743, 'HR', 'Sveti Lovreč', 1, 'sveti-lovrec', 45.17770000, 13.74317000),
(1054933, 1000743, 'HR', 'Tar', 1, 'tar', 45.30083000, 13.62528000),
(1054934, 1000743, 'HR', 'Tar-Vabriga-Torre Abrega', 1, 'tar-vabriga-torre-abrega', 45.29946000, 13.62489000),
(1054949, 1000743, 'HR', 'Umag', 1, 'umag', 45.43139000, 13.52389000),
(1054950, 1000743, 'HR', 'Umag-Umago', 1, 'umag-umago', 45.43462000, 13.52589000),
(1054951, 1000743, 'HR', 'Valbandon', 1, 'valbandon', 44.91879000, 13.81344000),
(1054967, 1000743, 'HR', 'Vinež', 1, 'vinez', 45.09806000, 14.10694000),
(1054977, 1000743, 'HR', 'Višnjan-Visignano', 1, 'visnjan-visignano', 45.27614000, 13.72128000),
(1054979, 1000743, 'HR', 'Vižinada-Visinada', 1, 'vizinada-visinada', 45.33126000, 13.75943000),
(1054982, 1000743, 'HR', 'Vodnjan', 1, 'vodnjan', 44.95944000, 13.85167000),
(1054983, 1000743, 'HR', 'Vodnjan-Dignano', 1, 'vodnjan-dignano', 44.96187000, 13.85041000),
(1054996, 1000743, 'HR', 'Vrsar', 1, 'vrsar', 45.14917000, 13.60528000),
(1054997, 1000743, 'HR', 'Vrsar-Orsera', 1, 'vrsar-orsera', 45.15074000, 13.60558000),
(1055039, 1000743, 'HR', 'Žminj', 1, 'zminj', 45.14278000, 13.90889000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000742, 'HR', 'Koprivnica-Križevci County', 1, 'koprivnica-krizevci-county');

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 
(1054469, 1000742, 'HR', 'Drnje', 1, 'drnje', 46.20694000, 16.91694000),
(1055024, 1000742, 'HR', 'Đelekovec', 1, 'delekovec', 46.24989000, 16.87011000),
(1055027, 1000742, 'HR', 'Đurđevac', 1, 'durdevac', 46.03972000, 17.07168000),
(1054481, 1000742, 'HR', 'Ferdinandovac', 1, 'ferdinandovac', 46.05000000, 17.20000000),
(1054492, 1000742, 'HR', 'Gola', 1, 'gola', 46.19583000, 17.05806000),
(1054496, 1000742, 'HR', 'Gornja Rijeka', 1, 'gornja-rijeka', 46.10977000, 16.39079000),
(1054524, 1000742, 'HR', 'Grad Koprivnica', 1, 'grad-koprivnica', 46.16667000, 16.83333000),
(1054527, 1000742, 'HR', 'Grad Križevci', 1, 'grad-krizevci', 46.03333000, 16.56667000),
(1054594, 1000742, 'HR', 'Hlebine', 1, 'hlebine', 46.15694000, 16.96278000),
(1054626, 1000742, 'HR', 'Kalinovac', 1, 'kalinovac', 46.02944000, 17.11556000),
(1054659, 1000742, 'HR', 'Koprivnica', 1, 'koprivnica', 46.16278000, 16.82750000),
(1054660, 1000742, 'HR', 'Koprivnički Ivanec', 1, 'koprivnicki-ivanec', 46.19907000, 16.81629000),
(1054670, 1000742, 'HR', 'Križevci', 1, 'krizevci', 46.02194000, 16.54250000),
(1054685, 1000742, 'HR', 'Legrad', 1, 'legrad', 46.29750000, 16.85667000),
(1054738, 1000742, 'HR', 'Molve', 1, 'molve', 46.10917000, 17.03167000),
(1054765, 1000742, 'HR', 'Novo Virje', 1, 'novo-virje', 46.09834000, 17.15215000),
(1054803, 1000742, 'HR', 'Peteranec', 1, 'peteranec', 46.19222000, 16.89167000),
(1054854, 1000742, 'HR', 'Rasinja', 1, 'rasinja', 46.18389000, 16.70667000),
(1054857, 1000742, 'HR', 'Reka', 1, 'reka', 46.13028000, 16.76694000),
(1054888, 1000742, 'HR', 'Sigetec', 1, 'sigetec', 46.18833000, 16.93583000),
(1054972, 1000742, 'HR', 'Virje', 1, 'virje', 46.06722000, 16.99000000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000729, 'HR', 'Krapina-Zagorje County', 1, 'krapina-zagorje-county');

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 
(1054390, 1000729, 'HR', 'Bedekovčina', 1, 'bedekovcina', 46.04111000, 15.99639000),
(1054430, 1000729, 'HR', 'Budinščina', 1, 'budinscina', 46.12785000, 16.20415000),
(1055026, 1000729, 'HR', 'Đurmanec', 1, 'durmanec', 46.19708000, 15.83786000),
(1054510, 1000729, 'HR', 'Grad Donja Stubica', 1, 'grad-donja-stubica', 45.97955000, 15.97069000),
(1054523, 1000729, 'HR', 'Grad Klanjec', 1, 'grad-klanjec', 46.04977000, 15.74615000),
(1054526, 1000729, 'HR', 'Grad Krapina', 1, 'grad-krapina', 46.15968000, 15.87258000),
(1054566, 1000729, 'HR', 'Grad Zabok', 1, 'grad-zabok', 46.02808000, 15.90855000),
(1054568, 1000729, 'HR', 'Grad Zlatar', 1, 'grad-zlatar', 46.09198000, 16.07695000),
(1054622, 1000729, 'HR', 'Jesenje', 1, 'jesenje', 46.20724000, 15.88194000),
(1054648, 1000729, 'HR', 'Klanjec', 1, 'klanjec', 46.04982000, 15.74418000),
(1054657, 1000729, 'HR', 'Konjščina', 1, 'konjscina', 46.05435000, 16.17763000),
(1054667, 1000729, 'HR', 'Krapina', 1, 'krapina', 46.16083000, 15.87889000),
(1054674, 1000729, 'HR', 'Kumrovec', 1, 'kumrovec', 46.07750000, 15.67556000),
(1054725, 1000729, 'HR', 'Mače', 1, 'mace', 46.09472000, 16.03528000),
(1054714, 1000729, 'HR', 'Marija Bistrica', 1, 'marija-bistrica', 46.00611000, 16.11111000),
(1054731, 1000729, 'HR', 'Mihovljan', 1, 'mihovljan', 46.13306000, 15.97222000),
(1054791, 1000729, 'HR', 'Oroslavje', 1, 'oroslavje', 45.99672000, 15.91507000),
(1054832, 1000729, 'HR', 'Pregrada', 1, 'pregrada', 46.16417000, 15.75083000),
(1054851, 1000729, 'HR', 'Radoboj', 1, 'radoboj', 46.16639000, 15.92361000),
(1054918, 1000729, 'HR', 'Stubičke Toplice', 1, 'stubicke-toplice', 45.97585000, 15.93238000),
(1054930, 1000729, 'HR', 'Sveti Križ Začretje', 1, 'sveti-kriz-zacretje', 46.08224000, 15.90704000),
(1055001, 1000729, 'HR', 'Zabok', 1, 'zabok', 46.02944000, 15.91500000),
(1055010, 1000729, 'HR', 'Zlatar', 1, 'zlatar', 46.09417000, 16.07083000),
(1055011, 1000729, 'HR', 'Zlatar Bistrica', 1, 'zlatar-bistrica', 46.04788000, 16.08527000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000731, 'HR', 'Lika-Senj County', 1, 'lika-senj-county');

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 
(1054422, 1000731, 'HR', 'Brinje', 1, 'brinje', 45.00250000, 15.13389000),
(1054501, 1000731, 'HR', 'Gospić', 1, 'gospic', 44.54611000, 15.37472000),
(1054633, 1000731, 'HR', 'Karlobag', 1, 'karlobag', 44.52750000, 15.07389000),
(1054690, 1000731, 'HR', 'Lički Osik', 1, 'licki-osik', 44.60389000, 15.42472000),
(1054758, 1000731, 'HR', 'Novalja', 1, 'novalja', 44.55778000, 14.88667000),
(1054796, 1000731, 'HR', 'Otočac', 1, 'otocac', 44.86944000, 15.23750000),
(1054802, 1000731, 'HR', 'Perušić', 1, 'perusic', 44.64944000, 15.38333000),
(1054812, 1000731, 'HR', 'Plitvička Jezera', 1, 'plitvicka-jezera', 44.88053000, 15.62123000),
(1054824, 1000731, 'HR', 'Popovača', 1, 'popovaca', 44.63917000, 15.17917000),
(1054884, 1000731, 'HR', 'Senj', 1, 'senj', 44.98944000, 14.90583000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000726, 'HR', 'Međimurje County', 1, 'medimurje-county');

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 
(1054392, 1000726, 'HR', 'Belica', 1, 'belica', 46.40417000, 16.51833000),
(1055015, 1000726, 'HR', 'Čakovec', 1, 'cakovec', 46.38444000, 16.43389000),
(1054451, 1000726, 'HR', 'Dekanovec', 1, 'dekanovec', 46.44861000, 16.58472000),
(1054455, 1000726, 'HR', 'Domašinec', 1, 'domasinec', 46.43250000, 16.60000000),
(1054493, 1000726, 'HR', 'Goričan', 1, 'gorican', 46.38417000, 16.68083000),
(1054570, 1000726, 'HR', 'Grad Čakovec', 1, 'grad-cakovec', 46.38583000, 16.43333000),
(1054595, 1000726, 'HR', 'Hodošan', 1, 'hodosan', 46.39528000, 16.64389000),
(1054606, 1000726, 'HR', 'Ivanovec', 1, 'ivanovec', 46.36833000, 16.47667000),
(1054663, 1000726, 'HR', 'Kotoriba', 1, 'kotoriba', 46.35500000, 16.81806000),
(1054675, 1000726, 'HR', 'Kuršanec', 1, 'kursanec', 46.33028000, 16.40167000),
(1054697, 1000726, 'HR', 'Lopatinec', 1, 'lopatinec', 46.43333000, 16.38333000),
(1054726, 1000726, 'HR', 'Mačkovec', 1, 'mackovec', 46.42417000, 16.43361000),
(1054711, 1000726, 'HR', 'Mala Subotica', 1, 'mala-subotica', 46.37616000, 16.52893000),
(1054730, 1000726, 'HR', 'Mihovljan', 1, 'mihovljan', 46.40861000, 16.44806000),
(1054744, 1000726, 'HR', 'Mursko Središće', 1, 'mursko-sredisce', 46.50944000, 16.44111000),
(1054749, 1000726, 'HR', 'Nedelišće', 1, 'nedelisce', 46.37583000, 16.38750000),
(1054764, 1000726, 'HR', 'Novo Selo Rok', 1, 'novo-selo-rok', 46.42839000, 16.46215000),
(1054788, 1000726, 'HR', 'Orehovica', 1, 'orehovica', 46.33167000, 16.50694000),
(1054801, 1000726, 'HR', 'Peklenica', 1, 'peklenica', 46.49528000, 16.47611000),
(1054818, 1000726, 'HR', 'Podturen', 1, 'podturen', 46.46472000, 16.54306000),
(1054834, 1000726, 'HR', 'Prelog', 1, 'prelog', 46.33500000, 16.61556000),
(1054836, 1000726, 'HR', 'Pribislavec', 1, 'pribislavec', 46.39250000, 16.48250000),
(1055029, 1000726, 'HR', 'Šenkovec', 1, 'senkovec', 46.40889000, 16.42167000),
(1054915, 1000726, 'HR', 'Strahoninec', 1, 'strahoninec', 46.36889000, 16.41500000),
(1054929, 1000726, 'HR', 'Sveti Juraj na Bregu', 1, 'sveti-juraj-na-bregu', 46.42853000, 16.38525000),
(1054988, 1000726, 'HR', 'Vratišinec', 1, 'vratisinec', 46.47806000, 16.45778000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000740, 'HR', 'Osijek-Baranja County', 1, 'osijek-baranja-county');

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 
(1054381, 1000740, 'HR', 'Antunovac', 1, 'antunovac', 45.49083000, 18.67500000),
(1054391, 1000740, 'HR', 'Beli Manastir', 1, 'beli-manastir', 45.77000000, 18.60361000),
(1054393, 1000740, 'HR', 'Belišće', 1, 'belisce', 45.68028000, 18.40583000),
(1054398, 1000740, 'HR', 'Bijelo Brdo', 1, 'bijelo-brdo', 45.51722000, 18.87083000),
(1054399, 1000740, 'HR', 'Bilje', 1, 'bilje', 45.60694000, 18.74389000),
(1054402, 1000740, 'HR', 'Bistrinci', 1, 'bistrinci', 45.69167000, 18.39861000),
(1054403, 1000740, 'HR', 'Bizovac', 1, 'bizovac', 45.59278000, 18.45889000),
(1054421, 1000740, 'HR', 'Brijest', 1, 'brijest', 45.52056000, 18.67194000),
(1054431, 1000740, 'HR', 'Budrovci', 1, 'budrovci', 45.27111000, 18.44861000),
(1055020, 1000740, 'HR', 'Čeminac', 1, 'ceminac', 45.68639000, 18.66750000),
(1055021, 1000740, 'HR', 'Čepin', 1, 'cepin', 45.52361000, 18.56333000),
(1054447, 1000740, 'HR', 'Dalj', 1, 'dalj', 45.48438000, 18.98610000),
(1054448, 1000740, 'HR', 'Darda', 1, 'darda', 45.62806000, 18.69972000),
(1054461, 1000740, 'HR', 'Donji Miholjac', 1, 'donji-miholjac', 45.76083000, 18.16722000),
(1054464, 1000740, 'HR', 'Draž', 1, 'draz', 45.84222000, 18.78861000),
(1055023, 1000740, 'HR', 'Đakovo', 1, 'dakovo', 45.30833000, 18.41056000),
(1055014, 1000740, 'HR', 'Đurđenovac', 1, 'durdenovac', 45.54333000, 18.04583000),
(1054476, 1000740, 'HR', 'Erdut', 1, 'erdut', 45.52639000, 19.06028000),
(1054477, 1000740, 'HR', 'Ernestinovo', 1, 'ernestinovo', 45.45194000, 18.65917000),
(1054482, 1000740, 'HR', 'Feričanci', 1, 'fericanci', 45.52889000, 17.97583000),
(1054494, 1000740, 'HR', 'Gorjani', 1, 'gorjani', 45.39889000, 18.37222000),
(1054503, 1000740, 'HR', 'Grad Beli Manastir', 1, 'grad-beli-manastir', 45.77219000, 18.61084000),
(1054511, 1000740, 'HR', 'Grad Donji Miholjac', 1, 'grad-donji-miholjac', 45.75000000, 18.16667000),
(1054533, 1000740, 'HR', 'Grad Našice', 1, 'grad-nasice', 45.50000000, 18.10000000),
(1054540, 1000740, 'HR', 'Grad Osijek', 1, 'grad-osijek', 45.58333000, 18.66667000),
(1054556, 1000740, 'HR', 'Grad Valpovo', 1, 'grad-valpovo', 45.66667000, 18.41667000),
(1054610, 1000740, 'HR', 'Jagodnjak', 1, 'jagodnjak', 45.69917000, 18.57694000),
(1054619, 1000740, 'HR', 'Jelisavac', 1, 'jelisavac', 45.52889000, 18.15611000),
(1054624, 1000740, 'HR', 'Josipovac', 1, 'josipovac', 45.58278000, 18.58139000),
(1054632, 1000740, 'HR', 'Karanac', 1, 'karanac', 45.76056000, 18.68444000),
(1054651, 1000740, 'HR', 'Kneževi Vinogradi', 1, 'knezevi-vinogradi', 45.75028000, 18.73306000),
(1054664, 1000740, 'HR', 'Koška', 1, 'koska', 45.54528000, 18.28583000),
(1054680, 1000740, 'HR', 'Kuševac', 1, 'kusevac', 45.34778000, 18.42889000),
(1054682, 1000740, 'HR', 'Ladimirevci', 1, 'ladimirevci', 45.62556000, 18.44861000),
(1054683, 1000740, 'HR', 'Laslovo', 1, 'laslovo', 45.41500000, 18.69611000),
(1054709, 1000740, 'HR', 'Magadenovac', 1, 'magadenovac', 45.66159000, 18.18679000),
(1054715, 1000740, 'HR', 'Marijanci', 1, 'marijanci', 45.66645000, 18.29284000),
(1054717, 1000740, 'HR', 'Marjanci', 1, 'marjanci', 45.66694000, 18.29222000),
(1054718, 1000740, 'HR', 'Markovac Našički', 1, 'markovac-nasicki', 45.49389000, 18.12556000),
(1054720, 1000740, 'HR', 'Martin', 1, 'martin', 45.49222000, 18.06667000),
(1054748, 1000740, 'HR', 'Našice', 1, 'nasice', 45.48861000, 18.08778000),
(1054792, 1000740, 'HR', 'Osijek', 1, 'osijek', 45.55111000, 18.69389000),
(1054804, 1000740, 'HR', 'Petlovac', 1, 'petlovac', 45.75833000, 18.52806000),
(1054806, 1000740, 'HR', 'Petrijevci', 1, 'petrijevci', 45.61278000, 18.53528000),
(1054810, 1000740, 'HR', 'Piškorevci', 1, 'piskorevci', 45.25528000, 18.40417000),
(1054814, 1000740, 'HR', 'Podgorač', 1, 'podgorac', 45.45861000, 18.22278000),
(1054816, 1000740, 'HR', 'Podravska Moslavina', 1, 'podravska-moslavina', 45.78456000, 17.98410000),
(1054877, 1000740, 'HR', 'Sarvaš', 1, 'sarvas', 45.52722000, 18.83750000),
(1054878, 1000740, 'HR', 'Satnica Đakovačka', 1, 'satnica-dakovacka', 45.35367000, 18.37729000),
(1054883, 1000740, 'HR', 'Semeljci', 1, 'semeljci', 45.36056000, 18.54361000),
(1055031, 1000740, 'HR', 'Široko Polje', 1, 'siroko-polje', 45.40528000, 18.47250000),
(1055034, 1000740, 'HR', 'Šodolovci', 1, 'sodolovci', 45.40000000, 18.62028000),
(1054916, 1000740, 'HR', 'Strizivojna', 1, 'strizivojna', 45.22611000, 18.42389000),
(1054935, 1000740, 'HR', 'Tenja', 1, 'tenja', 45.49806000, 18.74722000),
(1054952, 1000740, 'HR', 'Valpovo', 1, 'valpovo', 45.66083000, 18.41861000),
(1054963, 1000740, 'HR', 'Velimirovac', 1, 'velimirovac', 45.52361000, 18.10944000),
(1054966, 1000740, 'HR', 'Viljevo', 1, 'viljevo', 45.75139000, 18.06306000),
(1054975, 1000740, 'HR', 'Viškovci', 1, 'viskovci', 45.34500000, 18.46222000),
(1054978, 1000740, 'HR', 'Višnjevac', 1, 'visnjevac', 45.56861000, 18.61389000),
(1054980, 1000740, 'HR', 'Vladislavci', 1, 'vladislavci', 45.45944000, 18.57417000),
(1054999, 1000740, 'HR', 'Vuka', 1, 'vuka', 45.43389000, 18.50500000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000724, 'HR', 'Požega-Slavonia County', 1, 'pozega-slavonia-county');

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 
(1054415, 1000724, 'HR', 'Brestovac', 1, 'brestovac', 45.33056000, 17.59694000),
(1054541, 1000724, 'HR', 'Grad Pakrac', 1, 'grad-pakrac', 45.43333000, 17.20000000),
(1054545, 1000724, 'HR', 'Grad Požega', 1, 'grad-pozega', 45.33333000, 17.66667000),
(1054612, 1000724, 'HR', 'Jakšić', 1, 'jaksic', 45.35765000, 17.76502000),
(1054631, 1000724, 'HR', 'Kaptol', 1, 'kaptol', 45.43472000, 17.72611000),
(1054677, 1000724, 'HR', 'Kutjevo', 1, 'kutjevo', 45.42611000, 17.88250000),
(1054688, 1000724, 'HR', 'Lipik', 1, 'lipik', 45.41139000, 17.15222000),
(1054799, 1000724, 'HR', 'Pakrac', 1, 'pakrac', 45.43639000, 17.18889000),
(1054811, 1000724, 'HR', 'Pleternica', 1, 'pleternica', 45.28861000, 17.80639000),
(1054830, 1000724, 'HR', 'Požega', 1, 'pozega', 45.34028000, 17.68528000),
(1054955, 1000724, 'HR', 'Velika', 1, 'velika', 45.45444000, 17.66139000),
(1054964, 1000724, 'HR', 'Vidovci', 1, 'vidovci', 45.33250000, 17.71472000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000735, 'HR', 'Primorje-Gorski Kotar County', 1, 'primorje-gorski-kotar-county');

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 
(1054383, 1000735, 'HR', 'Bakar', 1, 'bakar', 45.30861000, 14.53028000),
(1054386, 1000735, 'HR', 'Banjol', 1, 'banjol', 44.75000000, 14.78333000),
(1054388, 1000735, 'HR', 'Baška', 1, 'baska', 44.97028000, 14.75333000),
(1054420, 1000735, 'HR', 'Bribir', 1, 'bribir', 45.16111000, 14.76472000),
(1054435, 1000735, 'HR', 'Buzdohanj', 1, 'buzdohanj', 45.34528000, 14.48833000),
(1055016, 1000735, 'HR', 'Čavle', 1, 'cavle', 45.35194000, 14.48389000),
(1054442, 1000735, 'HR', 'Cernik', 1, 'cernik', 45.34361000, 14.50222000),
(1054444, 1000735, 'HR', 'Cres', 1, 'cres', 44.96111000, 14.40840000),
(1054445, 1000735, 'HR', 'Crikvenica', 1, 'crikvenica', 45.17722000, 14.69278000),
(1054452, 1000735, 'HR', 'Delnice', 1, 'delnice', 45.40083000, 14.79972000),
(1054465, 1000735, 'HR', 'Dražice', 1, 'drazice', 45.39083000, 14.47028000),
(1054466, 1000735, 'HR', 'Drenova', 1, 'drenova', 45.35000000, 14.43028000),
(1054485, 1000735, 'HR', 'Fužine', 1, 'fuzine', 45.30528000, 14.71556000),
(1054569, 1000735, 'HR', 'Grad Čabar', 1, 'grad-cabar', 45.58333000, 14.58333000),
(1054507, 1000735, 'HR', 'Grad Crikvenica', 1, 'grad-crikvenica', 45.16667000, 14.70000000),
(1054509, 1000735, 'HR', 'Grad Delnice', 1, 'grad-delnice', 45.39806000, 14.80111000),
(1054528, 1000735, 'HR', 'Grad Krk', 1, 'grad-krk', 45.02829000, 14.57233000),
(1054538, 1000735, 'HR', 'Grad Opatija', 1, 'grad-opatija', 45.33333000, 14.26667000),
(1054546, 1000735, 'HR', 'Grad Rijeka', 1, 'grad-rijeka', 45.32693000, 14.43758000),
(1054563, 1000735, 'HR', 'Grad Vrbovsko', 1, 'grad-vrbovsko', 45.37542000, 15.07856000),
(1054598, 1000735, 'HR', 'Hreljin', 1, 'hreljin', 45.28250000, 14.59917000),
(1054609, 1000735, 'HR', 'Jadranovo', 1, 'jadranovo', 45.23111000, 14.61833000),
(1054628, 1000735, 'HR', 'Kampor', 1, 'kampor', 44.77500000, 14.71861000),
(1054635, 1000735, 'HR', 'Kastav', 1, 'kastav', 45.37528000, 14.34861000),
(1054647, 1000735, 'HR', 'Klana', 1, 'klana', 45.44694000, 14.37694000),
(1054666, 1000735, 'HR', 'Kraljevica', 1, 'kraljevica', 45.27395000, 14.56830000),
(1054668, 1000735, 'HR', 'Krasica', 1, 'krasica', 45.30972000, 14.55556000),
(1054671, 1000735, 'HR', 'Krk', 1, 'krk', 45.02744000, 14.57542000),
(1054696, 1000735, 'HR', 'Lopar', 1, 'lopar', 44.83250000, 14.73028000),
(1054699, 1000735, 'HR', 'Lovran', 1, 'lovran', 45.29194000, 14.27417000),
(1054712, 1000735, 'HR', 'Mali Lošinj', 1, 'mali-losinj', 44.53056000, 14.46861000),
(1054713, 1000735, 'HR', 'Malinska-Dubašnica', 1, 'malinska-dubasnica', 45.12277000, 14.52873000),
(1054723, 1000735, 'HR', 'Marčelji', 1, 'marcelji', 45.39611000, 14.38944000),
(1054716, 1000735, 'HR', 'Marinići', 1, 'marinici', 45.36500000, 14.39389000),
(1054724, 1000735, 'HR', 'Matulji', 1, 'matulji', 45.36167000, 14.32500000),
(1054729, 1000735, 'HR', 'Mihotići', 1, 'mihotici', 45.36125000, 14.30553000),
(1054743, 1000735, 'HR', 'Mrkopalj', 1, 'mrkopalj', 45.31556000, 14.85528000),
(1054755, 1000735, 'HR', 'Njivice', 1, 'njivice', 45.15806000, 14.53861000),
(1054759, 1000735, 'HR', 'Novi Vinodolski', 1, 'novi-vinodolski', 45.12806000, 14.78889000),
(1054776, 1000735, 'HR', 'Omišalj', 1, 'omisalj', 45.21134000, 14.55495000),
(1054777, 1000735, 'HR', 'Opatija', 1, 'opatija', 45.33771000, 14.30515000),
(1054815, 1000735, 'HR', 'Podhum', 1, 'podhum', 45.38722000, 14.47944000),
(1054846, 1000735, 'HR', 'Punat', 1, 'punat', 45.01472000, 14.62889000),
(1054849, 1000735, 'HR', 'Rab', 1, 'rab', 44.75769000, 14.75906000),
(1054863, 1000735, 'HR', 'Rijeka', 1, 'rijeka', 45.32673000, 14.44241000),
(1054870, 1000735, 'HR', 'Rubeši', 1, 'rubesi', 45.36694000, 14.34806000),
(1054882, 1000735, 'HR', 'Selce', 1, 'selce', 45.15639000, 14.72111000),
(1054893, 1000735, 'HR', 'Skrad', 1, 'skrad', 45.42778000, 14.91111000),
(1055033, 1000735, 'HR', 'Škrljevo', 1, 'skrljevo', 45.32053000, 14.53268000),
(1054924, 1000735, 'HR', 'Supetarska Draga', 1, 'supetarska-draga', 44.79750000, 14.72472000),
(1054970, 1000735, 'HR', 'Vinodolska općina', 1, 'vinodolska-opcina', 45.22219000, 14.68941000),
(1054976, 1000735, 'HR', 'Viškovo', 1, 'viskovo', 45.37572000, 14.38400000),
(1054990, 1000735, 'HR', 'Vrbnik', 1, 'vrbnik', 45.07583000, 14.67250000),
(1054992, 1000735, 'HR', 'Vrbovsko', 1, 'vrbovsko', 45.36861000, 15.07833000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000730, 'HR', 'Šibenik-Knin County', 1, 'sibenik-knin-county');

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 
(1054424, 1000730, 'HR', 'Brodarica', 1, 'brodarica', 43.68000000, 15.91972000),
(1054468, 1000730, 'HR', 'Drniš', 1, 'drnis', 43.86250000, 16.15556000),
(1054512, 1000730, 'HR', 'Grad Drniš', 1, 'grad-drnis', 43.83333000, 16.16667000),
(1054572, 1000730, 'HR', 'Grad Šibenik', 1, 'grad-sibenik', 43.73576000, 15.89602000),
(1054646, 1000730, 'HR', 'Kistanje', 1, 'kistanje', 43.98278000, 15.96500000),
(1054652, 1000730, 'HR', 'Knin', 1, 'knin', 44.04063000, 16.19662000),
(1054745, 1000730, 'HR', 'Murter', 1, 'murter', 43.82043000, 15.58988000),
(1054746, 1000730, 'HR', 'Murter-Kornati', 1, 'murter-kornati', 43.80959000, 15.60024000),
(1054808, 1000730, 'HR', 'Pirovac', 1, 'pirovac', 43.81917000, 15.67278000),
(1054839, 1000730, 'HR', 'Primošten', 1, 'primosten', 43.58632000, 15.92302000),
(1054843, 1000730, 'HR', 'Promina', 1, 'promina', 43.95798000, 16.09737000),
(1054864, 1000730, 'HR', 'Rogoznica', 1, 'rogoznica', 43.52472000, 15.97000000),
(1054865, 1000730, 'HR', 'Rogoznica Općina', 1, 'rogoznica-opcina', 43.53620000, 15.97086000),
(1055030, 1000730, 'HR', 'Šibenik', 1, 'sibenik', 43.72722000, 15.90583000),
(1054894, 1000730, 'HR', 'Skradin', 1, 'skradin', 43.82028000, 15.92361000),
(1054936, 1000730, 'HR', 'Tisno', 1, 'tisno', 43.80417000, 15.64333000),
(1054940, 1000730, 'HR', 'Tribunj', 1, 'tribunj', 43.75547000, 15.74444000),
(1054981, 1000730, 'HR', 'Vodice', 1, 'vodice', 43.76083000, 15.78278000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000733, 'HR', 'Sisak-Moslavina County', 1, 'sisak-moslavina-county');

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 
(1054429, 1000733, 'HR', 'Budaševo', 1, 'budasevo', 45.47472000, 16.43667000),
(1054475, 1000733, 'HR', 'Dvor', 1, 'dvor', 45.07306000, 16.37083000),
(1054491, 1000733, 'HR', 'Glina', 1, 'glina', 45.33806000, 16.08806000),
(1054516, 1000733, 'HR', 'Grad Glina', 1, 'grad-glina', 45.33333000, 16.10000000),
(1054518, 1000733, 'HR', 'Grad Hrvatska Kostajnica', 1, 'grad-hrvatska-kostajnica', 45.25000000, 16.56667000),
(1054529, 1000733, 'HR', 'Grad Kutina', 1, 'grad-kutina', 45.50000000, 16.75000000),
(1054536, 1000733, 'HR', 'Grad Novska', 1, 'grad-novska', 45.33333000, 17.00000000),
(1054543, 1000733, 'HR', 'Grad Petrinja', 1, 'grad-petrinja', 45.43333000, 16.26667000),
(1054549, 1000733, 'HR', 'Grad Sisak', 1, 'grad-sisak', 45.50000000, 16.36667000),
(1054592, 1000733, 'HR', 'Gvozd', 1, 'gvozd', 45.35305000, 15.86563000),
(1054600, 1000733, 'HR', 'Hrvatska Kostajnica', 1, 'hrvatska-kostajnica', 45.23167000, 16.53917000),
(1054676, 1000733, 'HR', 'Kutina', 1, 'kutina', 45.47500000, 16.78194000),
(1054686, 1000733, 'HR', 'Lekenik', 1, 'lekenik', 45.58556000, 16.21139000),
(1054689, 1000733, 'HR', 'Lipovljani', 1, 'lipovljani', 45.39667000, 16.88972000),
(1054721, 1000733, 'HR', 'Martinska Ves', 1, 'martinska-ves', 45.58670000, 16.37465000),
(1054768, 1000733, 'HR', 'Novska', 1, 'novska', 45.34056000, 16.97694000),
(1054782, 1000733, 'HR', 'Općina Dvor', 1, 'opcina-dvor', 45.10000000, 16.30000000),
(1054783, 1000733, 'HR', 'Općina Gvozd', 1, 'opcina-gvozd', 45.33333000, 15.90000000),
(1054807, 1000733, 'HR', 'Petrinja', 1, 'petrinja', 45.43750000, 16.29000000),
(1054825, 1000733, 'HR', 'Popovača', 1, 'popovaca', 45.56972000, 16.62500000),
(1054859, 1000733, 'HR', 'Repušnica', 1, 'repusnica', 45.49278000, 16.73083000),
(1054892, 1000733, 'HR', 'Sisak', 1, 'sisak', 45.46611000, 16.37833000),
(1054922, 1000733, 'HR', 'Sunja', 1, 'sunja', 45.36850000, 16.56702000),
(1054984, 1000733, 'HR', 'Voloder', 1, 'voloder', 45.54806000, 16.67889000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000725, 'HR', 'Split-Dalmatia County', 1, 'split-dalmatia-county');

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 
(1054389, 1000725, 'HR', 'Baška Voda', 1, 'baska-voda', 43.35694000, 16.95028000),
(1054407, 1000725, 'HR', 'Bol', 1, 'bol', 43.26194000, 16.65500000),
(1054414, 1000725, 'HR', 'Brela', 1, 'brela', 43.36889000, 16.93417000),
(1054423, 1000725, 'HR', 'Brnaze', 1, 'brnaze', 43.68000000, 16.64972000),
(1054454, 1000725, 'HR', 'Dicmo', 1, 'dicmo', 43.63678000, 16.58978000),
(1054463, 1000725, 'HR', 'Donji Vinjani', 1, 'donji-vinjani', 43.44613000, 17.24064000),
(1054474, 1000725, 'HR', 'Duće', 1, 'duce', 43.44278000, 16.66833000),
(1054472, 1000725, 'HR', 'Dugi Rat Općina', 1, 'dugi-rat-opcina', 43.44923000, 16.64738000),
(1054473, 1000725, 'HR', 'Dugopolje', 1, 'dugopolje', 43.58056000, 16.60278000),
(1054486, 1000725, 'HR', 'Gala', 1, 'gala', 43.71500000, 16.72694000),
(1054502, 1000725, 'HR', 'Grabovci', 1, 'grabovci', 43.49278000, 17.20111000),
(1054519, 1000725, 'HR', 'Grad Hvar', 1, 'grad-hvar', 43.17263000, 16.44550000),
(1054520, 1000725, 'HR', 'Grad Imotski', 1, 'grad-imotski', 43.43333000, 17.16667000),
(1054532, 1000725, 'HR', 'Grad Makarska', 1, 'grad-makarska', 43.30000000, 17.03333000),
(1054537, 1000725, 'HR', 'Grad Omiš', 1, 'grad-omis', 43.46667000, 16.70000000),
(1054548, 1000725, 'HR', 'Grad Sinj', 1, 'grad-sinj', 43.72285000, 16.65819000),
(1054552, 1000725, 'HR', 'Grad Split', 1, 'grad-split', 43.50000000, 16.50000000),
(1054553, 1000725, 'HR', 'Grad Supetar', 1, 'grad-supetar', 43.38444000, 16.55528000),
(1054555, 1000725, 'HR', 'Grad Trogir', 1, 'grad-trogir', 43.52061000, 16.25144000),
(1054561, 1000725, 'HR', 'Grad Vis', 1, 'grad-vis', 43.05315000, 16.18698000),
(1054564, 1000725, 'HR', 'Grad Vrgorac', 1, 'grad-vrgorac', 43.20000000, 17.36667000),
(1054574, 1000725, 'HR', 'Gradac', 1, 'gradac', 43.10583000, 17.34167000),
(1054584, 1000725, 'HR', 'Greda', 1, 'greda', 43.61528000, 16.69361000),
(1054587, 1000725, 'HR', 'Grubine', 1, 'grubine', 43.42986000, 17.16292000),
(1054599, 1000725, 'HR', 'Hrvace', 1, 'hrvace', 43.76333000, 16.61500000),
(1054601, 1000725, 'HR', 'Hvar', 1, 'hvar', 43.17250000, 16.44278000),
(1054603, 1000725, 'HR', 'Imotski', 1, 'imotski', 43.44667000, 17.21667000),
(1054620, 1000725, 'HR', 'Jelsa', 1, 'jelsa', 43.16139000, 16.69306000),
(1054621, 1000725, 'HR', 'Jesenice', 1, 'jesenice', 43.46158000, 16.60197000),
(1054627, 1000725, 'HR', 'Kamen', 1, 'kamen', 43.51417000, 16.51472000),
(1054637, 1000725, 'HR', 'Kaštel Gomilica', 1, 'kastel-gomilica', 43.55000000, 16.40000000),
(1054638, 1000725, 'HR', 'Kaštel Kambelovac', 1, 'kastel-kambelovac', 43.55000000, 16.38333000),
(1054639, 1000725, 'HR', 'Kaštel Lukšić', 1, 'kastel-luksic', 43.55528000, 16.36750000),
(1054640, 1000725, 'HR', 'Kaštel Novi', 1, 'kastel-novi', 43.55000000, 16.33333000),
(1054642, 1000725, 'HR', 'Kaštel Štafilić', 1, 'kastel-stafilic', 43.55000000, 16.33333000),
(1054641, 1000725, 'HR', 'Kaštel Stari', 1, 'kastel-stari', 43.55000000, 16.35000000),
(1054643, 1000725, 'HR', 'Kaštela', 1, 'kastela', 43.53865000, 16.30740000),
(1054650, 1000725, 'HR', 'Klis', 1, 'klis', 43.55944000, 16.51944000),
(1054654, 1000725, 'HR', 'Komiža', 1, 'komiza', 43.04306000, 16.09306000),
(1054665, 1000725, 'HR', 'Košute', 1, 'kosute', 43.63083000, 16.69500000),
(1054694, 1000725, 'HR', 'Lokvičići', 1, 'lokvicici', 43.46428000, 17.09142000),
(1054700, 1000725, 'HR', 'Lovreć', 1, 'lovrec', 43.48761000, 16.98632000),
(1054710, 1000725, 'HR', 'Makarska', 1, 'makarska', 43.29694000, 17.01778000),
(1054733, 1000725, 'HR', 'Milna', 1, 'milna', 43.32667000, 16.45083000),
(1054742, 1000725, 'HR', 'Mravince', 1, 'mravince', 43.53333000, 16.52194000),
(1054747, 1000725, 'HR', 'Muć', 1, 'muc', 43.69328000, 16.47267000),
(1054752, 1000725, 'HR', 'Nerežišća', 1, 'nerezisca', 43.32959000, 16.57743000),
(1054772, 1000725, 'HR', 'Okrug', 1, 'okrug', 43.49638000, 16.26732000),
(1054773, 1000725, 'HR', 'Okrug Gornji', 1, 'okrug-gornji', 43.49473000, 16.26531000),
(1054775, 1000725, 'HR', 'Omiš', 1, 'omis', 43.44472000, 16.68861000),
(1054795, 1000725, 'HR', 'Otok', 1, 'otok', 43.68661000, 16.73488000),
(1054817, 1000725, 'HR', 'Podstrana', 1, 'podstrana', 43.48668000, 16.55013000),
(1054829, 1000725, 'HR', 'Postira', 1, 'postira', 43.37551000, 16.63091000),
(1054842, 1000725, 'HR', 'Proložac', 1, 'prolozac', 43.46690000, 17.15507000),
(1054847, 1000725, 'HR', 'Pučišća', 1, 'pucisca', 43.34778000, 16.73389000),
(1054872, 1000725, 'HR', 'Runović', 1, 'runovic', 43.37667000, 17.23667000),
(1054873, 1000725, 'HR', 'Runovići', 1, 'runovici', 43.38704000, 17.23892000),
(1054879, 1000725, 'HR', 'Seget', 1, 'seget', 43.54305000, 16.21222000),
(1054880, 1000725, 'HR', 'Seget Vranjica', 1, 'seget-vranjica', 43.50999000, 16.18704000),
(1054881, 1000725, 'HR', 'Selca', 1, 'selca', 43.29722000, 16.85083000),
(1054890, 1000725, 'HR', 'Sinj', 1, 'sinj', 43.70361000, 16.63944000),
(1054896, 1000725, 'HR', 'Slatine', 1, 'slatine', 43.49944000, 16.33333000),
(1054901, 1000725, 'HR', 'Solin', 1, 'solin', 43.54320000, 16.49314000),
(1055035, 1000725, 'HR', 'Šolta', 1, 'solta', 43.38714000, 16.28865000),
(1054904, 1000725, 'HR', 'Split', 1, 'split', 43.50891000, 16.43915000),
(1054906, 1000725, 'HR', 'Srinjine', 1, 'srinjine', 43.48333000, 16.60000000),
(1054907, 1000725, 'HR', 'Stari Grad', 1, 'stari-grad', 43.18472000, 16.59528000),
(1054913, 1000725, 'HR', 'Stobreč', 1, 'stobrec', 43.50250000, 16.52222000),
(1054923, 1000725, 'HR', 'Supetar', 1, 'supetar', 43.38417000, 16.55083000),
(1054941, 1000725, 'HR', 'Trilj', 1, 'trilj', 43.61833000, 16.72417000),
(1054942, 1000725, 'HR', 'Trogir', 1, 'trogir', 43.51250000, 16.25167000),
(1054946, 1000725, 'HR', 'Tučepi', 1, 'tucepi', 43.27222000, 17.05444000),
(1054945, 1000725, 'HR', 'Turjaci', 1, 'turjaci', 43.65000000, 16.66917000),
(1054961, 1000725, 'HR', 'Veliki Drvenik', 1, 'veliki-drvenik', 43.45000000, 16.15000000),
(1054974, 1000725, 'HR', 'Vis', 1, 'vis', 43.06194000, 16.18306000),
(1054987, 1000725, 'HR', 'Vranjic', 1, 'vranjic', 43.53333000, 16.46667000),
(1054993, 1000725, 'HR', 'Vrgorac', 1, 'vrgorac', 43.20583000, 17.37111000),
(1054994, 1000725, 'HR', 'Vrlika', 1, 'vrlika', 43.91098000, 16.39933000),
(1055005, 1000725, 'HR', 'Zagvozd', 1, 'zagvozd', 43.39750000, 17.05694000),
(1055012, 1000725, 'HR', 'Zmijavci', 1, 'zmijavci', 43.41083000, 17.20556000),
(1055040, 1000725, 'HR', 'Žrnovnica', 1, 'zrnovnica', 43.52111000, 16.55917000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000739, 'HR', 'Varaždin County', 1, 'varazdin-county');

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 
(1054395, 1000739, 'HR', 'Beretinec', 1, 'beretinec', 46.25000000, 16.30000000),
(1054416, 1000739, 'HR', 'Breznica', 1, 'breznica', 46.07111000, 16.27111000),
(1054417, 1000739, 'HR', 'Breznički Hum', 1, 'breznicki-hum', 46.10722000, 16.27667000),
(1054443, 1000739, 'HR', 'Cestica', 1, 'cestica', 46.37167000, 16.12528000),
(1054459, 1000739, 'HR', 'Donje Ladanje', 1, 'donje-ladanje', 46.30000000, 16.16667000),
(1054497, 1000739, 'HR', 'Gornje Vratno', 1, 'gornje-vratno', 46.35917000, 16.15444000),
(1054500, 1000739, 'HR', 'Gornji Kneginec', 1, 'gornji-kneginec', 46.25051000, 16.37555000),
(1054521, 1000739, 'HR', 'Grad Ivanec', 1, 'grad-ivanec', 46.23333000, 16.13333000),
(1054531, 1000739, 'HR', 'Grad Ludbreg', 1, 'grad-ludbreg', 46.25000000, 16.63333000),
(1054535, 1000739, 'HR', 'Grad Novi Marof', 1, 'grad-novi-marof', 46.16667000, 16.33333000),
(1054557, 1000739, 'HR', 'Grad Varaždin', 1, 'grad-varazdin', 46.30354000, 16.33444000),
(1054597, 1000739, 'HR', 'Hrašćica', 1, 'hrascica', 46.32494000, 16.29427000),
(1054604, 1000739, 'HR', 'Ivanec', 1, 'ivanec', 46.22306000, 16.12000000),
(1054613, 1000739, 'HR', 'Jalkovec', 1, 'jalkovec', 46.28083000, 16.31972000),
(1054614, 1000739, 'HR', 'Jalžabet', 1, 'jalzabet', 46.26083000, 16.47500000),
(1054649, 1000739, 'HR', 'Klenovnik', 1, 'klenovnik', 46.27028000, 16.07000000),
(1054678, 1000739, 'HR', 'Kućan Marof', 1, 'kucan-marof', 46.28944000, 16.37222000),
(1054687, 1000739, 'HR', 'Lepoglava', 1, 'lepoglava', 46.21056000, 16.03556000),
(1054693, 1000739, 'HR', 'Ljubešćica', 1, 'ljubescica', 46.16667000, 16.38333000),
(1054701, 1000739, 'HR', 'Ludbreg', 1, 'ludbreg', 46.25194000, 16.61472000),
(1054750, 1000739, 'HR', 'Nedeljanec', 1, 'nedeljanec', 46.28778000, 16.28333000),
(1054805, 1000739, 'HR', 'Petrijanec', 1, 'petrijanec', 46.34917000, 16.22500000),
(1054858, 1000739, 'HR', 'Remetinec', 1, 'remetinec', 46.18528000, 16.32778000),
(1054905, 1000739, 'HR', 'Sračinec', 1, 'sracinec', 46.32944000, 16.27889000),
(1054932, 1000739, 'HR', 'Sveti Đurđ', 1, 'sveti-durd', 46.28331000, 16.60438000),
(1054947, 1000739, 'HR', 'Tužno', 1, 'tuzno', 46.25667000, 16.23500000),
(1054953, 1000739, 'HR', 'Varaždin', 1, 'varazdin', 46.30444000, 16.33778000),
(1054965, 1000739, 'HR', 'Vidovec', 1, 'vidovec', 46.28333000, 16.24111000),
(1054968, 1000739, 'HR', 'Vinica', 1, 'vinica', 46.33611000, 16.14944000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000732, 'HR', 'Virovitica-Podravina County', 1, 'virovitica-podravina-county');

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 
(1055018, 1000732, 'HR', 'Čačinci', 1, 'cacinci', 45.60389000, 17.87028000),
(1055019, 1000732, 'HR', 'Čađavica', 1, 'cadavica', 45.74417000, 17.85472000),
(1054446, 1000732, 'HR', 'Crnac', 1, 'crnac', 45.69611000, 17.93722000),
(1054539, 1000732, 'HR', 'Grad Orahovica', 1, 'grad-orahovica', 45.53333000, 17.90000000),
(1054550, 1000732, 'HR', 'Grad Slatina', 1, 'grad-slatina', 45.70000000, 17.70000000),
(1054560, 1000732, 'HR', 'Grad Virovitica', 1, 'grad-virovitica', 45.83167000, 17.38483000),
(1054576, 1000732, 'HR', 'Gradina', 1, 'gradina', 45.85423000, 17.51109000),
(1054732, 1000732, 'HR', 'Mikleuš', 1, 'mikleus', 45.61861000, 17.80389000),
(1054756, 1000732, 'HR', 'Nova Bukovica', 1, 'nova-bukovica', 45.66472000, 17.76694000),
(1054786, 1000732, 'HR', 'Orahovica', 1, 'orahovica', 45.54000000, 17.88472000),
(1054809, 1000732, 'HR', 'Pitomača', 1, 'pitomaca', 45.95056000, 17.22944000),
(1054861, 1000732, 'HR', 'Rezovac', 1, 'rezovac', 45.78333000, 17.41667000),
(1054895, 1000732, 'HR', 'Slatina', 1, 'slatina', 45.70333000, 17.70278000),
(1054903, 1000732, 'HR', 'Sopje', 1, 'sopje', 45.80111000, 17.74250000),
(1055036, 1000732, 'HR', 'Špišić Bukovica', 1, 'spisic-bukovica', 45.85740000, 17.30089000),
(1054920, 1000732, 'HR', 'Suhopolje', 1, 'suhopolje', 45.79972000, 17.49917000),
(1054973, 1000732, 'HR', 'Virovitica', 1, 'virovitica', 45.83194000, 17.38389000),
(1054985, 1000732, 'HR', 'Voćin', 1, 'vocin', 45.61778000, 17.54778000),
(1055008, 1000732, 'HR', 'Zdenci', 1, 'zdenci', 45.58917000, 17.95028000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000741, 'HR', 'Vukovar-Syrmia County', 1, 'vukovar-syrmia-county');

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 
(1054380, 1000741, 'HR', 'Andrijaševci', 1, 'andrijasevci', 45.22472000, 18.73806000),
(1054382, 1000741, 'HR', 'Babina Greda', 1, 'babina-greda', 45.11722000, 18.53694000),
(1054405, 1000741, 'HR', 'Bobota', 1, 'bobota', 45.42111000, 18.85389000),
(1054406, 1000741, 'HR', 'Bogdanovci', 1, 'bogdanovci', 45.34083000, 18.93083000),
(1054408, 1000741, 'HR', 'Borovo', 1, 'borovo', 45.37639000, 18.96694000),
(1054409, 1000741, 'HR', 'Borovo Selo', 1, 'borovo-selo', 45.40528000, 18.97583000),
(1054410, 1000741, 'HR', 'Bošnjaci', 1, 'bosnjaci', 45.05028000, 18.75556000),
(1054428, 1000741, 'HR', 'Bršadin', 1, 'brsadin', 45.36278000, 18.91111000),
(1054439, 1000741, 'HR', 'Cerić', 1, 'ceric', 45.31139000, 18.85611000),
(1054440, 1000741, 'HR', 'Cerna', 1, 'cerna', 45.18194000, 18.68944000),
(1054467, 1000741, 'HR', 'Drenovci', 1, 'drenovci', 44.91944000, 18.90284000),
(1054559, 1000741, 'HR', 'Grad Vinkovci', 1, 'grad-vinkovci', 45.28044000, 18.80482000),
(1054565, 1000741, 'HR', 'Grad Vukovar', 1, 'grad-vukovar', 45.33333000, 19.00000000),
(1054573, 1000741, 'HR', 'Grad Županja', 1, 'grad-zupanja', 45.07231000, 18.69513000),
(1054578, 1000741, 'HR', 'Gradište', 1, 'gradiste', 45.14806000, 18.70667000),
(1054591, 1000741, 'HR', 'Gunja', 1, 'gunja', 44.88000000, 18.85333000),
(1054602, 1000741, 'HR', 'Ilok', 1, 'ilok', 45.22222000, 19.37694000),
(1054605, 1000741, 'HR', 'Ivankovo', 1, 'ivankovo', 45.28861000, 18.68389000),
(1054616, 1000741, 'HR', 'Jarmina', 1, 'jarmina', 45.31806000, 18.72917000),
(1054655, 1000741, 'HR', 'Komletinci', 1, 'komletinci', 45.14972000, 18.94917000),
(1054698, 1000741, 'HR', 'Lovas', 1, 'lovas', 45.22639000, 19.17111000),
(1054719, 1000741, 'HR', 'Markušica', 1, 'markusica', 45.37389000, 18.70583000),
(1054734, 1000741, 'HR', 'Mirkovci', 1, 'mirkovci', 45.26972000, 18.85111000),
(1054751, 1000741, 'HR', 'Negoslavci', 1, 'negoslavci', 45.27944000, 18.99667000),
(1054753, 1000741, 'HR', 'Nijemci', 1, 'nijemci', 45.14028000, 19.03556000),
(1054769, 1000741, 'HR', 'Nuštar', 1, 'nustar', 45.33250000, 18.84139000),
(1054794, 1000741, 'HR', 'Otok', 1, 'otok', 45.14667000, 18.88389000),
(1054840, 1000741, 'HR', 'Privlaka', 1, 'privlaka', 45.19472000, 18.83750000),
(1054860, 1000741, 'HR', 'Retkovci', 1, 'retkovci', 45.23333000, 18.65306000),
(1054866, 1000741, 'HR', 'Rokovci', 1, 'rokovci', 45.23111000, 18.74389000),
(1054902, 1000741, 'HR', 'Soljani', 1, 'soljani', 44.95028000, 18.97028000),
(1054909, 1000741, 'HR', 'Stari Jankovci', 1, 'stari-jankovci', 45.26194000, 18.91444000),
(1055037, 1000741, 'HR', 'Štitar', 1, 'stitar', 45.09556000, 18.64028000),
(1054938, 1000741, 'HR', 'Tordinci', 1, 'tordinci', 45.37028000, 18.79500000),
(1054939, 1000741, 'HR', 'Tovarnik', 1, 'tovarnik', 45.16500000, 19.15194000),
(1054943, 1000741, 'HR', 'Trpinja', 1, 'trpinja', 45.41917000, 18.89917000),
(1054969, 1000741, 'HR', 'Vinkovci', 1, 'vinkovci', 45.28833000, 18.80472000),
(1054986, 1000741, 'HR', 'Vođinci', 1, 'vodinci', 45.27556000, 18.60972000),
(1054989, 1000741, 'HR', 'Vrbanja', 1, 'vrbanja', 44.98079000, 18.92717000),
(1055000, 1000741, 'HR', 'Vukovar', 1, 'vukovar', 45.35161000, 19.00225000),
(1055043, 1000741, 'HR', 'Županja', 1, 'zupanja', 45.07750000, 18.69750000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000727, 'HR', 'Zadar County', 1, 'zadar-county');

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 
(1054394, 1000727, 'HR', 'Benkovac', 1, 'benkovac', 44.03444000, 15.61278000),
(1054397, 1000727, 'HR', 'Bibinje', 1, 'bibinje', 44.07324000, 15.28288000),
(1054400, 1000727, 'HR', 'Biograd na Moru', 1, 'biograd-na-moru', 43.94333000, 15.45194000),
(1054488, 1000727, 'HR', 'Galovac', 1, 'galovac', 44.07139000, 15.39333000),
(1054499, 1000727, 'HR', 'Gornji Karin', 1, 'gornji-karin', 44.13598000, 15.63423000),
(1054582, 1000727, 'HR', 'Gračac', 1, 'gracac', 44.29916000, 15.84752000),
(1054504, 1000727, 'HR', 'Grad Biograd na Moru', 1, 'grad-biograd-na-moru', 43.93333000, 15.43333000),
(1054617, 1000727, 'HR', 'Jasenice', 1, 'jasenice', 44.22969000, 15.57514000),
(1054625, 1000727, 'HR', 'Kali', 1, 'kali', 44.06278000, 15.20556000),
(1054673, 1000727, 'HR', 'Kruševo', 1, 'krusevo', 44.18333000, 15.65000000),
(1054754, 1000727, 'HR', 'Nin', 1, 'nin', 44.24139000, 15.17833000),
(1054762, 1000727, 'HR', 'Novigrad Općina', 1, 'novigrad-opcina', 44.19417000, 15.55667000),
(1054770, 1000727, 'HR', 'Obrovac', 1, 'obrovac', 44.20056000, 15.68222000),
(1054793, 1000727, 'HR', 'Osljak', 1, 'osljak', 44.07667000, 15.20722000),
(1054797, 1000727, 'HR', 'Pag', 1, 'pag', 44.44500000, 15.05750000),
(1054798, 1000727, 'HR', 'Pakoštane', 1, 'pakostane', 43.91222000, 15.50889000),
(1054822, 1000727, 'HR', 'Polača', 1, 'polaca', 44.01833000, 15.51750000),
(1054823, 1000727, 'HR', 'Poličnik', 1, 'policnik', 44.17806000, 15.37556000),
(1054828, 1000727, 'HR', 'Posedarje', 1, 'posedarje', 44.21361000, 15.47667000),
(1054833, 1000727, 'HR', 'Preko', 1, 'preko', 44.08111000, 15.18750000),
(1054837, 1000727, 'HR', 'Pridraga', 1, 'pridraga', 44.16667000, 15.56667000),
(1054841, 1000727, 'HR', 'Privlaka', 1, 'privlaka', 44.26667000, 15.13333000),
(1054856, 1000727, 'HR', 'Ražanac', 1, 'razanac', 44.28194000, 15.34806000),
(1054875, 1000727, 'HR', 'Sali', 1, 'sali', 43.93972000, 15.16333000),
(1055032, 1000727, 'HR', 'Škabrnja', 1, 'skabrnja', 44.08949000, 15.45146000),
(1054908, 1000727, 'HR', 'Stari Grad', 1, 'stari-grad', 44.43000000, 15.06222000),
(1054911, 1000727, 'HR', 'Starigrad', 1, 'starigrad', 44.29601000, 15.43865000),
(1054921, 1000727, 'HR', 'Sukošan', 1, 'sukosan', 44.04696000, 15.31391000),
(1054928, 1000727, 'HR', 'Sveti Filip i Jakov', 1, 'sveti-filip-i-jakov', 43.96472000, 15.43000000),
(1054937, 1000727, 'HR', 'Tkon', 1, 'tkon', 43.91996000, 15.41639000),
(1054944, 1000727, 'HR', 'Turanj', 1, 'turanj', 43.97111000, 15.41139000),
(1054948, 1000727, 'HR', 'Ugljan', 1, 'ugljan', 44.13083000, 15.10306000),
(1054971, 1000727, 'HR', 'Vir', 1, 'vir', 44.29995000, 15.08663000),
(1054998, 1000727, 'HR', 'Vrsi', 1, 'vrsi', 44.26472000, 15.23250000),
(1055002, 1000727, 'HR', 'Zadar', 1, 'zadar', 44.11972000, 15.24222000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000738, 'HR', 'Zagreb', 1, 'zagreb');

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 
(1054419, 1000738, 'HR', 'Brezovica', 1, 'brezovica', 45.72919000, 15.91069000),
(1054438, 1000738, 'HR', 'Centar', 1, 'centar', 45.81313000, 15.97753000),
(1054470, 1000738, 'HR', 'Dubrava', 1, 'dubrava', 45.83361000, 16.06361000),
(1054579, 1000738, 'HR', 'Gradska četvrt Donji grad', 1, 'gradska-cetvrt-donji-grad', 45.80834000, 15.96949000),
(1054580, 1000738, 'HR', 'Gradska četvrt Gornji Grad - Medvescak', 1, 'gradska-cetvrt-gornji-grad-medvescak', 45.82820000, 15.97938000),
(1054581, 1000738, 'HR', 'Gradska četvrt Podsljeme', 1, 'gradska-cetvrt-podsljeme', 45.86097000, 15.97996000),
(1054596, 1000738, 'HR', 'Horvati', 1, 'horvati', 45.70000000, 15.81667000),
(1054615, 1000738, 'HR', 'Jankomir', 1, 'jankomir', 45.79167000, 15.90000000),
(1054623, 1000738, 'HR', 'Ježdovec', 1, 'jezdovec', 45.78333000, 15.85000000),
(1054636, 1000738, 'HR', 'Kašina', 1, 'kasina', 45.91134000, 16.12436000),
(1054707, 1000738, 'HR', 'Lučko', 1, 'lucko', 45.76111000, 15.87028000),
(1054760, 1000738, 'HR', 'Novi Zagreb', 1, 'novi-zagreb', 45.78333000, 15.98333000),
(1054771, 1000738, 'HR', 'Odra', 1, 'odra', 45.72979000, 15.99240000),
(1054885, 1000738, 'HR', 'Sesvete', 1, 'sesvete', 45.83333000, 16.13333000),
(1054912, 1000738, 'HR', 'Stenjevec', 1, 'stenjevec', 45.80846000, 15.88245000),
(1054917, 1000738, 'HR', 'Strmec', 1, 'strmec', 45.70843000, 15.91674000),
(1055003, 1000738, 'HR', 'Zadvorsko', 1, 'zadvorsko', 45.71978000, 15.90880000),
(1055004, 1000738, 'HR', 'Zagreb', 1, 'zagreb', 45.81444000, 15.97798000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000736, 'HR', 'Zagreb County', 1, 'zagreb-county');

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 
(1054396, 1000736, 'HR', 'Bestovje', 1, 'bestovje', 45.80833000, 15.81667000),
(1054401, 1000736, 'HR', 'Bistra', 1, 'bistra', 45.90657000, 15.85087000),
(1054411, 1000736, 'HR', 'Brckovljani', 1, 'brckovljani', 45.83333000, 16.30000000),
(1054412, 1000736, 'HR', 'Brdovec', 1, 'brdovec', 45.86666000, 15.77102000),
(1054413, 1000736, 'HR', 'Bregana', 1, 'bregana', 45.84013000, 15.68792000),
(1054456, 1000736, 'HR', 'Donja Bistra', 1, 'donja-bistra', 45.90778000, 15.85444000),
(1054457, 1000736, 'HR', 'Donja Lomnica', 1, 'donja-lomnica', 45.71194000, 16.02694000),
(1054458, 1000736, 'HR', 'Donja Zdenčina', 1, 'donja-zdencina', 45.66667000, 15.76667000),
(1054462, 1000736, 'HR', 'Donji Stupnik', 1, 'donji-stupnik', 45.73971000, 15.85975000),
(1054478, 1000736, 'HR', 'Farkaševac', 1, 'farkasevac', 45.87899000, 16.63467000),
(1054495, 1000736, 'HR', 'Gornja Bistra', 1, 'gornja-bistra', 45.91667000, 15.90000000),
(1054583, 1000736, 'HR', 'Gračec', 1, 'gracec', 45.83333000, 16.31667000),
(1054514, 1000736, 'HR', 'Grad Dugo Selo', 1, 'grad-dugo-selo', 45.80900000, 16.24123000),
(1054522, 1000736, 'HR', 'Grad Jastrebarsko', 1, 'grad-jastrebarsko', 45.66667000, 15.66667000),
(1054547, 1000736, 'HR', 'Grad Samobor', 1, 'grad-samobor', 45.80000000, 15.70000000),
(1054554, 1000736, 'HR', 'Grad Sveti Ivan Zelina', 1, 'grad-sveti-ivan-zelina', 45.96667000, 16.25000000),
(1054558, 1000736, 'HR', 'Grad Velika Gorica', 1, 'grad-velika-gorica', 45.70000000, 16.08333000),
(1054562, 1000736, 'HR', 'Grad Vrbovec', 1, 'grad-vrbovec', 45.86667000, 16.43333000),
(1054567, 1000736, 'HR', 'Grad Zaprešić', 1, 'grad-zapresic', 45.86667000, 15.80000000),
(1054575, 1000736, 'HR', 'Gradec', 1, 'gradec', 45.91111000, 16.48278000),
(1054577, 1000736, 'HR', 'Gradići', 1, 'gradici', 45.70000000, 16.05000000),
(1054608, 1000736, 'HR', 'Jablanovec', 1, 'jablanovec', 45.87583000, 15.85361000),
(1054611, 1000736, 'HR', 'Jakovlje', 1, 'jakovlje', 45.93611000, 15.85559000),
(1054618, 1000736, 'HR', 'Jastrebarsko', 1, 'jastrebarsko', 45.66833000, 15.64861000),
(1054645, 1000736, 'HR', 'Kerestinec', 1, 'kerestinec', 45.77010000, 15.80864000),
(1054669, 1000736, 'HR', 'Križ', 1, 'kriz', 45.66500000, 16.52333000),
(1054679, 1000736, 'HR', 'Kuče', 1, 'kuce', 45.67694000, 16.14500000),
(1054695, 1000736, 'HR', 'Lonjica', 1, 'lonjica', 45.85500000, 16.33000000),
(1054702, 1000736, 'HR', 'Luka', 1, 'luka', 45.95795000, 15.81954000),
(1054703, 1000736, 'HR', 'Lukavec', 1, 'lukavec', 45.70444000, 15.99000000),
(1054705, 1000736, 'HR', 'Lupoglav', 1, 'lupoglav', 45.79639000, 16.34639000),
(1054735, 1000736, 'HR', 'Mičevec', 1, 'micevec', 45.75000000, 16.06667000),
(1054741, 1000736, 'HR', 'Mraclin', 1, 'mraclin', 45.66667000, 16.09556000),
(1054766, 1000736, 'HR', 'Novo Čiče', 1, 'novo-cice', 45.70000000, 16.11667000),
(1054767, 1000736, 'HR', 'Novoselec', 1, 'novoselec', 45.65250000, 16.53639000),
(1054781, 1000736, 'HR', 'Općina Dubrava', 1, 'opcina-dubrava', 45.83759000, 16.53683000),
(1054789, 1000736, 'HR', 'Orešje', 1, 'oresje', 45.81618000, 15.80246000),
(1054820, 1000736, 'HR', 'Pojatno', 1, 'pojatno', 45.90500000, 15.80056000),
(1054835, 1000736, 'HR', 'Preseka', 1, 'preseka', 45.97456000, 16.38697000),
(1054838, 1000736, 'HR', 'Prigorje Brdovečko', 1, 'prigorje-brdovecko', 45.87944000, 15.73806000),
(1054848, 1000736, 'HR', 'Pušća', 1, 'pusca', 45.91567000, 15.78049000),
(1054852, 1000736, 'HR', 'Rakitje', 1, 'rakitje', 45.79389000, 15.82222000),
(1054853, 1000736, 'HR', 'Rakov Potok', 1, 'rakov-potok', 45.73806000, 15.79722000),
(1054871, 1000736, 'HR', 'Rude', 1, 'rude', 45.76667000, 15.66667000),
(1054876, 1000736, 'HR', 'Samobor', 1, 'samobor', 45.80306000, 15.71806000),
(1054919, 1000736, 'HR', 'Stupnik', 1, 'stupnik', 45.75314000, 15.84078000),
(1054926, 1000736, 'HR', 'Sveta Nedelja', 1, 'sveta-nedelja', 45.79617000, 15.77971000),
(1054927, 1000736, 'HR', 'Sveta Nedjelja', 1, 'sveta-nedjelja', 45.79833000, 15.78056000),
(1054956, 1000736, 'HR', 'Velika Gorica', 1, 'velika-gorica', 45.71250000, 16.07556000),
(1054958, 1000736, 'HR', 'Velika Mlaka', 1, 'velika-mlaka', 45.73639000, 16.03111000),
(1054959, 1000736, 'HR', 'Velika Ostrna', 1, 'velika-ostrna', 45.78752000, 16.28139000),
(1054991, 1000736, 'HR', 'Vrbovec', 1, 'vrbovec', 45.88333000, 16.42167000),
(1055006, 1000736, 'HR', 'Zaprešić', 1, 'zapresic', 45.85639000, 15.80778000),
(1055009, 1000736, 'HR', 'Zdenci Brdovečki', 1, 'zdenci-brdovecki', 45.86667000, 15.75000000);

