osm2pgrouting works without giving any errors but most of the roads have lost their geometry.

Result is ;

enter image description here

What I've done so far;

  1. OSM Data downloaded from http://download.geofabrik.de/ in pbf format.
  2. Data clipped and converted to osm format using the command below

osmconvert turkey-latest.pbf -B=ankara.poly -o=ankara.osm

  1. Data is inserted into PostgreSQL using the command below;

    osm2pgrouting --f ankara.osm --conf mapconfig.xml --dbname=workshop --host=localhost -p 5432 --username postgres -W 1 --clean

  • 1
    How did you create the image above? Which SQL statement did you use? – mmd Nov 26 '18 at 8:46
  • Hi, I've taken the screen shot from QGIS, I've added PostgreSQL table as layer. – Capan Nov 26 '18 at 8:47
  • 1
    Which table specifically? Postgres is the name of your database and won't tell us what table contents you're showing here. – mmd Nov 26 '18 at 8:48
  • Not the OP, but I've been seeing this in both the (prefix-)ways table and the osm_ways table. – ajlane Jan 20 '20 at 21:51

Try adding --complete-ways to your osmconvert command.


It seems that these errors can appear when osm2pgrouting encounters missing or incorrectly ordered data. Adding --complete-ways keeps features that cross the boundary intact.


I think you should try "osm2pgsql" instead of "osm2pgrouting".

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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