
INSERT INTO `#__wj_portal_cities` ( `name`, `localname`, `internationalname`, `stateid`, `countryid`, `isedit`, `enabled`, `serverid`, `latitude`, `longitude`) VALUES 
("Zürich", "Zürich", "Zurich", NULL, 92, 0, 1, NULL, "47.3744489", "8.5410422"),
("Genève", "Genève", "Geneva", NULL, 92, 0, 1, NULL, "46.2017559", "6.1466014"),
("Lausanne", "Lausanne", "Lausanne", NULL, 92, 0, 1, NULL, "46.5218269", "6.6327025"),
("Bern", "Bern", "Bern", NULL, 92, 0, 1, NULL, "46.9484742", "7.4521749"),
("Luzern", "Luzern", "Lucerne", NULL, 92, 0, 1, NULL, "47.0505452", "8.3054682"),
("Basel", "Basel", "Basel", NULL, 92, 0, 1, NULL, "47.5581077", "7.5878261"),
("Lugano", "Lugano", "Lugano", NULL, 92, 0, 1, NULL, "46.0038279", "8.9512134"),
("Winterthur", "Winterthur", "Winterthur", NULL, 92, 0, 1, NULL, "47.4991723", "8.7291498"),
("Sankt Gallen", "Sankt Gallen", "Sankt Gallen", NULL, 92, 0, 1, NULL, "47.4250593", "9.3765878"),
("Aadorf", "Aadorf", "Aadorf", NULL, 92, 0, 1, NULL, "47.4884348", "8.9035411"),
("Aarau", "Aarau", "Aarau", NULL, 92, 0, 1, NULL, "47.390434", "8.0457015"),
("Aarburg", "Aarburg", "Aarburg", NULL, 92, 0, 1, NULL, "47.3205914", "7.9066923"),
("Adligenswil", "Adligenswil", "Adligenswil", NULL, 92, 0, 1, NULL, "47.071186", "8.3647405"),
("Adliswil", "Adliswil", "Adliswil", NULL, 92, 0, 1, NULL, "47.3124347", "8.5270459"),
("Aesch", "Aesch", "Aesch", NULL, 92, 0, 1, NULL, "47.4672734", "7.5979344"),
("Affoltern", "Affoltern", "Affoltern", NULL, 92, 0, 1, NULL, "47.2795081", "8.4540083"),
("Aigle", "Aigle", "Aigle", NULL, 92, 0, 1, NULL, "46.3190253", "6.970566"),
("Allschwil", "Allschwil", "Allschwil", NULL, 92, 0, 1, NULL, "47.5528925", "7.5433615"),
("Alpnach", "Alpnach", "Alpnach", NULL, 92, 0, 1, NULL, "46.9380412", "8.2701754"),
("Altdorf", "Altdorf", "Altdorf", NULL, 92, 0, 1, NULL, "46.8821272", "8.6428436"),
("Altendorf", "Altendorf", "Altendorf", NULL, 92, 0, 1, NULL, "47.1914822", "8.8299043"),
("Altstatten", "Altstatten", "Altstatten", NULL, 92, 0, 1, NULL, "47.3774633", "9.5469133"),
("Amriswil", "Amriswil", "Amriswil", NULL, 92, 0, 1, NULL, "47.5449717", "9.3002409"),
("Appenzell", "Appenzell", "Appenzell", NULL, 92, 0, 1, NULL, "47.334932", "9.406594"),
("Arbon", "Arbon", "Arbon", NULL, 92, 0, 1, NULL, "47.5140905", "9.4268301"),
("Arlesheim", "Arlesheim", "Arlesheim", NULL, 92, 0, 1, NULL, "47.499576", "7.6192212"),
("Arth", "Arth", "Arth", NULL, 92, 0, 1, NULL, "47.0522846", "8.5544714"),
("Ascona", "Ascona", "Ascona", NULL, 92, 0, 1, NULL, "46.1615793", "8.7750131"),
("Au", "Au", "Au", NULL, 92, 0, 1, NULL, "47.431055", "9.6343097"),
("Bulach", "Bulach", "Bulach", NULL, 92, 0, 1, NULL, "47.5160671", "8.5419603"),
("Baar", "Baar", "Baar", NULL, 92, 0, 1, NULL, "47.1953729", "8.526087"),
("Bad Ragaz", "Bad Ragaz", "Bad Ragaz", NULL, 92, 0, 1, NULL, "47.0034141", "9.5011062"),
("Baden", "Baden", "Baden", NULL, 92, 0, 1, NULL, "47.47288", "8.30809"),
("Bagnes", "Bagnes", "Bagnes", NULL, 92, 0, 1, NULL, "46.07173", "7.22404"),
("Balsthal", "Balsthal", "Balsthal", NULL, 92, 0, 1, NULL, "47.3095856", "7.6883283"),
("Basse-Nendaz", "Basse-Nendaz", "Basse-Nendaz", NULL, 92, 0, 1, NULL, "46.1834441", "7.2942353"),
("Bassersdorf", "Bassersdorf", "Bassersdorf", NULL, 92, 0, 1, NULL, "47.4434608", "8.6287132"),
("Bellinzona", "Bellinzona", "Bellinzona", NULL, 92, 0, 1, NULL, "46.1946216", "9.0244124"),
("Belp", "Belp", "Belp", NULL, 92, 0, 1, NULL, "46.8914239", "7.499006"),
("Berikon", "Berikon", "Berikon", NULL, 92, 0, 1, NULL, "47.352", "8.37021"),
("Bernex", "Bernex", "Bernex", NULL, 92, 0, 1, NULL, "46.1771419", "6.0764849"),
("Bettlach", "Bettlach", "Bettlach", NULL, 92, 0, 1, NULL, "47.2026836", "7.4241066"),
("Bex", "Bex", "Bex", NULL, 92, 0, 1, NULL, "46.2499847", "7.0142664"),
("Biasca", "Biasca", "Biasca", NULL, 92, 0, 1, NULL, "46.3580008", "8.9704651"),
("Biberist", "Biberist", "Biberist", NULL, 92, 0, 1, NULL, "47.1818339", "7.5577799"),
("Biel", "Biel", "Biel", NULL, 92, 0, 1, NULL, "47.1367785", "7.2467909"),
("Binningen", "Binningen", "Binningen", NULL, 92, 0, 1, NULL, "47.5378697", "7.5709878"),
("Birmensdorf", "Birmensdorf", "Birmensdorf", NULL, 92, 0, 1, NULL, "47.35367", "8.43714"),
("Birsfelden", "Birsfelden", "Birsfelden", NULL, 92, 0, 1, NULL, "47.5516505", "7.6272499"),
("Blonay", "Blonay", "Blonay", NULL, 92, 0, 1, NULL, "46.4647104", "6.8946536");
