I am running a very simple boolean selection with
postgis st_intersects on two polygon tables:
select distinct on(ms.shape) ms.shape shape,ms.type_ from riparian_corridor.merged_soils ms join riparian_corridor.riparian_open_waters o on st_intersects(ms.shape,o.shape);
This query returns most correct features but there are a handful of instances where the features clearly intersect and it is not selected.
The distance between the edge of that blue feature and red outline polygon is about 2 feet. Should I be using
st_snaptogrid? If so, which geometry should I put it on? and should the tolerance be something around 2 feet to pick those features up?