潇湘博客

潇湘博客 源自岳麓山下的博客.心忧天下,敢为人先.潇湘天下,唯楚有才.本博文章来自互联网、部分原创,如版权问题请联系博主,将及时删除....

中国省市区县最新数据表

因为工作项目需求,需要一个城市县区数据表

特拿出来和大家分享。


sql 数据方面导入操作


下载在址:

http://download.csdn.net/detail/fkedwgwy/3757518



 /**********创建省级表**********/
CREATE TABLE T_Province
(
ProID INT IDENTITY(1,1) PRIMARY KEY,  --省份主键
ProName NVARCHAR(50) NOT NULL,      --省份名称
ProSort INT,      --省份排序
ProRemark NVARCHAR(50)     --说明  
)
Go
insert T_Province(ProName,ProSort,ProRemark) Values('北京市','1','直辖市')
insert T_Province(ProName,ProSort,ProRemark) Values('天津市','2','直辖市')
insert T_Province(ProName,ProSort,ProRemark) Values('河北省','5','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('山西省','6','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('内蒙古自治区','32','自治区')
insert T_Province(ProName,ProSort,ProRemark) Values('辽宁省','8','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('吉林省','9','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('黑龙江省','10','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('上海市','3','直辖市')
insert T_Province(ProName,ProSort,ProRemark) Values('江苏省','11','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('浙江省','12','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('安徽省','13','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('福建省','14','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('江西省','15','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('山东省','16','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('河南省','17','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('湖北省','18','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('湖南省','19','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('广东省','20','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('海南省','24','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('广西壮族自治区','28','自治区')
insert T_Province(ProName,ProSort,ProRemark) Values('甘肃省','21','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('陕西省','27','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('新 疆维吾尔自治区','31','自治区')
insert T_Province(ProName,ProSort,ProRemark) Values('青海省','26','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('宁夏回族自治区','30','自治区')
insert T_Province(ProName,ProSort,ProRemark) Values('重庆市','4','直辖市')
insert T_Province(ProName,ProSort,ProRemark) Values('四川省','22','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('贵州省','23','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('云南省','25','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('西藏自治区','29','自治区')
insert T_Province(ProName,ProSort,ProRemark) Values('台湾省','7','省份')
insert T_Province(ProName,ProSort,ProRemark) Values('澳门特别行政区','33','特别行政区')
insert T_Province(ProName,ProSort,ProRemark) Values('香港特别行政区','34','特别行政区')


/********创建市级表********/
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('秦皇<script type="text/javascript"><!--mce:0--></script><script type="text/javascript"><!--mce:1--></script><script type="text/javascript"><!--mce:2--></script><script type="text/javascript"><!--mce:3--></script><script type="text/javascript"><!--mce:4--></script>岛市','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')


/*********城市县区表*********/
CREATE TABLE  T_District
(
Id INT IDENTITY(1,1) PRIMARY KEY,
DisName NVARCHAR(30) NOT NULL, --区县名称
CityID INT NOT NULL, --所属城市
DisSort INT --区县排序
)
--1 北京
insert T_District(DisName,CityID) values('东城区','1')
insert T_District(DisName,CityID) values('西城区','1')
insert T_District(DisName,CityID) values('崇文区','1')
insert T_District(DisName,CityID) values('宣武区','1')
insert T_District(DisName,CityID) values('朝阳区','1')
insert T_District(DisName,CityID) values('丰台区','1')
insert T_District(DisName,CityID) values('石景山区','1')
insert T_District(DisName,CityID) values('海淀区','1')
insert T_District(DisName,CityID) values('门头沟区','1')
insert T_District(DisName,CityID) values('房山区','1')
insert T_District(DisName,CityID) values('通州区','1')
insert T_District(DisName,CityID) values('顺义区','1')
insert T_District(DisName,CityID) values('昌平区','1')
insert T_District(DisName,CityID) values('大兴区','1')
insert T_District(DisName,CityID) values('怀柔区','1')
insert T_District(DisName,CityID) values('平谷区','1')
insert T_District(DisName,CityID) values('密云县','1')
insert T_District(DisName,CityID) values('延庆县','1')


--2 天津
insert T_District(DisName,CityID) values('和平区','2')
insert T_District(DisName,CityID) values('河东区','2')
insert T_District(DisName,CityID) values('河西区','2')
insert T_District(DisName,CityID) values('南开区','2')
insert T_District(DisName,CityID) values('河北区','2')
insert T_District(DisName,CityID) values('红桥区','2')
insert T_District(DisName,CityID) values('塘沽区','2')
insert T_District(DisName,CityID) values('汉沽区','2')
insert T_District(DisName,CityID) values('大港区','2')
insert T_District(DisName,CityID) values('东丽区','2')
insert T_District(DisName,CityID) values('西青区','2')
insert T_District(DisName,CityID) values('津南区','2')
insert T_District(DisName,CityID) values('北辰区','2')
insert T_District(DisName,CityID) values('武清区','2')
insert T_District(DisName,CityID) values('宝坻区','2')
insert T_District(DisName,CityID) values('宁河县','2')
insert T_District(DisName,CityID) values('静海县','2')
insert T_District(DisName,CityID) values('蓟县','2')


--3 上海市
insert T_District(DisName,CityID) values('黄浦区','3')
insert T_District(DisName,CityID) values('卢湾区','3')
insert T_District(DisName,CityID) values('徐汇区','3')
insert T_District(DisName,CityID) values('长宁区','3')
insert T_District(DisName,CityID) values('静安区','3')
insert T_District(DisName,CityID) values('普陀区','3')
insert T_District(DisName,CityID) values('闸北区','3')
insert T_District(DisName,CityID) values('虹口区','3')
insert T_District(DisName,CityID) values('杨浦区','3')
insert T_District(DisName,CityID) values('闵行区','3')
insert T_District(DisName,CityID) values('宝山区','3')
insert T_District(DisName,CityID) values('嘉定区','3')
insert T_District(DisName,CityID) values('浦东新区','3')
insert T_District(DisName,CityID) values('金山区','3')
insert T_District(DisName,CityID) values('松江区','3')
insert T_District(DisName,CityID) values('青浦区','3')
insert T_District(DisName,CityID) values('南汇区','3')
insert T_District(DisName,CityID) values('奉贤区','3')
insert T_District(DisName,CityID) values('崇明县','3')


--4 重庆市
insert T_District(DisName,CityID) values('万州区','4')
insert T_District(DisName,CityID) values('涪陵区','4')
insert T_District(DisName,CityID) values('渝中区','4')
insert T_District(DisName,CityID) values('大渡口区','4')
insert T_District(DisName,CityID) values('江北区','4')
insert T_District(DisName,CityID) values('沙坪坝区','4')
insert T_District(DisName,CityID) values('九龙坡区','4')
insert T_District(DisName,CityID) values('南岸区','4')
insert T_District(DisName,CityID) values('北碚区','4')
insert T_District(DisName,CityID) values('万盛区','4')
insert T_District(DisName,CityID) values('双桥区','4')
insert T_District(DisName,CityID) values('渝北区','4')
insert T_District(DisName,CityID) values('巴南区','4')
insert T_District(DisName,CityID) values('黔江区','4')
insert T_District(DisName,CityID) values('长寿区','4')
insert T_District(DisName,CityID) values('江津区','4')
insert T_District(DisName,CityID) values('合川区','4')
insert T_District(DisName,CityID) values('永川区','4')
insert T_District(DisName,CityID) values('南川区','4')
insert T_District(DisName,CityID) values('綦江县','4')
insert T_District(DisName,CityID) values('潼南县','4')
insert T_District(DisName,CityID) values('铜梁县','4')
insert T_District(DisName,CityID) values('大足县','4')
insert T_District(DisName,CityID) values('荣昌县','4')
insert T_District(DisName,CityID) values('璧山县','4')
insert T_District(DisName,CityID) values('梁平县','4')
insert T_District(DisName,CityID) values('城口县','4')
insert T_District(DisName,CityID) values('丰都县','4')
insert T_District(DisName,CityID) values('垫江县','4')
insert T_District(DisName,CityID) values('武隆县','4')
insert T_District(DisName,CityID) values('忠县','4')
insert T_District(DisName,CityID) values('开县','4')
insert T_District(DisName,CityID) values('云阳县','4')
insert T_District(DisName,CityID) values('奉节县','4')
insert T_District(DisName,CityID) values('巫山县','4')
insert T_District(DisName,CityID) values('巫溪县','4')
insert T_District(DisName,CityID) values('石柱土家族自治县','4')
insert T_District(DisName,CityID) values('秀山土家族苗族自治县','4')
insert T_District(DisName,CityID) values('酉阳土家族苗族自治县','4')
insert T_District(DisName,CityID) values('彭水苗族土家族自治县','4')




 后面的就不贴上来了


下载在址:

http://download.csdn.net/detail/fkedwgwy/3757518










阅读更多
版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/fkedwgwy/article/details/6937993
想对作者说点什么? 我来说一句

全国省市区数据库,就一个表

2008年01月22日 308KB 下载

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

2014年12月16日 121KB 下载

没有更多推荐了,返回首页

不良信息举报

中国省市区县最新数据表

最多只允许输入30个字

加入CSDN,享受更精准的内容推荐,与500万程序员共同成长!
关闭
关闭