REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug, s_phone_code, s_name_native, s_currency) VALUES 
('HU', 'Hungary', 'hungary', '36', 'Magyarország', 'HUF');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001048, 'HU', 'Bács-Kiskun County', 1, 'bacs-kiskun-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 
(1056141, 1001048, 'HU', 'Ágasegyháza', 1, 'agasegyhaza', 46.84025000, 19.45208000),
(1055180, 1001048, 'HU', 'Akasztó', 1, 'akaszto', 46.69167000, 19.20423000),
(1055191, 1001048, 'HU', 'Apostag', 1, 'apostag', 46.88208000, 18.96210000),
(1055287, 1001048, 'HU', 'Bácsalmás', 1, 'bacsalmas', 46.12648000, 19.33260000),
(1055288, 1001048, 'HU', 'Bácsalmási Járás', 1, 'bacsalmasi-jaras', 46.10167000, 19.33063000),
(1055289, 1001048, 'HU', 'Bácsbokod', 1, 'bacsbokod', 46.12500000, 19.15621000),
(1055203, 1001048, 'HU', 'Baja', 1, 'baja', 46.18299000, 18.95307000),
(1055204, 1001048, 'HU', 'Bajai Járás', 1, 'bajai-jaras', 46.14507000, 19.01359000),
(1055225, 1001048, 'HU', 'Ballószög', 1, 'balloszog', 46.86216000, 19.57092000),
(1055295, 1001048, 'HU', 'Bátya', 1, 'batya', 46.48800000, 18.95419000),
(1055283, 1001048, 'HU', 'Bugac', 1, 'bugac', 46.68704000, 19.68074000),
(1055347, 1001048, 'HU', 'Császártöltés', 1, 'csaszartoltes', 46.42194000, 19.18361000),
(1055348, 1001048, 'HU', 'Csávoly', 1, 'csavoly', 46.18917000, 19.14667000),
(1055331, 1001048, 'HU', 'Csengőd', 1, 'csengod', 46.71543000, 19.26802000),
(1055386, 1001048, 'HU', 'Dávod', 1, 'davod', 45.99500000, 18.91722000),
(1055377, 1001048, 'HU', 'Dunapataj', 1, 'dunapataj', 46.64400000, 18.99632000),
(1055381, 1001048, 'HU', 'Dunavecse', 1, 'dunavecse', 46.91478000, 18.97127000),
(1055383, 1001048, 'HU', 'Dusnok', 1, 'dusnok', 46.39085000, 18.96296000),
(1056147, 1001048, 'HU', 'Érsekcsanád', 1, 'ersekcsanad', 46.25352000, 18.98457000),
(1055424, 1001048, 'HU', 'Felsőszentiván', 1, 'felsoszentivan', 46.19713000, 19.18686000),
(1055439, 1001048, 'HU', 'Fülöpjakab', 1, 'fulopjakab', 46.74221000, 19.72132000),
(1055440, 1001048, 'HU', 'Fülöpszállás', 1, 'fulopszallas', 46.82075000, 19.23748000),
(1055446, 1001048, 'HU', 'Gara', 1, 'gara', 46.03194000, 19.04278000),
(1055493, 1001048, 'HU', 'Hajós', 1, 'hajos', 46.39861000, 19.12056000),
(1055499, 1001048, 'HU', 'Harta', 1, 'harta', 46.69758000, 19.03110000),
(1055504, 1001048, 'HU', 'Helvécia', 1, 'helvecia', 46.83661000, 19.62251000),
(1055505, 1001048, 'HU', 'Hercegszántó', 1, 'hercegszanto', 45.95000000, 18.93917000),
(1055531, 1001048, 'HU', 'Izsák', 1, 'izsak', 46.80454000, 19.35172000),
(1055535, 1001048, 'HU', 'Jánoshalma', 1, 'janoshalma', 46.29861000, 19.32583000),
(1055536, 1001048, 'HU', 'Jánoshalmai Járás', 1, 'janoshalmai-jaras', 46.28283000, 19.31742000),
(1055552, 1001048, 'HU', 'Jászszentlászló', 1, 'jaszszentlaszlo', 46.56685000, 19.76065000),
(1055558, 1001048, 'HU', 'Kalocsa', 1, 'kalocsa', 46.52981000, 18.97283000),
(1055559, 1001048, 'HU', 'Kalocsai Járás', 1, 'kalocsai-jaras', 46.55646000, 19.04211000),
(1055574, 1001048, 'HU', 'Katymár', 1, 'katymar', 46.03398000, 19.20935000),
(1055578, 1001048, 'HU', 'Kecel', 1, 'kecel', 46.52528000, 19.25194000),
(1055579, 1001048, 'HU', 'Kecskemét', 1, 'kecskemet', 46.90618000, 19.69128000),
(1055580, 1001048, 'HU', 'Kecskeméti Járás', 1, 'kecskemeti-jaras', 46.88283000, 19.58701000),
(1055581, 1001048, 'HU', 'Kelebia', 1, 'kelebia', 46.19680000, 19.61659000),
(1055587, 1001048, 'HU', 'Kerekegyháza', 1, 'kerekegyhaza', 46.93722000, 19.47806000),
(1055602, 1001048, 'HU', 'Kiskőrös', 1, 'kiskoros', 46.62139000, 19.28528000),
(1055603, 1001048, 'HU', 'Kiskőrösi Járás', 1, 'kiskorosi-jaras', 46.63309000, 19.33726000),
(1055594, 1001048, 'HU', 'Kiskunfélegyháza', 1, 'kiskunfelegyhaza', 46.71213000, 19.84458000),
(1055595, 1001048, 'HU', 'Kiskunfélegyházi Járás', 1, 'kiskunfelegyhazi-jaras', 46.65721000, 19.77006000),
(1055596, 1001048, 'HU', 'Kiskunhalas', 1, 'kiskunhalas', 46.43402000, 19.48479000),
(1055597, 1001048, 'HU', 'Kiskunhalasi Járás', 1, 'kiskunhalasi-jaras', 46.35832000, 19.53067000),
(1055599, 1001048, 'HU', 'Kiskunmajsa', 1, 'kiskunmajsa', 46.49028000, 19.74000000),
(1055600, 1001048, 'HU', 'Kiskunmajsai Járás', 1, 'kiskunmajsai-jaras', 46.49608000, 19.72316000),
(1055608, 1001048, 'HU', 'Kisszállás', 1, 'kisszallas', 46.28009000, 19.48954000),
(1055626, 1001048, 'HU', 'Kunfehértó', 1, 'kunfeherto', 46.36091000, 19.41454000),
(1055630, 1001048, 'HU', 'Kunszentmiklós', 1, 'kunszentmiklos', 47.02699000, 19.12575000),
(1055631, 1001048, 'HU', 'Kunszentmiklósi Járás', 1, 'kunszentmiklosi-jaras', 46.94810000, 19.15563000),
(1055654, 1001048, 'HU', 'Lajosmizse', 1, 'lajosmizse', 47.02133000, 19.56171000),
(1055655, 1001048, 'HU', 'Lakitelek', 1, 'lakitelek', 46.87601000, 19.99504000),
(1055672, 1001048, 'HU', 'Madaras', 1, 'madaras', 46.05870000, 19.26121000),
(1055731, 1001048, 'HU', 'Mélykút', 1, 'melykut', 46.21509000, 19.38102000),
(1055741, 1001048, 'HU', 'Nagybaracska', 1, 'nagybaracska', 46.04248000, 18.90590000),
(1055765, 1001048, 'HU', 'Nemesnádudvar', 1, 'nemesnadudvar', 46.34051000, 19.05115000),
(1055768, 1001048, 'HU', 'Nyárlőrinc', 1, 'nyarlorinc', 46.86017000, 19.87836000),
(1055799, 1001048, 'HU', 'Orgovány', 1, 'orgovany', 46.75087000, 19.47259000),
(1055840, 1001048, 'HU', 'Pálmonostora', 1, 'palmonostora', 46.62417000, 19.95156000),
(1055903, 1001048, 'HU', 'Solt', 1, 'solt', 46.80101000, 19.00098000),
(1055904, 1001048, 'HU', 'Soltvadkert', 1, 'soltvadkert', 46.57889000, 19.39389000),
(1055997, 1001048, 'HU', 'Sükösd', 1, 'sukosd', 46.28181000, 18.99524000),
(1055913, 1001048, 'HU', 'Szabadszállás', 1, 'szabadszallas', 46.87575000, 19.22324000),
(1055917, 1001048, 'HU', 'Szalkszentmárton', 1, 'szalkszentmarton', 46.97565000, 19.01178000),
(1055919, 1001048, 'HU', 'Szank', 1, 'szank', 46.55713000, 19.66103000),
(1055942, 1001048, 'HU', 'Szentkirály', 1, 'szentkiraly', 46.91892000, 19.91846000),
(1056016, 1001048, 'HU', 'Tass', 1, 'tass', 47.02095000, 19.02988000),
(1056072, 1001048, 'HU', 'Tázlár', 1, 'tazlar', 46.54824000, 19.51436000),
(1056021, 1001048, 'HU', 'Tiszaalpár', 1, 'tiszaalpar', 46.81279000, 19.99841000),
(1056035, 1001048, 'HU', 'Tiszakécske', 1, 'tiszakecske', 46.93261000, 20.10349000),
(1056036, 1001048, 'HU', 'Tiszakécskei Járás', 1, 'tiszakecskei-jaras', 46.86013000, 19.97298000),
(1056055, 1001048, 'HU', 'Tompa', 1, 'tompa', 46.20605000, 19.53910000),
(1056111, 1001048, 'HU', 'Városföld', 1, 'varosfold', 46.81674000, 19.75668000),
(1056091, 1001048, 'HU', 'Vaskút', 1, 'vaskut', 46.10782000, 18.98514000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001055, 'HU', 'Baranya County', 1, 'baranya-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 
(1055238, 1001055, 'HU', 'Beremend', 1, 'beremend', 45.79108000, 18.43263000),
(1055304, 1001055, 'HU', 'Bóly', 1, 'boly', 45.96722000, 18.51833000),
(1055305, 1001055, 'HU', 'Bólyi Járás', 1, 'bolyi-jaras', 45.98075000, 18.48449000),
(1055310, 1001055, 'HU', 'Bükkösd', 1, 'bukkosd', 46.10751000, 17.98820000),
(1055378, 1001055, 'HU', 'Dunaszekcső', 1, 'dunaszekcso', 46.08740000, 18.75870000),
(1055497, 1001055, 'HU', 'Harkány', 1, 'harkany', 45.85002000, 18.23668000),
(1055502, 1001055, 'HU', 'Hegyháti Járás', 1, 'hegyhati-jaras', 46.27247000, 18.13758000),
(1055512, 1001055, 'HU', 'Hidas', 1, 'hidas', 46.25680000, 18.49540000),
(1055516, 1001055, 'HU', 'Hosszúhetény', 1, 'hosszuheteny', 46.16414000, 18.35077000),
(1055618, 1001055, 'HU', 'Komló', 1, 'komlo', 46.19278000, 18.26494000),
(1055619, 1001055, 'HU', 'Komlói Járás', 1, 'komloi-jaras', 46.22019000, 18.28620000),
(1055625, 1001055, 'HU', 'Kozármisleny', 1, 'kozarmisleny', 46.02967000, 18.29210000),
(1055667, 1001055, 'HU', 'Lánycsók', 1, 'lanycsok', 46.00543000, 18.62526000),
(1055719, 1001055, 'HU', 'Mágocs', 1, 'magocs', 46.34998000, 18.23240000),
(1055684, 1001055, 'HU', 'Mecseknádasd', 1, 'mecseknadasd', 46.22468000, 18.47076000),
(1055708, 1001055, 'HU', 'Mohács', 1, 'mohacs', 45.99020000, 18.68621000),
(1055709, 1001055, 'HU', 'Mohácsi Járás', 1, 'mohacsi-jaras', 46.02004000, 18.68000000),
(1055850, 1001055, 'HU', 'Pécs', 1, 'pecs', 46.08333000, 18.23333000),
(1055851, 1001055, 'HU', 'Pécsi Járás', 1, 'pecsi-jaras', 46.07990000, 18.25253000),
(1055852, 1001055, 'HU', 'Pécsvárad', 1, 'pecsvarad', 46.16033000, 18.42321000),
(1055853, 1001055, 'HU', 'Pécsváradi Járás', 1, 'pecsvaradi-jaras', 46.16782000, 18.45456000),
(1055812, 1001055, 'HU', 'Pellérd', 1, 'pellerd', 46.03438000, 18.15403000),
(1055993, 1001055, 'HU', 'Sásd', 1, 'sasd', 46.25520000, 18.10776000),
(1055894, 1001055, 'HU', 'Sellye', 1, 'sellye', 45.87247000, 17.84711000),
(1055895, 1001055, 'HU', 'Sellyei Járás', 1, 'sellyei-jaras', 45.86955000, 17.89827000),
(1055897, 1001055, 'HU', 'Siklós', 1, 'siklos', 45.85499000, 18.29752000),
(1055898, 1001055, 'HU', 'Siklósi Járás', 1, 'siklosi-jaras', 45.84981000, 18.31052000),
(1055970, 1001055, 'HU', 'Szászvár', 1, 'szaszvar', 46.27673000, 18.37566000),
(1055944, 1001055, 'HU', 'Szentlőrinc', 1, 'szentlorinc', 46.04016000, 17.98719000),
(1055945, 1001055, 'HU', 'Szentlőrinci Járás', 1, 'szentlorinci-jaras', 46.04694000, 18.01528000),
(1055954, 1001055, 'HU', 'Szigetvár', 1, 'szigetvar', 46.04865000, 17.80554000),
(1055955, 1001055, 'HU', 'Szigetvári Járás', 1, 'szigetvari-jaras', 46.07336000, 17.80391000),
(1056089, 1001055, 'HU', 'Vajszló', 1, 'vajszlo', 45.85957000, 17.98406000),
(1056102, 1001055, 'HU', 'Villány', 1, 'villany', 45.86889000, 18.45389000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001060, 'HU', 'Békés County', 1, 'bekes-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 
(1055233, 1001060, 'HU', 'Battonya', 1, 'battonya', 46.28333000, 21.01667000),
(1055296, 1001060, 'HU', 'Békés', 1, 'bekes', 46.76667000, 21.13333000),
(1055297, 1001060, 'HU', 'Békéscsaba', 1, 'bekescsaba', 46.68333000, 21.10000000),
(1055298, 1001060, 'HU', 'Békéscsabai Járás', 1, 'bekescsabai-jaras', 46.68133000, 21.07413000),
(1055299, 1001060, 'HU', 'Békési Járás', 1, 'bekesi-jaras', 46.83317000, 21.10000000),
(1055301, 1001060, 'HU', 'Békéssámson', 1, 'bekessamson', 46.41667000, 20.63333000),
(1055300, 1001060, 'HU', 'Békésszentandrás', 1, 'bekesszentandras', 46.86667000, 20.48333000),
(1055259, 1001060, 'HU', 'Bucsa', 1, 'bucsa', 47.20000000, 21.00000000),
(1055325, 1001060, 'HU', 'Csanádapáca', 1, 'csanadapaca', 46.55000000, 20.88333000),
(1055342, 1001060, 'HU', 'Csorvás', 1, 'csorvas', 46.63333000, 20.83333000),
(1055389, 1001060, 'HU', 'Dévaványa', 1, 'devavanya', 47.03333000, 20.96667000),
(1055364, 1001060, 'HU', 'Doboz', 1, 'doboz', 46.73333000, 21.25000000),
(1055366, 1001060, 'HU', 'Dombegyház', 1, 'dombegyhaz', 46.33333000, 21.13333000),
(1055402, 1001060, 'HU', 'Elek', 1, 'elek', 46.53333000, 21.25000000),
(1055443, 1001060, 'HU', 'Füzesgyarmat', 1, 'fuzesgyarmat', 47.10000000, 21.21667000),
(1055470, 1001060, 'HU', 'Gádoros', 1, 'gadoros', 46.66667000, 20.60000000),
(1055451, 1001060, 'HU', 'Gyomaendrőd', 1, 'gyomaendrod', 46.93333000, 20.83333000),
(1055452, 1001060, 'HU', 'Gyomaendrődi Járás', 1, 'gyomaendrodi-jaras', 46.98216000, 20.84851000),
(1055453, 1001060, 'HU', 'Gyula', 1, 'gyula', 46.65000000, 21.28333000),
(1055455, 1001060, 'HU', 'Gyulai Járás', 1, 'gyulai-jaras', 46.58626000, 21.22454000),
(1055573, 1001060, 'HU', 'Kaszaper', 1, 'kaszaper', 46.46667000, 20.83333000),
(1055642, 1001060, 'HU', 'Kétegyháza', 1, 'ketegyhaza', 46.53333000, 21.18333000),
(1055591, 1001060, 'HU', 'Kevermes', 1, 'kevermes', 46.41667000, 21.18333000),
(1055622, 1001060, 'HU', 'Kondoros', 1, 'kondoros', 46.76667000, 20.80000000),
(1055649, 1001060, 'HU', 'Körösladány', 1, 'korosladany', 46.96667000, 21.08333000),
(1055650, 1001060, 'HU', 'Köröstarcsa', 1, 'korostarcsa', 46.88333000, 21.03333000),
(1055634, 1001060, 'HU', 'Kunágota', 1, 'kunagota', 46.43333000, 21.05000000),
(1055670, 1001060, 'HU', 'Lőkösháza', 1, 'lokoshaza', 46.43333000, 21.23333000),
(1055675, 1001060, 'HU', 'Magyarbánhegyes', 1, 'magyarbanhegyes', 46.45000000, 20.96667000),
(1055685, 1001060, 'HU', 'Medgyesegyháza', 1, 'medgyesegyhaza', 46.50000000, 21.03333000),
(1055730, 1001060, 'HU', 'Méhkerék', 1, 'mehkerek', 46.78333000, 21.45000000),
(1055688, 1001060, 'HU', 'Mezőberény', 1, 'mezobereny', 46.81667000, 21.03333000),
(1055692, 1001060, 'HU', 'Mezőhegyes', 1, 'mezohegyes', 46.31667000, 20.81667000),
(1055694, 1001060, 'HU', 'Mezőkovácsháza', 1, 'mezokovacshaza', 46.40000000, 20.91667000),
(1055695, 1001060, 'HU', 'Mezőkovácsházai Járás', 1, 'mezokovacshazai-jaras', 46.40888000, 21.00318000),
(1055762, 1001060, 'HU', 'Nagyszénás', 1, 'nagyszenas', 46.68333000, 20.66667000),
(1055796, 1001060, 'HU', 'Okány', 1, 'okany', 46.90000000, 21.35000000),
(1055800, 1001060, 'HU', 'Orosháza', 1, 'oroshaza', 46.56667000, 20.66667000),
(1055801, 1001060, 'HU', 'Orosházi Járás', 1, 'oroshazi-jaras', 46.56355000, 20.73357000),
(1055833, 1001060, 'HU', 'Pusztaföldvár', 1, 'pusztafoldvar', 46.53333000, 20.80000000),
(1055891, 1001060, 'HU', 'Sarkad', 1, 'sarkad', 46.75000000, 21.38333000),
(1055892, 1001060, 'HU', 'Sarkadi Járás', 1, 'sarkadi-jaras', 46.86154000, 21.44875000),
(1055912, 1001060, 'HU', 'Szabadkígyós', 1, 'szabadkigyos', 46.61667000, 21.10000000),
(1055921, 1001060, 'HU', 'Szarvas', 1, 'szarvas', 46.86667000, 20.55000000),
(1055922, 1001060, 'HU', 'Szarvasi Járás', 1, 'szarvasi-jaras', 46.82891000, 20.63707000),
(1055927, 1001060, 'HU', 'Szeghalmi Járás', 1, 'szeghalmi-jaras', 47.00000000, 21.17000000),
(1055928, 1001060, 'HU', 'Szeghalom', 1, 'szeghalom', 47.03333000, 21.16667000),
(1056078, 1001060, 'HU', 'Tótkomlós', 1, 'totkomlos', 46.41667000, 20.73333000),
(1056162, 1001060, 'HU', 'Újkígyós', 1, 'ujkigyos', 46.58333000, 21.03333000),
(1056117, 1001060, 'HU', 'Vésztő', 1, 'veszto', 46.91667000, 21.26667000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001036, 'HU', 'Békéscsaba', 1, 'bekescsaba');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001058, 'HU', 'Borsod-Abaúj-Zemplén County', 1, 'borsod-abauj-zemplen-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 
(1055170, 1001058, 'HU', 'Abaújszántó', 1, 'abaujszanto', 48.28333000, 21.20000000),
(1055186, 1001058, 'HU', 'Alsózsolca', 1, 'alsozsolca', 48.06982000, 20.88046000),
(1055194, 1001058, 'HU', 'Arló', 1, 'arlo', 48.18333000, 20.26667000),
(1055195, 1001058, 'HU', 'Arnót', 1, 'arnot', 48.13058000, 20.85832000),
(1055196, 1001058, 'HU', 'Aszaló', 1, 'aszalo', 48.21667000, 20.96667000),
(1055235, 1001058, 'HU', 'Bekecs', 1, 'bekecs', 48.15000000, 21.18333000),
(1055311, 1001058, 'HU', 'Bőcs', 1, 'bocs', 48.05000000, 20.96667000),
(1055252, 1001058, 'HU', 'Bogács', 1, 'bogacs', 47.90000000, 20.53333000),
(1055254, 1001058, 'HU', 'Boldva', 1, 'boldva', 48.21667000, 20.80000000),
(1055258, 1001058, 'HU', 'Borsodnádasd', 1, 'borsodnadasd', 48.11667000, 20.25000000),
(1055321, 1001058, 'HU', 'Cigánd', 1, 'cigand', 48.25561000, 21.89195000),
(1055322, 1001058, 'HU', 'Cigándi Járás', 1, 'cigandi-jaras', 48.30338000, 21.87651000),
(1055396, 1001058, 'HU', 'Edelény', 1, 'edeleny', 48.30000000, 20.73333000),
(1055397, 1001058, 'HU', 'Edelényi Járás', 1, 'edelenyi-jaras', 48.40864000, 20.77506000),
(1055404, 1001058, 'HU', 'Emőd', 1, 'emod', 47.93333000, 20.81667000),
(1055405, 1001058, 'HU', 'Encs', 1, 'encs', 48.33333000, 21.13333000),
(1055407, 1001058, 'HU', 'Encsi Járás', 1, 'encsi-jaras', 48.39948000, 21.08169000),
(1055416, 1001058, 'HU', 'Farkaslyuk', 1, 'farkaslyuk', 48.18333000, 20.31667000),
(1055426, 1001058, 'HU', 'Felsőzsolca', 1, 'felsozsolca', 48.10000000, 20.86667000),
(1055448, 1001058, 'HU', 'Gesztely', 1, 'gesztely', 48.10000000, 20.96667000),
(1055477, 1001058, 'HU', 'Gönc', 1, 'gonc', 48.46667000, 21.28333000),
(1055478, 1001058, 'HU', 'Gönci Járás', 1, 'gonci-jaras', 48.39948000, 21.28307000),
(1055494, 1001058, 'HU', 'Halmaj', 1, 'halmaj', 48.25000000, 21.00000000),
(1055498, 1001058, 'HU', 'Harsány', 1, 'harsany', 47.96667000, 20.75000000),
(1055503, 1001058, 'HU', 'Hejőbába', 1, 'hejobaba', 47.90000000, 20.95000000),
(1055508, 1001058, 'HU', 'Hernádnémeti', 1, 'hernadnemeti', 48.06667000, 20.98333000),
(1055532, 1001058, 'HU', 'Izsófalva', 1, 'izsofalva', 48.30000000, 20.66667000),
(1055540, 1001058, 'HU', 'Járdánháza', 1, 'jardanhaza', 48.15000000, 20.25000000),
(1055569, 1001058, 'HU', 'Karcsa', 1, 'karcsa', 48.31130000, 21.80537000),
(1055575, 1001058, 'HU', 'Kazincbarcika', 1, 'kazincbarcika', 48.25000000, 20.63333000),
(1055576, 1001058, 'HU', 'Kazincbarcikai Járás', 1, 'kazincbarcikai-jaras', 48.26371000, 20.57978000),
(1055718, 1001058, 'HU', 'Mád', 1, 'mad', 48.19442000, 21.28208000),
(1055720, 1001058, 'HU', 'Mályi', 1, 'malyi', 48.01667000, 20.83333000),
(1055686, 1001058, 'HU', 'Megyaszó', 1, 'megyaszo', 48.18333000, 21.05000000),
(1055689, 1001058, 'HU', 'Mezőcsát', 1, 'mezocsat', 47.81667000, 20.91667000),
(1055690, 1001058, 'HU', 'Mezőcsáti Járás', 1, 'mezocsati-jaras', 47.79841000, 20.91693000),
(1055693, 1001058, 'HU', 'Mezőkeresztes', 1, 'mezokeresztes', 47.83333000, 20.70000000),
(1055696, 1001058, 'HU', 'Mezőkövesd', 1, 'mezokovesd', 47.81667000, 20.58333000),
(1055697, 1001058, 'HU', 'Mezőkövesdi Járás', 1, 'mezokovesdi-jaras', 47.84876000, 20.63623000),
(1055701, 1001058, 'HU', 'Mezőzombor', 1, 'mezozombor', 48.15000000, 21.26667000),
(1055705, 1001058, 'HU', 'Miskolc', 1, 'miskolc', 48.10000000, 20.78333000),
(1055706, 1001058, 'HU', 'Miskolci Járás', 1, 'miskolci-jaras', 48.08675000, 20.77353000),
(1055710, 1001058, 'HU', 'Monok', 1, 'monok', 48.21102000, 21.15052000),
(1055737, 1001058, 'HU', 'Múcsony', 1, 'mucsony', 48.26667000, 20.68333000),
(1055769, 1001058, 'HU', 'Nyékládháza', 1, 'nyekladhaza', 47.98333000, 20.83333000),
(1055797, 1001058, 'HU', 'Olaszliszka', 1, 'olaszliszka', 48.25000000, 21.43333000),
(1055798, 1001058, 'HU', 'Onga', 1, 'onga', 48.11667000, 20.91667000),
(1056151, 1001058, 'HU', 'Ónod', 1, 'onod', 48.00000000, 20.91667000),
(1056154, 1001058, 'HU', 'Ózd', 1, 'ozd', 48.21667000, 20.30000000),
(1056155, 1001058, 'HU', 'Ózdi Járás', 1, 'ozdi-jaras', 48.18133000, 20.24874000),
(1055832, 1001058, 'HU', 'Prügy', 1, 'prugy', 48.08333000, 21.25000000),
(1055837, 1001058, 'HU', 'Putnok', 1, 'putnok', 48.30000000, 20.43333000),
(1055838, 1001058, 'HU', 'Putnoki Járás', 1, 'putnoki-jaras', 48.33694000, 20.46384000),
(1055864, 1001058, 'HU', 'Ricse', 1, 'ricse', 48.32565000, 21.97069000),
(1055867, 1001058, 'HU', 'Rudabánya', 1, 'rudabanya', 48.38333000, 20.63333000),
(1055882, 1001058, 'HU', 'Sajóbábony', 1, 'sajobabony', 48.16667000, 20.73333000),
(1055883, 1001058, 'HU', 'Sajókaza', 1, 'sajokaza', 48.28333000, 20.58333000),
(1055884, 1001058, 'HU', 'Sajólád', 1, 'sajolad', 48.05000000, 20.90000000),
(1055888, 1001058, 'HU', 'Sajóörös', 1, 'sajooros', 47.95000000, 21.03333000),
(1055885, 1001058, 'HU', 'Sajószentpéter', 1, 'sajoszentpeter', 48.21667000, 20.71667000),
(1055886, 1001058, 'HU', 'Sajószöged', 1, 'sajoszoged', 47.95000000, 21.00000000),
(1055887, 1001058, 'HU', 'Sajóvámos', 1, 'sajovamos', 48.18171000, 20.83149000),
(1055979, 1001058, 'HU', 'Sály', 1, 'saly', 47.95000000, 20.66667000),
(1055986, 1001058, 'HU', 'Sárospatak', 1, 'sarospatak', 48.32450000, 21.57383000),
(1055987, 1001058, 'HU', 'Sárospataki Járás', 1, 'sarospataki-jaras', 48.29575000, 21.52716000),
(1055994, 1001058, 'HU', 'Sátoraljaújhely', 1, 'satoraljaujhely', 48.39492000, 21.65871000),
(1055995, 1001058, 'HU', 'Sátoraljaújhelyi Járás', 1, 'satoraljaujhelyi-jaras', 48.45898000, 21.54394000),
(1055933, 1001058, 'HU', 'Szendrő', 1, 'szendro', 48.40000000, 20.73333000),
(1055941, 1001058, 'HU', 'Szentistván', 1, 'szentistvan', 47.76667000, 20.66667000),
(1055948, 1001058, 'HU', 'Szerencs', 1, 'szerencs', 48.15993000, 21.20970000),
(1055949, 1001058, 'HU', 'Szerencsi Járás', 1, 'szerencsi-jaras', 48.14929000, 21.16865000),
(1055958, 1001058, 'HU', 'Szikszó', 1, 'szikszo', 48.20000000, 20.93333000),
(1055959, 1001058, 'HU', 'Szikszói Járás', 1, 'szikszoi-jaras', 48.30032000, 20.95507000),
(1055961, 1001058, 'HU', 'Szirmabesenyő', 1, 'szirmabesenyo', 48.15000000, 20.80000000),
(1056005, 1001058, 'HU', 'Taktaharkány', 1, 'taktaharkany', 48.08333000, 21.13333000),
(1056006, 1001058, 'HU', 'Taktaszada', 1, 'taktaszada', 48.11667000, 21.18333000),
(1056062, 1001058, 'HU', 'Tállya', 1, 'tallya', 48.23333000, 21.23333000),
(1056012, 1001058, 'HU', 'Tarcal', 1, 'tarcal', 48.13333000, 21.35000000),
(1056033, 1001058, 'HU', 'Tiszakarád', 1, 'tiszakarad', 48.20000000, 21.71667000),
(1056034, 1001058, 'HU', 'Tiszakeszi', 1, 'tiszakeszi', 47.78333000, 21.00000000),
(1056038, 1001058, 'HU', 'Tiszalúc', 1, 'tiszaluc', 48.03774000, 21.07261000),
(1056048, 1001058, 'HU', 'Tiszaújváros', 1, 'tiszaujvaros', 47.93333000, 21.08333000),
(1056049, 1001058, 'HU', 'Tiszaújvárosi Járás', 1, 'tiszaujvarosi-jaras', 47.92656000, 20.99321000),
(1056050, 1001058, 'HU', 'Tokaj', 1, 'tokaj', 48.11667000, 21.41667000),
(1056051, 1001058, 'HU', 'Tokaji Járás', 1, 'tokaji-jaras', 48.14014000, 21.37002000),
(1056052, 1001058, 'HU', 'Tolcsva', 1, 'tolcsva', 48.28333000, 21.45000000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001064, 'HU', 'Budapest', 1, 'budapest');

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 
(1055263, 1001064, 'HU', 'Budapest', 1, 'budapest', 47.49835000, 19.04045000),
(1055264, 1001064, 'HU', 'Budapest I. kerület', 1, 'budapest-i-kerulet', 47.49705000, 19.03961000),
(1055265, 1001064, 'HU', 'Budapest II. kerület', 1, 'budapest-ii-kerulet', 47.51984000, 19.02218000),
(1055266, 1001064, 'HU', 'Budapest III. kerület', 1, 'budapest-iii-kerulet', 47.54157000, 19.04501000),
(1055267, 1001064, 'HU', 'Budapest IV. kerület', 1, 'budapest-iv-kerulet', 47.56182000, 19.08909000),
(1055268, 1001064, 'HU', 'Budapest VI. kerület', 1, 'budapest-vi-kerulet', 47.50369000, 19.06583000),
(1055269, 1001064, 'HU', 'Budapest VIII. kerület', 1, 'budapest-viii-kerulet', 47.48919000, 19.07012000),
(1055270, 1001064, 'HU', 'Budapest X. kerület', 1, 'budapest-x-kerulet', 47.47910000, 19.15835000),
(1055271, 1001064, 'HU', 'Budapest XI. kerület', 1, 'budapest-xi-kerulet', 47.47603000, 19.03605000),
(1055272, 1001064, 'HU', 'Budapest XII. kerület', 1, 'budapest-xii-kerulet', 47.49192000, 19.01493000),
(1055273, 1001064, 'HU', 'Budapest XIII. kerület', 1, 'budapest-xiii-kerulet', 47.52978000, 19.08068000),
(1055274, 1001064, 'HU', 'Budapest XV. kerület', 1, 'budapest-xv-kerulet', 47.56263000, 19.11681000),
(1055275, 1001064, 'HU', 'Budapest XVI. kerület', 1, 'budapest-xvi-kerulet', 47.51482000, 19.17028000),
(1055276, 1001064, 'HU', 'Budapest XVII. kerület', 1, 'budapest-xvii-kerulet', 47.47997000, 19.25388000),
(1055277, 1001064, 'HU', 'Budapest XVIII. kerület', 1, 'budapest-xviii-kerulet', 47.44417000, 19.17595000),
(1055278, 1001064, 'HU', 'Budapest XX. kerület', 1, 'budapest-xx-kerulet', 47.43674000, 19.10093000),
(1055279, 1001064, 'HU', 'Budapest XXI. kerület', 1, 'budapest-xxi-kerulet', 47.43047000, 19.07098000),
(1055280, 1001064, 'HU', 'Budapest XXII. kerület', 1, 'budapest-xxii-kerulet', 47.42698000, 19.04016000),
(1055281, 1001064, 'HU', 'Budapest XXIII. kerület', 1, 'budapest-xxiii-kerulet', 47.39788000, 19.11492000),
(1055413, 1001064, 'HU', 'Erzsébetváros', 1, 'erzsebetvaros', 47.50207000, 19.07218000),
(1055554, 1001064, 'HU', 'Józsefváros', 1, 'jozsefvaros', 47.48938000, 19.07292000),
(1055607, 1001064, 'HU', 'Kispest', 1, 'kispest', 47.45150000, 19.14017000),
(1056133, 1001064, 'HU', 'Zugló', 1, 'zuglo', 47.51758000, 19.10549000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001031, 'HU', 'Csongrád County', 1, 'csongrad-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 
(1055184, 1001031, 'HU', 'Algyő', 1, 'algyo', 46.33472000, 20.20849000),
(1055192, 1001031, 'HU', 'Apátfalva', 1, 'apatfalva', 46.16667000, 20.58333000),
(1056143, 1001031, 'HU', 'Ásotthalom', 1, 'asotthalom', 46.19875000, 19.78334000),
(1055207, 1001031, 'HU', 'Baks', 1, 'baks', 46.54297000, 20.10213000),
(1055228, 1001031, 'HU', 'Balástya', 1, 'balastya', 46.42277000, 20.00816000),
(1055257, 1001031, 'HU', 'Bordány', 1, 'bordany', 46.31843000, 19.92306000),
(1055326, 1001031, 'HU', 'Csanádpalota', 1, 'csanadpalota', 46.25000000, 20.73333000),
(1055324, 1001031, 'HU', 'Csanytelek', 1, 'csanytelek', 46.59501000, 20.12342000),
(1055328, 1001031, 'HU', 'Csengele', 1, 'csengele', 46.54234000, 19.86358000),
(1055337, 1001031, 'HU', 'Csongrád', 1, 'csongrad', 46.71332000, 20.14241000),
(1055338, 1001031, 'HU', 'Csongrádi Járás', 1, 'csongradi-jaras', 46.66146000, 20.08792000),
(1055359, 1001031, 'HU', 'Deszk', 1, 'deszk', 46.21802000, 20.24322000),
(1055365, 1001031, 'HU', 'Domaszék', 1, 'domaszek', 46.24917000, 20.01111000),
(1055434, 1001031, 'HU', 'Fábiánsebestyén', 1, 'fabiansebestyen', 46.68333000, 20.46667000),
(1055438, 1001031, 'HU', 'Földeák', 1, 'foldeak', 46.31667000, 20.50000000),
(1055432, 1001031, 'HU', 'Forráskút', 1, 'forraskut', 46.36528000, 19.90973000),
(1055521, 1001031, 'HU', 'Hódmezővásárhely', 1, 'hodmezovasarhely', 46.41667000, 20.33333000),
(1055522, 1001031, 'HU', 'Hódmezővásárhelyi Járás', 1, 'hodmezovasarhelyi-jaras', 46.43301000, 20.37598000),
(1055610, 1001031, 'HU', 'Kistelek', 1, 'kistelek', 46.47250000, 19.97972000),
(1055611, 1001031, 'HU', 'Kisteleki Járás', 1, 'kisteleki-jaras', 46.48835000, 19.99568000),
(1055614, 1001031, 'HU', 'Kiszombor', 1, 'kiszombor', 46.18333000, 20.43333000),
(1055677, 1001031, 'HU', 'Makó', 1, 'mako', 46.21667000, 20.48333000),
(1055678, 1001031, 'HU', 'Makói Járás', 1, 'makoi-jaras', 46.26698000, 20.54200000),
(1055681, 1001031, 'HU', 'Maroslele', 1, 'maroslele', 46.26667000, 20.35000000),
(1055704, 1001031, 'HU', 'Mindszent', 1, 'mindszent', 46.52362000, 20.19038000),
(1055734, 1001031, 'HU', 'Mórahalmi Járás', 1, 'morahalmi-jaras', 46.26840000, 19.82256000),
(1055735, 1001031, 'HU', 'Mórahalom', 1, 'morahalom', 46.21806000, 19.88510000),
(1056152, 1001031, 'HU', 'Ópusztaszer', 1, 'opusztaszer', 46.48592000, 20.08722000),
(1055835, 1001031, 'HU', 'Pusztaszer', 1, 'pusztaszer', 46.55083000, 19.98823000),
(1055881, 1001031, 'HU', 'Röszke', 1, 'roszke', 46.18796000, 20.03372000),
(1055868, 1001031, 'HU', 'Ruzsa', 1, 'ruzsa', 46.28806000, 19.74714000),
(1055980, 1001031, 'HU', 'Sándorfalva', 1, 'sandorfalva', 46.36087000, 20.09889000),
(1055923, 1001031, 'HU', 'Szatymaz', 1, 'szatymaz', 46.34306000, 20.04020000),
(1055925, 1001031, 'HU', 'Szeged', 1, 'szeged', 46.25300000, 20.14824000),
(1055926, 1001031, 'HU', 'Szegedi Járás', 1, 'szegedi-jaras', 46.29536000, 20.13758000),
(1055929, 1001031, 'HU', 'Szegvár', 1, 'szegvar', 46.58740000, 20.22408000),
(1055976, 1001031, 'HU', 'Székkutas', 1, 'szekkutas', 46.50000000, 20.53333000),
(1055936, 1001031, 'HU', 'Szentes', 1, 'szentes', 46.65834000, 20.26080000),
(1055937, 1001031, 'HU', 'Szentesi Járás', 1, 'szentesi-jaras', 46.66005000, 20.37314000),
(1056081, 1001031, 'HU', 'Tömörkény', 1, 'tomorkeny', 46.61716000, 20.04357000),
(1056167, 1001031, 'HU', 'Üllés', 1, 'ulles', 46.33611000, 19.84454000),
(1056136, 1001031, 'HU', 'Zákányszék', 1, 'zakanyszek', 46.27453000, 19.88975000),
(1056130, 1001031, 'HU', 'Zsombó', 1, 'zsombo', 46.32566000, 19.97464000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001032, 'HU', 'Debrecen', 1, 'debrecen');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001049, 'HU', 'Dunaújváros', 1, 'dunaujvaros');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001037, 'HU', 'Eger', 1, 'eger');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001028, 'HU', 'Érd', 1, 'erd');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001044, 'HU', 'Fejér County', 1, 'fejer-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 
(1055168, 1001044, 'HU', 'Aba', 1, 'aba', 47.02907000, 18.52172000),
(1055175, 1001044, 'HU', 'Adony', 1, 'adony', 47.11940000, 18.86493000),
(1055181, 1001044, 'HU', 'Alap', 1, 'alap', 46.79915000, 18.68938000),
(1055205, 1001044, 'HU', 'Bakonycsernye', 1, 'bakonycsernye', 47.32395000, 18.07509000),
(1055229, 1001044, 'HU', 'Baracs', 1, 'baracs', 46.88202000, 18.90658000),
(1055230, 1001044, 'HU', 'Baracska', 1, 'baracska', 47.28225000, 18.75853000),
(1055246, 1001044, 'HU', 'Bicske', 1, 'bicske', 47.48419000, 18.64404000),
(1055247, 1001044, 'HU', 'Bicskei Járás', 1, 'bicskei-jaras', 47.43380000, 18.56757000),
(1055250, 1001044, 'HU', 'Bodajk', 1, 'bodajk', 47.32352000, 18.23312000),
(1055314, 1001044, 'HU', 'Cece', 1, 'cece', 46.77056000, 18.62826000),
(1055345, 1001044, 'HU', 'Csákvár', 1, 'csakvar', 47.39184000, 18.46501000),
(1055387, 1001044, 'HU', 'Dég', 1, 'deg', 46.86807000, 18.45042000),
(1056139, 1001044, 'HU', 'dunaújváros', 1, 'dunaujvaros', 46.96737000, 18.93288000),
(1055382, 1001044, 'HU', 'Dunaújvárosi Járás', 1, 'dunaujvarosi-jaras', 47.02801000, 18.82997000),
(1055403, 1001044, 'HU', 'Előszállás', 1, 'eloszallas', 46.83094000, 18.83481000),
(1055408, 1001044, 'HU', 'Enying', 1, 'enying', 46.93046000, 18.24202000),
(1055409, 1001044, 'HU', 'Enyingi Járás', 1, 'enyingi-jaras', 46.87240000, 18.30975000),
(1055410, 1001044, 'HU', 'Ercsi', 1, 'ercsi', 47.25194000, 18.89623000),
(1055414, 1001044, 'HU', 'Etyek', 1, 'etyek', 47.44794000, 18.75328000),
(1055422, 1001044, 'HU', 'Fehérvárcsurgó', 1, 'fehervarcsurgo', 47.29349000, 18.26460000),
(1055471, 1001044, 'HU', 'Gárdony', 1, 'gardony', 47.20942000, 18.63607000),
(1055472, 1001044, 'HU', 'Gárdonyi Járás', 1, 'gardonyi-jaras', 47.22785000, 18.63622000),
(1055530, 1001044, 'HU', 'Iváncsa', 1, 'ivancsa', 47.15670000, 18.82030000),
(1055638, 1001044, 'HU', 'Káloz', 1, 'kaloz', 46.95464000, 18.48259000),
(1055640, 1001044, 'HU', 'Kápolnásnyék', 1, 'kapolnasnyek', 47.24004000, 18.67564000),
(1055593, 1001044, 'HU', 'Kincsesbánya', 1, 'kincsesbanya', 47.26444000, 18.27790000),
(1055604, 1001044, 'HU', 'Kisláng', 1, 'kislang', 46.95744000, 18.38813000),
(1055653, 1001044, 'HU', 'Lajoskomárom', 1, 'lajoskomarom', 46.84201000, 18.33763000),
(1055659, 1001044, 'HU', 'Lepsény', 1, 'lepseny', 46.99036000, 18.24357000),
(1055665, 1001044, 'HU', 'Lovasberény', 1, 'lovasbereny', 47.30997000, 18.55177000),
(1055722, 1001044, 'HU', 'Mány', 1, 'many', 47.53352000, 18.65627000),
(1055682, 1001044, 'HU', 'Martonvásár', 1, 'martonvasar', 47.31601000, 18.79045000),
(1055683, 1001044, 'HU', 'Martonvásári Járás', 1, 'martonvasari-jaras', 47.29040000, 18.79945000),
(1055691, 1001044, 'HU', 'Mezőfalva', 1, 'mezofalva', 46.93184000, 18.77177000),
(1055698, 1001044, 'HU', 'Mezőszilas', 1, 'mezoszilas', 46.81109000, 18.47789000),
(1055733, 1001044, 'HU', 'Mór', 1, 'mor', 47.37787000, 18.20353000),
(1055736, 1001044, 'HU', 'Móri Járás', 1, 'mori-jaras', 47.34685000, 18.19838000),
(1055839, 1001044, 'HU', 'Pákozd', 1, 'pakozd', 47.21369000, 18.53306000),
(1055848, 1001044, 'HU', 'Pázmánd', 1, 'pazmand', 47.28755000, 18.65356000),
(1055814, 1001044, 'HU', 'Perkáta', 1, 'perkata', 47.04701000, 18.78734000),
(1055828, 1001044, 'HU', 'Polgárdi', 1, 'polgardi', 47.06099000, 18.30200000),
(1055834, 1001044, 'HU', 'Pusztaszabolcs', 1, 'pusztaszabolcs', 47.13718000, 18.76704000),
(1055836, 1001044, 'HU', 'Pusztavám', 1, 'pusztavam', 47.42948000, 18.22648000),
(1055870, 1001044, 'HU', 'Rácalmás', 1, 'racalmas', 47.02263000, 18.94056000),
(1055871, 1001044, 'HU', 'Ráckeresztúr', 1, 'rackeresztur', 47.27360000, 18.83343000),
(1055981, 1001044, 'HU', 'Sárbogárd', 1, 'sarbogard', 46.88692000, 18.62041000),
(1055982, 1001044, 'HU', 'Sárbogárdi Járás', 1, 'sarbogardi-jaras', 46.84036000, 18.60723000),
(1055983, 1001044, 'HU', 'Sárkeresztúr', 1, 'sarkeresztur', 47.00540000, 18.54391000),
(1055985, 1001044, 'HU', 'Sárosd', 1, 'sarosd', 47.04273000, 18.64357000),
(1055989, 1001044, 'HU', 'Sárszentmihály', 1, 'sarszentmihaly', 47.15321000, 18.33879000),
(1055896, 1001044, 'HU', 'Seregélyes', 1, 'seregelyes', 47.11050000, 18.56500000),
(1055908, 1001044, 'HU', 'Soponya', 1, 'soponya', 47.01485000, 18.45343000),
(1055911, 1001044, 'HU', 'Szabadbattyán', 1, 'szabadbattyan', 47.11902000, 18.36823000),
(1055969, 1001044, 'HU', 'Szárliget', 1, 'szarliget', 47.51581000, 18.49480000),
(1055974, 1001044, 'HU', 'Székesfehérvár', 1, 'szekesfehervar', 47.18995000, 18.41034000),
(1055975, 1001044, 'HU', 'Székesfehérvári Járás', 1, 'szekesfehervari-jaras', 47.16531000, 18.41349000),
(1056108, 1001044, 'HU', 'Vál', 1, 'val', 47.36264000, 18.67931000),
(1056096, 1001044, 'HU', 'Velence', 1, 'velence', 47.23855000, 18.65484000),
(1056137, 1001044, 'HU', 'Zámoly', 1, 'zamoly', 47.31667000, 18.40810000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001041, 'HU', 'Győr', 1, 'gyor');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001042, 'HU', 'Győr-Moson-Sopron County', 1, 'gyor-moson-sopron-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 
(1055171, 1001042, 'HU', 'Abda', 1, 'abda', 47.69464000, 17.54489000),
(1056142, 1001042, 'HU', 'Ágfalva', 1, 'agfalva', 47.68991000, 16.51658000),
(1056144, 1001042, 'HU', 'Ásványráró', 1, 'asvanyraro', 47.82733000, 17.49418000),
(1055206, 1001042, 'HU', 'Bakonyszentlászló', 1, 'bakonyszentlaszlo', 47.38901000, 17.80321000),
(1055236, 1001042, 'HU', 'Beled', 1, 'beled', 47.46594000, 17.09294000),
(1055312, 1001042, 'HU', 'Bőny', 1, 'bony', 47.65000000, 17.86977000),
(1055313, 1001042, 'HU', 'Bősárkány', 1, 'bosarkany', 47.68821000, 17.25000000),
(1055340, 1001042, 'HU', 'Csorna', 1, 'csorna', 47.61155000, 17.25012000),
(1055341, 1001042, 'HU', 'Csornai Járás', 1, 'csornai-jaras', 47.58403000, 17.26041000),
(1055418, 1001042, 'HU', 'Farád', 1, 'farad', 47.60633000, 17.20024000),
(1055427, 1001042, 'HU', 'Fertőd', 1, 'fertod', 47.62173000, 16.87088000),
(1055428, 1001042, 'HU', 'Fertőrákos', 1, 'fertorakos', 47.72017000, 16.65040000),
(1055429, 1001042, 'HU', 'Fertőszentmiklós', 1, 'fertoszentmiklos', 47.58996000, 16.87517000),
(1055466, 1001042, 'HU', 'Győr', 1, 'gyor', 47.68333000, 17.63512000),
(1055467, 1001042, 'HU', 'Győri Járás', 1, 'gyori-jaras', 47.67273000, 17.67936000),
(1055468, 1001042, 'HU', 'Győrszemere', 1, 'gyorszemere', 47.55256000, 17.56356000),
(1055469, 1001042, 'HU', 'Győrújbarát', 1, 'gyorujbarat', 47.60643000, 17.64875000),
(1055495, 1001042, 'HU', 'Halászi', 1, 'halaszi', 47.88930000, 17.32615000),
(1055539, 1001042, 'HU', 'Jánossomorja', 1, 'janossomorja', 47.78621000, 17.13603000),
(1055563, 1001042, 'HU', 'Kapuvár', 1, 'kapuvar', 47.59224000, 17.02886000),
(1055564, 1001042, 'HU', 'Kapuvári Járás', 1, 'kapuvari-jaras', 47.56705000, 17.04056000),
(1055592, 1001042, 'HU', 'Kimle', 1, 'kimle', 47.81726000, 17.36642000),
(1055645, 1001042, 'HU', 'Kóny', 1, 'kony', 47.63053000, 17.35717000),
(1055668, 1001042, 'HU', 'Lébény', 1, 'lebeny', 47.73574000, 17.39076000),
(1055702, 1001042, 'HU', 'Mihályi', 1, 'mihalyi', 47.51384000, 17.09507000),
(1055714, 1001042, 'HU', 'Mosonmagyaróvár', 1, 'mosonmagyarovar', 47.86789000, 17.26994000),
(1055715, 1001042, 'HU', 'Mosonmagyaróvári Járás', 1, 'mosonmagyarovari-jaras', 47.85767000, 17.28212000),
(1055716, 1001042, 'HU', 'Mosonszentmiklós', 1, 'mosonszentmiklos', 47.72778000, 17.42784000),
(1055742, 1001042, 'HU', 'Nagycenk', 1, 'nagycenk', 47.60435000, 16.69732000),
(1055793, 1001042, 'HU', 'Nyúl', 1, 'nyul', 47.59047000, 17.68904000),
(1056159, 1001042, 'HU', 'Öttevény', 1, 'otteveny', 47.71946000, 17.48474000),
(1055808, 1001042, 'HU', 'Pannonhalma', 1, 'pannonhalma', 47.54946000, 17.75535000),
(1055809, 1001042, 'HU', 'Pannonhalmi Járás', 1, 'pannonhalmi-jaras', 47.45571000, 17.81335000),
(1055854, 1001042, 'HU', 'Pér', 1, 'per', 47.61153000, 17.80632000),
(1055869, 1001042, 'HU', 'Rábapatona', 1, 'rabapatona', 47.63224000, 17.48004000),
(1055861, 1001042, 'HU', 'Rajka', 1, 'rajka', 47.99643000, 17.19821000),
(1055909, 1001042, 'HU', 'Sopron', 1, 'sopron', 47.68501000, 16.59049000),
(1055910, 1001042, 'HU', 'Soproni Járás', 1, 'soproni-jaras', 47.60385000, 16.75654000),
(1055920, 1001042, 'HU', 'Szany', 1, 'szany', 47.46423000, 17.30402000),
(1056074, 1001042, 'HU', 'Tét', 1, 'tet', 47.51922000, 17.50802000),
(1056075, 1001042, 'HU', 'Téti Járás', 1, 'teti-jaras', 47.51515000, 17.51612000),
(1056080, 1001042, 'HU', 'Töltéstava', 1, 'toltestava', 47.62609000, 17.73376000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001063, 'HU', 'Hajdú-Bihar County', 1, 'hajdu-bihar-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 
(1055202, 1001063, 'HU', 'Bagamér', 1, 'bagamer', 47.44882000, 21.98900000),
(1055226, 1001063, 'HU', 'Balmazújváros', 1, 'balmazujvaros', 47.61667000, 21.35000000),
(1055227, 1001063, 'HU', 'Balmazújvárosi Járás', 1, 'balmazujvarosi-jaras', 47.61840000, 21.14882000),
(1055290, 1001063, 'HU', 'Báránd', 1, 'barand', 47.30000000, 21.23333000),
(1055239, 1001063, 'HU', 'Berettyóújfalu', 1, 'berettyoujfalu', 47.21667000, 21.55000000),
(1055240, 1001063, 'HU', 'Berettyóújfalui Járás', 1, 'berettyoujfalui-jaras', 47.14109000, 21.55233000),
(1055248, 1001063, 'HU', 'Biharkeresztes', 1, 'biharkeresztes', 47.13333000, 21.71667000),
(1055249, 1001063, 'HU', 'Biharnagybajom', 1, 'biharnagybajom', 47.21667000, 21.23333000),
(1055349, 1001063, 'HU', 'Csökmő', 1, 'csokmo', 47.03333000, 21.30000000),
(1055353, 1001063, 'HU', 'Debrecen', 1, 'debrecen', 47.53333000, 21.63333000),
(1055354, 1001063, 'HU', 'Debreceni Járás', 1, 'debreceni-jaras', 47.52706000, 21.66869000),
(1055357, 1001063, 'HU', 'Derecske', 1, 'derecske', 47.35000000, 21.56667000),
(1055358, 1001063, 'HU', 'Derecskei Járás', 1, 'derecskei-jaras', 47.38194000, 21.74836000),
(1055393, 1001063, 'HU', 'Ebes', 1, 'ebes', 47.46667000, 21.50000000),
(1055401, 1001063, 'HU', 'Egyek', 1, 'egyek', 47.63333000, 20.90000000),
(1055437, 1001063, 'HU', 'Földes', 1, 'foldes', 47.30000000, 21.36667000),
(1055479, 1001063, 'HU', 'Görbeháza', 1, 'gorbehaza', 47.83333000, 21.23333000),
(1055480, 1001063, 'HU', 'Hadjúszoboszlói Járás', 1, 'hadjuszoboszloi-jaras', 47.48110000, 21.31000000),
(1055481, 1001063, 'HU', 'Hajdúbagos', 1, 'hajdubagos', 47.39295000, 21.66551000),
(1055482, 1001063, 'HU', 'Hajdúböszörmény', 1, 'hajduboszormeny', 47.66667000, 21.51667000),
(1055483, 1001063, 'HU', 'Hajdúböszörményi Járás', 1, 'hajduboszormenyi-jaras', 47.74000000, 21.50000000),
(1055484, 1001063, 'HU', 'Hajdúdorog', 1, 'hajdudorog', 47.81667000, 21.50000000),
(1055485, 1001063, 'HU', 'Hajdúhadház', 1, 'hajduhadhaz', 47.68333000, 21.66667000),
(1055486, 1001063, 'HU', 'Hajdúhadházi Járás', 1, 'hajduhadhazi-jaras', 47.67000000, 21.70000000),
(1055487, 1001063, 'HU', 'Hajdúnánás', 1, 'hajdunanas', 47.85000000, 21.43333000),
(1055488, 1001063, 'HU', 'Hajdúnánási Járás', 1, 'hajdunanasi-jaras', 47.83350000, 21.25256000),
(1055491, 1001063, 'HU', 'Hajdúsámson', 1, 'hajdusamson', 47.60000000, 21.76667000),
(1055489, 1001063, 'HU', 'Hajdúszoboszló', 1, 'hajduszoboszlo', 47.45000000, 21.40000000),
(1055490, 1001063, 'HU', 'Hajdúszovát', 1, 'hajduszovat', 47.38333000, 21.48333000),
(1055515, 1001063, 'HU', 'Hortobágy', 1, 'hortobagy', 47.58278000, 21.15108000),
(1055517, 1001063, 'HU', 'Hosszúpályi', 1, 'hosszupalyi', 47.39303000, 21.73280000),
(1055555, 1001063, 'HU', 'Kaba', 1, 'kaba', 47.35000000, 21.28333000),
(1055621, 1001063, 'HU', 'Komádi', 1, 'komadi', 47.00000000, 21.50000000),
(1055623, 1001063, 'HU', 'Konyár', 1, 'konyar', 47.31667000, 21.66667000),
(1055669, 1001063, 'HU', 'Létavértes', 1, 'letavertes', 47.38333000, 21.90000000),
(1055703, 1001063, 'HU', 'Mikepércs', 1, 'mikepercs', 47.45000000, 21.63333000),
(1055713, 1001063, 'HU', 'Monostorpályi', 1, 'monostorpalyi', 47.40000000, 21.78333000),
(1055794, 1001063, 'HU', 'Nádudvar', 1, 'nadudvar', 47.41667000, 21.16667000),
(1055760, 1001063, 'HU', 'Nagyrábé', 1, 'nagyrabe', 47.20000000, 21.33333000),
(1055792, 1001063, 'HU', 'Nyírábrány', 1, 'nyirabrany', 47.55311000, 22.02401000),
(1055770, 1001063, 'HU', 'Nyíracsád', 1, 'nyiracsad', 47.60330000, 21.97208000),
(1055771, 1001063, 'HU', 'Nyíradony', 1, 'nyiradony', 47.69746000, 21.91878000),
(1055772, 1001063, 'HU', 'Nyíradonyi Járás', 1, 'nyiradonyi-jaras', 47.57873000, 22.01381000),
(1055787, 1001063, 'HU', 'Nyírmártonfalva', 1, 'nyirmartonfalva', 47.58333000, 21.90000000),
(1055826, 1001063, 'HU', 'Pocsaj', 1, 'pocsaj', 47.28333000, 21.81667000),
(1055827, 1001063, 'HU', 'Polgár', 1, 'polgar', 47.86667000, 21.11667000),
(1055859, 1001063, 'HU', 'Püspökladány', 1, 'puspokladany', 47.31667000, 21.11667000),
(1055860, 1001063, 'HU', 'Püspökladányi Járás', 1, 'puspokladanyi-jaras', 47.31279000, 21.21177000),
(1055992, 1001063, 'HU', 'Sáránd', 1, 'sarand', 47.40000000, 21.63333000),
(1055988, 1001063, 'HU', 'Sárrétudvari', 1, 'sarretudvari', 47.23333000, 21.20000000),
(1056073, 1001063, 'HU', 'Téglás', 1, 'teglas', 47.71667000, 21.68333000),
(1056026, 1001063, 'HU', 'Tiszacsege', 1, 'tiszacsege', 47.70000000, 21.00000000),
(1056110, 1001063, 'HU', 'Vámospércs', 1, 'vamospercs', 47.53333000, 21.90000000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001040, 'HU', 'Heves County', 1, 'heves-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 
(1055169, 1001040, 'HU', 'Abasár', 1, 'abasar', 47.79705000, 20.00324000),
(1055176, 1001040, 'HU', 'Adács', 1, 'adacs', 47.69210000, 19.97696000),
(1055188, 1001040, 'HU', 'Andornaktálya', 1, 'andornaktalya', 47.85000000, 20.41667000),
(1055190, 1001040, 'HU', 'Apc', 1, 'apc', 47.79419000, 19.69429000),
(1055302, 1001040, 'HU', 'Bélapátfalva', 1, 'belapatfalva', 48.05000000, 20.36667000),
(1055303, 1001040, 'HU', 'Bélapátfalvai Járás', 1, 'belapatfalvai-jaras', 48.06386000, 20.36163000),
(1055244, 1001040, 'HU', 'Besenyőtelek', 1, 'besenyotelek', 47.70000000, 20.43333000),
(1055253, 1001040, 'HU', 'Boldog', 1, 'boldog', 47.60285000, 19.68839000),
(1055346, 1001040, 'HU', 'Csány', 1, 'csany', 47.64829000, 19.82972000),
(1055371, 1001040, 'HU', 'Domoszló', 1, 'domoszlo', 47.83333000, 20.11667000),
(1055395, 1001040, 'HU', 'Ecséd', 1, 'ecsed', 47.73267000, 19.76696000),
(1055398, 1001040, 'HU', 'Eger', 1, 'eger', 47.90265000, 20.37329000),
(1055399, 1001040, 'HU', 'Egerszalók', 1, 'egerszalok', 47.86667000, 20.33333000),
(1055400, 1001040, 'HU', 'Egri Járás', 1, 'egri-jaras', 47.92961000, 20.37383000),
(1055412, 1001040, 'HU', 'Erdőtelek', 1, 'erdotelek', 47.68333000, 20.31667000),
(1055425, 1001040, 'HU', 'Felsőtárkány', 1, 'felsotarkany', 47.96667000, 20.41667000),
(1055441, 1001040, 'HU', 'Füzesabony', 1, 'fuzesabony', 47.75000000, 20.41667000),
(1055442, 1001040, 'HU', 'Füzesabonyi Járás', 1, 'fuzesabonyi-jaras', 47.72671000, 20.42875000),
(1055459, 1001040, 'HU', 'Gyöngyös', 1, 'gyongyos', 47.78257000, 19.92800000),
(1055460, 1001040, 'HU', 'Gyöngyöshalász', 1, 'gyongyoshalasz', 47.74161000, 19.92876000),
(1055461, 1001040, 'HU', 'Gyöngyösi Járás', 1, 'gyongyosi-jaras', 47.79079000, 19.95430000),
(1055462, 1001040, 'HU', 'Gyöngyöspata', 1, 'gyongyospata', 47.81505000, 19.78925000),
(1055463, 1001040, 'HU', 'Gyöngyössolymos', 1, 'gyongyossolymos', 47.81724000, 19.93619000),
(1055464, 1001040, 'HU', 'Gyöngyöstarján', 1, 'gyongyostarjan', 47.81369000, 19.86724000),
(1055500, 1001040, 'HU', 'Hatvan', 1, 'hatvan', 47.66667000, 19.68333000),
(1055501, 1001040, 'HU', 'Hatvani Járás', 1, 'hatvani-jaras', 47.69468000, 19.72852000),
(1055509, 1001040, 'HU', 'Heréd', 1, 'hered', 47.70638000, 19.63314000),
(1055510, 1001040, 'HU', 'Heves', 1, 'heves', 47.60000000, 20.28333000),
(1055511, 1001040, 'HU', 'Hevesi Járás', 1, 'hevesi-jaras', 47.61535000, 20.31739000),
(1055514, 1001040, 'HU', 'Hort', 1, 'hort', 47.69081000, 19.78930000),
(1055635, 1001040, 'HU', 'Kál', 1, 'kal', 47.73333000, 20.26667000),
(1055571, 1001040, 'HU', 'Karácsond', 1, 'karacsond', 47.72962000, 20.03076000),
(1055586, 1001040, 'HU', 'Kerecsend', 1, 'kerecsend', 47.80000000, 20.35000000),
(1055601, 1001040, 'HU', 'Kisköre', 1, 'kiskore', 47.50000000, 20.50000000),
(1055620, 1001040, 'HU', 'Kompolt', 1, 'kompolt', 47.73333000, 20.25000000),
(1055671, 1001040, 'HU', 'Lőrinci', 1, 'lorinci', 47.73295000, 19.67867000),
(1055676, 1001040, 'HU', 'Maklár', 1, 'maklar', 47.80000000, 20.41667000),
(1055724, 1001040, 'HU', 'Mátraderecske', 1, 'matraderecske', 47.95000000, 20.08333000),
(1055761, 1001040, 'HU', 'Nagyréde', 1, 'nagyrede', 47.76543000, 19.84819000),
(1055802, 1001040, 'HU', 'Ostoros', 1, 'ostoros', 47.86667000, 20.43333000),
(1055810, 1001040, 'HU', 'Parád', 1, 'parad', 47.92323000, 20.02972000),
(1055811, 1001040, 'HU', 'Parádsasvár', 1, 'paradsasvar', 47.91260000, 19.97709000),
(1055856, 1001040, 'HU', 'Pétervására', 1, 'petervasara', 48.01667000, 20.10000000),
(1055857, 1001040, 'HU', 'Pétervásárai Járás', 1, 'petervasarai-jaras', 48.00589000, 20.09466000),
(1055816, 1001040, 'HU', 'Petőfibánya', 1, 'petofibanya', 47.76960000, 19.69988000),
(1055831, 1001040, 'HU', 'Poroszló', 1, 'poroszlo', 47.65000000, 20.66667000),
(1055863, 1001040, 'HU', 'Recsk', 1, 'recsk', 47.93333000, 20.11667000),
(1055880, 1001040, 'HU', 'Rózsaszentmárton', 1, 'rozsaszentmarton', 47.78200000, 19.74210000),
(1055900, 1001040, 'HU', 'Sirok', 1, 'sirok', 47.93333000, 20.20000000),
(1055957, 1001040, 'HU', 'Szihalom', 1, 'szihalom', 47.76667000, 20.48333000),
(1055960, 1001040, 'HU', 'Szilvásvárad', 1, 'szilvasvarad', 48.10000000, 20.40000000),
(1056013, 1001040, 'HU', 'Tarnalelesz', 1, 'tarnalelesz', 48.05000000, 20.18333000),
(1056014, 1001040, 'HU', 'Tarnaörs', 1, 'tarnaors', 47.59499000, 20.05254000),
(1056040, 1001040, 'HU', 'Tiszanána', 1, 'tiszanana', 47.56667000, 20.53333000),
(1056109, 1001040, 'HU', 'Vámosgyörk', 1, 'vamosgyork', 47.68429000, 19.92924000),
(1056098, 1001040, 'HU', 'Verpelét', 1, 'verpelet', 47.85000000, 20.23333000),
(1056119, 1001040, 'HU', 'Zagyvaszántó', 1, 'zagyvaszanto', 47.77703000, 19.67092000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001027, 'HU', 'Hódmezővásárhely', 1, 'hodmezovasarhely');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001043, 'HU', 'Jász-Nagykun-Szolnok County', 1, 'jasz-nagykun-szolnok-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 
(1055173, 1001043, 'HU', 'Abádszalók', 1, 'abadszalok', 47.46667000, 20.60000000),
(1055182, 1001043, 'HU', 'Alattyán', 1, 'alattyan', 47.42705000, 20.04219000),
(1055243, 1001043, 'HU', 'Besenyszög', 1, 'besenyszog', 47.30000000, 20.26667000),
(1055320, 1001043, 'HU', 'Cibakháza', 1, 'cibakhaza', 46.95976000, 20.19753000),
(1055333, 1001043, 'HU', 'Cserkeszőlő', 1, 'cserkeszolo', 46.86320000, 20.18701000),
(1055419, 1001043, 'HU', 'Fegyvernek', 1, 'fegyvernek', 47.26667000, 20.53333000),
(1055537, 1001043, 'HU', 'Jánoshida', 1, 'janoshida', 47.38333000, 20.06667000),
(1055541, 1001043, 'HU', 'Jászalsószentgyörgy', 1, 'jaszalsoszentgyorgy', 47.36667000, 20.10000000),
(1055542, 1001043, 'HU', 'Jászapáti', 1, 'jaszapati', 47.51667000, 20.15000000),
(1055543, 1001043, 'HU', 'Jászapáti Járás', 1, 'jaszapati-jaras', 47.46126000, 20.06567000),
(1055553, 1001043, 'HU', 'Jászárokszállás', 1, 'jaszarokszallas', 47.64238000, 19.98038000),
(1055544, 1001043, 'HU', 'Jászberény', 1, 'jaszbereny', 47.50000000, 19.91667000),
(1055545, 1001043, 'HU', 'Jászberényi Járás', 1, 'jaszberenyi-jaras', 47.56500000, 19.86887000),
(1055546, 1001043, 'HU', 'Jászdózsa', 1, 'jaszdozsa', 47.56610000, 20.01534000),
(1055547, 1001043, 'HU', 'Jászjákóhalma', 1, 'jaszjakohalma', 47.52038000, 19.99086000),
(1055549, 1001043, 'HU', 'Jászkisér', 1, 'jaszkiser', 47.45000000, 20.21667000),
(1055550, 1001043, 'HU', 'Jászladány', 1, 'jaszladany', 47.36667000, 20.16667000),
(1055551, 1001043, 'HU', 'Jászszentandrás', 1, 'jaszszentandras', 47.58333000, 20.18333000),
(1055567, 1001043, 'HU', 'Karcag', 1, 'karcag', 47.31667000, 20.93333000),
(1055568, 1001043, 'HU', 'Karcagi Járás', 1, 'karcagi-jaras', 47.28583000, 20.84218000),
(1055584, 1001043, 'HU', 'Kenderes', 1, 'kenderes', 47.25000000, 20.68333000),
(1055585, 1001043, 'HU', 'Kengyel', 1, 'kengyel', 47.08333000, 20.33333000),
(1055615, 1001043, 'HU', 'Kisújszállás', 1, 'kisujszallas', 47.21667000, 20.76667000),
(1055627, 1001043, 'HU', 'Kunhegyes', 1, 'kunhegyes', 47.36667000, 20.63333000),
(1055628, 1001043, 'HU', 'Kunhegyesi Járás', 1, 'kunhegyesi-jaras', 47.40329000, 20.59199000),
(1055629, 1001043, 'HU', 'Kunmadaras', 1, 'kunmadaras', 47.43333000, 20.80000000),
(1055632, 1001043, 'HU', 'Kunszentmárton', 1, 'kunszentmarton', 46.83916000, 20.28879000),
(1055633, 1001043, 'HU', 'Kunszentmártoni Járás', 1, 'kunszentmartoni-jaras', 46.87698000, 20.25179000),
(1055699, 1001043, 'HU', 'Mezőtúr', 1, 'mezotur', 47.00000000, 20.63333000),
(1055700, 1001043, 'HU', 'Mezőtúri Járás', 1, 'mezoturi-jaras', 47.02495000, 20.59046000),
(1056156, 1001043, 'HU', 'Öcsöd', 1, 'ocsod', 46.90000000, 20.40000000),
(1055874, 1001043, 'HU', 'Rákóczifalva', 1, 'rakoczifalva', 47.08333000, 20.23333000),
(1055875, 1001043, 'HU', 'Rákócziújfalu', 1, 'rakocziujfalu', 47.06667000, 20.26667000),
(1055915, 1001043, 'HU', 'Szajol', 1, 'szajol', 47.18333000, 20.30000000),
(1055932, 1001043, 'HU', 'Szelevény', 1, 'szeleveny', 46.80259000, 20.20283000),
(1055964, 1001043, 'HU', 'Szolnok', 1, 'szolnok', 47.18333000, 20.20000000),
(1055965, 1001043, 'HU', 'Szolnoki Járás', 1, 'szolnoki-jaras', 47.22480000, 20.19839000),
(1056025, 1001043, 'HU', 'Tiszabő', 1, 'tiszabo', 47.30000000, 20.48333000),
(1056024, 1001043, 'HU', 'Tiszabura', 1, 'tiszabura', 47.45000000, 20.46667000),
(1056030, 1001043, 'HU', 'Tiszaföldvár', 1, 'tiszafoldvar', 46.98333000, 20.25000000),
(1056031, 1001043, 'HU', 'Tiszafüred', 1, 'tiszafured', 47.61667000, 20.76667000),
(1056032, 1001043, 'HU', 'Tiszafüredi Járás', 1, 'tiszafuredi-jaras', 47.53907000, 20.78879000),
(1056041, 1001043, 'HU', 'Tiszapüspöki', 1, 'tiszapuspoki', 47.21667000, 20.31667000),
(1056042, 1001043, 'HU', 'Tiszaroff', 1, 'tiszaroff', 47.40000000, 20.45000000),
(1056045, 1001043, 'HU', 'Tiszasüly', 1, 'tiszasuly', 47.38333000, 20.40000000),
(1056043, 1001043, 'HU', 'Tiszaszentimre', 1, 'tiszaszentimre', 47.48333000, 20.73333000),
(1056044, 1001043, 'HU', 'Tiszaszőlős', 1, 'tiszaszolos', 47.55707000, 20.71949000),
(1056084, 1001043, 'HU', 'Törökszentmiklós', 1, 'torokszentmiklos', 47.18333000, 20.41667000),
(1056085, 1001043, 'HU', 'Törökszentmiklósi Járás', 1, 'torokszentmiklosi-jaras', 47.18209000, 20.44859000),
(1056077, 1001043, 'HU', 'Tószeg', 1, 'toszeg', 47.10000000, 20.15000000),
(1056086, 1001043, 'HU', 'Túrkeve', 1, 'turkeve', 47.10000000, 20.75000000),
(1056164, 1001043, 'HU', 'Újszász', 1, 'ujszasz', 47.30000000, 20.08333000),
(1056118, 1001043, 'HU', 'Zagyvarékas', 1, 'zagyvarekas', 47.26667000, 20.13333000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001067, 'HU', 'Kaposvár', 1, 'kaposvar');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001056, 'HU', 'Kecskemét', 1, 'kecskemet');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001065, 'HU', 'Miskolc', 1, 'miskolc');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001030, 'HU', 'Nagykanizsa', 1, 'nagykanizsa');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001051, 'HU', 'Nógrád County', 1, 'nograd-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 
(1055210, 1001051, 'HU', 'Balassagyarmat', 1, 'balassagyarmat', 48.07296000, 19.29614000),
(1055211, 1001051, 'HU', 'Balassagyarmati Járás', 1, 'balassagyarmati-jaras', 48.01657000, 19.30594000),
(1055293, 1001051, 'HU', 'Bátonyterenye', 1, 'batonyterenye', 47.96962000, 19.84076000),
(1055294, 1001051, 'HU', 'Bátonyterenyei Járás', 1, 'batonyterenyei-jaras', 47.97691000, 19.87345000),
(1055237, 1001051, 'HU', 'Bercel', 1, 'bercel', 47.87057000, 19.40715000),
(1055286, 1001051, 'HU', 'Buják', 1, 'bujak', 47.88352000, 19.54381000),
(1055363, 1001051, 'HU', 'Diósjenő', 1, 'diosjeno', 47.93968000, 19.04317000),
(1056148, 1001051, 'HU', 'Érsekvadkert', 1, 'ersekvadkert', 47.99619000, 19.20231000),
(1055518, 1001051, 'HU', 'Héhalom', 1, 'hehalom', 47.78017000, 19.58519000),
(1055533, 1001051, 'HU', 'Jobbágyi', 1, 'jobbagyi', 47.83238000, 19.67762000),
(1055565, 1001051, 'HU', 'Karancskeszi', 1, 'karancskeszi', 48.16353000, 19.69686000),
(1055566, 1001051, 'HU', 'Karancslapujtő', 1, 'karancslapujto', 48.15000000, 19.73333000),
(1055577, 1001051, 'HU', 'Kazár', 1, 'kazar', 48.04952000, 19.86143000),
(1055725, 1001051, 'HU', 'Mátranovák', 1, 'matranovak', 48.03809000, 19.98257000),
(1055726, 1001051, 'HU', 'Mátraterenye', 1, 'matraterenye', 48.03267000, 19.94762000),
(1055727, 1001051, 'HU', 'Mátraverebély', 1, 'matraverebely', 47.97421000, 19.78049000),
(1055759, 1001051, 'HU', 'Nagyoroszi', 1, 'nagyoroszi', 48.00503000, 19.09050000),
(1055807, 1001051, 'HU', 'Palotás', 1, 'palotas', 47.79528000, 19.59618000),
(1055844, 1001051, 'HU', 'Pásztó', 1, 'paszto', 47.92019000, 19.69829000),
(1055845, 1001051, 'HU', 'Pásztói Járás', 1, 'pasztoi-jaras', 47.87012000, 19.60648000),
(1055877, 1001051, 'HU', 'Rétság', 1, 'retsag', 47.92816000, 19.13720000),
(1055878, 1001051, 'HU', 'Rétsági Járás', 1, 'retsagi-jaras', 47.91741000, 19.16101000),
(1055865, 1001051, 'HU', 'Rimóc', 1, 'rimoc', 48.03695000, 19.53010000),
(1055866, 1001051, 'HU', 'Romhány', 1, 'romhany', 47.92618000, 19.25723000),
(1055889, 1001051, 'HU', 'Salgótarján', 1, 'salgotarjan', 48.09872000, 19.80303000),
(1055890, 1001051, 'HU', 'Salgótarjáni Járás', 1, 'salgotarjani-jaras', 48.10048000, 19.81548000),
(1055907, 1001051, 'HU', 'Somoskőújfalu', 1, 'somoskoujfalu', 48.16374000, 19.82303000),
(1055972, 1001051, 'HU', 'Szécsény', 1, 'szecseny', 48.08057000, 19.52019000),
(1055973, 1001051, 'HU', 'Szécsényi Járás', 1, 'szecsenyi-jaras', 48.07301000, 19.55156000),
(1055968, 1001051, 'HU', 'Szurdokpüspöki', 1, 'szurdokpuspoki', 47.85923000, 19.69218000),
(1056011, 1001051, 'HU', 'Tar', 1, 'tar', 47.95371000, 19.74610000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001034, 'HU', 'Nyíregyháza', 1, 'nyiregyhaza');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001053, 'HU', 'Pécs', 1, 'pecs');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001059, 'HU', 'Pest County', 1, 'pest-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 
(1055172, 1001059, 'HU', 'Abony', 1, 'abony', 47.18990000, 20.00476000),
(1055174, 1001059, 'HU', 'Acsa', 1, 'acsa', 47.79425000, 19.38795000),
(1055183, 1001059, 'HU', 'Albertirsa', 1, 'albertirsa', 47.24315000, 19.61686000),
(1055185, 1001059, 'HU', 'Alsónémedi', 1, 'alsonemedi', 47.31524000, 19.15843000),
(1055197, 1001059, 'HU', 'Aszód', 1, 'aszod', 47.65174000, 19.47850000),
(1055198, 1001059, 'HU', 'Aszódi Járás', 1, 'aszodi-jaras', 47.64738000, 19.54240000),
(1055201, 1001059, 'HU', 'Bag', 1, 'bag', 47.63333000, 19.48333000),
(1055245, 1001059, 'HU', 'Biatorbágy', 1, 'biatorbagy', 47.47060000, 18.81892000),
(1055260, 1001059, 'HU', 'Budakalász', 1, 'budakalasz', 47.61667000, 19.05000000),
(1055261, 1001059, 'HU', 'Budakeszi', 1, 'budakeszi', 47.51083000, 18.92717000),
(1055262, 1001059, 'HU', 'Budakeszi Járás', 1, 'budakeszi-jaras', 47.49788000, 18.84980000),
(1055282, 1001059, 'HU', 'Budaörs', 1, 'budaors', 47.46181000, 18.95845000),
(1055284, 1001059, 'HU', 'Bugyi', 1, 'bugyi', 47.22748000, 19.14664000),
(1055315, 1001059, 'HU', 'Cegléd', 1, 'cegled', 47.17266000, 19.79952000),
(1055316, 1001059, 'HU', 'Ceglédbercel', 1, 'cegledbercel', 47.22370000, 19.66828000),
(1055317, 1001059, 'HU', 'Ceglédi Járás', 1, 'cegledi-jaras', 47.20000000, 19.82463000),
(1055327, 1001059, 'HU', 'Csemő', 1, 'csemo', 47.11799000, 19.69092000),
(1055336, 1001059, 'HU', 'Csobánka', 1, 'csobanka', 47.64637000, 18.96189000),
(1055350, 1001059, 'HU', 'Csömör', 1, 'csomor', 47.55000000, 19.23333000),
(1055351, 1001059, 'HU', 'Dabas', 1, 'dabas', 47.18594000, 19.31091000),
(1055352, 1001059, 'HU', 'Dabasi Járás', 1, 'dabasi-jaras', 47.19000000, 19.33000000),
(1055384, 1001059, 'HU', 'Dánszentmiklós', 1, 'danszentmiklos', 47.21486000, 19.54695000),
(1055385, 1001059, 'HU', 'Dány', 1, 'dany', 47.52000000, 19.54400000),
(1055388, 1001059, 'HU', 'Délegyháza', 1, 'delegyhaza', 47.24135000, 19.09019000),
(1055362, 1001059, 'HU', 'Diósd', 1, 'diosd', 47.40950000, 18.94898000),
(1055370, 1001059, 'HU', 'Domony', 1, 'domony', 47.65552000, 19.43229000),
(1055392, 1001059, 'HU', 'Dömsöd', 1, 'domsod', 47.09005000, 19.01106000),
(1055372, 1001059, 'HU', 'Dunabogdány', 1, 'dunabogdany', 47.79052000, 19.04125000),
(1055374, 1001059, 'HU', 'Dunaharaszti', 1, 'dunaharaszti', 47.35450000, 19.09822000),
(1055375, 1001059, 'HU', 'Dunakeszi', 1, 'dunakeszi', 47.63641000, 19.13864000),
(1055376, 1001059, 'HU', 'Dunakeszi Járás', 1, 'dunakeszi-jaras', 47.63365000, 19.16254000),
(1055380, 1001059, 'HU', 'Dunavarsány', 1, 'dunavarsany', 47.27859000, 19.06617000),
(1055394, 1001059, 'HU', 'Ecser', 1, 'ecser', 47.44389000, 19.32450000),
(1056145, 1001059, 'HU', 'Érd', 1, 'erd', 47.39489000, 18.91361000),
(1056146, 1001059, 'HU', 'Érdi Járás', 1, 'erdi-jaras', 47.35600000, 18.90167000),
(1055411, 1001059, 'HU', 'Erdőkertes', 1, 'erdokertes', 47.67261000, 19.30786000),
(1055417, 1001059, 'HU', 'Farmos', 1, 'farmos', 47.36067000, 19.84619000),
(1055423, 1001059, 'HU', 'Felsőpakony', 1, 'felsopakony', 47.34329000, 19.23698000),
(1055433, 1001059, 'HU', 'Forrópuszta', 1, 'forropuszta', 47.45504000, 19.66001000),
(1055436, 1001059, 'HU', 'Fót', 1, 'fot', 47.61770000, 19.18870000),
(1055444, 1001059, 'HU', 'Galgahévíz', 1, 'galgaheviz', 47.61667000, 19.56667000),
(1055445, 1001059, 'HU', 'Galgamácsa', 1, 'galgamacsa', 47.69562000, 19.38724000),
(1055474, 1001059, 'HU', 'Göd', 1, 'god', 47.68324000, 19.13417000),
(1055475, 1001059, 'HU', 'Gödöllő', 1, 'godollo', 47.59657000, 19.35515000),
(1055476, 1001059, 'HU', 'Gödöllői Járás', 1, 'godolloi-jaras', 47.55127000, 19.39595000),
(1055449, 1001059, 'HU', 'Gomba', 1, 'gomba', 47.37095000, 19.53057000),
(1055456, 1001059, 'HU', 'Gyál', 1, 'gyal', 47.38449000, 19.22140000),
(1055457, 1001059, 'HU', 'Gyáli Járás', 1, 'gyali-jaras', 47.36821000, 19.27543000),
(1055458, 1001059, 'HU', 'Gyömrő', 1, 'gyomro', 47.42733000, 19.40133000),
(1055496, 1001059, 'HU', 'Halásztelek', 1, 'halasztelek', 47.36173000, 18.98119000),
(1055507, 1001059, 'HU', 'Hernád', 1, 'hernad', 47.16238000, 19.43295000),
(1055520, 1001059, 'HU', 'Hévízgyörk', 1, 'hevizgyork', 47.63333000, 19.51667000),
(1055526, 1001059, 'HU', 'Iklad', 1, 'iklad', 47.66533000, 19.43610000),
(1055527, 1001059, 'HU', 'Inárcs', 1, 'inarcs', 47.26200000, 19.32700000),
(1055529, 1001059, 'HU', 'Isaszeg', 1, 'isaszeg', 47.53011000, 19.40205000),
(1055548, 1001059, 'HU', 'Jászkarajenő', 1, 'jaszkarajeno', 47.05000000, 20.06667000),
(1055557, 1001059, 'HU', 'Kakucs', 1, 'kakucs', 47.24200000, 19.36467000),
(1055570, 1001059, 'HU', 'Kartal', 1, 'kartal', 47.67133000, 19.54200000),
(1055588, 1001059, 'HU', 'Kerepes', 1, 'kerepes', 47.56008000, 19.28289000),
(1055598, 1001059, 'HU', 'Kiskunlacháza', 1, 'kiskunlachaza', 47.18839000, 19.00930000),
(1055606, 1001059, 'HU', 'Kismaros', 1, 'kismaros', 47.83742000, 19.00463000),
(1055609, 1001059, 'HU', 'Kistarcsa', 1, 'kistarcsa', 47.54757000, 19.26247000),
(1055617, 1001059, 'HU', 'Kocsér', 1, 'kocser', 47.00165000, 19.92067000),
(1055644, 1001059, 'HU', 'Kóka', 1, 'koka', 47.48552000, 19.57876000),
(1055624, 1001059, 'HU', 'Kosd', 1, 'kosd', 47.80791000, 19.17821000),
(1055663, 1001059, 'HU', 'Leányfalu', 1, 'leanyfalu', 47.71778000, 19.08585000),
(1055674, 1001059, 'HU', 'Maglód', 1, 'maglod', 47.44258000, 19.36438000),
(1055687, 1001059, 'HU', 'Mende', 1, 'mende', 47.43133000, 19.45628000),
(1055707, 1001059, 'HU', 'Mogyoród', 1, 'mogyorod', 47.59748000, 19.24070000),
(1055711, 1001059, 'HU', 'Monor', 1, 'monor', 47.35133000, 19.44733000),
(1055712, 1001059, 'HU', 'Monori Járás', 1, 'monori-jaras', 47.34990000, 19.47680000),
(1055753, 1001059, 'HU', 'Nagykáta', 1, 'nagykata', 47.41514000, 19.74410000),
(1055754, 1001059, 'HU', 'Nagykátai Járás', 1, 'nagykatai-jaras', 47.39109000, 19.73920000),
(1055755, 1001059, 'HU', 'Nagykőrös', 1, 'nagykoros', 47.03419000, 19.77857000),
(1055756, 1001059, 'HU', 'Nagykőrösi Járás', 1, 'nagykorosi-jaras', 47.03563000, 19.79259000),
(1055750, 1001059, 'HU', 'Nagykovácsi', 1, 'nagykovacsi', 47.65000000, 19.01667000),
(1055757, 1001059, 'HU', 'Nagymaros', 1, 'nagymaros', 47.79280000, 18.95984000),
(1055763, 1001059, 'HU', 'Nagytarcsa', 1, 'nagytarcsa', 47.53128000, 19.28343000),
(1055767, 1001059, 'HU', 'Nyáregyháza', 1, 'nyaregyhaza', 47.26175000, 19.50146000),
(1056149, 1001059, 'HU', 'Ócsa', 1, 'ocsa', 47.29986000, 19.23057000),
(1056171, 1001059, 'HU', 'Őrbottyán', 1, 'orbottyan', 47.68711000, 19.28239000),
(1056158, 1001059, 'HU', 'Örkény', 1, 'orkeny', 47.12991000, 19.43324000),
(1055841, 1001059, 'HU', 'Pánd', 1, 'pand', 47.35333000, 19.63571000),
(1055847, 1001059, 'HU', 'Páty', 1, 'paty', 47.51709000, 18.82851000),
(1055849, 1001059, 'HU', 'Pécel', 1, 'pecel', 47.48962000, 19.34162000),
(1055813, 1001059, 'HU', 'Perbál', 1, 'perbal', 47.58957000, 18.76099000),
(1055855, 1001059, 'HU', 'Péteri', 1, 'peteri', 47.39104000, 19.40981000),
(1055817, 1001059, 'HU', 'Pilis', 1, 'pilis', 47.28904000, 19.54848000),
(1055818, 1001059, 'HU', 'Pilisborosjenő', 1, 'pilisborosjeno', 47.60744000, 18.99322000),
(1055819, 1001059, 'HU', 'Piliscsaba', 1, 'piliscsaba', 47.63417000, 18.82886000),
(1055822, 1001059, 'HU', 'Pilisszántó', 1, 'pilisszanto', 47.66909000, 18.88762000),
(1055820, 1001059, 'HU', 'Pilisszentiván', 1, 'pilisszentivan', 47.60964000, 18.89940000),
(1055821, 1001059, 'HU', 'Pilisszentkereszt', 1, 'pilisszentkereszt', 47.69143000, 18.90503000),
(1055823, 1001059, 'HU', 'Pilisvörösvár', 1, 'pilisvorosvar', 47.61386000, 18.90893000),
(1055824, 1001059, 'HU', 'Pilisvörösvári Járás', 1, 'pilisvorosvari-jaras', 47.60925000, 18.86658000),
(1055829, 1001059, 'HU', 'Pomáz', 1, 'pomaz', 47.64227000, 19.02784000),
(1055872, 1001059, 'HU', 'Ráckeve', 1, 'rackeve', 47.16095000, 18.94478000),
(1055873, 1001059, 'HU', 'Ráckevei Járás', 1, 'rackevei-jaras', 47.15158000, 19.01456000),
(1055905, 1001059, 'HU', 'Solymár', 1, 'solymar', 47.59246000, 18.93212000),
(1055996, 1001059, 'HU', 'Sóskút', 1, 'soskut', 47.40665000, 18.82247000),
(1055998, 1001059, 'HU', 'Sülysáp', 1, 'sulysap', 47.45206000, 19.53369000),
(1055914, 1001059, 'HU', 'Szada', 1, 'szada', 47.63333000, 19.31667000),
(1055971, 1001059, 'HU', 'Százhalombatta', 1, 'szazhalombatta', 47.32949000, 18.93878000),
(1055934, 1001059, 'HU', 'Szentendre', 1, 'szentendre', 47.66943000, 19.07561000),
(1055935, 1001059, 'HU', 'Szentendrei Járás', 1, 'szentendrei-jaras', 47.71146000, 19.02524000),
(1055946, 1001059, 'HU', 'Szentlőrinckáta', 1, 'szentlorinckata', 47.51947000, 19.75286000),
(1055947, 1001059, 'HU', 'Szentmártonkáta', 1, 'szentmartonkata', 47.45419000, 19.70143000),
(1055950, 1001059, 'HU', 'Szigetcsép', 1, 'szigetcsep', 47.26492000, 18.97048000),
(1055951, 1001059, 'HU', 'Szigethalom', 1, 'szigethalom', 47.32228000, 19.00262000),
(1055952, 1001059, 'HU', 'Szigetszentmiklós', 1, 'szigetszentmiklos', 47.34382000, 19.04335000),
(1055953, 1001059, 'HU', 'Szigetszentmiklósi Járás', 1, 'szigetszentmiklosi-jaras', 47.30566000, 19.02829000),
(1055956, 1001059, 'HU', 'Szigetújfalu', 1, 'szigetujfalu', 47.23417000, 18.92746000),
(1055962, 1001059, 'HU', 'Szob', 1, 'szob', 47.81921000, 18.87020000),
(1055963, 1001059, 'HU', 'Szobi Járás', 1, 'szobi-jaras', 47.93419000, 18.85438000),
(1055977, 1001059, 'HU', 'Sződ', 1, 'szod', 47.72439000, 19.17046000),
(1055978, 1001059, 'HU', 'Sződliget', 1, 'szodliget', 47.73259000, 19.14749000),
(1056061, 1001059, 'HU', 'Táborfalva', 1, 'taborfalva', 47.09942000, 19.47837000),
(1056003, 1001059, 'HU', 'Tahitótfalu', 1, 'tahitotfalu', 47.75000000, 19.10000000),
(1056004, 1001059, 'HU', 'Taksony', 1, 'taksony', 47.32968000, 19.06695000),
(1056063, 1001059, 'HU', 'Tápióbicske', 1, 'tapiobicske', 47.36096000, 19.68609000),
(1056064, 1001059, 'HU', 'Tápiógyörgye', 1, 'tapiogyorgye', 47.33505000, 19.95276000),
(1056069, 1001059, 'HU', 'Tápióság', 1, 'tapiosag', 47.40200000, 19.63047000),
(1056065, 1001059, 'HU', 'Tápiószecső', 1, 'tapioszecso', 47.45000000, 19.60923000),
(1056066, 1001059, 'HU', 'Tápiószele', 1, 'tapioszele', 47.33609000, 19.87724000),
(1056067, 1001059, 'HU', 'Tápiószentmárton', 1, 'tapioszentmarton', 47.33990000, 19.74648000),
(1056068, 1001059, 'HU', 'Tápiószőlős', 1, 'tapioszolos', 47.30248000, 19.85133000),
(1056071, 1001059, 'HU', 'Tárnok', 1, 'tarnok', 47.37327000, 18.84579000),
(1056018, 1001059, 'HU', 'Telki', 1, 'telki', 47.54791000, 18.82816000),
(1056076, 1001059, 'HU', 'Tóalmás', 1, 'toalmas', 47.50782000, 19.66657000),
(1056079, 1001059, 'HU', 'Tököl', 1, 'tokol', 47.32178000, 18.96249000),
(1056083, 1001059, 'HU', 'Törökbálint', 1, 'torokbalint', 47.42931000, 18.91356000),
(1056082, 1001059, 'HU', 'Törtel', 1, 'tortel', 47.12209000, 19.93714000),
(1056058, 1001059, 'HU', 'Tura', 1, 'tura', 47.60924000, 19.60279000),
(1056161, 1001059, 'HU', 'Újhartyán', 1, 'ujhartyan', 47.21981000, 19.38638000),
(1056163, 1001059, 'HU', 'Újszilvás', 1, 'ujszilvas', 47.27477000, 19.92477000),
(1056168, 1001059, 'HU', 'Üllő', 1, 'ullo', 47.38771000, 19.35533000),
(1056165, 1001059, 'HU', 'Úri', 1, 'uri', 47.41429000, 19.52762000),
(1056169, 1001059, 'HU', 'Üröm', 1, 'urom', 47.59674000, 19.01583000),
(1056105, 1001059, 'HU', 'Vác', 1, 'vac', 47.77591000, 19.13612000),
(1056106, 1001059, 'HU', 'Váci Járás', 1, 'vaci-jaras', 47.78316000, 19.23882000),
(1056107, 1001059, 'HU', 'Vácszentlászló', 1, 'vacszentlaszlo', 47.57400000, 19.53771000),
(1056090, 1001059, 'HU', 'Valkó', 1, 'valko', 47.56391000, 19.51267000),
(1056094, 1001059, 'HU', 'Vecsés', 1, 'vecses', 47.40705000, 19.28648000),
(1056095, 1001059, 'HU', 'Vecsési Járás', 1, 'vecsesi-jaras', 47.42923000, 19.30136000),
(1056097, 1001059, 'HU', 'Veresegyház', 1, 'veresegyhaz', 47.64590000, 19.29536000),
(1056099, 1001059, 'HU', 'Verőce', 1, 'veroce', 47.82468000, 19.03484000),
(1056103, 1001059, 'HU', 'Visegrád', 1, 'visegrad', 47.78526000, 18.97090000),
(1056132, 1001059, 'HU', 'Zsámbék', 1, 'zsambek', 47.54814000, 18.72011000),
(1056131, 1001059, 'HU', 'Zsámbok', 1, 'zsambok', 47.54381000, 19.61048000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001068, 'HU', 'Salgótarján', 1, 'salgotarjan');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001035, 'HU', 'Somogy County', 1, 'somogy-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 
(1056140, 1001035, 'HU', 'Ádánd', 1, 'adand', 46.85931000, 18.16442000),
(1055199, 1001035, 'HU', 'Babócsa', 1, 'babocsa', 46.04155000, 17.34332000),
(1055214, 1001035, 'HU', 'Balatonberény', 1, 'balatonbereny', 46.70701000, 17.32013000),
(1055215, 1001035, 'HU', 'Balatonboglár', 1, 'balatonboglar', 46.77525000, 17.64415000),
(1055216, 1001035, 'HU', 'Balatonfenyves', 1, 'balatonfenyves', 46.71542000, 17.49223000),
(1055217, 1001035, 'HU', 'Balatonföldvár', 1, 'balatonfoldvar', 46.85255000, 17.88123000),
(1055221, 1001035, 'HU', 'Balatonlelle', 1, 'balatonlelle', 46.78318000, 17.69498000),
(1055222, 1001035, 'HU', 'Balatonszabadi', 1, 'balatonszabadi', 46.89397000, 18.13737000),
(1055223, 1001035, 'HU', 'Balatonszárszó', 1, 'balatonszarszo', 46.82946000, 17.82426000),
(1055231, 1001035, 'HU', 'Barcs', 1, 'barcs', 45.96000000, 17.45861000),
(1055232, 1001035, 'HU', 'Barcsi Járás', 1, 'barcsi-jaras', 46.03687000, 17.47434000),
(1055242, 1001035, 'HU', 'Berzence', 1, 'berzence', 46.20907000, 17.14810000),
(1055306, 1001035, 'HU', 'Böhönye', 1, 'bohonye', 46.41345000, 17.38037000),
(1055343, 1001035, 'HU', 'Csurgó', 1, 'csurgo', 46.25314000, 17.10060000),
(1055344, 1001035, 'HU', 'Csurgói Járás', 1, 'csurgoi-jaras', 46.29502000, 17.10021000),
(1055430, 1001035, 'HU', 'Fonyód', 1, 'fonyod', 46.75552000, 17.57945000),
(1055431, 1001035, 'HU', 'Fonyódi Járás', 1, 'fonyodi-jaras', 46.67289000, 17.70000000),
(1055556, 1001035, 'HU', 'Kadarkút', 1, 'kadarkut', 46.23623000, 17.62014000),
(1055560, 1001035, 'HU', 'Kaposmérő', 1, 'kaposmero', 46.36167000, 17.70400000),
(1055561, 1001035, 'HU', 'Kaposvár', 1, 'kaposvar', 46.36667000, 17.80000000),
(1055562, 1001035, 'HU', 'Kaposvári Járás', 1, 'kaposvari-jaras', 46.39791000, 17.76990000),
(1055572, 1001035, 'HU', 'Karád', 1, 'karad', 46.69076000, 17.84136000),
(1055643, 1001035, 'HU', 'Kéthely', 1, 'kethely', 46.64605000, 17.39362000),
(1055666, 1001035, 'HU', 'Lábod', 1, 'labod', 46.20535000, 17.45419000),
(1055656, 1001035, 'HU', 'Lengyeltóti', 1, 'lengyeltoti', 46.67013000, 17.64398000),
(1055679, 1001035, 'HU', 'Marcali', 1, 'marcali', 46.58498000, 17.41196000),
(1055680, 1001035, 'HU', 'Marcali Járás', 1, 'marcali-jaras', 46.54382000, 17.39203000),
(1055738, 1001035, 'HU', 'Nagyatád', 1, 'nagyatad', 46.22961000, 17.35788000),
(1055739, 1001035, 'HU', 'Nagyatádi Járás', 1, 'nagyatadi-jaras', 46.25200000, 17.37520000),
(1055740, 1001035, 'HU', 'Nagybajom', 1, 'nagybajom', 46.39232000, 17.51147000),
(1055893, 1001035, 'HU', 'Segesd', 1, 'segesd', 46.34142000, 17.35132000),
(1055901, 1001035, 'HU', 'Siófok', 1, 'siofok', 46.90413000, 18.05800000),
(1055902, 1001035, 'HU', 'Siófoki Járás', 1, 'siofoki-jaras', 46.85060000, 17.99625000),
(1055906, 1001035, 'HU', 'Somogyvár', 1, 'somogyvar', 46.58140000, 17.66289000),
(1056001, 1001035, 'HU', 'Tab', 1, 'tab', 46.73135000, 18.03201000),
(1056002, 1001035, 'HU', 'Tabi Járás', 1, 'tabi-jaras', 46.68037000, 18.00560000),
(1056017, 1001035, 'HU', 'Taszár', 1, 'taszar', 46.37467000, 17.90594000),
(1056126, 1001035, 'HU', 'Zamárdi', 1, 'zamardi', 46.88488000, 17.95366000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001057, 'HU', 'Sopron', 1, 'sopron');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001045, 'HU', 'Szabolcs-Szatmár-Bereg County', 1, 'szabolcs-szatmar-bereg-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 
(1055177, 1001045, 'HU', 'Ajak', 1, 'ajak', 48.17664000, 22.06273000),
(1055187, 1001045, 'HU', 'Anarcs', 1, 'anarcs', 48.17642000, 22.11167000),
(1055189, 1001045, 'HU', 'Apagy', 1, 'apagy', 47.96431000, 21.93539000),
(1055193, 1001045, 'HU', 'Aranyosapáti', 1, 'aranyosapati', 48.20595000, 22.25916000),
(1055208, 1001045, 'HU', 'Baktalórántháza', 1, 'baktaloranthaza', 48.00000000, 22.08333000),
(1055209, 1001045, 'HU', 'Baktalórántházai Járás', 1, 'baktaloranthazai-jaras', 48.00436000, 22.02449000),
(1055224, 1001045, 'HU', 'Balkány', 1, 'balkany', 47.77066000, 21.86314000),
(1055307, 1001045, 'HU', 'Bököny', 1, 'bokony', 47.73333000, 21.75000000),
(1055285, 1001045, 'HU', 'Buj', 1, 'buj', 48.10000000, 21.65000000),
(1055329, 1001045, 'HU', 'Csenger', 1, 'csenger', 47.83582000, 22.68096000),
(1055330, 1001045, 'HU', 'Csengeri Járás', 1, 'csengeri-jaras', 47.83045000, 22.59810000),
(1055356, 1001045, 'HU', 'Demecser', 1, 'demecser', 48.11648000, 21.92624000),
(1055391, 1001045, 'HU', 'Döge', 1, 'doge', 48.26246000, 22.06339000),
(1055367, 1001045, 'HU', 'Dombrád', 1, 'dombrad', 48.23333000, 21.93333000),
(1055406, 1001045, 'HU', 'Encsencs', 1, 'encsencs', 47.73333000, 22.11667000),
(1055420, 1001045, 'HU', 'Fehérgyarmat', 1, 'fehergyarmat', 47.98333000, 22.51667000),
(1055421, 1001045, 'HU', 'Fehérgyarmati Járás', 1, 'fehergyarmati-jaras', 48.00436000, 22.63014000),
(1055435, 1001045, 'HU', 'Fényeslitke', 1, 'fenyeslitke', 48.27133000, 22.10009000),
(1055473, 1001045, 'HU', 'Gégény', 1, 'gegeny', 48.15000000, 21.95000000),
(1055454, 1001045, 'HU', 'Gyulaháza', 1, 'gyulahaza', 48.13333000, 22.11667000),
(1055513, 1001045, 'HU', 'Hodász', 1, 'hodasz', 47.91834000, 22.20153000),
(1055524, 1001045, 'HU', 'Ibrány', 1, 'ibrany', 48.12329000, 21.70953000),
(1055525, 1001045, 'HU', 'Ibrányi Járás', 1, 'ibranyi-jaras', 48.12794000, 21.69344000),
(1055636, 1001045, 'HU', 'Kállósemjén', 1, 'kallosemjen', 47.86081000, 21.93929000),
(1055637, 1001045, 'HU', 'Kálmánháza', 1, 'kalmanhaza', 47.88333000, 21.58333000),
(1055639, 1001045, 'HU', 'Kántorjánosi', 1, 'kantorjanosi', 47.93333000, 22.15000000),
(1055641, 1001045, 'HU', 'Kék', 1, 'kek', 48.11667000, 21.88333000),
(1055582, 1001045, 'HU', 'Kemecse', 1, 'kemecse', 48.07532000, 21.80625000),
(1055583, 1001045, 'HU', 'Kemecsei Járás', 1, 'kemecsei-jaras', 48.10048000, 21.88414000),
(1055605, 1001045, 'HU', 'Kisléta', 1, 'kisleta', 47.84244000, 22.00393000),
(1055612, 1001045, 'HU', 'Kisvárda', 1, 'kisvarda', 48.21667000, 22.08333000),
(1055613, 1001045, 'HU', 'Kisvárdai Járás', 1, 'kisvardai-jaras', 48.22100000, 22.06415000),
(1055616, 1001045, 'HU', 'Kocsord', 1, 'kocsord', 47.93912000, 22.38333000),
(1055646, 1001045, 'HU', 'Kótaj', 1, 'kotaj', 48.05000000, 21.71667000),
(1055662, 1001045, 'HU', 'Levelek', 1, 'levelek', 47.96282000, 21.98537000),
(1055721, 1001045, 'HU', 'Mándok', 1, 'mandok', 48.32149000, 22.19107000),
(1055723, 1001045, 'HU', 'Máriapócs', 1, 'mariapocs', 47.88303000, 22.02501000),
(1055728, 1001045, 'HU', 'Mátészalka', 1, 'mateszalka', 47.95528000, 22.32348000),
(1055729, 1001045, 'HU', 'Mátészalkai Járás', 1, 'mateszalkai-jaras', 47.92961000, 22.31892000),
(1055732, 1001045, 'HU', 'Mérk', 1, 'merk', 47.78824000, 22.38038000),
(1055743, 1001045, 'HU', 'Nagycserkesz', 1, 'nagycserkesz', 47.96667000, 21.53333000),
(1055744, 1001045, 'HU', 'Nagydobos', 1, 'nagydobos', 48.05759000, 22.30423000),
(1055746, 1001045, 'HU', 'Nagyecsed', 1, 'nagyecsed', 47.86547000, 22.39159000),
(1055747, 1001045, 'HU', 'Nagyhalász', 1, 'nagyhalasz', 48.13266000, 21.76104000),
(1055751, 1001045, 'HU', 'Nagykálló', 1, 'nagykallo', 47.87491000, 21.84082000),
(1055752, 1001045, 'HU', 'Nagykállói Járás', 1, 'nagykalloi-jaras', 47.79994000, 21.84753000),
(1055764, 1001045, 'HU', 'Napkor', 1, 'napkor', 47.93797000, 21.86763000),
(1055775, 1001045, 'HU', 'Nyírbátor', 1, 'nyirbator', 47.83333000, 22.13333000),
(1055776, 1001045, 'HU', 'Nyírbátori Járás', 1, 'nyirbatori-jaras', 47.77553000, 22.11755000),
(1055777, 1001045, 'HU', 'Nyírbéltek', 1, 'nyirbeltek', 47.70000000, 22.13333000),
(1055774, 1001045, 'HU', 'Nyírbogát', 1, 'nyirbogat', 47.80340000, 22.06561000),
(1055773, 1001045, 'HU', 'Nyírbogdány', 1, 'nyirbogdany', 48.05723000, 21.88242000),
(1055778, 1001045, 'HU', 'Nyírcsaholy', 1, 'nyircsaholy', 47.90383000, 22.33630000),
(1055779, 1001045, 'HU', 'Nyíregyháza', 1, 'nyiregyhaza', 47.95539000, 21.71671000),
(1055780, 1001045, 'HU', 'Nyíregyházi Járás', 1, 'nyiregyhazi-jaras', 47.97691000, 21.64463000),
(1055781, 1001045, 'HU', 'Nyírgyulaj', 1, 'nyirgyulaj', 47.88622000, 22.09781000),
(1055782, 1001045, 'HU', 'Nyírkarász', 1, 'nyirkarasz', 48.09477000, 22.10463000),
(1055783, 1001045, 'HU', 'Nyírlugos', 1, 'nyirlugos', 47.69315000, 22.04476000),
(1055784, 1001045, 'HU', 'Nyírmada', 1, 'nyirmada', 48.06667000, 22.20000000),
(1055785, 1001045, 'HU', 'Nyírmeggyes', 1, 'nyirmeggyes', 47.91667000, 22.26667000),
(1055786, 1001045, 'HU', 'Nyírmihálydi', 1, 'nyirmihalydi', 47.73976000, 21.96445000),
(1055788, 1001045, 'HU', 'Nyírpazony', 1, 'nyirpazony', 47.98333000, 21.80000000),
(1055789, 1001045, 'HU', 'Nyírtass', 1, 'nyirtass', 48.11667000, 22.03333000),
(1055790, 1001045, 'HU', 'Nyírtelek', 1, 'nyirtelek', 48.01667000, 21.63333000),
(1055791, 1001045, 'HU', 'Nyírvasvári', 1, 'nyirvasvari', 47.81667000, 22.18683000),
(1056150, 1001045, 'HU', 'Ófehértó', 1, 'ofeherto', 47.93333000, 22.05000000),
(1056157, 1001045, 'HU', 'Ököritófülpös', 1, 'okoritofulpos', 47.91862000, 22.50810000),
(1056153, 1001045, 'HU', 'Ópályi', 1, 'opalyi', 47.99771000, 22.32617000),
(1055846, 1001045, 'HU', 'Pátroha', 1, 'patroha', 48.16667000, 22.00000000),
(1055815, 1001045, 'HU', 'Petneháza', 1, 'petnehaza', 48.06084000, 22.07485000),
(1055830, 1001045, 'HU', 'Porcsalma', 1, 'porcsalma', 47.88333000, 22.56667000),
(1055862, 1001045, 'HU', 'Rakamaz', 1, 'rakamaz', 48.12372000, 21.46429000),
(1055916, 1001045, 'HU', 'Szakoly', 1, 'szakoly', 47.76667000, 21.91667000),
(1055918, 1001045, 'HU', 'Szamosszeg', 1, 'szamosszeg', 48.04561000, 22.36582000),
(1056015, 1001045, 'HU', 'Tarpa', 1, 'tarpa', 48.10480000, 22.53744000),
(1056022, 1001045, 'HU', 'Tiszabercel', 1, 'tiszabercel', 48.15000000, 21.65000000),
(1056023, 1001045, 'HU', 'Tiszabezdéd', 1, 'tiszabezded', 48.36667000, 22.15000000),
(1056027, 1001045, 'HU', 'Tiszadada', 1, 'tiszadada', 48.03333000, 21.25000000),
(1056028, 1001045, 'HU', 'Tiszadob', 1, 'tiszadob', 48.01667000, 21.16667000),
(1056029, 1001045, 'HU', 'Tiszaeszlár', 1, 'tiszaeszlar', 48.05000000, 21.46667000),
(1056037, 1001045, 'HU', 'Tiszalök', 1, 'tiszalok', 48.01667000, 21.38333000),
(1056039, 1001045, 'HU', 'Tiszanagyfalu', 1, 'tiszanagyfalu', 48.10000000, 21.48333000),
(1056046, 1001045, 'HU', 'Tiszavasvári', 1, 'tiszavasvari', 47.96667000, 21.35000000),
(1056047, 1001045, 'HU', 'Tiszavasvári Járás', 1, 'tiszavasvari-jaras', 47.98606000, 21.36545000),
(1056056, 1001045, 'HU', 'Tornyospálca', 1, 'tornyospalca', 48.26667000, 22.18333000),
(1056057, 1001045, 'HU', 'Tunyogmatolcs', 1, 'tunyogmatolcs', 47.96667000, 22.46667000),
(1056059, 1001045, 'HU', 'Tuzsér', 1, 'tuzser', 48.34407000, 22.11762000),
(1056060, 1001045, 'HU', 'Tyukod', 1, 'tyukod', 47.85378000, 22.56330000),
(1056160, 1001045, 'HU', 'Újfehértó', 1, 'ujfeherto', 47.80000000, 21.68333000),
(1056088, 1001045, 'HU', 'Vaja', 1, 'vaja', 48.00574000, 22.16761000),
(1056114, 1001045, 'HU', 'Vásárosnamény', 1, 'vasarosnameny', 48.12542000, 22.31325000),
(1056115, 1001045, 'HU', 'Vásárosnaményi Járás', 1, 'vasarosnamenyi-jaras', 48.17981000, 22.35859000),
(1056134, 1001045, 'HU', 'Záhony', 1, 'zahony', 48.40906000, 22.17614000),
(1056135, 1001045, 'HU', 'Záhonyi Járás', 1, 'zahonyi-jaras', 48.34914000, 22.18925000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001029, 'HU', 'Szeged', 1, 'szeged');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001033, 'HU', 'Székesfehérvár', 1, 'szekesfehervar');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001061, 'HU', 'Szekszárd', 1, 'szekszard');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001047, 'HU', 'Szolnok', 1, 'szolnok');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001052, 'HU', 'Szombathely', 1, 'szombathely');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001066, 'HU', 'Tatabánya', 1, 'tatabanya');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001038, 'HU', 'Tolna County', 1, 'tolna-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 
(1055291, 1001038, 'HU', 'Báta', 1, 'bata', 46.12864000, 18.77027000),
(1055292, 1001038, 'HU', 'Bátaszék', 1, 'bataszek', 46.19373000, 18.72307000),
(1055251, 1001038, 'HU', 'Bogyiszló', 1, 'bogyiszlo', 46.38638000, 18.82962000),
(1055308, 1001038, 'HU', 'Bölcske', 1, 'bolcske', 46.74102000, 18.96736000),
(1055255, 1001038, 'HU', 'Bonyhád', 1, 'bonyhad', 46.29921000, 18.53024000),
(1055256, 1001038, 'HU', 'Bonyhádi Járás', 1, 'bonyhadi-jaras', 46.33998000, 18.49739000),
(1055355, 1001038, 'HU', 'Decs', 1, 'decs', 46.28428000, 18.76000000),
(1055390, 1001038, 'HU', 'Döbrököz', 1, 'dobrokoz', 46.42178000, 18.23953000),
(1055368, 1001038, 'HU', 'Dombóvár', 1, 'dombovar', 46.37657000, 18.13696000),
(1055369, 1001038, 'HU', 'Dombóvári Járás', 1, 'dombovari-jaras', 46.45592000, 18.19076000),
(1055373, 1001038, 'HU', 'Dunaföldvár', 1, 'dunafoldvar', 46.80713000, 18.92763000),
(1055379, 1001038, 'HU', 'Dunaszentgyörgy', 1, 'dunaszentgyorgy', 46.52852000, 18.81771000),
(1055415, 1001038, 'HU', 'Fadd', 1, 'fadd', 46.46476000, 18.81925000),
(1055465, 1001038, 'HU', 'Gyönk', 1, 'gyonk', 46.55603000, 18.47694000),
(1055523, 1001038, 'HU', 'Hőgyész', 1, 'hogyesz', 46.49697000, 18.41841000),
(1055528, 1001038, 'HU', 'Iregszemcse', 1, 'iregszemcse', 46.69286000, 18.18581000),
(1055673, 1001038, 'HU', 'Madocsa', 1, 'madocsa', 46.68790000, 18.95791000),
(1055745, 1001038, 'HU', 'Nagydorog', 1, 'nagydorog', 46.62749000, 18.65565000),
(1055758, 1001038, 'HU', 'Nagymányok', 1, 'nagymanyok', 46.27911000, 18.45489000),
(1055795, 1001038, 'HU', 'Németkér', 1, 'nemetker', 46.71637000, 18.76311000),
(1056170, 1001038, 'HU', 'Őcsény', 1, 'ocseny', 46.31370000, 18.75749000),
(1055803, 1001038, 'HU', 'Ozora', 1, 'ozora', 46.75133000, 18.40010000),
(1055805, 1001038, 'HU', 'Paks', 1, 'paks', 46.62210000, 18.85569000),
(1055806, 1001038, 'HU', 'Paksi Járás', 1, 'paksi-jaras', 46.66035000, 18.78572000),
(1055825, 1001038, 'HU', 'Pincehely', 1, 'pincehely', 46.68095000, 18.43935000),
(1055899, 1001038, 'HU', 'Simontornya', 1, 'simontornya', 46.75462000, 18.55490000),
(1055924, 1001038, 'HU', 'Szedres', 1, 'szedres', 46.47551000, 18.68305000),
(1055930, 1001038, 'HU', 'Szekszárd', 1, 'szekszard', 46.35014000, 18.70905000),
(1055931, 1001038, 'HU', 'Szekszárdi Járás', 1, 'szekszardi-jaras', 46.33998000, 18.67893000),
(1055940, 1001038, 'HU', 'Szentgálpuszta', 1, 'szentgalpuszta', 46.37479000, 18.62601000),
(1056007, 1001038, 'HU', 'Tamási', 1, 'tamasi', 46.63333000, 18.28333000),
(1056008, 1001038, 'HU', 'Tamási Járás', 1, 'tamasi-jaras', 46.65424000, 18.35857000),
(1056019, 1001038, 'HU', 'Tengelic', 1, 'tengelic', 46.52878000, 18.71117000),
(1056053, 1001038, 'HU', 'Tolna', 1, 'tolna', 46.42677000, 18.78248000),
(1056054, 1001038, 'HU', 'Tolnai Járás', 1, 'tolnai-jaras', 46.42541000, 18.82691000),
(1056129, 1001038, 'HU', 'Zomba', 1, 'zomba', 46.41084000, 18.56577000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001039, 'HU', 'Vas County', 1, 'vas-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 
(1055309, 1001039, 'HU', 'Bük', 1, 'buk', 47.38486000, 16.75065000),
(1055318, 1001039, 'HU', 'Celldömölk', 1, 'celldomolk', 47.25713000, 17.15027000),
(1055319, 1001039, 'HU', 'Celldömölki Járás', 1, 'celldomolki-jaras', 47.25001000, 17.13209000),
(1055332, 1001039, 'HU', 'Csepreg', 1, 'csepreg', 47.40098000, 16.70881000),
(1055447, 1001039, 'HU', 'Gencsapáti', 1, 'gencsapati', 47.28496000, 16.59575000),
(1055534, 1001039, 'HU', 'Ják', 1, 'jak', 47.14249000, 16.58148000),
(1055538, 1001039, 'HU', 'Jánosháza', 1, 'janoshaza', 47.11937000, 17.16503000),
(1055647, 1001039, 'HU', 'Körmend', 1, 'kormend', 47.01096000, 16.60596000),
(1055648, 1001039, 'HU', 'Körmendi Járás', 1, 'kormendi-jaras', 46.92164000, 16.53291000),
(1055651, 1001039, 'HU', 'Kőszeg', 1, 'koszeg', 47.38922000, 16.54100000),
(1055652, 1001039, 'HU', 'Kőszegi Járás', 1, 'koszegi-jaras', 47.37500000, 16.65650000),
(1055876, 1001039, 'HU', 'Répcelak', 1, 'repcelak', 47.42105000, 17.01795000),
(1055990, 1001039, 'HU', 'Sárvár', 1, 'sarvar', 47.25395000, 16.93525000),
(1055991, 1001039, 'HU', 'Sárvári Járás', 1, 'sarvari-jaras', 47.23868000, 16.93299000),
(1055938, 1001039, 'HU', 'Szentgotthárd', 1, 'szentgotthard', 46.95261000, 16.27358000),
(1055939, 1001039, 'HU', 'Szentgotthárdi Járás', 1, 'szentgotthardi-jaras', 46.93674000, 16.30362000),
(1055966, 1001039, 'HU', 'Szombathely', 1, 'szombathely', 47.23088000, 16.62155000),
(1055967, 1001039, 'HU', 'Szombathelyi Járás', 1, 'szombathelyi-jaras', 47.21037000, 16.63954000),
(1056070, 1001039, 'HU', 'Táplánszentkereszt', 1, 'taplanszentkereszt', 47.19496000, 16.69613000),
(1056092, 1001039, 'HU', 'Vasvár', 1, 'vasvar', 47.04928000, 16.79954000),
(1056093, 1001039, 'HU', 'Vasvári Járás', 1, 'vasvari-jaras', 47.03487000, 16.85939000),
(1056116, 1001039, 'HU', 'Vép', 1, 'vep', 47.23041000, 16.72248000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001062, 'HU', 'Veszprém', 1, 'veszprem');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001054, 'HU', 'Veszprém County', 1, 'veszprem-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 
(1055178, 1001054, 'HU', 'Ajka', 1, 'ajka', 47.10196000, 17.55892000),
(1055179, 1001054, 'HU', 'Ajkai Járás', 1, 'ajkai-jaras', 47.07988000, 17.56375000),
(1055200, 1001054, 'HU', 'Badacsonytomaj', 1, 'badacsonytomaj', 46.80711000, 17.51385000),
(1055212, 1001054, 'HU', 'Balatonalmádi', 1, 'balatonalmadi', 47.03526000, 18.02076000),
(1055213, 1001054, 'HU', 'Balatonalmádi Járás', 1, 'balatonalmadi-jaras', 47.04174000, 18.09617000),
(1055218, 1001054, 'HU', 'Balatonfüred', 1, 'balatonfured', 46.96188000, 17.87187000),
(1055219, 1001054, 'HU', 'Balatonfüredi Járás', 1, 'balatonfuredi-jaras', 46.93952000, 17.79411000),
(1055220, 1001054, 'HU', 'Balatonkenese', 1, 'balatonkenese', 47.04019000, 18.10671000),
(1055241, 1001054, 'HU', 'Berhida', 1, 'berhida', 47.11131000, 18.12948000),
(1055323, 1001054, 'HU', 'Csabrendek', 1, 'csabrendek', 47.01356000, 17.29108000),
(1055335, 1001054, 'HU', 'Csetény', 1, 'cseteny', 47.31806000, 17.99208000),
(1055339, 1001054, 'HU', 'Csopak', 1, 'csopak', 46.97709000, 17.91819000),
(1055360, 1001054, 'HU', 'Devecser', 1, 'devecser', 47.10316000, 17.43802000),
(1055361, 1001054, 'HU', 'Devecseri Járás', 1, 'devecseri-jaras', 47.16836000, 17.32271000),
(1055492, 1001054, 'HU', 'Hajmáskér', 1, 'hajmasker', 47.14513000, 18.01964000),
(1055506, 1001054, 'HU', 'Herend', 1, 'herend', 47.13333000, 17.75000000),
(1055664, 1001054, 'HU', 'Litér', 1, 'liter', 47.10104000, 18.00454000),
(1055766, 1001054, 'HU', 'Nemesvámos', 1, 'nemesvamos', 47.05514000, 17.87477000),
(1056172, 1001054, 'HU', 'Ősi', 1, 'osi', 47.14722000, 18.18833000),
(1055842, 1001054, 'HU', 'Pápa', 1, 'papa', 47.33004000, 17.46740000),
(1055843, 1001054, 'HU', 'Pápai Járás', 1, 'papai-jaras', 47.33769000, 17.49663000),
(1055858, 1001054, 'HU', 'Pétfürdő', 1, 'petfurdo', 47.16667000, 18.11667000),
(1055879, 1001054, 'HU', 'Révfülöp', 1, 'revfulop', 46.82573000, 17.61967000),
(1055999, 1001054, 'HU', 'Sümeg', 1, 'sumeg', 46.97703000, 17.28209000),
(1056000, 1001054, 'HU', 'Sümegi Járás', 1, 'sumegi-jaras', 47.02648000, 17.26779000),
(1055943, 1001054, 'HU', 'Szentkirályszabadja', 1, 'szentkiralyszabadja', 47.05760000, 17.97052000),
(1056009, 1001054, 'HU', 'Tapolca', 1, 'tapolca', 46.88152000, 17.44117000),
(1056010, 1001054, 'HU', 'Tapolcai Járás', 1, 'tapolcai-jaras', 46.89833000, 17.49510000),
(1056020, 1001054, 'HU', 'Tihany', 1, 'tihany', 46.91369000, 17.88918000),
(1056166, 1001054, 'HU', 'Úrkút', 1, 'urkut', 47.08505000, 17.64393000),
(1056112, 1001054, 'HU', 'Várpalota', 1, 'varpalota', 47.19936000, 18.13954000),
(1056113, 1001054, 'HU', 'Várpalotai Járás', 1, 'varpalotai-jaras', 47.18514000, 18.12211000),
(1056100, 1001054, 'HU', 'Veszprém', 1, 'veszprem', 47.09327000, 17.91149000),
(1056101, 1001054, 'HU', 'Veszprémi Járás', 1, 'veszpremi-jaras', 47.09666000, 17.82157000),
(1056138, 1001054, 'HU', 'Zánka', 1, 'zanka', 46.87146000, 17.68473000),
(1056127, 1001054, 'HU', 'Zirc', 1, 'zirc', 47.26362000, 17.87373000),
(1056128, 1001054, 'HU', 'Zirci Járás', 1, 'zirci-jaras', 47.28583000, 17.88412000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001046, 'HU', 'Zala County', 1, 'zala-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 
(1055234, 1001046, 'HU', 'Becsehely', 1, 'becsehely', 46.44755000, 16.77710000),
(1055334, 1001046, 'HU', 'Cserszegtomaj', 1, 'cserszegtomaj', 46.80165000, 17.22096000),
(1055450, 1001046, 'HU', 'Gyenesdiás', 1, 'gyenesdias', 46.77058000, 17.28660000),
(1055519, 1001046, 'HU', 'Hévíz', 1, 'heviz', 46.79031000, 17.18408000),
(1055589, 1001046, 'HU', 'Keszthely', 1, 'keszthely', 46.76812000, 17.24317000),
(1055590, 1001046, 'HU', 'Keszthelyi Járás', 1, 'keszthelyi-jaras', 46.78356000, 17.22381000),
(1055657, 1001046, 'HU', 'Lenti', 1, 'lenti', 46.62403000, 16.53863000),
(1055658, 1001046, 'HU', 'Lenti Járás', 1, 'lenti-jaras', 46.65649000, 16.57443000),
(1055660, 1001046, 'HU', 'Letenye', 1, 'letenye', 46.43301000, 16.72583000),
(1055661, 1001046, 'HU', 'Letenyei Járás', 1, 'letenyei-jaras', 46.50552000, 16.76503000),
(1055717, 1001046, 'HU', 'Murakeresztúr', 1, 'murakeresztur', 46.36422000, 16.88177000),
(1055748, 1001046, 'HU', 'Nagykanizsa', 1, 'nagykanizsa', 46.45347000, 16.99104000),
(1055749, 1001046, 'HU', 'Nagykanizsai Járás', 1, 'nagykanizsai-jaras', 46.51873000, 17.04433000),
(1055804, 1001046, 'HU', 'Pacsa', 1, 'pacsa', 46.71981000, 17.01401000),
(1055984, 1001046, 'HU', 'Sármellék', 1, 'sarmellek', 46.71221000, 17.16865000),
(1056087, 1001046, 'HU', 'Türje', 1, 'turje', 46.98366000, 17.10742000),
(1056104, 1001046, 'HU', 'Vonyarcvashegy', 1, 'vonyarcvashegy', 46.75742000, 17.31172000),
(1056120, 1001046, 'HU', 'Zalaegerszeg', 1, 'zalaegerszeg', 46.84000000, 16.84389000),
(1056121, 1001046, 'HU', 'Zalaegerszegi Járás', 1, 'zalaegerszegi-jaras', 46.80000000, 16.83000000),
(1056122, 1001046, 'HU', 'Zalakomár', 1, 'zalakomar', 46.53795000, 17.18094000),
(1056123, 1001046, 'HU', 'Zalalövő', 1, 'zalalovo', 46.84802000, 16.58750000),
(1056124, 1001046, 'HU', 'Zalaszentgrót', 1, 'zalaszentgrot', 46.94474000, 17.07925000),
(1056125, 1001046, 'HU', 'Zalaszentgróti Járás', 1, 'zalaszentgroti-jaras', 46.92070000, 17.10095000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001050, 'HU', 'Zalaegerszeg', 1, 'zalaegerszeg');

