`
suizhikuo
  • 浏览: 28829 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

SQL 数据库 省市区三级表 建立语句

 
阅读更多

SQL省市区三级表


-- 表的结构 area
DROP TABLE area;
CREATE TABLE area (
id int NOT NULL ,
areaID int NOT NULL,
area varchar(200) NOT NULL,
fatherID int NOT NULL,
PRIMARY KEY (id)

)


DROP TABLE city;
CREATE TABLE city (
id int NOT NULL ,
cityID int NOT NULL,
city varchar(200) NOT NULL,
fatherID int NOT NULL,
PRIMARY KEY ( id)
)

--
-- 导出表中的数据 city
--


-- --------------------------------------------------------

--
-- 表的结构 province
--

DROP TABLE province;
CREATE TABLE province (
id int NOT NULL ,
provinceID int NOT NULL,
province varchar(200) NOT NULL,
PRIMARY KEY ( id))


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


INSERT city (id,cityID,city,fatherID)
select 1,110100,'市辖区',110000 union
select 2,110200,'县',110000 union
select 3,120100,'市辖区',120000 union
select 4,120200,'县',120000 union
select 5,130100,'石家庄市',130000 union
select 6,130200,'唐山市',130000 union
select 7,130300,'秦皇岛市',130000 union
select 8,130400,'邯郸市',130000 union
select 9,130500,'邢台市',130000 union
select 10,130600,'保定市',130000 union
select 11,130700,'张家口市',130000 union
select 12,130800,'承德市',130000 union
select 13,130900,'沧州市',130000 union
select 14,131000,'廊坊市',130000 union
select 15,131100,'衡水市',130000 union
select 16,140100,'太原市',140000 union
select 17,140200,'大同市',140000 union
select 18,140300,'阳泉市',140000 union
select 19,140400,'长治市',140000 union
select 20,140500,'晋城市',140000 union
select 21,140600,'朔州市',140000 union
select 22,140700,'晋中市',140000 union
select 23,140800,'运城市',140000 union
select 24,140900,'忻州市',140000 union
select 25,141000,'临汾市',140000 union
select 26,141100,'吕梁市',140000


INSERT city (id,cityID,city,fatherID)
select 27,150100,'呼和浩特市',150000 union
select 28,150200,'包头市',150000 union
select 29,150300,'乌海市',150000 union
select 30,150400,'赤峰市',150000 union
select 31,150500,'通辽市',150000 union
select 32,150600,'鄂尔多斯市',150000 union
select 33,150700,'呼伦贝尔市',150000 union
select 34,150800,'巴彦淖尔市',150000 union
select 35,150900,'乌兰察布市',150000 union
select 36,152200,'兴安盟',150000 union
select 37,152500,'锡林郭勒盟',150000 union
select 38,152900,'阿拉善盟',150000 union
select 39,210100,'沈阳市',210000 union
select 40,210200,'大连市',210000 union
select 41,210300,'鞍山市',210000 union
select 42,210400,'抚顺市',210000 union
select 43,210500,'本溪市',210000 union
select 44,210600,'丹东市',210000 union
select 45,210700,'锦州市',210000 union
select 46,210800,'营口市',210000 union
select 47,210900,'阜新市',210000 union
select 48,211000,'辽阳市',210000 union
select 49,211100,'盘锦市',210000 union
select 50,211200,'铁岭市',210000 union
select 51,211300,'朝阳市',210000 union
select 52,211400,'葫芦岛市',210000 union
select 53,220100,'长春市',220000 union
select 54,220200,'吉林市',220000 union
select 55,220300,'四平市',220000 union
select 56,220400,'辽源市',220000 union
select 57,220500,'通化市',220000 union
select 58,220600,'白山市',220000 union
select 59,220700,'松原市',220000 union
select 60,220800,'白城市',220000 union
select 61,222400,'延边朝鲜族自治州',220000 union
select 62,230100,'哈尔滨市',230000 union
select 63,230200,'齐齐哈尔市',230000 union
select 64,230300,'鸡西市',230000 union
select 65,230400,'鹤岗市',230000 union
select 66,230500,'双鸭山市',230000 union
select 67,230600,'大庆市',230000 union
select 68,230700,'伊春市',230000 union
select 69,230800,'佳木斯市',230000 union
select 70,230900,'七台河市',230000 union
select 71,231000,'牡丹江市',230000 union
select 72,231100,'黑河市',230000 union
select 73,231200,'绥化市',230000 union
select 74,232700,'大兴安岭地区',230000 union
select 75,310100,'市辖区',310000 union
select 76,310200,'县',310000 union
select 77,320100,'南京市',320000 union
select 78,320200,'无锡市',320000 union
select 79,320300,'徐州市',320000 union
select 80,320400,'常州市',320000 union
select 81,320500,'苏州市',320000 union
select 82,320600,'南通市',320000 union
select 83,320700,'连云港市',320000 union
select 84,320800,'淮安市',320000 union
select 85,320900,'盐城市',320000 union
select 86,321000,'扬州市',320000 union
select 87,321100,'镇江市',320000 union
select 88,321200,'泰州市',320000 union
select 89,321300,'宿迁市',320000 union
select 90,330100,'杭州市',330000 union
select 91,330200,'宁波市',330000 union
select 92,330300,'温州市',330000 union
select 93,330400,'嘉兴市',330000 union
select 94,330500,'湖州市',330000 union
select 95,330600,'绍兴市',330000 union
select 96,330700,'金华市',330000 union
select 97,330800,'衢州市',330000 union
select 98,330900,'舟山市',330000 union
select 99,331000,'台州市',330000 union
select 100,331100,'丽水市',330000 union
select 101,340100,'合肥市',340000 union
select 102,340200,'芜湖市',340000 union
select 103,340300,'蚌埠市',340000 union
select 104,340400,'淮南市',340000 union
select 105,340500,'马鞍山市',340000 union
select 106,340600,'淮北市',340000 union
select 107,340700,'铜陵市',340000 union
select 108,340800,'安庆市',340000 union
select 109,341000,'黄山市',340000 union
select 110,341100,'滁州市',340000 union
select 111,341200,'阜阳市',340000 union
select 112,341300,'宿州市',340000 union
select 113,341400,'巢湖市',340000 union
select 114,341500,'六安市',340000 union
select 115,341600,'亳州市',340000 union
select 116,341700,'池州市',340000 union
select 117,341800,'宣城市',340000 union
select 118,350100,'福州市',350000 union
select 119,350200,'厦门市',350000 union
select 120,350300,'莆田市',350000 union
select 121,350400,'三明市',350000 union
select 122,350500,'泉州市',350000 union
select 123,350600,'漳州市',350000 union
select 124,350700,'南平市',350000 union
select 125,350800,'龙岩市',350000 union
select 126,350900,'宁德市',350000

INSERT city (id,cityID,city,fatherID)
select 127,360100,'南昌市',360000 union
select 128,360200,'景德镇市',360000 union
select 129,360300,'萍乡市',360000 union
select 130,360400,'九江市',360000 union
select 131,360500,'新余市',360000 union
select 132,360600,'鹰潭市',360000 union
select 133,360700,'赣州市',360000 union
select 134,360800,'吉安市',360000 union
select 135,360900,'宜春市',360000 union
select 136,361000,'抚州市',360000 union
select 137,361100,'上饶市',360000 union
select 138,370100,'济南市',370000 union
select 139,370200,'青岛市',370000 union
select 140,370300,'淄博市',370000 union
select 141,370400,'枣庄市',370000 union
select 142,370500,'东营市',370000 union
select 143,370600,'烟台市',370000 union
select 144,370700,'潍坊市',370000 union
select 145,370800,'济宁市',370000 union
select 146,370900,'泰安市',370000 union
select 147,371000,'威海市',370000 union
select 148,371100,'日照市',370000 union
select 149,371200,'莱芜市',370000 union
select 150,371300,'临沂市',370000 union
select 151,371400,'德州市',370000 union
select 152,371500,'聊城市',370000 union
select 153,371600,'滨州市',370000 union
select 154,371700,'荷泽市',370000 union
select 155,410100,'郑州市',410000 union
select 156,410200,'开封市',410000 union
select 157,410300,'洛阳市',410000 union
select 158,410400,'平顶山市',410000 union
select 159,410500,'安阳市',410000 union
select 160,410600,'鹤壁市',410000 union
select 161,410700,'新乡市',410000 union
select 162,410800,'焦作市',410000 union
select 163,410900,'濮阳市',410000 union
select 164,411000,'许昌市',410000 union
select 165,411100,'漯河市',410000 union
select 166,411200,'三门峡市',410000 union
select 167,411300,'南阳市',410000 union
select 168,411400,'商丘市',410000 union
select 169,411500,'信阳市',410000 union
select 170,411600,'周口市',410000 union
select 171,411700,'驻马店市',410000


INSERT city (id,cityID,city,fatherID)
select 172,420100,'武汉市',420000 union
select 173,420200,'黄石市',420000 union
select 174,420300,'十堰市',420000 union
select 175,420500,'宜昌市',420000 union
select 176,420600,'襄樊市',420000 union
select 177,420700,'鄂州市',420000 union
select 178,420800,'荆门市',420000 union
select 179,420900,'孝感市',420000 union
select 180,421000,'荆州市',420000 union
select 181,421100,'黄冈市',420000 union
select 182,421200,'咸宁市',420000 union
select 183,421300,'随州市',420000 union
select 184,422800,'恩施土家族苗族自治州',420000 union
select 185,429000,'省直辖行政单位',420000 union
select 186,430100,'长沙市',430000 union
select 187,430200,'株洲市',430000 union
select 188,430300,'湘潭市',430000 union
select 189,430400,'衡阳市',430000 union
select 190,430500,'邵阳市',430000 union
select 191,430600,'岳阳市',430000 union
select 192,430700,'常德市',430000 union
select 193,430800,'张家界市',430000 union
select 194,430900,'益阳市',430000 union
select 195,431000,'郴州市',430000 union
select 196,431100,'永州市',430000 union
select 197,431200,'怀化市',430000 union
select 198,431300,'娄底市',430000 union
select 199,433100,'湘西土家族苗族自治州',430000 union
select 200,440100,'广州市',440000 union
select 201,440200,'韶关市',440000 union
select 202,440300,'深圳市',440000 union
select 203,440400,'珠海市',440000 union
select 204,440500,'汕头市',440000 union
select 205,440600,'佛山市',440000 union
select 206,440700,'江门市',440000 union
select 207,440800,'湛江市',440000 union
select 208,440900,'茂名市',440000 union
select 209,441200,'肇庆市',440000 union
select 210,441300,'惠州市',440000 union
select 211,441400,'梅州市',440000 union
select 212,441500,'汕尾市',440000 union
select 213,441600,'河源市',440000 union
select 214,441700,'阳江市',440000 union
select 215,441800,'清远市',440000 union
select 216,441900,'东莞市',440000 union
select 217,442000,'中山市',440000 union
select 218,445100,'潮州市',440000 union
select 219,445200,'揭阳市',440000 union
select 220,445300,'云浮市',440000 union
select 221,450100,'南宁市',450000 union
select 222,450200,'柳州市',450000 union
select 223,450300,'桂林市',450000 union
select 224,450400,'梧州市',450000 union
select 225,450500,'北海市',450000

INSERT city (id,cityID,city,fatherID)
select 226,450600,'防城港市',450000 union
select 227,450700,'钦州市',450000 union
select 228,450800,'贵港市',450000 union
select 229,450900,'玉林市',450000 union
select 230,451000,'百色市',450000 union
select 231,451100,'贺州市',450000 union
select 232,451200,'河池市',450000 union
select 233,451300,'来宾市',450000 union
select 234,451400,'崇左市',450000 union
select 235,460100,'海口市',460000 union
select 236,460200,'三亚市',460000 union
select 237,469000,'省直辖县级行政单位',460000 union
select 238,500100,'市辖区',500000 union
select 239,500200,'县',500000 union
select 240,500300,'市',500000 union
select 241,510100,'成都市',510000 union
select 242,510300,'自贡市',510000 union
select 243,510400,'攀枝花市',510000 union
select 244,510500,'泸州市',510000 union
select 245,510600,'德阳市',510000 union
select 246,510700,'绵阳市',510000 union
select 247,510800,'广元市',510000 union
select 248,510900,'遂宁市',510000 union
select 249,511000,'内江市',510000 union
select 250,511100,'乐山市',510000 union
select 251,511300,'南充市',510000 union
select 252,511400,'眉山市',510000 union
select 253,511500,'宜宾市',510000 union
select 254,511600,'广安市',510000 union
select 255,511700,'达州市',510000 union
select 256,511800,'雅安市',510000 union
select 257,511900,'巴中市',510000 union
select 258,512000,'资阳市',510000 union
select 259,513200,'阿坝藏族羌族自治州',510000 union
select 260,513300,'甘孜藏族自治州',510000 union
select 261,513400,'凉山彝族自治州',510000 union
select 262,520100,'贵阳市',520000 union
select 263,520200,'六盘水市',520000

INSERT city (id,cityID,city,fatherID)
select 264,520300,'遵义市',520000 union
select 265,520400,'安顺市',520000 union
select 266,522200,'铜仁地区',520000 union
select 267,522300,'黔西南布依族苗族自治州',520000 union
select 268,522400,'毕节地区',520000 union
select 269,522600,'黔东南苗族侗族自治州',520000 union
select 270,522700,'黔南布依族苗族自治州',520000 union
select 271,530100,'昆明市',530000 union
select 272,530300,'曲靖市',530000 union
select 273,530400,'玉溪市',530000 union
select 274,530500,'保山市',530000 union
select 275,530600,'昭通市',530000 union
select 276,530700,'丽江市',530000 union
select 277,530800,'思茅市',530000 union
select 278,530900,'临沧市',530000 union
select 279,532300,'楚雄彝族自治州',530000 union
select 280,532500,'红河哈尼族彝族自治州',530000 union
select 281,532600,'文山壮族苗族自治州',530000 union
select 282,532800,'西双版纳傣族自治州',530000 union
select 283,532900,'大理白族自治州',530000 union
select 284,533100,'德宏傣族景颇族自治州',530000 union
select 285,533300,'怒江傈僳族自治州',530000 union
select 286,533400,'迪庆藏族自治州',530000 union
select 287,540100,'拉萨市',540000 union
select 288,542100,'昌都地区',540000 union
select 289,542200,'山南地区',540000 union
select 290,542300,'日喀则地区',540000 union
select 291,542400,'那曲地区',540000 union
select 292,542500,'阿里地区',540000 union
select 293,542600,'林芝地区',540000


INSERT city (id,cityID,city,fatherID)
select 294,610100,'西安市',610000 union
select 295,610200,'铜川市',610000 union
select 296,610300,'宝鸡市',610000 union
select 297,610400,'咸阳市',610000 union
select 298,610500,'渭南市',610000 union
select 299,610600,'延安市',610000 union
select 300,610700,'汉中市',610000 union
select 301,610800,'榆林市',610000 union
select 302,610900,'安康市',610000 union
select 303,611000,'商洛市',610000 union
select 304,620100,'兰州市',620000 union
select 305,620200,'嘉峪关市',620000 union
select 306,620300,'金昌市',620000 union
select 307,620400,'白银市',620000 union
select 308,620500,'天水市',620000 union
select 309,620600,'武威市',620000 union
select 310,620700,'张掖市',620000 union
select 311,620800,'平凉市',620000 union
select 312,620900,'酒泉市',620000 union
select 313,621000,'庆阳市',620000 union
select 314,621100,'定西市',620000 union
select 315,621200,'陇南市',620000 union
select 316,622900,'临夏回族自治州',620000 union
select 317,623000,'甘南藏族自治州',620000 union
select 318,630100,'西宁市',630000 union
select 319,632100,'海东地区',630000 union
select 320,632200,'海北藏族自治州',630000 union
select 321,632300,'黄南藏族自治州',630000 union
select 322,632500,'海南藏族自治州',630000 union
select 323,632600,'果洛藏族自治州',630000 union
select 324,632700,'玉树藏族自治州',630000


INSERT city (id,cityID,city,fatherID)
select 325,632800,'海西蒙古族藏族自治州',630000 union
select 326,640100,'银川市',640000 union
select 327,640200,'石嘴山市',640000 union
select 328,640300,'吴忠市',640000 union
select 329,640400,'固原市',640000 union
select 330,640500,'中卫市',640000 union
select 331,650100,'乌鲁木齐市',650000 union
select 332,650200,'克拉玛依市',650000 union
select 333,652100,'吐鲁番地区',650000 union
select 334,652200,'哈密地区',650000 union
select 335,652300,'昌吉回族自治州',650000 union
select 336,652700,'博尔塔拉蒙古自治州',650000 union
select 337,652800,'巴音郭楞蒙古自治州',650000 union
select 338,652900,'阿克苏地区',650000


INSERT city (id,cityID,city,fatherID)
select 339,653000,'克孜勒苏柯尔克孜自治州',650000 union
select 340,653100,'喀什地区',650000 union
select 341,653200,'和田地区',650000 union
select 342,654000,'伊犁哈萨克自治州',650000 union
select 343,654200,'塔城地区',650000 union
select 344,654300,'阿勒泰地区',650000 union
select 345,659000,'省直辖行政单位',650000


INSERT INTO area (id,areaID,area,fatherID)
select 1,110101,'东城区',110100 union
select 2,110102,'西城区',110100 union
select 3,110103,'崇文区',110100 union
select 4,110104,'宣武区',110100 union
select 5,110105,'朝阳区',110100 union
select 6,110106,'丰台区',110100 union
select 7,110107,'石景山区',110100 union
select 8,110108,'海淀区',110100 union
select 9,110109,'门头沟区',110100 union
select 10,110111,'房山区',110100 union
select 11,110112,'通州区',110100 union
select 12,110113,'顺义区',110100 union
select 13,110114,'昌平区',110100 union
select 14,110115,'大兴区',110100 union
select 15,110116,'怀柔区',110100 union
select 16,110117,'平谷区',110100 union
select 17,110228,'密云县',110200 union
select 18,110229,'延庆县',110200 union
select 19,120101,'和平区',120100 union
select 20,120102,'河东区',120100 union
select 21,120103,'河西区',120100 union
select 22,120104,'南开区',120100 union
select 23,120105,'河北区',120100 union
select 24,120106,'红桥区',120100 union
select 25,120107,'塘沽区',120100 union
select 26,120108,'汉沽区',120100 union
select 27,120109,'大港区',120100 union
select 28,120110,'东丽区',120100 union
select 29,120111,'西青区',120100 union
select 30,120112,'津南区',120100 union
select 31,120113,'北辰区',120100 union
select 32,120114,'武清区',120100 union
select 33,120115,'宝坻区',120100 union
select 34,120221,'宁河县',120200 union
select 35,120223,'静海县',120200 union
select 36,120225,'蓟 县',120200 union
select 37,130101,'市辖区',130100 union
select 38,130102,'长安区',130100 union
select 39,130103,'桥东区',130100 union
select 40,130104,'桥西区',130100 union
select 41,130105,'新华区',130100 union
select 42,130107,'井陉矿区',130100 union
select 43,130108,'裕华区',130100 union
select 44,130121,'井陉县',130100 union
select 45,130123,'正定县',130100 union
select 46,130124,'栾城县',130100 union
select 47,130125,'行唐县',130100 union
select 48,130126,'灵寿县',130100 union
select 49,130127,'高邑县',130100 union
select 50,130128,'深泽县',130100 union
select 51,130129,'赞皇县',130100 union
select 52,130130,'无极县',130100 union
select 53,130131,'平山县',130100 union
select 54,130132,'元氏县',130100 union
select 55,130133,'赵 县',130100 union
select 56,130181,'辛集市',130100 union
select 57,130182,'藁城市',130100 union
select 58,130183,'晋州市',130100 union
select 59,130184,'新乐市',130100 union
select 60,130185,'鹿泉市',130100 union
select 61,130201,'市辖区',130200 union
select 62,130202,'路南区',130200 union
select 63,130203,'路北区',130200 union
select 64,130204,'古冶区',130200 union
select 65,130205,'开平区',130200 union
select 66,130207,'丰南区',130200 union
select 67,130208,'丰润区',130200 union
select 68,130223,'滦 县',130200 union
select 69,130224,'滦南县',130200 union
select 70,130225,'乐亭县',130200 union
select 71,130227,'迁西县',130200 union
select 72,130229,'玉田县',130200 union
select 73,130230,'唐海县',130200 union
select 74,130281,'遵化市',130200 union
select 75,130283,'迁安市',130200 union
select 76,130301,'市辖区',130300 union
select 77,130302,'海港区',130300 union
select 78,130303,'山海关区',130300 union
select 79,130304,'北戴河区',130300 union
select 80,130321,'青龙满族自治县',130300 union
select 81,130322,'昌黎县',130300 union
select 82,130323,'抚宁县',130300 union
select 83,130324,'卢龙县',130300 union
select 84,130401,'市辖区',130400 union
select 85,130402,'邯山区',130400 union
select 86,130403,'丛台区',130400 union
select 87,130404,'复兴区',130400 union
select 88,130406,'峰峰矿区',130400 union
select 89,130421,'邯郸县',130400 union
select 90,130423,'临漳县',130400 union
select 91,130424,'成安县',130400 union
select 92,130425,'大名县',130400 union
select 93,130426,'涉 县',130400 union
select 94,130427,'磁 县',130400 union
select 95,130428,'肥乡县',130400 union
select 96,130429,'永年县',130400 union
select 97,130430,'邱 县',130400 union
select 98,130431,'鸡泽县',130400 union
select 99,130432,'广平县',130400 union
select 100,130433,'馆陶县',130400 union
select 101,130434,'魏 县',130400 union
select 102,130435,'曲周县',130400 union
select 103,130481,'武安市',130400 union
select 104,130501,'市辖区',130500 union
select 105,130502,'桥东区',130500 union
select 106,130503,'桥西区',130500 union
select 107,130521,'邢台县',130500 union
select 108,130522,'临城县',130500 union
select 109,130523,'内丘县',130500 union
select 110,130524,'柏乡县',130500 union
select 111,130525,'隆尧县',130500 union
select 112,130526,'任 县',130500 union
select 113,130527,'南和县',130500 union
select 114,130528,'宁晋县',130500 union
select 115,130529,'巨鹿县',130500 union
select 116,130530,'新河县',130500 union
select 117,130531,'广宗县',130500 union
select 118,130532,'平乡县',130500 union
select 119,130533,'威 县',130500 union
select 120,130534,'清河县',130500 union
select 121,130535,'临西县',130500 union
select 122,130581,'南宫市',130500 union
select 123,130582,'沙河市',130500 union
select 124,130601,'市辖区',130600 union
select 125,130602,'新市区',130600 union
select 126,130603,'北市区',130600 union
select 127,130604,'南市区',130600 union
select 128,130621,'满城县',130600 union
select 129,130622,'清苑县',130600 union
select 130,130623,'涞水县',130600 union
select 131,130624,'阜平县',130600 union
select 132,130625,'徐水县',130600 union
select 133,130626,'定兴县',130600 union
select 134,130627,'唐 县',130600 union
select 135,130628,'高阳县',130600 union
select 136,130629,'容城县',130600 union
select 137,130630,'涞源县',130600 union
select 138,130631,'望都县',130600 union
select 139,130632,'安新县',130600 union
select 140,130633,'易 县',130600 union
select 141,130634,'曲阳县',130600 union
select 142,130635,'蠡 县',130600 union
select 143,130636,'顺平县',130600 union
select 144,130637,'博野县',130600 union
select 145,130638,'雄 县',130600 union
select 146,130681,'涿州市',130600 union
select 147,130682,'定州市',130600 union
select 148,130683,'安国市',130600 union
select 149,130684,'高碑店市',130600 union
select 150,130701,'市辖区',130700 union
select 151,130702,'桥东区',130700 union
select 152,130703,'桥西区',130700 union
select 153,130705,'宣化区',130700 union
select 154,130706,'下花园区',130700 union
select 155,130721,'宣化县',130700 union
select 156,130722,'张北县',130700 union
select 157,130723,'康保县',130700 union
select 158,130724,'沽源县',130700 union
select 159,130725,'尚义县',130700 union
select 160,130726,'蔚 县',130700 union
select 161,130727,'阳原县',130700 union
select 162,130728,'怀安县',130700 union
select 163,130729,'万全县',130700 union
select 164,130730,'怀来县',130700 union
select 165,130731,'涿鹿县',130700 union
select 166,130732,'赤城县',130700 union
select 167,130733,'崇礼县',130700 union
select 168,130801,'市辖区',130800 union
select 169,130802,'双桥区',130800 union
select 170,130803,'双滦区',130800 union
select 171,130804,'鹰手营子矿区',130800 union
select 172,130821,'承德县',130800 union
select 173,130822,'兴隆县',130800 union
select 174,130823,'平泉县',130800 union
select 175,130824,'滦平县',130800 union
select 176,130825,'隆化县',130800 union
select 177,130826,'丰宁满族自治县',130800 union
select 178,130827,'宽城满族自治县',130800 union
select 179,130828,'围场满族蒙古族自治县',130800 union
select 180,130901,'市辖区',130900 union
select 181,130902,'新华区',130900 union
select 182,130903,'运河区',130900 union
select 183,130921,'沧 县',130900 union
select 184,130922,'青 县',130900 union
select 185,130923,'东光县',130900 union
select 186,130924,'海兴县',130900 union
select 187,130925,'盐山县',130900 union
select 188,130926,'肃宁县',130900 union
select 189,130927,'南皮县',130900 union
select 190,130928,'吴桥县',130900 union
select 191,130929,'献 县',130900 union
select 192,130930,'孟村回族自治县',130900 union
select 193,130981,'泊头市',130900 union
select 194,130982,'任丘市',130900 union
select 195,130983,'黄骅市',130900 union
select 196,130984,'河间市',130900 union
select 197,131001,'市辖区',131000 union
select 198,131002,'安次区',131000 union
select 199,131003,'广阳区',131000 union
select 200,131022,'固安县',131000 union
select 201,131023,'永清县',131000 union
select 202,131024,'香河县',131000 union
select 203,131025,'大城县',131000 union
select 204,131026,'文安县',131000 union
select 205,131028,'大厂回族自治县',131000 union
select 206,131081,'霸州市',131000 union
select 207,131082,'三河市',131000 union
select 208,131101,'市辖区',131100 union
select 209,131102,'桃城区',131100 union
select 210,131121,'枣强县',131100 union
select 211,131122,'武邑县',131100 union
select 212,131123,'武强县',131100 union
select 213,131124,'饶阳县',131100 union
select 214,131125,'安平县',131100 union
select 215,131126,'故城县',131100 union
select 216,131127,'景 县',131100 union
select 217,131128,'阜城县',131100 union
select 218,131181,'冀州市',131100 union
select 219,131182,'深州市',131100 union
select 220,140101,'市辖区',140100 union
select 221,140105,'小店区',140100 union
select 222,140106,'迎泽区',140100 union
select 223,140107,'杏花岭区',140100 union
select 224,140108,'尖草坪区',140100 union
select 225,140109,'万柏林区',140100 union
select 226,140110,'晋源区',140100 union
select 227,140121,'清徐县',140100 union
select 228,140122,'阳曲县',140100 union
select 229,140123,'娄烦县',140100 union
select 230,140181,'古交市',140100 union
select 231,140201,'市辖区',140200 union
select 232,140202,'城 区',140200 union
select 233,140203,'矿 区',140200 union
select 234,140211,'南郊区',140200 union
select 235,140212,'新荣区',140200 union
select 236,140221,'阳高县',140200 union
select 237,140222,'天镇县',140200 union
select 238,140223,'广灵县',140200 union
select 239,140224,'灵丘县',140200 union
select 240,140225,'浑源县',140200 union
select 241,140226,'左云县',140200 union
select 242,140227,'大同县',140200 union
select 243,140301,'市辖区',140300 union
select 244,140302,'城 区',140300 union
select 245,140303,'矿 区',140300 union
select 246,140311,'郊 区',140300 union
select 247,140321,'平定县',140300 union
select 248,140322,'盂 县',140300 union
select 249,140401,'市辖区',140400 union
select 250,140402,'城 区',140400 union
select 251,140411,'郊 区',140400 union
select 252,140421,'长治县',140400 union
select 253,140423,'襄垣县',140400 union
select 254,140424,'屯留县',140400 union
select 255,140425,'平顺县',140400 union
select 256,140426,'黎城县',140400 union
select 257,140427,'壶关县',140400 union
select 258,140428,'长子县',140400 union
select 259,140429,'武乡县',140400 union
select 260,140430,'沁 县',140400 union
select 261,140431,'沁源县',140400 union
select 262,140481,'潞城市',140400 union
select 263,140501,'市辖区',140500 union
select 264,140502,'城 区',140500 union
select 265,140521,'沁水县',140500 union
select 266,140522,'阳城县',140500 union
select 267,140524,'陵川县',140500 union
select 268,140525,'泽州县',140500 union
select 269,140581,'高平市',140500 union
select 270,140601,'市辖区',140600 union
select 271,140602,'朔城区',140600 union
select 272,140603,'平鲁区',140600 union
select 273,140621,'山阴县',140600 union
select 274,140622,'应 县',140600 union
select 275,140623,'右玉县',140600 union
select 276,140624,'怀仁县',140600 union
select 277,140701,'市辖区',140700 union
select 278,140702,'榆次区',140700 union
select 279,140721,'榆社县',140700 union
select 280,140722,'左权县',140700 union
select 281,140723,'和顺县',140700 union
select 282,140724,'昔阳县',140700 union
select 283,140725,'寿阳县',140700 union
select 284,140726,'太谷县',140700 union
select 285,140727,'祁 县',140700 union
select 286,140728,'平遥县',140700 union
select 287,140729,'灵石县',140700 union
select 288,140781,'介休市',140700 union
select 289,140801,'市辖区',140800 union
select 290,140802,'盐湖区',140800 union
select 291,140821,'临猗县',140800 union
select 292,140822,'万荣县',140800 union
select 293,140823,'闻喜县',140800 union
select 294,140824,'稷山县',140800 union
select 295,140825,'新绛县',140800 union
select 296,140826,'绛 县',140800 union
select 297,140827,'垣曲县',140800 union
select 298,140828,'夏 县',140800 union
select 299,140829,'平陆县',140800 union
select 300,140830,'芮城县',140800 union
select 301,140881,'永济市',140800 union
select 302,140882,'河津市',140800 union
select 303,140901,'市辖区',140900 union
select 304,140902,'忻府区',140900 union
select 305,140921,'定襄县',140900 union
select 306,140922,'五台县',140900 union
select 307,140923,'代 县',140900 union
select 308,140924,'繁峙县',140900 union
select 309,140925,'宁武县',140900 union
select 310,140926,'静乐县',140900 union
select 311,140927,'神池县',140900 union
select 312,140928,'五寨县',140900 union
select 313,140929,'岢岚县',140900 union
select 314,140930,'河曲县',140900 union
select 315,140931,'保德县',140900 union
select 316,140932,'偏关县',140900 union
select 317,140981,'原平市',140900 union
select 318,141001,'市辖区',141000 union
select 319,141002,'尧都区',141000 union
select 320,141021,'曲沃县',141000 union
select 321,141022,'翼城县',141000 union
select 322,141023,'襄汾县',141000 union
select 323,141024,'洪洞县',141000 union
select 324,141025,'古 县',141000 union
select 325,141026,'安泽县',141000 union
select 326,141027,'浮山县',141000 union
select 327,141028,'吉 县',141000 union
select 328,141029,'乡宁县',141000 union
select 329,141030,'大宁县',141000 union
select 330,141031,'隰 县',141000 union
select 331,141032,'永和县',141000 union
select 332,141033,'蒲 县',141000 union
select 333,141034,'汾西县',141000 union
select 334,141081,'侯马市',141000 union
select 335,141082,'霍州市',141000 union
select 336,141101,'市辖区',141100 union
select 337,141102,'离石区',141100 union
select 338,141121,'文水县',141100 union
select 339,141122,'交城县',141100 union
select 340,141123,'兴 县',141100 union
select 341,141124,'临 县',141100 union
select 342,141125,'柳林县',141100 union
select 343,141126,'石楼县',141100 union
select 344,141127,'岚 县',141100 union
select 345,141128,'方山县',141100 union
select 346,141129,'中阳县',141100 union
select 347,141130,'交口县',141100 union
select 348,141181,'孝义市',141100 union
select 349,141182,'汾阳市',141100 union
select 350,150101,'市辖区',150100 union
select 351,150102,'新城区',150100 union
select 352,150103,'回民区',150100 union
select 353,150104,'玉泉区',150100 union
select 354,150105,'赛罕区',150100 union
select 355,150121,'土默特左旗',150100 union
select 356,150122,'托克托县',150100 union
select 357,150123,'和林格尔县',150100 union
select 358,150124,'清水河县',150100 union
select 359,150125,'武川县',150100 union
select 360,150201,'市辖区',150200 union
select 361,150202,'东河区',150200 union
select 362,150203,'昆都仑区',150200 union
select 363,150204,'青山区',150200 union
select 364,150205,'石拐区',150200 union
select 365,150206,'白云矿区',150200 union
select 366,150207,'九原区',150200 union
select 367,150221,'土默特右旗',150200 union
select 368,150222,'固阳县',150200 union
select 369,150223,'达尔罕茂明安联合旗',150200 union
select 370,150301,'市辖区',150300 union
select 371,150302,'海勃湾区',150300 union
select 372,150303,'海南区',150300 union
select 373,150304,'乌达区',150300 union
select 374,150401,'市辖区',150400 union
select 375,150402,'红山区',150400 union
select 376,150403,'元宝山区',150400 union
select 377,150404,'松山区',150400 union
select 378,150421,'阿鲁科尔沁旗',150400 union
select 379,150422,'巴林左旗',150400 union
select 380,150423,'巴林右旗',150400 union
select 381,150424,'林西县',150400 union
select 382,150425,'克什克腾旗',150400 union
select 383,150426,'翁牛特旗',150400 union
select 384,150428,'喀喇沁旗',150400 union
select 385,150429,'宁城县',150400 union
select 386,150430,'敖汉旗',150400 union
select 387,150501,'市辖区',150500 union
select 388,150502,'科尔沁区',150500 union
select 389,150521,'科尔沁左翼中旗',150500 union
select 390,150522,'科尔沁左翼后旗',150500 union
select 391,150523,'开鲁县',150500 union
select 392,150524,'库伦旗',150500 union
select 393,150525,'奈曼旗',150500 union
select 394,150526,'扎鲁特旗',150500 union
select 395,150581,'霍林郭勒市',150500 union
select 396,150602,'东胜区',150600 union
select 397,150621,'达拉特旗',150600 union
select 398,150622,'准格尔旗',150600 union
select 399,150623,'鄂托克前旗',150600 union
select 400,150624,'鄂托克旗',150600 union
select 401,150625,'杭锦旗',150600 union
select 402,150626,'乌审旗',150600 union
select 403,150627,'伊金霍洛旗',150600 union
select 404,150701,'市辖区',150700 union
select 405,150702,'海拉尔区',150700 union
select 406,150721,'阿荣旗',150700 union
select 407,150722,'莫力达瓦达斡尔族自治旗',150700 union
select 408,150723,'鄂伦春自治旗',150700 union
select 409,150724,'鄂温克族自治旗',150700 union
select 410,150725,'陈巴尔虎旗',150700 union
select 411,150726,'新巴尔虎左旗',150700 union
select 412,150727,'新巴尔虎右旗',150700 union
select 413,150781,'满洲里市',150700 union
select 414,150782,'牙克石市',150700 union
select 415,150783,'扎兰屯市',150700 union
select 416,150784,'额尔古纳市',150700 union
select 417,150785,'根河市',150700 union
select 418,150801,'市辖区',150800 union
select 419,150802,'临河区',150800 union
select 420,150821,'五原县',150800 union
select 421,150822,'磴口县',150800 union
select 422,150823,'乌拉特前旗',150800 union
select 423,150824,'乌拉特中旗',150800 union
select 424,150825,'乌拉特后旗',150800 union
select 425,150826,'杭锦后旗',150800 union
select 426,150901,'市辖区',150900 union
select 427,150902,'集宁区',150900 union
select 428,150921,'卓资县',150900 union
select 429,150922,'化德县',150900 union
select 430,150923,'商都县',150900 union
select 431,150924,'兴和县',150900 union
select 432,150925,'凉城县',150900 union
select 433,150926,'察哈尔右翼前旗',150900 union
select 434,150927,'察哈尔右翼中旗',150900 union
select 435,150928,'察哈尔右翼后旗',150900 union
select 436,150929,'四子王旗',150900 union
select 437,150981,'丰镇市',150900 union
select 438,152201,'乌兰浩特市',152200 union
select 439,152202,'阿尔山市',152200 union
select 440,152221,'科尔沁右翼前旗',152200 union
select 441,152222,'科尔沁右翼中旗',152200 union
select 442,152223,'扎赉特旗',152200 union
select 443,152224,'突泉县',152200 union
select 444,152501,'二连浩特市',152500 union
select 445,152502,'锡林浩特市',152500 union
select 446,152522,'阿巴嘎旗',152500 union
select 447,152523,'苏尼特左旗',152500 union
select 448,152524,'苏尼特右旗',152500 union
select 449,152525,'东乌珠穆沁旗',152500 union
select 450,152526,'西乌珠穆沁旗',152500 union
select 451,152527,'太仆寺旗',152500 union
select 452,152528,'镶黄旗',152500 union
select 453,152529,'正镶白旗',152500 union
select 454,152530,'正蓝旗',152500 union
select 455,152531,'多伦县',152500 union
select 456,152921,'阿拉善左旗',152900 union
select 457,152922,'阿拉善右旗',152900 union
select 458,152923,'额济纳旗',152900 union
select 459,210101,'市辖区',210100 union
select 460,210102,'和平区',210100 union
select 461,210103,'沈河区',210100 union
select 462,210104,'大东区',210100 union
select 463,210105,'皇姑区',210100 union
select 464,210106,'铁西区',210100 union
select 465,210111,'苏家屯区',210100 union
select 466,210112,'东陵区',210100 union
select 467,210113,'新城子区',210100 union
select 468,210114,'于洪区',210100 union
select 469,210122,'辽中县',210100 union
select 470,210123,'康平县',210100 union
select 471,210124,'法库县',210100 union
select 472,210181,'新民市',210100 union
select 473,210201,'市辖区',210200 union
select 474,210202,'中山区',210200 union
select 475,210203,'西岗区',210200 union
select 476,210204,'沙河口区',210200 union
select 477,210211,'甘井子区',210200 union
select 478,210212,'旅顺口区',210200 union
select 479,210213,'金州区',210200 union
select 480,210224,'长海县',210200 union
select 481,210281,'瓦房店市',210200 union
select 482,210282,'普兰店市',210200 union
select 483,210283,'庄河市',210200 union
select 484,210301,'市辖区',210300 union
select 485,210302,'铁东区',210300 union
select 486,210303,'铁西区',210300 union
select 487,210304,'立山区',210300 union
select 488,210311,'千山区',210300 union
select 489,210321,'台安县',210300 union
select 490,210323,'岫岩满族自治县',210300 union
select 491,210381,'海城市',210300 union
select 492,210401,'市辖区',210400 union
select 493,210402,'新抚区',210400 union
select 494,210403,'东洲区',210400 union
select 495,210404,'望花区',210400 union
select 496,210411,'顺城区',210400 union
select 497,210421,'抚顺县',210400 union
select 498,210422,'新宾满族自治县',210400 union
select 499,210423,'清原满族自治县',210400 union
select 500,210501,'市辖区',210500 union
select 501,210502,'平山区',210500 union
select 502,210503,'溪湖区',210500 union
select 503,210504,'明山区',210500 union
select 504,210505,'南芬区',210500 union
select 505,210521,'本溪满族自治县',210500 union
select 506,210522,'桓仁满族自治县',210500 union
select 507,210601,'市辖区',210600 union
select 508,210602,'元宝区',210600 union
select 509,210603,'振兴区',210600 union
select 510,210604,'振安区',210600 union
select 511,210624,'宽甸满族自治县',210600 union
select 512,210681,'东港市',210600 union
select 513,210682,'凤城市',210600 union
select 514,210701,'市辖区',210700 union
select 515,210702,'古塔区',210700 union
select 516,210703,'凌河区',210700 union
select 517,210711,'太和区',210700 union
select 518,210726,'黑山县',210700 union
select 519,210727,'义 县',210700 union
select 520,210781,'凌海市',210700 union
select 521,210782,'北宁市',210700 union
select 522,210801,'市辖区',210800 union
select 523,210802,'站前区',210800 union
select 524,210803,'西市区',210800 union
select 525,210804,'鲅鱼圈区',210800 union
select 526,210811,'老边区',210800 union
select 527,210881,'盖州市',210800 union
select 528,210882,'大石桥市',210800 union
select 529,210901,'市辖区',210900 union
select 530,210902,'海州区',210900 union
select 531,210903,'新邱区',210900 union
select 532,210904,'太平区',210900 union
select 533,210905,'清河门区',210900 union
select 534,210911,'细河区',210900 union
select 535,210921,'阜新蒙古族自治县',210900 union
select 536,210922,'彰武县',210900 union
select 537,211001,'市辖区',211000 union
select 538,211002,'白塔区',211000 union
select 539,211003,'文圣区',211000 union
select 540,211004,'宏伟区',211000 union
select 541,211005,'弓长岭区',211000 union
select 542,211011,'太子河区',211000 union
select 543,211021,'辽阳县',211000 union
select 544,211081,'灯塔市',211000 union
select 545,211101,'市辖区',211100 union
select 546,211102,'双台子区',211100 union
select 547,211103,'兴隆台区',211100 union
select 548,211121,'大洼县',211100 union
select 549,211122,'盘山县',211100 union
select 550,211201,'市辖区',211200 union
select 551,211202,'银州区',211200 union
select 552,211204,'清河区',211200 union
select 553,211221,'铁岭县',211200 union
select 554,211223,'西丰县',211200 union
select 555,211224,'昌图县',211200 union
select 556,211281,'调兵山市',211200 union
select 557,211282,'开原市',211200 union
select 558,211301,'市辖区',211300 union
select 559,211302,'双塔区',211300 union
select 560,211303,'龙城区',211300 union
select 561,211321,'朝阳县',211300 union
select 562,211322,'建平县',211300 union
select 563,211324,'喀喇沁左翼蒙古族自治县',211300 union
select 564,211381,'北票市',211300 union
select 565,211382,'凌源市',211300 union
select 566,211401,'市辖区',211400 union
select 567,211402,'连山区',211400 union
select 568,211403,'龙港区',211400 union
select 569,211404,'南票区',211400 union
select 570,211421,'绥中县',211400 union
select 571,211422,'建昌县',211400 union
select 572,211481,'兴城市',211400 union
select 573,220101,'市辖区',220100 union
select 574,220102,'南关区',220100 union
select 575,220103,'宽城区',220100 union
select 576,220104,'朝阳区',220100 union
select 577,220105,'二道区',220100 union
select 578,220106,'绿园区',220100 union
select 579,220112,'双阳区',220100 union
select 580,220122,'农安县',220100 union
select 581,220181,'九台市',220100 union
select 582,220182,'榆树市',220100 union
select 583,220183,'德惠市',220100 union
select 584,220201,'市辖区',220200 union
select 585,220202,'昌邑区',220200 union
select 586,220203,'龙潭区',220200 union
select 587,220204,'船营区',220200 union
select 588,220211,'丰满区',220200 union
select 589,220221,'永吉县',220200 union
select 590,220281,'蛟河市',220200 union
select 591,220282,'桦甸市',220200 union
select 592,220283,'舒兰市',220200 union
select 593,220284,'磐石市',220200 union
select 594,220301,'市辖区',220300 union
select 595,220302,'铁西区',220300 union
select 596,220303,'铁东区',220300 union
select 597,220322,'梨树县',220300 union
select 598,220323,'伊通满族自治县',220300 union
select 599,220381,'公主岭市',220300 union
select 600,220382,'双辽市',220300 union
select 601,220401,'市辖区',220400 union
select 602,220402,'龙山区',220400 union
select 603,220403,'西安区',220400 union
select 604,220421,'东丰县',220400 union
select 605,220422,'东辽县',220400 union
select 606,220501,'市辖区',220500 union
select 607,220502,'东昌区',220500 union
select 608,220503,'二道江区',220500 union
select 609,220521,'通化县',220500 union
select 610,220523,'辉南县',220500 union
select 611,220524,'柳河县',220500 union
select 612,220581,'梅河口市',220500 union
select 613,220582,'集安市',220500 union
select 614,220601,'市辖区',220600 union
select 615,220602,'八道江区',220600 union
select 616,220621,'抚松县',220600 union
select 617,220622,'靖宇县',220600 union
select 618,220623,'长白朝鲜族自治县',220600 union
select 619,220625,'江源县',220600 union
select 620,220681,'临江市',220600 union
select 621,220701,'市辖区',220700 union
select 622,220702,'宁江区',220700 union
select 623,220721,'前郭尔罗斯蒙古族自治县',220700 union
select 624,220722,'长岭县',220700 union
select 625,220723,'乾安县',220700 union
select 626,220724,'扶余县',220700 union
select 627,220801,'市辖区',220800 union
select 628,220802,'洮北区',220800 union
select 629,220821,'镇赉县',220800 union
select 630,220822,'通榆县',220800 union
select 631,220881,'洮南市',220800 union
select 632,220882,'大安市',220800 union
select 633,222401,'延吉市',222400 union
select 634,222402,'图们市',222400 union
select 635,222403,'敦化市',222400 union
select 636,222404,'珲春市',222400 union
select 637,222405,'龙井市',222400 union
select 638,222406,'和龙市',222400 union
select 639,222424,'汪清县',222400 union
select 640,222426,'安图县',222400 union
select 641,230101,'市辖区',230100 union
select 642,230102,'道里区',230100 union
select 643,230103,'南岗区',230100 union
select 644,230104,'道外区',230100 union
select 645,230106,'香坊区',230100 union
select 646,230107,'动力区',230100 union
select 647,230108,'平房区',230100 union
select 648,230109,'松北区',230100 union
select 649,230111,'呼兰区',230100 union
select 650,230123,'依兰县',230100 union
select 651,230124,'方正县',230100 union
select 652,230125,'宾 县',230100 union
select 653,230126,'巴彦县',230100 union
select 654,230127,'木兰县',230100 union
select 655,230128,'通河县',230100 union
select 656,230129,'延寿县',230100 union
select 657,230181,'阿城市',230100 union
select 658,230182,'双城市',230100 union
select 659,230183,'尚志市',230100 union
select 660,230184,'五常市',230100 union
select 661,230201,'市辖区',230200 union
select 662,230202,'龙沙区',230200 union
select 663,230203,'建华区',230200 union
select 664,230204,'铁锋区',230200 union
select 665,230205,'昂昂溪区',230200 union
select 666,230206,'富拉尔基区',230200 union
select 667,230207,'碾子山区',230200 union
select 668,230208,'梅里斯达斡尔族区',230200 union
select 669,230221,'龙江县',230200 union
select 670,230223,'依安县',230200 union
select 671,230224,'泰来县',230200 union
select 672,230225,'甘南县',230200 union
select 673,230227,'富裕县',230200 union
select 674,230229,'克山县',230200 union
select 675,230230,'克东县',230200 union
select 676,230231,'拜泉县',230200 union
select 677,230281,'讷河市',230200 union
select 678,230301,'市辖区',230300 union
select 679,230302,'鸡冠区',230300 union
select 680,230303,'恒山区',230300 union
select 681,230304,'滴道区',230300 union
select 682,230305,'梨树区',230300 union
select 683,230306,'城子河区',230300 union
select 684,230307,'麻山区',230300 union
select 685,230321,'鸡东县',230300 union
select 686,230381,'虎林市',230300 union
select 687,230382,'密山市',230300 union
select 688,230401,'市辖区',230400 union
select 689,230402,'向阳区',230400 union
select 690,230403,'工农区',230400 union
select 691,230404,'南山区',230400 union
select 692,230405,'兴安区',230400 union
select 693,230406,'东山区',230400 union
select 694,230407,'兴山区',230400 union
select 695,230421,'萝北县',230400 union
select 696,230422,'绥滨县',230400 union
select 697,230501,'市辖区',230500 union
select 698,230502,'尖山区',230500 union
select 699,230503,'岭东区',230500 union
select 700,230505,'四方台区',230500 union
select 701,230506,'宝山区',230500 union
select 702,230521,'集贤县',230500 union
select 703,230522,'友谊县',230500 union
select 704,230523,'宝清县',230500 union
select 705,230524,'饶河县',230500 union
select 706,230601,'市辖区',230600 union
select 707,230602,'萨尔图区',230600 union
select 708,230603,'龙凤区',230600 union
select 709,230604,'让胡路区',230600 union
select 710,230605,'红岗区',230600 union
select 711,230606,'大同区',230600 union
select 712,230621,'肇州县',230600 union
select 713,230622,'肇源县',230600 union
select 714,230623,'林甸县',230600 union
select 715,230624,'杜尔伯特蒙古族自治县',230600 union
select 716,230701,'市辖区',230700 union
select 717,230702,'伊春区',230700 union
select 718,230703,'南岔区',230700 union
select 719,230704,'友好区',230700 union
select 720,230705,'西林区',230700 union
select 721,230706,'翠峦区',230700 union
select 722,230707,'新青区',230700 union
select 723,230708,'美溪区',230700 union
select 724,230709,'金山屯区',230700 union
select 725,230710,'五营区',230700 union
select 726,230711,'乌马河区',230700 union
select 727,230712,'汤旺河区',230700 union
select 728,230713,'带岭区',230700 union
select 729,230714,'乌伊岭区',230700 union
select 730,230715,'红星区',230700 union
select 731,230716,'上甘岭区',230700 union
select 732,230722,'嘉荫县',230700 union
select 733,230781,'铁力市',230700 union
select 734,230801,'市辖区',230800 union
select 735,230802,'永红区',230800 union
select 736,230803,'向阳区',230800 union
select 737,230804,'前进区',230800 union
select 738,230805,'东风区',230800 union
select 739,230811,'郊 区',230800 union
select 740,230822,'桦南县',230800 union
select 741,230826,'桦川县',230800 union
select 742,230828,'汤原县',230800 union
select 743,230833,'抚远县',230800 union
select 744,230881,'同江市',230800 union
select 745,230882,'富锦市',230800 union
select 746,230901,'市辖区',230900 union
select 747,230902,'新兴区',230900 union
select 748,230903,'桃山区',230900 union
select 749,230904,'茄子河区',230900 union
select 750,230921,'勃利县',230900 union
select 751,231001,'市辖区',231000 union
select 752,231002,'东安区',231000 union
select 753,231003,'阳明区',231000 union
select 754,231004,'爱民区',231000 union
select 755,231005,'西安区',231000 union
select 756,231024,'东宁县',231000 union
select 757,231025,'林口县',231000 union
select 758,231081,'绥芬河市',231000 union
select 759,231083,'海林市',231000 union
select 760,231084,'宁安市',231000 union
select 761,231085,'穆棱市',231000 union
select 762,231101,'市辖区',231100 union
select 763,231102,'爱辉区',231100 union
select 764,231121,'嫩江县',231100 union
select 765,231123,'逊克县',231100 union
select 766,231124,'孙吴县',231100 union
select 767,231181,'北安市',231100 union
select 768,231182,'五大连池市',231100 union
select 769,231201,'市辖区',231200 union
select 770,231202,'北林区',231200 union
select 771,231221,'望奎县',231200 union
select 772,231222,'兰西县',231200 union
select 773,231223,'青冈县',231200 union
select 774,231224,'庆安县',231200 union
select 775,231225,'明水县',231200 union
select 776,231226,'绥棱县',231200 union
select 777,231281,'安达市',231200 union
select 778,231282,'肇东市',231200 union
select 779,231283,'海伦市',231200 union
select 780,232721,'呼玛县',232700 union
select 781,232722,'塔河县',232700 union
select 782,232723,'漠河县',232700 union
select 783,310101,'黄浦区',310100 union
select 784,310103,'卢湾区',310100 union
select 785,310104,'徐汇区',310100 union
select 786,310105,'长宁区',310100 union
select 787,310106,'静安区',310100 union
select 788,310107,'普陀区',310100 union
select 789,310108,'闸北区',310100 union
select 790,310109,'虹口区',310100 union
select 791,310110,'杨浦区',310100 union
select 792,310112,'闵行区',310100 union
select 793,310113,'宝山区',310100 union
select 794,310114,'嘉定区',310100 union
select 795,310115,'浦东新区',310100 union
select 796,310116,'金山区',310100 union
select 797,310117,'松江区',310100 union
select 798,310118,'青浦区',310100 union
select 799,310119,'南汇区',310100 union
select 800,310120,'奉贤区',310100 union
select 801,310230,'崇明县',310200 union
select 802,320101,'市辖区',320100 union
select 803,320102,'玄武区',320100 union
select 804,320103,'白下区',320100 union
select 805,320104,'秦淮区',320100 union
select 806,320105,'建邺区',320100 union
select 807,320106,'鼓楼区',320100 union
select 808,320107,'下关区',320100 union
select 809,320111,'浦口区',320100 union
select 810,320113,'栖霞区',320100 union
select 811,320114,'雨花台区',320100 union
select 812,320115,'江宁区',320100 union
select 813,320116,'六合区',320100 union
select 814,320124,'溧水县',320100 union
select 815,320125,'高淳县',320100 union
select 816,320201,'市辖区',320200 union
select 817,320202,'崇安区',320200 union
select 818,320203,'南长区',320200 union
select 819,320204,'北塘区',320200 union
select 820,320205,'锡山区',320200 union
select 821,320206,'惠山区',320200 union
select 822,320211,'滨湖区',320200 union
select 823,320281,'江阴市',320200 union
select 824,320282,'宜兴市',320200 union
select 825,320301,'市辖区',320300 union
select 826,320302,'鼓楼区',320300 union
select 827,320303,'云龙区',320300 union
select 828,320304,'九里区',320300 union
select 829,320305,'贾汪区',320300 union
select 830,320311,'泉山区',320300 union
select 831,320321,'丰 县',320300 union
select 832,320322,'沛 县',320300 union
select 833,320323,'铜山县',320300 union
select 834,320324,'睢宁县',320300 union
select 835,320381,'新沂市',320300 union
select 836,320382,'邳州市',320300 union
select 837,320401,'市辖区',320400 union
select 838,320402,'天宁区',320400 union
select 839,320404,'钟楼区',320400 union
select 840,320405,'戚墅堰区',320400 union
select 841,320411,'新北区',320400 union
select 842,320412,'武进区',320400 union
select 843,320481,'溧阳市',320400 union
select 844,320482,'金坛市',320400 union
select 845,320501,'市辖区',320500 union
select 846,320502,'沧浪区',320500 union
select 847,320503,'平江区',320500 union
select 848,320504,'金阊区',320500 union
select 849,320505,'虎丘区',320500 union
select 850,320506,'吴中区',320500 union
select 851,320507,'相城区',320500 union
select 852,320581,'常熟市',320500 union
select 853,320582,'张家港市',320500 union
select 854,320583,'昆山市',320500 union
select 855,320584,'吴江市',320500 union
select 856,320585,'太仓市',320500 union
select 857,320601,'市辖区',320600 union
select 858,320602,'崇川区',320600 union
select 859,320611,'港闸区',320600 union
select 860,320621,'海安县',320600 union
select 861,320623,'如东县',320600 union
select 862,320681,'启东市',320600 union
select 863,320682,'如皋市',320600 union
select 864,320683,'通州市',320600 union
select 865,320684,'海门市',320600 union
select 866,320701,'市辖区',320700 union
select 867,320703,'连云区',320700 union
select 868,320705,'新浦区',320700 union
select 869,320706,'海州区',320700 union
select 870,320721,'赣榆县',320700 union
select 871,320722,'东海县',320700 union
select 872,320723,'灌云县',320700 union
select 873,320724,'灌南县',320700 union
select 874,320801,'市辖区',320800 union
select 875,320802,'清河区',320800 union
select 876,320803,'楚州区',320800 union
select 877,320804,'淮阴区',320800 union
select 878,320811,'清浦区',320800 union
select 879,320826,'涟水县',320800 union
select 880,320829,'洪泽县',320800 union
select 881,320830,'盱眙县',320800 union
select 882,320831,'金湖县',320800 union
select 883,320901,'市辖区',320900 union
select 884,320902,'亭湖区',320900 union
select 885,320903,'盐都区',320900 union
select 886,320921,'响水县',320900 union
select 887,320922,'滨海县',320900 union
select 888,320923,'阜宁县',320900 union
select 889,320924,'射阳县',320900 union
select 890,320925,'建湖县',320900 union
select 891,320981,'东台市',320900 union
select 892,320982,'大丰市',320900 union
select 893,321001,'市辖区',321000 union
select 894,321002,'广陵区',321000 union
select 895,321003,'邗江区',321000 union
select 896,321011,'郊 区',321000 union
select 897,321023,'宝应县',321000 union
select 898,321081,'仪征市',321000 union
select 899,321084,'高邮市',321000 union
select 900,321088,'江都市',321000 union
select 901,321101,'市辖区',321100 union
select 902,321102,'京口区',321100 union
select 903,321111,'润州区',321100 union
select 904,321112,'丹徒区',321100 union
select 905,321181,'丹阳市',321100 union
select 906,321182,'扬中市',321100 union
select 907,321183,'句容市',321100 union
select 908,321201,'市辖区',321200 union
select 909,321202,'海陵区',321200 union
select 910,321203,'高港区',321200 union
select 911,321281,'兴化市',321200 union
select 912,321282,'靖江市',321200 union
select 913,321283,'泰兴市',321200 union
select 914,321284,'姜堰市',321200 union
select 915,321301,'市辖区',321300 union
select 916,321302,'宿城区',321300 union
select 917,321311,'宿豫区',321300 union
select 918,321322,'沭阳县',321300 union
select 919,321323,'泗阳县',321300 union
select 920,321324,'泗洪县',321300 union
select 921,330101,'市辖区',330100 union
select 922,330102,'上城区',330100 union
select 923,330103,'下城区',330100 union
select 924,330104,'江干区',330100 union
select 925,330105,'拱墅区',330100 union
select 926,330106,'西湖区',330100 union
select 927,330108,'滨江区',330100 union
select 928,330109,'萧山区',330100 union
select 929,330110,'余杭区',330100 union
select 930,330122,'桐庐县',330100 union
select 931,330127,'淳安县',330100 union
select 932,330182,'建德市',330100 union
select 933,330183,'富阳市',330100 union
select 934,330185,'临安市',330100 union
select 935,330201,'市辖区',330200 union
select 936,330203,'海曙区',330200 union
select 937,330204,'江东区',330200 union
select 938,330205,'江北区',330200 union
select 939,330206,'北仑区',330200 union
select 940,330211,'镇海区',330200 union
select 941,330212,'鄞州区',330200 union
select 942,330225,'象山县',330200 union
select 943,330226,'宁海县',330200 union
select 944,330281,'余姚市',330200 union
select 945,330282,'慈溪市',330200 union
select 946,330283,'奉化市',330200 union
select 947,330301,'市辖区',330300 union
select 948,330302,'鹿城区',330300 union
select 949,330303,'龙湾区',330300 union
select 950,330304,'瓯海区',330300 union
select 951,330322,'洞头县',330300 union
select 952,330324,'永嘉县',330300 union
select 953,330326,'平阳县',330300 union
select 954,330327,'苍南县',330300 union
select 955,330328,'文成县',330300 union
select 956,330329,'泰顺县',330300 union
select 957,330381,'瑞安市',330300 union
select 958,330382,'乐清市',330300 union
select 959,330401,'市辖区',330400 union
select 960,330402,'秀城区',330400 union
select 961,330411,'秀洲区',330400 union
select 962,330421,'嘉善县',330400 union
select 963,330424,'海盐县',330400 union
select 964,330481,'海宁市',330400 union
select 965,330482,'平湖市',330400 union
select 966,330483,'桐乡市',330400 union
select 967,330501,'市辖区',330500 union
select 968,330502,'吴兴区',330500 union
select 969,330503,'南浔区',330500 union
select 970,330521,'德清县',330500 union
select 971,330522,'长兴县',330500 union
select 972,330523,'安吉县',330500 union
select 973,330601,'市辖区',330600 union
select 974,330602,'越城区',330600 union
select 975,330621,'绍兴县',330600 union
select 976,330624,'新昌县',330600 union
select 977,330681,'诸暨市',330600 union
select 978,330682,'上虞市',330600 union
select 979,330683,'嵊州市',330600 union
select 980,330701,'市辖区',330700 union
select 981,330702,'婺城区',330700 union
select 982,330703,'金东区',330700 union
select 983,330723,'武义县',330700 union
select 984,330726,'浦江县',330700 union
select 985,330727,'磐安县',330700 union
select 986,330781,'兰溪市',330700 union
select 987,330782,'义乌市',330700 union
select 988,330783,'东阳市',330700 union
select 989,330784,'永康市',330700 union
select 990,330801,'市辖区',330800 union
select 991,330802,'柯城区',330800 union
select 992,330803,'衢江区',330800 union
select 993,330822,'常山县',330800 union
select 994,330824,'开化县',330800 union
select 995,330825,'龙游县',330800 union
select 996,330881,'江山市',330800 union
select 997,330901,'市辖区',330900 union
select 998,330902,'定海区',330900 union
select 999,330903,'普陀区',330900 union
select 1000,330921,'岱山县',330900 union
select 1001,330922,'嵊泗县',330900 union
select 1002,331001,'市辖区',331000 union
select 1003,331002,'椒江区',331000 union
select 1004,331003,'黄岩区',331000 union
select 1005,331004,'路桥区',331000 union
select 1006,331021,'玉环县',331000 union
select 1007,331022,'三门县',331000 union
select 1008,331023,'天台县',331000 union
select 1009,331024,'仙居县',331000 union
select 1010,331081,'温岭市',331000 union
select 1011,331082,'临海市',331000 union
select 1012,331101,'市辖区',331100 union
select 1013,331102,'莲都区',331100 union
select 1014,331121,'青田县',331100 union
select 1015,331122,'缙云县',331100 union
select 1016,331123,'遂昌县',331100 union
select 1017,331124,'松阳县',331100 union
select 1018,331125,'云和县',331100 union
select 1019,331126,'庆元县',331100 union
select 1020,331127,'景宁畲族自治县',331100 union
select 1021,331181,'龙泉市',331100 union
select 1022,340101,'市辖区',340100 union
select 1023,340102,'瑶海区',340100 union
select 1024,340103,'庐阳区',340100 union
select 1025,340104,'蜀山区',340100 union
select 1026,340111,'包河区',340100 union
select 1027,340121,'长丰县',340100 union
select 1028,340122,'肥东县',340100 union
select 1029,340123,'肥西县',340100 union
select 1030,340201,'市辖区',340200 union
select 1031,340202,'镜湖区',340200 union
select 1032,340203,'马塘区',340200 union
select 1033,340204,'新芜区',340200 union
select 1034,340207,'鸠江区',340200 union
select 1035,340221,'芜湖县',340200 union
select 1036,340222,'繁昌县',340200 union
select 1037,340223,'南陵县',340200 union
select 1038,340301,'市辖区',340300 union
select 1039,340302,'龙子湖区',340300 union
select 1040,340303,'蚌山区',340300 union
select 1041,340304,'禹会区',340300 union
select 1042,340311,'淮上区',340300 union
select 1043,340321,'怀远县',340300 union
select 1044,340322,'五河县',340300 union
select 1045,340323,'固镇县',340300 union
select 1046,340401,'市辖区',340400 union
select 1047,340402,'大通区',340400 union
select 1048,340403,'田家庵区',340400 union
select 1049,340404,'谢家集区',340400 union
select 1050,340405,'八公山区',340400 union
select 1051,340406,'潘集区',340400 union
select 1052,340421,'凤台县',340400 union
select 1053,340501,'市辖区',340500 union
select 1054,340502,'金家庄区',340500 union
select 1055,340503,'花山区',340500 union
select 1056,340504,'雨山区',340500 union
select 1057,340521,'当涂县',340500 union
select 1058,340601,'市辖区',340600 union
select 1059,340602,'杜集区',340600 union
select 1060,340603,'相山区',340600 union
select 1061,340604,'烈山区',340600 union
select 1062,340621,'濉溪县',340600 union
select 1063,340701,'市辖区',340700 union
select 1064,340702,'铜官山区',340700 union
select 1065,340703,'狮子山区',340700 union
select 1066,340711,'郊 区',340700 union
select 1067,340721,'铜陵县',340700 union
select 1068,340801,'市辖区',340800 union
select 1069,340802,'迎江区',340800 union
select 1070,340803,'大观区',340800 union
select 1071,340811,'郊 区',340800 union
select 1072,340822,'怀宁县',340800 union
select 1073,340823,'枞阳县',340800 union
select 1074,340824,'潜山县',340800 union
select 1075,340825,'太湖县',340800 union
select 1076,340826,'宿松县',340800 union
select 1077,340827,'望江县',340800 union
select 1078,340828,'岳西县',340800 union
select 1079,340881,'桐城市',340800 union
select 1080,341001,'市辖区',341000 union
select 1081,341002,'屯溪区',341000 union
select 1082,341003,'黄山区',341000 union
select 1083,341004,'徽州区',341000 union
select 1084,341021,'歙 县',341000 union
select 1085,341022,'休宁县',341000 union
select 1086,341023,'黟 县',341000 union
select 1087,341024,'祁门县',341000 union
select 1088,341101,'市辖区',341100 union
select 1089,341102,'琅琊区',341100 union
select 1090,341103,'南谯区',341100 union
select 1091,341122,'来安县',341100 union
select 1092,341124,'全椒县',341100 union
select 1093,341125,'定远县',341100 union
select 1094,341126,'凤阳县',341100 union
select 1095,341181,'天长市',341100 union
select 1096,341182,'明光市',341100 union
select 1097,341201,'市辖区',341200 union
select 1098,341202,'颍州区',341200 union
select 1099,341203,'颍东区',341200 union
select 1100,341204,'颍泉区',341200 union
select 1101,341221,'临泉县',341200 union
select 1102,341222,'太和县',341200 union
select 1103,341225,'阜南县',341200 union
select 1104,341226,'颍上县',341200 union
select 1105,341282,'界首市',341200 union
select 1106,341301,'市辖区',341300 union
select 1107,341302,'墉桥区',341300 union
select 1108,341321,'砀山县',341300 union
select 1109,341322,'萧 县',341300 union
select 1110,341323,'灵璧县',341300 union
select 1111,341324,'泗 县',341300 union
select 1112,341401,'市辖区',341400 union
select 1113,341402,'居巢区',341400 union
select 1114,341421,'庐江县',341400 union
select 1115,341422,'无为县',341400 union
select 1116,341423,'含山县',341400 union
select 1117,341424,'和 县',341400 union
select 1118,341501,'市辖区',341500 union
select 1119,341502,'金安区',341500 union
select 1120,341503,'裕安区',341500 union
select 1121,341521,'寿 县',341500 union
select 1122,341522,'霍邱县',341500 union
select 1123,341523,'舒城县',341500 union
select 1124,341524,'金寨县',341500 union
select 1125,341525,'霍山县',341500 union
select 1126,341601,'市辖区',341600 union
select 1127,341602,'谯城区',341600 union
select 1128,341621,'涡阳县',341600 union
select 1129,341622,'蒙城县',341600 union
select 1130,341623,'利辛县',341600 union
select 1131,341701,'市辖区',341700 union
select 1132,341702,'贵池区',341700 union
select 1133,341721,'东至县',341700 union
select 1134,341722,'石台县',341700 union
select 1135,341723,'青阳县',341700 union
select 1136,341801,'市辖区',341800 union
select 1137,341802,'宣州区',341800 union
select 1138,341821,'郎溪县',341800 union
select 1139,341822,'广德县',341800 union
select 1140,341823,'泾 县',341800 union
select 1141,341824,'绩溪县',341800 union
select 1142,341825,'旌德县',341800 union
select 1143,341881,'宁国市',341800 union
select 1144,350101,'市辖区',350100 union
select 1145,350102,'鼓楼区',350100 union
select 1146,350103,'台江区',350100 union
select 1147,350104,'仓山区',350100 union
select 1148,350105,'马尾区',350100 union
select 1149,350111,'晋安区',350100 union
select 1150,350121,'闽侯县',350100 union
select 1151,350122,'连江县',350100 union
select 1152,350123,'罗源县',350100 union
select 1153,350124,'闽清县',350100 union
select 1154,350125,'永泰县',350100 union
select 1155,350128,'平潭县',350100 union
select 1156,350181,'福清市',350100 union
select 1157,350182,'长乐市',350100 union
select 1158,350201,'市辖区',350200 union
select 1159,350203,'思明区',350200 union
select 1160,350205,'海沧区',350200 union
select 1161,350206,'湖里区',350200 union
select 1162,350211,'集美区',350200 union
select 1163,350212,'同安区',350200 union
select 1164,350213,'翔安区',350200 union
select 1165,350301,'市辖区',350300 union
select 1166,350302,'城厢区',350300 union
select 1167,350303,'涵江区',350300 union
select 1168,350304,'荔城区',350300 union
select 1169,350305,'秀屿区',350300 union
select 1170,350322,'仙游县',350300 union
select 1171,350401,'市辖区',350400 union
select 1172,350402,'梅列区',350400 union
select 1173,350403,'三元区',350400 union
select 1174,350421,'明溪县',350400 union
select 1175,350423,'清流县',350400 union
select 1176,350424,'宁化县',350400 union
select 1177,350425,'大田县',350400 union
select 1178,350426,'尤溪县',350400 union
select 1179,350427,'沙 县',350400 union
select 1180,350428,'将乐县',350400 union
select 1181,350429,'泰宁县',350400 union
select 1182,350430,'建宁县',350400 union
select 1183,350481,'永安市',350400 union
select 1184,350501,'市辖区',350500 union
select 1185,350502,'鲤城区',350500 union
select 1186,350503,'丰泽区',350500 union
select 1187,350504,'洛江区',350500 union
select 1188,350505,'泉港区',350500 union
select 1189,350521,'惠安县',350500 union
select 1190,350524,'安溪县',350500 union
select 1191,350525,'永春县',350500 union
select 1192,350526,'德化县',350500 union
select 1193,350527,'金门县',350500 union
select 1194,350581,'石狮市',350500 union
select 1195,350582,'晋江市',350500 union
select 1196,350583,'南安市',350500 union
select 1197,350601,'市辖区',350600 union
select 1198,350602,'芗城区',350600 union
select 1199,350603,'龙文区',350600 union
select 1200,350622,'云霄县',350600 union
select 1201,350623,'漳浦县',350600 union
select 1202,350624,'诏安县',350600 union
select 1203,350625,'长泰县',350600 union
select 1204,350626,'东山县',350600 union
select 1205,350627,'南靖县',350600 union
select 1206,350628,'平和县',350600 union
select 1207,350629,'华安县',350600 union
select 1208,350681,'龙海市',350600 union
select 1209,350701,'市辖区',350700 union
select 1210,350702,'延平区',350700 union
select 1211,350721,'顺昌县',350700 union
select 1212,350722,'浦城县',350700 union
select 1213,350723,'光泽县',350700 union
select 1214,350724,'松溪县',350700 union
select 1215,350725,'政和县',350700 union
select 1216,350781,'邵武市',350700 union
select 1217,350782,'武夷山市',350700 union
select 1218,350783,'建瓯市',350700 union
select 1219,350784,'建阳市',350700 union
select 1220,350801,'市辖区',350800 union
select 1221,350802,'新罗区',350800 union
select 1222,350821,'长汀县',350800 union
select 1223,350822,'永定县',350800 union
select 1224,350823,'上杭县',350800 union
select 1225,350824,'武平县',350800 union
select 1226,350825,'连城县',350800 union
select 1227,350881,'漳平市',350800 union
select 1228,350901,'市辖区',350900 union
select 1229,350902,'蕉城区',350900 union
select 1230,350921,'霞浦县',350900 union
select 1231,350922,'古田县',350900 union
select 1232,350923,'屏南县',350900 union
select 1233,350924,'寿宁县',350900 union
select 1234,350925,'周宁县',350900 union
select 1235,350926,'柘荣县',350900 union
select 1236,350981,'福安市',350900 union
select 1237,350982,'福鼎市',350900 union
select 1238,360101,'市辖区',360100 union
select 1239,360102,'东湖区',360100 union
select 1240,360103,'西湖区',360100 union
select 1241,360104,'青云谱区',360100 union
select 1242,360105,'湾里区',360100 union
select 1243,360111,'青山湖区',360100 union
select 1244,360121,'南昌县',360100 union
select 1245,360122,'新建县',360100 union
select 1246,360123,'安义县',360100 union
select 1247,360124,'进贤县',360100 union
select 1248,360201,'市辖区',360200 union
select 1249,360202,'昌江区',360200 union
select 1250,360203,'珠山区',360200 union
select 1251,360222,'浮梁县',360200 union
select 1252,360281,'乐平市',360200 union
select 1253,360301,'市辖区',360300 union
select 1254,360302,'安源区',360300 union
select 1255,360313,'湘东区',360300 union
select 1256,360321,'莲花县',360300 union
select 1257,360322,'上栗县',360300 union
select 1258,360323,'芦溪县',360300 union
select 1259,360401,'市辖区',360400 union
select 1260,360402,'庐山区',360400 union
select 1261,360403,'浔阳区',360400 union
select 1262,360421,'九江县',360400 union
select 1263,360423,'武宁县',360400 union
select 1264,360424,'修水县',360400 union
select 1265,360425,'永修县',360400 union
select 1266,360426,'德安县',360400 union
select 1267,360427,'星子县',360400 union
select 1268,360428,'都昌县',360400 union
select 1269,360429,'湖口县',360400 union
select 1270,360430,'彭泽县',360400 union
select 1271,360481,'瑞昌市',360400 union
select 1272,360501,'市辖区',360500 union
select 1273,360502,'渝水区',360500 union
select 1274,360521,'分宜县',360500 union
select 1275,360601,'市辖区',360600 union
select 1276,360602,'月湖区',360600 union
select 1277,360622,'余江县',360600 union
select 1278,360681,'贵溪市',360600 union
select 1279,360701,'市辖区',360700 union
select 1280,360702,'章贡区',360700 union
select 1281,360721,'赣 县',360700 union
select 1282,360722,'信丰县',360700 union
select 1283,360723,'大余县',360700 union
select 1284,360724,'上犹县',360700 union
select 1285,360725,'崇义县',360700 union
select 1286,360726,'安远县',360700 union
select 1287,360727,'龙南县',360700 union
select 1288,360728,'定南县',360700 union
select 1289,360729,'全南县',360700 union
select 1290,360730,'宁都县',360700 union
select 1291,360731,'于都县',360700 union
select 1292,360732,'兴国县',360700 union
select 1293,360733,'会昌县',360700 union
select 1294,360734,'寻乌县',360700 union
select 1295,360735,'石城县',360700 union
select 1296,360781,'瑞金市',360700 union
select 1297,360782,'南康市',360700 union
select 1298,360801,'市辖区',360800 union
select 1299,360802,'吉州区',360800 union
select 1300,360803,'青原区',360800 union
select 1301,360821,'吉安县',360800 union
select 1302,360822,'吉水县',360800 union
select 1303,360823,'峡江县',360800 union
select 1304,360824,'新干县',360800 union
select 1305,360825,'永丰县',360800 union
select 1306,360826,'泰和县',360800 union
select 1307,360827,'遂川县',360800 union
select 1308,360828,'万安县',360800 union
select 1309,360829,'安福县',360800 union
select 1310,360830,'永新县',360800 union
select 1311,360881,'井冈山市',360800 union
select 1312,360901,'市辖区',360900 union
select 1313,360902,'袁州区',360900 union
select 1314,360921,'奉新县',360900 union
select 1315,360922,'万载县',360900 union
select 1316,360923,'上高县',360900 union
select 1317,360924,'宜丰县',360900 union
select 1318,360925,'靖安县',360900 union
select 1319,360926,'铜鼓县',360900 union
select 1320,360981,'丰城市',360900 union
select 1321,360982,'樟树市',360900 union
select 1322,360983,'高安市',360900 union
select 1323,361001,'市辖区',361000 union
select 1324,361002,'临川区',361000 union
select 1325,361021,'南城县',361000 union
select 1326,361022,'黎川县',361000 union
select 1327,361023,'南丰县',361000 union
select 1328,361024,'崇仁县',361000 union
select 1329,361025,'乐安县',361000 union
select 1330,361026,'宜黄县',361000 union
select 1331,361027,'金溪县',361000 union
select 1332,361028,'资溪县',361000 union
select 1333,361029,'东乡县',361000 union
select 1334,361030,'广昌县',361000 union
select 1335,361101,'市辖区',361100 union
select 1336,361102,'信州区',361100 union
select 1337,361121,'上饶县',361100 union
select 1338,361122,'广丰县',361100 union
select 1339,361123,'玉山县',361100 union
select 1340,361124,'铅山县',361100 union
select 1341,361125,'横峰县',361100 union
select 1342,361126,'弋阳县',361100 union
select 1343,361127,'余干县',361100 union
select 1344,361128,'鄱阳县',361100 union
select 1345,361129,'万年县',361100 union
select 1346,361130,'婺源县',361100 union
select 1347,361181,'德兴市',361100 union
select 1348,370101,'市辖区',370100 union
select 1349,370102,'历下区',370100 union
select 1350,370103,'市中区',370100 union
select 1351,370104,'槐荫区',370100 union
select 1352,370105,'天桥区',370100 union
select 1353,370112,'历城区',370100 union
select 1354,370113,'长清区',370100 union
select 1355,370124,'平阴县',370100 union
select 1356,370125,'济阳县',370100 union
select 1357,370126,'商河县',370100 union
select 1358,370181,'章丘市',370100 union
select 1359,370201,'市辖区',370200 union
select 1360,370202,'市南区',370200 union
select 1361,370203,'市北区',370200 union
select 1362,370205,'四方区',370200 union
select 1363,370211,'黄岛区',370200 union
select 1364,370212,'崂山区',370200 union
select 1365,370213,'李沧区',370200 union
select 1366,370214,'城阳区',370200 union
select 1367,370281,'胶州市',370200 union
select 1368,370282,'即墨市',370200 union
select 1369,370283,'平度市',370200 union
select 1370,370284,'胶南市',370200 union
select 1371,370285,'莱西市',370200 union
select 1372,370301,'市辖区',370300 union
select 1373,370302,'淄川区',370300 union
select 1374,370303,'张店区',370300 union
select 1375,370304,'博山区',370300 union
select 1376,370305,'临淄区',370300 union
select 1377,370306,'周村区',370300 union
select 1378,370321,'桓台县',370300 union
select 1379,370322,'高青县',370300 union
select 1380,370323,'沂源县',370300 union
select 1381,370401,'市辖区',370400 union
select 1382,370402,'市中区',370400 union
select 1383,370403,'薛城区',370400 union
select 1384,370404,'峄城区',370400 union
select 1385,370405,'台儿庄区',370400 union
select 1386,370406,'山亭区',370400 union
select 1387,370481,'滕州市',370400 union
select 1388,370501,'市辖区',370500 union
select 1389,370502,'东营区',370500 union
select 1390,370503,'河口区',370500 union
select 1391,370521,'垦利县',370500 union
select 1392,370522,'利津县',370500 union
select 1393,370523,'广饶县',370500 union
select 1394,370601,'市辖区',370600 union
select 1395,370602,'芝罘区',370600 union
select 1396,370611,'福山区',370600 union
select 1397,370612,'牟平区',370600 union
select 1398,370613,'莱山区',370600 union
select 1399,370634,'长岛县',370600 union
select 1400,370681,'龙口市',370600 union
select 1401,370682,'莱阳市',370600 union
select 1402,370683,'莱州市',370600 union
select 1403,370684,'蓬莱市',370600 union
select 1404,370685,'招远市',370600 union
select 1405,370686,'栖霞市',370600 union
select 1406,370687,'海阳市',370600 union
select 1407,370701,'市辖区',370700 union
select 1408,370702,'潍城区',370700 union
select 1409,370703,'寒亭区',370700 union
select 1410,370704,'坊子区',370700 union
select 1411,370705,'奎文区',370700 union
select 1412,370724,'临朐县',370700 union
select 1413,370725,'昌乐县',370700 union
select 1414,370781,'青州市',370700 union
select 1415,370782,'诸城市',370700 union
select 1416,370783,'寿光市',370700 union
select 1417,370784,'安丘市',370700 union
select 1418,370785,'高密市',370700 union
select 1419,370786,'昌邑市',370700 union
select 1420,370801,'市辖区',370800 union
select 1421,370802,'市中区',370800 union
select 1422,370811,'任城区',370800 union
select 1423,370826,'微山县',370800 union
select 1424,370827,'鱼台县',370800 union
select 1425,370828,'金乡县',370800 union
select 1426,370829,'嘉祥县',370800 union
select 1427,370830,'汶上县',370800 union
select 1428,370831,'泗水县',370800 union
select 1429,370832,'梁山县',370800 union
select 1430,370881,'曲阜市',370800 union
select 1431,370882,'兖州市',370800 union
select 1432,370883,'邹城市',370800 union
select 1433,370901,'市辖区',370900

INSERT INTO area (id,areaID,area,fatherID)
select 1434,370902,'泰山区',370900 union
select 1435,370903,'岱岳区',370900 union
select 1436,370921,'宁阳县',370900 union
select 1437,370923,'东平县',370900 union
select 1438,370982,'新泰市',370900 union
select 1439,370983,'肥城市',370900 union
select 1440,371001,'市辖区',371000 union
select 1441,371002,'环翠区',371000 union
select 1442,371081,'文登市',371000 union
select 1443,371082,'荣成市',371000 union
select 1444,371083,'乳山市',371000 union
select 1445,371101,'市辖区',371100 union
select 1446,371102,'东港区',371100 union
select 1447,371103,'岚山区',371100 union
select 1448,371121,'五莲县',371100 union
select 1449,371122,'莒 县',371100 union
select 1450,371201,'市辖区',371200 union
select 1451,371202,'莱城区',371200 union
select 1452,371203,'钢城区',371200 union
select 1453,371301,'市辖区',371300 union
select 1454,371302,'兰山区',371300 union
select 1455,371311,'罗庄区',371300 union
select 1456,371312,'河东区',371300 union
select 1457,371321,'沂南县',371300 union
select 1458,371322,'郯城县',371300 union
select 1459,371323,'沂水县',371300 union
select 1460,371324,'苍山县',371300 union
select 1461,371325,'费 县',371300 union
select 1462,371326,'平邑县',371300 union
select 1463,371327,'莒南县',371300 union
select 1464,371328,'蒙阴县',371300 union
select 1465,371329,'临沭县',371300 union
select 1466,371401,'市辖区',371400 union
select 1467,371402,'德城区',371400 union
select 1468,371421,'陵 县',371400 union
select 1469,371422,'宁津县',371400 union
select 1470,371423,'庆云县',371400 union
select 1471,371424,'临邑县',371400 union
select 1472,371425,'齐河县',371400 union
select 1473,371426,'平原县',371400 union
select 1474,371427,'夏津县',371400 union
select 1475,371428,'武城县',371400 union
select 1476,371481,'乐陵市',371400 union
select 1477,371482,'禹城市',371400 union
select 1478,371501,'市辖区',371500 union
select 1479,371502,'东昌府区',371500 union
select 1480,371521,'阳谷县',371500 union
select 1481,371522,'莘 县',371500 union
select 1482,371523,'茌平县',371500 union
select 1483,371524,'东阿县',371500 union
select 1484,371525,'冠 县',371500 union
select 1485,371526,'高唐县',371500 union
select 1486,371581,'临清市',371500 union
select 1487,371601,'市辖区',371600 union
select 1488,371602,'滨城区',371600 union
select 1489,371621,'惠民县',371600 union
select 1490,371622,'阳信县',371600 union
select 1491,371623,'无棣县',371600 union
select 1492,371624,'沾化县',371600 union
select 1493,371625,'博兴县',371600 union
select 1494,371626,'邹平县',371600 union
select 1495,371701,'市辖区',371700 union
select 1496,371702,'牡丹区',371700 union
select 1497,371721,'曹 县',371700 union
select 1498,371722,'单 县',371700 union
select 1499,371723,'成武县',371700 union
select 1500,371724,'巨野县',371700 union
select 1501,371725,'郓城县',371700 union
select 1502,371726,'鄄城县',371700 union
select 1503,371727,'定陶县',371700 union
select 1504,371728,'东明县',371700 union
select 1505,410101,'市辖区',410100 union
select 1506,410102,'中原区',410100 union
select 1507,410103,'二七区',410100 union
select 1508,410104,'管城回族区',410100 union
select 1509,410105,'金水区',410100 union
select 1510,410106,'上街区',410100 union
select 1511,410108,'邙山区',410100 union
select 1512,410122,'中牟县',410100 union
select 1513,410181,'巩义市',410100 union
select 1514,410182,'荥阳市',410100 union
select 1515,410183,'新密市',410100 union
select 1516,410184,'新郑市',410100 union
select 1517,410185,'登封市',410100 union
select 1518,410201,'市辖区',410200 union
select 1519,410202,'龙亭区',410200 union
select 1520,410203,'顺河回族区',410200 union
select 1521,410204,'鼓楼区',410200 union
select 1522,410205,'南关区',410200 union
select 1523,410211,'郊 区',410200 union
select 1524,410221,'杞 县',410200 union
select 1525,410222,'通许县',410200 union
select 1526,410223,'尉氏县',410200 union
select 1527,410224,'开封县',410200 union
select 1528,410225,'兰考县',410200 union
select 1529,410301,'市辖区',410300 union
select 1530,410302,'老城区',410300 union
select 1531,410303,'西工区',410300 union
select 1532,410304,'廛河回族区',410300 union
select 1533,410305,'涧西区',410300 union
select 1534,410306,'吉利区',410300 union
select 1535,410307,'洛龙区',410300 union
select 1536,410322,'孟津县',410300 union
select 1537,410323,'新安县',410300 union
select 1538,410324,'栾川县',410300 union
select 1539,410325,'嵩 县',410300 union
select 1540,410326,'汝阳县',410300 union
select 1541,410327,'宜阳县',410300 union
select 1542,410328,'洛宁县',410300 union
select 1543,410329,'伊川县',410300 union
select 1544,410381,'偃师市',410300 union
select 1545,410401,'市辖区',410400 union
select 1546,410402,'新华区',410400 union
select 1547,410403,'卫东区',410400 union
select 1548,410404,'石龙区',410400 union
select 1549,410411,'湛河区',410400 union
select 1550,410421,'宝丰县',410400 union
select 1551,410422,'叶 县',410400 union
select 1552,410423,'鲁山县',410400 union
select 1553,410425,'郏 县',410400 union
select 1554,410481,'舞钢市',410400 union
select 1555,410482,'汝州市',410400 union
select 1556,410501,'市辖区',410500 union
select 1557,410502,'文峰区',410500 union
select 1558,410503,'北关区',410500 union
select 1559,410505,'殷都区',410500 union
select 1560,410506,'龙安区',410500 union
select 1561,410522,'安阳县',410500 union
select 1562,410523,'汤阴县',410500 union
select 1563,410526,'滑 县',410500 union
select 1564,410527,'内黄县',410500 union
select 1565,410581,'林州市',410500 union
select 1566,410601,'市辖区',410600 union
select 1567,410602,'鹤山区',410600 union
select 1568,410603,'山城区',410600 union
select 1569,410611,'淇滨区',410600 union
select 1570,410621,'浚 县',410600 union
select 1571,410622,'淇 县',410600 union
select 1572,410701,'市辖区',410700 union
select 1573,410702,'红旗区',410700 union
select 1574,410703,'卫滨区',410700 union
select 1575,410704,'凤泉区',410700 union
select 1576,410711,'牧野区',410700 union
select 1577,410721,'新乡县',410700 union
select 1578,410724,'获嘉县',410700 union
select 1579,410725,'原阳县',410700 union
select 1580,410726,'延津县',410700 union
select 1581,410727,'封丘县',410700 union
select 1582,410728,'长垣县',410700 union
select 1583,410781,'卫辉市',410700 union
select 1584,410782,'辉县市',410700 union
select 1585,410801,'市辖区',410800 union
select 1586,410802,'解放区',410800 union
select 1587,410803,'中站区',410800 union
select 1588,410804,'马村区',410800 union
select 1589,410811,'山阳区',410800 union
select 1590,410821,'修武县',410800 union
select 1591,410822,'博爱县',410800 union
select 1592,410823,'武陟县',410800 union
select 1593,410825,'温 县',410800 union
select 1594,410881,'济源市',410800 union
select 1595,410882,'沁阳市',410800 union
select 1596,410883,'孟州市',410800 union
select 1597,410901,'市辖区',410900 union
select 1598,410902,'华龙区',410900 union
select 1599,410922,'清丰县',410900 union
select 1600,410923,'南乐县',410900 union
select 1601,410926,'范 县',410900 union
select 1602,410927,'台前县',410900 union
select 1603,410928,'濮阳县',410900 union
select 1604,411001,'市辖区',411000 union
select 1605,411002,'魏都区',411000 union
select 1606,411023,'许昌县',411000 union
select 1607,411024,'鄢陵县',411000 union
select 1608,411025,'襄城县',411000 union
select 1609,411081,'禹州市',411000 union
select 1610,411082,'长葛市',411000 union
select 1611,411101,'市辖区',411100 union
select 1612,411102,'源汇区',411100 union
select 1613,411103,'郾城区',411100 union
select 1614,411104,'召陵区',411100 union
select 1615,411121,'舞阳县',411100 union
select 1616,411122,'临颍县',411100 union
select 1617,411201,'市辖区',411200 union
select 1618,411202,'湖滨区',411200 union
select 1619,411221,'渑池县',411200 union
select 1620,411222,'陕 县',411200 union
select 1621,411224,'卢氏县',411200 union
select 1622,411281,'义马市',411200 union
select 1623,411282,'灵宝市',411200 union
select 1624,411301,'市辖区',411300 union
select 1625,411302,'宛城区',411300 union
select 1626,411303,'卧龙区',411300 union
select 1627,411321,'南召县',411300 union
select 1628,411322,'方城县',411300 union
select 1629,411323,'西峡县',411300 union
select 1630,411324,'镇平县',411300 union
select 1631,411325,'内乡县',411300 union
select 1632,411326,'淅川县',411300 union
select 1633,411327,'社旗县',411300 union
select 1634,411328,'唐河县',411300 union
select 1635,411329,'新野县',411300 union
select 1636,411330,'桐柏县',411300 union
select 1637,411381,'邓州市',411300 union
select 1638,411401,'市辖区',411400 union
select 1639,411402,'梁园区',411400 union
select 1640,411403,'睢阳区',411400 union
select 1641,411421,'民权县',411400 union
select 1642,411422,'睢 县',411400 union
select 1643,411423,'宁陵县',411400 union
select 1644,411424,'柘城县',411400 union
select 1645,411425,'虞城县',411400 union
select 1646,411426,'夏邑县',411400 union
select 1647,411481,'永城市',411400 union
select 1648,411501,'市辖区',411500 union
select 1649,411502,'师河区',411500 union
select 1650,411503,'平桥区',411500 union
select 1651,411521,'罗山县',411500 union
select 1652,411522,'光山县',411500 union
select 1653,411523,'新 县',411500 union
select 1654,411524,'商城县',411500 union
select 1655,411525,'固始县',411500 union
select 1656,411526,'潢川县',411500 union
select 1657,411527,'淮滨县',411500 union
select 1658,411528,'息 县',411500 union
select 1659,411601,'市辖区',411600 union
select 1660,411602,'川汇区',411600 union
select 1661,411621,'扶沟县',411600 union
select 1662,411622,'西华县',411600 union
select 1663,411623,'商水县',411600 union
select 1664,411624,'沈丘县',411600 union
select 1665,411625,'郸城县',411600 union
select 1666,411626,'淮阳县',411600 union
select 1667,411627,'太康县',411600 union
select 1668,411628,'鹿邑县',411600 union
select 1669,411681,'项城市',411600 union
select 1670,411701,'市辖区',411700 union
select 1671,411702,'驿城区',411700 union
select 1672,411721,'西平县',411700 union
select 1673,411722,'上蔡县',411700 union
select 1674,411723,'平舆县',411700 union
select 1675,411724,'正阳县',411700 union
select 1676,411725,'确山县',411700 union
select 1677,411726,'泌阳县',411700 union
select 1678,411727,'汝南县',411700 union
select 1679,411728,'遂平县',411700 union
select 1680,411729,'新蔡县',411700 union
select 1681,420101,'市辖区',420100 union
select 1682,420102,'江岸区',420100 union
select 1683,420103,'江汉区',420100 union
select 1684,420104,'乔口区',420100 union
select 1685,420105,'汉阳区',420100 union
select 1686,420106,'武昌区',420100 union
select 1687,420107,'青山区',420100 union
select 1688,420111,'洪山区',420100 union
select 1689,420112,'东西湖区',420100 union
select 1690,420113,'汉南区',420100 union
select 1691,420114,'蔡甸区',420100 union
select 1692,420115,'江夏区',420100 union
select 1693,420116,'黄陂区',420100 union
select 1694,420117,'新洲区',420100 union
select 1695,420201,'市辖区',420200 union
select 1696,420202,'黄石港区',420200 union
select 1697,420203,'西塞山区',420200 union
select 1698,420204,'下陆区',420200 union
select 1699,420205,'铁山区',420200 union
select 1700,420222,'阳新县',420200 union
select 1701,420281,'大冶市',420200 union
select 1702,420301,'市辖区',420300 union
select 1703,420302,'茅箭区',420300 union
select 1704,420303,'张湾区',420300 union
select 1705,420321,'郧 县',420300 union
select 1706,420322,'郧西县',420300 union
select 1707,420323,'竹山县',420300 union
select 1708,420324,'竹溪县',420300 union
select 1709,420325,'房 县',420300 union
select 1710,420381,'丹江口市',420300 union
select 1711,420501,'市辖区',420500 union
select 1712,420502,'西陵区',420500 union
select 1713,420503,'伍家岗区',420500 union
select 1714,420504,'点军区',420500 union
select 1715,420505,'猇亭区',420500 union
select 1716,420506,'夷陵区',420500 union
select 1717,420525,'远安县',420500 union
select 1718,420526,'兴山县',420500 union
select 1719,420527,'秭归县',420500 union
select 1720,420528,'长阳土家族自治县',420500 union
select 1721,420529,'五峰土家族自治县',420500 union
select 1722,420581,'宜都市',420500 union
select 1723,420582,'当阳市',420500 union
select 1724,420583,'枝江市',420500 union
select 1725,420601,'市辖区',420600 union
select 1726,420602,'襄城区',420600 union
select 1727,420606,'樊城区',420600 union
select 1728,420607,'襄阳区',420600 union
select 1729,420624,'南漳县',420600 union
select 1730,420625,'谷城县',420600 union
select 1731,420626,'保康县',420600 union
select 1732,420682,'老河口市',420600 union
select 1733,420683,'枣阳市',420600 union
select 1734,420684,'宜城市',420600 union
select 1735,420701,'市辖区',420700 union
select 1736,420702,'梁子湖区',420700 union
select 1737,420703,'华容区',420700 union
select 1738,420704,'鄂城区',420700 union
select 1739,420801,'市辖区',420800 union
select 1740,420802,'东宝区',420800 union
select 1741,420804,'掇刀区',420800 union
select 1742,420821,'京山县',420800 union
select 1743,420822,'沙洋县',420800 union
select 1744,420881,'钟祥市',420800 union
select 1745,420901,'市辖区',420900 union
select 1746,420902,'孝南区',420900 union
select 1747,420921,'孝昌县',420900 union
select 1748,420922,'大悟县',420900 union
select 1749,420923,'云梦县',420900 union
select 1750,420981,'应城市',420900 union
select 1751,420982,'安陆市',420900 union
select 1752,420984,'汉川市',420900 union
select 1753,421001,'市辖区',421000 union
select 1754,421002,'沙市区',421000 union
select 1755,421003,'荆州区',421000 union
select 1756,421022,'公安县',421000 union
select 1757,421023,'监利县',421000 union
select 1758,421024,'江陵县',421000 union
select 1759,421081,'石首市',421000 union
select 1760,421083,'洪湖市',421000 union
select 1761,421087,'松滋市',421000 union
select 1762,421101,'市辖区',421100 union
select 1763,421102,'黄州区',421100 union
select 1764,421121,'团风县',421100 union
select 1765,421122,'红安县',421100 union
select 1766,421123,'罗田县',421100 union
select 1767,421124,'英山县',421100 union
select 1768,421125,'浠水县',421100 union
select 1769,421126,'蕲春县',421100 union
select 1770,421127,'黄梅县',421100 union
select 1771,421181,'麻城市',421100 union
select 1772,421182,'武穴市',421100 union
select 1773,421201,'市辖区',421200 union
select 1774,421202,'咸安区',421200 union
select 1775,421221,'嘉鱼县',421200 union
select 1776,421222,'通城县',421200 union
select 1777,421223,'崇阳县',421200 union
select 1778,421224,'通山县',421200 union
select 1779,421281,'赤壁市',421200 union
select 1780,421301,'市辖区',421300 union
select 1781,421302,'曾都区',421300 union
select 1782,421381,'广水市',421300 union
select 1783,422801,'恩施市',422800 union
select 1784,422802,'利川市',422800 union
select 1785,422822,'建始县',422800 union
select 1786,422823,'巴东县',422800 union
select 1787,422825,'宣恩县',422800 union
select 1788,422826,'咸丰县',422800 union
select 1789,422827,'来凤县',422800 union
select 1790,422828,'鹤峰县',422800 union
select 1791,429004,'仙桃市',429000 union
select 1792,429005,'潜江市',429000 union
select 1793,429006,'天门市',429000 union
select 1794,429021,'神农架林区',429000 union
select 1795,430101,'市辖区',430100 union
select 1796,430102,'芙蓉区',430100 union
select 1797,430103,'天心区',430100 union
select 1798,430104,'岳麓区',430100 union
select 1799,430105,'开福区',430100 union
select 1800,430111,'雨花区',430100 union
select 1801,430121,'长沙县',430100 union
select 1802,430122,'望城县',430100 union
select 1803,430124,'宁乡县',430100 union
select 1804,430181,'浏阳市',430100 union
select 1805,430201,'市辖区',430200 union
select 1806,430202,'荷塘区',430200 union
select 1807,430203,'芦淞区',430200 union
select 1808,430204,'石峰区',430200 union
select 1809,430211,'天元区',430200 union
select 1810,430221,'株洲县',430200 union
select 1811,430223,'攸 县',430200 union
select 1812,430224,'茶陵县',430200 union
select 1813,430225,'炎陵县',430200 union
select 1814,430281,'醴陵市',430200 union
select 1815,430301,'市辖区',430300 union
select 1816,430302,'雨湖区',430300 union
select 1817,430304,'岳塘区',430300 union
select 1818,430321,'湘潭县',430300 union
select 1819,430381,'湘乡市',430300 union
select 1820,430382,'韶山市',430300 union
select 1821,430401,'市辖区',430400 union
select 1822,430405,'珠晖区',430400 union
select 1823,430406,'雁峰区',430400 union
select 1824,430407,'石鼓区',430400 union
select 1825,430408,'蒸湘区',430400 union
select 1826,430412,'南岳区',430400 union
select 1827,430421,'衡阳县',430400 union
select 1828,430422,'衡南县',430400 union
select 1829,430423,'衡山县',430400 union
select 1830,430424,'衡东县',430400 union
select 1831,430426,'祁东县',430400 union
select 1832,430481,'耒阳市',430400 union
select 1833,430482,'常宁市',430400 union
select 1834,430501,'市辖区',430500 union
select 1835,430502,'双清区',430500 union
select 1836,430503,'大祥区',430500 union
select 1837,430511,'北塔区',430500 union
select 1838,430521,'邵东县',430500 union
select 1839,430522,'新邵县',430500 union
select 1840,430523,'邵阳县',430500 union
select 1841,430524,'隆回县',430500 union
select 1842,430525,'洞口县',430500 union
select 1843,430527,'绥宁县',430500 union
select 1844,430528,'新宁县',430500 union
select 1845,430529,'城步苗族自治县',430500 union
select 1846,430581,'武冈市',430500 union
select 1847,430601,'市辖区',430600 union
select 1848,430602,'岳阳楼区',430600 union
select 1849,430603,'云溪区',430600 union
select 1850,430611,'君山区',430600 union
select 1851,430621,'岳阳县',430600 union
select 1852,430623,'华容县',430600 union
select 1853,430624,'湘阴县',430600 union
select 1854,430626,'平江县',430600 union
select 1855,430681,'汨罗市',430600 union
select 1856,430682,'临湘市',430600 union
select 1857,430701,'市辖区',430700 union
select 1858,430702,'武陵区',430700 union
select 1859,430703,'鼎城区',430700 union
select 1860,430721,'安乡县',430700 union
select 1861,430722,'汉寿县',430700 union
select 1862,430723,'澧 县',430700 union
select 1863,430724,'临澧县',430700 union
select 1864,430725,'桃源县',430700 union
select 1865,430726,'石门县',430700 union
select 1866,430781,'津市市',430700 union
select 1867,430801,'市辖区',430800 union
select 1868,430802,'永定区',430800 union
select 1869,430811,'武陵源区',430800 union
select 1870,430821,'慈利县',430800 union
select 1871,430822,'桑植县',430800 union
select 1872,430901,'市辖区',430900 union
select 1873,430902,'资阳区',430900 union
select 1874,430903,'赫山区',430900 union
select 1875,430921,'南 县',430900 union
select 1876,430922,'桃江县',430900 union
select 1877,430923,'安化县',430900 union
select 1878,430981,'沅江市',430900 union
select 1879,431001,'市辖区',431000 union
select 1880,431002,'北湖区',431000 union
select 1881,431003,'苏仙区',431000 union
select 1882,431021,'桂阳县',431000 union
select 1883,431022,'宜章县',431000 union
select 1884,431023,'永兴县',431000 union
select 1885,431024,'嘉禾县',431000 union
select 1886,431025,'临武县',431000 union
select 1887,431026,'汝城县',431000 union
select 1888,431027,'桂东县',431000 union
select 1889,431028,'安仁县',431000 union
select 1890,431081,'资兴市',431000 union
select 1891,431101,'市辖区',431100 union
select 1892,431102,'芝山区',431100 union
select 1893,431103,'冷水滩区',431100 union
select 1894,431121,'祁阳县',431100 union
select 1895,431122,'东安县',431100 union
select 1896,431123,'双牌县',431100 union
select 1897,431124,'道 县',431100 union
select 1898,431125,'江永县',431100 union
select 1899,431126,'宁远县',431100 union
select 1900,431127,'蓝山县',431100 union
select 1901,431128,'新田县',431100 union
select 1902,431129,'江华瑶族自治县',431100 union
select 1903,431201,'市辖区',431200 union
select 1904,431202,'鹤城区',431200 union
select 1905,431221,'中方县',431200 union
select 1906,431222,'沅陵县',431200 union
select 1907,431223,'辰溪县',431200 union
select 1908,431224,'溆浦县',431200 union
select 1909,431225,'会同县',431200 union
select 1910,431226,'麻阳苗族自治县',431200 union
select 1911,431227,'新晃侗族自治县',431200 union
select 1912,431228,'芷江侗族自治县',431200 union
select 1913,431229,'靖州苗族侗族自治县',431200 union
select 1914,431230,'通道侗族自治县',431200 union
select 1915,431281,'洪江市',431200 union
select 1916,431301,'市辖区',431300 union
select 1917,431302,'娄星区',431300 union
select 1918,431321,'双峰县',431300 union
select 1919,431322,'新化县',431300 union
select 1920,431381,'冷水江市',431300 union
select 1921,431382,'涟源市',431300 union
select 1922,433101,'吉首市',433100 union
select 1923,433122,'泸溪县',433100 union
select 1924,433123,'凤凰县',433100 union
select 1925,433124,'花垣县',433100 union
select 1926,433125,'保靖县',433100 union
select 1927,433126,'古丈县',433100 union
select 1928,433127,'永顺县',433100 union
select 1929,433130,'龙山县',433100 union
select 1930,440101,'市辖区',440100 union
select 1931,440102,'东山区',440100 union
select 1932,440103,'荔湾区',440100 union
select 1933,440104,'越秀区',440100 union
select 1934,440105,'海珠区',440100 union
select 1935,440106,'天河区',440100 union
select 1936,440107,'芳村区',440100 union
select 1937,440111,'白云区',440100 union
select 1938,440112,'黄埔区',440100 union
select 1939,440113,'番禺区',440100 union
select 1940,440114,'花都区',440100 union
select 1941,440183,'增城市',440100 union
select 1942,440184,'从化市',440100 union
select 1943,440201,'市辖区',440200 union
select 1944,440203,'武江区',440200 union
select 1945,440204,'浈江区',440200 union
select 1946,440205,'曲江区',440200 union
select 1947,440222,'始兴县',440200 union
select 1948,440224,'仁化县',440200 union
select 1949,440229,'翁源县',440200 union
select 1950,440232,'乳源瑶族自治县',440200 union
select 1951,440233,'新丰县',440200 union
select 1952,440281,'乐昌市',440200 union
select 1953,440282,'南雄市',440200 union
select 1954,440301,'市辖区',440300 union
select 1955,440303,'罗湖区',440300 union
select 1956,440304,'福田区',440300 union
select 1957,440305,'南山区',440300 union
select 1958,440306,'宝安区',440300 union
select 1959,440307,'龙岗区',440300 union
select 1960,440308,'盐田区',440300 union
select 1961,440401,'市辖区',440400 union
select 1962,440402,'香洲区',440400 union
select 1963,440403,'斗门区',440400 union
select 1964,440404,'金湾区',440400 union
select 1965,440501,'市辖区',440500 union
select 1966,440507,'龙湖区',440500 union
select 1967,440511,'金平区',440500 union
select 1968,440512,'濠江区',440500 union
select 1969,440513,'潮阳区',440500 union
select 1970,440514,'潮南区',440500 union
select 1971,440515,'澄海区',440500 union
select 1972,440523,'南澳县',440500 union
select 1973,440601,'市辖区',440600 union
select 1974,440604,'禅城区',440600 union
select 1975,440605,'南海区',440600 union
select 1976,440606,'顺德区',440600 union
select 1977,440607,'三水区',440600 union
select 1978,440608,'高明区',440600 union
select 1979,440701,'市辖区',440700 union
select 1980,440703,'蓬江区',440700 union
select 1981,440704,'江海区',440700 union
select 1982,440705,'新会区',440700 union
select 1983,440781,'台山市',440700 union
select 1984,440783,'开平市',440700 union
select 1985,440784,'鹤山市',440700 union
select 1986,440785,'恩平市',440700 union
select 1987,440801,'市辖区',440800 union
select 1988,440802,'赤坎区',440800 union
select 1989,440803,'霞山区',440800 union
select 1990,440804,'坡头区',440800 union
select 1991,440811,'麻章区',440800 union
select 1992,440823,'遂溪县',440800 union
select 1993,440825,'徐闻县',440800 union
select 1994,440881,'廉江市',440800 union
select 1995,440882,'雷州市',440800 union
select 1996,440883,'吴川市',440800 union
select 1997,440901,'市辖区',440900 union
select 1998,440902,'茂南区',440900 union
select 1999,440903,'茂港区',440900 union
select 2000,440923,'电白县',440900 union
select 2001,440981,'高州市',440900 union
select 2002,440982,'化州市',440900 union
select 2003,440983,'信宜市',440900 union
select 2004,441201,'市辖区',441200 union
select 2005,441202,'端州区',441200 union
select 2006,441203,'鼎湖区',441200 union
select 2007,441223,'广宁县',441200 union
select 2008,441224,'怀集县',441200 union
select 2009,441225,'封开县',441200 union
select 2010,441226,'德庆县',441200 union
select 2011,441283,'高要市',441200 union
select 2012,441284,'四会市',441200 union
select 2013,441301,'市辖区',441300 union
select 2014,441302,'惠城区',441300 union
select 2015,441303,'惠阳区',441300 union
select 2016,441322,'博罗县',441300 union
select 2017,441323,'惠东县',441300 union
select 2018,441324,'龙门县',441300 union
select 2019,441401,'市辖区',441400 union
select 2020,441402,'梅江区',441400 union
select 2021,441421,'梅 县',441400 union
select 2022,441422,'大埔县',441400 union
select 2023,441423,'丰顺县',441400 union
select 2024,441424,'五华县',441400 union
select 2025,441426,'平远县',441400 union
select 2026,441427,'蕉岭县',441400 union
select 2027,441481,'兴宁市',441400 union
select 2028,441501,'市辖区',441500 union
select 2029,441502,'城 区',441500 union
select 2030,441521,'海丰县',441500 union
select 2031,441523,'陆河县',441500 union
select 2032,441581,'陆丰市',441500 union
select 2033,441601,'市辖区',441600 union
select 2034,441602,'源城区',441600 union
select 2035,441621,'紫金县',441600 union
select 2036,441622,'龙川县',441600 union
select 2037,441623,'连平县',441600 union
select 2038,441624,'和平县',441600 union
select 2039,441625,'东源县',441600 union
select 2040,441701,'市辖区',441700 union
select 2041,441702,'江城区',441700 union
select 2042,441721,'阳西县',441700 union
select 2043,441723,'阳东县',441700 union
select 2044,441781,'阳春市',441700 union
select 2045,441801,'市辖区',441800 union
select 2046,441802,'清城区',441800 union
select 2047,441821,'佛冈县',441800 union
select 2048,441823,'阳山县',441800 union
select 2049,441825,'连山壮族瑶族自治县',441800 union
select 2050,441826,'连南瑶族自治县',441800 union
select 2051,441827,'清新县',441800 union
select 2052,441881,'英德市',441800 union
select 2053,441882,'连州市',441800 union
select 2054,445101,'市辖区',445100 union
select 2055,445102,'湘桥区',445100 union
select 2056,445121,'潮安县',445100 union
select 2057,445122,'饶平县',445100 union
select 2058,445201,'市辖区',445200 union
select 2059,445202,'榕城区',445200 union
select 2060,445221,'揭东县',445200 union
select 2061,445222,'揭西县',445200 union
select 2062,445224,'惠来县',445200 union
select 2063,445281,'普宁市',445200 union
select 2064,445301,'市辖区',445300 union
select 2065,445302,'云城区',445300 union
select 2066,445321,'新兴县',445300 union
select 2067,445322,'郁南县',445300 union
select 2068,445323,'云安县',445300 union
select 2069,445381,'罗定市',445300 union
select 2070,450101,'市辖区',450100 union
select 2071,450102,'兴宁区',450100 union
select 2072,450103,'青秀区',450100 union
select 2073,450105,'江南区',450100 union
select 2074,450107,'西乡塘区',450100 union
select 2075,450108,'良庆区',450100 union
select 2076,450109,'邕宁区',450100 union
select 2077,450122,'武鸣县',450100 union
select 2078,450123,'隆安县',450100 union
select 2079,450124,'马山县',450100 union
select 2080,450125,'上林县',450100 union
select 2081,450126,'宾阳县',450100 union
select 2082,450127,'横 县',450100 union
select 2083,450201,'市辖区',450200 union
select 2084,450202,'城中区',450200 union
select 2085,450203,'鱼峰区',450200 union
select 2086,450204,'柳南区',450200 union
select 2087,450205,'柳北区',450200 union
select 2088,450221,'柳江县',450200 union
select 2089,450222,'柳城县',450200 union
select 2090,450223,'鹿寨县',450200 union
select 2091,450224,'融安县',450200 union
select 2092,450225,'融水苗族自治县',450200 union
select 2093,450226,'三江侗族自治县',450200 union
select 2094,450301,'市辖区',450300 union
select 2095,450302,'秀峰区',450300 union
select 2096,450303,'叠彩区',450300 union
select 2097,450304,'象山区',450300 union
select 2098,450305,'七星区',450300 union
select 2099,450311,'雁山区',450300 union
select 2100,450321,'阳朔县',450300 union
select 2101,450322,'临桂县',450300 union
select 2102,450323,'灵川县',450300 union
select 2103,450324,'全州县',450300 union
select 2104,450325,'兴安县',450300 union
select 2105,450326,'永福县',450300 union
select 2106,450327,'灌阳县',450300 union
select 2107,450328,'龙胜各族自治县',450300 union
select 2108,450329,'资源县',450300 union
select 2109,450330,'平乐县',450300 union
select 2110,450331,'荔蒲县',450300 union
select 2111,450332,'恭城瑶族自治县',450300 union
select 2112,450401,'市辖区',450400 union
select 2113,450403,'万秀区',450400 union
select 2114,450404,'蝶山区',450400 union
select 2115,450405,'长洲区',450400 union
select 2116,450421,'苍梧县',450400 union
select 2117,450422,'藤 县',450400 union
select 2118,450423,'蒙山县',450400 union
select 2119,450481,'岑溪市',450400 union
select 2120,450501,'市辖区',450500 union
select 2121,450502,'海城区',450500 union
select 2122,450503,'银海区',450500 union
select 2123,450512,'铁山港区',450500 union
select 2124,450521,'合浦县',450500 union
select 2125,450601,'市辖区',450600 union
select 2126,450602,'港口区',450600 union
select 2127,450603,'防城区',450600 union
select 2128,450621,'上思县',450600 union
select 2129,450681,'东兴市',450600 union
select 2130,450701,'市辖区',450700 union
select 2131,450702,'钦南区',450700 union
select 2132,450703,'钦北区',450700 union
select 2133,450721,'灵山县',450700 union
select 2134,450722,'浦北县',450700 union
select 2135,450801,'市辖区',450800 union
select 2136,450802,'港北区',450800 union
select 2137,450803,'港南区',450800 union
select 2138,450804,'覃塘区',450800 union
select 2139,450821,'平南县',450800 union
select 2140,450881,'桂平市',450800 union
select 2141,450901,'市辖区',450900 union
select 2142,450902,'玉州区',450900 union
select 2143,450921,'容 县',450900 union
select 2144,450922,'陆川县',450900 union
select 2145,450923,'博白县',450900 union
select 2146,450924,'兴业县',450900 union
select 2147,450981,'北流市',450900 union
select 2148,451001,'市辖区',451000 union
select 2149,451002,'右江区',451000 union
select 2150,451021,'田阳县',451000 union
select 2151,451022,'田东县',451000 union
select 2152,451023,'平果县',451000 union
select 2153,451024,'德保县',451000 union
select 2154,451025,'靖西县',451000 union
select 2155,451026,'那坡县',451000 union
select 2156,451027,'凌云县',451000 union
select 2157,451028,'乐业县',451000 union
select 2158,451029,'田林县',451000 union
select 2159,451030,'西林县',451000 union
select 2160,451031,'隆林各族自治县',451000 union
select 2161,451101,'市辖区',451100 union
select 2162,451102,'八步区',451100 union
select 2163,451121,'昭平县',451100 union
select 2164,451122,'钟山县',451100 union
select 2165,451123,'富川瑶族自治县',451100 union
select 2166,451201,'市辖区',451200 union
select 2167,451202,'金城江区',451200 union
select 2168,451221,'南丹县',451200 union
select 2169,451222,'天峨县',451200 union
select 2170,451223,'凤山县',451200 union
select 2171,451224,'东兰县',451200 union
select 2172,451225,'罗城仫佬族自治县',451200 union
select 2173,451226,'环江毛南族自治县',451200 union
select 2174,451227,'巴马瑶族自治县',451200 union
select 2175,451228,'都安瑶族自治县',451200 union
select 2176,451229,'大化瑶族自治县',451200 union
select 2177,451281,'宜州市',451200 union
select 2178,451301,'市辖区',451300 union
select 2179,451302,'兴宾区',451300 union
select 2180,451321,'忻城县',451300 union
select 2181,451322,'象州县',451300 union
select 2182,451323,'武宣县',451300 union
select 2183,451324,'金秀瑶族自治县',451300 union
select 2184,451381,'合山市',451300 union
select 2185,451401,'市辖区',451400 union
select 2186,451402,'江洲区',451400 union
select 2187,451421,'扶绥县',451400 union
select 2188,451422,'宁明县',451400 union
select 2189,451423,'龙州县',451400 union
select 2190,451424,'大新县',451400 union
select 2191,451425,'天等县',451400 union
select 2192,451481,'凭祥市',451400 union
select 2193,460101,'市辖区',460100 union
select 2194,460105,'秀英区',460100 union
select 2195,460106,'龙华区',460100 union
select 2196,460107,'琼山区',460100 union
select 2197,460108,'美兰区',460100 union
select 2198,460201,'市辖区',460200 union
select 2199,469001,'五指山市',469000 union
select 2200,469002,'琼海市',469000 union
select 2201,469003,'儋州市',469000 union
select 2202,469005,'文昌市',469000 union
select 2203,469006,'万宁市',469000 union
select 2204,469007,'东方市',469000 union
select 2205,469025,'定安县',469000 union
select 2206,469026,'屯昌县',469000 union
select 2207,469027,'澄迈县',469000 union
select 2208,469028,'临高县',469000 union
select 2209,469030,'白沙黎族自治县',469000 union
select 2210,469031,'昌江黎族自治县',469000 union
select 2211,469033,'乐东黎族自治县',469000 union
select 2212,469034,'陵水黎族自治县',469000 union
select 2213,469035,'保亭黎族苗族自治县',469000 union
select 2214,469036,'琼中黎族苗族自治县',469000 union
select 2215,469037,'西沙群岛',469000 union
select 2216,469038,'南沙群岛',469000 union
select 2217,469039,'中沙群岛的岛礁及其海域',469000 union
select 2218,500101,'万州区',500100 union
select 2219,500102,'涪陵区',500100 union
select 2220,500103,'渝中区',500100 union
select 2221,500104,'大渡口区',500100 union
select 2222,500105,'江北区',500100 union
select 2223,500106,'沙坪坝区',500100 union
select 2224,500107,'九龙坡区',500100 union
select 2225,500108,'南岸区',500100 union
select 2226,500109,'北碚区',500100 union
select 2227,500110,'万盛区',500100 union
select 2228,500111,'双桥区',500100 union
select 2229,500112,'渝北区',500100 union
select 2230,500113,'巴南区',500100 union
select 2231,500114,'黔江区',500100 union
select 2232,500115,'长寿区',500100 union
select 2233,500222,'綦江县',500200 union
select 2234,500223,'潼南县',500200 union
select 2235,500224,'铜梁县',500200 union
select 2236,500225,'大足县',500200 union
select 2237,500226,'荣昌县',500200 union
select 2238,500227,'璧山县',500200 union
select 2239,500228,'梁平县',500200 union
select 2240,500229,'城口县',500200 union
select 2241,500230,'丰都县',500200 union
select 2242,500231,'垫江县',500200 union
select 2243,500232,'武隆县',500200 union
select 2244,500233,'忠 县',500200 union
select 2245,500234,'开 县',500200 union
select 2246,500235,'云阳县',500200 union
select 2247,500236,'奉节县',500200 union
select 2248,500237,'巫山县',500200 union
select 2249,500238,'巫溪县',500200 union
select 2250,500240,'石柱土家族自治县',500200 union
select 2251,500241,'秀山土家族苗族自治县',500200 union
select 2252,500242,'酉阳土家族苗族自治县',500200 union
select 2253,500243,'彭水苗族土家族自治县',500200 union
select 2254,500381,'江津市',500300 union
select 2255,500382,'合川市',500300 union
select 2256,500383,'永川市',500300 union
select 2257,500384,'南川市',500300 union
select 2258,510101,'市辖区',510100 union
select 2259,510104,'锦江区',510100 union
select 2260,510105,'青羊区',510100 union
select 2261,510106,'金牛区',510100 union
select 2262,510107,'武侯区',510100 union
select 2263,510108,'成华区',510100 union
select 2264,510112,'龙泉驿区',510100 union
select 2265,510113,'青白江区',510100 union
select 2266,510114,'新都区',510100 union
select 2267,510115,'温江区',510100 union
select 2268,510121,'金堂县',510100 union
select 2269,510122,'双流县',510100 union
select 2270,510124,'郫 县',510100 union
select 2271,510129,'大邑县',510100 union
select 2272,510131,'蒲江县',510100 union
select 2273,510132,'新津县',510100 union
select 2274,510181,'都江堰市',510100 union
select 2275,510182,'彭州市',510100 union
select 2276,510183,'邛崃市',510100 union
select 2277,510184,'崇州市',510100 union
select 2278,510301,'市辖区',510300 union
select 2279,510302,'自流井区',510300 union
select 2280,510303,'贡井区',510300 union
select 2281,510304,'大安区',510300 union
select 2282,510311,'沿滩区',510300 union
select 2283,510321,'荣 县',510300 union
select 2284,510322,'富顺县',510300 union
select 2285,510401,'市辖区',510400 union
select 2286,510402,'东 区',510400 union
select 2287,510403,'西 区',510400 union
select 2288,510411,'仁和区',510400 union
select 2289,510421,'米易县',510400 union
select 2290,510422,'盐边县',510400 union
select 2291,510501,'市辖区',510500 union
select 2292,510502,'江阳区',510500 union
select 2293,510503,'纳溪区',510500 union
select 2294,510504,'龙马潭区',510500 union
select 2295,510521,'泸 县',510500 union
select 2296,510522,'合江县',510500 union
select 2297,510524,'叙永县',510500 union
select 2298,510525,'古蔺县',510500 union
select 2299,510601,'市辖区',510600 union
select 2300,510603,'旌阳区',510600 union
select 2301,510623,'中江县',510600 union
select 2302,510626,'罗江县',510600 union
select 2303,510681,'广汉市',510600 union
select 2304,510682,'什邡市',510600 union
select 2305,510683,'绵竹市',510600 union
select 2306,510701,'市辖区',510700 union
select 2307,510703,'涪城区',510700 union
select 2308,510704,'游仙区',510700 union
select 2309,510722,'三台县',510700 union
select 2310,510723,'盐亭县',510700 union
select 2311,510724,'安 县',510700 union
select 2312,510725,'梓潼县',510700 union
select 2313,510726,'北川羌族自治县',510700 union
select 2314,510727,'平武县',510700 union
select 2315,510781,'江油市',510700 union
select 2316,510801,'市辖区',510800 union
select 2317,510802,'市中区',510800 union
select 2318,510811,'元坝区',510800 union
select 2319,510812,'朝天区',510800 union
select 2320,510821,'旺苍县',510800 union
select 2321,510822,'青川县',510800 union
select 2322,510823,'剑阁县',510800 union
select 2323,510824,'苍溪县',510800 union
select 2324,510901,'市辖区',510900 union
select 2325,510903,'船山区',510900 union
select 2326,510904,'安居区',510900 union
select 2327,510921,'蓬溪县',510900 union
select 2328,510922,'射洪县',510900 union
select 2329,510923,'大英县',510900 union
select 2330,511001,'市辖区',511000 union
select 2331,511002,'市中区',511000 union
select 2332,511011,'东兴区',511000 union
select 2333,511024,'威远县',511000 union
select 2334,511025,'资中县',511000 union
select 2335,511028,'隆昌县',511000 union
select 2336,511101,'市辖区',511100 union
select 2337,511102,'市中区',511100 union
select 2338,511111,'沙湾区',511100 union
select 2339,511112,'五通桥区',511100 union
select 2340,511113,'金口河区',511100 union
select 2341,511123,'犍为县',511100 union
select 2342,511124,'井研县',511100 union
select 2343,511126,'夹江县',511100 union
select 2344,511129,'沐川县',511100 union
select 2345,511132,'峨边彝族自治县',511100 union
select 2346,511133,'马边彝族自治县',511100 union
select 2347,511181,'峨眉山市',511100 union
select 2348,511301,'市辖区',511300 union
select 2349,511302,'顺庆区',511300 union
select 2350,511303,'高坪区',511300 union
select 2351,511304,'嘉陵区',511300 union
select 2352,511321,'南部县',511300 union
select 2353,511322,'营山县',511300 union
select 2354,511323,'蓬安县',511300 union
select 2355,511324,'仪陇县',511300 union
select 2356,511325,'西充县',511300 union
select 2357,511381,'阆中市',511300 union
select 2358,511401,'市辖区',511400 union
select 2359,511402,'东坡区',511400 union
select 2360,511421,'仁寿县',511400 union
select 2361,511422,'彭山县',511400 union
select 2362,511423,'洪雅县',511400 union
select 2363,511424,'丹棱县',511400 union
select 2364,511425,'青神县',511400 union
select 2365,511501,'市辖区',511500 union
select 2366,511502,'翠屏区',511500 union
select 2367,511521,'宜宾县',511500 union
select 2368,511522,'南溪县',511500 union
select 2369,511523,'江安县',511500 union
select 2370,511524,'长宁县',511500 union
select 2371,511525,'高 县',511500 union
select 2372,511526,'珙 县',511500 union
select 2373,511527,'筠连县',511500 union
select 2374,511528,'兴文县',511500 union
select 2375,511529,'屏山县',511500 union
select 2376,511601,'市辖区',511600 union
select 2377,511602,'广安区',511600 union
select 2378,511621,'岳池县',511600 union
select 2379,511622,'武胜县',511600 union
select 2380,511623,'邻水县',511600 union
select 2381,511681,'华莹市',511600 union
select 2382,511701,'市辖区',511700 union
select 2383,511702,'通川区',511700 union
select 2384,511721,'达 县',511700 union
select 2385,511722,'宣汉县',511700 union
select 2386,511723,'开江县',511700 union
select 2387,511724,'大竹县',511700 union
select 2388,511725,'渠 县',511700 union
select 2389,511781,'万源市',511700 union
select 2390,511801,'市辖区',511800 union
select 2391,511802,'雨城区',511800 union
select 2392,511821,'名山县',511800 union
select 2393,511822,'荥经县',511800 union
select 2394,511823,'汉源县',511800 union
select 2395,511824,'石棉县',511800 union
select 2396,511825,'天全县',511800 union
select 2397,511826,'芦山县',511800 union
select 2398,511827,'宝兴县',511800 union
select 2399,511901,'市辖区',511900 union
select 2400,511902,'巴州区',511900 union
select 2401,511921,'通江县',511900 union
select 2402,511922,'南江县',511900 union
select 2403,511923,'平昌县',511900 union
select 2404,512001,'市辖区',512000 union
select 2405,512002,'雁江区',512000 union
select 2406,512021,'安岳县',512000 union
select 2407,512022,'乐至县',512000 union
select 2408,512081,'简阳市',512000 union
select 2409,513221,'汶川县',513200 union
select 2410,513222,'理 县',513200 union
select 2411,513223,'茂 县',513200 union
select 2412,513224,'松潘县',513200 union
select 2413,513225,'九寨沟县',513200 union
select 2414,513226,'金川县',513200 union
select 2415,513227,'小金县',513200 union
select 2416,513228,'黑水县',513200 union
select 2417,513229,'马尔康县',513200 union
select 2418,513230,'壤塘县',513200 union
select 2419,513231,'阿坝县',513200 union
select 2420,513232,'若尔盖县',513200 union
select 2421,513233,'红原县',513200 union
select 2422,513321,'康定县',513300 union
select 2423,513322,'泸定县',513300 union
select 2424,513323,'丹巴县',513300 union
select 2425,513324,'九龙县',513300 union
select 2426,513325,'雅江县',513300 union
select 2427,513326,'道孚县',513300 union
select 2428,513327,'炉霍县',513300 union
select 2429,513328,'甘孜县',513300 union
select 2430,513329,'新龙县',513300 union
select 2431,513330,'德格县',513300 union
select 2432,513331,'白玉县',513300 union
select 2433,513332,'石渠县',513300 union
select 2434,513333,'色达县',513300 union
select 2435,513334,'理塘县',513300 union
select 2436,513335,'巴塘县',513300 union
select 2437,513336,'乡城县',513300 union
select 2438,513337,'稻城县',513300 union
select 2439,513338,'得荣县',513300 union
select 2440,513401,'西昌市',513400 union
select 2441,513422,'木里藏族自治县',513400 union
select 2442,513423,'盐源县',513400 union
select 2443,513424,'德昌县',513400 union
select 2444,513425,'会理县',513400 union
select 2445,513426,'会东县',513400 union
select 2446,513427,'宁南县',513400 union
select 2447,513428,'普格县',513400 union
select 2448,513429,'布拖县',513400 union
select 2449,513430,'金阳县',513400 union
select 2450,513431,'昭觉县',513400 union
select 2451,513432,'喜德县',513400 union
select 2452,513433,'冕宁县',513400 union
select 2453,513434,'越西县',513400 union
select 2454,513435,'甘洛县',513400 union
select 2455,513436,'美姑县',513400 union
select 2456,513437,'雷波县',513400 union
select 2457,520101,'市辖区',520100 union
select 2458,520102,'南明区',520100 union
select 2459,520103,'云岩区',520100 union
select 2460,520111,'花溪区',520100 union
select 2461,520112,'乌当区',520100 union
select 2462,520113,'白云区',520100 union
select 2463,520114,'小河区',520100 union
select 2464,520121,'开阳县',520100 union
select 2465,520122,'息烽县',520100 union
select 2466,520123,'修文县',520100 union
select 2467,520181,'清镇市',520100 union
select 2468,520201,'钟山区',520200 union
select 2469,520203,'六枝特区',520200 union
select 2470,520221,'水城县',520200 union
select 2471,520222,'盘 县',520200 union
select 2472,520301,'市辖区',520300 union
select 2473,520302,'红花岗区',520300 union
select 2474,520303,'汇川区',520300 union
select 2475,520321,'遵义县',520300 union
select 2476,520322,'桐梓县',520300 union
select 2477,520323,'绥阳县',520300 union
select 2478,520324,'正安县',520300 union
select 2479,520325,'道真仡佬族苗族自治县',520300 union
select 2480,520326,'务川仡佬族苗族自治县',520300 union
select 2481,520327,'凤冈县',520300 union
select 2482,520328,'湄潭县',520300 union
select 2483,520329,'余庆县',520300 union
select 2484,520330,'习水县',520300 union
select 2485,520381,'赤水市',520300 union
select 2486,520382,'仁怀市',520300 union
select 2487,520401,'市辖区',520400 union
select 2488,520402,'西秀区',520400 union
select 2489,520421,'平坝县',520400 union
select 2490,520422,'普定县',520400 union
select 2491,520423,'镇宁布依族苗族自治县',520400 union
select 2492,520424,'关岭布依族苗族自治县',520400 union
select 2493,520425,'紫云苗族布依族自治县',520400 union
select 2494,522201,'铜仁市',522200 union
select 2495,522222,'江口县',522200 union
select 2496,522223,'玉屏侗族自治县',522200 union
select 2497,522224,'石阡县',522200 union
select 2498,522225,'思南县',522200 union
select 2499,522226,'印江土家族苗族自治县',522200 union
select 2500,522227,'德江县',522200 union
select 2501,522228,'沿河土家族自治县',522200 union
select 2502,522229,'松桃苗族自治县',522200 union
select 2503,522230,'万山特区',522200 union
select 2504,522301,'兴义市',522300 union
select 2505,522322,'兴仁县',522300 union
select 2506,522323,'普安县',522300 union
select 2507,522324,'晴隆县',522300 union
select 2508,522325,'贞丰县',522300 union
select 2509,522326,'望谟县',522300 union
select 2510,522327,'册亨县',522300 union
select 2511,522328,'安龙县',522300 union
select 2512,522401,'毕节市',522400 union
select 2513,522422,'大方县',522400 union
select 2514,522423,'黔西县',522400 union
select 2515,522424,'金沙县',522400 union
select 2516,522425,'织金县',522400 union
select 2517,522426,'纳雍县',522400 union
select 2518,522427,'威宁彝族回族苗族自治县',522400 union
select 2519,522428,'赫章县',522400 union
select 2520,522601,'凯里市',522600 union
select 2521,522622,'黄平县',522600 union
select 2522,522623,'施秉县',522600 union
select 2523,522624,'三穗县',522600 union
select 2524,522625,'镇远县',522600 union
select 2525,522626,'岑巩县',522600 union
select 2526,522627,'天柱县',522600 union
select 2527,522628,'锦屏县',522600 union
select 2528,522629,'剑河县',522600 union
select 2529,522630,'台江县',522600 union
select 2530,522631,'黎平县',522600 union
select 2531,522632,'榕江县',522600 union
select 2532,522633,'从江县',522600 union
select 2533,522634,'雷山县',522600 union
select 2534,522635,'麻江县',522600 union
select 2535,522636,'丹寨县',522600 union
select 2536,522701,'都匀市',522700 union
select 2537,522702,'福泉市',522700 union
select 2538,522722,'荔波县',522700 union
select 2539,522723,'贵定县',522700 union
select 2540,522725,'瓮安县',522700 union
select 2541,522726,'独山县',522700 union
select 2542,522727,'平塘县',522700 union
select 2543,522728,'罗甸县',522700 union
select 2544,522729,'长顺县',522700 union
select 2545,522730,'龙里县',522700 union
select 2546,522731,'惠水县',522700 union
select 2547,522732,'三都水族自治县',522700 union
select 2548,530101,'市辖区',530100 union
select 2549,530102,'五华区',530100 union
select 2550,530103,'盘龙区',530100 union
select 2551,530111,'官渡区',530100 union
select 2552,530112,'西山区',530100 union
select 2553,530113,'东川区',530100 union
select 2554,530121,'呈贡县',530100 union
select 2555,530122,'晋宁县',530100 union
select 2556,530124,'富民县',530100 union
select 2557,530125,'宜良县',530100 union
select 2558,530126,'石林彝族自治县',530100 union
select 2559,530127,'嵩明县',530100 union
select 2560,530128,'禄劝彝族苗族自治县',530100 union
select 2561,530129,'寻甸回族彝族自治县',530100 union
select 2562,530181,'安宁市',530100 union
select 2563,530301,'市辖区',530300 union
select 2564,530302,'麒麟区',530300 union
select 2565,530321,'马龙县',530300 union
select 2566,530322,'陆良县',530300 union
select 2567,530323,'师宗县',530300 union
select 2568,530324,'罗平县',530300 union
select 2569,530325,'富源县',530300 union
select 2570,530326,'会泽县',530300 union
select 2571,530328,'沾益县',530300 union
select 2572,530381,'宣威市',530300 union
select 2573,530401,'市辖区',530400 union
select 2574,530402,'红塔区',530400 union
select 2575,530421,'江川县',530400 union
select 2576,530422,'澄江县',530400 union
select 2577,530423,'通海县',530400 union
select 2578,530424,'华宁县',530400 union
select 2579,530425,'易门县',530400 union
select 2580,530426,'峨山彝族自治县',530400 union
select 2581,530427,'新平彝族傣族自治县',530400 union
select 2582,530428,'元江哈尼族彝族傣族自治县',530400 union
select 2583,530501,'市辖区',530500 union
select 2584,530502,'隆阳区',530500 union
select 2585,530521,'施甸县',530500 union
select 2586,530522,'腾冲县',530500 union
select 2587,530523,'龙陵县',530500 union
select 2588,530524,'昌宁县',530500 union
select 2589,530601,'市辖区',530600 union
select 2590,530602,'昭阳区',530600 union
select 2591,530621,'鲁甸县',530600 union
select 2592,530622,'巧家县',530600 union
select 2593,530623,'盐津县',530600 union
select 2594,530624,'大关县',530600 union
select 2595,530625,'永善县',530600 union
select 2596,530626,'绥江县',530600 union
select 2597,530627,'镇雄县',530600 union
select 2598,530628,'彝良县',530600 union
select 2599,530629,'威信县',530600 union
select 2600,530630,'水富县',530600 union
select 2601,530701,'市辖区',530700 union
select 2602,530702,'古城区',530700 union
select 2603,530721,'玉龙纳西族自治县',530700 union
select 2604,530722,'永胜县',530700 union
select 2605,530723,'华坪县',530700 union
select 2606,530724,'宁蒗彝族自治县',530700 union
select 2607,530801,'市辖区',530800 union
select 2608,530802,'翠云区',530800 union
select 2609,530821,'普洱哈尼族彝族自治县',530800 union
select 2610,530822,'墨江哈尼族自治县',530800 union
select 2611,530823,'景东彝族自治县',530800 union
select 2612,530824,'景谷傣族彝族自治县',530800 union
select 2613,530825,'镇沅彝族哈尼族拉祜族自治县',530800 union
select 2614,530826,'江城哈尼族彝族自治县',530800 union
select 2615,530827,'孟连傣族拉祜族佤族自治县',530800 union
select 2616,530828,'澜沧拉祜族自治县',530800 union
select 2617,530829,'西盟佤族自治县',530800 union
select 2618,530901,'市辖区',530900 union
select 2619,530902,'临翔区',530900 union
select 2620,530921,'凤庆县',530900 union
select 2621,530922,'云 县',530900 union
select 2622,530923,'永德县',530900 union
select 2623,530924,'镇康县',530900 union
select 2624,530925,'双江拉祜族佤族布朗族傣族自治县',530900 union
select 2625,530926,'耿马傣族佤族自治县',530900 union
select 2626,530927,'沧源佤族自治县',530900 union
select 2627,532301,'楚雄市',532300 union
select 2628,532322,'双柏县',532300 union
select 2629,532323,'牟定县',532300 union
select 2630,532324,'南华县',532300 union
select 2631,532325,'姚安县',532300 union
select 2632,532326,'大姚县',532300 union
select 2633,532327,'永仁县',532300 union
select 2634,532328,'元谋县',532300 union
select 2635,532329,'武定县',532300 union
select 2636,532331,'禄丰县',532300 union
select 2637,532501,'个旧市',532500 union
select 2638,532502,'开远市',532500 union
select 2639,532522,'蒙自县',532500 union
select 2640,532523,'屏边苗族自治县',532500 union
select 2641,532524,'建水县',532500 union
select 2642,532525,'石屏县',532500 union
select 2643,532526,'弥勒县',532500 union
select 2644,532527,'泸西县',532500 union
select 2645,532528,'元阳县',532500 union
select 2646,532529,'红河县',532500 union
select 2647,532530,'金平苗族瑶族傣族自治县',532500 union
select 2648,532531,'绿春县',532500 union
select 2649,532532,'河口瑶族自治县',532500 union
select 2650,532621,'文山县',532600 union
select 2651,532622,'砚山县',532600 union
select 2652,532623,'西畴县',532600 union
select 2653,532624,'麻栗坡县',532600 union
select 2654,532625,'马关县',532600 union
select 2655,532626,'丘北县',532600 union
select 2656,532627,'广南县',532600 union
select 2657,532628,'富宁县',532600 union
select 2658,532801,'景洪市',532800 union
select 2659,532822,'勐海县',532800 union
select 2660,532823,'勐腊县',532800 union
select 2661,532901,'大理市',532900 union
select 2662,532922,'漾濞彝族自治县',532900 union
select 2663,532923,'祥云县',532900 union
select 2664,532924,'宾川县',532900 union
select 2665,532925,'弥渡县',532900 union
select 2666,532926,'南涧彝族自治县',532900 union
select 2667,532927,'巍山彝族回族自治县',532900 union
select 2668,532928,'永平县',532900 union
select 2669,532929,'云龙县',532900 union
select 2670,532930,'洱源县',532900 union
select 2671,532931,'剑川县',532900 union
select 2672,532932,'鹤庆县',532900 union
select 2673,533102,'瑞丽市',533100 union
select 2674,533103,'潞西市',533100 union
select 2675,533122,'梁河县',533100 union
select 2676,533123,'盈江县',533100 union
select 2677,533124,'陇川县',533100 union
select 2678,533321,'泸水县',533300 union
select 2679,533323,'福贡县',533300 union
select 2680,533324,'贡山独龙族怒族自治县',533300 union
select 2681,533325,'兰坪白族普米族自治县',533300 union
select 2682,533421,'香格里拉县',533400 union
select 2683,533422,'德钦县',533400 union
select 2684,533423,'维西傈僳族自治县',533400 union
select 2685,540101,'市辖区',540100 union
select 2686,540102,'城关区',540100 union
select 2687,540121,'林周县',540100 union
select 2688,540122,'当雄县',540100 union
select 2689,540123,'尼木县',540100 union
select 2690,540124,'曲水县',540100 union
select 2691,540125,'堆龙德庆县',540100 union
select 2692,540126,'达孜县',540100 union
select 2693,540127,'墨竹工卡县',540100 union
select 2694,542121,'昌都县',542100 union
select 2695,542122,'江达县',542100 union
select 2696,542123,'贡觉县',542100 union
select 2697,542124,'类乌齐县',542100 union
select 2698,542125,'丁青县',542100 union
select 2699,542126,'察雅县',542100 union
select 2700,542127,'八宿县',542100 union
select 2701,542128,'左贡县',542100 union
select 2702,542129,'芒康县',542100 union
select 2703,542132,'洛隆县',542100 union
select 2704,542133,'边坝县',542100 union
select 2705,542221,'乃东县',542200 union
select 2706,542222,'扎囊县',542200 union
select 2707,542223,'贡嘎县',542200 union
select 2708,542224,'桑日县',542200 union
select 2709,542225,'琼结县',542200 union
select 2710,542226,'曲松县',542200 union
select 2711,542227,'措美县',542200 union
select 2712,542228,'洛扎县',542200 union
select 2713,542229,'加查县',542200 union
select 2714,542231,'隆子县',542200 union
select 2715,542232,'错那县',542200 union
select 2716,542233,'浪卡子县',542200 union
select 2717,542301,'日喀则市',542300 union
select 2718,542322,'南木林县',542300 union
select 2719,542323,'江孜县',542300 union
select 2720,542324,'定日县',542300 union
select 2721,542325,'萨迦县',542300 union
select 2722,542326,'拉孜县',542300 union
select 2723,542327,'昂仁县',542300 union
select 2724,542328,'谢通门县',542300 union
select 2725,542329,'白朗县',542300 union
select 2726,542330,'仁布县',542300 union
select 2727,542331,'康马县',542300 union
select 2728,542332,'定结县',542300 union
select 2729,542333,'仲巴县',542300 union
select 2730,542334,'亚东县',542300 union
select 2731,542335,'吉隆县',542300 union
select 2732,542336,'聂拉木县',542300 union
select 2733,542337,'萨嘎县',542300 union
select 2734,542338,'岗巴县',542300 union
select 2735,542421,'那曲县',542400 union
select 2736,542422,'嘉黎县',542400 union
select 2737,542423,'比如县',542400 union
select 2738,542424,'聂荣县',542400 union
select 2739,542425,'安多县',542400 union
select 2740,542426,'申扎县',542400 union
select 2741,542427,'索 县',542400 union
select 2742,542428,'班戈县',542400 union
select 2743,542429,'巴青县',542400 union
select 2744,542430,'尼玛县',542400 union
select 2745,542521,'普兰县',542500 union
select 2746,542522,'札达县',542500 union
select 2747,542523,'噶尔县',542500 union
select 2748,542524,'日土县',542500 union
select 2749,542525,'革吉县',542500 union
select 2750,542526,'改则县',542500 union
select 2751,542527,'措勤县',542500 union
select 2752,542621,'林芝县',542600 union
select 2753,542622,'工布江达县',542600 union
select 2754,542623,'米林县',542600 union
select 2755,542624,'墨脱县',542600 union
select 2756,542625,'波密县',542600 union
select 2757,542626,'察隅县',542600 union
select 2758,542627,'朗 县',542600 union
select 2759,610101,'市辖区',610100 union
select 2760,610102,'新城区',610100 union
select 2761,610103,'碑林区',610100 union
select 2762,610104,'莲湖区',610100 union
select 2763,610111,'灞桥区',610100 union
select 2764,610112,'未央区',610100 union
select 2765,610113,'雁塔区',610100 union
select 2766,610114,'阎良区',610100 union
select 2767,610115,'临潼区',610100 union
select 2768,610116,'长安区',610100 union
select 2769,610122,'蓝田县',610100 union
select 2770,610124,'周至县',610100 union
select 2771,610125,'户 县',610100 union
select 2772,610126,'高陵县',610100 union
select 2773,610201,'市辖区',610200 union
select 2774,610202,'王益区',610200 union
select 2775,610203,'印台区',610200 union
select 2776,610204,'耀州区',610200 union
select 2777,610222,'宜君县',610200 union
select 2778,610301,'市辖区',610300 union
select 2779,610302,'渭滨区',610300 union
select 2780,610303,'金台区',610300 union
select 2781,610304,'陈仓区',610300 union
select 2782,610322,'凤翔县',610300 union
select 2783,610323,'岐山县',610300 union
select 2784,610324,'扶风县',610300 union
select 2785,610326,'眉 县',610300 union
select 2786,610327,'陇 县',610300 union
select 2787,610328,'千阳县',610300 union
select 2788,610329,'麟游县',610300 union
select 2789,610330,'凤 县',610300 union
select 2790,610331,'太白县',610300 union
select 2791,610401,'市辖区',610400 union
select 2792,610402,'秦都区',610400 union
select 2793,610403,'杨凌区',610400 union
select 2794,610404,'渭城区',610400 union
select 2795,610422,'三原县',610400 union
select 2796,610423,'泾阳县',610400 union
select 2797,610424,'乾 县',610400 union
select 2798,610425,'礼泉县',610400 union
select 2799,610426,'永寿县',610400 union
select 2800,610427,'彬 县',610400 union
select 2801,610428,'长武县',610400 union
select 2802,610429,'旬邑县',610400 union
select 2803,610430,'淳化县',610400 union
select 2804,610431,'武功县',610400 union
select 2805,610481,'兴平市',610400 union
select 2806,610501,'市辖区',610500 union
select 2807,610502,'临渭区',610500 union
select 2808,610521,'华 县',610500 union
select 2809,610522,'潼关县',610500 union
select 2810,610523,'大荔县',610500 union
select 2811,610524,'合阳县',610500 union
select 2812,610525,'澄城县',610500 union
select 2813,610526,'蒲城县',610500 union
select 2814,610527,'白水县',610500 union
select 2815,610528,'富平县',610500 union
select 2816,610581,'韩城市',610500 union
select 2817,610582,'华阴市',610500 union
select 2818,610601,'市辖区',610600

INSERT INTO area (id,areaID,area,fatherID)
select 2819,610602,'宝塔区',610600 union
select 2820,610621,'延长县',610600 union
select 2821,610622,'延川县',610600 union
select 2822,610623,'子长县',610600 union
select 2823,610624,'安塞县',610600 union
select 2824,610625,'志丹县',610600 union
select 2825,610626,'吴旗县',610600 union
select 2826,610627,'甘泉县',610600 union
select 2827,610628,'富 县',610600 union
select 2828,610629,'洛川县',610600 union
select 2829,610630,'宜川县',610600 union
select 2830,610631,'黄龙县',610600 union
select 2831,610632,'黄陵县',610600 union
select 2832,610701,'市辖区',610700 union
select 2833,610702,'汉台区',610700 union
select 2834,610721,'南郑县',610700 union
select 2835,610722,'城固县',610700 union
select 2836,610723,'洋 县',610700 union
select 2837,610724,'西乡县',610700 union
select 2838,610725,'勉 县',610700 union
select 2839,610726,'宁强县',610700 union
select 2840,610727,'略阳县',610700 union
select 2841,610728,'镇巴县',610700 union
select 2842,610729,'留坝县',610700 union
select 2843,610730,'佛坪县',610700 union
select 2844,610801,'市辖区',610800 union
select 2845,610802,'榆阳区',610800 union
select 2846,610821,'神木县',610800 union
select 2847,610822,'府谷县',610800 union
select 2848,610823,'横山县',610800 union
select 2849,610824,'靖边县',610800 union
select 2850,610825,'定边县',610800 union
select 2851,610826,'绥德县',610800 union
select 2852,610827,'米脂县',610800 union
select 2853,610828,'佳 县',610800 union
select 2854,610829,'吴堡县',610800 union
select 2855,610830,'清涧县',610800 union
select 2856,610831,'子洲县',610800 union
select 2857,610901,'市辖区',610900 union
select 2858,610902,'汉滨区',610900 union
select 2859,610921,'汉阴县',610900 union
select 2860,610922,'石泉县',610900 union
select 2861,610923,'宁陕县',610900 union
select 2862,610924,'紫阳县',610900 union
select 2863,610925,'岚皋县',610900 union
select 2864,610926,'平利县',610900 union
select 2865,610927,'镇坪县',610900 union
select 2866,610928,'旬阳县',610900 union
select 2867,610929,'白河县',610900 union
select 2868,611001,'市辖区',611000 union
select 2869,611002,'商州区',611000 union
select 2870,611021,'洛南县',611000 union
select 2871,611022,'丹凤县',611000 union
select 2872,611023,'商南县',611000 union
select 2873,611024,'山阳县',611000 union
select 2874,611025,'镇安县',611000 union
select 2875,611026,'柞水县',611000 union
select 2876,620101,'市辖区',620100 union
select 2877,620102,'城关区',620100 union
select 2878,620103,'七里河区',620100 union
select 2879,620104,'西固区',620100 union
select 2880,620105,'安宁区',620100 union
select 2881,620111,'红古区',620100 union
select 2882,620121,'永登县',620100 union
select 2883,620122,'皋兰县',620100 union
select 2884,620123,'榆中县',620100 union
select 2885,620201,'市辖区',620200 union
select 2886,620301,'市辖区',620300 union
select 2887,620302,'金川区',620300 union
select 2888,620321,'永昌县',620300 union
select 2889,620401,'市辖区',620400 union
select 2890,620402,'白银区',620400 union
select 2891,620403,'平川区',620400 union
select 2892,620421,'靖远县',620400 union
select 2893,620422,'会宁县',620400 union
select 2894,620423,'景泰县',620400 union
select 2895,620501,'市辖区',620500 union
select 2896,620502,'秦城区',620500 union
select 2897,620503,'北道区',620500 union
select 2898,620521,'清水县',620500 union
select 2899,620522,'秦安县',620500 union
select 2900,620523,'甘谷县',620500 union
select 2901,620524,'武山县',620500 union
select 2902,620525,'张家川回族自治县',620500 union
select 2903,620601,'市辖区',620600 union
select 2904,620602,'凉州区',620600 union
select 2905,620621,'民勤县',620600 union
select 2906,620622,'古浪县',620600 union
select 2907,620623,'天祝藏族自治县',620600 union
select 2908,620701,'市辖区',620700 union
select 2909,620702,'甘州区',620700 union
select 2910,620721,'肃南裕固族自治县',620700 union
select 2911,620722,'民乐县',620700 union
select 2912,620723,'临泽县',620700 union
select 2913,620724,'高台县',620700 union
select 2914,620725,'山丹县',620700 union
select 2915,620801,'市辖区',620800 union
select 2916,620802,'崆峒区',620800 union
select 2917,620821,'泾川县',620800 union
select 2918,620822,'灵台县',620800 union
select 2919,620823,'崇信县',620800 union
select 2920,620824,'华亭县',620800 union
select 2921,620825,'庄浪县',620800 union
select 2922,620826,'静宁县',620800 union
select 2923,620901,'市辖区',620900 union
select 2924,620902,'肃州区',620900 union
select 2925,620921,'金塔县',620900 union
select 2926,620922,'安西县',620900 union
select 2927,620923,'肃北蒙古族自治县',620900 union
select 2928,620924,'阿克塞哈萨克族自治县',620900 union
select 2929,620981,'玉门市',620900 union
select 2930,620982,'敦煌市',620900 union
select 2931,621001,'市辖区',621000 union
select 2932,621002,'西峰区',621000 union
select 2933,621021,'庆城县',621000 union
select 2934,621022,'环 县',621000 union
select 2935,621023,'华池县',621000 union
select 2936,621024,'合水县',621000 union
select 2937,621025,'正宁县',621000 union
select 2938,621026,'宁 县',621000 union
select 2939,621027,'镇原县',621000 union
select 2940,621101,'市辖区',621100 union
select 2941,621102,'安定区',621100 union
select 2942,621121,'通渭县',621100 union
select 2943,621122,'陇西县',621100 union
select 2944,621123,'渭源县',621100 union
select 2945,621124,'临洮县',621100 union
select 2946,621125,'漳 县',621100 union
select 2947,621126,'岷 县',621100 union
select 2948,621201,'市辖区',621200 union
select 2949,621202,'武都区',621200 union
select 2950,621221,'成 县',621200 union
select 2951,621222,'文 县',621200 union
select 2952,621223,'宕昌县',621200 union
select 2953,621224,'康 县',621200 union
select 2954,621225,'西和县',621200 union
select 2955,621226,'礼 县',621200 union
select 2956,621227,'徽 县',621200 union
select 2957,621228,'两当县',621200 union
select 2958,622901,'临夏市',622900 union
select 2959,622921,'临夏县',622900 union
select 2960,622922,'康乐县',622900 union
select 2961,622923,'永靖县',622900 union
select 2962,622924,'广河县',622900 union
select 2963,622925,'和政县',622900 union
select 2964,622926,'东乡族自治县',622900 union
select 2965,622927,'积石山保安族东乡族撒拉族自治县',622900 union
select 2966,623001,'合作市',623000 union
select 2967,623021,'临潭县',623000 union
select 2968,623022,'卓尼县',623000 union
select 2969,623023,'舟曲县',623000 union
select 2970,623024,'迭部县',623000 union
select 2971,623025,'玛曲县',623000 union
select 2972,623026,'碌曲县',623000 union
select 2973,623027,'夏河县',623000 union
select 2974,630101,'市辖区',630100 union
select 2975,630102,'城东区',630100 union
select 2976,630103,'城中区',630100 union
select 2977,630104,'城西区',630100 union
select 2978,630105,'城北区',630100 union
select 2979,630121,'大通回族土族自治县',630100 union
select 2980,630122,'湟中县',630100 union
select 2981,630123,'湟源县',630100 union
select 2982,632121,'平安县',632100 union
select 2983,632122,'民和回族土族自治县',632100 union
select 2984,632123,'乐都县',632100 union
select 2985,632126,'互助土族自治县',632100 union
select 2986,632127,'化隆回族自治县',632100 union
select 2987,632128,'循化撒拉族自治县',632100 union
select 2988,632221,'门源回族自治县',632200 union
select 2989,632222,'祁连县',632200 union
select 2990,632223,'海晏县',632200 union
select 2991,632224,'刚察县',632200 union
select 2992,632321,'同仁县',632300 union
select 2993,632322,'尖扎县',632300 union
select 2994,632323,'泽库县',632300 union
select 2995,632324,'河南蒙古族自治县',632300 union
select 2996,632521,'共和县',632500 union
select 2997,632522,'同德县',632500 union
select 2998,632523,'贵德县',632500 union
select 2999,632524,'兴海县',632500 union
select 3000,632525,'贵南县',632500 union
select 3001,632621,'玛沁县',632600 union
select 3002,632622,'班玛县',632600 union
select 3003,632623,'甘德县',632600 union
select 3004,632624,'达日县',632600 union
select 3005,632625,'久治县',632600 union
select 3006,632626,'玛多县',632600 union
select 3007,632721,'玉树县',632700 union
select 3008,632722,'杂多县',632700 union
select 3009,632723,'称多县',632700 union
select 3010,632724,'治多县',632700 union
select 3011,632725,'囊谦县',632700 union
select 3012,632726,'曲麻莱县',632700 union
select 3013,632801,'格尔木市',632800 union
select 3014,632802,'德令哈市',632800 union
select 3015,632821,'乌兰县',632800 union
select 3016,632822,'都兰县',632800 union
select 3017,632823,'天峻县',632800 union
select 3018,640101,'市辖区',640100 union
select 3019,640104,'兴庆区',640100 union
select 3020,640105,'西夏区',640100 union
select 3021,640106,'金凤区',640100 union
select 3022,640121,'永宁县',640100 union
select 3023,640122,'贺兰县',640100 union
select 3024,640181,'灵武市',640100 union
select 3025,640201,'市辖区',640200 union
select 3026,640202,'大武口区',640200 union
select 3027,640205,'惠农区',640200 union
select 3028,640221,'平罗县',640200 union
select 3029,640301,'市辖区',640300 union
select 3030,640302,'利通区',640300 union
select 3031,640323,'盐池县',640300 union
select 3032,640324,'同心县',640300 union
select 3033,640381,'青铜峡市',640300 union
select 3034,640401,'市辖区',640400 union
select 3035,640402,'原州区',640400 union
select 3036,640422,'西吉县',640400 union
select 3037,640423,'隆德县',640400 union
select 3038,640424,'泾源县',640400 union
select 3039,640425,'彭阳县',640400 union
select 3040,640501,'市辖区',640500 union
select 3041,640502,'沙坡头区',640500 union
select 3042,640521,'中宁县',640500 union
select 3043,640522,'海原县',640500 union
select 3044,650101,'市辖区',650100 union
select 3045,650102,'天山区',650100 union
select 3046,650103,'沙依巴克区',650100 union
select 3047,650104,'新市区',650100 union
select 3048,650105,'水磨沟区',650100 union
select 3049,650106,'头屯河区',650100 union
select 3050,650107,'达坂城区',650100 union
select 3051,650108,'东山区',650100 union
select 3052,650121,'乌鲁木齐县',650100 union
select 3053,650201,'市辖区',650200 union
select 3054,650202,'独山子区',650200 union
select 3055,650203,'克拉玛依区',650200 union
select 3056,650204,'白碱滩区',650200 union
select 3057,650205,'乌尔禾区',650200 union
select 3058,652101,'吐鲁番市',652100 union
select 3059,652122,'鄯善县',652100 union
select 3060,652123,'托克逊县',652100 union
select 3061,652201,'哈密市',652200 union
select 3062,652222,'巴里坤哈萨克自治县',652200 union
select 3063,652223,'伊吾县',652200 union
select 3064,652301,'昌吉市',652300 union
select 3065,652302,'阜康市',652300 union
select 3066,652303,'米泉市',652300 union
select 3067,652323,'呼图壁县',652300 union
select 3068,652324,'玛纳斯县',652300 union
select 3069,652325,'奇台县',652300 union
select 3070,652327,'吉木萨尔县',652300 union
select 3071,652328,'木垒哈萨克自治县',652300 union
select 3072,652701,'博乐市',652700 union
select 3073,652722,'精河县',652700 union
select 3074,652723,'温泉县',652700 union
select 3075,652801,'库尔勒市',652800 union
select 3076,652822,'轮台县',652800 union
select 3077,652823,'尉犁县',652800 union
select 3078,652824,'若羌县',652800 union
select 3079,652825,'且末县',652800 union
select 3080,652826,'焉耆回族自治县',652800 union
select 3081,652827,'和静县',652800 union
select 3082,652828,'和硕县',652800 union
select 3083,652829,'博湖县',652800 union
select 3084,652901,'阿克苏市',652900 union
select 3085,652922,'温宿县',652900 union
select 3086,652923,'库车县',652900 union
select 3087,652924,'沙雅县',652900 union
select 3088,652925,'新和县',652900 union
select 3089,652926,'拜城县',652900 union
select 3090,652927,'乌什县',652900 union
select 3091,652928,'阿瓦提县',652900 union
select 3092,652929,'柯坪县',652900 union
select 3093,653001,'阿图什市',653000 union
select 3094,653022,'阿克陶县',653000 union
select 3095,653023,'阿合奇县',653000 union
select 3096,653024,'乌恰县',653000 union
select 3097,653101,'喀什市',653100 union
select 3098,653121,'疏附县',653100 union
select 3099,653122,'疏勒县',653100 union
select 3100,653123,'英吉沙县',653100 union
select 3101,653124,'泽普县',653100 union
select 3102,653125,'莎车县',653100 union
select 3103,653126,'叶城县',653100 union
select 3104,653127,'麦盖提县',653100 union
select 3105,653128,'岳普湖县',653100 union
select 3106,653129,'伽师县',653100 union
select 3107,653130,'巴楚县',653100 union
select 3108,653131,'塔什库尔干塔吉克自治县',653100 union
select 3109,653201,'和田市',653200 union
select 3110,653221,'和田县',653200 union
select 3111,653222,'墨玉县',653200 union
select 3112,653223,'皮山县',653200 union
select 3113,653224,'洛浦县',653200 union
select 3114,653225,'策勒县',653200 union
select 3115,653226,'于田县',653200 union
select 3116,653227,'民丰县',653200 union
select 3117,654002,'伊宁市',654000 union
select 3118,654003,'奎屯市',654000 union
select 3119,654021,'伊宁县',654000 union
select 3120,654022,'察布查尔锡伯自治县',654000 union
select 3121,654023,'霍城县',654000 union
select 3122,654024,'巩留县',654000 union
select 3123,654025,'新源县',654000 union
select 3124,654026,'昭苏县',654000 union
select 3125,654027,'特克斯县',654000 union
select 3126,654028,'尼勒克县',654000 union
select 3127,654201,'塔城市',654200 union
select 3128,654202,'乌苏市',654200 union
select 3129,654221,'额敏县',654200 union
select 3130,654223,'沙湾县',654200 union
select 3131,654224,'托里县',654200 union
select 3132,654225,'裕民县',654200 union
select 3133,654226,'和布克赛尔蒙古自治县',654200 union
select 3134,654301,'阿勒泰市',654300 union
select 3135,654321,'布尔津县',654300 union
select 3136,654322,'富蕴县',654300 union
select 3137,654323,'福海县',654300 union
select 3138,654324,'哈巴河县',654300 union
select 3139,654325,'青河县',654300 union
select 3140,654326,'吉木乃县',654300 union
select 3141,659001,'石河子市',659000 union
select 3142,659002,'阿拉尔市',659000 union
select 3143,659003,'图木舒克市',659000 union
select 3144,659004,'五家渠市',659000

分类: SQL Server

分享到:
评论

相关推荐

    省市区三级联动(代码+SQL)

    标题中的“省市区三级联动(代码+SQL)”是指在软件开发中常见的一个功能模块,特别是在中国的地理信息处理中,为了实现用户选择所在省份、城市和区县的联动效果。这个功能常见于地址输入、配送范围设定等场景。在这...

    省市区三级联动数据表-sql文件(全)

    总结一下,"省市区三级联动数据表-sql文件(全)"是一个包含中国所有省市区地理信息的数据库资源,它支持用户界面中的三级联动功能。这个资源对于开发需要展示地理位置信息的Web或移动应用非常有用,可以帮助快速...

    省市区三级级联数据库sql语句

    省市区三级级联的数据库sql语句,适用于SQLServer,若要别的数据库替换成相应的数据类型即可。 省市级联 省市区三级级联

    中国省市区三级数据库表

    此文档涉及的是一个中国省市区三级数据库表的构建,主要使用MySQL数据库管理系统。这个数据库表设计用于存储中国各个省份、城市和区县的层级关系数据,便于进行地理信息相关的查询和分析。 1. 数据库表结构设计: ...

    省市区三级联动通用sql语句

    总的来说,实现“省市区三级联动”的关键在于合理设计数据库结构,以及编写灵活高效的SQL查询语句。同时,理解并熟悉所使用的数据库管理系统的特点,能够帮助我们更好地优化代码,提升系统的整体性能。

    省市区三级联动数据库Mssql

    标题中的“省市区三级联动数据库Mssql”指的是在SQL Server(Mssql)中设计和实现的...这个数据库文件`省市区三级联动数据库.sql`包含了创建所需表和初始数据的SQL语句,应用开发者可以通过运行此脚本来初始化数据库。

    中国省市县三级联动数据库字典表

    本来是想免费的但是最低就是一分,相信大家也不在乎这一分,里面是一个中国省市县三级联动的SQL语句,字段包括 id , name , parentid ,使用方法大概介绍下,首先省的parentid 都为0,省那一栏查询所有parentid为0的...

    中国省市县三级联动数据库SQLServer

    总的来说,中国省市县三级联动数据库在SQL Server中提供了方便的方式来管理和操作中国行政区域数据,但同时也需要考虑数据的维护、性能优化以及安全性等问题。在实际应用中,合理的设计和管理将极大地提升开发效率和...

    全国省市区(县)三级地址表.zip

    例如,创建一个省市区三级表可能包含以下字段: 1. `id`:每个记录的唯一标识符,通常为整数类型,可以设置为主键(PRIMARY KEY)。 2. `province`:省份名称,字符串类型。 3. `city`:城市名称,字符串类型。 4. ...

    全国省市区数据sql (mysql)三级联动

    综上所述,这个压缩包提供的全国省市区数据SQL(MySQL)是一个完整的数据模型,适用于构建具有三级联动功能的地理信息系统。通过合理设计和优化数据库结构,可以高效地处理和检索地理数据,为各种应用提供支持。

    MySQL SQL 省市县三级联动(含台湾)

    "MySQL SQL 省市县三级联动(含台湾)"这个主题聚焦于一个特定的数据模型,即用于存储中国行政区域划分的数据库结构,它涉及到省级、市级和县级的层级关系,并且包含了台湾地区的数据。这样的设计在很多应用中都有...

    省市区字典sql-mysql-sqlserver.zip

    标签 "数据库 省市区三级联动 三级联动 sql语句" 进一步细化了主题。首先,"数据库"表明我们关注的是与数据存储和检索相关的技术;其次,"省市区三级联动"是指在一个交互式系统中,选择一个省份会自动加载对应的城市...

    全国省市区sql

    ### 全国省市区SQL知识点解析 ...总之,通过上述分析,我们可以看到“全国省市区SQL”不仅涉及数据库的设计与管理,还与实际应用紧密相关。对于从事IT行业的人来说,掌握这类基础知识是非常必要的。

    全国省市区三级数据库(单表)

    标题 "全国省市区三级数据库(单表)" 暗示了这个压缩包包含一个数据库文件,用于存储中国所有省份、城市和区县的详细层级关系。这种数据通常被广泛应用于地理位置信息系统(GIS)、物流配送、电子商务、数据分析等...

    全国省市区3级 3张表的创建文件,可直接在MSSQL数据库创建生成表。

    通过运行这个SQL脚本,用户可以直接在MSSQL数据库中生成完整的省市区3级数据表,无需手动创建。 在实际应用中,为了提高查询效率,往往还会创建索引,尤其是对经常需要进行筛选和关联操作的字段,如ProvinceID、...

    2021省市区三级联动SQL表.zip

    在给定的资源中,"2021省市区三级联动SQL表.zip" 提供了一个高效的数据解决方案,尤其适用于需要实现省市区三级联动效果的项目。这种联动通常在地理信息系统、电子商务网站、物流管理等场景中常见,用于用户选择收货...

    全国省市县数据库sql server

    T_district 区域 (三级) serialId bigint NOT NULL Id districtId nvarchar NULL 区域id districtName nvarchar NULL 区域名 districtUpId nvarchar NULL 上一级id districtUpIdNum int NULL 上一级名字 ...

    省市区三级联动的数据来源——sql insert语句

    标题提到的“省市区三级联动的数据来源——sql insert语句”,是指在SQL Server环境下,通过INSERT语句向数据库中添加省市区三级联动的数据。这种联动机制通常用于实现地理信息的层次化选择,如在电商、社交应用或...

    全国省市县三级联动数据库文件

    SanJI.sql可能包含创建数据库表的SQL语句,这些表可能包括省份(province)、城市(city)和县(district)的表格,每个表格都有相应的ID字段作为主键,并通过外键关联来实现三级联动。例如,city表中的province_id...

    全国省市区三级联动(PHP+jQuery附数据库)

    【全国省市区三级联动(PHP+jQuery附数据库)】是一个常见的前端与后端交互的实现方式,主要用于用户在网站上选择地址时提供下拉菜单的联动效果。这种联动通常包括省份、城市和区县三个级别,当用户选择一个省份时,会...

Global site tag (gtag.js) - Google Analytics