加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 百科 > 正文

全国省市XML和数据库

发布时间:2020-12-16 02:14:11 所属栏目:百科 来源:网络整理
导读:记录记录 ?xml version = "1.0" encoding= "utf-8" ?resources string -array name = "citys_01" item 哈尔滨/ item item 齐齐哈尔/ item item 牡丹江/ item item 佳木斯/ item item 大庆/ item item 绥化/ item item 鹤岗/ item item 鸡西/ item item 黑河/

记录记录

<?xml version="1.0" encoding="utf-8"?>
<resources>

    <string-array name="citys_01">
        <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="citys_02">
        <item>长春</item>
        <item>吉林</item>
        <item>四平</item>
        <item>辽源</item>
        <item>通化</item>
        <item>白山</item>
        <item>松原</item>
        <item>白城</item>
        <item>延吉</item>
    </string-array>
    <string-array name="citys_03">
        <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="citys_04">
        <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="citys_05">
        <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="citys_06">
        <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="citys_07">
        <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="citys_08">
        <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="citys_09">
        <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="citys_10">
        <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="citys_11">
        <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="citys_12">
        <item>银川</item>
        <item>石嘴山</item>
        <item>吴忠</item>
        <item>固原</item>
        <item>中卫</item>
    </string-array>
    <string-array name="citys_13">
        <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="citys_14">
        <item>西宁</item>
        <item>海东</item>
        <item>海北</item>
        <item>黄南</item>
        <item>海南</item>
        <item>果洛</item>
        <item>玉树</item>
        <item>海西</item>
    </string-array>
    <string-array name="citys_15">
        <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="citys_16">
        <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="citys_17">
        <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="citys_18">
        <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="citys_19">
        <item>福州</item>
        <item>厦门</item>
        <item>莆田</item>
        <item>三明</item>
        <item>泉州</item>
        <item>漳州</item>
        <item>南平</item>
        <item>龙岩</item>
        <item>宁德</item>
    </string-array>
    <string-array name="citys_20">
        <item>贵阳</item>
        <item>六盘水</item>
        <item>遵义</item>
        <item>安顺</item>
        <item>铜仁</item>
        <item>黔西南</item>
        <item>毕节</item>
        <item>黔东南</item>
        <item>黔南</item>
    </string-array>
    <string-array name="citys_21">
        <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="citys_22">
        <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="citys_23">
        <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="citys_24">
        <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="citys_25">
        <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="citys_26">
        <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="citys_27">
        <item>拉萨</item>
        <item>昌都</item>
        <item>山南</item>
        <item>日喀则</item>
        <item>那曲</item>
        <item>阿里</item>
        <item>林芝</item>
    </string-array>
    <string-array name="citys_28">
        <item>台湾</item>
    </string-array>
    <string-array name="citys_29">
        <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="citys_30">
        <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="citys_31">
        <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="citys_32">
        <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>
        <item>江津</item>
        <item>合川</item>
        <item>永川</item>
        <item>南川</item>
    </string-array>
    <string-array name="citys_33">
        <item>香港</item>
        <item>新界</item>
    </string-array>
    <string-array name="citys_34">
        <item>澳门</item>
    </string-array>
    <string-array name="citys_35">
        <item>钓鱼岛</item>
    </string-array>
    <string-array name="citys_36">
        <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>

</resources>

钓鱼岛????

CREATE TABLE swf_area ( id INT AUTO_INCREMENT PRIMARY KEY,parent_id INT NOT NULL DEFAULT 0,name VARCHAR(50) NOT NULL,sort INT NOT NULL DEFAULT 0 )ENGINE=INNODB DEFAULT CHARSET=UTF8;

INSERT INTO swf_area VALUES(0100,0,'安徽',1);
INSERT INTO swf_area VALUES(0101,0100,'合肥',1);
INSERT INTO swf_area VALUES(0102,'安庆',1);
INSERT INTO swf_area VALUES(0103,'毫州',1);
INSERT INTO swf_area VALUES(0104,'蚌埠',1);
INSERT INTO swf_area VALUES(0105,'滁州',1);
INSERT INTO swf_area VALUES(0106,'巢湖',1);
INSERT INTO swf_area VALUES(0107,'池州',1);
INSERT INTO swf_area VALUES(0108,'阜阳',1);
INSERT INTO swf_area VALUES(0109,'淮北',1);
INSERT INTO swf_area VALUES(0110,'淮南',1);
INSERT INTO swf_area VALUES(0111,'黄山站',1);
INSERT INTO swf_area VALUES(0112,'六安',1);
INSERT INTO swf_area VALUES(0113,'马鞍山',1);
INSERT INTO swf_area VALUES(0114,'宿州',1);
INSERT INTO swf_area VALUES(0115,'铜陵',1);
INSERT INTO swf_area VALUES(0116,'芜湖',1);
INSERT INTO swf_area VALUES(0117,'宣城',1);

