Java implements the lucene search method of recommends
- 2020-05-26 09:12:50
- OfStack
Direct access code:
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;
// Incremental index
/*
* Implementation approach : Query all records in the database table for the first time, index each record, and finally 1 Records of id Stored in the storeId.txt In the file
* When a new insert 1 When you create an index, you do not have to rebuild all the data 1 Through index,
* According to storage storeId.txt In the file id Find the newly inserted data, create a new index only for the newly added data, and append the newly added index to the original index file
* */
public class IncrementIndex {
public static void main(String[] args) {
try {
IncrementIndex index = new IncrementIndex();
String path = "E:\\Test\\lucene_test\\poiIdext";// The location of the index file
String storeIdPath = "E:\\Test\\lucene_test\\storeId.txt";// storage ID The path of the
String storeId = "";
Date date1 = new Date();
storeId = index.getStoreId(storeIdPath);
ResultSet rs = index.getResult(storeId);
System.out.println(" Start indexing... ");
index.indexBuilding(path, storeIdPath, rs);
Date date2 = new Date();
System.out.println(" Time: "+(date2.getTime()-date1.getTime())+"ms");
storeId = index.getStoreId(storeIdPath);
System.out.println(storeId);// Print it out and save it this time ID
} catch (Exception e) {
e.printStackTrace();
}
}
public static void buildIndex(String indexFile, String storeIdFile) {
try {
String path = indexFile;// The location of the index file
String storeIdPath = storeIdFile;// storage ID The path of the
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();
// Get stored ID , to determine whether the index should be incremented or re-indexed
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 Represents incremental index
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;// Will get the id to storeId This is not a reasonable way to do it
indexFlag = true;
}
writer.optimize();
writer.close();
if (indexFlag) {
// Will be the last 1 One of the ID Save to a disk file
writeStoreId(storeIdPath, storeId);
}
return true;
} catch (Exception e) {
e.printStackTrace();
System.out.println(" Make a mistake " + e.getClass() + "\n The error message is : " + 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));// Query field
doc.add(new Field("address", address, Field.Store.YES, Field.Index.TOKENIZED));
doc.add(new Field("citycode", citycode, Field.Store.YES, Field.Index.TOKENIZED));// Query field
return doc;
}
// Gets stored on disk 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;
}
// will ID Write to a disk file
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. Create an incremental index
public static void buildIndex(String indexFile, String storeIdFile) {
IncrementIndex.buildIndex(indexFile, storeIdFile);
}
//1. Single field query
@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(" Time: " + (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. Multi-conditional queries. So what we're doing here is and operation
// Note: the field to query must be index the
// namely 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 operation
}
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. The highlighted A single conditional query is implemented
// Can be transformed to multi-condition query
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. Multifield query
@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. Remove the index
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. 1 Yuan participle
@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(" Analysis method: default no words only words ( 1 Yuan participle) ");
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. A dictionary word
@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(" Analysis method : A dictionary word , Reciprocal search ");
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;
}
// Search in the results
public static void queryFromResults() {
}
// The assembly objects
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 {
// Store index files
private static String indexFile = "E:\\Test\\lucene_test\\poiIdext";
// store id
private static String storeIdFile = "E:\\Test\\lucene_test\\storeId.txt";
public static void main(String[] args) throws Exception {
//0. Create an incremental index
IndexUtils.buildIndex(indexFile, storeIdFile);
IndexSearcher indexSearcher = new IndexSearcher(indexFile);
List<IndexResult> list =null;
// String key ="";
Date date1 = new Date();
Date date2 =new Date();
//1. Single field query
// key = IndexUtils.ik_CAnalyzer(" Shanghai ");
// list = IndexUtils.queryByOneKey(indexSearcher, "address", key);
// date2 = new Date();
// System.out.println(" Time: " + (date2.getTime() - date1.getTime()) + "ms\n" + list.size()
// + " article ======================================= Single field query ");
// printResults(list);
// System.exit(1);
//2. Multiconditional query
String[] fields = { "name", "address" };
String[] keys = { IndexUtils.ik_CAnalyzer(" yongcheng ")};
date1 = new Date();
list = IndexUtils.queryByMultiKeys(indexSearcher, fields, keys);
date2 = new Date();
System.out.println(" Query time: " + (date2.getTime() - date1.getTime()) + "ms\n" + list.size()
+ " article \n=============================== Multiconditional query ");
printResults(list);
System.exit(1);
//3. The highlighted Single field query
// System.out.println("\n\n");
// date1 = new Date();
// key=" anhui ";
// list = IndexUtils.highlight(indexSearcher, key);
// date2 = new Date();
// System.out.println(" Time: " + (date2.getTime() - date1.getTime()) + "ms\n" + list.size()
// + " article \n====================================== The highlighted ");
// printResults(list);
// System.exit(1);
//4. Multifield query
// date1 = new Date();
// list = IndexUtils.queryByMultiFileds(indexSearcher, fields, key);
// date2 = new Date();
// System.out.println(" Time: " + (date2.getTime() - date1.getTime()) + "ms\n" + list.size()
// + " article \n===================================== Multifield query ");
// printResults(list);
//5. Drop the fields in the index According to the id To delete
// IndexUtils.deleteIndex(indexFile, "1552");
}
// Print the result
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);
}
}
}
}
Database script:
INSERT INTO `pd_ugc` VALUES ('1', ' Shanghai ', ' Shanghai ', 'shanghaishi');
INSERT INTO `pd_ugc` VALUES ('2', ' Shanghai ', ' Shanghai ', 'shanghaishi');
INSERT INTO `pd_ugc` VALUES ('5', ' The Beijing municipal ', ' The Beijing municipal ', 'beijingshi');
INSERT INTO `pd_ugc` VALUES ('6', ' The Beijing municipal ', ' The Beijing municipal ', 'beijingshi');
INSERT INTO `pd_ugc` VALUES ('9', ' Guangdong province, ', ' Guangdong province, ', 'guangdongsheng');
INSERT INTO `pd_ugc` VALUES ('10', ' guangzhou ', ' Guangzhou city, guangdong province ', 'guangzhoushi');
INSERT INTO `pd_ugc` VALUES ('11', ' Liwan district ', ' Liwan district, guangzhou city, guangdong province ', 'liwanqu');
INSERT INTO `pd_ugc` VALUES ('12', ' Yuexiu district ', ' Yuexiu district, guangzhou city, guangdong province ', 'yuexiuqu');
INSERT INTO `pd_ugc` VALUES ('13', ' Dongshan district ', ' Dongshan district, guangzhou city, guangdong province ', 'dongshanqu');
INSERT INTO `pd_ugc` VALUES ('14', ' The tianhe district ', ' Tianhe district, guangzhou city, guangdong province ', 'tianhequ');
INSERT INTO `pd_ugc` VALUES ('15', ' zhuhai ', ' Haizhu district, guangzhou city, guangdong province ', 'haizhuqu');
INSERT INTO `pd_ugc` VALUES ('17', ' tianjin ', ' tianjin ', 'tianjinshi');
INSERT INTO `pd_ugc` VALUES ('18', ' tianjin ', ' tianjin ', 'tianjinshi');
INSERT INTO `pd_ugc` VALUES ('20', ' In hebei province ', ' In hebei province ', 'hebeisheng');
INSERT INTO `pd_ugc` VALUES ('23', ' Shanxi Province ', ' Shanxi Province ', 'shanxisheng');
INSERT INTO `pd_ugc` VALUES ('26', ' Inner Mongolia autonomous region ', ' Inner Mongolia autonomous region ', 'neimengguzizhiqu');
INSERT INTO `pd_ugc` VALUES ('29', ' Liaoning province ', ' Liaoning province ', 'liaoningsheng');
INSERT INTO `pd_ugc` VALUES ('32', ' Jilin province ', ' Jilin province ', 'jilinsheng');
INSERT INTO `pd_ugc` VALUES ('35', ' Heilongjiang province ', ' Heilongjiang province ', 'heilongjiangsheng');
INSERT INTO `pd_ugc` VALUES ('41', ' Jiangsu province ', ' Jiangsu province ', 'jiangsusheng');
INSERT INTO `pd_ugc` VALUES ('44', ' Zhejiang province ', ' Zhejiang province ', 'zhejiangsheng');
INSERT INTO `pd_ugc` VALUES ('47', ' In anhui province ', ' In anhui province ', 'anhuisheng');
INSERT INTO `pd_ugc` VALUES ('50', ' Fujian province ', ' Fujian province ', 'fujiansheng');
INSERT INTO `pd_ugc` VALUES ('53', ' Jiangxi province ', ' Jiangxi province ', 'jiangxisheng');
INSERT INTO `pd_ugc` VALUES ('56', ' In shandong province ', ' In shandong province ', 'shandongsheng');
INSERT INTO `pd_ugc` VALUES ('59', ' Henan province ', ' Henan province ', 'henansheng');
INSERT INTO `pd_ugc` VALUES ('62', ' Hubei province ', ' Hubei province ', 'hubeisheng');
INSERT INTO `pd_ugc` VALUES ('65', ' Hunan province ', ' Hunan province ', 'hunansheng');
INSERT INTO `pd_ugc` VALUES ('68', ' chongqing ', ' chongqing ', 'zhongqingshi');
INSERT INTO `pd_ugc` VALUES ('69', ' chongqing ', ' chongqing ', 'zhongqingshi');
INSERT INTO `pd_ugc` VALUES ('71', '4 Sichuan province ', '4 Sichuan province ', 'sichuansheng');
INSERT INTO `pd_ugc` VALUES ('74', ' The guizhou province ', ' The guizhou province ', 'guizhousheng');
INSERT INTO `pd_ugc` VALUES ('77', ' In yunnan province, ', ' In yunnan province, ', 'yunnansheng');
INSERT INTO `pd_ugc` VALUES ('80', ' Tibet autonomous region ', ' Tibet autonomous region ', 'xizangzizhiqu');
INSERT INTO `pd_ugc` VALUES ('83', ' Shaanxi province ', ' Shaanxi province ', 'shanxisheng');
INSERT INTO `pd_ugc` VALUES ('86', ' Gansu province ', ' Gansu province ', 'gansusheng');
INSERT INTO `pd_ugc` VALUES ('89', ' Qinghai province ', ' Qinghai province ', 'qinghaisheng');
INSERT INTO `pd_ugc` VALUES ('92', ' Ningxia hui autonomous region ', ' Ningxia hui autonomous region ', 'ningxiahuizuzizhiqu');
INSERT INTO `pd_ugc` VALUES ('95', ' Xinjiang uygur autonomous region ', ' Xinjiang uygur autonomous region ', 'xinjiangweiwuerzizhiqu');
INSERT INTO `pd_ugc` VALUES ('101', ' Guangxi zhuang autonomous region ', ' Guangxi province, ', 'guangxizhuangzuzizhiqu');
INSERT INTO `pd_ugc` VALUES ('104', ' Hainan province, ', ' Hainan province, ', 'hainansheng');
INSERT INTO `pd_ugc` VALUES ('116', ' nanjing ', ' Nanjing, jiangsu province ', 'nanjingshi');
INSERT INTO `pd_ugc` VALUES ('117', ' Xuzhou city ', ' Xuzhou city, jiangsu province ', 'xuzhoushi');
INSERT INTO `pd_ugc` VALUES ('118', ' Lianyungang city ', ' Lianyungang city, jiangsu province ', 'lianyungangshi');
INSERT INTO `pd_ugc` VALUES ('119', ' suqian ', ' Suqian city, jiangsu province ', 'suqianshi');
INSERT INTO `pd_ugc` VALUES ('120', ' huaian ', ' Huai 'an city, jiangsu province ', 'huaianshi');
INSERT INTO `pd_ugc` VALUES ('121', ' Yancheng city ', ' Yancheng city, jiangsu province ', 'yanchengshi');
INSERT INTO `pd_ugc` VALUES ('122', ' Yangzhou city ', ' Yangzhou, jiangsu province ', 'yangzhoushi');
INSERT INTO `pd_ugc` VALUES ('123', ' taizhou ', ' Taizhou city, jiangsu province ', 'taizhoushi');
INSERT INTO `pd_ugc` VALUES ('124', ' zhenjiang ', ' Zhenjiang city, jiangsu province ', 'zhenjiangshi');
INSERT INTO `pd_ugc` VALUES ('125', ' changzhou ', ' Changzhou city, jiangsu province ', 'changzhoushi');
INSERT INTO `pd_ugc` VALUES ('126', ' Wuxi city ', ' Wuxi, jiangsu province ', 'wuxishi');
INSERT INTO `pd_ugc` VALUES ('127', ' suzhou ', ' Suzhou city, jiangsu province ', 'suzhoushi');
INSERT INTO `pd_ugc` VALUES ('128', ' nantong ', ' Nantong, jiangsu province ', 'nantongshi');
INSERT INTO `pd_ugc` VALUES ('130', ' hangzhou ', ' Hangzhou city, zhejiang province ', 'hangzhoushi');
INSERT INTO `pd_ugc` VALUES ('131', ' wenzhou ', ' Wenzhou, zhejiang province ', 'wenzhoushi');
INSERT INTO `pd_ugc` VALUES ('132', ' Jiaxing city ', ' Jiaxing city, zhejiang province ', 'jiaxingshi');
INSERT INTO `pd_ugc` VALUES ('133', ' huzhou ', ' Huzhou city, zhejiang province ', 'huzhoushi');
INSERT INTO `pd_ugc` VALUES ('134', ' shaoxing ', ' Shaoxing city, zhejiang province ', 'shaoxingshi');
INSERT INTO `pd_ugc` VALUES ('135', ' Jinhua city ', ' Jinhua city, zhejiang province ', 'jinhuashi');
INSERT INTO `pd_ugc` VALUES ('136', ' Quzhou City ', ' Zhejiang province Quzhou City ', 'quzhoushi');
INSERT INTO `pd_ugc` VALUES ('137', ' Zhoushan city ', ' Zhoushan city, zhejiang province ', 'zhoushanshi');
INSERT INTO `pd_ugc` VALUES ('138', ' taizhou ', ' Taizhou city, zhejiang province ', 'taizhoushi');
INSERT INTO `pd_ugc` VALUES ('139', ' Lishui city ', ' Lishui city, zhejiang province ', 'lishuishi');
INSERT INTO `pd_ugc` VALUES ('181', ' for ', ' Shanghai chongming, changxing, hengsha 3 island ', 'chongmingxian');
INSERT INTO `pd_ugc` VALUES ('201', ' Huangpu district ', ' Huangpu district, Shanghai ', 'huangpuqu');
INSERT INTO `pd_ugc` VALUES ('202', ' Luwan district ', ' Luwan district, Shanghai ', 'luwanqu');
INSERT INTO `pd_ugc` VALUES ('203', ' Xuhui district ', ' Xuhui district, Shanghai ', 'xuhuiqu');
INSERT INTO `pd_ugc` VALUES ('204', ' Changning district ', ' Changning district, Shanghai ', 'zhangningqu');
INSERT INTO `pd_ugc` VALUES ('205', ' Jing'an District ', ' Jing 'an district, Shanghai ', 'jinganqu');
INSERT INTO `pd_ugc` VALUES ('206', ' zhabei ', ' Zhabei district, Shanghai ', 'zhabeiqu');
INSERT INTO `pd_ugc` VALUES ('207', ' Hongkou district ', ' Hongkou district, Shanghai ', 'hongkouqu');
INSERT INTO `pd_ugc` VALUES ('208', ' Yangpu district ', ' Yangpu district, Shanghai ', 'yangpuqu');
INSERT INTO `pd_ugc` VALUES ('209', ' Baoshan district ', ' Baoshan district, Shanghai ', 'baoshanqu');
INSERT INTO `pd_ugc` VALUES ('210', ' Minhang district ', ' Minhang district, Shanghai ', 'minxingqu');
INSERT INTO `pd_ugc` VALUES ('211', ' Jiading district, ', ' Jiading district, Shanghai ', 'jiadingqu');
INSERT INTO `pd_ugc` VALUES ('212', ' Pudong new area ', ' Pudong new area, Shanghai ', 'pudongxinqu');
INSERT INTO `pd_ugc` VALUES ('213', ' Qingpu, ', ' Qingpu district, Shanghai ', 'qingpuqu');
INSERT INTO `pd_ugc` VALUES ('214', ' Songjiang district ', ' Songjiang district, Shanghai ', 'songjiangqu');
INSERT INTO `pd_ugc` VALUES ('215', ' jinshan ', ' Jinshan district, Shanghai ', 'jinshanqu');
INSERT INTO `pd_ugc` VALUES ('216', ' Nanhui district ', ' Nanhui district, Shanghai ', 'nanhuiqu');
INSERT INTO `pd_ugc` VALUES ('217', ' The district ', ' Fengxian district, Shanghai ', 'fengxianqu');
INSERT INTO `pd_ugc` VALUES ('218', ' Putuo district ', ' Putuo district, Shanghai ', 'putuoqu');
INSERT INTO `pd_ugc` VALUES ('222', ' uptown ', ' Shangcheng district, hangzhou city, zhejiang province ', 'shangchengqu');
INSERT INTO `pd_ugc` VALUES ('223', ' In lower ', ' Xiacheng district, hangzhou city, zhejiang province ', 'xiachengqu');
INSERT INTO `pd_ugc` VALUES ('224', ' Jianggan district ', ' Jianggan district, hangzhou city, zhejiang province ', 'jiangganqu');
INSERT INTO `pd_ugc` VALUES ('225', ' Gongshu district ', ' Gongshu district, hangzhou city, zhejiang province ', 'gongshuqu');
INSERT INTO `pd_ugc` VALUES ('226', ' lake ', ' Xihu district, hangzhou city, zhejiang province ', 'xihuqu');
INSERT INTO `pd_ugc` VALUES ('227', ' Binjiang, ', ' Binjiang district, hangzhou city, zhejiang province ', 'binjiangqu');
INSERT INTO `pd_ugc` VALUES ('228', ' Xiaoshan district, ', ' Xiaoshan district, hangzhou city, zhejiang province ', 'xiaoshanqu');
INSERT INTO `pd_ugc` VALUES ('229', ' Yuhang district ', ' Yuhang district, hangzhou city, zhejiang province ', 'yuhangqu');
INSERT INTO `pd_ugc` VALUES ('230', ' Tonglu county ', ' Tonglu county, hangzhou city, zhejiang province ', 'tongluxian');
INSERT INTO `pd_ugc` VALUES ('231', ' Chunan county ', ' Chun 'an county, hangzhou city, zhejiang province ', 'chunanxian');
INSERT INTO `pd_ugc` VALUES ('232', ' jiande ', ' Jiande city, hangzhou city, zhejiang province ', 'jiandeshi');
INSERT INTO `pd_ugc` VALUES ('233', ' fuyang ', ' Fuyang city, hangzhou city, zhejiang province ', 'fuyangshi');
INSERT INTO `pd_ugc` VALUES ('234', ' Linan city ', ' Lin 'an city, hangzhou city, zhejiang province ', 'linanshi');
INSERT INTO `pd_ugc` VALUES ('313', ' Should be hills ', 'gsysz', 'yingshanzhen');
INSERT INTO `pd_ugc` VALUES ('500', ' xining ', ' Xining, qinghai province ', 'xiningshi');
INSERT INTO `pd_ugc` VALUES ('501', ' East area ', ' Xining city, qinghai province, chengdong district ', 'chengdongqu');
INSERT INTO `pd_ugc` VALUES ('502', ' The central city ', ' Central district, xining city, qinghai province ', 'chengzhongqu');
INSERT INTO `pd_ugc` VALUES ('503', ' The west end ', ' Qinghai province xining city west district ', 'chengxiqu');
INSERT INTO `pd_ugc` VALUES ('504', ' Chengbei district ', ' Qinghai xining chengbei district ', 'chengbeiqu');
INSERT INTO `pd_ugc` VALUES ('505', ' Datong hui tu autonomous county ', ' Datong hui tu autonomous county, xining city, qinghai province ', 'datonghuizutuzuzizhixian');
INSERT INTO `pd_ugc` VALUES ('506', ' this ', ' Huangzhong county, xining city, qinghai province ', 'huangzhongxian');
INSERT INTO `pd_ugc` VALUES ('507', ' Huangyuan county ', ' Huangyuan county, xining city, qinghai province ', 'huangyuanxian');
INSERT INTO `pd_ugc` VALUES ('508', ' Whereas haidong539 area ', ' Qinghai haidong region city ', 'haidongdiqu');
INSERT INTO `pd_ugc` VALUES ('509', ' ping ', ' Qinghai haidong region city of pingan county ', 'pinganxian');
INSERT INTO `pd_ugc` VALUES ('510', ' Minhe hui tu autonomous county ', ' Residents of haidong region of qinghai province and hui tu autonomous county ', 'minhehuizutuzuzizhixian');
INSERT INTO `pd_ugc` VALUES ('511', ' Village in ', ' Ledu county, haidong prefecture, qinghai province ', 'ledouxian');
INSERT INTO `pd_ugc` VALUES ('512', ' Huhu tu autonomous county ', ' Qinghai haidong region city mutual assistance tu autonomous county ', 'huzhutuzuzizhixian');
INSERT INTO `pd_ugc` VALUES ('513', ' Hualong hui autonomous county ', ' Hualong hui autonomous county, haidong region, qinghai province ', 'hualonghuizuzizhixian');
INSERT INTO `pd_ugc` VALUES ('514', ' Xunhua sala autonomous county ', ' Xunhua sala autonomous county, haidong region, qinghai province ', 'xunhuasalazuzizhixian');
INSERT INTO `pd_ugc` VALUES ('515', ' Guoluo Tibetan autonomous prefecture ', ' Guoluo Tibetan autonomous prefecture, qinghai province ', 'guoluozangzuzizhizhou');
INSERT INTO `pd_ugc` VALUES ('516', ' Ma qin county ', ' Maqin county, guoluo Tibetan autonomous prefecture, qinghai province ', 'maqinxian');
INSERT INTO `pd_ugc` VALUES ('517', ' Class m county ', ' Banma county, guoluo Tibetan autonomous prefecture, qinghai province ', 'banmaxian');
INSERT INTO `pd_ugc` VALUES ('518', ' Gander county ', ' Gande county, guoluo Tibetan autonomous prefecture, qinghai province ', 'gandexian');
INSERT INTO `pd_ugc` VALUES ('519', ' Up to day county ', ' Dari county, guoluo Tibetan autonomous prefecture, qinghai province ', 'darixian');
INSERT INTO `pd_ugc` VALUES ('520', ' JiuZhi county ', ' Jiuzhi county, guoluo Tibetan autonomous prefecture, qinghai province ', 'jiuzhixian');
INSERT INTO `pd_ugc` VALUES ('521', ' madoi ', ' Mado county, guoluo Tibetan autonomous prefecture, qinghai province ', 'maduoxian');
INSERT INTO `pd_ugc` VALUES ('522', ' Yushu Tibetan autonomous prefecture ', ' Qinghai yushu Tibetan autonomous prefecture ', 'yushuzangzuzizhizhou');
INSERT INTO `pd_ugc` VALUES ('523', ' Yushu county ', ' Yushu county, yushu Tibetan autonomous prefecture, qinghai province ', 'yushuxian');
INSERT INTO `pd_ugc` VALUES ('524', ' Heteropoly county ', ' Zadoan county, yushu Tibetan autonomous prefecture, qinghai province ', 'zaduoxian');
INSERT INTO `pd_ugc` VALUES ('525', ' According to many county ', ' Qinghai yushu Tibetan autonomous prefecture said many counties ', 'chengduoxian');
INSERT INTO `pd_ugc` VALUES ('526', ' For many counties ', ' Zhiduo county, yushu Tibetan autonomous prefecture, qinghai province ', 'zhiduoxian');
INSERT INTO `pd_ugc` VALUES ('527', ' Capsule modest county ', ' Nangqian county, yushu Tibetan autonomous prefecture, qinghai province ', 'nangqianxian');
INSERT INTO `pd_ugc` VALUES ('528', ' Song ma lai county ', ' Qumalai county, yushu Tibetan autonomous prefecture, qinghai province ', 'qumalaixian');
INSERT INTO `pd_ugc` VALUES ('529', ' Haixi Mongolian and Tibetan autonomous prefecture ', ' Qinghai haixi Mongol Tibetan autonomous prefecture ', 'haiximengguzuzangzuzizhizhou');
INSERT INTO `pd_ugc` VALUES ('530', ' geermu ', ' Golmud city, haixi Mongol and Tibetan autonomous prefecture, qinghai province ', 'geermushi');
INSERT INTO `pd_ugc` VALUES ('531', ' DE delingha ', ' Delingha city, haixi Mongol and Tibetan autonomous prefecture, qinghai province ', 'delinghashi');
INSERT INTO `pd_ugc` VALUES ('532', ' His county ', ' Wulan county, haixi Mongol and Tibetan autonomous prefecture, qinghai province ', 'wulanxian');
INSERT INTO `pd_ugc` VALUES ('533', ' Touraine county ', ' Dulan county, haixi Mongolian and Tibetan autonomous prefecture, qinghai province ', 'doulanxian');
INSERT INTO `pd_ugc` VALUES ('534', ' Tianjun county ', ' Tianjun county, haixi Mongolian and Tibetan autonomous prefecture, qinghai province ', 'tianjunxian');
INSERT INTO `pd_ugc` VALUES ('535', ' Haibei Tibetan autonomous prefecture ', ' Haibei Tibetan autonomous prefecture, qinghai province ', 'haibeizangzuzizhizhou');
INSERT INTO `pd_ugc` VALUES ('536', ' Menyuan hui autonomous county ', ' Menyuan hui autonomous county, haibei Tibetan autonomous prefecture, qinghai province ', 'menyuanhuizuzizhixian');
INSERT INTO `pd_ugc` VALUES ('537', ' qilian ', ' Qinghai haibei Tibetan autonomous prefecture qilian county ', 'qilianxian');
INSERT INTO `pd_ugc` VALUES ('538', ' Taking the sea county ', ' Haiyan county, haibei Tibetan autonomous prefecture, qinghai province ', 'haiyanxian');
INSERT INTO `pd_ugc` VALUES ('539', ' Just was made in the county ', ' Gangcha county, haibei Tibetan autonomous prefecture, qinghai province ', 'gangchaxian');
INSERT INTO `pd_ugc` VALUES ('540', ' Huangnan Tibetan autonomous prefecture ', ' Huangnan Tibetan autonomous prefecture, qinghai province ', 'huangnanzangzuzizhizhou');
INSERT INTO `pd_ugc` VALUES ('541', ' Tongren county ', ' Tongren county, huangnan Tibetan autonomous prefecture, qinghai province ', 'tongrenxian');
INSERT INTO `pd_ugc` VALUES ('542', ' Sharp plunge into county ', ' Jianza county, huangnan Tibetan autonomous prefecture, qinghai province ', 'jianzhaxian');
INSERT INTO `pd_ugc` VALUES ('543', ' Ze library county ', ' Zeku county, huangnan Tibetan autonomous prefecture, qinghai province ', 'zekuxian');
INSERT INTO `pd_ugc` VALUES ('544', ' Henan Mongolian autonomous county ', ' Qinghai huangnan Tibetan autonomous prefecture henan Mongolian autonomous county ', 'henanmengguzuzizhixian');
INSERT INTO `pd_ugc` VALUES ('545', ' Hainan Tibetan autonomous prefecture ', ' Hainan Tibetan autonomous prefecture, qinghai province ', 'hainanzangzuzizhizhou');
INSERT INTO `pd_ugc` VALUES ('546', ' prepares ', ' Qinghai province hainan Tibetan autonomous prefecture republican county ', 'gonghexian');
INSERT INTO `pd_ugc` VALUES ('547', ' Tongde county ', ' Tongde county, hainan Tibetan autonomous prefecture, qinghai province ', 'tongdexian');
INSERT INTO `pd_ugc` VALUES ('548', ' Your DE county, ', ' Guide county, hainan Tibetan autonomous prefecture, qinghai province ', 'guidexian');
INSERT INTO `pd_ugc` VALUES ('549', ' Xinghai county ', ' Xinghai county, hainan Tibetan autonomous prefecture, qinghai province ', 'xinghaixian');
INSERT INTO `pd_ugc` VALUES ('550', ' shagou ', ' Guinan county, hainan Tibetan autonomous prefecture, qinghai province ', 'guinanxian');
INSERT INTO `pd_ugc` VALUES ('551', ' Guiyang city ', ' Guiyang, guizhou province ', 'guiyangshi');
INSERT INTO `pd_ugc` VALUES ('552', ' nanming ', ' Nanming district, guiyang city, guizhou province ', 'nanmingqu');
INSERT INTO `pd_ugc` VALUES ('553', ' Yunyan district ', ' Yunyan district, guiyang city, guizhou province ', 'yunyanqu');
INSERT INTO `pd_ugc` VALUES ('554', ' Huaxi district ', ' Huaxi district, guiyang city, guizhou province ', 'huaxiqu');
INSERT INTO `pd_ugc` VALUES ('555', ' Wudang district ', ' Wudang district, guiyang city, guizhou province ', 'wudangqu');
INSERT INTO `pd_ugc` VALUES ('556', ' Baiyun district ', ' Baiyun district, guiyang city, guizhou province ', 'baiyunqu');
INSERT INTO `pd_ugc` VALUES ('557', ' kaiyang ', ' Kaiyang county, guiyang city, guizhou province ', 'kaiyangxian');
INSERT INTO `pd_ugc` VALUES ('558', ' Map of xifeng county, ', ' Xifeng county, guiyang city, guizhou province ', 'xifengxian');
INSERT INTO `pd_ugc` VALUES ('559', ' By the county ', ' Xiuwen county, guiyang city, guizhou province ', 'xiuwenxian');
INSERT INTO `pd_ugc` VALUES ('560', ' qingzhen ', ' Qingzhen city, guiyang city, guizhou province ', 'qingzhenshi');
INSERT INTO `pd_ugc` VALUES ('561', ' The river area ', ' Xiaohe district, guiyang city, guizhou province ', 'xiaohequ');
INSERT INTO `pd_ugc` VALUES ('562', ' zhunyi ', ' Zunyi city, guizhou province ', 'zunyishi');
INSERT INTO `pd_ugc` VALUES ('563', ' Red flower district ', ' Honghuagang district, zunyi city, guizhou province ', 'honghuagangqu');
INSERT INTO `pd_ugc` VALUES ('564', ' Inovance area ', ' Huichuan district, zunyi city, guizhou province ', 'huichuanqu');
INSERT INTO `pd_ugc` VALUES ('565', ' Zunyi county ', ' Zunyi county, zunyi city, guizhou province ', 'zunyixian');
INSERT INTO `pd_ugc` VALUES ('566', ' TongZi county ', ' Tongzi county, zunyi city, guizhou province ', 'tongzixian');
INSERT INTO `pd_ugc` VALUES ('567', ' suiyang ', ' Suiyang county, zunyi city, guizhou province ', 'suiyangxian');
INSERT INTO `pd_ugc` VALUES ('568', ' Is anxian county, ', ' Zheng 'an county, zunyi city, guizhou province ', 'zhenganxian');
INSERT INTO `pd_ugc` VALUES ('569', ' Daozhengelao miao autonomous county ', ' Guizhou province zunyi daozhenlao miao autonomous county ', 'daozhengelaozumiaozuzizhixian');
INSERT INTO `pd_ugc` VALUES ('570', ' Wuchuan gelao miao autonomous county ', ' Wuchuan gelao miao autonomous county, zunyi city, guizhou province ', 'wuchuangelaozumiaozuzizhixian');
INSERT INTO `pd_ugc` VALUES ('571', ' Compared the county ', ' Fenggang county, zunyi city, guizhou province ', 'fenggangxian');
INSERT INTO `pd_ugc` VALUES ('572', ' Mae tam county ', ' Meitan county, zunyi city, guizhou province ', 'meitanxian');
INSERT INTO `pd_ugc` VALUES ('573', ' Yuqing county ', ' Yuqing county, zunyi city, guizhou province ', 'yuqingxian');
INSERT INTO `pd_ugc` VALUES ('574', ' XiShui County ', ' Xishui county, zunyi city, guizhou province ', 'xishuixian');
INSERT INTO `pd_ugc` VALUES ('575', ' Chishui city ', ' Chishui city, zunyi city, guizhou province ', 'chishuishi');
INSERT INTO `pd_ugc` VALUES ('576', ' renhuai ', ' Renhuai, zunyi city, guizhou province ', 'renhuaishi');
INSERT INTO `pd_ugc` VALUES ('577', ' Anshun city ', ' Anshun city, guizhou province ', 'anshunshi');
INSERT INTO `pd_ugc` VALUES ('578', ' West show area ', ' Xixiu district, anshun city, guizhou province ', 'xixiuqu');
INSERT INTO `pd_ugc` VALUES ('579', ' PingBa county ', ' Pingba county, anshun city, guizhou province ', 'pingbaxian');
INSERT INTO `pd_ugc` VALUES ('580', ' Puding county ', ' Puding county, anshun city, guizhou province ', 'pudingxian');
INSERT INTO `pd_ugc` VALUES ('581', ' Zhenning buyi miao autonomous county ', ' Guizhou province anshun zhenning buyi miao autonomous county ', 'zhenningbuyizumiaozuzizhixian');
INSERT INTO `pd_ugc` VALUES ('582', ' Guanling buyi and miao autonomous county ', ' Guanling buyi and miao autonomous county, anshun city, guizhou province ', 'guanlingbuyizumiaozuzizhixian');
INSERT INTO `pd_ugc` VALUES ('583', ' Ziyun miao buyi autonomous county ', ' Ziyun miao buyi autonomous county, anshun city, guizhou province ', 'ziyunmiaozubuyizuzizhixian');
INSERT INTO `pd_ugc` VALUES ('584', ' Qiannan buyi and miao autonomous prefecture ', ' Qiannan buyi and miao autonomous prefecture, guizhou province ', 'qiannanbuyizumiaozuzizhizhou');
INSERT INTO `pd_ugc` VALUES ('585', ' DouYun city ', ' Duyun city, qiannan buyi and miao autonomous prefecture, guizhou province ', 'douyunshi');
INSERT INTO `pd_ugc` VALUES ('586', ' Fuquan city ', ' Fuquan city, qiannan buyi and miao autonomous prefecture, guizhou province ', 'fuquanshi');
INSERT INTO `pd_ugc` VALUES ('587', ' libo ', ' Libo county, qiannan buyi and miao autonomous prefecture, guizhou province ', 'liboxian');
INSERT INTO `pd_ugc` VALUES ('588', ' Guiding county ', ' Guiding county, qiannan buyi and miao autonomous prefecture, guizhou province ', 'guidingxian');
INSERT INTO `pd_ugc` VALUES ('589', ' Weng 'an ', ' Weng 'an county, qiannan buyi and miao autonomous prefecture, guizhou province ', 'wenganxian');
INSERT INTO `pd_ugc` VALUES ('590', ' dushan ', ' Dushan county, qiannan buyi and miao autonomous prefecture, guizhou province ', 'dushanxian');
INSERT INTO `pd_ugc` VALUES ('591', ' PingTang county ', ' Pingtang county, qiannan buyi and miao autonomous prefecture, guizhou province ', 'pingtangxian');
INSERT INTO `pd_ugc` VALUES ('592', ' luodian ', ' Luodian county, qiannan buyi and miao autonomous prefecture, guizhou province ', 'luodianxian');
INSERT INTO `pd_ugc` VALUES ('593', ' changshun ', ' Changshun county, qiannan buyi and miao autonomous prefecture, guizhou province ', 'zhangshunxian');
INSERT INTO `pd_ugc` VALUES ('594', ' longli ', ' Longli county, qiannan buyi and miao autonomous prefecture, guizhou province ', 'longlixian');
INSERT INTO `pd_ugc` VALUES ('595', ' huishui ', ' Huishui county, qiannan buyi and miao autonomous prefecture, guizhou province ', 'huishuixian');
INSERT INTO `pd_ugc` VALUES ('596', '3 All aquarium autonomous county ', ' Qiannan buyi and miao autonomous prefecture, guizhou province 3 All aquarium autonomous county ', 'sandoushuizuzizhixian');
INSERT INTO `pd_ugc` VALUES ('597', ' Qiandongnan miao and dong autonomous prefecture ', ' Qiandongnan miao and dong autonomous prefecture, guizhou province ', 'qiandongnanmiaozudongzuzizhizh');
INSERT INTO `pd_ugc` VALUES ('598', ' kaili ', ' Kaili city, qiandongnan miao and dong autonomous prefecture, guizhou province ', 'kailishi');
INSERT INTO `pd_ugc` VALUES ('599', ' Huangping county ', ' Huangping county, qiandongnan miao and dong autonomous prefecture, guizhou province ', 'huangpingxian');
INSERT INTO `pd_ugc` VALUES ('600', ' Shi bing county ', ' Shibing county, qiandongnan miao and dong autonomous prefecture, guizhou province ', 'shibingxian');
INSERT INTO `pd_ugc` VALUES ('601', '3 Guangzhou county ', ' Qiandongnan miao and dong autonomous prefecture, guizhou province 3 Guangzhou county ', 'sansuixian');
INSERT INTO `pd_ugc` VALUES ('602', ' Zhenyuan county ', ' Yuan county, qiandongnan miao and dong autonomous prefecture, guizhou province ', 'zhenyuanxian');
INSERT INTO `pd_ugc` VALUES ('603', ' 岑巩 county ', ' Cenggong county, qiandongnan miao and dong autonomous prefecture, guizhou province ', 'cengongxian');
INSERT INTO `pd_ugc` VALUES ('604', ' talking ', ' Tianzhu county, qiandongnan miao and dong autonomous prefecture, guizhou province ', 'tianzhuxian');
INSERT INTO `pd_ugc` VALUES ('605', ' Kam screen county ', ' Jinping county, qiandongnan miao and dong autonomous prefecture, guizhou province ', 'jinpingxian');
INSERT INTO `pd_ugc` VALUES ('606', ' Jian river county, ', ' Jianhe county, qiandongnan miao and dong autonomous prefecture, guizhou province ', 'jianhexian');
INSERT INTO `pd_ugc` VALUES ('607', ' Says ha tae-keung county ', ' Taijiang county, qiandongnan miao and dong autonomous prefecture, guizhou province ', 'taijiangxian');
INSERT INTO `pd_ugc` VALUES ('608', ' province ', ' Liping county, qiandongnan miao and dong autonomous prefecture, guizhou province ', 'lipingxian');
INSERT INTO `pd_ugc` VALUES ('609', ' Rongjiang county ', ' Rongjiang county, qiandongnan miao and dong autonomous prefecture, guizhou province ', 'rongjiangxian');
INSERT INTO `pd_ugc` VALUES ('610', ' Congjiang county ', ' Congjiang county, qiandongnan miao and dong autonomous prefecture, guizhou province ', 'congjiangxian');
INSERT INTO `pd_ugc` VALUES ('611', ' In leishan county ', ' Leishan county, qiandongnan miao and dong autonomous prefecture, guizhou province ', 'leishanxian');
INSERT INTO `pd_ugc` VALUES ('612', ' Majiang county ', ' Majang county, qiandongnan miao and dong autonomous prefecture, guizhou province ', 'majiangxian');
INSERT INTO `pd_ugc` VALUES ('613', ' danzhai ', ' Danzhai county, qiandongnan miao and dong autonomous prefecture, guizhou province ', 'danzhaixian');
INSERT INTO `pd_ugc` VALUES ('614', ' Tongren region ', ' Tongren, guizhou province ', 'tongrendiqu');
INSERT INTO `pd_ugc` VALUES ('615', ' including ', ' Tongren city, tongren prefecture, guizhou province ', 'tongrenshi');
INSERT INTO `pd_ugc` VALUES ('616', ' jiangkou ', ' Jiangkou county, tongren prefecture, guizhou province ', 'jiangkouxian');
INSERT INTO `pd_ugc` VALUES ('617', ' Yuping dong autonomous county ', ' Yuping dong autonomous county, tongren prefecture, guizhou province ', 'yupingdongzuzizhixian');
INSERT INTO `pd_ugc` VALUES ('618', ' Shi Qian county ', ' Shiqian county, tongren prefecture, guizhou province ', 'shiqianxian');
INSERT INTO `pd_ugc` VALUES ('619', ' SiNa County ', ' Sinan county, tongren prefecture, guizhou province ', 'sinanxian');
INSERT INTO `pd_ugc` VALUES ('620', ' Yinjiang tujia and miao autonomous county ', ' Yinjiang tujia and miao autonomous county, tongren prefecture, guizhou province ', 'yinjiangtujiazumiaozuzizhixian');
INSERT INTO `pd_ugc` VALUES ('621', ' DE jiang county, ', ' Dejiang county, tongren prefecture, guizhou province ', 'dejiangxian');
INSERT INTO `pd_ugc` VALUES ('622', ' Yanhe tujia autonomous county ', ' Yanhe tujia autonomous county, tongren prefecture, guizhou province ', 'yanhetujiazuzizhixian');
INSERT INTO `pd_ugc` VALUES ('623', ' Songtao miao autonomous county ', ' Songtao miao autonomous county, tongren prefecture, guizhou province ', 'songtaomiaozuzizhixian');
INSERT INTO `pd_ugc` VALUES ('624', ' Wanshan SAR ', ' Wanshan special zone, tongren district, guizhou province ', 'wanshantequ');
INSERT INTO `pd_ugc` VALUES ('625', ' bijie ', ' Bijie, guizhou province ', 'bijiediqu');
INSERT INTO `pd_ugc` VALUES ('626', ' Bijie city ', ' Bijie city, bijie prefecture, guizhou province ', 'bijieshi');
INSERT INTO `pd_ugc` VALUES ('627', ' dafang ', ' Dafang county, bijie district, guizhou province ', 'dafangxian');
INSERT INTO `pd_ugc` VALUES ('628', ' qianxi ', ' Qianxi county, bijie district, guizhou province ', 'qianxixian');
INSERT INTO `pd_ugc` VALUES ('629', ' jinsha ', ' Jinsha county, bijie district, guizhou province ', 'jinshaxian');
INSERT INTO `pd_ugc` VALUES ('630', ' Zhijin county ', ' Zhijin county, bijie district, guizhou province ', 'zhijinxian');
INSERT INTO `pd_ugc` VALUES ('631', ' Na harmony county ', ' Nayong county, bijie district, guizhou province ', 'nayongxian');
INSERT INTO `pd_ugc` VALUES ('632', ' Weining yi hui miao autonomous county ', ' Weining yi hui miao autonomous county, bijie prefecture, guizhou province ', 'weiningyizuhuizumiaozuzizhixia');
INSERT INTO `pd_ugc` VALUES ('633', ' hezhang ', ' Hezhang county, bijie district, guizhou province ', 'hezhangxian');
INSERT INTO `pd_ugc` VALUES ('634', '6 Plate of water, ', ' The guizhou province 6 Plate of water, ', 'liupanshuishi');
INSERT INTO `pd_ugc` VALUES ('635', ' Zhong shan area ', ' The guizhou province 6 Zhongshan district, panshui city ', 'zhongshanqu');
INSERT INTO `pd_ugc` VALUES ('636', '6 Branches, d.c., ', ' The guizhou province 6 Plate of water, 6 Branches, d.c., ', 'liuzhitequ');
INSERT INTO `pd_ugc` VALUES ('637', ' shuicheng ', ' The guizhou province 6 Panshui city shuicheng county ', 'shuichengxian');
INSERT INTO `pd_ugc` VALUES ('638', ' Pan county ', ' The guizhou province 6 Pan shui city pan county ', 'panxian');
INSERT INTO `pd_ugc` VALUES ('639', ' Buyi and miao autonomous prefecture, southwest guizhou province ', ' Buyi and miao autonomous prefecture, southwest guizhou province ', 'qianxinanbuyizumiaozuzizhizhou');
INSERT INTO `pd_ugc` VALUES ('640', ' Wangmo county ', ' Wangmo county, buyi and miao autonomous prefecture, southwest guizhou province ', 'wangmoxian');
INSERT INTO `pd_ugc` VALUES ('641', ' ceheng ', ' Qiheng county, buyi and miao autonomous prefecture, southwest guizhou province ', 'cehengxian');
INSERT INTO `pd_ugc` VALUES ('642', ' Enron county ', ' Anlong county, buyi and miao autonomous prefecture, southwest guizhou province ', 'anlongxian');
INSERT INTO `pd_ugc` VALUES ('643', ' xingyi ', ' Xingyi city, buyi and miao autonomous prefecture, southwest guizhou province ', 'xingyishi');
INSERT INTO `pd_ugc` VALUES ('644', ' xingren ', ' Xingren county, buyi and miao autonomous prefecture, southwest guizhou province ', 'xingrenxian');
INSERT INTO `pd_ugc` VALUES ('645', ' Pu 'an ', ' Puan county, buyi and miao autonomous prefecture, southwest guizhou province ', 'puanxian');
INSERT INTO `pd_ugc` VALUES ('646', ' digging ', ' Qinglong county, buyi and miao autonomous prefecture, southwest guizhou province ', 'qinglongxian');
INSERT INTO `pd_ugc` VALUES ('647', ' zhenfeng ', ' Zhenfeng county, buyi and miao autonomous prefecture, southwest guizhou province ', 'zhenfengxian');
INSERT INTO `pd_ugc` VALUES ('648', ' Yueyang city ', ' Yueyang city, hunan province ', 'yueyangshi');
INSERT INTO `pd_ugc` VALUES ('649', ' Yueyang LouQu ', ' Yueyang Lou district, yueyang city, hunan province ', 'yueyanglouqu');
INSERT INTO `pd_ugc` VALUES ('650', ' Cloud creek area ', ' Yunxi district, yueyang city, hunan province ', 'yunxiqu');
INSERT INTO `pd_ugc` VALUES ('651', ' Junshan island area ', ' Junshan district, yueyang city, hunan province ', 'junshanqu');
INSERT INTO `pd_ugc` VALUES ('652', ' Yueyang county ', ' Yueyang county, yueyang city, hunan province ', 'yueyangxian');
INSERT INTO `pd_ugc` VALUES ('653', ' Huarong county ', ' Huarong county, yueyang city, hunan province ', 'huarongxian');
INSERT INTO `pd_ugc` VALUES ('654', ' xiangyin ', ' Xiangyin county, yueyang city, hunan province ', 'xiangyinxian');
INSERT INTO `pd_ugc` VALUES ('655', ' The pingjiang xian ', ' Pingjiang county, yueyang city, hunan province ', 'pingjiangxian');
INSERT INTO `pd_ugc` VALUES ('656', ' Miluo city ', ' Miluo city, yueyang city, hunan province ', 'miluoshi');
INSERT INTO `pd_ugc` VALUES ('657', ' Linxiang city ', ' Linxiang city, yueyang city, hunan province ', 'linxiangshi');
INSERT INTO `pd_ugc` VALUES ('658', ' Changsha city ', ' Changsha, hunan province ', 'zhangshashi');
INSERT INTO `pd_ugc` VALUES ('659', ' Furong district ', ' Furong district, changsha city, hunan province ', 'furongqu');
INSERT INTO `pd_ugc` VALUES ('660', ' By tianxin ', ' Tianxin district, changsha city, hunan province ', 'tianxinqu');
INSERT INTO `pd_ugc` VALUES ('661', ' Yuelu district ', ' Yuelu district, changsha city, hunan province ', 'yueluqu');
INSERT INTO `pd_ugc` VALUES ('662', ' Kaifu district ', ' Kaifu district, changsha city, hunan province ', 'kaifuqu');
INSERT INTO `pd_ugc` VALUES ('663', ' Yuhua district ', ' Yuhua district, changsha city, hunan province ', 'yuhuaqu');
INSERT INTO `pd_ugc` VALUES ('664', ' xingsha ', ' Changsha county, changsha city, hunan province ', 'zhangshaxian');
INSERT INTO `pd_ugc` VALUES ('665', ' wangcheng ', ' Wangcheng county, changsha city, hunan province ', 'wangchengxian');
INSERT INTO `pd_ugc` VALUES ('666', ' Ningxiang county ', ' Ningxiang county, changsha city, hunan province ', 'ningxiangxian');
INSERT INTO `pd_ugc` VALUES ('667', ' liuyang ', ' Liuyang city, changsha city, hunan province ', 'liuyangshi');
INSERT INTO `pd_ugc` VALUES ('668', ' Xiangtan city ', ' Xiangtan city, hunan province ', 'xiangtanshi');
INSERT INTO `pd_ugc` VALUES ('669', ' yuhu ', ' Yuhu district, xiangtan city, hunan province ', 'yuhuqu');
INSERT INTO `pd_ugc` VALUES ('670', ' Yue pond area ', ' Yuetang district, xiangtan city, hunan province ', 'yuetangqu');
INSERT INTO `pd_ugc` VALUES ('671', ' Xiangtan county ', ' Xiangtan county, xiangtan city, hunan province ', 'xiangtanxian');
INSERT INTO `pd_ugc` VALUES ('672', ' The xiangxiang ', ' Xiangxiang city, xiangtan city, hunan province ', 'xiangxiangshi');
INSERT INTO `pd_ugc` VALUES ('673', ' Shaoshan city ', ' Shaoshan city, xiangtan city, hunan province ', 'shaoshanshi');
INSERT INTO `pd_ugc` VALUES ('674', ' Zhuzhou city ', ' Zhuzhou city, hunan province ', 'zhuzhoushi');
INSERT INTO `pd_ugc` VALUES ('675', ' Lotus pond area ', ' Hetang district, zhuzhou city, hunan province ', 'hetangqu');
INSERT INTO `pd_ugc` VALUES ('676', ' LuSong area ', ' Lusong district, zhuzhou city, hunan province ', 'lusongqu');
INSERT INTO `pd_ugc` VALUES ('677', ' Stone mountain area ', ' Shifeng district, zhuzhou city, hunan province ', 'shifengqu');
INSERT INTO `pd_ugc` VALUES ('678', ' Tianyuan district, ', ' Tianyuan district, zhuzhou city, hunan province ', 'tianyuanqu');
INSERT INTO `pd_ugc` VALUES ('679', ' Zhuzhou county ', ' Zhuzhou county, zhuzhou city, hunan province ', 'zhuzhouxian');
INSERT INTO `pd_ugc` VALUES ('680', ' remote ', ' Youxian county, zhuzhou city, hunan province ', 'youxian');
INSERT INTO `pd_ugc` VALUES ('681', ' chaling ', ' Chaling county, zhuzhou city, hunan province ', 'chalingxian');
INSERT INTO `pd_ugc` VALUES ('682', ' tianxinli ', ' Yanling county, zhuzhou city, hunan province ', 'yanlingxian');
INSERT INTO `pd_ugc` VALUES ('683', ' liling ', ' Liling city, zhuzhou city, hunan province ', 'lilingshi');
INSERT INTO `pd_ugc` VALUES ('684', ' Hengyang city ', ' Hengyang city, hunan province ', 'hengyangshi');
INSERT INTO `pd_ugc` VALUES ('685', ' Bead CDH area ', ' Zhuhui district, hengyang city, hunan province ', 'zhuhuiqu');
INSERT INTO `pd_ugc` VALUES ('686', ' Wild goose peak area ', ' Yanfeng district, hengyang city, hunan province ', 'yanfengqu');
INSERT INTO `pd_ugc` VALUES ('687', ' Shek kwu district ', ' Shigu district, hengyang city, hunan province ', 'shiguqu');
INSERT INTO `pd_ugc` VALUES ('688', ' Steamed hunan area ', ' Zhengxiang district, hengyang city, hunan province ', 'zhengxiangqu');
INSERT INTO `pd_ugc` VALUES ('689', ' Nanyue district ', ' Nanyue district, hengyang city, hunan province ', 'nanyuequ');
INSERT INTO `pd_ugc` VALUES ('690', ' Hengyang county ', ' Hengyang county, hengyang city, hunan province ', 'hengyangxian');
INSERT INTO `pd_ugc` VALUES ('691', ' hengnan ', ' Hengnan county, hengyang city, hunan province ', 'hengnanxian');
INSERT INTO `pd_ugc` VALUES ('692', ' hengshan ', ' Hengshan county, hengyang city, hunan province ', 'hengshanxian');
INSERT INTO `pd_ugc` VALUES ('693', ' Hengdong county ', ' Hengdong county, hengyang city, hunan province ', 'hengdongxian');
INSERT INTO `pd_ugc` VALUES ('694', ' Qidong well county ', ' Qidong county, hengyang city, hunan province ', 'qidongxian');
INSERT INTO `pd_ugc` VALUES ('695', ' leiyang ', ' Leiyang, hengyang city, hunan province ', 'leiyangshi');
INSERT INTO `pd_ugc` VALUES ('696', ' Changning county ', ' Changning city, hengyang city, hunan province ', 'changningshi');
INSERT INTO `pd_ugc` VALUES ('697', ' Chenzhou city ', ' Chenzhou city, hunan province ', 'chenzhoushi');
INSERT INTO `pd_ugc` VALUES ('698', ' beihu ', ' Beihu district, chenzhou city, hunan province ', 'beihuqu');
INSERT INTO `pd_ugc` VALUES ('699', ' Suxian district ', ' Suxian district, chenzhou city, hunan province ', 'suxianqu');
INSERT INTO `pd_ugc` VALUES ('700', ' Guiyang county ', ' Guiyang county, chenzhou city, hunan province ', 'guiyangxian');
INSERT INTO `pd_ugc` VALUES ('701', ' yizhang ', ' Yizhang county, chenzhou city, hunan province ', 'yizhangxian');
INSERT INTO `pd_ugc` VALUES ('702', ' Yongxing county ', ' Yongxing county, chenzhou city, hunan province ', 'yongxingxian');
INSERT INTO `pd_ugc` VALUES ('703', ' jiahe ', ' Chenzhou jiahe county, hunan province ', 'jiahexian');
INSERT INTO `pd_ugc` VALUES ('704', ' Linwu county ', ' Linwu county, chenzhou city, hunan province ', 'linwuxian');
INSERT INTO `pd_ugc` VALUES ('705', ' Your city, county, ', ' Rucheng county, chenzhou city, hunan province ', 'ruchengxian');
INSERT INTO `pd_ugc` VALUES ('706', ' Our county ', ' Guidong county, chenzhou city, hunan province ', 'guidongxian');
INSERT INTO `pd_ugc` VALUES ('707', ' AnRen county ', ' Anren county, chenzhou city, hunan province ', 'anrenxian');
INSERT INTO `pd_ugc` VALUES ('708', ' The municipality ( ', ' Zixing city, chenzhou city, hunan province ', 'zixingshi');
INSERT INTO `pd_ugc` VALUES ('709', ' Chang DE city ', ' Changde city, hunan province ', 'changdeshi');
INSERT INTO `pd_ugc` VALUES ('710', ' Wuling district ', ' Wuling district, changde city, hunan province ', 'wulingqu');
INSERT INTO `pd_ugc` VALUES ('711', ' Dingcheng district ', ' Dingcheng district, changde city, hunan province ', 'dingchengqu');
INSERT INTO `pd_ugc` VALUES ('712', ' anxiang ', ' Anxiang county, changde city, hunan province ', 'anxiangxian');
INSERT INTO `pd_ugc` VALUES ('713', ' hanshou ', ' Hanshou county, changde city, hunan province ', 'hanshouxian');
INSERT INTO `pd_ugc` VALUES ('714', ' Li County ', ' Lixian county, changde city, hunan province ', 'lixian');
INSERT INTO `pd_ugc` VALUES ('715', ' linli ', ' Linli county, changde city, hunan province ', 'linlixian');
INSERT INTO `pd_ugc` VALUES ('716', ' Taoyuan county ', ' Taoyuan county, changde city, hunan province ', 'taoyuanxian');
INSERT INTO `pd_ugc` VALUES ('717', ' concession ', ' Shimen county, changde city, hunan province ', 'shimenxian');
INSERT INTO `pd_ugc` VALUES ('718', ' Tianjin city ', ' Jinshi city, changde city, hunan province ', 'jinshishi');
INSERT INTO `pd_ugc` VALUES ('719', ' Yiyang city ', ' Yiyang city, hunan province ', 'yiyangshi');
INSERT INTO `pd_ugc` VALUES ('720', ' Ziyang district ', ' Ziyang district, yiyang city, hunan province ', 'ziyangqu');
INSERT INTO `pd_ugc` VALUES ('721', ' Guming area ', ' Heshan district, yiyang city, hunan province ', 'heshanqu');
INSERT INTO `pd_ugc` VALUES ('722', ' no ', ' Nan county, yiyang city, hunan province ', 'nanxian');
INSERT INTO `pd_ugc` VALUES ('723', ' Taojiang county ', ' Taojiang county, yiyang city, hunan province ', 'taojiangxian');
INSERT INTO `pd_ugc` VALUES ('724', ' Anhua.we will act ', ' Anhua county, yiyang city, hunan province ', 'anhuaxian');
INSERT INTO `pd_ugc` VALUES ('725', ' Ruanjiang city ', ' Yuanjiang city, yiyang city, hunan province ', 'yuanjiangshi');
INSERT INTO `pd_ugc` VALUES ('726', ' loudi ', ' Loudi city, hunan province ', 'loudishi');
INSERT INTO `pd_ugc` VALUES ('727', ' LouXing area ', ' Louxing district, loudi city, hunan province ', 'louxingqu');
INSERT INTO `pd_ugc` VALUES ('728', ' Bimodal county ', ' Shuangfeng county, loudi city, hunan province ', 'shuangfengxian');
INSERT INTO `pd_ugc` VALUES ('729', ' xinhua ', ' Xinhua county, loudi city, hunan province ', 'xinhuaxian');
INSERT INTO `pd_ugc` VALUES ('730', ' Lengshuijiang city ', ' Lengshuijiang, loudi city, hunan province ', 'lengshuijiangshi');
INSERT INTO `pd_ugc` VALUES ('731', ' lianyuan ', ' Lianyuan city, loudi city, hunan province ', 'lianyuanshi');
INSERT INTO `pd_ugc` VALUES ('732', ' Shaoyang city ', ' Shaoyang city, hunan province ', 'shaoyangshi');
INSERT INTO `pd_ugc` VALUES ('733', ' Double clear zone ', ' Shuangqing district, shaoyang city, hunan province ', 'shuangqingqu');
INSERT INTO `pd_ugc` VALUES ('734', ' Hand area ', ' Daxiang district, shaoyang city, hunan province ', 'daxiangqu');
INSERT INTO `pd_ugc` VALUES ('735', ' The north tower area ', ' Beita district, shaoyang city, hunan province ', 'beitaqu');
INSERT INTO `pd_ugc` VALUES ('736', ' shaodong ', ' Shaodong county, shaoyang city, hunan province ', 'shaodongxian');
INSERT INTO `pd_ugc` VALUES ('737', ' XinShao county ', ' Xinshao county, shaoyang city, hunan province ', 'xinshaoxian');
INSERT INTO `pd_ugc` VALUES ('738', ' Shaoyang county ', ' Shaoyang county, shaoyang city, hunan province ', 'shaoyangxian');
INSERT INTO `pd_ugc` VALUES ('739', ' Longhui county ', ' Longhui county, shaoyang city, hunan province ', 'longhuixian');
INSERT INTO `pd_ugc` VALUES ('740', ' Dongkou county ', ' Dongkou county, shaoyang city, hunan province ', 'dongkouxian');
INSERT INTO `pd_ugc` VALUES ('741', ' suining ', ' Suining county, shaoyang city, hunan province ', 'suiningxian');
INSERT INTO `pd_ugc` VALUES ('742', ' New county ', ' Xinning county, shaoyang city, hunan province ', 'xinningxian');
INSERT INTO `pd_ugc` VALUES ('743', ' Chengbu miao autonomous county ', ' Chengbu miao autonomous county, shaoyang city, hunan province ', 'chengbumiaozuzizhixian');
INSERT INTO `pd_ugc` VALUES ('744', ' wugang ', ' Wugang city, shaoyang city, hunan province ', 'wugangshi');
INSERT INTO `pd_ugc` VALUES ('745', ' Xiangxi tujia and miao autonomous prefecture ', ' Xiangxi tujia and miao autonomous prefecture, hunan province ', 'xiangxitujiazumiaozuzizhizhou');
INSERT INTO `pd_ugc` VALUES ('746', ' jishou ', ' Jishou city, xiangxi tujia and miao autonomous prefecture, hunan province ', 'jishoushi');
INSERT INTO `pd_ugc` VALUES ('747', ' LuXi county ', ' Luxi county, xiangxi tujia and miao autonomous prefecture, hunan province ', 'luxixian');
INSERT INTO `pd_ugc` VALUES ('748', ' Fenghuang county ', ' Fenghuang county, xiangxi tujia and miao autonomous prefecture, hunan province ', 'fenghuangxian');
INSERT INTO `pd_ugc` VALUES ('749', ' Flowers through county ', ' Huayuan county, xiangxi tujia and miao autonomous prefecture, hunan province ', 'huayuanxian');
INSERT INTO `pd_ugc` VALUES ('750', ' Baojing county ', ' Baojing county, xiangxi tujia and miao autonomous prefecture, hunan province ', 'baojingxian');
INSERT INTO `pd_ugc` VALUES ('751', ' The ancient cultural county ', ' Guzhang county, xiangxi tujia and miao autonomous prefecture, hunan province ', 'guzhangxian');
INSERT INTO `pd_ugc` VALUES ('752', ' yongshun ', ' Yongshun county, xiangxi tujia and miao autonomous prefecture, hunan province ', 'yongshunxian');
INSERT INTO `pd_ugc` VALUES ('753', ' Longshan county ', ' Longshan county, xiangxi tujia and miao autonomous prefecture, hunan province ', 'longshanxian');
INSERT INTO `pd_ugc` VALUES ('754', ' zhangjiajie ', ' Zhangjiajie, hunan province ', 'zhangjiajieshi');
INSERT INTO `pd_ugc` VALUES ('755', ' Yongding district ', ' Yongding district, zhangjiajie city, hunan province ', 'yongdingqu');
INSERT INTO `pd_ugc` VALUES ('756', ' Wulingyuan district ', ' Wulingyuan district, zhangjiajie city, hunan province ', 'wulingyuanqu');
INSERT INTO `pd_ugc` VALUES ('757', ' cili ', ' Cili county, zhangjiajie city, hunan province ', 'cilixian');
INSERT INTO `pd_ugc` VALUES ('758', ' sangzhi ', ' Sangzhi county, zhangjiajie city, hunan province ', 'sangzhixian');
INSERT INTO `pd_ugc` VALUES ('759', ' Huaihua city ', ' Huaihua city, hunan province ', 'huaihuashi');
INSERT INTO `pd_ugc` VALUES ('760', ' Crane city ', ' Hecheng district, huaihua city, hunan province ', 'hechengqu');
INSERT INTO `pd_ugc` VALUES ('761', ' zhongfang ', ' Zhongfang county, huaihua city, hunan province ', 'zhongfangxian');
INSERT INTO `pd_ugc` VALUES ('762', ' yuanling ', ' Yuanling county, huaihua city, hunan province ', 'yuanlingxian');
INSERT INTO `pd_ugc` VALUES ('763', ' Calvin creek county ', ' Chenxi county, huaihua city, hunan province ', 'chenxixian');
INSERT INTO `pd_ugc` VALUES ('764', ' xupu ', ' Xupu county, huaihua city, hunan province ', 'xupuxian');
INSERT INTO `pd_ugc` VALUES ('765', ' province ', ' Huitong county, huaihua city, hunan province ', 'huitongxian');
INSERT INTO `pd_ugc` VALUES ('766', ' Mayang miao autonomous county ', ' Huaihua city, hunan province, mayang miao autonomous county ', 'mayangmiaozuzizhixian');
INSERT INTO `pd_ugc` VALUES ('767', ' Xinhuang dong autonomous county ', ' Xinhuang dong autonomous county, huaihua city, hunan province ', 'xinhuangdongzuzizhixian');
INSERT INTO `pd_ugc` VALUES ('768', ' Zhi river dong autonomous county ', ' Zhijiang dong autonomous county, huaihua city, hunan province ', 'zhijiangdongzuzizhixian');
INSERT INTO `pd_ugc` VALUES ('769', ' Jingzhou miao and dong autonomous county ', ' Jingzhou miao and dong autonomous county, huaihua city, hunan province ', 'jingzhoumiaozudongzuzizhixian');
INSERT INTO `pd_ugc` VALUES ('770', ' Tong dong autonomous county ', ' Dongdong autonomous county, huaihua city, hunan province ', 'tongdaodongzuzizhixian');
INSERT INTO `pd_ugc` VALUES ('771', ' Is necessary, ', ' Hongjiang city, huaihua city, hunan province ', 'hongjiangshi');
INSERT INTO `pd_ugc` VALUES ('772', ' Which was ', ' Yongzhou city, hunan province ', 'yongzhoushi');
INSERT INTO `pd_ugc` VALUES ('773', ' lingling ', ' Lingling district, yongzhou city, hunan province ', 'linglingqu');
INSERT INTO `pd_ugc` VALUES ('774', ' lengshuitan ', ' Lengshuitan district, yongzhou city, hunan province ', 'lengshuitanqu');
INSERT INTO `pd_ugc` VALUES ('775', ' qiyang ', ' Qiyang county, yongzhou city, hunan province ', 'qiyangxian');
INSERT INTO `pd_ugc` VALUES ('776', ' Dongan county ', ' Dongan county, yongzhou city, hunan province ', 'donganxian');
INSERT INTO `pd_ugc` VALUES ('777', ' The double card county ', ' Shuangpai county, yongzhou city, hunan province ', 'shuangpaixian');
INSERT INTO `pd_u