2020最新省市区县编码

本文整理了全国省市区街道地区编号，数据来源百度地图，自己整理一下，仅供参考

省

INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('110000', '北京市', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('120000', '天津市', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('130000', '河北省', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('140000', '山西省', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('150000', '内蒙古自治区', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('210000', '辽宁省', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('220000', '吉林省', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('230000', '黑龙江省', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('310000', '上海市', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('320000', '江苏省', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('330000', '浙江省', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('340000', '安徽省', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('350000', '福建省', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('360000', '江西省', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('370000', '山东省', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('410000', '河南省', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('420000', '湖北省', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('430000', '湖南省', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('440000', '广东省', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('450000', '广西壮族自治区', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('460000', '海南省', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('500000', '重庆市', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('510000', '四川省', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('520000', '贵州省', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('530000', '云南省', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('540000', '西藏自治区', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('610000', '陕西省', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('620000', '甘肃省', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('630000', '青海省', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('640000', '宁夏回族自治区', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('650000', '新疆维吾尔自治区', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('710000', '台湾省', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('810000', '香港', '0', '1');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('820000', '澳门', '0', '1');

市

INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('110100', '北京市', '110000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('120100', '天津市', '120000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('130100', '石家庄市', '130000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('130400', '邯郸市', '130000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('130600', '保定市', '130000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('130700', '张家口市', '130000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('130500', '邢台市', '130000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('130200', '唐山市', '130000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('130300', '秦皇岛市', '130000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('131000', '廊坊市', '130000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('131100', '衡水市', '130000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('130800', '承德市', '130000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('130900', '沧州市', '130000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('140300', '阳泉市', '140000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('140500', '晋城市', '140000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('141000', '临汾市', '140000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('140200', '大同市', '140000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('140400', '长治市', '140000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('141100', '吕梁市', '140000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('140100', '太原市', '140000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('140700', '晋中市', '140000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('140600', '朔州市', '140000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('140800', '运城市', '140000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('140900', '忻州市', '140000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('150700', '呼伦贝尔市', '150000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('150800', '巴彦淖尔市', '150000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('150200', '包头市', '150000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('150500', '通辽市', '150000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('152500', '锡林郭勒盟', '150000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('150100', '呼和浩特市', '150000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('152900', '阿拉善盟', '150000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('150400', '赤峰市', '150000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('150600', '鄂尔多斯市', '150000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('152200', '兴安盟', '150000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('150900', '乌兰察布市', '150000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('150300', '乌海市', '150000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('210500', '本溪市', '210000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('211300', '朝阳市', '210000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('210600', '丹东市', '210000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('210400', '抚顺市', '210000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('210900', '阜新市', '210000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('211400', '葫芦岛市', '210000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('210700', '锦州市', '210000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('211100', '盘锦市', '210000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('211200', '铁岭市', '210000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('210800', '营口市', '210000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('210300', '鞍山市', '210000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('210200', '大连市', '210000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('211000', '辽阳市', '210000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('210100', '沈阳市', '210000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('222400', '延边朝鲜族自治州', '220000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('220500', '通化市', '220000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('220700', '松原市', '220000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('220300', '四平市', '220000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('220400', '辽源市', '220000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('220800', '白城市', '220000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('220200', '吉林市', '220000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('220100', '长春市', '220000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('220600', '白山市', '220000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('232700', '大兴安岭地区', '230000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('230700', '伊春市', '230000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('230600', '大庆市', '230000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('230100', '哈尔滨市', '230000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('230400', '鹤岗市', '230000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('231100', '黑河市', '230000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('230300', '鸡西市', '230000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('230800', '佳木斯市', '230000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('231000', '牡丹江市', '230000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('230900', '七台河市', '230000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('230200', '齐齐哈尔市', '230000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('230500', '双鸭山市', '230000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('231200', '绥化市', '230000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('310100', '上海市', '310000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('320300', '徐州市', '320000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('320200', '无锡市', '320000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('320500', '苏州市', '320000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('320400', '常州市', '320000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('320800', '淮安市', '320000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('321000', '扬州市', '320000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('320900', '盐城市', '320000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('320700', '连云港市', '320000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('321300', '宿迁市', '320000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('320100', '南京市', '320000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('321100', '镇江市', '320000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('321200', '泰州市', '320000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('320600', '南通市', '320000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('330700', '金华市', '330000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('331000', '台州市', '330000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('330400', '嘉兴市', '330000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('331100', '丽水市', '330000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('330800', '衢州市', '330000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('330200', '宁波市', '330000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('330600', '绍兴市', '330000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('330100', '杭州市', '330000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('330500', '湖州市', '330000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('330300', '温州市', '330000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('330900', '舟山市', '330000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('340100', '合肥市', '340000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('341100', '滁州市', '340000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('340800', '安庆市', '340000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('340300', '蚌埠市', '340000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('341600', '亳州市', '340000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('341700', '池州市', '340000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('341200', '阜阳市', '340000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('340600', '淮北市', '340000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('340400', '淮南市', '340000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('341000', '黄山市', '340000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('341500', '六安市', '340000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('340500', '马鞍山市', '340000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('340700', '铜陵市', '340000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('340200', '芜湖市', '340000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('341300', '宿州市', '340000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('341800', '宣城市', '340000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('350900', '宁德市', '350000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('350300', '莆田市', '350000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('350400', '三明市', '350000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('350500', '泉州市', '350000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('350800', '龙岩市', '350000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('350100', '福州市', '350000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('350700', '南平市', '350000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('350200', '厦门市', '350000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('350600', '漳州市', '350000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('360200', '景德镇市', '360000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('360100', '南昌市', '360000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('361000', '抚州市', '360000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('360500', '新余市', '360000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('360300', '萍乡市', '360000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('360400', '九江市', '360000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('361100', '上饶市', '360000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('360800', '吉安市', '360000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('360900', '宜春市', '360000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('360700', '赣州市', '360000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('360600', '鹰潭市', '360000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('371100', '日照市', '370000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('370200', '青岛市', '370000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('370100', '济南市', '370000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('370700', '潍坊市', '370000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('370800', '济宁市', '370000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('370600', '烟台市', '370000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('371700', '菏泽市', '370000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('371600', '滨州市', '370000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('371400', '德州市', '370000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('370300', '淄博市', '370000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('370400', '枣庄市', '370000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('370900', '泰安市', '370000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('371500', '聊城市', '370000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('371000', '威海市', '370000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('371300', '临沂市', '370000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('370500', '东营市', '370000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('410600', '鹤壁市', '410000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('410800', '焦作市', '410000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('410200', '开封市', '410000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('411100', '漯河市', '410000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('411300', '南阳市', '410000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('410400', '平顶山市', '410000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('411200', '三门峡市', '410000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('411400', '商丘市', '410000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('419001', '济源市', '410000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('410700', '新乡市', '410000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('411500', '信阳市', '410000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('410100', '郑州市', '410000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('410500', '安阳市', '410000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('410300', '洛阳市', '410000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('411700', '驻马店市', '410000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('411600', '周口市', '410000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('411000', '许昌市', '410000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('410900', '濮阳市', '410000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('429004', '仙桃市', '420000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('420300', '十堰市', '420000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('420600', '襄阳市', '420000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('429021', '神农架林区', '420000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('421200', '咸宁市', '420000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('422800', '恩施土家族苗族自治州', '420000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('420900', '孝感市', '420000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('429006', '天门市', '420000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('420800', '荆门市', '420000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('420500', '宜昌市', '420000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('420100', '武汉市', '420000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('429005', '潜江市', '420000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('421000', '荆州市', '420000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('420700', '鄂州市', '420000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('421300', '随州市', '420000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('421100', '黄冈市', '420000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('420200', '黄石市', '420000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('430200', '株洲市', '430000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('430300', '湘潭市', '430000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('430100', '长沙市', '430000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('430600', '岳阳市', '430000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('433100', '湘西土家族苗族自治州', '430000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('430700', '常德市', '430000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('430400', '衡阳市', '430000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('431300', '娄底市', '430000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('431200', '怀化市', '430000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('431000', '郴州市', '430000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('430900', '益阳市', '430000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('431100', '永州市', '430000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('430800', '张家界市', '430000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('430500', '邵阳市', '430000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('441600', '河源市', '440000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('441700', '阳江市', '440000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('445300', '云浮市', '440000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('440800', '湛江市', '440000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('440700', '江门市', '440000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('442000', '中山市', '440000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('441900', '东莞市', '440000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('440300', '深圳市', '440000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('440500', '汕头市', '440000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('440100', '广州市', '440000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('441200', '肇庆市', '440000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('441300', '惠州市', '440000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('445200', '揭阳市', '440000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('441800', '清远市', '440000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('440600', '佛山市', '440000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('440400', '珠海市', '440000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('440200', '韶关市', '440000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('445100', '潮州市', '440000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('440900', '茂名市', '440000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('441400', '梅州市', '440000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('441500', '汕尾市', '440000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('451100', '贺州市', '450000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('450100', '南宁市', '450000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('450200', '柳州市', '450000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('450300', '桂林市', '450000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('451000', '百色市', '450000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('450500', '北海市', '450000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('450600', '防城港市', '450000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('450800', '贵港市', '450000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('451200', '河池市', '450000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('450700', '钦州市', '450000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('450400', '梧州市', '450000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('450900', '玉林市', '450000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('451400', '崇左市', '450000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('451300', '来宾市', '450000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('460100', '海口市', '460000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('460300', '三沙市', '460000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('460200', '三亚市', '460000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('469006', '万宁市', '460000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('469007', '东方市', '460000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('469024', '临高县', '460000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('469027', '乐东黎族自治县', '460000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('469001', '五指山市', '460000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('469029', '保亭黎族苗族自治县', '460000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('460400', '儋州市', '460000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('469021', '定安县', '460000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('469022', '屯昌县', '460000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('469005', '文昌市', '460000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('469026', '昌江黎族自治县', '460000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('469023', '澄迈县', '460000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('469030', '琼中黎族苗族自治县', '460000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('469002', '琼海市', '460000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('469025', '白沙黎族自治县', '460000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('469028', '陵水黎族自治县', '460000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('500100', '重庆市', '500000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('500200', '重庆市', '500000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('510800', '广元市', '510000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('511900', '巴中市', '510000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('511700', '达州市', '510000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('510700', '绵阳市', '510000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('511500', '宜宾市', '510000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('511400', '眉山市', '510000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('513400', '凉山彝族自治州', '510000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('511100', '乐山市', '510000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('510300', '自贡市', '510000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('510100', '成都市', '510000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('511800', '雅安市', '510000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('510600', '德阳市', '510000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('513200', '阿坝藏族羌族自治州', '510000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('513300', '甘孜藏族自治州', '510000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('511300', '南充市', '510000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('511600', '广安市', '510000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('510500', '泸州市', '510000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('511000', '内江市', '510000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('510400', '攀枝花市', '510000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('510900', '遂宁市', '510000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('512000', '资阳市', '510000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('520500', '毕节市', '520000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('520100', '贵阳市', '520000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('520400', '安顺市', '520000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('520200', '六盘水市', '520000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('522600', '黔东南苗族侗族自治州', '520000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('522700', '黔南布依族苗族自治州', '520000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('522300', '黔西南布依族苗族自治州', '520000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('520600', '铜仁市', '520000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('520300', '遵义市', '520000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('532900', '大理白族自治州', '530000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('532600', '文山壮族苗族自治州', '530000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('530900', '临沧市', '530000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('532800', '西双版纳傣族自治州', '530000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('533300', '怒江傈僳族自治州', '530000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('530100', '昆明市', '530000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('530300', '曲靖市', '530000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('530500', '保山市', '530000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('532300', '楚雄彝族自治州', '530000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('533100', '德宏傣族景颇族自治州', '530000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('533400', '迪庆藏族自治州', '530000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('532500', '红河哈尼族彝族自治州', '530000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('530700', '丽江市', '530000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('530800', '普洱市', '530000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('530400', '玉溪市', '530000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('530600', '昭通市', '530000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('540100', '拉萨市', '540000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('540300', '昌都市', '540000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('540400', '林芝市', '540000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('540500', '山南市', '540000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('540200', '日喀则市', '540000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('540600', '那曲市', '540000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('542500', '阿里地区', '540000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('610600', '延安市', '610000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('610800', '榆林市', '610000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('610100', '西安市', '610000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('610200', '铜川市', '610000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('610900', '安康市', '610000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('611000', '商洛市', '610000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('610400', '咸阳市', '610000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('610300', '宝鸡市', '610000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('610700', '汉中市', '610000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('610500', '渭南市', '610000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('620500', '天水市', '620000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('621100', '定西市', '620000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('621000', '庆阳市', '620000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('623000', '甘南藏族自治州', '620000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('620900', '酒泉市', '620000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('620700', '张掖市', '620000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('620300', '金昌市', '620000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('620600', '武威市', '620000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('620100', '兰州市', '620000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('620400', '白银市', '620000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('620800', '平凉市', '620000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('621200', '陇南市', '620000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('620200', '嘉峪关市', '620000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('622900', '临夏回族自治州', '620000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('632200', '海北藏族自治州', '630000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('630200', '海东市', '630000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('632500', '海南藏族自治州', '630000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('632800', '海西蒙古族藏族自治州', '630000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('632300', '黄南藏族自治州', '630000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('630100', '西宁市', '630000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('632600', '果洛藏族自治州', '630000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('632700', '玉树藏族自治州', '630000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('640400', '固原市', '640000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('640200', '石嘴山市', '640000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('640300', '吴忠市', '640000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('640100', '银川市', '640000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('640500', '中卫市', '640000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('652800', '巴音郭楞蒙古自治州', '650000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('652700', '博尔塔拉蒙古自治州', '650000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('652300', '昌吉回族自治州', '650000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('650500', '哈密市', '650000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('653200', '和田地区', '650000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('653100', '喀什地区', '650000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('654200', '塔城地区', '650000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('654300', '阿勒泰地区', '650000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('659000', '胡杨河市', '650000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('654000', '伊犁哈萨克自治州', '650000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('659009', '昆玉市', '650000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('652900', '阿克苏地区', '650000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('659002', '阿拉尔市', '650000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('653000', '克孜勒苏柯尔克孜自治州', '650000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('659005', '北屯市', '650000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('659006', '铁门关市', '650000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('659008', '可克达拉市', '650000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('650100', '乌鲁木齐市', '650000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('650400', '吐鲁番市', '650000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('650200', '克拉玛依市', '650000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('659004', '五家渠市', '650000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('659001', '石河子市', '650000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('659003', '图木舒克市', '650000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('659007', '双河市', '650000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('719003', '嘉义市', '710000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('710600', '桃园市', '710000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('710100', '台北市', '710000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('710400', '台中市', '710000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('710300', '新北市', '710000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('710500', '台南市', '710000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('719001', '基隆市', '710000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('710200', '高雄市', '710000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('719002', '新竹市', '710000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('719010', '嘉义县', '710000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('719008', '云林县', '710000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('719011', '屏东县', '710000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('719009', '南投县', '710000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('719013', '花莲县', '710000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('719007', '彰化县', '710000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('719012', '台东县', '710000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('719005', '宜兰县', '710000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('719006', '苗栗县', '710000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('719004', '新竹县', '710000', '2');
INSERT INTO `yijiao-gov`.`cn_area` (`id`, `name`, `pid`, `level`) VALUES ('719014', '澎湖县', '710000', '2');

以上只是省市的编码，市一下的地区无法全部显示，附百度网盘

链接：https://pan.baidu.com/s/1e93myKHZ4oA1AHeoWumhIg
提取码：8qkn