全国城市-拼音-编号Json数据(只城市)

[
        {
            "city_key":"600280000",
            "city_name":"安吉市",
            "initials":"aj",
            "pinyin":"anji",
            "short_name":"安吉"
        },
        {
            "city_key":"1000090000",
            "city_name":"安康市",
            "initials":"ak",
            "pinyin":"ankang",
            "short_name":"安康"
        },
        {
            "city_key":"1500080000",
            "city_name":"安庆市",
            "initials":"aq",
            "pinyin":"anqing",
            "short_name":"安庆"
        },
        {
            "city_key":"1300030000",
            "city_name":"鞍山市",
            "initials":"as",
            "pinyin":"anshan",
            "short_name":"鞍山"
        },
        {
            "city_key":"2000050000",
            "city_name":"安阳市",
            "initials":"ay",
            "pinyin":"anyang",
            "short_name":"安阳"
        },
        {
            "city_key":"2300080000",
            "city_name":"白城市",
            "initials":"bc",
            "pinyin":"baicheng",
            "short_name":"白城"
        },
        {
            "city_key":"2300060000",
            "city_name":"白山市",
            "initials":"bs",
            "pinyin":"baishan",
            "short_name":"白山"
        },
        {
            "city_key":"3000040000",
            "city_name":"白银市",
            "initials":"by",
            "pinyin":"baiyin",
            "short_name":"白银"
        },
        {
            "city_key":"1800060000",
            "city_name":"保定市",
            "initials":"bd",
            "pinyin":"baoding",
            "short_name":"保定"
        },
        {
            "city_key":"1000030000",
            "city_name":"宝鸡市",
            "initials":"bj",
            "pinyin":"baoji",
            "short_name":"宝鸡"
        },
        {
            "city_key":"2500050000",
            "city_name":"北海市",
            "initials":"bh",
            "pinyin":"beihai",
            "short_name":"北海"
        },
        {
            "city_key":"100010000",
            "city_name":"北京市",
            "initials":"bj",
            "pinyin":"beijing",
            "short_name":"北京"
        },
        {
            "city_key":"1500030000",
            "city_name":"蚌埠市",
            "initials":"bb",
            "pinyin":"bengbu",
            "short_name":"蚌埠"
        },
        {
            "city_key":"1300050000",
            "city_name":"本溪市",
            "initials":"bx",
            "pinyin":"benxi",
            "short_name":"本溪"
        },
        {
            "city_key":"1800090000",
            "city_name":"沧州市",
            "initials":"cz",
            "pinyin":"cangzhou",
            "short_name":"沧州"
        },
        {
            "city_key":"2300010000",
            "city_name":"长春市",
            "initials":"zc",
            "pinyin":"changchun",
            "short_name":"长春"
        },
        {
            "city_key":"1200070000",
            "city_name":"常德市",
            "initials":"cd",
            "pinyin":"changde",
            "short_name":"常德"
        },
        {
            "city_key":"1200010000",
            "city_name":"长沙市",
            "initials":"zs",
            "pinyin":"changsha",
            "short_name":"长沙"
        },
        {
            "city_key":"700150000",
            "city_name":"常熟市",
            "initials":"cs",
            "pinyin":"changshu",
            "short_name":"常熟"
        },
        {
            "city_key":"600240000",
            "city_name":"长兴市",
            "initials":"zx",
            "pinyin":"changxing",
            "short_name":"长兴"
        },
        {
            "city_key":"2100040000",
            "city_name":"长治市",
            "initials":"zz",
            "pinyin":"changzhi",
            "short_name":"长治"
        },
        {
            "city_key":"700040000",
            "city_name":"常州市",
            "initials":"cz",
            "pinyin":"changzhou",
            "short_name":"常州"
        },
        {
            "city_key":"1500130000",
            "city_name":"巢湖市",
            "initials":"ch",
            "pinyin":"chaohu",
            "short_name":"巢湖"
        },
        {
            "city_key":"1300130000",
            "city_name":"朝阳市",
            "initials":"cy",
            "pinyin":"chaoyang",
            "short_name":"朝阳"
        },
        {
            "city_key":"300190000",
            "city_name":"潮州市",
            "initials":"cz",
            "pinyin":"chaozhou",
            "short_name":"潮州"
        },
        {
            "city_key":"1800080000",
            "city_name":"承德市",
            "initials":"cd",
            "pinyin":"chengde",
            "short_name":"承德"
        },
        {
            "city_key":"800010000",
            "city_name":"成都市",
            "initials":"cd",
            "pinyin":"chengdu",
            "short_name":"成都"
        },
        {
            "city_key":"1500160000",
            "city_name":"池州市",
            "initials":"cz",
            "pinyin":"chizhou",
            "short_name":"池州"
        },
        {
            "city_key":"900010000",
            "city_name":"重庆市",
            "initials":"cq",
            "pinyin":"chongqing",
            "short_name":"重庆"
        },
        {
            "city_key":"600340000",
            "city_name":"淳安市",
            "initials":"ca",
            "pinyin":"chunan",
            "short_name":"淳安"
        },
        {
            "city_key":"1500100000",
            "city_name":"滁州市",
            "initials":"cz",
            "pinyin":"chuzhou",
            "short_name":"滁州"
        },
        {
            "city_key":"600120000",
            "city_name":"慈溪市",
            "initials":"cx",
            "pinyin":"cixi",
            "short_name":"慈溪"
        },
        {
            "city_key":"700330000",
            "city_name":"大丰县",
            "initials":"df",
            "pinyin":"dafeng",
            "short_name":"大丰"
        },
        {
            "city_key":"2800130000",
            "city_name":"大理白族自治州",
            "initials":"dlbz",
            "pinyin":"dali",
            "short_name":"大理白族"
        },
        {
            "city_key":"1300010000",
            "city_name":"大连市",
            "initials":"dl",
            "pinyin":"dalian",
            "short_name":"大连"
        },
        {
            "city_key":"1300060000",
            "city_name":"丹东市",
            "initials":"dd",
            "pinyin":"dandong",
            "short_name":"丹东"
        },
        {
            "city_key":"2600050000",
            "city_name":"儋州市",
            "initials":"dz",
            "pinyin":"danzhou",
            "short_name":"儋州"
        },
        {
            "city_key":"1100060000",
            "city_name":"大庆市",
            "initials":"dq",
            "pinyin":"daqing",
            "short_name":"大庆"
        },
        {
            "city_key":"2100020000",
            "city_name":"大同市",
            "initials":"dt",
            "pinyin":"datong",
            "short_name":"大同"
        },
        {
            "city_key":"800150000",
            "city_name":"达州市",
            "initials":"dz",
            "pinyin":"dazhou",
            "short_name":"达州"
        },
        {
            "city_key":"2000190000",
            "city_name":"登封市",
            "initials":"df",
            "pinyin":"dengfeng",
            "short_name":"登封"
        },
        {
            "city_key":"600270000",
            "city_name":"德清市",
            "initials":"dq",
            "pinyin":"deqing",
            "short_name":"德清"
        },
        {
            "city_key":"800050000",
            "city_name":"德阳市",
            "initials":"dy",
            "pinyin":"deyang",
            "short_name":"德阳"
        },
        {
            "city_key":"1400140000",
            "city_name":"德州市",
            "initials":"dz",
            "pinyin":"dezhou",
            "short_name":"德州"
        },
        {
            "city_key":"300170000",
            "city_name":"东莞市",
            "initials":"dg",
            "pinyin":"dongguan",
            "short_name":"东莞"
        },
        {
            "city_key":"600310000",
            "city_name":"东阳市",
            "initials":"dy",
            "pinyin":"dongyang",
            "short_name":"东阳"
        },
        {
            "city_key":"1400050000",
            "city_name":"东营市",
            "initials":"dy",
            "pinyin":"dongying",
            "short_name":"东营"
        },
        {
            "city_key":"2300110000",
            "city_name":"敦化市",
            "initials":"dh",
            "pinyin":"dunhua",
            "short_name":"敦化"
        },
        {
            "city_key":"800220000",
            "city_name":"峨眉山市",
            "initials":"ems",
            "pinyin":"emeishan",
            "short_name":"峨眉山"
        },
        {
            "city_key":"400190000",
            "city_name":"恩施市",
            "initials":"es",
            "pinyin":"enshi",
            "short_name":"恩施"
        },
        {
            "city_key":"300060000",
            "city_name":"佛山市",
            "initials":"fs",
            "pinyin":"foshan",
            "short_name":"佛山"
        },
        {
            "city_key":"1900130000",
            "city_name":"福清市",
            "initials":"fq",
            "pinyin":"fuqing",
            "short_name":"福清"
        },
        {
            "city_key":"1300040000",
            "city_name":"抚顺市",
            "initials":"fs",
            "pinyin":"fushun",
            "short_name":"抚顺"
        },
        {
            "city_key":"1300090000",
            "city_name":"阜新市",
            "initials":"fx",
            "pinyin":"fuxin",
            "short_name":"阜新"
        },
        {
            "city_key":"1500110000",
            "city_name":"阜阳市",
            "initials":"fy",
            "pinyin":"fuyang",
            "short_name":"阜阳"
        },
        {
            "city_key":"600140000",
            "city_name":"富阳市",
            "initials":"fy",
            "pinyin":"fuyang1",
            "short_name":"富阳"
        },
        {
            "city_key":"1900010000",
            "city_name":"福州市",
            "initials":"fz",
            "pinyin":"fuzhou",
            "short_name":"福州"
        },
        {
            "city_key":"2400070000",
            "city_name":"赣州市",
            "initials":"gz",
            "pinyin":"ganzhou",
            "short_name":"赣州"
        },
        {
            "city_key":"2000200000",
            "city_name":"巩义市",
            "initials":"gy",
            "pinyin":"gongyi",
            "short_name":"巩义"
        },
        {
            "city_key":"800070000",
            "city_name":"广元市",
            "initials":"gy",
            "pinyin":"guangyuan",
            "short_name":"广元"
        },
        {
            "city_key":"300110000",
            "city_name":"广州市",
            "initials":"gz",
            "pinyin":"guangzhou",
            "short_name":"广州"
        },
        {
            "city_key":"2500030000",
            "city_name":"桂林市",
            "initials":"gl",
            "pinyin":"guilin",
            "short_name":"桂林"
        },
        {
            "city_key":"2700010000",
            "city_name":"贵阳市",
            "initials":"gy",
            "pinyin":"guiyang",
            "short_name":"贵阳"
        },
        {
            "city_key":"1100010000",
            "city_name":"哈尔滨市",
            "initials":"heb",
            "pinyin":"haerbin",
            "short_name":"哈尔滨"
        },
        {
            "city_key":"700310000",
            "city_name":"海安县",
            "initials":"ha",
            "pinyin":"haian",
            "short_name":"海安"
        },
        {
            "city_key":"2600010000",
            "city_name":"海口市",
            "initials":"hk",
            "pinyin":"haikou",
            "short_name":"海口"
        },
        {
            "city_key":"700170000",
            "city_name":"海门市",
            "initials":"hm",
            "pinyin":"haimen",
            "short_name":"海门"
        },
        {
            "city_key":"600370000",
            "city_name":"海宁市",
            "initials":"hn",
            "pinyin":"haining",
            "short_name":"海宁"
        },
        {
            "city_key":"1400260000",
            "city_name":"海阳市",
            "initials":"hy",
            "pinyin":"haiyang",
            "short_name":"海阳"
        },
        {
            "city_key":"1800040000",
            "city_name":"邯郸市",
            "initials":"hd",
            "pinyin":"handan",
            "short_name":"邯郸"
        },
        {
            "city_key":"600010000",
            "city_name":"杭州市",
            "initials":"hz",
            "pinyin":"hangzhou",
            "short_name":"杭州"
        },
        {
            "city_key":"1000070000",
            "city_name":"汉中市",
            "initials":"hz",
            "pinyin":"hanzhong",
            "short_name":"汉中"
        },
        {
            "city_key":"2000060000",
            "city_name":"鹤壁市",
            "initials":"hb",
            "pinyin":"hebi",
            "short_name":"鹤壁"
        },
        {
            "city_key":"1500010000",
            "city_name":"合肥市",
            "initials":"hf",
            "pinyin":"hefei",
            "short_name":"合肥"
        },
        {
            "city_key":"1100040000",
            "city_name":"鹤岗市",
            "initials":"hg",
            "pinyin":"hegang",
            "short_name":"鹤岗"
        },
        {
            "city_key":"1100110000",
            "city_name":"黑河市",
            "initials":"hh",
            "pinyin":"heihe",
            "short_name":"黑河"
        },
        {
            "city_key":"1800110000",
            "city_name":"衡水市",
            "initials":"hs",
            "pinyin":"hengshui",
            "short_name":"衡水"
        },
        {
            "city_key":"1200040000",
            "city_name":"衡阳市",
            "initials":"hy",
            "pinyin":"hengyang",
            "short_name":"衡阳"
        },
        {
            "city_key":"300140000",
            "city_name":"河源市",
            "initials":"hy",
            "pinyin":"heyuan",
            "short_name":"河源"
        },
        {
            "city_key":"1400170000",
            "city_name":"菏泽市",
            "initials":"hz",
            "pinyin":"heze",
            "short_name":"菏泽"
        },
        {
            "city_key":"2200010000",
            "city_name":"呼和浩特市",
            "initials":"hhht",
            "pinyin":"hohhot",
            "short_name":"呼和浩特"
        },
        {
            "city_key":"2300100000",
            "city_name":"桦甸市",
            "initials":"hd",
            "pinyin":"huadian",
            "short_name":"桦甸"
        },
        {
            "city_key":"700080000",
            "city_name":"淮安市",
            "initials":"ha",
            "pinyin":"huaian",
            "short_name":"淮安"
        },
        {
            "city_key":"1500060000",
            "city_name":"淮北市",
            "initials":"hb",
            "pinyin":"huaibei",
            "short_name":"淮北"
        },
        {
            "city_key":"1200120000",
            "city_name":"怀化市",
            "initials":"hh",
            "pinyin":"huaihua",
            "short_name":"怀化"
        },
        {
            "city_key":"1500040000",
            "city_name":"淮南市",
            "initials":"hn",
            "pinyin":"huainan",
            "short_name":"淮南"
        },
        {
            "city_key":"400160000",
            "city_name":"黄冈市",
            "initials":"hg",
            "pinyin":"huanggang",
            "short_name":"黄冈"
        },
        {
            "city_key":"1500090000",
            "city_name":"黄山市",
            "initials":"hs",
            "pinyin":"huangshan",
            "short_name":"黄山"
        },
        {
            "city_key":"400020000",
            "city_name":"黄石市",
            "initials":"hs",
            "pinyin":"huangshi",
            "short_name":"黄石"
        },
        {
            "city_key":"300010000",
            "city_name":"惠州市",
            "initials":"hz",
            "pinyin":"huizhou",
            "short_name":"惠州"
        },
        {
            "city_key":"1300140000",
            "city_name":"葫芦岛市",
            "initials":"hld",
            "pinyin":"huludao",
            "short_name":"葫芦岛"
        },
        {
            "city_key":"600050000",
            "city_name":"湖州市",
            "initials":"hz",
            "pinyin":"huzhou",
            "short_name":"湖州"
        },
        {
            "city_key":"1100080000",
            "city_name":"佳木斯市",
            "initials":"jms",
            "pinyin":"jiamusi",
            "short_name":"佳木斯"
        },
        {
            "city_key":"600330000",
            "city_name":"建德市",
            "initials":"jd",
            "pinyin":"jiande",
            "short_name":"建德"
        },
        {
            "city_key":"300070000",
            "city_name":"江门市",
            "initials":"jm",
            "pinyin":"jiangmen",
            "short_name":"江门"
        },
        {
            "city_key":"700160000",
            "city_name":"江阴市",
            "initials":"jy",
            "pinyin":"jiangyin",
            "short_name":"江阴"
        },
        {
            "city_key":"2000080000",
            "city_name":"焦作市",
            "initials":"jz",
            "pinyin":"jiaozuo",
            "short_name":"焦作"
        },
        {
            "city_key":"600260000",
            "city_name":"嘉善市",
            "initials":"js",
            "pinyin":"jiashan",
            "short_name":"嘉善"
        },
        {
            "city_key":"600040000",
            "city_name":"嘉兴市",
            "initials":"jx",
            "pinyin":"jiaxing",
            "short_name":"嘉兴"
        },
        {
            "city_key":"1500190000",
            "city_name":"界首市",
            "initials":"js",
            "pinyin":"jieshou",
            "short_name":"界首"
        },
        {
            "city_key":"300200000",
            "city_name":"揭阳市",
            "initials":"jy",
            "pinyin":"jieyang",
            "short_name":"揭阳"
        },
        {
            "city_key":"2300020000",
            "city_name":"吉林市",
            "initials":"jl",
            "pinyin":"jilin",
            "short_name":"吉林"
        },
        {
            "city_key":"1400020000",
            "city_name":"济南市",
            "initials":"jn",
            "pinyin":"jinan",
            "short_name":"济南"
        },
        {
            "city_key":"2100050000",
            "city_name":"晋城市",
            "initials":"jc",
            "pinyin":"jincheng",
            "short_name":"晋城"
        },
        {
            "city_key":"2400020000",
            "city_name":"景德镇市",
            "initials":"jdz",
            "pinyin":"jindezhen",
            "short_name":"景德镇"
        },
        {
            "city_key":"700250000",
            "city_name":"靖江市",
            "initials":"jj",
            "pinyin":"jingjiang",
            "short_name":"靖江"
        },
        {
            "city_key":"400150000",
            "city_name":"荆州市",
            "initials":"jz",
            "pinyin":"jingzhou",
            "short_name":"荆州"
        },
        {
            "city_key":"600070000",
            "city_name":"金华市",
            "initials":"jh",
            "pinyin":"jinhua",
            "short_name":"金华"
        },
        {
            "city_key":"1400080000",
            "city_name":"济宁市",
            "initials":"jn",
            "pinyin":"jining",
            "short_name":"济宁"
        },
        {
            "city_key":"1900100000",
            "city_name":"晋江市",
            "initials":"jj",
            "pinyin":"jinjiang",
            "short_name":"晋江"
        },
        {
            "city_key":"700260000",
            "city_name":"金坛市",
            "initials":"jt",
            "pinyin":"jintan",
            "short_name":"金坛"
        },
        {
            "city_key":"2100070000",
            "city_name":"晋中市",
            "initials":"jz",
            "pinyin":"jinzhong",
            "short_name":"晋中"
        },
        {
            "city_key":"1300070000",
            "city_name":"锦州市",
            "initials":"jz",
            "pinyin":"jinzhou",
            "short_name":"锦州"
        },
        {
            "city_key":"2400040000",
            "city_name":"九江市",
            "initials":"jj",
            "pinyin":"jiujiang",
            "short_name":"九江"
        },
        {
            "city_key":"1100030000",
            "city_name":"鸡西市",
            "initials":"jx",
            "pinyin":"jixi",
            "short_name":"鸡西"
        },
        {
            "city_key":"2000180000",
            "city_name":"济源市",
            "initials":"jy",
            "pinyin":"jiyuan",
            "short_name":"济源"
        },
        {
            "city_key":"6200006209",
            "city_name":"酒泉市",
            "initials":"jq",
            "pinyin":"jiuquan",
            "short_name":"酒泉"
        },
        {
            "city_key":"2000020000",
            "city_name":"开封市",
            "initials":"kf",
            "pinyin":"kaifeng",
            "short_name":"开封"
        },
        {
            "city_key":"2800010000",
            "city_name":"昆明市",
            "initials":"km",
            "pinyin":"kunming",
            "short_name":"昆明"
        },
        {
            "city_key":"700220000",
            "city_name":"昆山市",
            "initials":"ks",
            "pinyin":"kunshan",
            "short_name":"昆山"
        },
        {
            "city_key":"1400120000",
            "city_name":"莱芜市",
            "initials":"lw",
            "pinyin":"laiwu",
            "short_name":"莱芜"
        },
        {
            "city_key":"1800100000",
            "city_name":"廊坊市",
            "initials":"lf",
            "pinyin":"langfang",
            "short_name":"廊坊"
        },
        {
            "city_key":"600300000",
            "city_name":"兰溪市",
            "initials":"lx",
            "pinyin":"lanxi",
            "short_name":"兰溪"
        },
        {
            "city_key":"3000010000",
            "city_name":"兰州市",
            "initials":"lz",
            "pinyin":"lanzhou",
            "short_name":"兰州"
        },
        {
            "city_key":"600180000",
            "city_name":"乐清市",
            "initials":"lq",
            "pinyin":"leqing",
            "short_name":"乐清"
        },
        {
            "city_key":"800100000",
            "city_name":"乐山市",
            "initials":"ls",
            "pinyin":"leshan",
            "short_name":"乐山"
        },
        {
            "city_key":"700070000",
            "city_name":"连云港市",
            "initials":"lyg",
            "pinyin":"lianyungang",
            "short_name":"连云港"
        },
        {
            "city_key":"1400150000",
            "city_name":"聊城市",
            "initials":"lc",
            "pinyin":"liaocheng",
            "short_name":"聊城"
        },
        {
            "city_key":"1300100000",
            "city_name":"辽阳市",
            "initials":"ly",
            "pinyin":"liaoyang",
            "short_name":"辽阳"
        },
        {
            "city_key":"2300040000",
            "city_name":"辽源市",
            "initials":"ly",
            "pinyin":"liaoyuan",
            "short_name":"辽源"
        },
        {
            "city_key":"2800060000",
            "city_name":"丽江市",
            "initials":"lj",
            "pinyin":"lijiang",
            "short_name":"丽江"
        },
        {
            "city_key":"600360000",
            "city_name":"临安市",
            "initials":"la",
            "pinyin":"linan",
            "short_name":"临安"
        },
        {
            "city_key":"2100100000",
            "city_name":"临汾市",
            "initials":"lf",
            "pinyin":"linfen",
            "short_name":"临汾"
        },
        {
            "city_key":"600220000",
            "city_name":"临海市",
            "initials":"lh",
            "pinyin":"linhai",
            "short_name":"临海"
        },
        {
            "city_key":"1000120000",
            "city_name":"临潼市",
            "initials":"lt",
            "pinyin":"lintong",
            "short_name":"临潼"
        },
        {
            "city_key":"1400130000",
            "city_name":"临沂市",
            "initials":"ly",
            "pinyin":"linyi",
            "short_name":"临沂"
        },
        {
            "city_key":"600020000",
            "city_name":"丽水市",
            "initials":"ls",
            "pinyin":"lishui",
            "short_name":"丽水"
        },
        {
            "city_key":"1500140000",
            "city_name":"六安市",
            "initials":"la",
            "pinyin":"liuan",
            "short_name":"六安"
        },
        {
            "city_key":"2500020000",
            "city_name":"柳州市",
            "initials":"lz",
            "pinyin":"liuzhou",
            "short_name":"柳州"
        },
        {
            "city_key":"700230000",
            "city_name":"溧阳市",
            "initials":"ly",
            "pinyin":"liyang",
            "short_name":"溧阳"
        },
        {
            "city_key":"1400190000",
            "city_name":"龙口市",
            "initials":"lk",
            "pinyin":"longkou",
            "short_name":"龙口"
        },
        {
            "city_key":"1900080000",
            "city_name":"龙岩市",
            "initials":"ly",
            "pinyin":"longyan",
            "short_name":"龙岩"
        },
        {
            "city_key":"2000110000",
            "city_name":"漯河市",
            "initials":"lh",
            "pinyin":"luohe",
            "short_name":"漯河"
        },
        {
            "city_key":"2000030000",
            "city_name":"洛阳市",
            "initials":"ly",
            "pinyin":"luoyang",
            "short_name":"洛阳"
        },
        {
            "city_key":"800040000",
            "city_name":"泸州市",
            "initials":"lz",
            "pinyin":"luzhou",
            "short_name":"泸州"
        },
        {
            "city_key":"2100110000",
            "city_name":"吕梁市",
            "initials":"ll",
            "pinyin":"lvliang",
            "short_name":"吕梁"
        },
        {
            "city_key":"1500050000",
            "city_name":"马鞍山市",
            "initials":"mas",
            "pinyin":"maanshan",
            "short_name":"马鞍山"
        },
        {
            "city_key":"300090000",
            "city_name":"茂名市",
            "initials":"mm",
            "pinyin":"maoming",
            "short_name":"茂名"
        },
        {
            "city_key":"300120000",
            "city_name":"梅州市",
            "initials":"mz",
            "pinyin":"meizhou",
            "short_name":"梅州"
        },
        {
            "city_key":"800060000",
            "city_name":"绵阳市",
            "initials":"my",
            "pinyin":"mianyang",
            "short_name":"绵阳"
        },
        {
            "city_key":"1500210000",
            "city_name":"明光市",
            "initials":"mg",
            "pinyin":"mingguang",
            "short_name":"明光"
        },
        {
            "city_key":"1100100000",
            "city_name":"牡丹江市",
            "initials":"mdj",
            "pinyin":"mudanjiang",
            "short_name":"牡丹江"
        },
        {
            "city_key":"2400010000",
            "city_name":"南昌市",
            "initials":"nc",
            "pinyin":"nanchang",
            "short_name":"南昌"
        },
        {
            "city_key":"800110000",
            "city_name":"南充市",
            "initials":"nc",
            "pinyin":"nanchong",
            "short_name":"南充"
        },
        {
            "city_key":"700010000",
            "city_name":"南京市",
            "initials":"nj",
            "pinyin":"nanjing",
            "short_name":"南京"
        },
        {
            "city_key":"2500010000",
            "city_name":"南宁市",
            "initials":"nn",
            "pinyin":"nanning",
            "short_name":"南宁"
        },
        {
            "city_key":"1900070000",
            "city_name":"南平市",
            "initials":"np",
            "pinyin":"nanping",
            "short_name":"南平"
        },
        {
            "city_key":"700060000",
            "city_name":"南通市",
            "initials":"nt",
            "pinyin":"nantong",
            "short_name":"南通"
        },
        {
            "city_key":"2000130000",
            "city_name":"南阳市",
            "initials":"ny",
            "pinyin":"nanyang",
            "short_name":"南阳"
        },
        {
            "city_key":"600110000",
            "city_name":"宁波市",
            "initials":"nb",
            "pinyin":"ningbo",
            "short_name":"宁波"
        },
        {
            "city_key":"1900090000",
            "city_name":"宁德市",
            "initials":"nd",
            "pinyin":"ningde",
            "short_name":"宁德"
        },
        {
            "city_key":"1500220000",
            "city_name":"宁国市",
            "initials":"ng",
            "pinyin":"ningguo",
            "short_name":"宁国"
        },
        {
            "city_key":"1300110000",
            "city_name":"盘锦市",
            "initials":"pj",
            "pinyin":"panjin",
            "short_name":"盘锦"
        },
        {
            "city_key":"1400250000",
            "city_name":"蓬莱市",
            "initials":"pl",
            "pinyin":"penglai",
            "short_name":"蓬莱"
        },
        {
            "city_key":"2000040000",
            "city_name":"平顶山市",
            "initials":"pds",
            "pinyin":"pingdingshan",
            "short_name":"平顶山"
        },
        {
            "city_key":"600380000",
            "city_name":"平湖市",
            "initials":"ph",
            "pinyin":"pinghu",
            "short_name":"平湖"
        },
        {
            "city_key":"2400030000",
            "city_name":"萍乡市",
            "initials":"px",
            "pinyin":"pingxiang",
            "short_name":"萍乡"
        },
        {
            "city_key":"1900030000",
            "city_name":"莆田市",
            "initials":"pt",
            "pinyin":"putian",
            "short_name":"莆田"
        },
        {
            "city_key":"2000090000",
            "city_name":"濮阳市",
            "initials":"py",
            "pinyin":"puyang",
            "short_name":"濮阳"
        },
        {
            "city_key":"700320000",
            "city_name":"启东县",
            "initials":"qd",
            "pinyin":"qidong",
            "short_name":"启东"
        },
        {
            "city_key":"1400010000",
            "city_name":"青岛市",
            "initials":"qd",
            "pinyin":"qingdao",
            "short_name":"青岛"
        },
        {
            "city_key":"300160000",
            "city_name":"清远市",
            "initials":"qy",
            "pinyin":"qingyuan",
            "short_name":"清远"
        },
        {
            "city_key":"1400220000",
            "city_name":"青州市",
            "initials":"qz",
            "pinyin":"qingzhou",
            "short_name":"青州"
        },
        {
            "city_key":"1800030000",
            "city_name":"秦皇岛市",
            "initials":"qhd",
            "pinyin":"qinhuangdao",
            "short_name":"秦皇岛"
        },
        {
            "city_key":"2600040000",
            "city_name":"琼海市",
            "initials":"qh",
            "pinyin":"qionghai",
            "short_name":"琼海"
        },
        {
            "city_key":"1100020000",
            "city_name":"齐齐哈尔市",
            "initials":"qqhe",
            "pinyin":"qiqihar",
            "short_name":"齐齐哈尔"
        },
        {
            "city_key":"2100090000",
            "city_name":"忻州市",
            "initials":"xz",
            "pinyin":"qizhou",
            "short_name":"忻州"
        },
        {
            "city_key":"1900050000",
            "city_name":"泉州市",
            "initials":"qz",
            "pinyin":"quanzhou",
            "short_name":"泉州"
        },
        {
            "city_key":"2800020000",
            "city_name":"曲靖市",
            "initials":"qj",
            "pinyin":"qujing",
            "short_name":"曲靖"
        },
        {
            "city_key":"600080000",
            "city_name":"衢州市",
            "initials":"qz",
            "pinyin":"quzhou",
            "short_name":"衢州"
        },
        {
            "city_key":"1400110000",
            "city_name":"日照市",
            "initials":"rz",
            "pinyin":"rizhao",
            "short_name":"日照"
        },
        {
            "city_key":"700300000",
            "city_name":"如皋县",
            "initials":"rg",
            "pinyin":"rugao",
            "short_name":"如皋"
        },
        {
            "city_key":"600170000",
            "city_name":"瑞安市",
            "initials":"ra",
            "pinyin":"ruian",
            "short_name":"瑞安"
        },
        {
            "city_key":"2000120000",
            "city_name":"三门峡市",
            "initials":"smx",
            "pinyin":"sanmenxia",
            "short_name":"三门峡"
        },
        {
            "city_key":"1900040000",
            "city_name":"三明市",
            "initials":"sm",
            "pinyin":"sanming",
            "short_name":"三明"
        },
        {
            "city_key":"2600020000",
            "city_name":"三亚市",
            "initials":"sy",
            "pinyin":"sanya",
            "short_name":"三亚"
        },
        {
            "city_key":"200010000",
            "city_name":"上海市",
            "initials":"sh",
            "pinyin":"shanghai",
            "short_name":"上海"
        },
        {
            "city_key":"1000100000",
            "city_name":"商洛市",
            "initials":"sl",
            "pinyin":"shangluo",
            "short_name":"商洛"
        },
        {
            "city_key":"2000140000",
            "city_name":"商丘市",
            "initials":"sq",
            "pinyin":"shangqiu",
            "short_name":"商丘"
        },
        {
            "city_key":"2400110000",
            "city_name":"上饶市",
            "initials":"sr",
            "pinyin":"shangrao",
            "short_name":"上饶"
        },
        {
            "city_key":"600200000",
            "city_name":"上虞市",
            "initials":"sy",
            "pinyin":"shangyu",
            "short_name":"上虞"
        },
        {
            "city_key":"300050000",
            "city_name":"汕头市",
            "initials":"st",
            "pinyin":"shantou",
            "short_name":"汕头"
        },
        {
            "city_key":"300130000",
            "city_name":"汕尾市",
            "initials":"sw",
            "pinyin":"shanwei",
            "short_name":"汕尾"
        },
        {
            "city_key":"300020000",
            "city_name":"韶关市",
            "initials":"sg",
            "pinyin":"shaoguan",
            "short_name":"韶关"
        },
        {
            "city_key":"600060000",
            "city_name":"绍兴市",
            "initials":"sx",
            "pinyin":"shaoxing",
            "short_name":"绍兴"
        },
        {
            "city_key":"1300020000",
            "city_name":"沈阳市",
            "initials":"sy",
            "pinyin":"shenyang",
            "short_name":"沈阳"
        },
        {
            "city_key":"300210000",
            "city_name":"深圳市",
            "initials":"sz",
            "pinyin":"shenzhen",
            "short_name":"深圳"
        },
        {
            "city_key":"1800010000",
            "city_name":"石家庄市",
            "initials":"sjz",
            "pinyin":"shijiazhuang",
            "short_name":"石家庄"
        },
        {
            "city_key":"1900110000",
            "city_name":"石狮市",
            "initials":"ss",
            "pinyin":"shishi",
            "short_name":"石狮"
        },
        {
            "city_key":"400030000",
            "city_name":"十堰市",
            "initials":"sy",
            "pinyin":"shiyan",
            "short_name":"十堰"
        },
        {
            "city_key":"1400230000",
            "city_name":"寿光市",
            "initials":"sg",
            "pinyin":"shouguang",
            "short_name":"寿光"
        },
        {
            "city_key":"1100050000",
            "city_name":"双鸭山市",
            "initials":"sys",
            "pinyin":"shuangyashan",
            "short_name":"双鸭山"
        },
        {
            "city_key":"300220000",
            "city_name":"顺德区",
            "initials":"sd",
            "pinyin":"shunde",
            "short_name":"顺德"
        },
        {
            "city_key":"2100060000",
            "city_name":"朔州市",
            "initials":"sz",
            "pinyin":"shuozhou",
            "short_name":"朔州"
        },
        {
            "city_key":"2300030000",
            "city_name":"四平市",
            "initials":"sp",
            "pinyin":"siping",
            "short_name":"四平"
        },
        {
            "city_key":"2300070000",
            "city_name":"松原市",
            "initials":"sy",
            "pinyin":"songyuan",
            "short_name":"松原"
        },
        {
            "city_key":"1100120000",
            "city_name":"绥化市",
            "initials":"sh",
            "pinyin":"suihua",
            "short_name":"绥化"
        },
        {
            "city_key":"700130000",
            "city_name":"宿迁市",
            "initials":"sq",
            "pinyin":"suqian",
            "short_name":"宿迁"
        },
        {
            "city_key":"700110000",
            "city_name":"苏州市",
            "initials":"sz",
            "pinyin":"suzhou",
            "short_name":"苏州"
        },
        {
            "city_key":"1400090000",
            "city_name":"泰安市",
            "initials":"ta",
            "pinyin":"taian",
            "short_name":"泰安"
        },
        {
            "city_key":"700290000",
            "city_name":"太仓市",
            "initials":"tc",
            "pinyin":"taicang",
            "short_name":"太仓"
        },
        {
            "city_key":"2100010000",
            "city_name":"太原市",
            "initials":"ty",
            "pinyin":"taiyuan",
            "short_name":"太原"
        },
        {
            "city_key":"600100000",
            "city_name":"台州市",
            "initials":"tz",
            "pinyin":"taizhou",
            "short_name":"台州"
        },
        {
            "city_key":"700120000",
            "city_name":"泰州市",
            "initials":"tz",
            "pinyin":"taizhoux",
            "short_name":"泰州"
        },
        {
            "city_key":"1800020000",
            "city_name":"唐山市",
            "initials":"ts",
            "pinyin":"tangshan",
            "short_name":"唐山"
        },
        {
            "city_key":"1500200000",
            "city_name":"天长市",
            "initials":"tz",
            "pinyin":"tianchang",
            "short_name":"天长"
        },
        {
            "city_key":"500010000",
            "city_name":"天津市",
            "initials":"tj",
            "pinyin":"tianjin",
            "short_name":"天津"
        },
        {
            "city_key":"3000050000",
            "city_name":"天水市",
            "initials":"ts",
            "pinyin":"tianshui",
            "short_name":"天水"
        },
        {
            "city_key":"1300120000",
            "city_name":"铁岭市",
            "initials":"tl",
            "pinyin":"tieling",
            "short_name":"铁岭"
        },
        {
            "city_key":"1500180000",
            "city_name":"桐城市",
            "initials":"tc",
            "pinyin":"tongcheng",
            "short_name":"桐城"
        },
        {
            "city_key":"2300050000",
            "city_name":"通化市",
            "initials":"th",
            "pinyin":"tonghua",
            "short_name":"通化"
        },
        {
            "city_key":"1500070000",
            "city_name":"铜陵市",
            "initials":"tl",
            "pinyin":"tongling",
            "short_name":"铜陵"
        },
        {
            "city_key":"600320000",
            "city_name":"桐庐县",
            "initials":"tl",
            "pinyin":"tonglu",
            "short_name":"桐庐"
        },
        {
            "city_key":"600250000",
            "city_name":"桐乡市",
            "initials":"tx",
            "pinyin":"tongxiang",
            "short_name":"桐乡"
        },
        {
            "city_key":"1400070000",
            "city_name":"潍坊市",
            "initials":"wf",
            "pinyin":"weifang",
            "short_name":"潍坊"
        },
        {
            "city_key":"1400100000",
            "city_name":"威海市",
            "initials":"wh",
            "pinyin":"weihai",
            "short_name":"威海"
        },
        {
            "city_key":"1000050000",
            "city_name":"渭南市",
            "initials":"wn",
            "pinyin":"weinan",
            "short_name":"渭南"
        },
        {
            "city_key":"600230000",
            "city_name":"温岭市",
            "initials":"wl",
            "pinyin":"wenling",
            "short_name":"温岭"
        },
        {
            "city_key":"600030000",
            "city_name":"温州市",
            "initials":"wz",
            "pinyin":"wenzhou",
            "short_name":"温州"
        },
        {
            "city_key":"400010000",
            "city_name":"武汉市",
            "initials":"wh",
            "pinyin":"wuhan",
            "short_name":"武汉"
        },
        {
            "city_key":"1500020000",
            "city_name":"芜湖市",
            "initials":"wh",
            "pinyin":"wuhu",
            "short_name":"芜湖"
        },
        {
            "city_key":"3300010000",
            "city_name":"乌鲁木齐市",
            "initials":"wlmq",
            "pinyin":"wulumuqi",
            "short_name":"乌鲁木齐"
        },
        {
            "city_key":"700210000",
            "city_name":"无锡市",
            "initials":"wx",
            "pinyin":"wuxi",
            "short_name":"无锡"
        },
        {
            "city_key":"1900120000",
            "city_name":"武夷山",
            "initials":"wys",
            "pinyin":"wuyishan",
            "short_name":"武夷山"
        },
        {
            "city_key":"1900020000",
            "city_name":"厦门市",
            "initials":"sm",
            "pinyin":"xiamen",
            "short_name":"厦门"
        },
        {
            "city_key":"1000010000",
            "city_name":"西安市",
            "initials":"xa",
            "pinyin":"xian",
            "short_name":"西安"
        },
        {
            "city_key":"1200030000",
            "city_name":"湘潭市",
            "initials":"xt",
            "pinyin":"xiangtan",
            "short_name":"湘潭"
        },
        {
            "city_key":"400130000",
            "city_name":"襄阳市",
            "initials":"xy",
            "pinyin":"xiangyang",
            "short_name":"襄阳"
        },
        {
            "city_key":"400140000",
            "city_name":"咸宁市",
            "initials":"xn",
            "pinyin":"xianning",
            "short_name":"咸宁"
        },
        {
            "city_key":"1000040000",
            "city_name":"咸阳市",
            "initials":"xy",
            "pinyin":"xianyang",
            "short_name":"咸阳"
        },
        {
            "city_key":"400080000",
            "city_name":"孝感市",
            "initials":"xg",
            "pinyin":"xiaogan",
            "short_name":"孝感"
        },
        {
            "city_key":"600390000",
            "city_name":"萧山市",
            "initials":"xs",
            "pinyin":"xiaoshan",
            "short_name":"萧山"
        },
        {
            "city_key":"1800050000",
            "city_name":"邢台市",
            "initials":"xt",
            "pinyin":"xingtai",
            "short_name":"邢台"
        },
        {
            "city_key":"2000230000",
            "city_name":"荥阳市",
            "initials":"xy",
            "pinyin":"xingyang",
            "short_name":"荥阳"
        },
        {
            "city_key":"2000220000",
            "city_name":"新密市",
            "initials":"xm",
            "pinyin":"xinmi",
            "short_name":"新密"
        },
        {
            "city_key":"2000070000",
            "city_name":"新乡市",
            "initials":"xx",
            "pinyin":"xinxiang",
            "short_name":"新乡"
        },
        {
            "city_key":"2000150000",
            "city_name":"信阳市",
            "initials":"xy",
            "pinyin":"xinyang",
            "short_name":"信阳"
        },
        {
            "city_key":"2000210000",
            "city_name":"新郑市",
            "initials":"xz",
            "pinyin":"xinzheng",
            "short_name":"新郑"
        },
        {
            "city_key":"2800120000",
            "city_name":"西双版纳傣族自治州",
            "initials":"xsbndz",
            "pinyin":"xishuangbanna",
            "short_name":"西双版纳傣族"
        },
        {
            "city_key":"1500170000",
            "city_name":"宣城市",
            "initials":"xc",
            "pinyin":"xuancheng",
            "short_name":"宣城"
        },
        {
            "city_key":"2000100000",
            "city_name":"许昌市",
            "initials":"xc",
            "pinyin":"xuchang",
            "short_name":"许昌"
        },
        {
            "city_key":"700030000",
            "city_name":"徐州市",
            "initials":"xz",
            "pinyin":"xuzhou",
            "short_name":"徐州"
        },
        {
            "city_key":"9003300000",
            "city_name":"西宁市",
            "initials":"xn",
            "pinyin":"xining",
            "short_name":"西宁"
        },
        {
            "city_key":"1000060000",
            "city_name":"延安市",
            "initials":"ya",
            "pinyin":"yanan",
            "short_name":"延安"
        },
        {
            "city_key":"2300090000",
            "city_name":"延边朝鲜族自治州",
            "initials":"ybcxz",
            "pinyin":"yanbian",
            "short_name":"延边朝鲜族"
        },
        {
            "city_key":"700090000",
            "city_name":"盐城市",
            "initials":"yc",
            "pinyin":"yancheng",
            "short_name":"盐城"
        },
        {
            "city_key":"300150000",
            "city_name":"阳江市",
            "initials":"yj",
            "pinyin":"yangjiang",
            "short_name":"阳江"
        },
        {
            "city_key":"2100030000",
            "city_name":"阳泉市",
            "initials":"yq",
            "pinyin":"yangquan",
            "short_name":"阳泉"
        },
        {
            "city_key":"2500160000",
            "city_name":"阳朔市",
            "initials":"ys",
            "pinyin":"yangshuo",
            "short_name":"阳朔"
        },
        {
            "city_key":"700100000",
            "city_name":"扬州市",
            "initials":"yz",
            "pinyin":"yangzhou",
            "short_name":"扬州"
        },
        {
            "city_key":"2300020001",
            "city_name":"延吉市",
            "initials":"yj",
            "pinyin":"yanji",
            "short_name":"延吉"
        },
        {
            "city_key":"1000110000",
            "city_name":"阎良市",
            "initials":"yl",
            "pinyin":"yanliang",
            "short_name":"阎良"
        },
        {
            "city_key":"1400060000",
            "city_name":"烟台市",
            "initials":"yt",
            "pinyin":"yantai",
            "short_name":"烟台"
        },
        {
            "city_key":"1400200000",
            "city_name":"兖州市",
            "initials":"yz",
            "pinyin":"yanzhou",
            "short_name":"兖州"
        },
        {
            "city_key":"800130000",
            "city_name":"宜宾市",
            "initials":"yb",
            "pinyin":"yibin",
            "short_name":"宜宾"
        },
        {
            "city_key":"400040000",
            "city_name":"宜昌市",
            "initials":"yc",
            "pinyin":"yichang",
            "short_name":"宜昌"
        },
        {
            "city_key":"1100070000",
            "city_name":"伊春市",
            "initials":"yc",
            "pinyin":"yichun",
            "short_name":"伊春"
        },
        {
            "city_key":"3200010000",
            "city_name":"银川市",
            "initials":"yc",
            "pinyin":"yinchuan",
            "short_name":"银川"
        },
        {
            "city_key":"1300080000",
            "city_name":"营口市",
            "initials":"yk",
            "pinyin":"yingkou",
            "short_name":"营口"
        },
        {
            "city_key":"600130000",
            "city_name":"义乌市",
            "initials":"yw",
            "pinyin":"yiwu",
            "short_name":"义乌"
        },
        {
            "city_key":"700270000",
            "city_name":"宜兴市",
            "initials":"yx",
            "pinyin":"yixing",
            "short_name":"宜兴"
        },
        {
            "city_key":"700240000",
            "city_name":"仪征市",
            "initials":"yz",
            "pinyin":"yizheng",
            "short_name":"仪征"
        },
        {
            "city_key":"600290000",
            "city_name":"永康市",
            "initials":"yk",
            "pinyin":"yongkang",
            "short_name":"永康"
        },
        {
            "city_key":"1200060000",
            "city_name":"岳阳市",
            "initials":"yy",
            "pinyin":"yueyang",
            "short_name":"岳阳"
        },
        {
            "city_key":"600350000",
            "city_name":"余杭市",
            "initials":"yh",
            "pinyin":"yuhang",
            "short_name":"余杭"
        },
        {
            "city_key":"1000080000",
            "city_name":"榆林市",
            "initials":"yl",
            "pinyin":"yulin",
            "short_name":"榆林"
        },
        {
            "city_key":"2500090000",
            "city_name":"玉林市",
            "initials":"yl",
            "pinyin":"yulin1",
            "short_name":"玉林"
        },
        {
            "city_key":"2100080000",
            "city_name":"运城市",
            "initials":"yc",
            "pinyin":"yuncheng",
            "short_name":"运城"
        },
        {
            "city_key":"300030000",
            "city_name":"云浮市",
            "initials":"yf",
            "pinyin":"yunfu",
            "short_name":"云浮"
        },
        {
            "city_key":"2800030000",
            "city_name":"玉溪市",
            "initials":"yx",
            "pinyin":"yuxi",
            "short_name":"玉溪"
        },
        {
            "city_key":"600190000",
            "city_name":"余姚市",
            "initials":"yy",
            "pinyin":"yuyao",
            "short_name":"余姚"
        },
        {
            "city_key":"700280000",
            "city_name":"张家港市",
            "initials":"zjg",
            "pinyin":"zhangjiagang",
            "short_name":"张家港"
        },
        {
            "city_key":"1800070000",
            "city_name":"张家口市",
            "initials":"zjk",
            "pinyin":"zhangjiakou",
            "short_name":"张家口"
        },
        {
            "city_key":"1400240000",
            "city_name":"章丘市",
            "initials":"zq",
            "pinyin":"zhangqiu",
            "short_name":"章丘"
        },
        {
            "city_key":"1900060000",
            "city_name":"漳州市",
            "initials":"zz",
            "pinyin":"zhangzhou",
            "short_name":"漳州"
        },
        {
            "city_key":"300080000",
            "city_name":"湛江市",
            "initials":"zj",
            "pinyin":"zhanjiang",
            "short_name":"湛江"
        },
        {
            "city_key":"300100000",
            "city_name":"肇庆市",
            "initials":"zq",
            "pinyin":"zhaoqing",
            "short_name":"肇庆"
        },
        {
            "city_key":"1400270000",
            "city_name":"招远市",
            "initials":"zy",
            "pinyin":"zhaoyuan",
            "short_name":"招远"
        },
        {
            "city_key":"2000010000",
            "city_name":"郑州市",
            "initials":"zz",
            "pinyin":"zhengzhou",
            "short_name":"郑州"
        },
        {
            "city_key":"700050000",
            "city_name":"镇江市",
            "initials":"zj",
            "pinyin":"zhenjiang",
            "short_name":"镇江"
        },
        {
            "city_key":"300180000",
            "city_name":"中山市",
            "initials":"zs",
            "pinyin":"zhongshan",
            "short_name":"中山"
        },
        {
            "city_key":"2000160000",
            "city_name":"周口市",
            "initials":"zk",
            "pinyin":"zhoukou",
            "short_name":"周口"
        },
        {
            "city_key":"600090000",
            "city_name":"舟山市",
            "initials":"zs",
            "pinyin":"zhoushan",
            "short_name":"舟山"
        },
        {
            "city_key":"300040000",
            "city_name":"珠海市",
            "initials":"zh",
            "pinyin":"zhuhai",
            "short_name":"珠海"
        },
        {
            "city_key":"600210000",
            "city_name":"诸暨市",
            "initials":"zj",
            "pinyin":"zhuji",
            "short_name":"诸暨"
        },
        {
            "city_key":"2000170000",
            "city_name":"驻马店市",
            "initials":"zmd",
            "pinyin":"zhumadian",
            "short_name":"驻马店"
        },
        {
            "city_key":"1200020000",
            "city_name":"株洲市",
            "initials":"zz",
            "pinyin":"zhuzhou",
            "short_name":"株洲"
        },
        {
            "city_key":"1400030000",
            "city_name":"淄博市",
            "initials":"zb",
            "pinyin":"zibo",
            "short_name":"淄博"
        },
        {
            "city_key":"800020000",
            "city_name":"自贡市",
            "initials":"zg",
            "pinyin":"zigong",
            "short_name":"自贡"
        },
        {
            "city_key":"2700030000",
            "city_name":"遵义市",
            "initials":"zy",
            "pinyin":"zunyi",
            "short_name":"遵义"
        }
    ]

 

