Changes between Version 1 and Version 2 of Ticket #837


Ignore:
Timestamp:
Feb 17, 2011, 6:48:36 AM (13 years ago)
Author:
robe
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #837 – Description

    v1 v2  
    11I tried to do this on my test elephant
    22 -- its a single tile -- I forget the size
    3 
     3 O
    44{{{
    5 UPDATE ch13.pele SET map_rast = ST_MapAlgebra(rast,'CASE WHEN rast BETWEEN 100 and 250 THEN 1 WHEN rast = 252 THEN 2 WHEN rast BETWEEN 253 and 254 THEN 3 ELSE 0 END', '2BUI') ;
     5ALTER TABLE ch13.pele ADD column map_rast raster;
     6UPDATE ch13.pele
     7SET map_rast = ST_MapAlgebra(rast,'CASE WHEN rast BETWEEN 100 and 250 THEN 1 WHEN rast = 252 THEN 2 WHEN rast BETWEEN 253 and 254 THEN 3 ELSE 0 END', '2BUI') ;
    68}}}
    79