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

[Zohreh Fallahnejad]

I used the osm2pgsql tool to insert the `openstreetmap` data for france into Postgres. I used their default.style as the style file. 
![sc12](https://github.com/osm2pgsql-dev/osm2pgsql/assets/5528548/496ecb46-9fe2-4dbb-b35c-b87298c8b444)


This tool created four tables:
* planet_osm_line: contains all imported ways
* planet_osm_point: contains all imported nodes with tags
* planet_osm_polygon: contains all imported polygons. 
* planet_osm_roads: contains a subset of planet_osm_line suitable for rendering at low zoom levels

I was wondering where are all the relations in these tables. It seems that there are other tables like `planet_osm_rels` which might include what I want but they are missing here. How can I have this table too? Is there another way to have relations in the tables too?

I also want to know how to extract the connection between ways and nodes. 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? 

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

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