Mapping tools for charities

On 14th November the UK’s first Data for Good conference took place in Birmingham and I gave a ‘quick intro’ session to mapping tools for civil society organisations. I ran through 3 examples, and thought it may be useful to provide links to the data sets and the tools. All 3 are free for the most part and require no coding and little previous GIS experience.

Google My Maps

Google My Maps is entirely free and part of the Google suite of tools. It’s fairly basic but does a great job of showing point locations and boundaries. It can be easily customised and embedded on a website using an iframe.

To demonstrate this, I showed how we can plot the location of community centres in Oxford.

OxfordCommunityCentres

The layer I imported was from Oxford City Council’s Open Data portal. If you use this dataset, you just need to split the addresses from the coordinates before uploading it. Local authorities often have a data hub/portal, with locally relevant datasets.

You can style the icons using the paint roller symbol on the left.

Google My Maps is also useful for displaying polygons, such as the boundaries of CCG’s in England. These files have to be KML format. You can get this (and lots more) from the data.gov.uk portal.

CCG boundaries

The map can be shared with colleagues or it can easily be embedded on your website, like West London Zone have, and any updates you make to the map in Google My Maps will carry through to the embedded map.

ArcGIS Online

ArcGIS Online is ESRI’s webmapping platform. ESRI once dominated the GIS scene, and while I much prefer the open-source QGIS for desktop mapping,  ArcGIS Online is really intuitive and produces great visualizations. It is similar to Google My Maps in simplicity, but gives the user more choice. The public account is free, but you should note that to save your map you must agree to it being publicly available.

To demonstrate ArcGIS Online, I looked at the prevelance of loneliness among over 65’s in Wigan, against local charities that work in this domain.

wiganloneliness.png

The most common vector format is a Shapefile (which actually contains several files). More info here. Wigan Council have shared data on loneliness among 65+ year olds by LSOA on their open data portal. To download Charity Commission data, NCVO and David Kane have developed a help guide.

You can visualise data as a choropleth (like above) in ArcGIS online, or as a heatmap. You can also create a slideshow with interactive maps. More information on styling your map.

QGIS

The third tool is QGIS. QGIS is a powerful desktop programme, that is free and open-source, meaning there are over 550 great plugins, including QGIS2Web, which outputs the files you need for a webmap. If you know any SQL, then you’ll love the query builder. There are plenty of tutorials and QGIS offers much more functionality than the webmapping tools displayed above.

To demonstrate QGIS, we can explore in which wards in Birmingham do Somalian diaspora live, according to the 2011 census. Birmingham City Council are moving to a neighbourhood approach to social care, so if our organisation worked with Somali speakers, we would want to be sure to target our efforts in the right neighbourhoods. Data that goes beyond anecdotal evidence is useful for this.

To start with, we can download the census data from the Consumer Data Research Centre (CDRC). CDRC have lots of useful maps and datasets that are free to download. You can also overlay KML or GeoJSON files on to the CDRC maps.

cdrc.png

Next we want the boundaries for census output areas and the wards across Birmingham. These can be downloaded in Shapefile format from the ONS’s Open Geography Portal and data.gov.uk

The 2 Shapefiles are loaded as vector layers, and the census data as delimited text (no geometry, attribute only). We then need to join the census data and the census output areas using the shared output area code, shown below. Join.png

The data can then be styled and labels added. The final output is a map which clearly shows in which wards in Birmingham we should focus our efforts.

somaliansinbham

Using the QGIS2Web plugin, you can upload your map to a webserver using either  OpenLayers or Leaflet. The plugin neatly packages up the code, leaving you with one .html file that displays the map. In lieu of my own server, I’ve used Amazon’s Web Services to host a map (which is free).

leaflet

Final thoughts…

  • Lots of the organisations I’ve come across have partnered with volunteers, universities or for-profit businesses to undertake geospatial work – you don’t always need to have the skills in-house.
  • You may already hold geospatial data…you just don’t think of it as such! Alot of data will have a postcode attached which you can easily map. Of course, be wary of sensitive data and GDPR processing rules, you can often aggregate data if this is an issue.
  • For those interested in spatial statistics, GeoDa is a great and relatively straightforward package. If you’re interested in making use of R and RStudio for geospatial analysis, here’s a good intro, alongside An introduction to R for Spatial Analysis and Mapping by Brunsdon and Comber.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s