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

Concrete Brutalism building with slanted walls and light visible through an atrium.

What ‘The Brutalist’ Teaches Us About Modern Cities

How architecture and urban landscapes reflect the trauma and dysfunction of the post-war experience.

February 28, 2025 - Justin Hollander

Complete Street

‘Complete Streets’ Webpage Deleted in Federal Purge

Basic resources and information on building bike lanes and sidewalks, formerly housed on the government’s Complete Streets website, are now gone.

February 27, 2025 - Streetsblog USA

Green electric Volkswagen van against a beach backdrop.

The VW Bus is Back — Now as an Electric Minivan

Volkswagen’s ID. Buzz reimagines its iconic Bus as a fully electric minivan, blending retro design with modern technology, a 231-mile range, and practical versatility to offer a stylish yet functional EV for the future.

March 3, 2025 - ABC 7 Eyewitness News

View of mountains with large shrubs in foreground in Altadena, California.

Healing Through Parks: Altadena’s Path to Recovery After the Eaton Fire

In the wake of the Eaton Fire, Altadena is uniting to restore Loma Alta Park, creating a renewed space for recreation, community gathering, and resilience.

March 9 - Pasadena NOw

Aerial view of single-family homes with swimming pools in San Diego, California.

San Diego to Rescind Multi-Unit ADU Rule

The city wants to close a loophole that allowed developers to build apartment buildings on single-family lots as ADUs.

March 9 - Axios

Close-up of row of electric cars plugged into chargers at outdoor station.

Electric Vehicles for All? Study Finds Disparities in Access and Incentives

A new UCLA study finds that while California has made progress in electric vehicle adoption, disadvantaged communities remain underserved in EV incentives, ownership, and charging access, requiring targeted policy changes to advance equity.

March 9 - UCLA Luskin Center for Innovation