mysql全国省市区

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