中国省市县(区)数据库表

--创建DBPromary数据库
create database DBPromary
use DBPromary
go
--创建Province表
CREATE TABLE [dbo].[Province](
[Id] [int] NULL,
[Name] [varchar](50) NULL,
[orderid] [int] NULL
)

插入数据
insert into Province values('1','北京','0')
insert into Province values('2','天津','0')
insert into Province values('3','河北','0')
insert into Province values('4','山西','0')
insert into Province values('5','内蒙古','0')
insert into Province values('6','辽宁','0')
insert into Province values('7','吉林','0')
insert into Province values('8','黑龙江','0')
insert into Province values('9','上海','0')
insert into Province values('10','江苏','0')
insert into Province values('11','浙江','0')
insert into Province values('12','安徽','0')
insert into Province values('13','福建','999')
insert into Province values('14','江西','0')
insert into Province values('15','山东','0')
insert into Province values('16','河南','0')
insert into Province values('17','湖北','0')
insert into Province values('18','湖南','0')
insert into Province values('19','广东','0')
insert into Province values('20','广西','0')
insert into Province values('21','海南','0')
insert into Province values('22','重庆','0')
insert into Province values('23','四川','0')
insert into Province values('24','贵州','0')
insert into Province values('25','云南','0')
insert into Province values('26','西藏','0')
insert into Province values('27','陕西','0')
insert into Province values('28','甘肃','0')
insert into Province values('29','青海','0')
insert into Province values('30','宁夏','0')
insert into Province values('31','新疆','0')
insert into Province values('32','香港','0')
insert into Province values('33','澳门','0')
insert into Province values('34','台湾','0')



创建City表
CREATE TABLE [dbo].[City](
[Id] [int] NULL,
[ProvinceId] [int] NULL,
[Name] [varchar](50) NULL,
[AreaCode] [varchar](50) NULL
)

插入数据
insert into City values('1','1','北京市','010')
insert into City values('2','2','天津市','022')
insert into City values('3','3','石家庄市','0311')
insert into City values('4','3','唐山市','0315')
insert into City values('5','3','秦皇岛市','0335')
insert into City values('6','3','邯郸市','0310')
insert into City values('7','3','邢台市','0319')
insert into City values('8','3','保定市','0312')
insert into City values('9','3','张家口市','0313')
insert into City values('10','3','承德市','0314')
insert into City values('11','3','沧州市','0317')
insert into City values('12','3','廊坊市','0316')
insert into City values('13','3','衡水市','0318')
insert into City values('14','4','太原市','0351')
insert into City values('15','4','大同市','0352')
insert into City values('16','4','阳泉市','0353')
insert into City values('17','4','长治市','0355')
insert i

nto City values('18','4','晋城市','0356')
insert into City values('19','4','朔州市','0349')
insert into City values('20','4','晋中市','0354')
insert into City values('21','4','运城市','0359')
insert into City values('22','4','忻州市','0350')
insert into City values('23','4','临汾市','0357')
insert into City values('24','4','吕梁市','0358')
insert into City values('25','5','呼和浩特市','0471')
insert into City values('26','5','包头市','0472')
insert into City values('27','5','乌海市','0473')
insert into City values('28','5','赤峰市','0476')
insert into City values('29','5','通辽市','0475')
insert into City values('30','5','鄂尔多斯市','0477')
insert into City values('31','5','呼伦贝尔市','0470')
insert into City values('32','5','巴彦淖尔市','0478')
insert into City values('33','5','乌兰察布市','0474')
insert into City values('34','5','兴安盟','0482')
insert into City values('35','5','锡林郭勒盟','0479')
insert into City values('36','5','阿拉善盟','0483')
insert into City values('37','6','沈阳市','024')
insert into City values('38','6','大连市','0411')
insert into City values('39','6','鞍山市','0412')
insert into City values('40','6','抚顺市','0413')
insert into City values('41','6','本溪市','0414')
insert into City values('42','6','丹东市','0415')
insert into City values('43','6','锦州市','0416')
insert into City values('44','6','营口市','0417')
insert into City values('45','6','阜新市','0418')
insert into City values('46','6','辽阳市','0419')
insert into City values('47','6','盘锦市','0427')
insert into City values('48','6','铁岭市','0410')
insert into City values('49','6','朝阳市','0421')
insert into City values('50','6','葫芦岛市','0429')
insert into City values('51','7','长春市','0431')
insert into City values('52','7','吉林市','0432')
insert into City values('53','7','四平市','0434')
insert into City values('54','7','辽源市','0437')
insert into City values('55','7','通化市','0435')
insert into City values('56','7','白山市','0439')
insert into City values('57','7','松原市','0438')
insert into City values('58','7','白城市','0436')
insert into City values('59','7','延边朝鲜族自治州','0433')
insert into City values('60','8','哈尔滨市','0451')
insert into City values('61','8','齐齐哈尔市','0452')
insert into City values('62','8','鸡西市','0467')
insert into City values('63','8','鹤岗市','0454')
insert into City values('64','8','双鸭山市','0454')
insert into City values('65','8','大庆市','0459')
insert into City values('66','8','伊春市','0458')
insert into City values('67','8','佳木斯市','0454')
insert into City values('68','8','七台河市','0464')
insert into City values('69','8','牡丹江市','0453')
insert into City values('70','8','黑河市','0456')
insert into City

