Java实现lucene搜索功能的方法(推荐)
直接上代码:
packagecom.sand.mpa.sousuo;
importjava.io.BufferedReader;
importjava.io.File;
importjava.io.FileReader;
importjava.io.FileWriter;
importjava.io.IOException;
importjava.io.PrintWriter;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.ResultSet;
importjava.sql.Statement;
importjava.util.Date;
importorg.apache.lucene.analysis.Analyzer;
importorg.apache.lucene.analysis.standard.StandardAnalyzer;
importorg.apache.lucene.document.Document;
importorg.apache.lucene.document.Field;
importorg.apache.lucene.index.IndexWriter;
//增量索引
/*
*实现思路:首次查询数据库表所有记录,对每条记录建立索引,并将最后一条记录的id存储到storeId.txt文件中
*当新插入一条记录时,再建立索引时不必再对所有数据重新建一遍索引,
*可根据存放在storeId.txt文件中的id查出新插入的数据,只对新增的数据新建索引,并把新增的索引追加到原来的索引文件中
**/
publicclassIncrementIndex{
publicstaticvoidmain(String[]args){
try{
IncrementIndexindex=newIncrementIndex();
Stringpath="E:\\Test\\lucene_test\\poiIdext";//索引文件的存放路径
StringstoreIdPath="E:\\Test\\lucene_test\\storeId.txt";//存储ID的路径
StringstoreId="";
Datedate1=newDate();
storeId=index.getStoreId(storeIdPath);
ResultSetrs=index.getResult(storeId);
System.out.println("开始建立索引。。。。");
index.indexBuilding(path,storeIdPath,rs);
Datedate2=newDate();
System.out.println("耗时:"+(date2.getTime()-date1.getTime())+"ms");
storeId=index.getStoreId(storeIdPath);
System.out.println(storeId);//打印出这次存储起来的ID
}catch(Exceptione){
e.printStackTrace();
}
}
publicstaticvoidbuildIndex(StringindexFile,StringstoreIdFile){
try{
Stringpath=indexFile;//索引文件的存放路径
StringstoreIdPath=storeIdFile;//存储ID的路径
StringstoreId="";
storeId=getStoreId(storeIdPath);
ResultSetrs=getResult(storeId);
indexBuilding(path,storeIdPath,rs);
storeId=getStoreId(storeIdPath);
}catch(Exceptione){
e.printStackTrace();
}
}
publicstaticResultSetgetResult(StringstoreId)throwsException{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Stringurl="jdbc:mysql://localhost:3306/1pm2_v1";
StringuserName="root";
Stringpassword="root";
Connectionconn=DriverManager.getConnection(url,userName,password);
Statementstmt=conn.createStatement();
Stringsql="select*frompd_ugc";
ResultSetrs=stmt.executeQuery(sql+"whereid>'"+storeId+"'orderbyid");
returnrs;
}
publicstaticbooleanindexBuilding(Stringpath,StringstoreIdPath,ResultSetrs){
try{
AnalyzerluceneAnalyzer=newStandardAnalyzer();
//取得存储起来的ID,以判定是增量索引还是重新索引
booleanisEmpty=true;
try{
Filefile=newFile(storeIdPath);
if(!file.exists()){
file.createNewFile();
}
FileReaderfr=newFileReader(storeIdPath);
BufferedReaderbr=newBufferedReader(fr);
if(br.readLine()!=null){
isEmpty=false;
}
br.close();
fr.close();
}catch(IOExceptione){
e.printStackTrace();
}
//isEmpty=false表示增量索引
IndexWriterwriter=newIndexWriter(path,luceneAnalyzer,isEmpty);
StringstoreId="";
booleanindexFlag=false;
Stringid;
Stringname;
Stringaddress;
Stringcitycode;
while(rs.next()){
id=rs.getInt("id")+"";
name=rs.getString("name");
address=rs.getString("address");
citycode=rs.getString("citycode");
writer.addDocument(Document(id,name,address,citycode));
storeId=id;//将拿到的id给storeId,这种拿法不合理,这里为了方便
indexFlag=true;
}
writer.optimize();
writer.close();
if(indexFlag){
//将最后一个的ID存到磁盘文件中
writeStoreId(storeIdPath,storeId);
}
returntrue;
}catch(Exceptione){
e.printStackTrace();
System.out.println("出错了"+e.getClass()+"\n错误信息为:"+e.getMessage());
returnfalse;
}
}
publicstaticDocumentDocument(Stringid,Stringname,Stringaddress,Stringcitycode){
Documentdoc=newDocument();
doc.add(newField("id",id,Field.Store.YES,Field.Index.TOKENIZED));
doc.add(newField("name",name,Field.Store.YES,Field.Index.TOKENIZED));//查询字段
doc.add(newField("address",address,Field.Store.YES,Field.Index.TOKENIZED));
doc.add(newField("citycode",citycode,Field.Store.YES,Field.Index.TOKENIZED));//查询字段
returndoc;
}
//取得存储在磁盘中的ID
publicstaticStringgetStoreId(Stringpath){
StringstoreId="";
try{
Filefile=newFile(path);
if(!file.exists()){
file.createNewFile();
}
FileReaderfr=newFileReader(path);
BufferedReaderbr=newBufferedReader(fr);
storeId=br.readLine();
if(storeId==null||storeId=="")storeId="0";
br.close();
fr.close();
}catch(Exceptione){
e.printStackTrace();
}
returnstoreId;
}
//将ID写入到磁盘文件中
publicstaticbooleanwriteStoreId(Stringpath,StringstoreId){
booleanb=false;
try{
Filefile=newFile(path);
if(!file.exists()){
file.createNewFile();
}
FileWriterfw=newFileWriter(path);
PrintWriterout=newPrintWriter(fw);
out.write(storeId);
out.close();
fw.close();
b=true;
}catch(IOExceptione){
e.printStackTrace();
}
returnb;
}
}
packagecom.sand.mpa.sousuo;
publicclassIndexResult{
privateStringid;
privateStringname;
privateStringaddress;
privateStringcitycode;
publicStringgetId(){
returnid;
}
publicvoidsetId(Stringid){
this.id=id;
}
publicStringgetName(){
returnname;
}
publicvoidsetName(Stringname){
this.name=name;
}
publicStringgetAddress(){
returnaddress;
}
publicvoidsetAddress(Stringaddress){
this.address=address;
}
publicStringgetCitycode(){
returncitycode;
}
publicvoidsetCitycode(Stringcitycode){
this.citycode=citycode;
}
}
packagecom.sand.mpa.sousuo;
importjava.io.IOException;
importjava.io.Reader;
importjava.io.StringReader;
importjava.util.ArrayList;
importjava.util.Date;
importjava.util.List;
importorg.apache.lucene.analysis.Analyzer;
importorg.apache.lucene.analysis.StopFilter;
importorg.apache.lucene.analysis.Token;
importorg.apache.lucene.analysis.TokenStream;
importorg.apache.lucene.analysis.standard.StandardAnalyzer;
importorg.apache.lucene.document.Document;
importorg.apache.lucene.index.CorruptIndexException;
importorg.apache.lucene.index.IndexReader;
importorg.apache.lucene.index.Term;
importorg.apache.lucene.queryParser.MultiFieldQueryParser;
importorg.apache.lucene.queryParser.ParseException;
importorg.apache.lucene.queryParser.QueryParser;
importorg.apache.lucene.search.BooleanClause;
importorg.apache.lucene.search.BooleanQuery;
importorg.apache.lucene.search.Hits;
importorg.apache.lucene.search.IndexSearcher;
importorg.apache.lucene.search.Query;
importorg.apache.lucene.search.ScoreDoc;
importorg.apache.lucene.search.TopDocCollector;
importorg.apache.lucene.search.highlight.Highlighter;
importorg.apache.lucene.search.highlight.InvalidTokenOffsetsException;
importorg.apache.lucene.search.highlight.QueryScorer;
importorg.apache.lucene.search.highlight.SimpleFragmenter;
importorg.apache.lucene.search.highlight.SimpleHTMLFormatter;
importorg.mira.lucene.analysis.IK_CAnalyzer;
publicclassIndexUtils{
//0.创建增量索引
publicstaticvoidbuildIndex(StringindexFile,StringstoreIdFile){
IncrementIndex.buildIndex(indexFile,storeIdFile);
}
//1.单字段查询
@SuppressWarnings("deprecation")
publicstaticList<IndexResult>queryByOneKey(IndexSearcherindexSearcher,Stringfield,
Stringkey){
try{
Datedate1=newDate();
QueryParserqueryParser=newQueryParser(field,newStandardAnalyzer());
Queryquery=queryParser.parse(key);
Hitshits=indexSearcher.search(query);
Datedate2=newDate();
System.out.println("耗时:"+(date2.getTime()-date1.getTime())+"ms");
List<IndexResult>list=newArrayList<IndexResult>();
for(inti=0;i<hits.length();i++){
list.add(getIndexResult(hits.doc(i)));
}
returnlist;
}catch(ParseExceptione){
e.printStackTrace();
}catch(IOExceptione){
e.printStackTrace();
}
returnnull;
}
//2.多条件查询。这里实现的是and操作
//注:要查询的字段必须是index的
//即doc.add(newField("pid",rs.getString("pid"),Field.Store.YES,Field.Index.TOKENIZED));
@SuppressWarnings("deprecation")
publicstaticList<IndexResult>queryByMultiKeys(IndexSearcherindexSearcher,String[]fields,
String[]keys){
try{
BooleanQuerym_BooleanQuery=newBooleanQuery();
if(keys!=null&&keys.length>0){
for(inti=0;i<keys.length;i++){
QueryParserqueryParser=newQueryParser(fields[i],newStandardAnalyzer());
Queryquery=queryParser.parse(keys[i]);
m_BooleanQuery.add(query,BooleanClause.Occur.MUST);//and操作
}
Hitshits=indexSearcher.search(m_BooleanQuery);
List<IndexResult>list=newArrayList<IndexResult>();
for(inti=0;i<hits.length();i++){
list.add(getIndexResult(hits.doc(i)));
}
returnlist;
}
}catch(ParseExceptione){
e.printStackTrace();
}catch(IOExceptione){
e.printStackTrace();
}
returnnull;
}
//3.高亮显示实现了单条件查询
//可改造为多条件查询
publicstaticList<IndexResult>highlight(IndexSearcherindexSearcher,Stringkey)throwsInvalidTokenOffsetsException{
try{
QueryParserqueryParser=newQueryParser("name",newStandardAnalyzer());
Queryquery=queryParser.parse(key);
TopDocCollectorcollector=newTopDocCollector(800);
indexSearcher.search(query,collector);
ScoreDoc[]hits=collector.topDocs().scoreDocs;
Highlighterhighlighter=null;
SimpleHTMLFormattersimpleHTMLFormatter=newSimpleHTMLFormatter("<fontcolor='red'>",
"</font>");
highlighter=newHighlighter(simpleHTMLFormatter,newQueryScorer(query));
highlighter.setTextFragmenter(newSimpleFragmenter(200));
List<IndexResult>list=newArrayList<IndexResult>();
Documentdoc;
for(inti=0;i<hits.length;i++){
//System.out.println(hits[i].score);
doc=indexSearcher.doc(hits[i].doc);
TokenStreamtokenStream=newStandardAnalyzer().tokenStream("name",
newStringReader(doc.get("name")));
IndexResultir=getIndexResult(doc);
ir.setName(highlighter.getBestFragment(tokenStream,doc.get("name")));
list.add(ir);
}
returnlist;
}catch(ParseExceptione){
e.printStackTrace();
}catch(IOExceptione){
e.printStackTrace();
}
returnnull;
}
//4.多字段查询
@SuppressWarnings("deprecation")
publicstaticList<IndexResult>queryByMultiFileds(IndexSearcherindexSearcher,
String[]fields,Stringkey){
try{
MultiFieldQueryParsermfq=newMultiFieldQueryParser(fields,newStandardAnalyzer());
Queryquery=mfq.parse(key);
Hitshits=indexSearcher.search(query);
List<IndexResult>list=newArrayList<IndexResult>();
for(inti=0;i<hits.length();i++){
list.add(getIndexResult(hits.doc(i)));
}
returnlist;
}catch(ParseExceptione){
e.printStackTrace();
}catch(IOExceptione){
e.printStackTrace();
}
returnnull;
}
//5.删除索引
publicstaticvoiddeleteIndex(StringindexFile,Stringid)throwsCorruptIndexException,
IOException{
IndexReaderindexReader=IndexReader.open(indexFile);
indexReader.deleteDocuments(newTerm("id",id));
indexReader.close();
}
//6.一元分词
@SuppressWarnings("deprecation")
publicstaticStringStandard_Analyzer(Stringstr){
Analyzeranalyzer=newStandardAnalyzer();
Readerr=newStringReader(str);
StopFiltersf=(StopFilter)analyzer.tokenStream("",r);
System.out.println("=====StandardAnalyzer====");
System.out.println("分析方法:默认没有词只有字(一元分词)");
Tokent;
Stringresults="";
try{
while((t=sf.next())!=null){
System.out.println(t.termText());
results=results+""+t.termText();
}
}catch(IOExceptione){
e.printStackTrace();
}
returnresults;
}
//7.字典分词
@SuppressWarnings("deprecation")
publicstaticStringik_CAnalyzer(Stringstr){
Analyzeranalyzer=newIK_CAnalyzer();
Readerr=newStringReader(str);
TokenStreamts=(TokenStream)analyzer.tokenStream("",r);
System.out.println("=====IK_CAnalyzer====");
System.out.println("分析方法:字典分词,正反双向搜索");
Tokent;
Stringresults="";
try{
while((t=ts.next())!=null){
System.out.println(t.termText());
results=results+""+t.termText();
}
}catch(IOExceptione){
e.printStackTrace();
}
System.out.println(results);
returnresults;
}
//在结果中搜索
publicstaticvoidqueryFromResults(){
}
//组装对象
publicstaticIndexResultgetIndexResult(Documentdoc){
IndexResultir=newIndexResult();
ir.setId(doc.get("id"));
ir.setName(doc.get("name"));
ir.setAddress(doc.get("address"));
ir.setCitycode(doc.get("citycode"));
returnir;
}
}
packagecom.sand.mpa.sousuo;
/**
*$Id$
*Copyright2009-2010OakPacificInteractive.Allrightsreserved.
*/
importjava.util.Date;
importjava.util.List;
importorg.apache.lucene.search.IndexSearcher;
importorg.apache.velocity.runtime.directive.Break;
publicclassTest{
//存放索引文件
privatestaticStringindexFile="E:\\Test\\lucene_test\\poiIdext";
//存放id
privatestaticStringstoreIdFile="E:\\Test\\lucene_test\\storeId.txt";
publicstaticvoidmain(String[]args)throwsException{
//0.创建增量索引
IndexUtils.buildIndex(indexFile,storeIdFile);
IndexSearcherindexSearcher=newIndexSearcher(indexFile);
List<IndexResult>list=null;
//Stringkey="";
Datedate1=newDate();
Datedate2=newDate();
//1.单字段查询
//key=IndexUtils.ik_CAnalyzer("上海");
//list=IndexUtils.queryByOneKey(indexSearcher,"address",key);
//date2=newDate();
//System.out.println("耗时:"+(date2.getTime()-date1.getTime())+"ms\n"+list.size()
//+"条=======================================单字段查询");
//printResults(list);
//System.exit(1);
//2.多条件查询
String[]fields={"name","address"};
String[]keys={IndexUtils.ik_CAnalyzer("永城市")};
date1=newDate();
list=IndexUtils.queryByMultiKeys(indexSearcher,fields,keys);
date2=newDate();
System.out.println("查询耗时:"+(date2.getTime()-date1.getTime())+"ms\n"+list.size()
+"条\n===============================多条件查询");
printResults(list);
System.exit(1);
//3.高亮显示单字段查询
//System.out.println("\n\n");
//date1=newDate();
//key="安徽";
//list=IndexUtils.highlight(indexSearcher,key);
//date2=newDate();
//System.out.println("耗时:"+(date2.getTime()-date1.getTime())+"ms\n"+list.size()
//+"条\n======================================高亮显示");
//printResults(list);
//System.exit(1);
//4.多字段查询
//date1=newDate();
//list=IndexUtils.queryByMultiFileds(indexSearcher,fields,key);
//date2=newDate();
//System.out.println("耗时:"+(date2.getTime()-date1.getTime())+"ms\n"+list.size()
//+"条\n=====================================多字段查询");
//printResults(list);
//5.删除索引中的字段根据id进行删除
//IndexUtils.deleteIndex(indexFile,"1552");
}
//打印结果
publicstaticvoidprintResults(List<IndexResult>list){
if(list!=null&&list.size()>0){
for(inti=0;i<list.size();i++){
System.out.println(list.get(i).getId()+","+list.get(i).getName()+","
+list.get(i).getAddress()+","+list.get(i).getCitycode()+"--->"+i);
}
}
}
}
数据库脚本:
INSERTINTO`pd_ugc`VALUES('1','上海市','上海市','shanghaishi');
INSERTINTO`pd_ugc`VALUES('2','上海市','上海市','shanghaishi');
INSERTINTO`pd_ugc`VALUES('5','北京市','北京市','beijingshi');
INSERTINTO`pd_ugc`VALUES('6','北京市','北京市','beijingshi');
INSERTINTO`pd_ugc`VALUES('9','广东省','广东省','guangdongsheng');
INSERTINTO`pd_ugc`VALUES('10','广州市','广东省广州市','guangzhoushi');
INSERTINTO`pd_ugc`VALUES('11','荔湾区','广东省广州市荔湾区','liwanqu');
INSERTINTO`pd_ugc`VALUES('12','越秀区','广东省广州市越秀区','yuexiuqu');
INSERTINTO`pd_ugc`VALUES('13','东山区','广东省广州市东山区','dongshanqu');
INSERTINTO`pd_ugc`VALUES('14','天河区','广东省广州市天河区','tianhequ');
INSERTINTO`pd_ugc`VALUES('15','海珠区','广东省广州市海珠区','haizhuqu');
INSERTINTO`pd_ugc`VALUES('17','天津市','天津市','tianjinshi');
INSERTINTO`pd_ugc`VALUES('18','天津市','天津市','tianjinshi');
INSERTINTO`pd_ugc`VALUES('20','河北省','河北省','hebeisheng');
INSERTINTO`pd_ugc`VALUES('23','山西省','山西省','shanxisheng');
INSERTINTO`pd_ugc`VALUES('26','内蒙古自治区','内蒙古自治区','neimengguzizhiqu');
INSERTINTO`pd_ugc`VALUES('29','辽宁省','辽宁省','liaoningsheng');
INSERTINTO`pd_ugc`VALUES('32','吉林省','吉林省','jilinsheng');
INSERTINTO`pd_ugc`VALUES('35','黑龙江省','黑龙江省','heilongjiangsheng');
INSERTINTO`pd_ugc`VALUES('41','江苏省','江苏省','jiangsusheng');
INSERTINTO`pd_ugc`VALUES('44','浙江省','浙江省','zhejiangsheng');
INSERTINTO`pd_ugc`VALUES('47','安徽省','安徽省','anhuisheng');
INSERTINTO`pd_ugc`VALUES('50','福建省','福建省','fujiansheng');
INSERTINTO`pd_ugc`VALUES('53','江西省','江西省','jiangxisheng');
INSERTINTO`pd_ugc`VALUES('56','山东省','山东省','shandongsheng');
INSERTINTO`pd_ugc`VALUES('59','河南省','河南省','henansheng');
INSERTINTO`pd_ugc`VALUES('62','湖北省','湖北省','hubeisheng');
INSERTINTO`pd_ugc`VALUES('65','湖南省','湖南省','hunansheng');
INSERTINTO`pd_ugc`VALUES('68','重庆市','重庆市','zhongqingshi');
INSERTINTO`pd_ugc`VALUES('69','重庆市','重庆市','zhongqingshi');
INSERTINTO`pd_ugc`VALUES('71','四川省','四川省','sichuansheng');
INSERTINTO`pd_ugc`VALUES('74','贵州省','贵州省','guizhousheng');
INSERTINTO`pd_ugc`VALUES('77','云南省','云南省','yunnansheng');
INSERTINTO`pd_ugc`VALUES('80','西藏自治区','西藏自治区','xizangzizhiqu');
INSERTINTO`pd_ugc`VALUES('83','陕西省','陕西省','shanxisheng');
INSERTINTO`pd_ugc`VALUES('86','甘肃省','甘肃省','gansusheng');
INSERTINTO`pd_ugc`VALUES('89','青海省','青海省','qinghaisheng');
INSERTINTO`pd_ugc`VALUES('92','宁夏回族自治区','宁夏回族自治区','ningxiahuizuzizhiqu');
INSERTINTO`pd_ugc`VALUES('95','新疆维吾尔自治区','新疆维吾尔自治区','xinjiangweiwuerzizhiqu');
INSERTINTO`pd_ugc`VALUES('101','广西壮族自治区','广西省','guangxizhuangzuzizhiqu');
INSERTINTO`pd_ugc`VALUES('104','海南省','海南省','hainansheng');
INSERTINTO`pd_ugc`VALUES('116','南京市','江苏省南京市','nanjingshi');
INSERTINTO`pd_ugc`VALUES('117','徐州市','江苏省徐州市','xuzhoushi');
INSERTINTO`pd_ugc`VALUES('118','连云港市','江苏省连云港市','lianyungangshi');
INSERTINTO`pd_ugc`VALUES('119','宿迁市','江苏省宿迁市','suqianshi');
INSERTINTO`pd_ugc`VALUES('120','淮安市','江苏省淮安市','huaianshi');
INSERTINTO`pd_ugc`VALUES('121','盐城市','江苏省盐城市','yanchengshi');
INSERTINTO`pd_ugc`VALUES('122','扬州市','江苏省扬州市','yangzhoushi');
INSERTINTO`pd_ugc`VALUES('123','泰州市','江苏省泰州市','taizhoushi');
INSERTINTO`pd_ugc`VALUES('124','镇江市','江苏省镇江市','zhenjiangshi');
INSERTINTO`pd_ugc`VALUES('125','常州市','江苏省常州市','changzhoushi');
INSERTINTO`pd_ugc`VALUES('126','无锡市','江苏省无锡市','wuxishi');
INSERTINTO`pd_ugc`VALUES('127','苏州市','江苏省苏州市','suzhoushi');
INSERTINTO`pd_ugc`VALUES('128','南通市','江苏省南通市','nantongshi');
INSERTINTO`pd_ugc`VALUES('130','杭州市','浙江省杭州市','hangzhoushi');
INSERTINTO`pd_ugc`VALUES('131','温州市','浙江省温州市','wenzhoushi');
INSERTINTO`pd_ugc`VALUES('132','嘉兴市','浙江省嘉兴市','jiaxingshi');
INSERTINTO`pd_ugc`VALUES('133','湖州市','浙江省湖州市','huzhoushi');
INSERTINTO`pd_ugc`VALUES('134','绍兴市','浙江省绍兴市','shaoxingshi');
INSERTINTO`pd_ugc`VALUES('135','金华市','浙江省金华市','jinhuashi');
INSERTINTO`pd_ugc`VALUES('136','衢州市','浙江省衢州市','quzhoushi');
INSERTINTO`pd_ugc`VALUES('137','舟山市','浙江省舟山市','zhoushanshi');
INSERTINTO`pd_ugc`VALUES('138','台州市','浙江省台州市','taizhoushi');
INSERTINTO`pd_ugc`VALUES('139','丽水市','浙江省丽水市','lishuishi');
INSERTINTO`pd_ugc`VALUES('181','崇明县','上海市崇明、长兴、横沙三岛','chongmingxian');
INSERTINTO`pd_ugc`VALUES('201','黄浦区','上海市黄浦区','huangpuqu');
INSERTINTO`pd_ugc`VALUES('202','卢湾区','上海市卢湾区','luwanqu');
INSERTINTO`pd_ugc`VALUES('203','徐汇区','上海市徐汇区','xuhuiqu');
INSERTINTO`pd_ugc`VALUES('204','长宁区','上海市长宁区','zhangningqu');
INSERTINTO`pd_ugc`VALUES('205','静安区','上海市静安区','jinganqu');
INSERTINTO`pd_ugc`VALUES('206','闸北区','上海市闸北区','zhabeiqu');
INSERTINTO`pd_ugc`VALUES('207','虹口区','上海市虹口区','hongkouqu');
INSERTINTO`pd_ugc`VALUES('208','杨浦区','上海市杨浦区','yangpuqu');
INSERTINTO`pd_ugc`VALUES('209','宝山区','上海市宝山区','baoshanqu');
INSERTINTO`pd_ugc`VALUES('210','闵行区','上海市闵行区','minxingqu');
INSERTINTO`pd_ugc`VALUES('211','嘉定区','上海市嘉定区','jiadingqu');
INSERTINTO`pd_ugc`VALUES('212','浦东新区','上海市浦东新区','pudongxinqu');
INSERTINTO`pd_ugc`VALUES('213','青浦区','上海市青浦区','qingpuqu');
INSERTINTO`pd_ugc`VALUES('214','松江区','上海市松江区','songjiangqu');
INSERTINTO`pd_ugc`VALUES('215','金山区','上海市金山区','jinshanqu');
INSERTINTO`pd_ugc`VALUES('216','南汇区','上海市南汇区','nanhuiqu');
INSERTINTO`pd_ugc`VALUES('217','奉贤区','上海市奉贤区','fengxianqu');
INSERTINTO`pd_ugc`VALUES('218','普陀区','上海市普陀区','putuoqu');
INSERTINTO`pd_ugc`VALUES('222','上城区','浙江省杭州市上城区','shangchengqu');
INSERTINTO`pd_ugc`VALUES('223','下城区','浙江省杭州市下城区','xiachengqu');
INSERTINTO`pd_ugc`VALUES('224','江干区','浙江省杭州市江干区','jiangganqu');
INSERTINTO`pd_ugc`VALUES('225','拱墅区','浙江省杭州市拱墅区','gongshuqu');
INSERTINTO`pd_ugc`VALUES('226','西湖区','浙江省杭州市西湖区','xihuqu');
INSERTINTO`pd_ugc`VALUES('227','滨江区','浙江省杭州市滨江区','binjiangqu');
INSERTINTO`pd_ugc`VALUES('228','萧山区','浙江省杭州市萧山区','xiaoshanqu');
INSERTINTO`pd_ugc`VALUES('229','余杭区','浙江省杭州市余杭区','yuhangqu');
INSERTINTO`pd_ugc`VALUES('230','桐庐县','浙江省杭州市桐庐县','tongluxian');
INSERTINTO`pd_ugc`VALUES('231','淳安县','浙江省杭州市淳安县','chunanxian');
INSERTINTO`pd_ugc`VALUES('232','建德市','浙江省杭州市建德市','jiandeshi');
INSERTINTO`pd_ugc`VALUES('233','富阳市','浙江省杭州市富阳市','fuyangshi');
INSERTINTO`pd_ugc`VALUES('234','临安市','浙江省杭州市临安市','linanshi');
INSERTINTO`pd_ugc`VALUES('313','应山镇','gsysz','yingshanzhen');
INSERTINTO`pd_ugc`VALUES('500','西宁市','青海省西宁市','xiningshi');
INSERTINTO`pd_ugc`VALUES('501','城东区','青海省西宁市城东区','chengdongqu');
INSERTINTO`pd_ugc`VALUES('502','城中区','青海省西宁市城中区','chengzhongqu');
INSERTINTO`pd_ugc`VALUES('503','城西区','青海省西宁市城西区','chengxiqu');
INSERTINTO`pd_ugc`VALUES('504','城北区','青海省西宁市城北区','chengbeiqu');
INSERTINTO`pd_ugc`VALUES('505','大通回族土族自治县','青海省西宁市大通回族土族自治县','datonghuizutuzuzizhixian');
INSERTINTO`pd_ugc`VALUES('506','湟中县','青海省西宁市湟中县','huangzhongxian');
INSERTINTO`pd_ugc`VALUES('507','湟源县','青海省西宁市湟源县','huangyuanxian');
INSERTINTO`pd_ugc`VALUES('508','海东地区','青海省海东地区市','haidongdiqu');
INSERTINTO`pd_ugc`VALUES('509','平安县','青海省海东地区市平安县','pinganxian');
INSERTINTO`pd_ugc`VALUES('510','民和回族土族自治县','青海省海东地区市民和回族土族自治县','minhehuizutuzuzizhixian');
INSERTINTO`pd_ugc`VALUES('511','乐都县','青海省海东地区市乐都县','ledouxian');
INSERTINTO`pd_ugc`VALUES('512','互助土族自治县','青海省海东地区市互助土族自治县','huzhutuzuzizhixian');
INSERTINTO`pd_ugc`VALUES('513','化隆回族自治县','青海省海东地区市化隆回族自治县','hualonghuizuzizhixian');
INSERTINTO`pd_ugc`VALUES('514','循化撒拉族自治县','青海省海东地区市循化撒拉族自治县','xunhuasalazuzizhixian');
INSERTINTO`pd_ugc`VALUES('515','果洛藏族自治州','青海省果洛藏族自治州','guoluozangzuzizhizhou');
INSERTINTO`pd_ugc`VALUES('516','玛沁县','青海省果洛藏族自治州玛沁县','maqinxian');
INSERTINTO`pd_ugc`VALUES('517','班玛县','青海省果洛藏族自治州班玛县','banmaxian');
INSERTINTO`pd_ugc`VALUES('518','甘德县','青海省果洛藏族自治州甘德县','gandexian');
INSERTINTO`pd_ugc`VALUES('519','达日县','青海省果洛藏族自治州达日县','darixian');
INSERTINTO`pd_ugc`VALUES('520','久治县','青海省果洛藏族自治州久治县','jiuzhixian');
INSERTINTO`pd_ugc`VALUES('521','玛多县','青海省果洛藏族自治州玛多县','maduoxian');
INSERTINTO`pd_ugc`VALUES('522','玉树藏族自治州','青海省玉树藏族自治州','yushuzangzuzizhizhou');
INSERTINTO`pd_ugc`VALUES('523','玉树县','青海省玉树藏族自治州玉树县','yushuxian');
INSERTINTO`pd_ugc`VALUES('524','杂多县','青海省玉树藏族自治州杂多县','zaduoxian');
INSERTINTO`pd_ugc`VALUES('525','称多县','青海省玉树藏族自治州称多县','chengduoxian');
INSERTINTO`pd_ugc`VALUES('526','治多县','青海省玉树藏族自治州治多县','zhiduoxian');
INSERTINTO`pd_ugc`VALUES('527','囊谦县','青海省玉树藏族自治州囊谦县','nangqianxian');
INSERTINTO`pd_ugc`VALUES('528','曲麻莱县','青海省玉树藏族自治州曲麻莱县','qumalaixian');
INSERTINTO`pd_ugc`VALUES('529','海西蒙古族藏族自治州','青海省海西蒙古族藏族自治州','haiximengguzuzangzuzizhizhou');
INSERTINTO`pd_ugc`VALUES('530','格尔木市','青海省海西蒙古族藏族自治州格尔木市','geermushi');
INSERTINTO`pd_ugc`VALUES('531','德令哈市','青海省海西蒙古族藏族自治州德令哈市','delinghashi');
INSERTINTO`pd_ugc`VALUES('532','乌兰县','青海省海西蒙古族藏族自治州乌兰县','wulanxian');
INSERTINTO`pd_ugc`VALUES('533','都兰县','青海省海西蒙古族藏族自治州都兰县','doulanxian');
INSERTINTO`pd_ugc`VALUES('534','天峻县','青海省海西蒙古族藏族自治州天峻县','tianjunxian');
INSERTINTO`pd_ugc`VALUES('535','海北藏族自治州','青海省海北藏族自治州','haibeizangzuzizhizhou');
INSERTINTO`pd_ugc`VALUES('536','门源回族自治县','青海省海北藏族自治州门源回族自治县','menyuanhuizuzizhixian');
INSERTINTO`pd_ugc`VALUES('537','祁连县','青海省海北藏族自治州祁连县','qilianxian');
INSERTINTO`pd_ugc`VALUES('538','海晏县','青海省海北藏族自治州海晏县','haiyanxian');
INSERTINTO`pd_ugc`VALUES('539','刚察县','青海省海北藏族自治州刚察县','gangchaxian');
INSERTINTO`pd_ugc`VALUES('540','黄南藏族自治州','青海省黄南藏族自治州','huangnanzangzuzizhizhou');
INSERTINTO`pd_ugc`VALUES('541','同仁县','青海省黄南藏族自治州同仁县','tongrenxian');
INSERTINTO`pd_ugc`VALUES('542','尖扎县','青海省黄南藏族自治州尖扎县','jianzhaxian');
INSERTINTO`pd_ugc`VALUES('543','泽库县','青海省黄南藏族自治州泽库县','zekuxian');
INSERTINTO`pd_ugc`VALUES('544','河南蒙古族自治县','青海省黄南藏族自治州河南蒙古族自治县','henanmengguzuzizhixian');
INSERTINTO`pd_ugc`VALUES('545','海南藏族自治州','青海省海南藏族自治州','hainanzangzuzizhizhou');
INSERTINTO`pd_ugc`VALUES('546','共和县','青海省海南藏族自治州共和县','gonghexian');
INSERTINTO`pd_ugc`VALUES('547','同德县','青海省海南藏族自治州同德县','tongdexian');
INSERTINTO`pd_ugc`VALUES('548','贵德县','青海省海南藏族自治州贵德县','guidexian');
INSERTINTO`pd_ugc`VALUES('549','兴海县','青海省海南藏族自治州兴海县','xinghaixian');
INSERTINTO`pd_ugc`VALUES('550','贵南县','青海省海南藏族自治州贵南县','guinanxian');
INSERTINTO`pd_ugc`VALUES('551','贵阳市','贵州省贵阳市','guiyangshi');
INSERTINTO`pd_ugc`VALUES('552','南明区','贵州省贵阳市南明区','nanmingqu');
INSERTINTO`pd_ugc`VALUES('553','云岩区','贵州省贵阳市云岩区','yunyanqu');
INSERTINTO`pd_ugc`VALUES('554','花溪区','贵州省贵阳市花溪区','huaxiqu');
INSERTINTO`pd_ugc`VALUES('555','乌当区','贵州省贵阳市乌当区','wudangqu');
INSERTINTO`pd_ugc`VALUES('556','白云区','贵州省贵阳市白云区','baiyunqu');
INSERTINTO`pd_ugc`VALUES('557','开阳县','贵州省贵阳市开阳县','kaiyangxian');
INSERTINTO`pd_ugc`VALUES('558','息烽县','贵州省贵阳市息烽县','xifengxian');
INSERTINTO`pd_ugc`VALUES('559','修文县','贵州省贵阳市修文县','xiuwenxian');
INSERTINTO`pd_ugc`VALUES('560','清镇市','贵州省贵阳市清镇市','qingzhenshi');
INSERTINTO`pd_ugc`VALUES('561','小河区','贵州省贵阳市小河区','xiaohequ');
INSERTINTO`pd_ugc`VALUES('562','遵义市','贵州省遵义市','zunyishi');
INSERTINTO`pd_ugc`VALUES('563','红花岗区','贵州省遵义市红花岗区','honghuagangqu');
INSERTINTO`pd_ugc`VALUES('564','汇川区','贵州省遵义市汇川区','huichuanqu');
INSERTINTO`pd_ugc`VALUES('565','遵义县','贵州省遵义市遵义县','zunyixian');
INSERTINTO`pd_ugc`VALUES('566','桐梓县','贵州省遵义市桐梓县','tongzixian');
INSERTINTO`pd_ugc`VALUES('567','绥阳县','贵州省遵义市绥阳县','suiyangxian');
INSERTINTO`pd_ugc`VALUES('568','正安县','贵州省遵义市正安县','zhenganxian');
INSERTINTO`pd_ugc`VALUES('569','道真仡佬族苗族自治县','贵州省遵义市道真仡佬族苗族自治县','daozhengelaozumiaozuzizhixian');
INSERTINTO`pd_ugc`VALUES('570','务川仡佬族苗族自治县','贵州省遵义市务川仡佬族苗族自治县','wuchuangelaozumiaozuzizhixian');
INSERTINTO`pd_ugc`VALUES('571','凤冈县','贵州省遵义市凤冈县','fenggangxian');
INSERTINTO`pd_ugc`VALUES('572','湄潭县','贵州省遵义市湄潭县','meitanxian');
INSERTINTO`pd_ugc`VALUES('573','余庆县','贵州省遵义市余庆县','yuqingxian');
INSERTINTO`pd_ugc`VALUES('574','习水县','贵州省遵义市习水县','xishuixian');
INSERTINTO`pd_ugc`VALUES('575','赤水市','贵州省遵义市赤水市','chishuishi');
INSERTINTO`pd_ugc`VALUES('576','仁怀市','贵州省遵义市仁怀市','renhuaishi');
INSERTINTO`pd_ugc`VALUES('577','安顺市','贵州省安顺市','anshunshi');
INSERTINTO`pd_ugc`VALUES('578','西秀区','贵州省安顺市西秀区','xixiuqu');
INSERTINTO`pd_ugc`VALUES('579','平坝县','贵州省安顺市平坝县','pingbaxian');
INSERTINTO`pd_ugc`VALUES('580','普定县','贵州省安顺市普定县','pudingxian');
INSERTINTO`pd_ugc`VALUES('581','镇宁布依族苗族自治县','贵州省安顺市镇宁布依族苗族自治县','zhenningbuyizumiaozuzizhixian');
INSERTINTO`pd_ugc`VALUES('582','关岭布依族苗族自治县','贵州省安顺市关岭布依族苗族自治县','guanlingbuyizumiaozuzizhixian');
INSERTINTO`pd_ugc`VALUES('583','紫云苗族布依族自治县','贵州省安顺市紫云苗族布依族自治县','ziyunmiaozubuyizuzizhixian');
INSERTINTO`pd_ugc`VALUES('584','黔南布依族苗族自治州','贵州省黔南布依族苗族自治州','qiannanbuyizumiaozuzizhizhou');
INSERTINTO`pd_ugc`VALUES('585','都匀市','贵州省黔南布依族苗族自治州都匀市','douyunshi');
INSERTINTO`pd_ugc`VALUES('586','福泉市','贵州省黔南布依族苗族自治州福泉市','fuquanshi');
INSERTINTO`pd_ugc`VALUES('587','荔波县','贵州省黔南布依族苗族自治州荔波县','liboxian');
INSERTINTO`pd_ugc`VALUES('588','贵定县','贵州省黔南布依族苗族自治州贵定县','guidingxian');
INSERTINTO`pd_ugc`VALUES('589','瓮安县','贵州省黔南布依族苗族自治州瓮安县','wenganxian');
INSERTINTO`pd_ugc`VALUES('590','独山县','贵州省黔南布依族苗族自治州独山县','dushanxian');
INSERTINTO`pd_ugc`VALUES('591','平塘县','贵州省黔南布依族苗族自治州平塘县','pingtangxian');
INSERTINTO`pd_ugc`VALUES('592','罗甸县','贵州省黔南布依族苗族自治州罗甸县','luodianxian');
INSERTINTO`pd_ugc`VALUES('593','长顺县','贵州省黔南布依族苗族自治州长顺县','zhangshunxian');
INSERTINTO`pd_ugc`VALUES('594','龙里县','贵州省黔南布依族苗族自治州龙里县','longlixian');
INSERTINTO`pd_ugc`VALUES('595','惠水县','贵州省黔南布依族苗族自治州惠水县','huishuixian');
INSERTINTO`pd_ugc`VALUES('596','三都水族自治县','贵州省黔南布依族苗族自治州三都水族自治县','sandoushuizuzizhixian');
INSERTINTO`pd_ugc`VALUES('597','黔东南苗族侗族自治州','贵州省黔东南苗族侗族自治州','qiandongnanmiaozudongzuzizhizh');
INSERTINTO`pd_ugc`VALUES('598','凯里市','贵州省黔东南苗族侗族自治州凯里市','kailishi');
INSERTINTO`pd_ugc`VALUES('599','黄平县','贵州省黔东南苗族侗族自治州黄平县','huangpingxian');
INSERTINTO`pd_ugc`VALUES('600','施秉县','贵州省黔东南苗族侗族自治州施秉县','shibingxian');
INSERTINTO`pd_ugc`VALUES('601','三穗县','贵州省黔东南苗族侗族自治州三穗县','sansuixian');
INSERTINTO`pd_ugc`VALUES('602','镇远县','贵州省黔东南苗族侗族自治州镇远县','zhenyuanxian');
INSERTINTO`pd_ugc`VALUES('603','岑巩县','贵州省黔东南苗族侗族自治州岑巩县','cengongxian');
INSERTINTO`pd_ugc`VALUES('604','天柱县','贵州省黔东南苗族侗族自治州天柱县','tianzhuxian');
INSERTINTO`pd_ugc`VALUES('605','锦屏县','贵州省黔东南苗族侗族自治州锦屏县','jinpingxian');
INSERTINTO`pd_ugc`VALUES('606','剑河县','贵州省黔东南苗族侗族自治州剑河县','jianhexian');
INSERTINTO`pd_ugc`VALUES('607','台江县','贵州省黔东南苗族侗族自治州台江县','taijiangxian');
INSERTINTO`pd_ugc`VALUES('608','黎平县','贵州省黔东南苗族侗族自治州黎平县','lipingxian');
INSERTINTO`pd_ugc`VALUES('609','榕江县','贵州省黔东南苗族侗族自治州榕江县','rongjiangxian');
INSERTINTO`pd_ugc`VALUES('610','从江县','贵州省黔东南苗族侗族自治州从江县','congjiangxian');
INSERTINTO`pd_ugc`VALUES('611','雷山县','贵州省黔东南苗族侗族自治州雷山县','leishanxian');
INSERTINTO`pd_ugc`VALUES('612','麻江县','贵州省黔东南苗族侗族自治州麻江县','majiangxian');
INSERTINTO`pd_ugc`VALUES('613','丹寨县','贵州省黔东南苗族侗族自治州丹寨县','danzhaixian');
INSERTINTO`pd_ugc`VALUES('614','铜仁地区','贵州省铜仁地区市','tongrendiqu');
INSERTINTO`pd_ugc`VALUES('615','铜仁市','贵州省铜仁地区市铜仁市','tongrenshi');
INSERTINTO`pd_ugc`VALUES('616','江口县','贵州省铜仁地区市江口县','jiangkouxian');
INSERTINTO`pd_ugc`VALUES('617','玉屏侗族自治县','贵州省铜仁地区市玉屏侗族自治县','yupingdongzuzizhixian');
INSERTINTO`pd_ugc`VALUES('618','石阡县','贵州省铜仁地区市石阡县','shiqianxian');
INSERTINTO`pd_ugc`VALUES('619','思南县','贵州省铜仁地区市思南县','sinanxian');
INSERTINTO`pd_ugc`VALUES('620','印江土家族苗族自治县','贵州省铜仁地区市印江土家族苗族自治县','yinjiangtujiazumiaozuzizhixian');
INSERTINTO`pd_ugc`VALUES('621','德江县','贵州省铜仁地区市德江县','dejiangxian');
INSERTINTO`pd_ugc`VALUES('622','沿河土家族自治县','贵州省铜仁地区市沿河土家族自治县','yanhetujiazuzizhixian');
INSERTINTO`pd_ugc`VALUES('623','松桃苗族自治县','贵州省铜仁地区市松桃苗族自治县','songtaomiaozuzizhixian');
INSERTINTO`pd_ugc`VALUES('624','万山特区','贵州省铜仁地区市万山特区','wanshantequ');
INSERTINTO`pd_ugc`VALUES('625','毕节地区','贵州省毕节地区市','bijiediqu');
INSERTINTO`pd_ugc`VALUES('626','毕节市','贵州省毕节地区市毕节市','bijieshi');
INSERTINTO`pd_ugc`VALUES('627','大方县','贵州省毕节地区市大方县','dafangxian');
INSERTINTO`pd_ugc`VALUES('628','黔西县','贵州省毕节地区市黔西县','qianxixian');
INSERTINTO`pd_ugc`VALUES('629','金沙县','贵州省毕节地区市金沙县','jinshaxian');
INSERTINTO`pd_ugc`VALUES('630','织金县','贵州省毕节地区市织金县','zhijinxian');
INSERTINTO`pd_ugc`VALUES('631','纳雍县','贵州省毕节地区市纳雍县','nayongxian');
INSERTINTO`pd_ugc`VALUES('632','威宁彝族回族苗族自治县','贵州省毕节地区市威宁彝族回族苗族自治县','weiningyizuhuizumiaozuzizhixia');
INSERTINTO`pd_ugc`VALUES('633','赫章县','贵州省毕节地区市赫章县','hezhangxian');
INSERTINTO`pd_ugc`VALUES('634','六盘水市','贵州省六盘水市','liupanshuishi');
INSERTINTO`pd_ugc`VALUES('635','钟山区','贵州省六盘水市钟山区','zhongshanqu');
INSERTINTO`pd_ugc`VALUES('636','六枝特区','贵州省六盘水市六枝特区','liuzhitequ');
INSERTINTO`pd_ugc`VALUES('637','水城县','贵州省六盘水市水城县','shuichengxian');
INSERTINTO`pd_ugc`VALUES('638','盘县','贵州省六盘水市盘县','panxian');
INSERTINTO`pd_ugc`VALUES('639','黔西南布依族苗族自治州','贵州省黔西南布依族苗族自治州','qianxinanbuyizumiaozuzizhizhou');
INSERTINTO`pd_ugc`VALUES('640','望谟县','贵州省黔西南布依族苗族自治州望谟县','wangmoxian');
INSERTINTO`pd_ugc`VALUES('641','册亨县','贵州省黔西南布依族苗族自治州册亨县','cehengxian');
INSERTINTO`pd_ugc`VALUES('642','安龙县','贵州省黔西南布依族苗族自治州安龙县','anlongxian');
INSERTINTO`pd_ugc`VALUES('643','兴义市','贵州省黔西南布依族苗族自治州兴义市','xingyishi');
INSERTINTO`pd_ugc`VALUES('644','兴仁县','贵州省黔西南布依族苗族自治州兴仁县','xingrenxian');
INSERTINTO`pd_ugc`VALUES('645','普安县','贵州省黔西南布依族苗族自治州普安县','puanxian');
INSERTINTO`pd_ugc`VALUES('646','晴隆县','贵州省黔西南布依族苗族自治州晴隆县','qinglongxian');
INSERTINTO`pd_ugc`VALUES('647','贞丰县','贵州省黔西南布依族苗族自治州贞丰县','zhenfengxian');
INSERTINTO`pd_ugc`VALUES('648','岳阳市','湖南省岳阳市','yueyangshi');
INSERTINTO`pd_ugc`VALUES('649','岳阳楼区','湖南省岳阳市岳阳楼区','yueyanglouqu');
INSERTINTO`pd_ugc`VALUES('650','云溪区','湖南省岳阳市云溪区','yunxiqu');
INSERTINTO`pd_ugc`VALUES('651','君山区','湖南省岳阳市君山区','junshanqu');
INSERTINTO`pd_ugc`VALUES('652','岳阳县','湖南省岳阳市岳阳县','yueyangxian');
INSERTINTO`pd_ugc`VALUES('653','华容县','湖南省岳阳市华容县','huarongxian');
INSERTINTO`pd_ugc`VALUES('654','湘阴县','湖南省岳阳市湘阴县','xiangyinxian');
INSERTINTO`pd_ugc`VALUES('655','平江县','湖南省岳阳市平江县','pingjiangxian');
INSERTINTO`pd_ugc`VALUES('656','汨罗市','湖南省岳阳市汨罗市','miluoshi');
INSERTINTO`pd_ugc`VALUES('657','临湘市','湖南省岳阳市临湘市','linxiangshi');
INSERTINTO`pd_ugc`VALUES('658','长沙市','湖南省长沙市','zhangshashi');
INSERTINTO`pd_ugc`VALUES('659','芙蓉区','湖南省长沙市芙蓉区','furongqu');
INSERTINTO`pd_ugc`VALUES('660','天心区','湖南省长沙市天心区','tianxinqu');
INSERTINTO`pd_ugc`VALUES('661','岳麓区','湖南省长沙市岳麓区','yueluqu');
INSERTINTO`pd_ugc`VALUES('662','开福区','湖南省长沙市开福区','kaifuqu');
INSERTINTO`pd_ugc`VALUES('663','雨花区','湖南省长沙市雨花区','yuhuaqu');
INSERTINTO`pd_ugc`VALUES('664','长沙县','湖南省长沙市长沙县','zhangshaxian');
INSERTINTO`pd_ugc`VALUES('665','望城县','湖南省长沙市望城县','wangchengxian');
INSERTINTO`pd_ugc`VALUES('666','宁乡县','湖南省长沙市宁乡县','ningxiangxian');
INSERTINTO`pd_ugc`VALUES('667','浏阳市','湖南省长沙市浏阳市','liuyangshi');
INSERTINTO`pd_ugc`VALUES('668','湘潭市','湖南省湘潭市','xiangtanshi');
INSERTINTO`pd_ugc`VALUES('669','雨湖区','湖南省湘潭市雨湖区','yuhuqu');
INSERTINTO`pd_ugc`VALUES('670','岳塘区','湖南省湘潭市岳塘区','yuetangqu');
INSERTINTO`pd_ugc`VALUES('671','湘潭县','湖南省湘潭市湘潭县','xiangtanxian');
INSERTINTO`pd_ugc`VALUES('672','湘乡市','湖南省湘潭市湘乡市','xiangxiangshi');
INSERTINTO`pd_ugc`VALUES('673','韶山市','湖南省湘潭市韶山市','shaoshanshi');
INSERTINTO`pd_ugc`VALUES('674','株洲市','湖南省株洲市','zhuzhoushi');
INSERTINTO`pd_ugc`VALUES('675','荷塘区','湖南省株洲市荷塘区','hetangqu');
INSERTINTO`pd_ugc`VALUES('676','芦淞区','湖南省株洲市芦淞区','lusongqu');
INSERTINTO`pd_ugc`VALUES('677','石峰区','湖南省株洲市石峰区','shifengqu');
INSERTINTO`pd_ugc`VALUES('678','天元区','湖南省株洲市天元区','tianyuanqu');
INSERTINTO`pd_ugc`VALUES('679','株洲县','湖南省株洲市株洲县','zhuzhouxian');
INSERTINTO`pd_ugc`VALUES('680','攸县','湖南省株洲市攸县','youxian');
INSERTINTO`pd_ugc`VALUES('681','茶陵县','湖南省株洲市茶陵县','chalingxian');
INSERTINTO`pd_ugc`VALUES('682','炎陵县','湖南省株洲市炎陵县','yanlingxian');
INSERTINTO`pd_ugc`VALUES('683','醴陵市','湖南省株洲市醴陵市','lilingshi');
INSERTINTO`pd_ugc`VALUES('684','衡阳市','湖南省衡阳市','hengyangshi');
INSERTINTO`pd_ugc`VALUES('685','珠晖区','湖南省衡阳市珠晖区','zhuhuiqu');
INSERTINTO`pd_ugc`VALUES('686','雁峰区','湖南省衡阳市雁峰区','yanfengqu');
INSERTINTO`pd_ugc`VALUES('687','石鼓区','湖南省衡阳市石鼓区','shiguqu');
INSERTINTO`pd_ugc`VALUES('688','蒸湘区','湖南省衡阳市蒸湘区','zhengxiangqu');
INSERTINTO`pd_ugc`VALUES('689','南岳区','湖南省衡阳市南岳区','nanyuequ');
INSERTINTO`pd_ugc`VALUES('690','衡阳县','湖南省衡阳市衡阳县','hengyangxian');
INSERTINTO`pd_ugc`VALUES('691','衡南县','湖南省衡阳市衡南县','hengnanxian');
INSERTINTO`pd_ugc`VALUES('692','衡山县','湖南省衡阳市衡山县','hengshanxian');
INSERTINTO`pd_ugc`VALUES('693','衡东县','湖南省衡阳市衡东县','hengdongxian');
INSERTINTO`pd_ugc`VALUES('694','祁东县','湖南省衡阳市祁东县','qidongxian');
INSERTINTO`pd_ugc`VALUES('695','耒阳市','湖南省衡阳市耒阳市','leiyangshi');
INSERTINTO`pd_ugc`VALUES('696','常宁市','湖南省衡阳市常宁市','changningshi');
INSERTINTO`pd_ugc`VALUES('697','郴州市','湖南省郴州市','chenzhoushi');
INSERTINTO`pd_ugc`VALUES('698','北湖区','湖南省郴州市北湖区','beihuqu');
INSERTINTO`pd_ugc`VALUES('699','苏仙区','湖南省郴州市苏仙区','suxianqu');
INSERTINTO`pd_ugc`VALUES('700','桂阳县','湖南省郴州市桂阳县','guiyangxian');
INSERTINTO`pd_ugc`VALUES('701','宜章县','湖南省郴州市宜章县','yizhangxian');
INSERTINTO`pd_ugc`VALUES('702','永兴县','湖南省郴州市永兴县','yongxingxian');
INSERTINTO`pd_ugc`VALUES('703','嘉禾县','湖南省郴州市嘉禾县','jiahexian');
INSERTINTO`pd_ugc`VALUES('704','临武县','湖南省郴州市临武县','linwuxian');
INSERTINTO`pd_ugc`VALUES('705','汝城县','湖南省郴州市汝城县','ruchengxian');
INSERTINTO`pd_ugc`VALUES('706','桂东县','湖南省郴州市桂东县','guidongxian');
INSERTINTO`pd_ugc`VALUES('707','安仁县','湖南省郴州市安仁县','anrenxian');
INSERTINTO`pd_ugc`VALUES('708','资兴市','湖南省郴州市资兴市','zixingshi');
INSERTINTO`pd_ugc`VALUES('709','常德市','湖南省常德市','changdeshi');
INSERTINTO`pd_ugc`VALUES('710','武陵区','湖南省常德市武陵区','wulingqu');
INSERTINTO`pd_ugc`VALUES('711','鼎城区','湖南省常德市鼎城区','dingchengqu');
INSERTINTO`pd_ugc`VALUES('712','安乡县','湖南省常德市安乡县','anxiangxian');
INSERTINTO`pd_ugc`VALUES('713','汉寿县','湖南省常德市汉寿县','hanshouxian');
INSERTINTO`pd_ugc`VALUES('714','澧县','湖南省常德市澧县','lixian');
INSERTINTO`pd_ugc`VALUES('715','临澧县','湖南省常德市临澧县','linlixian');
INSERTINTO`pd_ugc`VALUES('716','桃源县','湖南省常德市桃源县','taoyuanxian');
INSERTINTO`pd_ugc`VALUES('717','石门县','湖南省常德市石门县','shimenxian');
INSERTINTO`pd_ugc`VALUES('718','津市市','湖南省常德市津市市','jinshishi');
INSERTINTO`pd_ugc`VALUES('719','益阳市','湖南省益阳市','yiyangshi');
INSERTINTO`pd_ugc`VALUES('720','资阳区','湖南省益阳市资阳区','ziyangqu');
INSERTINTO`pd_ugc`VALUES('721','赫山区','湖南省益阳市赫山区','heshanqu');
INSERTINTO`pd_ugc`VALUES('722','南县','湖南省益阳市南县','nanxian');
INSERTINTO`pd_ugc`VALUES('723','桃江县','湖南省益阳市桃江县','taojiangxian');
INSERTINTO`pd_ugc`VALUES('724','安化县','湖南省益阳市安化县','anhuaxian');
INSERTINTO`pd_ugc`VALUES('725','沅江市','湖南省益阳市沅江市','yuanjiangshi');
INSERTINTO`pd_ugc`VALUES('726','娄底市','湖南省娄底市','loudishi');
INSERTINTO`pd_ugc`VALUES('727','娄星区','湖南省娄底市娄星区','louxingqu');
INSERTINTO`pd_ugc`VALUES('728','双峰县','湖南省娄底市双峰县','shuangfengxian');
INSERTINTO`pd_ugc`VALUES('729','新化县','湖南省娄底市新化县','xinhuaxian');
INSERTINTO`pd_ugc`VALUES('730','冷水江市','湖南省娄底市冷水江市','lengshuijiangshi');
INSERTINTO`pd_ugc`VALUES('731','涟源市','湖南省娄底市涟源市','lianyuanshi');
INSERTINTO`pd_ugc`VALUES('732','邵阳市','湖南省邵阳市','shaoyangshi');
INSERTINTO`pd_ugc`VALUES('733','双清区','湖南省邵阳市双清区','shuangqingqu');
INSERTINTO`pd_ugc`VALUES('734','大祥区','湖南省邵阳市大祥区','daxiangqu');
INSERTINTO`pd_ugc`VALUES('735','北塔区','湖南省邵阳市北塔区','beitaqu');
INSERTINTO`pd_ugc`VALUES('736','邵东县','湖南省邵阳市邵东县','shaodongxian');
INSERTINTO`pd_ugc`VALUES('737','新邵县','湖南省邵阳市新邵县','xinshaoxian');
INSERTINTO`pd_ugc`VALUES('738','邵阳县','湖南省邵阳市邵阳县','shaoyangxian');
INSERTINTO`pd_ugc`VALUES('739','隆回县','湖南省邵阳市隆回县','longhuixian');
INSERTINTO`pd_ugc`VALUES('740','洞口县','湖南省邵阳市洞口县','dongkouxian');
INSERTINTO`pd_ugc`VALUES('741','绥宁县','湖南省邵阳市绥宁县','suiningxian');
INSERTINTO`pd_ugc`VALUES('742','新宁县','湖南省邵阳市新宁县','xinningxian');
INSERTINTO`pd_ugc`VALUES('743','城步苗族自治县','湖南省邵阳市城步苗族自治县','chengbumiaozuzizhixian');
INSERTINTO`pd_ugc`VALUES('744','武冈市','湖南省邵阳市武冈市','wugangshi');
INSERTINTO`pd_ugc`VALUES('745','湘西土家族苗族自治州','湖南省湘西土家族苗族自治州','xiangxitujiazumiaozuzizhizhou');
INSERTINTO`pd_ugc`VALUES('746','吉首市','湖南省湘西土家族苗族自治州吉首市','jishoushi');
INSERTINTO`pd_ugc`VALUES('747','泸溪县','湖南省湘西土家族苗族自治州泸溪县','luxixian');
INSERTINTO`pd_ugc`VALUES('748','凤凰县','湖南省湘西土家族苗族自治州凤凰县','fenghuangxian');
INSERTINTO`pd_ugc`VALUES('749','花垣县','湖南省湘西土家族苗族自治州花垣县','huayuanxian');
INSERTINTO`pd_ugc`VALUES('750','保靖县','湖南省湘西土家族苗族自治州保靖县','baojingxian');
INSERTINTO`pd_ugc`VALUES('751','古丈县','湖南省湘西土家族苗族自治州古丈县','guzhangxian');
INSERTINTO`pd_ugc`VALUES('752','永顺县','湖南省湘西土家族苗族自治州永顺县','yongshunxian');
INSERTINTO`pd_ugc`VALUES('753','龙山县','湖南省湘西土家族苗族自治州龙山县','longshanxian');
INSERTINTO`pd_ugc`VALUES('754','张家界市','湖南省张家界市','zhangjiajieshi');
INSERTINTO`pd_ugc`VALUES('755','永定区','湖南省张家界市永定区','yongdingqu');
INSERTINTO`pd_ugc`VALUES('756','武陵源区','湖南省张家界市武陵源区','wulingyuanqu');
INSERTINTO`pd_ugc`VALUES('757','慈利县','湖南省张家界市慈利县','cilixian');
INSERTINTO`pd_ugc`VALUES('758','桑植县','湖南省张家界市桑植县','sangzhixian');
INSERTINTO`pd_ugc`VALUES('759','怀化市','湖南省怀化市','huaihuashi');
INSERTINTO`pd_ugc`VALUES('760','鹤城区','湖南省怀化市鹤城区','hechengqu');
INSERTINTO`pd_ugc`VALUES('761','中方县','湖南省怀化市中方县','zhongfangxian');
INSERTINTO`pd_ugc`VALUES('762','沅陵县','湖南省怀化市沅陵县','yuanlingxian');
INSERTINTO`pd_ugc`VALUES('763','辰溪县','湖南省怀化市辰溪县','chenxixian');
INSERTINTO`pd_ugc`VALUES('764','溆浦县','湖南省怀化市溆浦县','xupuxian');
INSERTINTO`pd_ugc`VALUES('765','会同县','湖南省怀化市会同县','huitongxian');
INSERTINTO`pd_ugc`VALUES('766','麻阳苗族自治县','湖南省怀化市麻阳苗族自治县','mayangmiaozuzizhixian');
INSERTINTO`pd_ugc`VALUES('767','新晃侗族自治县','湖南省怀化市新晃侗族自治县','xinhuangdongzuzizhixian');
INSERTINTO`pd_ugc`VALUES('768','芷江侗族自治县','湖南省怀化市芷江侗族自治县','zhijiangdongzuzizhixian');
INSERTINTO`pd_ugc`VALUES('769','靖州苗族侗族自治县','湖南省怀化市靖州苗族侗族自治县','jingzhoumiaozudongzuzizhixian');
INSERTINTO`pd_ugc`VALUES('770','通道侗族自治县','湖南省怀化市通道侗族自治县','tongdaodongzuzizhixian');
INSERTINTO`pd_ugc`VALUES('771','洪江市','湖南省怀化市洪江市','hongjiangshi');
INSERTINTO`pd_ugc`VALUES('772','永州市','湖南省永州市','yongzhoushi');
INSERTINTO`pd_ugc`VALUES('773','零陵区','湖南省永州市零陵区','linglingqu');
INSERTINTO`pd_ugc`VALUES('774','冷水滩区','湖南省永州市冷水滩区','lengshuitanqu');
INSERTINTO`pd_ugc`VALUES('775','祁阳县','湖南省永州市祁阳县','qiyangxian');
INSERTINTO`pd_ugc`VALUES('776','东安县','湖南省永州市东安县','donganxian');
INSERTINTO`pd_ugc`VALUES('777','双牌县','湖南省永州市双牌县','shuangpaixian');
INSERTINTO`pd_ugc`VALUES('778','閬撳幙','婀栧崡鐪佹案宸炲競閬撳幙','langqinmu');
INSERTINTO`pd_ugc`VALUES('779','江永县','湖南省永州市江永县','jiangyongxian');
INSERTINTO`pd_ugc`VALUES('780','宁远县','湖南省永州市宁远县','ningyuanxian');
INSERTINTO`pd_ugc`VALUES('781','蓝山县','湖南省永州市蓝山县','lanshanxian');
INSERTINTO`pd_ugc`VALUES('782','新田县','湖南省永州市新田县','xintianxian');
INSERTINTO`pd_ugc`VALUES('783','江华瑶族自治县','湖南省永州市江华瑶族自治县','jianghuayaozuzizhixian');
INSERTINTO`pd_ugc`VALUES('784','福州市','福建省福州市','fuzhoushi');
INSERTINTO`pd_ugc`VALUES('785','鼓楼区','福建省福州市鼓楼区','gulouqu');
INSERTINTO`pd_ugc`VALUES('786','台江区','福建省福州市台江区','taijiangqu');
INSERTINTO`pd_ugc`VALUES('787','仓山区','福建省福州市仓山区','cangshanqu');
INSERTINTO`pd_ugc`VALUES('788','马尾区','福建省福州市马尾区','maweiqu');
INSERTINTO`pd_ugc`VALUES('789','晋安区','福建省福州市晋安区','jinanqu');
INSERTINTO`pd_ugc`VALUES('790','闽侯县','福建省福州市闽侯县','minhouxian');
INSERTINTO`pd_ugc`VALUES('791','连江县','福建省福州市连江县','lianjiangxian');
INSERTINTO`pd_ugc`VALUES('792','罗源县','福建省福州市罗源县','luoyuanxian');
INSERTINTO`pd_ugc`VALUES('793','闽清县','福建省福州市闽清县','minqingxian');
INSERTINTO`pd_ugc`VALUES('794','永泰县','福建省福州市永泰县','yongtaixian');
INSERTINTO`pd_ugc`VALUES('795','平潭县','福建省福州市平潭县','pingtanxian');
INSERTINTO`pd_ugc`VALUES('796','福清市','福建省福州市福清市','fuqingshi');
INSERTINTO`pd_ugc`VALUES('797','长乐市','福建省福州市长乐市','zhangleshi');
INSERTINTO`pd_ugc`VALUES('798','厦门市','福建省厦门市','shamenshi');
INSERTINTO`pd_ugc`VALUES('799','思明区','福建省厦门市思明区','simingqu');
INSERTINTO`pd_ugc`VALUES('800','海沧区','福建省厦门市海沧区','haicangqu');
INSERTINTO`pd_ugc`VALUES('801','湖里区','福建省厦门市湖里区','huliqu');
INSERTINTO`pd_ugc`VALUES('802','集美区','福建省厦门市集美区','jimeiqu');
INSERTINTO`pd_ugc`VALUES('803','同安区','福建省厦门市同安区','tonganqu');
INSERTINTO`pd_ugc`VALUES('804','翔安区','福建省厦门市翔安区','xianganqu');
INSERTINTO`pd_ugc`VALUES('805','宁德市','福建省宁德市','ningdeshi');
INSERTINTO`pd_ugc`VALUES('806','蕉城区','福建省宁德市蕉城区','jiaochengqu');
INSERTINTO`pd_ugc`VALUES('807','霞浦县','福建省宁德市霞浦县','xiapuxian');
INSERTINTO`pd_ugc`VALUES('808','古田县','福建省宁德市古田县','gutianxian');
INSERTINTO`pd_ugc`VALUES('809','屏南县','福建省宁德市屏南县','pingnanxian');
INSERTINTO`pd_ugc`VALUES('810','寿宁县','福建省宁德市寿宁县','shouningxian');
INSERTINTO`pd_ugc`VALUES('811','周宁县','福建省宁德市周宁县','zhouningxian');
INSERTINTO`pd_ugc`VALUES('812','柘荣县','福建省宁德市柘荣县','zherongxian');
INSERTINTO`pd_ugc`VALUES('813','福安市','福建省宁德市福安市','fuanshi');
INSERTINTO`pd_ugc`VALUES('814','福鼎市','福建省宁德市福鼎市','fudingshi');
INSERTINTO`pd_ugc`VALUES('815','莆田市','福建省莆田市','putianshi');
INSERTINTO`pd_ugc`VALUES('816','城厢区','福建省莆田市城厢区','chengxiangqu');
INSERTINTO`pd_ugc`VALUES('817','涵江区','福建省莆田市涵江区','hanjiangqu');
INSERTINTO`pd_ugc`VALUES('818','荔城区','福建省莆田市荔城区','lichengqu');
INSERTINTO`pd_ugc`VALUES('819','秀屿区','福建省莆田市秀屿区','xiuyuqu');
INSERTINTO`pd_ugc`VALUES('820','仙游县','福建省莆田市仙游县','xianyouxian');
INSERTINTO`pd_ugc`VALUES('821','泉州市','福建省泉州市','quanzhoushi');
INSERTINTO`pd_ugc`VALUES('822','鲤城区','福建省泉州市鲤城区','lichengqu');
INSERTINTO`pd_ugc`VALUES('823','丰泽区','福建省泉州市丰泽区','fengzequ');
INSERTINTO`pd_ugc`VALUES('824','洛江区','福建省泉州市洛江区','luojiangqu');
INSERTINTO`pd_ugc`VALUES('825','泉港区','福建省泉州市泉港区','quangangqu');
INSERTINTO`pd_ugc`VALUES('826','惠安县','福建省泉州市惠安县','huianxian');
INSERTINTO`pd_ugc`VALUES('827','安溪县','福建省泉州市安溪县','anxixian');
INSERTINTO`pd_ugc`VALUES('828','永春县','福建省泉州市永春县','yongchunxian');
INSERTINTO`pd_ugc`VALUES('829','德化县','福建省泉州市德化县','dehuaxian');
INSERTINTO`pd_ugc`VALUES('830','金门县','福建省泉州市金门县','jinmenxian');
INSERTINTO`pd_ugc`VALUES('831','石狮市','福建省泉州市石狮市','shishishi');
INSERTINTO`pd_ugc`VALUES('832','晋江市','福建省泉州市晋江市','jinjiangshi');
INSERTINTO`pd_ugc`VALUES('833','南安市','福建省泉州市南安市','nananshi');
INSERTINTO`pd_ugc`VALUES('834','漳州市','福建省漳州市','zhangzhoushi');
INSERTINTO`pd_ugc`VALUES('835','芗城区','福建省漳州市芗城区','xiangchengqu');
INSERTINTO`pd_ugc`VALUES('836','龙文区','福建省漳州市龙文区','longwenqu');
INSERTINTO`pd_ugc`VALUES('837','云霄县','福建省漳州市云霄县','yunxiaoxian');
INSERTINTO`pd_ugc`VALUES('838','漳浦县','福建省漳州市漳浦县','zhangpuxian');
INSERTINTO`pd_ugc`VALUES('839','诏安县','福建省漳州市诏安县','zhaoanxian');
INSERTINTO`pd_ugc`VALUES('840','长泰县','福建省漳州市长泰县','zhangtaixian');
INSERTINTO`pd_ugc`VALUES('841','东山县','福建省漳州市东山县','dongshanxian');
INSERTINTO`pd_ugc`VALUES('842','南靖县','福建省漳州市南靖县','nanjingxian');
INSERTINTO`pd_ugc`VALUES('843','平和县','福建省漳州市平和县','pinghexian');
INSERTINTO`pd_ugc`VALUES('844','华安县','福建省漳州市华安县','huaanxian');
INSERTINTO`pd_ugc`VALUES('845','龙海市','福建省漳州市龙海市','longhaishi');
INSERTINTO`pd_ugc`VALUES('846','龙岩市','福建省龙岩市','longyanshi');
INSERTINTO`pd_ugc`VALUES('847','新罗区','福建省龙岩市新罗区','xinluoqu');
INSERTINTO`pd_ugc`VALUES('848','长汀县','福建省龙岩市长汀县','zhangtingxian');
INSERTINTO`pd_ugc`VALUES('849','永定县','福建省龙岩市永定县','yongdingxian');
INSERTINTO`pd_ugc`VALUES('850','上杭县','福建省龙岩市上杭县','shanghangxian');
INSERTINTO`pd_ugc`VALUES('851','武平县','福建省龙岩市武平县','wupingxian');
INSERTINTO`pd_ugc`VALUES('852','连城县','福建省龙岩市连城县','lianchengxian');
INSERTINTO`pd_ugc`VALUES('853','漳平市','福建省龙岩市漳平市','zhangpingshi');
INSERTINTO`pd_ugc`VALUES('854','三明市','福建省三明市','sanmingshi');
INSERTINTO`pd_ugc`VALUES('855','梅列区','福建省三明市梅列区','meiliequ');
INSERTINTO`pd_ugc`VALUES('856','三元区','福建省三明市三元区','sanyuanqu');
INSERTINTO`pd_ugc`VALUES('857','明溪县','福建省三明市明溪县','mingxixian');
INSERTINTO`pd_ugc`VALUES('858','清流县','福建省三明市清流县','qingliuxian');
INSERTINTO`pd_ugc`VALUES('859','宁化县','福建省三明市宁化县','ninghuaxian');
INSERTINTO`pd_ugc`VALUES('860','大田县','福建省三明市大田县','datianxian');
INSERTINTO`pd_ugc`VALUES('861','尤溪县','福建省三明市尤溪县','youxixian');
INSERTINTO`pd_ugc`VALUES('862','沙县','福建省三明市沙县','shaxian');
INSERTINTO`pd_ugc`VALUES('863','将乐县','福建省三明市将乐县','jianglexian');
INSERTINTO`pd_ugc`VALUES('864','泰宁县','福建省三明市泰宁县','tainingxian');
INSERTINTO`pd_ugc`VALUES('865','建宁县','福建省三明市建宁县','jianningxian');
INSERTINTO`pd_ugc`VALUES('866','永安市','福建省三明市永安市','yonganshi');
INSERTINTO`pd_ugc`VALUES('867','南平市','福建省南平市','nanpingshi');
INSERTINTO`pd_ugc`VALUES('868','延平区','福建省南平市延平区','yanpingqu');
INSERTINTO`pd_ugc`VALUES('869','顺昌县','福建省南平市顺昌县','shunchangxian');
INSERTINTO`pd_ugc`VALUES('870','蒲城县','福建省南平市浦城县','puchengxian');
INSERTINTO`pd_ugc`VALUES('871','光泽县','福建省南平市光泽县','guangzexian');
INSERTINTO`pd_ugc`VALUES('872','松溪县','福建省南平市松溪县','songxixian');
INSERTINTO`pd_ugc`VALUES('873','政和县','福建省南平市政和县','zhenghexian');
INSERTINTO`pd_ugc`VALUES('874','邵武市','福建省南平市邵武市','shaowushi');
INSERTINTO`pd_ugc`VALUES('875','武夷山市','福建省南平市武夷山市','wuyishanshi');
INSERTINTO`pd_ugc`VALUES('876','建瓯市','福建省南平市建瓯市','jianoushi');
INSERTINTO`pd_ugc`VALUES('877','建阳市','福建省南平市建阳市','jianyangshi');
INSERTINTO`pd_ugc`VALUES('878','玄武区','江苏省南京市玄武区','xuanwuqu');
INSERTINTO`pd_ugc`VALUES('879','白下区','江苏省南京市白下区','baixiaqu');
INSERTINTO`pd_ugc`VALUES('880','秦淮区','江苏省南京市秦淮区','qinhuaiqu');
INSERTINTO`pd_ugc`VALUES('881','建邺区','江苏省南京市建邺区','jianyequ');
INSERTINTO`pd_ugc`VALUES('882','鼓楼区','江苏省南京市鼓楼区','gulouqu');
INSERTINTO`pd_ugc`VALUES('883','下关区','江苏省南京市下关区','xiaguanqu');
INSERTINTO`pd_ugc`VALUES('884','浦口区','江苏省南京市浦口区','pukouqu');
INSERTINTO`pd_ugc`VALUES('885','栖霞区','江苏省南京市栖霞区','qixiaqu');