[postgis-users] Geometry problems

Agustin Ignacio Genoves agustingenoves at gmail.com
Wed Oct 10 06:48:08 PDT 2018


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 at 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 at 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 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/20181010/572259eb/attachment.html>


More information about the postgis-users mailing list