Posted on July 18, 2013
While cooling off via fire hydrant can be done legally, rogue streetside waterparks are generally frowned upon by the city.
Over a quick coffee-break a few of our data scientists wondered how hot does it need to get before New Yorkers open up fire hydrants?
The answer, based upon an analysis of complaints to 311, appears to be 80-85F with most instances occurring in the late afternoon. Hardly a shocker, but nonetheless an amusing insight into how NYC’s digital footprint reveals nuanced details on the pulse of the city.
The raw 311 data contains many additional details including the location of the complaint. However, after polishing off the morning cup of coffee we were done with fire hydrants for the day and got back to project-related analytics.
In this first set of charts we look at the volume of daily 311 calls relative to the maximum temperature recorded that day in Central Park. Calls for both “Hydrant Running” and “Illegal Use of a Hydrant” markedly increase once the temperature reaches about 80 degrees F. The bottom chart shows the overall 311 call volume for all other calls and there is very little correlation with temperature apart from a slight increase in volume for colder temperatures.
While the call volume increases we see for these two subsets can be due to a number of causes, it’s a reasonable assumption that a sizable portion of this trend is related to those looking to cool off. To further analyze that assumption we looked at the typical time of day for “Illegal Use of a Hydrant” calls on ‘hot’ (max temperature >78 degrees F) and ‘normal’ days. On ‘hot’ days, calls about the fire hydrants significantly increase in the late afternoon during the warmest part of the day. On cooler days no such significant time-specific peak is observed.
Coffee break insights are short and simple samples of digital analytics using publicly available data sources. The name comes from the fact that many of these charts and graphs are the result of informal "I wonder what..." conversations that occur around the CKM Advisors coffee bar. While the topics are often wholly unrelated to our consulting work, such simple results highlight the power of leveraging digital data for studying activities within complex organizations.