[postgis-devel] [PostGIS] #1889: [raster] ST_PixelOfValue: given a band and value, get the band pixels with that value

[PostGIS]

#1889: [raster] ST_PixelOfValue: given a band and value, get the band pixels with
that value
-------------------------+--------------------------------------------------
 Reporter:  dustymugs    |       Owner:  dustymugs    
     Type:  enhancement  |      Status:  new          
 Priority:  medium       |   Milestone:  PostGIS 2.1.0
Component:  raster       |     Version:  trunk        
 Keywords:               |  
-------------------------+--------------------------------------------------

Comment(by pracine):

 I find this is very similar to adding a WHERE clause to
 ST_PixelAsPoints...

 SELECT (gv).geom
 FROM (SELECT (ST_PixelAsPoints(rast)).geom geom
       FROM rast
      )
 WHERE (gv).val = 1234

 ST_PixelofValue might be faster though...

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1889#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.