Oh, and there's also http://www.openheatmap.com/ if you want to use OpenStreetMap, although again you'll need to fiddle with the ONS codes before it will display properly.
On 24 November 2012 13:43, Anna Powell-Smith <[email protected]> wrote: > Hi Andrew > > Probably the easiest way to do this is with Google Fusion Tables - the > same way the Guardian Datablog do all their maps [1]. > > You'll need to do the following: > > * grab the data for all regions from the PH site into a spreadsheet > * get KML geographic outlines for each council name (this is the fiddly bit) > * upload it to a Fusion Table > * use Fusion Table options to visualise it on a map, and set colours > for each region. > > You can then embed the Fusion Table anywhere you like. > > I've done London for you here, so you can see it works in principle: > https://www.google.com/fusiontables/DataSource?snapid=S785319dwY7 > > To get the KML for this, I uploaded the London data to Fusion Tables, > then merged it with the Guardian-owned Fusion Table behind the wages > map [2]. > > 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. So you'll need to get the KML from somewhere else, > probably Mapit. Do you feel confident doing this? > > Best wishes > Anna > > [1] For example: > http://www.guardian.co.uk/news/datablog/interactive/2012/nov/22/wages-map-britain > [2] Guardian table used to produce wages map: > https://www.google.com/fusiontables/DataSource?classic=true&docid=1NXSj_1Jx-wNf-GVo-KgPQeHANZ-Z35SYF-kNb08 > [3] PH data for all England: > https://www.google.com/fusiontables/DataSource?docid=1Myq0Z9aYRw-SXgkDSo25sJORBGKki5z0U93pVqk > > On 24 November 2012 13:02, Andrew Bailey <[email protected]> wrote: >> Andrew, >> >> I'd look at the list of open source GIS software at FOSS4G. I haven't >> had a chance to look at the sites you mention but I can give you some >> pointers... >> >> For producing a map that appears on the web you'll need a map library >> (Leaflet or Openlayers), some data of interest and some background >> mapping. The background mapping can be openstreetmap, google maps or >> bing for example. The data of interest will be a combination of >> attribute tabular data and the geometries. KML might be a reasonable >> data format for you. To get the data into a GIS state you'll probably >> need a desktop GIS and QGIS is pretty popular for that. You'll have to >> make sure the data you produce is the spherical mercator projection used >> by OSM, Google Maps. EPSG:3857 is the projection identifier and QGIS >> will be able to handle the projection transformation. Take a look at the >> FWTools installation of QGIS as that also installs OGR/GDAL - useful for >> your transformations. >> >> Sorry that's a bit rushed. Drop me a pm if you need more advice. I >> should mention there's sites (geocommons.org i think is one) where >> they'll take your attribute data and with a commonly-known column such >> as a postcode zipcode, country name they'll convert into a map for you. >> >> Andy B >> >> On Fri, Nov 23, 2012, at 06:07 PM, Andrew Wood wrote: >>> Dear all, >>> >>> Recently, I came across this fantastic source of information about >>> public health from the UK Government (called Public Health Outcomes >>> Framework: http://www.phoutcomes.info) >>> >>> Separately, I also notice this shaded map giving a pictorial >>> representation for one of the indicators of health re. mental health: at >>> this site http://www.nepho.org.uk/cmhp/ >>> >>> Is there a simple way to take the data from the >>> http://www.phoutcomes.info site and then for any of the health >>> indicators to produce a shaded map as shown for mental health above? >>> (Incidentally, I'm most interested in air quality/air pollution shown at >>> http://www.phoutcomes.info/public-health-outcomes-framework/domain/4 as >>> '3.01 - Fraction of mortality attributable to particulate air pollution') >>> >>> I can't see this option of pictorial map representation on the >>> http://www.phoutcomes.info site. Still, really great resource! Any >>> suggestions? >>> >>> Thanks, >>> >>> Andrew Wood >>> http://www.cleanairuk.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/andy%40planetnomad.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/annapowellsmith%40gmail.com > > > > -- > 07812 357037 -- 07812 357037 _______________________________________________ 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
