I have two polygon layers, one which defines subregions of the other. However, the layers do not line up exactly, so there are minor discrepancies along the edges. I would like to select all minor polygons which lie within the major polygon layer. What is the best way to do this in PostGIS?
Sample of map below. You can see the blue subregions on top of the larger yellow region, with seemingly exact "jigsaw" edging. I have tried using
ST_Within to select polygons, with the result being the purple polygons. These are clearly a subset of what I am looking for.
Zooming in, you can see that the edges do not align properly.
What is the best way to select under these circumstances?