Via SearchViews.
Vimeo has a similar interface to Flickr and works on collaborative content management.
Its currently in Beta and does not support account signups. But it does look cool.

Related posts:

1. Folksonomies — the good and the bad
2. Parallax: a better interface for Freebase
3. Fill out your Web Browser brackets: IE8, Chrome, Safari
4. NOSQL: distributed key-value data stores
5. 3scale provides infrastructure of the programmable web