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

View by zip code

This is a discussion on View by zip code within the MapPoint Desktop Discussion forums, part of the Map Forums category; I would like to view the US map by its zip code regions. My goal is to show sales by ...

  1. #1
    John Swanick is offline Junior Member White Belt
    Join Date
    May 2005
    Posts
    1

    View by zip code

    I would like to view the US map by its zip code regions. My goal is to show sales by zip code where each zip code area is colored reflecting sales volume ranges. Can this be done with MapPoint?

    Thanks for your help

  2. #2
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    Yes you can. Set up a data file (Excel or Access are easiest although there are other options) with one row per zipcode, with a column for the zipcode and a column for your sales data.

    Then select Data -> Import Data Wizard on the menu. This should guide you through the import process.
    You will need to select Shaded Area and Zipcode.

    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  3. #3
    coppertop41 is offline Junior Member White Belt
    Join Date
    Jul 2005
    Posts
    4
    Quote Originally Posted by Winwaed
    Yes you can. Set up a data file (Excel or Access are easiest although there are other options) with one row per zipcode, with a column for the zipcode and a column for your sales data.

    Then select Data -> Import Data Wizard on the menu. This should guide you through the import process.
    You will need to select Shaded Area and Zipcode.

    Richard

    I am so new that is not even funny. Doing project at work. I am so frustrated. All I need for now is to map sales reps name, city/state and zipcode and I need to have different colors per sales rep. When I did what you suggested above zipcode wasn't offered in the "select the data field or column to map". Name and ID was all that was offered. I have some sales reps handling several states. So when it ties to the name of course it says that there are several names that are the same. Anyway. Sorry I went on and on I am just soooo frustrated and have been searching and just want to get this project done.
    thanks

  4. #4
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    What are you trying to do? Plot zipcodes using different color for each sales person?

    The territory option might be worth investigating.

    What form is your data? Is it in excel? If so, you'll need a column for the name, and a column for the zipcode.
    I suggest the first row in the spreadsheet has column headers "Name" and "Zipcode" which might help you when you have to select the data columns in the data import wizard.


    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  5. #5
    coppertop41 is offline Junior Member White Belt
    Join Date
    Jul 2005
    Posts
    4

    view by zipcode

    thank you so much for helping me. i am sorry i am a pain. i have ordered a book but.... well you know how deadlines are. this is how i have the spread sheet in excel setup. i have used several different ways of doing this data and calling the columns different things. when i import this data on the far left it shows the different colors on the names next to the sales reps but those colors are not showing up in the map. if i just knew how to put the different colors for each sales rep would be great. also i have some guys that have a portion of a state!!!!ugh.... thanks again
    name state Zipcode
    Candler VA 24578
    Farinella NY 11743
    Goodman NC 28270
    Heck NJ 08054
    Kirk SC 29205
    Lipchak PA 15017
    Lydon MA 02081
    Saylor FL 33486
    Schaefer GA 30066
    Taylor FL 33594
    Weeks FL 32413
    Yazujian NJ 08822

  6. #6
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    I've managed to do it

    I cut and pasted your data into a text file and inserted some commas.
    An Excel spreadsheet would definitely be easier if you have it like that.
    I assume that you also have a lot more data? What I get is pretty sparse - a handful of zipcodes spread across the country.

    When you do the Data Import Wizard, it should detect three columns: name, state, zipcode.
    When I did it, MapPoint only automatically auto-detects the State.
    Select "Other Data" for the name.
    Select "Zipcode" in the combobox for the zipcode column. It should autodetect this, but you have some 4-digit zipcodes which is confusing MapPoint. You may want to pad with zeros if Excel will let you.

    Select Shaded Area.

    Then select "F1" as the data field or column to map.
    And Show the Data by "ZIP Code".

    You will then get a warning message that you have more than 8 categories. Basically you can only use 8 colour shades in your map.


    Territory doesn't have this limit of 8. It works in a similar way, but you need to select the first column as "Territory Name" (default is "Skip Column"), and select the zipcode as the zipcode.

    The Help file should also help you out. I find it useful to print pages and then read them - I have yet to believe in EBooks
    The Dummies book (I assume it is the one you have on order) is probably a better introduction to MapPoint's abilities than the help, although it has its limitations if you want to advanced stuff like programming.



    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  7. #7
    coppertop41 is offline Junior Member White Belt
    Join Date
    Jul 2005
    Posts
    4

    zipcodes

    Thank you so much richard. I will go try that. I really appreciate all your help.

  8. #8
    coppertop41 is offline Junior Member White Belt
    Join Date
    Jul 2005
    Posts
    4

    view by zipcode

    Hi Richard. Thanks again for all your help. I tried to create an excel spreadsheet that had, State, County Territory and Zipcode. But everytime I add the zipcode as a column my map won't show the different colors for each state. I took the zipcode out and walla I got all kinds of pretty colors even when I had duplicate sales reps for different states. oh well. i am not sure how to do this yet. i am still waiting for the book. thanks again.

  9. #9
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    It sounds like you might be trying to plot two things at the same time?
    Eg. shaded zipcodes and shaded states?
    Clearly you can't do that
    (you could put pushpins or shaded spots on shaded states, but excluding pushpins you can't map two different things in the same way)

    You might be able to get shaded territories on top of shaded States, although I haven't tried that.


    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using VB6 to Link to SQL View
    By takk in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 12-08-2004, 11:51 PM
  2. Choosing what to view
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 12-04-2003, 04:46 AM
  3. 3D View
    By Anonymous in forum Wish List
    Replies: 0
    Last Post: 06-06-2003, 06:19 PM
  4. One country view only?
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 04-18-2003, 11:45 AM
  5. Print View
    By healthsouthgirl in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 08-14-2002, 10:03 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