Mysql我国省市区字典数据

业务背景：几乎每家公司都需要一套针对全国省市的字典数据。有些数据分为三个表，有些数据不是很完整。他们整理了一个省、市、一个表的数据供备用。

数据库表结构：

CREATE TABLE `dic_area` (  `AREA_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',  `AREA_NAME` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 区域名称，  `PID` int(11) NOT NULL COMMENT '父id',  `AREA_STATE` tinyint(2) NOT NULL DEFAULT 1 COMMENT 记录状态：0代表不可用 有些没有审核，或者编辑在不可用的时候会处于这种状态，1代表可用性 ,2代表删除 删除后编辑后台state置为2',  `AREA_REMARK` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',  PRIMARY KEY (`AREA_ID`) USING BTREE,  INDEX `index_pid`(`PID`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 省市区县区域字典表 ROW_FORMAT = Dynamic;  -- 初始化sql INSERT INTO `dic_area` VALUES (1, '北京', 0, 1, NULL); INSERT INTO `dic_area` VALUES (2, 北京市， 1, 1, NULL); INSERT INTO `dic_area` VALUES (3, 东城区， 2, 1, NULL); INSERT INTO `dic_area` VALUES (4, 西城区， 2, 1, NULL); INSERT INTO `dic_area` VALUES (5, 崇文区， 2, 1, NULL); INSERT INTO `dic_area` VALUES (6, 宣武区， 2, 1, NULL); INSERT INTO `dic_area` VALUES (7, 朝阳区， 2, 1, NULL); INSERT INTO `dic_area` VALUES (8, 丰台区， 2, 1, NULL); INSERT INTO `dic_area` VALUES (9, 石景山区， 2, 1, NULL); INSERT INTO `dic_area` VALUES (10, 海淀区， 2, 1, NULL); INSERT INTO `dic_area` VALUES (11, '门头沟区', 2, 1, NULL); INSERT INTO `dic_area` VALUES (12, 房山区， 2, 1, NULL); INSERT INTO `dic_area` VALUES (13, 通州区， 2, 1, NULL); INSERT INTO `dic_area` VALUES (14, 顺义区， 2, 1, NULL); INSERT INTO `dic_area` VALUES (15, 昌平区， 2, 1, NULL); INSERT INTO `dic_area` VALUES (16, 大兴区， 2, 1, NULL); INSERT INTO `dic_area` VALUES (17, 怀柔区， 2, 1, NULL); INSERT INTO `dic_area` VALUES (18, 平谷区， 2, 1, NULL); INSERT INTO `dic_area` VALUES (19, 密云县， 2, 1, NULL); INSERT INTO `dic_area` VALUES (20, 延庆县， 2, 1, NULL); INSERT INTO `dic_area` VALUES (21, '天津', 0, 1, NULL); INSERT INTO `dic_area` VALUES (22, 天津市， 21, 1, NULL); INSERT INTO `dic_area` VALUES (23, 和平区， 22, 1, NULL); INSERT INTO `dic_area` VALUES (24, 河东区， 22, 1, NULL); INSERT INTO `dic_area` VALUES (25, 河西区， 22, 1, NULL); INSERT INTO `dic_area` VALUES (26, 南开区， 22, 1, NULL); INSERT INTO `dic_area` VALUES (27, 河北区， 22, 1, NULL); INSERT INTO `dic_area` VALUES (28, 红桥区， 22, 1, NULL); INSERT INTO `dic_area` VALUES (29, 塘沽区， 22, 1, NULL); INSERT INTO `dic_area` VALUES (30, 汉沽区， 22, 1, NULL); INSERT INTO `dic_area` VALUES (31, '大港区', 22, 1, NULL); INSERT INTO `dic_area` VALUES (32, 东丽区， 22, 1, NULL); INSERT INTO `dic_area` VALUES (33, 西青区， 22, 1, NULL); INSERT INTO `dic_area` VALUES (34, 津南区， 22, 1, NULL); INSERT INTO `dic_area` VALUES (35, 北辰区， 22, 1, NULL); INSERT INTO `dic_area` VALUES (36, 武清区， 22, 1, NULL); INSERT INTO `dic_area` VALUES (37, 宝坻区， 22, 1, NULL); INSERT INTO `dic_area` VALUES (38, 静海县， 22, 1, NULL); INSERT INTO `dic_area` VALUES (39, '蓟县', 22, 1, NULL); INSERT INTO `dic_area` VALUES (40, '上海', 0, 1, NULL); INSERT INTO `dic_area` VALUES (41, 上海市， 40, 1, NULL); INSERT INTO `dic_area` VALUES (42, 黄浦区， 41, 1, NULL); INSERT INTO `dic_area` VALUES (43, 卢湾区， 41, 1, NULL); INSERT INTO `dic_area` VALUES (44, 徐汇区， 41, 1, NULL); INSERT INTO `dic_area` VALUES (45, 长宁区， 41, 1, NULL); INSERT INTO `dic_area` VALUES (46, 静安区， 41, 1, NULL); INSERT INTO `dic_area` VALUES (47, 普陀区， 41, 1, NULL); INSERT INTO `dic_area` VALUES (48, 闸北区， 41, 1, NULL); INSERT INTO `dic_area` VALUES (49, 虹口区， 41, 1, NULL); INSERT INTO `dic_area` VALUES (50, 杨浦区， 41, 1, NULL); INSERT INTO `dic_area` VALUES (51, 闵行区， 41, 1, NULL); INSERT INTO `dic_area` VALUES (52, 宝山区， 41, 1, NULL); INSERT INTO `dic_area` VALUES (53, 嘉定区， 41, 1, NULL); INSERT INTO `dic_area` VALUES (54, 浦东新区， 41, 1, NULL); INSERT INTO `dic_area` VALUES (55, 金山区， 41, 1, NULL); INSERT INTO `dic_area` VALUES (56, 松江区， 41, 1, NULL); INSERT INTO `dic_area` VALUES (57, 青浦区， 41, 1, NULL); INSERT INTO `dic_area` VALUES (58, 南汇区， 41, 1, NULL); INSERT INTO `dic_area` VALUES (59, 奉贤区， 41, 1, NULL); INSERT INTO `dic_area` VALUES (60, 崇明县， 41, 1, NULL); INSERT INTO `dic_area` VALUES (61, '重庆', 0, 1, NULL); INSERT INTO `dic_area` VALUES (62, 重庆市， 61, 1, NULL); INSERT INTO `dic_area` VALUES (63, 万州区， 62, 1, NULL); INSERT INTO `dic_area` VALUES (64, 涪陵区， 62, 1, NULL); INSERT INTO `dic_area` VALUES (65,  62, 1, NULL); INSERT INTO `dic_area` VALUES (66, 大渡口区， 62, 1, NULL); INSERT INTO `dic_area` VALUES (67, 江北区， 62, 1, NULL); INSERT INTO `dic_area` VALUES (68, 沙坪坝区， 62, 1, NULL); INSERT INTO `dic_area` VALUES (69, 九龙坡区， 62, 1, NULL); INSERT INTO `dic_area` VALUES (70, '南岸区', 62, 1, NULL); INSERT INTO `dic_area` VALUES (71, 北碚区， 62, 1, NULL); INSERT INTO `dic_area` VALUES (72, 万盛区， 62, 1, NULL); INSERT INTO `dic_area` VALUES (73, 双桥区， 62, 1 NULL);
INSERT INTO `dic_area` VALUES (74, '渝北区', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (75, '巴南区', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (76, '黔江区', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (77, '长寿区', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (78, '潼南县', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (79, '铜梁县', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (80, '大足县', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (81, '荣昌县', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (82, '璧山县', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (83, '梁平县', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (84, '城口县', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (85, '丰都县', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (86, '垫江县', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (87, '武隆县', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (88, '忠县', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (89, '开县', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (90, '云阳县', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (91, '奉节县', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (92, '巫山县', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (93, '巫溪县', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (94, '石柱土家族自治县', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (95, '秀山土家族苗族自治县', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (96, '酉阳土家族苗族自治县', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (97, '彭水苗族土家族自治县', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (98, '江津市', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (99, '合川市', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (100, '永川市', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (101, '南川市', 62, 1, NULL);
INSERT INTO `dic_area` VALUES (102, '河北省', 0, 1, NULL);
INSERT INTO `dic_area` VALUES (103, '石家庄', 102, 1, NULL);
INSERT INTO `dic_area` VALUES (104, '市辖区', 103, 1, NULL);
INSERT INTO `dic_area` VALUES (105, '长安区', 103, 1, NULL);
INSERT INTO `dic_area` VALUES (106, '桥东区', 103, 1, NULL);
INSERT INTO `dic_area` VALUES (107, '桥西区', 103, 1, NULL);
INSERT INTO `dic_area` VALUES (108, '新华区', 103, 1, NULL);
INSERT INTO `dic_area` VALUES (109, '井陉矿区', 103, 1, NULL);
INSERT INTO `dic_area` VALUES (110, '裕华区', 103, 1, NULL);
INSERT INTO `dic_area` VALUES (111, '井陉县', 103, 1, NULL);
INSERT INTO `dic_area` VALUES (112, '正定县', 103, 1, NULL);
INSERT INTO `dic_area` VALUES (113, '栾城县', 103, 1, NULL);
INSERT INTO `dic_area` VALUES (114, '行唐县', 103, 1, NULL);
INSERT INTO `dic_area` VALUES (115, '灵寿县', 103, 1, NULL);
INSERT INTO `dic_area` VALUES (116, '高邑县', 103, 1, NULL);
INSERT INTO `dic_area` VALUES (117, '深泽县', 103, 1, NULL);
INSERT INTO `dic_area` VALUES (118, '赞皇县', 103, 1, NULL);
INSERT INTO `dic_area` VALUES (119, '无极县', 103, 1, NULL);
INSERT INTO `dic_area` VALUES (120, '平山县', 103, 1, NULL);
INSERT INTO `dic_area` VALUES (121, '元氏县', 103, 1, NULL);
INSERT INTO `dic_area` VALUES (122, '赵县', 103, 1, NULL);
INSERT INTO `dic_area` VALUES (123, '辛集市', 103, 1, NULL);
INSERT INTO `dic_area` VALUES (124, '藁城市', 103, 1, NULL);
INSERT INTO `dic_area` VALUES (125, '晋州市', 103, 1, NULL);
INSERT INTO `dic_area` VALUES (126, '新乐市', 103, 1, NULL);
INSERT INTO `dic_area` VALUES (127, '鹿泉市', 103, 1, NULL);
INSERT INTO `dic_area` VALUES (128, '唐山', 102, 1, NULL);
INSERT INTO `dic_area` VALUES (129, '市辖区', 128, 1, NULL);
INSERT INTO `dic_area` VALUES (130, '路南区', 128, 1, NULL);
INSERT INTO `dic_area` VALUES (131, '路北区', 128, 1, NULL);
INSERT INTO `dic_area` VALUES (132, '古冶区', 128, 1, NULL);
INSERT INTO `dic_area` VALUES (133, '开平区', 128, 1, NULL);
INSERT INTO `dic_area` VALUES (134, '丰南区', 128, 1, NULL);
INSERT INTO `dic_area` VALUES (135, '丰润区', 128, 1, NULL);
INSERT INTO `dic_area` VALUES (136, '滦县', 128, 1, NULL);
INSERT INTO `dic_area` VALUES (137, '滦南县', 128, 1, NULL);
INSERT INTO `dic_area` VALUES (138, '乐亭县', 128, 1, NULL);
INSERT INTO `dic_area` VALUES (139, '迁西县', 128, 1, NULL);
INSERT INTO `dic_area` VALUES (140, '玉田县', 128, 1, NULL);
INSERT INTO `dic_area` VALUES (141, '唐海县', 128, 1, NULL);
INSERT INTO `dic_area` VALUES (142, '遵化市', 128, 1, NULL);
INSERT INTO `dic_area` VALUES (143, '迁安市', 128, 1, NULL);
INSERT INTO `dic_area` VALUES (144, '秦皇岛', 102, 1, NULL);
INSERT INTO `dic_area` VALUES (145, '市辖区', 144, 1, NULL);
INSERT INTO `dic_area` VALUES (146, '海港区', 144, 1, NULL);
INSERT INTO `dic_area` VALUES (147, '山海关区', 144, 1, NULL);
INSERT INTO `dic_area` VALUES (148, '北戴河区', 144, 1, NULL);
INSERT INTO `dic_area` VALUES (149, '青龙满族自治县', 144, 1, NULL);
INSERT INTO `dic_area` VALUES (150, '昌黎县', 144, 1, NULL);
INSERT INTO `dic_area` VALUES (151, '抚宁县', 144, 1, NULL);
INSERT INTO `dic_area` VALUES (152, '卢龙县', 144, 1, NULL);
INSERT INTO `dic_area` VALUES (153, '邯郸', 102, 1, NULL);
INSERT INTO `dic_area` VALUES (154, '市辖区', 153, 1, NULL);
INSERT INTO `dic_area` VALUES (155, '邯山区', 153, 1, NULL);
INSERT INTO `dic_area` VALUES (156, '丛台区', 153, 1, NULL);
INSERT INTO `dic_area` VALUES (157, '复兴区', 153, 1, NULL);
INSERT INTO `dic_area` VALUES (158, '峰峰矿区', 153, 1, NULL);
INSERT INTO `dic_area` VALUES (159, '邯郸县', 153, 1, NULL);
INSERT INTO `dic_area` VALUES (160, '临漳县', 153, 1, NULL);
INSERT INTO `dic_area` VALUES (161, '成安县', 153, 1, NULL);
INSERT INTO `dic_area` VALUES (162, '大名县', 153, 1, NULL);
INSERT INTO `dic_area` VALUES (163, '涉县', 153, 1, NULL);
INSERT INTO `dic_area` VALUES (164, '磁县', 153, 1, NULL);
INSERT INTO `dic_area` VALUES (165, '肥乡县', 153, 1, NULL);
INSERT INTO `dic_area` VALUES (166, '永年县', 153, 1, NULL);
INSERT INTO `dic_area` VALUES (167, '邱县', 153, 1, NULL);
INSERT INTO `dic_area` VALUES (168, '鸡泽县', 153, 1, NULL);
INSERT INTO `dic_area` VALUES (169, '广平县', 153, 1, NULL);
INSERT INTO `dic_area` VALUES (170, '馆陶县', 153, 1, NULL);
INSERT INTO `dic_area` VALUES (171, '魏县', 153, 1, NULL);
INSERT INTO `dic_area` VALUES (172, '曲周县', 153, 1, NULL);
INSERT INTO `dic_area` VALUES (173, '武安市', 153, 1, NULL);
INSERT INTO `dic_area` VALUES (174, '邢台', 102, 1, NULL);
INSERT INTO `dic_area` VALUES (175, '市辖区', 174, 1, NULL);
INSERT INTO `dic_area` VALUES (176, '桥东区', 174, 1, NULL);
INSERT INTO `dic_area` VALUES (177, '桥西区', 174, 1, NULL);
INSERT INTO `dic_area` VALUES (178, '邢台县', 174, 1, NULL);
INSERT INTO `dic_area` VALUES (179, '临城县', 174, 1, NULL);
INSERT INTO `dic_area` VALUES (180, '内丘县', 174, 1, NULL);
INSERT INTO `dic_area` VALUES (181, '柏乡县', 174, 1, NULL);
INSERT INTO `dic_area` VALUES (182, '隆尧县', 174, 1, NULL);
INSERT INTO `dic_area` VALUES (183, '任县', 174, 1, NULL);
INSERT INTO `dic_area` VALUES (184, '南和县', 174, 1, NULL);
INSERT INTO `dic_area` VALUES (185, '宁晋县', 174, 1, NULL);
INSERT INTO `dic_area` VALUES (186, '巨鹿县', 174, 1, NULL);
INSERT INTO `dic_area` VALUES (187, '新河县', 174, 1, NULL);
INSERT INTO `dic_area` VALUES (188, '广宗县', 174, 1, NULL);
INSERT INTO `dic_area` VALUES (189, '平乡县', 174, 1, NULL);
INSERT INTO `dic_area` VALUES (190, '威县', 174, 1, NULL);
INSERT INTO `dic_area` VALUES (191, '清河县', 174, 1, NULL);
INSERT INTO `dic_area` VALUES (192, '临西县', 174, 1, NULL);
INSERT INTO `dic_area` VALUES (193, '南宫市', 174, 1, NULL);
INSERT INTO `dic_area` VALUES (194, '沙河市', 174, 1, NULL);
INSERT INTO `dic_area` VALUES (195, '保定', 102, 1, NULL);
INSERT INTO `dic_area` VALUES (196, '市辖区', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (197, '新市区', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (198, '北市区', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (199, '南市区', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (200, '满城县', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (201, '清苑县', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (202, '涞水县', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (203, '阜平县', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (204, '徐水县', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (205, '定兴县', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (206, '唐县', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (207, '高阳县', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (208, '容城县', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (209, '涞源县', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (210, '望都县', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (211, '安新县', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (212, '易县', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (213, '曲阳县', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (214, '蠡县', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (215, '顺平县', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (216, '博野县', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (217, '雄县', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (218, '涿州市', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (219, '定州市', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (220, '安国市', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (221, '高碑店市', 195, 1, NULL);
INSERT INTO `dic_area` VALUES (222, '张家口', 102, 1, NULL);
INSERT INTO `dic_area` VALUES (223, '市辖区', 222, 1, NULL);
INSERT INTO `dic_area` VALUES (224, '桥东区', 222, 1, NULL);
INSERT INTO `dic_area` VALUES (225, '桥西区', 222, 1, NULL);
INSERT INTO `dic_area` VALUES (226, '宣化区', 222, 1, NULL);
INSERT INTO `dic_area` VALUES (227, '下花园区', 222, 1, NULL);
INSERT INTO `dic_area` VALUES (228, '宣化县', 222, 1, NULL);
INSERT INTO `dic_area` VALUES (229, '张北县', 222, 1, NULL);
INSERT INTO `dic_area` VALUES (230, '康保县', 222, 1, NULL);
INSERT INTO `dic_area` VALUES (231, '沽源县', 222, 1, NULL);
INSERT INTO `dic_area` VALUES (232, '尚义县', 222, 1, NULL);
INSERT INTO `dic_area` VALUES (233, '蔚县', 222, 1, NULL);
INSERT INTO `dic_area` VALUES (234, '阳原县', 222, 1, NULL);
INSERT INTO `dic_area` VALUES (235, '怀安县', 222, 1, NULL);
INSERT INTO `dic_area` VALUES (236, '万全县', 222, 1, NULL);
INSERT INTO `dic_area` VALUES (237, '怀来县', 222, 1, NULL);
INSERT INTO `dic_area` VALUES (238, '涿鹿县', 222, 1, NULL);
INSERT INTO `dic_area` VALUES (239, '赤城县', 222, 1, NULL);
INSERT INTO `dic_area` VALUES (240, '崇礼县', 222, 1, NULL);
INSERT INTO `dic_area` VALUES (241, '承德', 102, 1, NULL);
INSERT INTO `dic_area` VALUES (242, '市辖区', 241, 1, NULL);
INSERT INTO `dic_area` VALUES (243, '双桥区', 241, 1, NULL);
INSERT INTO `dic_area` VALUES (244, '双滦区', 241, 1, NULL);
INSERT INTO `dic_area` VALUES (245, '鹰手营子矿区', 241, 1, NULL);
INSERT INTO `dic_area` VALUES (246, '承德县', 241, 1, NULL);
INSERT INTO `dic_area` VALUES (247, '兴隆县', 241, 1, NULL);
INSERT INTO `dic_area` VALUES (248, '平泉县', 241, 1, NULL);
INSERT INTO `dic_area` VALUES (249, '滦平县', 241, 1, NULL);
INSERT INTO `dic_area` VALUES (250, '隆化县', 241, 1, NULL);
INSERT INTO `dic_area` VALUES (251, '丰宁满族自治县', 241, 1, NULL);
INSERT INTO `dic_area` VALUES (252, '宽城满族自治县', 241, 1, NULL);
INSERT INTO `dic_area` VALUES (253, '围场满族蒙古族自治县', 241, 1, NULL);
INSERT INTO `dic_area` VALUES (254, '沧州', 102, 1, NULL);
INSERT INTO `dic_area` VALUES (255, '市辖区', 254, 1, NULL);
INSERT INTO `dic_area` VALUES (256, '新华区', 254, 1, NULL);
INSERT INTO `dic_area` VALUES (257, '运河区', 254, 1, NULL);
INSERT INTO `dic_area` VALUES (258, '沧县', 254, 1, NULL);
INSERT INTO `dic_area` VALUES (259, '青县', 254, 1, NULL);
INSERT INTO `dic_area` VALUES (260, '东光县', 254, 1, NULL);
INSERT INTO `dic_area` VALUES (261, '海兴县', 254, 1, NULL);
INSERT INTO `dic_area` VALUES (262, '盐山县', 254, 1, NULL);
INSERT INTO `dic_area` VALUES (263, '肃宁县', 254, 1, NULL);
INSERT INTO `dic_area` VALUES (264, '南皮县', 254, 1, NULL);
INSERT INTO `dic_area` VALUES (265, '吴桥县', 254, 1, NULL);
INSERT INTO `dic_area` VALUES (266, '献县', 254, 1, NULL);
INSERT INTO `dic_area` VALUES (267, '孟村回族自治县', 254, 1, NULL);
INSERT INTO `dic_area` VALUES (268, '泊头市', 254, 1, NULL);
INSERT INTO `dic_area` VALUES (269, '任丘市', 254, 1, NULL);
INSERT INTO `dic_area` VALUES (270, '黄骅市', 254, 1, NULL);
INSERT INTO `dic_area` VALUES (271, '河间市', 254, 1, NULL);
INSERT INTO `dic_area` VALUES (272, '廊坊', 102, 1, NULL);
INSERT INTO `dic_area` VALUES (273, '市辖区', 272, 1, NULL);
INSERT INTO `dic_area` VALUES (274, '安次区', 272, 1, NULL);
INSERT INTO `dic_area` VALUES (275, '广阳区', 272, 1, NULL);
INSERT INTO `dic_area` VALUES (276, '固安县', 272, 1, NULL);
INSERT INTO `dic_area` VALUES (277, '永清县', 272, 1, NULL);
INSERT INTO `dic_area` VALUES (278, '香河县', 272, 1, NULL);
INSERT INTO `dic_area` VALUES (279, '大城县', 272, 1, NULL);
INSERT INTO `dic_area` VALUES (280, '文安县', 272, 1, NULL);
INSERT INTO `dic_area` VALUES (281, '大厂回族自治县', 272, 1, NULL);
INSERT INTO `dic_area` VALUES (282, '霸州市', 272, 1, NULL);
INSERT INTO `dic_area` VALUES (283, '三河市', 272, 1, NULL);
INSERT INTO `dic_area` VALUES (284, '衡水', 102, 1, NULL);
INSERT INTO `dic_area` VALUES (285, '市辖区', 284, 1, NULL);
INSERT INTO `dic_area` VALUES (286, '桃城区', 284, 1, NULL);
INSERT INTO `dic_area` VALUES (287, '枣强县', 284, 1, NULL);
INSERT INTO `dic_area` VALUES (288, '武邑县', 284, 1, NULL);
INSERT INTO `dic_area` VALUES (289, '武强县', 284, 1, NULL);
INSERT INTO `dic_area` VALUES (290, '饶阳县', 284, 1, NULL);
INSERT INTO `dic_area` VALUES (291, '安平县', 284, 1, NULL);
INSERT INTO `dic_area` VALUES (292, '故城县', 284, 1, NULL);
INSERT INTO `dic_area` VALUES (293, '景县', 284, 1, NULL);
INSERT INTO `dic_area` VALUES (294, '阜城县', 284, 1, NULL);
INSERT INTO `dic_area` VALUES (295, '冀州市', 284, 1, NULL);
INSERT INTO `dic_area` VALUES (296, '深州市', 284, 1, NULL);
INSERT INTO `dic_area` VALUES (297, '山西省', 0, 1, NULL);
INSERT INTO `dic_area` VALUES (298, '太原', 297, 1, NULL);
INSERT INTO `dic_area` VALUES (299, '市辖区', 298, 1, NULL);
INSERT INTO `dic_area` VALUES (300, '小店区', 298, 1, NULL);
INSERT INTO `dic_area` VALUES (301, '迎泽区', 298, 1, NULL);
INSERT INTO `dic_area` VALUES (302, '杏花岭区', 298, 1, NULL);
INSERT INTO `dic_area` VALUES (303, '尖草坪区', 298, 1, NULL);
INSERT INTO `dic_area` VALUES (304, '万柏林区', 298, 1, NULL);
INSERT INTO `dic_area` VALUES (305, '晋源区', 298, 1, NULL);
INSERT INTO `dic_area` VALUES (306, '清徐县', 298, 1, NULL);
INSERT INTO `dic_area` VALUES (307, '阳曲县', 298, 1, NULL);
INSERT INTO `dic_area` VALUES (308, '娄烦县', 298, 1, NULL);
INSERT INTO `dic_area` VALUES (309, '古交市', 298, 1, NULL);
INSERT INTO `dic_area` VALUES (310, '大同', 297, 1, NULL);
INSERT INTO `dic_area` VALUES (311, '市辖区', 310, 1, NULL);
INSERT INTO `dic_area` VALUES (312, '城区', 310, 1, NULL);
INSERT INTO `dic_area` VALUES (313, '矿区', 310, 1, NULL);
INSERT INTO `dic_area` VALUES (314, '南郊区', 310, 1, NULL);
INSERT INTO `dic_area` VALUES (315, '新荣区', 310, 1, NULL);
INSERT INTO `dic_area` VALUES (316, '阳高县', 310, 1, NULL);
INSERT INTO `dic_area` VALUES (317, '天镇县', 310, 1, NULL);
INSERT INTO `dic_area` VALUES (318, '广灵县', 310, 1, NULL);
INSERT INTO `dic_area` VALUES (319, '灵丘县', 310, 1, NULL);
INSERT INTO `dic_area` VALUES (320, '浑源县', 310, 1, NULL);
INSERT INTO `dic_area` VALUES (321, '左云县', 310, 1, NULL);
INSERT INTO `dic_area` VALUES (322, '大同县', 310, 1, NULL);
INSERT INTO `dic_area` VALUES (323, '阳泉', 297, 1, NULL);
INSERT INTO `dic_area` VALUES (324, '市辖区', 323, 1, NULL);
INSERT INTO `dic_area` VALUES (325, '城区', 323, 1, NULL);
INSERT INTO `dic_area` VALUES (326, '矿区', 323, 1, NULL);
INSERT INTO `dic_area` VALUES (327, '郊区', 323, 1, NULL);
INSERT INTO `dic_area` VALUES (328, '平定县', 323, 1, NULL);
INSERT INTO `dic_area` VALUES (329, '盂县', 323, 1, NULL);
INSERT INTO `dic_area` VALUES (330, '长治', 297, 1, NULL);
INSERT INTO `dic_area` VALUES (331, '市辖区', 330, 1, NULL);
INSERT INTO `dic_area` VALUES (332, '城区', 330, 1, NULL);
INSERT INTO `dic_area` VALUES (333, '郊区', 330, 1, NULL);
INSERT INTO `dic_area` VALUES (334, '长治县', 330, 1, NULL);
INSERT INTO `dic_area` VALUES (335, '襄垣县', 330, 1, NULL);
INSERT INTO `dic_area` VALUES (336, '屯留县', 330, 1, NULL);
INSERT INTO `dic_area` VALUES (337, '平顺县', 330, 1, NULL);
INSERT INTO `dic_area` VALUES (338, '黎城县', 330, 1, NULL);
INSERT INTO `dic_area` VALUES (339, '壶关县', 330, 1, NULL);
INSERT INTO `dic_area` VALUES (340, '长子县', 330, 1, NULL);
INSERT INTO `dic_area` VALUES (341, '武乡县', 330, 1, NULL);
INSERT INTO `dic_area` VALUES (342, '沁县', 330, 1, NULL);
INSERT INTO `dic_area` VALUES (343, '沁源县', 330, 1, NULL);
INSERT INTO `dic_area` VALUES (344, '潞城市', 330, 1, NULL);
INSERT INTO `dic_area` VALUES (345, '晋城', 297, 1, NULL);
INSERT INTO `dic_area` VALUES (346, '市辖区', 345, 1, NULL);
INSERT INTO `dic_area` VALUES (347, '城区', 345, 1, NULL);
INSERT INTO `dic_area` VALUES (348, '沁水县', 345, 1, NULL);
INSERT INTO `dic_area` VALUES (349, '阳城县', 345, 1, NULL);
INSERT INTO `dic_area` VALUES (350, '陵川县', 345, 1, NULL);
INSERT INTO `dic_area` VALUES (351, '泽州县', 345, 1, NULL);
INSERT INTO `dic_area` VALUES (352, '高平市', 345, 1, NULL);
INSERT INTO `dic_area` VALUES (353, '朔州', 297, 1, NULL);
INSERT INTO `dic_area` VALUES (354, '市辖区', 353, 1, NULL);
INSERT INTO `dic_area` VALUES (355, '朔城区', 353, 1, NULL);
INSERT INTO `dic_area` VALUES (356, '平鲁区', 353, 1, NULL);
INSERT INTO `dic_area` VALUES (357, '山阴县', 353, 1, NULL);
INSERT INTO `dic_area` VALUES (358, '应县', 353, 1, NULL);
INSERT INTO `dic_area` VALUES (359, '右玉县', 353, 1, NULL);
INSERT INTO `dic_area` VALUES (360, '怀仁县', 353, 1, NULL);
INSERT INTO `dic_area` VALUES (361, '晋中', 297, 1, NULL);
INSERT INTO `dic_area` VALUES (362, '市辖区', 361, 1, NULL);
INSERT INTO `dic_area` VALUES (363, '榆次区', 361, 1, NULL);
INSERT INTO `dic_area` VALUES (364, '榆社县', 361, 1, NULL);
INSERT INTO `dic_area` VALUES (365, '左权县', 361, 1, NULL);
INSERT INTO `dic_area` VALUES (366, '和顺县', 361, 1, NULL);
INSERT INTO `dic_area` VALUES (367, '昔阳县', 361, 1, NULL);
INSERT INTO `dic_area` VALUES (368, '寿阳县', 361, 1, NULL);
INSERT INTO `dic_area` VALUES (369, '太谷县', 361, 1, NULL);
INSERT INTO `dic_area` VALUES (370, '祁县', 361, 1, NULL);
INSERT INTO `dic_area` VALUES (371, '平遥县', 361, 1, NULL);
INSERT INTO `dic_area` VALUES (372, '灵石县', 361, 1, NULL);
INSERT INTO `dic_area` VALUES (373, '介休市', 361, 1, NULL);
INSERT INTO `dic_area` VALUES (374, '运城', 297, 1, NULL);
INSERT INTO `dic_area` VALUES (375, '市辖区', 374, 1, NULL);
INSERT INTO `dic_area` VALUES (376, '盐湖区', 374, 1, NULL);
INSERT INTO `dic_area` VALUES (377, '临猗县', 374, 1, NULL);
INSERT INTO `dic_area` VALUES (378, '万荣县', 374, 1, NULL);
INSERT INTO `dic_area` VALUES (379, '闻喜县', 374, 1, NULL);
INSERT INTO `dic_area` VALUES (380, '稷山县', 374, 1, NULL);
INSERT INTO `dic_area` VALUES (381, '新绛县', 374, 1, NULL);
INSERT INTO `dic_area` VALUES (382, '绛县', 374, 1, NULL);
INSERT INTO `dic_area` VALUES (383, '垣曲县', 374, 1, NULL);
INSERT INTO `dic_area` VALUES (384, '夏县', 374, 1, NULL);
INSERT INTO `dic_area` VALUES (385, '平陆县', 374, 1, NULL);
INSERT INTO `dic_area` VALUES (386, '芮城县', 374, 1, NULL);
INSERT INTO `dic_area` VALUES (387, '永济市', 374, 1, NULL);
INSERT INTO `dic_area` VALUES (388, '河津市', 374, 1, NULL);
INSERT INTO `dic_area` VALUES (389, '忻州', 297, 1, NULL);
INSERT INTO `dic_area` VALUES (390, '市辖区', 389, 1, NULL);
INSERT INTO `dic_area` VALUES (391, '忻府区', 389, 1, NULL);
INSERT INTO `dic_area` VALUES (392, '定襄县', 389, 1, NULL);
INSERT INTO `dic_area` VALUES (393, '五台县', 389, 1, NULL);
INSERT INTO `dic_area` VALUES (394, '代县', 389, 1, NULL);
INSERT INTO `dic_area` VALUES (395, '繁峙县', 389, 1, NULL);
INSERT INTO `dic_area` VALUES (396, '宁武县', 389, 1, NULL);
INSERT INTO `dic_area` VALUES (397, '静乐县', 389, 1, NULL);
INSERT INTO `dic_area` VALUES (398, '神池县', 389, 1, NULL);
INSERT INTO `dic_area` VALUES (399, '五寨县', 389, 1, NULL);
INSERT INTO `dic_area` VALUES (400, '岢岚县', 389, 1, NULL);
INSERT INTO `dic_area` VALUES (401, '河曲县', 389, 1, NULL);
INSERT INTO `dic_area` VALUES (402, '保德县', 389, 1, NULL);
INSERT INTO `dic_area` VALUES (403, '偏关县', 389, 1, NULL);
INSERT INTO `dic_area` VALUES (404, '原平市', 389, 1, NULL);
INSERT INTO `dic_area` VALUES (405, '临汾', 297, 1, NULL);
INSERT INTO `dic_area` VALUES (406, '市辖区', 405, 1, NULL);
INSERT INTO `dic_area` VALUES (407, '尧都区', 405, 1, NULL);
INSERT INTO `dic_area` VALUES (408, '曲沃县', 405, 1, NULL);
INSERT INTO `dic_area` VALUES (409, '翼城县', 405, 1, NULL);
INSERT INTO `dic_area` VALUES (410, '襄汾县', 405, 1, NULL);
INSERT INTO `dic_area` VALUES (411, '洪洞县', 405, 1, NULL);
INSERT INTO `dic_area` VALUES (412, '古县', 405, 1, NULL);
INSERT INTO `dic_area` VALUES (413, '安泽县', 405, 1, NULL);
INSERT INTO `dic_area` VALUES (414, '浮山县', 405, 1, NULL);
INSERT INTO `dic_area` VALUES (415, '吉县', 405, 1, NULL);
INSERT INTO `dic_area` VALUES (416, '乡宁县', 405, 1, NULL);
INSERT INTO `dic_area` VALUES (417, '大宁县', 405, 1, NULL);
INSERT INTO `dic_area` VALUES (418, '隰县', 405, 1, NULL);
INSERT INTO `dic_area` VALUES (419, '永和县', 405, 1, NULL);
INSERT INTO `dic_area` VALUES (420, '蒲县', 405, 1, NULL);
INSERT INTO `dic_area` VALUES (421, '汾西县', 405, 1, NULL);
INSERT INTO `dic_area` VALUES (422, '侯马市', 405, 1, NULL);
INSERT INTO `dic_area` VALUES (423, '霍州市', 405, 1, NULL);
INSERT INTO `dic_area` VALUES (424, '吕梁', 297, 1, NULL);
INSERT INTO `dic_area` VALUES (425, '市辖区', 424, 1, NULL);
INSERT INTO `dic_area` VALUES (426, '离石区', 424, 1, NULL);
INSERT INTO `dic_area` VALUES (427, '文水县', 424, 1, NULL);
INSERT INTO `dic_area` VALUES (428, '交城县', 424, 1, NULL);
INSERT INTO `dic_area` VALUES (429, '兴县', 424, 1, NULL);
INSERT INTO `dic_area` VALUES (430, '临县', 424, 1, NULL);
INSERT INTO `dic_area` VALUES (431, '柳林县', 424, 1, NULL);
INSERT INTO `dic_area` VALUES (432, '石楼县', 424, 1, NULL);
INSERT INTO `dic_area` VALUES (433, '岚县', 424, 1, NULL);
INSERT INTO `dic_area` VALUES (434, '方山县', 424, 1, NULL);
INSERT INTO `dic_area` VALUES (435, '中阳县', 424, 1, NULL);
INSERT INTO `dic_area` VALUES (436, '交口县', 424, 1, NULL);
INSERT INTO `dic_area` VALUES (437, '孝义市', 424, 1, NULL);
INSERT INTO `dic_area` VALUES (438, '汾阳市', 424, 1, NULL);
INSERT INTO `dic_area` VALUES (439, '内蒙古区', 0, 1, NULL);
INSERT INTO `dic_area` VALUES (440, '呼和浩特', 439, 1, NULL);
INSERT INTO `dic_area` VALUES (441, '市辖区', 440, 1, NULL);
INSERT INTO `dic_area` VALUES (442, '新城区', 440, 1, NULL);
INSERT INTO `dic_area` VALUES (443, '回民区', 440, 1, NULL);
INSERT INTO `dic_area` VALUES (444, '玉泉区', 440, 1, NULL);
INSERT INTO `dic_area` VALUES (445, '赛罕区', 440, 1, NULL);
INSERT INTO `dic_area` VALUES (446, '土默特左旗', 440, 1, NULL);
INSERT INTO `dic_area` VALUES (447, '托克托县', 440, 1, NULL);
INSERT INTO `dic_area` VALUES (448, '和林格尔县', 440, 1, NULL);
INSERT INTO `dic_area` VALUES (449, '清水河县', 440, 1, NULL);
INSERT INTO `dic_area` VALUES (450, '武川县', 440, 1, NULL);
INSERT INTO `dic_area` VALUES (451, '包头', 439, 1, NULL);
INSERT INTO `dic_area` VALUES (452, '市辖区', 451, 1, NULL);
INSERT INTO `dic_area` VALUES (453, '东河区', 451, 1, NULL);
INSERT INTO `dic_area` VALUES (454, '昆都仑区', 451, 1, NULL);
INSERT INTO `dic_area` VALUES (455, '青山区', 451, 1, NULL);
INSERT INTO `dic_area` VALUES (456, '石拐区', 451, 1, NULL);
INSERT INTO `dic_area` VALUES (457, '白云矿区', 451, 1, NULL);
INSERT INTO `dic_area` VALUES (458, '九原区', 451, 1, NULL);
INSERT INTO `dic_area` VALUES (459, '土默特右旗', 451, 1, NULL);
INSERT INTO `dic_area` VALUES (460, '固阳县', 451, 1, NULL);
INSERT INTO `dic_area` VALUES (461, '达尔罕茂明安联合旗', 451, 1, NULL);
INSERT INTO `dic_area` VALUES (462, '乌海', 439, 1, NULL);
INSERT INTO `dic_area` VALUES (463, '市辖区', 462, 1, NULL);
INSERT INTO `dic_area` VALUES (464, '海勃湾区', 462, 1, NULL);
INSERT INTO `dic_area` VALUES (465, '海南区', 462, 1, NULL);
INSERT INTO `dic_area` VALUES (466, '乌达区', 462, 1, NULL);
INSERT INTO `dic_area` VALUES (467, '赤峰', 439, 1, NULL);
INSERT INTO `dic_area` VALUES (468, '市辖区', 467, 1, NULL);
INSERT INTO `dic_area` VALUES (469, '红山区', 467, 1, NULL);
INSERT INTO `dic_area` VALUES (470, '元宝山区', 467, 1, NULL);
INSERT INTO `dic_area` VALUES (471, '松山区', 467, 1, NULL);
INSERT INTO `dic_area` VALUES (472, '阿鲁科尔沁旗', 467, 1, NULL);
INSERT INTO `dic_area` VALUES (473, '巴林左旗', 467, 1, NULL);
INSERT INTO `dic_area` VALUES (474, '巴林右旗', 467, 1, NULL);
INSERT INTO `dic_area` VALUES (475, '林西县', 467, 1, NULL);
INSERT INTO `dic_area` VALUES (476, '克什克腾旗', 467, 1, NULL);
INSERT INTO `dic_area` VALUES (477, '翁牛特旗', 467, 1, NULL);
INSERT INTO `dic_area` VALUES (478, '喀喇沁旗', 467, 1, NULL);
INSERT INTO `dic_area` VALUES (479, '宁城县', 467, 1, NULL);
INSERT INTO `dic_area` VALUES (480, '敖汉旗', 467, 1, NULL);
INSERT INTO `dic_area` VALUES (481, '通辽', 439, 1, NULL);
INSERT INTO `dic_area` VALUES (482, '市辖区', 481, 1, NULL);
INSERT INTO `dic_area` VALUES (483, '科尔沁区', 481, 1, NULL);
INSERT INTO `dic_area` VALUES (484, '科尔沁左翼中旗', 481, 1, NULL);
INSERT INTO `dic_area` VALUES (485, '科尔沁左翼后旗', 481, 1, NULL);
INSERT INTO `dic_area` VALUES (486, '开鲁县', 481, 1, NULL);
INSERT INTO `dic_area` VALUES (487, '库伦旗', 481, 1, NULL);
INSERT INTO `dic_area` VALUES (488, '奈曼旗', 481, 1, NULL);
INSERT INTO `dic_area` VALUES (489, '扎鲁特旗', 481, 1, NULL);
INSERT INTO `dic_area` VALUES (490, '霍林郭勒市', 481, 1, NULL);
INSERT INTO `dic_area` VALUES (491, '鄂尔多斯', 439, 1, NULL);
INSERT INTO `dic_area` VALUES (492, '东胜区', 491, 1, NULL);
INSERT INTO `dic_area` VALUES (493, '达拉特旗', 491, 1, NULL);
INSERT INTO `dic_area` VALUES (494, '准格尔旗', 491, 1, NULL);
INSERT INTO `dic_area` VALUES (495, '鄂托克前旗', 491, 1, NULL);
INSERT INTO `dic_area` VALUES (496, '鄂托克旗', 491, 1, NULL);
INSERT INTO `dic_area` VALUES (497, '杭锦旗', 491, 1, NULL);
INSERT INTO `dic_area` VALUES (498, '乌审旗', 491, 1, NULL);
INSERT INTO `dic_area` VALUES (499, '伊金霍洛旗', 491, 1, NULL);
INSERT INTO `dic_area` VALUES (500, '呼伦贝尔', 439, 1, NULL);
INSERT INTO `dic_area` VALUES (501, '市辖区', 500, 1, NULL);
INSERT INTO `dic_area` VALUES (502, '海拉尔区', 500, 1, NULL);
INSERT INTO `dic_area` VALUES (503, '阿荣旗', 500, 1, NULL);
INSERT INTO `dic_area` VALUES (504, '莫力达瓦达斡尔族自治旗', 500, 1, NULL);
INSERT INTO `dic_area` VALUES (505, '鄂伦春自治旗', 500, 1, NULL);
INSERT INTO `dic_area` VALUES (506, '鄂温克族自治旗', 500, 1, NULL);
INSERT INTO `dic_area` VALUES (507, '陈巴尔虎旗', 500, 1, NULL);
INSERT INTO `dic_area` VALUES (508, '新巴尔虎左旗', 500, 1, NULL);
INSERT INTO `dic_area` VALUES (509, '新巴尔虎右旗', 500, 1, NULL);
INSERT INTO `dic_area` VALUES (510, '满洲里市', 500, 1, NULL);
INSERT INTO `dic_area` VALUES (511, '牙克石市', 500, 1, NULL);
INSERT INTO `dic_area` VALUES (512, '扎兰屯市', 500, 1, NULL);
INSERT INTO `dic_area` VALUES (513, '额尔古纳市', 500, 1, NULL);
INSERT INTO `dic_area` VALUES (514, '根河市', 500, 1, NULL);
INSERT INTO `dic_area` VALUES (515, '巴彦淖尔', 439, 1, NULL);
INSERT INTO `dic_area` VALUES (516, '市辖区', 515, 1, NULL);
INSERT INTO `dic_area` VALUES (517, '临河区', 515, 1, NULL);
INSERT INTO `dic_area` VALUES (518, '五原县', 515, 1, NULL);
INSERT INTO `dic_area` VALUES (519, '磴口县', 515, 1, NULL);
INSERT INTO `dic_area` VALUES (520, '乌拉特前旗', 515, 1, NULL);
INSERT INTO `dic_area` VALUES (521, '乌拉特中旗', 515, 1, NULL);
INSERT INTO `dic_area` VALUES (522, '乌拉特后旗', 515, 1, NULL);
INSERT INTO `dic_area` VALUES (523, '杭锦后旗', 515, 1, NULL);
INSERT INTO `dic_area` VALUES (524, '乌兰察布', 439, 1, NULL);
INSERT INTO `dic_area` VALUES (525, '市辖区', 524, 1, NULL);
INSERT INTO `dic_area` VALUES (526, '集宁区', 524, 1, NULL);
INSERT INTO `dic_area` VALUES (527, '卓资县', 524, 1, NULL);
INSERT INTO `dic_area` VALUES (528, '化德县', 524, 1, NULL);
INSERT INTO `dic_area` VALUES (529, '商都县', 524, 1, NULL);
INSERT INTO `dic_area` VALUES (530, '兴和县', 524, 1, NULL);
INSERT INTO `dic_area` VALUES (531, '凉城县', 524, 1, NULL);
INSERT INTO `dic_area` VALUES (532, '察哈尔右翼前旗', 524, 1, NULL);
INSERT INTO `dic_area` VALUES (533, '察哈尔右翼中旗', 524, 1, NULL);
INSERT INTO `dic_area` VALUES (534, '察哈尔右翼后旗', 524, 1, NULL);
INSERT INTO `dic_area` VALUES (535, '四子王旗', 524, 1, NULL);
INSERT INTO `dic_area` VALUES (536, '丰镇市', 524, 1, NULL);
INSERT INTO `dic_area` VALUES (537, '兴安盟', 439, 1, NULL);
INSERT INTO `dic_area` VALUES (538, '乌兰浩特市', 537, 1, NULL);
INSERT INTO `dic_area` VALUES (539, '阿尔山市', 537, 1, NULL);
INSERT INTO `dic_area` VALUES (540, '科尔沁右翼前旗', 537, 1, NULL);
INSERT INTO `dic_area` VALUES (541, '科尔沁右翼中旗', 537, 1, NULL);
INSERT INTO `dic_area` VALUES (542, '扎赉特旗', 537, 1, NULL);
INSERT INTO `dic_area` VALUES (543, '突泉县', 537, 1, NULL);
INSERT INTO `dic_area` VALUES (544, '锡林郭勒盟', 439, 1, NULL);
INSERT INTO `dic_area` VALUES (545, '二连浩特市', 544, 1, NULL);
INSERT INTO `dic_area` VALUES (546, '锡林浩特市', 544, 1, NULL);
INSERT INTO `dic_area` VALUES (547, '阿巴嘎旗', 544, 1, NULL);
INSERT INTO `dic_area` VALUES (548, '苏尼特左旗', 544, 1, NULL);
INSERT INTO `dic_area` VALUES (549, '苏尼特右旗', 544, 1, NULL);
INSERT INTO `dic_area` VALUES (550, '东乌珠穆沁旗', 544, 1, NULL);
INSERT INTO `dic_area` VALUES (551, '西乌珠穆沁旗', 544, 1, NULL);
INSERT INTO `dic_area` VALUES (552, '太仆寺旗', 544, 1, NULL);
INSERT INTO `dic_area` VALUES (553, '镶黄旗', 544, 1, NULL);
INSERT INTO `dic_area` VALUES (554, '正镶白旗', 544, 1, NULL);
INSERT INTO `dic_area` VALUES (555, '正蓝旗', 544, 1, NULL);
INSERT INTO `dic_area` VALUES (556, '多伦县', 544, 1, NULL);
INSERT INTO `dic_area` VALUES (557, '阿拉善盟', 439, 1, NULL);
INSERT INTO `dic_area` VALUES (558, '阿拉善左旗', 557, 1, NULL);
INSERT INTO `dic_area` VALUES (559, '阿拉善右旗', 557, 1, NULL);
INSERT INTO `dic_area` VALUES (560, '额济纳旗', 557, 1, NULL);
INSERT INTO `dic_area` VALUES (561, '辽宁省', 0, 1, NULL);
INSERT INTO `dic_area` VALUES (562, '沈阳', 561, 1, NULL);
INSERT INTO `dic_area` VALUES (563, '市辖区', 562, 1, NULL);
INSERT INTO `dic_area` VALUES (564, '和平区', 562, 1, NULL);
INSERT INTO `dic_area` VALUES (565, '沈河区', 562, 1, NULL);
INSERT INTO `dic_area` VALUES (566, '大东区', 562, 1, NULL);
INSERT INTO `dic_area` VALUES (567, '皇姑区', 562, 1, NULL);
INSERT INTO `dic_area` VALUES (568, '铁西区', 562, 1, NULL);
INSERT INTO `dic_area` VALUES (569, '苏家屯区', 562, 1, NULL);
INSERT INTO `dic_area` VALUES (570, '东陵区', 562, 1, NULL);
INSERT INTO `dic_area` VALUES (571, '新城子区', 562, 1, NULL);
INSERT INTO `dic_area` VALUES (572, '于洪区', 562, 1, NULL);
INSERT INTO `dic_area` VALUES (573, '辽中县', 562, 1, NULL);
INSERT INTO `dic_area` VALUES (574, '康平县', 562, 1, NULL);
INSERT INTO `dic_area` VALUES (575, '法库县', 562, 1, NULL);
INSERT INTO `dic_area` VALUES (576, '新民市', 562, 1, NULL);
INSERT INTO `dic_area` VALUES (577, '大连', 561, 1, NULL);
INSERT INTO `dic_area` VALUES (578, '市辖区', 577, 1, NULL);
INSERT INTO `dic_area` VALUES (579, '中山区', 577, 1, NULL);
INSERT INTO `dic_area` VALUES (580, '西岗区', 577, 1, NULL);
INSERT INTO `dic_area` VALUES (581, '沙河口区', 577, 1, NULL);
INSERT INTO `dic_area` VALUES (582, '甘井子区', 577, 1, NULL);
INSERT INTO `dic_area` VALUES (583, '旅顺口区', 577, 1, NULL);
INSERT INTO `dic_area` VALUES (584, '金州区', 577, 1, NULL);
INSERT INTO `dic_area` VALUES (585, '长海县', 577, 1, NULL);
INSERT INTO `dic_area` VALUES (586, '瓦房店市', 577, 1, NULL);
INSERT INTO `dic_area` VALUES (587, '普兰店市', 577, 1, NULL);
INSERT INTO `dic_area` VALUES (588, '庄河市', 577, 1, NULL);
INSERT INTO `dic_area` VALUES (589, '鞍山', 561, 1, NULL);
INSERT INTO `dic_area` VALUES (590, '市辖区', 589, 1, NULL);
INSERT INTO `dic_area` VALUES (591, '铁东区', 589, 1, NULL);
INSERT INTO `dic_area` VALUES (592, '铁西区', 589, 1, NULL);
INSERT INTO `dic_area` VALUES (593, '立山区', 589, 1, NULL);
INSERT INTO `dic_area` VALUES (594, '千山区', 589, 1, NULL);
INSERT INTO `dic_area` VALUES (595, '台安县', 589, 1, NULL);
INSERT INTO `dic_area` VALUES (596, '岫岩满族自治县', 589, 1, NULL);
INSERT INTO `dic_area` VALUES (597, '海城市', 589, 1, NULL);
INSERT INTO `dic_area` VALUES (598, '抚顺', 561, 1, NULL);
INSERT INTO `dic_area` VALUES (599, '市辖区', 598, 1, NULL);
INSERT INTO `dic_area` VALUES (600, '新抚区', 598, 1, NULL);
INSERT INTO `dic_area` VALUES (601, '东洲区', 598, 1, NULL);
INSERT INTO `dic_area` VALUES (602, '望花区', 598, 1, NULL);
INSERT INTO `dic_area` VALUES (603, '顺城区', 598, 1, NULL);
INSERT INTO `dic_area` VALUES (604, '抚顺县', 598, 1, NULL);
INSERT INTO `dic_area` VALUES (605, '新宾满族自治县', 598, 1, NULL);
INSERT INTO `dic_area` VALUES (606, '清原满族自治县', 598, 1, NULL);
INSERT INTO `dic_area` VALUES (607, '本溪', 561, 1, NULL);
INSERT INTO `dic_area` VALUES (608, '市辖区', 607, 1, NULL);
INSERT INTO `dic_area` VALUES (609, '平山区', 607, 1, NULL);
INSERT INTO `dic_area` VALUES (610, '溪湖区', 607, 1, NULL);
INSERT INTO `dic_area` VALUES (611, '明山区', 607, 1, NULL);
INSERT INTO `dic_area` VALUES (612, '南芬区', 607, 1, NULL);
INSERT INTO `dic_area` VALUES (613, '本溪满族自治县', 607, 1, NULL);
INSERT INTO `dic_area` VALUES (614, '桓仁满族自治县', 607, 1, NULL);
INSERT INTO `dic_area` VALUES (615, '丹东', 561, 1, NULL);
INSERT INTO `dic_area` VALUES (616, '市辖区', 615, 1, NULL);
INSERT INTO `dic_area` VALUES (617, '元宝区', 615, 1, NULL);
INSERT INTO `dic_area` VALUES (618, '振兴区', 615, 1, NULL);
INSERT INTO `dic_area` VALUES (619, '振安区', 615, 1, NULL);
INSERT INTO `dic_area` VALUES (620, '宽甸满族自治县', 615, 1, NULL);
INSERT INTO `dic_area` VALUES (621, '东港市', 615, 1, NULL);
INSERT INTO `dic_area` VALUES (622, '凤城市', 615, 1, NULL);
INSERT INTO `dic_area` VALUES (623, '锦州', 561, 1, NULL);
INSERT INTO `dic_area` VALUES (624, '市辖区', 623, 1, NULL);
INSERT INTO `dic_area` VALUES (625, '古塔区', 623, 1, NULL);
INSERT INTO `dic_area` VALUES (626, '凌河区', 623, 1, NULL);
INSERT INTO `dic_area` VALUES (627, '太和区', 623, 1, NULL);
INSERT INTO `dic_area` VALUES (628, '黑山县', 623, 1, NULL);
INSERT INTO `dic_area` VALUES (629, '义县', 623, 1, NULL);
INSERT INTO `dic_area` VALUES (630, '凌海市', 623, 1, NULL);
INSERT INTO `dic_area` VALUES (631, '北宁市', 623, 1, NULL);
INSERT INTO `dic_area` VALUES (632, '营口', 561, 1, NULL);
INSERT INTO `dic_area` VALUES (633, '市辖区', 632, 1, NULL);
INSERT INTO `dic_area` VALUES (634, '站前区', 632, 1, NULL);
INSERT INTO `dic_area` VALUES (635, '西市区', 632, 1, NULL);
INSERT INTO `dic_area` VALUES (636, '鲅鱼圈区', 632, 1, NULL);
INSERT INTO `dic_area` VALUES (637, '老边区', 632, 1, NULL);
INSERT INTO `dic_area` VALUES (638, '盖州市', 632, 1, NULL);
INSERT INTO `dic_area` VALUES (639, '大石桥市', 632, 1, NULL);
INSERT INTO `dic_area` VALUES (640, '阜新', 561, 1, NULL);
INSERT INTO `dic_area` VALUES (641, '市辖区', 640, 1, NULL);
INSERT INTO `dic_area` VALUES (642, '海州区', 640, 1, NULL);
INSERT INTO `dic_area` VALUES (643, '新邱区', 640, 1, NULL);
INSERT INTO `dic_area` VALUES (644, '太平区', 640, 1, NULL);
INSERT INTO `dic_area` VALUES (645, '清河门区', 640, 1, NULL);
INSERT INTO `dic_area` VALUES (646, '细河区', 640, 1, NULL);
INSERT INTO `dic_area` VALUES (647, '阜新蒙古族自治县', 640, 1, NULL);
INSERT INTO `dic_area` VALUES (648, '彰武县', 640, 1, NULL);
INSERT INTO `dic_area` VALUES (649, '辽阳', 561, 1, NULL);
INSERT INTO `dic_area` VALUES (650, '市辖区', 649, 1, NULL);
INSERT INTO `dic_area` VALUES (651, '白塔区', 649, 1, NULL);
INSERT INTO `dic_area` VALUES (652, '文圣区', 649, 1, NULL);
INSERT INTO `dic_area` VALUES (653, '宏伟区', 649, 1, NULL);
INSERT INTO `dic_area` VALUES (654, '弓长岭区', 649, 1, NULL);
INSERT INTO `dic_area` VALUES (655, '太子河区', 649, 1, NULL);
INSERT INTO `dic_area` VALUES (656, '辽阳县', 649, 1, NULL);
INSERT INTO `dic_area` VALUES (657, '灯塔市', 649, 1, NULL);
INSERT INTO `dic_area` VALUES (658, '盘锦', 561, 1, NULL);
INSERT INTO `dic_area` VALUES (659, '市辖区', 658, 1, NULL);
INSERT INTO `dic_area` VALUES (660, '双台子区', 658, 1, NULL);
INSERT INTO `dic_area` VALUES (661, '兴隆台区', 658, 1, NULL);
INSERT INTO `dic_area` VALUES (662, '大洼县', 658, 1, NULL);
INSERT INTO `dic_area` VALUES (663, '盘山县', 658, 1, NULL);
INSERT INTO `dic_area` VALUES (664, '铁岭', 561, 1, NULL);
INSERT INTO `dic_area` VALUES (665, '市辖区', 664, 1, NULL);
INSERT INTO `dic_area` VALUES (666, '银州区', 664, 1, NULL);
INSERT INTO `dic_area` VALUES (667, '清河区', 664, 1, NULL);
INSERT INTO `dic_area` VALUES (668, '铁岭县', 664, 1, NULL);
INSERT INTO `dic_area` VALUES (669, '西丰县', 664, 1, NULL);
INSERT INTO `dic_area` VALUES (670, '昌图县', 664, 1, NULL);
INSERT INTO `dic_area` VALUES (671, '调兵山市', 664, 1, NULL);
INSERT INTO `dic_area` VALUES (672, '开原市', 664, 1, NULL);
INSERT INTO `dic_area` VALUES (673, '朝阳', 561, 1, NULL);
INSERT INTO `dic_area` VALUES (674, '市辖区', 673, 1, NULL);
INSERT INTO `dic_area` VALUES (675, '双塔区', 673, 1, NULL);
INSERT INTO `dic_area` VALUES (676, '龙城区', 673, 1, NULL);
INSERT INTO `dic_area` VALUES (677, '朝阳县', 673, 1, NULL);
INSERT INTO `dic_area` VALUES (678, '建平县', 673, 1, NULL);
INSERT INTO `dic_area` VALUES (679, '喀喇沁左翼蒙古族自治县', 673, 1, NULL);
INSERT INTO `dic_area` VALUES (680, '北票市', 673, 1, NULL);
INSERT INTO `dic_area` VALUES (681, '凌源市', 673, 1, NULL);
INSERT INTO `dic_area` VALUES (682, '葫芦岛', 561, 1, NULL);
INSERT INTO `dic_area` VALUES (683, '市辖区', 682, 1, NULL);
INSERT INTO `dic_area` VALUES (684, '连山区', 682, 1, NULL);
INSERT INTO `dic_area` VALUES (685, '龙港区', 682, 1, NULL);
INSERT INTO `dic_area` VALUES (686, '南票区', 682, 1, NULL);
INSERT INTO `dic_area` VALUES (687, '绥中县', 682, 1, NULL);
INSERT INTO `dic_area` VALUES (688, '建昌县', 682, 1, NULL);
INSERT INTO `dic_area` VALUES (689, '兴城市', 682, 1, NULL);
INSERT INTO `dic_area` VALUES (690, '吉林省', 0, 1, NULL);
INSERT INTO `dic_area` VALUES (691, '长春', 690, 1, NULL);
INSERT INTO `dic_area` VALUES (692, '市辖区', 691, 1, NULL);
INSERT INTO `dic_area` VALUES (693, '南关区', 691, 1, NULL);
INSERT INTO `dic_area` VALUES (694, '宽城区', 691, 1, NULL);
INSERT INTO `dic_area` VALUES (695, '朝阳区', 691, 1, NULL);
INSERT INTO `dic_area` VALUES (696, '二道区', 691, 1, NULL);
INSERT INTO `dic_area` VALUES (697, '绿园区', 691, 1, NULL);
INSERT INTO `dic_area` VALUES (698, '双阳区', 691, 1, NULL);
INSERT INTO `dic_area` VALUES (699, '农安县', 691, 1, NULL);
INSERT INTO `dic_area` VALUES (700, '九台市', 691, 1, NULL);
INSERT INTO `dic_area` VALUES (701, '榆树市', 691, 1, NULL);
INSERT INTO `dic_area` VALUES (702, '德惠市', 691, 1, NULL);
INSERT INTO `dic_area` VALUES (703, '吉林', 690, 1, NULL);
INSERT INTO `dic_area` VALUES (704, '市辖区', 703, 1, NULL);
INSERT INTO `dic_area` VALUES (705, '昌邑区', 703, 1, NULL);
INSERT INTO `dic_area` VALUES (706, '龙潭区', 703, 1, NULL);
INSERT INTO `dic_area` VALUES (707, '船营区', 703, 1, NULL);
INSERT INTO `dic_area` VALUES (708, '丰满区', 703, 1, NULL);
INSERT INTO `dic_area` VALUES (709, '永吉县', 703, 1, NULL);
INSERT INTO `dic_area` VALUES (710, '蛟河市', 703, 1, NULL);
INSERT INTO `dic_area` VALUES (711, '桦甸市', 703, 1, NULL);
INSERT INTO `dic_area` VALUES (712, '舒兰市', 703, 1, NULL);
INSERT INTO `dic_area` VALUES (713, '磐石市', 703, 1, NULL);
INSERT INTO `dic_area` VALUES (714, '四平', 690, 1, NULL);
INSERT INTO `dic_area` VALUES (715, '市辖区', 714, 1, NULL);
INSERT INTO `dic_area` VALUES (716, '铁西区', 714, 1, NULL);
INSERT INTO `dic_area` VALUES (717, '铁东区', 714, 1, NULL);
INSERT INTO `dic_area` VALUES (718, '梨树县', 714, 1, NULL);
INSERT INTO `dic_area` VALUES (719, '伊通满族自治县', 714, 1, NULL);
INSERT INTO `dic_area` VALUES (720, '公主岭市', 714, 1, NULL);
INSERT INTO `dic_area` VALUES (721, '双辽市', 714, 1, NULL);
INSERT INTO `dic_area` VALUES (722, '辽源', 690, 1, NULL);
INSERT INTO `dic_area` VALUES (723, '市辖区', 722, 1, NULL);
INSERT INTO `dic_area` VALUES (724, '龙山区', 722, 1, NULL);
INSERT INTO `dic_area` VALUES (725, '西安区', 722, 1, NULL);
INSERT INTO `dic_area` VALUES (726, '东丰县', 722, 1, NULL);
INSERT INTO `dic_area` VALUES (727, '东辽县', 722, 1, NULL);
INSERT INTO `dic_area` VALUES (728, '通化', 690, 1, NULL);
INSERT INTO `dic_area` VALUES (729, '市辖区', 728, 1, NULL);
INSERT INTO `dic_area` VALUES (730, '东昌区', 728, 1, NULL);
INSERT INTO `dic_area` VALUES (731, '二道江区', 728, 1, NULL);
INSERT INTO `dic_area` VALUES (732, '通化县', 728, 1, NULL);
INSERT INTO `dic_area` VALUES (733, '辉南县', 728, 1, NULL);
INSERT INTO `dic_area` VALUES (734, '柳河县', 728, 1, NULL);
INSERT INTO `dic_area` VALUES (735, '梅河口市', 728, 1, NULL);
INSERT INTO `dic_area` VALUES (736, '集安市', 728, 1, NULL);
INSERT INTO `dic_area` VALUES (737, '白山', 690, 1, NULL);
INSERT INTO `dic_area` VALUES (738, '市辖区', 737, 1, NULL);
INSERT INTO `dic_area` VALUES (739, '八道江区', 737, 1, NULL);
INSERT INTO `dic_area` VALUES (740, '抚松县', 737, 1, NULL);
INSERT INTO `dic_area` VALUES (741, '靖宇县', 737, 1, NULL);
INSERT INTO `dic_area` VALUES (742, '长白朝鲜族自治县', 737, 1, NULL);
INSERT INTO `dic_area` VALUES (743, '江源县', 737, 1, NULL);
INSERT INTO `dic_area` VALUES (744, '临江市', 737, 1, NULL);
INSERT INTO `dic_area` VALUES (745, '松原', 690, 1, NULL);
INSERT INTO `dic_area` VALUES (746, '市辖区', 745, 1, NULL);
INSERT INTO `dic_area` VALUES (747, '宁江区', 745, 1, NULL);
INSERT INTO `dic_area` VALUES (748, '前郭尔罗斯蒙古族自治县', 745, 1, NULL);
INSERT INTO `dic_area` VALUES (749, '长岭县', 745, 1, NULL);
INSERT INTO `dic_area` VALUES (750, '乾安县', 745, 1, NULL);
INSERT INTO `dic_area` VALUES (751, '扶余县', 745, 1, NULL);
INSERT INTO `dic_area` VALUES (752, '白城', 690, 1, NULL);
INSERT INTO `dic_area` VALUES (753, '市辖区', 752, 1, NULL);
INSERT INTO `dic_area` VALUES (754, '洮北区', 752, 1, NULL);
INSERT INTO `dic_area` VALUES (755, '镇赉县', 752, 1, NULL);
INSERT INTO `dic_area` VALUES (756, '通榆县', 752, 1, NULL);
INSERT INTO `dic_area` VALUES (757, '洮南市', 752, 1, NULL);
INSERT INTO `dic_area` VALUES (758, '大安市', 752, 1, NULL);
INSERT INTO `dic_area` VALUES (759, '延边自治州', 690, 1, NULL);
INSERT INTO `dic_area` VALUES (760, '延吉市', 759, 1, NULL);
INSERT INTO `dic_area` VALUES (761, '图们市', 759, 1, NULL);
INSERT INTO `dic_area` VALUES (762, '敦化市', 759, 1, NULL);
INSERT INTO `dic_area` VALUES (763, '珲春市', 759, 1, NULL);
INSERT INTO `dic_area` VALUES (764, '龙井市', 759, 1, NULL);
INSERT INTO `dic_area` VALUES (765, '和龙市', 759, 1, NULL);
INSERT INTO `dic_area` VALUES (766, '汪清县', 759, 1, NULL);
INSERT INTO `dic_area` VALUES (767, '安图县', 759, 1, NULL);
INSERT INTO `dic_area` VALUES (768, '黑龙江省', 0, 1, NULL);
INSERT INTO `dic_area` VALUES (769, '哈尔滨', 768, 1, NULL);
INSERT INTO `dic_area` VALUES (770, '市辖区', 769, 1, NULL);
INSERT INTO `dic_area` VALUES (771, '道里区', 769, 1, NULL);
INSERT INTO `dic_area` VALUES (772, '南岗区', 769, 1, NULL);
INSERT INTO `dic_area` VALUES (773, '道外区', 769, 1, NULL);
INSERT INTO `dic_area` VALUES (774, '香坊区', 769, 1, NULL);
INSERT INTO `dic_area` VALUES (775, '动力区', 769, 1, NULL);
INSERT INTO `dic_area` VALUES (776, '平房区', 769, 1, NULL);
INSERT INTO `dic_area` VALUES (777, '松北区', 769, 1, NULL);
INSERT INTO `dic_area` VALUES (778, '呼兰区', 769, 1, NULL);
INSERT INTO `dic_area` VALUES (779, '依兰县', 769, 1, NULL);
INSERT INTO `dic_area` VALUES (780, '方正县', 769, 1, NULL);
INSERT INTO `dic_area` VALUES (781, '宾县', 769, 1, NULL);
INSERT INTO `dic_area` VALUES (782, '巴彦县', 769, 1, NULL);
INSERT INTO `dic_area` VALUES (783, '木兰县', 769, 1, NULL);
INSERT INTO `dic_area` VALUES (784, '通河县', 769, 1, NULL);
INSERT INTO `dic_area` VALUES (785, '延寿县', 769, 1, NULL);
INSERT INTO `dic_area` VALUES (786, '阿城市', 769, 1, NULL);
INSERT INTO `dic_area` VALUES (787, '双城市', 769, 1, NULL);
INSERT INTO `dic_area` VALUES (788, '尚志市', 769, 1, NULL);
INSERT INTO `dic_area` VALUES (789, '五常市', 769, 1, NULL);
INSERT INTO `dic_area` VALUES (790, '齐齐哈尔', 768, 1, NULL);
INSERT INTO `dic_area` VALUES (791, '市辖区', 790, 1, NULL);
INSERT INTO `dic_area` VALUES (792, '龙沙区', 790, 1, NULL);
INSERT INTO `dic_area` VALUES (793, '建华区', 790, 1, NULL);
INSERT INTO `dic_area` VALUES (794, '铁锋区', 790, 1, NULL);
INSERT INTO `dic_area` VALUES (795, '昂昂溪区', 790, 1, NULL);
INSERT INTO `dic_area` VALUES (796, '富拉尔基区', 790, 1, NULL);
INSERT INTO `dic_area` VALUES (797, '碾子山区', 790, 1, NULL);
INSERT INTO `dic_area` VALUES (798, '梅里斯达斡尔族区', 790, 1, NULL);
INSERT INTO `dic_area` VALUES (799, '龙江县', 790, 1, NULL);
INSERT INTO `dic_area` VALUES (800, '依安县', 790, 1, NULL);
INSERT INTO `dic_area` VALUES (801, '泰来县', 790, 1, NULL);
INSERT INTO `dic_area` VALUES (802, '甘南县', 790, 1, NULL);
INSERT INTO `dic_area` VALUES (803, '富裕县', 790, 1, NULL);
INSERT INTO `dic_area` VALUES (804, '克山县', 790, 1, NULL);
INSERT INTO `dic_area` VALUES (805, '克东县', 790, 1, NULL);
INSERT INTO `dic_area` VALUES (806, '拜泉县', 790, 1, NULL);
INSERT INTO `dic_area` VALUES (807, '讷河市', 790, 1, NULL);
INSERT INTO `dic_area` VALUES (808, '鸡西', 768, 1, NULL);
INSERT INTO `dic_area` VALUES (809, '市辖区', 808, 1, NULL);
INSERT INTO `dic_area` VALUES (810, '鸡冠区', 808, 1, NULL);
INSERT INTO `dic_area` VALUES (811, '恒山区', 808, 1, NULL);
INSERT INTO `dic_area` VALUES (812, '滴道区', 808, 1, NULL);
INSERT INTO `dic_area` VALUES (813, '梨树区', 808, 1, NULL);
INSERT INTO `dic_area` VALUES (814, '城子河区', 808, 1, NULL);
INSERT INTO `dic_area` VALUES (815, '麻山区', 808, 1, NULL);
INSERT INTO `dic_area` VALUES (816, '鸡东县', 808, 1, NULL);
INSERT INTO `dic_area` VALUES (817, '虎林市', 808, 1, NULL);
INSERT INTO `dic_area` VALUES (818, '密山市', 808, 1, NULL);
INSERT INTO `dic_area` VALUES (819, '鹤岗', 768, 1, NULL);
INSERT INTO `dic_area` VALUES (820, '市辖区', 819, 1, NULL);
INSERT INTO `dic_area` VALUES (821, '向阳区', 819, 1, NULL);
INSERT INTO `dic_area` VALUES (822, '工农区', 819, 1, NULL);
INSERT INTO `dic_area` VALUES (823, '南山区', 819, 1, NULL);
INSERT INTO `dic_area` VALUES (824, '兴安区', 819, 1, NULL);
INSERT INTO `dic_area` VALUES (825, '东山区', 819, 1, NULL);
INSERT INTO `dic_area` VALUES (826, '兴山区', 819, 1, NULL);
INSERT INTO `dic_area` VALUES (827, '萝北县', 819, 1, NULL);
INSERT INTO `dic_area` VALUES (828, '绥滨县', 819, 1, NULL);
INSERT INTO `dic_area` VALUES (829, '双鸭山', 768, 1, NULL);
INSERT INTO `dic_area` VALUES (830, '市辖区', 829, 1, NULL);
INSERT INTO `dic_area` VALUES (831, '尖山区', 829, 1, NULL);
INSERT INTO `dic_area` VALUES (832, '岭东区', 829, 1, NULL);
INSERT INTO `dic_area` VALUES (833, '四方台区', 829, 1, NULL);
INSERT INTO `dic_area` VALUES (834, '宝山区', 829, 1, NULL);
INSERT INTO `dic_area` VALUES (835, '集贤县', 829, 1, NULL);
INSERT INTO `dic_area` VALUES (836, '友谊县', 829, 1, NULL);
INSERT INTO `dic_area` VALUES (837, '宝清县', 829, 1, NULL);
INSERT INTO `dic_area` VALUES (838, '饶河县', 829, 1, NULL);
INSERT INTO `dic_area` VALUES (839, '大庆', 768, 1, NULL);
INSERT INTO `dic_area` VALUES (840, '市辖区', 839, 1, NULL);
INSERT INTO `dic_area` VALUES (841, '萨尔图区', 839, 1, NULL);
INSERT INTO `dic_area` VALUES (842, '龙凤区', 839, 1, NULL);
INSERT INTO `dic_area` VALUES (843, '让胡路区', 839, 1, NULL);
INSERT INTO `dic_area` VALUES (844, '红岗区', 839, 1, NULL);
INSERT INTO `dic_area` VALUES (845, '大同区', 839, 1, NULL);
INSERT INTO `dic_area` VALUES (846, '肇州县', 839, 1, NULL);
INSERT INTO `dic_area` VALUES (847, '肇源县', 839, 1, NULL);
INSERT INTO `dic_area` VALUES (848, '林甸县', 839, 1, NULL);
INSERT INTO `dic_area` VALUES (849, '杜尔伯特蒙古族自治县', 839, 1, NULL);
INSERT INTO `dic_area` VALUES (850, '伊春', 768, 1, NULL);
INSERT INTO `dic_area` VALUES (851, '市辖区', 850, 1, NULL);
INSERT INTO `dic_area` VALUES (852, '伊春区', 850, 1, NULL);
INSERT INTO `dic_area` VALUES (853, '南岔区', 850, 1, NULL);
INSERT INTO `dic_area` VALUES (854, '友好区', 850, 1, NULL);
INSERT INTO `dic_area` VALUES (855, '西林区', 850, 1, NULL);
INSERT INTO `dic_area` VALUES (856, '翠峦区', 850, 1, NULL);
INSERT INTO `dic_area` VALUES (857, '新青区', 850, 1, NULL);
INSERT INTO `dic_area` VALUES (858, '美溪区', 850, 1, NULL);
INSERT INTO `dic_area` VALUES (859, '金山屯区', 850, 1, NULL);
INSERT INTO `dic_area` VALUES (860, '五营区', 850, 1, NULL);
INSERT INTO `dic_area` VALUES (861, '乌马河区', 850, 1, NULL);
INSERT INTO `dic_area` VALUES (862, '汤旺河区', 850, 1, NULL);
INSERT INTO `dic_area` VALUES (863, '带岭区', 850, 1, NULL);
INSERT INTO `dic_area` VALUES (864, '乌伊岭区', 850, 1, NULL);
INSERT INTO `dic_area` VALUES (865, '红星区', 850, 1, NULL);
INSERT INTO `dic_area` VALUES (866, '上甘岭区', 850, 1, NULL);
INSERT INTO `dic_area` VALUES (867, '嘉荫县', 850, 1, NULL);
INSERT INTO `dic_area` VALUES (868, '铁力市', 850, 1, NULL);
INSERT INTO `dic_area` VALUES (869, '佳木斯', 768, 1, NULL);
INSERT INTO `dic_area` VALUES (870, '市辖区', 869, 1, NULL);
INSERT INTO `dic_area` VALUES (871, '永红区', 869, 1, NULL);
INSERT INTO `dic_area` VALUES (872, '向阳区', 869, 1, NULL);
INSERT INTO `dic_area` VALUES (873, '前进区', 869, 1, NULL);
INSERT INTO `dic_area` VALUES (874, '东风区', 869, 1, NULL);
INSERT INTO `dic_area` VALUES (875, '郊区', 869, 1, NULL);
INSERT INTO `dic_area` VALUES (876, '桦南县', 869, 1, NULL);
INSERT INTO `dic_area` VALUES (877, '桦川县', 869, 1, NULL);
INSERT INTO `dic_area` VALUES (878, '汤原县', 869, 1, NULL);
INSERT INTO `dic_area` VALUES (879, '抚远县', 869, 1, NULL);
INSERT INTO `dic_area` VALUES (880, '同江市', 869, 1, NULL);
INSERT INTO `dic_area` VALUES (881, '富锦市', 869, 1, NULL);
INSERT INTO `dic_area` VALUES (882, '七台河', 768, 1, NULL);
INSERT INTO `dic_area` VALUES (883, '市辖区', 882, 1, NULL);
INSERT INTO `dic_area` VALUES (884, '新兴区', 882, 1, NULL);
INSERT INTO `dic_area` VALUES (885, '桃山区', 882, 1, NULL);
INSERT INTO `dic_area` VALUES (886, '茄子河区', 882, 1, NULL);
INSERT INTO `dic_area` VALUES (887, '勃利县', 882, 1, NULL);
INSERT INTO `dic_area` VALUES (888, '牡丹江', 768, 1, NULL);
INSERT INTO `dic_area` VALUES (889, '市辖区', 888, 1, NULL);
INSERT INTO `dic_area` VALUES (890, '东安区', 888, 1, NULL);
INSERT INTO `dic_area` VALUES (891, '阳明区', 888, 1, NULL);
INSERT INTO `dic_area` VALUES (892, '爱民区', 888, 1, NULL);
INSERT INTO `dic_area` VALUES (893, '西安区', 888, 1, NULL);
INSERT INTO `dic_area` VALUES (894, '东宁县', 888, 1, NULL);
INSERT INTO `dic_area` VALUES (895, '林口县', 888, 1, NULL);
INSERT INTO `dic_area` VALUES (896, '绥芬河市', 888, 1, NULL);
INSERT INTO `dic_area` VALUES (897, '海林市', 888, 1, NULL);
INSERT INTO `dic_area` VALUES (898, '宁安市', 888, 1, NULL);
INSERT INTO `dic_area` VALUES (899, '穆棱市', 888, 1, NULL);
INSERT INTO `dic_area` VALUES (900, '黑河', 768, 1, NULL);
INSERT INTO `dic_area` VALUES (901, '市辖区', 900, 1, NULL);
INSERT INTO `dic_area` VALUES (902, '爱辉区', 900, 1, NULL);
INSERT INTO `dic_area` VALUES (903, '嫩江县', 900, 1, NULL);
INSERT INTO `dic_area` VALUES (904, '逊克县', 900, 1, NULL);
INSERT INTO `dic_area` VALUES (905, '孙吴县', 900, 1, NULL);
INSERT INTO `dic_area` VALUES (906, '北安市', 900, 1, NULL);
INSERT INTO `dic_area` VALUES (907, '五大连池市', 900, 1, NULL);
INSERT INTO `dic_area` VALUES (908, '绥化', 768, 1, NULL);
INSERT INTO `dic_area` VALUES (909, '市辖区', 908, 1, NULL);
INSERT INTO `dic_area` VALUES (910, '北林区', 908, 1, NULL);
INSERT INTO `dic_area` VALUES (911, '望奎县', 908, 1, NULL);
INSERT INTO `dic_area` VALUES (912, '兰西县', 908, 1, NULL);
INSERT INTO `dic_area` VALUES (913, '青冈县', 908, 1, NULL);
INSERT INTO `dic_area` VALUES (914, '庆安县', 908, 1, NULL);
INSERT INTO `dic_area` VALUES (915, '明水县', 908, 1, NULL);
INSERT INTO `dic_area` VALUES (916, '绥棱县', 908, 1, NULL);
INSERT INTO `dic_area` VALUES (917, '安达市', 908, 1, NULL);
INSERT INTO `dic_area` VALUES (918, '肇东市', 908, 1, NULL);
INSERT INTO `dic_area` VALUES (919, '海伦市', 908, 1, NULL);
INSERT INTO `dic_area` VALUES (920, '大兴安岭地区', 768, 1, NULL);
INSERT INTO `dic_area` VALUES (921, '呼玛县', 920, 1, NULL);
INSERT INTO `dic_area` VALUES (922, '塔河县', 920, 1, NULL);
INSERT INTO `dic_area` VALUES (923, '漠河县', 920, 1, NULL);
INSERT INTO `dic_area` VALUES (924, '江苏省', 0, 1, NULL);
INSERT INTO `dic_area` VALUES (925, '南京', 924, 1, NULL);
INSERT INTO `dic_area` VALUES (926, '市辖区', 925, 1, NULL);
INSERT INTO `dic_area` VALUES (927, '玄武区', 925, 1, NULL);
INSERT INTO `dic_area` VALUES (928, '白下区', 925, 1, NULL);
INSERT INTO `dic_area` VALUES (929, '秦淮区', 925, 1, NULL);
INSERT INTO `dic_area` VALUES (930, '建邺区', 925, 1, NULL);
INSERT INTO `dic_area` VALUES (931, '鼓楼区', 925, 1, NULL);
INSERT INTO `dic_area` VALUES (932, '下关区', 925, 1, NULL);
INSERT INTO `dic_area` VALUES (933, '浦口区', 925, 1, NULL);
INSERT INTO `dic_area` VALUES (934, '栖霞区', 925, 1, NULL);
INSERT INTO `dic_area` VALUES (935, '雨花台区', 925, 1, NULL);
INSERT INTO `dic_area` VALUES (936, '江宁区', 925, 1, NULL);
INSERT INTO `dic_area` VALUES (937, '六合区', 925, 1, NULL);
INSERT INTO `dic_area` VALUES (938, '溧水县', 925, 1, NULL);
INSERT INTO `dic_area` VALUES (939, '高淳县', 925, 1, NULL);
INSERT INTO `dic_area` VALUES (940, '无锡', 924, 1, NULL);
INSERT INTO `dic_area` VALUES (941, '市辖区', 940, 1, NULL);
INSERT INTO `dic_area` VALUES (942, '崇安区', 940, 1, NULL);
INSERT INTO `dic_area` VALUES (943, '南长区', 940, 1, NULL);
INSERT INTO `dic_area` VALUES (944, '北塘区', 940, 1, NULL);
INSERT INTO `dic_area` VALUES (945, '锡山区', 940, 1, NULL);
INSERT INTO `dic_area` VALUES (946, '惠山区', 940, 1, NULL);
INSERT INTO `dic_area` VALUES (947, '滨湖区', 940, 1, NULL);
INSERT INTO `dic_area` VALUES (948, '江阴市', 940, 1, NULL);
INSERT INTO `dic_area` VALUES (949, '宜兴市', 940, 1, NULL);
INSERT INTO `dic_area` VALUES (950, '徐州', 924, 1, NULL);
INSERT INTO `dic_area` VALUES (951, '市辖区', 950, 1, NULL);
INSERT INTO `dic_area` VALUES (952, '鼓楼区', 950, 1, NULL);
INSERT INTO `dic_area` VALUES (953, '云龙区', 950, 1, NULL);
INSERT INTO `dic_area` VALUES (954, '九里区', 950, 1, NULL);
INSERT INTO `dic_area` VALUES (955, '贾汪区', 950, 1, NULL);
INSERT INTO `dic_area` VALUES (956, '泉山区', 950, 1, NULL);
INSERT INTO `dic_area` VALUES (957, '丰县', 950, 1, NULL);
INSERT INTO `dic_area` VALUES (958, '沛县', 950, 1, NULL);
INSERT INTO `dic_area` VALUES (959, '铜山县', 950, 1, NULL);
INSERT INTO `dic_area` VALUES (960, '睢宁县', 950, 1, NULL);
INSERT INTO `dic_area` VALUES (961, '新沂市', 950, 1, NULL);
INSERT INTO `dic_area` VALUES (962, '邳州市', 950, 1, NULL);
INSERT INTO `dic_area` VALUES (963, '常州', 924, 1, NULL);
INSERT INTO `dic_area` VALUES (964, '市辖区', 963, 1, NULL);
INSERT INTO `dic_area` VALUES (965, '天宁区', 963, 1, NULL);
INSERT INTO `dic_area` VALUES (966, '钟楼区', 963, 1, NULL);
INSERT INTO `dic_area` VALUES (967, '戚墅堰区', 963, 1, NULL);
INSERT INTO `dic_area` VALUES (968, '新北区', 963, 1, NULL);
INSERT INTO `dic_area` VALUES (969, '武进区', 963, 1, NULL);
INSERT INTO `dic_area` VALUES (970, '溧阳市', 963, 1, NULL);
INSERT INTO `dic_area` VALUES (971, '金坛市', 963, 1, NULL);
INSERT INTO `dic_area` VALUES (972, '苏州', 924, 1, NULL);
INSERT INTO `dic_area` VALUES (973, '市辖区', 972, 1, NULL);
INSERT INTO `dic_area` VALUES (974, '沧浪区', 972, 1, NULL);
INSERT INTO `dic_area` VALUES (975, '平江区', 972, 1, NULL);
INSERT INTO `dic_area` VALUES (976, '金阊区', 972, 1, NULL);
INSERT INTO `dic_area` VALUES (977, '虎丘区', 972, 1, NULL);
INSERT INTO `dic_area` VALUES (978, '吴中区', 972, 1, NULL);
INSERT INTO `dic_area` VALUES (979, '相城区', 972, 1, NULL);
INSERT INTO `dic_area` VALUES (980, '常熟市', 972, 1, NULL);
INSERT INTO `dic_area` VALUES (981, '张家港市', 972, 1, NULL);
INSERT INTO `dic_area` VALUES (982, '昆山市', 972, 1, NULL);
INSERT INTO `dic_area` VALUES (983, '吴江市', 972, 1, NULL);
INSERT INTO `dic_area` VALUES (984, '太仓市', 972, 1, NULL);
INSERT INTO `dic_area` VALUES (985, '南通', 924, 1, NULL);
INSERT INTO `dic_area` VALUES (986, '市辖区', 985, 1, NULL);
INSERT INTO `dic_area` VALUES (987, '崇川区', 985, 1, NULL);
INSERT INTO `dic_area` VALUES (988, '港闸区', 985, 1, NULL);
INSERT INTO `dic_area` VALUES (989, '海安县', 985, 1, NULL);
INSERT INTO `dic_area` VALUES (990, '如东县', 985, 1, NULL);
INSERT INTO `dic_area` VALUES (991, '启东市', 985, 1, NULL);
INSERT INTO `dic_area` VALUES (992, '如皋市', 985, 1, NULL);
INSERT INTO `dic_area` VALUES (993, '通州市', 985, 1, NULL);
INSERT INTO `dic_area` VALUES (994, '海门市', 985, 1, NULL);
INSERT INTO `dic_area` VALUES (995, '连云港', 924, 1, NULL);
INSERT INTO `dic_area` VALUES (996, '市辖区', 995, 1, NULL);
INSERT INTO `dic_area` VALUES (997, '连云区', 995, 1, NULL);
INSERT INTO `dic_area` VALUES (998, '新浦区', 995, 1, NULL);
INS