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

PostGIS trac at osgeo.org
Thu Sep 24 08:06:51 PDT 2020


#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 strk):

 Simplified test:
 {{{
 select topology.DropTopology('t4758');

 select topology.CreateTopology ('t4758', 0, 1e-06);

 select topology.TopoGeo_addLinestring('t4758',
 'LINESTRING(
 11.38327215  60.4081942,
 11.3826176   60.4089484)
 '); -- length: 0.0009986257269390762 (=~ 1e-3)

 select topology.TopoGeo_addLinestring('t4758',
 'LINESTRING(
 11.3832721  60.408194249999994,
 11.38327215 60.4081942)
 '); -- length: 7.071067643283874e-08
     -- distance of start point from first edge: 4.9893601355070966e-09

 select topology.TopoGeo_addLinestring('t4758',
 'LINESTRING(
 11.38330505 60.408239599999995,
 11.3832721  60.408194249999994)
 '); -- length:  5.6056444769047025e-05
 }}}

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