[postgis-users] ST_Buffer malfunction on LINESTRING

Imre Samu pella.samu at gmail.com
Thu Aug 27 04:54:29 PDT 2020


> we have plan to upgrade to Debian 10. Hopefully will help.

You can pre-test with postgis docker images
( see https://github.com/postgis/docker-postgis )

The *"postgis/postgis:12-3.0"* docker image  is debian 10.5 and  still
:  *3.7.1
Geos*

root at 61a36fd6dd8b:/# cat /etc/debian_version
10.5
root at 61a36fd6dd8b:/# dpkg -l  | grep geos
ii  libgeos-3.7.1:amd64                  3.7.1-1                     amd64
       Geometry engine for Geographic Information Systems - C++ Library
ii  libgeos-c1v5:amd64                   3.7.1-1                     amd64
       Geometry engine for Geographic Information Systems - C Library

And you can test with the *"postgis/postgis:12-master"*  ( with the latest
geos, postgis, proj )

POSTGIS="3.1.0dev 3d049c8" [EXTENSION] PGSQL="120"
GEOS="3.9.0dev-CAPI-1.14.0" PROJ="7.2.0" LIBXML="2.9.4" LIBJSON="0.12.1"
LIBPROTOBUF="1.3.1" WAGYU="0.5.0 (Internal)" TOPOLOGY


Imre



Michal Seidl <michal.seidl at gmail.com> ezt írta (időpont: 2020. aug. 27.,
Cs, 12:17):

> Thanks for your time, we have plan to upgrade to Debian 10. Hopefully
> will help.
>
> MS
>
> On 8/26/20 11:45 PM, Paul Ramsey wrote:
> > "somehow", doh!
> > If JTS is not working, we did it accidentally, yay
> > P
> >
> >> On Aug 26, 2020, at 2:36 PM, Mike Taves <mwtoews at gmail.com> wrote:
> >>
> >> I can confirm that this was an issue for previous GEOS, but it is now
> >> fixed in master, somehow.
> >>
> >> However, I'm getting the same odd behaviour with JTS testbuilder (from
> >> master, I think). Martin could possibly confirm.
> >>
> >> On Thu, 27 Aug 2020 at 03:42, Paul Ramsey <pramsey at cleverelephant.ca>
> wrote:
> >>>
> >>> Try some more recent versions. I'm finding with my very-fresh GEOS I'm
> getting a poly-with-hole, just as you are.
> >>> P.
> >>>
> >>>> On Aug 26, 2020, at 2:58 AM, Michal Seidl <michal.seidl at gmail.com>
> wrote:
> >>>>
> >>>> Hello,
> >>>> I am facing this malfunction of ST_Buffer. The result of closed
> LINESTRING buffer should be polygon with hole but regular polygon is
> returned?
> >>>>
> >>>> I am using:
> >>>> POSTGIS="2.1.4 r12966" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel.
> 4.8.0, 6 March 2012" GDAL="GDAL 1.10.1, released 2013/08/26" LIBXML="2.9.1"
> LIBJSON="UNKNOWN" RASTER
> >>>>
> >>>> This is the case
> >>>> ST_AsText(ST_Buffer(ST_GeomFromText('LINESTRING(-632707.74
> -1143841.28,-632728.28 -1143828.04,-632761.31 -1143818.48,-632747.42
> -1143835.92,-632727.41 -1143861.05,-632687.29 -1143893.42,-632587.04
> -1143963.89,-632469.61 -1144047.39,-632439.8 -1144068.97,-632426.45
> -1144083.11,-632422.85 -1144089.95,-632423.07 -1144099.75,-632426.7
> -1144107.51,-632427.54 -1144108.41,-632426.4 -1144109.46,-632425.57
> -1144108.56,-632411.95 -1144094.85,-632403.98 -1144087.66,-632393.94
> -1144079.17,-632371.19 -1144059.68,-632381.11 -1144052.77,-632398.98
> -1144062.1,-632407.15 -1144063.46,-632420.6 -1144058,-632457.53
> -1144030.85,-632521.98 -1143975.36,-632585.23 -1143928.05,-632634.76
> -1143892.41,-632627.84 -1143886.95,-632631.46 -1143883.96,-632637.6
> -1143889.98,-632684 -1143856.57,-632707.74 -1143841.28)'), 0.001)) AS
> wkt_geometry
> >>>>
> >>>> If I enlarge buffer distance to 0.01 result looks OK. Also if I
> change from default propeties to endcap=square join=miter helps?
> >>>>
> >>>> Anu suggestions?
> >>>>
> >>>> Thanks Michal S.
> >>>> _______________________________________________
> >>>> postgis-users mailing list
> >>>> postgis-users at lists.osgeo.org
> >>>> https://lists.osgeo.org/mailman/listinfo/postgis-users
> >>>
> >>> _______________________________________________
> >>> postgis-users mailing list
> >>> postgis-users at lists.osgeo.org
> >>> https://lists.osgeo.org/mailman/listinfo/postgis-users
> >> _______________________________________________
> >> postgis-users mailing list
> >> postgis-users at lists.osgeo.org
> >> https://lists.osgeo.org/mailman/listinfo/postgis-users
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/postgis-users
> >
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200827/a81116b9/attachment.html>


More information about the postgis-users mailing list