/
json_to_csv.js
47 lines (43 loc) · 1019 Bytes
/
json_to_csv.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
var fs = require('fs');
var areas = require(__dirname + '/areas.json');
/*
[{
"name":"7H BUS STAND",
"id":"19140",
"neighborhoods":[
{
"name":"MUGAPPAIR",
"id":"20087",
"streets":[
{
"name":"11TH BLOCK PARISALAI",
"id":"28034"
}
]
}
]
}]
*/
var csvout = [];
var headers = 'area,area_id,locality_name,locality_id,street,street_id';
csvout.push(headers);
for (var a = 0; a < areas.length; a++) {
for (var n = 0; n < areas[a].neighborhoods.length; n++) {
for (var s = 0; s < areas[a].neighborhoods[n].streets.length; s++) {
csvout.push([
areas[a].name,
areas[a].id,
areas[a].neighborhoods[n].name,
areas[a].neighborhoods[n].id,
areas[a].neighborhoods[n].streets[s].name,
areas[a].neighborhoods[n].streets[s].id
].join(','));
}
}
}
fs.writeFile(__dirname + '/areas.csv', csvout.join("\n"), function (err) {
if (err) {
throw err;
}
console.log('finished!');
});