[postgis-users] ST_Value on tiled raster

[Albury, Carl -FS]

Hi
I'm new to PostGIS  so please bear with me.
I'm working with MODIS data that I tiled using the auto tile switch in raster2pgsql resulting in 13250 82x94 tiles.
When I try to query for pixel values using ST_Value, such as:

SELECT
    ST_Value(rast, 2, 1,1) -- multiband raster
FROM
  MODIS_test;

I get a value for each tile, not for each pixel (I assume the value is for the first pixel in the tile?).
If I want to query each pixel do I need to loop through each tile and have a sub loop for each pixel in that tile? If so I can't figure out the syntax to designate the tiles vs pixels.

Thanks very much,
Carl

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150421/94b3ca26/attachment.html>