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

Import Intersections

This is a discussion on Import Intersections within the MapPoint Desktop Discussion forums, part of the Map Forums category; Is there a way to import intersection locations? I can "Find" intersections, but can't import. I will be mapping a ...

  1. #1
    mjlacore is offline Junior Member White Belt
    Join Date
    Mar 2004
    Posts
    7

    Import Intersections

    Is there a way to import intersection locations? I can "Find" intersections, but can't import.

    I will be mapping a relatively small set of school bus routes, and many of the stops are located not at specific addresses but at intersections. I intend to use an Access table of stop information to import. I'm hoping I can find a relatively painless way of doing this without having to go in and locate the stops manually. Any ideas?
    Mark J. LaCore
    Duluth, MN

  2. #2
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    I thought you could import addresses.. post a few lines of examples and describe your procedure a little bit.

    Eric

  3. #3
    mjlacore is offline Junior Member White Belt
    Join Date
    Mar 2004
    Posts
    7
    Eric,

    I can import addresses easily enough, but not interesection locations. If, for instance, I try to import an address like:"2150 Springvale Rd., Duluth, MN", it works just fine. But if I try "W 11th St. & N 24th Av. W, Duluth, MN" it chokes out and won't match the location, even though I can type exactly the same thing in the "Find" dialog and it matches it perfectly.

    I've poked around the programming procedures and such and haven't yet found anything that will do it. Just thought there might be some sort of workaround that I'm not aware of. If not, MapPoint will not be quite as helpful as I was hoping, though I'll still do what I need to do manually.
    Mark J. LaCore
    Duluth, MN

  4. #4
    mjlacore is offline Junior Member White Belt
    Join Date
    Mar 2004
    Posts
    7
    Eric,

    I missed this part of your question --

    I am just using the Import Data Wizard to pull in a very simple Excel worksheet of addresses. Nothing fancy - starting simple to see how things work (or don't, as the case may be). I match the intersection location from Excel to the Address1 field in the Import Wizard. I also tried splitting the two streets into two fields and matching one street to Address1 and the other to Address2, but no luck.
    Mark J. LaCore
    Duluth, MN

  5. #5
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    Ah yeah I can't get it either.

    If you look in the Help File, there's three programming methods: FindAddressResults, FindPlaceResults, and FindResults.

    I think when it's importing or linking it's performing a FindAddressResults.

    You could program a custom script to perform the FindResults, here's the description of that.

    FindResults method
    Returns a collection of locations and Pushpins (FindResults collection) that are possible place and address find matches based on the input string; similar to the Find box on the Navigation toolbar.

    If custom programming is not an option or appropriate for your size of job, then manually doing them may be the way to go.

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

  6. #6
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

    finding an intersection

    this example should give you what you are looking for

    Private Sub stop_Click()
    Dim objMap As MapPoint.Map
    Set objMap = Forms!MAPform.MAP.ActiveMap
    Dim objloc As MapPoint.Location
    Dim addy As String
    addy = Forms!csgmAP.addys

    Set objloc = objMap.FindResults(Forms!MAPform.addys).Item(1)
    objMap.ActiveRoute.Waypoints.Add objloc
    'objloc.Goto

  7. #7
    mjlacore is offline Junior Member White Belt
    Join Date
    Mar 2004
    Posts
    7
    Eric & Randy - Thanks to both of you for checking into this for me. The FindResults option makes sense.

    You'll have to forgive my relative lack of VBA programming skills here, though (I'm learning, but way too slowly for my own tastes). Where would I attach this code? My primary goal at the moment is to create an Access database that includes a table of bus stops that are uniquely identified and that are assigned to a uniquely-identified route, and from that table, use a query to pull a list of stops by route to create a MapPoint dataset. In MapPoint, I could then sequence the stops to create the route and route directions. How would I adapt this code to accomplish that goal? (Note: I haven't even started building the database yet - just doing some preliminary planning and research here, in hopes of getting it close to right the first time.)
    Mark J. LaCore
    Duluth, MN

Thread Information

Users Browsing this Thread

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

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