IT技术互动交流平台

省市县三级地区列表显示

发布日期:2016-07-08 22:04:42

有些项目需要保存用户的注册信息,自然地区的信息显示是必不可少的,下面将之前整理的全国省市县的地区arraylist及sql展示如下:

1、在android arrays.xml中显示:只到二级:eg:湖南省长沙市

 

<?xml version="1.0" encoding="utf-8"?>
<resources>
  
    <string-array name="all_city_area">
        <item >北京</item>
        <item >天津</item>
        <item >河北</item>
        <item >山西</item>
        <item >内蒙古</item>
        <item >辽宁</item>
        <item >吉林</item>
        <item >黑龙江</item>
        <item >上海</item>
        <item >江苏</item>
        <item >浙江</item>
        <item >安徽</item>
        <item >福建</item>
        <item >江西</item>
        <item >山东</item>
        <item >河南</item>
        <item >湖北</item>
        <item >湖南</item>
        <item >广东</item>
        <item >广西</item>
        <item >海南</item>
        <item >重庆</item>
        <item >四川</item>
        <item >贵州</item>
        <item >云南</item>
        <item >西藏</item>
        <item >陕西</item>
        <item >甘肃</item>
        <item >青海</item>
        <item >宁夏</item>
        <item >新疆</item>
        
     </string-array>
     
    <string-array name="beijing">
        <item >西城区</item>
        <item >崇文区</item>
        <item >宣武区</item>
        <item >朝阳区</item>
        <item >丰台区</item>
        <item >石景山区</item>
        <item >海淀区</item>
        <item >门头沟区</item>
        <item >房山区</item>
        <item >通州区</item>
        <item >顺义区</item>
        <item >昌平区</item>
        <item >大兴区</item>
        <item >平谷区</item>
        <item >怀柔区</item>
        <item >密云县</item>
        <item >延庆县</item>
    </string-array>
    
    <string-array name="tianjing">
        <item >河东区</item>
        <item >河西区</item>
        <item >南开区</item>
        <item >河北区</item>
        <item >红桥区</item>
        <item >塘沽区</item>
        <item >汉沽区</item>
        <item >大港区</item>
        <item >东丽区</item>
        <item >西青区</item>
        <item >津南区</item>
        <item >北辰区</item>
        <item >武清区</item>
        <item >宝坻区</item>
        <item >宁河县</item>
        <item >静海县</item>
    </string-array>
    
    <string-array name="hebei">
        <item>石家庄市</item>
        <item>唐山市</item>
        <item>秦皇岛市</item>
        <item>邯郸市</item>
	<item>邢台市</item>
	<item>保定市</item>
	<item>张家口市</item>
	<item>承德市</item>
	<item>沧州市</item>
	<item>廊坊市</item>
	<item>衡水市</item>
        
    </string-array>
    
    <string-array name="shanxi">
        <item>太原市</item>
		<item>大同市</item>
		<item>阳泉市</item>
		<item>长治市</item>
		<item>晋城市</item>
		<item>朔州市</item>
		<item>忻州市</item>
		<item>吕梁市</item>
		<item>晋中市</item>
		<item>临汾市</item>
		<item>运城市</item>
    </string-array>
    
    <string-array name="neimenggu">
                <item>呼和浩特市</item>
		<item>包头市</item>
		<item>乌海市</item>
		<item>赤峰市</item>
		<item>呼伦贝尔市</item>
		<item>兴安盟</item>
		<item>通辽市</item>
		<item>锡林郭勒盟</item>
		<item>乌兰察布盟</item>
		<item>伊克昭盟</item>
		<item>巴彦淖尔盟</item>
		<item>阿拉善盟</item>
    </string-array>
    
    <string-array name="liaoning">
        	<item>沈阳市</item>
		<item>大连市</item>
		<item>鞍山市</item>
		<item>抚顺市</item>
		<item>本溪市</item>
		<item>丹东市</item>
		<item>锦州市</item>
		<item>营口市</item>
		<item>阜新市</item>
		<item>辽阳市</item>
		<item>盘锦市</item>
		<item>铁岭市</item>
		<item>朝阳市</item>
		<item>葫芦岛市</item>
    </string-array>
    
    <string-array name="jiling">
		<item>长春市</item>
		<item>吉林市</item>
		<item>四平市</item>
		<item>辽源市</item>
		<item>通化市</item>
		<item>白山市</item>
		<item>松原市</item>
		<item>白城市</item>
		<item>延边朝鲜族自治州</item>
    </string-array>
    
    <string-array name="heilongjiang">
		<item>哈尔滨市</item>
		<item>齐齐哈尔市</item>
		<item>鸡西市</item>
		<item>鹤岗市</item>
		<item>双鸭山市</item>
		<item>大庆市</item>
		<item>伊春市</item>
		<item>佳木斯市</item>
		<item>七台河市</item>
		<item>牡丹江市</item>
		<item>黑河市</item>
		<item>绥化市</item>
		<item>大兴安岭地区</item>
     </string-array>
    
    <string-array name="shanghai">
		<item>徐汇区</item>
		<item>黄浦区</item>
		<item>杨浦区</item>
		<item>虹口区</item>
		<item>闵行区</item>
		<item>长宁区</item>
		<item>普陀区</item>
		<item>宝山区</item>
		<item>静安区</item>
		<item>闸北区</item>
		<item>卢湾区</item>
		<item>松江区</item>
		<item>嘉定区</item>
		<item>南汇区</item>
		<item>金山区</item>
		<item>青浦区</item>
		<item>奉贤区</item>
		<item>崇明县</item>
	</string-array>

    <string-array name="jiangsu">
		<item>南京市</item>
		<item>无锡市</item>
		<item>徐州市</item>
		<item>常州市</item>
		<item>苏州市</item>
		<item>南通市</item>
		<item>连云港市</item>
		<item>淮阴市</item>
		<item>盐城市</item>
		<item>扬州市</item>
		<item>镇江市</item>
		<item>泰州市</item>
		<item>宿迁市</item>
	</string-array>

    
    <string-array name="zhejiang">
		<item>杭州市</item>
		<item>宁波市</item>
		<item>温州市</item>
		<item>嘉兴市</item>
		<item>湖州市</item>
		<item>绍兴市</item>
		<item>金华市</item>
		<item>衢州市</item>
		<item>舟山市</item>
		<item>台州市</item>
		<item>丽水市</item>
	</string-array>

    <string-array name="anhui">
		<item>合肥市</item>
		<item>芜湖市</item>
		<item>蚌埠市</item>
		<item>淮南市</item>
		<item>马鞍山市</item>
		<item>淮北市</item>
		<item>铜陵市</item>
		<item>安庆市</item>
		<item>黄山市</item>
		<item>滁州市</item>
		<item>阜阳市</item>
		<item>宿州市</item>
		<item>六安市</item>
		<item>宣城市</item>
		<item>巢湖市</item>
		<item>池州市</item>
	</string-array>

    <string-array name="fujian">
		<item>福州市</item>
		<item>厦门市</item>
		<item>宁德市</item>
		<item>莆田市</item>
		<item>泉州市</item>
		<item>漳州市</item>
		<item>龙岩</item>
		<item>三明市</item>
		<item>南平市</item>
	</string-array>
	
    
	<string-array name="jiangxi">
		<item>南昌市</item>
		<item>景德镇市</item>
		<item>萍乡市</item>
		<item>九江市</item>
		<item>新余市</item>
		<item>鹰潭市</item>
		<item>赣州市</item>
		<item>宜春市</item>
		<item>上饶市</item>
		<item>吉安市</item>
		<item>抚州市</item>
	</string-array>


	<string-array name="shandong">
		<item>济南市</item>
		<item>青岛市</item>
		<item>淄博市</item>
		<item>枣庄市</item>
		<item>东营市</item>
		<item>烟台市</item>
		<item>潍坊市</item>
		<item>济宁市</item>
		<item>泰安市</item>
		<item>威海市</item>
		<item>日照市</item>
		<item>莱芜市</item>
		<item>临沂市</item>
		<item>德州市</item>
		<item>聊城市</item>
		<item>滨州地区</item>
		<item>菏泽地区</item>
	</string-array>


	<string-array name="henan">
		<item>郑州市</item>
		<item>开封市</item>
		<item>洛阳市</item>
		<item>平顶山市</item>
		<item>安阳市</item>
		<item>鹤壁市</item>
		<item>新乡市</item>
		<item>焦作市</item>
		<item>濮阳市</item>
		<item>许昌市</item>
		<item>漯河市</item>
		<item>三门峡市</item>
		<item>南阳市</item>
		<item>商丘市</item>
		<item>信阳市</item>
		<item>周口市</item>
		<item>驻马店地区</item>
		<item>省直辖行政单位</item>
	</string-array>


	<string-array name="hubei">
		<item>武汉市</item>
		<item>黄石市</item>
		<item>十堰市</item>
		<item>宜昌市</item>
		<item>襄樊市</item>
		<item>鄂州市</item>
		<item>荆门市</item>
		<item>孝感市</item>
		<item>荆州市</item>
		<item>黄冈市</item>
		<item>咸宁市</item>
		<item>恩施土家族苗族自治州</item>
		<item>省直辖行政单位</item>
	</string-array>


	<string-array name="hunan">
		<item>长沙市</item>
		<item>株洲市</item>
		<item>湘潭市</item>
		<item>衡阳市</item>
		<item>邵阳市</item>
		<item>岳阳市</item>
		<item>常德市</item>
		<item>张家界市</item>
		<item>益阳市</item>
		<item>郴州市</item>
		<item>永州市</item>
		<item>怀化市</item>
		<item>娄底地区</item>
		<item>湘西土家族苗族自治州</item>
	</string-array>

	<string-array name="guangdong">
		<item>广州市</item>
		<item>韶关市</item>
		<item>深圳市</item>
		<item>珠海市</item>
		<item>汕头市</item>
		<item>佛山市</item>
		<item>江门市</item>
		<item>湛江市</item>
		<item>茂名市</item>
		<item>肇庆市</item>
		<item>惠州市</item>
		<item>梅州市</item>
		<item>汕尾市</item>
		<item>河源市</item>
		<item>阳江市</item>
		<item>清远市</item>
		<item>东莞市</item>
		<item>中山市</item>
		<item>潮州市</item>
		<item>揭阳市</item>
		<item>云浮市</item>
	</string-array>

	<string-array name="guangxi">
		<item>南宁市</item>
		<item>柳州市</item>
		<item>桂林市</item>
		<item>梧州市</item>
		<item>北海市</item>
		<item>防城港市</item>
		<item>钦州市</item>
		<item>贵港市</item>
		<item>玉林市</item>
		<item>崇左市</item>
		<item>来宾市</item>
		<item>贺州市</item>
		<item>百色市</item>
		<item>河池市</item>
	</string-array>

	<string-array name="hainan">
		<item>省直辖行政单位</item>
		<item>海口市</item>
		<item>三亚市</item>
	</string-array>

	<string-array name="chongqing">
		<item>涪陵区</item>
		<item>渝中区</item>
		<item>大渡口区</item>
		<item>江北区</item>
		<item>沙坪坝区</item>
		<item>九龙坡区</item>
		<item>南岸区</item>
		<item>北碚区</item>
		<item>万盛区</item>
		<item>双桥区</item>
		<item>渝北区</item>
		<item>巴南区</item>
		<item>长寿县</item>
		<item>綦江县</item>
		<item>潼南县</item>
		<item>铜梁县</item>
		<item>大足县</item>
		<item>荣昌县</item>
		<item>璧山县</item>
		<item>梁平县</item>
		<item>城口县</item>
		<item>丰都县</item>
		<item>垫江县</item>
		<item>武隆县</item>
		<item>云阳县</item>
		<item>奉节县</item>
		<item>巫山县</item>
		<item>巫溪县</item>
		<item>黔江土家族苗族自治县</item>
		<item>石柱土家族自治县</item>
		<item>秀山土家族苗族自治县</item>
		<item>酉阳土家族苗族自治县</item>
		<item>彭水苗族土家族自治县</item>
		<item>江津市</item>
		<item>合川市</item>
		<item>永川市</item>
		<item>南川市</item>
	</string-array>


	<string-array name="sichuan">
		<item>成都市</item>
		<item>自贡市</item>
		<item>攀枝花市</item>
		<item>泸州市</item>
		<item>德阳市</item>
		<item>绵阳市</item>
		<item>广元市</item>
		<item>遂宁市</item>
		<item>内江市</item>
		<item>乐山市</item>
		<item>南充市</item>
		<item>宜宾市</item>
		<item>广安市</item>
		<item>达川地区</item>
		<item>雅安地区</item>
		<item>阿坝藏族羌族自治州</item>
		<item>甘孜藏族自治州</item>
		<item>凉山彝族自治州</item>
		<item>巴中地区</item>
		<item>眉山地区</item>
		<item>资阳地区</item>
	</string-array>


	<string-array name="guizhou">
		<item>贵阳市</item>
		<item>六盘水市</item>
		<item>遵义市</item>
		<item>铜仁地区</item>
		<item>黔西南布依族苗族自治州</item>
		<item>毕节地区</item>
		<item>安顺地区</item>
		<item>黔东南苗族侗族自治州</item>
		<item>黔南布依族苗族自治州</item>
	</string-array>


	<string-array name="yunan">
		<item>昆明市</item>
		<item>曲靖市</item>
		<item>玉溪市</item>
		<item>昭通地区</item>
		<item>楚雄彝族自治州</item>
		<item>红河哈尼族彝族自治州</item>
		<item>文山壮族苗族自治州</item>
		<item>思茅市</item>
		<item>西双版纳傣族自治州</item>
		<item>大理白族自治州</item>
		<item>保山地区</item>
		<item>德宏傣族景颇族自治州</item>
		<item>丽江地区</item>
		<item>怒江傈僳族自治州</item>
		<item>迪庆藏族自治州</item>
		<item>临沧地区</item>
	</string-array>


	<string-array name="xizang">
		<item>拉萨市</item>
		<item>昌都地区</item>
		<item>山南地区</item>
		<item>日喀则地区</item>
		<item>那曲地区</item>
		<item>阿里地区</item>
		<item>林芝地区</item>
	</string-array>


	<string-array name="shengxi">
		<item>西安市</item>
		<item>铜川市</item>
		<item>宝鸡市</item>
		<item>咸阳市</item>
		<item>渭南市</item>
		<item>延安市</item>
		<item>汉中市</item>
		<item>安康地区</item>
		<item>商洛地区</item>
		<item>榆林地区</item>
	</string-array>


	<string-array name="gansu">
		<item>兰州市</item>
		<item>嘉峪关市</item>
		<item>金昌市</item>
		<item>白银市</item>
		<item>天水市</item>
		<item>酒泉地区</item>
		<item>张掖地区</item>
		<item>武威地区</item>
		<item>定西地区</item>
		<item>陇南地区</item>
		<item>平凉地区</item>
		<item>庆阳地区</item>
		<item>临夏回族自治州</item>
		<item>甘南藏族自治州</item>
	</string-array>


	<string-array name="qinghai">
		<item>西宁市</item>
		<item>海东地区</item>
		<item>海北藏族自治州</item>
		<item>黄南藏族自治州</item>
		<item>海南藏族自治州</item>
		<item>果洛藏族自治州</item>
		<item>玉树藏族自治州</item>
		<item>海西蒙古族藏族自治州</item>
	</string-array>


	<string-array name="ningxia">
		<item>银川市</item>
		<item>石嘴山市</item>
		<item>吴忠市</item>
		<item>固原地区</item>
		<item>中卫</item>
	</string-array>


	<string-array name="xinjiang">
		<item>乌鲁木齐市</item>
		<item>克拉玛依市</item>
		<item>吐鲁番地区</item>
		<item>哈密地区</item>
		<item>昌吉回族自治州</item>
		<item>博尔塔拉蒙古自治州</item>
		<item>巴音郭楞蒙古自治州</item>
		<item>阿克苏地区</item>
		<item>克孜勒苏柯尔克孜自治州</item>
		<item>喀什地区</item>
		<item>和田地区</item>
		<item>伊犁哈萨克自治州</item>
		<item>塔城地区</item>
		<item>阿勒泰地区</item>
		<item>省直辖行政单位</item>
	</string-array>
    
</resources>

 

2、数据库表设计:

表结构:

areaId int

type char

name varchar

parentId varchar

省类型:"1"、直辖市类型:"2"、省级市/区:"11"、省直辖单位:"12"、直辖市区类型:"21"、直辖市县类型:"22" 省直辖市的父类型为空

 

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

 

延伸阅读:

Tag标签: 省市   地区  
  • 专题推荐

About IT165 - 广告服务 - 隐私声明 - 版权申明 - 免责条款 - 网站地图 - 网友投稿 - 联系方式
本站内容来自于互联网,仅供用于网络技术学习,学习中请遵循相关法律法规