@roitsch asked how "Tweeting Places" is built. The first post of this blog is a good place to give a credit to the tools used for the first version.
The application runs on Google App Engine. Google Maps API is used to show the map. In addition, a few other JavaScript libraries are in play. jQuery provides visual effects and handles AJAX requests, except JSONP request to Twitter API, where jQuery-JSONP plugin by Julian Aubourg helps. To generate clusters of locations MarkerClusterer library by Xiaoxi Wu from a collection of utilities enhancing Google Maps, GMaps Utility Library, is used. Finally, some parts of twitterjs by Remy Sharp handle responses from Twitter API.
A few more posts are in drafts. There we will discuss the license for the collected data (it will be CC-by), features that will be introduced, such as zooming to location determined from the visitor's IP, and other things.
Stay tuned and follow us at twitter @tweetingplaces.