I work with a dataset that gathers stats from all across a city. Each datapoint is of interest and worth visualising to our users, but there are a few parts of the city that significantly deviate from the average into hostspot clusters.

For example many wards throughout the city would have a value of [0-5] for any given month but one particular ward might be [300-400+]. Additionally there's not much mid range.

I'm trying to think about clever ways of visualising this that demonstrate both the data and it's month-by-month changes for most wards throughout the city, but also clearly demonstrate how much of an outlier particular wards can be.

I've tried:

  • Heatmaps - Radius needs to be set to a narrow zone to prevent spill over small boundaries, but due to the massive deviation of our outliers I end up with very pale, widely distributed wards across the city and then one tight dark blotch in the middle. It looks like a pitri dish and isn't very effective. Increasing the radius improves readability but means that datapoints now spill over ward/borough lines.

  • Choropleth - Much more visually appealing but again in a single swatch of colours (yellow for our [0-5]'s and dark red for our [300+]) I think it's still difficult to demonstrate the magnitude of the skew. My mind draws a linear line between each colour step.

Really I need a good idea for geographically representing data on a Logarithmic scale when I have a massive deviation in my data. Additionally data for the mode is quite low significance (0-5) and so is subject to a high variability...

Really struggling to think about how best to plot this. Perhaps the answer not to try and instead break it into separate graphs demonstrating each aspect (skew, significance of mode and peaks?).

Has anyone tried mapping a dataset like this before?

  • What mapping applications do you have available? – artwork21 Nov 22 '16 at 14:27
  • @artwork21 ah good point, QGIS, R or anything I can write to output via Ruby (so... d3 etc) – Huw Nov 28 '16 at 11:54
  • @Mapperz can I get this re-opened? All visualisations are weighted to solve a specific problem, I think I've been specific about the problem I'm having and from the discreet number of visualisation options am asking for references/prior art/experience of other mapping members. I can't see why that's overly opinion based? – Huw Nov 28 '16 at 11:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.