省市区三级数据-MySQL

╰+攻爆jí腚メ 2023-01-16 09:47 92阅读 0赞

CREATE TABLE hat\_province (  
sid int(11) NOT NULL ,  
provinceID varchar(6) default NULL,  
province varchar(40) default NULL,  
PRIMARY KEY (sid)  
);

INSERT INTO hat\_province VALUES (1,'110000','北京市');  
INSERT INTO hat\_province VALUES (2,'120000','天津市');  
INSERT INTO hat\_province VALUES (3,'130000','河北省');  
INSERT INTO hat\_province VALUES (4,'140000','山西省');  
INSERT INTO hat\_province VALUES (5,'150000','内蒙古自治区');  
INSERT INTO hat\_province VALUES (6,'210000','辽宁省');  
INSERT INTO hat\_province VALUES (7,'220000','吉林省');  
INSERT INTO hat\_province VALUES (8,'230000','黑龙江省');  
INSERT INTO hat\_province VALUES (9,'310000','上海市');  
INSERT INTO hat\_province VALUES (10,'320000','江苏省');  
INSERT INTO hat\_province VALUES (11,'330000','浙江省');  
INSERT INTO hat\_province VALUES (12,'340000','安徽省');  
INSERT INTO hat\_province VALUES (13,'350000','福建省');  
INSERT INTO hat\_province VALUES (14,'360000','江西省');  
INSERT INTO hat\_province VALUES (15,'370000','山东省');  
INSERT INTO hat\_province VALUES (16,'410000','河南省');  
INSERT INTO hat\_province VALUES (17,'420000','湖北省');  
INSERT INTO hat\_province VALUES (18,'430000','湖南省');  
INSERT INTO hat\_province VALUES (19,'440000','广东省');  
INSERT INTO hat\_province VALUES (20,'450000','广西壮族自治区');  
INSERT INTO hat\_province VALUES (21,'460000','海南省');  
INSERT INTO hat\_province VALUES (22,'500000','重庆市');  
INSERT INTO hat\_province VALUES (23,'510000','四川省');  
INSERT INTO hat\_province VALUES (24,'520000','贵州省');  
INSERT INTO hat\_province VALUES (25,'530000','云南省');  
INSERT INTO hat\_province VALUES (26,'540000','西藏自治区');  
INSERT INTO hat\_province VALUES (27,'610000','陕西省');  
INSERT INTO hat\_province VALUES (28,'620000','甘肃省');  
INSERT INTO hat\_province VALUES (29,'630000','青海省');  
INSERT INTO hat\_province VALUES (30,'640000','宁夏回族自治区');  
INSERT INTO hat\_province VALUES (31,'650000','新疆维吾尔自治区');  
INSERT INTO hat\_province VALUES (32,'710000','台湾省');  
INSERT INTO hat\_province VALUES (33,'810000','香港特别行政区');  
INSERT INTO hat\_province VALUES (34,'820000','澳门特别行政区');

CREATE TABLE hat\_city (  
cid int(11) NOT NULL ,  
cityID varchar(6) default NULL,  
city varchar(50) default NULL,  
father varchar(6) default NULL,  
PRIMARY KEY (cid)  
);

