Hey, snap is deceiptively named. As far as I know It just snaps points to points (or points in geometry to points in geometry). For exemple, if you draw 2 square side by side, one being bigger than the other, and separate theim with small distance, snap will do nothing. Cheers, Rémi-C
2014-09-24 13:41 GMT+02:00 Alexandre Neto <[email protected]>: > 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 >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
