MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Using Multiple Matching Methods

This is a discussion on Using Multiple Matching Methods within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; Quick sanity check, I don't think the following is possible, is it? We're importing (or linking) data programmatically into MapPoint ...


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 02-28-2006
Winwaed's Avatar
Mapping-Tools.com
Red Belt
 
Join Date: Feb 2004
Posts: 893
Blog Entries: 10
Using Multiple Matching Methods

Quick sanity check, I don't think the following is possible, is it?

We're importing (or linking) data programmatically into MapPoint and displaying it as pushpins.

Each location can be located by longitude,latitude; or street address.
Having both sets of fields in the input data, MapPoint locates using latitude, longitude (a logical choice). However, some of our locations do not have longitude,latitude coordinates. For these, MapPoint ignores the street address information and marks the pins as "Not Matched".
Can anyone think of a way that we can match these pushpins?
Yes we can loop through them, but once we've found them, we cannot move them - the Location property is read only.

Ideally we should be able to say "match using this method, if it isn't available, use this one...".
Alternatively we could loop through finding the unmatched pins, and re-match them, using a different method.

--------------------------------
I don't think this is possible, so I have two backup schemes which might not be ideal, but at least they will work:

1.) We import the data manually a row at a time. We won't be able to import data field data, but it might be acceptable to parse the required data fields and put them in the text balloon.

2.) We batch geo-locate all of the addresses in the data source (Excel as it happens), ahead of time.


Richard
__________________
Winwaed Software Technology LLC
http://www.winwaed.com
See http://www.mapping-tools.com for MapPoint Tools
Pre-Order MapPoint 2009 today: http://www.mapping-tools.com/mappoint2009
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 02-28-2006
Senior Member
Black Belt
 
Join Date: Nov 2004
Posts: 2,112
Hi Richard,

I think I have less experiance in mappoint than you, so probably I can not help, but I dont understeand the prob.

Can you explain again in more 'simple English' ?
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 02-28-2006
Winwaed's Avatar
Mapping-Tools.com
Red Belt
 
Join Date: Feb 2004
Posts: 893
Blog Entries: 10
I'll try

We're importing data inot MapPoint as pushpins. We could locate these as addresses or longitude,latitude coords. We don't have longitude,latitude coords for all of the data points.
We'd like to match the data to longitude,latitude if we have it, otherwise the street address.
We'd like to do this programmatically. Loading the data in using the ImportData or LinkData methods results in a pushpin set which is effectively readonly - ie. although we can loop through and find the 'bad' pins, we can't move them to the right places.


Richard
__________________
Winwaed Software Technology LLC
http://www.winwaed.com
See http://www.mapping-tools.com for MapPoint Tools
Pre-Order MapPoint 2009 today: http://www.mapping-tools.com/mappoint2009
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #4 (permalink)  
Old 02-28-2006
Eric Frost's Avatar
Senior Member
Black Belt
 
Join Date: Jul 1992
Posts: 2,472
Blog Entries: 1
Yes, I would recommend to geocode and fill in all the missing lat/lons in Excel beforehand.. so you would have an Excel button or menu item that says "Obtain Lat/Lon's" which would need to be done in Excel.

Eric
__________________
~ Now taking orders for MapPoint 2009 ~
~
~ Upgrade to MapForums Plus membership ~
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #5 (permalink)  
Old 03-01-2006
Winwaed's Avatar
Mapping-Tools.com
Red Belt
 
Join Date: Feb 2004
Posts: 893
Blog Entries: 10
Yes that is my preferred solution at the moment - just checking I hadn't missed anything in the docs!


btw Eric, did you get the two emails I sent in the past few days?


Richard
__________________
Winwaed Software Technology LLC
http://www.winwaed.com
See http://www.mapping-tools.com for MapPoint Tools
Pre-Order MapPoint 2009 today: http://www.mapping-tools.com/mappoint2009
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #6 (permalink)  
Old 03-01-2006
Eric Frost's Avatar
Senior Member
Black Belt
 
Join Date: Jul 1992
Posts: 2,472
Blog Entries: 1
yes, I am sorry, am trying to catch up.. was sick with flu. Daughter has been sick from Friday and still sick

Eric
__________________
~ Now taking orders for MapPoint 2009 ~
~
~ Upgrade to MapForums Plus membership ~
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #7 (permalink)  
Old 03-01-2006
Winwaed's Avatar
Mapping-Tools.com
Red Belt
 
Join Date: Feb 2004
Posts: 893
Blog Entries: 10
That's fine - just checking that they hadn't been eaten by a spam filter or something

Hope the family gets well soon...


Richard
__________________
Winwaed Software Technology LLC
http://www.winwaed.com
See http://www.mapping-tools.com for MapPoint Tools
Pre-Order MapPoint 2009 today: http://www.mapping-tools.com/mappoint2009
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
matching, methods, multiple


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
Automating matching postcodes robertaw MapPoint 2006/2009 Discussion 3 11-15-2005 02:24 PM
Matching records problem - URGENT HELP Abilio Serafim MapPoint 2006/2009 Discussion 0 05-09-2005 12:23 PM
Help matching data Anonymous MapPoint 2006/2009 Discussion 0 03-01-2005 04:53 PM
Spatial Data Import Methods StanPrescott MapPoint 2006/2009 Discussion 1 11-17-2004 11:56 AM
Matching Un-matched Records to Zip Code Anonymous Products: Pushpin Tool, Single State Mapper 1 08-26-2004 03:26 PM


All times are GMT -5. The time now is 01:44 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