[PostGIS] #5705: Proposal: New function ST_RemoveIrrelevantPointsForView()

[PostGIS]

#5705: Proposal: New function ST_RemoveIrrelevantPointsForView()
-------------------------+---------------------------
 Reporter:  gluser1357   |      Owner:  pramsey
     Type:  enhancement  |     Status:  new
 Priority:  medium       |  Milestone:  PostGIS 3.5.0
Component:  postgis      |    Version:  master
 Keywords:               |
-------------------------+---------------------------
 I'd like to contribute a new Postgis function,
 ST_RemoveIrrelevantPointsForView (the_geom, bbox).

 This function removes all coordinates being irrelevant for rendering data
 within a given view. In contrast to ST_Intersection(), no new coordinates
 will be computed. The function currently supports (multi-)polygons and
 (multi-)linestrings of dimension 2.

 Using a test dataset containing the state borders in Europe, preprocessing
 with ST_RemoveIrrelevantPointsForView() leads to the same rendering result
 as with the original geometries. Compared with ST_Intersection(), it
 returns about the same number of points but is up to 20 times faster which
 is, as far as our long-term experience goes, advantageous for real-time
 applications.

 The code you can find as fork of https://github.com/postgis/postgis
 (master) here:

 https://github.com/gluser1357/postgis-
 fork/tree/remove_irrelevant_points_for_view

 Please see also the initial discussion on postgis devel here:

 https://lists.osgeo.org/pipermail/postgis-devel/2024-March/030262.html

 Thank you for reviews, hints and comments on this function or if there's
 something missing (e. g. more edge cases).
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5705>
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.