This is an experiment in visualising crime data by plotting markers on geo coordinates (latitude/longitude).

My source of data was a Microsoft word document with only a general location of where the crime was committed.

I converted the document to a plain text file and ran regular expressions to remove unneeded portions of text. Then I ran every general location against a list of towns in a database which had associated geo coordinates, and built a geoJSON file with data relating to each marker.

The markers are loaded onto a custom styled Google Map and a click event is attached to each marker. When a marker a clicked a popup with information appears.

Link: Trinidad & Tobago crime data