[postgis-tickets] [PostGIS] #4758: ERROR: XX000: SQL/MM Spatial exception - geometry crosses edge 2, LOCATION: pg_error, lwgeom_pg.c:250

[PostGIS]

#4758: ERROR:  XX000: SQL/MM Spatial exception - geometry crosses edge 2,
LOCATION:  pg_error, lwgeom_pg.c:250
-----------------------+---------------------------
  Reporter:  laopsahl  |      Owner:  pramsey
      Type:  defect    |     Status:  new
  Priority:  medium    |  Milestone:  PostGIS 3.1.0
 Component:  postgis   |    Version:  3.0.x
Resolution:            |   Keywords:
-----------------------+---------------------------

Comment (by laopsahl):

 Thanks for the the explanations and the patch, yes I do agree with you
 that is better to not change existing edges, but using your patch above
 works quite good thou.

 The number of error was reduced to 123 cases for the test with 20 mill.
 edges, from 252 errors. (I now found out that the case with with 625 error
 was before I added the code that tries fix error by deleting and re adding
 edges.) This errors left does not seem to cause any information loss,
 since we use different methods with retry.

 I have also been testing a smaller dataset with 1.5 million edges where we
 have also have some polygons that does have a neighbors and there we
 reduced the number of error from 24 to 15.

 I did not see any other side effects either when I checked problem areas,
 but I need to more checking on this.

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