[postgis-users] postgis raster st_value

[Pierre Racine]

Use ST_Intersects(raster, geometry) in the WHERE clause (as you would do with geometries).

Pierre

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of John Callahan
> Sent: Monday, February 20, 2012 4:28 PM
> To: PostGIS Users Discussion
> Subject: [postgis-users] postgis raster st_value
> 
> Hopefully this is a question with a quick answer....
> 
> I have a few rasters loaded into PostGIS 2.0 alpha5.  I loaded them with tiles at
> 256x256 px (no real reason why I chose those dimensions.)  When I run a simple
> ST_Value() statement, returned is one record for each tile.  And, of course, every
> one of those will be blank except for the tile that contains the location.  Is there
> a way to return only the value, and not a full array of nearly empty cells?   (of
> course, only one value is returned when the raster is not-tiled but I'm not sure if
> that's the way to go.)  Thanks.
> 
> 
> - John
> 
> ***********************************************
> John Callahan, Research Scientist
> Delaware Geological Survey, University of Delaware
> URL: http://www.dgs.udel.edu
> *************************************************
>