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 6 of 6

Finding populations

This is a discussion on Finding populations within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have several maps broken out by a certain territory comprising of counties. How can I find the population of ...

  1. #1
    donnagreek is offline Junior Member White Belt
    Join Date
    Sep 2007

    Finding populations

    I have several maps broken out by a certain territory comprising of counties. How can I find the population of that territory?

  2. #2
    dja3 is offline Junior Member White Belt
    Join Date
    Aug 2008
    Blog Entries

    Re: Finding populations

    I have the same issue. I have created sales territories by 3 digit zip codes and need to have the poulation shown for each territory. Can anyone let me know if MapPoint 2009 offers this capability?

  3. #3
    Paul Larson is offline Senior Member Green Belt
    Join Date
    Sep 2005
    Battle Creek, Michigan

    Arrow Re: Finding populations

    There's no easy way to do it, really. But it can be done.

    Using the method QueryAllRecords, you can determine which counties (or zip3 areas) are contained in each of the territories in the territory dataset.

    Once you know the sub-geographies in the given territory, you can query and aggregate the populations (or other demographic data) for each sub-geography.

    You could also hover the mouse over each sub-geography in a territory and manually add up a demographic from the displayed text.

    I've attached a document which illustrates the latter procedure.

    Attached Files Attached Files

  4. #4
    timetex is offline Junior Member White Belt
    Join Date
    Feb 2009

    Re: Finding populations

    Sorry to dredge up this old thread, but it is exactly my query too... and I find it very hard to believe that it isn't possible to achieve this!

    What do Microsoft think is the point of 'Territories', and being able to map them, if we cannot aggregate the demographic data which is provided, to get a proper picture of what the territory contains?

    Does anyone know if there is an add-in (free or paid-for) which can be used to do this?

    My primary uses for MapPoint are to:

    1) get a geographical map of current customers.
    2) design and plan franchise territories.

    MapPoint2009 does the former with absolute ease. No problem whatsoever.

    For territories, it is also easy to assign them etc. No problems there. But I actually want to PLAN my territories so they are balanced, using certain pieces of demographic data (households etc). I find it very hard to believe that, having included all the demographic data based on Postcode Area, District and Sector, that MapPoint doesn't allow you to aggregate this data when you have a territory which spans multiple Postcode Districts (for example).

    I could see that it would create awful problems if someone mapped territories which only contained part of a Postcode District... but when the planned territories contain ONLY complete Postcode Districts, it is surely only a few lines of code to enable MapPoint to show the demographic data for the territory itself.

  5. #5
    davidb is offline Senior Member Blue Belt
    Join Date
    Oct 2003

    Re: Finding populations

    Based on my experience there are a number of things you can do.
    1. Use the freeform tool to hand draw polygons for each of your territory boundaries. Tortuous but effective, especially if the territories donít change too often. You can then import all or any of the polygons as required and use export to excel on demographics or customers etc, or develop code to query the polygons.
    2. Itís possible to set up the demographics independent of MP in an excel workbook. Then you can Ďexport to excelí your territory definitions, assign demographic counts to each of the postcode districts and sum these to give your totals by territory (in my case this is done using excel vba). Involves a bit of cut and paste but is quite quick and painless. Also handling territories visually in excel is often helpful in things like equalising population and household totals, and redefined territories can be seamlessly loaded back into MP. Also if your customers have valid postcodes it would be straightforward to aggregate customer numbers, customer spend etc by territory. Anyway if youíd like to see some very rudimentary code and how this works then pm me your e-mail and Iíll dig some out for you
    3. As above but using Access and Access vba to allow a more refined and wide-ranging approach, eg. linking to updated official UK population estimates. As with the above, much of the data manipulation work is effectively outside of MP.

    There are probably even better solutions using sophisticated programming, but thatís beyond me at present!
    UK mapping and map analysis services at www.broomanalysis.plus.com

  6. #6
    MC Equities is offline Junior Member White Belt
    Join Date
    Feb 2009

    Re: Finding populations

    I usually look at populations by census tract. It is the smallest territory the census measures. I then draw a radius and export to excel. The table includes population for all census tracts included in or touched by the radius. Is there a better way to do this?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Finding USA Data
    By everblader in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-19-2005, 01:41 PM
  2. finding locations
    By SimonPearse in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 09-23-2004, 09:56 AM
  3. Finding a country or a city
    By wintermute in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 12-09-2003, 07:16 AM
  4. Finding closest 10 locations
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 11-19-2003, 05:59 AM
  5. finding a pushpin from a .dll
    By blackmap in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-10-2003, 03:11 PM

Tags for this Thread

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 126 127