REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug, s_phone_code, s_name_native, s_currency) VALUES 
('CN', 'China', 'china', '86', '中国', 'CNY');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002251, 'CN', 'Anhui', 1, 'anhui');

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 
(1019284, 1002251, 'CN', 'Anqing', 1, 'anqing', 30.51365000, 117.04723000),
(1019285, 1002251, 'CN', 'Anqing Shi', 1, 'anqing-shi', 30.66266000, 116.55911000),
(1019338, 1002251, 'CN', 'Bengbu', 1, 'bengbu', 32.94083000, 117.36083000),
(1019351, 1002251, 'CN', 'Bozhou', 1, 'bozhou', 33.87722000, 115.77028000),
(1019380, 1002251, 'CN', 'Chaohu', 1, 'chaohu', 31.60000000, 117.86667000),
(1019401, 1002251, 'CN', 'Chizhou', 1, 'chizhou', 30.66134000, 117.47783000),
(1019402, 1002251, 'CN', 'Chizhou Shi', 1, 'chizhou-shi', 30.30431000, 117.41388000),
(1019410, 1002251, 'CN', 'Chuzhou', 1, 'chuzhou', 32.32194000, 118.29778000),
(1019411, 1002251, 'CN', 'Chuzhou Shi', 1, 'chuzhou-shi', 32.60084000, 118.08813000),
(1019435, 1002251, 'CN', 'Datong', 1, 'datong', 32.62082000, 117.06319000),
(1019525, 1002251, 'CN', 'Fuyang', 1, 'fuyang', 32.90000000, 115.81667000),
(1019527, 1002251, 'CN', 'Fuyang Shi', 1, 'fuyang-shi', 32.93718000, 115.70778000),
(1019579, 1002251, 'CN', 'Gushu', 1, 'gushu', 31.56055000, 118.48147000),
(1019607, 1002251, 'CN', 'Hefei', 1, 'hefei', 31.86389000, 117.28083000),
(1019608, 1002251, 'CN', 'Hefei Shi', 1, 'hefei-shi', 31.94665000, 117.27805000),
(1019636, 1002251, 'CN', 'Huaibei', 1, 'huaibei', 33.97444000, 116.79167000),
(1019640, 1002251, 'CN', 'Huainan', 1, 'huainan', 32.62639000, 116.99694000),
(1019641, 1002251, 'CN', 'Huainan Shi', 1, 'huainan-shi', 32.73824000, 116.78813000),
(1019642, 1002251, 'CN', 'Huaiyuan Chengguanzhen', 1, 'huaiyuan-chengguanzhen', 32.95893000, 117.16566000),
(1019656, 1002251, 'CN', 'Huangshan', 1, 'huangshan', 29.71139000, 118.31250000),
(1019657, 1002251, 'CN', 'Huangshan Shi', 1, 'huangshan-shi', 29.89195000, 118.10553000),
(1019685, 1002251, 'CN', 'Huoqiu Chengguanzhen', 1, 'huoqiu-chengguanzhen', 32.35473000, 116.29390000),
(1019721, 1002251, 'CN', 'Jieshou', 1, 'jieshou', 33.26338000, 115.36108000),
(1019895, 1002251, 'CN', 'Lu’an', 1, 'lu-an', 31.73561000, 116.51688000),
(1019880, 1002251, 'CN', 'Lucheng', 1, 'lucheng', 31.23357000, 117.28057000),
(1019914, 1002251, 'CN', 'Mengcheng Chengguanzhen', 1, 'mengcheng-chengguanzhen', 33.26611000, 116.56605000),
(1019919, 1002251, 'CN', 'Mingguang', 1, 'mingguang', 32.78017000, 117.96378000),
(1020144, 1002251, 'CN', 'Suixi', 1, 'suixi', 33.89067000, 116.77473000),
(1020149, 1002251, 'CN', 'Suzhou', 1, 'suzhou', 33.63611000, 116.97889000),
(1020151, 1002251, 'CN', 'Suzhou Shi', 1, 'suzhou-shi', 33.86970000, 117.20569000),
(1020173, 1002251, 'CN', 'Tangzhai', 1, 'tangzhai', 34.43278000, 116.59111000),
(1020229, 1002251, 'CN', 'Wucheng', 1, 'wucheng', 29.60077000, 118.17495000),
(1020234, 1002251, 'CN', 'Wuhu', 1, 'wuhu', 31.33728000, 118.37351000),
(1020236, 1002251, 'CN', 'Wusong', 1, 'wusong', 30.95000000, 117.78333000),
(1020241, 1002251, 'CN', 'Wuyang', 1, 'wuyang', 31.99250000, 116.24722000),
(1020330, 1002251, 'CN', 'Xuanzhou', 1, 'xuanzhou', 30.95250000, 118.75528000),
(1020380, 1002251, 'CN', 'Yingshang Chengguanzhen', 1, 'yingshang-chengguanzhen', 32.62945000, 116.27013000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002257, 'CN', 'Beijing', 1, 'beijing');

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 
(1019332, 1002257, 'CN', 'Beijing', 1, 'beijing', 39.90750000, 116.39723000),
(1019370, 1002257, 'CN', 'Changping', 1, 'changping', 40.21612000, 116.23471000),
(1019439, 1002257, 'CN', 'Daxing', 1, 'daxing', 39.74025000, 116.32693000),
(1019499, 1002257, 'CN', 'Fangshan', 1, 'fangshan', 39.68699000, 115.99658000),
(1019817, 1002257, 'CN', 'Liangxiang', 1, 'liangxiang', 39.73598000, 116.13295000),
(1019916, 1002257, 'CN', 'Mentougou', 1, 'mentougou', 39.93819000, 116.09307000),
(1020126, 1002257, 'CN', 'Shunyi', 1, 'shunyi', 40.12175000, 116.64783000),
(1020197, 1002257, 'CN', 'Tongzhou', 1, 'tongzhou', 39.90395000, 116.66183000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002271, 'CN', 'Chongqing', 1, 'chongqing');

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 
(1019327, 1002271, 'CN', 'Beibei', 1, 'beibei', 29.82739000, 106.43645000),
(1019356, 1002271, 'CN', 'Caijia', 1, 'caijia', 28.90889000, 106.34040000),
(1019404, 1002271, 'CN', 'Chongqing', 1, 'chongqing', 29.56278000, 106.55278000),
(1019479, 1002271, 'CN', 'Dongxi', 1, 'dongxi', 28.76139000, 106.66111000),
(1019521, 1002271, 'CN', 'Fuling', 1, 'fuling', 29.70600000, 107.39575000),
(1019536, 1002271, 'CN', 'Ganshui', 1, 'ganshui', 28.74222000, 106.71111000),
(1019577, 1002271, 'CN', 'Guofuchang', 1, 'guofuchang', 28.85000000, 106.60139000),
(1019604, 1002271, 'CN', 'Hechuan', 1, 'hechuan', 29.99228000, 106.26461000),
(1019724, 1002271, 'CN', 'Jijiang', 1, 'jijiang', 29.28993000, 106.25001000),
(1019815, 1002271, 'CN', 'Liangping District', 1, 'liangping-district', 30.67409000, 107.79380000),
(1019991, 1002271, 'CN', 'Puhechang', 1, 'puhechang', 28.95250000, 106.83111000),
(1020084, 1002271, 'CN', 'Shapingba District', 1, 'shapingba-district', 29.54166000, 106.45547000),
(1020095, 1002271, 'CN', 'Shijiaochang', 1, 'shijiaochang', 28.92444000, 106.75611000),
(1020211, 1002271, 'CN', 'Wanxian', 1, 'wanxian', 30.81544000, 108.37089000),
(1020212, 1002271, 'CN', 'Wanzhou District', 1, 'wanzhou-district', 30.70576000, 108.40202000),
(1020385, 1002271, 'CN', 'Yongchuan', 1, 'yongchuan', 29.35376000, 105.89392000),
(1020395, 1002271, 'CN', 'Yudong', 1, 'yudong', 29.38500000, 106.51944000),
(1020412, 1002271, 'CN', 'Yuzhong District', 1, 'yuzhong-district', 29.55208000, 106.53814000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002248, 'CN', 'Fujian', 1, 'fujian');

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 
(1019296, 1002248, 'CN', 'Badu', 1, 'badu', 26.81028000, 119.56417000),
(1019301, 1002248, 'CN', 'Baiqi', 1, 'baiqi', 24.88244000, 118.70869000),
(1019310, 1002248, 'CN', 'Baiyun', 1, 'baiyun', 26.03648000, 118.90622000),
(1019334, 1002248, 'CN', 'Beishancun', 1, 'beishancun', 26.43732000, 119.63372000),
(1019371, 1002248, 'CN', 'Changqiao', 1, 'changqiao', 26.82139000, 118.84361000),
(1019391, 1002248, 'CN', 'Chengmen', 1, 'chengmen', 25.99339000, 119.36136000),
(1019400, 1002248, 'CN', 'Chixi', 1, 'chixi', 26.91111000, 119.48306000),
(1019405, 1002248, 'CN', 'Chongru', 1, 'chongru', 26.95111000, 119.92528000),
(1019414, 1002248, 'CN', 'Dadeng', 1, 'dadeng', 24.54386000, 118.32753000),
(1019417, 1002248, 'CN', 'Daixi', 1, 'daixi', 26.81250000, 119.11417000),
(1019427, 1002248, 'CN', 'Danyang', 1, 'danyang', 26.35102000, 119.48030000),
(1019429, 1002248, 'CN', 'Daqiao', 1, 'daqiao', 26.61500000, 118.90639000),
(1019444, 1002248, 'CN', 'Dazuo', 1, 'dazuo', 24.88616000, 118.96433000),
(1019457, 1002248, 'CN', 'Dinghaicun', 1, 'dinghaicun', 26.28022000, 119.78964000),
(1019459, 1002248, 'CN', 'Dingtoucun', 1, 'dingtoucun', 26.83977000, 119.66111000),
(1019462, 1002248, 'CN', 'Dongchongcun', 1, 'dongchongcun', 26.54001000, 119.83257000),
(1019464, 1002248, 'CN', 'Dongdai', 1, 'dongdai', 26.24366000, 119.61566000),
(1019469, 1002248, 'CN', 'Donghu', 1, 'donghu', 26.23453000, 119.51430000),
(1019471, 1002248, 'CN', 'Dongling', 1, 'dongling', 24.98271000, 118.89790000),
(1019482, 1002248, 'CN', 'Dongyuan', 1, 'dongyuan', 24.91738000, 118.75236000),
(1019502, 1002248, 'CN', 'Feiluan', 1, 'feiluan', 26.56250000, 119.59750000),
(1019508, 1002248, 'CN', 'Fengpu', 1, 'fengpu', 26.68276000, 118.76006000),
(1019512, 1002248, 'CN', 'Fengzhou', 1, 'fengzhou', 24.95762000, 118.53365000),
(1019532, 1002248, 'CN', 'Fu’an', 1, 'fu-an', 27.06372000, 119.65280000),
(1019517, 1002248, 'CN', 'Fuding', 1, 'fuding', 27.32734000, 120.21399000),
(1019522, 1002248, 'CN', 'Fuqing', 1, 'fuqing', 25.72500000, 119.37944000),
(1019531, 1002248, 'CN', 'Fuzhou', 1, 'fuzhou', 26.06139000, 119.30611000),
(1019537, 1002248, 'CN', 'Gantang', 1, 'gantang', 26.92000000, 119.63333000),
(1019566, 1002248, 'CN', 'Guantou', 1, 'guantou', 26.13593000, 119.56162000),
(1019568, 1002248, 'CN', 'Gufeng', 1, 'gufeng', 26.90833000, 118.98194000),
(1019618, 1002248, 'CN', 'Hetang', 1, 'hetang', 26.66276000, 119.11062000),
(1019628, 1002248, 'CN', 'Hongtang', 1, 'hongtang', 26.07056000, 119.23083000),
(1019629, 1002248, 'CN', 'Hongyang', 1, 'hongyang', 26.52861000, 119.46250000),
(1019632, 1002248, 'CN', 'Houyu', 1, 'houyu', 26.05958000, 119.53502000),
(1019643, 1002248, 'CN', 'Huai’an', 1, 'huai-an', 26.09899000, 119.22171000),
(1019659, 1002248, 'CN', 'Huangtian', 1, 'huangtian', 26.43851000, 118.62398000),
(1019686, 1002248, 'CN', 'Huotong', 1, 'huotong', 26.84972000, 119.41806000),
(1019709, 1002248, 'CN', 'Jian’ou', 1, 'jian-ou', 27.04694000, 118.32528000),
(1019697, 1002248, 'CN', 'Jiangkou', 1, 'jiangkou', 25.48694000, 119.19834000),
(1019706, 1002248, 'CN', 'Jianjiang', 1, 'jianjiang', 26.54972000, 119.75500000),
(1019732, 1002248, 'CN', 'Jingfeng', 1, 'jingfeng', 24.97441000, 118.96486000),
(1019744, 1002248, 'CN', 'Jinjiang', 1, 'jinjiang', 24.81978000, 118.57415000),
(1019746, 1002248, 'CN', 'Jinjing', 1, 'jinjing', 24.57500000, 118.59722000),
(1019755, 1002248, 'CN', 'Jitoucun', 1, 'jitoucun', 26.47681000, 119.60517000),
(1019777, 1002248, 'CN', 'Kengyuan', 1, 'kengyuan', 26.33964000, 119.76476000),
(1019778, 1002248, 'CN', 'Kerencun', 1, 'kerencun', 24.58213000, 118.66046000),
(1019780, 1002248, 'CN', 'Kuai’an', 1, 'kuai-an', 26.03417000, 119.41639000),
(1019820, 1002248, 'CN', 'Lianhecun', 1, 'lianhecun', 24.58932000, 118.33903000),
(1019862, 1002248, 'CN', 'Liuwudiancun', 1, 'liuwudiancun', 24.56923000, 118.19064000),
(1019870, 1002248, 'CN', 'Longmen', 1, 'longmen', 24.95972000, 118.08889000),
(1019875, 1002248, 'CN', 'Longyan', 1, 'longyan', 25.10722000, 117.02250000),
(1019886, 1002248, 'CN', 'Luoqiao', 1, 'luoqiao', 26.47265000, 119.00392000),
(1019890, 1002248, 'CN', 'Luoyang', 1, 'luoyang', 24.95938000, 118.68300000),
(1019892, 1002248, 'CN', 'Luxia', 1, 'luxia', 26.93000000, 118.80722000),
(1019907, 1002248, 'CN', 'Maping', 1, 'maping', 24.68722000, 118.55278000),
(1019911, 1002248, 'CN', 'Meipu', 1, 'meipu', 26.21120000, 118.89561000),
(1019924, 1002248, 'CN', 'Min’an', 1, 'min-an', 26.04962000, 119.49964000),
(1019947, 1002248, 'CN', 'Nanping', 1, 'nanping', 26.64500000, 118.17361000),
(1019955, 1002248, 'CN', 'Neikeng', 1, 'neikeng', 24.78544000, 118.46037000),
(1019960, 1002248, 'CN', 'Ningde', 1, 'ningde', 26.66167000, 119.52278000),
(1019971, 1002248, 'CN', 'Pandu', 1, 'pandu', 26.23639000, 119.45026000),
(1019990, 1002248, 'CN', 'Pucheng', 1, 'pucheng', 27.92333000, 118.53333000),
(1019998, 1002248, 'CN', 'Putian', 1, 'putian', 25.43944000, 119.01028000),
(1020012, 1002248, 'CN', 'Qibu', 1, 'qibu', 26.50750000, 119.54500000),
(1020013, 1002248, 'CN', 'Qidu', 1, 'qidu', 26.76528000, 119.54722000),
(1020036, 1002248, 'CN', 'Quanzhou', 1, 'quanzhou', 24.91389000, 118.58583000),
(1020043, 1002248, 'CN', 'Rong’an', 1, 'rong-an', 26.12472000, 119.12139000),
(1020055, 1002248, 'CN', 'Sanming', 1, 'sanming', 26.24861000, 117.61861000),
(1020061, 1002248, 'CN', 'Shajiang', 1, 'shajiang', 26.78250000, 119.96694000),
(1020064, 1002248, 'CN', 'Shangjie', 1, 'shangjie', 26.08679000, 119.18494000),
(1020078, 1002248, 'CN', 'Shanxia', 1, 'shanxia', 24.93802000, 118.88170000),
(1020079, 1002248, 'CN', 'Shanyang', 1, 'shanyang', 26.67019000, 119.20509000),
(1020081, 1002248, 'CN', 'Shaowu', 1, 'shaowu', 27.34089000, 117.48310000),
(1020098, 1002248, 'CN', 'Shijing', 1, 'shijing', 24.61956000, 118.42437000),
(1020102, 1002248, 'CN', 'Shima', 1, 'shima', 24.44647000, 117.81216000),
(1020113, 1002248, 'CN', 'Shoushan', 1, 'shoushan', 26.96444000, 119.16167000),
(1020118, 1002248, 'CN', 'Shuangxi', 1, 'shuangxi', 27.02248000, 119.04140000),
(1020121, 1002248, 'CN', 'Shuangzhu', 1, 'shuangzhu', 26.63114000, 118.64570000),
(1020124, 1002248, 'CN', 'Shuikou', 1, 'shuikou', 26.38360000, 118.73027000),
(1020169, 1002248, 'CN', 'Tangkou', 1, 'tangkou', 26.95417000, 119.01278000),
(1020174, 1002248, 'CN', 'Tantou', 1, 'tantou', 26.03033000, 119.59739000),
(1020177, 1002248, 'CN', 'Tatou', 1, 'tatou', 24.61732000, 118.52672000),
(1020186, 1002248, 'CN', 'Tingjiang', 1, 'tingjiang', 26.07401000, 119.50574000),
(1020202, 1002248, 'CN', 'Tuzhai', 1, 'tuzhai', 24.98301000, 118.83194000),
(1020227, 1002248, 'CN', 'Wubao', 1, 'wubao', 24.59589000, 118.55359000),
(1020243, 1002248, 'CN', 'Wuyishan', 1, 'wuyishan', 27.75995000, 118.03066000),
(1020244, 1002248, 'CN', 'Wuyucun', 1, 'wuyucun', 24.33551000, 118.14489000),
(1020248, 1002248, 'CN', 'Xiabaishi', 1, 'xiabaishi', 26.81528000, 119.67917000),
(1020249, 1002248, 'CN', 'Xiahu', 1, 'xiahu', 26.61056000, 119.94833000),
(1020252, 1002248, 'CN', 'Xiamen', 1, 'xiamen', 24.47979000, 118.08187000),
(1020253, 1002248, 'CN', 'Xiancun', 1, 'xiancun', 26.93861000, 119.36028000),
(1020259, 1002248, 'CN', 'Xiangyun', 1, 'xiangyun', 24.97111000, 118.16028000),
(1020279, 1002248, 'CN', 'Xibing', 1, 'xibing', 26.98139000, 119.72472000),
(1020286, 1002248, 'CN', 'Xiling', 1, 'xiling', 26.81444000, 119.04722000),
(1020287, 1002248, 'CN', 'Ximei', 1, 'ximei', 24.98773000, 118.38580000),
(1020288, 1002248, 'CN', 'Xinan', 1, 'xinan', 26.72000000, 119.85556000),
(1020292, 1002248, 'CN', 'Xindian', 1, 'xindian', 24.61006000, 118.24068000),
(1020337, 1002248, 'CN', 'Yakou', 1, 'yakou', 24.67194000, 118.63722000),
(1020343, 1002248, 'CN', 'Yanghou', 1, 'yanghou', 26.64083000, 118.50806000),
(1020348, 1002248, 'CN', 'Yangzhong', 1, 'yangzhong', 26.70556000, 119.37444000),
(1020357, 1002248, 'CN', 'Yantian', 1, 'yantian', 26.85333000, 119.85750000),
(1020377, 1002248, 'CN', 'Yingdu', 1, 'yingdu', 24.97167000, 118.24417000),
(1020379, 1002248, 'CN', 'Yinglin', 1, 'yinglin', 24.63222000, 118.58056000),
(1020387, 1002248, 'CN', 'Yongning', 1, 'yongning', 24.68000000, 118.69000000),
(1020404, 1002248, 'CN', 'Yushan', 1, 'yushan', 26.90863000, 118.56713000),
(1020425, 1002248, 'CN', 'Zhangwan', 1, 'zhangwan', 26.71139000, 119.59194000),
(1020428, 1002248, 'CN', 'Zhangzhou', 1, 'zhangzhou', 24.51333000, 117.65556000),
(1020440, 1002248, 'CN', 'Zhenhaicun', 1, 'zhenhaicun', 24.25894000, 118.09186000),
(1020450, 1002248, 'CN', 'Zhongfang', 1, 'zhongfang', 26.60083000, 119.42583000),
(1020472, 1002248, 'CN', 'Zhuoyang', 1, 'zhuoyang', 26.63003000, 119.02150000),
(1020473, 1002248, 'CN', 'Zhuqi', 1, 'zhuqi', 26.14860000, 119.10216000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002275, 'CN', 'Gansu', 1, 'gansu');

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 
(1019309, 1002275, 'CN', 'Baiyin', 1, 'baiyin', 36.54696000, 104.17023000),
(1019330, 1002275, 'CN', 'Beidao', 1, 'beidao', 34.56861000, 105.89333000),
(1019460, 1002275, 'CN', 'Dingxi Shi', 1, 'dingxi-shi', 35.03710000, 104.38623000),
(1019622, 1002275, 'CN', 'Hezuo', 1, 'hezuo', 34.98556000, 102.90944000),
(1019716, 1002275, 'CN', 'Jiayuguan', 1, 'jiayuguan', 39.81121000, 98.28618000),
(1019728, 1002275, 'CN', 'Jinchang', 1, 'jinchang', 38.50062000, 102.19379000),
(1019758, 1002275, 'CN', 'Jiuquan', 1, 'jiuquan', 39.74318000, 98.51736000),
(1019803, 1002275, 'CN', 'Lanzhou', 1, 'lanzhou', 36.05701000, 103.83987000),
(1019806, 1002275, 'CN', 'Laojunmiao', 1, 'laojunmiao', 39.83333000, 97.73333000),
(1019854, 1002275, 'CN', 'Linxia Chengguanzhen', 1, 'linxia-chengguanzhen', 35.60028000, 103.20639000),
(1019855, 1002275, 'CN', 'Linxia Huizu Zizhizhou', 1, 'linxia-huizu-zizhizhou', 35.66597000, 103.24080000),
(1019871, 1002275, 'CN', 'Longnan Shi', 1, 'longnan-shi', 33.53451000, 105.34947000),
(1019908, 1002275, 'CN', 'Mawu', 1, 'mawu', 34.42639000, 104.91472000),
(1019980, 1002275, 'CN', 'Pingliang', 1, 'pingliang', 35.53917000, 106.68611000),
(1020015, 1002275, 'CN', 'Qincheng', 1, 'qincheng', 34.58028000, 105.72722000),
(1020026, 1002275, 'CN', 'Qingyang Shi', 1, 'qingyang-shi', 36.23598000, 107.58113000),
(1020181, 1002275, 'CN', 'Tianshui', 1, 'tianshui', 34.57952000, 105.74238000),
(1020237, 1002275, 'CN', 'Wuwei', 1, 'wuwei', 37.92672000, 102.63202000),
(1020426, 1002275, 'CN', 'Zhangye', 1, 'zhangye', 38.93417000, 100.45167000),
(1020427, 1002275, 'CN', 'Zhangye Shi', 1, 'zhangye-shi', 39.12183000, 99.92495000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002279, 'CN', 'Guangdong', 1, 'guangdong');

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 
(1019278, 1002279, 'CN', 'Anbu', 1, 'anbu', 23.44895000, 116.68092000),
(1019383, 1002279, 'CN', 'Chaozhou', 1, 'chaozhou', 23.65396000, 116.62262000),
(1019389, 1002279, 'CN', 'Chenghua', 1, 'chenghua', 23.46132000, 116.77007000),
(1019422, 1002279, 'CN', 'Daliang', 1, 'daliang', 22.84067000, 113.25030000),
(1019426, 1002279, 'CN', 'Danshui', 1, 'danshui', 22.79840000, 114.46716000),
(1019432, 1002279, 'CN', 'Dasha', 1, 'dasha', 23.11037000, 113.44180000),
(1019467, 1002279, 'CN', 'Dongguan', 1, 'dongguan', 23.01797000, 113.74866000),
(1019468, 1002279, 'CN', 'Donghai', 1, 'donghai', 22.94593000, 115.64204000),
(1019483, 1002279, 'CN', 'Ducheng', 1, 'ducheng', 23.24212000, 111.52840000),
(1019490, 1002279, 'CN', 'Encheng', 1, 'encheng', 22.18659000, 112.30424000),
(1019514, 1002279, 'CN', 'Foshan', 1, 'foshan', 23.02677000, 113.13148000),
(1019515, 1002279, 'CN', 'Foshan Shi', 1, 'foshan-shi', 23.02264000, 112.96302000),
(1019546, 1002279, 'CN', 'Gaoyao', 1, 'gaoyao', 23.02432000, 112.44555000),
(1019550, 1002279, 'CN', 'Gaozhou', 1, 'gaozhou', 21.93924000, 110.84607000),
(1019562, 1002279, 'CN', 'Guangzhou', 1, 'guangzhou', 23.11667000, 113.25000000),
(1019563, 1002279, 'CN', 'Guangzhou Shi', 1, 'guangzhou-shi', 23.37327000, 113.51219000),
(1019586, 1002279, 'CN', 'Haikuotiankong', 1, 'haikuotiankong', 22.52881000, 113.93990000),
(1019590, 1002279, 'CN', 'Haimen', 1, 'haimen', 23.19346000, 116.61219000),
(1019617, 1002279, 'CN', 'Hepo', 1, 'hepo', 23.43077000, 115.82991000),
(1019620, 1002279, 'CN', 'Heyuan', 1, 'heyuan', 23.73333000, 114.68333000),
(1019637, 1002279, 'CN', 'Huaicheng', 1, 'huaicheng', 23.91952000, 112.17629000),
(1019646, 1002279, 'CN', 'Huanggang', 1, 'huanggang', 23.67704000, 116.99961000),
(1019669, 1002279, 'CN', 'Huazhou', 1, 'huazhou', 21.63333000, 110.58333000),
(1019672, 1002279, 'CN', 'Huicheng', 1, 'huicheng', 23.03845000, 116.28988000),
(1019675, 1002279, 'CN', 'Huizhou', 1, 'huizhou', 23.11147000, 114.41523000),
(1019681, 1002279, 'CN', 'Humen', 1, 'humen', 22.81899000, 113.67306000),
(1019699, 1002279, 'CN', 'Jiangmen', 1, 'jiangmen', 22.58333000, 113.08333000),
(1019717, 1002279, 'CN', 'Jiazi', 1, 'jiazi', 22.87932000, 116.07318000),
(1019720, 1002279, 'CN', 'Jieshi', 1, 'jieshi', 22.81027000, 115.83058000),
(1019723, 1002279, 'CN', 'Jieyang', 1, 'jieyang', 23.54180000, 116.36581000),
(1019807, 1002279, 'CN', 'Lecheng', 1, 'lecheng', 25.12800000, 113.35041000),
(1019821, 1002279, 'CN', 'Lianjiang', 1, 'lianjiang', 21.64673000, 110.28172000),
(1019826, 1002279, 'CN', 'Lianzhou', 1, 'lianzhou', 24.78186000, 112.37120000),
(1019833, 1002279, 'CN', 'Licheng', 1, 'licheng', 23.29549000, 113.82465000),
(1019879, 1002279, 'CN', 'Lubu', 1, 'lubu', 23.17233000, 112.28298000),
(1019881, 1002279, 'CN', 'Luocheng', 1, 'luocheng', 22.76953000, 111.56882000),
(1019888, 1002279, 'CN', 'Luoyang', 1, 'luoyang', 23.16244000, 114.27342000),
(1019898, 1002279, 'CN', 'Maba', 1, 'maba', 24.68413000, 113.59839000),
(1019904, 1002279, 'CN', 'Maoming', 1, 'maoming', 21.65000000, 110.90000000),
(1019913, 1002279, 'CN', 'Meizhou', 1, 'meizhou', 24.28859000, 116.11768000),
(1019939, 1002279, 'CN', 'Nanfeng', 1, 'nanfeng', 23.72695000, 111.79723000),
(1019982, 1002279, 'CN', 'Pingshan', 1, 'pingshan', 22.99376000, 114.71311000),
(1019996, 1002279, 'CN', 'Puning', 1, 'puning', 23.31072000, 116.16869000),
(1020027, 1002279, 'CN', 'Qingyuan', 1, 'qingyuan', 23.70000000, 113.03333000),
(1020057, 1002279, 'CN', 'Sanshui', 1, 'sanshui', 23.15486000, 112.89161000),
(1020076, 1002279, 'CN', 'Shantou', 1, 'shantou', 23.36814000, 116.71479000),
(1020077, 1002279, 'CN', 'Shanwei', 1, 'shanwei', 22.78199000, 115.34750000),
(1020080, 1002279, 'CN', 'Shaoguan', 1, 'shaoguan', 24.80000000, 113.58333000),
(1020083, 1002279, 'CN', 'Shaping', 1, 'shaping', 22.77019000, 112.95776000),
(1020091, 1002279, 'CN', 'Shenzhen', 1, 'shenzhen', 22.55653000, 113.98590000),
(1020101, 1002279, 'CN', 'Shilong', 1, 'shilong', 23.11444000, 113.84722000),
(1020103, 1002279, 'CN', 'Shiqi', 1, 'shiqi', 22.51682000, 113.38521000),
(1020105, 1002279, 'CN', 'Shiqiao', 1, 'shiqiao', 22.94640000, 113.35769000),
(1020107, 1002279, 'CN', 'Shiwan', 1, 'shiwan', 23.00107000, 113.07700000),
(1020108, 1002279, 'CN', 'Shixing', 1, 'shixing', 24.94824000, 114.06572000),
(1020160, 1002279, 'CN', 'Taishan', 1, 'taishan', 22.25135000, 112.77990000),
(1020170, 1002279, 'CN', 'Tangping', 1, 'tangping', 22.03177000, 111.93537000),
(1020230, 1002279, 'CN', 'Wuchuan', 1, 'wuchuan', 21.45713000, 110.76591000),
(1020296, 1002279, 'CN', 'Xingning', 1, 'xingning', 24.14830000, 115.72272000),
(1020299, 1002279, 'CN', 'Xinhui', 1, 'xinhui', 22.45600000, 113.04820000),
(1020312, 1002279, 'CN', 'Xinyi', 1, 'xinyi', 22.37303000, 110.94746000),
(1020319, 1002279, 'CN', 'Xiongzhou', 1, 'xiongzhou', 25.11667000, 114.30000000),
(1020333, 1002279, 'CN', 'Xucheng', 1, 'xucheng', 20.32917000, 110.16712000),
(1020341, 1002279, 'CN', 'Yangchun', 1, 'yangchun', 22.16667000, 111.78333000),
(1020344, 1002279, 'CN', 'Yangjiang', 1, 'yangjiang', 21.85563000, 111.96272000),
(1020375, 1002279, 'CN', 'Yingcheng', 1, 'yingcheng', 24.16588000, 113.41267000),
(1020401, 1002279, 'CN', 'Yunfu', 1, 'yunfu', 22.92833000, 112.03954000),
(1020429, 1002279, 'CN', 'Zhanjiang', 1, 'zhanjiang', 21.28145000, 110.34271000),
(1020433, 1002279, 'CN', 'Zhaoqing', 1, 'zhaoqing', 23.04893000, 112.46091000),
(1020451, 1002279, 'CN', 'Zhongshan', 1, 'zhongshan', 21.31992000, 110.57230000),
(1020452, 1002279, 'CN', 'Zhongshan Prefecture', 1, 'zhongshan-prefecture', 22.55358000, 113.37550000),
(1020466, 1002279, 'CN', 'Zhuhai', 1, 'zhuhai', 22.27694000, 113.56778000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002278, 'CN', 'Guangxi Zhuang Autonomous Region', 1, 'guangxi-zhuang-autonomous-region');

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 
(1019295, 1002278, 'CN', 'Babu', 1, 'babu', 24.41667000, 111.51667000),
(1019299, 1002278, 'CN', 'Baihe', 1, 'baihe', 22.13430000, 107.23200000),
(1019303, 1002278, 'CN', 'Baise City', 1, 'baise-city', 23.89972000, 106.61333000),
(1019304, 1002278, 'CN', 'Baise Shi', 1, 'baise-shi', 23.90000000, 106.61667000),
(1019331, 1002278, 'CN', 'Beihai', 1, 'beihai', 21.48333000, 109.10000000),
(1019407, 1002278, 'CN', 'Chongzuo Shi', 1, 'chongzuo-shi', 22.46541000, 107.39622000),
(1019441, 1002278, 'CN', 'Dazhai', 1, 'dazhai', 25.80980000, 110.15000000),
(1019498, 1002278, 'CN', 'Fangchenggang Shi', 1, 'fangchenggang-shi', 21.93580000, 107.95932000),
(1019569, 1002278, 'CN', 'Guigang', 1, 'guigang', 23.09639000, 109.60917000),
(1019570, 1002278, 'CN', 'Guilin', 1, 'guilin', 25.28194000, 110.28639000),
(1019571, 1002278, 'CN', 'Guilin Shi', 1, 'guilin-shi', 25.28333000, 110.28333000),
(1019572, 1002278, 'CN', 'Guiping', 1, 'guiping', 23.39336000, 110.07437000),
(1019603, 1002278, 'CN', 'Hechi Shi', 1, 'hechi-shi', 24.70000000, 108.03000000),
(1019743, 1002278, 'CN', 'Jinji', 1, 'jinji', 23.22806000, 110.82611000),
(1019789, 1002278, 'CN', 'Laibin', 1, 'laibin', 23.70000000, 109.26667000),
(1019827, 1002278, 'CN', 'Lianzhou', 1, 'lianzhou', 21.66621000, 109.20116000),
(1019840, 1002278, 'CN', 'Lingcheng', 1, 'lingcheng', 22.70722000, 110.34917000),
(1019863, 1002278, 'CN', 'Liuzhou Shi', 1, 'liuzhou-shi', 24.31667000, 109.40000000),
(1019887, 1002278, 'CN', 'Luorong', 1, 'luorong', 24.40583000, 109.60861000),
(1019938, 1002278, 'CN', 'Nandu', 1, 'nandu', 22.85250000, 110.82333000),
(1019945, 1002278, 'CN', 'Nanning', 1, 'nanning', 22.81667000, 108.31667000),
(1019981, 1002278, 'CN', 'Pingnan', 1, 'pingnan', 23.54218000, 110.38946000),
(1019995, 1002278, 'CN', 'Pumiao', 1, 'pumiao', 22.75867000, 108.48111000),
(1020031, 1002278, 'CN', 'Qinzhou', 1, 'qinzhou', 21.97296000, 108.62612000),
(1020247, 1002278, 'CN', 'Wuzhou', 1, 'wuzhou', 23.48333000, 111.31667000),
(1020346, 1002278, 'CN', 'Yangshuo', 1, 'yangshuo', 24.78081000, 110.48967000),
(1020361, 1002278, 'CN', 'Yashan', 1, 'yashan', 22.19750000, 109.94194000),
(1020398, 1002278, 'CN', 'Yulin', 1, 'yulin', 22.63333000, 110.15000000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002261, 'CN', 'Guizhou', 1, 'guizhou');

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 
(1019288, 1002261, 'CN', 'Anshun', 1, 'anshun', 26.25000000, 105.93333000),
(1019292, 1002261, 'CN', 'Aoshi', 1, 'aoshi', 26.40167000, 109.07111000),
(1019297, 1002261, 'CN', 'Bahuang', 1, 'bahuang', 27.71806000, 109.01889000),
(1019307, 1002261, 'CN', 'Baishi', 1, 'baishi', 26.97361000, 109.44333000),
(1019313, 1002261, 'CN', 'Bangdong', 1, 'bangdong', 26.97556000, 109.18583000),
(1019337, 1002261, 'CN', 'Benchu', 1, 'benchu', 26.77111000, 109.29056000),
(1019341, 1002261, 'CN', 'Bijie', 1, 'bijie', 27.30193000, 105.28627000),
(1019360, 1002261, 'CN', 'Chadian', 1, 'chadian', 27.58194000, 109.13278000),
(1019373, 1002261, 'CN', 'Changsha', 1, 'changsha', 28.68778000, 105.98972000),
(1019408, 1002261, 'CN', 'Chumi', 1, 'chumi', 28.23361000, 106.83278000),
(1019412, 1002261, 'CN', 'Dabachang', 1, 'dabachang', 27.74250000, 108.34333000),
(1019431, 1002261, 'CN', 'Darong', 1, 'darong', 25.78500000, 108.86400000),
(1019484, 1002261, 'CN', 'Dundong', 1, 'dundong', 26.01190000, 109.14100000),
(1019487, 1002261, 'CN', 'Duyun', 1, 'duyun', 26.26667000, 107.51667000),
(1019542, 1002261, 'CN', 'Gaoniang', 1, 'gaoniang', 26.84250000, 109.17889000),
(1019545, 1002261, 'CN', 'Gaowu', 1, 'gaowu', 25.56250000, 108.90800000),
(1019549, 1002261, 'CN', 'Gaozeng', 1, 'gaozeng', 25.80167000, 108.93750000),
(1019558, 1002261, 'CN', 'Guandu', 1, 'guandu', 28.56833000, 106.10255000),
(1019575, 1002261, 'CN', 'Guiyang', 1, 'guiyang', 26.58333000, 106.71667000),
(1019630, 1002261, 'CN', 'Hongzhou', 1, 'hongzhou', 26.12583000, 109.40889000),
(1019666, 1002261, 'CN', 'Huaqiu', 1, 'huaqiu', 28.11665000, 106.60225000),
(1019800, 1002261, 'CN', 'Lantian', 1, 'lantian', 27.02500000, 109.29472000),
(1019813, 1002261, 'CN', 'Liangcunchang', 1, 'liangcunchang', 28.40667000, 106.42444000),
(1019861, 1002261, 'CN', 'Liupanshui', 1, 'liupanshui', 26.59444000, 104.83333000),
(1019869, 1002261, 'CN', 'Longlisuo', 1, 'longlisuo', 26.41417000, 109.10222000),
(1019877, 1002261, 'CN', 'Loushanguan', 1, 'loushanguan', 28.13680000, 106.82200000),
(1019906, 1002261, 'CN', 'Maoping', 1, 'maoping', 26.73694000, 109.22111000),
(1019970, 1002261, 'CN', 'Ouyang', 1, 'ouyang', 26.41910000, 109.21600000),
(1019979, 1002261, 'CN', 'Pingjiang', 1, 'pingjiang', 25.97056000, 108.39528000),
(1020007, 1002261, 'CN', 'Qiandongnan Miao and Dong Autonomous Prefecture', 1, 'qiandongnan-miao-and-dong-autonomous-prefecture', 26.57380000, 108.59914000),
(1020009, 1002261, 'CN', 'Qianxinan Bouyeizu Miaozu Zizhizhou', 1, 'qianxinan-bouyeizu-miaozu-zizhizhou', 25.38808000, 105.38740000),
(1020014, 1002261, 'CN', 'Qimeng', 1, 'qimeng', 26.48472000, 108.99944000),
(1020019, 1002261, 'CN', 'Qinglang', 1, 'qinglang', 27.12472000, 108.73278000),
(1020046, 1002261, 'CN', 'Runsong', 1, 'runsong', 26.87000000, 109.09700000),
(1020051, 1002261, 'CN', 'Sanchahe', 1, 'sanchahe', 28.49528000, 106.42833000),
(1020053, 1002261, 'CN', 'Sangmu', 1, 'sangmu', 28.21528000, 106.26889000),
(1020104, 1002261, 'CN', 'Shiqian', 1, 'shiqian', 27.52250000, 108.22806000),
(1020134, 1002261, 'CN', 'Songkan', 1, 'songkan', 28.54972000, 106.85972000),
(1020185, 1002261, 'CN', 'Tingdong', 1, 'tingdong', 25.82444000, 108.61250000),
(1020189, 1002261, 'CN', 'Tonggu', 1, 'tonggu', 26.57222000, 109.30944000),
(1020193, 1002261, 'CN', 'Tongren', 1, 'tongren', 27.71722000, 109.18528000),
(1020194, 1002261, 'CN', 'Tongren Diqu', 1, 'tongren-diqu', 27.74188000, 109.19312000),
(1020216, 1002261, 'CN', 'Weining', 1, 'weining', 26.85000000, 104.23333000),
(1020224, 1002261, 'CN', 'Wenshui', 1, 'wenshui', 28.45056000, 106.52667000),
(1020250, 1002261, 'CN', 'Xiajiang', 1, 'xiajiang', 25.75556000, 108.69194000),
(1020276, 1002261, 'CN', 'Xiaoweizhai', 1, 'xiaoweizhai', 26.19028000, 107.51250000),
(1020315, 1002261, 'CN', 'Xinzhan', 1, 'xinzhan', 28.38833000, 106.85667000),
(1020321, 1002261, 'CN', 'Xishan', 1, 'xishan', 25.68528000, 108.96389000),
(1020334, 1002261, 'CN', 'Xujiaba', 1, 'xujiaba', 27.88472000, 108.11361000),
(1020347, 1002261, 'CN', 'Yangtou', 1, 'yangtou', 27.68944000, 109.41389000),
(1020390, 1002261, 'CN', 'Youyupu', 1, 'youyupu', 27.55170000, 109.13500000),
(1020448, 1002261, 'CN', 'Zhongchao', 1, 'zhongchao', 26.13750000, 109.22000000),
(1020468, 1002261, 'CN', 'Zhujiachang', 1, 'zhujiachang', 27.35750000, 108.93833000),
(1020483, 1002261, 'CN', 'Zunyi', 1, 'zunyi', 27.68667000, 106.90722000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002273, 'CN', 'Hainan', 1, 'hainan');

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 
(1019321, 1002273, 'CN', 'Basuo', 1, 'basuo', 19.09390000, 108.65456000),
(1019406, 1002273, 'CN', 'Chongshan', 1, 'chongshan', 18.78229000, 109.50130000),
(1019415, 1002273, 'CN', 'Dadonghai', 1, 'dadonghai', 18.22056000, 109.51028000),
(1019584, 1002273, 'CN', 'Haikou', 1, 'haikou', 20.04583000, 110.34167000),
(1019745, 1002273, 'CN', 'Jinjiang', 1, 'jinjiang', 19.72878000, 110.00851000),
(1019837, 1002273, 'CN', 'Lincheng', 1, 'lincheng', 19.90778000, 109.68583000),
(1019932, 1002273, 'CN', 'Nada', 1, 'nada', 19.52257000, 109.57860000),
(1020032, 1002273, 'CN', 'Qionghai', 1, 'qionghai', 19.24250000, 110.46417000),
(1020034, 1002273, 'CN', 'Qiongshan', 1, 'qiongshan', 20.00583000, 110.35417000),
(1020056, 1002273, 'CN', 'Sansha', 1, 'sansha', 16.83387000, 112.33435000),
(1020058, 1002273, 'CN', 'Sanya', 1, 'sanya', 18.24306000, 109.50500000),
(1020209, 1002273, 'CN', 'Wanning', 1, 'wanning', 18.79931000, 110.38410000),
(1020217, 1002273, 'CN', 'Wenchang', 1, 'wenchang', 19.61570000, 110.74894000),
(1020325, 1002273, 'CN', 'Xiuying', 1, 'xiuying', 20.00073000, 110.29359000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002280, 'CN', 'Hebei', 1, 'hebei');

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 
(1019314, 1002280, 'CN', 'Baoding', 1, 'baoding', 38.85111000, 115.49028000),
(1019329, 1002280, 'CN', 'Beidaihehaibin', 1, 'beidaihehaibin', 39.82222000, 119.51806000),
(1019349, 1002280, 'CN', 'Botou', 1, 'botou', 38.06667000, 116.56660000),
(1019357, 1002280, 'CN', 'Cangzhou', 1, 'cangzhou', 38.31667000, 116.86667000),
(1019358, 1002280, 'CN', 'Cangzhou Shi', 1, 'cangzhou-shi', 38.31000000, 116.86000000),
(1019368, 1002280, 'CN', 'Changli', 1, 'changli', 39.70417000, 119.15056000),
(1019385, 1002280, 'CN', 'Chengde', 1, 'chengde', 40.95190000, 117.95883000),
(1019386, 1002280, 'CN', 'Chengde Prefecture', 1, 'chengde-prefecture', 40.97000000, 117.93000000),
(1019461, 1002280, 'CN', 'Dingzhou', 1, 'dingzhou', 38.51306000, 114.99556000),
(1019509, 1002280, 'CN', 'Fengrun', 1, 'fengrun', 39.83333000, 118.11667000),
(1019581, 1002280, 'CN', 'Guye', 1, 'guye', 39.73054000, 118.44085000),
(1019597, 1002280, 'CN', 'Handan', 1, 'handan', 36.60056000, 114.46778000),
(1019605, 1002280, 'CN', 'Hecun', 1, 'hecun', 36.53333000, 114.11111000),
(1019614, 1002280, 'CN', 'Hengshui', 1, 'hengshui', 37.73222000, 115.70111000),
(1019794, 1002280, 'CN', 'Langfang', 1, 'langfang', 39.50972000, 116.69472000),
(1019795, 1002280, 'CN', 'Langfang Shi', 1, 'langfang-shi', 39.51667000, 116.68333000),
(1019851, 1002280, 'CN', 'Linshui', 1, 'linshui', 36.42472000, 114.20472000),
(1019853, 1002280, 'CN', 'Linxi', 1, 'linxi', 39.71183000, 118.44954000),
(1019878, 1002280, 'CN', 'Luancheng', 1, 'luancheng', 37.87917000, 114.65167000),
(1019940, 1002280, 'CN', 'Nangong', 1, 'nangong', 37.35806000, 115.37444000),
(1019976, 1002280, 'CN', 'Pengcheng', 1, 'pengcheng', 36.43111000, 114.17000000),
(1020029, 1002280, 'CN', 'Qinhuangdao', 1, 'qinhuangdao', 39.93167000, 119.58833000),
(1020040, 1002280, 'CN', 'Renqiu', 1, 'renqiu', 38.69889000, 116.09361000),
(1020060, 1002280, 'CN', 'Shahecheng', 1, 'shahecheng', 36.93833000, 114.50583000),
(1020071, 1002280, 'CN', 'Shanhaiguan', 1, 'shanhaiguan', 40.00250000, 119.74889000),
(1020096, 1002280, 'CN', 'Shijiazhuang', 1, 'shijiazhuang', 38.04139000, 114.47861000),
(1020097, 1002280, 'CN', 'Shijiazhuang Shi', 1, 'shijiazhuang-shi', 38.04000000, 114.47000000),
(1020135, 1002280, 'CN', 'Songling', 1, 'songling', 40.29303000, 118.26908000),
(1020168, 1002280, 'CN', 'Tangjiazhuang', 1, 'tangjiazhuang', 39.74326000, 118.45099000),
(1020171, 1002280, 'CN', 'Tangshan', 1, 'tangshan', 39.63333000, 118.18333000),
(1020172, 1002280, 'CN', 'Tangshan Shi', 1, 'tangshan-shi', 39.63000000, 118.18000000),
(1020178, 1002280, 'CN', 'Tianchang', 1, 'tianchang', 37.99806000, 114.01556000),
(1020297, 1002280, 'CN', 'Xingtai', 1, 'xingtai', 37.06306000, 114.49417000),
(1020301, 1002280, 'CN', 'Xinji', 1, 'xinji', 37.90278000, 115.20361000),
(1020422, 1002280, 'CN', 'Zhangjiakou', 1, 'zhangjiakou', 40.81000000, 114.87944000),
(1020423, 1002280, 'CN', 'Zhangjiakou Shi', 1, 'zhangjiakou-shi', 40.83333000, 114.93333000),
(1020424, 1002280, 'CN', 'Zhangjiakou Shi Xuanhua Qu', 1, 'zhangjiakou-shi-xuanhua-qu', 40.61028000, 115.04472000),
(1020432, 1002280, 'CN', 'Zhaogezhuang', 1, 'zhaogezhuang', 39.76538000, 118.41191000),
(1020482, 1002280, 'CN', 'Zunhua', 1, 'zunhua', 40.17917000, 117.95861000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002265, 'CN', 'Heilongjiang', 1, 'heilongjiang');

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 
(1019272, 1002265, 'CN', 'Acheng', 1, 'acheng', 45.54545000, 126.97703000),
(1019279, 1002265, 'CN', 'Anda', 1, 'anda', 46.40202000, 125.31454000),
(1019302, 1002265, 'CN', 'Baiquan', 1, 'baiquan', 47.60605000, 126.08481000),
(1019312, 1002265, 'CN', 'Bamiantong', 1, 'bamiantong', 44.91738000, 130.52000000),
(1019316, 1002265, 'CN', 'Baoqing', 1, 'baoqing', 46.33167000, 132.21111000),
(1019317, 1002265, 'CN', 'Baoshan', 1, 'baoshan', 46.55861000, 131.42444000),
(1019322, 1002265, 'CN', 'Bayan', 1, 'bayan', 46.07556000, 127.39840000),
(1019336, 1002265, 'CN', 'Bei’an', 1, 'bei-an', 48.26667000, 126.60000000),
(1019344, 1002265, 'CN', 'Binzhou', 1, 'binzhou', 45.75281000, 127.47986000),
(1019347, 1002265, 'CN', 'Boli', 1, 'boli', 45.75279000, 130.57211000),
(1019361, 1002265, 'CN', 'Chaihe', 1, 'chaihe', 44.75980000, 129.67826000),
(1019397, 1002265, 'CN', 'Chengzihe', 1, 'chengzihe', 45.33333000, 131.06667000),
(1019430, 1002265, 'CN', 'Daqing', 1, 'daqing', 46.58333000, 125.00000000),
(1019473, 1002265, 'CN', 'Dongning', 1, 'dongning', 44.06219000, 131.12075000),
(1019480, 1002265, 'CN', 'Dongxing', 1, 'dongxing', 45.36088000, 130.78679000),
(1019503, 1002265, 'CN', 'Fendou', 1, 'fendou', 46.64142000, 124.86283000),
(1019511, 1002265, 'CN', 'Fengxiang', 1, 'fengxiang', 47.57549000, 130.82306000),
(1019518, 1002265, 'CN', 'Fujin', 1, 'fujin', 47.26000000, 132.03222000),
(1019520, 1002265, 'CN', 'Fuli', 1, 'fuli', 46.72167000, 131.13944000),
(1019528, 1002265, 'CN', 'Fuyu', 1, 'fuyu', 47.79756000, 124.45731000),
(1019530, 1002265, 'CN', 'Fuyuan', 1, 'fuyuan', 48.36306000, 134.28917000),
(1019535, 1002265, 'CN', 'Gannan', 1, 'gannan', 47.91472000, 123.50306000),
(1019588, 1002265, 'CN', 'Hailin', 1, 'hailin', 44.57149000, 129.38539000),
(1019589, 1002265, 'CN', 'Hailun', 1, 'hailun', 47.45650000, 126.95368000),
(1019601, 1002265, 'CN', 'Harbin', 1, 'harbin', 45.75000000, 126.65000000),
(1019609, 1002265, 'CN', 'Hegang', 1, 'hegang', 47.35118000, 130.30012000),
(1019610, 1002265, 'CN', 'Heihe', 1, 'heihe', 50.24413000, 127.49016000),
(1019624, 1002265, 'CN', 'Honggang', 1, 'honggang', 46.40124000, 124.88322000),
(1019645, 1002265, 'CN', 'Huanan', 1, 'huanan', 46.22070000, 130.52500000),
(1019676, 1002265, 'CN', 'Hulan', 1, 'hulan', 45.98333000, 126.60000000),
(1019677, 1002265, 'CN', 'Hulan Ergi', 1, 'hulan-ergi', 47.20417000, 123.63333000),
(1019694, 1002265, 'CN', 'Jiamusi', 1, 'jiamusi', 46.79927000, 130.31633000),
(1019718, 1002265, 'CN', 'Jidong', 1, 'jidong', 45.21667000, 131.08333000),
(1019760, 1002265, 'CN', 'Jixi', 1, 'jixi', 45.30109000, 130.95718000),
(1019797, 1002265, 'CN', 'Langxiang', 1, 'langxiang', 46.94985000, 128.86849000),
(1019802, 1002265, 'CN', 'Lanxi', 1, 'lanxi', 46.25785000, 126.28269000),
(1019819, 1002265, 'CN', 'Lianhe', 1, 'lianhe', 47.13333000, 129.27426000),
(1019841, 1002265, 'CN', 'Lingdong', 1, 'lingdong', 46.56694000, 131.14528000),
(1019847, 1002265, 'CN', 'Linkou', 1, 'linkou', 45.28606000, 130.26151000),
(1019865, 1002265, 'CN', 'Longfeng', 1, 'longfeng', 46.53168000, 125.10380000),
(1019867, 1002265, 'CN', 'Longjiang', 1, 'longjiang', 47.33072000, 123.17816000),
(1019921, 1002265, 'CN', 'Mingshui', 1, 'mingshui', 47.18150000, 125.90027000),
(1019925, 1002265, 'CN', 'Mishan', 1, 'mishan', 45.55000000, 131.88333000),
(1019929, 1002265, 'CN', 'Mudanjiang', 1, 'mudanjiang', 44.58333000, 129.60000000),
(1019953, 1002265, 'CN', 'Nehe', 1, 'nehe', 48.48333000, 124.83333000),
(1019956, 1002265, 'CN', 'Nenjiang', 1, 'nenjiang', 49.17414000, 125.21774000),
(1019958, 1002265, 'CN', 'Nianzishan', 1, 'nianzishan', 47.51667000, 122.88333000),
(1019964, 1002265, 'CN', 'Ning’an', 1, 'ning-an', 44.34395000, 129.46556000),
(1020017, 1002265, 'CN', 'Qinggang', 1, 'qinggang', 46.68469000, 126.10595000),
(1020035, 1002265, 'CN', 'Qiqihar', 1, 'qiqihar', 47.34088000, 123.96045000),
(1020070, 1002265, 'CN', 'Shangzhi', 1, 'shangzhi', 45.21406000, 127.97426000),
(1020072, 1002265, 'CN', 'Shanhecun', 1, 'shanhecun', 45.71131000, 128.58029000),
(1020114, 1002265, 'CN', 'Shuangcheng', 1, 'shuangcheng', 45.35000000, 126.28333000),
(1020120, 1002265, 'CN', 'Shuangyashan', 1, 'shuangyashan', 46.63611000, 131.15389000),
(1020140, 1002265, 'CN', 'Suifenhe', 1, 'suifenhe', 44.39982000, 131.14775000),
(1020141, 1002265, 'CN', 'Suihua', 1, 'suihua', 46.63954000, 126.99508000),
(1020142, 1002265, 'CN', 'Suileng', 1, 'suileng', 47.24805000, 127.09535000),
(1020154, 1002265, 'CN', 'Tahe', 1, 'tahe', 52.33333000, 124.73333000),
(1020156, 1002265, 'CN', 'Taihecun', 1, 'taihecun', 45.76347000, 130.85048000),
(1020157, 1002265, 'CN', 'Taikang', 1, 'taikang', 46.86135000, 124.44200000),
(1020158, 1002265, 'CN', 'Tailai', 1, 'tailai', 46.38909000, 123.41371000),
(1020182, 1002265, 'CN', 'Tieli', 1, 'tieli', 46.98043000, 128.04497000),
(1020207, 1002265, 'CN', 'Wangkui', 1, 'wangkui', 46.83283000, 126.47768000),
(1020228, 1002265, 'CN', 'Wuchang', 1, 'wuchang', 44.91428000, 127.15001000),
(1020304, 1002265, 'CN', 'Xinqing', 1, 'xinqing', 48.28701000, 129.52337000),
(1020370, 1002265, 'CN', 'Yichun', 1, 'yichun', 47.72143000, 128.87529000),
(1020372, 1002265, 'CN', 'Yilan', 1, 'yilan', 46.31618000, 129.55455000),
(1020389, 1002265, 'CN', 'Youhao', 1, 'youhao', 47.85306000, 128.83565000),
(1020431, 1002265, 'CN', 'Zhaodong', 1, 'zhaodong', 46.06771000, 125.98263000),
(1020436, 1002265, 'CN', 'Zhaoyuan', 1, 'zhaoyuan', 45.50000000, 125.13333000),
(1020437, 1002265, 'CN', 'Zhaozhou', 1, 'zhaozhou', 45.68333000, 125.31667000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002259, 'CN', 'Henan', 1, 'henan');

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 
(1019290, 1002259, 'CN', 'Anyang', 1, 'anyang', 36.09600000, 114.38278000),
(1019291, 1002259, 'CN', 'Anyang Shi', 1, 'anyang-shi', 36.13639000, 114.33667000),
(1019342, 1002259, 'CN', 'Binhe', 1, 'binhe', 32.68833000, 112.82750000),
(1019388, 1002259, 'CN', 'Chengguan', 1, 'chengguan', 35.45861000, 113.79778000),
(1019390, 1002259, 'CN', 'Chengjiao', 1, 'chengjiao', 35.40495000, 114.06043000),
(1019428, 1002259, 'CN', 'Daokou', 1, 'daokou', 35.56389000, 114.50583000),
(1019456, 1002259, 'CN', 'Dingcheng', 1, 'dingcheng', 32.12722000, 115.03944000),
(1019594, 1002259, 'CN', 'Hancheng', 1, 'hancheng', 32.51861000, 112.35222000),
(1019602, 1002259, 'CN', 'Hebi', 1, 'hebi', 35.89917000, 114.19250000),
(1019638, 1002259, 'CN', 'Huaidian', 1, 'huaidian', 33.43333000, 115.03333000),
(1019670, 1002259, 'CN', 'Huazhou', 1, 'huazhou', 32.68222000, 112.08194000),
(1019671, 1002259, 'CN', 'Huichang', 1, 'huichang', 34.90376000, 112.78426000),
(1019708, 1002259, 'CN', 'Jianshe', 1, 'jianshe', 34.21750000, 113.76889000),
(1019712, 1002259, 'CN', 'Jiaozuo', 1, 'jiaozuo', 35.23972000, 113.23306000),
(1019754, 1002259, 'CN', 'Jishui', 1, 'jishui', 33.73333000, 115.40000000),
(1019761, 1002259, 'CN', 'Jiyuan', 1, 'jiyuan', 35.09000000, 112.58000000),
(1019766, 1002259, 'CN', 'Kaifeng', 1, 'kaifeng', 34.79860000, 114.30742000),
(1019769, 1002259, 'CN', 'Kaiyuan', 1, 'kaiyuan', 36.06813000, 113.82209000),
(1019839, 1002259, 'CN', 'Lingbao Chengguanzhen', 1, 'lingbao-chengguanzhen', 34.51972000, 110.86444000),
(1019883, 1002259, 'CN', 'Luohe', 1, 'luohe', 33.56394000, 114.04272000),
(1019884, 1002259, 'CN', 'Luohe Shi', 1, 'luohe-shi', 33.68806000, 113.91306000),
(1019889, 1002259, 'CN', 'Luoyang', 1, 'luoyang', 34.68361000, 112.45361000),
(1019918, 1002259, 'CN', 'Minggang', 1, 'minggang', 32.45861000, 114.04861000),
(1019950, 1002259, 'CN', 'Nanyang', 1, 'nanyang', 32.99472000, 112.53278000),
(1019977, 1002259, 'CN', 'Pingdingshan', 1, 'pingdingshan', 33.73847000, 113.30119000),
(1020000, 1002259, 'CN', 'Puyang Chengguanzhen', 1, 'puyang-chengguanzhen', 35.70506000, 115.01409000),
(1020001, 1002259, 'CN', 'Puyang Shi', 1, 'puyang-shi', 35.81333000, 115.15500000),
(1020021, 1002259, 'CN', 'Qingping', 1, 'qingping', 34.53656000, 113.37526000),
(1020045, 1002259, 'CN', 'Runing', 1, 'runing', 33.00111000, 114.35417000),
(1020048, 1002259, 'CN', 'Ruzhou', 1, 'ruzhou', 34.16167000, 112.82972000),
(1020066, 1002259, 'CN', 'Shangqiu', 1, 'shangqiu', 34.45000000, 115.65000000),
(1020137, 1002259, 'CN', 'Songyang', 1, 'songyang', 34.45528000, 113.02806000),
(1020147, 1002259, 'CN', 'Suohe', 1, 'suohe', 34.78722000, 113.35806000),
(1020166, 1002259, 'CN', 'Tanbei', 1, 'tanbei', 35.08806000, 112.93944000),
(1020205, 1002259, 'CN', 'Wacheng', 1, 'wacheng', 33.78333000, 114.51667000),
(1020254, 1002259, 'CN', 'Xiangcheng Chengguanzhen', 1, 'xiangcheng-chengguanzhen', 33.84703000, 113.47780000),
(1020289, 1002259, 'CN', 'Xincheng', 1, 'xincheng', 33.63333000, 115.18333000),
(1020298, 1002259, 'CN', 'Xinhualu', 1, 'xinhualu', 34.39633000, 113.72466000),
(1020308, 1002259, 'CN', 'Xinxiang', 1, 'xinxiang', 35.19033000, 113.80151000),
(1020309, 1002259, 'CN', 'Xinxiang Shi', 1, 'xinxiang-shi', 35.30861000, 114.05111000),
(1020311, 1002259, 'CN', 'Xinyang', 1, 'xinyang', 32.12278000, 114.06556000),
(1020327, 1002259, 'CN', 'Xixiang', 1, 'xixiang', 35.16278000, 112.86500000),
(1020331, 1002259, 'CN', 'Xuchang', 1, 'xuchang', 34.03189000, 113.86299000),
(1020332, 1002259, 'CN', 'Xuchang Shi', 1, 'xuchang-shi', 34.14778000, 113.71472000),
(1020338, 1002259, 'CN', 'Yakou', 1, 'yakou', 33.29649000, 113.52351000),
(1020354, 1002259, 'CN', 'Yanshi Chengguanzhen', 1, 'yanshi-chengguanzhen', 34.71601000, 112.79568000),
(1020371, 1002259, 'CN', 'Yigou', 1, 'yigou', 35.81139000, 114.31667000),
(1020373, 1002259, 'CN', 'Yima', 1, 'yima', 34.73806000, 111.88389000),
(1020376, 1002259, 'CN', 'Yingchuan', 1, 'yingchuan', 34.16278000, 113.46389000),
(1020403, 1002259, 'CN', 'Yunyang', 1, 'yunyang', 33.44743000, 112.71422000),
(1020439, 1002259, 'CN', 'Zhengzhou', 1, 'zhengzhou', 34.75778000, 113.64861000),
(1020460, 1002259, 'CN', 'Zhoukou', 1, 'zhoukou', 33.63333000, 114.63333000),
(1020470, 1002259, 'CN', 'Zhumadian', 1, 'zhumadian', 32.97944000, 114.02944000),
(1020471, 1002259, 'CN', 'Zhumadian Shi', 1, 'zhumadian-shi', 32.99417000, 114.06167000),
(1020480, 1002259, 'CN', 'Zijinglu', 1, 'zijinglu', 34.76000000, 112.97139000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002267, 'CN', 'Hong Kong', 1, 'hong-kong');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002274, 'CN', 'Hubei', 1, 'hubei');

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 
(1019282, 1002274, 'CN', 'Anlu', 1, 'anlu', 31.25750000, 113.67833000),
(1019353, 1002274, 'CN', 'Buhe', 1, 'buhe', 30.28757000, 112.22979000),
(1019355, 1002274, 'CN', 'Caidian', 1, 'caidian', 30.58333000, 114.03333000),
(1019359, 1002274, 'CN', 'Caohe', 1, 'caohe', 30.22970000, 115.43346000),
(1019396, 1002274, 'CN', 'Chengzhong', 1, 'chengzhong', 30.94454000, 113.55284000),
(1019425, 1002274, 'CN', 'Danjiangkou', 1, 'danjiangkou', 32.54278000, 111.50861000),
(1019440, 1002274, 'CN', 'Daye', 1, 'daye', 30.08333000, 114.95000000),
(1019486, 1002274, 'CN', 'Duobao', 1, 'duobao', 30.67000000, 112.68952000),
(1019491, 1002274, 'CN', 'Enshi', 1, 'enshi', 30.30000000, 109.48333000),
(1019492, 1002274, 'CN', 'Enshi Tujiazu Miaozu Zizhizhou', 1, 'enshi-tujiazu-miaozu-zizhizhou', 30.19810000, 109.67555000),
(1019495, 1002274, 'CN', 'Ezhou', 1, 'ezhou', 30.40000000, 114.83333000),
(1019496, 1002274, 'CN', 'Ezhou Shi', 1, 'ezhou-shi', 30.48832000, 114.77979000),
(1019507, 1002274, 'CN', 'Fengkou', 1, 'fengkou', 30.08268000, 113.33346000),
(1019560, 1002274, 'CN', 'Guangshui', 1, 'guangshui', 31.61990000, 113.99780000),
(1019567, 1002274, 'CN', 'Gucheng Chengguanzhen', 1, 'gucheng-chengguanzhen', 32.26604000, 111.63476000),
(1019596, 1002274, 'CN', 'Hanchuan', 1, 'hanchuan', 30.65000000, 113.76667000),
(1019647, 1002274, 'CN', 'Huanggang', 1, 'huanggang', 30.45143000, 114.87035000),
(1019651, 1002274, 'CN', 'Huangmei', 1, 'huangmei', 30.19235000, 116.02496000),
(1019654, 1002274, 'CN', 'Huangpi', 1, 'huangpi', 30.88453000, 114.37789000),
(1019658, 1002274, 'CN', 'Huangshi', 1, 'huangshi', 30.24706000, 115.04814000),
(1019663, 1002274, 'CN', 'Huangzhou', 1, 'huangzhou', 30.45000000, 114.80000000),
(1019735, 1002274, 'CN', 'Jingling', 1, 'jingling', 30.65000000, 113.10000000),
(1019736, 1002274, 'CN', 'Jingmen', 1, 'jingmen', 31.03361000, 112.20472000),
(1019737, 1002274, 'CN', 'Jingmen Shi', 1, 'jingmen-shi', 31.11244000, 112.64310000),
(1019738, 1002274, 'CN', 'Jingzhou', 1, 'jingzhou', 30.35028000, 112.19028000),
(1019805, 1002274, 'CN', 'Laohekou', 1, 'laohekou', 32.38583000, 111.66778000),
(1019834, 1002274, 'CN', 'Lichuan', 1, 'lichuan', 30.30000000, 108.85000000),
(1019900, 1002274, 'CN', 'Macheng', 1, 'macheng', 31.18013000, 115.02213000),
(1019951, 1002274, 'CN', 'Nanzhang Chengguanzhen', 1, 'nanzhang-chengguanzhen', 31.78394000, 111.82752000),
(1019997, 1002274, 'CN', 'Puqi', 1, 'puqi', 29.71667000, 113.88333000),
(1020008, 1002274, 'CN', 'Qianjiang', 1, 'qianjiang', 30.42100000, 112.89190000),
(1020022, 1002274, 'CN', 'Qingquan', 1, 'qingquan', 30.45113000, 115.25593000),
(1020085, 1002274, 'CN', 'Shashi', 1, 'shashi', 30.30722000, 112.24472000),
(1020089, 1002274, 'CN', 'Shennongjia', 1, 'shennongjia', 31.58339000, 110.49720000),
(1020109, 1002274, 'CN', 'Shiyan', 1, 'shiyan', 32.64750000, 110.77806000),
(1020145, 1002274, 'CN', 'Suizhou', 1, 'suizhou', 31.71111000, 113.36306000),
(1020233, 1002274, 'CN', 'Wuhan', 1, 'wuhan', 30.58333000, 114.26667000),
(1020240, 1002274, 'CN', 'Wuxue', 1, 'wuxue', 29.85058000, 115.55250000),
(1020258, 1002274, 'CN', 'Xiangyang', 1, 'xiangyang', 32.04220000, 112.14479000),
(1020261, 1002274, 'CN', 'Xianning', 1, 'xianning', 29.84347000, 114.32201000),
(1020262, 1002274, 'CN', 'Xianning Prefecture', 1, 'xianning-prefecture', 29.66609000, 114.26389000),
(1020266, 1002274, 'CN', 'Xiantao', 1, 'xiantao', 30.37080000, 113.44294000),
(1020269, 1002274, 'CN', 'Xiaogan', 1, 'xiaogan', 30.92689000, 113.92221000),
(1020282, 1002274, 'CN', 'Xihe', 1, 'xihe', 31.68635000, 113.46585000),
(1020290, 1002274, 'CN', 'Xindi', 1, 'xindi', 29.81667000, 113.46667000),
(1020305, 1002274, 'CN', 'Xinshi', 1, 'xinshi', 31.04704000, 113.14098000),
(1020317, 1002274, 'CN', 'Xinzhou', 1, 'xinzhou', 30.86667000, 114.80000000),
(1020323, 1002274, 'CN', 'Xiulin', 1, 'xiulin', 29.71667000, 112.40000000),
(1020366, 1002274, 'CN', 'Yichang', 1, 'yichang', 30.71444000, 111.28472000),
(1020367, 1002274, 'CN', 'Yicheng', 1, 'yicheng', 31.70472000, 112.25611000),
(1020402, 1002274, 'CN', 'Yunmeng Chengguanzhen', 1, 'yunmeng-chengguanzhen', 31.06251000, 113.76545000),
(1020414, 1002274, 'CN', 'Zaoyang', 1, 'zaoyang', 32.12722000, 112.75417000),
(1020445, 1002274, 'CN', 'Zhicheng', 1, 'zhicheng', 30.29556000, 111.50472000),
(1020446, 1002274, 'CN', 'Zhijiang', 1, 'zhijiang', 30.42139000, 111.75333000),
(1020455, 1002274, 'CN', 'Zhongxiang', 1, 'zhongxiang', 31.16611000, 112.58306000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002258, 'CN', 'Hunan', 1, 'hunan');

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 
(1019280, 1002258, 'CN', 'Anjiang', 1, 'anjiang', 27.31944000, 110.10306000),
(1019283, 1002258, 'CN', 'Anping', 1, 'anping', 27.86639000, 110.11611000),
(1019289, 1002258, 'CN', 'Anxiang', 1, 'anxiang', 29.40000000, 112.15000000),
(1019305, 1002258, 'CN', 'Baisha', 1, 'baisha', 26.52222000, 110.93111000),
(1019345, 1002258, 'CN', 'Biyong', 1, 'biyong', 27.18722000, 109.51000000),
(1019346, 1002258, 'CN', 'Bojia', 1, 'bojia', 26.46722000, 111.96806000),
(1019350, 1002258, 'CN', 'Boyang', 1, 'boyang', 26.21167000, 109.52056000),
(1019352, 1002258, 'CN', 'Bozhou', 1, 'bozhou', 27.37889000, 109.27778000),
(1019364, 1002258, 'CN', 'Changde', 1, 'changde', 29.04638000, 111.67830000),
(1019374, 1002258, 'CN', 'Changsha', 1, 'changsha', 28.19874000, 112.97087000),
(1019375, 1002258, 'CN', 'Changsha Shi', 1, 'changsha-shi', 28.14582000, 113.22967000),
(1019384, 1002258, 'CN', 'Chatian', 1, 'chatian', 27.80222000, 109.37361000),
(1019398, 1002258, 'CN', 'Chenzhou', 1, 'chenzhou', 25.80000000, 113.03333000),
(1019413, 1002258, 'CN', 'Dabaozi', 1, 'dabaozi', 26.69556000, 109.44778000),
(1019445, 1002258, 'CN', 'Dehang', 1, 'dehang', 28.30710000, 109.79668000),
(1019449, 1002258, 'CN', 'Dengjiapu', 1, 'dengjiapu', 26.90444000, 110.92000000),
(1019451, 1002258, 'CN', 'Dengyuantai', 1, 'dengyuantai', 26.68806000, 110.54222000),
(1019474, 1002258, 'CN', 'Dongshan Dongzuxiang', 1, 'dongshan-dongzuxiang', 26.59500000, 109.89667000),
(1019506, 1002258, 'CN', 'Fenghuang', 1, 'fenghuang', 27.93557000, 109.59961000),
(1019534, 1002258, 'CN', 'Gangdong', 1, 'gangdong', 27.91694000, 110.83417000),
(1019544, 1002258, 'CN', 'Gaoqiao', 1, 'gaoqiao', 26.63361000, 110.90000000),
(1019547, 1002258, 'CN', 'Gaoyi', 1, 'gaoyi', 26.95944000, 110.01556000),
(1019565, 1002258, 'CN', 'Guankou', 1, 'guankou', 28.15861000, 113.62709000),
(1019613, 1002258, 'CN', 'Hengbanqiao', 1, 'hengbanqiao', 27.17167000, 110.86528000),
(1019615, 1002258, 'CN', 'Hengyang', 1, 'hengyang', 26.88946000, 112.61888000),
(1019619, 1002258, 'CN', 'Hexiangqiao', 1, 'hexiangqiao', 27.22028000, 110.96333000),
(1019626, 1002258, 'CN', 'Hongjiang', 1, 'hongjiang', 27.11000000, 109.99556000),
(1019627, 1002258, 'CN', 'Hongqiao', 1, 'hongqiao', 26.76837000, 112.10814000),
(1019639, 1002258, 'CN', 'Huaihua', 1, 'huaihua', 27.56337000, 110.00404000),
(1019648, 1002258, 'CN', 'Huangjinjing', 1, 'huangjinjing', 27.58563000, 110.89133000),
(1019649, 1002258, 'CN', 'Huanglong', 1, 'huanglong', 26.54139000, 110.93444000),
(1019650, 1002258, 'CN', 'Huangmaoyuan', 1, 'huangmaoyuan', 27.40417000, 110.47472000),
(1019655, 1002258, 'CN', 'Huangqiao', 1, 'huangqiao', 27.02194000, 110.84056000),
(1019660, 1002258, 'CN', 'Huangtukuang', 1, 'huangtukuang', 26.91528000, 110.40778000),
(1019661, 1002258, 'CN', 'Huangxikou', 1, 'huangxikou', 27.71889000, 110.38500000),
(1019665, 1002258, 'CN', 'Huaqiao', 1, 'huaqiao', 27.70806000, 110.14194000),
(1019668, 1002258, 'CN', 'Huayuan', 1, 'huayuan', 26.91361000, 110.53583000),
(1019684, 1002258, 'CN', 'Huomachong', 1, 'huomachong', 27.88333000, 110.23000000),
(1019696, 1002258, 'CN', 'Jiangfang', 1, 'jiangfang', 26.50158000, 110.34640000),
(1019698, 1002258, 'CN', 'Jiangkouxu', 1, 'jiangkouxu', 27.69417000, 109.73583000),
(1019700, 1002258, 'CN', 'Jiangshi', 1, 'jiangshi', 27.12333000, 109.73778000),
(1019739, 1002258, 'CN', 'Jinhe', 1, 'jinhe', 27.71694000, 109.60472000),
(1019748, 1002258, 'CN', 'Jinshi', 1, 'jinshi', 29.60487000, 111.87012000),
(1019749, 1002258, 'CN', 'Jinshiqiao', 1, 'jinshiqiao', 27.58425000, 110.93634000),
(1019799, 1002258, 'CN', 'Lanli', 1, 'lanli', 27.88694000, 109.91861000),
(1019808, 1002258, 'CN', 'Leiyang', 1, 'leiyang', 26.40238000, 112.85908000),
(1019809, 1002258, 'CN', 'Lengshuijiang', 1, 'lengshuijiang', 27.68806000, 111.42944000),
(1019810, 1002258, 'CN', 'Lengshuitan', 1, 'lengshuitan', 26.41110000, 111.59559000),
(1019818, 1002258, 'CN', 'Liangyaping', 1, 'liangyaping', 27.71833000, 110.67083000),
(1019824, 1002258, 'CN', 'Lianyuan', 1, 'lianyuan', 27.68833000, 111.66417000),
(1019846, 1002258, 'CN', 'Linkou', 1, 'linkou', 26.24806000, 109.86361000),
(1019859, 1002258, 'CN', 'Liuduzhai', 1, 'liuduzhai', 27.36611000, 110.93500000),
(1019864, 1002258, 'CN', 'Lixiqiao', 1, 'lixiqiao', 26.79472000, 110.41806000),
(1019873, 1002258, 'CN', 'Longtan', 1, 'longtan', 27.41139000, 110.53639000),
(1019874, 1002258, 'CN', 'Longtou’an', 1, 'longtou-an', 27.67028000, 110.33611000),
(1019876, 1002258, 'CN', 'Loudi', 1, 'loudi', 27.73444000, 111.99444000),
(1019885, 1002258, 'CN', 'Luojiu', 1, 'luojiu', 27.51583000, 109.80889000),
(1019893, 1002258, 'CN', 'Luyang', 1, 'luyang', 27.62389000, 110.09889000),
(1019909, 1002258, 'CN', 'Ma’an', 1, 'ma-an', 26.97750000, 110.72111000),
(1019902, 1002258, 'CN', 'Malin', 1, 'malin', 26.45500000, 110.64167000),
(1019905, 1002258, 'CN', 'Maoping', 1, 'maoping', 26.51972000, 110.41194000),
(1019944, 1002258, 'CN', 'Nanmuping', 1, 'nanmuping', 27.31111000, 109.67861000),
(1019952, 1002258, 'CN', 'Nanzhou', 1, 'nanzhou', 29.35955000, 112.40243000),
(1019989, 1002258, 'CN', 'Prefecture of Chenzhou', 1, 'prefecture-of-chenzhou', 25.84347000, 113.05378000),
(1019993, 1002258, 'CN', 'Pukou', 1, 'pukou', 26.52222000, 109.55583000),
(1020002, 1002258, 'CN', 'Puzi', 1, 'puzi', 26.98639000, 109.77639000),
(1020006, 1002258, 'CN', 'Qiancheng', 1, 'qiancheng', 27.18501000, 109.76543000),
(1020010, 1002258, 'CN', 'Qianzhou', 1, 'qianzhou', 28.31925000, 109.73346000),
(1020011, 1002258, 'CN', 'Qiaojiang', 1, 'qiaojiang', 27.93722000, 110.67639000),
(1020018, 1002258, 'CN', 'Qingjiangqiao', 1, 'qingjiangqiao', 26.60444000, 110.98528000),
(1020024, 1002258, 'CN', 'Qingxi', 1, 'qingxi', 26.43114000, 110.35489000),
(1020033, 1002258, 'CN', 'Qionghu', 1, 'qionghu', 28.84061000, 112.37399000),
(1020047, 1002258, 'CN', 'Ruoshui', 1, 'ruoshui', 27.00194000, 109.96667000),
(1020065, 1002258, 'CN', 'Shangmei', 1, 'shangmei', 27.74278000, 111.29556000),
(1020073, 1002258, 'CN', 'Shanmen', 1, 'shanmen', 27.22500000, 110.69278000),
(1020094, 1002258, 'CN', 'Shijiang', 1, 'shijiang', 27.08194000, 110.79333000),
(1020116, 1002258, 'CN', 'Shuangjiang', 1, 'shuangjiang', 26.15467000, 109.71380000),
(1020117, 1002258, 'CN', 'Shuangxi', 1, 'shuangxi', 27.22833000, 109.85583000),
(1020122, 1002258, 'CN', 'Shuiche', 1, 'shuiche', 27.68694000, 110.99972000),
(1020123, 1002258, 'CN', 'Shuidatian', 1, 'shuidatian', 27.85222000, 109.60472000),
(1020128, 1002258, 'CN', 'Simenqian', 1, 'simenqian', 27.48722000, 110.88611000),
(1020167, 1002258, 'CN', 'Tangjiafang', 1, 'tangjiafang', 26.84000000, 110.36472000),
(1020175, 1002258, 'CN', 'Tanwan', 1, 'tanwan', 27.96639000, 110.15028000),
(1020196, 1002258, 'CN', 'Tongwan', 1, 'tongwan', 27.58111000, 110.27722000),
(1020199, 1002258, 'CN', 'Tuokou', 1, 'tuokou', 27.12472000, 109.62472000),
(1020210, 1002258, 'CN', 'Wantouqiao', 1, 'wantouqiao', 26.84111000, 110.61944000),
(1020225, 1002258, 'CN', 'Wenxing', 1, 'wenxing', 28.68208000, 112.87864000),
(1020235, 1002258, 'CN', 'Wulingyuan', 1, 'wulingyuan', 29.34936000, 110.54407000),
(1020238, 1002258, 'CN', 'Wuxi', 1, 'wuxi', 26.58440000, 111.85900000),
(1020242, 1002258, 'CN', 'Wuyang', 1, 'wuyang', 26.74278000, 110.32833000),
(1020255, 1002258, 'CN', 'Xiangtan', 1, 'xiangtan', 27.85000000, 112.90000000),
(1020256, 1002258, 'CN', 'Xiangxi Tujiazu Miaozu Zizhizhou', 1, 'xiangxi-tujiazu-miaozu-zizhizhou', 28.70573000, 109.73329000),
(1020257, 1002258, 'CN', 'Xiangxiang', 1, 'xiangxiang', 27.73333000, 112.53333000),
(1020264, 1002258, 'CN', 'Xianrenwan', 1, 'xianrenwan', 27.75444000, 110.32972000),
(1020267, 1002258, 'CN', 'Xianxi', 1, 'xianxi', 26.33472000, 109.64306000),
(1020270, 1002258, 'CN', 'Xiaohenglong', 1, 'xiaohenglong', 27.60500000, 110.51694000),
(1020272, 1002258, 'CN', 'Xiaolongmen', 1, 'xiaolongmen', 27.80194000, 110.16056000),
(1020273, 1002258, 'CN', 'Xiaoshajiang', 1, 'xiaoshajiang', 27.52139000, 110.74806000),
(1020322, 1002258, 'CN', 'Xishan', 1, 'xishan', 27.66667000, 113.50000000),
(1020326, 1002258, 'CN', 'Xixi', 1, 'xixi', 27.69375000, 110.95333000),
(1020328, 1002258, 'CN', 'Xiyan', 1, 'xiyan', 26.61639000, 110.47361000),
(1020353, 1002258, 'CN', 'Yanmen', 1, 'yanmen', 27.85500000, 109.74028000),
(1020360, 1002258, 'CN', 'Yaoshi', 1, 'yaoshi', 26.29306000, 110.78917000),
(1020363, 1002258, 'CN', 'Yatunpu', 1, 'yatunpu', 26.15500000, 109.62667000),
(1020384, 1002258, 'CN', 'Yiyang', 1, 'yiyang', 28.58917000, 112.32833000),
(1020386, 1002258, 'CN', 'Yongfeng', 1, 'yongfeng', 27.42829000, 112.18338000),
(1020388, 1002258, 'CN', 'Yongzhou', 1, 'yongzhou', 26.44014000, 111.60290000),
(1020396, 1002258, 'CN', 'Yueyang', 1, 'yueyang', 29.37455000, 113.09481000),
(1020397, 1002258, 'CN', 'Yueyang Shi', 1, 'yueyang-shi', 29.32472000, 113.30200000),
(1020408, 1002258, 'CN', 'Yutan', 1, 'yutan', 28.25831000, 112.56048000),
(1020418, 1002258, 'CN', 'Zhaishi Miaozu Dongzuxiang', 1, 'zhaishi-miaozu-dongzuxiang', 26.50083000, 110.04444000),
(1020421, 1002258, 'CN', 'Zhangjiajie', 1, 'zhangjiajie', 29.12944000, 110.47833000),
(1020449, 1002258, 'CN', 'Zhongfang', 1, 'zhongfang', 27.41139000, 109.93194000),
(1020457, 1002258, 'CN', 'Zhongzhai', 1, 'zhongzhai', 27.19528000, 109.26861000),
(1020474, 1002258, 'CN', 'Zhushi', 1, 'zhushi', 27.08778000, 110.67694000),
(1020475, 1002258, 'CN', 'Zhuzhou', 1, 'zhuzhou', 27.83333000, 113.15000000),
(1020476, 1002258, 'CN', 'Zhuzhou Shi', 1, 'zhuzhou-shi', 27.82450000, 113.08228000),
(1020477, 1002258, 'CN', 'Zhuzhoujiang Miaozuxiang', 1, 'zhuzhoujiang-miaozuxiang', 26.67528000, 110.07194000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002269, 'CN', 'Inner Mongolia', 1, 'inner-mongolia');

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 
(1019318, 1002269, 'CN', 'Baotou', 1, 'baotou', 40.65222000, 109.82222000),
(1019323, 1002269, 'CN', 'Bayan Nur', 1, 'bayan-nur', 40.74143000, 107.38599000),
(1019324, 1002269, 'CN', 'Bayannur Shi', 1, 'bayannur-shi', 41.56958000, 107.49485000),
(1019328, 1002269, 'CN', 'Beichengqu', 1, 'beichengqu', 40.43944000, 113.15361000),
(1019399, 1002269, 'CN', 'Chifeng', 1, 'chifeng', 42.26833000, 118.96361000),
(1019475, 1002269, 'CN', 'Dongsheng', 1, 'dongsheng', 39.81609000, 109.97763000),
(1019497, 1002269, 'CN', 'E’erguna', 1, 'e-erguna', 50.22362000, 120.17092000),
(1019494, 1002269, 'CN', 'Erenhot', 1, 'erenhot', 43.64750000, 111.97667000),
(1019553, 1002269, 'CN', 'Genhe', 1, 'genhe', 50.78333000, 121.51667000),
(1019587, 1002269, 'CN', 'Hailar', 1, 'hailar', 49.20000000, 119.70000000),
(1019623, 1002269, 'CN', 'Hohhot', 1, 'hohhot', 40.81056000, 111.65222000),
(1019680, 1002269, 'CN', 'Hulunbuir Region', 1, 'hulunbuir-region', 49.70989000, 121.72176000),
(1019691, 1002269, 'CN', 'Jalai Nur', 1, 'jalai-nur', 49.45000000, 117.70000000),
(1019692, 1002269, 'CN', 'Jiagedaqi', 1, 'jiagedaqi', 50.41667000, 124.11667000),
(1019742, 1002269, 'CN', 'Jining', 1, 'jining', 41.02750000, 113.10583000),
(1019903, 1002269, 'CN', 'Manzhouli', 1, 'manzhouli', 49.60000000, 117.43333000),
(1019928, 1002269, 'CN', 'Mositai', 1, 'mositai', 45.53538000, 119.66698000),
(1019931, 1002269, 'CN', 'Mujiayingzi', 1, 'mujiayingzi', 42.11667000, 118.78333000),
(1019967, 1002269, 'CN', 'Ordos', 1, 'ordos', 39.60860000, 109.78157000),
(1019968, 1002269, 'CN', 'Ordos Shi', 1, 'ordos-shi', 39.46142000, 108.80946000),
(1019969, 1002269, 'CN', 'Oroqen Zizhiqi', 1, 'oroqen-zizhiqi', 50.56667000, 123.71667000),
(1019986, 1002269, 'CN', 'Pingzhuang', 1, 'pingzhuang', 42.03722000, 119.28889000),
(1020050, 1002269, 'CN', 'Salaqi', 1, 'salaqi', 40.54139000, 110.51083000),
(1020092, 1002269, 'CN', 'Shiguai', 1, 'shiguai', 40.70583000, 110.28556000),
(1020192, 1002269, 'CN', 'Tongliao', 1, 'tongliao', 43.61250000, 122.26528000),
(1020203, 1002269, 'CN', 'Ulanhot', 1, 'ulanhot', 46.08333000, 122.08333000),
(1020220, 1002269, 'CN', 'Wenquan', 1, 'wenquan', 47.17560000, 119.94809000),
(1020231, 1002269, 'CN', 'Wuda', 1, 'wuda', 39.49944000, 106.71167000),
(1020232, 1002269, 'CN', 'Wuhai', 1, 'wuhai', 39.68442000, 106.81583000),
(1020284, 1002269, 'CN', 'Xilin Gol Meng', 1, 'xilin-gol-meng', 44.85493000, 115.72789000),
(1020285, 1002269, 'CN', 'Xilin Hot', 1, 'xilin-hot', 43.96667000, 116.03333000),
(1020336, 1002269, 'CN', 'Yakeshi', 1, 'yakeshi', 49.28333000, 120.73333000),
(1020419, 1002269, 'CN', 'Zhalantun', 1, 'zhalantun', 48.00945000, 122.73651000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002250, 'CN', 'Jiangsu', 1, 'jiangsu');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002256, 'CN', 'Jiangxi', 1, 'jiangxi');

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 
(1019367, 1002256, 'CN', 'Changleng', 1, 'changleng', 28.70000000, 115.81667000),
(1019513, 1002256, 'CN', 'Fenyi', 1, 'fenyi', 27.81117000, 114.66805000),
(1019538, 1002256, 'CN', 'Ganzhou', 1, 'ganzhou', 25.84664000, 114.93260000),
(1019539, 1002256, 'CN', 'Ganzhou Shi', 1, 'ganzhou-shi', 25.70387000, 115.34822000),
(1019574, 1002256, 'CN', 'Guixi', 1, 'guixi', 28.28857000, 117.21329000),
(1019762, 1002256, 'CN', 'Ji’an', 1, 'ji-an', 27.11716000, 114.97927000),
(1019701, 1002256, 'CN', 'Jianguang', 1, 'jianguang', 28.19377000, 115.78360000),
(1019730, 1002256, 'CN', 'Jingdezhen', 1, 'jingdezhen', 29.29470000, 117.20789000),
(1019731, 1002256, 'CN', 'Jingdezhen Shi', 1, 'jingdezhen-shi', 29.31682000, 117.24688000),
(1019756, 1002256, 'CN', 'Jiujiang', 1, 'jiujiang', 29.70475000, 116.00206000),
(1019935, 1002256, 'CN', 'Nanchang', 1, 'nanchang', 28.68396000, 115.85306000),
(1019983, 1002256, 'CN', 'Pingxiang', 1, 'pingxiang', 27.61672000, 113.85353000),
(1019988, 1002256, 'CN', 'Poyang', 1, 'poyang', 28.99242000, 116.66754000),
(1020067, 1002256, 'CN', 'Shangrao', 1, 'shangrao', 28.45179000, 117.94287000),
(1020313, 1002256, 'CN', 'Xinyu', 1, 'xinyu', 27.80429000, 114.93335000),
(1020369, 1002256, 'CN', 'Yichun', 1, 'yichun', 27.83333000, 114.40000000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002253, 'CN', 'Jilin', 1, 'jilin');

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 
(1019298, 1002253, 'CN', 'Baicheng', 1, 'baicheng', 45.60746000, 122.82076000),
(1019306, 1002253, 'CN', 'Baishan', 1, 'baishan', 41.93853000, 126.41965000),
(1019308, 1002253, 'CN', 'Baishishan', 1, 'baishishan', 43.58333000, 127.56667000),
(1019363, 1002253, 'CN', 'Changchun', 1, 'changchun', 43.88000000, 125.32278000),
(1019369, 1002253, 'CN', 'Changling', 1, 'changling', 44.26532000, 124.00045000),
(1019381, 1002253, 'CN', 'Chaoyang', 1, 'chaoyang', 42.66223000, 126.02630000),
(1019418, 1002253, 'CN', 'Dalai', 1, 'dalai', 45.50000000, 124.30000000),
(1019434, 1002253, 'CN', 'Dashitou', 1, 'dashitou', 43.30667000, 128.51139000),
(1019447, 1002253, 'CN', 'Dehui', 1, 'dehui', 44.53333000, 125.70000000),
(1019466, 1002253, 'CN', 'Dongfeng', 1, 'dongfeng', 42.64031000, 125.51176000),
(1019485, 1002253, 'CN', 'Dunhua', 1, 'dunhua', 43.37250000, 128.24250000),
(1019493, 1002253, 'CN', 'Erdaojiang', 1, 'erdaojiang', 41.77639000, 126.03194000),
(1019529, 1002253, 'CN', 'Fuyu', 1, 'fuyu', 45.18333000, 124.81667000),
(1019557, 1002253, 'CN', 'Gongzhuling', 1, 'gongzhuling', 43.50075000, 124.81979000),
(1019559, 1002253, 'CN', 'Guangming', 1, 'guangming', 45.33333000, 122.78333000),
(1019612, 1002253, 'CN', 'Helong', 1, 'helong', 42.53974000, 128.99722000),
(1019616, 1002253, 'CN', 'Hepingjie', 1, 'hepingjie', 42.05972000, 126.91583000),
(1019634, 1002253, 'CN', 'Huadian', 1, 'huadian', 42.96333000, 126.74778000),
(1019653, 1002253, 'CN', 'Huangnihe', 1, 'huangnihe', 43.55833000, 128.02389000),
(1019674, 1002253, 'CN', 'Huinan', 1, 'huinan', 42.62250000, 126.26139000),
(1019682, 1002253, 'CN', 'Hunchun', 1, 'hunchun', 42.86750000, 130.35806000),
(1019763, 1002253, 'CN', 'Ji’an', 1, 'ji-an', 41.12349000, 126.17631000),
(1019725, 1002253, 'CN', 'Jilin', 1, 'jilin', 43.85083000, 126.56028000),
(1019753, 1002253, 'CN', 'Jishu', 1, 'jishu', 44.31667000, 126.80000000),
(1019759, 1002253, 'CN', 'Jiutai', 1, 'jiutai', 44.15250000, 125.83278000),
(1019768, 1002253, 'CN', 'Kaitong', 1, 'kaitong', 44.81351000, 123.15000000),
(1019830, 1002253, 'CN', 'Liaoyuan', 1, 'liaoyuan', 42.90361000, 125.13583000),
(1019845, 1002253, 'CN', 'Linjiang', 1, 'linjiang', 41.80694000, 126.90778000),
(1019857, 1002253, 'CN', 'Lishu', 1, 'lishu', 43.30472000, 124.32778000),
(1019860, 1002253, 'CN', 'Liuhe', 1, 'liuhe', 42.24007000, 125.71717000),
(1019868, 1002253, 'CN', 'Longjing', 1, 'longjing', 42.77139000, 129.42333000),
(1019910, 1002253, 'CN', 'Meihekou', 1, 'meihekou', 42.52722000, 125.67528000),
(1019922, 1002253, 'CN', 'Mingyue', 1, 'mingyue', 43.10694000, 128.92167000),
(1019923, 1002253, 'CN', 'Minzhu', 1, 'minzhu', 43.72145000, 127.33401000),
(1019974, 1002253, 'CN', 'Panshi', 1, 'panshi', 42.94222000, 126.05611000),
(1020052, 1002253, 'CN', 'Sanchazi', 1, 'sanchazi', 42.08167000, 126.60028000),
(1020119, 1002253, 'CN', 'Shuangyang', 1, 'shuangyang', 43.52417000, 125.67361000),
(1020125, 1002253, 'CN', 'Shulan', 1, 'shulan', 44.41667000, 126.95000000),
(1020129, 1002253, 'CN', 'Siping', 1, 'siping', 43.16143000, 124.37785000),
(1020133, 1002253, 'CN', 'Songjianghe', 1, 'songjianghe', 42.18590000, 127.47895000),
(1020138, 1002253, 'CN', 'Songyuan', 1, 'songyuan', 45.12902000, 124.82769000),
(1020190, 1002253, 'CN', 'Tonghua', 1, 'tonghua', 41.71972000, 125.92639000),
(1020191, 1002253, 'CN', 'Tonghua Shi', 1, 'tonghua-shi', 42.12389000, 125.84833000),
(1020198, 1002253, 'CN', 'Tumen', 1, 'tumen', 42.96611000, 129.84250000),
(1020208, 1002253, 'CN', 'Wangqing', 1, 'wangqing', 43.32179000, 129.76342000),
(1020295, 1002253, 'CN', 'Xinglongshan', 1, 'xinglongshan', 43.95611000, 125.46611000),
(1020339, 1002253, 'CN', 'Yanbian Chaoxianzu Zizhizhou', 1, 'yanbian-chaoxianzu-zizhizhou', 43.12583000, 129.12833000),
(1020350, 1002253, 'CN', 'Yanji', 1, 'yanji', 42.90750000, 129.50778000),
(1020358, 1002253, 'CN', 'Yantongshan', 1, 'yantongshan', 43.29194000, 126.00944000),
(1020406, 1002253, 'CN', 'Yushu', 1, 'yushu', 44.80000000, 126.53333000),
(1020438, 1002253, 'CN', 'Zhengjiatun', 1, 'zhengjiatun', 43.50639000, 123.50639000),
(1020442, 1002253, 'CN', 'Zhenlai', 1, 'zhenlai', 45.84955000, 123.29730000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002276, 'CN', 'Keelung', 1, 'keelung');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002268, 'CN', 'Liaoning', 1, 'liaoning');

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 
(1019287, 1002268, 'CN', 'Anshan', 1, 'anshan', 41.12361000, 122.99000000),
(1019333, 1002268, 'CN', 'Beipiao', 1, 'beipiao', 41.79194000, 120.77917000),
(1019339, 1002268, 'CN', 'Benxi', 1, 'benxi', 41.28861000, 123.76500000),
(1019377, 1002268, 'CN', 'Changtu', 1, 'changtu', 42.77884000, 124.09545000),
(1019382, 1002268, 'CN', 'Chaoyang', 1, 'chaoyang', 41.57028000, 120.45861000),
(1019421, 1002268, 'CN', 'Dalian', 1, 'dalian', 38.91222000, 121.60222000),
(1019423, 1002268, 'CN', 'Dalianwan', 1, 'dalianwan', 39.02861000, 121.69500000),
(1019424, 1002268, 'CN', 'Dandong', 1, 'dandong', 40.12917000, 124.39472000),
(1019433, 1002268, 'CN', 'Dashiqiao', 1, 'dashiqiao', 40.63732000, 122.50251000),
(1019472, 1002268, 'CN', 'Dongling', 1, 'dongling', 41.81444000, 123.57583000),
(1019504, 1002268, 'CN', 'Fengcheng', 1, 'fengcheng', 40.45361000, 124.07167000),
(1019523, 1002268, 'CN', 'Fushun', 1, 'fushun', 41.88669000, 123.94363000),
(1019524, 1002268, 'CN', 'Fuxin', 1, 'fuxin', 42.01556000, 121.65889000),
(1019533, 1002268, 'CN', 'Gaizhou', 1, 'gaizhou', 40.39417000, 122.36861000),
(1019556, 1002268, 'CN', 'Gongchangling', 1, 'gongchangling', 41.11667000, 123.45000000),
(1019583, 1002268, 'CN', 'Haicheng', 1, 'haicheng', 40.85158000, 122.74754000),
(1019611, 1002268, 'CN', 'Heishan', 1, 'heishan', 41.68917000, 122.11278000),
(1019664, 1002268, 'CN', 'Huanren', 1, 'huanren', 41.26472000, 125.36667000),
(1019678, 1002268, 'CN', 'Huludao', 1, 'huludao', 40.75243000, 120.83552000),
(1019679, 1002268, 'CN', 'Huludao Shi', 1, 'huludao-shi', 40.74528000, 120.21972000),
(1019687, 1002268, 'CN', 'Hushitai', 1, 'hushitai', 41.94175000, 123.50266000),
(1019752, 1002268, 'CN', 'Jinzhou', 1, 'jinzhou', 41.10778000, 121.14167000),
(1019757, 1002268, 'CN', 'Jiupu', 1, 'jiupu', 41.06667000, 122.95000000),
(1019771, 1002268, 'CN', 'Kaiyuan', 1, 'kaiyuan', 42.53306000, 124.04028000),
(1019781, 1002268, 'CN', 'Kuandian', 1, 'kuandian', 40.72861000, 124.78472000),
(1019796, 1002268, 'CN', 'Langtoucun', 1, 'langtoucun', 40.04068000, 124.33525000),
(1019823, 1002268, 'CN', 'Lianshan', 1, 'lianshan', 40.76432000, 120.85327000),
(1019829, 1002268, 'CN', 'Liaoyang', 1, 'liaoyang', 41.27194000, 123.17306000),
(1019831, 1002268, 'CN', 'Liaozhong', 1, 'liaozhong', 41.50611000, 122.72417000),
(1019842, 1002268, 'CN', 'Linghai', 1, 'linghai', 41.16528000, 121.36667000),
(1019843, 1002268, 'CN', 'Lingyuan', 1, 'lingyuan', 41.24000000, 119.40111000),
(1019897, 1002268, 'CN', 'Lüshun', 1, 'lushun', 38.80000000, 121.26667000),
(1019946, 1002268, 'CN', 'Nanpiao', 1, 'nanpiao', 41.09822000, 120.74792000),
(1019948, 1002268, 'CN', 'Nantai', 1, 'nantai', 40.92410000, 122.80437000),
(1019972, 1002268, 'CN', 'Panjin Shi', 1, 'panjin-shi', 41.13167000, 121.99361000),
(1019973, 1002268, 'CN', 'Panshan', 1, 'panshan', 41.18806000, 122.04944000),
(1019994, 1002268, 'CN', 'Pulandian', 1, 'pulandian', 39.39528000, 121.96694000),
(1020090, 1002268, 'CN', 'Shenyang', 1, 'shenyang', 41.79222000, 123.43278000),
(1020146, 1002268, 'CN', 'Sujiatun', 1, 'sujiatun', 41.65917000, 123.33917000),
(1020183, 1002268, 'CN', 'Tieling', 1, 'tieling', 42.29306000, 123.84139000),
(1020184, 1002268, 'CN', 'Tieling Shi', 1, 'tieling-shi', 42.62583000, 124.32361000),
(1020206, 1002268, 'CN', 'Wafangdian', 1, 'wafangdian', 39.61833000, 122.00806000),
(1020275, 1002268, 'CN', 'Xiaoshi', 1, 'xiaoshi', 41.29711000, 124.12092000),
(1020281, 1002268, 'CN', 'Xifeng', 1, 'xifeng', 42.73722000, 124.72222000),
(1020293, 1002268, 'CN', 'Xingcheng', 1, 'xingcheng', 40.61667000, 120.71667000),
(1020302, 1002268, 'CN', 'Xinmin', 1, 'xinmin', 41.99083000, 122.82528000),
(1020310, 1002268, 'CN', 'Xinxing', 1, 'xinxing', 39.86694000, 124.12304000),
(1020324, 1002268, 'CN', 'Xiuyan', 1, 'xiuyan', 40.29278000, 123.27444000),
(1020364, 1002268, 'CN', 'Yebaishou', 1, 'yebaishou', 41.39750000, 119.64083000),
(1020378, 1002268, 'CN', 'Yingkou', 1, 'yingkou', 40.63897000, 122.24762000),
(1020464, 1002268, 'CN', 'Zhuanghe', 1, 'zhuanghe', 39.70083000, 122.99111000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002266, 'CN', 'Macau', 1, 'macau');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002262, 'CN', 'Ningxia Hui Autonomous Region', 1, 'ningxia-hui-autonomous-region');

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 
(1019438, 1002262, 'CN', 'Dawukou', 1, 'dawukou', 39.04194000, 106.39583000),
(1019476, 1002262, 'CN', 'Dongta', 1, 'dongta', 38.08140000, 106.34444000),
(1020106, 1002262, 'CN', 'Shitanjing', 1, 'shitanjing', 39.23417000, 106.34389000),
(1020111, 1002262, 'CN', 'Shizuishan', 1, 'shizuishan', 39.23333000, 106.76944000),
(1020246, 1002262, 'CN', 'Wuzhong', 1, 'wuzhong', 37.98670000, 106.20100000),
(1020374, 1002262, 'CN', 'Yinchuan', 1, 'yinchuan', 38.46806000, 106.27306000),
(1020454, 1002262, 'CN', 'Zhongwei', 1, 'zhongwei', 37.51129000, 105.19067000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002270, 'CN', 'Qinghai', 1, 'qinghai');

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 
(1019448, 1002270, 'CN', 'Delingha', 1, 'delingha', 37.37600000, 97.37457000),
(1019554, 1002270, 'CN', 'Golmud', 1, 'golmud', 36.40672000, 94.90061000),
(1019555, 1002270, 'CN', 'Golog Tibetan Autonomous Prefecture', 1, 'golog-tibetan-autonomous-prefecture', 34.08595000, 99.55181000),
(1019582, 1002270, 'CN', 'Haibei Tibetan Autonomous Prefecture', 1, 'haibei-tibetan-autonomous-prefecture', 37.71919000, 100.45656000),
(1019652, 1002270, 'CN', 'Huangnan Zangzu Zizhizhou', 1, 'huangnan-zangzu-zizhizhou', 35.06316000, 101.65149000),
(1020300, 1002270, 'CN', 'Xining', 1, 'xining', 36.62554000, 101.75739000),
(1020320, 1002270, 'CN', 'Xireg', 1, 'xireg', 36.91866000, 98.44463000),
(1020407, 1002270, 'CN', 'Yushu Zangzu Zizhizhou', 1, 'yushu-zangzu-zizhizhou', 34.39802000, 94.19021000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002272, 'CN', 'Shaanxi', 1, 'shaanxi');

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 
(1019281, 1002272, 'CN', 'Ankang', 1, 'ankang', 32.68000000, 109.01722000),
(1019315, 1002272, 'CN', 'Baoji Shi', 1, 'baoji-shi', 34.36944000, 107.13635000),
(1019578, 1002272, 'CN', 'Guozhen', 1, 'guozhen', 34.36591000, 107.35904000),
(1019595, 1002272, 'CN', 'Hancheng', 1, 'hancheng', 35.46028000, 110.42917000),
(1019600, 1002272, 'CN', 'Hanzhong', 1, 'hanzhong', 33.07507000, 107.02214000),
(1019667, 1002272, 'CN', 'Huayin', 1, 'huayin', 34.56528000, 110.06639000),
(1019852, 1002272, 'CN', 'Lintong', 1, 'lintong', 34.37803000, 109.20892000),
(1020188, 1002272, 'CN', 'Tongchuanshi', 1, 'tongchuanshi', 35.07474000, 109.08495000),
(1020215, 1002272, 'CN', 'Weinan', 1, 'weinan', 34.50355000, 109.50891000),
(1020329, 1002272, 'CN', 'Xi’an', 1, 'xi-an', 34.25833000, 108.92861000),
(1020268, 1002272, 'CN', 'Xianyang', 1, 'xianyang', 34.33778000, 108.70261000),
(1020352, 1002272, 'CN', 'Yanliang', 1, 'yanliang', 34.65918000, 109.22921000),
(1020399, 1002272, 'CN', 'Yulinshi', 1, 'yulinshi', 38.29181000, 109.73753000),
(1020410, 1002272, 'CN', 'Yuxia', 1, 'yuxia', 34.06153000, 108.62905000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002252, 'CN', 'Shandong', 1, 'shandong');

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 
(1019286, 1002252, 'CN', 'Anqiu', 1, 'anqiu', 36.43417000, 119.19250000),
(1019335, 1002252, 'CN', 'Beizhai', 1, 'beizhai', 36.21972000, 120.52889000),
(1019340, 1002252, 'CN', 'Bianzhuang', 1, 'bianzhuang', 34.84861000, 118.04472000),
(1019343, 1002252, 'CN', 'Binzhou', 1, 'binzhou', 37.36667000, 118.01667000),
(1019348, 1002252, 'CN', 'Boshan', 1, 'boshan', 36.48333000, 117.83333000),
(1019372, 1002252, 'CN', 'Changqing', 1, 'changqing', 36.55750000, 116.72722000),
(1019392, 1002252, 'CN', 'Chengqu', 1, 'chengqu', 36.91060000, 121.52504000),
(1019393, 1002252, 'CN', 'Chengtangcun', 1, 'chengtangcun', 35.08357000, 117.19071000),
(1019395, 1002252, 'CN', 'Chengyang', 1, 'chengyang', 35.57944000, 118.83278000),
(1019450, 1002252, 'CN', 'Dengying', 1, 'dengying', 36.13889000, 120.57417000),
(1019452, 1002252, 'CN', 'Dengzhou', 1, 'dengzhou', 37.80822000, 120.75908000),
(1019455, 1002252, 'CN', 'Dezhou', 1, 'dezhou', 37.45127000, 116.31046000),
(1019458, 1002252, 'CN', 'Dingtao', 1, 'dingtao', 35.07436000, 115.56582000),
(1019463, 1002252, 'CN', 'Dongcun', 1, 'dongcun', 36.77667000, 121.15972000),
(1019465, 1002252, 'CN', 'Dongdu', 1, 'dongdu', 35.85000000, 117.70000000),
(1019501, 1002252, 'CN', 'Feicheng', 1, 'feicheng', 36.24861000, 116.76583000),
(1019541, 1002252, 'CN', 'Gaomi', 1, 'gaomi', 36.38333000, 119.75278000),
(1019599, 1002252, 'CN', 'Hanting', 1, 'hanting', 36.77083000, 119.21083000),
(1019621, 1002252, 'CN', 'Heze', 1, 'heze', 35.23929000, 115.47358000),
(1019693, 1002252, 'CN', 'Jiamaying', 1, 'jiamaying', 37.20806000, 115.95000000),
(1019711, 1002252, 'CN', 'Jiaozhou', 1, 'jiaozhou', 36.28389000, 120.00333000),
(1019719, 1002252, 'CN', 'Jiehu', 1, 'jiehu', 35.54278000, 118.45500000),
(1019726, 1002252, 'CN', 'Jimo', 1, 'jimo', 36.38972000, 120.46222000),
(1019727, 1002252, 'CN', 'Jinan', 1, 'jinan', 36.66833000, 116.99722000),
(1019741, 1002252, 'CN', 'Jining', 1, 'jining', 35.40500000, 116.58139000),
(1019765, 1002252, 'CN', 'Juye', 1, 'juye', 35.39472000, 116.08833000),
(1019782, 1002252, 'CN', 'Kuiju', 1, 'kuiju', 36.85361000, 119.39083000),
(1019787, 1002252, 'CN', 'Kutao', 1, 'kutao', 36.14500000, 120.48778000),
(1019790, 1002252, 'CN', 'Laiwu', 1, 'laiwu', 36.19278000, 117.65694000),
(1019791, 1002252, 'CN', 'Laixi', 1, 'laixi', 36.85917000, 120.52694000),
(1019792, 1002252, 'CN', 'Laiyang', 1, 'laiyang', 36.97583000, 120.71361000),
(1019793, 1002252, 'CN', 'Laizhou', 1, 'laizhou', 37.18073000, 119.94217000),
(1019804, 1002252, 'CN', 'Laocheng', 1, 'laocheng', 37.14278000, 115.88833000),
(1019828, 1002252, 'CN', 'Liaocheng', 1, 'liaocheng', 36.45596000, 115.97766000),
(1019850, 1002252, 'CN', 'Linqu', 1, 'linqu', 36.51556000, 118.53972000),
(1019856, 1002252, 'CN', 'Linyi', 1, 'linyi', 35.06306000, 118.34278000),
(1019866, 1002252, 'CN', 'Longgang', 1, 'longgang', 37.65181000, 120.33063000),
(1019915, 1002252, 'CN', 'Mengyin', 1, 'mengyin', 35.70694000, 117.92639000),
(1019920, 1002252, 'CN', 'Mingshui', 1, 'mingshui', 36.71667000, 117.50000000),
(1019927, 1002252, 'CN', 'Mizhou', 1, 'mizhou', 35.99472000, 119.39750000),
(1019937, 1002252, 'CN', 'Nanding', 1, 'nanding', 36.74833000, 118.05583000),
(1019943, 1002252, 'CN', 'Nanma', 1, 'nanma', 36.18478000, 118.15486000),
(1019962, 1002252, 'CN', 'Ninghai', 1, 'ninghai', 37.38422000, 121.60859000),
(1019963, 1002252, 'CN', 'Ningyang', 1, 'ningyang', 35.76417000, 116.79139000),
(1019978, 1002252, 'CN', 'Pingdu', 1, 'pingdu', 36.78444000, 119.94639000),
(1019984, 1002252, 'CN', 'Pingyi', 1, 'pingyi', 35.50056000, 117.63083000),
(1019985, 1002252, 'CN', 'Pingyin', 1, 'pingyin', 36.28306000, 116.44528000),
(1020016, 1002252, 'CN', 'Qingdao', 1, 'qingdao', 36.06488000, 120.38042000),
(1020020, 1002252, 'CN', 'Qingnian', 1, 'qingnian', 36.84032000, 115.71183000),
(1020023, 1002252, 'CN', 'Qingshancun', 1, 'qingshancun', 36.15415000, 120.68240000),
(1020025, 1002252, 'CN', 'Qingyang', 1, 'qingyang', 37.49583000, 121.25806000),
(1020028, 1002252, 'CN', 'Qingzhou', 1, 'qingzhou', 36.69667000, 118.47972000),
(1020037, 1002252, 'CN', 'Qufu', 1, 'qufu', 35.59667000, 116.99111000),
(1020042, 1002252, 'CN', 'Rizhao', 1, 'rizhao', 35.42750000, 119.45528000),
(1020062, 1002252, 'CN', 'Shancheng', 1, 'shancheng', 34.79528000, 116.08167000),
(1020075, 1002252, 'CN', 'Shanting', 1, 'shanting', 35.07528000, 117.45778000),
(1020086, 1002252, 'CN', 'Shazikou', 1, 'shazikou', 36.11500000, 120.53722000),
(1020087, 1002252, 'CN', 'Shengli', 1, 'shengli', 37.46271000, 118.49165000),
(1020099, 1002252, 'CN', 'Shilaorencun', 1, 'shilaorencun', 36.09723000, 120.48910000),
(1020110, 1002252, 'CN', 'Shizilu', 1, 'shizilu', 35.17111000, 118.82889000),
(1020112, 1002252, 'CN', 'Shouguang', 1, 'shouguang', 36.88000000, 118.73750000),
(1020131, 1002252, 'CN', 'Sishui', 1, 'sishui', 35.64889000, 117.27583000),
(1020148, 1002252, 'CN', 'Suozhen', 1, 'suozhen', 36.95389000, 118.10472000),
(1020165, 1002252, 'CN', 'Tai’an', 1, 'tai-an', 36.18528000, 117.12000000),
(1020176, 1002252, 'CN', 'Taozhuang', 1, 'taozhuang', 34.85000000, 117.33333000),
(1020179, 1002252, 'CN', 'Tianfu', 1, 'tianfu', 37.19723000, 122.05228000),
(1020213, 1002252, 'CN', 'Weifang', 1, 'weifang', 36.71000000, 119.10194000),
(1020214, 1002252, 'CN', 'Weihai', 1, 'weihai', 37.50914000, 122.11356000),
(1020223, 1002252, 'CN', 'Wenshang', 1, 'wenshang', 35.72750000, 116.49611000),
(1020277, 1002252, 'CN', 'Xiazhen', 1, 'xiazhen', 34.80222000, 117.11167000),
(1020278, 1002252, 'CN', 'Xiazhuang', 1, 'xiazhuang', 34.91611000, 118.63889000),
(1020283, 1002252, 'CN', 'Xiliguantun', 1, 'xiliguantun', 37.07833000, 115.94139000),
(1020291, 1002252, 'CN', 'Xindian', 1, 'xindian', 36.79750000, 118.29444000),
(1020306, 1002252, 'CN', 'Xintai', 1, 'xintai', 35.90056000, 117.75194000),
(1020342, 1002252, 'CN', 'Yanggu', 1, 'yanggu', 36.11056000, 115.77528000),
(1020355, 1002252, 'CN', 'Yanta', 1, 'yanta', 36.24111000, 115.66722000),
(1020356, 1002252, 'CN', 'Yantai', 1, 'yantai', 37.47649000, 121.44081000),
(1020359, 1002252, 'CN', 'Yanzhou', 1, 'yanzhou', 35.55278000, 116.82861000),
(1020362, 1002252, 'CN', 'Yatou', 1, 'yatou', 37.15660000, 122.43762000),
(1020381, 1002252, 'CN', 'Yinzhu', 1, 'yinzhu', 35.87861000, 119.97528000),
(1020382, 1002252, 'CN', 'Yishui', 1, 'yishui', 35.78472000, 118.62806000),
(1020393, 1002252, 'CN', 'Yucheng', 1, 'yucheng', 34.92889000, 116.46528000),
(1020415, 1002252, 'CN', 'Zaozhuang', 1, 'zaozhuang', 34.86472000, 117.55417000),
(1020435, 1002252, 'CN', 'Zhaoyuan', 1, 'zhaoyuan', 37.36497000, 120.40997000),
(1020458, 1002252, 'CN', 'Zhoucheng', 1, 'zhoucheng', 35.91222000, 116.31167000),
(1020459, 1002252, 'CN', 'Zhoucun', 1, 'zhoucun', 36.81667000, 117.81667000),
(1020463, 1002252, 'CN', 'Zhu Cheng City', 1, 'zhu-cheng-city', 35.99502000, 119.40259000),
(1020465, 1002252, 'CN', 'Zhuangyuan', 1, 'zhuangyuan', 37.30553000, 120.82747000),
(1020478, 1002252, 'CN', 'Zibo', 1, 'zibo', 36.79056000, 118.06333000),
(1020481, 1002252, 'CN', 'Zoucheng', 1, 'zoucheng', 35.40056000, 116.96556000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002249, 'CN', 'Shanghai', 1, 'shanghai');

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 
(1020063, 1002249, 'CN', 'Shanghai', 1, 'shanghai', 31.22222000, 121.45806000),
(1020132, 1002249, 'CN', 'Songjiang', 1, 'songjiang', 31.03595000, 121.21460000),
(1020417, 1002249, 'CN', 'Zhabei', 1, 'zhabei', 31.25861000, 121.45972000),
(1020469, 1002249, 'CN', 'Zhujiajiao', 1, 'zhujiajiao', 31.10757000, 121.05696000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002254, 'CN', 'Shanxi', 1, 'shanxi');

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 
(1019378, 1002254, 'CN', 'Changzhi', 1, 'changzhi', 36.18389000, 113.10528000),
(1019436, 1002254, 'CN', 'Datong', 1, 'datong', 40.09361000, 113.29139000),
(1019437, 1002254, 'CN', 'Datong Shi', 1, 'datong-shi', 40.10484000, 113.63334000),
(1019580, 1002254, 'CN', 'Gutao', 1, 'gutao', 37.20250000, 112.17806000),
(1019722, 1002254, 'CN', 'Jiexiu', 1, 'jiexiu', 37.02444000, 111.91250000),
(1019729, 1002254, 'CN', 'Jincheng', 1, 'jincheng', 35.50222000, 112.83278000),
(1019751, 1002254, 'CN', 'Jinzhong Shi', 1, 'jinzhong-shi', 37.43597000, 113.08783000),
(1019838, 1002254, 'CN', 'Linfen', 1, 'linfen', 36.08889000, 111.51889000),
(1019896, 1002254, 'CN', 'Lüliang', 1, 'luliang', 37.73563000, 111.30538000),
(1020127, 1002254, 'CN', 'Shuozhou', 1, 'shuozhou', 39.31583000, 112.42250000),
(1020162, 1002254, 'CN', 'Taiyuan', 1, 'taiyuan', 37.86944000, 112.56028000),
(1020307, 1002254, 'CN', 'Xintian', 1, 'xintian', 35.61358000, 111.35660000),
(1020316, 1002254, 'CN', 'Xinzhi', 1, 'xinzhi', 36.49889000, 111.70472000),
(1020318, 1002254, 'CN', 'Xinzhou', 1, 'xinzhou', 38.40917000, 112.73333000),
(1020345, 1002254, 'CN', 'Yangquan', 1, 'yangquan', 37.85750000, 113.56333000),
(1020391, 1002254, 'CN', 'Yuanping', 1, 'yuanping', 38.71528000, 112.75750000),
(1020394, 1002254, 'CN', 'Yuci', 1, 'yuci', 37.68028000, 112.73194000),
(1020400, 1002254, 'CN', 'Yuncheng', 1, 'yuncheng', 35.02306000, 110.99278000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002277, 'CN', 'Sichuan', 1, 'sichuan');

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 
(1019271, 1002277, 'CN', 'Aba Zangzu Qiangzu Zizhizhou', 1, 'aba-zangzu-qiangzu-zizhizhou', 32.41875000, 102.63664000),
(1019320, 1002277, 'CN', 'Barkam', 1, 'barkam', 31.90059000, 102.22092000),
(1019326, 1002277, 'CN', 'Bazhong Shi', 1, 'bazhong-shi', 32.04025000, 107.06230000),
(1019362, 1002277, 'CN', 'Changchi', 1, 'changchi', 32.16377000, 106.65814000),
(1019387, 1002277, 'CN', 'Chengdu', 1, 'chengdu', 30.66667000, 104.06667000),
(1019403, 1002277, 'CN', 'Chonglong', 1, 'chonglong', 29.78062000, 104.85224000),
(1019416, 1002277, 'CN', 'Dadukou', 1, 'dadukou', 26.54790000, 101.70539000),
(1019443, 1002277, 'CN', 'Dazhou', 1, 'dazhou', 31.21592000, 107.50092000),
(1019454, 1002277, 'CN', 'Deyang', 1, 'deyang', 31.13019000, 104.38198000),
(1019478, 1002277, 'CN', 'Dongxi', 1, 'dongxi', 32.06577000, 106.24843000),
(1019500, 1002277, 'CN', 'Fangting', 1, 'fangting', 31.12766000, 104.16649000),
(1019516, 1002277, 'CN', 'Fubao', 1, 'fubao', 28.76905000, 106.07667000),
(1019543, 1002277, 'CN', 'Gaoping', 1, 'gaoping', 30.77576000, 106.10294000),
(1019551, 1002277, 'CN', 'Garzê Zangzu Zizhizhou', 1, 'garze-zangzu-zizhizhou', 31.02407000, 100.40553000),
(1019564, 1002277, 'CN', 'Guang’an', 1, 'guang-an', 30.47413000, 106.63696000),
(1019561, 1002277, 'CN', 'Guangyuan', 1, 'guangyuan', 32.44201000, 105.82300000),
(1019695, 1002277, 'CN', 'Jiancheng', 1, 'jiancheng', 30.39097000, 104.54912000),
(1019704, 1002277, 'CN', 'Jiangyou', 1, 'jiangyou', 31.76667000, 104.71667000),
(1019707, 1002277, 'CN', 'Jiannan', 1, 'jiannan', 31.34355000, 104.19588000),
(1019772, 1002277, 'CN', 'Kangding', 1, 'kangding', 30.00222000, 101.95690000),
(1019798, 1002277, 'CN', 'Langzhong', 1, 'langzhong', 31.55037000, 105.99381000),
(1019811, 1002277, 'CN', 'Leshan', 1, 'leshan', 29.56227000, 103.76386000),
(1019816, 1002277, 'CN', 'Liangshan Yizu Zizhizhou', 1, 'liangshan-yizu-zizhizhou', 27.87644000, 102.10180000),
(1019849, 1002277, 'CN', 'Linqiong', 1, 'linqiong', 30.41587000, 103.46089000),
(1019882, 1002277, 'CN', 'Luocheng', 1, 'luocheng', 30.98021000, 104.28081000),
(1019894, 1002277, 'CN', 'Luzhou', 1, 'luzhou', 28.89030000, 105.42575000),
(1019912, 1002277, 'CN', 'Meishan Shi', 1, 'meishan-shi', 30.03000000, 104.04000000),
(1019917, 1002277, 'CN', 'Mianyang', 1, 'mianyang', 31.46784000, 104.68168000),
(1019936, 1002277, 'CN', 'Nanchong', 1, 'nanchong', 30.79508000, 106.08473000),
(1019942, 1002277, 'CN', 'Nanlong', 1, 'nanlong', 31.35333000, 106.06309000),
(1019954, 1002277, 'CN', 'Neijiang', 1, 'neijiang', 29.58354000, 105.06216000),
(1019975, 1002277, 'CN', 'Panzhihua', 1, 'panzhihua', 26.58509000, 101.71276000),
(1019992, 1002277, 'CN', 'Puji', 1, 'puji', 32.23908000, 106.45478000),
(1020115, 1002277, 'CN', 'Shuanghejiedao', 1, 'shuanghejiedao', 30.37448000, 106.77266000),
(1020143, 1002277, 'CN', 'Suining', 1, 'suining', 30.50802000, 105.57332000),
(1020155, 1002277, 'CN', 'Taihe', 1, 'taihe', 30.87123000, 105.38454000),
(1020159, 1002277, 'CN', 'Taiping', 1, 'taiping', 28.14083000, 106.03771000),
(1020180, 1002277, 'CN', 'Tianpeng', 1, 'tianpeng', 30.98664000, 103.93933000),
(1020187, 1002277, 'CN', 'Tongchuan', 1, 'tongchuan', 31.09407000, 105.08731000),
(1020251, 1002277, 'CN', 'Xialiang', 1, 'xialiang', 32.07673000, 106.77151000),
(1020265, 1002277, 'CN', 'Xiantan', 1, 'xiantan', 28.81859000, 106.19270000),
(1020280, 1002277, 'CN', 'Xichang', 1, 'xichang', 27.89642000, 102.26341000),
(1020335, 1002277, 'CN', 'Xunchang', 1, 'xunchang', 28.45433000, 104.71498000),
(1020351, 1002277, 'CN', 'Yanjiang', 1, 'yanjiang', 30.12108000, 104.64811000),
(1020365, 1002277, 'CN', 'Yibin', 1, 'yibin', 28.76667000, 104.62383000),
(1020392, 1002277, 'CN', 'Yucheng', 1, 'yucheng', 29.98521000, 102.99900000),
(1020416, 1002277, 'CN', 'Zengjia', 1, 'zengjia', 32.61957000, 106.10118000),
(1020447, 1002277, 'CN', 'Zhongba', 1, 'zhongba', 31.77819000, 104.73932000),
(1020479, 1002277, 'CN', 'Zigong', 1, 'zigong', 29.34162000, 104.77689000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002255, 'CN', 'Taiwan Province, People\'s Republic of China', 1, 'taiwan-province-people-s-republic-of-china');

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 
(1019319, 1002255, 'CN', 'Baoying', 1, 'baoying', 33.22917000, 119.30917000),
(1019376, 1002255, 'CN', 'Changshu City', 1, 'changshu-city', 31.64615000, 120.74221000),
(1019379, 1002255, 'CN', 'Changzhou', 1, 'changzhou', 31.77359000, 119.95401000),
(1019394, 1002255, 'CN', 'Chengxiang', 1, 'chengxiang', 31.44778000, 121.09389000),
(1019442, 1002255, 'CN', 'Dazhong', 1, 'dazhong', 33.19973000, 120.45780000),
(1019470, 1002255, 'CN', 'Dongkan', 1, 'dongkan', 33.99972000, 119.83083000),
(1019477, 1002255, 'CN', 'Dongtai', 1, 'dongtai', 32.85231000, 120.30947000),
(1019510, 1002255, 'CN', 'Fengxian', 1, 'fengxian', 34.70388000, 116.58717000),
(1019540, 1002255, 'CN', 'Gaogou', 1, 'gaogou', 34.01750000, 119.18861000),
(1019548, 1002255, 'CN', 'Gaoyou', 1, 'gaoyou', 32.78933000, 119.44182000),
(1019573, 1002255, 'CN', 'Guiren', 1, 'guiren', 33.66972000, 118.18889000),
(1019592, 1002255, 'CN', 'Haizhou', 1, 'haizhou', 34.58167000, 119.12889000),
(1019606, 1002255, 'CN', 'Hede', 1, 'hede', 33.77220000, 120.26176000),
(1019635, 1002255, 'CN', 'Huai\'an', 1, 'huai-an', 33.58861000, 119.01917000),
(1019644, 1002255, 'CN', 'Huai’an Shi', 1, 'huai-an-shi', 33.31162000, 119.04559000),
(1019673, 1002255, 'CN', 'Huilong', 1, 'huilong', 31.81111000, 121.65500000),
(1019688, 1002255, 'CN', 'Hutang', 1, 'hutang', 31.53429000, 119.49000000),
(1019702, 1002255, 'CN', 'Jiangyan', 1, 'jiangyan', 32.50611000, 120.14278000),
(1019703, 1002255, 'CN', 'Jiangyin', 1, 'jiangyin', 31.91102000, 120.26302000),
(1019734, 1002255, 'CN', 'Jingjiang', 1, 'jingjiang', 32.01417000, 120.26250000),
(1019747, 1002255, 'CN', 'Jinsha', 1, 'jinsha', 32.08982000, 121.07355000),
(1019764, 1002255, 'CN', 'Juegang', 1, 'juegang', 32.31737000, 121.18552000),
(1019784, 1002255, 'CN', 'Kunshan', 1, 'kunshan', 31.37762000, 120.95431000),
(1019825, 1002255, 'CN', 'Lianyungang Shi', 1, 'lianyungang-shi', 34.54844000, 119.11228000),
(1019832, 1002255, 'CN', 'Licheng', 1, 'licheng', 31.42813000, 119.48353000),
(1019930, 1002255, 'CN', 'Mudu', 1, 'mudu', 31.25597000, 120.51857000),
(1019941, 1002255, 'CN', 'Nanjing', 1, 'nanjing', 32.06167000, 118.77778000),
(1019949, 1002255, 'CN', 'Nantong', 1, 'nantong', 32.03028000, 120.87472000),
(1019987, 1002255, 'CN', 'Pizhou', 1, 'pizhou', 34.31139000, 117.95028000),
(1020030, 1002255, 'CN', 'Qinnan', 1, 'qinnan', 33.25306000, 119.91333000),
(1020044, 1002255, 'CN', 'Rucheng', 1, 'rucheng', 32.38833000, 120.55528000),
(1020054, 1002255, 'CN', 'Sanmao', 1, 'sanmao', 32.23931000, 119.81536000),
(1020136, 1002255, 'CN', 'Songling', 1, 'songling', 31.19330000, 120.71758000),
(1020139, 1002255, 'CN', 'Suicheng', 1, 'suicheng', 33.89630000, 117.93307000),
(1020150, 1002255, 'CN', 'Suzhou', 1, 'suzhou', 31.30408000, 120.59538000),
(1020161, 1002255, 'CN', 'Taixing', 1, 'taixing', 32.16667000, 120.01361000),
(1020163, 1002255, 'CN', 'Taizhou', 1, 'taizhou', 32.49069000, 119.90812000),
(1020195, 1002255, 'CN', 'Tongshan', 1, 'tongshan', 34.18045000, 117.15707000),
(1020239, 1002255, 'CN', 'Wuxi', 1, 'wuxi', 31.56887000, 120.28857000),
(1020263, 1002255, 'CN', 'Xiannü', 1, 'xiannu', 32.42806000, 119.56048000),
(1020271, 1002255, 'CN', 'Xiaolingwei', 1, 'xiaolingwei', 32.03244000, 118.85400000),
(1020294, 1002255, 'CN', 'Xinghua', 1, 'xinghua', 32.93917000, 119.83417000),
(1020303, 1002255, 'CN', 'Xinpu', 1, 'xinpu', 34.59972000, 119.15944000),
(1020340, 1002255, 'CN', 'Yancheng', 1, 'yancheng', 33.35750000, 120.15730000),
(1020349, 1002255, 'CN', 'Yangzhou', 1, 'yangzhou', 32.39722000, 119.43583000),
(1020368, 1002255, 'CN', 'Yicheng', 1, 'yicheng', 31.36059000, 119.82016000),
(1020405, 1002255, 'CN', 'Yushan', 1, 'yushan', 31.67748000, 120.80134000),
(1020420, 1002255, 'CN', 'Zhangjiagang', 1, 'zhangjiagang', 31.86500000, 120.53889000),
(1020441, 1002255, 'CN', 'Zhenjiang', 1, 'zhenjiang', 32.21086000, 119.45508000),
(1020443, 1002255, 'CN', 'Zhenzhou', 1, 'zhenzhou', 32.28034000, 119.16999000),
(1020456, 1002255, 'CN', 'Zhongxing', 1, 'zhongxing', 33.70389000, 118.67917000),
(1020462, 1002255, 'CN', 'Zhouzhuang', 1, 'zhouzhuang', 31.11788000, 120.84427000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002264, 'CN', 'Tibet Autonomous Region', 1, 'tibet-autonomous-region');

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 
(1019354, 1002264, 'CN', 'Burang', 1, 'burang', 30.29559000, 81.17511000),
(1019488, 1002264, 'CN', 'Dêqên', 1, 'deqen', 29.96178000, 90.71875000),
(1019705, 1002264, 'CN', 'Jiangzi', 1, 'jiangzi', 28.92026000, 89.59956000),
(1019812, 1002264, 'CN', 'Lhasa', 1, 'lhasa', 29.65000000, 91.10000000),
(1019933, 1002264, 'CN', 'Nagqu', 1, 'nagqu', 31.47678000, 92.05729000),
(1019934, 1002264, 'CN', 'Nagqu Diqu', 1, 'nagqu-diqu', 32.66357000, 88.93146000),
(1019957, 1002264, 'CN', 'Ngari Diqu', 1, 'ngari-diqu', 33.21836000, 82.57507000),
(1019966, 1002264, 'CN', 'Nyingchi Prefecture', 1, 'nyingchi-prefecture', 29.60092000, 94.42406000),
(1020003, 1002264, 'CN', 'Qamdo', 1, 'qamdo', 31.13040000, 97.17982000),
(1020004, 1002264, 'CN', 'Qamdo Shi', 1, 'qamdo-shi', 31.58370000, 97.22304000),
(1020041, 1002264, 'CN', 'Rikaze', 1, 'rikaze', 29.25000000, 88.88333000),
(1020049, 1002264, 'CN', 'Saga', 1, 'saga', 29.32367000, 85.22601000),
(1020074, 1002264, 'CN', 'Shannan Diqu', 1, 'shannan-diqu', 28.55630000, 92.55684000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002263, 'CN', 'Xinjiang', 1, 'xinjiang');

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 
(1019273, 1002263, 'CN', 'Ailan Mubage', 1, 'ailan-mubage', 43.90845000, 81.33299000),
(1019274, 1002263, 'CN', 'Aksu', 1, 'aksu', 41.18418000, 80.27921000),
(1019275, 1002263, 'CN', 'Aksu Diqu', 1, 'aksu-diqu', 40.55689000, 81.84629000),
(1019276, 1002263, 'CN', 'Altay', 1, 'altay', 47.84864000, 88.13361000),
(1019277, 1002263, 'CN', 'Altay Diqu', 1, 'altay-diqu', 47.86667000, 88.11667000),
(1019293, 1002263, 'CN', 'Aral', 1, 'aral', 40.54184000, 81.26566000),
(1019294, 1002263, 'CN', 'Aykol', 1, 'aykol', 40.95759000, 80.13574000),
(1019300, 1002263, 'CN', 'Baijiantan', 1, 'baijiantan', 45.69298000, 85.13942000),
(1019311, 1002263, 'CN', 'Baluntaicun', 1, 'baluntaicun', 42.66842000, 86.32424000),
(1019325, 1002263, 'CN', 'Bayingolin Mongol Zizhizhou', 1, 'bayingolin-mongol-zizhizhou', 41.73333000, 86.15000000),
(1019365, 1002263, 'CN', 'Changji', 1, 'changji', 44.00782000, 87.30461000),
(1019366, 1002263, 'CN', 'Changji Huizu Zizhizhou', 1, 'changji-huizu-zizhizhou', 44.01667000, 87.31667000),
(1019519, 1002263, 'CN', 'Fukang', 1, 'fukang', 44.15874000, 87.97418000),
(1019593, 1002263, 'CN', 'Hami', 1, 'hami', 42.83393000, 93.50601000),
(1019631, 1002263, 'CN', 'Hotan', 1, 'hotan', 37.10750000, 79.93548000),
(1019633, 1002263, 'CN', 'Hoxtolgay', 1, 'hoxtolgay', 46.51872000, 86.00214000),
(1019683, 1002263, 'CN', 'Huocheng', 1, 'huocheng', 44.05305000, 80.87173000),
(1019690, 1002263, 'CN', 'Ili Kazak Zizhizhou', 1, 'ili-kazak-zizhizhou', 43.31211000, 82.27102000),
(1019773, 1002263, 'CN', 'Karamay', 1, 'karamay', 45.58473000, 84.88724000),
(1019774, 1002263, 'CN', 'Karamay Shi', 1, 'karamay-shi', 45.49989000, 84.91683000),
(1019775, 1002263, 'CN', 'Kashgar', 1, 'kashgar', 39.47066000, 75.98951000),
(1019776, 1002263, 'CN', 'Kaxgar Diqu', 1, 'kaxgar-diqu', 39.47543000, 75.98968000),
(1019779, 1002263, 'CN', 'Korla', 1, 'korla', 41.76055000, 86.15231000),
(1019786, 1002263, 'CN', 'Kuqa', 1, 'kuqa', 41.71707000, 82.93064000),
(1019788, 1002263, 'CN', 'Kuytun', 1, 'kuytun', 44.42707000, 84.90069000),
(1020005, 1002263, 'CN', 'Qapqal', 1, 'qapqal', 43.80194000, 81.08722000),
(1020059, 1002263, 'CN', 'Shache', 1, 'shache', 38.41667000, 77.24056000),
(1020093, 1002263, 'CN', 'Shihezi', 1, 'shihezi', 44.30230000, 86.03694000),
(1020130, 1002263, 'CN', 'Sishilichengzi', 1, 'sishilichengzi', 41.96194000, 86.47667000),
(1020152, 1002263, 'CN', 'Tacheng', 1, 'tacheng', 46.74535000, 82.95847000),
(1020153, 1002263, 'CN', 'Tacheng Diqu', 1, 'tacheng-diqu', 46.75000000, 82.95000000),
(1020200, 1002263, 'CN', 'Turpan', 1, 'turpan', 42.94769000, 89.17886000),
(1020201, 1002263, 'CN', 'Turpan Diqu', 1, 'turpan-diqu', 42.93333000, 89.16667000),
(1020484, 1002263, 'CN', 'Ürümqi', 1, 'urumqi', 43.80096000, 87.60046000),
(1020204, 1002263, 'CN', 'Urumqi Shi', 1, 'urumqi-shi', 43.80000000, 87.58333000),
(1020314, 1002263, 'CN', 'Xinyuan', 1, 'xinyuan', 43.42649000, 83.24959000),
(1020413, 1002263, 'CN', 'Zangguy', 1, 'zangguy', 37.28333000, 78.76667000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002260, 'CN', 'Yunnan', 1, 'yunnan');

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 
(1019409, 1002260, 'CN', 'Chuxiong Yizu Zizhizhou', 1, 'chuxiong-yizu-zizhizhou', 25.43204000, 101.70479000),
(1019419, 1002260, 'CN', 'Dali', 1, 'dali', 25.58474000, 100.21229000),
(1019420, 1002260, 'CN', 'Dali Baizu Zizhizhou', 1, 'dali-baizu-zizhizhou', 25.68548000, 100.13104000),
(1019446, 1002260, 'CN', 'Dehong Daizu Jingpozu Zizhizhou', 1, 'dehong-daizu-jingpozu-zizhizhou', 24.66347000, 98.03964000),
(1019489, 1002260, 'CN', 'Dêqên Tibetan Autonomous Prefecture', 1, 'deqen-tibetan-autonomous-prefecture', 27.91694000, 99.54841000),
(1019552, 1002260, 'CN', 'Gejiu', 1, 'gejiu', 23.36085000, 103.15372000),
(1019585, 1002260, 'CN', 'Haikou', 1, 'haikou', 24.77985000, 102.57548000),
(1019625, 1002260, 'CN', 'Honghe Hanizu Yizu Zizhizhou', 1, 'honghe-hanizu-yizu-zizhizhou', 23.51675000, 102.97389000),
(1019733, 1002260, 'CN', 'Jinghong', 1, 'jinghong', 21.99102000, 100.73409000),
(1019767, 1002260, 'CN', 'Kaihua', 1, 'kaihua', 23.36950000, 104.27721000),
(1019770, 1002260, 'CN', 'Kaiyuan', 1, 'kaiyuan', 23.69767000, 103.30372000),
(1019783, 1002260, 'CN', 'Kunming', 1, 'kunming', 25.03889000, 102.71833000),
(1019822, 1002260, 'CN', 'Lianran', 1, 'lianran', 24.92271000, 102.48496000),
(1019835, 1002260, 'CN', 'Lijiang', 1, 'lijiang', 26.86879000, 100.22072000),
(1019836, 1002260, 'CN', 'Lincang Shi', 1, 'lincang-shi', 23.94803000, 99.55124000),
(1019872, 1002260, 'CN', 'Longquan', 1, 'longquan', 24.67193000, 102.16130000),
(1019899, 1002260, 'CN', 'Mabai', 1, 'mabai', 23.01279000, 104.45081000),
(1019901, 1002260, 'CN', 'Majie', 1, 'majie', 25.03190000, 102.63800000),
(1019926, 1002260, 'CN', 'Miyang', 1, 'miyang', 24.40417000, 103.44278000),
(1019965, 1002260, 'CN', 'Nujiang Lisuzu Zizhizhou', 1, 'nujiang-lisuzu-zizhizhou', 26.61738000, 99.14062000),
(1020038, 1002260, 'CN', 'Qujing', 1, 'qujing', 25.48333000, 103.78333000),
(1020068, 1002260, 'CN', 'Shangri-La', 1, 'shangri-la', 27.82511000, 99.70779000),
(1020100, 1002260, 'CN', 'Shilin', 1, 'shilin', 24.81878000, 103.33237000),
(1020218, 1002260, 'CN', 'Wenlan', 1, 'wenlan', 23.36002000, 103.43684000),
(1020221, 1002260, 'CN', 'Wenshan City', 1, 'wenshan-city', 23.36306000, 104.25047000),
(1020222, 1002260, 'CN', 'Wenshan Zhuangzu Miaozu Zizhizhou', 1, 'wenshan-zhuangzu-miaozu-zizhizhou', 23.65130000, 104.70830000),
(1020409, 1002260, 'CN', 'Yuxi', 1, 'yuxi', 24.35500000, 102.54222000),
(1020434, 1002260, 'CN', 'Zhaotong', 1, 'zhaotong', 27.31667000, 103.71667000),
(1020453, 1002260, 'CN', 'Zhongshu', 1, 'zhongshu', 24.51667000, 103.76667000);

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(1002247, 'CN', 'Zhejiang', 1, 'zhejiang');

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 
(1019453, 1002247, 'CN', 'Deqing', 1, 'deqing', 30.54485000, 119.95990000),
(1019481, 1002247, 'CN', 'Dongyang', 1, 'dongyang', 29.26778000, 120.22528000),
(1019505, 1002247, 'CN', 'Fenghua', 1, 'fenghua', 29.65628000, 121.40640000),
(1019526, 1002247, 'CN', 'Fuyang', 1, 'fuyang', 30.05333000, 119.95194000),
(1019576, 1002247, 'CN', 'Guli', 1, 'guli', 28.88162000, 120.03308000),
(1019591, 1002247, 'CN', 'Haining', 1, 'haining', 30.53629000, 120.68638000),
(1019598, 1002247, 'CN', 'Hangzhou', 1, 'hangzhou', 30.29365000, 120.16142000),
(1019662, 1002247, 'CN', 'Huangyan', 1, 'huangyan', 28.65010000, 121.26591000),
(1019689, 1002247, 'CN', 'Huzhou', 1, 'huzhou', 30.87030000, 120.09330000),
(1019710, 1002247, 'CN', 'Jiaojiang', 1, 'jiaojiang', 28.69844000, 121.47331000),
(1019713, 1002247, 'CN', 'Jiashan', 1, 'jiashan', 30.84918000, 120.92583000),
(1019714, 1002247, 'CN', 'Jiaxing', 1, 'jiaxing', 30.75220000, 120.75000000),
(1019715, 1002247, 'CN', 'Jiaxing Shi', 1, 'jiaxing-shi', 30.77070000, 120.75238000),
(1019740, 1002247, 'CN', 'Jinhua', 1, 'jinhua', 29.10678000, 119.64421000),
(1019750, 1002247, 'CN', 'Jinxiang', 1, 'jinxiang', 27.43265000, 120.60625000),
(1019785, 1002247, 'CN', 'Kunyang', 1, 'kunyang', 27.66583000, 120.56583000),
(1019801, 1002247, 'CN', 'Lanxi', 1, 'lanxi', 29.21588000, 119.47156000),
(1019814, 1002247, 'CN', 'Lianghu', 1, 'lianghu', 29.99152000, 120.89845000),
(1019844, 1002247, 'CN', 'Linhai', 1, 'linhai', 28.85535000, 121.14470000),
(1019848, 1002247, 'CN', 'Linping', 1, 'linping', 30.42250000, 120.29722000),
(1019858, 1002247, 'CN', 'Lishui', 1, 'lishui', 28.46042000, 119.91029000),
(1019891, 1002247, 'CN', 'Luqiao', 1, 'luqiao', 28.58023000, 121.37491000),
(1019959, 1002247, 'CN', 'Ningbo', 1, 'ningbo', 29.87819000, 121.54945000),
(1019961, 1002247, 'CN', 'Ninghai', 1, 'ninghai', 29.28917000, 121.42472000),
(1019999, 1002247, 'CN', 'Puyang', 1, 'puyang', 29.45679000, 119.88872000),
(1020039, 1002247, 'CN', 'Quzhou', 1, 'quzhou', 28.95944000, 118.86861000),
(1020069, 1002247, 'CN', 'Shangyu', 1, 'shangyu', 30.01556000, 120.87111000),
(1020082, 1002247, 'CN', 'Shaoxing', 1, 'shaoxing', 30.00237000, 120.57864000),
(1020088, 1002247, 'CN', 'Shenjiamen', 1, 'shenjiamen', 29.95763000, 122.29802000),
(1020164, 1002247, 'CN', 'Taizhou', 1, 'taizhou', 28.66266000, 121.43312000),
(1020219, 1002247, 'CN', 'Wenling', 1, 'wenling', 28.37524000, 121.38416000),
(1020226, 1002247, 'CN', 'Wenzhou', 1, 'wenzhou', 27.99942000, 120.66682000),
(1020245, 1002247, 'CN', 'Wuzhen', 1, 'wuzhen', 30.74536000, 120.48510000),
(1020260, 1002247, 'CN', 'Xianju', 1, 'xianju', 28.85470000, 120.73168000),
(1020274, 1002247, 'CN', 'Xiaoshan', 1, 'xiaoshan', 30.16746000, 120.25883000),
(1020383, 1002247, 'CN', 'Yiwu', 1, 'yiwu', 29.31506000, 120.07676000),
(1020411, 1002247, 'CN', 'Yuyao', 1, 'yuyao', 30.05000000, 121.14944000),
(1020430, 1002247, 'CN', 'Zhaobaoshan', 1, 'zhaobaoshan', 29.96950000, 121.68753000),
(1020444, 1002247, 'CN', 'Zhicheng', 1, 'zhicheng', 31.00751000, 119.90851000),
(1020461, 1002247, 'CN', 'Zhoushan', 1, 'zhoushan', 29.98869000, 122.20488000),
(1020467, 1002247, 'CN', 'Zhuji', 1, 'zhuji', 29.71877000, 120.24233000);

