C#获取地址省市区

/// <summary>
        /// 解析省市区
        /// </summary>
        /// <param name="address"></param>
        /// <returns></returns>
        public (string province,string city,string county,string town,string village) Analysis(string address)
        {
            string regex = "(?<province>[^省]+自治区|.*?省|.*?行政区|.*?市)?(?<city>[^市]+自治州|.*?地区|.*?行政单位|.+盟|市辖区|.*?市|.*?县)?(?<county>[^县]+县|.+区|.+市|.+旗|.+海域|.+岛)?(?<town>[^区]+区|.+镇)?(?<village>.*)";

            var m = Regex.Match(address, regex, RegexOptions.IgnoreCase);

            var province = m.Groups["province"].Value;
            var city = m.Groups["city"].Value;
            var county = m.Groups["county"].Value;
            var town = m.Groups["town"].Value;
            var village = m.Groups["village"].Value;

            return (province, city, county, town, village);
        }

        /// <summary>
        /// 调用
        /// </summary>
        public void Call()
        {
            var res = Analysis("江西省南昌市青云谱区广州路25号");

            var province = res.province;//省
            var city = res.city;//市
            var county = res.county;//县
            var town = res.town;//镇
            var village = res.village;//村
        }

区 的正则 会受 小区名词 影响

解决方案为:

