This Pavement Condition Index Map of San Francisco is Amazing!

Data_SF_map_of_pavement_quality_small.jpgClick image to enlarge SF’s Pavement Condition Index map. Go to their website to use the fully interactive map feature.

The incredible design and data teams at SimpleGeo and Stamen, known among other things for Polymaps and Cabspotting, recently teamed up to tackle a data set only the wonkiest of us could love: San Francisco’s Pavement Condition Index. I assume Neal and Michael at the San Francisco Bicycle Coalitions’s Good Roads pothole fixin’ Superhero HQ have already checked this out and gushed over the results. 

For best results, click through to the Polymaps website to utilize the fully interactive map feature that allows you to zoom in to your block. While there is some lag in PCI data on Data SF, i.e. Valencia Street from 19th to 15th and Divisadero’s face lift don’t show up accurately smooth, this is nonetheless an amazing map.

I wonder if the SimpleGeo and Stamen team would consider an even bigger challenge: How about mapping the real-time NextMuni data set? I don’t know nearly enough about programming, but I would imagine it’s geometrically more complicated. Tell us what you think of this map and what other hypothetical maps you’d like to see in the comments.

McCune_prostitution_topo_map.jpgIt’s not transportation related, but Doug McCune’s topo map of San Francisco prostitution as elevation is amazing as well.
  • Sean H

    Bus speed map. Dwell time at bus stops map. Anything that helps sells system wide POP and transit only lanes for Muni.

  • I’m not sure what do you mean by mapping the real-time NextMuni data. Is it like one of this:

    I have something closer for Sean H, an analysis of historical performance data. Some preliminary work is posted here:

  • EL

    Hey, I live near one of the prostitution “humps”. 😉

  • Still gushing, Matthew. But way too much red on this map: streets in need of reconstruction or major repair. SFBC Good Roads works with DPW with this map in mind to identify bike/transit routes that need priority for repair and paving, sometimes advancing the work schedule for them. The good news is that there is steady progress as we’re finding not only on Valencia but also 7th Avenue, Steiner, and now Sanchez near the Wiggle, and several others.

    You know the closer: Turn ‘Em In….call/or report online to 311: give the location, address if possible, emphasize if hole is an immediate HAZARD, tell them you’re calling for SFBC (for tracking purposes).

  • Nice map!

    Sean H, here is the Muni speed map if you want it:

    I’ll try making a dwell time map too but imagine it would look pretty much like the same thing but inverted.

  • Why is Divisadero all red?

    A repavement was done last year from at least Geary to Haight and it’s been smooth ever since…

  • Alex

    @SeanH the data provided by NextBus is not precise enough to calculate dwell or delay information. Vehicles report their position every so often. Often times there is a > 1/4 mile gap between reports. I came close to calculating location, time, and durations of delays but packed it in after I realized that the data weren’t reliable enough.

    A heat map of bus speeds is a much easier thing to accomplish.

  • Joel

    This use of data collection and analysis is awesome. I want to point out that while Daly City doesn’t have nearly nearly as many livable streets improvements or social services, they have some damn nice roads:,+California+94127&ll=37.70842,-122.444751&spn=0.000521,0.001206&t=h&z=20&layer=c&cbll=37.708496,-122.444792&panoid=eIHNeRPLZiKeZtJQRmkxsQ&cbp=12,153.41,,0,24.22

    Here’s a look at a “border” street: the SF road with “craters” is closer, and the smooth DC road is further away. The contrast between the two is amazing.

    Bottom line is, smoother roads benefit all road users, and should be SF’s priority, even on residential streets.

  • Wow, Joel. That is a stunning visual! It certainly illustrates your point.

  • gibraltar

    Haha yes, it’s completely true about DC / SF. This is where I bike every morning:,+San+Francisco,+CA&sll=37.0625,-95.677068&sspn=44.658568,93.076172&ie=UTF8&hq=&hnear=215+De+Long+St,+San+Francisco,+California+94112&ll=37.708151,-122.467067&spn=0.010949,0.022724&z=16&layer=c&cbll=37.708247,-122.466969&panoid=Kg72eQUw5wFQfPtSW7OjUw&cbp=12,224.31,,0,5

    Again you can see how nice the pavement becomes at the border. And not just the pavement, but also the weeds are under control in DC and the street is cleaner.

    Of course, this is largely due to the fact that the southern part of SF is forgotten. By politicians, by journalists and also very often even by Streetsblog. The first imageof this post illustrates this point: apparently, San Francisco stops at Cesar Chavez street.

  • Oh, Gibraltar. I cut the image at Chavez for the sake of fitting the picture in width-wise. I live south of Chavez myself and certainly don’t consider it the border.


San Francisco to Start Smart Parking Management Trial Soon

The central principle of San Francisco’s cutting-edge parking management program, SFPark, comes right from Econ 101. If there are more people looking for parking than there are parking spaces (i.e. demand is greater than supply) adjust the price of parking until there is enough turnover on a given street, or roughly one free parking space […]

Reckless Driver Leaves Urban Data Maven Zachary Watson Fighting for Life

Zachary Watson, a noted 29-year-old city data visualizer, remains hospitalized in critical condition after a driver fleeing police in a stolen minivan caused a two-car wreck Monday night. Watson was apparently walking with his bike or locking it up when the vehicles hurtled toward him. He is known for creating works like a map of private shuttles that connect San […]

In New Orleans, You Should Follow the River

A city determined by the Mississippi. (Google photo composite: Leto A. via Flickr) Today on the Streetsblog Network, there’s a lovely post about the geographic idiosyncrasy of New Orleans, from NolaCycle Bike Map Project. This is the blog of a group whose mission is "to create a high quality cycling map of New Orleans" by […]

Happy Belated Transportation Freedom Day, San Francisco!

I’m sorry I’m late.  You know how it is, if it’s not in the Facebook calendar, I’m pretty much worthless at remembering.   Similar to the premise behind Tax Freedom Day, on March 1st, the San Francisco Bay Area celebrated (did it?) Transportation Freedom Day, the day when an average household has worked enough to […]

Walk Score Goes Multimodal With the Addition of Transit Score

Like much of Manhattan, Streetsblog HQ nets a "Rider’s Paradise" rating from Transit Score. One of the simplest and best tools for promoting walkable development has branched out into the full range of car-free transportation. Walk Score, the website which measures how many neighborhood amenities are within walking distance of a given location, has added […]