Forum Discussion

MYDATASTORY's avatar
MYDATASTORY
Resolver I
6 years ago
Solved

How to Calculate Distance on map from one Postcode to Another Postcode

Hi Everyone, Please provide advice/steps the most efficient way to calculate distance from Point A to Point B on Google map. For example Postcode W1 (W1 is the postcode district in Central).. to W2...
Need Help
  • MYDATASTORY's avatar
    MYDATASTORY
    6 years ago

    Greg_Deckler Wow this is fantastic, let me have a good look at it tomorrow so I can accept the solution , I'll let you know, but definitely amazing...

ToughTake's avatar
ToughTake
Frequent Visitor
2 years ago

Thanks Greg_Deckler 

 

I have had a quick look but I cannot quite figure out how its working, or how I could get it to work for my use.

 

If I have a list of postcodes with long and lat for each in a table, how would I use this to produce a table of the closest other postcodes? Ideally I would love to have the actaul distance in miles listed as well.

 

Any chance you could point me in the right direction please?

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    2 years ago

    ToughTake Sure, can you post a sample of the data you have? Then I can mock things up.

  • ToughTake's avatar
    ToughTake
    Frequent Visitor
    2 years ago

    Morning Greg_Deckler 

     

    Was the sample data enough to work with, did you need anything else from me?

     

    Thank you again for you help.

     

     

  • ToughTake's avatar
    ToughTake
    Frequent Visitor
    2 years ago

    Hi Greg_Deckler 

     

    Just checking if you have had chance to look into this yet?

     

    Happy to provide any more information that you might need?