-- "Sverige"-databasen med Sveriges tätorter, län och kommuner -- Thomas Padron-McCarthy (thomas.padron-mccarthy@oru.se) -- Denna version senast ändrad 9 april 2013 -- Ta bort eventuella gamla versioner av tabellerna -- DROP TABLE "Län" CASCADE; -- DROP TABLE Kommuner CASCADE; -- DROP TABLE "Tätorter" CASCADE; -- Skapa tabellerna CREATE TABLE "Län" (kod INTEGER NOT NULL PRIMARY KEY, bokstav VARCHAR(2) NOT NULL UNIQUE, namn VARCHAR(30) NOT NULL UNIQUE, "folkmängd" INTEGER NOT NULL, residensstad INTEGER); -- Kolumnen "residensstad" refererar till tabellen "Tätorter", men cirkulära referenser, så vi lägger dit det villkoret sist -- Tillåt NULL i Residensstad, annars blir det svårt att fylla tabellerna, också pga cirkulära referenser CREATE TABLE Kommuner (kod INTEGER NOT NULL PRIMARY KEY, namn VARCHAR(30) NOT NULL UNIQUE, "folkmängd" INTEGER NOT NULL, "län" INTEGER REFERENCES "Län"(kod)); CREATE TABLE "Tätorter" (kod INTEGER NOT NULL PRIMARY KEY, namn VARCHAR(40) NOT NULL, -- "Sjöbo sommarby och Svansjö sommarby" ska få plats kommun INTEGER NOT NULL REFERENCES Kommuner(kod), "folkmängd" INTEGER NOT NULL, latitud DECIMAL(8,6), longitud DECIMAL(8,6), elevation INTEGER, UNIQUE(namn, kommun)); -- tätortsnamn är unika inom en kommun men inte inom Sverige ALTER TABLE "Län" ADD CONSTRAINT residensstad FOREIGN KEY (Residensstad) REFERENCES "Tätorter"(Kod); -- Sveriges 21 län enligt Wikipedia 2013 -- NULL för residensstäderna, för vi har inte fyllt tätortstabellen än INSERT INTO "Län" VALUES (01, 'AB', 'Stockholms län', 2127006, NULL); INSERT INTO "Län" VALUES (03, 'C', 'Uppsala län', 341977, NULL); INSERT INTO "Län" VALUES (04, 'D', 'Södermanlands län', 274723, NULL); INSERT INTO "Län" VALUES (05, 'E', 'Östergötlands län', 433784, NULL); INSERT INTO "Län" VALUES (06, 'F', 'Jönköpings län', 339116, NULL); INSERT INTO "Län" VALUES (07, 'G', 'Kronobergs län', 185887, NULL); INSERT INTO "Län" VALUES (08, 'H', 'Kalmar län', 233548, NULL); INSERT INTO "Län" VALUES (09, 'I', 'Gotlands län', 57241, NULL); INSERT INTO "Län" VALUES (10, 'K', 'Blekinge län', 152315, NULL); INSERT INTO "Län" VALUES (12, 'M', 'Skåne län', 1263088, NULL); INSERT INTO "Län" VALUES (13, 'N', 'Hallands län', 304116, NULL); INSERT INTO "Län" VALUES (14, 'O', 'Västra Götalands län', 1600447, NULL); INSERT INTO "Län" VALUES (17, 'S', 'Värmlands län', 273080, NULL); INSERT INTO "Län" VALUES (18, 'T', 'Örebro län', 283113, NULL); INSERT INTO "Län" VALUES (19, 'U', 'Västmanlands län', 256224, NULL); INSERT INTO "Län" VALUES (20, 'W', 'Dalarnas län', 276555, NULL); INSERT INTO "Län" VALUES (21, 'X', 'Gävleborgs län', 276637, NULL); INSERT INTO "Län" VALUES (22, 'Y', 'Västernorrlands län', 241981, NULL); INSERT INTO "Län" VALUES (23, 'Z', 'Jämtlands län', 126201, NULL); INSERT INTO "Län" VALUES (24, 'AC', 'Västerbottens län', 260217, NULL); INSERT INTO "Län" VALUES (25, 'BD', 'Norrbottens län', 248637, NULL); -- Sveriges 290 kommuner enligt Wikipedia 2013 INSERT INTO Kommuner VALUES (114, 'Upplands Väsby kommun', 40723, 1); INSERT INTO Kommuner VALUES (115, 'Vallentuna kommun', 31215, 1); INSERT INTO Kommuner VALUES (117, 'Österåkers kommun', 40269, 1); INSERT INTO Kommuner VALUES (120, 'Värmdö kommun', 39387, 1); INSERT INTO Kommuner VALUES (123, 'Järfälla kommun', 68210, 1); INSERT INTO Kommuner VALUES (125, 'Ekerö kommun', 26160, 1); INSERT INTO Kommuner VALUES (126, 'Huddinge kommun', 101010, 1); INSERT INTO Kommuner VALUES (127, 'Botkyrka kommun', 86274, 1); INSERT INTO Kommuner VALUES (128, 'Salems kommun', 15881, 1); INSERT INTO Kommuner VALUES (136, 'Haninge kommun', 79430, 1); INSERT INTO Kommuner VALUES (138, 'Tyresö kommun', 43764, 1); INSERT INTO Kommuner VALUES (139, 'Upplands-Bro kommun', 24353, 1); INSERT INTO Kommuner VALUES (140, 'Nykvarns kommun', 9442, 1); INSERT INTO Kommuner VALUES (160, 'Täby kommun', 65364, 1); INSERT INTO Kommuner VALUES (162, 'Danderyds kommun', 31960, 1); INSERT INTO Kommuner VALUES (163, 'Sollentuna kommun', 66859, 1); INSERT INTO Kommuner VALUES (180, 'Stockholms kommun', 881235, 1); INSERT INTO Kommuner VALUES (181, 'Södertälje kommun', 89473, 1); INSERT INTO Kommuner VALUES (182, 'Nacka kommun', 92873, 1); INSERT INTO Kommuner VALUES (183, 'Sundbybergs kommun', 40793, 1); INSERT INTO Kommuner VALUES (184, 'Solna kommun', 71293, 1); INSERT INTO Kommuner VALUES (186, 'Lidingö kommun', 44434, 1); INSERT INTO Kommuner VALUES (187, 'Vaxholms kommun', 11126, 1); INSERT INTO Kommuner VALUES (188, 'Norrtälje kommun', 56634, 1); INSERT INTO Kommuner VALUES (191, 'Sigtuna kommun', 42272, 1); INSERT INTO Kommuner VALUES (192, 'Nynäshamns kommun', 26572, 1); INSERT INTO Kommuner VALUES (305, 'Håbo kommun', 19883, 3); INSERT INTO Kommuner VALUES (319, 'Älvkarleby kommun', 9059, 3); INSERT INTO Kommuner VALUES (330, 'Knivsta kommun', 15279, 3); INSERT INTO Kommuner VALUES (331, 'Heby kommun', 13364, 3); INSERT INTO Kommuner VALUES (360, 'Tierps kommun', 20156, 3); INSERT INTO Kommuner VALUES (380, 'Uppsala kommun', 202625, 3); INSERT INTO Kommuner VALUES (381, 'Enköpings kommun', 40349, 3); INSERT INTO Kommuner VALUES (382, 'Östhammars kommun', 21262, 3); INSERT INTO Kommuner VALUES (428, 'Vingåkers kommun', 8775, 4); INSERT INTO Kommuner VALUES (461, 'Gnesta kommun', 10442, 4); INSERT INTO Kommuner VALUES (480, 'Nyköpings kommun', 52336, 4); INSERT INTO Kommuner VALUES (481, 'Oxelösunds kommun', 11236, 4); INSERT INTO Kommuner VALUES (482, 'Flens kommun', 16019, 4); INSERT INTO Kommuner VALUES (483, 'Katrineholms kommun', 32549, 4); INSERT INTO Kommuner VALUES (484, 'Eskilstuna kommun', 98765, 4); INSERT INTO Kommuner VALUES (486, 'Strängnäs kommun', 33072, 4); INSERT INTO Kommuner VALUES (488, 'Trosa kommun', 11529, 4); INSERT INTO Kommuner VALUES (509, 'Ödeshögs kommun', 5200, 5); INSERT INTO Kommuner VALUES (512, 'Ydre kommun', 3612, 5); INSERT INTO Kommuner VALUES (513, 'Kinda kommun', 9744, 5); INSERT INTO Kommuner VALUES (560, 'Boxholms kommun', 5206, 5); INSERT INTO Kommuner VALUES (561, 'Åtvidabergs kommun', 11446, 5); INSERT INTO Kommuner VALUES (562, 'Finspångs kommun', 20791, 5); INSERT INTO Kommuner VALUES (563, 'Valdemarsviks kommun', 7597, 5); INSERT INTO Kommuner VALUES (580, 'Linköpings kommun', 148521, 5); INSERT INTO Kommuner VALUES (581, 'Norrköpings kommun', 132124, 5); INSERT INTO Kommuner VALUES (582, 'Söderköpings kommun', 14143, 5); INSERT INTO Kommuner VALUES (583, 'Motala kommun', 41867, 5); INSERT INTO Kommuner VALUES (584, 'Vadstena kommun', 7338, 5); INSERT INTO Kommuner VALUES (586, 'Mjölby kommun', 26195, 5); INSERT INTO Kommuner VALUES (604, 'Aneby kommun', 6407, 6); INSERT INTO Kommuner VALUES (617, 'Gnosjö kommun', 9354, 6); INSERT INTO Kommuner VALUES (642, 'Mullsjö kommun', 7070, 6); INSERT INTO Kommuner VALUES (643, 'Habo kommun', 10879, 6); INSERT INTO Kommuner VALUES (662, 'Gislaveds kommun', 28732, 6); INSERT INTO Kommuner VALUES (665, 'Vaggeryds kommun', 13148, 6); INSERT INTO Kommuner VALUES (680, 'Jönköpings kommun', 129478, 6); INSERT INTO Kommuner VALUES (682, 'Nässjö kommun', 29382, 6); INSERT INTO Kommuner VALUES (683, 'Värnamo kommun', 33012, 6); INSERT INTO Kommuner VALUES (684, 'Sävsjö kommun', 10844, 6); INSERT INTO Kommuner VALUES (685, 'Vetlanda kommun', 26297, 6); INSERT INTO Kommuner VALUES (686, 'Eksjö kommun', 16368, 6); INSERT INTO Kommuner VALUES (687, 'Tranås kommun', 18145, 6); INSERT INTO Kommuner VALUES (760, 'Uppvidinge kommun', 9276, 7); INSERT INTO Kommuner VALUES (761, 'Lessebo kommun', 8012, 7); INSERT INTO Kommuner VALUES (763, 'Tingsryds kommun', 12141, 7); INSERT INTO Kommuner VALUES (764, 'Alvesta kommun', 19034, 7); INSERT INTO Kommuner VALUES (765, 'Älmhults kommun', 15724, 7); INSERT INTO Kommuner VALUES (767, 'Markaryds kommun', 9477, 7); INSERT INTO Kommuner VALUES (780, 'Växjö kommun', 84800, 7); INSERT INTO Kommuner VALUES (781, 'Ljungby kommun', 27423, 7); INSERT INTO Kommuner VALUES (821, 'Högsby kommun', 5730, 8); INSERT INTO Kommuner VALUES (834, 'Torsås kommun', 6858, 8); INSERT INTO Kommuner VALUES (840, 'Mörbylånga kommun', 14256, 8); INSERT INTO Kommuner VALUES (860, 'Hultsfreds kommun', 13550, 8); INSERT INTO Kommuner VALUES (861, 'Mönsterås kommun', 12799, 8); INSERT INTO Kommuner VALUES (862, 'Emmaboda kommun', 8991, 8); INSERT INTO Kommuner VALUES (880, 'Kalmar kommun', 63671, 8); INSERT INTO Kommuner VALUES (881, 'Nybro kommun', 19486, 8); INSERT INTO Kommuner VALUES (882, 'Oskarshamns kommun', 26144, 8); INSERT INTO Kommuner VALUES (883, 'Västerviks kommun', 35892, 8); INSERT INTO Kommuner VALUES (884, 'Vimmerby kommun', 15403, 8); INSERT INTO Kommuner VALUES (885, 'Borgholms kommun', 10768, 8); INSERT INTO Kommuner VALUES (980, 'Gotlands kommun', 57241, 9); INSERT INTO Kommuner VALUES (1060, 'Olofströms kommun', 12896, 10); INSERT INTO Kommuner VALUES (1080, 'Karlskrona kommun', 63691, 10); INSERT INTO Kommuner VALUES (1081, 'Ronneby kommun', 27788, 10); INSERT INTO Kommuner VALUES (1082, 'Karlshamns kommun', 31132, 10); INSERT INTO Kommuner VALUES (1083, 'Sölvesborgs kommun', 16808, 10); INSERT INTO Kommuner VALUES (1214, 'Svalövs kommun', 13275, 12); INSERT INTO Kommuner VALUES (1230, 'Staffanstorps kommun', 22534, 12); INSERT INTO Kommuner VALUES (1231, 'Burlövs kommun', 17011, 12); INSERT INTO Kommuner VALUES (1233, 'Vellinge kommun', 33615, 12); INSERT INTO Kommuner VALUES (1256, 'Östra Göinge kommun', 13620, 12); INSERT INTO Kommuner VALUES (1257, 'Örkelljunga kommun', 9655, 12); INSERT INTO Kommuner VALUES (1260, 'Bjuvs kommun', 14866, 12); INSERT INTO Kommuner VALUES (1261, 'Kävlinge kommun', 29427, 12); INSERT INTO Kommuner VALUES (1262, 'Lomma kommun', 22298, 12); INSERT INTO Kommuner VALUES (1263, 'Svedala kommun', 19971, 12); INSERT INTO Kommuner VALUES (1264, 'Skurups kommun', 14955, 12); INSERT INTO Kommuner VALUES (1265, 'Sjöbo kommun', 18290, 12); INSERT INTO Kommuner VALUES (1266, 'Hörby kommun', 14958, 12); INSERT INTO Kommuner VALUES (1267, 'Höörs kommun', 15526, 12); INSERT INTO Kommuner VALUES (1270, 'Tomelilla kommun', 12917, 12); INSERT INTO Kommuner VALUES (1272, 'Bromölla kommun', 12250, 12); INSERT INTO Kommuner VALUES (1273, 'Osby kommun', 12637, 12); INSERT INTO Kommuner VALUES (1275, 'Perstorps kommun', 7096, 12); INSERT INTO Kommuner VALUES (1276, 'Klippans kommun', 16660, 12); INSERT INTO Kommuner VALUES (1277, 'Åstorps kommun', 14806, 12); INSERT INTO Kommuner VALUES (1278, 'Båstads kommun', 14263, 12); INSERT INTO Kommuner VALUES (1280, 'Malmö kommun', 307758, 12); INSERT INTO Kommuner VALUES (1281, 'Lunds kommun', 112950, 12); INSERT INTO Kommuner VALUES (1282, 'Landskrona kommun', 42560, 12); INSERT INTO Kommuner VALUES (1283, 'Helsingborgs kommun', 132011, 12); INSERT INTO Kommuner VALUES (1284, 'Höganäs kommun', 24863, 12); INSERT INTO Kommuner VALUES (1285, 'Eslövs kommun', 31744, 12); INSERT INTO Kommuner VALUES (1286, 'Ystads kommun', 28558, 12); INSERT INTO Kommuner VALUES (1287, 'Trelleborgs kommun', 42605, 12); INSERT INTO Kommuner VALUES (1290, 'Kristianstads kommun', 80507, 12); INSERT INTO Kommuner VALUES (1291, 'Simrishamns kommun', 18997, 12); INSERT INTO Kommuner VALUES (1292, 'Ängelholms kommun', 39742, 12); INSERT INTO Kommuner VALUES (1293, 'Hässleholms kommun', 50163, 12); INSERT INTO Kommuner VALUES (1315, 'Hylte kommun', 10032, 13); INSERT INTO Kommuner VALUES (1380, 'Halmstads kommun', 93231, 13); INSERT INTO Kommuner VALUES (1381, 'Laholms kommun', 23458, 13); INSERT INTO Kommuner VALUES (1382, 'Falkenbergs kommun', 41423, 13); INSERT INTO Kommuner VALUES (1383, 'Varbergs kommun', 59186, 13); INSERT INTO Kommuner VALUES (1384, 'Kungsbacka kommun', 76786, 13); INSERT INTO Kommuner VALUES (1401, 'Härryda kommun', 35223, 14); INSERT INTO Kommuner VALUES (1402, 'Partille kommun', 35837, 14); INSERT INTO Kommuner VALUES (1407, 'Öckerö kommun', 12539, 14); INSERT INTO Kommuner VALUES (1415, 'Stenungsunds kommun', 24868, 14); INSERT INTO Kommuner VALUES (1419, 'Tjörns kommun', 14974, 14); INSERT INTO Kommuner VALUES (1421, 'Orusts kommun', 15083, 14); INSERT INTO Kommuner VALUES (1427, 'Sotenäs kommun', 9004, 14); INSERT INTO Kommuner VALUES (1430, 'Munkedals kommun', 10173, 14); INSERT INTO Kommuner VALUES (1435, 'Tanums kommun', 12270, 14); INSERT INTO Kommuner VALUES (1438, 'Dals-Eds kommun', 4665, 14); INSERT INTO Kommuner VALUES (1439, 'Färgelanda kommun', 6549, 14); INSERT INTO Kommuner VALUES (1440, 'Ale kommun', 27842, 14); INSERT INTO Kommuner VALUES (1441, 'Lerums kommun', 39070, 14); INSERT INTO Kommuner VALUES (1442, 'Vårgårda kommun', 11030, 14); INSERT INTO Kommuner VALUES (1443, 'Bollebygds kommun', 8507, 14); INSERT INTO Kommuner VALUES (1444, 'Grästorps kommun', 5639, 14); INSERT INTO Kommuner VALUES (1445, 'Essunga kommun', 5502, 14); INSERT INTO Kommuner VALUES (1446, 'Karlsborgs kommun', 6699, 14); INSERT INTO Kommuner VALUES (1447, 'Gullspångs kommun', 5221, 14); INSERT INTO Kommuner VALUES (1452, 'Tranemo kommun', 11573, 14); INSERT INTO Kommuner VALUES (1460, 'Bengtsfors kommun', 9588, 14); INSERT INTO Kommuner VALUES (1461, 'Melleruds kommun', 8946, 14); INSERT INTO Kommuner VALUES (1462, 'Lilla Edets kommun', 12580, 14); INSERT INTO Kommuner VALUES (1463, 'Marks kommun', 33763, 14); INSERT INTO Kommuner VALUES (1465, 'Svenljunga kommun', 10239, 14); INSERT INTO Kommuner VALUES (1466, 'Herrljunga kommun', 9282, 14); INSERT INTO Kommuner VALUES (1470, 'Vara kommun', 15557, 14); INSERT INTO Kommuner VALUES (1471, 'Götene kommun', 13092, 14); INSERT INTO Kommuner VALUES (1472, 'Tibro kommun', 10673, 14); INSERT INTO Kommuner VALUES (1473, 'Töreboda kommun', 9009, 14); INSERT INTO Kommuner VALUES (1480, 'Göteborgs kommun', 526089, 14); INSERT INTO Kommuner VALUES (1481, 'Mölndals kommun', 61659, 14); INSERT INTO Kommuner VALUES (1482, 'Kungälvs kommun', 41753, 14); INSERT INTO Kommuner VALUES (1484, 'Lysekils kommun', 14396, 14); INSERT INTO Kommuner VALUES (1485, 'Uddevalla kommun', 52530, 14); INSERT INTO Kommuner VALUES (1486, 'Strömstads kommun', 12295, 14); INSERT INTO Kommuner VALUES (1487, 'Vänersborgs kommun', 36968, 14); INSERT INTO Kommuner VALUES (1488, 'Trollhättans kommun', 55749, 14); INSERT INTO Kommuner VALUES (1489, 'Alingsås kommun', 38355, 14); INSERT INTO Kommuner VALUES (1490, 'Borås kommun', 104867, 14); INSERT INTO Kommuner VALUES (1491, 'Ulricehamns kommun', 23015, 14); INSERT INTO Kommuner VALUES (1492, 'Åmåls kommun', 12211, 14); INSERT INTO Kommuner VALUES (1493, 'Mariestads kommun', 23739, 14); INSERT INTO Kommuner VALUES (1494, 'Lidköpings kommun', 38254, 14); INSERT INTO Kommuner VALUES (1495, 'Skara kommun', 18281, 14); INSERT INTO Kommuner VALUES (1496, 'Skövde kommun', 52212, 14); INSERT INTO Kommuner VALUES (1497, 'Hjo kommun', 8832, 14); INSERT INTO Kommuner VALUES (1498, 'Tidaholms kommun', 12556, 14); INSERT INTO Kommuner VALUES (1499, 'Falköpings kommun', 31689, 14); INSERT INTO Kommuner VALUES (1715, 'Kils kommun', 11782, 17); INSERT INTO Kommuner VALUES (1730, 'Eda kommun', 8496, 17); INSERT INTO Kommuner VALUES (1737, 'Torsby kommun', 12219, 17); INSERT INTO Kommuner VALUES (1760, 'Storfors kommun', 4150, 17); INSERT INTO Kommuner VALUES (1761, 'Hammarö kommun', 15061, 17); INSERT INTO Kommuner VALUES (1762, 'Munkfors kommun', 3642, 17); INSERT INTO Kommuner VALUES (1763, 'Forshaga kommun', 11311, 17); INSERT INTO Kommuner VALUES (1764, 'Grums kommun', 8939, 17); INSERT INTO Kommuner VALUES (1765, 'Årjängs kommun', 9864, 17); INSERT INTO Kommuner VALUES (1766, 'Sunne kommun', 13102, 17); INSERT INTO Kommuner VALUES (1780, 'Karlstads kommun', 86929, 17); INSERT INTO Kommuner VALUES (1781, 'Kristinehamns kommun', 23729, 17); INSERT INTO Kommuner VALUES (1782, 'Filipstads kommun', 10549, 17); INSERT INTO Kommuner VALUES (1783, 'Hagfors kommun', 12170, 17); INSERT INTO Kommuner VALUES (1784, 'Arvika kommun', 25829, 17); INSERT INTO Kommuner VALUES (1785, 'Säffle kommun', 15308, 17); INSERT INTO Kommuner VALUES (1814, 'Lekebergs kommun', 7298, 18); INSERT INTO Kommuner VALUES (1860, 'Laxå kommun', 5552, 18); INSERT INTO Kommuner VALUES (1861, 'Hallsbergs kommun', 15283, 18); INSERT INTO Kommuner VALUES (1862, 'Degerfors kommun', 9477, 18); INSERT INTO Kommuner VALUES (1863, 'Hällefors kommun', 6988, 18); INSERT INTO Kommuner VALUES (1864, 'Ljusnarsbergs kommun', 4848, 18); INSERT INTO Kommuner VALUES (1880, 'Örebro kommun', 138952, 18); INSERT INTO Kommuner VALUES (1881, 'Kumla kommun', 20738, 18); INSERT INTO Kommuner VALUES (1882, 'Askersunds kommun', 11011, 18); INSERT INTO Kommuner VALUES (1883, 'Karlskoga kommun', 29631, 18); INSERT INTO Kommuner VALUES (1884, 'Nora kommun', 10356, 18); INSERT INTO Kommuner VALUES (1885, 'Lindesbergs kommun', 22979, 18); INSERT INTO Kommuner VALUES (1904, 'Skinnskattebergs kommun', 4392, 19); INSERT INTO Kommuner VALUES (1907, 'Surahammars kommun', 9890, 19); INSERT INTO Kommuner VALUES (1960, 'Kungsörs kommun', 8030, 19); INSERT INTO Kommuner VALUES (1961, 'Hallstahammars kommun', 15346, 19); INSERT INTO Kommuner VALUES (1962, 'Norbergs kommun', 5630, 19); INSERT INTO Kommuner VALUES (1980, 'Västerås kommun', 140499, 19); INSERT INTO Kommuner VALUES (1981, 'Sala kommun', 21596, 19); INSERT INTO Kommuner VALUES (1982, 'Fagersta kommun', 12634, 19); INSERT INTO Kommuner VALUES (1983, 'Köpings kommun', 24854, 19); INSERT INTO Kommuner VALUES (1984, 'Arboga kommun', 13353, 19); INSERT INTO Kommuner VALUES (2021, 'Vansbro kommun', 6779, 20); INSERT INTO Kommuner VALUES (2023, 'Malung-Sälens kommun', 10178, 20); INSERT INTO Kommuner VALUES (2026, 'Gagnefs kommun', 10012, 20); INSERT INTO Kommuner VALUES (2029, 'Leksands kommun', 15146, 20); INSERT INTO Kommuner VALUES (2031, 'Rättviks kommun', 10799, 20); INSERT INTO Kommuner VALUES (2034, 'Orsa kommun', 6835, 20); INSERT INTO Kommuner VALUES (2039, 'Älvdalens kommun', 7139, 20); INSERT INTO Kommuner VALUES (2061, 'Smedjebackens kommun', 10650, 20); INSERT INTO Kommuner VALUES (2062, 'Mora kommun', 20082, 20); INSERT INTO Kommuner VALUES (2080, 'Falu kommun', 56432, 20); INSERT INTO Kommuner VALUES (2081, 'Borlänge kommun', 49482, 20); INSERT INTO Kommuner VALUES (2082, 'Säters kommun', 10851, 20); INSERT INTO Kommuner VALUES (2083, 'Hedemora kommun', 15064, 20); INSERT INTO Kommuner VALUES (2084, 'Avesta kommun', 21467, 20); INSERT INTO Kommuner VALUES (2085, 'Ludvika kommun', 25639, 20); INSERT INTO Kommuner VALUES (2101, 'Ockelbo kommun', 5850, 21); INSERT INTO Kommuner VALUES (2104, 'Hofors kommun', 9521, 21); INSERT INTO Kommuner VALUES (2121, 'Ovanåkers kommun', 11392, 21); INSERT INTO Kommuner VALUES (2132, 'Nordanstigs kommun', 9533, 21); INSERT INTO Kommuner VALUES (2161, 'Ljusdals kommun', 18880, 21); INSERT INTO Kommuner VALUES (2180, 'Gävle kommun', 96170, 21); INSERT INTO Kommuner VALUES (2181, 'Sandvikens kommun', 37089, 21); INSERT INTO Kommuner VALUES (2182, 'Söderhamns kommun', 25223, 21); INSERT INTO Kommuner VALUES (2183, 'Bollnäs kommun', 26158, 21); INSERT INTO Kommuner VALUES (2184, 'Hudiksvalls kommun', 36821, 21); INSERT INTO Kommuner VALUES (2260, 'Ånge kommun', 9639, 22); INSERT INTO Kommuner VALUES (2262, 'Timrå kommun', 17997, 22); INSERT INTO Kommuner VALUES (2280, 'Härnösands kommun', 24398, 22); INSERT INTO Kommuner VALUES (2281, 'Sundsvalls kommun', 96687, 22); INSERT INTO Kommuner VALUES (2282, 'Kramfors kommun', 18516, 22); INSERT INTO Kommuner VALUES (2283, 'Sollefteå kommun', 19736, 22); INSERT INTO Kommuner VALUES (2284, 'Örnsköldsviks kommun', 55008, 22); INSERT INTO Kommuner VALUES (2303, 'Ragunda kommun', 5466, 23); INSERT INTO Kommuner VALUES (2305, 'Bräcke kommun', 6655, 23); INSERT INTO Kommuner VALUES (2309, 'Krokoms kommun', 14590, 23); INSERT INTO Kommuner VALUES (2313, 'Strömsunds kommun', 12138, 23); INSERT INTO Kommuner VALUES (2321, 'Åre kommun', 10406, 23); INSERT INTO Kommuner VALUES (2326, 'Bergs kommun', 7215, 23); INSERT INTO Kommuner VALUES (2361, 'Härjedalens kommun', 10246, 23); INSERT INTO Kommuner VALUES (2380, 'Östersunds kommun', 59485, 23); INSERT INTO Kommuner VALUES (2401, 'Nordmalings kommun', 7039, 24); INSERT INTO Kommuner VALUES (2403, 'Bjurholms kommun', 2421, 24); INSERT INTO Kommuner VALUES (2404, 'Vindelns kommun', 5359, 24); INSERT INTO Kommuner VALUES (2409, 'Robertsfors kommun', 6717, 24); INSERT INTO Kommuner VALUES (2417, 'Norsjö kommun', 4172, 24); INSERT INTO Kommuner VALUES (2418, 'Malå kommun', 3196, 24); INSERT INTO Kommuner VALUES (2421, 'Storumans kommun', 6006, 24); INSERT INTO Kommuner VALUES (2422, 'Sorsele kommun', 2673, 24); INSERT INTO Kommuner VALUES (2425, 'Dorotea kommun', 2794, 24); INSERT INTO Kommuner VALUES (2460, 'Vännäs kommun', 8522, 24); INSERT INTO Kommuner VALUES (2462, 'Vilhelmina kommun', 6941, 24); INSERT INTO Kommuner VALUES (2463, 'Åsele kommun', 2958, 24); INSERT INTO Kommuner VALUES (2480, 'Umeå kommun', 117294, 24); INSERT INTO Kommuner VALUES (2481, 'Lycksele kommun', 12351, 24); INSERT INTO Kommuner VALUES (2482, 'Skellefteå kommun', 71774, 24); INSERT INTO Kommuner VALUES (2505, 'Arvidsjaurs kommun', 6467, 25); INSERT INTO Kommuner VALUES (2506, 'Arjeplogs kommun', 3054, 25); INSERT INTO Kommuner VALUES (2510, 'Jokkmokks kommun', 5086, 25); INSERT INTO Kommuner VALUES (2513, 'Överkalix kommun', 3497, 25); INSERT INTO Kommuner VALUES (2514, 'Kalix kommun', 16518, 25); INSERT INTO Kommuner VALUES (2518, 'Övertorneå kommun', 4772, 25); INSERT INTO Kommuner VALUES (2521, 'Pajala kommun', 6279, 25); INSERT INTO Kommuner VALUES (2523, 'Gällivare kommun', 18307, 25); INSERT INTO Kommuner VALUES (2560, 'Älvsbyns kommun', 8200, 25); INSERT INTO Kommuner VALUES (2580, 'Luleå kommun', 74905, 25); INSERT INTO Kommuner VALUES (2581, 'Piteå kommun', 41078, 25); INSERT INTO Kommuner VALUES (2582, 'Bodens kommun', 27598, 25); INSERT INTO Kommuner VALUES (2583, 'Haparanda kommun', 9904, 25); INSERT INTO Kommuner VALUES (2584, 'Kiruna kommun', 22972, 25); -- Sveriges 1956 tätorter enligt SCB, via svenska Wikipedia 2011, med koordinater från geonames.org, eventuellt med någon senare rättelse INSERT INTO "Tätorter" VALUES (100, 'Bergshamra', 188, 749, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (102, 'Bammarboda', 117, 249, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (104, 'Boo', 182, 24052, 59.333330, 18.283330, 34); INSERT INTO "Tätorter" VALUES (106, 'Björnömalmen och Klacknäset', 120, 624, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (108, 'Brevik', 186, 8772, 59.350000, 18.200000, 10); INSERT INTO "Tätorter" VALUES (110, 'Brevikshalvön', 138, 2018, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (112, 'Bro', 139, 7050, 59.516670, 17.633330, 17); INSERT INTO "Tätorter" VALUES (116, 'Brottby', 115, 205, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (120, 'Brunn', 120, 950, 59.280000, 18.430000, 25); INSERT INTO "Tätorter" VALUES (124, 'Brunna', 139, 3925, 60.262550, 16.010340, 55); INSERT INTO "Tätorter" VALUES (132, 'Dalarö', 136, 1199, 59.133060, 18.406390, NULL); INSERT INTO "Tätorter" VALUES (136, 'Djurö', 120, 967, 59.316670, 18.683330, NULL); INSERT INTO "Tätorter" VALUES (140, 'Drottningholm', 125, 398, 59.325130, 17.887800, 1); INSERT INTO "Tätorter" VALUES (144, 'Edsbro', 188, 488, 59.900000, 18.483330, 15); INSERT INTO "Tätorter" VALUES (148, 'Ekeby', 181, 1018, 59.250000, 17.520000, 55); INSERT INTO "Tätorter" VALUES (150, 'Ekerö', 125, 10907, 59.291000, 17.812120, 18); INSERT INTO "Tätorter" VALUES (151, 'Ekerö sommarstad', 125, 544, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (152, 'Ekeby', 114, 258, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (154, 'Värmdö-Evlinge', 120, 559, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (156, 'Fisksätra', 182, 7475, 59.283330, 18.266670, 33); INSERT INTO "Tätorter" VALUES (158, 'Finkarby', 140, 214, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (164, 'Finsta', 188, 244, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (166, 'Fågelvikshöjden', 120, 1043, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (168, 'Grisslehamn', 188, 249, 60.100000, 18.833330, 1); INSERT INTO "Tätorter" VALUES (170, 'Gimmersta', 138, 354, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (172, 'Gustavsberg', 120, 11333, 59.326840, 18.389750, 18); INSERT INTO "Tätorter" VALUES (176, 'Hallstavik', 188, 4476, 60.050000, 18.600000, 31); INSERT INTO "Tätorter" VALUES (178, 'Gladö kvarn', 126, 539, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (180, 'Hemmesta', 120, 5240, 59.316670, 18.500000, 5); INSERT INTO "Tätorter" VALUES (182, 'Parksidan', 125, 494, 59.283330, 17.833330, 20); INSERT INTO "Tätorter" VALUES (184, 'Herräng', 188, 422, 60.133330, 18.650000, 14); INSERT INTO "Tätorter" VALUES (186, 'Hedvigsberg', 120, 282, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (190, 'Håbo-Tibble kyrkby', 139, 256, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (192, 'Hästhagen', 182, 499, 60.216670, 18.516670, NULL); INSERT INTO "Tätorter" VALUES (194, 'Hagbyhöjden', 117, 479, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (196, 'Hölö', 181, 1400, 59.283330, 18.666670, 20); INSERT INTO "Tätorter" VALUES (198, 'Ingaröstrand', 120, 286, 59.283330, 18.500000, 21); INSERT INTO "Tätorter" VALUES (200, 'Jordbro', 136, 10291, 59.149720, 18.116670, 49); INSERT INTO "Tätorter" VALUES (202, 'Johannesudd', 115, 249, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (204, 'Järna', 181, 6377, 59.100000, 17.566670, 32); INSERT INTO "Tätorter" VALUES (208, 'Karby', 115, 865, 60.150000, 17.583330, 17); INSERT INTO "Tätorter" VALUES (212, 'Kil', 182, 731, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (214, 'Kopparmora', 120, 631, 59.333060, 18.583060, 14); INSERT INTO "Tätorter" VALUES (216, 'Kummelnäs', 182, 3848, 59.350000, 18.283330, 19); INSERT INTO "Tätorter" VALUES (218, 'Kungsberga', 125, 406, 59.400000, 17.633330, 16); INSERT INTO "Tätorter" VALUES (220, 'Kungsängen', 139, 9382, 59.478570, 17.748340, 20); INSERT INTO "Tätorter" VALUES (222, 'Kullö', 187, 889, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (224, 'Kårsta', 115, 457, 62.566670, 17.133330, 150); INSERT INTO "Tätorter" VALUES (226, 'Landfjärden', 192, 241, 59.033330, 17.983330, 21); INSERT INTO "Tätorter" VALUES (228, 'Lidingö', 186, 31561, 59.366670, 18.133330, 22); INSERT INTO "Tätorter" VALUES (230, 'Lilla Stenby', 125, 244, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (232, 'Lindholmen', 115, 860, 59.583330, 18.100000, 8); INSERT INTO "Tätorter" VALUES (234, 'Långvik', 120, 559, 66.116670, 22.233330, 143); INSERT INTO "Tätorter" VALUES (236, 'Löwenströmska lasarettet', 114, 518, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (238, 'Muskö', 136, 261, 58.983060, 18.133060, 6); INSERT INTO "Tätorter" VALUES (240, 'Märsta', 191, 24068, 59.616670, 17.850000, 24); INSERT INTO "Tätorter" VALUES (242, 'Mariedal', 139, 297, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (244, 'Mölnbo', 181, 1052, 59.050000, 17.416670, 16); INSERT INTO "Tätorter" VALUES (246, 'Lurudden', 125, 205, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (248, 'Mörtnäs', 120, 1511, 59.316670, 18.450000, 2); INSERT INTO "Tätorter" VALUES (250, 'Norra Lagnö', 120, 332, 59.350000, 18.416670, 7); INSERT INTO "Tätorter" VALUES (252, 'Norrtälje', 188, 17275, 59.757990, 18.704960, 26); INSERT INTO "Tätorter" VALUES (254, 'Lidatorp', 192, 340, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (256, 'Norrö', 117, 305, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (260, 'Nykvarn', 140, 6497, 59.800000, 18.300000, 19); INSERT INTO "Tätorter" VALUES (262, 'Nygårds hagar', 140, 328, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (264, 'Nynäshamn', 192, 13510, 58.903370, 17.947930, 1); INSERT INTO "Tätorter" VALUES (266, 'Sundby', 125, 270, 59.500000, 17.300000, 24); INSERT INTO "Tätorter" VALUES (268, 'Oskar-Fredriksborg', 187, 722, 59.400000, 18.433330, 11); INSERT INTO "Tätorter" VALUES (272, 'Pershagen', 181, 2216, 59.166670, 17.650000, 1); INSERT INTO "Tätorter" VALUES (274, 'Raksta', 138, 746, 59.216670, 18.300000, 51); INSERT INTO "Tätorter" VALUES (276, 'Resarö', 187, 2946, 59.429100, 18.333860, 24); INSERT INTO "Tätorter" VALUES (278, 'Riala', 188, 215, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (280, 'Rimbo', 188, 4629, 59.750000, 18.366670, 13); INSERT INTO "Tätorter" VALUES (282, 'Riksten', 127, 839, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (284, 'Rosersberg', 191, 1671, 59.583330, 17.883330, 26); INSERT INTO "Tätorter" VALUES (286, 'Rättarboda', 139, 237, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (288, 'Täby', 160, 61272, 59.443900, 18.068720, 8); INSERT INTO "Tätorter" VALUES (290, 'Täljö', 117, 387, 59.472730, 18.234520, 33); INSERT INTO "Tätorter" VALUES (292, 'Rydbo', 117, 582, 59.461910, 18.185380, 38); INSERT INTO "Tätorter" VALUES (294, 'Rånäs', 188, 428, 59.800000, 18.283330, 18); INSERT INTO "Tätorter" VALUES (296, 'Saltsjöbaden', 182, 9491, 59.283330, 18.300000, 8); INSERT INTO "Tätorter" VALUES (298, 'Sibble', 127, 309, 59.116670, 17.750000, 23); INSERT INTO "Tätorter" VALUES (300, 'Sigtuna', 191, 8444, 59.617310, 17.723610, 35); INSERT INTO "Tätorter" VALUES (302, 'Solberga', 117, 409, 60.983330, 15.216670, 227); INSERT INTO "Tätorter" VALUES (304, 'Sjöberg', 163, 4310, 64.833330, 16.250000, 510); INSERT INTO "Tätorter" VALUES (306, 'Skärgårdsstad', 117, 1924, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (308, 'Skebobruk', 188, 282, 59.966670, 18.600000, 18); INSERT INTO "Tätorter" VALUES (310, 'Sandviken', 181, 338, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (312, 'Skeppsdalsström', 120, 1573, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (314, 'Lugnet och Skälsmara', 120, 625, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (318, 'Solsidan', 125, 349, 59.400000, 17.550000, 17); INSERT INTO "Tätorter" VALUES (320, 'Sorunda', 192, 1307, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (324, 'Stavsnäs', 120, 810, 59.283330, 18.683330, 10); INSERT INTO "Tätorter" VALUES (326, 'Stava', 117, 305, 58.133330, 14.550000, 161); INSERT INTO "Tätorter" VALUES (328, 'Stenhamra', 125, 3336, 59.333330, 17.666670, 1); INSERT INTO "Tätorter" VALUES (330, 'Segersäng', 192, 608, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (332, 'Sticklinge udde', 186, 2943, 59.386140, 18.105670, NULL); INSERT INTO "Tätorter" VALUES (336, 'Stockholm', 180, 1372565, 59.332580, 18.064900, 20); INSERT INTO "Tätorter" VALUES (340, 'Stora Vika', 192, 651, 58.933330, 17.800000, NULL); INSERT INTO "Tätorter" VALUES (342, 'Strömma', 120, 579, 59.708330, 19.000000, NULL); INSERT INTO "Tätorter" VALUES (348, 'Svanberga', 188, 501, 59.833330, 18.650000, 10); INSERT INTO "Tätorter" VALUES (350, 'Svinninge', 117, 1636, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (352, 'Söderby-Karl', 188, 231, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (354, 'Södersvik', 188, 281, 59.783330, 18.983330, 1); INSERT INTO "Tätorter" VALUES (356, 'Södertälje', 181, 64619, 59.195540, 17.625250, 35); INSERT INTO "Tätorter" VALUES (362, 'Söderby', 125, 250, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (364, 'Grödby', 192, 340, 59.050000, 17.883330, 29); INSERT INTO "Tätorter" VALUES (366, 'Torsby', 120, 477, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (368, 'Tranholmen', 162, 338, 59.375710, 18.087100, NULL); INSERT INTO "Tätorter" VALUES (372, 'Tumba', 127, 37852, 59.198580, 17.833170, 48); INSERT INTO "Tätorter" VALUES (374, 'Tuna', 181, 232, 62.650000, 17.333330, 134); INSERT INTO "Tätorter" VALUES (378, 'Tureholm', 125, 260, 59.316670, 17.716670, 24); INSERT INTO "Tätorter" VALUES (384, 'Upplands Väsby', 114, 37594, 59.518390, 17.911280, 15); INSERT INTO "Tätorter" VALUES (388, 'Vallentuna', 115, 29519, 59.534360, 18.077580, 15); INSERT INTO "Tätorter" VALUES (390, 'Vattubrinken', 181, 332, 59.233330, 17.583330, 53); INSERT INTO "Tätorter" VALUES (392, 'Vaxholm', 187, 4857, 59.402250, 18.353170, NULL); INSERT INTO "Tätorter" VALUES (394, 'Vidja', 126, 682, 59.200000, 18.066670, 52); INSERT INTO "Tätorter" VALUES (396, 'Vårsta', 127, 2396, 59.166670, 17.800000, 54); INSERT INTO "Tätorter" VALUES (398, 'Viksäter', 181, 459, 63.000000, 18.100000, 140); INSERT INTO "Tätorter" VALUES (402, 'Väländan', 136, 469, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (404, 'Västerhaninge', 136, 15134, 59.116670, 18.100000, 39); INSERT INTO "Tätorter" VALUES (406, 'Ådran', 126, 244, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (408, 'Åkersberga', 117, 28033, 59.479440, 18.299670, 10); INSERT INTO "Tätorter" VALUES (410, 'Återvall', 120, 206, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (412, 'Älmsta', 188, 1097, 59.966670, 18.800000, 13); INSERT INTO "Tätorter" VALUES (414, 'Älvnäs', 125, 601, 59.283330, 17.766670, 21); INSERT INTO "Tätorter" VALUES (416, 'Älta', 182, 9989, 59.266670, 18.183330, 52); INSERT INTO "Tätorter" VALUES (418, 'Ängsvik', 120, 403, 59.350000, 18.516670, 8); INSERT INTO "Tätorter" VALUES (420, 'Ösmo', 192, 3911, 58.983330, 17.900000, 31); INSERT INTO "Tätorter" VALUES (422, 'Östhamra', 188, 255, 59.750000, 18.716670, 13); INSERT INTO "Tätorter" VALUES (424, 'Ölsta', 125, 267, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (426, 'Österhagen', 139, 213, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (428, 'Östra Kallfors', 181, 386, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (500, 'Almunge', 380, 813, 59.883330, 18.050000, 6); INSERT INTO "Tätorter" VALUES (504, 'Alsike', 330, 2681, 59.750000, 17.750000, 12); INSERT INTO "Tätorter" VALUES (508, 'Alunda', 382, 2317, 60.266670, 18.400000, 13); INSERT INTO "Tätorter" VALUES (512, 'Björklinge', 380, 3269, 60.250000, 18.466670, 12); INSERT INTO "Tätorter" VALUES (516, 'Vänge', 380, 1331, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (520, 'Bålsta', 305, 14147, 59.567100, 17.527810, 47); INSERT INTO "Tätorter" VALUES (524, 'Bälinge', 380, 2437, 59.950000, 17.533330, 27); INSERT INTO "Tätorter" VALUES (526, 'Bärby', 380, 220, 60.166670, 17.266670, 28); INSERT INTO "Tätorter" VALUES (528, 'Dannemora', 382, 213, 60.183330, 17.816670, 1); INSERT INTO "Tätorter" VALUES (532, 'Enköping', 381, 21121, 59.636070, 17.077680, 15); INSERT INTO "Tätorter" VALUES (536, 'Fjärdhundra', 381, 951, 59.783330, 16.933330, 37); INSERT INTO "Tätorter" VALUES (540, 'Gimo', 382, 2688, 60.173040, 18.185070, 9); INSERT INTO "Tätorter" VALUES (544, 'Grillby', 381, 972, 59.616670, 17.250000, 8); INSERT INTO "Tätorter" VALUES (548, 'Gunsta', 380, 380, 59.850000, 17.833330, 12); INSERT INTO "Tätorter" VALUES (552, 'Gårdskär', 319, 352, 60.616670, 17.583330, 11); INSERT INTO "Tätorter" VALUES (556, 'Gåvsta', 380, 549, 59.950000, 17.866670, 11); INSERT INTO "Tätorter" VALUES (558, 'Haga', 381, 257, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (560, 'Hargshamn', 382, 312, 60.166670, 18.466670, 1); INSERT INTO "Tätorter" VALUES (564, 'Hummelsta', 381, 1002, 59.616670, 16.950000, 7); INSERT INTO "Tätorter" VALUES (566, 'Håga', 380, 302, 59.850000, 17.583330, 16); INSERT INTO "Tätorter" VALUES (568, 'Järlåsa', 380, 493, 59.883330, 17.200000, 76); INSERT INTO "Tätorter" VALUES (570, 'Häggeby och Vreta', 305, 224, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (572, 'Karlholmsbruk', 360, 1150, 60.516670, 17.616670, 8); INSERT INTO "Tätorter" VALUES (576, 'Knivsta', 330, 7081, 59.725640, 17.787530, 28); INSERT INTO "Tätorter" VALUES (580, 'Knutby', 380, 564, 59.916670, 18.250000, 20); INSERT INTO "Tätorter" VALUES (584, 'Krägga', 305, 331, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (588, 'Lillkyrka', 381, 301, 59.560000, 17.250000, 19); INSERT INTO "Tätorter" VALUES (590, 'Läby', 380, 220, 60.083330, 17.550000, 33); INSERT INTO "Tätorter" VALUES (592, 'Länna', 380, 685, 59.866670, 17.966670, 15); INSERT INTO "Tätorter" VALUES (596, 'Lövstalöt', 380, 1046, 59.950000, 17.583330, 25); INSERT INTO "Tätorter" VALUES (600, 'Marma', 319, 298, 61.266670, 16.866670, 32); INSERT INTO "Tätorter" VALUES (604, 'Mehedeby', 360, 463, 60.450000, 17.400000, 43); INSERT INTO "Tätorter" VALUES (606, 'Ramstalund', 380, 311, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (608, 'Månkarbo', 360, 666, 60.233330, 17.466670, 32); INSERT INTO "Tätorter" VALUES (610, 'Norrskedika', 382, 214, 60.283330, 18.283330, 6); INSERT INTO "Tätorter" VALUES (612, 'Ryssbo', 381, 465, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (614, 'Skoby', 382, 230, 60.033330, 18.016670, 25); INSERT INTO "Tätorter" VALUES (616, 'Skutskär', 319, 6075, 60.641040, 17.409150, 4); INSERT INTO "Tätorter" VALUES (618, 'Råby', 305, 885, 60.100000, 16.366670, 74); INSERT INTO "Tätorter" VALUES (620, 'Skyttorp', 380, 666, 60.083330, 17.733330, 27); INSERT INTO "Tätorter" VALUES (622, 'Skölsta', 380, 344, 59.883330, 17.733330, 21); INSERT INTO "Tätorter" VALUES (624, 'Skärplinge', 360, 673, 60.466670, 17.766670, 9); INSERT INTO "Tätorter" VALUES (626, 'Slottsskogen', 305, 1492, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (628, 'Storvreta', 380, 6347, 59.966670, 17.700000, 17); INSERT INTO "Tätorter" VALUES (632, 'Sävja', 380, 9684, 59.820830, 17.698990, 24); INSERT INTO "Tätorter" VALUES (636, 'Söderfors', 360, 1572, 64.816670, 18.050000, 273); INSERT INTO "Tätorter" VALUES (638, 'Söderskogen', 305, 378, 60.216670, 17.833330, 23); INSERT INTO "Tätorter" VALUES (640, 'Tierp', 360, 5587, 60.342690, 17.518120, 19); INSERT INTO "Tätorter" VALUES (648, 'Tobo', 360, 607, 60.266670, 17.650000, 26); INSERT INTO "Tätorter" VALUES (650, 'Blackstalund', 380, 210, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (652, 'Upplanda', 360, 364, 60.233330, 17.733330, 24); INSERT INTO "Tätorter" VALUES (656, 'Uppsala', 380, 140454, 59.858500, 17.645430, 10); INSERT INTO "Tätorter" VALUES (660, 'Vattholma', 380, 1427, 60.016670, 17.733330, 17); INSERT INTO "Tätorter" VALUES (662, 'Ytternäs och Vreta', 380, 636, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (664, 'Älvkarleby', 319, 1647, 60.570810, 17.448950, 19); INSERT INTO "Tätorter" VALUES (666, 'Vårdsätra', 380, 237, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (672, 'Örbyhus', 360, 1984, 60.233330, 17.700000, 22); INSERT INTO "Tätorter" VALUES (676, 'Öregrund', 382, 1555, 60.333330, 18.433330, 15); INSERT INTO "Tätorter" VALUES (680, 'Örsundsbro', 381, 1813, 59.733330, 17.300000, 10); INSERT INTO "Tätorter" VALUES (684, 'Österbybruk', 382, 2272, 60.200000, 17.900000, 36); INSERT INTO "Tätorter" VALUES (688, 'Östhammar', 382, 4534, 60.259090, 18.374080, 5); INSERT INTO "Tätorter" VALUES (699, 'Abborrberget', 486, 2141, 60.150000, 14.800000, 300); INSERT INTO "Tätorter" VALUES (700, 'Alberga', 484, 395, 60.100000, 17.583330, 26); INSERT INTO "Tätorter" VALUES (702, 'Arnö', 480, 3871, 60.116670, 18.633330, 13); INSERT INTO "Tätorter" VALUES (704, 'Baggetorp', 428, 502, 59.150000, 14.633330, 119); INSERT INTO "Tätorter" VALUES (708, 'Bergshammar', 480, 790, 58.733330, 16.916670, 56); INSERT INTO "Tätorter" VALUES (712, 'Bettna', 482, 412, 58.900000, 16.633330, 24); INSERT INTO "Tätorter" VALUES (716, 'Bie', 483, 528, 59.083330, 16.200000, 82); INSERT INTO "Tätorter" VALUES (720, 'Björkvik', 483, 492, 65.500000, 15.566670, 412); INSERT INTO "Tätorter" VALUES (724, 'Björnlunda', 461, 827, 59.066670, 17.150000, 8); INSERT INTO "Tätorter" VALUES (728, 'Buskhyttan', 480, 225, 58.666670, 16.950000, 1); INSERT INTO "Tätorter" VALUES (730, 'Bälgviken', 484, 253, 59.250000, 16.450000, 62); INSERT INTO "Tätorter" VALUES (734, 'Djulö kvarn', 483, 209, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (736, 'Enstaberga', 480, 430, 58.750000, 16.850000, 22); INSERT INTO "Tätorter" VALUES (740, 'Eskilstuna', 484, 64679, 59.366610, 16.507700, 22); INSERT INTO "Tätorter" VALUES (744, 'Flen', 482, 6229, 59.058340, 16.587810, 32); INSERT INTO "Tätorter" VALUES (748, 'Forssjö', 483, 537, 58.950000, 16.283330, 13); INSERT INTO "Tätorter" VALUES (752, 'Gnesta', 461, 5562, 59.047510, 17.311910, 19); INSERT INTO "Tätorter" VALUES (756, 'Hållsta', 484, 823, 63.000000, 14.966670, 325); INSERT INTO "Tätorter" VALUES (760, 'Hällberga', 484, 612, 59.316670, 16.600000, 38); INSERT INTO "Tätorter" VALUES (764, 'Hällbybrunn', 484, 3296, 59.383330, 16.433330, 19); INSERT INTO "Tätorter" VALUES (768, 'Hälleforsnäs', 482, 1585, 59.166670, 16.500000, 58); INSERT INTO "Tätorter" VALUES (772, 'Härad', 486, 508, 59.350000, 16.900000, 28); INSERT INTO "Tätorter" VALUES (776, 'Högsjö', 428, 713, 62.533330, 17.083330, 189); INSERT INTO "Tätorter" VALUES (780, 'Jönåker', 480, 617, 58.733330, 16.716670, 28); INSERT INTO "Tätorter" VALUES (784, 'Katrineholm', 483, 21993, 58.995870, 16.207210, 51); INSERT INTO "Tätorter" VALUES (788, 'Kjulaås', 484, 837, 59.383060, 16.666670, 24); INSERT INTO "Tätorter" VALUES (790, 'Stensund och Krymla', 488, 346, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (792, 'Kvicksund', 1980, 1768, 59.450000, 16.316670, 29); INSERT INTO "Tätorter" VALUES (796, 'Malmköping', 482, 1977, 59.133330, 16.733330, 41); INSERT INTO "Tätorter" VALUES (798, 'Marielund', 486, 416, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (800, 'Mariefred', 486, 3726, 59.266670, 17.216670, 9); INSERT INTO "Tätorter" VALUES (802, 'Marmorbyn', 428, 382, 59.033060, 16.050000, 21); INSERT INTO "Tätorter" VALUES (804, 'Mellösa', 482, 535, 59.200000, 15.500000, 18); INSERT INTO "Tätorter" VALUES (806, 'Merlänna', 486, 356, 59.283330, 16.983330, 24); INSERT INTO "Tätorter" VALUES (812, 'Nyköping', 480, 29891, 58.753000, 17.007880, 17); INSERT INTO "Tätorter" VALUES (816, 'Nävekvarn', 480, 795, 58.633060, 16.800000, 29); INSERT INTO "Tätorter" VALUES (820, 'Oxelösund', 481, 10870, 58.670570, 17.101520, 21); INSERT INTO "Tätorter" VALUES (828, 'Runtuna', 480, 250, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (832, 'Sjösa', 480, 483, 58.766670, 17.083330, 6); INSERT INTO "Tätorter" VALUES (840, 'Skogstorp', 484, 2860, 59.333330, 16.466670, 28); INSERT INTO "Tätorter" VALUES (844, 'Sköldinge', 483, 604, 59.033330, 16.433330, 43); INSERT INTO "Tätorter" VALUES (848, 'Sparreholm', 482, 741, 59.066670, 16.816670, 38); INSERT INTO "Tätorter" VALUES (852, 'Stallarholmen', 486, 1623, 59.366670, 17.200000, 19); INSERT INTO "Tätorter" VALUES (854, 'Stavsjö', 480, 212, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (856, 'Stigtomta', 480, 1942, 58.800000, 16.783330, 30); INSERT INTO "Tätorter" VALUES (860, 'Stjärnhov', 461, 549, 59.083330, 17.000000, 21); INSERT INTO "Tätorter" VALUES (864, 'Strångsjö', 483, 365, 58.900000, 16.200000, 59); INSERT INTO "Tätorter" VALUES (868, 'Strängnäs', 486, 12856, 59.377410, 17.031190, 1); INSERT INTO "Tätorter" VALUES (870, 'Sundbyholm', 484, 485, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (876, 'Svalsta', 480, 1078, 58.733330, 16.866670, 34); INSERT INTO "Tätorter" VALUES (880, 'Torshälla', 484, 7612, 59.416670, 16.466670, 17); INSERT INTO "Tätorter" VALUES (882, 'Torshälla huvud', 484, 492, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (884, 'Trosa', 488, 5027, 58.896210, 17.548120, 4); INSERT INTO "Tätorter" VALUES (886, 'Tumbo', 484, 292, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (888, 'Tystberga', 480, 828, 58.850000, 17.233060, 16); INSERT INTO "Tätorter" VALUES (896, 'Vagnhärad', 488, 3324, 58.950000, 17.516670, 42); INSERT INTO "Tätorter" VALUES (898, 'Sund', 488, 329, 58.954200, 17.420900, NULL); INSERT INTO "Tätorter" VALUES (900, 'Valla', 483, 1517, 63.550000, 13.800000, 350); INSERT INTO "Tätorter" VALUES (902, 'Vansö', 486, 202, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (904, 'Vingåker', 428, 4282, 59.043300, 15.873740, 33); INSERT INTO "Tätorter" VALUES (908, 'Vrena', 480, 626, 58.866670, 16.683330, 23); INSERT INTO "Tätorter" VALUES (910, 'Västerljung', 488, 398, 58.916670, 17.433330, 20); INSERT INTO "Tätorter" VALUES (912, 'Åkers styckebruk', 486, 2891, 59.250000, 17.083330, 27); INSERT INTO "Tätorter" VALUES (916, 'Ålberga', 480, 247, 58.733330, 16.566670, 67); INSERT INTO "Tätorter" VALUES (918, 'Ängsholmen', 484, 222, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (920, 'Ärla', 484, 1270, 59.283330, 16.666670, 45); INSERT INTO "Tätorter" VALUES (924, 'Äsköping', 483, 342, 59.150000, 16.066670, 26); INSERT INTO "Tätorter" VALUES (996, 'Almborga', 581, 261, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (1004, 'Askeby', 580, 518, 58.416670, 15.833330, 61); INSERT INTO "Tätorter" VALUES (1008, 'Bankekind', 580, 405, 58.383330, 15.816670, 66); INSERT INTO "Tätorter" VALUES (1012, 'Berg', 561, 311, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (1016, 'Berg', 580, 1278, 58.488310, 15.529690, 47); INSERT INTO "Tätorter" VALUES (1020, 'Bestorp', 580, 475, 58.233330, 15.733330, 102); INSERT INTO "Tätorter" VALUES (1024, 'Björsäter', 561, 443, 58.650000, 13.700000, 46); INSERT INTO "Tätorter" VALUES (1028, 'Borensberg', 583, 2886, 58.566670, 15.283330, 118); INSERT INTO "Tätorter" VALUES (1032, 'Borggård', 562, 238, 58.733330, 15.533330, 61); INSERT INTO "Tätorter" VALUES (1040, 'Boxholm', 560, 3194, 58.197190, 15.053760, 142); INSERT INTO "Tätorter" VALUES (1044, 'Brokind', 580, 502, 58.216670, 15.666670, 82); INSERT INTO "Tätorter" VALUES (1046, 'Eksund', 581, 206, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (1048, 'Falerum', 561, 242, 58.150000, 16.216670, 89); INSERT INTO "Tätorter" VALUES (1050, 'Ekängen', 580, 2037, 58.466670, 15.633330, 45); INSERT INTO "Tätorter" VALUES (1052, 'Falla', 562, 467, 59.383330, 15.050000, 49); INSERT INTO "Tätorter" VALUES (1054, 'Ensjön', 581, 333, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (1056, 'Finspång', 562, 12440, 58.705780, 15.767390, 20); INSERT INTO "Tätorter" VALUES (1060, 'Fornåsa', 583, 433, 58.483330, 15.233330, 77); INSERT INTO "Tätorter" VALUES (1064, 'Fågelsta', 583, 287, 60.166670, 17.266670, 28); INSERT INTO "Tätorter" VALUES (1068, 'Gistad', 580, 288, 58.466670, 15.883330, 49); INSERT INTO "Tätorter" VALUES (1070, 'Godegård', 583, 200, 58.733330, 15.150000, 110); INSERT INTO "Tätorter" VALUES (1072, 'Grebo', 561, 970, 58.300000, 15.850000, 80); INSERT INTO "Tätorter" VALUES (1074, 'Graversfors', 581, 246, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (1080, 'Grytgöl', 562, 263, 58.800000, 15.550000, 58); INSERT INTO "Tätorter" VALUES (1084, 'Gusum', 563, 1175, 58.266670, 16.483330, 58); INSERT INTO "Tätorter" VALUES (1088, 'Herstadberg', 581, 236, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (1092, 'Hestra', 512, 476, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (1096, 'Hogstad', 586, 241, 58.333330, 15.016670, 111); INSERT INTO "Tätorter" VALUES (1100, 'Horn', 513, 495, 59.500000, 16.283330, 18); INSERT INTO "Tätorter" VALUES (1104, 'Hällestad', 562, 336, 58.733330, 15.566670, 54); INSERT INTO "Tätorter" VALUES (1108, 'Hästholmen', 509, 342, 65.750000, 23.016670, NULL); INSERT INTO "Tätorter" VALUES (1116, 'Igelfors', 562, 214, 58.850000, 15.683330, 60); INSERT INTO "Tätorter" VALUES (1120, 'Jursla', 581, 1692, 58.666670, 16.183330, 59); INSERT INTO "Tätorter" VALUES (1128, 'Kimstad', 581, 1510, 58.533330, 15.966670, 55); INSERT INTO "Tätorter" VALUES (1132, 'Kisa', 513, 3687, 57.987810, 15.633030, 111); INSERT INTO "Tätorter" VALUES (1136, 'Klockrike', 583, 272, 58.500000, 15.333330, 81); INSERT INTO "Tätorter" VALUES (1140, 'Krokek', 581, 4285, 58.666670, 16.400000, 45); INSERT INTO "Tätorter" VALUES (1144, 'Lindö', 581, 4915, 58.616670, 16.250000, NULL); INSERT INTO "Tätorter" VALUES (1148, 'Linghem', 580, 2804, 58.433330, 15.783330, 51); INSERT INTO "Tätorter" VALUES (1152, 'Linköping', 580, 104232, 58.416670, 15.616670, 33); INSERT INTO "Tätorter" VALUES (1156, 'Ljunga', 581, 688, 58.516670, 16.350000, 36); INSERT INTO "Tätorter" VALUES (1160, 'Ljungsbro', 580, 6620, 58.516670, 15.500000, 77); INSERT INTO "Tätorter" VALUES (1164, 'Ljusfallshammar', 562, 327, 58.783330, 15.483330, 72); INSERT INTO "Tätorter" VALUES (1168, 'Lotorp', 562, 701, 58.733330, 15.833330, 59); INSERT INTO "Tätorter" VALUES (1170, 'Snöveltorp', 582, 333, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (1172, 'Malmslätt', 580, 5214, 58.411020, 15.516470, 88); INSERT INTO "Tätorter" VALUES (1176, 'Mantorp', 586, 3671, 58.350000, 15.283330, 104); INSERT INTO "Tätorter" VALUES (1180, 'Mjölby', 586, 12245, 58.325950, 15.123650, 110); INSERT INTO "Tätorter" VALUES (1184, 'Mogata', 582, 301, 58.450000, 16.450000, 43); INSERT INTO "Tätorter" VALUES (1188, 'Motala', 583, 29823, 58.537060, 15.036490, 94); INSERT INTO "Tätorter" VALUES (1192, 'Norrköping', 581, 87247, 58.594190, 16.182600, 2); INSERT INTO "Tätorter" VALUES (1196, 'Norsholm', 581, 615, 58.516670, 15.966670, 62); INSERT INTO "Tätorter" VALUES (1200, 'Nykil', 580, 321, 58.283330, 15.450000, 117); INSERT INTO "Tätorter" VALUES (1204, 'Nykyrka', 583, 414, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (1206, 'Butbro', 562, 261, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (1212, 'Rappestad', 580, 235, 58.400000, 15.416670, 80); INSERT INTO "Tätorter" VALUES (1216, 'Rejmyre', 562, 900, 58.833330, 15.916670, 50); INSERT INTO "Tätorter" VALUES (1220, 'Rimforsa', 513, 2238, 58.136240, 15.686500, 82); INSERT INTO "Tätorter" VALUES (1224, 'Ringarum', 563, 577, 58.333330, 16.450000, 29); INSERT INTO "Tätorter" VALUES (1228, 'Rydsnäs', 512, 277, 57.800000, 15.166670, 218); INSERT INTO "Tätorter" VALUES (1232, 'Simonstorp', 581, 258, 58.782550, 16.156940, 69); INSERT INTO "Tätorter" VALUES (1236, 'Sjögestad', 580, 300, 58.366670, 15.366670, 83); INSERT INTO "Tätorter" VALUES (1238, 'Skeda udde', 580, 283, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (1242, 'Skriketorp', 581, 246, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (1244, 'Skänninge', 586, 3140, 59.933330, 18.483330, 24); INSERT INTO "Tätorter" VALUES (1248, 'Skärblacka', 581, 4059, 58.566670, 15.900000, 29); INSERT INTO "Tätorter" VALUES (1252, 'Slaka', 580, 592, 58.366670, 15.550000, 114); INSERT INTO "Tätorter" VALUES (1256, 'Sonstorp', 562, 429, 58.716670, 15.633330, 60); INSERT INTO "Tätorter" VALUES (1260, 'Spångsholm', 586, 408, 58.350000, 15.233330, 100); INSERT INTO "Tätorter" VALUES (1264, 'Strålsnäs', 560, 410, 58.233330, 15.100000, 152); INSERT INTO "Tätorter" VALUES (1268, 'Strömsfors', 581, 528, 58.680000, 16.330000, 82); INSERT INTO "Tätorter" VALUES (1272, 'Sturefors', 580, 2229, 58.333330, 15.733330, 67); INSERT INTO "Tätorter" VALUES (1276, 'Svärtinge', 581, 2963, 58.650000, 16.000000, 20); INSERT INTO "Tätorter" VALUES (1280, 'Sya', 586, 306, 58.333330, 15.216670, 105); INSERT INTO "Tätorter" VALUES (1284, 'Söderköping', 582, 6992, 58.480570, 16.322210, 7); INSERT INTO "Tätorter" VALUES (1292, 'Tjällmo', 583, 557, 58.716670, 15.350000, 56); INSERT INTO "Tätorter" VALUES (1296, 'Ulrika', 580, 200, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (1300, 'Vadstena', 584, 5613, 58.448630, 14.889690, 92); INSERT INTO "Tätorter" VALUES (1304, 'Valdemarsvik', 563, 2772, 58.203100, 16.602250, 52); INSERT INTO "Tätorter" VALUES (1308, 'Vikingstad', 580, 2096, 58.383040, 15.432010, 79); INSERT INTO "Tätorter" VALUES (1310, 'Vånga', 581, 220, 59.783330, 16.916670, 41); INSERT INTO "Tätorter" VALUES (1316, 'Väderstad', 586, 583, 58.316670, 14.916670, 95); INSERT INTO "Tätorter" VALUES (1318, 'Västerlösa', 580, 206, 58.800000, 15.533330, 70); INSERT INTO "Tätorter" VALUES (1320, 'Västra Husby', 582, 486, 58.483730, 16.175480, 33); INSERT INTO "Tätorter" VALUES (1324, 'Åby', 581, 4980, 58.666670, 16.183330, 59); INSERT INTO "Tätorter" VALUES (1326, 'Åselstad', 581, 475, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (1328, 'Åtvidaberg', 561, 6859, 58.201520, 15.997700, 95); INSERT INTO "Tätorter" VALUES (1330, 'Öbonäs', 581, 457, 58.533330, 16.183330, 49); INSERT INTO "Tätorter" VALUES (1332, 'Ödeshög', 509, 2572, 58.229490, 14.652940, 134); INSERT INTO "Tätorter" VALUES (1336, 'Österbymo', 512, 834, 57.824650, 15.273570, 194); INSERT INTO "Tätorter" VALUES (1340, 'Österstad', 583, 318, 58.516670, 15.166670, 75); INSERT INTO "Tätorter" VALUES (1344, 'Östra Husby', 581, 792, 58.583060, 16.550000, 21); INSERT INTO "Tätorter" VALUES (1348, 'Östra Ryd', 582, 457, 58.400000, 16.150000, 73); INSERT INTO "Tätorter" VALUES (1400, 'Anderstorp', 662, 4965, 58.883330, 14.283330, 126); INSERT INTO "Tätorter" VALUES (1404, 'Aneby', 604, 3367, 57.838950, 14.810160, 242); INSERT INTO "Tätorter" VALUES (1408, 'Anneberg', 682, 833, 60.241670, 18.416670, NULL); INSERT INTO "Tätorter" VALUES (1412, 'Bankeryd', 680, 8107, 57.850000, 14.116670, 216); INSERT INTO "Tätorter" VALUES (1420, 'Björköby', 685, 273, 57.519880, 14.905270, 205); INSERT INTO "Tätorter" VALUES (1424, 'Bodafors', 682, 1886, 57.500000, 14.700000, 280); INSERT INTO "Tätorter" VALUES (1428, 'Bor', 683, 1256, 57.116670, 14.166670, 197); INSERT INTO "Tätorter" VALUES (1432, 'Bottnaryd', 680, 713, 57.766670, 13.816670, 240); INSERT INTO "Tätorter" VALUES (1436, 'Bredaryd', 683, 1466, 57.166670, 13.733330, 179); INSERT INTO "Tätorter" VALUES (1440, 'Broaryd', 662, 271, 57.116670, 13.250000, 155); INSERT INTO "Tätorter" VALUES (1444, 'Bruzaholm', 686, 250, 57.633330, 15.266670, 249); INSERT INTO "Tätorter" VALUES (1448, 'Ölmstad', 680, 296, 57.933330, 14.366670, 216); INSERT INTO "Tätorter" VALUES (1452, 'Burseryd', 662, 854, 57.366670, 14.783330, 235); INSERT INTO "Tätorter" VALUES (1456, 'Ekenässjön', 685, 1517, 57.500000, 15.000000, 218); INSERT INTO "Tätorter" VALUES (1460, 'Eksjö', 686, 9701, 57.666430, 14.972050, 223); INSERT INTO "Tätorter" VALUES (1464, 'Flisby', 682, 201, 57.783330, 14.800000, 227); INSERT INTO "Tätorter" VALUES (1468, 'Forserum', 682, 2039, 57.950000, 16.466670, 11); INSERT INTO "Tätorter" VALUES (1472, 'Forsheda', 683, 1459, 57.150000, 13.816670, 181); INSERT INTO "Tätorter" VALUES (1476, 'Fredriksdal', 682, 310, 56.200000, 15.516670, 13); INSERT INTO "Tätorter" VALUES (1480, 'Frinnaryd', 604, 204, 57.933330, 14.816670, 224); INSERT INTO "Tätorter" VALUES (1484, 'Gislaved', 662, 10037, 57.304400, 13.540780, 169); INSERT INTO "Tätorter" VALUES (1488, 'Gnosjö', 617, 4326, 57.358500, 13.736860, 197); INSERT INTO "Tätorter" VALUES (1492, 'Grimstorp', 682, 344, 58.833330, 14.216670, 102); INSERT INTO "Tätorter" VALUES (1496, 'Gripenberg', 687, 292, 58.000000, 14.850000, 198); INSERT INTO "Tätorter" VALUES (1500, 'Gränna', 680, 2553, 58.016670, 14.466670, 248); INSERT INTO "Tätorter" VALUES (1504, 'Hestra', 662, 1306, 57.443228, 13.595494, NULL); INSERT INTO "Tätorter" VALUES (1508, 'Hillerstorp', 617, 1766, 57.316670, 13.866670, 173); INSERT INTO "Tätorter" VALUES (1512, 'Hjältevad', 686, 335, 57.633330, 15.333330, 175); INSERT INTO "Tätorter" VALUES (1516, 'Hok', 665, 637, 57.516670, 14.266670, 215); INSERT INTO "Tätorter" VALUES (1520, 'Holsbybrunn', 685, 729, 57.433330, 15.200000, 189); INSERT INTO "Tätorter" VALUES (1524, 'Horda', 683, 377, 57.033330, 14.250000, 205); INSERT INTO "Tätorter" VALUES (1528, 'Hult', 686, 455, 59.883060, 12.916670, 175); INSERT INTO "Tätorter" VALUES (1532, 'Hånger', 683, 301, 58.266670, 13.516670, 128); INSERT INTO "Tätorter" VALUES (1540, 'Ingatorp', 686, 453, 57.637680, 15.410210, 185); INSERT INTO "Tätorter" VALUES (1544, 'Jönköping', 680, 89396, 57.781450, 14.156180, 114); INSERT INTO "Tätorter" VALUES (1548, 'Kaxholmen', 680, 1458, 57.866670, 14.300000, 154); INSERT INTO "Tätorter" VALUES (1552, 'Klevshult', 665, 264, 57.350000, 14.083330, 186); INSERT INTO "Tätorter" VALUES (1556, 'Kulltorp', 617, 334, 57.766670, 16.166670, 120); INSERT INTO "Tätorter" VALUES (1560, 'Kvillsfors', 685, 500, 57.416670, 15.483330, 143); INSERT INTO "Tätorter" VALUES (1564, 'Kärda', 683, 320, 57.166670, 13.916670, 179); INSERT INTO "Tätorter" VALUES (1568, 'Landsbro', 685, 1426, 57.366670, 14.900000, 209); INSERT INTO "Tätorter" VALUES (1572, 'Lanna', 683, 329, 59.233330, 14.916670, 32); INSERT INTO "Tätorter" VALUES (1576, 'Lekeryd', 680, 817, 57.766670, 14.400000, 234); INSERT INTO "Tätorter" VALUES (1584, 'Malmbäck', 682, 1031, 57.583330, 14.466670, 300); INSERT INTO "Tätorter" VALUES (1588, 'Mariannelund', 686, 1468, 57.616670, 15.566670, 153); INSERT INTO "Tätorter" VALUES (1600, 'Myresjö', 685, 646, 57.383330, 14.950000, 221); INSERT INTO "Tätorter" VALUES (1604, 'Nissafors', 617, 285, 57.400000, 13.633330, 191); INSERT INTO "Tätorter" VALUES (1608, 'Nässjö', 682, 16678, 57.653070, 14.696760, 307); INSERT INTO "Tätorter" VALUES (1612, 'Odensjö', 680, 2495, 57.716670, 14.166670, 237); INSERT INTO "Tätorter" VALUES (1620, 'Pauliström', 685, 221, 57.466670, 15.516670, 206); INSERT INTO "Tätorter" VALUES (1624, 'Reftele', 662, 1282, 57.183330, 13.583330, 159); INSERT INTO "Tätorter" VALUES (1632, 'Rydaholm', 683, 1474, 56.983330, 14.300000, 191); INSERT INTO "Tätorter" VALUES (1636, 'Rörvik', 684, 523, 59.900000, 18.900000, NULL); INSERT INTO "Tätorter" VALUES (1644, 'Sjunnen', 685, 422, 57.433330, 15.166670, 184); INSERT INTO "Tätorter" VALUES (1648, 'Skede', 685, 304, 63.250000, 19.000000, 2); INSERT INTO "Tätorter" VALUES (1652, 'Skeppshult', 662, 365, 58.683330, 14.500000, 157); INSERT INTO "Tätorter" VALUES (1656, 'Skillingaryd', 665, 3889, 57.433330, 14.083330, 182); INSERT INTO "Tätorter" VALUES (1660, 'Skärstad', 680, 341, 57.883330, 14.366670, 295); INSERT INTO "Tätorter" VALUES (1664, 'Smålandsstenar', 662, 4530, 57.166670, 13.400000, 167); INSERT INTO "Tätorter" VALUES (1668, 'Solberga', 682, 374, 60.983330, 15.216670, 227); INSERT INTO "Tätorter" VALUES (1672, 'Sommen', 687, 772, 58.133330, 14.966670, 151); INSERT INTO "Tätorter" VALUES (1676, 'Stensjön', 682, 224, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (1680, 'Stockaryd', 684, 958, 57.316670, 14.583330, 223); INSERT INTO "Tätorter" VALUES (1684, 'Sundhultsbrunn', 604, 311, 57.916670, 14.900000, 255); INSERT INTO "Tätorter" VALUES (1688, 'Sävsjö', 684, 5122, 57.403270, 14.662440, 237); INSERT INTO "Tätorter" VALUES (1692, 'Taberg', 680, 4392, 57.683330, 14.083330, 235); INSERT INTO "Tätorter" VALUES (1696, 'Tenhult', 680, 2977, 57.716670, 14.316670, 296); INSERT INTO "Tätorter" VALUES (1700, 'Tranås', 687, 14197, 58.037170, 14.978200, 154); INSERT INTO "Tätorter" VALUES (1708, 'Tunnerstad', 680, 295, 58.050000, 14.316670, 105); INSERT INTO "Tätorter" VALUES (1714, 'Törestorp', 617, 203, 58.316670, 13.066670, 71); INSERT INTO "Tätorter" VALUES (1720, 'Vaggeryd', 665, 4920, 57.498070, 14.148420, 199); INSERT INTO "Tätorter" VALUES (1724, 'Vetlanda', 685, 13050, 57.428870, 15.077620, 186); INSERT INTO "Tätorter" VALUES (1728, 'Vrigstad', 684, 1421, 57.350000, 14.466670, 205); INSERT INTO "Tätorter" VALUES (1732, 'Värnamo', 683, 18696, 57.186040, 14.040010, 162); INSERT INTO "Tätorter" VALUES (1738, 'Åsenhöga', 617, 210, 57.400000, 13.800000, 248); INSERT INTO "Tätorter" VALUES (1740, 'Äng', 682, 277, 59.033330, 11.966670, 150); INSERT INTO "Tätorter" VALUES (1742, 'Öggestorp', 680, 212, 57.733330, 14.383330, 241); INSERT INTO "Tätorter" VALUES (1748, 'Örserum', 680, 322, 58.000000, 14.566670, 201); INSERT INTO "Tätorter" VALUES (1752, 'Korsberga', 685, 694, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (1802, 'Agunnaryd', 781, 220, 56.750000, 14.150000, 123); INSERT INTO "Tätorter" VALUES (1804, 'Alstermo', 760, 829, 56.966670, 15.633330, 182); INSERT INTO "Tätorter" VALUES (1808, 'Alvesta', 764, 8017, 56.899350, 14.555590, 122); INSERT INTO "Tätorter" VALUES (1812, 'Angelstad', 781, 271, 56.833330, 13.750000, 142); INSERT INTO "Tätorter" VALUES (1818, 'Björnö', 780, 215, 58.633330, 15.000000, 120); INSERT INTO "Tätorter" VALUES (1820, 'Braås', 780, 1547, 57.066670, 15.050000, 216); INSERT INTO "Tätorter" VALUES (1828, 'Delary', 765, 222, 56.550000, 13.950000, 123); INSERT INTO "Tätorter" VALUES (1832, 'Diö', 765, 910, 56.633330, 14.216670, 138); INSERT INTO "Tätorter" VALUES (1840, 'Eneryda', 765, 338, 56.700000, 14.333330, 140); INSERT INTO "Tätorter" VALUES (1844, 'Fridafors', 763, 221, 56.416670, 14.650000, 127); INSERT INTO "Tätorter" VALUES (1852, 'Furuby', 780, 372, 56.850000, 15.033330, 189); INSERT INTO "Tätorter" VALUES (1856, 'Gemla', 780, 1342, 56.866670, 14.633330, 165); INSERT INTO "Tätorter" VALUES (1860, 'Grimslöv', 764, 593, 56.733330, 14.533330, 153); INSERT INTO "Tätorter" VALUES (1872, 'Hjortsberga', 764, 245, 59.100000, 15.183330, 54); INSERT INTO "Tätorter" VALUES (1876, 'Hovmantorp', 761, 2991, 56.783330, 15.133330, 148); INSERT INTO "Tätorter" VALUES (1884, 'Ingelstad', 780, 1674, 57.000000, 16.850000, 18); INSERT INTO "Tätorter" VALUES (1892, 'Konga', 763, 476, 56.500000, 15.116670, 126); INSERT INTO "Tätorter" VALUES (1896, 'Kosta', 761, 884, 56.850000, 15.383330, 235); INSERT INTO "Tätorter" VALUES (1900, 'Kånna', 781, 352, 56.783330, 13.900000, 151); INSERT INTO "Tätorter" VALUES (1904, 'Lagan', 781, 1744, 56.916670, 13.983330, 158); INSERT INTO "Tätorter" VALUES (1908, 'Lammhult', 780, 1459, 57.166670, 14.583330, 245); INSERT INTO "Tätorter" VALUES (1912, 'Lenhovda', 760, 1744, 57.000000, 15.283330, 268); INSERT INTO "Tätorter" VALUES (1916, 'Lessebo', 761, 2737, 56.751850, 15.269690, 170); INSERT INTO "Tätorter" VALUES (1920, 'Liatorp', 765, 555, 56.666670, 14.266670, 154); INSERT INTO "Tätorter" VALUES (1924, 'Lidhult', 781, 611, 57.950000, 15.400000, 207); INSERT INTO "Tätorter" VALUES (1932, 'Linneryd', 763, 488, 57.400000, 14.150000, 164); INSERT INTO "Tätorter" VALUES (1936, 'Ljungby', 781, 15205, 56.833240, 13.940820, 139); INSERT INTO "Tätorter" VALUES (1940, 'Markaryd', 767, 3966, 56.461350, 13.596440, 107); INSERT INTO "Tätorter" VALUES (1944, 'Moheda', 764, 1824, 57.000000, 14.566670, 162); INSERT INTO "Tätorter" VALUES (1948, 'Norrhult-Klavreström', 760, 1215, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (1952, 'Nöbbele', 780, 257, 57.433330, 14.833330, 239); INSERT INTO "Tätorter" VALUES (1956, 'Rottne', 780, 2354, 57.016670, 14.900000, 205); INSERT INTO "Tätorter" VALUES (1960, 'Ryd', 763, 1415, 58.666670, 15.083330, 116); INSERT INTO "Tätorter" VALUES (1964, 'Ryssby', 781, 707, 57.716670, 14.650000, 301); INSERT INTO "Tätorter" VALUES (1968, 'Rävemåla', 763, 294, 56.933330, 16.366670, 15); INSERT INTO "Tätorter" VALUES (1976, 'Skruv', 761, 490, 57.150000, 15.166670, 270); INSERT INTO "Tätorter" VALUES (1980, 'Strömsnäsbruk', 767, 2066, 56.550000, 13.716670, 117); INSERT INTO "Tätorter" VALUES (1988, 'Timsfors', 767, 637, 56.483330, 13.583330, 102); INSERT INTO "Tätorter" VALUES (1992, 'Tingsryd', 763, 3037, 56.524700, 14.979020, 127); INSERT INTO "Tätorter" VALUES (1996, 'Torpsbruk', 764, 334, 57.033330, 14.583330, 201); INSERT INTO "Tätorter" VALUES (2000, 'Traryd', 767, 660, 56.583330, 13.783330, 161); INSERT INTO "Tätorter" VALUES (2002, 'Tävelsås', 780, 225, 56.766670, 14.816670, 155); INSERT INTO "Tätorter" VALUES (2004, 'Urshult', 763, 794, 56.533330, 14.783330, 141); INSERT INTO "Tätorter" VALUES (2012, 'Vislanda', 764, 1769, 56.783330, 14.450000, 147); INSERT INTO "Tätorter" VALUES (2016, 'Vittaryd', 781, 318, 57.866670, 14.783330, 231); INSERT INTO "Tätorter" VALUES (2020, 'Väckelsång', 763, 905, 56.633330, 14.916670, 131); INSERT INTO "Tätorter" VALUES (2024, 'Växjö', 780, 60887, 56.877670, 14.809060, 185); INSERT INTO "Tätorter" VALUES (2028, 'Åby', 780, 456, 60.650000, 17.033330, 17); INSERT INTO "Tätorter" VALUES (2032, 'Åryd', 780, 684, 57.950000, 13.650000, 267); INSERT INTO "Tätorter" VALUES (2036, 'Åseda', 760, 2430, 57.170100, 15.344300, 243); INSERT INTO "Tätorter" VALUES (2040, 'Älghult', 760, 446, 57.366670, 13.650000, 208); INSERT INTO "Tätorter" VALUES (2048, 'Älmhult', 765, 8955, 56.551460, 14.138270, 135); INSERT INTO "Tätorter" VALUES (2092, 'Algutsrum', 840, 532, 56.683330, 16.516670, 56); INSERT INTO "Tätorter" VALUES (2100, 'Alsterbro', 881, 422, 56.950000, 15.916670, 114); INSERT INTO "Tätorter" VALUES (2104, 'Ankarsrum', 883, 1254, 57.700000, 16.316670, 79); INSERT INTO "Tätorter" VALUES (2106, 'Arontorp', 840, 233, 56.650000, 16.533330, 44); INSERT INTO "Tätorter" VALUES (2108, 'Berga', 821, 724, 61.583330, 17.083330, NULL); INSERT INTO "Tätorter" VALUES (2112, 'Bergkvara', 834, 940, 56.390630, 16.072740, 4); INSERT INTO "Tätorter" VALUES (2114, 'Björkviken', 885, 208, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (2120, 'Blomstermåla', 861, 1527, 56.983330, 16.333330, 32); INSERT INTO "Tätorter" VALUES (2124, 'Bockara', 882, 316, 57.266670, 16.066670, 110); INSERT INTO "Tätorter" VALUES (2130, 'Boholmarna', 880, 297, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (2132, 'Borgholm', 885, 3071, 56.879300, 16.656340, 21); INSERT INTO "Tätorter" VALUES (2144, 'Bäckebo', 881, 219, 61.883330, 15.983330, 125); INSERT INTO "Tätorter" VALUES (2152, 'Degerhamn', 840, 331, 56.350000, 16.400000, NULL); INSERT INTO "Tätorter" VALUES (2154, 'Dunö', 880, 384, 56.633330, 16.266670, NULL); INSERT INTO "Tätorter" VALUES (2156, 'Edsbruk', 883, 300, 58.033330, 16.466670, 47); INSERT INTO "Tätorter" VALUES (2160, 'Emmaboda', 862, 4824, 56.632680, 15.536480, 112); INSERT INTO "Tätorter" VALUES (2164, 'Emsfors', 882, 332, 57.150000, 16.450000, 18); INSERT INTO "Tätorter" VALUES (2168, 'Eriksmåla', 862, 231, 56.733330, 15.466670, 168); INSERT INTO "Tätorter" VALUES (2172, 'Fagerhult', 821, 229, 58.816670, 11.600000, 121); INSERT INTO "Tätorter" VALUES (2176, 'Figeholm', 882, 743, 57.366670, 16.550000, 1); INSERT INTO "Tätorter" VALUES (2188, 'Fliseryd', 861, 677, 57.133330, 16.266670, 43); INSERT INTO "Tätorter" VALUES (2192, 'Flygsfors', 881, 226, 56.833330, 15.766670, 158); INSERT INTO "Tätorter" VALUES (2196, 'Frödinge', 884, 383, 57.700000, 16.000000, 124); INSERT INTO "Tätorter" VALUES (2200, 'Fågelfors', 821, 424, 57.200000, 15.833330, 132); INSERT INTO "Tätorter" VALUES (2204, 'Fårbo', 882, 517, 57.383330, 16.483330, 39); INSERT INTO "Tätorter" VALUES (2208, 'Färjestaden', 840, 5018, 56.650000, 16.450000, NULL); INSERT INTO "Tätorter" VALUES (2212, 'Gamleby', 883, 2775, 57.900000, 16.400000, 7); INSERT INTO "Tätorter" VALUES (2232, 'Gullringen', 884, 541, 57.800000, 15.700000, 141); INSERT INTO "Tätorter" VALUES (2236, 'Gunnebo', 883, 938, 57.716670, 16.533330, 30); INSERT INTO "Tätorter" VALUES (2240, 'Gårdby', 840, 257, 56.600000, 16.633330, 27); INSERT INTO "Tätorter" VALUES (2244, 'Hagby', 880, 689, 59.800000, 17.366670, 22); INSERT INTO "Tätorter" VALUES (2248, 'Halltorp', 880, 266, 57.933330, 11.833330, 35); INSERT INTO "Tätorter" VALUES (2256, 'Hjorted', 883, 324, 57.633330, 16.300000, 74); INSERT INTO "Tätorter" VALUES (2260, 'Hultsfred', 860, 5143, 57.488150, 15.843570, 96); INSERT INTO "Tätorter" VALUES (2264, 'Högsby', 821, 1881, 57.165970, 16.025620, 79); INSERT INTO "Tätorter" VALUES (2266, 'Rälla', 885, 407, 56.783330, 16.566670, 59); INSERT INTO "Tätorter" VALUES (2272, 'Johansfors', 862, 409, 56.833330, 12.983330, 90); INSERT INTO "Tätorter" VALUES (2276, 'Järnforsen', 860, 489, 57.416670, 15.616670, 120); INSERT INTO "Tätorter" VALUES (2280, 'Kalmar', 880, 36392, 56.661570, 16.361630, 6); INSERT INTO "Tätorter" VALUES (2284, 'Kastlösa', 840, 201, 56.466670, 16.433330, 38); INSERT INTO "Tätorter" VALUES (2288, 'Kristdala', 882, 945, 57.400000, 16.183330, 87); INSERT INTO "Tätorter" VALUES (2292, 'Kristvallabrunn', 881, 246, 56.766670, 16.050000, 60); INSERT INTO "Tätorter" VALUES (2296, 'Köpingsvik', 885, 599, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (2300, 'Lindsdal', 880, 5510, 56.733330, 16.300000, 5); INSERT INTO "Tätorter" VALUES (2304, 'Ljungbyholm', 880, 1604, 56.633330, 16.166670, 10); INSERT INTO "Tätorter" VALUES (2308, 'Loftahammar', 883, 404, 57.899720, 16.700000, NULL); INSERT INTO "Tätorter" VALUES (2312, 'Långasjö', 862, 348, 56.583330, 15.433330, 120); INSERT INTO "Tätorter" VALUES (2316, 'Läckeby', 880, 847, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (2324, 'Löttorp', 885, 438, 57.166670, 16.983330, 10); INSERT INTO "Tätorter" VALUES (2328, 'Misterhult', 882, 203, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (2330, 'Mysingsö', 882, 385, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (2332, 'Målerås', 881, 211, 56.916670, 15.566670, 225); INSERT INTO "Tätorter" VALUES (2336, 'Målilla', 860, 1524, 57.387730, 15.806750, 106); INSERT INTO "Tätorter" VALUES (2340, 'Mönsterås', 861, 4731, 57.041340, 16.444630, 9); INSERT INTO "Tätorter" VALUES (2344, 'Mörbylånga', 840, 1780, 56.524800, 16.378770, NULL); INSERT INTO "Tätorter" VALUES (2348, 'Mörlunda', 860, 838, 57.316670, 15.850000, 109); INSERT INTO "Tätorter" VALUES (2352, 'Nybro', 881, 12810, 56.744610, 15.907140, 88); INSERT INTO "Tätorter" VALUES (2356, 'Orrefors', 881, 719, 56.833330, 15.750000, 163); INSERT INTO "Tätorter" VALUES (2360, 'Oskarshamn', 882, 17258, 57.264550, 16.448370, 25); INSERT INTO "Tätorter" VALUES (2364, 'Piperskärr', 883, 551, 57.783330, 16.633060, NULL); INSERT INTO "Tätorter" VALUES (2368, 'Påryd', 880, 651, 56.566670, 15.916670, 64); INSERT INTO "Tätorter" VALUES (2372, 'Påskallavik', 882, 1083, 57.166670, 16.450000, 4); INSERT INTO "Tätorter" VALUES (2376, 'Rinkabyholm', 880, 1607, 56.649720, 16.266670, 3); INSERT INTO "Tätorter" VALUES (2380, 'Rockneby', 880, 869, 56.816670, 16.333330, 16); INSERT INTO "Tätorter" VALUES (2384, 'Rosenfors', 860, 281, 59.333330, 16.483330, 37); INSERT INTO "Tätorter" VALUES (2388, 'Ruda', 821, 613, 58.633330, 15.766670, 53); INSERT INTO "Tätorter" VALUES (2394, 'Saltvik', 882, 352, 62.666670, 17.866670, NULL); INSERT INTO "Tätorter" VALUES (2400, 'Silverdalen', 860, 725, 57.533330, 15.733330, 133); INSERT INTO "Tätorter" VALUES (2404, 'Skogsby', 840, 569, 56.633330, 16.500000, 55); INSERT INTO "Tätorter" VALUES (2408, 'Smedby', 880, 3487, 60.700000, 15.050000, 177); INSERT INTO "Tätorter" VALUES (2412, 'Storebro', 884, 972, 57.583330, 15.850000, 138); INSERT INTO "Tätorter" VALUES (2416, 'Söderåkra', 834, 912, 56.450000, 16.066670, 11); INSERT INTO "Tätorter" VALUES (2420, 'Södra Vi', 884, 1182, 57.750000, 15.800000, 122); INSERT INTO "Tätorter" VALUES (2422, 'Söregärde-Drag', 880, 274, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (2424, 'Timmernabben', 861, 1276, 56.966670, 16.433330, 10); INSERT INTO "Tätorter" VALUES (2428, 'Torsås', 834, 1848, 56.412510, 15.998440, 10); INSERT INTO "Tätorter" VALUES (2432, 'Totebo', 883, 239, 57.633330, 16.200000, 98); INSERT INTO "Tätorter" VALUES (2436, 'Trekanten', 880, 1422, 56.700000, 16.116670, 29); INSERT INTO "Tätorter" VALUES (2440, 'Tuna', 884, 227, 62.650000, 17.333330, 134); INSERT INTO "Tätorter" VALUES (2444, 'Tvärskog', 880, 404, 56.616670, 16.033330, 53); INSERT INTO "Tätorter" VALUES (2452, 'Vassmolösa', 880, 535, 56.600000, 16.166670, 13); INSERT INTO "Tätorter" VALUES (2456, 'Vena', 860, 367, 58.083330, 15.900000, 118); INSERT INTO "Tätorter" VALUES (2458, 'Vickleby', 840, 320, 56.579180, 16.459360, 54); INSERT INTO "Tätorter" VALUES (2460, 'Vimmerby', 884, 7934, 57.665880, 15.855150, 128); INSERT INTO "Tätorter" VALUES (2464, 'Virserum', 860, 1742, 57.316670, 15.583330, 127); INSERT INTO "Tätorter" VALUES (2468, 'Vissefjärda', 862, 670, 56.533330, 15.583330, 108); INSERT INTO "Tätorter" VALUES (2472, 'Västervik', 883, 21140, 57.758400, 16.637330, 5); INSERT INTO "Tätorter" VALUES (2480, 'Ålem', 861, 803, 56.950000, 16.383330, 21); INSERT INTO "Tätorter" VALUES (2484, 'Örsjö', 881, 369, 56.700000, 15.750000, 118); INSERT INTO "Tätorter" VALUES (2488, 'Överum', 883, 1203, 57.983330, 16.316670, 48); INSERT INTO "Tätorter" VALUES (2500, 'Burgsvik', 980, 338, 57.050000, 18.266670, NULL); INSERT INTO "Tätorter" VALUES (2504, 'Fårösund', 980, 816, 57.866670, 19.050000, NULL); INSERT INTO "Tätorter" VALUES (2506, 'Gustavsvik', 980, 453, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (2508, 'Havdhem', 980, 298, 57.150000, 18.316670, 7); INSERT INTO "Tätorter" VALUES (2512, 'Hemse', 980, 1715, 57.237880, 18.374430, 28); INSERT INTO "Tätorter" VALUES (2520, 'Klintehamn', 980, 1363, 57.386670, 18.203710, 4); INSERT INTO "Tätorter" VALUES (2524, 'Ljugarn', 980, 238, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (2528, 'Lärbro', 980, 484, 57.783330, 18.783330, 15); INSERT INTO "Tätorter" VALUES (2532, 'Romakloster', 980, 913, 57.516670, 18.450000, 31); INSERT INTO "Tätorter" VALUES (2534, 'Roma', 980, 261, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (2536, 'Slite', 980, 1483, 57.704610, 18.803100, 1); INSERT INTO "Tätorter" VALUES (2540, 'Stånga', 980, 317, 57.283330, 18.466670, 27); INSERT INTO "Tätorter" VALUES (2542, 'Tingstäde', 980, 265, 57.733330, 18.583330, 48); INSERT INTO "Tätorter" VALUES (2548, 'Vibble', 980, 1286, 57.600000, 18.250000, 46); INSERT INTO "Tätorter" VALUES (2552, 'Visby', 980, 22593, 57.640890, 18.296020, 46); INSERT INTO "Tätorter" VALUES (2556, 'Väskinde', 980, 337, 57.683330, 18.416670, 48); INSERT INTO "Tätorter" VALUES (2560, 'Västerhejde', 980, 313, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (2600, 'Backaryd', 1081, 365, 56.333330, 15.183330, 68); INSERT INTO "Tätorter" VALUES (2604, 'Bräkne-Hoby', 1081, 1689, 56.233330, 15.116670, 41); INSERT INTO "Tätorter" VALUES (2616, 'Eringsboda', 1081, 299, 56.433330, 15.350000, 110); INSERT INTO "Tätorter" VALUES (2620, 'Fridlevstad', 1080, 713, 56.266670, 15.500000, 22); INSERT INTO "Tätorter" VALUES (2624, 'Fågelmara', 1080, 374, 56.250000, 15.950000, 12); INSERT INTO "Tätorter" VALUES (2628, 'Gränum', 1060, 223, 56.233330, 14.583330, 58); INSERT INTO "Tätorter" VALUES (2630, 'Gängletorp', 1080, 369, 56.166670, 15.733330, 12); INSERT INTO "Tätorter" VALUES (2632, 'Hallabro', 1081, 254, 56.383330, 15.100000, 98); INSERT INTO "Tätorter" VALUES (2640, 'Hasslö', 1080, 1628, 56.116670, 15.483330, NULL); INSERT INTO "Tätorter" VALUES (2644, 'Holmsjö', 1080, 334, 65.266670, 18.333330, 366); INSERT INTO "Tätorter" VALUES (2648, 'Hällaryd', 1082, 546, 57.466670, 15.166670, 145); INSERT INTO "Tätorter" VALUES (2652, 'Hällevik', 1083, 813, 56.016670, 14.700000, 10); INSERT INTO "Tätorter" VALUES (2656, 'Hörvik', 1083, 784, 56.033330, 14.766670, 1); INSERT INTO "Tätorter" VALUES (2660, 'Johannishus', 1081, 748, 56.216670, 15.416670, 24); INSERT INTO "Tätorter" VALUES (2664, 'Jämjö', 1080, 2578, 56.800000, 16.683330, 37); INSERT INTO "Tätorter" VALUES (2668, 'Jämshög', 1060, 1494, 56.233330, 14.516670, 52); INSERT INTO "Tätorter" VALUES (2672, 'Kallinge', 1081, 4561, 56.233330, 15.283330, 46); INSERT INTO "Tätorter" VALUES (2676, 'Karlshamn', 1082, 19075, 56.170600, 14.861880, 14); INSERT INTO "Tätorter" VALUES (2680, 'Karlskrona', 1080, 35212, 56.161560, 15.586610, 1); INSERT INTO "Tätorter" VALUES (2684, 'Kyrkhult', 1060, 937, 56.550000, 13.266670, 141); INSERT INTO "Tätorter" VALUES (2686, 'Kättilsmåla', 1080, 253, 56.266670, 15.733330, 50); INSERT INTO "Tätorter" VALUES (2688, 'Listerby', 1081, 883, 56.200000, 15.400000, 23); INSERT INTO "Tätorter" VALUES (2692, 'Lörby', 1083, 264, 56.066670, 14.700000, 9); INSERT INTO "Tätorter" VALUES (2696, 'Mjällby', 1083, 1254, 56.683330, 12.766670, 19); INSERT INTO "Tätorter" VALUES (2700, 'Mörrum', 1082, 3695, 56.183330, 14.750000, 27); INSERT INTO "Tätorter" VALUES (2704, 'Nogersund', 1083, 495, 56.000000, 14.733330, NULL); INSERT INTO "Tätorter" VALUES (2708, 'Norje', 1083, 657, 56.116670, 14.666670, 2); INSERT INTO "Tätorter" VALUES (2712, 'Nättraby', 1080, 3109, 56.200000, 15.516670, 13); INSERT INTO "Tätorter" VALUES (2716, 'Nävragöl', 1080, 210, 56.366670, 15.566670, 83); INSERT INTO "Tätorter" VALUES (2720, 'Olofström', 1060, 7327, 56.277300, 14.534020, 87); INSERT INTO "Tätorter" VALUES (2724, 'Pukavik', 1083, 279, 56.166670, 14.683330, 13); INSERT INTO "Tätorter" VALUES (2728, 'Ramdala', 1080, 217, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (2732, 'Ronneby', 1081, 12029, 56.209990, 15.276020, 30); INSERT INTO "Tätorter" VALUES (2734, 'Ronnebyhamn', 1081, 537, 56.183330, 15.300000, 1); INSERT INTO "Tätorter" VALUES (2736, 'Rödeby', 1080, 3402, 56.250000, 15.600000, 13); INSERT INTO "Tätorter" VALUES (2738, 'Skavkulla och Skillingenäs', 1080, 621, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (2740, 'Sturkö', 1080, 1264, 56.083330, 15.700000, 1); INSERT INTO "Tätorter" VALUES (2742, 'Sjuhalla', 1080, 204, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (2744, 'Spjutsbygd', 1080, 383, 56.316670, 15.583330, 72); INSERT INTO "Tätorter" VALUES (2748, 'Svängsta', 1082, 1682, 56.266670, 14.766670, 68); INSERT INTO "Tätorter" VALUES (2752, 'Sölvesborg', 1083, 8401, 56.052050, 14.575250, 5); INSERT INTO "Tätorter" VALUES (2754, 'Torarp', 1082, 263, 56.816670, 13.600000, 142); INSERT INTO "Tätorter" VALUES (2760, 'Torhamn', 1080, 423, 56.100000, 15.833330, 1); INSERT INTO "Tätorter" VALUES (2764, 'Tving', 1080, 459, 56.300000, 15.450000, 49); INSERT INTO "Tätorter" VALUES (2772, 'Vilshult', 1060, 314, 56.350000, 14.466670, 99); INSERT INTO "Tätorter" VALUES (2776, 'Åryd', 1082, 336, 57.950000, 13.650000, 267); INSERT INTO "Tätorter" VALUES (2800, 'Arkelstorp', 1290, 768, 56.200000, 13.816670, 62); INSERT INTO "Tätorter" VALUES (2804, 'Ballingslöv', 1293, 310, 56.216670, 13.850000, 72); INSERT INTO "Tätorter" VALUES (2808, 'Balsby', 1290, 430, 56.066670, 14.200000, 10); INSERT INTO "Tätorter" VALUES (2814, 'Bergströmshusen', 1230, 209, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (2816, 'Bjärnum', 1293, 2674, 56.283330, 13.700000, 96); INSERT INTO "Tätorter" VALUES (2818, 'Beden-Grevie', 1230, 241, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (2820, 'Borrby', 1291, 930, 55.450000, 14.166670, 18); INSERT INTO "Tätorter" VALUES (2824, 'Brantevik', 1291, 409, 55.516670, 14.350000, NULL); INSERT INTO "Tätorter" VALUES (2828, 'Broby', 1256, 2920, 56.255210, 14.077970, 45); INSERT INTO "Tätorter" VALUES (2832, 'Bromölla', 1272, 7595, 56.075510, 14.469580, 10); INSERT INTO "Tätorter" VALUES (2836, 'Brösarp', 1270, 680, 55.716670, 14.116670, 31); INSERT INTO "Tätorter" VALUES (2840, 'Båstad', 1278, 4961, 56.426890, 12.853390, NULL); INSERT INTO "Tätorter" VALUES (2844, 'Bäckaskog', 1290, 293, 58.350000, 13.383060, 116); INSERT INTO "Tätorter" VALUES (2848, 'Degeberga', 1290, 1291, 55.833330, 14.083330, 14); INSERT INTO "Tätorter" VALUES (2856, 'Eket', 1257, 409, 56.250000, 13.183330, 109); INSERT INTO "Tätorter" VALUES (2860, 'Emmaljunga', 1293, 262, 56.400000, 13.650000, 143); INSERT INTO "Tätorter" VALUES (2864, 'Everöd', 1290, 885, 55.900000, 14.100000, 13); INSERT INTO "Tätorter" VALUES (2868, 'Finja', 1293, 535, 56.166670, 13.683330, 68); INSERT INTO "Tätorter" VALUES (2872, 'Fjälkinge', 1290, 1690, 56.050000, 14.283330, 10); INSERT INTO "Tätorter" VALUES (2876, 'Färlöv', 1290, 1026, 56.066670, 14.083330, 9); INSERT INTO "Tätorter" VALUES (2880, 'Förslöv', 1278, 2085, 56.350000, 12.816670, 61); INSERT INTO "Tätorter" VALUES (2884, 'Glimåkra', 1256, 1383, 56.300000, 14.133330, 71); INSERT INTO "Tätorter" VALUES (2888, 'Grevie', 1278, 788, 56.366670, 12.800000, 71); INSERT INTO "Tätorter" VALUES (2892, 'Gualöv', 1272, 530, 56.050000, 14.416670, 7); INSERT INTO "Tätorter" VALUES (2896, 'Gärds Köpinge', 1290, 936, 55.933330, 14.150000, 9); INSERT INTO "Tätorter" VALUES (2900, 'Gärsnäs', 1291, 1000, 59.416670, 12.900000, 66); INSERT INTO "Tätorter" VALUES (2904, 'Hammar', 1290, 2057, 56.016670, 14.216670, 7); INSERT INTO "Tätorter" VALUES (2906, 'Hammarslund', 1290, 461, 56.000000, 14.216670, 7); INSERT INTO "Tätorter" VALUES (2908, 'Hammenhög', 1291, 908, 55.500000, 14.150000, 32); INSERT INTO "Tätorter" VALUES (2912, 'Hanaskog', 1256, 1251, 56.150000, 14.116670, 19); INSERT INTO "Tätorter" VALUES (2916, 'Hjärnarp', 1292, 975, 56.316670, 12.916670, 59); INSERT INTO "Tätorter" VALUES (2920, 'Hjärsås', 1256, 229, 56.200000, 14.150000, 15); INSERT INTO "Tätorter" VALUES (2924, 'Huaröd', 1290, 242, 55.833330, 13.966670, 141); INSERT INTO "Tätorter" VALUES (2928, 'Hyllinge', 1277, 2204, 56.100000, 12.850000, 9); INSERT INTO "Tätorter" VALUES (2936, 'Hässleholm', 1293, 18500, 56.159050, 13.766380, 77); INSERT INTO "Tätorter" VALUES (2940, 'Hästveda', 1293, 1623, 56.266670, 13.933330, 113); INSERT INTO "Tätorter" VALUES (2942, 'Höja', 1292, 202, 59.433330, 13.550000, 60); INSERT INTO "Tätorter" VALUES (2948, 'Immeln', 1256, 278, 56.200000, 14.250000, 61); INSERT INTO "Tätorter" VALUES (2952, 'Karups sommarby', 1265, 344, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (2956, 'Killeberg', 1273, 585, 56.466670, 14.083330, 139); INSERT INTO "Tätorter" VALUES (2960, 'Kivik', 1291, 960, 55.683330, 14.250000, 1); INSERT INTO "Tätorter" VALUES (2964, 'Klippan', 1276, 8116, 56.135590, 13.130860, 58); INSERT INTO "Tätorter" VALUES (2968, 'Klippans bruk', 1276, 314, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (2972, 'Knislinge', 1256, 3030, 56.183330, 14.083330, 10); INSERT INTO "Tätorter" VALUES (2980, 'Kristianstad', 1290, 35711, 56.031290, 14.152420, 5); INSERT INTO "Tätorter" VALUES (2984, 'Kvidinge', 1277, 1854, 56.133330, 13.066670, 38); INSERT INTO "Tätorter" VALUES (2988, 'Linderöd', 1290, 404, 55.933330, 13.816670, 128); INSERT INTO "Tätorter" VALUES (2992, 'Ljungbyhed', 1276, 2046, 56.066670, 13.216670, 74); INSERT INTO "Tätorter" VALUES (2996, 'Lunnarp', 1270, 339, 55.650000, 13.333330, 25); INSERT INTO "Tätorter" VALUES (3000, 'Lönsboda', 1273, 1903, 56.400000, 14.316670, 129); INSERT INTO "Tätorter" VALUES (3008, 'Mala', 1293, 217, 56.233330, 13.700000, 96); INSERT INTO "Tätorter" VALUES (3010, 'Margretetorp', 1292, 214, 56.333330, 12.883330, 30); INSERT INTO "Tätorter" VALUES (3012, 'Munka-Ljungby', 1292, 2840, 56.250000, 12.966670, 21); INSERT INTO "Tätorter" VALUES (3016, 'Norra Åsum', 1290, 1264, 55.983330, 14.150000, 8); INSERT INTO "Tätorter" VALUES (3020, 'Nymölla', 1272, 272, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3024, 'Näsum', 1272, 1117, 56.166670, 14.483330, 10); INSERT INTO "Tätorter" VALUES (3028, 'Onslunda', 1270, 490, 60.016670, 17.633330, 16); INSERT INTO "Tätorter" VALUES (3032, 'Osby', 1273, 7157, 56.381650, 13.993640, 76); INSERT INTO "Tätorter" VALUES (3034, 'Ovesholm', 1290, 299, 56.000000, 14.016670, 48); INSERT INTO "Tätorter" VALUES (3036, 'Perstorp', 1275, 5665, 56.138290, 13.394760, 109); INSERT INTO "Tätorter" VALUES (3040, 'Rinkaby', 1290, 745, 59.466670, 15.583330, 36); INSERT INTO "Tätorter" VALUES (3044, 'Röke', 1293, 219, 56.233330, 13.500000, 126); INSERT INTO "Tätorter" VALUES (3048, 'Sankt Olof', 1291, 624, 55.633330, 14.133330, 110); INSERT INTO "Tätorter" VALUES (3052, 'Sibbhult', 1256, 1364, 56.266670, 14.200000, 79); INSERT INTO "Tätorter" VALUES (3056, 'Simris', 1291, 211, 55.533330, 14.333330, 18); INSERT INTO "Tätorter" VALUES (3060, 'Simrishamn', 1291, 6527, 55.556530, 14.350370, 1); INSERT INTO "Tätorter" VALUES (3062, 'Sjörröd', 1293, 1077, 56.283330, 13.916670, 95); INSERT INTO "Tätorter" VALUES (3063, 'Skepparkroken', 1292, 743, 56.291670, 12.800000, 9); INSERT INTO "Tätorter" VALUES (3072, 'Skillinge', 1291, 859, 59.433330, 16.116670, 20); INSERT INTO "Tätorter" VALUES (3080, 'Skånes-Fagerhult', 1257, 856, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3084, 'Smedstorp', 1270, 363, 59.416670, 14.300000, 121); INSERT INTO "Tätorter" VALUES (3092, 'Stidsvig', 1276, 754, 56.200000, 13.133330, 81); INSERT INTO "Tätorter" VALUES (3096, 'Stoby', 1293, 745, 56.183330, 13.816670, 66); INSERT INTO "Tätorter" VALUES (3100, 'Strövelstorp', 1292, 1087, 56.150000, 12.816670, 9); INSERT INTO "Tätorter" VALUES (3102, 'Svenstorp', 1292, 239, 58.916670, 16.316670, 39); INSERT INTO "Tätorter" VALUES (3104, 'Sösdala', 1293, 1811, 56.033330, 13.666670, 98); INSERT INTO "Tätorter" VALUES (3108, 'Tollarp', 1290, 3284, 56.166670, 14.283330, 11); INSERT INTO "Tätorter" VALUES (3112, 'Tomelilla', 1270, 6444, 55.542930, 13.954600, 61); INSERT INTO "Tätorter" VALUES (3116, 'Torekov', 1278, 863, 56.425000, 12.633330, 8); INSERT INTO "Tätorter" VALUES (3120, 'Tormestorp', 1293, 1050, 56.116670, 13.733330, 64); INSERT INTO "Tätorter" VALUES (3124, 'Torsebro', 1290, 270, 56.100000, 14.116670, 10); INSERT INTO "Tätorter" VALUES (3128, 'Tyringe', 1293, 4658, 59.333330, 15.916670, 38); INSERT INTO "Tätorter" VALUES (3136, 'Valje', 1272, 823, 56.050000, 14.550000, NULL); INSERT INTO "Tätorter" VALUES (3140, 'Vankiva', 1293, 340, 56.183330, 13.733330, 75); INSERT INTO "Tätorter" VALUES (3144, 'Vejbystrand', 1292, 2721, 56.317780, 12.767220, 13); INSERT INTO "Tätorter" VALUES (3148, 'Viby', 1290, 991, 60.100000, 17.200000, 25); INSERT INTO "Tätorter" VALUES (3152, 'Vik', 1291, 319, 61.683330, 17.133330, 39); INSERT INTO "Tätorter" VALUES (3156, 'Vinnö', 1290, 536, 56.050000, 14.083330, 6); INSERT INTO "Tätorter" VALUES (3160, 'Vinslöv', 1293, 3984, 56.100000, 13.916670, 54); INSERT INTO "Tätorter" VALUES (3164, 'Vitaby', 1291, 278, 55.700000, 14.166670, 12); INSERT INTO "Tätorter" VALUES (3168, 'Vittsjö', 1293, 1665, 61.116670, 16.100000, 379); INSERT INTO "Tätorter" VALUES (3170, 'Vittskövle', 1290, 235, 55.900000, 13.183330, 59); INSERT INTO "Tätorter" VALUES (3172, 'Västra Karup', 1278, 582, 56.416670, 12.750000, 134); INSERT INTO "Tätorter" VALUES (3180, 'Yngsjö', 1290, 302, 55.883330, 14.216670, 5); INSERT INTO "Tätorter" VALUES (3184, 'Åhus', 1290, 9423, 55.916670, 14.283330, 7); INSERT INTO "Tätorter" VALUES (3188, 'Åsljunga', 1257, 659, 56.316670, 13.366670, 155); INSERT INTO "Tätorter" VALUES (3192, 'Åstorp', 1277, 9488, 56.135660, 12.944300, 20); INSERT INTO "Tätorter" VALUES (3196, 'Ängelholm', 1292, 23240, 56.242800, 12.862190, 7); INSERT INTO "Tätorter" VALUES (3200, 'Önnestad', 1290, 1378, 56.050000, 14.016670, 10); INSERT INTO "Tätorter" VALUES (3208, 'Örkelljunga', 1257, 4818, 56.283380, 13.277730, 120); INSERT INTO "Tätorter" VALUES (3216, 'Österslöv', 1290, 414, 56.100000, 14.250000, 9); INSERT INTO "Tätorter" VALUES (3220, 'Östra Karup', 1278, 594, 56.416670, 12.950000, 9); INSERT INTO "Tätorter" VALUES (3224, 'Östra Ljungby', 1276, 935, 56.183330, 13.066670, 43); INSERT INTO "Tätorter" VALUES (3228, 'Östra Sönnarslöv', 1290, 294, 55.883330, 14.016670, 28); INSERT INTO "Tätorter" VALUES (3232, 'Östra Tommarp', 1291, 284, 55.533330, 14.233330, 29); INSERT INTO "Tätorter" VALUES (3300, 'Abbekås', 1264, 729, 55.400000, 13.600000, NULL); INSERT INTO "Tätorter" VALUES (3304, 'Allerum', 1283, 716, 56.116670, 12.683330, 12); INSERT INTO "Tätorter" VALUES (3308, 'Alstad', 1287, 237, 55.450000, 13.216670, 60); INSERT INTO "Tätorter" VALUES (3312, 'Anderslöv', 1287, 1808, 55.433330, 13.333330, 42); INSERT INTO "Tätorter" VALUES (3316, 'Annelöv', 1282, 380, 55.833330, 13.016670, 10); INSERT INTO "Tätorter" VALUES (3320, 'Arild', 1284, 522, 56.275000, 12.575000, NULL); INSERT INTO "Tätorter" VALUES (3328, 'Asmundtorp', 1282, 1562, 55.883330, 12.933330, 14); INSERT INTO "Tätorter" VALUES (3332, 'Bara', 1263, 3444, 58.683330, 17.066670, 13); INSERT INTO "Tätorter" VALUES (3336, 'Barsebäck', 1261, 524, 55.766670, 12.950000, 12); INSERT INTO "Tätorter" VALUES (3337, 'Barsebäckshamn', 1261, 438, 55.750000, 12.900000, NULL); INSERT INTO "Tätorter" VALUES (3338, 'Beddingestrand', 1287, 678, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3340, 'Billeberga', 1214, 987, 55.883330, 13.000000, 29); INSERT INTO "Tätorter" VALUES (3344, 'Billesholm', 1260, 2910, 56.050000, 13.000000, 81); INSERT INTO "Tätorter" VALUES (3348, 'Billinge', 1285, 415, 59.833330, 18.800000, 8); INSERT INTO "Tätorter" VALUES (3352, 'Bjuv', 1260, 6832, 56.083720, 12.919140, 14); INSERT INTO "Tätorter" VALUES (3356, 'Bjärred', 1262, 9542, 55.716670, 13.016670, 7); INSERT INTO "Tätorter" VALUES (3360, 'Bjärsjölagård', 1265, 324, 55.733330, 13.683330, 111); INSERT INTO "Tätorter" VALUES (3364, 'Blentarp', 1265, 1216, 55.583330, 13.600000, 44); INSERT INTO "Tätorter" VALUES (3372, 'Bunkeflostrand', 1280, 10386, 55.533330, 12.950000, 11); INSERT INTO "Tätorter" VALUES (3374, 'Burlövs egnahem', 1231, 554, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3376, 'Bårslöv', 1283, 2682, 56.000000, 12.816670, 40); INSERT INTO "Tätorter" VALUES (3380, 'Dalby', 1281, 5708, 59.533330, 17.350000, 12); INSERT INTO "Tätorter" VALUES (3384, 'Domsten', 1283, 617, 56.116670, 12.600000, 21); INSERT INTO "Tätorter" VALUES (3388, 'Dösjebro', 1261, 858, 55.816670, 13.016670, 9); INSERT INTO "Tätorter" VALUES (3392, 'Ekeby', 1260, 3230, 56.000000, 12.966670, 73); INSERT INTO "Tätorter" VALUES (3396, 'Eslöv', 1285, 17748, 55.839280, 13.303930, 56); INSERT INTO "Tätorter" VALUES (3400, 'Flyinge', 1285, 994, 55.750000, 13.350000, 15); INSERT INTO "Tätorter" VALUES (3402, 'Flädie', 1262, 251, 55.725000, 13.066670, 14); INSERT INTO "Tätorter" VALUES (3408, 'Furulund', 1261, 4180, 57.716670, 12.133330, 130); INSERT INTO "Tätorter" VALUES (3412, 'Gantofta', 1283, 1338, 55.983330, 12.800000, 32); INSERT INTO "Tätorter" VALUES (3416, 'Genarp', 1281, 2892, 55.600000, 13.383330, 40); INSERT INTO "Tätorter" VALUES (3424, 'Glemmingebro', 1286, 376, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3428, 'Glumslöv', 1282, 1994, 55.950000, 12.816670, 65); INSERT INTO "Tätorter" VALUES (3432, 'Gunnarstorp', 1260, 401, 58.300000, 14.100000, 121); INSERT INTO "Tätorter" VALUES (3436, 'Gårdstånga', 1285, 343, 55.766670, 13.350000, 40); INSERT INTO "Tätorter" VALUES (3438, 'Gessie villastad', 1233, 497, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3440, 'Harlösa', 1285, 763, 55.717250, 13.526230, 57); INSERT INTO "Tätorter" VALUES (3444, 'Hasslarp', 1283, 474, 56.150000, 12.816670, 9); INSERT INTO "Tätorter" VALUES (3448, 'Hedeskoga', 1286, 282, 55.450000, 13.800000, 29); INSERT INTO "Tätorter" VALUES (3452, 'Helsingborg', 1283, 97122, 56.046730, 12.694370, 28); INSERT INTO "Tätorter" VALUES (3456, 'Hittarp', 1283, 4075, 56.283330, 14.116670, 62); INSERT INTO "Tätorter" VALUES (3460, 'Hjärup', 1230, 4265, 55.668800, 13.139310, 12); INSERT INTO "Tätorter" VALUES (3464, 'Hofterup', 1261, 3501, 55.783330, 12.966670, 14); INSERT INTO "Tätorter" VALUES (3466, 'Holmeja', 1263, 239, 55.550000, 13.266670, 55); INSERT INTO "Tätorter" VALUES (3472, 'Hurva', 1285, 350, 55.800000, 13.433330, 65); INSERT INTO "Tätorter" VALUES (3476, 'Häljarp', 1282, 2795, 57.633330, 15.450000, 189); INSERT INTO "Tätorter" VALUES (3480, 'Torna Hällestad', 1281, 584, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3484, 'Härslöv', 1282, 382, 55.933330, 12.866670, 60); INSERT INTO "Tätorter" VALUES (3488, 'Höganäs', 1284, 14107, 56.199710, 12.557950, 9); INSERT INTO "Tätorter" VALUES (3492, 'Hököpinge', 1233, 1105, 55.483330, 13.016670, 18); INSERT INTO "Tätorter" VALUES (3496, 'Höllviken', 1233, 10607, 55.416670, 12.950000, 7); INSERT INTO "Tätorter" VALUES (3500, 'Hörby', 1266, 7085, 55.852380, 13.660940, 72); INSERT INTO "Tätorter" VALUES (3504, 'Höör', 1267, 7865, 55.934440, 13.538500, 55); INSERT INTO "Tätorter" VALUES (3506, 'Idala', 1281, 738, 55.620000, 13.500000, 41); INSERT INTO "Tätorter" VALUES (3508, 'Ingelsträde', 1284, 241, 56.183330, 12.616670, 7); INSERT INTO "Tätorter" VALUES (3512, 'Jonstorp', 1284, 1880, 58.000000, 12.716670, 128); INSERT INTO "Tätorter" VALUES (3516, 'Kattarp', 1283, 688, 57.300000, 12.933330, 224); INSERT INTO "Tätorter" VALUES (3524, 'Södra Klagshamn', 1280, 1367, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3528, 'Klagstorp', 1287, 323, 56.150000, 14.433330, 11); INSERT INTO "Tätorter" VALUES (3532, 'Klågerup', 1263, 1904, 55.594160, 13.245740, 17); INSERT INTO "Tätorter" VALUES (3538, 'Kurland', 1287, 507, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3540, 'Kungshult', 1285, 354, 55.850000, 13.400000, 86); INSERT INTO "Tätorter" VALUES (3542, 'Kvärlöv', 1282, 226, 55.833330, 13.000000, 9); INSERT INTO "Tätorter" VALUES (3543, 'Kyrkheddinge', 1230, 276, 55.650000, 13.266670, 13); INSERT INTO "Tätorter" VALUES (3544, 'Kågeröd', 1214, 1446, 56.016670, 13.100000, 141); INSERT INTO "Tätorter" VALUES (3552, 'Kävlinge', 1261, 9049, 55.791880, 13.110210, 14); INSERT INTO "Tätorter" VALUES (3556, 'Köpingebro', 1286, 1134, 55.466670, 13.933330, 15); INSERT INTO "Tätorter" VALUES (3560, 'Landskrona', 1282, 30499, 55.870800, 12.830160, 7); INSERT INTO "Tätorter" VALUES (3568, 'Lilla Harrie', 1261, 371, 55.792310, 13.203510, 24); INSERT INTO "Tätorter" VALUES (3572, 'Ljunghusen', 1233, 2555, 55.400000, 12.916670, 4); INSERT INTO "Tätorter" VALUES (3574, 'Ljungstorp och Jägersbo', 1267, 401, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3576, 'Lomma', 1262, 10837, 55.672440, 13.068490, 10); INSERT INTO "Tätorter" VALUES (3580, 'Ludvigsborg', 1266, 1041, 55.900000, 13.600000, 56); INSERT INTO "Tätorter" VALUES (3584, 'Lund', 1281, 82800, 55.705840, 13.193210, 47); INSERT INTO "Tätorter" VALUES (3588, 'Löberöd', 1285, 1127, 55.783330, 13.500000, 108); INSERT INTO "Tätorter" VALUES (3592, 'Löddeköpinge', 1261, 6290, 55.766670, 13.016670, 9); INSERT INTO "Tätorter" VALUES (3596, 'Löderup', 1286, 550, 55.433330, 14.116670, 14); INSERT INTO "Tätorter" VALUES (3600, 'Lövestad', 1265, 643, 55.650000, 13.883330, 67); INSERT INTO "Tätorter" VALUES (3604, 'Malmö', 1280, 280415, 55.605870, 13.000730, 10); INSERT INTO "Tätorter" VALUES (3608, 'Marieholm', 1285, 1598, 57.383330, 13.850000, 201); INSERT INTO "Tätorter" VALUES (3612, 'Mjöhult', 1284, 292, 57.683330, 15.733330, 195); INSERT INTO "Tätorter" VALUES (3616, 'Mölle', 1284, 715, 56.283330, 12.500000, 17); INSERT INTO "Tätorter" VALUES (3620, 'Mörarp', 1283, 1893, 56.066670, 12.866670, 19); INSERT INTO "Tätorter" VALUES (3622, 'Norra Rörum', 1267, 204, 56.016670, 13.500000, 110); INSERT INTO "Tätorter" VALUES (3632, 'Nybrostrand', 1286, 810, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3634, 'Ormanäs och Stanstorp', 1267, 438, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3636, 'Osbyholm', 1266, 269, 55.850000, 13.600000, 46); INSERT INTO "Tätorter" VALUES (3640, 'Oxie', 1280, 11493, 55.533330, 13.100000, 35); INSERT INTO "Tätorter" VALUES (3644, 'Påarp', 1283, 2789, 56.600000, 12.933330, 6); INSERT INTO "Tätorter" VALUES (3648, 'Revingeby', 1281, 545, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3652, 'Rydebäck', 1283, 5141, 55.966670, 12.766670, 10); INSERT INTO "Tätorter" VALUES (3656, 'Rydsgård', 1264, 1361, 55.466670, 13.583330, 38); INSERT INTO "Tätorter" VALUES (3658, 'Rängs sand', 1233, 808, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3660, 'Röstånga', 1214, 839, 56.000000, 13.283330, 60); INSERT INTO "Tätorter" VALUES (3662, 'Sandskogen', 1261, 621, 55.766670, 12.983330, 13); INSERT INTO "Tätorter" VALUES (3664, 'Sjöbo', 1265, 6724, 55.631350, 13.706220, 48); INSERT INTO "Tätorter" VALUES (3668, 'Sjödiken', 1263, 438, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3672, 'Skanör med Falsterbo', 1233, 6937, 55.400000, 12.850000, 4); INSERT INTO "Tätorter" VALUES (3676, 'Skegrie', 1287, 1106, 55.400000, 13.066670, 13); INSERT INTO "Tätorter" VALUES (3680, 'Skivarp', 1264, 1257, 55.416670, 13.566670, 16); INSERT INTO "Tätorter" VALUES (3682, 'Skumparp', 1280, 205, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3684, 'Skurup', 1264, 7565, 55.478390, 13.501860, 50); INSERT INTO "Tätorter" VALUES (3688, 'Smygehamn', 1287, 1278, 55.333330, 13.383330, NULL); INSERT INTO "Tätorter" VALUES (3696, 'Staffanstorp', 1230, 14808, 55.642770, 13.206380, 13); INSERT INTO "Tätorter" VALUES (3700, 'Stehag', 1285, 1122, 55.900000, 13.383330, 61); INSERT INTO "Tätorter" VALUES (3704, 'Stockamöllan', 1285, 300, 55.950000, 13.366670, 48); INSERT INTO "Tätorter" VALUES (3708, 'Stora Herrestad', 1286, 293, 55.466670, 13.866670, 15); INSERT INTO "Tätorter" VALUES (3712, 'Stångby', 1281, 1218, 59.766670, 16.833330, 34); INSERT INTO "Tätorter" VALUES (3714, 'Sjöbo sommarby och Svansjö sommarby', 1265, 668, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3716, 'Svalöv', 1214, 3633, 55.913400, 13.107620, 58); INSERT INTO "Tätorter" VALUES (3718, 'Saxtorpsskogen', 1282, 973, 55.833330, 12.941670, 12); INSERT INTO "Tätorter" VALUES (3720, 'Svarte', 1286, 902, 55.416670, 13.716670, NULL); INSERT INTO "Tätorter" VALUES (3724, 'Svedala', 1263, 10627, 55.507880, 13.235150, 46); INSERT INTO "Tätorter" VALUES (3728, 'Sätofta', 1267, 1348, 55.916670, 13.550000, 39); INSERT INTO "Tätorter" VALUES (3732, 'Södra Sandby', 1281, 6136, 56.566670, 16.616670, 24); INSERT INTO "Tätorter" VALUES (3736, 'Södra Vrams fälad', 1260, 249, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3738, 'Sövde', 1265, 291, 55.583330, 13.666670, 36); INSERT INTO "Tätorter" VALUES (3740, 'Sövestad', 1286, 386, 55.500000, 13.783330, 40); INSERT INTO "Tätorter" VALUES (3744, 'Teckomatorp', 1214, 1651, 55.866670, 13.083330, 22); INSERT INTO "Tätorter" VALUES (3748, 'Tjörnarp', 1267, 731, 56.000000, 13.616670, 95); INSERT INTO "Tätorter" VALUES (3750, 'Toarp', 1280, 219, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3752, 'Trelleborg', 1287, 28290, 55.375140, 13.156910, 9); INSERT INTO "Tätorter" VALUES (3756, 'Tygelsjö', 1280, 2710, 55.516670, 13.000000, 25); INSERT INTO "Tätorter" VALUES (3760, 'Tågarp', 1214, 431, 56.933330, 12.600000, 8); INSERT INTO "Tätorter" VALUES (3764, 'Tånga och Rögle', 1283, 223, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3766, 'Utvälinge', 1283, 227, 56.216670, 12.783330, NULL); INSERT INTO "Tätorter" VALUES (3772, 'Vallåkra', 1283, 642, 55.966670, 12.866670, 45); INSERT INTO "Tätorter" VALUES (3776, 'Veberöd', 1281, 4062, 55.633330, 13.483330, 27); INSERT INTO "Tätorter" VALUES (3780, 'Vellinge', 1233, 6304, 55.471240, 13.019710, 12); INSERT INTO "Tätorter" VALUES (3784, 'Viken', 1284, 4227, 64.725870, 20.915480, 87); INSERT INTO "Tätorter" VALUES (3788, 'Vintrie', 1280, 670, 55.550000, 12.966670, 13); INSERT INTO "Tätorter" VALUES (3792, 'Vollsjö', 1265, 836, 55.700000, 13.766670, 70); INSERT INTO "Tätorter" VALUES (3800, 'Västra Ingelstad', 1233, 721, 55.483330, 13.116670, 46); INSERT INTO "Tätorter" VALUES (3802, 'Västra Karaby', 1261, 229, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3804, 'Västra Klagstorp', 1280, 279, 55.533330, 12.983330, 12); INSERT INTO "Tätorter" VALUES (3806, 'Västra Tommarp', 1287, 214, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3808, 'Ystad', 1286, 18350, 55.429660, 13.820410, 8); INSERT INTO "Tätorter" VALUES (3812, 'Åkarp', 1231, 5617, 58.233330, 13.650000, 167); INSERT INTO "Tätorter" VALUES (3816, 'Äsperöd', 1265, 222, 58.149720, 12.116670, 17); INSERT INTO "Tätorter" VALUES (3820, 'Ödåkra', 1283, 4920, 56.100000, 12.733330, 19); INSERT INTO "Tätorter" VALUES (3828, 'Örtofta', 1285, 202, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3830, 'Väggarp', 1285, 211, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3832, 'Östra Grevie', 1233, 598, 55.466670, 13.133330, 44); INSERT INTO "Tätorter" VALUES (3834, 'Önneköp', 1266, 206, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3836, 'Östraby', 1266, 200, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3898, 'Röda holme', 1384, 279, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3900, 'Anneberg', 1384, 1469, 60.241670, 18.416670, NULL); INSERT INTO "Tätorter" VALUES (3904, 'Backa', 1384, 1547, 64.983330, 21.066670, 58); INSERT INTO "Tätorter" VALUES (3908, 'Bergagård', 1382, 250, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3910, 'Brattås', 1384, 384, 57.550000, 11.980000, 58); INSERT INTO "Tätorter" VALUES (3912, 'Bua', 1383, 1746, 57.566670, 12.666670, 98); INSERT INTO "Tätorter" VALUES (3914, 'Buerås', 1384, 708, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3916, 'Eldsberga', 1380, 720, 56.600000, 13.000000, 24); INSERT INTO "Tätorter" VALUES (3920, 'Falkenberg', 1382, 20035, 56.905520, 12.491180, 3); INSERT INTO "Tätorter" VALUES (3928, 'Fjärås kyrkby', 1384, 2321, 57.459130, 12.175080, 68); INSERT INTO "Tätorter" VALUES (3932, 'Frillesås', 1384, 2044, 57.316670, 12.166670, 19); INSERT INTO "Tätorter" VALUES (3934, 'Frösakull', 1380, 1635, 56.683330, 12.733330, 21); INSERT INTO "Tätorter" VALUES (3935, 'Fyllinge', 1380, 2927, 56.650000, 12.916670, 17); INSERT INTO "Tätorter" VALUES (3936, 'Genevad', 1381, 565, 56.566670, 13.016670, 18); INSERT INTO "Tätorter" VALUES (3940, 'Getinge', 1380, 1843, 56.816670, 12.733330, 8); INSERT INTO "Tätorter" VALUES (3944, 'Glommen', 1382, 761, 57.933330, 12.350000, 118); INSERT INTO "Tätorter" VALUES (3948, 'Gullbrandstorp', 1380, 1524, 56.700000, 12.733330, 29); INSERT INTO "Tätorter" VALUES (3950, 'Gundal och Högås', 1384, 384, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3952, 'Gullbranna', 1380, 704, 56.591670, 12.950000, 15); INSERT INTO "Tätorter" VALUES (3954, 'Hagryd-Dala', 1384, 391, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3956, 'Halla Heberg', 1384, 518, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (3960, 'Halmstad', 1380, 58577, 56.674460, 12.856760, 4); INSERT INTO "Tätorter" VALUES (3964, 'Harplinge', 1380, 1450, 56.750000, 12.716670, 40); INSERT INTO "Tätorter" VALUES (3968, 'Hasslöv', 1381, 228, 56.416670, 13.000000, 38); INSERT INTO "Tätorter" VALUES (3972, 'Haverdal', 1380, 1437, 56.722220, 12.671940, 7); INSERT INTO "Tätorter" VALUES (3976, 'Heberg', 1382, 449, 57.466940, 11.994720, 20); INSERT INTO "Tätorter" VALUES (3982, 'Himle', 1383, 278, 57.066670, 12.366670, 43); INSERT INTO "Tätorter" VALUES (3984, 'Hishult', 1381, 332, 56.433330, 13.300000, 132); INSERT INTO "Tätorter" VALUES (3986, 'Hjälm', 1384, 242, 57.494010, 12.166070, 38); INSERT INTO "Tätorter" VALUES (3988, 'Holm', 1380, 565, 61.666670, 17.216670, 14); INSERT INTO "Tätorter" VALUES (3990, 'Hjälmared', 1384, 360, 57.883330, 12.533330, 86); INSERT INTO "Tätorter" VALUES (3992, 'Hyltebruk', 1315, 3716, 56.998920, 13.239580, 147); INSERT INTO "Tätorter" VALUES (3996, 'Kinnared', 1315, 287, 57.783330, 13.516670, 331); INSERT INTO "Tätorter" VALUES (3998, 'Kläppa', 1384, 318, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4000, 'Knäred', 1381, 1088, 56.533330, 13.316670, 92); INSERT INTO "Tätorter" VALUES (4008, 'Kungsbacka', 1384, 19057, 57.487190, 12.076120, 17); INSERT INTO "Tätorter" VALUES (4012, 'Kungsäter', 1383, 353, 57.316670, 12.566670, 116); INSERT INTO "Tätorter" VALUES (4016, 'Kvibille', 1380, 925, 56.783330, 12.833330, 61); INSERT INTO "Tätorter" VALUES (4028, 'Laholm', 1381, 6150, 56.512070, 13.043710, 28); INSERT INTO "Tätorter" VALUES (4032, 'Landeryd', 1315, 367, 57.083330, 13.266670, 157); INSERT INTO "Tätorter" VALUES (4034, 'Laxvik', 1380, 475, 59.316670, 11.900000, 103); INSERT INTO "Tätorter" VALUES (4036, 'Lilla Tjärby', 1381, 914, 56.533330, 13.033330, 43); INSERT INTO "Tätorter" VALUES (4038, 'Lerkil', 1384, 505, 57.453890, 11.920560, 14); INSERT INTO "Tätorter" VALUES (4040, 'Långås', 1382, 534, 56.983330, 12.450000, 7); INSERT INTO "Tätorter" VALUES (4042, 'Löftaskog', 1383, 327, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4044, 'Mellbystrand', 1381, 1619, 56.516670, 12.933330, NULL); INSERT INTO "Tätorter" VALUES (4052, 'Morup', 1382, 259, 56.983330, 12.400000, 2); INSERT INTO "Tätorter" VALUES (4054, 'Onsala', 1384, 11951, 57.425310, 12.029030, 33); INSERT INTO "Tätorter" VALUES (4056, 'Oskarström', 1380, 4071, 56.800000, 12.966670, 34); INSERT INTO "Tätorter" VALUES (4058, 'Ringsegård', 1382, 446, 56.866670, 12.550000, 16); INSERT INTO "Tätorter" VALUES (4060, 'Rolfstorp', 1383, 513, 57.150000, 12.450000, 58); INSERT INTO "Tätorter" VALUES (4068, 'Rydöbruk', 1315, 388, 56.950000, 13.150000, 129); INSERT INTO "Tätorter" VALUES (4072, 'Ränneslöv', 1381, 413, 56.450000, 13.066670, 71); INSERT INTO "Tätorter" VALUES (4076, 'Sennan', 1380, 399, 56.766670, 12.983330, 40); INSERT INTO "Tätorter" VALUES (4080, 'Simlångsdalen', 1380, 587, 56.716670, 13.116670, 87); INSERT INTO "Tätorter" VALUES (4084, 'Skedala', 1380, 351, 56.700000, 12.966670, 42); INSERT INTO "Tätorter" VALUES (4088, 'Skogstorp', 1382, 2124, 59.333330, 16.466670, 28); INSERT INTO "Tätorter" VALUES (4092, 'Skottorp', 1381, 475, 59.933330, 15.383330, 229); INSERT INTO "Tätorter" VALUES (4094, 'Skreanäs', 1382, 243, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4096, 'Skrea', 1382, 1064, 56.883330, 12.566670, 5); INSERT INTO "Tätorter" VALUES (4098, 'Skummeslövsstrand', 1381, 491, 56.466670, 12.916670, NULL); INSERT INTO "Tätorter" VALUES (4100, 'Skällinge', 1383, 626, 57.183330, 12.466670, 97); INSERT INTO "Tätorter" VALUES (4104, 'Slöinge', 1382, 950, 56.850000, 12.683330, 16); INSERT INTO "Tätorter" VALUES (4106, 'Steninge', 1380, 836, 59.600000, 17.800000, 1); INSERT INTO "Tätorter" VALUES (4108, 'Särö', 1384, 3165, 57.500000, 11.933330, NULL); INSERT INTO "Tätorter" VALUES (4112, 'Tofta', 1383, 386, 58.516670, 13.116670, 45); INSERT INTO "Tätorter" VALUES (4116, 'Torup', 1315, 1183, 56.966670, 13.083330, 94); INSERT INTO "Tätorter" VALUES (4120, 'Träslövsläge', 1383, 2600, 57.065830, 12.282780, 14); INSERT INTO "Tätorter" VALUES (4122, 'Södra Näs', 1383, 671, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4124, 'Trönninge', 1380, 1504, 57.133330, 12.283330, 24); INSERT INTO "Tätorter" VALUES (4128, 'Trönninge', 1383, 880, 57.133330, 12.283330, 24); INSERT INTO "Tätorter" VALUES (4132, 'Tvååker', 1383, 2534, 57.050000, 12.400000, 32); INSERT INTO "Tätorter" VALUES (4134, 'Tylösand', 1380, 399, 56.650000, 12.733330, 15); INSERT INTO "Tätorter" VALUES (4136, 'Tångaberg', 1383, 468, 57.166670, 12.216670, 17); INSERT INTO "Tätorter" VALUES (4140, 'Ullared', 1382, 791, 57.133330, 12.716670, 86); INSERT INTO "Tätorter" VALUES (4144, 'Unnaryd', 1315, 759, 56.950000, 13.516670, 143); INSERT INTO "Tätorter" VALUES (4148, 'Vallberga', 1381, 657, 56.466670, 13.016670, 49); INSERT INTO "Tätorter" VALUES (4152, 'Vallda', 1384, 1604, 57.477500, 12.001390, 26); INSERT INTO "Tätorter" VALUES (4156, 'Varberg', 1383, 27602, 57.105570, 12.250780, 31); INSERT INTO "Tätorter" VALUES (4158, 'Vassbäck', 1384, 617, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4160, 'Veddige', 1383, 2045, 57.266670, 12.316670, 38); INSERT INTO "Tätorter" VALUES (4164, 'Veinge', 1381, 1190, 56.550000, 13.066670, 51); INSERT INTO "Tätorter" VALUES (4168, 'Vessigebro', 1382, 740, 56.983330, 12.650000, 16); INSERT INTO "Tätorter" VALUES (4176, 'Villshärad', 1380, 656, 56.700000, 12.683330, NULL); INSERT INTO "Tätorter" VALUES (4180, 'Vinberg', 1382, 592, 56.950000, 12.533330, 17); INSERT INTO "Tätorter" VALUES (4182, 'Vinbergs kyrkby', 1382, 208, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4184, 'Våxtorp', 1381, 970, 56.433330, 13.100000, 85); INSERT INTO "Tätorter" VALUES (4188, 'Väröbacka', 1383, 630, 57.250000, 12.183330, 24); INSERT INTO "Tätorter" VALUES (4190, 'Ysby', 1381, 260, 57.480280, 12.017500, 23); INSERT INTO "Tätorter" VALUES (4192, 'Åled', 1380, 1634, 56.750000, 12.933330, 55); INSERT INTO "Tätorter" VALUES (4196, 'Årstad', 1382, 284, 59.583330, 12.116670, 154); INSERT INTO "Tätorter" VALUES (4200, 'Åsa', 1384, 3369, 58.016670, 14.600000, 255); INSERT INTO "Tätorter" VALUES (4204, 'Åsby', 1383, 423, 59.933330, 18.283330, 27); INSERT INTO "Tätorter" VALUES (4212, 'Älvsered', 1382, 433, 57.233330, 12.866670, 172); INSERT INTO "Tätorter" VALUES (4216, 'Ätran', 1382, 417, 57.116670, 12.950000, 130); INSERT INTO "Tätorter" VALUES (4224, 'Västra Hagen', 1384, 969, 57.424440, 11.935830, 33); INSERT INTO "Tätorter" VALUES (4228, 'Ölmanäs', 1384, 886, 57.362410, 12.088390, NULL); INSERT INTO "Tätorter" VALUES (4290, 'Benareby', 1401, 384, 57.650000, 12.166670, 91); INSERT INTO "Tätorter" VALUES (4294, 'Angered', 1480, 950, 57.783330, 12.100000, 131); INSERT INTO "Tätorter" VALUES (4296, 'Ammenäs', 1485, 544, 58.308330, 11.833330, NULL); INSERT INTO "Tätorter" VALUES (4298, 'Asperö', 1480, 402, 57.647880, 11.793650, NULL); INSERT INTO "Tätorter" VALUES (4300, 'Billdal', 1384, 10289, 57.566670, 11.933330, NULL); INSERT INTO "Tätorter" VALUES (4302, 'Björlanda', 1480, 608, 57.766670, 11.833330, 22); INSERT INTO "Tätorter" VALUES (4304, 'Björkö', 1407, 1427, 59.750000, 19.000000, 4); INSERT INTO "Tätorter" VALUES (4308, 'Bleket', 1419, 240, 57.950000, 11.566670, NULL); INSERT INTO "Tätorter" VALUES (4310, 'Bosnäs', 1490, 308, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4312, 'Bovallstrand', 1427, 474, 58.483330, 11.316670, NULL); INSERT INTO "Tätorter" VALUES (4316, 'Brastad', 1484, 1846, 58.383330, 11.483330, 50); INSERT INTO "Tätorter" VALUES (4322, 'Brännö', 1480, 708, 57.645280, 11.781670, 1); INSERT INTO "Tätorter" VALUES (4324, 'Dingle', 1430, 900, 58.533330, 11.566670, 31); INSERT INTO "Tätorter" VALUES (4328, 'Diseröd', 1482, 1241, 57.916670, 12.016670, 34); INSERT INTO "Tätorter" VALUES (4330, 'Djupedalen', 1487, 270, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4332, 'Donsö', 1480, 1407, 57.600000, 11.799170, NULL); INSERT INTO "Tätorter" VALUES (4334, 'Eskilsby och Snugga', 1401, 220, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4336, 'Ellös', 1421, 998, 58.183330, 11.466670, NULL); INSERT INTO "Tätorter" VALUES (4338, 'Fagerhult', 1485, 353, 58.816670, 11.600000, 121); INSERT INTO "Tätorter" VALUES (4340, 'Fiskebäckskil', 1484, 379, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4344, 'Fjällbacka', 1435, 859, 59.049720, 12.566670, 147); INSERT INTO "Tätorter" VALUES (4348, 'Fotö', 1407, 620, 57.666670, 11.658330, NULL); INSERT INTO "Tätorter" VALUES (4354, 'Hällingsjö', 1401, 308, 57.616670, 12.433330, 83); INSERT INTO "Tätorter" VALUES (4356, 'Grebbestad', 1435, 1401, 58.702480, 11.257380, 25); INSERT INTO "Tätorter" VALUES (4360, 'Grundsund', 1484, 627, 58.216670, 11.416670, NULL); INSERT INTO "Tätorter" VALUES (4368, 'Göteborg', 1480, 549839, 57.707160, 11.966790, 6); INSERT INTO "Tätorter" VALUES (4370, 'Hallerna', 1415, 668, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4372, 'Hamburgsund', 1435, 818, 58.552540, 11.272680, 25); INSERT INTO "Tätorter" VALUES (4374, 'Hallsåsåsen', 1441, 408, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4380, 'Hedekas', 1430, 370, 58.650000, 11.766670, 100); INSERT INTO "Tätorter" VALUES (4384, 'Henån', 1421, 1816, 58.238480, 11.675980, 50); INSERT INTO "Tätorter" VALUES (4388, 'Herrestad', 1485, 2583, 58.383330, 14.800000, 91); INSERT INTO "Tätorter" VALUES (4392, 'Hindås', 1401, 2244, 57.700000, 12.450000, 149); INSERT INTO "Tätorter" VALUES (4396, 'Hjuvik', 1480, 3928, 57.701670, 11.716390, NULL); INSERT INTO "Tätorter" VALUES (4398, 'Hogstorp', 1485, 373, 58.400000, 11.750000, 75); INSERT INTO "Tätorter" VALUES (4404, 'Hunnebostrand', 1427, 1731, 58.441270, 11.303200, 38); INSERT INTO "Tätorter" VALUES (4410, 'Hällesåker', 1481, 357, 57.600000, 13.170000, 173); INSERT INTO "Tätorter" VALUES (4412, 'Hällevadsholm', 1430, 772, 58.583330, 11.533330, 89); INSERT INTO "Tätorter" VALUES (4414, 'Hälleviksstrand', 1421, 214, 58.125000, 11.450000, 20); INSERT INTO "Tätorter" VALUES (4420, 'Hälsö', 1407, 611, 57.733330, 11.650000, NULL); INSERT INTO "Tätorter" VALUES (4424, 'Härryda', 1401, 968, 57.654360, 12.363180, 145); INSERT INTO "Tätorter" VALUES (4428, 'Hönö', 1407, 5110, 57.689720, 11.649720, 11); INSERT INTO "Tätorter" VALUES (4432, 'Jonsered', 1402, 930, 57.750000, 12.166670, 82); INSERT INTO "Tätorter" VALUES (4434, 'Kalvsund', 1407, 221, 57.706110, 11.685560, NULL); INSERT INTO "Tätorter" VALUES (4436, 'Jörlanda', 1415, 789, 57.986300, 11.829430, 37); INSERT INTO "Tätorter" VALUES (4438, 'Kareby', 1482, 292, 57.916670, 11.900000, 42); INSERT INTO "Tätorter" VALUES (4439, 'Kebal', 1486, 258, 58.944440, 11.158330, 10); INSERT INTO "Tätorter" VALUES (4440, 'Klädesholmen', 1419, 385, 57.950000, 11.533330, NULL); INSERT INTO "Tätorter" VALUES (4444, 'Kode', 1482, 1380, 57.933330, 11.850000, 46); INSERT INTO "Tätorter" VALUES (4448, 'Kungshamn', 1427, 2814, 58.363050, 11.259380, 23); INSERT INTO "Tätorter" VALUES (4452, 'Kungälv', 1482, 22768, 57.870960, 11.980540, 52); INSERT INTO "Tätorter" VALUES (4456, 'Kvisljungeby', 1480, 639, 57.750000, 11.833330, 24); INSERT INTO "Tätorter" VALUES (4464, 'Kåhög', 1402, 832, 57.750000, 12.133330, 12); INSERT INTO "Tätorter" VALUES (4468, 'Kållekärr', 1419, 560, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4472, 'Kållered', 1481, 7456, 57.609920, 12.051060, 68); INSERT INTO "Tätorter" VALUES (4476, 'Källö-Knippla', 1407, 369, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4480, 'Kärna', 1482, 430, 60.116670, 16.250000, 66); INSERT INTO "Tätorter" VALUES (4482, 'Lanesund', 1485, 347, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4484, 'Landvetter', 1401, 7152, 57.686650, 12.211690, 75); INSERT INTO "Tätorter" VALUES (4488, 'Lindome', 1481, 11037, 57.566670, 12.083330, 14); INSERT INTO "Tätorter" VALUES (4492, 'Ljungskile', 1485, 3375, 58.216670, 11.916670, NULL); INSERT INTO "Tätorter" VALUES (4496, 'Lysekil', 1484, 7628, 58.274290, 11.435760, 1); INSERT INTO "Tätorter" VALUES (4498, 'Låssby', 1480, 251, 57.733330, 11.833330, 18); INSERT INTO "Tätorter" VALUES (4504, 'Marstrand', 1482, 1319, 57.886990, 11.582180, 1); INSERT INTO "Tätorter" VALUES (4508, 'Mollösund', 1421, 236, 58.066670, 11.466670, 3); INSERT INTO "Tätorter" VALUES (4510, 'Tumlehed', 1480, 475, 57.733330, 11.716670, NULL); INSERT INTO "Tätorter" VALUES (4512, 'Munkedal', 1430, 3718, 58.472440, 11.668590, 22); INSERT INTO "Tätorter" VALUES (4514, 'Höviksnäs', 1419, 1309, 58.033330, 11.766670, NULL); INSERT INTO "Tätorter" VALUES (4516, 'Myggenäs', 1419, 1230, 58.061760, 11.749360, 13); INSERT INTO "Tätorter" VALUES (4518, 'Mysterna', 1480, 3418, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4520, 'Mölnlycke', 1401, 15608, 57.658930, 12.117920, 91); INSERT INTO "Tätorter" VALUES (4522, 'Nolvik', 1480, 1025, 57.783330, 11.816670, 14); INSERT INTO "Tätorter" VALUES (4526, 'Nya Långenäs', 1401, 268, 57.650000, 12.166670, 91); INSERT INTO "Tätorter" VALUES (4528, 'Olofstorp', 1480, 3378, 58.250000, 14.000000, 130); INSERT INTO "Tätorter" VALUES (4532, 'Rabbalshede', 1435, 275, 58.616670, 11.466670, 99); INSERT INTO "Tätorter" VALUES (4540, 'Rixö', 1484, 357, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4542, 'Rya', 1401, 290, 59.550000, 15.233330, 66); INSERT INTO "Tätorter" VALUES (4544, 'Rävlanda', 1401, 1462, 57.650000, 12.500000, 139); INSERT INTO "Tätorter" VALUES (4546, 'Rödbo', 1480, 278, 57.841670, 11.950000, 53); INSERT INTO "Tätorter" VALUES (4548, 'Rönnäng', 1419, 1437, 57.933330, 11.583330, NULL); INSERT INTO "Tätorter" VALUES (4550, 'Andalen', 1480, 2188, 57.700000, 11.750000, NULL); INSERT INTO "Tätorter" VALUES (4552, 'Rörö', 1407, 269, 57.776110, 11.616670, 1); INSERT INTO "Tätorter" VALUES (4554, 'Torreby', 1430, 215, 58.450000, 11.600000, 68); INSERT INTO "Tätorter" VALUES (4556, 'Skee', 1486, 583, 58.933330, 11.316670, 50); INSERT INTO "Tätorter" VALUES (4560, 'Skärhamn', 1419, 3193, 57.986650, 11.557420, 20); INSERT INTO "Tätorter" VALUES (4562, 'Slätten', 1482, 247, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4564, 'Smögen', 1427, 1329, 58.355930, 11.224110, 3); INSERT INTO "Tätorter" VALUES (4566, 'Starrkärr och Näs', 1415, 499, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4568, 'Stenungsund', 1415, 9987, 58.070460, 11.818100, 23); INSERT INTO "Tätorter" VALUES (4570, 'Stora Bugärde', 1401, 367, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4572, 'Stora Dyrön', 1419, 250, 57.933330, 11.616670, 1); INSERT INTO "Tätorter" VALUES (4574, 'Stenared', 1480, 237, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4576, 'Stora Höga', 1415, 2751, 58.016670, 11.833330, 23); INSERT INTO "Tätorter" VALUES (4578, 'Stenungsön', 1415, 264, 58.066670, 11.800000, 3); INSERT INTO "Tätorter" VALUES (4580, 'Strandnorum', 1415, 1251, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4584, 'Strömstad', 1486, 6288, 58.939450, 11.171200, 23); INSERT INTO "Tätorter" VALUES (4588, 'Styrsö', 1480, 1304, 57.616390, 11.785560, 1); INSERT INTO "Tätorter" VALUES (4590, 'Sunningen', 1485, 742, 58.333330, 11.833330, 3); INSERT INTO "Tätorter" VALUES (4592, 'Svanesund', 1421, 1518, 58.133330, 11.833330, 1); INSERT INTO "Tätorter" VALUES (4594, 'Svanvik', 1421, 293, 58.571030, 14.498860, 91); INSERT INTO "Tätorter" VALUES (4596, 'Säve', 1480, 743, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4598, 'Svenshögen', 1415, 421, 58.150000, 11.933330, 50); INSERT INTO "Tätorter" VALUES (4600, 'Tanumshede', 1435, 1697, 58.723850, 11.325870, 41); INSERT INTO "Tätorter" VALUES (4602, 'Tulebo', 1481, 213, 57.616670, 12.100000, 114); INSERT INTO "Tätorter" VALUES (4604, 'Tjuvkil', 1482, 501, 57.900000, 11.733330, 28); INSERT INTO "Tätorter" VALUES (4606, 'Ucklum', 1415, 255, 58.083330, 11.950000, 69); INSERT INTO "Tätorter" VALUES (4608, 'Uddevalla', 1485, 31212, 58.347840, 11.942400, 25); INSERT INTO "Tätorter" VALUES (4610, 'Varekil', 1421, 602, 58.133330, 11.700000, 25); INSERT INTO "Tätorter" VALUES (4612, 'Vrångö', 1480, 364, 58.399720, 16.850000, NULL); INSERT INTO "Tätorter" VALUES (4616, 'Väjern', 1427, 688, 58.383330, 11.266670, 25); INSERT INTO "Tätorter" VALUES (4622, 'Ånneröd', 1486, 225, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4624, 'Åstol', 1419, 210, 57.916670, 11.583330, NULL); INSERT INTO "Tätorter" VALUES (4628, 'Öckerö', 1407, 3488, 57.708140, 11.655850, 1); INSERT INTO "Tätorter" VALUES (4630, 'Ödsmål', 1415, 608, 58.716670, 11.483330, 100); INSERT INTO "Tätorter" VALUES (4631, 'Öjersjö', 1402, 3543, 57.700000, 12.116670, 145); INSERT INTO "Tätorter" VALUES (4640, 'Tahult', 1401, 585, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4700, 'Alingsås', 1489, 24482, 57.930330, 12.533450, 79); INSERT INTO "Tätorter" VALUES (4704, 'Alvhem', 1440, 202, 58.000000, 12.150000, 39); INSERT INTO "Tätorter" VALUES (4708, 'Ambjörnarp', 1452, 270, 57.416670, 13.283330, 190); INSERT INTO "Tätorter" VALUES (4712, 'Annelund', 1466, 519, 60.000000, 16.033330, 62); INSERT INTO "Tätorter" VALUES (4716, 'Aplared', 1490, 465, 57.650000, 13.066670, 223); INSERT INTO "Tätorter" VALUES (4720, 'Bengtsfors', 1460, 3080, 59.029120, 12.232070, 110); INSERT INTO "Tätorter" VALUES (4724, 'Berghem', 1463, 360, 57.883330, 14.366670, 295); INSERT INTO "Tätorter" VALUES (4728, 'Billingsfors', 1460, 1134, 58.983330, 12.250000, 76); INSERT INTO "Tätorter" VALUES (4732, 'Björboholm', 1441, 963, 57.883330, 12.316670, 74); INSERT INTO "Tätorter" VALUES (4736, 'Björketorp', 1463, 467, 59.616670, 13.666670, 100); INSERT INTO "Tätorter" VALUES (4740, 'Blidsberg', 1491, 508, 57.933330, 13.483330, 236); INSERT INTO "Tätorter" VALUES (4744, 'Bollebygd', 1443, 3566, 57.668660, 12.572720, 100); INSERT INTO "Tätorter" VALUES (4748, 'Borgstena', 1490, 386, 57.883330, 13.016670, 205); INSERT INTO "Tätorter" VALUES (4752, 'Borås', 1490, 66273, 57.721010, 12.940100, 166); INSERT INTO "Tätorter" VALUES (4756, 'Bredared', 1490, 227, 57.800000, 12.883330, 279); INSERT INTO "Tätorter" VALUES (4760, 'Brålanda', 1487, 1385, 58.566670, 12.366670, 63); INSERT INTO "Tätorter" VALUES (4768, 'Bäckefors', 1460, 673, 58.800000, 12.166670, 170); INSERT INTO "Tätorter" VALUES (4772, 'Dals Långed', 1460, 1520, 58.916670, 12.300000, 74); INSERT INTO "Tätorter" VALUES (4776, 'Dals Rostock', 1461, 829, 58.716670, 12.350000, 78); INSERT INTO "Tätorter" VALUES (4780, 'Dalsjöfors', 1490, 3362, 57.716670, 13.083330, 255); INSERT INTO "Tätorter" VALUES (4784, 'Dalstorp', 1452, 776, 57.616670, 13.500000, 208); INSERT INTO "Tätorter" VALUES (4788, 'Dalum', 1491, 638, 57.898520, 13.464600, 205); INSERT INTO "Tätorter" VALUES (4792, 'Dannike', 1490, 369, 57.683330, 13.216670, 221); INSERT INTO "Tätorter" VALUES (4796, 'Ed', 1438, 2932, 58.912500, 11.925340, 133); INSERT INTO "Tätorter" VALUES (4800, 'Fengersfors', 1492, 345, 58.983330, 12.466670, 81); INSERT INTO "Tätorter" VALUES (4804, 'Floda', 1441, 8021, 57.800000, 12.366670, 121); INSERT INTO "Tätorter" VALUES (4808, 'Fristad', 1490, 4924, 65.200000, 16.716670, 395); INSERT INTO "Tätorter" VALUES (4812, 'Fritsla', 1463, 2293, 57.550000, 12.783330, 124); INSERT INTO "Tätorter" VALUES (4816, 'Frufällan', 1490, 917, 57.783330, 12.966670, 161); INSERT INTO "Tätorter" VALUES (4820, 'Frändefors', 1487, 613, 58.500000, 12.283330, 65); INSERT INTO "Tätorter" VALUES (4828, 'Färgelanda', 1439, 1894, 58.568160, 11.992350, 99); INSERT INTO "Tätorter" VALUES (4832, 'Grimsås', 1452, 721, 57.483330, 13.533330, 211); INSERT INTO "Tätorter" VALUES (4836, 'Gråbo', 1441, 4195, 57.833330, 12.300000, 105); INSERT INTO "Tätorter" VALUES (4840, 'Gräfsnäs', 1489, 367, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4848, 'Gånghester', 1490, 1526, 57.700000, 13.016670, 207); INSERT INTO "Tätorter" VALUES (4852, 'Gällstad', 1491, 471, 57.666670, 13.433330, 219); INSERT INTO "Tätorter" VALUES (4856, 'Göta', 1462, 920, 58.116670, 12.150000, 65); INSERT INTO "Tätorter" VALUES (4860, 'Hedared', 1490, 353, 57.816670, 12.750000, 235); INSERT INTO "Tätorter" VALUES (4864, 'Herrljunga', 1466, 3822, 58.077390, 13.026620, 110); INSERT INTO "Tätorter" VALUES (4868, 'Hillared', 1465, 578, 57.633330, 13.150000, 177); INSERT INTO "Tätorter" VALUES (4870, 'Hjälmared', 1489, 260, 57.883330, 12.533330, 86); INSERT INTO "Tätorter" VALUES (4872, 'Hjärtum', 1462, 367, 58.183330, 12.100000, 50); INSERT INTO "Tätorter" VALUES (4876, 'Holsljunga', 1465, 255, 57.416670, 12.966670, 163); INSERT INTO "Tätorter" VALUES (4880, 'Horred', 1463, 1271, 57.350000, 12.466670, 20); INSERT INTO "Tätorter" VALUES (4884, 'Hultafors', 1443, 227, 57.700000, 12.733330, 208); INSERT INTO "Tätorter" VALUES (4888, 'Hulu', 1491, 266, 57.883330, 14.633330, 314); INSERT INTO "Tätorter" VALUES (4892, 'Hyssna', 1463, 638, 57.566670, 12.533330, 121); INSERT INTO "Tätorter" VALUES (4900, 'Högsäter', 1439, 705, 59.900000, 11.983330, 152); INSERT INTO "Tätorter" VALUES (4904, 'Hökerum', 1491, 695, 57.850000, 13.283330, 220); INSERT INTO "Tätorter" VALUES (4908, 'Ingared', 1489, 1299, 57.844890, 12.470600, 104); INSERT INTO "Tätorter" VALUES (4912, 'Kinna', 1463, 14776, 57.507280, 12.694630, 53); INSERT INTO "Tätorter" VALUES (4916, 'Kinnarumma', 1490, 253, 57.600000, 12.833330, 132); INSERT INTO "Tätorter" VALUES (4920, 'Lerum', 1441, 16855, 57.770510, 12.269040, 48); INSERT INTO "Tätorter" VALUES (4924, 'Lilla Edet', 1462, 4862, 58.133330, 12.133330, 42); INSERT INTO "Tätorter" VALUES (4928, 'Limmared', 1452, 1412, 57.533330, 13.350000, 184); INSERT INTO "Tätorter" VALUES (4932, 'Ljung', 1466, 734, 57.983330, 13.050000, 196); INSERT INTO "Tätorter" VALUES (4936, 'Ljungsarp', 1452, 203, 57.566670, 13.566670, 212); INSERT INTO "Tätorter" VALUES (4940, 'Länghem', 1452, 989, 57.600000, 13.233330, 175); INSERT INTO "Tätorter" VALUES (4944, 'Lödöse', 1462, 1266, 58.033330, 12.133330, 19); INSERT INTO "Tätorter" VALUES (4948, 'Marbäck', 1491, 474, 60.083330, 17.166670, 52); INSERT INTO "Tätorter" VALUES (4952, 'Mellerud', 1461, 3750, 58.699790, 12.453120, 56); INSERT INTO "Tätorter" VALUES (4956, 'Mjöbäck', 1465, 294, 57.316670, 12.866670, 162); INSERT INTO "Tätorter" VALUES (4960, 'Målsryd', 1490, 907, 57.683330, 13.050000, 242); INSERT INTO "Tätorter" VALUES (4968, 'Nitta', 1491, 354, 57.816670, 13.183330, 231); INSERT INTO "Tätorter" VALUES (4972, 'Norsesund', 1489, 274, 57.866670, 12.433330, 88); INSERT INTO "Tätorter" VALUES (4974, 'Nordkroken', 1487, 423, 58.383330, 12.400000, 73); INSERT INTO "Tätorter" VALUES (4976, 'Nödinge-Nol', 1440, 9822, 57.912590, 12.055910, 22); INSERT INTO "Tätorter" VALUES (4978, 'Nygård', 1462, 419, 65.066670, 20.400000, 218); INSERT INTO "Tätorter" VALUES (4984, 'Olsfors', 1443, 623, 57.700000, 12.700000, 195); INSERT INTO "Tätorter" VALUES (4986, 'Olstorp', 1441, 1281, 57.820000, 12.280000, 95); INSERT INTO "Tätorter" VALUES (4988, 'Rosenlund', 1452, 316, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (4992, 'Rydal', 1463, 402, 57.550000, 12.683330, 108); INSERT INTO "Tätorter" VALUES (4996, 'Rydboholm', 1490, 1023, 57.650000, 12.883330, 160); INSERT INTO "Tätorter" VALUES (5000, 'Rångedala', 1490, 392, 57.783330, 13.116670, 249); INSERT INTO "Tätorter" VALUES (5004, 'Rånnaväg', 1491, 336, 57.683330, 13.466670, 278); INSERT INTO "Tätorter" VALUES (5008, 'Sandared', 1490, 3160, 57.709920, 12.792380, 188); INSERT INTO "Tätorter" VALUES (5012, 'Sandhult', 1490, 608, 57.766670, 12.816670, 246); INSERT INTO "Tätorter" VALUES (5016, 'Sexdrega', 1465, 787, 57.583330, 13.116670, 158); INSERT INTO "Tätorter" VALUES (5020, 'Sjuntorp', 1488, 2124, 58.200000, 12.216670, 44); INSERT INTO "Tätorter" VALUES (5024, 'Sjömarken', 1490, 2829, 57.715330, 12.834950, 193); INSERT INTO "Tätorter" VALUES (5032, 'Sjövik', 1441, 905, 60.150000, 16.316670, 38); INSERT INTO "Tätorter" VALUES (5036, 'Skepplanda', 1440, 1803, 57.983330, 12.200000, 71); INSERT INTO "Tätorter" VALUES (5038, 'Velanda', 1488, 581, 59.200000, 15.066670, 40); INSERT INTO "Tätorter" VALUES (5040, 'Skåpafors', 1460, 313, 59.016670, 12.266670, 93); INSERT INTO "Tätorter" VALUES (5044, 'Sollebrunn', 1489, 1440, 58.116670, 12.533330, 82); INSERT INTO "Tätorter" VALUES (5048, 'Stigen', 1439, 428, 58.566670, 12.066670, 100); INSERT INTO "Tätorter" VALUES (5052, 'Stora Mellby', 1489, 321, 58.150000, 12.566670, 98); INSERT INTO "Tätorter" VALUES (5056, 'Surte', 1440, 5798, 57.816670, 12.016670, 116); INSERT INTO "Tätorter" VALUES (5060, 'Svenljunga', 1465, 3418, 57.495510, 13.110780, 158); INSERT INTO "Tätorter" VALUES (5064, 'Sätila', 1463, 1059, 57.541720, 12.434290, 103); INSERT INTO "Tätorter" VALUES (5068, 'Timmele', 1491, 847, 57.850000, 13.433330, 197); INSERT INTO "Tätorter" VALUES (5070, 'Aröd och Timmervik', 1415, 637, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (5072, 'Tollered', 1441, 900, 57.950000, 12.100000, 58); INSERT INTO "Tätorter" VALUES (5076, 'Torestorp', 1463, 419, 58.300000, 13.966670, 123); INSERT INTO "Tätorter" VALUES (5078, 'Tosseryd', 1490, 223, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (5080, 'Tranemo', 1452, 3168, 57.483330, 13.350000, 186); INSERT INTO "Tätorter" VALUES (5084, 'Trollhättan', 1488, 46457, 58.283650, 12.288640, 56); INSERT INTO "Tätorter" VALUES (5086, 'Trulsegården', 1480, 211, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (5088, 'Trädet', 1491, 277, 57.983330, 13.533330, 225); INSERT INTO "Tätorter" VALUES (5092, 'Töllsjö', 1443, 369, 57.800000, 12.633330, 138); INSERT INTO "Tätorter" VALUES (5096, 'Tösse', 1492, 305, 58.966670, 12.616670, 53); INSERT INTO "Tätorter" VALUES (5100, 'Uddebo', 1452, 258, 65.550000, 22.233330, 1); INSERT INTO "Tätorter" VALUES (5104, 'Ulricehamn', 1491, 9787, 57.791590, 13.414220, 253); INSERT INTO "Tätorter" VALUES (5106, 'Utby', 1485, 267, 63.233330, 18.633330, 4); INSERT INTO "Tätorter" VALUES (5108, 'Upphärad', 1488, 588, 58.166670, 12.283330, 82); INSERT INTO "Tätorter" VALUES (5112, 'Vargön', 1487, 4919, 58.355990, 12.390600, 59); INSERT INTO "Tätorter" VALUES (5116, 'Vegby', 1491, 549, 57.683330, 13.383330, 179); INSERT INTO "Tätorter" VALUES (5120, 'Viskafors', 1490, 3790, 57.633330, 12.833330, 150); INSERT INTO "Tätorter" VALUES (5124, 'Vårgårda', 1442, 5133, 58.037060, 12.809070, 118); INSERT INTO "Tätorter" VALUES (5128, 'Väne-Åsaka', 1488, 292, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (5132, 'Vänersborg', 1487, 21699, 58.380750, 12.323400, 60); INSERT INTO "Tätorter" VALUES (5136, 'Västra Bodarna', 1489, 1059, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (5140, 'Åmål', 1492, 9065, 59.051000, 12.704920, 41); INSERT INTO "Tätorter" VALUES (5144, 'Åsensbruk', 1461, 522, 58.799720, 12.416670, 64); INSERT INTO "Tätorter" VALUES (5152, 'Älvängen', 1440, 4196, 57.966670, 12.116670, 15); INSERT INTO "Tätorter" VALUES (5156, 'Äspered', 1490, 287, 57.783330, 13.016670, 285); INSERT INTO "Tätorter" VALUES (5160, 'Ödeborg', 1439, 598, 58.545060, 11.974580, 97); INSERT INTO "Tätorter" VALUES (5162, 'Östadkulle', 1442, 245, 58.016670, 12.633330, 110); INSERT INTO "Tätorter" VALUES (5164, 'Östra Frölunda', 1465, 309, 57.333330, 13.016670, 151); INSERT INTO "Tätorter" VALUES (5168, 'Överlida', 1465, 525, 57.350000, 12.883330, 201); INSERT INTO "Tätorter" VALUES (5172, 'Öxabäck', 1463, 300, 57.400000, 12.800000, 161); INSERT INTO "Tätorter" VALUES (5176, 'Öxeryd', 1441, 491, 57.733330, 12.266670, 130); INSERT INTO "Tätorter" VALUES (5200, 'Ardala', 1495, 725, 58.350000, 13.333330, 106); INSERT INTO "Tätorter" VALUES (5204, 'Arentorp', 1470, 472, 58.233330, 12.866670, 93); INSERT INTO "Tätorter" VALUES (5208, 'Axvall', 1495, 1186, 58.383330, 13.566670, 137); INSERT INTO "Tätorter" VALUES (5212, 'Blikstorp', 1497, 222, 58.266670, 14.050000, 117); INSERT INTO "Tätorter" VALUES (5216, 'Eggby', 1495, 231, 58.433330, 13.650000, 146); INSERT INTO "Tätorter" VALUES (5220, 'Ekedalen', 1498, 404, 58.200000, 13.833330, 186); INSERT INTO "Tätorter" VALUES (5224, 'Emtunga', 1470, 273, 58.250000, 13.000000, 86); INSERT INTO "Tätorter" VALUES (5228, 'Fagerhult', 643, 316, 58.816670, 11.600000, 121); INSERT INTO "Tätorter" VALUES (5232, 'Fagersanna', 1472, 539, 58.466670, 14.300000, 103); INSERT INTO "Tätorter" VALUES (5236, 'Falköping', 1499, 16350, 58.173470, 13.550680, 229); INSERT INTO "Tätorter" VALUES (5240, 'Filsbäck', 1494, 615, 58.583330, 13.116670, 50); INSERT INTO "Tätorter" VALUES (5244, 'Floby', 1499, 1499, 58.133330, 13.333330, 170); INSERT INTO "Tätorter" VALUES (5248, 'Forsvik', 1446, 342, 59.279170, 18.366670, 33); INSERT INTO "Tätorter" VALUES (5250, 'Främmestad', 1445, 393, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (5252, 'Furusjö', 643, 325, 57.933330, 13.950000, 260); INSERT INTO "Tätorter" VALUES (5260, 'Grästorp', 1444, 2969, 58.332190, 12.681220, 67); INSERT INTO "Tätorter" VALUES (5264, 'Gudhem', 1499, 427, 58.226700, 13.563650, 210); INSERT INTO "Tätorter" VALUES (5268, 'Gullspång', 1447, 1167, 58.986150, 14.096440, 48); INSERT INTO "Tätorter" VALUES (5280, 'Götene', 1471, 4933, 58.528240, 13.494580, 70); INSERT INTO "Tätorter" VALUES (5284, 'Habo', 643, 6883, 57.911850, 14.074440, 184); INSERT INTO "Tätorter" VALUES (5296, 'Hjo', 1497, 6094, 58.301330, 14.287840, 88); INSERT INTO "Tätorter" VALUES (5300, 'Hova', 1447, 1288, 58.866670, 14.183330, 89); INSERT INTO "Tätorter" VALUES (5304, 'Hällekis', 1471, 704, 58.616670, 13.433330, 79); INSERT INTO "Tätorter" VALUES (5308, 'Igelstorp', 1496, 677, 58.400000, 13.966670, 103); INSERT INTO "Tätorter" VALUES (5312, 'Jonslund', 1445, 293, 58.166670, 12.833330, 104); INSERT INTO "Tätorter" VALUES (5316, 'Jung', 1470, 408, 59.683330, 17.033330, 24); INSERT INTO "Tätorter" VALUES (5320, 'Järpås', 1494, 795, 58.383330, 12.966670, 77); INSERT INTO "Tätorter" VALUES (5324, 'Karlsborg', 1446, 3551, 58.537240, 14.504700, 88); INSERT INTO "Tätorter" VALUES (5328, 'Kinnarp', 1499, 917, 58.066670, 13.516670, 205); INSERT INTO "Tätorter" VALUES (5332, 'Korsberga', 1497, 214, 58.300000, 14.083330, 114); INSERT INTO "Tätorter" VALUES (5336, 'Kvänum', 1470, 1277, 58.300000, 13.183330, 82); INSERT INTO "Tätorter" VALUES (5340, 'Källby', 1471, 1586, 58.516670, 13.316670, 50); INSERT INTO "Tätorter" VALUES (5344, 'Kättilstorp', 1499, 253, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (5348, 'Lerdala', 1496, 409, 58.483330, 13.716670, 111); INSERT INTO "Tätorter" VALUES (5352, 'Lidköping', 1494, 25644, 58.505170, 13.157650, 45); INSERT INTO "Tätorter" VALUES (5356, 'Lugnås', 1493, 653, 58.650000, 13.700000, 46); INSERT INTO "Tätorter" VALUES (5360, 'Lundsbrunn', 1471, 887, 58.483330, 13.450000, 107); INSERT INTO "Tätorter" VALUES (5364, 'Lyrestad', 1493, 479, 58.800000, 14.066670, 58); INSERT INTO "Tätorter" VALUES (5368, 'Madängsholm', 1498, 425, 58.150000, 13.916670, 160); INSERT INTO "Tätorter" VALUES (5372, 'Mariestad', 1493, 15591, 58.709710, 13.823670, 46); INSERT INTO "Tätorter" VALUES (5376, 'Moholm', 1473, 640, 58.616670, 14.033330, 78); INSERT INTO "Tätorter" VALUES (5380, 'Mullsjö', 642, 5452, 57.917100, 13.878310, 286); INSERT INTO "Tätorter" VALUES (5384, 'Mölltorp', 1446, 1050, 58.500000, 14.400000, 94); INSERT INTO "Tätorter" VALUES (5388, 'Nossebro', 1445, 1846, 58.188080, 12.715990, 101); INSERT INTO "Tätorter" VALUES (5392, 'Odensberg', 1499, 287, 58.150000, 13.433330, 207); INSERT INTO "Tätorter" VALUES (5396, 'Otterbäcken', 1447, 722, 58.950000, 14.033330, 43); INSERT INTO "Tätorter" VALUES (5404, 'Saleby', 1494, 232, 58.383330, 13.133330, 64); INSERT INTO "Tätorter" VALUES (5408, 'Sandhem', 642, 702, 58.016670, 13.483330, 196); INSERT INTO "Tätorter" VALUES (5412, 'Sjötorp', 1493, 494, 59.483330, 14.250000, 108); INSERT INTO "Tätorter" VALUES (5416, 'Skagersvik', 1447, 250, 58.966670, 14.100000, 62); INSERT INTO "Tätorter" VALUES (5420, 'Skara', 1495, 10841, 58.386590, 13.438360, 118); INSERT INTO "Tätorter" VALUES (5424, 'Skultorp', 1496, 3642, 58.350000, 13.833330, 165); INSERT INTO "Tätorter" VALUES (5428, 'Skövde', 1496, 34466, 58.391180, 13.845060, 139); INSERT INTO "Tätorter" VALUES (5436, 'Stenstorp', 1499, 1668, 58.483330, 15.066670, 106); INSERT INTO "Tätorter" VALUES (5440, 'Stora Levene', 1470, 761, 58.333330, 12.916670, 87); INSERT INTO "Tätorter" VALUES (5444, 'Stöpen', 1496, 1401, 58.466670, 13.866670, 81); INSERT INTO "Tätorter" VALUES (5456, 'Tibro', 1472, 8018, 58.424530, 14.161620, 105); INSERT INTO "Tätorter" VALUES (5460, 'Tidaholm', 1498, 8027, 58.180350, 13.958240, 143); INSERT INTO "Tätorter" VALUES (5464, 'Tidan', 1496, 935, 58.574670, 14.004950, 63); INSERT INTO "Tätorter" VALUES (5468, 'Timmersdala', 1496, 875, 58.533330, 13.750000, 78); INSERT INTO "Tätorter" VALUES (5472, 'Torbjörntorp', 1499, 475, 58.210240, 13.605970, 196); INSERT INTO "Tätorter" VALUES (5476, 'Tråvad', 1470, 448, 58.250000, 13.083330, 85); INSERT INTO "Tätorter" VALUES (5480, 'Tun', 1494, 206, 58.433330, 12.733330, 59); INSERT INTO "Tätorter" VALUES (5484, 'Töreboda', 1473, 4189, 58.707390, 14.125970, 91); INSERT INTO "Tätorter" VALUES (5488, 'Ullervad', 1493, 935, 58.666670, 13.866670, 61); INSERT INTO "Tätorter" VALUES (5492, 'Ulvåker', 1496, 254, 58.483330, 13.916670, 80); INSERT INTO "Tätorter" VALUES (5496, 'Undenäs', 1446, 237, 58.650000, 14.416670, 167); INSERT INTO "Tätorter" VALUES (5500, 'Vara', 1470, 3889, 58.262340, 12.954130, 83); INSERT INTO "Tätorter" VALUES (5504, 'Varnhem', 1495, 707, 58.383330, 13.650000, 185); INSERT INTO "Tätorter" VALUES (5508, 'Vartofta', 1499, 540, 58.100000, 13.633330, 226); INSERT INTO "Tätorter" VALUES (5512, 'Vedum', 1470, 926, 58.166670, 12.983330, 117); INSERT INTO "Tätorter" VALUES (5516, 'Vinninga', 1494, 1078, 58.450000, 13.266670, 86); INSERT INTO "Tätorter" VALUES (5520, 'Väring', 1496, 571, 58.500000, 13.950000, 70); INSERT INTO "Tätorter" VALUES (5524, 'Värsås', 1496, 578, 58.350000, 14.050000, 122); INSERT INTO "Tätorter" VALUES (5532, 'Åsarp', 1499, 598, 58.033330, 13.566670, 221); INSERT INTO "Tätorter" VALUES (5536, 'Älgarås', 1473, 417, 58.800000, 14.233330, 104); INSERT INTO "Tätorter" VALUES (5596, 'Alster', 1780, 586, 59.398530, 13.613690, 49); INSERT INTO "Tätorter" VALUES (5600, 'Ambjörby', 1737, 227, 60.500000, 13.166670, 183); INSERT INTO "Tätorter" VALUES (5604, 'Arvika', 1784, 14244, 59.655280, 12.585180, 48); INSERT INTO "Tätorter" VALUES (5612, 'Björneborg', 1781, 1099, 59.250000, 14.250000, 113); INSERT INTO "Tätorter" VALUES (5616, 'Blombacka', 1780, 217, 59.716670, 13.750000, 250); INSERT INTO "Tätorter" VALUES (5624, 'Bäckhammar', 1781, 284, 59.166670, 14.183330, 56); INSERT INTO "Tätorter" VALUES (5628, 'Charlottenberg', 1730, 2215, 59.884220, 12.303980, 139); INSERT INTO "Tätorter" VALUES (5632, 'Deje', 1763, 2742, 59.600000, 13.466670, 100); INSERT INTO "Tätorter" VALUES (5634, 'Dyvelsten', 1763, 219, 59.500000, 13.433060, 50); INSERT INTO "Tätorter" VALUES (5636, 'Eda glasbruk', 1730, 233, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (5640, 'Edane', 1784, 706, 59.633330, 12.800000, 70); INSERT INTO "Tätorter" VALUES (5652, 'Edsvalla', 1780, 1016, 59.433330, 13.183330, 100); INSERT INTO "Tätorter" VALUES (5656, 'Fagerås', 1715, 427, 59.533330, 13.200000, 77); INSERT INTO "Tätorter" VALUES (5660, 'Filipstad', 1782, 6022, 59.712360, 14.168310, 130); INSERT INTO "Tätorter" VALUES (5664, 'Forshaga', 1763, 6229, 59.525410, 13.481270, 56); INSERT INTO "Tätorter" VALUES (5668, 'Geijersholm', 1783, 222, 60.083330, 13.716670, 182); INSERT INTO "Tätorter" VALUES (5676, 'Grums', 1764, 5025, 59.346600, 13.109060, 48); INSERT INTO "Tätorter" VALUES (5680, 'Gunnarskog', 1784, 290, 59.833330, 12.550000, 90); INSERT INTO "Tätorter" VALUES (5688, 'Hagfors', 1783, 5146, 60.023780, 13.672140, 150); INSERT INTO "Tätorter" VALUES (5700, 'Jössefors', 1784, 732, 59.683330, 12.466670, 75); INSERT INTO "Tätorter" VALUES (5704, 'Karlstad', 1780, 61685, 59.379300, 13.503570, 49); INSERT INTO "Tätorter" VALUES (5708, 'Kil', 1715, 7842, 59.507220, 13.313950, 97); INSERT INTO "Tätorter" VALUES (5712, 'Klässbol', 1784, 293, 59.533330, 12.733330, 75); INSERT INTO "Tätorter" VALUES (5716, 'Koppom', 1730, 643, 59.716670, 12.150000, 106); INSERT INTO "Tätorter" VALUES (5720, 'Kristinehamn', 1781, 17839, 59.309780, 14.108080, 43); INSERT INTO "Tätorter" VALUES (5722, 'Kyrksten', 1760, 258, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (5724, 'Ekshärad', 1783, 1074, 60.172750, 13.496470, 150); INSERT INTO "Tätorter" VALUES (5730, 'Högboda', 1715, 262, 59.566670, 13.016670, 82); INSERT INTO "Tätorter" VALUES (5732, 'Lesjöfors', 1782, 1062, 59.983330, 14.183330, 245); INSERT INTO "Tätorter" VALUES (5744, 'Lysvik', 1766, 341, 60.016670, 13.133330, 75); INSERT INTO "Tätorter" VALUES (5752, 'Mjönäs', 1783, 217, 60.350000, 13.333330, 150); INSERT INTO "Tätorter" VALUES (5756, 'Molkom', 1780, 1863, 59.600000, 13.700000, 66); INSERT INTO "Tätorter" VALUES (5760, 'Munkfors', 1762, 3054, 59.838560, 13.543610, 103); INSERT INTO "Tätorter" VALUES (5764, 'Nordmark', 1782, 225, 59.833330, 14.100000, 174); INSERT INTO "Tätorter" VALUES (5772, 'Nykroppa', 1782, 846, 59.650000, 14.300000, 169); INSERT INTO "Tätorter" VALUES (5780, 'Oleby', 1737, 353, 60.133770, 13.038070, 97); INSERT INTO "Tätorter" VALUES (5784, 'Persberg', 1782, 313, 59.750000, 14.250000, 197); INSERT INTO "Tätorter" VALUES (5788, 'Rottneros', 1766, 448, 59.800000, 13.116670, 75); INSERT INTO "Tätorter" VALUES (5792, 'Råda', 1783, 448, 60.150000, 13.416670, 140); INSERT INTO "Tätorter" VALUES (5796, 'Segmon', 1764, 437, 59.283330, 13.016670, 69); INSERT INTO "Tätorter" VALUES (5800, 'Skattkärr', 1780, 2135, 59.416670, 13.633330, 85); INSERT INTO "Tätorter" VALUES (5804, 'Skoghall', 1761, 13265, 59.323240, 13.465520, 50); INSERT INTO "Tätorter" VALUES (5808, 'Skåre', 1780, 5402, 55.383330, 13.050000, 7); INSERT INTO "Tätorter" VALUES (5810, 'Slottsbron', 1764, 1039, 59.333330, 13.100000, 41); INSERT INTO "Tätorter" VALUES (5812, 'Storfors', 1760, 2337, 59.531830, 14.272010, 123); INSERT INTO "Tätorter" VALUES (5816, 'Stöllet', 1737, 245, 60.433330, 13.266670, 264); INSERT INTO "Tätorter" VALUES (5820, 'Sulvik', 1784, 312, 59.683330, 12.400000, 75); INSERT INTO "Tätorter" VALUES (5824, 'Sunne', 1766, 4931, 59.837640, 13.143020, 73); INSERT INTO "Tätorter" VALUES (5828, 'Sunnemo', 1783, 241, 59.883330, 13.716670, 154); INSERT INTO "Tätorter" VALUES (5832, 'Svanskog', 1785, 510, 59.183330, 12.550000, 93); INSERT INTO "Tätorter" VALUES (5836, 'Sysslebäck', 1737, 527, 60.750000, 12.866670, 363); INSERT INTO "Tätorter" VALUES (5840, 'Säffle', 1785, 8991, 59.132290, 12.928880, 58); INSERT INTO "Tätorter" VALUES (5844, 'Torsby', 1737, 4049, 60.135270, 13.008200, 100); INSERT INTO "Tätorter" VALUES (5848, 'Töcksfors', 1765, 1158, 59.508160, 11.844310, 114); INSERT INTO "Tätorter" VALUES (5852, 'Uddeholm', 1783, 667, 60.016670, 13.616670, 129); INSERT INTO "Tätorter" VALUES (5856, 'Uddheden', 1766, 258, 59.950000, 12.900000, 110); INSERT INTO "Tätorter" VALUES (5860, 'Vallargärdet', 1780, 382, 59.466670, 13.550000, 72); INSERT INTO "Tätorter" VALUES (5862, 'Vidöåsen', 1761, 272, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (5864, 'Vålberg', 1780, 2770, 59.400000, 13.166670, 88); INSERT INTO "Tätorter" VALUES (5868, 'Värmlandsbro', 1785, 501, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (5872, 'Väse', 1780, 494, 59.383330, 13.833330, 61); INSERT INTO "Tätorter" VALUES (5876, 'Västra Ämtervik', 1766, 366, 59.733330, 13.133330, 104); INSERT INTO "Tätorter" VALUES (5880, 'Åmotfors', 1730, 1410, 59.766670, 12.366670, 82); INSERT INTO "Tätorter" VALUES (5884, 'Årjäng', 1765, 3228, 59.392170, 12.133360, 150); INSERT INTO "Tätorter" VALUES (5888, 'Ölme', 1781, 224, 59.366670, 14.000000, 47); INSERT INTO "Tätorter" VALUES (5890, 'Örslösa', 1494, 307, 58.500000, 13.000000, 69); INSERT INTO "Tätorter" VALUES (5892, 'Östmark', 1737, 216, 60.283330, 12.750000, 100); INSERT INTO "Tätorter" VALUES (5900, 'Askersby', 1880, 243, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (5904, 'Askersund', 1882, 3887, 58.879880, 14.902300, 88); INSERT INTO "Tätorter" VALUES (5916, 'Degerfors', 1862, 7160, 59.237970, 14.430770, 99); INSERT INTO "Tätorter" VALUES (5920, 'Ekeby', 1881, 372, 59.163500, 15.268550, NULL); INSERT INTO "Tätorter" VALUES (5924, 'Ekeby-Almby', 1880, 1271, 59.260000, 15.330000, 25); INSERT INTO "Tätorter" VALUES (5928, 'Fellingsbro', 1885, 1384, 59.433330, 15.583330, 21); INSERT INTO "Tätorter" VALUES (5932, 'Finnerödja', 1860, 604, 58.933330, 14.433330, 96); INSERT INTO "Tätorter" VALUES (5936, 'Fjugesta', 1814, 2033, 59.173750, 14.872270, 40); INSERT INTO "Tätorter" VALUES (5940, 'Frövi', 1885, 2516, 59.466670, 15.366670, 41); INSERT INTO "Tätorter" VALUES (5944, 'Garphyttan', 1880, 1619, 59.304290, 14.946230, 97); INSERT INTO "Tätorter" VALUES (5948, 'Glanshammar', 1880, 727, 59.316670, 15.400000, 23); INSERT INTO "Tätorter" VALUES (5952, 'Grythyttan', 1863, 891, 59.700000, 14.533330, 160); INSERT INTO "Tätorter" VALUES (5956, 'Gusselby', 1885, 300, 59.650000, 15.216670, 81); INSERT INTO "Tätorter" VALUES (5960, 'Gyttorp', 1884, 661, 59.516670, 14.966670, 88); INSERT INTO "Tätorter" VALUES (5964, 'Hallsberg', 1861, 7122, 59.065700, 15.111740, 49); INSERT INTO "Tätorter" VALUES (5968, 'Hammar', 1882, 282, 63.183330, 16.900000, 172); INSERT INTO "Tätorter" VALUES (5974, 'Hampetorp', 1880, 297, 59.150000, 15.666670, 7); INSERT INTO "Tätorter" VALUES (5980, 'Hasselfors', 1860, 428, 59.083330, 14.650000, 67); INSERT INTO "Tätorter" VALUES (5984, 'Hjortkvarn', 1861, 238, 58.900000, 15.433330, 80); INSERT INTO "Tätorter" VALUES (5988, 'Hovsta', 1880, 2785, 59.350000, 15.216670, 39); INSERT INTO "Tätorter" VALUES (5992, 'Hällabrottet', 1881, 1789, 59.116670, 15.200000, 61); INSERT INTO "Tätorter" VALUES (5996, 'Hällefors', 1863, 4530, 59.783880, 14.521970, 202); INSERT INTO "Tätorter" VALUES (6008, 'Karlskoga', 1883, 27084, 59.326670, 14.523860, 106); INSERT INTO "Tätorter" VALUES (6012, 'Kilsmo', 1880, 263, 59.066670, 15.516670, 75); INSERT INTO "Tätorter" VALUES (6016, 'Kopparberg', 1864, 3016, 59.875970, 14.994360, 160); INSERT INTO "Tätorter" VALUES (6020, 'Kumla', 1881, 14062, 59.127700, 15.143410, 40); INSERT INTO "Tätorter" VALUES (6028, 'Lanna', 1814, 537, 59.233330, 14.916670, 32); INSERT INTO "Tätorter" VALUES (6032, 'Latorpsbruk', 1880, 597, 59.283330, 14.983330, 73); INSERT INTO "Tätorter" VALUES (6036, 'Laxå', 1860, 3064, 58.986300, 14.619040, 85); INSERT INTO "Tätorter" VALUES (6040, 'Lindesberg', 1885, 9149, 59.592020, 15.230400, 88); INSERT INTO "Tätorter" VALUES (6056, 'Mullhyttan', 1814, 503, 59.150000, 14.683330, 79); INSERT INTO "Tätorter" VALUES (6060, 'Nora', 1884, 6526, 59.519260, 15.039790, 65); INSERT INTO "Tätorter" VALUES (6064, 'Norra Bro', 1880, 687, 59.216670, 15.250000, 31); INSERT INTO "Tätorter" VALUES (6076, 'Odensbacken', 1880, 1374, 59.166670, 15.533330, 18); INSERT INTO "Tätorter" VALUES (6080, 'Olshammar', 1882, 271, 58.750000, 14.800000, 92); INSERT INTO "Tätorter" VALUES (6088, 'Pålsboda', 1861, 1552, 59.066670, 15.333330, 89); INSERT INTO "Tätorter" VALUES (6092, 'Ramsberg', 1885, 257, 59.766670, 15.283330, 140); INSERT INTO "Tätorter" VALUES (6096, 'Rockhammar', 1885, 270, 59.533330, 15.433330, 65); INSERT INTO "Tätorter" VALUES (6100, 'Röfors', 1860, 207, 58.950000, 14.616670, 125); INSERT INTO "Tätorter" VALUES (6104, 'Rönneshytta', 1882, 283, 58.933330, 15.033330, 110); INSERT INTO "Tätorter" VALUES (6108, 'Sannahed', 1881, 417, 59.100000, 15.150000, 51); INSERT INTO "Tätorter" VALUES (6112, 'Sköllersta', 1861, 1131, 59.150000, 15.333330, 58); INSERT INTO "Tätorter" VALUES (6116, 'Stora Mellösa', 1880, 776, 59.216670, 15.500000, 32); INSERT INTO "Tätorter" VALUES (6120, 'Storå', 1885, 1933, 59.716670, 15.133330, 53); INSERT INTO "Tätorter" VALUES (6124, 'Striberg', 1884, 317, 59.533330, 14.933330, 173); INSERT INTO "Tätorter" VALUES (6128, 'Stråssa', 1885, 306, 59.750000, 15.216670, 256); INSERT INTO "Tätorter" VALUES (6136, 'Ställdalen', 1864, 539, 59.933330, 14.933330, 194); INSERT INTO "Tätorter" VALUES (6140, 'Svartå', 1862, 495, 65.033330, 20.766670, 184); INSERT INTO "Tätorter" VALUES (6148, 'Vedevåg', 1885, 656, 59.533330, 15.283330, 52); INSERT INTO "Tätorter" VALUES (6152, 'Vintrosa', 1880, 1343, 59.250000, 14.950000, 35); INSERT INTO "Tätorter" VALUES (6156, 'Vretstorp', 1861, 842, 59.033330, 14.866670, 61); INSERT INTO "Tätorter" VALUES (6160, 'Zinkgruvan', 1882, 391, 58.816670, 15.083330, 191); INSERT INTO "Tätorter" VALUES (6164, 'Åbytorp', 1881, 755, 59.116670, 15.066670, 60); INSERT INTO "Tätorter" VALUES (6168, 'Åmmeberg', 1882, 590, 58.866670, 15.000000, 88); INSERT INTO "Tätorter" VALUES (6172, 'Åsbro', 1882, 1164, 59.000000, 15.050000, 112); INSERT INTO "Tätorter" VALUES (6176, 'Ås', 1884, 499, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (6178, 'Åtorp', 1862, 212, 59.783330, 13.416670, 113); INSERT INTO "Tätorter" VALUES (6184, 'Ölmbrotorp', 1880, 548, 59.383060, 15.233060, 40); INSERT INTO "Tätorter" VALUES (6188, 'Örebro', 1880, 107038, 59.274120, 15.206600, 30); INSERT INTO "Tätorter" VALUES (6192, 'Östansjö', 1861, 868, 66.083330, 17.516670, 423); INSERT INTO "Tätorter" VALUES (6200, 'Arboga', 1984, 10330, 59.393870, 15.838820, 5); INSERT INTO "Tätorter" VALUES (6204, 'Barkarö', 1980, 1163, 59.550000, 16.533330, 17); INSERT INTO "Tätorter" VALUES (6208, 'Dingtuna', 1980, 1005, 59.566670, 16.366670, 21); INSERT INTO "Tätorter" VALUES (6210, 'Enhagen-Ekbacken', 1980, 1012, 59.550000, 16.533330, 17); INSERT INTO "Tätorter" VALUES (6212, 'Fagersta', 1982, 11130, 60.004180, 15.793160, 110); INSERT INTO "Tätorter" VALUES (6220, 'Götlunda', 1984, 270, 58.550000, 13.983330, 63); INSERT INTO "Tätorter" VALUES (6224, 'Hallstahammar', 1961, 10478, 59.613950, 16.228460, 30); INSERT INTO "Tätorter" VALUES (6228, 'Harbo', 331, 721, 60.100000, 17.200000, 25); INSERT INTO "Tätorter" VALUES (6232, 'Heby', 331, 2550, 59.938150, 16.862170, 53); INSERT INTO "Tätorter" VALUES (6236, 'Hökåsen', 1980, 2956, 59.666670, 16.583330, 46); INSERT INTO "Tätorter" VALUES (6244, 'Kolbäck', 1961, 1951, 59.566670, 16.250000, 20); INSERT INTO "Tätorter" VALUES (6248, 'Kolsva', 1983, 2453, 59.600000, 15.833330, 29); INSERT INTO "Tätorter" VALUES (6252, 'Kumla kyrkby', 1981, 206, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (6256, 'Kungsör', 1960, 5452, 59.422450, 16.096560, 30); INSERT INTO "Tätorter" VALUES (6266, 'Kärsta och Bredsdal', 1980, 261, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (6268, 'Köping', 1983, 17743, 59.514040, 15.992550, 22); INSERT INTO "Tätorter" VALUES (6272, 'Medåker', 1984, 224, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (6276, 'Morgongåva', 331, 1409, 59.933330, 16.950000, 65); INSERT INTO "Tätorter" VALUES (6278, 'Munga', 1980, 212, 59.740000, 16.530000, 51); INSERT INTO "Tätorter" VALUES (6280, 'Munktorp', 1983, 455, 59.533330, 16.133330, 13); INSERT INTO "Tätorter" VALUES (6284, 'Möklinta', 1981, 358, 60.083330, 16.533330, 49); INSERT INTO "Tätorter" VALUES (6292, 'Norberg', 1962, 4518, 60.065050, 15.923660, 124); INSERT INTO "Tätorter" VALUES (6296, 'Ramnäs', 1907, 1465, 59.766670, 16.200000, 80); INSERT INTO "Tätorter" VALUES (6300, 'Ransta', 1981, 881, 59.800000, 16.633330, 48); INSERT INTO "Tätorter" VALUES (6304, 'Riddarhyttan', 1904, 431, 59.800000, 15.550000, 135); INSERT INTO "Tätorter" VALUES (6308, 'Runhällen', 331, 217, 60.033330, 16.816670, 65); INSERT INTO "Tätorter" VALUES (6312, 'Sala', 1981, 12289, 59.919930, 16.606550, 43); INSERT INTO "Tätorter" VALUES (6316, 'Salbohed', 1981, 259, 59.916670, 16.316670, 56); INSERT INTO "Tätorter" VALUES (6320, 'Skinnskatteberg', 1904, 2287, 59.830280, 15.693370, 128); INSERT INTO "Tätorter" VALUES (6324, 'Skultuna', 1980, 3133, 59.716670, 16.416670, 40); INSERT INTO "Tätorter" VALUES (6328, 'Strömsholm', 1961, 664, 65.650000, 18.100000, 405); INSERT INTO "Tätorter" VALUES (6332, 'Surahammar', 1907, 6179, 59.707250, 16.221880, 68); INSERT INTO "Tätorter" VALUES (6336, 'Sätra brunn', 1981, 335, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (6340, 'Sörstafors', 1961, 278, 59.583330, 16.216670, 22); INSERT INTO "Tätorter" VALUES (6342, 'Tidö-Lindö', 1980, 637, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (6344, 'Tillberga', 1980, 2180, 59.683330, 16.616670, 37); INSERT INTO "Tätorter" VALUES (6348, 'Tortuna', 1980, 459, 59.683330, 16.716670, 38); INSERT INTO "Tätorter" VALUES (6352, 'Tärnsjö', 331, 1221, 60.150000, 16.933330, 53); INSERT INTO "Tätorter" VALUES (6356, 'Irsta', 1980, 2717, 59.700000, 16.933330, 24); INSERT INTO "Tätorter" VALUES (6360, 'Valskog', 1960, 694, 59.450000, 15.950000, 11); INSERT INTO "Tätorter" VALUES (6364, 'Virsbo', 1907, 1517, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (6368, 'Vittinge', 331, 460, 59.900000, 17.066670, 75); INSERT INTO "Tätorter" VALUES (6372, 'Västerfärnebo', 1981, 477, 59.950000, 16.283330, 61); INSERT INTO "Tätorter" VALUES (6376, 'Västerås', 1980, 110877, 59.616170, 16.552760, 17); INSERT INTO "Tätorter" VALUES (6382, 'Örtagården', 1980, 460, 59.562800, 16.468440, 13); INSERT INTO "Tätorter" VALUES (6384, 'Östervåla', 331, 1595, 60.183330, 17.183330, 34); INSERT INTO "Tätorter" VALUES (6402, 'Alvik', 2029, 227, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (6404, 'Avesta', 2084, 14506, 60.145450, 16.167850, 90); INSERT INTO "Tätorter" VALUES (6412, 'Bengtsheden', 2080, 530, 60.700000, 15.866670, 108); INSERT INTO "Tätorter" VALUES (6424, 'Bjursås', 2080, 1839, 60.733330, 15.433330, 181); INSERT INTO "Tätorter" VALUES (6428, 'Björbo', 2026, 697, 60.450000, 14.700000, 275); INSERT INTO "Tätorter" VALUES (6432, 'Blötberget', 2085, 428, 60.116670, 15.066670, 161); INSERT INTO "Tätorter" VALUES (6436, 'Boda', 2031, 541, 60.250000, 18.383330, 16); INSERT INTO "Tätorter" VALUES (6440, 'Bonäs', 2062, 457, 61.083330, 14.483330, 186); INSERT INTO "Tätorter" VALUES (6444, 'Borlänge', 2081, 41734, 60.485800, 15.437140, 124); INSERT INTO "Tätorter" VALUES (6448, 'Brunnsberg', 2039, 222, 61.283330, 13.916670, 250); INSERT INTO "Tätorter" VALUES (6456, 'Bäsna', 2026, 649, 60.533330, 15.200000, 213); INSERT INTO "Tätorter" VALUES (6460, 'Floda', 2026, 680, 60.500000, 14.766670, 203); INSERT INTO "Tätorter" VALUES (6464, 'Husby', 2083, 256, 60.379930, 16.000900, 74); INSERT INTO "Tätorter" VALUES (6468, 'Järna', 2021, 1413, 60.533330, 14.366670, 234); INSERT INTO "Tätorter" VALUES (6472, 'Danholn', 2080, 440, 60.616670, 15.766670, 114); INSERT INTO "Tätorter" VALUES (6476, 'Djura', 2029, 364, 60.616670, 15.000000, 182); INSERT INTO "Tätorter" VALUES (6480, 'Djurmo', 2026, 711, 60.550000, 15.166670, 165); INSERT INTO "Tätorter" VALUES (6484, 'Djurås', 2026, 1278, 60.550000, 15.133330, 139); INSERT INTO "Tätorter" VALUES (6492, 'Naglarby och Enbacka', 2082, 961, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (6496, 'Enviken', 2080, 609, 60.800000, 15.783330, 137); INSERT INTO "Tätorter" VALUES (6500, 'Evertsberg', 2039, 267, 61.133330, 13.950000, 442); INSERT INTO "Tätorter" VALUES (6504, 'Falun', 2080, 37291, 60.603570, 15.625970, 97); INSERT INTO "Tätorter" VALUES (6508, 'Fors', 2084, 827, 63.416670, 18.583330, 140); INSERT INTO "Tätorter" VALUES (6512, 'Fredriksberg', 2085, 655, 60.133330, 14.383330, 350); INSERT INTO "Tätorter" VALUES (6516, 'Furudal', 2031, 407, 61.166670, 15.133330, 198); INSERT INTO "Tätorter" VALUES (6524, 'Färnäs', 2062, 988, 61.000000, 14.633330, 200); INSERT INTO "Tätorter" VALUES (6528, 'Gagnef', 2026, 1049, 60.598560, 15.077450, 172); INSERT INTO "Tätorter" VALUES (6532, 'Garpenberg', 2083, 518, 60.316670, 16.200000, 130); INSERT INTO "Tätorter" VALUES (6540, 'Gesunda', 2062, 229, 60.900000, 14.533330, 175); INSERT INTO "Tätorter" VALUES (6544, 'Gonäs', 2085, 357, 60.150000, 15.100000, 156); INSERT INTO "Tätorter" VALUES (6548, 'Grangärde', 2085, 351, 60.266670, 14.983330, 166); INSERT INTO "Tätorter" VALUES (6552, 'Grycksbo', 2080, 1825, 60.683330, 15.466670, 131); INSERT INTO "Tätorter" VALUES (6556, 'Grängesberg', 2085, 3481, 60.083330, 14.983330, 310); INSERT INTO "Tätorter" VALUES (6558, 'Gubbo', 2061, 215, 60.216670, 18.000000, 46); INSERT INTO "Tätorter" VALUES (6560, 'Gulleråsen', 2031, 333, 61.066670, 15.183330, 260); INSERT INTO "Tätorter" VALUES (6566, 'Hagge', 2061, 342, 60.116670, 15.266670, 148); INSERT INTO "Tätorter" VALUES (6568, 'Halvarsgårdarna', 2081, 325, 60.400000, 15.383330, 161); INSERT INTO "Tätorter" VALUES (6572, 'Hedemora', 2083, 7273, 60.279730, 15.988550, 101); INSERT INTO "Tätorter" VALUES (6576, 'Horndal', 2084, 1114, 60.300000, 16.416670, 120); INSERT INTO "Tätorter" VALUES (6580, 'Håksberg', 2085, 458, 60.183330, 15.200000, 120); INSERT INTO "Tätorter" VALUES (6584, 'Häradsbygden', 2029, 643, 60.700000, 15.033330, 195); INSERT INTO "Tätorter" VALUES (6588, 'Idkerberget', 2081, 290, 60.383330, 15.233330, 277); INSERT INTO "Tätorter" VALUES (6592, 'Idre', 2039, 794, 61.858210, 12.714010, 445); INSERT INTO "Tätorter" VALUES (6596, 'Insjön', 2029, 2149, 64.400000, 17.483330, 422); INSERT INTO "Tätorter" VALUES (6608, 'Leksand', 2029, 5934, 60.732900, 15.001830, 153); INSERT INTO "Tätorter" VALUES (6612, 'Lima', 2023, 398, 60.933330, 13.350000, 350); INSERT INTO "Tätorter" VALUES (6616, 'Limedsforsen', 2023, 441, 60.900000, 13.383330, 350); INSERT INTO "Tätorter" VALUES (6620, 'Linghed', 2080, 618, 60.783330, 15.850000, 150); INSERT INTO "Tätorter" VALUES (6624, 'Ludvika', 2085, 14498, 60.149590, 15.187760, 143); INSERT INTO "Tätorter" VALUES (6632, 'Långshyttan', 2083, 1671, 60.450000, 16.016670, 90); INSERT INTO "Tätorter" VALUES (6636, 'Malung', 2023, 5126, 60.683290, 13.715420, 300); INSERT INTO "Tätorter" VALUES (6640, 'Malungsfors', 2023, 560, 60.733330, 13.550000, 302); INSERT INTO "Tätorter" VALUES (6644, 'Mockfjärd', 2026, 1937, 60.500000, 14.966670, 177); INSERT INTO "Tätorter" VALUES (6648, 'Mora', 2062, 10896, 61.007040, 14.543160, 162); INSERT INTO "Tätorter" VALUES (6652, 'Mora', 2082, 817, 60.400000, 15.600000, 157); INSERT INTO "Tätorter" VALUES (6660, 'Nedre Gärdsjö', 2031, 225, 60.933330, 15.216670, 209); INSERT INTO "Tätorter" VALUES (6664, 'Nordanö', 2084, 435, 62.733330, 18.116670, 39); INSERT INTO "Tätorter" VALUES (6666, 'Norr Amsberg', 2081, 236, 60.533330, 15.350000, 143); INSERT INTO "Tätorter" VALUES (6672, 'Nusnäs', 2062, 729, 60.966670, 14.633330, 176); INSERT INTO "Tätorter" VALUES (6676, 'Nyhammar', 2085, 654, 60.283330, 14.966670, 174); INSERT INTO "Tätorter" VALUES (6680, 'Nås', 2021, 417, 60.450000, 14.483330, 232); INSERT INTO "Tätorter" VALUES (6684, 'Näs bruk', 2084, 207, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (6692, 'Ornäs', 2081, 1068, 60.516670, 15.533330, 115); INSERT INTO "Tätorter" VALUES (6696, 'Orsa', 2034, 5308, 61.120340, 14.615500, 169); INSERT INTO "Tätorter" VALUES (6704, 'Repbäcken', 2081, 220, 60.516670, 15.333330, 152); INSERT INTO "Tätorter" VALUES (6708, 'Rot', 2039, 695, 61.250000, 14.033330, 263); INSERT INTO "Tätorter" VALUES (6716, 'Rättvik', 2031, 4686, 60.886320, 15.117870, 174); INSERT INTO "Tätorter" VALUES (6720, 'Saxdalen', 2085, 604, 60.133330, 14.966670, 350); INSERT INTO "Tätorter" VALUES (6724, 'Selja', 2062, 548, 61.016670, 14.466670, 172); INSERT INTO "Tätorter" VALUES (6728, 'Sifferbo', 2026, 414, 60.566670, 15.216670, 249); INSERT INTO "Tätorter" VALUES (6732, 'Siljansnäs', 2029, 1268, 60.783330, 14.850000, 221); INSERT INTO "Tätorter" VALUES (6736, 'Skattungbyn', 2034, 295, 61.200000, 14.866670, 225); INSERT INTO "Tätorter" VALUES (6744, 'Smedjebacken', 2061, 5100, 60.141810, 15.414160, 105); INSERT INTO "Tätorter" VALUES (6748, 'Sollerön', 2062, 901, 60.916670, 14.616670, 193); INSERT INTO "Tätorter" VALUES (6752, 'Solvarbo', 2082, 321, 60.400000, 15.666670, 137); INSERT INTO "Tätorter" VALUES (6764, 'Skedvi kyrkby', 2082, 208, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (6768, 'Sundborn', 2080, 762, 60.650000, 15.766670, 107); INSERT INTO "Tätorter" VALUES (6772, 'Sunnansjö', 2085, 560, 64.100000, 19.350000, 204); INSERT INTO "Tätorter" VALUES (6776, 'Svärdsjö', 2080, 1251, 60.750000, 15.916670, 121); INSERT INTO "Tätorter" VALUES (6780, 'Sågmyra', 2080, 546, 60.716670, 15.283330, 213); INSERT INTO "Tätorter" VALUES (6784, 'Sälen', 2023, 652, 61.150000, 13.266670, 367); INSERT INTO "Tätorter" VALUES (6788, 'Särna', 2039, 719, 61.692840, 13.142570, 424); INSERT INTO "Tätorter" VALUES (6792, 'Säter', 2082, 4429, 60.347780, 15.750510, 151); INSERT INTO "Tätorter" VALUES (6796, 'Söderbärke', 2061, 924, 60.073880, 15.564280, 79); INSERT INTO "Tätorter" VALUES (6804, 'Sörvik', 2085, 743, 64.133330, 15.716670, 368); INSERT INTO "Tätorter" VALUES (6806, 'Torsång', 2081, 666, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (6808, 'Transtrand', 2023, 386, 61.083330, 13.316670, 369); INSERT INTO "Tätorter" VALUES (6814, 'Toftbyn', 2080, 243, 60.716670, 15.783330, 128); INSERT INTO "Tätorter" VALUES (6816, 'Tällberg', 2029, 606, 64.983330, 20.800000, 162); INSERT INTO "Tätorter" VALUES (6820, 'Vad', 2061, 308, 61.366670, 16.933330, 24); INSERT INTO "Tätorter" VALUES (6828, 'Vansbro', 2021, 2026, 60.508930, 14.224580, 250); INSERT INTO "Tätorter" VALUES (6832, 'Vattnäs', 2062, 294, 61.050000, 14.600000, 213); INSERT INTO "Tätorter" VALUES (6836, 'Venjan', 2062, 295, 60.950000, 13.916670, 275); INSERT INTO "Tätorter" VALUES (6840, 'Vika', 2080, 445, 60.950000, 14.450000, 187); INSERT INTO "Tätorter" VALUES (6848, 'Vikarbyn', 2031, 1171, 60.916670, 15.016670, 215); INSERT INTO "Tätorter" VALUES (6852, 'Vikmanshyttan', 2083, 843, 60.283330, 15.816670, 125); INSERT INTO "Tätorter" VALUES (6860, 'Vinäs', 2062, 329, 60.966670, 14.533330, 176); INSERT INTO "Tätorter" VALUES (6864, 'Våmhus', 2062, 857, 61.133330, 14.466670, 173); INSERT INTO "Tätorter" VALUES (6872, 'Västanvik', 2029, 385, 60.733330, 14.950000, 162); INSERT INTO "Tätorter" VALUES (6880, 'Västerby', 2083, 368, 63.316670, 18.316670, 162); INSERT INTO "Tätorter" VALUES (6884, 'Västermyckeläng', 2039, 279, 61.200000, 14.033330, 300); INSERT INTO "Tätorter" VALUES (6892, 'Åsen', 2039, 246, 64.600000, 20.000000, 240); INSERT INTO "Tätorter" VALUES (6896, 'Älvdalen', 2039, 1810, 61.227740, 14.039350, 253); INSERT INTO "Tätorter" VALUES (6900, 'Äppelbo', 2021, 258, 60.483330, 14.000000, 273); INSERT INTO "Tätorter" VALUES (6912, 'Östnor', 2062, 534, 61.033330, 14.483330, 171); INSERT INTO "Tätorter" VALUES (6920, 'Persbo', 2085, 344, 60.200000, 17.433330, 31); INSERT INTO "Tätorter" VALUES (7000, 'Alfta', 2121, 2155, 61.346750, 16.074990, 94); INSERT INTO "Tätorter" VALUES (7004, 'Arbrå', 2183, 2215, 61.466670, 16.383330, 107); INSERT INTO "Tätorter" VALUES (7012, 'Backberg', 2181, 244, 60.616670, 16.616670, 73); INSERT INTO "Tätorter" VALUES (7014, 'Berg', 2180, 213, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (7016, 'Bergby', 2180, 816, 60.950000, 17.033330, 18); INSERT INTO "Tätorter" VALUES (7020, 'Bergsjö', 2132, 1266, 61.982530, 17.063680, 27); INSERT INTO "Tätorter" VALUES (7024, 'Bergvik', 2182, 834, 61.266670, 16.850000, 42); INSERT INTO "Tätorter" VALUES (7028, 'Björke', 2180, 349, 60.766670, 17.200000, 17); INSERT INTO "Tätorter" VALUES (7036, 'Bollnäs', 2183, 12842, 61.348170, 16.394640, 38); INSERT INTO "Tätorter" VALUES (7038, 'Bönan', 2180, 316, 60.739620, 17.312390, 1); INSERT INTO "Tätorter" VALUES (7040, 'Delsbo', 2184, 2192, 61.801040, 16.555710, 62); INSERT INTO "Tätorter" VALUES (7044, 'Edsbyn', 2121, 3985, 61.376920, 15.817470, 155); INSERT INTO "Tätorter" VALUES (7048, 'Enånger', 2184, 642, 61.545560, 17.010560, 14); INSERT INTO "Tätorter" VALUES (7050, 'Forsby', 2180, 651, 60.716670, 17.133330, 13); INSERT INTO "Tätorter" VALUES (7052, 'Forsbacka', 2180, 1702, 64.766670, 20.500000, 144); INSERT INTO "Tätorter" VALUES (7056, 'Friggesund', 2184, 522, 61.900000, 16.533330, 75); INSERT INTO "Tätorter" VALUES (7060, 'Furuvik', 2180, 575, 60.650000, 17.333330, 8); INSERT INTO "Tätorter" VALUES (7064, 'Färila', 2161, 1293, 61.800000, 15.850000, 163); INSERT INTO "Tätorter" VALUES (7068, 'Gnarp', 2132, 1026, 62.066670, 17.283330, 62); INSERT INTO "Tätorter" VALUES (7076, 'Gävle', 2180, 71033, 60.674520, 17.141740, 3); INSERT INTO "Tätorter" VALUES (7084, 'Hammarby', 2181, 552, 60.550000, 16.566670, 59); INSERT INTO "Tätorter" VALUES (7092, 'Hamrångefjärden', 2180, 509, 60.900000, 17.066670, 1); INSERT INTO "Tätorter" VALUES (7096, 'Harmånger', 2132, 540, 61.933330, 17.216670, 14); INSERT INTO "Tätorter" VALUES (7104, 'Hedesunda', 2180, 1028, 60.400000, 17.000000, 52); INSERT INTO "Tätorter" VALUES (7112, 'Hofors', 2104, 6681, 60.545730, 16.286680, 114); INSERT INTO "Tätorter" VALUES (7120, 'Hudiksvall', 2184, 15015, 61.728970, 17.103580, 2); INSERT INTO "Tätorter" VALUES (7124, 'Hybo', 2161, 241, 61.800000, 16.200000, 131); INSERT INTO "Tätorter" VALUES (7130, 'Hålsjö', 2184, 214, 61.833330, 16.750000, 39); INSERT INTO "Tätorter" VALUES (7132, 'Iggesund', 2184, 3362, 61.644440, 17.083060, 12); INSERT INTO "Tätorter" VALUES (7136, 'Ilsbo', 2132, 406, 61.866670, 17.066670, 122); INSERT INTO "Tätorter" VALUES (7140, 'Jäderfors', 2181, 284, 60.683330, 16.666670, 76); INSERT INTO "Tätorter" VALUES (7144, 'Jädraås', 2101, 220, 60.850000, 16.466670, 206); INSERT INTO "Tätorter" VALUES (7148, 'Järbo', 2181, 1801, 60.716670, 16.600000, 111); INSERT INTO "Tätorter" VALUES (7152, 'Järvsö', 2161, 1407, 61.716670, 16.166670, 111); INSERT INTO "Tätorter" VALUES (7154, 'Jättendal', 2132, 253, 61.967500, 17.248890, 18); INSERT INTO "Tätorter" VALUES (7156, 'Kilafors', 2183, 1126, 61.233330, 16.566670, 39); INSERT INTO "Tätorter" VALUES (7168, 'Kungsgården', 2181, 1033, 63.000000, 17.833330, 13); INSERT INTO "Tätorter" VALUES (7172, 'Hassela', 2132, 364, 62.133330, 16.716670, 227); INSERT INTO "Tätorter" VALUES (7178, 'Lillhaga', 2161, 379, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (7180, 'Lingbo', 2101, 429, 61.050000, 16.683330, 79); INSERT INTO "Tätorter" VALUES (7184, 'Ljusdal', 2161, 6230, 61.828830, 16.091260, 132); INSERT INTO "Tätorter" VALUES (7188, 'Ljusne', 2182, 1917, 61.216670, 17.133330, 11); INSERT INTO "Tätorter" VALUES (7192, 'Los', 2161, 387, 61.733330, 15.166670, 376); INSERT INTO "Tätorter" VALUES (7196, 'Lottefors', 2183, 392, 61.416670, 16.400000, 96); INSERT INTO "Tätorter" VALUES (7198, 'Lund', 2180, 444, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (7204, 'Malnbaden', 2184, 213, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (7208, 'Marmaverken', 2182, 371, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (7210, 'Måga-Rolfhamre', 2161, 215, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (7212, 'Marmaskogen', 2182, 253, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (7214, 'Mohed', 2182, 393, 61.300000, 16.833330, 64); INSERT INTO "Tätorter" VALUES (7216, 'Njutånger', 2184, 885, 61.612500, 17.055560, 3); INSERT INTO "Tätorter" VALUES (7220, 'Nore', 2161, 411, 61.833330, 16.050000, 127); INSERT INTO "Tätorter" VALUES (7224, 'Norrlandet', 2180, 329, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (7228, 'Norrsundet', 2180, 968, 60.950000, 17.133330, 2); INSERT INTO "Tätorter" VALUES (7232, 'Näsviken', 2184, 924, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (7236, 'Ockelbo', 2101, 2724, 60.891200, 16.718460, 59); INSERT INTO "Tätorter" VALUES (7240, 'Ovanåker', 2121, 212, 61.362500, 15.892710, 148); INSERT INTO "Tätorter" VALUES (7252, 'Rengsjö', 2183, 264, 61.366670, 16.600000, 102); INSERT INTO "Tätorter" VALUES (7256, 'Roteberg', 2121, 393, 61.383330, 15.816670, 155); INSERT INTO "Tätorter" VALUES (7258, 'Runemo', 2121, 263, 61.366670, 16.116670, 94); INSERT INTO "Tätorter" VALUES (7268, 'Sandarne', 2182, 2067, 61.266670, 17.166670, NULL); INSERT INTO "Tätorter" VALUES (7272, 'Sandviken', 2181, 22965, 60.616670, 16.766670, 66); INSERT INTO "Tätorter" VALUES (7276, 'Segersta', 2183, 313, 61.266670, 16.633330, 51); INSERT INTO "Tätorter" VALUES (7280, 'Sibo', 2183, 301, 61.216670, 16.600000, 31); INSERT INTO "Tätorter" VALUES (7284, 'Skog', 2182, 302, 64.700000, 16.133330, 424); INSERT INTO "Tätorter" VALUES (7292, 'Stocka', 2132, 382, 61.893610, 17.336670, 2); INSERT INTO "Tätorter" VALUES (7296, 'Storvik', 2181, 2165, 65.150000, 20.733330, 198); INSERT INTO "Tätorter" VALUES (7304, 'Strömsbruk', 2132, 362, 61.870280, 17.315560, 15); INSERT INTO "Tätorter" VALUES (7308, 'Sälgsjön', 2180, 207, 60.617680, 17.113180, 53); INSERT INTO "Tätorter" VALUES (7312, 'Söderala', 2182, 949, 61.283330, 16.966670, 11); INSERT INTO "Tätorter" VALUES (7316, 'Söderhamn', 2182, 11761, 61.303730, 17.059210, 2); INSERT INTO "Tätorter" VALUES (7320, 'Sörforsa', 2184, 1574, 61.733330, 16.983330, 54); INSERT INTO "Tätorter" VALUES (7324, 'Tallåsen', 2161, 586, 64.300000, 18.833330, 275); INSERT INTO "Tätorter" VALUES (7332, 'Torsåker', 2104, 899, 63.066670, 17.750000, 1); INSERT INTO "Tätorter" VALUES (7336, 'Totra', 2180, 273, 60.916670, 17.066670, 11); INSERT INTO "Tätorter" VALUES (7340, 'Trödje', 2180, 333, 60.816670, 17.200000, 14); INSERT INTO "Tätorter" VALUES (7344, 'Valbo', 2180, 7065, 60.650000, 17.033330, 17); INSERT INTO "Tätorter" VALUES (7348, 'Vallsta', 2183, 277, 61.522370, 16.360870, 104); INSERT INTO "Tätorter" VALUES (7352, 'Vallvik', 2182, 258, 61.183330, 17.183330, 1); INSERT INTO "Tätorter" VALUES (7356, 'Vannsätter', 2182, 434, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (7360, 'Viksjöfors', 2121, 244, 61.333330, 15.950000, 162); INSERT INTO "Tätorter" VALUES (7364, 'Västerberg', 2181, 242, 61.216670, 16.516670, 68); INSERT INTO "Tätorter" VALUES (7368, 'Åbyggeby', 2180, 811, 60.916670, 16.650000, 75); INSERT INTO "Tätorter" VALUES (7372, 'Åmot', 2101, 277, 60.966670, 16.450000, 175); INSERT INTO "Tätorter" VALUES (7376, 'Årsunda', 2181, 1008, 60.533330, 16.733330, 48); INSERT INTO "Tätorter" VALUES (7380, 'Åshammar', 2181, 727, 60.650000, 16.533330, 92); INSERT INTO "Tätorter" VALUES (7384, 'Österfärnebo', 2181, 483, 60.300000, 16.800000, 50); INSERT INTO "Tätorter" VALUES (7400, 'Alby', 2260, 367, 62.500000, 15.466670, 205); INSERT INTO "Tätorter" VALUES (7402, 'Klingsta och Allsta', 2281, 342, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (7404, 'Vi', 2281, 4997, 62.300000, 17.166670, 183); INSERT INTO "Tätorter" VALUES (7408, 'Ankarsvik', 2281, 944, 62.370280, 17.411670, NULL); INSERT INTO "Tätorter" VALUES (7412, 'Arnäsvall', 2284, 341, 63.316670, 18.783330, 16); INSERT INTO "Tätorter" VALUES (7416, 'Bergeforsen', 2262, 1563, 62.533330, 17.383330, 43); INSERT INTO "Tätorter" VALUES (7420, 'Billsta', 2284, 361, 63.333330, 18.500000, 18); INSERT INTO "Tätorter" VALUES (7424, 'Bjästa', 2284, 1808, 63.200000, 18.500000, 33); INSERT INTO "Tätorter" VALUES (7428, 'Björna', 2284, 413, 63.566670, 18.550000, 181); INSERT INTO "Tätorter" VALUES (7432, 'Bollstabruk', 2282, 1871, 63.000000, 17.683330, 1); INSERT INTO "Tätorter" VALUES (7444, 'Bredbyn', 2284, 1186, 63.446550, 18.110190, 45); INSERT INTO "Tätorter" VALUES (7446, 'Dingersjö', 2281, 856, 62.266670, 17.383330, 1); INSERT INTO "Tätorter" VALUES (7448, 'Docksta', 2282, 378, 63.050000, 18.333330, 1); INSERT INTO "Tätorter" VALUES (7460, 'Essvik', 2281, 752, 62.316390, 17.393060, NULL); INSERT INTO "Tätorter" VALUES (7462, 'Fanbyn', 2281, 526, 63.366670, 19.200000, 22); INSERT INTO "Tätorter" VALUES (7468, 'Frånö', 2282, 640, 62.900000, 17.833330, 47); INSERT INTO "Tätorter" VALUES (7472, 'Fränsta', 2260, 1256, 62.500000, 16.150000, 57); INSERT INTO "Tätorter" VALUES (7476, 'Gideå', 2284, 266, 63.550000, 18.616670, 124); INSERT INTO "Tätorter" VALUES (7478, 'Gustavsberg', 2281, 254, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (7480, 'Gimåt', 2284, 903, 63.316670, 18.716670, 121); INSERT INTO "Tätorter" VALUES (7482, 'Gottne', 2284, 218, 63.432490, 18.429910, 20); INSERT INTO "Tätorter" VALUES (7492, 'Hovid', 2281, 225, 62.469170, 17.381110, NULL); INSERT INTO "Tätorter" VALUES (7496, 'Husum', 2284, 1647, 63.333330, 19.166670, 2); INSERT INTO "Tätorter" VALUES (7500, 'Härnösand', 2280, 17556, 62.632280, 17.937940, 25); INSERT INTO "Tätorter" VALUES (7504, 'Indal', 2281, 661, 62.566670, 17.100000, 90); INSERT INTO "Tätorter" VALUES (7506, 'Juniskär', 2281, 397, 62.296390, 17.460000, 1); INSERT INTO "Tätorter" VALUES (7510, 'Johannedal', 2281, 2754, 62.433610, 17.371110, 39); INSERT INTO "Tätorter" VALUES (7512, 'Junsele', 2283, 895, 63.683330, 16.900000, 196); INSERT INTO "Tätorter" VALUES (7516, 'Klockestrand', 2282, 315, 62.883330, 17.900000, NULL); INSERT INTO "Tätorter" VALUES (7520, 'Kovland', 2281, 486, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (7524, 'Kramfors', 2282, 5990, 62.931610, 17.776460, 1); INSERT INTO "Tätorter" VALUES (7532, 'Kvissleby', 2281, 2614, 62.293610, 17.375000, 1); INSERT INTO "Tätorter" VALUES (7540, 'Köpmanholmen', 2284, 1237, 63.166670, 18.566670, 9); INSERT INTO "Tätorter" VALUES (7548, 'Liden', 2281, 254, 64.916670, 20.783330, 139); INSERT INTO "Tätorter" VALUES (7552, 'Ljungaverk', 2260, 885, 62.483330, 16.016670, 169); INSERT INTO "Tätorter" VALUES (7560, 'Lucksta', 2281, 346, 62.300000, 17.050000, 6); INSERT INTO "Tätorter" VALUES (7564, 'Lungvik', 2282, 349, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (7568, 'Lunde', 2282, 399, 62.883330, 17.850000, 19); INSERT INTO "Tätorter" VALUES (7572, 'Långsele', 2283, 1584, 64.816670, 20.250000, 193); INSERT INTO "Tätorter" VALUES (7576, 'Långviksmon', 2284, 221, 63.633330, 18.683330, 189); INSERT INTO "Tätorter" VALUES (7580, 'Matfors', 2281, 3201, 62.350000, 17.033330, 36); INSERT INTO "Tätorter" VALUES (7584, 'Mellansel', 2284, 827, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (7588, 'Mjällom', 2282, 275, 62.983330, 18.433330, 110); INSERT INTO "Tätorter" VALUES (7592, 'Moliden', 2284, 300, 63.383330, 18.466670, 87); INSERT INTO "Tätorter" VALUES (7596, 'Nedansjö', 2281, 257, 62.383330, 16.816670, 49); INSERT INTO "Tätorter" VALUES (7600, 'Njurundabommen', 2281, 1983, 62.263390, 17.383540, 40); INSERT INTO "Tätorter" VALUES (7604, 'Nordingrå', 2282, 306, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (7616, 'Nyland', 2282, 903, 64.816670, 20.766670, 103); INSERT INTO "Tätorter" VALUES (7620, 'Näsåker', 2283, 513, 63.433330, 16.900000, 126); INSERT INTO "Tätorter" VALUES (7628, 'Ramsele', 2283, 968, 64.066670, 19.550000, 166); INSERT INTO "Tätorter" VALUES (7632, 'Ramvik', 2280, 691, 62.816670, 17.850000, 1); INSERT INTO "Tätorter" VALUES (7636, 'Sandslån', 2282, 272, 63.016670, 17.783330, 1); INSERT INTO "Tätorter" VALUES (7644, 'Sidensjö', 2284, 399, 63.300000, 18.300000, 126); INSERT INTO "Tätorter" VALUES (7652, 'Skottsund', 2281, 1069, 62.290560, 17.386940, 4); INSERT INTO "Tätorter" VALUES (7660, 'Sollefteå', 2283, 8562, 63.166670, 17.266670, 2); INSERT INTO "Tätorter" VALUES (7668, 'Stavreviken', 2262, 216, 62.550000, 17.400000, 16); INSERT INTO "Tätorter" VALUES (7670, 'Stockvik', 2281, 2359, 62.336670, 17.365830, 1); INSERT INTO "Tätorter" VALUES (7676, 'Stöde', 2281, 572, 62.416670, 16.600000, 76); INSERT INTO "Tätorter" VALUES (7680, 'Ullånger', 2282, 626, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (7684, 'Sundsbruk', 2281, 2137, 62.458060, 17.348890, 39); INSERT INTO "Tätorter" VALUES (7688, 'Sundsvall', 2281, 50712, 62.391290, 17.306300, 26); INSERT INTO "Tätorter" VALUES (7696, 'Svartvik', 2281, 949, 62.593330, 17.935000, NULL); INSERT INTO "Tätorter" VALUES (7700, 'Söråker', 2262, 2312, 62.505000, 17.513330, 91); INSERT INTO "Tätorter" VALUES (7704, 'Timrå', 2262, 10443, 62.487030, 17.325700, 1); INSERT INTO "Tätorter" VALUES (7708, 'Torpshammar', 2260, 444, 62.483330, 16.333330, 79); INSERT INTO "Tätorter" VALUES (7716, 'Tunadal', 2281, 360, 62.414170, 17.379440, 1); INSERT INTO "Tätorter" VALUES (7720, 'Utansjö', 2280, 209, 62.781390, 17.932780, 1); INSERT INTO "Tätorter" VALUES (7726, 'Vattjom', 2281, 477, 63.033330, 14.400000, 313); INSERT INTO "Tätorter" VALUES (7728, 'Västerhus', 2284, 326, 63.333330, 18.550000, 136); INSERT INTO "Tätorter" VALUES (7732, 'Åmynnet', 2284, 340, 63.183330, 18.516670, 2); INSERT INTO "Tätorter" VALUES (7736, 'Ånge', 2260, 2872, 62.524950, 15.659040, 168); INSERT INTO "Tätorter" VALUES (7740, 'Älandsbro', 2280, 832, 62.666670, 17.833330, 19); INSERT INTO "Tätorter" VALUES (7744, 'Örnsköldsvik', 2284, 28991, 63.290910, 18.715250, 1); INSERT INTO "Tätorter" VALUES (7748, 'Östavall', 2260, 222, 62.433330, 15.466670, 250); INSERT INTO "Tätorter" VALUES (7752, 'Österforse', 2283, 204, 63.150000, 17.016670, 155); INSERT INTO "Tätorter" VALUES (7756, 'Överhörnäs', 2284, 603, 63.300000, 18.550000, 1); INSERT INTO "Tätorter" VALUES (7800, 'Aspås', 2309, 375, 63.366670, 14.500000, 367); INSERT INTO "Tätorter" VALUES (7804, 'Backe', 2313, 599, 63.816670, 16.400000, 231); INSERT INTO "Tätorter" VALUES (7806, 'Östra Bispgården', 2303, 279, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (7808, 'Västra Bispgården', 2303, 518, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (7810, 'Björnänge', 2321, 254, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (7812, 'Brunflo', 2380, 3890, 63.075860, 14.832030, 339); INSERT INTO "Tätorter" VALUES (7816, 'Bräcke', 2305, 1651, 62.750670, 15.421930, 307); INSERT INTO "Tätorter" VALUES (7820, 'Duved', 2321, 663, 63.400000, 12.866670, 420); INSERT INTO "Tätorter" VALUES (7824, 'Dvärsätt', 2309, 461, 63.316670, 14.466670, 310); INSERT INTO "Tätorter" VALUES (7828, 'Funäsdalen', 2361, 890, 62.533330, 12.550000, 583); INSERT INTO "Tätorter" VALUES (7836, 'Föllinge', 2309, 485, 63.666670, 14.616670, 310); INSERT INTO "Tätorter" VALUES (7840, 'Gäddede', 2313, 401, 64.500000, 14.150000, 356); INSERT INTO "Tätorter" VALUES (7844, 'Gällö', 2305, 725, 62.916670, 15.233330, 296); INSERT INTO "Tätorter" VALUES (7848, 'Hackås', 2326, 480, 62.916670, 14.516670, 326); INSERT INTO "Tätorter" VALUES (7852, 'Hallen', 2321, 203, 63.766670, 14.750000, 385); INSERT INTO "Tätorter" VALUES (7856, 'Hammarstrand', 2303, 1052, 63.110410, 16.353770, 124); INSERT INTO "Tätorter" VALUES (7860, 'Hammerdal', 2313, 974, 63.600000, 15.350000, 293); INSERT INTO "Tätorter" VALUES (7868, 'Hede', 2361, 741, 62.422910, 13.521030, 421); INSERT INTO "Tätorter" VALUES (7876, 'Hoting', 2313, 667, 64.116670, 16.166670, 309); INSERT INTO "Tätorter" VALUES (7880, 'Häggenås', 2380, 320, 63.383330, 14.883330, 277); INSERT INTO "Tätorter" VALUES (7884, 'Järpen', 2321, 1408, 63.350000, 13.483330, 344); INSERT INTO "Tätorter" VALUES (7886, 'Klövsjö', 2326, 291, 62.528480, 14.194160, 535); INSERT INTO "Tätorter" VALUES (7888, 'Krokom', 2309, 2277, 63.325890, 14.448830, 294); INSERT INTO "Tätorter" VALUES (7896, 'Kälarne', 2305, 451, 62.983330, 16.083330, 277); INSERT INTO "Tätorter" VALUES (7904, 'Lillhärdal', 2361, 335, 61.850000, 14.066670, 446); INSERT INTO "Tätorter" VALUES (7908, 'Lit', 2380, 1040, 63.316670, 14.816670, 279); INSERT INTO "Tätorter" VALUES (7910, 'Marieby', 2380, 236, 63.116670, 14.733330, 294); INSERT INTO "Tätorter" VALUES (7912, 'Myrviken', 2326, 239, 63.000000, 14.350000, 297); INSERT INTO "Tätorter" VALUES (7916, 'Mörsil', 2321, 686, 63.316670, 13.633330, 450); INSERT INTO "Tätorter" VALUES (7920, 'Norr-Hede', 2361, 261, 62.416670, 13.533330, 426); INSERT INTO "Tätorter" VALUES (7932, 'Nälden', 2309, 873, 63.350000, 14.250000, 321); INSERT INTO "Tätorter" VALUES (7934, 'Näsviken', 2313, 203, 60.116670, 18.666670, 5); INSERT INTO "Tätorter" VALUES (7936, 'Ope', 2380, 453, 63.133330, 14.750000, 313); INSERT INTO "Tätorter" VALUES (7938, 'Orrviken', 2380, 262, 63.100000, 14.433330, 318); INSERT INTO "Tätorter" VALUES (7942, 'Optand', 2380, 257, 63.116670, 14.783330, 343); INSERT INTO "Tätorter" VALUES (7944, 'Pilgrimstad', 2305, 386, 62.950000, 15.033330, 290); INSERT INTO "Tätorter" VALUES (7948, 'Rossön', 2313, 352, 63.933330, 16.350000, 215); INSERT INTO "Tätorter" VALUES (7960, 'Strömsund', 2313, 3589, 63.852060, 15.555830, 299); INSERT INTO "Tätorter" VALUES (7964, 'Stugun', 2303, 659, 63.166670, 15.600000, 222); INSERT INTO "Tätorter" VALUES (7968, 'Sveg', 2361, 2547, 62.034070, 14.365770, 354); INSERT INTO "Tätorter" VALUES (7976, 'Svenstavik', 2326, 1004, 62.766670, 14.435350, 331); INSERT INTO "Tätorter" VALUES (7984, 'Tandsbyn', 2380, 374, 63.000000, 14.750000, 365); INSERT INTO "Tätorter" VALUES (7988, 'Trångsviken', 2309, 288, 63.333330, 14.016670, 300); INSERT INTO "Tätorter" VALUES (7996, 'Ulvkälla', 2361, 456, 62.016670, 14.350000, 368); INSERT INTO "Tätorter" VALUES (8000, 'Undersåker', 2321, 438, 63.333330, 13.266670, 500); INSERT INTO "Tätorter" VALUES (8002, 'Vaplan', 2309, 263, 63.333330, 14.216670, 320); INSERT INTO "Tätorter" VALUES (8008, 'Vemdalen', 2361, 542, 62.450000, 13.866670, 430); INSERT INTO "Tätorter" VALUES (8012, 'Ytterhogdal', 2361, 534, 62.183330, 14.950000, 269); INSERT INTO "Tätorter" VALUES (8016, 'Ytterån', 2309, 204, 63.317660, 14.170370, 300); INSERT INTO "Tätorter" VALUES (8024, 'Åre', 2321, 1417, 63.398350, 13.080190, 379); INSERT INTO "Tätorter" VALUES (8028, 'Ås', 2309, 1218, 63.248000, 14.560600, NULL); INSERT INTO "Tätorter" VALUES (8032, 'Åsarne', 2326, 268, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (8040, 'Änge', 2309, 314, 63.600000, 13.216670, 700); INSERT INTO "Tätorter" VALUES (8044, 'Östersund', 2380, 44327, 63.179200, 14.635660, 328); INSERT INTO "Tätorter" VALUES (8112, 'Bastuträsk', 2417, 392, 64.783330, 20.033330, 254); INSERT INTO "Tätorter" VALUES (8116, 'Bergsbyn', 2482, 1780, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (8120, 'Bjurholm', 2403, 968, 63.930270, 19.213690, 173); INSERT INTO "Tätorter" VALUES (8132, 'Boliden', 2482, 1566, 64.866670, 20.383330, 226); INSERT INTO "Tätorter" VALUES (8136, 'Botsmark', 2480, 201, 64.250000, 20.266670, 249); INSERT INTO "Tätorter" VALUES (8140, 'Brännland', 2480, 220, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (8142, 'Bullmark', 2480, 319, 64.033330, 20.466670, 86); INSERT INTO "Tätorter" VALUES (8144, 'Bureå', 2482, 2360, 64.616670, 21.200000, 6); INSERT INTO "Tätorter" VALUES (8148, 'Burträsk', 2482, 1575, 64.516670, 20.650000, 89); INSERT INTO "Tätorter" VALUES (8152, 'Bygdeå', 2409, 502, 64.066670, 20.850000, 12); INSERT INTO "Tätorter" VALUES (8156, 'Bygdsiljum', 2482, 357, 64.349240, 20.504140, 151); INSERT INTO "Tätorter" VALUES (8160, 'Byske', 2482, 1728, 64.952580, 21.205800, 9); INSERT INTO "Tätorter" VALUES (8168, 'Dorotea', 2425, 1543, 64.261850, 16.413060, 336); INSERT INTO "Tätorter" VALUES (8172, 'Ersmark', 2480, 1613, 63.883330, 20.316670, 44); INSERT INTO "Tätorter" VALUES (8174, 'Flurkmark', 2480, 291, 63.983330, 20.250000, 92); INSERT INTO "Tätorter" VALUES (8176, 'Fredrika', 2463, 215, 64.083330, 18.400000, 294); INSERT INTO "Tätorter" VALUES (8188, 'Granö', 2404, 238, 59.933330, 18.883330, 23); INSERT INTO "Tätorter" VALUES (8196, 'Hissjön', 2480, 477, 63.933330, 20.150000, 116); INSERT INTO "Tätorter" VALUES (8198, 'Hemavan/Bierke', 2421, 222, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (8200, 'Holmsund', 2480, 5489, 63.706020, 20.364090, 12); INSERT INTO "Tätorter" VALUES (8204, 'Hällnäs', 2404, 259, 65.450000, 16.000000, 393); INSERT INTO "Tätorter" VALUES (8208, 'Hörnefors', 2480, 2542, 63.623120, 19.908560, NULL); INSERT INTO "Tätorter" VALUES (8210, 'Innertavle', 2480, 582, 63.800000, 20.400000, 21); INSERT INTO "Tätorter" VALUES (8212, 'Jörn', 2482, 797, 65.066670, 20.033330, 270); INSERT INTO "Tätorter" VALUES (8220, 'Kristineberg', 2481, 257, 65.066670, 18.583330, 344); INSERT INTO "Tätorter" VALUES (8224, 'Kusmark', 2482, 441, 64.883330, 20.800000, 56); INSERT INTO "Tätorter" VALUES (8228, 'Kåge', 2482, 2248, 64.835710, 20.984530, 14); INSERT INTO "Tätorter" VALUES (8232, 'Lycksele', 2481, 8513, 64.595370, 18.673510, 224); INSERT INTO "Tätorter" VALUES (8236, 'Lögdeå', 2401, 394, 63.533330, 19.400000, 39); INSERT INTO "Tätorter" VALUES (8240, 'Lövånger', 2482, 761, 64.366670, 21.300000, 6); INSERT INTO "Tätorter" VALUES (8244, 'Malå', 2418, 2050, 65.185010, 18.742430, 324); INSERT INTO "Tätorter" VALUES (8248, 'Medle', 2482, 552, 64.750000, 20.733330, 69); INSERT INTO "Tätorter" VALUES (8252, 'Myckle', 2482, 355, 64.752970, 20.851540, 33); INSERT INTO "Tätorter" VALUES (8256, 'Nordmaling', 2401, 2546, 63.568520, 19.502440, 20); INSERT INTO "Tätorter" VALUES (8268, 'Norsjö', 2417, 2051, 64.912060, 19.481530, 300); INSERT INTO "Tätorter" VALUES (8280, 'Obbola', 2480, 2197, 63.700000, 20.316670, 1); INSERT INTO "Tätorter" VALUES (8284, 'Ostvik', 2482, 387, 64.883330, 21.066670, 24); INSERT INTO "Tätorter" VALUES (8292, 'Robertsfors', 2409, 2004, 64.193240, 20.848060, 62); INSERT INTO "Tätorter" VALUES (8296, 'Rundvik', 2401, 817, 63.533330, 19.433330, 21); INSERT INTO "Tätorter" VALUES (8300, 'Rusksele', 2481, 200, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (8304, 'Röbäck', 2480, 2230, 63.811590, 20.183260, 37); INSERT INTO "Tätorter" VALUES (8308, 'Skelleftehamn', 2482, 3184, 64.683330, 21.233330, NULL); INSERT INTO "Tätorter" VALUES (8310, 'Ursviken', 2482, 3977, 64.712610, 21.165800, 20); INSERT INTO "Tätorter" VALUES (8312, 'Skellefteå', 2482, 32775, 64.750670, 20.952790, 34); INSERT INTO "Tätorter" VALUES (8316, 'Sorsele', 2422, 1277, 65.534840, 17.537020, 340); INSERT INTO "Tätorter" VALUES (8320, 'Stensele', 2421, 546, 65.083330, 17.166670, 416); INSERT INTO "Tätorter" VALUES (8324, 'Storuman', 2421, 2207, 65.095900, 17.117310, 396); INSERT INTO "Tätorter" VALUES (8332, 'Stöcke', 2480, 483, 63.733330, 20.216670, 8); INSERT INTO "Tätorter" VALUES (8334, 'Stöcksjö', 2480, 215, 63.766670, 20.166670, 42); INSERT INTO "Tätorter" VALUES (8336, 'Sävar', 2480, 2670, 63.903830, 20.550140, 41); INSERT INTO "Tätorter" VALUES (8340, 'Drängsmark', 2482, 333, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (8342, 'Södra Bergsbyn och Stackgrönnan', 2482, 393, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (8344, 'Sörfors', 2480, 403, 64.133330, 20.633330, 101); INSERT INTO "Tätorter" VALUES (8348, 'Sörmjöle', 2480, 212, 63.683330, 20.000000, 6); INSERT INTO "Tätorter" VALUES (8352, 'Tavelsjö', 2480, 245, 64.033330, 20.100000, 142); INSERT INTO "Tätorter" VALUES (8356, 'Tvärålund', 2404, 257, 64.100000, 19.683330, 205); INSERT INTO "Tätorter" VALUES (8360, 'Täfteå', 2480, 1231, 63.833330, 20.483330, 13); INSERT INTO "Tätorter" VALUES (8364, 'Tärnaby', 2421, 482, 65.711500, 15.258380, 541); INSERT INTO "Tätorter" VALUES (8368, 'Ersmark', 2482, 892, 64.848060, 20.896000, 31); INSERT INTO "Tätorter" VALUES (8372, 'Umeå', 2480, 79594, 63.828420, 20.259720, 24); INSERT INTO "Tätorter" VALUES (8376, 'Vilhelmina', 2462, 3657, 64.626840, 16.656280, 372); INSERT INTO "Tätorter" VALUES (8380, 'Vindeln', 2404, 2333, 64.201750, 19.719450, 188); INSERT INTO "Tätorter" VALUES (8384, 'Vännäs', 2460, 4118, 63.906760, 19.757120, 81); INSERT INTO "Tätorter" VALUES (8388, 'Vännäsby', 2460, 1552, 63.933330, 19.833330, 78); INSERT INTO "Tätorter" VALUES (8390, 'Västibyn', 2480, 234, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (8392, 'Åmsele', 2404, 209, 64.533330, 19.333330, 199); INSERT INTO "Tätorter" VALUES (8394, 'Yttersjö', 2480, 384, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (8396, 'Ånäset', 2409, 610, 65.450000, 20.883330, 180); INSERT INTO "Tätorter" VALUES (8400, 'Åsele', 2463, 1798, 64.166670, 17.333330, 317); INSERT INTO "Tätorter" VALUES (8408, 'Örviken', 2482, 395, 64.675330, 21.197430, 1); INSERT INTO "Tätorter" VALUES (8412, 'Överboda', 2480, 218, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (8504, 'Alvik', 2580, 777, 65.567931, 21.776179, NULL); INSERT INTO "Tätorter" VALUES (8508, 'Antnäs', 2580, 822, 65.550000, 21.866670, 3); INSERT INTO "Tätorter" VALUES (8512, 'Arjeplog', 2506, 1977, 66.051730, 17.886060, 426); INSERT INTO "Tätorter" VALUES (8516, 'Arvidsjaur', 2505, 4635, 65.590330, 19.166820, 380); INSERT INTO "Tätorter" VALUES (8524, 'Avan', 2580, 200, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (8528, 'Bensbyn', 2580, 448, 65.650000, 22.233330, 10); INSERT INTO "Tätorter" VALUES (8532, 'Bergnäset', 2580, 3648, 65.577910, 22.108440, 1); INSERT INTO "Tätorter" VALUES (8536, 'Bergsviken', 2581, 2283, 65.300000, 21.383330, 13); INSERT INTO "Tätorter" VALUES (8540, 'Blåsmark', 2581, 339, 65.266670, 21.283330, 30); INSERT INTO "Tätorter" VALUES (8544, 'Boden', 2582, 18277, 65.825180, 21.688640, 10); INSERT INTO "Tätorter" VALUES (8556, 'Bredviken', 2514, 365, 65.800000, 23.600000, 1); INSERT INTO "Tätorter" VALUES (8558, 'Brändön', 2580, 287, 65.700000, 22.333330, 12); INSERT INTO "Tätorter" VALUES (8560, 'Båtskärsnäs', 2514, 296, 65.783330, 23.416670, NULL); INSERT INTO "Tätorter" VALUES (8564, 'Bälinge', 2580, 307, 65.634210, 21.928370, 2); INSERT INTO "Tätorter" VALUES (8568, 'Böle', 2581, 424, 64.366670, 21.358330, 21); INSERT INTO "Tätorter" VALUES (8576, 'Ersnäs', 2580, 292, 65.533330, 21.800000, 2); INSERT INTO "Tätorter" VALUES (8578, 'Gammelgården', 2514, 297, 65.883330, 23.033330, 19); INSERT INTO "Tätorter" VALUES (8580, 'Gammelstad', 2580, 4960, 65.639310, 22.011450, 19); INSERT INTO "Tätorter" VALUES (8584, 'Glommersträsk', 2505, 272, 65.262020, 19.639430, 374); INSERT INTO "Tätorter" VALUES (8596, 'Gällivare', 2523, 8449, 67.133870, 20.652780, 363); INSERT INTO "Tätorter" VALUES (8600, 'Hakkas', 2523, 365, 66.916670, 21.550000, 234); INSERT INTO "Tätorter" VALUES (8604, 'Haparanda', 2583, 4856, 65.835490, 24.136760, 5); INSERT INTO "Tätorter" VALUES (8608, 'Harads', 2582, 501, 66.084010, 20.955050, 124); INSERT INTO "Tätorter" VALUES (8612, 'Hedenäset', 2518, 270, 66.416670, 23.700000, 104); INSERT INTO "Tätorter" VALUES (8616, 'Hemmingsmark', 2581, 367, 65.216670, 21.266670, 51); INSERT INTO "Tätorter" VALUES (8620, 'Hortlax', 2581, 1248, 65.283330, 21.383330, 20); INSERT INTO "Tätorter" VALUES (8628, 'Jokkmokk', 2510, 2786, 66.606650, 19.823240, 251); INSERT INTO "Tätorter" VALUES (8632, 'Jukkasjärvi', 2584, 548, 67.850000, 20.616670, 321); INSERT INTO "Tätorter" VALUES (8636, 'Junosuando', 2521, 322, 67.433330, 22.516670, 218); INSERT INTO "Tätorter" VALUES (8640, 'Juoksengi', 2518, 350, 66.566670, 23.850000, 59); INSERT INTO "Tätorter" VALUES (8644, 'Jämtön', 2580, 237, 65.850000, 22.500000, 19); INSERT INTO "Tätorter" VALUES (8648, 'Jävre', 2581, 576, 65.150000, 21.483330, 29); INSERT INTO "Tätorter" VALUES (8656, 'Kalix', 2514, 7299, 65.852980, 23.156450, NULL); INSERT INTO "Tätorter" VALUES (8658, 'Kallax', 2580, 321, 65.529890, 22.055570, 13); INSERT INTO "Tätorter" VALUES (8660, 'Kangos', 2521, 252, 67.483330, 22.666670, 218); INSERT INTO "Tätorter" VALUES (8664, 'Karesuando', 2584, 303, 68.439590, 22.470470, 326); INSERT INTO "Tätorter" VALUES (8668, 'Karlsborg', 2514, 351, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (8670, 'Karlsvik', 2580, 256, 65.597810, 22.070670, 11); INSERT INTO "Tätorter" VALUES (8672, 'Karungi', 2583, 232, 66.050000, 23.950000, 39); INSERT INTO "Tätorter" VALUES (8676, 'Kiruna', 2584, 18148, 67.855720, 20.225130, 579); INSERT INTO "Tätorter" VALUES (8680, 'Klöverträsk', 2580, 246, 65.633330, 21.383330, 118); INSERT INTO "Tätorter" VALUES (8688, 'Korpilombolo', 2521, 529, 66.851770, 23.055150, 144); INSERT INTO "Tätorter" VALUES (8692, 'Korsträsk', 2560, 323, 65.683330, 20.883330, 101); INSERT INTO "Tätorter" VALUES (8694, 'Koskullskulle', 2523, 874, 67.183330, 20.750000, 297); INSERT INTO "Tätorter" VALUES (8704, 'Kuttainen', 2584, 333, 68.383330, 22.816670, 305); INSERT INTO "Tätorter" VALUES (8720, 'Lillpite', 2581, 429, 65.366670, 21.133330, 13); INSERT INTO "Tätorter" VALUES (8724, 'Luleå', 2580, 46607, 65.584150, 22.154650, 17); INSERT INTO "Tätorter" VALUES (8732, 'Malmberget', 2523, 5590, 67.175290, 20.654950, 418); INSERT INTO "Tätorter" VALUES (8734, 'Marielund', 2583, 1726, 61.333330, 17.150000, 15); INSERT INTO "Tätorter" VALUES (8740, 'Morjärv', 2514, 201, 66.066670, 22.716670, 27); INSERT INTO "Tätorter" VALUES (8744, 'Moskosel', 2505, 232, 65.866670, 19.416670, 319); INSERT INTO "Tätorter" VALUES (8752, 'Måttsund', 2580, 558, 65.550000, 21.900000, 65); INSERT INTO "Tätorter" VALUES (8768, 'Nikkala', 2583, 435, 65.800000, 23.933330, 1); INSERT INTO "Tätorter" VALUES (8776, 'Norrfjärden', 2581, 1362, 65.416670, 21.450000, 14); INSERT INTO "Tätorter" VALUES (8780, 'Pajala', 2521, 1958, 67.212840, 23.366070, 173); INSERT INTO "Tätorter" VALUES (8788, 'Persön', 2580, 223, 65.740080, 22.166980, 12); INSERT INTO "Tätorter" VALUES (8792, 'Piteå', 2581, 22913, 65.317170, 21.479440, 6); INSERT INTO "Tätorter" VALUES (8796, 'Porjus', 2510, 328, 66.959270, 19.820710, 384); INSERT INTO "Tätorter" VALUES (8804, 'Påläng', 2514, 278, 62.383330, 17.150000, 69); INSERT INTO "Tätorter" VALUES (8812, 'Risögrund', 2514, 697, 65.800000, 23.250000, NULL); INSERT INTO "Tätorter" VALUES (8816, 'Roknäs', 2581, 1238, 65.350000, 21.200000, 5); INSERT INTO "Tätorter" VALUES (8820, 'Rolfs', 2514, 1061, 65.850000, 23.116670, 16); INSERT INTO "Tätorter" VALUES (8824, 'Rosvik', 2581, 1735, 65.433330, 21.700000, 16); INSERT INTO "Tätorter" VALUES (8828, 'Rutvik', 2580, 839, 65.671710, 22.089730, 12); INSERT INTO "Tätorter" VALUES (8832, 'Råneå', 2580, 1912, 65.854820, 22.291260, 25); INSERT INTO "Tätorter" VALUES (8836, 'Sangis', 2514, 572, 65.850000, 23.500000, 16); INSERT INTO "Tätorter" VALUES (8840, 'Seskarö', 2583, 491, 65.750000, 23.733330, 1); INSERT INTO "Tätorter" VALUES (8846, 'Sjulsmark', 2581, 350, 65.516670, 21.500000, 39); INSERT INTO "Tätorter" VALUES (8864, 'Svappavaara', 2584, 417, 67.647210, 21.054010, 343); INSERT INTO "Tätorter" VALUES (8868, 'Svartbyn', 2513, 265, 66.266670, 22.816670, 41); INSERT INTO "Tätorter" VALUES (8872, 'Svartlå', 2582, 201, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (8876, 'Svensbyn', 2581, 342, 65.300000, 21.233330, 39); INSERT INTO "Tätorter" VALUES (8878, 'Sävast', 2582, 3148, 65.770020, 21.731130, 21); INSERT INTO "Tätorter" VALUES (8880, 'Södra Sunderbyn', 2580, 2977, 65.659830, 21.940040, 3); INSERT INTO "Tätorter" VALUES (8884, 'Tallvik', 2513, 434, 66.333330, 22.850000, 41); INSERT INTO "Tätorter" VALUES (8886, 'Tjautjas/Cavccas', 2523, 234, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (8896, 'Töre', 2514, 1099, 65.912430, 22.651280, 30); INSERT INTO "Tätorter" VALUES (8900, 'Ullatti', 2523, 213, 67.016670, 21.816670, 197); INSERT INTO "Tätorter" VALUES (8902, 'Unbyn', 2582, 468, 65.716670, 21.750000, 2); INSERT INTO "Tätorter" VALUES (8904, 'Vidsel', 2560, 533, 65.850000, 20.516670, 108); INSERT INTO "Tätorter" VALUES (8908, 'Vistträsk', 2560, 248, NULL, NULL, NULL); INSERT INTO "Tätorter" VALUES (8912, 'Vittangi', 2584, 784, 67.675890, 21.642040, 252); INSERT INTO "Tätorter" VALUES (8916, 'Vittjärv', 2582, 445, 65.850000, 21.566670, 16); INSERT INTO "Tätorter" VALUES (8920, 'Vuollerim', 2510, 732, 66.430380, 20.624340, 104); INSERT INTO "Tätorter" VALUES (8928, 'Nyborg', 2514, 833, 65.783330, 23.200000, 7); INSERT INTO "Tätorter" VALUES (8932, 'Älvsbyn', 2560, 4967, 65.676240, 21.001620, 33); INSERT INTO "Tätorter" VALUES (8940, 'Överkalix', 2513, 975, 66.327540, 22.844140, 41); INSERT INTO "Tätorter" VALUES (8944, 'Övertorneå', 2518, 1917, 66.387780, 23.654250, 54); INSERT INTO "Tätorter" VALUES (8948, 'Övre Soppero', 2584, 201, 68.083330, 21.683330, 364); -- Nu när tätorterna finns kan vi lägga in residensstäderna UPDATE "Län" SET residensstad = (SELECT "Tätorter".kod FROM "Tätorter", Kommuner WHERE "Tätorter".kommun = Kommuner.kod and "Tätorter".namn = 'Karlskrona' and Kommuner.namn = 'Karlskrona kommun') where Namn = 'Blekinge län'; UPDATE "Län" SET residensstad = (SELECT "Tätorter".kod FROM "Tätorter", Kommuner WHERE "Tätorter".kommun = Kommuner.kod and "Tätorter".namn = 'Falun' and Kommuner.namn = 'Falu kommun') where Namn = 'Dalarnas län'; UPDATE "Län" SET residensstad = (SELECT "Tätorter".kod FROM "Tätorter", Kommuner WHERE "Tätorter".kommun = Kommuner.kod and "Tätorter".namn = 'Visby' and Kommuner.namn = 'Gotlands kommun') where Namn = 'Gotlands län'; UPDATE "Län" SET residensstad = (SELECT "Tätorter".kod FROM "Tätorter", Kommuner WHERE "Tätorter".kommun = Kommuner.kod and "Tätorter".namn = 'Gävle' and Kommuner.namn = 'Gävle kommun') where Namn = 'Gävleborgs län'; UPDATE "Län" SET residensstad = (SELECT "Tätorter".kod FROM "Tätorter", Kommuner WHERE "Tätorter".kommun = Kommuner.kod and "Tätorter".namn = 'Halmstad' and Kommuner.namn = 'Halmstads kommun') where Namn = 'Hallands län'; UPDATE "Län" SET residensstad = (SELECT "Tätorter".kod FROM "Tätorter", Kommuner WHERE "Tätorter".kommun = Kommuner.kod and "Tätorter".namn = 'Östersund' and Kommuner.namn = 'Östersunds kommun') where Namn = 'Jämtlands län'; UPDATE "Län" SET residensstad = (SELECT "Tätorter".kod FROM "Tätorter", Kommuner WHERE "Tätorter".kommun = Kommuner.kod and "Tätorter".namn = 'Jönköping' and Kommuner.namn = 'Jönköpings kommun') where Namn = 'Jönköpings län'; UPDATE "Län" SET residensstad = (SELECT "Tätorter".kod FROM "Tätorter", Kommuner WHERE "Tätorter".kommun = Kommuner.kod and "Tätorter".namn = 'Kalmar' and Kommuner.namn = 'Kalmar kommun') where Namn = 'Kalmar län'; UPDATE "Län" SET residensstad = (SELECT "Tätorter".kod FROM "Tätorter", Kommuner WHERE "Tätorter".kommun = Kommuner.kod and "Tätorter".namn = 'Växjö' and Kommuner.namn = 'Växjö kommun') where Namn = 'Kronobergs län'; UPDATE "Län" SET residensstad = (SELECT "Tätorter".kod FROM "Tätorter", Kommuner WHERE "Tätorter".kommun = Kommuner.kod and "Tätorter".namn = 'Luleå' and Kommuner.namn = 'Luleå kommun') where Namn = 'Norrbottens län'; UPDATE "Län" SET residensstad = (SELECT "Tätorter".kod FROM "Tätorter", Kommuner WHERE "Tätorter".kommun = Kommuner.kod and "Tätorter".namn = 'Malmö' and Kommuner.namn = 'Malmö kommun') where Namn = 'Skåne län'; UPDATE "Län" SET residensstad = (SELECT "Tätorter".kod FROM "Tätorter", Kommuner WHERE "Tätorter".kommun = Kommuner.kod and "Tätorter".namn = 'Stockholm' and Kommuner.namn = 'Stockholms kommun') where Namn = 'Stockholms län'; UPDATE "Län" SET residensstad = (SELECT "Tätorter".kod FROM "Tätorter", Kommuner WHERE "Tätorter".kommun = Kommuner.kod and "Tätorter".namn = 'Nyköping' and Kommuner.namn = 'Nyköpings kommun') where Namn = 'Södermanlands län'; UPDATE "Län" SET residensstad = (SELECT "Tätorter".kod FROM "Tätorter", Kommuner WHERE "Tätorter".kommun = Kommuner.kod and "Tätorter".namn = 'Uppsala' and Kommuner.namn = 'Uppsala kommun') where Namn = 'Uppsala län'; UPDATE "Län" SET residensstad = (SELECT "Tätorter".kod FROM "Tätorter", Kommuner WHERE "Tätorter".kommun = Kommuner.kod and "Tätorter".namn = 'Karlstad' and Kommuner.namn = 'Karlstads kommun') where Namn = 'Värmlands län'; UPDATE "Län" SET residensstad = (SELECT "Tätorter".kod FROM "Tätorter", Kommuner WHERE "Tätorter".kommun = Kommuner.kod and "Tätorter".namn = 'Umeå' and Kommuner.namn = 'Umeå kommun') where Namn = 'Västerbottens län'; UPDATE "Län" SET residensstad = (SELECT "Tätorter".kod FROM "Tätorter", Kommuner WHERE "Tätorter".kommun = Kommuner.kod and "Tätorter".namn = 'Härnösand' and Kommuner.namn = 'Härnösands kommun') where Namn = 'Västernorrlands län'; UPDATE "Län" SET residensstad = (SELECT "Tätorter".kod FROM "Tätorter", Kommuner WHERE "Tätorter".kommun = Kommuner.kod and "Tätorter".namn = 'Västerås' and Kommuner.namn = 'Västerås kommun') where Namn = 'Västmanlands län'; UPDATE "Län" SET residensstad = (SELECT "Tätorter".kod FROM "Tätorter", Kommuner WHERE "Tätorter".kommun = Kommuner.kod and "Tätorter".namn = 'Göteborg' and Kommuner.namn = 'Göteborgs kommun') where Namn = 'Västra Götalands län'; UPDATE "Län" SET residensstad = (SELECT "Tätorter".kod FROM "Tätorter", Kommuner WHERE "Tätorter".kommun = Kommuner.kod and "Tätorter".namn = 'Örebro' and Kommuner.namn = 'Örebro kommun') where Namn = 'Örebro län'; UPDATE "Län" SET residensstad = (SELECT "Tätorter".kod FROM "Tätorter", Kommuner WHERE "Tätorter".kommun = Kommuner.kod and "Tätorter".namn = 'Linköping' and Kommuner.namn = 'Linköpings kommun') where Namn = 'Östergötlands län'; -- Nu ska det finnas 21 län, 290 kommunr och 1956 tätorter SELECT COUNT(*) FROM "Län"; SELECT COUNT(*) FROM Kommuner; SELECT COUNT(*) FROM "Tätorter";