[Tile-serving] [osm2pgsql-dev/osm2pgsql] Does osm2pgsql with flex output ignore nodes with no tags? (Discussion #2214)

[Jochen Topf]

You need the -x, --extra-attributes option to also get the non-tagged nodes, ways, and relations. But we aware that there are two orders of magnitude more untagged nodes than tagged nodes, so this will take a while.

There is currently no way to access the individual point geometries for way nodes. You'd have to use some trick like importing the linestring and using a trigger in the database to get the points from the linestring. Or, if you have a table with all nodes anyway, get them from there later.

Lastly here is a suggestion: Use the middle tables which osm2pgsql will create for you in `--slim` mode instead of your nodes table. It will not have a geometry column, but lat/lon columns. But you can easily add a view adding the geometry with `ST_MakePoint()`. Depending on access patterns (indexes?) this might or might not work for you.

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

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2214/comments/10110941 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20240721/5010cf5e/attachment.htm>