学步园

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