[postgis-users] Problem using ST_snap

[Alexandre Neto]

Hello all,

I have to tables in postgis. table one has a set of adjacent polygons that
covers all my area o interest, while table to have a few polygons across
the same area.

Some boundaries of table 2 should snap to the table 1 polygons, but they
don't.

I'm trying to use st_snap to correct this, but I'm not being able to do it.
There are vertices that "refuse" to change while other (just a few do). I'm
already using a very big tolerance.

 Therefore I need your help to see if my query looks correct or not.


WITH snap_grid as
(
SELECT
    St_Collect(f.geom) as geom
FROM
    table_1 as f
)
SELECT
    r.gid, st_snap(r.geom,q.geom,10) as geom
FROM
    table2 as r,
    snap_grid as q
WHERE r.gid = 53

I already tried dumping all point form the table 1 polygons, but the result
is "similar".

Thanks in advance,

Alexandre Neto
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140924/94286767/attachment.html>