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

High-rise apartment buildings in Waikiki, Hawaii with steep green mountains in background.

Study: Maui’s Plan to Convert Vacation Rentals to Long-Term Housing Could Cause Nearly $1 Billion Economic Loss

The plan would reduce visitor accommodation by 25% resulting in 1,900 jobs lost.

April 6, 2025 - Honolulu Civil Beat

Blue and white Seattle Link light rail train exiting concrete Downtown Bellevue Tunnel in Bellevue, WA.

Why Should We Subsidize Public Transportation?

Many public transit agencies face financial stress due to rising costs, declining fare revenue, and declining subsidies. Transit advocates must provide a strong business case for increasing public transit funding.

April 7, 2025 - Todd Litman

Silhouette of man holding on to back of bicycle ridden by woman with Eiffel Tower in background.

Paris Bike Boom Leads to Steep Drop in Air Pollution

The French city’s air quality has improved dramatically in the past 20 years, coinciding with a growth in cycling.

April 14 - Momentum Magazine

Multifamily housing under construction.

Why Housing Costs More to Build in California Than in Texas

Hard costs like labor and materials combined with ‘soft’ costs such as permitting make building in the San Francisco Bay Area almost three times as costly as in Texas cities.

April 14 - San Francisco Chronicle

Western coyote looking at camera in grassy field.

San Diego County Sees a Rise in Urban Coyotes

San Diego County experiences a rise in urban coyotes, as sightings become prevalent throughout its urban neighbourhoods and surrounding areas.

April 14 - Fox 5