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

Cover CM Credits, Earn Certificates, Push Your Career Forward

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.

June 11, 2025 - Diana Ionescu

Metrorail train pulling into newly opened subterranean station in Washington, D.C. with crowd on platform taking photos.

Congressman Proposes Bill to Rename DC Metro “Trump Train”

The Make Autorail Great Again Act would withhold federal funding to the system until the Washington Metropolitan Area Transit Authority (WMATA), rebrands as the Washington Metropolitan Authority for Greater Access (WMAGA).

June 2, 2025 - The Hill

Large crowd on street in San Francisco, California during Oktoberfest festival.

The Simple Legislative Tool Transforming Vacant Downtowns

In California, Michigan and Georgia, an easy win is bringing dollars — and delight — back to city centers.

June 2, 2025 - Robbie Silver

Color-coded map of labor & delivery departments and losses in United States.

The States Losing Rural Delivery Rooms at an Alarming Pace

In some states, as few as 9% of rural hospitals still deliver babies. As a result, rising pre-term births, no adequate pre-term care and "harrowing" close calls are a growing reality.

June 15 - Maine Morning Star

Street scene in Kathmandu, Nepal with yellow minibuses and other traffic.

The Small South Asian Republic Going all in on EVs

Thanks to one simple policy change less than five years ago, 65% of new cars in this Himalayan country are now electric.

June 15 - Fast Company

Bike lane in Washington D.C. protected by low concrete barriers.

DC Backpedals on Bike Lane Protection, Swaps Barriers for Paint

Citing aesthetic concerns, the city is removing the concrete barriers and flexposts that once separated Arizona Avenue cyclists from motor vehicles.

June 15 - The Washington Post