[postgis-users] summarizing a polygon values in a raster

[Peter Tittmann]

Pierre et al.

I have been investigating the apparent disappearance of ST_PixelAsPolygons.
I have updated the database to 2.0 and preformed an apparently successful
soft upgrade on the database. Still when, when trying to use the function i
get:

ERROR:  function st_pixelaspolygons(raster) does not exist

when using \df to list functions, it seems that there are two functions
called ST_PixelAsPolygon (no plural for Polygon):

public | st_pixelaspolygon                | geometry               | rast
raster, band integer, x integer, y integer








public | st_pixelaspolygon                | geometry               | rast
raster, x integer, y integer

I wonder if this is a bug in the function definition or an artifact in an
my database from a previous version.

Thanks very much for any suggestions.

Peter

On Thu, Apr 5, 2012 at 1:49 PM, Pierre Racine
<Pierre.Racine at sbf.ulaval.ca>wrote:

> > Thanks for your suggestion Pierre. I am working with v2.0 and it seems
> that
> > ST_PixelsAsPolygons() is not available. The singular Pixel version works
> though.
> > Any idea why that would be?
>
> Try ST_PixelAsPolygons()... (without the firs 's')
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120406/27f2908e/attachment.html>