行政区划数据库 (34个省份 396个城市 3700个区县) 区划ID-父亲ID-全称-简称-级别-邮编-区号-拼音-简拼-经纬度-省市区聚合 温馨提示 经纬度是省市区对应的中心经纬度,即国测局坐标 (GCJ02坐标:google地图、soso地图、aliyun地图、mapabc地图和amap地图所用坐标) 不是 WGS84 (gps)国际坐标; --mysql 导入数据库 --创建表 最新行政区划数据库 --字段 区划ID-父ID-全称-全称聚合-简称-简称聚合-级别-区号-邮编-拼音-简拼-首字母-经度-纬度-备注 CREATE TABLE `areas``.`areas` ( `ID` VARCHAR(45) NULL, `ParentId` VARCHAR(45) NULL, `Name` VARCHAR(45) NULL, `MergerName` VARCHAR(200) NULL, `ShortName` VARCHAR(45) NULL, `MergerShortName` VARCHAR(200) NULL, `LevelType` VARCHAR(45) NULL, `CityCode` VARCHAR(45) NULL, `ZipCode` VARCHAR(45) NULL, `Pinyin` VARCHAR(45) NULL, `Jianpin` VARCHAR(45) NULL, `FirstChar` VARCHAR(45) NULL, `lng` VARCHAR(45) NULL, `Lat` VARCHAR(45) NULL, `Remark` VARCHAR(45) NULL ); --导入数据库 LOAD DATA LOCAL INFILE 'G:\areas.txt' INTO TABLE areas FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' (ID,ParentId,Name,MergerName,ShortName,MergerShortName,LevelType,CityCode,ZipCode,Pinyin,Jianpin,FirstChar,lng,Lat,Remark); --xls 全选复制到txt --默认 txt为中文编码 导入时 请转为utf-8编码 以免乱码 --附 MSSQL导入方法: --创建 最新行政区划数据库 旗舰版 --字段 区划ID-父ID-全称-全称聚合-简称-简称聚合-级别-区号-邮编-拼音-简拼-首字母-经度-纬度-备注 CREATE TABLE [dbo].[areas]( [ID] [NVARCHAR](50) NULL, [ParentId] [NVARCHAR](50) NULL, [Name] [NVARCHAR](50) NULL, [MergerName] [NVARCHAR](200) NULL, [ShortName] [NVARCHAR](50) NULL, [MergerShortName] [NVARCHAR](200) NULL, [LevelType] [NVARCHAR](50) NULL, [CityCode] [NVARCHAR](50) NULL, [ZipCode] [NVARCHAR](50) NULL, [Pinyin] [NVARCHAR](50) NULL, [Jianpin] [NVARCHAR](50) NULL, [FirstChar] [NVARCHAR](50) NULL, [Lng] [NVARCHAR](50) NULL, [Lat] [NVARCHAR](50) NULL, [Remark] [NVARCHAR](50) NULL ) --导入数据库 BULK INSERT dbo.[areas] FROM 'G:\IP数据库\areas.sql WITH ( FIELDTERMINATOR = '\t', ROWTERMINATOR = '\n' ) --查询 SELECT * FROM dbo.areas
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值