Changes between Version 64 and Version 65 of WKTRaster/SpecificationWorking03

Show
Ignore:
Timestamp:
04/19/11 07:16:23 (2 years ago)
Author:
dustymugs
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • WKTRaster/SpecificationWorking03

    v64 v65  
    505505SELECT ST_Reclass( 
    506506  ST_Band(rast, ARRAY[1,1,1]),  
    507   1, LEAST(covmin, 0)::text || '-0:0,0-' || GREATEST(covmax, 0)::text || ':0-255', '8BUI', 
    508   2, LEAST(covmin, 0)::text || '-0:200,0-' || GREATEST(covmax, 0)::text' || ':0-255','8BUI', 
    509   3, LEAST(covmin, 0)::text || '-0:255,0-' || (GREATEST(covmax, 0)/2)::text' || ':0,' || (GREATEST(covmax, 0)/2)::text' || ':' || GREATEST(covmax, 0)::text || ':0-255', '8BUI') 
     507  ROW(1, LEAST(covmin, 0)::text || '-0:0,0-' || GREATEST(covmax, 0)::text || ':0-255', '8BUI'), 
     508  ROW(2, LEAST(covmin, 0)::text || '-0:200,0-' || GREATEST(covmax, 0)::text' || ':0-255','8BUI'), 
     509  ROW(3, LEAST(covmin, 0)::text || '-0:255,0-' || (GREATEST(covmax, 0)/2)::text' || ':0,' || (GREATEST(covmax, 0)/2)::text' || ':' || GREATEST(covmax, 0)::text || ':0-255', '8BUI') 
     510) 
    510511FROM mycoverage 
    511512}}}