Use ST_Intersects(raster, geometry) in the WHERE clause (as you would do with geometries).
Pierre > -----Original Message----- > From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users- > boun...@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 > ************************************************* > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
