A few days ago I posted a link to a US Flickr and Tweet map. There is now a large set of regions and cities with this information.

Red dots are locations of Flickr pictures. Blue dots are locations of Twitter tweets. White dots are locations that have been posted to both.