perfect, thanks Kevin.
Kevin Neufeld wrote:
Try using ST_SnapToGrid(geometry, size) will remove coincident points.
To identify polygons with dups,
SELECT *
FROM mypolytable
WHERE ST_NPoints(geom) != ST_NPoints(ST_SnapToGrid(geom, <some
precision>));
-- Kevin
Rob Agar wrote:
hi all,
Another quick question - is there a function for detecting polygons
with one or more sequential duplicated points? Basically, I want to
find and replace polys like "abccd" with "abcd".
cheers
Rob
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
