--最新行政区代码(2010-12-31) SQL语句
--LC_XZQ
delete from lc_xzq;
insert into LC_XZQ(XZQDM,XZQMC,PID) values('230900','七台河市','230000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('230901','市辖区','230900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('230902','新兴区','230900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('230903','桃山区','230900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('230904','茄子河区','230900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('230921','勃利县','230900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231000','牡丹江市','230000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231001','市辖区','231000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231002','东安区','231000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231003','阳明区','231000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231004','爱民区','231000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231005','西安区','231000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231024','东宁县','231000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231025','林口县','231000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231081','绥芬河市','231000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231083','海林市','231000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231084','宁安市','231000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231085','穆棱市','231000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231100','黑河市','230000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231101','市辖区','231100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231102','爱辉区','231100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231121','嫩江县','231100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231123','逊克县','231100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231124','孙吴县','231100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231181','北安市','231100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231182','五大连池市','231100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231200','绥化市','230000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231201','市辖区','231200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231202','北林区','231200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231221','望奎县','231200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231222','兰西县','231200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231223','青冈县','231200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231224','庆安县','231200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231225','明水县','231200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231226','绥棱县','231200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231281','安达市','231200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231282','肇东市','231200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('231283','海伦市','231200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('232700','大兴安岭地区','230000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('232701','加格达奇区','232700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('232702','松岭区','232700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('232703','新林区','232700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('232704','呼中区','232700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('232721','呼玛县','232700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('232722','塔河县','232700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('232723','漠河县','232700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('310000','上海市','310000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('310100','市辖区','310000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('310101','黄浦区','310100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('310103','卢湾区','310100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('310104','徐汇区','310100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('310105','长宁区','310100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('310106','静安区','310100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('310107','普陀区','310100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('310108','闸北区','310100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('310109','虹口区','310100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('310110','杨浦区','310100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('310112','闵行区','310100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('310113','宝山区','310100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('310114','嘉定区','310100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('310115','浦东新区','310100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('310116','金山区','310100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('310117','松江区','310100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('310118','青浦区','310100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('310120','奉贤区','310100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('310200','县','310000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('310230','崇明县','310200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320000','江苏省','320000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320100','南京市','320000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320101','市辖区','320100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320102','玄武区','320100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320103','白下区','320100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320104','秦淮区','320100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320105','建邺区','320100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320106','鼓楼区','320100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320107','下关区','320100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320111','浦口区','320100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320113','栖霞区','320100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320114','雨花台区','320100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320115','江宁区','320100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320116','六合区','320100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320124','溧水县','320100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320125','高淳县','320100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320200','无锡市','320000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320201','市辖区','320200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320202','崇安区','320200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320203','南长区','320200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320204','北塘区','320200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320205','锡山区','320200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320206','惠山区','320200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320211','滨湖区','320200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320281','江阴市','320200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320282','宜兴市','320200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320300','徐州市','320000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320301','市辖区','320300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320302','鼓楼区','320300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320303','云龙区','320300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320305','贾汪区','320300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320311','泉山区','320300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320312','铜山区','320300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320321','丰县','320300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320322','沛县','320300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320324','睢宁县','320300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320381','新沂市','320300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320382','邳州市','320300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320400','常州市','320000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320401','市辖区','320400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320402','天宁区','320400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320404','钟楼区','320400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320405','戚墅堰区','320400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320411','新北区','320400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320412','武进区','320400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320481','溧阳市','320400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320482','金坛市','320400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320500','苏州市','320000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320501','市辖区','320500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320502','沧浪区','320500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320503','平江区','320500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320504','金阊区','320500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320505','虎丘区','320500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320506','吴中区','320500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320507','相城区','320500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320581','常熟市','320500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320582','张家港市','320500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320583','昆山市','320500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320584','吴江市','320500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320585','太仓市','320500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320600','南通市','320000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320601','市辖区','320600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320602','崇川区','320600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320611','港闸区','320600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320612','通州区','320600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320621','海安县','320600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320623','如东县','320600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320681','启东市','320600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320682','如皋市','320600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320684','海门市','320600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320700','连云港市','320000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320701','市辖区','320700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320703','连云区','320700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320705','新浦区','320700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320706','海州区','320700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320721','赣榆县','320700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320722','东海县','320700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320723','灌云县','320700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320724','灌南县','320700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320800','淮安市','320000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320801','市辖区','320800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320802','清河区','320800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320803','楚州区','320800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320804','淮阴区','320800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320811','清浦区','320800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320826','涟水县','320800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320829','洪泽县','320800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320830','盱眙县','320800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320831','金湖县','320800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320900','盐城市','320000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320901','市辖区','320900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320902','亭湖区','320900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320903','盐都区','320900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320921','响水县','320900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320922','滨海县','320900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320923','阜宁县','320900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320924','射阳县','320900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320925','建湖县','320900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320981','东台市','320900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('320982','大丰市','320900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321000','扬州市','320000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321001','市辖区','321000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321002','广陵区','321000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321003','邗江区','321000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321011','维扬区','321000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321023','宝应县','321000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321081','仪征市','321000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321084','高邮市','321000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321088','江都市','321000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321100','镇江市','320000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321101','市辖区','321100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321102','京口区','321100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321111','润州区','321100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321112','丹徒区','321100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321181','丹阳市','321100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321182','扬中市','321100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321183','句容市','321100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321200','泰州市','320000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321201','市辖区','321200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321202','海陵区','321200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321203','高港区','321200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321281','兴化市','321200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321282','靖江市','321200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321283','泰兴市','321200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321284','姜堰市','321200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321300','宿迁市','320000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321301','市辖区','321300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321302','宿城区','321300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321311','宿豫区','321300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321322','沭阳县','321300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321323','泗阳县','321300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('321324','泗洪县','321300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330000','浙江省','330000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330100','杭州市','330000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330101','市辖区','330100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330102','上城区','330100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330103','下城区','330100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330104','江干区','330100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330105','拱墅区','330100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330106','西湖区','330100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330108','滨江区','330100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330109','萧山区','330100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330110','余杭区','330100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330122','桐庐县','330100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330127','淳安县','330100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330182','建德市','330100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330183','富阳市','330100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330185','临安市','330100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330200','宁波市','330000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330201','市辖区','330200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330203','海曙区','330200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330204','江东区','330200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330205','江北区','330200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330206','北仑区','330200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330211','镇海区','330200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330212','鄞州区','330200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330225','象山县','330200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330226','宁海县','330200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330281','余姚市','330200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330282','慈溪市','330200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330283','奉化市','330200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330300','温州市','330000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330301','市辖区','330300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330302','鹿城区','330300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330303','龙湾区','330300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330304','瓯海区','330300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330322','洞头县','330300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330324','永嘉县','330300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330326','平阳县','330300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330327','苍南县','330300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330328','文成县','330300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330329','泰顺县','330300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330381','瑞安市','330300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330382','乐清市','330300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330400','嘉兴市','330000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330401','市辖区','330400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330402','南湖区','330400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330411','秀洲区','330400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330421','嘉善县','330400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330424','海盐县','330400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330481','海宁市','330400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330482','平湖市','330400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330483','桐乡市','330400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330500','湖州市','330000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330501','市辖区','330500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330502','吴兴区','330500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330503','南浔区','330500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330521','德清县','330500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330522','长兴县','330500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330523','安吉县','330500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330600','绍兴市','330000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330601','市辖区','330600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330602','越城区','330600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330621','绍兴县','330600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330624','新昌县','330600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330681','诸暨市','330600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330682','上虞市','330600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330683','嵊州市','330600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330700','金华市','330000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330701','市辖区','330700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330702','婺城区','330700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330703','金东区','330700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330723','武义县','330700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330726','浦江县','330700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330727','磐安县','330700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330781','兰溪市','330700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330782','义乌市','330700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330783','东阳市','330700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330784','永康市','330700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330800','衢州市','330000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330801','市辖区','330800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330802','柯城区','330800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330803','衢江区','330800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330822','常山县','330800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330824','开化县','330800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330825','龙游县','330800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330881','江山市','330800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330900','舟山市','330000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330901','市辖区','330900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330902','定海区','330900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330903','普陀区','330900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330921','岱山县','330900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('330922','嵊泗县','330900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('331000','台州市','330000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('331001','市辖区','331000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('331002','椒江区','331000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('331003','黄岩区','331000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('331004','路桥区','331000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('331021','玉环县','331000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('331022','三门县','331000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('331023','天台县','331000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('331024','仙居县','331000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('331081','温岭市','331000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('331082','临海市','331000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('331100','丽水市','330000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('331101','市辖区','331100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('331102','莲都区','331100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('331121','青田县','331100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('331122','缙云县','331100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('331123','遂昌县','331100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('331124','松阳县','331100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('331125','云和县','331100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('331126','庆元县','331100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('331127','景宁畲族自治县','331100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('331181','龙泉市','331100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340000','安徽省','340000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340100','合肥市','340000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340101','市辖区','340100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340102','瑶海区','340100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340103','庐阳区','340100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340104','蜀山区','340100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340111','包河区','340100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340121','长丰县','340100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340122','肥东县','340100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340123','肥西县','340100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340200','芜湖市','340000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340201','市辖区','340200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340202','镜湖区','340200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340203','弋江区','340200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340207','鸠江区','340200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340208','三山区','340200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340221','芜湖县','340200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340222','繁昌县','340200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340223','南陵县','340200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340300','蚌埠市','340000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340301','市辖区','340300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340302','龙子湖区','340300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340303','蚌山区','340300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340304','禹会区','340300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340311','淮上区','340300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340321','怀远县','340300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340322','五河县','340300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340323','固镇县','340300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340400','淮南市','340000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340401','市辖区','340400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340402','大通区','340400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340403','田家庵区','340400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340404','谢家集区','340400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340405','八公山区','340400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340406','潘集区','340400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340421','凤台县','340400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340500','马鞍山市','340000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340501','市辖区','340500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340502','金家庄区','340500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340503','花山区','340500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340504','雨山区','340500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340521','当涂县','340500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340600','淮北市','340000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340601','市辖区','340600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340602','杜集区','340600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340603','相山区','340600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340604','烈山区','340600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340621','濉溪县','340600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340700','铜陵市','340000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340701','市辖区','340700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340702','铜官山区','340700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340703','狮子山区','340700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340711','郊区','340700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340721','铜陵县','340700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340800','安庆市','340000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340801','市辖区','340800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340802','迎江区','340800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340803','大观区','340800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340811','宜秀区','340800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340822','怀宁县','340800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340823','枞阳县','340800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340824','潜山县','340800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340825','太湖县','340800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340826','宿松县','340800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340827','望江县','340800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340828','岳西县','340800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('340881','桐城市','340800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341000','黄山市','340000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341001','市辖区','341000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341002','屯溪区','341000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341003','黄山区','341000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341004','徽州区','341000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341021','歙县','341000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341022','休宁县','341000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341023','黟县','341000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341024','祁门县','341000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341100','滁州市','340000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341101','市辖区','341100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341102','琅琊区','341100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341103','南谯区','341100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341122','来安县','341100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341124','全椒县','341100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341125','定远县','341100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341126','凤阳县','341100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341181','天长市','341100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341182','明光市','341100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341200','阜阳市','340000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341201','市辖区','341200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341202','颍州区','341200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341203','颍东区','341200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341204','颍泉区','341200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341221','临泉县','341200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341222','太和县','341200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341225','阜南县','341200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341226','颍上县','341200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341282','界首市','341200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341300','宿州市','340000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341301','市辖区','341300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341302','埇桥区','341300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341321','砀山县','341300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341322','萧县','341300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341323','灵璧县','341300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341324','泗县','341300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341400','巢湖市','340000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341401','市辖区','341400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341402','居巢区','341400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341421','庐江县','341400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341422','无为县','341400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341423','含山县','341400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341424','和县','341400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341500','六安市','340000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341501','市辖区','341500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341502','金安区','341500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341503','裕安区','341500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341521','寿县','341500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341522','霍邱县','341500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341523','舒城县','341500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341524','金寨县','341500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341525','霍山县','341500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341600','亳州市','340000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341601','市辖区','341600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341602','谯城区','341600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341621','涡阳县','341600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341622','蒙城县','341600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341623','利辛县','341600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341700','池州市','340000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341701','市辖区','341700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341702','贵池区','341700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341721','东至县','341700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341722','石台县','341700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341723','青阳县','341700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341800','宣城市','340000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341801','市辖区','341800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341802','宣州区','341800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341821','郎溪县','341800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341822','广德县','341800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341823','泾县','341800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341824','绩溪县','341800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341825','旌德县','341800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('341881','宁国市','341800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350000','福建省','350000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350100','福州市','350000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350101','市辖区','350100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350102','鼓楼区','350100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350103','台江区','350100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350104','仓山区','350100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350105','马尾区','350100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350111','晋安区','350100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350121','闽侯县','350100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350122','连江县','350100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350123','罗源县','350100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350124','闽清县','350100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350125','永泰县','350100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350128','平潭县','350100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350181','福清市','350100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350182','长乐市','350100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350200','厦门市','350000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350201','市辖区','350200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350203','思明区','350200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350205','海沧区','350200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350206','湖里区','350200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350211','集美区','350200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350212','同安区','350200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350213','翔安区','350200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350300','莆田市','350000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350301','市辖区','350300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350302','城厢区','350300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350303','涵江区','350300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350304','荔城区','350300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350305','秀屿区','350300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350322','仙游县','350300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350400','三明市','350000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350401','市辖区','350400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350402','梅列区','350400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350403','三元区','350400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350421','明溪县','350400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350423','清流县','350400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350424','宁化县','350400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350425','大田县','350400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350426','尤溪县','350400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350427','沙县','350400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350428','将乐县','350400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350429','泰宁县','350400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350430','建宁县','350400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350481','永安市','350400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350500','泉州市','350000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350501','市辖区','350500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350502','鲤城区','350500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350503','丰泽区','350500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350504','洛江区','350500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350505','泉港区','350500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350521','惠安县','350500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350524','安溪县','350500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350525','永春县','350500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350526','德化县','350500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350527','金门县','350500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350581','石狮市','350500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350582','晋江市','350500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350583','南安市','350500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350600','漳州市','350000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350601','市辖区','350600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350602','芗城区','350600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350603','龙文区','350600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350622','云霄县','350600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350623','漳浦县','350600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350624','诏安县','350600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350625','长泰县','350600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350626','东山县','350600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350627','南靖县','350600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350628','平和县','350600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350629','华安县','350600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350681','龙海市','350600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350700','南平市','350000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350701','市辖区','350700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350702','延平区','350700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350721','顺昌县','350700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350722','浦城县','350700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350723','光泽县','350700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350724','松溪县','350700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350725','政和县','350700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350781','邵武市','350700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350782','武夷山市','350700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350783','建瓯市','350700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350784','建阳市','350700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350800','龙岩市','350000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350801','市辖区','350800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350802','新罗区','350800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350821','长汀县','350800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350822','永定县','350800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350823','上杭县','350800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350824','武平县','350800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350825','连城县','350800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350881','漳平市','350800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350900','宁德市','350000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350901','市辖区','350900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350902','蕉城区','350900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350921','霞浦县','350900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350922','古田县','350900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350923','屏南县','350900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350924','寿宁县','350900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350925','周宁县','350900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350926','柘荣县','350900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350981','福安市','350900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('350982','福鼎市','350900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('360000','江西省','360000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('110000','北京市','110000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('110100','市辖区','110000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('110101','东城区','110100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('110102','西城区','110100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('110105','朝阳区','110100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('110106','丰台区','110100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('110107','石景山区','110100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('110108','海淀区','110100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('110109','门头沟区','110100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('110111','房山区','110100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('110112','通州区','110100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('110113','顺义区','110100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('110114','昌平区','110100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('110115','大兴区','110100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('110116','怀柔区','110100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('110117','平谷区','110100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('110200','县','110000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('110228','密云县','110200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('110229','延庆县','110200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('120000','天津市','120000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('120100','市辖区','120000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('120101','和平区','120100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('120102','河东区','120100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('120103','河西区','120100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('120104','南开区','120100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('120105','河北区','120100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('120106','红桥区','120100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('120110','东丽区','120100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('120111','西青区','120100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('120112','津南区','120100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('120113','北辰区','120100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('120114','武清区','120100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('120115','宝坻区','120100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('120116','滨海新区','120100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('120200','县','120000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('120221','宁河县','120200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('120223','静海县','120200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('120225','蓟县','120200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130000','河北省','130000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130100','石家庄市','130000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130101','市辖区','130100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130102','长安区','130100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130103','桥东区','130100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130104','桥西区','130100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130105','新华区','130100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130107','井陉矿区','130100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130108','裕华区','130100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130121','井陉县','130100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130123','正定县','130100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130124','栾城县','130100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130125','行唐县','130100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130126','灵寿县','130100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130127','高邑县','130100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130128','深泽县','130100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130129','赞皇县','130100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130130','无极县','130100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130131','平山县','130100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130132','元氏县','130100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130133','赵县','130100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130181','辛集市','130100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130182','藁城市','130100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130183','晋州市','130100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130184','新乐市','130100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130185','鹿泉市','130100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130200','唐山市','130000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130201','市辖区','130200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130202','路南区','130200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130203','路北区','130200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130204','古冶区','130200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130205','开平区','130200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130207','丰南区','130200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130208','丰润区','130200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130223','滦县','130200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130224','滦南县','130200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130225','乐亭县','130200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130227','迁西县','130200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130229','玉田县','130200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130230','唐海县','130200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130281','遵化市','130200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130283','迁安市','130200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130300','秦皇岛市','130000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130301','市辖区','130300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130302','海港区','130300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130303','山海关区','130300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130304','北戴河区','130300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130321','青龙满族自治县','130300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130322','昌黎县','130300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130323','抚宁县','130300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130324','卢龙县','130300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130400','邯郸市','130000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130401','市辖区','130400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130402','邯山区','130400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130403','丛台区','130400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130404','复兴区','130400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130406','峰峰矿区','130400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130421','邯郸县','130400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130423','临漳县','130400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130424','成安县','130400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130425','大名县','130400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130426','涉县','130400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130427','磁县','130400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130428','肥乡县','130400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130429','永年县','130400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130430','邱县','130400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130431','鸡泽县','130400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130432','广平县','130400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130433','馆陶县','130400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130434','魏县','130400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130435','曲周县','130400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130481','武安市','130400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130500','邢台市','130000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130501','市辖区','130500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130502','桥东区','130500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130503','桥西区','130500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130521','邢台县','130500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130522','临城县','130500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130523','内丘县','130500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130524','柏乡县','130500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130525','隆尧县','130500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130526','任县','130500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130527','南和县','130500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130528','宁晋县','130500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130529','巨鹿县','130500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130530','新河县','130500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130531','广宗县','130500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130532','平乡县','130500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130533','威县','130500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130534','清河县','130500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130535','临西县','130500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130581','南宫市','130500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130582','沙河市','130500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130600','保定市','130000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130601','市辖区','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130602','新市区','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130603','北市区','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130604','南市区','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130621','满城县','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130622','清苑县','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130623','涞水县','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130624','阜平县','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130625','徐水县','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130626','定兴县','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130627','唐县','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130628','高阳县','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130629','容城县','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130630','涞源县','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130631','望都县','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130632','安新县','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130633','易县','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130634','曲阳县','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130635','蠡县','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130636','顺平县','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130637','博野县','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130638','雄县','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130681','涿州市','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130682','定州市','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130683','安国市','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130684','高碑店市','130600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130700','张家口市','130000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130701','市辖区','130700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130702','桥东区','130700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130703','桥西区','130700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130705','宣化区','130700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130706','下花园区','130700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130721','宣化县','130700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130722','张北县','130700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130723','康保县','130700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130724','沽源县','130700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130725','尚义县','130700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130726','蔚县','130700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130727','阳原县','130700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130728','怀安县','130700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130729','万全县','130700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130730','怀来县','130700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130731','涿鹿县','130700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130732','赤城县','130700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130733','崇礼县','130700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130800','承德市','130000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130801','市辖区','130800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130802','双桥区','130800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130803','双滦区','130800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130804','鹰手营子矿区','130800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130821','承德县','130800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130822','兴隆县','130800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130823','平泉县','130800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130824','滦平县','130800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130825','隆化县','130800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130826','丰宁满族自治县','130800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130827','宽城满族自治县','130800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130828','围场满族蒙古族自治县','130800');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130900','沧州市','130000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130901','市辖区','130900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130902','新华区','130900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130903','运河区','130900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130921','沧县','130900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130922','青县','130900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130923','东光县','130900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130924','海兴县','130900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130925','盐山县','130900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130926','肃宁县','130900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130927','南皮县','130900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130928','吴桥县','130900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130929','献县','130900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130930','孟村回族自治县','130900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130981','泊头市','130900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130982','任丘市','130900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130983','黄骅市','130900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('130984','河间市','130900');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('131000','廊坊市','130000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('131001','市辖区','131000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('131002','安次区','131000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('131003','广阳区','131000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('131022','固安县','131000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('131023','永清县','131000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('131024','香河县','131000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('131025','大城县','131000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('131026','文安县','131000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('131028','大厂回族自治县','131000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('131081','霸州市','131000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('131082','三河市','131000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('131100','衡水市','130000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('131101','市辖区','131100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('131102','桃城区','131100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('131121','枣强县','131100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('131122','武邑县','131100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('131123','武强县','131100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('131124','饶阳县','131100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('131125','安平县','131100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('131126','故城县','131100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('131127','景县','131100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('131128','阜城县','131100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('131181','冀州市','131100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('131182','深州市','131100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140000','山西省','140000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140100','太原市','140000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140101','市辖区','140100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140105','小店区','140100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140106','迎泽区','140100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140107','杏花岭区','140100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140108','尖草坪区','140100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140109','万柏林区','140100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140110','晋源区','140100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140121','清徐县','140100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140122','阳曲县','140100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140123','娄烦县','140100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140181','古交市','140100');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140200','大同市','140000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140201','市辖区','140200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140202','城区','140200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140203','矿区','140200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140211','南郊区','140200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140212','新荣区','140200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140221','阳高县','140200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140222','天镇县','140200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140223','广灵县','140200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140224','灵丘县','140200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140225','浑源县','140200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140226','左云县','140200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140227','大同县','140200');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140300','阳泉市','140000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140301','市辖区','140300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140302','城区','140300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140303','矿区','140300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140311','郊区','140300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140321','平定县','140300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140322','盂县','140300');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140400','长治市','140000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140401','市辖区','140400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140402','城区','140400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140411','郊区','140400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140421','长治县','140400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140423','襄垣县','140400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140424','屯留县','140400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140425','平顺县','140400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140426','黎城县','140400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140427','壶关县','140400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140428','长子县','140400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140429','武乡县','140400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140430','沁县','140400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140431','沁源县','140400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140481','潞城市','140400');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140500','晋城市','140000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140501','市辖区','140500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140502','城区','140500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140521','沁水县','140500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140522','阳城县','140500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140524','陵川县','140500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140525','泽州县','140500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140581','高平市','140500');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140600','朔州市','140000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140601','市辖区','140600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140602','朔城区','140600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140603','平鲁区','140600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140621','山阴县','140600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140622','应县','140600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140623','右玉县','140600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140624','怀仁县','140600');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140700','晋中市','140000');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140701','市辖区','140700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140702','榆次区','140700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140721','榆社县','140700');
insert into LC_XZQ(XZQDM,XZQMC,PID) values('140722','左权县','140700');
inse