[postgis-users] snapping a table to itself

[Richard Greenwood]

I would like to automate the cleanup of a vector later. Neither ST_Snap()
nor ST_SnapToGrid() are doing it for me. I've got a little sketch below in
which I've attempted to illustrate my problem with ST_SnapToGrid(). The
green lines represent the vector layer that I'd like to clean up. I'd like
the four vertices to be snapped together. The red lines represent the grid.
So in this case the four vertices all fall in different grid cells and no
snapping occurs despite the vertices being closer together than the grid
size. The data is irregular so setting an origin will not be of much use.
Any suggestions?
[image: image.png]
-- 
Richard W. Greenwood
www.greenwoodmap.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20211027/2db4e571/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 8372 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20211027/2db4e571/attachment.png>