
INSERT INTO `#__wj_portal_cities` ( `name`, `localname`, `internationalname`, `stateid`, `countryid`, `isedit`, `enabled`, `serverid`, `latitude`, `longitude`) VALUES 
("Turku", "Turku", "Turku", NULL, 57, 0, 1, NULL, "60.4517531", "22.2670522"),
("Pori", "Pori", "Pori", NULL, 57, 0, 1, NULL, "61.4865542", "21.7968951"),
("Vaasa", "Vaasa", "Vaasa", NULL, 57, 0, 1, NULL, "63.0957722", "21.6159187"),
("Salo", "Salo", "Salo", NULL, 57, 0, 1, NULL, "60.3846716", "23.1286377"),
("Espoo", "Espoo", "Espoo", NULL, 57, 0, 1, NULL, "60.2047672", "24.6568435"),
("Helsinki", "Helsinki", "Helsinki", NULL, 57, 0, 1, NULL, "60.1674881", "24.9427473"),
("Vantaa", "Vantaa", "Vantaa", NULL, 57, 0, 1, NULL, "60.2921321", "25.0411832"),
("Tampere", "Tampere", "Tampere", NULL, 57, 0, 1, NULL, "61.4980214", "23.7603118"),
("Hämeenlinna", "Hämeenlinna", "Hämeenlinna", NULL, 57, 0, 1, NULL, "60.9948584", "24.46654"),
("Kotka", "Kotka", "Kotka", NULL, 57, 0, 1, NULL, "60.4674228", "26.9450844"),
("Lahti", "Lahti", "Lahti", NULL, 57, 0, 1, NULL, "60.9826014", "25.6613764"),
("Mikkeli", "Mikkeli", "Mikkeli", NULL, 57, 0, 1, NULL, "61.6877956", "27.2726569"),
("Lappeenranta", "Lappeenranta", "Lappeenranta", NULL, 57, 0, 1, NULL, "61.0583713", "28.1862742"),
("Seinäjoki", "Seinäjoki", "Seinäjoki", NULL, 57, 0, 1, NULL, "62.7954104", "22.8442015"),
("Kokkola", "Kokkola", "Kokkola", NULL, 57, 0, 1, NULL, "63.8391421", "23.1336845"),
("Jyväskylä", "Jyväskylä", "Jyväskylä", NULL, 57, 0, 1, NULL, "62.2417066", "25.7495727"),
("Kuopio", "Kuopio", "Kuopio", NULL, 57, 0, 1, NULL, "62.8924601", "27.6781839"),
("Kajaani", "Kajaani", "Kajaani", NULL, 57, 0, 1, NULL, "64.2240872", "27.7334227"),
("Oulu", "Oulu", "Oulu", NULL, 57, 0, 1, NULL, "65.0118734", "25.4716809"),
("Rovaniemi", "Rovaniemi", "Rovaniemi", NULL, 57, 0, 1, NULL, "66.5025657", "25.73122"),
("Joensuu", "Joensuu", "Joensuu", NULL, 57, 0, 1, NULL, "62.6005753", "29.7622128"),
("Aanekoski", "Aanekoski", "Aanekoski", NULL, 57, 0, 1, NULL, "62.6014659", "25.7278807"),
("Ahtari", "Ahtari", "Ahtari", NULL, 57, 0, 1, NULL, "62.5502478", "24.0694098"),
("Akaa", "Akaa", "Akaa", NULL, 57, 0, 1, NULL, "61.1677422", "23.8673424"),
("Alajarvi", "Alajarvi", "Alajarvi", NULL, 57, 0, 1, NULL, "63.0001054", "23.8159263"),
("Alavus", "Alavus", "Alavus", NULL, 57, 0, 1, NULL, "62.5864513", "23.6186654"),
("Anjala", "Anjala", "Anjala", NULL, 57, 0, 1, NULL, "60.6886864", "26.8079518"),
("Asikkala", "Asikkala", "Asikkala", NULL, 57, 0, 1, NULL, "61.1721358", "25.5471382"),
("Ekenas", "Ekenas", "Ekenas", NULL, 57, 0, 1, NULL, "59.9741851", "23.4375724"),
("Elimaki", "Elimaki", "Elimaki", NULL, 57, 0, 1, NULL, "60.7213103", "26.4509427"),
("Eno", "Eno", "Eno", NULL, 57, 0, 1, NULL, "62.7934143", "30.158627"),
("Eura", "Eura", "Eura", NULL, 57, 0, 1, NULL, "61.1295802", "22.1309558"),
("Eurajoki", "Eurajoki", "Eurajoki", NULL, 57, 0, 1, NULL, "61.2023562", "21.7339845"),
("Forssa", "Forssa", "Forssa", NULL, 57, 0, 1, NULL, "60.8146319", "23.6339467"),
("Hameenkyro", "Hameenkyro", "Hameenkyro", NULL, 57, 0, 1, NULL, "61.6383264", "23.196349"),
("Haapajarvi", "Haapajarvi", "Haapajarvi", NULL, 57, 0, 1, NULL, "63.7486624", "25.3180682"),
("Haapavesi", "Haapavesi", "Haapavesi", NULL, 57, 0, 1, NULL, "64.1373573", "25.3669422"),
("Halikko", "Halikko", "Halikko", NULL, 57, 0, 1, NULL, "60.397278", "23.0778126"),
("Hamina", "Hamina", "Hamina", NULL, 57, 0, 1, NULL, "60.5693374", "27.1878318"),
("Hankasalmi", "Hankasalmi", "Hankasalmi", NULL, 57, 0, 1, NULL, "62.3894407", "26.4361327"),
("Hanko", "Hanko", "Hanko", NULL, 57, 0, 1, NULL, "59.834482", "22.964781"),
("Harjavalta", "Harjavalta", "Harjavalta", NULL, 57, 0, 1, NULL, "61.3137102", "22.1413063"),
("Haukipudas", "Haukipudas", "Haukipudas", NULL, 57, 0, 1, NULL, "65.1762807", "25.3531972"),
("Hausjarvi", "Hausjarvi", "Hausjarvi", NULL, 57, 0, 1, NULL, "60.7864735", "25.0270946"),
("Heinola", "Heinola", "Heinola", NULL, 57, 0, 1, NULL, "61.2102113", "26.0457548"),
("Hollola", "Hollola", "Hollola", NULL, 57, 0, 1, NULL, "60.9887015", "25.5163229"),
("Huittinen", "Huittinen", "Huittinen", NULL, 57, 0, 1, NULL, "61.1760632", "22.698071"),
("Hyvinkaa", "Hyvinkaa", "Hyvinkaa", NULL, 57, 0, 1, NULL, "60.6299525", "24.8580797"),
("Ii", "Ii", "Ii", NULL, 57, 0, 1, NULL, "65.3124958", "25.3829275"),
("Iisalmi", "Iisalmi", "Iisalmi", NULL, 57, 0, 1, NULL, "63.5694237", "27.1826451");
