<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi everybody !<br>
<br>
For information, I work on :<br>
<br>
postgis 2.1<br>
postgre 9.4<br>
Qgis 2.12.2<br>
<br>
I try to compile together several raster layers with postgis. For
information, layer "a" has priority over layer "b", and all of my
rasters are single-band.<br>
<br>
This is the code I enter :<br>
<br>
DROP TABLE IF EXISTS lucie.compil;<br>
CREATE TABLE lucie.compil<br>
AS<br>
SELECT<br>
CASE<br>
WHEN a.valeur>0 THEN a.rast<br>
ELSE b.rast<br>
END as rast<br>
FROM lucie.test as a join lucie.final_raster as b on
st_intersects(a.rast,b.rast);<br>
<br>
But it doesn’t run...I can’t open the result layer on Qgis...Do you
know why ?<br>
<br>
Thank you very much for your help that would be so precious, because
I have been searching for 5 months !!!<br>
<br>
Lucie<br>
<div class="moz-signature">-- <br>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<title></title>
<font face="DaxOT-Regular"><b>Lucie DURANTON</b><br>
Chargée d'études SIG<br>
<br>
DTerCE - DETC - CTCS<br>
Tel : 04 74 27 53 52<br>
<a class="moz-txt-link-freetext" href="http://www.cerema.fr">http://www.cerema.fr</a></font><br>
<img alt="CEREMA - Direction territoriale Centre-Est : Cité des
mobilités - 25, avenue François Mitterrand - CS 92 803 - F-69674
BRON Cedex - Tel : +33 (0)4 72 14 30 30"
src="cid:part2.06080502.00080500@cerema.fr" height="200"
width="890"><br>
</div>
</body>
</html>