[Tile-serving] [openstreetmap/osm2pgsql] Add spherical_area() function (PR #2019)

[Jochen Topf]

@joto commented on this pull request.



>      { column = 'area', type = 'real' },
+    -- In this column we'll put the true area calculated on the spheroid

We don't use the same code PostGIS does but the code from boost::geometry which might or might not be better, different or whatever. I rely on that code like I do for everything we get from a library, so yes, there are some tests, but other than that I just expect this to work.

The description of the various area() functions are a bit fuzzy about whether they use a sphere or a spheroid and there are different versions of those functions etc. So I am going with spheroid because it sounds cooler and because technically a sphere is a special case of a spheroid so I am on the safe side. :-)

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/pull/2019#discussion_r1278531025
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/osm2pgsql/pull/2019/review/1553603060 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20230730/2396a51a/attachment.htm>