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 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 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 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 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 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 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 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 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 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 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 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。