After discovering the highest grossing hydrants in NYC, as measured by ticket revenue, I decided to expand a bit and make a map of the top 250 offending hydrants using the same NYC Open Data dataset.

At the top of the list, of course, are the two sneaky hydrants that were recently exposed by this blog. But mapping the remaining ones shows they are anything but evenly distributed around the city:

The map allows you to see the estimated annual ticket revenue from each of the top 250 grossing hydrants. Hover over any hydrant to see the revenue. The larger the circle, the more revenue generated. (Click on any hydrant to see the address. "O" means opposite, and “F” means in front of.)

After looking at this for a bit, what stood out the most to me was Lenox Hill on the Upper East Side. The number of top hydrants in that neighborhood seemed unreal. In fact 25% of the hydrants on this top 250 list are in that single neighborhood around the 19th precinct.

So is the 19th Precinct really that much of an outlier in the city? I decided to look at all hydrant tickets in the data set, and a more startling fact came to light: The 19th precinct issues an estimated 3 million dollars a year in hydrant tickets, more than double the total of the next closest precinct: the 34th in Washington Heights and Inwood, which issues about 1.4 million dollars in hydrant tickets annually. This graph shows how extreme the 19th Precinct is, when compared to the other Top 10 Precincts for Hydrant Tickets:

So if you live in Lenox Hill and drive, make sure you carry measuring tape! And good luck.

Data provided by NYC Open Data (August 1st 2013 - March 26th 2014)

Interactice Map made in CartoDB

Hydrant analysis done with pandas/ipython

Geocoding done with Google via geopy