[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):

 This is the relation between any pair of edges:

 {{{
 =# select count(*), rel from ( select ST_Relate(e1.geom, e2.geom) rel from
 t6129_outer_ring_edges e1, t6129_outer_ring_edges e2 where e2.edge_id >
 e1.edge_id ) foo group by 2;
  count |    rel
 -------+-----------
    367 | FF1F00102
  66794 | FF1FF0102
 (2 rows)
 }}}

 No pair has any interior-interior (1st matrix position) or interior-
 boundary (2nd and 4th position) intersection.

 No single edge is non-simple, but the output of
 ST_LineMerge(ST_Collect(geom)) is non-simple:
 {{{
 =# select count(*) filter ( WHERE not ST_IsSimple(geom) ) nonsimple_count,
 ST_IsSimple(ST_LineMerge(ST_Collect(geom))) from t6129_outer_ring_edges;
  nonsimple_count | st_issimple
 -----------------+-------------
                0 | f
 (1 row)
 }}}

 I'm calling this a bug in ST_LineMerge!
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/6129#comment:18>
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.