One of the new features coming in PostGIS 3.1 is fixed precision support.
This new feature will require compilation with not yet released GEOS 3.9.
There are a couple of functions already in PostGIS 3.1 that have this new feature -- they are ST_Subdivide, ST_Union, ST_SymDifference, ST_Union, and ST_UnaryUnion as summarized in
What's new in PostGIS 3.1.
To take advantage of these new to die for features, you'll need to have compiled your PostGIS with development GEOS 3.9 which is planned for release
around the same time we get around to releasing PostGIS 3.1. Windows users can download binaries with GEOS 3.9 support from
PostGIS windows experimental binaries
The ST_Union feature should improve a lot of cases where people ran into topological exceptions. Perhaps I'll demonstrate that in a separate article once I've given it a test drive.
Continue reading "Waiting for PostGIS 3.1: ST_Subdivide and other function support with fixed precision"