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
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
