460 likes | 549 Views
Visualising advocacy #enc2011 @ BethGranter & @ SteveWinton. HELLO! :). We’re: @bethgranter and @steveWINton from NixonMcInnes, a social business consultancy. Our clients. Applied technology. Basically, We ♥ data :). Why visualise advocacy?. Make people feel part of a movement
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