当前位置:Gxlcms > 数据库问题 > 省市区三级-sql脚本:

省市区三级-sql脚本:

时间:2021-07-01 10:21:17 帮助过:15人阅读

 

/*
Navicat MySQL Data Transfer

Source Server : moirai
Source Server Version : 50631
Source Host : 192.168.6.31:3306
Source Database : moirai

Target Server Type : MYSQL
Target Server Version : 50631
File Encoding : 65001

Date: 2017-11-22 15:53:58
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for sys_prov_city_dist
-- ----------------------------
DROP TABLE IF EXISTS `sys_prov_city_dist`;
CREATE TABLE `sys_prov_city_dist` (
`id` int(11) NOT NULL,
`province` varchar(50) DEFAULT NULL,
`type` char(1) DEFAULT NULL,
`city` varchar(80) DEFAULT NULL,
`province_id` int(6) DEFAULT NULL,
`district` varchar(80) DEFAULT NULL,
`city_id` int(6) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_prov_city_dist
-- ----------------------------
INSERT INTO `sys_prov_city_dist` VALUES (‘110000‘, ‘北京市‘, ‘0‘, null, null, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘110100‘, null, ‘1‘, ‘市辖区‘, ‘110000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘110101‘, null, ‘2‘, null, null, ‘东城区‘, ‘110100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘110102‘, null, ‘2‘, null, null, ‘西城区‘, ‘110100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘110105‘, null, ‘2‘, null, null, ‘朝阳区‘, ‘110100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘110106‘, null, ‘2‘, null, null, ‘丰台区‘, ‘110100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘110107‘, null, ‘2‘, null, null, ‘石景山区‘, ‘110100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘110108‘, null, ‘2‘, null, null, ‘海淀区‘, ‘110100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘110109‘, null, ‘2‘, null, null, ‘门头沟区‘, ‘110100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘110111‘, null, ‘2‘, null, null, ‘房山区‘, ‘110100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘110112‘, null, ‘2‘, null, null, ‘通州区‘, ‘110100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘110113‘, null, ‘2‘, null, null, ‘顺义区‘, ‘110100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘110114‘, null, ‘2‘, null, null, ‘昌平区‘, ‘110100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘110115‘, null, ‘2‘, null, null, ‘大兴区‘, ‘110100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘110116‘, null, ‘2‘, null, null, ‘怀柔区‘, ‘110100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘110117‘, null, ‘2‘, null, null, ‘平谷区‘, ‘110100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘110200‘, null, ‘1‘, ‘县‘, ‘110000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘110228‘, null, ‘2‘, null, null, ‘密云县‘, ‘110200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘110229‘, null, ‘2‘, null, null, ‘延庆县‘, ‘110200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘120000‘, ‘天津市‘, ‘0‘, null, null, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘120100‘, null, ‘1‘, ‘市辖区‘, ‘120000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘120101‘, null, ‘2‘, null, null, ‘和平区‘, ‘120100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘120102‘, null, ‘2‘, null, null, ‘河东区‘, ‘120100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘120103‘, null, ‘2‘, null, null, ‘河西区‘, ‘120100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘120104‘, null, ‘2‘, null, null, ‘南开区‘, ‘120100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘120105‘, null, ‘2‘, null, null, ‘河北区‘, ‘120100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘120106‘, null, ‘2‘, null, null, ‘红桥区‘, ‘120100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘120110‘, null, ‘2‘, null, null, ‘东丽区‘, ‘120100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘120111‘, null, ‘2‘, null, null, ‘西青区‘, ‘120100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘120112‘, null, ‘2‘, null, null, ‘津南区‘, ‘120100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘120113‘, null, ‘2‘, null, null, ‘北辰区‘, ‘120100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘120114‘, null, ‘2‘, null, null, ‘武清区‘, ‘120100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘120115‘, null, ‘2‘, null, null, ‘宝坻区‘, ‘120100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘120116‘, null, ‘2‘, null, null, ‘滨海新区‘, ‘120100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘120200‘, null, ‘1‘, ‘县‘, ‘120000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘120221‘, null, ‘2‘, null, null, ‘宁河县‘, ‘120200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘120223‘, null, ‘2‘, null, null, ‘静海县‘, ‘120200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘120225‘, null, ‘2‘, null, null, ‘蓟县‘, ‘120200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130000‘, ‘河北省‘, ‘0‘, null, null, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘130100‘, null, ‘1‘, ‘石家庄市‘, ‘130000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘130101‘, null, ‘2‘, null, null, ‘市辖区‘, ‘130100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130102‘, null, ‘2‘, null, null, ‘长安区‘, ‘130100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130104‘, null, ‘2‘, null, null, ‘桥西区‘, ‘130100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130105‘, null, ‘2‘, null, null, ‘新华区‘, ‘130100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130107‘, null, ‘2‘, null, null, ‘井陉矿区‘, ‘130100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130108‘, null, ‘2‘, null, null, ‘裕华区‘, ‘130100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130109‘, null, ‘2‘, null, null, ‘藁城区‘, ‘130100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130110‘, null, ‘2‘, null, null, ‘鹿泉区‘, ‘130100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130111‘, null, ‘2‘, null, null, ‘栾城区‘, ‘130100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130121‘, null, ‘2‘, null, null, ‘井陉县‘, ‘130100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130123‘, null, ‘2‘, null, null, ‘正定县‘, ‘130100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130125‘, null, ‘2‘, null, null, ‘行唐县‘, ‘130100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130126‘, null, ‘2‘, null, null, ‘灵寿县‘, ‘130100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130127‘, null, ‘2‘, null, null, ‘高邑县‘, ‘130100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130128‘, null, ‘2‘, null, null, ‘深泽县‘, ‘130100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130129‘, null, ‘2‘, null, null, ‘赞皇县‘, ‘130100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130130‘, null, ‘2‘, null, null, ‘无极县‘, ‘130100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130131‘, null, ‘2‘, null, null, ‘平山县‘, ‘130100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130132‘, null, ‘2‘, null, null, ‘元氏县‘, ‘130100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130133‘, null, ‘2‘, null, null, ‘赵县‘, ‘130100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130181‘, null, ‘2‘, null, null, ‘辛集市‘, ‘130100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130183‘, null, ‘2‘, null, null, ‘晋州市‘, ‘130100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130184‘, null, ‘2‘, null, null, ‘新乐市‘, ‘130100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130200‘, null, ‘1‘, ‘唐山市‘, ‘130000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘130201‘, null, ‘2‘, null, null, ‘市辖区‘, ‘130200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130202‘, null, ‘2‘, null, null, ‘路南区‘, ‘130200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130203‘, null, ‘2‘, null, null, ‘路北区‘, ‘130200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130204‘, null, ‘2‘, null, null, ‘古冶区‘, ‘130200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130205‘, null, ‘2‘, null, null, ‘开平区‘, ‘130200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130207‘, null, ‘2‘, null, null, ‘丰南区‘, ‘130200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130208‘, null, ‘2‘, null, null, ‘丰润区‘, ‘130200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130209‘, null, ‘2‘, null, null, ‘曹妃甸区‘, ‘130200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130223‘, null, ‘2‘, null, null, ‘滦县‘, ‘130200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130224‘, null, ‘2‘, null, null, ‘滦南县‘, ‘130200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130225‘, null, ‘2‘, null, null, ‘乐亭县‘, ‘130200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130227‘, null, ‘2‘, null, null, ‘迁西县‘, ‘130200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130229‘, null, ‘2‘, null, null, ‘玉田县‘, ‘130200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130281‘, null, ‘2‘, null, null, ‘遵化市‘, ‘130200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130283‘, null, ‘2‘, null, null, ‘迁安市‘, ‘130200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130300‘, null, ‘1‘, ‘秦皇岛市‘, ‘130000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘130301‘, null, ‘2‘, null, null, ‘市辖区‘, ‘130300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130302‘, null, ‘2‘, null, null, ‘海港区‘, ‘130300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130303‘, null, ‘2‘, null, null, ‘山海关区‘, ‘130300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130304‘, null, ‘2‘, null, null, ‘北戴河区‘, ‘130300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130321‘, null, ‘2‘, null, null, ‘青龙满族自治县‘, ‘130300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130322‘, null, ‘2‘, null, null, ‘昌黎县‘, ‘130300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130323‘, null, ‘2‘, null, null, ‘抚宁县‘, ‘130300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130324‘, null, ‘2‘, null, null, ‘卢龙县‘, ‘130300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130400‘, null, ‘1‘, ‘邯郸市‘, ‘130000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘130401‘, null, ‘2‘, null, null, ‘市辖区‘, ‘130400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130402‘, null, ‘2‘, null, null, ‘邯山区‘, ‘130400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130403‘, null, ‘2‘, null, null, ‘丛台区‘, ‘130400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130404‘, null, ‘2‘, null, null, ‘复兴区‘, ‘130400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130406‘, null, ‘2‘, null, null, ‘峰峰矿区‘, ‘130400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130421‘, null, ‘2‘, null, null, ‘邯郸县‘, ‘130400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130423‘, null, ‘2‘, null, null, ‘临漳县‘, ‘130400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130424‘, null, ‘2‘, null, null, ‘成安县‘, ‘130400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130425‘, null, ‘2‘, null, null, ‘大名县‘, ‘130400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130426‘, null, ‘2‘, null, null, ‘涉县‘, ‘130400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130427‘, null, ‘2‘, null, null, ‘磁县‘, ‘130400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130428‘, null, ‘2‘, null, null, ‘肥乡县‘, ‘130400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130429‘, null, ‘2‘, null, null, ‘永年县‘, ‘130400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130430‘, null, ‘2‘, null, null, ‘邱县‘, ‘130400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130431‘, null, ‘2‘, null, null, ‘鸡泽县‘, ‘130400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130432‘, null, ‘2‘, null, null, ‘广平县‘, ‘130400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130433‘, null, ‘2‘, null, null, ‘馆陶县‘, ‘130400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130434‘, null, ‘2‘, null, null, ‘魏县‘, ‘130400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130435‘, null, ‘2‘, null, null, ‘曲周县‘, ‘130400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130481‘, null, ‘2‘, null, null, ‘武安市‘, ‘130400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130500‘, null, ‘1‘, ‘邢台市‘, ‘130000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘130501‘, null, ‘2‘, null, null, ‘市辖区‘, ‘130500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130502‘, null, ‘2‘, null, null, ‘桥东区‘, ‘130500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130503‘, null, ‘2‘, null, null, ‘桥西区‘, ‘130500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130521‘, null, ‘2‘, null, null, ‘邢台县‘, ‘130500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130522‘, null, ‘2‘, null, null, ‘临城县‘, ‘130500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130523‘, null, ‘2‘, null, null, ‘内丘县‘, ‘130500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130524‘, null, ‘2‘, null, null, ‘柏乡县‘, ‘130500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130525‘, null, ‘2‘, null, null, ‘隆尧县‘, ‘130500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130526‘, null, ‘2‘, null, null, ‘任县‘, ‘130500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130527‘, null, ‘2‘, null, null, ‘南和县‘, ‘130500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130528‘, null, ‘2‘, null, null, ‘宁晋县‘, ‘130500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130529‘, null, ‘2‘, null, null, ‘巨鹿县‘, ‘130500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130530‘, null, ‘2‘, null, null, ‘新河县‘, ‘130500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130531‘, null, ‘2‘, null, null, ‘广宗县‘, ‘130500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130532‘, null, ‘2‘, null, null, ‘平乡县‘, ‘130500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130533‘, null, ‘2‘, null, null, ‘威县‘, ‘130500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130534‘, null, ‘2‘, null, null, ‘清河县‘, ‘130500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130535‘, null, ‘2‘, null, null, ‘临西县‘, ‘130500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130581‘, null, ‘2‘, null, null, ‘南宫市‘, ‘130500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130582‘, null, ‘2‘, null, null, ‘沙河市‘, ‘130500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130600‘, null, ‘1‘, ‘保定市‘, ‘130000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘130601‘, null, ‘2‘, null, null, ‘市辖区‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130602‘, null, ‘2‘, null, null, ‘新市区‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130603‘, null, ‘2‘, null, null, ‘北市区‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130604‘, null, ‘2‘, null, null, ‘南市区‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130621‘, null, ‘2‘, null, null, ‘满城县‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130622‘, null, ‘2‘, null, null, ‘清苑县‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130623‘, null, ‘2‘, null, null, ‘涞水县‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130624‘, null, ‘2‘, null, null, ‘阜平县‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130625‘, null, ‘2‘, null, null, ‘徐水县‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130626‘, null, ‘2‘, null, null, ‘定兴县‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130627‘, null, ‘2‘, null, null, ‘唐县‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130628‘, null, ‘2‘, null, null, ‘高阳县‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130629‘, null, ‘2‘, null, null, ‘容城县‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130630‘, null, ‘2‘, null, null, ‘涞源县‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130631‘, null, ‘2‘, null, null, ‘望都县‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130632‘, null, ‘2‘, null, null, ‘安新县‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130633‘, null, ‘2‘, null, null, ‘易县‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130634‘, null, ‘2‘, null, null, ‘曲阳县‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130635‘, null, ‘2‘, null, null, ‘蠡县‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130636‘, null, ‘2‘, null, null, ‘顺平县‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130637‘, null, ‘2‘, null, null, ‘博野县‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130638‘, null, ‘2‘, null, null, ‘雄县‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130681‘, null, ‘2‘, null, null, ‘涿州市‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130682‘, null, ‘2‘, null, null, ‘定州市‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130683‘, null, ‘2‘, null, null, ‘安国市‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130684‘, null, ‘2‘, null, null, ‘高碑店市‘, ‘130600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130700‘, null, ‘1‘, ‘张家口市‘, ‘130000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘130701‘, null, ‘2‘, null, null, ‘市辖区‘, ‘130700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130702‘, null, ‘2‘, null, null, ‘桥东区‘, ‘130700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130703‘, null, ‘2‘, null, null, ‘桥西区‘, ‘130700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130705‘, null, ‘2‘, null, null, ‘宣化区‘, ‘130700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130706‘, null, ‘2‘, null, null, ‘下花园区‘, ‘130700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130721‘, null, ‘2‘, null, null, ‘宣化县‘, ‘130700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130722‘, null, ‘2‘, null, null, ‘张北县‘, ‘130700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130723‘, null, ‘2‘, null, null, ‘康保县‘, ‘130700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130724‘, null, ‘2‘, null, null, ‘沽源县‘, ‘130700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130725‘, null, ‘2‘, null, null, ‘尚义县‘, ‘130700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130726‘, null, ‘2‘, null, null, ‘蔚县‘, ‘130700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130727‘, null, ‘2‘, null, null, ‘阳原县‘, ‘130700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130728‘, null, ‘2‘, null, null, ‘怀安县‘, ‘130700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130729‘, null, ‘2‘, null, null, ‘万全县‘, ‘130700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130730‘, null, ‘2‘, null, null, ‘怀来县‘, ‘130700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130731‘, null, ‘2‘, null, null, ‘涿鹿县‘, ‘130700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130732‘, null, ‘2‘, null, null, ‘赤城县‘, ‘130700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130733‘, null, ‘2‘, null, null, ‘崇礼县‘, ‘130700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130800‘, null, ‘1‘, ‘承德市‘, ‘130000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘130801‘, null, ‘2‘, null, null, ‘市辖区‘, ‘130800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130802‘, null, ‘2‘, null, null, ‘双桥区‘, ‘130800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130803‘, null, ‘2‘, null, null, ‘双滦区‘, ‘130800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130804‘, null, ‘2‘, null, null, ‘鹰手营子矿区‘, ‘130800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130821‘, null, ‘2‘, null, null, ‘承德县‘, ‘130800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130822‘, null, ‘2‘, null, null, ‘兴隆县‘, ‘130800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130823‘, null, ‘2‘, null, null, ‘平泉县‘, ‘130800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130824‘, null, ‘2‘, null, null, ‘滦平县‘, ‘130800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130825‘, null, ‘2‘, null, null, ‘隆化县‘, ‘130800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130826‘, null, ‘2‘, null, null, ‘丰宁满族自治县‘, ‘130800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130827‘, null, ‘2‘, null, null, ‘宽城满族自治县‘, ‘130800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130828‘, null, ‘2‘, null, null, ‘围场满族蒙古族自治县‘, ‘130800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130900‘, null, ‘1‘, ‘沧州市‘, ‘130000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘130901‘, null, ‘2‘, null, null, ‘市辖区‘, ‘130900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130902‘, null, ‘2‘, null, null, ‘新华区‘, ‘130900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130903‘, null, ‘2‘, null, null, ‘运河区‘, ‘130900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130921‘, null, ‘2‘, null, null, ‘沧县‘, ‘130900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130922‘, null, ‘2‘, null, null, ‘青县‘, ‘130900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130923‘, null, ‘2‘, null, null, ‘东光县‘, ‘130900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130924‘, null, ‘2‘, null, null, ‘海兴县‘, ‘130900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130925‘, null, ‘2‘, null, null, ‘盐山县‘, ‘130900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130926‘, null, ‘2‘, null, null, ‘肃宁县‘, ‘130900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130927‘, null, ‘2‘, null, null, ‘南皮县‘, ‘130900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130928‘, null, ‘2‘, null, null, ‘吴桥县‘, ‘130900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130929‘, null, ‘2‘, null, null, ‘献县‘, ‘130900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130930‘, null, ‘2‘, null, null, ‘孟村回族自治县‘, ‘130900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130981‘, null, ‘2‘, null, null, ‘泊头市‘, ‘130900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130982‘, null, ‘2‘, null, null, ‘任丘市‘, ‘130900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130983‘, null, ‘2‘, null, null, ‘黄骅市‘, ‘130900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘130984‘, null, ‘2‘, null, null, ‘河间市‘, ‘130900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘131000‘, null, ‘1‘, ‘廊坊市‘, ‘130000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘131001‘, null, ‘2‘, null, null, ‘市辖区‘, ‘131000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘131002‘, null, ‘2‘, null, null, ‘安次区‘, ‘131000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘131003‘, null, ‘2‘, null, null, ‘广阳区‘, ‘131000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘131022‘, null, ‘2‘, null, null, ‘固安县‘, ‘131000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘131023‘, null, ‘2‘, null, null, ‘永清县‘, ‘131000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘131024‘, null, ‘2‘, null, null, ‘香河县‘, ‘131000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘131025‘, null, ‘2‘, null, null, ‘大城县‘, ‘131000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘131026‘, null, ‘2‘, null, null, ‘文安县‘, ‘131000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘131028‘, null, ‘2‘, null, null, ‘大厂回族自治县‘, ‘131000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘131081‘, null, ‘2‘, null, null, ‘霸州市‘, ‘131000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘131082‘, null, ‘2‘, null, null, ‘三河市‘, ‘131000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘131100‘, null, ‘1‘, ‘衡水市‘, ‘130000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘131101‘, null, ‘2‘, null, null, ‘市辖区‘, ‘131100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘131102‘, null, ‘2‘, null, null, ‘桃城区‘, ‘131100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘131121‘, null, ‘2‘, null, null, ‘枣强县‘, ‘131100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘131122‘, null, ‘2‘, null, null, ‘武邑县‘, ‘131100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘131123‘, null, ‘2‘, null, null, ‘武强县‘, ‘131100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘131124‘, null, ‘2‘, null, null, ‘饶阳县‘, ‘131100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘131125‘, null, ‘2‘, null, null, ‘安平县‘, ‘131100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘131126‘, null, ‘2‘, null, null, ‘故城县‘, ‘131100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘131127‘, null, ‘2‘, null, null, ‘景县‘, ‘131100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘131128‘, null, ‘2‘, null, null, ‘阜城县‘, ‘131100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘131181‘, null, ‘2‘, null, null, ‘冀州市‘, ‘131100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘131182‘, null, ‘2‘, null, null, ‘深州市‘, ‘131100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140000‘, ‘山西省‘, ‘0‘, null, null, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘140100‘, null, ‘1‘, ‘太原市‘, ‘140000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘140101‘, null, ‘2‘, null, null, ‘市辖区‘, ‘140100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140105‘, null, ‘2‘, null, null, ‘小店区‘, ‘140100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140106‘, null, ‘2‘, null, null, ‘迎泽区‘, ‘140100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140107‘, null, ‘2‘, null, null, ‘杏花岭区‘, ‘140100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140108‘, null, ‘2‘, null, null, ‘尖草坪区‘, ‘140100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140109‘, null, ‘2‘, null, null, ‘万柏林区‘, ‘140100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140110‘, null, ‘2‘, null, null, ‘晋源区‘, ‘140100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140121‘, null, ‘2‘, null, null, ‘清徐县‘, ‘140100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140122‘, null, ‘2‘, null, null, ‘阳曲县‘, ‘140100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140123‘, null, ‘2‘, null, null, ‘娄烦县‘, ‘140100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140181‘, null, ‘2‘, null, null, ‘古交市‘, ‘140100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140200‘, null, ‘1‘, ‘大同市‘, ‘140000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘140201‘, null, ‘2‘, null, null, ‘市辖区‘, ‘140200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140202‘, null, ‘2‘, null, null, ‘城区‘, ‘140200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140203‘, null, ‘2‘, null, null, ‘矿区‘, ‘140200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140211‘, null, ‘2‘, null, null, ‘南郊区‘, ‘140200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140212‘, null, ‘2‘, null, null, ‘新荣区‘, ‘140200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140221‘, null, ‘2‘, null, null, ‘阳高县‘, ‘140200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140222‘, null, ‘2‘, null, null, ‘天镇县‘, ‘140200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140223‘, null, ‘2‘, null, null, ‘广灵县‘, ‘140200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140224‘, null, ‘2‘, null, null, ‘灵丘县‘, ‘140200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140225‘, null, ‘2‘, null, null, ‘浑源县‘, ‘140200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140226‘, null, ‘2‘, null, null, ‘左云县‘, ‘140200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140227‘, null, ‘2‘, null, null, ‘大同县‘, ‘140200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140300‘, null, ‘1‘, ‘阳泉市‘, ‘140000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘140301‘, null, ‘2‘, null, null, ‘市辖区‘, ‘140300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140302‘, null, ‘2‘, null, null, ‘城区‘, ‘140300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140303‘, null, ‘2‘, null, null, ‘矿区‘, ‘140300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140311‘, null, ‘2‘, null, null, ‘郊区‘, ‘140300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140321‘, null, ‘2‘, null, null, ‘平定县‘, ‘140300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140322‘, null, ‘2‘, null, null, ‘盂县‘, ‘140300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140400‘, null, ‘1‘, ‘长治市‘, ‘140000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘140401‘, null, ‘2‘, null, null, ‘市辖区‘, ‘140400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140402‘, null, ‘2‘, null, null, ‘城区‘, ‘140400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140411‘, null, ‘2‘, null, null, ‘郊区‘, ‘140400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140421‘, null, ‘2‘, null, null, ‘长治县‘, ‘140400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140423‘, null, ‘2‘, null, null, ‘襄垣县‘, ‘140400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140424‘, null, ‘2‘, null, null, ‘屯留县‘, ‘140400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140425‘, null, ‘2‘, null, null, ‘平顺县‘, ‘140400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140426‘, null, ‘2‘, null, null, ‘黎城县‘, ‘140400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140427‘, null, ‘2‘, null, null, ‘壶关县‘, ‘140400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140428‘, null, ‘2‘, null, null, ‘长子县‘, ‘140400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140429‘, null, ‘2‘, null, null, ‘武乡县‘, ‘140400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140430‘, null, ‘2‘, null, null, ‘沁县‘, ‘140400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140431‘, null, ‘2‘, null, null, ‘沁源县‘, ‘140400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140481‘, null, ‘2‘, null, null, ‘潞城市‘, ‘140400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140500‘, null, ‘1‘, ‘晋城市‘, ‘140000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘140501‘, null, ‘2‘, null, null, ‘市辖区‘, ‘140500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140502‘, null, ‘2‘, null, null, ‘城区‘, ‘140500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140521‘, null, ‘2‘, null, null, ‘沁水县‘, ‘140500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140522‘, null, ‘2‘, null, null, ‘阳城县‘, ‘140500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140524‘, null, ‘2‘, null, null, ‘陵川县‘, ‘140500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140525‘, null, ‘2‘, null, null, ‘泽州县‘, ‘140500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140581‘, null, ‘2‘, null, null, ‘高平市‘, ‘140500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140600‘, null, ‘1‘, ‘朔州市‘, ‘140000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘140601‘, null, ‘2‘, null, null, ‘市辖区‘, ‘140600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140602‘, null, ‘2‘, null, null, ‘朔城区‘, ‘140600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140603‘, null, ‘2‘, null, null, ‘平鲁区‘, ‘140600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140621‘, null, ‘2‘, null, null, ‘山阴县‘, ‘140600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140622‘, null, ‘2‘, null, null, ‘应县‘, ‘140600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140623‘, null, ‘2‘, null, null, ‘右玉县‘, ‘140600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140624‘, null, ‘2‘, null, null, ‘怀仁县‘, ‘140600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140700‘, null, ‘1‘, ‘晋中市‘, ‘140000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘140701‘, null, ‘2‘, null, null, ‘市辖区‘, ‘140700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140702‘, null, ‘2‘, null, null, ‘榆次区‘, ‘140700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140721‘, null, ‘2‘, null, null, ‘榆社县‘, ‘140700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140722‘, null, ‘2‘, null, null, ‘左权县‘, ‘140700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140723‘, null, ‘2‘, null, null, ‘和顺县‘, ‘140700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140724‘, null, ‘2‘, null, null, ‘昔阳县‘, ‘140700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140725‘, null, ‘2‘, null, null, ‘寿阳县‘, ‘140700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140726‘, null, ‘2‘, null, null, ‘太谷县‘, ‘140700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140727‘, null, ‘2‘, null, null, ‘祁县‘, ‘140700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140728‘, null, ‘2‘, null, null, ‘平遥县‘, ‘140700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140729‘, null, ‘2‘, null, null, ‘灵石县‘, ‘140700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140781‘, null, ‘2‘, null, null, ‘介休市‘, ‘140700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140800‘, null, ‘1‘, ‘运城市‘, ‘140000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘140801‘, null, ‘2‘, null, null, ‘市辖区‘, ‘140800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140802‘, null, ‘2‘, null, null, ‘盐湖区‘, ‘140800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140821‘, null, ‘2‘, null, null, ‘临猗县‘, ‘140800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140822‘, null, ‘2‘, null, null, ‘万荣县‘, ‘140800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140823‘, null, ‘2‘, null, null, ‘闻喜县‘, ‘140800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140824‘, null, ‘2‘, null, null, ‘稷山县‘, ‘140800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140825‘, null, ‘2‘, null, null, ‘新绛县‘, ‘140800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140826‘, null, ‘2‘, null, null, ‘绛县‘, ‘140800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140827‘, null, ‘2‘, null, null, ‘垣曲县‘, ‘140800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140828‘, null, ‘2‘, null, null, ‘夏县‘, ‘140800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140829‘, null, ‘2‘, null, null, ‘平陆县‘, ‘140800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140830‘, null, ‘2‘, null, null, ‘芮城县‘, ‘140800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140881‘, null, ‘2‘, null, null, ‘永济市‘, ‘140800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140882‘, null, ‘2‘, null, null, ‘河津市‘, ‘140800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140900‘, null, ‘1‘, ‘忻州市‘, ‘140000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘140901‘, null, ‘2‘, null, null, ‘市辖区‘, ‘140900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140902‘, null, ‘2‘, null, null, ‘忻府区‘, ‘140900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140921‘, null, ‘2‘, null, null, ‘定襄县‘, ‘140900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140922‘, null, ‘2‘, null, null, ‘五台县‘, ‘140900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140923‘, null, ‘2‘, null, null, ‘代县‘, ‘140900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140924‘, null, ‘2‘, null, null, ‘繁峙县‘, ‘140900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140925‘, null, ‘2‘, null, null, ‘宁武县‘, ‘140900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140926‘, null, ‘2‘, null, null, ‘静乐县‘, ‘140900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140927‘, null, ‘2‘, null, null, ‘神池县‘, ‘140900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140928‘, null, ‘2‘, null, null, ‘五寨县‘, ‘140900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140929‘, null, ‘2‘, null, null, ‘岢岚县‘, ‘140900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140930‘, null, ‘2‘, null, null, ‘河曲县‘, ‘140900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140931‘, null, ‘2‘, null, null, ‘保德县‘, ‘140900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140932‘, null, ‘2‘, null, null, ‘偏关县‘, ‘140900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘140981‘, null, ‘2‘, null, null, ‘原平市‘, ‘140900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141000‘, null, ‘1‘, ‘临汾市‘, ‘140000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘141001‘, null, ‘2‘, null, null, ‘市辖区‘, ‘141000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141002‘, null, ‘2‘, null, null, ‘尧都区‘, ‘141000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141021‘, null, ‘2‘, null, null, ‘曲沃县‘, ‘141000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141022‘, null, ‘2‘, null, null, ‘翼城县‘, ‘141000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141023‘, null, ‘2‘, null, null, ‘襄汾县‘, ‘141000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141024‘, null, ‘2‘, null, null, ‘洪洞县‘, ‘141000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141025‘, null, ‘2‘, null, null, ‘古县‘, ‘141000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141026‘, null, ‘2‘, null, null, ‘安泽县‘, ‘141000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141027‘, null, ‘2‘, null, null, ‘浮山县‘, ‘141000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141028‘, null, ‘2‘, null, null, ‘吉县‘, ‘141000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141029‘, null, ‘2‘, null, null, ‘乡宁县‘, ‘141000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141030‘, null, ‘2‘, null, null, ‘大宁县‘, ‘141000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141031‘, null, ‘2‘, null, null, ‘隰县‘, ‘141000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141032‘, null, ‘2‘, null, null, ‘永和县‘, ‘141000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141033‘, null, ‘2‘, null, null, ‘蒲县‘, ‘141000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141034‘, null, ‘2‘, null, null, ‘汾西县‘, ‘141000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141081‘, null, ‘2‘, null, null, ‘侯马市‘, ‘141000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141082‘, null, ‘2‘, null, null, ‘霍州市‘, ‘141000‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141100‘, null, ‘1‘, ‘吕梁市‘, ‘140000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘141101‘, null, ‘2‘, null, null, ‘市辖区‘, ‘141100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141102‘, null, ‘2‘, null, null, ‘离石区‘, ‘141100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141121‘, null, ‘2‘, null, null, ‘文水县‘, ‘141100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141122‘, null, ‘2‘, null, null, ‘交城县‘, ‘141100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141123‘, null, ‘2‘, null, null, ‘兴县‘, ‘141100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141124‘, null, ‘2‘, null, null, ‘临县‘, ‘141100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141125‘, null, ‘2‘, null, null, ‘柳林县‘, ‘141100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141126‘, null, ‘2‘, null, null, ‘石楼县‘, ‘141100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141127‘, null, ‘2‘, null, null, ‘岚县‘, ‘141100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141128‘, null, ‘2‘, null, null, ‘方山县‘, ‘141100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141129‘, null, ‘2‘, null, null, ‘中阳县‘, ‘141100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141130‘, null, ‘2‘, null, null, ‘交口县‘, ‘141100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141181‘, null, ‘2‘, null, null, ‘孝义市‘, ‘141100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘141182‘, null, ‘2‘, null, null, ‘汾阳市‘, ‘141100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150000‘, ‘内蒙古自治区‘, ‘0‘, null, null, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘150100‘, null, ‘1‘, ‘呼和浩特市‘, ‘150000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘150101‘, null, ‘2‘, null, null, ‘市辖区‘, ‘150100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150102‘, null, ‘2‘, null, null, ‘新城区‘, ‘150100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150103‘, null, ‘2‘, null, null, ‘回民区‘, ‘150100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150104‘, null, ‘2‘, null, null, ‘玉泉区‘, ‘150100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150105‘, null, ‘2‘, null, null, ‘赛罕区‘, ‘150100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150121‘, null, ‘2‘, null, null, ‘土默特左旗‘, ‘150100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150122‘, null, ‘2‘, null, null, ‘托克托县‘, ‘150100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150123‘, null, ‘2‘, null, null, ‘和林格尔县‘, ‘150100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150124‘, null, ‘2‘, null, null, ‘清水河县‘, ‘150100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150125‘, null, ‘2‘, null, null, ‘武川县‘, ‘150100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150200‘, null, ‘1‘, ‘包头市‘, ‘150000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘150201‘, null, ‘2‘, null, null, ‘市辖区‘, ‘150200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150202‘, null, ‘2‘, null, null, ‘东河区‘, ‘150200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150203‘, null, ‘2‘, null, null, ‘昆都仑区‘, ‘150200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150204‘, null, ‘2‘, null, null, ‘青山区‘, ‘150200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150205‘, null, ‘2‘, null, null, ‘石拐区‘, ‘150200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150206‘, null, ‘2‘, null, null, ‘白云鄂博矿区‘, ‘150200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150207‘, null, ‘2‘, null, null, ‘九原区‘, ‘150200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150221‘, null, ‘2‘, null, null, ‘土默特右旗‘, ‘150200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150222‘, null, ‘2‘, null, null, ‘固阳县‘, ‘150200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150223‘, null, ‘2‘, null, null, ‘达尔罕茂明安联合旗‘, ‘150200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150300‘, null, ‘1‘, ‘乌海市‘, ‘150000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘150301‘, null, ‘2‘, null, null, ‘市辖区‘, ‘150300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150302‘, null, ‘2‘, null, null, ‘海勃湾区‘, ‘150300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150303‘, null, ‘2‘, null, null, ‘海南区‘, ‘150300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150304‘, null, ‘2‘, null, null, ‘乌达区‘, ‘150300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150400‘, null, ‘1‘, ‘赤峰市‘, ‘150000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘150401‘, null, ‘2‘, null, null, ‘市辖区‘, ‘150400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150402‘, null, ‘2‘, null, null, ‘红山区‘, ‘150400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150403‘, null, ‘2‘, null, null, ‘元宝山区‘, ‘150400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150404‘, null, ‘2‘, null, null, ‘松山区‘, ‘150400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150421‘, null, ‘2‘, null, null, ‘阿鲁科尔沁旗‘, ‘150400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150422‘, null, ‘2‘, null, null, ‘巴林左旗‘, ‘150400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150423‘, null, ‘2‘, null, null, ‘巴林右旗‘, ‘150400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150424‘, null, ‘2‘, null, null, ‘林西县‘, ‘150400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150425‘, null, ‘2‘, null, null, ‘克什克腾旗‘, ‘150400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150426‘, null, ‘2‘, null, null, ‘翁牛特旗‘, ‘150400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150428‘, null, ‘2‘, null, null, ‘喀喇沁旗‘, ‘150400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150429‘, null, ‘2‘, null, null, ‘宁城县‘, ‘150400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150430‘, null, ‘2‘, null, null, ‘敖汉旗‘, ‘150400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150500‘, null, ‘1‘, ‘通辽市‘, ‘150000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘150501‘, null, ‘2‘, null, null, ‘市辖区‘, ‘150500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150502‘, null, ‘2‘, null, null, ‘科尔沁区‘, ‘150500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150521‘, null, ‘2‘, null, null, ‘科尔沁左翼中旗‘, ‘150500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150522‘, null, ‘2‘, null, null, ‘科尔沁左翼后旗‘, ‘150500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150523‘, null, ‘2‘, null, null, ‘开鲁县‘, ‘150500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150524‘, null, ‘2‘, null, null, ‘库伦旗‘, ‘150500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150525‘, null, ‘2‘, null, null, ‘奈曼旗‘, ‘150500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150526‘, null, ‘2‘, null, null, ‘扎鲁特旗‘, ‘150500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150581‘, null, ‘2‘, null, null, ‘霍林郭勒市‘, ‘150500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150600‘, null, ‘1‘, ‘鄂尔多斯市‘, ‘150000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘150601‘, null, ‘2‘, null, null, ‘市辖区‘, ‘150600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150602‘, null, ‘2‘, null, null, ‘东胜区‘, ‘150600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150621‘, null, ‘2‘, null, null, ‘达拉特旗‘, ‘150600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150622‘, null, ‘2‘, null, null, ‘准格尔旗‘, ‘150600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150623‘, null, ‘2‘, null, null, ‘鄂托克前旗‘, ‘150600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150624‘, null, ‘2‘, null, null, ‘鄂托克旗‘, ‘150600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150625‘, null, ‘2‘, null, null, ‘杭锦旗‘, ‘150600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150626‘, null, ‘2‘, null, null, ‘乌审旗‘, ‘150600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150627‘, null, ‘2‘, null, null, ‘伊金霍洛旗‘, ‘150600‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150700‘, null, ‘1‘, ‘呼伦贝尔市‘, ‘150000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘150701‘, null, ‘2‘, null, null, ‘市辖区‘, ‘150700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150702‘, null, ‘2‘, null, null, ‘海拉尔区‘, ‘150700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150703‘, null, ‘2‘, null, null, ‘扎赉诺尔区‘, ‘150700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150721‘, null, ‘2‘, null, null, ‘阿荣旗‘, ‘150700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150722‘, null, ‘2‘, null, null, ‘莫力达瓦达斡尔族自治旗‘, ‘150700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150723‘, null, ‘2‘, null, null, ‘鄂伦春自治旗‘, ‘150700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150724‘, null, ‘2‘, null, null, ‘鄂温克族自治旗‘, ‘150700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150725‘, null, ‘2‘, null, null, ‘陈巴尔虎旗‘, ‘150700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150726‘, null, ‘2‘, null, null, ‘新巴尔虎左旗‘, ‘150700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150727‘, null, ‘2‘, null, null, ‘新巴尔虎右旗‘, ‘150700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150781‘, null, ‘2‘, null, null, ‘满洲里市‘, ‘150700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150782‘, null, ‘2‘, null, null, ‘牙克石市‘, ‘150700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150783‘, null, ‘2‘, null, null, ‘扎兰屯市‘, ‘150700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150784‘, null, ‘2‘, null, null, ‘额尔古纳市‘, ‘150700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150785‘, null, ‘2‘, null, null, ‘根河市‘, ‘150700‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150800‘, null, ‘1‘, ‘巴彦淖尔市‘, ‘150000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘150801‘, null, ‘2‘, null, null, ‘市辖区‘, ‘150800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150802‘, null, ‘2‘, null, null, ‘临河区‘, ‘150800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150821‘, null, ‘2‘, null, null, ‘五原县‘, ‘150800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150822‘, null, ‘2‘, null, null, ‘磴口县‘, ‘150800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150823‘, null, ‘2‘, null, null, ‘乌拉特前旗‘, ‘150800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150824‘, null, ‘2‘, null, null, ‘乌拉特中旗‘, ‘150800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150825‘, null, ‘2‘, null, null, ‘乌拉特后旗‘, ‘150800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150826‘, null, ‘2‘, null, null, ‘杭锦后旗‘, ‘150800‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150900‘, null, ‘1‘, ‘乌兰察布市‘, ‘150000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘150901‘, null, ‘2‘, null, null, ‘市辖区‘, ‘150900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150902‘, null, ‘2‘, null, null, ‘集宁区‘, ‘150900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150921‘, null, ‘2‘, null, null, ‘卓资县‘, ‘150900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150922‘, null, ‘2‘, null, null, ‘化德县‘, ‘150900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150923‘, null, ‘2‘, null, null, ‘商都县‘, ‘150900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150924‘, null, ‘2‘, null, null, ‘兴和县‘, ‘150900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150925‘, null, ‘2‘, null, null, ‘凉城县‘, ‘150900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150926‘, null, ‘2‘, null, null, ‘察哈尔右翼前旗‘, ‘150900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150927‘, null, ‘2‘, null, null, ‘察哈尔右翼中旗‘, ‘150900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150928‘, null, ‘2‘, null, null, ‘察哈尔右翼后旗‘, ‘150900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150929‘, null, ‘2‘, null, null, ‘四子王旗‘, ‘150900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘150981‘, null, ‘2‘, null, null, ‘丰镇市‘, ‘150900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘152200‘, null, ‘1‘, ‘兴安盟‘, ‘150000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘152201‘, null, ‘2‘, null, null, ‘乌兰浩特市‘, ‘152200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘152202‘, null, ‘2‘, null, null, ‘阿尔山市‘, ‘152200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘152221‘, null, ‘2‘, null, null, ‘科尔沁右翼前旗‘, ‘152200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘152222‘, null, ‘2‘, null, null, ‘科尔沁右翼中旗‘, ‘152200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘152223‘, null, ‘2‘, null, null, ‘扎赉特旗‘, ‘152200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘152224‘, null, ‘2‘, null, null, ‘突泉县‘, ‘152200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘152500‘, null, ‘1‘, ‘锡林郭勒盟‘, ‘150000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘152501‘, null, ‘2‘, null, null, ‘二连浩特市‘, ‘152500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘152502‘, null, ‘2‘, null, null, ‘锡林浩特市‘, ‘152500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘152522‘, null, ‘2‘, null, null, ‘阿巴嘎旗‘, ‘152500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘152523‘, null, ‘2‘, null, null, ‘苏尼特左旗‘, ‘152500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘152524‘, null, ‘2‘, null, null, ‘苏尼特右旗‘, ‘152500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘152525‘, null, ‘2‘, null, null, ‘东乌珠穆沁旗‘, ‘152500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘152526‘, null, ‘2‘, null, null, ‘西乌珠穆沁旗‘, ‘152500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘152527‘, null, ‘2‘, null, null, ‘太仆寺旗‘, ‘152500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘152528‘, null, ‘2‘, null, null, ‘镶黄旗‘, ‘152500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘152529‘, null, ‘2‘, null, null, ‘正镶白旗‘, ‘152500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘152530‘, null, ‘2‘, null, null, ‘正蓝旗‘, ‘152500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘152531‘, null, ‘2‘, null, null, ‘多伦县‘, ‘152500‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘152900‘, null, ‘1‘, ‘阿拉善盟‘, ‘150000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘152921‘, null, ‘2‘, null, null, ‘阿拉善左旗‘, ‘152900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘152922‘, null, ‘2‘, null, null, ‘阿拉善右旗‘, ‘152900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘152923‘, null, ‘2‘, null, null, ‘额济纳旗‘, ‘152900‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210000‘, ‘辽宁省‘, ‘0‘, null, null, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘210100‘, null, ‘1‘, ‘沈阳市‘, ‘210000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘210101‘, null, ‘2‘, null, null, ‘市辖区‘, ‘210100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210102‘, null, ‘2‘, null, null, ‘和平区‘, ‘210100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210103‘, null, ‘2‘, null, null, ‘沈河区‘, ‘210100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210104‘, null, ‘2‘, null, null, ‘大东区‘, ‘210100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210105‘, null, ‘2‘, null, null, ‘皇姑区‘, ‘210100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210106‘, null, ‘2‘, null, null, ‘铁西区‘, ‘210100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210111‘, null, ‘2‘, null, null, ‘苏家屯区‘, ‘210100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210112‘, null, ‘2‘, null, null, ‘浑南区‘, ‘210100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210113‘, null, ‘2‘, null, null, ‘沈北新区‘, ‘210100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210114‘, null, ‘2‘, null, null, ‘于洪区‘, ‘210100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210122‘, null, ‘2‘, null, null, ‘辽中县‘, ‘210100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210123‘, null, ‘2‘, null, null, ‘康平县‘, ‘210100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210124‘, null, ‘2‘, null, null, ‘法库县‘, ‘210100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210181‘, null, ‘2‘, null, null, ‘新民市‘, ‘210100‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210200‘, null, ‘1‘, ‘大连市‘, ‘210000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘210201‘, null, ‘2‘, null, null, ‘市辖区‘, ‘210200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210202‘, null, ‘2‘, null, null, ‘中山区‘, ‘210200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210203‘, null, ‘2‘, null, null, ‘西岗区‘, ‘210200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210204‘, null, ‘2‘, null, null, ‘沙河口区‘, ‘210200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210211‘, null, ‘2‘, null, null, ‘甘井子区‘, ‘210200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210212‘, null, ‘2‘, null, null, ‘旅顺口区‘, ‘210200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210213‘, null, ‘2‘, null, null, ‘金州区‘, ‘210200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210224‘, null, ‘2‘, null, null, ‘长海县‘, ‘210200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210281‘, null, ‘2‘, null, null, ‘瓦房店市‘, ‘210200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210282‘, null, ‘2‘, null, null, ‘普兰店市‘, ‘210200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210283‘, null, ‘2‘, null, null, ‘庄河市‘, ‘210200‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210300‘, null, ‘1‘, ‘鞍山市‘, ‘210000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘210301‘, null, ‘2‘, null, null, ‘市辖区‘, ‘210300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210302‘, null, ‘2‘, null, null, ‘铁东区‘, ‘210300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210303‘, null, ‘2‘, null, null, ‘铁西区‘, ‘210300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210304‘, null, ‘2‘, null, null, ‘立山区‘, ‘210300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210311‘, null, ‘2‘, null, null, ‘千山区‘, ‘210300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210321‘, null, ‘2‘, null, null, ‘台安县‘, ‘210300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210323‘, null, ‘2‘, null, null, ‘岫岩满族自治县‘, ‘210300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210381‘, null, ‘2‘, null, null, ‘海城市‘, ‘210300‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210400‘, null, ‘1‘, ‘抚顺市‘, ‘210000‘, null, null);
INSERT INTO `sys_prov_city_dist` VALUES (‘210401‘, null, ‘2‘, null, null, ‘市辖区‘, ‘210400‘);
INSERT INTO `sys_prov_city_dist` VALUES (‘210402‘, null, ‘2‘, null, null, ‘新抚区‘, ‘210400<

人气教程排行