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 ATB, Matthew [2] 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] 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
