[postgis-users] Get ST_Value results from a tiled raster without all of the NULL results

Pierre Racine Pierre.Racine at sbf.ulaval.ca
Fri Jun 29 12:13:31 PDT 2012


> SELECT ST_Value(rast, ST_PointFromText('POINT(-59 -1)', 4326)) FROM
> modis.test

Did you try adding:

WHERE ST_Intersects(rast, ST_PointFromText('POINT(-59 -1)', 4326))

Pierre



More information about the postgis-users mailing list