mysql省市区表（完整版），带区号、拼音、经纬度

mysql省市区表（完整版），带区号、拼音、经纬度。

表结构示例

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for hup_region
-- ----------------------------
DROP TABLE IF EXISTS `hup_region`;
CREATE TABLE `hup_region`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `pid` int(11) NULL DEFAULT NULL COMMENT '父id',
  `shortname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '简称',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `merger_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '全称',
  `level` tinyint(4) UNSIGNED NULL DEFAULT 0 COMMENT '层级 1 2 3 省市区县',
  `pinyin` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '拼音',
  `code` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '长途区号',
  `zip_code` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮编',
  `first` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '首字母',
  `lng` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经度',
  `lat` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '纬度',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `name,level`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4019 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

表数据部分示例
完整的文章提交不成功，就离谱……

INSERT INTO `hup_region` VALUES (1, 0, '北京', '北京市', '中国,北京', 1, 'beijing', '', '', 'B', '116.405285', '39.904989');
INSERT INTO `hup_region` VALUES (2, 1, '北京', '北京市', '中国,北京,北京市', 2, 'beijing', '010', '100000', 'B', '116.405285', '39.904989');
INSERT INTO `hup_region` VALUES (3, 2, '东城', '东城区', '中国,北京,北京市,东城区', 3, 'dongcheng', '010', '100010', 'D', '116.41005', '39.93157');
INSERT INTO `hup_region` VALUES (4, 2, '西城', '西城区', '中国,北京,北京市,西城区', 3, 'xicheng', '010', '100032', 'X', '116.36003', '39.9305');
INSERT INTO `hup_region` VALUES (5, 2, '朝阳', '朝阳区', '中国,北京,北京市,朝阳区', 3, 'chaoyang', '010', '100020', 'C', '116.48548', '39.9484');
INSERT INTO `hup_region` VALUES (6, 2, '丰台', '丰台区', '中国,北京,北京市,丰台区', 3, 'fengtai', '010', '100071', 'F', '116.28625', '39.8585');
INSERT INTO `hup_region` VALUES (7, 2, '石景山', '石景山区', '中国,北京,北京市,石景山区', 3, 'shijingshan', '010', '100043', 'S', '116.2229', '39.90564');
INSERT INTO `hup_region` VALUES (8, 2, '海淀', '海淀区', '中国,北京,北京市,海淀区', 3, 'haidian', '010', '100089', 'H', '116.29812', '39.95931');
INSERT INTO `hup_region` VALUES (9, 2, '门头沟', '门头沟区', '中国,北京,北京市,门头沟区', 3, 'mentougou', '010', '102300', 'M', '116.10137', '39.94043');
INSERT INTO `hup_region` VALUES (10, 2, '房山', '房山区', '中国,北京,北京市,房山区', 3, 'fangshan', '010', '102488', 'F', '116.14257', '39.74786');
INSERT INTO `hup_region` VALUES (11, 2, '通州', '通州区', '中国,北京,北京市,通州区', 3, 'tongzhou', '010', '101149', 'T', '116.65716', '39.90966');
INSERT INTO `hup_region` VALUES (12, 2, '顺义', '顺义区', '中国,北京,北京市,顺义区', 3, 'shunyi', '010', '101300', 'S', '116.65417', '40.1302');
INSERT INTO `hup_region` VALUES (13, 2, '昌平', '昌平区', '中国,北京,北京市,昌平区', 3, 'changping', '010', '102200', 'C', '116.2312', '40.22072');
INSERT INTO `hup_region` VALUES (14, 2, '大兴', '大兴区', '中国,北京,北京市,大兴区', 3, 'daxing', '010', '102600', 'D', '116.34149', '39.72668');
INSERT INTO `hup_region` VALUES (15, 2, '怀柔', '怀柔区', '中国,北京,北京市,怀柔区', 3, 'huairou', '010', '101400', 'H', '116.63168', '40.31602');
INSERT INTO `hup_region` VALUES (16, 2, '平谷', '平谷区', '中国,北京,北京市,平谷区', 3, 'pinggu', '010', '101200', 'P', '117.12133', '40.14056');
INSERT INTO `hup_region` VALUES (17, 2, '密云', '密云县', '中国,北京,北京市,密云县', 3, 'miyun', '010', '101500', 'M', '116.84295', '40.37618');
INSERT INTO `hup_region` VALUES (18, 2, '延庆', '延庆县', '中国,北京,北京市,延庆县', 3, 'yanqing', '010', '102100', 'Y', '115.97494', '40.45672');
INSERT INTO `hup_region` VALUES (19, 0, '天津', '天津市', '中国,天津', 1, 'tianjin', '', '', 'T', '117.190182', '39.125596');
INSERT INTO `hup_region` VALUES (20, 19, '天津', '天津市', '中国,天津,天津市', 2, 'tianjin', '022', '300000', 'T', '117.190182', '39.125596');
INSERT INTO `hup_region` VALUES (21, 20, '和平', '和平区', '中国,天津,天津市,和平区', 3, 'heping', '022', '300041', 'H', '117.21456', '39.11718');
INSERT INTO `hup_region` VALUES (22, 20, '河东', '河东区', '中国,天津,天津市,河东区', 3, 'hedong', '022', '300171', 'H', '117.22562', '39.12318');
INSERT INTO `hup_region` VALUES (23, 20, '河西', '河西区', '中国,天津,天津市,河西区', 3, 'hexi', '022', '300202', 'H', '117.22327', '39.10959');
INSERT INTO `hup_region` VALUES (24, 20, '南开', '南开区', '中国,天津,天津市,南开区', 3, 'nankai', '022', '300110', 'N', '117.15074', '39.13821');
INSERT INTO `hup_region` VALUES (25, 20, '河北', '河北区', '中国,天津,天津市,河北区', 3, 'hebei', '022', '300143', 'H', '117.19697', '39.14816');
INSERT INTO `hup_region` VALUES (26, 20, '红桥', '红桥区', '中国,天津,天津市,红桥区', 3, 'hongqiao', '022', '300131', 'H', '117.15145', '39.16715');
INSERT INTO `hup_region` VALUES (27, 20, '东丽', '东丽区', '中国,天津,天津市,东丽区', 3, 'dongli', '022', '300300', 'D', '117.31436', '39.0863');
INSERT INTO `hup_region` VALUES (28, 20, '西青', '西青区', '中国,天津,天津市,西青区', 3, 'xiqing', '022', '300380', 'X', '117.00927', '39.14123');
INSERT INTO `hup_region` VALUES (29, 20, '津南', '津南区', '中国,天津,天津市,津南区', 3, 'jinnan', '022', '300350', 'J', '117.38537', '38.99139');
INSERT INTO `hup_region` VALUES (30, 20, '北辰', '北辰区', '中国,天津,天津市,北辰区', 3, 'beichen', '022', '300400', 'B', '117.13217', '39.22131');
INSERT INTO `hup_region` VALUES (31, 20, '武清', '武清区', '中国,天津,天津市,武清区', 3, 'wuqing', '022', '301700', 'W', '117.04443', '39.38415');
INSERT INTO `hup_region` VALUES (32, 20, '宝坻', '宝坻区', '中国,天津,天津市,宝坻区', 3, 'baodi', '022', '301800', 'B', '117.3103', '39.71761');
INSERT INTO `hup_region` VALUES (33, 20, '滨海新区', '滨海新区', '中国,天津,天津市,滨海新区', 3, 'binhaixinqu', '022', '300451', 'B', '117.70162', '39.02668');
INSERT INTO `hup_region` VALUES (34, 20, '宁河', '宁河县', '中国,天津,天津市,宁河县', 3, 'ninghe', '022', '301500', 'N', '117.8255', '39.33048');
INSERT INTO `hup_region` VALUES (35, 20, '静海', '静海县', '中国,天津,天津市,静海县', 3, 'jinghai', '022', '301600', 'J', '116.97436', '38.94582');
INSERT INTO `hup_region` VALUES (36, 20, '蓟县', '蓟县', '中国,天津,天津市,蓟县', 3, 'jixian', '022', '301900', 'J', '117.40799', '40.04567');
INSERT INTO `hup_region` VALUES (37, 0, '河北', '河北省', '中国,河北省', 1, 'hebei', '', '', 'H', '114.502461', '38.045474');
INSERT INTO `hup_region` VALUES (38, 37, '石家庄', '石家庄市', '中国,河北省,石家庄市', 2, 'shijiazhuang', '0311', '050011', 'S', '114.502461', '38.045474');
INSERT INTO `hup_region` VALUES (39, 38, '长安', '长安区', '中国,河北省,石家庄市,长安区', 3, 'chang\'an', '0311', '050011', 'C', '114.53906', '38.03665');
INSERT INTO `hup_region` VALUES (40, 38, '桥西', '桥西区', '中国,河北省,石家庄市,桥西区', 3, 'qiaoxi', '0311', '050091', 'Q', '114.46977', '38.03221');
INSERT INTO `hup_region` VALUES (41, 38, '新华', '新华区', '中国,河北省,石家庄市,新华区', 3, 'xinhua', '0311', '050051', 'X', '114.46326', '38.05088');
INSERT INTO `hup_region` VALUES (42, 38, '井陉矿区', '井陉矿区', '中国,河北省,石家庄市,井陉矿区', 3, 'jingxingkuangqu', '0311', '050100', 'J', '114.06518', '38.06705');
INSERT INTO `hup_region` VALUES (43, 38, '裕华', '裕华区', '中国,河北省,石家庄市,裕华区', 3, 'yuhua', '0311', '050031', 'Y', '114.53115', '38.00604');
INSERT INTO `hup_region` VALUES (44, 38, '藁城', '藁城区', '中国,河北省,石家庄市,藁城区', 3, 'gaocheng', '0311', '052160', NULL, '114.84671', '38.02162');
INSERT INTO `hup_region` VALUES (45, 38, '鹿泉', '鹿泉区', '中国,河北省,石家庄市,鹿泉区', 3, 'luquan', '0311', '050200', 'L', '114.31347', '38.08782');
INSERT INTO `hup_region` VALUES (46, 38, '栾城', '栾城区', '中国,河北省,石家庄市,栾城区', 3, 'luancheng', '0311', '051430', NULL, '114.64834', '37.90022');
INSERT INTO `hup_region` VALUES (47, 38, '井陉', '井陉县', '中国,河北省,石家庄市,井陉县', 3, 'jingxing', '0311', '050300', 'J', '114.14257', '38.03688');
INSERT INTO `hup_region` VALUES (48, 38, '正定', '正定县', '中国,河北省,石家庄市,正定县', 3, 'zhengding', '0311', '050800', 'Z', '114.57296', '38.14445');
INSERT INTO `hup_region` VALUES (49, 38, '行唐', '行唐县', '中国,河北省,石家庄市,行唐县', 3, 'xingtang', '0311', '050600', 'X', '114.55316', '38.43654');
INSERT INTO `hup_region` VALUES (50, 38, '灵寿', '灵寿县', '中国,河北省,石家庄市,灵寿县', 3, 'lingshou', '0311', '050500', 'L', '114.38259', '38.30845');
INSERT INTO `hup_region` VALUES (51, 38, '高邑', '高邑县', '中国,河北省,石家庄市,高邑县', 3, 'gaoyi', '0311', '051330', 'G', '114.61142', '37.61556');
INSERT INTO `hup_region` VALUES (52, 38, '深泽', '深泽县', '中国,河北省,石家庄市,深泽县', 3, 'shenze', '0311', '052560', 'S', '115.20358', '38.18353');
INSERT INTO `hup_region` VALUES (53, 38, '赞皇', '赞皇县', '中国,河北省,石家庄市,赞皇县', 3, 'zanhuang', '0311', '051230', 'Z', '114.38775', '37.66135');
INSERT INTO `hup_region` VALUES (54, 38, '无极', '无极县', '中国,河北省,石家庄市,无极县', 3, 'wuji', '0311', '052460', 'W', '114.97509', '38.17653');
INSERT INTO `hup_region` VALUES (55, 38, '平山', '平山县', '中国,河北省,石家庄市,平山县', 3, 'pingshan', '0311', '050400', 'P', '114.186', '38.25994');
INSERT INTO `hup_region` VALUES (56, 38, '元氏', '元氏县', '中国,河北省,石家庄市,元氏县', 3, 'yuanshi', '0311', '051130', 'Y', '114.52539', '37.76668');
INSERT INTO `hup_region` VALUES (57, 38, '赵县', '赵县', '中国,河北省,石家庄市,赵县', 3, 'zhaoxian', '0311', '051530', 'Z', '114.77612', '37.75628');
INSERT INTO `hup_region` VALUES (58, 38, '辛集', '辛集市', '中国,河北省,石家庄市,辛集市', 3, 'xinji', '0311', '052360', 'X', '115.20626', '37.94079');
INSERT INTO `hup_region` VALUES (59, 38, '晋州', '晋州市', '中国,河北省,石家庄市,晋州市', 3, 'jinzhou', '0311', '052260', 'J', '115.04348', '38.03135');
INSERT INTO `hup_region` VALUES (60, 38, '新乐', '新乐市', '中国,河北省,石家庄市,新乐市', 3, 'xinle', '0311', '050700', 'X', '114.68985', '38.34417');
INSERT INTO `hup_region` VALUES (61, 37, '唐山', '唐山市', '中国,河北省,唐山市', 2, 'tangshan', '0315', '063000', 'T', '118.175393', '39.635113');
INSERT INTO `hup_region` VALUES (62, 61, '路南', '路南区', '中国,河北省,唐山市,路南区', 3, 'lunan', '0315', '063000', 'L', '118.15431', '39.62505');
INSERT INTO `hup_region` VALUES (63, 61, '路北', '路北区', '中国,河北省,唐山市,路北区', 3, 'lubei', '0315', '063000', 'L', '118.20079', '39.62436');
INSERT INTO `hup_region` VALUES (64, 61, '古冶', '古冶区', '中国,河北省,唐山市,古冶区', 3, 'guye', '0315', '063100', 'G', '118.45803', '39.71993');
INSERT INTO `hup_region` VALUES (65, 61, '开平', '开平区', '中国,河北省,唐山市,开平区', 3, 'kaiping', '0315', '063021', 'K', '118.26171', '39.67128');
INSERT INTO `hup_region` VALUES (66, 61, '丰南', '丰南区', '中国,河北省,唐山市,丰南区', 3, 'fengnan', '0315', '063300', 'F', '118.11282', '39.56483');
INSERT INTO `hup_region` VALUES (67, 61, '丰润', '丰润区', '中国,河北省,唐山市,丰润区', 3, 'fengrun', '0315', '064000', 'F', '118.12976', '39.8244');
INSERT INTO `hup_region` VALUES (68, 61, '曹妃甸', '曹妃甸区', '中国,河北省,唐山市,曹妃甸区', 3, 'caofeidian', '0315', '063200', 'C', '118.460379', '39.273070');
INSERT INTO `hup_region` VALUES (69, 61, '滦县', '滦县', '中国,河北省,唐山市,滦县', 3, 'luanxian', '0315', '063700', 'L', '118.70346', '39.74056');
INSERT INTO `hup_region` VALUES (70, 61, '滦南', '滦南县', '中国,河北省,唐山市,滦南县', 3, 'luannan', '0315', '063500', 'L', '118.6741', '39.5039');
INSERT INTO `hup_region` VALUES (71, 61, '乐亭', '乐亭县', '中国,河北省,唐山市,乐亭县', 3, 'laoting', '0315', '063600', 'L', '118.9125', '39.42561');
INSERT INTO `hup_region` VALUES (72, 61, '迁西', '迁西县', '中国,河北省,唐山市,迁西县', 3, 'qianxi', '0315', '064300', 'Q', '118.31616', '40.14587');
INSERT INTO `hup_region` VALUES (73, 61, '玉田', '玉田县', '中国,河北省,唐山市,玉田县', 3, 'yutian', '0315', '064100', 'Y', '117.7388', '39.90049');
INSERT INTO `hup_region` VALUES (74, 61, '遵化', '遵化市', '中国,河北省,唐山市,遵化市', 3, 'zunhua', '0315', '064200', 'Z', '117.96444', '40.18741');
INSERT INTO `hup_region` VALUES (75, 61, '迁安', '迁安市', '中国,河北省,唐山市,迁安市', 3, 'qian\'an', '0315', '064400', 'Q', '118.70068', '39.99833');
INSERT INTO `hup_region` VALUES (76, 37, '秦皇岛', '秦皇岛市', '中国,河北省,秦皇岛市', 2, 'qinhuangdao', '0335', '066000', 'Q', '119.586579', '39.942531');
INSERT INTO `hup_region` VALUES (77, 76, '海港', '海港区', '中国,河北省,秦皇岛市,海港区', 3, 'haigang', '0335', '066000', 'H', '119.61046', '39.9345');
INSERT INTO `hup_region` VALUES (78, 76, '山海关', '山海关区', '中国,河北省,秦皇岛市,山海关区', 3, 'shanhaiguan', '0335', '066200', 'S', '119.77563', '39.97869');
INSERT INTO `hup_region` VALUES (79, 76, '北戴河', '北戴河区', '中国,河北省,秦皇岛市,北戴河区', 3, 'beidaihe', '0335', '066100', 'B', '119.48388', '39.83408');
INSERT INTO `hup_region` VALUES (80, 76, '青龙', '青龙满族自治县', '中国,河北省,秦皇岛市,青龙满族自治县', 3, 'qinglong', '0335', '066500', 'Q', '118.95242', '40.40743');
INSERT INTO `hup_region` VALUES (81, 76, '昌黎', '昌黎县', '中国,河北省,秦皇岛市,昌黎县', 3, 'changli', '0335', '066600', 'C', '119.16595', '39.70884');
INSERT INTO `hup_region` VALUES (82, 76, '抚宁', '抚宁县', '中国,河北省,秦皇岛市,抚宁县', 3, 'funing', '0335', '066300', 'F', '119.24487', '39.87538');
INSERT INTO `hup_region` VALUES (83, 76, '卢龙', '卢龙县', '中国,河北省,秦皇岛市,卢龙县', 3, 'lulong', '0335', '066400', 'L', '118.89288', '39.89176');
INSERT INTO `hup_region` VALUES (84, 37, '邯郸', '邯郸市', '中国,河北省,邯郸市', 2, 'handan', '0310', '056002', 'H', '114.490686', '36.612273');
INSERT INTO `hup_region` VALUES (85, 84, '邯山', '邯山区', '中国,河北省,邯郸市,邯山区', 3, 'hanshan', '0310', '056001', 'H', '114.48375', '36.60006');
INSERT INTO `hup_region` VALUES (86, 84, '丛台', '丛台区', '中国,河北省,邯郸市,丛台区', 3, 'congtai', '0310', '056002', 'C', '114.49343', '36.61847');
INSERT INTO `hup_region` VALUES (87, 84, '复兴', '复兴区', '中国,河北省,邯郸市,复兴区', 3, 'fuxing', '0310', '056003', 'F', '114.45928', '36.61134');
INSERT INTO `hup_region` VALUES (88, 84, '峰峰矿区', '峰峰矿区', '中国,河北省,邯郸市,峰峰矿区', 3, 'fengfengkuangqu', '0310', '056200', 'F', '114.21148', '36.41937');
INSERT INTO `hup_region` VALUES (89, 84, '邯郸', '邯郸县', '中国,河北省,邯郸市,邯郸县', 3, 'handan', '0310', '056101', 'H', '114.53103', '36.59385');
INSERT INTO `hup_region` VALUES (90, 84, '临漳', '临漳县', '中国,河北省,邯郸市,临漳县', 3, 'linzhang', '0310', '056600', 'L', '114.6195', '36.33461');
INSERT INTO `hup_region` VALUES (91, 84, '成安', '成安县', '中国,河北省,邯郸市,成安县', 3, 'cheng\'an', '0310', '056700', 'C', '114.66995', '36.44411');
INSERT INTO `hup_region` VALUES (92, 84, '大名', '大名县', '中国,河北省,邯郸市,大名县', 3, 'daming', '0310', '056900', 'D', '115.15362', '36.27994');
INSERT INTO `hup_region` VALUES (93, 84, '涉县', '涉县', '中国,河北省,邯郸市,涉县', 3, 'shexian', '0310', '056400', 'S', '113.69183', '36.58072');
INSERT INTO `hup_region` VALUES (94, 84, '磁县', '磁县', '中国,河北省,邯郸市,磁县', 3, 'cixian', '0310', '056500', 'C', '114.37387', '36.37392');
INSERT INTO `hup_region` VALUES (95, 84, '肥乡', '肥乡县', '中国,河北省,邯郸市,肥乡县', 3, 'feixiang', '0310', '057550', 'F', '114.79998', '36.54807');
INSERT INTO `hup_region` VALUES (96, 84, '永年', '永年县', '中国,河北省,邯郸市,永年县', 3, 'yongnian', '0310', '057150', 'Y', '114.48925', '36.78356');
INSERT INTO `hup_region` VALUES (97, 84, '邱县', '邱县', '中国,河北省,邯郸市,邱县', 3, 'qiuxian', '0310', '057450', 'Q', '115.17407', '36.82082');
INSERT INTO `hup_region` VALUES (98, 84, '鸡泽', '鸡泽县', '中国,河北省,邯郸市,鸡泽县', 3, 'jize', '0310', '057350', 'J', '114.8742', '36.92374');
INSERT INTO `hup_region` VALUES (99, 84, '广平', '广平县', '中国,河北省,邯郸市,广平县', 3, 'guangping', '0310', '057650', 'G', '114.94653', '36.48046');
INSERT INTO `hup_region` VALUES (100, 84, '馆陶', '馆陶县', '中国,河北省,邯郸市,馆陶县', 3, 'guantao', '0310', '057750', 'G', '115.29913', '36.53719');
INSERT INTO `hup_region` VALUES (101, 84, '魏县', '魏县', '中国,河北省,邯郸市,魏县', 3, 'weixian', '0310', '056800', 'W', '114.93518', '36.36171');
INSERT INTO `hup_region` VALUES (102, 84, '曲周', '曲周县', '中国,河北省,邯郸市,曲周县', 3, 'quzhou', '0310', '057250', 'Q', '114.95196', '36.77671');
INSERT INTO `hup_region` VALUES (103, 84, '武安', '武安市', '中国,河北省,邯郸市,武安市', 3, 'wu\'an', '0310', '056300', 'W', '114.20153', '36.69281');
INSERT INTO `hup_region` VALUES (104, 37, '邢台', '邢台市', '中国,河北省,邢台市', 2, 'xingtai', '0319', '054001', 'X', '114.508851', '37.0682');
INSERT INTO `hup_region` VALUES (105, 104, '桥东', '桥东区', '中国,河北省,邢台市,桥东区', 3, 'qiaodong', '0319', '054001', 'Q', '114.50725', '37.06801');
INSERT INTO `hup_region` VALUES (106, 104, '桥西', '桥西区', '中国,河北省,邢台市,桥西区', 3, 'qiaoxi', '0319', '054000', 'Q', '114.46803', '37.05984');
INSERT INTO `hup_region` VALUES (107, 104, '邢台', '邢台县', '中国,河北省,邢台市,邢台县', 3, 'xingtai', '0319', '054001', 'X', '114.56575', '37.0456');
INSERT INTO `hup_region` VALUES (108, 104, '临城', '临城县', '中国,河北省,邢台市,临城县', 3, 'lincheng', '0319', '054300', 'L', '114.50387', '37.43977');
INSERT INTO `hup_region` VALUES (109, 104, '内丘', '内丘县', '中国,河北省,邢台市,内丘县', 3, 'neiqiu', '0319', '054200', 'N', '114.51212', '37.28671');
INSERT INTO `hup_region` VALUES (110, 104, '柏乡', '柏乡县', '中国,河北省,邢台市,柏乡县', 3, 'baixiang', '0319', '055450', 'B', '114.69332', '37.48242');
INSERT INTO `hup_region` VALUES (111, 104, '隆尧', '隆尧县', '中国,河北省,邢台市,隆尧县', 3, 'longyao', '0319', '055350', 'L', '114.77615', '37.35351');
INSERT INTO `hup_region` VALUES (112, 104, '任县', '任县', '中国,河北省,邢台市,任县', 3, 'renxian', '0319', '055150', 'R', '114.6842', '37.12575');
INSERT INTO `hup_region` VALUES (113, 104, '南和', '南和县', '中国,河北省,邢台市,南和县', 3, 'nanhe', '0319', '054400', 'N', '114.68371', '37.00488');
INSERT INTO `hup_region` VALUES (114, 104, '宁晋', '宁晋县', '中国,河北省,邢台市,宁晋县', 3, 'ningjin', '0319', '055550', 'N', '114.92117', '37.61696');
INSERT INTO `hup_region` VALUES (115, 104, '巨鹿', '巨鹿县', '中国,河北省,邢台市,巨鹿县', 3, 'julu', '0319', '055250', 'J', '115.03524', '37.21801');
INSERT INTO `hup_region` VALUES (116, 104, '新河', '新河县', '中国,河北省,邢台市,新河县', 3, 'xinhe', '0319', '055650', 'X', '115.24987', '37.52718');
INSERT INTO `hup_region` VALUES (117, 104, '广宗', '广宗县', '中国,河北省,邢台市,广宗县', 3, 'guangzong', '0319', '054600', 'G', '115.14254', '37.0746');
INSERT INTO `hup_region` VALUES (118, 104, '平乡', '平乡县', '中国,河北省,邢台市,平乡县', 3, 'pingxiang', '0319', '054500', 'P', '115.03002', '37.06317');
INSERT INTO `hup_region` VALUES (119, 104, '威县', '威县', '中国,河北省,邢台市,威县', 3, 'weixian', '0319', '054700', 'W', '115.2637', '36.9768');
INSERT INTO `hup_region` VALUES (120, 104, '清河', '清河县', '中国,河北省,邢台市,清河县', 3, 'qinghe', '0319', '054800', 'Q', '115.66479', '37.07122');
INSERT INTO `hup_region` VALUES (121, 104, '临西', '临西县', '中国,河北省,邢台市,临西县', 3, 'linxi', '0319', '054900', 'L', '115.50097', '36.87078');
INSERT INTO `hup_region` VALUES (122, 104, '南宫', '南宫市', '中国,河北省,邢台市,南宫市', 3, 'nangong', '0319', '055750', 'N', '115.39068', '37.35799');
INSERT INTO `hup_region` VALUES (123, 104, '沙河', '沙河市', '中国,河北省,邢台市,沙河市', 3, 'shahe', '0319', '054100', 'S', '114.4981', '36.8577');
INSERT INTO `hup_region` VALUES (124, 37, '保定', '保定市', '中国,河北省,保定市', 2, 'baoding', '0312', '071052', 'B', '115.482331', '38.867657');
INSERT INTO `hup_region` VALUES (125, 124, '新市', '新市区', '中国,河北省,保定市,新市区', 3, 'xinshi', '0312', '071051', 'X', '115.4587', '38.87751');
INSERT INTO `hup_region` VALUES (126, 124, '北市', '北市区', '中国,河北省,保定市,北市区', 3, 'beishi', '0312', '071000', 'B', '115.49715', '38.88322');
INSERT INTO `hup_region` VALUES (127, 124, '南市', '南市区', '中国,河北省,保定市,南市区', 3, 'nanshi', '0312', '071001', 'N', '115.52859', '38.85455');
INSERT INTO `hup_region` VALUES (128, 124, '满城', '满城县', '中国,河北省,保定市,满城县', 3, 'mancheng', '0312', '072150', 'M', '115.32296', '38.94972');
INSERT INTO `hup_region` VALUES (129, 124, '清苑', '清苑县', '中国,河北省,保定市,清苑县', 3, 'qingyuan', '0312', '071100', 'Q', '115.49267', '38.76709');
INSERT INTO `hup_region` VALUES (130, 124, '涞水', '涞水县', '中国,河北省,保定市,涞水县', 3, 'laishui', '0312', '074100', NULL, '115.71517', '39.39404');
INSERT INTO `hup_region` VALUES (131, 124, '阜平', '阜平县', '中国,河北省,保定市,阜平县', 3, 'fuping', '0312', '073200', 'F', '114.19683', '38.84763');
INSERT INTO `hup_region` VALUES (132, 124, '徐水', '徐水县', '中国,河北省,保定市,徐水县', 3, 'xushui', '0312', '072550', 'X', '115.65829', '39.02099');
INSERT INTO `hup_region` VALUES (133, 124, '定兴', '定兴县', '中国,河北省,保定市,定兴县', 3, 'dingxing', '0312', '072650', 'D', '115.80786', '39.26312');
INSERT INTO `hup_region` VALUES (134, 124, '唐县', '唐县', '中国,河北省,保定市,唐县', 3, 'tangxian', '0312', '072350', 'T', '114.98516', '38.74513');
INSERT INTO `hup_region` VALUES (135, 124, '高阳', '高阳县', '中国,河北省,保定市,高阳县', 3, 'gaoyang', '0312', '071500', 'G', '115.7788', '38.70003');
INSERT INTO `hup_region` VALUES (136, 124, '容城', '容城县', '中国,河北省,保定市,容城县', 3, 'rongcheng', '0312', '071700', 'R', '115.87158', '39.0535');
INSERT INTO `hup_region` VALUES (137, 124, '涞源', '涞源县', '中国,河北省,保定市,涞源县', 3, 'laiyuan', '0312', '074300', NULL, '114.69128', '39.35388');
INSERT INTO `hup_region` VALUES (138, 124, '望都', '望都县', '中国,河北省,保定市,望都县', 3, 'wangdu', '0312', '072450', 'W', '115.1567', '38.70996');
INSERT INTO `hup_region` VALUES (139, 124, '安新', '安新县', '中国,河北省,保定市,安新县', 3, 'anxin', '0312', '071600', 'A', '115.93557', '38.93532');
INSERT INTO `hup_region` VALUES (140, 124, '易县', '易县', '中国,河北省,保定市,易县', 3, 'yixian', '0312', '074200', 'Y', '115.4981', '39.34885');
INSERT INTO `hup_region` VALUES (141, 124, '曲阳', '曲阳县', '中国,河北省,保定市,曲阳县', 3, 'quyang', '0312', '073100', 'Q', '114.70123', '38.62154');
INSERT INTO `hup_region` VALUES (142, 124, '蠡县', '蠡县', '中国,河北省,保定市,蠡县', 3, 'lixian', '0312', '071400', NULL, '115.57717', '38.48974');
INSERT INTO `hup_region` VALUES (143, 124, '顺平', '顺平县', '中国,河北省,保定市,顺平县', 3, 'shunping', '0312', '072250', 'S', '115.1347', '38.83854');
INSERT INTO `hup_region` VALUES (144, 124, '博野', '博野县', '中国,河北省,保定市,博野县', 3, 'boye', '0312', '071300', 'B', '115.47033', '38.4564');
INSERT INTO `hup_region` VALUES (145, 124, '雄县', '雄县', '中国,河北省,保定市,雄县', 3, 'xiongxian', '0312', '071800', 'X', '116.10873', '38.99442');
INSERT INTO `hup_region` VALUES (146, 124, '涿州', '涿州市', '中国,河北省,保定市,涿州市', 3, 'zhuozhou', '0312', '072750', NULL, '115.98062', '39.48622');
INSERT INTO `hup_region` VALUES (147, 124, '定州', '定州市', '中国,河北省,保定市,定州市', 3, 'dingzhou', '0312', '073000', 'D', '114.9902', '38.51623');
INSERT INTO `hup_region` VALUES (148, 124, '安国', '安国市', '中国,河北省,保定市,安国市', 3, 'anguo', '0312', '071200', 'A', '115.32321', '38.41391');
INSERT INTO `hup_region` VALUES (149, 124, '高碑店', '高碑店市', '中国,河北省,保定市,高碑店市', 3, 'gaobeidian', '0312', '074000', 'G', '115.87368', '39.32655');
INSERT INTO `hup_region` VALUES (150, 37, '张家口', '张家口市', '中国,河北省,张家口市', 2, 'zhangjiakou', '0313', '075000', 'Z', '114.884091', '40.811901');
INSERT INTO `hup_region` VALUES (151, 150, '桥东', '桥东区', '中国,河北省,张家口市,桥东区', 3, 'qiaodong', '0313', '075000', 'Q', '114.8943', '40.78844');
INSERT INTO `hup_region` VALUES (152, 150, '桥西', '桥西区', '中国,河北省,张家口市,桥西区', 3, 'qiaoxi', '0313', '075061', 'Q', '114.86962', '40.81945');
INSERT INTO `hup_region` VALUES (153, 150, '宣化', '宣化区', '中国,河北省,张家口市,宣化区', 3, 'xuanhua', '0313', '075100', 'X', '115.06543', '40.60957');
INSERT INTO `hup_region` VALUES (154, 150, '下花园', '下花园区', '中国,河北省,张家口市,下花园区', 3, 'xiahuayuan', '0313', '075300', 'X', '115.28744', '40.50236');
INSERT INTO `hup_region` VALUES (155, 150, '宣化', '宣化县', '中国,河北省,张家口市,宣化县', 3, 'xuanhua', '0313', '075100', 'X', '115.15497', '40.56618');
INSERT INTO `hup_region` VALUES (156, 150, '张北', '张北县', '中国,河北省,张家口市,张北县', 3, 'zhangbei', '0313', '076450', 'Z', '114.71432', '41.15977');
INSERT INTO `hup_region` VALUES (157, 150, '康保', '康保县', '中国,河北省,张家口市,康保县', 3, 'kangbao', '0313', '076650', 'K', '114.60031', '41.85225');
INSERT INTO `hup_region` VALUES (158, 150, '沽源', '沽源县', '中国,河北省,张家口市,沽源县', 3, 'guyuan', '0313', '076550', 'G', '115.68859', '41.66959');
INSERT INTO `hup_region` VALUES (159, 150, '尚义', '尚义县', '中国,河北省,张家口市,尚义县', 3, 'shangyi', '0313', '076750', 'S', '113.97134', '41.07782');
INSERT INTO `hup_region` VALUES (160, 150, '蔚县', '蔚县', '中国,河北省,张家口市,蔚县', 3, 'yuxian', '0313', '075700', 'W', '114.58892', '39.84067');
INSERT INTO `hup_region` VALUES (161, 150, '阳原', '阳原县', '中国,河北省,张家口市,阳原县', 3, 'yangyuan', '0313', '075800', 'Y', '114.15051', '40.10361');
INSERT INTO `hup_region` VALUES (162, 150, '怀安', '怀安县', '中国,河北省,张家口市,怀安县', 3, 'huai\'an', '0313', '076150', 'H', '114.38559', '40.67425');
INSERT INTO `hup_region` VALUES (163, 150, '万全', '万全县', '中国,河北省,张家口市,万全县', 3, 'wanquan', '0313', '076250', 'W', '114.7405', '40.76694');
INSERT INTO `hup_region` VALUES (164, 150, '怀来', '怀来县', '中国,河北省,张家口市,怀来县', 3, 'huailai', '0313', '075400', 'H', '115.51773', '40.41536');
INSERT INTO `hup_region` VALUES (165, 150, '涿鹿', '涿鹿县', '中国,河北省,张家口市,涿鹿县', 3, 'zhuolu', '0313', '075600', NULL, '115.22403', '40.37636');
INSERT INTO `hup_region` VALUES (166, 150, '赤城', '赤城县', '中国,河北省,张家口市,赤城县', 3, 'chicheng', '0313', '075500', 'C', '115.83187', '40.91438');
INSERT INTO `hup_region` VALUES (167, 150, '崇礼', '崇礼县', '中国,河北省,张家口市,崇礼县', 3, 'chongli', '0313', '076350', 'C', '115.27993', '40.97519');
INSERT INTO `hup_region` VALUES (168, 37, '承德', '承德市', '中国,河北省,承德市', 2, 'chengde', '0314', '067000', 'C', '117.939152', '40.976204');
INSERT INTO `hup_region` VALUES (169, 168, '双桥', '双桥区', '中国,河北省,承德市,双桥区', 3, 'shuangqiao', '0314', '067000', 'S', '117.9432', '40.97466');
INSERT INTO `hup_region` VALUES (170, 168, '双滦', '双滦区', '中国,河北省,承德市,双滦区', 3, 'shuangluan', '0314', '067001', 'S', '117.74487', '40.95375');
INSERT INTO `hup_region` VALUES (171, 168, '鹰手营子矿区', '鹰手营子矿区', '中国,河北省,承德市,鹰手营子矿区', 3, 'yingshouyingzikuangqu', '0314', '067200', 'Y', '117.65985', '40.54744');
INSERT INTO `hup_region` VALUES (172, 168, '承德', '承德县', '中国,河北省,承德市,承德县', 3, 'chengde', '0314', '067400', 'C', '118.17639', '40.76985');
INSERT INTO `hup_region` VALUES (173, 168, '兴隆', '兴隆县', '中国,河北省,承德市,兴隆县', 3, 'xinglong', '0314', '067300', 'X', '117.50073', '40.41709');
INSERT INTO `hup_region` VALUES (174, 168, '平泉', '平泉县', '中国,河北省,承德市,平泉县', 3, 'pingquan', '0314', '067500', 'P', '118.70196', '41.01839');
INSERT INTO `hup_region` VALUES (175, 168, '滦平', '滦平县', '中国,河北省,承德市,滦平县', 3, 'luanping', '0314', '068250', 'L', '117.33276', '40.94148');
INSERT INTO `hup_region` VALUES (176, 168, '隆化', '隆化县', '中国,河北省,承德市,隆化县', 3, 'longhua', '0314', '068150', 'L', '117.7297', '41.31412');
INSERT INTO `hup_region` VALUES (177, 168, '丰宁', '丰宁满族自治县', '中国,河北省,承德市,丰宁满族自治县', 3, 'fengning', '0314', '068350', 'F', '116.6492', '41.20481');
INSERT INTO `hup_region` VALUES (178, 168, '宽城', '宽城满族自治县', '中国,河北省,承德市,宽城满族自治县', 3, 'kuancheng', '0314', '067600', 'K', '118.49176', '40.60829');
INSERT INTO `hup_region` VALUES (179, 168, '围场', '围场满族蒙古族自治县', '中国,河北省,承德市,围场满族蒙古族自治县', 3, 'weichang', '0314', '068450', 'W', '117.7601', '41.94368');
INSERT INTO `hup_region` VALUES (180, 37, '沧州', '沧州市', '中国,河北省,沧州市', 2, 'cangzhou', '0317', '061001', 'C', '116.857461', '38.310582');
INSERT INTO `hup_region` VALUES (181, 180, '新华', '新华区', '中国,河北省,沧州市,新华区', 3, 'xinhua', '0317', '061000', 'X', '116.86643', '38.31438');
INSERT INTO `hup_region` VALUES (182, 180, '运河', '运河区', '中国,河北省,沧州市,运河区', 3, 'yunhe', '0317', '061001', 'Y', '116.85706', '38.31352');
INSERT INTO `hup_region` VALUES (183, 180, '沧县', '沧县', '中国,河北省,沧州市,沧县', 3, 'cangxian', '0317', '061000', 'C', '116.87817', '38.29361');
INSERT INTO `hup_region` VALUES (184, 180, '青县', '青县', '中国,河北省,沧州市,青县', 3, 'qingxian', '0317', '062650', 'Q', '116.80316', '38.58345');
INSERT INTO `hup_region` VALUES (185, 180, '东光', '东光县', '中国,河北省,沧州市,东光县', 3, 'dongguang', '0317', '061600', 'D', '116.53668', '37.8857');
INSERT INTO `hup_region` VALUES (186, 180, '海兴', '海兴县', '中国,河北省,沧州市,海兴县', 3, 'haixing', '0317', '061200', 'H', '117.49758', '38.13958');
INSERT INTO `hup_region` VALUES (187, 180, '盐山', '盐山县', '中国,河北省,沧州市,盐山县', 3, 'yanshan', '0317', '061300', 'Y', '117.23092', '38.05647');
INSERT INTO `hup_region` VALUES (188, 180, '肃宁', '肃宁县', '中国,河北省,沧州市,肃宁县', 3, 'suning', '0317', '062350', 'S', '115.82971', '38.42272');
INSERT INTO `hup_region` VALUES (189, 180, '南皮', '南皮县', '中国,河北省,沧州市,南皮县', 3, 'nanpi', '0317', '061500', 'N', '116.70224', '38.04109');
INSERT INTO `hup_region` VALUES (190, 180, '吴桥', '吴桥县', '中国,河北省,沧州市,吴桥县', 3, 'wuqiao', '0317', '061800', 'W', '116.3847', '37.62546');
INSERT INTO `hup_region` VALUES (191, 180, '献县', '献县', '中国,河北省,沧州市,献县', 3, 'xianxian', '0317', '062250', 'X', '116.12695', '38.19228');
INSERT INTO `hup_region` VALUES (192, 180, '孟村', '孟村回族自治县', '中国,河北省,沧州市,孟村回族自治县', 3, 'mengcun', '0317', '061400', 'M', '117.10412', '38.05338');
INSERT INTO `hup_region` VALUES (193, 180, '泊头', '泊头市', '中国,河北省,沧州市,泊头市', 3, 'botou', '0317', '062150', 'B', '116.57824', '38.08359');
INSERT INTO `hup_region` VALUES (194, 180, '任丘', '任丘市', '中国,河北省,沧州市,任丘市', 3, 'renqiu', '0317', '062550', 'R', '116.1033', '38.71124');
INSERT INTO `hup_region` VALUES (195, 180, '黄骅', '黄骅市', '中国,河北省,沧州市,黄骅市', 3, 'huanghua', '0317', '061100', 'H', '117.33883', '38.3706');
INSERT INTO `hup_region` VALUES (196, 180, '河间', '河间市', '中国,河北省,沧州市,河间市', 3, 'hejian', '0317', '062450', 'H', '116.0993', '38.44549');
INSERT INTO `hup_region` VALUES (197, 37, '廊坊', '廊坊市', '中国,河北省,廊坊市', 2, 'langfang', '0316', '065000', 'L', '116.713873', '39.529244');
INSERT INTO `hup_region` VALUES (198, 197, '安次', '安次区', '中国,河北省,廊坊市,安次区', 3, 'anci', '0316', '065000', 'A', '116.70308', '39.52057');
INSERT INTO `hup_region` VALUES (199, 197, '广阳', '广阳区', '中国,河北省,廊坊市,广阳区', 3, 'guangyang', '0316', '065000', 'G', '116.71069', '39.52278');
INSERT INTO `hup_region` VALUES (200, 197, '固安', '固安县', '中国,河北省,廊坊市,固安县', 3, 'gu\'an', '0316', '065500', 'G', '116.29916', '39.43833');
INSERT INTO `hup_region` VALUES (201, 197, '永清', '永清县', '中国,河北省,廊坊市,永清县', 3, 'yongqing', '0316', '065600', 'Y', '116.50091', '39.32069');
INSERT INTO `hup_region` VALUES (202, 197, '香河', '香河县', '中国,河北省,廊坊市,香河县', 3, 'xianghe', '0316', '065400', 'X', '117.00634', '39.76133');
INSERT INTO `hup_region` VALUES (203, 197, '大城', '大城县', '中国,河北省,廊坊市,大城县', 3, 'daicheng', '0316', '065900', 'D', '116.65353', '38.70534');
INSERT INTO `hup_region` VALUES (204, 197, '文安', '文安县', '中国,河北省,廊坊市,文安县', 3, 'wen\'an', '0316', '065800', 'W', '116.45846', '38.87325');
INSERT INTO `hup_region` VALUES (205, 197, '大厂', '大厂回族自治县', '中国,河北省,廊坊市,大厂回族自治县', 3, 'dachang', '0316', '065300', 'D', '116.98916', '39.88649');
INSERT INTO `hup_region` VALUES (206, 197, '霸州', '霸州市', '中国,河北省,廊坊市,霸州市', 3, 'bazhou', '0316', '065700', 'B', '116.39154', '39.12569');
INSERT INTO `hup_region` VALUES (207, 197, '三河', '三河市', '中国,河北省,廊坊市,三河市', 3, 'sanhe', '0316', '065200', 'S', '117.07229', '39.98358');
INSERT INTO `hup_region` VALUES (208, 37, '衡水', '衡水市', '中国,河北省,衡水市', 2, 'hengshui', '0318', '053000', 'H', '115.665993', '37.735097');
INSERT INTO `hup_region` VALUES (209, 208, '桃城', '桃城区', '中国,河北省,衡水市,桃城区', 3, 'taocheng', '0318', '053000', 'T', '115.67529', '37.73499');
INSERT INTO `hup_region` VALUES (210, 208, '枣强', '枣强县', '中国,河北省,衡水市,枣强县', 3, 'zaoqiang', '0318', '053100', 'Z', '115.72576', '37.51027');
INSERT INTO `hup_region` VALUES (211, 208, '武邑', '武邑县', '中国,河北省,衡水市,武邑县', 3, 'wuyi', '0318', '053400', 'W', '115.88748', '37.80181');
INSERT INTO `hup_region` VALUES (212, 208, '武强', '武强县', '中国,河北省,衡水市,武强县', 3, 'wuqiang', '0318', '053300', 'W', '115.98226', '38.04138');
INSERT INTO `hup_region` VALUES (213, 208, '饶阳', '饶阳县', '中国,河北省,衡水市,饶阳县', 3, 'raoyang', '0318', '053900', 'R', '115.72558', '38.23529');
INSERT INTO `hup_region` VALUES (214, 208, '安平', '安平县', '中国,河北省,衡水市,安平县', 3, 'anping', '0318', '053600', 'A', '115.51876', '38.23388');
INSERT INTO `hup_region` VALUES (215, 208, '故城', '故城县', '中国,河北省,衡水市,故城县', 3, 'gucheng', '0318', '053800', 'G', '115.97076', '37.34773');
INSERT INTO `hup_region` VALUES (216, 208, '景县', '景县', '中国,河北省,衡水市,景县', 3, 'jingxian', '0318', '053500', 'J', '116.26904', '37.6926');
INSERT INTO `hup_region` VALUES (217, 208, '阜城', '阜城县', '中国,河北省,衡水市,阜城县', 3, 'fucheng', '0318', '053700', 'F', '116.14431', '37.86881');
INSERT INTO `hup_region` VALUES (218, 208, '冀州', '冀州市', '中国,河北省,衡水市,冀州市', 3, 'jizhou', '0318', '053200', 'J', '115.57934', '37.55082');
INSERT INTO `hup_region` VALUES (219, 208, '深州', '深州市', '中国,河北省,衡水市,深州市', 3, 'shenzhou', '0318', '053800', 'S', '115.55993', '38.00109');
INSERT INTO `hup_region` VALUES (220, 0, '山西', '山西省', '中国,山西省', 1, 'shanxi', '', '', 'S', '112.549248', '37.857014');
INSERT INTO `hup_region` VALUES (221, 220, '太原', '太原市', '中国,山西省,太原市', 2, 'taiyuan', '0351', '030082', 'T', '112.549248', '37.857014');
INSERT INTO `hup_region` VALUES (222, 221, '小店', '小店区', '中国,山西省,太原市,小店区', 3, 'xiaodian', '0351', '030032', 'X', '112.56878', '37.73565');
INSERT INTO `hup_region` VALUES (223, 221, '迎泽', '迎泽区', '中国,山西省,太原市,迎泽区', 3, 'yingze', '0351', '030002', 'Y', '112.56338', '37.86326');
INSERT INTO `hup_region` VALUES (224, 221, '杏花岭', '杏花岭区', '中国,山西省,太原市,杏花岭区', 3, 'xinghualing', '0351', '030009', 'X', '112.56237', '37.88429');
INSERT INTO `hup_region` VALUES (225, 221, '尖草坪', '尖草坪区', '中国,山西省,太原市,尖草坪区', 3, 'jiancaoping', '0351', '030023', 'J', '112.48709', '37.94193');
INSERT INTO `hup_region` VALUES (226, 221, '万柏林', '万柏林区', '中国,山西省,太原市,万柏林区', 3, 'wanbailin', '0351', '030024', 'W', '112.51553', '37.85923');
INSERT INTO `hup_region` VALUES (227, 221, '晋源', '晋源区', '中国,山西省,太原市,晋源区', 3, 'jinyuan', '0351', '030025', 'J', '112.47985', '37.72479');
INSERT INTO `hup_region` VALUES (228, 221, '清徐', '清徐县', '中国,山西省,太原市,清徐县', 3, 'qingxu', '0351', '030400', 'Q', '112.35888', '37.60758');
INSERT INTO `hup_region` VALUES (229, 221, '阳曲', '阳曲县', '中国,山西省,太原市,阳曲县', 3, 'yangqu', '0351', '030100', 'Y', '112.67861', '38.05989');
INSERT INTO `hup_region` VALUES (230, 221, '娄烦', '娄烦县', '中国,山西省,太原市,娄烦县', 3, 'loufan', '0351', '030300', 'L', '111.79473', '38.06689');
INSERT INTO `hup_region` VALUES (231, 221, '古交', '古交市', '中国,山西省,太原市,古交市', 3, 'gujiao', '0351', '030200', 'G', '112.16918', '37.90983');
INSERT INTO `hup_region` VALUES (232, 220, '大同', '大同市', '中国,山西省,大同市', 2, 'datong', '0352', '037008', 'D', '113.295259', '40.09031');
INSERT INTO `hup_region` VALUES (233, 232, '城区', '城区', '中国,山西省,大同市,城区', 3, 'chengqu', '0352', '037008', 'C', '113.298', '40.07566');
INSERT INTO `hup_region` VALUES (234, 232, '矿区', '矿区', '中国,山西省,大同市,矿区', 3, 'kuangqu', '0352', '037003', 'K', '113.1772', '40.03685');
INSERT INTO `hup_region` VALUES (235, 232, '南郊', '南郊区', '中国,山西省,大同市,南郊区', 3, 'nanjiao', '0352', '037001', 'N', '113.14947', '40.00539');
INSERT INTO `hup_region` VALUES (236, 232, '新荣', '新荣区', '中国,山西省,大同市,新荣区', 3, 'xinrong', '0352', '037002', 'X', '113.13504', '40.25618');
INSERT INTO `hup_region` VALUES (237, 232, '阳高', '阳高县', '中国,山西省,大同市,阳高县', 3, 'yanggao', '0352', '038100', 'Y', '113.75012', '40.36256');
INSERT INTO `hup_region` VALUES (238, 232, '天镇', '天镇县', '中国,山西省,大同市,天镇县', 3, 'tianzhen', '0352', '038200', 'T', '114.0931', '40.42299');
INSERT INTO `hup_region` VALUES (239, 232, '广灵', '广灵县', '中国,山西省,大同市,广灵县', 3, 'guangling', '0352', '037500', 'G', '114.28204', '39.76082');
INSERT INTO `hup_region` VALUES (240, 232, '灵丘', '灵丘县', '中国,山西省,大同市,灵丘县', 3, 'lingqiu', '0352', '034400', 'L', '114.23672', '39.44043');
INSERT INTO `hup_region` VALUES (241, 232, '浑源', '浑源县', '中国,山西省,大同市,浑源县', 3, 'hunyuan', '0352', '037400', 'H', '113.69552', '39.69962');
INSERT INTO `hup_region` VALUES (242, 232, '左云', '左云县', '中国,山西省,大同市,左云县', 3, 'zuoyun', '0352', '037100', 'Z', '112.70266', '40.01336');
INSERT INTO `hup_region` VALUES (243, 232, '大同', '大同县', '中国,山西省,大同市,大同县', 3, 'datong', '0352', '037300', 'D', '113.61212', '40.04012');
INSERT INTO `hup_region` VALUES (244, 220, '阳泉', '阳泉市', '中国,山西省,阳泉市', 2, 'yangquan', '0353', '045000', 'Y', '113.583285', '37.861188');
INSERT INTO `hup_region` VALUES (245, 244, '城区', '城区', '中国,山西省,阳泉市,城区', 3, 'chengqu', '0353', '045000', 'C', '113.60069', '37.8474');
INSERT INTO `hup_region` VALUES (246, 244, '矿区', '矿区', '中国,山西省,阳泉市,矿区', 3, 'kuangqu', '0353', '045000', 'K', '113.55677', '37.86895');
INSERT INTO `hup_region` VALUES (247, 244, '郊区', '郊区', '中国,山西省,阳泉市,郊区', 3, 'jiaoqu', '0353', '045011', 'J', '113.58539', '37.94139');
INSERT INTO `hup_region` VALUES (248, 244, '平定', '平定县', '中国,山西省,阳泉市,平定县', 3, 'pingding', '0353', '045200', 'P', '113.65789', '37.78601');
INSERT INTO `hup_region` VALUES (249, 244, '盂县', '盂县', '中国,山西省,阳泉市,盂县', 3, 'yuxian', '0353', '045100', 'Y', '113.41235', '38.08579');
INSERT INTO `hup_region` VALUES (250, 220, '长治', '长治市', '中国,山西省,长治市', 2, 'changzhi', '0355', '046000', 'C', '113.113556', '36.191112');
INSERT INTO `hup_region` VALUES (251, 250, '城区', '城区', '中国,山西省,长治市,城区', 3, 'chengqu', '0355', '046011', 'C', '113.12308', '36.20351');
INSERT INTO `hup_region` VALUES (252, 250, '郊区', '郊区', '中国,山西省,长治市,郊区', 3, 'jiaoqu', '0355', '046011', 'J', '113.12653', '36.19918');
INSERT INTO `hup_region` VALUES (253, 250, '长治', '长治县', '中国,山西省,长治市,长治县', 3, 'changzhi', '0355', '047100', 'C', '113.04791', '36.04722');
INSERT INTO `hup_region` VALUES (254, 250, '襄垣', '襄垣县', '中国,山西省,长治市,襄垣县', 3, 'xiangyuan', '0355', '046200', 'X', '113.05157', '36.53527');
INSERT INTO `hup_region` VALUES (255, 250, '屯留', '屯留县', '中国,山西省,长治市,屯留县', 3, 'tunliu', '0355', '046100', 'T', '112.89196', '36.31579');
INSERT INTO `hup_region` VALUES (256, 250, '平顺', '平顺县', '中国,山西省,长治市,平顺县', 3, 'pingshun', '0355', '047400', 'P', '113.43603', '36.20005');
INSERT INTO `hup_region` VALUES (257, 250, '黎城', '黎城县', '中国,山西省,长治市,黎城县', 3, 'licheng', '0355', '047600', 'L', '113.38766', '36.50301');
INSERT INTO `hup_region` VALUES (258, 250, '壶关', '壶关县', '中国,山西省,长治市,壶关县', 3, 'huguan', '0355', '047300', 'H', '113.207', '36.11301');
INSERT INTO `hup_region` VALUES (259, 250, '长子', '长子县', '中国,山西省,长治市,长子县', 3, 'zhangzi', '0355', '046600', 'C', '112.87731', '36.12125');
INSERT INTO `hup_region` VALUES (260, 250, '武乡', '武乡县', '中国,山西省,长治市,武乡县', 3, 'wuxiang', '0355', '046300', 'W', '112.86343', '36.83687');
INSERT INTO `hup_region` VALUES (261, 250, '沁县', '沁县', '中国,山西省,长治市,沁县', 3, 'qinxian', '0355', '046400', 'Q', '112.69863', '36.75628');
INSERT INTO `hup_region` VALUES (262, 250, '沁源', '沁源县', '中国,山西省,长治市,沁源县', 3, 'qinyuan', '0355', '046500', 'Q', '112.33758', '36.50008');
INSERT INTO `hup_region` VALUES (263, 250, '潞城', '潞城市', '中国,山西省,长治市,潞城市', 3, 'lucheng', '0355', '047500', 'L', '113.22888', '36.33414');
INSERT INTO `hup_region` VALUES (264, 220, '晋城', '晋城市', '中国,山西省,晋城市', 2, 'jincheng', '0356', '048000', 'J', '112.851274', '35.497553');
INSERT INTO `hup_region` VALUES (265, 264, '城区', '城区', '中国,山西省,晋城市,城区', 3, 'chengqu', '0356', '048000', 'C', '112.85319', '35.50175');
INSERT INTO `hup_region` VALUES (266, 264, '沁水', '沁水县', '中国,山西省,晋城市,沁水县', 3, 'qinshui', '0356', '048200', 'Q', '112.1871', '35.69102');
INSERT INTO `hup_region` VALUES (267, 264, '阳城', '阳城县', '中国,山西省,晋城市,阳城县', 3, 'yangcheng', '0356', '048100', 'Y', '112.41485', '35.48614');
INSERT INTO `hup_region` VALUES (268, 264, '陵川', '陵川县', '中国,山西省,晋城市,陵川县', 3, 'lingchuan', '0356', '048300', 'L', '113.2806', '35.77532');
INSERT INTO `hup_region` VALUES (269, 264, '泽州', '泽州县', '中国,山西省,晋城市,泽州县', 3, 'zezhou', '0356', '048012', 'Z', '112.83947', '35.50789');
INSERT INTO `hup_region` VALUES (270, 264, '高平', '高平市', '中国,山西省,晋城市,高平市', 3, 'gaoping', '0356', '048400', 'G', '112.92288', '35.79705');
INSERT INTO `hup_region` VALUES (271, 220, '朔州', '朔州市', '中国,山西省,朔州市', 2, 'shuozhou', '0349', '038500', 'S', '112.433387', '39.331261');
INSERT INTO `hup_region` VALUES (272, 271, '朔城', '朔城区', '中国,山西省,朔州市,朔城区', 3, 'shuocheng', '0349', '036000', 'S', '112.43189', '39.31982');
INSERT INTO `hup_region` VALUES (273, 271, '平鲁', '平鲁区', '中国,山西省,朔州市,平鲁区', 3, 'pinglu', '0349', '038600', 'P', '112.28833', '39.51155');
INSERT INTO `hup_region` VALUES (274, 271, '山阴', '山阴县', '中国,山西省,朔州市,山阴县', 3, 'shanyin', '0349', '036900', 'S', '112.81662', '39.52697');
INSERT INTO `hup_region` VALUES (275, 271, '应县', '应县', '中国,山西省,朔州市,应县', 3, 'yingxian', '0349', '037600', 'Y', '113.19052', '39.55279');
INSERT INTO `hup_region` VALUES (276, 271, '右玉', '右玉县', '中国,山西省,朔州市,右玉县', 3, 'youyu', '0349', '037200', 'Y', '112.46902', '39.99011');
INSERT INTO `hup_region` VALUES (277, 271, '怀仁', '怀仁县', '中国,山西省,朔州市,怀仁县', 3, 'huairen', '0349', '038300', 'H', '113.10009', '39.82806');
INSERT INTO `hup_region` VALUES (278, 220, '晋中', '晋中市', '中国,山西省,晋中市', 2, 'jinzhong', '0354', '030600', 'J', '112.736465', '37.696495');
INSERT INTO `hup_region` VALUES (279, 278, '榆次', '榆次区', '中国,山西省,晋中市,榆次区', 3, 'yuci', '0354', '030600', 'Y', '112.70788', '37.6978');
INSERT INTO `hup_region` VALUES (280, 278, '榆社', '榆社县', '中国,山西省,晋中市,榆社县', 3, 'yushe', '0354', '031800', 'Y', '112.97558', '37.0721');
INSERT INTO `hup_region` VALUES (281, 278, '左权', '左权县', '中国,山西省,晋中市,左权县', 3, 'zuoquan', '0354', '032600', 'Z', '113.37918', '37.08235');
INSERT INTO `hup_region` VALUES (282, 278, '和顺', '和顺县', '中国,山西省,晋中市,和顺县', 3, 'heshun', '0354', '032700', 'H', '113.56988', '37.32963');
INSERT INTO `hup_region` VALUES (283, 278, '昔阳', '昔阳县', '中国,山西省,晋中市,昔阳县', 3, 'xiyang', '0354', '045300', 'X', '113.70517', '37.61863');
INSERT INTO `hup_region` VALUES (284, 278, '寿阳', '寿阳县', '中国,山西省,晋中市,寿阳县', 3, 'shouyang', '0354', '045400', 'S', '113.17495', '37.88899');
INSERT INTO `hup_region` VALUES (285, 278, '太谷', '太谷县', '中国,山西省,晋中市,太谷县', 3, 'taigu', '0354', '030800', 'T', '112.55246', '37.42161');
INSERT INTO `hup_region` VALUES (286, 278, '祁县', '祁县', '中国,山西省,晋中市,祁县', 3, 'qixian', '0354', '030900', 'Q', '112.33358', '37.3579');
INSERT INTO `hup_region` VALUES (287, 278, '平遥', '平遥县', '中国,山西省,晋中市,平遥县', 3, 'pingyao', '0354', '031100', 'P', '112.17553', '37.1892');
INSERT INTO `hup_region` VALUES (288, 278, '灵石', '灵石县', '中国,山西省,晋中市,灵石县', 3, 'lingshi', '0354', '031300', 'L', '111.7774', '36.84814');
INSERT INTO `hup_region` VALUES (289, 278, '介休', '介休市', '中国,山西省,晋中市,介休市', 3, 'jiexiu', '0354', '032000', 'J', '111.91824', '37.02771');
INSERT INTO `hup_region` VALUES (290, 220, '运城', '运城市', '中国,山西省,运城市', 2, 'yuncheng', '0359', '044000', 'Y', '111.003957', '35.022778');
INSERT INTO `hup_region` VALUES (291, 290, '盐湖', '盐湖区', '中国,山西省,运城市,盐湖区', 3, 'yanhu', '0359', '044000', 'Y', '110.99827', '35.0151');
INSERT INTO `hup_region` VALUES (292, 290, '临猗', '临猗县', '中国,山西省,运城市,临猗县', 3, 'linyi', '0359', '044100', 'L', '110.77432', '35.14455');
INSERT INTO `hup_region` VALUES (293, 290, '万荣', '万荣县', '中国,山西省,运城市,万荣县', 3, 'wanrong', '0359', '044200', 'W', '110.83657', '35.41556');
INSERT INTO `hup_region` VALUES (294, 290, '闻喜', '闻喜县', '中国,山西省,运城市,闻喜县', 3, 'wenxi', '0359', '043800', 'W', '111.22265', '35.35553');
INSERT INTO `hup_region` VALUES (295, 290, '稷山', '稷山县', '中国,山西省,运城市,稷山县', 3, 'jishan', '0359', '043200', NULL, '110.97924', '35.59993');
INSERT INTO `hup_region` VALUES (296, 290, '新绛', '新绛县', '中国,山西省,运城市,新绛县', 3, 'xinjiang', '0359', '043100', 'X', '111.22509', '35.61566');
INSERT INTO `hup_region` VALUES (297, 290, '绛县', '绛县', '中国,山西省,运城市,绛县', 3, 'jiangxian', '0359', '043600', NULL, '111.56668', '35.49096');
INSERT INTO `hup_region` VALUES (298, 290, '垣曲', '垣曲县', '中国,山西省,运城市,垣曲县', 3, 'yuanqu', '0359', '043700', 'Y', '111.67166', '35.29923');
INSERT INTO `hup_region` VALUES (299, 290, '夏县', '夏县', '中国,山西省,运城市,夏县', 3, 'xiaxian', '0359', '044400', 'X', '111.21966', '35.14121');
INSERT INTO `hup_region` VALUES (300, 290, '平陆', '平陆县', '中国,山西省,运城市,平陆县', 3, 'pinglu', '0359', '044300', 'P', '111.21704', '34.83772');
INSERT INTO `hup_region` VALUES (301, 290, '芮城', '芮城县', '中国,山西省,运城市,芮城县', 3, 'ruicheng', '0359', '044600', NULL, '110.69455', '34.69384');
INSERT INTO `hup_region` VALUES (302, 290, '永济', '永济市', '中国,山西省,运城市,永济市', 3, 'yongji', '0359', '044500', 'Y', '110.44537', '34.86556');
INSERT INTO `hup_region` VALUES (303, 290, '河津', '河津市', '中国,山西省,运城市,河津市', 3, 'hejin', '0359', '043300', 'H', '110.7116', '35.59478');
INSERT INTO `hup_region` VALUES (304, 220, '忻州', '忻州市', '中国,山西省,忻州市', 2, 'xinzhou', '0350', '034000', 'X', '112.733538', '38.41769');
INSERT INTO `hup_region` VALUES (305, 304, '忻府', '忻府区', '中国,山西省,忻州市,忻府区', 3, 'xinfu', '0350', '034000', 'X', '112.74603', '38.40414');
INSERT INTO `hup_region` VALUES (306, 304, '定襄', '定襄县', '中国,山西省,忻州市,定襄县', 3, 'dingxiang', '0350', '035400', 'D', '112.95733', '38.47387');
INSERT INTO `hup_region` VALUES (307, 304, '五台', '五台县', '中国,山西省,忻州市,五台县', 3, 'wutai', '0350', '035500', 'W', '113.25256', '38.72774');
INSERT INTO `hup_region` VALUES (308, 304, '代县', '代县', '中国,山西省,忻州市,代县', 3, 'daixian', '0350', '034200', 'D', '112.95913', '39.06717');
INSERT INTO `hup_region` VALUES (309, 304, '繁峙', '繁峙县', '中国,山西省,忻州市,繁峙县', 3, 'fanshi', '0350', '034300', 'F', '113.26303', '39.18886');
INSERT INTO `hup_region` VALUES (310, 304, '宁武', '宁武县', '中国,山西省,忻州市,宁武县', 3, 'ningwu', '0350', '036700', 'N', '112.30423', '39.00211');
INSERT INTO `hup_region` VALUES (311, 304, '静乐', '静乐县', '中国,山西省,忻州市,静乐县', 3, 'jingle', '0350', '035100', 'J', '111.94158', '38.3602');
INSERT INTO `hup_region` VALUES (312, 304, '神池', '神池县', '中国,山西省,忻州市,神池县', 3, 'shenchi', '0350', '036100', 'S', '112.20541', '39.09');
INSERT INTO `hup_region` VALUES (313, 304, '五寨', '五寨县', '中国,山西省,忻州市,五寨县', 3, 'wuzhai', '0350', '036200', 'W', '111.8489', '38.90757');
INSERT INTO `hup_region` VALUES (314, 304, '岢岚', '岢岚县', '中国,山西省,忻州市,岢岚县', 3, 'kelan', '0350', '036300', NULL, '111.57388', '38.70452');
INSERT INTO `hup_region` VALUES (315, 304, '河曲', '河曲县', '中国,山西省,忻州市,河曲县', 3, 'hequ', '0350', '036500', 'H', '111.13821', '39.38439');
INSERT INTO `hup_region` VALUES (316, 304, '保德', '保德县', '中国,山西省,忻州市,保德县', 3, 'baode', '0350', '036600', 'B', '111.08656', '39.02248');
INSERT INTO `hup_region` VALUES (317, 304, '偏关', '偏关县', '中国,山西省,忻州市,偏关县', 3, 'pianguan', '0350', '036400', 'P', '111.50863', '39.43609');
INSERT INTO `hup_region` VALUES (318, 304, '原平', '原平市', '中国,山西省,忻州市,原平市', 3, 'yuanping', '0350', '034100', 'Y', '112.70584', '38.73181');
INSERT INTO `hup_region` VALUES (319, 220, '临汾', '临汾市', '中国,山西省,临汾市', 2, 'linfen', '0357', '041000', 'L', '111.517973', '36.08415');
INSERT INTO `hup_region` VALUES (320, 319, '尧都', '尧都区', '中国,山西省,临汾市,尧都区', 3, 'yaodu', '0357', '041000', 'Y', '111.5787', '36.08298');
INSERT INTO `hup_region` VALUES (321, 319, '曲沃', '曲沃县', '中国,山西省,临汾市,曲沃县', 3, 'quwo', '0357', '043400', 'Q', '111.47525', '35.64119');
INSERT INTO `hup_region` VALUES (322, 319, '翼城', '翼城县', '中国,山西省,临汾市,翼城县', 3, 'yicheng', '0357', '043500', 'Y', '111.7181', '35.73881');
INSERT INTO `hup_region` VALUES (323, 319, '襄汾', '襄汾县', '中国,山西省,临汾市,襄汾县', 3, 'xiangfen', '0357', '041500', 'X', '111.44204', '35.87711');
INSERT INTO `hup_region` VALUES (324, 319, '洪洞', '洪洞县', '中国,山西省,临汾市,洪洞县', 3, 'hongtong', '0357', '041600', 'H', '111.67501', '36.25425');
INSERT INTO `hup_region` VALUES (325, 319, '古县', '古县', '中国,山西省,临汾市,古县', 3, 'guxian', '0357', '042400', 'G', '111.92041', '36.26688');
INSERT INTO `hup_region` VALUES (326, 319, '安泽', '安泽县', '中国,山西省,临汾市,安泽县', 3, 'anze', '0357', '042500', 'A', '112.24981', '36.14803');
INSERT INTO `hup_region` VALUES (327, 319, '浮山', '浮山县', '中国,山西省,临汾市,浮山县', 3, 'fushan', '0357', '042600', 'F', '111.84744', '35.96854');
INSERT INTO `hup_region` VALUES (328, 319, '吉县', '吉县', '中国,山西省,临汾市,吉县', 3, 'jixian', '0357', '042200', 'J', '110.68148', '36.09873');
INSERT INTO `hup_region` VALUES (329, 319, '乡宁', '乡宁县', '中国,山西省,临汾市,乡宁县', 3, 'xiangning', '0357', '042100', 'X', '110.84652', '35.97072');
INSERT INTO `hup_region` VALUES (330, 319, '大宁', '大宁县', '中国,山西省,临汾市,大宁县', 3, 'daning', '0357', '042300', 'D', '110.75216', '36.46624');
INSERT INTO `hup_region` VALUES (331, 319, '隰县', '隰县', '中国,山西省,临汾市,隰县', 3, 'xixian', '0357', '041300', NULL, '110.93881', '36.69258');
INSERT INTO `hup_region` VALUES (332, 319, '永和', '永和县', '中国,山西省,临汾市,永和县', 3, 'yonghe', '0357', '041400', 'Y', '110.63168', '36.7584');
INSERT INTO `hup_region` VALUES (333, 319, '蒲县', '蒲县', '中国,山西省,临汾市,蒲县', 3, 'puxian', '0357', '041200', 'P', '111.09674', '36.41243');
INSERT INTO `hup_region` VALUES (334, 319, '汾西', '汾西县', '中国,山西省,临汾市,汾西县', 3, 'fenxi', '0357', '031500', 'F', '111.56811', '36.65063');
INSERT INTO `hup_region` VALUES (335, 319, '侯马', '侯马市', '中国,山西省,临汾市,侯马市', 3, 'houma', '0357', '043000', 'H', '111.37207', '35.61903');
INSERT INTO `hup_region` VALUES (336, 319, '霍州', '霍州市', '中国,山西省,临汾市,霍州市', 3, 'huozhou', '0357', '031400', 'H', '111.755', '36.5638');
INSERT INTO `hup_region` VALUES (337, 220, '吕梁', '吕梁市', '中国,山西省,吕梁市', 2, 'lvliang', '0358', '033000', 'L', '111.134335', '37.524366');
INSERT INTO `hup_region` VALUES (338, 337, '离石', '离石区', '中国,山西省,吕梁市,离石区', 3, 'lishi', '0358', '033000', 'L', '111.15059', '37.5177');
INSERT INTO `hup_region` VALUES (339, 337, '文水', '文水县', '中国,山西省,吕梁市,文水县', 3, 'wenshui', '0358', '032100', 'W', '112.02829', '37.43841');
INSERT INTO `hup_region` VALUES (340, 337, '交城', '交城县', '中国,山西省,吕梁市,交城县', 3, 'jiaocheng', '0358', '030500', 'J', '112.1585', '37.5512');
INSERT INTO `hup_region` VALUES (341, 337, '兴县', '兴县', '中国,山西省,吕梁市,兴县', 3, 'xingxian', '0358', '033600', 'X', '111.12692', '38.46321');
INSERT INTO `hup_region` VALUES (342, 337, '临县', '临县', '中国,山西省,吕梁市,临县', 3, 'linxian', '0358', '033200', 'L', '110.99282', '37.95271');
INSERT INTO `hup_region` VALUES (343, 337, '柳林', '柳林县', '中国,山西省,吕梁市,柳林县', 3, 'liulin', '0358', '033300', 'L', '110.88922', '37.42932');
INSERT INTO `hup_region` VALUES (344, 337, '石楼', '石楼县', '中国,山西省,吕梁市,石楼县', 3, 'shilou', '0358', '032500', 'S', '110.8352', '36.99731');
INSERT INTO `hup_region` VALUES (345, 337, '岚县', '岚县', '中国,山西省,吕梁市,岚县', 3, 'lanxian', '0358', '033500', NULL, '111.67627', '38.27874');
INSERT INTO `hup_region` VALUES (346, 337, '方山', '方山县', '中国,山西省,吕梁市,方山县', 3, 'fangshan', '0358', '033100', 'F', '111.24011', '37.88979');
INSERT INTO `hup_region` VALUES (347, 337, '中阳', '中阳县', '中国,山西省,吕梁市,中阳县', 3, 'zhongyang', '0358', '033400', 'Z', '111.1795', '37.35715');
INSERT INTO `hup_region` VALUES (348, 337, '交口', '交口县', '中国,山西省,吕梁市,交口县', 3, 'jiaokou', '0358', '032400', 'J', '111.18103', '36.98213');
INSERT INTO `hup_region` VALUES (349, 337, '孝义', '孝义市', '中国,山西省,吕梁市,孝义市', 3, 'xiaoyi', '0358', '032300', 'X', '111.77362', '37.14414');
INSERT INTO `hup_region` VALUES (350, 337, '汾阳', '汾阳市', '中国,山西省,吕梁市,汾阳市', 3, 'fenyang', '0358', '032200', 'F', '111.7882', '37.26605');
INSERT INTO `hup_region` VALUES (351, 0, '内蒙古', '内蒙古自治区', '中国,内蒙古自治区', 1, 'innermongolia', '', '', 'N', '111.670801', '40.818311');
INSERT INTO `hup_region` VALUES (352, 351, '呼和浩特', '呼和浩特市', '中国,内蒙古自治区,呼和浩特市', 2, 'hohhot', '0471', '010000', 'H', '111.670801', '40.818311');
INSERT INTO `hup_region` VALUES (353, 352, '新城', '新城区', '中国,内蒙古自治区,呼和浩特市,新城区', 3, 'xincheng', '0471', '010050', 'X', '111.66554', '40.85828');
INSERT INTO `hup_region` VALUES (354, 352, '回民', '回民区', '中国,内蒙古自治区,呼和浩特市,回民区', 3, 'huimin', '0471', '010030', 'H', '111.62402', '40.80827');
INSERT INTO `hup_region` VALUES (355, 352, '玉泉', '玉泉区', '中国,内蒙古自治区,呼和浩特市,玉泉区', 3, 'yuquan', '0471', '010020', 'Y', '111.67456', '40.75227');
INSERT INTO `hup_region` VALUES (356, 352, '赛罕', '赛罕区', '中国,内蒙古自治区,呼和浩特市,赛罕区', 3, 'saihan', '0471', '010020', 'S', '111.70224', '40.79207');
INSERT INTO `hup_region` VALUES (357, 352, '土默特左旗', '土默特左旗', '中国,内蒙古自治区,呼和浩特市,土默特左旗', 3, 'tumotezuoqi', '0471', '010100', 'T', '111.14898', '40.72229');
INSERT INTO `hup_region` VALUES (358, 352, '托克托', '托克托县', '中国,内蒙古自治区,呼和浩特市,托克托县', 3, 'tuoketuo', '0471', '010200', 'T', '111.19101', '40.27492');
INSERT INTO `hup_region` VALUES (359, 352, '和林格尔', '和林格尔县', '中国,内蒙古自治区,呼和浩特市,和林格尔县', 3, 'helingeer', '0471', '011500', 'H', '111.82205', '40.37892');
INSERT INTO `hup_region` VALUES (360, 352, '清水河', '清水河县', '中国,内蒙古自治区,呼和浩特市,清水河县', 3, 'qingshuihe', '0471', '011600', 'Q', '111.68316', '39.9097');
INSERT INTO `hup_region` VALUES (361, 352, '武川', '武川县', '中国,内蒙古自治区,呼和浩特市,武川县', 3, 'wuchuan', '0471', '011700', 'W', '111.45785', '41.09289');
INSERT INTO `hup_region` VALUES (362, 351, '包头', '包头市', '中国,内蒙古自治区,包头市', 2, 'baotou', '0472', '014025', 'B', '109.840405', '40.658168');
INSERT INTO `hup_region` VALUES (363, 362, '东河', '东河区', '中国,内蒙古自治区,包头市,东河区', 3, 'donghe', '0472', '014040', 'D', '110.0462', '40.58237');
INSERT INTO `hup_region` VALUES (364, 362, '昆都仑', '昆都仑区', '中国,内蒙古自治区,包头市,昆都仑区', 3, 'kundulun', '0472', '014010', 'K', '109.83862', '40.64175');
INSERT INTO `hup_region` VALUES (365, 362, '青山', '青山区', '中国,内蒙古自治区,包头市,青山区', 3, 'qingshan', '0472', '014030', 'Q', '109.90131', '40.64329');
INSERT INTO `hup_region` VALUES (366, 362, '石拐', '石拐区', '中国,内蒙古自治区,包头市,石拐区', 3, 'shiguai', '0472', '014070', 'S', '110.27322', '40.67297');
INSERT INTO `hup_region` VALUES (367, 362, '白云鄂博矿区', '白云鄂博矿区', '中国,内蒙古自治区,包头市,白云鄂博矿区', 3, 'baiyunebokuangqu', '0472', '014080', 'B', '109.97367', '41.76968');
INSERT INTO `hup_region` VALUES (368, 362, '九原', '九原区', '中国,内蒙古自治区,包头市,九原区', 3, 'jiuyuan', '0472', '014060', 'J', '109.96496', '40.60554');
INSERT INTO `hup_region` VALUES (369, 362, '土默特右旗', '土默特右旗', '中国,内蒙古自治区,包头市,土默特右旗', 3, 'tumoteyouqi', '0472', '014100', 'T', '110.52417', '40.5688');
INSERT INTO `hup_region` VALUES (370, 362, '固阳', '固阳县', '中国,内蒙古自治区,包头市,固阳县', 3, 'guyang', '0472', '014200', 'G', '110.06372', '41.01851');
INSERT INTO `hup_region` VALUES (371, 362, '达茂旗', '达尔罕茂明安联合旗', '中国,内蒙古自治区,包头市,达尔罕茂明安联合旗', 3, 'damaoqi', '0472', '014500', 'D', '110.43258', '41.69875');
INSERT INTO `hup_region` VALUES (372, 351, '乌海', '乌海市', '中国,内蒙古自治区,乌海市', 2, 'wuhai', '0473', '016000', 'W', '106.825563', '39.673734');
INSERT INTO `hup_region` VALUES (373, 372, '海勃湾', '海勃湾区', '中国,内蒙古自治区,乌海市,海勃湾区', 3, 'haibowan', '0473', '016000', 'H', '106.8222', '39.66955');
INSERT INTO `hup_region` VALUES (374, 372, '海南', '海南区', '中国,内蒙古自治区,乌海市,海南区', 3, 'hainan', '0473', '016030', 'H', '106.88656', '39.44128');
INSERT INTO `hup_region` VALUES (375, 372, '乌达', '乌达区', '中国,内蒙古自治区,乌海市,乌达区', 3, 'wuda', '0473', '016040', 'W', '106.72723', '39.505');
INSERT INTO `hup_region` VALUES (376, 351, '赤峰', '赤峰市', '中国,内蒙古自治区,赤峰市', 2, 'chifeng', '0476', '024000', 'C', '118.956806', '42.275317');
INSERT INTO `hup_region` VALUES (377, 376, '红山', '红山区', '中国,内蒙古自治区,赤峰市,红山区', 3, 'hongshan', '0476', '024020', 'H', '118.95755', '42.24312');
INSERT INTO `hup_region` VALUES (378, 376, '元宝山', '元宝山区', '中国,内蒙古自治区,赤峰市,元宝山区', 3, 'yuanbaoshan', '0476', '024076', 'Y', '119.28921', '42.04005');
INSERT INTO `hup_region` VALUES (379, 376, '松山', '松山区', '中国,内蒙古自治区,赤峰市,松山区', 3, 'songshan', '0476', '024005', 'S', '118.9328', '42.28613');
INSERT INTO `hup_region` VALUES (380, 376, '阿鲁科尔沁旗', '阿鲁科尔沁旗', '中国,内蒙古自治区,赤峰市,阿鲁科尔沁旗', 3, 'alukeerqinqi', '0476', '025550', 'A', '120.06527', '43.87988');
INSERT INTO `hup_region` VALUES (381, 376, '巴林左旗', '巴林左旗', '中国,内蒙古自治区,赤峰市,巴林左旗', 3, 'balinzuoqi', '0476', '025450', 'B', '119.38012', '43.97031');
INSERT INTO `hup_region` VALUES (382, 376, '巴林右旗', '巴林右旗', '中国,内蒙古自治区,赤峰市,巴林右旗', 3, 'balinyouqi', '0476', '025150', 'B', '118.66461', '43.53387');
INSERT INTO `hup_region` VALUES (383, 376, '林西', '林西县', '中国,内蒙古自治区,赤峰市,林西县', 3, 'linxi', '0476', '025250', 'L', '118.04733', '43.61165');
INSERT INTO `hup_region` VALUES (384, 376, '克什克腾旗', '克什克腾旗', '中国,内蒙古自治区,赤峰市,克什克腾旗', 3, 'keshiketengqi', '0476', '025350', 'K', '117.54562', '43.26501');
INSERT INTO `hup_region` VALUES (385, 376, '翁牛特旗', '翁牛特旗', '中国,内蒙古自治区,赤峰市,翁牛特旗', 3, 'wengniuteqi', '0476', '024500', 'W', '119.03042', '42.93147');
INSERT INTO `hup_region` VALUES (386, 376, '喀喇沁旗', '喀喇沁旗', '中国,内蒙古自治区,赤峰市,喀喇沁旗', 3, 'kalaqinqi', '0476', '024400', 'K', '118.70144', '41.92917');
INSERT INTO `hup_region` VALUES (387, 376, '宁城', '宁城县', '中国,内蒙古自治区,赤峰市,宁城县', 3, 'ningcheng', '0476', '024200', 'N', '119.34375', '41.59661');
INSERT INTO `hup_region` VALUES (388, 376, '敖汉旗', '敖汉旗', '中国,内蒙古自治区,赤峰市,敖汉旗', 3, 'aohanqi', '0476', '024300', 'A', '119.92163', '42.29071');
INSERT INTO `hup_region` VALUES (389, 351, '通辽', '通辽市', '中国,内蒙古自治区,通辽市', 2, 'tongliao', '0475', '028000', 'T', '122.263119', '43.617429');
INSERT INTO `hup_region` VALUES (390, 389, '科尔沁', '科尔沁区', '中国,内蒙古自治区,通辽市,科尔沁区', 3, 'keerqin', '0475', '028000', 'K', '122.25573', '43.62257');
INSERT INTO `hup_region` VALUES (391, 389, '科尔沁左翼中旗', '科尔沁左翼中旗', '中国,内蒙古自治区,通辽市,科尔沁左翼中旗', 3, 'keerqinzuoyizhongqi', '0475', '029300', 'K', '123.31912', '44.13014');
INSERT INTO `hup_region` VALUES (392, 389, '科尔沁左翼后旗', '科尔沁左翼后旗', '中国,内蒙古自治区,通辽市,科尔沁左翼后旗', 3, 'keerqinzuoyihouqi', '0475', '028100', 'K', '122.35745', '42.94897');
INSERT INTO `hup_region` VALUES (393, 389, '开鲁', '开鲁县', '中国,内蒙古自治区,通辽市,开鲁县', 3, 'kailu', '0475', '028400', 'K', '121.31884', '43.60003');
INSERT INTO `hup_region` VALUES (394, 389, '库伦旗', '库伦旗', '中国,内蒙古自治区,通辽市,库伦旗', 3, 'kulunqi', '0475', '028200', 'K', '121.776', '42.72998');
INSERT INTO `hup_region` VALUES (395, 389, '奈曼旗', '奈曼旗', '中国,内蒙古自治区,通辽市,奈曼旗', 3, 'naimanqi', '0475', '028300', 'N', '120.66348', '42.84527');
INSERT INTO `hup_region` VALUES (396, 389, '扎鲁特旗', '扎鲁特旗', '中国,内蒙古自治区,通辽市,扎鲁特旗', 3, 'zhaluteqi', '0475', '029100', 'Z', '120.91507', '44.55592');
INSERT INTO `hup_region` VALUES (397, 389, '霍林郭勒', '霍林郭勒市', '中国,内蒙古自治区,通辽市,霍林郭勒市', 3, 'huolinguole', '0475', '029200', 'H', '119.65429', '45.53454');
INSERT INTO `hup_region` VALUES (398, 351, '鄂尔多斯', '鄂尔多斯市', '中国,内蒙古自治区,鄂尔多斯市', 2, 'ordos', '0477', '017004', 'E', '109.99029', '39.817179');
INSERT INTO `hup_region` VALUES (399, 398, '东胜', '东胜区', '中国,内蒙古自治区,鄂尔多斯市,东胜区', 3, 'dongsheng', '0477', '017000', 'D', '109.96289', '39.82236');
INSERT INTO `hup_region` VALUES (400, 398, '达拉特旗', '达拉特旗', '中国,内蒙古自治区,鄂尔多斯市,达拉特旗', 3, 'dalateqi', '0477', '014300', 'D', '110.03317', '40.4001');
INSERT INTO `hup_region` VALUES (401, 398, '准格尔旗', '准格尔旗', '中国,内蒙古自治区,鄂尔多斯市,准格尔旗', 3, 'zhungeerqi', '0477', '017100', 'Z', '111.23645', '39.86783');
INSERT INTO `hup_region` VALUES (402, 398, '鄂托克前旗', '鄂托克前旗', '中国,内蒙古自治区,鄂尔多斯市,鄂托克前旗', 3, 'etuokeqianqi', '0477', '016200', 'E', '107.48403', '38.18396');
INSERT INTO `hup_region` VALUES (403, 398, '鄂托克旗', '鄂托克旗', '中国,内蒙古自治区,鄂尔多斯市,鄂托克旗', 3, 'etuokeqi', '0477', '016100', 'E', '107.98226', '39.09456');
INSERT INTO `hup_region` VALUES (404, 398, '杭锦旗', '杭锦旗', '中国,内蒙古自治区,鄂尔多斯市,杭锦旗', 3, 'hangjinqi', '0477', '017400', 'H', '108.72934', '39.84023');
INSERT INTO `hup_region` VALUES (405, 398, '乌审旗', '乌审旗', '中国,内蒙古自治区,鄂尔多斯市,乌审旗', 3, 'wushenqi', '0477', '017300', 'W', '108.8461', '38.59092');
INSERT INTO `hup_region` VALUES (406, 398, '伊金霍洛旗', '伊金霍洛旗', '中国,内蒙古自治区,鄂尔多斯市,伊金霍洛旗', 3, 'yijinhuoluoqi', '0477', '017200', 'Y', '109.74908', '39.57393');
INSERT INTO `hup_region` VALUES (407, 351, '呼伦贝尔', '呼伦贝尔市', '中国,内蒙古自治区,呼伦贝尔市', 2, 'hulunber', '0470', '021008', 'H', '119.758168', '49.215333');
INSERT INTO `hup_region` VALUES (408, 407, '海拉尔', '海拉尔区', '中国,内蒙古自治区,呼伦贝尔市,海拉尔区', 3, 'hailaer', '0470', '021000', 'H', '119.7364', '49.2122');
INSERT INTO `hup_region` VALUES (409, 407, '扎赉诺尔', '扎赉诺尔区', '中国,内蒙古自治区,呼伦贝尔市,扎赉诺尔区', 3, 'zhalainuoer', '0470', '021410', 'Z', '117.792702', '49.486943');
INSERT INTO `hup_region` VALUES (410, 407, '阿荣旗', '阿荣旗', '中国,内蒙古自治区,呼伦贝尔市,阿荣旗', 3, 'arongqi', '0470', '162750', 'A', '123.45941', '48.12581');
INSERT INTO `hup_region` VALUES (411, 407, '莫旗', '莫力达瓦达斡尔族自治旗', '中国,内蒙古自治区,呼伦贝尔市,莫力达瓦达斡尔族自治旗', 3, 'moqi', '0470', '162850', 'M', '124.51498', '48.48055');
INSERT INTO `hup_region` VALUES (412, 407, '鄂伦春', '鄂伦春自治旗', '中国,内蒙古自治区,呼伦贝尔市,鄂伦春自治旗', 3, 'elunchun', '0470', '165450', 'E', '123.72604', '50.59777');
INSERT INTO `hup_region` VALUES (413, 407, '鄂温', '鄂温克族自治旗', '中国,内蒙古自治区,呼伦贝尔市,鄂温克族自治旗', 3, 'ewen', '0470', '021100', 'E', '119.7565', '49.14284');
INSERT INTO `hup_region` VALUES (414, 407, '陈巴尔虎旗', '陈巴尔虎旗', '中国,内蒙古自治区,呼伦贝尔市,陈巴尔虎旗', 3, 'chenbaerhuqi', '0470', '021500', 'C', '119.42434', '49.32684');
INSERT INTO `hup_region` VALUES (415, 407, '新巴尔虎左旗', '新巴尔虎左旗', '中国,内蒙古自治区,呼伦贝尔市,新巴尔虎左旗', 3, 'xinbaerhuzuoqi', '0470', '021200', 'X', '118.26989', '48.21842');
INSERT INTO `hup_region` VALUES (416, 407, '新巴尔虎右旗', '新巴尔虎右旗', '中国,内蒙古自治区,呼伦贝尔市,新巴尔虎右旗', 3, 'xinbaerhuyouqi', '0470', '021300', 'X', '116.82366', '48.66473');
INSERT INTO `hup_region` VALUES (417, 407, '满洲里', '满洲里市', '中国,内蒙古自治区,呼伦贝尔市,满洲里市', 3, 'manzhouli', '0470', '021400', 'M', '117.47946', '49.58272');
INSERT INTO `hup_region` VALUES (418, 407, '牙克石', '牙克石市', '中国,内蒙古自治区,呼伦贝尔市,牙克石市', 3, 'yakeshi', '0470', '022150', 'Y', '120.7117', '49.2856');
INSERT INTO `hup_region` VALUES (419, 407, '扎兰屯', '扎兰屯市', '中国,内蒙古自治区,呼伦贝尔市,扎兰屯市', 3, 'zhalantun', '0470', '162650', 'Z', '122.73757', '48.01363');
INSERT INTO `hup_region` VALUES (420, 407, '额尔古纳', '额尔古纳市', '中国,内蒙古自治区,呼伦贝尔市,额尔古纳市', 3, 'eerguna', '0470', '022250', 'E', '120.19094', '50.24249');
INSERT INTO `hup_region` VALUES (421, 407, '根河', '根河市', '中国,内蒙古自治区,呼伦贝尔市,根河市', 3, 'genhe', '0470', '022350', 'G', '121.52197', '50.77996');
INSERT INTO `hup_region` VALUES (422, 351, '巴彦淖尔', '巴彦淖尔市', '中国,内蒙古自治区,巴彦淖尔市', 2, 'bayannur', '0478', '015001', 'B', '107.416959', '40.757402');
INSERT INTO `hup_region` VALUES (423, 422, '临河', '临河区', '中国,内蒙古自治区,巴彦淖尔市,临河区', 3, 'linhe', '0478', '015001', 'L', '107.42668', '40.75827');
INSERT INTO `hup_region` VALUES (424, 422, '五原', '五原县', '中国,内蒙古自治区,巴彦淖尔市,五原县', 3, 'wuyuan', '0478', '015100', 'W', '108.26916', '41.09631');
INSERT INTO `hup_region` VALUES (425, 422, '磴口', '磴口县', '中国,内蒙古自治区,巴彦淖尔市,磴口县', 3, 'dengkou', '0478', '015200', NULL, '107.00936', '40.33062');
INSERT INTO `hup_region` VALUES (426, 422, '乌拉特前旗', '乌拉特前旗', '中国,内蒙古自治区,巴彦淖尔市,乌拉特前旗', 3, 'wulateqianqi', '0478', '014400', 'W', '108.65219', '40.73649');
INSERT INTO `hup_region` VALUES (427, 422, '乌拉特中旗', '乌拉特中旗', '中国,内蒙古自治区,巴彦淖尔市,乌拉特中旗', 3, 'wulatezhongqi', '0478', '015300', 'W', '108.52587', '41.56789');
INSERT INTO `hup_region` VALUES (428, 422, '乌拉特后旗', '乌拉特后旗', '中国,内蒙古自治区,巴彦淖尔市,乌拉特后旗', 3, 'wulatehouqi', '0478', '015500', 'W', '106.98971', '41.43151');
INSERT INTO `hup_region` VALUES (429, 422, '杭锦后旗', '杭锦后旗', '中国,内蒙古自治区,巴彦淖尔市,杭锦后旗', 3, 'hangjinhouqi', '0478', '015400', 'H', '107.15133', '40.88627');
INSERT INTO `hup_region` VALUES (430, 351, '乌兰察布', '乌兰察布市', '中国,内蒙古自治区,乌兰察布市', 2, 'ulanqab', '0474', '012000', 'W', '113.114543', '41.034126');
INSERT INTO `hup_region` VALUES (431, 430, '集宁', '集宁区', '中国,内蒙古自治区,乌兰察布市,集宁区', 3, 'jining', '0474', '012000', 'J', '113.11452', '41.0353');
INSERT INTO `hup_region` VALUES (432, 430, '卓资', '卓资县', '中国,内蒙古自治区,乌兰察布市,卓资县', 3, 'zhuozi', '0474', '012300', 'Z', '112.57757', '40.89414');
INSERT INTO `hup_region` VALUES (433, 430, '化德', '化德县', '中国,内蒙古自治区,乌兰察布市,化德县', 3, 'huade', '0474', '013350', 'H', '114.01071', '41.90433');
INSERT INTO `hup_region` VALUES (434, 430, '商都', '商都县', '中国,内蒙古自治区,乌兰察布市,商都县', 3, 'shangdu', '0474', '013450', 'S', '113.57772', '41.56213');
INSERT INTO `hup_region` VALUES (435, 430, '兴和', '兴和县', '中国,内蒙古自治区,乌兰察布市,兴和县', 3, 'xinghe', '0474', '013650', 'X', '113.83395', '40.87186');
INSERT INTO `hup_region` VALUES (436, 430, '凉城', '凉城县', '中国,内蒙古自治区,乌兰察布市,凉城县', 3, 'liangcheng', '0474', '013750', 'L', '112.49569', '40.53346');
INSERT INTO `hup_region` VALUES (437, 430, '察右前旗', '察哈尔右翼前旗', '中国,内蒙古自治区,乌兰察布市,察哈尔右翼前旗', 3, 'chayouqianqi', '0474', '012200', 'C', '113.22131', '40.7788');
INSERT INTO `hup_region` VALUES (438, 430, '察右中旗', '察哈尔右翼中旗', '中国,内蒙古自治区,乌兰察布市,察哈尔右翼中旗', 3, 'chayouzhongqi', '0474', '013550', 'C', '112.63537', '41.27742');
INSERT INTO `hup_region` VALUES (439, 430, '察右后旗', '察哈尔右翼后旗', '中国,内蒙古自治区,乌兰察布市,察哈尔右翼后旗', 3, 'chayouhouqi', '0474', '012400', 'C', '113.19216', '41.43554');
INSERT INTO `hup_region` VALUES (440, 430, '四子王旗', '四子王旗', '中国,内蒙古自治区,乌兰察布市,四子王旗', 3, 'siziwangqi', '0474', '011800', 'S', '111.70654', '41.53312');
INSERT INTO `hup_region` VALUES (441, 430, '丰镇', '丰镇市', '中国,内蒙古自治区,乌兰察布市,丰镇市', 3, 'fengzhen', '0474', '012100', 'F', '113.10983', '40.4369');
INSERT INTO `hup_region` VALUES (442, 351, '兴安盟', '兴安盟', '中国,内蒙古自治区,兴安盟', 2, 'hinggan', '0482', '137401', 'X', '122.070317', '46.076268');
INSERT INTO `hup_region` VALUES (443, 442, '乌兰浩特', '乌兰浩特市', '中国,内蒙古自治区,兴安盟,乌兰浩特市', 3, 'wulanhaote', '0482', '137401', 'W', '122.06378', '46.06235');
INSERT INTO `hup_region` VALUES (444, 442, '阿尔山', '阿尔山市', '中国,内蒙古自治区,兴安盟,阿尔山市', 3, 'aershan', '0482', '137800', 'A', '119.94317', '47.17716');
INSERT INTO `hup_region` VALUES (445, 442, '科右前旗', '科尔沁右翼前旗', '中国,内蒙古自治区,兴安盟,科尔沁右翼前旗', 3, 'keyouqianqi', '0482', '137423', 'K', '121.95269', '46.0795');
INSERT INTO `hup_region` VALUES (446, 442, '科右中旗', '科尔沁右翼中旗', '中国,内蒙古自治区,兴安盟,科尔沁右翼中旗', 3, 'keyouzhongqi', '0482', '029400', 'K', '121.46807', '45.05605');
INSERT INTO `hup_region` VALUES (447, 442, '扎赉特旗', '扎赉特旗', '中国,内蒙古自治区,兴安盟,扎赉特旗', 3, 'zhalaiteqi', '0482', '137600', 'Z', '122.91229', '46.7267');
INSERT INTO `hup_region` VALUES (448, 442, '突泉', '突泉县', '中国,内蒙古自治区,兴安盟,突泉县', 3, 'tuquan', '0482', '137500', 'T', '121.59396', '45.38187');
INSERT INTO `hup_region` VALUES (449, 351, '锡林郭勒盟', '锡林郭勒盟', '中国,内蒙古自治区,锡林郭勒盟', 2, 'xilingol', '0479', '026000', 'X', '116.090996', '43.944018');
INSERT INTO `hup_region` VALUES (450, 449, '二连浩特', '二连浩特市', '中国,内蒙古自治区,锡林郭勒盟,二连浩特市', 3, 'erlianhaote', '0479', '011100', 'E', '111.98297', '43.65303');
INSERT INTO `hup_region` VALUES (451, 449, '锡林浩特', '锡林浩特市', '中国,内蒙古自治区,锡林郭勒盟,锡林浩特市', 3, 'xilinhaote', '0479', '026021', 'X', '116.08603', '43.93341');
INSERT INTO `hup_region` VALUES (452, 449, '阿巴嘎旗', '阿巴嘎旗', '中国,内蒙古自治区,锡林郭勒盟,阿巴嘎旗', 3, 'abagaqi', '0479', '011400', 'A', '114.96826', '44.02174');
INSERT INTO `hup_region` VALUES (453, 449, '苏尼特左旗', '苏尼特左旗', '中国,内蒙古自治区,锡林郭勒盟,苏尼特左旗', 3, 'sunitezuoqi', '0479', '011300', 'S', '113.6506', '43.85687');
INSERT INTO `hup_region` VALUES (454, 449, '苏尼特右旗', '苏尼特右旗', '中国,内蒙古自治区,锡林郭勒盟,苏尼特右旗', 3, 'suniteyouqi', '0479', '011200', 'S', '112.65741', '42.7469');
INSERT INTO `hup_region` VALUES (455, 449, '东乌旗', '东乌珠穆沁旗', '中国,内蒙古自治区,锡林郭勒盟,东乌珠穆沁旗', 3, 'dongwuqi', '0479', '026300', 'D', '116.97293', '45.51108');
INSERT INTO `hup_region` VALUES (456, 449, '西乌旗', '西乌珠穆沁旗', '中国,内蒙古自治区,锡林郭勒盟,西乌珠穆沁旗', 3, 'xiwuqi', '0479', '026200', 'X', '117.60983', '44.59623');
INSERT INTO `hup_region` VALUES (457, 449, '太仆寺旗', '太仆寺旗', '中国,内蒙古自治区,锡林郭勒盟,太仆寺旗', 3, 'taipusiqi', '0479', '027000', 'T', '115.28302', '41.87727');
INSERT INTO `hup_region` VALUES (458, 449, '镶黄旗', '镶黄旗', '中国,内蒙古自治区,锡林郭勒盟,镶黄旗', 3, 'xianghuangqi', '0479', '013250', 'X', '113.84472', '42.23927');
INSERT INTO `hup_region` VALUES (459, 449, '正镶白旗', '正镶白旗', '中国,内蒙古自治区,锡林郭勒盟,正镶白旗', 3, 'zhengxiangbaiqi', '0479', '013800', 'Z', '115.00067', '42.30712');
INSERT INTO `hup_region` VALUES (460, 449, '正蓝旗', '正蓝旗', '中国,内蒙古自治区,锡林郭勒盟,正蓝旗', 3, 'zhenglanqi', '0479', '027200', 'Z', '116.00363', '42.25229');
INSERT INTO `hup_region` VALUES (461, 449, '多伦', '多伦县', '中国,内蒙古自治区,锡林郭勒盟,多伦县', 3, 'duolun', '0479', '027300', 'D', '116.48565', '42.203');
INSERT INTO `hup_region` VALUES (462, 351, '阿拉善盟', '阿拉善盟', '中国,内蒙古自治区,阿拉善盟', 2, 'alxa', '0483', '750306', 'A', '105.706422', '38.844814');
INSERT INTO `hup_region` VALUES (463, 462, '阿拉善左旗', '阿拉善左旗', '中国,内蒙古自治区,阿拉善盟,阿拉善左旗', 3, 'alashanzuoqi', '0483', '750306', 'A', '105.67532', '38.8293');
INSERT INTO `hup_region` VALUES (464, 462, '阿拉善右旗', '阿拉善右旗', '中国,内蒙古自治区,阿拉善盟,阿拉善右旗', 3, 'alashanyouqi', '0483', '737300', 'A', '101.66705', '39.21533');
INSERT INTO `hup_region` VALUES (465, 462, '额济纳旗', '额济纳旗', '中国,内蒙古自治区,阿拉善盟,额济纳旗', 3, 'ejinaqi', '0483', '735400', 'E', '101.06887', '41.96755');
INSERT INTO `hup_region` VALUES (466, 0, '辽宁', '辽宁省', '中国,辽宁省', 1, 'liaoning', '', '', 'L', '123.429096', '41.796767');
INSERT INTO `hup_region` VALUES (467, 466, '沈阳', '沈阳市', '中国,辽宁省,沈阳市', 2, 'shenyang', '024', '110013', 'S', '123.429096', '41.796767');
INSERT INTO `hup_region` VALUES (468, 467, '和平', '和平区', '中国,辽宁省,沈阳市,和平区', 3, 'heping', '024', '110001', 'H', '123.4204', '41.78997');
INSERT INTO `hup_region` VALUES (469, 467, '沈河', '沈河区', '中国,辽宁省,沈阳市,沈河区', 3, 'shenhe', '024', '110011', 'S', '123.45871', '41.79625');
INSERT INTO `hup_region` VALUES (470, 467, '大东', '大东区', '中国,辽宁省,沈阳市,大东区', 3, 'dadong', '024', '110041', 'D', '123.46997', '41.80539');
INSERT INTO `hup_region` VALUES (471, 467, '皇姑', '皇姑区', '中国,辽宁省,沈阳市,皇姑区', 3, 'huanggu', '024', '110031', 'H', '123.42527', '41.82035');
INSERT INTO `hup_region` VALUES (472, 467, '铁西', '铁西区', '中国,辽宁省,沈阳市,铁西区', 3, 'tiexi', '024', '110021', 'T', '123.37675', '41.80269');
INSERT INTO `hup_region` VALUES (473, 467, '苏家屯', '苏家屯区', '中国,辽宁省,沈阳市,苏家屯区', 3, 'sujiatun', '024', '110101', 'S', '123.34405', '41.66475');
INSERT INTO `hup_region` VALUES (474, 467, '浑南', '浑南区', '中国,辽宁省,沈阳市,浑南区', 3, 'hunnan', '024', '110015', 'H', '123.457707', '41.719450');
INSERT INTO `hup_region` VALUES (475, 467, '沈北新区', '沈北新区', '中国,辽宁省,沈阳市,沈北新区', 3, 'shenbeixinqu', '024', '110121', 'S', '123.52658', '42.05297');
INSERT INTO `hup_region` VALUES (476, 467, '于洪', '于洪区', '中国,辽宁省,沈阳市,于洪区', 3, 'yuhong', '024', '110141', 'Y', '123.30807', '41.794');
INSERT INTO `hup_region` VALUES (477, 467, '辽中', '辽中县', '中国,辽宁省,沈阳市,辽中县', 3, 'liaozhong', '024', '110200', 'L', '122.72659', '41.51302');
INSERT INTO `hup_region` VALUES (478, 467, '康平', '康平县', '中国,辽宁省,沈阳市,康平县', 3, 'kangping', '024', '110500', 'K', '123.35446', '42.75081');
INSERT INTO `hup_region` VALUES (479, 467, '法库', '法库县', '中国,辽宁省,沈阳市,法库县', 3, 'faku', '024', '110400', 'F', '123.41214', '42.50608');
INSERT INTO `hup_region` VALUES (480, 467, '新民', '新民市', '中国,辽宁省,沈阳市,新民市', 3, 'xinmin', '024', '110300', 'X', '122.82867', '41.99847');
INSERT INTO `hup_region` VALUES (481, 466, '大连', '大连市', '中国,辽宁省,大连市', 2, 'dalian', '0411', '116011', 'D', '121.618622', '38.91459');
INSERT INTO `hup_region` VALUES (482, 481, '中山', '中山区', '中国,辽宁省,大连市,中山区', 3, 'zhongshan', '0411', '116001', 'Z', '121.64465', '38.91859');
INSERT INTO `hup_region` VALUES (483, 481, '西岗', '西岗区', '中国,辽宁省,大连市,西岗区', 3, 'xigang', '0411', '116011', 'X', '121.61238', '38.91469');
INSERT INTO `hup_region` VALUES (484, 481, '沙河口', '沙河口区', '中国,辽宁省,大连市,沙河口区', 3, 'shahekou', '0411', '116021', 'S', '121.58017', '38.90536');
INSERT INTO `hup_region` VALUES (485, 481, '甘井子', '甘井子区', '中国,辽宁省,大连市,甘井子区', 3, 'ganjingzi', '0411', '116033', 'G', '121.56567', '38.95017');
INSERT INTO `hup_region` VALUES (486, 481, '旅顺口', '旅顺口区', '中国,辽宁省,大连市,旅顺口区', 3, 'lvshunkou', '0411', '116041', 'L', '121.26202', '38.85125');
INSERT INTO `hup_region` VALUES (487, 481, '金州', '金州区', '中国,辽宁省,大连市,金州区', 3, 'jinzhou', '0411', '116100', 'J', '121.71893', '39.1004');
INSERT INTO `hup_region` VALUES (488, 481, '长海', '长海县', '中国,辽宁省,大连市,长海县', 3, 'changhai', '0411', '116500', 'C', '122.58859', '39.27274');
INSERT INTO `hup_region` VALUES (489, 481, '瓦房店', '瓦房店市', '中国,辽宁省,大连市,瓦房店市', 3, 'wafangdian', '0411', '116300', 'W', '121.98104', '39.62843');
INSERT INTO `hup_region` VALUES (490, 481, '普兰店', '普兰店市', '中国,辽宁省,大连市,普兰店市', 3, 'pulandian', '0411', '116200', 'P', '121.96316', '39.39465');
INSERT INTO `hup_region` VALUES (491, 481, '庄河', '庄河市', '中国,辽宁省,大连市,庄河市', 3, 'zhuanghe', '0411', '116400', 'Z', '122.96725', '39.68815');
INSERT INTO `hup_region` VALUES (492, 466, '鞍山', '鞍山市', '中国,辽宁省,鞍山市', 2, 'anshan', '0412', '114001', 'A', '122.995632', '41.110626');
INSERT INTO `hup_region` VALUES (493, 492, '铁东', '铁东区', '中国,辽宁省,鞍山市,铁东区', 3, 'tiedong', '0412', '114001', 'T', '122.99085', '41.08975');
INSERT INTO `hup_region` VALUES (494, 492, '铁西', '铁西区', '中国,辽宁省,鞍山市,铁西区', 3, 'tiexi', '0413', '114013', 'T', '122.96967', '41.11977');
INSERT INTO `hup_region` VALUES (495, 492, '立山', '立山区', '中国,辽宁省,鞍山市,立山区', 3, 'lishan', '0414', '114031', 'L', '123.02948', '41.15008');
INSERT INTO `hup_region` VALUES (496, 492, '千山', '千山区', '中国,辽宁省,鞍山市,千山区', 3, 'qianshan', '0415', '114041', 'Q', '122.96048', '41.07507');
INSERT INTO `hup_region` VALUES (497, 492, '台安', '台安县', '中国,辽宁省,鞍山市,台安县', 3, 'tai\'an', '0417', '114100', 'T', '122.43585', '41.41265');
INSERT INTO `hup_region` VALUES (498, 492, '岫岩', '岫岩满族自治县', '中国,辽宁省,鞍山市,岫岩满族自治县', 3, 'xiuyan', '0418', '114300', NULL, '123.28875', '40.27996');
INSERT INTO `hup_region` VALUES (499, 492, '海城', '海城市', '中国,辽宁省,鞍山市,海城市', 3, 'haicheng', '0416', '114200', 'H', '122.68457', '40.88142');
INSERT INTO `hup_region` VALUES (500, 466, '抚顺', '抚顺市', '中国,辽宁省,抚顺市', 2, 'fushun', '024', '113008', 'F', '123.921109', '41.875956');
INSERT INTO `hup_region` VALUES (501, 500, '新抚', '新抚区', '中国,辽宁省,抚顺市,新抚区', 3, 'xinfu', '024', '113008', 'X', '123.91264', '41.86205');
INSERT INTO `hup_region` VALUES (502, 500, '东洲', '东洲区', '中国,辽宁省,抚顺市,东洲区', 3, 'dongzhou', '024', '113003', 'D', '124.03759', '41.8519');
INSERT INTO `hup_region` VALUES (503, 500, '望花', '望花区', '中国,辽宁省,抚顺市,望花区', 3, 'wanghua', '024', '113001', 'W', '123.78283', '41.85532');
INSERT INTO `hup_region` VALUES (504, 500, '顺城', '顺城区', '中国,辽宁省,抚顺市,顺城区', 3, 'shuncheng', '024', '113006', 'S', '123.94506', '41.88321');
INSERT INTO `hup_region` VALUES (505, 500, '抚顺', '抚顺县', '中国,辽宁省,抚顺市,抚顺县', 3, 'fushun', '024', '113006', 'F', '124.17755', '41.71217');
INSERT INTO `hup_region` VALUES (506, 500, '新宾', '新宾满族自治县', '中国,辽宁省,抚顺市,新宾满族自治县', 3, 'xinbin', '024', '113200', 'X', '125.04049', '41.73409');
INSERT INTO `hup_region` VALUES (507, 500, '清原', '清原满族自治县', '中国,辽宁省,抚顺市,清原满族自治县', 3, 'qingyuan', '024', '113300', 'Q', '124.92807', '42.10221');
INSERT INTO `hup_region` VALUES (508, 466, '本溪', '本溪市', '中国,辽宁省,本溪市', 2, 'benxi', '0414', '117000', 'B', '123.770519', '41.297909');
INSERT INTO `hup_region` VALUES (509, 508, '平山', '平山区', '中国,辽宁省,本溪市,平山区', 3, 'pingshan', '0414', '117000', 'P', '123.76892', '41.2997');
INSERT INTO `hup_region` VALUES (510, 508, '溪湖', '溪湖区', '中国,辽宁省,本溪市,溪湖区', 3, 'xihu', '0414', '117002', 'X', '123.76764', '41.32921');
INSERT INTO `hup_region` VALUES (511, 508, '明山', '明山区', '中国,辽宁省,本溪市,明山区', 3, 'mingshan', '0414', '117021', 'M', '123.81746', '41.30827');
INSERT INTO `hup_region` VALUES (512, 508, '南芬', '南芬区', '中国,辽宁省,本溪市,南芬区', 3, 'nanfen', '0414', '117014', 'N', '123.74523', '41.1006');
INSERT INTO `hup_region` VALUES (513, 508, '本溪', '本溪满族自治县', '中国,辽宁省,本溪市,本溪满族自治县', 3, 'benxi', '0414', '117100', 'B', '124.12741', '41.30059');
INSERT INTO `hup_region` VALUES (514, 508, '桓仁', '桓仁满族自治县', '中国,辽宁省,本溪市,桓仁满族自治县', 3, 'huanren', '0414', '117200', 'H', '125.36062', '41.26798');
INSERT INTO `hup_region` VALUES (515, 466, '丹东', '丹东市', '中国,辽宁省,丹东市', 2, 'dandong', '0415', '118000', 'D', '124.383044', '40.124296');
INSERT INTO `hup_region` VALUES (516, 515, '元宝', '元宝区', '中国,辽宁省,丹东市,元宝区', 3, 'yuanbao', '0415', '118000', 'Y', '124.39575', '40.13651');
INSERT INTO `hup_region` VALUES (517, 515, '振兴', '振兴区', '中国,辽宁省,丹东市,振兴区', 3, 'zhenxing', '0415', '118002', 'Z', '124.36035', '40.10489');
INSERT INTO `hup_region` VALUES (518, 515, '振安', '振安区', '中国,辽宁省,丹东市,振安区', 3, 'zhen\'an', '0415', '118001', 'Z', '124.42816', '40.15826');
INSERT INTO `hup_region` VALUES (519, 515, '宽甸', '宽甸满族自治县', '中国,辽宁省,丹东市,宽甸满族自治县', 3, 'kuandian', '0415', '118200', 'K', '124.78247', '40.73187');
INSERT INTO `hup_region` VALUES (520, 515, '东港', '东港市', '中国,辽宁省,丹东市,东港市', 3, 'donggang', '0415', '118300', 'D', '124.16287', '39.86256');
INSERT INTO `hup_region` VALUES (521, 515, '凤城', '凤城市', '中国,辽宁省,丹东市,凤城市', 3, 'fengcheng', '0415', '118100', 'F', '124.06671', '40.45302');
INSERT INTO `hup_region` VALUES (522, 466, '锦州', '锦州市', '中国,辽宁省,锦州市', 2, 'jinzhou', '0416', '121000', 'J', '121.135742', '41.119269');
INSERT INTO `hup_region` VALUES (523, 522, '古塔', '古塔区', '中国,辽宁省,锦州市,古塔区', 3, 'guta', '0416', '121001', 'G', '121.12832', '41.11725');
INSERT INTO `hup_region` VALUES (524, 522, '凌河', '凌河区', '中国,辽宁省,锦州市,凌河区', 3, 'linghe', '0416', '121000', 'L', '121.15089', '41.11496');
INSERT INTO `hup_region` VALUES (525, 522, '太和', '太和区', '中国,辽宁省,锦州市,太和区', 3, 'taihe', '0416', '121011', 'T', '121.10354', '41.10929');
INSERT INTO `hup_region` VALUES (526, 522, '黑山', '黑山县', '中国,辽宁省,锦州市,黑山县', 3, 'heishan', '0416', '121400', 'H', '122.12081', '41.69417');
INSERT INTO `hup_region` VALUES (527, 522, '义县', '义县', '中国,辽宁省,锦州市,义县', 3, 'yixian', '0416', '121100', 'Y', '121.24035', '41.53458');
INSERT INTO `hup_region` VALUES (528, 522, '凌海', '凌海市', '中国,辽宁省,锦州市,凌海市', 3, 'linghai', '0416', '121200', 'L', '121.35705', '41.1737');
INSERT INTO `hup_region` VALUES (529, 522, '北镇', '北镇市', '中国,辽宁省,锦州市,北镇市', 3, 'beizhen', '0416', '121300', 'B', '121.79858', '41.59537');
INSERT INTO `hup_region` VALUES (530, 466, '营口', '营口市', '中国,辽宁省,营口市', 2, 'yingkou', '0417', '115003', 'Y', '122.235151', '40.667432');
INSERT INTO `hup_region` VALUES (531, 530, '站前', '站前区', '中国,辽宁省,营口市,站前区', 3, 'zhanqian', '0417', '115002', 'Z', '122.25896', '40.67266');
INSERT INTO `hup_region` VALUES (532, 530, '西市', '西市区', '中国,辽宁省,营口市,西市区', 3, 'xishi', '0417', '115004', 'X', '122.20641', '40.6664');
INSERT INTO `hup_region` VALUES (533, 530, '鲅鱼圈', '鲅鱼圈区', '中国,辽宁省,营口市,鲅鱼圈区', 3, 'bayuquan', '0417', '115007', NULL, '122.13266', '40.26865');
INSERT INTO `hup_region` VALUES (534, 530, '老边', '老边区', '中国,辽宁省,营口市,老边区', 3, 'laobian', '0417', '115005', 'L', '122.37996', '40.6803');
INSERT INTO `hup_region` VALUES (535, 530, '盖州', '盖州市', '中国,辽宁省,营口市,盖州市', 3, 'gaizhou', '0417', '115200', 'G', '122.35464', '40.40446');
INSERT INTO `hup_region` VALUES (536, 530, '大石桥', '大石桥市', '中国,辽宁省,营口市,大石桥市', 3, 'dashiqiao', '0417', '115100', 'D', '122.50927', '40.64567');
INSERT INTO `hup_region` VALUES (537, 466, '阜新', '阜新市', '中国,辽宁省,阜新市', 2, 'fuxin', '0418', '123000', 'F', '121.648962', '42.011796');
INSERT INTO `hup_region` VALUES (538, 537, '海州', '海州区', '中国,辽宁省,阜新市,海州区', 3, 'haizhou', '0418', '123000', 'H', '121.65626', '42.01336');
INSERT INTO `hup_region` VALUES (539, 537, '新邱', '新邱区', '中国,辽宁省,阜新市,新邱区', 3, 'xinqiu', '0418', '123005', 'X', '121.79251', '42.09181');
INSERT INTO `hup_region` VALUES (540, 537, '太平', '太平区', '中国,辽宁省,阜新市,太平区', 3, 'taiping', '0418', '123003', 'T', '121.67865', '42.01065');
INSERT INTO `hup_region` VALUES (541, 537, '清河门', '清河门区', '中国,辽宁省,阜新市,清河门区', 3, 'qinghemen', '0418', '123006', 'Q', '121.4161', '41.78309');
INSERT INTO `hup_region` VALUES (542, 537, '细河', '细河区', '中国,辽宁省,阜新市,细河区', 3, 'xihe', '0418', '123000', 'X', '121.68013', '42.02533');
INSERT INTO `hup_region` VALUES (543, 537, '阜新', '阜新蒙古族自治县', '中国,辽宁省,阜新市,阜新蒙古族自治县', 3, 'fuxin', '0418', '123100', 'F', '121.75787', '42.0651');
INSERT INTO `hup_region` VALUES (544, 537, '彰武', '彰武县', '中国,辽宁省,阜新市,彰武县', 3, 'zhangwu', '0418', '123200', 'Z', '122.54022', '42.38625');
INSERT INTO `hup_region` VALUES (545, 466, '辽阳', '辽阳市', '中国,辽宁省,辽阳市', 2, 'liaoyang', '0419', '111000', 'L', '123.18152', '41.269402');
INSERT INTO `hup_region` VALUES (546, 545, '白塔', '白塔区', '中国,辽宁省,辽阳市,白塔区', 3, 'baita', '0419', '111000', 'B', '123.1747', '41.27025');
INSERT INTO `hup_region` VALUES (547, 545, '文圣', '文圣区', '中国,辽宁省,辽阳市,文圣区', 3, 'wensheng', '0419', '111000', 'W', '123.18521', '41.26267');
INSERT INTO `hup_region` VALUES (548, 545, '宏伟', '宏伟区', '中国,辽宁省,辽阳市,宏伟区', 3, 'hongwei', '0419', '111003', 'H', '123.1929', '41.21852');
INSERT INTO `hup_region` VALUES (549, 545, '弓长岭', '弓长岭区', '中国,辽宁省,辽阳市,弓长岭区', 3, 'gongchangling', '0419', '111008', 'G', '123.41963', '41.15181');
INSERT INTO `hup_region` VALUES (550, 545, '太子河', '太子河区', '中国,辽宁省,辽阳市,太子河区', 3, 'taizihe', '0419', '111000', 'T', '123.18182', '41.25337');
INSERT INTO `hup_region` VALUES (551, 545, '辽阳', '辽阳县', '中国,辽宁省,辽阳市,辽阳县', 3, 'liaoyang', '0419', '111200', 'L', '123.10574', '41.20542');
INSERT INTO `hup_region` VALUES (552, 545, '灯塔', '灯塔市', '中国,辽宁省,辽阳市,灯塔市', 3, 'dengta', '0419', '111300', 'D', '123.33926', '41.42612');
INSERT INTO `hup_region` VALUES (553, 466, '盘锦', '盘锦市', '中国,辽宁省,盘锦市', 2, 'panjin', '0427', '124010', 'P', '122.06957', '41.124484');
INSERT INTO `hup_region` VALUES (554, 553, '双台子', '双台子区', '中国,辽宁省,盘锦市,双台子区', 3, 'shuangtaizi', '0427', '124000', 'S', '122.06011', '41.1906');
INSERT INTO `hup_region` VALUES (555, 553, '兴隆台', '兴隆台区', '中国,辽宁省,盘锦市,兴隆台区', 3, 'xinglongtai', '0427', '124010', 'X', '122.07529', '41.12402');
INSERT INTO `hup_region` VALUES (556, 553, '大洼', '大洼县', '中国,辽宁省,盘锦市,大洼县', 3, 'dawa', '0427', '124200', 'D', '122.08239', '41.00244');
INSERT INTO `hup_region` VALUES (557, 553, '盘山', '盘山县', '中国,辽宁省,盘锦市,盘山县', 3, 'panshan', '0427', '124000', 'P', '121.99777', '41.23805');
INSERT INTO `hup_region` VALUES (558, 466, '铁岭', '铁岭市', '中国,辽宁省,铁岭市', 2, 'tieling', '024', '112000', 'T', '123.844279', '42.290585');
INSERT INTO `hup_region` VALUES (559, 558, '银州', '银州区', '中国,辽宁省,铁岭市,银州区', 3, 'yinzhou', '024', '112000', 'Y', '123.8573', '42.29507');
INSERT INTO `hup_region` VALUES (560, 558, '清河', '清河区', '中国,辽宁省,铁岭市,清河区', 3, 'qinghe', '024', '112003', 'Q', '124.15911', '42.54679');
INSERT INTO `hup_region` VALUES (561, 558, '铁岭', '铁岭县', '中国,辽宁省,铁岭市,铁岭县', 3, 'tieling', '024', '112000', 'T', '123.77325', '42.22498');
INSERT INTO `hup_region` VALUES (562, 558, '西丰', '西丰县', '中国,辽宁省,铁岭市,西丰县', 3, 'xifeng', '024', '112400', 'X', '124.7304', '42.73756');
INSERT INTO `hup_region` VALUES (563, 558, '昌图', '昌图县', '中国,辽宁省,铁岭市,昌图县', 3, 'changtu', '024', '112500', 'C', '124.11206', '42.78428');
INSERT INTO `hup_region` VALUES (564, 558, '调兵山', '调兵山市', '中国,辽宁省,铁岭市,调兵山市', 3, 'diaobingshan', '024', '112700', 'D', '123.56689', '42.4675');
INSERT INTO `hup_region` VALUES (565, 558, '开原', '开原市', '中国,辽宁省,铁岭市,开原市', 3, 'kaiyuan', '024', '112300', 'K', '124.03945', '42.54585');
INSERT INTO `hup_region` VALUES (566, 466, '朝阳', '朝阳市', '中国,辽宁省,朝阳市', 2, 'chaoyang', '0421', '122000', 'C', '120.451176', '41.576758');
INSERT INTO `hup_region` VALUES (567, 566, '双塔', '双塔区', '中国,辽宁省,朝阳市,双塔区', 3, 'shuangta', '0421', '122000', 'S', '120.45385', '41.566');
INSERT INTO `hup_region` VALUES (568, 566, '龙城', '龙城区', '中国,辽宁省,朝阳市,龙城区', 3, 'longcheng', '0421', '122000', 'L', '120.43719', '41.59264');
INSERT INTO `hup_region` VALUES (569, 566, '朝阳', '朝阳县', '中国,辽宁省,朝阳市,朝阳县', 3, 'chaoyang', '0421', '122000', 'C', '120.17401', '41.4324');
INSERT INTO `hup_region` VALUES (570, 566, '建平', '建平县', '中国,辽宁省,朝阳市,建平县', 3, 'jianping', '0421', '122400', 'J', '119.64392', '41.40315');
INSERT INTO `hup_region` VALUES (571, 566, '喀喇沁左翼', '喀喇沁左翼蒙古族自治县', '中国,辽宁省,朝阳市,喀喇沁左翼蒙古族自治县', 3, 'kalaqinzuoyi', '0421', '122300', 'K', '119.74185', '41.12801');
INSERT INTO `hup_region` VALUES (572, 566, '北票', '北票市', '中国,辽宁省,朝阳市,北票市', 3, 'beipiao', '0421', '122100', 'B', '120.76977', '41.80196');
INSERT INTO `hup_region` VALUES (573, 566, '凌源', '凌源市', '中国,辽宁省,朝阳市,凌源市', 3, 'lingyuan', '0421', '122500', 'L', '119.40148', '41.24558');
INSERT INTO `hup_region` VALUES (574, 466, '葫芦岛', '葫芦岛市', '中国,辽宁省,葫芦岛市', 2, 'huludao', '0429', '125000', 'H', '120.856394', '40.755572');
INSERT INTO `hup_region` VALUES (575, 574, '连山', '连山区', '中国,辽宁省,葫芦岛市,连山区', 3, 'lianshan', '0429', '125001', 'L', '120.86393', '40.75554');
INSERT INTO `hup_region` VALUES (576, 574, '龙港', '龙港区', '中国,辽宁省,葫芦岛市,龙港区', 3, 'longgang', '0429', '125003', 'L', '120.94866', '40.71919');
INSERT INTO `hup_region` VALUES (577, 574, '南票', '南票区', '中国,辽宁省,葫芦岛市,南票区', 3, 'nanpiao', '0429', '125027', 'N', '120.74978', '41.10707');
INSERT INTO `hup_region` VALUES (578, 574, '绥中', '绥中县', '中国,辽宁省,葫芦岛市,绥中县', 3, 'suizhong', '0429', '125200', 'S', '120.34451', '40.32552');
INSERT INTO `hup_region` VALUES (579, 574, '建昌', '建昌县', '中国,辽宁省,葫芦岛市,建昌县', 3, 'jianchang', '0429', '125300', 'J', '119.8377', '40.82448');
INSERT INTO `hup_region` VALUES (580, 574, '兴城', '兴城市', '中国,辽宁省,葫芦岛市,兴城市', 3, 'xingcheng', '0429', '125100', 'X', '120.72537', '40.61492');
INSERT INTO `hup_region` VALUES (581, 466, '金普新区', '金普新区', '中国,辽宁省,金普新区', 2, 'jinpuxinqu', '0411', '116100', 'J', '121.789627', '39.055451');
INSERT INTO `hup_region` VALUES (582, 581, '金州新区', '金州新区', '中国,辽宁省,金普新区,金州新区', 3, 'jinzhouxinqu', '0411', '116100', 'J', '121.784821', '39.052252');
INSERT INTO `hup_region` VALUES (583, 581, '普湾新区', '普湾新区', '中国,辽宁省,金普新区,普湾新区', 3, 'puwanxinqu', '0411', '116200', 'P', '121.812812', '39.330093');
INSERT INTO `hup_region` VALUES (584, 581, '保税区', '保税区', '中国,辽宁省,金普新区,保税区', 3, 'baoshuiqu', '0411', '116100', 'B', '121.94289', '39.224614');
INSERT INTO `hup_region` VALUES (585, 0, '吉林', '吉林省', '中国,吉林省', 1, 'jilin', '', '', 'J', '125.3245', '43.886841');
INSERT INTO `hup_region` VALUES (586, 585, '长春', '长春市', '中国,吉林省,长春市', 2, 'changchun', '0431', '130022', 'C', '125.3245', '43.886841');
INSERT INTO `hup_region` VALUES (587, 586, '南关', '南关区', '中国,吉林省,长春市,南关区', 3, 'nanguan', '0431', '130022', 'N', '125.35035', '43.86401');
INSERT INTO `hup_region` VALUES (588, 586, '宽城', '宽城区', '中国,吉林省,长春市,宽城区', 3, 'kuancheng', '0431', '130051', 'K', '125.32635', '43.90182');
INSERT INTO `hup_region` VALUES (589, 586, '朝阳', '朝阳区', '中国,吉林省,长春市,朝阳区', 3, 'chaoyang', '0431', '130012', 'C', '125.2883', '43.83339');
INSERT INTO `hup_region` VALUES (590, 586, '二道', '二道区', '中国,吉林省,长春市,二道区', 3, 'erdao', '0431', '130031', 'E', '125.37429', '43.86501');
INSERT INTO `hup_region` VALUES (591, 586, '绿园', '绿园区', '中国,吉林省,长春市,绿园区', 3, 'lvyuan', '0431', '130062', 'L', '125.25582', '43.88045');
INSERT INTO `hup_region` VALUES (592, 586, '双阳', '双阳区', '中国,吉林省,长春市,双阳区', 3, 'shuangyang', '0431', '130600', 'S', '125.65631', '43.52803');
INSERT INTO `hup_region` VALUES (593, 586, '九台', '九台区', '中国,吉林省,长春市,九台区', 3, 'jiutai', '0431', '130500', 'J', '125.8395', '44.15163');
INSERT INTO `hup_region` VALUES (594, 586, '农安', '农安县', '中国,吉林省,长春市,农安县', 3, 'nong\'an', '0431', '130200', 'N', '125.18481', '44.43265');
INSERT INTO `hup_region` VALUES (595, 586, '榆树', '榆树市', '中国,吉林省,长春市,榆树市', 3, 'yushu', '0431', '130400', 'Y', '126.55688', '44.82523');
INSERT INTO `hup_region` VALUES (596, 586, '德惠', '德惠市', '中国,吉林省,长春市,德惠市', 3, 'dehui', '0431', '130300', 'D', '125.70538', '44.53719');
INSERT INTO `hup_region` VALUES (597, 585, '吉林', '吉林市', '中国,吉林省,吉林市', 2, 'jilin', '0432', '132011', 'J', '126.55302', '43.843577');
INSERT INTO `hup_region` VALUES (598, 597, '昌邑', '昌邑区', '中国,吉林省,吉林市,昌邑区', 3, 'changyi', '0432', '132002', 'C', '126.57424', '43.88183');
INSERT INTO `hup_region` VALUES (599, 597, '龙潭', '龙潭区', '中国,吉林省,吉林市,龙潭区', 3, 'longtan', '0432', '132021', 'L', '126.56213', '43.91054');
INSERT INTO `hup_region` VALUES (600, 597, '船营', '船营区', '中国,吉林省,吉林市,船营区', 3, 'chuanying', '0432', '132011', 'C', '126.54096', '43.83344');
INSERT INTO `hup_region` VALUES (601, 597, '丰满', '丰满区', '中国,吉林省,吉林市,丰满区', 3, 'fengman', '0432', '132013', 'F', '126.56237', '43.82236');
INSERT INTO `hup_region` VALUES (602, 597, '永吉', '永吉县', '中国,吉林省,吉林市,永吉县', 3, 'yongji', '0432', '132200', 'Y', '126.4963', '43.67197');
INSERT INTO `hup_region` VALUES (603, 597, '蛟河', '蛟河市', '中国,吉林省,吉林市,蛟河市', 3, 'jiaohe', '0432', '132500', NULL, '127.34426', '43.72696');

mysql省市区表-2
https://blog.csdn.net/weixin_42998455/article/details/133635990

mysql省市区表-3
https://blog.csdn.net/weixin_42998455/article/details/133636248

mysql省市区表-4
https://blog.csdn.net/weixin_42998455/article/details/133636301

mysql省市区表-5
https://blog.csdn.net/weixin_42998455/article/details/133636352

mysql省市区表-6
https://blog.csdn.net/weixin_42998455/article/details/133636374

sql完整压缩包