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

 Ok now I see and confirm the problem. From my dump the "offending" face is
 face 9.
 The function generating the face geometry (`ST_GetFaceGeometry`) is unable
 to build the correct geometry, completely dropping the exterior ring.

 [[Image(missingArea9.png)]]

 I also confirm the `ST_Collect` vs. `ST_Union` difference, with the
 `ST_Union` version evidently including the outer ring:

 {{{
 strk at strk=# select ST_Area(ST_BuildArea(ST_Union(e.geom))) from t6129.edge
 e where e.left_face = 9 or e.right_face = 9;
         st_area
 -----------------------
  0.0002930648390859782
 (1 row)

 Time: 8.704 ms
 strk at strk=# select ST_Area(ST_BuildArea(ST_Collect(e.geom))) from
 t6129.edge e where e.left_face = 9 or e.right_face = 9;
         st_area
 ------------------------
  1.2519093540856632e-05
 (1 row)

 Time: 15.293 ms
 }}}

 It sounds like a robustness issue. I'll take a closer look at
 ST_GetFaceGeometry.

 My relevant versions:
 {{{
 POSTGIS="3.7.0dev 3.7.0rc1-61-gf8777b8ce"
 GEOS="3.14.1-CAPI-1.20.5"
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/6129#comment:9>
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.