[Tile-serving] [openstreetmap/osm2pgsql] Centroid of linestrings (Discussion #1772)

[Sarah Hoffmann]

You are mixing types up here. The generic geometry type in PostGIS is GEOMETRY, not GEOMETRYCOLLECTION. You can define a column of type geometry and then fill it with `as_point()` for nodes, `as_linestring()` for ways and `as_geometrycollection()` for relations. Then your trigger can do further processing. It can determine the actual geometry type with `ST_GeometryType()`.

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

Message ID: <openstreetmap/osm2pgsql/repo-discussions/1772/comments/3711970 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20220922/b31039fe/attachment.htm>