[postgis-devel] test output

strk strk at keybit.net
Mon Mar 8 16:08:42 PST 2004


I've finally handled to download Mark's data.
Here is the test output summary.

[lo:test_outputs]$ grep avg 52468-polygon-stats10-gain1                             1   (best/worst/avg)        0       0       +-0
    2   (best/worst/avg)        0.22    5.91    +-1.83
    4   (best/worst/avg)        0       6.07    +-1.47
    8   (best/worst/avg)        0       7.05    +-0.55
    16  (best/worst/avg)        0       10.51   +-0.25
    32  (best/worst/avg)        0       7.53    +-0.13

[lo:test_outputs]$ grep avg 52468-polygon-stats10-gainAOI
    1   (best/worst/avg)        0       0       +-0
    2   (best/worst/avg)        0       -1.07   +-0.38
    4   (best/worst/avg)        0       -3.11   +-0.59
    8   (best/worst/avg)        0       -2.95   +-0.22
    16  (best/worst/avg)        0       1.67    +-0.06
    32  (best/worst/avg)        0       -1.57   +-0.02

I've committed the gain = AOI/cell_area back in CVS.

--strk;

On Mon, Mar 08, 2004 at 06:22:04PM +0100, strk wrote:
> Ok, I've modified test output.
> The error gives the difference between estimated and real
> data divided by total number of rows in the table.
> I think now everything is more clear.
> 
> These tables all contain 8102 rows.
> gainAOI still seems to make a difference here.
> 
> [lo:test_outputs]$ grep avg strk-points-stats10-gain1
>     1   (best/worst/avg)        0       0       +-0
>     2   (best/worst/avg)        -0.01   3.33    +-1.74
>     4   (best/worst/avg)        0.01    4.09    +-1
>     8   (best/worst/avg)        0.01    5.81    +-0.68
>     16  (best/worst/avg)        0       5.68    +-0.37
>     32  (best/worst/avg)        0       5.92    +-0.22
> 
> [lo:test_outputs]$ grep avg strk-points-stats10-AOI
>     1   (best/worst/avg)        0       0       +-0
>     2   (best/worst/avg)        0.11    -0.71   +-0.36
>     4   (best/worst/avg)        0       -0.71   +-0.2
>     8   (best/worst/avg)        0       0.69    +-0.09
>     16  (best/worst/avg)        0       -0.48   +-0.04
>     32  (best/worst/avg)        0       0.4     +-0.02
> 
> [lo:test_outputs]$ grep avg strk-multipolygon-stats10-gain1
>     1   (best/worst/avg)        0       0       +-0
>     2   (best/worst/avg)        0.3     1.27    +-0.89
>     4   (best/worst/avg)        0       3.01    +-0.57
>     8   (best/worst/avg)        0       3.36    +-0.46
>     16  (best/worst/avg)        0       3.57    +-0.25
>     32  (best/worst/avg)        0       3.19    +-0.16
> 
> [lo:test_outputs]$ grep avg strk-multipolygon-stats10-AOI
>     1   (best/worst/avg)        0       0       +-0
>     2   (best/worst/avg)        -0.35   -1.01   +-0.65
>     4   (best/worst/avg)        0       -2.49   +-0.35
>     8   (best/worst/avg)        0       -2.43   +-0.18
>     16  (best/worst/avg)        0       -1.83   +-0.1
>     32  (best/worst/avg)        0       -0.95   +-0.05
> 
> And this is old PG74 estimator (with full rows histogram)
> 
> [lo:test_outputs]$ grep avg strk-multipolygon-PG74
>     1   (best/worst/avg)        0       0       +-0
>     2   (best/worst/avg)        -0.54   -2.33   +-1.09
>     4   (best/worst/avg)        0       -3.67   +-0.49
>     8   (best/worst/avg)        0       -1.99   +-0.16
>     16  (best/worst/avg)        0       -1.3    +-0.09
>     32  (best/worst/avg)        0       -0.88   +-0.05
> 
> We are not far uh ?
> 
> Mark, I'll wait your latest test outputs before putting
> gain=AOI/cell_area back.
> 
> --strk;
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel



More information about the postgis-devel mailing list