Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 7 of 7

Using Multiple Matching Methods

This is a discussion on Using Multiple Matching Methods within the MapPoint Desktop 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 ...

  1. #1
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60

    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

  2. #2
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433
    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' ?

  3. #3
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    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

  4. #4
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    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
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  5. #5
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    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

  6. #6
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    yes, I am sorry, am trying to catch up.. was sick with flu. Daughter has been sick from Friday and still sick

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  7. #7
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Automating matching postcodes
    By robertaw in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 11-15-2005, 02:24 PM
  2. Matching records problem - URGENT HELP
    By Abilio Serafim in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 05-09-2005, 12:23 PM
  3. Help matching data
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 03-01-2005, 04:53 PM
  4. Spatial Data Import Methods
    By StanPrescott in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 11-17-2004, 11:56 AM
  5. Matching Un-matched Records to Zip Code
    By Anonymous in forum Products: Pushpin Tool, Single State Mapper
    Replies: 1
    Last Post: 08-26-2004, 03:26 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


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 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96