[postgis-users] Summarystats (Raster, Polygon)

[Andreas Forø Tollefsen]

Hi Pierre and thanks for your reply.

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

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?

Andreas

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>