Is there an opensource software to route openstreetMap data based on database?

Question

I have a project that consists in aggregate traffic information on OpenStreetMap for routing proposes. My first idea is to use the OSM data from the region on a database, so I can aggregate the traffic information on the table, probably adjusting the cost column.

The problem is that all the routing software that I have already downloaded and tested creates a bin or obj file from the OSM instead of working with databases, so does anyone know an opensource software that creates and draw routes on OpenStreemaps based on database?

Answer 1

I would start with the OpenStreetMap Wiki. From there, I would say that pgRouting is one of the more popular OS DB routing tools. If going with the pgRouting approach, OSM2PO is a popular way of creating the sql import statements for large regions of OSM data, as I heard that the usual database import utility used with pgRouting, osm2pgrouting, has trouble with larger datasets.

Answer 2

In addition to the suggestion by maw269 (which I also recommend), you can do OSM routing with SpatiaLite. There is a step-by-step tutorial on the SpatiaLite documentation page (direct link to PDF).

Obviously PostGIS will give you better scalability / multi-user capability, but if your needs are limited (in particular, the area is small), then SpatiaLite may be easier to get set up.

Answer 3

if your data are not too complex, you could also try the road graph plugin in qgis. more infos here:

• http://underdark.wordpress.com/2011/01/14/calculating-shortest-path-in-qgis-using-roadgraph-plugin/
• http://linfiniti.com/2011/03/introducing-the-qgis-roadgraph-plugin/
• http://mauriciodepaulo.blogspot.co.at/2011/01/travelling-through-brazil-with-quantum.html

the roadgraph plugin accepts any vector-layer with lines , so you could use e.g. not only shapefiles but also spatialite, osm ...

Answer 4

Routing using OSM data, you say? Check out OSRM - https://project-osrm.org/

If you can run a docker container, you can set up a routing server in less than an hour with OSRM. You can get route steps or entire route geometries between points. You can do lots of other cool things that are covered in the docs.