INSERT INTO hat\_city VALUES (1,'110100','市辖区','110000');  
INSERT INTO hat\_city VALUES (2,'110200','县','110000');  
INSERT INTO hat\_city VALUES (3,'120100','市辖区','120000');  
INSERT INTO hat\_city VALUES (4,'120200','县','120000');  
INSERT INTO hat\_city VALUES (5,'130100','石家庄市','130000');  
INSERT INTO hat\_city VALUES (6,'130200','唐山市','130000');  
INSERT INTO hat\_city VALUES (7,'130300','秦皇岛市','130000');  
INSERT INTO hat\_city VALUES (8,'130400','邯郸市','130000');  
INSERT INTO hat\_city VALUES (9,'130500','邢台市','130000');  
INSERT INTO hat\_city VALUES (10,'130600','保定市','130000');  
INSERT INTO hat\_city VALUES (11,'130700','张家口市','130000');  
INSERT INTO hat\_city VALUES (12,'130800','承德市','130000');  
INSERT INTO hat\_city VALUES (13,'130900','沧州市','130000');  
INSERT INTO hat\_city VALUES (14,'131000','廊坊市','130000');  
INSERT INTO hat\_city VALUES (15,'131100','衡水市','130000');  
INSERT INTO hat\_city VALUES (16,'140100','太原市','140000');  
INSERT INTO hat\_city VALUES (17,'140200','大同市','140000');  
INSERT INTO hat\_city VALUES (18,'140300','阳泉市','140000');  
INSERT INTO hat\_city VALUES (19,'140400','长治市','140000');  
INSERT INTO hat\_city VALUES (20,'140500','晋城市','140000');  
INSERT INTO hat\_city VALUES (21,'140600','朔州市','140000');  
INSERT INTO hat\_city VALUES (22,'140700','晋中市','140000');  
INSERT INTO hat\_city VALUES (23,'140800','运城市','140000');  
INSERT INTO hat\_city VALUES (24,'140900','忻州市','140000');  
INSERT INTO hat\_city VALUES (25,'141000','临汾市','140000');  
INSERT INTO hat\_city VALUES (26,'141100','吕梁市','140000');  
INSERT INTO hat\_city VALUES (27,'150100','呼和浩特市','150000');  
INSERT INTO hat\_city VALUES (28,'150200','包头市','150000');  
INSERT INTO hat\_city VALUES (29,'150300','乌海市','150000');  
INSERT INTO hat\_city VALUES (30,'150400','赤峰市','150000');  
INSERT INTO hat\_city VALUES (31,'150500','通辽市','150000');  
INSERT INTO hat\_city VALUES (32,'150600','鄂尔多斯市','150000');  
INSERT INTO hat\_city VALUES (33,'150700','呼伦贝尔市','150000');  
INSERT INTO hat\_city VALUES (34,'150800','巴彦淖尔市','150000');  
INSERT INTO hat\_city VALUES (35,'150900','乌兰察布市','150000');  
INSERT INTO hat\_city VALUES (36,'152200','兴安盟','150000');  
INSERT INTO hat\_city VALUES (37,'152500','锡林郭勒盟','150000');  
INSERT INTO hat\_city VALUES (38,'152900','阿拉善盟','150000');  
INSERT INTO hat\_city VALUES (39,'210100','沈阳市','210000');  
INSERT INTO hat\_city VALUES (40,'210200','大连市','210000');  
INSERT INTO hat\_city VALUES (41,'210300','鞍山市','210000');  
INSERT INTO hat\_city VALUES (42,'210400','抚顺市','210000');  
INSERT INTO hat\_city VALUES (43,'210500','本溪市','210000');  
INSERT INTO hat\_city VALUES (44,'210600','丹东市','210000');  
INSERT INTO hat\_city VALUES (45,'210700','锦州市','210000');  
INSERT INTO hat\_city VALUES (46,'210800','营口市','210000');  
INSERT INTO hat\_city VALUES (47,'210900','阜新市','210000');  
INSERT INTO hat\_city VALUES (48,'211000','辽阳市','210000');  
INSERT INTO hat\_city VALUES (49,'211100','盘锦市','210000');  
INSERT INTO hat\_city VALUES (50,'211200','铁岭市','210000');  
INSERT INTO hat\_city VALUES (51,'211300','朝阳市','210000');  
INSERT INTO hat\_city VALUES (52,'211400','葫芦岛市','210000');  
INSERT INTO hat\_city VALUES (53,'220100','长春市','220000');  
INSERT INTO hat\_city VALUES (54,'220200','吉林市','220000');  
INSERT INTO hat\_city VALUES (55,'220300','四平市','220000');  
INSERT INTO hat\_city VALUES (56,'220400','辽源市','220000');  
INSERT INTO hat\_city VALUES (57,'220500','通化市','220000');  
INSERT INTO hat\_city VALUES (58,'220600','白山市','220000');  
INSERT INTO hat\_city VALUES (59,'220700','松原市','220000');  
INSERT INTO hat\_city VALUES (60,'220800','白城市','220000');  
INSERT INTO hat\_city VALUES (61,'222400','延边朝鲜族自治州','220000');  
INSERT INTO hat\_city VALUES (62,'230100','哈尔滨市','230000');  
INSERT INTO hat\_city VALUES (63,'230200','齐齐哈尔市','230000');  
INSERT INTO hat\_city VALUES (64,'230300','鸡西市','230000');  
INSERT INTO hat\_city VALUES (65,'230400','鹤岗市','230000');  
INSERT INTO hat\_city VALUES (66,'230500','双鸭山市','230000');  
INSERT INTO hat\_city VALUES (67,'230600','大庆市','230000');  
INSERT INTO hat\_city VALUES (68,'230700','伊春市','230000');  
INSERT INTO hat\_city VALUES (69,'230800','佳木斯市','230000');  
INSERT INTO hat\_city VALUES (70,'230900','七台河市','230000');  
INSERT INTO hat\_city VALUES (71,'231000','牡丹江市','230000');  
INSERT INTO hat\_city VALUES (72,'231100','黑河市','230000');  
INSERT INTO hat\_city VALUES (73,'231200','绥化市','230000');  
INSERT INTO hat\_city VALUES (74,'232700','大兴安岭地区','230000');  
INSERT INTO hat\_city VALUES (75,'310100','市辖区','310000');  
INSERT INTO hat\_city VALUES (76,'310200','县','310000');  
INSERT INTO hat\_city VALUES (77,'320100','南京市','320000');  
INSERT INTO hat\_city VALUES (78,'320200','无锡市','320000');  
INSERT INTO hat\_city VALUES (79,'320300','徐州市','320000');  
INSERT INTO hat\_city VALUES (80,'320400','常州市','320000');  
INSERT INTO hat\_city VALUES (81,'320500','苏州市','320000');  
INSERT INTO hat\_city VALUES (82,'320600','南通市','320000');  
INSERT INTO hat\_city VALUES (83,'320700','连云港市','320000');  
INSERT INTO hat\_city VALUES (84,'320800','淮安市','320000');  
INSERT INTO hat\_city VALUES (85,'320900','盐城市','320000');  
INSERT INTO hat\_city VALUES (86,'321000','扬州市','320000');  
INSERT INTO hat\_city VALUES (87,'321100','镇江市','320000');  
INSERT INTO hat\_city VALUES (88,'321200','泰州市','320000');  
INSERT INTO hat\_city VALUES (89,'321300','宿迁市','320000');  
INSERT INTO hat\_city VALUES (90,'330100','杭州市','330000');  
INSERT INTO hat\_city VALUES (91,'330200','宁波市','330000');  
INSERT INTO hat\_city VALUES (92,'330300','温州市','330000');  
INSERT INTO hat\_city VALUES (93,'330400','嘉兴市','330000');  
INSERT INTO hat\_city VALUES (94,'330500','湖州市','330000');  
INSERT INTO hat\_city VALUES (95,'330600','绍兴市','330000');  
INSERT INTO hat\_city VALUES (96,'330700','金华市','330000');  
INSERT INTO hat\_city VALUES (97,'330800','衢州市','330000');  
INSERT INTO hat\_city VALUES (98,'330900','舟山市','330000');  
INSERT INTO hat\_city VALUES (99,'331000','台州市','330000');  
INSERT INTO hat\_city VALUES (100,'331100','丽水市','330000');  
INSERT INTO hat\_city VALUES (101,'340100','合肥市','340000');  
INSERT INTO hat\_city VALUES (102,'340200','芜湖市','340000');  
INSERT INTO hat\_city VALUES (103,'340300','蚌埠市','340000');  
INSERT INTO hat\_city VALUES (104,'340400','淮南市','340000');  
INSERT INTO hat\_city VALUES (105,'340500','马鞍山市','340000');  
INSERT INTO hat\_city VALUES (106,'340600','淮北市','340000');  
INSERT INTO hat\_city VALUES (107,'340700','铜陵市','340000');  
INSERT INTO hat\_city VALUES (108,'340800','安庆市','340000');  
INSERT INTO hat\_city VALUES (109,'341000','黄山市','340000');  
INSERT INTO hat\_city VALUES (110,'341100','滁州市','340000');  
INSERT INTO hat\_city VALUES (111,'341200','阜阳市','340000');  
INSERT INTO hat\_city VALUES (112,'341300','宿州市','340000');  
INSERT INTO hat\_city VALUES (113,'341400','巢湖市','340000');  
INSERT INTO hat\_city VALUES (114,'341500','六安市','340000');  
INSERT INTO hat\_city VALUES (115,'341600','亳州市','340000');  
INSERT INTO hat\_city VALUES (116,'341700','池州市','340000');  
INSERT INTO hat\_city VALUES (117,'341800','宣城市','340000');  
INSERT INTO hat\_city VALUES (118,'350100','福州市','350000');  
INSERT INTO hat\_city VALUES (119,'350200','厦门市','350000');  
INSERT INTO hat\_city VALUES (120,'350300','莆田市','350000');  
INSERT INTO hat\_city VALUES (121,'350400','三明市','350000');  
INSERT INTO hat\_city VALUES (122,'350500','泉州市','350000');  
INSERT INTO hat\_city VALUES (123,'350600','漳州市','350000');  
INSERT INTO hat\_city VALUES (124,'350700','南平市','350000');  
INSERT INTO hat\_city VALUES (125,'350800','龙岩市','350000');  
INSERT INTO hat\_city VALUES (126,'350900','宁德市','350000');  
INSERT INTO hat\_city VALUES (127,'360100','南昌市','360000');  
INSERT INTO hat\_city VALUES (128,'360200','景德镇市','360000');  
INSERT INTO hat\_city VALUES (129,'360300','萍乡市','360000');  
INSERT INTO hat\_city VALUES (130,'360400','九江市','360000');  
INSERT INTO hat\_city VALUES (131,'360500','新余市','360000');  
INSERT INTO hat\_city VALUES (132,'360600','鹰潭市','360000');  
INSERT INTO hat\_city VALUES (133,'360700','赣州市','360000');  
INSERT INTO hat\_city VALUES (134,'360800','吉安市','360000');  
INSERT INTO hat\_city VALUES (135,'360900','宜春市','360000');  
INSERT INTO hat\_city VALUES (136,'361000','抚州市','360000');  
INSERT INTO hat\_city VALUES (137,'361100','上饶市','360000');  
INSERT INTO hat\_city VALUES (138,'370100','济南市','370000');  
INSERT INTO hat\_city VALUES (139,'370200','青岛市','370000');  
INSERT INTO hat\_city VALUES (140,'370300','淄博市','370000');  
INSERT INTO hat\_city VALUES (141,'370400','枣庄市','370000');  
INSERT INTO hat\_city VALUES (142,'370500','东营市','370000');  
INSERT INTO hat\_city VALUES (143,'370600','烟台市','370000');  
INSERT INTO hat\_city VALUES (144,'370700','潍坊市','370000');  
INSERT INTO hat\_city VALUES (145,'370800','济宁市','370000');  
INSERT INTO hat\_city VALUES (146,'370900','泰安市','370000');  
INSERT INTO hat\_city VALUES (147,'371000','威海市','370000');  
INSERT INTO hat\_city VALUES (148,'371100','日照市','370000');  
INSERT INTO hat\_city VALUES (149,'371200','莱芜市','370000');  
INSERT INTO hat\_city VALUES (150,'371300','临沂市','370000');  
INSERT INTO hat\_city VALUES (151,'371400','德州市','370000');  
INSERT INTO hat\_city VALUES (152,'371500','聊城市','370000');  
INSERT INTO hat\_city VALUES (153,'371600','滨州市','370000');  
INSERT INTO hat\_city VALUES (154,'371700','荷泽市','370000');  
INSERT INTO hat\_city VALUES (155,'410100','郑州市','410000');  
INSERT INTO hat\_city VALUES (156,'410200','开封市','410000');  
INSERT INTO hat\_city VALUES (157,'410300','洛阳市','410000');  
INSERT INTO hat\_city VALUES (158,'410400','平顶山市','410000');  
INSERT INTO hat\_city VALUES (159,'410500','安阳市','410000');  
INSERT INTO hat\_city VALUES (160,'410600','鹤壁市','410000');  
INSERT INTO hat\_city VALUES (161,'410700','新乡市','410000');  
INSERT INTO hat\_city VALUES (162,'410800','焦作市','410000');  
INSERT INTO hat\_city VALUES (163,'410900','濮阳市','410000');  
INSERT INTO hat\_city VALUES (164,'411000','许昌市','410000');  
INSERT INTO hat\_city VALUES (165,'411100','漯河市','410000');  
INSERT INTO hat\_city VALUES (166,'411200','三门峡市','410000');  
INSERT INTO hat\_city VALUES (167,'411300','南阳市','410000');  
INSERT INTO hat\_city VALUES (168,'411400','商丘市','410000');  
INSERT INTO hat\_city VALUES (169,'411500','信阳市','410000');  
INSERT INTO hat\_city VALUES (170,'411600','周口市','410000');  
INSERT INTO hat\_city VALUES (171,'411700','驻马店市','410000');  
INSERT INTO hat\_city VALUES (172,'420100','武汉市','420000');  
INSERT INTO hat\_city VALUES (173,'420200','黄石市','420000');  
INSERT INTO hat\_city VALUES (174,'420300','十堰市','420000');  
INSERT INTO hat\_city VALUES (175,'420500','宜昌市','420000');  
INSERT INTO hat\_city VALUES (176,'420600','襄樊市','420000');  
INSERT INTO hat\_city VALUES (177,'420700','鄂州市','420000');  
INSERT INTO hat\_city VALUES (178,'420800','荆门市','420000');  
INSERT INTO hat\_city VALUES (179,'420900','孝感市','420000');  
INSERT INTO hat\_city VALUES (180,'421000','荆州市','420000');  
INSERT INTO hat\_city VALUES (181,'421100','黄冈市','420000');  
INSERT INTO hat\_city VALUES (182,'421200','咸宁市','420000');  
INSERT INTO hat\_city VALUES (183,'421300','随州市','420000');  
INSERT INTO hat\_city VALUES (184,'422800','恩施土家族苗族自治州','420000');  
INSERT INTO hat\_city VALUES (185,'429000','省直辖行政单位','420000');  
INSERT INTO hat\_city VALUES (186,'430100','长沙市','430000');  
INSERT INTO hat\_city VALUES (187,'430200','株洲市','430000');  
INSERT INTO hat\_city VALUES (188,'430300','湘潭市','430000');  
INSERT INTO hat\_city VALUES (189,'430400','衡阳市','430000');  
INSERT INTO hat\_city VALUES (190,'430500','邵阳市','430000');  
INSERT INTO hat\_city VALUES (191,'430600','岳阳市','430000');  
INSERT INTO hat\_city VALUES (192,'430700','常德市','430000');  
INSERT INTO hat\_city VALUES (193,'430800','张家界市','430000');  
INSERT INTO hat\_city VALUES (194,'430900','益阳市','430000');  
INSERT INTO hat\_city VALUES (195,'431000','郴州市','430000');  
INSERT INTO hat\_city VALUES (196,'431100','永州市','430000');  
INSERT INTO hat\_city VALUES (197,'431200','怀化市','430000');  
INSERT INTO hat\_city VALUES (198,'431300','娄底市','430000');  
INSERT INTO hat\_city VALUES (199,'433100','湘西土家族苗族自治州','430000');  
INSERT INTO hat\_city VALUES (200,'440100','广州市','440000');  
INSERT INTO hat\_city VALUES (201,'440200','韶关市','440000');  
INSERT INTO hat\_city VALUES (202,'440300','深圳市','440000');  
INSERT INTO hat\_city VALUES (203,'440400','珠海市','440000');  
INSERT INTO hat\_city VALUES (204,'440500','汕头市','440000');  
INSERT INTO hat\_city VALUES (205,'440600','佛山市','440000');  
INSERT INTO hat\_city VALUES (206,'440700','江门市','440000');  
INSERT INTO hat\_city VALUES (207,'440800','湛江市','440000');  
INSERT INTO hat\_city VALUES (208,'440900','茂名市','440000');  
INSERT INTO hat\_city VALUES (209,'441200','肇庆市','440000');  
INSERT INTO hat\_city VALUES (210,'441300','惠州市','440000');  
INSERT INTO hat\_city VALUES (211,'441400','梅州市','440000');  
INSERT INTO hat\_city VALUES (212,'441500','汕尾市','440000');  
INSERT INTO hat\_city VALUES (213,'441600','河源市','440000');  
INSERT INTO hat\_city VALUES (214,'441700','阳江市','440000');  
INSERT INTO hat\_city VALUES (215,'441800','清远市','440000');  
INSERT INTO hat\_city VALUES (216,'441900','东莞市','440000');  
INSERT INTO hat\_city VALUES (217,'442000','中山市','440000');  
INSERT INTO hat\_city VALUES (218,'445100','潮州市','440000');  
INSERT INTO hat\_city VALUES (219,'445200','揭阳市','440000');  
INSERT INTO hat\_city VALUES (220,'445300','云浮市','440000');  
INSERT INTO hat\_city VALUES (221,'450100','南宁市','450000');  
INSERT INTO hat\_city VALUES (222,'450200','柳州市','450000');  
INSERT INTO hat\_city VALUES (223,'450300','桂林市','450000');  
INSERT INTO hat\_city VALUES (224,'450400','梧州市','450000');  
INSERT INTO hat\_city VALUES (225,'450500','北海市','450000');  
INSERT INTO hat\_city VALUES (226,'450600','防城港市','450000');  
INSERT INTO hat\_city VALUES (227,'450700','钦州市','450000');  
INSERT INTO hat\_city VALUES (228,'450800','贵港市','450000');  
INSERT INTO hat\_city VALUES (229,'450900','玉林市','450000');  
INSERT INTO hat\_city VALUES (230,'451000','百色市','450000');  
INSERT INTO hat\_city VALUES (231,'451100','贺州市','450000');  
INSERT INTO hat\_city VALUES (232,'451200','河池市','450000');  
INSERT INTO hat\_city VALUES (233,'451300','来宾市','450000');  
INSERT INTO hat\_city VALUES (234,'451400','崇左市','450000');  
INSERT INTO hat\_city VALUES (235,'460100','海口市','460000');  
INSERT INTO hat\_city VALUES (236,'460200','三亚市','460000');  
INSERT INTO hat\_city VALUES (237,'469000','省直辖县级行政单位','460000');  
INSERT INTO hat\_city VALUES (238,'500100','市辖区','500000');  
INSERT INTO hat\_city VALUES (239,'500200','县','500000');  
INSERT INTO hat\_city VALUES (240,'500300','市','500000');  
INSERT INTO hat\_city VALUES (241,'510100','成都市','510000');  
INSERT INTO hat\_city VALUES (242,'510300','自贡市','510000');  
INSERT INTO hat\_city VALUES (243,'510400','攀枝花市','510000');  
INSERT INTO hat\_city VALUES (244,'510500','泸州市','510000');  
INSERT INTO hat\_city VALUES (245,'510600','德阳市','510000');  
INSERT INTO hat\_city VALUES (246,'510700','绵阳市','510000');  
INSERT INTO hat\_city VALUES (247,'510800','广元市','510000');  
INSERT INTO hat\_city VALUES (248,'510900','遂宁市','510000');  
INSERT INTO hat\_city VALUES (249,'511000','内江市','510000');  
INSERT INTO hat\_city VALUES (250,'511100','乐山市','510000');  
INSERT INTO hat\_city VALUES (251,'511300','南充市','510000');  
INSERT INTO hat\_city VALUES (252,'511400','眉山市','510000');  
INSERT INTO hat\_city VALUES (253,'511500','宜宾市','510000');  
INSERT INTO hat\_city VALUES (254,'511600','广安市','510000');  
INSERT INTO hat\_city VALUES (255,'511700','达州市','510000');  
INSERT INTO hat\_city VALUES (256,'511800','雅安市','510000');  
INSERT INTO hat\_city VALUES (257,'511900','巴中市','510000');  
INSERT INTO hat\_city VALUES (258,'512000','资阳市','510000');  
INSERT INTO hat\_city VALUES (259,'513200','阿坝藏族羌族自治州','510000');  
INSERT INTO hat\_city VALUES (260,'513300','甘孜藏族自治州','510000');  
INSERT INTO hat\_city VALUES (261,'513400','凉山彝族自治州','510000');  
INSERT INTO hat\_city VALUES (262,'520100','贵阳市','520000');  
INSERT INTO hat\_city VALUES (263,'520200','六盘水市','520000');  
INSERT INTO hat\_city VALUES (264,'520300','遵义市','520000');  
INSERT INTO hat\_city VALUES (265,'520400','安顺市','520000');  
INSERT INTO hat\_city VALUES (266,'522200','铜仁地区','520000');  
INSERT INTO hat\_city VALUES (267,'522300','黔西南布依族苗族自治州','520000');  
INSERT INTO hat\_city VALUES (268,'522400','毕节地区','520000');  
INSERT INTO hat\_city VALUES (269,'522600','黔东南苗族侗族自治州','520000');  
INSERT INTO hat\_city VALUES (270,'522700','黔南布依族苗族自治州','520000');  
INSERT INTO hat\_city VALUES (271,'530100','昆明市','530000');  
INSERT INTO hat\_city VALUES (272,'530300','曲靖市','530000');  
INSERT INTO hat\_city VALUES (273,'530400','玉溪市','530000');  
INSERT INTO hat\_city VALUES (274,'530500','保山市','530000');  
INSERT INTO hat\_city VALUES (275,'530600','昭通市','530000');  
INSERT INTO hat\_city VALUES (276,'530700','丽江市','530000');  
INSERT INTO hat\_city VALUES (277,'530800','思茅市','530000');  
INSERT INTO hat\_city VALUES (278,'530900','临沧市','530000');  
INSERT INTO hat\_city VALUES (279,'532300','楚雄彝族自治州','530000');  
INSERT INTO hat\_city VALUES (280,'532500','红河哈尼族彝族自治州','530000');  
INSERT INTO hat\_city VALUES (281,'532600','文山壮族苗族自治州','530000');  
INSERT INTO hat\_city VALUES (282,'532800','西双版纳傣族自治州','530000');  
INSERT INTO hat\_city VALUES (283,'532900','大理白族自治州','530000');  
INSERT INTO hat\_city VALUES (284,'533100','德宏傣族景颇族自治州','530000');  
INSERT INTO hat\_city VALUES (285,'533300','怒江傈僳族自治州','530000');  
INSERT INTO hat\_city VALUES (286,'533400','迪庆藏族自治州','530000');  
INSERT INTO hat\_city VALUES (287,'540100','拉萨市','540000');  
INSERT INTO hat\_city VALUES (288,'542100','昌都地区','540000');  
INSERT INTO hat\_city VALUES (289,'542200','山南地区','540000');  
INSERT INTO hat\_city VALUES (290,'542300','日喀则地区','540000');  
INSERT INTO hat\_city VALUES (291,'542400','那曲地区','540000');  
INSERT INTO hat\_city VALUES (292,'542500','阿里地区','540000');  
INSERT INTO hat\_city VALUES (293,'542600','林芝地区','540000');  
INSERT INTO hat\_city VALUES (294,'610100','西安市','610000');  
INSERT INTO hat\_city VALUES (295,'610200','铜川市','610000');  
INSERT INTO hat\_city VALUES (296,'610300','宝鸡市','610000');  
INSERT INTO hat\_city VALUES (297,'610400','咸阳市','610000');  
INSERT INTO hat\_city VALUES (298,'610500','渭南市','610000');  
INSERT INTO hat\_city VALUES (299,'610600','延安市','610000');  
INSERT INTO hat\_city VALUES (300,'610700','汉中市','610000');  
INSERT INTO hat\_city VALUES (301,'610800','榆林市','610000');  
INSERT INTO hat\_city VALUES (302,'610900','安康市','610000');  
INSERT INTO hat\_city VALUES (303,'611000','商洛市','610000');  
INSERT INTO hat\_city VALUES (304,'620100','兰州市','620000');  
INSERT INTO hat\_city VALUES (305,'620200','嘉峪关市','620000');  
INSERT INTO hat\_city VALUES (306,'620300','金昌市','620000');  
INSERT INTO hat\_city VALUES (307,'620400','白银市','620000');  
INSERT INTO hat\_city VALUES (308,'620500','天水市','620000');  
INSERT INTO hat\_city VALUES (309,'620600','武威市','620000');  
INSERT INTO hat\_city VALUES (310,'620700','张掖市','620000');  
INSERT INTO hat\_city VALUES (311,'620800','平凉市','620000');  
INSERT INTO hat\_city VALUES (312,'620900','酒泉市','620000');  
INSERT INTO hat\_city VALUES (313,'621000','庆阳市','620000');  
INSERT INTO hat\_city VALUES (314,'621100','定西市','620000');  
INSERT INTO hat\_city VALUES (315,'621200','陇南市','620000');  
INSERT INTO hat\_city VALUES (316,'622900','临夏回族自治州','620000');  
INSERT INTO hat\_city VALUES (317,'623000','甘南藏族自治州','620000');  
INSERT INTO hat\_city VALUES (318,'630100','西宁市','630000');  
INSERT INTO hat\_city VALUES (319,'632100','海东地区','630000');  
INSERT INTO hat\_city VALUES (320,'632200','海北藏族自治州','630000');  
INSERT INTO hat\_city VALUES (321,'632300','黄南藏族自治州','630000');  
INSERT INTO hat\_city VALUES (322,'632500','海南藏族自治州','630000');  
INSERT INTO hat\_city VALUES (323,'632600','果洛藏族自治州','630000');  
INSERT INTO hat\_city VALUES (324,'632700','玉树藏族自治州','630000');  
INSERT INTO hat\_city VALUES (325,'632800','海西蒙古族藏族自治州','630000');  
INSERT INTO hat\_city VALUES (326,'640100','银川市','640000');  
INSERT INTO hat\_city VALUES (327,'640200','石嘴山市','640000');  
INSERT INTO hat\_city VALUES (328,'640300','吴忠市','640000');  
INSERT INTO hat\_city VALUES (329,'640400','固原市','640000');  
INSERT INTO hat\_city VALUES (330,'640500','中卫市','640000');  
INSERT INTO hat\_city VALUES (331,'650100','乌鲁木齐市','650000');  
INSERT INTO hat\_city VALUES (332,'650200','克拉玛依市','650000');  
INSERT INTO hat\_city VALUES (333,'652100','吐鲁番地区','650000');  
INSERT INTO hat\_city VALUES (334,'652200','哈密地区','650000');  
INSERT INTO hat\_city VALUES (335,'652300','昌吉回族自治州','650000');  
INSERT INTO hat\_city VALUES (336,'652700','博尔塔拉蒙古自治州','650000');  
INSERT INTO hat\_city VALUES (337,'652800','巴音郭楞蒙古自治州','650000');  
INSERT INTO hat\_city VALUES (338,'652900','阿克苏地区','650000');  
INSERT INTO hat\_city VALUES (339,'653000','克孜勒苏柯尔克孜自治州','650000');  
INSERT INTO hat\_city VALUES (340,'653100','喀什地区','650000');  
INSERT INTO hat\_city VALUES (341,'653200','和田地区','650000');  
INSERT INTO hat\_city VALUES (342,'654000','伊犁哈萨克自治州','650000');  
INSERT INTO hat\_city VALUES (343,'654200','塔城地区','650000');  
INSERT INTO hat\_city VALUES (344,'654300','阿勒泰地区','650000');  
INSERT INTO hat\_city VALUES (345,'659000','省直辖行政单位','650000');

