Posts by Cole Rosengren
Rosengren Data Presentation
FiveThirtyEight broke down the data around airline delays last month in a very detailed interactive graphic with an accompanying article. According to the Bureau of Transportation Statistics, which collects all of this information, the 6 million domestic flights in 2014 took an extra 80 million minutes to reach their destinations. Out the major airlines, United and American were the worst offenders.
-This clearly took a lot of work in terms of data organization and analysis. While it’s still a little confusing at first, the methods are explained thoroughly in an accompanying article.
-The visualizations are clear and engaging. Having the box for entering specific flights at the top works well to draw readers in.
-The map itself is fun to play with. Both charts do a good job of displaying the key points.
What could be improved:
-It would be better if the airport information card popped up automatically when you hover over an airport on the map. Right now, with so many dots, it’s hard to tell what you’re looking at unless you click on one.
-The graph plotting out times by month is confusing. Flipping the axes, so months are on the bottom along the x axis and times are on the lefthand side along y, would have been easier to understand. Right now it just looks like a bunch of lines.
Overall, a strong interactive piece that makes me happy to fly Virgin America!
Rosengren Story 2 Final
After lots of tinkering I still couldn’t figure out how to change the colors, but have made some other updates.
Rosengren Story 2
The Growing Cost of Garbage:
Headless Animals Revision
By Cole Rosengren & Jack D’Isidoro
I just realized that I accidentally wrote over the previous version. The main changes are a new title for second chart, new interview with Santeria practitioner and a third chart.
Where Does the Garbage Go?
By Cole Rosengren
Once New Yorkers put their garbage on the curb, they pay little attention to where it goes. The Department of Sanitation (DSNY) is still in the process of implementing former Mayor Bloomberg’s 2006 Solid Waste Management Plan by building new transfer stations. City Council is also considering a bill, Intro-495, that would change how much garbage goes through certain neighborhoods. These two plans have inspired particular outrage and misinformation among different communities that don’t want any garbage facilities in their backyard.
Using information from NYC Open Data, I plan to map out exactly where each community district’s garbage and recyclable materials go within the city for processing. A select few areas – the South Bronx, northern Brooklyn and southeast Queens – bear the brunt of it all. I’ll also highlight the sites of new DSNY facilities that are either being built or are planned to be built in some kind of second screen to show how they will change the pattern.
From there, I plan to map out where everything goes once it leaves the city. Data is available for New York and New Jersey landfills and waste-to-energy plants. I’m still working on data for the other states where we send our garbage – Pennsylvania, South Carolina, Ohio, etc. Even if I can’t find exact landfill locations I can still highlight that our garbage is heading in their direction.
Director of Environmental Justice, New York Lawyers for the Public Interest
Former policy director for DSNY, partner at Closed Loops consulting
Chair of City Council Committee on Sanitation & Solid Waste Management
Press Contact: Lacey Tauber
DSNY public affairs
The Mysterious Headless Animals of NYC
By Cole Rosengren & Jack D’Isidoro
Story 1 Pitch: Parks in Peril
Cole Rosengren & Jack D’Isidoro
An upcoming case before the New York State Court of Appeals, involving NYU’s expansion plans in Greenwich Village, could set a precedent that would allow private development of public parks because of a city technicality. NYU and City Hall say that three parks in question are fair game because they’re on land owned by the Department of Transportation. Community advocates say that razing these parks would violate the Public Trust Doctrine and open the door to similar development conflicts at other sites around the city.
We will show a map of parks in New York City which are owned by the DOT, but operated by the Parks Department. If applicable, we’ll also look at other sites where parks are located on non-Parks Department land.
Borough commissioner, Manhattan, NYC Parks
Director of CUNY Mapping Service
Mark Crispin Miller
President of NYU Faculty Against the Sexton Plan