使用本轮子插件lombok（实体类data），mybatis-plus（查询单list），Vue ElementUI，测试轮正常，可直接使用，收集三联支持
/** * 统一地区库 */ @Data @EqualsAndHashCode(callSuper = false) public class BaseArea implements Serializable { private static final long serialVersionUID = 1L; /** * 地址ID */ @JsonProperty("value") private Integer baseAreaid; /** * 地区名字 */ @JsonProperty("label") private String name; /** * 上级路径ID */ private Integer parentid; @TableField(exist = false) private List<BaseArea> children; } @Service public class BaseAreaServiceImpl implements BaseAreaService { @Autowired private BaseAreaDao baseAreaDao;//采用mybatis-plus @Override public CommonResult findAll() { List<BaseArea> baseAreas = baseAreaDao.selectList(null); List<BaseArea> provinces=new ArrayList<>(); //1.省级查询 for (BaseArea baseArea:baseAreas){ if(baseArea.getParentid()==0){ provinces.add(baseArea); } } //2.查询相应的子菜单 for(BaseArea baseArea:provinces){ List<BaseArea> children = findChildren(baseAreas, baseArea.getBaseAreaid()); if(children.size()>0) { baseArea.setChildren(children); } } return new CommonResult(200,"查询成功",provinces); } public List<BaseArea> findChildren(List<BaseArea> list,Integer pid){ List<BaseArea> children=new ArrayList<>(); for(BaseArea baseArea:list){ if(baseArea.getParentid().equals(pid)){ children.add(baseArea); } } for(BaseArea baseArea:children){ List<BaseArea> children1 = findChildren(list, baseArea.getBaseAreaid()); if(children1.size()>0) { baseArea.setChildren(children1); } } return children; } }<el-form-item> 门店地区: <el-cascader v-model="value" :options="options" @change="handleChange5"></el-cascader> </el-form-item> data(){ value:[], //格式 options:[] //后端传输的数据 }, methods{ handleChange5(value) { console.log(value) }, //获取城市 需要被调用 mycity(){ var that=this this.$http.get("http://localhost:8085/rent/area/list").then(resp => { if (resp.data.code == 2000) { that.options=resp.data.data } }) }, }-- ---------------------------- -- Table structure for base_area -- ---------------------------- DROP TABLE IF EXISTS `base_area`; CREATE TABLE `base_area` ( `base_areaid` mediumint(8) UNSIGNED NOT NULL COMMENT '地址ID', `name` varchar(50) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL DEFAULT '' COMMENT 地区名称， `parentid` mediumint(8) UNSIGNED NOT NULL DEFAULT 0 COMMENT '上级路径ID', `vieworder` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT '顺序', INDEX `idx_name`(`name`) USING BTREE, INDEX `idx_parentid_vieworder`(`parentid`, `vieworder`) USING BTREE ) ENGINE = MyISAM AUTO_INCREMENT = 820792 CHARACTER SET = gbk COLLATE = gbk_chinese_ci COMMENT = 统一区域库 ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of base_area -- ---------------------------- INSERT INTO `base_area` VALUES (110000, '北京', 0, 1); INSERT INTO `base_area` VALUES (310000, '上海', 0, 2); INSERT INTO `base_area` VALUES (440000, '广东', 0, 3); INSERT INTO `base_area` VALUES (340000, '安徽', 0, 4); INSERT INTO `base_area` VALUES (500000, '重庆', 0, 5); INSERT INTO `base_area` VALUES (350000, '福建', 0, 6); INSERT INTO `base_area` VALUES (460000, '海南', 0, 7); INSERT INTO `base_area` VALUES (130000, '河北', 0, 8); INSERT INTO `base_area` VALUES (410000, '河南', 0, 9); INSERT INTO `base_area` VALUES (230000, 黑龙江， 0, 10); INSERT INTO `base_area` VALUES (420000, '湖北', 0, 11); INSERT INTO `base_area` VALUES (430000, '湖南', 0, 12); INSERT INTO `base_area` VALUES (620000, '甘肃', 0, 13); INSERT INTO `base_area` VALUES (450000, '广西', 0, 14); INSERT INTO `base_area` VALUES (520000, '贵州', 0, 15); INSERT INTO `base_area` VALUES (220000, '吉林', 0, 16); INSERT INTO `base_area` VALUES (360000, '江西', 0, 17); INSERT INTO `base_area` VALUES (320000, '江苏', 0, 18); INSERT INTO `base_area` VALUES (210000, '辽宁', 0, 19); INSERT INTO `base_area` VALUES (150000, 内蒙古， 0, 20); INSERT INTO `base_area` VALUES (640000, '宁夏', 0, 21); INSERT INTO `base_area` VALUES (630000, '青海', 0, 22); INSET INTO `base_area` VALUES (370000, '山东', 0, 23);
INSERT INTO `base_area` VALUES (140000, '山西', 0, 24);
INSERT INTO `base_area` VALUES (610000, '陕西', 0, 25);
INSERT INTO `base_area` VALUES (510000, '四川', 0, 26);
INSERT INTO `base_area` VALUES (120000, '天津', 0, 27);
INSERT INTO `base_area` VALUES (540000, '西藏', 0, 28);
INSERT INTO `base_area` VALUES (650000, '新疆', 0, 29);
INSERT INTO `base_area` VALUES (530000, '云南', 0, 30);
INSERT INTO `base_area` VALUES (330000, '浙江', 0, 31);
INSERT INTO `base_area` VALUES (710000, '台湾', 0, 32);
INSERT INTO `base_area` VALUES (810000, '香港', 0, 33);
INSERT INTO `base_area` VALUES (820000, '澳门', 0, 34);
INSERT INTO `base_area` VALUES (112900, '延庆', 110000, 18);
INSERT INTO `base_area` VALUES (112800, '密云', 110000, 17);
INSERT INTO `base_area` VALUES (112700, '怀柔', 110000, 16);
INSERT INTO `base_area` VALUES (112600, '平谷', 110000, 15);
INSERT INTO `base_area` VALUES (112400, '大兴', 110000, 14);
INSERT INTO `base_area` VALUES (112100, '昌平', 110000, 13);
INSERT INTO `base_area` VALUES (111300, '顺义', 110000, 12);
INSERT INTO `base_area` VALUES (111200, '通州', 110000, 11);
INSERT INTO `base_area` VALUES (111100, '房山', 110000, 10);
INSERT INTO `base_area` VALUES (110900, '门头沟', 110000, 9);
INSERT INTO `base_area` VALUES (110800, '海淀', 110000, 8);
INSERT INTO `base_area` VALUES (110700, '石景山', 110000, 7);
INSERT INTO `base_area` VALUES (110600, '丰台', 110000, 6);
INSERT INTO `base_area` VALUES (110500, '朝阳', 110000, 5);
INSERT INTO `base_area` VALUES (110400, '宣武', 110000, 4);
INSERT INTO `base_area` VALUES (110300, '崇文', 110000, 3);
INSERT INTO `base_area` VALUES (110200, '西城', 110000, 2);
INSERT INTO `base_area` VALUES (110100, '东城', 110000, 1);
INSERT INTO `base_area` VALUES (120100, '和平', 120000, 1);
INSERT INTO `base_area` VALUES (120200, '河东', 120000, 2);
INSERT INTO `base_area` VALUES (120300, '河西', 120000, 3);
INSERT INTO `base_area` VALUES (120400, '南开', 120000, 4);
INSERT INTO `base_area` VALUES (120500, '河北', 120000, 5);
INSERT INTO `base_area` VALUES (120600, '红桥', 120000, 6);
INSERT INTO `base_area` VALUES (120700, '滨海新区', 120000, 7);
INSERT INTO `base_area` VALUES (121000, '东丽', 120000, 8);
INSERT INTO `base_area` VALUES (121100, '西青', 120000, 9);
INSERT INTO `base_area` VALUES (121200, '津南', 120000, 10);
INSERT INTO `base_area` VALUES (121300, '北辰', 120000, 11);
INSERT INTO `base_area` VALUES (122100, '宁河', 120000, 12);
INSERT INTO `base_area` VALUES (122200, '武清', 120000, 13);
INSERT INTO `base_area` VALUES (122300, '静海', 120000, 14);
INSERT INTO `base_area` VALUES (122400, '宝坻', 120000, 15);
INSERT INTO `base_area` VALUES (122500, '蓟县', 120000, 16);
INSERT INTO `base_area` VALUES (130100, '石家庄', 130000, 1);
INSERT INTO `base_area` VALUES (130200, '唐山', 130000, 2);
INSERT INTO `base_area` VALUES (130300, '秦皇岛', 130000, 3);
INSERT INTO `base_area` VALUES (130400, '邯郸', 130000, 4);
INSERT INTO `base_area` VALUES (130500, '邢台', 130000, 5);
INSERT INTO `base_area` VALUES (130600, '保定', 130000, 6);
INSERT INTO `base_area` VALUES (130700, '张家口', 130000, 7);
INSERT INTO `base_area` VALUES (130800, '承德', 130000, 8);
INSERT INTO `base_area` VALUES (130900, '沧州', 130000, 9);
INSERT INTO `base_area` VALUES (131000, '廊坊', 130000, 10);
INSERT INTO `base_area` VALUES (131100, '衡水', 130000, 11);
INSERT INTO `base_area` VALUES (140100, '太原', 140000, 1);
INSERT INTO `base_area` VALUES (140200, '大同', 140000, 2);
INSERT INTO `base_area` VALUES (140300, '阳泉', 140000, 3);
INSERT INTO `base_area` VALUES (140400, '长治', 140000, 4);
INSERT INTO `base_area` VALUES (140500, '晋城', 140000, 5);
INSERT INTO `base_area` VALUES (140600, '朔州', 140000, 6);
INSERT INTO `base_area` VALUES (140700, '晋中', 140000, 7);
INSERT INTO `base_area` VALUES (140800, '运城', 140000, 8);
INSERT INTO `base_area` VALUES (140900, '忻州', 140000, 9);
INSERT INTO `base_area` VALUES (141000, '临汾', 140000, 10);
INSERT INTO `base_area` VALUES (141100, '吕梁', 140000, 11);
INSERT INTO `base_area` VALUES (150100, '呼和浩特', 150000, 1);
INSERT INTO `base_area` VALUES (150200, '包头', 150000, 2);
INSERT INTO `base_area` VALUES (150300, '乌海', 150000, 3);
INSERT INTO `base_area` VALUES (150400, '赤峰', 150000, 4);
INSERT INTO `base_area` VALUES (150500, '通辽', 150000, 5);
INSERT INTO `base_area` VALUES (150600, '鄂尔多斯', 150000, 6);
INSERT INTO `base_area` VALUES (150700, '呼伦贝尔', 150000, 7);
INSERT INTO `base_area` VALUES (150800, '巴彦淖尔', 150000, 8);
INSERT INTO `base_area` VALUES (150900, '乌兰察布', 150000, 9);
INSERT INTO `base_area` VALUES (152200, '兴安', 150000, 10);
INSERT INTO `base_area` VALUES (152500, '锡林郭勒', 150000, 11);
INSERT INTO `base_area` VALUES (152900, '阿拉善', 150000, 12);
INSERT INTO `base_area` VALUES (210100, '沈阳', 210000, 1);
INSERT INTO `base_area` VALUES (210200, '大连', 210000, 2);
INSERT INTO `base_area` VALUES (210300, '鞍山', 210000, 3);
INSERT INTO `base_area` VALUES (210400, '抚顺', 210000, 4);
INSERT INTO `base_area` VALUES (210500, '本溪', 210000, 5);
INSERT INTO `base_area` VALUES (210600, '丹东', 210000, 6);
INSERT INTO `base_area` VALUES (210700, '锦州', 210000, 7);
INSERT INTO `base_area` VALUES (210800, '营口', 210000, 8);
INSERT INTO `base_area` VALUES (210900, '阜新', 210000, 9);
INSERT INTO `base_area` VALUES (211000, '辽阳', 210000, 10);
INSERT INTO `base_area` VALUES (211100, '盘锦', 210000, 11);
INSERT INTO `base_area` VALUES (211200, '铁岭', 210000, 12);
INSERT INTO `base_area` VALUES (211300, '朝阳', 210000, 13);
INSERT INTO `base_area` VALUES (211400, '葫芦岛', 210000, 14);
INSERT INTO `base_area` VALUES (220100, '长春', 220000, 1);
INSERT INTO `base_area` VALUES (220200, '吉林', 220000, 2);
INSERT INTO `base_area` VALUES (220300, '四平', 220000, 3);
INSERT INTO `base_area` VALUES (220400, '辽源', 220000, 4);
INSERT INTO `base_area` VALUES (220500, '通化', 220000, 5);
INSERT INTO `base_area` VALUES (220600, '白山', 220000, 6);
INSERT INTO `base_area` VALUES (220700, '松原', 220000, 7);
INSERT INTO `base_area` VALUES (220800, '白城', 220000, 8);
INSERT INTO `base_area` VALUES (222400, '延边', 220000, 9);
INSERT INTO `base_area` VALUES (230100, '哈尔滨', 230000, 1);
INSERT INTO `base_area` VALUES (230200, '齐齐哈尔', 230000, 2);
INSERT INTO `base_area` VALUES (230300, '鸡西', 230000, 3);
INSERT INTO `base_area` VALUES (230400, '鹤岗', 230000, 4);
INSERT INTO `base_area` VALUES (230500, '双鸭山', 230000, 5);
INSERT INTO `base_area` VALUES (230600, '大庆', 230000, 6);
INSERT INTO `base_area` VALUES (230700, '伊春', 230000, 7);
INSERT INTO `base_area` VALUES (230800, '佳木斯', 230000, 8);
INSERT INTO `base_area` VALUES (230900, '七台河', 230000, 9);
INSERT INTO `base_area` VALUES (231000, '牡丹江', 230000, 10);
INSERT INTO `base_area` VALUES (231100, '黑河', 230000, 11);
INSERT INTO `base_area` VALUES (231200, '绥化', 230000, 12);
INSERT INTO `base_area` VALUES (232700, '大兴安岭', 230000, 13);
INSERT INTO `base_area` VALUES (310100, '黄浦', 310000, 1);
INSERT INTO `base_area` VALUES (310300, '卢湾', 310000, 2);
INSERT INTO `base_area` VALUES (310400, '徐汇', 310000, 3);
INSERT INTO `base_area` VALUES (310500, '长宁', 310000, 4);
INSERT INTO `base_area` VALUES (310600, '静安', 310000, 5);
INSERT INTO `base_area` VALUES (310700, '普陀', 310000, 6);
INSERT INTO `base_area` VALUES (310800, '闸北', 310000, 7);
INSERT INTO `base_area` VALUES (310900, '虹口', 310000, 8);
INSERT INTO `base_area` VALUES (311000, '杨浦', 310000, 9);
INSERT INTO `base_area` VALUES (311200, '闵行', 310000, 10);
INSERT INTO `base_area` VALUES (311300, '宝山', 310000, 11);
INSERT INTO `base_area` VALUES (311400, '嘉定', 310000, 12);
INSERT INTO `base_area` VALUES (311500, '浦东新区', 310000, 13);
INSERT INTO `base_area` VALUES (311600, '金山', 310000, 14);
INSERT INTO `base_area` VALUES (311700, '松江', 310000, 15);
INSERT INTO `base_area` VALUES (312600, '奉贤', 310000, 16);
INSERT INTO `base_area` VALUES (312900, '青浦', 310000, 17);
INSERT INTO `base_area` VALUES (313000, '崇明', 310000, 18);
INSERT INTO `base_area` VALUES (320100, '南京', 320000, 1);
INSERT INTO `base_area` VALUES (320200, '无锡', 320000, 2);
INSERT INTO `base_area` VALUES (320300, '徐州', 320000, 3);
INSERT INTO `base_area` VALUES (320400, '常州', 320000, 4);
INSERT INTO `base_area` VALUES (320500, '苏州', 320000, 5);
INSERT INTO `base_area` VALUES (320600, '南通', 320000, 6);
INSERT INTO `base_area` VALUES (320700, '连云港', 320000, 7);
INSERT INTO `base_area` VALUES (320800, '淮安', 320000, 8);
INSERT INTO `base_area` VALUES (320900, '盐城', 320000, 9);
INSERT INTO `base_area` VALUES (321000, '扬州', 320000, 10);
INSERT INTO `base_area` VALUES (321100, '镇江', 320000, 11);
INSERT INTO `base_area` VALUES (321200, '泰州', 320000, 12);
INSERT INTO `base_area` VALUES (321300, '宿迁', 320000, 13);
INSERT INTO `base_area` VALUES (330100, '杭州', 330000, 1);
INSERT INTO `base_area` VALUES (330200, '宁波', 330000, 2);
INSERT INTO `base_area` VALUES (330300, '温州', 330000, 3);
INSERT INTO `base_area` VALUES (330400, '嘉兴', 330000, 4);
INSERT INTO `base_area` VALUES (330500, '湖州', 330000, 5);
INSERT INTO `base_area` VALUES (330600, '绍兴', 330000, 6);
INSERT INTO `base_area` VALUES (330700, '金华', 330000, 7);
INSERT INTO `base_area` VALUES (330800, '衢州', 330000, 8);
INSERT INTO `base_area` VALUES (330900, '舟山', 330000, 9);
INSERT INTO `base_area` VALUES (331000, '台州', 330000, 10);
INSERT INTO `base_area` VALUES (331100, '丽水', 330000, 11);
INSERT INTO `base_area` VALUES (340100, '合肥', 340000, 1);
INSERT INTO `base_area` VALUES (340200, '芜湖', 340000, 2);
INSERT INTO `base_area` VALUES (340300, '蚌埠', 340000, 3);
INSERT INTO `base_area` VALUES (340400, '淮南', 340000, 4);
INSERT INTO `base_area` VALUES (340500, '马鞍山', 340000, 5);
INSERT INTO `base_area` VALUES (340600, '淮北', 340000, 6);
INSERT INTO `base_area` VALUES (340700, '铜陵', 340000, 7);
INSERT INTO `base_area` VALUES (340800, '安庆', 340000, 8);
INSERT INTO `base_area` VALUES (341000, '黄山', 340000, 9);
INSERT INTO `base_area` VALUES (341100, '滁州', 340000, 10);
INSERT INTO `base_area` VALUES (341200, '阜阳', 340000, 11);
INSERT INTO `base_area` VALUES (341300, '宿州', 340000, 12);
INSERT INTO `base_area` VALUES (341400, '巢湖', 340000, 13);
INSERT INTO `base_area` VALUES (341500, '六安', 340000, 14);
INSERT INTO `base_area` VALUES (341600, '亳州', 340000, 15);
INSERT INTO `base_area` VALUES (341700, '池州', 340000, 16);
INSERT INTO `base_area` VALUES (341800, '宣城', 340000, 17);
INSERT INTO `base_area` VALUES (350100, '福州', 350000, 1);
INSERT INTO `base_area` VALUES (350200, '厦门', 350000, 2);
INSERT INTO `base_area` VALUES (350300, '莆田', 350000, 3);
INSERT INTO `base_area` VALUES (350400, '三明', 350000, 4);
INSERT INTO `base_area` VALUES (350500, '泉州', 350000, 5);
INSERT INTO `base_area` VALUES (350600, '漳州', 350000, 6);
INSERT INTO `base_area` VALUES (350700, '南平', 350000, 7);
INSERT INTO `base_area` VALUES (350800, '龙岩', 350000, 8);
INSERT INTO `base_area` VALUES (350900, '宁德', 350000, 9);
INSERT INTO `base_area` VALUES (360100, '南昌', 360000, 1);
INSERT INTO `base_area` VALUES (360200, '景德镇', 360000, 2);
INSERT INTO `base_area` VALUES (360300, '萍乡', 360000, 3);
INSERT INTO `base_area` VALUES (360400, '九江', 360000, 4);
INSERT INTO `base_area` VALUES (360500, '新余', 360000, 5);
INSERT INTO `base_area` VALUES (360600, '鹰潭', 360000, 6);
INSERT INTO `base_area` VALUES (360700, '赣州', 360000, 7);
INSERT INTO `base_area` VALUES (360800, '吉安', 360000, 8);
INSERT INTO `base_area` VALUES (360900, '宜春', 360000, 9);
INSERT INTO `base_area` VALUES (361000, '抚州', 360000, 10);
INSERT INTO `base_area` VALUES (361100, '上饶', 360000, 11);
INSERT INTO `base_area` VALUES (370100, '济南', 370000, 1);
INSERT INTO `base_area` VALUES (370200, '青岛', 370000, 2);
INSERT INTO `base_area` VALUES (370300, '淄博', 370000, 3);
INSERT INTO `base_area` VALUES (370400, '枣庄', 370000, 4);
INSERT INTO `base_area` VALUES (370500, '东营', 370000, 5);
INSERT INTO `base_area` VALUES (370600, '烟台', 370000, 6);
INSERT INTO `base_area` VALUES (370700, '潍坊', 370000, 7);
INSERT INTO `base_area` VALUES (370800, '济宁', 370000, 8);
INSERT INTO `base_area` VALUES (370900, '泰安', 370000, 9);
INSERT INTO `base_area` VALUES (371000, '威海', 370000, 10);
INSERT INTO `base_area` VALUES (371100, '日照', 370000, 11);
INSERT INTO `base_area` VALUES (371200, '莱芜', 370000, 12);
INSERT INTO `base_area` VALUES (371300, '临沂', 370000, 13);
INSERT INTO `base_area` VALUES (371400, '德州', 370000, 14);
INSERT INTO `base_area` VALUES (371500, '聊城', 370000, 15);
INSERT INTO `base_area` VALUES (371600, '滨州', 370000, 16);
INSERT INTO `base_area` VALUES (371700, '菏泽', 370000, 17);
INSERT INTO `base_area` VALUES (410100, '郑州', 410000, 1);
INSERT INTO `base_area` VALUES (410200, '开封', 410000, 2);
INSERT INTO `base_area` VALUES (410300, '洛阳', 410000, 3);
INSERT INTO `base_area` VALUES (410400, '平顶山', 410000, 4);
INSERT INTO `base_area` VALUES (410500, '安阳', 410000, 5);
INSERT INTO `base_area` VALUES (410600, '鹤壁', 410000, 6);
INSERT INTO `base_area` VALUES (410700, '新乡', 410000, 7);
INSERT INTO `base_area` VALUES (410800, '焦作', 410000, 8);
INSERT INTO `base_area` VALUES (410900, '濮阳', 410000, 9);
INSERT INTO `base_area` VALUES (411000, '许昌', 410000, 10);
INSERT INTO `base_area` VALUES (411100, '漯河', 410000, 11);
INSERT INTO `base_area` VALUES (411200, '三门峡', 410000, 12);
INSERT INTO `base_area` VALUES (411300, '南阳', 410000, 13);
INSERT INTO `base_area` VALUES (411400, '商丘', 410000, 14);
INSERT INTO `base_area` VALUES (411500, '信阳', 410000, 15);
INSERT INTO `base_area` VALUES (411600, '周口', 410000, 16);
INSERT INTO `base_area` VALUES (411700, '驻马店', 410000, 17);
INSERT INTO `base_area` VALUES (411800, '济源', 410000, 18);
INSERT INTO `base_area` VALUES (420100, '武汉', 420000, 1);
INSERT INTO `base_area` VALUES (420200, '黄石', 420000, 2);
INSERT INTO `base_area` VALUES (420300, '十堰', 420000, 3);
INSERT INTO `base_area` VALUES (420500, '宜昌', 420000, 4);
INSERT INTO `base_area` VALUES (420600, '襄樊', 420000, 5);
INSERT INTO `base_area` VALUES (420700, '鄂州', 420000, 6);
INSERT INTO `base_area` VALUES (420800, '荆门', 420000, 7);
INSERT INTO `base_area` VALUES (420900, '孝感', 420000, 8);
INSERT INTO `base_area` VALUES (421000, '荆州', 420000, 9);
INSERT INTO `base_area` VALUES (421100, '黄冈', 420000, 10);
INSERT INTO `base_area` VALUES (421200, '咸宁', 420000, 11);
INSERT INTO `base_area` VALUES (421300, '随州', 420000, 12);
INSERT INTO `base_area` VALUES (422800, '恩施', 420000, 13);
INSERT INTO `base_area` VALUES (422900, '仙桃', 420000, 14);
INSERT INTO `base_area` VALUES (423000, '潜江', 420000, 15);
INSERT INTO `base_area` VALUES (423100, '天门', 420000, 16);
INSERT INTO `base_area` VALUES (423200, '神农架', 420000, 17);
INSERT INTO `base_area` VALUES (430100, '长沙', 430000, 1);
INSERT INTO `base_area` VALUES (430200, '株洲', 430000, 2);
INSERT INTO `base_area` VALUES (430300, '湘潭', 430000, 3);
INSERT INTO `base_area` VALUES (430400, '衡阳', 430000, 4);
INSERT INTO `base_area` VALUES (430500, '邵阳', 430000, 5);
INSERT INTO `base_area` VALUES (430600, '岳阳', 430000, 6);
INSERT INTO `base_area` VALUES (430700, '常德', 430000, 7);
INSERT INTO `base_area` VALUES (430800, '张家界', 430000, 8);
INSERT INTO `base_area` VALUES (430900, '益阳', 430000, 9);
INSERT INTO `base_area` VALUES (431000, '郴州', 430000, 10);
INSERT INTO `base_area` VALUES (431100, '永州', 430000, 11);
INSERT INTO `base_area` VALUES (431200, '怀化', 430000, 12);
INSERT INTO `base_area` VALUES (431300, '娄底', 430000, 13);
INSERT INTO `base_area` VALUES (433100, '湘西', 430000, 14);
INSERT INTO `base_area` VALUES (440100, '广州', 440000, 1);
INSERT INTO `base_area` VALUES (440200, '韶关', 440000, 2);
INSERT INTO `base_area` VALUES (440300, '深圳', 440000, 3);
INSERT INTO `base_area` VALUES (440400, '珠海', 440000, 4);
INSERT INTO `base_area` VALUES (440500, '汕头', 440000, 5);
INSERT INTO `base_area` VALUES (440600, '佛山', 440000, 6);
INSERT INTO `base_area` VALUES (440700, '江门', 440000, 7);
INSERT INTO `base_area` VALUES (440800, '湛江', 440000, 8);
INSERT INTO `base_area` VALUES (440900, '茂名', 440000, 9);
INSERT INTO `base_area` VALUES (441200, '肇庆', 440000, 10);
INSERT INTO `base_area` VALUES (441300, '惠州', 440000, 11);
INSERT INTO `base_area` VALUES (441400, '梅州', 440000, 12);
INSERT INTO `base_area` VALUES (441500, '汕尾', 440000, 13);
INSERT INTO `base_area` VALUES (441600, '河源', 440000, 14);
INSERT INTO `base_area` VALUES (441700, '阳江', 440000, 15);
INSERT INTO `base_area` VALUES (441800, '清远', 440000, 16);
INSERT INTO `base_area` VALUES (441900, '东莞', 440000, 17);
INSERT INTO `base_area` VALUES (442000, '中山', 440000, 18);
INSERT INTO `base_area` VALUES (445100, '潮州', 440000, 19);
INSERT INTO `base_area` VALUES (445200, '揭阳', 440000, 20);
INSERT INTO `base_area` VALUES (445300, '云浮', 440000, 21);
INSERT INTO `base_area` VALUES (450100, '南宁', 450000, 1);
INSERT INTO `base_area` VALUES (450200, '柳州', 450000, 2);
INSERT INTO `base_area` VALUES (450300, '桂林', 450000, 3);
INSERT INTO `base_area` VALUES (450400, '梧州', 450000, 4);
INSERT INTO `base_area` VALUES (450500, '北海', 450000, 5);
INSERT INTO `base_area` VALUES (450600, '防城港', 450000, 6);
INSERT INTO `base_area` VALUES (450700, '钦州', 450000, 7);
INSERT INTO `base_area` VALUES (450800, '贵港', 450000, 8);
INSERT INTO `base_area` VALUES (450900, '玉林', 450000, 9);
INSERT INTO `base_area` VALUES (451000, '百色', 450000, 10);
INSERT INTO `base_area` VALUES (451100, '贺州', 450000, 11);
INSERT INTO `base_area` VALUES (451200, '河池', 450000, 12);
INSERT INTO `base_area` VALUES (451300, '来宾', 450000, 13);
INSERT INTO `base_area` VALUES (451400, '崇左', 450000, 14);
INSERT INTO `base_area` VALUES (460100, '海口', 460000, 1);
INSERT INTO `base_area` VALUES (460200, '三亚', 460000, 2);
INSERT INTO `base_area` VALUES (460300, '五指山', 460000, 3);
INSERT INTO `base_area` VALUES (460400, '琼海', 460000, 4);
INSERT INTO `base_area` VALUES (460500, '儋州', 460000, 5);
INSERT INTO `base_area` VALUES (460600, '文昌', 460000, 6);
INSERT INTO `base_area` VALUES (460700, '万宁', 460000, 7);
INSERT INTO `base_area` VALUES (500100, '万州', 500000, 1);
INSERT INTO `base_area` VALUES (500200, '涪陵', 500000, 2);
INSERT INTO `base_area` VALUES (500300, '渝中', 500000, 3);
INSERT INTO `base_area` VALUES (500400, '大渡口', 500000, 4);
INSERT INTO `base_area` VALUES (500500, '江北', 500000, 5);
INSERT INTO `base_area` VALUES (500600, '沙坪坝', 500000, 6);
INSERT INTO `base_area` VALUES (500700, '九龙坡', 500000, 7);
INSERT INTO `base_area` VALUES (500800, '南岸', 500000, 8);
INSERT INTO `base_area` VALUES (500900, '北碚', 500000, 9);
INSERT INTO `base_area` VALUES (501000, '万盛', 500000, 10);
INSERT INTO `base_area` VALUES (501100, '双桥', 500000, 11);
INSERT INTO `base_area` VALUES (501200, '渝北', 500000, 12);
INSERT INTO `base_area` VALUES (501300, '巴南', 500000, 13);
INSERT INTO `base_area` VALUES (502100, '长寿', 500000, 14);
INSERT INTO `base_area` VALUES (502200, '綦江', 500000, 15);
INSERT INTO `base_area` VALUES (502300, '潼南', 500000, 16);
INSERT INTO `base_area` VALUES (502400, '铜梁', 500000, 17);
INSERT INTO `base_area` VALUES (502500, '大足', 500000, 18);
INSERT INTO `base_area` VALUES (502600, '荣昌', 500000, 19);
INSERT INTO `base_area` VALUES (502700, '璧山', 500000, 20);
INSERT INTO `base_area` VALUES (502800, '梁平', 500000, 21);
INSERT INTO `base_area` VALUES (502900, '城口', 500000, 22);
INSERT INTO `base_area` VALUES (503000, '丰都', 500000, 23);
INSERT INTO `base_area` VALUES (503100, '垫江', 500000, 24);
INSERT INTO `base_area` VALUES (503200, '武隆', 500000, 25);
INSERT INTO `base_area` VALUES (503300, '忠县', 500000, 26);
INSERT INTO `base_area` VALUES (503400, '开县', 500000, 27);
INSERT INTO `base_area` VALUES (503500, '云阳', 500000, 28);
INSERT INTO `base_area` VALUES (503600, '奉节', 500000, 29);
INSERT INTO `base_area` VALUES (503700, '巫山', 500000, 30);
INSERT INTO `base_area` VALUES (503800, '巫溪', 500000, 31);
INSERT INTO `base_area` VALUES (503900, '黔江', 500000, 32);
INSERT INTO `base_area` VALUES (504000, '石柱', 500000, 33);
INSERT INTO `base_area` VALUES (504100, '秀山', 500000, 34);
INSERT INTO `base_area` VALUES (504200, '酉阳', 500000, 35);
INSERT INTO `base_area` VALUES (504300, '彭水', 500000, 36);
INSERT INTO `base_area` VALUES (508100, '江津', 500000, 37);
INSERT INTO `base_area` VALUES (508200, '合川', 500000, 38);
INSERT INTO `base_area` VALUES (508300, '永川', 500000, 39);
INSERT INTO `base_area` VALUES (508400, '南川', 500000, 40);
INSERT INTO `base_area` VALUES (510100, '成都', 510000, 1);
INSERT INTO `base_area` VALUES (510300, '自贡', 510000, 2);
INSERT INTO `base_area` VALUES (510400, '攀枝花', 510000, 3);
INSERT INTO `base_area` VALUES (510500, '泸州', 510000, 4);
INSERT INTO `base_area` VALUES (510600, '德阳', 510000, 5);
INSERT INTO `base_area` VALUES (510700, '绵阳', 510000, 6);
INSERT INTO `base_area` VALUES (510800, '广元', 510000, 7);
INSERT INTO `base_area` VALUES (510900, '遂宁', 510000, 8);
INSERT INTO `base_area` VALUES (511000, '内江', 510000, 9);
INSERT INTO `base_area` VALUES (511100, '乐山', 510000, 10);
INSERT INTO `base_area` VALUES (511300, '南充', 510000, 11);
INSERT INTO `base_area` VALUES (511400, '眉山', 510000, 12);
INSERT INTO `base_area` VALUES (511500, '宜宾', 510000, 13);
INSERT INTO `base_area` VALUES (511600, '广安', 510000, 14);
INSERT INTO `base_area` VALUES (511700, '达州', 510000, 15);
INSERT INTO `base_area` VALUES (511800, '雅安', 510000, 16);
INSERT INTO `base_area` VALUES (511900, '巴中', 510000, 17);
INSERT INTO `base_area` VALUES (512000, '资阳', 510000, 18);
INSERT INTO `base_area` VALUES (513200, '阿坝', 510000, 19);
INSERT INTO `base_area` VALUES (513300, '甘孜', 510000, 20);
INSERT INTO `base_area` VALUES (513400, '凉山', 510000, 21);
INSERT INTO `base_area` VALUES (520100, '贵阳', 520000, 1);
INSERT INTO `base_area` VALUES (520200, '六盘水', 520000, 2);
INSERT INTO `base_area` VALUES (520300, '遵义', 520000, 3);
INSERT INTO `base_area` VALUES (520400, '安顺', 520000, 4);
INSERT INTO `base_area` VALUES (522200, '铜仁', 520000, 5);
INSERT INTO `base_area` VALUES (522300, '黔西南', 520000, 6);
INSERT INTO `base_area` VALUES (522400, '毕节', 520000, 7);
INSERT INTO `base_area` VALUES (522600, '黔东南', 520000, 8);
INSERT INTO `base_area` VALUES (522700, '黔南', 520000, 9);
INSERT INTO `base_area` VALUES (530100, '昆明', 530000, 1);
INSERT INTO `base_area` VALUES (530300, '曲靖', 530000, 2);
INSERT INTO `base_area` VALUES (530400, '玉溪', 530000, 3);
INSERT INTO `base_area` VALUES (530500, '保山', 530000, 4);
INSERT INTO `base_area` VALUES (530600, '昭通', 530000, 5);
INSERT INTO `base_area` VALUES (530700, '丽江', 530000, 6);
INSERT INTO `base_area` VALUES (530800, '普洱', 530000, 7);
INSERT INTO `base_area` VALUES (530900, '临沧', 530000, 8);
INSERT INTO `base_area` VALUES (532300, '楚雄', 530000, 9);
INSERT INTO `base_area` VALUES (532500, '红河', 530000, 10);
INSERT INTO `base_area` VALUES (532600, '文山', 530000, 11);
INSERT INTO `base_area` VALUES (532800, '西双版纳', 530000, 12);
INSERT INTO `base_area` VALUES (532900, '大理', 530000, 13);
INSERT INTO `base_area` VALUES (533100, '德宏', 530000, 14);
INSERT INTO `base_area` VALUES (533300, '怒江傈', 530000, 15);
INSERT INTO `base_area` VALUES (533400, '迪庆', 530000, 16);
INSERT INTO `base_area` VALUES (540100, '拉萨', 540000, 1);
INSERT INTO `base_area` VALUES (542100, '昌都', 540000, 2);
INSERT INTO `base_area` VALUES (542200, '山南', 540000, 3);
INSERT INTO `base_area` VALUES (542300, '日喀则', 540000, 4);
INSERT INTO `base_area` VALUES (542400, '那曲', 540000, 5);
INSERT INTO `base_area` VALUES (542500, '阿里', 540000, 6);
INSERT INTO `base_area` VALUES (542600, '林芝', 540000, 7);
INSERT INTO `base_area` VALUES (610100, '西安', 610000, 1);
INSERT INTO `base_area` VALUES (610200, '铜川', 610000, 2);
INSERT INTO `base_area` VALUES (610300, '宝鸡', 610000, 3);
INSERT INTO `base_area` VALUES (610400, '咸阳', 610000, 4);
INSERT INTO `base_area` VALUES (610500, '渭南', 610000, 5);
INSERT INTO `base_area` VALUES (610600, '延安', 610000, 6);
INSERT INTO `base_area` VALUES (610700, '汉中', 610000, 7);
INSERT INTO `base_area` VALUES (610800, '榆林', 610000, 8);
INSERT INTO `base_area` VALUES (610900, '安康', 610000, 9);
INSERT INTO `base_area` VALUES (611000, '商洛', 610000, 10);
INSERT INTO `base_area` VALUES (620100, '兰州', 620000, 1);
INSERT INTO `base_area` VALUES (620200, '嘉峪关', 620000, 2);
INSERT INTO `base_area` VALUES (620300, '金昌', 620000, 3);
INSERT INTO `base_area` VALUES (620400, '白银', 620000, 4);
INSERT INTO `base_area` VALUES (620500, '天水', 620000, 5);
INSERT INTO `base_area` VALUES (620600, '武威', 620000, 6);
INSERT INTO `base_area` VALUES (620700, '张掖', 620000, 7);
INSERT INTO `base_area` VALUES (620800, '平凉', 620000, 8);
INSERT INTO `base_area` VALUES (620900, '酒泉', 620000, 9);
INSERT INTO `base_area` VALUES (621000, '庆阳', 620000, 10);
INSERT INTO `base_area` VALUES (621100, '定西', 620000, 11);
INSERT INTO `base_area` VALUES (621200, '陇南', 620000, 12);
INSERT INTO `base_area` VALUES (622900, '临夏', 620000, 13);
INSERT INTO `base_area` VALUES (623000, '甘南', 620000, 14);
INSERT INTO `base_area` VALUES (630100, '西宁', 630000, 1);
INSERT INTO `base_area` VALUES (632100, '海东', 630000, 2);
INSERT INTO `base_area` VALUES (632200, '海北', 630000, 3);
INSERT INTO `base_area` VALUES (632300, '黄南', 630000, 4);
INSERT INTO `base_area` VALUES (632500, '海南', 630000, 5);
INSERT INTO `base_area` VALUES (632600, '果洛', 630000, 6);
INSERT INTO `base_area` VALUES (632700, '玉树', 630000, 7);
INSERT INTO `base_area` VALUES (632800, '海西', 630000, 8);
INSERT INTO `base_area` VALUES (640100, '银川', 640000, 1);
INSERT INTO `base_area` VALUES (640200, '石嘴山', 640000, 2);
INSERT INTO `base_area` VALUES (640300, '吴忠', 640000, 3);
INSERT INTO `base_area` VALUES (640400, '固原', 640000, 4);
INSERT INTO `base_area` VALUES (640500, '中卫', 640000, 5);
INSERT INTO `base_area` VALUES (650100, '乌鲁木齐', 650000, 1);
INSERT INTO `base_area` VALUES (650200, '克拉玛依', 650000, 2);
INSERT INTO `base_area` VALUES (652100, '吐鲁番', 650000, 3);
INSERT INTO `base_area` VALUES (652200, '哈密', 650000, 4);
INSERT INTO `base_area` VALUES (652300, '昌吉', 650000, 5);
INSERT INTO `base_area` VALUES (652700, '博尔塔拉', 650000, 6);
INSERT INTO `base_area` VALUES (652800, '巴音郭楞', 650000, 7);
INSERT INTO `base_area` VALUES (652900, '阿克苏', 650000, 8);
INSERT INTO `base_area` VALUES (653000, '克孜勒苏', 650000, 9);
INSERT INTO `base_area` VALUES (653100, '喀什', 650000, 10);
INSERT INTO `base_area` VALUES (653200, '和田', 650000, 11);
INSERT INTO `base_area` VALUES (654000, '伊犁', 650000, 12);
INSERT INTO `base_area` VALUES (654200, '塔城', 650000, 13);
INSERT INTO `base_area` VALUES (654300, '阿勒泰', 650000, 14);
INSERT INTO `base_area` VALUES (654400, '石河子', 650000, 15);
INSERT INTO `base_area` VALUES (654500, '阿拉尔', 650000, 16);
INSERT INTO `base_area` VALUES (654600, '图木舒克', 650000, 17);
INSERT INTO `base_area` VALUES (654700, '五家渠', 650000, 18);
INSERT INTO `base_area` VALUES (710100, '台北市', 710000, 1);
INSERT INTO `base_area` VALUES (710200, '高雄市', 710000, 2);
INSERT INTO `base_area` VALUES (710300, '基隆市', 710000, 3);
INSERT INTO `base_area` VALUES (710400, '台中市', 710000, 4);
INSERT INTO `base_area` VALUES (710500, '台南市', 710000, 5);
INSERT INTO `base_area` VALUES (710600, '新竹市', 710000, 6);
INSERT INTO `base_area` VALUES (710700, '嘉义市', 710000, 7);
INSERT INTO `base_area` VALUES (710800, '台北县', 710000, 8);
INSERT INTO `base_area` VALUES (710900, '宜兰县', 710000, 9);
INSERT INTO `base_area` VALUES (711000, '新竹县', 710000, 10);
INSERT INTO `base_area` VALUES (711100, '桃园县', 710000, 11);
INSERT INTO `base_area` VALUES (711200, '苗栗县', 710000, 12);
INSERT INTO `base_area` VALUES (711300, '台中县', 710000, 13);
INSERT INTO `base_area` VALUES (711400, '彰化县', 710000, 14);
INSERT INTO `base_area` VALUES (711500, '南投县', 710000, 15);
INSERT INTO `base_area` VALUES (711600, '嘉义县', 710000, 16);
INSERT INTO `base_area` VALUES (711700, '云林县', 710000, 17);
INSERT INTO `base_area` VALUES (711800, '台南县', 710000, 18);
INSERT INTO `base_area` VALUES (711900, '高雄县', 710000, 19);
INSERT INTO `base_area` VALUES (712000, '屏东县', 710000, 20);
INSERT INTO `base_area` VALUES (712100, '台东县', 710000, 21);
INSERT INTO `base_area` VALUES (712200, '花莲县', 710000, 22);
INSERT INTO `base_area` VALUES (712300, '澎湖县', 710000, 23);
INSERT INTO `base_area` VALUES (810100, '中西区', 810000, 1);
INSERT INTO `base_area` VALUES (810200, '东区', 810000, 2);
INSERT INTO `base_area` VALUES (810300, '九龙城区', 810000, 3);
INSERT INTO `base_area` VALUES (810400, '观塘区', 810000, 4);
INSERT INTO `base_area` VALUES (810500, '南区', 810000, 5);
INSERT INTO `base_area` VALUES (810600, '深水区', 810000, 6);
INSERT INTO `base_area` VALUES (810700, '湾仔区', 810000, 7);
INSERT INTO `base_area` VALUES (810800, '黄大仙区', 810000, 8);
INSERT INTO `base_area` VALUES (810900, '油尖旺区', 810000, 9);
INSERT INTO `base_area` VALUES (811000, '离岛区', 810000, 10);
INSERT INTO `base_area` VALUES (811100, '葵青区', 810000, 11);
INSERT INTO `base_area` VALUES (811200, '北区', 810000, 12);
INSERT INTO `base_area` VALUES (811300, '西贡区', 810000, 13);
INSERT INTO `base_area` VALUES (811400, '沙田区', 810000, 14);
INSERT INTO `base_area` VALUES (811500, '屯门区', 810000, 15);
INSERT INTO `base_area` VALUES (811600, '大埔区', 810000, 16);
INSERT INTO `base_area` VALUES (811700, '荃湾区', 810000, 17);
INSERT INTO `base_area` VALUES (811800, '元朗区', 810000, 18);
INSERT INTO `base_area` VALUES (820100, '花地玛堂区', 820000, 1);
INSERT INTO `base_area` VALUES (820200, '圣安多尼堂区', 820000, 2);
INSERT INTO `base_area` VALUES (820300, '大堂区', 820000, 3);
INSERT INTO `base_area` VALUES (820400, '望德堂区', 820000, 4);
INSERT INTO `base_area` VALUES (820500, '风顺堂区', 820000, 5);
INSERT INTO `base_area` VALUES (820600, '嘉模堂区', 820000, 6);
INSERT INTO `base_area` VALUES (820700, '圣方济各堂区', 820000, 7);
INSERT INTO `base_area` VALUES (610424, '乾县', 610400, 6);
INSERT INTO `base_area` VALUES (610423, '泾阳县', 610400, 5);
INSERT INTO `base_area` VALUES (610422, '三原县', 610400, 4);
INSERT INTO `base_area` VALUES (610404, '渭城区', 610400, 3);
INSERT INTO `base_area` VALUES (610403, '杨凌区', 610400, 2);
INSERT INTO `base_area` VALUES (610402, '秦都区', 610400, 1);
INSERT INTO `base_area` VALUES (610331, '太白县', 610300, 12);
INSERT INTO `base_area` VALUES (610330, '凤县', 610300, 11);
INSERT INTO `base_area` VALUES (610329, '麟游县', 610300, 10);
INSERT INTO `base_area` VALUES (610328, '千阳县', 610300, 9);
INSERT INTO `base_area` VALUES (610327, '陇县', 610300, 8);
INSERT INTO `base_area` VALUES (610326, '眉县', 610300, 7);
INSERT INTO `base_area` VALUES (610324, '扶风县', 610300, 6);
INSERT INTO `base_area` VALUES (610323, '岐山县', 610300, 5);
INSERT INTO `base_area` VALUES (610322, '凤翔县', 610300, 4);
INSERT INTO `base_area` VALUES (610304, '陈仓区', 610300, 3);
INSERT INTO `base_area` VALUES (610303, '金台区', 610300, 2);
INSERT INTO `base_area` VALUES (610302, '渭滨区', 610300, 1);
INSERT INTO `base_area` VALUES (610222, '宜君县', 610200, 4);
INSERT INTO `base_area` VALUES (610204, '耀州区', 610200, 3);
INSERT INTO `base_area` VALUES (610203, '印台区', 610200, 2);
INSERT INTO `base_area` VALUES (610202, '王益区', 610200, 1);
INSERT INTO `base_area` VALUES (610126, '高陵县', 610100, 13);
INSERT INTO `base_area` VALUES (610125, '户县', 610100, 12);
INSERT INTO `base_area` VALUES (610124, '周至县', 610100, 11);
INSERT INTO `base_area` VALUES (610122, '蓝田县', 610100, 10);
INSERT INTO `base_area` VALUES (610116, '长安区', 610100, 9);
INSERT INTO `base_area` VALUES (610115, '临潼区', 610100, 8);
INSERT INTO `base_area` VALUES (610114, '阎良区', 610100, 7);
INSERT INTO `base_area` VALUES (610113, '雁塔区', 610100, 6);
INSERT INTO `base_area` VALUES (610112, '未央区', 610100, 5);
INSERT INTO `base_area` VALUES (610111, '灞桥区', 610100, 4);
INSERT INTO `base_area` VALUES (610104, '莲湖区', 610100, 3);
INSERT INTO `base_area` VALUES (610103, '碑林区', 610100, 2);
INSERT INTO `base_area` VALUES (610102, '新城区', 610100, 1);
INSERT INTO `base_area` VALUES (542627, '朗县', 542600, 7);
INSERT INTO `base_area` VALUES (542626, '察隅县', 542600, 6);
INSERT INTO `base_area` VALUES (542625, '波密县', 542600, 5);
INSERT INTO `base_area` VALUES (542624, '墨脱县', 542600, 4);
INSERT INTO `base_area` VALUES (542623, '米林县', 542600, 3);
INSERT INTO `base_area` VALUES (542622, '工布江达县', 542600, 2);
INSERT INTO `base_area` VALUES (542621, '林芝县', 542600, 1);
INSERT INTO `base_area` VALUES (542527, '措勤县', 542500, 7);
INSERT INTO `base_area` VALUES (542526, '改则县', 542500, 6);
INSERT INTO `base_area` VALUES (542525, '革吉县', 542500, 5);
INSERT INTO `base_area` VALUES (542524, '日土县', 542500, 4);
INSERT INTO `base_area` VALUES (542523, '噶尔县', 542500, 3);
INSERT INTO `base_area` VALUES (542522, '札达县', 542500, 2);
INSERT INTO `base_area` VALUES (542521, '普兰县', 542500, 1);
INSERT INTO `base_area` VALUES (542430, '尼玛县', 542400, 10);
INSERT INTO `base_area` VALUES (542429, '巴青县', 542400, 9);
INSERT INTO `base_area` VALUES (542428, '班戈县', 542400, 8);
INSERT INTO `base_area` VALUES (542427, '索县', 542400, 7);
INSERT INTO `base_area` VALUES (542426, '申扎县', 542400, 6);
INSERT INTO `base_area` VALUES (542425, '安多县', 542400, 5);
INSERT INTO `base_area` VALUES (542424, '聂荣县', 542400, 4);
INSERT INTO `base_area` VALUES (542423, '比如县', 542400, 3);
INSERT INTO `base_area` VALUES (542422, '嘉黎县', 542400, 2);
INSERT INTO `base_area` VALUES (542421, '那曲县', 542400, 1);
INSERT INTO `base_area` VALUES (542338, '岗巴县', 542300, 18);
INSERT INTO `base_area` VALUES (542337, '萨嘎县', 542300, 17);
INSERT INTO `base_area` VALUES (542336, '聂拉木县', 542300, 16);
INSERT INTO `base_area` VALUES (542335, '吉隆县', 542300, 15);
INSERT INTO `base_area` VALUES (542334, '亚东县', 542300, 14);
INSERT INTO `base_area` VALUES (542333, '仲巴县', 542300, 13);
INSERT INTO `base_area` VALUES (542332, '定结县', 542300, 12);
INSERT INTO `base_area` VALUES (542331, '康马县', 542300, 11);
INSERT INTO `base_area` VALUES (542330, '仁布县', 542300, 10);
INSERT INTO `base_area` VALUES (542329, '白朗县', 542300, 9);
INSERT INTO `base_area` VALUES (542328, '谢通门县', 542300, 8);
INSERT INTO `base_area` VALUES (542327, '昂仁县', 542300, 7);
INSERT INTO `base_area` VALUES (542326, '拉孜县', 542300, 6);
INSERT INTO `base_area` VALUES (542325, '萨迦县', 542300, 5);
INSERT INTO `base_area` VALUES (542324, '定日县', 542300, 4);
INSERT INTO `base_area` VALUES (542323, '江孜县', 542300, 3);
INSERT INTO `base_area` VALUES (542322, '南木林县', 542300, 2);
INSERT INTO `base_area` VALUES (542301, '日喀则市', 542300, 1);
INSERT INTO `base_area` VALUES (542233, '浪卡子县', 542200, 12);
INSERT INTO `base_area` VALUES (542232, '错那县', 542200, 11);
INSERT INTO `base_area` VALUES (542231, '隆子县', 542200, 10);
INSERT INTO `base_area` VALUES (542229, '加查县', 542200, 9);
INSERT INTO `base_area` VALUES (542228, '洛扎县', 542200, 8);
INSERT INTO `base_area` VALUES (542227, '措美县', 542200, 7);
INSERT INTO `base_area` VALUES (542226, '曲松县', 542200, 6);
INSERT INTO `base_area` VALUES (542225, '琼结县', 542200, 5);
INSERT INTO `base_area` VALUES (542224, '桑日县', 542200, 4);
INSERT INTO `base_area` VALUES (542223, '贡嘎县', 542200, 3);
INSERT INTO `base_area` VALUES (542222, '扎囊县', 542200, 2);
INSERT INTO `base_area` VALUES (542221, '乃东县', 542200, 1);
INSERT INTO `base_area` VALUES (542133, '边坝县', 542100, 11);
INSERT INTO `base_area` VALUES (542132, '洛隆县', 542100, 10);
INSERT INTO `base_area` VALUES (542129, '芒康县', 542100, 9);
INSERT INTO `base_area` VALUES (542128, '左贡县', 542100, 8);
INSERT INTO `base_area` VALUES (542127, '八宿县', 542100, 7);
INSERT INTO `base_area` VALUES (542126, '察雅县', 542100, 6);
INSERT INTO `base_area` VALUES (542125, '丁青县', 542100, 5);
INSERT INTO `base_area` VALUES (542124, '类乌齐县', 542100, 4);
INSERT INTO `base_area` VALUES (542123, '贡觉县', 542100, 3);
INSERT INTO `base_area` VALUES (542122, '江达县', 542100, 2);
INSERT INTO `base_area` VALUES (542121, '昌都县', 542100, 1);
INSERT INTO `base_area` VALUES (540127, '墨竹工卡县', 540100, 8);
INSERT INTO `base_area` VALUES (540126, '达孜县', 540100, 7);
INSERT INTO `base_area` VALUES (540125, '堆龙德庆县', 540100, 6);
INSERT INTO `base_area` VALUES (540124, '曲水县', 540100, 5);
INSERT INTO `base_area` VALUES (540123, '尼木县', 540100, 4);
INSERT INTO `base_area` VALUES (540122, '当雄县', 540100, 3);
INSERT INTO `base_area` VALUES (540121, '林周县', 540100, 2);
INSERT INTO `base_area` VALUES (540102, '城关区', 540100, 1);
INSERT INTO `base_area` VALUES (533423, '维西傈僳族自治县', 533400, 3);
INSERT INTO `base_area` VALUES (533422, '德钦县', 533400, 2);
INSERT INTO `base_area` VALUES (533421, '香格里拉县', 533400, 1);
INSERT INTO `base_area` VALUES (533325, '兰坪白族普米族自治县', 533300, 4);
INSERT INTO `base_area` VALUES (533324, '贡山独龙族怒族自治县', 533300, 3);
INSERT INTO `base_area` VALUES (533323, '福贡县', 533300, 2);
INSERT INTO `base_area` VALUES (533321, '泸水县', 533300, 1);
INSERT INTO `base_area` VALUES (533124, '陇川县', 533100, 5);
INSERT INTO `base_area` VALUES (533123, '盈江县', 533100, 4);
INSERT INTO `base_area` VALUES (533122, '梁河县', 533100, 3);
INSERT INTO `base_area` VALUES (533103, '潞西市', 533100, 2);
INSERT INTO `base_area` VALUES (533102, '瑞丽市', 533100, 1);
INSERT INTO `base_area` VALUES (532932, '鹤庆县', 532900, 12);
INSERT INTO `base_area` VALUES (532931, '剑川县', 532900, 11);
INSERT INTO `base_area` VALUES (532930, '洱源县', 532900, 10);
INSERT INTO `base_area` VALUES (532929, '云龙县', 532900, 9);
INSERT INTO `base_area` VALUES (532928, '永平县', 532900, 8);
INSERT INTO `base_area` VALUES (532927, '巍山彝族回族自治县', 532900, 7);
INSERT INTO `base_area` VALUES (532926, '南涧彝族自治县', 532900, 6);
INSERT INTO `base_area` VALUES (532925, '弥渡县', 532900, 5);
INSERT INTO `base_area` VALUES (532924, '宾川县', 532900, 4);
INSERT INTO `base_area` VALUES (532923, '祥云县', 532900, 3);
INSERT INTO `base_area` VALUES (532922, '漾濞彝族自治县', 532900, 2);
INSERT INTO `base_area` VALUES (532901, '大理市', 532900, 1);
INSERT INTO `base_area` VALUES (532823, '勐腊县', 532800, 3);
INSERT INTO `base_area` VALUES (532822, '勐海县', 532800, 2);
INSERT INTO `base_area` VALUES (532801, '景洪市', 532800, 1);
INSERT INTO `base_area` VALUES (532628, '富宁县', 532600, 8);
INSERT INTO `base_area` VALUES (532627, '广南县', 532600, 7);
INSERT INTO `base_area` VALUES (532626, '丘北县', 532600, 6);
INSERT INTO `base_area` VALUES (532625, '马关县', 532600, 5);
INSERT INTO `base_area` VALUES (532624, '麻栗坡县', 532600, 4);
INSERT INTO `base_area` VALUES (532623, '西畴县', 532600, 3);
INSERT INTO `base_area` VALUES (532622, '砚山县', 532600, 2);
INSERT INTO `base_area` VALUES (532621, '文山县', 532600, 1);
INSERT INTO `base_area` VALUES (532532, '河口瑶族自治县', 532500, 13);
INSERT INTO `base_area` VALUES (532531, '绿春县', 532500, 12);
INSERT INTO `base_area` VALUES (532530, '金平苗族瑶族傣族自治县', 532500, 11);
INSERT INTO `base_area` VALUES (532529, '红河县', 532500, 10);
INSERT INTO `base_area` VALUES (532528, '元阳县', 532500, 9);
INSERT INTO `base_area` VALUES (532527, '泸西县', 532500, 8);
INSERT INTO `base_area` VALUES (532526, '弥勒县', 532500, 7);
INSERT INTO `base_area` VALUES (532525, '石屏县', 532500, 6);
INSERT INTO `base_area` VALUES (532524, '建水县', 532500, 5);
INSERT INTO `base_area` VALUES (532523, '屏边苗族自治县', 532500, 4);
INSERT INTO `base_area` VALUES (532522, '蒙自县', 532500, 3);
INSERT INTO `base_area` VALUES (532502, '开远市', 532500, 2);
INSERT INTO `base_area` VALUES (532501, '个旧市', 532500, 1);
INSERT INTO `base_area` VALUES (532331, '禄丰县', 532300, 10);
INSERT INTO `base_area` VALUES (532329, '武定县', 532300, 9);
INSERT INTO `base_area` VALUES (532328, '元谋县', 532300, 8);
INSERT INTO `base_area` VALUES (532327, '永仁县', 532300, 7);
INSERT INTO `base_area` VALUES (532326, '大姚县', 532300, 6);
INSERT INTO `base_area` VALUES (532325, '姚安县', 532300, 5);
INSERT INTO `base_area` VALUES (532324, '南华县', 532300, 4);
INSERT INTO `base_area` VALUES (532323, '牟定县', 532300, 3);
INSERT INTO `base_area` VALUES (532322, '双柏县', 532300, 2);
INSERT INTO `base_area` VALUES (532301, '楚雄市', 532300, 1);
INSERT INTO `base_area` VALUES (530927, '沧源佤族自治县', 530900, 8);
INSERT INTO `base_area` VALUES (530926, '耿马傣族佤族自治县', 530900, 7);
INSERT INTO `base_area` VALUES (530925, '双江拉祜族佤族布朗族傣族自治县', 530900, 6);
INSERT INTO `base_area` VALUES (530924, '镇康县', 530900, 5);
INSERT INTO `base_area` VALUES (530923, '永德县', 530900, 4);
INSERT INTO `base_area` VALUES (530922, '云县', 530900, 3);
INSERT INTO `base_area` VALUES (530921, '凤庆县', 530900, 2);
INSERT INTO `base_area` VALUES (530902, '临翔区', 530900, 1);
INSERT INTO `base_area` VALUES (530829, '西盟佤族自治县', 530800, 10);
INSERT INTO `base_area` VALUES (530828, '澜沧拉祜族自治县', 530800, 9);
INSERT INTO `base_area` VALUES (530827, '孟连傣族拉祜族佤族自治县', 530800, 8);
INSERT INTO `base_area` VALUES (530826, '江城哈尼族彝族自治县', 530800, 7);
INSERT INTO `base_area` VALUES (530825, '镇沅彝族哈尼族拉祜族自治县', 530800, 6);
INSERT INTO `base_area` VALUES (530824, '景谷傣族彝族自治县', 530800, 5);
INSERT INTO `base_area` VALUES (530823, '景东彝族自治县', 530800, 4);
INSERT INTO `base_area` VALUES (530822, '墨江哈尼族自治县', 530800, 3);
INSERT INTO `base_area` VALUES (530821, '宁洱镇', 530800, 2);
INSERT INTO `base_area` VALUES (530802, '思茅区', 530800, 1);
INSERT INTO `base_area` VALUES (530724, '宁蒗彝族自治县', 530700, 5);
INSERT INTO `base_area` VALUES (530723, '华坪县', 530700, 4);
INSERT INTO `base_area` VALUES (530722, '永胜县', 530700, 3);
INSERT INTO `base_area` VALUES (530721, '玉龙纳西族自治县', 530700, 2);
INSERT INTO `base_area` VALUES (530702, '古城区', 530700, 1);
INSERT INTO `base_area` VALUES (530630, '水富县', 530600, 11);
INSERT INTO `base_area` VALUES (530629, '威信县', 530600, 10);
INSERT INTO `base_area` VALUES (530628, '彝良县', 530600, 9);
INSERT INTO `base_area` VALUES (530627, '镇雄县', 530600, 8);
INSERT INTO `base_area` VALUES (530626, '绥江县', 530600, 7);
INSERT INTO `base_area` VALUES (530625, '永善县', 530600, 6);
INSERT INTO `base_area` VALUES (530624, '大关县', 530600, 5);
INSERT INTO `base_area` VALUES (530623, '盐津县', 530600, 4);
INSERT INTO `base_area` VALUES (530622, '巧家县', 530600, 3);
INSERT INTO `base_area` VALUES (530621, '鲁甸县', 530600, 2);
INSERT INTO `base_area` VALUES (530602, '昭阳区', 530600, 1);
INSERT INTO `base_area` VALUES (530524, '昌宁县', 530500, 5);
INSERT INTO `base_area` VALUES (530523, '龙陵县', 530500, 4);
INSERT INTO `base_area` VALUES (530522, '腾冲县', 530500, 3);
INSERT INTO `base_area` VALUES (530521, '施甸县', 530500, 2);
INSERT INTO `base_area` VALUES (530502, '隆阳区', 530500, 1);
INSERT INTO `base_area` VALUES (530428, '元江哈尼族彝族傣族自治县', 530400, 9);
INSERT INTO `base_area` VALUES (530427, '新平彝族傣族自治县', 530400, 8);
INSERT INTO `base_area` VALUES (530426, '峨山彝族自治县', 530400, 7);
INSERT INTO `base_area` VALUES (530425, '易门县', 530400, 6);
INSERT INTO `base_area` VALUES (530424, '华宁县', 530400, 5);
INSERT INTO `base_area` VALUES (530423, '通海县', 530400, 4);
INSERT INTO `base_area` VALUES (530422, '澄江县', 530400, 3);
INSERT INTO `base_area` VALUES (530421, '江川县', 530400, 2);
INSERT INTO `base_area` VALUES (530402, '红塔区', 530400, 1);
INSERT INTO `base_area` VALUES (530381, '宣威市', 530300, 9);
INSERT INTO `base_area` VALUES (530328, '沾益县', 530300, 8);
INSERT INTO `base_area` VALUES (530326, '会泽县', 530300, 7);
INSERT INTO `base_area` VALUES (530325, '富源县', 530300, 6);
INSERT INTO `base_area` VALUES (530324, '罗平县', 530300, 5);
INSERT INTO `base_area` VALUES (530323, '师宗县', 530300, 4);
INSERT INTO `base_area` VALUES (530322, '陆良县', 530300, 3);
INSERT INTO `base_area` VALUES (530321, '马龙县', 530300, 2);
INSERT INTO `base_area` VALUES (530302, '麒麟区', 530300, 1);
INSERT INTO `base_area` VALUES (530181, '安宁市', 530100, 14);
INSERT INTO `base_area` VALUES (530129, '寻甸回族彝族自治县', 530100, 13);
INSERT INTO `base_area` VALUES (530128, '禄劝彝族苗族自治县', 530100, 12);
INSERT INTO `base_area` VALUES (530127, '嵩明县', 530100, 11);
INSERT INTO `base_area` VALUES (530126, '石林彝族自治县', 530100, 10);
INSERT INTO `base_area` VALUES (530125, '宜良县', 530100, 9);
INSERT INTO `base_area` VALUES (530124, '富民县', 530100, 8);
INSERT INTO `base_area` VALUES (530122, '晋宁县', 530100, 7);
INSERT INTO `base_area` VALUES (530121, '呈贡县', 530100, 6);
INSERT INTO `base_area` VALUES (530113, '东川区', 530100, 5);
INSERT INTO `base_area` VALUES (530112, '西山区', 530100, 4);
INSERT INTO `base_area` VALUES (530111, '官渡区', 530100, 3);
INSERT INTO `base_area` VALUES (530103, '盘龙区', 530100, 2);
INSERT INTO `base_area` VALUES (530102, '五华区', 530100, 1);
INSERT INTO `base_area` VALUES (522732, '三都水族自治县', 522700, 12);
INSERT INTO `base_area` VALUES (522731, '惠水县', 522700, 11);
INSERT INTO `base_area` VALUES (522730, '龙里县', 522700, 10);
INSERT INTO `base_area` VALUES (522729, '长顺县', 522700, 9);
INSERT INTO `base_area` VALUES (522728, '罗甸县', 522700, 8);
INSERT INTO `base_area` VALUES (522727, '平塘县', 522700, 7);
INSERT INTO `base_area` VALUES (522726, '独山县', 522700, 6);
INSERT INTO `base_area` VALUES (522725, '瓮安县', 522700, 5);
INSERT INTO `base_area` VALUES (522723, '贵定县', 522700, 4);
INSERT INTO `base_area` VALUES (522722, '荔波县', 522700, 3);
INSERT INTO `base_area` VALUES (522702, '福泉市', 522700, 2);
INSERT INTO `base_area` VALUES (522701, '都匀市', 522700, 1);
INSERT INTO `base_area` VALUES (522636, '丹寨县', 522600, 16);
INSERT INTO `base_area` VALUES (522635, '麻江县', 522600, 15);
INSERT INTO `base_area` VALUES (522634, '雷山县', 522600, 14);
INSERT INTO `base_area` VALUES (522633, '从江县', 522600, 13);
INSERT INTO `base_area` VALUES (522632, '榕江县', 522600, 12);
INSERT INTO `base_area` VALUES (522631, '黎平县', 522600, 11);
INSERT INTO `base_area` VALUES (522630, '台江县', 522600, 10);
INSERT INTO `base_area` VALUES (522629, '剑河县', 522600, 9);
INSERT INTO `base_area` VALUES (522628, '锦屏县', 522600, 8);
INSERT INTO `base_area` VALUES (522627, '天柱县', 522600, 7);
INSERT INTO `base_area` VALUES (522626, '岑巩县', 522600, 6);
INSERT INTO `base_area` VALUES (522625, '镇远县', 522600, 5);
INSERT INTO `base_area` VALUES (522624, '三穗县', 522600, 4);
INSERT INTO `base_area` VALUES (522623, '施秉县', 522600, 3);
INSERT INTO `base_area` VALUES (522622, '黄平县', 522600, 2);
INSERT INTO `base_area` VALUES (522601, '凯里市', 522600, 1);
INSERT INTO `base_area` VALUES (522428, '赫章县', 522400, 8);
INSERT INTO `base_area` VALUES (522427, '威宁彝族回族苗族自治县', 522400, 7);
INSERT INTO `base_area` VALUES (522426, '纳雍县', 522400, 6);
INSERT INTO `base_area` VALUES (522425, '织金县', 522400, 5);
INSERT INTO `base_area` VALUES (522424, '金沙县', 522400, 4);
INSERT INTO `base_area` VALUES (522423, '黔西县', 522400, 3);
INSERT INTO `base_area` VALUES (522422, '大方县', 522400, 2);
INSERT INTO `base_area` VALUES (522401, '毕节市', 522400, 1);
INSERT INTO `base_area` VALUES (522328, '安龙县', 522300, 8);
INSERT INTO `base_area` VALUES (522327, '册亨县', 522300, 7);
INSERT INTO `base_area` VALUES (522326, '望谟县', 522300, 6);
INSERT INTO `base_area` VALUES (522325, '贞丰县', 522300, 5);
INSERT INTO `base_area` VALUES (522324, '晴隆县', 522300, 4);
INSERT INTO `base_area` VALUES (522323, '普安县', 522300, 3);
INSERT INTO `base_area` VALUES (522322, '兴仁县', 522300, 2);
INSERT INTO `base_area` VALUES (522301, '兴义市', 522300, 1);
INSERT INTO `base_area` VALUES (522230, '万山特区', 522200, 10);
INSERT INTO `base_area` VALUES (522229, '松桃苗族自治县', 522200, 9);
INSERT INTO `base_area` VALUES (522228, '沿河土家族自治县', 522200, 8);
INSERT INTO `base_area` VALUES (522227, '德江县', 522200, 7);
INSERT INTO `base_area` VALUES (522226, '印江土家族苗族自治县', 522200, 6);
INSERT INTO `base_area` VALUES (522225, '思南县', 522200, 5);
INSERT INTO `base_area` VALUES (522224, '石阡县', 522200, 4);
INSERT INTO `base_area` VALUES (522223, '玉屏侗族自治县', 522200, 3);
INSERT INTO `base_area` VALUES (522222, '江口县', 522200, 2);
INSERT INTO `base_area` VALUES (522201, '铜仁市', 522200, 1);
INSERT INTO `base_area` VALUES (520425, '紫云苗族布依族自治县', 520400, 6);
INSERT INTO `base_area` VALUES (520424, '关岭布依族苗族自治县', 520400, 5);
INSERT INTO `base_area` VALUES (520423, '镇宁布依族苗族自治县', 520400, 4);
INSERT INTO `base_area` VALUES (520422, '普定县', 520400, 3);
INSERT INTO `base_area` VALUES (520421, '平坝县', 520400, 2);
INSERT INTO `base_area` VALUES (520402, '西秀区', 520400, 1);
INSERT INTO `base_area` VALUES (520382, '仁怀市', 520300, 14);
INSERT INTO `base_area` VALUES (520381, '赤水市', 520300, 13);
INSERT INTO `base_area` VALUES (520330, '习水县', 520300, 12);
INSERT INTO `base_area` VALUES (520329, '余庆县', 520300, 11);
INSERT INTO `base_area` VALUES (520328, '湄潭县', 520300, 10);
INSERT INTO `base_area` VALUES (520327, '凤冈县', 520300, 9);
INSERT INTO `base_area` VALUES (520326, '务川仡佬族苗族自治县', 520300, 8);
INSERT INTO `base_area` VALUES (520325, '道真仡佬族苗族自治县', 520300, 7);
INSERT INTO `base_area` VALUES (520324, '正安县', 520300, 6);
INSERT INTO `base_area` VALUES (520323, '绥阳县', 520300, 5);
INSERT INTO `base_area` VALUES (520322, '桐梓县', 520300, 4);
INSERT INTO `base_area` VALUES (520321, '遵义县', 520300, 3);
INSERT INTO `base_area` VALUES (520303, '汇川区', 520300, 2);
INSERT INTO `base_area` VALUES (520302, '红花岗区', 520300, 1);
INSERT INTO `base_area` VALUES (520222, '盘县', 520200, 4);
INSERT INTO `base_area` VALUES (520221, '水城县', 520200, 3);
INSERT INTO `base_area` VALUES (520203, '六枝特区', 520200, 2);
INSERT INTO `base_area` VALUES (520201, '钟山区', 520200, 1);
INSERT INTO `base_area` VALUES (520181, '清镇市', 520100, 10);
INSERT INTO `base_area` VALUES (520123, '修文县', 520100, 9);
INSERT INTO `base_area` VALUES (520122, '息烽县', 520100, 8);
INSERT INTO `base_area` VALUES (520121, '开阳县', 520100, 7);
INSERT INTO `base_area` VALUES (520114, '小河区', 520100, 6);
INSERT INTO `base_area` VALUES (520113, '白云区', 520100, 5);
INSERT INTO `base_area` VALUES (520112, '乌当区', 520100, 4);
INSERT INTO `base_area` VALUES (520111, '花溪区', 520100, 3);
INSERT INTO `base_area` VALUES (520103, '云岩区', 520100, 2);
INSERT INTO `base_area` VALUES (520102, '南明区', 520100, 1);
INSERT INTO `base_area` VALUES (513437, '雷波县', 513400, 17);
INSERT INTO `base_area` VALUES (513436, '美姑县', 513400, 16);
INSERT INTO `base_area` VALUES (513435, '甘洛县', 513400, 15);
INSERT INTO `base_area` VALUES (513434, '越西县', 513400, 14);
INSERT INTO `base_area` VALUES (513433, '冕宁县', 513400, 13);
INSERT INTO `base_area` VALUES (513432, '喜德县', 513400, 12);
INSERT INTO `base_area` VALUES (513431, '昭觉县', 513400, 11);
INSERT INTO `base_area` VALUES (513430, '金阳县', 513400, 10);
INSERT INTO `base_area` VALUES (513429, '布拖县', 513400, 9);
INSERT INTO `base_area` VALUES (513428, '普格县', 513400, 8);
INSERT INTO `base_area` VALUES (513427, '宁南县', 513400, 7);
INSERT INTO `base_area` VALUES (513426, '会东县', 513400, 6);
INSERT INTO `base_area` VALUES (513425, '会理县', 513400, 5);
INSERT INTO `base_area` VALUES (513424, '德昌县', 513400, 4);
INSERT INTO `base_area` VALUES (513423, '盐源县', 513400, 3);
INSERT INTO `base_area` VALUES (513422, '木里藏族自治县', 513400, 2);
INSERT INTO `base_area` VALUES (513401, '西昌市', 513400, 1);
INSERT INTO `base_area` VALUES (513338, '得荣县', 513300, 18);
INSERT INTO `base_area` VALUES (513337, '稻城县', 513300, 17);
INSERT INTO `base_area` VALUES (513336, '乡城县', 513300, 16);
INSERT INTO `base_area` VALUES (513335, '巴塘县', 513300, 15);
INSERT INTO `base_area` VALUES (513334, '理塘县', 513300, 14);
INSERT INTO `base_area` VALUES (513333, '色达县', 513300, 13);
INSERT INTO `base_area` VALUES (513332, '石渠县', 513300, 12);
INSERT INTO `base_area` VALUES (513331, '白玉县', 513300, 11);
INSERT INTO `base_area` VALUES (513330, '德格县', 513300, 10);
INSERT INTO `base_area` VALUES (513329, '新龙县', 513300, 9);
INSERT INTO `base_area` VALUES (513328, '甘孜县', 513300, 8);
INSERT INTO `base_area` VALUES (513327, '炉霍县', 513300, 7);
INSERT INTO `base_area` VALUES (513326, '道孚县', 513300, 6);
INSERT INTO `base_area` VALUES (513325, '雅江县', 513300, 5);
INSERT INTO `base_area` VALUES (513324, '九龙县', 513300, 4);
INSERT INTO `base_area` VALUES (513323, '丹巴县', 513300, 3);
INSERT INTO `base_area` VALUES (513322, '泸定县', 513300, 2);
INSERT INTO `base_area` VALUES (513321, '康定县', 513300, 1);
INSERT INTO `base_area` VALUES (513233, '红原县', 513200, 13);
INSERT INTO `base_area` VALUES (513232, '若尔盖县', 513200, 12);
INSERT INTO `base_area` VALUES (513231, '阿坝县', 513200, 11);
INSERT INTO `base_area` VALUES (513230, '壤塘县', 513200, 10);
INSERT INTO `base_area` VALUES (513229, '马尔康县', 513200, 9);
INSERT INTO `base_area` VALUES (513228, '黑水县', 513200, 8);
INSERT INTO `base_area` VALUES (513227, '小金县', 513200, 7);
INSERT INTO `base_area` VALUES (513226, '金川县', 513200, 6);
INSERT INTO `base_area` VALUES (513225, '九寨沟县', 513200, 5);
INSERT INTO `base_area` VALUES (513224, '松潘县', 513200, 4);
INSERT INTO `base_area` VALUES (513223, '茂县', 513200, 3);
INSERT INTO `base_area` VALUES (513222, '理县', 513200, 2);
INSERT INTO `base_area` VALUES (513221, '汶川县', 513200, 1);
INSERT INTO `base_area` VALUES (512081, '简阳市', 512000, 4);
INSERT INTO `base_area` VALUES (512022, '乐至县', 512000, 3);
INSERT INTO `base_area` VALUES (512021, '安岳县', 512000, 2);
INSERT INTO `base_area` VALUES (512002, '雁江区', 512000, 1);
INSERT INTO `base_area` VALUES (511923, '平昌县', 511900, 4);
INSERT INTO `base_area` VALUES (511922, '南江县', 511900, 3);
INSERT INTO `base_area` VALUES (511921, '通江县', 511900, 2);
INSERT INTO `base_area` VALUES (511902, '巴州区', 511900, 1);
INSERT INTO `base_area` VALUES (511827, '宝兴县', 511800, 8);
INSERT INTO `base_area` VALUES (511826, '芦山县', 511800, 7);
INSERT INTO `base_area` VALUES (511825, '天全县', 511800, 6);
INSERT INTO `base_area` VALUES (511824, '石棉县', 511800, 5);
INSERT INTO `base_area` VALUES (511823, '汉源县', 511800, 4);
INSERT INTO `base_area` VALUES (511822, '荥经县', 511800, 3);
INSERT INTO `base_area` VALUES (511821, '名山县', 511800, 2);
INSERT INTO `base_area` VALUES (511802, '雨城区', 511800, 1);
INSERT INTO `base_area` VALUES (511781, '万源市', 511700, 7);
INSERT INTO `base_area` VALUES (511725, '渠县', 511700, 6);
INSERT INTO `base_area` VALUES (511724, '大竹县', 511700, 5);
INSERT INTO `base_area` VALUES (511723, '开江县', 511700, 4);
INSERT INTO `base_area` VALUES (511722, '宣汉县', 511700, 3);
INSERT INTO `base_area` VALUES (511721, '达县', 511700, 2);
INSERT INTO `base_area` VALUES (511702, '通川区', 511700, 1);
INSERT INTO `base_area` VALUES (511681, '华蓥市', 511600, 5);
INSERT INTO `base_area` VALUES (511623, '邻水县', 511600, 4);
INSERT INTO `base_area` VALUES (511622, '武胜县', 511600, 3);
INSERT INTO `base_area` VALUES (511621, '岳池县', 511600, 2);
INSERT INTO `base_area` VALUES (511602, '广安区', 511600, 1);
INSERT INTO `base_area` VALUES (511529, '屏山县', 511500, 10);
INSERT INTO `base_area` VALUES (511528, '兴文县', 511500, 9);
INSERT INTO `base_area` VALUES (511527, '筠连县', 511500, 8);
INSERT INTO `base_area` VALUES (511526, '珙县', 511500, 7);
INSERT INTO `base_area` VALUES (511525, '高县', 511500, 6);
INSERT INTO `base_area` VALUES (511524, '长宁县', 511500, 5);
INSERT INTO `base_area` VALUES (511523, '江安县', 511500, 4);
INSERT INTO `base_area` VALUES (511522, '南溪县', 511500, 3);
INSERT INTO `base_area` VALUES (511521, '宜宾县', 511500, 2);
INSERT INTO `base_area` VALUES (511502, '翠屏区', 511500, 1);
INSERT INTO `base_area` VALUES (511425, '青神县', 511400, 6);
INSERT INTO `base_area` VALUES (511424, '丹棱县', 511400, 5);
INSERT INTO `base_area` VALUES (511423, '洪雅县', 511400, 4);
INSERT INTO `base_area` VALUES (511422, '彭山县', 511400, 3);
INSERT INTO `base_area` VALUES (511421, '仁寿县', 511400, 2);
INSERT INTO `base_area` VALUES (511402, '东坡区', 511400, 1);
INSERT INTO `base_area` VALUES (511381, '阆中市', 511300, 9);
INSERT INTO `base_area` VALUES (511325, '西充县', 511300, 8);
INSERT INTO `base_area` VALUES (511324, '仪陇县', 511300, 7);
INSERT INTO `base_area` VALUES (511323, '蓬安县', 511300, 6);
INSERT INTO `base_area` VALUES (511322, '营山县', 511300, 5);
INSERT INTO `base_area` VALUES (511321, '南部县', 511300, 4);
INSERT INTO `base_area` VALUES (511304, '嘉陵区', 511300, 3);
INSERT INTO `base_area` VALUES (511303, '高坪区', 511300, 2);
INSERT INTO `base_area` VALUES (511302, '顺庆区', 511300, 1);
INSERT INTO `base_area` VALUES (511181, '峨眉山市', 511100, 11);
INSERT INTO `base_area` VALUES (511133, '马边彝族自治县', 511100, 10);
INSERT INTO `base_area` VALUES (511132, '