INSERT INTO swf_area VALUES(0200,'澳门',2);

INSERT INTO swf_area VALUES(0300,'北京',3);

INSERT INTO swf_area VALUES(0400,'重庆',4);

INSERT INTO swf_area VALUES(0500,'福建',5);
INSERT INTO swf_area VALUES(0501,0500,'福州',5);
INSERT INTO swf_area VALUES(0502,'龙岩',5);
INSERT INTO swf_area VALUES(0503,'南平',5);
INSERT INTO swf_area VALUES(0504,'宁德',5);
INSERT INTO swf_area VALUES(0505,'莆田',5);
INSERT INTO swf_area VALUES(0506,'泉州',5);
INSERT INTO swf_area VALUES(0507,'三明',5);
INSERT INTO swf_area VALUES(0508,'厦门',5);
INSERT INTO swf_area VALUES(0509,'漳州',5);

INSERT INTO swf_area VALUES(0600,'甘肃',6);
INSERT INTO swf_area VALUES(0601,0600,'兰州',6);
INSERT INTO swf_area VALUES(0602,'白银',6);
INSERT INTO swf_area VALUES(0603,'定西',6);
INSERT INTO swf_area VALUES(0604,'合作',6);
INSERT INTO swf_area VALUES(0605,'金昌',6);
INSERT INTO swf_area VALUES(0606,'酒泉',6);
INSERT INTO swf_area VALUES(0607,'嘉峪关',6);
INSERT INTO swf_area VALUES(0608,'临夏',6);
INSERT INTO swf_area VALUES(0609,'平凉',6);
INSERT INTO swf_area VALUES(0610,'庆阳',6);
INSERT INTO swf_area VALUES(0611,'天水',6);
INSERT INTO swf_area VALUES(0612,'武威',6);
INSERT INTO swf_area VALUES(0613,'武都',6);
INSERT INTO swf_area VALUES(0614,'张掖',6);

INSERT INTO swf_area VALUES(0700,'广东',7);
INSERT INTO swf_area VALUES(0701,0700,'广州',7);
INSERT INTO swf_area VALUES(0702,'潮州',7);
INSERT INTO swf_area VALUES(0703,'东莞',7);
INSERT INTO swf_area VALUES(0704,'佛山',7);
INSERT INTO swf_area VALUES(0705,'河源',7);
INSERT INTO swf_area VALUES(0706,'惠州',7);
INSERT INTO swf_area VALUES(0707,'江门',7);
INSERT INTO swf_area VALUES(0708,'揭阳',7);
INSERT INTO swf_area VALUES(0709,'梅州',7);
INSERT INTO swf_area VALUES(0710,'茂名',7);
INSERT INTO swf_area VALUES(0711,'清远',7);
INSERT INTO swf_area VALUES(0712,'深圳',7);
INSERT INTO swf_area VALUES(0713,'汕头',7);
INSERT INTO swf_area VALUES(0714,'韶关',7);
INSERT INTO swf_area VALUES(0715,'汕尾',7);
INSERT INTO swf_area VALUES(0716,'阳江',7);
INSERT INTO swf_area VALUES(0717,'云浮',7);
INSERT INTO swf_area VALUES(0718,'珠海',7);
INSERT INTO swf_area VALUES(0719,'中山',7);
INSERT INTO swf_area VALUES(0720,'湛江',7);
INSERT INTO swf_area VALUES(0721,'肇庆',7);

INSERT INTO swf_area VALUES(0800,'广西',8);
INSERT INTO swf_area VALUES(0801,0800,'南宁',8);
INSERT INTO swf_area VALUES(0802,'北海',8);
INSERT INTO swf_area VALUES(0803,'白色',8);
INSERT INTO swf_area VALUES(0804,'崇左',8);
INSERT INTO swf_area VALUES(0805,'防城港',8);
INSERT INTO swf_area VALUES(0806,'桂林',8);
INSERT INTO swf_area VALUES(0807,'贵港',8);
INSERT INTO swf_area VALUES(0808,'贺州',8);
INSERT INTO swf_area VALUES(0809,'河池',8);
INSERT INTO swf_area VALUES(0810,'柳州',8);
INSERT INTO swf_area VALUES(0811,'来宾',8);
INSERT INTO swf_area VALUES(0812,'钦州',8);
INSERT INTO swf_area VALUES(0813,'梧州',8);
INSERT INTO swf_area VALUES(0814,'玉林',8);

