Note: this project is heavy on data manipulation and coding.

I set up demo to see if PostGIS could pull crimes that are nearest Septa regional rail stations and heat map them with Leaflet and heatmap.js. It went a little viral indicating a demand for stuff like this:

http://www.nbcphiladelphia.com/news/local/Developer-Maps-Crimes-Near-SEPTA-Stops-229590131.html

http://technical.ly/philly/2013/10/23/septa-regional-rail-crime-map/

and trashed by philebrity for having no context what so ever.

http://www.philebrity.com/2013/10/22/dept-of-interactive-maps-septa-heatmap-shows-amount-of-violent-crime-near-regional-rail-stations/

Project ideas

• finish the Septa stops of buses and subway stops
• heat map the change in crime over time
• heatmap schools in the district where the most crime happens during school dismissal hours
• get data on whether it's true that more crime happens near methadone clinics vs 7 elevens(this was an actual argument last year in NE Philly)

To Do

• choose direction, flesh it all out

Help Needed

• This is project is pretty heavy programming. An experienced php/PostGRE developer