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