INSERT INTO swf_area VALUES(0900,'贵州',9);
INSERT INTO swf_area VALUES(0901,0900,'贵阳',9);
INSERT INTO swf_area VALUES(0902,'安顺',9);
INSERT INTO swf_area VALUES(0903,'毕节',9);
INSERT INTO swf_area VALUES(0904,'都匀',9);
INSERT INTO swf_area VALUES(0905,'凯里',9);
INSERT INTO swf_area VALUES(0906,'六盘水',9);
INSERT INTO swf_area VALUES(0907,'晴隆',9);
INSERT INTO swf_area VALUES(0908,'铜仁',9);
INSERT INTO swf_area VALUES(0909,'兴义',9);
INSERT INTO swf_area VALUES(0910,'遵义',9);

INSERT INTO swf_area VALUES(1000,'海南',10);
INSERT INTO swf_area VALUES(1001,1000,'海口',10);
INSERT INTO swf_area VALUES(1002,'白沙',10);
INSERT INTO swf_area VALUES(1003,'保亭',10);
INSERT INTO swf_area VALUES(1004,'澄迈',10);
INSERT INTO swf_area VALUES(1005,'昌江',10);
INSERT INTO swf_area VALUES(1006,'儋州',10);
INSERT INTO swf_area VALUES(1007,'定安',10);
INSERT INTO swf_area VALUES(1008,'东方',10);
INSERT INTO swf_area VALUES(1009,'临高',10);
INSERT INTO swf_area VALUES(1010,'陵水',10);
INSERT INTO swf_area VALUES(1011,'乐东',10);
INSERT INTO swf_area VALUES(1012,'南沙岛',10);
INSERT INTO swf_area VALUES(1013,'琼海',10);
INSERT INTO swf_area VALUES(1014,'琼中',10);
INSERT INTO swf_area VALUES(1015,'三亚',10);
INSERT INTO swf_area VALUES(1016,'屯昌',10);
INSERT INTO swf_area VALUES(1017,'五指山',10);
INSERT INTO swf_area VALUES(1018,'文昌',10);
INSERT INTO swf_area VALUES(1019,'万宁',10);
INSERT INTO swf_area VALUES(1020,'西沙',10);

INSERT INTO swf_area VALUES(1100,'河北',11);
INSERT INTO swf_area VALUES(1101,1100,'石家庄',11);
INSERT INTO swf_area VALUES(1102,'保定',11);
INSERT INTO swf_area VALUES(1103,'承德',11);
INSERT INTO swf_area VALUES(1104,'沧州',11);
INSERT INTO swf_area VALUES(1105,'衡水',11);
INSERT INTO swf_area VALUES(1106,'邯郸',11);
INSERT INTO swf_area VALUES(1107,'廊坊',11);
INSERT INTO swf_area VALUES(1108,'秦皇岛',11);
INSERT INTO swf_area VALUES(1109,'唐山',11);
INSERT INTO swf_area VALUES(1110,'邢台',11);
INSERT INTO swf_area VALUES(1111,'张家口',11);

INSERT INTO swf_area VALUES(1200,'河南',12);
INSERT INTO swf_area VALUES(1201,1200,'郑州',12);
INSERT INTO swf_area VALUES(1202,'安阳',12);
INSERT INTO swf_area VALUES(1203,'鹤壁',12);
INSERT INTO swf_area VALUES(1204,'焦作',12);
INSERT INTO swf_area VALUES(1205,'济源',12);
INSERT INTO swf_area VALUES(1206,'开封',12);
INSERT INTO swf_area VALUES(1207,'洛阳',12);
INSERT INTO swf_area VALUES(1208,'漯河',12);
INSERT INTO swf_area VALUES(1209,'南阳',12);
INSERT INTO swf_area VALUES(1210,'濮阳',12);
INSERT INTO swf_area VALUES(1211,'平顶山',12);
INSERT INTO swf_area VALUES(1212,'三门峡',12);
INSERT INTO swf_area VALUES(1213,'商丘',12);
INSERT INTO swf_area VALUES(1214,'新乡',12);
INSERT INTO swf_area VALUES(1215,'许昌',12);
INSERT INTO swf_area VALUES(1216,'信阳',12);
INSERT INTO swf_area VALUES(1217,'周口',12);
INSERT INTO swf_area VALUES(1218,'驻马店',12);

