SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0;
-- Table structure for zh_city
DROP TABLE IF EXISTS zh_city;
CREATE TABLE zh_city (
id int(11) NOT NULL AUTO_INCREMENT,
adcode varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'adcode',
city_name varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '市名',
lat double NULL DEFAULT NULL COMMENT '中心纬度',
lng double NULL DEFAULT NULL COMMENT '中心经度',
parent_adcode varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '所属省',
citycode varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '区号',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 875 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '市' ROW_FORMAT = Dynamic;
-- Records of zh_city
INSERT INTO zh_city VALUES (480, '110100', '北京市市辖区', 39.904989, 116.405285, '110000', '010');
INSERT INTO zh_city VALUES (481, '120100', '天津市市辖区', 39.125596, 117.190182, '120000', '022');
INSERT INTO zh_city VALUES (482, '120200', '天津市郊县', 39.330613, 117.824898, '120000', '022');
INSERT INTO zh_city VALUES (483, '130100', '石家庄市', 38.045474, 114.502461, '130000', '0311');
INSERT INTO zh_city VALUES (484, '130200', '唐山市', 39.635113, 118.175393, '130000', '0315');
INSERT INTO zh_city VALUES (485, '130300', '秦皇岛市', 39.942531, 119.586579, '130000', '0335');
INSERT INTO zh_city VALUES (486, '130400', '邯郸市', 36.612273, 114.490686, '130000', '0310');
INSERT INTO zh_city VALUES (487, '130500', '邢台市', 37.0682, 114.508851, '130000', '0319');
INSERT INTO zh_city VALUES (488, '130600', '保定市', 38.867657, 115.482331, '130000', '0312');
INSERT INTO zh_city VALUES (489, '130700', '张家口市', 40.811901, 114.884091, '130000', '0313');
INSERT INTO zh_city VALUES (490, '130800', '承德市', 40.976204, 117.939152, '130000', '0314');
INSERT INTO zh_city VALUES (491, '130900', '沧州市', 38.310582, 116.857461, '130000', '0317');
INSERT INTO zh_city VALUES (492, '131000', '廊坊市', 39.523927, 116.704441, '130000', '0316');
INSERT INTO zh_city VALUES (493, '131100', '衡水市', 37.735097, 115.665993, '130000', '0318');
INSERT INTO zh_city VALUES (494, '140100', '太原市', 37.857014, 112.549248, '140000', '0351');
INSERT INTO zh_city VALUES (495, '140200', '大同市', 40.09031, 113.295259, '140000', '0352');
INSERT INTO zh_city VALUES (496, '140300', '阳泉市', 37.861188, 113.583285, '140000', '0353');
INSERT INTO zh_city VALUES (497, '140400', '长治市', 36.191112, 113.113556, '140000', '0355');
INSERT INTO zh_city VALUES (498, '140500', '晋城市', 35.497553, 112.851274, '140000', '0356');
INSERT INTO zh_city VALUES (499, '140600', '朔州市', 39.331261, 112.433387, '140000', '0349');
INSERT INTO zh_city VALUES (500, '140700', '晋中市', 37.696495, 112.736465, '140000', '0354');
INSERT INTO zh_city VALUES (501, '140800', '运城市', 35.022778, 111.003957, '140000', '0359');
INSERT INTO zh_city VALUES (502, '140900', '忻州市', 38.41769, 112.733538, '140000', '0350');
INSERT INTO zh_city VALUES (503, '141000', '临汾市', 36.08415, 111.517973, '140000', '0357');
INSERT INTO zh_city VALUES (504, '141100', '吕梁市', 37.524366, 111.134335, '140000', '0358');
INSERT INTO zh_city VALUES (505, '150100', '呼和浩特市', 40.818311, 111.670801, '150000', '0471');
INSERT INTO zh_city VALUES (506, '150200', '包头市', 40.658168, 109.840405, '150000', '0472');
INSERT INTO zh_city VALUES (507, '150300', '乌海市', 39.673734, 106.825563, '150000', '0473');
INSERT INTO zh_city VALUES (508, '150400', '赤峰市', 42.275317, 118.956806, '150000', '0476');
INSERT INTO zh_city VALUES (509, '150500', '通辽市', 43.617429, 122.263119, '150000', '0475');
INSERT INTO zh_city VALUES (510, '150600', '鄂尔多斯市', 39.817179, 109.99029, '150000', '0477');
INSERT INTO zh_city VALUES (511, '150700', '呼伦贝尔市', 49.215333, 119.758168, '150000', '0470');
INSERT INTO zh_city VALUES (512, '150800', '巴彦淖尔市', 40.757402, 107.416959, '150000', '0478');
INSERT INTO zh_city VALUES (513, '150900', '乌兰察布市', 41.034126, 113.114543, '150000', '0474');
INSERT INTO zh_city VALUES (514, '152200', '兴安盟', 46.076268, 122.070317, '150000', '0482');
INSERT INTO zh_city VALUES (515, '152500', '锡林郭勒盟', 43.944018, 116.090996, '150000', '0479');
INSERT INTO zh_city VALUES (516, '152900', '阿拉善盟', 38.844814, 105.706422, '150000', '0483');
INSERT INTO zh_city VALUES (517, '210100', '沈阳市', 41.796767, 123.429096, '210000', '024');
INSERT INTO zh_city VALUES (518, '210200', '大连市', 38.91459, 121.618622, '210000', '0411');
INSERT INTO zh_city VALUES (519, '210300', '鞍山市', 41.110626, 122.995632, '210000', '0412');
INSERT INTO zh_city VALUES (520, '210400', '抚顺市', 41.875956, 123.921109, '210000', '0413');
INSERT INTO zh_city VALUES (521, '210500', '本溪市', 41.297909, 123.770519, '210000', '0414');
INSERT INTO zh_city VALUES (522, '210600', '丹东市', 40.124296, 124.383044, '210000', '0415');
INSERT INTO zh_city VALUES (523, '210700', '锦州市', 41.119269, 121.135742, '210000', '0416');
INSERT INTO zh_city VALUES (524, '210800', '营口市', 40.667432, 122.235151, '210000', '0417');
INSERT INTO zh_city VALUES (525, '210900', '阜新市', 42.011796, 121.648962, '210000', '0418');
INSERT INTO zh_city VALUES (526, '211000', '辽阳市', 41.269402, 123.18152, '210000', '0419');
INSERT INTO zh_city VALUES (527, '211100', '盘锦市', 41.124484, 122.06957, '210000', '0427');
INSERT INTO zh_city VALUES (528, '211200', '铁岭市', 42.290585, 123.844279, '210000', '0410');
INSERT INTO zh_city VALUES (529, '211300', '朝阳市', 41.576758, 120.451176, '210000', '0421');
INSERT INTO zh_city VALUES (530, '211400', '葫芦岛市', 40.755572, 120.856394, '210000', '0429');
INSERT INTO zh_city VALUES (531, '220100', '长春市', 43.886841, 125.3245, '220000', '0431');
INSERT INTO zh_city VALUES (532, '220200', '吉林市', 43.843577, 126.55302, '220000', '0432');
INSERT INTO zh_city VALUES (533, '220300', '四平市', 43.170344, 124.370785, '220000', '0434');
INSERT INTO zh_city VALUES (534, '220400', '辽源市', 42.902692, 125.145349, '220000', '0437');
INSERT INTO zh_city VALUES (535, '220500', '通化市', 41.721177, 125.936501, '220000', '0435');
INSERT INTO zh_city VALUES (536, '220600', '白山市', 41.942505, 126.427839, '220000', '0439');
INSERT INTO zh_city VALUES (537, '220700', '松原市', 45.118243, 124.823608, '220000', '0438');
INSERT INTO zh_city VALUES (538, '220800', '白城市', 45.619026, 122.841114, '220000', '0436');
INSERT INTO zh_city VALUES (539, '222400', '延边朝鲜族自治州', 42.904823, 129.513228, '220000', '1433');
INSERT INTO zh_city VALUES (540, '230100', '哈尔滨市', 45.756967, 126.642464, '230000', '0451');
INSERT INTO zh_city VALUES (541, '230200', '齐齐哈尔市', 47.342081, 123.95792, '230000', '0452');
INSERT INTO zh_city VALUES (542, '230300', '鸡西市', 45.300046, 130.975966, '230000', '0467');
INSERT INTO zh_city VALUES (543, '230400', '鹤岗市', 47.332085, 130.277487, '230000', '0468');
INSERT INTO zh_city VALUES (544, '230500', '双鸭山市', 46.643442, 131.157304, '230000', '0469');
INSERT INTO zh_city VALUES (545, '230600', '大庆市', 46.590734, 125.11272, '230000', '0459');
INSERT INTO zh_city VALUES (546, '230700', '伊春市', 47.724775, 128.899396, '230000', '0458');
INSERT INTO zh_city VALUES (547, '230800', '佳木斯市', 46.809606, 130.361634, '230000', '0454');
INSERT INTO zh_city VALUES (548, '230900', '七台河市', 45.771266, 131.015584, '230000', '0464');
INSERT INTO zh_city VALUES (549, '231000', '牡丹江市', 44.582962, 129.618602, '230000', '0453');
INSERT INTO zh_city VALUES (550, '231100', '黑河市', 50.249585, 127.499023, '230000', '0456');
INSERT INTO zh_city VALUES (551, '231200', '绥化市', 46.637393, 126.99293, '230000', '0455');
INSERT INTO zh_city VALUES (552, '232700', '大兴安岭地区', 52.335262, 124.711526, '230000', '0457');
INSERT INTO zh_city VALUES (553, '310100', '上海市市辖区', 31.231706, 121.472644, '310000', '021');
INSERT INTO zh_city VALUES (554, '310200', '上海市郊县', 31.623587, 121.397417, '310000', '021');
INSERT INTO zh_city VALUES (555, '320100', '南京市', 32.041544, 118.767413, '320000', '025');
INSERT INTO zh_city VALUES (556, '320200', '无锡市', 31.574729, 120.301663, '320000', '0510');
INSERT INTO zh_city VALUES (557, '320300', '徐州市', 34.261792, 117.184811, '320000', '0516');
INSERT INTO zh_city VALUES (558, '320400', '常州市', 31.772752, 119.946973, '320000', '0519');
INSERT INTO zh_city VALUES (559, '320500', '苏州市', 31.299379, 120.619585, '320000', '0512');
INSERT INTO zh_city VALUES (560, '320600', '南通市', 32.016212, 120.864608, '320000', '0513');
INSERT INTO zh_city VALUES (561, '320700', '连云港市', 34.600018, 119.178821, '320000', '0518');
INSERT INTO zh_city VALUES (562, '320800', '淮安市', 33.597506, 119.021265, '320000', '0517');
INSERT INTO zh_city VALUES (563, '320900', '盐城市', 33.377631, 120.139998, '320000', '0515');
INSERT INTO zh_city VALUES (564, '321000', '扬州市', 32.393159, 119.421003, '320000', '0514');
INSERT INTO zh_city VALUES (565, '321100', '镇江市', 32.204402, 119.452753, '320000', '0511');
INSERT INTO zh_city VALUES (566, '321200', '泰州市', 32.484882, 119.915176, '320000', '0523');
INSERT INTO zh_city VALUES (567, '321300', '宿迁市', 33.963008, 118.275162, '320000', '0527');
INSERT INTO zh_city VALUES (568, '330100', '杭州市', 30.287459, 120.153576, '330000', '0571');
INSERT INTO zh_city VALUES (569, '330200', '宁波市', 29.868388, 121.549792, '330000', '0574');
INSERT INTO zh_city VALUES (570, '330300', '温州市', 28.000575, 120.672111, '330000', '0577');
INSERT INTO zh_city VALUES (571, '330400', '嘉兴市', 30.762653, 120.750865, '330000', '0573');
INSERT INTO zh_city VALUES (572, '330500', '湖州市', 30.867198, 120.102398, '330000', '0572');
INSERT INTO zh_city VALUES (573, '330600', '绍兴市', 29.997117, 120.582112, '330000', '0575');
INSERT INTO zh_city VALUES (574, '330700', '金华市', 29.089524, 119.649506, '330000', '0579');
INSERT INTO zh_city VALUES (575, '330800', '衢州市', 28.941708, 118.87263, '330000', '0570');
INSERT INTO zh_city VALUES (576, '330900', '舟山市', 30.016028, 122.106863, '330000', '0580');
INSERT INTO zh_city VALUES (577, '331000', '台州市', 28.661378, 121.428599, '330000', '0576');
INSERT INTO zh_city VALUES (578, '331100', '丽水市', 28.451993, 119.921786, '330000', '0578');
INSERT INTO zh_city VALUES (579, '340100', '合肥市', 31.86119, 117.283042, '340000', '0551');
INSERT INTO zh_city VALUES (580, '340200', '芜湖市', 31.326319, 118.376451, '340000', '0553');
INSERT INTO zh_city VALUES (581, '340300', '蚌埠市', 32.939667, 117.363228, '340000', '0552');
INSERT INTO zh_city VALUES (582, '340400', '淮南市', 32.647574, 117.018329, '340000', '0554');
INSERT INTO zh_city VALUES (583, '340500', '马鞍山市', 31.689362, 118.507906, '340000', '0555');
INSERT INTO zh_city VALUES (584, '340600', '淮北市', 33.971707, 116.794664, '340000', '0561');
INSERT INTO zh_city VALUES (585, '340700', '铜陵市', 30.929935, 117.816576, '340000', '0562');
INSERT INTO zh_city VALUES (586, '340800', '安庆市', 30.50883, 117.043551, '340000', '0556');
INSERT INTO zh_city VALUES (587, '341000', '黄山市', 29.709239, 118.317325, '340000', '0559');
INSERT INTO zh_city VALUES (588, '341100', '滁州市', 32.303627, 118.316264, '340000', '0550');
INSERT INTO zh_city VALUES (589, '341200', '阜阳市', 32.896969, 115.819729, '340000', '1558');
INSERT INTO zh_city VALUES (590, '341300', '宿州市', 33.633891, 116.984084, '340000', '0557');
INSERT INTO zh_city VALUES (591, '341500', '六安市', 31.752889, 116.507676, '340000', '0564');
INSERT INTO zh_city VALUES (592, '341600', '亳州市', 33.869338, 115.782939, '340000', '0558');
INSERT INTO zh_city VALUES (593, '341700', '池州市', 30.656037, 117.489157, '340000', '0566');
INSERT INTO zh_city VALUES (594, '341800', '宣城市', 30.945667, 118.757995, '340000', '0563');
INSERT INTO zh_city VALUES (595, '350100', '福州市', 26.075302, 119.306239, '350000', '0591');
INSERT INTO zh_city VALUES (596, '350200', '厦门市', 24.490474, 118.11022, '350000', '0592');
INSERT INTO zh_city VALUES (597, '350300', '莆田市', 25.431011, 119.007558, '350000', '0594');
INSERT INTO zh_city VALUES (598, '350400', '三明市', 26.265444, 117.635001, '350000', '0598');
INSERT INTO zh_city VALUES (599, '350500', '泉州市', 24.908853, 118.589421, '350000', '0595');
INSERT INTO zh_city VALUES (600, '350600', '漳州市', 24.510897, 117.661801, '350000', '0596');
INSERT INTO zh_city VALUES (601, '350700', '南平市', 26.635627, 118.178459, '350000', '0599');
INSERT INTO zh_city VALUES (602, '350800', '龙岩市', 25.091603, 117.02978, '350000', '0597');
INSERT INTO zh_city VALUES (603, '350900', '宁德市', 26.65924, 119.527082, '350000', '0593');
INSERT INTO zh_city VALUES (604, '360100', '南昌市', 28.676493, 115.892151, '360000', '0791');
INSERT INTO zh_city VALUES (605, '360200', '景德镇市', 29.29256, 117.214664, '360000', '0798');
INSERT INTO zh_city VALUES (606, '360300', '萍乡市', 27.622946, 113.852186, '360000', '0799');
INSERT INTO zh_city VALUES (607, '360400', '九江市', 29.712034, 115.992811, '360000', '0792');
INSERT INTO zh_city VALUES (608, '360500', '新余市', 27.810834, 114.930835, '360000', '0790');
INSERT INTO zh_city VALUES (609, '360600', '鹰潭市', 28.238638, 117.033838, '360000', '0701');
INSERT INTO zh_city VALUES (610, '360700', '赣州市', 25.85097, 114.940278, '360000', '0797');
INSERT INTO zh_city VALUES (611, '360800', '吉安市', 27.111699, 114.986373, '360000', '0796');
INSERT INTO zh_city VALUES (612, '360900', '宜春市', 27.8043, 114.391136, '360000', '0795');
INSERT INTO zh_city VALUES (613, '361000', '抚州市', 27.98385, 116.358351, '360000', '0794');
INSERT INTO zh_city VALUES (614, '361100', '上饶市', 28.44442, 117.971185, '360000', '0793');
INSERT INTO zh_city VALUES (615, '370100', '济南市', 36.675807, 117.000923, '370000', '0531');
INSERT INTO zh_city VALUES (616, '370200', '青岛市', 36.082982, 120.355173, '370000', '0532');
INSERT INTO zh_city VALUES (617, '370300', '淄博市', 36.814939, 118.047648, '370000', '0533');
INSERT INTO zh_city VALUES (618, '370400', '枣庄市', 34.856424, 117.557964, '370000', '0632');
INSERT INTO zh_city VALUES (619, '370500', '东营市', 37.434564, 118.66471, '370000', '0546');
INSERT INTO zh_city VALUES (620, '370600', '烟台市', 37.539297, 121.391382, '370000', '0535');
INSERT INTO zh_city VALUES (621, '370700', '潍坊市', 36.70925, 119.107078, '370000', '0536');
INSERT INTO zh_city VALUES (622, '370800', '济宁市', 35.415393, 116.587245, '370000', '0537');
INSERT INTO zh_city VALUES (623, '370900', '泰安市', 36.194968, 117.129063, '370000', '0538');
INSERT INTO zh_city VALUES (624, '371000', '威海市', 37.509691, 122.116394, '370000', '0631');
INSERT INTO zh_city VALUES (625, '371100', '日照市', 35.428588, 119.461208, '370000', '0633');
INSERT INTO zh_city VALUES (626, '371200', '莱芜市', 36.214397, 117.677736, '370000', '0634');
INSERT INTO zh_city VALUES (627, '371300', '临沂市', 35.065282, 118.326443, '370000', '0539');
INSERT INTO zh_city VALUES (628, '371400', '德州市', 37.453968, 116.307428, '370000', '0534');
INSERT INTO zh_city VALUES (629, '371500', '聊城市', 36.456013, 115.980367, '370000', '0635');
INSERT INTO zh_city VALUES (630, '371600', '滨州市', 37.383542, 118.016974, '370000', '0543');
INSERT INTO zh_city VALUES (631, '371700', '菏泽市', 35.246531, 115.469381, '370000', '0530');
INSERT INTO zh_city VALUES (632, '410100', '郑州市', 34.757975, 113.665412, '410000', '0371');
INSERT INTO zh_city VALUES (633, '410200', '开封市', 34.797049, 114.341447, '410000', '0378');
INSERT INTO zh_city VALUES (634, '410300', '洛阳市', 34.663041, 112.434468, '410000', '0379');
INSERT INTO zh_city VALUES (635, '410400', '平顶山市', 33.735241, 113.307718, '410000', '0375');
INSERT INTO zh_city VALUES (636, '410500', '安阳市', 36.103442, 114.352482, '410000', '0372');
INSERT INTO zh_city VALUES (637, '410600', '鹤壁市', 35.748236, 114.295444, '410000', '0392');
INSERT INTO zh_city VALUES (638, '410700', '新乡市', 35.302616, 113.883991, '410000', '0373');
INSERT INTO zh_city VALUES (639, '410800', '焦作市', 35.23904, 113.238266, '410000', '0391');
INSERT INTO zh_city VALUES (640, '410900', '濮阳市', 35.768234, 115.041299, '410000', '0393');
INSERT INTO zh_city VALUES (641, '411000', '许昌市', 34.022956, 113.826063, '410000', '0374');
INSERT INTO zh_city VALUES (642, '411100', '漯河市', 33.575855, 114.026405, '410000', '0395');
INSERT INTO zh_city VALUES (643, '411200', '三门峡市', 34.777338, 111.194099, '410000', '0398');
INSERT INTO zh_city VALUES (644, '411300', '南阳市', 32.999082, 112.540918, '410000', '0377');
INSERT INTO zh_city VALUES (645, '411400', '商丘市', 34.437054, 115.650497, '410000', '0370');
INSERT INTO zh_city VALUES (646, '411500', '信阳市', 32.123274, 114.075031, '410000', '0376');
INSERT INTO zh_city VALUES (647, '411600', '周口市', 33.620357, 114.649653, '410000', '0394');
INSERT INTO zh_city VALUES (648, '411700', '驻马店市', 32.980169, 114.024736, '410000', '0396');
INSERT INTO zh_city VALUES (649, '419001', '济源市', 35.090378, 112.590047, '410000', '1391');
INSERT INTO zh_city VALUES (650, '420100', '武汉市', 30.584355, 114.298572, '420000', '027');
INSERT INTO zh_city VALUES (651, '420200', '黄石市', 30.220074, 115.077048, '420000', '0714');
INSERT INTO zh_city VALUES (652, '420300', '十堰市', 32.646907, 110.787916, '420000', '0719');
INSERT INTO zh_city VALUES (653, '420500', '宜昌市', 30.702636, 111.290843, '420000', '0717');
INSERT INTO zh_city VALUES (654, '420600', '襄阳市', 32.042426, 112.144146, '420000', '0710');
INSERT INTO zh_city VALUES (655, '420700', '鄂州市', 30.396536, 114.890593, '420000', '0711');
INSERT INTO zh_city VALUES (656, '420800', '荆门市', 31.03542, 112.204251, '420000', '0724');
INSERT INTO zh_city VALUES (657, '420900', '孝感市', 30.926423, 113.926655, '420000', '0712');
INSERT INTO zh_city VALUES (658, '421000', '荆州市', 30.326857, 112.23813, '420000', '0716');
INSERT INTO zh_city VALUES (659, '421100', '黄冈市', 30.447711, 114.879365, '420000', '0713');
INSERT INTO zh_city VALUES (660, '421200', '咸宁市', 29.832798, 114.328963, '420000', '0715');
INSERT INTO zh_city VALUES (661, '421300', '随州市', 31.717497, 113.37377, '420000', '0722');
INSERT INTO zh_city VALUES (662, '422800', '恩施土家族苗族自治州', 30.283114, 109.48699, '420000', '0718');
INSERT INTO zh_city VALUES (663, '429004', '仙桃市', 30.364953, 113.453974, '420000', '0728');
INSERT INTO zh_city VALUES (664, '429005', '潜江市', 30.421215, 112.896866, '420000', '2728');
INSERT INTO zh_city VALUES (665, '429006', '天门市', 30.653061, 113.165862, '420000', '1728');
INSERT INTO zh_city VALUES (666, '429021', '神农架林区', 31.744449, 110.671525, '420000', '1719');
INSERT INTO zh_city VALUES (667, '430100', '长沙市', 28.19409, 112.982279, '430000', '0731');
INSERT INTO zh_city VALUES (668, '430200', '株洲市', 27.835806, 113.151737, '430000', '0733');
INSERT INTO zh_city VALUES (669, '430300', '湘潭市', 27.82973, 112.944052, '430000', '0732');
INSERT INTO zh_city VALUES (670, '430400', '衡阳市', 26.900358, 112.607693, '430000', '0734');
INSERT INTO zh_city VALUES (671, '430500', '邵阳市', 27.237842, 111.46923, '430000', '0739');
INSERT INTO zh_city VALUES (672, '430600', '岳阳市', 29.37029, 113.132855, '430000', '0730');
INSERT INTO zh_city VALUES (673, '430700', '常德市', 29.040225, 111.691347, '430000', '0736');
INSERT INTO zh_city VALUES (674, '430800', '张家界市', 29.127401, 110.479921, '430000', '0744');
INSERT INTO zh_city VALUES (675, '430900', '益阳市', 28.570066, 112.355042, '430000', '0737');
INSERT INTO zh_city VALUES (676, '431000', '郴州市', 25.793589, 113.032067, '430000', '0735');
INSERT INTO zh_city VALUES (677, '431100', '永州市', 26.434516, 111.608019, '430000', '0746');
INSERT INTO zh_city VALUES (678, '431200', '怀化市', 27.550082, 109.97824, '430000', '0745');
INSERT INTO zh_city VALUES (679, '431300', '娄底市', 27.728136, 112.008497, '430000', '0738');
INSERT INTO zh_city VALUES (680, '433100', '湘西土家族苗族自治州', 28.314296, 109.739735, '430000', '0743');
INSERT INTO zh_city VALUES (681, '440100', '广州市', 23.125178, 113.280637, '440000', '020');
INSERT INTO zh_city VALUES (682, '440200', '韶关市', 24.801322, 113.591544, '440000', '0751');
INSERT INTO zh_city VALUES (683, '440300', '深圳市', 22.547, 114.085947, '440000', '0755');
INSERT INTO zh_city VALUES (684, '440400', '珠海市', 22.224979, 113.553986, '440000', '0756');
INSERT INTO zh_city VALUES (685, '440500', '汕头市', 23.37102, 116.708463, '440000', '0754');
INSERT INTO zh_city VALUES (686, '440600', '佛山市', 23.028762, 113.122717, '440000', '0757');
INSERT INTO zh_city VALUES (687, '440700', '江门市', 22.590431, 113.094942, '440000', '0750');
INSERT INTO zh_city VALUES (688, '440800', '湛江市', 21.274898, 110.364977, '440000', '0759');
INSERT INTO zh_city VALUES (689, '440900', '茂名市', 21.659751, 110.919229, '440000', '0668');
INSERT INTO zh_city VALUES (690, '441200', '肇庆市', 23.051546, 112.472529, '440000', '0758');
INSERT INTO zh_city VALUES (691, '441300', '惠州市', 23.079404, 114.412599, '440000', '0752');
INSERT INTO zh_city VALUES (692, '441400', '梅州市', 24.299112, 116.117582, '440000', '0753');
INSERT INTO zh_city VALUES (693, '441500', '汕尾市', 22.774485, 115.364238, '440000', '0660');
INSERT INTO zh_city VALUES (694, '441600', '河源市', 23.746266, 114.697802, '440000', '0762');
INSERT INTO zh_city VALUES (695, '441700', '阳江市', 21.859222, 111.975107, '440000', '0662');
INSERT INTO zh_city VALUES (696, '441800', '清远市', 23.685022, 113.051227, '440000', '0763');
INSERT INTO zh_city VALUES (697, '441900', '东莞市', 23.046237, 113.746262, '440000', '0769');
INSERT INTO zh_city VALUES (698, '442000', '中山市', 22.521113, 113.382391, '440000', '0760');
INSERT INTO zh_city VALUES (699, '445100', '潮州市', 23.661701, 116.632301, '440000', '0768');
INSERT INTO zh_city VALUES (700, '445200', '揭阳市', 23.543778, 116.355733, '440000', '0663');
INSERT INTO zh_city VALUES (701, '445300', '云浮市', 22.929801, 112.044439, '440000', '0766');
INSERT INTO zh_city VALUES (702, '450100', '南宁市', 22.82402, 108.320004, '450000', '0771');
INSERT INTO zh_city VALUES (703, '450200', '柳州市', 24.314617, 109.411703, '450000', '0772');
INSERT INTO zh_city VALUES (704, '450300', '桂林市', 25.274215, 110.299121, '450000', '0773');
INSERT INTO zh_city VALUES (705, '450400', '梧州市', 23.474803, 111.297604, '450000', '0774');
INSERT INTO zh_city VALUES (706, '450500', '北海市', 21.473343, 109.119254, '450000', '0779');
INSERT INTO zh_city VALUES (707, '450600', '防城港市', 21.614631, 108.345478, '450000', '0770');
INSERT INTO zh_city VALUES (708, '450700', '钦州市', 21.967127, 108.624175, '450000', '0777');
INSERT INTO zh_city VALUES (709, '450800', '贵港市', 23.0936, 109.602146, '450000', '1755');
INSERT INTO zh_city VALUES (710, '450900', '玉林市', 22.63136, 110.154393, '450000', '0775');
INSERT INTO zh_city VALUES (711, '451000', '百色市', 23.897742, 106.616285, '450000', '0776');
INSERT INTO zh_city VALUES (712, '451100', '贺州市', 24.414141, 111.552056, '450000', '1774');
INSERT INTO zh_city VALUES (713, '451200', '河池市', 24.695899, 108.062105, '450000', '0778');
INSERT INTO zh_city VALUES (714, '451300', '来宾市', 23.733766, 109.229772, '450000', '1772');
INSERT INTO zh_city VALUES (715, '451400', '崇左市', 22.404108, 107.353926, '450000', '1771');
INSERT INTO zh_city VALUES (716, '460100', '海口市', 20.031971, 110.33119, '460000', '0898');
INSERT INTO zh_city VALUES (717, '460200', '三亚市', 18.247872, 109.508268, '460000', '0899');
INSERT INTO zh_city VALUES (718, '460300', '三沙市', 16.831039, 112.34882, '460000', '2898');
INSERT INTO zh_city VALUES (719, '460400', '儋州市', 19.517486, 109.576782, '460000', '0805');
INSERT INTO zh_city VALUES (720, '469001', '五指山市', 18.776921, 109.516662, '460000', '1897');
INSERT INTO zh_city VALUES (721, '469002', '琼海市', 19.246011, 110.466785, '460000', '1894');
INSERT INTO zh_city VALUES (722, '469005', '文昌市', 19.612986, 110.753975, '460000', '1893');
INSERT INTO zh_city VALUES (723, '469006', '万宁市', 18.796216, 110.388793, '460000', '1898');
INSERT INTO zh_city VALUES (724, '469007', '东方市', 19.10198, 108.653789, '460000', '0807');
INSERT INTO zh_city VALUES (725, '469021', '定安县', 19.684966, 110.349235, '460000', '0806');
INSERT INTO zh_city VALUES (726, '469022', '屯昌县', 19.362916, 110.102773, '460000', '1892');
INSERT INTO zh_city VALUES (727, '469023', '澄迈县', 19.737095, 110.007147, '460000', '0804');
INSERT INTO zh_city VALUES (728, '469024', '临高县', 19.908293, 109.687697, '460000', '1896');
INSERT INTO zh_city VALUES (729, '469025', '白沙黎族自治县', 19.224584, 109.452606, '460000', '0802');
INSERT INTO zh_city VALUES (730, '469026', '昌江黎族自治县', 19.260968, 109.053351, '460000', '0803');
INSERT INTO zh_city VALUES (731, '469027', '乐东黎族自治县', 18.74758, 109.175444, '460000', '2802');
INSERT INTO zh_city VALUES (732, '469028', '陵水黎族自治县', 18.505006, 110.037218, '460000', '0809');
INSERT INTO zh_city VALUES (733, '469029', '保亭黎族苗族自治县', 18.636371, 109.70245, '460000', '0801');
INSERT INTO zh_city VALUES (734, '469030', '琼中黎族苗族自治县', 19.03557, 109.839996, '460000', '1899');
INSERT INTO zh_city VALUES (735, '500100', '重庆市市辖区', 29.533155, 106.504962, '500000', '023');
INSERT INTO zh_city VALUES (736, '500200', '重庆市郊县', 29.291965, 108.170255, '500000', '023');
INSERT INTO zh_city VALUES (737, '510100', '成都市', 30.659462, 104.065735, '510000', '028');
INSERT INTO zh_city VALUES (738, '510300', '自贡市', 29.352765, 104.773447, '510000', '0813');
INSERT INTO zh_city VALUES (739, '510400', '攀枝花市', 26.580446, 101.716007, '510000', '0812');
INSERT INTO zh_city VALUES (740, '510500', '泸州市', 28.889138, 105.443348, '510000', '0830');
INSERT INTO zh_city VALUES (741, '510600', '德阳市', 31.127991, 104.398651, '510000', '0838');
INSERT INTO zh_city VALUES (742, '510700', '绵阳市', 31.46402, 104.741722, '510000', '0816');
INSERT INTO zh_city VALUES (743, '510800', '广元市', 32.433668, 105.829757, '510000', '0839');
INSERT INTO zh_city VALUES (744, '510900', '遂宁市', 30.513311, 105.571331, '510000', '0825');
INSERT INTO zh_city VALUES (745, '511000', '内江市', 29.58708, 105.066138, '510000', '1832');
INSERT INTO zh_city VALUES (746, '511100', '乐山市', 29.582024, 103.761263, '510000', '0833');
INSERT INTO zh_city VALUES (747, '511300', '南充市', 30.795281, 106.082974, '510000', '0817');
INSERT INTO zh_city VALUES (748, '511400', '眉山市', 30.048318, 103.831788, '510000', '1833');
INSERT INTO zh_city VALUES (749, '511500', '宜宾市', 28.760189, 104.630825, '510000', '0831');
INSERT INTO zh_city VALUES (750, '511600', '广安市', 30.456398, 106.633369, '510000', '0826');
INSERT INTO zh_city VALUES (751, '511700', '达州市', 31.209484, 107.502262, '510000', '0818');
INSERT INTO zh_city VALUES (752, '511800', '雅安市', 29.987722, 103.001033, '510000', '0835');
INSERT INTO zh_city VALUES (753, '511900', '巴中市', 31.858809, 106.753669, '510000', '0827');
INSERT INTO zh_city VALUES (754, '512000', '资阳市', 30.122211, 104.641917, '510000', '0832');
INSERT INTO zh_city VALUES (755, '513200', '阿坝藏族羌族自治州', 31.899792, 102.221374, '510000', '0837');
INSERT INTO zh_city VALUES (756, '513300', '甘孜藏族自治州', 30.050663, 101.963815, '510000', '0836');
INSERT INTO zh_city VALUES (757, '513400', '凉山彝族自治州', 27.886762, 102.258746, '510000', '0834');
INSERT INTO zh_city VALUES (758, '520100', '贵阳市', 26.578343, 106.713478, '520000', '0851');
INSERT INTO zh_city VALUES (759, '520200', '六盘水市', 26.584643, 104.846743, '520000', '0858');
INSERT INTO zh_city VALUES (760, '520300', '遵义市', 27.706626, 106.937265, '520000', '0852');
INSERT INTO zh_city VALUES (761, '520400', '安顺市', 26.245544, 105.932188, '520000', '0853');
INSERT INTO zh_city VALUES (762, '520500', '毕节市', 27.301693, 105.28501, '520000', '0857');
INSERT INTO zh_city VALUES (763, '520600', '铜仁市', 27.718346, 109.191555, '520000', '0856');
INSERT INTO zh_city VALUES (764, '522300', '黔西南布依族苗族自治州', 25.08812, 104.897971, '520000', '0859');
INSERT INTO zh_city VALUES (765, '522600', '黔东南苗族侗族自治州', 26.583352, 107.977488, '520000', '0855');
INSERT INTO zh_city VALUES (766, '522700', '黔南布依族苗族自治州', 26.258219, 107.517156, '520000', '0854');
INSERT INTO zh_city VALUES (767, '530100', '昆明市', 25.040609, 102.712251, '530000', '0871');
INSERT INTO zh_city VALUES (768, '530300', '曲靖市', 25.501557, 103.797851, '530000', '0874');
INSERT INTO zh_city VALUES (769, '530400', '玉溪市', 24.350461, 102.543907, '530000', '0877');
INSERT INTO zh_city VALUES (770, '530500', '保山市', 25.111802, 99.167133, '530000', '0875');
INSERT INTO zh_city VALUES (771, '530600', '昭通市', 27.336999, 103.717216, '530000', '0870');
INSERT INTO zh_city VALUES (772, '530700', '丽江市', 26.872108, 100.233026, '530000', '0888');
INSERT INTO zh_city VALUES (773, '530800', '普洱市', 22.777321, 100.972344, '530000', '0879');
INSERT INTO zh_city VALUES (774, '530900', '临沧市', 23.886567, 100.08697, '530000', '0883');
INSERT INTO zh_city VALUES (775, '532300', '楚雄彝族自治州', 25.041988, 101.546046, '530000', '0878');
INSERT INTO zh_city VALUES (776, '532500', '红河哈尼族彝族自治州', 23.366775, 103.384182, '530000', '0873');
INSERT INTO zh_city VALUES (777, '532600', '文山壮族苗族自治州', 23.36951, 104.24401, '530000', '0876');
INSERT INTO zh_city VALUES (778, '532800', '西双版纳傣族自治州', 22.001724, 100.797941, '530000', '0691');
INSERT INTO zh_city VALUES (779, '532900', '大理白族自治州', 25.589449, 100.225668, '530000', '0872');
INSERT INTO zh_city VALUES (780, '533100', '德宏傣族景颇族自治州', 24.436694, 98.578363, '530000', '0692');
INSERT INTO zh_city VALUES (781, '533300', '怒江傈僳族自治州', 25.850949, 98.854304, '530000', '0886');
INSERT INTO zh_city VALUES (782, '533400', '迪庆藏族自治州', 27.826853, 99.706463, '530000', '0887');
INSERT INTO zh_city VALUES (783, '540100', '拉萨市', 29.660361, 91.132212, '540000', '0891');
INSERT INTO zh_city VALUES (784, '540200', '日喀则市', 29.267519, 88.885148, '540000', '0892');
INSERT INTO zh_city VALUES (785, '540300', '昌都市', 31.136875, 97.178452, '540000', '0895');
INSERT INTO zh_city VALUES (786, '542200', '山南地区', 29.236023, 91.766529, '540000', '0893');
INSERT INTO zh_city VALUES (787, '542400', '那曲地区', 31.476004, 92.060214, '540000', '0896');
INSERT INTO zh_city VALUES (788, '542500', '阿里地区', 32.503187, 80.105498, '540000', '0897');
INSERT INTO zh_city VALUES (789, '540400', '林芝市', 29.654693, 94.362348, '540000', '0894');
INSERT INTO zh_city VALUES (790, '610100', '西安市', 34.263161, 108.948024, '610000', '029');
INSERT INTO zh_city VALUES (791, '610200', '铜川市', 34.916582, 108.979608, '610000', '0919');
INSERT INTO zh_city VALUES (792, '610300', '宝鸡市', 34.369315, 107.14487, '610000', '0917');
INSERT INTO zh_city VALUES (793, '610400', '咸阳市', 34.333439, 108.705117, '610000', '0910');
INSERT INTO zh_city VALUES (794, '610500', '渭南市', 34.499381, 109.502882, '610000', '0913');
INSERT INTO zh_city VALUES (795, '610600', '延安市', 36.596537, 109.49081, '610000', '0911');
INSERT INTO zh_city VALUES (796, '610700', '汉中市', 33.077668, 107.028621, '610000', '0916');
INSERT INTO zh_city VALUES (797, '610800', '榆林市', 38.290162, 109.741193, '610000', '0912');
INSERT INTO zh_city VALUES (798, '610900', '安康市', 32.6903, 109.029273, '610000', '0915');
INSERT INTO zh_city VALUES (799, '611000', '商洛市', 33.868319, 109.939776, '610000', '0914');
INSERT INTO zh_city VALUES (800, '620100', '兰州市', 36.058039, 103.823557, '620000', '0931');
INSERT INTO zh_city VALUES (801, '620200', '嘉峪关市', 39.786529, 98.277304, '620000', '1937');
INSERT INTO zh_city VALUES (802, '620300', '金昌市', 38.514238, 102.187888, '620000', '0935');
INSERT INTO zh_city VALUES (803, '620400', '白银市', 36.54568, 104.173606, '620000', '0943');
INSERT INTO zh_city VALUES (804, '620500', '天水市', 34.578529, 105.724998, '620000', '0938');
INSERT INTO zh_city VALUES (805, '620600', '武威市', 37.929996, 102.634697, '620000', '1935');
INSERT INTO zh_city VALUES (806, '620700', '张掖市', 38.932897, 100.455472, '620000', '0936');
INSERT INTO zh_city VALUES (807, '620800', '平凉市', 35.54279, 106.684691, '620000', '0933');
INSERT INTO zh_city VALUES (808, '620900', '酒泉市', 39.744023, 98.510795, '620000', '0937');
INSERT INTO zh_city VALUES (809, '621000', '庆阳市', 35.734218, 107.638372, '620000', '0934');
INSERT INTO zh_city VALUES (810, '621100', '定西市', 35.579578, 104.626294, '620000', '0932');
INSERT INTO zh_city VALUES (811, '621200', '陇南市', 33.388598, 104.929379, '620000', '2935');
INSERT INTO zh_city VALUES (812, '622900', '临夏回族自治州', 35.599446, 103.212006, '620000', '0930');
INSERT INTO zh_city VALUES (813, '623000', '甘南藏族自治州', 34.986354, 102.911008, '620000', '0941');
INSERT INTO zh_city VALUES (814, '630100', '西宁市', 36.623178, 101.778916, '630000', '0971');
INSERT INTO zh_city VALUES (815, '630200', '海东市', 36.502916, 102.10327, '630000', '0972');
INSERT INTO zh_city VALUES (816, '632200', '海北藏族自治州', 36.959435, 100.901059, '630000', '0970');
INSERT INTO zh_city VALUES (817, '632300', '黄南藏族自治州', 35.517744, 102.019988, '630000', '0973');
INSERT INTO zh_city VALUES (818, '632500', '海南藏族自治州', 36.280353, 100.619542, '630000', '0974');
INSERT INTO zh_city VALUES (819, '632600', '果洛藏族自治州', 34.4736, 100.242143, '630000', '0975');
INSERT INTO zh_city VALUES (820, '632700', '玉树藏族自治州', 33.004049, 97.008522, '630000', '0976');
INSERT INTO zh_city VALUES (821, '632800', '海西蒙古族藏族自治州', 37.374663, 97.370785, '630000', '0977');
INSERT INTO zh_city VALUES (822, '640100', '银川市', 38.46637, 106.278179, '640000', '0951');
INSERT INTO zh_city VALUES (823, '640200', '石嘴山市', 39.01333, 106.376173, '640000', '0952');
INSERT INTO zh_city VALUES (824, '640300', '吴忠市', 37.986165, 106.199409, '640000', '0953');
INSERT INTO zh_city VALUES (825, '640400', '固原市', 36.004561, 106.285241, '640000', '0954');
INSERT INTO zh_city VALUES (826, '640500', '中卫市', 37.514951, 105.189568, '640000', '1953');
INSERT INTO zh_city VALUES (827, '650100', '乌鲁木齐市', 43.792818, 87.617733, '650000', '0991');
INSERT INTO zh_city VALUES (828, '650200', '克拉玛依市', 45.595886, 84.873946, '650000', '0990');
INSERT INTO zh_city VALUES (829, '650400', '吐鲁番市', 42.947613, 89.184078, '650000', '0995');
INSERT INTO zh_city VALUES (830, '652200', '哈密地区', 42.833248, 93.51316, '650000', '0902');
INSERT INTO zh_city VALUES (831, '652300', '昌吉回族自治州', 44.014577, 87.304012, '650000', '0994');
INSERT INTO zh_city VALUES (832, '652700', '博尔塔拉蒙古自治州', 44.903258, 82.074778, '650000', '0909');
INSERT INTO zh_city VALUES (833, '652800', '巴音郭楞蒙古自治州', 41.768552, 86.150969, '650000', '0996');
INSERT INTO zh_city VALUES (834, '652900', '阿克苏地区', 41.170712, 80.265068, '650000', '0997');
INSERT INTO zh_city VALUES (835, '653000', '克孜勒苏柯尔克孜自治州', 39.713431, 76.172825, '650000', '0908');
INSERT INTO zh_city VALUES (836, '653100', '喀什地区', 39.467664, 75.989138, '650000', '0998');
INSERT INTO zh_city VALUES (837, '653200', '和田地区', 37.110687, 79.92533, '650000', '0903');
INSERT INTO zh_city VALUES (838, '654000', '伊犁哈萨克自治州', 43.92186, 81.317946, '650000', '0999');
INSERT INTO zh_city VALUES (839, '654200', '塔城地区', 46.746301, 82.985732, '650000', '0901');
INSERT INTO zh_city VALUES (840, '654300', '阿勒泰地区', 47.848393, 88.13963, '650000', '0906');
INSERT INTO zh_city VALUES (841, '659001', '石河子市', 44.305886, 86.041075, '650000', '0993');
INSERT INTO zh_city VALUES (842, '659002', '阿拉尔市', 40.541914, 81.285884, '650000', '1997');
INSERT INTO zh_city VALUES (843, '659003', '图木舒克市', 39.867316, 79.077978, '650000', '1998');
INSERT INTO zh_city VALUES (844, '659004', '五家渠市', 44.167401, 87.526884, '650000', '1994');
INSERT INTO zh_city VALUES (845, '659005', '北屯市', 47.353177, 87.824932, '650000', '1906');
INSERT INTO zh_city VALUES (846, '659006', '铁门关市', 41.827251, 85.501218, '650000', '1996');
INSERT INTO zh_city VALUES (847, '659007', '双河市', 44.840524, 82.353656, '650000', '1909');
INSERT INTO zh_city VALUES (848, '659008', '可克达拉市', 43.6832, 80.63579, '650000', '1999');
INSERT INTO zh_city VALUES (849, '810001', '中西区', 22.281931, 114.154334, '810000', '1852');
INSERT INTO zh_city VALUES (850, '810002', '湾仔区', 22.276345, 114.18299, '810000', '1852');
INSERT INTO zh_city VALUES (851, '810003', '东区', 22.279779, 114.225965, '810000', '1852');
INSERT INTO zh_city VALUES (852, '810004', '南区', 22.245811, 114.160023, '810000', '1852');
INSERT INTO zh_city VALUES (853, '810005', '油尖旺区', 22.311632, 114.173347, '810000', '1852');
INSERT INTO zh_city VALUES (854, '810006', '深水埗区', 22.333775, 114.163349, '810000', '1852');
INSERT INTO zh_city VALUES (855, '810007', '九龙城区', 22.312373, 114.193047, '810000', '1852');
INSERT INTO zh_city VALUES (856, '810008', '黄大仙区', 22.336112, 114.203985, '810000', '1852');
INSERT INTO zh_city VALUES (857, '810009', '观塘区', 22.320679, 114.214083, '810000', '1852');
INSERT INTO zh_city VALUES (858, '810010', '荃湾区', 22.368458, 114.121234, '810000', '1852');
INSERT INTO zh_city VALUES (859, '810011', '屯门区', 22.393896, 113.976308, '810000', '1852');
INSERT INTO zh_city VALUES (860, '810012', '元朗区', 22.44132, 114.032528, '810000', '1852');
INSERT INTO zh_city VALUES (861, '810013', '北区', 22.496143, 114.147404, '810000', '1852');
INSERT INTO zh_city VALUES (862, '810014', '大埔区', 22.44573, 114.171713, '810000', '1852');
INSERT INTO zh_city VALUES (863, '810015', '西贡区', 22.314203, 114.264813, '810000', '1852');
INSERT INTO zh_city VALUES (864, '810016', '沙田区', 22.379715, 114.195126, '810000', '1852');
INSERT INTO zh_city VALUES (865, '810017', '葵青区', 22.363908, 114.13918, '810000', '1852');
INSERT INTO zh_city VALUES (866, '810018', '离岛区', 22.286371, 113.946059, '810000', '1852');
INSERT INTO zh_city VALUES (867, '820001', '花地玛堂区', 22.207882, 113.552965, '820000', '1853');
INSERT INTO zh_city VALUES (868, '820002', '花王堂区', 22.199175, 113.549052, '820000', '1853');
INSERT INTO zh_city VALUES (869, '820003', '望德堂区', 22.193791, 113.550252, '820000', '1853');
INSERT INTO zh_city VALUES (870, '820004', '大堂区', 22.188119, 113.55374, '820000', '1853');
INSERT INTO zh_city VALUES (871, '820005', '风顺堂区', 22.187778, 113.54167, '820000', '1853');
INSERT INTO zh_city VALUES (872, '820006', '嘉模堂区', 22.154124, 113.558783, '820000', '1853');
INSERT INTO zh_city VALUES (873, '820007', '路凼填海区', 22.136546, 113.56925, '820000', '1853');
INSERT INTO zh_city VALUES (874, '820008', '圣方济各堂区', 22.124049, 113.559954, '820000', '1853');
SET FOREIGN_KEY_CHECKS = 1;
