Hi all, I am having trouble geting the following query to run in a efficient manner:
Select ST_AsText(point) as point,ST_WorldToRasterCoordX(raster,point) as cx,ST_WorldToRasterCoordY(raster,point) as cy,ST_AsGDALRaster(raster,'GTiff') as image from ( SELECT geom as point, ST_UNION(ST_CLIP(rast,ST_BUFFER(geom,10000))) as raster from wv_ned_utm83 , pointsouth where ST_INTERSECTS(rast,ST_Buffer(geom,10000)) and ST_VALUE(rast,geom) != 0 GROUP BY geom limit 1 ) as foo"
Any suggestions or help would be greatly appreciated!! Thanks, Nathaniel Hunter Clay _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
