[Tile-serving] [osm2pgsql-dev/osm2pgsql] Linking between nodes and ways (Discussion #2455)

[Jochen Topf]

* re 4: no ways can be added from the `process_relation`, because that is processing relations. Should be fine.
* re 5: no, you don't have access to that table, that's the way it is at the moment, you have to join later
* re 6: it is correct that the spatial index is on the node, because that's what you are rendering. What makes it "way-based" is that there should an index on the way id, in this case the "osm_id" column, which is needed for updates. If you don't have that index, something is wrong.
* re 7: you don't need the join with the `planet_osm_line` table, because you can write everything that's needed from that table into the `planet_osm_highways_with_special_nodes` table, in this case the highway type, which you already do and the z_order which you don't. 

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

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2455/comments/16626474 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20260419/1e196ca9/attachment.htm>