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

Wastewater pouring out from a pipe.

Alabama: Trump Terminates Settlements for Black Communities Harmed By Raw Sewage

Trump deemed the landmark civil rights agreement “illegal DEI and environmental justice policy.”

April 13, 2025 - Inside Climate News

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 16, 2025 - Diana Ionescu

Black and white photos of camp made up of small 'earthquake shacks' in Dolores Park in 1906 after the San Francisco earthquake.

The 120 Year Old Tiny Home Villages That Sheltered San Francisco’s Earthquake Refugees

More than a century ago, San Francisco mobilized to house thousands of residents displaced by the 1906 earthquake. Could their strategy offer a model for the present?

April 15, 2025 - Charles F. Bloszies

People walking up and down stairs in New York City subway station.

In Both Crashes and Crime, Public Transportation is Far Safer than Driving

Contrary to popular assumptions, public transportation has far lower crash and crime rates than automobile travel. For safer communities, improve and encourage transit travel.

7 hours ago - Scientific American

White public transit bus with bike on front bike rack in Nashville, Tennessee.

Report: Zoning Reforms Should Complement Nashville’s Ambitious Transit Plan

Without reform, restrictive zoning codes will limit the impact of the city’s planned transit expansion and could exclude some of the residents who depend on transit the most.

April 18 - Bloomberg CityLab

An engineer controlling a quality of water ,aerated activated sludge tank at a waste water treatment plant.

Judge Orders Release of Frozen IRA, IIJA Funding

The decision is a victory for environmental groups who charged that freezing funds for critical infrastructure and disaster response programs caused “real and irreparable harm” to communities.

April 18 - Smart Cities Dive