values('71','8','绥化市','0455')
insert into City values('72','8','大兴安岭地区','0457')
insert into City values('73','9','上海市','021')
insert into City values('74','10','南京市','025')
insert into City values('75','10','无锡市','0510')
insert into City values('76','10','徐州市','0516')
insert into City values('77','10','常州市','0519')
insert into City values('78','10','苏州市','0512')
insert into City values('79','10','南通市','0513')
insert into City values('80','10','连云港市','0518')
insert into City values('81','10','淮安市','0517')
insert into City values('82','10','盐城市','0515')
insert into City values('83','10','扬州市','0514')
insert into City values('84','10','镇江市','0511')
insert into City values('85','10','泰州市','0523')
insert into City values('86','10','宿迁市','0527')
insert into City values('87','11','杭州市','0571')
insert into City values('88','11','宁波市','0574')
insert into City values('89','11','温州市','0577')
insert into City values('90','11','嘉兴市','0573')
insert into City values('91','11','湖州市','0572')
insert into City values('92','11','绍兴市','0575')
insert into City values('93','11','金华市','0579')
insert into City values('94','11','衢州市','0570')
insert into City values('95','11','舟山市','0580')
insert into City values('96','11','台州市','0576')
insert into City values('97','11','丽水市','0578')
insert into City values('98','12','合肥市','0551')
insert into City values('99','12','芜湖市','0553')
insert into City values('100','12','蚌埠市','0552')
insert into City values('101','12','淮南市','0554')
insert into City values('102','12','马鞍山市','0555')
insert into City values('103','12','淮北市','0561')
insert into City values('104','12','铜陵市','0562')
insert into City values('105','12','安庆市','0556')
insert into City values('106','12','黄山市','0559')
insert into City values('107','12','滁州市','0550')
insert into City values('108','12','阜阳市','0558')
insert into City values('109','12','宿州市','0557')
insert into City values('110','12','巢湖市','0565')
insert into City values('111','12','六安市','0564')
insert into City values('112','12','亳州市','0558')
insert into City values('113','12','池州市','0566')
insert into City values('114','12','宣城市','0563')
insert into City values('115','13','福州市','0591')
insert into City values('116','13','厦门市','0592')
insert into City values('117','13','莆田市','0594')
insert into City values('118','13','三明市','0598')
insert into City values('119','13','泉州市','0595')
insert into City values('120','13','漳州市','0596')
insert into City values('121','13','南平市','0599')
insert into City values('122','13','龙岩市','0597')
insert into City values('123','13','宁德市','0593')
insert into Ci

