[PostGIS] #6062: More error XX000: SQL/MM Spatial exception - geometry

[PostGIS]

#6062: More error   XX000: SQL/MM Spatial exception - geometry
-------------------------------+---------------------------
 Reporter:  Lars Aksel Opsahl  |      Owner:  strk
     Type:  defect             |     Status:  new
 Priority:  medium             |  Milestone:  PostGIS 3.6.2
Component:  topology           |    Version:  3.6.x
 Keywords:                     |
-------------------------------+---------------------------
 With attached with get topology errors

 {{{
 psql:/Users/lop/dev/github/resolve-overlap-and-gap/tmp3/error_01.sql:41:
 ERROR:  XX000: SQL/MM Spatial exception - geometry crosses edge 5107 at
 POINT(5.97358081667813 58.6227425544318)
 LOCATION:  pg_error, lwgeom_pg.c:363
 psql:/Users/lop/dev/github/resolve-overlap-and-gap/tmp3/error_01.sql:42:
 ERROR:  XX000: SQL/MM Spatial exception - geometry crosses edge 5107 at
 POINT(5.97358081667813 58.6227425544318)
 LOCATION:  pg_error, lwgeom_pg.c:363


 }}}

 Tested on


 {{{
 PostgreSQL 16.10 (Homebrew) on aarch64-apple-darwin23.6.0, compiled by
 Apple clang version 16.0.0 (clang-1600.0.26.6), 64-bit

 POSTGIS="3.7.0dev 3.6.0rc2-305-g3b3488ddf" [EXTENSION] PGSQL="160"
 GEOS="3.14.0-CAPI-1.20.4" PROJ="9.7.0 NETWORK_ENABLED=OFF
 URL_ENDPOINT=https://cdn.proj.org
 USER_WRITABLE_DIRECTORY=/Users/lop/Library/Application Support/proj
 DATABASE_PATH=/opt/homebrew/Cellar/proj/9.7.0/share/proj/proj.db"
 (compiled against PROJ 9.7.0) LIBXML="2.13.0" LIBJSON="0.18" TOPOLOGY

 PostgreSQL 16.4 (Ubuntu 16.4-1.pgdg20.04+1) on x86_64-pc-linux-gnu,
 compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.2) 9.4.0, 64-bit

 POSTGIS="3.7.0dev 3.6.0rc2-305-g3b3488ddf" [EXTENSION] PGSQL="160"
 GEOS="3.14.0-CAPI-1.20.4" (compiled against GEOS 3.13.1) PROJ="8.2.1
 NETWORK_ENABLED=OFF URL_ENDPOINT=https://cdn.proj.org
 USER_WRITABLE_DIRECTORY=/var/lib/postgresql/.local/share/proj
 DATABASE_PATH=/usr/share/proj/proj.db" (compiled against PROJ 8.2.1)
 LIBXML="2.9.13" LIBJSON="0.15" LIBPROTOBUF="1.3.3" WAGYU="0.5.0
 (Internal)" TOPOLOGY

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