Skip to content

Instantly share code, notes, and snippets.

@SaitoWu
Created October 28, 2014 10:20
Show Gist options
  • Select an option

  • Save SaitoWu/8bb90847fd1955fb94e7 to your computer and use it in GitHub Desktop.

Select an option

Save SaitoWu/8bb90847fd1955fb94e7 to your computer and use it in GitHub Desktop.

Revisions

  1. SaitoWu created this gist Oct 28, 2014.
    339 changes: 339 additions & 0 deletions address.csv
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,339 @@
    110100,110000,"北京市",2
    120100,120000,"天津市",2
    130100,130000,"石家庄市",2
    130200,130000,"唐山市",2
    130300,130000,"秦皇岛市",2
    130400,130000,"邯郸市",2
    130500,130000,"邢台市",2
    130600,130000,"保定市",2
    130700,130000,"张家口市",2
    130800,130000,"承德市",2
    130900,130000,"沧州市",2
    131000,130000,"廊坊市",2
    131100,130000,"衡水市",2
    140100,140000,"太原市",2
    140200,140000,"大同市",2
    140300,140000,"阳泉市",2
    140400,140000,"长治市",2
    140500,140000,"晋城市",2
    140600,140000,"朔州市",2
    140700,140000,"晋中市",2
    140800,140000,"运城市",2
    140900,140000,"忻州市",2
    141000,140000,"临汾市",2
    141100,140000,"吕梁市",2
    150100,150000,"呼和浩特市",2
    150200,150000,"包头市",2
    150300,150000,"乌海市",2
    150400,150000,"赤峰市",2
    150500,150000,"通辽市",2
    150600,150000,"鄂尔多斯市",2
    150700,150000,"呼伦贝尔市",2
    150800,150000,"巴彦淖尔市",2
    150900,150000,"乌兰察布市",2
    152200,150000,"兴安盟",2
    152500,150000,"锡林郭勒盟",2
    152900,150000,"阿拉善盟",2
    210100,210000,"沈阳市",2
    210200,210000,"大连市",2
    210300,210000,"鞍山市",2
    210400,210000,"抚顺市",2
    210500,210000,"本溪市",2
    210600,210000,"丹东市",2
    210700,210000,"锦州市",2
    210800,210000,"营口市",2
    210900,210000,"阜新市",2
    211000,210000,"辽阳市",2
    211100,210000,"盘锦市",2
    211200,210000,"铁岭市",2
    211300,210000,"朝阳市",2
    211400,210000,"葫芦岛市",2
    220100,220000,"长春市",2
    220200,220000,"吉林市",2
    220300,220000,"四平市",2
    220400,220000,"辽源市",2
    220500,220000,"通化市",2
    220600,220000,"白山市",2
    220700,220000,"松原市",2
    220800,220000,"白城市",2
    222400,220000,"延边朝鲜族自治州",2
    230100,230000,"哈尔滨市",2
    230200,230000,"齐齐哈尔市",2
    230300,230000,"鸡西市",2
    230400,230000,"鹤岗市",2
    230500,230000,"双鸭山市",2
    230600,230000,"大庆市",2
    230700,230000,"伊春市",2
    230800,230000,"佳木斯市",2
    230900,230000,"七台河市",2
    231000,230000,"牡丹江市",2
    231100,230000,"黑河市",2
    231200,230000,"绥化市",2
    232700,230000,"大兴安岭地区",2
    310100,310000,"上海市",2
    320100,320000,"南京市",2
    320200,320000,"无锡市",2
    320300,320000,"徐州市",2
    320400,320000,"常州市",2
    320500,320000,"苏州市",2
    320600,320000,"南通市",2
    320700,320000,"连云港市",2
    320800,320000,"淮安市",2
    320900,320000,"盐城市",2
    321000,320000,"扬州市",2
    321100,320000,"镇江市",2
    321200,320000,"泰州市",2
    321300,320000,"宿迁市",2
    330100,330000,"杭州市",2
    330200,330000,"宁波市",2
    330300,330000,"温州市",2
    330400,330000,"嘉兴市",2
    330500,330000,"湖州市",2
    330600,330000,"绍兴市",2
    330700,330000,"金华市",2
    330800,330000,"衢州市",2
    330900,330000,"舟山市",2
    331000,330000,"台州市",2
    331100,330000,"丽水市",2
    340100,340000,"合肥市",2
    340200,340000,"芜湖市",2
    340300,340000,"蚌埠市",2
    340400,340000,"淮南市",2
    340500,340000,"马鞍山市",2
    340600,340000,"淮北市",2
    340700,340000,"铜陵市",2
    340800,340000,"安庆市",2
    341000,340000,"黄山市",2
    341100,340000,"滁州市",2
    341200,340000,"阜阳市",2
    341300,340000,"宿州市",2
    341400,340000,"巢湖市",2
    341500,340000,"六安市",2
    341600,340000,"亳州市",2
    341700,340000,"池州市",2
    341800,340000,"宣城市",2
    350100,350000,"福州市",2
    350200,350000,"厦门市",2
    350300,350000,"莆田市",2
    350400,350000,"三明市",2
    350500,350000,"泉州市",2
    350600,350000,"漳州市",2
    350700,350000,"南平市",2
    350800,350000,"龙岩市",2
    350900,350000,"宁德市",2
    360100,360000,"南昌市",2
    360200,360000,"景德镇市",2
    360300,360000,"萍乡市",2
    360400,360000,"九江市",2
    360500,360000,"新余市",2
    360600,360000,"鹰潭市",2
    360700,360000,"赣州市",2
    360800,360000,"吉安市",2
    360900,360000,"宜春市",2
    361000,360000,"抚州市",2
    361100,360000,"上饶市",2
    370100,370000,"济南市",2
    370200,370000,"青岛市",2
    370300,370000,"淄博市",2
    370400,370000,"枣庄市",2
    370500,370000,"东营市",2
    370600,370000,"烟台市",2
    370700,370000,"潍坊市",2
    370800,370000,"济宁市",2
    370900,370000,"泰安市",2
    371000,370000,"威海市",2
    371100,370000,"日照市",2
    371200,370000,"莱芜市",2
    371300,370000,"临沂市",2
    371400,370000,"德州市",2
    371500,370000,"聊城市",2
    371600,370000,"滨州市",2
    371700,370000,"荷泽市",2
    410100,410000,"郑州市",2
    410200,410000,"开封市",2
    410300,410000,"洛阳市",2
    410400,410000,"平顶山市",2
    410500,410000,"安阳市",2
    410600,410000,"鹤壁市",2
    410700,410000,"新乡市",2
    410800,410000,"焦作市",2
    410900,410000,"濮阳市",2
    411000,410000,"许昌市",2
    411100,410000,"漯河市",2
    411200,410000,"三门峡市",2
    411300,410000,"南阳市",2
    411400,410000,"商丘市",2
    411500,410000,"信阳市",2
    411600,410000,"周口市",2
    411700,410000,"驻马店市",2
    420100,420000,"武汉市",2
    420200,420000,"黄石市",2
    420300,420000,"十堰市",2
    420500,420000,"宜昌市",2
    420600,420000,"襄樊市",2
    420700,420000,"鄂州市",2
    420800,420000,"荆门市",2
    420900,420000,"孝感市",2
    421000,420000,"荆州市",2
    421100,420000,"黄冈市",2
    421200,420000,"咸宁市",2
    421300,420000,"随州市",2
    422800,420000,"恩施土家族苗族自治州",2
    429000,420000,"省直辖行政单位",2
    430100,430000,"长沙市",2
    430200,430000,"株洲市",2
    430300,430000,"湘潭市",2
    430400,430000,"衡阳市",2
    430500,430000,"邵阳市",2
    430600,430000,"岳阳市",2
    430700,430000,"常德市",2
    430800,430000,"张家界市",2
    430900,430000,"益阳市",2
    431000,430000,"郴州市",2
    431100,430000,"永州市",2
    431200,430000,"怀化市",2
    431300,430000,"娄底市",2
    433100,430000,"湘西土家族苗族自治州",2
    440100,440000,"广州市",2
    440200,440000,"韶关市",2
    440300,440000,"深圳市",2
    440400,440000,"珠海市",2
    440500,440000,"汕头市",2
    440600,440000,"佛山市",2
    440700,440000,"江门市",2
    440800,440000,"湛江市",2
    440900,440000,"茂名市",2
    441200,440000,"肇庆市",2
    441300,440000,"惠州市",2
    441400,440000,"梅州市",2
    441500,440000,"汕尾市",2
    441600,440000,"河源市",2
    441700,440000,"阳江市",2
    441800,440000,"清远市",2
    441900,440000,"东莞市",2
    442000,440000,"中山市",2
    445100,440000,"潮州市",2
    445200,440000,"揭阳市",2
    445300,440000,"云浮市",2
    450100,450000,"南宁市",2
    450200,450000,"柳州市",2
    450300,450000,"桂林市",2
    450400,450000,"梧州市",2
    450500,450000,"北海市",2
    450600,450000,"防城港市",2
    450700,450000,"钦州市",2
    450800,450000,"贵港市",2
    450900,450000,"玉林市",2
    451000,450000,"百色市",2
    451100,450000,"贺州市",2
    451200,450000,"河池市",2
    451300,450000,"来宾市",2
    451400,450000,"崇左市",2
    460100,460000,"海口市",2
    460200,460000,"三亚市",2
    469000,460000,"省直辖县级行政单位",2
    500100,500000,"重庆市",2
    510100,510000,"成都市",2
    510300,510000,"自贡市",2
    510400,510000,"攀枝花市",2
    510500,510000,"泸州市",2
    510600,510000,"德阳市",2
    510700,510000,"绵阳市",2
    510800,510000,"广元市",2
    510900,510000,"遂宁市",2
    511000,510000,"内江市",2
    511100,510000,"乐山市",2
    511300,510000,"南充市",2
    511400,510000,"眉山市",2
    511500,510000,"宜宾市",2
    511600,510000,"广安市",2
    511700,510000,"达州市",2
    511800,510000,"雅安市",2
    511900,510000,"巴中市",2
    512000,510000,"资阳市",2
    513200,510000,"阿坝藏族羌族自治州",2
    513300,510000,"甘孜藏族自治州",2
    513400,510000,"凉山彝族自治州",2
    520100,520000,"贵阳市",2
    520200,520000,"六盘水市",2
    520300,520000,"遵义市",2
    520400,520000,"安顺市",2
    522200,520000,"铜仁地区",2
    522300,520000,"黔西南布依族苗族自治州",2
    522400,520000,"毕节地区",2
    522600,520000,"黔东南苗族侗族自治州",2
    522700,520000,"黔南布依族苗族自治州",2
    530100,530000,"昆明市",2
    530300,530000,"曲靖市",2
    530400,530000,"玉溪市",2
    530500,530000,"保山市",2
    530600,530000,"昭通市",2
    530700,530000,"丽江市",2
    530800,530000,"思茅市",2
    530900,530000,"临沧市",2
    532300,530000,"楚雄彝族自治州",2
    532500,530000,"红河哈尼族彝族自治州",2
    532600,530000,"文山壮族苗族自治州",2
    532800,530000,"西双版纳傣族自治州",2
    532900,530000,"大理白族自治州",2
    533100,530000,"德宏傣族景颇族自治州",2
    533300,530000,"怒江傈僳族自治州",2
    533400,530000,"迪庆藏族自治州",2
    540100,540000,"拉萨市",2
    542100,540000,"昌都地区",2
    542200,540000,"山南地区",2
    542300,540000,"日喀则地区",2
    542400,540000,"那曲地区",2
    542500,540000,"阿里地区",2
    542600,540000,"林芝地区",2
    610100,610000,"西安市",2
    610200,610000,"铜川市",2
    610300,610000,"宝鸡市",2
    610400,610000,"咸阳市",2
    610500,610000,"渭南市",2
    610600,610000,"延安市",2
    610700,610000,"汉中市",2
    610800,610000,"榆林市",2
    610900,610000,"安康市",2
    611000,610000,"商洛市",2
    620100,620000,"兰州市",2
    620200,620000,"嘉峪关市",2
    620300,620000,"金昌市",2
    620400,620000,"白银市",2
    620500,620000,"天水市",2
    620600,620000,"武威市",2
    620700,620000,"张掖市",2
    620800,620000,"平凉市",2
    620900,620000,"酒泉市",2
    621000,620000,"庆阳市",2
    621100,620000,"定西市",2
    621200,620000,"陇南市",2
    622900,620000,"临夏回族自治州",2
    623000,620000,"甘南藏族自治州",2
    630100,630000,"西宁市",2
    632100,630000,"海东地区",2
    632200,630000,"海北藏族自治州",2
    632300,630000,"黄南藏族自治州",2
    632500,630000,"海南藏族自治州",2
    632600,630000,"果洛藏族自治州",2
    632700,630000,"玉树藏族自治州",2
    632800,630000,"海西蒙古族藏族自治州",2
    640100,640000,"银川市",2
    640200,640000,"石嘴山市",2
    640300,640000,"吴忠市",2
    640400,640000,"固原市",2
    640500,640000,"中卫市",2
    650100,650000,"乌鲁木齐市",2
    650200,650000,"克拉玛依市",2
    652100,650000,"吐鲁番地区",2
    652200,650000,"哈密地区",2
    652300,650000,"昌吉回族自治州",2
    652700,650000,"博尔塔拉蒙古自治州",2
    652800,650000,"巴音郭楞蒙古自治州",2
    652900,650000,"阿克苏地区",2
    653000,650000,"克孜勒苏柯尔克孜自治州",2
    653100,650000,"喀什地区",2
    653200,650000,"和田地区",2
    654000,650000,"伊犁哈萨克自治州",2
    654200,650000,"塔城地区",2
    654300,650000,"阿勒泰地区",2
    17 changes: 17 additions & 0 deletions group.rb
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,17 @@
    require "ruby-pinyin"

    cities = []

    City = Struct.new(:id, :name, :alphabet)

    File.open("address.csv").each_line do |line|
    cols = line.split(",")
    id = cols[0]
    name = cols[2]
    alphabet = PinYin.of_string(cols[2]).first.chars.first.to_s.upcase
    cities << City.new(id, name, alphabet)
    end

    cities.sort{|x, y| x.alphabet <=> y.alphabet }.group_by {|c| c.alphabet }.each do |k, v|
    v.each {|i| p "#{k} => #{i.id} #{i.name}"}
    end