[postgis-users] Geom/Rast Intersection St9bad_alloc

[JamesH]

"I am attempting to intersect a vector dataset of building polygons with a
3-Band Thermal tiff to produce a dataset that shows the thermal readings for
each polygon."

If I took the 3 band jpeg of this raster and used ST_AsTiff to convert it to
a single band tiff would this calculation be valid? How could I place this
into the query?

SELECT gid, ST_Intersection(geom, rast, 1) 
FROM clip_build, nclheat 
WHERE ST_Intersects(rast, geom) 

any help greatly appreciated,

Kind Regards,
James

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