[PostGIS] #5699: ERROR: XX000: SQL/MM Spatial exception - geometry crosses an edge

PostGIS trac at osgeo.org
Mon Mar 25 03:33:48 PDT 2024


#5699: ERROR:  XX000: SQL/MM Spatial exception - geometry crosses an edge
--------------------------------+---------------------------
  Reporter:  Lars Aksel Opsahl  |      Owner:  strk
      Type:  defect             |     Status:  assigned
  Priority:  medium             |  Milestone:  PostGIS 3.4.3
 Component:  topology           |    Version:  3.4.x
Resolution:                     |   Keywords:  robustness
--------------------------------+---------------------------
Changes (by strk):

 * keywords:   => robustness
 * owner:  pramsey => strk
 * status:  new => assigned
 * component:  postgis => topology

Comment:

 Reduced testcase
 {{{
 -- Creates a valid topology
 SELECT topology.CreateTopology ('topo_t5699');

 SELECT topology.TopoGeo_addLinestring('topo_t5699', 'LINESTRING(
 16.330791631988802 68.75635661578073,
 16.332533372319826 68.75496886016562,
 16.355483101540106 68.756151360702)');

 SELECT topology.TopoGeo_addLinestring('topo_t5699', 'LINESTRING(
 16.345890311070306 68.75803010362833,
 16.33167771310482 68.75565061843871,
 16.330791631988802 68.75635661578073)');

 SELECT * FROM ValidateTopology('topo_t5699'); -- verify the topology is
 valid

 BEGIN;

 -- Corrupts the topology introducing crossing edges
 SELECT topology.TopoGeo_addLinestring('topo_t5699', 'LINESTRING(
 16.30641253121884 68.75189557630306,
 16.33167771310482 68.75565061843871
 )'::geometry);

 SELECT * FROM ValidateTopology('topo_t5699'); -- crossing edges are found
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5699#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