REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug, s_phone_code, s_name_native, s_currency) VALUES 
('NO', 'Norway', 'norway', '47', 'Norge', 'NOK');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001017, 'NO', 'Akershus', 1, 'akershus');

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 
(1079681, 1001017, 'NO', 'Åneby', 1, 'aneby', 60.08926000, 10.86998000),
(1079684, 1001017, 'NO', 'Årnes', 1, 'arnes', 60.12237000, 11.47005000),
(1079687, 1001017, 'NO', 'Ås', 1, 'as', 59.66366000, 10.79101000),
(1079044, 1001017, 'NO', 'Ask', 1, 'ask', 60.07131000, 11.03620000),
(1079045, 1001017, 'NO', 'Asker', 1, 'asker', 59.83734000, 10.43595000),
(1079051, 1001017, 'NO', 'Auli', 1, 'auli', 60.03450000, 11.36046000),
(1079054, 1001017, 'NO', 'Aurskog-Høland', 1, 'aurskog-holand', 59.88321000, 11.56491000),
(1079055, 1001017, 'NO', 'Aursmoen', 1, 'aursmoen', 59.92763000, 11.44275000),
(1079094, 1001017, 'NO', 'Bærum', 1, 'baerum', 59.88996000, 10.52649000),
(1079073, 1001017, 'NO', 'Billingstad', 1, 'billingstad', 59.87548000, 10.48230000),
(1079078, 1001017, 'NO', 'Bjørkelangen', 1, 'bjorkelangen', 59.88357000, 11.56396000),
(1079080, 1001017, 'NO', 'Blakstad', 1, 'blakstad', 59.81910000, 10.46450000),
(1079106, 1001017, 'NO', 'Drøbak', 1, 'drobak', 59.66333000, 10.62975000),
(1079115, 1001017, 'NO', 'Eidsvoll', 1, 'eidsvoll', 60.32893000, 11.26119000),
(1079123, 1001017, 'NO', 'Enebakk', 1, 'enebakk', 59.76452000, 11.14492000),
(1079132, 1001017, 'NO', 'Fagerstrand', 1, 'fagerstrand', 59.73746000, 10.59404000),
(1079137, 1001017, 'NO', 'Fet', 1, 'fet', 59.92216000, 11.16778000),
(1079138, 1001017, 'NO', 'Fetsund', 1, 'fetsund', 59.92463000, 11.15711000),
(1079145, 1001017, 'NO', 'Fjellfoten', 1, 'fjellfoten', 60.08967000, 11.47222000),
(1079148, 1001017, 'NO', 'Flateby', 1, 'flateby', 59.82951000, 11.15345000),
(1079161, 1001017, 'NO', 'Frogn', 1, 'frogn', 59.66665000, 10.63566000),
(1079162, 1001017, 'NO', 'Frogner', 1, 'frogner', 60.02463000, 11.10284000),
(1079178, 1001017, 'NO', 'Gjerdrum', 1, 'gjerdrum', 60.07159000, 11.03597000),
(1079239, 1001017, 'NO', 'Hurdal', 1, 'hurdal', 60.43518000, 11.06707000),
(1079256, 1001017, 'NO', 'Jessheim', 1, 'jessheim', 60.14151000, 11.17515000),
(1079276, 1001017, 'NO', 'Kløfta', 1, 'klofta', 60.07407000, 11.13805000),
(1079310, 1001017, 'NO', 'Leirsund', 1, 'leirsund', 59.99682000, 11.08746000),
(1079324, 1001017, 'NO', 'Lillestrøm', 1, 'lillestrom', 59.95597000, 11.04918000),
(1079346, 1001017, 'NO', 'Lørenskog', 1, 'lorenskog', 59.93209000, 10.96079000),
(1079340, 1001017, 'NO', 'Lysaker', 1, 'lysaker', 59.90994000, 10.63545000),
(1079355, 1001017, 'NO', 'Maura', 1, 'maura', 60.25830000, 11.03192000),
(1079385, 1001017, 'NO', 'Nannestad', 1, 'nannestad', 60.21707000, 11.01200000),
(1079389, 1001017, 'NO', 'Nes', 1, 'nes', 60.12252000, 11.46570000),
(1079392, 1001017, 'NO', 'Neskollen', 1, 'neskollen', 60.12159000, 11.33926000),
(1079394, 1001017, 'NO', 'Nesodden', 1, 'nesodden', 59.84220000, 10.64940000),
(1079395, 1001017, 'NO', 'Nesoddtangen', 1, 'nesoddtangen', 59.86244000, 10.66308000),
(1079399, 1001017, 'NO', 'Nittedal', 1, 'nittedal', 60.04278000, 10.88167000),
(1079420, 1001017, 'NO', 'Oppegård', 1, 'oppegard', 59.81149000, 10.79712000),
(1079464, 1001017, 'NO', 'Råholt', 1, 'raholt', 60.27513000, 11.17901000),
(1079465, 1001017, 'NO', 'Rælingen', 1, 'raelingen', 59.92626000, 11.06527000),
(1079458, 1001017, 'NO', 'Rotnes', 1, 'rotnes', 60.05707000, 10.86135000),
(1079506, 1001017, 'NO', 'Skedsmo', 1, 'skedsmo', 59.95448000, 11.03952000),
(1079507, 1001017, 'NO', 'Ski', 1, 'ski', 59.72049000, 10.83882000),
(1079522, 1001017, 'NO', 'Skui', 1, 'skui', 59.92746000, 10.44750000),
(1079586, 1001017, 'NO', 'Sørum', 1, 'sorum', 59.98709000, 11.24019000),
(1079587, 1001017, 'NO', 'Sørumsand', 1, 'sorumsand', 59.98621000, 11.24154000),
(1079621, 1001017, 'NO', 'Ullensaker', 1, 'ullensaker', 60.14401000, 11.17441000),
(1079642, 1001017, 'NO', 'Vestby', 1, 'vestby', 59.60228000, 10.74807000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001011, 'NO', 'Buskerud', 1, 'buskerud');

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 
(1079677, 1001011, 'NO', 'Ål', 1, 'al', 60.63028000, 8.56115000),
(1079685, 1001011, 'NO', 'Åros', 1, 'aros', 59.70610000, 10.51092000),
(1079104, 1001011, 'NO', 'Drammen', 1, 'drammen', 59.74389000, 10.20449000),
(1079153, 1001011, 'NO', 'Flå', 1, 'fla', 60.42910000, 9.46611000),
(1079150, 1001011, 'NO', 'Flesberg', 1, 'flesberg', 59.83283000, 9.58308000),
(1079174, 1001011, 'NO', 'Geilo', 1, 'geilo', 60.53369000, 8.20539000),
(1079184, 1001011, 'NO', 'Gol', 1, 'gol', 60.69953000, 8.95024000),
(1079217, 1001011, 'NO', 'Hemsedal', 1, 'hemsedal', 60.86114000, 8.56537000),
(1079227, 1001011, 'NO', 'Hol', 1, 'hol', 60.61528000, 8.30194000),
(1079228, 1001011, 'NO', 'Hole', 1, 'hole', 60.08017000, 10.27840000),
(1079247, 1001011, 'NO', 'Hønefoss', 1, 'honefoss', 60.16804000, 10.25647000),
(1079240, 1001011, 'NO', 'Hurum', 1, 'hurum', 59.61401000, 10.45763000),
(1079242, 1001011, 'NO', 'Hvittingfoss', 1, 'hvittingfoss', 59.48572000, 10.01173000),
(1079281, 1001011, 'NO', 'Kongsberg', 1, 'kongsberg', 59.66516000, 9.64653000),
(1079289, 1001011, 'NO', 'Krødsherad', 1, 'krodsherad', 60.17944000, 9.62124000),
(1079320, 1001011, 'NO', 'Lier', 1, 'lier', 59.78663000, 10.24590000),
(1079368, 1001011, 'NO', 'Modum', 1, 'modum', 59.97346000, 10.00468000),
(1079388, 1001011, 'NO', 'Nedre Eiker', 1, 'nedre-eiker', 59.75023000, 10.00736000),
(1079390, 1001011, 'NO', 'Nes', 1, 'nes', 60.56804000, 9.10169000),
(1079391, 1001011, 'NO', 'Nesbyen', 1, 'nesbyen', 60.56809000, 9.10274000),
(1079411, 1001011, 'NO', 'Nore og Uvdal', 1, 'nore-og-uvdal', 60.26706000, 8.94635000),
(1079412, 1001011, 'NO', 'Noresund', 1, 'noresund', 60.17985000, 9.62411000),
(1079700, 1001011, 'NO', 'Øvre Eiker', 1, 'ovre-eiker', 59.77111000, 9.90840000),
(1079432, 1001011, 'NO', 'Prestfoss', 1, 'prestfoss', 60.04343000, 9.63520000),
(1079451, 1001011, 'NO', 'Ringerike', 1, 'ringerike', 60.16018000, 10.25660000),
(1079456, 1001011, 'NO', 'Rollag', 1, 'rollag', 59.98413000, 9.29489000),
(1079471, 1001011, 'NO', 'Røyken', 1, 'royken', 59.74019000, 10.41321000),
(1079574, 1001011, 'NO', 'Sætre', 1, 'saetre', 59.68129000, 10.52749000),
(1079497, 1001011, 'NO', 'Sigdal', 1, 'sigdal', 60.04592000, 9.63673000),
(1079515, 1001011, 'NO', 'Skoger', 1, 'skoger', 59.71327000, 10.25356000),
(1079597, 1001011, 'NO', 'Tofte', 1, 'tofte', 59.54275000, 10.56138000),
(1079604, 1001011, 'NO', 'Tranby', 1, 'tranby', 59.80850000, 10.26114000),
(1079653, 1001011, 'NO', 'Vikersund', 1, 'vikersund', 59.96838000, 9.99107000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001016, 'NO', 'Finnmark', 1, 'finnmark');

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 
(1079039, 1001016, 'NO', 'Alta', 1, 'alta', 69.97675000, 23.29634000),
(1079672, 1001016, 'NO', 'Ávanuorri', 1, 'avanuorri', 70.99634000, 24.66217000),
(1079093, 1001016, 'NO', 'Båtsfjord', 1, 'batsfjord', 70.63428000, 29.71750000),
(1079072, 1001016, 'NO', 'Berlevåg', 1, 'berlevag', 70.85778000, 29.08636000),
(1079079, 1001016, 'NO', 'Bjørnevatn', 1, 'bjornevatn', 69.66745000, 29.98722000),
(1079170, 1001016, 'NO', 'Gamvik', 1, 'gamvik', 71.04107000, 27.85144000),
(1079203, 1001016, 'NO', 'Hammerfest', 1, 'hammerfest', 70.66257000, 23.68295000),
(1079209, 1001016, 'NO', 'Hasvik', 1, 'hasvik', 70.59164000, 22.30272000),
(1079233, 1001016, 'NO', 'Honningsvåg', 1, 'honningsvag', 70.98209000, 25.97037000),
(1079299, 1001016, 'NO', 'Kárášjohka', 1, 'karasjohka', 69.47187000, 25.51122000),
(1079264, 1001016, 'NO', 'Karasjok', 1, 'karasjok', 69.47224000, 25.51885000),
(1079268, 1001016, 'NO', 'Kautokeino', 1, 'kautokeino', 69.01151000, 23.04151000),
(1079270, 1001016, 'NO', 'Kirkenes', 1, 'kirkenes', 69.72706000, 30.04578000),
(1079272, 1001016, 'NO', 'Kjøllefjord', 1, 'kjollefjord', 70.94574000, 27.34650000),
(1079290, 1001016, 'NO', 'Kvalsund', 1, 'kvalsund', 70.49910000, 23.97393000),
(1079301, 1001016, 'NO', 'Lakselv', 1, 'lakselv', 70.05133000, 24.97182000),
(1079307, 1001016, 'NO', 'Lebesby', 1, 'lebesby', 70.94535000, 27.35134000),
(1079329, 1001016, 'NO', 'Loppa', 1, 'loppa', 70.23952000, 22.35136000),
(1079381, 1001016, 'NO', 'Måsøy', 1, 'masoy', 70.99654000, 24.66146000),
(1079356, 1001016, 'NO', 'Mehamn', 1, 'mehamn', 71.04137000, 27.85133000),
(1079396, 1001016, 'NO', 'Nesseby', 1, 'nesseby', 69.88541000, 28.43368000),
(1079407, 1001016, 'NO', 'Nordkapp', 1, 'nordkapp', 70.97808000, 25.97473000),
(1079691, 1001016, 'NO', 'Øksfjord', 1, 'oksfjord', 70.23936000, 22.35070000),
(1079429, 1001016, 'NO', 'Porsanger', 1, 'porsanger', 70.05214000, 24.95592000),
(1079462, 1001016, 'NO', 'Rypefjord', 1, 'rypefjord', 70.64126000, 23.67213000),
(1079582, 1001016, 'NO', 'Sør-Varanger', 1, 'sor-varanger', 69.72859000, 30.04264000),
(1079588, 1001016, 'NO', 'Tana', 1, 'tana', 70.19976000, 28.18494000),
(1079628, 1001016, 'NO', 'Vadsø', 1, 'vadso', 70.07412000, 29.74922000),
(1079633, 1001016, 'NO', 'Vardø', 1, 'vardo', 70.37040000, 31.10866000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001019, 'NO', 'Hedmark', 1, 'hedmark');

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 
(1079040, 1001019, 'NO', 'Alvdal', 1, 'alvdal', 62.10854000, 10.63483000),
(1079679, 1001019, 'NO', 'Åmot', 1, 'amot', 61.13199000, 11.37328000),
(1079690, 1001019, 'NO', 'Åsnes', 1, 'asnes', 60.61363000, 12.01200000),
(1079089, 1001019, 'NO', 'Brumunddal', 1, 'brumunddal', 60.88095000, 10.93948000),
(1079114, 1001019, 'NO', 'Eidskog', 1, 'eidskog', 59.98556000, 12.12502000),
(1079122, 1001019, 'NO', 'Elverum', 1, 'elverum', 60.88159000, 11.56314000),
(1079124, 1001019, 'NO', 'Engerdal', 1, 'engerdal', 61.75774000, 11.95966000),
(1079154, 1001019, 'NO', 'Folldal', 1, 'folldal', 62.13329000, 9.99710000),
(1079192, 1001019, 'NO', 'Grue', 1, 'grue', 60.45133000, 12.05489000),
(1079201, 1001019, 'NO', 'Hamar', 1, 'hamar', 60.79450000, 11.06798000),
(1079254, 1001019, 'NO', 'Innbygda', 1, 'innbygda', 61.31484000, 12.26374000),
(1079271, 1001019, 'NO', 'Kirkenær', 1, 'kirkenaer', 60.45790000, 12.05855000),
(1079282, 1001019, 'NO', 'Kongsvinger', 1, 'kongsvinger', 60.19117000, 11.99916000),
(1079284, 1001019, 'NO', 'Koppang', 1, 'koppang', 61.57219000, 11.04659000),
(1079347, 1001019, 'NO', 'Løten', 1, 'loten', 60.81771000, 11.34373000),
(1079369, 1001019, 'NO', 'Moelv', 1, 'moelv', 60.93333000, 10.70000000),
(1079404, 1001019, 'NO', 'Nord-Odal', 1, 'nord-odal', 60.39195000, 11.54151000),
(1079422, 1001019, 'NO', 'Os', 1, 'os', 62.49536000, 11.22807000),
(1079444, 1001019, 'NO', 'Rena', 1, 'rena', 61.13222000, 11.37156000),
(1079445, 1001019, 'NO', 'Rendalen', 1, 'rendalen', 61.89004000, 11.07694000),
(1079452, 1001019, 'NO', 'Ringsaker', 1, 'ringsaker', 60.88216000, 10.95030000),
(1079477, 1001019, 'NO', 'Sand', 1, 'sand', 60.39220000, 11.54030000),
(1079504, 1001019, 'NO', 'Skarnes', 1, 'skarnes', 60.25391000, 11.68485000),
(1079519, 1001019, 'NO', 'Skotterud', 1, 'skotterud', 59.98281000, 12.12825000),
(1079581, 1001019, 'NO', 'Sør-Odal', 1, 'sor-odal', 60.25455000, 11.68246000),
(1079535, 1001019, 'NO', 'Spetalen', 1, 'spetalen', 60.18333000, 11.90000000),
(1079537, 1001019, 'NO', 'Stange', 1, 'stange', 60.71576000, 11.19069000),
(1079547, 1001019, 'NO', 'Stor-Elvdal', 1, 'stor-elvdal', 61.57198000, 11.04759000),
(1079599, 1001019, 'NO', 'Tolga', 1, 'tolga', 62.40984000, 10.99770000),
(1079610, 1001019, 'NO', 'Trysil', 1, 'trysil', 61.31549000, 12.26422000),
(1079615, 1001019, 'NO', 'Tynset', 1, 'tynset', 62.27387000, 10.77626000),
(1079667, 1001019, 'NO', 'Våler', 1, 'valer', 60.67845000, 11.83314000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001023, 'NO', 'Hordaland', 1, 'hordaland');

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 
(1079675, 1001023, 'NO', 'Ågotnes', 1, 'agotnes', 60.40306000, 5.01927000),
(1079048, 1001023, 'NO', 'Askøy', 1, 'askoy', 60.40916000, 5.22599000),
(1079056, 1001023, 'NO', 'Austevoll', 1, 'austevoll', 60.09578000, 5.22722000),
(1079057, 1001023, 'NO', 'Austrheim', 1, 'austrheim', 60.77742000, 4.93227000),
(1079069, 1001023, 'NO', 'Bergen', 1, 'bergen', 60.39200000, 5.32800000),
(1079097, 1001023, 'NO', 'Bømlo', 1, 'bomlo', 59.79384000, 5.17624000),
(1079098, 1001023, 'NO', 'Dale', 1, 'dale', 60.58639000, 5.81888000),
(1079112, 1001023, 'NO', 'Eidfjord', 1, 'eidfjord', 60.46741000, 7.06971000),
(1079119, 1001023, 'NO', 'Eikelandsosen', 1, 'eikelandsosen', 60.24175000, 5.74433000),
(1079125, 1001023, 'NO', 'Espeland', 1, 'espeland', 60.38249000, 5.46570000),
(1079126, 1001023, 'NO', 'Etne', 1, 'etne', 59.66472000, 5.93438000),
(1079136, 1001023, 'NO', 'Fedje', 1, 'fedje', 60.77873000, 4.71965000),
(1079142, 1001023, 'NO', 'Fitjar', 1, 'fitjar', 59.91742000, 5.31637000),
(1079144, 1001023, 'NO', 'Fjell', 1, 'fjell', 60.36267000, 5.12194000),
(1079160, 1001023, 'NO', 'Frekhaug', 1, 'frekhaug', 60.51321000, 5.24252000),
(1079166, 1001023, 'NO', 'Fusa', 1, 'fusa', 60.24072000, 5.74458000),
(1079187, 1001023, 'NO', 'Granvin', 1, 'granvin', 60.52629000, 6.72178000),
(1079198, 1001023, 'NO', 'Hagavik', 1, 'hagavik', 60.18076000, 5.40146000),
(1079243, 1001023, 'NO', 'Hylkje', 1, 'hylkje', 60.51028000, 5.35444000),
(1079252, 1001023, 'NO', 'Indre Arna', 1, 'indre-arna', 60.41768000, 5.47087000),
(1079258, 1001023, 'NO', 'Jondal', 1, 'jondal', 60.27620000, 6.25257000),
(1079269, 1001023, 'NO', 'Kinsarvik', 1, 'kinsarvik', 60.37567000, 6.71948000),
(1079277, 1001023, 'NO', 'Knappskog', 1, 'knappskog', 60.37906000, 5.05602000),
(1079279, 1001023, 'NO', 'Knarvik', 1, 'knarvik', 60.54530000, 5.28208000),
(1079291, 1001023, 'NO', 'Kvam', 1, 'kvam', 60.36977000, 6.14344000),
(1079293, 1001023, 'NO', 'Kvinnherad', 1, 'kvinnherad', 59.98421000, 6.01227000),
(1079311, 1001023, 'NO', 'Leirvik', 1, 'leirvik', 59.77977000, 5.50051000),
(1079326, 1001023, 'NO', 'Lindås', 1, 'lindas', 60.54910000, 5.28559000),
(1079328, 1001023, 'NO', 'Lonevåg', 1, 'lonevag', 60.52556000, 5.49563000),
(1079351, 1001023, 'NO', 'Manger', 1, 'manger', 60.64145000, 5.04136000),
(1079354, 1001023, 'NO', 'Masfjorden', 1, 'masfjorden', 60.79947000, 5.30035000),
(1079357, 1001023, 'NO', 'Meland', 1, 'meland', 60.51777000, 5.24063000),
(1079367, 1001023, 'NO', 'Modalen', 1, 'modalen', 60.81735000, 5.80790000),
(1079376, 1001023, 'NO', 'Mosterhamn', 1, 'mosterhamn', 59.69919000, 5.38585000),
(1079413, 1001023, 'NO', 'Norheimsund', 1, 'norheimsund', 60.37089000, 6.14562000),
(1079417, 1001023, 'NO', 'Odda', 1, 'odda', 60.06697000, 6.54541000),
(1079423, 1001023, 'NO', 'Os', 1, 'os', 60.18547000, 5.46962000),
(1079426, 1001023, 'NO', 'Osterøy', 1, 'osteroy', 60.52389000, 5.50551000),
(1079702, 1001023, 'NO', 'Øygarden', 1, 'oygarden', 60.59041000, 4.83890000),
(1079703, 1001023, 'NO', 'Øystese', 1, 'oystese', 60.38825000, 6.19251000),
(1079434, 1001023, 'NO', 'Radøy', 1, 'radoy', 60.64187000, 5.04110000),
(1079457, 1001023, 'NO', 'Rosendal', 1, 'rosendal', 59.98589000, 6.01157000),
(1079459, 1001023, 'NO', 'Rubbestadneset', 1, 'rubbestadneset', 59.81559000, 5.26822000),
(1079473, 1001023, 'NO', 'Sagvåg', 1, 'sagvag', 59.78139000, 5.38996000),
(1079476, 1001023, 'NO', 'Samnanger', 1, 'samnanger', 60.37745000, 5.76219000),
(1079485, 1001023, 'NO', 'Sandsli', 1, 'sandsli', 60.30323000, 5.28554000),
(1079517, 1001023, 'NO', 'Skogsvågen', 1, 'skogsvagen', 60.25512000, 5.10161000),
(1079548, 1001023, 'NO', 'Stord', 1, 'stord', 59.78092000, 5.49980000),
(1079550, 1001023, 'NO', 'Storebø', 1, 'storebo', 60.09485000, 5.22705000),
(1079558, 1001023, 'NO', 'Straume', 1, 'straume', 60.36131000, 5.12199000),
(1079564, 1001023, 'NO', 'Sund', 1, 'sund', 60.27019000, 5.07225000),
(1079568, 1001023, 'NO', 'Sveio', 1, 'sveio', 59.54303000, 5.35410000),
(1079572, 1001023, 'NO', 'Syfteland', 1, 'syfteland', 60.23803000, 5.45285000),
(1079617, 1001023, 'NO', 'Tysnes', 1, 'tysnes', 60.04076000, 5.53129000),
(1079622, 1001023, 'NO', 'Ullensvang', 1, 'ullensvang', 60.37501000, 6.72073000),
(1079626, 1001023, 'NO', 'Ulvik', 1, 'ulvik', 60.56719000, 6.91871000),
(1079629, 1001023, 'NO', 'Vaksdal', 1, 'vaksdal', 60.59030000, 5.82272000),
(1079662, 1001023, 'NO', 'Voss', 1, 'voss', 60.62780000, 6.41831000),
(1079670, 1001023, 'NO', 'Ytre Arna', 1, 'ytre-arna', 60.46175000, 5.43265000),
(1079671, 1001023, 'NO', 'Ytrebygda', 1, 'ytrebygda', 60.30504000, 5.28236000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001026, 'NO', 'Jan Mayen', 1, 'jan-mayen');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001020, 'NO', 'Møre og Romsdal', 1, 'more-og-romsdal');

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 
(1079678, 1001020, 'NO', 'Ålesund', 1, 'alesund', 62.47225000, 6.15492000),
(1079680, 1001020, 'NO', 'Åndalsnes', 1, 'andalsnes', 62.56749000, 7.68709000),
(1079050, 1001020, 'NO', 'Aukra', 1, 'aukra', 62.80500000, 6.88722000),
(1079052, 1001020, 'NO', 'Aure', 1, 'aure', 63.26750000, 8.52778000),
(1079058, 1001020, 'NO', 'Averøy', 1, 'averoy', 63.05344000, 7.63265000),
(1079066, 1001020, 'NO', 'Batnfjordsøra', 1, 'batnfjordsora', 62.89463000, 7.67251000),
(1079086, 1001020, 'NO', 'Brattvåg', 1, 'brattvag', 62.59991000, 6.44426000),
(1079111, 1001020, 'NO', 'Eide', 1, 'eide', 62.91570000, 7.44496000),
(1079116, 1001020, 'NO', 'Eidsvåg', 1, 'eidsvag', 62.77656000, 8.06550000),
(1079121, 1001020, 'NO', 'Elnesvågen', 1, 'elnesvagen', 62.85426000, 7.13769000),
(1079164, 1001020, 'NO', 'Fræna', 1, 'fraena', 62.85375000, 7.15380000),
(1079176, 1001020, 'NO', 'Giske', 1, 'giske', 62.50070000, 6.13472000),
(1079177, 1001020, 'NO', 'Gjemnes', 1, 'gjemnes', 62.89379000, 7.67714000),
(1079200, 1001020, 'NO', 'Halsa', 1, 'halsa', 63.11855000, 8.31536000),
(1079205, 1001020, 'NO', 'Haram', 1, 'haram', 62.59898000, 6.44483000),
(1079207, 1001020, 'NO', 'Hareid', 1, 'hareid', 62.36742000, 6.02114000),
(1079221, 1001020, 'NO', 'Herøy', 1, 'heroy', 62.33333000, 5.63598000),
(1079225, 1001020, 'NO', 'Hjelset', 1, 'hjelset', 62.78050000, 7.49277000),
(1079234, 1001020, 'NO', 'Hopen', 1, 'hopen', 63.46539000, 8.01437000),
(1079288, 1001020, 'NO', 'Kristiansund', 1, 'kristiansund', 63.11152000, 7.73198000),
(1079303, 1001020, 'NO', 'Larsnes', 1, 'larsnes', 62.20282000, 5.57729000),
(1079364, 1001020, 'NO', 'Midsund', 1, 'midsund', 62.67614000, 6.67776000),
(1079372, 1001020, 'NO', 'Molde', 1, 'molde', 62.73807000, 7.15882000),
(1079397, 1001020, 'NO', 'Nesset', 1, 'nesset', 62.77619000, 8.06623000),
(1079405, 1001020, 'NO', 'Norddal', 1, 'norddal', 62.29910000, 7.26145000),
(1079410, 1001020, 'NO', 'Nordstranda', 1, 'nordstranda', 62.51384000, 6.13166000),
(1079697, 1001020, 'NO', 'Ørskog', 1, 'orskog', 62.48450000, 6.82025000),
(1079698, 1001020, 'NO', 'Ørsta', 1, 'orsta', 62.19937000, 6.13084000),
(1079440, 1001020, 'NO', 'Rauma', 1, 'rauma', 62.56810000, 7.68612000),
(1079448, 1001020, 'NO', 'Rensvik', 1, 'rensvik', 63.09843000, 7.82026000),
(1079481, 1001020, 'NO', 'Sande', 1, 'sande', 62.20455000, 5.57971000),
(1079486, 1001020, 'NO', 'Sandøy', 1, 'sandoy', 62.78167000, 6.46875000),
(1079501, 1001020, 'NO', 'Sjøholt', 1, 'sjoholt', 62.48263000, 6.81376000),
(1079514, 1001020, 'NO', 'Skodje', 1, 'skodje', 62.50306000, 6.69817000),
(1079525, 1001020, 'NO', 'Smøla', 1, 'smola', 63.46526000, 8.01814000),
(1079542, 1001020, 'NO', 'Steinshamn', 1, 'steinshamn', 62.78389000, 6.47065000),
(1079549, 1001020, 'NO', 'Stordal', 1, 'stordal', 62.38214000, 6.98708000),
(1079556, 1001020, 'NO', 'Stranda', 1, 'stranda', 62.31132000, 6.93115000),
(1079562, 1001020, 'NO', 'Sula', 1, 'sula', 62.44447000, 6.21229000),
(1079565, 1001020, 'NO', 'Sunndal', 1, 'sunndal', 62.67464000, 8.56188000),
(1079566, 1001020, 'NO', 'Sunndalsøra', 1, 'sunndalsora', 62.67519000, 8.56327000),
(1079567, 1001020, 'NO', 'Surnadal', 1, 'surnadal', 62.97533000, 8.72490000),
(1079573, 1001020, 'NO', 'Sykkylven', 1, 'sykkylven', 62.38962000, 6.57825000),
(1079593, 1001020, 'NO', 'Tingvoll', 1, 'tingvoll', 62.91194000, 8.20673000),
(1079600, 1001020, 'NO', 'Tomra', 1, 'tomra', 62.58118000, 6.93106000),
(1079623, 1001020, 'NO', 'Ulstein', 1, 'ulstein', 62.34423000, 5.85241000),
(1079624, 1001020, 'NO', 'Ulsteinvik', 1, 'ulsteinvik', 62.34317000, 5.84869000),
(1079625, 1001020, 'NO', 'Ulsteinvik weather pws station', 1, 'ulsteinvik-weather-pws-station', 62.34338000, 5.84385000),
(1079632, 1001020, 'NO', 'Vanylven', 1, 'vanylven', 62.10003000, 5.55827000),
(1079635, 1001020, 'NO', 'Vatne', 1, 'vatne', 62.55826000, 6.61708000),
(1079644, 1001020, 'NO', 'Vestnes', 1, 'vestnes', 62.62130000, 7.08966000),
(1079660, 1001020, 'NO', 'Volda', 1, 'volda', 62.14678000, 6.06800000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001012, 'NO', 'Nord-Trøndelag', 1, 'nord-trondelag');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001025, 'NO', 'Nordland', 1, 'nordland');

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 
(1079038, 1001025, 'NO', 'Alstahaug', 1, 'alstahaug', 65.97556000, 12.56836000),
(1079041, 1001025, 'NO', 'Andenes', 1, 'andenes', 69.31428000, 16.11939000),
(1079042, 1001025, 'NO', 'Andøy', 1, 'andoy', 69.08033000, 15.77637000),
(1079061, 1001025, 'NO', 'Ballangen', 1, 'ballangen', 68.34365000, 16.83317000),
(1079067, 1001025, 'NO', 'Beiarn', 1, 'beiarn', 67.00725000, 14.57304000),
(1079074, 1001025, 'NO', 'Bindal', 1, 'bindal', 65.08780000, 12.37747000),
(1079076, 1001025, 'NO', 'Bjerkvik', 1, 'bjerkvik', 68.54917000, 17.55709000),
(1079081, 1001025, 'NO', 'Bodø', 1, 'bodo', 67.28325000, 14.38319000),
(1079082, 1001025, 'NO', 'Bogen', 1, 'bogen', 68.52647000, 16.99280000),
(1079096, 1001025, 'NO', 'Bø', 1, 'bo', 68.68823000, 14.47899000),
(1079091, 1001025, 'NO', 'Brønnøy', 1, 'bronnoy', 65.46786000, 12.20626000),
(1079092, 1001025, 'NO', 'Brønnøysund', 1, 'bronnoysund', 65.47487000, 12.21285000),
(1079108, 1001025, 'NO', 'Dønna', 1, 'donna', 66.10606000, 12.48189000),
(1079128, 1001025, 'NO', 'Evenes', 1, 'evenes', 68.52334000, 17.00888000),
(1079130, 1001025, 'NO', 'Evjen', 1, 'evjen', 68.26667000, 13.73333000),
(1079135, 1001025, 'NO', 'Fauske', 1, 'fauske', 67.25963000, 15.39410000),
(1079146, 1001025, 'NO', 'Flakstad', 1, 'flakstad', 68.09292000, 13.23310000),
(1079175, 1001025, 'NO', 'Gildeskål', 1, 'gildeskal', 67.03394000, 14.02582000),
(1079181, 1001025, 'NO', 'Gladstad', 1, 'gladstad', 65.67683000, 11.96218000),
(1079182, 1001025, 'NO', 'Glomfjord', 1, 'glomfjord', 66.81663000, 13.94404000),
(1079186, 1001025, 'NO', 'Grane', 1, 'grane', 65.53865000, 13.38499000),
(1079189, 1001025, 'NO', 'Gravdal', 1, 'gravdal', 68.11832000, 13.55339000),
(1079197, 1001025, 'NO', 'Hadsel', 1, 'hadsel', 68.56328000, 14.90835000),
(1079202, 1001025, 'NO', 'Hamarøy', 1, 'hamaroy', 68.08381000, 15.61671000),
(1079210, 1001025, 'NO', 'Hattfjelldal', 1, 'hattfjelldal', 65.59765000, 13.98948000),
(1079213, 1001025, 'NO', 'Hauknes', 1, 'hauknes', 66.28333000, 14.06667000),
(1079215, 1001025, 'NO', 'Hemnes', 1, 'hemnes', 66.07712000, 13.81350000),
(1079216, 1001025, 'NO', 'Hemnesberget', 1, 'hemnesberget', 66.22489000, 13.61643000),
(1079220, 1001025, 'NO', 'Herøy', 1, 'heroy', 65.98427000, 12.28916000),
(1079255, 1001025, 'NO', 'Inndyr', 1, 'inndyr', 67.03353000, 14.02663000),
(1079263, 1001025, 'NO', 'Kabelvåg', 1, 'kabelvag', 68.21066000, 14.47554000),
(1079273, 1001025, 'NO', 'Kjøpsvik', 1, 'kjopsvik', 68.09696000, 16.37416000),
(1079285, 1001025, 'NO', 'Korgen', 1, 'korgen', 66.07662000, 13.82160000),
(1079309, 1001025, 'NO', 'Leirfjord', 1, 'leirfjord', 66.06348000, 12.93667000),
(1079313, 1001025, 'NO', 'Leknes', 1, 'leknes', 68.14746000, 13.61151000),
(1079314, 1001025, 'NO', 'Leland', 1, 'leland', 66.06406000, 12.94325000),
(1079343, 1001025, 'NO', 'Løding', 1, 'loding', 67.30055000, 14.73852000),
(1079344, 1001025, 'NO', 'Lødingen', 1, 'lodingen', 68.40998000, 15.99012000),
(1079345, 1001025, 'NO', 'Løpsmarka', 1, 'lopsmarka', 67.31343000, 14.44934000),
(1079334, 1001025, 'NO', 'Lurøy', 1, 'luroy', 66.41887000, 12.84248000),
(1079358, 1001025, 'NO', 'Melbu', 1, 'melbu', 68.50246000, 14.79962000),
(1079362, 1001025, 'NO', 'Meløy', 1, 'meloy', 66.87204000, 13.70763000),
(1079366, 1001025, 'NO', 'Mo i Rana', 1, 'mo-i-rana', 66.31278000, 14.14278000),
(1079373, 1001025, 'NO', 'Mosjøen', 1, 'mosjoen', 65.83599000, 13.19076000),
(1079374, 1001025, 'NO', 'Moskenes', 1, 'moskenes', 67.93467000, 13.09109000),
(1079377, 1001025, 'NO', 'Myre', 1, 'myre', 68.91400000, 15.07843000),
(1079386, 1001025, 'NO', 'Narvik', 1, 'narvik', 68.43896000, 17.42775000),
(1079393, 1001025, 'NO', 'Nesna', 1, 'nesna', 66.19796000, 13.02229000),
(1079692, 1001025, 'NO', 'Øksnes', 1, 'oksnes', 68.91463000, 15.08703000),
(1079696, 1001025, 'NO', 'Ørnes', 1, 'ornes', 66.86878000, 13.70579000),
(1079436, 1001025, 'NO', 'Rana', 1, 'rana', 66.31122000, 14.13996000),
(1079442, 1001025, 'NO', 'Reine', 1, 'reine', 67.93249000, 13.08955000),
(1079455, 1001025, 'NO', 'Rognan', 1, 'rognan', 67.10021000, 15.39086000),
(1079466, 1001025, 'NO', 'Rødøy', 1, 'rodoy', 66.71195000, 13.28530000),
(1079470, 1001025, 'NO', 'Røst', 1, 'rost', 67.51727000, 12.11564000),
(1079475, 1001025, 'NO', 'Saltdal', 1, 'saltdal', 67.10144000, 15.39458000),
(1079484, 1001025, 'NO', 'Sandnessjøen', 1, 'sandnessjoen', 66.02166000, 12.63158000),
(1079534, 1001025, 'NO', 'Sortland', 1, 'sortland', 68.69618000, 15.41174000),
(1079577, 1001025, 'NO', 'Sømna', 1, 'somna', 65.31379000, 12.16729000),
(1079583, 1001025, 'NO', 'Sørfold', 1, 'sorfold', 67.34803000, 15.59445000),
(1079584, 1001025, 'NO', 'Sørland', 1, 'sorland', 67.66564000, 12.69784000),
(1079540, 1001025, 'NO', 'Steigen', 1, 'steigen', 67.77625000, 15.01621000),
(1079546, 1001025, 'NO', 'Stokmarknes', 1, 'stokmarknes', 68.56462000, 14.91075000),
(1079557, 1001025, 'NO', 'Straume', 1, 'straume', 68.68880000, 14.47205000),
(1079560, 1001025, 'NO', 'Straumen', 1, 'straumen', 67.34769000, 15.60493000),
(1079571, 1001025, 'NO', 'Svolvær', 1, 'svolvaer', 68.23417000, 14.56834000),
(1079591, 1001025, 'NO', 'Terråk', 1, 'terrak', 65.08700000, 12.37148000),
(1079595, 1001025, 'NO', 'Tjeldsund', 1, 'tjeldsund', 68.55557000, 16.36172000),
(1079611, 1001025, 'NO', 'Træna', 1, 'traena', 66.50159000, 12.09645000),
(1079607, 1001025, 'NO', 'Trofors', 1, 'trofors', 65.53335000, 13.40631000),
(1079616, 1001025, 'NO', 'Tysfjord', 1, 'tysfjord', 68.09772000, 16.37591000),
(1079663, 1001025, 'NO', 'Vågan', 1, 'vagan', 68.23220000, 14.56226000),
(1079669, 1001025, 'NO', 'Værøy', 1, 'vaeroy', 67.66374000, 12.69337000),
(1079637, 1001025, 'NO', 'Vefsn', 1, 'vefsn', 65.84109000, 13.20024000),
(1079638, 1001025, 'NO', 'Vega', 1, 'vega', 65.67539000, 11.96456000),
(1079647, 1001025, 'NO', 'Vestvågøy', 1, 'vestvagoy', 68.14830000, 13.61119000),
(1079648, 1001025, 'NO', 'Vevelstad', 1, 'vevelstad', 65.70002000, 12.43921000),
(1079651, 1001025, 'NO', 'Vik', 1, 'vik', 65.31254000, 12.16734000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001009, 'NO', 'Oppland', 1, 'oppland');

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 
(1079059, 1001009, 'NO', 'Bagn', 1, 'bagn', 60.82249000, 9.55207000),
(1079101, 1001009, 'NO', 'Dokka', 1, 'dokka', 60.83500000, 10.07362000),
(1079102, 1001009, 'NO', 'Dombås', 1, 'dombas', 62.07554000, 9.12785000),
(1079103, 1001009, 'NO', 'Dovre', 1, 'dovre', 61.98582000, 9.24947000),
(1079127, 1001009, 'NO', 'Etnedal', 1, 'etnedal', 60.88872000, 9.64031000),
(1079131, 1001009, 'NO', 'Fagernes', 1, 'fagernes', 60.98584000, 9.23236000),
(1079157, 1001009, 'NO', 'Fossbergom', 1, 'fossbergom', 61.83772000, 8.56842000),
(1079173, 1001009, 'NO', 'Gausdal', 1, 'gausdal', 61.22685000, 10.22145000),
(1079180, 1001009, 'NO', 'Gjøvik', 1, 'gjovik', 60.79472000, 10.69287000),
(1079185, 1001009, 'NO', 'Gran', 1, 'gran', 60.39293000, 10.56045000),
(1079191, 1001009, 'NO', 'Grua', 1, 'grua', 60.25701000, 10.66222000),
(1079237, 1001009, 'NO', 'Hov', 1, 'hov', 60.69870000, 10.35193000),
(1079238, 1001009, 'NO', 'Hundorp', 1, 'hundorp', 61.55523000, 9.94069000),
(1079257, 1001009, 'NO', 'Jevnaker', 1, 'jevnaker', 60.24060000, 10.38587000),
(1079315, 1001009, 'NO', 'Lena', 1, 'lena', 60.67391000, 10.81317000),
(1079318, 1001009, 'NO', 'Lesja', 1, 'lesja', 62.11785000, 8.86262000),
(1079323, 1001009, 'NO', 'Lillehammer', 1, 'lillehammer', 61.11464000, 10.46743000),
(1079327, 1001009, 'NO', 'Lom', 1, 'lom', 61.83639000, 8.56811000),
(1079333, 1001009, 'NO', 'Lunner', 1, 'lunner', 60.29462000, 10.60860000),
(1079402, 1001009, 'NO', 'Nord-Aurdal', 1, 'nord-aurdal', 60.98531000, 9.23661000),
(1079403, 1001009, 'NO', 'Nord-Fron', 1, 'nord-fron', 61.59556000, 9.74830000),
(1079408, 1001009, 'NO', 'Nordre Land', 1, 'nordre-land', 60.83471000, 10.07543000),
(1079427, 1001009, 'NO', 'Otta', 1, 'otta', 61.77120000, 9.53529000),
(1079699, 1001009, 'NO', 'Østre Toten', 1, 'ostre-toten', 60.67659000, 10.81997000),
(1079701, 1001009, 'NO', 'Øyer', 1, 'oyer', 61.26495000, 10.41297000),
(1079704, 1001009, 'NO', 'Øystre Slidre', 1, 'oystre-slidre', 61.13377000, 9.07872000),
(1079439, 1001009, 'NO', 'Raufoss', 1, 'raufoss', 60.72604000, 10.61330000),
(1079443, 1001009, 'NO', 'Reinsvoll', 1, 'reinsvoll', 60.67977000, 10.62175000),
(1079450, 1001009, 'NO', 'Ringebu', 1, 'ringebu', 61.52980000, 10.14180000),
(1079490, 1001009, 'NO', 'Sel', 1, 'sel', 61.77278000, 9.53415000),
(1079512, 1001009, 'NO', 'Skjåk', 1, 'skjak', 61.88349000, 8.26490000),
(1079520, 1001009, 'NO', 'Skreia', 1, 'skreia', 60.65257000, 10.93564000),
(1079578, 1001009, 'NO', 'Søndre Land', 1, 'sondre-land', 60.69944000, 10.35086000),
(1079579, 1001009, 'NO', 'Sør-Aurdal', 1, 'sor-aurdal', 60.82242000, 9.54836000),
(1079580, 1001009, 'NO', 'Sør-Fron', 1, 'sor-fron', 61.55652000, 9.93949000),
(1079606, 1001009, 'NO', 'Tretten', 1, 'tretten', 61.31423000, 10.30066000),
(1079665, 1001009, 'NO', 'Vågå', 1, 'vaga', 61.87565000, 9.09572000),
(1079666, 1001009, 'NO', 'Vågåmo', 1, 'vagamo', 61.87505000, 9.09671000),
(1079630, 1001009, 'NO', 'Vang', 1, 'vang', 61.12564000, 8.57167000),
(1079645, 1001009, 'NO', 'Vestre Slidre', 1, 'vestre-slidre', 61.08842000, 8.98196000),
(1079646, 1001009, 'NO', 'Vestre Toten', 1, 'vestre-toten', 60.72593000, 10.60764000),
(1079659, 1001009, 'NO', 'Vinstra', 1, 'vinstra', 61.59496000, 9.75134000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001007, 'NO', 'Oslo', 1, 'oslo');

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 
(1079425, 1001007, 'NO', 'Oslo', 1, 'oslo', 59.91273000, 10.74609000),
(1079502, 1001007, 'NO', 'Sjølyststranda', 1, 'sjolyststranda', 59.92105000, 10.68017000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001022, 'NO', 'Østfold', 1, 'ostfold');

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 
(1079043, 1001022, 'NO', 'Aremark', 1, 'aremark', 59.22198000, 11.69582000),
(1079046, 1001022, 'NO', 'Askim', 1, 'askim', 59.58464000, 11.16084000),
(1079113, 1001022, 'NO', 'Eidsberg', 1, 'eidsberg', 59.55148000, 11.33587000),
(1079158, 1001022, 'NO', 'Fossby', 1, 'fossby', 59.22218000, 11.69928000),
(1079159, 1001022, 'NO', 'Fredrikstad', 1, 'fredrikstad', 59.21759000, 10.93787000),
(1079199, 1001022, 'NO', 'Halden', 1, 'halden', 59.12258000, 11.38709000),
(1079226, 1001022, 'NO', 'Hobøl', 1, 'hobol', 59.62252000, 10.94979000),
(1079241, 1001022, 'NO', 'Hvaler', 1, 'hvaler', 59.02809000, 11.03110000),
(1079265, 1001022, 'NO', 'Karlshus', 1, 'karlshus', 59.35195000, 10.87226000),
(1079278, 1001022, 'NO', 'Knappstad', 1, 'knappstad', 59.62424000, 11.03274000),
(1079302, 1001022, 'NO', 'Larkollen', 1, 'larkollen', 59.33196000, 10.66687000),
(1079317, 1001022, 'NO', 'Lervik', 1, 'lervik', 59.27119000, 10.74610000),
(1079352, 1001022, 'NO', 'Marker', 1, 'marker', 59.47952000, 11.65917000),
(1079375, 1001022, 'NO', 'Moss', 1, 'moss', 59.43436000, 10.65968000),
(1079378, 1001022, 'NO', 'Mysen', 1, 'mysen', 59.55354000, 11.32578000),
(1079694, 1001022, 'NO', 'Ørje', 1, 'orje', 59.48023000, 11.66016000),
(1079463, 1001022, 'NO', 'Råde', 1, 'rade', 59.35162000, 10.87135000),
(1079435, 1001022, 'NO', 'Rakkestad', 1, 'rakkestad', 59.42822000, 11.34350000),
(1079467, 1001022, 'NO', 'Rømskog', 1, 'romskog', 59.74968000, 11.81122000),
(1079460, 1001022, 'NO', 'Rygge', 1, 'rygge', 59.40629000, 10.69298000),
(1079461, 1001022, 'NO', 'Ryggebyen', 1, 'ryggebyen', 59.37500000, 10.75000000),
(1079487, 1001022, 'NO', 'Sarpsborg', 1, 'sarpsborg', 59.28148000, 11.11167000),
(1079509, 1001022, 'NO', 'Skiptvet', 1, 'skiptvet', 59.47751000, 11.16171000),
(1079513, 1001022, 'NO', 'Skjærhalden', 1, 'skjaerhalden', 59.02526000, 11.03685000),
(1079510, 1001022, 'NO', 'Skjeberg', 1, 'skjeberg', 59.21148000, 11.19025000),
(1079536, 1001022, 'NO', 'Spydeberg', 1, 'spydeberg', 59.62028000, 11.08069000),
(1079601, 1001022, 'NO', 'Tomter', 1, 'tomter', 59.65910000, 10.99487000),
(1079612, 1001022, 'NO', 'Trøgstad', 1, 'trogstad', 59.64016000, 11.31890000),
(1079668, 1001022, 'NO', 'Våler', 1, 'valer', 59.48870000, 10.86551000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001021, 'NO', 'Rogaland', 1, 'rogaland');

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 
(1079676, 1001021, 'NO', 'Åkrehamn', 1, 'akrehamn', 59.26053000, 5.18689000),
(1079075, 1001021, 'NO', 'Bjerkreim', 1, 'bjerkreim', 58.63050000, 6.08130000),
(1079083, 1001021, 'NO', 'Bokn', 1, 'bokn', 59.23062000, 5.43524000),
(1079090, 1001021, 'NO', 'Bryne', 1, 'bryne', 58.73536000, 5.64766000),
(1079109, 1001021, 'NO', 'Egersund', 1, 'egersund', 58.45133000, 5.99970000),
(1079117, 1001021, 'NO', 'Eigersund', 1, 'eigersund', 58.45236000, 6.00314000),
(1079118, 1001021, 'NO', 'Eike', 1, 'eike', 59.39833000, 5.36389000),
(1079141, 1001021, 'NO', 'Finnøy', 1, 'finnoy', 59.17117000, 5.87398000),
(1079155, 1001021, 'NO', 'Forsand', 1, 'forsand', 58.89929000, 6.09642000),
(1079179, 1001021, 'NO', 'Gjesdal', 1, 'gjesdal', 58.76478000, 5.85500000),
(1079245, 1001021, 'NO', 'Hå', 1, 'ha', 58.61610000, 5.64497000),
(1079211, 1001021, 'NO', 'Hauge i Dalane', 1, 'hauge-i-dalane', 58.34361000, 6.28121000),
(1079212, 1001021, 'NO', 'Haugesund', 1, 'haugesund', 59.41015000, 5.27551000),
(1079224, 1001021, 'NO', 'Hjelmeland', 1, 'hjelmeland', 59.23668000, 6.17912000),
(1079232, 1001021, 'NO', 'Hommersåk', 1, 'hommersak', 58.92556000, 5.85104000),
(1079262, 1001021, 'NO', 'Jørpeland', 1, 'jorpeland', 59.02251000, 6.04078000),
(1079259, 1001021, 'NO', 'Judaberg', 1, 'judaberg', 59.17204000, 5.87617000),
(1079267, 1001021, 'NO', 'Karmøy', 1, 'karmoy', 59.28079000, 5.30529000),
(1079274, 1001021, 'NO', 'Klepp', 1, 'klepp', 58.77655000, 5.63009000),
(1079283, 1001021, 'NO', 'Kopervik', 1, 'kopervik', 59.28354000, 5.30669000),
(1079295, 1001021, 'NO', 'Kvitsøy', 1, 'kvitsoy', 59.06471000, 5.40537000),
(1079330, 1001021, 'NO', 'Lund', 1, 'lund', 58.45715000, 6.54871000),
(1079336, 1001021, 'NO', 'Lyefjell', 1, 'lyefjell', 58.73539000, 5.73615000),
(1079371, 1001021, 'NO', 'Moi', 1, 'moi', 58.45674000, 6.55184000),
(1079415, 1001021, 'NO', 'Nærbø', 1, 'naerbo', 58.66546000, 5.63788000),
(1079693, 1001021, 'NO', 'Ølen', 1, 'olen', 59.60437000, 5.80799000),
(1079437, 1001021, 'NO', 'Randaberg', 1, 'randaberg', 58.99870000, 5.62055000),
(1079447, 1001021, 'NO', 'Rennesøy', 1, 'rennesoy', 59.09899000, 5.69966000),
(1079483, 1001021, 'NO', 'Sandnes', 1, 'sandnes', 58.84760000, 5.72855000),
(1079488, 1001021, 'NO', 'Sauda', 1, 'sauda', 59.65067000, 6.35312000),
(1079575, 1001021, 'NO', 'Sæveland', 1, 'saeveland', 59.26667000, 5.20000000),
(1079521, 1001021, 'NO', 'Skudeneshavn', 1, 'skudeneshavn', 59.14856000, 5.25687000),
(1079530, 1001021, 'NO', 'Sokndal', 1, 'sokndal', 58.34256000, 6.29425000),
(1079531, 1001021, 'NO', 'Sola', 1, 'sola', 58.88806000, 5.64728000),
(1079538, 1001021, 'NO', 'Stavanger', 1, 'stavanger', 58.96941000, 5.72856000),
(1079555, 1001021, 'NO', 'Strand', 1, 'strand', 59.02353000, 6.04343000),
(1079563, 1001021, 'NO', 'Suldal', 1, 'suldal', 59.48571000, 6.25222000),
(1079589, 1001021, 'NO', 'Tananger', 1, 'tananger', 58.93618000, 5.57410000),
(1079590, 1001021, 'NO', 'Tau', 1, 'tau', 59.06481000, 5.92250000),
(1079592, 1001021, 'NO', 'Time', 1, 'time', 58.73636000, 5.65297000),
(1079618, 1001021, 'NO', 'Tysvær', 1, 'tysvaer', 59.42159000, 5.44781000),
(1079627, 1001021, 'NO', 'Utsira', 1, 'utsira', 59.30565000, 4.88621000),
(1079634, 1001021, 'NO', 'Varhaug', 1, 'varhaug', 58.61810000, 5.65702000),
(1079636, 1001021, 'NO', 'Vedavågen', 1, 'vedavagen', 59.29483000, 5.21874000),
(1079650, 1001021, 'NO', 'Vigrestad', 1, 'vigrestad', 58.57103000, 5.68182000),
(1079654, 1001021, 'NO', 'Vikeså', 1, 'vikesa', 58.63759000, 6.09133000),
(1079655, 1001021, 'NO', 'Vikevåg', 1, 'vikevag', 59.09754000, 5.69790000),
(1079657, 1001021, 'NO', 'Vindafjord', 1, 'vindafjord', 59.60543000, 5.80784000),
(1079661, 1001021, 'NO', 'Vormedal', 1, 'vormedal', 59.35607000, 5.31962000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001018, 'NO', 'Sogn og Fjordane', 1, 'sogn-og-fjordane');

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 
(1079682, 1001018, 'NO', 'Årdal', 1, 'ardal', 61.23639000, 7.70204000),
(1079683, 1001018, 'NO', 'Årdalstangen', 1, 'ardalstangen', 61.23581000, 7.70370000),
(1079047, 1001018, 'NO', 'Askvoll', 1, 'askvoll', 61.34850000, 5.05318000),
(1079053, 1001018, 'NO', 'Aurland', 1, 'aurland', 60.90556000, 7.18734000),
(1079060, 1001018, 'NO', 'Balestrand', 1, 'balestrand', 61.20809000, 6.53551000),
(1079088, 1001018, 'NO', 'Bremanger', 1, 'bremanger', 61.76862000, 5.28907000),
(1079099, 1001018, 'NO', 'Dale', 1, 'dale', 61.36353000, 5.40036000),
(1079110, 1001018, 'NO', 'Eid', 1, 'eid', 61.90684000, 5.99321000),
(1079120, 1001018, 'NO', 'Eivindvik', 1, 'eivindvik', 60.98133000, 5.07497000),
(1079133, 1001018, 'NO', 'Farnes', 1, 'farnes', 61.30850000, 7.79694000),
(1079143, 1001018, 'NO', 'Fjaler', 1, 'fjaler', 61.36383000, 5.39808000),
(1079151, 1001018, 'NO', 'Flora', 1, 'flora', 61.59994000, 5.03144000),
(1079152, 1001018, 'NO', 'Florø', 1, 'floro', 61.59957000, 5.03280000),
(1079169, 1001018, 'NO', 'Førde', 1, 'forde', 61.45045000, 5.85397000),
(1079171, 1001018, 'NO', 'Gaular', 1, 'gaular', 61.32564000, 5.79523000),
(1079172, 1001018, 'NO', 'Gaupne', 1, 'gaupne', 61.40472000, 7.29458000),
(1079183, 1001018, 'NO', 'Gloppen', 1, 'gloppen', 61.77728000, 6.21561000),
(1079194, 1001018, 'NO', 'Gulen', 1, 'gulen', 60.98192000, 5.07408000),
(1079206, 1001018, 'NO', 'Hardbakke', 1, 'hardbakke', 61.07562000, 4.84111000),
(1079218, 1001018, 'NO', 'Hermansverk', 1, 'hermansverk', 61.18461000, 6.85016000),
(1079235, 1001018, 'NO', 'Hornindal', 1, 'hornindal', 61.96925000, 6.52249000),
(1079248, 1001018, 'NO', 'Høyanger', 1, 'hoyanger', 61.21880000, 6.07308000),
(1079244, 1001018, 'NO', 'Hyllestad', 1, 'hyllestad', 61.17036000, 5.29614000),
(1079261, 1001018, 'NO', 'Jølster', 1, 'jolster', 61.56923000, 6.48351000),
(1079341, 1001018, 'NO', 'Lærdal', 1, 'laerdal', 61.09842000, 7.48101000),
(1079342, 1001018, 'NO', 'Lærdalsøyri', 1, 'laerdalsoyri', 61.10001000, 7.47374000),
(1079308, 1001018, 'NO', 'Leikanger', 1, 'leikanger', 61.18556000, 6.82199000),
(1079335, 1001018, 'NO', 'Luster', 1, 'luster', 61.40310000, 7.29793000),
(1079380, 1001018, 'NO', 'Måløy', 1, 'maloy', 61.93535000, 5.11362000),
(1079387, 1001018, 'NO', 'Naustdal', 1, 'naustdal', 61.51034000, 5.71719000),
(1079406, 1001018, 'NO', 'Nordfjordeid', 1, 'nordfjordeid', 61.91220000, 5.98557000),
(1079478, 1001018, 'NO', 'Sandane', 1, 'sandane', 61.77277000, 6.21496000),
(1079479, 1001018, 'NO', 'Sande', 1, 'sande', 61.32511000, 5.79773000),
(1079492, 1001018, 'NO', 'Selje', 1, 'selje', 62.04263000, 5.34449000),
(1079529, 1001018, 'NO', 'Sogndal', 1, 'sogndal', 61.23144000, 7.10301000),
(1079532, 1001018, 'NO', 'Solund', 1, 'solund', 61.07394000, 4.83876000),
(1079561, 1001018, 'NO', 'Stryn', 1, 'stryn', 61.90406000, 6.72400000),
(1079569, 1001018, 'NO', 'Svelgen', 1, 'svelgen', 61.76976000, 5.29544000),
(1079664, 1001018, 'NO', 'Vågsøy', 1, 'vagsoy', 61.93544000, 5.11402000),
(1079652, 1001018, 'NO', 'Vik', 1, 'vik', 61.08863000, 6.58512000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001010, 'NO', 'Sør-Trøndelag', 1, 'sor-trondelag');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001013, 'NO', 'Svalbard', 1, 'svalbard');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001024, 'NO', 'Telemark', 1, 'telemark');

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 
(1079063, 1001024, 'NO', 'Bamble', 1, 'bamble', 59.00146000, 9.74573000),
(1079095, 1001024, 'NO', 'Bø', 1, 'bo', 59.41281000, 9.06618000),
(1079100, 1001024, 'NO', 'Dalen', 1, 'dalen', 59.44499000, 8.00492000),
(1079105, 1001024, 'NO', 'Drangedal', 1, 'drangedal', 59.09655000, 9.05960000),
(1079167, 1001024, 'NO', 'Fyresdal', 1, 'fyresdal', 59.18651000, 8.08953000),
(1079196, 1001024, 'NO', 'Gvarv', 1, 'gvarv', 59.38767000, 9.17240000),
(1079219, 1001024, 'NO', 'Herre', 1, 'herre', 59.10351000, 9.56195000),
(1079223, 1001024, 'NO', 'Hjartdal', 1, 'hjartdal', 59.61276000, 8.94942000),
(1079286, 1001024, 'NO', 'Kragerø', 1, 'kragero', 58.86792000, 9.41099000),
(1079294, 1001024, 'NO', 'Kviteseid', 1, 'kviteseid', 59.40194000, 8.49459000),
(1079332, 1001024, 'NO', 'Lunde', 1, 'lunde', 59.29832000, 9.10268000),
(1079398, 1001024, 'NO', 'Nissedal', 1, 'nissedal', 59.01958000, 8.52127000),
(1079401, 1001024, 'NO', 'Nome', 1, 'nome', 59.28136000, 9.25678000),
(1079414, 1001024, 'NO', 'Notodden', 1, 'notodden', 59.55992000, 9.26046000),
(1079430, 1001024, 'NO', 'Porsgrunn', 1, 'porsgrunn', 59.14190000, 9.65680000),
(1079431, 1001024, 'NO', 'Prestestranda', 1, 'prestestranda', 59.09773000, 9.05866000),
(1079453, 1001024, 'NO', 'Rjukan', 1, 'rjukan', 59.87891000, 8.59411000),
(1079489, 1001024, 'NO', 'Sauherad', 1, 'sauherad', 59.39642000, 9.24910000),
(1079493, 1001024, 'NO', 'Seljord', 1, 'seljord', 59.48274000, 8.62672000),
(1079498, 1001024, 'NO', 'Siljan', 1, 'siljan', 59.28251000, 9.73368000),
(1079508, 1001024, 'NO', 'Skien', 1, 'skien', 59.20748000, 9.61052000),
(1079594, 1001024, 'NO', 'Tinn', 1, 'tinn', 59.83486000, 9.13528000),
(1079598, 1001024, 'NO', 'Tokke', 1, 'tokke', 59.44569000, 8.01388000),
(1079620, 1001024, 'NO', 'Ulefoss', 1, 'ulefoss', 59.28245000, 9.26548000),
(1079658, 1001024, 'NO', 'Vinje', 1, 'vinje', 59.56924000, 7.98896000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001015, 'NO', 'Troms', 1, 'troms');

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 
(1079062, 1001015, 'NO', 'Balsfjord', 1, 'balsfjord', 69.24024000, 19.22653000),
(1079064, 1001015, 'NO', 'Bardu', 1, 'bardu', 68.86058000, 18.35052000),
(1079068, 1001015, 'NO', 'Berg', 1, 'berg', 69.44444000, 17.29950000),
(1079084, 1001015, 'NO', 'Borkenes', 1, 'borkenes', 68.77261000, 16.17115000),
(1079107, 1001015, 'NO', 'Dyrøy', 1, 'dyroy', 69.09154000, 17.69094000),
(1079129, 1001015, 'NO', 'Evenskjer', 1, 'evenskjer', 68.58283000, 16.57203000),
(1079140, 1001015, 'NO', 'Finnsnes', 1, 'finnsnes', 69.22959000, 17.98114000),
(1079188, 1001015, 'NO', 'Gratangen', 1, 'gratangen', 68.69273000, 17.53186000),
(1079193, 1001015, 'NO', 'Gryllefjord', 1, 'gryllefjord', 69.36304000, 17.05284000),
(1079204, 1001015, 'NO', 'Hansnes', 1, 'hansnes', 69.96701000, 19.62752000),
(1079208, 1001015, 'NO', 'Harstad', 1, 'harstad', 68.79896000, 16.52930000),
(1079250, 1001015, 'NO', 'Ibestad', 1, 'ibestad', 68.77866000, 17.17661000),
(1079300, 1001015, 'NO', 'Kåfjord', 1, 'kafjord', 69.60400000, 20.53456000),
(1079266, 1001015, 'NO', 'Karlsøy', 1, 'karlsoy', 69.96185000, 19.61811000),
(1079296, 1001015, 'NO', 'Kvæfjord', 1, 'kvaefjord', 68.77201000, 16.17294000),
(1079297, 1001015, 'NO', 'Kvænangen', 1, 'kvaenangen', 69.93890000, 22.04935000),
(1079306, 1001015, 'NO', 'Lavangen', 1, 'lavangen', 68.74722000, 17.80558000),
(1079316, 1001015, 'NO', 'Lenvik', 1, 'lenvik', 69.23111000, 17.98739000),
(1079338, 1001015, 'NO', 'Lyngen', 1, 'lyngen', 69.57621000, 20.21702000),
(1079339, 1001015, 'NO', 'Lyngseidet', 1, 'lyngseidet', 69.57629000, 20.21887000),
(1079379, 1001015, 'NO', 'Målselv', 1, 'malselv', 69.12389000, 18.61498000),
(1079370, 1001015, 'NO', 'Moen', 1, 'moen', 69.13043000, 18.61226000),
(1079409, 1001015, 'NO', 'Nordreisa', 1, 'nordreisa', 69.76825000, 21.02569000),
(1079418, 1001015, 'NO', 'Olderdalen', 1, 'olderdalen', 69.60407000, 20.53272000),
(1079474, 1001015, 'NO', 'Salangen', 1, 'salangen', 68.87669000, 17.83375000),
(1079496, 1001015, 'NO', 'Setermoen', 1, 'setermoen', 68.86099000, 18.34857000),
(1079503, 1001015, 'NO', 'Sjøvegan', 1, 'sjovegan', 68.87363000, 17.84706000),
(1079524, 1001015, 'NO', 'Skånland', 1, 'skanland', 68.58378000, 16.57305000),
(1079511, 1001015, 'NO', 'Skjervøy', 1, 'skjervoy', 70.03379000, 20.97365000),
(1079585, 1001015, 'NO', 'Sørreisa', 1, 'sorreisa', 69.14697000, 18.15629000),
(1079551, 1001015, 'NO', 'Storfjord', 1, 'storfjord', 69.26860000, 19.96089000),
(1079552, 1001015, 'NO', 'Storslett', 1, 'storslett', 69.76783000, 21.02466000),
(1079553, 1001015, 'NO', 'Storsteinnes', 1, 'storsteinnes', 69.24081000, 19.23437000),
(1079603, 1001015, 'NO', 'Torsken', 1, 'torsken', 69.36184000, 17.05384000),
(1079605, 1001015, 'NO', 'Tranøy', 1, 'tranoy', 69.17022000, 17.73480000),
(1079608, 1001015, 'NO', 'Tromsø', 1, 'tromso', 69.64961000, 18.95702000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001006, 'NO', 'Trøndelag', 1, 'trondelag');

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 
(1079673, 1001006, 'NO', 'Å i Åfjord', 1, 'a-i-afjord', 63.96068000, 10.22468000),
(1079674, 1001006, 'NO', 'Åfjord', 1, 'afjord', 63.96196000, 10.22587000),
(1079037, 1001006, 'NO', 'Agdenes', 1, 'agdenes', 63.50575000, 9.82623000),
(1079071, 1001006, 'NO', 'Berkåk', 1, 'berkak', 62.82496000, 10.01177000),
(1079077, 1001006, 'NO', 'Bjugn', 1, 'bjugn', 63.76522000, 9.80940000),
(1079085, 1001006, 'NO', 'Botngård', 1, 'botngard', 63.76484000, 9.80863000),
(1079087, 1001006, 'NO', 'Brekstad', 1, 'brekstad', 63.68697000, 9.66541000),
(1079139, 1001006, 'NO', 'Fillan', 1, 'fillan', 63.60638000, 8.96961000),
(1079147, 1001006, 'NO', 'Flatanger', 1, 'flatanger', 64.41282000, 11.03285000),
(1079156, 1001006, 'NO', 'Fosnes', 1, 'fosnes', 64.65910000, 11.26535000),
(1079163, 1001006, 'NO', 'Frosta', 1, 'frosta', 63.58910000, 10.74230000),
(1079165, 1001006, 'NO', 'Frøya', 1, 'froya', 63.73005000, 8.82426000),
(1079190, 1001006, 'NO', 'Grong', 1, 'grong', 64.46397000, 12.31114000),
(1079214, 1001006, 'NO', 'Hemne', 1, 'hemne', 63.29095000, 9.08893000),
(1079222, 1001006, 'NO', 'Hitra', 1, 'hitra', 63.54528000, 8.78029000),
(1079230, 1001006, 'NO', 'Holtålen', 1, 'holtalen', 62.84318000, 11.29284000),
(1079231, 1001006, 'NO', 'Hommelvik', 1, 'hommelvik', 63.41083000, 10.79424000),
(1079249, 1001006, 'NO', 'Høylandet', 1, 'hoylandet', 64.62759000, 12.30041000),
(1079251, 1001006, 'NO', 'Inderøy', 1, 'inderoy', 63.87826000, 11.28424000),
(1079253, 1001006, 'NO', 'Indre Fosen', 1, 'indre-fosen', 63.58897000, 9.95847000),
(1079275, 1001006, 'NO', 'Klæbu', 1, 'klaebu', 63.30060000, 10.48188000),
(1079280, 1001006, 'NO', 'Kolvereid', 1, 'kolvereid', 64.86549000, 11.60465000),
(1079298, 1001006, 'NO', 'Kyrksæterøra', 1, 'kyrksaeterora', 63.29057000, 9.08909000),
(1079305, 1001006, 'NO', 'Lauvsnes', 1, 'lauvsnes', 64.50061000, 10.89396000),
(1079312, 1001006, 'NO', 'Leka', 1, 'leka', 65.09244000, 11.70513000),
(1079319, 1001006, 'NO', 'Levanger', 1, 'levanger', 63.74585000, 11.29991000),
(1079321, 1001006, 'NO', 'Lierne', 1, 'lierne', 64.46413000, 13.59249000),
(1079331, 1001006, 'NO', 'Lundamo', 1, 'lundamo', 63.15216000, 10.28555000),
(1079348, 1001006, 'NO', 'Malm', 1, 'malm', 64.07534000, 11.22398000),
(1079349, 1001006, 'NO', 'Malvik', 1, 'malvik', 63.41057000, 10.79382000),
(1079359, 1001006, 'NO', 'Meldal', 1, 'meldal', 63.04598000, 9.71088000),
(1079360, 1001006, 'NO', 'Melhus', 1, 'melhus', 63.28755000, 10.27686000),
(1079363, 1001006, 'NO', 'Meråker', 1, 'meraker', 63.41423000, 11.74558000),
(1079365, 1001006, 'NO', 'Midtre Gauldal', 1, 'midtre-gauldal', 63.03902000, 10.28701000),
(1079382, 1001006, 'NO', 'Namdalseid', 1, 'namdalseid', 64.10843000, 10.91862000),
(1079383, 1001006, 'NO', 'Namsos', 1, 'namsos', 64.47842000, 11.54182000),
(1079384, 1001006, 'NO', 'Namsskogan', 1, 'namsskogan', 64.92597000, 13.15932000),
(1079416, 1001006, 'NO', 'Nærøy', 1, 'naeroy', 64.86298000, 11.60505000),
(1079419, 1001006, 'NO', 'Oppdal', 1, 'oppdal', 62.59495000, 9.68761000),
(1079421, 1001006, 'NO', 'Orkdal', 1, 'orkdal', 63.29989000, 9.84365000),
(1079424, 1001006, 'NO', 'Osen', 1, 'osen', 64.29875000, 10.51284000),
(1079428, 1001006, 'NO', 'Overhalla', 1, 'overhalla', 64.49380000, 11.94753000),
(1079695, 1001006, 'NO', 'Ørland', 1, 'orland', 63.68574000, 9.66633000),
(1079433, 1001006, 'NO', 'Raarvihke - Røyrvik', 1, 'raarvihke-royrvik', 64.88380000, 13.56310000),
(1079438, 1001006, 'NO', 'Ranemsletta', 1, 'ranemsletta', 64.49447000, 11.94912000),
(1079446, 1001006, 'NO', 'Rennebu', 1, 'rennebu', 62.82864000, 10.00487000),
(1079449, 1001006, 'NO', 'Rindal', 1, 'rindal', 63.05511000, 9.21274000),
(1079454, 1001006, 'NO', 'Roan', 1, 'roan', 64.17281000, 10.22511000),
(1079468, 1001006, 'NO', 'Røros', 1, 'roros', 62.57562000, 11.38730000),
(1079469, 1001006, 'NO', 'Rørvik', 1, 'rorvik', 64.86185000, 11.23969000),
(1079472, 1001006, 'NO', 'Røyrvik', 1, 'royrvik', 64.88394000, 13.56256000),
(1079491, 1001006, 'NO', 'Selbu', 1, 'selbu', 63.21770000, 11.03938000),
(1079500, 1001006, 'NO', 'Sistranda', 1, 'sistranda', 63.72523000, 8.83318000),
(1079505, 1001006, 'NO', 'Skaun', 1, 'skaun', 63.32386000, 10.06745000),
(1079516, 1001006, 'NO', 'Skogn', 1, 'skogn', 63.70374000, 11.19262000),
(1079527, 1001006, 'NO', 'Snåase', 1, 'snaase', 64.24570000, 12.37779000),
(1079528, 1001006, 'NO', 'Snåase - Snåsa', 1, 'snaase-snasa', 64.24606000, 12.38294000),
(1079526, 1001006, 'NO', 'Snillfjord', 1, 'snillfjord', 63.39973000, 9.50194000),
(1079541, 1001006, 'NO', 'Steinkjer', 1, 'steinkjer', 64.19303000, 11.38505000),
(1079543, 1001006, 'NO', 'Stjørdal', 1, 'stjordal', 63.56699000, 11.02730000),
(1079544, 1001006, 'NO', 'Stjørdalshalsen', 1, 'stjordalshalsen', 63.46810000, 10.92618000),
(1079559, 1001006, 'NO', 'Straumen', 1, 'straumen', 63.87163000, 11.29617000),
(1079609, 1001006, 'NO', 'Trondheim', 1, 'trondheim', 63.42811000, 10.39687000),
(1079614, 1001006, 'NO', 'Tydal', 1, 'tydal', 63.04477000, 11.65038000),
(1079640, 1001006, 'NO', 'Verdal', 1, 'verdal', 63.90023000, 11.72724000),
(1079641, 1001006, 'NO', 'Verran', 1, 'verran', 64.07100000, 11.21795000),
(1079656, 1001006, 'NO', 'Vikna', 1, 'vikna', 64.86362000, 11.24198000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001014, 'NO', 'Vest-Agder', 1, 'vest-agder');

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 
(1079688, 1001014, 'NO', 'Åseral', 1, 'aseral', 58.61730000, 7.41118000),
(1079049, 1001014, 'NO', 'Audnedal', 1, 'audnedal', 58.28378000, 7.35487000),
(1079134, 1001014, 'NO', 'Farsund', 1, 'farsund', 58.09538000, 6.80403000),
(1079149, 1001014, 'NO', 'Flekkefjord', 1, 'flekkefjord', 58.29791000, 6.66345000),
(1079246, 1001014, 'NO', 'Hægebostad', 1, 'haegebostad', 58.37572000, 7.21973000),
(1079260, 1001014, 'NO', 'Justvik', 1, 'justvik', 58.19691000, 8.03107000),
(1079287, 1001014, 'NO', 'Kristiansand', 1, 'kristiansand', 58.14642000, 7.99687000),
(1079292, 1001014, 'NO', 'Kvinesdal', 1, 'kvinesdal', 58.23894000, 6.71445000),
(1079322, 1001014, 'NO', 'Liknes', 1, 'liknes', 58.31216000, 6.96180000),
(1079325, 1001014, 'NO', 'Lindesnes', 1, 'lindesnes', 58.08435000, 7.30162000),
(1079337, 1001014, 'NO', 'Lyngdal', 1, 'lyngdal', 58.13829000, 7.06836000),
(1079350, 1001014, 'NO', 'Mandal', 1, 'mandal', 58.02633000, 7.45014000),
(1079353, 1001014, 'NO', 'Marnardal', 1, 'marnardal', 58.19802000, 7.52802000),
(1079400, 1001014, 'NO', 'Nodeland', 1, 'nodeland', 58.15517000, 7.83576000),
(1079499, 1001014, 'NO', 'Sirdal', 1, 'sirdal', 58.66510000, 6.71585000),
(1079523, 1001014, 'NO', 'Skålevik', 1, 'skalevik', 58.07955000, 8.01602000),
(1079533, 1001014, 'NO', 'Songdalen', 1, 'songdalen', 58.15273000, 7.83677000),
(1079576, 1001014, 'NO', 'Søgne', 1, 'sogne', 58.09663000, 7.81491000),
(1079554, 1001014, 'NO', 'Strai', 1, 'strai', 58.18930000, 7.92826000),
(1079602, 1001014, 'NO', 'Tonstad', 1, 'tonstad', 58.66263000, 6.71694000),
(1079613, 1001014, 'NO', 'Tveit', 1, 'tveit', 58.23366000, 8.12199000),
(1079631, 1001014, 'NO', 'Vanse', 1, 'vanse', 58.09812000, 6.69184000),
(1079639, 1001014, 'NO', 'Vennesla', 1, 'vennesla', 58.34271000, 7.97596000),
(1079643, 1001014, 'NO', 'Vestbygd', 1, 'vestbygd', 58.09991000, 6.58696000),
(1079649, 1001014, 'NO', 'Vigeland', 1, 'vigeland', 58.08437000, 7.30497000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001008, 'NO', 'Vestfold', 1, 'vestfold');

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 
(1079686, 1001008, 'NO', 'Årøysund', 1, 'aroysund', 59.18321000, 10.45743000),
(1079689, 1001008, 'NO', 'Åsgårdstrand', 1, 'asgardstrand', 59.34938000, 10.46948000),
(1079065, 1001008, 'NO', 'Barkåker', 1, 'barkaker', 59.31859000, 10.38963000),
(1079070, 1001008, 'NO', 'Berger', 1, 'berger', 59.54994000, 10.38641000),
(1079168, 1001008, 'NO', 'Færder', 1, 'faerder', 59.22791000, 10.41530000),
(1079195, 1001008, 'NO', 'Gullhaug', 1, 'gullhaug', 59.50130000, 10.25224000),
(1079229, 1001008, 'NO', 'Holmestrand', 1, 'holmestrand', 59.48976000, 10.31515000),
(1079236, 1001008, 'NO', 'Horten', 1, 'horten', 59.41547000, 10.48527000),
(1079304, 1001008, 'NO', 'Larvik', 1, 'larvik', 59.05234000, 10.02701000),
(1079361, 1001008, 'NO', 'Melsomvik', 1, 'melsomvik', 59.22394000, 10.33616000),
(1079441, 1001008, 'NO', 'Re', 1, 're', 59.35056000, 10.24763000),
(1079480, 1001008, 'NO', 'Sande', 1, 'sande', 59.59362000, 10.20757000),
(1079482, 1001008, 'NO', 'Sandefjord', 1, 'sandefjord', 59.12881000, 10.21971000),
(1079494, 1001008, 'NO', 'Selvik', 1, 'selvik', 59.56645000, 10.26004000),
(1079495, 1001008, 'NO', 'Sem', 1, 'sem', 59.28230000, 10.33004000),
(1079518, 1001008, 'NO', 'Skoppum', 1, 'skoppum', 59.38613000, 10.41077000),
(1079539, 1001008, 'NO', 'Stavern', 1, 'stavern', 59.00000000, 10.03333000),
(1079545, 1001008, 'NO', 'Stokke', 1, 'stokke', 59.22255000, 10.30055000),
(1079570, 1001008, 'NO', 'Svelvik', 1, 'svelvik', 59.60677000, 10.40225000),
(1079596, 1001008, 'NO', 'Tjøme', 1, 'tjome', 59.11090000, 10.39330000),
(1079619, 1001008, 'NO', 'Tønsberg', 1, 'tonsberg', 59.26754000, 10.40762000);

