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 4 of 4

Obtaining/Exporting GPS Coordinates

This is a discussion on Obtaining/Exporting GPS Coordinates within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have a data/route travel map done up for unique addresses in the city of St. John's, Newfoundland, Canada. The ...

  1. #1
    cmolloy69 is offline Junior Member White Belt
    Join Date
    Apr 2003
    Posts
    3

    Obtaining/Exporting GPS Coordinates

    I have a data/route travel map done up for unique addresses in the city of St. John's, Newfoundland, Canada. The route map was created by importing 350 unique addresses from Microsoft Excel into MapPoint using the Import Data Wizard Function. The importation process worked fine and created the map. What i need to do now is obtain the gps coordinates for each unique address and place this into the excel spreadsheet as well. Is there any way that I can do this without having to manually enter in each address. I know that under the tools menu, location sensor will give you the coordinates for each pushpin address. I am trying to avoid these option and trying to see if there is a way possilbe to export or obtain the gps coordinates for each address on the route map without having to use the location sensor method and manually having to enter the coordinates for each address imported in from excel. If there is a way, can someone please let me know. Thanks and great forum by the way.
    The game.

  2. #2
    Labtek is offline Member Yellow Belt
    Join Date
    Mar 2003
    Posts
    41

    Obtaining/Exporting GPS Coordinates

    I wrote a program (coordex) that will extract the lat/long of the MapPoint pushpins. Right now you can only extract to a small set of file formats. You should be able to parse the text file for input into Excel. Try the gpsutil file format. The next version will be able to interact with GPSBabel and export many more formats.

  3. #3
    Labtek is offline Member Yellow Belt
    Join Date
    Mar 2003
    Posts
    41

    Obtaining/Exporting GPS Coordinates

    I've just posted version 0.3 of Coordinate Exchange to my website: http://www.hypercubed.com/projects/coordex/ . This version should do what you need.

    Labtek

  4. #4
    cmolloy69 is offline Junior Member White Belt
    Join Date
    Apr 2003
    Posts
    3

    Obtaining/Exporting GPS Coordinates

    Thanks for your help and the link to the file. I did as you suggested and it worked, however the problem that we encountered with the Coordintes were that they were off. They kept bringing us to different spots in the Atlantic Ocean. Even though the coordinates for each address was different, each coordinate location ended up somewhere in the Atlantic Ocean. I don't know if there was a problem with the converstaion from the source file to the destination file. I don't know if you know of any solutions to fix this, but if you have they would be greatly appreciated. I want to thank-you for your help that you have provided.

    Cheers,

    Chris
    p.s

    Also, I don't know if you are familar with this software tool but anyhow here goes, we recently downloaded a demo version of MapPoint Push Pin Tool Beta version 2.5. I know that it is only a trail version and that it is limited in the amount of push pins that you can extract information from, but it goes through the motions fine and lets us do everything that we ask it to do except for actually extracting the information into an Excel file. When we open the data/route travel map and then go under tools menu and pushpin tool it works fine, then when that opens up we go under the pushpins dialog box/tools menu option and hit export with Lat/Lon option, when we do this it opens up the Excel spreadsheet but no information appears at all. So then when we go to close the book, it asks us do we want to save changes, but there is no information there at all. Are you familiar with this problem, and if so do you know of a solution that we can use to correct this problem. Thanks for all the information that you have provided to us in the past. Take care.

    Chris
    The game.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Exporting Drivetime Zone coordinates
    By karlski in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 05-18-2011, 10:37 AM
  2. Obtaining pushpin's territory information
    By paf33 in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 07-30-2005, 07:53 PM
  3. Exporting Coordinates, Census Tracts or Other Information
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 12
    Last Post: 04-14-2005, 09:36 AM
  4. Obtaining corrected matched data
    By jamesvdale in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 12-03-2004, 03:02 PM
  5. In Chris Gebhardts' article on obtaining Lat/Lon ....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 07-25-2001, 12:52 PM

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 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83