Added every other minute
N miles radius of center city coordinates
Pull next 100 from last stored tweet
After N seconds * 20 (all initially queued tweets are displayed), ajax call to pull next 20.
Queued effect gives feel of real-time updating while allowing some caching and a fuller experience in smaller, less popular areas (less tweeting).
Tweets stored indefinitely
Username stored with each tweet, can create related tables later to pull more information for more relations between tweets and their locations / content.
Extended Venue Information
Service sees few updates and small community. Assuming that most data is acquired via aggregation instead of user submission.
Most complete local music data
Also, hardest to acquire (no structured syndication and no API)
First phase builds interest
Second phase builds value
Ex: Tweets that mention Charlotte the name instead of Charlotte the city.
Ex: Tweets that relate to an already-mentioned (and mapped) event.
Simple RSS submission