[postgis-users] Better way of removing pixelation with postgis raster

[Pierre Racine]

> In my idea staying with the algebra functions should be doable, even
> with complex speckles.
> As long as the mask is big enough (finding speckles of max N pixels
> takes a 2N x 2N matrix) one should be able to run a neighbourhood scan
> outwards from the centre pixel. With some smart iterations that might
> work, I just need to start learning plpsql or something...
> Would you agree that that kind of method would be faster than vectorizing?

I can't answer this as I haven't played much with ST_MapAlgebraFctNgb.. It all depends on the size of the window.

Give it a try! plpgsql is very easy and you can start from the example in the doc.

Pierre