missing public tranpsort routes

[riccardoklinger]

When using the export from Oct/05 (public transport) I was expecting some bus routes of public transport for my city like this relation here:

Unfortunately the export just shows the "plattforms" of a stop. Is there a way to get all bus lines?

[michaelmgis]

At the moment, only geometries are extracted as points, lines and polygon. Bus routes are represented as relation which leads to complex combinations of all types of geometries.
The data model within a geopackage requires a distinction of geometries per feature class.

Let's put this issue on a road map where special osm relations are stored as geopackage beside the global data sets.

Thank you

https://wiki.openstreetmap.org/wiki/Types_of_relation#Established_relations

https://imposm.org/docs/imposm3/latest/relations.html

[michaelmgis]

Update: Query geometries in relation is tricky in relatioal databases.
I testet a on-premise overpass-api installation to query the bus routes. It works out for files smaller than 1,5 GB but not for larger extracts.

I continue checking.

[michaelmgis]

New workflow for this certain file: public_transport_with_relations: https://github.com/michaelmgis/osmdata.xyz/blob/master/README.md#recent-improvements-and-changes