HomeMicrosoft


POI Mega File - pushpin collections for truckers, RVers, and other travelers
malaki86
You're gonna make me break down and download a trial of Mappoint 2010, aren't you... My trial for S & T expired ages ago. I want to steal - no, I mean see - what all you've got. :wink:
Marvin Hlavac
I just looked at the stats of the two specific files. The November.zip file has been downloaded 331 times and the November.stt file shows 191 downloads so far.

331 x 7 MB = 2,317 MB
191 x 20 MB = 3,820 MB

Total for the past few days: = 6,137 MB for the two files :-)

6 GB is just a small portion of our current 100 GB monthly limit. Nothing would give me more pleasure than to have to increase the monthly bandwidth limit because of the popularity of your POI Megafile, Larry.
prsmith
You also can take a Export GPX file from S&T and open it in Excel, delete all but the Latitude, Longitude and Name fields and then save it as a .csv file. I have also saved the GPX files in TomTom itinerary format and uploaded to my TomTom - works great - but it has been awhile since I did that version.

Be sure to hide all your pushpins! Just the route will show up.

Tom
Tom,

I do not have S&T but would like to convert this great pushpin file to a TOMTOM .ov2 format

GPSBabel does not recognize the stt format

I saw your note about using Exel but I have to get it to a format that I can edit to put it in Excel

You talked about a GPX format but since I do not have S&T I have a problem

Thanks

Preston
ki4nai
Question/Request... Is it possible to get all the National Park Visitor Centers added to the Mega File. If you didn't know any better, you would think that the current file (National Parks) was the Visitor Centers instead of Campgrounds... tks
Ken in Regina
I figured it would be kind of nice to have this in a format that could be used by other software. The simplest seemed to be to get it into Excel. Then it can be saved to .CSV, a format that can easily be converted to other file types by converters like GPS Babel. If I can do that, I'll upload it here so others can use it.

So, I loaded the .stt file into Streets&Trips and saved it as a .est file so it could be loaded into Mappoint.

I downloaded the trial version of Mappoint 2010 and installed it. Then I opened the .est version of the POI megafile in Mappoint 2010.

Now I'm stuck. It appears that two steps are required to get it saved to Excel. First, I need to unhide all of the pushpin sets or nothing will get exported to Excel. Then I need to select the pushpin sets and select "Export to Excel".

Here's my problem. To unhide a pushpin set requires selecting it in the list in the Legend and Overview pane. To save a pushpin set to Excel also requires that it be selected in the Legend and Overview pane.

But I can only select one pushpin set at a time in the Legend and Overview pane. At least I cannot find any way to select more than one. I have tried all the usual ways .. Ctrl-A just brings up the GPS pane. Using either Ctrl-click or Shift-click does nothing.

I don't want this badly enough to go through the entire list, twice, to first unhide each of the pushpin sets, one at a time, and then save each of the pushpin sets to Excel, one at a time.

Is there something simple that I'm missing?

Here is the requirement:

1. Pushpin sets must be unhidden or they will not be exported to Excel.

2. Pushpin sets must be selected or you can't unhide them or export them.

3. I'm not going to do this one at a time. I need a way to select them all so I can, first, unhide them with a single operation and, second, export them all with a single operation.

Any suggestions?

...ken...
Johnnycb
Is there a way to be able to delete multiple pins at one time?

I have tried using Shift and clicking the first and last to be deleted and it does not work.

I have also tried using Ctrl and selecting individual pins to delete and it doesn't work either.

Johnny
SpadesFlush
@Ken: Doesn't Mappoint work the same way as S&T in that you can toggle all pushpin sets hidden or not by right-clicking "pushpins" at the top of the legend panel??

@Johnny: It is not clear how you are trying to do what you describe but, if you are doing it from the drop-down list of pushpins under a pushpin sets Properties "Matching" tab, you can make your selection and then click "Cut". That seems to have the effect of deleting from the Matching set and placing them in the clipboard. There, you can ignore them or paste them somewhere else.

But this may not be what you mean.
Johnnycb
Spade,

What I am doing is deleting the sets that are no use to me.

Then save as a new named map.

Now when I open this new saved map all the "junk" sets are not available thus the list of avaiable sets is much shorter.

Johnny
Ken in Regina
Johnny is having the same problem I am. We can't seem to find a way to select groups of pushpin sets in the Legend and Overview pane.

Your suggestion to right-click Pushpins at the top of the list gets me halfway there. That will unhide everything in one operation.

Now I need a way to select all of the pushpin sets so when I Export to Excel they will all go in a single operation instead of having to do them one set at a time.

Johnny wants to select groups of sets to delete (or copy) rather than having to do them one at a time.

Did Microsoft really not allow for selecting pushpin sets in groups by using Ctrl-click or Shift-click or some other method?

...ken...
SpadesFlush
Johnny,

To delete an entire set, I go to Legend and overview {ctrl-G}, select the pushpin set I want to delete, right-click to get the drop-down menu, and click on Delete (or just hit the Delete key or {ctrl-X). Are you trying something else that does not work?
SpadesFlush
Ken says
...Johnny wants to select groups of sets to delete (or copy) rather than having to do them one at a time...
OK, I get it now, duh.

One way would be to show (unhide) all the sets you have a hankering to delete and then select a rectangular area {right-click-drag} around the excess pushpins and select Delete from the drop-down list. I know it is not what you are getting at: Add as a Wishlist Item??
SpadesFlush
Ken, you say
Now I need a way to select all of the pushpin sets so when I Export to Excel they will all go in a single operation instead of having to do them one set at a time...
Once the sets are open, won't they all be exported in one fell swoop?
SpadesFlush
Once the sets are open, won't they all be exported in one fell swoop?
I tried this for a few open (unhidden) sets and I produced a nice spreadsheet showing 4 data fields: lat; lon; name7; and type12 (the pushpin sets name) and a lot of vacant columns. All the PPs seem to be listed.
SpadesFlush
It seemed to work for me: 86,601 POIs. Too big to attach.
Ken in Regina
It seemed to work for me: 86,601 POIs. Too big to attach.
Can you describe the exact procedure, please?

I tried unhiding, for instance, four pushpin sets. Then I clicked on the word "Pushpins" at the top of the list to select it, then I clicked the Export to Excel icon on the top toolbar. Nothing.

The only way I can find to get the export to work is to actually select one of the pushpin sets in the list, e.g. click on on pushpin set name so it's highlighted. But that only results in that one set getting exported, no matter how many sets I have unhidden.

After you did the unhide for all sets, what exactly did you do next? What did you select/highlight? Etc.

...ken...
laptopgpsworld.com About