[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] ST_PixelAsPoints
From:       dustymugs <dustymugs () gmail ! com>
Date:       2013-01-31 17:22:25
Message-ID: 510AA851.20901 () gmail ! com
[Download RAW message or body]

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;
> =

> =85 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;
> =

> =85 executes but never completes.  =

> =

> Any ideas? Any alternatives?
> =

> Thanks in advance! Sam  =

> =

> =

> =

> =

> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> =

_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]