I wrote earlier about various efforts to map community data in a visually accessible form (they are called mashups or video mashups).
Another recent addition is Oakland Crimespotting. [Another prior example by the same design firm lets one watch San Francisco cabs traverse the city (cabspotting) -- a bit like watching the elevators to see which is on what floor, except that you have no guarantee that the cabs will stop for you.]
