I have a polygon and a set of rasters. I'm trying to clip raster with polygon.
As you see, my rasters is divided into tiles. Any tiles that is contained by the polygon has ST_Overlaps(polygon, rast_geom_4326) = 'f', obviously. And it leads to non-noded intersection error.
But, I also have the same problem with this query:
SELECT ST_Clip(rast, ST_Transform(polygon, rast_geom_4326))
FROM landsat8
WHERE ST_Overlaps(polygon, rast_geom_4326)
Is there any function to dissolve the polygon with tiles, to get rid of "non-noded intersection between LINESTRING".
I've read a presentation about this error postgis-power.pdf. But, I can't find the solution for my problem.
SELECT ST_Intersection(polygon,rast_geom_4326) FROM landsat8 WHERE ST_Intersects(polygon,rast_geom_4326)