That's what Stweet, a fun mashup of Google Street View and Twitter, attempts to do. In an imperfect way, it takes the co-ordinates posted by some Twitter apps, like TwitterFon (location must be enabled), and uses that data to find the approximate street address the Tweet came from. It then overlays the Tweet on a Google Street View image.
If you'd like to test it out, the best city by far is San Francisco, with a high volume of Tweets. A dropdown menu lets you browse various US cities, and you can see if there are Tweets from countries not listed by changing the end of the URL to "city,country". For instance, this is the URL for Tweets in London, UK.
Is it any use? Perhaps not, but it sure is an interesting distraction, and raises the question: do I want the world to know what street I'm on?