ty values('124','14','南昌市','0791')
insert into City values('125','14','景德镇市','0798')
insert into City values('126','14','萍乡市','0799')
insert into City values('127','14','九江市','0792')
insert into City values('128','14','新余市','0790')
insert into City values('129','14','鹰潭市','0701')
insert into City values('130','14','赣州市','0797')
insert into City values('131','14','吉安市','0796')
insert into City values('132','14','宜春市','0795')
insert into City values('133','14','抚州市','0794')
insert into City values('134','14','上饶市','0793')
insert into City values('135','15','济南市','0531')
insert into City values('136','15','青岛市','0532')
insert into City values('137','15','淄博市','0533')
insert into City values('138','15','枣庄市','0632')
insert into City values('139','15','东营市','0546')
insert into City values('140','15','烟台市','0535')
insert into City values('141','15','潍坊市','0536')
insert into City values('142','15','济宁市','0537')
insert into City values('143','15','泰安市','0538')
insert into City values('144','15','威海市','0631')
insert into City values('145','15','日照市','0633')
insert into City values('146','15','莱芜市','0634')
insert into City values('147','15','临沂市','0539')
insert into City values('148','15','德州市','0534')
insert into City values('149','15','聊城市','0635')
insert into City values('150','15','滨州市','0543')
insert into City values('151','15','菏泽市','0530')
insert into City values('152','16','郑州市','0371')
insert into City values('153','16','开封市','0378')
insert into City values('154','16','洛阳市','0379')
insert into City values('155','16','平顶山市','0375')
insert into City values('156','16','安阳市','0372')
insert into City values('157','16','鹤壁市','0392')
insert into City values('158','16','新乡市','0373')
insert into City values('159','16','焦作市','0391')
insert into City values('160','16','濮阳市','0393')
insert into City values('161','16','许昌市','0374')
insert into City values('162','16','漯河市','0395')
insert into City values('163','16','三门峡市','0398')
insert into City values('164','16','南阳市','0377')
insert into City values('165','16','商丘市','0370')
insert into City values('166','16','信阳市','0376')
insert into City values('167','16','周口市','0394')
insert into City values('168','16','驻马店市','0396')
insert into City values('169','16','济源市','0391')
insert into City values('170','17','武汉市','027')
insert into City values('171','17','黄石市','0714')
insert into City values('172','17','十堰市','0719')
insert into City values('173','17','宜昌市','0717')
insert into City values('174','17','襄樊市','0710')
insert into City values('175','17','鄂州市','0711')
insert into City values('176','17','荆

门市','0724')
insert into City values('177','17','孝感市','0712')
insert into City values('178','17','荆州市','0716')
insert into City values('179','17','黄冈市','0713')
insert into City values('180','17','咸宁市','0715')
insert into City values('181','17','随州市','0722')
insert into City values('182','17','恩施土家族苗族自治州','0718')
insert into City values('183','17','省直辖县级行政单位','0728')
insert into City values('184','18','长沙市','0731')
insert into City values('185','18','株洲市','0733')
insert into City values('186','18','湘潭市','0732')
insert into City values('187','18','衡阳市','0734')
insert into City values('188','18','邵阳市','0739')
insert into City values('189','18','岳阳市','0730')
insert into City values('190','18','常德市','0736')
insert into City values('191','18','张家界市','0744')
insert into City values('192','18','益阳市','0737')
insert into City values('193','18','郴州市','0735')
insert into City values('194','18','永州市','0746')
insert into City values('195','18','怀化市','0745')
insert into City values('196','18','娄底市','0738')
insert into City values('197','18','湘西土家族苗族自治州','0743')
insert into City values('198','19','广州市','020')
insert into City values('199','19','韶关市','0751')
insert into City values('200','19','深圳市','0755')
insert into City values('201','19','珠海市','0756')
insert into City values('202','19','汕头市','0754')
insert into City values('203','19','佛山市','0757')
insert into City values('204','19','江门市','0750')
insert into City values('205','19','湛江市','0759')
insert into City values('206','19','茂名市','0668')
insert into City values('207','19','肇庆市','0758')
insert into City values('208','19','惠州市','0752')
insert into City values('209','19','梅州市','0753')
insert into City values('210','19','汕尾市','0660')
insert into City values('211','19','河源市','0762')
insert into City values('212','19','阳江市','0662')
insert into City values('213','19','清远市','0763')
insert into City values('214','19','东莞市','0769')
insert into City values('215','19','中山市','0760')
insert into City values('216','19','潮州市','0768')
insert into City values('217','19','揭阳市','0663')
insert into City values('218','19','云浮市','0766')
insert into City values('219','20','南宁市','0771')
insert into City values('220','20','柳州市','0772')
insert into City values('221','20','桂林市','0773')
insert into City values('222','20','梧州市','0774')
insert into City values('223','20','北海市','0779')
insert into City values('224','20','防城港市','0770')
insert into City values('225','20','钦州市','0777')
insert into City values('226','20','贵港市','0775')
insert into City values('227','20','玉林市','0775')
insert int

o City values('228','20','百色市','0776')
insert into City values('229','20','贺州市','0774')
insert into City values('230','20','河池市','0778')
insert into City values('231','20','来宾市','0772')
insert into City values('232','20','崇左市','0771')
insert into City values('233','21','海口市','0898')
insert into City values('234','21','三亚市','0898')
insert into City values('235','21','省直辖县级行政单位','0898')
insert into City values('236','22','重庆市','023')
insert into City values('237','23','成都市','028')
insert into City values('238','23','自贡市','0813')
insert into City values('239','23','攀枝花市','0812')
insert into City values('240','23','泸州市','0830')
insert into City values('241','23','德阳市','0838')
insert into City values('242','23','绵阳市','0816')
insert into City values('243','23','广元市','0839')
insert into City values('244','23','遂宁市','0825')
insert into City values('245','23','内江市','0832')
insert into City values('246','23','乐山市','0833')
insert into City values('247','23','南充市','0817')
insert into City values('248','23','眉山市','0833')
insert into City values('249','23','宜宾市','0831')
insert into City values('250','23','广安市','0826')
insert into City values('251','23','达州市','0818')
insert into City values('252','23','雅安市','0835')
insert into City values('253','23','巴中市','0827')
insert into City values('254','23','资阳市','0832')
insert into City values('255','23','阿坝藏族羌族自治州','0837')
insert into City values('256','23','甘孜藏族自治州','0836')
insert into City values('257','23','凉山彝族自治州','0834')
insert into City values('258','24','贵阳市','0851')
insert into City values('259','24','六盘水市','0858')
insert into City values('260','24','遵义市','0852')
insert into City values('261','24','安顺市','0853')
insert into City values('262','24','铜仁地区','0856')
insert into City values('263','24','黔西南布依族苗族自治州','0859')
insert into City values('264','24','毕节地区','0857')
insert into City values('265','24','黔东南苗族侗族自治州','0855')
insert into City values('266','24','黔南布依族苗族自治州','0854')
insert into City values('267','25','昆明市','0871')
insert into City values('268','25','曲靖市','0874')
insert into City values('269','25','玉溪市','0877')
insert into City values('270','25','保山市','0875')
insert into City values('271','25','昭通市','0870')
insert into City values('272','25','丽江市','0888')
insert into City values('273','25','普洱市','0879')
insert into City values('274','25','临沧市','0883')
insert into City values('275','25','楚雄彝族自治州','0878')
insert into City values('276','25','红河哈尼族彝族自治州','0873')
insert into City values('277','25','文山壮族

苗族自治州','0876')
insert into City values('278','25','西双版纳傣族自治州','0691')
insert into City values('279','25','大理白族自治州','0872')
insert into City values('280','25','德宏傣族景颇族自治州','0692')
insert into City values('281','25','怒江傈僳族自治州','0886')
insert into City values('282','25','迪庆藏族自治州','0887')
insert into City values('283','26','拉萨市','0891')
insert into City values('284','26','昌都地区','0895')
insert into City values('285','26','山南地区','0893')
insert into City values('286','26','日喀则地区','0892')
insert into City values('287','26','那曲地区','0896')
insert into City values('288','26','阿里地区','0897')
insert into City values('289','26','林芝地区','0894')
insert into City values('290','27','西安市','029')
insert into City values('291','27','铜川市','0919')
insert into City values('292','27','宝鸡市','0917')
insert into City values('293','27','咸阳市','029')
insert into City values('294','27','渭南市','0913')
insert into City values('295','27','延安市','0911')
insert into City values('296','27','汉中市','0916')
insert into City values('297','27','榆林市','0912')
insert into City values('298','27','安康市','0915')
insert into City values('299','27','商洛市','0914')
insert into City values('300','28','兰州市','0931')
insert into City values('301','28','嘉峪关市','0937')
insert into City values('302','28','金昌市','0935')
insert into City values('303','28','白银市','0943')
insert into City values('304','28','天水市','0938')
insert into City values('305','28','武威市','0935')
insert into City values('306','28','张掖市','0936')
insert into City values('307','28','平凉市','0933')
insert into City values('308','28','酒泉市','0937')
insert into City values('309','28','庆阳市','0934')
insert into City values('310','28','定西市','0932')
insert into City values('311','28','陇南市','0939')
insert into City values('312','28','临夏回族自治州','0930')
insert into City values('313','28','甘南藏族自治州','0941')
insert into City values('314','29','西宁市','0971')
insert into City values('315','29','海东地区','0972')
insert into City values('316','29','海北藏族自治州','0970')
insert into City values('317','29','黄南藏族自治州','0973')
insert into City values('318','29','海南藏族自治州','0974')
insert into City values('319','29','果洛藏族自治州','0975')
insert into City values('320','29','玉树藏族自治州','0976')
insert into City values('321','29','海西蒙古族藏族自治州','0979')
insert into City values('322','30','银川市','0951')
insert into City values('323','30','石嘴山市','0952')
insert into City values('324','30','吴忠市','0953')
insert into City values('325','30','固原市','0954')
insert into City values('3

26','30','中卫市','0955')
insert into City values('327','31','乌鲁木齐市','0991')
insert into City values('328','31','克拉玛依市','0990')
insert into City values('329','31','吐鲁番地区','0995')
insert into City values('330','31','哈密地区','0902')
insert into City values('331','31','昌吉回族自治州','0994')
insert into City values('332','31','博尔塔拉蒙古自治州','0909')
insert into City values('333','31','巴音郭楞蒙古自治州','0996')
insert into City values('334','31','阿克苏地区','0997')
insert into City values('335','31','克孜勒苏柯尔克孜自治州','0908')
insert into City values('336','31','喀什地区','0998')
insert into City values('337','31','和田地区','0903')
insert into City values('338','31','伊犁哈萨克自治州','0999')
insert into City values('339','31','塔城地区','0901')
insert into City values('340','31','阿勒泰地区','0906')
insert into City values('341','31','省直辖县级行政单位','0993')
insert into City values('342','32','香港','1000')
insert into City values('343','33','澳门','1001')
insert into City values('344','34','台湾','1002')

创建县区表
CREATE TABLE [dbo].[District](
[Id] [int] NULL,
[CityId] [int] NULL,
[Name] [varchar](50) NULL,
[PostCode] [varchar](50) NULL
)
插入数据
insert into District values('1','1','东城区','100010')
insert into District values('2','1','西城区','100032')
insert into District values('3','1','崇文区','100061')
insert into District values('4','1','宣武区','100054')
insert into District values('5','1','朝阳区','100020')
insert into District values('6','1','丰台区','100071')
insert into District values('7','1','石景山区','100043')
insert into District values('8','1','海淀区','100089')
insert into District values('9','1','门头沟区','102300')
insert into District values('10','1','房山区','102488')
insert into District values('11','1','通州区','101100')
insert into District values('12','1','顺义区','101300')
insert into District values('13','1','昌平区','102200')
insert into District values('14','1','大兴区','102600')
insert into District values('15','1','怀柔区','101400')
insert into District values('16','1','平谷区','101200')
insert into District values('17','1','密云县','101500')
insert into District values('18','1','延庆县','102100')
insert into District values('19','2','和平区','300041')
insert into District values('20','2','河东区','300171')
insert into District values('21','2','河西区','300202')
insert into District values('22','2','南开区','300100')
insert into District values('23','2','河北区','300143')
insert into District values('24','2','红桥区','300131')
insert into District values('25','2','塘沽区','300450')
insert into District values('26','2','汉沽区','300480')
insert into District values('27','2','大港区','30

0270')
insert into District values('28','2','东丽区','300300')
insert into District values('29','2','西青区','300380')
insert into District values('30','2','津南区','300350')
insert into District values('31','2','北辰区','300400')
insert into District values('32','2','武清区','301700')
insert into District values('33','2','宝坻区','301800')
insert into District values('34','2','宁河县','301500')
insert into District values('35','2','静海县','301600')
insert into District values('36','2','蓟县','301900')
insert into District values('37','2','保税区','300308')
insert into District values('38','2','经济技术开发区','300457')
insert into District values('39','2','高新区','300384')
insert into District values('40','2','滨海新区','300457')
insert into District values('41','3','长安区','050011')
insert into District values('42','3','桥东区','050011')
insert into District values('43','3','桥西区','050051')
insert into District values('44','3','新华区','050051')
insert into District values('45','3','井陉矿区','050100')
insert into District values('46','3','裕华区','050081')
insert into District values('47','3','井陉县','050300')
insert into District values('48','3','正定县','050800')
insert into District values('49','3','栾城县','051430')
insert into District values('50','3','行唐县','050600')
insert into District values('51','3','灵寿县','050500')
insert into District values('52','3','高邑县','051330')
insert into District values('53','3','深泽县','052560')
insert into District values('54','3','赞皇县','051230')
insert into District values('55','3','无极县','052400')
insert into District values('56','3','平山县','050400')
insert into District values('57','3','元氏县','051130')
insert into District values('58','3','赵县','051530')
insert into District values('59','3','辛集市','052300')
insert into District values('60','3','藁城市','052160')
insert into District values('61','3','晋州市','052200')
insert into District values('62','3','新乐市','050700')
insert into District values('63','3','鹿泉市','050200')
insert into District values('64','3','高新技术开发区','050035')
insert into District values('65','4','路南区','063017')
insert into District values('66','4','路北区','063015')
insert into District values('67','4','古冶区','063104')
insert into District values('68','4','开平区','063021')
insert into District values('69','4','丰南区','063300')
insert into District values('70','4','丰润区','064000')
insert into District values('71','4','滦县','063700')
insert into District values('72','4','滦南县','063500')
insert into District values('73','4','乐亭县','063600')
insert into District values('74','4','迁西县','064300')
insert into District values('75','4','玉田县','064100')
insert into District values('76','4','唐

海县','063200')
insert into District values('77','4','遵化市','064200')
insert into District values('78','4','迁安市','064400')
insert into District values('79','4','高新区','063020')
insert into District values('80','4','汉沽管理区','301501')
insert into District values('81','4','海港开发区','063600')
insert into District values('82','4','芦台开发区','301501')
insert into District values('83','4','南堡开发区','063305')
insert into District values('84','4','曹妃甸工业区','063200')
insert into District values('85','5','海港区','066000')
insert into District values('86','5','山海关区','066200')
insert into District values('87','5','北戴河区','066100')
insert into District values('88','5','青龙满族自治县','066500')
insert into District values('89','5','昌黎县','066600')
insert into District values('90','5','抚宁县','066300')
insert into District values('91','5','卢龙县','066400')
insert into District values('92','5','经济技术开发区','066004')
insert into District values('93','6','邯山区','056001')
insert into District values('94','6','丛台区','056004')
insert into District values('95','6','复兴区','056003')
insert into District values('96','6','峰峰矿区','056200')
insert into District values('97','6','邯郸县','056100')
insert into District values('98','6','临漳县','056600')
insert into District values('99','6','成安县','056700')
insert into District values('100','6','大名县','056900')
insert into District values('101','6','涉县','056400')
insert into District values('102','6','磁县','056500')
insert into District values('103','6','肥乡县','057550')
insert into District values('104','6','永年县','057150')
insert into District values('105','6','邱县','057450')
insert into District values('106','6','鸡泽县','057350')
insert into District values('107','6','广平县','057650')
insert into District values('108','6','馆陶县','057750')
insert into District values('109','6','魏县','056800')
insert into District values('110','6','曲周县','057250')
insert into District values('111','6','武安市','056300')
insert into District values('112','6','经济开发区','056002')
insert into District values('113','7','桥东区','054001')
insert into District values('114','7','桥西区','054000')
insert into District values('115','7','邢台县','054001')
insert into District values('116','7','临城县','054300')
insert into District values('117','7','内丘县','054200')
insert into District values('118','7','柏乡县','055450')
insert into District values('119','7','隆尧县','055350')
insert into District values('120','7','任县','055150')
insert into District values('121','7','南和县','054400')
insert into District values('122','7','宁晋县','055550')
insert into District values('123','7','巨鹿县','055250')
insert into District values('124'

,'7','新河县','051730')
insert into District values('125','7','广宗县','054600')
insert into District values('126','7','平乡县','054500')
insert into District values('127','7','威县','054700')
insert into District values('128','7','清河县','054800')
insert into District values('129','7','临西县','054900')
insert into District values('130','7','南宫市','055750')
insert into District values('131','7','沙河市','054100')
insert into District values('132','8','新市区','071052')
insert into District values('133','8','南市区','071000')
insert into District values('134','8','北市区','071000')
insert into District values('135','8','满城县','072150')
insert into District values('136','8','清苑县','071100')
insert into District values('137','8','涞水县','074100')
insert into District values('138','8','阜平县','073200')
insert into District values('139','8','徐水县','072550')
insert into District values('140','8','定兴县','072650')
insert into District values('141','8','唐县','072350')
insert into District values('142','8','高阳县','071500')
insert into District values('143','8','容城县','071700')
insert into District values('144','8','涞源县','074300')
insert into District values('145','8','望都县','072450')
insert into District values('146','8','安新县','071600')
insert into District values('147','8','易县','074200')
insert into District values('148','8','曲阳县','073100')
insert into District values('149','8','蠡县','071400')
insert into District values('150','8','顺平县','072250')
insert into District values('151','8','博野县','071300')
insert into District values('152','8','雄县','071800')
insert into District values('153','8','涿州市','072750')
insert into District values('154','8','定州市','073000')
insert into District values('155','8','安国市','071200')
insert into District values('156','8','高碑店市','074000')
insert into District values('157','9','桥东区','075000')
insert into District values('158','9','桥西区','075061')
insert into District values('159','9','宣化区','075100')
insert into District values('160','9','下花园区','075300')
insert into District values('161','9','宣化县','075100')
insert into District values('162','9','张北县','076450')
insert into District values('163','9','康保县','076650')
insert into District values('164','9','沽源县','076550')
insert into District values('165','9','尚义县','076750')
insert into District values('166','9','蔚县','075700')
insert into District values('167','9','阳原县','075800')
insert into District values('168','9','怀安县','076150')
insert into District values('169','9','万全县','076250')
insert into District values('170','9','怀来县','075400')
insert into District values('171','9','涿鹿县','075600')
insert into District values('172','9','赤城县','075500')
insert

into District values('173','9','崇礼县','076350')
insert into District values('174','10','双桥区','067000')
insert into District values('175','10','双滦区','067000')
insert into District values('176','10','鹰手营子矿区','067200')
insert into District values('177','10','承德县','067400')
insert into District values('178','10','兴隆县','067300')
insert into District values('179','10','平泉县','067500')
insert into District values('180','10','滦平县','068250')
insert into District values('181','10','隆化县','068150')
insert into District values('182','10','丰宁满族自治县','068350')
insert into District values('183','10','宽城满族自治县','067600')
insert into District values('184','10','围场满族蒙古族自治县','068450')
insert into District values('185','11','新华区','061000')
insert into District values('186','11','运河区','061000')
insert into District values('187','11','沧县','061000')
insert into District values('188','11','青县','062650')
insert into District values('189','11','东光县','061600')
insert into District values('190','11','海兴县','061200')
insert into District values('191','11','盐山县','061300')
insert into District values('192','11','肃宁县','062350')
insert into District values('193','11','南皮县','061500')
insert into District values('194','11','吴桥县','061800')
insert into District values('195','11','献县','062250')
insert into District values('196','11','孟村回族自治县','061400')
insert into District values('197','11','泊头市','062150')
insert into District values('198','11','任丘市','062550')
insert into District values('199','11','黄骅市','061100')
insert into District values('200','11','河间市','062450')
insert into District values('201','12','安次区','065000')
insert into District values('202','12','广阳区','065000')
insert into District values('203','12','固安县','065500')
insert into District values('204','12','永清县','065600')
insert into District values('205','12','香河县','065400')
insert into District values('206','12','大城县','065900')
insert into District values('207','12','文安县','065800')
insert into District values('208','12','大厂回族自治县','065300')
insert into District values('209','12','霸州市','065700')
insert into District values('210','12','三河市','065200')
insert into District values('211','12','开发区','065001')
insert into District values('212','13','桃城区','053000')
insert into District values('213','13','枣强县','053100')
insert into District values('214','13','武邑县','053400')
insert into District values('215','13','武强县','053300')
insert into District values('216','13','饶阳县','053900')
insert into District values('217','13','安平县','053600')
insert into District values('218','13','故城县','253800')
insert into District values('219','13','

景县','053500')
insert into District values('220','13','阜城县','053700')
insert into District values('221','13','冀州市','053200')
insert into District values('222','13','深州市','053800')
insert into District values('223','14','小店区','030032')
insert into District values('224','14','迎泽区','030024')
insert into District values('225','14','杏花岭区','030001')
insert into District values('226','14','尖草坪区','030003')
insert into District values('227','14','万柏林区','030027')
insert into District values('228','14','晋源区','030025')
insert into District values('229','14','清徐县','030400')
insert into District values('230','14','阳曲县','030100')
insert into District values('231','14','娄烦县','030300')
insert into District values('232','14','古交市','030200')
insert into District values('233','15','城区','037008')
insert into District values('234','15','矿区','037001')
insert into District values('235','15','南郊区','037001')
insert into District values('236','15','新荣区','037002')
insert into District values('237','15','阳高县','038100')
insert into District values('238','15','天镇县','038200')
insert into District values('239','15','广灵县','037500')
insert into District values('240','15','灵丘县','034400')
insert into District values('241','15','浑源县','037400')
insert into District values('242','15','左云县','037100')
insert into District values('243','15','大同县','037300')
insert into District values('244','16','城区','045000')
insert into District values('245','16','矿区','045000')
insert into District values('246','16','郊区','045011')
insert into District values('247','16','平定县','045200')
insert into District values('248','16','盂县','045100')
insert into District values('249','17','城区','046011')
insert into District values('250','17','郊区','046011')
insert into District values('251','17','长治县','047100')
insert into District values('252','17','襄垣县','046200')
insert into District values('253','17','屯留县','046100')
insert into District values('254','17','平顺县','047400')
insert into District values('255','17','黎城县','047600')
insert into District values('256','17','壶关县','047300')
insert into District values('257','17','长子县','046600')
insert into District values('258','17','武乡县','046300')
insert into District values('259','17','沁县','046400')
insert into District values('260','17','沁源县','046500')
insert into District values('261','17','潞城市','047500')
insert into District values('262','18','城区','048000')
insert into District values('263','18','沁水县','048200')
insert into District values('264','18','阳城县','048100')
insert into District values('265','18','陵川县','048300')
insert into District values('266','18','泽州县','048012')
insert into District values('267','18','

高平市','048400')
insert into District values('268','19','朔城区','038500')
insert into District values('269','19','平鲁区','038600')
insert into District values('270','19','山阴县','036900')
insert into District values('271','19','应县','037600')
insert into District values('272','19','右玉县','037200')
insert into District values('273','19','怀仁县','038300')
insert into District values('274','20','榆次区','030600')
insert into District values('275','20','榆社县','031800')
insert into District values('276','20','左权县','032600')
insert into District values('277','20','和顺县','032700')
insert into District values('278','20','昔阳县','045300')
insert into District values('279','20','寿阳县','045400')
insert into District values('280','20','太谷县','030800')
insert into District values('281','20','祁县','030900')
insert into District values('282','20','平遥县','031100')
insert into District values('283','20','灵石县','031300')
insert into District values('284','20','介休市','031200')
insert into District values('285','21','盐湖区','044000')
insert into District values('286','21','临猗县','044100')
insert into District values('287','21','万荣县','044200')
insert into District values('288','21','闻喜县','043800')
insert into District values('289','21','稷山县','043200')
insert into District values('290','21','新绛县','043100')
insert into District values('291','21','绛县','043600')
insert into District values('292','21','垣曲县','043700')
insert into District values('293','21','夏县','044400')
insert into District values('294','21','平陆县','044300')
insert into District values('295','21','芮城县','044600')
insert into District values('296','21','永济市','044500')
insert into District values('297','21','河津市','043300')
insert into District values('298','22','忻府区','034000')
insert into District values('299','22','定襄县','035400')
insert into District values('300','22','五台县','035500')
insert into District values('301','22','代县','034200')
insert into District values('302','22','繁峙县','034300')
insert into District values('303','22','宁武县','036700')
insert into District values('304','22','静乐县','035100')
insert into District values('305','22','神池县','036100')
insert into District values('306','22','五寨县','036200')
insert into District values('307','22','岢岚县','036300')
insert into District values('308','22','河曲县','036500')
insert into District values('309','22','保德县','036600')
insert into District values('310','22','偏关县','036400')
insert into District values('311','22','原平市','034100')
insert into District values('312','23','尧都区','041000')
insert into District values('313','23','曲沃县','043400')
insert into District values('314','23','翼城县','043500')
insert into District values('315

','23','襄汾县','041500')
insert into District values('316','23','洪洞县','031600')
insert into District values('317','23','古县','042400')
insert into District values('318','23','安泽县','042500')
insert into District values('319','23','浮山县','042600')
insert into District values('320','23','吉县','042200')
insert into District values('321','23','乡宁县','042100')
insert into District values('322','23','大宁县','042300')
insert into District values('323','23','隰县','041300')
insert into District values('324','23','永和县','041400')
insert into District values('325','23','蒲县','041200')
insert into District values('326','23','汾西县','031500')
insert into District values('327','23','侯马市','043007')
insert into District values('328','23','霍州市','031400')
insert into District values('329','24','离石区','033000')
insert into District values('330','24','文水县','032100')
insert into District values('331','24','交城县','030500')
insert into District values('332','24','兴县','033600')
insert into District values('333','24','临县','033200')
insert into District values('334','24','柳林县','033300')
insert into District values('335','24','石楼县','032500')
insert into District values('336','24','岚县','033500')
insert into District values('337','24','方山县','033100')
insert into District values('338','24','中阳县','033400')
insert into District values('339','24','交口县','032400')
insert into District values('340','24','孝义市','032300')
insert into District values('341','24','汾阳市','032200')
insert into District values('342','25','回民区','010030')
insert into District values('343','25','玉泉区','010020')
insert into District values('344','25','新城区','010030')
insert into District values('345','25','赛罕区','010020')
insert into District values('346','25','土默特左旗','010100')
insert into District values('347','25','托克托县','010200')
insert into District values('348','25','和林格尔县','011500')
insert into District values('349','25','清水河县','011600')
insert into District values('350','25','武川县','011700')
insert into District values('351','26','东河区','014040')
insert into District values('352','26','昆都仑区','014010')
insert into District values('353','26','青山区','014030')
insert into District values('354','26','石拐区','014070')
insert into District values('355','26','白云矿区','014080')
insert into District values('356','26','九原区','014060')
insert into District values('357','26','土默特右旗','014100')
insert into District values('358','26','固阳县','014200')
insert into District values('359','26','达尔罕茂明安联合旗','014500')
insert into District values('360','27','海勃湾区','016000')
insert into District values('361','27','海南区','016030')
insert into District values('362','27','

乌达区','016040')
insert into District values('363','28','红山区','024020')
insert into District values('364','28','元宝山区','024076')
insert into District values('365','28','松山区','024005')
insert into District values('366','28','阿鲁科尔沁旗','025550')
insert into District values('367','28','巴林左旗','025450')
insert into District values('368','28','巴林右旗','025150')
insert into District values('369','28','林西县','025250')
insert into District values('370','28','克什克腾旗','025350')
insert into District values('371','28','翁牛特旗','024500')
insert into District values('372','28','喀喇沁旗','024400')
insert into District values('373','28','宁城县','024200')
insert into District values('374','28','敖汉旗','024300')
insert into District values('375','28','新城区','025350')
insert into District values('376','29','科尔沁区','028000')
insert into District values('377','29','科尔沁左翼中旗','029300')
insert into District values('378','29','科尔沁左翼后旗','028100')
insert into District values('379','29','开鲁县','028400')
insert into District values('380','29','库伦旗','028200')
insert into District values('381','29','奈曼旗','028300')
insert into District values('382','29','扎鲁特旗','029100')
insert into District values('383','29','霍林郭勒市','029200')
insert into District values('384','30','东胜区','017000')
insert into District values('385','30','达拉特旗','014300')
insert into District values('386','30','准格尔旗','017100')
insert into District values('387','30','鄂托克前旗','016200')
insert into District values('388','30','鄂托克旗','016100')
insert into District values('389','30','杭锦旗','017400')
insert into District values('390','30','乌审旗','017300')
insert into District values('391','30','伊金霍洛旗','017200')
insert into District values('392','31','海拉尔区','021000')
insert into District values('393','31','阿荣旗','162750')
insert into District values('394','31','莫力达瓦达斡尔族自治旗','162850')
insert into District values('395','31','鄂伦春自治旗','165450')
insert into District values('396','31','鄂温克族自治旗','021100')
insert into District values('397','31','陈巴尔虎旗','021500')
insert into District values('398','31','新巴尔虎左旗','021200')
insert into District values('399','31','新巴尔虎右旗','021300')
insert into District values('400','31','满洲里市','021400')
insert into District values('401','31','牙克石市','022150')
insert into District values('402','31','扎兰屯市','162650')
insert into District values('403','31','额尔古纳市','022250')
insert into District values('404','31','根河市','022350')
insert into District values('405','32','临河区','015001')
insert into District values('406','32','五原县','015100')
insert into District values('407

','32','磴口县','015200')
insert into District values('408','32','乌拉特前旗','014400')
insert into District values('409','32','乌拉特中旗','015300')
insert into District values('410','32','乌拉特后旗','015500')
insert into District values('411','32','杭锦后旗','015400')
insert into District values('412','33','集宁区','012000')
insert into District values('413','33','卓资县','012300')
insert into District values('414','33','化德县','013350')
insert into District values('415','33','商都县','013450')
insert into District values('416','33','兴和县','013650')
insert into District values('417','33','凉城县','013750')
insert into District values('418','33','察哈尔右翼前旗','012200')
insert into District values('419','33','察哈尔右翼中旗','013550')
insert into District values('420','33','察哈尔右翼后旗','012400')
insert into District values('421','33','四子王旗','011800')
insert into District values('422','33','丰镇市','012100')
insert into District values('423','34','乌兰浩特市','137401')
insert into District values('424','34','阿尔山市','137800')
insert into District values('425','34','科尔沁右翼前旗','137423')
insert into District values('426','34','科尔沁右翼中旗','029400')
insert into District values('427','34','扎赉特旗','137600')
insert into District values('428','34','突泉县','137500')
insert into District values('429','35','二连浩特市','011100')
insert into District values('430','35','锡林浩特市','026000')
insert into District values('431','35','阿巴嘎旗','011400')
insert into District values('432','35','苏尼特左旗','011300')
insert into District values('433','35','苏尼特右旗','011200')
insert into District values('434','35','东乌珠穆沁旗','026300')
insert into District values('435','35','西乌珠穆沁旗','026200')
insert into District values('436','35','太仆寺旗','027000')
insert into District values('437','35','镶黄旗','013250')
insert into District values('438','35','正镶白旗','013800')
insert into District values('439','35','正蓝旗','027200')
insert into District values('440','35','多伦县','027300')
insert into District values('441','36','阿拉善左旗','750306')
insert into District values('442','36','阿拉善右旗','737300')
insert into District values('443','36','额济纳旗','735400')
insert into District values('444','37','和平区','110001')
insert into District values('445','37','沈河区','110013')
insert into District values('446','37','大东区','110041')
insert into District values('447','37','皇姑区','110031')
insert into District values('448','37','铁西区','110021')
insert into District values('449','37','苏家屯区','110101')
insert into District values('450','37','东陵区','110015')
insert into District values('451','37','沈北新区','110121')
insert into District values('

452','37','于洪区','110141')
insert into District values('453','37','辽中县','110200')
insert into District values('454','37','康平县','110500')
insert into District values('455','37','法库县','110400')
insert into District values('456','37','新民市','110300')
insert into District values('457','37','经济技术开发区','110141')
insert into District values('458','37','浑南新区','110179')
insert into District values('459','37','新城子经济技术开发区','110121')
insert into District values('460','38','中山区','116001')
insert into District values('461','38','西岗区','116011')
insert into District values('462','38','沙河口区','116021')
insert into District values('463','38','甘井子区','116033')
insert into District values('464','38','旅顺口区','116041')
insert into District values('465','38','金州区','116100')
insert into District values('466','38','长海县','116500')
insert into District values('467','38','瓦房店市','116300')
insert into District values('468','38','普兰店市','116200')
insert into District values('469','38','庄河市','116400')
insert into District values('470','38','开发区','116600')
insert into District values('471','38','保税区','116600')
insert into District values('472','39','铁东区','114001')
insert into District values('473','39','铁西区','114013')
insert into District values('474','39','立山区','114031')
insert into District values('475','39','千山区','114041')
insert into District values('476','39','台安县','114100')
insert into District values('477','39','岫岩满族自治县','114300')
insert into District values('478','39','海城市','114200')
insert into District values('479','40','新抚区','113008')
insert into District values('480','40','东洲区','113003')
insert into District values('481','40','望花区','113001')
insert into District values('482','40','顺城区','113006')
insert into District values('483','40','抚顺县','113006')
insert into District values('484','40','新宾满族自治县','113200')
insert into District values('485','40','清原满族自治县','113300')
insert into District values('486','41','平山区','117000')
insert into District values('487','41','明山区','117021')
insert into District values('488','41','溪湖区','117002')
insert into District values('489','41','南芬区','117014')
insert into District values('490','41','本溪满族自治县','117100')
insert into District values('491','41','桓仁满族自治县','117200')
insert into District values('492','42','元宝区','118000')
insert into District values('493','42','振兴区','118002')
insert into District values('494','42','振安区','118001')
insert into District values('495','42','宽甸满族自治县','118200')
insert into District values('496','42','东港市','118300')
insert into District values('497','42','凤城市','118100')
insert i

nto District values('498','43','古塔区','121001')
insert into District values('499','43','凌河区','121000')
insert into District values('500','43','太和区','121011')
insert into District values('501','43','黑山县','121400')
insert into District values('502','43','义县','121100')
insert into District values('503','43','凌海市','121200')
insert into District values('504','43','北宁市','121300')
insert into District values('505','43','松山新区','121219')
insert into District values('506','43','经济技术开发区','121007')
insert into District values('507','44','站前区','115002')
insert into District values('508','44','西市区','115004')
insert into District values('509','44','鲅鱼圈区','115007')
insert into District values('510','44','老边区','115005')
insert into District values('511','44','盖州市','115200')
insert into District values('512','44','大石桥市','115100')
insert into District values('513','45','海州区','123000')
insert into District values('514','45','新邱区','123005')
insert into District values('515','45','太平区','123003')
insert into District values('516','45','清河门区','123006')
insert into District values('517','45','细河区','123000')
insert into District values('518','45','阜新蒙古族自治县','123100')
insert into District values('519','45','彰武县','123200')
insert into District values('520','46','白塔区','111000')
insert into District values('521','46','文圣区','111000')
insert into District values('522','46','宏伟区','111003')
insert into District values('523','46','弓长岭区','111008')
insert into District values('524','46','太子河区','111000')
insert into District values('525','46','辽阳县','111200')
insert into District values('526','46','灯塔市','111300')
insert into District values('527','47','双台子区','124000')
insert into District values('528','47','兴隆台区','124010')
insert into District values('529','47','大洼县','124200')
insert into District values('530','47','盘山县','124000')
insert into District values('531','48','银州区','112000')
insert into District values('532','48','清河区','112003')
insert into District values('533','48','铁岭县','112000')
insert into District values('534','48','西丰县','112400')
insert into District values('535','48','昌图县','112500')
insert into District values('536','48','调兵山市','112700')
insert into District values('537','48','开原市','112300')
insert into District values('538','49','双塔区','122000')
insert into District values('539','49','龙城区','122000')
insert into District values('540','49','朝阳县','122000')
insert into District values('541','49','建平县','122400')
insert into District values('542','49','喀喇沁左翼蒙古族自治县','122300')
insert into District values('543','49','北票市','122100')
insert into District values('544','

49','凌源市','122500')
insert into District values('545','50','连山区','125001')
insert into District values('546','50','龙港区','125003')
insert into District values('547','50','南票区','125027')
insert into District values('548','50','绥中县','125200')
insert into District values('549','50','建昌县','125300')
insert into District values('550','50','兴城市','125100')
insert into District values('551','51','南关区','130022')
insert into District values('552','51','宽城区','130051')
insert into District values('553','51','朝阳区','130012')
insert into District values('554','51','二道区','130031')
insert into District values('555','51','绿园区','130062')
insert into District values('556','51','双阳区','130600')
insert into District values('557','51','农安县','130200')
insert into District values('558','51','九台市','130500')
insert into District values('559','51','榆树市','130400')
insert into District values('560','51','德惠市','130300')
insert into District values('561','51','净月经济开发区','130117')
insert into District values('562','51','高新技术产业开发区','130015')
insert into District values('563','51','经济技术开发区','130022')
insert into District values('564','52','昌邑区','132002')
insert into District values('565','52','龙潭区','132021')
insert into District values('566','52','船营区','132011')
insert into District values('567','52','丰满区','132013')
insert into District values('568','52','永吉县','132200')
insert into District values('569','52','蛟河市','132500')
insert into District values('570','52','桦甸市','132400')
insert into District values('571','52','舒兰市','132600')
insert into District values('572','52','磐石市','132300')
insert into District values('573','53','铁西区','136000')
insert into District values('574','53','铁东区','136001')
insert into District values('575','53','梨树县','136500')
insert into District values('576','53','伊通满族自治县','130700')
insert into District values('577','53','公主岭市','136100')
insert into District values('578','53','双辽市','136400')
insert into District values('579','54','龙山区','136200')
insert into District values('580','54','西安区','136201')
insert into District values('581','54','东丰县','136300')
insert into District values('582','54','东辽县','136600')
insert into District values('583','55','东昌区','134001')
insert into District values('584','55','二道江区','134003')
insert into District values('585','55','通化县','134100')
insert into District values('586','55','辉南县','135100')
insert into District values('587','55','柳河县','135300')
insert into District values('588','55','梅河口市','135000')
insert into District values('589','55','集安市','134200')
insert into District values('590','56','八道江区','134300')
insert i