[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] st_intersects not working
From:       Sandro Santilli <strk () keybit ! net>
Date:       2015-02-12 8:45:31
Message-ID: 20150212084531.GA5540 () localhost
[Download RAW message or body]

On Wed, Feb 11, 2015 at 02:25:08PM -0500, Rhys A.D. Stewart wrote:
> Greetings all,
> 
> I am working on a set of data where I have noded linestrings. All
> linestrings have just two points and the nodes were derived from the
> endpoints.
> 
> I've found one instance where st_intersects and st_equals return the
> incorrect value (AFAICT).
...
> I did a select into a new schema and the same issue occurred. I did an
> `update table set g = st_astext(g)::geometry` and it works fine after that.

Sounds like a small coordinate difference that's not enough to get a digit
printed when converted to text. Compare the HEXWKB to spot the difference.
You can use ST_SnapToGrid to ensure all vertexes fall on the same grid.

--strk;
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]