HomeMicrosoft


Obtaining latitude and longitude of a pushpin?
LineChaser
How do I get the latitude/longitude for a pushpin?

While I was in the process of "massaging" the exported pushpin data from my map (1650+ pins!), I decided to go back and look at one town in Google Maps and see if I could find one location without having to hop in the car and make a 45-minute (one way) drive to find it. I eventually cyber-stumbled on the location and added it to the map.

Since I may be making the jump to Microsoft Streets and Trips 2010 soon, I want all the pushpin locations in the Excel spreadsheet for easier importing. Is there a way I can obtain the lat/long of a pushpin in S&T 2008 without having to go through the rigamarole of having to export it through POIConverter?

The location in question is the southeast corner of 7th and Hanson in Emery, SD.
t923347
In S&T 2010 261st Street turns into Hanson east of 1St and then dead ends near the railroad track east of S 3rd St. 261st Street starts up again east of the railway and Hwy 262. If I can assume that this is also know as Hanson then the southeast corner of Hanson and S 7th St is at approximately 43.60075N and 97.61705W
SpadesFlush
Quote:
Originally Posted by LineChaser
How do I get the latitude/longitude for a pushpin? ...
The gpx file will have imbedded in it the lat/long data for your open Pushpin sets and you can open the gpx file in Excel as delimited text. However, the info is not obvious or easy to deal with. Excel wants something like csv data and wants delimiters so that it can drop the data into cells.

What happens with a gpx file is that each Pushpin set gets added as a row on the Excel sheet. I used "/" as a delimiter and the result I got was that every third cell (horizontally) that begins with "wpt><wpt" has the lat/long data and the Pushpin name, and other cells have structure instructions and address data, if present in the Pushpin details. So it seems to me that one would have to write a macro that would extract this data systematically and array it in the Excel spreadsheet the way you want it but it could be done. At least the lat/long data is there.
jsnoik
I may miss a step, because I had only glimpse at the replys.

However, if you are switching from 2009 to 2010, I have some recommedations.

1 - Make a copy of your 2009 file with something like 2010 or 10 on the end. You can do that from the 2009, or just with the Windows Copy command.

2 - Open the ....2010 file with your ST2010. I expect, it will behave as mine did when I went from 2007 to 2009: It should ask if you want the file converted. To which you would say yes. All of your pushpins should make the jump to the new program. (See below for why I say "should".)

3 - When you resave the file, it will have the 2010 settings embedded. Therefore, you will NOT be able to open it with the 2009 program.

My reason for suggesting the second file, at least for the time being, can be traced to some issues I encountered when I changed to the 2009. In the 2009, Microsoft removed a lot of their pushpins. I had been using my ST while delivering pizzas. And I was using the number pushpins as part of the address for locations to help me find houses better. With them removed in the 2009 version, they were replaced by generic pushpins. So, I remade them and brought them back into my file.

Anyhow, good luck in the update. I've just started reading the forum again. I no longer do deliveries, so my laptop stays home, now.
LineChaser
jsnoik: thanks but I was after info on how to extract lat / lon on (now two) manually placed pushpins.

My solution in the end was to copy the pushpins to a new map and export from there (dealing with only 2 records vs 1650+).
SpadesFlush
Quote:
Originally Posted by LineChaser
jsnoik: thanks but I was after info on how to extract lat / lon on (now two) manually placed pushpins.

My solution in the end was to copy the pushpins to a new map and export from there (dealing with only 2 records vs 1650+).
Linechaser, this response helped me understand your question better.

Streets & Trips 2010 only exports GPX data on open (unhidden) Pushpin sets. Therefore, another (easier?) thing to do would be to hide all the Pushpin sets for which you don't want lat/long data and then do your export. If your, say, two Pushpins for which you want to export data are in a larger set, just copy the two to a new set and hide all the other sets. You can delete that copy set afterwards before saving the file. In this way, no useless file will clutter-up your harddisk.
Gladwin
Quote:
Originally Posted by LineChaser
how to extract lat / lon on (now two) manually placed pushpins.

My solution in the end was to copy the pushpins to a new map and export from there (dealing with only 2 records vs 1650+).

LineChaser, In Streets & Trips 2010 there is an easy way to capture the lat/long. Zoom in at 1 mile and place your mouse pointer over the pushpin, and observe the lat/long displayed in the status bar at the bottom of the screen.



Now hit Ctrl+Alt+C to copy the lat/long of the location of your mouse pointer.

48.86543N 2.31525E
Attached Images
latlong.jpg  
Ken in Regina
Thanks, Gladwin. I've been driving myself nuts the past few days trying to remember how to recreate that. I knew I had found a method for displaying the lat/long in Streets without a bunch of fooling about but darned if I could recall how I had done it. Thanks for confirming that I haven't lost it completely.

Thanks for the tip on how to get it out to the clipboard without having to type it. I'll bet Marvin will make this a Tip as soon as he sees it.

...ken...
LineChaser
Gladwin: I noticed the lat / lon display in 2010. As soon as I can understand how to import JUST the first couple rows of pushpins and thumbtacks as used in 2008 into 2010, I'll go "whole hog" and get everything moved on over to 2010 format...
Gladwin
LineChaser: If you just trying to move selected pushpins from ST2008 into ST2010 then right click on the pushpin in ST2008 and copy it and then paste the content in ST2010.

You can also copy and paste pushpin sets the same way, this will move all pushpins associated with that pushpin set.
LineChaser
My question has been answered already...
laptopgpsworld.com About