topology.RemoveUnusedPrimitives(topology, bbox) function

[strk]

It is sometimes useful to cleanup the topology by removing unused primitives (edges not binding areal TopoGeometries, nodes not binding lineal TopoGeometries).

This is for example implemented in QGIS PostGIS Topology Editor plugin: ​https://plugins.qgis.org/plugins/pgtopoeditor/

And is implemented in NIBIO's topo_update extension: ​https://gitlab.com/nibioopensource/pgtopo_update_sql/-/blob/910da58a375ae9454634538b6fa110167f655c41/src/sql/topo_update/function_02_cleanup_topology.sql

This ticket is to expose such a function in core PostGIS Topology for reuse by others.

See also #5180 for exposing a part of this function but specifically for edges only

[strk]

Draft merge request: ​https://gitlab.com/postgis/postgis/-/merge_requests/84

[Sandro Santilli <strk@…>]

In 2f915e1/git:

Implement topology.RemoveUnusedPrimitives

Closes #5183

Includes tests, docs and NEWS entry

[strk]

In case someone landed here following the commit log in [ab58faa8bf7b95187d74179e78946e2284fb8b85/git] .. that commit log was bogus, the actual bug being fixed with that was #5185