MapForums
Community of VE/MapPoint Users and Developers
Import Intersections
This is a discussion on Import Intersections within the MapPoint 2006/2009 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 ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-03-2004
| |||
| |||
| Import Intersections 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         |
|
03-03-2004
| |||
| |||
|
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 |
|
03-03-2004
| |||
| |||
|
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 |
|
03-03-2004
| ||||
| ||||
|
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
__________________ |
|
03-03-2004
| |||
| |||
| 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 |
|
03-04-2004
| |||
| |||
|
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 |
Linear Mode
