MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Finding which pins from two data sets are at same location

This is a discussion on Finding which pins from two data sets are at same location within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; Is there a way that I can isolate the pins that i plot from two datasets that are at the ...


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 08-22-2003
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
Finding which pins from two data sets are at same location

Is there a way that I can isolate the pins that i plot from two datasets that are at the same exact address? Ideally I would like to be able to just print the hyperlinks and/or pushpin name of those at same locations.

Perhaps there is a way that after I display the pins from both sets, I can hit my button and those pins that arent at location of another disappear and I can then print out the remaining pins.

Or maybe I can use highlight for those that are at same, and then print highlighted.

Either way, I REALLY need to be able to isolate the locations with 2 or more pins.

Many thanks for reading and hope you can help. From what I see you guys are pretty good with MP!
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 01-08-2004
Senior Member
Black Belt
 
Join Date: Jul 2002
Posts: 5,138
i am looking for the same things. any ideas..
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 01-12-2004
Member
Yellow Belt
 
Join Date: Feb 2003
Posts: 48
Try something along the lines of:
Loop through each pushpin in "Dataset A" doing a QueryCircle on "Dataset B" centred on the location of the pushpin. If the returned recordset has any entries, then there are 2 co-incident pushpins, so set the Highlight property/move or copy to another dataset/save name of pin etc. (whatever).

HTH

M.
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
data, finding, location, pins, sets


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
Switchable data sets? mksql MapPoint 2006/2009 Discussion 0 07-06-2005 06:31 PM
Push Pins not showing up on linked data? chucker MapPoint 2006/2009 Discussion 1 01-13-2005 04:15 PM
Downloadable Data Sets (PLEASE HELP) Anonymous MapPoint 2006/2009 Discussion 0 11-15-2004 10:05 PM
Viewing multiple data sets on a map. Pauluk MapPoint 2006/2009 Discussion 4 11-21-2003 11:12 PM
I have 2 sets of data detailing locations. The fi.... Anonymous MapPoint 2006/2009 Discussion 1 08-28-2001 10:30 AM


All times are GMT -5. The time now is 09:17 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 55