[postgis-users] ST_PixelAsPoints

[dustymugs]

ST_PixelAsPoints() isn't part of PostGIS 2.0 but is found in PostGIS 2.1.

As for the second never completing, you'd need to provide more information.

1. How big is sfdem?  How many rows?  Width/height of each rast in each row?

2. Never completing?  How long have you waited?  Have done a test case
by adding LIMIT 10 or so in the subquery?

-bborie

On 01/31/2013 08:53 AM, Samuel Smith wrote:
> 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  
> 
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>