1

I have a polygon and a set of rasters. I'm trying to clip raster with polygon.
enter image description here
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.

|improve this question
  • Perhaps you want to define the polygon in terms of an intersection (postgis.org/docs/ST_Intersection.html)? – BradHards Mar 13 '14 at 11:21
  • Hi @BradHards, could you tell me more how to define the polygon. Because, I tried but it keeps throws the same error. SELECT ST_Intersection(polygon,rast_geom_4326) FROM landsat8 WHERE ST_Intersects(polygon,rast_geom_4326) – Jackie Mar 14 '14 at 3:58
0

I had a similar problem which I resolved by adding a small amount of entropy to the vectors: How best to fix a non-noded intersection problem in PostGIS?

It looks like there might be vectors which overlap, but are very close to being identical in your diagram. This may be causing the non-noded problem.

|improve this answer
  • Hi @djq, I tried the solution above but it didn't solve my problem. However, I figured out my problem. My polygon was invalid. It was like a bow tie instead of a rectangular, what I expect. So it has self-intersection in the center. – Jackie Mar 19 '14 at 1:56
0

After trying some solutions for non-noded-problems, I still couldn't solved my problem. Then I figured out that my polygon was invalid. I expected a rectangular, but it was a bow tie instead (ST_isValid(geom)). Therefore, the polygon was self-intersection at center.

|improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.