text: drop database if exists lovo;
  create database lovo;
  use lovo;
  /*
  Navicat MySQL Data Transfer
  
  Source Server         : localhost_3306
  Source Server Version : 50620
  Source Host           : localhost:3306
  Source Database       : lovo
  
  Target Server Type    : MYSQL
  Target Server Version : 50620
  File Encoding         : 65001
  
  Date: 2015-06-07 14:05:16
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for `city`
  -- ----------------------------
  DROP TABLE IF EXISTS `city`;
  CREATE TABLE `city` (
    `c_id` int(11) NOT NULL AUTO_INCREMENT,
    `c_name` varchar(30) DEFAULT NULL,
    `p_id` int(11) DEFAULT NULL,
    PRIMARY KEY (`c_id`),
    KEY `p_id` (`p_id`),
    CONSTRAINT `city_ibfk_1` FOREIGN KEY (`p_id`) REFERENCES `province` (`p_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=370 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of city
  -- ----------------------------
  INSERT INTO `city` VALUES ('1', '东城区', '1');
  INSERT INTO `city` VALUES ('2', '西城区', '1');
  INSERT INTO `city` VALUES ('3', '崇文区', '1');
  INSERT INTO `city` VALUES ('4', '宣武区', '1');
  INSERT INTO `city` VALUES ('5', '朝阳区', '1');
  INSERT INTO `city` VALUES ('6', '丰台区', '1');
  INSERT INTO `city` VALUES ('7', '石景山区', '1');
  INSERT INTO `city` VALUES ('8', '海淀区', '1');
  INSERT INTO `city` VALUES ('9', '门头沟区', '1');
  INSERT INTO `city` VALUES ('10', '房山区', '1');
  INSERT INTO `city` VALUES ('11', '通州区', '1');
  INSERT INTO `city` VALUES ('12', '顺义区', '1');
  INSERT INTO `city` VALUES ('13', '昌平区', '1');
  INSERT INTO `city` VALUES ('14', '大兴区', '1');
  INSERT INTO `city` VALUES ('15', '怀柔区', '1');
  INSERT INTO `city` VALUES ('16', '平谷区', '1');
  INSERT INTO `city` VALUES ('17', '密云县', '1');
  INSERT INTO `city` VALUES ('18', '延庆县', '1');
  INSERT INTO `city` VALUES ('19', '和平区', '2');
  INSERT INTO `city` VALUES ('20', '河东区', '2');
  INSERT INTO `city` VALUES ('21', '河西区', '2');
  INSERT INTO `city` VALUES ('22', '南开区', '2');
  INSERT INTO `city` VALUES ('23', '河北区', '2');
  INSERT INTO `city` VALUES ('24', '红桥区', '2');
  INSERT INTO `city` VALUES ('25', '塘沽区', '2');
  INSERT INTO `city` VALUES ('26', '汉沽区', '2');
  INSERT INTO `city` VALUES ('27', '大港区', '2');
  INSERT INTO `city` VALUES ('28', '东丽区', '2');
  INSERT INTO `city` VALUES ('29', '西青区', '2');
  INSERT INTO `city` VALUES ('30', '津南区', '2');
  INSERT INTO `city` VALUES ('31', '北辰区', '2');
  INSERT INTO `city` VALUES ('32', '武清区', '2');
  INSERT INTO `city` VALUES ('33', '宝坻区', '2');
  INSERT INTO `city` VALUES ('34', '宁河县', '2');
  INSERT INTO `city` VALUES ('35', '静海县', '2');
  INSERT INTO `city` VALUES ('36', '蓟  县', '2');
  INSERT INTO `city` VALUES ('37', '石家庄市', '3');
  INSERT INTO `city` VALUES ('38', '唐山市', '3');
  INSERT INTO `city` VALUES ('39', '秦皇岛市', '3');
  INSERT INTO `city` VALUES ('40', '邯郸市', '3');
  INSERT INTO `city` VALUES ('41', '邢台市', '3');
  INSERT INTO `city` VALUES ('42', '保定市', '3');
  INSERT INTO `city` VALUES ('43', '张家口市', '3');
  INSERT INTO `city` VALUES ('44', '承德市', '3');
  INSERT INTO `city` VALUES ('45', '沧州市', '3');
  INSERT INTO `city` VALUES ('46', '廊坊市', '3');
  INSERT INTO `city` VALUES ('47', '衡水市', '3');
  INSERT INTO `city` VALUES ('48', '太原市', '4');
  INSERT INTO `city` VALUES ('49', '大同市', '4');
  INSERT INTO `city` VALUES ('50', '阳泉市', '4');
  INSERT INTO `city` VALUES ('51', '长治市', '4');
  INSERT INTO `city` VALUES ('52', '晋城市', '4');
  INSERT INTO `city` VALUES ('53', '朔州市', '4');
  INSERT INTO `city` VALUES ('54', '晋中市', '4');
  INSERT INTO `city` VALUES ('55', '运城市', '4');
  INSERT INTO `city` VALUES ('56', '忻州市', '4');
  INSERT INTO `city` VALUES ('57', '临汾市', '4');
  INSERT INTO `city` VALUES ('58', '吕梁市', '4');
  INSERT INTO `city` VALUES ('59', '呼和浩特市', '5');
  INSERT INTO `city` VALUES ('60', '包头市', '5');
  INSERT INTO `city` VALUES ('61', '乌海市', '5');
  INSERT INTO `city` VALUES ('62', '赤峰市', '5');
  INSERT INTO `city` VALUES ('63', '通辽市', '5');
  INSERT INTO `city` VALUES ('64', '鄂尔多斯市', '5');
  INSERT INTO `city` VALUES ('65', '呼伦贝尔市', '5');
  INSERT INTO `city` VALUES ('66', '巴彦淖尔市', '5');
  INSERT INTO `city` VALUES ('67', '乌兰察布市', '5');
  INSERT INTO `city` VALUES ('68', '沈阳市', '6');
  INSERT INTO `city` VALUES ('69', '大连市', '6');
  INSERT INTO `city` VALUES ('70', '鞍山市', '6');
  INSERT INTO `city` VALUES ('71', '抚顺市', '6');
  INSERT INTO `city` VALUES ('72', '本溪市', '6');
  INSERT INTO `city` VALUES ('73', '丹东市', '6');
  INSERT INTO `city` VALUES ('74', '锦州市', '6');
  INSERT INTO `city` VALUES ('75', '营口市', '6');
  INSERT INTO `city` VALUES ('76', '营口市', '6');
  INSERT INTO `city` VALUES ('77', '辽阳市', '6');
  INSERT INTO `city` VALUES ('78', '盘锦市', '6');
  INSERT INTO `city` VALUES ('79', '铁岭市', '6');
  INSERT INTO `city` VALUES ('80', '朝阳市', '6');
  INSERT INTO `city` VALUES ('81', '葫芦岛市', '6');
  INSERT INTO `city` VALUES ('82', '长春市', '7');
  INSERT INTO `city` VALUES ('83', '吉林市', '7');
  INSERT INTO `city` VALUES ('84', '四平市', '7');
  INSERT INTO `city` VALUES ('85', '辽源市', '7');
  INSERT INTO `city` VALUES ('86', '通化市', '7');
  INSERT INTO `city` VALUES ('87', '白山市', '7');
  INSERT INTO `city` VALUES ('88', '松原市', '7');
  INSERT INTO `city` VALUES ('89', '白城市', '7');
  INSERT INTO `city` VALUES ('90', '延边朝鲜族自治州', '7');
  INSERT INTO `city` VALUES ('91', '哈尔滨市', '8');
  INSERT INTO `city` VALUES ('92', '齐齐哈尔市', '8');
  INSERT INTO `city` VALUES ('93', '鸡西市', '8');
  INSERT INTO `city` VALUES ('94', '鹤岗市', '8');
  INSERT INTO `city` VALUES ('95', '双鸭山市', '8');
  INSERT INTO `city` VALUES ('96', '大庆市', '8');
  INSERT INTO `city` VALUES ('97', '伊春市', '8');
  INSERT INTO `city` VALUES ('98', '佳木斯市', '8');
  INSERT INTO `city` VALUES ('99', '七台河市', '8');
  INSERT INTO `city` VALUES ('100', '牡丹江市', '8');
  INSERT INTO `city` VALUES ('101', '黑河市', '8');
  INSERT INTO `city` VALUES ('102', '绥化市', '8');
  INSERT INTO `city` VALUES ('103', '上海市', '9');
  INSERT INTO `city` VALUES ('104', '南京市', '10');
  INSERT INTO `city` VALUES ('105', '无锡市', '10');
  INSERT INTO `city` VALUES ('106', '徐州市', '10');
  INSERT INTO `city` VALUES ('107', '常州市', '10');
  INSERT INTO `city` VALUES ('108', '苏州市', '10');
  INSERT INTO `city` VALUES ('109', '南通市', '10');
  INSERT INTO `city` VALUES ('110', '连云港市', '10');
  INSERT INTO `city` VALUES ('111', '淮安市', '10');
  INSERT INTO `city` VALUES ('112', '盐城市', '10');
  INSERT INTO `city` VALUES ('113', '扬州市', '10');
  INSERT INTO `city` VALUES ('114', '镇江市', '10');
  INSERT INTO `city` VALUES ('115', '泰州市', '10');
  INSERT INTO `city` VALUES ('116', '宿迁市', '10');
  INSERT INTO `city` VALUES ('117', '杭州市', '11');
  INSERT INTO `city` VALUES ('118', '宁波市', '11');
  INSERT INTO `city` VALUES ('119', '温州市', '11');
  INSERT INTO `city` VALUES ('120', '嘉兴市', '11');
  INSERT INTO `city` VALUES ('121', '湖州市', '11');
  INSERT INTO `city` VALUES ('122', '绍兴市', '11');
  INSERT INTO `city` VALUES ('123', '金华市', '11');
  INSERT INTO `city` VALUES ('124', '衢州市', '11');
  INSERT INTO `city` VALUES ('125', '舟山市', '11');
  INSERT INTO `city` VALUES ('126', '台州市', '11');
  INSERT INTO `city` VALUES ('127', '丽水市', '11');
  INSERT INTO `city` VALUES ('128', '合肥市', '12');
  INSERT INTO `city` VALUES ('129', '芜湖市', '12');
  INSERT INTO `city` VALUES ('130', '蚌埠市', '12');
  INSERT INTO `city` VALUES ('131', '淮南市', '12');
  INSERT INTO `city` VALUES ('132', '马鞍山市', '12');
  INSERT INTO `city` VALUES ('133', '淮北市', '12');
  INSERT INTO `city` VALUES ('134', '铜陵市', '12');
  INSERT INTO `city` VALUES ('135', '安庆市', '12');
  INSERT INTO `city` VALUES ('136', '黄山市', '12');
  INSERT INTO `city` VALUES ('137', '滁州市', '12');
  INSERT INTO `city` VALUES ('138', '阜阳市', '12');
  INSERT INTO `city` VALUES ('139', '宿州市', '12');
  INSERT INTO `city` VALUES ('140', '巢湖市', '12');
  INSERT INTO `city` VALUES ('141', '六安市', '12');
  INSERT INTO `city` VALUES ('142', '亳州市', '12');
  INSERT INTO `city` VALUES ('143', '池州市', '12');
  INSERT INTO `city` VALUES ('144', '宣城市', '12');
  INSERT INTO `city` VALUES ('145', '福州市', '13');
  INSERT INTO `city` VALUES ('146', '厦门市', '13');
  INSERT INTO `city` VALUES ('147', '莆田市', '13');
  INSERT INTO `city` VALUES ('148', '三明市', '13');
  INSERT INTO `city` VALUES ('149', '泉州市', '13');
  INSERT INTO `city` VALUES ('150', '漳州市', '13');
  INSERT INTO `city` VALUES ('151', '南平市', '13');
  INSERT INTO `city` VALUES ('152', '龙岩市', '13');
  INSERT INTO `city` VALUES ('153', '宁德市', '13');
  INSERT INTO `city` VALUES ('154', '南昌市', '14');
  INSERT INTO `city` VALUES ('155', '景德镇市', '14');
  INSERT INTO `city` VALUES ('156', '萍乡市', '14');
  INSERT INTO `city` VALUES ('157', '九江市', '14');
  INSERT INTO `city` VALUES ('158', '新余市', '14');
  INSERT INTO `city` VALUES ('159', '鹰潭市', '14');
  INSERT INTO `city` VALUES ('160', '赣州市', '14');
  INSERT INTO `city` VALUES ('161', '吉安市', '14');
  INSERT INTO `city` VALUES ('162', '宜春市', '14');
  INSERT INTO `city` VALUES ('163', '抚州市', '14');
  INSERT INTO `city` VALUES ('164', '上饶市', '14');
  INSERT INTO `city` VALUES ('165', '济南市', '15');
  INSERT INTO `city` VALUES ('166', '青岛市', '15');
  INSERT INTO `city` VALUES ('167', '淄博市', '15');
  INSERT INTO `city` VALUES ('168', '枣庄市', '15');
  INSERT INTO `city` VALUES ('169', '东营市', '15');
  INSERT INTO `city` VALUES ('170', '烟台市', '15');
  INSERT INTO `city` VALUES ('171', '潍坊市', '15');
  INSERT INTO `city` VALUES ('172', '济宁市', '15');
  INSERT INTO `city` VALUES ('173', '泰安市', '15');
  INSERT INTO `city` VALUES ('174', '威海市', '15');
  INSERT INTO `city` VALUES ('175', '日照市', '15');
  INSERT INTO `city` VALUES ('176', '莱芜市', '15');
  INSERT INTO `city` VALUES ('177', '临沂市', '15');
  INSERT INTO `city` VALUES ('178', '德州市', '15');
  INSERT INTO `city` VALUES ('179', '聊城市', '15');
  INSERT INTO `city` VALUES ('180', '滨州市', '15');
  INSERT INTO `city` VALUES ('181', '菏泽市', '15');
  INSERT INTO `city` VALUES ('182', '郑州市', '16');
  INSERT INTO `city` VALUES ('183', '开封市', '16');
  INSERT INTO `city` VALUES ('184', '洛阳市', '16');
  INSERT INTO `city` VALUES ('185', '平顶山市', '16');
  INSERT INTO `city` VALUES ('186', '安阳市', '16');
  INSERT INTO `city` VALUES ('187', '鹤壁市', '16');
  INSERT INTO `city` VALUES ('188', '新乡市', '16');
  INSERT INTO `city` VALUES ('189', '焦作市', '16');
  INSERT INTO `city` VALUES ('190', '濮阳市', '16');
  INSERT INTO `city` VALUES ('191', '许昌市', '16');
  INSERT INTO `city` VALUES ('192', '漯河市', '16');
  INSERT INTO `city` VALUES ('193', '三门峡市', '16');
  INSERT INTO `city` VALUES ('194', '南阳市', '16');
  INSERT INTO `city` VALUES ('195', '商丘市', '16');
  INSERT INTO `city` VALUES ('196', '信阳市', '16');
  INSERT INTO `city` VALUES ('197', '周口市', '16');
  INSERT INTO `city` VALUES ('198', '驻马店市', '16');
  INSERT INTO `city` VALUES ('199', '武汉市', '17');
  INSERT INTO `city` VALUES ('200', '黄石市', '17');
  INSERT INTO `city` VALUES ('201', '十堰市', '17');
  INSERT INTO `city` VALUES ('202', '宜昌市', '17');
  INSERT INTO `city` VALUES ('203', '襄樊市', '17');
  INSERT INTO `city` VALUES ('204', '鄂州市', '17');
  INSERT INTO `city` VALUES ('205', '荆门市', '17');
  INSERT INTO `city` VALUES ('206', '孝感市', '17');
  INSERT INTO `city` VALUES ('207', '荆州市', '17');
  INSERT INTO `city` VALUES ('208', '黄冈市', '17');
  INSERT INTO `city` VALUES ('209', '咸宁市', '17');
  INSERT INTO `city` VALUES ('210', '随州市', '17');
  INSERT INTO `city` VALUES ('211', '恩施土家族苗族自治州', '17');
  INSERT INTO `city` VALUES ('212', '长沙市', '18');
  INSERT INTO `city` VALUES ('213', '株洲市', '18');
  INSERT INTO `city` VALUES ('214', '湘潭市', '18');
  INSERT INTO `city` VALUES ('215', '衡阳市', '18');
  INSERT INTO `city` VALUES ('216', '邵阳市', '18');
  INSERT INTO `city` VALUES ('217', '岳阳市', '18');
  INSERT INTO `city` VALUES ('218', '常德市', '18');
  INSERT INTO `city` VALUES ('219', '张家界市', '18');
  INSERT INTO `city` VALUES ('220', '益阳市', '18');
  INSERT INTO `city` VALUES ('221', '郴州市', '18');
  INSERT INTO `city` VALUES ('222', '永州市', '18');
  INSERT INTO `city` VALUES ('223', '怀化市', '18');
  INSERT INTO `city` VALUES ('224', '娄底市', '18');
  INSERT INTO `city` VALUES ('225', '湘西土家族苗族自治州', '18');
  INSERT INTO `city` VALUES ('226', '广州市', '19');
  INSERT INTO `city` VALUES ('227', '韶关市', '19');
  INSERT INTO `city` VALUES ('228', '深圳市', '19');
  INSERT INTO `city` VALUES ('229', '珠海市', '19');
  INSERT INTO `city` VALUES ('230', '汕头市', '19');
  INSERT INTO `city` VALUES ('231', '佛山市', '19');
  INSERT INTO `city` VALUES ('232', '江门市', '19');
  INSERT INTO `city` VALUES ('233', '湛江市', '19');
  INSERT INTO `city` VALUES ('234', '茂名市', '19');
  INSERT INTO `city` VALUES ('235', '肇庆市', '19');
  INSERT INTO `city` VALUES ('236', '惠州市', '19');
  INSERT INTO `city` VALUES ('237', '梅州市', '19');
  INSERT INTO `city` VALUES ('238', '汕尾市', '19');
  INSERT INTO `city` VALUES ('239', '河源市', '19');
  INSERT INTO `city` VALUES ('240', '阳江市', '19');
  INSERT INTO `city` VALUES ('241', '清远市', '19');
  INSERT INTO `city` VALUES ('242', '潮州市', '19');
  INSERT INTO `city` VALUES ('243', '揭阳市', '19');
  INSERT INTO `city` VALUES ('244', '云浮市', '19');
  INSERT INTO `city` VALUES ('245', '南宁市', '20');
  INSERT INTO `city` VALUES ('246', '柳州市', '20');
  INSERT INTO `city` VALUES ('247', '桂林市', '20');
  INSERT INTO `city` VALUES ('248', '梧州市', '20');
  INSERT INTO `city` VALUES ('249', '北海市', '20');
  INSERT INTO `city` VALUES ('250', '防城港市', '20');
  INSERT INTO `city` VALUES ('251', '钦州市', '20');
  INSERT INTO `city` VALUES ('252', '贵港市', '20');
  INSERT INTO `city` VALUES ('253', '玉林市', '20');
  INSERT INTO `city` VALUES ('254', '百色市', '20');
  INSERT INTO `city` VALUES ('255', '贺州市', '20');
  INSERT INTO `city` VALUES ('256', '河池市', '20');
  INSERT INTO `city` VALUES ('257', '来宾市', '20');
  INSERT INTO `city` VALUES ('258', '崇左市', '20');
  INSERT INTO `city` VALUES ('259', '海口市', '21');
  INSERT INTO `city` VALUES ('260', '三亚市', '21');
  INSERT INTO `city` VALUES ('261', '重庆市', '22');
  INSERT INTO `city` VALUES ('262', '成都市', '23');
  INSERT INTO `city` VALUES ('263', '自贡市', '23');
  INSERT INTO `city` VALUES ('264', '攀枝花市', '23');
  INSERT INTO `city` VALUES ('265', '泸州市', '23');
  INSERT INTO `city` VALUES ('266', '德阳市', '23');
  INSERT INTO `city` VALUES ('267', '绵阳市', '23');
  INSERT INTO `city` VALUES ('268', '广元市', '23');
  INSERT INTO `city` VALUES ('269', '遂宁市', '23');
  INSERT INTO `city` VALUES ('270', '内江市', '23');
  INSERT INTO `city` VALUES ('271', '乐山市', '23');
  INSERT INTO `city` VALUES ('272', '南充市', '23');
  INSERT INTO `city` VALUES ('273', '眉山市', '23');
  INSERT INTO `city` VALUES ('274', '宜宾市', '23');
  INSERT INTO `city` VALUES ('275', '广安市', '23');
  INSERT INTO `city` VALUES ('276', '达州市', '23');
  INSERT INTO `city` VALUES ('277', '雅安市', '23');
  INSERT INTO `city` VALUES ('278', '巴中市', '23');
  INSERT INTO `city` VALUES ('279', '资阳市', '23');
  INSERT INTO `city` VALUES ('280', '阿坝藏族羌族自治州', '23');
  INSERT INTO `city` VALUES ('281', '甘孜藏族自治州', '23');
  INSERT INTO `city` VALUES ('282', '凉山彝族自治州', '23');
  INSERT INTO `city` VALUES ('283', '贵阳市', '24');
  INSERT INTO `city` VALUES ('284', '六盘水市', '24');
  INSERT INTO `city` VALUES ('285', '遵义市', '24');
  INSERT INTO `city` VALUES ('286', '安顺市', '24');
  INSERT INTO `city` VALUES ('287', '铜仁地区', '24');
  INSERT INTO `city` VALUES ('288', '黔西南布依族苗族自治州', '24');
  INSERT INTO `city` VALUES ('289', '毕节地区', '24');
  INSERT INTO `city` VALUES ('290', '黔东南苗族侗族自治州', '24');
  INSERT INTO `city` VALUES ('291', '黔南布依族苗族自治州', '24');
  INSERT INTO `city` VALUES ('292', '昆明市', '25');
  INSERT INTO `city` VALUES ('293', '曲靖市', '25');
  INSERT INTO `city` VALUES ('294', '玉溪市', '25');
  INSERT INTO `city` VALUES ('295', '保山市', '25');
  INSERT INTO `city` VALUES ('296', '昭通市', '25');
  INSERT INTO `city` VALUES ('297', '丽江市', '25');
  INSERT INTO `city` VALUES ('298', '普洱市', '25');
  INSERT INTO `city` VALUES ('299', '临沧市', '25');
  INSERT INTO `city` VALUES ('300', '楚雄彝族自治州', '25');
  INSERT INTO `city` VALUES ('301', '红河哈尼族彝族自治州', '25');
  INSERT INTO `city` VALUES ('302', '文山壮族苗族自治州', '25');
  INSERT INTO `city` VALUES ('303', '西双版纳傣族自治州', '25');
  INSERT INTO `city` VALUES ('304', '大理白族自治州', '25');
  INSERT INTO `city` VALUES ('305', '德宏傣族景颇族自治州', '25');
  INSERT INTO `city` VALUES ('306', '怒江傈僳族自治州', '25');
  INSERT INTO `city` VALUES ('307', '迪庆藏族自治州', '25');
  INSERT INTO `city` VALUES ('308', '拉萨市', '26');
  INSERT INTO `city` VALUES ('309', '昌都地区', '26');
  INSERT INTO `city` VALUES ('310', '山南地区', '26');
  INSERT INTO `city` VALUES ('311', '日喀则地区', '26');
  INSERT INTO `city` VALUES ('312', '那曲地区', '26');
  INSERT INTO `city` VALUES ('313', '阿里地区', '26');
  INSERT INTO `city` VALUES ('314', '林芝地区', '26');
  INSERT INTO `city` VALUES ('315', '西安市', '27');
  INSERT INTO `city` VALUES ('316', '铜川市', '27');
  INSERT INTO `city` VALUES ('317', '宝鸡市', '27');
  INSERT INTO `city` VALUES ('318', '咸阳市', '27');
  INSERT INTO `city` VALUES ('319', '渭南市', '27');
  INSERT INTO `city` VALUES ('320', '延安市', '27');
  INSERT INTO `city` VALUES ('321', '汉中市', '27');
  INSERT INTO `city` VALUES ('322', '榆林市', '27');
  INSERT INTO `city` VALUES ('323', '安康市', '27');
  INSERT INTO `city` VALUES ('324', '商洛市', '27');
  INSERT INTO `city` VALUES ('325', '兰州市', '28');
  INSERT INTO `city` VALUES ('326', '金昌市', '28');
  INSERT INTO `city` VALUES ('327', '白银市', '28');
  INSERT INTO `city` VALUES ('328', '天水市', '28');
  INSERT INTO `city` VALUES ('329', '武威市', '28');
  INSERT INTO `city` VALUES ('330', '张掖市', '28');
  INSERT INTO `city` VALUES ('331', '平凉市', '28');
  INSERT INTO `city` VALUES ('332', '酒泉市', '28');
  INSERT INTO `city` VALUES ('333', '庆阳市', '28');
  INSERT INTO `city` VALUES ('334', '定西市', '28');
  INSERT INTO `city` VALUES ('335', '陇南市', '28');
  INSERT INTO `city` VALUES ('336', '临夏回族自治州', '28');
  INSERT INTO `city` VALUES ('337', '甘南藏族自治州', '28');
  INSERT INTO `city` VALUES ('338', '西宁市', '29');
  INSERT INTO `city` VALUES ('339', '海东地区', '29');
  INSERT INTO `city` VALUES ('340', '海北藏族自治州', '29');
  INSERT INTO `city` VALUES ('341', '黄南藏族自治州', '29');
  INSERT INTO `city` VALUES ('342', '海南藏族自治州', '29');
  INSERT INTO `city` VALUES ('343', '果洛藏族自治州', '29');
  INSERT INTO `city` VALUES ('344', '玉树藏族自治州', '29');
  INSERT INTO `city` VALUES ('345', '海西蒙古族藏族自治州', '29');
  INSERT INTO `city` VALUES ('346', '银川市', '30');
  INSERT INTO `city` VALUES ('347', '石嘴山市', '30');
  INSERT INTO `city` VALUES ('348', '吴忠市', '30');
  INSERT INTO `city` VALUES ('349', '固原市', '30');
  INSERT INTO `city` VALUES ('350', '中卫市', '30');
  INSERT INTO `city` VALUES ('351', '乌鲁木齐市', '31');
  INSERT INTO `city` VALUES ('352', '克拉玛依市', '31');
  INSERT INTO `city` VALUES ('353', '吐鲁番地区', '31');
  INSERT INTO `city` VALUES ('354', '哈密地区', '31');
  INSERT INTO `city` VALUES ('355', '昌吉回族自治州', '31');
  INSERT INTO `city` VALUES ('356', '博尔塔拉蒙古自治州', '31');
  INSERT INTO `city` VALUES ('357', '巴音郭楞蒙古自治州', '31');
  INSERT INTO `city` VALUES ('358', '阿克苏地区', '31');
  INSERT INTO `city` VALUES ('359', '克孜勒苏柯尔克孜自治州', '31');
  INSERT INTO `city` VALUES ('360', '喀什地区', '31');
  INSERT INTO `city` VALUES ('361', '和田地区', '31');
  INSERT INTO `city` VALUES ('362', '伊犁哈萨克自治州', '31');
  INSERT INTO `city` VALUES ('363', '塔城地区', '31');
  INSERT INTO `city` VALUES ('364', '阿勒泰地区', '31');
  INSERT INTO `city` VALUES ('365', '石河子市', '31');
  INSERT INTO `city` VALUES ('366', '阿拉尔市', '31');
  INSERT INTO `city` VALUES ('367', '图木舒克市', '31');
  INSERT INTO `city` VALUES ('368', '五家渠市', '31');
  INSERT INTO `city` VALUES ('369', '嘉峪关市', '28');
  
  -- ----------------------------
  -- Table structure for `district`
  -- ----------------------------
  DROP TABLE IF EXISTS `district`;
  CREATE TABLE `district` (
    `d_id` int(11) NOT NULL AUTO_INCREMENT,
    `d_name` varchar(30) DEFAULT NULL,
    `c_id` int(11) DEFAULT NULL,
    PRIMARY KEY (`d_id`),
    KEY `c_id` (`c_id`),
    CONSTRAINT `district_ibfk_1` FOREIGN KEY (`c_id`) REFERENCES `city` (`c_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2824 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of district
  -- ----------------------------
  INSERT INTO `district` VALUES ('1', '长安区', '37');
  INSERT INTO `district` VALUES ('2', '桥东区', '37');
  INSERT INTO `district` VALUES ('3', '桥西区', '37');
  INSERT INTO `district` VALUES ('4', '新华区', '37');
  INSERT INTO `district` VALUES ('5', '井陉矿区', '37');
  INSERT INTO `district` VALUES ('6', '裕华区', '37');
  INSERT INTO `district` VALUES ('7', '井陉县', '37');
  INSERT INTO `district` VALUES ('8', '正定县', '37');
  INSERT INTO `district` VALUES ('9', '栾城县', '37');
  INSERT INTO `district` VALUES ('10', '行唐县', '37');
  INSERT INTO `district` VALUES ('11', '灵寿县', '37');
  INSERT INTO `district` VALUES ('12', '高邑县', '37');
  INSERT INTO `district` VALUES ('13', '深泽县', '37');
  INSERT INTO `district` VALUES ('14', '赞皇县', '37');
  INSERT INTO `district` VALUES ('15', '无极县', '37');
  INSERT INTO `district` VALUES ('16', '平山县', '37');
  INSERT INTO `district` VALUES ('17', '元氏县', '37');
  INSERT INTO `district` VALUES ('18', '赵  县', '37');
  INSERT INTO `district` VALUES ('19', '辛集市', '37');
  INSERT INTO `district` VALUES ('20', '藁城市', '37');
  INSERT INTO `district` VALUES ('21', '晋州市', '37');
  INSERT INTO `district` VALUES ('22', '新乐市', '37');
  INSERT INTO `district` VALUES ('23', '鹿泉市', '37');
  INSERT INTO `district` VALUES ('24', '路南区', '38');
  INSERT INTO `district` VALUES ('25', '路北区', '38');
  INSERT INTO `district` VALUES ('26', '古冶区', '38');
  INSERT INTO `district` VALUES ('27', '开平区', '38');
  INSERT INTO `district` VALUES ('28', '丰南区', '38');
  INSERT INTO `district` VALUES ('29', '丰润区', '38');
  INSERT INTO `district` VALUES ('30', '滦  县', '38');
  INSERT INTO `district` VALUES ('31', '滦南县', '38');
  INSERT INTO `district` VALUES ('32', '乐亭县', '38');
  INSERT INTO `district` VALUES ('33', '迁西县', '38');
  INSERT INTO `district` VALUES ('34', '玉田县', '38');
  INSERT INTO `district` VALUES ('35', '唐海县', '38');
  INSERT INTO `district` VALUES ('36', '遵化市', '38');
  INSERT INTO `district` VALUES ('37', '迁安市', '38');
  INSERT INTO `district` VALUES ('38', '海港区', '39');
  INSERT INTO `district` VALUES ('39', '山海关区', '39');
  INSERT INTO `district` VALUES ('40', '北戴河区', '39');
  INSERT INTO `district` VALUES ('41', '青龙满族自治县', '39');
  INSERT INTO `district` VALUES ('42', '昌黎县', '39');
  INSERT INTO `district` VALUES ('43', '抚宁县', '39');
  INSERT INTO `district` VALUES ('44', '卢龙县', '39');
  INSERT INTO `district` VALUES ('45', '邯山区', '40');
  INSERT INTO `district` VALUES ('46', '丛台区', '40');
  INSERT INTO `district` VALUES ('47', '复兴区', '40');
  INSERT INTO `district` VALUES ('48', '峰峰矿区', '40');
  INSERT INTO `district` VALUES ('49', '邯郸县', '40');
  INSERT INTO `district` VALUES ('50', '临漳县', '40');
  INSERT INTO `district` VALUES ('51', '成安县', '40');
  INSERT INTO `district` VALUES ('52', '大名县', '40');
  INSERT INTO `district` VALUES ('53', '涉  县', '40');
  INSERT INTO `district` VALUES ('54', '磁  县', '40');
  INSERT INTO `district` VALUES ('55', '肥乡县', '40');
  INSERT INTO `district` VALUES ('56', '永年县', '40');
  INSERT INTO `district` VALUES ('57', '邱  县', '40');
  INSERT INTO `district` VALUES ('58', '鸡泽县', '40');
  INSERT INTO `district` VALUES ('59', '广平县', '40');
  INSERT INTO `district` VALUES ('60', '馆陶县', '40');
  INSERT INTO `district` VALUES ('61', '魏  县', '40');
  INSERT INTO `district` VALUES ('62', '曲周县', '40');
  INSERT INTO `district` VALUES ('63', '武安市', '40');
  INSERT INTO `district` VALUES ('64', '桥东区', '41');
  INSERT INTO `district` VALUES ('65', '桥西区', '41');
  INSERT INTO `district` VALUES ('66', '邢台县', '41');
  INSERT INTO `district` VALUES ('67', '临城县', '41');
  INSERT INTO `district` VALUES ('68', '内丘县', '41');
  INSERT INTO `district` VALUES ('69', '柏乡县', '41');
  INSERT INTO `district` VALUES ('70', '隆尧县', '41');
  INSERT INTO `district` VALUES ('71', '任　县', '41');
  INSERT INTO `district` VALUES ('72', '南和县', '41');
  INSERT INTO `district` VALUES ('73', '宁晋县', '41');
  INSERT INTO `district` VALUES ('74', '巨鹿县', '41');
  INSERT INTO `district` VALUES ('75', '新河县', '41');
  INSERT INTO `district` VALUES ('76', '广宗县', '41');
  INSERT INTO `district` VALUES ('77', '平乡县', '41');
  INSERT INTO `district` VALUES ('78', '威　县', '41');
  INSERT INTO `district` VALUES ('79', '清河县', '41');
  INSERT INTO `district` VALUES ('80', '临西县', '41');
  INSERT INTO `district` VALUES ('81', '南宫市', '41');
  INSERT INTO `district` VALUES ('82', '沙河市', '41');
  INSERT INTO `district` VALUES ('83', '新市区', '42');
  INSERT INTO `district` VALUES ('84', '北市区', '42');
  INSERT INTO `district` VALUES ('85', '南市区', '42');
  INSERT INTO `district` VALUES ('86', '满城县', '42');
  INSERT INTO `district` VALUES ('87', '清苑县', '42');
  INSERT INTO `district` VALUES ('88', '涞水县', '42');
  INSERT INTO `district` VALUES ('89', '阜平县', '42');
  INSERT INTO `district` VALUES ('90', '徐水县', '42');
  INSERT INTO `district` VALUES ('91', '定兴县', '42');
  INSERT INTO `district` VALUES ('92', '唐　县', '42');
  INSERT INTO `district` VALUES ('93', '高阳县', '42');
  INSERT INTO `district` VALUES ('94', '容城县', '42');
  INSERT INTO `district` VALUES ('95', '涞源县', '42');
  INSERT INTO `district` VALUES ('96', '望都县', '42');
  INSERT INTO `district` VALUES ('97', '安新县', '42');
  INSERT INTO `district` VALUES ('98', '易　县', '42');
  INSERT INTO `district` VALUES ('99', '曲阳县', '42');
  INSERT INTO `district` VALUES ('100', '蠡　县', '42');
  INSERT INTO `district` VALUES ('101', '顺平县', '42');
  INSERT INTO `district` VALUES ('102', '博野县', '42');
  INSERT INTO `district` VALUES ('103', '雄　县', '42');
  INSERT INTO `district` VALUES ('104', '涿州市', '42');
  INSERT INTO `district` VALUES ('105', '定州市', '42');
  INSERT INTO `district` VALUES ('106', '安国市', '42');
  INSERT INTO `district` VALUES ('107', '高碑店市', '42');
  INSERT INTO `district` VALUES ('108', '桥东区', '43');
  INSERT INTO `district` VALUES ('109', '桥西区', '43');
  INSERT INTO `district` VALUES ('110', '宣化区', '43');
  INSERT INTO `district` VALUES ('111', '下花园区', '43');
  INSERT INTO `district` VALUES ('112', '宣化县', '43');
  INSERT INTO `district` VALUES ('113', '张北县', '43');
  INSERT INTO `district` VALUES ('114', '康保县', '43');
  INSERT INTO `district` VALUES ('115', '沽源县', '43');
  INSERT INTO `district` VALUES ('116', '尚义县', '43');
  INSERT INTO `district` VALUES ('117', '蔚　县', '43');
  INSERT INTO `district` VALUES ('118', '阳原县', '43');
  INSERT INTO `district` VALUES ('119', '怀安县', '43');
  INSERT INTO `district` VALUES ('120', '万全县', '43');
  INSERT INTO `district` VALUES ('121', '怀来县', '43');
  INSERT INTO `district` VALUES ('122', '涿鹿县', '43');
  INSERT INTO `district` VALUES ('123', '赤城县', '43');
  INSERT INTO `district` VALUES ('124', '崇礼县', '43');
  INSERT INTO `district` VALUES ('125', '双桥区', '44');
  INSERT INTO `district` VALUES ('126', '双滦区', '44');
  INSERT INTO `district` VALUES ('127', '鹰手营子矿区', '44');
  INSERT INTO `district` VALUES ('128', '承德县', '44');
  INSERT INTO `district` VALUES ('129', '兴隆县', '44');
  INSERT INTO `district` VALUES ('130', '平泉县', '44');
  INSERT INTO `district` VALUES ('131', '滦平县', '44');
  INSERT INTO `district` VALUES ('132', '隆化县', '44');
  INSERT INTO `district` VALUES ('133', '丰宁满族自治县', '44');
  INSERT INTO `district` VALUES ('134', '宽城满族自治县', '44');
  INSERT INTO `district` VALUES ('135', '围场满族蒙古族自治县', '44');
  INSERT INTO `district` VALUES ('136', '新华区', '45');
  INSERT INTO `district` VALUES ('137', '运河区', '45');
  INSERT INTO `district` VALUES ('138', '沧　县', '45');
  INSERT INTO `district` VALUES ('139', '青　县', '45');
  INSERT INTO `district` VALUES ('140', '东光县', '45');
  INSERT INTO `district` VALUES ('141', '海兴县', '45');
  INSERT INTO `district` VALUES ('142', '盐山县', '45');
  INSERT INTO `district` VALUES ('143', '肃宁县', '45');
  INSERT INTO `district` VALUES ('144', '南皮县', '45');
  INSERT INTO `district` VALUES ('145', '吴桥县', '45');
  INSERT INTO `district` VALUES ('146', '献　县', '45');
  INSERT INTO `district` VALUES ('147', '孟村回族自治县', '45');
  INSERT INTO `district` VALUES ('148', '泊头市', '45');
  INSERT INTO `district` VALUES ('149', '任丘市', '45');
  INSERT INTO `district` VALUES ('150', '黄骅市', '45');
  INSERT INTO `district` VALUES ('151', '河间市', '45');
  INSERT INTO `district` VALUES ('152', '安次区', '46');
  INSERT INTO `district` VALUES ('153', '广阳区', '46');
  INSERT INTO `district` VALUES ('154', '固安县', '46');
  INSERT INTO `district` VALUES ('155', '永清县', '46');
  INSERT INTO `district` VALUES ('156', '香河县', '46');
  INSERT INTO `district` VALUES ('157', '大城县', '46');
  INSERT INTO `district` VALUES ('158', '文安县', '46');
  INSERT INTO `district` VALUES ('159', '大厂回族自治县', '46');
  INSERT INTO `district` VALUES ('160', '霸州市', '46');
  INSERT INTO `district` VALUES ('161', '三河市', '46');
  INSERT INTO `district` VALUES ('162', '桃城区', '47');
  INSERT INTO `district` VALUES ('163', '枣强县', '47');
  INSERT INTO `district` VALUES ('164', '武邑县', '47');
  INSERT INTO `district` VALUES ('165', '武强县', '47');
  INSERT INTO `district` VALUES ('166', '饶阳县', '47');
  INSERT INTO `district` VALUES ('167', '安平县', '47');
  INSERT INTO `district` VALUES ('168', '故城县', '47');
  INSERT INTO `district` VALUES ('169', '景　县', '47');
  INSERT INTO `district` VALUES ('170', '阜城县', '47');
  INSERT INTO `district` VALUES ('171', '冀州市', '47');
  INSERT INTO `district` VALUES ('172', '深州市', '47');
  INSERT INTO `district` VALUES ('173', '小店区', '48');
  INSERT INTO `district` VALUES ('174', '迎泽区', '48');
  INSERT INTO `district` VALUES ('175', '杏花岭区', '48');
  INSERT INTO `district` VALUES ('176', '尖草坪区', '48');
  INSERT INTO `district` VALUES ('177', '万柏林区', '48');
  INSERT INTO `district` VALUES ('178', '晋源区', '48');
  INSERT INTO `district` VALUES ('179', '清徐县', '48');
  INSERT INTO `district` VALUES ('180', '阳曲县', '48');
  INSERT INTO `district` VALUES ('181', '娄烦县', '48');
  INSERT INTO `district` VALUES ('182', '古交市', '48');
  INSERT INTO `district` VALUES ('183', '城　区', '49');
  INSERT INTO `district` VALUES ('184', '矿　区', '49');
  INSERT INTO `district` VALUES ('185', '南郊区', '49');
  INSERT INTO `district` VALUES ('186', '新荣区', '49');
  INSERT INTO `district` VALUES ('187', '阳高县', '49');
  INSERT INTO `district` VALUES ('188', '天镇县', '49');
  INSERT INTO `district` VALUES ('189', '广灵县', '49');
  INSERT INTO `district` VALUES ('190', '灵丘县', '49');
  INSERT INTO `district` VALUES ('191', '浑源县', '49');
  INSERT INTO `district` VALUES ('192', '左云县', '49');
  INSERT INTO `district` VALUES ('193', '大同县', '49');
  INSERT INTO `district` VALUES ('194', '城　区', '50');
  INSERT INTO `district` VALUES ('195', '矿　区', '50');
  INSERT INTO `district` VALUES ('196', '郊　区', '50');
  INSERT INTO `district` VALUES ('197', '平定县', '50');
  INSERT INTO `district` VALUES ('198', '盂　县', '50');
  INSERT INTO `district` VALUES ('199', '城　区', '51');
  INSERT INTO `district` VALUES ('200', '郊　区', '51');
  INSERT INTO `district` VALUES ('201', '长治县', '51');
  INSERT INTO `district` VALUES ('202', '襄垣县', '51');
  INSERT INTO `district` VALUES ('203', '屯留县', '51');
  INSERT INTO `district` VALUES ('204', '平顺县', '51');
  INSERT INTO `district` VALUES ('205', '黎城县', '51');
  INSERT INTO `district` VALUES ('206', '壶关县', '51');
  INSERT INTO `district` VALUES ('207', '长子县', '51');
  INSERT INTO `district` VALUES ('208', '武乡县', '51');
  INSERT INTO `district` VALUES ('209', '沁　县', '51');
  INSERT INTO `district` VALUES ('210', '沁源县', '51');
  INSERT INTO `district` VALUES ('211', '潞城市', '51');
  INSERT INTO `district` VALUES ('212', '城　区', '52');
  INSERT INTO `district` VALUES ('213', '沁水县', '52');
  INSERT INTO `district` VALUES ('214', '阳城县', '52');
  INSERT INTO `district` VALUES ('215', '陵川县', '52');
  INSERT INTO `district` VALUES ('216', '泽州县', '52');
  INSERT INTO `district` VALUES ('217', '高平市', '52');
  INSERT INTO `district` VALUES ('218', '朔城区', '53');
  INSERT INTO `district` VALUES ('219', '平鲁区', '53');
  INSERT INTO `district` VALUES ('220', '山阴县', '53');
  INSERT INTO `district` VALUES ('221', '应　县', '53');
  INSERT INTO `district` VALUES ('222', '右玉县', '53');
  INSERT INTO `district` VALUES ('223', '怀仁县', '53');
  INSERT INTO `district` VALUES ('224', '榆次区', '54');
  INSERT INTO `district` VALUES ('225', '榆社县', '54');
  INSERT INTO `district` VALUES ('226', '左权县', '54');
  INSERT INTO `district` VALUES ('227', '和顺县', '54');
  INSERT INTO `district` VALUES ('228', '昔阳县', '54');
  INSERT INTO `district` VALUES ('229', '寿阳县', '54');
  INSERT INTO `district` VALUES ('230', '太谷县', '54');
  INSERT INTO `district` VALUES ('231', '祁　县', '54');
  INSERT INTO `district` VALUES ('232', '平遥县', '54');
  INSERT INTO `district` VALUES ('233', '灵石县', '54');
  INSERT INTO `district` VALUES ('234', '介休市', '54');
  INSERT INTO `district` VALUES ('235', '盐湖区', '55');
  INSERT INTO `district` VALUES ('236', '临猗县', '55');
  INSERT INTO `district` VALUES ('237', '万荣县', '55');
  INSERT INTO `district` VALUES ('238', '闻喜县', '55');
  INSERT INTO `district` VALUES ('239', '稷山县', '55');
  INSERT INTO `district` VALUES ('240', '新绛县', '55');
  INSERT INTO `district` VALUES ('241', '绛　县', '55');
  INSERT INTO `district` VALUES ('242', '垣曲县', '55');
  INSERT INTO `district` VALUES ('243', '夏　县', '55');
  INSERT INTO `district` VALUES ('244', '平陆县', '55');
  INSERT INTO `district` VALUES ('245', '芮城县', '55');
  INSERT INTO `district` VALUES ('246', '永济市', '55');
  INSERT INTO `district` VALUES ('247', '河津市', '55');
  INSERT INTO `district` VALUES ('248', '忻府区', '56');
  INSERT INTO `district` VALUES ('249', '定襄县', '56');
  INSERT INTO `district` VALUES ('250', '五台县', '56');
  INSERT INTO `district` VALUES ('251', '代　县', '56');
  INSERT INTO `district` VALUES ('252', '繁峙县', '56');
  INSERT INTO `district` VALUES ('253', '宁武县', '56');
  INSERT INTO `district` VALUES ('254', '静乐县', '56');
  INSERT INTO `district` VALUES ('255', '神池县', '56');
  INSERT INTO `district` VALUES ('256', '五寨县', '56');
  INSERT INTO `district` VALUES ('257', '岢岚县', '56');
  INSERT INTO `district` VALUES ('258', '河曲县', '56');
  INSERT INTO `district` VALUES ('259', '保德县', '56');
  INSERT INTO `district` VALUES ('260', '偏关县', '56');
  INSERT INTO `district` VALUES ('261', '原平市', '56');
  INSERT INTO `district` VALUES ('262', '尧都区', '57');
  INSERT INTO `district` VALUES ('263', '曲沃县', '57');
  INSERT INTO `district` VALUES ('264', '翼城县', '57');
  INSERT INTO `district` VALUES ('265', '襄汾县', '57');
  INSERT INTO `district` VALUES ('266', '洪洞县', '57');
  INSERT INTO `district` VALUES ('267', '古　县', '57');
  INSERT INTO `district` VALUES ('268', '安泽县', '57');
  INSERT INTO `district` VALUES ('269', '浮山县', '57');
  INSERT INTO `district` VALUES ('270', '吉　县', '57');
  INSERT INTO `district` VALUES ('271', '乡宁县', '57');
  INSERT INTO `district` VALUES ('272', '大宁县', '57');
  INSERT INTO `district` VALUES ('273', '隰　县', '57');
  INSERT INTO `district` VALUES ('274', '永和县', '57');
  INSERT INTO `district` VALUES ('275', '蒲　县', '57');
  INSERT INTO `district` VALUES ('276', '汾西县', '57');
  INSERT INTO `district` VALUES ('277', '侯马市', '57');
  INSERT INTO `district` VALUES ('278', '霍州市', '57');
  INSERT INTO `district` VALUES ('279', '离石区', '58');
  INSERT INTO `district` VALUES ('280', '文水县', '58');
  INSERT INTO `district` VALUES ('281', '交城县', '58');
  INSERT INTO `district` VALUES ('282', '兴　县', '58');
  INSERT INTO `district` VALUES ('283', '临　县', '58');
  INSERT INTO `district` VALUES ('284', '柳林县', '58');
  INSERT INTO `district` VALUES ('285', '石楼县', '58');
  INSERT INTO `district` VALUES ('286', '岚　县', '58');
  INSERT INTO `district` VALUES ('287', '方山县', '58');
  INSERT INTO `district` VALUES ('288', '中阳县', '58');
  INSERT INTO `district` VALUES ('289', '交口县', '58');
  INSERT INTO `district` VALUES ('290', '孝义市', '58');
  INSERT INTO `district` VALUES ('291', '汾阳市', '58');
  INSERT INTO `district` VALUES ('292', '新城区', '59');
  INSERT INTO `district` VALUES ('293', '回民区', '59');
  INSERT INTO `district` VALUES ('294', '玉泉区', '59');
  INSERT INTO `district` VALUES ('295', '赛罕区', '59');
  INSERT INTO `district` VALUES ('296', '土默特左旗', '59');
  INSERT INTO `district` VALUES ('297', '托克托县', '59');
  INSERT INTO `district` VALUES ('298', '和林格尔县', '59');
  INSERT INTO `district` VALUES ('299', '清水河县', '59');
  INSERT INTO `district` VALUES ('300', '武川县', '59');
  INSERT INTO `district` VALUES ('301', '东河区', '60');
  INSERT INTO `district` VALUES ('302', '昆都仑区', '60');
  INSERT INTO `district` VALUES ('303', '青山区', '60');
  INSERT INTO `district` VALUES ('304', '石拐区', '60');
  INSERT INTO `district` VALUES ('305', '白云矿区', '60');
  INSERT INTO `district` VALUES ('306', '九原区', '60');
  INSERT INTO `district` VALUES ('307', '土默特右旗', '60');
  INSERT INTO `district` VALUES ('308', '固阳县', '60');
  INSERT INTO `district` VALUES ('309', '达尔罕茂明安联合旗', '60');
  INSERT INTO `district` VALUES ('310', '海勃湾区', '61');
  INSERT INTO `district` VALUES ('311', '海南区', '61');
  INSERT INTO `district` VALUES ('312', '乌达区', '61');
  INSERT INTO `district` VALUES ('313', '红山区', '62');
  INSERT INTO `district` VALUES ('314', '元宝山区', '62');
  INSERT INTO `district` VALUES ('315', '松山区', '62');
  INSERT INTO `district` VALUES ('316', '阿鲁科尔沁旗', '62');
  INSERT INTO `district` VALUES ('317', '巴林左旗', '62');
  INSERT INTO `district` VALUES ('318', '巴林右旗', '62');
  INSERT INTO `district` VALUES ('319', '林西县', '62');
  INSERT INTO `district` VALUES ('320', '克什克腾旗', '62');
  INSERT INTO `district` VALUES ('321', '翁牛特旗', '62');
  INSERT INTO `district` VALUES ('322', '喀喇沁旗', '62');
  INSERT INTO `district` VALUES ('323', '宁城县', '62');
  INSERT INTO `district` VALUES ('324', '敖汉旗', '62');
  INSERT INTO `district` VALUES ('325', '科尔沁区', '63');
  INSERT INTO `district` VALUES ('326', '科尔沁左翼中旗', '63');
  INSERT INTO `district` VALUES ('327', '科尔沁左翼后旗', '63');
  INSERT INTO `district` VALUES ('328', '开鲁县', '63');
  INSERT INTO `district` VALUES ('329', '库伦旗', '63');
  INSERT INTO `district` VALUES ('330', '奈曼旗', '63');
  INSERT INTO `district` VALUES ('331', '扎鲁特旗', '63');
  INSERT INTO `district` VALUES ('332', '霍林郭勒市', '63');
  INSERT INTO `district` VALUES ('333', '东胜区', '64');
  INSERT INTO `district` VALUES ('334', '达拉特旗', '64');
  INSERT INTO `district` VALUES ('335', '准格尔旗', '64');
  INSERT INTO `district` VALUES ('336', '鄂托克前旗', '64');
  INSERT INTO `district` VALUES ('337', '鄂托克旗', '64');
  INSERT INTO `district` VALUES ('338', '杭锦旗', '64');
  INSERT INTO `district` VALUES ('339', '乌审旗', '64');
  INSERT INTO `district` VALUES ('340', '伊金霍洛旗', '64');
  INSERT INTO `district` VALUES ('341', '海拉尔区', '65');
  INSERT INTO `district` VALUES ('342', '阿荣旗', '65');
  INSERT INTO `district` VALUES ('343', '莫力达瓦达斡尔族自治旗', '65');
  INSERT INTO `district` VALUES ('344', '鄂伦春自治旗', '65');
  INSERT INTO `district` VALUES ('345', '鄂温克族自治旗', '65');
  INSERT INTO `district` VALUES ('346', '陈巴尔虎旗', '65');
  INSERT INTO `district` VALUES ('347', '新巴尔虎左旗', '65');
  INSERT INTO `district` VALUES ('348', '新巴尔虎右旗', '65');
  INSERT INTO `district` VALUES ('349', '满洲里市', '65');
  INSERT INTO `district` VALUES ('350', '牙克石市', '65');
  INSERT INTO `district` VALUES ('351', '扎兰屯市', '65');
  INSERT INTO `district` VALUES ('352', '额尔古纳市', '65');
  INSERT INTO `district` VALUES ('353', '根河市', '65');
  INSERT INTO `district` VALUES ('354', '临河区', '66');
  INSERT INTO `district` VALUES ('355', '五原县', '66');
  INSERT INTO `district` VALUES ('356', '磴口县', '66');
  INSERT INTO `district` VALUES ('357', '乌拉特前旗', '66');
  INSERT INTO `district` VALUES ('358', '乌拉特中旗', '66');
  INSERT INTO `district` VALUES ('359', '乌拉特后旗', '66');
  INSERT INTO `district` VALUES ('360', '杭锦后旗', '66');
  INSERT INTO `district` VALUES ('361', '集宁区', '67');
  INSERT INTO `district` VALUES ('362', '卓资县', '67');
  INSERT INTO `district` VALUES ('363', '化德县', '67');
  INSERT INTO `district` VALUES ('364', '商都县', '67');
  INSERT INTO `district` VALUES ('365', '兴和县', '67');
  INSERT INTO `district` VALUES ('366', '凉城县', '67');
  INSERT INTO `district` VALUES ('367', '察哈尔右翼前旗', '67');
  INSERT INTO `district` VALUES ('368', '察哈尔右翼中旗', '67');
  INSERT INTO `district` VALUES ('369', '察哈尔右翼后旗', '67');
  INSERT INTO `district` VALUES ('370', '四子王旗', '67');
  INSERT INTO `district` VALUES ('371', '丰镇市', '67');
  INSERT INTO `district` VALUES ('372', '兴安盟', '67');
  INSERT INTO `district` VALUES ('373', '乌兰浩特市', '67');
  INSERT INTO `district` VALUES ('374', '阿尔山市', '67');
  INSERT INTO `district` VALUES ('375', '科尔沁右翼前旗', '67');
  INSERT INTO `district` VALUES ('376', '科尔沁右翼中旗', '67');
  INSERT INTO `district` VALUES ('377', '扎赉特旗', '67');
  INSERT INTO `district` VALUES ('378', '突泉县', '67');
  INSERT INTO `district` VALUES ('379', '锡林郭勒盟', '67');
  INSERT INTO `district` VALUES ('380', '二连浩特市', '67');
  INSERT INTO `district` VALUES ('381', '锡林浩特市', '67');
  INSERT INTO `district` VALUES ('382', '阿巴嘎旗', '67');
  INSERT INTO `district` VALUES ('383', '苏尼特左旗', '67');
  INSERT INTO `district` VALUES ('384', '苏尼特右旗', '67');
  INSERT INTO `district` VALUES ('385', '东乌珠穆沁旗', '67');
  INSERT INTO `district` VALUES ('386', '西乌珠穆沁旗', '67');
  INSERT INTO `district` VALUES ('387', '太仆寺旗', '67');
  INSERT INTO `district` VALUES ('388', '镶黄旗', '67');
  INSERT INTO `district` VALUES ('389', '正镶白旗', '67');
  INSERT INTO `district` VALUES ('390', '正蓝旗', '67');
  INSERT INTO `district` VALUES ('391', '多伦县', '67');
  INSERT INTO `district` VALUES ('392', '阿拉善盟', '67');
  INSERT INTO `district` VALUES ('393', '阿拉善左旗', '67');
  INSERT INTO `district` VALUES ('394', '阿拉善右旗', '67');
  INSERT INTO `district` VALUES ('395', '额济纳旗', '67');
  INSERT INTO `district` VALUES ('396', '和平区', '68');
  INSERT INTO `district` VALUES ('397', '沈河区', '68');
  INSERT INTO `district` VALUES ('398', '大东区', '68');
  INSERT INTO `district` VALUES ('399', '皇姑区', '68');
  INSERT INTO `district` VALUES ('400', '铁西区', '68');
  INSERT INTO `district` VALUES ('401', '苏家屯区', '68');
  INSERT INTO `district` VALUES ('402', '东陵区', '68');
  INSERT INTO `district` VALUES ('403', '沈北新区', '68');
  INSERT INTO `district` VALUES ('404', '于洪区', '68');
  INSERT INTO `district` VALUES ('405', '辽中县', '68');
  INSERT INTO `district` VALUES ('406', '康平县', '68');
  INSERT INTO `district` VALUES ('407', '法库县', '68');
  INSERT INTO `district` VALUES ('408', '新民市', '68');
  INSERT INTO `district` VALUES ('409', '中山区', '69');
  INSERT INTO `district` VALUES ('410', '西岗区', '69');
  INSERT INTO `district` VALUES ('411', '沙河口区', '69');
  INSERT INTO `district` VALUES ('412', '甘井子区', '69');
  INSERT INTO `district` VALUES ('413', '旅顺口区', '69');
  INSERT INTO `district` VALUES ('414', '金州区', '69');
  INSERT INTO `district` VALUES ('415', '长海县', '69');
  INSERT INTO `district` VALUES ('416', '瓦房店市', '69');
  INSERT INTO `district` VALUES ('417', '普兰店市', '69');
  INSERT INTO `district` VALUES ('418', '庄河市', '69');
  INSERT INTO `district` VALUES ('419', '铁东区', '70');
  INSERT INTO `district` VALUES ('420', '铁西区', '70');
  INSERT INTO `district` VALUES ('421', '立山区', '70');
  INSERT INTO `district` VALUES ('422', '千山区', '70');
  INSERT INTO `district` VALUES ('423', '台安县', '70');
  INSERT INTO `district` VALUES ('424', '岫岩满族自治县', '70');
  INSERT INTO `district` VALUES ('425', '海城市', '70');
  INSERT INTO `district` VALUES ('426', '新抚区', '71');
  INSERT INTO `district` VALUES ('427', '东洲区', '71');
  INSERT INTO `district` VALUES ('428', '望花区', '71');
  INSERT INTO `district` VALUES ('429', '顺城区', '71');
  INSERT INTO `district` VALUES ('430', '抚顺县', '71');
  INSERT INTO `district` VALUES ('431', '新宾满族自治县', '71');
  INSERT INTO `district` VALUES ('432', '清原满族自治县', '71');
  INSERT INTO `district` VALUES ('433', '平山区', '72');
  INSERT INTO `district` VALUES ('434', '溪湖区', '72');
  INSERT INTO `district` VALUES ('435', '明山区', '72');
  INSERT INTO `district` VALUES ('436', '南芬区', '72');
  INSERT INTO `district` VALUES ('437', '本溪满族自治县', '72');
  INSERT INTO `district` VALUES ('438', '桓仁满族自治县', '72');
  INSERT INTO `district` VALUES ('439', '元宝区', '73');
  INSERT INTO `district` VALUES ('440', '振兴区', '73');
  INSERT INTO `district` VALUES ('441', '振安区', '73');
  INSERT INTO `district` VALUES ('442', '宽甸满族自治县', '73');
  INSERT INTO `district` VALUES ('443', '东港市', '73');
  INSERT INTO `district` VALUES ('444', '凤城市', '73');
  INSERT INTO `district` VALUES ('445', '古塔区', '74');
  INSERT INTO `district` VALUES ('446', '凌河区', '74');
  INSERT INTO `district` VALUES ('447', '太和区', '74');
  INSERT INTO `district` VALUES ('448', '黑山县', '74');
  INSERT INTO `district` VALUES ('449', '义　县', '74');
  INSERT INTO `district` VALUES ('450', '凌海市', '74');
  INSERT INTO `district` VALUES ('451', '北镇市', '74');
  INSERT INTO `district` VALUES ('452', '站前区', '75');
  INSERT INTO `district` VALUES ('453', '西市区', '75');
  INSERT INTO `district` VALUES ('454', '鲅鱼圈区', '75');
  INSERT INTO `district` VALUES ('455', '老边区', '75');
  INSERT INTO `district` VALUES ('456', '盖州市', '75');
  INSERT INTO `district` VALUES ('457', '大石桥市', '75');
  INSERT INTO `district` VALUES ('458', '海州区', '76');
  INSERT INTO `district` VALUES ('459', '新邱区', '76');
  INSERT INTO `district` VALUES ('460', '太平区', '76');
  INSERT INTO `district` VALUES ('461', '清河门区', '76');
  INSERT INTO `district` VALUES ('462', '细河区', '76');
  INSERT INTO `district` VALUES ('463', '阜新蒙古族自治县', '76');
  INSERT INTO `district` VALUES ('464', '彰武县', '76');
  INSERT INTO `district` VALUES ('465', '白塔区', '77');
  INSERT INTO `district` VALUES ('466', '文圣区', '77');
  INSERT INTO `district` VALUES ('467', '宏伟区', '77');
  INSERT INTO `district` VALUES ('468', '弓长岭区', '77');
  INSERT INTO `district` VALUES ('469', '太子河区', '77');
  INSERT INTO `district` VALUES ('470', '辽阳县', '77');
  INSERT INTO `district` VALUES ('471', '灯塔市', '77');
  INSERT INTO `district` VALUES ('472', '双台子区', '78');
  INSERT INTO `district` VALUES ('473', '兴隆台区', '78');
  INSERT INTO `district` VALUES ('474', '大洼县', '78');
  INSERT INTO `district` VALUES ('475', '盘山县', '78');
  INSERT INTO `district` VALUES ('476', '银州区', '79');
  INSERT INTO `district` VALUES ('477', '清河区', '79');
  INSERT INTO `district` VALUES ('478', '铁岭县', '79');
  INSERT INTO `district` VALUES ('479', '西丰县', '79');
  INSERT INTO `district` VALUES ('480', '昌图县', '79');
  INSERT INTO `district` VALUES ('481', '调兵山市', '79');
  INSERT INTO `district` VALUES ('482', '开原市', '79');
  INSERT INTO `district` VALUES ('483', '双塔区', '80');
  INSERT INTO `district` VALUES ('484', '龙城区', '80');
  INSERT INTO `district` VALUES ('485', '朝阳县', '80');
  INSERT INTO `district` VALUES ('486', '建平县', '80');
  INSERT INTO `district` VALUES ('487', '喀喇沁左翼蒙古族自治县', '80');
  INSERT INTO `district` VALUES ('488', '北票市', '80');
  INSERT INTO `district` VALUES ('489', '凌源市', '90');
  INSERT INTO `district` VALUES ('490', '连山区', '81');
  INSERT INTO `district` VALUES ('491', '龙港区', '81');
  INSERT INTO `district` VALUES ('492', '南票区', '81');
  INSERT INTO `district` VALUES ('493', '绥中县', '81');
  INSERT INTO `district` VALUES ('494', '建昌县', '81');
  INSERT INTO `district` VALUES ('495', '兴城市', '81');
  INSERT INTO `district` VALUES ('496', '南关区', '82');
  INSERT INTO `district` VALUES ('497', '宽城区', '82');
  INSERT INTO `district` VALUES ('498', '朝阳区', '82');
  INSERT INTO `district` VALUES ('499', '二道区', '82');
  INSERT INTO `district` VALUES ('500', '绿园区', '82');
  INSERT INTO `district` VALUES ('501', '双阳区', '82');
  INSERT INTO `district` VALUES ('502', '农安县', '82');
  INSERT INTO `district` VALUES ('503', '九台市', '82');
  INSERT INTO `district` VALUES ('504', '榆树市', '82');
  INSERT INTO `district` VALUES ('505', '德惠市', '82');
  INSERT INTO `district` VALUES ('506', '昌邑区', '83');
  INSERT INTO `district` VALUES ('507', '龙潭区', '83');
  INSERT INTO `district` VALUES ('508', '船营区', '83');
  INSERT INTO `district` VALUES ('509', '丰满区', '83');
  INSERT INTO `district` VALUES ('510', '永吉县', '83');
  INSERT INTO `district` VALUES ('511', '蛟河市', '83');
  INSERT INTO `district` VALUES ('512', '桦甸市', '83');
  INSERT INTO `district` VALUES ('513', '舒兰市', '83');
  INSERT INTO `district` VALUES ('514', '磐石市', '83');
  INSERT INTO `district` VALUES ('515', '铁西区', '84');
  INSERT INTO `district` VALUES ('516', '铁东区', '84');
  INSERT INTO `district` VALUES ('517', '梨树县', '84');
  INSERT INTO `district` VALUES ('518', '伊通满族自治县', '84');
  INSERT INTO `district` VALUES ('519', '公主岭市', '84');
  INSERT INTO `district` VALUES ('520', '双辽市', '84');
  INSERT INTO `district` VALUES ('521', '龙山区', '85');
  INSERT INTO `district` VALUES ('522', '西安区', '85');
  INSERT INTO `district` VALUES ('523', '东丰县', '85');
  INSERT INTO `district` VALUES ('524', '东辽县', '85');
  INSERT INTO `district` VALUES ('525', '东昌区', '86');
  INSERT INTO `district` VALUES ('526', '二道江区', '86');
  INSERT INTO `district` VALUES ('527', '通化县', '86');
  INSERT INTO `district` VALUES ('528', '辉南县', '86');
  INSERT INTO `district` VALUES ('529', '柳河县', '86');
  INSERT INTO `district` VALUES ('530', '梅河口市', '86');
  INSERT INTO `district` VALUES ('531', '集安市', '86');
  INSERT INTO `district` VALUES ('532', '八道江区', '87');
  INSERT INTO `district` VALUES ('533', '江源区', '87');
  INSERT INTO `district` VALUES ('534', '抚松县', '87');
  INSERT INTO `district` VALUES ('535', '靖宇县', '87');
  INSERT INTO `district` VALUES ('536', '长白朝鲜族自治县', '87');
  INSERT INTO `district` VALUES ('537', '临江市', '87');
  INSERT INTO `district` VALUES ('538', '宁江区', '88');
  INSERT INTO `district` VALUES ('539', '前郭尔罗斯蒙古族自治县', '88');
  INSERT INTO `district` VALUES ('540', '长岭县', '88');
  INSERT INTO `district` VALUES ('541', '乾安县', '88');
  INSERT INTO `district` VALUES ('542', '扶余县', '88');
  INSERT INTO `district` VALUES ('543', '洮北区', '89');
  INSERT INTO `district` VALUES ('544', '镇赉县', '89');
  INSERT INTO `district` VALUES ('545', '通榆县', '89');
  INSERT INTO `district` VALUES ('546', '洮南市', '89');
  INSERT INTO `district` VALUES ('547', '大安市', '89');
  INSERT INTO `district` VALUES ('548', '延吉市', '90');
  INSERT INTO `district` VALUES ('549', '图们市', '90');
  INSERT INTO `district` VALUES ('550', '敦化市', '90');
  INSERT INTO `district` VALUES ('551', '珲春市', '90');
  INSERT INTO `district` VALUES ('552', '龙井市', '90');
  INSERT INTO `district` VALUES ('553', '和龙市', '90');
  INSERT INTO `district` VALUES ('554', '汪清县', '90');
  INSERT INTO `district` VALUES ('555', '安图县', '90');
  INSERT INTO `district` VALUES ('556', '道里区', '91');
  INSERT INTO `district` VALUES ('557', '南岗区', '91');
  INSERT INTO `district` VALUES ('558', '道外区', '91');
  INSERT INTO `district` VALUES ('559', '平房区', '91');
  INSERT INTO `district` VALUES ('560', '松北区', '91');
  INSERT INTO `district` VALUES ('561', '香坊区', '91');
  INSERT INTO `district` VALUES ('562', '呼兰区', '91');
  INSERT INTO `district` VALUES ('563', '阿城区', '91');
  INSERT INTO `district` VALUES ('564', '依兰县', '91');
  INSERT INTO `district` VALUES ('565', '方正县', '91');
  INSERT INTO `district` VALUES ('566', '宾　县', '91');
  INSERT INTO `district` VALUES ('567', '巴彦县', '91');
  INSERT INTO `district` VALUES ('568', '木兰县', '91');
  INSERT INTO `district` VALUES ('569', '通河县', '91');
  INSERT INTO `district` VALUES ('570', '延寿县', '91');
  INSERT INTO `district` VALUES ('571', '双城市', '91');
  INSERT INTO `district` VALUES ('572', '尚志市', '91');
  INSERT INTO `district` VALUES ('573', '五常市', '91');
  INSERT INTO `district` VALUES ('574', '龙沙区', '92');
  INSERT INTO `district` VALUES ('575', '建华区', '92');
  INSERT INTO `district` VALUES ('576', '铁锋区', '92');
  INSERT INTO `district` VALUES ('577', '昂昂溪区', '92');
  INSERT INTO `district` VALUES ('578', '富拉尔基区', '92');
  INSERT INTO `district` VALUES ('579', '碾子山区', '92');
  INSERT INTO `district` VALUES ('580', '梅里斯达斡尔族区', '92');
  INSERT INTO `district` VALUES ('581', '龙江县', '92');
  INSERT INTO `district` VALUES ('582', '依安县', '92');
  INSERT INTO `district` VALUES ('583', '泰来县', '92');
  INSERT INTO `district` VALUES ('584', '甘南县', '92');
  INSERT INTO `district` VALUES ('585', '富裕县', '92');
  INSERT INTO `district` VALUES ('586', '克山县', '92');
  INSERT INTO `district` VALUES ('587', '克东县', '92');
  INSERT INTO `district` VALUES ('588', '拜泉县', '92');
  INSERT INTO `district` VALUES ('589', '讷河市', '92');
  INSERT INTO `district` VALUES ('590', '鸡冠区', '93');
  INSERT INTO `district` VALUES ('591', '恒山区', '93');
  INSERT INTO `district` VALUES ('592', '滴道区', '93');
  INSERT INTO `district` VALUES ('593', '梨树区', '93');
  INSERT INTO `district` VALUES ('594', '城子河区', '93');
  INSERT INTO `district` VALUES ('595', '麻山区', '93');
  INSERT INTO `district` VALUES ('596', '鸡东县', '93');
  INSERT INTO `district` VALUES ('597', '虎林市', '93');
  INSERT INTO `district` VALUES ('598', '密山市', '93');
  INSERT INTO `district` VALUES ('599', '向阳区', '94');
  INSERT INTO `district` VALUES ('600', '工农区', '94');
  INSERT INTO `district` VALUES ('601', '南山区', '94');
  INSERT INTO `district` VALUES ('602', '兴安区', '94');
  INSERT INTO `district` VALUES ('603', '东山区', '94');
  INSERT INTO `district` VALUES ('604', '兴山区', '94');
  INSERT INTO `district` VALUES ('605', '萝北县', '94');
  INSERT INTO `district` VALUES ('606', '绥滨县', '94');
  INSERT INTO `district` VALUES ('607', '尖山区', '95');
  INSERT INTO `district` VALUES ('608', '岭东区', '95');
  INSERT INTO `district` VALUES ('609', '四方台区', '95');
  INSERT INTO `district` VALUES ('610', '宝山区', '95');
  INSERT INTO `district` VALUES ('611', '集贤县', '95');
  INSERT INTO `district` VALUES ('612', '友谊县', '95');
  INSERT INTO `district` VALUES ('613', '宝清县', '95');
  INSERT INTO `district` VALUES ('614', '饶河县', '95');
  INSERT INTO `district` VALUES ('615', '萨尔图区', '96');
  INSERT INTO `district` VALUES ('616', '龙凤区', '96');
  INSERT INTO `district` VALUES ('617', '让胡路区', '96');
  INSERT INTO `district` VALUES ('618', '红岗区', '96');
  INSERT INTO `district` VALUES ('619', '大同区', '96');
  INSERT INTO `district` VALUES ('620', '肇州县', '96');
  INSERT INTO `district` VALUES ('621', '肇源县', '96');
  INSERT INTO `district` VALUES ('622', '林甸县', '96');
  INSERT INTO `district` VALUES ('623', '杜尔伯特蒙古族自治县', '96');
  INSERT INTO `district` VALUES ('624', '伊春区', '97');
  INSERT INTO `district` VALUES ('625', '南岔区', '97');
  INSERT INTO `district` VALUES ('626', '友好区', '97');
  INSERT INTO `district` VALUES ('627', '西林区', '97');
  INSERT INTO `district` VALUES ('628', '翠峦区', '97');
  INSERT INTO `district` VALUES ('629', '新青区', '97');
  INSERT INTO `district` VALUES ('630', '美溪区', '97');
  INSERT INTO `district` VALUES ('631', '金山屯区', '97');
  INSERT INTO `district` VALUES ('632', '五营区', '97');
  INSERT INTO `district` VALUES ('633', '乌马河区', '97');
  INSERT INTO `district` VALUES ('634', '汤旺河区', '97');
  INSERT INTO `district` VALUES ('635', '带岭区', '97');
  INSERT INTO `district` VALUES ('636', '乌伊岭区', '97');
  INSERT INTO `district` VALUES ('637', '红星区', '97');
  INSERT INTO `district` VALUES ('638', '上甘岭区', '97');
  INSERT INTO `district` VALUES ('639', '嘉荫县', '97');
  INSERT INTO `district` VALUES ('640', '铁力市', '97');
  INSERT INTO `district` VALUES ('641', '向阳区', '98');
  INSERT INTO `district` VALUES ('642', '前进区', '98');
  INSERT INTO `district` VALUES ('643', '东风区', '98');
  INSERT INTO `district` VALUES ('644', '郊　区', '98');
  INSERT INTO `district` VALUES ('645', '桦南县', '98');
  INSERT INTO `district` VALUES ('646', '桦川县', '98');
  INSERT INTO `district` VALUES ('647', '汤原县', '98');
  INSERT INTO `district` VALUES ('648', '抚远县', '98');
  INSERT INTO `district` VALUES ('649', '同江市', '98');
  INSERT INTO `district` VALUES ('650', '富锦市', '98');
  INSERT INTO `district` VALUES ('651', '新兴区', '99');
  INSERT INTO `district` VALUES ('652', '桃山区', '99');
  INSERT INTO `district` VALUES ('653', '茄子河区', '99');
  INSERT INTO `district` VALUES ('654', '勃利县', '99');
  INSERT INTO `district` VALUES ('655', '东安区', '100');
  INSERT INTO `district` VALUES ('656', '阳明区', '100');
  INSERT INTO `district` VALUES ('657', '爱民区', '100');
  INSERT INTO `district` VALUES ('658', '西安区', '100');
  INSERT INTO `district` VALUES ('659', '东宁县', '100');
  INSERT INTO `district` VALUES ('660', '林口县', '100');
  INSERT INTO `district` VALUES ('661', '绥芬河市', '100');
  INSERT INTO `district` VALUES ('662', '海林市', '100');
  INSERT INTO `district` VALUES ('663', '宁安市', '100');
  INSERT INTO `district` VALUES ('664', '穆棱市', '100');
  INSERT INTO `district` VALUES ('665', '爱辉区', '101');
  INSERT INTO `district` VALUES ('666', '嫩江县', '101');
  INSERT INTO `district` VALUES ('667', '逊克县', '101');
  INSERT INTO `district` VALUES ('668', '孙吴县', '101');
  INSERT INTO `district` VALUES ('669', '北安市', '101');
  INSERT INTO `district` VALUES ('670', '五大连池市', '101');
  INSERT INTO `district` VALUES ('671', '北林区', '102');
  INSERT INTO `district` VALUES ('672', '望奎县', '102');
  INSERT INTO `district` VALUES ('673', '兰西县', '102');
  INSERT INTO `district` VALUES ('674', '青冈县', '102');
  INSERT INTO `district` VALUES ('675', '庆安县', '102');
  INSERT INTO `district` VALUES ('676', '明水县', '102');
  INSERT INTO `district` VALUES ('677', '绥棱县', '102');
  INSERT INTO `district` VALUES ('678', '安达市', '102');
  INSERT INTO `district` VALUES ('679', '肇东市', '102');
  INSERT INTO `district` VALUES ('680', '海伦市', '102');
  INSERT INTO `district` VALUES ('681', '大兴安岭地区', '102');
  INSERT INTO `district` VALUES ('682', '呼玛县', '102');
  INSERT INTO `district` VALUES ('683', '塔河县', '102');
  INSERT INTO `district` VALUES ('684', '漠河县', '102');
  INSERT INTO `district` VALUES ('685', '黄浦区', '103');
  INSERT INTO `district` VALUES ('686', '卢湾区', '103');
  INSERT INTO `district` VALUES ('687', '徐汇区', '103');
  INSERT INTO `district` VALUES ('688', '长宁区', '103');
  INSERT INTO `district` VALUES ('689', '静安区', '103');
  INSERT INTO `district` VALUES ('690', '普陀区', '103');
  INSERT INTO `district` VALUES ('691', '闸北区', '103');
  INSERT INTO `district` VALUES ('692', '虹口区', '103');
  INSERT INTO `district` VALUES ('693', '杨浦区', '103');
  INSERT INTO `district` VALUES ('694', '闵行区', '103');
  INSERT INTO `district` VALUES ('695', '宝山区', '103');
  INSERT INTO `district` VALUES ('696', '嘉定区', '103');
  INSERT INTO `district` VALUES ('697', '浦东新区', '103');
  INSERT INTO `district` VALUES ('698', '金山区', '103');
  INSERT INTO `district` VALUES ('699', '松江区', '103');
  INSERT INTO `district` VALUES ('700', '青浦区', '103');
  INSERT INTO `district` VALUES ('701', '南汇区', '103');
  INSERT INTO `district` VALUES ('702', '奉贤区', '103');
  INSERT INTO `district` VALUES ('703', '崇明县', '103');
  INSERT INTO `district` VALUES ('704', '玄武区', '104');
  INSERT INTO `district` VALUES ('705', '白下区', '104');
  INSERT INTO `district` VALUES ('706', '秦淮区', '104');
  INSERT INTO `district` VALUES ('707', '建邺区', '104');
  INSERT INTO `district` VALUES ('708', '鼓楼区', '104');
  INSERT INTO `district` VALUES ('709', '下关区', '104');
  INSERT INTO `district` VALUES ('710', '浦口区', '104');
  INSERT INTO `district` VALUES ('711', '栖霞区', '104');
  INSERT INTO `district` VALUES ('712', '雨花台区', '104');
  INSERT INTO `district` VALUES ('713', '江宁区', '104');
  INSERT INTO `district` VALUES ('714', '六合区', '104');
  INSERT INTO `district` VALUES ('715', '溧水县', '104');
  INSERT INTO `district` VALUES ('716', '高淳县', '104');
  INSERT INTO `district` VALUES ('717', '崇安区', '105');
  INSERT INTO `district` VALUES ('718', '南长区', '105');
  INSERT INTO `district` VALUES ('719', '北塘区', '105');
  INSERT INTO `district` VALUES ('720', '锡山区', '105');
  INSERT INTO `district` VALUES ('721', '惠山区', '105');
  INSERT INTO `district` VALUES ('722', '滨湖区', '105');
  INSERT INTO `district` VALUES ('723', '江阴市', '105');
  INSERT INTO `district` VALUES ('724', '宜兴市', '105');
  INSERT INTO `district` VALUES ('725', '鼓楼区', '106');
  INSERT INTO `district` VALUES ('726', '云龙区', '106');
  INSERT INTO `district` VALUES ('727', '九里区', '106');
  INSERT INTO `district` VALUES ('728', '贾汪区', '106');
  INSERT INTO `district` VALUES ('729', '泉山区', '106');
  INSERT INTO `district` VALUES ('730', '丰　县', '106');
  INSERT INTO `district` VALUES ('731', '沛　县', '106');
  INSERT INTO `district` VALUES ('732', '铜山县', '106');
  INSERT INTO `district` VALUES ('733', '睢宁县', '106');
  INSERT INTO `district` VALUES ('734', '新沂市', '106');
  INSERT INTO `district` VALUES ('735', '邳州市', '106');
  INSERT INTO `district` VALUES ('736', '天宁区', '107');
  INSERT INTO `district` VALUES ('737', '钟楼区', '107');
  INSERT INTO `district` VALUES ('738', '戚墅堰区', '107');
  INSERT INTO `district` VALUES ('739', '新北区', '107');
  INSERT INTO `district` VALUES ('740', '武进区', '107');
  INSERT INTO `district` VALUES ('741', '溧阳市', '107');
  INSERT INTO `district` VALUES ('742', '金坛市', '107');
  INSERT INTO `district` VALUES ('743', '沧浪区', '108');
  INSERT INTO `district` VALUES ('744', '平江区', '108');
  INSERT INTO `district` VALUES ('745', '金阊区', '108');
  INSERT INTO `district` VALUES ('746', '虎丘区', '108');
  INSERT INTO `district` VALUES ('747', '吴中区', '108');
  INSERT INTO `district` VALUES ('748', '相城区', '108');
  INSERT INTO `district` VALUES ('749', '常熟市', '108');
  INSERT INTO `district` VALUES ('750', '张家港市', '108');
  INSERT INTO `district` VALUES ('751', '昆山市', '108');
  INSERT INTO `district` VALUES ('752', '吴江市', '108');
  INSERT INTO `district` VALUES ('753', '太仓市', '108');
  INSERT INTO `district` VALUES ('754', '崇川区', '109');
  INSERT INTO `district` VALUES ('755', '港闸区', '109');
  INSERT INTO `district` VALUES ('756', '海安县', '109');
  INSERT INTO `district` VALUES ('757', '如东县', '109');
  INSERT INTO `district` VALUES ('758', '启东市', '109');
  INSERT INTO `district` VALUES ('759', '如皋市', '109');
  INSERT INTO `district` VALUES ('760', '通州市', '109');
  INSERT INTO `district` VALUES ('761', '海门市', '109');
  INSERT INTO `district` VALUES ('762', '连云区', '110');
  INSERT INTO `district` VALUES ('763', '新浦区', '110');
  INSERT INTO `district` VALUES ('764', '海州区', '110');
  INSERT INTO `district` VALUES ('765', '赣榆县', '110');
  INSERT INTO `district` VALUES ('766', '东海县', '110');
  INSERT INTO `district` VALUES ('767', '灌云县', '110');
  INSERT INTO `district` VALUES ('768', '灌南县', '110');
  INSERT INTO `district` VALUES ('769', '清河区', '111');
  INSERT INTO `district` VALUES ('770', '楚州区', '111');
  INSERT INTO `district` VALUES ('771', '淮阴区', '111');
  INSERT INTO `district` VALUES ('772', '清浦区', '111');
  INSERT INTO `district` VALUES ('773', '涟水县', '111');
  INSERT INTO `district` VALUES ('774', '洪泽县', '111');
  INSERT INTO `district` VALUES ('775', '盱眙县', '111');
  INSERT INTO `district` VALUES ('776', '金湖县', '111');
  INSERT INTO `district` VALUES ('777', '亭湖区', '112');
  INSERT INTO `district` VALUES ('778', '盐都区', '112');
  INSERT INTO `district` VALUES ('779', '响水县', '112');
  INSERT INTO `district` VALUES ('780', '滨海县', '112');
  INSERT INTO `district` VALUES ('781', '阜宁县', '112');
  INSERT INTO `district` VALUES ('782', '射阳县', '112');
  INSERT INTO `district` VALUES ('783', '建湖县', '112');
  INSERT INTO `district` VALUES ('784', '东台市', '112');
  INSERT INTO `district` VALUES ('785', '大丰市', '112');
  INSERT INTO `district` VALUES ('786', '广陵区', '113');
  INSERT INTO `district` VALUES ('787', '邗江区', '113');
  INSERT INTO `district` VALUES ('788', '维扬区', '113');
  INSERT INTO `district` VALUES ('789', '宝应县', '113');
  INSERT INTO `district` VALUES ('790', '仪征市', '113');
  INSERT INTO `district` VALUES ('791', '高邮市', '113');
  INSERT INTO `district` VALUES ('792', '江都市', '113');
  INSERT INTO `district` VALUES ('793', '京口区', '114');
  INSERT INTO `district` VALUES ('794', '润州区', '114');
  INSERT INTO `district` VALUES ('795', '丹徒区', '114');
  INSERT INTO `district` VALUES ('796', '丹阳市', '114');
  INSERT INTO `district` VALUES ('797', '扬中市', '114');
  INSERT INTO `district` VALUES ('798', '句容市', '114');
  INSERT INTO `district` VALUES ('799', '海陵区', '115');
  INSERT INTO `district` VALUES ('800', '高港区', '115');
  INSERT INTO `district` VALUES ('801', '兴化市', '115');
  INSERT INTO `district` VALUES ('802', '靖江市', '115');
  INSERT INTO `district` VALUES ('803', '泰兴市', '115');
  INSERT INTO `district` VALUES ('804', '姜堰市', '115');
  INSERT INTO `district` VALUES ('805', '宿城区', '116');
  INSERT INTO `district` VALUES ('806', '宿豫区', '116');
  INSERT INTO `district` VALUES ('807', '沭阳县', '116');
  INSERT INTO `district` VALUES ('808', '泗阳县', '116');
  INSERT INTO `district` VALUES ('809', '泗洪县', '116');
  INSERT INTO `district` VALUES ('810', '上城区', '117');
  INSERT INTO `district` VALUES ('811', '下城区', '117');
  INSERT INTO `district` VALUES ('812', '江干区', '117');
  INSERT INTO `district` VALUES ('813', '拱墅区', '117');
  INSERT INTO `district` VALUES ('814', '西湖区', '117');
  INSERT INTO `district` VALUES ('815', '滨江区', '117');
  INSERT INTO `district` VALUES ('816', '萧山区', '117');
  INSERT INTO `district` VALUES ('817', '余杭区', '117');
  INSERT INTO `district` VALUES ('818', '桐庐县', '117');
  INSERT INTO `district` VALUES ('819', '淳安县', '117');
  INSERT INTO `district` VALUES ('820', '建德市', '117');
  INSERT INTO `district` VALUES ('821', '富阳市', '117');
  INSERT INTO `district` VALUES ('822', '临安市', '117');
  INSERT INTO `district` VALUES ('823', '海曙区', '118');
  INSERT INTO `district` VALUES ('824', '江东区', '118');
  INSERT INTO `district` VALUES ('825', '江北区', '118');
  INSERT INTO `district` VALUES ('826', '北仑区', '118');
  INSERT INTO `district` VALUES ('827', '镇海区', '118');
  INSERT INTO `district` VALUES ('828', '鄞州区', '118');
  INSERT INTO `district` VALUES ('829', '象山县', '118');
  INSERT INTO `district` VALUES ('830', '宁海县', '118');
  INSERT INTO `district` VALUES ('831', '余姚市', '118');
  INSERT INTO `district` VALUES ('832', '慈溪市', '118');
  INSERT INTO `district` VALUES ('833', '奉化市', '118');
  INSERT INTO `district` VALUES ('834', '鹿城区', '119');
  INSERT INTO `district` VALUES ('835', '龙湾区', '119');
  INSERT INTO `district` VALUES ('836', '瓯海区', '119');
  INSERT INTO `district` VALUES ('837', '洞头县', '119');
  INSERT INTO `district` VALUES ('838', '永嘉县', '119');
  INSERT INTO `district` VALUES ('839', '平阳县', '119');
  INSERT INTO `district` VALUES ('840', '苍南县', '119');
  INSERT INTO `district` VALUES ('841', '文成县', '119');
  INSERT INTO `district` VALUES ('842', '泰顺县', '119');
  INSERT INTO `district` VALUES ('843', '瑞安市', '119');
  INSERT INTO `district` VALUES ('844', '乐清市', '119');
  INSERT INTO `district` VALUES ('845', '南湖区', '120');
  INSERT INTO `district` VALUES ('846', '秀洲区', '120');
  INSERT INTO `district` VALUES ('847', '嘉善县', '120');
  INSERT INTO `district` VALUES ('848', '海盐县', '120');
  INSERT INTO `district` VALUES ('849', '海宁市', '120');
  INSERT INTO `district` VALUES ('850', '平湖市', '120');
  INSERT INTO `district` VALUES ('851', '桐乡市', '120');
  INSERT INTO `district` VALUES ('852', '吴兴区', '121');
  INSERT INTO `district` VALUES ('853', '南浔区', '121');
  INSERT INTO `district` VALUES ('854', '德清县', '121');
  INSERT INTO `district` VALUES ('855', '长兴县', '121');
  INSERT INTO `district` VALUES ('856', '安吉县', '121');
  INSERT INTO `district` VALUES ('857', '越城区', '122');
  INSERT INTO `district` VALUES ('858', '绍兴县', '122');
  INSERT INTO `district` VALUES ('859', '新昌县', '122');
  INSERT INTO `district` VALUES ('860', '诸暨市', '122');
  INSERT INTO `district` VALUES ('861', '上虞市', '122');
  INSERT INTO `district` VALUES ('862', '嵊州市', '122');
  INSERT INTO `district` VALUES ('863', '婺城区', '123');
  INSERT INTO `district` VALUES ('864', '金东区', '123');
  INSERT INTO `district` VALUES ('865', '武义县', '123');
  INSERT INTO `district` VALUES ('866', '浦江县', '123');
  INSERT INTO `district` VALUES ('867', '磐安县', '123');
  INSERT INTO `district` VALUES ('868', '兰溪市', '123');
  INSERT INTO `district` VALUES ('869', '义乌市', '123');
  INSERT INTO `district` VALUES ('870', '东阳市', '123');
  INSERT INTO `district` VALUES ('871', '永康市', '123');
  INSERT INTO `district` VALUES ('872', '柯城区', '124');
  INSERT INTO `district` VALUES ('873', '衢江区', '124');
  INSERT INTO `district` VALUES ('874', '常山县', '124');
  INSERT INTO `district` VALUES ('875', '开化县', '124');
  INSERT INTO `district` VALUES ('876', '龙游县', '124');
  INSERT INTO `district` VALUES ('877', '江山市', '124');
  INSERT INTO `district` VALUES ('878', '定海区', '125');
  INSERT INTO `district` VALUES ('879', '普陀区', '125');
  INSERT INTO `district` VALUES ('880', '岱山县', '125');
  INSERT INTO `district` VALUES ('881', '嵊泗县', '125');
  INSERT INTO `district` VALUES ('882', '椒江区', '126');
  INSERT INTO `district` VALUES ('883', '黄岩区', '126');
  INSERT INTO `district` VALUES ('884', '路桥区', '126');
  INSERT INTO `district` VALUES ('885', '玉环县', '126');
  INSERT INTO `district` VALUES ('886', '三门县', '126');
  INSERT INTO `district` VALUES ('887', '天台县', '126');
  INSERT INTO `district` VALUES ('888', '仙居县', '126');
  INSERT INTO `district` VALUES ('889', '温岭市', '126');
  INSERT INTO `district` VALUES ('890', '临海市', '126');
  INSERT INTO `district` VALUES ('891', '莲都区', '127');
  INSERT INTO `district` VALUES ('892', '青田县', '127');
  INSERT INTO `district` VALUES ('893', '缙云县', '127');
  INSERT INTO `district` VALUES ('894', '遂昌县', '127');
  INSERT INTO `district` VALUES ('895', '松阳县', '127');
  INSERT INTO `district` VALUES ('896', '云和县', '127');
  INSERT INTO `district` VALUES ('897', '庆元县', '127');
  INSERT INTO `district` VALUES ('898', '景宁畲族自治县', '127');
  INSERT INTO `district` VALUES ('899', '龙泉市', '127');
  INSERT INTO `district` VALUES ('900', '瑶海区', '128');
  INSERT INTO `district` VALUES ('901', '庐阳区', '128');
  INSERT INTO `district` VALUES ('902', '蜀山区', '128');
  INSERT INTO `district` VALUES ('903', '包河区', '128');
  INSERT INTO `district` VALUES ('904', '长丰县', '128');
  INSERT INTO `district` VALUES ('905', '肥东县', '128');
  INSERT INTO `district` VALUES ('906', '肥西县', '128');
  INSERT INTO `district` VALUES ('907', '镜湖区', '129');
  INSERT INTO `district` VALUES ('908', '弋江区', '129');
  INSERT INTO `district` VALUES ('909', '鸠江区', '129');
  INSERT INTO `district` VALUES ('910', '三山区', '129');
  INSERT INTO `district` VALUES ('911', '芜湖县', '129');
  INSERT INTO `district` VALUES ('912', '繁昌县', '129');
  INSERT INTO `district` VALUES ('913', '南陵县', '129');
  INSERT INTO `district` VALUES ('914', '龙子湖区', '130');
  INSERT INTO `district` VALUES ('915', '蚌山区', '130');
  INSERT INTO `district` VALUES ('916', '禹会区', '130');
  INSERT INTO `district` VALUES ('917', '淮上区', '130');
  INSERT INTO `district` VALUES ('918', '怀远县', '130');
  INSERT INTO `district` VALUES ('919', '五河县', '130');
  INSERT INTO `district` VALUES ('920', '固镇县', '130');
  INSERT INTO `district` VALUES ('921', '大通区', '131');
  INSERT INTO `district` VALUES ('922', '田家庵区', '131');
  INSERT INTO `district` VALUES ('923', '谢家集区', '131');
  INSERT INTO `district` VALUES ('924', '八公山区', '131');
  INSERT INTO `district` VALUES ('925', '潘集区', '131');
  INSERT INTO `district` VALUES ('926', '凤台县', '131');
  INSERT INTO `district` VALUES ('927', '金家庄区', '132');
  INSERT INTO `district` VALUES ('928', '花山区', '132');
  INSERT INTO `district` VALUES ('929', '雨山区', '132');
  INSERT INTO `district` VALUES ('930', '当涂县', '132');
  INSERT INTO `district` VALUES ('931', '杜集区', '133');
  INSERT INTO `district` VALUES ('932', '相山区', '133');
  INSERT INTO `district` VALUES ('933', '烈山区', '133');
  INSERT INTO `district` VALUES ('934', '濉溪县', '133');
  INSERT INTO `district` VALUES ('935', '铜官山区', '134');
  INSERT INTO `district` VALUES ('936', '狮子山区', '134');
  INSERT INTO `district` VALUES ('937', '郊　区', '134');
  INSERT INTO `district` VALUES ('938', '铜陵县', '134');
  INSERT INTO `district` VALUES ('939', '迎江区', '135');
  INSERT INTO `district` VALUES ('940', '大观区', '135');
  INSERT INTO `district` VALUES ('941', '宜秀区', '135');
  INSERT INTO `district` VALUES ('942', '怀宁县', '135');
  INSERT INTO `district` VALUES ('943', '枞阳县', '135');
  INSERT INTO `district` VALUES ('944', '潜山县', '135');
  INSERT INTO `district` VALUES ('945', '太湖县', '135');
  INSERT INTO `district` VALUES ('946', '宿松县', '135');
  INSERT INTO `district` VALUES ('947', '望江县', '135');
  INSERT INTO `district` VALUES ('948', '岳西县', '135');
  INSERT INTO `district` VALUES ('949', '桐城市', '135');
  INSERT INTO `district` VALUES ('950', '屯溪区', '136');
  INSERT INTO `district` VALUES ('951', '黄山区', '136');
  INSERT INTO `district` VALUES ('952', '徽州区', '136');
  INSERT INTO `district` VALUES ('953', '歙　县', '136');
  INSERT INTO `district` VALUES ('954', '休宁县', '136');
  INSERT INTO `district` VALUES ('955', '黟　县', '136');
  INSERT INTO `district` VALUES ('956', '祁门县', '136');
  INSERT INTO `district` VALUES ('957', '琅琊区', '137');
  INSERT INTO `district` VALUES ('958', '南谯区', '137');
  INSERT INTO `district` VALUES ('959', '来安县', '137');
  INSERT INTO `district` VALUES ('960', '全椒县', '137');
  INSERT INTO `district` VALUES ('961', '定远县', '137');
  INSERT INTO `district` VALUES ('962', '凤阳县', '137');
  INSERT INTO `district` VALUES ('963', '天长市', '137');
  INSERT INTO `district` VALUES ('964', '明光市', '137');
  INSERT INTO `district` VALUES ('965', '颍州区', '138');
  INSERT INTO `district` VALUES ('966', '颍东区', '138');
  INSERT INTO `district` VALUES ('967', '颍泉区', '138');
  INSERT INTO `district` VALUES ('968', '临泉县', '138');
  INSERT INTO `district` VALUES ('969', '太和县', '138');
  INSERT INTO `district` VALUES ('970', '阜南县', '138');
  INSERT INTO `district` VALUES ('971', '颍上县', '138');
  INSERT INTO `district` VALUES ('972', '界首市', '138');
  INSERT INTO `district` VALUES ('973', '俑桥区', '139');
  INSERT INTO `district` VALUES ('974', '砀山县', '139');
  INSERT INTO `district` VALUES ('975', '萧　县', '139');
  INSERT INTO `district` VALUES ('976', '灵璧县', '139');
  INSERT INTO `district` VALUES ('977', '泗　县', '139');
  INSERT INTO `district` VALUES ('978', '居巢区', '140');
  INSERT INTO `district` VALUES ('979', '庐江县', '140');
  INSERT INTO `district` VALUES ('980', '无为县', '140');
  INSERT INTO `district` VALUES ('981', '含山县', '140');
  INSERT INTO `district` VALUES ('982', '和　县', '140');
  INSERT INTO `district` VALUES ('983', '金安区', '141');
  INSERT INTO `district` VALUES ('984', '裕安区', '141');
  INSERT INTO `district` VALUES ('985', '寿　县', '141');
  INSERT INTO `district` VALUES ('986', '霍邱县', '141');
  INSERT INTO `district` VALUES ('987', '舒城县', '141');
  INSERT INTO `district` VALUES ('988', '金寨县', '141');
  INSERT INTO `district` VALUES ('989', '霍山县', '141');
  INSERT INTO `district` VALUES ('990', '谯城区', '142');
  INSERT INTO `district` VALUES ('991', '涡阳县', '142');
  INSERT INTO `district` VALUES ('992', '蒙城县', '142');
  INSERT INTO `district` VALUES ('993', '利辛县', '142');
  INSERT INTO `district` VALUES ('994', '贵池区', '143');
  INSERT INTO `district` VALUES ('995', '东至县', '143');
  INSERT INTO `district` VALUES ('996', '石台县', '143');
  INSERT INTO `district` VALUES ('997', '青阳县', '143');
  INSERT INTO `district` VALUES ('998', '宣州区', '144');
  INSERT INTO `district` VALUES ('999', '郎溪县', '144');
  INSERT INTO `district` VALUES ('1000', '广德县', '144');
  INSERT INTO `district` VALUES ('1001', '泾　县', '144');
  INSERT INTO `district` VALUES ('1002', '绩溪县', '144');
  INSERT INTO `district` VALUES ('1003', '旌德县', '144');
  INSERT INTO `district` VALUES ('1004', '宁国市', '144');
  INSERT INTO `district` VALUES ('1005', '鼓楼区', '145');
  INSERT INTO `district` VALUES ('1006', '台江区', '145');
  INSERT INTO `district` VALUES ('1007', '仓山区', '145');
  INSERT INTO `district` VALUES ('1008', '马尾区', '145');
  INSERT INTO `district` VALUES ('1009', '晋安区', '145');
  INSERT INTO `district` VALUES ('1010', '闽侯县', '145');
  INSERT INTO `district` VALUES ('1011', '连江县', '145');
  INSERT INTO `district` VALUES ('1012', '罗源县', '145');
  INSERT INTO `district` VALUES ('1013', '闽清县', '145');
  INSERT INTO `district` VALUES ('1014', '永泰县', '145');
  INSERT INTO `district` VALUES ('1015', '平潭县', '145');
  INSERT INTO `district` VALUES ('1016', '福清市', '145');
  INSERT INTO `district` VALUES ('1017', '长乐市', '145');
  INSERT INTO `district` VALUES ('1018', '思明区', '146');
  INSERT INTO `district` VALUES ('1019', '海沧区', '146');
  INSERT INTO `district` VALUES ('1020', '湖里区', '146');
  INSERT INTO `district` VALUES ('1021', '集美区', '146');
  INSERT INTO `district` VALUES ('1022', '同安区', '146');
  INSERT INTO `district` VALUES ('1023', '翔安区', '146');
  INSERT INTO `district` VALUES ('1024', '城厢区', '147');
  INSERT INTO `district` VALUES ('1025', '涵江区', '147');
  INSERT INTO `district` VALUES ('1026', '荔城区', '147');
  INSERT INTO `district` VALUES ('1027', '秀屿区', '147');
  INSERT INTO `district` VALUES ('1028', '仙游县', '147');
  INSERT INTO `district` VALUES ('1029', '梅列区', '148');
  INSERT INTO `district` VALUES ('1030', '三元区', '148');
  INSERT INTO `district` VALUES ('1031', '明溪县', '148');
  INSERT INTO `district` VALUES ('1032', '清流县', '148');
  INSERT INTO `district` VALUES ('1033', '宁化县', '148');
  INSERT INTO `district` VALUES ('1034', '大田县', '148');
  INSERT INTO `district` VALUES ('1035', '尤溪县', '148');
  INSERT INTO `district` VALUES ('1036', '沙　县', '148');
  INSERT INTO `district` VALUES ('1037', '将乐县', '148');
  INSERT INTO `district` VALUES ('1038', '泰宁县', '148');
  INSERT INTO `district` VALUES ('1039', '建宁县', '148');
  INSERT INTO `district` VALUES ('1040', '永安市', '148');
  INSERT INTO `district` VALUES ('1041', '鲤城区', '149');
  INSERT INTO `district` VALUES ('1042', '丰泽区', '149');
  INSERT INTO `district` VALUES ('1043', '洛江区', '149');
  INSERT INTO `district` VALUES ('1044', '泉港区', '149');
  INSERT INTO `district` VALUES ('1045', '惠安县', '149');
  INSERT INTO `district` VALUES ('1046', '安溪县', '149');
  INSERT INTO `district` VALUES ('1047', '永春县', '149');
  INSERT INTO `district` VALUES ('1048', '德化县', '149');
  INSERT INTO `district` VALUES ('1049', '金门县', '149');
  INSERT INTO `district` VALUES ('1050', '石狮市', '149');
  INSERT INTO `district` VALUES ('1051', '晋江市', '149');
  INSERT INTO `district` VALUES ('1052', '南安市', '149');
  INSERT INTO `district` VALUES ('1053', '芗城区', '150');
  INSERT INTO `district` VALUES ('1054', '龙文区', '150');
  INSERT INTO `district` VALUES ('1055', '云霄县', '150');
  INSERT INTO `district` VALUES ('1056', '漳浦县', '150');
  INSERT INTO `district` VALUES ('1057', '诏安县', '150');
  INSERT INTO `district` VALUES ('1058', '长泰县', '150');
  INSERT INTO `district` VALUES ('1059', '东山县', '150');
  INSERT INTO `district` VALUES ('1060', '南靖县', '150');
  INSERT INTO `district` VALUES ('1061', '平和县', '150');
  INSERT INTO `district` VALUES ('1062', '华安县', '150');
  INSERT INTO `district` VALUES ('1063', '龙海市', '150');
  INSERT INTO `district` VALUES ('1064', '延平区', '151');
  INSERT INTO `district` VALUES ('1065', '顺昌县', '151');
  INSERT INTO `district` VALUES ('1066', '浦城县', '151');
  INSERT INTO `district` VALUES ('1067', '光泽县', '151');
  INSERT INTO `district` VALUES ('1068', '松溪县', '151');
  INSERT INTO `district` VALUES ('1069', '政和县', '151');
  INSERT INTO `district` VALUES ('1070', '邵武市', '151');
  INSERT INTO `district` VALUES ('1071', '武夷山市', '151');
  INSERT INTO `district` VALUES ('1072', '建瓯市', '151');
  INSERT INTO `district` VALUES ('1073', '建阳市', '151');
  INSERT INTO `district` VALUES ('1074', '新罗区', '152');
  INSERT INTO `district` VALUES ('1075', '长汀县', '152');
  INSERT INTO `district` VALUES ('1076', '永定县', '152');
  INSERT INTO `district` VALUES ('1077', '上杭县', '152');
  INSERT INTO `district` VALUES ('1078', '武平县', '152');
  INSERT INTO `district` VALUES ('1079', '连城县', '152');
  INSERT INTO `district` VALUES ('1080', '漳平市', '152');
  INSERT INTO `district` VALUES ('1081', '蕉城区', '153');
  INSERT INTO `district` VALUES ('1082', '霞浦县', '153');
  INSERT INTO `district` VALUES ('1083', '古田县', '153');
  INSERT INTO `district` VALUES ('1084', '屏南县', '153');
  INSERT INTO `district` VALUES ('1085', '寿宁县', '153');
  INSERT INTO `district` VALUES ('1086', '周宁县', '153');
  INSERT INTO `district` VALUES ('1087', '柘荣县', '153');
  INSERT INTO `district` VALUES ('1088', '福安市', '153');
  INSERT INTO `district` VALUES ('1089', '福鼎市', '153');
  INSERT INTO `district` VALUES ('1090', '东湖区', '154');
  INSERT INTO `district` VALUES ('1091', '西湖区', '154');
  INSERT INTO `district` VALUES ('1092', '青云谱区', '154');
  INSERT INTO `district` VALUES ('1093', '湾里区', '154');
  INSERT INTO `district` VALUES ('1094', '青山湖区', '154');
  INSERT INTO `district` VALUES ('1095', '南昌县', '154');
  INSERT INTO `district` VALUES ('1096', '新建县', '154');
  INSERT INTO `district` VALUES ('1097', '安义县', '154');
  INSERT INTO `district` VALUES ('1098', '进贤县', '154');
  INSERT INTO `district` VALUES ('1099', '昌江区', '155');
  INSERT INTO `district` VALUES ('1100', '珠山区', '155');
  INSERT INTO `district` VALUES ('1101', '浮梁县', '155');
  INSERT INTO `district` VALUES ('1102', '乐平市', '155');
  INSERT INTO `district` VALUES ('1103', '安源区', '156');
  INSERT INTO `district` VALUES ('1104', '湘东区', '156');
  INSERT INTO `district` VALUES ('1105', '莲花县', '156');
  INSERT INTO `district` VALUES ('1106', '上栗县', '156');
  INSERT INTO `district` VALUES ('1107', '芦溪县', '156');
  INSERT INTO `district` VALUES ('1108', '庐山区', '157');
  INSERT INTO `district` VALUES ('1109', '浔阳区', '157');
  INSERT INTO `district` VALUES ('1110', '九江县', '157');
  INSERT INTO `district` VALUES ('1111', '武宁县', '157');
  INSERT INTO `district` VALUES ('1112', '修水县', '157');
  INSERT INTO `district` VALUES ('1113', '永修县', '157');
  INSERT INTO `district` VALUES ('1114', '德安县', '157');
  INSERT INTO `district` VALUES ('1115', '星子县', '157');
  INSERT INTO `district` VALUES ('1116', '都昌县', '157');
  INSERT INTO `district` VALUES ('1117', '湖口县', '157');
  INSERT INTO `district` VALUES ('1118', '彭泽县', '157');
  INSERT INTO `district` VALUES ('1119', '瑞昌市', '157');
  INSERT INTO `district` VALUES ('1120', '渝水区', '158');
  INSERT INTO `district` VALUES ('1121', '分宜县', '158');
  INSERT INTO `district` VALUES ('1122', '月湖区', '159');
  INSERT INTO `district` VALUES ('1123', '余江县', '159');
  INSERT INTO `district` VALUES ('1124', '贵溪市', '159');
  INSERT INTO `district` VALUES ('1125', '章贡区', '160');
  INSERT INTO `district` VALUES ('1126', '赣　县', '160');
  INSERT INTO `district` VALUES ('1127', '信丰县', '160');
  INSERT INTO `district` VALUES ('1128', '大余县', '160');
  INSERT INTO `district` VALUES ('1129', '上犹县', '160');
  INSERT INTO `district` VALUES ('1130', '崇义县', '160');
  INSERT INTO `district` VALUES ('1131', '安远县', '160');
  INSERT INTO `district` VALUES ('1132', '龙南县', '160');
  INSERT INTO `district` VALUES ('1133', '定南县', '160');
  INSERT INTO `district` VALUES ('1134', '全南县', '160');
  INSERT INTO `district` VALUES ('1135', '宁都县', '160');
  INSERT INTO `district` VALUES ('1136', '于都县', '160');
  INSERT INTO `district` VALUES ('1137', '兴国县', '160');
  INSERT INTO `district` VALUES ('1138', '会昌县', '160');
  INSERT INTO `district` VALUES ('1139', '寻乌县', '160');
  INSERT INTO `district` VALUES ('1140', '石城县', '160');
  INSERT INTO `district` VALUES ('1141', '瑞金市', '160');
  INSERT INTO `district` VALUES ('1142', '南康市', '160');
  INSERT INTO `district` VALUES ('1143', '吉州区', '161');
  INSERT INTO `district` VALUES ('1144', '青原区', '161');
  INSERT INTO `district` VALUES ('1145', '吉安县', '161');
  INSERT INTO `district` VALUES ('1146', '吉水县', '161');
  INSERT INTO `district` VALUES ('1147', '峡江县', '161');
  INSERT INTO `district` VALUES ('1148', '新干县', '161');
  INSERT INTO `district` VALUES ('1149', '永丰县', '161');
  INSERT INTO `district` VALUES ('1150', '泰和县', '161');
  INSERT INTO `district` VALUES ('1151', '遂川县', '161');
  INSERT INTO `district` VALUES ('1152', '万安县', '161');
  INSERT INTO `district` VALUES ('1153', '安福县', '161');
  INSERT INTO `district` VALUES ('1154', '永新县', '161');
  INSERT INTO `district` VALUES ('1155', '井冈山市', '161');
  INSERT INTO `district` VALUES ('1156', '袁州区', '162');
  INSERT INTO `district` VALUES ('1157', '奉新县', '162');
  INSERT INTO `district` VALUES ('1158', '万载县', '162');
  INSERT INTO `district` VALUES ('1159', '上高县', '162');
  INSERT INTO `district` VALUES ('1160', '宜丰县', '162');
  INSERT INTO `district` VALUES ('1161', '靖安县', '162');
  INSERT INTO `district` VALUES ('1162', '铜鼓县', '162');
  INSERT INTO `district` VALUES ('1163', '丰城市', '162');
  INSERT INTO `district` VALUES ('1164', '樟树市', '162');
  INSERT INTO `district` VALUES ('1165', '高安市', '162');
  INSERT INTO `district` VALUES ('1166', '临川区', '163');
  INSERT INTO `district` VALUES ('1167', '南城县', '163');
  INSERT INTO `district` VALUES ('1168', '黎川县', '163');
  INSERT INTO `district` VALUES ('1169', '南丰县', '163');
  INSERT INTO `district` VALUES ('1170', '崇仁县', '163');
  INSERT INTO `district` VALUES ('1171', '乐安县', '163');
  INSERT INTO `district` VALUES ('1172', '宜黄县', '163');
  INSERT INTO `district` VALUES ('1173', '金溪县', '163');
  INSERT INTO `district` VALUES ('1174', '资溪县', '163');
  INSERT INTO `district` VALUES ('1175', '东乡县', '163');
  INSERT INTO `district` VALUES ('1176', '广昌县', '163');
  INSERT INTO `district` VALUES ('1177', '信州区', '164');
  INSERT INTO `district` VALUES ('1178', '上饶县', '164');
  INSERT INTO `district` VALUES ('1179', '广丰县', '164');
  INSERT INTO `district` VALUES ('1180', '玉山县', '164');
  INSERT INTO `district` VALUES ('1181', '铅山县', '164');
  INSERT INTO `district` VALUES ('1182', '横峰县', '164');
  INSERT INTO `district` VALUES ('1183', '弋阳县', '164');
  INSERT INTO `district` VALUES ('1184', '余干县', '164');
  INSERT INTO `district` VALUES ('1185', '鄱阳县', '164');
  INSERT INTO `district` VALUES ('1186', '万年县', '164');
  INSERT INTO `district` VALUES ('1187', '婺源县', '164');
  INSERT INTO `district` VALUES ('1188', '德兴市', '164');
  INSERT INTO `district` VALUES ('1189', '历下区', '165');
  INSERT INTO `district` VALUES ('1190', '市中区', '165');
  INSERT INTO `district` VALUES ('1191', '槐荫区', '165');
  INSERT INTO `district` VALUES ('1192', '天桥区', '165');
  INSERT INTO `district` VALUES ('1193', '历城区', '165');
  INSERT INTO `district` VALUES ('1194', '长清区', '165');
  INSERT INTO `district` VALUES ('1195', '平阴县', '165');
  INSERT INTO `district` VALUES ('1196', '济阳县', '165');
  INSERT INTO `district` VALUES ('1197', '商河县', '165');
  INSERT INTO `district` VALUES ('1198', '章丘市', '165');
  INSERT INTO `district` VALUES ('1199', '市南区', '166');
  INSERT INTO `district` VALUES ('1200', '市北区', '166');
  INSERT INTO `district` VALUES ('1201', '四方区', '166');
  INSERT INTO `district` VALUES ('1202', '黄岛区', '166');
  INSERT INTO `district` VALUES ('1203', '崂山区', '166');
  INSERT INTO `district` VALUES ('1204', '李沧区', '166');
  INSERT INTO `district` VALUES ('1205', '城阳区', '166');
  INSERT INTO `district` VALUES ('1206', '胶州市', '166');
  INSERT INTO `district` VALUES ('1207', '即墨市', '166');
  INSERT INTO `district` VALUES ('1208', '平度市', '166');
  INSERT INTO `district` VALUES ('1209', '胶南市', '166');
  INSERT INTO `district` VALUES ('1210', '莱西市', '166');
  INSERT INTO `district` VALUES ('1211', '淄川区', '167');
  INSERT INTO `district` VALUES ('1212', '张店区', '167');
  INSERT INTO `district` VALUES ('1213', '博山区', '167');
  INSERT INTO `district` VALUES ('1214', '临淄区', '167');
  INSERT INTO `district` VALUES ('1215', '周村区', '167');
  INSERT INTO `district` VALUES ('1216', '桓台县', '167');
  INSERT INTO `district` VALUES ('1217', '高青县', '167');
  INSERT INTO `district` VALUES ('1218', '沂源县', '167');
  INSERT INTO `district` VALUES ('1219', '市中区', '168');
  INSERT INTO `district` VALUES ('1220', '薛城区', '168');
  INSERT INTO `district` VALUES ('1221', '峄城区', '168');
  INSERT INTO `district` VALUES ('1222', '台儿庄区', '168');
  INSERT INTO `district` VALUES ('1223', '山亭区', '168');
  INSERT INTO `district` VALUES ('1224', '滕州市', '168');
  INSERT INTO `district` VALUES ('1225', '东营区', '169');
  INSERT INTO `district` VALUES ('1226', '河口区', '169');
  INSERT INTO `district` VALUES ('1227', '垦利县', '169');
  INSERT INTO `district` VALUES ('1228', '利津县', '169');
  INSERT INTO `district` VALUES ('1229', '广饶县', '169');
  INSERT INTO `district` VALUES ('1230', '芝罘区', '170');
  INSERT INTO `district` VALUES ('1231', '福山区', '170');
  INSERT INTO `district` VALUES ('1232', '牟平区', '170');
  INSERT INTO `district` VALUES ('1233', '莱山区', '170');
  INSERT INTO `district` VALUES ('1234', '长岛县', '170');
  INSERT INTO `district` VALUES ('1235', '龙口市', '170');
  INSERT INTO `district` VALUES ('1236', '莱阳市', '170');
  INSERT INTO `district` VALUES ('1237', '莱州市', '170');
  INSERT INTO `district` VALUES ('1238', '蓬莱市', '170');
  INSERT INTO `district` VALUES ('1239', '招远市', '170');
  INSERT INTO `district` VALUES ('1240', '栖霞市', '170');
  INSERT INTO `district` VALUES ('1241', '海阳市', '170');
  INSERT INTO `district` VALUES ('1242', '潍城区', '171');
  INSERT INTO `district` VALUES ('1243', '寒亭区', '171');
  INSERT INTO `district` VALUES ('1244', '坊子区', '171');
  INSERT INTO `district` VALUES ('1245', '奎文区', '171');
  INSERT INTO `district` VALUES ('1246', '临朐县', '171');
  INSERT INTO `district` VALUES ('1247', '昌乐县', '171');
  INSERT INTO `district` VALUES ('1248', '青州市', '171');
  INSERT INTO `district` VALUES ('1249', '诸城市', '171');
  INSERT INTO `district` VALUES ('1250', '寿光市', '171');
  INSERT INTO `district` VALUES ('1251', '安丘市', '171');
  INSERT INTO `district` VALUES ('1252', '高密市', '171');
  INSERT INTO `district` VALUES ('1253', '昌邑市', '171');
  INSERT INTO `district` VALUES ('1254', '市中区', '172');
  INSERT INTO `district` VALUES ('1255', '任城区', '172');
  INSERT INTO `district` VALUES ('1256', '微山县', '172');
  INSERT INTO `district` VALUES ('1257', '鱼台县', '172');
  INSERT INTO `district` VALUES ('1258', '金乡县', '172');
  INSERT INTO `district` VALUES ('1259', '嘉祥县', '172');
  INSERT INTO `district` VALUES ('1260', '汶上县', '172');
  INSERT INTO `district` VALUES ('1261', '泗水县', '172');
  INSERT INTO `district` VALUES ('1262', '梁山县', '172');
  INSERT INTO `district` VALUES ('1263', '曲阜市', '172');
  INSERT INTO `district` VALUES ('1264', '兖州市', '172');
  INSERT INTO `district` VALUES ('1265', '邹城市', '172');
  INSERT INTO `district` VALUES ('1266', '泰山区', '173');
  INSERT INTO `district` VALUES ('1267', '岱岳区', '173');
  INSERT INTO `district` VALUES ('1268', '宁阳县', '173');
  INSERT INTO `district` VALUES ('1269', '东平县', '173');
  INSERT INTO `district` VALUES ('1270', '新泰市', '173');
  INSERT INTO `district` VALUES ('1271', '肥城市', '173');
  INSERT INTO `district` VALUES ('1272', '环翠区', '174');
  INSERT INTO `district` VALUES ('1273', '文登市', '174');
  INSERT INTO `district` VALUES ('1274', '荣成市', '174');
  INSERT INTO `district` VALUES ('1275', '乳山市', '174');
  INSERT INTO `district` VALUES ('1276', '东港区', '175');
  INSERT INTO `district` VALUES ('1277', '岚山区', '175');
  INSERT INTO `district` VALUES ('1278', '五莲县', '175');
  INSERT INTO `district` VALUES ('1279', '莒　县', '175');
  INSERT INTO `district` VALUES ('1280', '莱城区', '176');
  INSERT INTO `district` VALUES ('1281', '钢城区', '176');
  INSERT INTO `district` VALUES ('1282', '兰山区', '177');
  INSERT INTO `district` VALUES ('1283', '罗庄区', '177');
  INSERT INTO `district` VALUES ('1284', '河东区', '177');
  INSERT INTO `district` VALUES ('1285', '沂南县', '177');
  INSERT INTO `district` VALUES ('1286', '郯城县', '177');
  INSERT INTO `district` VALUES ('1287', '沂水县', '177');
  INSERT INTO `district` VALUES ('1288', '苍山县', '177');
  INSERT INTO `district` VALUES ('1289', '费　县', '177');
  INSERT INTO `district` VALUES ('1290', '平邑县', '177');
  INSERT INTO `district` VALUES ('1291', '莒南县', '177');
  INSERT INTO `district` VALUES ('1292', '蒙阴县', '177');
  INSERT INTO `district` VALUES ('1293', '临沭县', '177');
  INSERT INTO `district` VALUES ('1294', '德城区', '178');
  INSERT INTO `district` VALUES ('1295', '陵　县', '178');
  INSERT INTO `district` VALUES ('1296', '宁津县', '178');
  INSERT INTO `district` VALUES ('1297', '庆云县', '178');
  INSERT INTO `district` VALUES ('1298', '临邑县', '178');
  INSERT INTO `district` VALUES ('1299', '齐河县', '178');
  INSERT INTO `district` VALUES ('1300', '平原县', '178');
  INSERT INTO `district` VALUES ('1301', '夏津县', '178');
  INSERT INTO `district` VALUES ('1302', '武城县', '178');
  INSERT INTO `district` VALUES ('1303', '乐陵市', '178');
  INSERT INTO `district` VALUES ('1304', '禹城市', '178');
  INSERT INTO `district` VALUES ('1305', '东昌府区', '179');
  INSERT INTO `district` VALUES ('1306', '阳谷县', '179');
  INSERT INTO `district` VALUES ('1307', '莘　县', '179');
  INSERT INTO `district` VALUES ('1308', '茌平县', '179');
  INSERT INTO `district` VALUES ('1309', '东阿县', '179');
  INSERT INTO `district` VALUES ('1310', '冠　县', '179');
  INSERT INTO `district` VALUES ('1311', '高唐县', '179');
  INSERT INTO `district` VALUES ('1312', '临清市', '179');
  INSERT INTO `district` VALUES ('1313', '滨城区', '180');
  INSERT INTO `district` VALUES ('1314', '惠民县', '180');
  INSERT INTO `district` VALUES ('1315', '阳信县', '180');
  INSERT INTO `district` VALUES ('1316', '无棣县', '180');
  INSERT INTO `district` VALUES ('1317', '沾化县', '180');
  INSERT INTO `district` VALUES ('1318', '博兴县', '180');
  INSERT INTO `district` VALUES ('1319', '邹平县', '180');
  INSERT INTO `district` VALUES ('1320', '牡丹区', '181');
  INSERT INTO `district` VALUES ('1321', '曹　县', '181');
  INSERT INTO `district` VALUES ('1322', '单　县', '181');
  INSERT INTO `district` VALUES ('1323', '成武县', '181');
  INSERT INTO `district` VALUES ('1324', '巨野县', '181');
  INSERT INTO `district` VALUES ('1325', '郓城县', '181');
  INSERT INTO `district` VALUES ('1326', '鄄城县', '181');
  INSERT INTO `district` VALUES ('1327', '定陶县', '181');
  INSERT INTO `district` VALUES ('1328', '东明县', '181');
  INSERT INTO `district` VALUES ('1329', '中原区', '182');
  INSERT INTO `district` VALUES ('1330', '二七区', '182');
  INSERT INTO `district` VALUES ('1331', '管城回族区', '182');
  INSERT INTO `district` VALUES ('1332', '金水区', '182');
  INSERT INTO `district` VALUES ('1333', '上街区', '182');
  INSERT INTO `district` VALUES ('1334', '惠济区', '182');
  INSERT INTO `district` VALUES ('1335', '中牟县', '182');
  INSERT INTO `district` VALUES ('1336', '巩义市', '182');
  INSERT INTO `district` VALUES ('1337', '荥阳市', '182');
  INSERT INTO `district` VALUES ('1338', '新密市', '182');
  INSERT INTO `district` VALUES ('1339', '新郑市', '182');
  INSERT INTO `district` VALUES ('1340', '登封市', '182');
  INSERT INTO `district` VALUES ('1341', '龙亭区', '183');
  INSERT INTO `district` VALUES ('1342', '顺河回族区', '183');
  INSERT INTO `district` VALUES ('1343', '鼓楼区', '183');
  INSERT INTO `district` VALUES ('1344', '禹王台区', '183');
  INSERT INTO `district` VALUES ('1345', '金明区', '183');
  INSERT INTO `district` VALUES ('1346', '杞　县', '183');
  INSERT INTO `district` VALUES ('1347', '通许县', '183');
  INSERT INTO `district` VALUES ('1348', '尉氏县', '183');
  INSERT INTO `district` VALUES ('1349', '开封县', '183');
  INSERT INTO `district` VALUES ('1350', '兰考县', '183');
  INSERT INTO `district` VALUES ('1351', '老城区', '184');
  INSERT INTO `district` VALUES ('1352', '西工区', '184');
  INSERT INTO `district` VALUES ('1353', '涧西区', '184');
  INSERT INTO `district` VALUES ('1354', '吉利区', '184');
  INSERT INTO `district` VALUES ('1355', '洛龙区', '184');
  INSERT INTO `district` VALUES ('1356', '孟津县', '184');
  INSERT INTO `district` VALUES ('1357', '新安县', '184');
  INSERT INTO `district` VALUES ('1358', '栾川县', '184');
  INSERT INTO `district` VALUES ('1359', '嵩　县', '184');
  INSERT INTO `district` VALUES ('1360', '汝阳县', '184');
  INSERT INTO `district` VALUES ('1361', '宜阳县', '184');
  INSERT INTO `district` VALUES ('1362', '洛宁县', '184');
  INSERT INTO `district` VALUES ('1363', '伊川县', '184');
  INSERT INTO `district` VALUES ('1364', '偃师市', '184');
  INSERT INTO `district` VALUES ('1365', '新华区', '185');
  INSERT INTO `district` VALUES ('1366', '卫东区', '185');
  INSERT INTO `district` VALUES ('1367', '石龙区', '185');
  INSERT INTO `district` VALUES ('1368', '湛河区', '185');
  INSERT INTO `district` VALUES ('1369', '宝丰县', '185');
  INSERT INTO `district` VALUES ('1370', '叶　县', '185');
  INSERT INTO `district` VALUES ('1371', '鲁山县', '185');
  INSERT INTO `district` VALUES ('1372', '郏　县', '185');
  INSERT INTO `district` VALUES ('1373', '舞钢市', '185');
  INSERT INTO `district` VALUES ('1374', '汝州市', '185');
  INSERT INTO `district` VALUES ('1375', '文峰区', '186');
  INSERT INTO `district` VALUES ('1376', '北关区', '186');
  INSERT INTO `district` VALUES ('1377', '殷都区', '186');
  INSERT INTO `district` VALUES ('1378', '龙安区', '186');
  INSERT INTO `district` VALUES ('1379', '安阳县', '186');
  INSERT INTO `district` VALUES ('1380', '汤阴县', '186');
  INSERT INTO `district` VALUES ('1381', '滑　县', '186');
  INSERT INTO `district` VALUES ('1382', '内黄县', '186');
  INSERT INTO `district` VALUES ('1383', '林州市', '186');
  INSERT INTO `district` VALUES ('1384', '鹤山区', '187');
  INSERT INTO `district` VALUES ('1385', '山城区', '187');
  INSERT INTO `district` VALUES ('1386', '淇滨区', '187');
  INSERT INTO `district` VALUES ('1387', '浚　县', '187');
  INSERT INTO `district` VALUES ('1388', '淇　县', '187');
  INSERT INTO `district` VALUES ('1389', '红旗区', '188');
  INSERT INTO `district` VALUES ('1390', '卫滨区', '188');
  INSERT INTO `district` VALUES ('1391', '凤泉区', '188');
  INSERT INTO `district` VALUES ('1392', '牧野区', '188');
  INSERT INTO `district` VALUES ('1393', '新乡县', '188');
  INSERT INTO `district` VALUES ('1394', '获嘉县', '188');
  INSERT INTO `district` VALUES ('1395', '原阳县', '188');
  INSERT INTO `district` VALUES ('1396', '延津县', '188');
  INSERT INTO `district` VALUES ('1397', '封丘县', '188');
  INSERT INTO `district` VALUES ('1398', '长垣县', '188');
  INSERT INTO `district` VALUES ('1399', '卫辉市', '188');
  INSERT INTO `district` VALUES ('1400', '辉县市', '188');
  INSERT INTO `district` VALUES ('1401', '解放区', '189');
  INSERT INTO `district` VALUES ('1402', '中站区', '189');
  INSERT INTO `district` VALUES ('1403', '马村区', '189');
  INSERT INTO `district` VALUES ('1404', '山阳区', '189');
  INSERT INTO `district` VALUES ('1405', '修武县', '189');
  INSERT INTO `district` VALUES ('1406', '博爱县', '189');
  INSERT INTO `district` VALUES ('1407', '武陟县', '189');
  INSERT INTO `district` VALUES ('1408', '温　县', '189');
  INSERT INTO `district` VALUES ('1409', '济源市', '189');
  INSERT INTO `district` VALUES ('1410', '沁阳市', '189');
  INSERT INTO `district` VALUES ('1411', '孟州市', '189');
  INSERT INTO `district` VALUES ('1412', '华龙区', '190');
  INSERT INTO `district` VALUES ('1413', '清丰县', '190');
  INSERT INTO `district` VALUES ('1414', '南乐县', '190');
  INSERT INTO `district` VALUES ('1415', '范　县', '190');
  INSERT INTO `district` VALUES ('1416', '台前县', '190');
  INSERT INTO `district` VALUES ('1417', '濮阳县', '190');
  INSERT INTO `district` VALUES ('1418', '魏都区', '191');
  INSERT INTO `district` VALUES ('1419', '许昌县', '191');
  INSERT INTO `district` VALUES ('1420', '鄢陵县', '191');
  INSERT INTO `district` VALUES ('1421', '襄城县', '191');
  INSERT INTO `district` VALUES ('1422', '禹州市', '191');
  INSERT INTO `district` VALUES ('1423', '长葛市', '191');
  INSERT INTO `district` VALUES ('1424', '源汇区', '192');
  INSERT INTO `district` VALUES ('1425', '郾城区', '192');
  INSERT INTO `district` VALUES ('1426', '召陵区', '192');
  INSERT INTO `district` VALUES ('1427', '舞阳县', '192');
  INSERT INTO `district` VALUES ('1428', '临颍县', '192');
  INSERT INTO `district` VALUES ('1429', '湖滨区', '193');
  INSERT INTO `district` VALUES ('1430', '渑池县', '193');
  INSERT INTO `district` VALUES ('1431', '陕　县', '193');
  INSERT INTO `district` VALUES ('1432', '卢氏县', '193');
  INSERT INTO `district` VALUES ('1433', '义马市', '193');
  INSERT INTO `district` VALUES ('1434', '灵宝市', '193');
  INSERT INTO `district` VALUES ('1435', '宛城区', '194');
  INSERT INTO `district` VALUES ('1436', '卧龙区', '194');
  INSERT INTO `district` VALUES ('1437', '南召县', '194');
  INSERT INTO `district` VALUES ('1438', '方城县', '194');
  INSERT INTO `district` VALUES ('1439', '西峡县', '194');
  INSERT INTO `district` VALUES ('1440', '镇平县', '194');
  INSERT INTO `district` VALUES ('1441', '内乡县', '194');
  INSERT INTO `district` VALUES ('1442', '淅川县', '194');
  INSERT INTO `district` VALUES ('1443', '社旗县', '194');
  INSERT INTO `district` VALUES ('1444', '唐河县', '194');
  INSERT INTO `district` VALUES ('1445', '新野县', '194');
  INSERT INTO `district` VALUES ('1446', '桐柏县', '194');
  INSERT INTO `district` VALUES ('1447', '邓州市', '194');
  INSERT INTO `district` VALUES ('1448', '梁园区', '195');
  INSERT INTO `district` VALUES ('1449', '睢阳区', '195');
  INSERT INTO `district` VALUES ('1450', '民权县', '195');
  INSERT INTO `district` VALUES ('1451', '睢　县', '195');
  INSERT INTO `district` VALUES ('1452', '宁陵县', '195');
  INSERT INTO `district` VALUES ('1453', '柘城县', '195');
  INSERT INTO `district` VALUES ('1454', '虞城县', '195');
  INSERT INTO `district` VALUES ('1455', '夏邑县', '195');
  INSERT INTO `district` VALUES ('1456', '永城市', '195');
  INSERT INTO `district` VALUES ('1457', '平桥区', '196');
  INSERT INTO `district` VALUES ('1458', '罗山县', '196');
  INSERT INTO `district` VALUES ('1459', '光山县', '196');
  INSERT INTO `district` VALUES ('1460', '新　县', '196');
  INSERT INTO `district` VALUES ('1461', '商城县', '196');
  INSERT INTO `district` VALUES ('1462', '固始县', '196');
  INSERT INTO `district` VALUES ('1463', '潢川县', '196');
  INSERT INTO `district` VALUES ('1464', '淮滨县', '196');
  INSERT INTO `district` VALUES ('1465', '息　县', '196');
  INSERT INTO `district` VALUES ('1466', '川汇区', '197');
  INSERT INTO `district` VALUES ('1467', '扶沟县', '197');
  INSERT INTO `district` VALUES ('1468', '西华县', '197');
  INSERT INTO `district` VALUES ('1469', '商水县', '197');
  INSERT INTO `district` VALUES ('1470', '沈丘县', '197');
  INSERT INTO `district` VALUES ('1471', '郸城县', '197');
  INSERT INTO `district` VALUES ('1472', '淮阳县', '197');
  INSERT INTO `district` VALUES ('1473', '太康县', '197');
  INSERT INTO `district` VALUES ('1474', '鹿邑县', '197');
  INSERT INTO `district` VALUES ('1475', '项城市', '197');
  INSERT INTO `district` VALUES ('1476', '驿城区', '198');
  INSERT INTO `district` VALUES ('1477', '西平县', '198');
  INSERT INTO `district` VALUES ('1478', '上蔡县', '198');
  INSERT INTO `district` VALUES ('1479', '平舆县', '198');
  INSERT INTO `district` VALUES ('1480', '正阳县', '198');
  INSERT INTO `district` VALUES ('1481', '确山县', '198');
  INSERT INTO `district` VALUES ('1482', '泌阳县', '198');
  INSERT INTO `district` VALUES ('1483', '汝南县', '198');
  INSERT INTO `district` VALUES ('1484', '遂平县', '198');
  INSERT INTO `district` VALUES ('1485', '新蔡县', '198');
  INSERT INTO `district` VALUES ('1486', '江岸区', '199');
  INSERT INTO `district` VALUES ('1487', '江汉区', '199');
  INSERT INTO `district` VALUES ('1488', '汉阳区', '199');
  INSERT INTO `district` VALUES ('1489', '武昌区', '199');
  INSERT INTO `district` VALUES ('1490', '青山区', '199');
  INSERT INTO `district` VALUES ('1491', '洪山区', '199');
  INSERT INTO `district` VALUES ('1492', '东西湖区', '199');
  INSERT INTO `district` VALUES ('1493', '汉南区', '199');
  INSERT INTO `district` VALUES ('1494', '蔡甸区', '199');
  INSERT INTO `district` VALUES ('1495', '江夏区', '199');
  INSERT INTO `district` VALUES ('1496', '黄陂区', '199');
  INSERT INTO `district` VALUES ('1497', '新洲区', '199');
  INSERT INTO `district` VALUES ('1498', '黄石港区', '200');
  INSERT INTO `district` VALUES ('1499', '西塞山区', '200');
  INSERT INTO `district` VALUES ('1500', '下陆区', '200');
  INSERT INTO `district` VALUES ('1501', '铁山区', '200');
  INSERT INTO `district` VALUES ('1502', '阳新县', '200');
  INSERT INTO `district` VALUES ('1503', '大冶市', '200');
  INSERT INTO `district` VALUES ('1504', '茅箭区', '201');
  INSERT INTO `district` VALUES ('1505', '张湾区', '201');
  INSERT INTO `district` VALUES ('1506', '郧　县', '201');
  INSERT INTO `district` VALUES ('1507', '郧西县', '201');
  INSERT INTO `district` VALUES ('1508', '竹山县', '201');
  INSERT INTO `district` VALUES ('1509', '竹溪县', '201');
  INSERT INTO `district` VALUES ('1510', '房　县', '201');
  INSERT INTO `district` VALUES ('1511', '丹江口市', '201');
  INSERT INTO `district` VALUES ('1512', '西陵区', '202');
  INSERT INTO `district` VALUES ('1513', '伍家岗区', '202');
  INSERT INTO `district` VALUES ('1514', '点军区', '202');
  INSERT INTO `district` VALUES ('1515', '夷陵区', '202');
  INSERT INTO `district` VALUES ('1516', '远安县', '202');
  INSERT INTO `district` VALUES ('1517', '兴山县', '202');
  INSERT INTO `district` VALUES ('1518', '秭归县', '202');
  INSERT INTO `district` VALUES ('1519', '长阳土家族自治县', '202');
  INSERT INTO `district` VALUES ('1520', '五峰土家族自治县', '202');
  INSERT INTO `district` VALUES ('1521', '宜都市', '202');
  INSERT INTO `district` VALUES ('1522', '当阳市', '202');
  INSERT INTO `district` VALUES ('1523', '枝江市', '202');
  INSERT INTO `district` VALUES ('1524', '襄城区', '203');
  INSERT INTO `district` VALUES ('1525', '樊城区', '203');
  INSERT INTO `district` VALUES ('1526', '襄阳区', '203');
  INSERT INTO `district` VALUES ('1527', '南漳县', '203');
  INSERT INTO `district` VALUES ('1528', '谷城县', '203');
  INSERT INTO `district` VALUES ('1529', '保康县', '203');
  INSERT INTO `district` VALUES ('1530', '老河口市', '203');
  INSERT INTO `district` VALUES ('1531', '枣阳市', '203');
  INSERT INTO `district` VALUES ('1532', '宜城市', '203');
  INSERT INTO `district` VALUES ('1533', '梁子湖区', '204');
  INSERT INTO `district` VALUES ('1534', '华容区', '204');
  INSERT INTO `district` VALUES ('1535', '鄂城区', '204');
  INSERT INTO `district` VALUES ('1536', '东宝区', '205');
  INSERT INTO `district` VALUES ('1537', '掇刀区', '205');
  INSERT INTO `district` VALUES ('1538', '京山县', '205');
  INSERT INTO `district` VALUES ('1539', '沙洋县', '205');
  INSERT INTO `district` VALUES ('1540', '钟祥市', '205');
  INSERT INTO `district` VALUES ('1541', '孝南区', '206');
  INSERT INTO `district` VALUES ('1542', '孝昌县', '206');
  INSERT INTO `district` VALUES ('1543', '大悟县', '206');
  INSERT INTO `district` VALUES ('1544', '云梦县', '206');
  INSERT INTO `district` VALUES ('1545', '应城市', '206');
  INSERT INTO `district` VALUES ('1546', '安陆市', '206');
  INSERT INTO `district` VALUES ('1547', '汉川市', '206');
  INSERT INTO `district` VALUES ('1548', '沙市区', '207');
  INSERT INTO `district` VALUES ('1549', '荆州区', '207');
  INSERT INTO `district` VALUES ('1550', '公安县', '207');
  INSERT INTO `district` VALUES ('1551', '监利县', '207');
  INSERT INTO `district` VALUES ('1552', '江陵县', '207');
  INSERT INTO `district` VALUES ('1553', '石首市', '207');
  INSERT INTO `district` VALUES ('1554', '洪湖市', '207');
  INSERT INTO `district` VALUES ('1555', '松滋市', '207');
  INSERT INTO `district` VALUES ('1556', '黄州区', '208');
  INSERT INTO `district` VALUES ('1557', '团风县', '208');
  INSERT INTO `district` VALUES ('1558', '红安县', '208');
  INSERT INTO `district` VALUES ('1559', '罗田县', '208');
  INSERT INTO `district` VALUES ('1560', '英山县', '208');
  INSERT INTO `district` VALUES ('1561', '浠水县', '208');
  INSERT INTO `district` VALUES ('1562', '蕲春县', '208');
  INSERT INTO `district` VALUES ('1563', '黄梅县', '208');
  INSERT INTO `district` VALUES ('1564', '麻城市', '208');
  INSERT INTO `district` VALUES ('1565', '武穴市', '208');
  INSERT INTO `district` VALUES ('1566', '咸安区', '209');
  INSERT INTO `district` VALUES ('1567', '嘉鱼县', '209');
  INSERT INTO `district` VALUES ('1568', '通城县', '209');
  INSERT INTO `district` VALUES ('1569', '崇阳县', '209');
  INSERT INTO `district` VALUES ('1570', '通山县', '209');
  INSERT INTO `district` VALUES ('1571', '赤壁市', '209');
  INSERT INTO `district` VALUES ('1572', '曾都区', '210');
  INSERT INTO `district` VALUES ('1573', '广水市', '210');
  INSERT INTO `district` VALUES ('1574', '恩施市', '211');
  INSERT INTO `district` VALUES ('1575', '利川市', '211');
  INSERT INTO `district` VALUES ('1576', '建始县', '211');
  INSERT INTO `district` VALUES ('1577', '巴东县', '211');
  INSERT INTO `district` VALUES ('1578', '宣恩县', '211');
  INSERT INTO `district` VALUES ('1579', '咸丰县', '211');
  INSERT INTO `district` VALUES ('1580', '来凤县', '211');
  INSERT INTO `district` VALUES ('1581', '鹤峰县', '211');
  INSERT INTO `district` VALUES ('1582', '仙桃市', '211');
  INSERT INTO `district` VALUES ('1583', '潜江市', '211');
  INSERT INTO `district` VALUES ('1584', '天门市', '211');
  INSERT INTO `district` VALUES ('1585', '神农架林区', '211');
  INSERT INTO `district` VALUES ('1586', '芙蓉区', '212');
  INSERT INTO `district` VALUES ('1587', '天心区', '212');
  INSERT INTO `district` VALUES ('1588', '岳麓区', '212');
  INSERT INTO `district` VALUES ('1589', '开福区', '212');
  INSERT INTO `district` VALUES ('1590', '雨花区', '212');
  INSERT INTO `district` VALUES ('1591', '长沙县', '212');
  INSERT INTO `district` VALUES ('1592', '望城县', '212');
  INSERT INTO `district` VALUES ('1593', '宁乡县', '212');
  INSERT INTO `district` VALUES ('1594', '浏阳市', '212');
  INSERT INTO `district` VALUES ('1595', '荷塘区', '213');
  INSERT INTO `district` VALUES ('1596', '芦淞区', '213');
  INSERT INTO `district` VALUES ('1597', '石峰区', '213');
  INSERT INTO `district` VALUES ('1598', '天元区', '213');
  INSERT INTO `district` VALUES ('1599', '株洲县', '213');
  INSERT INTO `district` VALUES ('1600', '攸　县', '213');
  INSERT INTO `district` VALUES ('1601', '茶陵县', '213');
  INSERT INTO `district` VALUES ('1602', '炎陵县', '213');
  INSERT INTO `district` VALUES ('1603', '雨湖区', '214');
  INSERT INTO `district` VALUES ('1604', '岳塘区', '214');
  INSERT INTO `district` VALUES ('1605', '湘潭县', '214');
  INSERT INTO `district` VALUES ('1606', '湘乡市', '214');
  INSERT INTO `district` VALUES ('1607', '韶山市', '214');
  INSERT INTO `district` VALUES ('1608', '珠晖区', '215');
  INSERT INTO `district` VALUES ('1609', '雁峰区', '215');
  INSERT INTO `district` VALUES ('1610', '石鼓区', '215');
  INSERT INTO `district` VALUES ('1611', '蒸湘区', '215');
  INSERT INTO `district` VALUES ('1612', '南岳区', '215');
  INSERT INTO `district` VALUES ('1613', '衡阳县', '215');
  INSERT INTO `district` VALUES ('1614', '衡南县', '215');
  INSERT INTO `district` VALUES ('1615', '衡山县', '215');
  INSERT INTO `district` VALUES ('1616', '衡东县', '215');
  INSERT INTO `district` VALUES ('1617', '祁东县', '215');
  INSERT INTO `district` VALUES ('1618', '耒阳市', '215');
  INSERT INTO `district` VALUES ('1619', '常宁市', '215');
  INSERT INTO `district` VALUES ('1620', '双清区', '216');
  INSERT INTO `district` VALUES ('1621', '大祥区', '216');
  INSERT INTO `district` VALUES ('1622', '北塔区', '216');
  INSERT INTO `district` VALUES ('1623', '邵东县', '216');
  INSERT INTO `district` VALUES ('1624', '新邵县', '216');
  INSERT INTO `district` VALUES ('1625', '邵阳县', '216');
  INSERT INTO `district` VALUES ('1626', '隆回县', '216');
  INSERT INTO `district` VALUES ('1627', '洞口县', '216');
  INSERT INTO `district` VALUES ('1628', '绥宁县', '216');
  INSERT INTO `district` VALUES ('1629', '新宁县', '216');
  INSERT INTO `district` VALUES ('1630', '城步苗族自治县', '216');
  INSERT INTO `district` VALUES ('1631', '武冈市', '216');
  INSERT INTO `district` VALUES ('1632', '岳阳楼区', '217');
  INSERT INTO `district` VALUES ('1633', '云溪区', '217');
  INSERT INTO `district` VALUES ('1634', '君山区', '217');
  INSERT INTO `district` VALUES ('1635', '岳阳县', '217');
  INSERT INTO `district` VALUES ('1636', '华容县', '217');
  INSERT INTO `district` VALUES ('1637', '湘阴县', '217');
  INSERT INTO `district` VALUES ('1638', '平江县', '217');
  INSERT INTO `district` VALUES ('1639', '汨罗市', '217');
  INSERT INTO `district` VALUES ('1640', '临湘市', '217');
  INSERT INTO `district` VALUES ('1641', '武陵区', '218');
  INSERT INTO `district` VALUES ('1642', '鼎城区', '218');
  INSERT INTO `district` VALUES ('1643', '安乡县', '218');
  INSERT INTO `district` VALUES ('1644', '汉寿县', '218');
  INSERT INTO `district` VALUES ('1645', '澧　县', '218');
  INSERT INTO `district` VALUES ('1646', '临澧县', '218');
  INSERT INTO `district` VALUES ('1647', '桃源县', '218');
  INSERT INTO `district` VALUES ('1648', '石门县', '218');
  INSERT INTO `district` VALUES ('1649', '津市市', '218');
  INSERT INTO `district` VALUES ('1650', '永定区', '219');
  INSERT INTO `district` VALUES ('1651', '武陵源区', '219');
  INSERT INTO `district` VALUES ('1652', '慈利县', '219');
  INSERT INTO `district` VALUES ('1653', '桑植县', '219');
  INSERT INTO `district` VALUES ('1654', '资阳区', '220');
  INSERT INTO `district` VALUES ('1655', '赫山区', '220');
  INSERT INTO `district` VALUES ('1656', '南　县', '220');
  INSERT INTO `district` VALUES ('1657', '桃江县', '220');
  INSERT INTO `district` VALUES ('1658', '安化县', '220');
  INSERT INTO `district` VALUES ('1659', '沅江市', '220');
  INSERT INTO `district` VALUES ('1660', '北湖区', '221');
  INSERT INTO `district` VALUES ('1661', '苏仙区', '221');
  INSERT INTO `district` VALUES ('1662', '桂阳县', '221');
  INSERT INTO `district` VALUES ('1663', '宜章县', '221');
  INSERT INTO `district` VALUES ('1664', '永兴县', '221');
  INSERT INTO `district` VALUES ('1665', '嘉禾县', '221');
  INSERT INTO `district` VALUES ('1666', '临武县', '221');
  INSERT INTO `district` VALUES ('1667', '汝城县', '221');
  INSERT INTO `district` VALUES ('1668', '桂东县', '221');
  INSERT INTO `district` VALUES ('1669', '安仁县', '21');
  INSERT INTO `district` VALUES ('1670', '资兴市', '221');
  INSERT INTO `district` VALUES ('1671', '零陵区', '222');
  INSERT INTO `district` VALUES ('1672', '冷水滩区', '222');
  INSERT INTO `district` VALUES ('1673', '祁阳县', '222');
  INSERT INTO `district` VALUES ('1674', '东安县', '222');
  INSERT INTO `district` VALUES ('1675', '双牌县', '222');
  INSERT INTO `district` VALUES ('1676', '道　县', '222');
  INSERT INTO `district` VALUES ('1677', '江永县', '222');
  INSERT INTO `district` VALUES ('1678', '宁远县', '222');
  INSERT INTO `district` VALUES ('1679', '蓝山县', '222');
  INSERT INTO `district` VALUES ('1680', '新田县', '222');
  INSERT INTO `district` VALUES ('1681', '江华瑶族自治县', '222');
  INSERT INTO `district` VALUES ('1682', '鹤城区', '223');
  INSERT INTO `district` VALUES ('1683', '中方县', '223');
  INSERT INTO `district` VALUES ('1684', '沅陵县', '223');
  INSERT INTO `district` VALUES ('1685', '辰溪县', '223');
  INSERT INTO `district` VALUES ('1686', '溆浦县', '223');
  INSERT INTO `district` VALUES ('1687', '会同县', '223');
  INSERT INTO `district` VALUES ('1688', '麻阳苗族自治县', '223');
  INSERT INTO `district` VALUES ('1689', '新晃侗族自治县', '223');
  INSERT INTO `district` VALUES ('1690', '芷江侗族自治县', '223');
  INSERT INTO `district` VALUES ('1691', '靖州苗族侗族自治县', '223');
  INSERT INTO `district` VALUES ('1692', '通道侗族自治县', '223');
  INSERT INTO `district` VALUES ('1693', '洪江市', '223');
  INSERT INTO `district` VALUES ('1694', '娄星区', '224');
  INSERT INTO `district` VALUES ('1695', '双峰县', '224');
  INSERT INTO `district` VALUES ('1696', '新化县', '224');
  INSERT INTO `district` VALUES ('1697', '冷水江市', '224');
  INSERT INTO `district` VALUES ('1698', '涟源市', '224');
  INSERT INTO `district` VALUES ('1699', '吉首市', '225');
  INSERT INTO `district` VALUES ('1700', '泸溪县', '225');
  INSERT INTO `district` VALUES ('1701', '凤凰县', '225');
  INSERT INTO `district` VALUES ('1702', '花垣县', '225');
  INSERT INTO `district` VALUES ('1703', '保靖县', '225');
  INSERT INTO `district` VALUES ('1704', '古丈县', '225');
  INSERT INTO `district` VALUES ('1705', '永顺县', '225');
  INSERT INTO `district` VALUES ('1706', '龙山县', '225');
  INSERT INTO `district` VALUES ('1707', '荔湾区', '226');
  INSERT INTO `district` VALUES ('1708', '越秀区', '226');
  INSERT INTO `district` VALUES ('1709', '海珠区', '226');
  INSERT INTO `district` VALUES ('1710', '天河区', '226');
  INSERT INTO `district` VALUES ('1711', '白云区', '226');
  INSERT INTO `district` VALUES ('1712', '黄埔区', '226');
  INSERT INTO `district` VALUES ('1713', '番禺区', '226');
  INSERT INTO `district` VALUES ('1714', '花都区', '226');
  INSERT INTO `district` VALUES ('1715', '南沙区', '226');
  INSERT INTO `district` VALUES ('1716', '萝岗区', '226');
  INSERT INTO `district` VALUES ('1717', '增城市', '226');
  INSERT INTO `district` VALUES ('1718', '从化市', '226');
  INSERT INTO `district` VALUES ('1719', '武江区', '227');
  INSERT INTO `district` VALUES ('1720', '浈江区', '227');
  INSERT INTO `district` VALUES ('1721', '曲江区', '227');
  INSERT INTO `district` VALUES ('1722', '始兴县', '227');
  INSERT INTO `district` VALUES ('1723', '仁化县', '227');
  INSERT INTO `district` VALUES ('1724', '翁源县', '227');
  INSERT INTO `district` VALUES ('1725', '乳源瑶族自治县', '227');
  INSERT INTO `district` VALUES ('1726', '新丰县', '227');
  INSERT INTO `district` VALUES ('1727', '乐昌市', '227');
  INSERT INTO `district` VALUES ('1728', '南雄市', '227');
  INSERT INTO `district` VALUES ('1729', '罗湖区', '228');
  INSERT INTO `district` VALUES ('1730', '福田区', '228');
  INSERT INTO `district` VALUES ('1731', '南山区', '228');
  INSERT INTO `district` VALUES ('1732', '宝安区', '228');
  INSERT INTO `district` VALUES ('1733', '龙岗区', '228');
  INSERT INTO `district` VALUES ('1734', '盐田区', '228');
  INSERT INTO `district` VALUES ('1735', '香洲区', '229');
  INSERT INTO `district` VALUES ('1736', '斗门区', '229');
  INSERT INTO `district` VALUES ('1737', '金湾区', '229');
  INSERT INTO `district` VALUES ('1738', '龙湖区', '230');
  INSERT INTO `district` VALUES ('1739', '金平区', '230');
  INSERT INTO `district` VALUES ('1740', '濠江区', '230');
  INSERT INTO `district` VALUES ('1741', '潮阳区', '230');
  INSERT INTO `district` VALUES ('1742', '潮南区', '230');
  INSERT INTO `district` VALUES ('1743', '澄海区', '230');
  INSERT INTO `district` VALUES ('1744', '南澳县', '230');
  INSERT INTO `district` VALUES ('1745', '禅城区', '231');
  INSERT INTO `district` VALUES ('1746', '南海区', '231');
  INSERT INTO `district` VALUES ('1747', '顺德区', '231');
  INSERT INTO `district` VALUES ('1748', '三水区', '231');
  INSERT INTO `district` VALUES ('1749', '高明区', '231');
  INSERT INTO `district` VALUES ('1750', '蓬江区', '232');
  INSERT INTO `district` VALUES ('1751', '江海区', '232');
  INSERT INTO `district` VALUES ('1752', '新会区', '232');
  INSERT INTO `district` VALUES ('1753', '台山市', '232');
  INSERT INTO `district` VALUES ('1754', '开平市', '232');
  INSERT INTO `district` VALUES ('1755', '鹤山市', '232');
  INSERT INTO `district` VALUES ('1756', '恩平市', '232');
  INSERT INTO `district` VALUES ('1757', '赤坎区', '233');
  INSERT INTO `district` VALUES ('1758', '霞山区', '233');
  INSERT INTO `district` VALUES ('1759', '坡头区', '233');
  INSERT INTO `district` VALUES ('1760', '麻章区', '233');
  INSERT INTO `district` VALUES ('1761', '遂溪县', '233');
  INSERT INTO `district` VALUES ('1762', '徐闻县', '233');
  INSERT INTO `district` VALUES ('1763', '廉江市', '233');
  INSERT INTO `district` VALUES ('1764', '雷州市', '233');
  INSERT INTO `district` VALUES ('1765', '吴川市', '233');
  INSERT INTO `district` VALUES ('1766', '茂南区', '234');
  INSERT INTO `district` VALUES ('1767', '茂港区', '234');
  INSERT INTO `district` VALUES ('1768', '电白县', '234');
  INSERT INTO `district` VALUES ('1769', '高州市', '234');
  INSERT INTO `district` VALUES ('1770', '化州市', '234');
  INSERT INTO `district` VALUES ('1771', '信宜市', '234');
  INSERT INTO `district` VALUES ('1772', '端州区', '235');
  INSERT INTO `district` VALUES ('1773', '鼎湖区', '235');
  INSERT INTO `district` VALUES ('1774', '广宁县', '235');
  INSERT INTO `district` VALUES ('1775', '怀集县', '235');
  INSERT INTO `district` VALUES ('1776', '封开县', '235');
  INSERT INTO `district` VALUES ('1777', '德庆县', '235');
  INSERT INTO `district` VALUES ('1778', '高要市', '235');
  INSERT INTO `district` VALUES ('1779', '四会市', '235');
  INSERT INTO `district` VALUES ('1780', '惠城区', '236');
  INSERT INTO `district` VALUES ('1781', '惠阳区', '236');
  INSERT INTO `district` VALUES ('1782', '博罗县', '236');
  INSERT INTO `district` VALUES ('1783', '惠东县', '236');
  INSERT INTO `district` VALUES ('1784', '龙门县', '236');
  INSERT INTO `district` VALUES ('1785', '梅江区', '237');
  INSERT INTO `district` VALUES ('1786', '梅　县', '237');
  INSERT INTO `district` VALUES ('1787', '大埔县', '237');
  INSERT INTO `district` VALUES ('1788', '丰顺县', '237');
  INSERT INTO `district` VALUES ('1789', '五华县', '237');
  INSERT INTO `district` VALUES ('1790', '平远县', '237');
  INSERT INTO `district` VALUES ('1791', '蕉岭县', '237');
  INSERT INTO `district` VALUES ('1792', '兴宁市', '237');
  INSERT INTO `district` VALUES ('1793', '城　区', '238');
  INSERT INTO `district` VALUES ('1794', '海丰县', '238');
  INSERT INTO `district` VALUES ('1795', '陆河县', '238');
  INSERT INTO `district` VALUES ('1796', '陆丰市', '238');
  INSERT INTO `district` VALUES ('1797', '源城区', '239');
  INSERT INTO `district` VALUES ('1798', '紫金县', '239');
  INSERT INTO `district` VALUES ('1799', '龙川县', '239');
  INSERT INTO `district` VALUES ('1800', '连平县', '239');
  INSERT INTO `district` VALUES ('1801', '和平县', '239');
  INSERT INTO `district` VALUES ('1802', '东源县', '239');
  INSERT INTO `district` VALUES ('1803', '江城区', '240');
  INSERT INTO `district` VALUES ('1804', '阳西县', '240');
  INSERT INTO `district` VALUES ('1805', '阳东县', '240');
  INSERT INTO `district` VALUES ('1806', '阳春市', '240');
  INSERT INTO `district` VALUES ('1807', '清城区', '241');
  INSERT INTO `district` VALUES ('1808', '佛冈县', '241');
  INSERT INTO `district` VALUES ('1809', '阳山县', '241');
  INSERT INTO `district` VALUES ('1810', '连山壮族瑶族自治县', '241');
  INSERT INTO `district` VALUES ('1811', '连南瑶族自治县', '241');
  INSERT INTO `district` VALUES ('1812', '清新县', '241');
  INSERT INTO `district` VALUES ('1813', '英德市', '241');
  INSERT INTO `district` VALUES ('1814', '连州市', '241');
  INSERT INTO `district` VALUES ('1815', '东莞市', '241');
  INSERT INTO `district` VALUES ('1816', '中山市', '241');
  INSERT INTO `district` VALUES ('1817', '湘桥区', '242');
  INSERT INTO `district` VALUES ('1818', '潮安县', '242');
  INSERT INTO `district` VALUES ('1819', '饶平县', '242');
  INSERT INTO `district` VALUES ('1820', '榕城区', '243');
  INSERT INTO `district` VALUES ('1821', '揭东县', '243');
  INSERT INTO `district` VALUES ('1822', '揭西县', '243');
  INSERT INTO `district` VALUES ('1823', '惠来县', '243');
  INSERT INTO `district` VALUES ('1824', '普宁市', '243');
  INSERT INTO `district` VALUES ('1825', '云城区', '244');
  INSERT INTO `district` VALUES ('1826', '新兴县', '244');
  INSERT INTO `district` VALUES ('1827', '郁南县', '244');
  INSERT INTO `district` VALUES ('1828', '云安县', '244');
  INSERT INTO `district` VALUES ('1829', '罗定市', '244');
  INSERT INTO `district` VALUES ('1830', '兴宁区', '245');
  INSERT INTO `district` VALUES ('1831', '青秀区', '245');
  INSERT INTO `district` VALUES ('1832', '江南区', '245');
  INSERT INTO `district` VALUES ('1833', '西乡塘区', '245');
  INSERT INTO `district` VALUES ('1834', '良庆区', '245');
  INSERT INTO `district` VALUES ('1835', '邕宁区', '245');
  INSERT INTO `district` VALUES ('1836', '武鸣县', '245');
  INSERT INTO `district` VALUES ('1837', '隆安县', '245');
  INSERT INTO `district` VALUES ('1838', '马山县', '245');
  INSERT INTO `district` VALUES ('1839', '上林县', '245');
  INSERT INTO `district` VALUES ('1840', '宾阳县', '245');
  INSERT INTO `district` VALUES ('1841', '横　县', '245');
  INSERT INTO `district` VALUES ('1842', '城中区', '246');
  INSERT INTO `district` VALUES ('1843', '鱼峰区', '246');
  INSERT INTO `district` VALUES ('1844', '柳南区', '246');
  INSERT INTO `district` VALUES ('1845', '柳北区', '246');
  INSERT INTO `district` VALUES ('1846', '柳江县', '246');
  INSERT INTO `district` VALUES ('1847', '柳城县', '246');
  INSERT INTO `district` VALUES ('1848', '鹿寨县', '246');
  INSERT INTO `district` VALUES ('1849', '融安县', '246');
  INSERT INTO `district` VALUES ('1850', '融水苗族自治县', '246');
  INSERT INTO `district` VALUES ('1851', '三江侗族自治县', '246');
  INSERT INTO `district` VALUES ('1852', '秀峰区', '247');
  INSERT INTO `district` VALUES ('1853', '叠彩区', '247');
  INSERT INTO `district` VALUES ('1854', '象山区', '247');
  INSERT INTO `district` VALUES ('1855', '七星区', '247');
  INSERT INTO `district` VALUES ('1856', '雁山区', '247');
  INSERT INTO `district` VALUES ('1857', '阳朔县', '247');
  INSERT INTO `district` VALUES ('1858', '临桂县', '247');
  INSERT INTO `district` VALUES ('1859', '灵川县', '247');
  INSERT INTO `district` VALUES ('1860', '全州县', '247');
  INSERT INTO `district` VALUES ('1861', '兴安县', '247');
  INSERT INTO `district` VALUES ('1862', '永福县', '247');
  INSERT INTO `district` VALUES ('1863', '灌阳县', '247');
  INSERT INTO `district` VALUES ('1864', '龙胜各族自治县', '247');
  INSERT INTO `district` VALUES ('1865', '资源县', '247');
  INSERT INTO `district` VALUES ('1866', '平乐县', '247');
  INSERT INTO `district` VALUES ('1867', '荔蒲县', '247');
  INSERT INTO `district` VALUES ('1868', '恭城瑶族自治县', '247');
  INSERT INTO `district` VALUES ('1869', '万秀区', '248');
  INSERT INTO `district` VALUES ('1870', '蝶山区', '248');
  INSERT INTO `district` VALUES ('1871', '长洲区', '248');
  INSERT INTO `district` VALUES ('1872', '苍梧县', '248');
  INSERT INTO `district` VALUES ('1873', '藤　县', '248');
  INSERT INTO `district` VALUES ('1874', '蒙山县', '248');
  INSERT INTO `district` VALUES ('1875', '岑溪市', '248');
  INSERT INTO `district` VALUES ('1876', '海城区', '249');
  INSERT INTO `district` VALUES ('1877', '银海区', '249');
  INSERT INTO `district` VALUES ('1878', '铁山港区', '249');
  INSERT INTO `district` VALUES ('1879', '合浦县', '249');
  INSERT INTO `district` VALUES ('1880', '港口区', '250');
  INSERT INTO `district` VALUES ('1881', '防城区', '250');
  INSERT INTO `district` VALUES ('1882', '上思县', '250');
  INSERT INTO `district` VALUES ('1883', '东兴市', '250');
  INSERT INTO `district` VALUES ('1884', '钦南区', '251');
  INSERT INTO `district` VALUES ('1885', '钦北区', '251');
  INSERT INTO `district` VALUES ('1886', '灵山县', '251');
  INSERT INTO `district` VALUES ('1887', '浦北县', '251');
  INSERT INTO `district` VALUES ('1888', '港北区', '252');
  INSERT INTO `district` VALUES ('1889', '港南区', '252');
  INSERT INTO `district` VALUES ('1890', '覃塘区', '252');
  INSERT INTO `district` VALUES ('1891', '平南县', '252');
  INSERT INTO `district` VALUES ('1892', '桂平市', '252');
  INSERT INTO `district` VALUES ('1893', '玉州区', '253');
  INSERT INTO `district` VALUES ('1894', '容　县', '253');
  INSERT INTO `district` VALUES ('1895', '陆川县', '253');
  INSERT INTO `district` VALUES ('1896', '博白县', '253');
  INSERT INTO `district` VALUES ('1897', '兴业县', '253');
  INSERT INTO `district` VALUES ('1898', '北流市', '253');
  INSERT INTO `district` VALUES ('1899', '右江区', '254');
  INSERT INTO `district` VALUES ('1900', '田阳县', '254');
  INSERT INTO `district` VALUES ('1901', '田东县', '254');
  INSERT INTO `district` VALUES ('1902', '平果县', '254');
  INSERT INTO `district` VALUES ('1903', '德保县', '254');
  INSERT INTO `district` VALUES ('1904', '靖西县', '254');
  INSERT INTO `district` VALUES ('1905', '那坡县', '254');
  INSERT INTO `district` VALUES ('1906', '凌云县', '254');
  INSERT INTO `district` VALUES ('1907', '乐业县', '254');
  INSERT INTO `district` VALUES ('1908', '田林县', '254');
  INSERT INTO `district` VALUES ('1909', '西林县', '254');
  INSERT INTO `district` VALUES ('1910', '隆林各族自治县', '254');
  INSERT INTO `district` VALUES ('1911', '八步区', '255');
  INSERT INTO `district` VALUES ('1912', '昭平县', '255');
  INSERT INTO `district` VALUES ('1913', '钟山县', '255');
  INSERT INTO `district` VALUES ('1914', '富川瑶族自治县', '255');
  INSERT INTO `district` VALUES ('1915', '金城江区', '256');
  INSERT INTO `district` VALUES ('1916', '南丹县', '256');
  INSERT INTO `district` VALUES ('1917', '天峨县', '256');
  INSERT INTO `district` VALUES ('1918', '凤山县', '256');
  INSERT INTO `district` VALUES ('1919', '东兰县', '256');
  INSERT INTO `district` VALUES ('1920', '罗城仫佬族自治县', '256');
  INSERT INTO `district` VALUES ('1921', '环江毛南族自治县', '256');
  INSERT INTO `district` VALUES ('1922', '巴马瑶族自治县', '256');
  INSERT INTO `district` VALUES ('1923', '都安瑶族自治县', '256');
  INSERT INTO `district` VALUES ('1924', '大化瑶族自治县', '256');
  INSERT INTO `district` VALUES ('1925', '宜州市', '256');
  INSERT INTO `district` VALUES ('1926', '兴宾区', '257');
  INSERT INTO `district` VALUES ('1927', '忻城县', '257');
  INSERT INTO `district` VALUES ('1928', '象州县', '257');
  INSERT INTO `district` VALUES ('1929', '武宣县', '257');
  INSERT INTO `district` VALUES ('1930', '金秀瑶族自治县', '257');
  INSERT INTO `district` VALUES ('1931', '合山市', '257');
  INSERT INTO `district` VALUES ('1932', '江洲区', '258');
  INSERT INTO `district` VALUES ('1933', '扶绥县', '258');
  INSERT INTO `district` VALUES ('1934', '宁明县', '258');
  INSERT INTO `district` VALUES ('1935', '龙州县', '258');
  INSERT INTO `district` VALUES ('1936', '大新县', '258');
  INSERT INTO `district` VALUES ('1937', '天等县', '258');
  INSERT INTO `district` VALUES ('1938', '凭祥市', '258');
  INSERT INTO `district` VALUES ('1939', '秀英区', '259');
  INSERT INTO `district` VALUES ('1940', '龙华区', '259');
  INSERT INTO `district` VALUES ('1941', '琼山区', '259');
  INSERT INTO `district` VALUES ('1942', '美兰区', '259');
  INSERT INTO `district` VALUES ('1943', '五指山市', '260');
  INSERT INTO `district` VALUES ('1944', '琼海市', '260');
  INSERT INTO `district` VALUES ('1945', '儋州市', '260');
  INSERT INTO `district` VALUES ('1946', '文昌市', '260');
  INSERT INTO `district` VALUES ('1947', '万宁市', '260');
  INSERT INTO `district` VALUES ('1948', '东方市', '260');
  INSERT INTO `district` VALUES ('1949', '定安县', '260');
  INSERT INTO `district` VALUES ('1950', '屯昌县', '260');
  INSERT INTO `district` VALUES ('1951', '澄迈县', '260');
  INSERT INTO `district` VALUES ('1952', '临高县', '260');
  INSERT INTO `district` VALUES ('1953', '白沙黎族自治县', '260');
  INSERT INTO `district` VALUES ('1954', '昌江黎族自治县', '260');
  INSERT INTO `district` VALUES ('1955', '乐东黎族自治县', '260');
  INSERT INTO `district` VALUES ('1956', '陵水黎族自治县', '260');
  INSERT INTO `district` VALUES ('1957', '保亭黎族苗族自治县', '260');
  INSERT INTO `district` VALUES ('1958', '琼中黎族苗族自治县', '260');
  INSERT INTO `district` VALUES ('1959', '西沙群岛', '260');
  INSERT INTO `district` VALUES ('1960', '南沙群岛', '260');
  INSERT INTO `district` VALUES ('1961', '中沙群岛的岛礁及其海域', '260');
  INSERT INTO `district` VALUES ('1962', '万州区', '261');
  INSERT INTO `district` VALUES ('1963', '涪陵区', '261');
  INSERT INTO `district` VALUES ('1964', '渝中区', '261');
  INSERT INTO `district` VALUES ('1965', '大渡口区', '261');
  INSERT INTO `district` VALUES ('1966', '江北区', '261');
  INSERT INTO `district` VALUES ('1967', '沙坪坝区', '261');
  INSERT INTO `district` VALUES ('1968', '九龙坡区', '261');
  INSERT INTO `district` VALUES ('1969', '南岸区', '261');
  INSERT INTO `district` VALUES ('1970', '北碚区', '261');
  INSERT INTO `district` VALUES ('1971', '万盛区', '261');
  INSERT INTO `district` VALUES ('1972', '双桥区', '261');
  INSERT INTO `district` VALUES ('1973', '渝北区', '261');
  INSERT INTO `district` VALUES ('1974', '巴南区', '261');
  INSERT INTO `district` VALUES ('1975', '黔江区', '261');
  INSERT INTO `district` VALUES ('1976', '长寿区', '261');
  INSERT INTO `district` VALUES ('1977', '江津市', '261');
  INSERT INTO `district` VALUES ('1978', '合川市', '261');
  INSERT INTO `district` VALUES ('1979', '永川市', '261');
  INSERT INTO `district` VALUES ('1980', '南川市', '261');
  INSERT INTO `district` VALUES ('1981', '綦江县', '261');
  INSERT INTO `district` VALUES ('1982', '潼南县', '261');
  INSERT INTO `district` VALUES ('1983', '铜梁县', '261');
  INSERT INTO `district` VALUES ('1984', '大足县', '261');
  INSERT INTO `district` VALUES ('1985', '荣昌县', '261');
  INSERT INTO `district` VALUES ('1986', '璧山县', '261');
  INSERT INTO `district` VALUES ('1987', '梁平县', '261');
  INSERT INTO `district` VALUES ('1988', '城口县', '261');
  INSERT INTO `district` VALUES ('1989', '丰都县', '261');
  INSERT INTO `district` VALUES ('1990', '垫江县', '261');
  INSERT INTO `district` VALUES ('1991', '武隆县', '261');
  INSERT INTO `district` VALUES ('1992', '忠　县', '261');
  INSERT INTO `district` VALUES ('1993', '开　县', '261');
  INSERT INTO `district` VALUES ('1994', '云阳县', '261');
  INSERT INTO `district` VALUES ('1995', '奉节县', '261');
  INSERT INTO `district` VALUES ('1996', '巫山县', '261');
  INSERT INTO `district` VALUES ('1997', '巫溪县', '261');
  INSERT INTO `district` VALUES ('1998', '石柱土家族自治县', '261');
  INSERT INTO `district` VALUES ('1999', '秀山土家族苗族自治县', '261');
  INSERT INTO `district` VALUES ('2000', '酉阳土家族苗族自治县', '261');
  INSERT INTO `district` VALUES ('2001', '彭水苗族土家族自治县', '261');
  INSERT INTO `district` VALUES ('2002', '锦江区', '262');
  INSERT INTO `district` VALUES ('2003', '青羊区', '262');
  INSERT INTO `district` VALUES ('2004', '金牛区', '262');
  INSERT INTO `district` VALUES ('2005', '武侯区', '262');
  INSERT INTO `district` VALUES ('2006', '成华区', '262');
  INSERT INTO `district` VALUES ('2007', '龙泉驿区', '262');
  INSERT INTO `district` VALUES ('2008', '青白江区', '262');
  INSERT INTO `district` VALUES ('2009', '新都区', '262');
  INSERT INTO `district` VALUES ('2010', '温江区', '262');
  INSERT INTO `district` VALUES ('2011', '金堂县', '262');
  INSERT INTO `district` VALUES ('2012', '双流县', '262');
  INSERT INTO `district` VALUES ('2013', '郫　县', '262');
  INSERT INTO `district` VALUES ('2014', '大邑县', '262');
  INSERT INTO `district` VALUES ('2015', '蒲江县', '262');
  INSERT INTO `district` VALUES ('2016', '新津县', '262');
  INSERT INTO `district` VALUES ('2017', '都江堰市', '262');
  INSERT INTO `district` VALUES ('2018', '彭州市', '262');
  INSERT INTO `district` VALUES ('2019', '邛崃市', '262');
  INSERT INTO `district` VALUES ('2020', '崇州市', '262');
  INSERT INTO `district` VALUES ('2021', '自流井区', '263');
  INSERT INTO `district` VALUES ('2022', '贡井区', '263');
  INSERT INTO `district` VALUES ('2023', '大安区', '263');
  INSERT INTO `district` VALUES ('2024', '沿滩区', '263');
  INSERT INTO `district` VALUES ('2025', '荣　县', '263');
  INSERT INTO `district` VALUES ('2026', '富顺县', '263');
  INSERT INTO `district` VALUES ('2027', '东　区', '264');
  INSERT INTO `district` VALUES ('2028', '西　区', '264');
  INSERT INTO `district` VALUES ('2029', '仁和区', '264');
  INSERT INTO `district` VALUES ('2030', '米易县', '264');
  INSERT INTO `district` VALUES ('2031', '盐边县', '264');
  INSERT INTO `district` VALUES ('2032', '江阳区', '265');
  INSERT INTO `district` VALUES ('2033', '纳溪区', '265');
  INSERT INTO `district` VALUES ('2034', '龙马潭区', '265');
  INSERT INTO `district` VALUES ('2035', '泸　县', '265');
  INSERT INTO `district` VALUES ('2036', '合江县', '265');
  INSERT INTO `district` VALUES ('2037', '叙永县', '265');
  INSERT INTO `district` VALUES ('2038', '古蔺县', '265');
  INSERT INTO `district` VALUES ('2039', '旌阳区', '266');
  INSERT INTO `district` VALUES ('2040', '中江县', '266');
  INSERT INTO `district` VALUES ('2041', '罗江县', '266');
  INSERT INTO `district` VALUES ('2042', '广汉市', '266');
  INSERT INTO `district` VALUES ('2043', '什邡市', '266');
  INSERT INTO `district` VALUES ('2044', '绵竹市', '266');
  INSERT INTO `district` VALUES ('2045', '涪城区', '267');
  INSERT INTO `district` VALUES ('2046', '游仙区', '267');
  INSERT INTO `district` VALUES ('2047', '三台县', '267');
  INSERT INTO `district` VALUES ('2048', '盐亭县', '267');
  INSERT INTO `district` VALUES ('2049', '安　县', '267');
  INSERT INTO `district` VALUES ('2050', '梓潼县', '267');
  INSERT INTO `district` VALUES ('2051', '北川羌族自治县', '267');
  INSERT INTO `district` VALUES ('2052', '平武县', '267');
  INSERT INTO `district` VALUES ('2053', '江油市', '267');
  INSERT INTO `district` VALUES ('2054', '市中区', '268');
  INSERT INTO `district` VALUES ('2055', '元坝区', '268');
  INSERT INTO `district` VALUES ('2056', '朝天区', '268');
  INSERT INTO `district` VALUES ('2057', '旺苍县', '268');
  INSERT INTO `district` VALUES ('2058', '青川县', '268');
  INSERT INTO `district` VALUES ('2059', '剑阁县', '268');
  INSERT INTO `district` VALUES ('2060', '苍溪县', '268');
  INSERT INTO `district` VALUES ('2061', '船山区', '269');
  INSERT INTO `district` VALUES ('2062', '安居区', '269');
  INSERT INTO `district` VALUES ('2063', '蓬溪县', '269');
  INSERT INTO `district` VALUES ('2064', '射洪县', '269');
  INSERT INTO `district` VALUES ('2065', '大英县', '269');
  INSERT INTO `district` VALUES ('2066', '市中区', '270');
  INSERT INTO `district` VALUES ('2067', '东兴区', '270');
  INSERT INTO `district` VALUES ('2068', '威远县', '270');
  INSERT INTO `district` VALUES ('2069', '资中县', '270');
  INSERT INTO `district` VALUES ('2070', '隆昌县', '270');
  INSERT INTO `district` VALUES ('2071', '市中区', '271');
  INSERT INTO `district` VALUES ('2072', '沙湾区', '271');
  INSERT INTO `district` VALUES ('2073', '五通桥区', '271');
  INSERT INTO `district` VALUES ('2074', '金口河区', '271');
  INSERT INTO `district` VALUES ('2075', '犍为县', '271');
  INSERT INTO `district` VALUES ('2076', '井研县', '271');
  INSERT INTO `district` VALUES ('2077', '夹江县', '271');
  INSERT INTO `district` VALUES ('2078', '沐川县', '271');
  INSERT INTO `district` VALUES ('2079', '峨边彝族自治县', '271');
  INSERT INTO `district` VALUES ('2080', '马边彝族自治县', '271');
  INSERT INTO `district` VALUES ('2081', '峨眉山市', '271');
  INSERT INTO `district` VALUES ('2082', '顺庆区', '272');
  INSERT INTO `district` VALUES ('2083', '高坪区', '272');
  INSERT INTO `district` VALUES ('2084', '嘉陵区', '272');
  INSERT INTO `district` VALUES ('2085', '南部县', '272');
  INSERT INTO `district` VALUES ('2086', '营山县', '272');
  INSERT INTO `district` VALUES ('2087', '蓬安县', '272');
  INSERT INTO `district` VALUES ('2088', '仪陇县', '272');
  INSERT INTO `district` VALUES ('2089', '西充县', '272');
  INSERT INTO `district` VALUES ('2090', '阆中市', '272');
  INSERT INTO `district` VALUES ('2091', '东坡区', '273');
  INSERT INTO `district` VALUES ('2092', '仁寿县', '273');
  INSERT INTO `district` VALUES ('2093', '彭山县', '273');
  INSERT INTO `district` VALUES ('2094', '洪雅县', '273');
  INSERT INTO `district` VALUES ('2095', '丹棱县', '273');
  INSERT INTO `district` VALUES ('2096', '青神县', '273');
  INSERT INTO `district` VALUES ('2097', '翠屏区', '274');
  INSERT INTO `district` VALUES ('2098', '宜宾县', '274');
  INSERT INTO `district` VALUES ('2099', '南溪县', '274');
  INSERT INTO `district` VALUES ('2100', '江安县', '274');
  INSERT INTO `district` VALUES ('2101', '长宁县', '274');
  INSERT INTO `district` VALUES ('2102', '高　县', '274');
  INSERT INTO `district` VALUES ('2103', '珙　县', '274');
  INSERT INTO `district` VALUES ('2104', '筠连县', '274');
  INSERT INTO `district` VALUES ('2105', '兴文县', '274');
  INSERT INTO `district` VALUES ('2106', '屏山县', '274');
  INSERT INTO `district` VALUES ('2107', '广安区', '275');
  INSERT INTO `district` VALUES ('2108', '岳池县', '275');
  INSERT INTO `district` VALUES ('2109', '武胜县', '275');
  INSERT INTO `district` VALUES ('2110', '邻水县', '275');
  INSERT INTO `district` VALUES ('2111', '华蓥市', '275');
  INSERT INTO `district` VALUES ('2112', '通川区', '276');
  INSERT INTO `district` VALUES ('2113', '达　县', '276');
  INSERT INTO `district` VALUES ('2114', '宣汉县', '276');
  INSERT INTO `district` VALUES ('2115', '开江县', '276');
  INSERT INTO `district` VALUES ('2116', '大竹县', '276');
  INSERT INTO `district` VALUES ('2117', '渠　县', '276');
  INSERT INTO `district` VALUES ('2118', '万源市', '276');
  INSERT INTO `district` VALUES ('2119', '雨城区', '277');
  INSERT INTO `district` VALUES ('2120', '名山县', '277');
  INSERT INTO `district` VALUES ('2121', '荥经县', '277');
  INSERT INTO `district` VALUES ('2122', '汉源县', '277');
  INSERT INTO `district` VALUES ('2123', '石棉县', '277');
  INSERT INTO `district` VALUES ('2124', '天全县', '277');
  INSERT INTO `district` VALUES ('2125', '芦山县', '277');
  INSERT INTO `district` VALUES ('2126', '宝兴县', '277');
  INSERT INTO `district` VALUES ('2127', '巴州区', '278');
  INSERT INTO `district` VALUES ('2128', '通江县', '278');
  INSERT INTO `district` VALUES ('2129', '南江县', '278');
  INSERT INTO `district` VALUES ('2130', '平昌县', '278');
  INSERT INTO `district` VALUES ('2131', '雁江区', '279');
  INSERT INTO `district` VALUES ('2132', '安岳县', '279');
  INSERT INTO `district` VALUES ('2133', '乐至县', '279');
  INSERT INTO `district` VALUES ('2134', '简阳市', '279');
  INSERT INTO `district` VALUES ('2135', '汶川县', '280');
  INSERT INTO `district` VALUES ('2136', '理　县', '280');
  INSERT INTO `district` VALUES ('2137', '茂　县', '280');
  INSERT INTO `district` VALUES ('2138', '松潘县', '280');
  INSERT INTO `district` VALUES ('2139', '九寨沟县', '280');
  INSERT INTO `district` VALUES ('2140', '金川县', '280');
  INSERT INTO `district` VALUES ('2141', '小金县', '280');
  INSERT INTO `district` VALUES ('2142', '黑水县', '280');
  INSERT INTO `district` VALUES ('2143', '马尔康县', '280');
  INSERT INTO `district` VALUES ('2144', '壤塘县', '280');
  INSERT INTO `district` VALUES ('2145', '阿坝县', '280');
  INSERT INTO `district` VALUES ('2146', '若尔盖县', '280');
  INSERT INTO `district` VALUES ('2147', '红原县', '280');
  INSERT INTO `district` VALUES ('2148', '康定县', '281');
  INSERT INTO `district` VALUES ('2149', '泸定县', '281');
  INSERT INTO `district` VALUES ('2150', '丹巴县', '281');
  INSERT INTO `district` VALUES ('2151', '九龙县', '281');
  INSERT INTO `district` VALUES ('2152', '雅江县', '281');
  INSERT INTO `district` VALUES ('2153', '道孚县', '281');
  INSERT INTO `district` VALUES ('2154', '炉霍县', '281');
  INSERT INTO `district` VALUES ('2155', '甘孜县', '281');
  INSERT INTO `district` VALUES ('2156', '新龙县', '281');
  INSERT INTO `district` VALUES ('2157', '德格县', '281');
  INSERT INTO `district` VALUES ('2158', '白玉县', '281');
  INSERT INTO `district` VALUES ('2159', '石渠县', '281');
  INSERT INTO `district` VALUES ('2160', '色达县', '281');
  INSERT INTO `district` VALUES ('2161', '理塘县', '281');
  INSERT INTO `district` VALUES ('2162', '巴塘县', '281');
  INSERT INTO `district` VALUES ('2163', '乡城县', '281');
  INSERT INTO `district` VALUES ('2164', '稻城县', '281');
  INSERT INTO `district` VALUES ('2165', '得荣县', '281');
  INSERT INTO `district` VALUES ('2166', '西昌市', '282');
  INSERT INTO `district` VALUES ('2167', '木里藏族自治县', '282');
  INSERT INTO `district` VALUES ('2168', '盐源县', '282');
  INSERT INTO `district` VALUES ('2169', '德昌县', '282');
  INSERT INTO `district` VALUES ('2170', '会理县', '282');
  INSERT INTO `district` VALUES ('2171', '会东县', '282');
  INSERT INTO `district` VALUES ('2172', '宁南县', '282');
  INSERT INTO `district` VALUES ('2173', '普格县', '282');
  INSERT INTO `district` VALUES ('2174', '布拖县', '282');
  INSERT INTO `district` VALUES ('2175', '金阳县', '282');
  INSERT INTO `district` VALUES ('2176', '昭觉县', '282');
  INSERT INTO `district` VALUES ('2177', '喜德县', '282');
  INSERT INTO `district` VALUES ('2178', '冕宁县', '282');
  INSERT INTO `district` VALUES ('2179', '越西县', '282');
  INSERT INTO `district` VALUES ('2180', '甘洛县', '282');
  INSERT INTO `district` VALUES ('2181', '美姑县', '282');
  INSERT INTO `district` VALUES ('2182', '雷波县', '282');
  INSERT INTO `district` VALUES ('2183', '南明区', '283');
  INSERT INTO `district` VALUES ('2184', '云岩区', '283');
  INSERT INTO `district` VALUES ('2185', '花溪区', '23');
  INSERT INTO `district` VALUES ('2186', '乌当区', '283');
  INSERT INTO `district` VALUES ('2187', '白云区', '283');
  INSERT INTO `district` VALUES ('2188', '小河区', '283');
  INSERT INTO `district` VALUES ('2189', '开阳县', '283');
  INSERT INTO `district` VALUES ('2190', '息烽县', '283');
  INSERT INTO `district` VALUES ('2191', '修文县', '283');
  INSERT INTO `district` VALUES ('2192', '清镇市', '283');
  INSERT INTO `district` VALUES ('2193', '钟山区', '284');
  INSERT INTO `district` VALUES ('2194', '六枝特区', '284');
  INSERT INTO `district` VALUES ('2195', '水城县', '284');
  INSERT INTO `district` VALUES ('2196', '盘　县', '284');
  INSERT INTO `district` VALUES ('2197', '红花岗区', '285');
  INSERT INTO `district` VALUES ('2198', '汇川区', '285');
  INSERT INTO `district` VALUES ('2199', '遵义县', '285');
  INSERT INTO `district` VALUES ('2200', '桐梓县', '285');
  INSERT INTO `district` VALUES ('2201', '绥阳县', '285');
  INSERT INTO `district` VALUES ('2202', '正安县', '285');
  INSERT INTO `district` VALUES ('2203', '道真仡佬族苗族自治县', '285');
  INSERT INTO `district` VALUES ('2204', '务川仡佬族苗族自治县', '285');
  INSERT INTO `district` VALUES ('2205', '凤冈县', '285');
  INSERT INTO `district` VALUES ('2206', '湄潭县', '285');
  INSERT INTO `district` VALUES ('2207', '余庆县', '285');
  INSERT INTO `district` VALUES ('2208', '习水县', '285');
  INSERT INTO `district` VALUES ('2209', '赤水市', '285');
  INSERT INTO `district` VALUES ('2210', '仁怀市', '285');
  INSERT INTO `district` VALUES ('2211', '西秀区', '286');
  INSERT INTO `district` VALUES ('2212', '平坝县', '286');
  INSERT INTO `district` VALUES ('2213', '普定县', '286');
  INSERT INTO `district` VALUES ('2214', '镇宁布依族苗族自治县', '286');
  INSERT INTO `district` VALUES ('2215', '关岭布依族苗族自治县', '286');
  INSERT INTO `district` VALUES ('2216', '紫云苗族布依族自治县', '286');
  INSERT INTO `district` VALUES ('2217', '铜仁市', '287');
  INSERT INTO `district` VALUES ('2218', '江口县', '287');
  INSERT INTO `district` VALUES ('2219', '玉屏侗族自治县', '287');
  INSERT INTO `district` VALUES ('2220', '石阡县', '287');
  INSERT INTO `district` VALUES ('2221', '思南县', '287');
  INSERT INTO `district` VALUES ('2222', '印江土家族苗族自治县', '287');
  INSERT INTO `district` VALUES ('2223', '德江县', '287');
  INSERT INTO `district` VALUES ('2224', '沿河土家族自治县', '287');
  INSERT INTO `district` VALUES ('2225', '松桃苗族自治县', '287');
  INSERT INTO `district` VALUES ('2226', '万山特区', '287');
  INSERT INTO `district` VALUES ('2227', '兴义市', '288');
  INSERT INTO `district` VALUES ('2228', '兴仁县', '288');
  INSERT INTO `district` VALUES ('2229', '普安县', '288');
  INSERT INTO `district` VALUES ('2230', '晴隆县', '288');
  INSERT INTO `district` VALUES ('2231', '贞丰县', '288');
  INSERT INTO `district` VALUES ('2232', '望谟县', '288');
  INSERT INTO `district` VALUES ('2233', '册亨县', '288');
  INSERT INTO `district` VALUES ('2234', '安龙县', '288');
  INSERT INTO `district` VALUES ('2235', '毕节市', '289');
  INSERT INTO `district` VALUES ('2236', '大方县', '289');
  INSERT INTO `district` VALUES ('2237', '黔西县', '289');
  INSERT INTO `district` VALUES ('2238', '金沙县', '289');
  INSERT INTO `district` VALUES ('2239', '织金县', '289');
  INSERT INTO `district` VALUES ('2240', '纳雍县', '289');
  INSERT INTO `district` VALUES ('2241', '威宁彝族回族苗族自治县', '289');
  INSERT INTO `district` VALUES ('2242', '赫章县', '289');
  INSERT INTO `district` VALUES ('2243', '凯里市', '290');
  INSERT INTO `district` VALUES ('2244', '黄平县', '290');
  INSERT INTO `district` VALUES ('2245', '施秉县', '290');
  INSERT INTO `district` VALUES ('2246', '三穗县', '290');
  INSERT INTO `district` VALUES ('2247', '镇远县', '290');
  INSERT INTO `district` VALUES ('2248', '岑巩县', '290');
  INSERT INTO `district` VALUES ('2249', '天柱县', '290');
  INSERT INTO `district` VALUES ('2250', '锦屏县', '290');
  INSERT INTO `district` VALUES ('2251', '剑河县', '290');
  INSERT INTO `district` VALUES ('2252', '台江县', '290');
  INSERT INTO `district` VALUES ('2253', '黎平县', '290');
  INSERT INTO `district` VALUES ('2254', '榕江县', '290');
  INSERT INTO `district` VALUES ('2255', '从江县', '290');
  INSERT INTO `district` VALUES ('2256', '雷山县', '290');
  INSERT INTO `district` VALUES ('2257', '麻江县', '290');
  INSERT INTO `district` VALUES ('2258', '丹寨县', '290');
  INSERT INTO `district` VALUES ('2259', '都匀市', '291');
  INSERT INTO `district` VALUES ('2260', '福泉市', '291');
  INSERT INTO `district` VALUES ('2261', '荔波县', '291');
  INSERT INTO `district` VALUES ('2262', '贵定县', '291');
  INSERT INTO `district` VALUES ('2263', '瓮安县', '291');
  INSERT INTO `district` VALUES ('2264', '独山县', '291');
  INSERT INTO `district` VALUES ('2265', '平塘县', '291');
  INSERT INTO `district` VALUES ('2266', '罗甸县', '291');
  INSERT INTO `district` VALUES ('2267', '长顺县', '291');
  INSERT INTO `district` VALUES ('2268', '龙里县', '291');
  INSERT INTO `district` VALUES ('2269', '惠水县', '291');
  INSERT INTO `district` VALUES ('2270', '三都水族自治县', '291');
  INSERT INTO `district` VALUES ('2271', '五华区', '292');
  INSERT INTO `district` VALUES ('2272', '盘龙区', '292');
  INSERT INTO `district` VALUES ('2273', '官渡区', '292');
  INSERT INTO `district` VALUES ('2274', '西山区', '292');
  INSERT INTO `district` VALUES ('2275', '东川区', '292');
  INSERT INTO `district` VALUES ('2276', '呈贡县', '292');
  INSERT INTO `district` VALUES ('2277', '晋宁县', '292');
  INSERT INTO `district` VALUES ('2278', '富民县', '292');
  INSERT INTO `district` VALUES ('2279', '宜良县', '292');
  INSERT INTO `district` VALUES ('2280', '石林彝族自治县', '292');
  INSERT INTO `district` VALUES ('2281', '嵩明县', '292');
  INSERT INTO `district` VALUES ('2282', '禄劝彝族苗族自治县', '292');
  INSERT INTO `district` VALUES ('2283', '寻甸回族彝族自治县', '292');
  INSERT INTO `district` VALUES ('2284', '安宁市', '292');
  INSERT INTO `district` VALUES ('2285', '麒麟区', '293');
  INSERT INTO `district` VALUES ('2286', '马龙县', '293');
  INSERT INTO `district` VALUES ('2287', '陆良县', '293');
  INSERT INTO `district` VALUES ('2288', '师宗县', '293');
  INSERT INTO `district` VALUES ('2289', '罗平县', '293');
  INSERT INTO `district` VALUES ('2290', '富源县', '293');
  INSERT INTO `district` VALUES ('2291', '会泽县', '293');
  INSERT INTO `district` VALUES ('2292', '沾益县', '293');
  INSERT INTO `district` VALUES ('2293', '宣威市', '293');
  INSERT INTO `district` VALUES ('2294', '红塔区', '294');
  INSERT INTO `district` VALUES ('2295', '江川县', '294');
  INSERT INTO `district` VALUES ('2296', '澄江县', '294');
  INSERT INTO `district` VALUES ('2297', '通海县', '294');
  INSERT INTO `district` VALUES ('2298', '华宁县', '294');
  INSERT INTO `district` VALUES ('2299', '易门县', '294');
  INSERT INTO `district` VALUES ('2300', '峨山彝族自治县', '294');
  INSERT INTO `district` VALUES ('2301', '新平彝族傣族自治县', '294');
  INSERT INTO `district` VALUES ('2302', '元江哈尼族彝族傣族自治县', '294');
  INSERT INTO `district` VALUES ('2303', '隆阳区', '295');
  INSERT INTO `district` VALUES ('2304', '施甸县', '295');
  INSERT INTO `district` VALUES ('2305', '腾冲县', '295');
  INSERT INTO `district` VALUES ('2306', '龙陵县', '295');
  INSERT INTO `district` VALUES ('2307', '昌宁县', '295');
  INSERT INTO `district` VALUES ('2308', '昭阳区', '296');
  INSERT INTO `district` VALUES ('2309', '鲁甸县', '296');
  INSERT INTO `district` VALUES ('2310', '巧家县', '296');
  INSERT INTO `district` VALUES ('2311', '盐津县', '296');
  INSERT INTO `district` VALUES ('2312', '大关县', '296');
  INSERT INTO `district` VALUES ('2313', '永善县', '296');
  INSERT INTO `district` VALUES ('2314', '绥江县', '296');
  INSERT INTO `district` VALUES ('2315', '镇雄县', '296');
  INSERT INTO `district` VALUES ('2316', '彝良县', '296');
  INSERT INTO `district` VALUES ('2317', '威信县', '296');
  INSERT INTO `district` VALUES ('2318', '水富县', '296');
  INSERT INTO `district` VALUES ('2319', '古城区', '297');
  INSERT INTO `district` VALUES ('2320', '玉龙纳西族自治县', '297');
  INSERT INTO `district` VALUES ('2321', '永胜县', '297');
  INSERT INTO `district` VALUES ('2322', '华坪县', '297');
  INSERT INTO `district` VALUES ('2323', '宁蒗彝族自治县', '297');
  INSERT INTO `district` VALUES ('2324', '思茅区', '298');
  INSERT INTO `district` VALUES ('2325', '宁洱哈尼族彝族自治县', '298');
  INSERT INTO `district` VALUES ('2326', '墨江哈尼族自治县', '298');
  INSERT INTO `district` VALUES ('2327', '景东彝族自治县', '298');
  INSERT INTO `district` VALUES ('2328', '景谷傣族彝族自治县', '298');
  INSERT INTO `district` VALUES ('2329', '镇沅彝族哈尼族拉祜族自治县', '298');
  INSERT INTO `district` VALUES ('2330', '江城哈尼族彝族自治县', '298');
  INSERT INTO `district` VALUES ('2331', '孟连傣族拉祜族佤族自治县', '298');
  INSERT INTO `district` VALUES ('2332', '澜沧拉祜族自治县', '298');
  INSERT INTO `district` VALUES ('2333', '西盟佤族自治县', '298');
  INSERT INTO `district` VALUES ('2334', '临翔区', '299');
  INSERT INTO `district` VALUES ('2335', '凤庆县', '299');
  INSERT INTO `district` VALUES ('2336', '云　县', '299');
  INSERT INTO `district` VALUES ('2337', '永德县', '299');
  INSERT INTO `district` VALUES ('2338', '镇康县', '299');
  INSERT INTO `district` VALUES ('2339', '双江拉祜族佤族布朗族傣族自治县', '299');
  INSERT INTO `district` VALUES ('2340', '耿马傣族佤族自治县', '299');
  INSERT INTO `district` VALUES ('2341', '沧源佤族自治县', '299');
  INSERT INTO `district` VALUES ('2342', '楚雄市', '300');
  INSERT INTO `district` VALUES ('2343', '双柏县', '300');
  INSERT INTO `district` VALUES ('2344', '牟定县', '300');
  INSERT INTO `district` VALUES ('2345', '南华县', '300');
  INSERT INTO `district` VALUES ('2346', '姚安县', '300');
  INSERT INTO `district` VALUES ('2347', '大姚县', '300');
  INSERT INTO `district` VALUES ('2348', '永仁县', '300');
  INSERT INTO `district` VALUES ('2349', '元谋县', '300');
  INSERT INTO `district` VALUES ('2350', '武定县', '300');
  INSERT INTO `district` VALUES ('2351', '禄丰县', '300');
  INSERT INTO `district` VALUES ('2352', '个旧市', '301');
  INSERT INTO `district` VALUES ('2353', '开远市', '301');
  INSERT INTO `district` VALUES ('2354', '蒙自县', '301');
  INSERT INTO `district` VALUES ('2355', '屏边苗族自治县', '301');
  INSERT INTO `district` VALUES ('2356', '建水县', '301');
  INSERT INTO `district` VALUES ('2357', '石屏县', '301');
  INSERT INTO `district` VALUES ('2358', '弥勒县', '301');
  INSERT INTO `district` VALUES ('2359', '泸西县', '301');
  INSERT INTO `district` VALUES ('2360', '元阳县', '301');
  INSERT INTO `district` VALUES ('2361', '红河县', '301');
  INSERT INTO `district` VALUES ('2362', '金平苗族瑶族傣族自治县', '301');
  INSERT INTO `district` VALUES ('2363', '绿春县', '301');
  INSERT INTO `district` VALUES ('2364', '河口瑶族自治县', '301');
  INSERT INTO `district` VALUES ('2365', '文山县', '302');
  INSERT INTO `district` VALUES ('2366', '砚山县', '302');
  INSERT INTO `district` VALUES ('2367', '西畴县', '302');
  INSERT INTO `district` VALUES ('2368', '麻栗坡县', '302');
  INSERT INTO `district` VALUES ('2369', '马关县', '302');
  INSERT INTO `district` VALUES ('2370', '丘北县', '302');
  INSERT INTO `district` VALUES ('2371', '广南县', '302');
  INSERT INTO `district` VALUES ('2372', '富宁县', '302');
  INSERT INTO `district` VALUES ('2373', '景洪市', '303');
  INSERT INTO `district` VALUES ('2374', '勐海县', '303');
  INSERT INTO `district` VALUES ('2375', '勐腊县', '303');
  INSERT INTO `district` VALUES ('2376', '大理市', '304');
  INSERT INTO `district` VALUES ('2377', '漾濞彝族自治县', '304');
  INSERT INTO `district` VALUES ('2378', '祥云县', '304');
  INSERT INTO `district` VALUES ('2379', '宾川县', '304');
  INSERT INTO `district` VALUES ('2380', '弥渡县', '304');
  INSERT INTO `district` VALUES ('2381', '南涧彝族自治县', '304');
  INSERT INTO `district` VALUES ('2382', '巍山彝族回族自治县', '304');
  INSERT INTO `district` VALUES ('2383', '永平县', '304');
  INSERT INTO `district` VALUES ('2384', '云龙县', '304');
  INSERT INTO `district` VALUES ('2385', '洱源县', '304');
  INSERT INTO `district` VALUES ('2386', '剑川县', '304');
  INSERT INTO `district` VALUES ('2387', '鹤庆县', '304');
  INSERT INTO `district` VALUES ('2388', '瑞丽市', '305');
  INSERT INTO `district` VALUES ('2389', '潞西市', '305');
  INSERT INTO `district` VALUES ('2390', '梁河县', '305');
  INSERT INTO `district` VALUES ('2391', '盈江县', '305');
  INSERT INTO `district` VALUES ('2392', '陇川县', '305');
  INSERT INTO `district` VALUES ('2393', '泸水县', '306');
  INSERT INTO `district` VALUES ('2394', '福贡县', '306');
  INSERT INTO `district` VALUES ('2395', '贡山独龙族怒族自治县', '306');
  INSERT INTO `district` VALUES ('2396', '兰坪白族普米族自治县', '306');
  INSERT INTO `district` VALUES ('2397', '香格里拉县', '307');
  INSERT INTO `district` VALUES ('2398', '德钦县', '307');
  INSERT INTO `district` VALUES ('2399', '维西傈僳族自治县', '307');
  INSERT INTO `district` VALUES ('2400', '城关区', '308');
  INSERT INTO `district` VALUES ('2401', '林周县', '308');
  INSERT INTO `district` VALUES ('2402', '当雄县', '308');
  INSERT INTO `district` VALUES ('2403', '尼木县', '308');
  INSERT INTO `district` VALUES ('2404', '曲水县', '308');
  INSERT INTO `district` VALUES ('2405', '堆龙德庆县', '308');
  INSERT INTO `district` VALUES ('2406', '达孜县', '308');
  INSERT INTO `district` VALUES ('2407', '墨竹工卡县', '308');
  INSERT INTO `district` VALUES ('2408', '昌都县', '309');
  INSERT INTO `district` VALUES ('2409', '江达县', '309');
  INSERT INTO `district` VALUES ('2410', '贡觉县', '309');
  INSERT INTO `district` VALUES ('2411', '类乌齐县', '309');
  INSERT INTO `district` VALUES ('2412', '丁青县', '309');
  INSERT INTO `district` VALUES ('2413', '察雅县', '309');
  INSERT INTO `district` VALUES ('2414', '八宿县', '309');
  INSERT INTO `district` VALUES ('2415', '左贡县', '309');
  INSERT INTO `district` VALUES ('2416', '芒康县', '309');
  INSERT INTO `district` VALUES ('2417', '洛隆县', '309');
  INSERT INTO `district` VALUES ('2418', '边坝县', '309');
  INSERT INTO `district` VALUES ('2419', '乃东县', '310');
  INSERT INTO `district` VALUES ('2420', '扎囊县', '310');
  INSERT INTO `district` VALUES ('2421', '贡嘎县', '310');
  INSERT INTO `district` VALUES ('2422', '桑日县', '310');
  INSERT INTO `district` VALUES ('2423', '琼结县', '310');
  INSERT INTO `district` VALUES ('2424', '曲松县', '310');
  INSERT INTO `district` VALUES ('2425', '措美县', '310');
  INSERT INTO `district` VALUES ('2426', '洛扎县', '310');
  INSERT INTO `district` VALUES ('2427', '加查县', '310');
  INSERT INTO `district` VALUES ('2428', '隆子县', '310');
  INSERT INTO `district` VALUES ('2429', '错那县', '310');
  INSERT INTO `district` VALUES ('2430', '浪卡子县', '310');
  INSERT INTO `district` VALUES ('2431', '日喀则市', '311');
  INSERT INTO `district` VALUES ('2432', '南木林县', '311');
  INSERT INTO `district` VALUES ('2433', '江孜县', '311');
  INSERT INTO `district` VALUES ('2434', '定日县', '311');
  INSERT INTO `district` VALUES ('2435', '萨迦县', '311');
  INSERT INTO `district` VALUES ('2436', '拉孜县', '311');
  INSERT INTO `district` VALUES ('2437', '昂仁县', '311');
  INSERT INTO `district` VALUES ('2438', '谢通门县', '311');
  INSERT INTO `district` VALUES ('2439', '白朗县', '311');
  INSERT INTO `district` VALUES ('2440', '仁布县', '311');
  INSERT INTO `district` VALUES ('2441', '康马县', '311');
  INSERT INTO `district` VALUES ('2442', '定结县', '311');
  INSERT INTO `district` VALUES ('2443', '仲巴县', '311');
  INSERT INTO `district` VALUES ('2444', '亚东县', '311');
  INSERT INTO `district` VALUES ('2445', '吉隆县', '311');
  INSERT INTO `district` VALUES ('2446', '聂拉木县', '311');
  INSERT INTO `district` VALUES ('2447', '萨嘎县', '311');
  INSERT INTO `district` VALUES ('2448', '岗巴县', '311');
  INSERT INTO `district` VALUES ('2449', '那曲县', '312');
  INSERT INTO `district` VALUES ('2450', '嘉黎县', '312');
  INSERT INTO `district` VALUES ('2451', '比如县', '312');
  INSERT INTO `district` VALUES ('2452', '聂荣县', '312');
  INSERT INTO `district` VALUES ('2453', '安多县', '312');
  INSERT INTO `district` VALUES ('2454', '申扎县', '312');
  INSERT INTO `district` VALUES ('2455', '索　县', '312');
  INSERT INTO `district` VALUES ('2456', '班戈县', '312');
  INSERT INTO `district` VALUES ('2457', '巴青县', '312');
  INSERT INTO `district` VALUES ('2458', '尼玛县', '312');
  INSERT INTO `district` VALUES ('2459', '普兰县', '313');
  INSERT INTO `district` VALUES ('2460', '札达县', '313');
  INSERT INTO `district` VALUES ('2461', '噶尔县', '313');
  INSERT INTO `district` VALUES ('2462', '日土县', '313');
  INSERT INTO `district` VALUES ('2463', '革吉县', '313');
  INSERT INTO `district` VALUES ('2464', '改则县', '313');
  INSERT INTO `district` VALUES ('2465', '措勤县', '313');
  INSERT INTO `district` VALUES ('2466', '林芝县', '314');
  INSERT INTO `district` VALUES ('2467', '工布江达县', '314');
  INSERT INTO `district` VALUES ('2468', '米林县', '314');
  INSERT INTO `district` VALUES ('2469', '墨脱县', '314');
  INSERT INTO `district` VALUES ('2470', '波密县', '314');
  INSERT INTO `district` VALUES ('2471', '察隅县', '314');
  INSERT INTO `district` VALUES ('2472', '朗　县', '314');
  INSERT INTO `district` VALUES ('2473', '新城区', '315');
  INSERT INTO `district` VALUES ('2474', '碑林区', '315');
  INSERT INTO `district` VALUES ('2475', '莲湖区', '315');
  INSERT INTO `district` VALUES ('2476', '灞桥区', '315');
  INSERT INTO `district` VALUES ('2477', '未央区', '315');
  INSERT INTO `district` VALUES ('2478', '雁塔区', '315');
  INSERT INTO `district` VALUES ('2479', '阎良区', '315');
  INSERT INTO `district` VALUES ('2480', '临潼区', '315');
  INSERT INTO `district` VALUES ('2481', '长安区', '315');
  INSERT INTO `district` VALUES ('2482', '蓝田县', '315');
  INSERT INTO `district` VALUES ('2483', '周至县', '315');
  INSERT INTO `district` VALUES ('2484', '户　县', '315');
  INSERT INTO `district` VALUES ('2485', '高陵县', '315');
  INSERT INTO `district` VALUES ('2486', '王益区', '316');
  INSERT INTO `district` VALUES ('2487', '印台区', '316');
  INSERT INTO `district` VALUES ('2488', '耀州区', '316');
  INSERT INTO `district` VALUES ('2489', '宜君县', '316');
  INSERT INTO `district` VALUES ('2490', '渭滨区', '317');
  INSERT INTO `district` VALUES ('2491', '金台区', '317');
  INSERT INTO `district` VALUES ('2492', '陈仓区', '317');
  INSERT INTO `district` VALUES ('2493', '凤翔县', '317');
  INSERT INTO `district` VALUES ('2494', '岐山县', '317');
  INSERT INTO `district` VALUES ('2495', '扶风县', '317');
  INSERT INTO `district` VALUES ('2496', '眉　县', '317');
  INSERT INTO `district` VALUES ('2497', '陇　县', '317');
  INSERT INTO `district` VALUES ('2498', '千阳县', '317');
  INSERT INTO `district` VALUES ('2499', '麟游县', '317');
  INSERT INTO `district` VALUES ('2500', '凤　县', '317');
  INSERT INTO `district` VALUES ('2501', '太白县', '317');
  INSERT INTO `district` VALUES ('2502', '秦都区', '318');
  INSERT INTO `district` VALUES ('2503', '杨凌区', '318');
  INSERT INTO `district` VALUES ('2504', '渭城区', '318');
  INSERT INTO `district` VALUES ('2505', '三原县', '318');
  INSERT INTO `district` VALUES ('2506', '泾阳县', '318');
  INSERT INTO `district` VALUES ('2507', '乾　县', '318');
  INSERT INTO `district` VALUES ('2508', '礼泉县', '318');
  INSERT INTO `district` VALUES ('2509', '永寿县', '318');
  INSERT INTO `district` VALUES ('2510', '彬　县', '318');
  INSERT INTO `district` VALUES ('2511', '长武县', '318');
  INSERT INTO `district` VALUES ('2512', '旬邑县', '318');
  INSERT INTO `district` VALUES ('2513', '淳化县', '318');
  INSERT INTO `district` VALUES ('2514', '武功县', '318');
  INSERT INTO `district` VALUES ('2515', '兴平市', '318');
  INSERT INTO `district` VALUES ('2516', '临渭区', '319');
  INSERT INTO `district` VALUES ('2517', '华　县', '319');
  INSERT INTO `district` VALUES ('2518', '潼关县', '319');
  INSERT INTO `district` VALUES ('2519', '大荔县', '319');
  INSERT INTO `district` VALUES ('2520', '合阳县', '319');
  INSERT INTO `district` VALUES ('2521', '澄城县', '319');
  INSERT INTO `district` VALUES ('2522', '蒲城县', '319');
  INSERT INTO `district` VALUES ('2523', '白水县', '319');
  INSERT INTO `district` VALUES ('2524', '富平县', '319');
  INSERT INTO `district` VALUES ('2525', '韩城市', '319');
  INSERT INTO `district` VALUES ('2526', '华阴市', '319');
  INSERT INTO `district` VALUES ('2527', '宝塔区', '320');
  INSERT INTO `district` VALUES ('2528', '延长县', '320');
  INSERT INTO `district` VALUES ('2529', '延川县', '320');
  INSERT INTO `district` VALUES ('2530', '子长县', '320');
  INSERT INTO `district` VALUES ('2531', '安塞县', '320');
  INSERT INTO `district` VALUES ('2532', '志丹县', '320');
  INSERT INTO `district` VALUES ('2533', '吴起县', '320');
  INSERT INTO `district` VALUES ('2534', '甘泉县', '320');
  INSERT INTO `district` VALUES ('2535', '富　县', '320');
  INSERT INTO `district` VALUES ('2536', '洛川县', '320');
  INSERT INTO `district` VALUES ('2537', '宜川县', '320');
  INSERT INTO `district` VALUES ('2538', '黄龙县', '320');
  INSERT INTO `district` VALUES ('2539', '黄陵县', '320');
  INSERT INTO `district` VALUES ('2540', '汉台区', '321');
  INSERT INTO `district` VALUES ('2541', '南郑县', '321');
  INSERT INTO `district` VALUES ('2542', '城固县', '321');
  INSERT INTO `district` VALUES ('2543', '洋　县', '321');
  INSERT INTO `district` VALUES ('2544', '西乡县', '321');
  INSERT INTO `district` VALUES ('2545', '勉　县', '321');
  INSERT INTO `district` VALUES ('2546', '宁强县', '321');
  INSERT INTO `district` VALUES ('2547', '略阳县', '321');
  INSERT INTO `district` VALUES ('2548', '镇巴县', '321');
  INSERT INTO `district` VALUES ('2549', '留坝县', '321');
  INSERT INTO `district` VALUES ('2550', '佛坪县', '321');
  INSERT INTO `district` VALUES ('2551', '榆阳区', '322');
  INSERT INTO `district` VALUES ('2552', '神木县', '322');
  INSERT INTO `district` VALUES ('2553', '府谷县', '322');
  INSERT INTO `district` VALUES ('2554', '横山县', '322');
  INSERT INTO `district` VALUES ('2555', '靖边县', '322');
  INSERT INTO `district` VALUES ('2556', '定边县', '322');
  INSERT INTO `district` VALUES ('2557', '绥德县', '322');
  INSERT INTO `district` VALUES ('2558', '米脂县', '322');
  INSERT INTO `district` VALUES ('2559', '佳　县', '322');
  INSERT INTO `district` VALUES ('2560', '吴堡县', '322');
  INSERT INTO `district` VALUES ('2561', '清涧县', '322');
  INSERT INTO `district` VALUES ('2562', '子洲县', '322');
  INSERT INTO `district` VALUES ('2563', '汉滨区', '323');
  INSERT INTO `district` VALUES ('2564', '汉阴县', '323');
  INSERT INTO `district` VALUES ('2565', '石泉县', '323');
  INSERT INTO `district` VALUES ('2566', '宁陕县', '323');
  INSERT INTO `district` VALUES ('2567', '紫阳县', '323');
  INSERT INTO `district` VALUES ('2568', '岚皋县', '323');
  INSERT INTO `district` VALUES ('2569', '平利县', '323');
  INSERT INTO `district` VALUES ('2570', '镇坪县', '323');
  INSERT INTO `district` VALUES ('2571', '旬阳县', '323');
  INSERT INTO `district` VALUES ('2572', '白河县', '323');
  INSERT INTO `district` VALUES ('2573', '商州区', '324');
  INSERT INTO `district` VALUES ('2574', '洛南县', '324');
  INSERT INTO `district` VALUES ('2575', '丹凤县', '324');
  INSERT INTO `district` VALUES ('2576', '商南县', '324');
  INSERT INTO `district` VALUES ('2577', '山阳县', '324');
  INSERT INTO `district` VALUES ('2578', '镇安县', '324');
  INSERT INTO `district` VALUES ('2579', '柞水县', '324');
  INSERT INTO `district` VALUES ('2580', '城关区', '325');
  INSERT INTO `district` VALUES ('2581', '七里河区', '325');
  INSERT INTO `district` VALUES ('2582', '西固区', '325');
  INSERT INTO `district` VALUES ('2583', '安宁区', '325');
  INSERT INTO `district` VALUES ('2584', '红古区', '325');
  INSERT INTO `district` VALUES ('2585', '永登县', '325');
  INSERT INTO `district` VALUES ('2586', '皋兰县', '325');
  INSERT INTO `district` VALUES ('2587', '榆中县', '325');
  INSERT INTO `district` VALUES ('2588', '金川区', '326');
  INSERT INTO `district` VALUES ('2589', '永昌县', '326');
  INSERT INTO `district` VALUES ('2590', '白银区', '327');
  INSERT INTO `district` VALUES ('2591', '平川区', '327');
  INSERT INTO `district` VALUES ('2592', '靖远县', '327');
  INSERT INTO `district` VALUES ('2593', '会宁县', '327');
  INSERT INTO `district` VALUES ('2594', '景泰县', '327');
  INSERT INTO `district` VALUES ('2595', '秦州区', '328');
  INSERT INTO `district` VALUES ('2596', '麦积区', '328');
  INSERT INTO `district` VALUES ('2597', '清水县', '328');
  INSERT INTO `district` VALUES ('2598', '秦安县', '328');
  INSERT INTO `district` VALUES ('2599', '甘谷县', '328');
  INSERT INTO `district` VALUES ('2600', '武山县', '328');
  INSERT INTO `district` VALUES ('2601', '张家川回族自治县', '328');
  INSERT INTO `district` VALUES ('2602', '凉州区', '329');
  INSERT INTO `district` VALUES ('2603', '民勤县', '329');
  INSERT INTO `district` VALUES ('2604', '古浪县', '329');
  INSERT INTO `district` VALUES ('2605', '天祝藏族自治县', '329');
  INSERT INTO `district` VALUES ('2606', '甘州区', '330');
  INSERT INTO `district` VALUES ('2607', '肃南裕固族自治县', '330');
  INSERT INTO `district` VALUES ('2608', '民乐县', '330');
  INSERT INTO `district` VALUES ('2609', '临泽县', '330');
  INSERT INTO `district` VALUES ('2610', '高台县', '330');
  INSERT INTO `district` VALUES ('2611', '山丹县', '330');
  INSERT INTO `district` VALUES ('2612', '崆峒区', '331');
  INSERT INTO `district` VALUES ('2613', '泾川县', '331');
  INSERT INTO `district` VALUES ('2614', '灵台县', '331');
  INSERT INTO `district` VALUES ('2615', '崇信县', '331');
  INSERT INTO `district` VALUES ('2616', '华亭县', '331');
  INSERT INTO `district` VALUES ('2617', '庄浪县', '331');
  INSERT INTO `district` VALUES ('2618', '静宁县', '331');
  INSERT INTO `district` VALUES ('2619', '肃州区', '332');
  INSERT INTO `district` VALUES ('2620', '金塔县', '332');
  INSERT INTO `district` VALUES ('2621', '瓜州县', '332');
  INSERT INTO `district` VALUES ('2622', '肃北蒙古族自治县', '332');
  INSERT INTO `district` VALUES ('2623', '阿克塞哈萨克族自治县', '332');
  INSERT INTO `district` VALUES ('2624', '玉门市', '332');
  INSERT INTO `district` VALUES ('2625', '敦煌市', '332');
  INSERT INTO `district` VALUES ('2626', '西峰区', '333');
  INSERT INTO `district` VALUES ('2627', '庆城县', '333');
  INSERT INTO `district` VALUES ('2628', '环　县', '333');
  INSERT INTO `district` VALUES ('2629', '华池县', '333');
  INSERT INTO `district` VALUES ('2630', '合水县', '333');
  INSERT INTO `district` VALUES ('2631', '正宁县', '333');
  INSERT INTO `district` VALUES ('2632', '宁　县', '333');
  INSERT INTO `district` VALUES ('2633', '镇原县', '333');
  INSERT INTO `district` VALUES ('2634', '安定区', '334');
  INSERT INTO `district` VALUES ('2635', '通渭县', '334');
  INSERT INTO `district` VALUES ('2636', '陇西县', '334');
  INSERT INTO `district` VALUES ('2637', '渭源县', '334');
  INSERT INTO `district` VALUES ('2638', '临洮县', '334');
  INSERT INTO `district` VALUES ('2639', '漳　县', '334');
  INSERT INTO `district` VALUES ('2640', '岷　县', '334');
  INSERT INTO `district` VALUES ('2641', '武都区', '335');
  INSERT INTO `district` VALUES ('2642', '成　县', '335');
  INSERT INTO `district` VALUES ('2643', '文　县', '335');
  INSERT INTO `district` VALUES ('2644', '宕昌县', '335');
  INSERT INTO `district` VALUES ('2645', '康　县', '335');
  INSERT INTO `district` VALUES ('2646', '西和县', '335');
  INSERT INTO `district` VALUES ('2647', '礼　县', '335');
  INSERT INTO `district` VALUES ('2648', '徽　县', '335');
  INSERT INTO `district` VALUES ('2649', '两当县', '335');
  INSERT INTO `district` VALUES ('2650', '临夏市', '336');
  INSERT INTO `district` VALUES ('2651', '临夏县', '336');
  INSERT INTO `district` VALUES ('2652', '康乐县', '336');
  INSERT INTO `district` VALUES ('2653', '永靖县', '336');
  INSERT INTO `district` VALUES ('2654', '广河县', '336');
  INSERT INTO `district` VALUES ('2655', '和政县', '336');
  INSERT INTO `district` VALUES ('2656', '东乡族自治县', '336');
  INSERT INTO `district` VALUES ('2657', '积石山保安族东乡族撒拉族自治县', '336');
  INSERT INTO `district` VALUES ('2658', '合作市', '337');
  INSERT INTO `district` VALUES ('2659', '临潭县', '337');
  INSERT INTO `district` VALUES ('2660', '卓尼县', '337');
  INSERT INTO `district` VALUES ('2661', '舟曲县', '337');
  INSERT INTO `district` VALUES ('2662', '迭部县', '337');
  INSERT INTO `district` VALUES ('2663', '玛曲县', '337');
  INSERT INTO `district` VALUES ('2664', '碌曲县', '337');
  INSERT INTO `district` VALUES ('2665', '夏河县', '337');
  INSERT INTO `district` VALUES ('2666', '城东区', '338');
  INSERT INTO `district` VALUES ('2667', '城中区', '338');
  INSERT INTO `district` VALUES ('2668', '城西区', '338');
  INSERT INTO `district` VALUES ('2669', '城北区', '338');
  INSERT INTO `district` VALUES ('2670', '大通回族土族自治县', '338');
  INSERT INTO `district` VALUES ('2671', '湟中县', '338');
  INSERT INTO `district` VALUES ('2672', '湟源县', '338');
  INSERT INTO `district` VALUES ('2673', '平安县', '339');
  INSERT INTO `district` VALUES ('2674', '民和回族土族自治县', '339');
  INSERT INTO `district` VALUES ('2675', '乐都县', '339');
  INSERT INTO `district` VALUES ('2676', '互助土族自治县', '339');
  INSERT INTO `district` VALUES ('2677', '化隆回族自治县', '339');
  INSERT INTO `district` VALUES ('2678', '循化撒拉族自治县', '339');
  INSERT INTO `district` VALUES ('2679', '门源回族自治县', '340');
  INSERT INTO `district` VALUES ('2680', '祁连县', '340');
  INSERT INTO `district` VALUES ('2681', '海晏县', '340');
  INSERT INTO `district` VALUES ('2682', '刚察县', '340');
  INSERT INTO `district` VALUES ('2683', '同仁县', '341');
  INSERT INTO `district` VALUES ('2684', '尖扎县', '341');
  INSERT INTO `district` VALUES ('2685', '泽库县', '341');
  INSERT INTO `district` VALUES ('2686', '河南蒙古族自治县', '341');
  INSERT INTO `district` VALUES ('2687', '共和县', '342');
  INSERT INTO `district` VALUES ('2688', '同德县', '342');
  INSERT INTO `district` VALUES ('2689', '贵德县', '342');
  INSERT INTO `district` VALUES ('2690', '兴海县', '342');
  INSERT INTO `district` VALUES ('2691', '贵南县', '342');
  INSERT INTO `district` VALUES ('2692', '玛沁县', '343');
  INSERT INTO `district` VALUES ('2693', '班玛县', '343');
  INSERT INTO `district` VALUES ('2694', '甘德县', '343');
  INSERT INTO `district` VALUES ('2695', '达日县', '343');
  INSERT INTO `district` VALUES ('2696', '久治县', '343');
  INSERT INTO `district` VALUES ('2697', '玛多县', '343');
  INSERT INTO `district` VALUES ('2698', '玉树县', '344');
  INSERT INTO `district` VALUES ('2699', '杂多县', '344');
  INSERT INTO `district` VALUES ('2700', '称多县', '344');
  INSERT INTO `district` VALUES ('2701', '治多县', '344');
  INSERT INTO `district` VALUES ('2702', '囊谦县', '344');
  INSERT INTO `district` VALUES ('2703', '曲麻莱县', '344');
  INSERT INTO `district` VALUES ('2704', '格尔木市', '345');
  INSERT INTO `district` VALUES ('2705', '德令哈市', '345');
  INSERT INTO `district` VALUES ('2706', '乌兰县', '345');
  INSERT INTO `district` VALUES ('2707', '都兰县', '345');
  INSERT INTO `district` VALUES ('2708', '天峻县', '345');
  INSERT INTO `district` VALUES ('2709', '兴庆区', '346');
  INSERT INTO `district` VALUES ('2710', '西夏区', '346');
  INSERT INTO `district` VALUES ('2711', '金凤区', '346');
  INSERT INTO `district` VALUES ('2712', '永宁县', '346');
  INSERT INTO `district` VALUES ('2713', '贺兰县', '346');
  INSERT INTO `district` VALUES ('2714', '灵武市', '346');
  INSERT INTO `district` VALUES ('2715', '大武口区', '347');
  INSERT INTO `district` VALUES ('2716', '惠农区', '347');
  INSERT INTO `district` VALUES ('2717', '平罗县', '347');
  INSERT INTO `district` VALUES ('2718', '利通区', '348');
  INSERT INTO `district` VALUES ('2719', '盐池县', '348');
  INSERT INTO `district` VALUES ('2720', '同心县', '348');
  INSERT INTO `district` VALUES ('2721', '青铜峡市', '348');
  INSERT INTO `district` VALUES ('2722', '原州区', '349');
  INSERT INTO `district` VALUES ('2723', '西吉县', '349');
  INSERT INTO `district` VALUES ('2724', '隆德县', '349');
  INSERT INTO `district` VALUES ('2725', '泾源县', '349');
  INSERT INTO `district` VALUES ('2726', '彭阳县', '349');
  INSERT INTO `district` VALUES ('2727', '沙坡头区', '350');
  INSERT INTO `district` VALUES ('2728', '中宁县', '350');
  INSERT INTO `district` VALUES ('2729', '海原县', '350');
  INSERT INTO `district` VALUES ('2730', '天山区', '351');
  INSERT INTO `district` VALUES ('2731', '沙依巴克区', '351');
  INSERT INTO `district` VALUES ('2732', '新市区', '351');
  INSERT INTO `district` VALUES ('2733', '水磨沟区', '351');
  INSERT INTO `district` VALUES ('2734', '头屯河区', '351');
  INSERT INTO `district` VALUES ('2735', '达坂城区', '351');
  INSERT INTO `district` VALUES ('2736', '米东区', '351');
  INSERT INTO `district` VALUES ('2737', '乌鲁木齐县', '351');
  INSERT INTO `district` VALUES ('2738', '独山子区', '352');
  INSERT INTO `district` VALUES ('2739', '克拉玛依区', '352');
  INSERT INTO `district` VALUES ('2740', '白碱滩区', '352');
  INSERT INTO `district` VALUES ('2741', '乌尔禾区', '352');
  INSERT INTO `district` VALUES ('2742', '吐鲁番市', '353');
  INSERT INTO `district` VALUES ('2743', '鄯善县', '353');
  INSERT INTO `district` VALUES ('2744', '托克逊县', '353');
  INSERT INTO `district` VALUES ('2745', '哈密市', '354');
  INSERT INTO `district` VALUES ('2746', '巴里坤哈萨克自治县', '354');
  INSERT INTO `district` VALUES ('2747', '伊吾县', '354');
  INSERT INTO `district` VALUES ('2748', '昌吉市', '355');
  INSERT INTO `district` VALUES ('2749', '阜康市', '355');
  INSERT INTO `district` VALUES ('2750', '呼图壁县', '355');
  INSERT INTO `district` VALUES ('2751', '玛纳斯县', '355');
  INSERT INTO `district` VALUES ('2752', '奇台县', '355');
  INSERT INTO `district` VALUES ('2753', '吉木萨尔县', '355');
  INSERT INTO `district` VALUES ('2754', '木垒哈萨克自治县', '355');
  INSERT INTO `district` VALUES ('2755', '博乐市', '356');
  INSERT INTO `district` VALUES ('2756', '精河县', '356');
  INSERT INTO `district` VALUES ('2757', '温泉县', '356');
  INSERT INTO `district` VALUES ('2758', '库尔勒市', '357');
  INSERT INTO `district` VALUES ('2759', '轮台县', '357');
  INSERT INTO `district` VALUES ('2760', '尉犁县', '357');
  INSERT INTO `district` VALUES ('2761', '若羌县', '357');
  INSERT INTO `district` VALUES ('2762', '且末县', '357');
  INSERT INTO `district` VALUES ('2763', '焉耆回族自治县', '357');
  INSERT INTO `district` VALUES ('2764', '和静县', '357');
  INSERT INTO `district` VALUES ('2765', '和硕县', '357');
  INSERT INTO `district` VALUES ('2766', '博湖县', '357');
  INSERT INTO `district` VALUES ('2767', '阿克苏市', '358');
  INSERT INTO `district` VALUES ('2768', '温宿县', '358');
  INSERT INTO `district` VALUES ('2769', '库车县', '358');
  INSERT INTO `district` VALUES ('2770', '沙雅县', '358');
  INSERT INTO `district` VALUES ('2771', '新和县', '358');
  INSERT INTO `district` VALUES ('2772', '拜城县', '358');
  INSERT INTO `district` VALUES ('2773', '乌什县', '358');
  INSERT INTO `district` VALUES ('2774', '阿瓦提县', '358');
  INSERT INTO `district` VALUES ('2775', '柯坪县', '358');
  INSERT INTO `district` VALUES ('2776', '阿图什市', '359');
  INSERT INTO `district` VALUES ('2777', '阿克陶县', '359');
  INSERT INTO `district` VALUES ('2778', '阿合奇县', '359');
  INSERT INTO `district` VALUES ('2779', '乌恰县', '359');
  INSERT INTO `district` VALUES ('2780', '喀什市', '360');
  INSERT INTO `district` VALUES ('2781', '疏附县', '360');
  INSERT INTO `district` VALUES ('2782', '疏勒县', '360');
  INSERT INTO `district` VALUES ('2783', '英吉沙县', '360');
  INSERT INTO `district` VALUES ('2784', '泽普县', '360');
  INSERT INTO `district` VALUES ('2785', '莎车县', '360');
  INSERT INTO `district` VALUES ('2786', '叶城县', '360');
  INSERT INTO `district` VALUES ('2787', '麦盖提县', '360');
  INSERT INTO `district` VALUES ('2788', '岳普湖县', '360');
  INSERT INTO `district` VALUES ('2789', '伽师县', '360');
  INSERT INTO `district` VALUES ('2790', '巴楚县', '360');
  INSERT INTO `district` VALUES ('2791', '塔什库尔干塔吉克自治县', '360');
  INSERT INTO `district` VALUES ('2792', '和田市', '361');
  INSERT INTO `district` VALUES ('2793', '和田县', '361');
  INSERT INTO `district` VALUES ('2794', '墨玉县', '361');
  INSERT INTO `district` VALUES ('2795', '皮山县', '361');
  INSERT INTO `district` VALUES ('2796', '洛浦县', '361');
  INSERT INTO `district` VALUES ('2797', '策勒县', '361');
  INSERT INTO `district` VALUES ('2798', '于田县', '361');
  INSERT INTO `district` VALUES ('2799', '民丰县', '361');
  INSERT INTO `district` VALUES ('2800', '伊宁市', '362');
  INSERT INTO `district` VALUES ('2801', '奎屯市', '362');
  INSERT INTO `district` VALUES ('2802', '伊宁县', '362');
  INSERT INTO `district` VALUES ('2803', '察布查尔锡伯自治县', '362');
  INSERT INTO `district` VALUES ('2804', '霍城县', '362');
  INSERT INTO `district` VALUES ('2805', '巩留县', '362');
  INSERT INTO `district` VALUES ('2806', '新源县', '362');
  INSERT INTO `district` VALUES ('2807', '昭苏县', '362');
  INSERT INTO `district` VALUES ('2808', '特克斯县', '362');
  INSERT INTO `district` VALUES ('2809', '尼勒克县', '362');
  INSERT INTO `district` VALUES ('2810', '塔城市', '363');
  INSERT INTO `district` VALUES ('2811', '乌苏市', '363');
  INSERT INTO `district` VALUES ('2812', '额敏县', '363');
  INSERT INTO `district` VALUES ('2813', '沙湾县', '363');
  INSERT INTO `district` VALUES ('2814', '托里县', '363');
  INSERT INTO `district` VALUES ('2815', '裕民县', '363');
  INSERT INTO `district` VALUES ('2816', '和布克赛尔蒙古自治县', '363');
  INSERT INTO `district` VALUES ('2817', '阿勒泰市', '364');
  INSERT INTO `district` VALUES ('2818', '布尔津县', '364');
  INSERT INTO `district` VALUES ('2819', '富蕴县', '364');
  INSERT INTO `district` VALUES ('2820', '福海县', '364');
  INSERT INTO `district` VALUES ('2821', '哈巴河县', '364');
  INSERT INTO `district` VALUES ('2822', '青河县', '364');
  INSERT INTO `district` VALUES ('2823', '吉木乃县', '364');
  
  -- ----------------------------
  -- Table structure for `province`
  -- ----------------------------
  DROP TABLE IF EXISTS `province`;
  CREATE TABLE `province` (
    `p_id` int(11) NOT NULL AUTO_INCREMENT,
    `p_name` varchar(30) DEFAULT NULL,
    PRIMARY KEY (`p_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of province
  -- ----------------------------
  INSERT INTO `province` VALUES ('1', '北京市');
  INSERT INTO `province` VALUES ('2', '天津市');
  INSERT INTO `province` VALUES ('3', '河北省');
  INSERT INTO `province` VALUES ('4', '山西省');
  INSERT INTO `province` VALUES ('5', '内蒙古自治区');
  INSERT INTO `province` VALUES ('6', '辽宁省');
  INSERT INTO `province` VALUES ('7', '吉林省');
  INSERT INTO `province` VALUES ('8', '黑龙江省');
  INSERT INTO `province` VALUES ('9', '上海市');
  INSERT INTO `province` VALUES ('10', '江苏省');
  INSERT INTO `province` VALUES ('11', '浙江省');
  INSERT INTO `province` VALUES ('12', '安徽省');
  INSERT INTO `province` VALUES ('13', '福建省');
  INSERT INTO `province` VALUES ('14', '江西省');
  INSERT INTO `province` VALUES ('15', '山东省');
  INSERT INTO `province` VALUES ('16', '河南省');
  INSERT INTO `province` VALUES ('17', '湖北省');
  INSERT INTO `province` VALUES ('18', '湖南省');
  INSERT INTO `province` VALUES ('19', '广东省');
  INSERT INTO `province` VALUES ('20', '广西壮族自治区');
  INSERT INTO `province` VALUES ('21', '海南省');
  INSERT INTO `province` VALUES ('22', '重庆市');
  INSERT INTO `province` VALUES ('23', '四川省');
  INSERT INTO `province` VALUES ('24', '贵州省');
  INSERT INTO `province` VALUES ('25', '云南省');
  INSERT INTO `province` VALUES ('26', '西藏自治区');
  INSERT INTO `province` VALUES ('27', '陕西省');
  INSERT INTO `province` VALUES ('28', '甘肃省');
  INSERT INTO `province` VALUES ('29', '青海省');
  INSERT INTO `province` VALUES ('30', '宁夏回族自治区');
  INSERT INTO `province` VALUES ('31', '新疆维吾尔自治区');
  INSERT INTO `province` VALUES ('32', '台湾省');
  INSERT INTO `province` VALUES ('33', '香港特别行政区');
  INSERT INTO `province` VALUES ('34', '澳门特别行政区');
  
  -- ----------------------------
  -- Table structure for `t_diary`
  -- ----------------------------
  DROP TABLE IF EXISTS `t_diary`;
  CREATE TABLE `t_diary` (
    `diaryId` int(11) NOT NULL AUTO_INCREMENT,
    `diaryTitle` varchar(255) DEFAULT NULL,
    `diaryImage` varchar(255) DEFAULT NULL,
    `diaryContent` mediumblob,
    `diaryTime` varchar(255) DEFAULT NULL,
    `userId` int(11) DEFAULT NULL,
    `readTimes` int(11) DEFAULT NULL,
    PRIMARY KEY (`diaryId`)
  ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of t_diary
  -- ----------------------------
  INSERT INTO `t_diary` VALUES ('5', '穷游品味古城历史', 'Upload/20131111163341161120.jpg', 0x3C703ED5E2CAC7CED2B5DAD2BBB4CEB2DFBBAED7EEBEC0BDE1B5C4D7D4D3C9D0D0CFEBB9FDC8A53C6120636C6173733D22612D6E6F7465732D696E6E65726C696E6B2220687265663D22687474703A2F2F6C76796F752E62616964752E636F6D2F67756979616E6722207374796C653D22746578742D6465636F726174696F6E3A206E6F6E653B20636F6C6F723A2072676228302C203132362C20323137293B22207461726765743D225F626C616E6B223EB9F3D1F43C2F613EB5ABB8FCCFEBC8A5CEF7B0B23C2F703E3C703EBAF3C0B4B0D1D6D5B5E3B6A8D4DAC1CB3C6120636C6173733D22612D6E6F7465732D696E6E65726C696E6B2220687265663D22687474703A2F2F6C76796F752E62616964752E636F6D2F7869616E22207374796C653D22746578742D6465636F726174696F6E3A206E6F6E653B20636F6C6F723A2072676228302C203132362C20323137293B22207461726765743D225F626C616E6B223ECEF7B0B23C2F613EC8A5D6D8C7ECB5C4BBFAC6B1B1E3D2CBBECDC1A2C2EDB6A9C1CB3C6120636C6173733D22612D6E6F7465732D696E6E65726C696E6B2220687265663D22687474703A2F2F6C76796F752E62616964752E636F6D2F63686F6E6771696E6722207374796C653D22746578742D6465636F726174696F6E3A206E6F6E653B20636F6C6F723A2072676228302C203132362C20323137293B22207461726765743D225F626C616E6B223ED6D8C7EC3C2F613EB5BDCEF7B0B2B5C4BBF0B3B5C6B13C2F703E3C703EBAF3C0B4D3D0C8CBCBB5C2E5D1F4C4B5B5A4BBA8BAC33C6120636C6173733D22612D6E6F7465732D696E6E65726C696E6B2220687265663D22687474703A2F2F6C76796F752E62616964752E636F6D2F6C756F79616E6722207374796C653D22746578742D6465636F726174696F6E3A206E6F6E653B20636F6C6F723A2072676228302C203132362C20323137293B22207461726765743D225F626C616E6B223EC2E5D1F43C2F613EB5C4BBFAC6B1D2B2D2BBD1F9B1E3D2CBBECDC1A2C2EDB7C5C6FAC1CBC8A5D6D8C7EC3C2F703E3C703ECFEBD7C5D6D0BCE4D3D0C1BDCCECC3BBCAC2B8C9BECDCBB5C8A5C6BDD2A3B9C5B3C7BFB4BFB4B0D1B8DFCCFAC6B1B6A9C1CBD3D6BEF6B6A8BBB9CAC7C8A53C6120636C6173733D22612D6E6F7465732D696E6E65726C696E6B2220687265663D22687474703A2F2F6C76796F752E62616964752E636F6D2F68756B6F757075627522207374796C653D22746578742D6465636F726174696F6E3A206E6F6E653B20636F6C6F723A2072676228302C203132362C20323137293B22207461726765743D225F626C616E6B223EBAF8BFDAC6D9B2BC3C2F613E266E6273703B3C2F703E3C703EBDE1B9FBB0D1D4ADB6A8BCC6BBAEB6BCB8C4B5F4C1CBBECDB3C9C1CBCFD6D4DAB5C4A1BE3C7374726F6E673E3C7370616E207374796C653D22636F6C6F723A726762283235352C20302C203029223E3C6120636C6173733D22612D6E6F7465732D696E6E65726C696E6B2220687265663D22687474703A2F2F6C76796F752E62616964752E636F6D2F6775616E677A686F7522207374796C653D22746578742D6465636F726174696F6E3A206E6F6E653B20636F6C6F723A2072676228302C203132362C20323137293B22207461726765743D225F626C616E6B223EB9E3D6DD3C2F613E26726172723BC2E5D1F426726172723BCEF7B0B226726172723BD1D3B0B226726172723B3C6120636C6173733D22612D6E6F7465732D696E6E65726C696E6B2220687265663D22687474703A2F2F6C76796F752E62616964752E636F6D2F7765696E616E22207374796C653D22746578742D6465636F726174696F6E3A206E6F6E653B20636F6C6F723A2072676228302C203132362C20323137293B22207461726765743D225F626C616E6B223ECEBCC4CF3C2F613E26726172723BCEF7B0B226726172723BCFCCD1F426726172723BB9E3D6DD3C2F7370616E3E3C2F7374726F6E673EA1BF3C2F703E3C703E266E6273703B3C2F703E3C703EBAC3BEC0BDE1D5E2C3B4BEC3D6D5D3DAB3F6B7A2A3A13C2F703E3C703EB5C8B5C8A3A1C2E8D1BDCED2D3D6B1BBC8CBC8A1CFFBB7C9BBFAC4CFBABDD2BBCCECD6BBD3D0D2BBB0E0BBFAC8A5C2E5D1F4BACDC4CFBABDB6E0B4CED0ADC9CCBBB9CAC7CCE1D4E7D2BBCCECB3F6B7A23C2F703E, '2015-05-13 11:39:14', '1', '453');
  INSERT INTO `t_diary` VALUES ('6', '古城西安市 梦回长安城', 'Upload/adb73c8d-1524-45c9-8948-930ce014b1ca.jpg', 0x3C703E3C7370616E207374796C653D22666F6E742D66616D696C793A617269616C2CCBCECCE53B20666F6E742D73697A653A31347078223ECEF7B0B2CAC7D2BBB8F6CEC4BBAFB9C5B6BCA3ACD5E2C0EFC2F1D7C5D6D0B9FAC0FACAB7B4F3D0A1B3AFB4FAB4F3D4BC3732CEBBBBCAB5DBA1A3C6E4D6D0B1C8BDCFD3D0C3FBB5C4BECDCAC7C7D8CABCBBCAC1CBA3ACC7D8CABCBBCACDB3D2BBD6D0B9FAA3ACCAC7D6D0B9FAC0FACAB7C9CFB5DAD2BBB8F6BBCAB5DBA3ACB3F6C9FAD4DA3C2F7370616E3E3C6120636C6173733D22612D6E6F7465732D696E6E65726C696E6B2220687265663D22687474703A2F2F6C76796F752E62616964752E636F6D2F686562656922207374796C653D22746578742D6465636F726174696F6E3A206E6F6E653B20636F6C6F723A2072676228302C203132362C20323137293B20666F6E742D66616D696C793A20417269616C2C20CBCECCE53B20666F6E742D73697A653A20313470783B206C696E652D6865696768743A20323170783B22207461726765743D225F626C616E6B223EBAD3B1B13C2F613E3C7370616E207374796C653D22666F6E742D66616D696C793A617269616C2CCBCECCE53B20666F6E742D73697A653A31347078223EBAAAB5A6A3A8B0B3C3C7B4F3BAD3B1B1B5C4A3A9A3ACBFC9CFA7D3A2C4EAD4E7CAC5A3ACBBB9B2BBB5BD3530CBEAA1A3B2BBCBB5CBFBC9FAC7B0C1CBA3ACCBB5CBB5CBFBB5C4C1EAB0C9A3A8C6D5CDA8B0D9D0D5CBC0BAF3D7A1B5C4CAC7B7D8A3ACB5B1B9D9D3D0B5D8CEBBB5C4CBC0BAF3D7A1C4B9A3ACC4C7BBCAB5DBCBC0BAF3D7A1B5C4B5D8B7BDB3C6D6AECEAAC1EAA3A9A1A33C2F7370616E3E3C6120636C6173733D22612D6E6F7465732D696E6E65726C696E6B2220687265663D22687474703A2F2F6C76796F752E62616964752E636F6D2F71696E7368696875616E676C696E6722207374796C653D22746578742D6465636F726174696F6E3A206E6F6E653B20636F6C6F723A2072676228302C203132362C20323137293B20666F6E742D66616D696C793A20417269616C2C20CBCECCE53B20666F6E742D73697A653A20313470783B206C696E652D6865696768743A20323170783B22207461726765743D225F626C616E6B223EC7D8CABCBBCAC1EA3C2F613E3C7370616E207374796C653D22666F6E742D66616D696C793A617269616C2CCBCECCE53B20666F6E742D73697A653A31347078223ED5BCB5D8C3E6BBFDB4F3B8C5CAC7C1BDB8F63C2F7370616E3E3C6120636C6173733D22612D6E6F7465732D696E6E65726C696E6B2220687265663D22687474703A2F2F6C76796F752E62616964752E636F6D2F616F6D656E22207374796C653D22746578742D6465636F726174696F6E3A206E6F6E653B20636F6C6F723A2072676228302C203132362C20323137293B20666F6E742D66616D696C793A20417269616C2C20CBCECCE53B20666F6E742D73697A653A20313470783B206C696E652D6865696768743A20323170783B22207461726765743D225F626C616E6B223EB0C4C3C53C2F613E3C7370616E207374796C653D22666F6E742D66616D696C793A617269616C2CCBCECCE53B20666F6E742D73697A653A31347078223EC4C7C3B4B4F3A3ACCED2BADCB3D4BEAAA3ACCBE4C8BBCED2B2BBD6AAB5C0B0C4C3C5D3D0B6E0B4F3A3ACC8CBC3C7D0CEC8DDB4F3D0A1CFB2BBB6D3C3D7E3C7F2B3A1C0B4BAE2C1BFA3ACBEADB9FDCED2B5C4BCC6CBE3A3ACB0C4C3C5B4F3D4BCD3B4D3D034363230B8F6D7E3C7F2B3A1C4C7C3B4B4F3A3ACC4C7C7D8CABCBBCAC1EAC4D8A3ACB4F3D4BCD3D037393833B8F6D7E3C7F2B3A1C4C7C3B4B4F3A1A3A1A3A1A3A1A3C4C7BBCAB5DBC3C7CEAACAB2C3B4B6BCD4B8D2E2C0B4CEF7B0B2D5E2B8F6B5D8B7BDC4D8A3ACD6D0B9FAC8CBBDB2BEBFB7E7CBAEA3ACCEF7B0B2A3ACC4CFB2E0CAC73C2F7370616E3E3C6120636C6173733D22612D6E6F7465732D696E6E65726C696E6B2220687265663D22687474703A2F2F6C76796F752E62616964752E636F6D2F6C697368616E22207374796C653D22746578742D6465636F726174696F6E3A206E6F6E653B20636F6C6F723A2072676228302C203132362C20323137293B20666F6E742D66616D696C793A20417269616C2C20CBCECCE53B20666F6E742D73697A653A20313470783B206C696E652D6865696768743A20323170783B22207461726765743D225F626C616E6B223EE6EAC9BD3C2F613E3C7370616E207374796C653D22666F6E742D66616D696C793A617269616C2CCBCECCE53B20666F6E742D73697A653A31347078223EA3ACB1B1B1DFCAC7CEBCBAD3A3ACB7E7CBAEBAC3B0A1A1A3CBF9D2D4CED2D2BBD6B1CFEBC8A5CEF7B0B2A3ACBFB4BFB4D5E2CAC0BDE7B5DAB0CBB4F3C6E6BCA3A1A33C2F7370616E3E3C7370616E207374796C653D22666F6E742D66616D696C793A617269616C2CCBCECCE53B20666F6E742D73697A653A31347078223E266E6273703B3C2F7370616E3E3C2F703E3C703EB9D8D3DAC1BDC8D5D3CECDC6BCF6C2B7CFDFA3A8B4D3D4E7C9CFBFAACABCA3A9A3BA3C2F703E3C703E443120B1F8C2EDD9B8312E35D0A1CAB126726172723BC7D8CABCBBCAC1EA31D0A1CAB126726172723BBBAAC7E5B3D8A3A8BFC9D1A1A3A9322D33D0A1CAB126726172723BD6D3C2A5B9C4C2A531D0A1CAB126726172723BBBD8C3F1BDD6A3A8CDEDC9CFD7EEC8C8C4D6A3A93C2F703E3C703E443220B2A9CEEFB9DD32D0A1CAB126726172723BB4F3D1E3CBFE32D0A1CAB126726172723BCEF7B0B2B9C5B3C7C7BD32D0A1CAB13C2F703E3C703ED5E2CCF5C2B7CFDFCFE0B6D4B1C8BDCFB2BBBBE1C8C6C2B7A3ACB2CEB9DBB5C4CAB1BCE4B1C8BDCFB3E4D7E3A1A33C2F703E3C703E266E6273703B3C2F703E3C703E266E6273703B266E6273703B266E6273703B266E6273703B266E6273703B266E6273703B266E6273703B3C2F703E3C703E266E6273703B266E6273703B266E6273703B266E6273703B266E6273703B20266E6273703B20CBE4C8BBC8A5D6AEC7B0D3F6B5BDC1CBD0A9BFB2BFC0A1A33C2F703E3C703E266E6273703B3C2F703E3C703E266E6273703B266E6273703B266E6273703B266E6273703B266E6273703B266E6273703B20266E6273703B20C4C7CAC7D2BBB8F6D5FDD4C2B3F5C1F9A3ACD7F7CEAAD2BBB8F6D4DACDE2B4F2C6B4B5C4D3D0D6BEC7E0C4EAA3ACCED2D4E7D4E7B5C4BECDB5BDC1CBD2ECB5D8D7BCB1B8D3ADBDD3D0C2B5C4D2BBC4EAA1A3C4C7CAC7D2BBB8F6B3F5C6DFB5C4D4E7C9CFA3ACC6F0B4B2C7B0A3ACC0CFB0E5C3D8CAE9CDBBC8BBD4DAC8BAC0EFB7A2C1CBD2BBCCF5CFFBCFA2A3AC266C6471756F3BBDF1CCECB2BBC9CFB0E0C1CBA3ACBFC9C4DCD6DCC1F9C9CFB0E0A3ACB4F3BCD2D7F6BAC3D7BCB1B826726471756F3B3C696D67207372633D22687474703A2F2F696D672E62616964752E636F6D2F68692F6A78322F6A5F303030332E67696622207374796C653D22626F726465723A3070783B206D61782D77696474683A363030707822202F3E7965737E20BCD9C6DAD7E3D7E3D1D3B3A4C1CB33CCECA1A33C2F703E3C703E266E6273703B20266E6273703B20266E6273703B20266E6273703B20C4C7CED2B8C9B5E3CAB2C3B4A3ACC1BDCCECB5C4D0D0B3CCA3ACD2BBD6B1CFEBC8A5CEF7B0B2BBB9D3D0C2E5D1F47EC8A5C4C4C4D8A3ACB4F2BFAAC1CBB0D9B6C8C2C3D3CEBFCDBBA7B6CBA3AC32CCECB5C4D0D0B3CCA1A3CED2D3D6B4F2BFAAC1CB3132333036A3ACB2E9BFB4CFC2BBF0B3B5C6B1A3ACB0A6A3ACC8A5C2E5D1F4B5C4BBB0D3D0C8A5CEDEBBD8A1A3C4C7BECDCEF7B0B2B0C9A1A33C2F703E3C703E266E6273703B20266E6273703B20266E6273703B20266E6273703B20CED2BECDB6A9C1CBCAAFBCD2D7AFBFAACDF9CEF7B0B2B5C454323331B4CEC1D0B3B5A3ACD6BBD3D0D3B2D7F93231B5E33430BFAAB3B5A3ACB5DAB6FECCECD2BBD4E7B5BDA1A3C8BBBAF3BECDB2E9BEC6B5EAA3ACCEF7B0B2D3D0B2BCB6A1BEC6B5EAA3ACB2BCB6A1BEC6B5EACAC7D2BBB8F6CFE0B6D4B1C8BDCFB1E3D2CBB6F8C7D2BADCB8C9BEBBB5C4BFECBDDDC1ACCBF8BEC6B5EAA3ACD4A4B6A8C1CBB1B1B9D8B5D8CCFABFDAB5EAA3ACD4A4B8B6B7BFBFEEB2BBBFC9D2D4CDCBC5B6A3A8415050D7A8CFEDCCD8BCDBB4F3B4B2B7BFC5B6A3A9A1A3BBD8C0B4B5C4BBB0BECDC8A5CCABD4ADB5B9B3B5A3ACB6AFB3B5B5BDCCABD4ADA3ACC8BBBAF3D4DACCABD4ADB5BDCAAFBCD2D7AFA3ACB6A9C1CB4432353130CEF7B0B2B5BDCCABD4ADC4CFA3AC4B353230CCABD4ADB5BDCAAFBCD2D7AFB1B1A3ACCDEDC9CF3130B5E3B5BDA1A33C2F703E3C703E266E6273703B20266E6273703B20266E6273703B20266E6273703B20B0D1BEC6B5EABACDB3B5C6B1B6A8BAC3D6AEBAF3A3ACD6D0CEE7A3ACBDD3B5BDCFFBCFA2A3ACC3F7CCECC9CFB0E0266E6273703B20266E6273703B20266E6273703B20266E6273703B3C2F703E, '2015-05-13 11:40:18', '1', '125');
  INSERT INTO `t_diary` VALUES ('7', '参观世界第八大奇迹', 'Upload/9cc94c17-b943-43e4-814f-175c43650eba.jpg', 0x3C703ED0D0B3CCB8C5C0A8A3BA382E3330B5BDCEF7B0B2D5BE26726172723BBEC6B5EA26726172723BB1F8C2EDD9B826726172723B3C6120636C6173733D22612D6E6F7465732D696E6E65726C696E6B2220687265663D22687474703A2F2F6C76796F752E62616964752E636F6D2F71696E7368696875616E676C696E6722207374796C653D22746578742D6465636F726174696F6E3A206E6F6E653B20636F6C6F723A2072676228302C203132362C20323137293B22207461726765743D225F626C616E6B223EC7D8CABCBBCAC1EA3C2F613E26726172723BBBD8C3F1BDD626726172723BCEF7B0B2B9C5B3C7C7BD26726172723BBBD8BEC6B5EA3C2F703E3C703E266E6273703B266E6273703B266E6273703B266E6273703B266E6273703B266E6273703B266E6273703B266E6273703BD4E7C9CFB5BDB4EF3C6120636C6173733D22612D6E6F7465732D696E6E65726C696E6B2220687265663D22687474703A2F2F6C76796F752E62616964752E636F6D2F7869616E22207374796C653D22746578742D6465636F726174696F6E3A206E6F6E653B20636F6C6F723A2072676228302C203132362C20323137293B22207461726765743D225F626C616E6B223ECEF7B0B23C2F613ED6AEBAF3A3ACCED2BECDB8F9BEDDB0D9B6C8B5D8CDBCB5C4C2B7CFDFA3ACD5D2B5BDB9ABBDBB373035C2B7A3ACCFC8B4EFB5BDBEC6B5EAA3ACBDF8D0D0BCF2B5A5B5C4CFB4CAFED0DDD5FBA1A3B4F3B8C5D0DDCFA2C1CB31B8F6D0A1CAB1A1A3A1BECEF7B0B2BBF0B3B5D5BEB7C7B3A3C2D2A3ACBADCB6E0B9ABBDBBB2BBBAC3D5D2A3ACB1C8C8E7B9ABBDBB373035C2B7BECDCAC7D2BBB8F6B1C8BDCFC6ABB5C4A1BFA1A3C4E3C3E6B6D4BBF0B3B5D5BEA3ACD7F3B1DFCAC7CEF7A3ACD3D2B1DFCAC7B6ABA1A33C2F703E3C703E266E6273703B266E6273703B266E6273703B266E6273703B266E6273703BC8E7B9FBC4E3CFEBB4D3CEF7B0B2D5BED6B1BDD3B5BDB1F8C2EDD9B8BFC9D2D4B3F6D5BEBFDAD2BBD6B1CDF9B6ABD7DFA3ACB5BDC9CCBCF3C2B7D7F3D7AAA3ACB9FDC1CB3C6120636C6173733D22612D6E6F7465732D696E6E65726C696E6B2220687265663D22687474703A2F2F6C76796F752E62616964752E636F6D2F67756368656E677169616F6E6722207374796C653D22746578742D6465636F726174696F6E3A206E6F6E653B20636F6C6F723A2072676228302C203132362C20323137293B22207461726765743D225F626C616E6B223EB9C5B3C7C7BD3C2F613EA3ACB9FDC1CBD2BBCCF5BAD3BECDBFC9D2D4BFB4B5BDD2BBB8F6B3B5B3A1A3ACC4C7C0EFD3D0BADCB6E0C2C3D3CED7A8CFDFB5C4B3B5A3ACBFC9D2D4D6B1BDD3B5BD3C6120636C6173733D22612D6E6F7465732D696E6E65726C696E6B2220687265663D22687474703A2F2F6C76796F752E62616964752E636F6D2F68756171696E6763686922207374796C653D22746578742D6465636F726174696F6E3A206E6F6E653B20636F6C6F723A2072676228302C203132362C20323137293B22207461726765743D225F626C616E6B223EBBAAC7E5B3D83C2F613EA1A2B1F8C2EDD9B8A1A33C2F703E, '2015-05-13 11:41:54', '1', '356');
  INSERT INTO `t_diary` VALUES ('9', '一路向西: 西安/青海/甘南', 'Upload/75D8C33D2E5BF5D1B883BA44BD539A65.jpg', 0x3C70207374796C653D22746578742D616C69676E3A206A7573746966793B223E3C7370616E207374796C653D22636F6C6F723A72676228302C20302C2030293B20666F6E742D66616D696C793ACBCECCE52C73696D73756E3B20666F6E742D73697A653A31367078223EB2BBD6AAB4D3BACECAB1CFB2B0AEC9CFC1CBC2C3D0D0A1A3B4F3B5D6CAC7B4D3B5DAD2BBB4CEB5C43C6120636C6173733D22612D6E6F7465732D696E6E65726C696E6B2220687265663D22687474703A2F2F6C76796F752E62616964752E636F6D2F6875616E677368616E22207374796C653D22746578742D6465636F726174696F6E3A206E6F6E653B20636F6C6F723A2072676228302C203132362C20323137293B22207461726765743D225F626C616E6B223EBBC6C9BD3C2F613EBFAACABCBAF3A3ACB6D4D5E2B8F6CAC0BDE7B3E4C2FAC1CBBAC3C6E6A3ACECBDECBBB5C4B7E7BEB0A1A2D0CED0CEC9ABC9ABB5C4C8CBA3ACCFEBD6AACFFEB5C4D3D0CCABB6E0A1A3BBB7C7F2C2C3D0D0CAC7CCABB6E0C8CBB5C4C3CECFEBA3ACD2B2D4F8D4DACBAFC3CEC7B0E3BFE3BDB9FDA1A3CFD6CAB5CAC7C3BBD3D0BBF9B4A1B5C4BBA7CDE2BEADD1E9A1A2BFC9D2D4BDBBC1F7B5C4B9FABCCAD3EFD1D4A1A2D7E3B9BBC8C3D6AED3D0B0B2C8ABB8D0B5C4C2C3B7D1A3ACC8E7BACECAB5CFD6BBB7C7F2C2C3D0D0B5C4C3CECFEBA1A33C6272202F3E0D0A266E6273703B266E6273703BCFC8B4D3B9FAC4DABFAACABCC2FDC2FDB9DBBFB4CAC0BDE7A3A13C6272202F3E0D0A266E6273703B266E6273703BC5ACC1A6B9A4D7F7B0C9A3A1D5E2D1F9B2C5C4DCD3D0BBFABBE1C8C3C3CECFEBD5D5BDF8CFD6CAB5A1A33C6272202F3E0D0A3C6272202F3E0D0A266E6273703B266E6273703BD2BBD6B1CFE0D0C5A3ACC8CBD4DAB3F6C9FACAB1BECDB4F8D7C5D2BBD0A9BCB2B2A1A3ACD6D5BCBAD2BBC9FAA3ACB6BCCAC7CEAAC1CBB0DACDD1CBFCA1A3BCC5C4AFA1A2BCB5B6CAA1A2D7D4B1B0A1A2B2C2BCC9A1A2C6B6C7EEA1A2BBD1D1D4A1A2CCB0C0B7A1A2ECE5C6F8266D6964646F743B266D6964646F743B266D6964646F743B266D6964646F743B266D6964646F743B3C6272202F3E0D0A266E6273703B266E6273703BC5C5D0F2A3BAD7D4B1B0A1A2BBD1D1D4A1A2ECE5C6F8A1A2CCB0C0B7A1A2BCC5C4AFA1A2B2C2BCC9A1A2C6B6C7EEA1A3BCB5B6CAB4D3C0B4CEDEB9D8D3EBBCBAA1A33C6272202F3E0D0A266E6273703B266E6273703BB9FDD3DAC1CBBDE2D7D4BCBAB5C4C1D3B8F9D0D4A3ACD6BBCAC7CCABC4D1D2D4B8FCB8C4A1A33C2F7370616E3E3C6272202F3E0D0A266E6273703B3C2F703E0D0A3C646976207374796C653D22666F6E742D66616D696C793A20417269616C2C20CBCECCE53B20666F6E742D73697A653A20313470783B206C696E652D6865696768743A20323170783B20746578742D616C69676E3A206A7573746966793B223E3C7370616E207374796C653D22636F6C6F723A72676228302C20302C2030293B20666F6E742D66616D696C793ACBCECCE52C73696D73756E3B20666F6E742D73697A653A31367078223E3C6120687265663D22687474703A2F2F6261696B652E62616964752E636F6D2F766965772F343639362E68746D22207374796C653D22746578742D6465636F726174696F6E3A206E6F6E653B20636F6C6F723A2072676228302C203132362C20323137293B22207461726765743D225F626C616E6B223E3C7370616E207374796C653D22636F6C6F723A72676228302C20302C203029223EB7F0BDCC3C2F7370616E3E3C2F613ED6D0B5C43C6120687265663D22687474703A2F2F6261696B652E62616964752E636F6D2F766965772F3234393838352E68746D22207374796C653D22746578742D6465636F726174696F6E3A206E6F6E653B20636F6C6F723A2072676228302C203132362C20323137293B22207461726765743D225F626C616E6B223E3C7370616E207374796C653D22636F6C6F723A72676228302C20302C203029223EC8FDB6BE3C2F7370616E3E3C2F613EA3BACCB0A3BABFCAC8A1D2BBC7D0CBB3BEB3A1A3E0C1A3BAB6D4CBF9D3F6C4E6BEB3D2FDC6F0B7DEC5ADA1A3266E6273703BB3D5A3BAD0C4D6C73C6120687265663D22687474703A2F2F6261696B652E62616964752E636F6D2F737562766965772F3437313831372F353037373933342E68746D22207374796C653D22746578742D6465636F726174696F6E3A206E6F6E653B20636F6C6F723A2072676228302C203132362C20323137293B22207461726765743D225F626C616E6B223E3C7370616E207374796C653D22636F6C6F723A72676228302C20302C203029223EE3C2B6AE3C2F7370616E3E3C2F613EA3ACB2BBC3F7CAC2C0EDA3ACB5DFB5B9CDFDC8A1A3ACC6F0D6EED0B0D0D0A1A33C6272202F3E0D0A3C6272202F3E0D0A266E6273703B266E6273703BE0C1A3ACD3D0CBF9B6D9CEF2A3ACD3D0CBF9CCE1D0D1A3ACD3D0CBF9B3C9D0A7A1A3BFC9D2D4D7F6B5BDBECDB4FAB1EDD3D0CBF9B6D9CEF2A3ACB7B4D6AED6BBCAC7D6AACFFEA1A3D4DAD2ECB3A3C9FAC6F8CAB1B1F0C8CBB6BCBBE1C8B0BDE2CBB5B2BBD2AAD3C3B1F0C8CBB5C4B4EDCEF3C0B4B3CDB7A3D7D4BCBAA3ACB5ABB4F3B6E0CAB1BAF2CAB1D7F6B2BBB5BDB5C4BBB9CAC7BBE1B7A2C5ADA1A3B5ABBBE1B2BBCDA3B5C4B8E6BDEBD7D4BCBAB2BBD2AAC9FAC6F8A3ACD7D4CED2B5C4B2BBCDA3C8B0BDE2A3ACBBF2CFEBD2BBD0A9C6E4CBFCCAC2C7E9C0B4D7AAD2C6D7D4BCBAB5C4D7A2D2E2C1A6A3ACB6D4D2D1BADCD3D0D0A7A1A3D5E2CAC7D2BBB8F6B9FDB3CCA3ACD3C3CAB1BCE4C0B4D6A4C3F7BACECAB1BFC9D2D4D7F6B5BDC3BBD3D0C5ADC4EEA1A3C5CED5E2D2BBCCECD4E7D0A9C0B4A1A33C6272202F3E0D0A266E6273703B266E6273703BCCB0A3ACCCB0C1B5CAB3CEEFA1A2CCB0C3D4D2BBC7D0C3C0BAC3CAC2CEEFA1A2CCB0CBBCCDF6C8CBA1A2CCB0CFEBD0E9CEDEE7CEE7BFB5C4D7D4CED2B0B2C8ABB8D0A1A2CCB0BBC3C8B7C8CFB5C4B0AE266D6964646F743B266D6964646F743B266D6964646F743B266D6964646F743B266D6964646F743B266D6964646F743B3C6272202F3E0D0A266E6273703B266E6273703BCBB5CED2CEDED3FBCEDEC7F3B5C4C8CBCAC7C3BBD3D0C9EEB6C8C1CBBDE2B9FDA3ACB2BBB9FDD6BBCAC7B6D4B4F3D6DACFB2B0AEB5C4B7BFA1A2B3B5A1A2C9DDB3DEC6B7C3BBD3D0C4C7C3B4C5A8BAF1B7C7D2AAB5C3B5BDB5C4D0CBC8A4B0D5C1CBA3ACB5ABB2BBB1EDCABECEDED3FBCEDEC7F3A1A33C6272202F3E0D0A266E6273703B266E6273703BB3D5A3AC266E6273703BD4DDCEDEA1A33C2F7370616E3E3C2F6469763E0D0A0D0A3C70207374796C653D22746578742D616C69676E3A206A7573746966793B223E3C7370616E207374796C653D22636F6C6F723A72676228302C20302C2030293B20666F6E742D66616D696C793ACBCECCE52C73696D73756E3B20666F6E742D73697A653A31367078223E266E6273703B266E6273703B266E6273703B266E6273703B3C6272202F3E0D0A266E6273703B266E6273703B266E6273703BD7D4CAA1A1A3D3A6B8C3B6E0B7B4CAA1D7D4BCBAB5C4D1D4D0D0A3ACB6E0B6E0BFBCC2C7B6D4B7BDB5C4B8D0CADCA1A3D2D1CAC7B3C9C4EAC8CBA3ACB2BBBFC9D4D9BDE8D3C9D0A1BAA2D7D3B5C4B1EAD7BCB6F8CBC1D2E2CDFDCEAAA1A3C9EDB1DFD3D0D2BBD0A9C8CBB5C4D1DBBEA6B4F3B6E0CAB1BAF2CAC7D6BBBFB4B5BDB1F0C8CBB5C4C8B1B5E3A3ACBFB4C8CBBFB4CAC2B5DAD2BBCAB1BCE4BFB4B5BDB6D4B7BDB5C4CAC7C8B1B5E3C1D3CAC2D3A6D7D4CED2B7B4CAA1A3ACC4DAD0C4B2BBB9BBC3F7C1C1B5C4C8CBBADCC4D1BFECC0D6A3ACD3D0D5E2D0A9CAB1BCE4BACEB2BBBBA8C0B4C9F3CAD3D7D4BCBAA1A33C6272202F3E0D0A266E6273703B266E6273703BB0FCC8DDA1A3D7DCCAC7BFBCC2C7D7D4BCBACCABB6E0A3ACCFEBB1F0C8CBCCABC9D9A3ACD5E2D1F9B5C4D0C4BEB3D6D5BEBFD3D0D0A9CFC1B0AFA1A3CBF9D2D4D3D0D0A9CAB1BAF2D1D4D3EFBBE1B3E5D7B2A1A3B5AB3235CBEAB5C4CED2C4DCD7F6B5C4CAC7B2BBB6CFB5C4B7B4CAA1B2A2C5ACC1A6D0DED5FDA1A3266E6273703B266E6273703B3C6272202F3E0D0A266E6273703B266E6273703B3C6272202F3E0D0A266E6273703B266E6273703BBEA1C1A6B3C9CEAAD2BBB8F6D7D4BCBACFB2B0AED7D4BCBAB5C4C8CBA3A13C2F7370616E3E3C2F703E, '2015-05-13 11:47:35', '1', '130');
  INSERT INTO `t_diary` VALUES ('12', '四天玩转了西安五千年', 'Upload/2012-12-4-16-29-37.jpg', 0x3C70207374796C653D22746578742D616C69676E3A6A757374696679223E266E6273703B3C2F703E3C70207374796C653D22746578742D616C69676E3A6A757374696679223E3C7370616E207374796C653D22666F6E742D73697A653A31367078223E3C7370616E207374796C653D22666F6E742D66616D696C793ACBCECCE52C73696D73756E223E44415931A3BACFC2CEE7D7F8B7C9BBFAB5BDCEF7B0B2B2A2C8EBD7A1A1A33C2F7370616E3E3C2F7370616E3E3C2F703E3C70207374796C653D22746578742D616C69676E3A6A757374696679223E3C7370616E207374796C653D22666F6E742D73697A653A31367078223E3C7370616E207374796C653D22666F6E742D66616D696C793ACBCECCE52C73696D73756E223EB9E3D6DDB0D7D4C6BBFAB3A1BAF2BBFAC2A53C2F7370616E3E3C2F7370616E3E3C2F703E3C70207374796C653D22746578742D616C69676E3A6A757374696679223E3C7370616E207374796C653D22666F6E742D73697A653A31367078223E3C7370616E207374796C653D22666F6E742D66616D696C793ACBCECCE52C73696D73756E223E444159323A3C2F7370616E3EB0D7CCECA3BAB1F8C2EDD9B8A1A23C6120636C6173733D22612D6E6F7465732D696E6E65726C696E6B2220687265663D22687474703A2F2F6C76796F752E62616964752E636F6D2F68756171696E6763686922207374796C653D22746578742D6465636F726174696F6E3A206E6F6E653B20636F6C6F723A2072676228302C203132362C20323137293B22207461726765743D225F626C616E6B223EBBAAC7E5B3D83C2F613EBACDE6EAC9BDA3A8D3C9D3DACCECC6F8D4ADD2F2C8A1CFFBC1CBBBAAC7E5B3D8BACD3C6120636C6173733D22612D6E6F7465732D696E6E65726C696E6B2220687265663D22687474703A2F2F6C76796F752E62616964752E636F6D2F6C697368616E22207374796C653D22746578742D6465636F726174696F6E3A206E6F6E653B20636F6C6F723A2072676228302C203132362C20323137293B22207461726765743D225F626C616E6B223EE6EAC9BD3C2F613ED6AED0D0A3A9A1A3CDEDC9CFA3BAB4F3D1E3CBFEC5E7C8AAB9E3B3A1A1A2D6D3C2A5BACDB9C4C2A5A1A33C2F7370616E3E3C2F703E3C70207374796C653D22746578742D616C69676E3A6A757374696679223E3C7370616E207374796C653D22666F6E742D73697A653A31367078223E3C7370616E207374796C653D22666F6E742D66616D696C793ACBCECCE52C73696D73756E223EB1F8C2EDD9B8D2BBBAC5BFD3D5B9C0C0CCFC3C2F7370616E3E3C2F7370616E3E3C2F703E3C70207374796C653D22746578742D616C69676E3A6A757374696679223E266E6273703B3C2F703E3C70207374796C653D22746578742D616C69676E3A6A757374696679223E3C7370616E207374796C653D22666F6E742D73697A653A31367078223E3C7370616E207374796C653D22666F6E742D66616D696C793ACBCECCE52C73696D73756E223E444159333A3C2F7370616E3E3C2F7370616E3E3C2F703E3C70207374796C653D22746578742D616C69676E3A6A757374696679223E3C7370616E207374796C653D22666F6E742D73697A653A31367078223E3C7370616E207374796C653D22666F6E742D66616D696C793ACBCECCE52C73696D73756E223EB0D7CCECA3BA3C6120636C6173733D22612D6E6F7465732D696E6E65726C696E6B2220687265663D22687474703A2F2F6C76796F752E62616964752E636F6D2F67756368656E677169616F6E6722207374796C653D22746578742D6465636F726174696F6E3A206E6F6E653B20636F6C6F723A2072676228302C203132362C20323137293B22207461726765743D225F626C616E6B223EB9C5B3C7C7BD3C2F613EA1A2BBD8C3F1BDD6BACDC9C2CEF7CAA13C6120636C6173733D22612D6E6F7465732D696E6E65726C696E6B2220687265663D22687474703A2F2F6C76796F752E62616964752E636F6D2F6C69736869626F77756775616E22207374796C653D22746578742D6465636F726174696F6E3A206E6F6E653B20636F6C6F723A2072676228302C203132362C20323137293B22207461726765743D225F626C616E6B223EC0FACAB7B2A9CEEFB9DD3C2F613EA1A33C2F7370616E3E3C2F7370616E3E3C2F703E3C70207374796C653D22746578742D616C69676E3A6A757374696679223E3C7370616E207374796C653D22666F6E742D73697A653A31367078223E3C7370616E207374796C653D22666F6E742D66616D696C793ACBCECCE52C73696D73756E223ECDEDC9CFA3BAB4F3CCC6DCBDC8D8D4B03C2F7370616E3E3C2F7370616E3E3C2F703E3C70207374796C653D22746578742D616C69676E3A6A757374696679223E3C7370616E207374796C653D22666F6E742D73697A653A31367078223E3C7370616E207374796C653D22666F6E742D66616D696C793ACBCECCE52C73696D73756E223EB9C5B3C7C7BD3C2F7370616E3E3C2F7370616E3E3C2F703E3C70207374796C653D22746578742D616C69676E3A6A757374696679223E266E6273703B3C2F703E3C70207374796C653D22746578742D616C69676E3A6A757374696679223E3C7370616E207374796C653D22666F6E742D73697A653A31367078223E3C7370616E207374796C653D22666F6E742D66616D696C793ACBCECCE52C73696D73756E223E444159343A3C2F7370616E3E3C2F7370616E3E3C2F703E3C70207374796C653D22746578742D616C69676E3A6A757374696679223E3C7370616E207374796C653D22666F6E742D73697A653A31367078223E3C7370616E207374796C653D22666F6E742D66616D696C793ACBCECCE52C73696D73756E223EB0D7CCECA3BAB4F3C3F7B9ACD2C5D6B7B9ABD4B0A1A2B0A2B7BFB9ACA3A8BAF3C0B4CCFDB1BEB5D8C8CBCBB5D3C9D3DABEADD3AAB7BDD6D8D7E9D2D1BEADBFAACABCB2F0D0B62CBAF3C0B4B0D1D0D0B3CCB8C4CEAAC7FABDADB3D8D2C5D6B7B9ABD4B0A3A93C2F7370616E3E3C2F7370616E3E3C2F703E3C70207374796C653D22746578742D616C69676E3A6A757374696679223E3C7370616E207374796C653D22666F6E742D73697A653A31367078223E3C7370616E207374796C653D22666F6E742D66616D696C793ACBCECCE52C73696D73756E223ECDEDC9CFA3BAD0DDCFA2A3A8D3C9D3DAD0D0B3CCB8C4B1E4A3ACB4D3C7FABDADB3D8D2C5D6B7B9ABD4B0D4D9B5BDB4F3D1E3CBFEBACDB4F3CCC6B2BBD2B9B3C7A3A93C2F7370616E3E3C2F7370616E3E3C2F703E3C70207374796C653D22746578742D616C69676E3A6A757374696679223E3C7370616E207374796C653D22666F6E742D73697A653A31367078223E3C7370616E207374796C653D22666F6E742D66616D696C793ACBCECCE52C73696D73756E223EB4F3C3F7B9ACD2C5D6B7B9ABD4B03C2F7370616E3E3C2F7370616E3E3C2F703E3C703E266E6273703B3C2F703E, '2015-05-14 11:32:22', '1', '97');
  
  -- ----------------------------
  -- Table structure for `t_place`
  -- ----------------------------
  DROP TABLE IF EXISTS `t_place`;
  CREATE TABLE `t_place` (
    `placeId` int(11) NOT NULL AUTO_INCREMENT,
    `placeName` varchar(255) DEFAULT NULL,
    `placeImage` varchar(255) DEFAULT NULL,
    `placeType` varchar(255) DEFAULT NULL,
    `placeLocation` varchar(255) DEFAULT NULL,
    `ray_x` varchar(255) DEFAULT NULL,
    `ray_y` varchar(255) DEFAULT NULL,
    `placeInfo` varchar(255) DEFAULT NULL,
    `placeRate` varchar(255) DEFAULT NULL,
    `placeCost` varchar(255) DEFAULT NULL,
    `placeHot` int(11) DEFAULT NULL,
    PRIMARY KEY (`placeId`)
  ) ENGINE=InnoDB AUTO_INCREMENT=10162 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of t_place
  -- ----------------------------
  INSERT INTO `t_place` VALUES ('10001', '华山', 'Upload/hs.jpg', '名胜山水', null, '110.089809', '34.527387', '奇险天下第一山，西峰绝壁，东峰日出，南峰奇松，北峰云雾，名不虚传。华山风景美不胜收，索道非常壮观，雪景也很美。门票性价比很高，而且服务真的很好。', '4.6', '180', '1531');
  INSERT INTO `t_place` VALUES ('10002', '兵马俑', 'Upload/bmy.jpg', '历史遗迹', '273152480', '109.291934', '34.39444', '秦始皇陵兵马俑位于陕西省西安市以东35公里的临潼区秦始皇陵兵马俑陪葬坑内，于公元前246年至公元前208年修建。现已发现和真人、真马大小相似的陶俑、陶马近8000件。有车兵、骑兵和步兵等不同的兵种，排列整齐有序。陶俑的形象各不相同，被誉为“世界第八大奇迹”、“二十世纪考古史上的伟大发现之一”', '4.5', '120', '3224');
  INSERT INTO `t_place` VALUES ('10003', '钟楼', 'Upload/zl.jpg', '历史遗迹', '', '108.95344', '34.265657', '钟楼和鼓楼不远，但是门票有点贵。不过是个很棒的地方，去看看还是不错的。晚上灯光一开很漂亮，特别宏伟，古朴大气，而且非常精致的机械设计。', '4.1', '35', '1371');
  INSERT INTO `t_place` VALUES ('10004', '鼓楼', 'Upload/gl.jpg', '历史遗迹', '', '108.949903', '34.266395', '但凡历史悠久的地方都有鼓楼，离钟楼不远可以去看看。外观漂亮，建筑风格独特，而且很有历史感，但是将近四十的门票实在太贵。周围有很多美食和特色的街道，推荐去买矮子饼。', '4', '35', '875');
  INSERT INTO `t_place` VALUES ('10005', '回民街', 'Upload/hmj.jpg', '古镇民俗', '', '108.949881', '34.267932', '西安最出名的一条小吃街，有很多种类的特色小吃。回民街上的建筑是清真风格，牛羊肉味道太过于浓郁但是很正宗，肉夹馍味道独特，推荐贾三家灌汤包，吃货们可以去看看。', '4.2', '0', '2473');
  INSERT INTO `t_place` VALUES ('10006', '西安古城墙', 'Upload/xacq.jpg', '历史遗迹', '', '108.953323', '34.258153', '西安古城墙是中国古代著名的城垣建筑，也是保存最完整的古城墙。历史感很强大，而且雄伟的古城墙气势无比恢宏。在西安古城墙上骑自行车真的很爽，风景很好，可以去走走看看。', '4.4', '40', '2162');
  INSERT INTO `t_place` VALUES ('10007', '书院门', 'Upload/sym.jpg', null, '', '108.953656', '34.259272', '西安人通常所说的“书院门”，指的是从碑林到关中书院门口的一条步行街。 从西安钟楼南行，将至南门往东拐，便是书院门古文化街，街口有一座古韵十足的高大牌楼，牌楼上方是“书院门”三个金色颜体大字，两旁是“碑林藏国宝，书院育人杰”的醒目对联，街道两旁是清一色仿古建筑，街道为青石铺砌。', '4', '0', '331');
  INSERT INTO `t_place` VALUES ('10008', '陕西历史博物馆', 'Upload/lsbwg.jpg', null, '', '108.961428', '34.229386', '陕西历史博物馆浓缩了中原文化的精髓，能够感受陕西悠久的古代历史文明。门票是免费的，但是找个导游则更好。博物馆里面内容非常丰富，很多精美藏品，并且很多都是非常珍贵的文物。', '4.5', '0', '1850');
  INSERT INTO `t_place` VALUES ('10009', '大雁塔', 'Upload/dyt.jpg', null, '', '108.970504', '34.227401', '大雁塔倒是值得上去一次看看的，但是又要收比较贵的门票，广场的喷泉很壮观，是保存比较完好的楼阁式塔。', '4.2', '50', '2465');
  INSERT INTO `t_place` VALUES ('10010', '小雁塔', 'Upload/xyt.jpg', null, '', '108.948943', '34.247136', '著名唐代佛塔，是唐朝都城长安（西安）保留至今的两处重要建筑之一。 小雁塔的塔形秀丽，被认为是唐代精美的佛教建筑艺术遗产，小雁塔在唐、宋朝时期一直叫“荐福寺塔”，至于“小雁塔”之名，则和“大雁塔”的名称有关。', '4.1', '30', '618');
  INSERT INTO `t_place` VALUES ('10011', '大唐芙蓉园', 'Upload/dtfry.jpg', null, '', '108.980379', '34.218454', '景区内环境比较好，但就是票价有点贵。很大气的仿古园林，感觉印象最深的还是梦回大唐歌舞表演。', '4.1', '120', '1246');
  INSERT INTO `t_place` VALUES ('10013', '大明宫国家遗址公园', 'Upload/dmgyzgy.jpg', null, '', '108.972371', '34.29647', '唐大明宫是东方园林建筑艺术的杰出代表，被誉为丝绸之路的东方圣殿。大明宫面积很大，超大的开放公园，遗址复建等正在建设中。大气恢弘的含元殿，是其中最壮观的宫殿。', '3.9', '60', '382');
  INSERT INTO `t_place` VALUES ('10014', '华清池', 'Upload/hqc.jpg', null, '', '109.219934', '34.370442', '杨贵妃的故事赋予了华清池浪漫唯美的色彩，唐风建筑很多，园林设计很美，景点维护的也不错。票价较贵，导游很专业，讲解很仔细，服务也很好，而且温泉不错。', '4', '110', '1417');
  INSERT INTO `t_place` VALUES ('10015', '骊山', 'Upload/ls.jpg', null, '', '109.216498', '34.358687', '骊山国家森林公园，位于陕西省西安市临潼县城南，距离西安市区30多公里，最高峰九龙顶海拔1301.9米。', '3.9', '70', '572');
  INSERT INTO `t_place` VALUES ('10016', '曲江池遗址公园', 'Upload/qjcyzgy.jpg', null, '', '108.988649', '34.207565', '遗址公园再造曲江南湖、曲江流饮、汉武泉、宜春苑、凤凰池等历史文化景观，再现曲江地区“青林重复，绿水弥漫”的山水人文格局。而且适合散步的地方。', '4.2', '0', '311');
  INSERT INTO `t_place` VALUES ('10017', '秦岭野生动物园', 'Upload/qlysdwy.jpg', null, '', '108.856896', '34.05842', '秦岭野生动物园位于秦岭北麓浅山地带，距西安市区28公里。是集野生动物移地保护、科普教育、旅游观光、休闲度假等功能于一体的综合性园林项目。西安秦岭野生动物园是西北首家野生动物园。', '3.9', '100', '249');
  INSERT INTO `t_place` VALUES ('10018', '曲江海洋馆', 'Upload/qjhyg.jpg', null, '', '108.98598', '34.221252', '西安曲江海洋馆，位于西安曲江新区规划的核心旅游景园区内，西临大雁塔，南与大唐芙蓉园一路之隔，和曲江南湖、寒窑等人文景观交相辉映。 海洋馆由四馆八区组成：海豚表演馆，海洋科普馆，热带雨林馆、海底隧道四馆及入场区、科普区、雨林体验区、海底体验区、中央演艺区、消费服务区、海底大观区、设备区等八区。 ', '3.9', '100', '159');
  INSERT INTO `t_place` VALUES ('10019', '大唐不夜城', 'Upload/dtbyc.jpg', null, '', '108.970811', '34.221185', '大唐不夜城项目位于西安曲江新区举世闻名的大雁塔脚下，是陕西省、西安市重点建设项目。 该项目以盛唐文化为背景，以唐风元素为主线，以体验消费为特征，着力打造集购物、餐饮、娱乐、休闲、旅游、商务为一体的一站式消费天堂——中国第一文化MALL。', '4', '0', '331');
  INSERT INTO `t_place` VALUES ('10020', '翠华山', 'Upload/chs.jpg', null, '', '109.013004', '33.999399', '风景区拥有秀美的湖光山色和其国内罕见的山崩地貌。植被茂密景色宜人，沿途风光也很美，山顶尤其壮观。夏日去会很凉爽，游客众多。', '4.2', '70', '290');
  INSERT INTO `t_place` VALUES ('10021', '沣峪口', 'Upload/fyk.jpg', null, '', '108.81001', '34.038828', '沣峪口位于陕西省西安市长安区滦镇街道，是秦岭的一条山沟，沿途有观音禅院等景点。', '4', '0', '129');
  INSERT INTO `t_place` VALUES ('10022', '西安植物园', 'Upload/zwy.jpg', null, '', '108.966355', '34.213595', '位于西安市大雁塔旁，占地面积20公顷，收集保存植物3400余种（含品种），保存国家重点保护的珍稀濒危植物32科70余种，是目前西北地区引种保存植物种类最多的植物园。 ', '4.1', '10', '113');
  INSERT INTO `t_place` VALUES ('10023', '西安事变纪念馆', 'Upload/xnsbjng.jpg', null, '', '108.973596', '34.263583', '西安事变纪念馆设在张学良公馆，1986年12月在纪念西安事变五十周年之际正式对外开放。 周恩来、叶剑英等到西安后，即住在张公馆的东楼，在中楼与张学良、杨虎城会谈，并和二人与南京政府代表宋子文等谈判。', '4.1', '0', '242');
  INSERT INTO `t_place` VALUES ('10025', '高冠瀑布', 'Upload/ggpb.jpg', null, '', '108.767723', '34.004075', '高冠瀑布位于陕西省西安市户县东南20千米的秦岭北麓圭峰山的高冠峪口。 因高冠峪两侧有一高耸的秀峰，形似巨人，头戴高帽，故被称为高冠峪，对瀑布亦呼为高冠瀑布。', '3.8', '15', '112');
  INSERT INTO `t_place` VALUES ('10026', '半坡遗址博物馆', 'Upload/bpyzbwg.jpg', null, '', '109.052839', '34.27718', '西安半坡遗址是一个非常值得去的一个景点，景点就两个馆值得参观，人民的智慧赞不绝口，环境古朴典雅，而且很有意义。馆内陈列比较丰富，在历史文化悠久的西安。', '4', '65', '181');
  INSERT INTO `t_place` VALUES ('10027', '大唐西市', 'Upload/dtxs.jpg', null, '', '108.915005', '34.252812', '全国唯一在原址上重建的项目。 在唐朝当时西市占地1600 多亩，建筑面积100万平方米，有220 多个行业，固定商铺4 万多家，被誉为“金市”，是当时世界上最大的商贸中心“ ', '4.1', '0', '149');
  INSERT INTO `t_place` VALUES ('10028', '西安博物院', 'Upload/xabwy.jpg', null, '', '108.945837', '34.244196', '西安博物院位于陕西省西安市南门外友谊西路。由文物展馆区、小雁塔以及荐福寺为核心的历史名胜区、园林游览区三部分组成。西安博物院集博物馆、名胜古迹、城市园林为一体。2007年对外开放。以展示的珍贵文物，唐代千年古塔、悠扬的雁塔晨钟、秀丽的园林景观而闻名。', '4.3', '0', '160');
  INSERT INTO `t_place` VALUES ('10029', '兴庆宫', 'Upload/xqg.jpg', null, '', '108.994344', '34.260003', '兴庆宫，位于唐都长安外郭城东部的兴庆坊（隆庆坊），这里曾是唐玄宗李隆基的旧宅，玄宗未即位前曾与其兄弟居住于此。兴庆宫是唐玄宗（唐明皇）时代的国家政治中心所在，也是和他的爱妃杨玉环（杨贵妃）长期居住的地方，宫内建有兴庆殿、南熏殿、大同殿、勤政务本楼，花萼相辉楼和沉香亭等建筑物。 兴庆宫历经扩建，占地达2016亩，超过我国现存最大、最完整的建筑群－－明清故宫的面积（1087亩）', '3.8', '0', '133');
  INSERT INTO `t_place` VALUES ('10035', '广仁寺', 'Upload/grs.jpg', null, '', '108.93229', '34.279857', '坐落在西安城内西北角，是西北和康藏一带大喇嘛进京路过陕西时的行宫，因此又称“喇嘛寺”。 广仁寺是陕西省唯一的藏传佛教寺院，1703年由清圣祖康熙帝敕建，历史上起着凝聚、促进西北边陲多民族团结的作用。', '4.2', '20', '112');
  INSERT INTO `t_place` VALUES ('10057', '乾陵', 'Upload/ql.jpg', null, '', '108.226309', '34.577231', '乾陵，位于陕西咸阳市乾县城北6公里的梁山上，是陕西关中地区唐十八陵之一。 乾陵是中国乃至世界上独一无二的一座两朝帝王、一对夫妻皇帝合葬陵。', '4.1', '122', '203');
  INSERT INTO `t_place` VALUES ('10058', '袁家村', 'Upload/yjc.jpg', null, '', '108.545342', '34.597254', '袁家村坐落在礼泉县烟霞镇北面的九嵕山下，处在西咸半小时经济圈内，距西安一个小时车程，是目前全省乃至全国最受欢迎的乡村旅游胜地。', '4', '0', '143');
  INSERT INTO `t_place` VALUES ('10070', '法门寺', 'Upload/fms.jpg', null, '', '107.911678', '34.439422', '法门寺位于陕西省宝鸡市扶风县城北10公里处的法门镇，东距西安市120公里，西距宝鸡市96公里。 法门寺旅游区是国家AAAAA级景区。始建于东汉末年，恒灵年间，距今约有1700多年历史，有“关中塔庙始祖”之称。发迹于北魏，起兴于隋，鼎盛于唐，被誉为“皇家寺庙”，因安置释迦牟尼佛指骨舍利而成为举国仰望的佛教圣地。', '4', '120', '249');
  INSERT INTO `t_place` VALUES ('10110', '黄帝陵', 'Upload/hdl.jpg', null, '', '109.280487', '35.587062', '黄帝陵，是中华民族始祖黄帝轩辕氏的陵墓，位于黄陵县城北桥山。1961年，国务院将黄帝陵公布为全国第一批全国重点文物保护单位，号称“天下第一陵”。', '4.1', '85', '114');
  INSERT INTO `t_place` VALUES ('10112', '宝塔山', 'Upload/bts.jpg', null, '', '109.5032', '36.600141', '宝塔山，位于延安城区中心，是革命圣地延安的标志性建筑，是游览延安的必去之地。山上现已建成为宝塔山公园，林木葱郁，环境优美。宝塔山是融自然景观与人文景观为一体、历史文物与革命旧址合二而一的著名风景名胜区。', '4', '65', '149');
  INSERT INTO `t_place` VALUES ('10113', '延安革命纪念馆', 'Upload/yagmjng.jpg', null, '', '109.484352', '36.613968', '延安革命纪念馆位于宝塔区西北延河东岸。纪念馆内展出了大量珍贵革命文物、文献和照片，按历史顺序分列11个单元，400多米长的展览大厅，以1000多幅历史照片和800多件革命文物，生动、形象地再现了老一辈革命家在延安住窑洞、吃小米、驱日寇的光辉业绩。', '4.3', '0', '136');
  INSERT INTO `t_place` VALUES ('10114', '枣园', 'Upload/zy.jpg', null, '', '109.428553', '36.633613', '枣园革命旧址位于延安城西北约8公里处，是中共中央书记处1943年10月至1947年3月的所在地。枣园又名延园，占地面积54万多平方米。园内树木葱郁、绿草如茵、花团锦簇。', '4.1', '0', '124');
  INSERT INTO `t_place` VALUES ('10161', '壶口瀑布', 'Upload/hkpb.jpg', null, '', '110.455575', '36.151234', '中国黄河上的著名瀑布,世界上最大的黄色瀑布 位于宜川县城以东35公里，吉县城西45公里处的秦晋大峡谷黄河河床中,东濒山西省临汾市吉县壶口镇，西临陕西省延安市宜川县壶口乡。', '4.6', '75', '408');
  
  -- ----------------------------
  -- Table structure for `t_user`
  -- ----------------------------
  DROP TABLE IF EXISTS `t_user`;
  CREATE TABLE `t_user` (
    `userId` int(11) NOT NULL AUTO_INCREMENT,
    `userName` varchar(255) DEFAULT NULL,
    `userMail` varchar(255) DEFAULT NULL,
    `userPwd` varchar(255) DEFAULT NULL,
    `userSex` varchar(255) DEFAULT NULL,
    `userBirth` varchar(255) DEFAULT NULL,
    `userHome` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`userId`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of t_user
  -- ----------------------------
  INSERT INTO `t_user` VALUES ('1', '程', 'cheng@qq.com', '89975c5e5d407916e8080d137c48ddd7', '男', '1989-5-11', '315');
  INSERT INTO `t_user` VALUES ('2', '王斌', 'wang@qq.com', '362941d29aa54817a10871f726f42e3f', '男', '1987-4-26', '324');
  