Anna, Andrew, Pete and Matthew - Brilliant! Thank-you so much for
emailing the list with the suggestions re.mapping the health stats from
http://www.phoutcomes.info. This is really helpful; it all seems so
daunting without a little direction. As has been said many times before
- the first step of any journey is often the most difficult.
All the best, Andrew
On 11/24/2012 04:45 PM, Anna Powell-Smith wrote:
Hooray, nice one Matthew.
On 24 Nov 2012 16:09, "Matthew Somerville" <[email protected]
<mailto:[email protected]>> wrote:
On 24 Nov 2012, at 13:43, Anna Powell-Smith wrote:
> I have got the data for all English regions from the PH site -
here it
> is, cleaned up a bit [3]. However, it doesn't merge nicely with this
> Guardian table.
That's because the Guardian table [2] has district councils,
whilst the PH data [3] uses county councils. If you use the County
Council boundaries from the Guardian's
https://www.google.com/fusiontables/DataSource?dsrcid=1668120
(can't merge, as that one doesn't have ONS codes annoyingly), and
download CSV/reimport to allow you to actually edit the KML
column, then you end up with:
https://www.google.com/fusiontables/embedviz?viz=MAP&q=select+col4+from+1GEfB61IonI1xmKl6N7r0J-QDljxeeGOkCLpYaBU&h=false&lat=53.698808088700666&lng=1.8269385273438132&z=6&t=1&l=col4&y=1&tmplt=1
<https://www.google.com/fusiontables/embedviz?viz=MAP&q=select+col4+from+1GEfB61IonI1xmKl6N7r0J-QDljxeeGOkCLpYaBU&h=false&lat=53.698808088700666&lng=1.8269385273438132&z=6&t=1&l=col4&y=1&tmplt=1>
ATB,
Matthew
[2]
https://www.google.com/fusiontables/DataSource?classic=true&docid=1NXSj_1Jx-wNf-GVo-KgPQeHANZ-Z35SYF-kNb08
<https://www.google.com/fusiontables/DataSource?classic=true&docid=1NXSj_1Jx-wNf-GVo-KgPQeHANZ-Z35SYF-kNb08>
[3]
https://www.google.com/fusiontables/DataSource?docid=1Myq0Z9aYRw-SXgkDSo25sJORBGKki5z0U93pVqk
_______________________________________________
developers-public mailing list
[email protected]
<mailto:[email protected]>
https://secure.mysociety.org/admin/lists/mailman/listinfo/developers-public
Unsubscribe:
https://secure.mysociety.org/admin/lists/mailman/options/developers-public/annapowellsmith%40gmail.com
_______________________________________________
developers-public mailing list
[email protected]
https://secure.mysociety.org/admin/lists/mailman/listinfo/developers-public
Unsubscribe:
https://secure.mysociety.org/admin/lists/mailman/options/developers-public/andrew%40gn.apc.org
_______________________________________________
developers-public mailing list
[email protected]
https://secure.mysociety.org/admin/lists/mailman/listinfo/developers-public
Unsubscribe:
https://secure.mysociety.org/admin/lists/mailman/options/developers-public/archive%40mail-archive.com