INSERT INTO swf_area VALUES(1300,'黑龙江',13);
INSERT INTO swf_area VALUES(1301,1300,'哈尔滨',13);
INSERT INTO swf_area VALUES(1302,'大庆',13);
INSERT INTO swf_area VALUES(1303,'大兴安岭',13);
INSERT INTO swf_area VALUES(1304,'鹤岗',13);
INSERT INTO swf_area VALUES(1305,'黑河',13);
INSERT INTO swf_area VALUES(1306,'佳木斯',13);
INSERT INTO swf_area VALUES(1307,'鸡西',13);
INSERT INTO swf_area VALUES(1308,'牡丹江',13);
INSERT INTO swf_area VALUES(1309,'齐齐哈尔',13);
INSERT INTO swf_area VALUES(1310,'七台河',13);
INSERT INTO swf_area VALUES(1311,'双鸭山',13);
INSERT INTO swf_area VALUES(1312,'绥化',13);
INSERT INTO swf_area VALUES(1313,'伊春',13);

INSERT INTO swf_area VALUES(1400,'湖北',14);
INSERT INTO swf_area VALUES(1401,1400,'武汉',14);
INSERT INTO swf_area VALUES(1402,'鄂州',14);
INSERT INTO swf_area VALUES(1403,'恩施',14);
INSERT INTO swf_area VALUES(1404,'黄石',14);
INSERT INTO swf_area VALUES(1405,'黄冈',14);
INSERT INTO swf_area VALUES(1406,'荆州',14);
INSERT INTO swf_area VALUES(1407,'荆门',14);
INSERT INTO swf_area VALUES(1408,'潜江',14);
INSERT INTO swf_area VALUES(1409,'十堰',14);
INSERT INTO swf_area VALUES(1410,'随州',14);
INSERT INTO swf_area VALUES(1411,'神农架',14);
INSERT INTO swf_area VALUES(1412,'天门',14);
INSERT INTO swf_area VALUES(1413,'襄阳',14);
INSERT INTO swf_area VALUES(1414,'孝感',14);
INSERT INTO swf_area VALUES(1415,'咸宁',14);
INSERT INTO swf_area VALUES(1416,'仙桃',14);
INSERT INTO swf_area VALUES(1417,'宜昌',14);

INSERT INTO swf_area VALUES(1500,'湖南',15);
INSERT INTO swf_area VALUES(1501,1500,'长沙',15);
INSERT INTO swf_area VALUES(1502,'常德',15);
INSERT INTO swf_area VALUES(1503,'郴州',15);
INSERT INTO swf_area VALUES(1504,'衡阳',15);
INSERT INTO swf_area VALUES(1505,'怀化',15);
INSERT INTO swf_area VALUES(1506,'吉首',15);
INSERT INTO swf_area VALUES(1507,'娄底',15);
INSERT INTO swf_area VALUES(1508,'黔阳',15);
INSERT INTO swf_area VALUES(1509,'邵阳',15);
INSERT INTO swf_area VALUES(1510,'湘潭',15);
INSERT INTO swf_area VALUES(1511,'岳阳',15);
INSERT INTO swf_area VALUES(1512,'益阳',15);
INSERT INTO swf_area VALUES(1513,'永州',15);
INSERT INTO swf_area VALUES(1514,'株洲',15);
INSERT INTO swf_area VALUES(1515,'张家界',15);

INSERT INTO swf_area VALUES(1600,'吉林',16);
INSERT INTO swf_area VALUES(1601,1600,'长春',16);
INSERT INTO swf_area VALUES(1602,'白山',16);
INSERT INTO swf_area VALUES(1603,'白城',16);
INSERT INTO swf_area VALUES(1604,16);
INSERT INTO swf_area VALUES(1605,'辽源',16);
INSERT INTO swf_area VALUES(1606,'四平',16);
INSERT INTO swf_area VALUES(1607,'松原',16);
INSERT INTO swf_area VALUES(1608,'通化',16);
INSERT INTO swf_area VALUES(1609,'延吉',16);

