I need a tool to find the distance between two points whose longitude and latitude are given. I am making an application so it will require bulk queries, so i cannot use google maps distance matrix API that could tell me the distance via road, airways or any other.
So I turned up to OSM data, i downloaded the OSM data and then pgrouting tool. But I am unable to find the distance via road between two points from this data stored in postgres table.
Any help regarding how to fetch this data from the postgresql db or any other resource you know that can accomplish my goal will be greatly appreciated.
Best Answer
OSM has a page dedicated to routing, which is worth going over:
http://wiki.openstreetmap.org/wiki/Routing
There is a special tool for importing OSM data into a PGRouting system and generating the required structure:
https://github.com/pgRouting/osm2pgrouting
Lastly, there is a workshop tutorial on getting routing working with OSM data here:
http://workshop.pgrouting.org/index.html