[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