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