Rate of False Alarms by Neighborhood and Year
This visualization shows the rate of false alarms (calls classified as 'No Merit', 'Gone on Arrival', 'Unable to Locate', 'Cancelled', or 'Duplicate') for San Francisco neighborhoods from 2005 to 2016. Animated over time, it displays a choropleth map of the city divided into neighborhoods, colored by the annual false alarm rate, with blue dots marking SFFD fire station locations. The animation reveals a noticeable increase in false alarms toward the end of the period, particularly in 2014-2016. The data was derived from SF OpenData and processed using Spark SQL.
AI-generated descriptionThis came from watching Sameer Farooqui's <a href="https://youtu.be/K14plpZgy_c" target="_blank">tutorial on how to use using Spark SQL and DataFrames</a>.
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:
Draw voronoi-style territories based on the locations of the fire stations, colored by number of calls within their borders.
- Possibly incorporate data about the responding station when they responded to a location outside of their voronoi territory.
Voronoi territories like above, but adjusting the polygons so that all the events are evenly distributed among the different fire stations and their voronoi territories.