[postgis-users] Geom/Rast Intersection St9bad_alloc

[JamesH]

>http://trac.osgeo.org/postgis/browser/trunk/raster/scripts/plpgsql/st_summarystatsagg.sql>
>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
ST_Clip? 

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

Kind Regards,
James

-----
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.