[Tile-serving] [osm2pgsql-dev/osm2pgsql] Use osm2pgsql to prepare data that can be imported in a routing service (Discussion #2145)

[Tobias]

During the FOSSGIS OSM Unconference we talked about how to scale and add routing features to the cycling quality index project https://www.osm-verkehrswende.org/cqi/. 

First, we want to scale the project to all of Germany using the osm2pgsql setup from radverkehrsatlas.de. This will allow us to create road segments with just the right data processed in the way we need it. Those are categories, cleaned up tags and – of course – the quality index value per segment.

The issue we discussed was, that most / all(?) routing services are build to import a raw or filtered (osmium) OSM file.

However, we end up with a PostgreSQL database.

So the question is, is there any tooling in the ecosystem of osm2pgsql or outside that we could use to export this database back into a file that in turn can be used to be imported by a routing service?

-- 
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2145
You are receiving this because you are subscribed to this thread.

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2145 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20240324/cb165eb3/attachment-0001.htm>