MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




noob help with counties

This is a discussion on noob help with counties within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; How do you get it to show the counties in the state view. I can see them at a multi ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read



Click here to register

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 03-18-2005
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
noob help with counties

How do you get it to show the counties in the state view.
I can see them at a multi county level but when I zoom out to print the territories at a state level they do not show.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 03-24-2005
Junior Member
White Belt
 
Join Date: Mar 2005
Posts: 3
There may be an easier way, but this works and took about ten minutes. The technique involves using MapPoint's built-in demographic data to export counties to Excel, then importing the counties back into MapPoint as custom territories. Here are the steps in MapPoint 2004:

1. Select Data/Data Mapping Wizard... from the MapPoint main menu
2. On the "Data Mapping Wizard-Map Type" dialog box, click on the "Next>" button
3. On the "Data Mapping Wizard-Data Set" dialog box, click on the "Next>" button
4. On the "Data Mapping Wizard-Data Fields" dialog box, select "County" in the "Show the day by" list and then click on the "Finish" button
5. Using one of the drawing tools, surround the region for which you want counties on the map
6. Select the Data/Export to Excel menu options

7. In Excel, clean up the data with the following quick steps:
- Delete the MapPoint worksheet as you do not need it
- Delete the column containing the "Area in Square Miles by County" as you do not need it
- Delete the "Set0" named range (simplifies import step later)
- Sort the data by State and then delete any extra counties (if there are any)
- Copy the entire County column and create a new column with the same data. The column heading should be Territory
- Save the file

8. Back in MapPoint, select the Data/Territories… menu options
9. On the "Create Territories Wizard-Method" dialog box, click on the "Next>" button
10. On the "Create Territories Wizard-Import or Link" dialog box, click on the "Next>" button
11. Select the Excel file containing the county data and click on the "Open" button.
12. On the "Import Territories Wizard" dialog box, click on the "Finish" button

You now have a set of territories corresponding to the counties of the selected region.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
counties, noob


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Sharing Counties, Map Layers, Possible? jlssa MapPoint 2006/2009 Discussion 1 06-20-2005 10:56 AM
Manual Placements and Counties wadams MapPoint 2006/2009 Discussion 2 05-12-2005 01:52 PM
show ONLY the counties in my territory eieio59 MapPoint 2006/2009 Discussion 1 08-24-2004 09:37 PM
TEXT WITHIN COUNTIES Anonymous MapPoint 2006/2009 Discussion 0 07-09-2004 01:54 PM
Clickable counties (polygons) najones MapPoint 2006/2009 Discussion 0 12-01-2003 05:52 PM


All times are GMT -5. The time now is 07:45 PM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
MP2K Magazine
Visitor Map


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