I am getting this PostGIS error:
ERROR: lwgeom_unaryunion_prec: GEOS Error: TopologyException: Ring > edge missing at 577690.01999999955 213605.69999999925 SQL state: XX000
I have checked that the table has the correct SRID set, and I have checked that all polygons are considered valid by running this (and getting a result of 0):
SELECT COUNT(*) FROM table1 AS a WHERE NOT ST_IsValid(a.geom) ;
Just in case it helped anyway, I also created a copy of the table using
ST_MakeValid on all polygons. Unsurprisingly, given the
ST_IsValid results, this didn't remove the error.
I realise that I can inspect the site of the error using the coordinates given. At maximum magnification in QGIS I can't see a problem with the polygon in question.
Is this likely to be a numerical precision issue as discussed in ST_Union Topology exception despite of valid geometries ?