[postgis-users] Geom/Rast Intersection St9bad_alloc

JamesH james.holmes at newcastle.ac.uk
Wed Apr 25 01:32:27 PDT 2012

>I copied the code and ran it, returned as successful but when I run the
full query it says that function >ST_SummaryStatsagg(raster) does not exist.
>Have I copied the function incorrect>

This was my mistake, I downloaded st_summarystatsagg in plain text form and
created the function.

It ran and returned in 1 hour with the statistics which have helped me.

However, if I wanted to create a view or a new dataset which has the raster
clipped by the polygon's geometry in addition to the stats, can I use just

Something like:
SELECT ST_Clip(rast,geom)
FROM clip_build, nclheat
WHERE ST_Intersects(rast,geom)

Kind Regards,

GIS Undergraduate
View this message in context: http://postgis.17.n6.nabble.com/Geom-Rast-Intersection-St9bad-alloc-tp4912994p4915991.html
Sent from the PostGIS - User mailing list archive at Nabble.com.

More information about the postgis-users mailing list