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 _______________________________________________ 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
