visualising advocacy #enc2011 @bethgranter & @stevewinton
TRANSCRIPT
![Page 1: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/1.jpg)
Visualising advocacy#enc2011@BethGranter & @SteveWinton
![Page 2: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/2.jpg)
HELLO! :)We’re:
@bethgranter and
@steveWINton
from NixonMcInnes, a social business consultancy.
![Page 3: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/3.jpg)
Our clients
![Page 4: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/4.jpg)
Applied technology
![Page 5: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/5.jpg)
Basically,
We ♥ data :)
![Page 6: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/6.jpg)
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
![Page 7: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/7.jpg)
Why visualise advocacy?
![Page 8: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/8.jpg)
Why visualise advocacy?
![Page 9: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/9.jpg)
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
![Page 10: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/10.jpg)
Mapping advocacy: recipe 1
• Take 1 e-activist data feed (EaEmailAOTarget)
![Page 11: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/11.jpg)
Mapping advocacy: Recipe 1• Take 1 advocacy online data feed
(EaEmailAOTarget)
![Page 12: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/12.jpg)
Mapping advocacy: recipe 1
• Make a CSV!
![Page 13: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/13.jpg)
Mapping advocacy: Recipe 1
• Make a CSV!
![Page 14: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/14.jpg)
Mapping advocacy: recipe 1
• Geocode!(the process of getting co-ordinates for an address)
![Page 15: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/15.jpg)
Mapping advocacy: Recipe 1
• Geocode!(the process of getting co-ordinates for an address)
http://www.google.com/fusiontables/
![Page 16: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/16.jpg)
Mapping advocacy: recipe 1
• Visualise!(putting the co-ordinates on a map)
![Page 17: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/17.jpg)
Mapping advocacy: Recipe 1
• Visualise!(putting the co-ordinates on a map)
http://www.google.com/fusiontables/
![Page 18: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/18.jpg)
But,
What about privacy?! :(
![Page 19: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/19.jpg)
Mapping advocacy: recipe 2
IDEA!
Group advocates by constituency!
![Page 20: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/20.jpg)
Mapping advocacy: Recipe 2
• Group advocates by constituency!
Mapping each postcode to a constituency is straightforward, thanks to...
![Page 21: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/21.jpg)
http://code.google.com/p/google-refine/
And we can work in Google Refine...
(not for the faint-hearted!)
![Page 22: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/22.jpg)
Using Google Refine, we can grab constituency data from our postcodes
![Page 23: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/23.jpg)
Mapping advocacy: Recipe 2
• Group advocates by constituency!
Grabbing geography for each constituency is also straightforward, thanks to...
![Page 24: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/24.jpg)
Mapping advocacy: Recipe 2
• Group advocates by constituency!
Or, here’s one we made earlier...
http://j.mp/uk-constituencies
![Page 25: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/25.jpg)
Mapping advocacy: Recipe 2
• Group advocates by constituency!
Join the 2 sets of data in a spreadsheet...
![Page 26: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/26.jpg)
Mapping advocacy: Recipe 2
• Group advocates by constituency!
Visualise! Again, using Google Fusion Tables...
![Page 27: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/27.jpg)
But,
It’s a bit messy?! :(
![Page 28: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/28.jpg)
Mapping advocacy: recipe 3IDEA!
Group by different geographic areas, based on zoom level!
![Page 29: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/29.jpg)
Mapping advocacy: Recipe 2
• Group advocates by constituency!
So... We need county/region + lat/lon for each constituency? OK...
http://j.mp/uk-constituencies
![Page 30: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/30.jpg)
Mapping advocacy: Recipe 2
• Group advocates by constituency!
Here’s one we made earlier...
![Page 31: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/31.jpg)
Cool!But...
How can we show the impact?! :(
![Page 32: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/32.jpg)
Mapping advocacy: recipe 4
IDEA!
Showing MP support for a campaign – intentions to vote or how they voted
![Page 33: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/33.jpg)
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
![Page 34: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/34.jpg)
Mapping advocacy: Recipe 2
• Group advocates by constituency!
Remember this...?
http://j.mp/uk-constituencies
![Page 35: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/35.jpg)
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
![Page 36: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/36.jpg)
![Page 37: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/37.jpg)
![Page 38: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/38.jpg)
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
![Page 39: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/39.jpg)
V. cool!But...
Can we make advocacy hotspots easier to… spot?:)
![Page 40: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/40.jpg)
Mapping advocacy: Recipe 2
• Group advocates by constituency!
Of course! Enter the choropleth*...
*http://en.wikipedia.org/wiki/Choropleth
http://j.mp/uk-constituencies-svg
![Page 41: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/41.jpg)
Mapping advocacy: Recipe 2
• Group advocates by constituency!
Immediately, we can see the ‘hotspots’...
Here!
Here!
Not here!
http://j.mp/uk-constituencies-choropleth
![Page 42: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/42.jpg)
Mapping advocacy: Recipe 2
• Group advocates by constituency!
LIVE: http://j.mp/visualising-advocacy
For added interactivity, turn to TileMill...
![Page 43: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/43.jpg)
Wow!But...
Can we make it update dynamically?!! :) :)
![Page 44: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/44.jpg)
Yes, we can!
We’ve built a tool that updates the map automatically...
![Page 45: Visualising advocacy #enc2011 @BethGranter & @SteveWinton](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e915503460f94b96d75/html5/thumbnails/45.jpg)
http://www.demandabetterbill.org.uk/