对区 这个对象 再做一次  正则  正则 内容 由 区 和 小区 区分(只是一个思路)

  • 2
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
CREATE TABLE sys_city ( id int NOT NULL , areaname varchar(24) NULL , parentid int DEFAULT NULL, ) INSERT INTO sys_city VALUES ('110000', '北京市', '0'); INSERT INTO sys_city VALUES ('110101', '东城区', '110100'); INSERT INTO sys_city VALUES ('110102', '西城区', '110100'); INSERT INTO sys_city VALUES ('110105', '朝阳区', '110100'); INSERT INTO sys_city VALUES ('110106', '丰台区', '110100'); INSERT INTO sys_city VALUES ('110107', '石景山区', '110100'); INSERT INTO sys_city VALUES ('110108', '海淀区', '110100'); INSERT INTO sys_city VALUES ('110109', '门头沟区', '110100'); INSERT INTO sys_city VALUES ('110111', '房山区', '110100'); INSERT INTO sys_city VALUES ('110112', '通州区', '110100'); INSERT INTO sys_city VALUES ('110113', '顺义区', '110100'); INSERT INTO sys_city VALUES ('110114', '昌平区', '110100'); INSERT INTO sys_city VALUES ('110115', '大兴区', '110100'); INSERT INTO sys_city VALUES ('110116', '怀柔区', '110100'); INSERT INTO sys_city VALUES ('110117', '平谷区', '110100'); INSERT INTO sys_city VALUES ('110228', '密云区', '110200'); INSERT INTO sys_city VALUES ('110229', '延庆区', '110200'); INSERT INTO sys_city VALUES ('120000', '天津市', '0'); INSERT INTO sys_city VALUES ('120101', '和平区', '120100'); INSERT INTO sys_city VALUES ('120102', '河东区', '120100'); INSERT INTO sys_city VALUES ('120103', '河西区', '120100'); INSERT INTO sys_city VALUES ('120104', '南开区', '120100'); INSERT INTO sys_city VALUES ('120105', '河北区', '120100'); INSERT INTO sys_city VALUES ('120106', '红桥区', '120100'); INSERT INTO sys_city VALUES ('120110', '东丽区', '120100'); INSERT INTO sys_city VALUES ('120111', '西青区', '120100'); INSERT INTO sys_city VALUES ('120112', '津南区', '120100'); INSERT INTO sys_city VALUES ('120113', '北辰区', '120100'); INSERT INTO sys_city VALUES ('120114', '武清区', '120100'); INSERT INTO sys_city VALUES ('120115', '宝坻区', '120100'); INSERT INTO sys_city VALUES ('120116', '滨海新区', '120100'); INSERT INTO sys_city VALUES ('120221', '宁河区', '120200'); INSERT INTO sys_city VALUES ('120223', '静海区', '120200'); INSERT INTO sys_city VALUES ('120225', '蓟', '120200'); INSERT INTO sys_city VALUES ('130000', '河北省', '0'); INSERT INTO sys_city VALUES ('130100', '石家庄市', '130000'); INSERT INTO sys_city VALUES ('130102', '长安区', '130100'); INSERT INTO sys_city VALUES ('130104', '桥西区', '130100'); INSERT INTO sys_city VALUES ('130105', '新华区', '130100'); INSERT INTO sys_city VALUES ('130107', '井陉矿区', '130100'); INSERT INTO sys_city VALUES ('130108', '裕华区', '130100'); INSERT INTO sys_city VALUES ('130109', '藁城区', '130100'); INSERT INTO sys_city VALUES ('130110', '鹿泉区', '130100'); INSERT INTO sys_city VALUES ('130111', '栾城区', '130100'); INSERT INTO sys_city VALUES ('130121', '井陉', '130100'); INSERT INTO sys_city VALUES ('130123', '正定', '130100'); INSERT INTO sys_city VALUES ('130125', '行唐', '130100'); INSERT INTO sys_city VALUES ('130126', '灵寿', '130100'); INSERT INTO sys_city VALUES ('130127', '高邑', '130100'); INSERT INTO sys_city VALUES ('130128', '深泽', '130100'); INSERT INTO sys_city VALUES ('130129', '赞皇', '130100'); INSERT INTO sys_city VALUES ('130130', '无极', '130100'); INSERT INTO sys_city VALUES ('130131', '平山', '130100'); INSERT INTO sys_city VALUES ('130132', '元氏', '130100'); INSERT INTO sys_city VALUES ('130133', '赵', '130100'); INSERT INTO sys_city VALUES ('130181', '辛集市', '130100'); INSERT INTO sys_city VALUES ('130183', '晋州市', '130100'); INSERT INTO sys_city VALUES ('130184', '新乐市', '130100'); INSERT INTO sys_city VALUES ('130200', '唐山市', '130000'); INSERT INTO sys_city VALUES ('130202', '路南区', '130200'); INSERT INTO sys_city VALUES ('130203', '路北区', '130200'); INSERT INTO sys_city VALUES ('130204', '古冶区', '130200'); INSERT INTO sys_city VALUES ('130205', '开平区', '130200'); INSERT INTO sys_city VALUES ('130207', '丰南区', '130200'); INSERT INTO sys_city VALUES ('130208', '丰润区', '130200'); INSERT INTO sys_city VALUES ('130209', '曹妃甸区', '130200'); INSERT INTO sys_city VALUES ('130223', '滦', '130200'); INSERT INTO sys_city VALUES ('130224', '滦南', '130200'); INSERT INTO sys_city VALUES ('130225', '乐亭', '130200'); INSERT INTO sys_city VALUES ('130227', '迁西', '130200'); INSERT INTO sys_city VALUES ('130229', '玉田', '130200'); INSERT INTO sys_city VALUES ('130281', '遵化市', '130200'); INSERT INTO sys_city VALUES ('130283', '迁安市', '130200'); INSERT INTO sys_city VALUES ('130300', '秦皇岛市', '130000'); INSERT INTO sys_city VALUES ('130302', '海港区', '130300'); INSERT INTO sys_city VALUES ('130303', '山海关区', '130300'); INSERT INTO sys_city VALUES ('130304', '北戴河区', '130300'); INSERT INTO sys_city VALUES ('130321', '青龙满族自治', '130300'); INSERT INTO sys_city VALUES ('130322', '昌黎', '130300'); INSERT INTO sys_city VALUES ('130323', '抚宁', '130300'); INSERT INTO sys_city VALUES ('130324', '卢龙', '130300'); INSERT INTO sys_city VALUES ('130400', '邯郸市', '130000'); INSERT INTO sys_city VALUES ('130402', '邯山区', '130400'); INSERT INTO sys_city VALUES ('130403', '丛台区', '130400'); INSERT INTO sys_city VALUES ('130404', '复兴区', '130400'); INSERT INTO sys_city VALUES ('130406', '峰峰矿区', '130400'); INSERT INTO sys_city VALUES ('130421', '邯郸', '130400'); INSERT INTO sys_city VALUES ('130423', '临漳', '130400'); INSERT INTO sys_city VALUES ('130424', '成安', '130400'); INSERT INTO sys_city VALUES ('130425', '大名', '130400'); INSERT INTO sys_city VALUES ('130426', '涉', '130400'); INSERT INTO sys_city VALUES ('130427', '磁', '130400'); INSERT INTO sys_city VALUES ('130428', '肥乡', '130400'); INSERT INTO sys_city VALUES ('130429', '永年', '130400'); INSERT INTO sys_city VALUES ('130430', '邱', '130400'); INSERT INTO sys_city VALUES ('130431', '鸡泽', '130400'); INSERT INTO sys_city VALUES ('130432', '广平', '130400'); INSERT INTO sys_city VALUES ('130433', '馆陶', '130400'); INSERT INTO sys_city VALUES ('130434', '魏', '130400'); INSERT INTO sys_city VALUES ('130435', '曲周', '130400'); INSERT INTO sys_city VALUES ('130481', '武安市', '130400'); INSERT INTO sys_city VALUES ('130500', '邢台市', '130000'); INSERT INTO sys_city VALUES ('130502', '桥东区', '130500'); INSERT INTO sys_city VALUES ('130503', '桥西区', '130500'); INSERT INTO sys_city VALUES ('130521', '邢台', '130500'); INSERT INTO sys_city VALUES ('130522', '临城', '130500'); INSERT INTO sys_city VALUES ('130523', '内丘', '130500'); INSERT INTO sys_city VALUES ('130524', '柏乡', '130500'); INSERT INTO sys_city VALUES ('130525', '隆尧', '130500'); INSERT INTO sys_city VALUES ('130526', '任', '130500'); INSERT INTO sys_city VALUES ('130527', '南和', '130500'); INSERT INTO sys_city VALUES ('130528', '宁晋', '130500'); INSERT INTO sys_city VALUES ('130529', '巨鹿', '130500'); INSERT INTO sys_city VALUES ('130530', '新河', '130500'); INSERT INTO sys_city VALUES ('130531', '广宗', '130500'); INSERT INTO sys_city VALUES ('130532', '平乡', '130500'); INSERT INTO sys_city VALUES ('130533', '威', '130500'); INSERT INTO sys_city VALUES ('130534', '清河', '130500'); INSERT INTO sys_city VALUES ('130535', '临西', '130500'); INSERT INTO sys_city VALUES ('130581', '南宫市', '130500'); INSERT INTO sys_city VALUES ('130582', '沙河市', '130500'); INSERT INTO sys_city VALUES ('130600', '保定市', '130000'); INSERT INTO sys_city VALUES ('130602', '竞秀区', '130600'); INSERT INTO sys_city VALUES ('130604', '南市区', '130600'); INSERT INTO sys_city VALUES ('130606', '莲池区', '130600'); INSERT INTO sys_city VALUES ('130607', '满城区', '130600'); INSERT INTO sys_city VALUES ('130608', '清苑区', '130600'); INSERT INTO sys_city VALUES ('130609', '徐水区', '130600'); INSERT INTO sys_city VALUES ('130623', '涞水', '130600'); INSERT INTO sys_city VALUES ('130624', '阜平', '130600'); INSERT INTO sys_city VALUES ('130626', '定兴', '130600'); INSERT INTO sys_city VALUES ('130627', '唐', '130600'); INSERT INTO sys_city VALUES ('130628', '高阳', '130600'); INSERT INTO sys_city VALUES ('130629', '容城', '130600'); INSERT INTO sys_city VALUES ('130630', '涞源', '130600'); INSERT INTO sys_city VALUES ('130631', '望都', '130600'); INSERT INTO sys_city VALUES ('130632', '安新', '130600'); INSERT INTO sys_city VALUES ('130633', '易', '130600'); INSERT INTO sys_city VALUES ('130634', '曲阳', '130600'); INSERT INTO sys_city VALUES ('130635', '蠡', '130600'); INSERT INTO sys_city VALUES ('130636', '顺平', '130600'); INSERT INTO sys_city VALUES ('130637', '博野', '130600'); INSERT INTO sys_city VALUES ('130638', '雄', '130600'); INSERT INTO sys_city VALUES ('130681', '涿州市', '130600'); INSERT INTO sys_city VALUES ('130682', '定州市', '130600'); INSERT INTO sys_city VALUES ('130683', '安国市', '130600'); INSERT INTO sys_city VALUES ('130684', '高碑店市', '130600'); INSERT INTO sys_city VALUES ('130700', '张家口市', '130000'); INSERT INTO sys_city VALUES ('130702', '桥东区', '130700'); INSERT INTO sys_city VALUES ('130703', '桥西区', '130700'); INSERT INTO sys_city VALUES ('130705', '宣化区', '130700'); INSERT INTO sys_city VALUES ('130706', '下花园区', '130700'); INSERT INTO sys_city VALUES ('130721', '宣化', '130700'); INSERT INTO sys_city VALUES ('130722', '张北', '130700'); INSERT INTO sys_city VALUES ('130723', '康保', '130700'); INSERT INTO sys_city VALUES ('130724', '沽源', '130700'); INSERT INTO sys_city VALUES ('130725', '尚义', '130700'); INSERT INTO sys_city VALUES ('130726', '蔚', '130700'); INSERT INTO sys_city VALUES ('130727', '阳原', '130700'); INSERT INTO sys_city VALUES ('130728', '怀安', '130700'); INSERT INTO sys_city VALUES ('130729', '万全', '130700'); INSERT INTO sys_city VALUES ('130730', '怀来', '130700'); INSERT INTO sys_city VALUES ('130731', '涿鹿', '130700'); INSERT INTO sys_city VALUES ('130732', '赤城', '130700'); INSERT INTO sys_city VALUES ('130733', '崇礼', '130700'); INSERT INTO sys_city VALUES ('130800', '承德市', '130000'); INSERT INTO sys_city VALUES ('130802', '双桥区', '130800'); INSERT INTO sys_city VALUES ('130803', '双滦区', '130800'); INSERT INTO sys_city VALUES ('130804', '鹰手营子矿区', '130800'); INSERT INTO sys_city VALUES ('130821', '承德', '130800'); INSERT INTO sys_city VALUES ('130822', '兴隆', '130800'); INSERT INTO sys_city VALUES ('130823', '平泉', '130800'); INSERT INTO sys_city VALUES ('130824', '滦平', '130800'); INSERT INTO sys_city VALUES ('130825', '隆化', '130800'); INSERT INTO sys_city VALUES ('130826', '丰宁满族自治', '130800'); INSERT INTO sys_city VALUES ('130827', '宽城满族自治', '130800'); INSERT INTO sys_city VALUES ('130828', '围场满族蒙古族自治', '130800'); INSERT INTO sys_city VALUES ('130900', '沧州市', '130000'); INSERT INTO sys_city VALUES ('130902', '新华区', '130900'); INSERT INTO sys_city VALUES ('130903', '运河区', '130900'); INSERT INTO sys_city VALUES ('130921', '沧', '130900'); INSERT INTO sys_city VALUES ('130922', '青', '130900'); INSERT INTO sys_city VALUES ('130923', '东光', '130900'); INSERT INTO sys_city VALUES ('130924', '海兴', '130900'); INSERT INTO sys_city VALUES ('130925', '盐山', '130900'); INSERT INTO sys_city VALUES ('130926', '肃宁', '130900'); INSERT INTO sys_city VALUES ('130927', '南皮', '130900'); INSERT INTO sys_city VALUES ('130928', '吴桥', '130900'); INSERT INTO sys_city VALUES ('130929', '献', '130900'); INSERT INTO sys_city VALUES ('130930', '孟村回族自治', '130900'); INSERT INTO sys_city VALUES ('130981', '泊头市', '130900'); INSERT INTO sys_city VALUES ('130982', '任丘市', '130900'); INSERT INTO sys_city VALUES ('130983', '黄骅市', '130900'); INSERT INTO sys_city VALUES ('130984', '河间市', '130900'); INSERT INTO sys_city VALUES ('131000', '廊坊市', '130000'); INSERT INTO sys_city VALUES ('131002', '安次区', '131000'); INSERT INTO sys_city VALUES ('131003', '广阳区', '131000'); INSERT INTO sys_city VALUES ('131022', '固安', '131000'); INSERT INTO sys_city VALUES ('131023', '永清', '131000'); INSERT INTO sys_city VALUES ('131024', '香河', '131000'); INSERT INTO sys_city VALUES ('131025', '大城', '131000'); INSERT INTO sys_city VALUES ('131026', '文安', '131000'); INSERT INTO sys_city VALUES ('131028', '大厂回族自治', '131000'); INSERT INTO sys_city VALUES ('131081', '霸州市', '131000'); INSERT INTO sys_city VALUES ('131082', '三河市', '131000'); INSERT INTO sys_city VALUES ('131100', '衡水市', '130000'); INSERT INTO sys_city VALUES ('131102', '桃城区', '131100'); INSERT INTO sys_city VALUES ('131121', '枣强', '131100'); INSERT INTO sys_city VALUES ('131122', '武邑', '131100'); INSERT INTO sys_city VALUES ('131123', '武强', '131100'); INSERT INTO sys_city VALUES ('131124', '饶阳', '131100'); INSERT INTO sys_city VALUES ('131125', '安平', '131100'); INSERT INTO sys_city VALUES ('131126', '故城', '131100'); INSERT INTO sys_city VALUES ('131127', '景', '131100'); INSERT INTO sys_city VALUES ('131128', '阜城', '131100'); INSERT INTO sys_city VALUES ('131181', '冀州市', '131100'); INSERT INTO sys_city VALUES ('131182', '深州市', '131100'); INSERT INTO sys_city VALUES ('140000', '山西省', '0'); INSERT INTO sys_city VALUES ('140100', '太原市', '140000'); INSERT INTO sys_city VALUES ('140105', '小店区', '140100'); INSERT INTO sys_city VALUES ('140106', '迎泽区', '140100'); INSERT INTO sys_city VALUES ('140107', '杏花岭区', '140100'); INSERT INTO sys_city VALUES ('140108', '尖草坪区', '140100'); INSERT INTO sys_city VALUES ('140109', '万柏林区', '140100'); INSERT INTO sys_city VALUES ('140110', '晋源区', '140100'); INSERT INTO sys_city VALUES ('140121', '清徐', '140100'); INSERT INTO sys_city VALUES ('140122', '阳曲', '140100'); INSERT INTO sys_city VALUES ('140123', '娄烦', '140100'); INSERT INTO sys_city VALUES ('140181', '古交市', '140100'); INSERT INTO sys_city VALUES ('140200', '大同市', '140000'); INSERT INTO sys_city VALUES ('140202', '城区', '140200'); INSERT INTO sys_city VALUES ('140203', '矿区', '140200'); INSERT INTO sys_city VALUES ('140211', '南郊区', '140200'); INSERT INTO sys_city VALUES ('140212', '新荣区', '140200'); INSERT INTO sys_city VALUES ('140221', '阳高', '140200'); INSERT INTO sys_city VALUES ('140222', '天镇', '140200'); INSERT INTO sys_city VALUES ('140223', '广灵', '140200'); INSERT INTO sys_city VALUES ('140224', '灵丘', '140200'); INSERT INTO sys_city VALUES ('140225', '浑源', '140200'); INSERT INTO sys_city VALUES ('140226', '左云', '140200'); INSERT INTO sys_city VALUES ('140227', '大同', '140200'); INSERT INTO sys_city VALUES ('140300', '阳泉市', '140000'); INSERT INTO sys_city VALUES ('140302', '城区', '140300'); INSERT INTO sys_city VALUES ('140303', '矿区', '140300'); INSERT INTO sys_city VALUES ('140311', '郊区', '140300'); INSERT INTO sys_city VALUES ('140321', '平定', '140300'); INSERT INTO sys_city VALUES ('140322', '盂', '140300'); INSERT INTO sys_city VALUES ('140400', '长治市', '140000'); INSERT INTO sys_city VALUES ('140402', '城区', '140400'); INSERT INTO sys_city VALUES ('140411', '郊区', '140400'); INSERT INTO sys_city VALUES ('140421', '长治', '140400'); INSERT INTO sys_city VALUES ('140423', '襄垣', '140400'); INSERT INTO sys_city VALUES ('140424', '屯留', '140400'); INSERT INTO sys_city VALUES ('140425', '平顺', '140400'); INSERT INTO sys_city VALUES ('140426', '黎城', '140400'); INSERT INTO sys_city VALUES ('140427', '壶关', '140400'); INSERT INTO sys_city VALUES ('140428', '长子', '140400'); INSERT INTO sys_city VALUES ('140429', '武乡', '140400'); INSERT INTO sys_city VALUES ('140430', '沁', '140400'); INSERT INTO sys_city VALUES ('140431', '沁源', '140400'); INSERT INTO sys_city VALUES ('140481', '潞城市', '140400'); INSERT INTO sys_city VALUES ('140500', '晋城市', '140000'); INSERT INTO sys_city VALUES ('140502', '城区', '140500'); INSERT INTO sys_city VALUES ('140521', '沁水', '140500'); INSERT INTO sys_city VALUES ('140522', '阳城', '140500'); INSERT INTO sys_city VALUES ('140524', '陵川', '140500'); INSERT INTO sys_city VALUES ('140525', '泽州', '140500'); INSERT INTO sys_city VALUES ('140581', '高平市', '140500'); INSERT INTO sys_city VALUES ('140600', '朔州市', '140000'); INSERT INTO sys_city VALUES ('140602', '朔城区', '140600'); INSERT INTO sys_city VALUES ('140603', '平鲁区', '140600'); INSERT INTO sys_city VALUES ('140621', '山阴', '140600'); INSERT INTO sys_city VALUES ('140622', '应', '140600'); INSERT INTO sys_city VALUES ('140623', '右玉', '140600'); INSERT INTO sys_city VALUES ('140624', '怀仁', '140600'); INSERT INTO sys_city VALUES ('140700', '晋中市', '140000'); INSERT INTO sys_city VALUES ('140702', '榆次区', '140700'); INSERT INTO sys_city VALUES ('140721', '榆社', '140700'); INSERT INTO sys_city VALUES ('140722', '左权', '140700'); INSERT INTO sys_city VALUES ('140723', '和顺', '140700'); INSERT INTO sys_city VALUES ('140724', '昔阳', '140700'); INSERT INTO sys_city VALUES ('140725', '寿阳', '140700'); INSERT INTO sys_city VALUES ('140726', '太谷', '140700'); INSERT INTO sys_city VALUES ('140727', '祁', '140700'); INSERT INTO sys_city VALUES ('140728', '平遥', '140700'); INSERT INTO sys_city VALUES ('140729', '灵石', '140700'); INSERT INTO sys_city VALUES ('140781', '介休市', '140700'); INSERT INTO sys_city VALUES ('140800', '运城市', '140000'); INSERT INTO sys_city VALUES ('140802', '盐湖区', '140800'); INSERT INTO sys_city VALUES ('140821', '临猗', '140800'); INSERT INTO sys_city VALUES ('140822', '万荣', '140800'); INSERT INTO sys_city VALUES ('140823', '闻喜', '140800'); INSERT INTO sys_city VALUES ('140824', '稷山', '140800'); INSERT INTO sys_city VALUES ('140825', '新绛', '140800'); INSERT INTO sys_city VALUES ('140826', '绛', '140800'); INSERT INTO sys_city VALUES ('140827', '垣曲', '140800'); INSERT INTO sys_city VALUES ('140828', '夏', '140800'); INSERT INTO sys_city VALUES ('140829', '平陆', '140800'); INSERT INTO sys_city VALUES ('140830', '芮城', '140800'); INSERT INTO sys_city VALUES ('140881', '永济市', '140800'); INSERT INTO sys_city VALUES ('140882', '河津市', '140800'); INSERT INTO sys_city VALUES ('140900', '忻州市', '140000'); INSERT INTO sys_city VALUES ('140902', '忻府区', '140900'); INSERT INTO sys_city VALUES ('140921', '定襄', '140900'); INSERT INTO sys_city VALUES ('140922', '五台', '140900'); INSERT INTO sys_city VALUES ('140923', '代', '140900'); INSERT INTO sys_city VALUES ('140924', '繁峙', '140900'); INSERT INTO sys_city VALUES ('140925', '宁武', '140900'); INSERT INTO sys_city VALUES ('140926', '静乐', '140900'); INSERT INTO sys_city VALUES ('140927', '神池', '140900'); INSERT INTO sys_city VALUES ('140928', '五寨', '140900'); INSERT INTO sys_city VALUES ('140929', '岢岚', '140900'); INSERT INTO sys_city VALUES ('140930', '河曲', '140900'); INSERT INTO sys_city VALUES ('140931', '保德', '140900'); INSERT INTO sys_city VALUES ('140932', '偏关', '140900'); INSERT INTO sys_city VALUES ('140981', '原平市', '140900'); INSERT INTO sys_city VALUES ('141000', '临汾市', '140000'); INSERT INTO sys_city VALUES ('141002', '尧都区', '141000'); INSERT INTO sys_city VALUES ('141021', '曲沃', '141000'); INSERT INTO sys_city VALUES ('141022', '翼城', '141000'); INSERT INTO sys_city VALUES ('141023', '襄汾', '141000'); INSERT INTO sys_city VALUES ('141024', '洪洞', '141000'); INSERT INTO sys_city VALUES ('141025', '古', '141000'); INSERT INTO sys_city VALUES ('141026', '安泽', '141000'); INSERT INTO sys_city VALUES ('141027', '浮山', '141000'); INSERT INTO sys_city VALUES ('141028', '吉', '141000'); INSERT INTO sys_city VALUES ('141029', '乡宁', '141000'); INSERT INTO sys_city VALUES ('141030', '大宁', '141000'); INSERT INTO sys_city VALUES ('141031', '隰', '141000'); INSERT INTO sys_city VALUES ('141032', '永和', '141000'); INSERT INTO sys_city VALUES ('141033', '蒲', '141000'); INSERT INTO sys_city VALUES ('141034', '汾西', '141000'); INSERT INTO sys_city VALUES ('141081', '侯马市', '141000'); INSERT INTO sys_city VALUES ('141082', '霍州市', '141000'); INSERT INTO sys_city VALUES ('141100', '吕梁市', '140000'); INSERT INTO sys_city VALUES ('141102', '离石区', '141100'); INSERT INTO sys_city VALUES ('141121', '文水', '141100'); INSERT INTO sys_city VALUES ('141122', '交城', '141100'); INSERT INTO sys_city VALUES ('141123', '兴', '141100'); INSERT INTO sys_city VALUES ('141124', '临', '141100'); INSERT INTO sys_city VALUES ('141125', '柳林', '141100'); INSERT INTO sys_city VALUES ('141126', '石楼', '141100'); INSERT INTO sys_city VALUES ('141127', '岚', '141100'); INSERT INTO sys_city VALUES ('141128', '方山', '141100'); INSERT INTO sys_city VALUES ('141129', '中阳', '141100'); INSERT INTO sys_city VALUES ('141130', '交口', '141100'); INSERT INTO sys_city VALUES ('141181', '孝义市', '141100'); INSERT INTO sys_city VALUES ('141182', '汾阳市', '141100'); INSERT INTO sys_city VALUES ('150000', '内蒙古自治区', '0'); INSERT INTO sys_city VALUES ('150100', '呼和浩特市', '150000'); INSERT INTO sys_city VALUES ('150102', '新城区', '150100'); INSERT INTO sys_city VALUES ('150103', '回民区', '150100'); INSERT INTO sys_city VALUES ('150104', '玉泉区', '150100'); INSERT INTO sys_city VALUES ('150105', '赛罕区', '150100'); INSERT INTO sys_city VALUES ('150121', '土默特左旗', '150100'); INSERT INTO sys_city VALUES ('150122', '托克托', '150100'); INSERT INTO sys_city VALUES ('150123', '和林格尔', '150100'); INSERT INTO sys_city VALUES ('150124', '清水河', '150100'); INSERT INTO sys_city VALUES ('150125', '武川', '150100'); INSERT INTO sys_city VALUES ('150200', '包头市', '150000'); INSERT INTO sys_city VALUES ('150202', '东河区', '150200'); INSERT INTO sys_city VALUES ('150203', '昆都仑区', '150200'); INSERT INTO sys_city VALUES ('150204', '青山区', '150200'); INSERT INTO sys_city VALUES ('150205', '石拐区', '150200'); INSERT INTO sys_city VALUES ('150206', '白云鄂博矿区', '150200'); INSERT INTO sys_city VALUES ('150207', '九原区', '150200'); INSERT INTO sys_city VALUES ('150221', '土默特右旗', '150200'); INSERT INTO sys_city VALUES ('150222', '固阳', '150200'); INSERT INTO sys_city VALUES ('150223', '达尔罕茂明安联合旗', '150200'); INSERT INTO sys_city VALUES ('150300', '乌海市', '150000'); INSERT INTO sys_city VALUES ('150302', '海勃湾区', '150300'); INSERT INTO sys_city VALUES ('150303', '海南区', '150300'); INSERT INTO sys_city VALUES ('150304', '乌达区', '150300'); INSERT INTO sys_city VALUES ('150400', '赤峰市', '150000'); INSERT INTO sys_city VALUES ('150402', '红山区', '150400'); INSERT INTO sys_city VALUES ('150403', '元宝山区', '150400'); INSERT INTO sys_city VALUES ('150404', '松山区', '150400'); INSERT INTO sys_city VALUES ('150421', '阿鲁科尔沁旗', '150400'); INSERT INTO sys_city VALUES ('150422', '巴林左旗', '150400'); INSERT INTO sys_city VALUES ('150423', '巴林右旗', '150400'); INSERT INTO sys_city VALUES ('150424', '林西', '150400'); INSERT INTO sys_city VALUES ('150425', '克什克腾旗', '150400'); INSERT INTO sys_city VALUES ('150426', '翁牛特旗', '150400'); INSERT INTO sys_city VALUES ('150428', '喀喇沁旗', '150400'); INSERT INTO sys_city VALUES ('150429', '宁城', '150400'); INSERT INTO sys_city VALUES ('150430', '敖汉旗', '150400'); INSERT INTO sys_city VALUES ('150500', '通辽市', '150000'); INSERT INTO sys_city VALUES ('150502', '科尔沁区', '150500'); INSERT INTO sys_city VALUES ('150521', '科尔沁左翼中旗', '150500'); INSERT INTO sys_city VALUES ('150522', '科尔沁左翼后旗', '150500'); INSERT INTO sys_city VALUES ('150523', '开鲁', '150500'); INSERT INTO sys_city VALUES ('150524', '库伦旗', '150500'); INSERT INTO sys_city VALUES ('150525', '奈曼旗', '150500'); INSERT INTO sys_city VALUES ('150526', '扎鲁特旗', '150500'); INSERT INTO sys_city VALUES ('150581', '霍林郭勒市', '150500'); INSERT INTO sys_city VALUES ('150600', '鄂尔多斯市', '150000'); INSERT INTO sys_city VALUES ('150602', '东胜区', '150600'); INSERT INTO sys_city VALUES ('150621', '达拉特旗', '150600'); INSERT INTO sys_city VALUES ('150622', '准格尔旗', '150600'); INSERT INTO sys_city VALUES ('150623', '鄂托克前旗', '150600'); INSERT INTO sys_city VALUES ('150624', '鄂托克旗', '150600'); INSERT INTO sys_city VALUES ('150625', '杭锦旗', '150600'); INSERT INTO sys_city VALUES ('150626', '乌审旗', '150600'); INSERT INTO sys_city VALUES ('150627', '伊金霍洛旗', '150600'); INSERT INTO sys_city VALUES ('150700', '呼伦贝尔市', '150000'); INSERT INTO sys_city VALUES ('150702', '海拉尔区', '150700'); INSERT INTO sys_city VALUES ('150703', '扎赉诺尔区', '150700'); INSERT INTO sys_city VALUES ('150721', '阿荣旗', '150700'); INSERT INTO sys_city VALUES ('150722', '莫力达瓦达斡尔族自治旗', '150700'); INSERT INTO sys_city VALUES ('150723', '鄂伦春自治旗', '150700'); INSERT INTO sys_city VALUES ('150724', '鄂温克族自治旗', '150700'); INSERT INTO sys_city VALUES ('150725', '陈巴尔虎旗', '150700'); INSERT INTO sys_city VALUES ('150726', '新巴尔虎左旗', '150700'); INSERT INTO sys_city VALUES ('150727', '新巴尔虎右旗', '150700'); INSERT INTO sys_city VALUES ('150781', '满洲里市', '150700'); INSERT INTO sys_city VALUES ('150782', '牙克石市', '150700'); INSERT INTO sys_city VALUES ('150783', '扎兰屯市', '150700'); INSERT INTO sys_city VALUES ('150784', '额尔古纳市', '150700'); INSERT INTO sys_city VALUES ('150785', '根河市', '150700'); INSERT INTO sys_city VALUES ('150800', '巴彦淖尔市', '150000'); INSERT INTO sys_city VALUES ('150802', '临河区', '150800'); INSERT INTO sys_city VALUES ('150821', '五原', '150800'); INSERT INTO sys_city VALUES ('150822', '磴口', '150800'); INSERT INTO sys_city VALUES ('150823', '乌拉特前旗', '150800'); INSERT INTO sys_city VALUES ('150824', '乌拉特中旗', '150800'); INSERT INTO sys_city VALUES ('150825', '乌拉特后旗', '150800'); INSERT INTO sys_city VALUES ('150826', '杭锦后旗', '150800'); INSERT INTO sys_city VALUES ('150900', '乌兰察布市', '150000'); INSERT INTO sys_city VALUES ('150902', '集宁区', '150900'); INSERT INTO sys_city VALUES ('150921', '卓资', '150900'); INSERT INTO sys_city VALUES ('150922', '化德', '150900'); INSERT INTO sys_city VALUES ('150923', '商都', '150900'); INSERT INTO sys_city VALUES ('150924', '兴和', '150900'); INSERT INTO sys_city VALUES ('150925', '凉城', '150900'); INSERT INTO sys_city VALUES ('150926', '察哈尔右翼前旗', '150900'); INSERT INTO sys_city VALUES ('150927', '察哈尔右翼中旗', '150900'); INSERT INTO sys_city VALUES ('150928', '察哈尔右翼后旗', '150900'); INSERT INTO sys_city VALUES ('150929', '四子王旗', '150900'); INSERT INTO sys_city VALUES ('150981', '丰镇市', '150900'); INSERT INTO sys_city VALUES ('152200', '兴安盟', '150000'); INSERT INTO sys_city VALUES ('152201', '乌兰浩特市', '152200'); INSERT INTO sys_city VALUES ('152202', '阿尔山市', '152200'); INSERT INTO sys_city VALUES ('152221', '科尔沁右翼前旗', '152200'); INSERT INTO sys_city VALUES ('152222', '科尔沁右翼中旗', '152200'); INSERT INTO sys_city VALUES ('152223', '扎赉特旗', '152200'); INSERT INTO sys_city VALUES ('152224', '突泉', '152200'); INSERT INTO sys_city VALUES ('152500', '锡林郭勒盟', '150000'); INSERT INTO sys_city VALUES ('152501', '二连浩特市', '152500'); INSERT INTO sys_city VALUES ('152502', '锡林浩特市', '152500'); INSERT INTO sys_city VALUES ('152522', '阿巴嘎旗', '152500'); INSERT INTO sys_city VALUES ('152523', '苏尼特左旗', '152500'); INSERT INTO sys_city VALUES ('152524', '苏尼特右旗', '152500'); INSERT INTO sys_city VALUES ('152525', '东乌珠穆沁旗', '152500'); INSERT INTO sys_city VALUES ('152526', '西乌珠穆沁旗', '152500'); INSERT INTO sys_city VALUES ('152527', '太仆寺旗', '152500'); INSERT INTO sys_city VALUES ('152528', '镶黄旗', '152500'); INSERT INTO sys_city VALUES ('152529', '正镶白旗', '152500'); INSERT INTO sys_city VALUES ('152530', '正蓝旗', '152500'); INSERT INTO sys_city VALUES ('152531', '多伦', '152500'); INSERT INTO sys_city VALUES ('152900', '阿拉善盟', '150000'); INSERT INTO sys_city VALUES ('152921', '阿拉善左旗', '152900'); INSERT INTO sys_city VALUES ('152922', '阿拉善右旗', '152900'); INSERT INTO sys_city VALUES ('152923', '额济纳旗', '152900'); INSERT INTO sys_city VALUES ('210000', '辽宁省', '0'); INSERT INTO sys_city VALUES ('210100', '沈阳市', '210000'); INSERT INTO sys_city VALUES ('210102', '和平区', '210100'); INSERT INTO sys_city VALUES ('210103', '沈河区', '210100'); INSERT INTO sys_city VALUES ('210104', '大东区', '210100'); INSERT INTO sys_city VALUES ('210105', '皇姑区', '210100'); INSERT INTO sys_city VALUES ('210106', '铁西区', '210100'); INSERT INTO sys_city VALUES ('210111', '苏家屯区', '210100'); INSERT INTO sys_city VALUES ('210112', '东陵区', '210100'); INSERT INTO sys_city VALUES ('210113', '沈北新区', '210100'); INSERT INTO sys_city VALUES ('210114', '于洪区', '210100'); INSERT INTO sys_city VALUES ('210122', '辽中', '210100'); INSERT INTO sys_city VALUES ('210123', '康平', '210100'); INSERT INTO sys_city VALUES ('210124', '法库', '210100'); INSERT INTO sys_city VALUES ('210181', '新民市', '210100'); INSERT INTO sys_city VALUES ('210200', '大连市', '210000'); INSERT INTO sys_city VALUES ('210202', '中山区', '210200'); INSERT INTO sys_city VALUES ('210203', '西岗区', '210200'); INSERT INTO sys_city VALUES ('210204', '沙河口区', '210200'); INSERT INTO sys_city VALUES ('210211', '甘井子区', '210200'); INSERT INTO sys_city VALUES ('210212', '旅顺口区', '210200'); INSERT INTO sys_city VALUES ('210213', '金州区', '210200'); INSERT INTO sys_city VALUES ('210224', '长海', '210200'); INSERT INTO sys_city VALUES ('210281', '瓦房店市', '210200'); INSERT INTO sys_city VALUES ('210282', '普兰店市', '210200'); INSERT INTO sys_city VALUES ('210283', '庄河市', '210200'); INSERT INTO sys_city VALUES ('210300', '鞍山市', '210000'); INSERT INTO sys_city VALUES ('210302', '铁东区', '210300'); INSERT INTO sys_city VALUES ('210303', '铁西区', '210300'); INSERT INTO sys_city VALUES ('210304', '立山区', '210300'); INSERT INTO sys_city VALUES ('210311', '千山区', '210300'); INSERT INTO sys_city VALUES ('210321', '台安', '210300'); INSERT INTO sys_city VALUES ('210323', '岫岩满族自治', '210300'); INSERT INTO sys_city VALUES ('210381', '海城市', '210300'); INSERT INTO sys_city VALUES ('210400', '抚顺市', '210000'); INSERT INTO sys_city VALUES ('210402', '新抚区', '210400'); INSERT INTO sys_city VALUES ('210403', '东洲区', '210400'); INSERT INTO sys_city VALUES ('210404', '望花区', '210400'); INSERT INTO sys_city VALUES ('210411', '顺城区', '210400'); INSERT INTO sys_city VALUES ('210421', '抚顺', '210400'); INSERT INTO sys_city VALUES ('210422', '新宾满族自治', '210400'); INSERT INTO sys_city VALUES ('210423', '清原满族自治', '210400'); INSERT INTO sys_city VALUES ('210500', '本溪市', '210000'); INSERT INTO sys_city VALUES ('210502', '平山区', '210500'); INSERT INTO sys_city VALUES ('210503', '溪湖区', '210500'); INSERT INTO sys_city VALUES ('210504', '明山区', '210500'); INSERT INTO sys_city VALUES ('210505', '南芬区', '210500'); INSERT INTO sys_city VALUES ('210521', '本溪满族自治', '210500'); INSERT INTO sys_city VALUES ('210522', '桓仁满族自治', '210500'); INSERT INTO sys_city VALUES ('210600', '丹东市', '210000'); INSERT INTO sys_city VALUES ('210602', '元宝区', '210600'); INSERT INTO sys_city VALUES ('210603', '振兴区', '210600'); INSERT INTO sys_city VALUES ('210604', '振安区', '210600'); INSERT INTO sys_city VALUES ('210624', '宽甸满族自治', '210600'); INSERT INTO sys_city VALUES ('210681', '东港市', '210600'); INSERT INTO sys_city VALUES ('210682', '凤城市', '210600'); INSERT INTO sys_city VALUES ('210700', '锦州市', '210000'); INSERT INTO sys_city VALUES ('210702', '古塔区', '210700'); INSERT INTO sys_city VALUES ('210703', '凌河区', '210700'); INSERT INTO sys_city VALUES ('210711', '太和区', '210700'); INSERT INTO sys_city VALUES ('210726', '黑山', '210700'); INSERT INTO sys_city VALUES ('210727', '义', '210700'); INSERT INTO sys_city VALUES ('210781', '凌海市', '210700'); INSERT INTO sys_city VALUES ('210782', '北镇市', '210700'); INSERT INTO sys_city VALUES ('210800', '营口市', '210000'); INSERT INTO sys_city VALUES ('210802', '站前区', '210800'); INSERT INTO sys_city VALUES ('210803', '西市区', '210800'); INSERT INTO sys_city VALUES ('210804', '鲅鱼圈区', '210800'); INSERT INTO sys_city VALUES ('210811', '老边区', '210800'); INSERT INTO sys_city VALUES ('210881', '盖州市', '210800'); INSERT INTO sys_city VALUES ('210882', '大石桥市', '210800'); INSERT INTO sys_city VALUES ('210900', '阜新市', '210000'); INSERT INTO sys_city VALUES ('210902', '海州区', '210900'); INSERT INTO sys_city VALUES ('210903', '新邱区', '210900'); INSERT INTO sys_city VALUES ('210904', '太平区', '210900'); INSERT INTO sys_city VALUES ('210905', '清河门区', '210900'); INSERT INTO sys_city VALUES ('210911', '细河区', '210900'); INSERT INTO sys_city VALUES ('210921', '阜新蒙古族自治', '210900'); INSERT INTO sys_city VALUES ('210922', '彰武', '210900'); INSERT INTO sys_city VALUES ('211000', '辽阳市', '210000'); INSERT INTO sys_city VALUES ('211002', '白塔区', '211000'); INSERT INTO sys_city VALUES ('211003', '文圣区', '211000'); INSERT INTO sys_city VALUES ('211004', '宏伟区', '211000'); INSERT INTO sys_city VALUES ('211005', '弓长岭区', '211000'); INSERT INTO sys_city VALUES ('211011', '太子河区', '211000'); INSERT INTO sys_city VALUES ('211021', '辽阳', '211000'); INSERT INTO sys_city VALUES ('211081', '灯塔市', '211000'); INSERT INTO sys_city VALUES ('211100', '盘锦市', '210000'); INSERT INTO sys_city VALUES ('211102', '双台子区', '211100'); INSERT INTO sys_city VALUES ('211103', '兴隆台区', '211100'); INSERT INTO sys_city VALUES ('211121', '大洼', '211100'); INSERT INTO sys_city VALUES ('211122', '盘山', '211100'); INSERT INTO sys_city VALUES ('211200', '铁岭市', '210000'); INSERT INTO sys_city VALUES ('211202', '银州区', '211200'); INSERT INTO sys_city VALUES ('211204', '清河区', '211200'); INSERT INTO sys_city VALUES ('211221', '铁岭', '211200'); INSERT INTO sys_city VALUES ('211223', '西丰', '211200'); INSERT INTO sys_city VALUES ('211224', '昌图', '211200'); INSERT INTO sys_city VALUES ('211281', '调兵山市', '211200'); INSERT INTO sys_city VALUES ('211282', '开原市', '211200'); INSERT INTO sys_city VALUES ('211300', '朝阳市', '210000'); INSERT INTO sys_city VALUES ('211302', '双塔区', '211300'); INSERT INTO sys_city VALUES ('211303', '龙城区', '211300'); INSERT INTO sys_city VALUES ('211321', '朝阳', '211300'); INSERT INTO sys_city VALUES ('211322', '建平', '211300'); INSERT INTO sys_city VALUES ('211324', '喀喇沁左翼蒙古族自治', '211300'); INSERT INTO sys_city VALUES ('211381', '北票市', '211300'); INSERT INTO sys_city VALUES ('211382', '凌源市', '211300'); INSERT INTO sys_city VALUES ('211400', '葫芦岛市', '210000'); INSERT INTO sys_city VALUES ('211402', '连山区', '211400'); INSERT INTO sys_city VALUES ('211403', '龙港区', '211400'); INSERT INTO sys_city VALUES ('211404', '南票区', '211400'); INSERT INTO sys_city VALUES ('211421', '绥中', '211400'); INSERT INTO sys_city VALUES ('211422', '建昌', '211400'); INSERT INTO sys_city VALUES ('211481', '兴城市', '211400'); INSERT INTO sys_city VALUES ('220000', '吉林省', '0'); INSERT INTO sys_city VALUES ('220100', '长春市', '220000'); INSERT INTO sys_city VALUES ('220102', '南关区', '220100'); INSERT INTO sys_city VALUES ('220103', '宽城区', '220100'); INSERT INTO sys_city VALUES ('220104', '朝阳区', '220100'); INSERT INTO sys_city VALUES ('220105', '二道区', '220100'); INSERT INTO sys_city VALUES ('220106', '绿园区', '220100'); INSERT INTO sys_city VALUES ('220112', '双阳区', '220100'); INSERT INTO sys_city VALUES ('220113', '九台区', '220100'); INSERT INTO sys_city VALUES ('220122', '农安', '220100'); INSERT INTO sys_city VALUES ('220182', '榆树市', '220100'); INSERT INTO sys_city VALUES ('220183', '德惠市', '220100'); INSERT INTO sys_city VALUES ('220200', '吉林市', '220000'); INSERT INTO sys_city VALUES ('220202', '昌邑区', '220200'); INSERT INTO sys_city VALUES ('220203', '龙潭区', '220200'); INSERT INTO sys_city VALUES ('220204', '船营区', '220200'); INSERT INTO sys_city VALUES ('220211', '丰满区', '220200'); INSERT INTO sys_city VALUES ('220221', '永吉', '220200'); INSERT INTO sys_city VALUES ('220281', '蛟河市', '220200'); INSERT INTO sys_city VALUES ('220282', '桦甸市', '220200'); INSERT INTO sys_city VALUES ('220283', '舒兰市', '220200'); INSERT INTO sys_city VALUES ('220284', '磐石市', '220200'); INSERT INTO sys_city VALUES ('220300', '四平市', '220000'); INSERT INTO sys_city VALUES ('220302', '铁西区', '220300'); INSERT INTO sys_city VALUES ('220303', '铁东区', '220300'); INSERT INTO sys_city VALUES ('220322', '梨树', '220300'); INSERT INTO sys_city VALUES ('220323', '伊通满族自治', '220300'); INSERT INTO sys_city VALUES ('220381', '公主岭市', '220300'); INSERT INTO sys_city VALUES ('220382', '双辽市', '220300'); INSERT INTO sys_city VALUES ('220400', '辽源市', '220000'); INSERT INTO sys_city VALUES ('220402', '龙山区', '220400'); INSERT INTO sys_city VALUES ('220403', '西安区', '220400'); INSERT INTO sys_city VALUES ('220421', '东丰', '220400'); INSERT INTO sys_city VALUES ('220422', '东辽', '220400'); INSERT INTO sys_city VALUES ('220500', '通化市', '220000'); INSERT INTO sys_city VALUES ('220502', '东昌区', '220500'); INSERT INTO sys_city VALUES ('220503', '二道江区', '220500'); INSERT INTO sys_city VALUES ('220521', '通化', '220500'); INSERT INTO sys_city VALUES ('220523', '辉南', '220500'); INSERT INTO sys_city VALUES ('220524', '柳河', '220500'); INSERT INTO sys_city VALUES ('220581', '梅河口市', '220500'); INSERT INTO sys_city VALUES ('220582', '集安市', '220500'); INSERT INTO sys_city VALUES ('220600', '白山市', '220000'); INSERT INTO sys_city VALUES ('220602', '浑江区', '220600'); INSERT INTO sys_city VALUES ('220605', '江源区', '220600'); INSERT INTO sys_city VALUES ('220621', '抚松', '220600'); INSERT INTO sys_city VALUES ('220622', '靖宇', '220600'); INSERT INTO sys_city VALUES ('220623', '长白朝鲜族自治', '220600'); INSERT INTO sys_city VALUES ('220681', '临江市', '220600'); INSERT INTO sys_city VALUES ('220700', '松原市', '220000'); INSERT INTO sys_city VALUES ('220702', '宁江区', '220700'); INSERT INTO sys_city VALUES ('220721', '前郭尔罗斯蒙古族自治', '220700'); INSERT INTO sys_city VALUES ('220722', '长岭', '220700'); INSERT INTO sys_city VALUES ('220723', '乾安', '220700'); INSERT INTO sys_city VALUES ('220781', '扶余市', '220700'); INSERT INTO sys_city VALUES ('220800', '白城市', '220000'); INSERT INTO sys_city VALUES ('220802', '洮北区', '220800'); INSERT INTO sys_city VALUES ('220821', '镇赉', '220800'); INSERT INTO sys_city VALUES ('220822', '通榆', '220800'); INSERT INTO sys_city VALUES ('220881', '洮南市', '220800'); INSERT INTO sys_city VALUES ('220882', '大安市', '220800'); INSERT INTO sys_city VALUES ('222400', '延边朝鲜族自治州', '220000'); INSERT INTO sys_city VALUES ('222401', '延吉市', '222400'); INSERT INTO sys_city VALUES ('222402', '图们市', '222400'); INSERT INTO sys_city VALUES ('222403', '敦化市', '222400'); INSERT INTO sys_city VALUES ('222404', '珲春市', '222400'); INSERT INTO sys_city VALUES ('222405', '龙井市', '222400'); INSERT INTO sys_city VALUES ('222406', '和龙市', '222400'); INSERT INTO sys_city VALUES ('222424', '汪清', '222400'); INSERT INTO sys_city VALUES ('222426', '安图', '222400'); INSERT INTO sys_city VALUES ('230000', '黑龙江省', '0'); INSERT INTO sys_city VALUES ('230100', '哈尔滨市', '230000'); INSERT INTO sys_city VALUES ('230102', '道里区', '230100'); INSERT INTO sys_city VALUES ('230103', '南岗区', '230100'); INSERT INTO sys_city VALUES ('230104', '道外区', '230100'); INSERT INTO sys_city VALUES ('230108', '平房区', '230100'); INSERT INTO sys_city VALUES ('230109', '松北区', '230100'); INSERT INTO sys_city VALUES ('230110', '香坊区', '230100'); INSERT INTO sys_city VALUES ('230111', '呼兰区', '230100'); INSERT INTO sys_city VALUES ('230112', '阿城区', '230100'); INSERT INTO sys_city VALUES ('230113', '双城区', '230100'); INSERT INTO sys_city VALUES ('230123', '依兰', '230100'); INSERT INTO sys_city VALUES ('230124', '方正', '230100'); INSERT INTO sys_city VALUES ('230125', '宾', '230100'); INSERT INTO sys_city VALUES ('230126', '巴彦', '230100'); INSERT INTO sys_city VALUES ('230127', '木兰', '230100'); INSERT INTO sys_city VALUES ('230128', '通河', '230100'); INSERT INTO sys_city VALUES ('230129', '延寿', '230100'); INSERT INTO sys_city VALUES ('230183', '尚志市', '230100'); INSERT INTO sys_city VALUES ('230184', '五常市', '230100'); INSERT INTO sys_city VALUES ('230200', '齐齐哈尔市', '230000'); INSERT INTO sys_city VALUES ('230202', '龙沙区', '230200'); INSERT INTO sys_city VALUES ('230203', '建华区', '230200'); INSERT INTO sys_city VALUES ('230204', '铁锋区', '230200'); INSERT INTO sys_city VALUES ('230205', '昂昂溪区', '230200'); INSERT INTO sys_city VALUES ('230206', '富拉尔基区', '230200'); INSERT INTO sys_city VALUES ('230207', '碾子山区', '230200'); INSERT INTO sys_city VALUES ('230208', '梅里斯达斡尔族区', '230200'); INSERT INTO sys_city VALUES ('230221', '龙江', '230200'); INSERT INTO sys_city VALUES ('230223', '依安', '230200'); INSERT INTO sys_city VALUES ('230224', '泰来', '230200'); INSERT INTO sys_city VALUES ('230225', '甘南', '230200'); INSERT INTO sys_city VALUES ('230227', '富裕', '230200'); INSERT INTO sys_city VALUES ('230229', '克山', '230200'); INSERT INTO sys_city VALUES ('230230', '克东', '230200'); INSERT INTO sys_city VALUES ('230231', '拜泉', '230200'); INSERT INTO sys_city VALUES ('230281', '讷河市', '230200'); INSERT INTO sys_city VALUES ('230300', '鸡西市', '230000'); INSERT INTO sys_city VALUES ('230302', '鸡冠区', '230300'); INSERT INTO sys_city VALUES ('230303', '恒山区', '230300'); INSERT INTO sys_city VALUES ('230304', '滴道区', '230300'); INSERT INTO sys_city VALUES ('230305', '梨树区', '230300'); INSERT INTO sys_city VALUES ('230306', '城子河区', '230300'); INSERT INTO sys_city VALUES ('230307', '麻山区', '230300'); INSERT INTO sys_city VALUES ('230321', '鸡东', '230300'); INSERT INTO sys_city VALUES ('230381', '虎林市', '230300'); INSERT INTO sys_city VALUES ('230382', '密山市', '230300'); INSERT INTO sys_city VALUES ('230400', '鹤岗市', '230000'); INSERT INTO sys_city VALUES ('230402', '向阳区', '230400'); INSERT INTO sys_city VALUES ('230403', '工农区', '230400'); INSERT INTO sys_city VALUES ('230404', '南山区', '230400'); INSERT INTO sys_city VALUES ('230405', '兴安区', '230400'); INSERT INTO sys_city VALUES ('230406', '东山区', '230400'); INSERT INTO sys_city VALUES ('230407', '兴山区', '230400'); INSERT INTO sys_city VALUES ('230421', '萝北', '230400'); INSERT INTO sys_city VALUES ('230422', '绥滨', '230400'); INSERT INTO sys_city VALUES ('230500', '双鸭山市', '230000'); INSERT INTO sys_city VALUES ('230502', '尖山区', '230500'); INSERT INTO sys_city VALUES ('230503', '岭东区', '230500'); INSERT INTO sys_city VALUES ('230505', '四方台区', '230500'); INSERT INTO sys_city VALUES ('230506', '宝山区', '230500'); INSERT INTO sys_city VALUES ('230521', '集贤', '230500'); INSERT INTO sys_city VALUES ('230522', '友谊', '230500'); INSERT INTO sys_city VALUES ('230523', '宝清', '230500'); INSERT INTO sys_city VALUES ('230524', '饶河', '230500'); INSERT INTO sys_city VALUES ('230600', '大庆市', '230000'); INSERT INTO sys_city VALUES ('230602', '萨尔图区', '230600'); INSERT INTO sys_city VALUES ('230603', '龙凤区', '230600'); INSERT INTO sys_city VALUES ('230604', '让胡路区', '230600'); INSERT INTO sys_city VALUES ('230605', '红岗区', '230600'); INSERT INTO sys_city VALUES ('230606', '大同区', '230600'); INSERT INTO sys_city VALUES ('230621', '肇州', '230600'); INSERT INTO sys_city VALUES ('230622', '肇源', '230600'); INSERT INTO sys_city VALUES ('230623', '林甸', '230600'); INSERT INTO sys_city VALUES ('230624', '杜尔伯特蒙古族自治', '230600'); INSERT INTO sys_city VALUES ('230700', '伊春市', '230000'); INSERT INTO sys_city VALUES ('230702', '伊春区', '230700'); INSERT INTO sys_city VALUES ('230703', '南岔区', '230700'); INSERT INTO sys_city VALUES ('230704', '友好区', '230700'); INSERT INTO sys_city VALUES ('230705', '西林区', '230700'); INSERT INTO sys_city VALUES ('230706', '翠峦区', '230700'); INSERT INTO sys_city VALUES ('230707', '新青区', '230700'); INSERT INTO sys_city VALUES ('230708', '美溪区', '230700'); INSERT INTO sys_city VALUES ('230709', '金山屯区', '230700'); INSERT INTO sys_city VALUES ('230710', '五营区', '230700'); INSERT INTO sys_city VALUES ('230711', '乌马河区', '230700'); INSERT INTO sys_city VALUES ('230712', '汤旺河区', '230700'); INSERT INTO sys_city VALUES ('230713', '带岭区', '230700'); INSERT INTO sys_city VALUES ('230714', '乌伊岭区', '230700'); INSERT INTO sys_city VALUES ('230715', '红星区', '230700'); INSERT INTO sys_city VALUES ('230716', '上甘岭区', '230700'); INSERT INTO sys_city VALUES ('230722', '嘉荫', '230700'); INSERT INTO sys_city VALUES ('230781', '铁力市', '230700'); INSERT INTO sys_city VALUES ('230800', '佳木斯市', '230000'); INSERT INTO sys_city VALUES ('230803', '向阳区', '230800'); INSERT INTO sys_city VALUES ('230804', '前进区', '230800'); INSERT INTO sys_city VALUES ('230805', '东风区', '230800'); INSERT INTO sys_city VALUES ('230811', '郊区', '230800'); INSERT INTO sys_city VALUES ('230822', '桦南', '230800'); INSERT INTO sys_city VALUES ('230826', '桦川', '230800'); INSERT INTO sys_city VALUES ('230828', '汤原', '230800'); INSERT INTO sys_city VALUES ('230833', '抚远', '230800'); INSERT INTO sys_city VALUES ('230881', '同江市', '230800'); INSERT INTO sys_city VALUES ('230882', '富锦市', '230800'); INSERT INTO sys_city VALUES ('230900', '七台河市', '230000'); INSERT INTO sys_city VALUES ('230902', '新兴区', '230900'); INSERT INTO sys_city VALUES ('230903', '桃山区', '230900'); INSERT INTO sys_city VALUES ('230904', '茄子河区', '230900'); INSERT INTO sys_city VALUES ('230921', '勃利', '230900'); INSERT INTO sys_city VALUES ('231000', '牡丹江市', '230000'); INSERT INTO sys_city VALUES ('231002', '东安区', '231000'); INSERT INTO sys_city VALUES ('231003', '阳明区', '231000'); INSERT INTO sys_city VALUES ('231004', '爱民区', '231000'); INSERT INTO sys_city VALUES ('231005', '西安区', '231000'); INSERT INTO sys_city VALUES ('231024', '东宁', '231000'); INSERT INTO sys_city VALUES ('231025', '林口', '231000'); INSERT INTO sys_city VALUES ('231081', '绥芬河市', '231000'); INSERT INTO sys_city VALUES ('231083', '海林市', '231000'); INSERT INTO sys_city VALUES ('231084', '宁安市', '231000'); INSERT INTO sys_city VALUES ('231085', '穆棱市', '231000'); INSERT INTO sys_city VALUES ('231100', '黑河市', '230000'); INSERT INTO sys_city VALUES ('231102', '爱辉区', '231100'); INSERT INTO sys_city VALUES ('231121', '嫩江', '231100'); INSERT INTO sys_city VALUES ('231123', '逊克', '231100'); INSERT INTO sys_city VALUES ('231124', '孙吴', '231100'); INSERT INTO sys_city VALUES ('231181', '北安市', '231100'); INSERT INTO sys_city VALUES ('231182', '五大连池市', '231100'); INSERT INTO sys_city VALUES ('231200', '绥化市', '230000'); INSERT INTO sys_city VALUES ('231202', '北林区', '231200'); INSERT INTO sys_city VALUES ('231221', '望奎', '231200'); INSERT INTO sys_city VALUES ('231222', '兰西', '231200'); INSERT INTO sys_city VALUES ('231223', '青冈', '231200'); INSERT INTO sys_city VALUES ('231224', '庆安', '231200'); INSERT INTO sys_city VALUES ('231225', '明水', '231200'); INSERT INTO sys_city VALUES ('231226', '绥棱', '231200'); INSERT INTO sys_city VALUES ('231281', '安达市', '231200'); INSERT INTO sys_city VALUES ('231282', '肇东市', '231200'); INSERT INTO sys_city VALUES ('231283', '海伦市', '231200'); INSERT INTO sys_city VALUES ('232700', '大兴安岭地区', '230000'); INSERT INTO sys_city VALUES ('232721', '呼玛', '232700'); INSERT INTO sys_city VALUES ('232722', '塔河', '232700'); INSERT INTO sys_city VALUES ('232723', '漠河', '232700'); INSERT INTO sys_city VALUES ('310000', '上海市', '0'); INSERT INTO sys_city VALUES ('310101', '黄浦区', '310100'); INSERT INTO sys_city VALUES ('310104', '徐汇区', '310100'); INSERT INTO sys_city VALUES ('310105', '长宁区', '310100'); INSERT INTO sys_city VALUES ('310106', '静安区', '310100'); INSERT INTO sys_city VALUES ('310107', '普陀区', '310100'); INSERT INTO sys_city VALUES ('310108', '闸北区', '310100'); INSERT INTO sys_city VALUES ('310109', '虹口区', '310100'); INSERT INTO sys_city VALUES ('310110', '杨浦区', '310100'); INSERT INTO sys_city VALUES ('310112', '闵行区', '310100'); INSERT INTO sys_city VALUES ('310113', '宝山区', '310100'); INSERT INTO sys_city VALUES ('310114', '嘉定区', '310100'); INSERT INTO sys_city VALUES ('310115', '浦东新区', '310100'); INSERT INTO sys_city VALUES ('310116', '金山区', '310100'); INSERT INTO sys_city VALUES ('310117', '松江区', '310100'); INSERT INTO sys_city VALUES ('310118', '青浦区', '310100'); INSERT INTO sys_city VALUES ('310120', '奉贤区', '310100'); INSERT INTO sys_city VALUES ('310230', '崇明', '310200'); INSERT INTO sys_city VALUES ('320000', '江苏省', '0'); INSERT INTO sys_city VALUES ('320100', '南京市', '320000'); INSERT INTO sys_city VALUES ('320102', '玄武区', '320100'); INSERT INTO sys_city VALUES ('320104', '秦淮区', '320100'); INSERT INTO sys_city VALUES ('320105', '建邺区', '320100'); INSERT INTO sys_city VALUES ('320106', '鼓楼区', '320100'); INSERT INTO sys_city VALUES ('320111', '浦口区', '320100'); INSERT INTO sys_city VALUES ('320113', '栖霞区', '320100'); INSERT INTO sys_city VALUES ('320114', '雨花台区', '320100'); INSERT INTO sys_city VALUES ('320115', '江宁区', '320100'); INSERT INTO sys_city VALUES ('320116', '六合区', '320100'); INSERT INTO sys_city VALUES ('320117', '溧水区', '320100'); INSERT INTO sys_city VALUES ('320118', '高淳区', '320100'); INSERT INTO sys_city VALUES ('320200', '无锡市', '320000'); INSERT INTO sys_city VALUES ('320202', '崇安区', '320200'); INSERT INTO sys_city VALUES ('320203', '南长区', '320200'); INSERT INTO sys_city VALUES ('320204', '北塘区', '320200'); INSERT INTO sys_city VALUES ('320205', '锡山区', '320200'); INSERT INTO sys_city VALUES ('320206', '惠山区', '320200'); INSERT INTO sys_city VALUES ('320211', '滨湖区', '320200'); INSERT INTO sys_city VALUES ('320281', '江阴市', '320200'); INSERT INTO sys_city VALUES ('320282', '宜兴市', '320200'); INSERT INTO sys_city VALUES ('320300', '徐州市', '320000'); INSERT INTO sys_city VALUES ('320302', '鼓楼区', '320300'); INSERT INTO sys_city VALUES ('320303', '云龙区', '320300'); INSERT INTO sys_city VALUES ('320305', '贾汪区', '320300'); INSERT INTO sys_city VALUES ('320311', '泉山区', '320300'); INSERT INTO sys_city VALUES ('320312', '铜山区', '320300'); INSERT INTO sys_city VALUES ('320321', '丰', '320300'); INSERT INTO sys_city VALUES ('320322', '沛', '320300'); INSERT INTO sys_city VALUES ('320324', '睢宁', '320300'); INSERT INTO sys_city VALUES ('320381', '新沂市', '320300'); INSERT INTO sys_city VALUES ('320382', '邳州市', '320300'); INSERT INTO sys_city VALUES ('320400', '常州市', '320000'); INSERT INTO sys_city VALUES ('320402', '天宁区', '320400'); INSERT INTO sys_city VALUES ('320404', '钟楼区', '320400'); INSERT INTO sys_city VALUES ('320411', '新北区', '320400'); INSERT INTO sys_city VALUES ('320412', '武进区', '320400'); INSERT INTO sys_city VALUES ('320413', '金坛区', '320400'); INSERT INTO sys_city VALUES ('320481', '溧阳市', '320400'); INSERT INTO sys_city VALUES ('320500', '苏州市', '320000'); INSERT INTO sys_city VALUES ('320505', '虎丘区', '320500'); INSERT INTO sys_city VALUES ('320506', '吴中区', '320500'); INSERT INTO sys_city VALUES ('320507', '相城区', '320500'); INSERT INTO sys_city VALUES ('320508', '姑苏区', '320500'); INSERT INTO sys_city VALUES ('320509', '吴江区', '320500'); INSERT INTO sys_city VALUES ('320581', '常熟市', '320500'); INSERT INTO sys_city VALUES ('320582', '张家港市', '320500'); INSERT INTO sys_city VALUES ('320583', '昆山市', '320500'); INSERT INTO sys_city VALUES ('320585', '太仓市', '320500'); INSERT INTO sys_city VALUES ('320600', '南通市', '320000'); INSERT INTO sys_city VALUES ('320602', '崇川区', '320600'); INSERT INTO sys_city VALUES ('320611', '港闸区', '320600'); INSERT INTO sys_city VALUES ('320612', '通州区', '320600'); INSERT INTO sys_city VALUES ('320621', '海安', '320600'); INSERT INTO sys_city VALUES ('320623', '如东', '320600'); INSERT INTO sys_city VALUES ('320681', '启东市', '320600'); INSERT INTO sys_city VALUES ('320682', '如皋市', '320600'); INSERT INTO sys_city VALUES ('320684', '海门市', '320600'); INSERT INTO sys_city VALUES ('320700', '连云港市', '320000'); INSERT INTO sys_city VALUES ('320703', '连云区', '320700'); INSERT INTO sys_city VALUES ('320706', '海州区', '320700'); INSERT INTO sys_city VALUES ('320707', '赣榆区', '320700'); INSERT INTO sys_city VALUES ('320722', '东海', '320700'); INSERT INTO sys_city VALUES ('320723', '灌云', '320700'); INSERT INTO sys_city VALUES ('320724', '灌南', '320700'); INSERT INTO sys_city VALUES ('320800', '淮安市', '320000'); INSERT INTO sys_city VALUES ('320802', '清河区', '320800'); INSERT INTO sys_city VALUES ('320803', '淮安区', '320800'); INSERT INTO sys_city VALUES ('320804', '淮阴区', '320800'); INSERT INTO sys_city VALUES ('320811', '清浦区', '320800'); INSERT INTO sys_city VALUES ('320826', '涟水', '320800'); INSERT INTO sys_city VALUES ('320829', '洪泽', '320800'); INSERT INTO sys_city VALUES ('320830', '盱眙', '320800'); INSERT INTO sys_city VALUES ('320831', '金湖', '320800'); INSERT INTO sys_city VALUES ('320900', '盐城市', '320000'); INSERT INTO sys_city VALUES ('320902', '亭湖区', '320900'); INSERT INTO sys_city VALUES ('320903', '盐都区', '320900'); INSERT INTO sys_city VALUES ('320904', '大丰区', '320900'); INSERT INTO sys_city VALUES ('320921', '响水', '320900'); INSERT INTO sys_city VALUES ('320922', '滨海', '320900'); INSERT INTO sys_city VALUES ('320923', '阜宁', '320900'); INSERT INTO sys_city VALUES ('320924', '射阳', '320900'); INSERT INTO sys_city VALUES ('320925', '建湖', '320900'); INSERT INTO sys_city VALUES ('320981', '东台市', '320900'); INSERT INTO sys_city VALUES ('321000', '扬州市', '320000'); INSERT INTO sys_city VALUES ('321002', '广陵区', '321000'); INSERT INTO sys_city VALUES ('321003', '邗江区', '321000'); INSERT INTO sys_city VALUES ('321012', '江都区', '321000'); INSERT INTO sys_city VALUES ('321023', '宝应', '321000'); INSERT INTO sys_city VALUES ('321081', '仪征市', '321000'); INSERT INTO sys_city VALUES ('321084', '高邮市', '321000'); INSERT INTO sys_city VALUES ('321100', '镇江市', '320000'); INSERT INTO sys_city VALUES ('321102', '京口区', '321100'); INSERT INTO sys_city VALUES ('321111', '润州区', '321100'); INSERT INTO sys_city VALUES ('321112', '丹徒区', '321100'); INSERT INTO sys_city VALUES ('321181', '丹阳市', '321100'); INSERT INTO sys_city VALUES ('321182', '扬中市', '321100'); INSERT INTO sys_city VALUES ('321183', '句容市', '321100'); INSERT INTO sys_city VALUES ('321200', '泰州市', '320000'); INSERT INTO sys_city VALUES ('321202', '海陵区', '321200'); INSERT INTO sys_city VALUES ('321203', '高港区', '321200'); INSERT INTO sys_city VALUES ('321204', '姜堰区', '321200'); INSERT INTO sys_city VALUES ('321281', '兴化市', '321200'); INSERT INTO sys_city VALUES ('321282', '靖江市', '321200'); INSERT INTO sys_city VALUES ('321283', '泰兴市', '321200'); INSERT INTO sys_city VALUES ('321300', '宿迁市', '320000'); INSERT INTO sys_city VALUES ('321302', '宿城区', '321300'); INSERT INTO sys_city VALUES ('321311', '宿豫区', '321300'); INSERT INTO sys_city VALUES ('321322', '沭阳', '321300'); INSERT INTO sys_city VALUES ('321323', '泗阳', '321300'); INSERT INTO sys_city VALUES ('321324', '泗洪', '321300'); INSERT INTO sys_city VALUES ('330000', '浙江省', '0'); INSERT INTO sys_city VALUES ('330100', '杭州市', '330000'); INSERT INTO sys_city VALUES ('330102', '上城区', '330100'); INSERT INTO sys_city VALUES ('330103', '下城区', '330100'); INSERT INTO sys_city VALUES ('330104', '江干区', '330100'); INSERT INTO sys_city VALUES ('330105', '拱墅区', '330100'); INSERT INTO sys_city VALUES ('330106', '西湖区', '330100'); INSERT INTO sys_city VALUES ('330108', '滨江区', '330100'); INSERT INTO sys_city VALUES ('330109', '萧山区', '330100'); INSERT INTO sys_city VALUES ('330110', '余杭区', '330100'); INSERT INTO sys_city VALUES ('330111', '富阳区', '330100'); INSERT INTO sys_city VALUES ('330122', '桐庐', '330100'); INSERT INTO sys_city VALUES ('330127', '淳安', '330100'); INSERT INTO sys_city VALUES ('330182', '建德市', '330100'); INSERT INTO sys_city VALUES ('330185', '临安市', '330100'); INSERT INTO sys_city VALUES ('330200', '宁波市', '330000'); INSERT INTO sys_city VALUES ('330203', '海曙区', '330200'); INSERT INTO sys_city VALUES ('330204', '江东区', '330200'); INSERT INTO sys_city VALUES ('330205', '江北区', '330200'); INSERT INTO sys_city VALUES ('330206', '北仑区', '330200'); INSERT INTO sys_city VALUES ('330211', '镇海区', '330200'); INSERT INTO sys_city VALUES ('330212', '鄞州区', '330200'); INSERT INTO sys_city VALUES ('330225', '象山', '330200'); INSERT INTO sys_city VALUES ('330226', '宁海', '330200'); INSERT INTO sys_city VALUES ('330281', '余姚市', '330200'); INSERT INTO sys_city VALUES ('330282', '慈溪市', '330200'); INSERT INTO sys_city VALUES ('330283', '奉化市', '330200'); INSERT INTO sys_city VALUES ('330300', '温州市', '330000'); INSERT INTO sys_city VALUES ('330302', '鹿城区', '330300'); INSERT INTO sys_city VALUES ('330303', '龙湾区', '330300'); INSERT INTO sys_city VALUES ('330304', '瓯海区', '330300'); INSERT INTO sys_city VALUES ('330305', '洞头区', '330300'); INSERT INTO sys_city VALUES ('330324', '永嘉', '330300'); INSERT INTO sys_city VALUES ('330326', '平阳', '330300'); INSERT INTO sys_city VALUES ('330327', '苍南', '330300'); INSERT INTO sys_city VALUES ('330328', '文成', '330300'); INSERT INTO sys_city VALUES ('330329', '泰顺', '330300'); INSERT INTO sys_city VALUES ('330381', '瑞安市', '330300'); INSERT INTO sys_city VALUES ('330382', '乐清市', '330300'); INSERT INTO sys_city VALUES ('330400', '嘉兴市', '330000'); INSERT INTO sys_city VALUES ('330402', '南湖区', '330400'); INSERT INTO sys_city VALUES ('330411', '秀洲区', '330400'); INSERT INTO sys_city VALUES ('330421', '嘉善', '330400'); INSERT INTO sys_city VALUES ('330424', '海盐', '330400'); INSERT INTO sys_city VALUES ('330481', '海宁市', '330400'); INSERT INTO sys_city VALUES ('330482', '平湖市', '330400'); INSERT INTO sys_city VALUES ('330483', '桐乡市', '330400'); INSERT INTO sys_city VALUES ('330500', '湖州市', '330000'); INSERT INTO sys_city VALUES ('330502', '吴兴区', '330500'); INSERT INTO sys_city VALUES ('330503', '南浔区', '330500'); INSERT INTO sys_city VALUES ('330521', '德清', '330500'); INSERT INTO sys_city VALUES ('330522', '长兴', '330500'); INSERT INTO sys_city VALUES ('330523', '安吉', '330500'); INSERT INTO sys_city VALUES ('330600', '绍兴市', '330000'); INSERT INTO sys_city VALUES ('330602', '越城区', '330600'); INSERT INTO sys_city VALUES ('330603', '柯桥区', '330600'); INSERT INTO sys_city VALUES ('330604', '上虞区', '330600'); INSERT INTO sys_city VALUES ('330624', '新昌', '330600'); INSERT INTO sys_city VALUES ('330681', '诸暨市', '330600'); INSERT INTO sys_city VALUES ('330683', '嵊州市', '330600'); INSERT INTO sys_city VALUES ('330700', '金华市', '330000'); INSERT INTO sys_city VALUES ('330702', '婺城区', '330700'); INSERT INTO sys_city VALUES ('330703', '金东区', '330700'); INSERT INTO sys_city VALUES ('330723', '武义', '330700'); INSERT INTO sys_city VALUES ('330726', '浦江', '330700'); INSERT INTO sys_city VALUES ('330727', '磐安', '330700'); INSERT INTO sys_city VALUES ('330781', '兰溪市', '330700'); INSERT INTO sys_city VALUES ('330782', '义乌市', '330700'); INSERT INTO sys_city VALUES ('330783', '东阳市', '330700'); INSERT INTO sys_city VALUES ('330784', '永康市', '330700'); INSERT INTO sys_city VALUES ('330800', '衢州市', '330000'); INSERT INTO sys_city VALUES ('330802', '柯城区', '330800'); INSERT INTO sys_city VALUES ('330803', '衢江区', '330800'); INSERT INTO sys_city VALUES ('330822', '常山', '330800'); INSERT INTO sys_city VALUES ('330824', '开化', '330800'); INSERT INTO sys_city VALUES ('330825', '龙游', '330800'); INSERT INTO sys_city VALUES ('330881', '江山市', '330800'); INSERT INTO sys_city VALUES ('330900', '舟山市', '330000'); INSERT INTO sys_city VALUES ('330902', '定海区', '330900'); INSERT INTO sys_city VALUES ('330903', '普陀区', '330900'); INSERT INTO sys_city VALUES ('330921', '岱山', '330900'); INSERT INTO sys_city VALUES ('330922', '嵊泗', '330900'); INSERT INTO sys_city VALUES ('331000', '台州市', '330000'); INSERT INTO sys_city VALUES ('331002', '椒江区', '331000'); INSERT INTO sys_city VALUES ('331003', '黄岩区', '331000'); INSERT INTO sys_city VALUES ('331004', '路桥区', '331000'); INSERT INTO sys_city VALUES ('331021', '玉环', '331000'); INSERT INTO sys_city VALUES ('331022', '三门', '331000'); INSERT INTO sys_city VALUES ('331023', '天台', '331000'); INSERT INTO sys_city VALUES ('331024', '仙居', '331000'); INSERT INTO sys_city VALUES ('331081', '温岭市', '331000'); INSERT INTO sys_city VALUES ('331082', '临海市', '331000'); INSERT INTO sys_city VALUES ('331100', '丽水市', '330000'); INSERT INTO sys_city VALUES ('331102', '莲都区', '331100'); INSERT INTO sys_city VALUES ('331121', '青田', '331100'); INSERT INTO sys_city VALUES ('331122', '缙云', '331100'); INSERT INTO sys_city VALUES ('331123', '遂昌', '331100'); INSERT INTO sys_city VALUES ('331124', '松阳', '331100'); INSERT INTO sys_city VALUES ('331125', '云和', '331100'); INSERT INTO sys_city VALUES ('331126', '庆元', '331100'); INSERT INTO sys_city VALUES ('331127', '景宁畲族自治', '331100'); INSERT INTO sys_city VALUES ('331181', '龙泉市', '331100'); INSERT INTO sys_city VALUES ('340000', '安徽省', '0'); INSERT INTO sys_city VALUES ('340100', '合肥市', '340000'); INSERT INTO sys_city VALUES ('340102', '瑶海区', '340100'); INSERT INTO sys_city VALUES ('340103', '庐阳区', '340100'); INSERT INTO sys_city

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

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

余额充值