全国省市县SQL数据库

最新推荐文章于 2025-05-16 16:10:33 发布
adminwoc
最新推荐文章于 2025-05-16 16:10:33 发布
阅读量1.9k
点赞数 1
CC 4.0 BY-SA版权
分类专栏：数据库
本文链接：https://blog.youkuaiyun.com/yangxuesong5555/article/details/99579749
本文分享了如何整理和构建全国省市县的SQL数据库，包括数据来源、数据清洗过程及数据库结构设计，对于地理信息处理和数据分析项目具有参考价值。
摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >
CREATE TABLE `city` (
  `id` int(11) NOT NULL DEFAULT '0',
  `pid` int(11) DEFAULT NULL,
  `cityname` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of city
-- ----------------------------
INSERT INTO `city` VALUES ('1', '0', '中国', '0');
INSERT INTO `city` VALUES ('2', '1', '北京', '1');
INSERT INTO `city` VALUES ('3', '1', '安徽', '1');
INSERT INTO `city` VALUES ('4', '1', '福建', '1');
INSERT INTO `city` VALUES ('5', '1', '甘肃', '1');
INSERT INTO `city` VALUES ('6', '1', '广东', '1');
INSERT INTO `city` VALUES ('7', '1', '广西', '1');
INSERT INTO `city` VALUES ('8', '1', '贵州', '1');
INSERT INTO `city` VALUES ('9', '1', '海南', '1');
INSERT INTO `city` VALUES ('10', '1', '河北', '1');
INSERT INTO `city` VALUES ('11', '1', '河南', '1');
INSERT INTO `city` VALUES ('12', '1', '黑龙江', '1');
INSERT INTO `city` VALUES ('13', '1', '湖北', '1');
INSERT INTO `city` VALUES ('14', '1', '湖南', '1');
INSERT INTO `city` VALUES ('15', '1', '吉林', '1');
INSERT INTO `city` VALUES ('16', '1', '江苏', '1');
INSERT INTO `city` VALUES ('17', '1', '江西', '1');
INSERT INTO `city` VALUES ('18', '1', '辽宁', '1');
INSERT INTO `city` VALUES ('19', '1', '内蒙古', '1');
INSERT INTO `city` VALUES ('20', '1', '宁夏', '1');
INSERT INTO `city` VALUES ('21', '1', '青海', '1');
INSERT INTO `city` VALUES ('22', '1', '山东', '1');
INSERT INTO `city` VALUES ('23', '1', '山西', '1');
INSERT INTO `city` VALUES ('24', '1', '陕西', '1');
INSERT INTO `city` VALUES ('25', '1', '上海', '1');
INSERT INTO `city` VALUES ('26', '1', '四川', '1');
INSERT INTO `city` VALUES ('27', '1', '天津', '1');
INSERT INTO `city` VALUES ('28', '1', '西藏', '1');
INSERT INTO `city` VALUES ('29', '1', '新疆', '1');
INSERT INTO `city` VALUES ('30', '1', '云南', '1');
INSERT INTO `city` VALUES ('31', '1', '浙江', '1');
INSERT INTO `city` VALUES ('32', '1', '重庆', '1');
INSERT INTO `city` VALUES ('33', '1', '香港', '1');
INSERT INTO `city` VALUES ('34', '1', '澳门', '1');
INSERT INTO `city` VALUES ('35', '1', '台湾', '1');
INSERT INTO `city` VALUES ('36', '3', '安庆', '2');
INSERT INTO `city` VALUES ('37', '3', '蚌埠', '2');
INSERT INTO `city` VALUES ('38', '3', '巢湖', '2');
INSERT INTO `city` VALUES ('39', '3', '池州', '2');
INSERT INTO `city` VALUES ('40', '3', '滁州', '2');
INSERT INTO `city` VALUES ('41', '3', '阜阳', '2');
INSERT INTO `city` VALUES ('42', '3', '淮北', '2');
INSERT INTO `city` VALUES ('43', '3', '淮南', '2');
INSERT INTO `city` VALUES ('44', '3', '黄山', '2');
INSERT INTO `city` VALUES ('45', '3', '六安', '2');
INSERT INTO `city` VALUES ('46', '3', '马鞍山', '2');
INSERT INTO `city` VALUES ('47', '3', '宿州', '2');
INSERT INTO `city` VALUES ('48', '3', '铜陵', '2');
INSERT INTO `city` VALUES ('49', '3', '芜湖', '2');
INSERT INTO `city` VALUES ('50', '3', '宣城', '2');
INSERT INTO `city` VALUES ('51', '3', '亳州', '2');
INSERT INTO `city` VALUES ('52', '2', '市辖区', '2');
INSERT INTO `city` VALUES ('53', '4', '福州', '2');
INSERT INTO `city` VALUES ('54', '4', '龙岩', '2');
INSERT INTO `city` VALUES ('55', '4', '南平', '2');
INSERT INTO `city` VALUES ('56', '4', '宁德', '2');
INSERT INTO `city` VALUES ('57', '4', '莆田', '2');
INSERT INTO `city` VALUES ('58', '4', '泉州', '2');
INSERT INTO `city` VALUES ('59', '4', '三明', '2');
INSERT INTO `city` VALUES ('60', '4', '厦门', '2');
INSERT INTO `city` VALUES ('61', '4', '漳州', '2');
INSERT INTO `city` VALUES ('62', '5', '兰州', '2');
INSERT INTO `city` VALUES ('63', '5', '白银', '2');
INSERT INTO `city` VALUES ('64', '5', '定西', '2');
INSERT INTO `city` VALUES ('65', '5', '甘南', '2');
INSERT INTO `city` VALUES ('66', '5', '嘉峪关', '2');
INSERT INTO `city` VALUES ('67', '5', '金昌', '2');
INSERT INTO `city` VALUES ('68', '5', '酒泉', '2');
INSERT INTO `city` VALUES ('69', '5', '临夏', '2');
INSERT INTO `city` VALUES ('70', '5', '陇南', '2');
INSERT INTO `city` VALUES ('71', '5', '平凉', '2');
INSERT INTO `city` VALUES ('72', '5', '庆阳', '2');
INSERT INTO `city` VALUES ('73', '5', '天水', '2');
INSERT INTO `city` VALUES ('74', '5', '武威', '2');
INSERT INTO `city` VALUES ('75', '5', '张掖', '2');
INSERT INTO `city` VALUES ('76', '6', '广州', '2');
INSERT INTO `city` VALUES ('77', '6', '深圳', '2');
INSERT INTO `city` VALUES ('78', '6', '潮州', '2');
INSERT INTO `city` VALUES ('79', '6', '东莞', '2');
INSERT INTO `city` VALUES ('80', '6', '佛山', '2');
INSERT INTO `city` VALUES ('81', '6', '河源', '2');
INSERT INTO `city` VALUES ('82', '6', '惠州', '2');
INSERT INTO `city` VALUES ('83', '6', '江门', '2');
INSERT INTO `city` VALUES ('84', '6', '揭阳', '2');
INSERT INTO `city` VALUES ('85', '6', '茂名', '2');
INSERT INTO `city` VALUES ('86', '6', '梅州', '2');
INSERT INTO `city` VALUES ('87', '6', '清远', '2');
INSERT INTO `city` VALUES ('88', '6', '汕头', '2');
INSERT INTO `city` VALUES ('89', '6', '汕尾', '2');
INSERT INTO `city` VALUES ('90', '6', '韶关', '2');
INSERT INTO `city` VALUES ('91', '6', '阳江', '2');
INSERT INTO `city` VALUES ('92', '6', '云浮', '2');
INSERT INTO `city` VALUES ('93', '6', '湛江', '2');
INSERT INTO `city` VALUES ('94', '6', '肇庆', '2');
INSERT INTO `city` VALUES ('95', '6', '中山', '2');
INSERT INTO `city` VALUES ('96', '6', '珠海', '2');
INSERT INTO `city` VALUES ('97', '7', '南宁', '2');
INSERT INTO `city` VALUES ('98', '7', '桂林', '2');
INSERT INTO `city` VALUES ('99', '7', '百色', '2');
INSERT INTO `city` VALUES ('100', '7', '北海', '2');
INSERT INTO `city` VALUES ('101', '7', '崇左', '2');
INSERT INTO `city` VALUES ('102', '7', '防城港', '2');
INSERT INTO `city` VALUES ('103', '7', '贵港', '2');
INSERT INTO `city` VALUES ('104', '7', '河池', '2');
INSERT INTO `city` VALUES ('105', '7', '贺州', '2');
INSERT INTO `city` VALUES ('106', '7', '来宾', '2');
INSERT INTO `city` VALUES ('107', '7', '柳州', '2');
INSERT INTO `city` VALUES ('108', '7', '钦州', '2');
INSERT INTO `city` VALUES ('109', '7', '梧州', '2');
INSERT INTO `city` VALUES ('110', '7', '玉林', '2');
INSERT INTO `city` VALUES ('111', '8', '贵阳', '2');
INSERT INTO `city` VALUES ('112', '8', '安顺', '2');
INSERT INTO `city` VALUES ('113', '8', '毕节', '2');
INSERT INTO `city` VALUES ('114', '8', '六盘水', '2');
INSERT INTO `city` VALUES ('115', '8', '黔东南', '2');
INSERT INTO `city` VALUES ('116', '8', '黔南', '2');
INSERT INTO `city` VALUES ('117', '8', '黔西南', '2');
INSERT INTO `city` VALUES ('118', '8', '铜仁', '2');
INSERT INTO `city` VALUES ('119', '8', '遵义', '2');
INSERT INTO `city` VALUES ('120', '9', '海口', '2');
INSERT INTO `city` VALUES ('121', '9', '三亚', '2');
INSERT INTO `city` VALUES ('122', '9', '白沙', '2');
INSERT INTO `city` VALUES ('123', '9', '保亭', '2');
INSERT INTO `city` VALUES ('124', '9', '昌江', '2');
INSERT INTO `city` VALUES ('125', '9', '澄迈县', '2');
INSERT INTO `city` VALUES ('126', '9', '定安县', '2');
INSERT INTO `city` VALUES ('127', '9', '东方', '2');
INSERT INTO `city` VALUES ('128', '9', '乐东', '2');
INSERT INTO `city` VALUES ('129', '9', '临高县', '2');
INSERT INTO `city` VALUES ('130', '9', '陵水', '2');
INSERT INTO `city` VALUES ('131', '9', '琼海', '2');
INSERT INTO `city` VALUES ('132', '9', '琼中', '2');
INSERT INTO `city` VALUES ('133', '9', '屯昌县', '2');
INSERT INTO `city` VALUES ('134', '9', '万宁', '2');
INSERT INTO `city` VALUES ('135', '9', '文昌', '2');
INSERT INTO `city` VALUES ('136', '9', '五指山', '2');
INSERT INTO `city` VALUES ('137', '9', '儋州', '2');
INSERT INTO `city` VALUES ('138', '10', '石家庄', '2');
INSERT INTO `city` VALUES ('139', '10', '保定', '2');
INSERT INTO `city` VALUES ('140', '10', '沧州', '2');
INSERT INTO `city` VALUES ('141', '10', '承德', '2');
INSERT INTO `city` VALUES ('142', '10', '邯郸', '2');
INSERT INTO `city` VALUES ('143', '10', '衡水', '2');
INSERT INTO `city` VALUES ('144', '10', '廊坊', '2');
INSERT INTO `city` VALUES ('145', '10', '秦皇岛', '2');
INSERT INTO `city` VALUES ('146', '10', '唐山', '2');
INSERT INTO `city` VALUES ('147', '10', '邢台', '2');
INSERT INTO `city` VALUES ('148', '10', '张家口', '2');
INSERT INTO `city` VALUES ('149', '11', '郑州', '2');
INSERT INTO `city` VALUES ('150', '11', '洛阳', '2');
INSERT INTO `city` VALUES ('151', '11', '开封', '2');
INSERT INTO `city` VALUES ('152', '11', '安阳', '2');
INSERT INTO `city` VALUES ('153', '11', '鹤壁', '2');
INSERT INTO `city` VALUES ('154', '11', '济源', '2');
INSERT INTO `city` VALUES ('155', '11', '焦作', '2');
INSERT INTO `city` VALUES ('156', '11', '南阳', '2');
INSERT INTO `city` VALUES ('157', '11', '平顶山', '2');
INSERT INTO `city` VALUES ('158', '11', '三门峡', '2');
INSERT INTO `city` VALUES ('159', '11', '商丘', '2');
INSERT INTO `city` VALUES ('160', '11', '新乡', '2');
INSERT INTO `city` VALUES ('161', '11', '信阳', '2');
INSERT INTO `city` VALUES ('162', '11', '许昌', '2');
INSERT INTO `city` VALUES ('163', '11', '周口', '2');
INSERT INTO `city` VALUES ('164', '11', '驻马店', '2');
INSERT INTO `city` VALUES ('165', '11', '漯河', '2');
INSERT INTO `city` VALUES ('166', '11', '濮阳', '2');
INSERT INTO `city` VALUES ('167', '12', '哈尔滨', '2');
INSERT INTO `city` VALUES ('168', '12', '大庆', '2');
INSERT INTO `city` VALUES ('169', '12', '大兴安岭', '2');
INSERT INTO `city` VALUES ('170', '12', '鹤岗', '2');
INSERT INTO `city` VALUES ('171', '12', '黑河', '2');
INSERT INTO `city` VALUES ('172', '12', '鸡西', '2');
INSERT INTO `city` VALUES ('173', '12', '佳木斯', '2');
INSERT INTO `city` VALUES ('174', '12', '牡丹江', '2');
INSERT INTO `city` VALUES ('175', '12', '七台河', '2');
INSERT INTO `city` VALUES ('176', '12', '齐齐哈尔', '2');
INSERT INTO `city` VALUES ('177', '12', '双鸭山', '2');
INSERT INTO `city` VALUES ('178', '12', '绥化', '2');
INSERT INTO `city` VALUES ('179', '12', '伊春', '2');
INSERT INTO `city` VALUES ('180', '13', '武汉', '2');
INSERT INTO `city` VALUES ('181', '13', '仙桃', '2');
INSERT INTO `city` VALUES ('182', '13', '鄂州', '2');
INSERT INTO `city` VALUES ('183', '13', '黄冈', '2');
INSERT INTO `city` VALUES ('184', '13', '黄石', '2');
INSERT INTO `city` VALUES ('185', '13', '荆门', '2');
INSERT INTO `city` VALUES ('186', '13', '荆州', '2');
INSERT INTO `city` VALUES ('187', '13', '潜江', '2');
INSERT INTO `city` VALUES ('188', '13', '神农架林区', '2');
INSERT INTO `city` VALUES ('189', '13', '十堰', '2');
INSERT INTO `city` VALUES ('190', '13', '随州', '2');
INSERT INTO `city` VALUES ('191', '13', '天门', '2');
INSERT INTO `city` VALUES ('192', '13', '咸宁', '2');
INSERT INTO `city` VALUES ('193', '13', '襄樊', '2');
INSERT INTO `city` VALUES ('194', '13', '孝感', '2');
INSERT INTO `city` VALUES ('195', '13', '宜昌', '2');
INSERT INTO `city` VALUES ('196', '13', '恩施', '2');
INSERT INTO `city` VALUES ('197', '14', '长沙', '2');
INSERT INTO `city` VALUES ('198', '14', '张家界', '2');
INSERT INTO `city` VALUES ('199', '14', '常德', '2');
INSERT INTO `city` VALUES ('200', '14', '郴州', '2');
INSERT INTO `city` VALUES ('201', '14', '衡阳', '2');
INSERT INTO `city` VALUES ('202', '14', '怀化', '2');
INSERT INTO `city` VALUES ('203', '14', '娄底', '2');
INSERT INTO `city` VALUES ('204', '14', '邵阳', '2');
INSERT INTO `city` VALUES ('205', '14', '湘潭', '2');
INSERT INTO `city` VALUES ('206', '14', '湘西', '2');
INSERT INTO `city` VALUES ('207', '14', '益阳', '2');
INSERT INTO `city` VALUES ('208', '14', '永州', '2');
INSERT INTO `city` VALUES ('209', '14', '岳阳', '2');
INSERT INTO `city` VALUES ('210', '14', '株洲', '2');
INSERT INTO `city` VALUES ('211', '15', '长春', '2');
INSERT INTO `city` VALUES ('212', '15', '吉林', '2');
INSERT INTO `city` VALUES ('213', '15', '白城', '2');
INSERT INTO `city` VALUES ('214', '15', '白山', '2');
INSERT INTO `city` VALUES ('215', '15', '辽源', '2');
INSERT INTO `city` VALUES ('216', '15', '四平', '2');
INSERT INTO `city` VALUES ('217', '15', '松原', '2');
INSERT INTO `city` VALUES ('218', '15', '通化', '2');
INSERT INTO `city` VALUES ('219', '15', '延边', '2');
INSERT INTO `city` VALUES ('220', '16', '南京', '2');
INSERT INTO `city` VALUES ('221', '16', '苏州', '2');
INSERT INTO `city` VALUES ('222', '16', '无锡', '2');
INSERT INTO `city` VALUES ('223', '16', '常州', '2');
INSERT INTO `city` VALUES ('224', '16', '淮安', '2');
INSERT INTO `city` VALUES ('225', '16', '连云港', '2');
INSERT INTO `city` VALUES ('226', '16', '南通', '2');
INSERT INTO `city` VALUES ('227', '16', '宿迁', '2');
INSERT INTO `city` VALUES ('228', '16', '泰州', '2');
INSERT INTO `city` VALUES ('229', '16', '徐州', '2');
INSERT INTO `city` VALUES ('230', '16', '盐城', '2');
INSERT INTO `city` VALUES ('231', '16', '扬州', '2');
INSERT INTO `city` VALUES ('232', '16', '镇江', '2');
INSERT INTO `city` VALUES ('233', '17', '南昌', '2');
INSERT INTO `city` VALUES ('234', '17', '抚州', '2');
INSERT INTO `city` VALUES ('235', '17', '赣州', '2');
INSERT INTO `city` VALUES ('236', '17', '吉安', '2');
INSERT INTO `city` VALUES ('237', '17', '景德镇', '2');
INSERT INTO `city` VALUES ('238', '17', '九江', '2');
INSERT INTO `city` VALUES ('239', '17', '萍乡', '2');
INSERT INTO `city` VALUES ('240', '17', '上饶', '2');
INSERT INTO `city` VALUES ('241', '17', '新余', '2');
INSERT INTO `city` VALUES ('242', '17', '宜春', '2');
INSERT INTO `city` VALUES ('243', '17', '鹰潭', '2');
INSERT INTO `city` VALUES ('244', '18', '沈阳', '2');
INSERT INTO `city` VALUES ('245', '18', '大连', '2');
INSERT INTO `city` VALUES ('246', '18', '鞍山', '2');
INSERT INTO `city` VALUES ('247', '18', '本溪', '2');
INSERT INTO `city` VALUES ('248', '18', '朝阳', '2');
INSERT INTO `city` VALUES ('249', '18', '丹东', '2');
INSERT INTO `city` VALUES ('250', '18', '抚顺', '2');
INSERT INTO `city` VALUES ('251', '18', '阜新', '2');
INSERT INTO `city` VALUES ('252', '18', '葫芦岛', '2');
INSERT INTO `city` VALUES ('253', '18', '锦州', '2');
INSERT INTO `city` VALUES ('254', '18', '辽阳', '2');
INSERT INTO `city` VALUES ('255', '18', '盘锦', '2');
INSERT INTO `city` VALUES ('256', '18', '铁岭', '2');
INSERT INTO `city` VALUES ('257', '18', '营口', '2');
INSERT INTO `city` VALUES ('258', '19', '呼和浩特', '2');
INSERT INTO `city` VALUES ('259', '19', '阿拉善盟', '2');
INSERT INTO `city` VALUES ('260', '19', '巴彦淖尔盟', '2');
INSERT INTO `city` VALUES ('261', '19', '包头', '2');
INSERT INTO `city` VALUES ('262', '19', '赤峰', '2');
INSERT INTO `city` VALUES ('263', '19', '鄂尔多斯', '2');
INSERT INTO `city` VALUES ('264', '19', '呼伦贝尔', '2');
INSERT INTO `city` VALUES ('265', '19', '通辽', '2');
INSERT INTO `city` VALUES ('266', '19', '乌海', '2');
INSERT INTO `city` VALUES ('267', '19', '乌兰察布市', '2');
INSERT INTO `city` VALUES ('268', '19', '锡林郭勒盟', '2');
INSERT INTO `city` VALUES ('269', '19', '兴安盟', '2');
INSERT INTO `city` VALUES ('270', '20', '银川', '2');
INSERT INTO `city` VALUES ('271', '20', '固原', '2');
INSERT INTO `city` VALUES ('272', '20', '石嘴山', '2');
INSERT INTO `city` VALUES ('273', '20', '吴忠', '2');
INSERT INTO `city` VALUES ('274', '20', '中卫', '2');
INSERT INTO `city` VALUES ('275', '21', '西宁', '2');
INSERT INTO `city` VALUES ('276', '21', '果洛', '2');
INSERT INTO `city` VALUES ('277', '21', '海北', '2');
INSERT INTO `city` VALUES ('278', '21', '海东', '2');
INSERT INTO `city` VALUES ('279', '21', '海南', '2');
INSERT INTO `city` VALUES ('280', '21', '海西', '2');
INSERT INTO `city` VALUES ('281', '21', '黄南', '2');
INSERT INTO `city` VALUES ('282', '21', '玉树', '2');
INSERT INTO `city` VALUES ('283', '22', '济南', '2');
INSERT INTO `city` VALUES ('284', '22', '青岛', '2');
INSERT INTO `city` VALUES ('285', '22', '滨州', '2');
INSERT INTO `city` VALUES ('286', '22', '德州', '2');
INSERT INTO `city` VALUES ('287', '22', '东营', '2');
INSERT INTO `city` VALUES ('288', '22', '菏泽', '2');
INSERT INTO `city` VALUES ('289', '22', '济宁', '2');
INSERT INTO `city` VALUES ('290', '22', '莱芜', '2');
INSERT INTO `city` VALUES ('291', '22', '聊城', '2');
INSERT INTO `city` VALUES ('292', '22', '临沂', '2');
INSERT INTO `city` VALUES ('293', '22', '日照', '2');
INSERT INTO `city` VALUES ('294', '22', '泰安', '2');
INSERT INTO `city` VALUES ('295', '22', '威海', '2');
INSERT INTO `city` VALUES ('296', '22', '潍坊', '2');
INSERT INTO `city` VALUES ('297', '22', '烟台', '2');
INSERT INTO `city` VALUES ('298', '22', '枣庄', '2');
INSERT INTO `city` VALUES ('299', '22', '淄博', '2');
INSERT INTO `city` VALUES ('300', '23', '太原', '2');
INSERT INTO `city` VALUES ('301', '23', '长治', '2');
INSERT INTO `city` VALUES ('302', '23', '大同', '2');
INSERT INTO `city` VALUES ('303', '23', '晋城', '2');
INSERT INTO `city` VALUES ('304', '23', '晋中', '2');
INSERT INTO `city` VALUES ('305', '23', '临汾', '2');
INSERT INTO `city` VALUES ('306', '23', '吕梁', '2');
INSERT INTO `city` VALUES ('307', '23', '朔州', '2');
INSERT INTO `city` VALUES ('308', '23', '忻州', '2');
INSERT INTO `city` VALUES ('309', '23', '阳泉', '2');
INSERT INTO `city` VALUES ('310', '23', '运城', '2');
INSERT INTO `city` VALUES ('311', '24', '西安', '2');
INSERT INTO `city` VALUES ('312', '24', '安康', '2');
INSERT INTO `city` VALUES ('313', '24', '宝鸡', '2');
INSERT INTO `city` VALUES ('314', '24', '汉中', '2');
INSERT INTO `city` VALUES ('315', '24', '商洛', '2');
INSERT INTO `city` VALUES ('316', '24', '铜川', '2');
INSERT INTO `city` VALUES ('317', '24', '渭南', '2');
INSERT INTO `city` VALUES ('318', '24', '咸阳', '2');
INSERT INTO `city` VALUES ('319', '24', '延安', '2');
INSERT INTO `city` VALUES ('320', '24', '榆林', '2');
INSERT INTO `city` VALUES ('321', '25', '上海', '2');
INSERT INTO `city` VALUES ('322', '26', '成都', '2');
INSERT INTO `city` VALUES ('323', '26', '绵阳', '2');
INSERT INTO `city` VALUES ('324', '26', '阿坝', '2');
INSERT INTO `city` VALUES ('325', '26', '巴中', '2');
INSERT INTO `city` VALUES ('326', '26', '达州', '2');
INSERT INTO `city` VALUES ('327', '26', '德阳', '2');
INSERT INTO `city` VALUES ('328', '26', '甘孜', '2');
INSERT INTO `city` VALUES ('329', '26', '广安', '2');
INSERT INTO `city` VALUES ('330', '26', '广元', '2');
INSERT INTO `city` VALUES ('331', '26', '乐山', '2');
INSERT INTO `city` VALUES ('332', '26', '凉山', '2');
INSERT INTO `city` VALUES ('333', '26', '眉山', '2');
INSERT INTO `city` VALUES ('334', '26', '南充', '2');
INSERT INTO `city` VALUES ('335', '26', '内江', '2');
INSERT INTO `city` VALUES ('336', '26', '攀枝花', '2');
INSERT INTO `city` VALUES ('337', '26', '遂宁', '2');
INSERT INTO `city` VALUES ('338', '26', '雅安', '2');
INSERT INTO `city` VALUES ('339', '26', '宜宾', '2');
INSERT INTO `city` VALUES ('340', '26', '资阳', '2');
INSERT INTO `city` VALUES ('341', '26', '自贡', '2');
INSERT INTO `city` VALUES ('342', '26', '泸州', '2');
INSERT INTO `city` VALUES ('343', '27', '天津', '2');
INSERT INTO `city` VALUES ('344', '28', '拉萨', '2');
INSERT INTO `city` VALUES ('345', '28', '阿里', '2');
INSERT INTO `city` VALUES ('346', '28', '昌都', '2');
INSERT INTO `city` VALUES ('347', '28', '林芝', '2');
INSERT INTO `city` VALUES ('348', '28', '那曲', '2');
INSERT INTO `city` VALUES ('349', '28', '日喀则', '2');
INSERT INTO `city` VALUES ('350', '28', '山南', '2');
INSERT INTO `city` VALUES ('351', '29', '乌鲁木齐', '2');
INSERT INTO `city` VALUES ('352', '29', '阿克苏', '2');
INSERT INTO `city` VALUES ('353', '29', '阿拉尔', '2');
INSERT INTO `city` VALUES ('354', '29', '巴音郭楞', '2');
INSERT INTO `city` VALUES ('355', '29', '博尔塔拉', '2');
INSERT INTO `city` VALUES ('356', '29', '昌吉', '2');
INSERT INTO `city` VALUES ('357', '29', '哈密', '2');
INSERT INTO `city` VALUES ('358', '29', '和田', '2');
INSERT INTO `city` VALUES ('359', '29', '喀什', '2');
INSERT INTO `city` VALUES ('360', '29', '克拉玛依', '2');
INSERT INTO `city` VALUES ('361', '29', '克孜勒苏', '2');
INSERT INTO `city` VALUES ('362', '29', '石河子', '2');
INSERT INTO `city` VALUES ('363', '29', '图木舒克', '2');
INSERT INTO `city` VALUES ('364', '29', '吐鲁番', '2');
INSERT INTO `city` VALUES ('365', '29', '五家渠', '2');
INSERT INTO `city` VALUES ('366', '29', '伊犁', '2');
INSERT INTO `city` VALUES ('367', '30', '昆明', '2');
INSERT INTO `city` VALUES ('368', '30', '怒江', '2');
INSERT INTO `city` VALUES ('369', '30', '普洱', '2');
INSERT INTO `city` VALUES ('370', '30', '丽江', '2');
INSERT INTO `city` VALUES ('371', '30', '保山', '2');
INSERT INTO `city` VALUES ('372', '30', '楚雄', '2');
INSERT INTO `city` VALUES ('373', '30', '大理', '2');
INSERT INTO `city` VALUES ('374', '30', '德宏', '2');
INSERT INTO `city` VALUES ('375', '30', '迪庆', '2');
INSERT INTO `city` VALUES ('376', '30', '红河', '2');
INSERT INTO `city` VALUES ('377', '30', '临沧', '2');
INSERT INTO `city` VALUES ('378', '30', '曲靖', '2');
INSERT INTO `city` VALUES ('379', '30', '文山', '2');
INSERT INTO `city` VALUES ('380', '30', '西双版纳', '2');
INSERT INTO `city` VALUES ('381', '30', '玉溪', '2');
INSERT INTO `city` VALUES ('382', '30', '昭通', '2');
INSERT INTO `city` VALUES ('383', '31', '杭州', '2');
INSERT INTO `city` VALUES ('384', '31', '湖州', '2');
INSERT INTO `city` VALUES ('385', '31', '嘉兴', '2');
INSERT INTO `city` VALUES ('386', '31', '金华', '2');
INSERT INTO `city` VALUES ('387', '31', '丽水', '2');
INSERT INTO `city` VALUES ('388', '31', '宁波', '2');
INSERT INTO `city` VALUES ('389', '31', '绍兴', '2');
INSERT INTO `city` VALUES ('390', '31', '台州', '2');
INSERT INTO `city` VALUES ('391', '31', '温州', '2');
INSERT INTO `city` VALUES ('392', '31', '舟山', '2');
INSERT INTO `city` VALUES ('393', '31', '衢州', '2');
INSERT INTO `city` VALUES ('394', '32', '重庆', '2');
INSERT INTO `city` VALUES ('395', '33', '香港', '2');
INSERT INTO `city` VALUES ('396', '34', '澳门', '2');
INSERT INTO `city` VALUES ('397', '35', '台湾', '2');
INSERT INTO `city` VALUES ('398', '36', '迎江区', '3');
INSERT INTO `city` VALUES ('399', '36', '大观区', '3');
INSERT INTO `city` VALUES ('400', '36', '宜秀区', '3');
INSERT INTO `city` VALUES ('401', '36', '桐城市', '3');
INSERT INTO `city` VALUES ('402', '36', '怀宁县', '3');
INSERT INTO `city` VALUES ('403', '36', '枞阳县', '3');
INSERT INTO `city` VALUES ('404', '36', '潜山县', '3');
INSERT INTO `city` VALUES ('405', '36', '太湖县', '3');
INSERT INTO `city` VALUES ('406', '36', '宿松县', '3');
INSERT INTO `city` VALUES ('407', '36', '望江县', '3');
INSERT INTO `city` VALUES ('408', '36', '岳西县', '3');
INSERT INTO `city` VALUES ('409', '37', '中市区', '3');
INSERT INTO `city` VALUES ('410', '37', '东市区', '3');
INSERT INTO `city` VALUES ('411', '37', '西市区', '3');
INSERT INTO `city` VALUES ('412', '37', '郊区', '3');
INSERT INTO `city` VALUES ('413', '37', '怀远县', '3');
INSERT INTO `city` VALUES ('414', '37', '五河县', '3');
INSERT INTO `city` VALUES ('415', '37', '固镇县', '3');
INSERT INTO `city` VALUES ('416', '38', '居巢区', '3');
INSERT INTO `city` VALUES ('417', '38', '庐江县', '3');
INSERT INTO `city` VALUES ('418', '38', '无为县', '3');
INSERT INTO `city` VALUES ('419', '38', '含山县', '3');
INSERT INTO `city` VALUES ('420', '38', '和县', '3');
INSERT INTO `city` VALUES ('421', '39', '贵池区', '3');
INSERT INTO `city` VALUES ('422', '39', '东至县', '3');
INSERT INTO `city` VALUES ('423', '39', '石台县', '3');
INSERT INTO `city` VALUES ('424', '39', '青阳县', '3');
INSERT INTO `city` VALUES ('425', '40', '琅琊区', '3');
INSERT INTO `city` VALUES ('426', '40', '南谯区', '3');
INSERT INTO `city` VALUES ('427', '40', '天长市', '3');
INSERT INTO `city` VALUES ('428', '40', '明光市', '3');
INSERT INTO `city` VALUES ('429', '40', '来安县', '3');
INSERT INTO `city` VALUES ('430', '40', '全椒县', '3');
INSERT INTO `city` VALUES ('431', '40', '定远县', '3');
INSERT INTO `city` VALUES ('432', '40', '凤阳县', '3');
INSERT INTO `city` VALUES ('433', '41', '蚌山区', '3');
INSERT INTO `city` VALUES ('434', '41', '龙子湖区', '3');
INSERT INTO `city` VALUES ('435', '41', '禹会区', '3');
INSERT INTO `city` VALUES ('436', '41', '淮上区', '3');
INSERT INTO `city` VALUES ('437', '41', '颍州区', '3');
INSERT INTO `city` VALUES ('438', '41', '颍东区', '3');
INSERT INTO `city` VALUES ('439', '41', '颍泉区', '3');
INSERT INTO `city` VALUES ('440', '41', '界首市', '3');
INSERT INTO `city` VALUES ('441', '41', '临泉县', '3');
INSERT INTO `city` VALUES ('442', '41', '太和县', '3');
INSERT INTO `city` VALUES ('443', '41', '阜南县', '3');
INSERT INTO `city` VALUES ('444', '41', '颖上县', '3');
INSERT INTO `city` VALUES ('445', '42', '相山区', '3');
INSERT INTO `city` VALUES ('446', '42', '杜集区', '3');
INSERT INTO `city` VALUES ('447', '42', '烈山区', '3');
INSERT INTO `city` VALUES ('448', '42', '濉溪县', '3');
INSERT INTO `city` VALUES ('449', '43', '田家庵区', '3');
INSERT INTO `city` VALUES ('450', '43', '大通区', '3');
INSERT INTO `city` VALUES ('451', '43', '谢家集区', '3');
INSERT INTO `city` VALUES ('452', '43', '八公山区', '3');
INSERT INTO `city` VALUES ('453', '43', '潘集区', '3');
INSERT INTO `city` VALUES ('454', '43', '凤台县', '3');
INSERT INTO `city` VALUES ('455', '44', '屯溪区', '3');
INSERT INTO `city` VALUES ('456', '44', '黄山区', '3');
INSERT INTO `city` VALUES ('457', '44', '徽州区', '3');
INSERT INTO `city` VALUES ('458', '44', '歙县', '3');
INSERT INTO `city` VALUES ('459', '44', '休宁县', '3');
INSERT INTO `city` VALUES ('460', '44', '黟县', '3');
INSERT INTO `city` VALUES ('461', '44', '祁门县', '3');
INSERT INTO `city` VALUES ('462', '45', '金安区', '3');
INSERT INTO `city` VALUES ('463', '45', '裕安区', '3');
INSERT INTO `city` VALUES ('464', '45', '寿县', '3');
INSERT INTO `city` VALUES ('465', '45', '霍邱县', '3');
INSERT INTO `city` VALUES ('466', '45', '舒城县', '3');
INSERT INTO `city` VALUES ('467', '45', '金寨县', '3');
INSERT INTO `city` VALUES ('468', '45', '霍山县', '3');
INSERT INTO `city` VALUES ('469', '46', '雨山区', '3');
INSERT INTO `city` VALUES ('470', '46', '花山区', '3');
INSERT INTO `city` VALUES ('471', '46', '金家庄区', '3');
INSERT INTO `city` VALUES ('472', '46', '当涂县', '3');
INSERT INTO `city` VALUES ('473', '47', '埇桥区', '3');
INSERT INTO `city` VALUES ('474', '47', '砀山县', '3');
INSERT INTO `city` VALUES ('475', '47', '萧县', '3');
INSERT INTO `city` VALUES ('476', '47', '灵璧县', '3');
INSERT INTO `city` VALUES ('477', '47', '泗县', '3');
INSERT INTO `city` VALUES ('478', '48', '铜官山区', '3');
INSERT INTO `city` VALUES ('479', '48', '狮子山区', '3');
INSERT INTO `city` VALUES ('480', '48', '郊区', '3');
INSERT INTO `city` VALUES ('481', '48', '铜陵县', '3');
INSERT INTO `city` VALUES ('482', '49', '镜湖区', '3');
INSERT INTO `city` VALUES ('483', '49', '弋江区', '3');
INSERT INTO `city` VALUES ('484', '49', '鸠江区', '3');
INSERT INTO `city` VALUES ('485', '49', '三山区', '3');
INSERT INTO `city` VALUES ('486', '49', '芜湖县', '3');
INSERT INTO `city` VALUES ('487', '49', '繁昌县', '3');
INSERT INTO `city` VALUES ('488', '49', '南陵县', '3');
INSERT INTO `city` VALUES ('489', '50', '宣州区', '3');
INSERT INTO `city` VALUES ('490', '50', '宁国市', '3');
INSERT INTO `city` VALUES ('491', '50', '郎溪县', '3');
INSERT INTO `city` VALUES ('492', '50', '广德县', '3');
INSERT INTO `city` VALUES ('493', '50', '泾县', '3');
INSERT INTO `city` VALUES ('494', '50', '绩溪县', '3');
INSERT INTO `city` VALUES ('495', '50', '旌德县', '3');
INSERT INTO `city` VALUES ('496', '51', '涡阳县', '3');
INSERT INTO `city` VALUES ('497', '51', '蒙城县', '3');
INSERT INTO `city` VALUES ('498', '51', '利辛县', '3');
INSERT INTO `city` VALUES ('499', '51', '谯城区', '3');
INSERT INTO `city` VALUES ('500', '52', '东城区', '3');
INSERT INTO `city` VALUES ('501', '52', '西城区', '3');
INSERT INTO `city` VALUES ('502', '52', '海淀区', '3');
INSERT INTO `city` VALUES ('503', '52', '朝阳区', '3');
INSERT INTO `city` VALUES ('504', '52', '崇文区', '3');
INSERT INTO `city` VALUES ('505', '52', '宣武区', '3');
INSERT INTO `city` VALUES ('506', '52', '丰台区', '3');
INSERT INTO `city` VALUES ('507', '52', '石景山区', '3');
INSERT INTO `city` VALUES ('508', '52', '房山区', '3');
INSERT INTO `city` VALUES ('509', '52', '门头沟区', '3');
INSERT INTO `city` VALUES ('510', '52', '通州区', '3');
INSERT INTO `city` VALUES ('511', '52', '顺义区', '3');
INSERT INTO `city` VALUES ('512', '52', '昌平区', '3');
INSERT INTO `city` VALUES ('513', '52', '怀柔区', '3');
INSERT INTO `city` VALUES ('514', '52', '平谷区', '3');
INSERT INTO `city` VALUES ('515', '52', '大兴区', '3');
INSERT INTO `city` VALUES ('516', '52', '密云县', '3');
INSERT INTO `city` VALUES ('517', '52', '延庆县', '3');
INSERT INTO `city` VALUES ('518', '53', '鼓楼区', '3');
INSERT INTO `city` VALUES ('519', '53', '台江区', '3');
INSERT INTO `city` VALUES ('520', '53', '仓山区', '3');
INSERT INTO `city` VALUES ('521', '53', '马尾区', '3');
INSERT INTO `city` VALUES ('522', '53', '晋安区', '3');
INSERT INTO `city` VALUES ('523', '53', '福清市', '3');
INSERT INTO `city` VALUES ('524', '53', '长乐市', '3');
INSERT INTO `city` VALUES ('525', '53', '闽侯县', '3');
INSERT INTO `city` VALUES ('526', '53', '连江县', '3');
INSERT INTO `city` VALUES ('527', '53', '罗源县', '3');
INSERT INTO `city` VALUES ('528', '53', '闽清县', '3');
INSERT INTO `city` VALUES ('529', '53', '永泰县', '3');
INSERT INTO `city` VALUES ('530', '53', '平潭县', '3');
INSERT INTO `city` VALUES ('531', '54', '新罗区', '3');
INSERT INTO `city` VALUES ('532', '54', '漳平市', '3');
INSERT INTO `city` VALUES ('533', '54', '长汀县', '3');
INSERT INTO `city` VALUES ('534', '54', '永定县', '3');
INSERT INTO `city` VALUES ('535', '54', '上杭县', '3');
INSERT INTO `city` VALUES ('536', '54', '武平县', '3');
INSERT INTO `city` VALUES ('537', '54', '连城县', '3');
INSERT INTO `city` VALUES ('538', '55', '延平区', '3');
INSERT INTO `city` VALUES ('539', '55', '邵武市', '3');
INSERT INTO `city` VALUES ('540', '55', '武夷山市', '3');
INSERT INTO `city` VALUES ('541', '55', '建瓯市', '3');
INSERT INTO `city` VALUES ('542', '55', '建阳市', '3');
INSERT INTO `city` VALUES ('543', '55', '顺昌县', '3');
INSERT INTO `city` VALUES ('544', '55', '浦城县', '3');
INSERT INTO `city` VALUES ('545', '55', '光泽县', '3');
INSERT INTO `city` VALUES ('546', '55', '松溪县', '3');
INSERT INTO `city` VALUES ('547', '55', '政和县', '3');
INSERT INTO `city` VALUES ('548', '56', '蕉城区', '3');
INSERT INTO `city` VALUES ('549', '56', '福安市', '3');
INSERT INTO `city` VALUES ('550', '56', '福鼎市', '3');
INSERT INTO `city` VALUES ('551', '56', '霞浦县', '3');
INSERT INTO `city` VALUES ('552', '56', '古田县', '3');
INSERT INTO `city` VALUES ('553', '56', '屏南县', '3');
INSERT INTO `city` VALUES ('554', '56', '寿宁县', '3');
INSERT INTO `city` VALUES ('555', '56', '周宁县', '3');
INSERT INTO `city` VALUES ('556', '56', '柘荣县', '3');
INSERT INTO `city` VALUES ('557', '57', '城厢区', '3');
INSERT INTO `city` VALUES ('558', '57', '涵江区', '3');
INSERT INTO `city` VALUES ('559', '57', '荔城区', '3');
INSERT INTO `city` VALUES ('560', '57', '秀屿区', '3');
INSERT INTO `city` VALUES ('561', '57', '仙游县', '3');
INSERT INTO `city` VALUES ('562', '58', '鲤城区', '3');
INSERT INTO `city` VALUES ('563', '58', '丰泽区', '3');
INSERT INTO `city` VALUES ('564', '58', '洛江区', '3');
INSERT INTO `city` VALUES ('565', '58', '清濛开发区', '3');
INSERT INTO `city` VALUES ('566', '58', '泉港区', '3');
INSERT INTO `city` VALUES ('567', '58', '石狮市', '3');
INSERT INTO `city` VALUES ('568', '58', '晋江市', '3');
INSERT INTO `city` VALUES ('569', '58', '南安市', '3');
INSERT INTO `city` VALUES ('570', '58', '惠安县', '3');
INSERT INTO `city` VALUES ('571', '58', '安溪县', '3');
INSERT INTO `city` VALUES ('572', '58', '永春县', '3');
INSERT INTO `city` VALUES ('573', '58', '德化县', '3');
INSERT INTO `city` VALUES ('574', '58', '金门县', '3');
INSERT INTO `city` VALUES ('575', '59', '梅列区', '3');
INSERT INTO `city` VALUES ('576', '59', '三元区', '3');
INSERT INTO `city` VALUES ('577', '59', '永安市', '3');
INSERT INTO `city` VALUES ('578', '59', '明溪县', '3');
INSERT INTO `city` VALUES ('579', '59', '清流县', '3');
INSERT INTO `city` VALUES ('580', '59', '宁化县', '3');
INSERT INTO `city` VALUES ('581', '59', '大田县', '3');
INSERT INTO `city` VALUES ('582', '59', '尤溪县', '3');
INSERT INTO `city` VALUES ('583', '59', '沙县', '3');
INSERT INTO `city` VALUES ('584', '59', '将乐县', '3');
INSERT INTO `city` VALUES ('585', '59', '泰宁县', '3');
INSERT INTO `city` VALUES ('586', '59', '建宁县', '3');
INSERT INTO `city` VALUES ('587', '60', '思明区', '3');
INSERT INTO `city` VALUES ('588', '60', '海沧区', '3');
INSERT INTO `city` VALUES ('589', '60', '湖里区', '3');
INSERT INTO `city` VALUES ('590', '60', '集美区', '3');
INSERT INTO `city` VALUES ('591', '60', '同安区', '3');
INSERT INTO `city` VALUES ('592', '60', '翔安区', '3');
INSERT INTO `city` VALUES ('593', '61', '芗城区', '3');
INSERT INTO `city` VALUES ('594', '61', '龙文区', '3');
INSERT INTO `city` VALUES ('595', '61', '龙海市', '3');
INSERT INTO `city` VALUES ('596', '61', '云霄县', '3');
INSERT INTO `city` VALUES ('597', '61', '漳浦县', '3');
INSERT INTO `city` VALUES ('598', '61', '诏安县', '3');
INSERT INTO `city` VALUES ('599', '61', '长泰县', '3');
INSERT INTO `city` VALUES ('600', '61', '东山县', '3');
INSERT INTO `city` VALUES ('601', '61', '南靖县', '3');
INSERT INTO `city` VALUES ('602', '61', '平和县', '3');
INSERT INTO `city` VALUES ('603', '61', '华安县', '3');
INSERT INTO `city` VALUES ('604', '62', '皋兰县', '3');
INSERT INTO `city` VALUES ('605', '62', '城关区', '3');
INSERT INTO `city` VALUES ('606', '62', '七里河区', '3');
INSERT INTO `city` VALUES ('607', '62', '西固区', '3');
INSERT INTO `city` VALUES ('608', '62', '安宁区', '3');
INSERT INTO `city` VALUES ('609', '62', '红古区', '3');
INSERT INTO `city` VALUES ('610', '62', '永登县', '3');
INSERT INTO `city` VALUES ('611', '62', '榆中县', '3');
INSERT INTO `city` VALUES ('612', '63', '白银区', '3');
INSERT INTO `city` VALUES ('613', '63', '平川区', '3');
INSERT INTO `city` VALUES ('614', '63', '会宁县', '3');
INSERT INTO `city` VALUES ('615', '63', '景泰县', '3');
INSERT INTO `city` VALUES ('616', '63', '靖远县', '3');
INSERT INTO `city` VALUES ('617', '64', '临洮县', '3');
INSERT INTO `city` VALUES ('618', '64', '陇西县', '3');
INSERT INTO `city` VALUES ('619', '64', '通渭县', '3');
INSERT INTO `city` VALUES ('620', '64', '渭源县', '3');
INSERT INTO `city` VALUES ('621', '64', '漳县', '3');
INSERT INTO `city` VALUES ('622', '64', '岷县', '3');
INSERT INTO `city` VALUES ('623', '64', '安定区', '3');
INSERT INTO `city` VALUES ('624', '64', '安定区', '3');
INSERT INTO `city` VALUES ('625', '65', '合作市', '3');
INSERT INTO `city` VALUES ('626', '65', '临潭县', '3');
INSERT INTO `city` VALUES ('627', '65', '卓尼县', '3');
INSERT INTO `city` VALUES ('628', '65', '舟曲县', '3');
INSERT INTO `city` VALUES ('629', '65', '迭部县', '3');
INSERT INTO `city` VALUES ('630', '65', '玛曲县', '3');
INSERT INTO `city` VALUES ('631', '65', '碌曲县', '3');
INSERT INTO `city` VALUES ('632', '65', '夏河县', '3');
INSERT INTO `city` VALUES ('633', '66', '嘉峪关市', '3');
INSERT INTO `city` VALUES ('634', '67', '金川区', '3');
INSERT INTO `city` VALUES ('635', '67', '永昌县', '3');
INSERT INTO `city` VALUES ('636', '68', '肃州区', '3');
INSERT INTO `city` VALUES ('637', '68', '玉门市', '3');
INSERT INTO `city` VALUES ('638', '68', '敦煌市', '3');
INSERT INTO `city` VALUES ('639', '68', '金塔县', '3');
INSERT INTO `city` VALUES ('640', '68', '瓜州县', '3');
INSERT INTO `city` VALUES ('641', '68', '肃北', '3');
INSERT INTO `city` VALUES ('642', '68', '阿克塞', '3');
INSERT INTO `city` VALUES ('643', '69', '临夏市', '3');
INSERT INTO `city` VALUES ('644', '69', '临夏县', '3');
INSERT INTO `city` VALUES ('645', '69', '康乐县', '3');
INSERT INTO `city` VALUES ('646', '69', '永靖县', '3');
INSERT INTO `city` VALUES ('647', '69', '广河县', '3');
INSERT INTO `city` VALUES ('648', '69', '和政县', '3');
INSERT INTO `city` VALUES ('649', '69', '东乡族自治县', '3');
INSERT INTO `city` VALUES ('650', '69', '积石山', '3');
INSERT INTO `city` VALUES ('651', '70', '成县', '3');
INSERT INTO `city` VALUES ('652', '70', '徽县', '3');
INSERT INTO `city` VALUES ('653', '70', '康县', '3');
INSERT INTO `city` VALUES ('654', '70', '礼县', '3');
INSERT INTO `city` VALUES ('655', '70', '两当县', '3');
INSERT INTO `city` VALUES ('656', '70', '文县', '3');
INSERT INTO `city` VALUES ('657', '70', '西和县', '3');
INSERT INTO `city` VALUES ('658', '70', '宕昌县', '3');
INSERT INTO `city` VALUES ('659', '70', '武都区', '3');
INSERT INTO `city` VALUES ('660', '71', '崇信县', '3');
INSERT INTO `city` VALUES ('661', '71', '华亭县', '3');
INSERT INTO `city` VALUES ('662', '71', '静宁县', '3');
INSERT INTO `city` VALUES ('663', '71', '灵台县', '3');
INSERT INTO `city` VALUES ('664', '71', '崆峒区', '3');
INSERT INTO `city` VALUES ('665', '71', '庄浪县', '3');
INSERT INTO `city` VALUES ('666', '71', '泾川县', '3');
INSERT INTO `city` VALUES ('667', '72', '合水县', '3');
INSERT INTO `city` VALUES ('668', '72', '华池县', '3');
INSERT INTO `city` VALUES ('669', '72', '环县', '3');
INSERT INTO `city` VALUES ('670', '72', '宁县', '3');
INSERT INTO `city` VALUES ('671', '72', '庆城县', '3');
INSERT INTO `city` VALUES ('672', '72', '西峰区', '3');
INSERT INTO `city` VALUES ('673', '72', '镇原县', '3');
INSERT INTO `city` VALUES ('674', '72', '正宁县', '3');
INSERT INTO `city` VALUES ('675', '73', '甘谷县', '3');
INSERT INTO `city` VALUES ('676', '73', '秦安县', '3');
INSERT INTO `city` VALUES ('677', '73', '清水县', '3');
INSERT INTO `city` VALUES ('678', '73', '秦州区', '3');
INSERT INTO `city` VALUES ('679', '73', '麦积区', '3');
INSERT INTO `city` VALUES ('680', '73', '武山县', '3');
INSERT INTO `city` VALUES ('681', '73', '张家川', '3');
INSERT INTO `city` VALUES ('682', '74', '古浪县', '3');
INSERT INTO `city` VALUES ('683', '74', '民勤县', '3');
INSERT INTO `city` VALUES ('684', '74', '天祝', '3');
INSERT INTO `city` VALUES ('685', '74', '凉州区', '3');
INSERT INTO `city` VALUES ('686', '75', '高台县', '3');
INSERT INTO `city` VALUES ('687', '75', '临泽县', '3');
INSERT INTO `city` VALUES ('688', '75', '民乐县', '3');
INSERT INTO `city` VALUES ('689', '75', '山丹县', '3');
INSERT INTO `city` VALUES ('690', '75', '肃南', '3');
INSERT INTO `city` VALUES ('691', '75', '甘州区', '3');
INSERT INTO `city` VALUES ('692', '76', '从化市', '3');
INSERT INTO `city` VALUES ('693', '76', '天河区', '3');
INSERT INTO `city` VALUES ('694', '76', '东山区', '3');
INSERT INTO `city` VALUES ('695', '76', '白云区', '3');
INSERT INTO `city` VALUES ('696', '76', '海珠区', '3');
INSERT INTO `city` VALUES ('697', '76', '荔湾区', '3');
INSERT INTO `city` VALUES ('698', '76', '越秀区', '3');
INSERT INTO `city` VALUES ('699', '76', '黄埔区', '3');
INSERT INTO `city` VALUES ('700', '76', '番禺区', '3');
INSERT INTO `city` VALUES ('701', '76', '花都区', '3');
INSERT INTO `city` VALUES ('702', '76', '增城区', '3');
INSERT INTO `city` VALUES ('703', '76', '从化区', '3');
INSERT INTO `city` VALUES ('704', '76', '市郊', '