Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 5 down vote accepted

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.

share|improve this answer
Thanks @underdark.. I have done what you suggest and I am able to create the route and visualize on Map.. But I am facing a new issue, and I would like to know if you can help me.. As the map has nodes.. the route starts and ends exactly where there is a node.. so if I request a route from a place that is between two nodes.. it will actually starts from the nearest node, and it is not what I need.. I was wondering if there is a way to create more nodes in the map to reduce the distance between each pair.. or if there is another solution for this.. what do you think about it? – Roberto Ferraz Nov 19 '12 at 13:43
There are some examples of people solving this problem with pgRouting. Check out… – maw269 Dec 5 '12 at 16:32

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.

share|improve this answer

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

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

share|improve this answer
Hey @RyanDalton, thank you for your reply.. I am looking for a web based solution.. I want to create an website with this service.. – Roberto Ferraz Dec 12 '12 at 17:38

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.