[postgis-tickets] [PostGIS] #3647: non-noded intersection error when running st_node

[PostGIS]

#3647: non-noded intersection error when running st_node
-------------------------------+---------------------------
 Reporter:  mathiasversichele  |      Owner:  pramsey
     Type:  defect             |     Status:  new
 Priority:  medium             |  Milestone:  PostGIS 2.3.1
Component:  postgis            |    Version:  2.2.x
 Keywords:                     |
-------------------------------+---------------------------
 Hi all,

 I've been struggling with "non intersecting node" issues when trying to
 run st_node, which seems weird to me as st_node is supposed to fix these
 issues in the first place, right ?

 The table dump in attachment illustrates the problem.

 When running the following query:

 {{{
 select st_node(st_collect(geom)) from input_geoms;
 }}}

 I get the following error:

 ERROR:  GEOSUnaryUnion: TopologyException: found non-noded intersection
 between LINESTRING (1.0708e+06 786844, 1.07094e+06 786875) and LINESTRING
 (1.07097e+06 786883, 1.0708e+06 786844) at 1070922.7377618756
 786871.60839152802

 The input geoms are already snapped to 10meters precision.

 I'm running
 {{{
 POSTGIS="2.1.8 r13780" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6
 March 2012" GDAL="GDAL 1.11.2, released 2015/02/10" LIBXML="2.9.1"
 LIBJSON="UNKNOWN" RASTER
 }}}

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3647>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.