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

Mappoint 2006 and Exporting Radius's

This is a discussion on Mappoint 2006 and Exporting Radius's within the MapPoint Desktop Discussion forums, part of the Map Forums category; Trying to get data exported in Mappoint. We have imported data into Mappoint. I am doing a Radius and exporting ...

  1. #1
    fatbobthefirst is offline Junior Member White Belt
    Join Date
    Oct 2007
    Posts
    3

    Mappoint 2006 and Exporting Radius's

    Trying to get data exported in Mappoint.
    We have imported data into Mappoint.
    I am doing a Radius and exporting the data.
    But what I need to get out when it exports is the mileage for all the data from the center point out into the excel sheet.
    Right now I don't see how Mappoint can pull Mileage out of the RADIUS and the centerpoint and insert it into the excel sheet.

    Any help would be appreciated.

  2. #2
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433

    Re: Mappoint 2006 and Exporting Radius's

    Hi,

    I don't understand what you mean by "pulling mileage out of a radius of a centerpoint". Maybe it is my English but can you clarify this a little ?

  3. #3
    fatbobthefirst is offline Junior Member White Belt
    Join Date
    Oct 2007
    Posts
    3

    Re: Mappoint 2006 and Exporting Radius's

    The old program we used was Delorme.
    We would put a Radius of 15 miles in.
    The Exported Excel sheet would bring all the pushpins for the 15 mile radius, along with the data that was imported. Also it would put the Mileage from the center or the starting point of the radius next to the information. So say the first one of the sheet would have a distance of 2.13 miles on and on to one that is 14.88 miles away from center.

  4. #4
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433

    Re: Mappoint 2006 and Exporting Radius's

    Hi,

    OK understand now what you mean. What you want is very easy to do with some custom programming (add-in or MP embedded in custom program). I don't think this is standard behaviour with the standalone version.

  5. #5
    fatbobthefirst is offline Junior Member White Belt
    Join Date
    Oct 2007
    Posts
    3

    Re: Mappoint 2006 and Exporting Radius's

    I wish it was that easy.
    I was now able to push out the Lat and Lon into the export.
    I figured we can do something with that info.
    But it will not put Center pushpin as what we are going off of.

    We would have to take that excel and change it around to say this point is the starting and everything goes from that point.

    Do you know any formulas in excel to take the Lat and Log to give miles from a certain point.

  6. #6
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433

    Re: Mappoint 2006 and Exporting Radius's

    Hi,

    This is a pease of C code (you can easy translate it to VBA for use in excel) to calculate the distance between 2 lat / long pairs. It returns the distance in km.

    Code:
    u_32 calc_distance(double lat1, double lon1, double lat2, double lon2)
    {
    	double lat  = lat2 - lat1;
    	double lon  = (lon2 - lon1) * cos(deg2rad((lat1 + lat2) / 2));
    	double dist = hypot(lat, lon);
    	return (u_32)(dist * 60 * 1.852);
    }

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Please Help! Exporting data from Mappoint
    By sugarflux in forum MapPoint Desktop Discussion
    Replies: 8
    Last Post: 07-10-2007, 05:54 AM
  2. Exporting Pushpins out of MapPoint
    By EFeams01 in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 06-07-2007, 01:34 PM
  3. 2006 on CE and exporting
    By raul522 in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 12-15-2006, 03:40 PM
  4. Difference between MapPoint 2006 and MapPoint 2006 Fleet
    By jlewis in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 11-21-2006, 08:18 AM
  5. Exporting MapPoint data
    By mr4tno in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 05-11-2005, 12:08 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