[postgis-users] raster: several DTM in same table, how to select?

Denis Rouzaud denis.rouzaud at gmail.com
Thu Mar 29 01:35:07 PDT 2012

Hi all,

I have a table in which I put ~10 dtm as rasters.

How do I select in the where close the DTM in which my point is?

Indeed, if I use ST_Value on the whole table, I have:
NOTICE:  Attempting to get pixel value with out of range raster 
coordinates: (9512, 9899)
CONTEXT:  PL/pgSQL function "st_value" line 13 at RETURN
SQL statement "SELECT ST_Value(rast, ST_SetSRID( point , 21781 )) FROM 

BTW, isn'it strange? I think that it used to return a NULL value if 
outside of the boundaries, no?



More information about the postgis-users mailing list