MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




newbie q: more than one record at a single postcode

This is a discussion on newbie q: more than one record at a single postcode within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; Hi I'm mapping individual postcodes but where I have more than one record at a single postcode only one marker ...


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

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 10-16-2007
Junior Member
White Belt
 
Join Date: Oct 2007
Posts: 2
newbie q: more than one record at a single postcode

Hi

I'm mapping individual postcodes but where I have more than one record at a single postcode only one marker is being shown.

On the spreadsheet I'm importing, there is one row for each record, ie the same postcode can appear in several different rows. I have only one column of data (for my first effort!).

Is there of showing the number instances of each record at each postcode? I don't mind creating 'dummy' data if it helps.

Thanks very much.

Dave S
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 10-17-2007
Member
Green Belt
 
Join Date: Oct 2003
Location: London
Posts: 97
Re: newbie q: more than one record at a single postcode

Hi there

You might consider using some custom programming to do this. If you just want to use the package however then one solution might be to read your data in as frequencies by postcode eg KT17 6XY 5 meaning 5 occurrences in that postcode. You could then map the data using 'Multiple Symbol' and you'll see that in the symbol menu you can choose a brown circle with a number in it. Maximum would be 8 different frequency levels. Worth a shot.
__________________
David
MapPoint Europe Gallery at http://www.broomanalysis.plus.com/gallerylist.html
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3 (permalink)  
Old 10-17-2007
Junior Member
White Belt
 
Join Date: Oct 2007
Posts: 2
Re: newbie q: more than one record at a single postcode

Hi

thanks for your response - not sure about custom programming at this stage! - but I took your suggestion and made a pivot table from my data to obtain frequencies and that does the trick very nicely.

Thankyou

Regards

Dave
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


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
Are there any workarounds for the 10000 record lim.... Anonymous MapPoint 2006/2009 Discussion 2 03-23-2005 05:01 PM
gps record bchara MapPoint 2006/2009 Discussion 0 07-23-2004 07:31 AM
using an excel record as a variable Anonymous MapPoint 2006/2009 Discussion 2 02-11-2004 12:47 PM
50,000-record limitation Anonymous MapPoint 2006/2009 Discussion 2 02-06-2004 10:41 AM
PUSHPIN RECORD LIMIT gsc1ugs Products: Pushpin Tool, Single State Mapper 2 03-07-2003 10:00 AM


All times are GMT -5. The time now is 09:15 AM.


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

Ski Holiday Soldeu
Ski holidays in Soldeu are renowned for the fantastic snow and sunshine records combined with the high standard of accommodation. Book a ski holiday in Soldeu online.

European City Breaks
Find European City Breaks on Travel Counsellors. Based on holidays booked this year, these are the most popular City Breaks for 2006

Cheap Holidays to Turkey
If you’re looking for cheap holidays to Turkey then dealchecker.co.uk is the place for you! Our search helps you see real prices from the UK’s top holiday companies all in one go.

Barbados Holidays
Barbados holidays can be a wonderful break from the rat race or an exciting, action packed adventure. Plan the perfect holiday in Barbados.

Cheap Greece Holidays
For cheap Greece holidays make sure you know when to book and who to book with. Visit ulookubook.com to get help with doing both of those things. Why not time your visit with a Greek festival?

Holiday Packages
Spoil yourself and your loved ones with one of the great Holiday Packages from Travel.co.uk.

Holidays to Goa
Golden beaches, coconut trees. Visit On The Beach for holidays to Goa, and experience India!


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