REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('GL', 'Greenland', 'Kalaallit Nunaat', 'greenland', '299', 'DKK');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(10602005, 'GL', 'Kujalleq', 1, 'kujalleq'),
(10602006, 'GL', 'Qeqqata', 1, 'qeqqata'),
(10602007, 'GL', 'Sermersooq', 1, 'sermersooq'),
(14839534, 'GL', 'Qeqertalik', 1, 'qeqertalik'),
(14839537, 'GL', 'Avannaata', 1, 'avannaata');

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 
(6418809, 10602007, 'GL', 'Vandreblokken', 1, 'vandreblokken', 70.65, -24),
(6418835, 10602007, 'GL', 'Uunartoq', 1, 'uunartoq', 70.41472, -21.97603),
(6418836, 14839534, 'GL', 'Uunartoq', 1, 'uunartoq', 69.9, -52.6),
(6418841, 14839537, 'GL', 'Uummannatsiaq', 1, 'uummannatsiaq', 70.56667, -51.68333),
(6418845, 10602007, 'GL', 'Uummannaq', 1, 'uummannaq', 64.48333, -50.78333),
(6418859, 10602006, 'GL', 'Uummannaarsuk', 1, 'uummannaarsuk', 66.85, -53.58333),
(6418881, 10602007, 'GL', 'Utoqqarmiut', 1, 'utoqqarmiut', 63.8, -51.46667),
(6418910, 14839537, 'GL', 'Upernavik', 1, 'upernavik', 72.7872, -56.14436),
(6418914, 10602005, 'GL', 'Upernaviarsuk', 1, 'upernaviarsuk', 60.75, -45.88333),
(6418947, 10602007, 'GL', 'Umiattuartivit', 1, 'umiattuartivit', 65.9, -37.98333),
(6418991, 14839537, 'GL', 'Ukkusissat', 1, 'ukkusissat', 71.04963, -51.8869),
(6418997, 10602007, 'GL', 'Ukîverajik', 1, 'ukiverajik', 65.75, -37.91667),
(6419009, 14839534, 'GL', 'Ujarasussuk', 1, 'ujarasussuk', 69.86667, -52.45),
(6419034, 10602007, 'GL', 'Ujaraat', 1, 'ujaraat', 62.11667, -49.38333),
(6419136, 14839534, 'GL', 'Tununngasoq', 1, 'tununngasoq', 68.1, -53.18333),
(6419198, 10602005, 'GL', 'Tuapaat', 1, 'tuapaat', 60.11667, -45.16667),
(6419263, 10602006, 'GL', 'Toqqusaq', 1, 'toqqusaq', 64.86667, -52.2),
(6419291, 10602007, 'GL', 'Tiniteqilaarmiit', 1, 'tiniteqilaarmiit', 63.38333, -41.11667),
(6419292, 10602007, 'GL', 'Tiniteqilaaq', 1, 'tiniteqilaaq', 65.88873, -37.7787),
(6419310, 10602005, 'GL', 'Timmiarmiut', 1, 'timmiarmiut', 62.53333, -42.21667),
(6419316, 10602006, 'GL', 'Timerliit', 1, 'timerliit', 65.83333, -53.25),
(6419378, 14839537, 'GL', 'Tasiusaq', 1, 'tasiusaq', 73.36902, -56.05755),
(6419379, 10602005, 'GL', 'Tasiusaq', 1, 'tasiusaq', 60.19405, -44.81716),
(6419443, 14839537, 'GL', 'Tartunaq', 1, 'tartunaq', 70.03333, -52.21667),
(6419712, 14839537, 'GL', 'Upernavik Kujalleq', 1, 'upernavik-kujalleq', 72.15508, -55.5241),
(6419714, 10602006, 'GL', 'Kangerlussuaq', 1, 'kangerlussuaq', 67.00876, -50.68937),
(6419721, 10602005, 'GL', 'Søndre Igaliku', 1, 'sondre-igaliku', 60.9, -45.28333),
(6419777, 10602005, 'GL', 'Ammassivik', 1, 'ammassivik', 60.59673, -45.38633),
(6419793, 10602007, 'GL', 'Skjoldungen', 1, 'skjoldungen', 63.21955, -41.40284),
(6419818, 14839534, 'GL', 'Skansen', 1, 'skansen', 69.43333, -52.45),
(6419842, 10602006, 'GL', 'Sisimiut', 1, 'sisimiut', 66.93946, -53.6735),
(6419883, 10602007, 'GL', 'Simiutaq', 1, 'simiutaq', 65.86667, -37.03333),
(6419959, 10602007, 'GL', 'Sermiligaaq', 1, 'sermiligaaq', 65.90734, -36.3798),
(6419968, 14839537, 'GL', 'Sermiarsuit', 1, 'sermiarsuit', 70.56667, -52.1),
(6420079, 10602006, 'GL', 'Sarfannguaq', 1, 'sarfannguaq', 66.9, -52.86667),
(6420093, 10602006, 'GL', 'Saqqarliit', 1, 'saqqarliit', 66.86667, -52.46667),
(6420097, 14839537, 'GL', 'Saqqaq', 1, 'saqqaq', 70.00962, -51.94532),
(6420101, 10602005, 'GL', 'Saqqamiut', 1, 'saqqamiut', 60.81667, -47.41667),
(6420130, 10602005, 'GL', 'Sammisoq', 1, 'sammisoq', 59.99083, -43.93222),
(6420217, 10602005, 'GL', 'Saarloq', 1, 'saarloq', 60.53761, -46.02765),
(6420293, 14839537, 'GL', 'Ritenbenk', 1, 'ritenbenk', 69.76667, -51.31667),
(6420377, 10602005, 'GL', 'Qunnermiut', 1, 'qunnermiut', 60.45, -45.25),
(6420388, 14839534, 'GL', 'Qullissat', 1, 'qullissat', 70.08333, -53.01667),
(6420458, 10602007, 'GL', 'Qoornoq', 1, 'qoornoq', 64.53333, -51.1),
(6420468, 10602007, 'GL', 'Qooqqut', 1, 'qooqqut', 64.26667, -50.9),
(6420527, 10602007, 'GL', 'Qíngeq', 1, 'qingeq', 65.96667, -37.11667),
(6420591, 10602007, 'GL', 'Qernertuarssuit', 1, 'qernertuarssuit', 65.71667, -37.3),
(6420629, 14839534, 'GL', 'Qeqertarsuatsiaq', 1, 'qeqertarsuatsiaq', 68.41667, -53.25),
(6420635, 14839537, 'GL', 'Qeqertarsuaq', 1, 'qeqertarsuaq', 69.24721, -53.53682),
(6420636, 10602007, 'GL', 'Qeqertarsuaq', 1, 'qeqertarsuaq', 62.11667, -49.78333),
(6420712, 10602007, 'GL', 'Qeertartivatsiaq', 1, 'qeertartivatsiaq', 65.83333, -38.01667),
(6420739, 10602005, 'GL', 'Qassimiut', 1, 'qassimiut', 60.78333, -47.16667),
(6420741, 10602005, 'GL', 'Qassiarsuk', 1, 'qassiarsuk', 61.14958, -45.51452),
(6420768, 14839534, 'GL', 'Qasigiannguit', 1, 'qasigiannguit', 68.81926, -51.19221),
(6420846, 10602005, 'GL', 'Qaqortoq', 1, 'qaqortoq', 60.71839, -46.03561),
(6420893, 10602005, 'GL', 'Qallimiut', 1, 'qallimiut', 60.7, -45.33333),
(6420937, 14839537, 'GL', 'Qaarsut', 1, 'qaarsut', 70.73333, -52.65),
(6421005, 14839537, 'GL', 'Kangersuatsiaq', 1, 'kangersuatsiaq', 72.37994, -55.54739),
(6421013, 10602005, 'GL', 'Prins Christians Sund', 1, 'prins-christians-sund', 60.05587, -43.15923),
(6421028, 10602005, 'GL', 'Portusooq', 1, 'portusooq', 60.55, -45.23333),
(6421049, 14839537, 'GL', 'Pitorqeq', 1, 'pitorqeq', 69.2152, -51.1193),
(6421190, 10602007, 'GL', 'Paarnakajiit', 1, 'paarnakajiit', 66.08333, -37.63333),
(6421193, 10602007, 'GL', 'Paamiut', 1, 'paamiut', 61.99402, -49.66776),
(6421319, 10602007, 'GL', 'Nuuk', 1, 'nuuk', 64.18347, -51.72157),
(6421320, 10602005, 'GL', 'Nuuk', 1, 'nuuk', 60.24017, -44.15815),
(6421327, 14839537, 'GL', 'Nuugaatsiaq', 1, 'nuugaatsiaq', 71.53563, -53.2124),
(6421337, 14839537, 'GL', 'Nuugaaq', 1, 'nuugaaq', 69.96667, -51.26667),
(6421476, 14839537, 'GL', 'Nordre Huse', 1, 'nordre-huse', 69.11667, -51.08333),
(6421522, 14839534, 'GL', 'Nivaaq', 1, 'nivaaq', 68.61667, -52.41667),
(6421582, 10602005, 'GL', 'Niaqornaq', 1, 'niaqornaq', 61, -46.13333),
(6421618, 10602007, 'GL', 'Neriunaq', 1, 'neriunaq', 64.46667, -50.31667),
(6421619, 10602007, 'GL', 'Neria', 1, 'neria', 61.61667, -49.11667),
(6421707, 10602006, 'GL', 'Narssarmiut', 1, 'narssarmiut', 65.88333, -53.3),
(6421709, 10602007, 'GL', 'Narsatsiaat', 1, 'narsatsiaat', 62.1, -49.36667),
(6421711, 10602005, 'GL', 'Narsarsuaq', 1, 'narsarsuaq', 61.15667, -45.42536),
(6421718, 10602007, 'GL', 'Narsaq', 1, 'narsaq', 64.00167, -51.63378),
(6421719, 10602005, 'GL', 'Narsaq', 1, 'narsaq', 60.91298, -46.05055),
(6421725, 10602007, 'GL', 'Narsalik', 1, 'narsalik', 61.61667, -49.35),
(6421750, 10602006, 'GL', 'Napasoq', 1, 'napasoq', 65.05, -52.4),
(6421765, 10602005, 'GL', 'Nanortalik', 1, 'nanortalik', 60.14169, -45.24069),
(6421812, 14839537, 'GL', 'Naajat', 1, 'naajat', 73.15, -55.81667),
(6421948, 14839534, 'GL', 'Marraat', 1, 'marraat', 69.36667, -52.78333),
(6421982, 10602006, 'GL', 'Maniitsoq', 1, 'maniitsoq', 65.41506, -52.89822),
(6422000, 14839534, 'GL', 'Manermiut', 1, 'manermiut', 68.6, -53.13333),
(6422047, 14839537, 'GL', 'Maarmorilik', 1, 'maarmorilik', 71.13333, -51.28333),
(6422101, 10602005, 'GL', 'Lichtenau', 1, 'lichtenau', 60.55, -45.46667),
(6422205, 10602007, 'GL', 'Kuummiit', 1, 'kuummiit', 65.86469, -37.00479),
(6422210, 14839537, 'GL', 'Kuuk', 1, 'kuuk', 73.7, -56.21667),
(6422225, 10602007, 'GL', 'Kulusuk', 1, 'kulusuk', 65.57538, -37.18467),
(6422228, 14839537, 'GL', 'Kullorsuaq', 1, 'kullorsuaq', 74.57849, -57.22094),
(6422290, 14839534, 'GL', 'Kronprinsen Ejland', 1, 'kronprinsen-ejland', 69.01667, -53.31667),
(6422300, 14839537, 'GL', 'Nuussuaq', 1, 'nuussuaq', 74.11117, -57.05962),
(6422376, 14839537, 'GL', 'Kittorsaq', 1, 'kittorsaq', 73.95, -56.73333),
(6422439, 14839534, 'GL', 'Killiat', 1, 'killiat', 68.28333, -53.78333),
(6422449, 10602007, 'GL', 'Kiinnarissoq', 1, 'kiinnarissoq', 62.16667, -49.3),
(6422467, 14839534, 'GL', 'Kigdlûssat', 1, 'kigdlussat', 69.38333, -52.76667),
(6422515, 10602007, 'GL', 'Kapisillit', 1, 'kapisillit', 64.43518, -50.2713),
(6422554, 10602007, 'GL', 'Kangilineq', 1, 'kangilineq', 61.95, -49.46667),
(6422567, 10602005, 'GL', 'Kangikitsoq', 1, 'kangikitsoq', 60.45, -44.78333),
(6422572, 10602005, 'GL', 'Kangikasîk', 1, 'kangikasik', 60.51667, -45.65),
(6422576, 10602007, 'GL', 'Kangigdlermiut', 1, 'kangigdlermiut', 62.81667, -50.4),
(6422618, 10602006, 'GL', 'Kangerluarsuk', 1, 'kangerluarsuk', 65.41667, -52.53333),
(6422635, 10602007, 'GL', 'Kangerluarsoruseq', 1, 'kangerluarsoruseq', 63.69776, -51.54446),
(6422665, 10602007, 'GL', 'Kangeq', 1, 'kangeq', 64.11667, -52.05),
(6422690, 14839537, 'GL', 'Kangaarsuk', 1, 'kangaarsuk', 72, -55.6),
(6422700, 10602006, 'GL', 'Kangaamiut', 1, 'kangaamiut', 65.82503, -53.34279),
(6422861, 10602007, 'GL', 'Ivittuut', 1, 'ivittuut', 61.20693, -48.17225),
(6422886, 10602007, 'GL', 'Ittumiit', 1, 'ittumiit', 65.58333, -37.58333),
(6422887, 10602007, 'GL', 'Ittorisseq', 1, 'ittorisseq', 70.45, -22.45),
(6422889, 10602007, 'GL', 'Kap Hope', 1, 'kap-hope', 70.4588, -22.32975),
(6422934, 10602006, 'GL', 'Itilleq', 1, 'itilleq', 66.58333, -53.5),
(6422935, 10602005, 'GL', 'Itilleq', 1, 'itilleq', 59.88333, -43.73333),
(6422944, 10602005, 'GL', 'Iterlak', 1, 'iterlak', 60.91667, -45.3),
(6423000, 10602007, 'GL', 'Isortoq', 1, 'isortoq', 65.54847, -38.97559),
(6423081, 14839534, 'GL', 'Innalik', 1, 'innalik', 68.45, -53.5),
(6423146, 14839537, 'GL', 'Ilulissat', 1, 'ilulissat', 69.21981, -51.09861),
(6423174, 14839537, 'GL', 'Illulik', 1, 'illulik', 74.35, -56.7),
(6423179, 14839537, 'GL', 'Illorsuit', 1, 'illorsuit', 71.24165, -53.5647),
(6423180, 10602005, 'GL', 'Illorsuit', 1, 'illorsuit', 61.06667, -46.25),
(6423182, 10602005, 'GL', 'Illorpaat', 1, 'illorpaat', 60.45, -45.33333),
(6423210, 14839537, 'GL', 'Ikorfat', 1, 'ikorfat', 69.98333, -51.43333),
(6423220, 10602006, 'GL', 'Ikkamiut', 1, 'ikkamiut', 65.63333, -52.8),
(6423260, 14839537, 'GL', 'Ikerasak', 1, 'ikerasak', 70.50164, -51.30246),
(6423262, 10602006, 'GL', 'Ikerasak', 1, 'ikerasak', 66.86667, -53.43333),
(6423277, 14839537, 'GL', 'Ikerasaarsuk', 1, 'ikerasaarsuk', 73.53333, -56.43333),
(6423279, 10602006, 'GL', 'Ikerasaarsuk', 1, 'ikerasaarsuk', 66.81667, -53.1),
(6423291, 10602007, 'GL', 'Íkáteq', 1, 'ikateq', 65.94651, -36.66756),
(6423313, 14839534, 'GL', 'Ikamiut', 1, 'ikamiut', 68.63425, -51.82545),
(6423330, 10602007, 'GL', 'Igssalik', 1, 'igssalik', 65.51667, -39.01667),
(6423337, 14839534, 'GL', 'Iginniarfik', 1, 'iginniarfik', 68.14789, -53.1716),
(6423392, 10602005, 'GL', 'Igaliku', 1, 'igaliku', 60.98766, -45.4207),
(6423512, 10602005, 'GL', 'Ikigaat', 1, 'ikigaat', 59.98333, -44.7),
(6423634, 10602007, 'GL', 'Kangilinnguit', 1, 'kangilinnguit', 61.23238, -48.096),
(6423734, 14839534, 'GL', 'Gamle Qutdligssat', 1, 'gamle-qutdligssat', 70.03333, -52.95),
(6423735, 14839534, 'GL', 'Gamle Egedesminde', 1, 'gamle-egedesminde', 67.65, -53.58333),
(6423771, 10602005, 'GL', 'Narsarmijit', 1, 'narsarmijit', 60.00488, -44.66531),
(6423823, 10602007, 'GL', 'Qeqertarsuatsiaat', 1, 'qeqertarsuatsiaat', 63.08815, -50.67767),
(6423830, 10602007, 'GL', 'Finnsbu', 1, 'finnsbu', 63.38333, -41.3),
(6423892, 14839537, 'GL', 'Eqi', 1, 'eqi', 69.13333, -51.08333),
(6424030, 14839534, 'GL', 'Diskofjord', 1, 'diskofjord', 69.48333, -53.95),
(6424150, 10602006, 'GL', 'Camp Lloyd', 1, 'camp-lloyd', 66.97266, -50.92924),
(6424381, 14839537, 'GL', 'Autdlainiarfinguaq', 1, 'autdlainiarfinguaq', 70.7, -54.58333),
(6424408, 14839534, 'GL', 'Attu', 1, 'attu', 67.94097, -53.62365),
(6424424, 10602006, 'GL', 'Atammik', 1, 'atammik', 64.8, -52.21667),
(6424427, 14839537, 'GL', 'Ataa', 1, 'ataa', 69.76667, -50.95),
(6424436, 10602006, 'GL', 'Assaqutaq', 1, 'assaqutaq', 66.91667, -53.46667),
(6424452, 10602007, 'GL', 'Arsuk', 1, 'arsuk', 61.17456, -48.45117),
(6424453, 14839537, 'GL', 'Arsivik', 1, 'arsivik', 69.85, -50.7),
(6424486, 14839534, 'GL', 'Aqisserniaq', 1, 'aqisserniaq', 67.86667, -53.6),
(6424495, 10602007, 'GL', 'Aputiteeq', 1, 'aputiteeq', 67.78333, -32.28333),
(6424510, 14839537, 'GL', 'Appat', 1, 'appat', 70.91667, -52.16667),
(6424517, 10602006, 'GL', 'Appamiut', 1, 'appamiut', 65.66667, -53.18333),
(6424537, 10602005, 'GL', 'Anorliuitsoq', 1, 'anorliuitsoq', 60.08333, -44.21667),
(6424607, 10602007, 'GL', 'Tasiilaq', 1, 'tasiilaq', 65.61451, -37.63676),
(6424682, 10602005, 'GL', 'Alluitsup Paa', 1, 'alluitsup-paa', 60.46266, -45.56951),
(6424725, 14839534, 'GL', 'Akulliit', 1, 'akulliit', 68.66667, -51.25),
(6424773, 10602005, 'GL', 'Akuliaruseq', 1, 'akuliaruseq', 60.46667, -45.48333),
(6424900, 10602007, 'GL', 'Aasivik', 1, 'aasivik', 62.2, -49.33333),
(6424901, 14839534, 'GL', 'Aasiaat', 1, 'aasiaat', 68.70981, -52.86988),
(6424904, 14839534, 'GL', 'Aasiaat Kommuniat', 1, 'aasiaat-kommuniat', 68.66667, -52.75),
(6424906, 14839537, 'GL', 'Aappilattoq', 1, 'aappilattoq', 72.88333, -55.6),
(6424907, 10602005, 'GL', 'Aappilattorq', 1, 'aappilattorq', 60.16667, -44.5),
(6424922, 14839534, 'GL', 'Aalatsivik', 1, 'aalatsivik', 68.16667, -52.83333),
(6426128, 10602007, 'GL', 'Kap Tobin', 1, 'kap-tobin', 70.41141, -21.94659),
(6426193, 14839537, 'GL', 'Uummannaq', 1, 'uummannaq', 70.67442, -52.12545),
(6426194, 10602005, 'GL', 'Aappilattoq', 1, 'aappilattoq', 60.15031, -44.28503),
(6426195, 10602005, 'GL', 'Eqalugaarsuit', 1, 'eqalugaarsuit', 60.62324, -45.91),
(6831080, 14839537, 'GL', 'Upernavissuaq', 1, 'upernavissuaq', 77.31667, -71.83333),
(6831081, 14839537, 'GL', 'Ulussat', 1, 'ulussat', 77.38333, -71.06667),
(6831102, 14839537, 'GL', 'Tikeraasaq', 1, 'tikeraasaq', 77.36139, -68.46417),
(6831146, 14839537, 'GL', 'Savissivik', 1, 'savissivik', 76.01972, -65.11494),
(6831174, 14839537, 'GL', 'Quínissut', 1, 'quinissut', 77.5325, -67.76722),
(6831180, 14839537, 'GL', 'Qeqertat', 1, 'qeqertat', 77.50972, -66.64778),
(6831189, 14839537, 'GL', 'Qeqertaq', 1, 'qeqertaq', 76.03444, -65.98639),
(6831197, 14839537, 'GL', 'Qassisalik', 1, 'qassisalik', 77.33333, -71.53333),
(6831204, 14839537, 'GL', 'Qangattaat', 1, 'qangattaat', 77.38333, -72.46667),
(6831208, 14839537, 'GL', 'Qaanaaq', 1, 'qaanaaq', 77.46666, -69.23155),
(6831209, 14839537, 'GL', 'Qaanaaq Kommune', 1, 'qaanaaq-kommune', 77.5, -69.16667),
(6831232, 14839537, 'GL', 'Perlernerit', 1, 'perlernerit', 75.92722, -66.44889),
(6831257, 14839537, 'GL', 'Nunatarsuaq', 1, 'nunatarsuaq', 77.42389, -66.57472),
(6831260, 14839537, 'GL', 'Nunatami', 1, 'nunatami', 80, -66),
(6831262, 14839537, 'GL', 'Nunat', 1, 'nunat', 77.38944, -67.52972),
(6831275, 14839537, 'GL', 'Neqi', 1, 'neqi', 77.86168, -71.55355),
(6831277, 14839537, 'GL', 'Natsilivik', 1, 'natsilivik', 77.175, -70.7375),
(6831310, 14839537, 'GL', 'Moriusaq', 1, 'moriusaq', 76.75611, -69.88639),
(6831336, 14839537, 'GL', 'Kiatak', 1, 'kiatak', 77.35, -71.46667),
(6831344, 14839537, 'GL', 'Kangerluarsuk', 1, 'kangerluarsuk', 77.55667, -68.585),
(6831365, 14839537, 'GL', 'Itilleq', 1, 'itilleq', 77.22444, -69.48917),
(6831521, 14839537, 'GL', 'Appaarsuit', 1, 'appaarsuit', 77.41667, -72.66667);