In OpenStreetMap (OSM) road data there is information about whether or not a road feature is a bridge or not (boolean). However, when importing into a postgreSQL data base for routing (pgrouting), using osm2pgrouting, I cannot find information whether a feature is a bridge or not. Is it possible to tell osm2pgrouting, or osm2po, to include this information somehow? Maybe in the mapconfig.xml?

I understand that OSM2PGROUTING uses the bridge-information for excluding nodes at a bridge-road intersection, but I need that information in later analysis.

Here is the column-heads for OSM road data: OSM_columns


  • Windows 10
  • Postgis 2.2.1
  • postgreSQL 9.5
  • pgrouting: 2.1.0

Speaking for pgRouting it keeps the original OSM ID as attribute, so you can load the OSM data with osm2psql for example into your database and afterwards link the tables using the OSM ID.

  • Thanks for the tip! This will work. However, I'm now struggling with the osm2pgsql .style-file. Ideally, I would like to narrow down the imported lines_table to just include the osm_id and bridge columns. Is this possible? How would this be specified in the .style-file for osm2pgsql?
    – Latus
    Mar 23 '16 at 13:05

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.