<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: arial,helvetica,sans-serif; font-size: 10pt; color: #000000'>Goog morning Pierre,<br><br>yes, it works.<br><br>Thank's a lot!<br><br><div><span name="x"></span>--<br><font style="color: rgb(102, 102, 102);" size="1"><em>Mathieu BOSSAERT</em><br style="font-style: italic;"><span style="font-style: italic;">Responsable du </span><a style="font-style: italic;" href="http://si.cenlr.org/">système d'information</a></font><font style="font-weight: bold; font-style: italic; color: rgb(102, 102, 102);" size="1"> du CEN L-R</font><br><font style="font-style: italic; color: rgb(102, 102, 102);" size="1">04 67 29 90 65 - sig@cenlr.org</font><br><img src="http://sig.cenlr.org/_media/signature-courriel_mathieu.jpg"><br><span name="x"></span><br></div><hr id="zwchr"><div style="color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><b>De: </b>"Pierre Racine" <Pierre.Racine@sbf.ulaval.ca><br><b>À: </b>"Mathieu Bossaert (CEN L-R)" <sig@cenlr.org>, "PostGIS Users Discussion" <postgis-users@lists.osgeo.org><br><b>Envoyé: </b>Mercredi 13 Février 2013 16:01:14<br><b>Objet: </b>RE: [postgis-users] Add bands to a raster<br><br>That looks good. does it work?<br><br>> -----Original Message-----<br>> From: postgis-users-bounces@lists.osgeo.org [mailto:postgis-users-<br>> bounces@lists.osgeo.org] On Behalf Of SIG CEN L-R<br>> Sent: Monday, February 11, 2013 5:42 PM<br>> To: postgis-users@lists.osgeo.org<br>> Subject: [postgis-users] Add bands to a raster<br>> <br>> Good evening,<br>> <br>> I would like to apply what I red from Pierre Racine about the way to add a band<br>> to a raster from another one.<br>> http://geospatialelucubrations.blogspot.fr/2012/09/loading-many-rasters-into-<br>> separate.html?showComment=1346973298820#c4654958992264542142<br>> <br>> I have 3 tables all tiled the same way.<br>> The first one "altitude", the second one "temp_min" and the third one<br>> "temp_max"<br>> <br>> In order to facilitate analyses, I would like to add 2 bands to the raster "altitude"<br>> <br>> I translate what I understood from Mr Racine like this, could someone tell me if I<br>> am wrong ?<br>> <br>> UPDATE altitude SET rast=ST_AddBand(altitude.rast, min.rast)<br>> FROM temperature_min min<br>> WHERE ST_UpperLeftX(min.rast) = ST_UpperLeftX(altitude.rast)<br>> AND ST_UpperLeftY(min.rast) = ST_UpperLeftY(altitude.rast);<br>> <br>> UPDATE altitude SET rast=ST_AddBand(altitude.rast, max.rast)<br>> FROM temperature_max max<br>> WHERE ST_UpperLeftX(max.rast) = ST_UpperLeftX(altitude.rast)<br>> AND ST_UpperLeftY(max.rast) = ST_UpperLeftY(altitude.rast);<br>> <br>> Thanks a lot!<br>> <br>> Mathieu Bossaert<br>> <br>> --<br>> Mathieu BOSSAERT<br>> Responsable du système d'information <http://si.cenlr.org/> du CEN L-R<br>> 04 67 29 90 65 - sig@cenlr.org<br>> <http://sig.cenlr.org/_media/signature-courriel_mathieu.jpg><br>> <br>> ________________________________<br><br></div><br></div></body></html>