Pretty neat. Regarding Flickr, I went to www.flickr.com/map and was able to both click&zoom on specific locations to see the relevant geotagged photos as well as use the filter form at the bottom of the map window to select galleries by group, person or date.
However, I wasn't logged on. Maybe when you're logged on, the map is already filtered by default to include only your own images? I would imagine you should be able to change that though.