HomeMicrosoft


Plotting Mexican cities in Microsoft Streets & Trips 2013
jamm28
I'm trying to export a list of addresses from an Excel worksheet into Streets & Trips 2013 but it's not recognizing the addresses. Any tips?
winwaed
MapPoint and Streets&Trips only have limited coverage of Mexico. Because of this I haven't done much work with Mexican data, but I think it might be able to plot Mexico City and perhaps some of the larger cities, but that is all?
jamm28
Is there any program out there like Streets & Trips that could accommodate plotting of Mexican cities?
SpadesFlush
Either ITN Converter or Tyre, both freeware, will do that for you. On the former be careful of the download sites that provide it; see discussion elsewhere in the Forum. On the latter see www.tyretotravel.com. That is also discussed here; do a search.
Confused
We have been RVing in Mexico for the past 7 years (3 - 4 months each winter) and visited Mexico many times prior to that going back to my first "RV" trip in 1971. I use S&T all the time in our motorhome and also use it to plan our trips and each days travel. We also use a Garmin 2757LM in the car when we do many side trips. Point being - a good deal of experience in Mexico.

I assume you want to search for and find a specific address? I have found no way to do this. Even when I know where the street is and click on the side of the street to try to find a street number, as we do in the US, I have never been able to find a street number. I have also found it difficult for S&T or Garmin to find a specific street even when that street is on the map - though it sometimes does work.

Since I cannot get this to work in either S&T or Garmin I have assumed that Mexico does not provide street numbers to NAVTEQ or whoever creates the base maps used in these systems. But I do not know and wonder if anyone else knows if this is what is being asked and/or if there is an answer.

I have also found some streets can't be found even when I am looking at them on the map. There are even sections of major highways that S&T refuses to see even when I try to force it to go there - by using Avoid Area to eliminate all other possibilities.

Above it is suggested to use tyretotravel and I looked at their website but am not sure what this is or how it works etc. Can we get some idea of what this is and how it works and what it does? I am not sure if this answers the original question or if I am clear on the original question. Mexico can be very confusing.
jamm28
Confused - you have experienced everything I have. I tried Tyre and it seems to work the best, so far. It's not as perfect as S & T US version but it's helping me get the job done.
Confused
Thanks jamm28,

I don't really need the specific kind of detail you do and looking at the Tyre website I probably will not be using it. I might be able to help in some areas of Mexico but not much in Mexico City.
SpadesFlush
The main advantage of both Tyre and ITNConverter is that they are basically overlays of Google maps. Therefore, any search will be, in effect, a Google map search which seems to have a better data base than does S&T. Also, it seems to be more up-to-date. And you cannot beat the Google Street View (which is a click away in ITNConverter) for getting a clear impression of the close-up locality.

Actually, for best results, I tend to use both S&T (or AutoRoute, if in Europe) and ITNConverter. For instance I am currently working on an 11-day tour of Sicily and I keep going back and forth between the two constantly refining the saved AutoRoute map file. I also create pushpins that are hyperlinked to pdfs of Wikipedia downloads or other sources. I am finding that only about half of our planned hotels and restaurants are in A/R so it is useful to have ITNConverter as a source.

Finally, I find it useful to be able to copy the co-ordinates from Google Maps, using ITN, to place waypoints in A/R precisely.
jamm28
SpadesFlush; A traveler after my own heart!! I do the same with AutoRoute and Google. ITNconverter is new to me so I'm going to try that program, too. I'd like to learn how you create the pushpins that are hyperlinked to PDFs of Wikipedia. It sounds like I have to navigate through two or three programs to achieve my end goal.
Marvin Hlavac
Hi Jamm28,

Quote:
I'd like to learn how you create the pushpins that are hyperlinked to PDFs of Wikipedia.
The following describes how it is done: Pushpin links to files and folders
SpadesFlush
Of course, Marvin's pointer to an old discussion of this subject is correct and useful.

You don't have to do a lot of program surfing outside of S&T or A/R to get there, though. You do need something to convert what you see on a web page to a pdf file, however. I personally use ScanSoft pdf Create which comes free with PDF Converter Professional but there are tons of programs out there that will serve as a virtual printer to convert what you see on the screen to a pdf. Adobe has something although I don't use it.

So my process is to find the places of interest in either Wikipedia or Tripadvisor, or both, creating pdfs as I go. I find it easier to use the pdfs if they saved are in the same folder as where the route file is saved, so long as it is not too long of a string of letters for the address. Then, I create the pushpins in the usual fashion as outlined in Marvin's link above and enter the pdf file address to the pushpin balloon. As I usually do not have an internet connection when I am "in the field," I avoid hyperlinking to web pages as elegant as that can be. That's all you have to do.

Optionally, you can create more specialized pushpin sets to meet your needs. For instance, for my Sicily trip, I have pushpin sets for each hotels, restaurants, ruins, castles & villas, churches (which includes cathedrals), and just-plain other. That helps to reduce the visual clutter that can occur with too many pushpins on a map. I just toggle hide/unhide the set as appropriate. Obviously, I don't want to think about "ruins" when I only want to find a "restaurant." Finally, at the end of the day I usually hide individual pushpins when I've been there and done that.
CloudyBright
There are many small cities such as La Penita or San Blas that I found surprisingly detailed.
However, the list of site that I was given was in GPS coordinates and I had to manually enter them into S&T.
Confused
CloudyBright,

Not sure what you mean by manually enter. Using Data Import Wizard you can enter a list of coordinates. I use a simple Notepad .txt or .doc and comma separated values to make my own map showing hundreds of locations. Many times the Lat Lon and name can be done by Copy & Paste and other times I have entered to Notepad manually and then add the list with the Wizard. We are RV travelers and I located well over 400 campgrounds where RVs can park in Mexico - and they all show up on my map. Maybe that is what you mean by manually. Sometimes we have to create our own Pushpin Set.
laptopgpsworld.com About