![]() Google, for exapmle, has a pretty solid web service called "DistanceMatrix" calculating distances between geographical locations - anywhere on the world, in any input format. Google DistanceMatrixīut more cloud-companies exist out there. Still, neither gives me just the distance). ![]() There's also the Bing Maps API, but I didn't find anything there to just calculate travel distances (I think geocoding API's are the closest, maybe combined with the routes API. A few quick searches showed that there are some services available offering travel distances, but they're pretty limited - requiring coördinates as input (of course, customers always stores addresses as coördinates) or being limited to Great Britain. Integrated with DQS, it would be an easy game to calculate travel distances, right? So, as a Microsoft-oriented BI guy, my first guess to look at was Azure Datamarket (now included in Azure Marketplace). But look at the calendar - it's 2016! Cloud, baby! Azure DataMarket Use a cloud-service to give a somewhat more accurate estimateīack in 2005 - when cloud services weren't that widespread - I'd consider the first option.Translate locations to geo-coordinates, then calculating distance as the crow flies. ![]() For example: What is the distance I travel when I, living at Kalverstraat 7 (Amsterdam) commute five days a week to my customer in Paris (1, rue Victor Cousin)? By the way: it should be calculated for all employees, for all customer locations, so manually entering distances is not considered an option. Last week, I had an interesting question from one of my clients about estimates of planned commute distances.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |