省市区三级数据-MySQL

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′);