The 0.75 is the quantile.<div><br></div><div>I will report the bugs. Thanks for the help/info.</div><div><br></div><div>Joan<br><br><div class="gmail_quote">On 27 January 2012 20:31, Stephen Woodbridge <span dir="ltr"><<a href="mailto:woodbri@swoodbridge.com">woodbri@swoodbridge.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Joan,<br>
<br>
Looking at the function the Bborie posted:<div class="im"><br>
<br>
st_quantile(rastertable text, rastercolumn text, nband int DEFAULT<br>
1, exclude_nodata_value boolean DEFAULT TRUE, quantiles double<br>
precision[] DEFAULT NULL)<br>
<br></div>
The 3rd parameter is the band number. What is the 0.75 supposed to represent? My guess is that is getting truncated to 0 and it is trying to process band=0 which might not be valid.<br>
<br>
But it should not crash, so please write two bugs against this:<br>
1. for the missing doc<br>
2. for the crash if you enter 0.75<br>
<br>
Thanks,<br>
-Steve<div class="im"><br>
<br>
On 1/27/2012 2:19 PM, Joan wrote:<br>
</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
Hi Steve,<br>
<br>
I have gotten the same problem (db server stopped running).<br>
<br>
Joan<br>
<br>
On 27 January 2012 20:05, Stephen Woodbridge <<a href="mailto:woodbri@swoodbridge.com" target="_blank">woodbri@swoodbridge.com</a><br></div><div class="im">
<mailto:<a href="mailto:woodbri@swoodbridge.com" target="_blank">woodbri@swoodbridge.<u></u>com</a>>> wrote:<br>
<br>
Joan,<br>
<br>
I've never used these function, but try doing:<br>
<br>
select st_quantile('kbd_ext', 'rast', 0.75);<br>
<br>
Since you probably do not want this called once for every row in the<br>
table.<br>
<br>
-Steve<br>
<br>
<br>
On 1/27/2012 2:03 PM, Joan wrote:<br>
<br>
Hi Bborie,<br>
<br>
This is my query and it crashes the db server.<br>
select st_quantile('kbd_ext', 'rast', 0.75) from kbd_ext limit 10;<br>
<br>
Joan<br>
<br>
On 27 January 2012 19:14, Bborie Park <<a href="mailto:bkpark@ucdavis.edu" target="_blank">bkpark@ucdavis.edu</a><br>
<mailto:<a href="mailto:bkpark@ucdavis.edu" target="_blank">bkpark@ucdavis.edu</a>><br></div><div><div class="h5">
<mailto:<a href="mailto:bkpark@ucdavis.edu" target="_blank">bkpark@ucdavis.edu</a> <mailto:<a href="mailto:bkpark@ucdavis.edu" target="_blank">bkpark@ucdavis.edu</a>>>> wrote:<br>
<br>
Hey Joan,<br>
<br>
Assuming your whole coverage is in a table, you should use the<br>
table/column version of ST_Quantile (which by the looks of it is<br>
undocumented for some reason).<br>
<br>
The function definition of ST_Quantile(rastertable,<br>
rastercolumn) is...<br>
<br>
st_quantile(rastertable text, rastercolumn text, nband int<br>
DEFAULT<br>
1, exclude_nodata_value boolean DEFAULT TRUE, quantiles double<br>
precision[] DEFAULT NULL)<br>
<br>
At the moment an aggregate version of ST_Quantile (and the other<br>
basic stats functions) does not exist. It is expected that<br>
one will<br>
be written for PostGIS 2.1 assuming dev-time is available.<br>
<br>
-bborie<br>
<br>
<br>
On 01/27/2012 09:06 AM, Joan wrote:<br>
<br>
Hi,<br>
<br>
I would like to find the quantile values of a whole raster<br>
coverage, but<br>
ST_Quantile returns quantile values of each tile. Which<br>
would be<br>
the best<br>
method to approximate the quantile value of the whole<br>
coverage?<br>
<br>
Regards,<br>
<br>
Joan<br>
<br>
<br>
<br>
<br>
______________________________ _________________<br>
postgis-users mailing list<br>
postgis-users@postgis. <a href="http://refractions.net" target="_blank">refractions.net</a><br></div></div>
<<a href="http://refractions.net" target="_blank">http://refractions.net</a>><br>
<mailto:<a href="mailto:postgis-users@postgis" target="_blank">postgis-users@postgis</a>. <a href="http://refractions.net" target="_blank">refractions.net</a><div class="im"><br>
<mailto:<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.<u></u>refractions.net</a>>><br>
<a href="http://postgis.refractions" target="_blank">http://postgis.refractions</a>. net/mailman/listinfo/postgis- users<br>
<br>
<<a href="http://postgis.refractions" target="_blank">http://postgis.refractions</a>. net/mailman/listinfo/postgis- users<br>
<<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.<u></u>net/mailman/listinfo/postgis-<u></u>users</a>>><br>
<br>
<br>
--<br>
Bborie Park<br>
Programmer<br>
Center for Vectorborne Diseases<br>
UC Davis<br>
530-752-8380<br>
<a href="mailto:bkpark@ucdavis.edu" target="_blank">bkpark@ucdavis.edu</a> <mailto:<a href="mailto:bkpark@ucdavis.edu" target="_blank">bkpark@ucdavis.edu</a>><br></div>
<mailto:<a href="mailto:bkpark@ucdavis.edu" target="_blank">bkpark@ucdavis.edu</a> <mailto:<a href="mailto:bkpark@ucdavis.edu" target="_blank">bkpark@ucdavis.edu</a>>><div class="im"><br>
<br>
______________________________ _________________<br>
postgis-users mailing list<br></div>
postgis-users@postgis. <a href="http://refractions.net" target="_blank">refractions.net</a> <<a href="http://refractions.net" target="_blank">http://refractions.net</a>><br>
<mailto:<a href="mailto:postgis-users@postgis" target="_blank">postgis-users@postgis</a>. <a href="http://refractions.net" target="_blank">refractions.net</a><div class="im"><br>
<mailto:<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.<u></u>refractions.net</a>>><br>
<a href="http://postgis.refractions" target="_blank">http://postgis.refractions</a>. net/mailman/listinfo/postgis- users<br>
<<a href="http://postgis.refractions" target="_blank">http://postgis.refractions</a>. net/mailman/listinfo/postgis- users<br>
<<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.<u></u>net/mailman/listinfo/postgis-<u></u>users</a>>><br>
<br>
<br>
<br>
<br>
<br>
______________________________ _________________<br>
postgis-users mailing list<br>
postgis-users@postgis. <a href="http://refractions.net" target="_blank">refractions.net</a><br>
<mailto:<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.<u></u>refractions.net</a>><br>
<a href="http://postgis.refractions" target="_blank">http://postgis.refractions</a>. net/mailman/listinfo/postgis- users<br>
<<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.<u></u>net/mailman/listinfo/postgis-<u></u>users</a>><br>
<br>
<br></div><div class="im">
______________________________ _________________<br>
postgis-users mailing list<br>
postgis-users@postgis. <a href="http://refractions.net" target="_blank">refractions.net</a><br>
<mailto:<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.<u></u>refractions.net</a>><br>
<a href="http://postgis.refractions" target="_blank">http://postgis.refractions</a>. net/mailman/listinfo/postgis- users<br>
<<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.<u></u>net/mailman/listinfo/postgis-<u></u>users</a>><br>
<br>
<br>
<br>
<br>
______________________________<u></u>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.<u></u>refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.<u></u>net/mailman/listinfo/postgis-<u></u>users</a><br>
</div></blockquote><div class="HOEnZb"><div class="h5">
<br>
______________________________<u></u>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.<u></u>refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.<u></u>net/mailman/listinfo/postgis-<u></u>users</a><br>
</div></div></blockquote></div><br></div>