[postgis-users] raster, stats conditioned to a set of values

juli g. pausas juli.g.pausas at uv.es
Mon Jul 6 06:57:56 PDT 2015

INSERT INTO rastertmp.provanet
    SELECT t1.rid, ST_Union(ST_Intersection(t1.rast, 1, t2.rast, 1,
    FROM rastertmp.prova AS t1, rastertmp.provapositiu AS t2
    WHERE ST_Intersects(t1.rast, t2.rast)
    GROUP BY t1.rid;

NOTICE:  The two rasters provided have no intersection.  Returning no band
CONTEXT:  PL/pgSQL function
st_intersection(raster,integer,raster,integer,text,double precision[]) line
20 at assignment
NOTICE:  Could not find raster band of index 1 when setting pixel value.
Nodata value not set. Returning original raster

*CIDE, CSIC*  |  www.uv.es/jgpausas  |

On Mon, Jul 6, 2015 at 3:52 PM, Pierre Racine <Pierre.Racine at sbf.ulaval.ca>

> > Adding a GROUP BY t1.rid, doesn't solve the problem, still get an error.
> Which error?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150706/183f207e/attachment.html>

More information about the postgis-users mailing list