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

Optimize location

This is a discussion on Optimize location within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hello, I would like to optmize the location of a distribution centre. Therefore I have data like the postal code ...

  1. #1
    hutjes is offline Junior Member White Belt
    Join Date
    Aug 2006
    Posts
    2

    Optimize location

    Hello,

    I would like to optmize the location of a distribution centre. Therefore I have data like the postal code and the amount of tons sent to the postal code area. Is it possible to show the optimal location where a new distribution centre should be build up?

    Thanks

    best regards

    hutjes

  2. #2
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    You could plot the data (shaded area), and then visually choose a suitable spot.

    If you want something more mathematical, then a bit of custom programming could do this. If straight line distances and postcode centroids are acceptable, then it should be a pretty simple.

    Sophisticated variations would include real distances (or travel times) rather than straight line distances. This would be useful where they were is a significant barrier between important postcodes. Working in the Western Highlands & Islands of Scotland would be an excellent example - the drive from Ayr to the Mull of Kintyre is quite a bit longer than the straight line distance!

    It would be difficult to do better than postcode centroids unless you had more detailed information.

    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  3. #3
    hutjes is offline Junior Member White Belt
    Join Date
    Aug 2006
    Posts
    2
    Thank you Richard,

    but where can I get those solutions? For the short time straight line distances and postcode centroids are acceptable. Can you please send a link, where I can obtain it or post the code so that IŽll be able to do it myself?

    Thanks

    Hutjes

  4. #4
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    You need to find a location object for each postcode (look at the FindResults() and related methods in the help).

    For this Location object you will need its coordinates. You could use OS coordinates if you're upto that, but longitude & latitude would make a good start. MapPoint 2006 (not yet released for Europe) will make this easy, but for now you have to use Gilles Kohl's "CalcPos" routine - search these forums and the mp2kmag site for the VB6 code. (Gilles released it as freeware).

    Then you calculate a simple weighted mean of the coordinates. Use the tons for your weights.

    Eg. TonA = tonnage for location A, etc
    SumTons = Total Tonnage

    Therefore WeightA = TonA / SumTons

    Weighted Centroid Latitude = Sum( of all Latitudes multiplied by their respective weights)
    Weighted Centroid Longitude = Sum( of all Longitudes multiplied by their respective weights)

    Note that the Earth is a sphere, and this will become less accurate over larger areas - the UK is probably about the limit. Using OS coordinates would also help to avoid spherical problems (note that OS coordinates would also limit you to an area about the size of the UK!)

    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Optimize Progress Bar
    By Metod in forum MapPoint Desktop Discussion
    Replies: 15
    Last Post: 11-16-2005, 02:13 PM
  2. Optimize multiple stops
    By petekk in forum MapPoint Desktop Discussion
    Replies: 7
    Last Post: 09-29-2005, 05:09 PM
  3. Speed up optimize for routes + geofencing
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 9
    Last Post: 05-17-2004, 08:12 AM
  4. Optimize Events
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 12-03-2003, 12:45 PM
  5. Optimize and calculate a Route
    By rms62 in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 08-22-2003, 03:55 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