全国省市XML和数据库

记录记录

<?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, 0100, '安庆', 1);
INSERT INTO swf_area VALUES(0103, 0100, '毫州', 1);
INSERT INTO swf_area VALUES(0104, 0100, '蚌埠', 1);
INSERT INTO swf_area VALUES(0105, 0100, '滁州', 1);
INSERT INTO swf_area VALUES(0106, 0100, '巢湖', 1);
INSERT INTO swf_area VALUES(0107, 0100, '池州', 1);
INSERT INTO swf_area VALUES(0108, 0100, '阜阳', 1);
INSERT INTO swf_area VALUES(0109, 0100, '淮北', 1);
INSERT INTO swf_area VALUES(0110, 0100, '淮南', 1);
INSERT INTO swf_area VALUES(0111, 0100, '黄山站', 1);
INSERT INTO swf_area VALUES(0112, 0100, '六安', 1);
INSERT INTO swf_area VALUES(0113, 0100, '马鞍山', 1);
INSERT INTO swf_area VALUES(0114, 0100, '宿州', 1);
INSERT INTO swf_area VALUES(0115, 0100, '铜陵', 1);
INSERT INTO swf_area VALUES(0116, 0100, '芜湖', 1);
INSERT INTO swf_area VALUES(0117, 0100, '宣城', 1);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

下载地址