Hello,

How can I query OSM to give me travel distances between adresses from access VBA?

regards

asked 22 Sep, 14:28

thedan85's gravatar image

thedan85
162
accept rate: 0%


You cannot query OSM to do this, you need to query a routing engine. You can either install a routing engine yourself - open source software includes OSRM, Graphhopper, Valhalla - or you can use a routing engine run (and paid for) by someone else, for example the free offers on graphhopper.com (running Graphhopper) or routing.openstreetmap.de (running OSRM). These servers have usage policies and limits - it's ok to make a couple hundred queries for yourself but if you want to use it intensively or commercially, double-check what you are allowed to do.

Generally these servers will expect you to make a HTTP request and reply with a JSON message that you can then process in VBA. The precise formatting of the request and response depend on which routing engine you are using.

permanent link

answered 22 Sep, 14:35

Frederik%20Ramm's gravatar image

Frederik Ramm ♦
70.6k826391105
accept rate: 24%

edited 22 Sep, 14:37

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×79
×2

question asked: 22 Sep, 14:28

question was seen: 120 times

last updated: 22 Sep, 14:37

powered by OSQA