thequery.sql

(
    select
        st_union(wkb_geometry) as wkb_geometry,
        avg(value) as tempval,
        left(quadtree, (z(!scale_denominator!)+5)*2+1) as tqt
    from latticegrid
    where wkb_geometry && !bbox!
    group by tqt
) as data