REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug, s_phone_code, s_name_native, s_currency) VALUES 
('JP', 'Japan', 'japan', '81', '日本', 'JPY');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000827, 'JP', 'Aichi Prefecture', 1, 'aichi-prefecture');

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 
(1063223, 1000827, 'JP', 'Aisai-shi', 1, 'aisai-shi', 35.17234000, 136.69478000),
(1063237, 1000827, 'JP', 'Ama-gun', 1, 'ama-gun', 35.17174000, 136.82308000),
(1063246, 1000827, 'JP', 'Anjō-shi', 1, 'anjo-shi', 34.94341000, 137.07165000),
(1063305, 1000827, 'JP', 'Chiryū', 1, 'chiryu', 35.00000000, 137.03333000),
(1063306, 1000827, 'JP', 'Chiryū-shi', 1, 'chiryu-shi', 34.99862000, 137.05000000),
(1063307, 1000827, 'JP', 'Chita', 1, 'chita', 35.00267000, 136.86420000),
(1063308, 1000827, 'JP', 'Chita-shi', 1, 'chita-shi', 34.97048000, 136.86490000),
(1063382, 1000827, 'JP', 'Gamagōri', 1, 'gamagori', 34.83333000, 137.23333000),
(1063383, 1000827, 'JP', 'Gamagōri-shi', 1, 'gamagori-shi', 34.82759000, 137.22752000),
(1063433, 1000827, 'JP', 'Handa', 1, 'handa', 34.88333000, 136.93333000),
(1063434, 1000827, 'JP', 'Handa-shi', 1, 'handa-shi', 34.89903000, 136.92660000),
(1063453, 1000827, 'JP', 'Hekinan', 1, 'hekinan', 34.88333000, 136.98333000),
(1063454, 1000827, 'JP', 'Hekinan-shi', 1, 'hekinan-shi', 34.87955000, 136.99155000),
(1063542, 1000827, 'JP', 'Ichinomiya', 1, 'ichinomiya', 35.30000000, 136.80000000),
(1063543, 1000827, 'JP', 'Ichinomiya-shi', 1, 'ichinomiya-shi', 35.31037000, 136.79237000),
(1063573, 1000827, 'JP', 'Inazawa', 1, 'inazawa', 35.25000000, 136.78333000),
(1063574, 1000827, 'JP', 'Inazawa-shi', 1, 'inazawa-shi', 35.24814000, 136.77979000),
(1063576, 1000827, 'JP', 'Inuyama', 1, 'inuyama', 35.37995000, 136.94295000),
(1063577, 1000827, 'JP', 'Inuyama-shi', 1, 'inuyama-shi', 35.36232000, 136.98072000),
(1063598, 1000827, 'JP', 'Ishiki', 1, 'ishiki', 34.80000000, 137.01667000),
(1063624, 1000827, 'JP', 'Iwakura', 1, 'iwakura', 35.28333000, 136.86667000),
(1063625, 1000827, 'JP', 'Iwakura-shi', 1, 'iwakura-shi', 35.27927000, 136.86885000),
(1063711, 1000827, 'JP', 'Kanie', 1, 'kanie', 35.13333000, 136.80000000),
(1063723, 1000827, 'JP', 'Kariya', 1, 'kariya', 34.98333000, 136.98333000),
(1063725, 1000827, 'JP', 'Kariya-shi', 1, 'kariya-shi', 35.01098000, 137.00166000),
(1063745, 1000827, 'JP', 'Kasugai', 1, 'kasugai', 35.24762000, 136.97229000),
(1063746, 1000827, 'JP', 'Kasugai-shi', 1, 'kasugai-shi', 35.24762000, 136.97226000),
(1063811, 1000827, 'JP', 'Kitanagoya', 1, 'kitanagoya', 35.24702000, 136.87832000),
(1063812, 1000827, 'JP', 'Kitanagoya-shi', 1, 'kitanagoya-shi', 35.24640000, 136.87293000),
(1063816, 1000827, 'JP', 'Kiyosu-shi', 1, 'kiyosu-shi', 35.21325000, 136.84771000),
(1063835, 1000827, 'JP', 'Komaki', 1, 'komaki', 35.28333000, 136.91667000),
(1063836, 1000827, 'JP', 'Komaki-shi', 1, 'komaki-shi', 35.29103000, 136.91196000),
(1063896, 1000827, 'JP', 'Kōnan', 1, 'konan', 35.33165000, 136.87042000),
(1063897, 1000827, 'JP', 'Kōnan-shi', 1, 'konan-shi', 35.33137000, 136.87077000),
(1063850, 1000827, 'JP', 'Kozakai-chō', 1, 'kozakai-cho', 34.80000000, 137.35889000),
(1063875, 1000827, 'JP', 'Kuroda', 1, 'kuroda', 35.35000000, 136.78333000),
(1064017, 1000827, 'JP', 'Miyoshi-shi', 1, 'miyoshi-shi', 35.09480000, 137.08870000),
(1064063, 1000827, 'JP', 'Nagakute-shi', 1, 'nagakute-shi', 35.18335000, 137.04895000),
(1064078, 1000827, 'JP', 'Nagoya', 1, 'nagoya', 35.18147000, 136.90641000),
(1064152, 1000827, 'JP', 'Nishio', 1, 'nishio', 34.86667000, 137.05000000),
(1064153, 1000827, 'JP', 'Nishio-shi', 1, 'nishio-shi', 34.86223000, 137.05433000),
(1064158, 1000827, 'JP', 'Nisshin-shi', 1, 'nisshin-shi', 35.13114000, 137.03934000),
(1064715, 1000827, 'JP', 'Ōbu', 1, 'obu', 35.01756000, 136.94947000),
(1064716, 1000827, 'JP', 'Ōbu-shi', 1, 'obu-shi', 35.01920000, 136.95424000),
(1064197, 1000827, 'JP', 'Okazaki-shi', 1, 'okazaki-shi', 34.95245000, 137.25783000),
(1064218, 1000827, 'JP', 'Owariasahi-shi', 1, 'owariasahi-shi', 35.21652000, 137.03542000),
(1064304, 1000827, 'JP', 'Seto', 1, 'seto', 35.23333000, 137.10000000),
(1064305, 1000827, 'JP', 'Seto-shi', 1, 'seto-shi', 35.22340000, 137.08414000),
(1064345, 1000827, 'JP', 'Shinshiro', 1, 'shinshiro', 34.90000000, 137.50000000),
(1064346, 1000827, 'JP', 'Shinshiro-shi', 1, 'shinshiro-shi', 34.96073000, 137.54360000),
(1064372, 1000827, 'JP', 'Sobue', 1, 'sobue', 35.25000000, 136.71667000),
(1064410, 1000827, 'JP', 'Tahara', 1, 'tahara', 34.66667000, 137.26667000),
(1064411, 1000827, 'JP', 'Tahara-shi', 1, 'tahara-shi', 34.64140000, 137.18314000),
(1064420, 1000827, 'JP', 'Takahama', 1, 'takahama', 34.91667000, 136.98333000),
(1064421, 1000827, 'JP', 'Takahama-shi', 1, 'takahama-shi', 34.93337000, 136.99490000),
(1064450, 1000827, 'JP', 'Taketoyo', 1, 'taketoyo', 34.85000000, 136.91667000),
(1064568, 1000827, 'JP', 'Tōkai-shi', 1, 'tokai-shi', 35.02676000, 136.89846000),
(1064493, 1000827, 'JP', 'Tokoname', 1, 'tokoname', 34.88333000, 136.85000000),
(1064494, 1000827, 'JP', 'Tokoname-shi', 1, 'tokoname-shi', 34.88929000, 136.85299000),
(1064522, 1000827, 'JP', 'Toyoake', 1, 'toyoake', 35.03800000, 136.99931000),
(1064523, 1000827, 'JP', 'Toyoake-shi', 1, 'toyoake-shi', 35.06248000, 137.00887000),
(1064524, 1000827, 'JP', 'Toyohama', 1, 'toyohama', 34.70933000, 136.93425000),
(1064525, 1000827, 'JP', 'Toyohashi', 1, 'toyohashi', 34.76667000, 137.38333000),
(1064526, 1000827, 'JP', 'Toyohashi-shi', 1, 'toyohashi-shi', 34.74050000, 137.40714000),
(1064527, 1000827, 'JP', 'Toyokawa', 1, 'toyokawa', 34.81667000, 137.40000000),
(1064528, 1000827, 'JP', 'Toyokawa-shi', 1, 'toyokawa-shi', 34.85032000, 137.36175000),
(1064534, 1000827, 'JP', 'Toyota-shi', 1, 'toyota-shi', 35.08700000, 137.15000000),
(1064560, 1000827, 'JP', 'Tsushima', 1, 'tsushima', 35.16667000, 136.71667000),
(1064562, 1000827, 'JP', 'Tsushima-shi', 1, 'tsushima-shi', 35.17718000, 136.74168000),
(1064662, 1000827, 'JP', 'Yatomi-shi', 1, 'yatomi-shi', 35.10938000, 136.72451000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000829, 'JP', 'Akita Prefecture', 1, 'akita-prefecture');

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 
(1063233, 1000829, 'JP', 'Akita', 1, 'akita', 39.71667000, 140.11667000),
(1063234, 1000829, 'JP', 'Akita Shi', 1, 'akita-shi', 39.71043000, 140.23207000),
(1063318, 1000829, 'JP', 'Daisen', 1, 'daisen', 39.44116000, 140.48961000),
(1063319, 1000829, 'JP', 'Daisen-shi', 1, 'daisen-shi', 39.53710000, 140.44139000),
(1063432, 1000829, 'JP', 'Hanawa', 1, 'hanawa', 40.18361000, 140.78722000),
(1063675, 1000829, 'JP', 'Kakunodatemachi', 1, 'kakunodatemachi', 39.58926000, 140.56724000),
(1063751, 1000829, 'JP', 'Katagami', 1, 'katagami', 39.87869000, 139.99767000),
(1063752, 1000829, 'JP', 'Katagami-shi', 1, 'katagami-shi', 39.87209000, 140.04910000),
(1063780, 1000829, 'JP', 'Kazuno Shi', 1, 'kazuno-shi', 40.21035000, 140.83030000),
(1063798, 1000829, 'JP', 'Kitaakita-shi', 1, 'kitaakita-shi', 40.23446000, 140.39978000),
(1064137, 1000829, 'JP', 'Nikaho-shi', 1, 'nikaho-shi', 39.19677000, 139.97305000),
(1064168, 1000829, 'JP', 'Noshiro', 1, 'noshiro', 40.20838000, 140.02740000),
(1064169, 1000829, 'JP', 'Noshiro Shi', 1, 'noshiro-shi', 40.20289000, 140.14486000),
(1064719, 1000829, 'JP', 'Ōdate', 1, 'odate', 40.27178000, 140.55756000),
(1064720, 1000829, 'JP', 'Ōdate-shi', 1, 'odate-shi', 40.30000000, 140.55000000),
(1064185, 1000829, 'JP', 'Oga', 1, 'oga', 39.87100000, 139.84926000),
(1064186, 1000829, 'JP', 'Oga-shi', 1, 'oga-shi', 39.93793000, 139.83611000),
(1064736, 1000829, 'JP', 'Ōmagari', 1, 'omagari', 39.45000000, 140.48333000),
(1064299, 1000829, 'JP', 'Semboku-shi', 1, 'semboku-shi', 39.75709000, 140.66998000),
(1064430, 1000829, 'JP', 'Takanosu', 1, 'takanosu', 40.22268000, 140.36611000),
(1064482, 1000829, 'JP', 'Tennō', 1, 'tenno', 39.90000000, 139.96667000),
(1064674, 1000829, 'JP', 'Yokote', 1, 'yokote', 39.31691000, 140.55034000),
(1064675, 1000829, 'JP', 'Yokote-shi', 1, 'yokote-shi', 39.28369000, 140.54432000),
(1064698, 1000829, 'JP', 'Yurihonjō', 1, 'yurihonjo', 39.38950000, 140.05813000),
(1064699, 1000829, 'JP', 'Yurihonjō-shi', 1, 'yurihonjo-shi', 39.29336000, 140.16498000),
(1064701, 1000829, 'JP', 'Yuzawa', 1, 'yuzawa', 39.16667000, 140.50000000),
(1064702, 1000829, 'JP', 'Yuzawa-shi', 1, 'yuzawa-shi', 39.03658000, 140.54267000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000839, 'JP', 'Aomori Prefecture', 1, 'aomori-prefecture');

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 
(1063249, 1000839, 'JP', 'Aomori', 1, 'aomori', 40.81667000, 140.73333000),
(1063250, 1000839, 'JP', 'Aomori Shi', 1, 'aomori-shi', 40.77001000, 140.75423000),
(1063394, 1000839, 'JP', 'Goshogawara', 1, 'goshogawara', 40.80444000, 140.44139000),
(1063395, 1000839, 'JP', 'Goshogawara Shi', 1, 'goshogawara-shi', 40.91657000, 140.46998000),
(1063408, 1000839, 'JP', 'Hachinohe', 1, 'hachinohe', 40.50000000, 141.50000000),
(1063409, 1000839, 'JP', 'Hachinohe Shi', 1, 'hachinohe-shi', 40.47389000, 141.48125000),
(1063491, 1000839, 'JP', 'Hirakawa', 1, 'hirakawa', 40.58728000, 140.57107000),
(1063492, 1000839, 'JP', 'Hirakawa Shi', 1, 'hirakawa-shi', 40.51832000, 140.70048000),
(1063497, 1000839, 'JP', 'Hirosaki', 1, 'hirosaki', 40.59306000, 140.47250000),
(1063498, 1000839, 'JP', 'Hirosaki Shi', 1, 'hirosaki-shi', 40.60512000, 140.38460000),
(1063876, 1000839, 'JP', 'Kuroishi', 1, 'kuroishi', 40.64581000, 140.58354000),
(1063877, 1000839, 'JP', 'Kuroishi Shi', 1, 'kuroishi-shi', 40.61709000, 140.70467000),
(1063983, 1000839, 'JP', 'Misawa', 1, 'misawa', 40.68682000, 141.38969000),
(1063984, 1000839, 'JP', 'Misawa Shi', 1, 'misawa-shi', 40.74647000, 141.38124000),
(1064054, 1000839, 'JP', 'Mutsu', 1, 'mutsu', 41.28944000, 141.21694000),
(1064055, 1000839, 'JP', 'Mutsu-shi', 1, 'mutsu-shi', 41.29090000, 141.03327000),
(1064098, 1000839, 'JP', 'Namioka', 1, 'namioka', 40.71069000, 140.59048000),
(1064333, 1000839, 'JP', 'Shimokizukuri', 1, 'shimokizukuri', 40.81609000, 140.37539000),
(1064520, 1000839, 'JP', 'Towada Shi', 1, 'towada-shi', 40.56736000, 141.05794000),
(1064541, 1000839, 'JP', 'Tsugaru', 1, 'tsugaru', 40.80357000, 140.40299000),
(1064542, 1000839, 'JP', 'Tsugaru Shi', 1, 'tsugaru-shi', 40.86988000, 140.34963000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000821, 'JP', 'Chiba Prefecture', 1, 'chiba-prefecture');

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 
(1063213, 1000821, 'JP', 'Abiko', 1, 'abiko', 35.86667000, 140.01667000),
(1063214, 1000821, 'JP', 'Abiko-shi', 1, 'abiko-shi', 35.86947000, 140.06510000),
(1063258, 1000821, 'JP', 'Asahi-shi', 1, 'asahi-shi', 35.73443000, 140.65549000),
(1063293, 1000821, 'JP', 'Chiba', 1, 'chiba', 35.60000000, 140.11667000),
(1063314, 1000821, 'JP', 'Chōshi-shi', 1, 'choshi-shi', 35.74303000, 140.77552000),
(1063375, 1000821, 'JP', 'Funabashi-shi', 1, 'funabashi-shi', 35.69455000, 139.98255000),
(1063381, 1000821, 'JP', 'Futtsu', 1, 'futtsu', 35.31080000, 139.81877000),
(1063441, 1000821, 'JP', 'Hasaki', 1, 'hasaki', 35.73333000, 140.83333000),
(1063520, 1000821, 'JP', 'Honchō', 1, 'honcho', 35.70129000, 139.98648000),
(1063537, 1000821, 'JP', 'Ichihara', 1, 'ichihara', 35.51667000, 140.08333000),
(1063538, 1000821, 'JP', 'Ichihara Shi', 1, 'ichihara-shi', 35.42484000, 140.13725000),
(1063539, 1000821, 'JP', 'Ichikawa Shi', 1, 'ichikawa-shi', 35.71865000, 139.93294000),
(1063578, 1000821, 'JP', 'Inzai-shi', 1, 'inzai-shi', 35.81207000, 140.14098000),
(1063603, 1000821, 'JP', 'Isumi', 1, 'isumi', 35.23005000, 140.40492000),
(1063604, 1000821, 'JP', 'Isumi Shi', 1, 'isumi-shi', 35.27777000, 140.34335000),
(1063677, 1000821, 'JP', 'Kamagaya Shi', 1, 'kamagaya-shi', 35.77289000, 139.99883000),
(1063702, 1000821, 'JP', 'Kamogawa', 1, 'kamogawa', 35.09690000, 140.10030000),
(1063703, 1000821, 'JP', 'Kamogawa-shi', 1, 'kamogawa-shi', 35.10000000, 140.10000000),
(1063739, 1000821, 'JP', 'Kashiwa', 1, 'kashiwa', 35.86224000, 139.97732000),
(1063740, 1000821, 'JP', 'Kashiwa Shi', 1, 'kashiwa-shi', 35.86017000, 139.99386000),
(1063754, 1000821, 'JP', 'Katori-shi', 1, 'katori-shi', 35.88333000, 140.51667000),
(1063760, 1000821, 'JP', 'Katsuura', 1, 'katsuura', 35.14621000, 140.31507000),
(1063762, 1000821, 'JP', 'Katsuura-shi', 1, 'katsuura-shi', 35.17535000, 140.26760000),
(1063787, 1000821, 'JP', 'Kimitsu', 1, 'kimitsu', 35.35043000, 139.87029000),
(1063793, 1000821, 'JP', 'Kisarazu', 1, 'kisarazu', 35.38329000, 139.93254000),
(1063794, 1000821, 'JP', 'Kisarazu Shi', 1, 'kisarazu-shi', 35.36981000, 139.98749000),
(1063932, 1000821, 'JP', 'Matsudo Shi', 1, 'matsudo-shi', 35.79574000, 139.92908000),
(1063966, 1000821, 'JP', 'Minamibōsō Shi', 1, 'minamiboso-shi', 35.03657000, 139.92847000),
(1064022, 1000821, 'JP', 'Mobara', 1, 'mobara', 35.42583000, 140.29608000),
(1064023, 1000821, 'JP', 'Mobara Shi', 1, 'mobara-shi', 35.44981000, 140.30163000),
(1064069, 1000821, 'JP', 'Nagareyama', 1, 'nagareyama', 35.85630000, 139.90266000),
(1064070, 1000821, 'JP', 'Nagareyama-shi', 1, 'nagareyama-shi', 35.85631000, 139.90266000),
(1064107, 1000821, 'JP', 'Narashino-shi', 1, 'narashino-shi', 35.68091000, 140.03418000),
(1064108, 1000821, 'JP', 'Narita', 1, 'narita', 35.78333000, 140.31667000),
(1064109, 1000821, 'JP', 'Narita-shi', 1, 'narita-shi', 35.81547000, 140.35757000),
(1064112, 1000821, 'JP', 'Narutō', 1, 'naruto', 35.60000000, 140.41667000),
(1064163, 1000821, 'JP', 'Noda', 1, 'noda', 35.94897000, 139.86793000),
(1064164, 1000821, 'JP', 'Noda-shi', 1, 'noda-shi', 35.98516000, 139.86215000),
(1064712, 1000821, 'JP', 'Ōami', 1, 'oami', 35.51667000, 140.31667000),
(1064713, 1000821, 'JP', 'Ōamishirasato-shi', 1, 'oamishirasato-shi', 35.51279000, 140.34295000),
(1064724, 1000821, 'JP', 'Ōhara', 1, 'ohara', 35.24761000, 140.39289000),
(1064204, 1000821, 'JP', 'Omigawa', 1, 'omigawa', 35.85000000, 140.61667000),
(1064268, 1000821, 'JP', 'Sakura', 1, 'sakura', 35.71667000, 140.23333000),
(1064269, 1000821, 'JP', 'Sakura-shi', 1, 'sakura-shi', 35.70619000, 140.21326000),
(1064275, 1000821, 'JP', 'Sambu-gun', 1, 'sambu-gun', 35.68843000, 140.45346000),
(1064279, 1000821, 'JP', 'Sanmu', 1, 'sanmu', 35.62756000, 140.41762000),
(1064280, 1000821, 'JP', 'Sanmu-shi', 1, 'sanmu-shi', 35.62397000, 140.42079000),
(1064295, 1000821, 'JP', 'Sawara', 1, 'sawara', 35.88333000, 140.50000000),
(1064357, 1000821, 'JP', 'Shiroi', 1, 'shiroi', 35.80000000, 140.06667000),
(1064358, 1000821, 'JP', 'Shiroi-shi', 1, 'shiroi-shi', 35.80164000, 140.06005000),
(1064362, 1000821, 'JP', 'Shisui', 1, 'shisui', 35.71667000, 140.26667000),
(1064373, 1000821, 'JP', 'Sodegaura-shi', 1, 'sodegaura-shi', 35.41642000, 140.01771000),
(1064404, 1000821, 'JP', 'Sōsa-shi', 1, 'sosa-shi', 35.69983000, 140.55366000),
(1064474, 1000821, 'JP', 'Tateyama', 1, 'tateyama', 34.98333000, 139.86667000),
(1064475, 1000821, 'JP', 'Tateyama-shi', 1, 'tateyama-shi', 34.97156000, 139.86163000),
(1064566, 1000821, 'JP', 'Tōgane', 1, 'togane', 35.55000000, 140.36667000),
(1064567, 1000821, 'JP', 'Tōgane-shi', 1, 'togane-shi', 35.56517000, 140.36707000),
(1064508, 1000821, 'JP', 'Tomisato-shi', 1, 'tomisato-shi', 35.72024000, 140.34080000),
(1064598, 1000821, 'JP', 'Urayasu-shi', 1, 'urayasu-shi', 35.64250000, 139.90192000),
(1064629, 1000821, 'JP', 'Yachimata', 1, 'yachimata', 35.65000000, 140.31667000),
(1064630, 1000821, 'JP', 'Yachimata-shi', 1, 'yachimata-shi', 35.64241000, 140.29686000),
(1064631, 1000821, 'JP', 'Yachiyo-shi', 1, 'yachiyo-shi', 35.73921000, 140.10502000),
(1064703, 1000821, 'JP', 'Yōkaichiba', 1, 'yokaichiba', 35.70000000, 140.55000000),
(1064690, 1000821, 'JP', 'Yotsukaidō', 1, 'yotsukaido', 35.65000000, 140.16667000),
(1064691, 1000821, 'JP', 'Yotsukaidō-shi', 1, 'yotsukaido-shi', 35.67167000, 140.17912000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000865, 'JP', 'Ehime Prefecture', 1, 'ehime-prefecture');

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 
(1063529, 1000865, 'JP', 'Hōjō', 1, 'hojo', 33.97661000, 132.77767000),
(1063560, 1000865, 'JP', 'Imabari-shi', 1, 'imabari-shi', 34.06667000, 132.99791000),
(1063636, 1000865, 'JP', 'Iyo', 1, 'iyo', 33.75139000, 132.70139000),
(1063637, 1000865, 'JP', 'Iyo-shi', 1, 'iyo-shi', 33.68493000, 132.68909000),
(1063774, 1000865, 'JP', 'Kawanoechō', 1, 'kawanoecho', 34.01654000, 133.57844000),
(1063783, 1000865, 'JP', 'Kihoku-chō', 1, 'kihoku-cho', 33.25592000, 132.68343000),
(1063925, 1000865, 'JP', 'Masaki-chō', 1, 'masaki-cho', 33.78757000, 132.71124000),
(1063941, 1000865, 'JP', 'Matsuyama-shi', 1, 'matsuyama-shi', 33.83568000, 132.76224000),
(1064131, 1000865, 'JP', 'Niihama', 1, 'niihama', 33.96047000, 133.30522000),
(1064132, 1000865, 'JP', 'Niihama-shi', 1, 'niihama-shi', 33.90670000, 133.33250000),
(1064770, 1000865, 'JP', 'Ōzu', 1, 'ozu', 33.50000000, 132.55000000),
(1064771, 1000865, 'JP', 'Ōzu-shi', 1, 'ozu-shi', 33.50619000, 132.54430000),
(1064245, 1000865, 'JP', 'Saijō', 1, 'saijo', 33.91667000, 133.18333000),
(1064246, 1000865, 'JP', 'Saijō-shi', 1, 'saijo-shi', 33.86100000, 133.10832000),
(1064297, 1000865, 'JP', 'Seiyo-shi', 1, 'seiyo-shi', 33.39408000, 132.63262000),
(1064322, 1000865, 'JP', 'Shikoku-chūō Shi', 1, 'shikoku-chuo-shi', 33.93538000, 133.53622000),
(1064575, 1000865, 'JP', 'Tōon-shi', 1, 'toon-shi', 33.79099000, 132.87234000),
(1064613, 1000865, 'JP', 'Uwajima', 1, 'uwajima', 33.22375000, 132.56001000),
(1064614, 1000865, 'JP', 'Uwajima-shi', 1, 'uwajima-shi', 33.22325000, 132.56069000),
(1064667, 1000865, 'JP', 'Yawatahama-shi', 1, 'yawatahama-shi', 33.46302000, 132.42336000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000848, 'JP', 'Fukui Prefecture', 1, 'fukui-prefecture');

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 
(1063257, 1000848, 'JP', 'Asahi', 1, 'asahi', 35.97259000, 136.12455000),
(1063276, 1000848, 'JP', 'Awara-shi', 1, 'awara-shi', 36.22777000, 136.25154000),
(1063329, 1000848, 'JP', 'Echizen-shi', 1, 'echizen-shi', 35.88946000, 136.17723000),
(1063363, 1000848, 'JP', 'Fukui-shi', 1, 'fukui-shi', 36.06667000, 136.21667000),
(1063763, 1000848, 'JP', 'Katsuyama', 1, 'katsuyama', 36.06173000, 136.50101000),
(1063764, 1000848, 'JP', 'Katsuyama Shi', 1, 'katsuyama-shi', 36.08440000, 136.52178000),
(1063924, 1000848, 'JP', 'Maruoka', 1, 'maruoka', 36.15340000, 136.27029000),
(1063955, 1000848, 'JP', 'Mikuni', 1, 'mikuni', 36.21706000, 136.15185000),
(1064176, 1000848, 'JP', 'Obama', 1, 'obama', 35.49576000, 135.74604000),
(1064177, 1000848, 'JP', 'Obama-shi', 1, 'obama-shi', 35.45000000, 135.70000000),
(1064726, 1000848, 'JP', 'Ōi-gun', 1, 'oi-gun', 35.49238000, 135.49311000),
(1064209, 1000848, 'JP', 'Ono', 1, 'ono', 35.98106000, 136.48727000),
(1064748, 1000848, 'JP', 'Ōno-shi', 1, 'ono-shi', 35.90837000, 136.61696000),
(1064236, 1000848, 'JP', 'Sabae', 1, 'sabae', 35.94647000, 136.18498000),
(1064237, 1000848, 'JP', 'Sabae-shi', 1, 'sabae-shi', 35.95932000, 136.21835000),
(1064259, 1000848, 'JP', 'Sakai-shi', 1, 'sakai-shi', 36.16406000, 136.25544000),
(1064444, 1000848, 'JP', 'Takefu', 1, 'takefu', 35.90393000, 136.16687000),
(1064553, 1000848, 'JP', 'Tsuruga', 1, 'tsuruga', 35.64547000, 136.05580000),
(1064554, 1000848, 'JP', 'Tsuruga-shi', 1, 'tsuruga-shi', 35.63730000, 136.08068000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000861, 'JP', 'Fukuoka Prefecture', 1, 'fukuoka-prefecture');

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 
(1063239, 1000861, 'JP', 'Amagi', 1, 'amagi', 33.41804000, 130.65413000),
(1063263, 1000861, 'JP', 'Asakura Shi', 1, 'asakura-shi', 33.41684000, 130.74167000),
(1063290, 1000861, 'JP', 'Buzen', 1, 'buzen', 33.61153000, 131.13002000),
(1063291, 1000861, 'JP', 'Buzen-shi', 1, 'buzen-shi', 33.56743000, 131.08578000),
(1063298, 1000861, 'JP', 'Chikugo Shi', 1, 'chikugo-shi', 33.20748000, 130.49122000),
(1063302, 1000861, 'JP', 'Chikushino-shi', 1, 'chikushino-shi', 33.49631000, 130.51560000),
(1063325, 1000861, 'JP', 'Dazaifu-shi', 1, 'dazaifu-shi', 33.50000000, 130.53333000),
(1063365, 1000861, 'JP', 'Fukuoka', 1, 'fukuoka', 33.60000000, 130.41667000),
(1063366, 1000861, 'JP', 'Fukuoka-shi', 1, 'fukuoka-shi', 33.56894000, 130.35764000),
(1063372, 1000861, 'JP', 'Fukutsu Shi', 1, 'fukutsu-shi', 33.77982000, 130.49804000),
(1063551, 1000861, 'JP', 'Iizuka', 1, 'iizuka', 33.63654000, 130.68678000),
(1063552, 1000861, 'JP', 'Iizuka Shi', 1, 'iizuka-shi', 33.61353000, 130.66098000),
(1063614, 1000861, 'JP', 'Itoshima-shi', 1, 'itoshima-shi', 33.53317000, 130.17975000),
(1063676, 1000861, 'JP', 'Kama Shi', 1, 'kama-shi', 33.53663000, 130.74028000),
(1063708, 1000861, 'JP', 'Kanda', 1, 'kanda', 33.78333000, 130.98333000),
(1063744, 1000861, 'JP', 'Kasuga Shi', 1, 'kasuga-shi', 33.52404000, 130.45641000),
(1063776, 1000861, 'JP', 'Kawasaki', 1, 'kawasaki', 33.59993000, 130.81495000),
(1063808, 1000861, 'JP', 'Kitakyushu', 1, 'kitakyushu', 33.85181000, 130.85034000),
(1063823, 1000861, 'JP', 'Koga', 1, 'koga', 33.73333000, 130.46667000),
(1063825, 1000861, 'JP', 'Koga-shi', 1, 'koga-shi', 33.72139000, 130.49947000),
(1063879, 1000861, 'JP', 'Kurume', 1, 'kurume', 33.31667000, 130.51667000),
(1063880, 1000861, 'JP', 'Kurume Shi', 1, 'kurume-shi', 33.30358000, 130.56549000),
(1063907, 1000861, 'JP', 'Maebaru-chūō', 1, 'maebaru-chuo', 33.55916000, 130.20148000),
(1064005, 1000861, 'JP', 'Miyama Shi', 1, 'miyama-shi', 33.12369000, 130.49540000),
(1064007, 1000861, 'JP', 'Miyata', 1, 'miyata', 33.70811000, 130.65297000),
(1064008, 1000861, 'JP', 'Miyawaka Shi', 1, 'miyawaka-shi', 33.71559000, 130.61506000),
(1064044, 1000861, 'JP', 'Munakata-shi', 1, 'munakata-shi', 33.80000000, 130.55000000),
(1064084, 1000861, 'JP', 'Nakama', 1, 'nakama', 33.81688000, 130.70962000),
(1064085, 1000861, 'JP', 'Nakama Shi', 1, 'nakama-shi', 33.82081000, 130.70862000),
(1064147, 1000861, 'JP', 'Nishifukuma', 1, 'nishifukuma', 33.76627000, 130.47461000),
(1064174, 1000861, 'JP', 'Nōgata', 1, 'nogata', 33.74051000, 130.72263000),
(1064175, 1000861, 'JP', 'Nōgata Shi', 1, 'nogata-shi', 33.75116000, 130.74592000),
(1064189, 1000861, 'JP', 'Ogōri-shi', 1, 'ogori-shi', 33.38333000, 130.56667000),
(1064730, 1000861, 'JP', 'Ōkawa', 1, 'okawa', 33.20566000, 130.37527000),
(1064731, 1000861, 'JP', 'Ōkawa-shi', 1, 'okawa-shi', 33.20736000, 130.38253000),
(1064745, 1000861, 'JP', 'Ōmuta', 1, 'omuta', 33.03333000, 130.45000000),
(1064746, 1000861, 'JP', 'Ōmuta Shi', 1, 'omuta-shi', 33.04616000, 130.46912000),
(1064207, 1000861, 'JP', 'Onga-gun', 1, 'onga-gun', 33.85699000, 130.63626000),
(1064749, 1000861, 'JP', 'Ōnojō', 1, 'onojo', 33.53567000, 130.47861000),
(1064750, 1000861, 'JP', 'Ōnojō Shi', 1, 'onojo-shi', 33.51302000, 130.47925000),
(1064287, 1000861, 'JP', 'Sasaguri', 1, 'sasaguri', 33.61561000, 130.55105000),
(1064303, 1000861, 'JP', 'Setakamachi-takayanagi', 1, 'setakamachi-takayanagi', 33.14858000, 130.46548000),
(1064318, 1000861, 'JP', 'Shiida', 1, 'shiida', 33.65341000, 131.05797000),
(1064340, 1000861, 'JP', 'Shingū', 1, 'shingu', 33.71399000, 130.43130000),
(1064408, 1000861, 'JP', 'Tagawa', 1, 'tagawa', 33.63333000, 130.80000000),
(1064409, 1000861, 'JP', 'Tagawa Shi', 1, 'tagawa-shi', 33.63159000, 130.79966000),
(1064468, 1000861, 'JP', 'Tanushimarumachi-toyoki', 1, 'tanushimarumachi-toyoki', 33.35000000, 130.68333000),
(1064543, 1000861, 'JP', 'Tsuiki', 1, 'tsuiki', 33.67307000, 131.03776000),
(1064588, 1000861, 'JP', 'Ukiha Shi', 1, 'ukiha-shi', 33.31184000, 130.79325000),
(1064589, 1000861, 'JP', 'Umi', 1, 'umi', 33.56826000, 130.51009000),
(1064648, 1000861, 'JP', 'Yame Shi', 1, 'yame-shi', 33.23302000, 130.62775000),
(1064650, 1000861, 'JP', 'Yanagawa', 1, 'yanagawa', 33.16667000, 130.40000000),
(1064651, 1000861, 'JP', 'Yanagawa Shi', 1, 'yanagawa-shi', 33.14932000, 130.40725000),
(1064689, 1000861, 'JP', 'Yoshitomi', 1, 'yoshitomi', 33.60247000, 131.17599000),
(1064696, 1000861, 'JP', 'Yukuhashi', 1, 'yukuhashi', 33.72873000, 130.98300000),
(1064697, 1000861, 'JP', 'Yukuhashi Shi', 1, 'yukuhashi-shi', 33.71404000, 130.97108000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000847, 'JP', 'Fukushima Prefecture', 1, 'fukushima-prefecture');

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 
(1063224, 1000847, 'JP', 'Aizu-wakamatsu Shi', 1, 'aizu-wakamatsu-shi', 37.45071000, 139.96814000),
(1063323, 1000847, 'JP', 'Date-shi', 1, 'date-shi', 37.81667000, 140.51667000),
(1063370, 1000847, 'JP', 'Fukushima', 1, 'fukushima', 37.75000000, 140.46667000),
(1063371, 1000847, 'JP', 'Fukushima Shi', 1, 'fukushima-shi', 37.78643000, 140.38849000),
(1063377, 1000847, 'JP', 'Funehikimachi-funehiki', 1, 'funehikimachi-funehiki', 37.44722000, 140.57710000),
(1063513, 1000847, 'JP', 'Hobaramachi', 1, 'hobaramachi', 37.81667000, 140.55000000),
(1063572, 1000847, 'JP', 'Inawashiro', 1, 'inawashiro', 37.56667000, 140.11667000),
(1063597, 1000847, 'JP', 'Ishikawa', 1, 'ishikawa', 37.15000000, 140.45000000),
(1063621, 1000847, 'JP', 'Iwaki', 1, 'iwaki', 37.05000000, 140.88333000),
(1063622, 1000847, 'JP', 'Iwaki-shi', 1, 'iwaki-shi', 37.08333000, 140.83333000),
(1063806, 1000847, 'JP', 'Kitakata', 1, 'kitakata', 37.65000000, 139.86667000),
(1063807, 1000847, 'JP', 'Kitakata-shi', 1, 'kitakata-shi', 37.68333000, 139.90000000),
(1063899, 1000847, 'JP', 'Kōriyama', 1, 'koriyama', 37.40000000, 140.38333000),
(1063900, 1000847, 'JP', 'Kōriyama Shi', 1, 'koriyama-shi', 37.41277000, 140.29507000),
(1063950, 1000847, 'JP', 'Miharu', 1, 'miharu', 37.43333000, 140.48333000),
(1063962, 1000847, 'JP', 'Minami-Sōma', 1, 'minami-soma', 37.62908000, 140.97868000),
(1063971, 1000847, 'JP', 'Minamisōma Shi', 1, 'minamisoma-shi', 37.63108000, 140.92852000),
(1064039, 1000847, 'JP', 'Motomiya', 1, 'motomiya', 37.51391000, 140.40063000),
(1064040, 1000847, 'JP', 'Motomiya-shi', 1, 'motomiya-shi', 37.51218000, 140.39841000),
(1064097, 1000847, 'JP', 'Namie', 1, 'namie', 37.48333000, 141.00000000),
(1064127, 1000847, 'JP', 'Nihommatsu', 1, 'nihommatsu', 37.58333000, 140.43333000),
(1064128, 1000847, 'JP', 'Nihonmatsu Shi', 1, 'nihonmatsu-shi', 37.58402000, 140.49543000),
(1064353, 1000847, 'JP', 'Shirakawa Shi', 1, 'shirakawa-shi', 37.12225000, 140.24963000),
(1064402, 1000847, 'JP', 'Sōma', 1, 'soma', 37.79283000, 140.92941000),
(1064403, 1000847, 'JP', 'Sōma Shi', 1, 'soma-shi', 37.78193000, 140.87321000),
(1064381, 1000847, 'JP', 'Sukagawa', 1, 'sukagawa', 37.28333000, 140.38333000),
(1064382, 1000847, 'JP', 'Sukagawa Shi', 1, 'sukagawa-shi', 37.29342000, 140.31691000),
(1064461, 1000847, 'JP', 'Tamura', 1, 'tamura', 37.43055000, 140.60335000),
(1064462, 1000847, 'JP', 'Tamura-shi', 1, 'tamura-shi', 37.43793000, 140.57384000),
(1064652, 1000847, 'JP', 'Yanagawamachi-saiwaichō', 1, 'yanagawamachi-saiwaicho', 37.85000000, 140.60000000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000858, 'JP', 'Gifu Prefecture', 1, 'gifu-prefecture');

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 
(1063332, 1000858, 'JP', 'Ena-shi', 1, 'ena-shi', 35.44722000, 137.41810000),
(1063384, 1000858, 'JP', 'Gero', 1, 'gero', 35.80000000, 137.23333000),
(1063385, 1000858, 'JP', 'Gero-shi', 1, 'gero-shi', 35.75000000, 137.25000000),
(1063386, 1000858, 'JP', 'Gifu-shi', 1, 'gifu-shi', 35.44826000, 136.76470000),
(1063402, 1000858, 'JP', 'Gōdo', 1, 'godo', 35.41667000, 136.60000000),
(1063398, 1000858, 'JP', 'Gujō', 1, 'gujo', 35.73691000, 136.95852000),
(1063399, 1000858, 'JP', 'Gujō-shi', 1, 'gujo-shi', 35.83298000, 136.94561000),
(1063442, 1000858, 'JP', 'Hashima', 1, 'hashima', 35.32900000, 136.68051000),
(1063443, 1000858, 'JP', 'Hashima-shi', 1, 'hashima-shi', 35.30740000, 136.70161000),
(1063455, 1000858, 'JP', 'Hida', 1, 'hida', 36.24483000, 137.17323000),
(1063456, 1000858, 'JP', 'Hida Shi', 1, 'hida-shi', 36.33272000, 137.20568000),
(1063664, 1000858, 'JP', 'Kaizu-shi', 1, 'kaizu-shi', 35.21381000, 136.62443000),
(1063668, 1000858, 'JP', 'Kakamigahara-shi', 1, 'kakamigahara-shi', 35.40283000, 136.87829000),
(1063710, 1000858, 'JP', 'Kani-shi', 1, 'kani-shi', 35.40589000, 137.06602000),
(1063729, 1000858, 'JP', 'Kasamatsuchō', 1, 'kasamatsucho', 35.36667000, 136.76667000),
(1063977, 1000858, 'JP', 'Mino', 1, 'mino', 35.53333000, 136.91667000),
(1063978, 1000858, 'JP', 'Mino-shi', 1, 'mino-shi', 35.57892000, 136.90120000),
(1063979, 1000858, 'JP', 'Minokamo', 1, 'minokamo', 35.48199000, 137.02166000),
(1063980, 1000858, 'JP', 'Minokamo-shi', 1, 'minokamo-shi', 35.48386000, 137.02658000),
(1063989, 1000858, 'JP', 'Mitake', 1, 'mitake', 35.41667000, 137.13333000),
(1064018, 1000858, 'JP', 'Mizuho-shi', 1, 'mizuho-shi', 35.39663000, 136.67022000),
(1064019, 1000858, 'JP', 'Mizunami', 1, 'mizunami', 35.36667000, 137.25000000),
(1064020, 1000858, 'JP', 'Mizunami-shi', 1, 'mizunami-shi', 35.38935000, 137.27360000),
(1064041, 1000858, 'JP', 'Motosu-shi', 1, 'motosu-shi', 35.65553000, 136.61991000),
(1064091, 1000858, 'JP', 'Nakatsugawa', 1, 'nakatsugawa', 35.48333000, 137.50000000),
(1064092, 1000858, 'JP', 'Nakatsugawa-shi', 1, 'nakatsugawa-shi', 35.56656000, 137.47433000),
(1064723, 1000858, 'JP', 'Ōgaki-shi', 1, 'ogaki-shi', 35.36485000, 136.60189000),
(1064298, 1000858, 'JP', 'Seki-shi', 1, 'seki-shi', 35.48333000, 136.91667000),
(1064415, 1000858, 'JP', 'Tajimi', 1, 'tajimi', 35.31667000, 137.13333000),
(1064416, 1000858, 'JP', 'Tajimi-shi', 1, 'tajimi-shi', 35.33401000, 137.11258000),
(1064442, 1000858, 'JP', 'Takayama Shi', 1, 'takayama-shi', 36.13181000, 137.28585000),
(1064469, 1000858, 'JP', 'Tarui', 1, 'tarui', 35.36667000, 136.53333000),
(1064491, 1000858, 'JP', 'Toki', 1, 'toki', 35.35000000, 137.18333000),
(1064492, 1000858, 'JP', 'Toki-shi', 1, 'toki-shi', 35.32418000, 137.20748000),
(1064640, 1000858, 'JP', 'Yamagata-shi', 1, 'yamagata-shi', 35.59892000, 136.74311000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000862, 'JP', 'Gunma Prefecture', 1, 'gunma-prefecture');

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 
(1063217, 1000862, 'JP', 'Agatsuma-gun', 1, 'agatsuma-gun', 36.57368000, 138.67243000),
(1063247, 1000862, 'JP', 'Annaka', 1, 'annaka', 36.33011000, 138.89585000),
(1063248, 1000862, 'JP', 'Annaka Shi', 1, 'annaka-shi', 36.34079000, 138.77647000),
(1063350, 1000862, 'JP', 'Fujioka', 1, 'fujioka', 36.24624000, 139.07204000),
(1063351, 1000862, 'JP', 'Fujioka Shi', 1, 'fujioka-shi', 36.19213000, 138.99918000),
(1063588, 1000862, 'JP', 'Isesaki', 1, 'isesaki', 36.31667000, 139.20000000),
(1063589, 1000862, 'JP', 'Isesaki Shi', 1, 'isesaki-shi', 36.32126000, 139.21823000),
(1063709, 1000862, 'JP', 'Kanekomachi', 1, 'kanekomachi', 36.41097000, 138.99621000),
(1063790, 1000862, 'JP', 'Kiryū', 1, 'kiryu', 36.40000000, 139.33333000),
(1063791, 1000862, 'JP', 'Kiryū Shi', 1, 'kiryu-shi', 36.45702000, 139.30962000),
(1063908, 1000862, 'JP', 'Maebashi', 1, 'maebashi', 36.40000000, 139.08333000),
(1063909, 1000862, 'JP', 'Maebashi Shi', 1, 'maebashi-shi', 36.41432000, 139.13110000),
(1063946, 1000862, 'JP', 'Midori', 1, 'midori', 36.44492000, 139.28448000),
(1063947, 1000862, 'JP', 'Midori Shi', 1, 'midori-shi', 36.53044000, 139.34728000),
(1064088, 1000862, 'JP', 'Nakanojōmachi', 1, 'nakanojomachi', 36.58717000, 138.84083000),
(1064170, 1000862, 'JP', 'Numata', 1, 'numata', 36.63333000, 139.05000000),
(1064171, 1000862, 'JP', 'Numata Shi', 1, 'numata-shi', 36.67371000, 139.18353000),
(1064737, 1000862, 'JP', 'Ōmamachō-ōmama', 1, 'omamacho-omama', 36.43181000, 139.27534000),
(1064757, 1000862, 'JP', 'Ōta', 1, 'ota', 36.30000000, 139.36667000),
(1064759, 1000862, 'JP', 'Ōta-shi', 1, 'ota-shi', 36.30000000, 139.36667000),
(1064258, 1000862, 'JP', 'Sakai-nakajima', 1, 'sakai-nakajima', 36.26667000, 139.25000000),
(1064312, 1000862, 'JP', 'Shibukawa', 1, 'shibukawa', 36.48333000, 139.00000000),
(1064313, 1000862, 'JP', 'Shibukawa-shi', 1, 'shibukawa-shi', 36.50000000, 138.98333000),
(1064436, 1000862, 'JP', 'Takasaki', 1, 'takasaki', 36.33333000, 139.01667000),
(1064437, 1000862, 'JP', 'Takasaki Shi', 1, 'takasaki-shi', 36.40538000, 138.89227000),
(1064456, 1000862, 'JP', 'Tamamura', 1, 'tamamura', 36.30000000, 139.11667000),
(1064472, 1000862, 'JP', 'Tatebayashi', 1, 'tatebayashi', 36.25000000, 139.53333000),
(1064473, 1000862, 'JP', 'Tatebayashi-shi', 1, 'tatebayashi-shi', 36.24597000, 139.53533000),
(1064506, 1000862, 'JP', 'Tomioka', 1, 'tomioka', 36.25411000, 138.89813000),
(1064507, 1000862, 'JP', 'Tomioka-shi', 1, 'tomioka-shi', 36.25000000, 138.88333000),
(1064684, 1000862, 'JP', 'Yoshii', 1, 'yoshii', 36.25000000, 138.98333000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000828, 'JP', 'Hiroshima Prefecture', 1, 'hiroshima-prefecture');

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 
(1063230, 1000828, 'JP', 'Aki-takata Shi', 1, 'aki-takata-shi', 34.70248000, 132.67770000),
(1063335, 1000828, 'JP', 'Etajima-shi', 1, 'etajima-shi', 34.21989000, 132.44345000),
(1063337, 1000828, 'JP', 'Fuchū-shi', 1, 'fuchu-shi', 34.56667000, 133.23333000),
(1063338, 1000828, 'JP', 'Fuchūchō', 1, 'fuchucho', 34.57350000, 133.23513000),
(1063373, 1000828, 'JP', 'Fukuyama', 1, 'fukuyama', 34.48333000, 133.36667000),
(1063374, 1000828, 'JP', 'Fukuyama Shi', 1, 'fukuyama-shi', 34.52342000, 133.33779000),
(1063449, 1000828, 'JP', 'Hatsukaichi', 1, 'hatsukaichi', 34.35000000, 132.33333000),
(1063450, 1000828, 'JP', 'Hatsukaichi-shi', 1, 'hatsukaichi-shi', 34.35000000, 132.30000000),
(1063459, 1000828, 'JP', 'Higashihiroshima Shi', 1, 'higashihiroshima-shi', 34.44755000, 132.76116000),
(1063499, 1000828, 'JP', 'Hiroshima', 1, 'hiroshima', 34.40000000, 132.45000000),
(1063500, 1000828, 'JP', 'Hiroshima-shi', 1, 'hiroshima-shi', 34.47942000, 132.45312000),
(1063575, 1000828, 'JP', 'Innoshima', 1, 'innoshima', 34.28333000, 133.18333000),
(1063712, 1000828, 'JP', 'Kannabechō-yahiro', 1, 'kannabecho-yahiro', 34.55808000, 133.41796000),
(1063868, 1000828, 'JP', 'Kure', 1, 'kure', 34.23222000, 132.56658000),
(1063869, 1000828, 'JP', 'Kure-shi', 1, 'kure-shi', 34.22448000, 132.62914000),
(1063948, 1000828, 'JP', 'Mihara', 1, 'mihara', 34.40000000, 133.08333000),
(1063949, 1000828, 'JP', 'Mihara Shi', 1, 'mihara-shi', 34.45817000, 133.00395000),
(1063998, 1000828, 'JP', 'Miyajima', 1, 'miyajima', 34.29907000, 132.32186000),
(1064013, 1000828, 'JP', 'Miyoshi', 1, 'miyoshi', 34.80000000, 132.85000000),
(1064014, 1000828, 'JP', 'Miyoshi Shi', 1, 'miyoshi-shi', 34.79201000, 132.86435000),
(1064747, 1000828, 'JP', 'Ōno-hara', 1, 'ono-hara', 34.28333000, 132.26667000),
(1064212, 1000828, 'JP', 'Onomichi', 1, 'onomichi', 34.41667000, 133.20000000),
(1064213, 1000828, 'JP', 'Onomichi-shi', 1, 'onomichi-shi', 34.42630000, 133.16329000),
(1064760, 1000828, 'JP', 'Ōtake', 1, 'otake', 34.20754000, 132.22063000),
(1064761, 1000828, 'JP', 'Ōtake-shi', 1, 'otake-shi', 34.25787000, 132.18756000),
(1064347, 1000828, 'JP', 'Shin’ichi', 1, 'shin-ichi', 34.55543000, 133.27297000),
(1064368, 1000828, 'JP', 'Shōbara', 1, 'shobara', 34.85000000, 133.01667000),
(1064369, 1000828, 'JP', 'Shōbara-shi', 1, 'shobara-shi', 34.94831000, 133.06769000),
(1064445, 1000828, 'JP', 'Takehara', 1, 'takehara', 34.33833000, 132.91667000),
(1064446, 1000828, 'JP', 'Takehara-shi', 1, 'takehara-shi', 34.35000000, 132.90000000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000832, 'JP', 'Hokkaidō Prefecture', 1, 'hokkaido-prefecture');

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 
(1063211, 1000832, 'JP', 'Abashiri', 1, 'abashiri', 44.02127000, 144.26971000),
(1063212, 1000832, 'JP', 'Abashiri Shi', 1, 'abashiri-shi', 43.98565000, 144.21051000),
(1063225, 1000832, 'JP', 'Akabira', 1, 'akabira', 43.55139000, 142.05306000),
(1063226, 1000832, 'JP', 'Akabira-shi', 1, 'akabira-shi', 43.56790000, 142.06281000),
(1063259, 1000832, 'JP', 'Asahikawa', 1, 'asahikawa', 43.77063000, 142.36489000),
(1063264, 1000832, 'JP', 'Ashibetsu', 1, 'ashibetsu', 43.50972000, 142.18556000),
(1063265, 1000832, 'JP', 'Ashibetsu-shi', 1, 'ashibetsu-shi', 43.42542000, 142.20161000),
(1063285, 1000832, 'JP', 'Bibai', 1, 'bibai', 43.32472000, 141.85861000),
(1063309, 1000832, 'JP', 'Chitose', 1, 'chitose', 42.81944000, 141.65222000),
(1063310, 1000832, 'JP', 'Chitose Shi', 1, 'chitose-shi', 42.80048000, 141.50951000),
(1063322, 1000832, 'JP', 'Date', 1, 'date', 42.46806000, 140.86806000),
(1063324, 1000832, 'JP', 'Date-shi', 1, 'date-shi', 42.49337000, 140.89142000),
(1063326, 1000832, 'JP', 'Ebetsu', 1, 'ebetsu', 43.10806000, 141.55056000),
(1063333, 1000832, 'JP', 'Eniwa-shi', 1, 'eniwa-shi', 42.88333000, 141.56667000),
(1063356, 1000832, 'JP', 'Fukagawa', 1, 'fukagawa', 43.70806000, 142.03917000),
(1063357, 1000832, 'JP', 'Fukagawa-shi', 1, 'fukagawa-shi', 43.79334000, 142.09923000),
(1063378, 1000832, 'JP', 'Furano-shi', 1, 'furano-shi', 43.28182000, 142.47349000),
(1063416, 1000832, 'JP', 'Hakodate', 1, 'hakodate', 41.77583000, 140.73667000),
(1063417, 1000832, 'JP', 'Hakodate Shi', 1, 'hakodate-shi', 41.83754000, 140.92597000),
(1063516, 1000832, 'JP', 'Hokuto', 1, 'hokuto', 41.81626000, 140.63472000),
(1063519, 1000832, 'JP', 'Hokuto-shi', 1, 'hokuto-shi', 41.86411000, 140.55424000),
(1063521, 1000832, 'JP', 'Honchō', 1, 'honcho', 41.89440000, 140.69386000),
(1063594, 1000832, 'JP', 'Ishikari', 1, 'ishikari', 43.23972000, 141.35389000),
(1063595, 1000832, 'JP', 'Ishikari-shi', 1, 'ishikari-shi', 43.46596000, 141.44298000),
(1063626, 1000832, 'JP', 'Iwamizawa', 1, 'iwamizawa', 43.20028000, 141.75972000),
(1063627, 1000832, 'JP', 'Iwamizawa-shi', 1, 'iwamizawa-shi', 43.18086000, 141.79744000),
(1063628, 1000832, 'JP', 'Iwanai', 1, 'iwanai', 42.97444000, 140.50889000),
(1063691, 1000832, 'JP', 'Kamiiso', 1, 'kamiiso', 41.82013000, 140.64482000),
(1063692, 1000832, 'JP', 'Kamikawa', 1, 'kamikawa', 43.84000000, 142.77111000),
(1063800, 1000832, 'JP', 'Kitahiroshima', 1, 'kitahiroshima', 42.97583000, 141.56722000),
(1063801, 1000832, 'JP', 'Kitahiroshima-shi', 1, 'kitahiroshima-shi', 42.98581000, 141.55678000),
(1063809, 1000832, 'JP', 'Kitami', 1, 'kitami', 43.80306000, 143.89083000),
(1063851, 1000832, 'JP', 'Ktiami Shi', 1, 'ktiami-shi', 43.85160000, 143.71520000),
(1063886, 1000832, 'JP', 'Kushiro', 1, 'kushiro', 42.97500000, 144.37472000),
(1063887, 1000832, 'JP', 'Kushiro Shi', 1, 'kushiro-shi', 43.15910000, 144.06647000),
(1063917, 1000832, 'JP', 'Makubetsu', 1, 'makubetsu', 45.37139000, 141.82111000),
(1063951, 1000832, 'JP', 'Mikasa', 1, 'mikasa', 43.25581000, 141.88818000),
(1063952, 1000832, 'JP', 'Mikasa-shi', 1, 'mikasa-shi', 43.23976000, 141.99273000),
(1064024, 1000832, 'JP', 'Mombetsu', 1, 'mombetsu', 44.35250000, 143.35250000),
(1064025, 1000832, 'JP', 'Monbetsu Shi', 1, 'monbetsu-shi', 44.20323000, 143.29293000),
(1064038, 1000832, 'JP', 'Motomachi', 1, 'motomachi', 43.82634000, 144.09638000),
(1064049, 1000832, 'JP', 'Muroran', 1, 'muroran', 42.31722000, 140.98806000),
(1064050, 1000832, 'JP', 'Muroran-shi', 1, 'muroran-shi', 42.36659000, 140.98845000),
(1064117, 1000832, 'JP', 'Nayoro', 1, 'nayoro', 44.35056000, 142.45778000),
(1064118, 1000832, 'JP', 'Nayoro Shi', 1, 'nayoro-shi', 44.33951000, 142.45932000),
(1064120, 1000832, 'JP', 'Nemuro', 1, 'nemuro', 43.32361000, 145.57500000),
(1064121, 1000832, 'JP', 'Nemuro-shi', 1, 'nemuro-shi', 43.33333000, 145.61667000),
(1064145, 1000832, 'JP', 'Niseko Town', 1, 'niseko-town', 42.77871000, 140.66903000),
(1064161, 1000832, 'JP', 'Noboribetsu', 1, 'noboribetsu', 42.45215000, 141.17914000),
(1064162, 1000832, 'JP', 'Noboribetsu-shi', 1, 'noboribetsu-shi', 42.46565000, 141.07578000),
(1064180, 1000832, 'JP', 'Obihiro', 1, 'obihiro', 42.91722000, 143.20444000),
(1064181, 1000832, 'JP', 'Obihiro Shi', 1, 'obihiro-shi', 42.75736000, 143.03061000),
(1064215, 1000832, 'JP', 'Otaru', 1, 'otaru', 43.18944000, 141.00222000),
(1064216, 1000832, 'JP', 'Otaru-shi', 1, 'otaru-shi', 43.15628000, 141.02572000),
(1064217, 1000832, 'JP', 'Otofuke', 1, 'otofuke', 42.99167000, 143.20028000),
(1064224, 1000832, 'JP', 'Rebun Gun', 1, 'rebun-gun', 45.38263000, 141.02839000),
(1064227, 1000832, 'JP', 'Rishiri Gun', 1, 'rishiri-gun', 45.18244000, 141.22859000),
(1064228, 1000832, 'JP', 'Rishiri Town', 1, 'rishiri-town', 45.15928000, 141.19629000),
(1064230, 1000832, 'JP', 'Rumoi', 1, 'rumoi', 43.93444000, 141.64278000),
(1064231, 1000832, 'JP', 'Rumoi-shi', 1, 'rumoi-shi', 43.88560000, 141.75567000),
(1064285, 1000832, 'JP', 'Sapporo', 1, 'sapporo', 43.06667000, 141.35000000),
(1064286, 1000832, 'JP', 'Sapporo-shi', 1, 'sapporo-shi', 43.06667000, 141.35000000),
(1064310, 1000832, 'JP', 'Shibetsu', 1, 'shibetsu', 43.65899000, 145.13197000),
(1064311, 1000832, 'JP', 'Shibetsu Shi', 1, 'shibetsu-shi', 44.11522000, 142.54054000),
(1064329, 1000832, 'JP', 'Shimo-furano', 1, 'shimo-furano', 43.35000000, 142.38333000),
(1064354, 1000832, 'JP', 'Shiraoi', 1, 'shiraoi', 42.55000000, 141.35000000),
(1064365, 1000832, 'JP', 'Shizunai-furukawachō', 1, 'shizunai-furukawacho', 42.33389000, 142.36694000),
(1064386, 1000832, 'JP', 'Sunagawa', 1, 'sunagawa', 43.48639000, 141.90556000),
(1064387, 1000832, 'JP', 'Sunagawa-shi', 1, 'sunagawa-shi', 43.50328000, 141.93274000),
(1064451, 1000832, 'JP', 'Takikawa', 1, 'takikawa', 43.55278000, 141.90639000),
(1064452, 1000832, 'JP', 'Takikawa-shi', 1, 'takikawa-shi', 43.60837000, 141.94988000),
(1064565, 1000832, 'JP', 'Tōbetsu', 1, 'tobetsu', 43.21694000, 141.51694000),
(1064501, 1000832, 'JP', 'Tomakomai', 1, 'tomakomai', 42.63694000, 141.60333000),
(1064502, 1000832, 'JP', 'Tomakomai Shi', 1, 'tomakomai-shi', 42.68226000, 141.57948000),
(1064607, 1000832, 'JP', 'Utashinai', 1, 'utashinai', 43.51667000, 142.05000000),
(1064608, 1000832, 'JP', 'Utashinai-shi', 1, 'utashinai-shi', 43.49366000, 142.03878000),
(1064619, 1000832, 'JP', 'Wakkanai', 1, 'wakkanai', 45.40944000, 141.67389000),
(1064620, 1000832, 'JP', 'Wakkanai Shi', 1, 'wakkanai-shi', 45.33243000, 141.82831000),
(1064668, 1000832, 'JP', 'Yoichi', 1, 'yoichi', 43.20389000, 140.77028000),
(1064704, 1000832, 'JP', 'Yūbari', 1, 'yubari', 43.03778000, 141.95778000),
(1064705, 1000832, 'JP', 'Yūbari-shi', 1, 'yubari-shi', 43.04336000, 142.11065000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000831, 'JP', 'Hyōgo Prefecture', 1, 'hyogo-prefecture');

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 
(1063220, 1000831, 'JP', 'Aioi', 1, 'aioi', 34.80361000, 134.46806000),
(1063221, 1000831, 'JP', 'Aioi Shi', 1, 'aioi-shi', 34.82719000, 134.46699000),
(1063228, 1000831, 'JP', 'Akashi', 1, 'akashi', 34.65524000, 135.00687000),
(1063229, 1000831, 'JP', 'Akashi Shi', 1, 'akashi-shi', 34.68277000, 134.94029000),
(1063238, 1000831, 'JP', 'Amagasaki Shi', 1, 'amagasaki-shi', 34.73544000, 135.41181000),
(1063256, 1000831, 'JP', 'Asago-shi', 1, 'asago-shi', 35.26249000, 134.82527000),
(1063267, 1000831, 'JP', 'Ashiya', 1, 'ashiya', 34.72807000, 135.30264000),
(1063268, 1000831, 'JP', 'Ashiya Shi', 1, 'ashiya-shi', 34.74853000, 135.29759000),
(1063275, 1000831, 'JP', 'Awaji Shi', 1, 'awaji-shi', 34.49749000, 134.91331000),
(1063367, 1000831, 'JP', 'Fukura', 1, 'fukura', 34.25765000, 134.71535000),
(1063478, 1000831, 'JP', 'Himeji', 1, 'himeji', 34.81667000, 134.70000000),
(1063479, 1000831, 'JP', 'Himeji Shi', 1, 'himeji-shi', 34.90134000, 134.66316000),
(1063608, 1000831, 'JP', 'Itami', 1, 'itami', 34.78427000, 135.40126000),
(1063609, 1000831, 'JP', 'Itami Shi', 1, 'itami-shi', 34.78675000, 135.40562000),
(1063671, 1000831, 'JP', 'Kakogawa Shi', 1, 'kakogawa-shi', 34.78472000, 134.84897000),
(1063672, 1000831, 'JP', 'Kakogawachō-honmachi', 1, 'kakogawacho-honmachi', 34.76943000, 134.82905000),
(1063724, 1000831, 'JP', 'Kariya', 1, 'kariya', 34.75136000, 134.38734000),
(1063726, 1000831, 'JP', 'Kasai Shi', 1, 'kasai-shi', 34.92476000, 134.85359000),
(1063765, 1000831, 'JP', 'Katō Shi', 1, 'kato-shi', 34.92714000, 135.02134000),
(1063772, 1000831, 'JP', 'Kawanishi', 1, 'kawanishi', 34.81667000, 135.41667000),
(1063773, 1000831, 'JP', 'Kawanishi Shi', 1, 'kawanishi-shi', 34.87955000, 135.40919000),
(1063820, 1000831, 'JP', 'Kobe', 1, 'kobe', 34.69130000, 135.18300000),
(1063953, 1000831, 'JP', 'Miki', 1, 'miki', 34.80000000, 134.98333000),
(1063954, 1000831, 'JP', 'Miki Shi', 1, 'miki-shi', 34.83553000, 135.05822000),
(1063965, 1000831, 'JP', 'Minamiawaji Shi', 1, 'minamiawaji-shi', 34.27530000, 134.76465000),
(1064148, 1000831, 'JP', 'Nishinomiya Shi', 1, 'nishinomiya-shi', 34.78194000, 135.30247000),
(1064149, 1000831, 'JP', 'Nishinomiya-hama', 1, 'nishinomiya-hama', 34.71562000, 135.33199000),
(1064156, 1000831, 'JP', 'Nishiwaki', 1, 'nishiwaki', 34.98419000, 134.97407000),
(1064157, 1000831, 'JP', 'Nishiwaki-shi', 1, 'nishiwaki-shi', 35.01098000, 134.99650000),
(1064208, 1000831, 'JP', 'Ono', 1, 'ono', 34.85000000, 134.93333000),
(1064210, 1000831, 'JP', 'Ono Shi', 1, 'ono-shi', 34.85750000, 134.95129000),
(1064276, 1000831, 'JP', 'Sanda Shi', 1, 'sanda-shi', 34.95506000, 135.21660000),
(1064277, 1000831, 'JP', 'Sandachō', 1, 'sandacho', 34.88444000, 135.22694000),
(1064288, 1000831, 'JP', 'Sasayama', 1, 'sasayama', 35.06667000, 135.21667000),
(1064289, 1000831, 'JP', 'Sasayama-shi', 1, 'sasayama-shi', 35.07523000, 135.23087000),
(1064352, 1000831, 'JP', 'Shirahamachō-usazakiminami', 1, 'shirahamacho-usazakiminami', 34.78333000, 134.71667000),
(1064363, 1000831, 'JP', 'Shisō-shi', 1, 'shiso-shi', 35.15466000, 134.54337000),
(1064384, 1000831, 'JP', 'Sumoto', 1, 'sumoto', 34.34322000, 134.88911000),
(1064385, 1000831, 'JP', 'Sumoto Shi', 1, 'sumoto-shi', 34.34533000, 134.85858000),
(1064418, 1000831, 'JP', 'Taka-gun', 1, 'taka-gun', 35.08473000, 134.90474000),
(1064433, 1000831, 'JP', 'Takarazuka', 1, 'takarazuka', 34.79936000, 135.35697000),
(1064434, 1000831, 'JP', 'Takarazuka Shi', 1, 'takarazuka-shi', 34.86008000, 135.33197000),
(1064435, 1000831, 'JP', 'Takasago Shi', 1, 'takasago-shi', 34.77796000, 134.78665000),
(1064466, 1000831, 'JP', 'Tanba-shi', 1, 'tanba-shi', 35.17715000, 135.04972000),
(1064477, 1000831, 'JP', 'Tatsuno-shi', 1, 'tatsuno-shi', 34.88804000, 134.51910000),
(1064478, 1000831, 'JP', 'Tatsunochō-tominaga', 1, 'tatsunocho-tominaga', 34.86437000, 134.55200000),
(1064531, 1000831, 'JP', 'Toyooka', 1, 'toyooka', 35.54008000, 134.82038000),
(1064532, 1000831, 'JP', 'Toyooka-shi', 1, 'toyooka-shi', 35.51384000, 134.82724000),
(1064627, 1000831, 'JP', 'Yabu', 1, 'yabu', 35.40304000, 134.77118000),
(1064628, 1000831, 'JP', 'Yabu-shi', 1, 'yabu-shi', 35.38333000, 134.81667000),
(1064647, 1000831, 'JP', 'Yamazakichō-nakabirose', 1, 'yamazakicho-nakabirose', 35.00000000, 134.55000000),
(1064658, 1000831, 'JP', 'Yashiro', 1, 'yashiro', 34.91667000, 134.96667000),
(1064678, 1000831, 'JP', 'Yonedacho Sendo', 1, 'yonedacho-sendo', 34.77560000, 134.82551000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000851, 'JP', 'Ibaraki Prefecture', 1, 'ibaraki-prefecture');

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 
(1063244, 1000851, 'JP', 'Ami', 1, 'ami', 36.03333000, 140.20000000),
(1063281, 1000851, 'JP', 'Bandō', 1, 'bando', 36.06997000, 139.86705000),
(1063282, 1000851, 'JP', 'Bandō-shi', 1, 'bando-shi', 36.06384000, 139.88787000),
(1063300, 1000851, 'JP', 'Chikusei', 1, 'chikusei', 36.31600000, 139.98238000),
(1063301, 1000851, 'JP', 'Chikusei-shi', 1, 'chikusei-shi', 36.28938000, 139.98692000),
(1063317, 1000851, 'JP', 'Daigo', 1, 'daigo', 36.76667000, 140.35000000),
(1063331, 1000851, 'JP', 'Edosaki', 1, 'edosaki', 35.95000000, 140.31667000),
(1063354, 1000851, 'JP', 'Fujishiro', 1, 'fujishiro', 35.91667000, 140.11667000),
(1063376, 1000851, 'JP', 'Funaishikawa', 1, 'funaishikawa', 36.46667000, 140.56667000),
(1063504, 1000851, 'JP', 'Hitachi', 1, 'hitachi', 36.60000000, 140.65000000),
(1063505, 1000851, 'JP', 'Hitachi-Naka', 1, 'hitachi-naka', 36.39659000, 140.53479000),
(1063506, 1000851, 'JP', 'Hitachi-ota', 1, 'hitachi-ota', 36.55130000, 140.52821000),
(1063507, 1000851, 'JP', 'Hitachi-shi', 1, 'hitachi-shi', 36.62492000, 140.61876000),
(1063508, 1000851, 'JP', 'Hitachinaka-shi', 1, 'hitachinaka-shi', 36.39596000, 140.55789000),
(1063509, 1000851, 'JP', 'Hitachiōmiya-shi', 1, 'hitachiomiya-shi', 36.61371000, 140.33990000),
(1063510, 1000851, 'JP', 'Hitachiōta-shi', 1, 'hitachiota-shi', 36.64836000, 140.50536000),
(1063515, 1000851, 'JP', 'Hokota-shi', 1, 'hokota-shi', 36.17337000, 140.51993000),
(1063570, 1000851, 'JP', 'Inashiki', 1, 'inashiki', 35.95633000, 140.32356000),
(1063571, 1000851, 'JP', 'Inashiki-shi', 1, 'inashiki-shi', 35.94563000, 140.36889000),
(1063592, 1000851, 'JP', 'Ishige', 1, 'ishige', 36.11667000, 139.96667000),
(1063601, 1000851, 'JP', 'Ishioka', 1, 'ishioka', 36.18333000, 140.26667000),
(1063602, 1000851, 'JP', 'Ishioka-shi', 1, 'ishioka-shi', 36.22776000, 140.21786000),
(1063606, 1000851, 'JP', 'Itako', 1, 'itako', 35.93333000, 140.55000000),
(1063607, 1000851, 'JP', 'Itako-shi', 1, 'itako-shi', 35.96100000, 140.56210000),
(1063620, 1000851, 'JP', 'Iwai', 1, 'iwai', 36.05000000, 139.90000000),
(1063631, 1000851, 'JP', 'Iwase', 1, 'iwase', 36.35000000, 140.10000000),
(1063653, 1000851, 'JP', 'Jōsō-shi', 1, 'joso-shi', 36.06409000, 139.96397000),
(1063698, 1000851, 'JP', 'Kamisu-shi', 1, 'kamisu-shi', 35.85126000, 140.71171000),
(1063727, 1000851, 'JP', 'Kasama', 1, 'kasama', 36.38333000, 140.26667000),
(1063728, 1000851, 'JP', 'Kasama-shi', 1, 'kasama-shi', 36.35651000, 140.26935000),
(1063738, 1000851, 'JP', 'Kashima-shi', 1, 'kashima-shi', 35.96536000, 140.64474000),
(1063749, 1000851, 'JP', 'Kasumigaura', 1, 'kasumigaura', 36.15326000, 140.24635000),
(1063750, 1000851, 'JP', 'Kasumigaura-shi', 1, 'kasumigaura-shi', 36.10937000, 140.30205000),
(1063759, 1000851, 'JP', 'Katsuta', 1, 'katsuta', 36.38333000, 140.53333000),
(1063802, 1000851, 'JP', 'Kitaibaraki', 1, 'kitaibaraki', 36.78671000, 140.74901000),
(1063803, 1000851, 'JP', 'Kitaibaraki-shi', 1, 'kitaibaraki-shi', 36.83987000, 140.68736000),
(1063824, 1000851, 'JP', 'Koga', 1, 'koga', 36.18333000, 139.71667000),
(1063826, 1000851, 'JP', 'Koga-shi', 1, 'koga-shi', 36.17975000, 139.77534000),
(1063914, 1000851, 'JP', 'Makabe', 1, 'makabe', 36.26667000, 140.10000000),
(1063990, 1000851, 'JP', 'Mito', 1, 'mito', 36.35000000, 140.45000000),
(1063991, 1000851, 'JP', 'Mito-shi', 1, 'mito-shi', 36.37053000, 140.43559000),
(1063993, 1000851, 'JP', 'Mitsukaidō', 1, 'mitsukaido', 36.01667000, 139.98333000),
(1064032, 1000851, 'JP', 'Moriya', 1, 'moriya', 35.93333000, 140.00000000),
(1064033, 1000851, 'JP', 'Moriya-shi', 1, 'moriya-shi', 35.95140000, 139.97539000),
(1064081, 1000851, 'JP', 'Naka', 1, 'naka', 36.05000000, 140.16667000),
(1064082, 1000851, 'JP', 'Naka-gun', 1, 'naka-gun', 36.46934000, 140.47943000),
(1064093, 1000851, 'JP', 'Namegata', 1, 'namegata', 36.00705000, 140.49623000),
(1064094, 1000851, 'JP', 'Namegata-shi', 1, 'namegata-shi', 36.06526000, 140.47173000),
(1064714, 1000851, 'JP', 'Ōarai', 1, 'oarai', 36.31409000, 140.58389000),
(1064202, 1000851, 'JP', 'Okunoya', 1, 'okunoya', 36.28333000, 140.41667000),
(1064205, 1000851, 'JP', 'Omitama-shi', 1, 'omitama-shi', 36.20403000, 140.35980000),
(1064742, 1000851, 'JP', 'Ōmiya', 1, 'omiya', 36.55000000, 140.41667000),
(1064233, 1000851, 'JP', 'Ryūgasaki', 1, 'ryugasaki', 35.90000000, 140.18333000),
(1064234, 1000851, 'JP', 'Ryūgasaki-shi', 1, 'ryugasaki-shi', 35.92249000, 140.18527000),
(1064255, 1000851, 'JP', 'Sakai', 1, 'sakai', 36.10000000, 139.80000000),
(1064271, 1000851, 'JP', 'Sakuragawa', 1, 'sakuragawa', 36.25052000, 140.11565000),
(1064272, 1000851, 'JP', 'Sakuragawa-shi', 1, 'sakuragawa-shi', 36.32746000, 140.10792000),
(1064332, 1000851, 'JP', 'Shimodate', 1, 'shimodate', 36.30000000, 139.98333000),
(1064337, 1000851, 'JP', 'Shimotsuma-shi', 1, 'shimotsuma-shi', 36.18743000, 139.96642000),
(1064419, 1000851, 'JP', 'Takahagi', 1, 'takahagi', 36.71667000, 140.71667000),
(1064510, 1000851, 'JP', 'Tomobe', 1, 'tomobe', 36.35000000, 140.30000000),
(1064515, 1000851, 'JP', 'Toride', 1, 'toride', 35.90000000, 140.08333000),
(1064516, 1000851, 'JP', 'Toride-shi', 1, 'toride-shi', 35.91286000, 140.08009000),
(1064540, 1000851, 'JP', 'Tsuchiura-shi', 1, 'tsuchiura-shi', 36.08333000, 140.20000000),
(1064545, 1000851, 'JP', 'Tsukuba', 1, 'tsukuba', 36.20000000, 140.10000000),
(1064546, 1000851, 'JP', 'Tsukuba-shi', 1, 'tsukuba-shi', 36.10532000, 140.08174000),
(1064547, 1000851, 'JP', 'Tsukubamirai', 1, 'tsukubamirai', 35.98411000, 140.00929000),
(1064548, 1000851, 'JP', 'Tsukubamirai-shi', 1, 'tsukubamirai-shi', 35.98201000, 140.03812000),
(1064603, 1000851, 'JP', 'Ushiku', 1, 'ushiku', 35.96667000, 140.13333000),
(1064604, 1000851, 'JP', 'Ushiku-shi', 1, 'ushiku-shi', 35.97175000, 140.18578000),
(1064706, 1000851, 'JP', 'Yūki', 1, 'yuki', 36.30000000, 139.88333000),
(1064707, 1000851, 'JP', 'Yūki-shi', 1, 'yuki-shi', 36.26127000, 139.86403000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000830, 'JP', 'Ishikawa Prefecture', 1, 'ishikawa-prefecture');

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 
(1063420, 1000830, 'JP', 'Hakui', 1, 'hakui', 36.88333000, 136.78333000),
(1063421, 1000830, 'JP', 'Hakui Shi', 1, 'hakui-shi', 36.91136000, 136.81626000),
(1063422, 1000830, 'JP', 'Hakusan Shi', 1, 'hakusan-shi', 36.27558000, 136.66966000),
(1063657, 1000830, 'JP', 'Kaga Shi', 1, 'kaga-shi', 36.25503000, 136.37963000),
(1063660, 1000830, 'JP', 'Kahoku Shi', 1, 'kahoku-shi', 36.74365000, 136.73273000),
(1063706, 1000830, 'JP', 'Kanazawa', 1, 'kanazawa', 36.60000000, 136.61667000),
(1063707, 1000830, 'JP', 'Kanazawa-shi', 1, 'kanazawa-shi', 36.51919000, 136.70836000),
(1063837, 1000830, 'JP', 'Komatsu', 1, 'komatsu', 36.40263000, 136.45088000),
(1063938, 1000830, 'JP', 'Matsutō', 1, 'matsuto', 36.51667000, 136.56667000),
(1064099, 1000830, 'JP', 'Nanao Shi', 1, 'nanao-shi', 37.07844000, 136.92860000),
(1064165, 1000830, 'JP', 'Nomi Shi', 1, 'nomi-shi', 36.43593000, 136.54456000),
(1064166, 1000830, 'JP', 'Nonoichi', 1, 'nonoichi', 36.53333000, 136.61667000),
(1064167, 1000830, 'JP', 'Nonoichi-shi', 1, 'nonoichi-shi', 36.52288000, 136.60589000),
(1064394, 1000830, 'JP', 'Suzu', 1, 'suzu', 37.43459000, 137.26009000),
(1064395, 1000830, 'JP', 'Suzu Shi', 1, 'suzu-shi', 37.45533000, 137.22587000),
(1064539, 1000830, 'JP', 'Tsubata', 1, 'tsubata', 36.67012000, 136.74030000),
(1064556, 1000830, 'JP', 'Tsurugi-asahimachi', 1, 'tsurugi-asahimachi', 36.45000000, 136.63333000),
(1064615, 1000830, 'JP', 'Wajima Shi', 1, 'wajima-shi', 37.33753000, 136.88757000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000856, 'JP', 'Iwate Prefecture', 1, 'iwate-prefecture');

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 
(1063406, 1000856, 'JP', 'Hachimantai', 1, 'hachimantai', 39.89979000, 141.12989000),
(1063407, 1000856, 'JP', 'Hachimantai Shi', 1, 'hachimantai-shi', 40.02390000, 140.99113000),
(1063430, 1000856, 'JP', 'Hanamaki', 1, 'hanamaki', 39.38333000, 141.11667000),
(1063431, 1000856, 'JP', 'Hanamaki Shi', 1, 'hanamaki-shi', 39.44187000, 141.16751000),
(1063541, 1000856, 'JP', 'Ichinohe', 1, 'ichinohe', 40.21965000, 141.28986000),
(1063544, 1000856, 'JP', 'Ichinoseki', 1, 'ichinoseki', 38.91667000, 141.13333000),
(1063545, 1000856, 'JP', 'Ichinoseki-shi', 1, 'ichinoseki-shi', 38.91667000, 141.13333000),
(1063634, 1000856, 'JP', 'Iwate-gun', 1, 'iwate-gun', 39.97238000, 141.22719000),
(1063678, 1000856, 'JP', 'Kamaishi', 1, 'kamaishi', 39.27694000, 141.86801000),
(1063679, 1000856, 'JP', 'Kamaishi-shi', 1, 'kamaishi-shi', 39.28748000, 141.79854000),
(1063804, 1000856, 'JP', 'Kitakami', 1, 'kitakami', 39.28333000, 141.11667000),
(1063805, 1000856, 'JP', 'Kitakami-shi', 1, 'kitakami-shi', 39.30765000, 141.00795000),
(1063854, 1000856, 'JP', 'Kuji', 1, 'kuji', 40.18778000, 141.76889000),
(1063855, 1000856, 'JP', 'Kuji-shi', 1, 'kuji-shi', 40.14364000, 141.65918000),
(1064000, 1000856, 'JP', 'Miyako', 1, 'miyako', 39.64691000, 141.94057000),
(1064001, 1000856, 'JP', 'Miyako-shi', 1, 'miyako-shi', 39.65724000, 141.85144000),
(1064021, 1000856, 'JP', 'Mizusawa', 1, 'mizusawa', 39.13333000, 141.13333000),
(1064030, 1000856, 'JP', 'Morioka', 1, 'morioka', 39.70000000, 141.15000000),
(1064031, 1000856, 'JP', 'Morioka-shi', 1, 'morioka-shi', 39.74546000, 141.26915000),
(1064140, 1000856, 'JP', 'Ninohe', 1, 'ninohe', 40.29081000, 141.31334000),
(1064141, 1000856, 'JP', 'Ninohe Shi', 1, 'ninohe-shi', 40.23798000, 141.19576000),
(1064721, 1000856, 'JP', 'Ōfunato', 1, 'ofunato', 39.07167000, 141.71667000),
(1064722, 1000856, 'JP', 'Ōfunato-shi', 1, 'ofunato-shi', 39.06667000, 141.71667000),
(1064755, 1000856, 'JP', 'Ōshū', 1, 'oshu', 39.13927000, 141.16850000),
(1064756, 1000856, 'JP', 'Ōshū-shi', 1, 'oshu-shi', 39.12962000, 141.09479000),
(1064765, 1000856, 'JP', 'Ōtsuchi', 1, 'otsuchi', 39.36667000, 141.90000000),
(1064226, 1000856, 'JP', 'Rikuzentakata-shi', 1, 'rikuzentakata-shi', 39.04082000, 141.57703000),
(1064364, 1000856, 'JP', 'Shizukuishi', 1, 'shizukuishi', 39.69414000, 140.98442000),
(1064453, 1000856, 'JP', 'Takizawa-shi', 1, 'takizawa-shi', 39.80000000, 141.06667000),
(1064573, 1000856, 'JP', 'Tōno', 1, 'tono', 39.31667000, 141.53333000),
(1064574, 1000856, 'JP', 'Tōno-shi', 1, 'tono-shi', 39.36479000, 141.50922000),
(1064636, 1000856, 'JP', 'Yamada', 1, 'yamada', 39.46667000, 141.95000000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000864, 'JP', 'Kagawa Prefecture', 1, 'kagawa-prefecture');

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 
(1063460, 1000864, 'JP', 'Higashikagawa Shi', 1, 'higashikagawa-shi', 34.21158000, 134.33350000),
(1063718, 1000864, 'JP', 'Kan’onji Shi', 1, 'kan-onji-shi', 34.08457000, 133.67448000),
(1063719, 1000864, 'JP', 'Kan’onjichō', 1, 'kan-onjicho', 34.12760000, 133.64598000),
(1063921, 1000864, 'JP', 'Marugame', 1, 'marugame', 34.28333000, 133.78333000),
(1063922, 1000864, 'JP', 'Marugame Shi', 1, 'marugame-shi', 34.28560000, 133.81535000),
(1063992, 1000864, 'JP', 'Mitoyo Shi', 1, 'mitoyo-shi', 34.16176000, 133.72282000),
(1064260, 1000864, 'JP', 'Sakaide Shi', 1, 'sakaide-shi', 34.32403000, 133.89222000),
(1064261, 1000864, 'JP', 'Sakaidechō', 1, 'sakaidecho', 34.32278000, 133.83560000),
(1064283, 1000864, 'JP', 'Sanuki-shi', 1, 'sanuki-shi', 34.26615000, 134.20941000),
(1064317, 1000864, 'JP', 'Shido', 1, 'shido', 34.32333000, 134.17333000),
(1064406, 1000864, 'JP', 'Tadotsu', 1, 'tadotsu', 34.27500000, 133.75000000),
(1064427, 1000864, 'JP', 'Takamatsu', 1, 'takamatsu', 34.33333000, 134.05000000),
(1064428, 1000864, 'JP', 'Takamatsu Shi', 1, 'takamatsu-shi', 34.26852000, 134.05450000),
(1064514, 1000864, 'JP', 'Tonoshō', 1, 'tonosho', 34.48047000, 134.17017000),
(1064710, 1000864, 'JP', 'Zentsūji Shi', 1, 'zentsuji-shi', 34.22581000, 133.77692000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000840, 'JP', 'Kagoshima Prefecture', 1, 'kagoshima-prefecture');

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 
(1063222, 1000840, 'JP', 'Aira Shi', 1, 'aira-shi', 31.78460000, 130.60668000),
(1063235, 1000840, 'JP', 'Akune', 1, 'akune', 32.01667000, 130.20000000),
(1063236, 1000840, 'JP', 'Akune Shi', 1, 'akune-shi', 32.02516000, 130.19768000),
(1063242, 1000840, 'JP', 'Amami', 1, 'amami', 28.37690000, 129.49379000),
(1063243, 1000840, 'JP', 'Amami Shi', 1, 'amami-shi', 28.34542000, 129.50221000),
(1063428, 1000840, 'JP', 'Hamanoichi', 1, 'hamanoichi', 31.71667000, 130.73333000),
(1063485, 1000840, 'JP', 'Hioki', 1, 'hioki', 31.58333000, 130.35000000),
(1063486, 1000840, 'JP', 'Hioki Shi', 1, 'hioki-shi', 31.59929000, 130.38208000),
(1063535, 1000840, 'JP', 'Ibusuki', 1, 'ibusuki', 31.23333000, 130.65000000),
(1063536, 1000840, 'JP', 'Ibusuki Shi', 1, 'ibusuki-shi', 31.22962000, 130.58060000),
(1063540, 1000840, 'JP', 'Ichikikushikino Shi', 1, 'ichikikushikino-shi', 31.73281000, 130.28893000),
(1063553, 1000840, 'JP', 'Ijūin', 1, 'ijuin', 31.61667000, 130.40000000),
(1063580, 1000840, 'JP', 'Isa Shi', 1, 'isa-shi', 32.05835000, 130.60104000),
(1063641, 1000840, 'JP', 'Izumi', 1, 'izumi', 32.08333000, 130.36667000),
(1063642, 1000840, 'JP', 'Izumi Shi', 1, 'izumi-shi', 32.06412000, 130.36097000),
(1063658, 1000840, 'JP', 'Kagoshima', 1, 'kagoshima', 31.56667000, 130.55000000),
(1063659, 1000840, 'JP', 'Kagoshima Shi', 1, 'kagoshima-shi', 31.58003000, 130.52806000),
(1063667, 1000840, 'JP', 'Kajiki', 1, 'kajiki', 31.73333000, 130.66667000),
(1063713, 1000840, 'JP', 'Kanoya', 1, 'kanoya', 31.38333000, 130.85000000),
(1063714, 1000840, 'JP', 'Kanoya Shi', 1, 'kanoya-shi', 31.42664000, 130.86735000),
(1063732, 1000840, 'JP', 'Kaseda-shirakame', 1, 'kaseda-shirakame', 31.41667000, 130.31667000),
(1063789, 1000840, 'JP', 'Kirishima Shi', 1, 'kirishima-shi', 31.80558000, 130.78164000),
(1063829, 1000840, 'JP', 'Kokubu-matsuki', 1, 'kokubu-matsuki', 31.73333000, 130.76667000),
(1063847, 1000840, 'JP', 'Koseda', 1, 'koseda', 30.38796000, 130.64924000),
(1063849, 1000840, 'JP', 'Koshima', 1, 'koshima', 30.23461000, 130.53517000),
(1063873, 1000840, 'JP', 'Kurio', 1, 'kurio', 30.27123000, 130.42360000),
(1063883, 1000840, 'JP', 'Kushikino', 1, 'kushikino', 31.71667000, 130.26667000),
(1063918, 1000840, 'JP', 'Makurazaki', 1, 'makurazaki', 31.26667000, 130.31667000),
(1063919, 1000840, 'JP', 'Makurazaki Shi', 1, 'makurazaki-shi', 31.29139000, 130.30681000),
(1063967, 1000840, 'JP', 'Minamikyushu Shi', 1, 'minamikyushu-shi', 31.34038000, 130.43677000),
(1063969, 1000840, 'JP', 'Minamisatsuma Shi', 1, 'minamisatsuma-shi', 31.38793000, 130.26961000),
(1064006, 1000840, 'JP', 'Miyanoura', 1, 'miyanoura', 30.42690000, 130.57151000),
(1064073, 1000840, 'JP', 'Nagata', 1, 'nagata', 30.39516000, 130.42548000),
(1064119, 1000840, 'JP', 'Naze', 1, 'naze', 28.36667000, 129.48333000),
(1064150, 1000840, 'JP', 'Nishinoomote', 1, 'nishinoomote', 30.73333000, 131.00000000),
(1064151, 1000840, 'JP', 'Nishinoomote Shi', 1, 'nishinoomote-shi', 30.70536000, 131.01521000),
(1064733, 1000840, 'JP', 'Ōkuchi-shinohara', 1, 'okuchi-shinohara', 32.06779000, 130.62439000),
(1064291, 1000840, 'JP', 'Satsumasendai', 1, 'satsumasendai', 31.81667000, 130.30000000),
(1064292, 1000840, 'JP', 'Satsumasendai Shi', 1, 'satsumasendai-shi', 31.82376000, 130.25899000),
(1064314, 1000840, 'JP', 'Shibushi', 1, 'shibushi', 31.47600000, 131.10114000),
(1064315, 1000840, 'JP', 'Shibushi-shi', 1, 'shibushi-shi', 31.48333000, 131.10000000),
(1064374, 1000840, 'JP', 'Soo Shi', 1, 'soo-shi', 31.65615000, 130.97470000),
(1064375, 1000840, 'JP', 'Sueyoshichō-ninokata', 1, 'sueyoshicho-ninokata', 31.65000000, 131.01667000),
(1064470, 1000840, 'JP', 'Tarumizu', 1, 'tarumizu', 31.48333000, 130.70000000),
(1064471, 1000840, 'JP', 'Tarumizu Shi', 1, 'tarumizu-shi', 31.51583000, 130.76046000),
(1064693, 1000840, 'JP', 'Yudomari', 1, 'yudomari', 30.23470000, 130.47942000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000842, 'JP', 'Kanagawa Prefecture', 1, 'kanagawa-prefecture');

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 
(1063272, 1000842, 'JP', 'Atsugi', 1, 'atsugi', 35.44272000, 139.36931000),
(1063273, 1000842, 'JP', 'Atsugi Shi', 1, 'atsugi-shi', 35.46513000, 139.32707000),
(1063279, 1000842, 'JP', 'Ayase Shi', 1, 'ayase-shi', 35.43995000, 139.43089000),
(1063296, 1000842, 'JP', 'Chigasaki', 1, 'chigasaki', 35.33638000, 139.40434000),
(1063297, 1000842, 'JP', 'Chigasaki Shi', 1, 'chigasaki-shi', 35.34429000, 139.40958000),
(1063327, 1000842, 'JP', 'Ebina Shi', 1, 'ebina-shi', 35.43762000, 139.39307000),
(1063352, 1000842, 'JP', 'Fujisawa', 1, 'fujisawa', 35.34926000, 139.47666000),
(1063353, 1000842, 'JP', 'Fujisawa Shi', 1, 'fujisawa-shi', 35.36814000, 139.45899000),
(1063411, 1000842, 'JP', 'Hadano', 1, 'hadano', 35.37111000, 139.22361000),
(1063412, 1000842, 'JP', 'Hadano-shi', 1, 'hadano-shi', 35.40000000, 139.20000000),
(1063418, 1000842, 'JP', 'Hakone', 1, 'hakone', 35.18945000, 139.02649000),
(1063451, 1000842, 'JP', 'Hayama', 1, 'hayama', 35.27651000, 139.57733000),
(1063495, 1000842, 'JP', 'Hiratsuka', 1, 'hiratsuka', 35.32785000, 139.33735000),
(1063496, 1000842, 'JP', 'Hiratsuka Shi', 1, 'hiratsuka-shi', 35.35099000, 139.32013000),
(1063586, 1000842, 'JP', 'Isehara', 1, 'isehara', 35.39932000, 139.31019000),
(1063587, 1000842, 'JP', 'Isehara Shi', 1, 'isehara-shi', 35.41011000, 139.29203000),
(1063680, 1000842, 'JP', 'Kamakura', 1, 'kamakura', 35.30889000, 139.55028000),
(1063681, 1000842, 'JP', 'Kamakura Shi', 1, 'kamakura-shi', 35.33000000, 139.53798000),
(1063775, 1000842, 'JP', 'Kawasaki', 1, 'kawasaki', 35.52056000, 139.71722000),
(1063777, 1000842, 'JP', 'Kawasaki-shi', 1, 'kawasaki-shi', 35.56996000, 139.62854000),
(1063963, 1000842, 'JP', 'Minamiashigara', 1, 'minamiashigara', 35.31947000, 139.10960000),
(1063964, 1000842, 'JP', 'Minamiashigara Shi', 1, 'minamiashigara-shi', 35.30991000, 139.07016000),
(1063968, 1000842, 'JP', 'Minamirinkan', 1, 'minamirinkan', 35.49527000, 139.44279000),
(1063996, 1000842, 'JP', 'Miura', 1, 'miura', 35.14000000, 139.61917000),
(1063997, 1000842, 'JP', 'Miura Shi', 1, 'miura-shi', 35.16754000, 139.64104000),
(1064142, 1000842, 'JP', 'Ninomiya', 1, 'ninomiya', 35.30150000, 139.25581000),
(1064183, 1000842, 'JP', 'Odawara', 1, 'odawara', 35.25556000, 139.15972000),
(1064184, 1000842, 'JP', 'Odawara-shi', 1, 'odawara-shi', 35.25000000, 139.13333000),
(1064727, 1000842, 'JP', 'Ōiso', 1, 'oiso', 35.31558000, 139.31625000),
(1064243, 1000842, 'JP', 'Sagamihara-shi', 1, 'sagamihara-shi', 35.55000000, 139.35000000),
(1064642, 1000842, 'JP', 'Yamakita', 1, 'yamakita', 35.36344000, 139.07975000),
(1064644, 1000842, 'JP', 'Yamato-shi', 1, 'yamato-shi', 35.46934000, 139.46165000),
(1064670, 1000842, 'JP', 'Yokohama', 1, 'yokohama', 35.43333000, 139.65000000),
(1064671, 1000842, 'JP', 'Yokohama Shi', 1, 'yokohama-shi', 35.46225000, 139.57645000),
(1064672, 1000842, 'JP', 'Yokosuka', 1, 'yokosuka', 35.28361000, 139.66722000),
(1064673, 1000842, 'JP', 'Yokosuka Shi', 1, 'yokosuka-shi', 35.24985000, 139.66033000),
(1064695, 1000842, 'JP', 'Yugawara', 1, 'yugawara', 35.15000000, 139.06667000),
(1064708, 1000842, 'JP', 'Zama', 1, 'zama', 35.48790000, 139.39101000),
(1064709, 1000842, 'JP', 'Zama Shi', 1, 'zama-shi', 35.48752000, 139.40925000),
(1064711, 1000842, 'JP', 'Zushi Shi', 1, 'zushi-shi', 35.29900000, 139.59125000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000846, 'JP', 'Kumamoto Prefecture', 1, 'kumamoto-prefecture');

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 
(1063240, 1000846, 'JP', 'Amakusa Gun', 1, 'amakusa-gun', 32.48513000, 130.07240000),
(1063241, 1000846, 'JP', 'Amakusa Shi', 1, 'amakusa-shi', 32.38515000, 130.15014000),
(1063253, 1000846, 'JP', 'Arao Shi', 1, 'arao-shi', 32.97619000, 130.47562000),
(1063269, 1000846, 'JP', 'Aso-shi', 1, 'aso-shi', 32.95608000, 131.09458000),
(1063511, 1000846, 'JP', 'Hitoyoshi', 1, 'hitoyoshi', 32.21667000, 130.75000000),
(1063512, 1000846, 'JP', 'Hitoyoshi Shi', 1, 'hitoyoshi-shi', 32.17298000, 130.74013000),
(1063522, 1000846, 'JP', 'Hondomachi-hondo', 1, 'hondomachi-hondo', 32.45993000, 130.16713000),
(1063525, 1000846, 'JP', 'Honmachi', 1, 'honmachi', 32.50439000, 130.59952000),
(1063687, 1000846, 'JP', 'Kamiamakusa Shi', 1, 'kamiamakusa-shi', 32.49550000, 130.40816000),
(1063784, 1000846, 'JP', 'Kikuchi', 1, 'kikuchi', 32.98333000, 130.81667000),
(1063785, 1000846, 'JP', 'Kikuchi Shi', 1, 'kikuchi-shi', 32.99107000, 130.85523000),
(1063901, 1000846, 'JP', 'Kōshi Shi', 1, 'koshi-shi', 32.89305000, 130.76867000),
(1063859, 1000846, 'JP', 'Kumamoto', 1, 'kumamoto', 32.80589000, 130.69181000),
(1063860, 1000846, 'JP', 'Kumamoto Shi', 1, 'kumamoto-shi', 32.79733000, 130.69171000),
(1063931, 1000846, 'JP', 'Matsubase', 1, 'matsubase', 32.65000000, 130.66667000),
(1063959, 1000846, 'JP', 'Minamata', 1, 'minamata', 32.21667000, 130.40000000),
(1063960, 1000846, 'JP', 'Minamata Shi', 1, 'minamata-shi', 32.17055000, 130.46211000),
(1064769, 1000846, 'JP', 'Ōzu', 1, 'ozu', 32.88040000, 130.87161000),
(1064457, 1000846, 'JP', 'Tamana', 1, 'tamana', 32.94716000, 130.57446000),
(1064458, 1000846, 'JP', 'Tamana Shi', 1, 'tamana-shi', 32.91550000, 130.56018000),
(1064580, 1000846, 'JP', 'Uekimachi-mōno', 1, 'uekimachi-mono', 32.89964000, 130.68898000),
(1064587, 1000846, 'JP', 'Uki Shi', 1, 'uki-shi', 32.62669000, 130.65491000),
(1064602, 1000846, 'JP', 'Ushibukamachi', 1, 'ushibukamachi', 32.20142000, 130.02171000),
(1064609, 1000846, 'JP', 'Uto', 1, 'uto', 32.68333000, 130.66667000),
(1064610, 1000846, 'JP', 'Uto Shi', 1, 'uto-shi', 32.68092000, 130.61308000),
(1064637, 1000846, 'JP', 'Yamaga Shi', 1, 'yamaga-shi', 33.05587000, 130.72309000),
(1064664, 1000846, 'JP', 'Yatsushiro Shi', 1, 'yatsushiro-shi', 32.49063000, 130.74972000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000834, 'JP', 'Kyōto Prefecture', 1, 'kyoto-prefecture');

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 
(1063254, 1000834, 'JP', 'Arashiyama', 1, 'arashiyama', 35.01481000, 135.67755000),
(1063277, 1000834, 'JP', 'Ayabe', 1, 'ayabe', 35.30000000, 135.25000000),
(1063278, 1000834, 'JP', 'Ayabe-shi', 1, 'ayabe-shi', 35.35263000, 135.34465000),
(1063361, 1000834, 'JP', 'Fukuchiyama-shi', 1, 'fukuchiyama-shi', 35.32404000, 135.11332000),
(1063654, 1000834, 'JP', 'Jōyō Shi', 1, 'joyo-shi', 34.84566000, 135.79760000),
(1063683, 1000834, 'JP', 'Kameoka', 1, 'kameoka', 35.00000000, 135.58333000),
(1063684, 1000834, 'JP', 'Kameoka-shi', 1, 'kameoka-shi', 35.01021000, 135.53900000),
(1063689, 1000834, 'JP', 'Kamigyō-ku', 1, 'kamigyo-ku', 35.02954000, 135.75666000),
(1063817, 1000834, 'JP', 'Kizugawa-shi', 1, 'kizugawa-shi', 34.73781000, 135.82128000),
(1063891, 1000834, 'JP', 'Kyōtanabe Shi', 1, 'kyotanabe-shi', 34.80779000, 135.76300000),
(1063892, 1000834, 'JP', 'Kyōtango-shi', 1, 'kyotango-shi', 35.63089000, 135.04785000),
(1063890, 1000834, 'JP', 'Kyoto', 1, 'kyoto', 35.02107000, 135.75385000),
(1063912, 1000834, 'JP', 'Maizuru', 1, 'maizuru', 35.45000000, 135.33333000),
(1063913, 1000834, 'JP', 'Maizuru-shi', 1, 'maizuru-shi', 35.47009000, 135.34003000),
(1064011, 1000834, 'JP', 'Miyazu', 1, 'miyazu', 35.53333000, 135.18333000),
(1064012, 1000834, 'JP', 'Miyazu-shi', 1, 'miyazu-shi', 35.55596000, 135.17662000),
(1064043, 1000834, 'JP', 'Mukō Shi', 1, 'muko-shi', 34.94975000, 135.70269000),
(1064068, 1000834, 'JP', 'Nagaokakyō Shi', 1, 'nagaokakyo-shi', 34.92840000, 135.67881000),
(1064102, 1000834, 'JP', 'Nantan-shi', 1, 'nantan-shi', 35.22740000, 135.55939000),
(1064463, 1000834, 'JP', 'Tanabe', 1, 'tanabe', 34.82242000, 135.76604000),
(1064584, 1000834, 'JP', 'Uji', 1, 'uji', 34.89044000, 135.80325000),
(1064585, 1000834, 'JP', 'Uji Shi', 1, 'uji-shi', 34.90296000, 135.82039000),
(1064665, 1000834, 'JP', 'Yawata', 1, 'yawata', 34.87009000, 135.70270000),
(1064666, 1000834, 'JP', 'Yawata Shi', 1, 'yawata-shi', 34.86662000, 135.71470000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000833, 'JP', 'Mie Prefecture', 1, 'mie-prefecture');

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 
(1063501, 1000833, 'JP', 'Hisai-motomachi', 1, 'hisai-motomachi', 34.66667000, 136.46667000),
(1063546, 1000833, 'JP', 'Iga-shi', 1, 'iga-shi', 34.76855000, 136.13013000),
(1063567, 1000833, 'JP', 'Inabe', 1, 'inabe', 35.11344000, 136.57205000),
(1063568, 1000833, 'JP', 'Inabe-shi', 1, 'inabe-shi', 35.16061000, 136.50788000),
(1063584, 1000833, 'JP', 'Ise', 1, 'ise', 34.48333000, 136.70000000),
(1063585, 1000833, 'JP', 'Ise-shi', 1, 'ise-shi', 34.46740000, 136.71585000),
(1063685, 1000833, 'JP', 'Kameyama', 1, 'kameyama', 34.85000000, 136.45000000),
(1063686, 1000833, 'JP', 'Kameyama Shi', 1, 'kameyama-shi', 34.86866000, 136.39345000),
(1063767, 1000833, 'JP', 'Kawage', 1, 'kawage', 34.80447000, 136.54645000),
(1063840, 1000833, 'JP', 'Komono', 1, 'komono', 35.00000000, 136.51667000),
(1063861, 1000833, 'JP', 'Kumano', 1, 'kumano', 33.90389000, 136.12214000),
(1063862, 1000833, 'JP', 'Kumano-shi', 1, 'kumano-shi', 33.92290000, 136.02646000),
(1063888, 1000833, 'JP', 'Kuwana', 1, 'kuwana', 35.05192000, 136.66958000),
(1063889, 1000833, 'JP', 'Kuwana-shi', 1, 'kuwana-shi', 35.06176000, 136.68348000),
(1063942, 1000833, 'JP', 'Matsuzaka-shi', 1, 'matsuzaka-shi', 34.56667000, 136.53333000),
(1064057, 1000833, 'JP', 'Nabari', 1, 'nabari', 34.61667000, 136.08333000),
(1064058, 1000833, 'JP', 'Nabari-shi', 1, 'nabari-shi', 34.62643000, 136.10825000),
(1064219, 1000833, 'JP', 'Owase', 1, 'owase', 34.06667000, 136.20000000),
(1064323, 1000833, 'JP', 'Shima', 1, 'shima', 34.33333000, 136.83333000),
(1064324, 1000833, 'JP', 'Shima-shi', 1, 'shima-shi', 34.33795000, 136.81336000),
(1064396, 1000833, 'JP', 'Suzuka', 1, 'suzuka', 34.88333000, 136.58333000),
(1064397, 1000833, 'JP', 'Suzuka-shi', 1, 'suzuka-shi', 34.88114000, 136.58443000),
(1064485, 1000833, 'JP', 'Toba', 1, 'toba', 34.48330000, 136.84186000),
(1064486, 1000833, 'JP', 'Toba-shi', 1, 'toba-shi', 34.48333000, 136.83333000),
(1064535, 1000833, 'JP', 'Tsu', 1, 'tsu', 34.73333000, 136.51667000),
(1064536, 1000833, 'JP', 'Tsu-shi', 1, 'tsu-shi', 34.71706000, 136.50616000),
(1064581, 1000833, 'JP', 'Ueno-ebisumachi', 1, 'ueno-ebisumachi', 34.75856000, 136.13108000),
(1064669, 1000833, 'JP', 'Yokkaichi-shi', 1, 'yokkaichi-shi', 34.96475000, 136.62443000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000857, 'JP', 'Miyagi Prefecture', 1, 'miyagi-prefecture');

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 
(1063379, 1000857, 'JP', 'Furukawa', 1, 'furukawa', 38.57167000, 140.95556000),
(1063462, 1000857, 'JP', 'Higashimatshushima Shi', 1, 'higashimatshushima-shi', 38.41089000, 141.17717000),
(1063463, 1000857, 'JP', 'Higashimatsushima', 1, 'higashimatsushima', 38.40886000, 141.17901000),
(1063599, 1000857, 'JP', 'Ishinomaki', 1, 'ishinomaki', 38.41667000, 141.30000000),
(1063600, 1000857, 'JP', 'Ishinomaki Shi', 1, 'ishinomaki-shi', 38.47918000, 141.37226000),
(1063629, 1000857, 'JP', 'Iwanuma', 1, 'iwanuma', 38.10472000, 140.85944000),
(1063630, 1000857, 'JP', 'Iwanuma-shi', 1, 'iwanuma-shi', 38.11667000, 140.88333000),
(1063673, 1000857, 'JP', 'Kakuda', 1, 'kakuda', 37.97451000, 140.77202000),
(1063674, 1000857, 'JP', 'Kakuda Shi', 1, 'kakuda-shi', 37.98828000, 140.77903000),
(1063781, 1000857, 'JP', 'Kesennuma', 1, 'kesennuma', 38.90112000, 141.57746000),
(1063782, 1000857, 'JP', 'Kesennuma Shi', 1, 'kesennuma-shi', 38.91377000, 141.55711000),
(1063828, 1000857, 'JP', 'Kogota', 1, 'kogota', 38.55000000, 141.05000000),
(1063870, 1000857, 'JP', 'Kurihara', 1, 'kurihara', 38.75000000, 141.00000000),
(1063871, 1000857, 'JP', 'Kurihara Shi', 1, 'kurihara-shi', 38.80895000, 140.94034000),
(1063923, 1000857, 'JP', 'Marumori', 1, 'marumori', 37.91667000, 140.76667000),
(1063937, 1000857, 'JP', 'Matsushima', 1, 'matsushima', 38.37357000, 141.06105000),
(1064116, 1000857, 'JP', 'Natori Shi', 1, 'natori-shi', 38.16729000, 140.86666000),
(1064732, 1000857, 'JP', 'Ōkawara', 1, 'okawara', 38.05000000, 140.73361000),
(1064206, 1000857, 'JP', 'Onagawa Chō', 1, 'onagawa-cho', 38.44660000, 141.44794000),
(1064752, 1000857, 'JP', 'Ōsaki', 1, 'osaki', 38.58866000, 140.97300000),
(1064753, 1000857, 'JP', 'Ōsaki Shi', 1, 'osaki-shi', 38.68005000, 140.84669000),
(1064225, 1000857, 'JP', 'Rifu', 1, 'rifu', 38.33092000, 140.97691000),
(1064300, 1000857, 'JP', 'Sendai', 1, 'sendai', 38.26667000, 140.86667000),
(1064348, 1000857, 'JP', 'Shiogama', 1, 'shiogama', 38.31667000, 141.03333000),
(1064359, 1000857, 'JP', 'Shiroishi', 1, 'shiroishi', 38.00333000, 140.61833000),
(1064360, 1000857, 'JP', 'Shiroishi Shi', 1, 'shiroishi-shi', 37.99691000, 140.57944000),
(1064407, 1000857, 'JP', 'Tagajō Shi', 1, 'tagajo-shi', 38.29535000, 140.99910000),
(1064503, 1000857, 'JP', 'Tome Shi', 1, 'tome-shi', 38.68583000, 141.25745000),
(1064509, 1000857, 'JP', 'Tomiya', 1, 'tomiya', 38.39306000, 140.88611000),
(1064622, 1000857, 'JP', 'Wakuya', 1, 'wakuya', 38.54465000, 141.13461000),
(1064625, 1000857, 'JP', 'Watari', 1, 'watari', 38.03500000, 140.85111000),
(1064626, 1000857, 'JP', 'Watari-gun', 1, 'watari-gun', 37.99640000, 140.87909000),
(1064649, 1000857, 'JP', 'Yamoto', 1, 'yamoto', 38.42738000, 141.21487000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000855, 'JP', 'Miyazaki Prefecture', 1, 'miyazaki-prefecture');

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 
(1063328, 1000855, 'JP', 'Ebino-shi', 1, 'ebino-shi', 32.01667000, 130.80000000),
(1063527, 1000855, 'JP', 'Hyūga-shi', 1, 'hyuga-shi', 32.37710000, 131.52275000),
(1063818, 1000855, 'JP', 'Kobayashi', 1, 'kobayashi', 31.98333000, 130.98333000),
(1063819, 1000855, 'JP', 'Kobayashi Shi', 1, 'kobayashi-shi', 32.04556000, 131.02762000),
(1063884, 1000855, 'JP', 'Kushima', 1, 'kushima', 31.48621000, 131.24210000),
(1063885, 1000855, 'JP', 'Kushima Shi', 1, 'kushima-shi', 31.48571000, 131.26485000),
(1064003, 1000855, 'JP', 'Miyakonojō', 1, 'miyakonojo', 31.73333000, 131.06667000),
(1064004, 1000855, 'JP', 'Miyakonojō Shi', 1, 'miyakonojo-shi', 31.80920000, 131.07904000),
(1064009, 1000855, 'JP', 'Miyazaki', 1, 'miyazaki', 31.91667000, 131.41667000),
(1064010, 1000855, 'JP', 'Miyazaki-shi', 1, 'miyazaki-shi', 31.96192000, 131.38455000),
(1064125, 1000855, 'JP', 'Nichinan', 1, 'nichinan', 31.60000000, 131.36667000),
(1064126, 1000855, 'JP', 'Nichinan Shi', 1, 'nichinan-shi', 31.63737000, 131.33409000),
(1064159, 1000855, 'JP', 'Nobeoka', 1, 'nobeoka', 32.58333000, 131.66667000),
(1064160, 1000855, 'JP', 'Nobeoka-shi', 1, 'nobeoka-shi', 32.67238000, 131.64311000),
(1064252, 1000855, 'JP', 'Saito-shi', 1, 'saito-shi', 32.17288000, 131.31543000),
(1064429, 1000855, 'JP', 'Takanabe', 1, 'takanabe', 32.13333000, 131.50000000),
(1064551, 1000855, 'JP', 'Tsuma', 1, 'tsuma', 32.10000000, 131.40000000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000843, 'JP', 'Nagano Prefecture', 1, 'nagano-prefecture');

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 
(1063280, 1000843, 'JP', 'Azumino-Shi', 1, 'azumino-shi', 36.32716000, 137.83988000),
(1063299, 1000843, 'JP', 'Chikuma Shi', 1, 'chikuma-shi', 36.50624000, 138.12352000),
(1063303, 1000843, 'JP', 'Chino', 1, 'chino', 35.99440000, 138.15428000),
(1063304, 1000843, 'JP', 'Chino Shi', 1, 'chino-shi', 36.02522000, 138.24668000),
(1063419, 1000843, 'JP', 'Hakuba', 1, 'hakuba', 36.69818000, 137.86185000),
(1063526, 1000843, 'JP', 'Hotaka', 1, 'hotaka', 36.33960000, 137.88254000),
(1063547, 1000843, 'JP', 'Iida', 1, 'iida', 35.51965000, 137.82074000),
(1063548, 1000843, 'JP', 'Iida-shi', 1, 'iida-shi', 35.42287000, 137.89381000),
(1063549, 1000843, 'JP', 'Iiyama', 1, 'iiyama', 36.85000000, 138.36667000),
(1063550, 1000843, 'JP', 'Iiyama Shi', 1, 'iiyama-shi', 36.91249000, 138.38345000),
(1063565, 1000843, 'JP', 'Ina', 1, 'ina', 35.82756000, 137.95378000),
(1063566, 1000843, 'JP', 'Ina-shi', 1, 'ina-shi', 35.79079000, 138.07402000),
(1063693, 1000843, 'JP', 'Kamimaruko', 1, 'kamimaruko', 36.31865000, 138.27329000),
(1063833, 1000843, 'JP', 'Komagane', 1, 'komagane', 35.71657000, 137.93745000),
(1063834, 1000843, 'JP', 'Komagane-shi', 1, 'komagane-shi', 35.72770000, 137.94783000),
(1063841, 1000843, 'JP', 'Komoro', 1, 'komoro', 36.31667000, 138.43333000),
(1063842, 1000843, 'JP', 'Komoro Shi', 1, 'komoro-shi', 36.33905000, 138.43503000),
(1063935, 1000843, 'JP', 'Matsumoto', 1, 'matsumoto', 36.23333000, 137.96667000),
(1063936, 1000843, 'JP', 'Matsumoto Shi', 1, 'matsumoto-shi', 36.20418000, 137.81419000),
(1064064, 1000843, 'JP', 'Nagano', 1, 'nagano', 36.65000000, 138.18333000),
(1064065, 1000843, 'JP', 'Nagano Shi', 1, 'nagano-shi', 36.65257000, 138.11694000),
(1064086, 1000843, 'JP', 'Nakano Shi', 1, 'nakano-shi', 36.76940000, 138.34717000),
(1064193, 1000843, 'JP', 'Okaya', 1, 'okaya', 36.05659000, 138.04510000),
(1064194, 1000843, 'JP', 'Okaya Shi', 1, 'okaya-shi', 36.07917000, 138.04805000),
(1064734, 1000843, 'JP', 'Ōmachi', 1, 'omachi', 36.50000000, 137.86667000),
(1064735, 1000843, 'JP', 'Ōmachi-shi', 1, 'omachi-shi', 36.55000000, 137.75000000),
(1064266, 1000843, 'JP', 'Saku', 1, 'saku', 36.21667000, 138.48333000),
(1064267, 1000843, 'JP', 'Saku Shi', 1, 'saku-shi', 36.21577000, 138.44529000),
(1064349, 1000843, 'JP', 'Shiojiri', 1, 'shiojiri', 36.10000000, 137.96667000),
(1064350, 1000843, 'JP', 'Shiojiri-shi', 1, 'shiojiri-shi', 36.08333000, 137.93333000),
(1064390, 1000843, 'JP', 'Suwa', 1, 'suwa', 36.03799000, 138.11308000),
(1064391, 1000843, 'JP', 'Suwa Shi', 1, 'suwa-shi', 36.02899000, 138.11357000),
(1064392, 1000843, 'JP', 'Suzaka', 1, 'suzaka', 36.65000000, 138.31667000),
(1064393, 1000843, 'JP', 'Suzaka-shi', 1, 'suzaka-shi', 36.65000000, 138.31667000),
(1064476, 1000843, 'JP', 'Tatsuno', 1, 'tatsuno', 35.98426000, 137.99721000),
(1064571, 1000843, 'JP', 'Tōmi', 1, 'tomi', 36.35582000, 138.36093000),
(1064572, 1000843, 'JP', 'Tōmi Shi', 1, 'tomi-shi', 36.37387000, 138.36866000),
(1064533, 1000843, 'JP', 'Toyoshina', 1, 'toyoshina', 36.29991000, 137.90108000),
(1064578, 1000843, 'JP', 'Ueda', 1, 'ueda', 36.40265000, 138.28161000),
(1064579, 1000843, 'JP', 'Ueda Shi', 1, 'ueda-shi', 36.38352000, 138.24186000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000849, 'JP', 'Nagasaki Prefecture', 1, 'nagasaki-prefecture');

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 
(1063362, 1000849, 'JP', 'Fukuechō', 1, 'fukuecho', 32.69732000, 128.84561000),
(1063397, 1000849, 'JP', 'Gotō Shi', 1, 'goto-shi', 32.69892000, 128.76871000),
(1063487, 1000849, 'JP', 'Hirado', 1, 'hirado', 33.36853000, 129.55247000),
(1063488, 1000849, 'JP', 'Hirado Shi', 1, 'hirado-shi', 33.31596000, 129.48688000),
(1063557, 1000849, 'JP', 'Iki Shi', 1, 'iki-shi', 33.78554000, 129.71670000),
(1063581, 1000849, 'JP', 'Isahaya', 1, 'isahaya', 32.84111000, 130.04306000),
(1063582, 1000849, 'JP', 'Isahaya-shi', 1, 'isahaya-shi', 32.86912000, 130.06369000),
(1063939, 1000849, 'JP', 'Matsuura', 1, 'matsuura', 33.34058000, 129.69504000),
(1063940, 1000849, 'JP', 'Matsuura Shi', 1, 'matsuura-shi', 33.35334000, 129.73504000),
(1063970, 1000849, 'JP', 'Minamishimabara-shi', 1, 'minamishimabara-shi', 32.67565000, 130.25695000),
(1064071, 1000849, 'JP', 'Nagasaki', 1, 'nagasaki', 32.75000000, 129.88333000),
(1064072, 1000849, 'JP', 'Nagasaki-shi', 1, 'nagasaki-shi', 32.78206000, 129.82715000),
(1064182, 1000849, 'JP', 'Obita', 1, 'obita', 32.81667000, 129.88333000),
(1064743, 1000849, 'JP', 'Ōmura', 1, 'omura', 32.92139000, 129.95389000),
(1064744, 1000849, 'JP', 'Ōmura-shi', 1, 'omura-shi', 32.93978000, 129.99297000),
(1064247, 1000849, 'JP', 'Saikai-shi', 1, 'saikai-shi', 32.99259000, 129.68200000),
(1064290, 1000849, 'JP', 'Sasebo Shi', 1, 'sasebo-shi', 33.18992000, 129.68960000),
(1064325, 1000849, 'JP', 'Shimabara', 1, 'shimabara', 32.78333000, 130.36667000),
(1064326, 1000849, 'JP', 'Shimabara-shi', 1, 'shimabara-shi', 32.79429000, 130.32925000),
(1064490, 1000849, 'JP', 'Togitsu', 1, 'togitsu', 32.83333000, 129.85000000),
(1064561, 1000849, 'JP', 'Tsushima Shi', 1, 'tsushima-shi', 34.40845000, 129.32599000),
(1064591, 1000849, 'JP', 'Unzen-shi', 1, 'unzen-shi', 32.78390000, 130.22828000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000824, 'JP', 'Nara Prefecture', 1, 'nara-prefecture');

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 
(1063389, 1000824, 'JP', 'Gojō', 1, 'gojo', 34.35000000, 135.70000000),
(1063390, 1000824, 'JP', 'Gojō-shi', 1, 'gojo-shi', 34.35081000, 135.69489000),
(1063391, 1000824, 'JP', 'Gose', 1, 'gose', 34.45000000, 135.73333000),
(1063415, 1000824, 'JP', 'Haibara-akanedai', 1, 'haibara-akanedai', 34.53333000, 135.95000000),
(1063530, 1000824, 'JP', 'Hōryūji', 1, 'horyuji', 34.61234000, 135.73754000),
(1063558, 1000824, 'JP', 'Ikoma', 1, 'ikoma', 34.68333000, 135.70000000),
(1063559, 1000824, 'JP', 'Ikoma-shi', 1, 'ikoma-shi', 34.69187000, 135.70057000),
(1063733, 1000824, 'JP', 'Kashiba-shi', 1, 'kashiba-shi', 34.54107000, 135.69918000),
(1063735, 1000824, 'JP', 'Kashihara-shi', 1, 'kashihara-shi', 34.50352000, 135.78986000),
(1063755, 1000824, 'JP', 'Katsuragi', 1, 'katsuragi', 34.48562000, 135.69698000),
(1063756, 1000824, 'JP', 'Katsuragi Shi', 1, 'katsuragi-shi', 34.49682000, 135.70464000),
(1064106, 1000824, 'JP', 'Nara-shi', 1, 'nara-shi', 34.68506000, 135.80485000),
(1064273, 1000824, 'JP', 'Sakurai', 1, 'sakurai', 34.50000000, 135.85000000),
(1064274, 1000824, 'JP', 'Sakurai-shi', 1, 'sakurai-shi', 34.51816000, 135.84320000),
(1064479, 1000824, 'JP', 'Tawaramoto', 1, 'tawaramoto', 34.55420000, 135.79297000),
(1064483, 1000824, 'JP', 'Tenri', 1, 'tenri', 34.58333000, 135.83333000),
(1064484, 1000824, 'JP', 'Tenri-shi', 1, 'tenri-shi', 34.59619000, 135.83736000),
(1064577, 1000824, 'JP', 'Uda Shi', 1, 'uda-shi', 34.52035000, 135.99787000),
(1064645, 1000824, 'JP', 'Yamatokōriyama-shi', 1, 'yamatokoriyama-shi', 34.64917000, 135.78278000),
(1064646, 1000824, 'JP', 'Yamatotakada-shi', 1, 'yamatotakada-shi', 34.51490000, 135.73660000),
(1064687, 1000824, 'JP', 'Yoshino-chō', 1, 'yoshino-cho', 34.39611000, 135.85768000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000841, 'JP', 'Niigata Prefecture', 1, 'niigata-prefecture');

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 
(1063216, 1000841, 'JP', 'Agano Shi', 1, 'agano-shi', 37.81420000, 139.25914000),
(1063251, 1000841, 'JP', 'Arai', 1, 'arai', 37.00059000, 138.22590000),
(1063392, 1000841, 'JP', 'Gosen', 1, 'gosen', 37.73333000, 139.16667000),
(1063393, 1000841, 'JP', 'Gosen Shi', 1, 'gosen-shi', 37.65643000, 139.22634000),
(1063610, 1000841, 'JP', 'Itoigawa', 1, 'itoigawa', 37.03333000, 137.85000000),
(1063611, 1000841, 'JP', 'Itoigawa Shi', 1, 'itoigawa-shi', 36.96626000, 137.89402000),
(1063651, 1000841, 'JP', 'Jōetsu', 1, 'joetsu', 37.14828000, 138.23642000),
(1063652, 1000841, 'JP', 'Jōetsu Shi', 1, 'joetsu-shi', 37.12010000, 138.33752000),
(1063682, 1000841, 'JP', 'Kameda-honchō', 1, 'kameda-honcho', 37.87214000, 139.10990000),
(1063699, 1000841, 'JP', 'Kamo', 1, 'kamo', 37.66442000, 139.03502000),
(1063700, 1000841, 'JP', 'Kamo Shi', 1, 'kamo-shi', 37.62209000, 139.11068000),
(1063742, 1000841, 'JP', 'Kashiwazaki', 1, 'kashiwazaki', 37.36667000, 138.55000000),
(1063743, 1000841, 'JP', 'Kashiwazaki Shi', 1, 'kashiwazaki-shi', 37.29913000, 138.58654000),
(1063915, 1000841, 'JP', 'Maki', 1, 'maki', 37.75000000, 138.88333000),
(1063972, 1000841, 'JP', 'Minamiuonuma Shi', 1, 'minamiuonuma-shi', 37.05587000, 138.93735000),
(1063994, 1000841, 'JP', 'Mitsuke', 1, 'mitsuke', 37.53333000, 138.93333000),
(1063995, 1000841, 'JP', 'Mitsuke Shi', 1, 'mitsuke-shi', 37.52465000, 138.93711000),
(1064042, 1000841, 'JP', 'Muikamachi', 1, 'muikamachi', 37.06667000, 138.88333000),
(1064045, 1000841, 'JP', 'Murakami Shi', 1, 'murakami-shi', 38.31023000, 139.61733000),
(1064046, 1000841, 'JP', 'Muramatsu', 1, 'muramatsu', 37.69257000, 139.17127000),
(1064056, 1000841, 'JP', 'Myoko-shi', 1, 'myoko-shi', 37.00000000, 138.25000000),
(1064066, 1000841, 'JP', 'Nagaoka', 1, 'nagaoka', 37.45000000, 138.85000000),
(1064067, 1000841, 'JP', 'Nagaoka Shi', 1, 'nagaoka-shi', 37.44516000, 138.85678000),
(1064129, 1000841, 'JP', 'Niigata', 1, 'niigata', 37.88637000, 139.00589000),
(1064130, 1000841, 'JP', 'Niigata Shi', 1, 'niigata-shi', 37.82738000, 139.03303000),
(1064135, 1000841, 'JP', 'Niitsu-honchō', 1, 'niitsu-honcho', 37.80024000, 139.12240000),
(1064191, 1000841, 'JP', 'Ojiya', 1, 'ojiya', 37.30000000, 138.80000000),
(1064192, 1000841, 'JP', 'Ojiya-shi', 1, 'ojiya-shi', 37.30000000, 138.80000000),
(1064232, 1000841, 'JP', 'Ryōtsu-minato', 1, 'ryotsu-minato', 38.07817000, 138.43939000),
(1064238, 1000841, 'JP', 'Sado Shi', 1, 'sado-shi', 38.04439000, 138.38984000),
(1064278, 1000841, 'JP', 'Sanjō Shi', 1, 'sanjo-shi', 37.54068000, 139.08983000),
(1064308, 1000841, 'JP', 'Shibata', 1, 'shibata', 37.95000000, 139.33333000),
(1064309, 1000841, 'JP', 'Shibata Shi', 1, 'shibata-shi', 37.90732000, 139.42786000),
(1064351, 1000841, 'JP', 'Shiozawa', 1, 'shiozawa', 37.03757000, 138.84867000),
(1064361, 1000841, 'JP', 'Shirone', 1, 'shirone', 37.76354000, 139.02199000),
(1064378, 1000841, 'JP', 'Suibara', 1, 'suibara', 37.84608000, 139.23039000),
(1064412, 1000841, 'JP', 'Tainai', 1, 'tainai', 38.06646000, 139.37436000),
(1064413, 1000841, 'JP', 'Tainai Shi', 1, 'tainai-shi', 38.00587000, 139.48053000),
(1064488, 1000841, 'JP', 'Tochio-honchō', 1, 'tochio-honcho', 37.47642000, 138.99513000),
(1064569, 1000841, 'JP', 'Tōkamachi', 1, 'tokamachi', 37.13333000, 138.76667000),
(1064570, 1000841, 'JP', 'Tōkamachi-shi', 1, 'tokamachi-shi', 37.13333000, 138.76667000),
(1064537, 1000841, 'JP', 'Tsubame', 1, 'tsubame', 37.66450000, 138.92518000),
(1064538, 1000841, 'JP', 'Tsubame Shi', 1, 'tsubame-shi', 37.66541000, 138.88619000),
(1064592, 1000841, 'JP', 'Uonuma', 1, 'uonuma', 37.24488000, 138.96234000),
(1064593, 1000841, 'JP', 'Uonuma Shi', 1, 'uonuma-shi', 37.22088000, 139.09795000),
(1064683, 1000841, 'JP', 'Yoshida-kasugachō', 1, 'yoshida-kasugacho', 37.68333000, 138.88333000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000822, 'JP', 'Ōita Prefecture', 1, 'oita-prefecture');

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 
(1063283, 1000822, 'JP', 'Beppu', 1, 'beppu', 33.27945000, 131.49751000),
(1063284, 1000822, 'JP', 'Beppu Shi', 1, 'beppu-shi', 33.28573000, 131.45280000),
(1063288, 1000822, 'JP', 'Bungo-ōno Shi', 1, 'bungo-ono-shi', 32.97249000, 131.51210000),
(1063287, 1000822, 'JP', 'Bungo-Takada-shi', 1, 'bungo-takada-shi', 33.55670000, 131.44506000),
(1063472, 1000822, 'JP', 'Hiji', 1, 'hiji', 33.37081000, 131.53025000),
(1063502, 1000822, 'JP', 'Hita', 1, 'hita', 33.32130000, 130.94098000),
(1063503, 1000822, 'JP', 'Hita Shi', 1, 'hita-shi', 33.24452000, 130.95063000),
(1063813, 1000822, 'JP', 'Kitsuki', 1, 'kitsuki', 33.41998000, 131.61837000),
(1063814, 1000822, 'JP', 'Kitsuki Shi', 1, 'kitsuki-shi', 33.44729000, 131.53670000),
(1063863, 1000822, 'JP', 'Kunisaki-shi', 1, 'kunisaki-shi', 33.56543000, 131.73157000),
(1064089, 1000822, 'JP', 'Nakatsu', 1, 'nakatsu', 33.59811000, 131.18830000),
(1064090, 1000822, 'JP', 'Nakatsu Shi', 1, 'nakatsu-shi', 33.46458000, 131.12642000),
(1064728, 1000822, 'JP', 'Ōita', 1, 'oita', 33.23333000, 131.60000000),
(1064729, 1000822, 'JP', 'Ōita-shi', 1, 'oita-shi', 33.17980000, 131.64085000),
(1064248, 1000822, 'JP', 'Saiki', 1, 'saiki', 32.95000000, 131.90000000),
(1064249, 1000822, 'JP', 'Saiki-shi', 1, 'saiki-shi', 32.88598000, 131.77600000),
(1064443, 1000822, 'JP', 'Takedamachi', 1, 'takedamachi', 32.96667000, 131.40000000),
(1064449, 1000822, 'JP', 'Taketa-shi', 1, 'taketa-shi', 32.99774000, 131.32724000),
(1064544, 1000822, 'JP', 'Tsukawaki', 1, 'tsukawaki', 33.27668000, 131.15628000),
(1064549, 1000822, 'JP', 'Tsukumi-shi', 1, 'tsukumi-shi', 33.06667000, 131.86667000),
(1064550, 1000822, 'JP', 'Tsukumiura', 1, 'tsukumiura', 33.07539000, 131.86907000),
(1064559, 1000822, 'JP', 'Tsurusaki', 1, 'tsurusaki', 33.24528000, 131.69165000),
(1064601, 1000822, 'JP', 'Usa Shi', 1, 'usa-shi', 33.44996000, 131.33662000),
(1064605, 1000822, 'JP', 'Usuki', 1, 'usuki', 33.12342000, 131.80401000),
(1064606, 1000822, 'JP', 'Usuki Shi', 1, 'usuki-shi', 33.07223000, 131.74457000),
(1064694, 1000822, 'JP', 'Yufu-shi', 1, 'yufu-shi', 33.17923000, 131.43219000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000820, 'JP', 'Okayama Prefecture', 1, 'okayama-prefecture');

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 
(1063227, 1000820, 'JP', 'Akaiwa Shi', 1, 'akaiwa-shi', 34.83767000, 134.01792000),
(1063262, 1000820, 'JP', 'Asakuchi Shi', 1, 'asakuchi-shi', 34.53607000, 133.59456000),
(1063286, 1000820, 'JP', 'Bizen Shi', 1, 'bizen-shi', 34.79504000, 134.23510000),
(1063531, 1000820, 'JP', 'Ibara', 1, 'ibara', 34.60000000, 133.46667000),
(1063532, 1000820, 'JP', 'Ibara Shi', 1, 'ibara-shi', 34.65033000, 133.47371000),
(1063701, 1000820, 'JP', 'Kamogatachō-kamogata', 1, 'kamogatacho-kamogata', 34.53745000, 133.58967000),
(1063730, 1000820, 'JP', 'Kasaoka', 1, 'kasaoka', 34.50597000, 133.50391000),
(1063731, 1000820, 'JP', 'Kasaoka Shi', 1, 'kasaoka-shi', 34.51520000, 133.50618000),
(1063865, 1000820, 'JP', 'Kurashiki', 1, 'kurashiki', 34.58333000, 133.76667000),
(1063866, 1000820, 'JP', 'Kurashiki Shi', 1, 'kurashiki-shi', 34.55466000, 133.74826000),
(1063920, 1000820, 'JP', 'Maniwa-shi', 1, 'maniwa-shi', 35.13549000, 133.69358000),
(1063957, 1000820, 'JP', 'Mimasaka-shi', 1, 'mimasaka-shi', 35.04419000, 134.23052000),
(1064133, 1000820, 'JP', 'Niimi', 1, 'niimi', 34.98333000, 133.46667000),
(1064134, 1000820, 'JP', 'Niimi Shi', 1, 'niimi-shi', 35.01571000, 133.44900000),
(1064195, 1000820, 'JP', 'Okayama', 1, 'okayama', 34.65000000, 133.93333000),
(1064196, 1000820, 'JP', 'Okayama Shi', 1, 'okayama-shi', 34.71251000, 133.92329000),
(1064306, 1000820, 'JP', 'Setouchi Shi', 1, 'setouchi-shi', 34.66539000, 134.14161000),
(1064398, 1000820, 'JP', 'Sōja', 1, 'soja', 34.67534000, 133.75091000),
(1064399, 1000820, 'JP', 'Sōja Shi', 1, 'soja-shi', 34.70269000, 133.70218000),
(1064422, 1000820, 'JP', 'Takahashi', 1, 'takahashi', 34.78333000, 133.61667000),
(1064423, 1000820, 'JP', 'Takahashi Shi', 1, 'takahashi-shi', 34.82103000, 133.52435000),
(1064459, 1000820, 'JP', 'Tamano', 1, 'tamano', 34.51745000, 133.94574000),
(1064460, 1000820, 'JP', 'Tamano Shi', 1, 'tamano-shi', 34.52507000, 133.93769000),
(1064563, 1000820, 'JP', 'Tsuyama', 1, 'tsuyama', 35.05215000, 133.99885000),
(1064564, 1000820, 'JP', 'Tsuyama-shi', 1, 'tsuyama-shi', 35.14048000, 134.03181000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000853, 'JP', 'Okinawa Prefecture', 1, 'okinawa-prefecture');

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 
(1063292, 1000853, 'JP', 'Chatan', 1, 'chatan', 26.30948000, 127.77024000),
(1063387, 1000853, 'JP', 'Ginowan Shi', 1, 'ginowan-shi', 26.27620000, 127.75742000),
(1063400, 1000853, 'JP', 'Gushikawa', 1, 'gushikawa', 26.35937000, 127.86735000),
(1063493, 1000853, 'JP', 'Hirara', 1, 'hirara', 24.80379000, 125.30222000),
(1063590, 1000853, 'JP', 'Ishigaki', 1, 'ishigaki', 24.34478000, 124.15717000),
(1063591, 1000853, 'JP', 'Ishigaki-shi', 1, 'ishigaki-shi', 24.39401000, 124.20113000),
(1063596, 1000853, 'JP', 'Ishikawa', 1, 'ishikawa', 26.42333000, 127.82139000),
(1063612, 1000853, 'JP', 'Itoman', 1, 'itoman', 26.12647000, 127.66918000),
(1063613, 1000853, 'JP', 'Itoman Shi', 1, 'itoman-shi', 26.11795000, 127.68710000),
(1063757, 1000853, 'JP', 'Katsuren-haebaru', 1, 'katsuren-haebaru', 26.33294000, 127.87403000),
(1064002, 1000853, 'JP', 'Miyakojima Shi', 1, 'miyakojima-shi', 24.78574000, 125.30132000),
(1064076, 1000853, 'JP', 'Nago', 1, 'nago', 26.61502000, 127.98543000),
(1064077, 1000853, 'JP', 'Nago Shi', 1, 'nago-shi', 26.58507000, 128.02466000),
(1064079, 1000853, 'JP', 'Naha', 1, 'naha', 26.21667000, 127.68333000),
(1064080, 1000853, 'JP', 'Naha Shi', 1, 'naha-shi', 26.21077000, 127.68645000),
(1064083, 1000853, 'JP', 'Nakagami-gun', 1, 'nakagami-gun', 26.30917000, 127.77722000),
(1064100, 1000853, 'JP', 'Nanjō', 1, 'nanjo', 26.14447000, 127.76697000),
(1064101, 1000853, 'JP', 'Nanjō Shi', 1, 'nanjo-shi', 26.16371000, 127.77874000),
(1064200, 1000853, 'JP', 'Okinawa', 1, 'okinawa', 26.33583000, 127.80139000),
(1064201, 1000853, 'JP', 'Okinawa Shi', 1, 'okinawa-shi', 26.35313000, 127.80754000),
(1064504, 1000853, 'JP', 'Tomigusuku', 1, 'tomigusuku', 26.18583000, 127.68192000),
(1064505, 1000853, 'JP', 'Tomigusuku-shi', 1, 'tomigusuku-shi', 26.16667000, 127.66667000),
(1064596, 1000853, 'JP', 'Urasoe Shi', 1, 'urasoe-shi', 26.25106000, 127.71512000),
(1064600, 1000853, 'JP', 'Uruma Shi', 1, 'uruma-shi', 26.36777000, 127.87373000),
(1064677, 1000853, 'JP', 'Yonakuni', 1, 'yonakuni', 24.46667000, 123.00000000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000859, 'JP', 'Ōsaka Prefecture', 1, 'osaka-prefecture');

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 
(1063320, 1000859, 'JP', 'Daitō Shi', 1, 'daito-shi', 34.71284000, 135.63576000),
(1063321, 1000859, 'JP', 'Daitōchō', 1, 'daitocho', 34.71378000, 135.62033000),
(1063343, 1000859, 'JP', 'Fujiidera-shi', 1, 'fujiidera-shi', 34.57422000, 135.59730000),
(1063405, 1000859, 'JP', 'Habikino-shi', 1, 'habikino-shi', 34.55775000, 135.60631000),
(1063435, 1000859, 'JP', 'Hannan', 1, 'hannan', 34.33333000, 135.25000000),
(1063436, 1000859, 'JP', 'Hannan Shi', 1, 'hannan-shi', 34.33115000, 135.23521000),
(1063471, 1000859, 'JP', 'Higashiōsaka Shi', 1, 'higashiosaka-shi', 34.67112000, 135.61760000),
(1063489, 1000859, 'JP', 'Hirakata', 1, 'hirakata', 34.81352000, 135.64914000),
(1063490, 1000859, 'JP', 'Hirakata Shi', 1, 'hirakata-shi', 34.81762000, 135.68171000),
(1063533, 1000859, 'JP', 'Ibaraki', 1, 'ibaraki', 34.81641000, 135.56828000),
(1063534, 1000859, 'JP', 'Ibaraki Shi', 1, 'ibaraki-shi', 34.85588000, 135.54998000),
(1063554, 1000859, 'JP', 'Ikeda', 1, 'ikeda', 34.82208000, 135.42980000),
(1063555, 1000859, 'JP', 'Ikeda Shi', 1, 'ikeda-shi', 34.83443000, 135.43825000),
(1063640, 1000859, 'JP', 'Izumi', 1, 'izumi', 34.48333000, 135.43333000),
(1063643, 1000859, 'JP', 'Izumi Shi', 1, 'izumi-shi', 34.43135000, 135.47164000),
(1063646, 1000859, 'JP', 'Izumiōtsu', 1, 'izumiotsu', 34.50000000, 135.40000000),
(1063647, 1000859, 'JP', 'Izumiōtsu Shi', 1, 'izumiotsu-shi', 34.50647000, 135.40462000),
(1063644, 1000859, 'JP', 'Izumisano', 1, 'izumisano', 34.41667000, 135.31667000),
(1063645, 1000859, 'JP', 'Izumisano Shi', 1, 'izumisano-shi', 34.37398000, 135.33682000),
(1063655, 1000859, 'JP', 'Kadoma', 1, 'kadoma', 34.73810000, 135.57442000),
(1063656, 1000859, 'JP', 'Kadoma Shi', 1, 'kadoma-shi', 34.73215000, 135.59935000),
(1063665, 1000859, 'JP', 'Kaizuka', 1, 'kaizuka', 34.45000000, 135.35000000),
(1063666, 1000859, 'JP', 'Kaizuka Shi', 1, 'kaizuka-shi', 34.40105000, 135.38510000),
(1063734, 1000859, 'JP', 'Kashihara', 1, 'kashihara', 34.58333000, 135.61667000),
(1063741, 1000859, 'JP', 'Kashiwara-shi', 1, 'kashiwara-shi', 34.57920000, 135.62867000),
(1063753, 1000859, 'JP', 'Katano Shi', 1, 'katano-shi', 34.77215000, 135.68693000),
(1063766, 1000859, 'JP', 'Kawachi-nagano Shi', 1, 'kawachi-nagano-shi', 34.40547000, 135.56692000),
(1063795, 1000859, 'JP', 'Kishiwada', 1, 'kishiwada', 34.46667000, 135.36667000),
(1063796, 1000859, 'JP', 'Kishiwada Shi', 1, 'kishiwada-shi', 34.42747000, 135.41605000),
(1063929, 1000859, 'JP', 'Matsubara', 1, 'matsubara', 34.56667000, 135.55000000),
(1063930, 1000859, 'JP', 'Matsubara-shi', 1, 'matsubara-shi', 34.57726000, 135.55206000),
(1063976, 1000859, 'JP', 'Mino', 1, 'mino', 34.82691000, 135.47057000),
(1063981, 1000859, 'JP', 'Minoo Shi', 1, 'minoo-shi', 34.85590000, 135.47926000),
(1063987, 1000859, 'JP', 'Mishima-gun', 1, 'mishima-gun', 34.89887000, 135.65325000),
(1064029, 1000859, 'JP', 'Moriguchi', 1, 'moriguchi', 34.73333000, 135.56667000),
(1064123, 1000859, 'JP', 'Neyagawa', 1, 'neyagawa', 34.76615000, 135.62759000),
(1064124, 1000859, 'JP', 'Neyagawa Shi', 1, 'neyagawa-shi', 34.76539000, 135.62696000),
(1064214, 1000859, 'JP', 'Osaka', 1, 'osaka', 34.69374000, 135.50218000),
(1064751, 1000859, 'JP', 'Ōsaka-sayama Shi', 1, 'osaka-sayama-shi', 34.49645000, 135.54894000),
(1064256, 1000859, 'JP', 'Sakai', 1, 'sakai', 34.58333000, 135.46667000),
(1064257, 1000859, 'JP', 'Sakai Shi', 1, 'sakai-shi', 34.53166000, 135.49460000),
(1064301, 1000859, 'JP', 'Sennan Shi', 1, 'sennan-shi', 34.35164000, 135.29176000),
(1064307, 1000859, 'JP', 'Settsu Shi', 1, 'settsu-shi', 34.77220000, 135.56824000),
(1064319, 1000859, 'JP', 'Shijonawate Shi', 1, 'shijonawate-shi', 34.73242000, 135.66784000),
(1064379, 1000859, 'JP', 'Suita', 1, 'suita', 34.76143000, 135.51567000),
(1064380, 1000859, 'JP', 'Suita Shi', 1, 'suita-shi', 34.78556000, 135.51909000),
(1064417, 1000859, 'JP', 'Tajiri', 1, 'tajiri', 34.42695000, 135.24552000),
(1064425, 1000859, 'JP', 'Takaishi', 1, 'takaishi', 34.51667000, 135.43333000),
(1064426, 1000859, 'JP', 'Takaishi Shi', 1, 'takaishi-shi', 34.52868000, 135.42958000),
(1064440, 1000859, 'JP', 'Takatsuki', 1, 'takatsuki', 34.84833000, 135.61678000),
(1064441, 1000859, 'JP', 'Takatsuki Shi', 1, 'takatsuki-shi', 34.88079000, 135.60792000),
(1064512, 1000859, 'JP', 'Tondabayashi Shi', 1, 'tondabayashi-shi', 34.48882000, 135.59431000),
(1064513, 1000859, 'JP', 'Tondabayashichō', 1, 'tondabayashicho', 34.50065000, 135.60211000),
(1064529, 1000859, 'JP', 'Toyonaka', 1, 'toyonaka', 34.78244000, 135.46932000),
(1064530, 1000859, 'JP', 'Toyonaka Shi', 1, 'toyonaka-shi', 34.78191000, 135.47276000),
(1064654, 1000859, 'JP', 'Yao', 1, 'yao', 34.61667000, 135.60000000),
(1064655, 1000859, 'JP', 'Yao-shi', 1, 'yao-shi', 34.62629000, 135.60099000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000863, 'JP', 'Saga Prefecture', 1, 'saga-prefecture');

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 
(1063562, 1000863, 'JP', 'Imari Shi', 1, 'imari-shi', 33.30409000, 129.88598000),
(1063563, 1000863, 'JP', 'Imarichō-kō', 1, 'imaricho-ko', 33.27362000, 129.87877000),
(1063717, 1000863, 'JP', 'Kanzaki Shi', 1, 'kanzaki-shi', 33.34446000, 130.35883000),
(1063721, 1000863, 'JP', 'Karatsu', 1, 'karatsu', 33.44250000, 129.96972000),
(1063722, 1000863, 'JP', 'Karatsu Shi', 1, 'karatsu-shi', 33.41802000, 129.99775000),
(1063736, 1000863, 'JP', 'Kashima', 1, 'kashima', 33.10611000, 130.09056000),
(1063737, 1000863, 'JP', 'Kashima Shi', 1, 'kashima-shi', 33.06203000, 130.09396000),
(1063999, 1000863, 'JP', 'Miyaki-gun', 1, 'miyaki-gun', 33.35298000, 130.45711000),
(1064188, 1000863, 'JP', 'Ogi-shi', 1, 'ogi-shi', 33.26667000, 130.20000000),
(1064239, 1000863, 'JP', 'Saga', 1, 'saga', 33.23333000, 130.30000000),
(1064240, 1000863, 'JP', 'Saga Shi', 1, 'saga-shi', 33.32558000, 130.26430000),
(1064447, 1000863, 'JP', 'Takeo Shi', 1, 'takeo-shi', 33.20413000, 129.99775000),
(1064448, 1000863, 'JP', 'Takeochō-takeo', 1, 'takeocho-takeo', 33.19009000, 130.02084000),
(1064454, 1000863, 'JP', 'Taku Shi', 1, 'taku-shi', 33.27829000, 130.10523000),
(1064518, 1000863, 'JP', 'Tosu Shi', 1, 'tosu-shi', 33.37825000, 130.49001000),
(1064599, 1000863, 'JP', 'Ureshino Shi', 1, 'ureshino-shi', 33.09558000, 130.01495000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000860, 'JP', 'Saitama Prefecture', 1, 'saitama-prefecture');

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 
(1063218, 1000860, 'JP', 'Ageo Shi', 1, 'ageo-shi', 35.97043000, 139.58159000),
(1063219, 1000860, 'JP', 'Ageoshimo', 1, 'ageoshimo', 35.97145000, 139.61382000),
(1063260, 1000860, 'JP', 'Asaka', 1, 'asaka', 35.80472000, 139.60194000),
(1063261, 1000860, 'JP', 'Asaka-shi', 1, 'asaka-shi', 35.80000000, 139.60000000),
(1063294, 1000860, 'JP', 'Chichibu', 1, 'chichibu', 35.99028000, 139.07639000),
(1063295, 1000860, 'JP', 'Chichibu-shi', 1, 'chichibu-shi', 35.95966000, 138.93347000),
(1063345, 1000860, 'JP', 'Fujimi-shi', 1, 'fujimi-shi', 35.85393000, 139.55478000),
(1063346, 1000860, 'JP', 'Fujimino Shi', 1, 'fujimino-shi', 35.86505000, 139.51524000),
(1063358, 1000860, 'JP', 'Fukaya-shi', 1, 'fukaya-shi', 36.20000000, 139.28333000),
(1063359, 1000860, 'JP', 'Fukayachō', 1, 'fukayacho', 36.20000000, 139.28333000),
(1063360, 1000860, 'JP', 'Fukiage-fujimi', 1, 'fukiage-fujimi', 36.10000000, 139.45000000),
(1063401, 1000860, 'JP', 'Gyōda', 1, 'gyoda', 36.14074000, 139.46011000),
(1063437, 1000860, 'JP', 'Hannō', 1, 'hanno', 35.85194000, 139.31806000),
(1063438, 1000860, 'JP', 'Hannō-shi', 1, 'hanno-shi', 35.85567000, 139.32777000),
(1063439, 1000860, 'JP', 'Hanyū', 1, 'hanyu', 36.16667000, 139.53333000),
(1063440, 1000860, 'JP', 'Hanyū-shi', 1, 'hanyu-shi', 36.17251000, 139.55338000),
(1063446, 1000860, 'JP', 'Hasuda', 1, 'hasuda', 35.97113000, 139.64910000),
(1063447, 1000860, 'JP', 'Hasuda-shi', 1, 'hasuda-shi', 36.00147000, 139.64981000),
(1063448, 1000860, 'JP', 'Hatogaya-honchō', 1, 'hatogaya-honcho', 35.83314000, 139.74250000),
(1063457, 1000860, 'JP', 'Hidaka-shi', 1, 'hidaka-shi', 35.90859000, 139.34346000),
(1063464, 1000860, 'JP', 'Higashimatsuyama Shi', 1, 'higashimatsuyama-shi', 36.03183000, 139.39138000),
(1063475, 1000860, 'JP', 'Hiki-gun', 1, 'hiki-gun', 36.02757000, 139.33415000),
(1063523, 1000860, 'JP', 'Honjō', 1, 'honjo', 36.23780000, 139.19023000),
(1063524, 1000860, 'JP', 'Honjō Shi', 1, 'honjo-shi', 36.19925000, 139.14627000),
(1063579, 1000860, 'JP', 'Iruma-shi', 1, 'iruma-shi', 35.81802000, 139.36754000),
(1063635, 1000860, 'JP', 'Iwatsuki', 1, 'iwatsuki', 35.96474000, 139.69644000),
(1063688, 1000860, 'JP', 'Kamifukuoka', 1, 'kamifukuoka', 35.87266000, 139.51369000),
(1063747, 1000860, 'JP', 'Kasukabe', 1, 'kasukabe', 35.98308000, 139.74966000),
(1063748, 1000860, 'JP', 'Kasukabe Shi', 1, 'kasukabe-shi', 35.98270000, 139.77574000),
(1063768, 1000860, 'JP', 'Kawagoe', 1, 'kawagoe', 35.90861000, 139.48528000),
(1063769, 1000860, 'JP', 'Kawagoe-shi', 1, 'kawagoe-shi', 35.91149000, 139.47924000),
(1063770, 1000860, 'JP', 'Kawaguchi', 1, 'kawaguchi', 35.80521000, 139.71072000),
(1063771, 1000860, 'JP', 'Kawaguchi-shi', 1, 'kawaguchi-shi', 35.83389000, 139.73252000),
(1063778, 1000860, 'JP', 'Kazo', 1, 'kazo', 36.11667000, 139.60000000),
(1063779, 1000860, 'JP', 'Kazo-shi', 1, 'kazo-shi', 36.13670000, 139.61992000),
(1063792, 1000860, 'JP', 'Kisai', 1, 'kisai', 36.10000000, 139.58333000),
(1063810, 1000860, 'JP', 'Kitamoto Shi', 1, 'kitamoto-shi', 36.02615000, 139.53043000),
(1063822, 1000860, 'JP', 'Kodamachō-kodamaminami', 1, 'kodamacho-kodamaminami', 36.18497000, 139.13191000),
(1063898, 1000860, 'JP', 'Kōnosu', 1, 'konosu', 36.06868000, 139.51684000),
(1063844, 1000860, 'JP', 'Konosu-Shi', 1, 'konosu-shi', 36.06634000, 139.52010000),
(1063848, 1000860, 'JP', 'Koshigaya Shi', 1, 'koshigaya-shi', 35.90108000, 139.79023000),
(1063856, 1000860, 'JP', 'Kuki-shi', 1, 'kuki-shi', 36.07664000, 139.64941000),
(1063857, 1000860, 'JP', 'Kukichūō', 1, 'kukichuo', 36.06739000, 139.67498000),
(1063858, 1000860, 'JP', 'Kumagaya Shi', 1, 'kumagaya-shi', 36.16028000, 139.37256000),
(1063872, 1000860, 'JP', 'Kurihashi', 1, 'kurihashi', 36.13333000, 139.70000000),
(1063944, 1000860, 'JP', 'Menuma', 1, 'menuma', 36.22245000, 139.38205000),
(1063982, 1000860, 'JP', 'Misato Shi', 1, 'misato-shi', 35.83221000, 139.87185000),
(1064036, 1000860, 'JP', 'Morohongō', 1, 'morohongo', 35.93556000, 139.30444000),
(1064136, 1000860, 'JP', 'Niiza-shi', 1, 'niiza-shi', 35.79345000, 139.56559000),
(1064187, 1000860, 'JP', 'Ogawa', 1, 'ogawa', 36.05342000, 139.26612000),
(1064725, 1000860, 'JP', 'Ōi', 1, 'oi', 35.85091000, 139.51998000),
(1064198, 1000860, 'JP', 'Okegawa', 1, 'okegawa', 36.00000000, 139.55722000),
(1064199, 1000860, 'JP', 'Okegawa-shi', 1, 'okegawa-shi', 36.00000000, 139.55000000),
(1064754, 1000860, 'JP', 'Ōsato-gun', 1, 'osato-gun', 36.11132000, 139.20281000),
(1064250, 1000860, 'JP', 'Saitama', 1, 'saitama', 35.90807000, 139.65657000),
(1064251, 1000860, 'JP', 'Saitama-shi', 1, 'saitama-shi', 35.86100000, 139.64554000),
(1064253, 1000860, 'JP', 'Sakado', 1, 'sakado', 35.95694000, 139.38889000),
(1064254, 1000860, 'JP', 'Sakado-shi', 1, 'sakado-shi', 35.96776000, 139.40595000),
(1064293, 1000860, 'JP', 'Satte', 1, 'satte', 36.07254000, 139.72615000),
(1064294, 1000860, 'JP', 'Satte Shi', 1, 'satte-shi', 36.07081000, 139.74022000),
(1064296, 1000860, 'JP', 'Sayama', 1, 'sayama', 35.85295000, 139.41212000),
(1064320, 1000860, 'JP', 'Shiki', 1, 'shiki', 35.83333000, 139.58333000),
(1064321, 1000860, 'JP', 'Shiki Shi', 1, 'shiki-shi', 35.83698000, 139.58347000),
(1064335, 1000860, 'JP', 'Shimotoda', 1, 'shimotoda', 35.81500000, 139.68530000),
(1064355, 1000860, 'JP', 'Shiraoka', 1, 'shiraoka', 36.01839000, 139.66034000),
(1064356, 1000860, 'JP', 'Shiraoka-shi', 1, 'shiraoka-shi', 36.01667000, 139.66667000),
(1064370, 1000860, 'JP', 'Shōbu', 1, 'shobu', 36.06667000, 139.60000000),
(1064400, 1000860, 'JP', 'Sōka', 1, 'soka', 35.83643000, 139.79957000),
(1064401, 1000860, 'JP', 'Sōka Shi', 1, 'soka-shi', 35.83868000, 139.80216000),
(1064377, 1000860, 'JP', 'Sugito', 1, 'sugito', 36.03107000, 139.72636000),
(1064489, 1000860, 'JP', 'Toda-shi', 1, 'toda-shi', 35.81477000, 139.65699000),
(1064495, 1000860, 'JP', 'Tokorozawa', 1, 'tokorozawa', 35.79916000, 139.46903000),
(1064496, 1000860, 'JP', 'Tokorozawa-shi', 1, 'tokorozawa-shi', 35.79968000, 139.45817000),
(1064555, 1000860, 'JP', 'Tsurugashima-shi', 1, 'tsurugashima-shi', 35.93571000, 139.39456000),
(1064621, 1000860, 'JP', 'Wako', 1, 'wako', 35.78944000, 139.62333000),
(1064623, 1000860, 'JP', 'Wakō-shi', 1, 'wako-shi', 35.78934000, 139.61988000),
(1064624, 1000860, 'JP', 'Warabi-shi', 1, 'warabi-shi', 35.82526000, 139.68550000),
(1064656, 1000860, 'JP', 'Yashio', 1, 'yashio', 35.82255000, 139.83905000),
(1064657, 1000860, 'JP', 'Yashio-shi', 1, 'yashio-shi', 35.80918000, 139.84669000),
(1064681, 1000860, 'JP', 'Yono', 1, 'yono', 35.88333000, 139.63333000),
(1064682, 1000860, 'JP', 'Yorii', 1, 'yorii', 36.11567000, 139.19429000),
(1064685, 1000860, 'JP', 'Yoshikawa', 1, 'yoshikawa', 35.89232000, 139.84184000),
(1064686, 1000860, 'JP', 'Yoshikawa Shi', 1, 'yoshikawa-shi', 35.89512000, 139.86090000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000845, 'JP', 'Shiga Prefecture', 1, 'shiga-prefecture');

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 
(1063470, 1000845, 'JP', 'Higashiōmi-shi', 1, 'higashiomi-shi', 35.10890000, 136.17920000),
(1063476, 1000845, 'JP', 'Hikone', 1, 'hikone', 35.25000000, 136.25000000),
(1063477, 1000845, 'JP', 'Hikone-shi', 1, 'hikone-shi', 35.23036000, 136.20760000),
(1063482, 1000845, 'JP', 'Hino', 1, 'hino', 35.00000000, 136.25000000),
(1063799, 1000845, 'JP', 'Kitahama', 1, 'kitahama', 35.16667000, 135.91667000),
(1063895, 1000845, 'JP', 'Kōka-shi', 1, 'koka-shi', 34.91667000, 136.16667000),
(1063843, 1000845, 'JP', 'Konan-shi', 1, 'konan-shi', 35.01667000, 136.08333000),
(1063881, 1000845, 'JP', 'Kusatsu', 1, 'kusatsu', 35.01667000, 135.96667000),
(1063882, 1000845, 'JP', 'Kusatsu-shi', 1, 'kusatsu-shi', 35.02758000, 135.93840000),
(1063910, 1000845, 'JP', 'Maibara', 1, 'maibara', 35.31667000, 136.28333000),
(1063911, 1000845, 'JP', 'Maibara-shi', 1, 'maibara-shi', 35.38457000, 136.37741000),
(1063958, 1000845, 'JP', 'Minakuchichō-matoba', 1, 'minakuchicho-matoba', 34.96667000, 136.16667000),
(1064034, 1000845, 'JP', 'Moriyama', 1, 'moriyama', 35.06667000, 135.98333000),
(1064035, 1000845, 'JP', 'Moriyama-shi', 1, 'moriyama-shi', 35.08815000, 135.96869000),
(1064059, 1000845, 'JP', 'Nagahama', 1, 'nagahama', 35.38333000, 136.26667000),
(1064060, 1000845, 'JP', 'Nagahama-shi', 1, 'nagahama-shi', 35.42256000, 136.26272000),
(1064740, 1000845, 'JP', 'Ōmihachiman', 1, 'omihachiman', 35.12861000, 136.09760000),
(1064741, 1000845, 'JP', 'Ōmihachiman-shi', 1, 'omihachiman-shi', 35.15251000, 136.06964000),
(1064764, 1000845, 'JP', 'Ōtsu-shi', 1, 'otsu-shi', 35.10203000, 135.92452000),
(1064229, 1000845, 'JP', 'Rittō-shi', 1, 'ritto-shi', 34.99603000, 136.01412000),
(1064438, 1000845, 'JP', 'Takashima', 1, 'takashima', 35.41347000, 136.01612000),
(1064439, 1000845, 'JP', 'Takashima-shi', 1, 'takashima-shi', 35.35448000, 136.02859000),
(1064659, 1000845, 'JP', 'Yasu-shi', 1, 'yasu-shi', 35.06801000, 136.02327000),
(1064692, 1000845, 'JP', 'Youkaichi', 1, 'youkaichi', 35.11626000, 136.19768000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000826, 'JP', 'Shimane Prefecture', 1, 'shimane-prefecture');

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 
(1063403, 1000826, 'JP', 'Gōtsu Shi', 1, 'gotsu-shi', 34.98095000, 132.29488000),
(1063404, 1000826, 'JP', 'Gōtsuchō', 1, 'gotsucho', 35.00856000, 132.22570000),
(1063423, 1000826, 'JP', 'Hamada', 1, 'hamada', 34.88333000, 132.08333000),
(1063424, 1000826, 'JP', 'Hamada Shi', 1, 'hamada-shi', 34.82809000, 132.13914000),
(1063494, 1000826, 'JP', 'Hiratachō', 1, 'hiratacho', 35.43333000, 132.81667000),
(1063648, 1000826, 'JP', 'Izumo', 1, 'izumo', 35.36667000, 132.76667000),
(1063649, 1000826, 'JP', 'Izumo Shi', 1, 'izumo-shi', 35.33858000, 132.73903000),
(1063927, 1000826, 'JP', 'Masuda', 1, 'masuda', 34.66667000, 131.85000000),
(1063928, 1000826, 'JP', 'Masuda Shi', 1, 'masuda-shi', 34.62909000, 131.94590000),
(1063933, 1000826, 'JP', 'Matsue', 1, 'matsue', 35.48333000, 133.05000000),
(1063934, 1000826, 'JP', 'Matsue Shi', 1, 'matsue-shi', 35.47702000, 133.05917000),
(1064717, 1000826, 'JP', 'Ōda Shi', 1, 'oda-shi', 35.13958000, 132.48811000),
(1064718, 1000826, 'JP', 'Ōdachō-ōda', 1, 'odacho-oda', 35.19025000, 132.50846000),
(1064590, 1000826, 'JP', 'Unnan Shi', 1, 'unnan-shi', 35.24918000, 132.89478000),
(1064660, 1000826, 'JP', 'Yasugi Shi', 1, 'yasugi-shi', 35.33570000, 133.19761000),
(1064661, 1000826, 'JP', 'Yasugichō', 1, 'yasugicho', 35.42146000, 133.24224000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000825, 'JP', 'Shizuoka Prefecture', 1, 'shizuoka-prefecture');

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 
(1063270, 1000825, 'JP', 'Atami', 1, 'atami', 35.08834000, 139.05325000),
(1063271, 1000825, 'JP', 'Atami-shi', 1, 'atami-shi', 35.08957000, 139.06357000),
(1063340, 1000825, 'JP', 'Fuji Shi', 1, 'fuji-shi', 35.20106000, 138.69905000),
(1063342, 1000825, 'JP', 'Fujieda Shi', 1, 'fujieda-shi', 34.91956000, 138.23379000),
(1063347, 1000825, 'JP', 'Fujinomiya', 1, 'fujinomiya', 35.21667000, 138.61667000),
(1063348, 1000825, 'JP', 'Fujinomiya Shi', 1, 'fujinomiya-shi', 35.31753000, 138.62375000),
(1063368, 1000825, 'JP', 'Fukuroi', 1, 'fukuroi', 34.75000000, 137.91667000),
(1063369, 1000825, 'JP', 'Fukuroi-shi', 1, 'fukuroi-shi', 34.74175000, 137.92805000),
(1063396, 1000825, 'JP', 'Gotenba Shi', 1, 'gotenba-shi', 35.29893000, 138.87902000),
(1063425, 1000825, 'JP', 'Hamakita', 1, 'hamakita', 34.80000000, 137.78333000),
(1063426, 1000825, 'JP', 'Hamamatsu', 1, 'hamamatsu', 34.70000000, 137.73333000),
(1063427, 1000825, 'JP', 'Hamamatsu-shi', 1, 'hamamatsu-shi', 34.95375000, 137.80733000),
(1063452, 1000825, 'JP', 'Heda', 1, 'heda', 34.96277000, 138.78543000),
(1063616, 1000825, 'JP', 'Itō', 1, 'ito', 34.96667000, 139.08333000),
(1063617, 1000825, 'JP', 'Itō Shi', 1, 'ito-shi', 34.93563000, 139.08725000),
(1063632, 1000825, 'JP', 'Iwata', 1, 'iwata', 34.70000000, 137.85000000),
(1063633, 1000825, 'JP', 'Iwata-shi', 1, 'iwata-shi', 34.74451000, 137.85043000),
(1063638, 1000825, 'JP', 'Izu', 1, 'izu', 34.97159000, 138.94643000),
(1063639, 1000825, 'JP', 'Izu-shi', 1, 'izu-shi', 34.92201000, 138.92585000),
(1063650, 1000825, 'JP', 'Izunokuni-shi', 1, 'izunokuni-shi', 35.03799000, 138.97295000),
(1063669, 1000825, 'JP', 'Kakegawa', 1, 'kakegawa', 34.76667000, 138.01667000),
(1063670, 1000825, 'JP', 'Kakegawa Shi', 1, 'kakegawa-shi', 34.77993000, 138.01897000),
(1063705, 1000825, 'JP', 'Kanaya', 1, 'kanaya', 34.82022000, 138.12775000),
(1063786, 1000825, 'JP', 'Kikugawa-shi', 1, 'kikugawa-shi', 34.75000000, 138.10000000),
(1063845, 1000825, 'JP', 'Kosai', 1, 'kosai', 34.70053000, 137.52253000),
(1063846, 1000825, 'JP', 'Kosai-shi', 1, 'kosai-shi', 34.73092000, 137.51643000),
(1063916, 1000825, 'JP', 'Makinohara Shi', 1, 'makinohara-shi', 34.73226000, 138.18567000),
(1063985, 1000825, 'JP', 'Mishima', 1, 'mishima', 35.11667000, 138.91667000),
(1063986, 1000825, 'JP', 'Mishima Shi', 1, 'mishima-shi', 35.13940000, 138.94882000),
(1064028, 1000825, 'JP', 'Mori', 1, 'mori', 34.83333000, 137.93333000),
(1064172, 1000825, 'JP', 'Numazu-shi', 1, 'numazu-shi', 35.09491000, 138.86667000),
(1064203, 1000825, 'JP', 'Omaezaki-shi', 1, 'omaezaki-shi', 34.60000000, 138.21667000),
(1064768, 1000825, 'JP', 'Ōyama', 1, 'oyama', 34.60359000, 138.21719000),
(1064244, 1000825, 'JP', 'Sagara', 1, 'sagara', 34.68503000, 138.20461000),
(1064327, 1000825, 'JP', 'Shimada', 1, 'shimada', 34.81667000, 138.18333000),
(1064328, 1000825, 'JP', 'Shimada-shi', 1, 'shimada-shi', 34.91220000, 138.12662000),
(1064330, 1000825, 'JP', 'Shimoda', 1, 'shimoda', 34.67652000, 138.94456000),
(1064331, 1000825, 'JP', 'Shimoda-shi', 1, 'shimoda-shi', 34.70879000, 138.92148000),
(1064366, 1000825, 'JP', 'Shizuoka', 1, 'shizuoka', 34.98333000, 138.38333000),
(1064367, 1000825, 'JP', 'Shizuoka-shi', 1, 'shizuoka-shi', 35.20164000, 138.31426000),
(1064388, 1000825, 'JP', 'Susono', 1, 'susono', 35.17388000, 138.90691000),
(1064389, 1000825, 'JP', 'Susono Shi', 1, 'susono-shi', 35.22551000, 138.87734000),
(1064634, 1000825, 'JP', 'Yaizu', 1, 'yaizu', 34.86877000, 138.31952000),
(1064635, 1000825, 'JP', 'Yaizu Shi', 1, 'yaizu-shi', 34.84008000, 138.30127000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000854, 'JP', 'Tochigi Prefecture', 1, 'tochigi-prefecture');

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 
(1063266, 1000854, 'JP', 'Ashikaga', 1, 'ashikaga', 36.33333000, 139.45000000),
(1063349, 1000854, 'JP', 'Fujioka', 1, 'fujioka', 36.25000000, 139.65000000),
(1063561, 1000854, 'JP', 'Imaichi', 1, 'imaichi', 36.71667000, 139.68333000),
(1063694, 1000854, 'JP', 'Kaminokawa', 1, 'kaminokawa', 36.43333000, 139.91667000),
(1063715, 1000854, 'JP', 'Kanuma', 1, 'kanuma', 36.55000000, 139.73333000),
(1063716, 1000854, 'JP', 'Kanuma-shi', 1, 'kanuma-shi', 36.57550000, 139.64149000),
(1063720, 1000854, 'JP', 'Karasuyama', 1, 'karasuyama', 36.65000000, 140.15000000),
(1063878, 1000854, 'JP', 'Kuroiso', 1, 'kuroiso', 36.96667000, 140.05000000),
(1063926, 1000854, 'JP', 'Mashiko', 1, 'mashiko', 36.46667000, 140.10000000),
(1063945, 1000854, 'JP', 'Mibu', 1, 'mibu', 36.41667000, 139.80000000),
(1064026, 1000854, 'JP', 'Mooka', 1, 'mooka', 36.43333000, 140.01667000),
(1064027, 1000854, 'JP', 'Mooka-shi', 1, 'mooka-shi', 36.45000000, 140.05000000),
(1064037, 1000854, 'JP', 'Motegi', 1, 'motegi', 36.51667000, 140.18333000),
(1064113, 1000854, 'JP', 'Nasukarasuyama', 1, 'nasukarasuyama', 36.65233000, 140.16084000),
(1064114, 1000854, 'JP', 'Nasukarasuyama-shi', 1, 'nasukarasuyama-shi', 36.66270000, 140.13405000),
(1064115, 1000854, 'JP', 'Nasushiobara-shi', 1, 'nasushiobara-shi', 36.99085000, 139.91052000),
(1064139, 1000854, 'JP', 'Nikkō', 1, 'nikko', 36.75000000, 139.61667000),
(1064138, 1000854, 'JP', 'Nikko-shi', 1, 'nikko-shi', 36.75000000, 139.70000000),
(1064762, 1000854, 'JP', 'Ōtawara', 1, 'otawara', 36.86667000, 140.03333000),
(1064763, 1000854, 'JP', 'Ōtawara-shi', 1, 'otawara-shi', 36.86129000, 140.11915000),
(1064222, 1000854, 'JP', 'Oyama', 1, 'oyama', 36.30000000, 139.80000000),
(1064223, 1000854, 'JP', 'Oyama-shi', 1, 'oyama-shi', 36.30800000, 139.80195000),
(1064270, 1000854, 'JP', 'Sakura-shi', 1, 'sakura-shi', 36.72362000, 140.00289000),
(1064281, 1000854, 'JP', 'Sano', 1, 'sano', 36.31667000, 139.58333000),
(1064282, 1000854, 'JP', 'Sano-shi', 1, 'sano-shi', 36.42406000, 139.53578000),
(1064336, 1000854, 'JP', 'Shimotsuke-shi', 1, 'shimotsuke-shi', 36.40291000, 139.86111000),
(1064467, 1000854, 'JP', 'Tanuma', 1, 'tanuma', 36.36667000, 139.58333000),
(1064487, 1000854, 'JP', 'Tochigi-shi', 1, 'tochigi-shi', 36.41128000, 139.69357000),
(1064586, 1000854, 'JP', 'Ujiie', 1, 'ujiie', 36.68333000, 139.96667000),
(1064611, 1000854, 'JP', 'Utsunomiya', 1, 'utsunomiya', 36.56667000, 139.88333000),
(1064612, 1000854, 'JP', 'Utsunomiya-shi', 1, 'utsunomiya-shi', 36.59688000, 139.88657000),
(1064632, 1000854, 'JP', 'Yaita', 1, 'yaita', 36.80000000, 139.93333000),
(1064633, 1000854, 'JP', 'Yaita-shi', 1, 'yaita-shi', 36.82746000, 139.89809000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000836, 'JP', 'Tokushima Prefecture', 1, 'tokushima-prefecture');

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 
(1063245, 1000836, 'JP', 'Anan Shi', 1, 'anan-shi', 33.87716000, 134.60644000),
(1063274, 1000836, 'JP', 'Awa-shi', 1, 'awa-shi', 34.10000000, 134.25000000),
(1063556, 1000836, 'JP', 'Ikedachō', 1, 'ikedacho', 34.02849000, 133.80616000),
(1063593, 1000836, 'JP', 'Ishii', 1, 'ishii', 34.06752000, 134.44208000),
(1063704, 1000836, 'JP', 'Kamojimachō-jōgejima', 1, 'kamojimacho-jogejima', 34.06803000, 134.35033000),
(1063761, 1000836, 'JP', 'Katsuura Gun', 1, 'katsuura-gun', 33.91380000, 134.42641000),
(1063838, 1000836, 'JP', 'Komatsushima Shi', 1, 'komatsushima-shi', 33.98071000, 134.59529000),
(1063839, 1000836, 'JP', 'Komatsushimachō', 1, 'komatsushimacho', 34.00000000, 134.58333000),
(1063956, 1000836, 'JP', 'Mima Shi', 1, 'mima-shi', 34.01889000, 134.14333000),
(1064015, 1000836, 'JP', 'Miyoshi Shi', 1, 'miyoshi-shi', 33.93349000, 133.85184000),
(1064016, 1000836, 'JP', 'Miyoshi-gun', 1, 'miyoshi-gun', 34.03647000, 133.91818000),
(1064110, 1000836, 'JP', 'Naruto-shi', 1, 'naruto-shi', 34.17881000, 134.61357000),
(1064111, 1000836, 'JP', 'Narutochō-mitsuishi', 1, 'narutocho-mitsuishi', 34.19933000, 134.60932000),
(1064497, 1000836, 'JP', 'Tokushima', 1, 'tokushima', 34.06667000, 134.56667000),
(1064498, 1000836, 'JP', 'Tokushima Shi', 1, 'tokushima-shi', 34.04922000, 134.52359000),
(1064618, 1000836, 'JP', 'Wakimachi', 1, 'wakimachi', 34.06667000, 134.15000000),
(1064688, 1000836, 'JP', 'Yoshinogawa Shi', 1, 'yoshinogawa-shi', 34.03705000, 134.28354000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000823, 'JP', 'Tokyo', 1, 'tokyo');

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 
(1063215, 1000823, 'JP', 'Adachi Ku', 1, 'adachi-ku', 35.77880000, 139.79509000),
(1063231, 1000823, 'JP', 'Akiruno-shi', 1, 'akiruno-shi', 35.73285000, 139.22525000),
(1063232, 1000823, 'JP', 'Akishima-shi', 1, 'akishima-shi', 35.70782000, 139.36418000),
(1063252, 1000823, 'JP', 'Arakawa Ku', 1, 'arakawa-ku', 35.73993000, 139.78130000),
(1063289, 1000823, 'JP', 'Bunkyō-ku', 1, 'bunkyo-ku', 35.71745000, 139.74729000),
(1063311, 1000823, 'JP', 'Chiyoda-ku', 1, 'chiyoda-ku', 35.69402000, 139.75363000),
(1063312, 1000823, 'JP', 'Chōfu', 1, 'chofu', 35.65924000, 139.54837000),
(1063313, 1000823, 'JP', 'Chōfu-shi', 1, 'chofu-shi', 35.65000000, 139.55000000),
(1063315, 1000823, 'JP', 'Chūō Ku', 1, 'chuo-ku', 35.66993000, 139.77705000),
(1063330, 1000823, 'JP', 'Edogawa Ku', 1, 'edogawa-ku', 35.69242000, 139.87567000),
(1063336, 1000823, 'JP', 'Fuchū-shi', 1, 'fuchu-shi', 35.66667000, 139.50000000),
(1063380, 1000823, 'JP', 'Fussa', 1, 'fussa', 35.73667000, 139.32361000),
(1063410, 1000823, 'JP', 'Hachiōji', 1, 'hachioji', 35.65583000, 139.32389000),
(1063429, 1000823, 'JP', 'Hamura-shi', 1, 'hamura-shi', 35.76351000, 139.31411000),
(1063458, 1000823, 'JP', 'Higashi-murayama-shi', 1, 'higashi-murayama-shi', 35.75529000, 139.46972000),
(1063461, 1000823, 'JP', 'Higashikurume-shi', 1, 'higashikurume-shi', 35.75821000, 139.52954000),
(1063465, 1000823, 'JP', 'Higashimurayama', 1, 'higashimurayama', 35.75459000, 139.46852000),
(1063468, 1000823, 'JP', 'Higashiyamato', 1, 'higashiyamato', 35.76298000, 139.44575000),
(1063469, 1000823, 'JP', 'Higashiyamato-shi', 1, 'higashiyamato-shi', 35.75031000, 139.42660000),
(1063483, 1000823, 'JP', 'Hino', 1, 'hino', 35.67306000, 139.40028000),
(1063484, 1000823, 'JP', 'Hino-shi', 1, 'hino-shi', 35.66333000, 139.39865000),
(1063569, 1000823, 'JP', 'Inagi-shi', 1, 'inagi-shi', 35.63290000, 139.49291000),
(1063605, 1000823, 'JP', 'Itabashi-ku', 1, 'itabashi-ku', 35.75118000, 139.70927000),
(1063615, 1000823, 'JP', 'Itsukaichi', 1, 'itsukaichi', 35.72528000, 139.21778000),
(1063697, 1000823, 'JP', 'Kamirenjaku', 1, 'kamirenjaku', 35.69423000, 139.55495000),
(1063758, 1000823, 'JP', 'Katsushika Ku', 1, 'katsushika-ku', 35.75324000, 139.85567000),
(1063797, 1000823, 'JP', 'Kita-ku', 1, 'kita-ku', 35.75264000, 139.73348000),
(1063815, 1000823, 'JP', 'Kiyose-shi', 1, 'kiyose-shi', 35.78551000, 139.52628000),
(1063821, 1000823, 'JP', 'Kodaira-shi', 1, 'kodaira-shi', 35.72738000, 139.48173000),
(1063827, 1000823, 'JP', 'Koganei-shi', 1, 'koganei-shi', 35.70108000, 139.51104000),
(1063830, 1000823, 'JP', 'Kokubunji', 1, 'kokubunji', 35.70222000, 139.47556000),
(1063831, 1000823, 'JP', 'Kokubunji-shi', 1, 'kokubunji-shi', 35.70552000, 139.46125000),
(1063832, 1000823, 'JP', 'Komae-shi', 1, 'komae-shi', 35.63487000, 139.57723000),
(1063903, 1000823, 'JP', 'Kōtō-ku', 1, 'koto-ku', 35.66667000, 139.81667000),
(1063864, 1000823, 'JP', 'Kunitachi-shi', 1, 'kunitachi-shi', 35.68634000, 139.43878000),
(1063905, 1000823, 'JP', 'Machida', 1, 'machida', 35.54028000, 139.45083000),
(1063906, 1000823, 'JP', 'Machida-shi', 1, 'machida-shi', 35.57626000, 139.42998000),
(1063943, 1000823, 'JP', 'Meguro-ku', 1, 'meguro-ku', 35.64146000, 139.69817000),
(1063974, 1000823, 'JP', 'Minato-ku', 1, 'minato-ku', 35.65000000, 139.73333000),
(1063988, 1000823, 'JP', 'Mitaka-shi', 1, 'mitaka-shi', 35.68351000, 139.55963000),
(1064051, 1000823, 'JP', 'Musashimurayama-shi', 1, 'musashimurayama-shi', 35.75037000, 139.38391000),
(1064052, 1000823, 'JP', 'Musashino', 1, 'musashino', 35.70611000, 139.55944000),
(1064053, 1000823, 'JP', 'Musashino-shi', 1, 'musashino-shi', 35.71771000, 139.56600000),
(1064087, 1000823, 'JP', 'Nakano-ku', 1, 'nakano-ku', 35.71091000, 139.66248000),
(1064122, 1000823, 'JP', 'Nerima-ku', 1, 'nerima-ku', 35.73551000, 139.65168000),
(1064146, 1000823, 'JP', 'Nishi-Tokyo-shi', 1, 'nishi-tokyo-shi', 35.72526000, 139.53830000),
(1064155, 1000823, 'JP', 'Nishitōkyō-shi', 1, 'nishitokyo-shi', 35.73485000, 139.54624000),
(1064738, 1000823, 'JP', 'Ōme', 1, 'ome', 35.78389000, 139.24306000),
(1064739, 1000823, 'JP', 'Ōme-shi', 1, 'ome-shi', 35.78814000, 139.27501000),
(1064758, 1000823, 'JP', 'Ōta-ku', 1, 'ota-ku', 35.56126000, 139.71605000),
(1064302, 1000823, 'JP', 'Setagaya-ku', 1, 'setagaya-ku', 35.64657000, 139.65325000),
(1064316, 1000823, 'JP', 'Shibuya-ku', 1, 'shibuya-ku', 35.66404000, 139.69821000),
(1064338, 1000823, 'JP', 'Shinagawa-ku', 1, 'shinagawa-ku', 35.60902000, 139.73017000),
(1064342, 1000823, 'JP', 'Shinjuku-ku', 1, 'shinjuku-ku', 35.69384000, 139.70355000),
(1064376, 1000823, 'JP', 'Suginami-ku', 1, 'suginami-ku', 35.69951000, 139.63641000),
(1064383, 1000823, 'JP', 'Sumida-ku', 1, 'sumida-ku', 35.71072000, 139.80150000),
(1064405, 1000823, 'JP', 'Tachikawa-shi', 1, 'tachikawa-shi', 35.71447000, 139.40453000),
(1064414, 1000823, 'JP', 'Taitō-ku', 1, 'taito-ku', 35.71261000, 139.78000000),
(1064455, 1000823, 'JP', 'Tama-shi', 1, 'tama-shi', 35.63054000, 139.43976000),
(1064465, 1000823, 'JP', 'Tanashichō', 1, 'tanashicho', 35.72922000, 139.53813000),
(1064500, 1000823, 'JP', 'Tokyo', 1, 'tokyo', 35.68950000, 139.69171000),
(1064517, 1000823, 'JP', 'Toshima-ku', 1, 'toshima-ku', 35.73246000, 139.71540000),
(1064597, 1000823, 'JP', 'Urayasu', 1, 'urayasu', 35.67056000, 139.88861000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000850, 'JP', 'Tottori Prefecture', 1, 'tottori-prefecture');

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 
(1063867, 1000850, 'JP', 'Kurayoshi-shi', 1, 'kurayoshi-shi', 35.39110000, 133.74577000),
(1064262, 1000850, 'JP', 'Sakaiminato', 1, 'sakaiminato', 35.53774000, 133.23094000),
(1064263, 1000850, 'JP', 'Sakaiminato Shi', 1, 'sakaiminato-shi', 35.52034000, 133.22704000),
(1064519, 1000850, 'JP', 'Tottori-shi', 1, 'tottori-shi', 35.43255000, 134.15576000),
(1064676, 1000850, 'JP', 'Yonago Shi', 1, 'yonago-shi', 35.43486000, 133.35873000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000838, 'JP', 'Toyama Prefecture', 1, 'toyama-prefecture');

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 
(1063364, 1000838, 'JP', 'Fukumitsu', 1, 'fukumitsu', 36.55751000, 136.86945000),
(1063480, 1000838, 'JP', 'Himi Shi', 1, 'himi-shi', 36.87218000, 136.94066000),
(1063481, 1000838, 'JP', 'Himimachi', 1, 'himimachi', 36.85609000, 136.98850000),
(1063564, 1000838, 'JP', 'Imizu Shi', 1, 'imizu-shi', 36.72939000, 137.08784000),
(1063690, 1000838, 'JP', 'Kamiichi', 1, 'kamiichi', 36.70000000, 137.36667000),
(1063874, 1000838, 'JP', 'Kurobe-shi', 1, 'kurobe-shi', 36.90123000, 137.44955000),
(1064095, 1000838, 'JP', 'Namerikawa', 1, 'namerikawa', 36.75965000, 137.36215000),
(1064096, 1000838, 'JP', 'Namerikawa-shi', 1, 'namerikawa-shi', 36.74934000, 137.38129000),
(1064103, 1000838, 'JP', 'Nanto Shi', 1, 'nanto-shi', 36.45260000, 136.91430000),
(1064104, 1000838, 'JP', 'Nanto-shi', 1, 'nanto-shi', 36.56922000, 136.91162000),
(1064154, 1000838, 'JP', 'Nishishinminato', 1, 'nishishinminato', 36.77957000, 137.07576000),
(1064173, 1000838, 'JP', 'Nyūzen', 1, 'nyuzen', 36.93744000, 137.50059000),
(1064220, 1000838, 'JP', 'Oyabe', 1, 'oyabe', 36.66667000, 136.85000000),
(1064221, 1000838, 'JP', 'Oyabe Shi', 1, 'oyabe-shi', 36.66349000, 136.85499000),
(1064431, 1000838, 'JP', 'Takaoka', 1, 'takaoka', 36.75000000, 137.01667000),
(1064432, 1000838, 'JP', 'Takaoka Shi', 1, 'takaoka-shi', 36.74257000, 136.96263000),
(1064511, 1000838, 'JP', 'Tonami Shi', 1, 'tonami-shi', 36.62395000, 136.98899000),
(1064521, 1000838, 'JP', 'Toyama Shi', 1, 'toyama-shi', 36.55146000, 137.29872000),
(1064594, 1000838, 'JP', 'Uozu', 1, 'uozu', 36.80000000, 137.40000000),
(1064595, 1000838, 'JP', 'Uozu Shi', 1, 'uozu-shi', 36.76234000, 137.48984000),
(1064663, 1000838, 'JP', 'Yatsuomachi-higashikumisaka', 1, 'yatsuomachi-higashikumisaka', 36.56667000, 137.13333000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000844, 'JP', 'Wakayama Prefecture', 1, 'wakayama-prefecture');

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 
(1063255, 1000844, 'JP', 'Arida Shi', 1, 'arida-shi', 34.07937000, 135.14230000),
(1063388, 1000844, 'JP', 'Gobō', 1, 'gobo', 33.88153000, 135.16960000),
(1063444, 1000844, 'JP', 'Hashimoto', 1, 'hashimoto', 34.31667000, 135.61667000),
(1063445, 1000844, 'JP', 'Hashimoto Shi', 1, 'hashimoto-shi', 34.32417000, 135.61045000),
(1063618, 1000844, 'JP', 'Iwade', 1, 'iwade', 34.25000000, 135.31667000),
(1063619, 1000844, 'JP', 'Iwade Shi', 1, 'iwade-shi', 34.28089000, 135.30560000),
(1063662, 1000844, 'JP', 'Kainan', 1, 'kainan', 34.15166000, 135.21398000),
(1063663, 1000844, 'JP', 'Kainan Shi', 1, 'kainan-shi', 34.14182000, 135.22400000),
(1063788, 1000844, 'JP', 'Kinokawa Shi', 1, 'kinokawa-shi', 34.25400000, 135.39412000),
(1063904, 1000844, 'JP', 'Kōya', 1, 'koya', 34.21294000, 135.62244000),
(1063973, 1000844, 'JP', 'Minato', 1, 'minato', 34.21520000, 135.15010000),
(1064339, 1000844, 'JP', 'Shingū', 1, 'shingu', 33.73333000, 135.98333000),
(1064341, 1000844, 'JP', 'Shingū-shi', 1, 'shingu-shi', 33.76663000, 135.85863000),
(1064464, 1000844, 'JP', 'Tanabe-shi', 1, 'tanabe-shi', 33.82731000, 135.57786000),
(1064616, 1000844, 'JP', 'Wakayama', 1, 'wakayama', 34.23333000, 135.16667000),
(1064617, 1000844, 'JP', 'Wakayama Shi', 1, 'wakayama-shi', 34.24252000, 135.19595000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000837, 'JP', 'Yamagata Prefecture', 1, 'yamagata-prefecture');

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 
(1063466, 1000837, 'JP', 'Higashine', 1, 'higashine', 38.43889000, 140.40056000),
(1063467, 1000837, 'JP', 'Higashine Shi', 1, 'higashine-shi', 38.42559000, 140.46670000),
(1063695, 1000837, 'JP', 'Kaminoyama', 1, 'kaminoyama', 38.15389000, 140.27361000),
(1063696, 1000837, 'JP', 'Kaminoyama-shi', 1, 'kaminoyama-shi', 38.13333000, 140.33333000),
(1064047, 1000837, 'JP', 'Murayama', 1, 'murayama', 38.46972000, 140.41441000),
(1064048, 1000837, 'JP', 'Murayama Shi', 1, 'murayama-shi', 38.51671000, 140.33518000),
(1064061, 1000837, 'JP', 'Nagai', 1, 'nagai', 38.10361000, 140.03500000),
(1064062, 1000837, 'JP', 'Nagai-shi', 1, 'nagai-shi', 38.16667000, 140.00000000),
(1064105, 1000837, 'JP', 'Nanyō Shi', 1, 'nanyo-shi', 38.10319000, 140.15609000),
(1064178, 1000837, 'JP', 'Obanazawa', 1, 'obanazawa', 38.60333000, 140.40194000),
(1064179, 1000837, 'JP', 'Obanazawa Shi', 1, 'obanazawa-shi', 38.59362000, 140.47681000),
(1064241, 1000837, 'JP', 'Sagae', 1, 'sagae', 38.37250000, 140.27250000),
(1064242, 1000837, 'JP', 'Sagae-shi', 1, 'sagae-shi', 38.45000000, 140.23333000),
(1064264, 1000837, 'JP', 'Sakata', 1, 'sakata', 38.91667000, 139.85500000),
(1064265, 1000837, 'JP', 'Sakata Shi', 1, 'sakata-shi', 38.92490000, 139.98427000),
(1064343, 1000837, 'JP', 'Shinjō', 1, 'shinjo', 38.75861000, 140.30083000),
(1064344, 1000837, 'JP', 'Shinjō Shi', 1, 'shinjo-shi', 38.78819000, 140.33989000),
(1064424, 1000837, 'JP', 'Takahata', 1, 'takahata', 38.00250000, 140.19111000),
(1064480, 1000837, 'JP', 'Tendō', 1, 'tendo', 38.35361000, 140.36972000),
(1064481, 1000837, 'JP', 'Tendō Shi', 1, 'tendo-shi', 38.35819000, 140.39652000),
(1064557, 1000837, 'JP', 'Tsuruoka', 1, 'tsuruoka', 38.72167000, 139.82167000),
(1064558, 1000837, 'JP', 'Tsuruoka Shi', 1, 'tsuruoka-shi', 38.58507000, 139.80839000),
(1064638, 1000837, 'JP', 'Yamagata', 1, 'yamagata', 38.23333000, 140.36667000),
(1064639, 1000837, 'JP', 'Yamagata Shi', 1, 'yamagata-shi', 38.24907000, 140.37272000),
(1064679, 1000837, 'JP', 'Yonezawa', 1, 'yonezawa', 37.91000000, 140.11667000),
(1064680, 1000837, 'JP', 'Yonezawa Shi', 1, 'yonezawa-shi', 37.84998000, 140.12160000),
(1064700, 1000837, 'JP', 'Yuza', 1, 'yuza', 39.01573000, 139.92909000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000835, 'JP', 'Yamaguchi Prefecture', 1, 'yamaguchi-prefecture');

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 
(1063413, 1000835, 'JP', 'Hagi', 1, 'hagi', 34.40000000, 131.41667000),
(1063414, 1000835, 'JP', 'Hagi Shi', 1, 'hagi-shi', 34.43206000, 131.50623000),
(1063473, 1000835, 'JP', 'Hikari', 1, 'hikari', 33.95500000, 131.95000000),
(1063474, 1000835, 'JP', 'Hikari Shi', 1, 'hikari-shi', 33.98247000, 131.97485000),
(1063528, 1000835, 'JP', 'Hōfu', 1, 'hofu', 34.05000000, 131.56667000),
(1063514, 1000835, 'JP', 'Hofu Shi', 1, 'hofu-shi', 34.07287000, 131.56808000),
(1063623, 1000835, 'JP', 'Iwakuni Shi', 1, 'iwakuni-shi', 34.20608000, 132.06286000),
(1063852, 1000835, 'JP', 'Kudamatsu', 1, 'kudamatsu', 34.00000000, 131.86667000),
(1063853, 1000835, 'JP', 'Kudamatsu Shi', 1, 'kudamatsu-shi', 34.03243000, 131.88683000),
(1063975, 1000835, 'JP', 'Mine Shi', 1, 'mine-shi', 34.21083000, 131.25170000),
(1064074, 1000835, 'JP', 'Nagato', 1, 'nagato', 34.38333000, 131.20000000),
(1064075, 1000835, 'JP', 'Nagato Shi', 1, 'nagato-shi', 34.34880000, 131.14703000),
(1064190, 1000835, 'JP', 'Ogōri-shimogō', 1, 'ogori-shimogo', 34.10000000, 131.40000000),
(1064211, 1000835, 'JP', 'Onoda', 1, 'onoda', 34.00139000, 131.18361000),
(1064284, 1000835, 'JP', 'Sanyōonoda Shi', 1, 'sanyoonoda-shi', 34.03956000, 131.15417000),
(1064334, 1000835, 'JP', 'Shimonoseki Shi', 1, 'shimonoseki-shi', 34.17277000, 130.98766000),
(1064371, 1000835, 'JP', 'Shūnan Shi', 1, 'shunan-shi', 34.15136000, 131.82498000),
(1064499, 1000835, 'JP', 'Tokuyama', 1, 'tokuyama', 34.05000000, 131.81667000),
(1064576, 1000835, 'JP', 'Ube', 1, 'ube', 33.94306000, 131.25111000),
(1064641, 1000835, 'JP', 'Yamaguchi Shi', 1, 'yamaguchi-shi', 34.17753000, 131.54667000),
(1064653, 1000835, 'JP', 'Yanai Shi', 1, 'yanai-shi', 33.96243000, 132.13111000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1000852, 'JP', 'Yamanashi Prefecture', 1, 'yamanashi-prefecture');

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 
(1063316, 1000852, 'JP', 'Chūō-shi', 1, 'chuo-shi', 35.58418000, 138.54110000),
(1063334, 1000852, 'JP', 'Enzan', 1, 'enzan', 35.70000000, 138.73333000),
(1063339, 1000852, 'JP', 'Fuefuki-shi', 1, 'fuefuki-shi', 35.59955000, 138.68067000),
(1063341, 1000852, 'JP', 'Fuji-yoshida Shi', 1, 'fuji-yoshida-shi', 35.43915000, 138.79368000),
(1063344, 1000852, 'JP', 'Fujikawaguchiko', 1, 'fujikawaguchiko', 35.48933000, 138.68832000),
(1063355, 1000852, 'JP', 'Fujiyoshida', 1, 'fujiyoshida', 35.44032000, 138.79586000),
(1063517, 1000852, 'JP', 'Hokuto', 1, 'hokuto', 35.83458000, 138.39606000),
(1063518, 1000852, 'JP', 'Hokuto-shi', 1, 'hokuto-shi', 35.83717000, 138.39375000),
(1063583, 1000852, 'JP', 'Isawa', 1, 'isawa', 35.65000000, 138.63333000),
(1063661, 1000852, 'JP', 'Kai-shi', 1, 'kai-shi', 35.71627000, 138.51871000),
(1063893, 1000852, 'JP', 'Kōfu', 1, 'kofu', 35.66667000, 138.56667000),
(1063894, 1000852, 'JP', 'Kōfu-shi', 1, 'kofu-shi', 35.69606000, 138.61261000),
(1063902, 1000852, 'JP', 'Kōshū-shi', 1, 'koshu-shi', 35.72649000, 138.79178000),
(1063961, 1000852, 'JP', 'Minami Alps-shi', 1, 'minami-alps-shi', 35.65065000, 138.35413000),
(1064143, 1000852, 'JP', 'Nirasaki', 1, 'nirasaki', 35.70000000, 138.45000000),
(1064144, 1000852, 'JP', 'Nirasaki-shi', 1, 'nirasaki-shi', 35.71772000, 138.41200000),
(1064766, 1000852, 'JP', 'Ōtsuki', 1, 'otsuki', 35.61851000, 138.97396000),
(1064767, 1000852, 'JP', 'Ōtsuki-shi', 1, 'otsuki-shi', 35.64285000, 138.91993000),
(1064235, 1000852, 'JP', 'Ryūō', 1, 'ryuo', 35.65000000, 138.50000000),
(1064552, 1000852, 'JP', 'Tsuru-shi', 1, 'tsuru-shi', 35.53660000, 138.91489000),
(1064582, 1000852, 'JP', 'Uenohara', 1, 'uenohara', 35.61667000, 139.11667000),
(1064583, 1000852, 'JP', 'Uenohara-shi', 1, 'uenohara-shi', 35.65000000, 139.05000000),
(1064643, 1000852, 'JP', 'Yamanashi-shi', 1, 'yamanashi-shi', 35.79691000, 138.69743000);

