The Data-Driven Key to Unlocking New York's Congestion

Wired profiles Charles Komanoff, who's hoping to use his immense spreadsheet of New York City traffic data to clear the city's congestion.

1 minute read

May 26, 2010, 5:00 AM PDT

By Nate Berg


Komanoff's been trying to measure how traffic affects the city and its people, from time lost to money spent. He also has an eye on how understanding the patterns of transportation in the city can help improve its flows.

"Komanoff will use this interview to inform his magnum opus, the Balanced Transportation Analyzer, an enormous Excel spreadsheet that he's been building for the past three years. Over the course of about 50 worksheets, the BTA breaks down every aspect of New York City transportation-subway revenues, traffic jams, noise pollution-in an attempt to discover which mix of tolls and surcharges would create the greatest benefit for the largest number of people.

Komanoff's spreadsheet, which he has posted online, calculates how new fees and changes to existing tolls affect traffic at different times of day. It calculates which costs are borne by city dwellers and which by suburbanites. It calculates how long it takes passengers to dig for change and board buses. And it allows any user to adjust dozens of different variables-from taxi surcharges to truck tolls-and measure their impact. The result is a kind of statistical SimCity, an opportunity to play God (or at least Robert Moses) and devise the perfect traffic policy."

Monday, May 24, 2010 in Wired

portrait of professional woman

I love the variety of courses, many practical, and all richly illustrated. They have inspired many ideas that I've applied in practice, and in my own teaching. Mary G., Urban Planner

I love the variety of courses, many practical, and all richly illustrated. They have inspired many ideas that I've applied in practice, and in my own teaching.

Mary G., Urban Planner

Get top-rated, practical training

Close-up of "Apartment for rent" sign in red text on black background in front of blurred building

Trump Administration Could Effectively End Housing Voucher Program

Federal officials are eyeing major cuts to the Section 8 program that helps millions of low-income households pay rent.

April 21, 2025 - Housing Wire

Logo for Planetizen Federal Action Tracker with black and white image of U.S. Capitol with water ripple overlay.

Planetizen Federal Action Tracker

A weekly monitor of how Trump’s orders and actions are impacting planners and planning in America.

April 30, 2025 - Diana Ionescu

Ken Jennings stands in front of Snohomish County Community Transit bus.

Ken Jennings Launches Transit Web Series

The Jeopardy champ wants you to ride public transit.

April 20, 2025 - Streetsblog USA

Close-up of white panel at top of school bus with "100% electric" black text.

Driving Equity and Clean Air: California Invests in Greener School Transportation

California has awarded $500 million to fund 1,000 zero-emission school buses and chargers for educational agencies as part of its effort to reduce pollution, improve student health, and accelerate the transition to clean transportation.

April 30 - California Air Resources Board

Aerial view of Freeway Park cap park over I-5 interstate freeway in Seattle, Washington at night.

Congress Moves to End Reconnecting Communities and Related Grants

The House Transportation and Infrastructure Committee moved to rescind funding for the Neighborhood Equity and Access program, which funds highway removals, freeway caps, transit projects, pedestrian infrastructure, and more.

April 30 - Streetsblog USA

"No Thru Traffic - Open Streets Restaurants" sign in New York City during Covid-19 pandemic.

From Throughway to Public Space: Taking Back the American Street

How the Covid-19 pandemic taught us new ways to reclaim city streets from cars.

April 30 - Next City