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

上接上个章节

INSERT INTO `sys_address` VALUES ('1002500', '红花岗区', NULL, '520302', '1002498', 3);
INSERT INTO `sys_address` VALUES ('1002501', '播州区', NULL, '520304', '1002498', 3);
INSERT INTO `sys_address` VALUES ('1002502', '赤水市', NULL, '520381', '1002498', 3);
INSERT INTO `sys_address` VALUES ('1002503', '仁怀市', NULL, '520382', '1002498', 3);
INSERT INTO `sys_address` VALUES ('1002504', '桐梓县', NULL, '520322', '1002498', 3);
INSERT INTO `sys_address` VALUES ('1002505', '绥阳县', NULL, '520323', '1002498', 3);
INSERT INTO `sys_address` VALUES ('1002506', '正安县', NULL, '520324', '1002498', 3);
INSERT INTO `sys_address` VALUES ('1002507', '凤冈县', NULL, '520327', '1002498', 3);
INSERT INTO `sys_address` VALUES ('1002508', '湄潭县', NULL, '520328', '1002498', 3);
INSERT INTO `sys_address` VALUES ('1002509', '余庆县', NULL, '520329', '1002498', 3);
INSERT INTO `sys_address` VALUES ('1002510', '习水县', NULL, '520330', '1002498', 3);
INSERT INTO `sys_address` VALUES ('1002511', '道真仡佬族苗族自治县', NULL, '520325', '1002498', 3);
INSERT INTO `sys_address` VALUES ('1002512', '务川仡佬族苗族自治县', NULL, '520326', '1002498', 3);
INSERT INTO `sys_address` VALUES ('1002513', '安顺市', NULL, '520400', '1000023', 2);
INSERT INTO `sys_address` VALUES ('1002514', '西秀区', NULL, '520402', '1002513', 3);
INSERT INTO `sys_address` VALUES ('1002515', '平坝区', NULL, '520403', '1002513', 3);
INSERT INTO `sys_address` VALUES ('1002516', '普定县', NULL, '520422', '1002513', 3);
INSERT INTO `sys_address` VALUES ('1002517', '镇宁布依族苗族自治县', NULL, '520423', '1002513', 3);
INSERT INTO `sys_address` VALUES ('1002518', '关岭布依族苗族自治县', NULL, '520424', '1002513', 3);
INSERT INTO `sys_address` VALUES ('1002519', '紫云苗族布依族自治县', NULL, '520425', '1002513', 3);
INSERT INTO `sys_address` VALUES ('1002520', '毕节市', NULL, '520500', '1000023', 2);
INSERT INTO `sys_address` VALUES ('1002521', '七星关区', NULL, '520502', '1002520', 3);
INSERT INTO `sys_address` VALUES ('1002522', '大方县', NULL, '520521', '1002520', 3);
INSERT INTO `sys_address` VALUES ('1002523', '黔西县', NULL, '520522', '1002520', 3);
INSERT INTO `sys_address` VALUES ('1002524', '金沙县', NULL, '520523', '1002520', 3);
INSERT INTO `sys_address` VALUES ('1002525', '织金县', NULL, '520524', '1002520', 3);
INSERT INTO `sys_address` VALUES ('1002526', '纳雍县', NULL, '520525', '1002520', 3);
INSERT INTO `sys_address` VALUES ('1002527', '赫章县', NULL, '520527', '1002520', 3);
INSERT INTO `sys_address` VALUES ('1002528', '威宁彝族回族苗族自治县', NULL, '520526', '1002520', 3);
INSERT INTO `sys_address` VALUES ('1002529', '铜仁市', NULL, '520600', '1000023', 2);
INSERT INTO `sys_address` VALUES ('1002530', '碧江区', NULL, '520602', '1002529', 3);
INSERT INTO `sys_address` VALUES ('1002531', '万山区', NULL, '520603', '1002529', 3);
INSERT INTO `sys_address` VALUES ('1002532', '江口县', NULL, '520621', '1002529', 3);
INSERT INTO `sys_address` VALUES ('1002533', '石阡县', NULL, '520623', '1002529', 3);
INSERT INTO `sys_address` VALUES ('1002534', '思南县', NULL, '520624', '1002529', 3);
INSERT INTO `sys_address` VALUES ('1002535', '德江县', NULL, '520626', '1002529', 3);
INSERT INTO `sys_address` VALUES ('1002536', '玉屏侗族自治县', NULL, '520622', '1002529', 3);
INSERT INTO `sys_address` VALUES ('1002537', '印江土家族苗族自治县', NULL, '520625', '1002529', 3);
INSERT INTO `sys_address` VALUES ('1002538', '沿河土家族自治县', NULL, '520627', '1002529', 3);
INSERT INTO `sys_address` VALUES ('1002539', '松桃苗族自治县', NULL, '520628', '1002529', 3);
INSERT INTO `sys_address` VALUES ('1002540', '黔西南布依族苗族自治州', NULL, '522300', '1000023', 2);
INSERT INTO `sys_address` VALUES ('1002541', '兴义市', NULL, '522301', '1002540', 3);
INSERT INTO `sys_address` VALUES ('1002542', '兴仁县', NULL, '522322', '1002540', 3);
INSERT INTO `sys_address` VALUES ('1002543', '普安县', NULL, '522323', '1002540', 3);
INSERT INTO `sys_address` VALUES ('1002544', '晴隆县', NULL, '522324', '1002540', 3);
INSERT INTO `sys_address` VALUES ('1002545', '贞丰县', NULL, '522325', '1002540', 3);
INSERT INTO `sys_address` VALUES ('1002546', '望谟县', NULL, '522326', '1002540', 3);
INSERT INTO `sys_address` VALUES ('1002547', '册亨县', NULL, '522327', '1002540', 3);
INSERT INTO `sys_address` VALUES ('1002548', '安龙县', NULL, '522328', '1002540', 3);
INSERT INTO `sys_address` VALUES ('1002549', '黔东南苗族侗族自治州', NULL, '522600', '1000023', 2);
INSERT INTO `sys_address` VALUES ('1002550', '凯里市', NULL, '522601', '1002549', 3);
INSERT INTO `sys_address` VALUES ('1002551', '黄平县', NULL, '522622', '1002549', 3);
INSERT INTO `sys_address` VALUES ('1002552', '施秉县', NULL, '522623', '1002549', 3);
INSERT INTO `sys_address` VALUES ('1002553', '三穗县', NULL, '522624', '1002549', 3);
INSERT INTO `sys_address` VALUES ('1002554', '镇远县', NULL, '522625', '1002549', 3);
INSERT INTO `sys_address` VALUES ('1002555', '岑巩县', NULL, '522626', '1002549', 3);
INSERT INTO `sys_address` VALUES ('1002556', '天柱县', NULL, '522627', '1002549', 3);
INSERT INTO `sys_address` VALUES ('1002557', '锦屏县', NULL, '522628', '1002549', 3);
INSERT INTO `sys_address` VALUES ('1002558', '剑河县', NULL, '522629', '1002549', 3);
INSERT INTO `sys_address` VALUES ('1002559', '台江县', NULL, '522630', '1002549', 3);
INSERT INTO `sys_address` VALUES ('1002560', '黎平县', NULL, '522631', '1002549', 3);
INSERT INTO `sys_address` VALUES ('1002561', '榕江县', NULL, '522632', '1002549', 3);
INSERT INTO `sys_address` VALUES ('1002562', '从江县', NULL, '522633', '1002549', 3);
INSERT INTO `sys_address` VALUES ('1002563', '雷山县', NULL, '522634', '1002549', 3);
INSERT INTO `sys_address` VALUES ('1002564', '麻江县', NULL, '522635', '1002549', 3);
INSERT INTO `sys_address` VALUES ('1002565', '丹寨县', NULL, '522636', '1002549', 3);
INSERT INTO `sys_address` VALUES ('1002566', '黔南布依族苗族自治州', NULL, '522700', '1000023', 2);
INSERT INTO `sys_address` VALUES ('1002567', '都匀市', NULL, '522701', '1002566', 3);
INSERT INTO `sys_address` VALUES ('1002568', '福泉市', NULL, '522702', '1002566', 3);
INSERT INTO `sys_address` VALUES ('1002569', '荔波县', NULL, '522722', '1002566', 3);
INSERT INTO `sys_address` VALUES ('1002570', '贵定县', NULL, '522723', '1002566', 3);
INSERT INTO `sys_address` VALUES ('1002571', '瓮安县', NULL, '522725', '1002566', 3);
INSERT INTO `sys_address` VALUES ('1002572', '独山县', NULL, '522726', '1002566', 3);
INSERT INTO `sys_address` VALUES ('1002573', '平塘县', NULL, '522727', '1002566', 3);
INSERT INTO `sys_address` VALUES ('1002574', '罗甸县', NULL, '522728', '1002566', 3);
INSERT INTO `sys_address` VALUES ('1002575', '长顺县', NULL, '522729', '1002566', 3);
INSERT INTO `sys_address` VALUES ('1002576', '龙里县', NULL, '522730', '1002566', 3);
INSERT INTO `sys_address` VALUES ('1002577', '惠水县', NULL, '522731', '1002566', 3);
INSERT INTO `sys_address` VALUES ('1002578', '三都水族自治县', NULL, '522732', '1002566', 3);
INSERT INTO `sys_address` VALUES ('1002579', '昆明市', NULL, '530100', '1000024', 2);
INSERT INTO `sys_address` VALUES ('1002580', '呈贡区', NULL, '530114', '1002579', 3);
INSERT INTO `sys_address` VALUES ('1002581', '五华区', NULL, '530102', '1002579', 3);
INSERT INTO `sys_address` VALUES ('1002582', '盘龙区', NULL, '530103', '1002579', 3);
INSERT INTO `sys_address` VALUES ('1002583', '官渡区', NULL, '530111', '1002579', 3);
INSERT INTO `sys_address` VALUES ('1002584', '西山区', NULL, '530112', '1002579', 3);
INSERT INTO `sys_address` VALUES ('1002585', '东川区', NULL, '530113', '1002579', 3);
INSERT INTO `sys_address` VALUES ('1002586', '晋宁区', NULL, '530115', '1002579', 3);
INSERT INTO `sys_address` VALUES ('1002587', '安宁市', NULL, '530181', '1002579', 3);
INSERT INTO `sys_address` VALUES ('1002588', '富民县', NULL, '530124', '1002579', 3);
INSERT INTO `sys_address` VALUES ('1002589', '宜良县', NULL, '530125', '1002579', 3);
INSERT INTO `sys_address` VALUES ('1002590', '嵩明县', NULL, '530127', '1002579', 3);
INSERT INTO `sys_address` VALUES ('1002591', '石林彝族自治县', NULL, '530126', '1002579', 3);
INSERT INTO `sys_address` VALUES ('1002592', '禄劝彝族苗族自治县', NULL, '530128', '1002579', 3);
INSERT INTO `sys_address` VALUES ('1002593', '寻甸回族彝族自治县', NULL, '530129', '1002579', 3);
INSERT INTO `sys_address` VALUES ('1002594', '曲靖市', NULL, '530300', '1000024', 2);
INSERT INTO `sys_address` VALUES ('1002595', '麒麟区', NULL, '530302', '1002594', 3);
INSERT INTO `sys_address` VALUES ('1002596', '沾益区', NULL, '530303', '1002594', 3);
INSERT INTO `sys_address` VALUES ('1002597', '宣威市', NULL, '530381', '1002594', 3);
INSERT INTO `sys_address` VALUES ('1002598', '马龙县', NULL, '530321', '1002594', 3);
INSERT INTO `sys_address` VALUES ('1002599', '陆良县', NULL, '530322', '1002594', 3);
INSERT INTO `sys_address` VALUES ('1002600', '师宗县', NULL, '530323', '1002594', 3);
INSERT INTO `sys_address` VALUES ('1002601', '罗平县', NULL, '530324', '1002594', 3);
INSERT INTO `sys_address` VALUES ('1002602', '富源县', NULL, '530325', '1002594', 3);
INSERT INTO `sys_address` VALUES ('1002603', '会泽县', NULL, '530326', '1002594', 3);
INSERT INTO `sys_address` VALUES ('1002604', '玉溪市', NULL, '530400', '1000024', 2);
INSERT INTO `sys_address` VALUES ('1002605', '红塔区', NULL, '530402', '1002604', 3);
INSERT INTO `sys_address` VALUES ('1002606', '江川区', NULL, '530403', '1002604', 3);
INSERT INTO `sys_address` VALUES ('1002607', '澄江县', NULL, '530422', '1002604', 3);
INSERT INTO `sys_address` VALUES ('1002608', '通海县', NULL, '530423', '1002604', 3);
INSERT INTO `sys_address` VALUES ('1002609', '华宁县', NULL, '530424', '1002604', 3);
INSERT INTO `sys_address` VALUES ('1002610', '易门县', NULL, '530425', '1002604', 3);
INSERT INTO `sys_address` VALUES ('1002611', '峨山彝族自治县', NULL, '530426', '1002604', 3);
INSERT INTO `sys_address` VALUES ('1002612', '新平彝族傣族自治县', NULL, '530427', '1002604', 3);
INSERT INTO `sys_address` VALUES ('1002613', '元江哈尼族彝族傣族自治县', NULL, '530428', '1002604', 3);
INSERT INTO `sys_address` VALUES ('1002614', '保山市', NULL, '530500', '1000024', 2);
INSERT INTO `sys_address` VALUES ('1002615', '隆阳区', NULL, '530502', '1002614', 3);
INSERT INTO `sys_address` VALUES ('1002616', '腾冲市', NULL, '530581', '1002614', 3);
INSERT INTO `sys_address` VALUES ('1002617', '施甸县', NULL, '530521', '1002614', 3);
INSERT INTO `sys_address` VALUES ('1002618', '龙陵县', NULL, '530523', '1002614', 3);
INSERT INTO `sys_address` VALUES ('1002619', '昌宁县', NULL, '530524', '1002614', 3);
INSERT INTO `sys_address` VALUES ('1002620', '昭通市', NULL, '530600', '1000024', 2);
INSERT INTO `sys_address` VALUES ('1002621', '昭阳区', NULL, '530602', '1002620', 3);
INSERT INTO `sys_address` VALUES ('1002622', '鲁甸县', NULL, '530621', '1002620', 3);
INSERT INTO `sys_address` VALUES ('1002623', '巧家县', NULL, '530622', '1002620', 3);
INSERT INTO `sys_address` VALUES ('1002624', '盐津县', NULL, '530623', '1002620', 3);
INSERT INTO `sys_address` VALUES ('1002625', '大关县', NULL, '530624', '1002620', 3);
INSERT INTO `sys_address` VALUES ('1002626', '永善县', NULL, '530625', '1002620', 3);
INSERT INTO `sys_address` VALUES ('1002627', '绥江县', NULL, '530626', '1002620', 3);
INSERT INTO `sys_address` VALUES ('1002628', '镇雄县', NULL, '530627', '1002620', 3);
INSERT INTO `sys_address` VALUES ('1002629', '彝良县', NULL, '530628', '1002620', 3);
INSERT INTO `sys_address` VALUES ('1002630', '威信县', NULL, '530629', '1002620', 3);
INSERT INTO `sys_address` VALUES ('1002631', '水富县', NULL, '530630', '1002620', 3);
INSERT INTO `sys_address` VALUES ('1002632', '丽江市', NULL, '530700', '1000024', 2);
INSERT INTO `sys_address` VALUES ('1002633', '古城区', NULL, '530702', '1002632', 3);
INSERT INTO `sys_address` VALUES ('1002634', '永胜县', NULL, '530722', '1002632', 3);
INSERT INTO `sys_address` VALUES ('1002635', '华坪县', NULL, '530723', '1002632', 3);
INSERT INTO `sys_address` VALUES ('1002636', '玉龙纳西族自治县', NULL, '530721', '1002632', 3);
INSERT INTO `sys_address` VALUES ('1002637', '宁蒗彝族自治县', NULL, '530724', '1002632', 3);
INSERT INTO `sys_address` VALUES ('1002638', '普洱市', NULL, '530800', '1000024', 2);
INSERT INTO `sys_address` VALUES ('1002639', '思茅区', NULL, '530802', '1002638', 3);
INSERT INTO `sys_address` VALUES ('1002640', '宁洱哈尼族彝族自治县', NULL, '530821', '1002638', 3);
INSERT INTO `sys_address` VALUES ('1002641', '墨江哈尼族自治县', NULL, '530822', '1002638', 3);
INSERT INTO `sys_address` VALUES ('1002642', '景东彝族自治县', NULL, '530823', '1002638', 3);
INSERT INTO `sys_address` VALUES ('1002643', '景谷傣族彝族自治县', NULL, '530824', '1002638', 3);
INSERT INTO `sys_address` VALUES ('1002644', '镇沅彝族哈尼族拉祜族自治县', NULL, '530825', '1002638', 3);
INSERT INTO `sys_address` VALUES ('1002645', '江城哈尼族彝族自治县', NULL, '530826', '1002638', 3);
INSERT INTO `sys_address` VALUES ('1002646', '孟连傣族拉祜族佤族自治县', NULL, '530827', '1002638', 3);
INSERT INTO `sys_address` VALUES ('1002647', '澜沧拉祜族自治县', NULL, '530828', '1002638', 3);
INSERT INTO `sys_address` VALUES ('1002648', '西盟佤族自治县', NULL, '530829', '1002638', 3);
INSERT INTO `sys_address` VALUES ('1002649', '临沧市', NULL, '530900', '1000024', 2);
INSERT INTO `sys_address` VALUES ('1002650', '临翔区', NULL, '530902', '1002649', 3);
INSERT INTO `sys_address` VALUES ('1002651', '凤庆县', NULL, '530921', '1002649', 3);
INSERT INTO `sys_address` VALUES ('1002652', '云县', NULL, '530922', '1002649', 3);
INSERT INTO `sys_address` VALUES ('1002653', '永德县', NULL, '530923', '1002649', 3);
INSERT INTO `sys_address` VALUES ('1002654', '镇康县', NULL, '530924', '1002649', 3);
INSERT INTO `sys_address` VALUES ('1002655', '双江拉祜族佤族布朗族傣族自治县', NULL, '530925', '1002649', 3);
INSERT INTO `sys_address` VALUES ('1002656', '耿马傣族佤族自治县', NULL, '530926', '1002649', 3);
INSERT INTO `sys_address` VALUES ('1002657', '沧源佤族自治县', NULL, '530927', '1002649', 3);
INSERT INTO `sys_address` VALUES ('1002658', '楚雄彝族自治州', NULL, '532300', '1000024', 2);
INSERT INTO `sys_address` VALUES ('1002659', '楚雄市', NULL, '532301', '1002658', 3);
INSERT INTO `sys_address` VALUES ('1002660', '双柏县', NULL, '532322', '1002658', 3);
INSERT INTO `sys_address` VALUES ('1002661', '牟定县', NULL, '532323', '1002658', 3);
INSERT INTO `sys_address` VALUES ('1002662', '南华县', NULL, '532324', '1002658', 3);
INSERT INTO `sys_address` VALUES ('1002663', '姚安县', NULL, '532325', '1002658', 3);
INSERT INTO `sys_address` VALUES ('1002664', '大姚县', NULL, '532326', '1002658', 3);
INSERT INTO `sys_address` VALUES ('1002665', '永仁县', NULL, '532327', '1002658', 3);
INSERT INTO `sys_address` VALUES ('1002666', '元谋县', NULL, '532328', '1002658', 3);
INSERT INTO `sys_address` VALUES ('1002667', '武定县', NULL, '532329', '1002658', 3);
INSERT INTO `sys_address` VALUES ('1002668', '禄丰县', NULL, '532331', '1002658', 3);
INSERT INTO `sys_address` VALUES ('1002669', '红河哈尼族彝族自治州', NULL, '532500', '1000024', 2);
INSERT INTO `sys_address` VALUES ('1002670', '蒙自市', NULL, '532503', '1002669', 3);
INSERT INTO `sys_address` VALUES ('1002671', '个旧市', NULL, '532501', '1002669', 3);
INSERT INTO `sys_address` VALUES ('1002672', '开远市', NULL, '532502', '1002669', 3);
INSERT INTO `sys_address` VALUES ('1002673', '弥勒市', NULL, '532504', '1002669', 3);
INSERT INTO `sys_address` VALUES ('1002674', '建水县', NULL, '532524', '1002669', 3);
INSERT INTO `sys_address` VALUES ('1002675', '石屏县', NULL, '532525', '1002669', 3);
INSERT INTO `sys_address` VALUES ('1002676', '泸西县', NULL, '532527', '1002669', 3);
INSERT INTO `sys_address` VALUES ('1002677', '元阳县', NULL, '532528', '1002669', 3);
INSERT INTO `sys_address` VALUES ('1002678', '红河县', NULL, '532529', '1002669', 3);
INSERT INTO `sys_address` VALUES ('1002679', '绿春县', NULL, '532531', '1002669', 3);
INSERT INTO `sys_address` VALUES ('1002680', '屏边苗族自治县', NULL, '532523', '1002669', 3);
INSERT INTO `sys_address` VALUES ('1002681', '金平苗族瑶族傣族自治县', NULL, '532530', '1002669', 3);
INSERT INTO `sys_address` VALUES ('1002682', '河口瑶族自治县', NULL, '532532', '1002669', 3);
INSERT INTO `sys_address` VALUES ('1002683', '文山壮族苗族自治州', NULL, '532600', '1000024', 2);
INSERT INTO `sys_address` VALUES ('1002684', '文山市', NULL, '532601', '1002683', 3);
INSERT INTO `sys_address` VALUES ('1002685', '砚山县', NULL, '532622', '1002683', 3);
INSERT INTO `sys_address` VALUES ('1002686', '西畴县', NULL, '532623', '1002683', 3);
INSERT INTO `sys_address` VALUES ('1002687', '麻栗坡县', NULL, '532624', '1002683', 3);
INSERT INTO `sys_address` VALUES ('1002688', '马关县', NULL, '532625', '1002683', 3);
INSERT INTO `sys_address` VALUES ('1002689', '丘北县', NULL, '532626', '1002683', 3);
INSERT INTO `sys_address` VALUES ('1002690', '广南县', NULL, '532627', '1002683', 3);
INSERT INTO `sys_address` VALUES ('1002691', '富宁县', NULL, '532628', '1002683', 3);
INSERT INTO `sys_address` VALUES ('1002692', '西双版纳傣族自治州', NULL, '532800', '1000024', 2);
INSERT INTO `sys_address` VALUES ('1002693', '景洪市', NULL, '532801', '1002692', 3);
INSERT INTO `sys_address` VALUES ('1002694', '勐海县', NULL, '532822', '1002692', 3);
INSERT INTO `sys_address` VALUES ('1002695', '勐腊县', NULL, '532823', '1002692', 3);
INSERT INTO `sys_address` VALUES ('1002696', '大理白族自治州', NULL, '532900', '1000024', 2);
INSERT INTO `sys_address` VALUES ('1002697', '大理市', NULL, '532901', '1002696', 3);
INSERT INTO `sys_address` VALUES ('1002698', '祥云县', NULL, '532923', '1002696', 3);
INSERT INTO `sys_address` VALUES ('1002699', '宾川县', NULL, '532924', '1002696', 3);
INSERT INTO `sys_address` VALUES ('1002700', '弥渡县', NULL, '532925', '1002696', 3);
INSERT INTO `sys_address` VALUES ('1002701', '永平县', NULL, '532928', '1002696', 3);
INSERT INTO `sys_address` VALUES ('1002702', '云龙县', NULL, '532929', '1002696', 3);
INSERT INTO `sys_address` VALUES ('1002703', '洱源县', NULL, '532930', '1002696', 3);
INSERT INTO `sys_address` VALUES ('1002704', '剑川县', NULL, '532931', '1002696', 3);
INSERT INTO `sys_address` VALUES ('1002705', '鹤庆县', NULL, '532932', '1002696', 3);
INSERT INTO `sys_address` VALUES ('1002706', '漾濞彝族自治县', NULL, '532922', '1002696', 3);
INSERT INTO `sys_address` VALUES ('1002707', '南涧彝族自治县', NULL, '532926', '1002696', 3);
INSERT INTO `sys_address` VALUES ('1002708', '巍山彝族回族自治县', NULL, '532927', '1002696', 3);
INSERT INTO `sys_address` VALUES ('1002709', '德宏傣族景颇族自治州', NULL, '533100', '1000024', 2);
INSERT INTO `sys_address` VALUES ('1002710', '芒市', NULL, '533103', '1002709', 3);
INSERT INTO `sys_address` VALUES ('1002711', '瑞丽市', NULL, '533102', '1002709', 3);
INSERT INTO `sys_address` VALUES ('1002712', '梁河县', NULL, '533122', '1002709', 3);
INSERT INTO `sys_address` VALUES ('1002713', '盈江县', NULL, '533123', '1002709', 3);
INSERT INTO `sys_address` VALUES ('1002714', '陇川县', NULL, '533124', '1002709', 3);
INSERT INTO `sys_address` VALUES ('1002715', '怒江傈僳族自治州', NULL, '533300', '1000024', 2);
INSERT INTO `sys_address` VALUES ('1002716', '泸水市', NULL, '533301', '1002715', 3);
INSERT INTO `sys_address` VALUES ('1002717', '福贡县', NULL, '533323', '1002715', 3);
INSERT INTO `sys_address` VALUES ('1002718', '贡山独龙族怒族自治县', NULL, '533324', '1002715', 3);
INSERT INTO `sys_address` VALUES ('1002719', '兰坪白族普米族自治县', NULL, '533325', '1002715', 3);
INSERT INTO `sys_address` VALUES ('1002720', '迪庆藏族自治州', NULL, '533400', '1000024', 2);
INSERT INTO `sys_address` VALUES ('1002721', '香格里拉市', NULL, '533401', '1002720', 3);
INSERT INTO `sys_address` VALUES ('1002722', '德钦县', NULL, '533422', '1002720', 3);
INSERT INTO `sys_address` VALUES ('1002723', '维西傈僳族自治县', NULL, '533423', '1002720', 3);
INSERT INTO `sys_address` VALUES ('1002724', '拉萨市', NULL, '540100', '1000025', 2);
INSERT INTO `sys_address` VALUES ('1002725', '城关区', NULL, '540102', '1002724', 3);
INSERT INTO `sys_address` VALUES ('1002726', '堆龙德庆区', NULL, '540103', '1002724', 3);
INSERT INTO `sys_address` VALUES ('1002727', '达孜区', NULL, '540104', '1002724', 3);
INSERT INTO `sys_address` VALUES ('1002728', '林周县', NULL, '540121', '1002724', 3);
INSERT INTO `sys_address` VALUES ('1002729', '当雄县', NULL, '540122', '1002724', 3);
INSERT INTO `sys_address` VALUES ('1002730', '尼木县', NULL, '540123', '1002724', 3);
INSERT INTO `sys_address` VALUES ('1002731', '曲水县', NULL, '540124', '1002724', 3);
INSERT INTO `sys_address` VALUES ('1002732', '墨竹工卡县', NULL, '540127', '1002724', 3);
INSERT INTO `sys_address` VALUES ('1002733', '日喀则市', NULL, '540200', '1000025', 2);
INSERT INTO `sys_address` VALUES ('1002734', '桑珠孜区', NULL, '540202', '1002733', 3);
INSERT INTO `sys_address` VALUES ('1002735', '南木林县', NULL, '540221', '1002733', 3);
INSERT INTO `sys_address` VALUES ('1002736', '江孜县', NULL, '540222', '1002733', 3);
INSERT INTO `sys_address` VALUES ('1002737', '定日县', NULL, '540223', '1002733', 3);
INSERT INTO `sys_address` VALUES ('1002738', '萨迦县', NULL, '540224', '1002733', 3);
INSERT INTO `sys_address` VALUES ('1002739', '拉孜县', NULL, '540225', '1002733', 3);
INSERT INTO `sys_address` VALUES ('1002740', '昂仁县', NULL, '540226', '1002733', 3);
INSERT INTO `sys_address` VALUES ('1002741', '谢通门县', NULL, '540227', '1002733', 3);
INSERT INTO `sys_address` VALUES ('1002742', '白朗县', NULL, '540228', '1002733', 3);
INSERT INTO `sys_address` VALUES ('1002743', '仁布县', NULL, '540229', '1002733', 3);
INSERT INTO `sys_address` VALUES ('1002744', '康马县', NULL, '540230', '1002733', 3);
INSERT INTO `sys_address` VALUES ('1002745', '定结县', NULL, '540231', '1002733', 3);
INSERT INTO `sys_address` VALUES ('1002746', '仲巴县', NULL, '540232', '1002733', 3);
INSERT INTO `sys_address` VALUES ('1002747', '亚东县', NULL, '540233', '1002733', 3);
INSERT INTO `sys_address` VALUES ('1002748', '吉隆县', NULL, '540234', '1002733', 3);
INSERT INTO `sys_address` VALUES ('1002749', '聂拉木县', NULL, '540235', '1002733', 3);
INSERT INTO `sys_address` VALUES ('1002750', '萨嘎县', NULL, '540236', '1002733', 3);
INSERT INTO `sys_address` VALUES ('1002751', '岗巴县', NULL, '540237', '1002733', 3);
INSERT INTO `sys_address` VALUES ('1002752', '昌都市', NULL, '540300', '1000025', 2);
INSERT INTO `sys_address` VALUES ('1002753', '卡若区', NULL, '540302', '1002752', 3);
INSERT INTO `sys_address` VALUES ('1002754', '江达县', NULL, '540321', '1002752', 3);
INSERT INTO `sys_address` VALUES ('1002755', '贡觉县', NULL, '540322', '1002752', 3);
INSERT INTO `sys_address` VALUES ('1002756', '类乌齐县', NULL, '540323', '1002752', 3);
INSERT INTO `sys_address` VALUES ('1002757', '丁青县', NULL, '540324', '1002752', 3);
INSERT INTO `sys_address` VALUES ('1002758', '察雅县', NULL, '540325', '1002752', 3);
INSERT INTO `sys_address` VALUES ('1002759', '八宿县', NULL, '540326', '1002752', 3);
INSERT INTO `sys_address` VALUES ('1002760', '左贡县', NULL, '540327', '1002752', 3);
INSERT INTO `sys_address` VALUES ('1002761', '芒康县', NULL, '540328', '1002752', 3);
INSERT INTO `sys_address` VALUES ('1002762', '洛隆县', NULL, '540329', '1002752', 3);
INSERT INTO `sys_address` VALUES ('1002763', '边坝县', NULL, '540330', '1002752', 3);
INSERT INTO `sys_address` VALUES ('1002764', '林芝市', NULL, '540400', '1000025', 2);
INSERT INTO `sys_address` VALUES ('1002765', '巴宜区', NULL, '540402', '1002764', 3);
INSERT INTO `sys_address` VALUES ('1002766', '工布江达县', NULL, '540421', '1002764', 3);
INSERT INTO `sys_address` VALUES ('1002767', '米林县', NULL, '540422', '1002764', 3);
INSERT INTO `sys_address` VALUES ('1002768', '墨脱县', NULL, '540423', '1002764', 3);
INSERT INTO `sys_address` VALUES ('1002769', '波密县', NULL, '540424', '1002764', 3);
INSERT INTO `sys_address` VALUES ('1002770', '察隅县', NULL, '540425', '1002764', 3);
INSERT INTO `sys_address` VALUES ('1002771', '朗县', NULL, '540426', '1002764', 3);
INSERT INTO `sys_address` VALUES ('1002772', '山南市', NULL, '540500', '1000025', 2);
INSERT INTO `sys_address` VALUES ('1002773', '乃东区', NULL, '540502', '1002772', 3);
INSERT INTO `sys_address` VALUES ('1002774', '扎囊县', NULL, '540521', '1002772', 3);
INSERT INTO `sys_address` VALUES ('1002775', '贡嘎县', NULL, '540522', '1002772', 3);
INSERT INTO `sys_address` VALUES ('1002776', '桑日县', NULL, '540523', '1002772', 3);
INSERT INTO `sys_address` VALUES ('1002777', '琼结县', NULL, '540524', '1002772', 3);
INSERT INTO `sys_address` VALUES ('1002778', '曲松县', NULL, '540525', '1002772', 3);
INSERT INTO `sys_address` VALUES ('1002779', '措美县', NULL, '540526', '1002772', 3);
INSERT INTO `sys_address` VALUES ('1002780', '洛扎县', NULL, '540527', '1002772', 3);
INSERT INTO `sys_address` VALUES ('1002781', '加查县', NULL, '540528', '1002772', 3);
INSERT INTO `sys_address` VALUES ('1002782', '隆子县', NULL, '540529', '1002772', 3);
INSERT INTO `sys_address` VALUES ('1002783', '错那县', NULL, '540530', '1002772', 3);
INSERT INTO `sys_address` VALUES ('1002784', '浪卡子县', NULL, '540531', '1002772', 3);
INSERT INTO `sys_address` VALUES ('1002785', '那曲市', NULL, '540600', '1000025', 2);
INSERT INTO `sys_address` VALUES ('1002786', '色尼区', NULL, '540602', '1002785', 3);
INSERT INTO `sys_address` VALUES ('1002787', '嘉黎县', NULL, '540621', '1002785', 3);
INSERT INTO `sys_address` VALUES ('1002788', '比如县', NULL, '540622', '1002785', 3);
INSERT INTO `sys_address` VALUES ('1002789', '聂荣县', NULL, '540623', '1002785', 3);
INSERT INTO `sys_address` VALUES ('1002790', '安多县', NULL, '540624', '1002785', 3);
INSERT INTO `sys_address` VALUES ('1002791', '申扎县', NULL, '540625', '1002785', 3);
INSERT INTO `sys_address` VALUES ('1002792', '索县', NULL, '540626', '1002785', 3);
INSERT INTO `sys_address` VALUES ('1002793', '班戈县', NULL, '540627', '1002785', 3);
INSERT INTO `sys_address` VALUES ('1002794', '巴青县', NULL, '540628', '1002785', 3);
INSERT INTO `sys_address` VALUES ('1002795', '尼玛县', NULL, '540629', '1002785', 3);
INSERT INTO `sys_address` VALUES ('1002796', '双湖县', NULL, '540630', '1002785', 3);
INSERT INTO `sys_address` VALUES ('1002797', '阿里地区', NULL, '542500', '1000025', 2);
INSERT INTO `sys_address` VALUES ('1002798', '噶尔县', NULL, '542523', '1002797', 3);
INSERT INTO `sys_address` VALUES ('1002799', '普兰县', NULL, '542521', '1002797', 3);
INSERT INTO `sys_address` VALUES ('1002800', '札达县', NULL, '542522', '1002797', 3);
INSERT INTO `sys_address` VALUES ('1002801', '日土县', NULL, '542524', '1002797', 3);
INSERT INTO `sys_address` VALUES ('1002802', '革吉县', NULL, '542525', '1002797', 3);
INSERT INTO `sys_address` VALUES ('1002803', '改则县', NULL, '542526', '1002797', 3);
INSERT INTO `sys_address` VALUES ('1002804', '措勤县', NULL, '542527', '1002797', 3);
INSERT INTO `sys_address` VALUES ('1002805', '西安市', NULL, '610100', '1000026', 2);
INSERT INTO `sys_address` VALUES ('1002806', '未央区', NULL, '610112', '1002805', 3);
INSERT INTO `sys_address` VALUES ('1002807', '新城区', NULL, '610102', '1002805', 3);
INSERT INTO `sys_address` VALUES ('1002808', '碑林区', NULL, '610103', '1002805', 3);
INSERT INTO `sys_address` VALUES ('1002809', '莲湖区', NULL, '610104', '1002805', 3);
INSERT INTO `sys_address` VALUES ('1002810', '灞桥区', NULL, '610111', '1002805', 3);
INSERT INTO `sys_address` VALUES ('1002811', '雁塔区', NULL, '610113', '1002805', 3);
INSERT INTO `sys_address` VALUES ('1002812', '阎良区', NULL, '610114', '1002805', 3);
INSERT INTO `sys_address` VALUES ('1002813', '临潼区', NULL, '610115', '1002805', 3);
INSERT INTO `sys_address` VALUES ('1002814', '长安区', NULL, '610116', '1002805', 3);
INSERT INTO `sys_address` VALUES ('1002815', '高陵区', NULL, '610117', '1002805', 3);
INSERT INTO `sys_address` VALUES ('1002816', '鄠邑区', NULL, '610118', '1002805', 3);
INSERT INTO `sys_address` VALUES ('1002817', '蓝田县', NULL, '610122', '1002805', 3);
INSERT INTO `sys_address` VALUES ('1002818', '周至县', NULL, '610124', '1002805', 3);
INSERT INTO `sys_address` VALUES ('1002819', '铜川市', NULL, '610200', '1000026', 2);
INSERT INTO `sys_address` VALUES ('1002820', '耀州区', NULL, '610204', '1002819', 3);
INSERT INTO `sys_address` VALUES ('1002821', '王益区', NULL, '610202', '1002819', 3);
INSERT INTO `sys_address` VALUES ('1002822', '印台区', NULL, '610203', '1002819', 3);
INSERT INTO `sys_address` VALUES ('1002823', '宜君县', NULL, '610222', '1002819', 3);
INSERT INTO `sys_address` VALUES ('1002824', '宝鸡市', NULL, '610300', '1000026', 2);
INSERT INTO `sys_address` VALUES ('1002825', '金台区', NULL, '610303', '1002824', 3);
INSERT INTO `sys_address` VALUES ('1002826', '渭滨区', NULL, '610302', '1002824', 3);
INSERT INTO `sys_address` VALUES ('1002827', '陈仓区', NULL, '610304', '1002824', 3);
INSERT INTO `sys_address` VALUES ('1002828', '凤翔县', NULL, '610322', '1002824', 3);
INSERT INTO `sys_address` VALUES ('1002829', '岐山县', NULL, '610323', '1002824', 3);
INSERT INTO `sys_address` VALUES ('1002830', '扶风县', NULL, '610324', '1002824', 3);
INSERT INTO `sys_address` VALUES ('1002831', '眉县', NULL, '610326', '1002824', 3);
INSERT INTO `sys_address` VALUES ('1002832', '陇县', NULL, '610327', '1002824', 3);
INSERT INTO `sys_address` VALUES ('1002833', '千阳县', NULL, '610328', '1002824', 3);
INSERT INTO `sys_address` VALUES ('1002834', '麟游县', NULL, '610329', '1002824', 3);
INSERT INTO `sys_address` VALUES ('1002835', '凤县', NULL, '610330', '1002824', 3);
INSERT INTO `sys_address` VALUES ('1002836', '太白县', NULL, '610331', '1002824', 3);
INSERT INTO `sys_address` VALUES ('1002837', '咸阳市', NULL, '610400', '1000026', 2);
INSERT INTO `sys_address` VALUES ('1002838', '秦都区', NULL, '610402', '1002837', 3);
INSERT INTO `sys_address` VALUES ('1002839', '杨陵区', NULL, '610403', '1002837', 3);
INSERT INTO `sys_address` VALUES ('1002840', '渭城区', NULL, '610404', '1002837', 3);
INSERT INTO `sys_address` VALUES ('1002841', '兴平市', NULL, '610481', '1002837', 3);
INSERT INTO `sys_address` VALUES ('1002842', '三原县', NULL, '610422', '1002837', 3);
INSERT INTO `sys_address` VALUES ('1002843', '泾阳县', NULL, '610423', '1002837', 3);
INSERT INTO `sys_address` VALUES ('1002844', '乾县', NULL, '610424', '1002837', 3);
INSERT INTO `sys_address` VALUES ('1002845', '礼泉县', NULL, '610425', '1002837', 3);
INSERT INTO `sys_address` VALUES ('1002846', '永寿县', NULL, '610426', '1002837', 3);
INSERT INTO `sys_address` VALUES ('1002847', '彬县', NULL, '610427', '1002837', 3);
INSERT INTO `sys_address` VALUES ('1002848', '长武县', NULL, '610428', '1002837', 3);
INSERT INTO `sys_address` VALUES ('1002849', '旬邑县', NULL, '610429', '1002837', 3);
INSERT INTO `sys_address` VALUES ('1002850', '淳化县', NULL, '610430', '1002837', 3);
INSERT INTO `sys_address` VALUES ('1002851', '武功县', NULL, '610431', '1002837', 3);
INSERT INTO `sys_address` VALUES ('1002852', '渭南市', NULL, '610500', '1000026', 2);
INSERT INTO `sys_address` VALUES ('1002853', '临渭区', NULL, '610502', '1002852', 3);
INSERT INTO `sys_address` VALUES ('1002854', '韩城市', NULL, '610581', '1002852', 3);
INSERT INTO `sys_address` VALUES ('1002855', '华阴市', NULL, '610582', '1002852', 3);
INSERT INTO `sys_address` VALUES ('1002856', '华州区', NULL, '610503', '1002852', 3);
INSERT INTO `sys_address` VALUES ('1002857', '潼关县', NULL, '610522', '1002852', 3);
INSERT INTO `sys_address` VALUES ('1002858', '大荔县', NULL, '610523', '1002852', 3);
INSERT INTO `sys_address` VALUES ('1002859', '合阳县', NULL, '610524', '1002852', 3);
INSERT INTO `sys_address` VALUES ('1002860', '澄城县', NULL, '610525', '1002852', 3);
INSERT INTO `sys_address` VALUES ('1002861', '蒲城县', NULL, '610526', '1002852', 3);
INSERT INTO `sys_address` VALUES ('1002862', '白水县', NULL, '610527', '1002852', 3);
INSERT INTO `sys_address` VALUES ('1002863', '富平县', NULL, '610528', '1002852', 3);
INSERT INTO `sys_address` VALUES ('1002864', '延安市', NULL, '610600', '1000026', 2);
INSERT INTO `sys_address` VALUES ('1002865', '宝塔区', NULL, '610602', '1002864', 3);
INSERT INTO `sys_address` VALUES ('1002866', '安塞区', NULL, '610603', '1002864', 3);
INSERT INTO `sys_address` VALUES ('1002867', '延长县', NULL, '610621', '1002864', 3);
INSERT INTO `sys_address` VALUES ('1002868', '延川县', NULL, '610622', '1002864', 3);
INSERT INTO `sys_address` VALUES ('1002869', '子长县', NULL, '610623', '1002864', 3);
INSERT INTO `sys_address` VALUES ('1002870', '志丹县', NULL, '610625', '1002864', 3);
INSERT INTO `sys_address` VALUES ('1002871', '吴起县', NULL, '610626', '1002864', 3);
INSERT INTO `sys_address` VALUES ('1002872', '甘泉县', NULL, '610627', '1002864', 3);
INSERT INTO `sys_address` VALUES ('1002873', '富县', NULL, '610628', '1002864', 3);
INSERT INTO `sys_address` VALUES ('1002874', '洛川县', NULL, '610629', '1002864', 3);
INSERT INTO `sys_address` VALUES ('1002875', '宜川县', NULL, '610630', '1002864', 3);
INSERT INTO `sys_address` VALUES ('1002876', '黄龙县', NULL, '610631', '1002864', 3);
INSERT INTO `sys_address` VALUES ('1002877', '黄陵县', NULL, '610632', '1002864', 3);
INSERT INTO `sys_address` VALUES ('1002878', '汉中市', NULL, '610700', '1000026', 2);
INSERT INTO `sys_address` VALUES ('1002879', '汉台区', NULL, '610702', '1002878', 3);
INSERT INTO `sys_address` VALUES ('1002880', '南郑区', NULL, '610703', '1002878', 3);
INSERT INTO `sys_address` VALUES ('1002881', '城固县', NULL, '610722', '1002878', 3);
INSERT INTO `sys_address` VALUES ('1002882', '洋县', NULL, '610723', '1002878', 3);
INSERT INTO `sys_address` VALUES ('1002883', '西乡县', NULL, '610724', '1002878', 3);
INSERT INTO `sys_address` VALUES ('1002884', '勉县', NULL, '610725', '1002878', 3);
INSERT INTO `sys_address` VALUES ('1002885', '宁强县', NULL, '610726', '1002878', 3);
INSERT INTO `sys_address` VALUES ('1002886', '略阳县', NULL, '610727', '1002878', 3);
INSERT INTO `sys_address` VALUES ('1002887', '镇巴县', NULL, '610728', '1002878', 3);
INSERT INTO `sys_address` VALUES ('1002888', '留坝县', NULL, '610729', '1002878', 3);
INSERT INTO `sys_address` VALUES ('1002889', '佛坪县', NULL, '610730', '1002878', 3);
INSERT INTO `sys_address` VALUES ('1002890', '榆林市', NULL, '610800', '1000026', 2);
INSERT INTO `sys_address` VALUES ('1002891', '榆阳区', NULL, '610802', '1002890', 3);
INSERT INTO `sys_address` VALUES ('1002892', '神木市', NULL, '610881', '1002890', 3);
INSERT INTO `sys_address` VALUES ('1002893', '府谷县', NULL, '610822', '1002890', 3);
INSERT INTO `sys_address` VALUES ('1002894', '横山区', NULL, '610803', '1002890', 3);
INSERT INTO `sys_address` VALUES ('1002895', '靖边县', NULL, '610824', '1002890', 3);
INSERT INTO `sys_address` VALUES ('1002896', '定边县', NULL, '610825', '1002890', 3);
INSERT INTO `sys_address` VALUES ('1002897', '绥德县', NULL, '610826', '1002890', 3);
INSERT INTO `sys_address` VALUES ('1002898', '米脂县', NULL, '610827', '1002890', 3);
INSERT INTO `sys_address` VALUES ('1002899', '佳县', NULL, '610828', '1002890', 3);
INSERT INTO `sys_address` VALUES ('1002900', '吴堡县', NULL, '610829', '1002890', 3);
INSERT INTO `sys_address` VALUES ('1002901', '清涧县', NULL, '610830', '1002890', 3);
INSERT INTO `sys_address` VALUES ('1002902', '子洲县', NULL, '610831', '1002890', 3);
INSERT INTO `sys_address` VALUES ('1002903', '安康市', NULL, '610900', '1000026', 2);
INSERT INTO `sys_address` VALUES ('1002904', '汉滨区', NULL, '610902', '1002903', 3);
INSERT INTO `sys_address` VALUES ('1002905', '汉阴县', NULL, '610921', '1002903', 3);
INSERT INTO `sys_address` VALUES ('1002906', '石泉县', NULL, '610922', '1002903', 3);
INSERT INTO `sys_address` VALUES ('1002907', '宁陕县', NULL, '610923', '1002903', 3);
INSERT INTO `sys_address` VALUES ('1002908', '紫阳县', NULL, '610924', '1002903', 3);
INSERT INTO `sys_address` VALUES ('1002909', '岚皋县', NULL, '610925', '1002903', 3);
INSERT INTO `sys_address` VALUES ('1002910', '平利县', NULL, '610926', '1002903', 3);
INSERT INTO `sys_address` VALUES ('1002911', '镇坪县', NULL, '610927', '1002903', 3);
INSERT INTO `sys_address` VALUES ('1002912', '旬阳县', NULL, '610928', '1002903', 3);
INSERT INTO `sys_address` VALUES ('1002913', '白河县', NULL, '610929', '1002903', 3);
INSERT INTO `sys_address` VALUES ('1002914', '商洛市', NULL, '611000', '1000026', 2);
INSERT INTO `sys_address` VALUES ('1002915', '商州区', NULL, '611002', '1002914', 3);
INSERT INTO `sys_address` VALUES ('1002916', '洛南县', NULL, '611021', '1002914', 3);
INSERT INTO `sys_address` VALUES ('1002917', '丹凤县', NULL, '611022', '1002914', 3);
INSERT INTO `sys_address` VALUES ('1002918', '商南县', NULL, '611023', '1002914', 3);
INSERT INTO `sys_address` VALUES ('1002919', '山阳县', NULL, '611024', '1002914', 3);
INSERT INTO `sys_address` VALUES ('1002920', '镇安县', NULL, '611025', '1002914', 3);
INSERT INTO `sys_address` VALUES ('1002921', '柞水县', NULL, '611026', '1002914', 3);
INSERT INTO `sys_address` VALUES ('1002922', '兰州市', NULL, '620100', '1000027', 2);
INSERT INTO `sys_address` VALUES ('1002923', '城关区', NULL, '620102', '1002922', 3);
INSERT INTO `sys_address` VALUES ('1002924', '七里河区', NULL, '620103', '1002922', 3);
INSERT INTO `sys_address` VALUES ('1002925', '西固区', NULL, '620104', '1002922', 3);
INSERT INTO `sys_address` VALUES ('1002926', '安宁区', NULL, '620105', '1002922', 3);
INSERT INTO `sys_address` VALUES ('1002927', '红古区', NULL, '620111', '1002922', 3);
INSERT INTO `sys_address` VALUES ('1002928', '永登县', NULL, '620121', '1002922', 3);
INSERT INTO `sys_address` VALUES ('1002929', '皋兰县', NULL, '620122', '1002922', 3);
INSERT INTO `sys_address` VALUES ('1002930', '榆中县', NULL, '620123', '1002922', 3);
INSERT INTO `sys_address` VALUES ('1002931', '嘉峪关市', NULL, '620200', '1000027', 2);
INSERT INTO `sys_address` VALUES ('1002932', '金昌市', NULL, '620300', '1000027', 2);
INSERT INTO `sys_address` VALUES ('1002933', '金川区', NULL, '620302', '1002932', 3);
INSERT INTO `sys_address` VALUES ('1002934', '永昌县', NULL, '620321', '1002932', 3);
INSERT INTO `sys_address` VALUES ('1002935', '白银市', NULL, '620400', '1000027', 2);
INSERT INTO `sys_address` VALUES ('1002936', '白银区', NULL, '620402', '1002935', 3);
INSERT INTO `sys_address` VALUES ('1002937', '平川区', NULL, '620403', '1002935', 3);
INSERT INTO `sys_address` VALUES ('1002938', '靖远县', NULL, '620421', '1002935', 3);
INSERT INTO `sys_address` VALUES ('1002939', '会宁县', NULL, '620422', '1002935', 3);
INSERT INTO `sys_address` VALUES ('1002940', '景泰县', NULL, '620423', '1002935', 3);
INSERT INTO `sys_address` VALUES ('1002941', '天水市', NULL, '620500', '1000027', 2);
INSERT INTO `sys_address` VALUES ('1002942', '秦州区', NULL, '620502', '1002941', 3);
INSERT INTO `sys_address` VALUES ('1002943', '麦积区', NULL, '620503', '1002941', 3);
INSERT INTO `sys_address` VALUES ('1002944', '清水县', NULL, '620521', '1002941', 3);
INSERT INTO `sys_address` VALUES ('1002945', '秦安县', NULL, '620522', '1002941', 3);
INSERT INTO `sys_address` VALUES ('1002946', '甘谷县', NULL, '620523', '1002941', 3);
INSERT INTO `sys_address` VALUES ('1002947', '武山县', NULL, '620524', '1002941', 3);
INSERT INTO `sys_address` VALUES ('1002948', '张家川回族自治县', NULL, '620525', '1002941', 3);
INSERT INTO `sys_address` VALUES ('1002949', '武威市', NULL, '620600', '1000027', 2);
INSERT INTO `sys_address` VALUES ('1002950', '凉州区', NULL, '620602', '1002949', 3);
INSERT INTO `sys_address` VALUES ('1002951', '民勤县', NULL, '620621', '1002949', 3);
INSERT INTO `sys_address` VALUES ('1002952', '古浪县', NULL, '620622', '1002949', 3);
INSERT INTO `sys_address` VALUES ('1002953', '天祝藏族自治县', NULL, '620623', '1002949', 3);
INSERT INTO `sys_address` VALUES ('1002954', '张掖市', NULL, '620700', '1000027', 2);
INSERT INTO `sys_address` VALUES ('1002955', '甘州区', NULL, '620702', '1002954', 3);
INSERT INTO `sys_address` VALUES ('1002956', '民乐县', NULL, '620722', '1002954', 3);
INSERT INTO `sys_address` VALUES ('1002957', '临泽县', NULL, '620723', '1002954', 3);
INSERT INTO `sys_address` VALUES ('1002958', '高台县', NULL, '620724', '1002954', 3);
INSERT INTO `sys_address` VALUES ('1002959', '山丹县', NULL, '620725', '1002954', 3);
INSERT INTO `sys_address` VALUES ('1002960', '肃南裕固族自治县', NULL, '620721', '1002954', 3);
INSERT INTO `sys_address` VALUES ('1002961', '平凉市', NULL, '620800', '1000027', 2);
INSERT INTO `sys_address` VALUES ('1002962', '崆峒区', NULL, '620802', '1002961', 3);
INSERT INTO `sys_address` VALUES ('1002963', '泾川县', NULL, '620821', '1002961', 3);
INSERT INTO `sys_address` VALUES ('1002964', '灵台县', NULL, '620822', '1002961', 3);
INSERT INTO `sys_address` VALUES ('1002965', '崇信县', NULL, '620823', '1002961', 3);
INSERT INTO `sys_address` VALUES ('1002966', '华亭县', NULL, '620824', '1002961', 3);
INSERT INTO `sys_address` VALUES ('1002967', '庄浪县', NULL, '620825', '1002961', 3);
INSERT INTO `sys_address` VALUES ('1002968', '静宁县', NULL, '620826', '1002961', 3);
INSERT INTO `sys_address` VALUES ('1002969', '酒泉市', NULL, '620900', '1000027', 2);
INSERT INTO `sys_address` VALUES ('1002970', '肃州区', NULL, '620902', '1002969', 3);
INSERT INTO `sys_address` VALUES ('1002971', '玉门市', NULL, '620981', '1002969', 3);
INSERT INTO `sys_address` VALUES ('1002972', '敦煌市', NULL, '620982', '1002969', 3);
INSERT INTO `sys_address` VALUES ('1002973', '金塔县', NULL, '620921', '1002969', 3);
INSERT INTO `sys_address` VALUES ('1002974', '瓜州县', NULL, '620922', '1002969', 3);
INSERT INTO `sys_address` VALUES ('1002975', '肃北蒙古族自治县', NULL, '620923', '1002969', 3);
INSERT INTO `sys_address` VALUES ('1002976', '阿克塞哈萨克族自治县', NULL, '620924', '1002969', 3);
INSERT INTO `sys_address` VALUES ('1002977', '庆阳市', NULL, '621000', '1000027', 2);
INSERT INTO `sys_address` VALUES ('1002978', '西峰区', NULL, '621002', '1002977', 3);
INSERT INTO `sys_address` VALUES ('1002979', '庆城县', NULL, '621021', '1002977', 3);
INSERT INTO `sys_address` VALUES ('1002980', '环县', NULL, '621022', '1002977', 3);
INSERT INTO `sys_address` VALUES ('1002981', '华池县', NULL, '621023', '1002977', 3);
INSERT INTO `sys_address` VALUES ('1002982', '合水县', NULL, '621024', '1002977', 3);
INSERT INTO `sys_address` VALUES ('1002983', '正宁县', NULL, '621025', '1002977', 3);
INSERT INTO `sys_address` VALUES ('1002984', '宁县', NULL, '621026', '1002977', 3);
INSERT INTO `sys_address` VALUES ('1002985', '镇原县', NULL, '621027', '1002977', 3);
INSERT INTO `sys_address` VALUES ('1002986', '定西市', NULL, '621100', '1000027', 2);
INSERT INTO `sys_address` VALUES ('1002987', '安定区', NULL, '621102', '1002986', 3);
INSERT INTO `sys_address` VALUES ('1002988', '通渭县', NULL, '621121', '1002986', 3);
INSERT INTO `sys_address` VALUES ('1002989', '陇西县', NULL, '621122', '1002986', 3);
INSERT INTO `sys_address` VALUES ('1002990', '渭源县', NULL, '621123', '1002986', 3);
INSERT INTO `sys_address` VALUES ('1002991', '临洮县', NULL, '621124', '1002986', 3);
INSERT INTO `sys_address` VALUES ('1002992', '漳县', NULL, '621125', '1002986', 3);
INSERT INTO `sys_address` VALUES ('1002993', '岷县', NULL, '621126', '1002986', 3);
INSERT INTO `sys_address` VALUES ('1002994', '陇南市', NULL, '621200', '1000027', 2);
INSERT INTO `sys_address` VALUES ('1002995', '武都区', NULL, '621202', '1002994', 3);
INSERT INTO `sys_address` VALUES ('1002996', '成县', NULL, '621221', '1002994', 3);
INSERT INTO `sys_address` VALUES ('1002997', '文县', NULL, '621222', '1002994', 3);
INSERT INTO `sys_address` VALUES ('1002998', '宕昌县', NULL, '621223', '1002994', 3);
INSERT INTO `sys_address` VALUES ('1002999', '康县', NULL, '621224', '1002994', 3);
INSERT INTO `sys_address` VALUES ('1003000', '西和县', NULL, '621225', '1002994', 3);
INSERT INTO `sys_address` VALUES ('1003001', '礼县', NULL, '621226', '1002994', 3);
INSERT INTO `sys_address` VALUES ('1003002', '徽县', NULL, '621227', '1002994', 3);
INSERT INTO `sys_address` VALUES ('1003003', '两当县', NULL, '621228', '1002994', 3);
INSERT INTO `sys_address` VALUES ('1003004', '临夏回族自治州', NULL, '622900', '1000027', 2);
INSERT INTO `sys_address` VALUES ('1003005', '临夏市', NULL, '622901', '1003004', 3);
INSERT INTO `sys_address` VALUES ('1003006', '临夏县', NULL, '622921', '1003004', 3);
INSERT INTO `sys_address` VALUES ('1003007', '康乐县', NULL, '622922', '1003004', 3);
INSERT INTO `sys_address` VALUES ('1003008', '永靖县', NULL, '622923', '1003004', 3);
INSERT INTO `sys_address` VALUES ('1003009', '广河县', NULL, '622924', '1003004', 3);
INSERT INTO `sys_address` VALUES ('1003010', '和政县', NULL, '622925', '1003004', 3);
INSERT INTO `sys_address` VALUES ('1003011', '东乡族自治县', NULL, '622926', '1003004', 3);
INSERT INTO `sys_address` VALUES ('1003012', '积石山保安族东乡族撒拉族自治县', NULL, '622927', '1003004', 3);
INSERT INTO `sys_address` VALUES ('1003013', '甘南藏族自治州', NULL, '623000', '1000027', 2);
INSERT INTO `sys_address` VALUES ('1003014', '合作市', NULL, '623001', '1003013', 3);
INSERT INTO `sys_address` VALUES ('1003015', '临潭县', NULL, '623021', '1003013', 3);
INSERT INTO `sys_address` VALUES ('1003016', '卓尼县', NULL, '623022', '1003013', 3);
INSERT INTO `sys_address` VALUES ('1003017', '舟曲县', NULL, '623023', '1003013', 3);
INSERT INTO `sys_address` VALUES ('1003018', '迭部县', NULL, '623024', '1003013', 3);
INSERT INTO `sys_address` VALUES ('1003019', '玛曲县', NULL, '623025', '1003013', 3);
INSERT INTO `sys_address` VALUES ('1003020', '碌曲县', NULL, '623026', '1003013', 3);
INSERT INTO `sys_address` VALUES ('1003021', '夏河县', NULL, '623027', '1003013', 3);
INSERT INTO `sys_address` VALUES ('1003022', '西宁市', NULL, '630100', '1000028', 2);
INSERT INTO `sys_address` VALUES ('1003023', '城中区', NULL, '630103', '1003022', 3);
INSERT INTO `sys_address` VALUES ('1003024', '城东区', NULL, '630102', '1003022', 3);
INSERT INTO `sys_address` VALUES ('1003025', '城西区', NULL, '630104', '1003022', 3);
INSERT INTO `sys_address` VALUES ('1003026', '城北区', NULL, '630105', '1003022', 3);
INSERT INTO `sys_address` VALUES ('1003027', '湟中县', NULL, '630122', '1003022', 3);
INSERT INTO `sys_address` VALUES ('1003028', '湟源县', NULL, '630123', '1003022', 3);
INSERT INTO `sys_address` VALUES ('1003029', '大通回族土族自治县', NULL, '630121', '1003022', 3);
INSERT INTO `sys_address` VALUES ('1003030', '海东市', NULL, '630200', '1000028', 2);
INSERT INTO `sys_address` VALUES ('1003031', '乐都区', NULL, '630202', '1003030', 3);
INSERT INTO `sys_address` VALUES ('1003032', '平安区', NULL, '630203', '1003030', 3);
INSERT INTO `sys_address` VALUES ('1003033', '民和回族土族自治县', NULL, '630222', '1003030', 3);
INSERT INTO `sys_address` VALUES ('1003034', '互助土族自治县', NULL, '630223', '1003030', 3);
INSERT INTO `sys_address` VALUES ('1003035', '化隆回族自治县', NULL, '630224', '1003030', 3);
INSERT INTO `sys_address` VALUES ('1003036', '循化撒拉族自治县', NULL, '630225', '1003030', 3);
INSERT INTO `sys_address` VALUES ('1003037', '海北藏族自治州', NULL, '632200', '1000028', 2);
INSERT INTO `sys_address` VALUES ('1003038', '海晏县', NULL, '632223', '1003037', 3);
INSERT INTO `sys_address` VALUES ('1003039', '祁连县', NULL, '632222', '1003037', 3);
INSERT INTO `sys_address` VALUES ('1003040', '刚察县', NULL, '632224', '1003037', 3);
INSERT INTO `sys_address` VALUES ('1003041', '门源回族自治县', NULL, '632221', '1003037', 3);
INSERT INTO `sys_address` VALUES ('1003042', '黄南藏族自治州', NULL, '632300', '1000028', 2);
INSERT INTO `sys_address` VALUES ('1003043', '同仁县', NULL, '632321', '1003042', 3);
INSERT INTO `sys_address` VALUES ('1003044', '尖扎县', NULL, '632322', '1003042', 3);
INSERT INTO `sys_address` VALUES ('1003045', '泽库县', NULL, '632323', '1003042', 3);
INSERT INTO `sys_address` VALUES ('1003046', '河南蒙古族自治县', NULL, '632324', '1003042', 3);
INSERT INTO `sys_address` VALUES ('1003047', '海南藏族自治州', NULL, '632500', '1000028', 2);
INSERT INTO `sys_address` VALUES ('1003048', '共和县', NULL, '632521', '1003047', 3);
INSERT INTO `sys_address` VALUES ('1003049', '同德县', NULL, '632522', '1003047', 3);
INSERT INTO `sys_address` VALUES ('1003050', '贵德县', NULL, '632523', '1003047', 3);
INSERT INTO `sys_address` VALUES ('1003051', '兴海县', NULL, '632524', '1003047', 3);
INSERT INTO `sys_address` VALUES ('1003052', '贵南县', NULL, '632525', '1003047', 3);
INSERT INTO `sys_address` VALUES ('1003053', '果洛藏族自治州', NULL, '632600', '1000028', 2);
INSERT INTO `sys_address` VALUES ('1003054', '玛沁县', NULL, '632621', '1003053', 3);
INSERT INTO `sys_address` VALUES ('1003055', '班玛县', NULL, '632622', '1003053', 3);
INSERT INTO `sys_address` VALUES ('1003056', '甘德县', NULL, '632623', '1003053', 3);
INSERT INTO `sys_address` VALUES ('1003057', '达日县', NULL, '632624', '1003053', 3);
INSERT INTO `sys_address` VALUES ('1003058', '久治县', NULL, '632625', '1003053', 3);
INSERT INTO `sys_address` VALUES ('1003059', '玛多县', NULL, '632626', '1003053', 3);
INSERT INTO `sys_address` VALUES ('1003060', '玉树藏族自治州', NULL, '632700', '1000028', 2);
INSERT INTO `sys_address` VALUES ('1003061', '玉树市', NULL, '632701', '1003060', 3);
INSERT INTO `sys_address` VALUES ('1003062', '杂多县', NULL, '632722', '1003060', 3);
INSERT INTO `sys_address` VALUES ('1003063', '称多县', NULL, '632723', '1003060', 3);
INSERT INTO `sys_address` VALUES ('1003064', '治多县', NULL, '632724', '1003060', 3);
INSERT INTO `sys_address` VALUES ('1003065', '囊谦县', NULL, '632725', '1003060', 3);
INSERT INTO `sys_address` VALUES ('1003066', '曲麻莱县', NULL, '632726', '1003060', 3);
INSERT INTO `sys_address` VALUES ('1003067', '海西蒙古族藏族自治州', NULL, '632800', '1000028', 2);
INSERT INTO `sys_address` VALUES ('1003068', '德令哈市', NULL, '632802', '1003067', 3);
INSERT INTO `sys_address` VALUES ('1003069', '格尔木市', NULL, '632801', '1003067', 3);
INSERT INTO `sys_address` VALUES ('1003070', '乌兰县', NULL, '632821', '1003067', 3);
INSERT INTO `sys_address` VALUES ('1003071', '都兰县', NULL, '632822', '1003067', 3);
INSERT INTO `sys_address` VALUES ('1003072', '天峻县', NULL, '632823', '1003067', 3);
INSERT INTO `sys_address` VALUES ('1003073', '银川市', NULL, '640100', '1000029', 2);
INSERT INTO `sys_address` VALUES ('1003074', '金凤区', NULL, '640106', '1003073', 3);
INSERT INTO `sys_address` VALUES ('1003075', '兴庆区', NULL, '640104', '1003073', 3);
INSERT INTO `sys_address` VALUES ('1003076', '西夏区', NULL, '640105', '1003073', 3);
INSERT INTO `sys_address` VALUES ('1003077', '灵武市', NULL, '640181', '1003073', 3);
INSERT INTO `sys_address` VALUES ('1003078', '永宁县', NULL, '640121', '1003073', 3);
INSERT INTO `sys_address` VALUES ('1003079', '贺兰县', NULL, '640122', '1003073', 3);
INSERT INTO `sys_address` VALUES ('1003080', '石嘴山市', NULL, '640200', '1000029', 2);
INSERT INTO `sys_address` VALUES ('1003081', '大武口区', NULL, '640202', '1003080', 3);
INSERT INTO `sys_address` VALUES ('1003082', '惠农区', NULL, '640205', '1003080', 3);
INSERT INTO `sys_address` VALUES ('1003083', '平罗县', NULL, '640221', '1003080', 3);
INSERT INTO `sys_address` VALUES ('1003084', '吴忠市', NULL, '640300', '1000029', 2);
INSERT INTO `sys_address` VALUES ('1003085', '利通区', NULL, '640302', '1003084', 3);
INSERT INTO `sys_address` VALUES ('1003086', '红寺堡区', NULL, '640303', '1003084', 3);
INSERT INTO `sys_address` VALUES ('1003087', '青铜峡市', NULL, '640381', '1003084', 3);
INSERT INTO `sys_address` VALUES ('1003088', '盐池县', NULL, '640323', '1003084', 3);
INSERT INTO `sys_address` VALUES ('1003089', '同心县', NULL, '640324', '1003084', 3);
INSERT INTO `sys_address` VALUES ('1003090', '固原市', NULL, '640400', '1000029', 2);
INSERT INTO `sys_address` VALUES ('1003091', '原州区', NULL, '640402', '1003090', 3);
INSERT INTO `sys_address` VALUES ('1003092', '西吉县', NULL, '640422', '1003090', 3);
INSERT INTO `sys_address` VALUES ('1003093', '隆德县', NULL, '640423', '1003090', 3);
INSERT INTO `sys_address` VALUES ('1003094', '泾源县', NULL, '640424', '1003090', 3);
INSERT INTO `sys_address` VALUES ('1003095', '彭阳县', NULL, '640425', '1003090', 3);
INSERT INTO `sys_address` VALUES ('1003096', '中卫市', NULL, '640500', '1000029', 2);
INSERT INTO `sys_address` VALUES ('1003097', '沙坡头区', NULL, '640502', '1003096', 3);
INSERT INTO `sys_address` VALUES ('1003098', '中宁县', NULL, '640521', '1003096', 3);
INSERT INTO `sys_address` VALUES ('1003099', '海原县', NULL, '640522', '1003096', 3);
INSERT INTO `sys_address` VALUES ('1003100', '乌鲁木齐市', NULL, '650100', '1000030', 2);
INSERT INTO `sys_address` VALUES ('1003101', '天山区', NULL, '650102', '1003100', 3);
INSERT INTO `sys_address` VALUES ('1003102', '沙依巴克区', NULL, '650103', '1003100', 3);
INSERT INTO `sys_address` VALUES ('1003103', '新市区', NULL, '650104', '1003100', 3);
INSERT INTO `sys_address` VALUES ('1003104', '水磨沟区', NULL, '650105', '1003100', 3);
INSERT INTO `sys_address` VALUES ('1003105', '头屯河区', NULL, '650106', '1003100', 3);
INSERT INTO `sys_address` VALUES ('1003106', '达坂城区', NULL, '650107', '1003100', 3);
INSERT INTO `sys_address` VALUES ('1003107', '米东区', NULL, '650109', '1003100', 3);
INSERT INTO `sys_address` VALUES ('1003108', '乌鲁木齐县', NULL, '650121', '1003100', 3);
INSERT INTO `sys_address` VALUES ('1003109', '克拉玛依市', NULL, '650200', '1000030', 2);
INSERT INTO `sys_address` VALUES ('1003110', '克拉玛依区', NULL, '650203', '1003109', 3);
INSERT INTO `sys_address` VALUES ('1003111', '独山子区', NULL, '650202', '1003109', 3);
INSERT INTO `sys_address` VALUES ('1003112', '白碱滩区', NULL, '650204', '1003109', 3);
INSERT INTO `sys_address` VALUES ('1003113', '乌尔禾区', NULL, '650205', '1003109', 3);
INSERT INTO `sys_address` VALUES ('1003114', '吐鲁番市', NULL, '650400', '1000030', 2);
INSERT INTO `sys_address` VALUES ('1003115', '高昌区', NULL, '650402', '1003114', 3);
INSERT INTO `sys_address` VALUES ('1003116', '鄯善县', NULL, '650421', '1003114', 3);
INSERT INTO `sys_address` VALUES ('1003117', '托克逊县', NULL, '650422', '1003114', 3);
INSERT INTO `sys_address` VALUES ('1003118', '哈密市', NULL, '650500', '1000030', 2);
INSERT INTO `sys_address` VALUES ('1003119', '伊州区', NULL, '650502', '1003118', 3);
INSERT INTO `sys_address` VALUES ('1003120', '伊吾县', NULL, '650522', '1003118', 3);
INSERT INTO `sys_address` VALUES ('1003121', '巴里坤哈萨克自治县', NULL, '650521', '1003118', 3);
INSERT INTO `sys_address` VALUES ('1003122', '阿克苏地区', NULL, '652900', '1000030', 2);
INSERT INTO `sys_address` VALUES ('1003123', '阿克苏市', NULL, '652901', '1003122', 3);
INSERT INTO `sys_address` VALUES ('1003124', '温宿县', NULL, '652922', '1003122', 3);
INSERT INTO `sys_address` VALUES ('1003125', '库车县', NULL, '652923', '1003122', 3);
INSERT INTO `sys_address` VALUES ('1003126', '沙雅县', NULL, '652924', '1003122', 3);
INSERT INTO `sys_address` VALUES ('1003127', '新和县', NULL, '652925', '1003122', 3);
INSERT INTO `sys_address` VALUES ('1003128', '拜城县', NULL, '652926', '1003122', 3);
INSERT INTO `sys_address` VALUES ('1003129', '乌什县', NULL, '652927', '1003122', 3);
INSERT INTO `sys_address` VALUES ('1003130', '阿瓦提县', NULL, '652928', '1003122', 3);
INSERT INTO `sys_address` VALUES ('1003131', '柯坪县', NULL, '652929', '1003122', 3);
INSERT INTO `sys_address` VALUES ('1003132', '喀什地区', NULL, '653100', '1000030', 2);
INSERT INTO `sys_address` VALUES ('1003133', '喀什市', NULL, '653101', '1003132', 3);
INSERT INTO `sys_address` VALUES ('1003134', '疏附县', NULL, '653121', '1003132', 3);
INSERT INTO `sys_address` VALUES ('1003135', '疏勒县', NULL, '653122', '1003132', 3);
INSERT INTO `sys_address` VALUES ('1003136', '英吉沙县', NULL, '653123', '1003132', 3);
INSERT INTO `sys_address` VALUES ('1003137', '泽普县', NULL, '653124', '1003132', 3);
INSERT INTO `sys_address` VALUES ('1003138', '莎车县', NULL, '653125', '1003132', 3);
INSERT INTO `sys_address` VALUES ('1003139', '叶城县', NULL, '653126', '1003132', 3);
INSERT INTO `sys_address` VALUES ('1003140', '麦盖提县', NULL, '653127', '1003132', 3);
INSERT INTO `sys_address` VALUES ('1003141', '岳普湖县', NULL, '653128', '1003132', 3);
INSERT INTO `sys_address` VALUES ('1003142', '伽师县', NULL, '653129', '1003132', 3);
INSERT INTO `sys_address` VALUES ('1003143', '巴楚县', NULL, '653130', '1003132', 3);
INSERT INTO `sys_address` VALUES ('1003144', '塔什库尔干塔吉克自治县', NULL, '653131', '1003132', 3);
INSERT INTO `sys_address` VALUES ('1003145', '和田地区', NULL, '653200', '1000030', 2);
INSERT INTO `sys_address` VALUES ('1003146', '和田市', NULL, '653201', '1003145', 3);
INSERT INTO `sys_address` VALUES ('1003147', '和田县', NULL, '653221', '1003145', 3);
INSERT INTO `sys_address` VALUES ('1003148', '墨玉县', NULL, '653222', '1003145', 3);
INSERT INTO `sys_address` VALUES ('1003149', '皮山县', NULL, '653223', '1003145', 3);
INSERT INTO `sys_address` VALUES ('1003150', '洛浦县', NULL, '653224', '1003145', 3);
INSERT INTO `sys_address` VALUES ('1003151', '策勒县', NULL, '653225', '1003145', 3);
INSERT INTO `sys_address` VALUES ('1003152', '于田县', NULL, '653226', '1003145', 3);
INSERT INTO `sys_address` VALUES ('1003153', '民丰县', NULL, '653227', '1003145', 3);
INSERT INTO `sys_address` VALUES ('1003154', '昌吉回族自治州', NULL, '652300', '1000030', 2);
INSERT INTO `sys_address` VALUES ('1003155', '昌吉市', NULL, '652301', '1003154', 3);
INSERT INTO `sys_address` VALUES ('1003156', '阜康市', NULL, '652302', '1003154', 3);
INSERT INTO `sys_address` VALUES ('1003157', '呼图壁县', NULL, '652323', '1003154', 3);
INSERT INTO `sys_address` VALUES ('1003158', '玛纳斯县', NULL, '652324', '1003154', 3);
INSERT INTO `sys_address` VALUES ('1003159', '奇台县', NULL, '652325', '1003154', 3);
INSERT INTO `sys_address` VALUES ('1003160', '吉木萨尔县', NULL, '652327', '1003154', 3);
INSERT INTO `sys_address` VALUES ('1003161', '木垒哈萨克自治县', NULL, '652328', '1003154', 3);
INSERT INTO `sys_address` VALUES ('1003162', '博尔塔拉蒙古自治州', NULL, '652700', '1000030', 2);
INSERT INTO `sys_address` VALUES ('1003163', '博乐市', NULL, '652701', '1003162', 3);
INSERT INTO `sys_address` VALUES ('1003164', '阿拉山口市', NULL, '652702', '1003162', 3);
INSERT INTO `sys_address` VALUES ('1003165', '精河县', NULL, '652722', '1003162', 3);
INSERT INTO `sys_address` VALUES ('1003166', '温泉县', NULL, '652723', '1003162', 3);
INSERT INTO `sys_address` VALUES ('1003167', '巴音郭楞蒙古自治州', NULL, '652800', '1000030', 2);
INSERT INTO `sys_address` VALUES ('1003168', '库尔勒市', NULL, '652801', '1003167', 3);
INSERT INTO `sys_address` VALUES ('1003169', '轮台县', NULL, '652822', '1003167', 3);
INSERT INTO `sys_address` VALUES ('1003170', '尉犁县', NULL, '652823', '1003167', 3);
INSERT INTO `sys_address` VALUES ('1003171', '若羌县', NULL, '652824', '1003167', 3);
INSERT INTO `sys_address` VALUES ('1003172', '且末县', NULL, '652825', '1003167', 3);
INSERT INTO `sys_address` VALUES ('1003173', '和静县', NULL, '652827', '1003167', 3);
INSERT INTO `sys_address` VALUES ('1003174', '和硕县', NULL, '652828', '1003167', 3);
INSERT INTO `sys_address` VALUES ('1003175', '博湖县', NULL, '652829', '1003167', 3);
INSERT INTO `sys_address` VALUES ('1003176', '焉耆回族自治县', NULL, '652826', '1003167', 3);
INSERT INTO `sys_address` VALUES ('1003177', '克孜勒苏柯尔克孜自治州', NULL, '653000', '1000030', 2);
INSERT INTO `sys_address` VALUES ('1003178', '阿图什市', NULL, '653001', '1003177', 3);
INSERT INTO `sys_address` VALUES ('1003179', '阿克陶县', NULL, '653022', '1003177', 3);
INSERT INTO `sys_address` VALUES ('1003180', '阿合奇县', NULL, '653023', '1003177', 3);
INSERT INTO `sys_address` VALUES ('1003181', '乌恰县', NULL, '653024', '1003177', 3);
INSERT INTO `sys_address` VALUES ('1003182', '伊犁哈萨克自治州', NULL, '654000', '1000030', 2);
INSERT INTO `sys_address` VALUES ('1003183', '伊宁市', NULL, '654002', '1003182', 3);
INSERT INTO `sys_address` VALUES ('1003184', '奎屯市', NULL, '654003', '1003182', 3);
INSERT INTO `sys_address` VALUES ('1003185', '霍尔果斯市', NULL, '654004', '1003182', 3);
INSERT INTO `sys_address` VALUES ('1003186', '伊宁县', NULL, '654021', '1003182', 3);
INSERT INTO `sys_address` VALUES ('1003187', '霍城县', NULL, '654023', '1003182', 3);
INSERT INTO `sys_address` VALUES ('1003188', '巩留县', NULL, '654024', '1003182', 3);
INSERT INTO `sys_address` VALUES ('1003189', '新源县', NULL, '654025', '1003182', 3);
INSERT INTO `sys_address` VALUES ('1003190', '昭苏县', NULL, '654026', '1003182', 3);
INSERT INTO `sys_address` VALUES ('1003191', '特克斯县', NULL, '654027', '1003182', 3);
INSERT INTO `sys_address` VALUES ('1003192', '尼勒克县', NULL, '654028', '1003182', 3);
INSERT INTO `sys_address` VALUES ('1003193', '察布查尔锡伯自治县', NULL, '654022', '1003182', 3);
INSERT INTO `sys_address` VALUES ('1003194', '塔城地区', NULL, '654200', '1000030', 2);
INSERT INTO `sys_address` VALUES ('1003195', '塔城市', NULL, '654201', '1003194', 3);
INSERT INTO `sys_address` VALUES ('1003196', '乌苏市', NULL, '654202', '1003194', 3);
INSERT INTO `sys_address` VALUES ('1003197', '额敏县', NULL, '654221', '1003194', 3);
INSERT INTO `sys_address` VALUES ('1003198', '沙湾县', NULL, '654223', '1003194', 3);
INSERT INTO `sys_address` VALUES ('1003199', '托里县', NULL, '654224', '1003194', 3);
INSERT INTO `sys_address` VALUES ('1003200', '裕民县', NULL, '654225', '1003194', 3);
INSERT INTO `sys_address` VALUES ('1003201', '和布克赛尔蒙古自治县', NULL, '654226', '1003194', 3);
INSERT INTO `sys_address` VALUES ('1003202', '阿勒泰地区', NULL, '654300', '1000030', 2);
INSERT INTO `sys_address` VALUES ('1003203', '阿勒泰市', NULL, '654301', '1003202', 3);
INSERT INTO `sys_address` VALUES ('1003204', '布尔津县', NULL, '654321', '1003202', 3);
INSERT INTO `sys_address` VALUES ('1003205', '富蕴县', NULL, '654322', '1003202', 3);
INSERT INTO `sys_address` VALUES ('1003206', '福海县', NULL, '654323', '1003202', 3);
INSERT INTO `sys_address` VALUES ('1003207', '哈巴河县', NULL, '654324', '1003202', 3);
INSERT INTO `sys_address` VALUES ('1003208', '青河县', NULL, '654325', '1003202', 3);
INSERT INTO `sys_address` VALUES ('1003209', '吉木乃县', NULL, '654326', '1003202', 3);
INSERT INTO `sys_address` VALUES ('1003210', '石河子市', NULL, '659001', '1000030', 2);
INSERT INTO `sys_address` VALUES ('1003211', '阿拉尔市', NULL, '659002', '1000030', 2);
INSERT INTO `sys_address` VALUES ('1003212', '图木舒克市', NULL, '659003', '1000030', 2);
INSERT INTO `sys_address` VALUES ('1003213', '五家渠市', NULL, '659004', '1000030', 2);
INSERT INTO `sys_address` VALUES ('1003214', '北屯市', NULL, '659005', '1000030', 2);
INSERT INTO `sys_address` VALUES ('1003215', '铁门关市', NULL, '659006', '1000030', 2);
INSERT INTO `sys_address` VALUES ('1003216', '双河市', NULL, '659007', '1000030', 2);
INSERT INTO `sys_address` VALUES ('1003217', '可克达拉市', NULL, '659008', '1000030', 2);
INSERT INTO `sys_address` VALUES ('1003218', '昆玉市', NULL, '659009', '1000030', 2);
INSERT INTO `sys_address` VALUES ('1003219', '中西区', NULL, '', '1000031', 2);
INSERT INTO `sys_address` VALUES ('1003220', '东区', NULL, '', '1000031', 2);
INSERT INTO `sys_address` VALUES ('1003221', '九龙城区', NULL, '', '1000031', 2);
INSERT INTO `sys_address` VALUES ('1003222', '观塘区', NULL, '', '1000031', 2);
INSERT INTO `sys_address` VALUES ('1003223', '南区', NULL, '', '1000031', 2);
INSERT INTO `sys_address` VALUES ('1003224', '深水埗区', NULL, '', '1000031', 2);
INSERT INTO `sys_address` VALUES ('1003225', '湾仔区', NULL, '', '1000031', 2);
INSERT INTO `sys_address` VALUES ('1003226', '黄大仙区', NULL, '', '1000031', 2);
INSERT INTO `sys_address` VALUES ('1003227', '油尖旺区', NULL, '', '1000031', 2);
INSERT INTO `sys_address` VALUES ('1003228', '离岛区', NULL, '', '1000031', 2);
INSERT INTO `sys_address` VALUES ('1003229', '葵青区', NULL, '', '1000031', 2);
INSERT INTO `sys_address` VALUES ('1003230', '北区', NULL, '', '1000031', 2);
INSERT INTO `sys_address` VALUES ('1003231', '西贡区', NULL, '', '1000031', 2);
INSERT INTO `sys_address` VALUES ('1003232', '沙田区', NULL, '', '1000031', 2);
INSERT INTO `sys_address` VALUES ('1003233', '屯门区', NULL, '', '1000031', 2);
INSERT INTO `sys_address` VALUES ('1003234', '大埔区', NULL, '', '1000031', 2);
INSERT INTO `sys_address` VALUES ('1003235', '荃湾区', NULL, '', '1000031', 2);
INSERT INTO `sys_address` VALUES ('1003236', '元朗区', NULL, '', '1000031', 2);
  • 7
    点赞
  • 8
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
好的,以下是使用`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、付费专栏及课程。

余额充值