[postgis-users] ST_PixelAsPoints

[Samuel Smith]

Hey List,

For a raster successfully ingested into PostGIS, I'm trying to get a dump of all pixel values as vectorizable features.  

SELECT x, y, val, ST_AsText(geom) FROM (SELECT (ST_PixelAsPoints(rast, 1)).* FROM sfdem) as foo;

… doesn't work in PostGIS 2.0.1, but  

SELECT x, y, val, ST_AsText(geom) FROM (SELECT (ST_PixelAsPolygons(rast, 1)).* FROM sfdem) as foo;

… executes but never completes.  

Any ideas? Any alternatives?

Thanks in advance! Sam  

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130131/0832b3fb/attachment.html>