INSERT INTO swf_area VALUES(1700,'江苏',17);
INSERT INTO swf_area VALUES(1701,1700,'南京',17);
INSERT INTO swf_area VALUES(1702,'常州',17);
INSERT INTO swf_area VALUES(1703,'淮安',17);
INSERT INTO swf_area VALUES(1704,'连云港',17);
INSERT INTO swf_area VALUES(1705,'南通',17);
INSERT INTO swf_area VALUES(1706,'苏州',17);
INSERT INTO swf_area VALUES(1707,'宿迁',17);
INSERT INTO swf_area VALUES(1708,'秦州',17);
INSERT INTO swf_area VALUES(1709,'无锡',17);
INSERT INTO swf_area VALUES(1710,'徐州',17);
INSERT INTO swf_area VALUES(1711,'盐城',17);
INSERT INTO swf_area VALUES(1712,'扬州',17);
INSERT INTO swf_area VALUES(1713,'镇江',17);

INSERT INTO swf_area VALUES(1800,'江西',18);
INSERT INTO swf_area VALUES(1801,1800,'南昌',18);
INSERT INTO swf_area VALUES(1802,'抚州',18);
INSERT INTO swf_area VALUES(1803,'赣州',18);
INSERT INTO swf_area VALUES(1804,'九江',18);
INSERT INTO swf_area VALUES(1805,'景德镇',18);
INSERT INTO swf_area VALUES(1806,'吉安',18);
INSERT INTO swf_area VALUES(1807,'萍乡',18);
INSERT INTO swf_area VALUES(1808,'上饶',18);
INSERT INTO swf_area VALUES(1809,'新余',18);
INSERT INTO swf_area VALUES(1810,'鹰潭',18);
INSERT INTO swf_area VALUES(1811,'宜春',18);

INSERT INTO swf_area VALUES(1900,'辽宁',19);
INSERT INTO swf_area VALUES(1901,1900,'沈阳',19);
INSERT INTO swf_area VALUES(1902,'鞍山',19);
INSERT INTO swf_area VALUES(1903,'本溪',19);
INSERT INTO swf_area VALUES(1904,'朝阳',19);
INSERT INTO swf_area VALUES(1905,'大连',19);
INSERT INTO swf_area VALUES(1906,'丹东',19);
INSERT INTO swf_area VALUES(1907,'抚顺',19);
INSERT INTO swf_area VALUES(1908,'阜新',19);
INSERT INTO swf_area VALUES(1909,'葫芦岛',19);
INSERT INTO swf_area VALUES(1910,'锦州',19);
INSERT INTO swf_area VALUES(1911,'辽阳',19);
INSERT INTO swf_area VALUES(1912,'盘锦',19);
INSERT INTO swf_area VALUES(1913,'铁岭',19);
INSERT INTO swf_area VALUES(1914,'营口',19);

INSERT INTO swf_area VALUES(2000,'内蒙古',20);
INSERT INTO swf_area VALUES(2001,2000,'呼和浩特',20);
INSERT INTO swf_area VALUES(2002,'阿拉善左旗',20);
INSERT INTO swf_area VALUES(2003,'包头',20);
INSERT INTO swf_area VALUES(2004,'赤峰',20);
INSERT INTO swf_area VALUES(2005,'鄂尔多斯',20);
INSERT INTO swf_area VALUES(2006,'呼伦贝尔',20);
INSERT INTO swf_area VALUES(2007,'集宁',20);
INSERT INTO swf_area VALUES(2008,'临河',20);
INSERT INTO swf_area VALUES(2009,'通辽',20);
INSERT INTO swf_area VALUES(2010,'乌兰浩特',20);
INSERT INTO swf_area VALUES(2011,'乌海',20);
INSERT INTO swf_area VALUES(2012,'锡林浩特',20);

INSERT INTO swf_area VALUES(2100,'宁夏',21);
INSERT INTO swf_area VALUES(2101,2100,'银川',21);
INSERT INTO swf_area VALUES(2102,'固原',21);
INSERT INTO swf_area VALUES(2103,'石嘴山',21);
INSERT INTO swf_area VALUES(2104,'吴忠',21);
INSERT INTO swf_area VALUES(2105,'中卫',21);

