460 likes | 562 Views
Learn the power of mapping advocacy to engage communities, track impact, and inspire action for social change. Discover tools, techniques, and case studies to visualize data effectively. Reach out to us for more information!
E N D
Visualising advocacy#enc2011 @BethGranter & @SteveWinton
HELLO! :) We’re: @bethgranter and @steveWINton from NixonMcInnes, a social business consultancy.
Why visualise advocacy? • Make people feel part of a movement • “I’m part of something big” • To motivate people to complete an action or pass it on
Why map advocacy? • Highlight areas where advocacy is high/low, which MPs have been targeted • “I can make a difference / I’m needed” • Reflect how local communities feel about issues • “This is relevant to me” • To further motivate people to complete an action or pass it on
Mapping advocacy: recipe 1 • Take 1 e-activist data feed (EaEmailAOTarget)
Mapping advocacy: Recipe 1 • Take 1 advocacy online data feed (EaEmailAOTarget)
Mapping advocacy: recipe 1 • Make a CSV!
Mapping advocacy: Recipe 1 • Make a CSV!
Mapping advocacy: recipe 1 • Geocode! (the process of getting co-ordinates for an address)
Mapping advocacy: Recipe 1 • Geocode! (the process of getting co-ordinates for an address) http://www.google.com/fusiontables/
Mapping advocacy: recipe 1 • Visualise! (putting the co-ordinates on a map)
Mapping advocacy: Recipe 1 • Visualise! (putting the co-ordinates on a map) • http://www.google.com/fusiontables/
Mapping advocacy: recipe 2 IDEA! Group advocates by constituency!
Mapping each postcode to a constituency is straightforward, thanks to... Mapping advocacy: Recipe 2 • Group advocates by constituency!
And we can work in Google Refine... (not for the faint-hearted!) http://code.google.com/p/google-refine/
Using Google Refine, we can grab constituency data from our postcodes
Grabbing geography for each constituency is also straightforward, thanks to... Mapping advocacy: Recipe 2 • Group advocates by constituency!
Or, here’s one we made earlier... Mapping advocacy: Recipe 2 • Group advocates by constituency! http://j.mp/uk-constituencies
Join the 2 sets of data in a spreadsheet... Mapping advocacy: Recipe 2 • Group advocates by constituency!
Visualise! Again, using Google Fusion Tables... Mapping advocacy: Recipe 2 • Group advocates by constituency!
Mapping advocacy: recipe 3 IDEA! Group by different geographic areas, based on zoom level!
So... We need county/region + lat/lon for each constituency? OK... Mapping advocacy: Recipe 2 • Group advocates by constituency! http://j.mp/uk-constituencies
Here’s one we made earlier... Mapping advocacy: Recipe 2 • Group advocates by constituency!
Mapping advocacy: recipe 4 IDEA! Showing MP support for a campaign – intentions to vote or how they voted
Mapping impact • Showing MP support for a campaign – intentions to vote or how they voted • Public Whip • Excel spreadsheet • Convert votes to numbers e.g. absent = -1, no = 0, aye = 1 • TheyWorkForYou API constitency geo data CSV • Google Fusion Tables • Vizualize > Map > Configure styles
Remember this...? Mapping advocacy: Recipe 2 • Group advocates by constituency! http://j.mp/uk-constituencies
Mapping impact • Showing MP support for a campaign – intentions to vote or how they voted • Public Whip • Excel spreadsheet • Convert votes to numbers e.g. absent = -1, no = 0, aye = 1 • TheyWorkForYou API constitency geo data CSV • Google Fusion Tables • Vizualize > Map > Configure styles
Mapping impact • Showing MP support for a campaign – intentions to vote or how they voted • Public Whip voting data • Convert votes to numerical code • e.g. absent = -1, no = 0, aye = 1 • TheyWorkForYou API constituency geo data CSV • Google Fusion Tables • Vizualize > Map > Configure styles by vote code
V. cool!But...Can we make advocacy hotspots easier to… spot?:)
Of course! Enter the choropleth*... Mapping advocacy: Recipe 2 • *http://en.wikipedia.org/wiki/Choropleth • Group advocates by constituency! • http://j.mp/uk-constituencies-svg
Immediately, we can see the ‘hotspots’... Mapping advocacy: Recipe 2 • Group advocates by constituency! Not here! Here! Here! • http://j.mp/uk-constituencies-choropleth
For added interactivity, turn to TileMill... Mapping advocacy: Recipe 2 • Group advocates by constituency! LIVE: http://j.mp/visualising-advocacy
Yes, we can!We’ve built a tool that updates the map automatically...
Thanks! Questions? • beth.granter@nixonmcinnes.co.uk@bethgranter • steve.winton@nixonmcinnes.co.uk@steveWINton