[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