INSERT INTO swf_area VALUES(2200,'青海',22);
INSERT INTO swf_area VALUES(2201,2200,'西宁',22);
INSERT INTO swf_area VALUES(2202,'果洛',22);
INSERT INTO swf_area VALUES(2203,'海东',22);
INSERT INTO swf_area VALUES(2204,22);
INSERT INTO swf_area VALUES(2205,'海北',22);
INSERT INTO swf_area VALUES(2206,'海西',22);
INSERT INTO swf_area VALUES(2207,'黄南',22);
INSERT INTO swf_area VALUES(2208,'玉树',22);

INSERT INTO swf_area VALUES(2300,'山东',23);
INSERT INTO swf_area VALUES(2301,2300,'济南',23);
INSERT INTO swf_area VALUES(2302,'滨州',23);
INSERT INTO swf_area VALUES(2303,'东营',23);
INSERT INTO swf_area VALUES(2304,'德州',23);
INSERT INTO swf_area VALUES(2305,'菏泽',23);
INSERT INTO swf_area VALUES(2306,'济宁',23);
INSERT INTO swf_area VALUES(2307,'莱芜',23);
INSERT INTO swf_area VALUES(2308,'临沂',23);
INSERT INTO swf_area VALUES(2309,'聊城',23);
INSERT INTO swf_area VALUES(2310,'青岛',23);
INSERT INTO swf_area VALUES(2311,'日照',23);
INSERT INTO swf_area VALUES(2312,'泰安',23);
INSERT INTO swf_area VALUES(2313,'潍坊',23);
INSERT INTO swf_area VALUES(2314,'威海',23);
INSERT INTO swf_area VALUES(2315,'烟台',23);
INSERT INTO swf_area VALUES(2316,'淄博',23);
INSERT INTO swf_area VALUES(2317,'枣庄',23);

INSERT INTO swf_area VALUES(2400,'山西',24);
INSERT INTO swf_area VALUES(2401,2400,'太原',24);
INSERT INTO swf_area VALUES(2402,'长治',24);
INSERT INTO swf_area VALUES(2403,'大同',24);
INSERT INTO swf_area VALUES(2404,'晋城',24);
INSERT INTO swf_area VALUES(2405,'晋中',24);
INSERT INTO swf_area VALUES(2406,'临汾',24);
INSERT INTO swf_area VALUES(2407,'吕梁',24);
INSERT INTO swf_area VALUES(2408,'朔州',24);
INSERT INTO swf_area VALUES(2409,'忻州',24);
INSERT INTO swf_area VALUES(2410,'阳泉',24);
INSERT INTO swf_area VALUES(2411,'运城',24);

INSERT INTO swf_area VALUES(2500,'陕西',25);
INSERT INTO swf_area VALUES(2501,2500,'西安',25);
INSERT INTO swf_area VALUES(2502,'宝康',25);
INSERT INTO swf_area VALUES(2503,'宝鸡',25);
INSERT INTO swf_area VALUES(2504,'陈仓',25);
INSERT INTO swf_area VALUES(2505,'汉中',25);
INSERT INTO swf_area VALUES(2506,'商洛',25);
INSERT INTO swf_area VALUES(2507,'铜川',25);
INSERT INTO swf_area VALUES(2508,'渭南',25);
INSERT INTO swf_area VALUES(2509,'咸阳',25);
INSERT INTO swf_area VALUES(2510,'延安',25);
INSERT INTO swf_area VALUES(2511,'榆林',25);

INSERT INTO swf_area VALUES(2600,'上海',26);

INSERT INTO swf_area VALUES(2700,'四川',27);
INSERT INTO swf_area VALUES(2701,2700,'成都',27);
INSERT INTO swf_area VALUES(2702,'阿贝',27);
INSERT INTO swf_area VALUES(2703,'巴中',27);
INSERT INTO swf_area VALUES(2704,'德阳',27);
INSERT INTO swf_area VALUES(2705,'达州',27);
INSERT INTO swf_area VALUES(2706,'广元',27);
INSERT INTO swf_area VALUES(2707,'广安',27);
INSERT INTO swf_area VALUES(2708,'甘孜',27);
INSERT INTO swf_area VALUES(2709,'泸州',27);
INSERT INTO swf_area VALUES(2710,'乐山',27);
INSERT INTO swf_area VALUES(2711,'凉山',27);
INSERT INTO swf_area VALUES(2712,'绵阳',27);
INSERT INTO swf_area VALUES(2713,'眉山',27);
INSERT INTO swf_area VALUES(2714,'内江',27);
INSERT INTO swf_area VALUES(2715,'南充',27);
INSERT INTO swf_area VALUES(2716,'攀枝花',27);
INSERT INTO swf_area VALUES(2717,'遂宁',27);
INSERT INTO swf_area VALUES(2718,'宜宾',27);
INSERT INTO swf_area VALUES(2719,'雅安',27);
INSERT INTO swf_area VALUES(2720,'自贡',27);
INSERT INTO swf_area VALUES(2721,'资阳',27);

