>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. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
