[Tile-serving] [osm2pgsql-dev/osm2pgsql] Geography datatype (Discussion #2152)

[Jochen Topf]

Is there any need for supporting other projections except 4326 for the geography data type? If not then there is an easy backwards-compatible way to implement this. The `projection` parameter on geometry columns already support either a number (ie SRID) or a few strings like `mercator` and `latlon` (https://github.com/osm2pgsql-dev/osm2pgsql/blob/master/src/flex-table-column.cpp#L101-L125). This could be extended to allow `geography` as name, use -1 or something like that as `m_srid` and then use that in https://github.com/osm2pgsql-dev/osm2pgsql/blob/master/src/flex-table-column.cpp#L127-L178 to switch to geography type. Feel free to create a PR for that. And yes, we'll need some tests.

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

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2152/comments/8993303 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20240403/8a9c9676/attachment.htm>