World atlas of Flickr geotaggers is maptastic
The maps are ordered by the number of pictures taken in the central cluster of each one. This is a little unfair to aggressively polycentric cities like Tokyo and Los Angeles, which probably get lower placement than they really deserve because there are gaps where no one took any pictures. The central cluster of each map is not necessarily in the center of each image, because the image bounds are chosen to include as many geotagged locations as possible near the central cluster. All the maps are to the same scale, chosen to be just large enough for the central New York cluster to fit.
Additionally, trace color indicates mode of transportation. Black is walking, red is bicycling, and blue is moving by motor vehicle. From what I gather, photos either come straight from Flickr or a teamed group of people. Unfortunately, that's all I can find though. Some more explanation would probably make these a lot more enjoyable. Nevertheless, they're nice to look at.
Major streets emerge, bridges with bicycle lanes appear, and they've got a sexy spider web thing going for them.
Here are the maps for London and San Francisco, respectively.
Check out Fischer's full set on Flickr.
Update: Fischer comments, "I got the photo locations from the Flickr and Picasa search APIs. The base maps that they are plotted on top of are from OpenStreetMap. I wrote some perl scripts to identify and plot the clusters of locations. The scripts generate PostScript which I then converted to JPEGs using Ghostscript."