-- "Sverige"-databasen med Sveriges tatorter, lan och kommuner
-- Thomas Padron-McCarthy (thomas.padron-mccarthy@oru.se)
-- Utan svenska tecken!
-- Denna version senast andrad 5 januari 2023

-- 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 cirkulara referenser, sa vi lagger dit det villkoret sist
-- Tillat NULL i Residensstad, annars blir det svart att fylla tabellerna, ocksa pga cirkulara 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, -- "Sjobo sommarby och Svansjo sommarby" ska fa 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)); -- tatortsnamn ar unika inom en kommun men inte inom Sverige

ALTER TABLE Lan ADD CONSTRAINT residensstad FOREIGN KEY (Residensstad) REFERENCES Tatorter(Kod);

-- Sveriges 21 lan enligt Wikipedia 2013
-- NULL for residensstaderna, for vi har inte fyllt tatortstabellen an

INSERT INTO Lan VALUES (01, 'AB', 'Stockholms lan', 2127006, NULL);
INSERT INTO Lan VALUES (03, 'C', 'Uppsala lan', 341977, NULL);
INSERT INTO Lan VALUES (04, 'D', 'Sodermanlands lan', 274723, NULL);
INSERT INTO Lan VALUES (05, 'E', 'Ostergotlands lan', 433784, NULL);
INSERT INTO Lan VALUES (06, 'F', 'Jonkopings lan', 339116, NULL);
INSERT INTO Lan VALUES (07, 'G', 'Kronobergs lan', 185887, NULL);
INSERT INTO Lan VALUES (08, 'H', 'Kalmar lan', 233548, NULL);
INSERT INTO Lan VALUES (09, 'I', 'Gotlands lan', 57241, NULL);
INSERT INTO Lan VALUES (10, 'K', 'Blekinge lan', 152315, NULL);
INSERT INTO Lan VALUES (12, 'M', 'Skane lan', 1263088, NULL);
INSERT INTO Lan VALUES (13, 'N', 'Hallands lan', 304116, NULL);
INSERT INTO Lan VALUES (14, 'O', 'Vastra Gotalands lan', 1600447, NULL);
INSERT INTO Lan VALUES (17, 'S', 'Varmlands lan', 273080, NULL);
INSERT INTO Lan VALUES (18, 'T', 'Orebro lan', 283113, NULL);
INSERT INTO Lan VALUES (19, 'U', 'Vastmanlands lan', 256224, NULL);
INSERT INTO Lan VALUES (20, 'W', 'Dalarnas lan', 276555, NULL);
INSERT INTO Lan VALUES (21, 'X', 'Gavleborgs lan', 276637, NULL);
INSERT INTO Lan VALUES (22, 'Y', 'Vasternorrlands lan', 241981, NULL);
INSERT INTO Lan VALUES (23, 'Z', 'Jamtlands lan', 126201, NULL);
INSERT INTO Lan VALUES (24, 'AC', 'Vasterbottens lan', 260217, NULL);
INSERT INTO Lan VALUES (25, 'BD', 'Norrbottens lan', 248637, NULL);

-- Sveriges 290 kommuner enligt Wikipedia 2013

