[postgis-tickets] [PostGIS] #5377: Proposal: ST_Node as a window function

[PostGIS]

#5377: Proposal: ST_Node as a window function
-------------------------+-----------------------------
 Reporter:  mdavis       |      Owner:  pramsey
     Type:  enhancement  |     Status:  new
 Priority:  low          |  Milestone:  PostGIS Fund Me
Component:  postgis      |    Version:  3.3.x
 Keywords:               |
-------------------------+-----------------------------
 This proposes making a window function version of `ST_Node` (perhaps
 called `ST_NodeWin`.  This will support the situation of noding a set of
 features together while preserving the attribution of each feature.

 An example is noding a linear network, and preserving the attribute
 information for each network linear feature.

 Note that unlike `ST_Node` this function will NOT dissolve identical
 linework (since each feature needs to have its full linework returned,
 possibly containing new nodes).

 The function should support the optional `gridSize` argument as in other
 overlay functions.  If `gridSize` is specified, the noding will use snap-
 rounding to provide precise and robust output.

 There are two options for output: split and merged.  Split output will
 split LineStrings into MultiLineStrings at each node.  Merged will
 maintain LineStrings, but with vertices added at node points.

 This will require a new GEOS function to support this functionality.  See
 https://github.com/libgeos/geos/issues/877 for some discussion around this
 requirement.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5377>
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.