
INSERT INTO `#__wj_portal_cities` ( `name`, `localname`, `internationalname`, `stateid`, `countryid`, `isedit`, `enabled`, `serverid`, `latitude`, `longitude`) VALUES 
("Liepāja", "Liepāja", "Liepaja", NULL, 71, 0, 1, NULL, "56.5048435", "21.0070903"),
("Ventspils", "Ventspils", "Ventspils", NULL, 71, 0, 1, NULL, "57.3903918", "21.5635991"),
("Daugavpils", "Daugavpils", "Daugavpils", NULL, 71, 0, 1, NULL, "55.8712267", "26.5159337"),
("Jelgava", "Jelgava", "Jelgava", NULL, 71, 0, 1, NULL, "56.6514394", "23.7339143"),
("Jūrmala", "Jūrmala", "Jūrmala", NULL, 71, 0, 1, NULL, "56.9727164", "23.7886979"),
("Rīga", "Rīga", "Riga", NULL, 71, 0, 1, NULL, "56.9493977", "24.1051846"),
("Ogre", "Ogre", "Ogre", NULL, 71, 0, 1, NULL, "56.8192045", "24.6074393"),
("Jēkabpils", "Jēkabpils", "Jēkabpils", NULL, 71, 0, 1, NULL, "56.4958638", "25.8687747"),
("Valmiera", "Valmiera", "Valmiera", NULL, 71, 0, 1, NULL, "57.5389148", "25.4261688"),
("Rēzekne", "Rēzekne", "Rezekne", NULL, 71, 0, 1, NULL, "56.506281", "27.3306623"),
("Ainazi", "Ainazi", "Ainazi", NULL, 71, 0, 1, NULL, "57.8552975", "24.3530817"),
("Aizkraukle", "Aizkraukle", "Aizkraukle", NULL, 71, 0, 1, NULL, "56.5930499", "25.2431539"),
("Aizpute", "Aizpute", "Aizpute", NULL, 71, 0, 1, NULL, "56.715739", "21.605305"),
("Akniste", "Akniste", "Akniste", NULL, 71, 0, 1, NULL, "56.1597379", "25.744289"),
("Aluksne", "Aluksne", "Aluksne", NULL, 71, 0, 1, NULL, "57.4207878", "27.0513491"),
("Aloja", "Aloja", "Aloja", NULL, 71, 0, 1, NULL, "57.767136", "24.8770839"),
("Ape", "Ape", "Ape", NULL, 71, 0, 1, NULL, "57.537763", "26.704314"),
("Auce", "Auce", "Auce", NULL, 71, 0, 1, NULL, "56.460168", "22.905478"),
("Baldone", "Baldone", "Baldone", NULL, 71, 0, 1, NULL, "56.7458379", "24.4061069"),
("Balozi", "Balozi", "Balozi", NULL, 71, 0, 1, NULL, "56.8691589", "24.12987"),
("Balvi", "Balvi", "Balvi", NULL, 71, 0, 1, NULL, "57.1324175", "27.2655869"),
("Bauska", "Bauska", "Bauska", NULL, 71, 0, 1, NULL, "56.4102879", "24.1999989"),
("Bolderaja", "Bolderaja", "Bolderaja", NULL, 71, 0, 1, NULL, "57.0237445", "24.0385876"),
("Broceni", "Broceni", "Broceni", NULL, 71, 0, 1, NULL, "56.673312", "22.574388"),
("Cesvaine", "Cesvaine", "Cesvaine", NULL, 71, 0, 1, NULL, "56.9651439", "26.3110469"),
("Cesis", "Cesis", "Cesis", NULL, 71, 0, 1, NULL, "57.308611", "25.2668719"),
("Dagda", "Dagda", "Dagda", NULL, 71, 0, 1, NULL, "56.0956089", "27.532459"),
("Daugavgriva", "Daugavgriva", "Daugavgriva", NULL, 71, 0, 1, NULL, "57.0408915", "24.0131821"),
("Dobele", "Dobele", "Dobele", NULL, 71, 0, 1, NULL, "56.6249062", "23.2791069"),
("Kegums", "Kegums", "Kegums", NULL, 71, 0, 1, NULL, "56.7402899", "24.718165"),
("Kekava", "Kekava", "Kekava", NULL, 71, 0, 1, NULL, "56.8173109", "24.224916"),
("Engure", "Engure", "Engure", NULL, 71, 0, 1, NULL, "57.162312", "23.2197229"),
("Grobina", "Grobina", "Grobina", NULL, 71, 0, 1, NULL, "56.539632", "21.166892"),
("Gulbene", "Gulbene", "Gulbene", NULL, 71, 0, 1, NULL, "57.1714821", "26.7522537"),
("Iecava", "Iecava", "Iecava", NULL, 71, 0, 1, NULL, "56.5953599", "24.1989563"),
("Ikskile", "Ikskile", "Ikskile", NULL, 71, 0, 1, NULL, "56.8335579", "24.4954399"),
("Ilukste", "Ilukste", "Ilukste", NULL, 71, 0, 1, NULL, "55.976315", "26.305525"),
("Jaunciems", "Jaunciems", "Jaunciems", NULL, 71, 0, 1, NULL, "57.0337373", "24.1802613"),
("Jaunjelgava", "Jaunjelgava", "Jaunjelgava", NULL, 71, 0, 1, NULL, "56.6123099", "25.078927"),
("Jumprava", "Jumprava", "Jumprava", NULL, 71, 0, 1, NULL, "56.6745719", "24.9743789"),
("Kandava", "Kandava", "Kandava", NULL, 71, 0, 1, NULL, "57.033151", "22.7767899"),
("Karsava", "Karsava", "Karsava", NULL, 71, 0, 1, NULL, "56.7837809", "27.681978"),
("Kraslava", "Kraslava", "Kraslava", NULL, 71, 0, 1, NULL, "55.894769", "27.162763"),
("Kuldiga", "Kuldiga", "Kuldiga", NULL, 71, 0, 1, NULL, "56.9688139", "21.9615079"),
("Ligatne", "Ligatne", "Ligatne", NULL, 71, 0, 1, NULL, "57.2363399", "25.0380729"),
("Lielvarde", "Lielvarde", "Lielvarde", NULL, 71, 0, 1, NULL, "56.719152", "24.814229"),
("Limbazi", "Limbazi", "Limbazi", NULL, 71, 0, 1, NULL, "57.5129829", "24.721996"),
("Lubana", "Lubana", "Lubana", NULL, 71, 0, 1, NULL, "56.8999269", "26.7198789"),
("Ludza", "Ludza", "Ludza", NULL, 71, 0, 1, NULL, "56.545959", "27.7143199"),
("Livani", "Livani", "Livani", NULL, 71, 0, 1, NULL, "56.355176", "26.1725259");
