postgis 自相交数据检测 修复
检测:
SELECT ST_IsValid(geom),ST_IsValidReason(geom) FROM tableName
修复
update tableName set geom=ST_MakeValid(geom)
检测:
SELECT ST_IsValid(geom),ST_IsValidReason(geom) FROM tableName
修复
update tableName set geom=ST_MakeValid(geom)