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