On Mon, 28 Dec 2020 08:10:50 -0800 (PST), Andrea Borruso wrote:
> is there a SQL way to run RTTOPO SanitizeGeometry command of the
> spatialite-gui app (using the default sanitize option)?
the GUI wizard is fully based on the standard RTTOPO MakeValid()
function, it simply add some bonus value such as producing an
HTML detailed report.
you can get the same practical effect by using a pure SQL
UPDATE geom = MakeValid(geom) FROM my_table;
or even better:
UPDATE geom = MakeValid(geom)
WHERE ST_IsValid(geom) <> 1;
happy new year,