[postgis-devel] test output

[strk]

I wanted to show you also the estimator results with a
statistic target of 1 (300samples / 12 boxesPerSide histogram).
They look nice :)

[lo:test_outputs]$ grep avg 52468-polygon-stats1
    1   (best/worst/avg)        0       0       +-0
    2   (best/worst/avg)        0       -1.94   +-0.81
    4   (best/worst/avg)        0       4.32    +-0.71
    8   (best/worst/avg)        0       4.32    +-0.22
    16  (best/worst/avg)        0       3.27    +-0.09
    32  (best/worst/avg)        0       -1.63   +-0.04

--strk;

On Tue, Mar 09, 2004 at 01:08:42AM +0100, strk wrote:
> 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
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel