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');