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

Grid of distances from address data

This is a discussion on Grid of distances from address data within the MapPoint Desktop Discussion forums, part of the Map Forums category; I am trying to create a grid of distances from a set of address data (either in Excel or Access ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

    Grid of distances from address data

    I am trying to create a grid of distances from a set of address data (either in Excel or Access or even as delimited file). That is, how far are my customers from each other.

    The input data has the following fields:
    CustID***Address1***State***ZIP
    I need a grid in the following format:

    CustID1***CustID2***Distance
    Has anybody done anything similar? Any pointers on how to do this will be greatly appreciated.

    Thanks,
    Satish

  2. #2
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    This would be fairly straightforward programming, maybe 1-2 hours of work. Do you need road distance or could it just be as the crow flies? The latter would be even easier.

    Eric

  3. #3
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    I am looking at a matrix of road distances.

    Also, do you have any idea how long it would take to create a matrix/grid of say, 100 different addresses in Mappoint?

    Would MapPoint be the best software to address this requirement or would a higher end GIS software like MapInfo be needed?

    Thanks,
    Satish

  4. #4
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    MapInfo doesn't have road data built-in. If you're looking at performing routing calcuations, I think MapPoint is the way to go. You would have 100*100 or 10,000 calculations? That might take a few minutes I don't know what routing add-ons are available for MapInfo/MapPoint to compare, you might see "Freeway" ?

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  5. #5
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    Eric:

    Thanks for the info. One more question: What is "Freeway"?

    Satish

  6. #6
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    From a reseller's web site: "It can also be used for point-to-point drive times between a single origin and single destination point. Finally, it can produce tables between a set of one or more origins and a set of one or more destinations."

    http://www.datasourcetech.com/produc...ware/drive.htm

    But I don't know enough about it to recommend it for your needs..

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  7. #7
    Mossoft is offline Member Yellow Belt
    Join Date
    Feb 2003
    Posts
    48
    Import the data into 2 datasets then use something like:

    Dim rsA As MapPoint.Recordset
    Dim rsB As MapPoint.Recordset
    Dim oRte As MapPoint.Route

    Set rsA = oMapControl.ActiveMap.DataSets(<First Dataset name>).QueryAllRecords
    Set rsB = oMapControl.ActiveMap.DataSets(<Second dataset name>).QueryAllRecords
    Set oRte = oMapControl.ActiveMap.ActiveRoute

    rsA.MoveFirst
    rsB.MoveFirst

    While Not rsA.EOF
    While Not rsB.EOF
    Debug.Print "Straight Line = " & mapWhere.ActiveMap.Distance(rsA.Location, rsB.Location)

    oRte.Clear
    oRte.Waypoints.Add rsA.Location
    oRte.Waypoints.Add rsB.Location
    oRte.Calculate
    Debug.Print "Route distance = " & oRte.Distance

    rsB.MoveNext
    Wend
    rsA.MoveNext
    Wend
    Set rsA = Nothing
    Set rsB = Nothing
    Set oRte = Nothing

    Which puts the straight line and road distances into the debug window. This could just as easily be appended to a flat file. Augment the data by adding a key field from the dataset (like the names of the locations would be useful ) Also may want to turn off the screen updates as they do flash around a bit when the routes are being calculated (would probably speed it up as well)

    M.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Link Data to Excel update MP resets or can't place address
    By GEB in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 10-01-2005, 05:30 AM
  2. Displaying lat/lon grid?
    By cd4000 in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 11-12-2004, 09:18 AM
  3. MP 2002 Zipcode Map Grid
    By kb0sei in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 10-09-2002, 09:58 PM
  4. Please could you tell me the grid reference point ....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 06-13-2002, 02:41 AM
  5. Is it possible to update the Address Data (Postal ....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 04-25-2002, 07:11 AM

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 84 85 86 87 88 89 90 91 92 93 94 95 96