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

Peter Tittmann ptittmann at gmail.com
Fri Apr 6 16:32:49 PDT 2012

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

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.


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>

More information about the postgis-users mailing list