Programmatically classify a raster using PostGIS

[المشرف العام]

I want to programmatically classify a raster by substituting the pixel values, for example if

1 < val < 10 put 5

11 < val < 20 put 15

​

I'm using the query bellow and it's working:

Select St_Reclass(a.rast, 1, '[200-210):205,[210-220):215','32BF',0) From raster1 aSo each time I need to specify the gap.

Is there any way to modify the query by adding only an interval or gap to be applied for all values of raster?



أكثر...