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

[dch0ph]

I've made some progress with this - compiling the master version include the id caching. Combining `turning-circles.lua` into the complex Carto configuration has been a bit tricky, and my [version to date](https://gist.github.com/dch0ph/59c7f7ad8cbc3f34766b3fb463e40817) is only partially working.

Issues noted:

1. I've been keeping the "linking tables" quite minimal. The equivalent of the `turning-circles` table in the example, `special_nodes_on_highways` has no data columns. But I wasn't allowed to set `table_columns['special_nodes_on_highways']` to an empty set of columns, `{}`, hence the `dummy` column. Otherwise this table functions as expected. 
2. The "way" based table `highways_with_special_nodes` has proved tricky. I wasn't sure how to handle the segmenting of very long ways, since this could produce a multilinestring. I've currently put the "checking for special nodes" before the segmenting. I'm also missing the `transform(3857)` so this isn't going to work anyway, but you can see my dilemma.
3. The insert into `highways_with_special_nodes` is quietly failing (the inserts instructions are reached, but no rows appear in the table). Mismatched geometries?


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

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