Steve, Actually that was just for coloring geometries. For raster I usually just output the raster as RGB
R for band 1, G band 2, B for band 3 If you have a single band raster, you'll need to do reclassify the bands if you want to out as PNG for example http://www.postgis.org/documentation/manual-svn/RT_ST_Reclass.html Look at the last example in the docs. Or you could just export as one of the gdal 1 Banded supporting formats and use QGIS to do the classification. > -----Original Message----- > From: postgis-users-boun...@postgis.refractions.net > [mailto:postgis-users-boun...@postgis.refractions.net] On > Behalf Of Stephen Crawford > Sent: Wednesday, December 21, 2011 10:51 AM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] raster output > > Thanks for getting back to me. I want to do something like > #3, but I just don't understand the work flow. I have raw > data as a one band raster in postGIS, and the (seemingly) > simple thing i would like to do is output the entire table as > a jpg or png with the cells classified by color. I see > references to "color tables" and "palettes". I can't seem to > figure out where I can define "if cell val < 0.5, color = 0, > 0, 255" etc. > > Thanks, > Steve > > On 12/20/2011 6:13 PM, Paragon Corporation wrote: > > 3) You can use gdal_translate (compiled with PostgreSQL support) to > > output a postgis raster query. > > -- > Stephen Crawford > Center for Environmental Informatics > The Pennsylvania State University > > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