INSERT INTO Kommuner VALUES (114, 'Upplands Vasby kommun', 40723, 1);
INSERT INTO Kommuner VALUES (115, 'Vallentuna kommun', 31215, 1);
INSERT INTO Kommuner VALUES (117, 'Osterakers kommun', 40269, 1);
INSERT INTO Kommuner VALUES (120, 'Varmdo kommun', 39387, 1);
INSERT INTO Kommuner VALUES (123, 'Jarfalla kommun', 68210, 1);
INSERT INTO Kommuner VALUES (125, 'Ekero 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, 'Tyreso 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, 'Taby 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, 'Sodertalje 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, 'Lidingo kommun', 44434, 1);
INSERT INTO Kommuner VALUES (187, 'Vaxholms kommun', 11126, 1);
INSERT INTO Kommuner VALUES (188, 'Norrtalje kommun', 56634, 1);
INSERT INTO Kommuner VALUES (191, 'Sigtuna kommun', 42272, 1);
INSERT INTO Kommuner VALUES (192, 'Nynashamns kommun', 26572, 1);
INSERT INTO Kommuner VALUES (305, 'Habo kommun', 19883, 3);
INSERT INTO Kommuner VALUES (319, 'Alvkarleby 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, 'Enkopings kommun', 40349, 3);
INSERT INTO Kommuner VALUES (382, 'Osthammars kommun', 21262, 3);
INSERT INTO Kommuner VALUES (428, 'Vingakers kommun', 8775, 4);
INSERT INTO Kommuner VALUES (461, 'Gnesta kommun', 10442, 4);
INSERT INTO Kommuner VALUES (480, 'Nykopings kommun', 52336, 4);
INSERT INTO Kommuner VALUES (481, 'Oxelosunds 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, 'Strangnas kommun', 33072, 4);
INSERT INTO Kommuner VALUES (488, 'Trosa kommun', 11529, 4);
INSERT INTO Kommuner VALUES (509, 'Odeshogs 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, 'Atvidabergs kommun', 11446, 5);
INSERT INTO Kommuner VALUES (562, 'Finspangs kommun', 20791, 5);
INSERT INTO Kommuner VALUES (563, 'Valdemarsviks kommun', 7597, 5);
INSERT INTO Kommuner VALUES (580, 'Linkopings kommun', 148521, 5);
INSERT INTO Kommuner VALUES (581, 'Norrkopings kommun', 132124, 5);
INSERT INTO Kommuner VALUES (582, 'Soderkopings 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, 'Mjolby kommun', 26195, 5);
INSERT INTO Kommuner VALUES (604, 'Aneby kommun', 6407, 6);
INSERT INTO Kommuner VALUES (617, 'Gnosjo kommun', 9354, 6);
INSERT INTO Kommuner VALUES (642, 'Mullsjo kommun', 7070, 6);
INSERT INTO Kommuner VALUES (643, 'Haabo 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, 'Jonkopings kommun', 129478, 6);
INSERT INTO Kommuner VALUES (682, 'Nassjo kommun', 29382, 6);
INSERT INTO Kommuner VALUES (683, 'Varnamo kommun', 33012, 6);
INSERT INTO Kommuner VALUES (684, 'Savsjo kommun', 10844, 6);
INSERT INTO Kommuner VALUES (685, 'Vetlanda kommun', 26297, 6);
INSERT INTO Kommuner VALUES (686, 'Eksjo kommun', 16368, 6);
INSERT INTO Kommuner VALUES (687, 'Tranas 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, 'Almhults kommun', 15724, 7);
INSERT INTO Kommuner VALUES (767, 'Markaryds kommun', 9477, 7);
INSERT INTO Kommuner VALUES (780, 'Vaxjo kommun', 84800, 7);
INSERT INTO Kommuner VALUES (781, 'Ljungby kommun', 27423, 7);
INSERT INTO Kommuner VALUES (821, 'Hogsby kommun', 5730, 8);
INSERT INTO Kommuner VALUES (834, 'Torsas kommun', 6858, 8);
INSERT INTO Kommuner VALUES (840, 'Morbylanga kommun', 14256, 8);
INSERT INTO Kommuner VALUES (860, 'Hultsfreds kommun', 13550, 8);
INSERT INTO Kommuner VALUES (861, 'Monsteras 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, 'Vasterviks 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, 'Olofstroms 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, 'Solvesborgs kommun', 16808, 10);
INSERT INTO Kommuner VALUES (1214, 'Svalovs kommun', 13275, 12);
INSERT INTO Kommuner VALUES (1230, 'Staffanstorps kommun', 22534, 12);
INSERT INTO Kommuner VALUES (1231, 'Burlovs kommun', 17011, 12);
INSERT INTO Kommuner VALUES (1233, 'Vellinge kommun', 33615, 12);
INSERT INTO Kommuner VALUES (1256, 'Ostra Goinge kommun', 13620, 12);
INSERT INTO Kommuner VALUES (1257, 'Orkelljunga kommun', 9655, 12);
INSERT INTO Kommuner VALUES (1260, 'Bjuvs kommun', 14866, 12);
INSERT INTO Kommuner VALUES (1261, 'Kavlinge 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, 'Sjobo kommun', 18290, 12);
INSERT INTO Kommuner VALUES (1266, 'Horby kommun', 14958, 12);
INSERT INTO Kommuner VALUES (1267, 'Hoors kommun', 15526, 12);
INSERT INTO Kommuner VALUES (1270, 'Tomelilla kommun', 12917, 12);
INSERT INTO Kommuner VALUES (1272, 'Bromolla 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, 'Astorps kommun', 14806, 12);
INSERT INTO Kommuner VALUES (1278, 'Bastads kommun', 14263, 12);
INSERT INTO Kommuner VALUES (1280, 'Malmo 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, 'Hoganas kommun', 24863, 12);
INSERT INTO Kommuner VALUES (1285, 'Eslovs 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, 'Angelholms kommun', 39742, 12);
INSERT INTO Kommuner VALUES (1293, 'Hassleholms 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, 'Harryda kommun', 35223, 14);
INSERT INTO Kommuner VALUES (1402, 'Partille kommun', 35837, 14);
INSERT INTO Kommuner VALUES (1407, 'Ockero kommun', 12539, 14);
INSERT INTO Kommuner VALUES (1415, 'Stenungsunds kommun', 24868, 14);
INSERT INTO Kommuner VALUES (1419, 'Tjorns kommun', 14974, 14);
INSERT INTO Kommuner VALUES (1421, 'Orusts kommun', 15083, 14);
INSERT INTO Kommuner VALUES (1427, 'Sotenas 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, 'Fargelanda 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, 'Vargarda kommun', 11030, 14);
INSERT INTO Kommuner VALUES (1443, 'Bollebygds kommun', 8507, 14);
INSERT INTO Kommuner VALUES (1444, 'Grastorps 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, 'Gullspangs 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, 'Gotene kommun', 13092, 14);
INSERT INTO Kommuner VALUES (1472, 'Tibro kommun', 10673, 14);
INSERT INTO Kommuner VALUES (1473, 'Toreboda kommun', 9009, 14);
INSERT INTO Kommuner VALUES (1480, 'Goteborgs kommun', 526089, 14);
INSERT INTO Kommuner VALUES (1481, 'Molndals kommun', 61659, 14);
INSERT INTO Kommuner VALUES (1482, 'Kungalvs 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, 'Stromstads kommun', 12295, 14);
INSERT INTO Kommuner VALUES (1487, 'Vanersborgs kommun', 36968, 14);
INSERT INTO Kommuner VALUES (1488, 'Trollhattans kommun', 55749, 14);
INSERT INTO Kommuner VALUES (1489, 'Alingsas kommun', 38355, 14);
INSERT INTO Kommuner VALUES (1490, 'Boras kommun', 104867, 14);
INSERT INTO Kommuner VALUES (1491, 'Ulricehamns kommun', 23015, 14);
INSERT INTO Kommuner VALUES (1492, 'Amals kommun', 12211, 14);
INSERT INTO Kommuner VALUES (1493, 'Mariestads kommun', 23739, 14);
INSERT INTO Kommuner VALUES (1494, 'Lidkopings kommun', 38254, 14);
INSERT INTO Kommuner VALUES (1495, 'Skara kommun', 18281, 14);
INSERT INTO Kommuner VALUES (1496, 'Skovde 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, 'Falkopings 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, 'Hammaro 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, 'Arjangs 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, 'Saffle kommun', 15308, 17);
INSERT INTO Kommuner VALUES (1814, 'Lekebergs kommun', 7298, 18);
INSERT INTO Kommuner VALUES (1860, 'Laxa 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, 'Hallefors kommun', 6988, 18);
INSERT INTO Kommuner VALUES (1864, 'Ljusnarsbergs kommun', 4848, 18);
INSERT INTO Kommuner VALUES (1880, 'Orebro 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, 'Kungsors 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, 'Vasteras 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, 'Kopings 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-Salens 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, 'Rattviks kommun', 10799, 20);
INSERT INTO Kommuner VALUES (2034, 'Orsa kommun', 6835, 20);
INSERT INTO Kommuner VALUES (2039, 'Alvdalens 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, 'Borlange kommun', 49482, 20);
INSERT INTO Kommuner VALUES (2082, 'Saters 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, 'Ovanakers 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, 'Gavle kommun', 96170, 21);
INSERT INTO Kommuner VALUES (2181, 'Sandvikens kommun', 37089, 21);
INSERT INTO Kommuner VALUES (2182, 'Soderhamns kommun', 25223, 21);
INSERT INTO Kommuner VALUES (2183, 'Bollnas kommun', 26158, 21);
INSERT INTO Kommuner VALUES (2184, 'Hudiksvalls kommun', 36821, 21);
INSERT INTO Kommuner VALUES (2260, 'Ange kommun', 9639, 22);
INSERT INTO Kommuner VALUES (2262, 'Timra kommun', 17997, 22);
INSERT INTO Kommuner VALUES (2280, 'Harnosands 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, 'Solleftea kommun', 19736, 22);
INSERT INTO Kommuner VALUES (2284, 'Ornskoldsviks kommun', 55008, 22);
INSERT INTO Kommuner VALUES (2303, 'Ragunda kommun', 5466, 23);
INSERT INTO Kommuner VALUES (2305, 'Bracke kommun', 6655, 23);
INSERT INTO Kommuner VALUES (2309, 'Krokoms kommun', 14590, 23);
INSERT INTO Kommuner VALUES (2313, 'Stromsunds kommun', 12138, 23);
INSERT INTO Kommuner VALUES (2321, 'Are kommun', 10406, 23);
INSERT INTO Kommuner VALUES (2326, 'Bergs kommun', 7215, 23);
INSERT INTO Kommuner VALUES (2361, 'Harjedalens kommun', 10246, 23);
INSERT INTO Kommuner VALUES (2380, 'Ostersunds 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, 'Norsjo kommun', 4172, 24);
INSERT INTO Kommuner VALUES (2418, 'Mala 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, 'Vannas kommun', 8522, 24);
INSERT INTO Kommuner VALUES (2462, 'Vilhelmina kommun', 6941, 24);
INSERT INTO Kommuner VALUES (2463, 'Asele kommun', 2958, 24);
INSERT INTO Kommuner VALUES (2480, 'Umea kommun', 117294, 24);
INSERT INTO Kommuner VALUES (2481, 'Lycksele kommun', 12351, 24);
INSERT INTO Kommuner VALUES (2482, 'Skelleftea 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, 'Overkalix kommun', 3497, 25);
INSERT INTO Kommuner VALUES (2514, 'Kalix kommun', 16518, 25);
INSERT INTO Kommuner VALUES (2518, 'Overtornea kommun', 4772, 25);
INSERT INTO Kommuner VALUES (2521, 'Pajala kommun', 6279, 25);
INSERT INTO Kommuner VALUES (2523, 'Gallivare kommun', 18307, 25);
INSERT INTO Kommuner VALUES (2560, 'Alvsbyns kommun', 8200, 25);
INSERT INTO Kommuner VALUES (2580, 'Lulea kommun', 74905, 25);
INSERT INTO Kommuner VALUES (2581, 'Pitea 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 tatorter enligt SCB, via svenska Wikipedia 2011, med koordinater fran geonames.org, eventuellt med nagon senare rattelse

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, 'Bjornomalmen och Klacknaset', 120, 624, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (108, 'Brevik', 186, 8772, 59.350000, 18.200000, 10);
INSERT INTO Tatorter VALUES (110, 'Brevikshalvon', 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, 'Dalaro', 136, 1199, 59.133060, 18.406390, NULL);
INSERT INTO Tatorter VALUES (136, 'Djuro', 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, 'Ekero', 125, 10907, 59.291000, 17.812120, 18);
INSERT INTO Tatorter VALUES (151, 'Ekero sommarstad', 125, 544, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (152, 'Ekeby', 114, 258, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (154, 'Varmdo-Evlinge', 120, 559, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (156, 'Fisksatra', 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, 'Fagelvikshojden', 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, 'Glado 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, 'Herrang', 188, 422, 60.133330, 18.650000, 14);
INSERT INTO Tatorter VALUES (186, 'Hedvigsberg', 120, 282, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (190, 'Habo-Tibble kyrkby', 139, 256, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (192, 'Hasthagen', 182, 499, 60.216670, 18.516670, NULL);
INSERT INTO Tatorter VALUES (194, 'Hagbyhojden', 117, 479, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (196, 'Holo', 181, 1400, 59.283330, 18.666670, 20);
INSERT INTO Tatorter VALUES (198, 'Ingarostrand', 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, 'Jarna', 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, 'Kummelnas', 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, 'Kungsangen', 139, 9382, 59.478570, 17.748340, 20);
INSERT INTO Tatorter VALUES (222, 'Kullo', 187, 889, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (224, 'Karsta', 115, 457, 62.566670, 17.133330, 150);
INSERT INTO Tatorter VALUES (226, 'Landfjarden', 192, 241, 59.033330, 17.983330, 21);
INSERT INTO Tatorter VALUES (228, 'Lidingo', 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, 'Langvik', 120, 559, 66.116670, 22.233330, 143);
INSERT INTO Tatorter VALUES (236, 'Lowenstromska lasarettet', 114, 518, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (238, 'Musko', 136, 261, 58.983060, 18.133060, 6);
INSERT INTO Tatorter VALUES (240, 'Marsta', 191, 24068, 59.616670, 17.850000, 24);
INSERT INTO Tatorter VALUES (242, 'Mariedal', 139, 297, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (244, 'Molnbo', 181, 1052, 59.050000, 17.416670, 16);
INSERT INTO Tatorter VALUES (246, 'Lurudden', 125, 205, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (248, 'Mortnas', 120, 1511, 59.316670, 18.450000, 2);
INSERT INTO Tatorter VALUES (250, 'Norra Lagno', 120, 332, 59.350000, 18.416670, 7);
INSERT INTO Tatorter VALUES (252, 'Norrtalje', 188, 17275, 59.757990, 18.704960, 26);
INSERT INTO Tatorter VALUES (254, 'Lidatorp', 192, 340, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (256, 'Norro', 117, 305, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (260, 'Nykvarn', 140, 6497, 59.800000, 18.300000, 19);
INSERT INTO Tatorter VALUES (262, 'Nygards hagar', 140, 328, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (264, 'Nynashamn', 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, 'Resaro', 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, 'Rattarboda', 139, 237, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (288, 'Taby', 160, 61272, 59.443900, 18.068720, 8);
INSERT INTO Tatorter VALUES (290, 'Taljo', 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, 'Ranas', 188, 428, 59.800000, 18.283330, 18);
INSERT INTO Tatorter VALUES (296, 'Saltsjobaden', 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, 'Sjoberg', 163, 4310, 64.833330, 16.250000, 510);
INSERT INTO Tatorter VALUES (306, 'Skargardsstad', 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, 'Skeppsdalsstrom', 120, 1573, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (314, 'Lugnet och Skalsmara', 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, 'Stavsnas', 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, 'Segersang', 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, 'Stromma', 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, 'Soderby-Karl', 188, 231, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (354, 'Sodersvik', 188, 281, 59.783330, 18.983330, 1);
INSERT INTO Tatorter VALUES (356, 'Sodertalje', 181, 64619, 59.195540, 17.625250, 35);
INSERT INTO Tatorter VALUES (362, 'Soderby', 125, 250, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (364, 'Grodby', 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 Vasby', 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, 'Varsta', 127, 2396, 59.166670, 17.800000, 54);
INSERT INTO Tatorter VALUES (398, 'Viksater', 181, 459, 63.000000, 18.100000, 140);
INSERT INTO Tatorter VALUES (402, 'Valandan', 136, 469, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (404, 'Vasterhaninge', 136, 15134, 59.116670, 18.100000, 39);
INSERT INTO Tatorter VALUES (406, 'Adran', 126, 244, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (408, 'Akersberga', 117, 28033, 59.479440, 18.299670, 10);
INSERT INTO Tatorter VALUES (410, 'Atervall', 120, 206, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (412, 'Almsta', 188, 1097, 59.966670, 18.800000, 13);
INSERT INTO Tatorter VALUES (414, 'Alvnas', 125, 601, 59.283330, 17.766670, 21);
INSERT INTO Tatorter VALUES (416, 'Alta', 182, 9989, 59.266670, 18.183330, 52);
INSERT INTO Tatorter VALUES (418, 'Angsvik', 120, 403, 59.350000, 18.516670, 8);
INSERT INTO Tatorter VALUES (420, 'Osmo', 192, 3911, 58.983330, 17.900000, 31);
INSERT INTO Tatorter VALUES (422, 'Osthamra', 188, 255, 59.750000, 18.716670, 13);
INSERT INTO Tatorter VALUES (424, 'Olsta', 125, 267, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (426, 'Osterhagen', 139, 213, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (428, 'Ostra 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, 'Bjorklinge', 380, 3269, 60.250000, 18.466670, 12);
INSERT INTO Tatorter VALUES (516, 'Vange', 380, 1331, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (520, 'Balsta', 305, 14147, 59.567100, 17.527810, 47);
INSERT INTO Tatorter VALUES (524, 'Balinge', 380, 2437, 59.950000, 17.533330, 27);
INSERT INTO Tatorter VALUES (526, 'Barby', 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, 'Enkoping', 381, 21121, 59.636070, 17.077680, 15);
INSERT INTO Tatorter VALUES (536, 'Fjardhundra', 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, 'Gardskar', 319, 352, 60.616670, 17.583330, 11);
INSERT INTO Tatorter VALUES (556, 'Gavsta', 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, 'Haga', 380, 302, 59.850000, 17.583330, 16);
INSERT INTO Tatorter VALUES (568, 'Jarlasa', 380, 493, 59.883330, 17.200000, 76);
INSERT INTO Tatorter VALUES (570, 'Haggeby 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, 'Kragga', 305, 331, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (588, 'Lillkyrka', 381, 301, 59.560000, 17.250000, 19);
INSERT INTO Tatorter VALUES (590, 'Laby', 380, 220, 60.083330, 17.550000, 33);
INSERT INTO Tatorter VALUES (592, 'Lanna', 380, 685, 59.866670, 17.966670, 15);
INSERT INTO Tatorter VALUES (596, 'Lovstalot', 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, 'Mankarbo', 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, 'Skutskar', 319, 6075, 60.641040, 17.409150, 4);
INSERT INTO Tatorter VALUES (618, 'Raby', 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, 'Skolsta', 380, 344, 59.883330, 17.733330, 21);
INSERT INTO Tatorter VALUES (624, 'Skarplinge', 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, 'Savja', 380, 9684, 59.820830, 17.698990, 24);
INSERT INTO Tatorter VALUES (636, 'Soderfors', 360, 1572, 64.816670, 18.050000, 273);
INSERT INTO Tatorter VALUES (638, 'Soderskogen', 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, 'Ytternas och Vreta', 380, 636, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (664, 'Alvkarleby', 319, 1647, 60.570810, 17.448950, 19);
INSERT INTO Tatorter VALUES (666, 'Vardsatra', 380, 237, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (672, 'Orbyhus', 360, 1984, 60.233330, 17.700000, 22);
INSERT INTO Tatorter VALUES (676, 'Oregrund', 382, 1555, 60.333330, 18.433330, 15);
INSERT INTO Tatorter VALUES (680, 'Orsundsbro', 381, 1813, 59.733330, 17.300000, 10);
INSERT INTO Tatorter VALUES (684, 'Osterbybruk', 382, 2272, 60.200000, 17.900000, 36);
INSERT INTO Tatorter VALUES (688, 'Osthammar', 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, 'Arno', 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, 'Bjorkvik', 483, 492, 65.500000, 15.566670, 412);
INSERT INTO Tatorter VALUES (724, 'Bjornlunda', 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, 'Balgviken', 484, 253, 59.250000, 16.450000, 62);
INSERT INTO Tatorter VALUES (734, 'Djulo 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, 'Forssjo', 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, 'Hallsta', 484, 823, 63.000000, 14.966670, 325);
INSERT INTO Tatorter VALUES (760, 'Hallberga', 484, 612, 59.316670, 16.600000, 38);
INSERT INTO Tatorter VALUES (764, 'Hallbybrunn', 484, 3296, 59.383330, 16.433330, 19);
INSERT INTO Tatorter VALUES (768, 'Halleforsnas', 482, 1585, 59.166670, 16.500000, 58);
INSERT INTO Tatorter VALUES (772, 'Harad', 486, 508, 59.350000, 16.900000, 28);
INSERT INTO Tatorter VALUES (776, 'Hogsjo', 428, 713, 62.533330, 17.083330, 189);
INSERT INTO Tatorter VALUES (780, 'Jonaker', 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, 'Kjulaas', 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, 'Malmkoping', 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, 'Mellosa', 482, 535, 59.200000, 15.500000, 18);
INSERT INTO Tatorter VALUES (806, 'Merlanna', 486, 356, 59.283330, 16.983330, 24);
INSERT INTO Tatorter VALUES (812, 'Nykoping', 480, 29891, 58.753000, 17.007880, 17);
INSERT INTO Tatorter VALUES (816, 'Navekvarn', 480, 795, 58.633060, 16.800000, 29);
INSERT INTO Tatorter VALUES (820, 'Oxelosund', 481, 10870, 58.670570, 17.101520, 21);
INSERT INTO Tatorter VALUES (828, 'Runtuna', 480, 250, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (832, 'Sjosa', 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, 'Skoldinge', 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, 'Stavsjo', 480, 212, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (856, 'Stigtomta', 480, 1942, 58.800000, 16.783330, 30);
INSERT INTO Tatorter VALUES (860, 'Stjarnhov', 461, 549, 59.083330, 17.000000, 21);
INSERT INTO Tatorter VALUES (864, 'Strangsjo', 483, 365, 58.900000, 16.200000, 59);
INSERT INTO Tatorter VALUES (868, 'Strangnas', 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, 'Torshalla', 484, 7612, 59.416670, 16.466670, 17);
INSERT INTO Tatorter VALUES (882, 'Torshalla 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, 'Vagnharad', 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, 'Vanso', 486, 202, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (904, 'Vingaker', 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, 'Vasterljung', 488, 398, 58.916670, 17.433330, 20);
INSERT INTO Tatorter VALUES (912, 'Akers styckebruk', 486, 2891, 59.250000, 17.083330, 27);
INSERT INTO Tatorter VALUES (916, 'Alberga', 480, 247, 58.733330, 16.566670, 67);
INSERT INTO Tatorter VALUES (918, 'Angsholmen', 484, 222, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (920, 'Arla', 484, 1270, 59.283330, 16.666670, 45);
INSERT INTO Tatorter VALUES (924, 'Askoping', 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, 'Bjorsater', 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, 'Borggard', 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, 'Ekangen', 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, 'Ensjon', 581, 333, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (1056, 'Finspang', 562, 12440, 58.705780, 15.767390, 20);
INSERT INTO Tatorter VALUES (1060, 'Fornasa', 583, 433, 58.483330, 15.233330, 77);
INSERT INTO Tatorter VALUES (1064, 'Fagelsta', 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, 'Godegard', 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, 'Grytgol', 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, 'Hallestad', 562, 336, 58.733330, 15.566670, 54);
INSERT INTO Tatorter VALUES (1108, 'Hastholmen', 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, 'Lindo', 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, 'Linkoping', 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, 'Snoveltorp', 582, 333, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (1172, 'Malmslatt', 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, 'Mjolby', 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, 'Norrkoping', 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, 'Rydsnas', 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, 'Sjogestad', 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, 'Skanninge', 586, 3140, 59.933330, 18.483330, 24);
INSERT INTO Tatorter VALUES (1248, 'Skarblacka', 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, 'Spangsholm', 586, 408, 58.350000, 15.233330, 100);
INSERT INTO Tatorter VALUES (1264, 'Stralsnas', 560, 410, 58.233330, 15.100000, 152);
INSERT INTO Tatorter VALUES (1268, 'Stromsfors', 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, 'Svartinge', 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, 'Soderkoping', 582, 6992, 58.480570, 16.322210, 7);
INSERT INTO Tatorter VALUES (1292, 'Tjallmo', 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, 'Vanga', 581, 220, 59.783330, 16.916670, 41);
INSERT INTO Tatorter VALUES (1316, 'Vaderstad', 586, 583, 58.316670, 14.916670, 95);
INSERT INTO Tatorter VALUES (1318, 'Vasterlosa', 580, 206, 58.800000, 15.533330, 70);
INSERT INTO Tatorter VALUES (1320, 'Vastra Husby', 582, 486, 58.483730, 16.175480, 33);
INSERT INTO Tatorter VALUES (1324, 'Aby', 581, 4980, 58.666670, 16.183330, 59);
INSERT INTO Tatorter VALUES (1326, 'Aselstad', 581, 475, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (1328, 'Atvidaberg', 561, 6859, 58.201520, 15.997700, 95);
INSERT INTO Tatorter VALUES (1330, 'Obonas', 581, 457, 58.533330, 16.183330, 49);
INSERT INTO Tatorter VALUES (1332, 'Odeshog', 509, 2572, 58.229490, 14.652940, 134);
INSERT INTO Tatorter VALUES (1336, 'Osterbymo', 512, 834, 57.824650, 15.273570, 194);
INSERT INTO Tatorter VALUES (1340, 'Osterstad', 583, 318, 58.516670, 15.166670, 75);
INSERT INTO Tatorter VALUES (1344, 'Ostra Husby', 581, 792, 58.583060, 16.550000, 21);
INSERT INTO Tatorter VALUES (1348, 'Ostra 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, 'Bjorkoby', 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, 'Olmstad', 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, 'Ekenassjon', 685, 1517, 57.500000, 15.000000, 218);
INSERT INTO Tatorter VALUES (1460, 'Eksjo', 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, 'Gnosjo', 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, 'Granna', 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, 'Hjaltevad', 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, 'Hanger', 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, 'Jonkoping', 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, 'Karda', 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, 'Malmback', 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, 'Myresjo', 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, 'Nassjo', 682, 16678, 57.653070, 14.696760, 307);
INSERT INTO Tatorter VALUES (1612, 'Odensjo', 680, 2495, 57.716670, 14.166670, 237);
INSERT INTO Tatorter VALUES (1620, 'Paulistrom', 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, 'Rorvik', 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, 'Skarstad', 680, 341, 57.883330, 14.366670, 295);
INSERT INTO Tatorter VALUES (1664, 'Smalandsstenar', 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, 'Stensjon', 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, 'Savsjo', 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, 'Tranas', 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, 'Torestorp', 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, 'Varnamo', 683, 18696, 57.186040, 14.040010, 162);
INSERT INTO Tatorter VALUES (1738, 'Asenhoga', 617, 210, 57.400000, 13.800000, 248);
INSERT INTO Tatorter VALUES (1740, 'Ang', 682, 277, 59.033330, 11.966670, 150);
INSERT INTO Tatorter VALUES (1742, 'Oggestorp', 680, 212, 57.733330, 14.383330, 241);
INSERT INTO Tatorter VALUES (1748, 'Orserum', 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, 'Bjorno', 780, 215, 58.633330, 15.000000, 120);
INSERT INTO Tatorter VALUES (1820, 'Braas', 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, 'Dio', 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, 'Grimslov', 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, 'Kanna', 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-Klavrestrom', 760, 1215, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (1952, 'Nobbele', 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, 'Ravemala', 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, 'Stromsnasbruk', 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, 'Tavelsas', 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, 'Vackelsang', 763, 905, 56.633330, 14.916670, 131);
INSERT INTO Tatorter VALUES (2024, 'Vaxjo', 780, 60887, 56.877670, 14.809060, 185);
INSERT INTO Tatorter VALUES (2028, 'Aby', 780, 456, 60.650000, 17.033330, 17);
INSERT INTO Tatorter VALUES (2032, 'Aryd', 780, 684, 57.950000, 13.650000, 267);
INSERT INTO Tatorter VALUES (2036, 'Aseda', 760, 2430, 57.170100, 15.344300, 243);
INSERT INTO Tatorter VALUES (2040, 'Alghult', 760, 446, 57.366670, 13.650000, 208);
INSERT INTO Tatorter VALUES (2048, 'Almhult', 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, 'Bjorkviken', 885, 208, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (2120, 'Blomstermala', 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, 'Backebo', 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, 'Duno', 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, 'Eriksmala', 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, 'Frodinge', 884, 383, 57.700000, 16.000000, 124);
INSERT INTO Tatorter VALUES (2200, 'Fagelfors', 821, 424, 57.200000, 15.833330, 132);
INSERT INTO Tatorter VALUES (2204, 'Farbo', 882, 517, 57.383330, 16.483330, 39);
INSERT INTO Tatorter VALUES (2208, 'Farjestaden', 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, 'Gardby', 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, 'Hogsby', 821, 1881, 57.165970, 16.025620, 79);
INSERT INTO Tatorter VALUES (2266, 'Ralla', 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, 'Jarnforsen', 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, 'Kastlosa', 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, 'Kopingsvik', 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, 'Langasjo', 862, 348, 56.583330, 15.433330, 120);
INSERT INTO Tatorter VALUES (2316, 'Lackeby', 880, 847, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (2324, 'Lottorp', 885, 438, 57.166670, 16.983330, 10);
INSERT INTO Tatorter VALUES (2328, 'Misterhult', 882, 203, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (2330, 'Mysingso', 882, 385, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (2332, 'Maleras', 881, 211, 56.916670, 15.566670, 225);
INSERT INTO Tatorter VALUES (2336, 'Malilla', 860, 1524, 57.387730, 15.806750, 106);
INSERT INTO Tatorter VALUES (2340, 'Monsteras', 861, 4731, 57.041340, 16.444630, 9);
INSERT INTO Tatorter VALUES (2344, 'Morbylanga', 840, 1780, 56.524800, 16.378770, NULL);
INSERT INTO Tatorter VALUES (2348, 'Morlunda', 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, 'Piperskarr', 883, 551, 57.783330, 16.633060, NULL);
INSERT INTO Tatorter VALUES (2368, 'Paryd', 880, 651, 56.566670, 15.916670, 64);
INSERT INTO Tatorter VALUES (2372, 'Paskallavik', 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, 'Soderakra', 834, 912, 56.450000, 16.066670, 11);
INSERT INTO Tatorter VALUES (2420, 'Sodra Vi', 884, 1182, 57.750000, 15.800000, 122);
INSERT INTO Tatorter VALUES (2422, 'Soregarde-Drag', 880, 274, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (2424, 'Timmernabben', 861, 1276, 56.966670, 16.433330, 10);
INSERT INTO Tatorter VALUES (2428, 'Torsas', 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, 'Tvarskog', 880, 404, 56.616670, 16.033330, 53);
INSERT INTO Tatorter VALUES (2452, 'Vassmolosa', 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, 'Vissefjarda', 862, 670, 56.533330, 15.583330, 108);
INSERT INTO Tatorter VALUES (2472, 'Vastervik', 883, 21140, 57.758400, 16.637330, 5);
INSERT INTO Tatorter VALUES (2480, 'Alem', 861, 803, 56.950000, 16.383330, 21);
INSERT INTO Tatorter VALUES (2484, 'Orsjo', 881, 369, 56.700000, 15.750000, 118);
INSERT INTO Tatorter VALUES (2488, 'Overum', 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, 'Farosund', 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, 'Larbro', 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, 'Stanga', 980, 317, 57.283330, 18.466670, 27);
INSERT INTO Tatorter VALUES (2542, 'Tingstade', 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, 'Vaskinde', 980, 337, 57.683330, 18.416670, 48);
INSERT INTO Tatorter VALUES (2560, 'Vasterhejde', 980, 313, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (2600, 'Backaryd', 1081, 365, 56.333330, 15.183330, 68);
INSERT INTO Tatorter VALUES (2604, 'Brakne-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, 'Fagelmara', 1080, 374, 56.250000, 15.950000, 12);
INSERT INTO Tatorter VALUES (2628, 'Granum', 1060, 223, 56.233330, 14.583330, 58);
INSERT INTO Tatorter VALUES (2630, 'Gangletorp', 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, 'Hasslo', 1080, 1628, 56.116670, 15.483330, NULL);
INSERT INTO Tatorter VALUES (2644, 'Holmsjo', 1080, 334, 65.266670, 18.333330, 366);
INSERT INTO Tatorter VALUES (2648, 'Hallaryd', 1082, 546, 57.466670, 15.166670, 145);
INSERT INTO Tatorter VALUES (2652, 'Hallevik', 1083, 813, 56.016670, 14.700000, 10);
INSERT INTO Tatorter VALUES (2656, 'Horvik', 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, 'Jamjo', 1080, 2578, 56.800000, 16.683330, 37);
INSERT INTO Tatorter VALUES (2668, 'Jamshog', 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, 'Kattilsmala', 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, 'Lorby', 1083, 264, 56.066670, 14.700000, 9);
INSERT INTO Tatorter VALUES (2696, 'Mjallby', 1083, 1254, 56.683330, 12.766670, 19);
INSERT INTO Tatorter VALUES (2700, 'Morrum', 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, 'Nattraby', 1080, 3109, 56.200000, 15.516670, 13);
INSERT INTO Tatorter VALUES (2716, 'Navragol', 1080, 210, 56.366670, 15.566670, 83);
INSERT INTO Tatorter VALUES (2720, 'Olofstrom', 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, 'Rodeby', 1080, 3402, 56.250000, 15.600000, 13);
INSERT INTO Tatorter VALUES (2738, 'Skavkulla och Skillingenas', 1080, 621, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (2740, 'Sturko', 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, 'Svangsta', 1082, 1682, 56.266670, 14.766670, 68);
INSERT INTO Tatorter VALUES (2752, 'Solvesborg', 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, 'Aryd', 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, 'Ballingslov', 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, 'Bergstromshusen', 1230, 209, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (2816, 'Bjarnum', 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, 'Bromolla', 1272, 7595, 56.075510, 14.469580, 10);
INSERT INTO Tatorter VALUES (2836, 'Brosarp', 1270, 680, 55.716670, 14.116670, 31);
INSERT INTO Tatorter VALUES (2840, 'Bastad', 1278, 4961, 56.426890, 12.853390, NULL);
INSERT INTO Tatorter VALUES (2844, 'Backaskog', 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, 'Everod', 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, 'Fjalkinge', 1290, 1690, 56.050000, 14.283330, 10);
INSERT INTO Tatorter VALUES (2876, 'Farlov', 1290, 1026, 56.066670, 14.083330, 9);
INSERT INTO Tatorter VALUES (2880, 'Forslov', 1278, 2085, 56.350000, 12.816670, 61);
INSERT INTO Tatorter VALUES (2884, 'Glimakra', 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, 'Gualov', 1272, 530, 56.050000, 14.416670, 7);
INSERT INTO Tatorter VALUES (2896, 'Gards Kopinge', 1290, 936, 55.933330, 14.150000, 9);
INSERT INTO Tatorter VALUES (2900, 'Garsnas', 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, 'Hammenhog', 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, 'Hjarnarp', 1292, 975, 56.316670, 12.916670, 59);
INSERT INTO Tatorter VALUES (2920, 'Hjarsas', 1256, 229, 56.200000, 14.150000, 15);
INSERT INTO Tatorter VALUES (2924, 'Huarod', 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, 'Hassleholm', 1293, 18500, 56.159050, 13.766380, 77);
INSERT INTO Tatorter VALUES (2940, 'Hastveda', 1293, 1623, 56.266670, 13.933330, 113);
INSERT INTO Tatorter VALUES (2942, 'Hoja', 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, 'Linderod', 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, 'Lonsboda', 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 Asum', 1290, 1264, 55.983330, 14.150000, 8);
INSERT INTO Tatorter VALUES (3020, 'Nymolla', 1272, 272, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (3024, 'Nasum', 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, 'Roke', 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, 'Sjorrod', 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, 'Skanes-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, 'Strovelstorp', 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, 'Sosdala', 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, 'Vinno', 1290, 536, 56.050000, 14.083330, 6);
INSERT INTO Tatorter VALUES (3160, 'Vinslov', 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, 'Vittsjo', 1293, 1665, 61.116670, 16.100000, 379);
INSERT INTO Tatorter VALUES (3170, 'Vittskovle', 1290, 235, 55.900000, 13.183330, 59);
INSERT INTO Tatorter VALUES (3172, 'Vastra Karup', 1278, 582, 56.416670, 12.750000, 134);
INSERT INTO Tatorter VALUES (3180, 'Yngsjo', 1290, 302, 55.883330, 14.216670, 5);
INSERT INTO Tatorter VALUES (3184, 'Ahus', 1290, 9423, 55.916670, 14.283330, 7);
INSERT INTO Tatorter VALUES (3188, 'Asljunga', 1257, 659, 56.316670, 13.366670, 155);
INSERT INTO Tatorter VALUES (3192, 'Astorp', 1277, 9488, 56.135660, 12.944300, 20);
INSERT INTO Tatorter VALUES (3196, 'Angelholm', 1292, 23240, 56.242800, 12.862190, 7);
INSERT INTO Tatorter VALUES (3200, 'Onnestad', 1290, 1378, 56.050000, 14.016670, 10);
INSERT INTO Tatorter VALUES (3208, 'Orkelljunga', 1257, 4818, 56.283380, 13.277730, 120);
INSERT INTO Tatorter VALUES (3216, 'Osterslov', 1290, 414, 56.100000, 14.250000, 9);
INSERT INTO Tatorter VALUES (3220, 'Ostra Karup', 1278, 594, 56.416670, 12.950000, 9);
INSERT INTO Tatorter VALUES (3224, 'Ostra Ljungby', 1276, 935, 56.183330, 13.066670, 43);
INSERT INTO Tatorter VALUES (3228, 'Ostra Sonnarslov', 1290, 294, 55.883330, 14.016670, 28);
INSERT INTO Tatorter VALUES (3232, 'Ostra Tommarp', 1291, 284, 55.533330, 14.233330, 29);
INSERT INTO Tatorter VALUES (3300, 'Abbekas', 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, 'Anderslov', 1287, 1808, 55.433330, 13.333330, 42);
INSERT INTO Tatorter VALUES (3316, 'Annelov', 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, 'Barseback', 1261, 524, 55.766670, 12.950000, 12);
INSERT INTO Tatorter VALUES (3337, 'Barsebackshamn', 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, 'Bjarred', 1262, 9542, 55.716670, 13.016670, 7);
INSERT INTO Tatorter VALUES (3360, 'Bjarsjolagard', 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, 'Burlovs egnahem', 1231, 554, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (3376, 'Barslov', 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, 'Dosjebro', 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, 'Eslov', 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, 'Fladie', 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, 'Glumslov', 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, 'Gardstanga', 1285, 343, 55.766670, 13.350000, 40);
INSERT INTO Tatorter VALUES (3438, 'Gessie villastad', 1233, 497, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (3440, 'Harlosa', 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, 'Hjarup', 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, 'Haljarp', 1282, 2795, 57.633330, 15.450000, 189);
INSERT INTO Tatorter VALUES (3480, 'Torna Hallestad', 1281, 584, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (3484, 'Harslov', 1282, 382, 55.933330, 12.866670, 60);
INSERT INTO Tatorter VALUES (3488, 'Hoganas', 1284, 14107, 56.199710, 12.557950, 9);
INSERT INTO Tatorter VALUES (3492, 'Hokopinge', 1233, 1105, 55.483330, 13.016670, 18);
INSERT INTO Tatorter VALUES (3496, 'Hollviken', 1233, 10607, 55.416670, 12.950000, 7);
INSERT INTO Tatorter VALUES (3500, 'Horby', 1266, 7085, 55.852380, 13.660940, 72);
INSERT INTO Tatorter VALUES (3504, 'Hoor', 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, 'Ingelstrade', 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, 'Sodra Klagshamn', 1280, 1367, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (3528, 'Klagstorp', 1287, 323, 56.150000, 14.433330, 11);
INSERT INTO Tatorter VALUES (3532, 'Klagerup', 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, 'Kvarlov', 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, 'Kagerod', 1214, 1446, 56.016670, 13.100000, 141);
INSERT INTO Tatorter VALUES (3552, 'Kavlinge', 1261, 9049, 55.791880, 13.110210, 14);
INSERT INTO Tatorter VALUES (3556, 'Kopingebro', 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 Jagersbo', 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, 'Loberod', 1285, 1127, 55.783330, 13.500000, 108);
INSERT INTO Tatorter VALUES (3592, 'Loddekopinge', 1261, 6290, 55.766670, 13.016670, 9);
INSERT INTO Tatorter VALUES (3596, 'Loderup', 1286, 550, 55.433330, 14.116670, 14);
INSERT INTO Tatorter VALUES (3600, 'Lovestad', 1265, 643, 55.650000, 13.883330, 67);
INSERT INTO Tatorter VALUES (3604, 'Malmo', 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, 'Mjohult', 1284, 292, 57.683330, 15.733330, 195);
INSERT INTO Tatorter VALUES (3616, 'Molle', 1284, 715, 56.283330, 12.500000, 17);
INSERT INTO Tatorter VALUES (3620, 'Morarp', 1283, 1893, 56.066670, 12.866670, 19);
INSERT INTO Tatorter VALUES (3622, 'Norra Rorum', 1267, 204, 56.016670, 13.500000, 110);
INSERT INTO Tatorter VALUES (3632, 'Nybrostrand', 1286, 810, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (3634, 'Ormanas 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, 'Paarp', 1283, 2789, 56.600000, 12.933330, 6);
INSERT INTO Tatorter VALUES (3648, 'Revingeby', 1281, 545, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (3652, 'Rydeback', 1283, 5141, 55.966670, 12.766670, 10);
INSERT INTO Tatorter VALUES (3656, 'Rydsgard', 1264, 1361, 55.466670, 13.583330, 38);
INSERT INTO Tatorter VALUES (3658, 'Rangs sand', 1233, 808, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (3660, 'Rostanga', 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, 'Sjobo', 1265, 6724, 55.631350, 13.706220, 48);
INSERT INTO Tatorter VALUES (3668, 'Sjodiken', 1263, 438, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (3672, 'Skanor 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, 'Stockamollan', 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, 'Stangby', 1281, 1218, 59.766670, 16.833330, 34);
INSERT INTO Tatorter VALUES (3714, 'Sjobo sommarby och Svansjo sommarby', 1265, 668, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (3716, 'Svalov', 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, 'Satofta', 1267, 1348, 55.916670, 13.550000, 39);
INSERT INTO Tatorter VALUES (3732, 'Sodra Sandby', 1281, 6136, 56.566670, 16.616670, 24);
INSERT INTO Tatorter VALUES (3736, 'Sodra Vrams falad', 1260, 249, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (3738, 'Sovde', 1265, 291, 55.583330, 13.666670, 36);
INSERT INTO Tatorter VALUES (3740, 'Sovestad', 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, 'Tjornarp', 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, 'Tygelsjo', 1280, 2710, 55.516670, 13.000000, 25);
INSERT INTO Tatorter VALUES (3760, 'Tagarp', 1214, 431, 56.933330, 12.600000, 8);
INSERT INTO Tatorter VALUES (3764, 'Tanga och Rogle', 1283, 223, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (3766, 'Utvalinge', 1283, 227, 56.216670, 12.783330, NULL);
INSERT INTO Tatorter VALUES (3772, 'Vallakra', 1283, 642, 55.966670, 12.866670, 45);
INSERT INTO Tatorter VALUES (3776, 'Veberod', 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, 'Vollsjo', 1265, 836, 55.700000, 13.766670, 70);
INSERT INTO Tatorter VALUES (3800, 'Vastra Ingelstad', 1233, 721, 55.483330, 13.116670, 46);
INSERT INTO Tatorter VALUES (3802, 'Vastra Karaby', 1261, 229, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (3804, 'Vastra Klagstorp', 1280, 279, 55.533330, 12.983330, 12);
INSERT INTO Tatorter VALUES (3806, 'Vastra Tommarp', 1287, 214, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (3808, 'Ystad', 1286, 18350, 55.429660, 13.820410, 8);
INSERT INTO Tatorter VALUES (3812, 'Akarp', 1231, 5617, 58.233330, 13.650000, 167);
INSERT INTO Tatorter VALUES (3816, 'Asperod', 1265, 222, 58.149720, 12.116670, 17);
INSERT INTO Tatorter VALUES (3820, 'Odakra', 1283, 4920, 56.100000, 12.733330, 19);
INSERT INTO Tatorter VALUES (3828, 'Ortofta', 1285, 202, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (3830, 'Vaggarp', 1285, 211, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (3832, 'Ostra Grevie', 1233, 598, 55.466670, 13.133330, 44);
INSERT INTO Tatorter VALUES (3834, 'Onnekop', 1266, 206, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (3836, 'Ostraby', 1266, 200, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (3898, 'Roda 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, 'Bergagard', 1382, 250, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (3910, 'Brattas', 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, 'Bueras', 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, 'Fjaras kyrkby', 1384, 2321, 57.459130, 12.175080, 68);
INSERT INTO Tatorter VALUES (3932, 'Frillesas', 1384, 2044, 57.316670, 12.166670, 19);
INSERT INTO Tatorter VALUES (3934, 'Frosakull', 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 Hogas', 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, 'Hasslov', 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, 'Hjalm', 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, 'Hjalmared', 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, 'Klappa', 1384, 318, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (4000, 'Knared', 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, 'Kungsater', 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 Tjarby', 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, 'Langas', 1382, 534, 56.983330, 12.450000, 7);
INSERT INTO Tatorter VALUES (4042, 'Loftaskog', 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, 'Oskarstrom', 1380, 4071, 56.800000, 12.966670, 34);
INSERT INTO Tatorter VALUES (4058, 'Ringsegard', 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, 'Rydobruk', 1315, 388, 56.950000, 13.150000, 129);
INSERT INTO Tatorter VALUES (4072, 'Ranneslov', 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, 'Simlangsdalen', 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, 'Skreanas', 1382, 243, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (4096, 'Skrea', 1382, 1064, 56.883330, 12.566670, 5);
INSERT INTO Tatorter VALUES (4098, 'Skummeslovsstrand', 1381, 491, 56.466670, 12.916670, NULL);
INSERT INTO Tatorter VALUES (4100, 'Skallinge', 1383, 626, 57.183330, 12.466670, 97);
INSERT INTO Tatorter VALUES (4104, 'Sloinge', 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, 'Saro', 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, 'Traslovslage', 1383, 2600, 57.065830, 12.282780, 14);
INSERT INTO Tatorter VALUES (4122, 'Sodra Nas', 1383, 671, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (4124, 'Tronninge', 1380, 1504, 57.133330, 12.283330, 24);
INSERT INTO Tatorter VALUES (4128, 'Tronninge', 1383, 880, 57.133330, 12.283330, 24);
INSERT INTO Tatorter VALUES (4132, 'Tvaaker', 1383, 2534, 57.050000, 12.400000, 32);
INSERT INTO Tatorter VALUES (4134, 'Tylosand', 1380, 399, 56.650000, 12.733330, 15);
INSERT INTO Tatorter VALUES (4136, 'Tangaberg', 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, 'Vassback', 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, 'Villsharad', 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, 'Vaxtorp', 1381, 970, 56.433330, 13.100000, 85);
INSERT INTO Tatorter VALUES (4188, 'Varobacka', 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, 'Aled', 1380, 1634, 56.750000, 12.933330, 55);
INSERT INTO Tatorter VALUES (4196, 'Arstad', 1382, 284, 59.583330, 12.116670, 154);
INSERT INTO Tatorter VALUES (4200, 'Asa', 1384, 3369, 58.016670, 14.600000, 255);
INSERT INTO Tatorter VALUES (4204, 'Asby', 1383, 423, 59.933330, 18.283330, 27);
INSERT INTO Tatorter VALUES (4212, 'Alvsered', 1382, 433, 57.233330, 12.866670, 172);
INSERT INTO Tatorter VALUES (4216, 'Atran', 1382, 417, 57.116670, 12.950000, 130);
INSERT INTO Tatorter VALUES (4224, 'Vastra Hagen', 1384, 969, 57.424440, 11.935830, 33);
INSERT INTO Tatorter VALUES (4228, 'Olmanas', 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, 'Ammenas', 1485, 544, 58.308330, 11.833330, NULL);
INSERT INTO Tatorter VALUES (4298, 'Aspero', 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, 'Bjorlanda', 1480, 608, 57.766670, 11.833330, 22);
INSERT INTO Tatorter VALUES (4304, 'Bjorko', 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, 'Bosnas', 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, 'Branno', 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, 'Diserod', 1482, 1241, 57.916670, 12.016670, 34);
INSERT INTO Tatorter VALUES (4330, 'Djupedalen', 1487, 270, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (4332, 'Donso', 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, 'Ellos', 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, 'Fiskebackskil', 1484, 379, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (4344, 'Fjallbacka', 1435, 859, 59.049720, 12.566670, 147);
INSERT INTO Tatorter VALUES (4348, 'Foto', 1407, 620, 57.666670, 11.658330, NULL);
INSERT INTO Tatorter VALUES (4354, 'Hallingsjo', 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, 'Goteborg', 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, 'Hallsasasen', 1441, 408, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (4380, 'Hedekas', 1430, 370, 58.650000, 11.766670, 100);
INSERT INTO Tatorter VALUES (4384, 'Henan', 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, 'Hindas', 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, 'Hallesaker', 1481, 357, 57.600000, 13.170000, 173);
INSERT INTO Tatorter VALUES (4412, 'Hallevadsholm', 1430, 772, 58.583330, 11.533330, 89);
INSERT INTO Tatorter VALUES (4414, 'Halleviksstrand', 1421, 214, 58.125000, 11.450000, 20);
INSERT INTO Tatorter VALUES (4420, 'Halso', 1407, 611, 57.733330, 11.650000, NULL);
INSERT INTO Tatorter VALUES (4424, 'Harryda', 1401, 968, 57.654360, 12.363180, 145);
INSERT INTO Tatorter VALUES (4428, 'Hono', 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, 'Jorlanda', 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, 'Kladesholmen', 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, 'Kungalv', 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, 'Kahog', 1402, 832, 57.750000, 12.133330, 12);
INSERT INTO Tatorter VALUES (4468, 'Kallekarr', 1419, 560, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (4472, 'Kallered', 1481, 7456, 57.609920, 12.051060, 68);
INSERT INTO Tatorter VALUES (4476, 'Kallo-Knippla', 1407, 369, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (4480, 'Karna', 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, 'Lassby', 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, 'Mollosund', 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, 'Hoviksnas', 1419, 1309, 58.033330, 11.766670, NULL);
INSERT INTO Tatorter VALUES (4516, 'Myggenas', 1419, 1230, 58.061760, 11.749360, 13);
INSERT INTO Tatorter VALUES (4518, 'Mysterna', 1480, 3418, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (4520, 'Molnlycke', 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 Langenas', 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, 'Rixo', 1484, 357, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (4542, 'Rya', 1401, 290, 59.550000, 15.233330, 66);
INSERT INTO Tatorter VALUES (4544, 'Ravlanda', 1401, 1462, 57.650000, 12.500000, 139);
INSERT INTO Tatorter VALUES (4546, 'Rodbo', 1480, 278, 57.841670, 11.950000, 53);
INSERT INTO Tatorter VALUES (4548, 'Ronnang', 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, 'Roro', 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, 'Skarhamn', 1419, 3193, 57.986650, 11.557420, 20);
INSERT INTO Tatorter VALUES (4562, 'Slatten', 1482, 247, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (4564, 'Smogen', 1427, 1329, 58.355930, 11.224110, 3);
INSERT INTO Tatorter VALUES (4566, 'Starrkarr och Nas', 1415, 499, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (4568, 'Stenungsund', 1415, 9987, 58.070460, 11.818100, 23);
INSERT INTO Tatorter VALUES (4570, 'Stora Bugarde', 1401, 367, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (4572, 'Stora Dyron', 1419, 250, 57.933330, 11.616670, 1);
INSERT INTO Tatorter VALUES (4574, 'Stenared', 1480, 237, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (4576, 'Stora Hoga', 1415, 2751, 58.016670, 11.833330, 23);
INSERT INTO Tatorter VALUES (4578, 'Stenungson', 1415, 264, 58.066670, 11.800000, 3);
INSERT INTO Tatorter VALUES (4580, 'Strandnorum', 1415, 1251, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (4584, 'Stromstad', 1486, 6288, 58.939450, 11.171200, 23);
INSERT INTO Tatorter VALUES (4588, 'Styrso', 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, 'Save', 1480, 743, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (4598, 'Svenshogen', 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, 'Vrango', 1480, 364, 58.399720, 16.850000, NULL);
INSERT INTO Tatorter VALUES (4616, 'Vajern', 1427, 688, 58.383330, 11.266670, 25);
INSERT INTO Tatorter VALUES (4622, 'Annerod', 1486, 225, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (4624, 'Astol', 1419, 210, 57.916670, 11.583330, NULL);
INSERT INTO Tatorter VALUES (4628, 'Ockero', 1407, 3488, 57.708140, 11.655850, 1);
INSERT INTO Tatorter VALUES (4630, 'Odsmal', 1415, 608, 58.716670, 11.483330, 100);
INSERT INTO Tatorter VALUES (4631, 'Ojersjo', 1402, 3543, 57.700000, 12.116670, 145);
INSERT INTO Tatorter VALUES (4640, 'Tahult', 1401, 585, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (4700, 'Alingsas', 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, 'Ambjornarp', 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, 'Bjorboholm', 1441, 963, 57.883330, 12.316670, 74);
INSERT INTO Tatorter VALUES (4736, 'Bjorketorp', 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, 'Boras', 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, 'Bralanda', 1487, 1385, 58.566670, 12.366670, 63);
INSERT INTO Tatorter VALUES (4768, 'Backefors', 1460, 673, 58.800000, 12.166670, 170);
INSERT INTO Tatorter VALUES (4772, 'Dals Langed', 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, 'Dalsjofors', 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, 'Frufallan', 1490, 917, 57.783330, 12.966670, 161);
INSERT INTO Tatorter VALUES (4820, 'Frandefors', 1487, 613, 58.500000, 12.283330, 65);
INSERT INTO Tatorter VALUES (4828, 'Fargelanda', 1439, 1894, 58.568160, 11.992350, 99);
INSERT INTO Tatorter VALUES (4832, 'Grimsas', 1452, 721, 57.483330, 13.533330, 211);
INSERT INTO Tatorter VALUES (4836, 'Grabo', 1441, 4195, 57.833330, 12.300000, 105);
INSERT INTO Tatorter VALUES (4840, 'Grafsnas', 1489, 367, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (4848, 'Ganghester', 1490, 1526, 57.700000, 13.016670, 207);
INSERT INTO Tatorter VALUES (4852, 'Gallstad', 1491, 471, 57.666670, 13.433330, 219);
INSERT INTO Tatorter VALUES (4856, 'Gota', 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, 'Hjalmared', 1489, 260, 57.883330, 12.533330, 86);
INSERT INTO Tatorter VALUES (4872, 'Hjartum', 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, 'Hogsater', 1439, 705, 59.900000, 11.983330, 152);
INSERT INTO Tatorter VALUES (4904, 'Hokerum', 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, 'Langhem', 1452, 989, 57.600000, 13.233330, 175);
INSERT INTO Tatorter VALUES (4944, 'Lodose', 1462, 1266, 58.033330, 12.133330, 19);
INSERT INTO Tatorter VALUES (4948, 'Marback', 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, 'Mjoback', 1465, 294, 57.316670, 12.866670, 162);
INSERT INTO Tatorter VALUES (4960, 'Malsryd', 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, 'Nodinge-Nol', 1440, 9822, 57.912590, 12.055910, 22);
INSERT INTO Tatorter VALUES (4978, 'Nygard', 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, 'Rangedala', 1490, 392, 57.783330, 13.116670, 249);
INSERT INTO Tatorter VALUES (5004, 'Rannavag', 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, 'Sjomarken', 1490, 2829, 57.715330, 12.834950, 193);
INSERT INTO Tatorter VALUES (5032, 'Sjovik', 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, 'Skapafors', 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, 'Satila', 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, 'Arod 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, 'Trollhattan', 1488, 46457, 58.283650, 12.288640, 56);
INSERT INTO Tatorter VALUES (5086, 'Trulsegarden', 1480, 211, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (5088, 'Tradet', 1491, 277, 57.983330, 13.533330, 225);
INSERT INTO Tatorter VALUES (5092, 'Tollsjo', 1443, 369, 57.800000, 12.633330, 138);
INSERT INTO Tatorter VALUES (5096, 'Tosse', 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, 'Uppharad', 1488, 588, 58.166670, 12.283330, 82);
INSERT INTO Tatorter VALUES (5112, 'Vargon', 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, 'Vargarda', 1442, 5133, 58.037060, 12.809070, 118);
INSERT INTO Tatorter VALUES (5128, 'Vane-Asaka', 1488, 292, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (5132, 'Vanersborg', 1487, 21699, 58.380750, 12.323400, 60);
INSERT INTO Tatorter VALUES (5136, 'Vastra Bodarna', 1489, 1059, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (5140, 'Amal', 1492, 9065, 59.051000, 12.704920, 41);
INSERT INTO Tatorter VALUES (5144, 'Asensbruk', 1461, 522, 58.799720, 12.416670, 64);
INSERT INTO Tatorter VALUES (5152, 'Alvangen', 1440, 4196, 57.966670, 12.116670, 15);
INSERT INTO Tatorter VALUES (5156, 'Aspered', 1490, 287, 57.783330, 13.016670, 285);
INSERT INTO Tatorter VALUES (5160, 'Odeborg', 1439, 598, 58.545060, 11.974580, 97);
INSERT INTO Tatorter VALUES (5162, 'Ostadkulle', 1442, 245, 58.016670, 12.633330, 110);
INSERT INTO Tatorter VALUES (5164, 'Ostra Frolunda', 1465, 309, 57.333330, 13.016670, 151);
INSERT INTO Tatorter VALUES (5168, 'Overlida', 1465, 525, 57.350000, 12.883330, 201);
INSERT INTO Tatorter VALUES (5172, 'Oxaback', 1463, 300, 57.400000, 12.800000, 161);
INSERT INTO Tatorter VALUES (5176, 'Oxeryd', 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, 'Falkoping', 1499, 16350, 58.173470, 13.550680, 229);
INSERT INTO Tatorter VALUES (5240, 'Filsback', 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, 'Frammestad', 1445, 393, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (5252, 'Furusjo', 643, 325, 57.933330, 13.950000, 260);
INSERT INTO Tatorter VALUES (5260, 'Grastorp', 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, 'Gullspang', 1447, 1167, 58.986150, 14.096440, 48);
INSERT INTO Tatorter VALUES (5280, 'Gotene', 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, 'Hallekis', 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, 'Jarpas', 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, 'Kvanum', 1470, 1277, 58.300000, 13.183330, 82);
INSERT INTO Tatorter VALUES (5340, 'Kallby', 1471, 1586, 58.516670, 13.316670, 50);
INSERT INTO Tatorter VALUES (5344, 'Kattilstorp', 1499, 253, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (5348, 'Lerdala', 1496, 409, 58.483330, 13.716670, 111);
INSERT INTO Tatorter VALUES (5352, 'Lidkoping', 1494, 25644, 58.505170, 13.157650, 45);
INSERT INTO Tatorter VALUES (5356, 'Lugnas', 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, 'Madangsholm', 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, 'Mullsjo', 642, 5452, 57.917100, 13.878310, 286);
INSERT INTO Tatorter VALUES (5384, 'Molltorp', 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, 'Otterbacken', 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, 'Sjotorp', 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, 'Skovde', 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, 'Stopen', 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, 'Torbjorntorp', 1499, 475, 58.210240, 13.605970, 196);
INSERT INTO Tatorter VALUES (5476, 'Travad', 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, 'Toreboda', 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, 'Ulvaker', 1496, 254, 58.483330, 13.916670, 80);
INSERT INTO Tatorter VALUES (5496, 'Undenas', 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, 'Varing', 1496, 571, 58.500000, 13.950000, 70);
INSERT INTO Tatorter VALUES (5524, 'Varsas', 1496, 578, 58.350000, 14.050000, 122);
INSERT INTO Tatorter VALUES (5532, 'Asarp', 1499, 598, 58.033330, 13.566670, 221);
INSERT INTO Tatorter VALUES (5536, 'Algaras', 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, 'Ambjorby', 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, 'Bjorneborg', 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, 'Backhammar', 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, 'Fageras', 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, 'Jossefors', 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, 'Klassbol', 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, 'Eksharad', 1783, 1074, 60.172750, 13.496470, 150);
INSERT INTO Tatorter VALUES (5730, 'Hogboda', 1715, 262, 59.566670, 13.016670, 82);
INSERT INTO Tatorter VALUES (5732, 'Lesjofors', 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, 'Mjonas', 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, 'Rada', 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, 'Skattkarr', 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, 'Skare', 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, 'Stollet', 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, 'Syssleback', 1737, 527, 60.750000, 12.866670, 363);
INSERT INTO Tatorter VALUES (5840, 'Saffle', 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, 'Tocksfors', 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, 'Vallargardet', 1780, 382, 59.466670, 13.550000, 72);
INSERT INTO Tatorter VALUES (5862, 'Vidoasen', 1761, 272, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (5864, 'Valberg', 1780, 2770, 59.400000, 13.166670, 88);
INSERT INTO Tatorter VALUES (5868, 'Varmlandsbro', 1785, 501, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (5872, 'Vase', 1780, 494, 59.383330, 13.833330, 61);
INSERT INTO Tatorter VALUES (5876, 'Vastra Amtervik', 1766, 366, 59.733330, 13.133330, 104);
INSERT INTO Tatorter VALUES (5880, 'Amotfors', 1730, 1410, 59.766670, 12.366670, 82);
INSERT INTO Tatorter VALUES (5884, 'Arjang', 1765, 3228, 59.392170, 12.133360, 150);
INSERT INTO Tatorter VALUES (5888, 'Olme', 1781, 224, 59.366670, 14.000000, 47);
INSERT INTO Tatorter VALUES (5890, 'Orslosa', 1494, 307, 58.500000, 13.000000, 69);
INSERT INTO Tatorter VALUES (5892, 'Ostmark', 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, 'Finnerodja', 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, 'Frovi', 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, 'Hallabrottet', 1881, 1789, 59.116670, 15.200000, 61);
INSERT INTO Tatorter VALUES (5996, 'Hallefors', 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, 'Laxa', 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, 'Palsboda', 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, 'Rofors', 1860, 207, 58.950000, 14.616670, 125);
INSERT INTO Tatorter VALUES (6104, 'Ronneshytta', 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, 'Skollersta', 1861, 1131, 59.150000, 15.333330, 58);
INSERT INTO Tatorter VALUES (6116, 'Stora Mellosa', 1880, 776, 59.216670, 15.500000, 32);
INSERT INTO Tatorter VALUES (6120, 'Stora', 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, 'Strassa', 1885, 306, 59.750000, 15.216670, 256);
INSERT INTO Tatorter VALUES (6136, 'Stalldalen', 1864, 539, 59.933330, 14.933330, 194);
INSERT INTO Tatorter VALUES (6140, 'Svarta', 1862, 495, 65.033330, 20.766670, 184);
INSERT INTO Tatorter VALUES (6148, 'Vedevag', 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, 'Abytorp', 1881, 755, 59.116670, 15.066670, 60);
INSERT INTO Tatorter VALUES (6168, 'Ammeberg', 1882, 590, 58.866670, 15.000000, 88);
INSERT INTO Tatorter VALUES (6172, 'Asbro', 1882, 1164, 59.000000, 15.050000, 112);
INSERT INTO Tatorter VALUES (6176, 'As', 1884, 499, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (6178, 'Atorp', 1862, 212, 59.783330, 13.416670, 113);
INSERT INTO Tatorter VALUES (6184, 'Olmbrotorp', 1880, 548, 59.383060, 15.233060, 40);
INSERT INTO Tatorter VALUES (6188, 'Orebro', 1880, 107038, 59.274120, 15.206600, 30);
INSERT INTO Tatorter VALUES (6192, 'Ostansjo', 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, 'Barkaro', 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, 'Gotlunda', 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, 'Hokasen', 1980, 2956, 59.666670, 16.583330, 46);
INSERT INTO Tatorter VALUES (6244, 'Kolback', 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, 'Kungsor', 1960, 5452, 59.422450, 16.096560, 30);
INSERT INTO Tatorter VALUES (6266, 'Karsta och Bredsdal', 1980, 261, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (6268, 'Koping', 1983, 17743, 59.514040, 15.992550, 22);
INSERT INTO Tatorter VALUES (6272, 'Medaker', 1984, 224, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (6276, 'Morgongava', 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, 'Moklinta', 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, 'Ramnas', 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, 'Runhallen', 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, 'Stromsholm', 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, 'Satra brunn', 1981, 335, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (6340, 'Sorstafors', 1961, 278, 59.583330, 16.216670, 22);
INSERT INTO Tatorter VALUES (6342, 'Tido-Lindo', 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, 'Tarnsjo', 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, 'Vasterfarnebo', 1981, 477, 59.950000, 16.283330, 61);
INSERT INTO Tatorter VALUES (6376, 'Vasteras', 1980, 110877, 59.616170, 16.552760, 17);
INSERT INTO Tatorter VALUES (6382, 'Ortagarden', 1980, 460, 59.562800, 16.468440, 13);
INSERT INTO Tatorter VALUES (6384, 'Ostervala', 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, 'Bjursas', 2080, 1839, 60.733330, 15.433330, 181);
INSERT INTO Tatorter VALUES (6428, 'Bjorbo', 2026, 697, 60.450000, 14.700000, 275);
INSERT INTO Tatorter VALUES (6432, 'Blotberget', 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, 'Bonas', 2062, 457, 61.083330, 14.483330, 186);
INSERT INTO Tatorter VALUES (6444, 'Borlange', 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, 'Basna', 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, 'Jarna', 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, 'Djuras', 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, 'Farnas', 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, 'Gonas', 2085, 357, 60.150000, 15.100000, 156);
INSERT INTO Tatorter VALUES (6548, 'Grangarde', 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, 'Grangesberg', 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, 'Gullerasen', 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, 'Halvarsgardarna', 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, 'Haksberg', 2085, 458, 60.183330, 15.200000, 120);
INSERT INTO Tatorter VALUES (6584, 'Haradsbygden', 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, 'Insjon', 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, 'Langshyttan', 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, 'Mockfjard', 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 Gardsjo', 2031, 225, 60.933330, 15.216670, 209);
INSERT INTO Tatorter VALUES (6664, 'Nordano', 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, 'Nusnas', 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, 'Nas', 2021, 417, 60.450000, 14.483330, 232);
INSERT INTO Tatorter VALUES (6684, 'Nas bruk', 2084, 207, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (6692, 'Ornas', 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, 'Repbacken', 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, 'Rattvik', 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, 'Siljansnas', 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, 'Solleron', 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, 'Sunnansjo', 2085, 560, 64.100000, 19.350000, 204);
INSERT INTO Tatorter VALUES (6776, 'Svardsjo', 2080, 1251, 60.750000, 15.916670, 121);
INSERT INTO Tatorter VALUES (6780, 'Sagmyra', 2080, 546, 60.716670, 15.283330, 213);
INSERT INTO Tatorter VALUES (6784, 'Salen', 2023, 652, 61.150000, 13.266670, 367);
INSERT INTO Tatorter VALUES (6788, 'Sarna', 2039, 719, 61.692840, 13.142570, 424);
INSERT INTO Tatorter VALUES (6792, 'Sater', 2082, 4429, 60.347780, 15.750510, 151);
INSERT INTO Tatorter VALUES (6796, 'Soderbarke', 2061, 924, 60.073880, 15.564280, 79);
INSERT INTO Tatorter VALUES (6804, 'Sorvik', 2085, 743, 64.133330, 15.716670, 368);
INSERT INTO Tatorter VALUES (6806, 'Torsang', 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, 'Tallberg', 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, 'Vattnas', 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, 'Vinas', 2062, 329, 60.966670, 14.533330, 176);
INSERT INTO Tatorter VALUES (6864, 'Vamhus', 2062, 857, 61.133330, 14.466670, 173);
INSERT INTO Tatorter VALUES (6872, 'Vastanvik', 2029, 385, 60.733330, 14.950000, 162);
INSERT INTO Tatorter VALUES (6880, 'Vasterby', 2083, 368, 63.316670, 18.316670, 162);
INSERT INTO Tatorter VALUES (6884, 'Vastermyckelang', 2039, 279, 61.200000, 14.033330, 300);
INSERT INTO Tatorter VALUES (6892, 'Asen', 2039, 246, 64.600000, 20.000000, 240);
INSERT INTO Tatorter VALUES (6896, 'Alvdalen', 2039, 1810, 61.227740, 14.039350, 253);
INSERT INTO Tatorter VALUES (6900, 'Appelbo', 2021, 258, 60.483330, 14.000000, 273);
INSERT INTO Tatorter VALUES (6912, 'Ostnor', 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, 'Arbra', 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, 'Bergsjo', 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, 'Bjorke', 2180, 349, 60.766670, 17.200000, 17);
INSERT INTO Tatorter VALUES (7036, 'Bollnas', 2183, 12842, 61.348170, 16.394640, 38);
INSERT INTO Tatorter VALUES (7038, 'Bonan', 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, 'Enanger', 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, 'Farila', 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, 'Gavle', 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, 'Hamrangefjarden', 2180, 509, 60.900000, 17.066670, 1);
INSERT INTO Tatorter VALUES (7096, 'Harmanger', 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, 'Halsjo', 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, 'Jaderfors', 2181, 284, 60.683330, 16.666670, 76);
INSERT INTO Tatorter VALUES (7144, 'Jadraas', 2101, 220, 60.850000, 16.466670, 206);
INSERT INTO Tatorter VALUES (7148, 'Jarbo', 2181, 1801, 60.716670, 16.600000, 111);
INSERT INTO Tatorter VALUES (7152, 'Jarvso', 2161, 1407, 61.716670, 16.166670, 111);
INSERT INTO Tatorter VALUES (7154, 'Jattendal', 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, 'Kungsgarden', 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, 'Maga-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, 'Njutanger', 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, 'Nasviken', 2184, 924, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (7236, 'Ockelbo', 2101, 2724, 60.891200, 16.718460, 59);
INSERT INTO Tatorter VALUES (7240, 'Ovanaker', 2121, 212, 61.362500, 15.892710, 148);
INSERT INTO Tatorter VALUES (7252, 'Rengsjo', 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, 'Stromsbruk', 2132, 362, 61.870280, 17.315560, 15);
INSERT INTO Tatorter VALUES (7308, 'Salgsjon', 2180, 207, 60.617680, 17.113180, 53);
INSERT INTO Tatorter VALUES (7312, 'Soderala', 2182, 949, 61.283330, 16.966670, 11);
INSERT INTO Tatorter VALUES (7316, 'Soderhamn', 2182, 11761, 61.303730, 17.059210, 2);
INSERT INTO Tatorter VALUES (7320, 'Sorforsa', 2184, 1574, 61.733330, 16.983330, 54);
INSERT INTO Tatorter VALUES (7324, 'Tallasen', 2161, 586, 64.300000, 18.833330, 275);
INSERT INTO Tatorter VALUES (7332, 'Torsaker', 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, 'Trodje', 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, 'Vannsatter', 2182, 434, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (7360, 'Viksjofors', 2121, 244, 61.333330, 15.950000, 162);
INSERT INTO Tatorter VALUES (7364, 'Vasterberg', 2181, 242, 61.216670, 16.516670, 68);
INSERT INTO Tatorter VALUES (7368, 'Abyggeby', 2180, 811, 60.916670, 16.650000, 75);
INSERT INTO Tatorter VALUES (7372, 'Amot', 2101, 277, 60.966670, 16.450000, 175);
INSERT INTO Tatorter VALUES (7376, 'Arsunda', 2181, 1008, 60.533330, 16.733330, 48);
INSERT INTO Tatorter VALUES (7380, 'Ashammar', 2181, 727, 60.650000, 16.533330, 92);
INSERT INTO Tatorter VALUES (7384, 'Osterfarnebo', 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, 'Arnasvall', 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, 'Bjasta', 2284, 1808, 63.200000, 18.500000, 33);
INSERT INTO Tatorter VALUES (7428, 'Bjorna', 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, 'Dingersjo', 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, 'Frano', 2282, 640, 62.900000, 17.833330, 47);
INSERT INTO Tatorter VALUES (7472, 'Fransta', 2260, 1256, 62.500000, 16.150000, 57);
INSERT INTO Tatorter VALUES (7476, 'Gidea', 2284, 266, 63.550000, 18.616670, 124);
INSERT INTO Tatorter VALUES (7478, 'Gustavsberg', 2281, 254, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (7480, 'Gimat', 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, 'Harnosand', 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, 'Juniskar', 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, 'Kopmanholmen', 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, 'Langsele', 2283, 1584, 64.816670, 20.250000, 193);
INSERT INTO Tatorter VALUES (7576, 'Langviksmon', 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, 'Mjallom', 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, 'Nedansjo', 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, 'Nordingra', 2282, 306, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (7616, 'Nyland', 2282, 903, 64.816670, 20.766670, 103);
INSERT INTO Tatorter VALUES (7620, 'Nasaker', 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, 'Sandslan', 2282, 272, 63.016670, 17.783330, 1);
INSERT INTO Tatorter VALUES (7644, 'Sidensjo', 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, 'Solleftea', 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, 'Stode', 2281, 572, 62.416670, 16.600000, 76);
INSERT INTO Tatorter VALUES (7680, 'Ullanger', 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, 'Soraker', 2262, 2312, 62.505000, 17.513330, 91);
INSERT INTO Tatorter VALUES (7704, 'Timra', 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, 'Utansjo', 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, 'Vasterhus', 2284, 326, 63.333330, 18.550000, 136);
INSERT INTO Tatorter VALUES (7732, 'Amynnet', 2284, 340, 63.183330, 18.516670, 2);
INSERT INTO Tatorter VALUES (7736, 'Ange', 2260, 2872, 62.524950, 15.659040, 168);
INSERT INTO Tatorter VALUES (7740, 'Alandsbro', 2280, 832, 62.666670, 17.833330, 19);
INSERT INTO Tatorter VALUES (7744, 'Ornskoldsvik', 2284, 28991, 63.290910, 18.715250, 1);
INSERT INTO Tatorter VALUES (7748, 'Ostavall', 2260, 222, 62.433330, 15.466670, 250);
INSERT INTO Tatorter VALUES (7752, 'Osterforse', 2283, 204, 63.150000, 17.016670, 155);
INSERT INTO Tatorter VALUES (7756, 'Overhornas', 2284, 603, 63.300000, 18.550000, 1);
INSERT INTO Tatorter VALUES (7800, 'Aspas', 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, 'Ostra Bispgarden', 2303, 279, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (7808, 'Vastra Bispgarden', 2303, 518, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (7810, 'Bjornange', 2321, 254, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (7812, 'Brunflo', 2380, 3890, 63.075860, 14.832030, 339);
INSERT INTO Tatorter VALUES (7816, 'Bracke', 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, 'Dvarsatt', 2309, 461, 63.316670, 14.466670, 310);
INSERT INTO Tatorter VALUES (7828, 'Funasdalen', 2361, 890, 62.533330, 12.550000, 583);
INSERT INTO Tatorter VALUES (7836, 'Follinge', 2309, 485, 63.666670, 14.616670, 310);
INSERT INTO Tatorter VALUES (7840, 'Gaddede', 2313, 401, 64.500000, 14.150000, 356);
INSERT INTO Tatorter VALUES (7844, 'Gallo', 2305, 725, 62.916670, 15.233330, 296);
INSERT INTO Tatorter VALUES (7848, 'Hackas', 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, 'Haggenas', 2380, 320, 63.383330, 14.883330, 277);
INSERT INTO Tatorter VALUES (7884, 'Jarpen', 2321, 1408, 63.350000, 13.483330, 344);
INSERT INTO Tatorter VALUES (7886, 'Klovsjo', 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, 'Kalarne', 2305, 451, 62.983330, 16.083330, 277);
INSERT INTO Tatorter VALUES (7904, 'Lillhardal', 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, 'Morsil', 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, 'Nalden', 2309, 873, 63.350000, 14.250000, 321);
INSERT INTO Tatorter VALUES (7934, 'Nasviken', 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, 'Rosson', 2313, 352, 63.933330, 16.350000, 215);
INSERT INTO Tatorter VALUES (7960, 'Stromsund', 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, 'Trangsviken', 2309, 288, 63.333330, 14.016670, 300);
INSERT INTO Tatorter VALUES (7996, 'Ulvkalla', 2361, 456, 62.016670, 14.350000, 368);
INSERT INTO Tatorter VALUES (8000, 'Undersaker', 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, 'Ytteran', 2309, 204, 63.317660, 14.170370, 300);
INSERT INTO Tatorter VALUES (8024, 'Are', 2321, 1417, 63.398350, 13.080190, 379);
INSERT INTO Tatorter VALUES (8028, 'As', 2309, 1218, 63.248000, 14.560600, NULL);
INSERT INTO Tatorter VALUES (8032, 'Asarne', 2326, 268, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (8040, 'Ange', 2309, 314, 63.600000, 13.216670, 700);
INSERT INTO Tatorter VALUES (8044, 'Ostersund', 2380, 44327, 63.179200, 14.635660, 328);
INSERT INTO Tatorter VALUES (8112, 'Bastutrask', 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, 'Brannland', 2480, 220, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (8142, 'Bullmark', 2480, 319, 64.033330, 20.466670, 86);
INSERT INTO Tatorter VALUES (8144, 'Burea', 2482, 2360, 64.616670, 21.200000, 6);
INSERT INTO Tatorter VALUES (8148, 'Burtrask', 2482, 1575, 64.516670, 20.650000, 89);
INSERT INTO Tatorter VALUES (8152, 'Bygdea', 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, 'Grano', 2404, 238, 59.933330, 18.883330, 23);
INSERT INTO Tatorter VALUES (8196, 'Hissjon', 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, 'Hallnas', 2404, 259, 65.450000, 16.000000, 393);
INSERT INTO Tatorter VALUES (8208, 'Hornefors', 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, 'Jorn', 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, 'Kage', 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, 'Logdea', 2401, 394, 63.533330, 19.400000, 39);
INSERT INTO Tatorter VALUES (8240, 'Lovanger', 2482, 761, 64.366670, 21.300000, 6);
INSERT INTO Tatorter VALUES (8244, 'Mala', 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, 'Norsjo', 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, 'Roback', 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, 'Skelleftea', 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, 'Stocke', 2480, 483, 63.733330, 20.216670, 8);
INSERT INTO Tatorter VALUES (8334, 'Stocksjo', 2480, 215, 63.766670, 20.166670, 42);
INSERT INTO Tatorter VALUES (8336, 'Savar', 2480, 2670, 63.903830, 20.550140, 41);
INSERT INTO Tatorter VALUES (8340, 'Drangsmark', 2482, 333, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (8342, 'Sodra Bergsbyn och Stackgronnan', 2482, 393, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (8344, 'Sorfors', 2480, 403, 64.133330, 20.633330, 101);
INSERT INTO Tatorter VALUES (8348, 'Sormjole', 2480, 212, 63.683330, 20.000000, 6);
INSERT INTO Tatorter VALUES (8352, 'Tavelsjo', 2480, 245, 64.033330, 20.100000, 142);
INSERT INTO Tatorter VALUES (8356, 'Tvaralund', 2404, 257, 64.100000, 19.683330, 205);
INSERT INTO Tatorter VALUES (8360, 'Taftea', 2480, 1231, 63.833330, 20.483330, 13);
INSERT INTO Tatorter VALUES (8364, 'Tarnaby', 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, 'Umea', 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, 'Vannas', 2460, 4118, 63.906760, 19.757120, 81);
INSERT INTO Tatorter VALUES (8388, 'Vannasby', 2460, 1552, 63.933330, 19.833330, 78);
INSERT INTO Tatorter VALUES (8390, 'Vastibyn', 2480, 234, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (8392, 'Amsele', 2404, 209, 64.533330, 19.333330, 199);
INSERT INTO Tatorter VALUES (8394, 'Yttersjo', 2480, 384, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (8396, 'Anaset', 2409, 610, 65.450000, 20.883330, 180);
INSERT INTO Tatorter VALUES (8400, 'Asele', 2463, 1798, 64.166670, 17.333330, 317);
INSERT INTO Tatorter VALUES (8408, 'Orviken', 2482, 395, 64.675330, 21.197430, 1);
INSERT INTO Tatorter VALUES (8412, 'Overboda', 2480, 218, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (8504, 'Alvik', 2580, 777, 65.567931, 21.776179, NULL);
INSERT INTO Tatorter VALUES (8508, 'Antnas', 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, 'Bergnaset', 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, 'Blasmark', 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, 'Brandon', 2580, 287, 65.700000, 22.333330, 12);
INSERT INTO Tatorter VALUES (8560, 'Batskarsnas', 2514, 296, 65.783330, 23.416670, NULL);
INSERT INTO Tatorter VALUES (8564, 'Balinge', 2580, 307, 65.634210, 21.928370, 2);
INSERT INTO Tatorter VALUES (8568, 'Bole', 2581, 424, 64.366670, 21.358330, 21);
INSERT INTO Tatorter VALUES (8576, 'Ersnas', 2580, 292, 65.533330, 21.800000, 2);
INSERT INTO Tatorter VALUES (8578, 'Gammelgarden', 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, 'Glommerstrask', 2505, 272, 65.262020, 19.639430, 374);
INSERT INTO Tatorter VALUES (8596, 'Gallivare', 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, 'Hedenaset', 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, 'Jukkasjarvi', 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, 'Jamton', 2580, 237, 65.850000, 22.500000, 19);
INSERT INTO Tatorter VALUES (8648, 'Javre', 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, 'Klovertrask', 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, 'Korstrask', 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, 'Lulea', 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, 'Morjarv', 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, 'Mattsund', 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, 'Norrfjarden', 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, 'Person', 2580, 223, 65.740080, 22.166980, 12);
INSERT INTO Tatorter VALUES (8792, 'Pitea', 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, 'Palang', 2514, 278, 62.383330, 17.150000, 69);
INSERT INTO Tatorter VALUES (8812, 'Risogrund', 2514, 697, 65.800000, 23.250000, NULL);
INSERT INTO Tatorter VALUES (8816, 'Roknas', 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, 'Ranea', 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, 'Seskaro', 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, 'Svartla', 2582, 201, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (8876, 'Svensbyn', 2581, 342, 65.300000, 21.233330, 39);
INSERT INTO Tatorter VALUES (8878, 'Savast', 2582, 3148, 65.770020, 21.731130, 21);
INSERT INTO Tatorter VALUES (8880, 'Sodra 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, 'Tore', 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, 'Visttrask', 2560, 248, NULL, NULL, NULL);
INSERT INTO Tatorter VALUES (8912, 'Vittangi', 2584, 784, 67.675890, 21.642040, 252);
INSERT INTO Tatorter VALUES (8916, 'Vittjarv', 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, 'Alvsbyn', 2560, 4967, 65.676240, 21.001620, 33);
INSERT INTO Tatorter VALUES (8940, 'Overkalix', 2513, 975, 66.327540, 22.844140, 41);
INSERT INTO Tatorter VALUES (8944, 'Overtornea', 2518, 1917, 66.387780, 23.654250, 54);
INSERT INTO Tatorter VALUES (8948, 'Ovre Soppero', 2584, 201, 68.083330, 21.683330, 364);

-- Nu nar tatorterna finns kan vi lagga in residensstaderna

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 lan';
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 lan';
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 lan';
UPDATE Lan SET residensstad = (SELECT Tatorter.kod FROM Tatorter, Kommuner WHERE Tatorter.kommun = Kommuner.kod and Tatorter.namn = 'Gavle' and Kommuner.namn = 'Gavle kommun') where Namn = 'Gavleborgs lan';
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 lan';
UPDATE Lan SET residensstad = (SELECT Tatorter.kod FROM Tatorter, Kommuner WHERE Tatorter.kommun = Kommuner.kod and Tatorter.namn = 'Ostersund' and Kommuner.namn = 'Ostersunds kommun') where Namn = 'Jamtlands lan';
UPDATE Lan SET residensstad = (SELECT Tatorter.kod FROM Tatorter, Kommuner WHERE Tatorter.kommun = Kommuner.kod and Tatorter.namn = 'Jonkoping' and Kommuner.namn = 'Jonkopings kommun') where Namn = 'Jonkopings lan';
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 lan';
UPDATE Lan SET residensstad = (SELECT Tatorter.kod FROM Tatorter, Kommuner WHERE Tatorter.kommun = Kommuner.kod and Tatorter.namn = 'Vaxjo' and Kommuner.namn = 'Vaxjo kommun') where Namn = 'Kronobergs lan';
UPDATE Lan SET residensstad = (SELECT Tatorter.kod FROM Tatorter, Kommuner WHERE Tatorter.kommun = Kommuner.kod and Tatorter.namn = 'Lulea' and Kommuner.namn = 'Lulea kommun') where Namn = 'Norrbottens lan';
UPDATE Lan SET residensstad = (SELECT Tatorter.kod FROM Tatorter, Kommuner WHERE Tatorter.kommun = Kommuner.kod and Tatorter.namn = 'Malmo' and Kommuner.namn = 'Malmo kommun') where Namn = 'Skane lan';
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 lan';
UPDATE Lan SET residensstad = (SELECT Tatorter.kod FROM Tatorter, Kommuner WHERE Tatorter.kommun = Kommuner.kod and Tatorter.namn = 'Nykoping' and Kommuner.namn = 'Nykopings kommun') where Namn = 'Sodermanlands lan';
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 lan';
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 = 'Varmlands lan';
UPDATE Lan SET residensstad = (SELECT Tatorter.kod FROM Tatorter, Kommuner WHERE Tatorter.kommun = Kommuner.kod and Tatorter.namn = 'Umea' and Kommuner.namn = 'Umea kommun') where Namn = 'Vasterbottens lan';
UPDATE Lan SET residensstad = (SELECT Tatorter.kod FROM Tatorter, Kommuner WHERE Tatorter.kommun = Kommuner.kod and Tatorter.namn = 'Harnosand' and Kommuner.namn = 'Harnosands kommun') where Namn = 'Vasternorrlands lan';
UPDATE Lan SET residensstad = (SELECT Tatorter.kod FROM Tatorter, Kommuner WHERE Tatorter.kommun = Kommuner.kod and Tatorter.namn = 'Vasteras' and Kommuner.namn = 'Vasteras kommun') where Namn = 'Vastmanlands lan';
UPDATE Lan SET residensstad = (SELECT Tatorter.kod FROM Tatorter, Kommuner WHERE Tatorter.kommun = Kommuner.kod and Tatorter.namn = 'Goteborg' and Kommuner.namn = 'Goteborgs kommun') where Namn = 'Vastra Gotalands lan';
UPDATE Lan SET residensstad = (SELECT Tatorter.kod FROM Tatorter, Kommuner WHERE Tatorter.kommun = Kommuner.kod and Tatorter.namn = 'Orebro' and Kommuner.namn = 'Orebro kommun') where Namn = 'Orebro lan';
UPDATE Lan SET residensstad = (SELECT Tatorter.kod FROM Tatorter, Kommuner WHERE Tatorter.kommun = Kommuner.kod and Tatorter.namn = 'Linkoping' and Kommuner.namn = 'Linkopings kommun') where Namn = 'Ostergotlands lan';

-- Nu ska det finnas 21 lan, 290 kommunr och 1956 tatorter

SELECT COUNT(*) FROM Lan;
SELECT COUNT(*) FROM Kommuner;
SELECT COUNT(*) FROM Tatorter;