
INSERT INTO `#__wj_portal_cities` ( `name`, `localname`, `internationalname`, `stateid`, `countryid`, `isedit`, `enabled`, `serverid`, `latitude`, `longitude`) VALUES 
("Plzeň", "Plzeň", "Plzeň", NULL, 54, 0, 1, NULL, "49.7477415", "13.3775249"),
("České Budějovice", "České Budějovice", "České Budějovice", NULL, 54, 0, 1, NULL, "48.9747357", "14.474285"),
("Brno", "Brno", "Brno", NULL, 54, 0, 1, NULL, "49.1922443", "16.6113382"),
("Praha", "Praha", "Prague", NULL, 54, 0, 1, NULL, "50.0874654", "14.4212535"),
("Hradec Králové", "Hradec Králové", "Hradec Králové", NULL, 54, 0, 1, NULL, "50.2092113", "15.8327512"),
("Olomouc", "Olomouc", "Olomouc", NULL, 54, 0, 1, NULL, "49.5940567", "17.251143"),
("Ostrava", "Ostrava", "Ostrava", NULL, 54, 0, 1, NULL, "49.8349139", "18.2820084"),
("Ústí nad Labem", "Ústí nad Labem", "Ústí nad Labem", NULL, 54, 0, 1, NULL, "50.6603327", "14.0381357"),
("Liberec", "Liberec", "Liberec", NULL, 54, 0, 1, NULL, "50.7702648", "15.0583947"),
("Caslav", "Caslav", "Caslav", NULL, 54, 0, 1, NULL, "49.9108953", "15.3907936"),
("Ricany", "Ricany", "Ricany", NULL, 54, 0, 1, NULL, "49.9916782", "14.6542758"),
("Ustinad Orlici", "Ustinad Orlici", "Ustinad Orlici", NULL, 54, 0, 1, NULL, "49.9721801", "16.3996617"),
("Zdarnad Sazavou", "Zdarnad Sazavou", "Zdarnad Sazavou", NULL, 54, 0, 1, NULL, "49.5641882", "15.9394069"),
("Zdarnad Sazavou I I", "Zdarnad Sazavou I I", "Zdarnad Sazavou I I", NULL, 54, 0, 1, NULL, "49.5598016", "15.857384"),
("As", "As", "As", NULL, 54, 0, 1, NULL, "50.2238827", "12.1950127"),
("Zatec", "Zatec", "Zatec", NULL, 54, 0, 1, NULL, "50.327176", "13.5457856"),
("Bilina", "Bilina", "Bilina", NULL, 54, 0, 1, NULL, "50.5485474", "13.7753594"),
("Bilina Kyselka", "Bilina Kyselka", "Bilina Kyselka", NULL, 54, 0, 1, NULL, "50.5409147", "13.7597926"),
("Bilovec", "Bilovec", "Bilovec", NULL, 54, 0, 1, NULL, "49.7563861", "18.0158193"),
("Breclav", "Breclav", "Breclav", NULL, 54, 0, 1, NULL, "48.75314", "16.8825168"),
("Benesov", "Benesov", "Benesov", NULL, 54, 0, 1, NULL, "49.7837821", "14.6873698"),
("Beroun", "Beroun", "Beroun", NULL, 54, 0, 1, NULL, "49.9672047", "14.0862836"),
("Blansko", "Blansko", "Blansko", NULL, 54, 0, 1, NULL, "49.3648502", "16.6477552"),
("Bohumin", "Bohumin", "Bohumin", NULL, 54, 0, 1, NULL, "49.9043259", "18.3569743"),
("Boskovice", "Boskovice", "Boskovice", NULL, 54, 0, 1, NULL, "49.4875115", "16.6599761"),
("Branik", "Branik", "Branik", NULL, 54, 0, 1, NULL, "50.0344022", "14.4155652"),
("Brandysnad Labem- Stara Boleslav", "Brandysnad Labem- Stara Boleslav", "Brandysnad Labem- Stara Boleslav", NULL, 54, 0, 1, NULL, "50.1863259", "14.6592444"),
("Broumov", "Broumov", "Broumov", NULL, 54, 0, 1, NULL, "50.5856582", "16.3318151"),
("Bruntal", "Bruntal", "Bruntal", NULL, 54, 0, 1, NULL, "49.9881767", "17.4636941"),
("Bystricenad Pernstejnem", "Bystricenad Pernstejnem", "Bystricenad Pernstejnem", NULL, 54, 0, 1, NULL, "49.522946", "16.2614713"),
("Bystricepod Hostynem", "Bystricepod Hostynem", "Bystricepod Hostynem", NULL, 54, 0, 1, NULL, "49.3992365", "17.6740211"),
("Cheb", "Cheb", "Cheb", NULL, 54, 0, 1, NULL, "50.0795334", "12.3698636"),
("Chocen", "Chocen", "Chocen", NULL, 54, 0, 1, NULL, "50.0016037", "16.2230307"),
("Chodov", "Chodov", "Chodov", NULL, 54, 0, 1, NULL, "50.036257", "14.508483"),
("Chomutov", "Chomutov", "Chomutov", NULL, 54, 0, 1, NULL, "50.4634975", "13.410737"),
("Chotebor", "Chotebor", "Chotebor", NULL, 54, 0, 1, NULL, "49.7206138", "15.6710415"),
("Chrudim", "Chrudim", "Chrudim", NULL, 54, 0, 1, NULL, "49.9497244", "15.7950578"),
("Decin", "Decin", "Decin", NULL, 54, 0, 1, NULL, "50.7725563", "14.2127612"),
("Dacice", "Dacice", "Dacice", NULL, 54, 0, 1, NULL, "49.0798195", "15.434204"),
("Dobris", "Dobris", "Dobris", NULL, 54, 0, 1, NULL, "49.781138", "14.1671734"),
("Dobruska", "Dobruska", "Dobruska", NULL, 54, 0, 1, NULL, "50.2920108", "16.1600182"),
("Domazlice", "Domazlice", "Domazlice", NULL, 54, 0, 1, NULL, "49.4397027", "12.9311435"),
("Dubi", "Dubi", "Dubi", NULL, 54, 0, 1, NULL, "50.6810392", "13.7888466"),
("Duchcov", "Duchcov", "Duchcov", NULL, 54, 0, 1, NULL, "50.603771", "13.7462216"),
("Dvur Kralovenad Labem", "Dvur Kralovenad Labem", "Dvur Kralovenad Labem", NULL, 54, 0, 1, NULL, "50.4317202", "15.8140269"),
("Celakovice", "Celakovice", "Celakovice", NULL, 54, 0, 1, NULL, "50.1627026", "14.7509891"),
("Cerny Most", "Cerny Most", "Cerny Most", NULL, 54, 0, 1, NULL, "50.1064489", "14.5744479"),
("Cerveny Kostelec", "Cerveny Kostelec", "Cerveny Kostelec", NULL, 54, 0, 1, NULL, "50.4762607", "16.0928999"),
("Ceska Lipa", "Ceska Lipa", "Ceska Lipa", NULL, 54, 0, 1, NULL, "50.6785201", "14.5396991"),
("Ceska Trebova", "Ceska Trebova", "Ceska Trebova", NULL, 54, 0, 1, NULL, "49.9018822", "16.4472845");
