[postgis-users] postgis raster st_value
Pierre Racine
Pierre.Racine at sbf.ulaval.ca
Mon Feb 20 13:29:09 PST 2012
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
> *************************************************
>
More information about the postgis-users
mailing list