All examples By author By category About

alexmacy

Rate of False Alarms by Neighborhood and Year

This came from watching Sameer Farooqui's tutorial on how to use using Spark SQL and DataFrames.

It shows the rate of false alarms - calls where the final classfication was one of 'No Merit', 'Gone on Arrival', 'Unable to Locate', 'Cancelled', or 'Duplicate'. The blue dots are the locations of SFFD fire stations, and the city has been divided up into the neighborhoods as per the data provided SF OpenData.

This was done as a way to experiment with Spark and creating visualizations within Databricks' community edition, but I exported the result of my Spark SQL query so that I could post it here as well. There is a noticeable increase in 'false alarms' towards the end, although I'm not sure why that is, I'm gueesing it may have something to do with better record keeping...

On my wishlist - or for another day: