tw-100-mountain-csv-to-json

tw-100-mountain-csv-to-json.js

var fs = require('fs');
var parse = require('csv-parse');

fs.readFile('100mountain.csv', (err, dataCSV) => {
  if (err) throw err;
  parse(dataCSV, (err, dataArray) => {
    dataArray = dataArray.slice(1).map( (mountain, index) => {
      return({
        index: Number.parseInt(mountain[0]),
        name: mountain[2],
        altitude: Number.parseInt(mountain[4]),
        longitude: {
          direction: 'N',
          degrees: mountain[8].match(/\d+/g)[0],
          minutes: mountain[8].match(/\d+/g)[1],
          seconds: mountain[8].match(/\d+/g)[2]
        },
        latitude: {
          direction: 'E',
          degrees: mountain[8].match(/\d+/g)[3],
          minutes: mountain[8].match(/\d+/g)[4],
          seconds: mountain[8].match(/\d+/g)[5]
        }
      })
    })
    fs.writeFile('mountains.json', JSON.stringify(dataArray), (err) => {
      if (err) throw err;
      console.log('finished')
    })
  })
})

tw-100-mountain.csv

tw-100-mountain.json

[{"index":1,"name":"玉山","altitude":3952,"longitude":{"direction":"N","degrees":"23","minutes":"28","seconds":"14"},"latitude":{"direction":"E","degrees":"120","minutes":"56","seconds":"56"}},{"index":2,"name":"雪山","altitude":3886,"longitude":{"direction":"N","degrees":"24","minutes":"23","seconds":"08"},"latitude":{"direction":"E","degrees":"121","minutes":"13","seconds":"23"}},{"index":3,"name":"玉山東峰","altitude":3869,"longitude":{"direction":"N","degrees":"23","minutes":"28","seconds":"21"},"latitude":{"direction":"E","degrees":"120","minutes":"57","seconds":"27"}},{"index":4,"name":"玉山北峰","altitude":3858,"longitude":{"direction":"N","degrees":"23","minutes":"29","seconds":"30"},"latitude":{"direction":"E","degrees":"120","minutes":"57","seconds":"05"}},{"index":5,"name":"玉山南峰","altitude":3844,"longitude":{"direction":"N","degrees":"23","minutes":"26","seconds":"53"},"latitude":{"direction":"E","degrees":"120","minutes":"57","seconds":"02"}},{"index":6,"name":"秀姑巒山","altitude":3805,"longitude":{"direction":"N","degrees":"23","minutes":"29","seconds":"53"},"latitude":{"direction":"E","degrees":"121","minutes":"03","seconds":"02"}},{"index":7,"name":"馬博拉斯山","altitude":3765,"longitude":{"direction":"N","degrees":"23","minutes":"31","seconds":"20"},"latitude":{"direction":"E","degrees":"121","minutes":"03","seconds":"34"}},{"index":8,"name":"南湖大山","altitude":3742,"longitude":{"direction":"N","degrees":"24","minutes":"21","seconds":"49"},"latitude":{"direction":"E","degrees":"121","minutes":"25","seconds":"44"}},{"index":9,"name":"東小南山","altitude":3711,"longitude":{"direction":"N","degrees":"23","minutes":"26","seconds":"26"},"latitude":{"direction":"E","degrees":"120","minutes":"57","seconds":"19"}},{"index":10,"name":"中央尖山","altitude":3705,"longitude":{"direction":"N","degrees":"24","minutes":"19","seconds":"43"},"latitude":{"direction":"E","degrees":"121","minutes":"24","seconds":"28"}},{"index":11,"name":"雪山北峰","altitude":3703,"longitude":{"direction":"N","degrees":"24","minutes":"25","seconds":"02"},"latitude":{"direction":"E","degrees":"121","minutes":"13","seconds":"55"}},{"index":12,"name":"關山","altitude":3668,"longitude":{"direction":"N","degrees":"23","minutes":"13","seconds":"50"},"latitude":{"direction":"E","degrees":"120","minutes":"54","seconds":"12"}},{"index":13,"name":"南湖大山東峰","altitude":3632,"longitude":{"direction":"N","degrees":"24","minutes":"22","seconds":"04"},"latitude":{"direction":"E","degrees":"121","minutes":"26","seconds":"33"}},{"index":14,"name":"大水窟山","altitude":3630,"longitude":{"direction":"N","degrees":"23","minutes":"28","seconds":"32"},"latitude":{"direction":"E","degrees":"121","minutes":"01","seconds":"50"}},{"index":15,"name":"東郡大山","altitude":3619,"longitude":{"direction":"N","degrees":"23","minutes":"37","seconds":"41"},"latitude":{"direction":"E","degrees":"121","minutes":"05","seconds":"03"}},{"index":16,"name":"奇萊主山北峰","altitude":3607,"longitude":{"direction":"N","degrees":"24","minutes":"07","seconds":"18"},"latitude":{"direction":"E","degrees":"121","minutes":"19","seconds":"42"}},{"index":17,"name":"向陽山","altitude":3603,"longitude":{"direction":"N","degrees":"23","minutes":"17","seconds":"11"},"latitude":{"direction":"E","degrees":"120","minutes":"59","seconds":"04"}},{"index":18,"name":"大劍山","altitude":3594,"longitude":{"direction":"N","degrees":"24","minutes":"20","seconds":"33"},"latitude":{"direction":"E","degrees":"121","minutes":"11","seconds":"32"}},{"index":19,"name":"雲峰","altitude":3564,"longitude":{"direction":"N","degrees":"23","minutes":"21","seconds":"20"},"latitude":{"direction":"E","degrees":"120","minutes":"58","seconds":"04"}},{"index":20,"name":"奇萊主山","altitude":3560,"longitude":{"direction":"N","degrees":"24","minutes":"05","seconds":"16"},"latitude":{"direction":"E","degrees":"121","minutes":"18","seconds":"54"}},{"index":21,"name":"馬利加南山","altitude":3546,"longitude":{"direction":"N","degrees":"23","minutes":"31","seconds":"59"},"latitude":{"direction":"E","degrees":"121","minutes":"06","seconds":"37"}},{"index":22,"name":"南湖北山","altitude":3536,"longitude":{"direction":"N","degrees":"24","minutes":"23","seconds":"09"},"latitude":{"direction":"E","degrees":"121","minutes":"25","seconds":"43"}},{"index":23,"name":"大雪山","altitude":3530,"longitude":{"direction":"N","degrees":"24","minutes":"19","seconds":"57"},"latitude":{"direction":"E","degrees":"121","minutes":"06","seconds":"46"}},{"index":24,"name":"品田山","altitude":3524,"longitude":{"direction":"N","degrees":"24","minutes":"25","seconds":"48"},"latitude":{"direction":"E","degrees":"121","minutes":"15","seconds":"32"}},{"index":25,"name":"玉山西峰","altitude":3518,"longitude":{"direction":"N","degrees":"23","minutes":"28","seconds":"26"},"latitude":{"direction":"E","degrees":"120","minutes":"55","seconds":"33"}},{"index":26,"name":"頭鷹山","altitude":3510,"longitude":{"direction":"N","degrees":"24","minutes":"21","seconds":"43"},"latitude":{"direction":"E","degrees":"121","minutes":"07","seconds":"56"}},{"index":27,"name":"三叉山","altitude":3496,"longitude":{"direction":"N","degrees":"23","minutes":"17","seconds":"58"},"latitude":{"direction":"E","degrees":"121","minutes":"01","seconds":"14"}},{"index":28,"name":"大霸尖山","altitude":3492,"longitude":{"direction":"N","degrees":"24","minutes":"27","seconds":"40"},"latitude":{"direction":"E","degrees":"121","minutes":"14","seconds":"59"}},{"index":29,"name":"南湖大山南峰","altitude":3475,"longitude":{"direction":"N","degrees":"24","minutes":"20","seconds":"58"},"latitude":{"direction":"E","degrees":"121","minutes":"25","seconds":"36"}},{"index":30,"name":"東巒大山","altitude":3468,"longitude":{"direction":"N","degrees":"23","minutes":"39","seconds":"00"},"latitude":{"direction":"E","degrees":"121","minutes":"04","seconds":"25"}},{"index":31,"name":"無明山","altitude":3451,"longitude":{"direction":"N","degrees":"24","minutes":"15","seconds":"27"},"latitude":{"direction":"E","degrees":"121","minutes":"22","seconds":"43"}},{"index":32,"name":"巴巴山","altitude":3449,"longitude":{"direction":"N","degrees":"24","minutes":"20","seconds":"42"},"latitude":{"direction":"E","degrees":"121","minutes":"25","seconds":"48"}},{"index":33,"name":"馬西山","altitude":3443,"longitude":{"direction":"N","degrees":"23","minutes":"29","seconds":"05"},"latitude":{"direction":"E","degrees":"121","minutes":"09","seconds":"58"}},{"index":34,"name":"北合歡山","altitude":3422,"longitude":{"direction":"N","degrees":"24","minutes":"10","seconds":"59"},"latitude":{"direction":"E","degrees":"121","minutes":"16","seconds":"24"}},{"index":35,"name":"合歡山東峰","altitude":3421,"longitude":{"direction":"N","degrees":"24","minutes":"08","seconds":"16"},"latitude":{"direction":"E","degrees":"121","minutes":"16","seconds":"23"}},{"index":36,"name":"小霸尖山","altitude":3418,"longitude":{"direction":"N","degrees":"24","minutes":"27","seconds":"20"},"latitude":{"direction":"E","degrees":"121","minutes":"14","seconds":"35"}},{"index":37,"name":"合歡山","altitude":3417,"longitude":{"direction":"N","degrees":"24","minutes":"08","seconds":"42"},"latitude":{"direction":"E","degrees":"121","minutes":"15","seconds":"47"}},{"index":38,"name":"南玉山","altitude":3383,"longitude":{"direction":"N","degrees":"23","minutes":"25","seconds":"53"},"latitude":{"direction":"E","degrees":"120","minutes":"55","seconds":"01"}},{"index":39,"name":"畢祿山","altitude":3371,"longitude":{"direction":"N","degrees":"24","minutes":"12","seconds":"55"},"latitude":{"direction":"E","degrees":"121","minutes":"20","seconds":"21"}},{"index":40,"name":"卓社大山","altitude":3369,"longitude":{"direction":"N","degrees":"23","minutes":"50","seconds":"10"},"latitude":{"direction":"E","degrees":"121","minutes":"06","seconds":"16"}},{"index":41,"name":"奇萊主山南峰","altitude":3358,"longitude":{"direction":"N","degrees":"24","minutes":"03","seconds":"50"},"latitude":{"direction":"E","degrees":"121","minutes":"16","seconds":"18"}},{"index":42,"name":"南雙頭山","altitude":3356,"longitude":{"direction":"N","degrees":"23","minutes":"21","seconds":"09"},"latitude":{"direction":"E","degrees":"121","minutes":"00","seconds":"40"}},{"index":43,"name":"能高山南峰","altitude":3349,"longitude":{"direction":"N","degrees":"23","minutes":"58","seconds":"02"},"latitude":{"direction":"E","degrees":"121","minutes":"16","seconds":"06"}},{"index":44,"name":"白姑大山","altitude":3341,"longitude":{"direction":"N","degrees":"24","minutes":"12","seconds":"17"},"latitude":{"direction":"E","degrees":"121","minutes":"06","seconds":"03"}},{"index":45,"name":"八通關山","altitude":3335,"longitude":{"direction":"N","degrees":"23","minutes":"29","seconds":"32"},"latitude":{"direction":"E","degrees":"121","minutes":"00","seconds":"06"}},{"index":46,"name":"新康山","altitude":3331,"longitude":{"direction":"N","degrees":"23","minutes":"19","seconds":"10"},"latitude":{"direction":"E","degrees":"121","minutes":"07","seconds":"10"}},{"index":47,"name":"丹大山","altitude":3325,"longitude":{"direction":"N","degrees":"23","minutes":"36","seconds":"08"},"latitude":{"direction":"E","degrees":"121","minutes":"12","seconds":"20"}},{"index":48,"name":"桃山","altitude":3325,"longitude":{"direction":"N","degrees":"24","minutes":"26","seconds":"03"},"latitude":{"direction":"E","degrees":"121","minutes":"17","seconds":"48"}},{"index":49,"name":"佳陽山","altitude":3314,"longitude":{"direction":"N","degrees":"24","minutes":"18","seconds":"32"},"latitude":{"direction":"E","degrees":"121","minutes":"10","seconds":"47"}},{"index":50,"name":"火石山","altitude":3310,"longitude":{"direction":"N","degrees":"24","minutes":"23","seconds":"03"},"latitude":{"direction":"E","degrees":"121","minutes":"10","seconds":"10"}},{"index":51,"name":"池有山","altitude":3303,"longitude":{"direction":"N","degrees":"24","minutes":"25","seconds":"57"},"latitude":{"direction":"E","degrees":"121","minutes":"16","seconds":"48"}},{"index":52,"name":"伊澤山","altitude":3297,"longitude":{"direction":"N","degrees":"24","minutes":"28","seconds":"19"},"latitude":{"direction":"E","degrees":"121","minutes":"14","seconds":"08"}},{"index":53,"name":"卑南主山","altitude":3295,"longitude":{"direction":"N","degrees":"23","minutes":"03","seconds":"12"},"latitude":{"direction":"E","degrees":"120","minutes":"51","seconds":"59"}},{"index":54,"name":"郡大山","altitude":3292,"longitude":{"direction":"N","degrees":"23","minutes":"35","seconds":"26"},"latitude":{"direction":"E","degrees":"120","minutes":"56","seconds":"55"}},{"index":55,"name":"志佳陽大山","altitude":3289,"longitude":{"direction":"N","degrees":"24","minutes":"21","seconds":"42"},"latitude":{"direction":"E","degrees":"121","minutes":"14","seconds":"26"}},{"index":56,"name":"干卓萬山","altitude":3284,"longitude":{"direction":"N","degrees":"23","minutes":"52","seconds":"40"},"latitude":{"direction":"E","degrees":"121","minutes":"07","seconds":"51"}},{"index":57,"name":"太魯閣大山","altitude":3283,"longitude":{"direction":"N","degrees":"24","minutes":"04","seconds":"53"},"latitude":{"direction":"E","degrees":"121","minutes":"24","seconds":"56"}},{"index":58,"name":"轆轆山","altitude":3279,"longitude":{"direction":"N","degrees":"23","minutes":"23","seconds":"35"},"latitude":{"direction":"E","degrees":"120","minutes":"59","seconds":"26"}},{"index":59,"name":"喀西帕南山","altitude":3276,"longitude":{"direction":"N","degrees":"23","minutes":"28","seconds":"01"},"latitude":{"direction":"E","degrees":"121","minutes":"10","seconds":"42"}},{"index":60,"name":"內嶺爾山","altitude":3275,"longitude":{"direction":"N","degrees":"23","minutes":"34","seconds":"51"},"latitude":{"direction":"E","degrees":"121","minutes":"11","seconds":"09"}},{"index":61,"name":"鈴鳴山","altitude":3272,"longitude":{"direction":"N","degrees":"24","minutes":"14","seconds":"45"},"latitude":{"direction":"E","degrees":"121","minutes":"20","seconds":"35"}},{"index":62,"name":"能高山","altitude":3262,"longitude":{"direction":"N","degrees":"23","minutes":"59","seconds":"38"},"latitude":{"direction":"E","degrees":"121","minutes":"15","seconds":"07"}},{"index":63,"name":"萬東山西峰","altitude":3258,"longitude":{"direction":"N","degrees":"23","minutes":"51","seconds":"13"},"latitude":{"direction":"E","degrees":"121","minutes":"10","seconds":"38"}},{"index":64,"name":"劍山","altitude":3253,"longitude":{"direction":"N","degrees":"24","minutes":"17","seconds":"53"},"latitude":{"direction":"E","degrees":"121","minutes":"09","seconds":"38"}},{"index":65,"name":"屏風山","altitude":3250,"longitude":{"direction":"N","degrees":"24","minutes":"09","seconds":"06"},"latitude":{"direction":"E","degrees":"121","minutes":"20","seconds":"05"}},{"index":66,"name":"小關山","altitude":3249,"longitude":{"direction":"N","degrees":"23","minutes":"09","seconds":"12"},"latitude":{"direction":"E","degrees":"120","minutes":"52","seconds":"06"}},{"index":67,"name":"義西請馬至山","altitude":3245,"longitude":{"direction":"N","degrees":"23","minutes":"35","seconds":"18"},"latitude":{"direction":"E","degrees":"121","minutes":"08","seconds":"42"}},{"index":68,"name":"牧山","altitude":3241,"longitude":{"direction":"N","degrees":"23","minutes":"51","seconds":"53"},"latitude":{"direction":"E","degrees":"121","minutes":"09","seconds":"08"}},{"index":69,"name":"玉山前峰","altitude":3239,"longitude":{"direction":"N","degrees":"23","minutes":"28","seconds":"38"},"latitude":{"direction":"E","degrees":"120","minutes":"54","seconds":"37"}},{"index":70,"name":"石門山","altitude":3237,"longitude":{"direction":"N","degrees":"24","minutes":"09","seconds":"18"},"latitude":{"direction":"E","degrees":"121","minutes":"16","seconds":"45"}},{"index":71,"name":"無雙山","altitude":3231,"longitude":{"direction":"N","degrees":"23","minutes":"35","seconds":"39"},"latitude":{"direction":"E","degrees":"121","minutes":"02","seconds":"58"}},{"index":72,"name":"塔關山","altitude":3222,"longitude":{"direction":"N","degrees":"23","minutes":"15","seconds":"16"},"latitude":{"direction":"E","degrees":"120","minutes":"55","seconds":"59"}},{"index":73,"name":"馬比杉山","altitude":3211,"longitude":{"direction":"N","degrees":"24","minutes":"21","seconds":"01"},"latitude":{"direction":"E","degrees":"121","minutes":"28","seconds":"41"}},{"index":74,"name":"達芬尖山","altitude":3208,"longitude":{"direction":"N","degrees":"23","minutes":"26","seconds":"14"},"latitude":{"direction":"E","degrees":"121","minutes":"00","seconds":"18"}},{"index":75,"name":"雪山東峰","altitude":3201,"longitude":{"direction":"N","degrees":"24","minutes":"23","seconds":"28"},"latitude":{"direction":"E","degrees":"121","minutes":"15","seconds":"48"}},{"index":76,"name":"南華山","altitude":3184,"longitude":{"direction":"N","degrees":"24","minutes":"02","seconds":"29"},"latitude":{"direction":"E","degrees":"121","minutes":"16","seconds":"40"}},{"index":77,"name":"關山嶺山","altitude":3176,"longitude":{"direction":"N","degrees":"23","minutes":"16","seconds":"23"},"latitude":{"direction":"E","degrees":"120","minutes":"57","seconds":"04"}},{"index":78,"name":"海諾南山","altitude":3175,"longitude":{"direction":"N","degrees":"23","minutes":"11","seconds":"19"},"latitude":{"direction":"E","degrees":"120","minutes":"54","seconds":"12"}},{"index":79,"name":"中雪山","altitude":3173,"longitude":{"direction":"N","degrees":"24","minutes":"21","seconds":"17"},"latitude":{"direction":"E","degrees":"121","minutes":"04","seconds":"10"}},{"index":80,"name":"閂山","altitude":3168,"longitude":{"direction":"N","degrees":"24","minutes":"15","seconds":"37"},"latitude":{"direction":"E","degrees":"121","minutes":"18","seconds":"06"}},{"index":81,"name":"甘藷峰","altitude":3158,"longitude":{"direction":"N","degrees":"24","minutes":"17","seconds":"32"},"latitude":{"direction":"E","degrees":"121","minutes":"22","seconds":"52"}},{"index":82,"name":"西合歡山","altitude":3145,"longitude":{"direction":"N","degrees":"24","minutes":"10","seconds":"46"},"latitude":{"direction":"E","degrees":"121","minutes":"14","seconds":"11"}},{"index":83,"name":"審馬陣山","altitude":3141,"longitude":{"direction":"N","degrees":"24","minutes":"22","seconds":"57"},"latitude":{"direction":"E","degrees":"121","minutes":"24","seconds":"33"}},{"index":84,"name":"喀拉業山","altitude":3133,"longitude":{"direction":"N","degrees":"24","minutes":"27","seconds":"07"},"latitude":{"direction":"E","degrees":"121","minutes":"18","seconds":"47"}},{"index":85,"name":"庫哈諾辛山","altitude":3115,"longitude":{"direction":"N","degrees":"23","minutes":"15","seconds":"54"},"latitude":{"direction":"E","degrees":"120","minutes":"53","seconds":"24"}},{"index":86,"name":"加利山","altitude":3112,"longitude":{"direction":"N","degrees":"24","minutes":"27","seconds":"37"},"latitude":{"direction":"E","degrees":"121","minutes":"12","seconds":"28"}},{"index":87,"name":"白石山","altitude":3110,"longitude":{"direction":"N","degrees":"23","minutes":"54","seconds":"34"},"latitude":{"direction":"E","degrees":"121","minutes":"16","seconds":"00"}},{"index":88,"name":"磐石山","altitude":3106,"longitude":{"direction":"N","degrees":"24","minutes":"06","seconds":"26"},"latitude":{"direction":"E","degrees":"121","minutes":"22","seconds":"48"}},{"index":89,"name":"帕托魯山","altitude":3101,"longitude":{"direction":"N","degrees":"24","minutes":"06","seconds":"06"},"latitude":{"direction":"E","degrees":"121","minutes":"27","seconds":"30"}},{"index":90,"name":"北大武山","altitude":3092,"longitude":{"direction":"N","degrees":"22","minutes":"37","seconds":"45"},"latitude":{"direction":"E","degrees":"120","minutes":"45","seconds":"07"}},{"index":91,"name":"巒大山","altitude":3081,"longitude":{"direction":"N","degrees":"23","minutes":"41","seconds":"43"},"latitude":{"direction":"E","degrees":"120","minutes":"56","seconds":"21"}},{"index":92,"name":"塔芬山","altitude":3070,"longitude":{"direction":"N","degrees":"23","minutes":"24","seconds":"27"},"latitude":{"direction":"E","degrees":"121","minutes":"01","seconds":"09"}},{"index":93,"name":"立霧主山","altitude":3070,"longitude":{"direction":"N","degrees":"24","minutes":"07","seconds":"35"},"latitude":{"direction":"E","degrees":"121","minutes":"26","seconds":"16"}},{"index":94,"name":"安東軍山","altitude":3068,"longitude":{"direction":"N","degrees":"23","minutes":"52","seconds":"26"},"latitude":{"direction":"E","degrees":"121","minutes":"15","seconds":"28"}},{"index":95,"name":"光頭山","altitude":3060,"longitude":{"direction":"N","degrees":"23","minutes":"56","seconds":"23"},"latitude":{"direction":"E","degrees":"121","minutes":"15","seconds":"46"}},{"index":96,"name":"羊頭山","altitude":3035,"longitude":{"direction":"N","degrees":"24","minutes":"12","seconds":"36"},"latitude":{"direction":"E","degrees":"121","minutes":"22","seconds":"17"}},{"index":97,"name":"駒盆山 ","altitude":3022,"longitude":{"direction":"N","degrees":"23","minutes":"33","seconds":"00"},"latitude":{"direction":"E","degrees":"121","minutes":"01","seconds":"32"}},{"index":98,"name":"布拉克桑山","altitude":3020,"longitude":{"direction":"N","degrees":"23","minutes":"14","seconds":"06"},"latitude":{"direction":"E","degrees":"121","minutes":"04","seconds":"16"}},{"index":99,"name":"六順山","altitude":2999,"longitude":{"direction":"N","degrees":"23","minutes":"43","seconds":"29"},"latitude":{"direction":"E","degrees":"121","minutes":"13","seconds":"49"}},{"index":100,"name":"鹿山","altitude":2981,"longitude":{"direction":"N","degrees":"23","minutes":"27","seconds":"08"},"latitude":{"direction":"E","degrees":"120","minutes":"58","seconds":"49"}}]