Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 4 of 4

Heat Mapping

This is a discussion on Heat Mapping within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi, I have just started using mappoint in the last week (2013 UK/Europe) and I am loving how easy it ...

  1. #1
    Jack Young is offline Junior Member White Belt
    Join Date
    Feb 2013

    Heat Mapping


    I have just started using mappoint in the last week (2013 UK/Europe) and I am loving how easy it is to produce data maps! I have a question though, which make may more send if I explain what I am trying to do:

    I work for a recruitment company and I am trying to produce a heatmap of where our candidates are located. I have an excel file with all of our candidate postcodes in one column and another column with the number 1 in (Mappoint wouldn't let me produce a map without a column of values). I use the data mapping wizard with shaded area selected, and pick continuous range for the colour scheme. I have set my regions to show candidate numbers by postcode.

    Now my question is..... Does the shade of colour represent the total number of candidates within that region or their density? For example, Manchester is a similar colour to Birmingham, does that mean they have the same number of candidates, or does Birmingham have more overall because it is a larger area? I would prefer it to be the latter!



  2. #2
    lucassen is offline Junior Member Yellow Belt
    Join Date
    Mar 2009
    Rotterdam, The Netherlands

    Re: Heat Mapping

    Hi Jack, the colors should reflect the weight (read number of candidates in this case) per selected postcode area. If you have 1 candidate in every single postcode, obviously all you will see is a map with colors without any meaning. Solution would be to use Postcode Area or District or Sector , i.e. AB10, so you include more postcodes in the area and subsequently you will see this reflected in the shaded colors. Try importing your pushpins first and you will see where they are on the map, you can add a second layer of shaded colors.

  3. #3
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Blog Entries

    Re: Heat Mapping

    I played around with this some, see posts below. MapPoint will do some aggregation for you in the Import Data Wizard, see the final screenshot below.

    First, here's the data I put together.


    This is postcode sectors north of downtown London, or maybe it's the northern part of downtown London. In any case, I repeated several of the rows lots of times.

    Thus when imported as Pushpins, there are several postcode sectors with multiple pushpins on top of each other.

    When I changed the map type to Shaded area and mapped at the Postcode Area level, you can see the shading showing the frequency.

    This is the Import Data Wizard screen where you can set the geography level you to which you want to aggregate.

    The same should work to aggregate the full postcodes up to postcode sector, but I didn't have full postcode data handy to work with.

    Hope this helps and let us know how it goes and if we can be of any more help.

    Last edited by Eric Frost; 02-08-2013 at 11:14 AM.
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  4. #4
    Kirsten Tisdale is offline Junior Member Yellow Belt
    Join Date
    Aug 2009

    Re: Heat Mapping


    If you use eg postcode areas for your shading, you can also divide out by the demographic data that is in MapPoint - see the dropdown right in the middle of Eric's screenshot of the Data Mapping Wizard. So you can divide out by, for example, sqkm or by population. If you're going to use this for presentation rather than just your own investigation, it can pay to prep your data first, so that you end up with "Candidates per 1000 Members" of the population, say - otherwise you end up with some long decimals in your legend! However, also see the post I'm about to do on UK counties in 2013.


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Creating a heat map
    By sward0 in forum Tips and Tricks
    Replies: 6
    Last Post: 12-06-2013, 08:25 AM
  2. Limited Heat Map?
    By tlindeman in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 08-21-2012, 07:25 AM
  3. Heat Mapping on Territory Map
    By Boogle in forum Tips and Tricks
    Replies: 2
    Last Post: 06-25-2011, 07:46 PM
  4. Replies: 0
    Last Post: 06-09-2011, 10:30 AM
  5. Thematic Mapping and Heat Maps with Virtual Earth
    By VirtualEarth MSDN Blog in forum Bing Maps Blogs & Tweets
    Replies: 0
    Last Post: 12-02-2008, 03:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125