省市县级联表-数据库创建(一)

已于 2024-03-07 13:07:55 修改
阅读量533 收藏 7
点赞数 12
分类专栏： 表设计 Mysql 文章标签： 数据库 java mysql
于 2024-03-07 11:59:57 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_58353992/article/details/136528057
版权

创建数据库


DROP TABLE IF EXISTS `sys_address`;
CREATE TABLE `sys_address`  (
  `region_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '地区主键编号',
  `region_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '地区名称',
  `region_short_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地区缩写',
  `region_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '行政地区编号',
  `region_parent_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地区父id',
  `region_level` int(2) NULL DEFAULT NULL COMMENT '地区级别 1-省、自治区、直辖市 2-地级市、地区、自治州、盟 3-市辖区、县级市、县',
  PRIMARY KEY (`region_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT = '地区表';

数据

INSERT INTO `sys_address` VALUES ('1000000', '北京市', '京', '110000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000001', '天津市', '津', '120000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000002', '河北省', '冀', '130000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000003', '山西省', '晋', '140000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000004', '内蒙古自治区', '内蒙古', '150000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000005', '辽宁省', '辽', '210000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000006', '吉林省', '吉', '220000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000007', '黑龙江省', '黑', '230000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000008', '上海市', '沪', '310000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000009', '江苏省', '苏', '320000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000010', '浙江省', '浙', '330000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000011', '安徽省', '皖', '340000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000012', '福建省', '闽', '350000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000013', '江西省', '赣', '360000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000014', '山东省', '鲁', '370000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000015', '河南省', '豫', '410000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000016', '湖北省', '鄂', '420000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000017', '湖南省', '湘', '430000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000018', '广东省', '粤', '440000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000019', '广西壮族自治区', '桂', '450000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000020', '海南省', '琼', '460000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000021', '重庆市', '渝', '500000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000022', '四川省', '川、蜀', '510000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000023', '贵州省', '黔、贵', '520000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000024', '云南省', '滇、云', '530000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000025', '西藏自治区', '藏', '540000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000026', '陕西省', '陕、秦', '610000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000027', '甘肃省', '甘、陇', '620000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000028', '青海省', '青', '630000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000029', '宁夏回族自治区', '宁', '640000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000030', '新疆维吾尔自治区', '新', '650000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000031', '香港特别行政区', '港', '810000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000032', '澳门特别行政区', '澳', '820000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000033', '台湾省', '台', '710000', '-1', 1);
INSERT INTO `sys_address` VALUES ('1000034', '东城区', NULL, '110101', '1000000', 2);
INSERT INTO `sys_address` VALUES ('1000035', '西城区', NULL, '110102', '1000000', 2);
INSERT INTO `sys_address` VALUES ('1000036', '朝阳区', NULL, '110105', '1000000', 2);
INSERT INTO `sys_address` VALUES ('1000037', '丰台区', NULL, '110106', '1000000', 2);
INSERT INTO `sys_address` VALUES ('1000038', '石景山区', NULL, '110107', '1000000', 2);
INSERT INTO `sys_address` VALUES ('1000039', '海淀区', NULL, '110108', '1000000', 2);
INSERT INTO `sys_address` VALUES ('1000040', '门头沟区', NULL, '110109', '1000000', 2);
INSERT INTO `sys_address` VALUES ('1000041', '房山区', NULL, '110111', '1000000', 2);
INSERT INTO `sys_address` VALUES ('1000042', '通州区', NULL, '110112', '1000000', 2);
INSERT INTO `sys_address` VALUES ('1000043', '顺义区', NULL, '110113', '1000000', 2);
INSERT INTO `sys_address` VALUES ('1000044', '昌平区', NULL, '110114', '1000000', 2);
INSERT INTO `sys_address` VALUES ('1000045', '大兴区', NULL, '110115', '1000000', 2);
INSERT INTO `sys_address` VALUES ('1000046', '怀柔区', NULL, '110116', '1000000', 2);
INSERT INTO `sys_address` VALUES ('1000047', '平谷区', NULL, '110117', '1000000', 2);
INSERT INTO `sys_address` VALUES ('1000048', '密云区', NULL, '110118', '1000000', 2);
INSERT INTO `sys_address` VALUES ('1000049', '延庆区', NULL, '110119', '1000000', 2);
INSERT INTO `sys_address` VALUES ('1000050', '河西区', NULL, '120103', '1000001', 2);
INSERT INTO `sys_address` VALUES ('1000051', '和平区', NULL, '120101', '1000001', 2);
INSERT INTO `sys_address` VALUES ('1000052', '河东区', NULL, '120102', '1000001', 2);
INSERT INTO `sys_address` VALUES ('1000053', '南开区', NULL, '120104', '1000001', 2);
INSERT INTO `sys_address` VALUES ('1000054', '河北区', NULL, '120105', '1000001', 2);
INSERT INTO `sys_address` VALUES ('1000055', '红桥区', NULL, '120106', '1000001', 2);
INSERT INTO `sys_address` VALUES ('1000056', '东丽区', NULL, '120110', '1000001', 2);
INSERT INTO `sys_address` VALUES ('1000057', '西青区', NULL, '120111', '1000001', 2);
INSERT INTO `sys_address` VALUES ('1000058', '津南区', NULL, '120112', '1000001', 2);
INSERT INTO `sys_address` VALUES ('1000059', '北辰区', NULL, '120113', '1000001', 2);
INSERT INTO `sys_address` VALUES ('1000060', '武清区', NULL, '120114', '1000001', 2);
INSERT INTO `sys_address` VALUES ('1000061', '宝坻区', NULL, '120115', '1000001', 2);
INSERT INTO `sys_address` VALUES ('1000062', '滨海新区', NULL, '120116', '1000001', 2);
INSERT INTO `sys_address` VALUES ('1000063', '宁河区', NULL, '120117', '1000001', 2);
INSERT INTO `sys_address` VALUES ('1000064', '静海区', NULL, '120118', '1000001', 2);
INSERT INTO `sys_address` VALUES ('1000065', '蓟州区', NULL, '120119', '1000001', 2);
INSERT INTO `sys_address` VALUES ('1000066', '石家庄市', NULL, '130100', '1000002', 2);
INSERT INTO `sys_address` VALUES ('1000067', '长安区', NULL, '130102', '1000066', 3);
INSERT INTO `sys_address` VALUES ('1000068', '桥西区', NULL, '130104', '1000066', 3);
INSERT INTO `sys_address` VALUES ('1000069', '新华区', NULL, '130105', '1000066', 3);
INSERT INTO `sys_address` VALUES ('1000070', '井陉矿区', NULL, '130107', '1000066', 3);
INSERT INTO `sys_address` VALUES ('1000071', '裕华区', NULL, '130108', '1000066', 3);
INSERT INTO `sys_address` VALUES ('1000072', '藁城区', NULL, '130109', '1000066', 3);
INSERT INTO `sys_address` VALUES ('1000073', '鹿泉区', NULL, '130110', '1000066', 3);
INSERT INTO `sys_address` VALUES ('1000074', '栾城区', NULL, '130111', '1000066', 3);
INSERT INTO `sys_address` VALUES ('1000075', '辛集市', NULL, '130181', '1000066', 3);
INSERT INTO `sys_address` VALUES ('1000076', '晋州市', NULL, '130183', '1000066', 3);
INSERT INTO `sys_address` VALUES ('1000077', '新乐市', NULL, '130184', '1000066', 3);
INSERT INTO `sys_address` VALUES ('1000078', '井陉县', NULL, '130121', '1000066', 3);
INSERT INTO `sys_address` VALUES ('1000079', '正定县', NULL, '130123', '1000066', 3);
INSERT INTO `sys_address` VALUES ('1000080', '行唐县', NULL, '130125', '1000066', 3);
INSERT INTO `sys_address` VALUES ('1000081', '灵寿县', NULL, '130126', '1000066', 3);
INSERT INTO `sys_address` VALUES ('1000082', '高邑县', NULL, '130127', '1000066', 3);
INSERT INTO `sys_address` VALUES ('1000083', '深泽县', NULL, '130128', '1000066', 3);
INSERT INTO `sys_address` VALUES ('1000084', '赞皇县', NULL, '130129', '1000066', 3);
INSERT INTO `sys_address` VALUES ('1000085', '无极县', NULL, '130130', '1000066', 3);
INSERT INTO `sys_address` VALUES ('1000086', '平山县', NULL, '130131', '1000066', 3);
INSERT INTO `sys_address` VALUES ('1000087', '元氏县', NULL, '130132', '1000066', 3);
INSERT INTO `sys_address` VALUES ('1000088', '赵县', NULL, '130133', '1000066', 3);
INSERT INTO `sys_address` VALUES ('1000089', '唐山市', NULL, '130200', '1000002', 2);
INSERT INTO `sys_address` VALUES ('1000090', '路北区', NULL, '130203', '1000089', 3);
INSERT INTO `sys_address` VALUES ('1000091', '路南区', NULL, '130202', '1000089', 3);
INSERT INTO `sys_address` VALUES ('1000092', '古冶区', NULL, '130204', '1000089', 3);
INSERT INTO `sys_address` VALUES ('1000093', '开平区', NULL, '130205', '1000089', 3);
INSERT INTO `sys_address` VALUES ('1000094', '丰南区', NULL, '130207', '1000089', 3);
INSERT INTO `sys_address` VALUES ('1000095', '丰润区', NULL, '130208', '1000089', 3);
INSERT INTO `sys_address` VALUES ('1000096', '曹妃甸区', NULL, '130209', '1000089', 3);
INSERT INTO `sys_address` VALUES ('1000097', '遵化市', NULL, '130281', '1000089', 3);
INSERT INTO `sys_address` VALUES ('1000098', '迁安市', NULL, '130283', '1000089', 3);
INSERT INTO `sys_address` VALUES ('1000099', '滦县', NULL, '130223', '1000089', 3);
INSERT INTO `sys_address` VALUES ('1000100', '滦南县', NULL, '130224', '1000089', 3);
INSERT INTO `sys_address` VALUES ('1000101', '乐亭县', NULL, '130225', '1000089', 3);
INSERT INTO `sys_address` VALUES ('1000102', '迁西县', NULL, '130227', '1000089', 3);
INSERT INTO `sys_address` VALUES ('1000103', '玉田县', NULL, '130229', '1000089', 3);
INSERT INTO `sys_address` VALUES ('1000104', '秦皇岛市', NULL, '130300', '1000002', 2);
INSERT INTO `sys_address` VALUES ('1000105', '海港区', NULL, '130302', '1000104', 3);
INSERT INTO `sys_address` VALUES ('1000106', '山海关区', NULL, '130303', '1000104', 3);
INSERT INTO `sys_address` VALUES ('1000107', '北戴河区', NULL, '130304', '1000104', 3);
INSERT INTO `sys_address` VALUES ('1000108', '抚宁区', NULL, '130306', '1000104', 3);
INSERT INTO `sys_address` VALUES ('1000109', '昌黎县', NULL, '130322', '1000104', 3);
INSERT INTO `sys_address` VALUES ('1000110', '卢龙县', NULL, '130324', '1000104', 3);
INSERT INTO `sys_address` VALUES ('1000111', '青龙满族自治县', NULL, '130321', '1000104', 3);
INSERT INTO `sys_address` VALUES ('1000112', '邯郸市', NULL, '130400', '1000002', 2);
INSERT INTO `sys_address` VALUES ('1000113', '丛台区', NULL, '130403', '1000112', 3);
INSERT INTO `sys_address` VALUES ('1000114', '邯山区', NULL, '130402', '1000112', 3);
INSERT INTO `sys_address` VALUES ('1000115', '复兴区', NULL, '130404', '1000112', 3);
INSERT INTO `sys_address` VALUES ('1000116', '峰峰矿区', NULL, '130406', '1000112', 3);
INSERT INTO `sys_address` VALUES ('1000117', '肥乡区', NULL, '130407', '1000112', 3);
INSERT INTO `sys_address` VALUES ('1000118', '永年区', NULL, '130408', '1000112', 3);
INSERT INTO `sys_address` VALUES ('1000119', '武安市', NULL, '130481', '1000112', 3);
INSERT INTO `sys_address` VALUES ('1000120', '临漳县', NULL, '130423', '1000112', 3);
INSERT INTO `sys_address` VALUES ('1000121', '成安县', NULL, '130424', '1000112', 3);
INSERT INTO `sys_address` VALUES ('1000122', '大名县', NULL, '130425', '1000112', 3);
INSERT INTO `sys_address` VALUES ('1000123', '涉县', NULL, '130426', '1000112', 3);
INSERT INTO `sys_address` VALUES ('1000124', '磁县', NULL, '130427', '1000112', 3);
INSERT INTO `sys_address` VALUES ('1000125', '邱县', NULL, '130430', '1000112', 3);
INSERT INTO `sys_address` VALUES ('1000126', '鸡泽县', NULL, '130431', '1000112', 3);
INSERT INTO `sys_address` VALUES ('1000127', '广平县', NULL, '130432', '1000112', 3);
INSERT INTO `sys_address` VALUES ('1000128', '馆陶县', NULL, '130433', '1000112', 3);
INSERT INTO `sys_address` VALUES ('1000129', '魏县', NULL, '130434', '1000112', 3);
INSERT INTO `sys_address` VALUES ('1000130', '曲周县', NULL, '130435', '1000112', 3);
INSERT INTO `sys_address` VALUES ('1000131', '邢台市', NULL, '130500', '1000002', 2);
INSERT INTO `sys_address` VALUES ('1000132', '桥东区', NULL, '130502', '1000131', 3);
INSERT INTO `sys_address` VALUES ('1000133', '桥西区', NULL, '130503', '1000131', 3);
INSERT INTO `sys_address` VALUES ('1000134', '南宫市', NULL, '130581', '1000131', 3);
INSERT INTO `sys_address` VALUES ('1000135', '沙河市', NULL, '130582', '1000131', 3);
INSERT INTO `sys_address` VALUES ('1000136', '邢台县', NULL, '130521', '1000131', 3);
INSERT INTO `sys_address` VALUES ('1000137', '临城县', NULL, '130522', '1000131', 3);
INSERT INTO `sys_address` VALUES ('1000138', '内丘县', NULL, '130523', '1000131', 3);
INSERT INTO `sys_address` VALUES ('1000139', '柏乡县', NULL, '130524', '1000131', 3);
INSERT INTO `sys_address` VALUES ('1000140', '隆尧县', NULL, '130525', '1000131', 3);
INSERT INTO `sys_address` VALUES ('1000141', '任县', NULL, '130526', '1000131', 3);
INSERT INTO `sys_address` VALUES ('1000142', '南和县', NULL, '130527', '1000131', 3);
INSERT INTO `sys_address` VALUES ('1000143', '宁晋县', NULL, '130528', '1000131', 3);
INSERT INTO `sys_address` VALUES ('1000144', '巨鹿县', NULL, '130529', '1000131', 3);
INSERT INTO `sys_address` VALUES ('1000145', '新河县', NULL, '130530', '1000131', 3);
INSERT INTO `sys_address` VALUES ('1000146', '广宗县', NULL, '130531', '1000131', 3);
INSERT INTO `sys_address` VALUES ('1000147', '平乡县', NULL, '130532', '1000131', 3);
INSERT INTO `sys_address` VALUES ('1000148', '威县', NULL, '130533', '1000131', 3);
INSERT INTO `sys_address` VALUES ('1000149', '清河县', NULL, '130534', '1000131', 3);
INSERT INTO `sys_address` VALUES ('1000150', '临西县', NULL, '130535', '1000131', 3);
INSERT INTO `sys_address` VALUES ('1000151', '保定市', NULL, '130600', '1000002', 2);
INSERT INTO `sys_address` VALUES ('1000152', '竞秀区', NULL, '130602', '1000151', 3);
INSERT INTO `sys_address` VALUES ('1000153', '莲池区', NULL, '130606', '1000151', 3);
INSERT INTO `sys_address` VALUES ('1000154', '满城区', NULL, '130607', '1000151', 3);
INSERT INTO `sys_address` VALUES ('1000155', '清苑区', NULL, '130608', '1000151', 3);
INSERT INTO `sys_address` VALUES ('1000156', '徐水区', NULL, '130609', '1000151', 3);
INSERT INTO `sys_address` VALUES ('1000157', '涿州市', NULL, '130681', '1000151', 3);
INSERT INTO `sys_address` VALUES ('1000158', '定州市', NULL, '130682', '1000151', 3);
INSERT INTO `sys_address` VALUES ('1000159', '安国市', NULL, '130683', '1000151', 3);
INSERT INTO `sys_address` VALUES ('1000160', '高碑店市', NULL, '130684', '1000151', 3);
INSERT INTO `sys_address` VALUES ('1000161', '涞水县', NULL, '130623', '1000151', 3);
INSERT INTO `sys_address` VALUES ('1000162', '阜平县', NULL, '130624', '1000151', 3);
INSERT INTO `sys_address` VALUES ('1000163', '定兴县', NULL, '130626', '1000151', 3);
INSERT INTO `sys_address` VALUES ('1000164', '唐县', NULL, '130627', '1000151', 3);
INSERT INTO `sys_address` VALUES ('1000165', '高阳县', NULL, '130628', '1000151', 3);
INSERT INTO `sys_address` VALUES ('1000166', '容城县', NULL, '130629', '1000151', 3);
INSERT INTO `sys_address` VALUES ('1000167', '涞源县', NULL, '130630', '1000151', 3);
INSERT INTO `sys_address` VALUES ('1000168', '望都县', NULL, '130631', '1000151', 3);
INSERT INTO `sys_address` VALUES ('1000169', '安新县', NULL, '130632', '1000151', 3);
INSERT INTO `sys_address` VALUES ('1000170', '易县', NULL, '130633', '1000151', 3);
INSERT INTO `sys_address` VALUES ('1000171', '曲阳县', NULL, '130634', '1000151', 3);
INSERT INTO `sys_address` VALUES ('1000172', '蠡县', NULL, '130635', '1000151', 3);
INSERT INTO `sys_address` VALUES ('1000173', '顺平县', NULL, '130636', '1000151', 3);
INSERT INTO `sys_address` VALUES ('1000174', '博野县', NULL, '130637', '1000151', 3);
INSERT INTO `sys_address` VALUES ('1000175', '雄县', NULL, '130638', '1000151', 3);
INSERT INTO `sys_address` VALUES ('1000176', '张家口市', NULL, '130700', '1000002', 2);
INSERT INTO `sys_address` VALUES ('1000177', '桥西区', NULL, '130703', '1000176', 3);
INSERT INTO `sys_address` VALUES ('1000178', '桥东区', NULL, '130702', '1000176', 3);
INSERT INTO `sys_address` VALUES ('1000179', '宣化区', NULL, '130705', '1000176', 3);
INSERT INTO `sys_address` VALUES ('1000180', '下花园区', NULL, '130706', '1000176', 3);
INSERT INTO `sys_address` VALUES ('1000181', '万全区', NULL, '130708', '1000176', 3);
INSERT INTO `sys_address` VALUES ('1000182', '崇礼区', NULL, '130709', '1000176', 3);
INSERT INTO `sys_address` VALUES ('1000183', '张北县', NULL, '130722', '1000176', 3);
INSERT INTO `sys_address` VALUES ('1000184', '康保县', NULL, '130723', '1000176', 3);
INSERT INTO `sys_address` VALUES ('1000185', '沽源县', NULL, '130724', '1000176', 3);
INSERT INTO `sys_address` VALUES ('1000186', '尚义县', NULL, '130725', '1000176', 3);
INSERT INTO `sys_address` VALUES ('1000187', '蔚县', NULL, '130726', '1000176', 3);
INSERT INTO `sys_address` VALUES ('1000188', '阳原县', NULL, '130727', '1000176', 3);
INSERT INTO `sys_address` VALUES ('1000189', '怀安县', NULL, '130728', '1000176', 3);
INSERT INTO `sys_address` VALUES ('1000190', '怀来县', NULL, '130730', '1000176', 3);
INSERT INTO `sys_address` VALUES ('1000191', '涿鹿县', NULL, '130731', '1000176', 3);
INSERT INTO `sys_address` VALUES ('1000192', '赤城县', NULL, '130732', '1000176', 3);
INSERT INTO `sys_address` VALUES ('1000193', '承德市', NULL, '130800', '1000002', 2);
INSERT INTO `sys_address` VALUES ('1000194', '双桥区', NULL, '130802', '1000193', 3);
INSERT INTO `sys_address` VALUES ('1000195', '双滦区', NULL, '130803', '1000193', 3);
INSERT INTO `sys_address` VALUES ('1000196', '鹰手营子矿区', NULL, '130804', '1000193', 3);
INSERT INTO `sys_address` VALUES ('1000197', '平泉市', NULL, '130881', '1000193', 3);
INSERT INTO `sys_address` VALUES ('1000198', '承德县', NULL, '130821', '1000193', 3);
INSERT INTO `sys_address` VALUES ('1000199', '兴隆县', NULL, '130822', '1000193', 3);
INSERT INTO `sys_address` VALUES ('1000200', '滦平县', NULL, '130824', '1000193', 3);
INSERT INTO `sys_address` VALUES ('1000201', '隆化县', NULL, '130825', '1000193', 3);
INSERT INTO `sys_address` VALUES ('1000202', '丰宁满族自治县', NULL, '130826', '1000193', 3);
INSERT INTO `sys_address` VALUES ('1000203', '宽城满族自治县', NULL, '130827', '1000193', 3);
INSERT INTO `sys_address` VALUES ('1000204', '围场满族蒙古族自治县', NULL, '130828', '1000193', 3);
INSERT INTO `sys_address` VALUES ('1000205', '沧州市', NULL, '130900', '1000002', 2);
INSERT INTO `sys_address` VALUES ('1000206', '运河区', NULL, '130903', '1000205', 3);
INSERT INTO `sys_address` VALUES ('1000207', '新华区', NULL, '130902', '1000205', 3);
INSERT INTO `sys_address` VALUES ('1000208', '泊头市', NULL, '130981', '1000205', 3);
INSERT INTO `sys_address` VALUES ('1000209', '任丘市', NULL, '130982', '1000205', 3);
INSERT INTO `sys_address` VALUES ('1000210', '黄骅市', NULL, '130983', '1000205', 3);
INSERT INTO `sys_address` VALUES ('1000211', '河间市', NULL, '130984', '1000205', 3);
INSERT INTO `sys_address` VALUES ('1000212', '沧县', NULL, '130921', '1000205', 3);
INSERT INTO `sys_address` VALUES ('1000213', '青县', NULL, '130922', '1000205', 3);
INSERT INTO `sys_address` VALUES ('1000214', '东光县', NULL, '130923', '1000205', 3);
INSERT INTO `sys_address` VALUES ('1000215', '海兴县', NULL, '130924', '1000205', 3);
INSERT INTO `sys_address` VALUES ('1000216', '盐山县', NULL, '130925', '1000205', 3);
INSERT INTO `sys_address` VALUES ('1000217', '肃宁县', NULL, '130926', '1000205', 3);
INSERT INTO `sys_address` VALUES ('1000218', '南皮县', NULL, '130927', '1000205', 3);
INSERT INTO `sys_address` VALUES ('1000219', '吴桥县', NULL, '130928', '1000205', 3);
INSERT INTO `sys_address` VALUES ('1000220', '献县', NULL, '130929', '1000205', 3);
INSERT INTO `sys_address` VALUES ('1000221', '孟村回族自治县', NULL, '130930', '1000205', 3);
INSERT INTO `sys_address` VALUES ('1000222', '廊坊市', NULL, '131000', '1000002', 2);
INSERT INTO `sys_address` VALUES ('1000223', '广阳区', NULL, '131003', '1000222', 3);
INSERT INTO `sys_address` VALUES ('1000224', '安次区', NULL, '131002', '1000222', 3);
INSERT INTO `sys_address` VALUES ('1000225', '霸州市', NULL, '131081', '1000222', 3);
INSERT INTO `sys_address` VALUES ('1000226', '三河市', NULL, '131082', '1000222', 3);
INSERT INTO `sys_address` VALUES ('1000227', '固安县', NULL, '131022', '1000222', 3);
INSERT INTO `sys_address` VALUES ('1000228', '永清县', NULL, '131023', '1000222', 3);
INSERT INTO `sys_address` VALUES ('1000229', '香河县', NULL, '131024', '1000222', 3);
INSERT INTO `sys_address` VALUES ('1000230', '大城县', NULL, '131025', '1000222', 3);
INSERT INTO `sys_address` VALUES ('1000231', '文安县', NULL, '131026', '1000222', 3);
INSERT INTO `sys_address` VALUES ('1000232', '大厂回族自治县', NULL, '131028', '1000222', 3);
INSERT INTO `sys_address` VALUES ('1000233', '衡水市', NULL, '131100', '1000002', 2);
INSERT INTO `sys_address` VALUES ('1000234', '桃城区', NULL, '131102', '1000233', 3);
INSERT INTO `sys_address` VALUES ('1000235', '冀州区', NULL, '131103', '1000233', 3);
INSERT INTO `sys_address` VALUES ('1000236', '深州市', NULL, '131182', '1000233', 3);
INSERT INTO `sys_address` VALUES ('1000237', '枣强县', NULL, '131121', '1000233', 3);
INSERT INTO `sys_address` VALUES ('1000238', '武邑县', NULL, '131122', '1000233', 3);
INSERT INTO `sys_address` VALUES ('1000239', '武强县', NULL, '131123', '1000233', 3);
INSERT INTO `sys_address` VALUES ('1000240', '饶阳县', NULL, '131124', '1000233', 3);
INSERT INTO `sys_address` VALUES ('1000241', '安平县', NULL, '131125', '1000233', 3);
INSERT INTO `sys_address` VALUES ('1000242', '故城县', NULL, '131126', '1000233', 3);
INSERT INTO `sys_address` VALUES ('1000243', '景县', NULL, '131127', '1000233', 3);
INSERT INTO `sys_address` VALUES ('1000244', '阜城县', NULL, '131128', '1000233', 3);
INSERT INTO `sys_address` VALUES ('1000245', '太原市', NULL, '140100', '1000003', 2);
INSERT INTO `sys_address` VALUES ('1000246', '杏花岭区', NULL, '140107', '1000245', 3);
INSERT INTO `sys_address` VALUES ('1000247', '小店区', NULL, '140105', '1000245', 3);
INSERT INTO `sys_address` VALUES ('1000248', '迎泽区', NULL, '140106', '1000245', 3);
INSERT INTO `sys_address` VALUES ('1000249', '尖草坪区', NULL, '140108', '1000245', 3);
INSERT INTO `sys_address` VALUES ('1000250', '万柏林区', NULL, '140109', '1000245', 3);
INSERT INTO `sys_address` VALUES ('1000251', '晋源区', NULL, '140110', '1000245', 3);
INSERT INTO `sys_address` VALUES ('1000252', '古交市', NULL, '140181', '1000245', 3);
INSERT INTO `sys_address` VALUES ('1000253', '清徐县', NULL, '140121', '1000245', 3);
INSERT INTO `sys_address` VALUES ('1000254', '阳曲县', NULL, '140122', '1000245', 3);
INSERT INTO `sys_address` VALUES ('1000255', '娄烦县', NULL, '140123', '1000245', 3);
INSERT INTO `sys_address` VALUES ('1000256', '大同市', NULL, '140200', '1000003', 2);
INSERT INTO `sys_address` VALUES ('1000257', '城区', NULL, '140202', '1000256', 3);
INSERT INTO `sys_address` VALUES ('1000258', '矿区', NULL, '140203', '1000256', 3);
INSERT INTO `sys_address` VALUES ('1000259', '南郊区', NULL, '140211', '1000256', 3);
INSERT INTO `sys_address` VALUES ('1000260', '新荣区', NULL, '140212', '1000256', 3);
INSERT INTO `sys_address` VALUES ('1000261', '阳高县', NULL, '140221', '1000256', 3);
INSERT INTO `sys_address` VALUES ('1000262', '天镇县', NULL, '140222', '1000256', 3);
INSERT INTO `sys_address` VALUES ('1000263', '广灵县', NULL, '140223', '1000256', 3);
INSERT INTO `sys_address` VALUES ('1000264', '灵丘县', NULL, '140224', '1000256', 3);
INSERT INTO `sys_address` VALUES ('1000265', '浑源县', NULL, '140225', '1000256', 3);
INSERT INTO `sys_address` VALUES ('1000266', '左云县', NULL, '140226', '1000256', 3);
INSERT INTO `sys_address` VALUES ('1000267', '大同县', NULL, '140227', '1000256', 3);
INSERT INTO `sys_address` VALUES ('1000268', '阳泉市', NULL, '140300', '1000003', 2);
INSERT INTO `sys_address` VALUES ('1000269', '城区', NULL, '140302', '1000268', 3);
INSERT INTO `sys_address` VALUES ('1000270', '矿区', NULL, '140303', '1000268', 3);
INSERT INTO `sys_address` VALUES ('1000271', '郊区', NULL, '140311', '1000268', 3);
INSERT INTO `sys_address` VALUES ('1000272', '平定县', NULL, '140321', '1000268', 3);
INSERT INTO `sys_address` VALUES ('1000273', '盂县', NULL, '140322', '1000268', 3);
INSERT INTO `sys_address` VALUES ('1000274', '长治市', NULL, '140400', '1000003', 2);
INSERT INTO `sys_address` VALUES ('1000275', '城区', NULL, '140402', '1000274', 3);
INSERT INTO `sys_address` VALUES ('1000276', '郊区', NULL, '140411', '1000274', 3);
INSERT INTO `sys_address` VALUES ('1000277', '潞城市', NULL, '140481', '1000274', 3);
INSERT INTO `sys_address` VALUES ('1000278', '长治县', NULL, '140421', '1000274', 3);
INSERT INTO `sys_address` VALUES ('1000279', '襄垣县', NULL, '140423', '1000274', 3);
INSERT INTO `sys_address` VALUES ('1000280', '屯留县', NULL, '140424', '1000274', 3);
INSERT INTO `sys_address` VALUES ('1000281', '平顺县', NULL, '140425', '1000274', 3);
INSERT INTO `sys_address` VALUES ('1000282', '黎城县', NULL, '140426', '1000274', 3);
INSERT INTO `sys_address` VALUES ('1000283', '壶关县', NULL, '140427', '1000274', 3);
INSERT INTO `sys_address` VALUES ('1000284', '长子县', NULL, '140428', '1000274', 3);
INSERT INTO `sys_address` VALUES ('1000285', '武乡县', NULL, '140429', '1000274', 3);
INSERT INTO `sys_address` VALUES ('1000286', '沁县', NULL, '140430', '1000274', 3);
INSERT INTO `sys_address` VALUES ('1000287', '沁源县', NULL, '140431', '1000274', 3);
INSERT INTO `sys_address` VALUES ('1000288', '晋城市', NULL, '140500', '1000003', 2);
INSERT INTO `sys_address` VALUES ('1000289', '城区', NULL, '140502', '1000288', 3);
INSERT INTO `sys_address` VALUES ('1000290', '高平市', NULL, '140581', '1000288', 3);
INSERT INTO `sys_address` VALUES ('1000291', '沁水县', NULL, '140521', '1000288', 3);
INSERT INTO `sys_address` VALUES ('1000292', '阳城县', NULL, '140522', '1000288', 3);
INSERT INTO `sys_address` VALUES ('1000293', '陵川县', NULL, '140524', '1000288', 3);
INSERT INTO `sys_address` VALUES ('1000294', '泽州县', NULL, '140525', '1000288', 3);
INSERT INTO `sys_address` VALUES ('1000295', '朔州市', NULL, '140600', '1000003', 2);
INSERT INTO `sys_address` VALUES ('1000296', '朔城区', NULL, '140602', '1000295', 3);
INSERT INTO `sys_address` VALUES ('1000297', '平鲁区', NULL, '140603', '1000295', 3);
INSERT INTO `sys_address` VALUES ('1000298', '山阴县', NULL, '140621', '1000295', 3);
INSERT INTO `sys_address` VALUES ('1000299', '应县', NULL, '140622', '1000295', 3);
INSERT INTO `sys_address` VALUES ('1000300', '右玉县', NULL, '140623', '1000295', 3);
INSERT INTO `sys_address` VALUES ('1000301', '怀仁县', NULL, '140624', '1000295', 3);
INSERT INTO `sys_address` VALUES ('1000302', '晋中市', NULL, '140700', '1000003', 2);
INSERT INTO `sys_address` VALUES ('1000303', '榆次区', NULL, '140702', '1000302', 3);
INSERT INTO `sys_address` VALUES ('1000304', '介休市', NULL, '140781', '1000302', 3);
INSERT INTO `sys_address` VALUES ('1000305', '榆社县', NULL, '140721', '1000302', 3);
INSERT INTO `sys_address` VALUES ('1000306', '左权县', NULL, '140722', '1000302', 3);
INSERT INTO `sys_address` VALUES ('1000307', '和顺县', NULL, '140723', '1000302', 3);
INSERT INTO `sys_address` VALUES ('1000308', '昔阳县', NULL, '140724', '1000302', 3);
INSERT INTO `sys_address` VALUES ('1000309', '寿阳县', NULL, '140725', '1000302', 3);
INSERT INTO `sys_address` VALUES ('1000310', '太谷县', NULL, '140726', '1000302', 3);
INSERT INTO `sys_address` VALUES ('1000311', '祁县', NULL, '140727', '1000302', 3);
INSERT INTO `sys_address` VALUES ('1000312', '平遥县', NULL, '140728', '1000302', 3);
INSERT INTO `sys_address` VALUES ('1000313', '灵石县', NULL, '140729', '1000302', 3);
INSERT INTO `sys_address` VALUES ('1000314', '运城市', NULL, '140800', '1000003', 2);
INSERT INTO `sys_address` VALUES ('1000315', '盐湖区', NULL, '140802', '1000314', 3);
INSERT INTO `sys_address` VALUES ('1000316', '永济市', NULL, '140881', '1000314', 3);
INSERT INTO `sys_address` VALUES ('1000317', '河津市', NULL, '140882', '1000314', 3);
INSERT INTO `sys_address` VALUES ('1000318', '临猗县', NULL, '140821', '1000314', 3);
INSERT INTO `sys_address` VALUES ('1000319', '万荣县', NULL, '140822', '1000314', 3);
INSERT INTO `sys_address` VALUES ('1000320', '闻喜县', NULL, '140823', '1000314', 3);
INSERT INTO `sys_address` VALUES ('1000321', '稷山县', NULL, '140824', '1000314', 3);
INSERT INTO `sys_address` VALUES ('1000322', '新绛县', NULL, '140825', '1000314', 3);
INSERT INTO `sys_address` VALUES ('1000323', '绛县', NULL, '140826', '1000314', 3);
INSERT INTO `sys_address` VALUES ('1000324', '垣曲县', NULL, '140827', '1000314', 3);
INSERT INTO `sys_address` VALUES ('1000325', '夏县', NULL, '140828', '1000314', 3);
INSERT INTO `sys_address` VALUES ('1000326', '平陆县', NULL, '140829', '1000314', 3);
INSERT INTO `sys_address` VALUES ('1000327', '芮城县', NULL, '140830', '1000314', 3);
INSERT INTO `sys_address` VALUES ('1000328', '忻州市', NULL, '140900', '1000003', 2);
INSERT INTO `sys_address` VALUES ('1000329', '忻府区', NULL, '140902', '1000328', 3);
INSERT INTO `sys_address` VALUES ('1000330', '原平市', NULL, '140981', '1000328', 3);
INSERT INTO `sys_address` VALUES ('1000331', '定襄县', NULL, '140921', '1000328', 3);
INSERT INTO `sys_address` VALUES ('1000332', '五台县', NULL, '140922', '1000328', 3);
INSERT INTO `sys_address` VALUES ('1000333', '代县', NULL, '140923', '1000328', 3);
INSERT INTO `sys_address` VALUES ('1000334', '繁峙县', NULL, '140924', '1000328', 3);
INSERT INTO `sys_address` VALUES ('1000335', '宁武县', NULL, '140925', '1000328', 3);
INSERT INTO `sys_address` VALUES ('1000336', '静乐县', NULL, '140926', '1000328', 3);
INSERT INTO `sys_address` VALUES ('1000337', '神池县', NULL, '140927', '1000328', 3);
INSERT INTO `sys_address` VALUES ('1000338', '五寨县', NULL, '140928', '1000328', 3);
INSERT INTO `sys_address` VALUES ('1000339', '岢岚县', NULL, '140929', '1000328', 3);
INSERT INTO `sys_address` VALUES ('1000340', '河曲县', NULL, '140930', '1000328', 3);
INSERT INTO `sys_address` VALUES ('1000341', '保德县', NULL, '140931', '1000328', 3);
INSERT INTO `sys_address` VALUES ('1000342', '偏关县', NULL, '140932', '1000328', 3);
INSERT INTO `sys_address` VALUES ('1000343', '临汾市', NULL, '141000', '1000003', 2);
INSERT INTO `sys_address` VALUES ('1000344', '尧都区', NULL, '141002', '1000343', 3);
INSERT INTO `sys_address` VALUES ('1000345', '侯马市', NULL, '141081', '1000343', 3);
INSERT INTO `sys_address` VALUES ('1000346', '霍州市', NULL, '141082', '1000343', 3);
INSERT INTO `sys_address` VALUES ('1000347', '曲沃县', NULL, '141021', '1000343', 3);
INSERT INTO `sys_address` VALUES ('1000348', '翼城县', NULL, '141022', '1000343', 3);
INSERT INTO `sys_address` VALUES ('1000349', '襄汾县', NULL, '141023', '1000343', 3);
INSERT INTO `sys_address` VALUES ('1000350', '洪洞县', NULL, '141024', '1000343', 3);
INSERT INTO `sys_address` VALUES ('1000351', '古县', NULL, '141025', '1000343', 3);
INSERT INTO `sys_address` VALUES ('1000352', '安泽县', NULL, '141026', '1000343', 3);
INSERT INTO `sys_address` VALUES ('1000353', '浮山县', NULL, '141027', '1000343', 3);
INSERT INTO `sys_address` VALUES ('1000354', '吉县', NULL, '141028', '1000343', 3);
INSERT INTO `sys_address` VALUES ('1000355', '乡宁县', NULL, '141029', '1000343', 3);
INSERT INTO `sys_address` VALUES ('1000356', '大宁县', NULL, '141030', '1000343', 3);
INSERT INTO `sys_address` VALUES ('1000357', '隰县', NULL, '141031', '1000343', 3);
INSERT INTO `sys_address` VALUES ('1000358', '永和县', NULL, '141032', '1000343', 3);
INSERT INTO `sys_address` VALUES ('1000359', '蒲县', NULL, '141033', '1000343', 3);
INSERT INTO `sys_address` VALUES ('1000360', '汾西县', NULL, '141034', '1000343', 3);
INSERT INTO `sys_address` VALUES ('1000361', '吕梁市', NULL, '141100', '1000003', 2);
INSERT INTO `sys_address` VALUES ('1000362', '离石区', NULL, '141102', '1000361', 3);
INSERT INTO `sys_address` VALUES ('1000363', '孝义市', NULL, '141181', '1000361', 3);
INSERT INTO `sys_address` VALUES ('1000364', '汾阳市', NULL, '141182', '1000361', 3);
INSERT INTO `sys_address` VALUES ('1000365', '文水县', NULL, '141121', '1000361', 3);
INSERT INTO `sys_address` VALUES ('1000366', '交城县', NULL, '141122', '1000361', 3);
INSERT INTO `sys_address` VALUES ('1000367', '兴县', NULL, '141123', '1000361', 3);
INSERT INTO `sys_address` VALUES ('1000368', '临县', NULL, '141124', '1000361', 3);
INSERT INTO `sys_address` VALUES ('1000369', '柳林县', NULL, '141125', '1000361', 3);
INSERT INTO `sys_address` VALUES ('1000370', '石楼县', NULL, '141126', '1000361', 3);
INSERT INTO `sys_address` VALUES ('1000371', '岚县', NULL, '141127', '1000361', 3);
INSERT INTO `sys_address` VALUES ('1000372', '方山县', NULL, '141128', '1000361', 3);
INSERT INTO `sys_address` VALUES ('1000373', '中阳县', NULL, '141129', '1000361', 3);
INSERT INTO `sys_address` VALUES ('1000374', '交口县', NULL, '141130', '1000361', 3);
INSERT INTO `sys_address` VALUES ('1000375', '呼和浩特市', NULL, '150100', '1000004', 2);
INSERT INTO `sys_address` VALUES ('1000376', '新城区', NULL, '150102', '1000375', 3);
INSERT INTO `sys_address` VALUES ('1000377', '回民区', NULL, '150103', '1000375', 3);
INSERT INTO `sys_address` VALUES ('1000378', '玉泉区', NULL, '150104', '1000375', 3);
INSERT INTO `sys_address` VALUES ('1000379', '赛罕区', NULL, '150105', '1000375', 3);
INSERT INTO `sys_address` VALUES ('1000380', '托克托县', NULL, '150122', '1000375', 3);
INSERT INTO `sys_address` VALUES ('1000381', '和林格尔县', NULL, '150123', '1000375', 3);
INSERT INTO `sys_address` VALUES ('1000382', '清水河县', NULL, '150124', '1000375', 3);
INSERT INTO `sys_address` VALUES ('1000383', '武川县', NULL, '150125', '1000375', 3);
INSERT INTO `sys_address` VALUES ('1000384', '土默特左旗', NULL, '150121', '1000375', 3);
INSERT INTO `sys_address` VALUES ('1000385', '包头市', NULL, '150200', '1000004', 2);
INSERT INTO `sys_address` VALUES ('1000386', '昆都仑区', NULL, '150203', '1000385', 3);
INSERT INTO `sys_address` VALUES ('1000387', '东河区', NULL, '150202', '1000385', 3);
INSERT INTO `sys_address` VALUES ('1000388', '青山区', NULL, '150204', '1000385', 3);
INSERT INTO `sys_address` VALUES ('1000389', '石拐区', NULL, '150205', '1000385', 3);
INSERT INTO `sys_address` VALUES ('1000390', '白云鄂博矿区', NULL, '150206', '1000385', 3);
INSERT INTO `sys_address` VALUES ('1000391', '九原区', NULL, '150207', '1000385', 3);
INSERT INTO `sys_address` VALUES ('1000392', '固阳县', NULL, '150222', '1000385', 3);
INSERT INTO `sys_address` VALUES ('1000393', '土默特右旗', NULL, '150221', '1000385', 3);
INSERT INTO `sys_address` VALUES ('1000394', '达尔罕茂明安联合旗', NULL, '150223', '1000385', 3);
INSERT INTO `sys_address` VALUES ('1000395', '乌海市', NULL, '150300', '1000004', 2);
INSERT INTO `sys_address` VALUES ('1000396', '海勃湾区', NULL, '150302', '1000395', 3);
INSERT INTO `sys_address` VALUES ('1000397', '海南区', NULL, '150303', '1000395', 3);
INSERT INTO `sys_address` VALUES ('1000398', '乌达区', NULL, '150304', '1000395', 3);
INSERT INTO `sys_address` VALUES ('1000399', '赤峰市', NULL, '150400', '1000004', 2);
INSERT INTO `sys_address` VALUES ('1000400', '红山区', NULL, '150402', '1000399', 3);
INSERT INTO `sys_address` VALUES ('1000401', '元宝山区', NULL, '150403', '1000399', 3);
INSERT INTO `sys_address` VALUES ('1000402', '松山区', NULL, '150404', '1000399', 3);
INSERT INTO `sys_address` VALUES ('1000403', '林西县', NULL, '150424', '1000399', 3);
INSERT INTO `sys_address` VALUES ('1000404', '宁城县', NULL, '150429', '1000399', 3);
INSERT INTO `sys_address` VALUES ('1000405', '阿鲁科尔沁旗', NULL, '150421', '1000399', 3);
INSERT INTO `sys_address` VALUES ('1000406', '巴林左旗', NULL, '150422', '1000399', 3);
INSERT INTO `sys_address` VALUES ('1000407', '巴林右旗', NULL, '150423', '1000399', 3);
INSERT INTO `sys_address` VALUES ('1000408', '克什克腾旗', NULL, '150425', '1000399', 3);
INSERT INTO `sys_address` VALUES ('1000409', '翁牛特旗', NULL, '150426', '1000399', 3);
INSERT INTO `sys_address` VALUES ('1000410', '喀喇沁旗', NULL, '150428', '1000399', 3);
INSERT INTO `sys_address` VALUES ('1000411', '敖汉旗', NULL, '150430', '1000399', 3);
INSERT INTO `sys_address` VALUES ('1000412', '通辽市', NULL, '150500', '1000004', 2);
INSERT INTO `sys_address` VALUES ('1000413', '科尔沁区', NULL, '150502', '1000412', 3);
INSERT INTO `sys_address` VALUES ('1000414', '霍林郭勒市', NULL, '150581', '1000412', 3);
INSERT INTO `sys_address` VALUES ('1000415', '开鲁县', NULL, '150523', '1000412', 3);
INSERT INTO `sys_address` VALUES ('1000416', '库伦旗', NULL, '150524', '1000412', 3);
INSERT INTO `sys_address` VALUES ('1000417', '奈曼旗', NULL, '150525', '1000412', 3);
INSERT INTO `sys_address` VALUES ('1000418', '扎鲁特旗', NULL, '150526', '1000412', 3);
INSERT INTO `sys_address` VALUES ('1000419', '科尔沁左翼中旗', NULL, '150521', '1000412', 3);
INSERT INTO `sys_address` VALUES ('1000420', '科尔沁左翼后旗', NULL, '150522', '1000412', 3);
INSERT INTO `sys_address` VALUES ('1000421', '鄂尔多斯市', NULL, '150600', '1000004', 2);
INSERT INTO `sys_address` VALUES ('1000422', '东胜区', NULL, '150602', '1000421', 3);
INSERT INTO `sys_address` VALUES ('1000423', '康巴什区', NULL, '150603', '1000421', 3);
INSERT INTO `sys_address` VALUES ('1000424', '达拉特旗', NULL, '150621', '1000421', 3);
INSERT INTO `sys_address` VALUES ('1000425', '准格尔旗', NULL, '150622', '1000421', 3);
INSERT INTO `sys_address` VALUES ('1000426', '鄂托克前旗', NULL, '150623', '1000421', 3);
INSERT INTO `sys_address` VALUES ('1000427', '鄂托克旗', NULL, '150624', '1000421', 3);
INSERT INTO `sys_address` VALUES ('1000428', '杭锦旗', NULL, '150625', '1000421', 3);
INSERT INTO `sys_address` VALUES ('1000429', '乌审旗', NULL, '150626', '1000421', 3);
INSERT INTO `sys_address` VALUES ('1000430', '伊金霍洛旗', NULL, '150627', '1000421', 3);
INSERT INTO `sys_address` VALUES ('1000431', '呼伦贝尔市', NULL, '150700', '1000004', 2);
INSERT INTO `sys_address` VALUES ('1000432', '海拉尔区', NULL, '150702', '1000431', 3);
INSERT INTO `sys_address` VALUES ('1000433', '扎赉诺尔区', NULL, '150703', '1000431', 3);
INSERT INTO `sys_address` VALUES ('1000434', '满洲里市', NULL, '150781', '1000431', 3);
INSERT INTO `sys_address` VALUES ('1000435', '牙克石市', NULL, '150782', '1000431', 3);
INSERT INTO `sys_address` VALUES ('1000436', '扎兰屯市', NULL, '150783', '1000431', 3);
INSERT INTO `sys_address` VALUES ('1000437', '额尔古纳市', NULL, '150784', '1000431', 3);
INSERT INTO `sys_address` VALUES ('1000438', '根河市', NULL, '150785', '1000431', 3);
INSERT INTO `sys_address` VALUES ('1000439', '阿荣旗', NULL, '150721', '1000431', 3);
INSERT INTO `sys_address` VALUES ('1000440', '陈巴尔虎旗', NULL, '150725', '1000431', 3);
INSERT INTO `sys_address` VALUES ('1000441', '新巴尔虎左旗', NULL, '150726', '1000431', 3);
INSERT INTO `sys_address` VALUES ('1000442', '新巴尔虎右旗', NULL, '150727', '1000431', 3);
INSERT INTO `sys_address` VALUES ('1000443', '莫力达瓦达斡尔族自治旗', NULL, '150722', '1000431', 3);
INSERT INTO `sys_address` VALUES ('1000444', '鄂伦春自治旗', NULL, '150723', '1000431', 3);
INSERT INTO `sys_address` VALUES ('1000445', '鄂温克族自治旗', NULL, '150724', '1000431', 3);
INSERT INTO `sys_address` VALUES ('1000446', '巴彦淖尔市', NULL, '150800', '1000004', 2);
INSERT INTO `sys_address` VALUES ('1000447', '临河区', NULL, '150802', '1000446', 3);
INSERT INTO `sys_address` VALUES ('1000448', '五原县', NULL, '150821', '1000446', 3);
INSERT INTO `sys_address` VALUES ('1000449', '磴口县', NULL, '150822', '1000446', 3);
INSERT INTO `sys_address` VALUES ('1000450', '乌拉特前旗', NULL, '150823', '1000446', 3);
INSERT INTO `sys_address` VALUES ('1000451', '乌拉特中旗', NULL, '150824', '1000446', 3);
INSERT INTO `sys_address` VALUES ('1000452', '乌拉特后旗', NULL, '150825', '1000446', 3);
INSERT INTO `sys_address` VALUES ('1000453', '杭锦后旗', NULL, '150826', '1000446', 3);
INSERT INTO `sys_address` VALUES ('1000454', '乌兰察布市', NULL, '150900', '1000004', 2);
INSERT INTO `sys_address` VALUES ('1000455', '集宁区', NULL, '150902', '1000454', 3);
INSERT INTO `sys_address` VALUES ('1000456', '丰镇市', NULL, '150981', '1000454', 3);
INSERT INTO `sys_address` VALUES ('1000457', '卓资县', NULL, '150921', '1000454', 3);
INSERT INTO `sys_address` VALUES ('1000458', '化德县', NULL, '150922', '1000454', 3);
INSERT INTO `sys_address` VALUES ('1000459', '商都县', NULL, '150923', '1000454', 3);
INSERT INTO `sys_address` VALUES ('1000460', '兴和县', NULL, '150924', '1000454', 3);
INSERT INTO `sys_address` VALUES ('1000461', '凉城县', NULL, '150925', '1000454', 3);
INSERT INTO `sys_address` VALUES ('1000462', '察哈尔右翼前旗', NULL, '150926', '1000454', 3);
INSERT INTO `sys_address` VALUES ('1000463', '察哈尔右翼中旗', NULL, '150927', '1000454', 3);
INSERT INTO `sys_address` VALUES ('1000464', '察哈尔右翼后旗', NULL, '150928', '1000454', 3);
INSERT INTO `sys_address` VALUES ('1000465', '四子王旗', NULL, '150929', '1000454', 3);
INSERT INTO `sys_address` VALUES ('1000466', '兴安盟', NULL, '152200', '1000004', 2);
INSERT INTO `sys_address` VALUES ('1000467', '乌兰浩特市', NULL, '152201', '1000466', 3);
INSERT INTO `sys_address` VALUES ('1000468', '阿尔山市', NULL, '152202', '1000466', 3);
INSERT INTO `sys_address` VALUES ('1000469', '突泉县', NULL, '152224', '1000466', 3);
INSERT INTO `sys_address` VALUES ('1000470', '科尔沁右翼前旗', NULL, '152221', '1000466', 3);
INSERT INTO `sys_address` VALUES ('1000471', '科尔沁右翼中旗', NULL, '152222', '1000466', 3);
INSERT INTO `sys_address` VALUES ('1000472', '扎赉特旗', NULL, '152223', '1000466', 3);
INSERT INTO `sys_address` VALUES ('1000473', '锡林郭勒盟', NULL, '152500', '1000004', 2);
INSERT INTO `sys_address` VALUES ('1000474', '锡林浩特市', NULL, '152502', '1000473', 3);
INSERT INTO `sys_address` VALUES ('1000475', '二连浩特市', NULL, '152501', '1000473', 3);
INSERT INTO `sys_address` VALUES ('1000476', '多伦县', NULL, '152531', '1000473', 3);
INSERT INTO `sys_address` VALUES ('1000477', '阿巴嘎旗', NULL, '152522', '1000473', 3);
INSERT INTO `sys_address` VALUES ('1000478', '苏尼特左旗', NULL, '152523', '1000473', 3);
INSERT INTO `sys_address` VALUES ('1000479', '苏尼特右旗', NULL, '152524', '1000473', 3);
INSERT INTO `sys_address` VALUES ('1000480', '东乌珠穆沁旗', NULL, '152525', '1000473', 3);
INSERT INTO `sys_address` VALUES ('1000481', '西乌珠穆沁旗', NULL, '152526', '1000473', 3);
INSERT INTO `sys_address` VALUES ('1000482', '太仆寺旗', NULL, '152527', '1000473', 3);
INSERT INTO `sys_address` VALUES ('1000483', '镶黄旗', NULL, '152528', '1000473', 3);
INSERT INTO `sys_address` VALUES ('1000484', '正镶白旗', NULL, '152529', '1000473', 3);
INSERT INTO `sys_address` VALUES ('1000485', '正蓝旗', NULL, '152530', '1000473', 3);
INSERT INTO `sys_address` VALUES ('1000486', '阿拉善盟', NULL, '152900', '1000004', 2);
INSERT INTO `sys_address` VALUES ('1000487', '阿拉善左旗', NULL, '152921', '1000486', 3);
INSERT INTO `sys_address` VALUES ('1000488', '阿拉善右旗', NULL, '152922', '1000486', 3);
INSERT INTO `sys_address` VALUES ('1000489', '额济纳旗', NULL, '152923', '1000486', 3);
INSERT INTO `sys_address` VALUES ('1000490', '沈阳市', NULL, '210100', '1000005', 2);
INSERT INTO `sys_address` VALUES ('1000491', '沈河区', NULL, '210103', '1000490', 3);
INSERT INTO `sys_address` VALUES ('1000492', '和平区', NULL, '210102', '1000490', 3);
INSERT INTO `sys_address` VALUES ('1000493', '大东区', NULL, '210104', '1000490', 3);
INSERT INTO `sys_address` VALUES ('1000494', '皇姑区', NULL, '210105', '1000490', 3);
INSERT INTO `sys_address` VALUES ('1000495', '铁西区', NULL, '210106', '1000490', 3);
INSERT INTO `sys_address` VALUES ('1000496', '苏家屯区', NULL, '210111', '1000490', 3);
INSERT INTO `sys_address` VALUES ('1000497', '浑南区', NULL, '210112', '1000490', 3);
INSERT INTO `sys_address` VALUES ('1000498', '沈北新区', NULL, '210113', '1000490', 3);
INSERT INTO `sys_address` VALUES ('1000499', '于洪区', NULL, '210114', '1000490', 3);
INSERT INTO `sys_address` VALUES ('1000500', '辽中区', NULL, '210115', '1000490', 3);
INSERT INTO `sys_address` VALUES ('1000501', '新民市', NULL, '210181', '1000490', 3);
INSERT INTO `sys_address` VALUES ('1000502', '康平县', NULL, '210123', '1000490', 3);
INSERT INTO `sys_address` VALUES ('1000503', '法库县', NULL, '210124', '1000490', 3);
INSERT INTO `sys_address` VALUES ('1000504', '大连市', NULL, '210200', '1000005', 2);
INSERT INTO `sys_address` VALUES ('1000505', '西岗区', NULL, '210203', '1000504', 3);
INSERT INTO `sys_address` VALUES ('1000506', '中山区', NULL, '210202', '1000504', 3);
INSERT INTO `sys_address` VALUES ('1000507', '沙河口区', NULL, '210204', '1000504', 3);
INSERT INTO `sys_address` VALUES ('1000508', '甘井子区', NULL, '210211', '1000504', 3);
INSERT INTO `sys_address` VALUES ('1000509', '旅顺口区', NULL, '210212', '1000504', 3);
INSERT INTO `sys_address` VALUES ('1000510', '金州区', NULL, '210213', '1000504', 3);
INSERT INTO `sys_address` VALUES ('1000511', '瓦房店市', NULL, '210281', '1000504', 3);
INSERT INTO `sys_address` VALUES ('1000512', '普兰店区', NULL, '210214', '1000504', 3);
INSERT INTO `sys_address` VALUES ('1000513', '庄河市', NULL, '210283', '1000504', 3);
INSERT INTO `sys_address` VALUES ('1000514', '长海县', NULL, '210224', '1000504', 3);
INSERT INTO `sys_address` VALUES ('1000515', '鞍山市', NULL, '210300', '1000005', 2);
INSERT INTO `sys_address` VALUES ('1000516', '铁东区', NULL, '210302', '1000515', 3);
INSERT INTO `sys_address` VALUES ('1000517', '铁西区', NULL, '210303', '1000515', 3);
INSERT INTO `sys_address` VALUES ('1000518', '立山区', NULL, '210304', '1000515', 3);
INSERT INTO `sys_address` VALUES ('1000519', '千山区', NULL, '210311', '1000515', 3);
INSERT INTO `sys_address` VALUES ('1000520', '海城市', NULL, '210381', '1000515', 3);
INSERT INTO `sys_address` VALUES ('1000521', '台安县', NULL, '210321', '1000515', 3);
INSERT INTO `sys_address` VALUES ('1000522', '岫岩满族自治县', NULL, '210323', '1000515', 3);
INSERT INTO `sys_address` VALUES ('1000523', '抚顺市', NULL, '210400', '1000005', 2);
INSERT INTO `sys_address` VALUES ('1000524', '顺城区', NULL, '210411', '1000523', 3);
INSERT INTO `sys_address` VALUES ('1000525', '新抚区', NULL, '210402', '1000523', 3);
INSERT INTO `sys_address` VALUES ('1000526', '东洲区', NULL, '210403', '1000523', 3);
INSERT INTO `sys_address` VALUES ('1000527', '望花区', NULL, '210404', '1000523', 3);
INSERT INTO `sys_address` VALUES ('1000528', '抚顺县', NULL, '210421', '1000523', 3);
INSERT INTO `sys_address` VALUES ('1000529', '新宾满族自治县', NULL, '210422', '1000523', 3);
INSERT INTO `sys_address` VALUES ('1000530', '清原满族自治县', NULL, '210423', '1000523', 3);
INSERT INTO `sys_address` VALUES ('1000531', '本溪市', NULL, '210500', '1000005', 2);
INSERT INTO `sys_address` VALUES ('1000532', '平山区', NULL, '210502', '1000531', 3);
INSERT INTO `sys_address` VALUES ('1000533', '溪湖区', NULL, '210503', '1000531', 3);
INSERT INTO `sys_address` VALUES ('1000534', '明山区', NULL, '210504', '1000531', 3);
INSERT INTO `sys_address` VALUES ('1000535', '南芬区', NULL, '210505', '1000531', 3);
INSERT INTO `sys_address` VALUES ('1000536', '本溪满族自治县', NULL, '210521', '1000531', 3);
INSERT INTO `sys_address` VALUES ('1000537', '桓仁满族自治县', NULL, '210522', '1000531', 3);
INSERT INTO `sys_address` VALUES ('1000538', '丹东市', NULL, '210600', '1000005', 2);
INSERT INTO `sys_address` VALUES ('1000539', '振兴区', NULL, '210603', '1000538', 3);
INSERT INTO `sys_address` VALUES ('1000540', '元宝区', NULL, '210602', '1000538', 3);
INSERT INTO `sys_address` VALUES ('1000541', '振安区', NULL, '210604', '1000538', 3);
INSERT INTO `sys_address` VALUES ('1000542', '东港市', NULL, '210681', '1000538', 3);
INSERT INTO `sys_address` VALUES ('1000543', '凤城市', NULL, '210682', '1000538', 3);
INSERT INTO `sys_address` VALUES ('1000544', '宽甸满族自治县', NULL, '210624', '1000538', 3);
INSERT INTO `sys_address` VALUES ('1000545', '锦州市', NULL, '210700', '1000005', 2);
INSERT INTO `sys_address` VALUES ('1000546', '太和区', NULL, '210711', '1000545', 3);
INSERT INTO `sys_address` VALUES ('1000547', '古塔区', NULL, '210702', '1000545', 3);
INSERT INTO `sys_address` VALUES ('1000548', '凌河区', NULL, '210703', '1000545', 3);
INSERT INTO `sys_address` VALUES ('1000549', '凌海市', NULL, '210781', '1000545', 3);
INSERT INTO `sys_address` VALUES ('1000550', '北镇市', NULL, '210782', '1000545', 3);
INSERT INTO `sys_address` VALUES ('1000551', '黑山县', NULL, '210726', '1000545', 3);
INSERT INTO `sys_address` VALUES ('1000552', '义县', NULL, '210727', '1000545', 3);
INSERT INTO `sys_address` VALUES ('1000553', '营口市', NULL, '210800', '1000005', 2);
INSERT INTO `sys_address` VALUES ('1000554', '站前区', NULL, '210802', '1000553', 3);
INSERT INTO `sys_address` VALUES ('1000555', '西市区', NULL, '210803', '1000553', 3);
INSERT INTO `sys_address` VALUES ('1000556', '鲅鱼圈区', NULL, '210804', '1000553', 3);
INSERT INTO `sys_address` VALUES ('1000557', '老边区', NULL, '210811', '1000553', 3);
INSERT INTO `sys_address` VALUES ('1000558', '盖州市', NULL, '210881', '1000553', 3);
INSERT INTO `sys_address` VALUES ('1000559', '大石桥市', NULL, '210882', '1000553', 3);
INSERT INTO `sys_address` VALUES ('1000560', '阜新市', NULL, '210900', '1000005', 2);
INSERT INTO `sys_address` VALUES ('1000561', '细河区', NULL, '210911', '1000560', 3);
INSERT INTO `sys_address` VALUES ('1000562', '海州区', NULL, '210902', '1000560', 3);
INSERT INTO `sys_address` VALUES ('1000563', '新邱区', NULL, '210903', '1000560', 3);
INSERT INTO `sys_address` VALUES ('1000564', '太平区', NULL, '210904', '1000560', 3);
INSERT INTO `sys_address` VALUES ('1000565', '清河门区', NULL, '210905', '1000560', 3);
INSERT INTO `sys_address` VALUES ('1000566', '彰武县', NULL, '210922', '1000560', 3);
INSERT INTO `sys_address` VALUES ('1000567', '阜新蒙古族自治县', NULL, '210921', '1000560', 3);
INSERT INTO `sys_address` VALUES ('1000568', '辽阳市', NULL, '211000', '1000005', 2);
INSERT INTO `sys_address` VALUES ('1000569', '白塔区', NULL, '211002', '1000568', 3);
INSERT INTO `sys_address` VALUES ('1000570', '文圣区', NULL, '211003', '1000568', 3);
INSERT INTO `sys_address` VALUES ('1000571', '宏伟区', NULL, '211004', '1000568', 3);
INSERT INTO `sys_address` VALUES ('1000572', '弓长岭区', NULL, '211005', '1000568', 3);
INSERT INTO `sys_address` VALUES ('1000573', '太子河区', NULL, '211011', '1000568', 3);
INSERT INTO `sys_address` VALUES ('1000574', '灯塔市', NULL, '211081', '1000568', 3);
INSERT INTO `sys_address` VALUES ('1000575', '辽阳县', NULL, '211021', '1000568', 3);
INSERT INTO `sys_address` VALUES ('1000576', '盘锦市', NULL, '211100', '1000005', 2);
INSERT INTO `sys_address` VALUES ('1000577', '兴隆台区', NULL, '211103', '1000576', 3);
INSERT INTO `sys_address` VALUES ('1000578', '双台子区', NULL, '211102', '1000576', 3);
INSERT INTO `sys_address` VALUES ('1000579', '大洼区', NULL, '211104', '1000576', 3);
INSERT INTO `sys_address` VALUES ('1000580', '盘山县', NULL, '211122', '1000576', 3);
INSERT INTO `sys_address` VALUES ('1000581', '铁岭市', NULL, '211200', '1000005', 2);
INSERT INTO `sys_address` VALUES ('1000582', '银州区', NULL, '211202', '1000581', 3);
INSERT INTO `sys_address` VALUES ('1000583', '清河区', NULL, '211204', '1000581', 3);
INSERT INTO `sys_address` VALUES ('1000584', '调兵山市', NULL, '211281', '1000581', 3);
INSERT INTO `sys_address` VALUES ('1000585', '开原市', NULL, '211282', '1000581', 3);
INSERT INTO `sys_address` VALUES ('1000586', '铁岭县', NULL, '211221', '1000581', 3);
INSERT INTO `sys_address` VALUES ('1000587', '西丰县', NULL, '211223', '1000581', 3);
INSERT INTO `sys_address` VALUES ('1000588', '昌图县', NULL, '211224', '1000581', 3);
INSERT INTO `sys_address` VALUES ('1000589', '朝阳市', NULL, '211300', '1000005', 2);
INSERT INTO `sys_address` VALUES ('1000590', '双塔区', NULL, '211302', '1000589', 3);
INSERT INTO `sys_address` VALUES ('1000591', '龙城区', NULL, '211303', '1000589', 3);
INSERT INTO `sys_address` VALUES ('1000592', '北票市', NULL, '211381', '1000589', 3);
INSERT INTO `sys_address` VALUES ('1000593', '凌源市', NULL, '211382', '1000589', 3);
INSERT INTO `sys_address` VALUES ('1000594', '朝阳县', NULL, '211321', '1000589', 3);
INSERT INTO `sys_address` VALUES ('1000595', '建平县', NULL, '211322', '1000589', 3);
INSERT INTO `sys_address` VALUES ('1000596', '喀喇沁左翼蒙古族自治县', NULL, '211324', '1000589', 3);
INSERT INTO `sys_address` VALUES ('1000597', '葫芦岛市', NULL, '211400', '1000005', 2);
INSERT INTO `sys_address` VALUES ('1000598', '龙港区', NULL, '211403', '1000597', 3);
INSERT INTO `sys_address` VALUES ('1000599', '连山区', NULL, '211402', '1000597', 3);
INSERT INTO `sys_address` VALUES ('1000600', '南票区', NULL, '211404', '1000597', 3);
INSERT INTO `sys_address` VALUES ('1000601', '兴城市', NULL, '211481', '1000597', 3);
INSERT INTO `sys_address` VALUES ('1000602', '绥中县', NULL, '211421', '1000597', 3);
INSERT INTO `sys_address` VALUES ('1000603', '建昌县', NULL, '211422', '1000597', 3);
INSERT INTO `sys_address` VALUES ('1000604', '长春市', NULL, '220100', '1000006', 2);
INSERT INTO `sys_address` VALUES ('1000605', '南关区', NULL, '220102', '1000604', 3);
INSERT INTO `sys_address` VALUES ('1000606', '宽城区', NULL, '220103', '1000604', 3);
INSERT INTO `sys_address` VALUES ('1000607', '朝阳区', NULL, '220104', '1000604', 3);
INSERT INTO `sys_address` VALUES ('1000608', '二道区', NULL, '220105', '1000604', 3);
INSERT INTO `sys_address` VALUES ('1000609', '绿园区', NULL, '220106', '1000604', 3);
INSERT INTO `sys_address` VALUES ('1000610', '双阳区', NULL, '220112', '1000604', 3);
INSERT INTO `sys_address` VALUES ('1000611', '九台区', NULL, '220113', '1000604', 3);
INSERT INTO `sys_address` VALUES ('1000612', '榆树市', NULL, '220182', '1000604', 3);
INSERT INTO `sys_address` VALUES ('1000613', '德惠市', NULL, '220183', '1000604', 3);
INSERT INTO `sys_address` VALUES ('1000614', '农安县', NULL, '220122', '1000604', 3);
INSERT INTO `sys_address` VALUES ('1000615', '吉林市', NULL, '220200', '1000006', 2);
INSERT INTO `sys_address` VALUES ('1000616', '船营区', NULL, '220204', '1000615', 3);
INSERT INTO `sys_address` VALUES ('1000617', '昌邑区', NULL, '220202', '1000615', 3);
INSERT INTO `sys_address` VALUES ('1000618', '龙潭区', NULL, '220203', '1000615', 3);
INSERT INTO `sys_address` VALUES ('1000619', '丰满区', NULL, '220211', '1000615', 3);
INSERT INTO `sys_address` VALUES ('1000620', '蛟河市', NULL, '220281', '1000615', 3);
INSERT INTO `sys_address` VALUES ('1000621', '桦甸市', NULL, '220282', '1000615', 3);
INSERT INTO `sys_address` VALUES ('1000622', '舒兰市', NULL, '220283', '1000615', 3);
INSERT INTO `sys_address` VALUES ('1000623', '磐石市', NULL, '220284', '1000615', 3);
INSERT INTO `sys_address` VALUES ('1000624', '永吉县', NULL, '220221', '1000615', 3);
INSERT INTO `sys_address` VALUES ('1000625', '四平市', NULL, '220300', '1000006', 2);
INSERT INTO `sys_address` VALUES ('1000626', '铁西区', NULL, '220302', '1000625', 3);
INSERT INTO `sys_address` VALUES ('1000627', '铁东区', NULL, '220303', '1000625', 3);
INSERT INTO `sys_address` VALUES ('1000628', '公主岭市', NULL, '220381', '1000625', 3);
INSERT INTO `sys_address` VALUES ('1000629', '双辽市', NULL, '220382', '1000625', 3);
INSERT INTO `sys_address` VALUES ('1000630', '梨树县', NULL, '220322', '1000625', 3);
INSERT INTO `sys_address` VALUES ('1000631', '伊通满族自治县', NULL, '220323', '1000625', 3);
INSERT INTO `sys_address` VALUES ('1000632', '辽源市', NULL, '220400', '1000006', 2);
INSERT INTO `sys_address` VALUES ('1000633', '龙山区', NULL, '220402', '1000632', 3);
INSERT INTO `sys_address` VALUES ('1000634', '西安区', NULL, '220403', '1000632', 3);
INSERT INTO `sys_address` VALUES ('1000635', '东丰县', NULL, '220421', '1000632', 3);
INSERT INTO `sys_address` VALUES ('1000636', '东辽县', NULL, '220422', '1000632', 3);
INSERT INTO `sys_address` VALUES ('1000637', '通化市', NULL, '220500', '1000006', 2);
INSERT INTO `sys_address` VALUES ('1000638', '东昌区', NULL, '220502', '1000637', 3);
INSERT INTO `sys_address` VALUES ('1000639', '二道江区', NULL, '220503', '1000637', 3);
INSERT INTO `sys_address` VALUES ('1000640', '梅河口市', NULL, '220581', '1000637', 3);
INSERT INTO `sys_address` VALUES ('1000641', '集安市', NULL, '220582', '1000637', 3);
INSERT INTO `sys_address` VALUES ('1000642', '通化县', NULL, '220521', '1000637', 3);
INSERT INTO `sys_address` VALUES ('1000643', '辉南县', NULL, '220523', '1000637', 3);
INSERT INTO `sys_address` VALUES ('1000644', '柳河县', NULL, '220524', '1000637', 3);
INSERT INTO `sys_address` VALUES ('1000645', '白山市', NULL, '220600', '1000006', 2);
INSERT INTO `sys_address` VALUES ('1000646', '浑江区', NULL, '220602', '1000645', 3);
INSERT INTO `sys_address` VALUES ('1000647', '江源区', NULL, '220605', '1000645', 3);
INSERT INTO `sys_address` VALUES ('1000648', '临江市', NULL, '220681', '1000645', 3);
INSERT INTO `sys_address` VALUES ('1000649', '抚松县', NULL, '220621', '1000645', 3);
INSERT INTO `sys_address` VALUES ('1000650', '靖宇县', NULL, '220622', '1000645', 3);
INSERT INTO `sys_address` VALUES ('1000651', '长白朝鲜族自治县', NULL, '220623', '1000645', 3);
INSERT INTO `sys_address` VALUES ('1000652', '松原市', NULL, '220700', '1000006', 2);
INSERT INTO `sys_address` VALUES ('1000653', '宁江区', NULL, '220702', '1000652', 3);
INSERT INTO `sys_address` VALUES ('1000654', '扶余市', NULL, '220781', '1000652', 3);
INSERT INTO `sys_address` VALUES ('1000655', '长岭县', NULL, '220722', '1000652', 3);
INSERT INTO `sys_address` VALUES ('1000656', '乾安县', NULL, '220723', '1000652', 3);
INSERT INTO `sys_address` VALUES ('1000657', '前郭尔罗斯蒙古族自治县', NULL, '220721', '1000652', 3);
INSERT INTO `sys_address` VALUES ('1000658', '白城市', NULL, '220800', '1000006', 2);
INSERT INTO `sys_address` VALUES ('1000659', '洮北区', NULL, '220802', '1000658', 3);
INSERT INTO `sys_address` VALUES ('1000660', '洮南市', NULL, '220881', '1000658', 3);
INSERT INTO `sys_address` VALUES ('1000661', '大安市', NULL, '220882', '1000658', 3);
INSERT INTO `sys_address` VALUES ('1000662', '镇赉县', NULL, '220821', '1000658', 3);
INSERT INTO `sys_address` VALUES ('1000663', '通榆县', NULL, '220822', '1000658', 3);
INSERT INTO `sys_address` VALUES ('1000664', '延边朝鲜族自治州', NULL, '222400', '1000006', 2);
INSERT INTO `sys_address` VALUES ('1000665', '延吉市', NULL, '222401', '1000664', 3);
INSERT INTO `sys_address` VALUES ('1000666', '图们市', NULL, '222402', '1000664', 3);
INSERT INTO `sys_address` VALUES ('1000667', '敦化市', NULL, '222403', '1000664', 3);
INSERT INTO `sys_address` VALUES ('1000668', '珲春市', NULL, '222404', '1000664', 3);
INSERT INTO `sys_address` VALUES ('1000669', '龙井市', NULL, '222405', '1000664', 3);
INSERT INTO `sys_address` VALUES ('1000670', '和龙市', NULL, '222406', '1000664', 3);
INSERT INTO `sys_address` VALUES ('1000671', '汪清县', NULL, '222424', '1000664', 3);
INSERT INTO `sys_address` VALUES ('1000672', '安图县', NULL, '222426', '1000664', 3);
INSERT INTO `sys_address` VALUES ('1000673', '哈尔滨市', NULL, '230100', '1000007', 2);
INSERT INTO `sys_address` VALUES ('1000674', '松北区', NULL, '230109', '1000673', 3);
INSERT INTO `sys_address` VALUES ('1000675', '道里区', NULL, '230102', '1000673', 3);
INSERT INTO `sys_address` VALUES ('1000676', '南岗区', NULL, '230103', '1000673', 3);
INSERT INTO `sys_address` VALUES ('1000677', '道外区', NULL, '230104', '1000673', 3);
INSERT INTO `sys_address` VALUES ('1000678', '平房区', NULL, '230108', '1000673', 3);
INSERT INTO `sys_address` VALUES ('1000679', '香坊区', NULL, '230110', '1000673', 3);
INSERT INTO `sys_address` VALUES ('1000680', '呼兰区', NULL, '230111', '1000673', 3);
INSERT INTO `sys_address` VALUES ('1000681', '阿城区', NULL, '230112', '1000673', 3);
INSERT INTO `sys_address` VALUES ('1000682', '双城区', NULL, '230113', '1000673', 3);
INSERT INTO `sys_address` VALUES ('1000683', '尚志市', NULL, '230183', '1000673', 3);
INSERT INTO `sys_address` VALUES ('1000684', '五常市', NULL, '230184', '1000673', 3);
INSERT INTO `sys_address` VALUES ('1000685', '依兰县', NULL, '230123', '1000673', 3);
INSERT INTO `sys_address` VALUES ('1000686', '方正县', NULL, '230124', '1000673', 3);
INSERT INTO `sys_address` VALUES ('1000687', '宾县', NULL, '230125', '1000673', 3);
INSERT INTO `sys_address` VALUES ('1000688', '巴彦县', NULL, '230126', '1000673', 3);
INSERT INTO `sys_address` VALUES ('1000689', '木兰县', NULL, '230127', '1000673', 3);
INSERT INTO `sys_address` VALUES ('1000690', '通河县', NULL, '230128', '1000673', 3);
INSERT INTO `sys_address` VALUES ('1000691', '延寿县', NULL, '230129', '1000673', 3);
INSERT INTO `sys_address` VALUES ('1000692', '齐齐哈尔市', NULL, '230200', '1000007', 2);
INSERT INTO `sys_address` VALUES ('1000693', '建华区', NULL, '230203', '1000692', 3);
INSERT INTO `sys_address` VALUES ('1000694', '龙沙区', NULL, '230202', '1000692', 3);
INSERT INTO `sys_address` VALUES ('1000695', '铁锋区', NULL, '230204', '1000692', 3);
INSERT INTO `sys_address` VALUES ('1000696', '昂昂溪区', NULL, '230205', '1000692', 3);
INSERT INTO `sys_address` VALUES ('1000697', '富拉尔基区', NULL, '230206', '1000692', 3);
INSERT INTO `sys_address` VALUES ('1000698', '碾子山区', NULL, '230207', '1000692', 3);
INSERT INTO `sys_address` VALUES ('1000699', '梅里斯达斡尔族区', NULL, '230208', '1000692', 3);
INSERT INTO `sys_address` VALUES ('1000700', '讷河市', NULL, '230281', '1000692', 3);
INSERT INTO `sys_address` VALUES ('1000701', '龙江县', NULL, '230221', '1000692', 3);
INSERT INTO `sys_address` VALUES ('1000702', '依安县', NULL, '230223', '1000692', 3);
INSERT INTO `sys_address` VALUES ('1000703', '泰来县', NULL, '230224', '1000692', 3);
INSERT INTO `sys_address` VALUES ('1000704', '甘南县', NULL, '230225', '1000692', 3);
INSERT INTO `sys_address` VALUES ('1000705', '富裕县', NULL, '230227', '1000692', 3);
INSERT INTO `sys_address` VALUES ('1000706', '克山县', NULL, '230229', '1000692', 3);
INSERT INTO `sys_address` VALUES ('1000707', '克东县', NULL, '230230', '1000692', 3);
INSERT INTO `sys_address` VALUES ('1000708', '拜泉县', NULL, '230231', '1000692', 3);
INSERT INTO `sys_address` VALUES ('1000709', '鸡西市', NULL, '230300', '1000007', 2);
INSERT INTO `sys_address` VALUES ('1000710', '鸡冠区', NULL, '230302', '1000709', 3);
INSERT INTO `sys_address` VALUES ('1000711', '恒山区', NULL, '230303', '1000709', 3);
INSERT INTO `sys_address` VALUES ('1000712', '滴道区', NULL, '230304', '1000709', 3);
INSERT INTO `sys_address` VALUES ('1000713', '梨树区', NULL, '230305', '1000709', 3);
INSERT INTO `sys_address` VALUES ('1000714', '城子河区', NULL, '230306', '1000709', 3);
INSERT INTO `sys_address` VALUES ('1000715', '麻山区', NULL, '230307', '1000709', 3);
INSERT INTO `sys_address` VALUES ('1000716', '虎林市', NULL, '230381', '1000709', 3);
INSERT INTO `sys_address` VALUES ('1000717', '密山市', NULL, '230382', '1000709', 3);
INSERT INTO `sys_address` VALUES ('1000718', '鸡东县', NULL, '230321', '1000709', 3);
INSERT INTO `sys_address` VALUES ('1000719', '鹤岗市', NULL, '230400', '1000007', 2);
INSERT INTO `sys_address` VALUES ('1000720', '向阳区', NULL, '230402', '1000719', 3);
INSERT INTO `sys_address` VALUES ('1000721', '工农区', NULL, '230403', '1000719', 3);
INSERT INTO `sys_address` VALUES ('1000722', '南山区', NULL, '230404', '1000719', 3);
INSERT INTO `sys_address` VALUES ('1000723', '兴安区', NULL, '230405', '1000719', 3);
INSERT INTO `sys_address` VALUES ('1000724', '东山区', NULL, '230406', '1000719', 3);
INSERT INTO `sys_address` VALUES ('1000725', '兴山区', NULL, '230407', '1000719', 3);
INSERT INTO `sys_address` VALUES ('1000726', '萝北县', NULL, '230421', '1000719', 3);
INSERT INTO `sys_address` VALUES ('1000727', '绥滨县', NULL, '230422', '1000719', 3);
INSERT INTO `sys_address` VALUES ('1000728', '双鸭山市', NULL, '230500', '1000007', 2);
INSERT INTO `sys_address` VALUES ('1000729', '尖山区', NULL, '230502', '1000728', 3);
INSERT INTO `sys_address` VALUES ('1000730', '岭东区', NULL, '230503', '1000728', 3);
INSERT INTO `sys_address` VALUES ('1000731', '四方台区', NULL, '230505', '1000728', 3);
INSERT INTO `sys_address` VALUES ('1000732', '宝山区', NULL, '230506', '1000728', 3);
INSERT INTO `sys_address` VALUES ('1000733', '集贤县', NULL, '230521', '1000728', 3);
INSERT INTO `sys_address` VALUES ('1000734', '友谊县', NULL, '230522', '1000728', 3);
INSERT INTO `sys_address` VALUES ('1000735', '宝清县', NULL, '230523', '1000728', 3);
INSERT INTO `sys_address` VALUES ('1000736', '饶河县', NULL, '230524', '1000728', 3);
INSERT INTO `sys_address` VALUES ('1000737', '大庆市', NULL, '230600', '1000007', 2);
INSERT INTO `sys_address` VALUES ('1000738', '萨尔图区', NULL, '230602', '1000737', 3);
INSERT INTO `sys_address` VALUES ('1000739', '龙凤区', NULL, '230603', '1000737', 3);
INSERT INTO `sys_address` VALUES ('1000740', '让胡路区', NULL, '230604', '1000737', 3);
INSERT INTO `sys_address` VALUES ('1000741', '红岗区', NULL, '230605', '1000737', 3);
INSERT INTO `sys_address` VALUES ('1000742', '大同区', NULL, '230606', '1000737', 3);
INSERT INTO `sys_address` VALUES ('1000743', '肇州县', NULL, '230621', '1000737', 3);
INSERT INTO `sys_address` VALUES ('1000744', '肇源县', NULL, '230622', '1000737', 3);
INSERT INTO `sys_address` VALUES ('1000745', '林甸县', NULL, '230623', '1000737', 3);
INSERT INTO `sys_address` VALUES ('1000746', '杜尔伯特蒙古族自治县', NULL, '230624', '1000737', 3);
INSERT INTO `sys_address` VALUES ('1000747', '伊春市', NULL, '230700', '1000007', 2);
INSERT INTO `sys_address` VALUES ('1000748', '伊春区', NULL, '230702', '1000747', 3);
INSERT INTO `sys_address` VALUES ('1000749', '南岔区', NULL, '230703', '1000747', 3);
INSERT INTO `sys_address` VALUES ('1000750', '友好区', NULL, '230704', '1000747', 3);
INSERT INTO `sys_address` VALUES ('1000751', '西林区', NULL, '230705', '1000747', 3);
INSERT INTO `sys_address` VALUES ('1000752', '翠峦区', NULL, '230706', '1000747', 3);
INSERT INTO `sys_address` VALUES ('1000753', '新青区', NULL, '230707', '1000747', 3);
INSERT INTO `sys_address` VALUES ('1000754', '美溪区', NULL, '230708', '1000747', 3);
INSERT INTO `sys_address` VALUES ('1000755', '金山屯区', NULL, '230709', '1000747', 3);
INSERT INTO `sys_address` VALUES ('1000756', '五营区', NULL, '230710', '1000747', 3);
INSERT INTO `sys_address` VALUES ('1000757', '乌马河区', NULL, '230711', '1000747', 3);
INSERT INTO `sys_address` VALUES ('1000758', '汤旺河区', NULL, '230712', '1000747', 3);
INSERT INTO `sys_address` VALUES ('1000759', '带岭区', NULL, '230713', '1000747', 3);
INSERT INTO `sys_address` VALUES ('1000760', '乌伊岭区', NULL, '230714', '1000747', 3);
INSERT INTO `sys_address` VALUES ('1000761', '红星区', NULL, '230715', '1000747', 3);
INSERT INTO `sys_address` VALUES ('1000762', '上甘岭区', NULL, '230716', '1000747', 3);
INSERT INTO `sys_address` VALUES ('1000763', '铁力市', NULL, '230781', '1000747', 3);
INSERT INTO `sys_address` VALUES ('1000764', '嘉荫县', NULL, '230722', '1000747', 3);
INSERT INTO `sys_address` VALUES ('1000765', '佳木斯市', NULL, '230800', '1000007', 2);
INSERT INTO `sys_address` VALUES ('1000766', '前进区', NULL, '230804', '1000765', 3);
INSERT INTO `sys_address` VALUES ('1000767', '向阳区', NULL, '230803', '1000765', 3);
INSERT INTO `sys_address` VALUES ('1000768', '东风区', NULL, '230805', '1000765', 3);
INSERT INTO `sys_address` VALUES ('1000769', '郊区', NULL, '230811', '1000765', 3);
INSERT INTO `sys_address` VALUES ('1000770', '同江市', NULL, '230881', '1000765', 3);
INSERT INTO `sys_address` VALUES ('1000771', '富锦市', NULL, '230882', '1000765', 3);
INSERT INTO `sys_address` VALUES ('1000772', '抚远市', NULL, '230883', '1000765', 3);
INSERT INTO `sys_address` VALUES ('1000773', '桦南县', NULL, '230822', '1000765', 3);
INSERT INTO `sys_address` VALUES ('1000774', '桦川县', NULL, '230826', '1000765', 3);
INSERT INTO `sys_address` VALUES ('1000775', '汤原县', NULL, '230828', '1000765', 3);
INSERT INTO `sys_address` VALUES ('1000776', '七台河市', NULL, '230900', '1000007', 2);
INSERT INTO `sys_address` VALUES ('1000777', '桃山区', NULL, '230903', '1000776', 3);
INSERT INTO `sys_address` VALUES ('1000778', '新兴区', NULL, '230902', '1000776', 3);
INSERT INTO `sys_address` VALUES ('1000779', '茄子河区', NULL, '230904', '1000776', 3);
INSERT INTO `sys_address` VALUES ('1000780', '勃利县', NULL, '230921', '1000776', 3);
INSERT INTO `sys_address` VALUES ('1000781', '牡丹江市', NULL, '231000', '1000007', 2);
INSERT INTO `sys_address` VALUES ('1000782', '东安区', NULL, '231002', '1000781', 3);
INSERT INTO `sys_address` VALUES ('1000783', '阳明区', NULL, '231003', '1000781', 3);
INSERT INTO `sys_address` VALUES ('1000784', '爱民区', NULL, '231004', '1000781', 3);
INSERT INTO `sys_address` VALUES ('1000785', '西安区', NULL, '231005', '1000781', 3);
INSERT INTO `sys_address` VALUES ('1000786', '绥芬河市', NULL, '231081', '1000781', 3);
INSERT INTO `sys_address` VALUES ('1000787', '海林市', NULL, '231083', '1000781', 3);
INSERT INTO `sys_address` VALUES ('1000788', '宁安市', NULL, '231084', '1000781', 3);
INSERT INTO `sys_address` VALUES ('1000789', '穆棱市', NULL, '231085', '1000781', 3);
INSERT INTO `sys_address` VALUES ('1000790', '东宁市', NULL, '231086', '1000781', 3);
INSERT INTO `sys_address` VALUES ('1000791', '林口县', NULL, '231025', '1000781', 3);
INSERT INTO `sys_address` VALUES ('1000792', '黑河市', NULL, '231100', '1000007', 2);
INSERT INTO `sys_address` VALUES ('1000793', '爱辉区', NULL, '231102', '1000792', 3);
INSERT INTO `sys_address` VALUES ('1000794', '北安市', NULL, '231181', '1000792', 3);
INSERT INTO `sys_address` VALUES ('1000795', '五大连池市', NULL, '231182', '1000792', 3);
INSERT INTO `sys_address` VALUES ('1000796', '嫩江县', NULL, '231121', '1000792', 3);
INSERT INTO `sys_address` VALUES ('1000797', '逊克县', NULL, '231123', '1000792', 3);
INSERT INTO `sys_address` VALUES ('1000798', '孙吴县', NULL, '231124', '1000792', 3);
INSERT INTO `sys_address` VALUES ('1000799', '绥化市', NULL, '231200', '1000007', 2);
INSERT INTO `sys_address` VALUES ('1000800', '北林区', NULL, '231202', '1000799', 3);
INSERT INTO `sys_address` VALUES ('1000801', '安达市', NULL, '231281', '1000799', 3);
INSERT INTO `sys_address` VALUES ('1000802', '肇东市', NULL, '231282', '1000799', 3);
INSERT INTO `sys_address` VALUES ('1000803', '海伦市', NULL, '231283', '1000799', 3);
INSERT INTO `sys_address` VALUES ('1000804', '望奎县', NULL, '231221', '1000799', 3);
INSERT INTO `sys_address` VALUES ('1000805', '兰西县', NULL, '231222', '1000799', 3);
INSERT INTO `sys_address` VALUES ('1000806', '青冈县', NULL, '231223', '1000799', 3);
INSERT INTO `sys_address` VALUES ('1000807', '庆安县', NULL, '231224', '1000799', 3);
INSERT INTO `sys_address` VALUES ('1000808', '明水县', NULL, '231225', '1000799', 3);
INSERT INTO `sys_address` VALUES ('1000809', '绥棱县', NULL, '231226', '1000799', 3);
INSERT INTO `sys_address` VALUES ('1000810', '大兴安岭地区', NULL, '232700', '1000007', 2);
INSERT INTO `sys_address` VALUES ('1000811', '呼玛县', NULL, '232721', '1000810', 3);
INSERT INTO `sys_address` VALUES ('1000812', '塔河县', NULL, '232722', '1000810', 3);
INSERT INTO `sys_address` VALUES ('1000813', '漠河县', NULL, '232723', '1000810', 3);
INSERT INTO `sys_address` VALUES ('1000814', '黄浦区', NULL, '310101', '1000008', 2);
INSERT INTO `sys_address` VALUES ('1000815', '徐汇区', NULL, '310104', '1000008', 2);
INSERT INTO `sys_address` VALUES ('1000816', '长宁区', NULL, '310105', '1000008', 2);
INSERT INTO `sys_address` VALUES ('1000817', '静安区', NULL, '310106', '1000008', 2);
INSERT INTO `sys_address` VALUES ('1000818', '普陀区', NULL, '310107', '1000008', 2);
INSERT INTO `sys_address` VALUES ('1000819', '虹口区', NULL, '310109', '1000008', 2);
INSERT INTO `sys_address` VALUES ('1000820', '杨浦区', NULL, '310110', '1000008', 2);
INSERT INTO `sys_address` VALUES ('1000821', '闵行区', NULL, '310112', '1000008', 2);
INSERT INTO `sys_address` VALUES ('1000822', '宝山区', NULL, '310113', '1000008', 2);
INSERT INTO `sys_address` VALUES ('1000823', '嘉定区', NULL, '310114', '1000008', 2);
INSERT INTO `sys_address` VALUES ('1000824', '浦东新区', NULL, '310115', '1000008', 2);
INSERT INTO `sys_address` VALUES ('1000825', '金山区', NULL, '310116', '1000008', 2);
INSERT INTO `sys_address` VALUES ('1000826', '松江区', NULL, '310117', '1000008', 2);
INSERT INTO `sys_address` VALUES ('1000827', '青浦区', NULL, '310118', '1000008', 2);
INSERT INTO `sys_address` VALUES ('1000828', '奉贤区', NULL, '310120', '1000008', 2);
INSERT INTO `sys_address` VALUES ('1000829', '崇明区', NULL, '310151', '1000008', 2);
INSERT INTO `sys_address` VALUES ('1000830', '南京市', NULL, '320100', '1000009', 2);
INSERT INTO `sys_address` VALUES ('1000831', '玄武区', NULL, '320102', '1000830', 3);
INSERT INTO `sys_address` VALUES ('1000832', '秦淮区', NULL, '320104', '1000830', 3);
INSERT INTO `sys_address` VALUES ('1000833', '建邺区', NULL, '320105', '1000830', 3);
INSERT INTO `sys_address` VALUES ('1000834', '鼓楼区', NULL, '320106', '1000830', 3);
INSERT INTO `sys_address` VALUES ('1000835', '浦口区', NULL, '320111', '1000830', 3);
INSERT INTO `sys_address` VALUES ('1000836', '栖霞区', NULL, '320113', '1000830', 3);
INSERT INTO `sys_address` VALUES ('1000837', '雨花台区', NULL, '320114', '1000830', 3);
INSERT INTO `sys_address` VALUES ('1000838', '江宁区', NULL, '320115', '1000830', 3);
INSERT INTO `sys_address` VALUES ('1000839', '六合区', NULL, '320116', '1000830', 3);
INSERT INTO `sys_address` VALUES ('1000840', '溧水区', NULL, '320117', '1000830', 3);
INSERT INTO `sys_address` VALUES ('1000841', '高淳区', NULL, '320118', '1000830', 3);
INSERT INTO `sys_address` VALUES ('1000842', '无锡市', NULL, '320200', '1000009', 2);
INSERT INTO `sys_address` VALUES ('1000843', '锡山区', NULL, '320205', '1000842', 3);
INSERT INTO `sys_address` VALUES ('1000844', '惠山区', NULL, '320206', '1000842', 3);
INSERT INTO `sys_address` VALUES ('1000845', '滨湖区', NULL, '320211', '1000842', 3);
INSERT INTO `sys_address` VALUES ('1000846', '梁溪区', NULL, '320213', '1000842', 3);
INSERT INTO `sys_address` VALUES ('1000847', '新吴区', NULL, '320214', '1000842', 3);

下接章节链接

版权声明：本文为其他博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载。原文链接

二进制诗人
关注
  • 12
    点赞
  • 踩
  • 7
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
专栏目录
中国省-市-县级联
创造自我、追求无我
07-20 1055
背景：   在学习ASP.net的时候讲到一个控件—DropDownList（表示允许用户从下拉框中选择一项的控件）。视屏中是中国省，市的级联，不过只是一小部分。自己脑子一热，索性把中国所有的省、市、县的全做了，以后用着方便。    步骤：    1、准备数据库    把中国所有的省、市、县录入数据库。当然自己没有那么勤快了，我是从网上下载的。下载链接：http://yunpan.cn/c
全国省市县级联菜单数据库
03-24
全国省市县级联菜单数据库是一种用于构建具有完整中国行政区域层级关系的数据结构，它通常由三个主要部分组成：省、市、县（区）三级数据表。这种数据库设计旨在支持高效检索和展示中国各地的地区信息，尤其适用于...
省市县级联
09-23
省市县级联
省市县三级级联
chongfumang5782的博客
12-08 115
####主要思想 1.省改变，市改变，并初始化县 2.市改变，县改变 ####html代码 <select id="sheng"> <option value="">--请选择--</option> <option value="0">北京市&l...
AJAX.全国省市县级联 JS+数据库
08-26
全国省市县级联 JS+数据库"涉及到的是在网页开发中使用AJAX（Asynchronous JavaScript and XML）技术实现全国省市县级数据的联动加载与展示。这一技术通常用于用户在选择省份时，根据省份的选择动态加载对应的市、县...
省市级联demo-学习用-数据库版
05-25
1. **数据库设计**：如何规划和创建存储省市区数据的数据库表结构。 2. **Ajax技术**：理解Ajax的工作原理，如何编写Ajax请求，以及处理返回的数据。 3. **前端交互**：利用JavaScript和HTML实现用户界面的交互，...
中国所有省市县数据库表包含数据.rar
04-22
在我们所讨论的“中国所有省市县数据库表包含数据.rar”压缩包中，包含了名为“js_sys_area_data.sql”的文件，这是一个SQL脚本文件，用于创建和填充一个描述中国行政区域结构的数据库表。 首先，我们需要了解...
django实现省市县级联菜单
08-10
在本文中，我们将深入探讨如何使用Django框架实现省市县级联菜单。Django是一个功能强大的Python Web开发框架，以其高效、简洁和可扩展性而受到广泛赞誉。在Web应用程序中，级联下拉菜单通常用于表示地理位置信息，...
省市县级联demo
09-19
通过js控制的省市县级联demo,可直接在网页运行看效果，附加5秒网页跳转案例，都可直接运行看效果，代码简单明了，欢迎借鉴~
全国地区省市县级联关系表
05-24
包含、全国、华中、华南等7大区、省、市、县、层级/级联关系
省市县（区）三级级联
05-06
最全的省市县（区）三级级联，同时有json数据和mysql数据库文件，可以相互参照，文件内是html+jquery+json数据的例子，数据库可自己参照修改
省市县三级级联select
10-27
里面有三个文件，jq和html放一起，pro省市县文件最好和你的jsp界面在同一目录下
省市县三级联动.zip
09-11
此为省市县三级联动数据库表,和js实现. 可以很方便的实现省市县的字典
省市县级联 年月日级联
weixin_30457065的博客
03-24 155
//省市县json串 var cityInfo = { 'province':{'11':'北京','12':'天津','13':'河北','14':'山西','15':'内蒙古','21':'辽宁','22':'吉林','23':'黑龙江','31':'上海','32':'江苏','33':'浙江','34':'安徽','35':'福建','36':'江西','37':'山东...
省市县三级级联（模块化开发）
不动声色的小蜗牛的博客
07-27 273
不废话，上代码： 先看一下项目列表： tool包里的代码： 请看：tool包 vo.Area类： package com.jd.vo; public class Area { private String id; private String name; private String code; private String parentCode; public Area(String id, String name, String code, String parentCode)
用jaxa做一个省市县级联的Demo
Endless love
07-25 366
用jaxa做一个省市县级联的Demo 完整代码加数据都在连接里 连接 连接有数据，代码如下： &lt;!DOCTYPE html&gt; &lt;html lang="en"&gt; &lt;head&gt; &lt;meta charset="UTF-8"&gt; &lt;title&gt;Document&lt;/title&gt; &l
全国省市区(县)级联一张表 -sql
11-28
sql 一个表创建全国省、市、区，全国省市区三级地区含同一张表里，解压可直接使用。内含表结构，及所有插入语句
使用el-cascader和vue3封装一个省市县级联组件
最新发布
05-29
好的，以下是使用`el-cascader`和Vue3封装的省市县级联组件示例代码： ```vue <template> <el-cascader :options="options" :props="{ value: 'name', label: 'name', children: 'children' }" :change-on-select="true" v-model="selectedValues" @change="handleChange" /> </template> <script> import { reactive, toRefs } from 'vue' import { getCities } from '@/api/city' // 此处需要自己实现获取城市数据的方法 export default { setup() { const state = reactive({ options: [], selectedValues: [], }) // 初始化省市县数据 const initOptions = async () => { const provinces = await getCities() state.options = provinces.map(province => ({ name: province.name, children: province.cities.map(city => ({ name: city.name, children: city.districts.map(district => ({ name: district.name, })), })), })) } // 监听选中值的变化 const handleChange = (value) => { state.selectedValues = value // 在这里可以触发选中值变化的回调函数 } // 初始化省市县数据 initOptions() // 返回 selectedValues 和 handleChange，以便在父组件中使用 return { ...toRefs(state), handleChange, } }, } </script> ``` 上述代码中，我们使用了`reactive`和`toRefs`来创建响应式数据，使用`getCities`方法获取省市县数据，初始化`options`选项，当选中值发生变化时触发`handleChange`回调函数。在父组件中使用该组件时，只需要监听`selectedValues`和`handleChange`即可。需要注意的是，`getCities`方法需要自己实现，可以从后端接口获取数据或者使用本地静态文件。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

二进制诗人

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值