This is an experiment in visualising the amount of people in an area with diabetes in the form of a Heatmap.

My source of data was a Microsoft Excel file.

I converted the document to a plain text file and ran regular expressions to remove unneeded portions of text. The results were then stored in a database and a JSON file with geo coordinates and total amounts for each locality was generated.

The JSON file is loaded into the Google Map Api and parsed using Google Maps visualisation HeatmapLayer, which when fed appropriate values will generate the heapmap visualisation.

Link: Diabetes Heatmap