Driven kilometres between two points

• dbalmf

  SSCrazy

  Points: 2063

  More actions

  March 21, 2014 at 5:29 am

  #284767

  Hi All,

  I have been given the task of generating the number of kilometres between a warehouse and a list of customers by road. I have the post codes (zip codes) for the warehouse and all the customers.

  What I need to end up with is a table which has warehouse, customer, distance.

  So I'll need somesort of mapping tool, maybe a web service, that I can feed coordinates or postcodes into and get back the kilometres. there are several thousand to plan so I'm looking to automate this.

  Any ideas?

  ============================================================
  David

  http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  March 21, 2014 at 5:58 am

  #1699053

  Maybe you can use the Google Maps API?

  http://stackoverflow.com/questions/1502590/calculate-distance-between-two-points-in-google-maps-v3

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP