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
    Posts
    1

    Heat Mapping

    Hi,

    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!

    Thanks

    Jack

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

    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.
    Regards
    Paul

  3. #3
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    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.

    http://www.mapforums.com/images/arti...SectorData.zip

    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.

    Eric
    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
    Posts
    20

    Re: Heat Mapping

    Jack

    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.

    Kirsten

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