REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('IS', 'Iceland', 'Ísland', 'iceland', '354', 'ISK');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(6337403, 'IS', 'Northwest', 1, 'northwest'),
(6337404, 'IS', 'Northeast', 1, 'northeast'),
(6337405, 'IS', 'East', 1, 'east'),
(6337406, 'IS', 'South', 1, 'south'),
(6426182, 'IS', 'Capital Region', 1, 'capital-region'),
(6426183, 'IS', 'Southern Peninsula', 1, 'southern-peninsula'),
(6426184, 'IS', 'West', 1, 'west'),
(6426185, 'IS', 'Westfjords', 1, 'westfjords');

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 
(5625189, 6337405, 'IS', 'Vopnafjörður', 1, 'vopnafjoerdur', 65.75658, -14.82777),
(5625252, 6337406, 'IS', 'Vík í Mýrdal', 1, 'vik-i-myrdal', 63.41944, -19.00972),
(5625499, 6337403, 'IS', 'Varmahlíð', 1, 'varmahlid', 65.55303, -19.44609),
(5626002, 6337404, 'IS', 'Þórshöfn', 1, 'thorshoefn', 66.19814, -15.33679),
(5626319, 6337404, 'IS', 'Svalbarðseyri', 1, 'svalbardseyri', 65.74107, -18.07744),
(5626637, 6337404, 'IS', 'Stafn', 1, 'stafn', 65.62849, -17.31908),
(5627130, 6337404, 'IS', 'Siglufjörður', 1, 'siglufjoerdur', 66.15198, -18.90815),
(5627140, 6337405, 'IS', 'Seyðisfjörður', 1, 'seydisfjoerdur', 65.26008, -14.00577),
(5627309, 6337403, 'IS', 'Sauðárkrókur', 1, 'saudarkrokur', 65.74611, -19.63944),
(5627574, 6337404, 'IS', 'Reykjahlíð', 1, 'reykjahlid', 65.64205, -16.91244),
(5627642, 6337404, 'IS', 'Raufarhöfn', 1, 'raufarhoefn', 66.45429, -15.9511),
(5627843, 6337404, 'IS', 'Ólafsfjörður', 1, 'olafsfjoerdur', 66.06722, -18.64399),
(5628020, 6337405, 'IS', 'Neskaupstaður', 1, 'neskaupstadur', 65.14819, -13.68368),
(5628589, 6337404, 'IS', 'Litli-Árskógssandur', 1, 'litli-arskogssandur', 65.94422, -18.35654),
(5629105, 6337404, 'IS', 'Kópasker', 1, 'kopasker', 66.30178, -16.44452),
(5629301, 6337405, 'IS', 'Stöðvarfjörður', 1, 'stoedvarfjoerdur', 64.83296, -13.87492),
(5629306, 6337406, 'IS', 'Kirkjubæjarklaustur', 1, 'kirkjubaejarklaustur', 63.78935, -18.05273),
(5629833, 6337404, 'IS', 'Norðurþing', 1, 'nordurthing', 66.04148, -17.33834),
(5630237, 6337403, 'IS', 'Hólar', 1, 'holar', 65.73079, -19.11164),
(5630277, 6337403, 'IS', 'Hofsós', 1, 'hofsos', 65.89896, -19.41298),
(5630299, 6337405, 'IS', 'Höfn', 1, 'hoefn', 64.25388, -15.21212),
(5630431, 6337404, 'IS', 'Hjalteyri', 1, 'hjalteyri', 65.84817, -18.20127),
(5631153, 6337404, 'IS', 'Grenivík', 1, 'grenivik', 65.95102, -18.17493),
(5632028, 6337405, 'IS', 'Eskifjörður', 1, 'eskifjoerdur', 65.07306, -14.01525),
(5632132, 6337405, 'IS', 'Egilsstaðir', 1, 'egilsstadir', 65.26687, -14.39485),
(5632226, 6337405, 'IS', 'Djúpivogur', 1, 'djupivogur', 64.65713, -14.28517),
(5632287, 6337404, 'IS', 'Dalvík', 1, 'dalvik', 65.97018, -18.52861),
(5632418, 6337405, 'IS', 'Fáskrúðsfjörður', 1, 'faskrudsfjoerdur', 64.93128, -14.0189),
(5632428, 6337405, 'IS', 'Reyðarfjörður', 1, 'reydarfjoerdur', 65.03164, -14.21832),
(5632552, 6337405, 'IS', 'Breiðdalsvík', 1, 'breiddalsvik', 64.79212, -14.0065),
(5632969, 6337404, 'IS', 'Bakkafjörður', 1, 'bakkafjoerdur', 66.03772, -14.79315),
(5633274, 6337404, 'IS', 'Akureyri', 1, 'akureyri', 65.68353, -18.0878),
(6228381, 6337405, 'IS', 'Bakkagerði', 1, 'bakkagerdi', 65.52548, -13.80376),
(6412011, 6426183, 'IS', 'Vogar', 1, 'vogar', 63.9816, -22.38473),
(6412093, 6337406, 'IS', 'Vestmannaeyjar', 1, 'vestmannaeyjar', 63.44273, -20.27339),
(6412173, 6426185, 'IS', 'Patreksfjörður', 1, 'patreksfjoerdur', 65.59783, -23.99596),
(6412460, 6337406, 'IS', 'Þykkvibær', 1, 'thykkvibaer', 63.74256, -20.60912),
(6412589, 6337406, 'IS', 'Þorlákshöfn', 1, 'thorlakshoefn', 63.85591, -21.38337),
(6412655, 6426185, 'IS', 'Þingeyri', 1, 'thingeyri', 65.87899, -23.49289),
(6412878, 6426185, 'IS', 'Suðureyri', 1, 'sudureyri', 66.13041, -23.52804),
(6412887, 6426185, 'IS', 'Súðavík', 1, 'sudavik', 66.03829, -22.98593),
(6412888, 6426184, 'IS', 'Stykkishólmur', 1, 'stykkisholmur', 65.07537, -22.72977),
(6413008, 6337406, 'IS', 'Stokkseyri', 1, 'stokkseyri', 63.83788, -21.0587),
(6413604, 6337406, 'IS', 'Selfoss', 1, 'selfoss', 63.93311, -20.99712),
(6413727, 6426183, 'IS', 'Sandgerði', 1, 'sandgerdi', 64.03762, -22.70799),
(6413821, 6426184, 'IS', 'Rif', 1, 'rif', 64.92245, -23.81802),
(6413829, 6426182, 'IS', 'Reykjavík', 1, 'reykjavik', 64.13548, -21.89541),
(6413876, 6426184, 'IS', 'Reykholt', 1, 'reykholt', 64.66437, -21.2915),
(6413877, 6426185, 'IS', 'Reykhólar', 1, 'reykholar', 65.44612, -22.1899),
(6414079, 6426184, 'IS', 'Ólafsvík', 1, 'olafsvik', 64.89429, -23.70918),
(6414222, 6426183, 'IS', 'Njarðvík', 1, 'njardvik', 63.9809, -22.5145),
(6414856, 6337406, 'IS', 'Laugarvatn', 1, 'laugarvatn', 64.21762, -20.73386),
(6414868, 6337406, 'IS', 'Laugarás', 1, 'laugaras', 64.11555, -20.49381),
(6414979, 6426182, 'IS', 'Seltjarnarnes', 1, 'seltjarnarnes', 64.15309, -21.99499),
(6415021, 6426182, 'IS', 'Mosfellsbær', 1, 'mosfellsbaer', 64.16667, -21.7),
(6415212, 6426182, 'IS', 'Kópavogur', 1, 'kopavogur', 64.11234, -21.91298),
(6415667, 6426185, 'IS', 'Ísafjörður', 1, 'isafjoerdur', 66.07475, -23.13498),
(6415720, 6337406, 'IS', 'Hvolsvöllur', 1, 'hvolsvoellur', 63.75069, -20.22454),
(6415761, 6337406, 'IS', 'Hveragerði', 1, 'hveragerdi', 64.00039, -21.18602),
(6415779, 6426184, 'IS', 'Hvanneyri', 1, 'hvanneyri', 64.56404, -21.7589),
(6415811, 6337403, 'IS', 'Hvammstangi', 1, 'hvammstangi', 65.39711, -20.94346),
(6416144, 6426185, 'IS', 'Hólmavík', 1, 'holmavik', 65.70767, -21.67065),
(6416248, 6337403, 'IS', 'Skagaströnd', 1, 'skagastroend', 65.82319, -20.30248),
(6416267, 6426185, 'IS', 'Hnífsdalur', 1, 'hnifsdalur', 66.11131, -23.12036),
(6416434, 6426184, 'IS', 'Hellnar', 1, 'hellnar', 64.75055, -23.64747),
(6416439, 6426184, 'IS', 'Hellissandur', 1, 'hellissandur', 64.91757, -23.88557),
(6416453, 6337406, 'IS', 'Hella', 1, 'hella', 63.8348, -20.40084),
(6416694, 6426183, 'IS', 'Hafnir', 1, 'hafnir', 63.93319, -22.68212),
(6416706, 6426182, 'IS', 'Hafnarfjörður', 1, 'hafnarfjoerdur', 64.0671, -21.93774),
(6416839, 6426184, 'IS', 'Grundarfjörður', 1, 'grundarfjoerdur', 64.92427, -23.26313),
(6416888, 6426183, 'IS', 'Grindavík', 1, 'grindavik', 63.83849, -22.43931),
(6417079, 6426183, 'IS', 'Garður', 1, 'gardur', 64.07055, -22.6513),
(6417195, 6426182, 'IS', 'Garðabær', 1, 'gardabaer', 64.08865, -21.92298),
(6417363, 6426185, 'IS', 'Flateyri', 1, 'flateyri', 66.05119, -23.51547),
(6417367, 6426185, 'IS', 'Flatey', 1, 'flatey', 65.37587, -22.91785),
(6417528, 6337406, 'IS', 'Eyrarbakki', 1, 'eyrarbakki', 63.86323, -21.14915),
(6417724, 6426185, 'IS', 'Drangsnes', 1, 'drangsnes', 65.68918, -21.44353),
(6417878, 6426184, 'IS', 'Búðardalur', 1, 'budardalur', 65.10944, -21.76392),
(6417929, 6426185, 'IS', 'Brjánslækur', 1, 'brjanslaekur', 65.53, -23.19437),
(6417972, 6426182, 'IS', 'Álftanes', 1, 'alftanes', 64.1, -22.01667),
(6418076, 6426184, 'IS', 'Borgarnes', 1, 'borgarnes', 64.53834, -21.92064),
(6418105, 6426185, 'IS', 'Borðeyri', 1, 'bordeyri', 65.20751, -21.0995),
(6418112, 6426185, 'IS', 'Bolungarvík', 1, 'bolungarvik', 66.15917, -23.24941),
(6418130, 6337403, 'IS', 'Blönduós', 1, 'bloenduos', 65.65932, -20.28083),
(6418226, 6426185, 'IS', 'Bíldudalur', 1, 'bildudalur', 65.6853, -23.59992),
(6418526, 6426184, 'IS', 'Arnarstapi', 1, 'arnarstapi', 64.76936, -23.62258),
(6418653, 6426184, 'IS', 'Akranes', 1, 'akranes', 64.32179, -22.0749),
(9951090, 6337406, 'IS', 'Flúðir', 1, 'fludir', 64.13428, -20.32265),
(11450332, 6337403, 'IS', 'Laugarbakki', 1, 'laugarbakki', 65.32624, -20.89295),
(11643869, 6337405, 'IS', 'Fellabaer', 1, 'fellabaer', 65.28418, -14.42621),
(11643894, 6426182, 'IS', 'Grundarhverfi', 1, 'grundarhverfi', 64.24058, -21.8367),
(11643897, 6337406, 'IS', 'Reykholt', 1, 'reykholt', 64.17829, -20.44161),
(11643899, 6426185, 'IS', 'Talknafjordur', 1, 'talknafjordur', 65.62648, -23.8246),
(11643913, 6337404, 'IS', 'Grímsey', 1, 'grimsey', 66.53938, -18.01348),
(11643914, 6337404, 'IS', 'Hrísey', 1, 'hrisey', 65.97835, -18.37777),
(11643948, 6337404, 'IS', 'Laugar', 1, 'laugar', 65.72159, -17.37352),
(11644037, 6426183, 'IS', 'Reykjanesbær', 1, 'reykjanesbaer', 63.99813, -22.56111),
(11644039, 6337406, 'IS', 'Borg', 1, 'borg', 64.07522, -20.76472),
(12180128, 6337405, 'IS', 'Eidar', 1, 'eidar', 65.37199, -14.34866),
(13630415, 6337404, 'IS', 'Urðir', 1, 'urdir', 65.80496, -18.60535),
(14049327, 6426184, 'IS', 'Saelingsdal', 1, 'saelingsdal', 65.24618, -21.80376),
(14072358, 6426185, 'IS', 'Sæból', 1, 'saebol', 66.04406, -23.70549),
(14103193, 6337403, 'IS', 'Reykir', 1, 'reykir', 65.55391, -20.22308),
(14103247, 6337403, 'IS', 'Rip', 1, 'rip', 65.69038, -19.50863),
(14103248, 6426185, 'IS', 'Árneshreppur', 1, 'arneshreppur', 66.00371, -21.49981),
(14128168, 6426184, 'IS', 'Eyja- og Miklaholtshreppur', 1, 'eyja-og-miklaholtshreppur', 64.83463, -22.57107),
(14153343, 6426185, 'IS', 'Flókalundur', 1, 'flokalundur', 65.57625, -23.16699),
(14184862, 6426184, 'IS', 'Sodulsholt', 1, 'sodulsholt', 64.83514, -22.4346),
(14205273, 6337405, 'IS', 'Hoffell', 1, 'hoffell', 64.39308, -15.39391),
(14205275, 6337403, 'IS', 'Lækjamót', 1, 'laekjamot', 65.41859, -20.601),
(14776642, 6426185, 'IS', 'Vatnsfjordhur', 1, 'vatnsfjordhur', 65.93211, -22.51081);