Hello,
I have a MySQL-table looking like this:
Year|ZIP Code|Causes of Death|Count|Location
1999|90001 |SUI |0 |(33.973092999999999, -118.247896)
... |
And I need to create JSON data which looks like this
var data = [
[
'seriesA', [ latitude, longitude, magnitude, latitude, longitude, magnitude, ... ]
],
[
'seriesB', [ latitude, longitude, magnitude, latitude, longitude, magnitude, ... ]
]
];
So getting the "Location" and "Count" columns from the MySQL table into the new JSON-file.
Thanks!