
INSERT INTO `#__wj_portal_cities` ( `name`, `localname`, `internationalname`, `stateid`, `countryid`, `isedit`, `enabled`, `serverid`, `latitude`, `longitude`) VALUES 
("Tallinn", "Tallinn", "Tallinn", NULL, 56, 0, 1, NULL, "59.4372155", "24.7453688"),
("Tartu", "Tartu", "Tartu", NULL, 56, 0, 1, NULL, "58.3801207", "26.72245"),
("Ulenurme", "Ulenurme", "Ulenurme", NULL, 56, 0, 1, NULL, "58.3152423", "26.7213332"),
("Abja-Paluoja", "Abja-Paluoja", "Abja-Paluoja", NULL, 56, 0, 1, NULL, "58.1261942", "25.3558311"),
("Arukula", "Arukula", "Arukula", NULL, 56, 0, 1, NULL, "59.365784", "25.0819151"),
("Aseri", "Aseri", "Aseri", NULL, 56, 0, 1, NULL, "59.4520561", "26.8687946"),
("Audru", "Audru", "Audru", NULL, 56, 0, 1, NULL, "58.4146092", "24.3218542"),
("Elva", "Elva", "Elva", NULL, 56, 0, 1, NULL, "58.2213885", "26.4078362"),
("Haabneeme", "Haabneeme", "Haabneeme", NULL, 56, 0, 1, NULL, "59.5133999", "24.8192999"),
("Haapsalu", "Haapsalu", "Haapsalu", NULL, 56, 0, 1, NULL, "58.9482486", "23.5370534"),
("Haljala", "Haljala", "Haljala", NULL, 56, 0, 1, NULL, "59.4310564", "26.2664249"),
("Jarva- Jaani", "Jarva- Jaani", "Jarva- Jaani", NULL, 56, 0, 1, NULL, "59.0389202", "25.8823519"),
("Jarvakandi", "Jarvakandi", "Jarvakandi", NULL, 56, 0, 1, NULL, "58.7786849", "24.8170215"),
("Jogeva", "Jogeva", "Jogeva", NULL, 56, 0, 1, NULL, "58.7462917", "26.3972118"),
("Johvi", "Johvi", "Johvi", NULL, 56, 0, 1, NULL, "59.3573116", "27.4136646"),
("Juri", "Juri", "Juri", NULL, 56, 0, 1, NULL, "59.3588438", "24.9117257"),
("Kardla", "Kardla", "Kardla", NULL, 56, 0, 1, NULL, "58.4451679", "26.560122"),
("Kadrina", "Kadrina", "Kadrina", NULL, 56, 0, 1, NULL, "59.3419992", "26.1304916"),
("Kallaste", "Kallaste", "Kallaste", NULL, 56, 0, 1, NULL, "57.7518", "27.0634999"),
("Karksi-Nuia", "Karksi-Nuia", "Karksi-Nuia", NULL, 56, 0, 1, NULL, "58.1048945", "25.5475385"),
("Kehra", "Kehra", "Kehra", NULL, 56, 0, 1, NULL, "59.333951", "25.3325146"),
("Kehtna", "Kehtna", "Kehtna", NULL, 56, 0, 1, NULL, "58.9259739", "24.8724018"),
("Keila", "Keila", "Keila", NULL, 56, 0, 1, NULL, "59.3082327", "24.4258028"),
("Kilingi- Nomme", "Kilingi- Nomme", "Kilingi- Nomme", NULL, 56, 0, 1, NULL, "58.1483629", "24.9513594"),
("Kivioli", "Kivioli", "Kivioli", NULL, 56, 0, 1, NULL, "59.3559924", "26.9669312"),
("Koeru", "Koeru", "Koeru", NULL, 56, 0, 1, NULL, "58.9641719", "26.028961"),
("Kohila", "Kohila", "Kohila", NULL, 56, 0, 1, NULL, "59.1676314", "24.7500277"),
("Kohtla- Jarve", "Kohtla- Jarve", "Kohtla- Jarve", NULL, 56, 0, 1, NULL, "59.3974738", "27.2797506"),
("Kohtla- Nomme", "Kohtla- Nomme", "Kohtla- Nomme", NULL, 56, 0, 1, NULL, "59.354719", "27.1916495"),
("Kose", "Kose", "Kose", NULL, 56, 0, 1, NULL, "59.1845204", "25.1669197"),
("Kunda", "Kunda", "Kunda", NULL, 56, 0, 1, NULL, "59.5006139", "26.5144401"),
("Kuressaare", "Kuressaare", "Kuressaare", NULL, 56, 0, 1, NULL, "58.2529231", "22.4850408"),
("Kuusalu", "Kuusalu", "Kuusalu", NULL, 56, 0, 1, NULL, "59.4462981", "25.443847"),
("Laagri", "Laagri", "Laagri", NULL, 56, 0, 1, NULL, "59.3517412", "24.6104962"),
("Lihula", "Lihula", "Lihula", NULL, 56, 0, 1, NULL, "58.6866285", "23.8332693"),
("Loksa", "Loksa", "Loksa", NULL, 56, 0, 1, NULL, "59.5812449", "25.7213551"),
("Loo", "Loo", "Loo", NULL, 56, 0, 1, NULL, "59.4342152", "24.9466284"),
("Marjamaa", "Marjamaa", "Marjamaa", NULL, 56, 0, 1, NULL, "58.904908", "24.4278467"),
("Moisakula", "Moisakula", "Moisakula", NULL, 56, 0, 1, NULL, "58.09241", "25.1831047"),
("Maardu", "Maardu", "Maardu", NULL, 56, 0, 1, NULL, "59.4687696", "24.9801867"),
("Mustvee", "Mustvee", "Mustvee", NULL, 56, 0, 1, NULL, "58.8484094", "26.9399663"),
("Noo", "Noo", "Noo", NULL, 56, 0, 1, NULL, "58.2777481", "26.5367208"),
("Narva", "Narva", "Narva", NULL, 56, 0, 1, NULL, "59.3796798", "28.1791333"),
("Narva- Joesuu", "Narva- Joesuu", "Narva- Joesuu", NULL, 56, 0, 1, NULL, "59.4609192", "28.0395998"),
("Orissaare", "Orissaare", "Orissaare", NULL, 56, 0, 1, NULL, "58.55895", "23.0835987"),
("Otepaa", "Otepaa", "Otepaa", NULL, 56, 0, 1, NULL, "58.058048", "26.4947523"),
("Parnu", "Parnu", "Parnu", NULL, 56, 0, 1, NULL, "58.3858079", "24.4965768"),
("Parnu- Jaagupi", "Parnu- Jaagupi", "Parnu- Jaagupi", NULL, 56, 0, 1, NULL, "58.0607459", "24.4800649"),
("Poltsamaa", "Poltsamaa", "Poltsamaa", NULL, 56, 0, 1, NULL, "58.6552312", "25.9768885"),
("Polva", "Polva", "Polva", NULL, 56, 0, 1, NULL, "58.0537462", "27.0548658");
