REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug, s_phone_code, s_name_native, s_currency) VALUES 
('CH', 'Switzerland', 'switzerland', '41', 'Schweiz', 'CHF');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001639, 'CH', 'Aargau', 1, 'aargau');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1017357, 1001639, 'CH', 'Aarau', 1, 'aarau', 47.39254000, 8.04422000),
(1017359, 1001639, 'CH', 'Aarburg', 1, 'aarburg', 47.32067000, 7.89986000),
(1017407, 1001639, 'CH', 'Aristau', 1, 'aristau', 47.28692000, 8.36356000),
(1017424, 1001639, 'CH', 'Auw', 1, 'auw', 47.21082000, 8.36583000),
(1017431, 1001639, 'CH', 'Bad Zurzach', 1, 'bad-zurzach', 47.58764000, 8.29365000),
(1017432, 1001639, 'CH', 'Baden', 1, 'baden', 47.47333000, 8.30592000),
(1017460, 1001639, 'CH', 'Berikon', 1, 'berikon', 47.35155000, 8.37232000),
(1017467, 1001639, 'CH', 'Besenbüren', 1, 'besenburen', 47.31439000, 8.34586000),
(1017471, 1001639, 'CH', 'Bezirk Aarau', 1, 'bezirk-aarau', 47.37706000, 8.05235000),
(1017475, 1001639, 'CH', 'Bezirk Baden', 1, 'bezirk-baden', 47.45660000, 8.30059000),
(1017476, 1001639, 'CH', 'Bezirk Bremgarten', 1, 'bezirk-bremgarten', 47.34927000, 8.33343000),
(1017477, 1001639, 'CH', 'Bezirk Brugg', 1, 'bezirk-brugg', 47.47776000, 8.17798000),
(1017491, 1001639, 'CH', 'Bezirk Kulm', 1, 'bezirk-kulm', 47.28757000, 8.13302000),
(1017494, 1001639, 'CH', 'Bezirk Laufenburg', 1, 'bezirk-laufenburg', 47.51844000, 8.03878000),
(1017496, 1001639, 'CH', 'Bezirk Lenzburg', 1, 'bezirk-lenzburg', 47.37184000, 8.18910000),
(1017501, 1001639, 'CH', 'Bezirk Muri', 1, 'bezirk-muri', 47.25233000, 8.35362000),
(1017506, 1001639, 'CH', 'Bezirk Rheinfelden', 1, 'bezirk-rheinfelden', 47.54048000, 7.83331000),
(1017521, 1001639, 'CH', 'Bezirk Zofingen', 1, 'bezirk-zofingen', 47.28864000, 7.95697000),
(1017522, 1001639, 'CH', 'Bezirk Zurzach', 1, 'bezirk-zurzach', 47.56182000, 8.28020000),
(1017536, 1001639, 'CH', 'Birmenstorf', 1, 'birmenstorf', 47.46152000, 8.24816000),
(1017537, 1001639, 'CH', 'Birr', 1, 'birr', 47.43432000, 8.20891000),
(1017549, 1001639, 'CH', 'Boniswil', 1, 'boniswil', 47.31725000, 8.18963000),
(1017558, 1001639, 'CH', 'Bremgarten', 1, 'bremgarten', 47.35109000, 8.34214000),
(1017565, 1001639, 'CH', 'Brittnau', 1, 'brittnau', 47.25954000, 7.94689000),
(1017570, 1001639, 'CH', 'Brugg', 1, 'brugg', 47.48096000, 8.20869000),
(1017579, 1001639, 'CH', 'Buchs', 1, 'buchs', 47.39358000, 8.08233000),
(1017588, 1001639, 'CH', 'Buttwil', 1, 'buttwil', 47.26828000, 8.31064000),
(1017682, 1001639, 'CH', 'Densbüren', 1, 'densburen', 47.45260000, 8.05330000),
(1017705, 1001639, 'CH', 'Dottikon', 1, 'dottikon', 47.38437000, 8.23981000),
(1017717, 1001639, 'CH', 'Dürrenäsch', 1, 'durrenasch', 47.32094000, 8.15874000),
(1017732, 1001639, 'CH', 'Egliswil', 1, 'egliswil', 47.34922000, 8.18553000),
(1017734, 1001639, 'CH', 'Ehrendingen', 1, 'ehrendingen', 47.50250000, 8.34729000),
(1017737, 1001639, 'CH', 'Eiken', 1, 'eiken', 47.53361000, 7.98801000),
(1017749, 1001639, 'CH', 'Endingen', 1, 'endingen', 47.53742000, 8.29036000),
(1017810, 1001639, 'CH', 'Frick', 1, 'frick', 47.51169000, 8.02471000),
(1017824, 1001639, 'CH', 'Gebenstorf', 1, 'gebenstorf', 47.48136000, 8.23949000),
(1017834, 1001639, 'CH', 'Gipf-Oberfrick', 1, 'gipf-oberfrick', 47.49875000, 8.00497000),
(1017853, 1001639, 'CH', 'Gontenschwil', 1, 'gontenschwil', 47.27166000, 8.14396000),
(1017880, 1001639, 'CH', 'Gränichen', 1, 'granichen', 47.35930000, 8.10243000),
(1017939, 1001639, 'CH', 'Hägglingen', 1, 'hagglingen', 47.38851000, 8.25285000),
(1017895, 1001639, 'CH', 'Hausen', 1, 'hausen', 47.46396000, 8.20988000),
(1017960, 1001639, 'CH', 'Jonen', 1, 'jonen', 47.29750000, 8.39282000),
(1017966, 1001639, 'CH', 'Kaiseraugst', 1, 'kaiseraugst', 47.53966000, 7.72605000),
(1017967, 1001639, 'CH', 'Kaisten', 1, 'kaisten', 47.54160000, 8.04337000),
(1017978, 1001639, 'CH', 'Killwangen', 1, 'killwangen', 47.43223000, 8.35097000),
(1017985, 1001639, 'CH', 'Klingnau', 1, 'klingnau', 47.58361000, 8.24880000),
(1017999, 1001639, 'CH', 'Koblenz', 1, 'koblenz', 47.60972000, 8.23750000),
(1018010, 1001639, 'CH', 'Kölliken', 1, 'kolliken', 47.33337000, 8.02237000),
(1018012, 1001639, 'CH', 'Künten', 1, 'kunten', 47.38887000, 8.33045000),
(1018020, 1001639, 'CH', 'Küttigen', 1, 'kuttigen', 47.41484000, 8.04979000),
(1018043, 1001639, 'CH', 'Laufenburg', 1, 'laufenburg', 47.55985000, 8.06225000),
(1018044, 1001639, 'CH', 'Lauffohr (Brugg)', 1, 'lauffohr-brugg', 47.50154000, 8.23122000),
(1018062, 1001639, 'CH', 'Leibstadt', 1, 'leibstadt', 47.58790000, 8.17611000),
(1018066, 1001639, 'CH', 'Lenzburg', 1, 'lenzburg', 47.38853000, 8.17503000),
(1018115, 1001639, 'CH', 'Magden', 1, 'magden', 47.52868000, 7.81128000),
(1018144, 1001639, 'CH', 'Meisterschwanden', 1, 'meisterschwanden', 47.29489000, 8.22867000),
(1018148, 1001639, 'CH', 'Mellingen', 1, 'mellingen', 47.41903000, 8.27331000),
(1018151, 1001639, 'CH', 'Menziken', 1, 'menziken', 47.23965000, 8.18996000),
(1018154, 1001639, 'CH', 'Merenschwand', 1, 'merenschwand', 47.25944000, 8.37633000),
(1018191, 1001639, 'CH', 'Möhlin', 1, 'mohlin', 47.55915000, 7.84329000),
(1018176, 1001639, 'CH', 'Muhen', 1, 'muhen', 47.33578000, 8.05536000),
(1018177, 1001639, 'CH', 'Mumpf', 1, 'mumpf', 47.54563000, 7.92123000),
(1018181, 1001639, 'CH', 'Murgenthal', 1, 'murgenthal', 47.27145000, 7.83935000),
(1018182, 1001639, 'CH', 'Muri', 1, 'muri', 47.27428000, 8.33854000),
(1018215, 1001639, 'CH', 'Neuenhof', 1, 'neuenhof', 47.44985000, 8.32682000),
(1018227, 1001639, 'CH', 'Niederlenz', 1, 'niederlenz', 47.40079000, 8.17640000),
(1018228, 1001639, 'CH', 'Niederrohrdorf', 1, 'niederrohrdorf', 47.42409000, 8.30404000),
(1018250, 1001639, 'CH', 'Oberentfelden', 1, 'oberentfelden', 47.35639000, 8.04594000),
(1018257, 1001639, 'CH', 'Oberlunkhofen', 1, 'oberlunkhofen', 47.31244000, 8.39242000),
(1018263, 1001639, 'CH', 'Oberrohrdorf', 1, 'oberrohrdorf', 47.41833000, 8.31983000),
(1018264, 1001639, 'CH', 'Oberrüti', 1, 'oberruti', 47.16673000, 8.39441000),
(1018266, 1001639, 'CH', 'Obersiggenthal', 1, 'obersiggenthal', 47.48750000, 8.29652000),
(1018281, 1001639, 'CH', 'Oftringen', 1, 'oftringen', 47.31382000, 7.92533000),
(1018293, 1001639, 'CH', 'Othmarsingen', 1, 'othmarsingen', 47.40125000, 8.21383000),
(1018363, 1001639, 'CH', 'Reinach', 1, 'reinach', 47.25732000, 8.18091000),
(1018366, 1001639, 'CH', 'Rheinfelden', 1, 'rheinfelden', 47.55437000, 7.79403000),
(1018394, 1001639, 'CH', 'Rothrist', 1, 'rothrist', 47.30508000, 7.89196000),
(1018397, 1001639, 'CH', 'Rudolfstetten', 1, 'rudolfstetten', 47.37101000, 8.38083000),
(1018399, 1001639, 'CH', 'Rupperswil', 1, 'rupperswil', 47.40131000, 8.12877000),
(1018419, 1001639, 'CH', 'Safenwil', 1, 'safenwil', 47.32163000, 7.98254000),
(1018446, 1001639, 'CH', 'Sarmenstorf', 1, 'sarmenstorf', 47.31109000, 8.24950000),
(1018456, 1001639, 'CH', 'Schafisheim', 1, 'schafisheim', 47.37664000, 8.14263000),
(1018462, 1001639, 'CH', 'Schinznach Bad', 1, 'schinznach-bad', 47.44992000, 8.16833000),
(1018463, 1001639, 'CH', 'Schinznach Dorf', 1, 'schinznach-dorf', 47.44650000, 8.14089000),
(1018483, 1001639, 'CH', 'Schöftland', 1, 'schoftland', 47.30590000, 8.05119000),
(1018474, 1001639, 'CH', 'Schwaderloch', 1, 'schwaderloch', 47.58541000, 8.14455000),
(1018501, 1001639, 'CH', 'Seengen', 1, 'seengen', 47.32503000, 8.20724000),
(1018511, 1001639, 'CH', 'Seon', 1, 'seon', 47.34848000, 8.16072000),
(1018523, 1001639, 'CH', 'Sins', 1, 'sins', 47.19296000, 8.39384000),
(1018534, 1001639, 'CH', 'Spreitenbach', 1, 'spreitenbach', 47.42285000, 8.36792000),
(1018544, 1001639, 'CH', 'Staffelbach', 1, 'staffelbach', 47.28395000, 8.04208000),
(1018548, 1001639, 'CH', 'Staufen', 1, 'staufen', 47.38197000, 8.16681000),
(1018551, 1001639, 'CH', 'Stein', 1, 'stein', 47.54403000, 7.95256000),
(1018559, 1001639, 'CH', 'Strengelbach', 1, 'strengelbach', 47.27917000, 7.92895000),
(1018562, 1001639, 'CH', 'Suhr', 1, 'suhr', 47.37172000, 8.07967000),
(1018564, 1001639, 'CH', 'Sulz', 1, 'sulz', 47.53602000, 8.09628000),
(1018577, 1001639, 'CH', 'Tegerfelden', 1, 'tegerfelden', 47.55809000, 8.28914000),
(1018580, 1001639, 'CH', 'Teufenthal', 1, 'teufenthal', 47.32896000, 8.11777000),
(1018614, 1001639, 'CH', 'Turgi', 1, 'turgi', 47.49201000, 8.25412000),
(1018625, 1001639, 'CH', 'Uerkheim', 1, 'uerkheim', 47.30353000, 8.02320000),
(1018633, 1001639, 'CH', 'Unterkulm', 1, 'unterkulm', 47.30998000, 8.11371000),
(1018634, 1001639, 'CH', 'Unterlunkhofen', 1, 'unterlunkhofen', 47.32120000, 8.38102000),
(1018636, 1001639, 'CH', 'Untersiggenthal', 1, 'untersiggenthal', 47.50213000, 8.25554000),
(1018664, 1001639, 'CH', 'Veltheim', 1, 'veltheim', 47.43796000, 8.14722000),
(1018683, 1001639, 'CH', 'Villigen', 1, 'villigen', 47.52682000, 8.21486000),
(1018684, 1001639, 'CH', 'Villmergen', 1, 'villmergen', 47.35009000, 8.24762000),
(1018685, 1001639, 'CH', 'Villnachern', 1, 'villnachern', 47.47098000, 8.15975000),
(1018692, 1001639, 'CH', 'Vordemwald', 1, 'vordemwald', 47.27585000, 7.90114000),
(1018719, 1001639, 'CH', 'Waltenschwil', 1, 'waltenschwil', 47.33339000, 8.29791000),
(1018728, 1001639, 'CH', 'Wegenstetten', 1, 'wegenstetten', 47.49797000, 7.93141000),
(1018736, 1001639, 'CH', 'Wettingen', 1, 'wettingen', 47.47049000, 8.31636000),
(1018757, 1001639, 'CH', 'Windisch', 1, 'windisch', 47.47899000, 8.21842000),
(1018760, 1001639, 'CH', 'Wittnau', 1, 'wittnau', 47.48139000, 7.97577000),
(1018761, 1001639, 'CH', 'Wohlen', 1, 'wohlen', 47.35066000, 8.27517000),
(1018782, 1001639, 'CH', 'Wölflinswil', 1, 'wolflinswil', 47.46070000, 7.99835000),
(1018788, 1001639, 'CH', 'Würenlingen', 1, 'wurenlingen', 47.53356000, 8.25666000),
(1018789, 1001639, 'CH', 'Würenlos', 1, 'wurenlos', 47.44205000, 8.36261000),
(1018796, 1001639, 'CH', 'Zofingen', 1, 'zofingen', 47.28779000, 7.94586000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001655, 'CH', 'Appenzell Ausserrhoden', 1, 'appenzell-ausserrhoden');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1017487, 1001655, 'CH', 'Bezirk Hinterland', 1, 'bezirk-hinterland', 47.36470000, 9.27350000),
(1017500, 1001655, 'CH', 'Bezirk Mittelland', 1, 'bezirk-mittelland', 47.37700000, 9.43469000),
(1017517, 1001655, 'CH', 'Bezirk Vorderland', 1, 'bezirk-vorderland', 47.44167000, 9.53869000),
(1017597, 1001655, 'CH', 'Bühler', 1, 'buhler', 47.37348000, 9.42507000),
(1017819, 1001655, 'CH', 'Gais', 1, 'gais', 47.36150000, 9.45356000),
(1017901, 1001655, 'CH', 'Heiden', 1, 'heiden', 47.44255000, 9.53293000),
(1017907, 1001655, 'CH', 'Herisau', 1, 'herisau', 47.38615000, 9.27916000),
(1018359, 1001655, 'CH', 'Rehetobel', 1, 'rehetobel', 47.42611000, 9.48300000),
(1018477, 1001655, 'CH', 'Schwellbrunn', 1, 'schwellbrunn', 47.35255000, 9.24894000),
(1018532, 1001655, 'CH', 'Speicher', 1, 'speicher', 47.41090000, 9.44335000),
(1018579, 1001655, 'CH', 'Teufen', 1, 'teufen', 47.39080000, 9.38644000),
(1018605, 1001655, 'CH', 'Trogen', 1, 'trogen', 47.40782000, 9.46498000),
(1018643, 1001655, 'CH', 'Urnäsch', 1, 'urnasch', 47.31669000, 9.27950000),
(1018712, 1001655, 'CH', 'Waldstatt', 1, 'waldstatt', 47.35627000, 9.28345000),
(1018720, 1001655, 'CH', 'Walzenhausen', 1, 'walzenhausen', 47.44867000, 9.60495000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001649, 'CH', 'Appenzell Innerrhoden', 1, 'appenzell-innerrhoden');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1017400, 1001649, 'CH', 'Appenzell', 1, 'appenzell', 47.33103000, 9.40996000),
(1017852, 1001649, 'CH', 'Gonten', 1, 'gonten', 47.32725000, 9.34705000),
(1017894, 1001649, 'CH', 'Haslen', 1, 'haslen', 47.36931000, 9.36752000),
(1018245, 1001649, 'CH', 'Oberegg', 1, 'oberegg', 47.42531000, 9.55134000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001641, 'CH', 'Basel-Landschaft', 1, 'basel-landschaft');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1017371, 1001641, 'CH', 'Aesch', 1, 'aesch', 47.47104000, 7.59730000),
(1017386, 1001641, 'CH', 'Allschwil', 1, 'allschwil', 47.55074000, 7.53599000),
(1017406, 1001641, 'CH', 'Arisdorf', 1, 'arisdorf', 47.51323000, 7.76515000),
(1017408, 1001641, 'CH', 'Arlesheim', 1, 'arlesheim', 47.49412000, 7.61979000),
(1017474, 1001641, 'CH', 'Bezirk Arlesheim', 1, 'bezirk-arlesheim', 47.51668000, 7.58733000),
(1017493, 1001641, 'CH', 'Bezirk Laufen', 1, 'bezirk-laufen', 47.42324000, 7.48750000),
(1017497, 1001641, 'CH', 'Bezirk Liestal', 1, 'bezirk-liestal', 47.48124000, 7.72714000),
(1017510, 1001641, 'CH', 'Bezirk Sissach', 1, 'bezirk-sissach', 47.44237000, 7.84871000),
(1017518, 1001641, 'CH', 'Bezirk Waldenburg', 1, 'bezirk-waldenburg', 47.39367000, 7.74137000),
(1017530, 1001641, 'CH', 'Binningen', 1, 'binningen', 47.54021000, 7.56932000),
(1017538, 1001641, 'CH', 'Birsfelden', 1, 'birsfelden', 47.55290000, 7.62322000),
(1017553, 1001641, 'CH', 'Bottmingen', 1, 'bottmingen', 47.52343000, 7.57211000),
(1017563, 1001641, 'CH', 'Brislach', 1, 'brislach', 47.41763000, 7.54340000),
(1017575, 1001641, 'CH', 'Bubendorf', 1, 'bubendorf', 47.44586000, 7.73759000),
(1017589, 1001641, 'CH', 'Buus', 1, 'buus', 47.50635000, 7.86414000),
(1017684, 1001641, 'CH', 'Diegten', 1, 'diegten', 47.41380000, 7.81085000),
(1017775, 1001641, 'CH', 'Ettingen', 1, 'ettingen', 47.48225000, 7.54654000),
(1017808, 1001641, 'CH', 'Frenkendorf', 1, 'frenkendorf', 47.50686000, 7.71648000),
(1017817, 1001641, 'CH', 'Füllinsdorf', 1, 'fullinsdorf', 47.50688000, 7.73129000),
(1017825, 1001641, 'CH', 'Gelterkinden', 1, 'gelterkinden', 47.46497000, 7.85174000),
(1017867, 1001641, 'CH', 'Grellingen', 1, 'grellingen', 47.44231000, 7.58906000),
(1017942, 1001641, 'CH', 'Hölstein', 1, 'holstein', 47.42290000, 7.77041000),
(1017956, 1001641, 'CH', 'Itingen', 1, 'itingen', 47.46651000, 7.78502000),
(1018034, 1001641, 'CH', 'Langenbruck', 1, 'langenbruck', 47.34917000, 7.76802000),
(1018109, 1001641, 'CH', 'Läufelfingen', 1, 'laufelfingen', 47.39457000, 7.85578000),
(1018042, 1001641, 'CH', 'Laufen', 1, 'laufen', 47.42193000, 7.49946000),
(1018050, 1001641, 'CH', 'Lausen', 1, 'lausen', 47.47139000, 7.76030000),
(1018082, 1001641, 'CH', 'Liesberg', 1, 'liesberg', 47.40398000, 7.42787000),
(1018083, 1001641, 'CH', 'Liestal', 1, 'liestal', 47.48455000, 7.73446000),
(1018200, 1001641, 'CH', 'Münchenstein', 1, 'munchenstein', 47.51848000, 7.60966000),
(1018185, 1001641, 'CH', 'Muttenz', 1, 'muttenz', 47.52271000, 7.64511000),
(1018244, 1001641, 'CH', 'Oberdorf', 1, 'oberdorf', 47.39353000, 7.75169000),
(1018270, 1001641, 'CH', 'Oberwil', 1, 'oberwil', 47.51407000, 7.55786000),
(1018287, 1001641, 'CH', 'Ormalingen', 1, 'ormalingen', 47.46936000, 7.87248000),
(1018307, 1001641, 'CH', 'Pfeffingen', 1, 'pfeffingen', 47.45984000, 7.58975000),
(1018324, 1001641, 'CH', 'Pratteln', 1, 'pratteln', 47.52071000, 7.69356000),
(1018362, 1001641, 'CH', 'Reigoldswil', 1, 'reigoldswil', 47.39824000, 7.68718000),
(1018403, 1001641, 'CH', 'Röschenz', 1, 'roschenz', 47.42366000, 7.48024000),
(1018484, 1001641, 'CH', 'Schönenbuch', 1, 'schonenbuch', 47.53853000, 7.50572000),
(1018505, 1001641, 'CH', 'Seltisberg', 1, 'seltisberg', 47.46249000, 7.72039000),
(1018526, 1001641, 'CH', 'Sissach', 1, 'sissach', 47.46408000, 7.80888000),
(1018589, 1001641, 'CH', 'Therwil', 1, 'therwil', 47.49941000, 7.55669000),
(1018699, 1001641, 'CH', 'Wahlen', 1, 'wahlen', 47.40226000, 7.51511000),
(1018710, 1001641, 'CH', 'Waldenburg', 1, 'waldenburg', 47.38333000, 7.75000000),
(1018803, 1001641, 'CH', 'Zunzgen', 1, 'zunzgen', 47.44925000, 7.80789000),
(1018807, 1001641, 'CH', 'Zwingen', 1, 'zwingen', 47.43825000, 7.53027000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001645, 'CH', 'canton of Bern', 1, 'canton-of-bern');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1017358, 1001645, 'CH', 'Aarberg', 1, 'aarberg', 47.04439000, 7.27578000),
(1017360, 1001645, 'CH', 'Aarwangen', 1, 'aarwangen', 47.23845000, 7.76854000),
(1017362, 1001645, 'CH', 'Adelboden', 1, 'adelboden', 46.49142000, 7.56031000),
(1017373, 1001645, 'CH', 'Aeschi b. Spiez', 1, 'aeschi-b-spiez', 46.65848000, 7.69650000),
(1017404, 1001645, 'CH', 'Arch', 1, 'arch', 47.16533000, 7.43139000),
(1017417, 1001645, 'CH', 'Attiswil', 1, 'attiswil', 47.24673000, 7.61353000),
(1017592, 1001645, 'CH', 'Bäriswil', 1, 'bariswil', 47.01947000, 7.52709000),
(1017593, 1001645, 'CH', 'Bätterkinden', 1, 'batterkinden', 47.13164000, 7.53817000),
(1017447, 1001645, 'CH', 'Beatenberg', 1, 'beatenberg', 46.69896000, 7.79428000),
(1017454, 1001645, 'CH', 'Bellmund', 1, 'bellmund', 47.10852000, 7.24608000),
(1017456, 1001645, 'CH', 'Belp', 1, 'belp', 46.89129000, 7.49825000),
(1017462, 1001645, 'CH', 'Bern', 1, 'bern', 46.94809000, 7.44744000),
(1017463, 1001645, 'CH', 'Bern-Mittelland District', 1, 'bern-mittelland-district', 46.92526000, 7.49024000),
(1017594, 1001645, 'CH', 'Bévilard', 1, 'bevilard', 47.23711000, 7.28325000),
(1017526, 1001645, 'CH', 'Biel/Bienne', 1, 'biel-bienne', 47.13713000, 7.24608000),
(1017527, 1001645, 'CH', 'Biel/Bienne District', 1, 'biel-bienne-district', 47.12725000, 7.26174000),
(1017528, 1001645, 'CH', 'Biglen', 1, 'biglen', 46.92629000, 7.62508000),
(1017542, 1001645, 'CH', 'Blumenstein', 1, 'blumenstein', 46.74210000, 7.52136000),
(1017545, 1001645, 'CH', 'Bolligen', 1, 'bolligen', 46.97510000, 7.49697000),
(1017546, 1001645, 'CH', 'Boltigen', 1, 'boltigen', 46.62847000, 7.39054000),
(1017595, 1001645, 'CH', 'Bönigen', 1, 'bonigen', 46.68736000, 7.89350000),
(1017556, 1001645, 'CH', 'Bowil', 1, 'bowil', 46.89304000, 7.69757000),
(1017560, 1001645, 'CH', 'Brienz', 1, 'brienz', 46.75450000, 8.03847000),
(1017572, 1001645, 'CH', 'Brügg', 1, 'brugg', 47.12370000, 7.27887000),
(1017577, 1001645, 'CH', 'Buchholterberg', 1, 'buchholterberg', 46.81351000, 7.67463000),
(1017583, 1001645, 'CH', 'Burgdorf', 1, 'burgdorf', 47.05901000, 7.62786000),
(1017584, 1001645, 'CH', 'Burgistein', 1, 'burgistein', 46.78464000, 7.49988000),
(1017653, 1001645, 'CH', 'Corgémont', 1, 'corgemont', 47.19457000, 7.14517000),
(1017664, 1001645, 'CH', 'Court', 1, 'court', 47.23956000, 7.33655000),
(1017665, 1001645, 'CH', 'Courtelary', 1, 'courtelary', 47.17822000, 7.07236000),
(1017708, 1001645, 'CH', 'Därligen', 1, 'darligen', 46.66175000, 7.80808000),
(1017686, 1001645, 'CH', 'Diemtigen', 1, 'diemtigen', 46.64928000, 7.56477000),
(1017716, 1001645, 'CH', 'Dürrenroth', 1, 'durrenroth', 47.08953000, 7.79170000),
(1017731, 1001645, 'CH', 'Eggiwil', 1, 'eggiwil', 46.87575000, 7.79567000),
(1017747, 1001645, 'CH', 'Emmental District', 1, 'emmental-district', 47.04425000, 7.66176000),
(1017758, 1001645, 'CH', 'Eriswil', 1, 'eriswil', 47.07816000, 7.85149000),
(1017759, 1001645, 'CH', 'Erlach', 1, 'erlach', 47.04220000, 7.09728000),
(1017764, 1001645, 'CH', 'Erlenbach im Simmental', 1, 'erlenbach-im-simmental', 46.66021000, 7.55445000),
(1017767, 1001645, 'CH', 'Ersigen', 1, 'ersigen', 47.09368000, 7.59507000),
(1017777, 1001645, 'CH', 'Evilard', 1, 'evilard', 47.15046000, 7.23895000),
(1017784, 1001645, 'CH', 'Ferenbalm', 1, 'ferenbalm', 46.94880000, 7.21124000),
(1017802, 1001645, 'CH', 'Fraubrunnen', 1, 'fraubrunnen', 47.08620000, 7.52727000),
(1017805, 1001645, 'CH', 'Frauenkappelen', 1, 'frauenkappelen', 46.95425000, 7.33835000),
(1017812, 1001645, 'CH', 'Frutigen', 1, 'frutigen', 46.58723000, 7.64945000),
(1017813, 1001645, 'CH', 'Frutigen-Niedersimmental District', 1, 'frutigen-niedersimmental-district', 46.60236000, 7.62292000),
(1017870, 1001645, 'CH', 'Grindelwald', 1, 'grindelwald', 46.62396000, 8.03601000),
(1017874, 1001645, 'CH', 'Grossaffoltern', 1, 'grossaffoltern', 47.06534000, 7.35689000),
(1017884, 1001645, 'CH', 'Gstaad', 1, 'gstaad', 46.47215000, 7.28685000),
(1017885, 1001645, 'CH', 'Guggisberg', 1, 'guggisberg', 46.76756000, 7.32946000),
(1017902, 1001645, 'CH', 'Heimberg', 1, 'heimberg', 46.79482000, 7.60433000),
(1017903, 1001645, 'CH', 'Heimiswil', 1, 'heimiswil', 47.06755000, 7.66665000),
(1017908, 1001645, 'CH', 'Hermiswil', 1, 'hermiswil', 46.83125000, 7.47775000),
(1017910, 1001645, 'CH', 'Herzogenbuchsee', 1, 'herzogenbuchsee', 47.18795000, 7.70620000),
(1017913, 1001645, 'CH', 'Hilterfingen', 1, 'hilterfingen', 46.73521000, 7.66185000),
(1017915, 1001645, 'CH', 'Hindelbank', 1, 'hindelbank', 47.04270000, 7.54143000),
(1017936, 1001645, 'CH', 'Huttwil', 1, 'huttwil', 47.11502000, 7.86209000),
(1017952, 1001645, 'CH', 'Ins', 1, 'ins', 47.00584000, 7.10609000),
(1017953, 1001645, 'CH', 'Interlaken', 1, 'interlaken', 46.68387000, 7.86638000),
(1017954, 1001645, 'CH', 'Interlaken-Oberhasli District', 1, 'interlaken-oberhasli-district', 46.68931000, 7.98869000),
(1017957, 1001645, 'CH', 'Jegenstorf', 1, 'jegenstorf', 47.04802000, 7.50787000),
(1017963, 1001645, 'CH', 'Jura bernois', 1, 'jura-bernois', 47.21892000, 7.21981000),
(1017968, 1001645, 'CH', 'Kallnach', 1, 'kallnach', 47.02032000, 7.23545000),
(1017970, 1001645, 'CH', 'Kandersteg', 1, 'kandersteg', 46.49467000, 7.67326000),
(1017971, 1001645, 'CH', 'Kappelen', 1, 'kappelen', 47.06015000, 7.26860000),
(1017972, 1001645, 'CH', 'Kehrsatz', 1, 'kehrsatz', 46.91035000, 7.47096000),
(1017981, 1001645, 'CH', 'Kirchberg', 1, 'kirchberg', 47.08538000, 7.58288000),
(1017982, 1001645, 'CH', 'Kirchlindach', 1, 'kirchlindach', 46.99965000, 7.41735000),
(1018011, 1001645, 'CH', 'Köniz', 1, 'koniz', 46.92436000, 7.41457000),
(1018002, 1001645, 'CH', 'Konolfingen', 1, 'konolfingen', 46.87909000, 7.62013000),
(1018003, 1001645, 'CH', 'Koppigen', 1, 'koppigen', 47.13125000, 7.60525000),
(1018004, 1001645, 'CH', 'Krauchthal', 1, 'krauchthal', 47.00964000, 7.56640000),
(1018023, 1001645, 'CH', 'La Neuveville', 1, 'la-neuveville', 47.06592000, 7.09717000),
(1018036, 1001645, 'CH', 'Langenthal', 1, 'langenthal', 47.21526000, 7.79607000),
(1018037, 1001645, 'CH', 'Langnau', 1, 'langnau', 46.93936000, 7.78738000),
(1018045, 1001645, 'CH', 'Laupen', 1, 'laupen', 46.90214000, 7.23973000),
(1018047, 1001645, 'CH', 'Lauperswil', 1, 'lauperswil', 46.96564000, 7.74214000),
(1018051, 1001645, 'CH', 'Lauterbrunnen', 1, 'lauterbrunnen', 46.59307000, 7.90938000),
(1018063, 1001645, 'CH', 'Lengnau', 1, 'lengnau', 47.18155000, 7.36814000),
(1018064, 1001645, 'CH', 'Lenk', 1, 'lenk', 46.45826000, 7.44298000),
(1018077, 1001645, 'CH', 'Leuzigen', 1, 'leuzigen', 47.17458000, 7.45775000),
(1018085, 1001645, 'CH', 'Linden', 1, 'linden', 46.84690000, 7.67831000),
(1018093, 1001645, 'CH', 'Lotzwil', 1, 'lotzwil', 47.19135000, 7.79102000),
(1018112, 1001645, 'CH', 'Lützelflüh', 1, 'lutzelfluh', 47.00757000, 7.69165000),
(1018107, 1001645, 'CH', 'Lyss', 1, 'lyss', 47.07410000, 7.30655000),
(1018108, 1001645, 'CH', 'Lyssach', 1, 'lyssach', 47.06445000, 7.58228000),
(1018113, 1001645, 'CH', 'Madiswil', 1, 'madiswil', 47.16463000, 7.79858000),
(1018118, 1001645, 'CH', 'Malleray', 1, 'malleray', 47.23839000, 7.27286000),
(1018129, 1001645, 'CH', 'Matten', 1, 'matten', 46.67833000, 7.86889000),
(1018142, 1001645, 'CH', 'Meinisberg', 1, 'meinisberg', 47.15965000, 7.34801000),
(1018143, 1001645, 'CH', 'Meiringen', 1, 'meiringen', 46.72709000, 8.18720000),
(1018146, 1001645, 'CH', 'Melchnau', 1, 'melchnau', 47.18213000, 7.85128000),
(1018175, 1001645, 'CH', 'Moutier', 1, 'moutier', 47.27818000, 7.36951000),
(1018195, 1001645, 'CH', 'Mühleberg', 1, 'muhleberg', 46.95466000, 7.26102000),
(1018197, 1001645, 'CH', 'Mühlethurnen', 1, 'muhlethurnen', 46.81345000, 7.50881000),
(1018199, 1001645, 'CH', 'Münchenbuchsee', 1, 'munchenbuchsee', 47.02175000, 7.45036000),
(1018201, 1001645, 'CH', 'Münchenwiler', 1, 'munchenwiler', 46.91334000, 7.12556000),
(1018204, 1001645, 'CH', 'Münsingen', 1, 'munsingen', 46.87298000, 7.56100000),
(1018206, 1001645, 'CH', 'Müntschemier', 1, 'muntschemier', 46.99548000, 7.14626000),
(1018183, 1001645, 'CH', 'Muri', 1, 'muri', 46.93122000, 7.48658000),
(1018219, 1001645, 'CH', 'Nidau', 1, 'nidau', 47.12545000, 7.24033000),
(1018220, 1001645, 'CH', 'Niederbipp', 1, 'niederbipp', 47.27175000, 7.69583000),
(1018239, 1001645, 'CH', 'Oberaargau', 1, 'oberaargau', 47.19202000, 7.74553000),
(1018240, 1001645, 'CH', 'Oberbipp', 1, 'oberbipp', 47.26070000, 7.66359000),
(1018242, 1001645, 'CH', 'Oberburg', 1, 'oberburg', 47.03665000, 7.62745000),
(1018243, 1001645, 'CH', 'Oberdiessbach', 1, 'oberdiessbach', 46.84117000, 7.61730000),
(1018267, 1001645, 'CH', 'Obersimmental-Saanen District', 1, 'obersimmental-saanen-district', 46.47932000, 7.35803000),
(1018289, 1001645, 'CH', 'Orpund', 1, 'orpund', 47.13891000, 7.30775000),
(1018291, 1001645, 'CH', 'Orvin', 1, 'orvin', 47.16068000, 7.21368000),
(1018332, 1001645, 'CH', 'Péry', 1, 'pery', 47.19398000, 7.24913000),
(1018314, 1001645, 'CH', 'Pieterlen', 1, 'pieterlen', 47.17501000, 7.33791000),
(1018334, 1001645, 'CH', 'Radelfingen', 1, 'radelfingen', 47.02146000, 7.27178000),
(1018343, 1001645, 'CH', 'Reconvilier', 1, 'reconvilier', 47.23431000, 7.22239000),
(1018376, 1001645, 'CH', 'Riggisberg', 1, 'riggisberg', 46.81028000, 7.48014000),
(1018377, 1001645, 'CH', 'Ringgenberg', 1, 'ringgenberg', 46.70114000, 7.89445000),
(1018382, 1001645, 'CH', 'Roggwil', 1, 'roggwil', 47.24119000, 7.82141000),
(1018385, 1001645, 'CH', 'Rohrbach', 1, 'rohrbach', 47.13521000, 7.81334000),
(1018396, 1001645, 'CH', 'Rubigen', 1, 'rubigen', 46.89868000, 7.54460000),
(1018404, 1001645, 'CH', 'Rüderswil', 1, 'ruderswil', 46.98374000, 7.72167000),
(1018405, 1001645, 'CH', 'Rüeggisberg', 1, 'rueggisberg', 46.82216000, 7.43890000),
(1018408, 1001645, 'CH', 'Rüschegg', 1, 'ruschegg', 46.77977000, 7.39167000),
(1018415, 1001645, 'CH', 'Saanen', 1, 'saanen', 46.48945000, 7.26003000),
(1018425, 1001645, 'CH', 'Saint-Imier', 1, 'saint-imier', 47.15284000, 6.99692000),
(1018443, 1001645, 'CH', 'Sankt Stephan', 1, 'sankt-stephan', 46.50827000, 7.39559000),
(1018488, 1001645, 'CH', 'Schüpfen', 1, 'schupfen', 47.03661000, 7.37723000),
(1018491, 1001645, 'CH', 'Seeberg', 1, 'seeberg', 47.15585000, 7.66567000),
(1018493, 1001645, 'CH', 'Seedorf', 1, 'seedorf', 47.03445000, 7.31249000),
(1018494, 1001645, 'CH', 'Seeland District', 1, 'seeland-district', 47.06635000, 7.26333000),
(1018502, 1001645, 'CH', 'Seftigen', 1, 'seftigen', 46.78765000, 7.53937000),
(1018519, 1001645, 'CH', 'Signau', 1, 'signau', 46.91944000, 7.72418000),
(1018520, 1001645, 'CH', 'Sigriswil', 1, 'sigriswil', 46.71656000, 7.71335000),
(1018533, 1001645, 'CH', 'Spiez', 1, 'spiez', 46.68473000, 7.69111000),
(1018550, 1001645, 'CH', 'Steffisburg', 1, 'steffisburg', 46.77807000, 7.63249000),
(1018558, 1001645, 'CH', 'Stettlen', 1, 'stettlen', 46.95835000, 7.52508000),
(1018566, 1001645, 'CH', 'Sumiswald', 1, 'sumiswald', 47.02747000, 7.74526000),
(1018617, 1001645, 'CH', 'Täuffelen', 1, 'tauffelen', 47.06630000, 7.19883000),
(1018576, 1001645, 'CH', 'Tavannes', 1, 'tavannes', 47.22079000, 7.19759000),
(1018590, 1001645, 'CH', 'Thierachern', 1, 'thierachern', 46.75319000, 7.57442000),
(1018591, 1001645, 'CH', 'Thun', 1, 'thun', 46.75118000, 7.62166000),
(1018592, 1001645, 'CH', 'Thun District', 1, 'thun-district', 46.76290000, 7.62503000),
(1018597, 1001645, 'CH', 'Toffen', 1, 'toffen', 46.86031000, 7.49216000),
(1018598, 1001645, 'CH', 'Trachselwald', 1, 'trachselwald', 47.01699000, 7.73639000),
(1018599, 1001645, 'CH', 'Tramelan', 1, 'tramelan', 47.22298000, 7.10287000),
(1018608, 1001645, 'CH', 'Trub', 1, 'trub', 46.94168000, 7.87996000),
(1018609, 1001645, 'CH', 'Trubschachen', 1, 'trubschachen', 46.92228000, 7.84520000),
(1018626, 1001645, 'CH', 'Uetendorf', 1, 'uetendorf', 46.77392000, 7.57251000),
(1018635, 1001645, 'CH', 'Unterseen', 1, 'unterseen', 46.68530000, 7.84722000),
(1018644, 1001645, 'CH', 'Urtenen', 1, 'urtenen', 47.02667000, 7.50081000),
(1018651, 1001645, 'CH', 'Uttigen', 1, 'uttigen', 46.79435000, 7.57789000),
(1018653, 1001645, 'CH', 'Utzenstorf', 1, 'utzenstorf', 47.13248000, 7.55355000),
(1018663, 1001645, 'CH', 'Vechigen', 1, 'vechigen', 46.94616000, 7.56065000),
(1018714, 1001645, 'CH', 'Walkringen', 1, 'walkringen', 46.94856000, 7.62040000),
(1018723, 1001645, 'CH', 'Wangen an der Aare', 1, 'wangen-an-der-aare', 47.23208000, 7.65253000),
(1018724, 1001645, 'CH', 'Wattenwil', 1, 'wattenwil', 46.76973000, 7.50835000),
(1018744, 1001645, 'CH', 'Wichtrach', 1, 'wichtrach', 46.85010000, 7.57748000),
(1018745, 1001645, 'CH', 'Wiedlisbach', 1, 'wiedlisbach', 47.25194000, 7.64610000),
(1018752, 1001645, 'CH', 'Wilderswil', 1, 'wilderswil', 46.66369000, 7.86175000),
(1018756, 1001645, 'CH', 'Wimmis', 1, 'wimmis', 46.67587000, 7.63972000),
(1018762, 1001645, 'CH', 'Wohlen', 1, 'wohlen', 46.97118000, 7.35685000),
(1018768, 1001645, 'CH', 'Worb', 1, 'worb', 46.92984000, 7.56306000),
(1018769, 1001645, 'CH', 'Worben', 1, 'worben', 47.10279000, 7.29518000),
(1018770, 1001645, 'CH', 'Wynau', 1, 'wynau', 47.25570000, 7.81626000),
(1018771, 1001645, 'CH', 'Wynigen', 1, 'wynigen', 47.10586000, 7.66681000),
(1018772, 1001645, 'CH', 'Wyssachen', 1, 'wyssachen', 47.07851000, 7.82922000),
(1018808, 1001645, 'CH', 'Zäziwil', 1, 'zaziwil', 46.90196000, 7.66185000),
(1018798, 1001645, 'CH', 'Zollikofen', 1, 'zollikofen', 46.99905000, 7.45809000),
(1018806, 1001645, 'CH', 'Zweisimmen', 1, 'zweisimmen', 46.55539000, 7.37302000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001640, 'CH', 'Canton of Fribourg', 1, 'canton-of-fribourg');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1017390, 1001640, 'CH', 'Alterswil', 1, 'alterswil', 46.79587000, 7.25877000),
(1017415, 1001640, 'CH', 'Attalens', 1, 'attalens', 46.50555000, 6.85039000),
(1017426, 1001640, 'CH', 'Avry-sur-Matran', 1, 'avry-sur-matran', 46.78753000, 7.06735000),
(1017440, 1001640, 'CH', 'Bas-Vully', 1, 'bas-vully', 46.96194000, 7.11251000),
(1017450, 1001640, 'CH', 'Belfaux', 1, 'belfaux', 46.82171000, 7.10674000),
(1017596, 1001640, 'CH', 'Bösingen', 1, 'bosingen', 46.89229000, 7.22770000),
(1017566, 1001640, 'CH', 'Broc', 1, 'broc', 46.60513000, 7.09891000),
(1017568, 1001640, 'CH', 'Broye District', 1, 'broye-district', 46.82212000, 6.90249000),
(1017581, 1001640, 'CH', 'Bulle', 1, 'bulle', 46.61797000, 7.05690000),
(1017627, 1001640, 'CH', 'Charmey', 1, 'charmey', 46.61957000, 7.16486000),
(1017641, 1001640, 'CH', 'Châtel-Saint-Denis', 1, 'chatel-saint-denis', 46.52691000, 6.90083000),
(1017654, 1001640, 'CH', 'Corminboeuf', 1, 'corminboeuf', 46.81029000, 7.10535000),
(1017661, 1001640, 'CH', 'Courgevaux', 1, 'courgevaux', 46.90648000, 7.11215000),
(1017671, 1001640, 'CH', 'Cugy', 1, 'cugy', 46.81479000, 6.88888000),
(1017702, 1001640, 'CH', 'Domdidier', 1, 'domdidier', 46.86716000, 7.01337000),
(1017714, 1001640, 'CH', 'Düdingen', 1, 'dudingen', 46.84916000, 7.19150000),
(1017723, 1001640, 'CH', 'Ecublens', 1, 'ecublens', 46.60735000, 6.80895000),
(1017757, 1001640, 'CH', 'Ependes', 1, 'ependes', 46.75368000, 7.14609000),
(1017774, 1001640, 'CH', 'Estavayer-le-Lac', 1, 'estavayer-le-lac', 46.84876000, 6.84650000),
(1017790, 1001640, 'CH', 'Flamatt', 1, 'flamatt', 46.88994000, 7.32204000),
(1017809, 1001640, 'CH', 'Fribourg', 1, 'fribourg', 46.80237000, 7.15128000),
(1017832, 1001640, 'CH', 'Giffers', 1, 'giffers', 46.76230000, 7.20845000),
(1017837, 1001640, 'CH', 'Givisiez', 1, 'givisiez', 46.81201000, 7.12639000),
(1017845, 1001640, 'CH', 'Glâne District', 1, 'glane-district', 46.66667000, 6.91667000),
(1017871, 1001640, 'CH', 'Grolley', 1, 'grolley', 46.83360000, 7.07116000),
(1017876, 1001640, 'CH', 'Gruyère District', 1, 'gruyere-district', 46.60753000, 7.10741000),
(1017877, 1001640, 'CH', 'Gruyères', 1, 'gruyeres', 46.58338000, 7.08207000),
(1017904, 1001640, 'CH', 'Heitenried', 1, 'heitenried', 46.82762000, 7.29944000),
(1017974, 1001640, 'CH', 'Kerzers', 1, 'kerzers', 46.97586000, 7.19570000),
(1018025, 1001640, 'CH', 'La Roche', 1, 'la-roche', 46.69620000, 7.13721000),
(1018028, 1001640, 'CH', 'La Tour-de-Trême', 1, 'la-tour-de-treme', 46.61061000, 7.06496000),
(1018031, 1001640, 'CH', 'Lake District', 1, 'lake-district', 46.91016000, 7.14088000),
(1018122, 1001640, 'CH', 'Marly', 1, 'marly', 46.77611000, 7.16459000),
(1018123, 1001640, 'CH', 'Marsens', 1, 'marsens', 46.65644000, 7.05948000),
(1018190, 1001640, 'CH', 'Mézières', 1, 'mezieres', 46.67958000, 6.92630000),
(1018184, 1001640, 'CH', 'Murten/Morat', 1, 'murten-morat', 46.92827000, 7.11715000),
(1018265, 1001640, 'CH', 'Oberschrot', 1, 'oberschrot', 46.74126000, 7.28149000),
(1018315, 1001640, 'CH', 'Plaffeien', 1, 'plaffeien', 46.74198000, 7.28666000),
(1018323, 1001640, 'CH', 'Praroman', 1, 'praroman', 46.75145000, 7.17778000),
(1018342, 1001640, 'CH', 'Rechthalten', 1, 'rechthalten', 46.76766000, 7.24028000),
(1018368, 1001640, 'CH', 'Riaz', 1, 'riaz', 46.64224000, 7.06183000),
(1018389, 1001640, 'CH', 'Romont', 1, 'romont', 46.69652000, 6.91898000),
(1018398, 1001640, 'CH', 'Rue', 1, 'rue', 46.61916000, 6.82225000),
(1018569, 1001640, 'CH', 'Sâles', 1, 'sales', 46.63473000, 6.97336000),
(1018437, 1001640, 'CH', 'Sankt Antoni', 1, 'sankt-antoni', 46.82207000, 7.26091000),
(1018445, 1001640, 'CH', 'Sarine District', 1, 'sarine-district', 46.78435000, 7.09993000),
(1018473, 1001640, 'CH', 'Schmitten', 1, 'schmitten', 46.85750000, 7.25031000),
(1018510, 1001640, 'CH', 'Sense District', 1, 'sense-district', 46.80132000, 7.26028000),
(1018570, 1001640, 'CH', 'Tafers', 1, 'tafers', 46.81483000, 7.21852000),
(1018601, 1001640, 'CH', 'Treyvaux', 1, 'treyvaux', 46.72796000, 7.13769000),
(1018623, 1001640, 'CH', 'Ueberstorf', 1, 'ueberstorf', 46.86587000, 7.30998000),
(1018674, 1001640, 'CH', 'Veveyse District', 1, 'veveyse-district', 46.55083000, 6.91085000),
(1018679, 1001640, 'CH', 'Villars-sur-Glâne', 1, 'villars-sur-glane', 46.79054000, 7.11717000),
(1018681, 1001640, 'CH', 'Villaz-Saint-Pierre', 1, 'villaz-saint-pierre', 46.72074000, 6.95638000),
(1018695, 1001640, 'CH', 'Vuadens', 1, 'vuadens', 46.61545000, 7.01732000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001647, 'CH', 'Canton of Geneva', 1, 'canton-of-geneva');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1017383, 1001647, 'CH', 'Aire-la-Ville', 1, 'aire-la-ville', 46.19057000, 6.04287000),
(1017399, 1001647, 'CH', 'Anières', 1, 'anieres', 46.27673000, 6.22204000),
(1017451, 1001647, 'CH', 'Bellevue', 1, 'bellevue', 46.25739000, 6.15475000),
(1017464, 1001647, 'CH', 'Bernex', 1, 'bernex', 46.17650000, 6.07544000),
(1017612, 1001647, 'CH', 'Carouge', 1, 'carouge', 46.18096000, 6.13921000),
(1017625, 1001647, 'CH', 'Chancy', 1, 'chancy', 46.15003000, 5.97153000),
(1017643, 1001647, 'CH', 'Chêne-Bougeries', 1, 'chene-bougeries', 46.19843000, 6.18642000),
(1017644, 1001647, 'CH', 'Chêne-Bourg', 1, 'chene-bourg', 46.19534000, 6.19406000),
(1017649, 1001647, 'CH', 'Confignon', 1, 'confignon', 46.17341000, 6.08437000),
(1017656, 1001647, 'CH', 'Corsier', 1, 'corsier', 46.26297000, 6.22461000),
(1017676, 1001647, 'CH', 'Dardagny', 1, 'dardagny', 46.19564000, 5.99497000),
(1017827, 1001647, 'CH', 'Genève', 1, 'geneve', 46.20222000, 6.14569000),
(1017965, 1001647, 'CH', 'Jussy', 1, 'jussy', 46.23590000, 6.26701000),
(1018032, 1001647, 'CH', 'Lancy', 1, 'lancy', 46.18981000, 6.11441000),
(1018055, 1001647, 'CH', 'Le Grand-Saconnex', 1, 'le-grand-saconnex', 46.23188000, 6.12091000),
(1018068, 1001647, 'CH', 'Les Avanchets', 1, 'les-avanchets', 46.22168000, 6.10814000),
(1018141, 1001647, 'CH', 'Meinier', 1, 'meinier', 46.24706000, 6.23423000),
(1018158, 1001647, 'CH', 'Meyrin', 1, 'meyrin', 46.23424000, 6.08025000),
(1018284, 1001647, 'CH', 'Onex', 1, 'onex', 46.18396000, 6.10237000),
(1018316, 1001647, 'CH', 'Plan-les-Ouates', 1, 'plan-les-ouates', 46.16789000, 6.11664000),
(1018330, 1001647, 'CH', 'Puplinge', 1, 'puplinge', 46.21043000, 6.23114000),
(1018448, 1001647, 'CH', 'Satigny', 1, 'satigny', 46.21462000, 6.03553000),
(1018595, 1001647, 'CH', 'Thônex', 1, 'thonex', 46.18815000, 6.19904000),
(1018606, 1001647, 'CH', 'Troinex', 1, 'troinex', 46.16313000, 6.14745000),
(1018661, 1001647, 'CH', 'Vandœuvres', 1, 'vandoeuvres', 46.22179000, 6.20285000),
(1018670, 1001647, 'CH', 'Vernier', 1, 'vernier', 46.21702000, 6.08497000),
(1018672, 1001647, 'CH', 'Versoix', 1, 'versoix', 46.28382000, 6.16214000),
(1018676, 1001647, 'CH', 'Veyrier', 1, 'veyrier', 46.16699000, 6.18436000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001658, 'CH', 'Canton of Jura', 1, 'canton-of-jura');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1017385, 1001658, 'CH', 'Alle', 1, 'alle', 47.42542000, 7.13018000),
(1017442, 1001658, 'CH', 'Bassecourt', 1, 'bassecourt', 47.33808000, 7.24373000),
(1017548, 1001658, 'CH', 'Boncourt', 1, 'boncourt', 47.49493000, 7.01297000),
(1017659, 1001658, 'CH', 'Courfaivre', 1, 'courfaivre', 47.33461000, 7.28186000),
(1017660, 1001658, 'CH', 'Courgenay', 1, 'courgenay', 47.40483000, 7.12522000),
(1017662, 1001658, 'CH', 'Courrendlin', 1, 'courrendlin', 47.33853000, 7.37243000),
(1017663, 1001658, 'CH', 'Courroux', 1, 'courroux', 47.36069000, 7.37371000),
(1017666, 1001658, 'CH', 'Courtételle', 1, 'courtetelle', 47.34074000, 7.31827000),
(1017680, 1001658, 'CH', 'Delémont', 1, 'delemont', 47.36493000, 7.34453000),
(1017681, 1001658, 'CH', 'Delémont District', 1, 'delemont-district', 47.35434000, 7.33053000),
(1017799, 1001658, 'CH', 'Fontenais', 1, 'fontenais', 47.40292000, 7.08108000),
(1017801, 1001658, 'CH', 'Franches-Montagnes District', 1, 'franches-montagnes-district', 47.24935000, 7.04562000),
(1017844, 1001658, 'CH', 'Glovelier', 1, 'glovelier', 47.33534000, 7.20556000),
(1018060, 1001658, 'CH', 'Le Noirmont', 1, 'le-noirmont', 47.22464000, 6.95784000),
(1018069, 1001658, 'CH', 'Les Bois', 1, 'les-bois', 47.17715000, 6.90498000),
(1018071, 1001658, 'CH', 'Les Breuleux', 1, 'les-breuleux', 47.21099000, 7.00792000),
(1018319, 1001658, 'CH', 'Porrentruy', 1, 'porrentruy', 47.41728000, 7.07573000),
(1018320, 1001658, 'CH', 'Porrentruy District', 1, 'porrentruy-district', 47.41475000, 7.07638000),
(1018420, 1001658, 'CH', 'Saignelégier', 1, 'saignelegier', 47.25619000, 6.99648000),
(1018677, 1001658, 'CH', 'Vicques', 1, 'vicques', 47.35000000, 7.41342000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001663, 'CH', 'Canton of Lucerne', 1, 'canton-of-lucerne');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1017363, 1001663, 'CH', 'Adligenswil', 1, 'adligenswil', 47.06521000, 8.36124000),
(1017391, 1001663, 'CH', 'Altishofen', 1, 'altishofen', 47.19916000, 7.96964000),
(1017437, 1001663, 'CH', 'Ballwil', 1, 'ballwil', 47.15371000, 8.32233000),
(1017466, 1001663, 'CH', 'Beromünster', 1, 'beromunster', 47.20612000, 8.19265000),
(1017578, 1001663, 'CH', 'Buchrain', 1, 'buchrain', 47.09625000, 8.34729000),
(1017604, 1001663, 'CH', 'Büron', 1, 'buron', 47.21192000, 8.09420000),
(1017587, 1001663, 'CH', 'Buttisholz', 1, 'buttisholz', 47.11442000, 8.09425000),
(1017674, 1001663, 'CH', 'Dagmersellen', 1, 'dagmersellen', 47.21405000, 7.98519000),
(1017718, 1001663, 'CH', 'Ebikon', 1, 'ebikon', 47.07937000, 8.34041000),
(1017735, 1001663, 'CH', 'Eich', 1, 'eich', 47.15116000, 8.16695000),
(1017746, 1001663, 'CH', 'Emmen', 1, 'emmen', 47.07819000, 8.27331000),
(1017753, 1001663, 'CH', 'Entlebuch', 1, 'entlebuch', 46.99559000, 8.06354000),
(1017754, 1001663, 'CH', 'Entlebuch District', 1, 'entlebuch-district', 46.92590000, 8.01427000),
(1017772, 1001663, 'CH', 'Escholzmatt', 1, 'escholzmatt', 46.91350000, 7.93426000),
(1017776, 1001663, 'CH', 'Ettiswil', 1, 'ettiswil', 47.15031000, 8.01759000),
(1017797, 1001663, 'CH', 'Flühli', 1, 'fluhli', 46.88391000, 8.01558000),
(1017831, 1001663, 'CH', 'Geuensee', 1, 'geuensee', 47.19970000, 8.10689000),
(1017875, 1001663, 'CH', 'Grosswangen', 1, 'grosswangen', 47.13310000, 8.05041000),
(1017887, 1001663, 'CH', 'Gunzwil', 1, 'gunzwil', 47.21072000, 8.17932000),
(1017893, 1001663, 'CH', 'Hasle', 1, 'hasle', 46.97787000, 8.05326000),
(1017912, 1001663, 'CH', 'Hildisrieden', 1, 'hildisrieden', 47.15068000, 8.22582000),
(1017920, 1001663, 'CH', 'Hitzkirch', 1, 'hitzkirch', 47.22403000, 8.26425000),
(1017921, 1001663, 'CH', 'Hochdorf', 1, 'hochdorf', 47.16841000, 8.29179000),
(1017922, 1001663, 'CH', 'Hochdorf District', 1, 'hochdorf-district', 47.17062000, 8.28702000),
(1017926, 1001663, 'CH', 'Hohenrain', 1, 'hohenrain', 47.18083000, 8.31802000),
(1017935, 1001663, 'CH', 'Horw', 1, 'horw', 47.01692000, 8.30956000),
(1017955, 1001663, 'CH', 'Inwil', 1, 'inwil', 47.12530000, 8.34885000),
(1017998, 1001663, 'CH', 'Knutwil', 1, 'knutwil', 47.19953000, 8.07315000),
(1018008, 1001663, 'CH', 'Kriens', 1, 'kriens', 47.03110000, 8.28547000),
(1018087, 1001663, 'CH', 'Littau', 1, 'littau', 47.05000000, 8.26274000),
(1018095, 1001663, 'CH', 'Lucerne-Land District', 1, 'lucerne-land-district', 47.04046000, 8.29271000),
(1018096, 1001663, 'CH', 'Lucerne-Stadt District', 1, 'lucerne-stadt-district', 47.05334000, 8.31063000),
(1018103, 1001663, 'CH', 'Luthern', 1, 'luthern', 47.05753000, 7.91692000),
(1018106, 1001663, 'CH', 'Luzern', 1, 'luzern', 47.05048000, 8.30635000),
(1018119, 1001663, 'CH', 'Malters', 1, 'malters', 47.03628000, 8.18193000),
(1018136, 1001663, 'CH', 'Mauensee', 1, 'mauensee', 47.16703000, 8.06793000),
(1018138, 1001663, 'CH', 'Meggen', 1, 'meggen', 47.04691000, 8.37467000),
(1018139, 1001663, 'CH', 'Meierskappel', 1, 'meierskappel', 47.12470000, 8.44274000),
(1018153, 1001663, 'CH', 'Menznau', 1, 'menznau', 47.08364000, 8.03971000),
(1018208, 1001663, 'CH', 'Nebikon', 1, 'nebikon', 47.19185000, 7.97769000),
(1018214, 1001663, 'CH', 'Neudorf', 1, 'neudorf', 47.17699000, 8.20911000),
(1018216, 1001663, 'CH', 'Neuenkirch', 1, 'neuenkirch', 47.09989000, 8.20416000),
(1018230, 1001663, 'CH', 'Nottwil', 1, 'nottwil', 47.13469000, 8.13774000),
(1018256, 1001663, 'CH', 'Oberkirch', 1, 'oberkirch', 47.15642000, 8.11567000),
(1018306, 1001663, 'CH', 'Pfaffnau', 1, 'pfaffnau', 47.22772000, 7.89719000),
(1018361, 1001663, 'CH', 'Reiden', 1, 'reiden', 47.24719000, 7.97135000),
(1018402, 1001663, 'CH', 'Römerswil', 1, 'romerswil', 47.16881000, 8.24528000),
(1018390, 1001663, 'CH', 'Root', 1, 'root', 47.11458000, 8.39021000),
(1018401, 1001663, 'CH', 'Ruswil', 1, 'ruswil', 47.08425000, 8.12645000),
(1018459, 1001663, 'CH', 'Schenkon', 1, 'schenkon', 47.17765000, 8.13204000),
(1018486, 1001663, 'CH', 'Schötz', 1, 'schotz', 47.16896000, 7.98870000),
(1018489, 1001663, 'CH', 'Schüpfheim', 1, 'schupfheim', 46.95161000, 8.01723000),
(1018476, 1001663, 'CH', 'Schwarzenberg', 1, 'schwarzenberg', 47.01705000, 8.17261000),
(1018508, 1001663, 'CH', 'Sempach', 1, 'sempach', 47.13577000, 8.19149000),
(1018567, 1001663, 'CH', 'Sursee', 1, 'sursee', 47.17088000, 8.11113000),
(1018568, 1001663, 'CH', 'Sursee District', 1, 'sursee-district', 47.15591000, 8.13704000),
(1018602, 1001663, 'CH', 'Triengen', 1, 'triengen', 47.23573000, 8.07652000),
(1018622, 1001663, 'CH', 'Udligenswil', 1, 'udligenswil', 47.09005000, 8.40335000),
(1018690, 1001663, 'CH', 'Vitznau', 1, 'vitznau', 47.01014000, 8.48420000),
(1018726, 1001663, 'CH', 'Wauwil', 1, 'wauwil', 47.18457000, 8.02100000),
(1018729, 1001663, 'CH', 'Weggis', 1, 'weggis', 47.03208000, 8.43219000),
(1018735, 1001663, 'CH', 'Werthenstein', 1, 'werthenstein', 47.05578000, 8.10182000),
(1018748, 1001663, 'CH', 'Wikon', 1, 'wikon', 47.26339000, 7.96801000),
(1018754, 1001663, 'CH', 'Willisau', 1, 'willisau', 47.12183000, 7.99418000),
(1018755, 1001663, 'CH', 'Willisau District', 1, 'willisau-district', 47.14097000, 7.95933000),
(1018766, 1001663, 'CH', 'Wolhusen', 1, 'wolhusen', 47.05983000, 8.07389000),
(1018792, 1001663, 'CH', 'Zell', 1, 'zell', 47.13673000, 7.92495000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001659, 'CH', 'Canton of Neuchâtel', 1, 'canton-of-neuchatel');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1017423, 1001659, 'CH', 'Auvernier', 1, 'auvernier', 46.97545000, 6.87903000),
(1017469, 1001659, 'CH', 'Bevaix', 1, 'bevaix', 46.92958000, 6.81470000),
(1017554, 1001659, 'CH', 'Boudry', 1, 'boudry', 46.94991000, 6.83757000),
(1017555, 1001659, 'CH', 'Boudry District', 1, 'boudry-district', 46.94594000, 6.82842000),
(1017619, 1001659, 'CH', 'Cernier', 1, 'cernier', 47.05878000, 6.90040000),
(1017642, 1001659, 'CH', 'Chézard-Saint-Martin', 1, 'chezard-saint-martin', 47.06629000, 6.93332000),
(1017655, 1001659, 'CH', 'Cornaux', 1, 'cornaux', 47.03960000, 7.01872000),
(1017657, 1001659, 'CH', 'Cortaillod', 1, 'cortaillod', 46.94306000, 6.84440000),
(1017667, 1001659, 'CH', 'Couvet', 1, 'couvet', 46.92525000, 6.63270000),
(1017701, 1001659, 'CH', 'Dombresson', 1, 'dombresson', 47.07192000, 6.95920000),
(1017792, 1001659, 'CH', 'Fleurier', 1, 'fleurier', 46.90224000, 6.58253000),
(1017798, 1001659, 'CH', 'Fontainemelon', 1, 'fontainemelon', 47.05495000, 6.88680000),
(1017855, 1001659, 'CH', 'Gorgier', 1, 'gorgier', 46.90143000, 6.77985000),
(1017861, 1001659, 'CH', 'Grand-Savagnier', 1, 'grand-savagnier', 47.05101000, 6.95489000),
(1018021, 1001659, 'CH', 'La Chaux-de-Fonds', 1, 'la-chaux-de-fonds', 47.09993000, 6.82586000),
(1018022, 1001659, 'CH', 'La Chaux-de-Fonds District', 1, 'la-chaux-de-fonds-district', 47.12159000, 6.84064000),
(1018056, 1001659, 'CH', 'Le Landeron', 1, 'le-landeron', 47.05702000, 7.07052000),
(1018057, 1001659, 'CH', 'Le Locle', 1, 'le-locle', 47.05619000, 6.74913000),
(1018058, 1001659, 'CH', 'Le Locle District', 1, 'le-locle-district', 47.01927000, 6.69635000),
(1018070, 1001659, 'CH', 'Les Brenets', 1, 'les-brenets', 47.06774000, 6.70478000),
(1018072, 1001659, 'CH', 'Les Geneveys-sur-Coffrane', 1, 'les-geneveys-sur-coffrane', 47.01528000, 6.85130000),
(1018073, 1001659, 'CH', 'Les Ponts-de-Martel', 1, 'les-ponts-de-martel', 46.99735000, 6.73059000),
(1018121, 1001659, 'CH', 'Marin-Epagnier', 1, 'marin-epagnier', 47.01017000, 6.99941000),
(1018212, 1001659, 'CH', 'Neuchâtel', 1, 'neuchatel', 46.99179000, 6.93100000),
(1018213, 1001659, 'CH', 'Neuchâtel District', 1, 'neuchatel-district', 47.01799000, 6.99337000),
(1018304, 1001659, 'CH', 'Peseux', 1, 'peseux', 46.98704000, 6.88903000),
(1018422, 1001659, 'CH', 'Saint-Aubin-Sauges', 1, 'saint-aubin-sauges', 46.89419000, 6.77251000),
(1018423, 1001659, 'CH', 'Saint-Blaise', 1, 'saint-blaise', 47.01511000, 6.98832000),
(1018600, 1001659, 'CH', 'Travers', 1, 'travers', 46.94018000, 6.67595000),
(1018656, 1001659, 'CH', 'Val-de-Ruz District', 1, 'val-de-ruz-district', 47.04008000, 6.90829000),
(1018657, 1001659, 'CH', 'Val-de-Travers District', 1, 'val-de-travers-district', 46.90357000, 6.56310000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001654, 'CH', 'Canton of Schaffhausen', 1, 'canton-of-schaffhausen');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1017461, 1001654, 'CH', 'Beringen', 1, 'beringen', 47.69763000, 8.57431000),
(1017502, 1001654, 'CH', 'Bezirk Oberklettgau', 1, 'bezirk-oberklettgau', 47.69893000, 8.51774000),
(1017505, 1001654, 'CH', 'Bezirk Reiat', 1, 'bezirk-reiat', 47.74752000, 8.70821000),
(1017507, 1001654, 'CH', 'Bezirk Schaffhausen', 1, 'bezirk-schaffhausen', 47.69440000, 8.63525000),
(1017508, 1001654, 'CH', 'Bezirk Schleitheim', 1, 'bezirk-schleitheim', 47.75000000, 8.51111000),
(1017512, 1001654, 'CH', 'Bezirk Stein', 1, 'bezirk-stein', 47.66429000, 8.84683000),
(1017515, 1001654, 'CH', 'Bezirk Unterklettgau', 1, 'bezirk-unterklettgau', 47.68000000, 8.46333000),
(1017892, 1001654, 'CH', 'Hallau', 1, 'hallau', 47.69648000, 8.45827000),
(1018110, 1001654, 'CH', 'Löhningen', 1, 'lohningen', 47.70121000, 8.55236000),
(1018217, 1001654, 'CH', 'Neuhausen', 1, 'neuhausen', 47.68579000, 8.61474000),
(1018218, 1001654, 'CH', 'Neunkirch', 1, 'neunkirch', 47.69012000, 8.49981000),
(1018336, 1001654, 'CH', 'Ramsen', 1, 'ramsen', 47.70797000, 8.80949000),
(1018455, 1001654, 'CH', 'Schaffhausen', 1, 'schaffhausen', 47.69732000, 8.63493000),
(1018464, 1001654, 'CH', 'Schleitheim', 1, 'schleitheim', 47.74818000, 8.48213000),
(1018552, 1001654, 'CH', 'Stein am Rhein', 1, 'stein-am-rhein', 47.65933000, 8.85964000),
(1018556, 1001654, 'CH', 'Stetten', 1, 'stetten', 47.74025000, 8.66298000),
(1018588, 1001654, 'CH', 'Thayngen', 1, 'thayngen', 47.74717000, 8.70724000),
(1018751, 1001654, 'CH', 'Wilchingen', 1, 'wilchingen', 47.66745000, 8.46774000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001662, 'CH', 'Canton of Solothurn', 1, 'canton-of-solothurn');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1017438, 1001662, 'CH', 'Balsthal', 1, 'balsthal', 47.31613000, 7.69318000),
(1017468, 1001662, 'CH', 'Bettlach', 1, 'bettlach', 47.20062000, 7.42405000),
(1017478, 1001662, 'CH', 'Bezirk Bucheggberg', 1, 'bezirk-bucheggberg', 47.13205000, 7.47885000),
(1017482, 1001662, 'CH', 'Bezirk Dorneck', 1, 'bezirk-dorneck', 47.48032000, 7.61816000),
(1017485, 1001662, 'CH', 'Bezirk Gäu', 1, 'bezirk-gau', 47.29606000, 7.77503000),
(1017486, 1001662, 'CH', 'Bezirk Gösgen', 1, 'bezirk-gosgen', 47.37758000, 7.92030000),
(1017495, 1001662, 'CH', 'Bezirk Lebern', 1, 'bezirk-lebern', 47.21798000, 7.48053000),
(1017503, 1001662, 'CH', 'Bezirk Olten', 1, 'bezirk-olten', 47.34426000, 7.90755000),
(1017511, 1001662, 'CH', 'Bezirk Solothurn', 1, 'bezirk-solothurn', 47.20818000, 7.53084000),
(1017513, 1001662, 'CH', 'Bezirk Thal', 1, 'bezirk-thal', 47.31095000, 7.63592000),
(1017514, 1001662, 'CH', 'Bezirk Thierstein', 1, 'bezirk-thierstein', 47.38333000, 7.55000000),
(1017519, 1001662, 'CH', 'Bezirk Wasseramt', 1, 'bezirk-wasseramt', 47.18911000, 7.59157000),
(1017525, 1001662, 'CH', 'Biberist', 1, 'biberist', 47.18009000, 7.56246000),
(1017557, 1001662, 'CH', 'Breitenbach', 1, 'breitenbach', 47.40668000, 7.54554000),
(1017605, 1001662, 'CH', 'Büsserach', 1, 'busserach', 47.39415000, 7.54117000),
(1017679, 1001662, 'CH', 'Deitingen', 1, 'deitingen', 47.21515000, 7.61880000),
(1017683, 1001662, 'CH', 'Derendingen', 1, 'derendingen', 47.19850000, 7.58844000),
(1017704, 1001662, 'CH', 'Dornach', 1, 'dornach', 47.48038000, 7.61644000),
(1017728, 1001662, 'CH', 'Egerkingen', 1, 'egerkingen', 47.31957000, 7.78424000),
(1017765, 1001662, 'CH', 'Erlinsbach', 1, 'erlinsbach', 47.39753000, 8.00797000),
(1017814, 1001662, 'CH', 'Fulenbach', 1, 'fulenbach', 47.27103000, 7.83136000),
(1017828, 1001662, 'CH', 'Gerlafingen', 1, 'gerlafingen', 47.17087000, 7.57249000),
(1017868, 1001662, 'CH', 'Grenchen', 1, 'grenchen', 47.19210000, 7.39586000),
(1017886, 1001662, 'CH', 'Gunzgen', 1, 'gunzgen', 47.31375000, 7.83102000),
(1017937, 1001662, 'CH', 'Hägendorf', 1, 'hagendorf', 47.33497000, 7.84133000),
(1017914, 1001662, 'CH', 'Himmelried', 1, 'himmelried', 47.42136000, 7.59985000),
(1017924, 1001662, 'CH', 'Hochwald', 1, 'hochwald', 47.45389000, 7.64459000),
(1017984, 1001662, 'CH', 'Kleinlützel', 1, 'kleinlutzel', 47.42518000, 7.41607000),
(1018007, 1001662, 'CH', 'Kriegstetten', 1, 'kriegstetten', 47.17449000, 7.59799000),
(1018035, 1001662, 'CH', 'Langendorf', 1, 'langendorf', 47.21974000, 7.51469000),
(1018046, 1001662, 'CH', 'Laupersdorf', 1, 'laupersdorf', 47.31260000, 7.65465000),
(1018092, 1001662, 'CH', 'Lostorf', 1, 'lostorf', 47.38372000, 7.94655000),
(1018102, 1001662, 'CH', 'Luterbach', 1, 'luterbach', 47.21426000, 7.58463000),
(1018134, 1001662, 'CH', 'Matzendorf', 1, 'matzendorf', 47.30374000, 7.62820000),
(1018156, 1001662, 'CH', 'Messen', 1, 'messen', 47.09155000, 7.44528000),
(1018224, 1001662, 'CH', 'Niedergösgen', 1, 'niedergosgen', 47.37157000, 7.98837000),
(1018232, 1001662, 'CH', 'Nunningen', 1, 'nunningen', 47.39410000, 7.61951000),
(1018241, 1001662, 'CH', 'Oberbuchsiten', 1, 'oberbuchsiten', 47.31334000, 7.76836000),
(1018254, 1001662, 'CH', 'Obergösgen', 1, 'obergosgen', 47.36538000, 7.95173000),
(1018279, 1001662, 'CH', 'Oensingen', 1, 'oensingen', 47.28764000, 7.71612000),
(1018283, 1001662, 'CH', 'Olten', 1, 'olten', 47.34999000, 7.90329000),
(1018375, 1001662, 'CH', 'Riedholz', 1, 'riedholz', 47.23158000, 7.56829000),
(1018381, 1001662, 'CH', 'Rodersdorf', 1, 'rodersdorf', 47.48082000, 7.45767000),
(1018384, 1001662, 'CH', 'Rohr', 1, 'rohr', 47.41029000, 7.95333000),
(1018485, 1001662, 'CH', 'Schönenwerd', 1, 'schonenwerd', 47.36910000, 8.00167000),
(1018506, 1001662, 'CH', 'Selzach', 1, 'selzach', 47.20531000, 7.45521000),
(1018528, 1001662, 'CH', 'Solothurn', 1, 'solothurn', 47.20791000, 7.53714000),
(1018561, 1001662, 'CH', 'Subingen', 1, 'subingen', 47.19852000, 7.61949000),
(1018603, 1001662, 'CH', 'Trimbach', 1, 'trimbach', 47.36561000, 7.88680000),
(1018721, 1001662, 'CH', 'Wangen', 1, 'wangen', 47.34365000, 7.86982000),
(1018734, 1001662, 'CH', 'Welschenrohr', 1, 'welschenrohr', 47.28052000, 7.52664000),
(1018765, 1001662, 'CH', 'Wolfwil', 1, 'wolfwil', 47.26871000, 7.79652000),
(1018800, 1001662, 'CH', 'Zuchwil', 1, 'zuchwil', 47.20173000, 7.56649000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001644, 'CH', 'Canton of St. Gallen', 1, 'canton-of-st-gallen');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1017393, 1001644, 'CH', 'Altstätten', 1, 'altstatten', 47.37766000, 9.54746000),
(1017394, 1001644, 'CH', 'Amden', 1, 'amden', 47.14888000, 9.14233000),
(1017398, 1001644, 'CH', 'Andwil', 1, 'andwil', 47.43855000, 9.27436000),
(1017419, 1001644, 'CH', 'Au', 1, 'au', 47.43093000, 9.63448000),
(1017430, 1001644, 'CH', 'Bad Ragaz', 1, 'bad-ragaz', 47.00601000, 9.50266000),
(1017435, 1001644, 'CH', 'Balgach', 1, 'balgach', 47.40556000, 9.60702000),
(1017458, 1001644, 'CH', 'Benken', 1, 'benken', 47.19942000, 9.00735000),
(1017567, 1001644, 'CH', 'Bronschhofen', 1, 'bronschhofen', 47.47835000, 9.03454000),
(1017580, 1001644, 'CH', 'Buchs', 1, 'buchs', 47.16743000, 9.47794000),
(1017606, 1001644, 'CH', 'Bütschwil', 1, 'butschwil', 47.36022000, 9.07213000),
(1017678, 1001644, 'CH', 'Degersheim', 1, 'degersheim', 47.37429000, 9.20019000),
(1017687, 1001644, 'CH', 'Diepoldsau', 1, 'diepoldsau', 47.38600000, 9.65558000),
(1017720, 1001644, 'CH', 'Ebnat-Kappel', 1, 'ebnat-kappel', 47.26195000, 9.12473000),
(1017730, 1001644, 'CH', 'Eggersriet', 1, 'eggersriet', 47.44202000, 9.46901000),
(1017736, 1001644, 'CH', 'Eichberg', 1, 'eichberg', 47.34374000, 9.53140000),
(1017769, 1001644, 'CH', 'Eschenbach', 1, 'eschenbach', 47.23981000, 8.92156000),
(1017791, 1001644, 'CH', 'Flawil', 1, 'flawil', 47.41301000, 9.18324000),
(1017794, 1001644, 'CH', 'Flums', 1, 'flums', 47.09058000, 9.34301000),
(1017821, 1001644, 'CH', 'Gams', 1, 'gams', 47.20429000, 9.44172000),
(1017822, 1001644, 'CH', 'Ganterschwil', 1, 'ganterschwil', 47.38103000, 9.09239000),
(1017847, 1001644, 'CH', 'Goldach', 1, 'goldach', 47.47401000, 9.46711000),
(1017849, 1001644, 'CH', 'Goldingen', 1, 'goldingen', 47.26477000, 8.96167000),
(1017850, 1001644, 'CH', 'Gommiswald', 1, 'gommiswald', 47.23128000, 9.02355000),
(1017856, 1001644, 'CH', 'Gossau', 1, 'gossau', 47.41551000, 9.25482000),
(1017859, 1001644, 'CH', 'Grabs', 1, 'grabs', 47.18248000, 9.44395000),
(1017890, 1001644, 'CH', 'Haag (Rheintal)', 1, 'haag-rheintal', 47.20989000, 9.48931000),
(1017938, 1001644, 'CH', 'Häggenschwil', 1, 'haggenschwil', 47.49462000, 9.34487000),
(1017934, 1001644, 'CH', 'Horn', 1, 'horn', 47.49425000, 9.46246000),
(1017959, 1001644, 'CH', 'Jona', 1, 'jona', 47.22983000, 8.83884000),
(1017962, 1001644, 'CH', 'Jonschwil', 1, 'jonschwil', 47.42402000, 9.08689000),
(1017969, 1001644, 'CH', 'Kaltbrunn', 1, 'kaltbrunn', 47.21367000, 9.02590000),
(1017980, 1001644, 'CH', 'Kirchberg', 1, 'kirchberg', 47.41159000, 9.04020000),
(1018009, 1001644, 'CH', 'Krummenau', 1, 'krummenau', 47.24755000, 9.17064000),
(1018081, 1001644, 'CH', 'Lichtensteig', 1, 'lichtensteig', 47.32381000, 9.08758000),
(1018111, 1001644, 'CH', 'Lütisburg', 1, 'lutisburg', 47.39451000, 9.08312000),
(1018160, 1001644, 'CH', 'Mogelsberg', 1, 'mogelsberg', 47.36222000, 9.13541000),
(1018194, 1001644, 'CH', 'Mörschwil', 1, 'morschwil', 47.47097000, 9.42278000),
(1018173, 1001644, 'CH', 'Mosnang', 1, 'mosnang', 47.36252000, 9.04296000),
(1018178, 1001644, 'CH', 'Muolen', 1, 'muolen', 47.52102000, 9.32484000),
(1018221, 1001644, 'CH', 'Niederbüren', 1, 'niederburen', 47.46547000, 9.20568000),
(1018226, 1001644, 'CH', 'Niederhelfenschwil', 1, 'niederhelfenschwil', 47.47487000, 9.18543000),
(1018255, 1001644, 'CH', 'Oberhelfenschwil', 1, 'oberhelfenschwil', 47.35673000, 9.11076000),
(1018262, 1001644, 'CH', 'Oberriet', 1, 'oberriet', 47.32088000, 9.56808000),
(1018269, 1001644, 'CH', 'Oberuzwil', 1, 'oberuzwil', 47.43076000, 9.12724000),
(1018333, 1001644, 'CH', 'Quarten', 1, 'quarten', 47.10700000, 9.24199000),
(1018338, 1001644, 'CH', 'Rapperswil', 1, 'rapperswil', 47.22557000, 8.82228000),
(1018341, 1001644, 'CH', 'Rebstein', 1, 'rebstein', 47.39812000, 9.58503000),
(1018365, 1001644, 'CH', 'Rheineck', 1, 'rheineck', 47.46630000, 9.59028000),
(1018392, 1001644, 'CH', 'Rorschach', 1, 'rorschach', 47.47800000, 9.49030000),
(1018410, 1001644, 'CH', 'Rüthi', 1, 'ruthi', 47.29480000, 9.53857000),
(1018438, 1001644, 'CH', 'Sankt Gallen', 1, 'sankt-gallen', 47.42391000, 9.37477000),
(1018439, 1001644, 'CH', 'Sankt Gallenkappel', 1, 'sankt-gallenkappel', 47.24368000, 8.96438000),
(1018440, 1001644, 'CH', 'Sankt Margrethen', 1, 'sankt-margrethen', 47.45253000, 9.63741000),
(1018442, 1001644, 'CH', 'Sankt Peterzell', 1, 'sankt-peterzell', 47.31782000, 9.17599000),
(1018444, 1001644, 'CH', 'Sargans', 1, 'sargans', 47.04896000, 9.44103000),
(1018482, 1001644, 'CH', 'Schänis', 1, 'schanis', 47.15995000, 9.04549000),
(1018472, 1001644, 'CH', 'Schmerikon', 1, 'schmerikon', 47.22538000, 8.94836000),
(1018509, 1001644, 'CH', 'Sennwald', 1, 'sennwald', 47.26063000, 9.50268000),
(1018515, 1001644, 'CH', 'Sevelen', 1, 'sevelen', 47.12213000, 9.48601000),
(1018581, 1001644, 'CH', 'Thal', 1, 'thal', 47.46677000, 9.56643000),
(1018654, 1001644, 'CH', 'Uznach', 1, 'uznach', 47.22421000, 8.98263000),
(1018655, 1001644, 'CH', 'Uzwil', 1, 'uzwil', 47.43653000, 9.13422000),
(1018700, 1001644, 'CH', 'Wahlkreis Rheintal', 1, 'wahlkreis-rheintal', 47.37769000, 9.57903000),
(1018701, 1001644, 'CH', 'Wahlkreis Rorschach', 1, 'wahlkreis-rorschach', 47.46647000, 9.44246000),
(1018702, 1001644, 'CH', 'Wahlkreis Sarganserland', 1, 'wahlkreis-sarganserland', 47.05000000, 9.43333000),
(1018703, 1001644, 'CH', 'Wahlkreis See-Gaster', 1, 'wahlkreis-see-gaster', 47.22459000, 9.01680000),
(1018704, 1001644, 'CH', 'Wahlkreis St. Gallen', 1, 'wahlkreis-st-gallen', 47.46342000, 9.39052000),
(1018705, 1001644, 'CH', 'Wahlkreis Toggenburg', 1, 'wahlkreis-toggenburg', 47.29453000, 9.17283000),
(1018706, 1001644, 'CH', 'Wahlkreis Werdenberg', 1, 'wahlkreis-werdenberg', 47.17743000, 9.46299000),
(1018707, 1001644, 'CH', 'Wahlkreis Wil', 1, 'wahlkreis-wil', 47.42591000, 9.12451000),
(1018711, 1001644, 'CH', 'Waldkirch', 1, 'waldkirch', 47.46859000, 9.28665000),
(1018713, 1001644, 'CH', 'Walenstadt', 1, 'walenstadt', 47.12411000, 9.31194000),
(1018725, 1001644, 'CH', 'Wattwil', 1, 'wattwil', 47.29955000, 9.08657000),
(1018727, 1001644, 'CH', 'Weesen', 1, 'weesen', 47.13447000, 9.09644000),
(1018749, 1001644, 'CH', 'Wil', 1, 'wil', 47.46152000, 9.04552000),
(1018753, 1001644, 'CH', 'Wildhaus', 1, 'wildhaus', 47.20583000, 9.35402000),
(1018759, 1001644, 'CH', 'Wittenbach', 1, 'wittenbach', 47.46108000, 9.38601000),
(1018805, 1001644, 'CH', 'Zuzwil', 1, 'zuzwil', 47.47452000, 9.11196000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001648, 'CH', 'Canton of Valais', 1, 'canton-of-valais');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1017405, 1001648, 'CH', 'Ardon', 1, 'ardon', 46.20951000, 7.26012000),
(1017427, 1001648, 'CH', 'Ayent', 1, 'ayent', 46.28249000, 7.41028000),
(1017433, 1001648, 'CH', 'Bagnes', 1, 'bagnes', 46.08333000, 7.21667000),
(1017439, 1001648, 'CH', 'Baltschieder', 1, 'baltschieder', 46.30888000, 7.86570000),
(1017441, 1001648, 'CH', 'Basse-Nendaz', 1, 'basse-nendaz', 46.18993000, 7.31209000),
(1017561, 1001648, 'CH', 'Brig', 1, 'brig', 46.31667000, 7.98333000),
(1017562, 1001648, 'CH', 'Brig District', 1, 'brig-district', 46.28255000, 8.01185000),
(1017621, 1001648, 'CH', 'Chalais', 1, 'chalais', 46.26758000, 7.51145000),
(1017623, 1001648, 'CH', 'Chamoson', 1, 'chamoson', 46.20275000, 7.22319000),
(1017624, 1001648, 'CH', 'Champéry', 1, 'champery', 46.17543000, 6.86903000),
(1017628, 1001648, 'CH', 'Charrat', 1, 'charrat', 46.12490000, 7.13138000),
(1017632, 1001648, 'CH', 'Chermignon-d’en Haut', 1, 'chermignon-d-en-haut', 46.28844000, 7.47487000),
(1017637, 1001648, 'CH', 'Chippis', 1, 'chippis', 46.28020000, 7.53962000),
(1017646, 1001648, 'CH', 'Collombey', 1, 'collombey', 46.27385000, 6.94789000),
(1017650, 1001648, 'CH', 'Conthey', 1, 'conthey', 46.22370000, 7.30283000),
(1017651, 1001648, 'CH', 'Conthey District', 1, 'conthey-district', 46.20485000, 7.27857000),
(1017755, 1001648, 'CH', 'Entremont District', 1, 'entremont-district', 46.02099000, 7.21260000),
(1017778, 1001648, 'CH', 'Evionnaz', 1, 'evionnaz', 46.18096000, 7.02232000),
(1017779, 1001648, 'CH', 'Evolène', 1, 'evolene', 46.11422000, 7.49407000),
(1017788, 1001648, 'CH', 'Fiesch', 1, 'fiesch', 46.39981000, 8.13533000),
(1017815, 1001648, 'CH', 'Fully', 1, 'fully', 46.13851000, 7.11468000),
(1017820, 1001648, 'CH', 'Gampel', 1, 'gampel', 46.31599000, 7.74210000),
(1017851, 1001648, 'CH', 'Goms District', 1, 'goms-district', 46.46161000, 8.22190000),
(1017879, 1001648, 'CH', 'Grächen', 1, 'grachen', 46.19529000, 7.83745000),
(1017869, 1001648, 'CH', 'Grimisuat', 1, 'grimisuat', 46.25938000, 7.38408000),
(1017881, 1001648, 'CH', 'Grône', 1, 'grone', 46.25288000, 7.45947000),
(1017941, 1001648, 'CH', 'Hérémence', 1, 'heremence', 46.18032000, 7.40477000),
(1017940, 1001648, 'CH', 'Hérens District', 1, 'herens-district', 46.19407000, 7.42391000),
(1018065, 1001648, 'CH', 'Lens', 1, 'lens', 46.28298000, 7.44976000),
(1018074, 1001648, 'CH', 'Leuk', 1, 'leuk', 46.31736000, 7.63412000),
(1018075, 1001648, 'CH', 'Leuk District', 1, 'leuk-district', 46.31439000, 7.67291000),
(1018076, 1001648, 'CH', 'Leukerbad', 1, 'leukerbad', 46.37943000, 7.62687000),
(1018080, 1001648, 'CH', 'Leytron', 1, 'leytron', 46.18660000, 7.20780000),
(1018125, 1001648, 'CH', 'Martigny District', 1, 'martigny-district', 46.12386000, 7.10354000),
(1018126, 1001648, 'CH', 'Martigny-Combe', 1, 'martigny-combe', 46.07817000, 7.05099000),
(1018127, 1001648, 'CH', 'Martigny-Ville', 1, 'martigny-ville', 46.10276000, 7.07245000),
(1018165, 1001648, 'CH', 'Montana', 1, 'montana', 46.31338000, 7.48839000),
(1018167, 1001648, 'CH', 'Monthey', 1, 'monthey', 46.25451000, 6.95406000),
(1018168, 1001648, 'CH', 'Monthey District', 1, 'monthey-district', 46.27043000, 6.90274000),
(1018207, 1001648, 'CH', 'Naters', 1, 'naters', 46.32536000, 7.98912000),
(1018290, 1001648, 'CH', 'Orsières', 1, 'orsieres', 46.02903000, 7.14437000),
(1018337, 1001648, 'CH', 'Randogne', 1, 'randogne', 46.30952000, 7.50058000),
(1018339, 1001648, 'CH', 'Raron', 1, 'raron', 46.31196000, 7.80029000),
(1018340, 1001648, 'CH', 'Raron District', 1, 'raron-district', 46.30000000, 7.80000000),
(1018374, 1001648, 'CH', 'Riddes', 1, 'riddes', 46.17276000, 7.22360000),
(1018416, 1001648, 'CH', 'Saas-Fee', 1, 'saas-fee', 46.10805000, 7.92741000),
(1018417, 1001648, 'CH', 'Saas-Grund', 1, 'saas-grund', 46.12281000, 7.93651000),
(1018421, 1001648, 'CH', 'Saillon', 1, 'saillon', 46.17035000, 7.18771000),
(1018427, 1001648, 'CH', 'Saint-Léonard', 1, 'saint-leonard', 46.25152000, 7.41714000),
(1018428, 1001648, 'CH', 'Saint-Maurice', 1, 'saint-maurice', 46.21826000, 7.00320000),
(1018429, 1001648, 'CH', 'Saint-Maurice District', 1, 'saint-maurice-district', 46.15384000, 6.99823000),
(1018432, 1001648, 'CH', 'Salgesch', 1, 'salgesch', 46.31155000, 7.57120000),
(1018434, 1001648, 'CH', 'Salvan', 1, 'salvan', 46.11890000, 7.02078000),
(1018441, 1001648, 'CH', 'Sankt Niklaus', 1, 'sankt-niklaus', 46.17717000, 7.80349000),
(1018452, 1001648, 'CH', 'Savièse', 1, 'saviese', 46.25115000, 7.34558000),
(1018453, 1001648, 'CH', 'Saxon', 1, 'saxon', 46.14937000, 7.17514000),
(1018517, 1001648, 'CH', 'Sierre', 1, 'sierre', 46.29192000, 7.53559000),
(1018518, 1001648, 'CH', 'Sierre District', 1, 'sierre-district', 46.27052000, 7.51570000),
(1018524, 1001648, 'CH', 'Sion District', 1, 'sion-district', 46.23343000, 7.34939000),
(1018527, 1001648, 'CH', 'Sitten', 1, 'sitten', 46.22739000, 7.35559000),
(1018545, 1001648, 'CH', 'Stalden', 1, 'stalden', 46.23341000, 7.87273000),
(1018573, 1001648, 'CH', 'Tanay', 1, 'tanay', 46.34503000, 6.83041000),
(1018607, 1001648, 'CH', 'Troistorrents', 1, 'troistorrents', 46.22890000, 6.91589000),
(1018615, 1001648, 'CH', 'Turtmann', 1, 'turtmann', 46.30028000, 7.70200000),
(1018662, 1001648, 'CH', 'Varen', 1, 'varen', 46.31860000, 7.60743000),
(1018668, 1001648, 'CH', 'Verbier', 1, 'verbier', 46.10020000, 7.22651000),
(1018669, 1001648, 'CH', 'Vernayaz', 1, 'vernayaz', 46.13667000, 7.03906000),
(1018697, 1001648, 'CH', 'Vétroz', 1, 'vetroz', 46.22171000, 7.27858000),
(1018675, 1001648, 'CH', 'Vex', 1, 'vex', 46.21239000, 7.39826000),
(1018686, 1001648, 'CH', 'Vionnaz', 1, 'vionnaz', 46.31101000, 6.90062000),
(1018687, 1001648, 'CH', 'Visp', 1, 'visp', 46.29370000, 7.88149000),
(1018688, 1001648, 'CH', 'Visp District', 1, 'visp-district', 46.17612000, 7.85609000),
(1018689, 1001648, 'CH', 'Visperterminen', 1, 'visperterminen', 46.25899000, 7.90192000),
(1018694, 1001648, 'CH', 'Vouvry', 1, 'vouvry', 46.33746000, 6.88950000),
(1018793, 1001648, 'CH', 'Zermatt', 1, 'zermatt', 46.01998000, 7.74863000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001651, 'CH', 'Canton of Vaud', 1, 'canton-of-vaud');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1017381, 1001651, 'CH', 'Aigle', 1, 'aigle', 46.31810000, 6.96457000),
(1017382, 1001651, 'CH', 'Aigle District', 1, 'aigle-district', 46.30577000, 7.02974000),
(1017401, 1001651, 'CH', 'Apples', 1, 'apples', 46.55237000, 6.42889000),
(1017412, 1001651, 'CH', 'Arzier', 1, 'arzier', 46.45962000, 6.20813000),
(1017422, 1001651, 'CH', 'Aubonne', 1, 'aubonne', 46.49514000, 6.39155000),
(1017425, 1001651, 'CH', 'Avenches', 1, 'avenches', 46.88004000, 7.04071000),
(1017436, 1001651, 'CH', 'Ballens', 1, 'ballens', 46.55485000, 6.37310000),
(1017446, 1001651, 'CH', 'Bavois', 1, 'bavois', 46.68403000, 6.56710000),
(1017449, 1001651, 'CH', 'Begnins', 1, 'begnins', 46.44152000, 6.24762000),
(1017455, 1001651, 'CH', 'Belmont-sur-Lausanne', 1, 'belmont-sur-lausanne', 46.51891000, 6.67636000),
(1017465, 1001651, 'CH', 'Berolle', 1, 'berolle', 46.55798000, 6.33551000),
(1017470, 1001651, 'CH', 'Bex', 1, 'bex', 46.24965000, 7.00980000),
(1017539, 1001651, 'CH', 'Bière', 1, 'biere', 46.53761000, 6.33362000),
(1017543, 1001651, 'CH', 'Blécherette', 1, 'blecherette', 46.53932000, 6.62227000),
(1017541, 1001651, 'CH', 'Blonay', 1, 'blonay', 46.46778000, 6.89615000),
(1017551, 1001651, 'CH', 'Bottens', 1, 'bottens', 46.61596000, 6.66149000),
(1017569, 1001651, 'CH', 'Broye-Vully District', 1, 'broye-vully-district', 46.78082000, 6.90161000),
(1017586, 1001651, 'CH', 'Bussigny', 1, 'bussigny', 46.55110000, 6.55597000),
(1017616, 1001651, 'CH', 'Caux', 1, 'caux', 46.43241000, 6.93855000),
(1017626, 1001651, 'CH', 'Chardonne', 1, 'chardonne', 46.47676000, 6.82680000),
(1017640, 1001651, 'CH', 'Château-d\'Oex', 1, 'chateau-d-oex', 46.47455000, 7.13155000),
(1017629, 1001651, 'CH', 'Chavannes', 1, 'chavannes', 46.53005000, 6.57068000),
(1017630, 1001651, 'CH', 'Chavannes-le-Veyron', 1, 'chavannes-le-veyron', 46.60700000, 6.45086000),
(1017631, 1001651, 'CH', 'Chavornay', 1, 'chavornay', 46.70244000, 6.56940000),
(1017633, 1001651, 'CH', 'Cheseaux', 1, 'cheseaux', 46.58624000, 6.60587000),
(1017634, 1001651, 'CH', 'Chevilly', 1, 'chevilly', 46.64272000, 6.47661000),
(1017635, 1001651, 'CH', 'Chexbres', 1, 'chexbres', 46.48208000, 6.77805000),
(1017647, 1001651, 'CH', 'Colombier', 1, 'colombier', 46.55709000, 6.47284000),
(1017652, 1001651, 'CH', 'Coppet', 1, 'coppet', 46.31682000, 6.19114000),
(1017658, 1001651, 'CH', 'Cossonay', 1, 'cossonay', 46.61443000, 6.50631000),
(1017668, 1001651, 'CH', 'Crissier', 1, 'crissier', 46.54586000, 6.57567000),
(1017669, 1001651, 'CH', 'Cuarnens', 1, 'cuarnens', 46.62545000, 6.43713000),
(1017672, 1001651, 'CH', 'Cully', 1, 'cully', 46.48892000, 6.72945000),
(1017721, 1001651, 'CH', 'Echallens', 1, 'echallens', 46.64130000, 6.63317000),
(1017722, 1001651, 'CH', 'Ecublens', 1, 'ecublens', 46.52899000, 6.56261000),
(1017756, 1001651, 'CH', 'Epalinges', 1, 'epalinges', 46.54896000, 6.66831000),
(1017785, 1001651, 'CH', 'Ferreyres', 1, 'ferreyres', 46.65804000, 6.48520000),
(1017800, 1001651, 'CH', 'Founex', 1, 'founex', 46.33277000, 6.19243000),
(1017811, 1001651, 'CH', 'Froideville', 1, 'froideville', 46.60123000, 6.68085000),
(1017826, 1001651, 'CH', 'Genolier', 1, 'genolier', 46.43537000, 6.21809000),
(1017833, 1001651, 'CH', 'Gimel', 1, 'gimel', 46.50945000, 6.30736000),
(1017838, 1001651, 'CH', 'Gland', 1, 'gland', 46.42082000, 6.27010000),
(1017860, 1001651, 'CH', 'Grancy', 1, 'grancy', 46.59214000, 6.46391000),
(1017862, 1001651, 'CH', 'Grandson', 1, 'grandson', 46.80946000, 6.64600000),
(1017872, 1001651, 'CH', 'Gros-de-Vaud District', 1, 'gros-de-vaud-district', 46.65180000, 6.65728000),
(1017878, 1001651, 'CH', 'Gryon', 1, 'gryon', 46.27377000, 7.05975000),
(1017961, 1001651, 'CH', 'Jongny', 1, 'jongny', 46.47883000, 6.84114000),
(1017964, 1001651, 'CH', 'Jura-Nord vaudois District', 1, 'jura-nord-vaudois-district', 46.72981000, 6.45429000),
(1018026, 1001651, 'CH', 'La Sarraz', 1, 'la-sarraz', 46.65863000, 6.51077000),
(1018027, 1001651, 'CH', 'La Tour-de-Peilz', 1, 'la-tour-de-peilz', 46.45312000, 6.85856000),
(1018048, 1001651, 'CH', 'Lausanne', 1, 'lausanne', 46.51600000, 6.63282000),
(1018049, 1001651, 'CH', 'Lausanne District', 1, 'lausanne-district', 46.52131000, 6.63334000),
(1018052, 1001651, 'CH', 'Lavaux-Oron District', 1, 'lavaux-oron-district', 46.53618000, 6.77086000),
(1018054, 1001651, 'CH', 'Le Chenit', 1, 'le-chenit', 46.60688000, 6.23062000),
(1018059, 1001651, 'CH', 'Le Mont-sur-Lausanne', 1, 'le-mont-sur-lausanne', 46.55815000, 6.63145000),
(1018061, 1001651, 'CH', 'Le Vaud', 1, 'le-vaud', 46.47753000, 6.23603000),
(1018079, 1001651, 'CH', 'Leysin', 1, 'leysin', 46.34183000, 7.01151000),
(1018094, 1001651, 'CH', 'Lucens', 1, 'lucens', 46.70854000, 6.83931000),
(1018104, 1001651, 'CH', 'Lutry', 1, 'lutry', 46.50241000, 6.68647000),
(1018137, 1001651, 'CH', 'Mauraz', 1, 'mauraz', 46.60558000, 6.42074000),
(1018161, 1001651, 'CH', 'Mollens', 1, 'mollens', 46.57760000, 6.36320000),
(1018164, 1001651, 'CH', 'Montagny', 1, 'montagny', 46.79289000, 6.61222000),
(1018169, 1001651, 'CH', 'Montreux', 1, 'montreux', 46.43301000, 6.91143000),
(1018171, 1001651, 'CH', 'Morges', 1, 'morges', 46.51127000, 6.49854000),
(1018172, 1001651, 'CH', 'Morges District', 1, 'morges-district', 46.53578000, 6.48662000),
(1018174, 1001651, 'CH', 'Moudon', 1, 'moudon', 46.66758000, 6.79781000),
(1018233, 1001651, 'CH', 'Nyon', 1, 'nyon', 46.38318000, 6.23955000),
(1018234, 1001651, 'CH', 'Nyon District', 1, 'nyon-district', 46.42004000, 6.22177000),
(1018282, 1001651, 'CH', 'Ollon', 1, 'ollon', 46.29524000, 6.99314000),
(1018286, 1001651, 'CH', 'Orbe', 1, 'orbe', 46.72504000, 6.53069000),
(1018288, 1001651, 'CH', 'Oron-la-Ville', 1, 'oron-la-ville', 46.57094000, 6.82557000),
(1018295, 1001651, 'CH', 'Ouest Lausannois District', 1, 'ouest-lausannois-district', 46.54589000, 6.56995000),
(1018296, 1001651, 'CH', 'Pailly', 1, 'pailly', 46.70123000, 6.67540000),
(1018297, 1001651, 'CH', 'Palézieux', 1, 'palezieux', 46.54191000, 6.83989000),
(1018298, 1001651, 'CH', 'Pampigny', 1, 'pampigny', 46.58093000, 6.42941000),
(1018299, 1001651, 'CH', 'Paudex', 1, 'paudex', 46.50548000, 6.66819000),
(1018300, 1001651, 'CH', 'Payerne', 1, 'payerne', 46.82192000, 6.93817000),
(1018301, 1001651, 'CH', 'Penthalaz', 1, 'penthalaz', 46.61077000, 6.52519000),
(1018302, 1001651, 'CH', 'Penthéréaz', 1, 'penthereaz', 46.68171000, 6.60390000),
(1018303, 1001651, 'CH', 'Perroy', 1, 'perroy', 46.46690000, 6.35349000),
(1018317, 1001651, 'CH', 'Pompaples', 1, 'pompaples', 46.66699000, 6.50966000),
(1018322, 1001651, 'CH', 'Prangins', 1, 'prangins', 46.39518000, 6.24960000),
(1018327, 1001651, 'CH', 'Préverenges', 1, 'preverenges', 46.51854000, 6.52682000),
(1018326, 1001651, 'CH', 'Prilly', 1, 'prilly', 46.53698000, 6.60456000),
(1018328, 1001651, 'CH', 'Puidoux', 1, 'puidoux', 46.50093000, 6.78249000),
(1018329, 1001651, 'CH', 'Pully', 1, 'pully', 46.51027000, 6.66183000),
(1018364, 1001651, 'CH', 'Renens', 1, 'renens', 46.53989000, 6.58810000),
(1018380, 1001651, 'CH', 'Riviera-Pays-d\'Enhaut District', 1, 'riviera-pays-d-enhaut-district', 46.46459000, 6.88499000),
(1018386, 1001651, 'CH', 'Rolle', 1, 'rolle', 46.45820000, 6.33499000),
(1018387, 1001651, 'CH', 'Romanel-sur-Lausanne', 1, 'romanel-sur-lausanne', 46.56403000, 6.60538000),
(1018424, 1001651, 'CH', 'Saint-Cergue', 1, 'saint-cergue', 46.44590000, 6.15737000),
(1018426, 1001651, 'CH', 'Saint-Livres', 1, 'saint-livres', 46.50794000, 6.38753000),
(1018430, 1001651, 'CH', 'Saint-Prex', 1, 'saint-prex', 46.47963000, 6.45992000),
(1018431, 1001651, 'CH', 'Sainte-Croix', 1, 'sainte-croix', 46.82203000, 6.50283000),
(1018450, 1001651, 'CH', 'Saubraz', 1, 'saubraz', 46.51606000, 6.33018000),
(1018451, 1001651, 'CH', 'Savigny', 1, 'savigny', 46.53844000, 6.73222000),
(1018531, 1001651, 'CH', 'Sottens', 1, 'sottens', 46.65521000, 6.74197000),
(1018611, 1001651, 'CH', 'Trélex', 1, 'trelex', 46.41538000, 6.20813000),
(1018659, 1001651, 'CH', 'Vallorbe', 1, 'vallorbe', 46.71256000, 6.37894000),
(1018673, 1001651, 'CH', 'Vevey', 1, 'vevey', 46.46299000, 6.84345000),
(1018680, 1001651, 'CH', 'Villars-sur-Ollon', 1, 'villars-sur-ollon', 46.29832000, 7.05631000),
(1018682, 1001651, 'CH', 'Villeneuve', 1, 'villeneuve', 46.39869000, 6.92654000),
(1018696, 1001651, 'CH', 'Vuarrens', 1, 'vuarrens', 46.68578000, 6.64793000),
(1018790, 1001651, 'CH', 'Yverdon-les-Bains', 1, 'yverdon-les-bains', 46.77852000, 6.64115000),
(1018791, 1001651, 'CH', 'Yvonand', 1, 'yvonand', 46.80034000, 6.74249000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001646, 'CH', 'Canton of Zug', 1, 'canton-of-zug');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1017428, 1001646, 'CH', 'Baar', 1, 'baar', 47.19625000, 8.52954000),
(1017622, 1001646, 'CH', 'Cham', 1, 'cham', 47.18213000, 8.46358000),
(1017944, 1001646, 'CH', 'Hünenberg', 1, 'hunenberg', 47.17536000, 8.42497000),
(1018152, 1001646, 'CH', 'Menzingen', 1, 'menzingen', 47.17764000, 8.59215000),
(1018395, 1001646, 'CH', 'Rotkreuz', 1, 'rotkreuz', 47.14283000, 8.43140000),
(1018554, 1001646, 'CH', 'Steinhausen', 1, 'steinhausen', 47.19510000, 8.48581000),
(1018638, 1001646, 'CH', 'Unterägeri', 1, 'unterageri', 47.13645000, 8.58530000),
(1018708, 1001646, 'CH', 'Walchwil', 1, 'walchwil', 47.10169000, 8.51693000),
(1018801, 1001646, 'CH', 'Zug', 1, 'zug', 47.17242000, 8.51745000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001656, 'CH', 'canton of Zürich', 1, 'canton-of-zurich');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1017364, 1001656, 'CH', 'Adliswil', 1, 'adliswil', 47.30997000, 8.52462000),
(1017365, 1001656, 'CH', 'Adliswil / Adliswil (Stadtkern)', 1, 'adliswil-adliswil-stadtkern', 47.31128000, 8.52675000),
(1017366, 1001656, 'CH', 'Adliswil / Hündli-Zopf', 1, 'adliswil-hundli-zopf', 47.31637000, 8.51888000),
(1017367, 1001656, 'CH', 'Adliswil / Oberleimbach', 1, 'adliswil-oberleimbach', 47.32020000, 8.51508000),
(1017368, 1001656, 'CH', 'Adliswil / Sonnenberg', 1, 'adliswil-sonnenberg', 47.30958000, 8.52055000),
(1017369, 1001656, 'CH', 'Adliswil / Sood', 1, 'adliswil-sood', 47.31870000, 8.52425000),
(1017370, 1001656, 'CH', 'Adliswil / Tal', 1, 'adliswil-tal', 47.31142000, 8.53446000),
(1017372, 1001656, 'CH', 'Aesch', 1, 'aesch', 47.32970000, 8.65410000),
(1017375, 1001656, 'CH', 'Affoltern / Hasenbüel', 1, 'affoltern-hasenbuel', 47.27324000, 8.45218000),
(1017376, 1001656, 'CH', 'Affoltern / Oberdorf', 1, 'affoltern-oberdorf', 47.27852000, 8.45651000),
(1017377, 1001656, 'CH', 'Affoltern / Sonnenberg', 1, 'affoltern-sonnenberg', 47.28055000, 8.46008000),
(1017378, 1001656, 'CH', 'Affoltern / Unterdorf', 1, 'affoltern-unterdorf', 47.28277000, 8.45409000),
(1017379, 1001656, 'CH', 'Affoltern am Albis', 1, 'affoltern-am-albis', 47.27743000, 8.45128000),
(1017396, 1001656, 'CH', 'Andelfingen', 1, 'andelfingen', 47.59447000, 8.67826000),
(1017418, 1001656, 'CH', 'Au', 1, 'au', 47.24185000, 8.64406000),
(1017420, 1001656, 'CH', 'Au / Mittel-Dorf', 1, 'au-mittel-dorf', 47.24303000, 8.64591000),
(1017421, 1001656, 'CH', 'Au / Unter-Dorf', 1, 'au-unter-dorf', 47.24730000, 8.63270000),
(1017429, 1001656, 'CH', 'Bachenbülach', 1, 'bachenbulach', 47.50317000, 8.54556000),
(1017591, 1001656, 'CH', 'Bäretswil', 1, 'baretswil', 47.33709000, 8.85645000),
(1017443, 1001656, 'CH', 'Bassersdorf', 1, 'bassersdorf', 47.44342000, 8.62851000),
(1017445, 1001656, 'CH', 'Bauma', 1, 'bauma', 47.36745000, 8.87905000),
(1017457, 1001656, 'CH', 'Benglen', 1, 'benglen', 47.36077000, 8.63687000),
(1017472, 1001656, 'CH', 'Bezirk Affoltern', 1, 'bezirk-affoltern', 47.27311000, 8.47444000),
(1017473, 1001656, 'CH', 'Bezirk Andelfingen', 1, 'bezirk-andelfingen', 47.61328000, 8.68124000),
(1017479, 1001656, 'CH', 'Bezirk Bülach', 1, 'bezirk-bulach', 47.49706000, 8.56764000),
(1017480, 1001656, 'CH', 'Bezirk Dielsdorf', 1, 'bezirk-dielsdorf', 47.47181000, 8.45631000),
(1017481, 1001656, 'CH', 'Bezirk Dietikon', 1, 'bezirk-dietikon', 47.38804000, 8.44260000),
(1017488, 1001656, 'CH', 'Bezirk Hinwil', 1, 'bezirk-hinwil', 47.29646000, 8.83431000),
(1017489, 1001656, 'CH', 'Bezirk Horgen', 1, 'bezirk-horgen', 47.25767000, 8.59702000),
(1017499, 1001656, 'CH', 'Bezirk Meilen', 1, 'bezirk-meilen', 47.27920000, 8.66259000),
(1017504, 1001656, 'CH', 'Bezirk Pfäffikon', 1, 'bezirk-pfaffikon', 47.40905000, 8.77208000),
(1017516, 1001656, 'CH', 'Bezirk Uster', 1, 'bezirk-uster', 47.34952000, 8.71353000),
(1017520, 1001656, 'CH', 'Bezirk Winterthur', 1, 'bezirk-winterthur', 47.50781000, 8.76900000),
(1017523, 1001656, 'CH', 'Bezirk Zürich', 1, 'bezirk-zurich', 47.37110000, 8.54323000),
(1017531, 1001656, 'CH', 'Binz', 1, 'binz', 47.35635000, 8.62657000),
(1017532, 1001656, 'CH', 'Binzikon', 1, 'binzikon', 47.27632000, 8.75851000),
(1017534, 1001656, 'CH', 'Birchwil', 1, 'birchwil', 47.45431000, 8.63477000),
(1017535, 1001656, 'CH', 'Birmensdorf', 1, 'birmensdorf', 47.35515000, 8.44256000),
(1017550, 1001656, 'CH', 'Bonstetten', 1, 'bonstetten', 47.31505000, 8.46836000),
(1017573, 1001656, 'CH', 'Brütten', 1, 'brutten', 47.47318000, 8.67569000),
(1017574, 1001656, 'CH', 'Brüttisellen', 1, 'bruttisellen', 47.42173000, 8.63263000),
(1017576, 1001656, 'CH', 'Bubikon', 1, 'bubikon', 47.26698000, 8.81790000),
(1017598, 1001656, 'CH', 'Bülach', 1, 'bulach', 47.52197000, 8.54049000),
(1017599, 1001656, 'CH', 'Bülach / Gstückt', 1, 'bulach-gstuckt', 47.52337000, 8.54879000),
(1017600, 1001656, 'CH', 'Bülach / Seematt', 1, 'bulach-seematt', 47.51716000, 8.54651000),
(1017601, 1001656, 'CH', 'Bülach / Soligänter', 1, 'bulach-soliganter', 47.52632000, 8.54106000),
(1017673, 1001656, 'CH', 'Dachsen', 1, 'dachsen', 47.66515000, 8.61790000),
(1017706, 1001656, 'CH', 'Dällikon / Dällikon (Dorf)', 1, 'dallikon-dallikon-dorf', 47.43983000, 8.43813000),
(1017707, 1001656, 'CH', 'Dänikon', 1, 'danikon', 47.44674000, 8.40648000),
(1017685, 1001656, 'CH', 'Dielsdorf', 1, 'dielsdorf', 47.48146000, 8.45850000),
(1017689, 1001656, 'CH', 'Dietikon', 1, 'dietikon', 47.40165000, 8.40015000),
(1017690, 1001656, 'CH', 'Dietikon / Almend', 1, 'dietikon-almend', 47.40477000, 8.39168000),
(1017691, 1001656, 'CH', 'Dietikon / Guggenbühl', 1, 'dietikon-guggenbuhl', 47.40009000, 8.40818000),
(1017692, 1001656, 'CH', 'Dietikon / Hofacker', 1, 'dietikon-hofacker', 47.39718000, 8.41609000),
(1017693, 1001656, 'CH', 'Dietikon / Kreuzacker', 1, 'dietikon-kreuzacker', 47.39919000, 8.40146000),
(1017694, 1001656, 'CH', 'Dietikon / Oberdorf', 1, 'dietikon-oberdorf', 47.40065000, 8.39416000),
(1017695, 1001656, 'CH', 'Dietikon / Schönenwerd', 1, 'dietikon-schonenwerd', 47.39706000, 8.42576000),
(1017696, 1001656, 'CH', 'Dietikon / Vorstadt', 1, 'dietikon-vorstadt', 47.40819000, 8.39719000),
(1017697, 1001656, 'CH', 'Dietlikon / Dietlikon (Dorf)', 1, 'dietlikon-dietlikon-dorf', 47.41827000, 8.61880000),
(1017698, 1001656, 'CH', 'Dietlikon / Eichwiesen', 1, 'dietlikon-eichwiesen', 47.41910000, 8.62078000),
(1017703, 1001656, 'CH', 'Dorf', 1, 'dorf', 47.23900000, 8.73567000),
(1017709, 1001656, 'CH', 'Dübendorf', 1, 'dubendorf', 47.39724000, 8.61872000),
(1017710, 1001656, 'CH', 'Dübendorf / Kunklerstrasse', 1, 'dubendorf-kunklerstrasse', 47.40109000, 8.62724000),
(1017711, 1001656, 'CH', 'Dübendorf / Sonnenberg', 1, 'dubendorf-sonnenberg', 47.39469000, 8.63162000),
(1017712, 1001656, 'CH', 'Dübendorf / Vogelquartier', 1, 'dubendorf-vogelquartier', 47.39502000, 8.61184000),
(1017713, 1001656, 'CH', 'Dübendorf / Wasserfurren', 1, 'dubendorf-wasserfurren', 47.39352000, 8.60850000),
(1017715, 1001656, 'CH', 'Dürnten', 1, 'durnten', 47.27856000, 8.84156000),
(1017719, 1001656, 'CH', 'Ebmatingen', 1, 'ebmatingen', 47.34987000, 8.64013000),
(1017724, 1001656, 'CH', 'Effretikon', 1, 'effretikon', 47.42575000, 8.69094000),
(1017725, 1001656, 'CH', 'Effretikon / Rappenhalde-Bannhalde', 1, 'effretikon-rappenhalde-bannhalde', 47.42388000, 8.69653000),
(1017726, 1001656, 'CH', 'Effretikon / Rikon', 1, 'effretikon-rikon', 47.43099000, 8.68624000),
(1017727, 1001656, 'CH', 'Effretikon / Watt', 1, 'effretikon-watt', 47.42797000, 8.69822000),
(1017729, 1001656, 'CH', 'Egg', 1, 'egg', 47.29976000, 8.69032000),
(1017739, 1001656, 'CH', 'Elgg', 1, 'elgg', 47.49715000, 8.86523000),
(1017740, 1001656, 'CH', 'Elgg / Städtchen und Umgebung', 1, 'elgg-stadtchen-und-umgebung', 47.49265000, 8.86680000),
(1017741, 1001656, 'CH', 'Elsau-Räterschen', 1, 'elsau-raterschen', 47.50238000, 8.79874000),
(1017742, 1001656, 'CH', 'Elsau-Räterschen / Räterschen', 1, 'elsau-raterschen-raterschen', 47.49927000, 8.79600000),
(1017743, 1001656, 'CH', 'Embrach', 1, 'embrach', 47.50561000, 8.59406000),
(1017744, 1001656, 'CH', 'Embrach / Embrach (Dorfkern)', 1, 'embrach-embrach-dorfkern', 47.50400000, 8.59477000),
(1017745, 1001656, 'CH', 'Embrach / Kellersacker', 1, 'embrach-kellersacker', 47.51455000, 8.59146000),
(1017761, 1001656, 'CH', 'Erlenbach', 1, 'erlenbach', 47.30298000, 8.59743000),
(1017762, 1001656, 'CH', 'Erlenbach / links des Dorfbachs oberhalb Bahnlinie', 1, 'erlenbach-links-des-dorfbachs-oberhalb-bahnlinie', 47.29950000, 8.60188000),
(1017763, 1001656, 'CH', 'Erlenbach / rechts des Dorfbachs oberhalb Bahnlinie', 1, 'erlenbach-rechts-des-dorfbachs-oberhalb-bahnlinie', 47.30658000, 8.60271000),
(1017773, 1001656, 'CH', 'Esslingen', 1, 'esslingen', 47.28325000, 8.71038000),
(1017816, 1001656, 'CH', 'Fällanden', 1, 'fallanden', 47.37169000, 8.63869000),
(1017781, 1001656, 'CH', 'Fehraltorf', 1, 'fehraltorf', 47.38775000, 8.75149000),
(1017782, 1001656, 'CH', 'Feldmeilen', 1, 'feldmeilen', 47.27873000, 8.62165000),
(1017786, 1001656, 'CH', 'Feuerthalen', 1, 'feuerthalen', 47.69054000, 8.64357000),
(1017795, 1001656, 'CH', 'Flurlingen', 1, 'flurlingen', 47.68390000, 8.62995000),
(1017807, 1001656, 'CH', 'Freienstein', 1, 'freienstein', 47.53307000, 8.58455000),
(1017823, 1001656, 'CH', 'Gattikon', 1, 'gattikon', 47.28439000, 8.54830000),
(1017829, 1001656, 'CH', 'Geroldswil', 1, 'geroldswil', 47.42213000, 8.41085000),
(1017840, 1001656, 'CH', 'Glattbrugg', 1, 'glattbrugg', 47.43130000, 8.56272000),
(1017841, 1001656, 'CH', 'Glattbrugg / Rohr/Platten-Balsberg', 1, 'glattbrugg-rohr-platten-balsberg', 47.43721000, 8.56642000),
(1017842, 1001656, 'CH', 'Glattbrugg / Wydacker/Bettacker/Lättenwiesen', 1, 'glattbrugg-wydacker-bettacker-lattenwiesen', 47.42908000, 8.56657000),
(1017843, 1001656, 'CH', 'Glattfelden', 1, 'glattfelden', 47.55871000, 8.50167000),
(1017846, 1001656, 'CH', 'Gockhausen', 1, 'gockhausen', 47.38098000, 8.59978000),
(1017857, 1001656, 'CH', 'Gossau', 1, 'gossau', 47.30510000, 8.75831000),
(1017864, 1001656, 'CH', 'Greifensee', 1, 'greifensee', 47.36717000, 8.68115000),
(1017865, 1001656, 'CH', 'Greifensee / Müllerwis / Seilerwis', 1, 'greifensee-mullerwis-seilerwis', 47.37042000, 8.68151000),
(1017866, 1001656, 'CH', 'Greifensee / Pfisterhölzli', 1, 'greifensee-pfisterholzli', 47.36430000, 8.68979000),
(1017873, 1001656, 'CH', 'Grossacker/Opfikon', 1, 'grossacker-opfikon', 47.42696000, 8.57886000),
(1017883, 1001656, 'CH', 'Grüt', 1, 'grut', 47.31151000, 8.78339000),
(1017888, 1001656, 'CH', 'Gutenswil', 1, 'gutenswil', 47.38387000, 8.71763000),
(1017891, 1001656, 'CH', 'Hadlikon', 1, 'hadlikon', 47.28750000, 8.85719000),
(1017896, 1001656, 'CH', 'Hausen am Albis / Hausen (Dorf)', 1, 'hausen-am-albis-hausen-dorf', 47.24496000, 8.53299000),
(1017897, 1001656, 'CH', 'Hedingen', 1, 'hedingen', 47.29794000, 8.44833000),
(1017898, 1001656, 'CH', 'Hegnau', 1, 'hegnau', 47.39227000, 8.66988000),
(1017899, 1001656, 'CH', 'Hegnau / Dammboden-Grindel', 1, 'hegnau-dammboden-grindel', 47.38713000, 8.66657000),
(1017900, 1001656, 'CH', 'Hegnau / Sunnebüel-Eich', 1, 'hegnau-sunnebuel-eich', 47.39246000, 8.67910000),
(1017905, 1001656, 'CH', 'Henggart', 1, 'henggart', 47.56272000, 8.68215000),
(1017909, 1001656, 'CH', 'Herrliberg', 1, 'herrliberg', 47.29064000, 8.61464000),
(1017911, 1001656, 'CH', 'Hettlingen', 1, 'hettlingen', 47.54610000, 8.70532000),
(1017916, 1001656, 'CH', 'Hinteregg', 1, 'hinteregg', 47.30736000, 8.68339000),
(1017918, 1001656, 'CH', 'Hinwil', 1, 'hinwil', 47.29426000, 8.84393000),
(1017919, 1001656, 'CH', 'Hittnau / Hittnau (Dorf)', 1, 'hittnau-hittnau-dorf', 47.36334000, 8.82418000),
(1017923, 1001656, 'CH', 'Hochfelden', 1, 'hochfelden', 47.52262000, 8.51564000),
(1017925, 1001656, 'CH', 'Hofstetten', 1, 'hofstetten', 47.47778000, 8.50646000),
(1017927, 1001656, 'CH', 'Hombrechtikon', 1, 'hombrechtikon', 47.25298000, 8.77212000),
(1017929, 1001656, 'CH', 'Horgen', 1, 'horgen', 47.25983000, 8.59778000),
(1017930, 1001656, 'CH', 'Horgen / Allmend', 1, 'horgen-allmend', 47.24729000, 8.60660000),
(1017931, 1001656, 'CH', 'Horgen / Horgen (Dorfkern)', 1, 'horgen-horgen-dorfkern', 47.25604000, 8.60159000),
(1017932, 1001656, 'CH', 'Horgen / Oberdorf', 1, 'horgen-oberdorf', 47.25837000, 8.59013000),
(1017933, 1001656, 'CH', 'Horgen / Scheller-Stockerstrasse', 1, 'horgen-scheller-stockerstrasse', 47.26584000, 8.58760000),
(1017943, 1001656, 'CH', 'Höri', 1, 'hori', 47.50799000, 8.51203000),
(1017949, 1001656, 'CH', 'Illnau', 1, 'illnau', 47.41130000, 8.72125000),
(1017950, 1001656, 'CH', 'Illnau / Unter-Illnau', 1, 'illnau-unter-illnau', 47.40787000, 8.72607000),
(1017975, 1001656, 'CH', 'Kilchberg', 1, 'kilchberg', 47.32438000, 8.54548000),
(1017976, 1001656, 'CH', 'Kilchberg / Bächler-Stocken', 1, 'kilchberg-bachler-stocken', 47.32728000, 8.53957000),
(1017977, 1001656, 'CH', 'Kilchberg / Kilchberg (Dorfkern)', 1, 'kilchberg-kilchberg-dorfkern', 47.32012000, 8.54306000),
(1017979, 1001656, 'CH', 'Kindhausen / Kindhausen (Dorf)', 1, 'kindhausen-kindhausen-dorf', 47.40644000, 8.68296000),
(1017983, 1001656, 'CH', 'Kleinandelfingen', 1, 'kleinandelfingen', 47.60058000, 8.68362000),
(1017987, 1001656, 'CH', 'Kloten', 1, 'kloten', 47.45152000, 8.58491000),
(1017988, 1001656, 'CH', 'Kloten / Balsberg', 1, 'kloten-balsberg', 47.44233000, 8.57496000),
(1017989, 1001656, 'CH', 'Kloten / Freienberg (Chanzler-Chlini Chaseren)', 1, 'kloten-freienberg-chanzler-chlini-chaseren', 47.46584000, 8.58145000),
(1017990, 1001656, 'CH', 'Kloten / Geissberg', 1, 'kloten-geissberg', 47.45424000, 8.59066000),
(1017991, 1001656, 'CH', 'Kloten / Holberg', 1, 'kloten-holberg', 47.44642000, 8.57661000),
(1017992, 1001656, 'CH', 'Kloten / Horainli', 1, 'kloten-horainli', 47.45399000, 8.58306000),
(1017993, 1001656, 'CH', 'Kloten / Hostrass', 1, 'kloten-hostrass', 47.45255000, 8.59464000),
(1017994, 1001656, 'CH', 'Kloten / Kloten (Zentrum)', 1, 'kloten-kloten-zentrum', 47.45134000, 8.58683000),
(1017995, 1001656, 'CH', 'Kloten / Rütlen', 1, 'kloten-rutlen', 47.44726000, 8.58808000),
(1017996, 1001656, 'CH', 'Kloten / Spitz', 1, 'kloten-spitz', 47.44455000, 8.58724000),
(1017997, 1001656, 'CH', 'Knonau', 1, 'knonau', 47.22350000, 8.46197000),
(1018000, 1001656, 'CH', 'Kollbrunn', 1, 'kollbrunn', 47.45793000, 8.78295000),
(1018001, 1001656, 'CH', 'Kollbrunn / Kollbrunn (Dorfkern)', 1, 'kollbrunn-kollbrunn-dorfkern', 47.45748000, 8.77413000),
(1018013, 1001656, 'CH', 'Küsnacht', 1, 'kusnacht', 47.31805000, 8.58401000),
(1018014, 1001656, 'CH', 'Küsnacht / Dorf', 1, 'kusnacht-dorf', 47.31783000, 8.58303000),
(1018015, 1001656, 'CH', 'Küsnacht / Goldbach', 1, 'kusnacht-goldbach', 47.32729000, 8.58077000),
(1018016, 1001656, 'CH', 'Küsnacht / Heslibach', 1, 'kusnacht-heslibach', 47.31307000, 8.58849000),
(1018017, 1001656, 'CH', 'Küsnacht / Itschnach', 1, 'kusnacht-itschnach', 47.32714000, 8.60068000),
(1018018, 1001656, 'CH', 'Küsnacht / Schiedhalden', 1, 'kusnacht-schiedhalden', 47.32112000, 8.58881000),
(1018038, 1001656, 'CH', 'Langnau / Langnau (Dorf)', 1, 'langnau-langnau-dorf', 47.28643000, 8.53627000),
(1018039, 1001656, 'CH', 'Langnau / Vitaquartier', 1, 'langnau-vitaquartier', 47.29377000, 8.53758000),
(1018040, 1001656, 'CH', 'Langnau am Albis', 1, 'langnau-am-albis', 47.28885000, 8.54110000),
(1018186, 1001656, 'CH', 'Männedorf', 1, 'mannedorf', 47.25686000, 8.69893000),
(1018187, 1001656, 'CH', 'Männedorf / Ausserfeld', 1, 'mannedorf-ausserfeld', 47.24636000, 8.70608000),
(1018188, 1001656, 'CH', 'Männedorf / Dorfkern', 1, 'mannedorf-dorfkern', 47.25612000, 8.69161000),
(1018124, 1001656, 'CH', 'Marthalen', 1, 'marthalen', 47.62913000, 8.65326000),
(1018130, 1001656, 'CH', 'Mattenbach (Kreis 7)', 1, 'mattenbach-kreis-7', 47.48705000, 8.74681000),
(1018131, 1001656, 'CH', 'Mattenbach (Kreis 7) / Deutweg', 1, 'mattenbach-kreis-7-deutweg', 47.49419000, 8.73948000),
(1018132, 1001656, 'CH', 'Mattenbach (Kreis 7) / Endliker', 1, 'mattenbach-kreis-7-endliker', 47.48821000, 8.74938000),
(1018133, 1001656, 'CH', 'Mattenbach (Kreis 7) / Gutschick', 1, 'mattenbach-kreis-7-gutschick', 47.49104000, 8.75258000),
(1018140, 1001656, 'CH', 'Meilen', 1, 'meilen', 47.27232000, 8.64617000),
(1018157, 1001656, 'CH', 'Mettmenstetten', 1, 'mettmenstetten', 47.24529000, 8.46347000),
(1018192, 1001656, 'CH', 'Mönchaltorf', 1, 'monchaltorf', 47.30958000, 8.72029000),
(1018193, 1001656, 'CH', 'Mönchaltorf / Dorf', 1, 'monchaltorf-dorf', 47.30401000, 8.72211000),
(1018196, 1001656, 'CH', 'Mühlehalde', 1, 'muhlehalde', 47.28306000, 8.53386000),
(1018236, 1001656, 'CH', 'Nänikon', 1, 'nanikon', 47.36975000, 8.68894000),
(1018237, 1001656, 'CH', 'Nänikon / Nänikon (Dorfkern)', 1, 'nanikon-nanikon-dorfkern', 47.37099000, 8.69254000),
(1018209, 1001656, 'CH', 'Neerach', 1, 'neerach', 47.51096000, 8.47099000),
(1018210, 1001656, 'CH', 'Neftenbach / Dorf Neftenbach', 1, 'neftenbach-dorf-neftenbach', 47.52764000, 8.66490000),
(1018222, 1001656, 'CH', 'Niederglatt', 1, 'niederglatt', 47.49066000, 8.49987000),
(1018223, 1001656, 'CH', 'Niederglatt / Niederglatt (Dorfkern)', 1, 'niederglatt-niederglatt-dorfkern', 47.49065000, 8.50048000),
(1018225, 1001656, 'CH', 'Niederhasli', 1, 'niederhasli', 47.48012000, 8.48576000),
(1018238, 1001656, 'CH', 'Nürensdorf', 1, 'nurensdorf', 47.44814000, 8.64908000),
(1018246, 1001656, 'CH', 'Oberengstringen', 1, 'oberengstringen', 47.40841000, 8.46515000),
(1018247, 1001656, 'CH', 'Oberengstringen / Rauchacher', 1, 'oberengstringen-rauchacher', 47.40919000, 8.45627000),
(1018248, 1001656, 'CH', 'Oberengstringen / Sonnenberg', 1, 'oberengstringen-sonnenberg', 47.41211000, 8.46055000),
(1018249, 1001656, 'CH', 'Oberengstringen / Zentrum', 1, 'oberengstringen-zentrum', 47.40711000, 8.46276000),
(1018251, 1001656, 'CH', 'Oberglatt', 1, 'oberglatt', 47.47576000, 8.51896000),
(1018252, 1001656, 'CH', 'Oberglatt / Bahnhofquartier', 1, 'oberglatt-bahnhofquartier', 47.47143000, 8.51289000),
(1018253, 1001656, 'CH', 'Oberglatt / Oberglatt (Dorfkern)', 1, 'oberglatt-oberglatt-dorfkern', 47.47596000, 8.51929000),
(1018258, 1001656, 'CH', 'Obermeilen', 1, 'obermeilen', 47.26574000, 8.65567000),
(1018259, 1001656, 'CH', 'Oberrieden', 1, 'oberrieden', 47.27444000, 8.57838000),
(1018260, 1001656, 'CH', 'Oberrieden / Berg', 1, 'oberrieden-berg', 47.27628000, 8.57257000),
(1018261, 1001656, 'CH', 'Oberrieden / Mitte', 1, 'oberrieden-mitte', 47.27242000, 8.58021000),
(1018271, 1001656, 'CH', 'Oberwinterthur (Kreis 2)', 1, 'oberwinterthur-kreis-2', 47.51692000, 8.76863000),
(1018272, 1001656, 'CH', 'Oberwinterthur (Kreis 2) / Guggenbühl', 1, 'oberwinterthur-kreis-2-guggenbuhl', 47.51339000, 8.75998000),
(1018273, 1001656, 'CH', 'Oberwinterthur (Kreis 2) / Hegi', 1, 'oberwinterthur-kreis-2-hegi', 47.50716000, 8.77057000),
(1018274, 1001656, 'CH', 'Oberwinterthur (Kreis 2) / Talacker', 1, 'oberwinterthur-kreis-2-talacker', 47.50596000, 8.75150000),
(1018275, 1001656, 'CH', 'Oberwinterthur (Kreis 2) / Zinzikon', 1, 'oberwinterthur-kreis-2-zinzikon', 47.51950000, 8.75640000),
(1018276, 1001656, 'CH', 'Obfelden', 1, 'obfelden', 47.26413000, 8.42150000),
(1018277, 1001656, 'CH', 'Obfelden / Oberlunnern', 1, 'obfelden-oberlunnern', 47.26197000, 8.41588000),
(1018278, 1001656, 'CH', 'Obfelden / Toussen', 1, 'obfelden-toussen', 47.26574000, 8.43013000),
(1018280, 1001656, 'CH', 'Oetwil', 1, 'oetwil', 47.27049000, 8.72023000),
(1018285, 1001656, 'CH', 'Opfikon', 1, 'opfikon', 47.43169000, 8.57588000),
(1018292, 1001656, 'CH', 'Otelfingen', 1, 'otelfingen', 47.46053000, 8.39141000),
(1018294, 1001656, 'CH', 'Ottenbach', 1, 'ottenbach', 47.28228000, 8.40432000),
(1018305, 1001656, 'CH', 'Pfaffhausen', 1, 'pfaffhausen', 47.36476000, 8.62375000),
(1018311, 1001656, 'CH', 'Pfäffikon', 1, 'pfaffikon', 47.36453000, 8.79202000),
(1018312, 1001656, 'CH', 'Pfäffikon / Irgenhausen', 1, 'pfaffikon-irgenhausen', 47.36240000, 8.79265000),
(1018313, 1001656, 'CH', 'Pfäffikon / Pfäffikon (Dorfkern)', 1, 'pfaffikon-pfaffikon-dorfkern', 47.36943000, 8.78309000),
(1018308, 1001656, 'CH', 'Pfungen', 1, 'pfungen', 47.51394000, 8.64230000),
(1018335, 1001656, 'CH', 'Rafz', 1, 'rafz', 47.60438000, 8.54305000),
(1018344, 1001656, 'CH', 'Regensdorf', 1, 'regensdorf', 47.43410000, 8.46874000),
(1018345, 1001656, 'CH', 'Regensdorf / Feldblumen-Riedthofstrasse', 1, 'regensdorf-feldblumen-riedthofstrasse', 47.43618000, 8.46659000),
(1018346, 1001656, 'CH', 'Regensdorf / Hofacher-Geeren', 1, 'regensdorf-hofacher-geeren', 47.43525000, 8.46240000),
(1018347, 1001656, 'CH', 'Regensdorf / Obstgarten', 1, 'regensdorf-obstgarten', 47.42772000, 8.46566000),
(1018369, 1001656, 'CH', 'Richterswil', 1, 'richterswil', 47.20622000, 8.69686000),
(1018370, 1001656, 'CH', 'Richterswil / Burghalde', 1, 'richterswil-burghalde', 47.20973000, 8.69133000),
(1018371, 1001656, 'CH', 'Richterswil / Dorfkern', 1, 'richterswil-dorfkern', 47.20715000, 8.70607000),
(1018372, 1001656, 'CH', 'Richterswil / Richterswil (Dorfkern)', 1, 'richterswil-richterswil-dorfkern', 47.20323000, 8.70516000),
(1018391, 1001656, 'CH', 'Rorbas', 1, 'rorbas', 47.53092000, 8.57555000),
(1018406, 1001656, 'CH', 'Rümlang', 1, 'rumlang', 47.45041000, 8.52993000),
(1018407, 1001656, 'CH', 'Rümlang / Rümlang (Dorfkern)', 1, 'rumlang-rumlang-dorfkern', 47.44940000, 8.53255000),
(1018409, 1001656, 'CH', 'Rüschlikon', 1, 'ruschlikon', 47.30688000, 8.55135000),
(1018400, 1001656, 'CH', 'Russikon', 1, 'russikon', 47.39669000, 8.77515000),
(1018411, 1001656, 'CH', 'Rüti', 1, 'ruti', 47.25603000, 8.85552000),
(1018412, 1001656, 'CH', 'Rüti / Dorfzentrum, Südl. Teil', 1, 'ruti-dorfzentrum-sudl-teil', 47.25368000, 8.85654000),
(1018413, 1001656, 'CH', 'Rüti / Oberdorf', 1, 'ruti-oberdorf', 47.25894000, 8.86512000),
(1018414, 1001656, 'CH', 'Rüti / Westlicher Dorfteil', 1, 'ruti-westlicher-dorfteil', 47.25548000, 8.84490000),
(1018436, 1001656, 'CH', 'Samstagern', 1, 'samstagern', 47.19167000, 8.68196000),
(1018454, 1001656, 'CH', 'Schachen', 1, 'schachen', 47.32419000, 8.47251000),
(1018465, 1001656, 'CH', 'Schlieren', 1, 'schlieren', 47.39668000, 8.44763000),
(1018466, 1001656, 'CH', 'Schlieren / Boden', 1, 'schlieren-boden', 47.39721000, 8.45734000),
(1018467, 1001656, 'CH', 'Schlieren / Engstingerquartier', 1, 'schlieren-engstingerquartier', 47.40338000, 8.44352000),
(1018468, 1001656, 'CH', 'Schlieren / Freiestrasse', 1, 'schlieren-freiestrasse', 47.39598000, 8.44202000),
(1018469, 1001656, 'CH', 'Schlieren / Kamp', 1, 'schlieren-kamp', 47.39358000, 8.44453000),
(1018470, 1001656, 'CH', 'Schlieren / Spital', 1, 'schlieren-spital', 47.39489000, 8.43027000),
(1018471, 1001656, 'CH', 'Schlieren / Zentrum', 1, 'schlieren-zentrum', 47.39779000, 8.44770000),
(1018478, 1001656, 'CH', 'Schwerzenbach', 1, 'schwerzenbach', 47.38213000, 8.65727000),
(1018479, 1001656, 'CH', 'Schwerzenbach / Blatten', 1, 'schwerzenbach-blatten', 47.38308000, 8.64954000),
(1018480, 1001656, 'CH', 'Schwerzenbach / Chimli', 1, 'schwerzenbach-chimli', 47.38592000, 8.65888000),
(1018495, 1001656, 'CH', 'Seen (Kreis 3)', 1, 'seen-kreis-3', 47.47646000, 8.76996000),
(1018496, 1001656, 'CH', 'Seen (Kreis 3) / Büelwiesen', 1, 'seen-kreis-3-buelwiesen', 47.48446000, 8.76517000),
(1018497, 1001656, 'CH', 'Seen (Kreis 3) / Ganzenbühl', 1, 'seen-kreis-3-ganzenbuhl', 47.48100000, 8.76249000),
(1018498, 1001656, 'CH', 'Seen (Kreis 3) / Oberseen', 1, 'seen-kreis-3-oberseen', 47.48205000, 8.77289000),
(1018499, 1001656, 'CH', 'Seen (Kreis 3) / Waldegg', 1, 'seen-kreis-3-waldegg', 47.48393000, 8.75586000),
(1018500, 1001656, 'CH', 'Seen (Kreis 3) / Waser', 1, 'seen-kreis-3-waser', 47.48913000, 8.76034000),
(1018503, 1001656, 'CH', 'Seglingen', 1, 'seglingen', 47.57244000, 8.52093000),
(1018504, 1001656, 'CH', 'Sellenbüren', 1, 'sellenburen', 47.34361000, 8.48301000),
(1018512, 1001656, 'CH', 'Seuzach / Seuzach (Dorf)', 1, 'seuzach-seuzach-dorf', 47.53545000, 8.73728000),
(1018513, 1001656, 'CH', 'Seuzach Dorf', 1, 'seuzach-dorf', 47.53560000, 8.73209000),
(1018514, 1001656, 'CH', 'Seuzach Dorf / Breite-Weid', 1, 'seuzach-dorf-breite-weid', 47.53345000, 8.73415000),
(1018529, 1001656, 'CH', 'Sonnhalde', 1, 'sonnhalde', 47.45329000, 8.46091000),
(1018537, 1001656, 'CH', 'Stadt Winterthur (Kreis 1)', 1, 'stadt-winterthur-kreis-1', 47.49494000, 8.71954000),
(1018538, 1001656, 'CH', 'Stadt Winterthur (Kreis 1) / Altstadt', 1, 'stadt-winterthur-kreis-1-altstadt', 47.49951000, 8.72872000),
(1018539, 1001656, 'CH', 'Stadt Winterthur (Kreis 1) / Brühlberg', 1, 'stadt-winterthur-kreis-1-bruhlberg', 47.49764000, 8.71272000),
(1018540, 1001656, 'CH', 'Stadt Winterthur (Kreis 1) / Heiligberg', 1, 'stadt-winterthur-kreis-1-heiligberg', 47.49409000, 8.72334000),
(1018541, 1001656, 'CH', 'Stadt Winterthur (Kreis 1) / Lind', 1, 'stadt-winterthur-kreis-1-lind', 47.50571000, 8.73372000),
(1018542, 1001656, 'CH', 'Stadt Winterthur (Kreis 1) / Neuwiesen', 1, 'stadt-winterthur-kreis-1-neuwiesen', 47.50207000, 8.71625000),
(1018543, 1001656, 'CH', 'Stadt Winterthur (Kreis 1) / Tössfeld', 1, 'stadt-winterthur-kreis-1-tossfeld', 47.49340000, 8.71512000),
(1018560, 1001656, 'CH', 'Stäfa', 1, 'stafa', 47.24254000, 8.72342000),
(1018555, 1001656, 'CH', 'Steinmaur', 1, 'steinmaur', 47.49710000, 8.45216000),
(1018565, 1001656, 'CH', 'Sulz', 1, 'sulz', 47.53954000, 8.78887000),
(1018571, 1001656, 'CH', 'Tagelswangen', 1, 'tagelswangen', 47.43070000, 8.67284000),
(1018574, 1001656, 'CH', 'Tann', 1, 'tann', 47.26898000, 8.85024000),
(1018575, 1001656, 'CH', 'Tann / Tann (Dorfkern)', 1, 'tann-tann-dorfkern', 47.26494000, 8.85048000),
(1018582, 1001656, 'CH', 'Thalwil', 1, 'thalwil', 47.29175000, 8.56351000),
(1018583, 1001656, 'CH', 'Thalwil / Berg', 1, 'thalwil-berg', 47.29178000, 8.55602000),
(1018584, 1001656, 'CH', 'Thalwil / Dorfkern', 1, 'thalwil-dorfkern', 47.29047000, 8.56633000),
(1018585, 1001656, 'CH', 'Thalwil / Nord', 1, 'thalwil-nord', 47.29748000, 8.55634000),
(1018586, 1001656, 'CH', 'Thalwil / See', 1, 'thalwil-see', 47.29409000, 8.56929000),
(1018587, 1001656, 'CH', 'Thalwil / Süd', 1, 'thalwil-sud', 47.28495000, 8.56954000),
(1018618, 1001656, 'CH', 'Töss (Kreis 4)', 1, 'toss-kreis-4', 47.47890000, 8.70215000),
(1018619, 1001656, 'CH', 'Töss (Kreis 4) / Eichliacker', 1, 'toss-kreis-4-eichliacker', 47.48727000, 8.70740000),
(1018620, 1001656, 'CH', 'Töss (Kreis 4) / Schlosstal', 1, 'toss-kreis-4-schlosstal', 47.49279000, 8.70223000),
(1018621, 1001656, 'CH', 'Töss (Kreis 4) / Vorder-Dättnau', 1, 'toss-kreis-4-vorder-dattnau', 47.48135000, 8.69855000),
(1018613, 1001656, 'CH', 'Turbenthal', 1, 'turbenthal', 47.43633000, 8.84629000),
(1018624, 1001656, 'CH', 'Uerikon', 1, 'uerikon', 47.23672000, 8.75730000),
(1018627, 1001656, 'CH', 'Uetikon', 1, 'uetikon', 47.26441000, 8.67925000),
(1018628, 1001656, 'CH', 'Uetikon / Grossdorf', 1, 'uetikon-grossdorf', 47.26654000, 8.67765000),
(1018629, 1001656, 'CH', 'Uhwiesen', 1, 'uhwiesen', 47.67074000, 8.63542000),
(1018630, 1001656, 'CH', 'Uitikon', 1, 'uitikon', 47.36911000, 8.45699000),
(1018631, 1001656, 'CH', 'Unterengstringen', 1, 'unterengstringen', 47.41396000, 8.44761000),
(1018639, 1001656, 'CH', 'Urdorf', 1, 'urdorf', 47.38507000, 8.42581000),
(1018640, 1001656, 'CH', 'Urdorf / Bodenfeld', 1, 'urdorf-bodenfeld', 47.38920000, 8.42265000),
(1018641, 1001656, 'CH', 'Urdorf / Moos', 1, 'urdorf-moos', 47.38977000, 8.42886000),
(1018642, 1001656, 'CH', 'Urdorf / Oberurdorf', 1, 'urdorf-oberurdorf', 47.38072000, 8.42343000),
(1018645, 1001656, 'CH', 'Uster', 1, 'uster', 47.34713000, 8.72091000),
(1018646, 1001656, 'CH', 'Uster / Gschwader', 1, 'uster-gschwader', 47.36016000, 8.71390000),
(1018647, 1001656, 'CH', 'Uster / Kirch-Uster', 1, 'uster-kirch-uster', 47.34579000, 8.71839000),
(1018648, 1001656, 'CH', 'Uster / Nieder-Uster', 1, 'uster-nieder-uster', 47.34743000, 8.70088000),
(1018649, 1001656, 'CH', 'Uster / Nossikon', 1, 'uster-nossikon', 47.34088000, 8.72555000),
(1018650, 1001656, 'CH', 'Uster / Ober-Uster', 1, 'uster-ober-uster', 47.34874000, 8.73319000),
(1018665, 1001656, 'CH', 'Veltheim (Kreis 5)', 1, 'veltheim-kreis-5', 47.51419000, 8.71700000),
(1018666, 1001656, 'CH', 'Veltheim (Kreis 5) / Blumenau', 1, 'veltheim-kreis-5-blumenau', 47.50618000, 8.71563000),
(1018667, 1001656, 'CH', 'Veltheim (Kreis 5) / Rosenberg', 1, 'veltheim-kreis-5-rosenberg', 47.51386000, 8.71583000),
(1018691, 1001656, 'CH', 'Volketswil / Volketswil (Dorf)', 1, 'volketswil-volketswil-dorf', 47.39016000, 8.69085000),
(1018773, 1001656, 'CH', 'Wädenswil', 1, 'wadenswil', 47.22683000, 8.66870000),
(1018774, 1001656, 'CH', 'Wädenswil / Boller-Giessen', 1, 'wadenswil-boller-giessen', 47.22115000, 8.68385000),
(1018775, 1001656, 'CH', 'Wädenswil / Büelen', 1, 'wadenswil-buelen', 47.23395000, 8.66346000),
(1018776, 1001656, 'CH', 'Wädenswil / Dorf (Wädenswil)', 1, 'wadenswil-dorf-wadenswil', 47.22923000, 8.67220000),
(1018777, 1001656, 'CH', 'Wädenswil / Eichweid', 1, 'wadenswil-eichweid', 47.21847000, 8.67440000),
(1018778, 1001656, 'CH', 'Wädenswil / Hangenmoos', 1, 'wadenswil-hangenmoos', 47.23367000, 8.65251000),
(1018779, 1001656, 'CH', 'Wädenswil / Leihof-Mühlebach', 1, 'wadenswil-leihof-muhlebach', 47.22364000, 8.67149000),
(1018780, 1001656, 'CH', 'Wädenswil / Untermosen-Fuhr', 1, 'wadenswil-untermosen-fuhr', 47.22772000, 8.66303000),
(1018709, 1001656, 'CH', 'Wald', 1, 'wald', 47.27595000, 8.91405000),
(1018715, 1001656, 'CH', 'Wallisellen', 1, 'wallisellen', 47.41499000, 8.59672000),
(1018716, 1001656, 'CH', 'Wallisellen / Rieden', 1, 'wallisellen-rieden', 47.41738000, 8.60028000),
(1018717, 1001656, 'CH', 'Wallisellen / Wallisellen-Ost', 1, 'wallisellen-wallisellen-ost', 47.41446000, 8.59727000),
(1018718, 1001656, 'CH', 'Wallisellen / Wallisellen-West', 1, 'wallisellen-wallisellen-west', 47.41906000, 8.58586000),
(1018722, 1001656, 'CH', 'Wangen', 1, 'wangen', 47.41182000, 8.64516000),
(1018732, 1001656, 'CH', 'Weiningen', 1, 'weiningen', 47.42022000, 8.43644000),
(1018733, 1001656, 'CH', 'Weisslingen', 1, 'weisslingen', 47.43063000, 8.76787000),
(1018737, 1001656, 'CH', 'Wettswil / Ausser-Dorf', 1, 'wettswil-ausser-dorf', 47.33197000, 8.47732000),
(1018738, 1001656, 'CH', 'Wettswil / Wettswil (Dorf)', 1, 'wettswil-wettswil-dorf', 47.34152000, 8.47149000),
(1018739, 1001656, 'CH', 'Wetzikon', 1, 'wetzikon', 47.32640000, 8.79779000),
(1018740, 1001656, 'CH', 'Wetzikon / Kempten', 1, 'wetzikon-kempten', 47.33319000, 8.80982000),
(1018741, 1001656, 'CH', 'Wetzikon / Ober-Wetzikon', 1, 'wetzikon-ober-wetzikon', 47.32514000, 8.80005000),
(1018742, 1001656, 'CH', 'Wetzikon / Robenhausen', 1, 'wetzikon-robenhausen', 47.33089000, 8.78762000),
(1018743, 1001656, 'CH', 'Wetzikon / Unter-Wetzikon', 1, 'wetzikon-unter-wetzikon', 47.31637000, 8.79369000),
(1018746, 1001656, 'CH', 'Wiesendangen / Wiesendangen (Dorf)', 1, 'wiesendangen-wiesendangen-dorf', 47.52170000, 8.78967000),
(1018750, 1001656, 'CH', 'Wila', 1, 'wila', 47.41928000, 8.84524000),
(1018758, 1001656, 'CH', 'Winterthur', 1, 'winterthur', 47.50564000, 8.72413000),
(1018764, 1001656, 'CH', 'Wolfhausen', 1, 'wolfhausen', 47.25619000, 8.79910000),
(1018783, 1001656, 'CH', 'Wülflingen (Kreis 6)', 1, 'wulflingen-kreis-6', 47.51036000, 8.68333000),
(1018784, 1001656, 'CH', 'Wülflingen (Kreis 6) / Härti', 1, 'wulflingen-kreis-6-harti', 47.51262000, 8.68400000),
(1018785, 1001656, 'CH', 'Wülflingen (Kreis 6) / Lindenplatz', 1, 'wulflingen-kreis-6-lindenplatz', 47.51098000, 8.69290000),
(1018786, 1001656, 'CH', 'Wülflingen (Kreis 6) / Niederfeld', 1, 'wulflingen-kreis-6-niederfeld', 47.50904000, 8.67968000),
(1018787, 1001656, 'CH', 'Wülflingen (Kreis 6) / Oberfeld', 1, 'wulflingen-kreis-6-oberfeld', 47.49873000, 8.69897000),
(1018797, 1001656, 'CH', 'Zollikerberg', 1, 'zollikerberg', 47.34510000, 8.60088000),
(1018799, 1001656, 'CH', 'Zollikon', 1, 'zollikon', 47.34019000, 8.57407000),
(1018802, 1001656, 'CH', 'Zumikon', 1, 'zumikon', 47.33158000, 8.62271000),
(1018809, 1001656, 'CH', 'Zürich', 1, 'zurich', 47.36667000, 8.55000000),
(1018810, 1001656, 'CH', 'Zürich (Kreis 1)', 1, 'zurich-kreis-1', 47.37055000, 8.54177000),
(1018811, 1001656, 'CH', 'Zürich (Kreis 1) / City', 1, 'zurich-kreis-1-city', 47.37269000, 8.53576000),
(1018812, 1001656, 'CH', 'Zürich (Kreis 1) / Lindenhof', 1, 'zurich-kreis-1-lindenhof', 47.37188000, 8.54036000),
(1018813, 1001656, 'CH', 'Zürich (Kreis 1) / Rathaus', 1, 'zurich-kreis-1-rathaus', 47.37161000, 8.54501000),
(1018814, 1001656, 'CH', 'Zürich (Kreis 10)', 1, 'zurich-kreis-10', 47.40773000, 8.50050000),
(1018815, 1001656, 'CH', 'Zürich (Kreis 10) / Höngg', 1, 'zurich-kreis-10-hongg', 47.40313000, 8.49710000),
(1018816, 1001656, 'CH', 'Zürich (Kreis 10) / Rütihof', 1, 'zurich-kreis-10-rutihof', 47.41444000, 8.47928000),
(1018817, 1001656, 'CH', 'Zürich (Kreis 10) / Wipkingen', 1, 'zurich-kreis-10-wipkingen', 47.39503000, 8.52529000),
(1018818, 1001656, 'CH', 'Zürich (Kreis 11)', 1, 'zurich-kreis-11', 47.42326000, 8.52166000),
(1018819, 1001656, 'CH', 'Zürich (Kreis 11) / Affoltern', 1, 'zurich-kreis-11-affoltern', 47.41814000, 8.51220000),
(1018820, 1001656, 'CH', 'Zürich (Kreis 11) / Oerlikon', 1, 'zurich-kreis-11-oerlikon', 47.40823000, 8.54258000),
(1018821, 1001656, 'CH', 'Zürich (Kreis 11) / Schwandenholz', 1, 'zurich-kreis-11-schwandenholz', 47.42476000, 8.52125000),
(1018822, 1001656, 'CH', 'Zürich (Kreis 11) / Seebach', 1, 'zurich-kreis-11-seebach', 47.42181000, 8.54779000),
(1018823, 1001656, 'CH', 'Zürich (Kreis 12)', 1, 'zurich-kreis-12', 47.40372000, 8.57608000),
(1018824, 1001656, 'CH', 'Zürich (Kreis 12) / Auzelg', 1, 'zurich-kreis-12-auzelg', 47.41511000, 8.57014000),
(1018825, 1001656, 'CH', 'Zürich (Kreis 12) / Hirzenbach', 1, 'zurich-kreis-12-hirzenbach', 47.40187000, 8.58633000),
(1018826, 1001656, 'CH', 'Zürich (Kreis 12) / Saatlen', 1, 'zurich-kreis-12-saatlen', 47.41127000, 8.56480000),
(1018827, 1001656, 'CH', 'Zürich (Kreis 12) / Schwamendingen-Mitte', 1, 'zurich-kreis-12-schwamendingen-mitte', 47.40630000, 8.57242000),
(1018828, 1001656, 'CH', 'Zürich (Kreis 2)', 1, 'zurich-kreis-2', 47.33756000, 8.52110000),
(1018829, 1001656, 'CH', 'Zürich (Kreis 2) / Enge', 1, 'zurich-kreis-2-enge', 47.36050000, 8.53127000),
(1018830, 1001656, 'CH', 'Zürich (Kreis 2) / Mittel-Leimbach', 1, 'zurich-kreis-2-mittel-leimbach', 47.32538000, 8.51391000),
(1018831, 1001656, 'CH', 'Zürich (Kreis 2) / Unter-Leimbach', 1, 'zurich-kreis-2-unter-leimbach', 47.33362000, 8.51433000),
(1018832, 1001656, 'CH', 'Zürich (Kreis 2) / Wollishofen', 1, 'zurich-kreis-2-wollishofen', 47.34010000, 8.53134000),
(1018833, 1001656, 'CH', 'Zürich (Kreis 3)', 1, 'zurich-kreis-3', 47.35785000, 8.50296000),
(1018834, 1001656, 'CH', 'Zürich (Kreis 3) / Alt-Wiedikon', 1, 'zurich-kreis-3-alt-wiedikon', 47.36201000, 8.51497000),
(1018835, 1001656, 'CH', 'Zürich (Kreis 3) / Friesenberg', 1, 'zurich-kreis-3-friesenberg', 47.36372000, 8.50417000),
(1018836, 1001656, 'CH', 'Zürich (Kreis 3) / Sihlfeld', 1, 'zurich-kreis-3-sihlfeld', 47.37382000, 8.51164000),
(1018837, 1001656, 'CH', 'Zürich (Kreis 4) / Aussersihl', 1, 'zurich-kreis-4-aussersihl', 47.37752000, 8.52127000),
(1018838, 1001656, 'CH', 'Zürich (Kreis 4) / Hard', 1, 'zurich-kreis-4-hard', 47.38311000, 8.50942000),
(1018839, 1001656, 'CH', 'Zürich (Kreis 4) / Langstrasse', 1, 'zurich-kreis-4-langstrasse', 47.37767000, 8.52854000),
(1018840, 1001656, 'CH', 'Zürich (Kreis 4) / Werd', 1, 'zurich-kreis-4-werd', 47.37178000, 8.52584000),
(1018841, 1001656, 'CH', 'Zürich (Kreis 5)', 1, 'zurich-kreis-5', 47.38767000, 8.52152000),
(1018842, 1001656, 'CH', 'Zürich (Kreis 5) / Escher-Wyss', 1, 'zurich-kreis-5-escher-wyss', 47.39052000, 8.51292000),
(1018843, 1001656, 'CH', 'Zürich (Kreis 5) / Gewerbeschule', 1, 'zurich-kreis-5-gewerbeschule', 47.38481000, 8.53011000),
(1018844, 1001656, 'CH', 'Zürich (Kreis 6)', 1, 'zurich-kreis-6', 47.39223000, 8.54381000),
(1018845, 1001656, 'CH', 'Zürich (Kreis 6) / Oberstrass', 1, 'zurich-kreis-6-oberstrass', 47.38917000, 8.55040000),
(1018846, 1001656, 'CH', 'Zürich (Kreis 6) / Unterstrass', 1, 'zurich-kreis-6-unterstrass', 47.39530000, 8.53721000),
(1018847, 1001656, 'CH', 'Zürich (Kreis 7)', 1, 'zurich-kreis-7', 47.37328000, 8.58038000),
(1018848, 1001656, 'CH', 'Zürich (Kreis 7) / Fluntern', 1, 'zurich-kreis-7-fluntern', 47.38013000, 8.56133000),
(1018849, 1001656, 'CH', 'Zürich (Kreis 7) / Hirslanden', 1, 'zurich-kreis-7-hirslanden', 47.36240000, 8.56755000),
(1018850, 1001656, 'CH', 'Zürich (Kreis 7) / Hottingen', 1, 'zurich-kreis-7-hottingen', 47.37011000, 8.56306000),
(1018851, 1001656, 'CH', 'Zürich (Kreis 7) / Witikon', 1, 'zurich-kreis-7-witikon', 47.35751000, 8.59105000),
(1018852, 1001656, 'CH', 'Zürich (Kreis 8)', 1, 'zurich-kreis-8', 47.35480000, 8.56097000),
(1018853, 1001656, 'CH', 'Zürich (Kreis 8) / Mühlebach', 1, 'zurich-kreis-8-muhlebach', 47.35727000, 8.55744000),
(1018854, 1001656, 'CH', 'Zürich (Kreis 8) / Seefeld', 1, 'zurich-kreis-8-seefeld', 47.35462000, 8.55537000),
(1018855, 1001656, 'CH', 'Zürich (Kreis 8) / Weinegg', 1, 'zurich-kreis-8-weinegg', 47.35250000, 8.57011000),
(1018856, 1001656, 'CH', 'Zürich (Kreis 9)', 1, 'zurich-kreis-9', 47.38245000, 8.47993000),
(1018857, 1001656, 'CH', 'Zürich (Kreis 9) / Albisrieden', 1, 'zurich-kreis-9-albisrieden', 47.37398000, 8.49007000),
(1018858, 1001656, 'CH', 'Zürich (Kreis 9) / Altstetten', 1, 'zurich-kreis-9-altstetten', 47.38946000, 8.48533000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001661, 'CH', 'Glarus', 1, 'glarus');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1017529, 1001661, 'CH', 'Bilten', 1, 'bilten', 47.14995000, 9.02551000),
(1017751, 1001661, 'CH', 'Ennenda', 1, 'ennenda', 47.03363000, 9.07888000),
(1017839, 1001661, 'CH', 'Glarus', 1, 'glarus', 47.04057000, 9.06804000),
(1018086, 1001661, 'CH', 'Linthal', 1, 'linthal', 46.92127000, 8.99799000),
(1018097, 1001661, 'CH', 'Luchsingen', 1, 'luchsingen', 46.96640000, 9.03715000),
(1018162, 1001661, 'CH', 'Mollis', 1, 'mollis', 47.08878000, 9.07242000),
(1018235, 1001661, 'CH', 'Näfels', 1, 'nafels', 47.09775000, 9.06361000),
(1018211, 1001661, 'CH', 'Netstal', 1, 'netstal', 47.06337000, 9.05734000),
(1018229, 1001661, 'CH', 'Niederurnen', 1, 'niederurnen', 47.12598000, 9.05428000),
(1018268, 1001661, 'CH', 'Oberurnen', 1, 'oberurnen', 47.11412000, 9.05866000),
(1018475, 1001661, 'CH', 'Schwanden', 1, 'schwanden', 46.99541000, 9.07010000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001660, 'CH', 'Graubünden', 1, 'graubunden');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1017409, 1001660, 'CH', 'Arosa', 1, 'arosa', 46.77793000, 9.67621000),
(1017411, 1001660, 'CH', 'Arvigo', 1, 'arvigo', 46.30211000, 9.11300000),
(1017547, 1001660, 'CH', 'Bonaduz', 1, 'bonaduz', 46.81103000, 9.39821000),
(1017559, 1001660, 'CH', 'Breíl', 1, 'breil', 46.76986000, 9.06036000),
(1017571, 1001660, 'CH', 'Brusio', 1, 'brusio', 46.25953000, 10.12385000),
(1017585, 1001660, 'CH', 'Buseno', 1, 'buseno', 46.27381000, 9.10735000),
(1017615, 1001660, 'CH', 'Cauco', 1, 'cauco', 46.33541000, 9.12129000),
(1017617, 1001660, 'CH', 'Cazis', 1, 'cazis', 46.71940000, 9.43271000),
(1017618, 1001660, 'CH', 'Celerina', 1, 'celerina', 46.51217000, 9.85794000),
(1017638, 1001660, 'CH', 'Chur', 1, 'chur', 46.84986000, 9.53287000),
(1017639, 1001660, 'CH', 'Churwalden', 1, 'churwalden', 46.78143000, 9.54377000),
(1017677, 1001660, 'CH', 'Davos', 1, 'davos', 46.80429000, 9.83723000),
(1017699, 1001660, 'CH', 'Disentis', 1, 'disentis', 46.70341000, 8.85090000),
(1017700, 1001660, 'CH', 'Domat', 1, 'domat', 46.83483000, 9.45075000),
(1017783, 1001660, 'CH', 'Felsberg', 1, 'felsberg', 46.84566000, 9.47588000),
(1017793, 1001660, 'CH', 'Flims', 1, 'flims', 46.83705000, 9.28458000),
(1017882, 1001660, 'CH', 'Grüsch', 1, 'grusch', 46.97965000, 9.64639000),
(1017917, 1001660, 'CH', 'Hinterrhein', 1, 'hinterrhein', 46.53333000, 9.20000000),
(1017947, 1001660, 'CH', 'Igis', 1, 'igis', 46.94531000, 9.57218000),
(1017948, 1001660, 'CH', 'Ilanz', 1, 'ilanz', 46.77413000, 9.20461000),
(1017958, 1001660, 'CH', 'Jenaz', 1, 'jenaz', 46.92892000, 9.71275000),
(1017986, 1001660, 'CH', 'Klosters Serneus', 1, 'klosters-serneus', 46.88918000, 9.83826000),
(1018024, 1001660, 'CH', 'La Punt Chamues-ch', 1, 'la-punt-chamues-ch', 46.57887000, 9.92015000),
(1018029, 1001660, 'CH', 'Laax', 1, 'laax', 46.80452000, 9.25787000),
(1018033, 1001660, 'CH', 'Landquart', 1, 'landquart', 46.95000000, 9.56667000),
(1018067, 1001660, 'CH', 'Lenzerheide', 1, 'lenzerheide', 46.72215000, 9.55905000),
(1018105, 1001660, 'CH', 'Luzein', 1, 'luzein', 46.91957000, 9.76080000),
(1018116, 1001660, 'CH', 'Maienfeld', 1, 'maienfeld', 47.00472000, 9.53115000),
(1018117, 1001660, 'CH', 'Malans', 1, 'malans', 46.98096000, 9.57527000),
(1018155, 1001660, 'CH', 'Mesocco', 1, 'mesocco', 46.39390000, 9.23333000),
(1018318, 1001660, 'CH', 'Pontresina', 1, 'pontresina', 46.49550000, 9.90126000),
(1018321, 1001660, 'CH', 'Poschiavo', 1, 'poschiavo', 46.32441000, 10.05823000),
(1018348, 1001660, 'CH', 'Region Albula', 1, 'region-albula', 46.60255000, 9.65150000),
(1018349, 1001660, 'CH', 'Region Bernina', 1, 'region-bernina', 46.33488000, 10.07349000),
(1018350, 1001660, 'CH', 'Region Engiadina Bassa / Val Müstair', 1, 'region-engiadina-bassa-val-mustair', 46.75212000, 10.26032000),
(1018351, 1001660, 'CH', 'Region Imboden', 1, 'region-imboden', 46.84876000, 9.36225000),
(1018352, 1001660, 'CH', 'Region Landquart', 1, 'region-landquart', 46.96403000, 9.56365000),
(1018353, 1001660, 'CH', 'Region Maloja', 1, 'region-maloja', 46.47448000, 9.83138000),
(1018354, 1001660, 'CH', 'Region Moesa', 1, 'region-moesa', 46.35200000, 9.17870000),
(1018355, 1001660, 'CH', 'Region Plessur', 1, 'region-plessur', 46.81819000, 9.62542000),
(1018356, 1001660, 'CH', 'Region Prättigau / Davos', 1, 'region-prattigau-davos', 46.86727000, 9.82014000),
(1018357, 1001660, 'CH', 'Region Surselva', 1, 'region-surselva', 46.69564000, 9.04834000),
(1018358, 1001660, 'CH', 'Region Viamala', 1, 'region-viamala', 46.58762000, 9.40035000),
(1018367, 1001660, 'CH', 'Rhäzüns', 1, 'rhazuns', 46.79891000, 9.39764000),
(1018435, 1001660, 'CH', 'Samedan', 1, 'samedan', 46.53399000, 9.87276000),
(1018457, 1001660, 'CH', 'Scharans', 1, 'scharans', 46.71814000, 9.45903000),
(1018460, 1001660, 'CH', 'Schiers', 1, 'schiers', 46.96973000, 9.68720000),
(1018490, 1001660, 'CH', 'Scuol', 1, 'scuol', 46.79671000, 10.29804000),
(1018522, 1001660, 'CH', 'Silvaplana', 1, 'silvaplana', 46.45810000, 9.79514000),
(1018535, 1001660, 'CH', 'St. Moritz', 1, 'st-moritz', 46.49937000, 9.84327000),
(1018572, 1001660, 'CH', 'Tamins', 1, 'tamins', 46.82964000, 9.40648000),
(1018594, 1001660, 'CH', 'Thusis', 1, 'thusis', 46.69724000, 9.43938000),
(1018596, 1001660, 'CH', 'Tiefencastel', 1, 'tiefencastel', 46.66014000, 9.57883000),
(1018604, 1001660, 'CH', 'Trimmis', 1, 'trimmis', 46.90075000, 9.56120000),
(1018610, 1001660, 'CH', 'Trun', 1, 'trun', 46.74292000, 8.98716000),
(1018637, 1001660, 'CH', 'Untervaz', 1, 'untervaz', 46.92750000, 9.53422000),
(1018660, 1001660, 'CH', 'Vals Platz', 1, 'vals-platz', 46.61647000, 9.18025000),
(1018794, 1001660, 'CH', 'Zernez', 1, 'zernez', 46.69862000, 10.09268000),
(1018795, 1001660, 'CH', 'Zizers', 1, 'zizers', 46.93575000, 9.56491000),
(1018804, 1001660, 'CH', 'Zuoz', 1, 'zuoz', 46.60206000, 9.95965000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001652, 'CH', 'Nidwalden', 1, 'nidwalden');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1017448, 1001652, 'CH', 'Beckenried', 1, 'beckenried', 46.96653000, 8.47575000),
(1017582, 1001652, 'CH', 'Buochs', 1, 'buochs', 46.97398000, 8.42279000),
(1017675, 1001652, 'CH', 'Dallenwil', 1, 'dallenwil', 46.92420000, 8.38785000),
(1017748, 1001652, 'CH', 'Emmetten', 1, 'emmetten', 46.95658000, 8.51467000),
(1017752, 1001652, 'CH', 'Ennetbürgen', 1, 'ennetburgen', 46.98423000, 8.41003000),
(1017906, 1001652, 'CH', 'Hergiswil', 1, 'hergiswil', 46.98429000, 8.30944000),
(1018546, 1001652, 'CH', 'Stans', 1, 'stans', 46.95805000, 8.36609000),
(1018547, 1001652, 'CH', 'Stansstad', 1, 'stansstad', 46.97680000, 8.33553000),
(1018763, 1001652, 'CH', 'Wolfenschiessen', 1, 'wolfenschiessen', 46.90322000, 8.39423000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001650, 'CH', 'Obwalden', 1, 'obwalden');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1017387, 1001650, 'CH', 'Alpnach', 1, 'alpnach', 46.94227000, 8.27180000),
(1017750, 1001650, 'CH', 'Engelberg', 1, 'engelberg', 46.82107000, 8.40133000),
(1017835, 1001650, 'CH', 'Giswil', 1, 'giswil', 46.83333000, 8.18065000),
(1017973, 1001650, 'CH', 'Kerns', 1, 'kerns', 46.90121000, 8.27514000),
(1018101, 1001650, 'CH', 'Lungern', 1, 'lungern', 46.78578000, 8.15984000),
(1018418, 1001650, 'CH', 'Sachseln', 1, 'sachseln', 46.86718000, 8.23344000),
(1018447, 1001650, 'CH', 'Sarnen', 1, 'sarnen', 46.89611000, 8.24531000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001653, 'CH', 'Schwyz', 1, 'schwyz');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1017389, 1001653, 'CH', 'Altendorf', 1, 'altendorf', 47.18994000, 8.83823000),
(1017410, 1001653, 'CH', 'Arth', 1, 'arth', 47.06337000, 8.52349000),
(1017590, 1001653, 'CH', 'Bäch', 1, 'bach', 47.20388000, 8.73224000),
(1017483, 1001653, 'CH', 'Bezirk Einsiedeln', 1, 'bezirk-einsiedeln', 47.10792000, 8.76010000),
(1017484, 1001653, 'CH', 'Bezirk Gersau', 1, 'bezirk-gersau', 47.00800000, 8.51678000),
(1017490, 1001653, 'CH', 'Bezirk Höfe', 1, 'bezirk-hofe', 47.19043000, 8.73960000),
(1017492, 1001653, 'CH', 'Bezirk Küssnacht', 1, 'bezirk-kussnacht', 47.08611000, 8.44444000),
(1017498, 1001653, 'CH', 'Bezirk March', 1, 'bezirk-march', 47.16128000, 8.91103000),
(1017509, 1001653, 'CH', 'Bezirk Schwyz', 1, 'bezirk-schwyz', 47.02814000, 8.63619000),
(1017738, 1001653, 'CH', 'Einsiedeln', 1, 'einsiedeln', 47.12849000, 8.74735000),
(1017787, 1001653, 'CH', 'Feusisberg', 1, 'feusisberg', 47.18707000, 8.74724000),
(1017806, 1001653, 'CH', 'Freienbach', 1, 'freienbach', 47.20534000, 8.75842000),
(1017830, 1001653, 'CH', 'Gersau', 1, 'gersau', 46.99419000, 8.52500000),
(1017848, 1001653, 'CH', 'Goldau', 1, 'goldau', 47.04761000, 8.54616000),
(1017946, 1001653, 'CH', 'Ibach', 1, 'ibach', 47.01105000, 8.64538000),
(1017951, 1001653, 'CH', 'Ingenbohl', 1, 'ingenbohl', 46.99880000, 8.61529000),
(1018019, 1001653, 'CH', 'Küssnacht', 1, 'kussnacht', 47.08557000, 8.44206000),
(1018030, 1001653, 'CH', 'Lachen', 1, 'lachen', 47.19224000, 8.85324000),
(1018179, 1001653, 'CH', 'Muotathal', 1, 'muotathal', 46.97676000, 8.76499000),
(1018310, 1001653, 'CH', 'Pfäffikon', 1, 'pfaffikon', 47.20109000, 8.77816000),
(1018360, 1001653, 'CH', 'Reichenburg', 1, 'reichenburg', 47.17097000, 8.97704000),
(1018393, 1001653, 'CH', 'Rothenthurm', 1, 'rothenthurm', 47.10420000, 8.67585000),
(1018449, 1001653, 'CH', 'Sattel', 1, 'sattel', 47.08246000, 8.63565000),
(1018461, 1001653, 'CH', 'Schindellegi', 1, 'schindellegi', 47.17460000, 8.71345000),
(1018487, 1001653, 'CH', 'Schübelbach', 1, 'schubelbach', 47.17326000, 8.92811000),
(1018481, 1001653, 'CH', 'Schwyz', 1, 'schwyz', 47.02076000, 8.65414000),
(1018516, 1001653, 'CH', 'Siebnen', 1, 'siebnen', 47.17449000, 8.89781000),
(1018553, 1001653, 'CH', 'Steinen', 1, 'steinen', 47.04975000, 8.61214000),
(1018612, 1001653, 'CH', 'Tuggen', 1, 'tuggen', 47.20291000, 8.94896000),
(1018632, 1001653, 'CH', 'Unteriberg', 1, 'unteriberg', 47.06258000, 8.80520000),
(1018693, 1001653, 'CH', 'Vorderthal', 1, 'vorderthal', 47.12172000, 8.90225000),
(1018767, 1001653, 'CH', 'Wollerau', 1, 'wollerau', 47.19478000, 8.71903000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001657, 'CH', 'Thurgau', 1, 'thurgau');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1017356, 1001657, 'CH', 'Aadorf', 1, 'aadorf', 47.49204000, 8.90099000),
(1017374, 1001657, 'CH', 'Affeltrangen', 1, 'affeltrangen', 47.52581000, 9.03307000),
(1017392, 1001657, 'CH', 'Altnau', 1, 'altnau', 47.61052000, 9.26160000),
(1017395, 1001657, 'CH', 'Amriswil', 1, 'amriswil', 47.54699000, 9.29586000),
(1017402, 1001657, 'CH', 'Arbon', 1, 'arbon', 47.51667000, 9.43333000),
(1017403, 1001657, 'CH', 'Arbon District', 1, 'arbon-district', 47.54867000, 9.35159000),
(1017459, 1001657, 'CH', 'Berg', 1, 'berg', 47.57879000, 9.16635000),
(1017552, 1001657, 'CH', 'Bottighofen', 1, 'bottighofen', 47.63643000, 9.20882000),
(1017603, 1001657, 'CH', 'Bürglen', 1, 'burglen', 47.54921000, 9.14950000),
(1017688, 1001657, 'CH', 'Diessenhofen', 1, 'diessenhofen', 47.68908000, 8.74958000),
(1017733, 1001657, 'CH', 'Egnach', 1, 'egnach', 47.54268000, 9.38048000),
(1017760, 1001657, 'CH', 'Erlen', 1, 'erlen', 47.54814000, 9.23415000),
(1017766, 1001657, 'CH', 'Ermatingen', 1, 'ermatingen', 47.67057000, 9.08573000),
(1017770, 1001657, 'CH', 'Eschenz', 1, 'eschenz', 47.64793000, 8.87472000),
(1017771, 1001657, 'CH', 'Eschlikon', 1, 'eschlikon', 47.46361000, 8.96381000),
(1017789, 1001657, 'CH', 'Fischingen', 1, 'fischingen', 47.41422000, 8.96862000),
(1017803, 1001657, 'CH', 'Frauenfeld', 1, 'frauenfeld', 47.55776000, 8.89893000),
(1017804, 1001657, 'CH', 'Frauenfeld District', 1, 'frauenfeld-district', 47.61115000, 8.89444000),
(1017818, 1001657, 'CH', 'Gachnang', 1, 'gachnang', 47.53935000, 8.85311000),
(1017858, 1001657, 'CH', 'Gottlieben', 1, 'gottlieben', 47.66380000, 9.13371000),
(1017889, 1001657, 'CH', 'Güttingen', 1, 'guttingen', 47.60349000, 9.28742000),
(1017928, 1001657, 'CH', 'Homburg', 1, 'homburg', 47.63469000, 9.00756000),
(1017945, 1001657, 'CH', 'Hüttwilen', 1, 'huttwilen', 47.60674000, 8.87343000),
(1018005, 1001657, 'CH', 'Kreuzlingen', 1, 'kreuzlingen', 47.65051000, 9.17504000),
(1018006, 1001657, 'CH', 'Kreuzlingen District', 1, 'kreuzlingen-district', 47.63046000, 9.16458000),
(1018041, 1001657, 'CH', 'Langrickenbach', 1, 'langrickenbach', 47.59353000, 9.24727000),
(1018189, 1001657, 'CH', 'Märstetten-Dorf', 1, 'marstetten-dorf', 47.59252000, 9.06851000),
(1018135, 1001657, 'CH', 'Matzingen', 1, 'matzingen', 47.51957000, 8.93365000),
(1018198, 1001657, 'CH', 'Müllheim', 1, 'mullheim', 47.60195000, 9.00357000),
(1018202, 1001657, 'CH', 'Münchwilen', 1, 'munchwilen', 47.47719000, 8.99677000),
(1018203, 1001657, 'CH', 'Münchwilen District', 1, 'munchwilen-district', 47.47324000, 8.98812000),
(1018205, 1001657, 'CH', 'Münsterlingen', 1, 'munsterlingen', 47.63197000, 9.23271000),
(1018309, 1001657, 'CH', 'Pfyn', 1, 'pfyn', 47.59693000, 8.95420000),
(1018373, 1001657, 'CH', 'Rickenbach bei Wil', 1, 'rickenbach-bei-wil', 47.44856000, 9.04902000),
(1018383, 1001657, 'CH', 'Roggwil', 1, 'roggwil', 47.49981000, 9.39580000),
(1018388, 1001657, 'CH', 'Romanshorn', 1, 'romanshorn', 47.56586000, 9.37869000),
(1018433, 1001657, 'CH', 'Salmsach', 1, 'salmsach', 47.55433000, 9.37229000),
(1018525, 1001657, 'CH', 'Sirnach', 1, 'sirnach', 47.46222000, 8.99763000),
(1018549, 1001657, 'CH', 'Steckborn', 1, 'steckborn', 47.66667000, 8.98333000),
(1018557, 1001657, 'CH', 'Stettfurt', 1, 'stettfurt', 47.52588000, 8.95317000),
(1018563, 1001657, 'CH', 'Sulgen', 1, 'sulgen', 47.53967000, 9.18585000),
(1018616, 1001657, 'CH', 'Tägerwilen', 1, 'tagerwilen', 47.65698000, 9.13999000),
(1018593, 1001657, 'CH', 'Thundorf', 1, 'thundorf', 47.54594000, 8.96358000),
(1018652, 1001657, 'CH', 'Uttwil', 1, 'uttwil', 47.58440000, 9.34101000),
(1018698, 1001657, 'CH', 'Wagenhausen', 1, 'wagenhausen', 47.66003000, 8.84782000),
(1018781, 1001657, 'CH', 'Wängi', 1, 'wangi', 47.49654000, 8.95325000),
(1018730, 1001657, 'CH', 'Weinfelden', 1, 'weinfelden', 47.56667000, 9.10000000),
(1018731, 1001657, 'CH', 'Weinfelden District', 1, 'weinfelden-district', 47.54237000, 9.15713000),
(1018747, 1001657, 'CH', 'Wigoltingen', 1, 'wigoltingen', 47.59770000, 9.03141000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001643, 'CH', 'Ticino', 1, 'ticino');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1017361, 1001643, 'CH', 'Acquarossa', 1, 'acquarossa', 46.45473000, 8.94261000),
(1017380, 1001643, 'CH', 'Agno', 1, 'agno', 45.99863000, 8.90030000),
(1017384, 1001643, 'CH', 'Airolo', 1, 'airolo', 46.52855000, 8.61189000),
(1017413, 1001643, 'CH', 'Arzo', 1, 'arzo', 45.87606000, 8.94103000),
(1017414, 1001643, 'CH', 'Ascona', 1, 'ascona', 46.15451000, 8.77327000),
(1017434, 1001643, 'CH', 'Balerna', 1, 'balerna', 45.84638000, 9.00724000),
(1017452, 1001643, 'CH', 'Bellinzona', 1, 'bellinzona', 46.19278000, 9.01703000),
(1017453, 1001643, 'CH', 'Bellinzona District', 1, 'bellinzona-district', 46.18858000, 9.00254000),
(1017524, 1001643, 'CH', 'Biasca', 1, 'biasca', 46.35972000, 8.96965000),
(1017533, 1001643, 'CH', 'Bioggio', 1, 'bioggio', 46.01357000, 8.91103000),
(1017540, 1001643, 'CH', 'Blenio District', 1, 'blenio-district', 46.47613000, 8.94609000),
(1017544, 1001643, 'CH', 'Bodio', 1, 'bodio', 46.37808000, 8.90991000),
(1017564, 1001643, 'CH', 'Brissago', 1, 'brissago', 46.12013000, 8.71181000),
(1017607, 1001643, 'CH', 'Cadempino', 1, 'cadempino', 46.03672000, 8.93403000),
(1017608, 1001643, 'CH', 'Cadenazzo', 1, 'cadenazzo', 46.15172000, 8.94719000),
(1017609, 1001643, 'CH', 'Cadro', 1, 'cadro', 46.04595000, 8.98725000),
(1017610, 1001643, 'CH', 'Camorino', 1, 'camorino', 46.16483000, 9.00547000),
(1017611, 1001643, 'CH', 'Canobbio', 1, 'canobbio', 46.03592000, 8.96605000),
(1017613, 1001643, 'CH', 'Caslano', 1, 'caslano', 45.97364000, 8.87739000),
(1017614, 1001643, 'CH', 'Castel San Pietro', 1, 'castel-san-pietro', 45.86211000, 9.00843000),
(1017620, 1001643, 'CH', 'Cevio', 1, 'cevio', 46.31479000, 8.60332000),
(1017636, 1001643, 'CH', 'Chiasso', 1, 'chiasso', 45.83203000, 9.03119000),
(1017645, 1001643, 'CH', 'Claro', 1, 'claro', 46.25763000, 9.02252000),
(1017648, 1001643, 'CH', 'Comano', 1, 'comano', 46.03635000, 8.95526000),
(1017670, 1001643, 'CH', 'Cugnasco', 1, 'cugnasco', 46.17473000, 8.91684000),
(1017780, 1001643, 'CH', 'Faido', 1, 'faido', 46.47700000, 8.80125000),
(1017836, 1001643, 'CH', 'Giubiasco', 1, 'giubiasco', 46.17246000, 9.00793000),
(1017854, 1001643, 'CH', 'Gordola', 1, 'gordola', 46.18256000, 8.86657000),
(1017863, 1001643, 'CH', 'Gravesano', 1, 'gravesano', 46.04208000, 8.91832000),
(1018053, 1001643, 'CH', 'Lavertezzo', 1, 'lavertezzo', 46.25893000, 8.83756000),
(1018078, 1001643, 'CH', 'Leventina District', 1, 'leventina-district', 46.46912000, 8.75539000),
(1018084, 1001643, 'CH', 'Ligornetto', 1, 'ligornetto', 45.86161000, 8.95166000),
(1018088, 1001643, 'CH', 'Locarno', 1, 'locarno', 46.17086000, 8.79953000),
(1018089, 1001643, 'CH', 'Locarno District', 1, 'locarno-district', 46.18033000, 8.75991000),
(1018090, 1001643, 'CH', 'Lodrino', 1, 'lodrino', 46.30016000, 8.97986000),
(1018091, 1001643, 'CH', 'Losone', 1, 'losone', 46.16866000, 8.75928000),
(1018098, 1001643, 'CH', 'Lugano', 1, 'lugano', 46.01008000, 8.96004000),
(1018099, 1001643, 'CH', 'Lugano District', 1, 'lugano-district', 46.02322000, 8.93802000),
(1018100, 1001643, 'CH', 'Lumino', 1, 'lumino', 46.23020000, 9.06420000),
(1018114, 1001643, 'CH', 'Magadino', 1, 'magadino', 46.14892000, 8.85610000),
(1018120, 1001643, 'CH', 'Malvaglia', 1, 'malvaglia', 46.40588000, 8.98190000),
(1018128, 1001643, 'CH', 'Massagno', 1, 'massagno', 46.01257000, 8.94354000),
(1018145, 1001643, 'CH', 'Melano', 1, 'melano', 45.92202000, 8.98435000),
(1018147, 1001643, 'CH', 'Melide', 1, 'melide', 45.95455000, 8.94725000),
(1018149, 1001643, 'CH', 'Mendrisio', 1, 'mendrisio', 45.87019000, 8.98160000),
(1018150, 1001643, 'CH', 'Mendrisio District', 1, 'mendrisio-district', 45.86592000, 8.99931000),
(1018159, 1001643, 'CH', 'Minusio', 1, 'minusio', 46.17769000, 8.81473000),
(1018163, 1001643, 'CH', 'Montagnola', 1, 'montagnola', 45.98323000, 8.91786000),
(1018166, 1001643, 'CH', 'Monte Carasso', 1, 'monte-carasso', 46.18649000, 8.99892000),
(1018170, 1001643, 'CH', 'Morbio Inferiore', 1, 'morbio-inferiore', 45.84915000, 9.01907000),
(1018180, 1001643, 'CH', 'Muralto', 1, 'muralto', 46.17323000, 8.80219000),
(1018231, 1001643, 'CH', 'Novazzano', 1, 'novazzano', 45.84073000, 8.98236000),
(1018325, 1001643, 'CH', 'Pregassona', 1, 'pregassona', 46.02021000, 8.97429000),
(1018331, 1001643, 'CH', 'Pura', 1, 'pura', 45.98647000, 8.86877000),
(1018378, 1001643, 'CH', 'Riva San Vitale', 1, 'riva-san-vitale', 45.90123000, 8.97167000),
(1018379, 1001643, 'CH', 'Riviera District', 1, 'riviera-district', 46.30926000, 8.98148000),
(1018507, 1001643, 'CH', 'Sementina', 1, 'sementina', 46.18363000, 8.99162000),
(1018530, 1001643, 'CH', 'Sorengo', 1, 'sorengo', 45.99766000, 8.93783000),
(1018536, 1001643, 'CH', 'Stabio', 1, 'stabio', 45.84846000, 8.93642000),
(1018578, 1001643, 'CH', 'Tesserete', 1, 'tesserete', 46.06813000, 8.96501000),
(1018658, 1001643, 'CH', 'Vallemaggia District', 1, 'vallemaggia-district', 46.35483000, 8.60540000),
(1018671, 1001643, 'CH', 'Verscio', 1, 'verscio', 46.18482000, 8.73224000),
(1018678, 1001643, 'CH', 'Viganello', 1, 'viganello', 46.01342000, 8.96879000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1001642, 'CH', 'Uri', 1, 'uri');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(1017388, 1001642, 'CH', 'Altdorf', 1, 'altdorf', 46.88042000, 8.64441000),
(1017397, 1001642, 'CH', 'Andermatt', 1, 'andermatt', 46.63565000, 8.59388000),
(1017416, 1001642, 'CH', 'Attinghausen', 1, 'attinghausen', 46.86255000, 8.63036000),
(1017444, 1001642, 'CH', 'Bauen', 1, 'bauen', 46.93559000, 8.57836000),
(1017602, 1001642, 'CH', 'Bürglen', 1, 'burglen', 46.87565000, 8.66539000),
(1017768, 1001642, 'CH', 'Erstfeld', 1, 'erstfeld', 46.81885000, 8.65052000),
(1017796, 1001642, 'CH', 'Flüelen', 1, 'fluelen', 46.90478000, 8.62396000),
(1018458, 1001642, 'CH', 'Schattdorf', 1, 'schattdorf', 46.86550000, 8.65465000),
(1018492, 1001642, 'CH', 'Seedorf', 1, 'seedorf', 46.88199000, 8.61611000),
(1018521, 1001642, 'CH', 'Silenen', 1, 'silenen', 46.78910000, 8.67325000);

