[PostGIS] #6129: Missing area with topology.ST_GetFaceGeometry('arstat_2026_overlay_02_348',101383), but alle edges seems to be prensent

[PostGIS]

#6129: Missing area with
topology.ST_GetFaceGeometry('arstat_2026_overlay_02_348',101383), but alle
edges seems to be prensent
--------------------------------+---------------------------
  Reporter:  Lars Aksel Opsahl  |      Owner:  strk
      Type:  defect             |     Status:  new
  Priority:  medium             |  Milestone:  PostGIS 3.6.5
 Component:  topology           |    Version:  3.6.x
Resolution:                     |   Keywords:
--------------------------------+---------------------------
Comment (by strk):

 According to QGIS there's a self-contact in the ring in the
 [[Image(SelfContact.png)]]

 Looking close with TopoViewer this is the problematic area:
 [[Image(ProblematicArea.png)]]

 The tiny red arrow pointing up above edge 371 is probably edge 383 which
 QGIS doesn't even handle to place a label for (but you can find out with
 the Info tool of QGIS).

 Some info about the problematic area:
 {{{
 =# select edge_id, start_node, end_node, st_issimple(geom),
 st_length(geom) from t6129.edge where edge_id in ( 371, 304, 383 );
  edge_id | start_node | end_node | st_issimple |       st_length
 ---------+------------+----------+-------------+------------------------
      371 |        376 |      306 | t           | 2.7514787551148605e-05
      304 |        309 |      310 | t           |  0.0016005631542521598
      383 |        376 |      310 | t           | 4.9083385500421105e-09
 (3 rows)
 }}}

 Problematic area detail:
 [[Image(ProblematicAreaDetail.png)]]

 Note that the yellow edge (304) is reported to be simple, but evidently
 has a vertex which is very very close to one of its own segments. This is
 one of those cases that should be reported by [https://postgis.net/docs
 /manual-dev/en/FindVertexSegmentPairsBelowDistance.html
 FindVertexSegmentPairsBelowDistance] but can probably NOT be fixed by
 adding a node there ( due to #6121 )
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/6129#comment:15>
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.