Hi everybody !
For information, I work on :
postgis 2.1
postgre 9.4
Qgis 2.12.2
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.
This is the code I enter :
DROP TABLE IF EXISTS lucie.compil;
CREATE TABLE lucie.compil
AS
SELECT
CASE
WHEN a.valeur>0 THEN a.rast
ELSE b.rast
END as rast
FROM lucie.test as a join lucie.final_raster as b on
st_intersects(a.rast,b.rast);
But it doesn’t run...I can’t open the result layer on Qgis...Do you know
why ?
Thank you very much for your help that would be so precious, because I
have been searching for 5 months !!!
Lucie
--
*Lucie DURANTON*
Chargée d'études SIG
DTerCE - DETC - CTCS
Tel : 04 74 27 53 52
http://www.cerema.fr
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
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/postgis-users
