[postgis-tickets] [PostGIS] #3838: topology.toTopoGeom fails with ERROR: XX000: SQL/MM Spatial exception - geometry crosses, when using tolerance 10 meter

[PostGIS]

#3838: topology.toTopoGeom fails with ERROR:  XX000: SQL/MM Spatial exception -
geometry crosses,  when using tolerance 10 meter
-------------------------+-------------------------------------------------
  Reporter:  laopsahl    |      Owner:  strk
      Type:  defect      |     Status:  assigned
  Priority:  medium      |  Milestone:  PostGIS 2.3.5
 Component:  topology    |    Version:  2.3.x
Resolution:              |   Keywords:  totopogeom, ERROR:  XX000: SQL/MM
                         |  Spatial exception - geometry crosses
-------------------------+-------------------------------------------------

Comment (by strk):

 The point is: if you tolerate 10 meters, you should not allow lines with
 points closer than 10 meters each other. Those lines, even if drawn by
 users, can be cleaned up before being sent to the topology, using
 ST_RemoveRepeatedPoints or ST_Simplify. An already-built topology can also
 be cleaned to a target tolerance by using the same functions and
 ST_ChangeEdgeGeom.

 That said, the snapping method used during topology building (implemented
 in GEOS) is not stable enough, so it would be useful to rewrite it.

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3838#comment:12>
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.