[PostGIS] #5698: XX000: SQL/MM Spatial exception - point not on edge

PostGIS trac at osgeo.org
Fri Mar 22 09:14:00 PDT 2024


#5698: XX000: SQL/MM Spatial exception - point not on edge
--------------------------------+---------------------------
  Reporter:  Lars Aksel Opsahl  |      Owner:  strk
      Type:  defect             |     Status:  new
  Priority:  medium             |  Milestone:  PostGIS 3.4.3
 Component:  topology           |    Version:  3.4.x
Resolution:                     |   Keywords:
--------------------------------+---------------------------
Comment (by robe):

 strk fwiw, on my
 {{{
                                                      postgis_full_version
 -------------------------------------------------------------------------------------------------------------------------------
  POSTGIS="3.1.9 95a641b" [EXTENSION] PGSQL="110" GEOS="3.10.3-CAPI-1.16.1"
 PROJ="7.2.1" LIBXML="2.9.1" LIBJSON="0.11" TOPOLOGY
 (1 row)
 }}}


 {{{

 select ST_AsText(ST_Split(
  'LINESTRING(15.796760167740288 69.05714853429149,15.796760167739626
 69.05714853429157,15.795906966300288 69.05725770093837)'::geometry,
 'POINT(15.796760167739626 69.05714853429157)'::geometry));
 st_astext
 ------------------------------------------------------------------------------------------------------------------------------------------------
  GEOMETRYCOLLECTION(LINESTRING(15.796760167740288
 69.05714853429149,15.796760167739626 69.05714853429157,15.795906966300288
 69.05725770093837))
 (1 row)
 }}}



 {{{

 select st_astext(ST_PointN(e,2)), st_astext(st_split(e,st_pointn(e,2)))
 from ( select 'LINESTRING(15.796760167740288
 69.05714853429149,15.796760167739626 69.05714853429157,15.795906966300288
 69.05725770093837)'::geometry e ) foo;
 [ RECORD 1
 ]---------------------------------------------------------------------------------------------------------------------------------------------
 st_astext | POINT(15.796760167739626 69.05714853429157)
 st_astext | GEOMETRYCOLLECTION(LINESTRING(15.796760167740288
 69.05714853429149,15.796760167739626 69.05714853429157,15.795906966300288
 69.05725770093837))

 }}}


 So guess we need to go further back on GEOS version?  I'll see if I can
 dig up a 3.9 or 3.6
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5698#comment:8>
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.


More information about the postgis-tickets mailing list