[postgis-tickets] [PostGIS] #3787: Wrong results when using 3D in topology

[PostGIS]

#3787: Wrong results when using 3D in topology
------------------------+-----------------------------
  Reporter:  aperi2007  |      Owner:  strk
      Type:  defect     |     Status:  new
  Priority:  medium     |  Milestone:  PostGIS Fund Me
 Component:  topology   |    Version:  2.3.x
Resolution:             |   Keywords:
------------------------+-----------------------------
Changes (by komzpa):

 * milestone:  PostGIS 2.4.6 => PostGIS Fund Me


Comment:

 Results changed in 3.0alpha4. I believe there is no definition on what
 noding process should do for two non-3D-intersecting 2D-intersecting
 geometries. How should it be and why?

 Proper 3D topology should even not node these as they don't intesect in
 3D. That would be a bigger rewrite that needs more definitions.

 {{{
 14:19:56 [kom] > select postgis_full_version();
 ┌───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
 │
 postgis_full_version
 │
 ├───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┤
 │ POSTGIS="3.0.0alpha2 r17458" [EXTENSION] PGSQL="110"
 GEOS="3.7.2-CAPI-1.11.2 b55d2125" SFCGAL="1.3.7" PROJ="Rel. 5.2.0,
 September 15th, 2018" GDAL="GDAL 2.4.2, released 2019/06/28"
 LIBXML="2.9.4" LIBJSON="0.12.1" LIBPROTOBUF="1.3.1" WAGYU="0.4.3
 (Internal)" TOPOLOGY RASTER │
 └───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘
 (1 row)

 Time: 497,155 ms
 14:20:25 [kom] > select ST_Astext(geom) from topo_test.edge_data;
 ┌─────────────────────────────────────────┐
 │                st_astext                │
 ├─────────────────────────────────────────┤
 │ LINESTRING Z (50 -50 0.001,50 0 0.0005) │
 │ LINESTRING Z (50 0 0,100 0 0)           │
 │ LINESTRING Z (50 0 0.0005,50 50 0.001)  │
 │ LINESTRING Z (0 0 0,50 0 0)             │
 └─────────────────────────────────────────┘
 (4 rows)

 Time: 0,257 ms
 }}}

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