[postgis-users] ST_MapAlgebraExpr(rast,rast) Error

[Andreas Forø Tollefsen]

Hi,

Just for documentation purposes I changed the query to the following.
Working great.

SELECT
a.gid ,
(ST_SummaryStats((ST_Union(ST_MapAlgebraExpr(ST_AsRaster(a.cell,
b.rast, '32BF'), b.rast, '[rast2]', '32BF','INTERSECTION','NULL',
'NULL'))), true)).mean As avgmnt
FROM
priogrid a LEFT JOIN
access b
    ON ST_Intersects(a.cell, b.rast)
    WHERE gid >= 160000 AND gid <= 160999
GROUP BY a.gid
ORDER BY a.gid;

2012/2/8 Sandro Santilli <strk at keybit.net>:
> On Wed, Feb 08, 2012 at 11:47:30AM +0100, Andreas Forø Tollefsen wrote:
>> Great Sandro,
>>
>> Thanks! Is this documented somewhere?
>
> It looks like the manual page wasn't updated, see
> http://trac.osgeo.org/postgis/ticket/1525#comment:29
>
> I think the short-version of it is:
>
>  [rast.val]
>  [rast.x]
>  [rast.y]
>
> And for the 2-rasters version:
>
>  [rast1.val]    [rast2.val]
>  [rast1.x]      [rast2.x]
>  [rast1.y]      [rast2.y]
>
> --strk;
>
>  ,------o-.
>  |   __/  |    Thank you for PostGIS-2.0 Topology !
>  |  / 2.0 |    http://www.pledgebank.com/postgistopology
>  `-o------'
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users