One of the most interesting systems I ever created was a Grassroots supporter database that:
- combined multiple lists of donors, supporters, email subscribers and action alert subscribers
- ran all addresses through Google Maps to show hot spots of support at state levels
- obtained GIS coordinates via Google Maps API and ran them through Sunlight Foundation’s API to discover which state legislators represented the largest number of supporters and donors (where do we have leverage?)
The Grassroots supporter database helped the organization know which legislators they could most powerfully lobby via a larger number of supporters in their districts.
Here is a view of support across Virginia: