[postgis-tickets] [PostGIS] #5144: 3d intersects in postgis hangs on simple polyhedron
PostGIS
trac at osgeo.org
Mon Jun 19 13:14:29 PDT 2023
#5144: 3d intersects in postgis hangs on simple polyhedron
--------------------------+---------------------------
Reporter: lbartoletti | Owner: pramsey
Type: defect | Status: closed
Priority: medium | Milestone: PostGIS 3.4.0
Component: postgis | Version: 3.2.x
Resolution: wontfix | Keywords:
--------------------------+---------------------------
Comment (by robe):
This wasn't an sfcgal issue, it wa a PostGIS one. ST_3DIntersects (exposed
by SFCGAL was removed in PostGIS 3.0)
The answer on my setup with or without sfcgal installed returns false. So
I guess the issue has been fixed in PostGIS proper at least to not hang.
The only issue that remains is ST_3DIntersects I don't think is Solid
aware.
I think we might have a ticket somewhere to reexpose the SFCGAL
ST_3DIntersects which is solid aware. If not we should create one.
The ST_3DIntersection function, which IS postgis_sfcgal, seems to return
the point fine.
{{{
SELECT ST_AsText(ST_3DIntersection('POINT(0 0.5 0.5)', 'POLYHEDRALSURFACE
Z (((2 0.5 0.5, 0 0 1, 0 0 0, 2 0.5 0.5)), ((2 0.5 0.5, 0 1 1, 0 0 1, 2
0.5 0.5)), ((2 0.5 0.5, 0 1 0, 0 1 1, 2 0.5 0.5)), ((2 0.5 0.5, 0 0 0, 0 1
0, 2 0.5 0.5)), ((0 0 0, 0 0 1, 0 1 1, 0 1 0, 0 0 0)))'))
}}}
outputs
{{{
POINT Z (0 0.5 0.5)
}}}
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5144#comment:13>
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