[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] Geometry problems
From: Darafei_"Komяpa"_Praliaskouski <me () komzpa ! net>
Date: 2018-10-10 13:57:03
Message-ID: CAC8Q8tKUkFzH4rHG7ZPRVA4SaCc2y6VxRuH5AZ6T1xWB30+F6w () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
PostGIS 2.1 is End of Life and the only way to resolve issues in it should
be upgrading to latest version:
https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS
ср, 10 окт. 2018 г. в 16:49, Agustin Ignacio Genoves <
agustingenoves@gmail.com>:
> Here we have installed postgis 2.1.4. I read that in version 2.2 onwards
> if they are binary equal, it returns true even if the geometry is invalid.
>
> El mié., 10 oct. 2018 a las 10:43, Daniel Baston (<dbaston@gmail.com>)
> escribió:
>
>> Plugging the WKT directly into JTS TestBuilder shows that
>> equals=false, even if you paste the same WKT for both inputs. The
>> geometry is invalid, but I would have expected Geometry.equals() to
>> report a correct answer or throw an exception.
>>
>> PostGIS 2.2+ should return 'true' in this case, because it does a
>> memcmp before ever sending the geometry to GEOSEquals.
>>
>> Dan
>>
>> On Wed, Oct 10, 2018 at 9:29 AM Sandro Santilli <strk@kbt.io> wrote:
>> >
>> > On Wed, Oct 10, 2018 at 10:07:20AM -0300, Agustin Ignacio Genoves wrote:
>> >
>> > > when I compared two identical geometries with the function st_equals
>> () it
>> > > returns false. I give details of the geometries and the query.
>> >
>> > When you print the geometries in WKT form you loose precision
>> > (due to the limited number of decimal digits we print).
>> >
>> > Get an HEXWKB representation of those two geometries and I bet you'll
>> > find a difference.
>> >
>> > --strk;
>> > _______________________________________________
>> > 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
--
Darafei Praliaskouski
Support me: http://patreon.com/komzpa
[Attachment #5 (text/html)]
<div dir="ltr"><div>PostGIS 2.1 is End of Life and the only way to resolve issues in \
it should be upgrading to latest version:</div><a \
href="https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS">https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS</a> \
<br><br><div class="gmail_quote"><div dir="ltr">ср, 10 окт. 2018 г. в 16:49, \
Agustin Ignacio Genoves <<a \
href="mailto:agustingenoves@gmail.com">agustingenoves@gmail.com</a>>:<br></div><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr"><div dir="ltr">Here we have installed postgis \
2.1.4. I read that in version 2.2 onwards if they are binary equal, it returns true \
even if the geometry is invalid.<br></div></div><br><div class="gmail_quote"><div \
dir="ltr">El mié., 10 oct. 2018 a las 10:43, Daniel Baston (<<a \
href="mailto:dbaston@gmail.com" target="_blank">dbaston@gmail.com</a>>) \
escribió:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex">Plugging the WKT directly into JTS \
TestBuilder shows that<br> equals=false, even if you paste the same WKT for both \
inputs. The<br> geometry is invalid, but I would have expected Geometry.equals() \
to<br> report a correct answer or throw an exception.<br>
<br>
PostGIS 2.2+ should return 'true' in this case, because it does a<br>
memcmp before ever sending the geometry to GEOSEquals.<br>
<br>
Dan<br>
<br>
On Wed, Oct 10, 2018 at 9:29 AM Sandro Santilli <<a href="mailto:strk@kbt.io" \
target="_blank">strk@kbt.io</a>> wrote:<br> ><br>
> On Wed, Oct 10, 2018 at 10:07:20AM -0300, Agustin Ignacio Genoves wrote:<br>
><br>
> > when I compared two identical geometries with the function st_equals () \
it<br> > > returns false. I give details of the geometries and the query.<br>
><br>
> When you print the geometries in WKT form you loose precision<br>
> (due to the limited number of decimal digits we print).<br>
><br>
> Get an HEXWKB representation of those two geometries and I bet you'll<br>
> find a difference.<br>
><br>
> --strk;<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></blockquote></div>
_______________________________________________<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></div>-- \
<br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div \
dir="ltr">Darafei Praliaskouski<br>Support me: <a \
href="http://patreon.com/komzpa">http://patreon.com/komzpa</a></div></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