[postgis-users] Summarystats (Raster, Polygon)

Andreas Forø Tollefsen andreasft at gmail.com
Fri Nov 16 03:41:08 PST 2012

Hi Pierre and thanks for your reply.

My nodata values are well defined and are excluded in the summarystats
I also tried inverting the order of (geom, rast) without this changing the

Could this be explained by the possibility that Postgis and ArcGIS handels
pixels at the border of the polygon differently? i.e. that one includes
pixels intersecting, while the other only includes pixels if the centroid
of the pixel intersects?


2012/11/15 Pierre Racine <Pierre.Racine at sbf.ulaval.ca>

> > Any suggestions why the results are not the same?
> Are your nodata values well defined?
> Might also be, depending on the version you have, the order in which you
> pass the geometry and the raster to the ST_Intersects() function. Try
> inverting them.
> > Any improvements to the query maybe?
> Not really.
> Pierre
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121116/ceca34f6/attachment.html>

More information about the postgis-users mailing list