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

[mboeringa]

@mboeringa commented on this pull request.



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

> on the spheroid

Shouldn't this read 'on the sphere'?

By the way, I recommend you to thoroughly test this, also with data near the date line. I ran into serious issues with crashes with Planet wide (generalized) data and PostGIS ST_Area and spherical calculations when I first attempted implementing both spherical and spheroidal area calculations, and had to switch to spheroidal (ST_Area(geography,true)) to overcome these issues. ST_Area for some reason failed with spherical calculations. 

I have never been able to track down the real cause, and simply worked around it with the (slower) spheroidal calculations, but if this solution for osm2pgsql relies on some of the same libraries as PostGIS, it may encounter similar issues if it hasn't been fixed in the mean time.



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

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