RatGraph: Visualization of Rat Sightings in NYC

Rats! At times, they seem to be everywhere in New York City, scurrying across the subway tracks or into a dark alley. Statistician Jonathan Auerbach recently estimated that there are about 2 million rats in the city. Rats carry a variety of infectious bacteria, as a recent study by researchers at Columbia University found. In October 2014, the city of New York was rated the 4th rattiest city in the country by Orkin.

The city makes much of its data on reported rat and rodent sightings available to the public. The visualization below uses the data from 311 calls to show how rat sightings vary over time and location.

RatGraph Summary [+] View the interactive version of this graph

A recent study by Dr. Michael Walsh, Assistant Professor of Epidemiology and Biostatistics in the School of Public Health at SUNY Downstate, combined this rat sighting data with socioeconomic and geographic data and found that "closer proximity to both subway lines and recreational public spaces was associated with a higher concentration of rat sightings, as was a greater presence of older housing, vacant housing units, and low education among the population."

Looking at sightings over time is particularly relevant because NYC is in the process of piloting a new rat control program that uses a chemical, ContraPest® from SenesTech Inc., to reduce rat fertility.

For the scientifically inclined, the main active ingredient in ContraPest is 4-vinylcyclohexene diepoxide (VCD).  This paper provides a good overview of what scientists know about its mechanism of action and effects.  In short, it seems to cause early menopause in female rats.

If the pilot portion of the study being conducted in 2014 is successful and NYC rolls out the program on a wider basis, the number of rat sightings over time should go down.

You can clearly see some seasonal variation in the data.  The most dominant species of rat in NYC, the brown rat (rattus norvegicus), breeds year-around but mates more frequently in the warmer months of the year so this is a likely explanation for the variation.

About the Data

The rodent complaint data comes from NYC Open Data. About 10% of the complaint records have a resolved date that is before the created date, sometimes as much as a few months before. To determine the sighting date, this visualization uses the minimum of the created and resolved dates.

The income data is from the 2008-2012 American Community Survey 5 Year Average and the population data is from the 2010 Diennial Census.

Credits

Thank you to Cyrus Innovation and Occom for their support of this project. Thank you to David Blinn for transitioning the site from Heroku to GitHub pages.

Thank you to Frank Donnelly for his great explanation of how to find census data and his zip code to ZCTA mapping. Thank you to Jon Roberts for his NYC Zip Code Map.