[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 Lars Aksel Opsahl):

 Pushed a test now in https://gitlab.com/nibioopensource/resolve-overlap-
 and-gap/-/merge_requests/120

 Seems like we have both overlaps and gaps because of error in the topology

 If you run

 {{{
 make clean ; make ; time sh src/test/sql/regress/run_resolve_test.sh
 --nodrop src/test/sql/regress/rog_overlay_test_54_a;

 }}}

 and after this run


 {{{

 [local] lop at t1=# SELECT 'area of overlap' , round(st_area(geom,true)) from
 test_54_a_1.result_rogtest_overlap order by round(st_area(geom,true));

 SELECT 'area of gaps' , round(st_area(geom,true)) from
 test_54_a_1.result_rogtest_gap order by round(st_area(geom,true));
     ?column?     | round
 -----------------+-------
  area of overlap |  5687
  area of overlap |  7019
 (2 rows)

    ?column?   | round
 --------------+--------
  area of gaps |    153
  area of gaps |    957
  area of gaps |   1339
  area of gaps |  45572
  area of gaps |  60530
  area of gaps |  83592
  area of gaps | 116433
  area of gaps | 372300
  area of gaps | 591234

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