[Tile-serving] [osm2pgsql-dev/osm2pgsql] Where are all the relations? How to extract connection between ways and nodes? (Discussion #2189)

[SomeoneElseOSM]

> I was wondering where are all the relations in these tables.

Relations with (multi)polygon geometry will be in planet_osm_polygon.

> I don't see any connection between the ways in planet_osm_polygon table and the points in planet_osm_point table. How can I have this connection in the generated tables too?

That rather depends on what you are trying to do.  osm2pgsql supports [more than one](https://osm2pgsql.org/doc/manual.html) output type, and another might be more appropriate, depending on what you are trying to do.  What columns you get, and whether something in the input is treated as an area or a closed line, is also under your control.  See e.g. [here](https://osm2pgsql.org/doc/manual.html#lua-tag-transformations).

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

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2189/comments/9568466 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20240527/e7a5238d/attachment.htm>