• mysql省市县数据库 枫


    CREATE TABLE `base_area` (
      `id` mediumint(12) unsigned NOT NULL auto_increment COMMENT 'id',
      `pid` int(12) NOT NULL COMMENT '父id',
      `name` varchar(60) NOT NULL COMMENT '名称',
      `display` tinyint(1) NOT NULL COMMENT '显示属性',
      PRIMARY KEY  (`id`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=gbk COMMENT='省市县数据表';
    数据:
    #省级
    INSERT INTO `base_area` SET `id`='1',`pid`='0',`name`='安徽';
    #省级
    INSERT INTO `base_area` SET `id`='2',`pid`='0',`name`='北京';
    #省级
    INSERT INTO `base_area` SET `id`='3',`pid`='0',`name`='福建';
    #省级
    INSERT INTO `base_area` SET `id`='4',`pid`='0',`name`='甘肃';
    #省级
    INSERT INTO `base_area` SET `id`='5',`pid`='0',`name`='广东';
    #省级
    INSERT INTO `base_area` SET `id`='6',`pid`='0',`name`='广西';
    #省级
    INSERT INTO `base_area` SET `id`='7',`pid`='0',`name`='贵州';
    #省级
    INSERT INTO `base_area` SET `id`='8',`pid`='0',`name`='海南';
    #省级
    INSERT INTO `base_area` SET `id`='9',`pid`='0',`name`='河北';
    #省级
    INSERT INTO `base_area` SET `id`='10',`pid`='0',`name`='河南';
    #省级
    INSERT INTO `base_area` SET `id`='11',`pid`='0',`name`='黑龙江';
    #省级
    INSERT INTO `base_area` SET `id`='12',`pid`='0',`name`='湖北';
    #省级
    INSERT INTO `base_area` SET `id`='13',`pid`='0',`name`='湖南';
    #省级
    INSERT INTO `base_area` SET `id`='14',`pid`='0',`name`='吉林';
    #省级
    INSERT INTO `base_area` SET `id`='15',`pid`='0',`name`='江苏';
    #省级
    INSERT INTO `base_area` SET `id`='16',`pid`='0',`name`='江西';
    #省级
    INSERT INTO `base_area` SET `id`='17',`pid`='0',`name`='辽宁';
    #省级
    INSERT INTO `base_area` SET `id`='18',`pid`='0',`name`='内蒙古';
    #省级
    INSERT INTO `base_area` SET `id`='19',`pid`='0',`name`='宁夏';
    #省级
    INSERT INTO `base_area` SET `id`='20',`pid`='0',`name`='青海';
    #省级
    INSERT INTO `base_area` SET `id`='21',`pid`='0',`name`='山东';
    #省级
    INSERT INTO `base_area` SET `id`='22',`pid`='0',`name`='山西';
    #省级
    INSERT INTO `base_area` SET `id`='23',`pid`='0',`name`='陕西';
    #省级
    INSERT INTO `base_area` SET `id`='24',`pid`='0',`name`='上海';
    #省级
    INSERT INTO `base_area` SET `id`='25',`pid`='0',`name`='四川';
    #省级
    INSERT INTO `base_area` SET `id`='26',`pid`='0',`name`='天津';
    #省级
    INSERT INTO `base_area` SET `id`='27',`pid`='0',`name`='西藏';
    #省级
    INSERT INTO `base_area` SET `id`='28',`pid`='0',`name`='新疆';
    #省级
    INSERT INTO `base_area` SET `id`='29',`pid`='0',`name`='云南';
    #省级
    INSERT INTO `base_area` SET `id`='30',`pid`='0',`name`='浙江';
    #省级
    INSERT INTO `base_area` SET `id`='31',`pid`='0',`name`='重庆';
    #市级1
    INSERT INTO `base_area` SET `id`='10000',`pid`='1',`name`='安庆';
    INSERT INTO `base_area` SET `id`='10001',`pid`='2',`name`='蚌埠';
    INSERT INTO `base_area` SET `id`='10002',`pid`='3',`name`='巢湖';
    INSERT INTO `base_area` SET `id`='10003',`pid`='4',`name`='池州';
    INSERT INTO `base_area` SET `id`='10004',`pid`='5',`name`='滁州';
    INSERT INTO `base_area` SET `id`='10005',`pid`='6',`name`='阜阳';
    INSERT INTO `base_area` SET `id`='10006',`pid`='7',`name`='合肥';
    INSERT INTO `base_area` SET `id`='10007',`pid`='8',`name`='淮北';
    INSERT INTO `base_area` SET `id`='10008',`pid`='9',`name`='淮南';
    INSERT INTO `base_area` SET `id`='10009',`pid`='10',`name`='黄山';
    INSERT INTO `base_area` SET `id`='10010',`pid`='11',`name`='六安';
    INSERT INTO `base_area` SET `id`='10011',`pid`='12',`name`='马鞍山';
    INSERT INTO `base_area` SET `id`='10012',`pid`='13',`name`='宿州';
    INSERT INTO `base_area` SET `id`='10013',`pid`='14',`name`='铜陵';
    INSERT INTO `base_area` SET `id`='10014',`pid`='15',`name`='芜湖';
    INSERT INTO `base_area` SET `id`='10015',`pid`='16',`name`='宣城';
    INSERT INTO `base_area` SET `id`='10016',`pid`='17',`name`='亳州';
    #县级10000
    INSERT INTO `base_area` SET `id`='100010',`pid`='10000',`name`='安庆市';
    INSERT INTO `base_area` SET `id`='100011',`pid`='10000',`name`='怀宁县';
    INSERT INTO `base_area` SET `id`='100012',`pid`='10000',`name`='潜山县';
    INSERT INTO `base_area` SET `id`='100013',`pid`='10000',`name`='宿松县';
    INSERT INTO `base_area` SET `id`='100014',`pid`='10000',`name`='太湖县';
    INSERT INTO `base_area` SET `id`='100015',`pid`='10000',`name`='桐城市';
    INSERT INTO `base_area` SET `id`='100016',`pid`='10000',`name`='望江县';
    INSERT INTO `base_area` SET `id`='100017',`pid`='10000',`name`='岳西县';
    INSERT INTO `base_area` SET `id`='100018',`pid`='10000',`name`='枞阳县';
    #县级10001
    INSERT INTO `base_area` SET `id`='100020',`pid`='10001',`name`='蚌埠市';
    INSERT INTO `base_area` SET `id`='100021',`pid`='10001',`name`='固镇县';
    INSERT INTO `base_area` SET `id`='100022',`pid`='10001',`name`='怀远县';
    INSERT INTO `base_area` SET `id`='100023',`pid`='10001',`name`='五河县';
    #县级10002
    INSERT INTO `base_area` SET `id`='100030',`pid`='10002',`name`='巢湖市';
    INSERT INTO `base_area` SET `id`='100031',`pid`='10002',`name`='含山县';
    INSERT INTO `base_area` SET `id`='100032',`pid`='10002',`name`='和县';
    INSERT INTO `base_area` SET `id`='100033',`pid`='10002',`name`='庐江县';
    INSERT INTO `base_area` SET `id`='100034',`pid`='10002',`name`='无为县';
    #县级10003
    INSERT INTO `base_area` SET `id`='100040',`pid`='10003',`name`='池州市';
    INSERT INTO `base_area` SET `id`='100041',`pid`='10003',`name`='东至县';
    INSERT INTO `base_area` SET `id`='100042',`pid`='10003',`name`='青阳县';
    INSERT INTO `base_area` SET `id`='100043',`pid`='10003',`name`='石台县';
    #县级10004
    INSERT INTO `base_area` SET `id`='100050',`pid`='10004',`name`='滁州市';
    INSERT INTO `base_area` SET `id`='100051',`pid`='10004',`name`='定远县';
    INSERT INTO `base_area` SET `id`='100052',`pid`='10004',`name`='凤阳县';
    INSERT INTO `base_area` SET `id`='100053',`pid`='10004',`name`='来安县';
    INSERT INTO `base_area` SET `id`='100054',`pid`='10004',`name`='明光市';
    INSERT INTO `base_area` SET `id`='100055',`pid`='10004',`name`='全椒县';
    INSERT INTO `base_area` SET `id`='100056',`pid`='10004',`name`='天长市';
    #县级10005
    INSERT INTO `base_area` SET `id`='100060',`pid`='10005',`name`='阜南县';
    INSERT INTO `base_area` SET `id`='100061',`pid`='10005',`name`='阜阳市';
    INSERT INTO `base_area` SET `id`='100062',`pid`='10005',`name`='界首市';
    INSERT INTO `base_area` SET `id`='100063',`pid`='10005',`name`='临泉县';
    INSERT INTO `base_area` SET `id`='100064',`pid`='10005',`name`='太和县';
    INSERT INTO `base_area` SET `id`='100065',`pid`='10005',`name`='颖上县';
    #县级10006
    INSERT INTO `base_area` SET `id`='100070',`pid`='10006',`name`='长丰县';
    INSERT INTO `base_area` SET `id`='100071',`pid`='10006',`name`='肥东县';
    INSERT INTO `base_area` SET `id`='100072',`pid`='10006',`name`='肥西县';
    #县级10007
    INSERT INTO `base_area` SET `id`='100080',`pid`='10007',`name`='淮北市';
    INSERT INTO `base_area` SET `id`='100081',`pid`='10007',`name`='濉溪县';
    #县级10008
    INSERT INTO `base_area` SET `id`='100090',`pid`='10008',`name`='凤台县';
    INSERT INTO `base_area` SET `id`='100091',`pid`='10008',`name`='淮南市';
    #县级10009
    INSERT INTO `base_area` SET `id`='100100',`pid`='10009',`name`='黄山市';
    INSERT INTO `base_area` SET `id`='100101',`pid`='10009',`name`='祁门县';
    INSERT INTO `base_area` SET `id`='100102',`pid`='10009',`name`='休宁县';
    INSERT INTO `base_area` SET `id`='100103',`pid`='10009',`name`='歙县';
    INSERT INTO `base_area` SET `id`='100104',`pid`='10009',`name`='黟县';
    #县级10010
    INSERT INTO `base_area` SET `id`='100110',`pid`='10010',`name`='霍邱县';
    INSERT INTO `base_area` SET `id`='100111',`pid`='10010',`name`='霍山县';
    INSERT INTO `base_area` SET `id`='100112',`pid`='10010',`name`='金寨县';
    INSERT INTO `base_area` SET `id`='100113',`pid`='10010',`name`='六安市';
    INSERT INTO `base_area` SET `id`='100114',`pid`='10010',`name`='寿县';
    INSERT INTO `base_area` SET `id`='100115',`pid`='10010',`name`='舒城县';
    #县级10011
    INSERT INTO `base_area` SET `id`='100120',`pid`='10011',`name`='当涂县';
    INSERT INTO `base_area` SET `id`='100121',`pid`='10011',`name`='马鞍山市';
    #县级10012
    INSERT INTO `base_area` SET `id`='100130',`pid`='10012',`name`='灵璧县';
    INSERT INTO `base_area` SET `id`='100131',`pid`='10012',`name`='宿州市';
    INSERT INTO `base_area` SET `id`='100132',`pid`='10012',`name`='萧县';
    INSERT INTO `base_area` SET `id`='100133',`pid`='10012',`name`='泗县';
    INSERT INTO `base_area` SET `id`='100134',`pid`='10012',`name`='砀山县';
    #县级10013
    INSERT INTO `base_area` SET `id`='100140',`pid`='10013',`name`='铜陵市';
    INSERT INTO `base_area` SET `id`='100141',`pid`='10013',`name`='铜陵县';
    #县级10014
    INSERT INTO `base_area` SET `id`='100150',`pid`='10014',`name`='繁昌县';
    INSERT INTO `base_area` SET `id`='100151',`pid`='10014',`name`='南陵县';
    INSERT INTO `base_area` SET `id`='100152',`pid`='10014',`name`='芜湖市';
    INSERT INTO `base_area` SET `id`='100153',`pid`='10014',`name`='芜湖县';
    #县级10015
    INSERT INTO `base_area` SET `id`='100160',`pid`='10015',`name`='广德县';
    INSERT INTO `base_area` SET `id`='100161',`pid`='10015',`name`='绩溪县';
    INSERT INTO `base_area` SET `id`='100162',`pid`='10015',`name`='郎溪县';
    INSERT INTO `base_area` SET `id`='100163',`pid`='10015',`name`='宁国市';
    INSERT INTO `base_area` SET `id`='100164',`pid`='10015',`name`='宣城市';
    INSERT INTO `base_area` SET `id`='100165',`pid`='10015',`name`='泾县';
    INSERT INTO `base_area` SET `id`='100166',`pid`='10015',`name`='旌德县';
    #县级10016
    INSERT INTO `base_area` SET `id`='100170',`pid`='10016',`name`='利辛县';
    INSERT INTO `base_area` SET `id`='100171',`pid`='10016',`name`='蒙城县';
    INSERT INTO `base_area` SET `id`='100172',`pid`='10016',`name`='涡阳县';
    INSERT INTO `base_area` SET `id`='100173',`pid`='10016',`name`='亳州市';
    #市级2
    INSERT INTO `base_area` SET `id`='20000',`pid`='2',`name`='北京';
    #县级20000
    INSERT INTO `base_area` SET `id`='200010',`pid`='20000',`name`='北京市';
    INSERT INTO `base_area` SET `id`='200011',`pid`='20000',`name`='密云县';
    INSERT INTO `base_area` SET `id`='200012',`pid`='20000',`name`='延庆县';
    #市级3
    INSERT INTO `base_area` SET `id`='30000',`pid`='3',`name`='福州';
    INSERT INTO `base_area` SET `id`='30001',`pid`='4',`name`='龙岩';
    INSERT INTO `base_area` SET `id`='30002',`pid`='5',`name`='南平';
    INSERT INTO `base_area` SET `id`='30003',`pid`='6',`name`='宁德';
    INSERT INTO `base_area` SET `id`='30004',`pid`='7',`name`='莆田';
    INSERT INTO `base_area` SET `id`='30005',`pid`='8',`name`='泉州';
    INSERT INTO `base_area` SET `id`='30006',`pid`='9',`name`='三明';
    INSERT INTO `base_area` SET `id`='30007',`pid`='10',`name`='厦门';
    INSERT INTO `base_area` SET `id`='30008',`pid`='11',`name`='漳州';
    #县级30000
    INSERT INTO `base_area` SET `id`='300010',`pid`='30000',`name`='长乐市';
    INSERT INTO `base_area` SET `id`='300011',`pid`='30000',`name`='福清市';
    INSERT INTO `base_area` SET `id`='300012',`pid`='30000',`name`='福州市';
    INSERT INTO `base_area` SET `id`='300013',`pid`='30000',`name`='连江县';
    INSERT INTO `base_area` SET `id`='300014',`pid`='30000',`name`='罗源县';
    INSERT INTO `base_area` SET `id`='300015',`pid`='30000',`name`='闽侯县';
    INSERT INTO `base_area` SET `id`='300016',`pid`='30000',`name`='闽清县';
    INSERT INTO `base_area` SET `id`='300017',`pid`='30000',`name`='平潭县';
    INSERT INTO `base_area` SET `id`='300018',`pid`='30000',`name`='永泰县';
    #县级30001
    INSERT INTO `base_area` SET `id`='300020',`pid`='30001',`name`='长汀县';
    INSERT INTO `base_area` SET `id`='300021',`pid`='30001',`name`='连城县';
    INSERT INTO `base_area` SET `id`='300022',`pid`='30001',`name`='龙岩市';
    INSERT INTO `base_area` SET `id`='300023',`pid`='30001',`name`='上杭县';
    INSERT INTO `base_area` SET `id`='300024',`pid`='30001',`name`='武平县';
    INSERT INTO `base_area` SET `id`='300025',`pid`='30001',`name`='永定县';
    INSERT INTO `base_area` SET `id`='300026',`pid`='30001',`name`='漳平市';
    #县级30002
    INSERT INTO `base_area` SET `id`='300030',`pid`='30002',`name`='光泽县';
    INSERT INTO `base_area` SET `id`='300031',`pid`='30002',`name`='建阳市';
    INSERT INTO `base_area` SET `id`='300032',`pid`='30002',`name`='建瓯市';
    INSERT INTO `base_area` SET `id`='300033',`pid`='30002',`name`='南平市';
    INSERT INTO `base_area` SET `id`='300034',`pid`='30002',`name`='浦城县';
    INSERT INTO `base_area` SET `id`='300035',`pid`='30002',`name`='邵武市';
    INSERT INTO `base_area` SET `id`='300036',`pid`='30002',`name`='顺昌县';
    INSERT INTO `base_area` SET `id`='300037',`pid`='30002',`name`='松溪县';
    INSERT INTO `base_area` SET `id`='300038',`pid`='30002',`name`='武夷山市';
    INSERT INTO `base_area` SET `id`='300039',`pid`='30002',`name`='政和县';
    #县级30003
    INSERT INTO `base_area` SET `id`='300040',`pid`='30003',`name`='福安市';
    INSERT INTO `base_area` SET `id`='300041',`pid`='30003',`name`='福鼎市';
    INSERT INTO `base_area` SET `id`='300042',`pid`='30003',`name`='古田县';
    INSERT INTO `base_area` SET `id`='300043',`pid`='30003',`name`='宁德市';
    INSERT INTO `base_area` SET `id`='300044',`pid`='30003',`name`='屏南县';
    INSERT INTO `base_area` SET `id`='300045',`pid`='30003',`name`='寿宁县';
    INSERT INTO `base_area` SET `id`='300046',`pid`='30003',`name`='霞浦县';
    INSERT INTO `base_area` SET `id`='300047',`pid`='30003',`name`='周宁县';
    INSERT INTO `base_area` SET `id`='300048',`pid`='30003',`name`='柘荣县';
    #县级30004
    INSERT INTO `base_area` SET `id`='300050',`pid`='30004',`name`='莆田市';
    INSERT INTO `base_area` SET `id`='300051',`pid`='30004',`name`='仙游县';
    #县级30005
    INSERT INTO `base_area` SET `id`='300060',`pid`='30005',`name`='安溪县';
    INSERT INTO `base_area` SET `id`='300061',`pid`='30005',`name`='德化县';
    INSERT INTO `base_area` SET `id`='300062',`pid`='30005',`name`='惠安县';
    INSERT INTO `base_area` SET `id`='300063',`pid`='30005',`name`='金门县';
    INSERT INTO `base_area` SET `id`='300064',`pid`='30005',`name`='晋江市';
    INSERT INTO `base_area` SET `id`='300065',`pid`='30005',`name`='南安市';
    INSERT INTO `base_area` SET `id`='300066',`pid`='30005',`name`='泉州市';
    INSERT INTO `base_area` SET `id`='300067',`pid`='30005',`name`='石狮市';
    INSERT INTO `base_area` SET `id`='300068',`pid`='30005',`name`='永春县';
    #县级30006
    INSERT INTO `base_area` SET `id`='300070',`pid`='30006',`name`='大田县';
    INSERT INTO `base_area` SET `id`='300071',`pid`='30006',`name`='建宁县';
    INSERT INTO `base_area` SET `id`='300072',`pid`='30006',`name`='将乐县';
    INSERT INTO `base_area` SET `id`='300073',`pid`='30006',`name`='明溪县';
    INSERT INTO `base_area` SET `id`='300074',`pid`='30006',`name`='宁化县';
    INSERT INTO `base_area` SET `id`='300075',`pid`='30006',`name`='清流县';
    INSERT INTO `base_area` SET `id`='300076',`pid`='30006',`name`='三明市';
    INSERT INTO `base_area` SET `id`='300077',`pid`='30006',`name`='沙县';
    INSERT INTO `base_area` SET `id`='300078',`pid`='30006',`name`='泰宁县';
    INSERT INTO `base_area` SET `id`='300079',`pid`='30006',`name`='永安市';
    INSERT INTO `base_area` SET `id`='300080',`pid`='30006',`name`='尤溪县';
    #县级30007
    INSERT INTO `base_area` SET `id`='300081',`pid`='30007',`name`='厦门市';
    #县级30008
    INSERT INTO `base_area` SET `id`='300090',`pid`='30008',`name`='长泰县';
    INSERT INTO `base_area` SET `id`='300091',`pid`='30008',`name`='东山县';
    INSERT INTO `base_area` SET `id`='300092',`pid`='30008',`name`='华安县';
    INSERT INTO `base_area` SET `id`='300093',`pid`='30008',`name`='龙海市';
    INSERT INTO `base_area` SET `id`='300094',`pid`='30008',`name`='南靖县';
    INSERT INTO `base_area` SET `id`='300095',`pid`='30008',`name`='平和县';
    INSERT INTO `base_area` SET `id`='300096',`pid`='30008',`name`='云霄县';
    INSERT INTO `base_area` SET `id`='300097',`pid`='30008',`name`='漳浦县';
    INSERT INTO `base_area` SET `id`='300098',`pid`='30008',`name`='漳州市';
    INSERT INTO `base_area` SET `id`='300099',`pid`='30008',`name`='诏安县';
    #市级4
    INSERT INTO `base_area` SET `id`='40000',`pid`='4',`name`='白银';
    INSERT INTO `base_area` SET `id`='40001',`pid`='5',`name`='定西';
    INSERT INTO `base_area` SET `id`='40002',`pid`='6',`name`='甘南藏族自治州';
    INSERT INTO `base_area` SET `id`='40003',`pid`='7',`name`='嘉峪关';
    INSERT INTO `base_area` SET `id`='40004',`pid`='8',`name`='金昌';
    INSERT INTO `base_area` SET `id`='40005',`pid`='9',`name`='酒泉';
    INSERT INTO `base_area` SET `id`='40006',`pid`='10',`name`='兰州';
    INSERT INTO `base_area` SET `id`='40007',`pid`='11',`name`='临夏回族自治州';
    INSERT INTO `base_area` SET `id`='40008',`pid`='12',`name`='陇南';
    INSERT INTO `base_area` SET `id`='40009',`pid`='13',`name`='平凉';
    INSERT INTO `base_area` SET `id`='40010',`pid`='14',`name`='庆阳';
    INSERT INTO `base_area` SET `id`='40011',`pid`='15',`name`='天水';
    INSERT INTO `base_area` SET `id`='40012',`pid`='16',`name`='武威';
    INSERT INTO `base_area` SET `id`='40013',`pid`='17',`name`='张掖';
    #县级40000
    INSERT INTO `base_area` SET `id`='400010',`pid`='40000',`name`='白银市';
    INSERT INTO `base_area` SET `id`='400011',`pid`='40000',`name`='会宁县';
    INSERT INTO `base_area` SET `id`='400012',`pid`='40000',`name`='景泰县';
    INSERT INTO `base_area` SET `id`='400013',`pid`='40000',`name`='靖远县';
    #县级40001
    INSERT INTO `base_area` SET `id`='400020',`pid`='40001',`name`='定西县';
    INSERT INTO `base_area` SET `id`='400021',`pid`='40001',`name`='临洮县';
    INSERT INTO `base_area` SET `id`='400022',`pid`='40001',`name`='陇西县';
    INSERT INTO `base_area` SET `id`='400023',`pid`='40001',`name`='通渭县';
    INSERT INTO `base_area` SET `id`='400024',`pid`='40001',`name`='渭源县';
    INSERT INTO `base_area` SET `id`='400025',`pid`='40001',`name`='漳县';
    INSERT INTO `base_area` SET `id`='400026',`pid`='40001',`name`='岷县';
    #县级40002
    INSERT INTO `base_area` SET `id`='400030',`pid`='40002',`name`='迭部县';
    INSERT INTO `base_area` SET `id`='400031',`pid`='40002',`name`='合作市';
    INSERT INTO `base_area` SET `id`='400032',`pid`='40002',`name`='临潭县';
    INSERT INTO `base_area` SET `id`='400033',`pid`='40002',`name`='碌曲县';
    INSERT INTO `base_area` SET `id`='400034',`pid`='40002',`name`='玛曲县';
    INSERT INTO `base_area` SET `id`='400035',`pid`='40002',`name`='夏河县';
    INSERT INTO `base_area` SET `id`='400036',`pid`='40002',`name`='舟曲县';
    INSERT INTO `base_area` SET `id`='400037',`pid`='40002',`name`='卓尼县';
    #县级40003
    INSERT INTO `base_area` SET `id`='400040',`pid`='40003',`name`='嘉峪关市';
    #县级40004
    INSERT INTO `base_area` SET `id`='400050',`pid`='40004',`name`='金昌市';
    INSERT INTO `base_area` SET `id`='400051',`pid`='40004',`name`='永昌县';
    #县级40005
    INSERT INTO `base_area` SET `id`='400060',`pid`='40005',`name`='阿克塞哈萨克族自治县';
    INSERT INTO `base_area` SET `id`='400061',`pid`='40005',`name`='安西县';
    INSERT INTO `base_area` SET `id`='400062',`pid`='40005',`name`='敦煌市';
    INSERT INTO `base_area` SET `id`='400063',`pid`='40005',`name`='金塔县';
    INSERT INTO `base_area` SET `id`='400064',`pid`='40005',`name`='酒泉市';
    INSERT INTO `base_area` SET `id`='400065',`pid`='40005',`name`='肃北蒙古族自治县';
    INSERT INTO `base_area` SET `id`='400066',`pid`='40005',`name`='玉门市';
    #县级40006
    INSERT INTO `base_area` SET `id`='400070',`pid`='40006',`name`='皋兰县';
    INSERT INTO `base_area` SET `id`='400071',`pid`='40006',`name`='兰州市';
    INSERT INTO `base_area` SET `id`='400072',`pid`='40006',`name`='永登县';
    INSERT INTO `base_area` SET `id`='400073',`pid`='40006',`name`='榆中县';
    #县级40007
    INSERT INTO `base_area` SET `id`='400080',`pid`='40007',`name`='东乡族自治县';
    INSERT INTO `base_area` SET `id`='400081',`pid`='40007',`name`='广河县';
    INSERT INTO `base_area` SET `id`='400082',`pid`='40007',`name`='和政县';
    INSERT INTO `base_area` SET `id`='400083',`pid`='40007',`name`='积石山保安族东乡族撒拉族自治县';
    INSERT INTO `base_area` SET `id`='400084',`pid`='40007',`name`='康乐县';
    INSERT INTO `base_area` SET `id`='400085',`pid`='40007',`name`='临夏市';
    INSERT INTO `base_area` SET `id`='400086',`pid`='40007',`name`='临夏县';
    INSERT INTO `base_area` SET `id`='400087',`pid`='40007',`name`='永靖县';
    #县级40008
    INSERT INTO `base_area` SET `id`='400090',`pid`='40008',`name`='成县';
    INSERT INTO `base_area` SET `id`='400091',`pid`='40008',`name`='徽县';
    INSERT INTO `base_area` SET `id`='400092',`pid`='40008',`name`='康县';
    INSERT INTO `base_area` SET `id`='400093',`pid`='40008',`name`='礼县';
    INSERT INTO `base_area` SET `id`='400094',`pid`='40008',`name`='两当县';
    INSERT INTO `base_area` SET `id`='400095',`pid`='40008',`name`='文县';
    INSERT INTO `base_area` SET `id`='400096',`pid`='40008',`name`='武都县';
    INSERT INTO `base_area` SET `id`='400097',`pid`='40008',`name`='西和县';
    INSERT INTO `base_area` SET `id`='400098',`pid`='40008',`name`='宕昌县';
    #县级40009
    INSERT INTO `base_area` SET `id`='400100',`pid`='40009',`name`='崇信县';
    INSERT INTO `base_area` SET `id`='400101',`pid`='40009',`name`='华亭县';
    INSERT INTO `base_area` SET `id`='400102',`pid`='40009',`name`='静宁县';
    INSERT INTO `base_area` SET `id`='400103',`pid`='40009',`name`='灵台县';
    INSERT INTO `base_area` SET `id`='400104',`pid`='40009',`name`='平凉市';
    INSERT INTO `base_area` SET `id`='400105',`pid`='40009',`name`='庄浪县';
    INSERT INTO `base_area` SET `id`='400106',`pid`='40009',`name`='泾川县';
    #县级40010
    INSERT INTO `base_area` SET `id`='400110',`pid`='40010',`name`='合水县';
    INSERT INTO `base_area` SET `id`='400111',`pid`='40010',`name`='华池县';
    INSERT INTO `base_area` SET `id`='400112',`pid`='40010',`name`='环县';
    INSERT INTO `base_area` SET `id`='400113',`pid`='40010',`name`='宁县';
    INSERT INTO `base_area` SET `id`='400114',`pid`='40010',`name`='庆城县';
    INSERT INTO `base_area` SET `id`='400115',`pid`='40010',`name`='庆阳市';
    INSERT INTO `base_area` SET `id`='400116',`pid`='40010',`name`='镇原县';
    INSERT INTO `base_area` SET `id`='400117',`pid`='40010',`name`='正宁县';
    #县级40011
    INSERT INTO `base_area` SET `id`='400120',`pid`='40011',`name`='甘谷县';
    INSERT INTO `base_area` SET `id`='400121',`pid`='40011',`name`='秦安县';
    INSERT INTO `base_area` SET `id`='400122',`pid`='40011',`name`='清水县';
    INSERT INTO `base_area` SET `id`='400123',`pid`='40011',`name`='天水市';
    INSERT INTO `base_area` SET `id`='400124',`pid`='40011',`name`='武山县';
    INSERT INTO `base_area` SET `id`='400125',`pid`='40011',`name`='张家川回族自治县';
    #县级40012
    INSERT INTO `base_area` SET `id`='400130',`pid`='40012',`name`='古浪县';
    INSERT INTO `base_area` SET `id`='400131',`pid`='40012',`name`='民勤县';
    INSERT INTO `base_area` SET `id`='400132',`pid`='40012',`name`='天祝藏族自治县';
    INSERT INTO `base_area` SET `id`='400133',`pid`='40012',`name`='武威市';
    #县级40013
    INSERT INTO `base_area` SET `id`='400140',`pid`='40013',`name`='高台县';
    INSERT INTO `base_area` SET `id`='400141',`pid`='40013',`name`='临泽县';
    INSERT INTO `base_area` SET `id`='400142',`pid`='40013',`name`='民乐县';
    INSERT INTO `base_area` SET `id`='400143',`pid`='40013',`name`='山丹县';
    INSERT INTO `base_area` SET `id`='400144',`pid`='40013',`name`='肃南裕固族自治县';
    INSERT INTO `base_area` SET `id`='400145',`pid`='40013',`name`='张掖市';
    #市级5
    INSERT INTO `base_area` SET `id`='50000',`pid`='5',`name`='潮州';
    INSERT INTO `base_area` SET `id`='50001',`pid`='6',`name`='东莞';
    INSERT INTO `base_area` SET `id`='50002',`pid`='7',`name`='佛山';
    INSERT INTO `base_area` SET `id`='50003',`pid`='8',`name`='广州';
    INSERT INTO `base_area` SET `id`='50004',`pid`='9',`name`='河源';
    INSERT INTO `base_area` SET `id`='50005',`pid`='10',`name`='惠州';
    INSERT INTO `base_area` SET `id`='50006',`pid`='11',`name`='江门';
    INSERT INTO `base_area` SET `id`='50007',`pid`='12',`name`='揭阳';
    INSERT INTO `base_area` SET `id`='50008',`pid`='13',`name`='茂名';
    INSERT INTO `base_area` SET `id`='50009',`pid`='14',`name`='梅州';
    INSERT INTO `base_area` SET `id`='50010',`pid`='15',`name`='清远';
    INSERT INTO `base_area` SET `id`='50011',`pid`='16',`name`='汕头';
    INSERT INTO `base_area` SET `id`='50012',`pid`='17',`name`='汕尾';
    INSERT INTO `base_area` SET `id`='50013',`pid`='18',`name`='韶关';
    INSERT INTO `base_area` SET `id`='50014',`pid`='19',`name`='深圳';
    INSERT INTO `base_area` SET `id`='50015',`pid`='20',`name`='阳江';
    INSERT INTO `base_area` SET `id`='50016',`pid`='21',`name`='云浮';
    INSERT INTO `base_area` SET `id`='50017',`pid`='22',`name`='湛江';
    INSERT INTO `base_area` SET `id`='50018',`pid`='23',`name`='肇庆';
    INSERT INTO `base_area` SET `id`='50019',`pid`='24',`name`='中山';
    INSERT INTO `base_area` SET `id`='50020',`pid`='25',`name`='珠海';
    #县级50000
    INSERT INTO `base_area` SET `id`='500010',`pid`='50000',`name`='潮安县';
    INSERT INTO `base_area` SET `id`='500011',`pid`='50000',`name`='潮州市';
    INSERT INTO `base_area` SET `id`='500012',`pid`='50000',`name`='饶平县';
    #县级50001
    INSERT INTO `base_area` SET `id`='500020',`pid`='50001',`name`='东莞市';
    #县级50002
    INSERT INTO `base_area` SET `id`='500030',`pid`='50002',`name`='佛山市';
    #县级50003
    INSERT INTO `base_area` SET `id`='500040',`pid`='50003',`name`='从化市';
    INSERT INTO `base_area` SET `id`='500041',`pid`='50003',`name`='广州市';
    INSERT INTO `base_area` SET `id`='500042',`pid`='50003',`name`='增城市';
    #县级50004
    INSERT INTO `base_area` SET `id`='500050',`pid`='50004',`name`='东源县';
    INSERT INTO `base_area` SET `id`='500051',`pid`='50004',`name`='和平县';
    INSERT INTO `base_area` SET `id`='500052',`pid`='50004',`name`='河源市';
    INSERT INTO `base_area` SET `id`='500053',`pid`='50004',`name`='连平县';
    INSERT INTO `base_area` SET `id`='500054',`pid`='50004',`name`='龙川县';
    INSERT INTO `base_area` SET `id`='500055',`pid`='50004',`name`='紫金县';
    #县级50005
    INSERT INTO `base_area` SET `id`='500060',`pid`='50005',`name`='博罗县';
    INSERT INTO `base_area` SET `id`='500061',`pid`='50005',`name`='惠东县';
    INSERT INTO `base_area` SET `id`='500062',`pid`='50005',`name`='惠阳市';
    INSERT INTO `base_area` SET `id`='500063',`pid`='50005',`name`='惠州市';
    INSERT INTO `base_area` SET `id`='500064',`pid`='50005',`name`='龙门县';
    #县级50006
    INSERT INTO `base_area` SET `id`='500070',`pid`='50006',`name`='恩平市';
    INSERT INTO `base_area` SET `id`='500071',`pid`='50006',`name`='鹤山市';
    INSERT INTO `base_area` SET `id`='500072',`pid`='50006',`name`='江门市';
    INSERT INTO `base_area` SET `id`='500073',`pid`='50006',`name`='开平市';
    INSERT INTO `base_area` SET `id`='500074',`pid`='50006',`name`='台山市';
    #县级50007
    INSERT INTO `base_area` SET `id`='500080',`pid`='50007',`name`='惠来县';
    INSERT INTO `base_area` SET `id`='500081',`pid`='50007',`name`='揭东县';
    INSERT INTO `base_area` SET `id`='500082',`pid`='50007',`name`='揭西县';
    INSERT INTO `base_area` SET `id`='500083',`pid`='50007',`name`='揭阳市';
    INSERT INTO `base_area` SET `id`='500084',`pid`='50007',`name`='普宁市';
    #县级50008
    INSERT INTO `base_area` SET `id`='500090',`pid`='50008',`name`='电白县';
    INSERT INTO `base_area` SET `id`='500091',`pid`='50008',`name`='高州市';
    INSERT INTO `base_area` SET `id`='500092',`pid`='50008',`name`='化州市';
    INSERT INTO `base_area` SET `id`='500093',`pid`='50008',`name`='茂名市';
    INSERT INTO `base_area` SET `id`='500094',`pid`='50008',`name`='信宜市';
    #县级50009
    INSERT INTO `base_area` SET `id`='500100',`pid`='50009',`name`='大埔县';
    INSERT INTO `base_area` SET `id`='500101',`pid`='50009',`name`='丰顺县';
    INSERT INTO `base_area` SET `id`='500102',`pid`='50009',`name`='蕉岭县';
    INSERT INTO `base_area` SET `id`='500103',`pid`='50009',`name`='梅县';
    INSERT INTO `base_area` SET `id`='500104',`pid`='50009',`name`='梅州市';
    INSERT INTO `base_area` SET `id`='500105',`pid`='50009',`name`='平远县';
    INSERT INTO `base_area` SET `id`='500106',`pid`='50009',`name`='五华县';
    INSERT INTO `base_area` SET `id`='500107',`pid`='50009',`name`='兴宁市';
    #县级50010
    INSERT INTO `base_area` SET `id`='500110',`pid`='50010',`name`='佛冈县';
    INSERT INTO `base_area` SET `id`='500111',`pid`='50010',`name`='连南瑶族自治县';
    INSERT INTO `base_area` SET `id`='500112',`pid`='50010',`name`='连山壮族瑶族自治县';
    INSERT INTO `base_area` SET `id`='500113',`pid`='50010',`name`='连州市';
    INSERT INTO `base_area` SET `id`='500114',`pid`='50010',`name`='清新县';
    INSERT INTO `base_area` SET `id`='500115',`pid`='50010',`name`='清远市';
    INSERT INTO `base_area` SET `id`='500116',`pid`='50010',`name`='阳山县';
    INSERT INTO `base_area` SET `id`='500117',`pid`='50010',`name`='英德市';
    #县级50011
    INSERT INTO `base_area` SET `id`='500120',`pid`='50011',`name`='潮阳市';
    INSERT INTO `base_area` SET `id`='500121',`pid`='50011',`name`='澄海市';
    INSERT INTO `base_area` SET `id`='500122',`pid`='50011',`name`='南澳县';
    INSERT INTO `base_area` SET `id`='500123',`pid`='50011',`name`='汕头市';
    #县级50012
    INSERT INTO `base_area` SET `id`='500130',`pid`='50012',`name`='海丰县';
    INSERT INTO `base_area` SET `id`='500131',`pid`='50012',`name`='陆丰市';
    INSERT INTO `base_area` SET `id`='500132',`pid`='50012',`name`='陆河县';
    INSERT INTO `base_area` SET `id`='500133',`pid`='50012',`name`='汕尾市';
    #县级50013
    INSERT INTO `base_area` SET `id`='500140',`pid`='50013',`name`='乐昌市';
    INSERT INTO `base_area` SET `id`='500141',`pid`='50013',`name`='南雄市';
    INSERT INTO `base_area` SET `id`='500142',`pid`='50013',`name`='曲江县';
    INSERT INTO `base_area` SET `id`='500143',`pid`='50013',`name`='仁化县';
    INSERT INTO `base_area` SET `id`='500144',`pid`='50013',`name`='乳源瑶族自治县';
    INSERT INTO `base_area` SET `id`='500145',`pid`='50013',`name`='韶关市';
    INSERT INTO `base_area` SET `id`='500146',`pid`='50013',`name`='始兴县';
    INSERT INTO `base_area` SET `id`='500147',`pid`='50013',`name`='翁源县';
    INSERT INTO `base_area` SET `id`='500148',`pid`='50013',`name`='新丰县';
    #县级50014
    INSERT INTO `base_area` SET `id`='500150',`pid`='50014',`name`='深圳市';
    #县级50015
    INSERT INTO `base_area` SET `id`='500160',`pid`='50015',`name`='阳春市';
    INSERT INTO `base_area` SET `id`='500161',`pid`='50015',`name`='阳东县';
    INSERT INTO `base_area` SET `id`='500162',`pid`='50015',`name`='阳江市';
    INSERT INTO `base_area` SET `id`='500163',`pid`='50015',`name`='阳西县';
    #县级50016
    INSERT INTO `base_area` SET `id`='500170',`pid`='50016',`name`='罗定市';
    INSERT INTO `base_area` SET `id`='500171',`pid`='50016',`name`='新兴县';
    INSERT INTO `base_area` SET `id`='500172',`pid`='50016',`name`='郁南县';
    INSERT INTO `base_area` SET `id`='500173',`pid`='50016',`name`='云安县';
    INSERT INTO `base_area` SET `id`='500174',`pid`='50016',`name`='云浮市';
    #县级50017
    INSERT INTO `base_area` SET `id`='500180',`pid`='50017',`name`='雷州市';
    INSERT INTO `base_area` SET `id`='500181',`pid`='50017',`name`='廉江市';
    INSERT INTO `base_area` SET `id`='500182',`pid`='50017',`name`='遂溪县';
    INSERT INTO `base_area` SET `id`='500183',`pid`='50017',`name`='吴川市';
    INSERT INTO `base_area` SET `id`='500184',`pid`='50017',`name`='徐闻县';
    INSERT INTO `base_area` SET `id`='500185',`pid`='50017',`name`='湛江市';
    #县级50018
    INSERT INTO `base_area` SET `id`='500190',`pid`='50018',`name`='德庆县';
    INSERT INTO `base_area` SET `id`='500191',`pid`='50018',`name`='封开县';
    INSERT INTO `base_area` SET `id`='500192',`pid`='50018',`name`='高要市';
    INSERT INTO `base_area` SET `id`='500193',`pid`='50018',`name`='广宁县';
    INSERT INTO `base_area` SET `id`='500194',`pid`='50018',`name`='怀集县';
    INSERT INTO `base_area` SET `id`='500195',`pid`='50018',`name`='四会市';
    INSERT INTO `base_area` SET `id`='500196',`pid`='50018',`name`='肇庆市';
    #县级50019
    INSERT INTO `base_area` SET `id`='500200',`pid`='50019',`name`='中山市';
    #县级50020
    INSERT INTO `base_area` SET `id`='500210',`pid`='50020',`name`='珠海市';
    #市级6
    INSERT INTO `base_area` SET `id`='60000',`pid`='6',`name`='百色';
    INSERT INTO `base_area` SET `id`='60001',`pid`='7',`name`='北海';
    INSERT INTO `base_area` SET `id`='60002',`pid`='8',`name`='崇左';
    INSERT INTO `base_area` SET `id`='60003',`pid`='9',`name`='防城港';
    INSERT INTO `base_area` SET `id`='60004',`pid`='10',`name`='桂林';
    INSERT INTO `base_area` SET `id`='60005',`pid`='11',`name`='贵港';
    INSERT INTO `base_area` SET `id`='60006',`pid`='12',`name`='河池';
    INSERT INTO `base_area` SET `id`='60007',`pid`='13',`name`='贺州';
    INSERT INTO `base_area` SET `id`='60008',`pid`='14',`name`='来宾';
    INSERT INTO `base_area` SET `id`='60009',`pid`='15',`name`='柳州';
    INSERT INTO `base_area` SET `id`='60010',`pid`='16',`name`='南宁';
    INSERT INTO `base_area` SET `id`='60011',`pid`='17',`name`='钦州';
    INSERT INTO `base_area` SET `id`='60012',`pid`='18',`name`='梧州';
    INSERT INTO `base_area` SET `id`='60013',`pid`='19',`name`='玉林';
    #县级60000
    INSERT INTO `base_area` SET `id`='600010',`pid`='60000',`name`='百色市';
    INSERT INTO `base_area` SET `id`='600011',`pid`='60000',`name`='德保县';
    INSERT INTO `base_area` SET `id`='600012',`pid`='60000',`name`='靖西县';
    INSERT INTO `base_area` SET `id`='600013',`pid`='60000',`name`='乐业县';
    INSERT INTO `base_area` SET `id`='600014',`pid`='60000',`name`='凌云县';
    INSERT INTO `base_area` SET `id`='600015',`pid`='60000',`name`='隆林各族自治县';
    INSERT INTO `base_area` SET `id`='600016',`pid`='60000',`name`='那坡县';
    INSERT INTO `base_area` SET `id`='600017',`pid`='60000',`name`='平果县';
    INSERT INTO `base_area` SET `id`='600018',`pid`='60000',`name`='田东县';
    INSERT INTO `base_area` SET `id`='600019',`pid`='60000',`name`='田林县';
    INSERT INTO `base_area` SET `id`='600020',`pid`='60000',`name`='田阳县';
    INSERT INTO `base_area` SET `id`='600021',`pid`='60000',`name`='西林县';
    #县级60001
    INSERT INTO `base_area` SET `id`='600025',`pid`='60001',`name`='北海市';
    INSERT INTO `base_area` SET `id`='600026',`pid`='60001',`name`='合浦县';
    #县级60002
    INSERT INTO `base_area` SET `id`='600030',`pid`='60002',`name`='崇左市';
    INSERT INTO `base_area` SET `id`='600031',`pid`='60002',`name`='大新县';
    INSERT INTO `base_area` SET `id`='600032',`pid`='60002',`name`='扶绥县';
    INSERT INTO `base_area` SET `id`='600033',`pid`='60002',`name`='龙州县';
    INSERT INTO `base_area` SET `id`='600034',`pid`='60002',`name`='宁明县';
    INSERT INTO `base_area` SET `id`='600035',`pid`='60002',`name`='凭祥市';
    INSERT INTO `base_area` SET `id`='600036',`pid`='60002',`name`='天等县';
    #县级60003
    INSERT INTO `base_area` SET `id`='600040',`pid`='60003',`name`='东兴市';
    INSERT INTO `base_area` SET `id`='600041',`pid`='60003',`name`='防城港市';
    INSERT INTO `base_area` SET `id`='600042',`pid`='60003',`name`='上思县';
    #县级60004
    INSERT INTO `base_area` SET `id`='600050',`pid`='60004',`name`='恭城瑶族自治县';
    INSERT INTO `base_area` SET `id`='600051',`pid`='60004',`name`='灌阳县';
    INSERT INTO `base_area` SET `id`='600052',`pid`='60004',`name`='桂林市';
    INSERT INTO `base_area` SET `id`='600053',`pid`='60004',`name`='荔浦县';
    INSERT INTO `base_area` SET `id`='600054',`pid`='60004',`name`='临桂县';
    INSERT INTO `base_area` SET `id`='600055',`pid`='60004',`name`='灵川县';
    INSERT INTO `base_area` SET `id`='600056',`pid`='60004',`name`='龙胜各族自治县';
    INSERT INTO `base_area` SET `id`='600057',`pid`='60004',`name`='平乐县';
    INSERT INTO `base_area` SET `id`='600058',`pid`='60004',`name`='全州县';
    INSERT INTO `base_area` SET `id`='600059',`pid`='60004',`name`='兴安县';
    INSERT INTO `base_area` SET `id`='600060',`pid`='60004',`name`='阳朔县';
    INSERT INTO `base_area` SET `id`='600061',`pid`='60004',`name`='永福县';
    INSERT INTO `base_area` SET `id`='600062',`pid`='60004',`name`='资源县';
    #县级60005
    INSERT INTO `base_area` SET `id`='600066',`pid`='60005',`name`='桂平市';
    INSERT INTO `base_area` SET `id`='600067',`pid`='60005',`name`='贵港市';
    INSERT INTO `base_area` SET `id`='600068',`pid`='60005',`name`='平南县';
    #县级60006
    INSERT INTO `base_area` SET `id`='600070',`pid`='60006',`name`='巴马瑶族自治县';
    INSERT INTO `base_area` SET `id`='600071',`pid`='60006',`name`='大化瑶族自治县';
    INSERT INTO `base_area` SET `id`='600072',`pid`='60006',`name`='东兰县';
    INSERT INTO `base_area` SET `id`='600073',`pid`='60006',`name`='都安瑶族自治县';
    INSERT INTO `base_area` SET `id`='600074',`pid`='60006',`name`='凤山县';
    INSERT INTO `base_area` SET `id`='600075',`pid`='60006',`name`='河池市';
    INSERT INTO `base_area` SET `id`='600076',`pid`='60006',`name`='环江毛南族自治县';
    INSERT INTO `base_area` SET `id`='600077',`pid`='60006',`name`='罗城仡佬族自治县';
    INSERT INTO `base_area` SET `id`='600078',`pid`='60006',`name`='南丹县';
    INSERT INTO `base_area` SET `id`='600079',`pid`='60006',`name`='天峨县';
    INSERT INTO `base_area` SET `id`='600080',`pid`='60006',`name`='宜州市';
    #县级60007
    INSERT INTO `base_area` SET `id`='600081',`pid`='60007',`name`='富川瑶族自治县';
    INSERT INTO `base_area` SET `id`='600082',`pid`='60007',`name`='贺州市';
    INSERT INTO `base_area` SET `id`='600083',`pid`='60007',`name`='昭平县';
    INSERT INTO `base_area` SET `id`='600084',`pid`='60007',`name`='钟山县';
    #县级60008
    INSERT INTO `base_area` SET `id`='600090',`pid`='60008',`name`='合山市';
    INSERT INTO `base_area` SET `id`='600091',`pid`='60008',`name`='金秀瑶族自治县';
    INSERT INTO `base_area` SET `id`='600092',`pid`='60008',`name`='来宾市';
    INSERT INTO `base_area` SET `id`='600093',`pid`='60008',`name`='武宣县';
    INSERT INTO `base_area` SET `id`='600094',`pid`='60008',`name`='象州县';
    INSERT INTO `base_area` SET `id`='600095',`pid`='60008',`name`='忻城县';
    #县级60009
    INSERT INTO `base_area` SET `id`='600100',`pid`='60009',`name`='柳城县';
    INSERT INTO `base_area` SET `id`='600101',`pid`='60009',`name`='柳江县';
    INSERT INTO `base_area` SET `id`='600102',`pid`='60009',`name`='柳州市';
    INSERT INTO `base_area` SET `id`='600103',`pid`='60009',`name`='鹿寨县';
    INSERT INTO `base_area` SET `id`='600104',`pid`='60009',`name`='融安县';
    INSERT INTO `base_area` SET `id`='600105',`pid`='60009',`name`='融水苗族自治县';
    INSERT INTO `base_area` SET `id`='600106',`pid`='60009',`name`='三江侗族自治县';
    #县级60010
    INSERT INTO `base_area` SET `id`='600110',`pid`='60010',`name`='宾阳县';
    INSERT INTO `base_area` SET `id`='600111',`pid`='60010',`name`='横县';
    INSERT INTO `base_area` SET `id`='600112',`pid`='60010',`name`='隆安县';
    INSERT INTO `base_area` SET `id`='600113',`pid`='60010',`name`='马山县';
    INSERT INTO `base_area` SET `id`='600114',`pid`='60010',`name`='南宁市';
    INSERT INTO `base_area` SET `id`='600115',`pid`='60010',`name`='上林县';
    INSERT INTO `base_area` SET `id`='600116',`pid`='60010',`name`='武鸣县';
    INSERT INTO `base_area` SET `id`='600117',`pid`='60010',`name`='邕宁县';
    #县级60011
    INSERT INTO `base_area` SET `id`='600120',`pid`='60011',`name`='灵山县';
    INSERT INTO `base_area` SET `id`='600121',`pid`='60011',`name`='浦北县';
    INSERT INTO `base_area` SET `id`='600122',`pid`='60011',`name`='钦州市';
    #县级60012
    INSERT INTO `base_area` SET `id`='600130',`pid`='60012',`name`='苍梧县';
    INSERT INTO `base_area` SET `id`='600131',`pid`='60012',`name`='蒙山县';
    INSERT INTO `base_area` SET `id`='600132',`pid`='60012',`name`='藤县';
    INSERT INTO `base_area` SET `id`='600133',`pid`='60012',`name`='梧州市';
    INSERT INTO `base_area` SET `id`='600134',`pid`='60012',`name`='岑溪市';
    #县级60013
    INSERT INTO `base_area` SET `id`='600140',`pid`='60013',`name`='北流市';
    INSERT INTO `base_area` SET `id`='600141',`pid`='60013',`name`='博白县';
    INSERT INTO `base_area` SET `id`='600142',`pid`='60013',`name`='陆川县';
    INSERT INTO `base_area` SET `id`='600143',`pid`='60013',`name`='容县';
    INSERT INTO `base_area` SET `id`='600144',`pid`='60013',`name`='兴业县';
    INSERT INTO `base_area` SET `id`='600145',`pid`='60013',`name`='玉林市';
    #市级7
    INSERT INTO `base_area` SET `id`='70000',`pid`='7',`name`='安顺';
    INSERT INTO `base_area` SET `id`='70001',`pid`='8',`name`='毕节';
    INSERT INTO `base_area` SET `id`='70002',`pid`='9',`name`='贵阳';
    INSERT INTO `base_area` SET `id`='70003',`pid`='10',`name`='六盘水';
    INSERT INTO `base_area` SET `id`='70004',`pid`='11',`name`='黔东南苗族侗族自治州';
    INSERT INTO `base_area` SET `id`='70005',`pid`='12',`name`='黔南布依族苗族自治州';
    INSERT INTO `base_area` SET `id`='70006',`pid`='13',`name`='黔西南布依族苗族自治州';
    INSERT INTO `base_area` SET `id`='70007',`pid`='14',`name`='铜仁';
    INSERT INTO `base_area` SET `id`='70008',`pid`='15',`name`='遵义';
    #县级70000
    INSERT INTO `base_area` SET `id`='700010',`pid`='70000',`name`='安顺市';
    INSERT INTO `base_area` SET `id`='700011',`pid`='70000',`name`='关岭布依族苗族自治县';
    INSERT INTO `base_area` SET `id`='700012',`pid`='70000',`name`='平坝县';
    INSERT INTO `base_area` SET `id`='700013',`pid`='70000',`name`='普定县';
    INSERT INTO `base_area` SET `id`='700014',`pid`='70000',`name`='镇宁布依族苗族自治县';
    INSERT INTO `base_area` SET `id`='700015',`pid`='70000',`name`='紫云苗族布依族自治县';
    #县级70001
    INSERT INTO `base_area` SET `id`='700020',`pid`='70001',`name`='毕节市';
    INSERT INTO `base_area` SET `id`='700021',`pid`='70001',`name`='大方县';
    INSERT INTO `base_area` SET `id`='700022',`pid`='70001',`name`='赫章县';
    INSERT INTO `base_area` SET `id`='700023',`pid`='70001',`name`='金沙县';
    INSERT INTO `base_area` SET `id`='700024',`pid`='70001',`name`='纳雍县';
    INSERT INTO `base_area` SET `id`='700025',`pid`='70001',`name`='黔西县';
    INSERT INTO `base_area` SET `id`='700026',`pid`='70001',`name`='威宁彝族回族苗族自治县';
    INSERT INTO `base_area` SET `id`='700027',`pid`='70001',`name`='织金县';
    #县级70002
    INSERT INTO `base_area` SET `id`='700030',`pid`='70002',`name`='贵阳市';
    INSERT INTO `base_area` SET `id`='700031',`pid`='70002',`name`='开阳县';
    INSERT INTO `base_area` SET `id`='700032',`pid`='70002',`name`='清镇市';
    INSERT INTO `base_area` SET `id`='700033',`pid`='70002',`name`='息烽县';
    INSERT INTO `base_area` SET `id`='700034',`pid`='70002',`name`='修文县';
    #县级70003
    INSERT INTO `base_area` SET `id`='700040',`pid`='70003',`name`='六盘水市';
    INSERT INTO `base_area` SET `id`='700041',`pid`='70003',`name`='六枝特区';
    INSERT INTO `base_area` SET `id`='700042',`pid`='70003',`name`='盘县';
    INSERT INTO `base_area` SET `id`='700043',`pid`='70003',`name`='水城县';
    #县级70004
    INSERT INTO `base_area` SET `id`='700044',`pid`='70004',`name`='从江县';
    INSERT INTO `base_area` SET `id`='700045',`pid`='70004',`name`='丹寨县';
    INSERT INTO `base_area` SET `id`='700052',`pid`='70004',`name`='黄平县';
    INSERT INTO `base_area` SET `id`='700053',`pid`='70004',`name`='剑河县';
    INSERT INTO `base_area` SET `id`='700054',`pid`='70004',`name`='锦屏县';
    INSERT INTO `base_area` SET `id`='700055',`pid`='70004',`name`='凯里市';
    INSERT INTO `base_area` SET `id`='700056',`pid`='70004',`name`='雷山县';
    INSERT INTO `base_area` SET `id`='700057',`pid`='70004',`name`='黎平县';
    INSERT INTO `base_area` SET `id`='700058',`pid`='70004',`name`='麻江县';
    INSERT INTO `base_area` SET `id`='700059',`pid`='70004',`name`='三穗县';
    INSERT INTO `base_area` SET `id`='700060',`pid`='70004',`name`='施秉县';
    INSERT INTO `base_area` SET `id`='700061',`pid`='70004',`name`='台江县';
    INSERT INTO `base_area` SET `id`='700062',`pid`='70004',`name`='天柱县';
    INSERT INTO `base_area` SET `id`='700063',`pid`='70004',`name`='镇远县';
    INSERT INTO `base_area` SET `id`='700064',`pid`='70004',`name`='岑巩县';
    INSERT INTO `base_area` SET `id`='700065',`pid`='70004',`name`='榕江县';
    #县级70005
    INSERT INTO `base_area` SET `id`='700060',`pid`='70005',`name`='长顺县';
    INSERT INTO `base_area` SET `id`='700061',`pid`='70005',`name`='都匀市';
    INSERT INTO `base_area` SET `id`='700062',`pid`='70005',`name`='独山县';
    INSERT INTO `base_area` SET `id`='700063',`pid`='70005',`name`='福泉市';
    INSERT INTO `base_area` SET `id`='700064',`pid`='70005',`name`='贵定县';
    INSERT INTO `base_area` SET `id`='700065',`pid`='70005',`name`='惠水县';
    INSERT INTO `base_area` SET `id`='700066',`pid`='70005',`name`='荔波县';
    INSERT INTO `base_area` SET `id`='700067',`pid`='70005',`name`='龙里县';
    INSERT INTO `base_area` SET `id`='700068',`pid`='70005',`name`='罗甸县';
    INSERT INTO `base_area` SET `id`='700069',`pid`='70005',`name`='平塘县';
    INSERT INTO `base_area` SET `id`='700070',`pid`='70005',`name`='三都水族自治县';
    INSERT INTO `base_area` SET `id`='700071',`pid`='70005',`name`='瓮安县';
    #县级70006
    INSERT INTO `base_area` SET `id`='700070',`pid`='70006',`name`='安龙县';
    INSERT INTO `base_area` SET `id`='700071',`pid`='70006',`name`='册亨县';
    INSERT INTO `base_area` SET `id`='700072',`pid`='70006',`name`='普安县';
    INSERT INTO `base_area` SET `id`='700073',`pid`='70006',`name`='晴隆县';
    INSERT INTO `base_area` SET `id`='700074',`pid`='70006',`name`='望谟县';
    INSERT INTO `base_area` SET `id`='700075',`pid`='70006',`name`='兴仁县';
    INSERT INTO `base_area` SET `id`='700076',`pid`='70006',`name`='兴义市';
    INSERT INTO `base_area` SET `id`='700077',`pid`='70006',`name`='贞丰县';
    #县级70007
    INSERT INTO `base_area` SET `id`='700080',`pid`='70007',`name`='德江县';
    INSERT INTO `base_area` SET `id`='700081',`pid`='70007',`name`='江口县';
    INSERT INTO `base_area` SET `id`='700082',`pid`='70007',`name`='石阡县';
    INSERT INTO `base_area` SET `id`='700083',`pid`='70007',`name`='思南县';
    INSERT INTO `base_area` SET `id`='700084',`pid`='70007',`name`='松桃苗族自治县';
    INSERT INTO `base_area` SET `id`='700085',`pid`='70007',`name`='铜仁市';
    INSERT INTO `base_area` SET `id`='700086',`pid`='70007',`name`='万山特区';
    INSERT INTO `base_area` SET `id`='700087',`pid`='70007',`name`='沿河土家族自治县';
    INSERT INTO `base_area` SET `id`='700088',`pid`='70007',`name`='印江土家族苗族自治县';
    INSERT INTO `base_area` SET `id`='700089',`pid`='70007',`name`='玉屏侗族自治县';
    #县级70008
    INSERT INTO `base_area` SET `id`='700090',`pid`='70008',`name`='赤水市';
    INSERT INTO `base_area` SET `id`='700091',`pid`='70008',`name`='道真仡佬族苗族自治县';
    INSERT INTO `base_area` SET `id`='700092',`pid`='70008',`name`='凤冈县';
    INSERT INTO `base_area` SET `id`='700093',`pid`='70008',`name`='仁怀市';
    INSERT INTO `base_area` SET `id`='700094',`pid`='70008',`name`='绥阳县';
    INSERT INTO `base_area` SET `id`='700095',`pid`='70008',`name`='桐梓县';
    INSERT INTO `base_area` SET `id`='700096',`pid`='70008',`name`='务川仡佬族苗族自治县';
    INSERT INTO `base_area` SET `id`='700097',`pid`='70008',`name`='习水县';
    INSERT INTO `base_area` SET `id`='700098',`pid`='70008',`name`='余庆县';
    INSERT INTO `base_area` SET `id`='700099',`pid`='70008',`name`='正安县';
    INSERT INTO `base_area` SET `id`='700100',`pid`='70008',`name`='遵义市';
    INSERT INTO `base_area` SET `id`='700101',`pid`='70008',`name`='遵义县';
    INSERT INTO `base_area` SET `id`='700102',`pid`='70008',`name`='湄潭县';
    #市级8
    INSERT INTO `base_area` SET `id`='80000',`pid`='8',`name`='白沙黎族自治县';
    INSERT INTO `base_area` SET `id`='80001',`pid`='9',`name`='保亭黎族苗族自治县';
    INSERT INTO `base_area` SET `id`='80002',`pid`='10',`name`='昌江黎族自治县';
    INSERT INTO `base_area` SET `id`='80003',`pid`='11',`name`='澄迈县';
    INSERT INTO `base_area` SET `id`='80004',`pid`='12',`name`='定安县';
    INSERT INTO `base_area` SET `id`='80005',`pid`='13',`name`='东方';
    INSERT INTO `base_area` SET `id`='80006',`pid`='14',`name`='海口';
    INSERT INTO `base_area` SET `id`='80007',`pid`='15',`name`='乐东黎族自治县';
    INSERT INTO `base_area` SET `id`='80008',`pid`='16',`name`='临高县';
    INSERT INTO `base_area` SET `id`='80009',`pid`='17',`name`='陵水黎族自治县';
    INSERT INTO `base_area` SET `id`='80010',`pid`='18',`name`='琼海';
    INSERT INTO `base_area` SET `id`='80011',`pid`='19',`name`='琼中黎族苗族自治县';
    INSERT INTO `base_area` SET `id`='80012',`pid`='20',`name`='三亚';
    INSERT INTO `base_area` SET `id`='80013',`pid`='21',`name`='屯昌县';
    INSERT INTO `base_area` SET `id`='80014',`pid`='22',`name`='万宁';
    INSERT INTO `base_area` SET `id`='80015',`pid`='23',`name`='文昌';
    INSERT INTO `base_area` SET `id`='80016',`pid`='24',`name`='五指山';
    INSERT INTO `base_area` SET `id`='80017',`pid`='25',`name`='儋州';
    #县级80000
    INSERT INTO `base_area` SET `id`='800010',`pid`='80000',`name`='白沙黎族自治县';
    #县级80001
    INSERT INTO `base_area` SET `id`='800020',`pid`='80001',`name`='保亭黎族苗族自治县';
    #县级80002
    INSERT INTO `base_area` SET `id`='800030',`pid`='80002',`name`='昌江黎族自治县';
    #县级80003
    INSERT INTO `base_area` SET `id`='800040',`pid`='80003',`name`='澄迈县';
    #县级80004
    INSERT INTO `base_area` SET `id`='800050',`pid`='80004',`name`='定安县';
    #县级80005
    INSERT INTO `base_area` SET `id`='800060',`pid`='80005',`name`='东方市';
    #县级80006
    INSERT INTO `base_area` SET `id`='800070',`pid`='80006',`name`='海口市';
    #县级80007
    INSERT INTO `base_area` SET `id`='800080',`pid`='80007',`name`='乐东黎族自治县';
    #县级80008
    INSERT INTO `base_area` SET `id`='800090',`pid`='80008',`name`='临高县';
    #县级80009
    INSERT INTO `base_area` SET `id`='800100',`pid`='80009',`name`='陵水黎族自治县';
    #县级80010
    INSERT INTO `base_area` SET `id`='800110',`pid`='80010',`name`='琼海市';
    #县级80011
    INSERT INTO `base_area` SET `id`='800120',`pid`='80011',`name`='琼中黎族苗族自治县';
    #县级80012
    INSERT INTO `base_area` SET `id`='800130',`pid`='80012',`name`='三亚市';
    #县级80013
    INSERT INTO `base_area` SET `id`='800140',`pid`='80013',`name`='屯昌县';
    #县级80014
    INSERT INTO `base_area` SET `id`='800150',`pid`='80014',`name`='万宁市';
    #县级80015
    INSERT INTO `base_area` SET `id`='800160',`pid`='80015',`name`='文昌市';
    #县级80016
    INSERT INTO `base_area` SET `id`='800170',`pid`='80016',`name`='五指山市';
    #县级80017
    INSERT INTO `base_area` SET `id`='800180',`pid`='80017',`name`='儋州市';
    #市级9
    INSERT INTO `base_area` SET `id`='90000',`pid`='9',`name`='保定';
    INSERT INTO `base_area` SET `id`='90001',`pid`='10',`name`='沧州';
    INSERT INTO `base_area` SET `id`='90002',`pid`='11',`name`='承德';
    INSERT INTO `base_area` SET `id`='90003',`pid`='12',`name`='邯郸';
    INSERT INTO `base_area` SET `id`='90004',`pid`='13',`name`='衡水';
    INSERT INTO `base_area` SET `id`='90005',`pid`='14',`name`='廊坊';
    INSERT INTO `base_area` SET `id`='90006',`pid`='15',`name`='秦皇岛';
    INSERT INTO `base_area` SET `id`='90007',`pid`='16',`name`='石家庄';
    INSERT INTO `base_area` SET `id`='90008',`pid`='17',`name`='唐山';
    INSERT INTO `base_area` SET `id`='90009',`pid`='18',`name`='邢台';
    INSERT INTO `base_area` SET `id`='90010',`pid`='19',`name`='张家口';
    #县级90000
    INSERT INTO `base_area` SET `id`='900010',`pid`='90000',`name`='安国市';
    INSERT INTO `base_area` SET `id`='900011',`pid`='90000',`name`='安新县';
    INSERT INTO `base_area` SET `id`='900012',`pid`='90000',`name`='保定市';
    INSERT INTO `base_area` SET `id`='900013',`pid`='90000',`name`='博野县';
    INSERT INTO `base_area` SET `id`='900014',`pid`='90000',`name`='定兴县';
    INSERT INTO `base_area` SET `id`='900015',`pid`='90000',`name`='定州市';
    INSERT INTO `base_area` SET `id`='900016',`pid`='90000',`name`='阜平县';
    INSERT INTO `base_area` SET `id`='900017',`pid`='90000',`name`='高碑店市';
    INSERT INTO `base_area` SET `id`='900018',`pid`='90000',`name`='高阳县';
    INSERT INTO `base_area` SET `id`='900019',`pid`='90000',`name`='满城县';
    INSERT INTO `base_area` SET `id`='900020',`pid`='90000',`name`='清苑县';
    INSERT INTO `base_area` SET `id`='900021',`pid`='90000',`name`='曲阳县';
    INSERT INTO `base_area` SET `id`='900022',`pid`='90000',`name`='容城县';
    INSERT INTO `base_area` SET `id`='900023',`pid`='90000',`name`='顺平县';
    INSERT INTO `base_area` SET `id`='900024',`pid`='90000',`name`='唐县';
    INSERT INTO `base_area` SET `id`='900025',`pid`='90000',`name`='望都县';
    INSERT INTO `base_area` SET `id`='900026',`pid`='90000',`name`='雄县';
    INSERT INTO `base_area` SET `id`='900027',`pid`='90000',`name`='徐水县';
    INSERT INTO `base_area` SET `id`='900028',`pid`='90000',`name`='易县';
    INSERT INTO `base_area` SET `id`='900029',`pid`='90000',`name`='涞水县';
    INSERT INTO `base_area` SET `id`='900030',`pid`='90000',`name`='涞源县';
    INSERT INTO `base_area` SET `id`='900031',`pid`='90000',`name`='涿州市';
    INSERT INTO `base_area` SET `id`='900032',`pid`='90000',`name`='蠡县';
    #县级90001
    INSERT INTO `base_area` SET `id`='900020',`pid`='90001',`name`='泊头市';
    INSERT INTO `base_area` SET `id`='900021',`pid`='90001',`name`='沧县';
    INSERT INTO `base_area` SET `id`='900022',`pid`='90001',`name`='沧州市';
    INSERT INTO `base_area` SET `id`='900023',`pid`='90001',`name`='东光县';
    INSERT INTO `base_area` SET `id`='900024',`pid`='90001',`name`='海兴县';
    INSERT INTO `base_area` SET `id`='900025',`pid`='90001',`name`='河间市';
    INSERT INTO `base_area` SET `id`='900026',`pid`='90001',`name`='黄骅市';
    INSERT INTO `base_area` SET `id`='900027',`pid`='90001',`name`='孟村回族自治县';
    INSERT INTO `base_area` SET `id`='900028',`pid`='90001',`name`='南皮县';
    INSERT INTO `base_area` SET `id`='900029',`pid`='90001',`name`='青县';
    INSERT INTO `base_area` SET `id`='900030',`pid`='90001',`name`='任丘市';
    INSERT INTO `base_area` SET `id`='900031',`pid`='90001',`name`='肃宁县';
    INSERT INTO `base_area` SET `id`='900032',`pid`='90001',`name`='吴桥县';
    INSERT INTO `base_area` SET `id`='900033',`pid`='90001',`name`='献县';
    INSERT INTO `base_area` SET `id`='900034',`pid`='90001',`name`='盐山县';
    #县级90002
    INSERT INTO `base_area` SET `id`='900030',`pid`='90002',`name`='承德市';
    INSERT INTO `base_area` SET `id`='900031',`pid`='90002',`name`='承德县';
    INSERT INTO `base_area` SET `id`='900032',`pid`='90002',`name`='丰宁满族自治县';
    INSERT INTO `base_area` SET `id`='900033',`pid`='90002',`name`='宽城满族自治县';
    INSERT INTO `base_area` SET `id`='900034',`pid`='90002',`name`='隆化县';
    INSERT INTO `base_area` SET `id`='900035',`pid`='90002',`name`='滦平县';
    INSERT INTO `base_area` SET `id`='900036',`pid`='90002',`name`='平泉县';
    INSERT INTO `base_area` SET `id`='900037',`pid`='90002',`name`='围场满族蒙古族自治县';
    INSERT INTO `base_area` SET `id`='900038',`pid`='90002',`name`='兴隆县';
    #县级90003
    INSERT INTO `base_area` SET `id`='900040',`pid`='90003',`name`='成安县';
    INSERT INTO `base_area` SET `id`='900041',`pid`='90003',`name`='磁县';
    INSERT INTO `base_area` SET `id`='900042',`pid`='90003',`name`='大名县';
    INSERT INTO `base_area` SET `id`='900043',`pid`='90003',`name`='肥乡县';
    INSERT INTO `base_area` SET `id`='900044',`pid`='90003',`name`='馆陶县';
    INSERT INTO `base_area` SET `id`='900045',`pid`='90003',`name`='广平县';
    INSERT INTO `base_area` SET `id`='900046',`pid`='90003',`name`='邯郸市';
    INSERT INTO `base_area` SET `id`='900047',`pid`='90003',`name`='邯郸县';
    INSERT INTO `base_area` SET `id`='900048',`pid`='90003',`name`='鸡泽县';
    INSERT INTO `base_area` SET `id`='900049',`pid`='90003',`name`='临漳县';
    INSERT INTO `base_area` SET `id`='900050',`pid`='90003',`name`='邱县';
    INSERT INTO `base_area` SET `id`='900051',`pid`='90003',`name`='曲周县';
    INSERT INTO `base_area` SET `id`='900052',`pid`='90003',`name`='涉县';
    INSERT INTO `base_area` SET `id`='900053',`pid`='90003',`name`='魏县';
    INSERT INTO `base_area` SET `id`='900054',`pid`='90003',`name`='武安市';
    INSERT INTO `base_area` SET `id`='900055',`pid`='90003',`name`='永年县';
    #县级90004
    INSERT INTO `base_area` SET `id`='900050',`pid`='90004',`name`='安平县';
    INSERT INTO `base_area` SET `id`='900051',`pid`='90004',`name`='阜城县';
    INSERT INTO `base_area` SET `id`='900052',`pid`='90004',`name`='故城县';
    INSERT INTO `base_area` SET `id`='900053',`pid`='90004',`name`='衡水市';
    INSERT INTO `base_area` SET `id`='900054',`pid`='90004',`name`='冀州市';
    INSERT INTO `base_area` SET `id`='900055',`pid`='90004',`name`='景县';
    INSERT INTO `base_area` SET `id`='900056',`pid`='90004',`name`='饶阳县';
    INSERT INTO `base_area` SET `id`='900057',`pid`='90004',`name`='深州市';
    INSERT INTO `base_area` SET `id`='900058',`pid`='90004',`name`='武强县';
    INSERT INTO `base_area` SET `id`='900059',`pid`='90004',`name`='武邑县';
    INSERT INTO `base_area` SET `id`='900060',`pid`='90004',`name`='枣强县';
    #县级90005
    INSERT INTO `base_area` SET `id`='900060',`pid`='90005',`name`='霸州市';
    INSERT INTO `base_area` SET `id`='900061',`pid`='90005',`name`='大厂回族自治县';
    INSERT INTO `base_area` SET `id`='900062',`pid`='90005',`name`='大城县';
    INSERT INTO `base_area` SET `id`='900063',`pid`='90005',`name`='固安县';
    INSERT INTO `base_area` SET `id`='900064',`pid`='90005',`name`='廊坊市';
    INSERT INTO `base_area` SET `id`='900065',`pid`='90005',`name`='三河市';
    INSERT INTO `base_area` SET `id`='900066',`pid`='90005',`name`='文安县';
    INSERT INTO `base_area` SET `id`='900067',`pid`='90005',`name`='香河县';
    INSERT INTO `base_area` SET `id`='900068',`pid`='90005',`name`='永清县';
    #县级90006
    INSERT INTO `base_area` SET `id`='900070',`pid`='90006',`name`='昌黎县';
    INSERT INTO `base_area` SET `id`='900071',`pid`='90006',`name`='抚宁县';
    INSERT INTO `base_area` SET `id`='900072',`pid`='90006',`name`='卢龙县';
    INSERT INTO `base_area` SET `id`='900073',`pid`='90006',`name`='秦皇岛市';
    INSERT INTO `base_area` SET `id`='900074',`pid`='90006',`name`='青龙满族自治县';
    #县级90007
    INSERT INTO `base_area` SET `id`='900080',`pid`='90007',`name`='高邑县';
    INSERT INTO `base_area` SET `id`='900081',`pid`='90007',`name`='晋州市';
    INSERT INTO `base_area` SET `id`='900082',`pid`='90007',`name`='井陉县';
    INSERT INTO `base_area` SET `id`='900083',`pid`='90007',`name`='灵寿县';
    INSERT INTO `base_area` SET `id`='900084',`pid`='90007',`name`='鹿泉市';
    INSERT INTO `base_area` SET `id`='900085',`pid`='90007',`name`='平山县';
    INSERT INTO `base_area` SET `id`='900086',`pid`='90007',`name`='深泽县';
    INSERT INTO `base_area` SET `id`='900087',`pid`='90007',`name`='石家庄市';
    INSERT INTO `base_area` SET `id`='900088',`pid`='90007',`name`='无极县';
    INSERT INTO `base_area` SET `id`='900089',`pid`='90007',`name`='辛集市';
    INSERT INTO `base_area` SET `id`='900090',`pid`='90007',`name`='新乐市';
    INSERT INTO `base_area` SET `id`='900091',`pid`='90007',`name`='行唐县';
    INSERT INTO `base_area` SET `id`='900092',`pid`='90007',`name`='元氏县';
    INSERT INTO `base_area` SET `id`='900093',`pid`='90007',`name`='赞皇县';
    INSERT INTO `base_area` SET `id`='900094',`pid`='90007',`name`='赵县';
    INSERT INTO `base_area` SET `id`='900095',`pid`='90007',`name`='正定县';
    INSERT INTO `base_area` SET `id`='900096',`pid`='90007',`name`='藁城市';
    INSERT INTO `base_area` SET `id`='900097',`pid`='90007',`name`='栾城县';
    #县级90008
    INSERT INTO `base_area` SET `id`='900090',`pid`='90008',`name`='乐亭县';
    INSERT INTO `base_area` SET `id`='900091',`pid`='90008',`name`='滦南县';
    INSERT INTO `base_area` SET `id`='900092',`pid`='90008',`name`='滦县';
    INSERT INTO `base_area` SET `id`='900093',`pid`='90008',`name`='迁安市';
    INSERT INTO `base_area` SET `id`='900094',`pid`='90008',`name`='迁西县';
    INSERT INTO `base_area` SET `id`='900095',`pid`='90008',`name`='唐海县';
    INSERT INTO `base_area` SET `id`='900096',`pid`='90008',`name`='唐山市';
    INSERT INTO `base_area` SET `id`='900097',`pid`='90008',`name`='玉田县';
    INSERT INTO `base_area` SET `id`='900098',`pid`='90008',`name`='遵化市';
    #县级90009
    INSERT INTO `base_area` SET `id`='900100',`pid`='90009',`name`='柏乡县';
    INSERT INTO `base_area` SET `id`='900101',`pid`='90009',`name`='广宗县';
    INSERT INTO `base_area` SET `id`='900102',`pid`='90009',`name`='巨鹿县';
    INSERT INTO `base_area` SET `id`='900103',`pid`='90009',`name`='临城县';
    INSERT INTO `base_area` SET `id`='900104',`pid`='90009',`name`='临西县';
    INSERT INTO `base_area` SET `id`='900105',`pid`='90009',`name`='隆尧县';
    INSERT INTO `base_area` SET `id`='900106',`pid`='90009',`name`='南宫市';
    INSERT INTO `base_area` SET `id`='900107',`pid`='90009',`name`='南和县';
    INSERT INTO `base_area` SET `id`='900108',`pid`='90009',`name`='内丘县';
    INSERT INTO `base_area` SET `id`='900109',`pid`='90009',`name`='宁晋县';
    INSERT INTO `base_area` SET `id`='900110',`pid`='90009',`name`='平乡县';
    INSERT INTO `base_area` SET `id`='900111',`pid`='90009',`name`='清河县';
    INSERT INTO `base_area` SET `id`='900112',`pid`='90009',`name`='任县';
    INSERT INTO `base_area` SET `id`='900113',`pid`='90009',`name`='沙河市';
    INSERT INTO `base_area` SET `id`='900114',`pid`='90009',`name`='威县';
    INSERT INTO `base_area` SET `id`='900115',`pid`='90009',`name`='新河县';
    INSERT INTO `base_area` SET `id`='900116',`pid`='90009',`name`='邢台市';
    INSERT INTO `base_area` SET `id`='900117',`pid`='90009',`name`='邢台县';
    #县级90010
    INSERT INTO `base_area` SET `id`='900110',`pid`='90010',`name`='赤城县';
    INSERT INTO `base_area` SET `id`='900111',`pid`='90010',`name`='崇礼县';
    INSERT INTO `base_area` SET `id`='900112',`pid`='90010',`name`='沽源县';
    INSERT INTO `base_area` SET `id`='900113',`pid`='90010',`name`='怀安县';
    INSERT INTO `base_area` SET `id`='900114',`pid`='90010',`name`='怀来县';
    INSERT INTO `base_area` SET `id`='900115',`pid`='90010',`name`='康保县';
    INSERT INTO `base_area` SET `id`='900116',`pid`='90010',`name`='尚义县';
    INSERT INTO `base_area` SET `id`='900117',`pid`='90010',`name`='万全县';
    INSERT INTO `base_area` SET `id`='900118',`pid`='90010',`name`='蔚县';
    INSERT INTO `base_area` SET `id`='900119',`pid`='90010',`name`='宣化县';
    INSERT INTO `base_area` SET `id`='900120',`pid`='90010',`name`='阳原县';
    INSERT INTO `base_area` SET `id`='900121',`pid`='90010',`name`='张北县';
    INSERT INTO `base_area` SET `id`='900122',`pid`='90010',`name`='张家口市';
    INSERT INTO `base_area` SET `id`='900123',`pid`='90010',`name`='涿鹿县';
    #市级10
    INSERT INTO `base_area` SET `id`='100000',`pid`='10',`name`='安阳';
    INSERT INTO `base_area` SET `id`='100001',`pid`='11',`name`='鹤壁';
    INSERT INTO `base_area` SET `id`='100002',`pid`='12',`name`='济源';
    INSERT INTO `base_area` SET `id`='100003',`pid`='13',`name`='焦作';
    INSERT INTO `base_area` SET `id`='100004',`pid`='14',`name`='开封';
    INSERT INTO `base_area` SET `id`='100005',`pid`='15',`name`='洛阳';
    INSERT INTO `base_area` SET `id`='100006',`pid`='16',`name`='南阳';
    INSERT INTO `base_area` SET `id`='100007',`pid`='17',`name`='平顶山';
    INSERT INTO `base_area` SET `id`='100008',`pid`='18',`name`='三门峡';
    INSERT INTO `base_area` SET `id`='100009',`pid`='19',`name`='商丘';
    INSERT INTO `base_area` SET `id`='100010',`pid`='20',`name`='新乡';
    INSERT INTO `base_area` SET `id`='100011',`pid`='21',`name`='信阳';
    INSERT INTO `base_area` SET `id`='100012',`pid`='22',`name`='许昌';
    INSERT INTO `base_area` SET `id`='100013',`pid`='23',`name`='郑州';
    INSERT INTO `base_area` SET `id`='100014',`pid`='24',`name`='周口';
    INSERT INTO `base_area` SET `id`='100015',`pid`='25',`name`='驻马店';
    INSERT INTO `base_area` SET `id`='100016',`pid`='26',`name`='漯河';
    INSERT INTO `base_area` SET `id`='100017',`pid`='27',`name`='濮阳';
    #县级100000
    INSERT INTO `base_area` SET `id`='1000010',`pid`='100000',`name`='安阳市';
    INSERT INTO `base_area` SET `id`='1000011',`pid`='100000',`name`='安阳县';
    INSERT INTO `base_area` SET `id`='1000012',`pid`='100000',`name`='滑县';
    INSERT INTO `base_area` SET `id`='1000013',`pid`='100000',`name`='林州市';
    INSERT INTO `base_area` SET `id`='1000014',`pid`='100000',`name`='内黄县';
    INSERT INTO `base_area` SET `id`='1000015',`pid`='100000',`name`='汤阴县';
    #县级100001
    INSERT INTO `base_area` SET `id`='1000020',`pid`='100001',`name`='';
    INSERT INTO `base_area` SET `id`='1000021',`pid`='100001',`name`='鹤壁市';
    INSERT INTO `base_area` SET `id`='1000022',`pid`='100001',`name`='浚县';
    INSERT INTO `base_area` SET `id`='1000023',`pid`='100001',`name`='淇县';
    #县级100002
    INSERT INTO `base_area` SET `id`='1000030',`pid`='100002',`name`='济源市';
    #县级100003
    INSERT INTO `base_area` SET `id`='1000040',`pid`='100003',`name`='博爱县';
    INSERT INTO `base_area` SET `id`='1000041',`pid`='100003',`name`='焦作市';
    INSERT INTO `base_area` SET `id`='1000042',`pid`='100003',`name`='孟州市';
    INSERT INTO `base_area` SET `id`='1000043',`pid`='100003',`name`='沁阳市';
    INSERT INTO `base_area` SET `id`='1000044',`pid`='100003',`name`='温县';
    INSERT INTO `base_area` SET `id`='1000045',`pid`='100003',`name`='武陟县';
    INSERT INTO `base_area` SET `id`='1000046',`pid`='100003',`name`='修武县';
    #县级100004
    INSERT INTO `base_area` SET `id`='1000050',`pid`='100004',`name`='开封市';
    INSERT INTO `base_area` SET `id`='1000051',`pid`='100004',`name`='开封县';
    INSERT INTO `base_area` SET `id`='1000052',`pid`='100004',`name`='兰考县';
    INSERT INTO `base_area` SET `id`='1000053',`pid`='100004',`name`='通许县';
    INSERT INTO `base_area` SET `id`='1000054',`pid`='100004',`name`='尉氏县';
    INSERT INTO `base_area` SET `id`='1000055',`pid`='100004',`name`='杞县';
    #县级100005
    INSERT INTO `base_area` SET `id`='1000060',`pid`='100005',`name`='洛宁县';
    INSERT INTO `base_area` SET `id`='1000061',`pid`='100005',`name`='洛阳市';
    INSERT INTO `base_area` SET `id`='1000062',`pid`='100005',`name`='孟津县';
    INSERT INTO `base_area` SET `id`='1000063',`pid`='100005',`name`='汝阳县';
    INSERT INTO `base_area` SET `id`='1000064',`pid`='100005',`name`='新安县';
    INSERT INTO `base_area` SET `id`='1000065',`pid`='100005',`name`='伊川县';
    INSERT INTO `base_area` SET `id`='1000066',`pid`='100005',`name`='宜阳县';
    INSERT INTO `base_area` SET `id`='1000067',`pid`='100005',`name`='偃师市';
    INSERT INTO `base_area` SET `id`='1000068',`pid`='100005',`name`='嵩县';
    INSERT INTO `base_area` SET `id`='1000069',`pid`='100005',`name`='栾川县';
    #县级100006
    INSERT INTO `base_area` SET `id`='1000070',`pid`='100006',`name`='邓州市';
    INSERT INTO `base_area` SET `id`='1000071',`pid`='100006',`name`='方城县';
    INSERT INTO `base_area` SET `id`='1000072',`pid`='100006',`name`='南阳市';
    INSERT INTO `base_area` SET `id`='1000073',`pid`='100006',`name`='南召县';
    INSERT INTO `base_area` SET `id`='1000074',`pid`='100006',`name`='内乡县';
    INSERT INTO `base_area` SET `id`='1000075',`pid`='100006',`name`='社旗县';
    INSERT INTO `base_area` SET `id`='1000076',`pid`='100006',`name`='唐河县';
    INSERT INTO `base_area` SET `id`='1000077',`pid`='100006',`name`='桐柏县';
    INSERT INTO `base_area` SET `id`='1000078',`pid`='100006',`name`='西峡县';
    INSERT INTO `base_area` SET `id`='1000079',`pid`='100006',`name`='新野县';
    INSERT INTO `base_area` SET `id`='1000080',`pid`='100006',`name`='镇平县';
    INSERT INTO `base_area` SET `id`='1000081',`pid`='100006',`name`='淅川县';
    #县级100007
    INSERT INTO `base_area` SET `id`='1000080',`pid`='100007',`name`='宝丰县';
    INSERT INTO `base_area` SET `id`='1000081',`pid`='100007',`name`='鲁山县';
    INSERT INTO `base_area` SET `id`='1000082',`pid`='100007',`name`='平顶山市';
    INSERT INTO `base_area` SET `id`='1000083',`pid`='100007',`name`='汝州市';
    INSERT INTO `base_area` SET `id`='1000084',`pid`='100007',`name`='舞钢市';
    INSERT INTO `base_area` SET `id`='1000085',`pid`='100007',`name`='叶县';
    INSERT INTO `base_area` SET `id`='1000086',`pid`='100007',`name`='郏县';
    #县级100008
    INSERT INTO `base_area` SET `id`='1000090',`pid`='100008',`name`='灵宝市';
    INSERT INTO `base_area` SET `id`='1000091',`pid`='100008',`name`='卢氏县';
    INSERT INTO `base_area` SET `id`='1000092',`pid`='100008',`name`='三门峡市';
    INSERT INTO `base_area` SET `id`='1000093',`pid`='100008',`name`='陕县';
    INSERT INTO `base_area` SET `id`='1000094',`pid`='100008',`name`='义马市';
    INSERT INTO `base_area` SET `id`='1000095',`pid`='100008',`name`='渑池县';
    #县级100009
    INSERT INTO `base_area` SET `id`='1000100',`pid`='100009',`name`='民权县';
    INSERT INTO `base_area` SET `id`='1000101',`pid`='100009',`name`='宁陵县';
    INSERT INTO `base_area` SET `id`='1000102',`pid`='100009',`name`='商丘市';
    INSERT INTO `base_area` SET `id`='1000103',`pid`='100009',`name`='夏邑县';
    INSERT INTO `base_area` SET `id`='1000104',`pid`='100009',`name`='永城市';
    INSERT INTO `base_area` SET `id`='1000105',`pid`='100009',`name`='虞城县';
    INSERT INTO `base_area` SET `id`='1000106',`pid`='100009',`name`='柘城县';
    INSERT INTO `base_area` SET `id`='1000107',`pid`='100009',`name`='睢县';
    #县级100010
    INSERT INTO `base_area` SET `id`='1000110',`pid`='100010',`name`='长垣县';
    INSERT INTO `base_area` SET `id`='1000111',`pid`='100010',`name`='封丘县';
    INSERT INTO `base_area` SET `id`='1000112',`pid`='100010',`name`='辉县市';
    INSERT INTO `base_area` SET `id`='1000113',`pid`='100010',`name`='获嘉县';
    INSERT INTO `base_area` SET `id`='1000114',`pid`='100010',`name`='卫辉市';
    INSERT INTO `base_area` SET `id`='1000115',`pid`='100010',`name`='新乡市';
    INSERT INTO `base_area` SET `id`='1000116',`pid`='100010',`name`='新乡县';
    INSERT INTO `base_area` SET `id`='1000117',`pid`='100010',`name`='延津县';
    INSERT INTO `base_area` SET `id`='1000118',`pid`='100010',`name`='原阳县';
    #县级100011
    INSERT INTO `base_area` SET `id`='1000120',`pid`='100011',`name`='固始县';
    INSERT INTO `base_area` SET `id`='1000121',`pid`='100011',`name`='光山县';
    INSERT INTO `base_area` SET `id`='1000122',`pid`='100011',`name`='淮滨县';
    INSERT INTO `base_area` SET `id`='1000123',`pid`='100011',`name`='罗山县';
    INSERT INTO `base_area` SET `id`='1000124',`pid`='100011',`name`='商城县';
    INSERT INTO `base_area` SET `id`='1000125',`pid`='100011',`name`='息县';
    INSERT INTO `base_area` SET `id`='1000126',`pid`='100011',`name`='新县';
    INSERT INTO `base_area` SET `id`='1000127',`pid`='100011',`name`='信阳市';
    INSERT INTO `base_area` SET `id`='1000128',`pid`='100011',`name`='潢川县';
    #县级100012
    INSERT INTO `base_area` SET `id`='1000130',`pid`='100012',`name`='长葛市';
    INSERT INTO `base_area` SET `id`='1000131',`pid`='100012',`name`='襄城县';
    INSERT INTO `base_area` SET `id`='1000132',`pid`='100012',`name`='许昌市';
    INSERT INTO `base_area` SET `id`='1000133',`pid`='100012',`name`='许昌县';
    INSERT INTO `base_area` SET `id`='1000134',`pid`='100012',`name`='禹州市';
    INSERT INTO `base_area` SET `id`='1000135',`pid`='100012',`name`='鄢陵县';
    #县级100013
    INSERT INTO `base_area` SET `id`='1000140',`pid`='100013',`name`='登封市';
    INSERT INTO `base_area` SET `id`='1000141',`pid`='100013',`name`='巩义市';
    INSERT INTO `base_area` SET `id`='1000142',`pid`='100013',`name`='新密市';
    INSERT INTO `base_area` SET `id`='1000143',`pid`='100013',`name`='新郑市';
    INSERT INTO `base_area` SET `id`='1000144',`pid`='100013',`name`='郑州市';
    INSERT INTO `base_area` SET `id`='1000145',`pid`='100013',`name`='中牟县';
    INSERT INTO `base_area` SET `id`='1000146',`pid`='100013',`name`='荥阳市';
    #县级100014
    INSERT INTO `base_area` SET `id`='1000150',`pid`='100014',`name`='郸城县';
    INSERT INTO `base_area` SET `id`='1000151',`pid`='100014',`name`='扶沟县';
    INSERT INTO `base_area` SET `id`='1000152',`pid`='100014',`name`='淮阳县';
    INSERT INTO `base_area` SET `id`='1000153',`pid`='100014',`name`='鹿邑县';
    INSERT INTO `base_area` SET `id`='1000154',`pid`='100014',`name`='商水县';
    INSERT INTO `base_area` SET `id`='1000155',`pid`='100014',`name`='沈丘县';
    INSERT INTO `base_area` SET `id`='1000156',`pid`='100014',`name`='太康县';
    INSERT INTO `base_area` SET `id`='1000157',`pid`='100014',`name`='西华县';
    INSERT INTO `base_area` SET `id`='1000158',`pid`='100014',`name`='项城市';
    INSERT INTO `base_area` SET `id`='1000159',`pid`='100014',`name`='周口市';
    #县级100015
    INSERT INTO `base_area` SET `id`='1000160',`pid`='100015',`name`='泌阳县';
    INSERT INTO `base_area` SET `id`='1000161',`pid`='100015',`name`='平舆县';
    INSERT INTO `base_area` SET `id`='1000162',`pid`='100015',`name`='确山县';
    INSERT INTO `base_area` SET `id`='1000163',`pid`='100015',`name`='汝南县';
    INSERT INTO `base_area` SET `id`='1000164',`pid`='100015',`name`='上蔡县';
    INSERT INTO `base_area` SET `id`='1000165',`pid`='100015',`name`='遂平县';
    INSERT INTO `base_area` SET `id`='1000166',`pid`='100015',`name`='西平县';
    INSERT INTO `base_area` SET `id`='1000167',`pid`='100015',`name`='新蔡县';
    INSERT INTO `base_area` SET `id`='1000168',`pid`='100015',`name`='正阳县';
    INSERT INTO `base_area` SET `id`='1000169',`pid`='100015',`name`='驻马店市';
    #县级100016
    INSERT INTO `base_area` SET `id`='1000170',`pid`='100016',`name`='临颍县';
    INSERT INTO `base_area` SET `id`='1000171',`pid`='100016',`name`='舞阳县';
    INSERT INTO `base_area` SET `id`='1000172',`pid`='100016',`name`='郾城县';
    INSERT INTO `base_area` SET `id`='1000173',`pid`='100016',`name`='漯河市';
    #县级100017
    INSERT INTO `base_area` SET `id`='1000180',`pid`='100017',`name`='范县';
    INSERT INTO `base_area` SET `id`='1000181',`pid`='100017',`name`='南乐县';
    INSERT INTO `base_area` SET `id`='1000182',`pid`='100017',`name`='清丰县';
    INSERT INTO `base_area` SET `id`='1000183',`pid`='100017',`name`='台前县';
    INSERT INTO `base_area` SET `id`='1000184',`pid`='100017',`name`='濮阳市';
    INSERT INTO `base_area` SET `id`='1000185',`pid`='100017',`name`='濮阳县';
    #市级11
    INSERT INTO `base_area` SET `id`='110000',`pid`='11',`name`='大庆';
    INSERT INTO `base_area` SET `id`='110001',`pid`='12',`name`='大兴安岭';
    INSERT INTO `base_area` SET `id`='110002',`pid`='13',`name`='哈尔滨';
    INSERT INTO `base_area` SET `id`='110003',`pid`='14',`name`='鹤岗';
    INSERT INTO `base_area` SET `id`='110004',`pid`='15',`name`='黑河';
    INSERT INTO `base_area` SET `id`='110005',`pid`='16',`name`='鸡西';
    INSERT INTO `base_area` SET `id`='110006',`pid`='17',`name`='佳木斯';
    INSERT INTO `base_area` SET `id`='110007',`pid`='18',`name`='牡丹江';
    INSERT INTO `base_area` SET `id`='110008',`pid`='19',`name`='七台河';
    INSERT INTO `base_area` SET `id`='110009',`pid`='20',`name`='齐齐哈尔';
    INSERT INTO `base_area` SET `id`='110010',`pid`='21',`name`='双鸭山';
    INSERT INTO `base_area` SET `id`='110011',`pid`='22',`name`='绥化';
    INSERT INTO `base_area` SET `id`='110012',`pid`='23',`name`='伊春';
    #县级110000
    INSERT INTO `base_area` SET `id`='1100010',`pid`='110000',`name`='大庆市';
    INSERT INTO `base_area` SET `id`='1100011',`pid`='110000',`name`='杜尔伯特蒙古族自治县';
    INSERT INTO `base_area` SET `id`='1100012',`pid`='110000',`name`='林甸县';
    INSERT INTO `base_area` SET `id`='1100013',`pid`='110000',`name`='肇源县';
    INSERT INTO `base_area` SET `id`='1100014',`pid`='110000',`name`='肇州县';
    #县级110001
    INSERT INTO `base_area` SET `id`='1100020',`pid`='110001',`name`='呼玛县';
    INSERT INTO `base_area` SET `id`='1100021',`pid`='110001',`name`='漠河县';
    INSERT INTO `base_area` SET `id`='1100022',`pid`='110001',`name`='塔河县';
    #县级110002
    INSERT INTO `base_area` SET `id`='1100030',`pid`='110002',`name`='阿城市';
    INSERT INTO `base_area` SET `id`='1100031',`pid`='110002',`name`='巴彦县';
    INSERT INTO `base_area` SET `id`='1100032',`pid`='110002',`name`='宾县';
    INSERT INTO `base_area` SET `id`='1100033',`pid`='110002',`name`='方正县';
    INSERT INTO `base_area` SET `id`='1100034',`pid`='110002',`name`='哈尔滨市';
    INSERT INTO `base_area` SET `id`='1100035',`pid`='110002',`name`='呼兰县';
    INSERT INTO `base_area` SET `id`='1100036',`pid`='110002',`name`='木兰县';
    INSERT INTO `base_area` SET `id`='1100037',`pid`='110002',`name`='尚志市';
    INSERT INTO `base_area` SET `id`='1100038',`pid`='110002',`name`='双城市';
    INSERT INTO `base_area` SET `id`='1100039',`pid`='110002',`name`='通河县';
    INSERT INTO `base_area` SET `id`='1100040',`pid`='110002',`name`='五常市';
    INSERT INTO `base_area` SET `id`='1100041',`pid`='110002',`name`='延寿县';
    INSERT INTO `base_area` SET `id`='1100042',`pid`='110002',`name`='依兰县';
    #县级110003
    INSERT INTO `base_area` SET `id`='1100040',`pid`='110003',`name`='鹤岗市';
    INSERT INTO `base_area` SET `id`='1100041',`pid`='110003',`name`='萝北县';
    INSERT INTO `base_area` SET `id`='1100042',`pid`='110003',`name`='绥滨县';
    #县级110004
    INSERT INTO `base_area` SET `id`='1100050',`pid`='110004',`name`='北安市';
    INSERT INTO `base_area` SET `id`='1100051',`pid`='110004',`name`='黑河市';
    INSERT INTO `base_area` SET `id`='1100052',`pid`='110004',`name`='嫩江县';
    INSERT INTO `base_area` SET `id`='1100053',`pid`='110004',`name`='孙吴县';
    INSERT INTO `base_area` SET `id`='1100054',`pid`='110004',`name`='五大连池市';
    INSERT INTO `base_area` SET `id`='1100055',`pid`='110004',`name`='逊克县';
    #县级110005
    INSERT INTO `base_area` SET `id`='1100060',`pid`='110005',`name`='虎林市';
    INSERT INTO `base_area` SET `id`='1100061',`pid`='110005',`name`='鸡东县';
    INSERT INTO `base_area` SET `id`='1100062',`pid`='110005',`name`='鸡西市';
    INSERT INTO `base_area` SET `id`='1100063',`pid`='110005',`name`='密山市';
    #县级110006
    INSERT INTO `base_area` SET `id`='1100070',`pid`='110006',`name`='抚远县';
    INSERT INTO `base_area` SET `id`='1100071',`pid`='110006',`name`='富锦市';
    INSERT INTO `base_area` SET `id`='1100072',`pid`='110006',`name`='佳木斯市';
    INSERT INTO `base_area` SET `id`='1100073',`pid`='110006',`name`='汤原县';
    INSERT INTO `base_area` SET `id`='1100074',`pid`='110006',`name`='同江市';
    INSERT INTO `base_area` SET `id`='1100075',`pid`='110006',`name`='桦川县';
    INSERT INTO `base_area` SET `id`='1100076',`pid`='110006',`name`='桦南县';
    #县级110007
    INSERT INTO `base_area` SET `id`='1100080',`pid`='110007',`name`='东宁县';
    INSERT INTO `base_area` SET `id`='1100081',`pid`='110007',`name`='海林市';
    INSERT INTO `base_area` SET `id`='1100082',`pid`='110007',`name`='林口县';
    INSERT INTO `base_area` SET `id`='1100083',`pid`='110007',`name`='牡丹江市';
    INSERT INTO `base_area` SET `id`='1100084',`pid`='110007',`name`='穆棱市';
    INSERT INTO `base_area` SET `id`='1100085',`pid`='110007',`name`='宁安市';
    INSERT INTO `base_area` SET `id`='1100086',`pid`='110007',`name`='绥芬河市';
    #县级110008
    INSERT INTO `base_area` SET `id`='1100090',`pid`='110008',`name`='勃利县';
    INSERT INTO `base_area` SET `id`='1100091',`pid`='110008',`name`='七台河市';
    #县级110009
    INSERT INTO `base_area` SET `id`='1100100',`pid`='110009',`name`='拜泉县';
    INSERT INTO `base_area` SET `id`='1100101',`pid`='110009',`name`='富裕县';
    INSERT INTO `base_area` SET `id`='1100102',`pid`='110009',`name`='甘南县';
    INSERT INTO `base_area` SET `id`='1100103',`pid`='110009',`name`='克东县';
    INSERT INTO `base_area` SET `id`='1100104',`pid`='110009',`name`='克山县';
    INSERT INTO `base_area` SET `id`='1100105',`pid`='110009',`name`='龙江县';
    INSERT INTO `base_area` SET `id`='1100106',`pid`='110009',`name`='齐齐哈尔市';
    INSERT INTO `base_area` SET `id`='1100107',`pid`='110009',`name`='泰来县';
    INSERT INTO `base_area` SET `id`='1100108',`pid`='110009',`name`='依安县';
    INSERT INTO `base_area` SET `id`='1100109',`pid`='110009',`name`='讷河市';
    #县级110010
    INSERT INTO `base_area` SET `id`='1100110',`pid`='110010',`name`='宝清县';
    INSERT INTO `base_area` SET `id`='1100111',`pid`='110010',`name`='集贤县';
    INSERT INTO `base_area` SET `id`='1100112',`pid`='110010',`name`='饶河县';
    INSERT INTO `base_area` SET `id`='1100113',`pid`='110010',`name`='双鸭山市';
    INSERT INTO `base_area` SET `id`='1100114',`pid`='110010',`name`='友谊县';
    #县级110011
    INSERT INTO `base_area` SET `id`='1100120',`pid`='110011',`name`='安达市';
    INSERT INTO `base_area` SET `id`='1100121',`pid`='110011',`name`='海伦市';
    INSERT INTO `base_area` SET `id`='1100122',`pid`='110011',`name`='兰西县';
    INSERT INTO `base_area` SET `id`='1100123',`pid`='110011',`name`='明水县';
    INSERT INTO `base_area` SET `id`='1100124',`pid`='110011',`name`='青冈县';
    INSERT INTO `base_area` SET `id`='1100125',`pid`='110011',`name`='庆安县';
    INSERT INTO `base_area` SET `id`='1100126',`pid`='110011',`name`='绥化市';
    INSERT INTO `base_area` SET `id`='1100127',`pid`='110011',`name`='绥棱县';
    INSERT INTO `base_area` SET `id`='1100128',`pid`='110011',`name`='望奎县';
    INSERT INTO `base_area` SET `id`='1100129',`pid`='110011',`name`='肇东市';
    #县级110012
    INSERT INTO `base_area` SET `id`='1100130',`pid`='110012',`name`='嘉荫县';
    INSERT INTO `base_area` SET `id`='1100131',`pid`='110012',`name`='铁力市';
    INSERT INTO `base_area` SET `id`='1100132',`pid`='110012',`name`='伊春市';
    #市级12
    INSERT INTO `base_area` SET `id`='120000',`pid`='12',`name`='鄂州';
    INSERT INTO `base_area` SET `id`='120001',`pid`='13',`name`='恩施土家族苗族自治州';
    INSERT INTO `base_area` SET `id`='120002',`pid`='14',`name`='黄冈';
    INSERT INTO `base_area` SET `id`='120003',`pid`='15',`name`='黄石';
    INSERT INTO `base_area` SET `id`='120004',`pid`='16',`name`='荆门';
    INSERT INTO `base_area` SET `id`='120005',`pid`='17',`name`='荆州';
    INSERT INTO `base_area` SET `id`='120006',`pid`='18',`name`='潜江';
    INSERT INTO `base_area` SET `id`='120007',`pid`='19',`name`='神农架林区';
    INSERT INTO `base_area` SET `id`='120008',`pid`='20',`name`='十堰';
    INSERT INTO `base_area` SET `id`='120009',`pid`='21',`name`='随州';
    INSERT INTO `base_area` SET `id`='120010',`pid`='22',`name`='天门';
    INSERT INTO `base_area` SET `id`='120011',`pid`='23',`name`='武汉';
    INSERT INTO `base_area` SET `id`='120012',`pid`='24',`name`='仙桃';
    INSERT INTO `base_area` SET `id`='120013',`pid`='25',`name`='咸宁';
    INSERT INTO `base_area` SET `id`='120014',`pid`='26',`name`='襄樊';
    INSERT INTO `base_area` SET `id`='120015',`pid`='27',`name`='孝感';
    INSERT INTO `base_area` SET `id`='120016',`pid`='28',`name`='宜昌';
    #县级120000
    INSERT INTO `base_area` SET `id`='1200010',`pid`='120000',`name`='鄂州市';
    #县级120001
    INSERT INTO `base_area` SET `id`='1200020',`pid`='120001',`name`='巴东县';
    INSERT INTO `base_area` SET `id`='1200021',`pid`='120001',`name`='恩施市';
    INSERT INTO `base_area` SET `id`='1200022',`pid`='120001',`name`='鹤峰县';
    INSERT INTO `base_area` SET `id`='1200023',`pid`='120001',`name`='建始县';
    INSERT INTO `base_area` SET `id`='1200024',`pid`='120001',`name`='来凤县';
    INSERT INTO `base_area` SET `id`='1200025',`pid`='120001',`name`='利川市';
    INSERT INTO `base_area` SET `id`='1200026',`pid`='120001',`name`='咸丰县';
    INSERT INTO `base_area` SET `id`='1200027',`pid`='120001',`name`='宣恩县';
    #县级120002
    INSERT INTO `base_area` SET `id`='1200030',`pid`='120002',`name`='红安县';
    INSERT INTO `base_area` SET `id`='1200031',`pid`='120002',`name`='黄冈市';
    INSERT INTO `base_area` SET `id`='1200032',`pid`='120002',`name`='黄梅县';
    INSERT INTO `base_area` SET `id`='1200033',`pid`='120002',`name`='罗田县';
    INSERT INTO `base_area` SET `id`='1200034',`pid`='120002',`name`='麻城市';
    INSERT INTO `base_area` SET `id`='1200035',`pid`='120002',`name`='团风县';
    INSERT INTO `base_area` SET `id`='1200036',`pid`='120002',`name`='武穴市';
    INSERT INTO `base_area` SET `id`='1200037',`pid`='120002',`name`='英山县';
    INSERT INTO `base_area` SET `id`='1200038',`pid`='120002',`name`='蕲春县';
    INSERT INTO `base_area` SET `id`='1200039',`pid`='120002',`name`='浠水县';
    #县级120003
    INSERT INTO `base_area` SET `id`='1200040',`pid`='120003',`name`='大冶市';
    INSERT INTO `base_area` SET `id`='1200041',`pid`='120003',`name`='黄石市';
    INSERT INTO `base_area` SET `id`='1200042',`pid`='120003',`name`='阳新县';
    #县级120004
    INSERT INTO `base_area` SET `id`='1200050',`pid`='120004',`name`='荆门市';
    INSERT INTO `base_area` SET `id`='1200051',`pid`='120004',`name`='京山县';
    INSERT INTO `base_area` SET `id`='1200052',`pid`='120004',`name`='沙洋县';
    INSERT INTO `base_area` SET `id`='1200053',`pid`='120004',`name`='钟祥市';
    #县级120005
    INSERT INTO `base_area` SET `id`='1200060',`pid`='120005',`name`='公安县';
    INSERT INTO `base_area` SET `id`='1200061',`pid`='120005',`name`='洪湖市';
    INSERT INTO `base_area` SET `id`='1200062',`pid`='120005',`name`='监利县';
    INSERT INTO `base_area` SET `id`='1200063',`pid`='120005',`name`='江陵县';
    INSERT INTO `base_area` SET `id`='1200064',`pid`='120005',`name`='荆州市';
    INSERT INTO `base_area` SET `id`='1200065',`pid`='120005',`name`='石首市';
    INSERT INTO `base_area` SET `id`='1200066',`pid`='120005',`name`='松滋市';
    #县级120006
    INSERT INTO `base_area` SET `id`='1200070',`pid`='120006',`name`='潜江市';
    #县级120007
    INSERT INTO `base_area` SET `id`='1200080',`pid`='120007',`name`='神农架林区';
    #县级120008
    INSERT INTO `base_area` SET `id`='1200090',`pid`='120008',`name`='丹江口市';
    INSERT INTO `base_area` SET `id`='1200091',`pid`='120008',`name`='房县';
    INSERT INTO `base_area` SET `id`='1200092',`pid`='120008',`name`='十堰市';
    INSERT INTO `base_area` SET `id`='1200093',`pid`='120008',`name`='郧西县';
    INSERT INTO `base_area` SET `id`='1200094',`pid`='120008',`name`='郧县';
    INSERT INTO `base_area` SET `id`='1200095',`pid`='120008',`name`='竹山县';
    INSERT INTO `base_area` SET `id`='1200096',`pid`='120008',`name`='竹溪县';
    #县级120009
    INSERT INTO `base_area` SET `id`='1200100',`pid`='120009',`name`='广水市';
    INSERT INTO `base_area` SET `id`='1200101',`pid`='120009',`name`='随州市';
    #县级120010
    INSERT INTO `base_area` SET `id`='1200110',`pid`='120010',`name`='天门市';
    #县级120011
    INSERT INTO `base_area` SET `id`='1200120',`pid`='120011',`name`='武汉市';
    #县级120012
    INSERT INTO `base_area` SET `id`='1200130',`pid`='120012',`name`='仙桃市';
  • 相关阅读:
    年薪30W的软件测试“老司机”工作经验
    软件测试的痛点有哪些?
    学会高效管理时间,健康工作
    一周面试十家公司,分享面试经历
    电子公文传输系统安全进展二
    常用国外会议出版社及出版社地址
    linux中wget命令
    python中 从gff文件提取指定基因信息
    R语言中空值NA、""、NULL的区别
    python 中列出指定目录中文件的绝对路径
  • 原文地址:https://www.cnblogs.com/mrray/p/2035217.html
Copyright © 2020-2023  润新知