全国省份城市数据

CREATE TABLE [LocationList] (
[FID] [int] NOT NULL ,
[ParentID] [int] NULL ,
[LocationName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
CONSTRAINT [PK_LocationList] PRIMARY KEY  CLUSTERED
(
[FID]
)  ON [PRIMARY]
) ON [PRIMARY]
GO

insert into LocationList (FID,ParentID,LocationName)
select 1,0,'北京' union all
select 2,0,'天津' union all
select 3,0,'上海' union all
select 4,0,'广东' union all
select 5,0,'广西' union all
select 6,0,'河北' union all
select 7,0,'河南' union all
select 8,0,'湖北' union all
select 9,0,'湖南' union all
select 10,0,'福建' union all
select 11,0,'山东' union all
select 12,0,'安徽' union all
select 13,0,'浙江' union all
select 14,0,'四川' union all
select 15,0,'重庆' union all
select 16,0,'贵州' union all
select 17,0,'云南' union all
select 18,0,'江苏' union all
select 19,0,'山西' union all
select 20,0,'辽宁' union all
select 21,0,'吉林' union all
select 22,0,'内蒙古' union all
select 23,0,'黑龙江' union all
select 24,0,'西藏' union all
select 25,0,'陕西' union all
select 26,0,'甘肃' union all
select 27,0,'青海' union all
select 28,0,'宁夏' union all
select 29,0,'新疆' union all
select 30,0,'江西' union all
select 31,0,'海南' union all
select 32,0,'台湾' union all
select 33,0,'香港' union all
select 34,0,'澳门'
insert into LocationList (FID,ParentID,LocationName)
select 35,1,'北京' union all
select 36,2,'天津' union all
select 37,3,'上海' union all
select 38,4,'潮州' union all
select 39,4,'东莞' union all
select 40,4,'佛山' union all
select 41,4,'广州' union all
select 42,4,'河源' union all
select 43,4,'惠州' union all
select 44,4,'江门' union all
select 45,4,'揭阳' union all
select 46,4,'茂名' union all
select 47,4,'梅州' union all
select 48,4,'清远' union all
select 49,4,'汕头' union all
select 50,4,'汕尾' union all
select 51,4,'韶关' union all
select 52,4,'深圳' union all
select 53,4,'阳江' union all
select 54,4,'云浮' union all
select 55,4,'湛江' union all
select 56,4,'肇庆' union all
select 57,4,'中山' union all
select 58,4,'珠海' union all
select 59,5,'百色' union all
select 60,5,'北海' union all
select 61,5,'崇左' union all
select 62,5,'防城港' union all
select 63,5,'桂林' union all
select 64,5,'贵港' union all
select 65,5,'河池' union all
select 66,5,'贺州' union all
select 67,5,'来宾' union all
select 68,5,'柳州' union all
select 69,5,'南宁' union all
select 70,5,'钦州' union all
select 71,5,'梧州' union all
select 72,5,'玉林' union all
select 73,6,'保定' union all
select 74,6,'沧州' union all
select 75,6,'承德' union all
select 76,6,'邯郸' union all
select 77,6,'衡水' union all
select 78,6,'廊坊' union all
select 79,6,'秦皇岛' union all
select 80,6,'石家庄' union all
select 81,6,'唐山' union all
select 82,6,'邢台' union all
select 83,6,'张家口' union all
select 84,7,'安阳' union all
select 85,7,'鹤壁' union all
select 86,7,'济源' union all
select 87,7,'焦作' union all
select 88,7,'开封' union all
select 89,7,'洛阳' union all
select 90,7,'南阳' union all
select 91,7,'平顶山' union all
select 92,7,'三门峡' union all
select 93,7,'商丘' union all
select 94,7,'新乡' union all
select 95,7,'信阳' union all
select 96,7,'许昌' union all
select 97,7,'郑州' union all
select 98,7,'周口' union all
select 99,7,'驻马店' union all
select 100,7,'漯河' union all
select 101,7,'濮阳' union all
select 102,8,'鄂州' union all
select 103,8,'恩施' union all
select 104,8,'黄冈' union all
select 105,8,'黄石' union all
select 106,8,'荆门' union all
select 107,8,'荆州' union all
select 108,8,'潜江' union all
select 109,8,'神农架林区' union all
select 110,8,'十堰' union all
select 111,8,'随州' union all
select 112,8,'天门' union all
select 113,8,'武汉' union all
select 114,8,'仙桃' union all
select 115,8,'咸宁' union all
select 116,8,'襄樊' union all
select 117,8,'孝感' union all
select 118,8,'宜昌' union all
select 119,9,'常德' union all
select 120,9,'长沙' union all
select 121,9,'郴州' union all
select 122,9,'衡阳' union all
select 123,9,'怀化' union all
select 124,9,'娄底' union all
select 125,9,'邵阳' union all
select 126,9,'湘潭' union all
select 127,9,'湘西土家族苗族自治州' union all
select 128,9,'益阳' union all
select 129,9,'永州' union all
select 130,9,'岳阳' union all
select 131,9,'张家界' union all
select 132,9,'株洲' union all
select 133,10,'福州' union all
select 134,10,'龙岩' union all
select 135,10,'南平' union all
select 136,10,'宁德' union all
select 137,10,'莆田' union all
select 138,10,'泉州' union all
select 139,10,'三明' union all
select 140,10,'厦门' union all
select 141,10,'漳州' union all
select 142,11,'滨州' union all
select 143,11,'德州' union all
select 144,11,'东营' union all
select 145,11,'菏泽' union all
select 146,11,'济南' union all
select 147,11,'济宁' union all
select 148,11,'莱芜' union all
select 149,11,'聊城' union all
select 150,11,'临沂' union all
select 151,11,'青岛' union all
select 152,11,'日照' union all
select 153,11,'泰安' union all
select 154,11,'威海' union all
select 155,11,'潍坊' union all
select 156,11,'烟台' union all
select 157,11,'枣庄' union all
select 158,11,'淄博' union all
select 159,12,'亳州' union all
select 160,12,'安庆' union all
select 161,12,'蚌埠' union all
select 162,12,'巢湖' union all
select 163,12,'池州' union all
select 164,12,'滁州' union all
select 165,12,'阜阳' union all
select 166,12,'合肥' union all
select 167,12,'淮北' union all
select 168,12,'淮南' union all
select 169,12,'黄山' union all
select 170,12,'六安' union all
select 171,12,'马鞍山' union all
select 172,12,'宿州' union all
select 173,12,'铜陵' union all
select 174,12,'芜湖' union all
select 175,12,'宣城' union all
select 176,13,'杭州' union all
select 177,13,'湖州' union all
select 178,13,'嘉兴' union all
select 179,13,'金华' union all
select 180,13,'丽水' union all
select 181,13,'宁波' union all
select 182,13,'绍兴' union all
select 183,13,'台州' union all
select 184,13,'温州' union all
select 185,13,'舟山' union all
select 186,13,'衢州' union all
select 187,14,'阿坝' union all
select 188,14,'巴中' union all
select 189,14,'成都' union all
select 190,14,'自贡' union all
select 191,14,'泸州' union all
select 192,14,'达州' union all
select 193,14,'德阳' union all
select 194,14,'甘孜州' union all
select 195,14,'广安' union all
select 196,14,'广元' union all
select 197,14,'乐山' union all
select 198,14,'凉山' union all
select 199,14,'眉山' union all
select 200,14,'绵阳' union all
select 201,14,'南充' union all
select 202,14,'内江' union all
select 203,14,'攀枝花' union all
select 204,14,'遂宁' union all
select 205,14,'雅安' union all
select 206,14,'宜宾' union all
select 207,14,'资阳' union all
select 208,15,'重庆' union all
select 209,16,'黔西南布依族苗族自治州' union all
select 210,16,'安顺' union all
select 211,16,'毕节' union all
select 212,16,'贵阳' union all
select 213,16,'六盘水' union all
select 214,16,'黔东南苗族侗族自治州' union all
select 215,16,'黔南布依族苗族自治州' union all
select 216,16,'铜仁' union all
select 217,16,'遵义' union all
select 218,17,'昭通' union all
select 219,17,'丽江' union all
select 220,17,'临沧' union all
select 221,17,'怒江' union all
select 222,17,'曲靖' union all
select 223,17,'思茅' union all
select 224,17,'文山' union all
select 225,17,'西双版纳' union all
select 226,17,'玉溪' union all
select 227,17,'保山' union all
select 228,17,'楚雄' union all
select 229,17,'大理' union all
select 230,17,'德宏' union all
select 231,17,'迪庆' union all
select 232,17,'红河' union all
select 233,17,'昆明' union all
select 234,18,'无锡' union all
select 235,18,'徐州' union all
select 236,18,'盐城' union all
select 237,18,'扬州' union all
select 238,18,'镇江' union all
select 239,18,'常州' union all
select 240,18,'淮安' union all
select 241,18,'连云港' union all
select 242,18,'南京' union all
select 243,18,'南通' union all
select 244,18,'苏州' union all
select 245,18,'宿迁' union all
select 246,18,'泰州' union all
select 247,19,'阳泉' union all
select 248,19,'运城' union all
select 249,19,'长治' union all
select 250,19,'大同' union all
select 251,19,'晋城' union all
select 252,19,'晋中' union all
select 253,19,'临汾' union all
select 254,19,'吕梁' union all
select 255,19,'朔州' union all
select 256,19,'太原' union all
select 257,19,'忻州' union all
select 258,20,'鞍山' union all
select 259,20,'本溪' union all
select 260,20,'朝阳' union all
select 261,20,'大连' union all
select 262,20,'丹东' union all
select 263,20,'抚顺' union all
select 264,20,'阜新' union all
select 265,20,'葫芦岛' union all
select 266,20,'锦州' union all
select 267,20,'辽阳' union all
select 268,20,'盘锦' union all
select 269,20,'沈阳' union all
select 270,20,'铁岭' union all
select 271,20,'营口' union all
select 272,21,'白山' union all
select 273,21,'长春' union all
select 274,21,'吉林' union all
select 275,21,'辽源' union all
select 276,21,'四平' union all
select 277,21,'松原' union all
select 278,21,'通化' union all
select 279,21,'延边' union all
select 280,21,'白城' union all
select 281,22,'阿拉善盟' union all
select 282,22,'巴彦淖尔市' union all
select 283,22,'包头' union all
select 284,22,'赤峰' union all
select 285,22,'鄂尔多斯' union all
select 286,22,'呼和浩特' union all
select 287,22,'呼伦贝尔' union all
select 288,22,'通辽' union all
select 289,22,'乌海' union all
select 290,22,'乌兰察布市' union all
select 291,22,'锡林郭勒盟' union all
select 292,22,'兴安盟' union all
select 293,23,'大庆' union all
select 294,23,'大兴安岭' union all
select 295,23,'哈尔滨' union all
select 296,23,'鹤岗' union all
select 297,23,'黑河' union all
select 298,23,'鸡西' union all
select 299,23,'佳木斯' union all
select 300,23,'牡丹江' union all
select 301,23,'七台河' union all
select 302,23,'齐齐哈尔' union all
select 303,23,'双鸭山' union all
select 304,23,'绥化' union all
select 305,23,'伊春' union all
select 306,24,'阿里' union all
select 307,24,'昌都' union all
select 308,24,'拉萨' union all
select 309,24,'林芝' union all
select 310,24,'那曲' union all
select 311,24,'日喀则' union all
select 312,24,'山南' union all
select 313,25,'安康' union all
select 314,25,'宝鸡' union all
select 315,25,'汉中' union all
select 316,25,'商洛' union all
select 317,25,'铜川' union all
select 318,25,'渭南' union all
select 319,25,'西安' union all
select 320,25,'咸阳' union all
select 321,25,'延安' union all
select 322,25,'榆林' union all
select 323,26,'白银' union all
select 324,26,'定西' union all
select 325,26,'甘南' union all
select 326,26,'嘉峪关' union all
select 327,26,'金昌' union all
select 328,26,'张掖' union all
select 329,26,'酒泉' union all
select 330,26,'兰州' union all
select 331,26,'临夏' union all
select 332,26,'陇南' union all
select 333,26,'平凉' union all
select 334,26,'庆阳' union all
select 335,26,'天水' union all
select 336,26,'武威' union all
select 337,27,'果洛' union all
select 338,27,'海北' union all
select 339,27,'西宁' union all
select 340,27,'玉树' union all
select 341,27,'海东' union all
select 342,27,'海南' union all
select 343,27,'海西' union all
select 344,27,'黄南' union all
select 345,28,'吴忠' union all
select 346,28,'银川' union all
select 347,28,'固原' union all
select 348,28,'石嘴山' union all
select 349,29,'阿克苏' union all
select 350,29,'阿拉尔' union all
select 351,29,'巴音郭楞' union all
select 352,29,'博尔塔拉' union all
select 353,29,'昌吉' union all
select 354,29,'哈密' union all
select 355,29,'伊犁' union all
select 356,29,'和田' union all
select 357,29,'喀什' union all
select 358,29,'克拉玛依' union all
select 359,29,'石河子' union all
select 360,29,'图木舒克' union all
select 361,29,'吐鲁番' union all
select 362,29,'乌鲁木齐' union all
select 363,29,'五家渠' union all
select 364,29,'克孜勒苏' union all
select 365,30,'抚州' union all
select 366,30,'赣州' union all
select 367,30,'吉安' union all
select 368,30,'景德镇' union all
select 369,30,'九江' union all
select 370,30,'南昌' union all
select 371,30,'萍乡' union all
select 372,30,'上饶' union all
select 373,30,'新余' union all
select 374,30,'宜春' union all
select 375,30,'鹰潭' union all
select 376,31,'白沙' union all
select 377,31,'保亭' union all
select 378,31,'昌江' union all
select 379,31,'澄迈县' union all
select 380,31,'定安县' union all
select 381,31,'东方' union all
select 382,31,'海口' union all
select 383,31,'乐东黎族自治县' union all
select 384,31,'临高县' union all
select 385,31,'陵水黎族自治县' union all
select 386,31,'琼海' union all
select 387,31,'琼中黎族苗族自治县' union all
select 388,31,'五指山' union all
select 389,31,'儋州' union all
select 390,31,'三亚' union all
select 391,31,'屯昌县' union all
select 392,31,'万宁' union all
select 393,31,'文昌' union all
select 394,32,'台中' union all
select 395,32,'台东' union all
select 396,32,'台南' union all
select 397,32,'花莲' union all
select 398,32,'基隆' union all
select 399,32,'嘉义' union all
select 400,32,'台北' union all
select 401,32,'高雄' union all
select 402,33,'香港' union all
select 403,34,'澳门'

select * FROM LocationList