PDA

View Full Version : new to MapPoint with lots of questions



smileygirlkim
01-15-2009, 01:28 PM
Hi! I just started using MapPoint and am trying to map out some information for my CEO. He wants to map my credit union's 92,000+ members on a map but wants to see pushpins to show how many members live in each area. I added the members with each member having a pushpin representing the member but of course the map is way too crowded. I'm searching to see if there is a way to have each pushpin represent x number of members, such as 10 or 100, in order to cut down on the total number of pushpins. I don't see how to do that yet. If you have an answer please let me know!

Eric Frost
01-16-2009, 07:35 AM
I would recommend to try grouping your data by Zip code and then map the zip codes?

Eric

Winwaed
01-16-2009, 08:55 AM
Your could use the multi pushpin option, and use different pushpins for different numbers of people. You will probably have to group them though - eg. 1-5 per zipcode, 6-10, etc.

If you wanted an online solution, then the latest Virtual Earth (6.2) has a pushpin clustering option which can be set to do this automatically for you.
Eg. if you had a town in a rural area. Lots of patients => lots of pushpins which crowd each other out when zoomed out; so VE replaces the cluster with a special "multi" pushpin to indiciate lots of overlapping pushpins.

Richard

Don.Marquardt
01-16-2009, 03:01 PM
I am also new. I have an excel spreadsheet with 4 columns, key, zip, id(value of 1-21) and count(number of items with that ID in this zip code). I would like to create a Column chart for Mappoint 2009 where each id is a different colour and the count is represented by the height of the column.

Can I do this?

If so How?

Thanks

Don

Winwaed
01-16-2009, 03:15 PM
So a zipcode can have multiple id values?
If so, then using the Data Import Wizard and the bar graph option might be best - or the sized pie chart option. It sounds like the bar graph would be easier to read.


Richard

Don.Marquardt
01-16-2009, 03:27 PM
It would seem so, but all I get in each zip code area is a single bar with lines representing the number of items for each cycle rather than a separate bar for each cycle. From Exercise 6: See how your business has performed over time (http://msdn.microsoft.com/en-us/library/aa493417.aspx)
it looks like I have to spread out each cycle as a separate column.

Don.Marquardt
01-16-2009, 03:30 PM
Here is some of my data...

<table style="border-collapse: collapse; width: 192pt;" border="0" cellpadding="0" cellspacing="0" width="256"><col style="width: 48pt;" span="4" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 48pt;" width="64" height="20">Key</td> <td style="width: 48pt;" width="64">ZIP</td> <td style="width: 48pt;" width="64">CYCLE</td> <td style="width: 48pt;" width="64">SUM</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">10</td> <td align="right">92003</td> <td align="right">14</td> <td align="right">59</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">11</td> <td align="right">92003</td> <td align="right">15</td> <td align="right">82</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">12</td> <td align="right">92003</td> <td align="right">19</td> <td align="right">2</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">13</td> <td align="right">92003</td> <td align="right">11</td> <td align="right">1</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">14</td> <td align="right">92003</td> <td align="right">16</td> <td align="right">2026</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">15</td> <td align="right">92004</td> <td align="right">11</td> <td align="right">11</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">16</td> <td align="right">92004</td> <td align="right">12</td> <td align="right">1869</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">17</td> <td align="right">92004</td> <td align="right">13</td> <td align="right">914</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">18</td> <td align="right">92004</td> <td align="right">15</td> <td align="right">3</td> </tr> </tbody></table>
What I would like to see is that in zip 92003 there would be at least 5 bars for cycles 14,15,19,11 and 16 where the bar for 16 would be highest. Then for 92004 there would be bars for 11,12,13, and 15 where 12 would be highest.

Don.Marquardt
01-16-2009, 07:29 PM
Well I got the display that I want, but what I had to do was that I had to move the Cycle counts to be in their own column. That is cycle 1 counts for each Zip are in C1, Cycle 2 counts in C2 etc.

Another question I have is How can I have more than 16 columns in a column chart?

TIA

Laura
01-19-2009, 04:59 PM
Have used Map Point for a while but at quite a simplistic level. In our job, we often have to create a (for example) 3 mile radius around 200 locations. Is there any way to automate this. We only know how to go to each of the 200 locations and create a 3 mile radius, then move to the next location. Obviously, VERY time consuming. Any advise? Laura

Eric Frost
01-19-2009, 06:47 PM
Well I got the display that I want, but what I had to do was that I had to move the Cycle counts to be in their own column. That is cycle 1 counts for each Zip are in C1, Cycle 2 counts in C2 etc.

Another question I have is How can I have more than 16 columns in a column chart?

TIA

I don't think it will allow more than 16 columns. Maybe you could group some of the items?

Eric

Eric Frost
01-19-2009, 06:49 PM
Have used Map Point for a while but at quite a simplistic level. In our job, we often have to create a (for example) 3 mile radius around 200 locations. Is there any way to automate this. We only know how to go to each of the 200 locations and create a 3 mile radius, then move to the next location. Obviously, VERY time consuming. Any advise? Laura

I'd recommend to get a custom utility created. There are a bunch of tutorials on getting started with MapPoint programming here --
Working With Excel and MapPoint - MP2K Magazine (http://www.mp2kmag.com/excel)

Maybe this would give you some ideas and the start you need?

Eric