xiaoming
/*
Name: tangchao
Date: 2017-05-03 14:26:30
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `zbp_city`
-- ----------------------------
DROP TABLE IF EXISTS `zbp_city`;
CREATE TABLE `zbp_city` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cityID` varchar(6) DEFAULT NULL,
`city` varchar(50) DEFAULT NULL,
`father` varchar(6) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=346 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of zbp_city
-- ----------------------------
INSERT INTO `zbp_city` VALUES (1, 110100, 北京市, 110000, beijingshi);
INSERT INTO `zbp_city` VALUES (2, 110200, 北京县, 110000, beijingxian);
INSERT INTO `zbp_city` VALUES (3, 120100, 天津市, 120000, tianjinshi);
INSERT INTO `zbp_city` VALUES (4, 120200, 天津县, 120000, tianjinxian);
INSERT INTO `zbp_city` VALUES (5, 130100, 石家庄市, 130000, shijiazhuangshi);
INSERT INTO `zbp_city` VALUES (6, 130200, 唐山市, 130000, tangshanshi);
INSERT INTO `zbp_city` VALUES (7, 130300, 秦皇岛市, 130000, qinhuangdaoshi);
INSERT INTO `zbp_city` VALUES (8, 130400, 邯郸市, 130000, handanshi);
INSERT INTO `zbp_city` VALUES (9, 130500, 邢台市, 130000, xingtaishi);
INSERT INTO `zbp_city` VALUES (10, 130600, 保定市, 130000, baodingshi);
INSERT INTO `zbp_city` VALUES (11, 130700, 张家口市, 130000, zhangjiakoushi);
INSERT INTO `zbp_city` VALUES (12, 130800, 承德市, 130000, chengdeshi);
INSERT INTO `zbp_city` VALUES (13, 130900, 沧州市, 130000, cangzhoushi);
INSERT INTO `zbp_city` VALUES (14, 131000, 廊坊市, 130000, langfangshi);
INSERT INTO `zbp_city` VALUES (15, 131100, 衡水市, 130000, hengshuishi);
INSERT INTO `zbp_city` VALUES (16, 140100, 太原市, 140000, taiyuanshi);
INSERT INTO `zbp_city` VALUES (17, 140200, 大同市, 140000, datongshi);
INSERT INTO `zbp_city` VALUES (18, 140300, 阳泉市, 140000, yangquanshi);
INSERT INTO `zbp_city` VALUES (19, 140400, 长治市, 140000, changzhishi);
INSERT INTO `zbp_city` VALUES (20, 140500, 晋城市, 140000, jinchengshi);
INSERT INTO `zbp_city` VALUES (21, 140600, 朔州市, 140000, shuozhoushi);
INSERT INTO `zbp_city` VALUES (22, 140700, 晋中市, 140000, jinzhongshi);
INSERT INTO `zbp_city` VALUES (23, 140800, 运城市, 140000, yunchengshi);
INSERT INTO `zbp_city` VALUES (24, 140900, 忻州市, 140000, xinzhoushi);
INSERT INTO `zbp_city` VALUES (25, 141000, 临汾市, 140000, linfenshi);
INSERT INTO `zbp_city` VALUES (26, 141100, 吕梁市, 140000, lvliangshi);
INSERT INTO `zbp_city` VALUES (27, 150100, 呼和浩特市, 150000, huhehaoteshi);
INSERT INTO `zbp_city` VALUES (28, 150200, 包头市, 150000, baotoushi);
INSERT INTO `zbp_city` VALUES (29, 150300, 乌海市, 150000, wuhaishi);
INSERT INTO `zbp_city` VALUES (30, 150400, 赤峰市, 150000, chifengshi);
INSERT INTO `zbp_city` VALUES (31, 150500, 通辽市, 150000, tongliaoshi);
INSERT INTO `zbp_city` VALUES (32, 150600, 鄂尔多斯市, 150000, eerduosishi);
INSERT INTO `zbp_city` VALUES (33, 150700, 呼伦贝尔市, 150000, hulunbeiershi);
INSERT INTO `zbp_city` VALUES (34, 150800, 巴彦淖尔市, 150000, bayannaoershi);
INSERT INTO `zbp_city` VALUES (35, 150900, 乌兰察布市, 150000, wulanchabushi);
INSERT INTO `zbp_city` VALUES (36, 152200, 兴安盟, 150000, xinganmeng);
INSERT INTO `zbp_city` VALUES (37, 152500, 锡林郭勒盟, 150000, xilinguolemeng);
INSERT INTO `zbp_city` VALUES (38, 152900, 阿拉善盟, 150000, alashanmeng);
INSERT INTO `zbp_city` VALUES (39, 210100, 沈阳市, 210000, shenyangshi);
INSERT INTO `zbp_city` VALUES (40, 210200, 大连市, 210000, dalianshi);
INSERT INTO `zbp_city` VALUES (41, 210300, 鞍山市, 210000, anshanshi);
INSERT INTO `zbp_city` VALUES (42, 210400, 抚顺市, 210000, fushunshi);
INSERT INTO `zbp_city` VALUES (43, 210500, 本溪市, 210000, benxishi);
INSERT INTO `zbp_city` VALUES (44, 210600, 丹东市, 210000, dandongshi);
INSERT INTO `zbp_city` VALUES (45, 210700, 锦州市, 210000, jinzhoushi);
INSERT INTO `zbp_city` VALUES (46, 210800, 营口市, 210000, yingkoushi);
INSERT INTO `zbp_city` VALUES (47, 210900, 阜新市, 210000, fuxinshi);
INSERT INTO `zbp_city` VALUES (48, 211000, 辽阳市, 210000, liaoyangshi);
INSERT INTO `zbp_city` VALUES (49, 211100, 盘锦市, 210000, panjinshi);
INSERT INTO `zbp_city` VALUES (50, 211200, 铁岭市, 210000, tielingshi);
INSERT INTO `zbp_city` VALUES (51, 211300, 朝阳市, 210000, chaoyangshi);
INSERT INTO `zbp_city` VALUES (52, 211400, 葫芦岛市, 210000, huludaoshi);
INSERT INTO `zbp_city` VALUES (53, 220100, 长春市, 220000, changchunshi);
INSERT INTO `zbp_city` VALUES (54, 220200, 吉林市, 220000, jilinshi);
INSERT INTO `zbp_city` VALUES (55, 220300, 四平市, 220000, sipingshi);
INSERT INTO `zbp_city` VALUES (56, 220400, 辽源市, 220000, liaoyuanshi);
INSERT INTO `zbp_city` VALUES (57, 220500, 通化市, 220000, tonghuashi);
INSERT INTO `zbp_city` VALUES (58, 220600, 白山市, 220000, baishanshi);
INSERT INTO `zbp_city` VALUES (59, 220700, 松原市, 220000, songyuanshi);
INSERT INTO `zbp_city` VALUES (60, 220800, 白城市, 220000, baichengshi);
INSERT INTO `zbp_city` VALUES (61, 222400, 延边朝鲜族自治州, 220000, yanbianchaoxianzu);
INSERT INTO `zbp_city` VALUES (62, 230100, 哈尔滨市, 230000, haerbinshi);
INSERT INTO `zbp_city` VALUES (63, 230200, 齐齐哈尔市, 230000, qiqihaershi);
INSERT INTO `zbp_city` VALUES (64, 230300, 鸡西市, 230000, jixishi);
INSERT INTO `zbp_city` VALUES (65, 230400, 鹤岗市, 230000, hegangshi);
INSERT INTO `zbp_city` VALUES (66, 230500, 双鸭山市, 230000, shuangyashanshi);
INSERT INTO `zbp_city` VALUES (67, 230600, 大庆市, 230000, daqingshi);
INSERT INTO `zbp_city` VALUES (68, 230700, 伊春市, 230000, yichunshi);
INSERT INTO `zbp_city` VALUES (69, 230800, 佳木斯市, 230000, jiamusishi);
INSERT INTO `zbp_city` VALUES (70, 230900, 七台河市, 230000, qitaiheshi);
INSERT INTO `zbp_city` VALUES (71, 231000, 牡丹江市, 230000, mudanjiangshi);
INSERT INTO `zbp_city` VALUES (72, 231100, 黑河市, 230000, heiheshi);
INSERT INTO `zbp_city` VALUES (73, 231200, 绥化市, 230000, suihuashi);
INSERT INTO `zbp_city` VALUES (74, 232700, 大兴安岭地区, 230000, daxinganling);
INSERT INTO `zbp_city` VALUES (75, 310100, 上海市, 310000, shanghaishi);
INSERT INTO `zbp_city` VALUES (76, 310200, 上海县, 310000, shanghaixian);
INSERT INTO `zbp_city` VALUES (77, 320100, 南京市, 320000, nanjingshi);
INSERT INTO `zbp_city` VALUES (78, 320200, 无锡市, 320000, wuxishi);
INSERT INTO `zbp_city` VALUES (79, 320300, 徐州市, 320000, xuzhoushi);
INSERT INTO `zbp_city` VALUES (80, 320400, 常州市, 320000, changzhoushi);
INSERT INTO `zbp_city` VALUES (81, 320500, 苏州市, 320000, suzhoushi);
INSERT INTO `zbp_city` VALUES (82, 320600, 南通市, 320000, nantongshi);
INSERT INTO `zbp_city` VALUES (83, 320700, 连云港市, 320000, lianyungangshi);
INSERT INTO `zbp_city` VALUES (84, 320800, 淮安市, 320000, huaianshi);
INSERT INTO `zbp_city` VALUES (85, 320900, 盐城市, 320000, yanchengshi);
INSERT INTO `zbp_city` VALUES (86, 321000, 扬州市, 320000, yangzhoushi);
INSERT INTO `zbp_city` VALUES (87, 321100, 镇江市, 320000, zhenjiangshi);
INSERT INTO `zbp_city` VALUES (88, 321200, 泰州市, 320000, taizhoushi);
INSERT INTO `zbp_city` VALUES (89, 321300, 宿迁市, 320000, suqianshi);
INSERT INTO `zbp_city` VALUES (90, 330100, 杭州市, 330000, hangzhoushi);
INSERT INTO `zbp_city` VALUES (91, 330200, 宁波市, 330000, ningboshi);
INSERT INTO `zbp_city` VALUES (92, 330300, 温州市, 330000, wenzhoushi);
INSERT INTO `zbp_city` VALUES (93, 330400, 嘉兴市, 330000, jiaxingshi);
INSERT INTO `zbp_city` VALUES (94, 330500, 湖州市, 330000, huzhoushi);
INSERT INTO `zbp_city` VALUES (95, 330600, 绍兴市, 330000, shaoxingshi);
INSERT INTO `zbp_city` VALUES (96, 330700, 金华市, 330000, jinhuashi);
INSERT INTO `zbp_city` VALUES (97, 330800, 衢州市, 330000, zuozhoushi);
INSERT INTO `zbp_city` VALUES (98, 330900, 舟山市, 330000, zhoushanshi);
INSERT INTO `zbp_city` VALUES (99, 331000, 台州市, 330000, taizhoushi);
INSERT INTO `zbp_city` VALUES (100, 331100, 丽水市, 330000, lishuishi);
INSERT INTO `zbp_city` VALUES (101, 340100, 合肥市, 340000, hefeishi);
INSERT INTO `zbp_city` VALUES (102, 340200, 芜湖市, 340000, wuhushi);
INSERT INTO `zbp_city` VALUES (103, 340300, 蚌埠市, 340000, bangbushi);
INSERT INTO `zbp_city` VALUES (104, 340400, 淮南市, 340000, huainanshi);
INSERT INTO `zbp_city` VALUES (105, 340500, 马鞍山市, 340000, maanshanshi);
INSERT INTO `zbp_city` VALUES (106, 340600, 淮北市, 340000, huaibeishi);
INSERT INTO `zbp_city` VALUES (107, 340700, 铜陵市, 340000, tonglingshi);
INSERT INTO `zbp_city` VALUES (108, 340800, 安庆市, 340000, anqingshi);
INSERT INTO `zbp_city` VALUES (109, 341000, 黄山市, 340000, huangshanshi);
INSERT INTO `zbp_city` VALUES (110, 341100, 滁州市, 340000, chuzhoushi);
INSERT INTO `zbp_city` VALUES (111, 341200, 阜阳市, 340000, fuyangshi);
INSERT INTO `zbp_city` VALUES (112, 341300, 宿州市, 340000, suzhoushi);
INSERT INTO `zbp_city` VALUES (113, 341400, 巢湖市, 340000, chaohushi);
INSERT INTO `zbp_city` VALUES (114, 341500, 六安市, 340000, liuanshi);
INSERT INTO `zbp_city` VALUES (115, 341600, 亳州市, 340000, zuozhoushi);
INSERT INTO `zbp_city` VALUES (116, 341700, 池州市, 340000, chizhoushi);
INSERT INTO `zbp_city` VALUES (117, 341800, 宣城市, 340000, xuanchengshi);
INSERT INTO `zbp_city` VALUES (118, 350100, 福州市, 350000, fuzhoushi);
INSERT INTO `zbp_city` VALUES (119, 350200, 厦门市, 350000, xiamenshi);
INSERT INTO `zbp_city` VALUES (120, 350300, 莆田市, 350000, putianshi);
INSERT INTO `zbp_city` VALUES (121, 350400, 三明市, 350000, sanmingshi);
INSERT INTO `zbp_city` VALUES (122, 350500, 泉州市, 350000, quanzhoushi);
INSERT INTO `zbp_city` VALUES (123, 350600, 漳州市, 350000, zhangzhoushi);
INSERT INTO `zbp_city` VALUES (124, 350700, 南平市, 350000, nanpingshi);
INSERT INTO `zbp_city` VALUES (125, 350800, 龙岩市, 350000, longyanshi);
INSERT INTO `zbp_city` VALUES (126, 350900, 宁德市, 350000, ningdeshi);
INSERT INTO `zbp_city` VALUES (127, 360100, 南昌市, 360000, nanchangshi);
INSERT INTO `zbp_city` VALUES (128, 360200, 景德镇市, 360000, jingdezhenshi);
INSERT INTO `zbp_city` VALUES (129, 360300, 萍乡市, 360000, pingxiangshi);
INSERT INTO `zbp_city` VALUES (130, 360400, 九江市, 360000, jiujiangshi);
INSERT INTO `zbp_city` VALUES (131, 360500, 新余市, 360000, xinyushi);
INSERT INTO `zbp_city` VALUES (132, 360600, 鹰潭市, 360000, yingtanshi);
INSERT INTO `zbp_city` VALUES (133, 360700, 赣州市, 360000, ganzhoushi);
INSERT INTO `zbp_city` VALUES (134, 360800, 吉安市, 360000, jianshi);
INSERT INTO `zbp_city` VALUES (135, 360900, 宜春市, 360000, yichunshi);
INSERT INTO `zbp_city` VALUES (136, 361000, 抚州市, 360000, fuzhoushi);
INSERT INTO `zbp_city` VALUES (137, 361100, 上饶市, 360000, shangraoshi);
INSERT INTO `zbp_city` VALUES (138, 370100, 济南市, 370000, jinanshi);
INSERT INTO `zbp_city` VALUES (139, 370200, 青岛市, 370000, qingdaoshi);
INSERT INTO `zbp_city` VALUES (140, 370300, 淄博市, 370000, ziboshi);
INSERT INTO `zbp_city` VALUES (141, 370400, 枣庄市, 370000, zaozhuangshi);
INSERT INTO `zbp_city` VALUES (142, 370500, 东营市, 370000, dongyingshi);
INSERT INTO `zbp_city` VALUES (143, 370600, 烟台市, 370000, yantaishi);
INSERT INTO `zbp_city` VALUES (144, 370700, 潍坊市, 370000, weifangshi);
INSERT INTO `zbp_city` VALUES (145, 370800, 济宁市, 370000, jiningshi);
INSERT INTO `zbp_city` VALUES (146, 370900, 泰安市, 370000, taianshi);
INSERT INTO `zbp_city` VALUES (147, 371000, 威海市, 370000, weihaishi);
INSERT INTO `zbp_city` VALUES (148, 371100, 日照市, 370000, rizhaoshi);
INSERT INTO `zbp_city` VALUES (149, 371200, 莱芜市, 370000, laiwushi);
INSERT INTO `zbp_city` VALUES (150, 371300, 临沂市, 370000, linyishi);
INSERT INTO `zbp_city` VALUES (151, 371400, 德州市, 370000, dezhoushi);
INSERT INTO `zbp_city` VALUES (152, 371500, 聊城市, 370000, liaochengshi);
INSERT INTO `zbp_city` VALUES (153, 371600, 滨州市, 370000, binzhoushi);
INSERT INTO `zbp_city` VALUES (154, 371700, 荷泽市, 370000, hezeshi);
INSERT INTO `zbp_city` VALUES (155, 410100, 郑州市, 410000, zhengzhoushi);
INSERT INTO `zbp_city` VALUES (156, 410200, 开封市, 410000, kaifengshi);
INSERT INTO `zbp_city` VALUES (157, 410300, 洛阳市, 410000, luoyangshi);
INSERT INTO `zbp_city` VALUES (158, 410400, 平顶山市, 410000, pingdingshanshi);
INSERT INTO `zbp_city` VALUES (159, 410500, 安阳市, 410000, anyangshi);
INSERT INTO `zbp_city` VALUES (160, 410600, 鹤壁市, 410000, hebishi);
INSERT INTO `zbp_city` VALUES (161, 410700, 新乡市, 410000, xinxiangshi);
INSERT INTO `zbp_city` VALUES (162, 410800, 焦作市, 410000, jiaozuoshi);
INSERT INTO `zbp_city` VALUES (163, 410900, 濮阳市, 410000, zuoyangshi);
INSERT INTO `zbp_city` VALUES (164, 411000, 许昌市, 410000, xuchangshi);
INSERT INTO `zbp_city` VALUES (165, 411100, 漯河市, 410000, zuoheshi);
INSERT INTO `zbp_city` VALUES (166, 411200, 三门峡市, 410000, sanmenxiashi);
INSERT INTO `zbp_city` VALUES (167, 411300, 南阳市, 410000, nanyangshi);
INSERT INTO `zbp_city` VALUES (168, 411400, 商丘市, 410000, shangqiushi);
INSERT INTO `zbp_city` VALUES (169, 411500, 信阳市, 410000, xinyangshi);
INSERT INTO `zbp_city` VALUES (170, 411600, 周口市, 410000, zhoukoushi);
INSERT INTO `zbp_city` VALUES (171, 411700, 驻马店市, 410000, zhumadianshi);
INSERT INTO `zbp_city` VALUES (172, 420100, 武汉市, 420000, wuhanshi);
INSERT INTO `zbp_city` VALUES (173, 420200, 黄石市, 420000, huangshishi);
INSERT INTO `zbp_city` VALUES (174, 420300, 十堰市, 420000, shiyanshi);
INSERT INTO `zbp_city` VALUES (175, 420500, 宜昌市, 420000, yichangshi);
INSERT INTO `zbp_city` VALUES (176, 420600, 襄樊市, 420000, xiangfanshi);
INSERT INTO `zbp_city` VALUES (177, 420700, 鄂州市, 420000, ezhoushi);
INSERT INTO `zbp_city` VALUES (178, 420800, 荆门市, 420000, jingmenshi);
INSERT INTO `zbp_city` VALUES (179, 420900, 孝感市, 420000, xiaoganshi);
INSERT INTO `zbp_city` VALUES (180, 421000, 荆州市, 420000, jingzhoushi);
INSERT INTO `zbp_city` VALUES (181, 421100, 黄冈市, 420000, huanggangshi);
INSERT INTO `zbp_city` VALUES (182, 421200, 咸宁市, 420000, xianningshi);
INSERT INTO `zbp_city` VALUES (183, 421300, 随州市, 420000, suizhoushi);
INSERT INTO `zbp_city` VALUES (184, 422800, 恩施土家族苗族自治州, 420000, enshitujiazumiaozu);
INSERT INTO `zbp_city` VALUES (185, 429000, 湖北省直辖行政单位, 420000, hubeisheng);
INSERT INTO `zbp_city` VALUES (186, 430100, 长沙市, 430000, changshashi);
INSERT INTO `zbp_city` VALUES (187, 430200, 株洲市, 430000, zhuzhoushi);
INSERT INTO `zbp_city` VALUES (188, 430300, 湘潭市, 430000, xiangtanshi);
INSERT INTO `zbp_city` VALUES (189, 430400, 衡阳市, 430000, hengyangshi);
INSERT INTO `zbp_city` VALUES (190, 430500, 邵阳市, 430000, shaoyangshi);
INSERT INTO `zbp_city` VALUES (191, 430600, 岳阳市, 430000, yueyangshi);
INSERT INTO `zbp_city` VALUES (192, 430700, 常德市, 430000, changdeshi);
INSERT INTO `zbp_city` VALUES (193, 430800, 张家界市, 430000, zhangjiajieshi);
INSERT INTO `zbp_city` VALUES (194, 430900, 益阳市, 430000, yiyangshi);
INSERT INTO `zbp_city` VALUES (195, 431000, 郴州市, 430000, chenzhoushi);
INSERT INTO `zbp_city` VALUES (196, 431100, 永州市, 430000, yongzhoushi);
INSERT INTO `zbp_city` VALUES (197, 431200, 怀化市, 430000, huaihuashi);
INSERT INTO `zbp_city` VALUES (198, 431300, 娄底市, 430000, loudishi);
INSERT INTO `zbp_city` VALUES (199, 433100, 湘西土家族苗族自治州, 430000, xiangxitujiazumiaozu);
INSERT INTO `zbp_city` VALUES (200, 440100, 广州市, 440000, guangzhoushi);
INSERT INTO `zbp_city` VALUES (201, 440200, 韶关市, 440000, shaoguanshi);
INSERT INTO `zbp_city` VALUES (202, 440300, 深圳市, 440000, shenzuoshi);
INSERT INTO `zbp_city` VALUES (203, 440400, 珠海市, 440000, zhuhaishi);
INSERT INTO `zbp_city` VALUES (204, 440500, 汕头市, 440000, shantoushi);
INSERT INTO `zbp_city` VALUES (205, 440600, 佛山市, 440000, foshanshi);
INSERT INTO `zbp_city` VALUES (206, 440700, 江门市, 440000, jiangmenshi);
INSERT INTO `zbp_city` VALUES (207, 440800, 湛江市, 440000, zhanjiangshi);
INSERT INTO `zbp_city` VALUES (208, 440900, 茂名市, 440000, maomingshi);
INSERT INTO `zbp_city` VALUES (209, 441200, 肇庆市, 440000, zhaoqingshi);
INSERT INTO `zbp_city` VALUES (210, 441300, 惠州市, 440000, huizhoushi);
INSERT INTO `zbp_city` VALUES (211, 441400, 梅州市, 440000, meizhoushi);
INSERT INTO `zbp_city` VALUES (212, 441500, 汕尾市, 440000, shanweishi);
INSERT INTO `zbp_city` VALUES (213, 441600, 河源市, 440000, heyuanshi);
INSERT INTO `zbp_city` VALUES (214, 441700, 阳江市, 440000, yangjiangshi);
INSERT INTO `zbp_city` VALUES (215, 441800, 清远市, 440000, qingyuanshi);
INSERT INTO `zbp_city` VALUES (216, 441900, 东莞市, 440000, dongzuoshi);
INSERT INTO `zbp_city` VALUES (217, 442000, 中山市, 440000, zhongshanshi);
INSERT INTO `zbp_city` VALUES (218, 445100, 潮州市, 440000, chaozhoushi);
INSERT INTO `zbp_city` VALUES (219, 445200, 揭阳市, 440000, jieyangshi);
INSERT INTO `zbp_city` VALUES (220, 445300, 云浮市, 440000, yunfushi);
INSERT INTO `zbp_city` VALUES (221, 450100, 南宁市, 450000, nanningshi);
INSERT INTO `zbp_city` VALUES (222, 450200, 柳州市, 450000, liuzhoushi);
INSERT INTO `zbp_city` VALUES (223, 450300, 桂林市, 450000, guilinshi);
INSERT INTO `zbp_city` VALUES (224, 450400, 梧州市, 450000, wuzhoushi);
INSERT INTO `zbp_city` VALUES (225, 450500, 北海市, 450000, beihaishi);
INSERT INTO `zbp_city` VALUES (226, 450600, 防城港市, 450000, fangchenggangshi);
INSERT INTO `zbp_city` VALUES (227, 450700, 钦州市, 450000, qinzhoushi);
INSERT INTO `zbp_city` VALUES (228, 450800, 贵港市, 450000, guigangshi);
INSERT INTO `zbp_city` VALUES (229, 450900, 玉林市, 450000, yulinshi);
INSERT INTO `zbp_city` VALUES (230, 451000, 百色市, 450000, baiseshi);
INSERT INTO `zbp_city` VALUES (231, 451100, 贺州市, 450000, hezhoushi);
INSERT INTO `zbp_city` VALUES (232, 451200, 河池市, 450000, hechishi);
INSERT INTO `zbp_city` VALUES (233, 451300, 来宾市, 450000, laibinshi);
INSERT INTO `zbp_city` VALUES (234, 451400, 崇左市, 450000, chongzuoshi);
INSERT INTO `zbp_city` VALUES (235, 460100, 海口市, 460000, haikoushi);
INSERT INTO `zbp_city` VALUES (236, 460200, 三亚市, 460000, sanyashi);
INSERT INTO `zbp_city` VALUES (237, 469000, 省直辖县级行政单位, 460000, shengzhixiaxianjixingzhengdanwei);
INSERT INTO `zbp_city` VALUES (238, 500100, 重庆市, 500000, zhongqingshi);
INSERT INTO `zbp_city` VALUES (239, 500200, 重庆县, 500000, zhongqingxian);
INSERT INTO `zbp_city` VALUES (240, 500300, 市, 500000, shi);
INSERT INTO `zbp_city` VALUES (241, 510100, 成都市, 510000, chengdushi);
INSERT INTO `zbp_city` VALUES (242, 510300, 自贡市, 510000, zigongshi);
INSERT INTO `zbp_city` VALUES (243, 510400, 攀枝花市, 510000, panzhihuashi);
INSERT INTO `zbp_city` VALUES (244, 510500, 泸州市, 510000, zuozhoushi);
INSERT INTO `zbp_city` VALUES (245, 510600, 德阳市, 510000, deyangshi);
INSERT INTO `zbp_city` VALUES (246, 510700, 绵阳市, 510000, mianyangshi);
INSERT INTO `zbp_city` VALUES (247, 510800, 广元市, 510000, guangyuanshi);
INSERT INTO `zbp_city` VALUES (248, 510900, 遂宁市, 510000, suiningshi);
INSERT INTO `zbp_city` VALUES (249, 511000, 内江市, 510000, neijiangshi);
INSERT INTO `zbp_city` VALUES (250, 511100, 乐山市, 510000, leshanshi);
INSERT INTO `zbp_city` VALUES (251, 511300, 南充市, 510000, nanchongshi);
INSERT INTO `zbp_city` VALUES (252, 511400, 眉山市, 510000, meishanshi);
INSERT INTO `zbp_city` VALUES (253, 511500, 宜宾市, 510000, yibinshi);
INSERT INTO `zbp_city` VALUES (254, 511600, 广安市, 510000, guanganshi);
INSERT INTO `zbp_city` VALUES (255, 511700, 达州市, 510000, dazhoushi);
INSERT INTO `zbp_city` VALUES (256, 511800, 雅安市, 510000, yaanshi);
INSERT INTO `zbp_city` VALUES (257, 511900, 巴中市, 510000, bazhongshi);
INSERT INTO `zbp_city` VALUES (258, 512000, 资阳市, 510000, ziyangshi);
INSERT INTO `zbp_city` VALUES (259, 513200, 阿坝藏族羌族自治州, 510000, abacangzuqiangzu);
INSERT INTO `zbp_city` VALUES (260, 513300, 甘孜藏族自治州, 510000, ganzicangzu);
INSERT INTO `zbp_city` VALUES (261, 513400, 凉山彝族自治州, 510000, liangshanyizu);
INSERT INTO `zbp_city` VALUES (262, 520100, 贵阳市, 520000, guiyangshi);
INSERT INTO `zbp_city` VALUES (263, 520200, 六盘水市, 520000, liupanshuishi);
INSERT INTO `zbp_city` VALUES (264, 520300, 遵义市, 520000, zunyishi);
INSERT INTO `zbp_city` VALUES (265, 520400, 安顺市, 520000, anshunshi);
INSERT INTO `zbp_city` VALUES (266, 522200, 铜仁地区, 520000, tongren);
INSERT INTO `zbp_city` VALUES (267, 522300, 黔西南布依族苗族自治州, 520000, qianxinanbuyizumiaozu);
INSERT INTO `zbp_city` VALUES (268, 522400, 毕节地区, 520000, bijie);
INSERT INTO `zbp_city` VALUES (269, 522600, 黔东南苗族侗族自治州, 520000, qiandongnanmiaozudongzu);
INSERT INTO `zbp_city` VALUES (270, 522700, 黔南布依族苗族自治州, 520000, qiannanbuyizumiaozu);
INSERT INTO `zbp_city` VALUES (271, 530100, 昆明市, 530000, kunmingshi);
INSERT INTO `zbp_city` VALUES (272, 530300, 曲靖市, 530000, qujingshi);
INSERT INTO `zbp_city` VALUES (273, 530400, 玉溪市, 530000, yuxishi);
INSERT INTO `zbp_city` VALUES (274, 530500, 保山市, 530000, baoshanshi);
INSERT INTO `zbp_city` VALUES (275, 530600, 昭通市, 530000, zhaotongshi);
INSERT INTO `zbp_city` VALUES (276, 530700, 丽江市, 530000, lijiangshi);
INSERT INTO `zbp_city` VALUES (277, 530800, 思茅市, 530000, simaoshi);
INSERT INTO `zbp_city` VALUES (278, 530900, 临沧市, 530000, lincangshi);
INSERT INTO `zbp_city` VALUES (279, 532300, 楚雄彝族自治州, 530000, chuxiongyizu);
INSERT INTO `zbp_city` VALUES (280, 532500, 红河哈尼族彝族自治州, 530000, honghehanizuyizu);
INSERT INTO `zbp_city` VALUES (281, 532600, 文山壮族苗族自治州, 530000, wenshanzhuangzumiaozu);
INSERT INTO `zbp_city` VALUES (282, 532800, 西双版纳傣族自治州, 530000, xishuangbannadaizu);
INSERT INTO `zbp_city` VALUES (283, 532900, 大理白族自治州, 530000, dalibaizu);
INSERT INTO `zbp_city` VALUES (284, 533100, 德宏傣族景颇族自治州, 530000, dehongdaizujingpozu);
INSERT INTO `zbp_city` VALUES (285, 533300, 怒江傈僳族自治州, 530000, nujianglisuzu);
INSERT INTO `zbp_city` VALUES (286, 533400, 迪庆藏族自治州, 530000, diqingcangzu);
INSERT INTO `zbp_city` VALUES (287, 540100, 拉萨市, 540000, lasashi);
INSERT INTO `zbp_city` VALUES (288, 542100, 昌都地区, 540000, changdu);
INSERT INTO `zbp_city` VALUES (289, 542200, 山南地区, 540000, shannan);
INSERT INTO `zbp_city` VALUES (290, 542300, 日喀则地区, 540000, rikaze);
INSERT INTO `zbp_city` VALUES (291, 542400, 那曲地区, 540000, naqu);
INSERT INTO `zbp_city` VALUES (292, 542500, 阿里地区, 540000, ali);
INSERT INTO `zbp_city` VALUES (293, 542600, 林芝地区, 540000, linzhi);
INSERT INTO `zbp_city` VALUES (294, 610100, 西安市, 610000, xianshi);
INSERT INTO `zbp_city` VALUES (295, 610200, 铜川市, 610000, tongchuanshi);
INSERT INTO `zbp_city` VALUES (296, 610300, 宝鸡市, 610000, baojishi);
INSERT INTO `zbp_city` VALUES (297, 610400, 咸阳市, 610000, xianyangshi);
INSERT INTO `zbp_city` VALUES (298, 610500, 渭南市, 610000, weinanshi);
INSERT INTO `zbp_city` VALUES (299, 610600, 延安市, 610000, yananshi);
INSERT INTO `zbp_city` VALUES (300, 610700, 汉中市, 610000, hanzhongshi);
INSERT INTO `zbp_city` VALUES (301, 610800, 榆林市, 610000, yulinshi);
INSERT INTO `zbp_city` VALUES (302, 610900, 安康市, 610000, ankangshi);
INSERT INTO `zbp_city` VALUES (303, 611000, 商洛市, 610000, shangluoshi);
INSERT INTO `zbp_city` VALUES (304, 620100, 兰州市, 620000, lanzhoushi);
INSERT INTO `zbp_city` VALUES (305, 620200, 嘉峪关市, 620000, jiayuguanshi);
INSERT INTO `zbp_city` VALUES (306, 620300, 金昌市, 620000, jinchangshi);
INSERT INTO `zbp_city` VALUES (307, 620400, 白银市, 620000, baiyinshi);
INSERT INTO `zbp_city` VALUES (308, 620500, 天水市, 620000, tianshuishi);
INSERT INTO `zbp_city` VALUES (309, 620600, 武威市, 620000, wuweishi);
INSERT INTO `zbp_city` VALUES (310, 620700, 张掖市, 620000, zhangyeshi);
INSERT INTO `zbp_city` VALUES (311, 620800, 平凉市, 620000, pingliangshi);
INSERT INTO `zbp_city` VALUES (312, 620900, 酒泉市, 620000, jiuquanshi);
INSERT INTO `zbp_city` VALUES (313, 621000, 庆阳市, 620000, qingyangshi);
INSERT INTO `zbp_city` VALUES (314, 621100, 定西市, 620000, dingxishi);
INSERT INTO `zbp_city` VALUES (315, 621200, 陇南市, 620000, longnanshi);
INSERT INTO `zbp_city` VALUES (316, 622900, 临夏回族自治州, 620000, linxiahuizu);
INSERT INTO `zbp_city` VALUES (317, 623000, 甘南藏族自治州, 620000, gannancangzu);
INSERT INTO `zbp_city` VALUES (318, 630100, 西宁市, 630000, xiningshi);
INSERT INTO `zbp_city` VALUES (319, 632100, 海东地区, 630000, haidong);
INSERT INTO `zbp_city` VALUES (320, 632200, 海北藏族自治州, 630000, haibeicangzu);
INSERT INTO `zbp_city` VALUES (321, 632300, 黄南藏族自治州, 630000, huangnancangzu);
INSERT INTO `zbp_city` VALUES (322, 632500, 海南藏族自治州, 630000, hainancangzu);
INSERT INTO `zbp_city` VALUES (323, 632600, 果洛藏族自治州, 630000, guoluocangzu);
INSERT INTO `zbp_city` VALUES (324, 632700, 玉树藏族自治州, 630000, yushucangzu);
INSERT INTO `zbp_city` VALUES (325, 632800, 海西蒙古族藏族自治州, 630000, haiximengguzucangzu);
INSERT INTO `zbp_city` VALUES (326, 640100, 银川市, 640000, yinchuanshi);
INSERT INTO `zbp_city` VALUES (327, 640200, 石嘴山市, 640000, shizuishanshi);
INSERT INTO `zbp_city` VALUES (328, 640300, 吴忠市, 640000, wuzhongshi);
INSERT INTO `zbp_city` VALUES (329, 640400, 固原市, 640000, guyuanshi);
INSERT INTO `zbp_city` VALUES (330, 640500, 中卫市, 640000, zhongweishi);
INSERT INTO `zbp_city` VALUES (331, 650100, 乌鲁木齐市, 650000, wulumuqishi);
INSERT INTO `zbp_city` VALUES (332, 650200, 克拉玛依市, 650000, kelamayishi);
INSERT INTO `zbp_city` VALUES (333, 652100, 吐鲁番地区, 650000, tulufan);
INSERT INTO `zbp_city` VALUES (334, 652200, 哈密地区, 650000, hami);
INSERT INTO `zbp_city` VALUES (335, 652300, 昌吉回族自治州, 650000, changjihuizu);
INSERT INTO `zbp_city` VALUES (336, 652700, 博尔塔拉蒙古自治州, 650000, boertalamenggu);
INSERT INTO `zbp_city` VALUES (337, 652800, 巴音郭楞蒙古自治州, 650000, bayinguolengmenggu);
INSERT INTO `zbp_city` VALUES (338, 652900, 阿克苏地区, 650000, akesu);
INSERT INTO `zbp_city` VALUES (339, 653000, 克孜勒苏柯尔克孜自治州, 650000, kezilesukeerkezi);
INSERT INTO `zbp_city` VALUES (340, 653100, 喀什地区, 650000, kashi);
INSERT INTO `zbp_city` VALUES (341, 653200, 和田地区, 650000, hetian);
INSERT INTO `zbp_city` VALUES (342, 654000, 伊犁哈萨克自治州, 650000, yilihasake);
INSERT INTO `zbp_city` VALUES (343, 654200, 塔城地区, 650000, tacheng);
INSERT INTO `zbp_city` VALUES (344, 654300, 阿勒泰地区, 650000, aletai);
INSERT INTO `zbp_city` VALUES (345, 659000, 新疆省直辖行政单位, 650000, xinjiangsheng);
