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

Zip Code Counts to Territories

This is a discussion on Zip Code Counts to Territories within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have about 40,000 zip code entries in my database, which have been sorted by zip code, and I have ...

  1. #1
    RogerMcc is offline Junior Member White Belt
    Join Date
    Oct 2002
    Posts
    2

    Zip Code Counts to Territories

    I have about 40,000 zip code entries in my database, which have been sorted by zip code, and I have a count for the number of entries for each zip code. This is in an Excel File with a column for the zip code, and another column with the number of times that zip code appears in my database.

    I have manually created territories in MapPoint 2002. I want to import the zip codes and the counts, and generate a shaded map for the territories that I have created.

    Is this possible, and if it is how do I accomplish it?

    Thanks in advance,

  2. #2
    John Meyer's Avatar
    John Meyer is offline Senior Member Blue Belt
    Join Date
    Jul 2002
    Posts
    478
    In the create territory wizzard if you chose "create manually" go back and try "create from you own set of data"

  3. #3
    RogerMcc is offline Junior Member White Belt
    Join Date
    Oct 2002
    Posts
    2
    Thanks for the suggestion, but I don't think it will help. The problem is that the territories are defined only in MP2K, and the Zip Codes exist in Excell without the corresponding territories. When I import the Zip Codes into MP2K, they get assigned to the correct territories, but appear only as push-pins. I'd like to shade each territory by the number of push pins, or even better, the count for each Zip Code.

    Suggestions???

    Thanks in advance,

    Roger McClelland

  4. #4
    John Meyer's Avatar
    John Meyer is offline Senior Member Blue Belt
    Join Date
    Jul 2002
    Posts
    478
    Roger,

    I thought I would list the steps in case others reading this thread that have never tried this would be able to recreate the steps.

    I think this is what you are trying to do?? I could be wrong.

    I created a excel file. One column called ZIP and one called Data
    I inserted 2 rows consisting of 2 different zip codes. For the data I put 1 in the first row and 2 in the second row.

    ////////////////////
    ZIP Data
    21061 1
    21144 2
    ///////////////////

    Start the Data Mapping Wizard
    Choose Shaded Area
    Click Next
    Select Import Data To Map It
    Click Next
    (Brings up the open file dialog)
    Choose you excel file
    Choose sheet 1
    click next

    The next screen has allot of info but make sure the column headings show ZIP and Data. Data type "ZIP" for the zip column and "other data" for the Data

    There is also an information icon with text that reads "Matching records to: Zip code. Country/Region: United States

    Click Next

    There should only be one choice in the "Select the data field or column to map (it will be "data")

    Show the data by: should be ZIP Code

    Click Next

    I did not change anything on this screen but the number of ranges is 2

    click finish

    Mappoint will zoom in to the 2 zip codes. 21061 will be shaded white and 21144 will be shaded green.

    Hope this helps

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple Territories Assocaited with a zip Code???
    By lane in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 05-15-2006, 09:59 AM
  2. how to add postal code to territories for an excel export ?
    By nat in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 05-25-2005, 06:23 AM
  3. MapPoint 2004-Create Territories Using Full Cdn Postal Code
    By wkcarreg in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-30-2004, 11:46 AM
  4. Showing ZIP code divisions for territories programmatically
    By Fer in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 09-10-2003, 06:51 PM
  5. Counts By Zip Code
    By Jim Grace in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 12-09-2002, 04:44 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