I finally finished a mash up using Placemaker to find locations in tweets. The results are then stored to be be queried on via a map or via a simple search box. This will enable to find what people write about specific locations.
There are two pages:
The first page http://www.geomojo.org/cgi-bin/map.cgi which contains a map with tweets makers where clicking on these markers prints the tweets associate to the locations. The markers are clustered using the following hierarchy Country, State, County, Locality.
The second page http://www.geomojo.org/cgi-bin/geotweets.cgi just contains a search box. Provide the location wanted and the tweets for this locations will be display.
