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 6 of 6

How to programatically tell if an address is located?

This is a discussion on How to programatically tell if an address is located? within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have a Microsoft Access program that moves through a pushpin dataset to determine the matching method of each pushpin ...

  1. #1
    jharbaugh is offline Junior Member White Belt
    Join Date
    Apr 2004
    Posts
    4

    How to programatically tell if an address is located?

    I have a Microsoft Access program that moves through a pushpin dataset to determine the matching method of each pushpin and print out a report of those pushpins that could not be matched to a specific street address. I believed that checking the MatchingMethod property would let me know if an exact street address match had been made by MapPoint. However, I have found two pushpins located in the same place on my map but in reality, the businesses are about 1/2 mile apart. Both pushpin dataset records show that the MatchingMethod was geoByStreetAddress but MapPoint 2004 does not apparently have the addresses in its database so it picked a location along the street and mapped both addresses at that point.

    Is there a way to tell if a match was made by the numerical street address and not just by the name of the street. We want to give customers directions to businesses but we can't if we can not rely on the pushpins being mapped to an actual street address. Any assistance you can provide would be greatly appreciated. Thanks.

    Jim Harbaugh
    T.E.A.M.
    Troy, MI

  2. #2
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433
    Hi,

    I'm not sure if I understean the question very well, but:

    two pushpins located in the same place on my map but in reality, the businesses are about 1/2 mile apar
    How many decimals do you have ? If not enough you can easy get a resolution of 1/2 mile. 1 minute is exact 1 sea mile on latitude and on longitude on equator.

    numerical street address and not just by the name of the street
    If the street contains no number (which is sometimes), then the only method to check this (as far as I know), is to parse the returned streetaddress and check if there is a number in it.

  3. #3
    jharbaugh is offline Junior Member White Belt
    Join Date
    Apr 2004
    Posts
    4
    I didn't think I had described my problem very well either so I'll try again:

    I have a map that is linked to an Access database. In the Access database are a list of businesses that we work with. For most of the businesses, a pushpin is placed at the exact location of the business. However, I have found at least two businesses that have different addresses (they are approximately 1/2 mile apart; neither are located where MapPoint placed the pushpins) but MapPoint has their corresponding pushpins overlaying each other.

    Upon closer examination, I found that the section of road that both businesses are located at does not have numerical addresses assigned to it by MapPoint. It appears that since MapPoint didn't know the numerical addresses, it placed the pushpins in the center of the unaddressed section of the road.

    My question is this: I want to be able to write VBA code to read through the link dataset and based on the matching method used to place the pushpin, print a report of pushpins that are not in the correct location. However, the MatchingMethod property is 7 (geoByStreetAddress) for both correctly matched records and for records where the address couldn't be correctly located. Is there a different property I should be using to determine if the pushpin for the record was placed in the correct location or if MapPoint just placed the pushpin in the center of the unaddressed section of the road? If there isn't a property that will provide me with the information I want, is there another method that will tell me which pushpins were not mapped based on the numerical address?

    I hope this clears up my question. Thanks for any assistance that anyone can provide.

    Jim Harbaugh

  4. #4
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433
    Hi,

    I'm still not sure I understeand fully but I like it to take step by step. If I sound silly please dont border me, Englisch is not my mothers tongue

    two businesses that have different addresses (they are approximately 1/2 mile apart; neither are located where MapPoint placed the pushpins) but MapPoint has their corresponding pushpins overlaying each other.
    So you make pushpins at different location, and Mappoint display them at same place ?

  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
    I think I understand and I'm having a similar problem - or I think I am.

    I have a client test dataset with 1000+ pushpins. I think these have been imported and a handful haven't been matched. Perhaps MapPoint couldn't find the addresses.
    When I try to measure a distance to them (eg. via Gilles' location finding code) I get an assertion. This is because the pushpin in question doesn't have a valid location. (cf. MapPoint help).

    So is there a way that I can detect if a pushpin has been matched without a dummy call to DistanceTo (or Gilles location code) and trapping an assertion. Trapping an assertion is very ugly and slow - but might be the best way.

    The help says there's a geoByNone value for the MatchingMethod properties.
    Jim, you're saying this isn't being set!? Typical, isn't it?


    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  6. #6
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    For my own specific problem I have found the Recordset.IsMatched flag that looks to be working (I have a test running in the background).

    I don't think this will work for two pushpins located at the same place, though.
    Has the user 'helped' with the locating? You know when MapPoint can't find an exact address, but does find some possibles and asks the user?


    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. How can I get the territory code that a pushipin is located
    By paf33 in forum MapPoint Desktop Discussion
    Replies: 7
    Last Post: 06-08-2006, 05:45 AM
  2. Which Territory is a Pushpin located?
    By johnweidauer in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 07-31-2005, 11:46 AM
  3. Exporting "located" data points to excel
    By Jonboy in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 04-06-2005, 09:25 AM
  4. MapPoint to Gif Programatically
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 5
    Last Post: 03-17-2004, 09:32 AM
  5. With MP2K does anyone know how to programatically ....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 07-29-2002, 07:19 AM

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