INSERT INTO swf_area VALUES(2800,'天津',28);

INSERT INTO swf_area VALUES(2900,'台湾',29);

INSERT INTO swf_area VALUES(3000,'西藏',30);
INSERT INTO swf_area VALUES(3001,3000,'拉萨',30);
INSERT INTO swf_area VALUES(3002,'阿里',30);
INSERT INTO swf_area VALUES(3003,'昌都',30);
INSERT INTO swf_area VALUES(3004,'林芝',30);
INSERT INTO swf_area VALUES(3005,'那曲',30);
INSERT INTO swf_area VALUES(3006,'日喀则',30);
INSERT INTO swf_area VALUES(3007,'山南',30);

INSERT INTO swf_area VALUES(3100,'香港',31);

INSERT INTO swf_area VALUES(3200,'新疆',32);
INSERT INTO swf_area VALUES(3201,3200,'乌鲁木齐',32);
INSERT INTO swf_area VALUES(3202,'阿克苏',32);
INSERT INTO swf_area VALUES(3203,'阿图什',32);
INSERT INTO swf_area VALUES(3204,'阿勒泰',32);
INSERT INTO swf_area VALUES(3205,'阿拉尔',32);
INSERT INTO swf_area VALUES(3206,'博乐',32);
INSERT INTO swf_area VALUES(3207,'昌吉',32);
INSERT INTO swf_area VALUES(3208,'哈密',32);
INSERT INTO swf_area VALUES(3209,'和田',32);
INSERT INTO swf_area VALUES(3210,'克拉玛依',32);
INSERT INTO swf_area VALUES(3211,'喀什',32);
INSERT INTO swf_area VALUES(3212,'库尔勒',32);
INSERT INTO swf_area VALUES(3213,'石河子',32);
INSERT INTO swf_area VALUES(3214,'吐鲁番',32);
INSERT INTO swf_area VALUES(3215,'塔城',32);
INSERT INTO swf_area VALUES(3216,'伊宁',32);

INSERT INTO swf_area VALUES(3300,'云南',33);
INSERT INTO swf_area VALUES(3301,3300,'昆明',33);
INSERT INTO swf_area VALUES(3302,'保山',33);
INSERT INTO swf_area VALUES(3303,'楚雄',33);
INSERT INTO swf_area VALUES(3304,'大理',33);
INSERT INTO swf_area VALUES(3305,'德宏',33);
INSERT INTO swf_area VALUES(3306,'红河',33);
INSERT INTO swf_area VALUES(3307,'景洪',33);
INSERT INTO swf_area VALUES(3308,'丽江',33);
INSERT INTO swf_area VALUES(3309,'临沧',33);
INSERT INTO swf_area VALUES(3310,'怒江',33);
INSERT INTO swf_area VALUES(3311,'曲靖',33);
INSERT INTO swf_area VALUES(3312,'思茅',33);
INSERT INTO swf_area VALUES(3313,'文山',33);
INSERT INTO swf_area VALUES(3314,'香格里拉',33);
INSERT INTO swf_area VALUES(3315,'玉溪',33);
INSERT INTO swf_area VALUES(3316,'昭通',33);

INSERT INTO swf_area VALUES(3400,'浙江',34);
INSERT INTO swf_area VALUES(3401,3400,'杭州',34);
INSERT INTO swf_area VALUES(3402,'湖州',34);
INSERT INTO swf_area VALUES(3403,'嘉兴',34);
INSERT INTO swf_area VALUES(3404,'金华',34);
INSERT INTO swf_area VALUES(3405,'丽水',34);
INSERT INTO swf_area VALUES(3406,'宁波',34);
INSERT INTO swf_area VALUES(3407,'衢州',34);
INSERT INTO swf_area VALUES(3408,'绍兴',34);
INSERT INTO swf_area VALUES(3409,'台州',34);
INSERT INTO swf_area VALUES(3410,'温州',34);
INSERT INTO swf_area VALUES(3411,'舟山',34);

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读