CREATE TABLE hat\_area (  
rid int(11) NOT NULL,  
areaID varchar(50) default NULL,  
area varchar(60) default NULL,  
father varchar(6) default NULL,  
primary key(rid)  
);

INSERT INTO hat\_area VALUES (1,'110101','东城区','110100');  
INSERT INTO hat\_area VALUES (2,'110102','西城区','110100');  
INSERT INTO hat\_area VALUES (3,'110103','崇文区','110100');  
INSERT INTO hat\_area VALUES (4,'110104','宣武区','110100');  
INSERT INTO hat\_area VALUES (5,'110105','朝阳区','110100');  
INSERT INTO hat\_area VALUES (6,'110106','丰台区','110100');  
INSERT INTO hat\_area VALUES (7,'110107','石景山区','110100');  
INSERT INTO hat\_area VALUES (8,'110108','海淀区','110100');  
INSERT INTO hat\_area VALUES (9,'110109','门头沟区','110100');  
INSERT INTO hat\_area VALUES (10,'110111','房山区','110100');  
INSERT INTO hat\_area VALUES (11,'110112','通州区','110100');  
INSERT INTO hat\_area VALUES (12,'110113','顺义区','110100');  
INSERT INTO hat\_area VALUES (13,'110114','昌平区','110100');  
INSERT INTO hat\_area VALUES (14,'110115','大兴区','110100');  
INSERT INTO hat\_area VALUES (15,'110116','怀柔区','110100');  
INSERT INTO hat\_area VALUES (16,'110117','平谷区','110100');  
INSERT INTO hat\_area VALUES (17,'110228','密云县','110200');  
INSERT INTO hat\_area VALUES (18,'110229','延庆县','110200');  
INSERT INTO hat\_area VALUES (19,'120101','和平区','120100');  
INSERT INTO hat\_area VALUES (20,'120102','河东区','120100');  
INSERT INTO hat\_area VALUES (21,'120103','河西区','120100');  
INSERT INTO hat\_area VALUES (22,'120104','南开区','120100');  
INSERT INTO hat\_area VALUES (23,'120105','河北区','120100');  
INSERT INTO hat\_area VALUES (24,'120106','红桥区','120100');  
INSERT INTO hat\_area VALUES (25,'120107','塘沽区','120100');  
INSERT INTO hat\_area VALUES (26,'120108','汉沽区','120100');  
INSERT INTO hat\_area VALUES (27,'120109','大港区','120100');  
INSERT INTO hat\_area VALUES (28,'120110','东丽区','120100');  
INSERT INTO hat\_area VALUES (29,'120111','西青区','120100');  
INSERT INTO hat\_area VALUES (30,'120112','津南区','120100');  
INSERT INTO hat\_area VALUES (31,'120113','北辰区','120100');  
INSERT INTO hat\_area VALUES (32,'120114','武清区','120100');  
INSERT INTO hat\_area VALUES (33,'120115','宝坻区','120100');  
INSERT INTO hat\_area VALUES (34,'120221','宁河县','120200');  
INSERT INTO hat\_area VALUES (35,'120223','静海县','120200');  
INSERT INTO hat\_area VALUES (36,'120225','蓟　县','120200');  
INSERT INTO hat\_area VALUES (37,'130101','市辖区','130100');  
INSERT INTO hat\_area VALUES (38,'130102','长安区','130100');  
INSERT INTO hat\_area VALUES (39,'130103','桥东区','130100');  
INSERT INTO hat\_area VALUES (40,'130104','桥西区','130100');  
INSERT INTO hat\_area VALUES (41,'130105','新华区','130100');  
INSERT INTO hat\_area VALUES (42,'130107','井陉矿区','130100');  
INSERT INTO hat\_area VALUES (43,'130108','裕华区','130100');  
INSERT INTO hat\_area VALUES (44,'130121','井陉县','130100');  
INSERT INTO hat\_area VALUES (45,'130123','正定县','130100');  
INSERT INTO hat\_area VALUES (46,'130124','栾城县','130100');  
INSERT INTO hat\_area VALUES (47,'130125','行唐县','130100');  
INSERT INTO hat\_area VALUES (48,'130126','灵寿县','130100');  
INSERT INTO hat\_area VALUES (49,'130127','高邑县','130100');  
INSERT INTO hat\_area VALUES (50,'130128','深泽县','130100');  
INSERT INTO hat\_area VALUES (51,'130129','赞皇县','130100');  
INSERT INTO hat\_area VALUES (52,'130130','无极县','130100');  
INSERT INTO hat\_area VALUES (53,'130131','平山县','130100');  
INSERT INTO hat\_area VALUES (54,'130132','元氏县','130100');  
INSERT INTO hat\_area VALUES (55,'130133','赵　县','130100');  
INSERT INTO hat\_area VALUES (56,'130181','辛集市','130100');  
INSERT INTO hat\_area VALUES (57,'130182','藁城市','130100');  
INSERT INTO hat\_area VALUES (58,'130183','晋州市','130100');  
INSERT INTO hat\_area VALUES (59,'130184','新乐市','130100');  
INSERT INTO hat\_area VALUES (60,'130185','鹿泉市','130100');  
INSERT INTO hat\_area VALUES (61,'130201','市辖区','130200');  
INSERT INTO hat\_area VALUES (62,'130202','路南区','130200');  
INSERT INTO hat\_area VALUES (63,'130203','路北区','130200');  
INSERT INTO hat\_area VALUES (64,'130204','古冶区','130200');  
INSERT INTO hat\_area VALUES (65,'130205','开平区','130200');  
INSERT INTO hat\_area VALUES (66,'130207','丰南区','130200');  
INSERT INTO hat\_area VALUES (67,'130208','丰润区','130200');  
INSERT INTO hat\_area VALUES (68,'130223','滦　县','130200');  
INSERT INTO hat\_area VALUES (69,'130224','滦南县','130200');  
INSERT INTO hat\_area VALUES (70,'130225','乐亭县','130200');  
INSERT INTO hat\_area VALUES (71,'130227','迁西县','130200');  
INSERT INTO hat\_area VALUES (72,'130229','玉田县','130200');  
INSERT INTO hat\_area VALUES (73,'130230','唐海县','130200');  
INSERT INTO hat\_area VALUES (74,'130281','遵化市','130200');  
INSERT INTO hat\_area VALUES (75,'130283','迁安市','130200');  
INSERT INTO hat\_area VALUES (76,'130301','市辖区','130300');  
INSERT INTO hat\_area VALUES (77,'130302','海港区','130300');  
INSERT INTO hat\_area VALUES (78,'130303','山海关区','130300');  
INSERT INTO hat\_area VALUES (79,'130304','北戴河区','130300');  
INSERT INTO hat\_area VALUES (80,'130321','青龙满族自治县','130300');  
INSERT INTO hat\_area VALUES (81,'130322','昌黎县','130300');  
INSERT INTO hat\_area VALUES (82,'130323','抚宁县','130300');  
INSERT INTO hat\_area VALUES (83,'130324','卢龙县','130300');  
INSERT INTO hat\_area VALUES (84,'130401','市辖区','130400');  
INSERT INTO hat\_area VALUES (85,'130402','邯山区','130400');  
INSERT INTO hat\_area VALUES (86,'130403','丛台区','130400');  
INSERT INTO hat\_area VALUES (87,'130404','复兴区','130400');  
INSERT INTO hat\_area VALUES (88,'130406','峰峰矿区','130400');  
INSERT INTO hat\_area VALUES (89,'130421','邯郸县','130400');  
INSERT INTO hat\_area VALUES (90,'130423','临漳县','130400');  
INSERT INTO hat\_area VALUES (91,'130424','成安县','130400');  
INSERT INTO hat\_area VALUES (92,'130425','大名县','130400');  
INSERT INTO hat\_area VALUES (93,'130426','涉　县','130400');  
INSERT INTO hat\_area VALUES (94,'130427','磁　县','130400');  
INSERT INTO hat\_area VALUES (95,'130428','肥乡县','130400');  
INSERT INTO hat\_area VALUES (96,'130429','永年县','130400');  
INSERT INTO hat\_area VALUES (97,'130430','邱　县','130400');  
INSERT INTO hat\_area VALUES (98,'130431','鸡泽县','130400');  
INSERT INTO hat\_area VALUES (99,'130432','广平县','130400');  
INSERT INTO hat\_area VALUES (100,'130433','馆陶县','130400');  
INSERT INTO hat\_area VALUES (101,'130434','魏　县','130400');  
INSERT INTO hat\_area VALUES (102,'130435','曲周县','130400');  
INSERT INTO hat\_area VALUES (103,'130481','武安市','130400');  
INSERT INTO hat\_area VALUES (104,'130501','市辖区','130500');  
INSERT INTO hat\_area VALUES (105,'130502','桥东区','130500');  
INSERT INTO hat\_area VALUES (106,'130503','桥西区','130500');  
INSERT INTO hat\_area VALUES (107,'130521','邢台县','130500');  
INSERT INTO hat\_area VALUES (108,'130522','临城县','130500');  
INSERT INTO hat\_area VALUES (109,'130523','内丘县','130500');  
INSERT INTO hat\_area VALUES (110,'130524','柏乡县','130500');  
INSERT INTO hat\_area VALUES (111,'130525','隆尧县','130500');  
INSERT INTO hat\_area VALUES (112,'130526','任　县','130500');  
INSERT INTO hat\_area VALUES (113,'130527','南和县','130500');  
INSERT INTO hat\_area VALUES (114,'130528','宁晋县','130500');  
INSERT INTO hat\_area VALUES (115,'130529','巨鹿县','130500');  
INSERT INTO hat\_area VALUES (116,'130530','新河县','130500');  
INSERT INTO hat\_area VALUES (117,'130531','广宗县','130500');  
INSERT INTO hat\_area VALUES (118,'130532','平乡县','130500');  
INSERT INTO hat\_area VALUES (119,'130533','威　县','130500');  
INSERT INTO hat\_area VALUES (120,'130534','清河县','130500');  
INSERT INTO hat\_area VALUES (121,'130535','临西县','130500');  
INSERT INTO hat\_area VALUES (122,'130581','南宫市','130500');  
INSERT INTO hat\_area VALUES (123,'130582','沙河市','130500');  
INSERT INTO hat\_area VALUES (124,'130601','市辖区','130600');  
INSERT INTO hat\_area VALUES (125,'130602','新市区','130600');  
INSERT INTO hat\_area VALUES (126,'130603','北市区','130600');  
INSERT INTO hat\_area VALUES (127,'130604','南市区','130600');  
INSERT INTO hat\_area VALUES (128,'130621','满城县','130600');  
INSERT INTO hat\_area VALUES (129,'130622','清苑县','130600');  
INSERT INTO hat\_area VALUES (130,'130623','涞水县','130600');  
INSERT INTO hat\_area VALUES (131,'130624','阜平县','130600');  
INSERT INTO hat\_area VALUES (132,'130625','徐水县','130600');  
INSERT INTO hat\_area VALUES (133,'130626','定兴县','130600');  
INSERT INTO hat\_area VALUES (134,'130627','唐　县','130600');  
INSERT INTO hat\_area VALUES (135,'130628','高阳县','130600');  
INSERT INTO hat\_area VALUES (136,'130629','容城县','130600');  
INSERT INTO hat\_area VALUES (137,'130630','涞源县','130600');  
INSERT INTO hat\_area VALUES (138,'130631','望都县','130600');  
INSERT INTO hat\_area VALUES (139,'130632','安新县','130600');  
INSERT INTO hat\_area VALUES (140,'130633','易　县','130600');  
INSERT INTO hat\_area VALUES (141,'130634','曲阳县','130600');  
INSERT INTO hat\_area VALUES (142,'130635','蠡　县','130600');  
INSERT INTO hat\_area VALUES (143,'130636','顺平县','130600');  
INSERT INTO hat\_area VALUES (144,'130637','博野县','130600');  
INSERT INTO hat\_area VALUES (145,'130638','雄　县','130600');  
INSERT INTO hat\_area VALUES (146,'130681','涿州市','130600');  
INSERT INTO hat\_area VALUES (147,'130682','定州市','130600');  
INSERT INTO hat\_area VALUES (148,'130683','安国市','130600');  
INSERT INTO hat\_area VALUES (149,'130684','高碑店市','130600');  
INSERT INTO hat\_area VALUES (150,'130701','市辖区','130700');  
INSERT INTO hat\_area VALUES (151,'130702','桥东区','130700');  
INSERT INTO hat\_area VALUES (152,'130703','桥西区','130700');  
INSERT INTO hat\_area VALUES (153,'130705','宣化区','130700');  
INSERT INTO hat\_area VALUES (154,'130706','下花园区','130700');  
INSERT INTO hat\_area VALUES (155,'130721','宣化县','130700');  
INSERT INTO hat\_area VALUES (156,'130722','张北县','130700');  
INSERT INTO hat\_area VALUES (157,'130723','康保县','130700');  
INSERT INTO hat\_area VALUES (158,'130724','沽源县','130700');  
INSERT INTO hat\_area VALUES (159,'130725','尚义县','130700');  
INSERT INTO hat\_area VALUES (160,'130726','蔚　县','130700');  
INSERT INTO hat\_area VALUES (161,'130727','阳原县','130700');  
INSERT INTO hat\_area VALUES (162,'130728','怀安县','130700');  
INSERT INTO hat\_area VALUES (163,'130729','万全县','130700');  
INSERT INTO hat\_area VALUES (164,'130730','怀来县','130700');  
INSERT INTO hat\_area VALUES (165,'130731','涿鹿县','130700');  
INSERT INTO hat\_area VALUES (166,'130732','赤城县','130700');  
INSERT INTO hat\_area VALUES (167,'130733','崇礼县','130700');  
INSERT INTO hat\_area VALUES (168,'130801','市辖区','130800');  
INSERT INTO hat\_area VALUES (169,'130802','双桥区','130800');  
INSERT INTO hat\_area VALUES (170,'130803','双滦区','130800');  
INSERT INTO hat\_area VALUES (171,'130804','鹰手营子矿区','130800');  
INSERT INTO hat\_area VALUES (172,'130821','承德县','130800');  
INSERT INTO hat\_area VALUES (173,'130822','兴隆县','130800');  
INSERT INTO hat\_area VALUES (174,'130823','平泉县','130800');  
INSERT INTO hat\_area VALUES (175,'130824','滦平县','130800');  
INSERT INTO hat\_area VALUES (176,'130825','隆化县','130800');  
INSERT INTO hat\_area VALUES (177,'130826','丰宁满族自治县','130800');  
INSERT INTO hat\_area VALUES (178,'130827','宽城满族自治县','130800');  
INSERT INTO hat\_area VALUES (179,'130828','围场满族蒙古族自治县','130800');  
INSERT INTO hat\_area VALUES (180,'130901','市辖区','130900');  
INSERT INTO hat\_area VALUES (181,'130902','新华区','130900');  
INSERT INTO hat\_area VALUES (182,'130903','运河区','130900');  
INSERT INTO hat\_area VALUES (183,'130921','沧　县','130900');  
INSERT INTO hat\_area VALUES (184,'130922','青　县','130900');  
INSERT INTO hat\_area VALUES (185,'130923','东光县','130900');  
INSERT INTO hat\_area VALUES (186,'130924','海兴县','130900');  
INSERT INTO hat\_area VALUES (187,'130925','盐山县','130900');  
INSERT INTO hat\_area VALUES (188,'130926','肃宁县','130900');  
INSERT INTO hat\_area VALUES (189,'130927','南皮县','130900');  
INSERT INTO hat\_area VALUES (190,'130928','吴桥县','130900');  
INSERT INTO hat\_area VALUES (191,'130929','献　县','130900');  
INSERT INTO hat\_area VALUES (192,'130930','孟村回族自治县','130900');  
INSERT INTO hat\_area VALUES (193,'130981','泊头市','130900');  
INSERT INTO hat\_area VALUES (194,'130982','任丘市','130900');  
INSERT INTO hat\_area VALUES (195,'130983','黄骅市','130900');  
INSERT INTO hat\_area VALUES (196,'130984','河间市','130900');  
INSERT INTO hat\_area VALUES (197,'131001','市辖区','131000');  
INSERT INTO hat\_area VALUES (198,'131002','安次区','131000');  
INSERT INTO hat\_area VALUES (199,'131003','广阳区','131000');  
INSERT INTO hat\_area VALUES (200,'131022','固安县','131000');  
INSERT INTO hat\_area VALUES (201,'131023','永清县','131000');  
INSERT INTO hat\_area VALUES (202,'131024','香河县','131000');  
INSERT INTO hat\_area VALUES (203,'131025','大城县','131000');  
INSERT INTO hat\_area VALUES (204,'131026','文安县','131000');  
INSERT INTO hat\_area VALUES (205,'131028','大厂回族自治县','131000');  
INSERT INTO hat\_area VALUES (206,'131081','霸州市','131000');  
INSERT INTO hat\_area VALUES (207,'131082','三河市','131000');  
INSERT INTO hat\_area VALUES (208,'131101','市辖区','131100');  
INSERT INTO hat\_area VALUES (209,'131102','桃城区','131100');  
INSERT INTO hat\_area VALUES (210,'131121','枣强县','131100');  
INSERT INTO hat\_area VALUES (211,'131122','武邑县','131100');  
INSERT INTO hat\_area VALUES (212,'131123','武强县','131100');  
INSERT INTO hat\_area VALUES (213,'131124','饶阳县','131100');  
INSERT INTO hat\_area VALUES (214,'131125','安平县','131100');  
INSERT INTO hat\_area VALUES (215,'131126','故城县','131100');  
INSERT INTO hat\_area VALUES (216,'131127','景　县','131100');  
INSERT INTO hat\_area VALUES (217,'131128','阜城县','131100');  
INSERT INTO hat\_area VALUES (218,'131181','冀州市','131100');  
INSERT INTO hat\_area VALUES (219,'131182','深州市','131100');  
INSERT INTO hat\_area VALUES (220,'140101','市辖区','140100');  
INSERT INTO hat\_area VALUES (221,'140105','小店区','140100');  
INSERT INTO hat\_area VALUES (222,'140106','迎泽区','140100');  
INSERT INTO hat\_area VALUES (223,'140107','杏花岭区','140100');  
INSERT INTO hat\_area VALUES (224,'140108','尖草坪区','140100');  
INSERT INTO hat\_area VALUES (225,'140109','万柏林区','140100');  
INSERT INTO hat\_area VALUES (226,'140110','晋源区','140100');  
INSERT INTO hat\_area VALUES (227,'140121','清徐县','140100');  
INSERT INTO hat\_area VALUES (228,'140122','阳曲县','140100');  
INSERT INTO hat\_area VALUES (229,'140123','娄烦县','140100');  
INSERT INTO hat\_area VALUES (230,'140181','古交市','140100');  
INSERT INTO hat\_area VALUES (231,'140201','市辖区','140200');  
INSERT INTO hat\_area VALUES (232,'140202','城　区','140200');  
INSERT INTO hat\_area VALUES (233,'140203','矿　区','140200');  
INSERT INTO hat\_area VALUES (234,'140211','南郊区','140200');  
INSERT INTO hat\_area VALUES (235,'140212','新荣区','140200');  
INSERT INTO hat\_area VALUES (236,'140221','阳高县','140200');  
INSERT INTO hat\_area VALUES (237,'140222','天镇县','140200');  
INSERT INTO hat\_area VALUES (238,'140223','广灵县','140200');  
INSERT INTO hat\_area VALUES (239,'140224','灵丘县','140200');  
INSERT INTO hat\_area VALUES (240,'140225','浑源县','140200');  
INSERT INTO hat\_area VALUES (241,'140226','左云县','140200');  
INSERT INTO hat\_area VALUES (242,'140227','大同县','140200');  
INSERT INTO hat\_area VALUES (243,'140301','市辖区','140300');  
INSERT INTO hat\_area VALUES (244,'140302','城　区','140300');  
INSERT INTO hat\_area VALUES (245,'140303','矿　区','140300');  
INSERT INTO hat\_area VALUES (246,'140311','郊　区','140300');  
INSERT INTO hat\_area VALUES (247,'140321','平定县','140300');  
INSERT INTO hat\_area VALUES (248,'140322','盂　县','140300');  
INSERT INTO hat\_area VALUES (249,'140401','市辖区','140400');  
INSERT INTO hat\_area VALUES (250,'140402','城　区','140400');  
INSERT INTO hat\_area VALUES (251,'140411','郊　区','140400');  
INSERT INTO hat\_area VALUES (252,'140421','长治县','140400');  
INSERT INTO hat\_area VALUES (253,'140423','襄垣县','140400');  
INSERT INTO hat\_area VALUES (254,'140424','屯留县','140400');  
INSERT INTO hat\_area VALUES (255,'140425','平顺县','140400');  
INSERT INTO hat\_area VALUES (256,'140426','黎城县','140400');  
INSERT INTO hat\_area VALUES (257,'140427','壶关县','140400');  
INSERT INTO hat\_area VALUES (258,'140428','长子县','140400');  
INSERT INTO hat\_area VALUES (259,'140429','武乡县','140400');  
INSERT INTO hat\_area VALUES (260,'140430','沁　县','140400');  
INSERT INTO hat\_area VALUES (261,'140431','沁源县','140400');  
INSERT INTO hat\_area VALUES (262,'140481','潞城市','140400');  
INSERT INTO hat\_area VALUES (263,'140501','市辖区','140500');  
INSERT INTO hat\_area VALUES (264,'140502','城　区','140500');  
INSERT INTO hat\_area VALUES (265,'140521','沁水县','140500');  
INSERT INTO hat\_area VALUES (266,'140522','阳城县','140500');  
INSERT INTO hat\_area VALUES (267,'140524','陵川县','140500');  
INSERT INTO hat\_area VALUES (268,'140525','泽州县','140500');  
INSERT INTO hat\_area VALUES (269,'140581','高平市','140500');  
INSERT INTO hat\_area VALUES (270,'140601','市辖区','140600');  
INSERT INTO hat\_area VALUES (271,'140602','朔城区','140600');  
INSERT INTO hat\_area VALUES (272,'140603','平鲁区','140600');  
INSERT INTO hat\_area VALUES (273,'140621','山阴县','140600');  
INSERT INTO hat\_area VALUES (274,'140622','应　县','140600');  
INSERT INTO hat\_area VALUES (275,'140623','右玉县','140600');  
INSERT INTO hat\_area VALUES (276,'140624','怀仁县','140600');  
INSERT INTO hat\_area VALUES (277,'140701','市辖区','140700');  
INSERT INTO hat\_area VALUES (278,'140702','榆次区','140700');  
INSERT INTO hat\_area VALUES (279,'140721','榆社县','140700');  
INSERT INTO hat\_area VALUES (280,'140722','左权县','140700');  
INSERT INTO hat\_area VALUES (281,'140723','和顺县','140700');  
INSERT INTO hat\_area VALUES (282,'140724','昔阳县','140700');  
INSERT INTO hat\_area VALUES (283,'140725','寿阳县','140700');  
INSERT INTO hat\_area VALUES (284,'140726','太谷县','140700');  
INSERT INTO hat\_area VALUES (285,'140727','祁　县','140700');  
INSERT INTO hat\_area VALUES (286,'140728','平遥县','140700');  
INSERT INTO hat\_area VALUES (287,'140729','灵石县','140700');  
INSERT INTO hat\_area VALUES (288,'140781','介休市','140700');  
INSERT INTO hat\_area VALUES (289,'140801','市辖区','140800');  
INSERT INTO hat\_area VALUES (290,'140802','盐湖区','140800');  
INSERT INTO hat\_area VALUES (291,'140821','临猗县','140800');  
INSERT INTO hat\_area VALUES (292,'140822','万荣县','140800');  
INSERT INTO hat\_area VALUES (293,'140823','闻喜县','140800');  
INSERT INTO hat\_area VALUES (294,'140824','稷山县','140800');  
INSERT INTO hat\_area VALUES (295,'140825','新绛县','140800');  
INSERT INTO hat\_area VALUES (296,'140826','绛　县','140800');  
INSERT INTO hat\_area VALUES (297,'140827','垣曲县','140800');  
INSERT INTO hat\_area VALUES (298,'140828','夏　县','140800');  
INSERT INTO hat\_area VALUES (299,'140829','平陆县','140800');  
INSERT INTO hat\_area VALUES (300,'140830','芮城县','140800');  
INSERT INTO hat\_area VALUES (301,'140881','永济市','140800');  
INSERT INTO hat\_area VALUES (302,'140882','河津市','140800');  
INSERT INTO hat\_area VALUES (303,'140901','市辖区','140900');  
INSERT INTO hat\_area VALUES (304,'140902','忻府区','140900');  
INSERT INTO hat\_area VALUES (305,'140921','定襄县','140900');  
INSERT INTO hat\_area VALUES (306,'140922','五台县','140900');  
INSERT INTO hat\_area VALUES (307,'140923','代　县','140900');  
INSERT INTO hat\_area VALUES (308,'140924','繁峙县','140900');  
INSERT INTO hat\_area VALUES (309,'140925','宁武县','140900');  
INSERT INTO hat\_area VALUES (310,'140926','静乐县','140900');  
INSERT INTO hat\_area VALUES (311,'140927','神池县','140900');  
INSERT INTO hat\_area VALUES (312,'140928','五寨县','140900');  
INSERT INTO hat\_area VALUES (313,'140929','岢岚县','140900');  
INSERT INTO hat\_area VALUES (314,'140930','河曲县','140900');  
INSERT INTO hat\_area VALUES (315,'140931','保德县','140900');  
INSERT INTO hat\_area VALUES (316,'140932','偏关县','140900');  
INSERT INTO hat\_area VALUES (317,'140981','原平市','140900');  
INSERT INTO hat\_area VALUES (318,'141001','市辖区','141000');  
INSERT INTO hat\_area VALUES (319,'141002','尧都区','141000');  
INSERT INTO hat\_area VALUES (320,'141021','曲沃县','141000');  
INSERT INTO hat\_area VALUES (321,'141022','翼城县','141000');  
INSERT INTO hat\_area VALUES (322,'141023','襄汾县','141000');  
INSERT INTO hat\_area VALUES (323,'141024','洪洞县','141000');  
INSERT INTO hat\_area VALUES (324,'141025','古　县','141000');  
INSERT INTO hat\_area VALUES (325,'141026','安泽县','141000');  
INSERT INTO hat\_area VALUES (326,'141027','浮山县','141000');  
INSERT INTO hat\_area VALUES (327,'141028','吉　县','141000');  
INSERT INTO hat\_area VALUES (328,'141029','乡宁县','141000');  
INSERT INTO hat\_area VALUES (329,'141030','大宁县','141000');  
INSERT INTO hat\_area VALUES (330,'141031','隰　县','141000');  
INSERT INTO hat\_area VALUES (331,'141032','永和县','141000');  
INSERT INTO hat\_area VALUES (332,'141033','蒲　县','141000');  
INSERT INTO hat\_area VALUES (333,'141034','汾西县','141000');  
INSERT INTO hat\_area VALUES (334,'141081','侯马市','141000');  
INSERT INTO hat\_area VALUES (335,'141082','霍州市','141000');  
INSERT INTO hat\_area VALUES (336,'141101','市辖区','141100');  
INSERT INTO hat\_area VALUES (337,'141102','离石区','141100');  
INSERT INTO hat\_area VALUES (338,'141121','文水县','141100');  
INSERT INTO hat\_area VALUES (339,'141122','交城县','141100');  
INSERT INTO hat\_area VALUES (340,'141123','兴　县','141100');  
INSERT INTO hat\_area VALUES (341,'141124','临　县','141100');  
INSERT INTO hat\_area VALUES (342,'141125','柳林县','141100');  
INSERT INTO hat\_area VALUES (343,'141126','石楼县','141100');  
INSERT INTO hat\_area VALUES (344,'141127','岚　县','141100');  
INSERT INTO hat\_area VALUES (345,'141128','方山县','141100');  
INSERT INTO hat\_area VALUES (346,'141129','中阳县','141100');  
INSERT INTO hat\_area VALUES (347,'141130','交口县','141100');  
INSERT INTO hat\_area VALUES (348,'141181','孝义市','141100');  
INSERT INTO hat\_area VALUES (349,'141182','汾阳市','141100');  
INSERT INTO hat\_area VALUES (350,'150101','市辖区','150100');  
INSERT INTO hat\_area VALUES (351,'150102','新城区','150100');  
INSERT INTO hat\_area VALUES (352,'150103','回民区','150100');  
INSERT INTO hat\_area VALUES (353,'150104','玉泉区','150100');  
INSERT INTO hat\_area VALUES (354,'150105','赛罕区','150100');  
INSERT INTO hat\_area VALUES (355,'150121','土默特左旗','150100');  
INSERT INTO hat\_area VALUES (356,'150122','托克托县','150100');  
INSERT INTO hat\_area VALUES (357,'150123','和林格尔县','150100');  
INSERT INTO hat\_area VALUES (358,'150124','清水河县','150100');  
INSERT INTO hat\_area VALUES (359,'150125','武川县','150100');  
INSERT INTO hat\_area VALUES (360,'150201','市辖区','150200');  
INSERT INTO hat\_area VALUES (361,'150202','东河区','150200');  
INSERT INTO hat\_area VALUES (362,'150203','昆都仑区','150200');  
INSERT INTO hat\_area VALUES (363,'150204','青山区','150200');  
INSERT INTO hat\_area VALUES (364,'150205','石拐区','150200');  
INSERT INTO hat\_area VALUES (365,'150206','白云矿区','150200');  
INSERT INTO hat\_area VALUES (366,'150207','九原区','150200');  
INSERT INTO hat\_area VALUES (367,'150221','土默特右旗','150200');  
INSERT INTO hat\_area VALUES (368,'150222','固阳县','150200');  
INSERT INTO hat\_area VALUES (369,'150223','达尔罕茂明安联合旗','150200');  
INSERT INTO hat\_area VALUES (370,'150301','市辖区','150300');  
INSERT INTO hat\_area VALUES (371,'150302','海勃湾区','150300');  
INSERT INTO hat\_area VALUES (372,'150303','海南区','150300');  
INSERT INTO hat\_area VALUES (373,'150304','乌达区','150300');  
INSERT INTO hat\_area VALUES (374,'150401','市辖区','150400');  
INSERT INTO hat\_area VALUES (375,'150402','红山区','150400');  
INSERT INTO hat\_area VALUES (376,'150403','元宝山区','150400');  
INSERT INTO hat\_area VALUES (377,'150404','松山区','150400');  
INSERT INTO hat\_area VALUES (378,'150421','阿鲁科尔沁旗','150400');  
INSERT INTO hat\_area VALUES (379,'150422','巴林左旗','150400');  
INSERT INTO hat\_area VALUES (380,'150423','巴林右旗','150400');  
INSERT INTO hat\_area VALUES (381,'150424','林西县','150400');  
INSERT INTO hat\_area VALUES (382,'150425','克什克腾旗','150400');  
INSERT INTO hat\_area VALUES (383,'150426','翁牛特旗','150400');  
INSERT INTO hat\_area VALUES (384,'150428','喀喇沁旗','150400');  
INSERT INTO hat\_area VALUES (385,'150429','宁城县','150400');  
INSERT INTO hat\_area VALUES (386,'150430','敖汉旗','150400');  
INSERT INTO hat\_area VALUES (387,'150501','市辖区','150500');  
INSERT INTO hat\_area VALUES (388,'150502','科尔沁区','150500');  
INSERT INTO hat\_area VALUES (389,'150521','科尔沁左翼中旗','150500');  
INSERT INTO hat\_area VALUES (390,'150522','科尔沁左翼后旗','150500');  
INSERT INTO hat\_area VALUES (391,'150523','开鲁县','150500');  
INSERT INTO hat\_area VALUES (392,'150524','库伦旗','150500');  
INSERT INTO hat\_area VALUES (393,'150525','奈曼旗','150500');  
INSERT INTO hat\_area VALUES (394,'150526','扎鲁特旗','150500');  
INSERT INTO hat\_area VALUES (395,'150581','霍林郭勒市','150500');  
INSERT INTO hat\_area VALUES (396,'150602','东胜区','150600');  
INSERT INTO hat\_area VALUES (397,'150621','达拉特旗','150600');  
INSERT INTO hat\_area VALUES (398,'150622','准格尔旗','150600');  
INSERT INTO hat\_area VALUES (399,'150623','鄂托克前旗','150600');  
INSERT INTO hat\_area VALUES (400,'150624','鄂托克旗','150600');  
INSERT INTO hat\_area VALUES (401,'150625','杭锦旗','150600');  
INSERT INTO hat\_area VALUES (402,'150626','乌审旗','150600');  
INSERT INTO hat\_area VALUES (403,'150627','伊金霍洛旗','150600');  
INSERT INTO hat\_area VALUES (404,'150701','市辖区','150700');  
INSERT INTO hat\_area VALUES (405,'150702','海拉尔区','150700');  
INSERT INTO hat\_area VALUES (406,'150721','阿荣旗','150700');  
INSERT INTO hat\_area VALUES (407,'150722','莫力达瓦达斡尔族自治旗','150700');  
INSERT INTO hat\_area VALUES (408,'150723','鄂伦春自治旗','150700');  
INSERT INTO hat\_area VALUES (409,'150724','鄂温克族自治旗','150700');  
INSERT INTO hat\_area VALUES (410,'150725','陈巴尔虎旗','150700');  
INSERT INTO hat\_area VALUES (411,'150726','新巴尔虎左旗','150700');  
INSERT INTO hat\_area VALUES (412,'150727','新巴尔虎右旗','150700');  
INSERT INTO hat\_area VALUES (413,'150781','满洲里市','150700');  
INSERT INTO hat\_area VALUES (414,'150782','牙克石市','150700');  
INSERT INTO hat\_area VALUES (415,'150783','扎兰屯市','150700');  
INSERT INTO hat\_area VALUES (416,'150784','额尔古纳市','150700');  
INSERT INTO hat\_area VALUES (417,'150785','根河市','150700');  
INSERT INTO hat\_area VALUES (418,'150801','市辖区','150800');  
INSERT INTO hat\_area VALUES (419,'150802','临河区','150800');  
INSERT INTO hat\_area VALUES (420,'150821','五原县','150800');  
INSERT INTO hat\_area VALUES (421,'150822','磴口县','150800');  
INSERT INTO hat\_area VALUES (422,'150823','乌拉特前旗','150800');  
INSERT INTO hat\_area VALUES (423,'150824','乌拉特中旗','150800');  
INSERT INTO hat\_area VALUES (424,'150825','乌拉特后旗','150800');  
INSERT INTO hat\_area VALUES (425,'150826','杭锦后旗','150800');  
INSERT INTO hat\_area VALUES (426,'150901','市辖区','150900');  
INSERT INTO hat\_area VALUES (427,'150902','集宁区','150900');  
INSERT INTO hat\_area VALUES (428,'150921','卓资县','150900');  
INSERT INTO hat\_area VALUES (429,'150922','化德县','150900');  
INSERT INTO hat\_area VALUES (430,'150923','商都县','150900');  
INSERT INTO hat\_area VALUES (431,'150924','兴和县','150900');  
INSERT INTO hat\_area VALUES (432,'150925','凉城县','150900');  
INSERT INTO hat\_area VALUES (433,'150926','察哈尔右翼前旗','150900');  
INSERT INTO hat\_area VALUES (434,'150927','察哈尔右翼中旗','150900');  
INSERT INTO hat\_area VALUES (435,'150928','察哈尔右翼后旗','150900');  
INSERT INTO hat\_area VALUES (436,'150929','四子王旗','150900');  
INSERT INTO hat\_area VALUES (437,'150981','丰镇市','150900');  
INSERT INTO hat\_area VALUES (438,'152201','乌兰浩特市','152200');  
INSERT INTO hat\_area VALUES (439,'152202','阿尔山市','152200');  
INSERT INTO hat\_area VALUES (440,'152221','科尔沁右翼前旗','152200');  
INSERT INTO hat\_area VALUES (441,'152222','科尔沁右翼中旗','152200');  
INSERT INTO hat\_area VALUES (442,'152223','扎赉特旗','152200');  
INSERT INTO hat\_area VALUES (443,'152224','突泉县','152200');  
INSERT INTO hat\_area VALUES (444,'152501','二连浩特市','152500');  
INSERT INTO hat\_area VALUES (445,'152502','锡林浩特市','152500');  
INSERT INTO hat\_area VALUES (446,'152522','阿巴嘎旗','152500');  
INSERT INTO hat\_area VALUES (447,'152523','苏尼特左旗','152500');  
INSERT INTO hat\_area VALUES (448,'152524','苏尼特右旗','152500');  
INSERT INTO hat\_area VALUES (449,'152525','东乌珠穆沁旗','152500');  
INSERT INTO hat\_area VALUES (450,'152526','西乌珠穆沁旗','152500');  
INSERT INTO hat\_area VALUES (451,'152527','太仆寺旗','152500');  
INSERT INTO hat\_area VALUES (452,'152528','镶黄旗','152500');  
INSERT INTO hat\_area VALUES (453,'152529','正镶白旗','152500');  
INSERT INTO hat\_area VALUES (454,'152530','正蓝旗','152500');  
INSERT INTO hat\_area VALUES (455,'152531','多伦县','152500');  
INSERT INTO hat\_area VALUES (456,'152921','阿拉善左旗','152900');  
INSERT INTO hat\_area VALUES (457,'152922','阿拉善右旗','152900');  
INSERT INTO hat\_area VALUES (458,'152923','额济纳旗','152900');  
INSERT INTO hat\_area VALUES (459,'210101','市辖区','210100');  
INSERT INTO hat\_area VALUES (460,'210102','和平区','210100');  
INSERT INTO hat\_area VALUES (461,'210103','沈河区','210100');  
INSERT INTO hat\_area VALUES (462,'210104','大东区','210100');  
INSERT INTO hat\_area VALUES (463,'210105','皇姑区','210100');  
INSERT INTO hat\_area VALUES (464,'210106','铁西区','210100');  
INSERT INTO hat\_area VALUES (465,'210111','苏家屯区','210100');  
INSERT INTO hat\_area VALUES (466,'210112','东陵区','210100');  
INSERT INTO hat\_area VALUES (467,'210113','新城子区','210100');  
INSERT INTO hat\_area VALUES (468,'210114','于洪区','210100');  
INSERT INTO hat\_area VALUES (469,'210122','辽中县','210100');  
INSERT INTO hat\_area VALUES (470,'210123','康平县','210100');  
INSERT INTO hat\_area VALUES (471,'210124','法库县','210100');  
INSERT INTO hat\_area VALUES (472,'210181','新民市','210100');  
INSERT INTO hat\_area VALUES (473,'210201','市辖区','210200');  
INSERT INTO hat\_area VALUES (474,'210202','中山区','210200');  
INSERT INTO hat\_area VALUES (475,'210203','西岗区','210200');  
INSERT INTO hat\_area VALUES (476,'210204','沙河口区','210200');  
INSERT INTO hat\_area VALUES (477,'210211','甘井子区','210200');  
INSERT INTO hat\_area VALUES (478,'210212','旅顺口区','210200');  
INSERT INTO hat\_area VALUES (479,'210213','金州区','210200');  
INSERT INTO hat\_area VALUES (480,'210224','长海县','210200');  
INSERT INTO hat\_area VALUES (481,'210281','瓦房店市','210200');  
INSERT INTO hat\_area VALUES (482,'210282','普兰店市','210200');  
INSERT INTO hat\_area VALUES (483,'210283','庄河市','210200');  
INSERT INTO hat\_area VALUES (484,'210301','市辖区','210300');  
INSERT INTO hat\_area VALUES (485,'210302','铁东区','210300');  
INSERT INTO hat\_area VALUES (486,'210303','铁西区','210300');  
INSERT INTO hat\_area VALUES (487,'210304','立山区','210300');  
INSERT INTO hat\_area VALUES (488,'210311','千山区','210300');  
INSERT INTO hat\_area VALUES (489,'210321','台安县','210300');  
INSERT INTO hat\_area VALUES (490,'210323','岫岩满族自治县','210300');  
INSERT INTO hat\_area VALUES (491,'210381','海城市','210300');  
INSERT INTO hat\_area VALUES (492,'210401','市辖区','210400');  
INSERT INTO hat\_area VALUES (493,'210402','新抚区','210400');  
INSERT INTO hat\_area VALUES (494,'210403','东洲区','210400');  
INSERT INTO hat\_area VALUES (495,'210404','望花区','210400');  
INSERT INTO hat\_area VALUES (496,'210411','顺城区','210400');  
INSERT INTO hat\_area VALUES (497,'210421','抚顺县','210400');  
INSERT INTO hat\_area VALUES (498,'210422','新宾满族自治县','210400');  
INSERT INTO hat\_area VALUES (499,'210423','清原满族自治县','210400');  
INSERT INTO hat\_area VALUES (500,'210501','市辖区','210500');  
INSERT INTO hat\_area VALUES (501,'210502','平山区','210500');  
INSERT INTO hat\_area VALUES (502,'210503','溪湖区','210500');  
INSERT INTO hat\_area VALUES (503,'210504','明山区','210500');  
INSERT INTO hat\_area VALUES (504,'210505','南芬区','210500');  
INSERT INTO hat\_area VALUES (505,'210521','本溪满族自治县','210500');  
INSERT INTO hat\_area VALUES (506,'210522','桓仁满族自治县','210500');  
INSERT INTO hat\_area VALUES (507,'210601','市辖区','210600');  
INSERT INTO hat\_area VALUES (508,'210602','元宝区','210600');  
INSERT INTO hat\_area VALUES (509,'210603','振兴区','210600');  
INSERT INTO hat\_area VALUES (510,'210604','振安区','210600');  
INSERT INTO hat\_area VALUES (511,'210624','宽甸满族自治县','210600');  
INSERT INTO hat\_area VALUES (512,'210681','东港市','210600');  
INSERT INTO hat\_area VALUES (513,'210682','凤城市','210600');  
INSERT INTO hat\_area VALUES (514,'210701','市辖区','210700');  
INSERT INTO hat\_area VALUES (515,'210702','古塔区','210700');  
INSERT INTO hat\_area VALUES (516,'210703','凌河区','210700');  
INSERT INTO hat\_area VALUES (517,'210711','太和区','210700');  
INSERT INTO hat\_area VALUES (518,'210726','黑山县','210700');  
INSERT INTO hat\_area VALUES (519,'210727','义　县','210700');  
INSERT INTO hat\_area VALUES (520,'210781','凌海市','210700');  
INSERT INTO hat\_area VALUES (521,'210782','北宁市','210700');  
INSERT INTO hat\_area VALUES (522,'210801','市辖区','210800');  
INSERT INTO hat\_area VALUES (523,'210802','站前区','210800');  
INSERT INTO hat\_area VALUES (524,'210803','西市区','210800');  
INSERT INTO hat\_area VALUES (525,'210804','鲅鱼圈区','210800');  
INSERT INTO hat\_area VALUES (526,'210811','老边区','210800');  
INSERT INTO hat\_area VALUES (527,'210881','盖州市','210800');  
INSERT INTO hat\_area VALUES (528,'210882','大石桥市','210800');  
INSERT INTO hat\_area VALUES (529,'210901','市辖区','210900');  
INSERT INTO hat\_area VALUES (530,'210902','海州区','210900');  
INSERT INTO hat\_area VALUES (531,'210903','新邱区','210900');  
INSERT INTO hat\_area VALUES (532,'210904','太平区','210900');  
INSERT INTO hat\_area VALUES (533,'210905','清河门区','210900');  
INSERT INTO hat\_area VALUES (534,'210911','细河区','210900');  
INSERT INTO hat\_area VALUES (535,'210921','阜新蒙古族自治县','210900');  
INSERT INTO hat\_area VALUES (536,'210922','彰武县','210900');  
INSERT INTO hat\_area VALUES (537,'211001','市辖区','211000');  
INSERT INTO hat\_area VALUES (538,'211002','白塔区','211000');  
INSERT INTO hat\_area VALUES (539,'211003','文圣区','211000');  
INSERT INTO hat\_area VALUES (540,'211004','宏伟区','211000');  
INSERT INTO hat\_area VALUES (541,'211005','弓长岭区','211000');  
INSERT INTO hat\_area VALUES (542,'211011','太子河区','211000');  
INSERT INTO hat\_area VALUES (543,'211021','辽阳县','211000');  
INSERT INTO hat\_area VALUES (544,'211081','灯塔市','211000');  
INSERT INTO hat\_area VALUES (545,'211101','市辖区','211100');  
INSERT INTO hat\_area VALUES (546,'211102','双台子区','211100');  
INSERT INTO hat\_area VALUES (547,'211103','兴隆台区','211100');  
INSERT INTO hat\_area VALUES (548,'211121','大洼县','211100');  
INSERT INTO hat\_area VALUES (549,'211122','盘山县','211100');  
INSERT INTO hat\_area VALUES (550,'211201','市辖区','211200');  
INSERT INTO hat\_area VALUES (551,'211202','银州区','211200');  
INSERT INTO hat\_area VALUES (552,'211204','清河区','211200');  
INSERT INTO hat\_area VALUES (553,'211221','铁岭县','211200');  
INSERT INTO hat\_area VALUES (554,'211223','西丰县','211200');  
INSERT INTO hat\_area VALUES (555,'211224','昌图县','211200');  
INSERT INTO hat\_area VALUES (556,'211281','调兵山市','211200');  
INSERT INTO hat\_area VALUES (557,'211282','开原市','211200');  
INSERT INTO hat\_area VALUES (558,'211301','市辖区','211300');  
INSERT INTO hat\_area VALUES (559,'211302','双塔区','211300');  
INSERT INTO hat\_area VALUES (560,'211303','龙城区','211300');  
INSERT INTO hat\_area VALUES (561,'211321','朝阳县','211300');  
INSERT INTO hat\_area VALUES (562,'211322','建平县','211300');  
INSERT INTO hat\_area VALUES (563,'211324','喀喇沁左翼蒙古族自治县','211300');  
INSERT INTO hat\_area VALUES (564,'211381','北票市','211300');  
INSERT INTO hat\_area VALUES (565,'211382','凌源市','211300');  
INSERT INTO hat\_area VALUES (566,'211401','市辖区','211400');  
INSERT INTO hat\_area VALUES (567,'211402','连山区','211400');  
INSERT INTO hat\_area VALUES (568,'211403','龙港区','211400');  
INSERT INTO hat\_area VALUES (569,'211404','南票区','211400');  
INSERT INTO hat\_area VALUES (570,'211421','绥中县','211400');  
INSERT INTO hat\_area VALUES (571,'211422','建昌县','211400');  
INSERT INTO hat\_area VALUES (572,'211481','兴城市','211400');  
INSERT INTO hat\_area VALUES (573,'220101','市辖区','220100');  
INSERT INTO hat\_area VALUES (574,'220102','南关区','220100');  
INSERT INTO hat\_area VALUES (575,'220103','宽城区','220100');  
INSERT INTO hat\_area VALUES (576,'220104','朝阳区','220100');  
INSERT INTO hat\_area VALUES (577,'220105','二道区','220100');  
INSERT INTO hat\_area VALUES (578,'220106','绿园区','220100');  
INSERT INTO hat\_area VALUES (579,'220112','双阳区','220100');  
INSERT INTO hat\_area VALUES (580,'220122','农安县','220100');  
INSERT INTO hat\_area VALUES (581,'220181','九台市','220100');  
INSERT INTO hat\_area VALUES (582,'220182','榆树市','220100');  
INSERT INTO hat\_area VALUES (583,'220183','德惠市','220100');  
INSERT INTO hat\_area VALUES (584,'220201','市辖区','220200');  
INSERT INTO hat\_area VALUES (585,'220202','昌邑区','220200');  
INSERT INTO hat\_area VALUES (586,'220203','龙潭区','220200');  
INSERT INTO hat\_area VALUES (587,'220204','船营区','220200');  
INSERT INTO hat\_area VALUES (588,'220211','丰满区','220200');  
INSERT INTO hat\_area VALUES (589,'220221','永吉县','220200');  
INSERT INTO hat\_area VALUES (590,'220281','蛟河市','220200');  
INSERT INTO hat\_area VALUES (591,'220282','桦甸市','220200');  
INSERT INTO hat\_area VALUES (592,'220283','舒兰市','220200');  
INSERT INTO hat\_area VALUES (593,'220284','磐石市','220200');  
INSERT INTO hat\_area VALUES (594,'220301','市辖区','220300');  
INSERT INTO hat\_area VALUES (595,'220302','铁西区','220300');  
INSERT INTO hat\_area VALUES (596,'220303','铁东区','220300');  
INSERT INTO hat\_area VALUES (597,'220322','梨树县','220300');  
INSERT INTO hat\_area VALUES (598,'220323','伊通满族自治县','220300');  
INSERT INTO hat\_area VALUES (599,'220381','公主岭市','220300');  
INSERT INTO hat\_area VALUES (600,'220382','双辽市','220300');  
INSERT INTO hat\_area VALUES (601,'220401','市辖区','220400');  
INSERT INTO hat\_area VALUES (602,'220402','龙山区','220400');  
INSERT INTO hat\_area VALUES (603,'220403','西安区','220400');  
INSERT INTO hat\_area VALUES (604,'220421','东丰县','220400');  
INSERT INTO hat\_area VALUES (605,'220422','东辽县','220400');  
INSERT INTO hat\_area VALUES (606,'220501','市辖区','220500');  
INSERT INTO hat\_area VALUES (607,'220502','东昌区','220500');  
INSERT INTO hat\_area VALUES (608,'220503','二道江区','220500');  
INSERT INTO hat\_area VALUES (609,'220521','通化县','220500');  
INSERT INTO hat\_area VALUES (610,'220523','辉南县','220500');  
INSERT INTO hat\_area VALUES (611,'220524','柳河县','220500');  
INSERT INTO hat\_area VALUES (612,'220581','梅河口市','220500');  
INSERT INTO hat\_area VALUES (613,'220582','集安市','220500');  
INSERT INTO hat\_area VALUES (614,'220601','市辖区','220600');  
INSERT INTO hat\_area VALUES (615,'220602','八道江区','220600');  
INSERT INTO hat\_area VALUES (616,'220621','抚松县','220600');  
INSERT INTO hat\_area VALUES (617,'220622','靖宇县','220600');  
INSERT INTO hat\_area VALUES (618,'220623','长白朝鲜族自治县','220600');  
INSERT INTO hat\_area VALUES (619,'220625','江源县','220600');  
INSERT INTO hat\_area VALUES (620,'220681','临江市','220600');  
INSERT INTO hat\_area VALUES (621,'220701','市辖区','220700');  
INSERT INTO hat\_area VALUES (622,'220702','宁江区','220700');  
INSERT INTO hat\_area VALUES (623,'220721','前郭尔罗斯蒙古族自治县','220700');  
INSERT INTO hat\_area VALUES (624,'220722','长岭县','220700');  
INSERT INTO hat\_area VALUES (625,'220723','乾安县','220700');  
INSERT INTO hat\_area VALUES (626,'220724','扶余县','220700');  
INSERT INTO hat\_area VALUES (627,'220801','市辖区','220800');  
INSERT INTO hat\_area VALUES (628,'220802','洮北区','220800');  
INSERT INTO hat\_area VALUES (629,'220821','镇赉县','220800');  
INSERT INTO hat\_area VALUES (630,'220822','通榆县','220800');  
INSERT INTO hat\_area VALUES (631,'220881','洮南市','220800');  
INSERT INTO hat\_area VALUES (632,'220882','大安市','220800');  
INSERT INTO hat\_area VALUES (633,'222401','延吉市','222400');  
INSERT INTO hat\_area VALUES (634,'222402','图们市','222400');  
INSERT INTO hat\_area VALUES (635,'222403','敦化市','222400');  
INSERT INTO hat\_area VALUES (636,'222404','珲春市','222400');  
INSERT INTO hat\_area VALUES (637,'222405','龙井市','222400');  
INSERT INTO hat\_area VALUES (638,'222406','和龙市','222400');  
INSERT INTO hat\_area VALUES (639,'222424','汪清县','222400');  
INSERT INTO hat\_area VALUES (640,'222426','安图县','222400');  
INSERT INTO hat\_area VALUES (641,'230101','市辖区','230100');  
INSERT INTO hat\_area VALUES (642,'230102','道里区','230100');  
INSERT INTO hat\_area VALUES (643,'230103','南岗区','230100');  
INSERT INTO hat\_area VALUES (644,'230104','道外区','230100');  
INSERT INTO hat\_area VALUES (645,'230106','香坊区','230100');  
INSERT INTO hat\_area VALUES (646,'230107','动力区','230100');  
INSERT INTO hat\_area VALUES (647,'230108','平房区','230100');  
INSERT INTO hat\_area VALUES (648,'230109','松北区','230100');  
INSERT INTO hat\_area VALUES (649,'230111','呼兰区','230100');  
INSERT INTO hat\_area VALUES (650,'230123','依兰县','230100');  
INSERT INTO hat\_area VALUES (651,'230124','方正县','230100');  
INSERT INTO hat\_area VALUES (652,'230125','宾　县','230100');  
INSERT INTO hat\_area VALUES (653,'230126','巴彦县','230100');  
INSERT INTO hat\_area VALUES (654,'230127','木兰县','230100');  
INSERT INTO hat\_area VALUES (655,'230128','通河县','230100');  
INSERT INTO hat\_area VALUES (656,'230129','延寿县','230100');  
INSERT INTO hat\_area VALUES (657,'230181','阿城市','230100');  
INSERT INTO hat\_area VALUES (658,'230182','双城市','230100');  
INSERT INTO hat\_area VALUES (659,'230183','尚志市','230100');  
INSERT INTO hat\_area VALUES (660,'230184','五常市','230100');  
INSERT INTO hat\_area VALUES (661,'230201','市辖区','230200');  
INSERT INTO hat\_area VALUES (662,'230202','龙沙区','230200');  
INSERT INTO hat\_area VALUES (663,'230203','建华区','230200');  
INSERT INTO hat\_area VALUES (664,'230204','铁锋区','230200');  
INSERT INTO hat\_area VALUES (665,'230205','昂昂溪区','230200');  
INSERT INTO hat\_area VALUES (666,'230206','富拉尔基区','230200');  
INSERT INTO hat\_area VALUES (667,'230207','碾子山区','230200');  
INSERT INTO hat\_area VALUES (668,'230208','梅里斯达斡尔族区','230200');  
INSERT INTO hat\_area VALUES (669,'230221','龙江县','230200');  
INSERT INTO hat\_area VALUES (670,'230223','依安县','230200');  
INSERT INTO hat\_area VALUES (671,'230224','泰来县','230200');  
INSERT INTO hat\_area VALUES (672,'230225','甘南县','230200');  
INSERT INTO hat\_area VALUES (673,'230227','富裕县','230200');  
INSERT INTO hat\_area VALUES (674,'230229','克山县','230200');  
INSERT INTO hat\_area VALUES (675,'230230','克东县','230200');  
INSERT INTO hat\_area VALUES (676,'230231','拜泉县','230200');  
INSERT INTO hat\_area VALUES (677,'230281','讷河市','230200');  
INSERT INTO hat\_area VALUES (678,'230301','市辖区','230300');  
INSERT INTO hat\_area VALUES (679,'230302','鸡冠区','230300');  
INSERT INTO hat\_area VALUES (680,'230303','恒山区','230300');  
INSERT INTO hat\_area VALUES (681,'230304','滴道区','230300');  
INSERT INTO hat\_area VALUES (682,'230305','梨树区','230300');  
INSERT INTO hat\_area VALUES (683,'230306','城子河区','230300');  
INSERT INTO hat\_area VALUES (684,'230307','麻山区','230300');  
INSERT INTO hat\_area VALUES (685,'230321','鸡东县','230300');  
INSERT INTO hat\_area VALUES (686,'230381','虎林市','230300');  
INSERT INTO hat\_area VALUES (687,'230382','密山市','230300');  
INSERT INTO hat\_area VALUES (688,'230401','市辖区','230400');  
INSERT INTO hat\_area VALUES (689,'230402','向阳区','230400');  
INSERT INTO hat\_area VALUES (690,'230403','工农区','230400');  
INSERT INTO hat\_area VALUES (691,'230404','南山区','230400');  
INSERT INTO hat\_area VALUES (692,'230405','兴安区','230400');  
INSERT INTO hat\_area VALUES (693,'230406','东山区','230400');  
INSERT INTO hat\_area VALUES (694,'230407','兴山区','230400');  
INSERT INTO hat\_area VALUES (695,'230421','萝北县','230400');  
INSERT INTO hat\_area VALUES (696,'230422','绥滨县','230400');

.....

文字内容太多，发不了，请移步下面转载源

或者画一个C币吧：《[CSDN下载][CSDN]》

本文内容转载自：《[java 省市区数据data ][java _data]》

[CSDN]: https://download.csdn.net/download/yexiaomodemo/17783900
[java _data]: https://www.liangzl.com/get-article-detail-36352.html