全国省市区县数据库-市（全）

省级数据库：全国省市区县数据库-省（全）
县区数据库：全国省市区县数据库-县区（全）

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