[postgis-devel] When did ST_BuildArea change

Regina Obe lr at pcorp.us
Mon Oct 5 12:21:16 PDT 2020


I noticed this before but came across it again.

 

http://postgis.net/docs/manual-dev/ST_BuildArea.html

 

At the time I created this page which I am guessing was like circa 2008

 

This query created a gaping hole.  Now it doesn't so the docs are wrong

 

SELECT ST_BuildArea(ST_Collect(line,circle))

FROM (SELECT

    ST_Buffer(

        ST_MakeLine(ST_MakePoint(10, 10),ST_MakePoint(190, 190)),

                5)  As line,

    ST_Buffer(ST_GeomFromText('POINT(100 90)'), 50) As circle) As foo;

 

--this creates the same gaping hole

--but using linestrings instead of polygons

SELECT ST_BuildArea(

    ST_Collect(ST_ExteriorRing(line),ST_ExteriorRing(circle))

    )

FROM (SELECT ST_Buffer(

    ST_MakeLine(ST_MakePoint(10, 10),ST_MakePoint(190, 190))

        ,5)  As line,

    ST_Buffer(ST_GeomFromText('POINT(100 90)'), 50) As circle) As foo;

 

Docs say this:

 



 

But when I run in pgAdmin4 I get this:

 

 



 

Does anyone know when this behavior changed and why?  I'm assuming it is a
GEOS change, so cc'ing GEOS dev as well.

 

More depressing is my signature symmetric podded Bee Hive on this page
(circa 2010(

 

http://postgis.net/docs/manual-dev/ST_LongestLine.html

 

Which looked like this (minus the longest line of course) - beautiful isn't
it?

 

 



 

Now looks like a shadow of its former self

 



 

 

 

 

Thanks,

Regina

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20201005/0ff2c685/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 3432 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20201005/0ff2c685/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 6270 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20201005/0ff2c685/attachment-0005.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 18342 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20201005/0ff2c685/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 7629 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20201005/0ff2c685/attachment-0007.png>


More information about the postgis-devel mailing list