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

PostGIS trac at osgeo.org
Wed Oct 25 04:15:02 PDT 2017


#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:  closed
  Priority:  medium      |  Milestone:  PostGIS 2.5.0
 Component:  topology    |    Version:  2.3.x
Resolution:  fixed       |   Keywords:  totopogeom, ERROR:  XX000: SQL/MM
                         |  Spatial exception - geometry crosses
-------------------------+-------------------------------------------------

Comment (by laopsahl):

 Thanks starting to be more robust now so  I did a bigger test with the new
 code.

 I started with a simple feature data set of 92746 polygons (11657424
 points) and another  dataset of 8754 polygons (846345 points). Then I
 convert both data sets to Postgis Topology and then I try to merge the
 small data set into big data by using snapto in Postgis Topology. I then
 get problem with for 747 of these points. Most of this errors will not
 cause problems for the because we already have line there, but some
 failing snapto will cause polygons not to close .

 I will create new bug report with more example.

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


More information about the postgis-tickets mailing list