[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] ST_Buffer malfunction on LINESTRING
From: Imre Samu <pella.samu () gmail ! com>
Date: 2020-08-27 11:54:29
Message-ID: CAJnEWw=OHhJso2JZvPz+Uw0mj4ELsHW96Rh3OqJKBOqeOi7AoA () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
> 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@61a36fd6dd8b:/# cat /etc/debian_version
10.5
root@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@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@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@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@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@lists.osgeo.org
> >>>> https://lists.osgeo.org/mailman/listinfo/postgis-users
> >>>
> >>> _______________________________________________
> >>> postgis-users mailing list
> >>> postgis-users@lists.osgeo.org
> >>> https://lists.osgeo.org/mailman/listinfo/postgis-users
> >> _______________________________________________
> >> postgis-users mailing list
> >> postgis-users@lists.osgeo.org
> >> https://lists.osgeo.org/mailman/listinfo/postgis-users
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users@lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/postgis-users
> >
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
[Attachment #5 (text/html)]
<div dir="ltr">> we have plan to upgrade to Debian 10. Hopefully will \
help.<div><br></div><div>You can pre-test with postgis docker images</div><div>( see \
<a href="https://github.com/postgis/docker-postgis">https://github.com/postgis/docker-postgis</a> \
)</div><div><br></div><div>The <b>"postgis/postgis:12-3.0"</b> docker image \
is debian 10.5 and still : <b>3.7.1 Geos</b><br></div><div><br><font \
size="1">root@61a36fd6dd8b:/# cat \
/etc/debian_version<br>10.5<br></font></div><div><font size="1">root@61a36fd6dd8b:/# \
dpkg -l | grep geos<br>ii libgeos-3.7.1:amd64 3.7.1-1 \
amd64 Geometry engine for Geographic Information Systems - C++ \
Library<br>ii libgeos-c1v5:amd64 3.7.1-1 \
amd64 Geometry engine for Geographic Information Systems - C \
Library<br></font><br></div><div>And you can test with the \
<b>"postgis/postgis:12-master"</b> ( with the latest geos, postgis, proj \
)</div><div><span style="font-size:x-small"><br>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</span><br></div><div><font \
size="1"><br></font></div><div><br></div><div>Imre</div><div><br></div><div><br></div></div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">Michal Seidl <<a \
href="mailto:michal.seidl@gmail.com">michal.seidl@gmail.com</a>> ezt írta \
(időpont: 2020. aug. 27., Cs, 12:17):<br></div><blockquote class="gmail_quote" \
style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex">Thanks for your time, we have plan to upgrade to \
Debian 10. Hopefully <br> will help.<br>
<br>
MS<br>
<br>
On 8/26/20 11:45 PM, Paul Ramsey wrote:<br>
> "somehow", doh!<br>
> If JTS is not working, we did it accidentally, yay<br>
> P<br>
> <br>
>> On Aug 26, 2020, at 2:36 PM, Mike Taves <<a \
href="mailto:mwtoews@gmail.com" target="_blank">mwtoews@gmail.com</a>> wrote:<br> \
>><br> >> I can confirm that this was an issue for previous GEOS, but it \
is now<br> >> fixed in master, somehow.<br>
>><br>
>> However, I'm getting the same odd behaviour with JTS testbuilder \
(from<br> >> master, I think). Martin could possibly confirm.<br>
>><br>
>> On Thu, 27 Aug 2020 at 03:42, Paul Ramsey <<a \
href="mailto:pramsey@cleverelephant.ca" \
target="_blank">pramsey@cleverelephant.ca</a>> wrote:<br> >>><br>
>>> Try some more recent versions. I'm finding with my very-fresh GEOS \
I'm getting a poly-with-hole, just as you are.<br> >>> P.<br>
>>><br>
>>>> On Aug 26, 2020, at 2:58 AM, Michal Seidl <<a \
href="mailto:michal.seidl@gmail.com" target="_blank">michal.seidl@gmail.com</a>> \
wrote:<br> >>>><br>
>>>> Hello,<br>
>>>> I am facing this malfunction of ST_Buffer. The result of closed \
LINESTRING buffer should be polygon with hole but regular polygon is returned?<br> \
>>>><br> >>>> I am using:<br>
>>>> 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<br> >>>><br>
>>>> This is the case<br>
>>>> 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<br> >>>><br>
>>>> If I enlarge buffer distance to 0.01 result looks OK. Also if I \
change from default propeties to endcap=square join=miter helps?<br> \
>>>><br> >>>> Anu suggestions?<br>
>>>><br>
>>>> Thanks Michal S.<br>
>>>> _______________________________________________<br>
>>>> postgis-users mailing list<br>
>>>> <a href="mailto:postgis-users@lists.osgeo.org" \
target="_blank">postgis-users@lists.osgeo.org</a><br> >>>> <a \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" \
target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br> \
>>><br> >>> _______________________________________________<br>
>>> postgis-users mailing list<br>
>>> <a href="mailto:postgis-users@lists.osgeo.org" \
target="_blank">postgis-users@lists.osgeo.org</a><br> >>> <a \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" \
target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br> \
>> _______________________________________________<br> >> postgis-users \
mailing list<br> >> <a href="mailto:postgis-users@lists.osgeo.org" \
target="_blank">postgis-users@lists.osgeo.org</a><br> >> <a \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" \
target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br> > \
<br> > _______________________________________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@lists.osgeo.org" \
target="_blank">postgis-users@lists.osgeo.org</a><br> > <a \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" \
target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br> > \
<br> _______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" \
target="_blank">postgis-users@lists.osgeo.org</a><br> <a \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" \
target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote></div>
[Attachment #6 (text/plain)]
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic