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.


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 […]

New Website Tracks How Well CA Cap-and-Trade Fights Climate Change

TransForm has unveiled the Climate Benefits Map, an interactive online tool that provides a centralized source tracking the benefits of California’s cap-and-trade program, which helps fund transit and development projects. The map, currently in beta, will feature all the data available about the various programs and projects funded by the state’s Greenhouse Gas Reduction Fund (GGRF) and make it available to […]

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 […]

Mapping Your City with Pictures Taken by Others

Data visualization is the rage right now, as city managers release ever more information through open source APIs and creative programmers tease out trends in colorful maps and images, beautifully depicting statistics that would otherwise be stuck in a dense spreadsheet only an actuary could love. Media foundations have been busy giving money to pioneering […]

Subway Metadata Master Plan

Yesterday afternoon the Land Use and Transportation Committee of the San Francisco Board of Supervisors heard a presentation from transportation officials on efforts to design a “Subway Master Plan,” a long-range blueprint for a subway network for San Francisco. From a release on the meeting from Supervisor Scott Wiener’s office: Today at the Land Use […]