REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('AX', 'Aland Islands', 'Åland', 'aland-islands', '+358-18', 'EUR');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(12611689, 'AX', 'Mariehamns stad', 1, 'mariehamns-stad'),
(12611692, 'AX', 'Ålands landsbygd', 1, 'alands-landsbygd'),
(12611694, 'AX', 'Ålands skärgård', 1, 'alands-skaergard');

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 
(3630705, 12611692, 'AX', 'Ytterby', 1, 'ytterby', 60.16667, 20.01667),
(3631841, 12611692, 'AX', 'Vessingsboda', 1, 'vessingsboda', 60.044, 20.17501),
(3632219, 12611692, 'AX', 'Västeränga', 1, 'vaesteraenga', 60.01548, 20.13079),
(3632410, 12611694, 'AX', 'Vargata', 1, 'vargata', 60.2465, 20.35033),
(3632421, 12611694, 'AX', 'Vårdö', 1, 'vardoe', 60.25, 20.38333),
(3632565, 12611694, 'AX', 'Vålö', 1, 'valoe', 59.95, 21),
(3633398, 12611694, 'AX', 'Ulversö', 1, 'ulversoe', 60.1, 20.55),
(3634002, 12611692, 'AX', 'Tranvik', 1, 'tranvik', 60.2, 20.15),
(3634042, 12611692, 'AX', 'Tosarby', 1, 'tosarby', 60.21667, 20.1),
(3634065, 12611694, 'AX', 'Torsholma', 1, 'torsholma', 60.35, 21.1),
(3634335, 12611694, 'AX', 'Töftö', 1, 'toeftoe', 60.2, 20.3),
(3634959, 12611692, 'AX', 'Tängsöda', 1, 'taengsoeda', 60.3, 20.13333),
(3635395, 12611692, 'AX', 'Syllöda', 1, 'sylloeda', 60.28333, 20.11667),
(3635424, 12611692, 'AX', 'Svinö', 1, 'svinoe', 60.07974, 20.26263),
(3635815, 12611692, 'AX', 'Sund', 1, 'sund', 60.25, 20.11667),
(3635946, 12611692, 'AX', 'Strömma', 1, 'stroemma', 60.33333, 20.05),
(3636158, 12611694, 'AX', 'Sottunga', 1, 'sottunga', 60.13023, 20.66683),
(3636291, 12611694, 'AX', 'Sonnboda', 1, 'sonnboda', 60.0467, 20.48739),
(3636332, 12611694, 'AX', 'Sommarö', 1, 'sommaroe', 60.03563, 20.56186),
(3636461, 12611692, 'AX', 'Söderby', 1, 'soederby', 60.06682, 20.0714),
(3636463, 12611694, 'AX', 'Söderby', 1, 'soederby', 59.93333, 20.96667),
(3636494, 12611692, 'AX', 'Smedsböle', 1, 'smedsboele', 60.21667, 20.16667),
(3636548, 12611694, 'AX', 'Skogboda', 1, 'skogboda', 60.02965, 20.51284),
(3636601, 12611692, 'AX', 'Skag', 1, 'skag', 60.08333, 20.23333),
(3636765, 12611694, 'AX', 'Simskäla', 1, 'simskaela', 60.34139, 20.3097),
(3637065, 12611692, 'AX', 'Sibby', 1, 'sibby', 60.25, 20.2),
(3637226, 12611694, 'AX', 'Seglinge', 1, 'seglinge', 60.20496, 20.69569),
(3637793, 12611694, 'AX', 'Sandö', 1, 'sandoe', 60.28333, 20.4),
(3637878, 12611692, 'AX', 'Saltvik', 1, 'saltvik', 60.28333, 20.05),
(3638222, 12611692, 'AX', 'Såg', 1, 'sag', 60.11667, 20.01667),
(3638993, 12611692, 'AX', 'Rörstorp', 1, 'roerstorp', 60.0733, 20.1319),
(3643435, 12611694, 'AX', 'Överö', 1, 'oeveroe', 60.10671, 20.51905),
(3643446, 12611694, 'AX', 'Överboda', 1, 'oeverboda', 59.93333, 20.9),
(3643562, 12611694, 'AX', 'Österbygge', 1, 'oesterbygge', 59.93726, 20.98013),
(3643718, 12611692, 'AX', 'Önningby', 1, 'oenningby', 60.11754, 20.00782),
(3644334, 12611694, 'AX', 'Nötö', 1, 'noetoe', 60.08333, 20.48333),
(3644394, 12611692, 'AX', 'Norrby', 1, 'norrby', 60.07862, 20.08215),
(3644396, 12611692, 'AX', 'Norrboda', 1, 'norrboda', 60.13333, 20.28333),
(3646808, 12611692, 'AX', 'Mångstäkta', 1, 'mangstaekta', 60.25323, 20.22937),
(3647453, 12611692, 'AX', 'Lumpo', 1, 'lumpo', 60.15, 20.23333),
(3647455, 12611692, 'AX', 'Lumparland', 1, 'lumparland', 60.11695, 20.25819),
(3647459, 12611692, 'AX', 'Lumparby', 1, 'lumparby', 60.12181, 20.24433),
(3647566, 12611694, 'AX', 'Lövö', 1, 'loevoe', 60.26147, 20.37175),
(3647823, 12611694, 'AX', 'Listersby', 1, 'listersby', 60.23038, 20.38049),
(3647969, 12611694, 'AX', 'Lilleböle', 1, 'lilleboele', 59.93333, 20.88333),
(3648382, 12611692, 'AX', 'Lemland', 1, 'lemland', 60.07178, 20.08472),
(3648868, 12611694, 'AX', 'Lappo', 1, 'lappo', 60.31667, 20.98333),
(3649125, 12611692, 'AX', 'Långbergsöda', 1, 'langbergsoeda', 60.30058, 20.13326),
(3649634, 12611694, 'AX', 'Kyrkogårdsö', 1, 'kyrkogardsoe', 60.03333, 20.83333),
(3650395, 12611694, 'AX', 'Kumlinge', 1, 'kumlinge', 60.26013, 20.77892),
(3650472, 12611692, 'AX', 'Kulla', 1, 'kulla', 60.23333, 20.08333),
(3650756, 12611692, 'AX', 'Krokstad', 1, 'krokstad', 60.1, 20.26667),
(3651101, 12611694, 'AX', 'Koskenpää', 1, 'koskenpaeae', 60.41667, 21.01667),
(3651288, 12611694, 'AX', 'Korsö', 1, 'korsoe', 60.41667, 21),
(3651986, 12611694, 'AX', 'Kökar', 1, 'koekar', 59.92051, 20.90883),
(3652265, 12611692, 'AX', 'Knutsboda', 1, 'knutsboda', 60.06667, 20.03333),
(3653740, 12611692, 'AX', 'Kastelholm', 1, 'kastelholm', 60.23387, 20.07601),
(3653943, 12611694, 'AX', 'Karlby', 1, 'karlby', 59.92071, 20.90387),
(3654597, 12611694, 'AX', 'Kallsö', 1, 'kallsoe', 59.99599, 20.38709),
(3655244, 12611694, 'AX', 'Jyddö', 1, 'jyddoe', 60.08333, 20.53333),
(3655377, 12611694, 'AX', 'Jurmo', 1, 'jurmo', 60.51848, 21.07744),
(3657052, 12611694, 'AX', 'Husö', 1, 'husoe', 60.06667, 20.8),
(3657118, 12611694, 'AX', 'Hummersö', 1, 'hummersoe', 60.00197, 20.35661),
(3657119, 12611694, 'AX', 'Hummelvik', 1, 'hummelvik', 60.22456, 20.41325),
(3657140, 12611692, 'AX', 'Hulta', 1, 'hulta', 60.28333, 20.25),
(3657352, 12611694, 'AX', 'Horsholma', 1, 'horsholma', 60.04429, 20.56665),
(3657353, 12611694, 'AX', 'Horsholm', 1, 'horsholm', 60.2, 20.28333),
(3657615, 12611692, 'AX', 'Högbolstad', 1, 'hoegbolstad', 60.2, 20.08333),
(3658235, 12611694, 'AX', 'Hellsö', 1, 'hellsoe', 59.9501, 20.94764),
(3658238, 12611692, 'AX', 'Hellestorp', 1, 'hellestorp', 60.06023, 20.09747),
(3658727, 12611694, 'AX', 'Hastersboda', 1, 'hastersboda', 60.02695, 20.57753),
(3658949, 12611692, 'AX', 'Haraldsby', 1, 'haraldsby', 60.25, 20.03333),
(3659473, 12611692, 'AX', 'Haga', 1, 'haga', 60.3, 20.01667),
(3659476, 12611692, 'AX', 'Haddnäs', 1, 'haddnaes', 60.059, 20.20731),
(3659746, 12611694, 'AX', 'Grundsunda', 1, 'grundsunda', 60.21022, 20.37872),
(3659810, 12611692, 'AX', 'Granboda', 1, 'granboda', 60.08333, 20.2),
(3659811, 12611694, 'AX', 'Granboda', 1, 'granboda', 60.04533, 20.44306),
(3659823, 12611692, 'AX', 'Godby', 1, 'godby', 60.22995, 19.9881),
(3659844, 12611692, 'AX', 'Germundö', 1, 'germundoe', 60.28333, 20),
(3659949, 12611694, 'AX', 'Föglö', 1, 'foegloe', 60.01667, 20.41667),
(3659958, 12611694, 'AX', 'Flisö', 1, 'flisoe', 60.01516, 20.34268),
(3659973, 12611692, 'AX', 'Flaka', 1, 'flaka', 60.02613, 20.16911),
(3659984, 12611694, 'AX', 'Fiskö', 1, 'fiskoe', 60.45178, 20.93874),
(3659997, 12611694, 'AX', 'Finnö', 1, 'finnoe', 60.06667, 20.71667),
(3660018, 12611692, 'AX', 'Finby', 1, 'finby', 60.21667, 20.18333),
(3660245, 12611694, 'AX', 'Enklinge', 1, 'enklinge', 60.34141, 20.76446),
(3660383, 12611692, 'AX', 'Domarböle', 1, 'domarboele', 60.23333, 20.13333),
(3660415, 12611694, 'AX', 'Degerby', 1, 'degerby', 60.0305, 20.38876),
(3660448, 12611694, 'AX', 'Bussö', 1, 'bussoe', 60.16667, 20.33333),
(3660499, 12611694, 'AX', 'Bråttö', 1, 'brattoe', 59.99323, 20.32093),
(3660521, 12611694, 'AX', 'Brändö', 1, 'braendoe', 60.41165, 21.04534),
(3660530, 12611692, 'AX', 'Brännbolstad', 1, 'braennbolstad', 60.26667, 20.15),
(3660567, 12611692, 'AX', 'Bomarsund', 1, 'bomarsund', 60.21234, 20.24023),
(3660629, 12611694, 'AX', 'Björsboda', 1, 'bjoersboda', 60.00505, 20.41719),
(3660637, 12611694, 'AX', 'Björnholma', 1, 'bjoernholma', 60.43333, 21.03333),
(3660654, 12611694, 'AX', 'Björkö', 1, 'bjoerkoe', 60.33192, 20.91921),
(3660683, 12611692, 'AX', 'Bistorp', 1, 'bistorp', 60.0819, 20.11043),
(3660709, 12611694, 'AX', 'Bergö', 1, 'bergoe', 60.16478, 20.39976),
(3660738, 12611692, 'AX', 'Bengtsböle', 1, 'bengtsboele', 60.06778, 20.11272),
(3660773, 12611694, 'AX', 'Bänö', 1, 'baenoe', 60.1, 20.6),
(3660779, 12611694, 'AX', 'Baggholma', 1, 'baggholma', 60.38333, 21.03333),
(3660821, 12611694, 'AX', 'Åva', 1, 'ava', 60.45785, 21.07796),
(3660905, 12611694, 'AX', 'Asterholma', 1, 'asterholma', 60.2991, 21.0548),
(3660954, 12611692, 'AX', 'Åsgårda', 1, 'asgarda', 60.31631, 20.07022),
(3661183, 12611694, 'AX', 'Ängö', 1, 'aengoe', 60.15, 20.3),
(3845802, 12611692, 'AX', 'Pellas', 1, 'pellas', 60.0775, 20.18222),
(3845805, 12611692, 'AX', 'Ingela', 1, 'ingela', 60.06731, 20.2655),
(3845810, 12611692, 'AX', 'Åkerlund', 1, 'akerlund', 60.08472, 20.25722),
(3845811, 12611692, 'AX', 'Norrgård', 1, 'norrgard', 60.08472, 20.26361),
(3845812, 12611692, 'AX', 'Bastvik', 1, 'bastvik', 60.08556, 20.145),
(3845814, 12611692, 'AX', 'Högvalla', 1, 'hoegvalla', 60.08139, 20.09361),
(3845822, 12611692, 'AX', 'Björkebo', 1, 'bjoerkebo', 60.02687, 20.12147),
(3845823, 12611692, 'AX', 'Nyäng', 1, 'nyaeng', 60.03712, 20.1031),
(3845826, 12611692, 'AX', 'Österlund', 1, 'oesterlund', 60.06603, 20.09999),
(3845827, 12611692, 'AX', 'Nygård', 1, 'nygard', 60.07333, 20.0725),
(3845831, 12611692, 'AX', 'Nedre Börs', 1, 'nedre-boers', 60.07194, 20.03528),
(3845833, 12611692, 'AX', 'Södergård', 1, 'soedergard', 60.07722, 20.01194),
(3845834, 12611692, 'AX', 'Lemböte', 1, 'lemboete', 60.08028, 20.00389),
(3845847, 12611692, 'AX', 'Näset', 1, 'naeset', 60.00778, 20.11778),
(3845857, 12611692, 'AX', 'Jonases', 1, 'jonases', 60.12, 20.00667),
(3845860, 12611692, 'AX', 'Alfhem', 1, 'alfhem', 60.14139, 20.00139),
(3845864, 12611692, 'AX', 'Janses', 1, 'janses', 60.12444, 20.00778),
(3845877, 12611692, 'AX', 'Björkhem', 1, 'bjoerkhem', 60.12167, 20.22833),
(3845879, 12611692, 'AX', 'Solhem', 1, 'solhem', 60.13194, 20.24444),
(3845880, 12611692, 'AX', 'Tullen', 1, 'tullen', 60.12875, 20.26297),
(3845897, 12611692, 'AX', 'Nästgård', 1, 'naestgard', 60.19611, 20.15583),
(3845899, 12611692, 'AX', 'Norrdal', 1, 'norrdal', 60.20333, 20.15806),
(3845900, 12611692, 'AX', 'Mattas', 1, 'mattas', 60.21, 20.18694),
(3845901, 12611692, 'AX', 'Estvik', 1, 'estvik', 60.20972, 20.20167),
(3845909, 12611694, 'AX', 'Västergård', 1, 'vaestergard', 60.185, 20.26556),
(3845910, 12611692, 'AX', 'Prästö', 1, 'praestoe', 60.20778, 20.25667),
(3845912, 12611692, 'AX', 'Svensböle', 1, 'svensboele', 60.225, 20.15083),
(3845914, 12611692, 'AX', 'Johannelund', 1, 'johannelund', 60.20056, 20.14806),
(3845919, 12611692, 'AX', 'Arnelund', 1, 'arnelund', 60.19861, 20.07833),
(3845926, 12611692, 'AX', 'Tjudnäs', 1, 'tjudnaes', 60.21389, 20.0525),
(3845927, 12611692, 'AX', 'Storängen', 1, 'storaengen', 60.21972, 20.0525),
(3845929, 12611692, 'AX', 'Strömsgärdan', 1, 'stroemsgaerdan', 60.21639, 20.00472),
(3846049, 12611694, 'AX', 'Trångsund', 1, 'trangsund', 59.94694, 20.97861),
(3846055, 12611694, 'AX', 'Söderholm', 1, 'soederholm', 59.92639, 20.95417),
(3846313, 12611694, 'AX', 'Sanda', 1, 'sanda', 60.03664, 20.53984),
(3846314, 12611694, 'AX', 'Ekdal', 1, 'ekdal', 60.04538, 20.56446),
(3846320, 12611694, 'AX', 'Finholma', 1, 'finholma', 60.0632, 20.51957),
(3846359, 12611694, 'AX', 'Englund', 1, 'englund', 60.02341, 20.42148),
(3846362, 12611694, 'AX', 'Näversholma', 1, 'naeversholma', 60.02801, 20.46889),
(3846421, 12611694, 'AX', 'Jakopas', 1, 'jakopas', 60.09083, 20.49611),
(3846501, 12611694, 'AX', 'Gåsvik', 1, 'gasvik', 60.11556, 20.68083),
(3846582, 12611694, 'AX', 'Känskit', 1, 'kaenskit', 60.20528, 20.70278),
(3846583, 12611694, 'AX', 'Mattas', 1, 'mattas', 60.19833, 20.6975),
(3846588, 12611694, 'AX', 'Simas', 1, 'simas', 60.20333, 20.6975),
(3846627, 12611694, 'AX', 'Hellsvik', 1, 'hellsvik', 60.175, 20.43222),
(3846642, 12611694, 'AX', 'Signedal', 1, 'signedal', 60.22389, 20.38306),
(3846644, 12611694, 'AX', 'Nedergård', 1, 'nedergard', 60.22917, 20.38278),
(3846651, 12611694, 'AX', 'Påvals', 1, 'pavals', 60.2125, 20.29778),
(3849690, 12611694, 'AX', 'Lillposten', 1, 'lillposten', 60.24778, 20.39278),
(3849707, 12611694, 'AX', 'Ramsholm', 1, 'ramsholm', 60.24167, 20.80083),
(3849709, 12611694, 'AX', 'Nabbas', 1, 'nabbas', 60.24639, 20.78778),
(3849769, 12611694, 'AX', 'Emtvik', 1, 'emtvik', 60.27917, 20.79639),
(3849771, 12611694, 'AX', 'Kvarnkulla', 1, 'kvarnkulla', 60.26667, 20.765),
(3849817, 12611694, 'AX', 'Hemskär', 1, 'hemskaer', 60.27833, 20.30889),
(3849939, 12611694, 'AX', 'Sälvik', 1, 'saelvik', 60.35111, 20.7475),
(3849940, 12611694, 'AX', 'Finnslätt', 1, 'finnslaett', 60.35917, 20.77),
(3849974, 12611694, 'AX', 'Västernäs', 1, 'vaesternaes', 60.34111, 20.91861),
(3850023, 12611694, 'AX', 'Notholm', 1, 'notholm', 60.43667, 20.93),
(3850147, 12611694, 'AX', 'Hullberga', 1, 'hullberga', 60.52778, 20.88889),
(3850199, 12611692, 'AX', 'Persby', 1, 'persby', 60.24806, 20.18611),
(3850211, 12611692, 'AX', 'Sveden', 1, 'sveden', 60.3125, 20.19417),
(3850214, 12611692, 'AX', 'Djupdal', 1, 'djupdal', 60.29639, 20.17444),
(3850216, 12611692, 'AX', 'Kleven', 1, 'kleven', 60.28472, 20.18139),
(3850222, 12611692, 'AX', 'Strömbolstad', 1, 'stroembolstad', 60.25883, 20.17929),
(3850224, 12611692, 'AX', 'Björby', 1, 'bjoerby', 60.25732, 20.13127),
(3850226, 12611692, 'AX', 'Främmanby', 1, 'fraemmanby', 60.26528, 20.06361),
(3850236, 12611692, 'AX', 'Näs', 1, 'naes', 60.32278, 20.02083),
(3850241, 12611692, 'AX', 'Kvarnbo', 1, 'kvarnbo', 60.28472, 20.04306),
(3850242, 12611692, 'AX', 'Lagmansby', 1, 'lagmansby', 60.28444, 20.06528),
(3850244, 12611692, 'AX', 'Rangsby', 1, 'rangsby', 60.27806, 20.075),
(6041648, 12611689, 'AX', 'Ytternäs', 1, 'ytternaes', 60.08333, 19.95),
(6041650, 12611692, 'AX', 'Västerkalmare', 1, 'vaesterkalmare', 60.13333, 19.96667),
(6041651, 12611692, 'AX', 'Västergeta', 1, 'vaestergeta', 60.38333, 19.85),
(6041652, 12611692, 'AX', 'Västansunda', 1, 'vaestansunda', 60.15, 19.85),
(6041659, 12611692, 'AX', 'Torrbolstad', 1, 'torrbolstad', 60.28333, 19.91667),
(6041662, 12611692, 'AX', 'Torp', 1, 'torp', 60.18333, 19.58333),
(6041666, 12611692, 'AX', 'Tjudö', 1, 'tjudoe', 60.33333, 19.95),
(6041667, 12611692, 'AX', 'Tärnbolstad', 1, 'taernbolstad', 60.26667, 19.96667),
(6041670, 12611692, 'AX', 'Svartsmara', 1, 'svartsmara', 60.24935, 19.88016),
(6041675, 12611692, 'AX', 'Storby', 1, 'storby', 60.22317, 19.55948),
(6041679, 12611692, 'AX', 'Stålsby', 1, 'stalsby', 60.35, 19.98333),
(6041684, 12611692, 'AX', 'Södersunda', 1, 'soedersunda', 60.15, 19.86667),
(6041685, 12611692, 'AX', 'Söderlund', 1, 'soederlund', 60.23333, 19.66667),
(6041687, 12611692, 'AX', 'Snäckö', 1, 'snaeckoe', 60.35, 19.8),
(6041692, 12611692, 'AX', 'Skeppsvik', 1, 'skeppsvik', 60.16667, 19.53333),
(6041698, 12611692, 'AX', 'Sålis', 1, 'salis', 60.25566, 19.74037),
(6041702, 12611692, 'AX', 'Ringsböle', 1, 'ringsboele', 60.2, 19.91667),
(6041704, 12611692, 'AX', 'Rågetsböle', 1, 'ragetsboele', 60.26667, 19.9),
(6041705, 12611692, 'AX', 'Posta', 1, 'posta', 60.23333, 19.78333),
(6041706, 12611692, 'AX', 'Pålsböle', 1, 'palsboele', 60.26319, 19.93246),
(6041707, 12611692, 'AX', 'Överby', 1, 'oeverby', 60.21667, 19.63333),
(6041709, 12611692, 'AX', 'Östergeta', 1, 'oestergeta', 60.38333, 19.88333),
(6041711, 12611692, 'AX', 'Ödkarby', 1, 'oedkarby', 60.30908, 19.98016),
(6041713, 12611692, 'AX', 'Norrsunda', 1, 'norrsunda', 60.16667, 19.88333),
(6041717, 12611692, 'AX', 'Näfsby', 1, 'naefsby', 60.2, 19.8),
(6041718, 12611692, 'AX', 'Nåtö', 1, 'natoe', 60.05, 19.98333),
(6041720, 12611692, 'AX', 'Mörby', 1, 'moerby', 60.23333, 19.71667),
(6041724, 12611692, 'AX', 'Möckelby', 1, 'moeckelby', 60.15083, 19.93944),
(6041729, 12611692, 'AX', 'Marsund', 1, 'marsund', 60.2, 19.7),
(6041732, 12611689, 'AX', 'Mariehamn', 1, 'mariehamn', 60.09726, 19.93481),
(6041734, 12611692, 'AX', 'Marby', 1, 'marby', 60.2, 19.66667),
(6041735, 12611692, 'AX', 'Mangelbo', 1, 'mangelbo', 60.26532, 19.9792),
(6041739, 12611692, 'AX', 'Lillbolstad', 1, 'lillbolstad', 60.25, 19.76667),
(6041750, 12611692, 'AX', 'Kattby', 1, 'kattby', 60.21638, 19.74026),
(6041752, 12611692, 'AX', 'Karrböle', 1, 'karrboele', 60.18333, 19.93333),
(6041753, 12611692, 'AX', 'Karlgård', 1, 'karlgard', 60.15, 19.71667),
(6041759, 12611692, 'AX', 'Jomalby', 1, 'jomalby', 60.18333, 19.98333),
(6041760, 12611692, 'AX', 'Jomala', 1, 'jomala', 60.14902, 19.951),
(6041762, 12611692, 'AX', 'Jättböle', 1, 'jattbole', 60.13333, 19.98333),
(6041763, 12611692, 'AX', 'Isaksö', 1, 'isaksoe', 60.36773, 19.74956),
(6041765, 12611692, 'AX', 'Ingby', 1, 'ingby', 60.16667, 19.95),
(6041769, 12611689, 'AX', 'Hindersböle', 1, 'hindersboele', 60.11667, 19.95),
(6041774, 12611692, 'AX', 'Hamnäs', 1, 'hamnaes', 60.1, 19.83333),
(6041776, 12611692, 'AX', 'Hammarland', 1, 'hammarland', 60.21667, 19.75),
(6041785, 12611692, 'AX', 'Gottby', 1, 'gottby', 60.12992, 19.82191),
(6041786, 12611692, 'AX', 'Gölby', 1, 'goelby', 60.18333, 19.95),
(6041792, 12611692, 'AX', 'Geta', 1, 'geta', 60.37453, 19.84455),
(6041796, 12611692, 'AX', 'Frebbenby', 1, 'frebbenby', 60.21667, 19.71667),
(6041798, 12611692, 'AX', 'Finström', 1, 'finstroem', 60.26667, 19.93333),
(6041802, 12611692, 'AX', 'Finbo', 1, 'finbo', 60.35, 19.58333),
(6041806, 12611692, 'AX', 'Emkarby', 1, 'emkarby', 60.21111, 19.88556),
(6041807, 12611692, 'AX', 'Eckerö', 1, 'eckeroe', 60.21249, 19.61442),
(6041810, 12611692, 'AX', 'Drygsböle', 1, 'drygsboele', 60.18333, 19.8),
(6041812, 12611692, 'AX', 'Djurvik', 1, 'djurvik', 60.11667, 19.76667),
(6041813, 12611692, 'AX', 'Djäkenböle', 1, 'djaekenboele', 60.2, 19.78333),
(6041815, 12611692, 'AX', 'Degersand', 1, 'degersand', 60.15, 19.6),
(6041818, 12611692, 'AX', 'Dånö', 1, 'danoe', 60.40154, 19.77359),
(6041820, 12611692, 'AX', 'Dalkarby', 1, 'dalkarby', 60.13333, 19.95),
(6041821, 12611692, 'AX', 'Buskböle', 1, 'buskboele', 60.18333, 19.95),
(6041823, 12611692, 'AX', 'Bredbolstad', 1, 'bredbolstad', 60.24475, 19.72355),
(6041825, 12611692, 'AX', 'Bovik', 1, 'bovik', 60.25919, 19.70778),
(6041828, 12611692, 'AX', 'Björsby', 1, 'bjoersby', 60.18678, 19.96175),
(6041830, 12611692, 'AX', 'Björnhuvud', 1, 'bjoernhuvud', 60.18515, 19.66578),
(6041831, 12611692, 'AX', 'Bergö', 1, 'bergoe', 60.3, 19.83333),
(6041833, 12611692, 'AX', 'Bastö', 1, 'bastoe', 60.31667, 19.86667),
(6041835, 12611692, 'AX', 'Bamböle', 1, 'bamboele', 60.23333, 19.85),
(6041837, 12611692, 'AX', 'Åttböle', 1, 'attboele', 60.25, 19.91667),
(6041842, 12611692, 'AX', 'Ämnäs', 1, 'amnas', 60.21667, 19.98333),
(6336320, 12611692, 'AX', 'Östergård', 1, 'oestergard', 60.02222, 19.99889),
(6336347, 12611689, 'AX', 'Strandnäs', 1, 'strandnaes', 60.115, 19.94556),
(6336348, 12611689, 'AX', 'Klinten', 1, 'klinten', 60.10861, 19.93),
(6336349, 12611692, 'AX', 'Rommarn', 1, 'rommarn', 60.0975, 19.91528),
(6336351, 12611692, 'AX', 'Trovill', 1, 'trovill', 60.0925, 19.91056),
(6336356, 12611689, 'AX', 'Östra Ytternäs', 1, 'oestra-ytternaes', 60.08306, 19.96278),
(6336357, 12611689, 'AX', 'Västra Ytternäs', 1, 'vaestra-ytternaes', 60.07944, 19.9375),
(6336401, 12611692, 'AX', 'Tallöga', 1, 'talloega', 60.11083, 19.74583),
(6336402, 12611692, 'AX', 'Alebo', 1, 'alebo', 60.09972, 19.78),
(6336413, 12611692, 'AX', 'Karlberg', 1, 'karlberg', 60.11222, 19.81472),
(6336415, 12611692, 'AX', 'Böjsas', 1, 'boejsas', 60.12444, 19.81472),
(6336416, 12611692, 'AX', 'Karls', 1, 'karls', 60.13194, 19.82861),
(6336421, 12611692, 'AX', 'Mellangård', 1, 'mellangard', 60.155, 19.75833),
(6336422, 12611692, 'AX', 'Västergård', 1, 'vaestergard', 60.15889, 19.75639),
(6336423, 12611692, 'AX', 'Furubo', 1, 'furubo', 60.15917, 19.76111),
(6336424, 12611692, 'AX', 'Görans', 1, 'goerans', 60.15333, 19.80056),
(6336435, 12611692, 'AX', 'Nybacka', 1, 'nybacka', 60.12583, 19.83),
(6336436, 12611692, 'AX', 'Bengtas', 1, 'bengtas', 60.11083, 19.84583),
(6336437, 12611692, 'AX', 'Fagerlund', 1, 'fagerlund', 60.10111, 19.86528),
(6336439, 12611692, 'AX', 'Brandö', 1, 'brandoe', 60.11417, 19.88028),
(6336444, 12611692, 'AX', 'Grönbacka', 1, 'groenbacka', 60.13806, 19.97889),
(6336445, 12611692, 'AX', 'Österkalmare', 1, 'oesterkalmare', 60.13028, 19.99583),
(6336446, 12611692, 'AX', 'Ulvsby', 1, 'ulvsby', 60.15861, 19.93083),
(6336447, 12611692, 'AX', 'Kihla', 1, 'kihla', 60.15833, 19.98389),
(6336448, 12611692, 'AX', 'Kyrkobyn', 1, 'kyrkobyn', 60.15139, 19.95167),
(6336450, 12611692, 'AX', 'Kalmsta', 1, 'kalmsta', 60.11861, 19.9675),
(6336453, 12611692, 'AX', 'Julle', 1, 'julle', 60.12861, 19.8975),
(6336454, 12611692, 'AX', 'Boskas', 1, 'boskas', 60.13417, 19.89972),
(6336456, 12611692, 'AX', 'Gibböle', 1, 'gibboele', 60.21167, 19.99139),
(6336457, 12611692, 'AX', 'Norrberg', 1, 'norrberg', 60.20806, 19.97583),
(6336462, 12611692, 'AX', 'Norrängen', 1, 'norraengen', 60.16583, 19.98583),
(6336463, 12611692, 'AX', 'Markusas', 1, 'markusas', 60.16806, 19.95),
(6336474, 12611692, 'AX', 'Vargsunda', 1, 'vargsunda', 60.18028, 19.85583),
(6336476, 12611692, 'AX', 'Kullaö', 1, 'kullaoe', 60.20389, 19.85917),
(6336477, 12611692, 'AX', 'Vikhem', 1, 'vikhem', 60.20972, 19.85889),
(6336478, 12611692, 'AX', 'Bjärström', 1, 'bjaerstroem', 60.21333, 19.85917),
(6336479, 12611692, 'AX', 'Björkbacka', 1, 'bjoerkbacka', 60.21556, 19.85417),
(6336483, 12611692, 'AX', 'Rönnhem', 1, 'roennhem', 60.21444, 19.89778),
(6336485, 12611692, 'AX', 'Stornäs', 1, 'stornaes', 60.22333, 19.94722),
(6336486, 12611692, 'AX', 'Östanåker', 1, 'oestanaker', 60.20611, 19.9025),
(6336490, 12611692, 'AX', 'Andersböle', 1, 'andersboele', 60.18139, 19.94111),
(6336491, 12611692, 'AX', 'Jans', 1, 'jans', 60.18944, 19.93972),
(6336492, 12611692, 'AX', 'Grins', 1, 'grins', 60.18667, 19.94444),
(6336495, 12611692, 'AX', 'Boda', 1, 'boda', 60.185, 19.80472),
(6336499, 12611692, 'AX', 'Mannes', 1, 'mannes', 60.16833, 19.74556),
(6336500, 12611692, 'AX', 'Samuelstorp', 1, 'samuelstorp', 60.16917, 19.74472),
(6336503, 12611692, 'AX', 'Sandhagen', 1, 'sandhagen', 60.18472, 19.69972),
(6336504, 12611692, 'AX', 'Hällesby Sand', 1, 'haellesby-sand', 60.18833, 19.6975),
(6336507, 12611692, 'AX', 'Övergård', 1, 'oevergard', 60.1875, 19.75778),
(6336508, 12611692, 'AX', 'Bolstad', 1, 'bolstad', 60.18556, 19.78278),
(6336510, 12611692, 'AX', 'Karlsö', 1, 'karlsoe', 60.19278, 19.81833),
(6336511, 12611692, 'AX', 'Björknäs', 1, 'bjoerknaes', 60.20056, 19.8275),
(6336514, 12611692, 'AX', 'Strandäng', 1, 'strandaeng', 60.21444, 19.77472),
(6336516, 12611692, 'AX', 'Björkbo', 1, 'bjoerkbo', 60.22028, 19.77306),
(6336517, 12611692, 'AX', 'Laine', 1, 'laine', 60.21833, 19.76028),
(6336518, 12611692, 'AX', 'Månäng', 1, 'manaeng', 60.21861, 19.74056),
(6336519, 12611692, 'AX', 'Västerbo', 1, 'vaesterbo', 60.21667, 19.71167),
(6336520, 12611692, 'AX', 'Örliden', 1, 'oerliden', 60.21528, 19.685),
(6336522, 12611692, 'AX', 'Smeds', 1, 'smeds', 60.20861, 19.67472),
(6336523, 12611692, 'AX', 'Kattnäs', 1, 'kattnaes', 60.19833, 19.69333),
(6336524, 12611692, 'AX', 'Nordström', 1, 'nordstroem', 60.19917, 19.70083),
(6336525, 12611692, 'AX', 'Nedergård', 1, 'nedergard', 60.20194, 19.73472),
(6336526, 12611692, 'AX', 'Bohem', 1, 'bohem', 60.20806, 19.73833),
(6336527, 12611692, 'AX', 'Hellesby', 1, 'hellesby', 60.20361, 19.73861),
(6336529, 12611692, 'AX', 'Grops', 1, 'grops', 60.19806, 19.77472),
(6336537, 12611692, 'AX', 'Bonäs', 1, 'bonaes', 60.17778, 19.59694),
(6336538, 12611692, 'AX', 'Furulund', 1, 'furulund', 60.18444, 19.57917),
(6336540, 12611692, 'AX', 'Östra Mangsjö', 1, 'oestra-mangsjoe', 60.18833, 19.59361),
(6336545, 12611692, 'AX', 'Klemes', 1, 'klemes', 60.21111, 19.66111),
(6336546, 12611692, 'AX', 'Storhaga', 1, 'storhaga', 60.2225, 19.66111),
(6336554, 12611692, 'AX', 'Kyrkoby', 1, 'kyrkoby', 60.21639, 19.60528),
(6336563, 12611692, 'AX', 'Karlsdal', 1, 'karlsdal', 60.17806, 19.52333),
(6336564, 12611692, 'AX', 'Kalsborg', 1, 'kalsborg', 60.17389, 19.53028),
(6336600, 12611692, 'AX', 'Brännskär', 1, 'braennskaer', 60.2425, 19.53278),
(6336602, 12611692, 'AX', 'Hummelvik', 1, 'hummelvik', 60.245, 19.54056),
(6336603, 12611692, 'AX', 'Böle', 1, 'boele', 60.22833, 19.595),
(6336624, 12611692, 'AX', 'Laby', 1, 'laby', 60.31889, 19.99667),
(6336625, 12611692, 'AX', 'Hjortö', 1, 'hjortoe', 60.28175, 19.99014),
(6336626, 12611692, 'AX', 'Markusböle', 1, 'markusboele', 60.25333, 19.91611),
(6336627, 12611692, 'AX', 'Brantsböle', 1, 'brantsboele', 60.27611, 19.91944),
(6336635, 12611692, 'AX', 'Norra Vandö', 1, 'norra-vandoe', 60.32333, 19.91222),
(6336639, 12611692, 'AX', 'Pantsarnäs', 1, 'pantsarnaes', 60.33389, 19.85194),
(6336691, 12611692, 'AX', 'Skarpnåtö', 1, 'skarpnatoe', 60.32559, 19.7541),
(6336749, 12611692, 'AX', 'Öra', 1, 'oera', 60.27722, 19.59056),
(6336796, 12611692, 'AX', 'Olofsnäs', 1, 'olofsnaes', 60.35528, 19.83361),
(6336845, 12611692, 'AX', 'Pettböle', 1, 'pettboele', 60.35611, 19.98333),
(6336849, 12611692, 'AX', 'Västanträsk', 1, 'vaestantraesk', 60.34222, 19.92889),
(6336853, 12611692, 'AX', 'Gräggnäs', 1, 'graeggnaes', 60.35194, 19.84861),
(10667965, 12611692, 'AX', 'Klemetsby', 1, 'klemetsby', 60.12203, 20.26188),
(15217817, 12611692, 'AX', 'Långnäs hamn', 1, 'langnaes-hamn', 60.1169, 20.29711),
(15225703, 12611692, 'AX', 'Sviby', 1, 'sviby', 60.13393, 19.9173);