[postgis-users] SUM on rasters

Stephen Crawford src176 at psu.edu
Wed Oct 14 07:51:09 PDT 2015


Yes, I figured out I needed to use St_Union()....and also that it can 
exceed available memory :-)  But after some fine tuning it worked.  Thanks.

On 10/14/2015 10:27 AM, Pierre Racine wrote:
> If by "sum" you mean "merge" or "union" use ST_Union(). Be careful as the "sum" can exceed available memory if they are too many rasters in the table.
>
>> -----Original Message-----
>> From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On
>> Behalf Of Stephen Crawford
>> Sent: Monday, October 12, 2015 10:46 AM
>> To: PostGIS Users Discussion
>> Subject: [postgis-users] SUM on rasters
>>
>> Hi,
>>
>> I have a table of rasters.  I would like to SUM the entire table with
>> one raster as the result. Can somebody point me in to the correct
>> funtion to do this?
>>
>> Thanks,
>> Steve
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users




More information about the postgis-users mailing list