Custom Query (2765 matches)

test wcps "79-range_on_t_axis-t335.test" with query

for c in (eobstest)
return encode(
  coverage averagesOverTime
  over $T t(0:2)
  values ( avg(c[t($T:$T + 1)] ) ),
"csv")

Iterator in Marray from [0:2] is converted to only [0:1] in Rasql from WCPS 2.0

SELECT encode(MARRAY T in [0:1] VALUES 
(  avg_cells(c[T[0]:T[0] + 1,*:*,*:*])  ) , "csv" ) FROM eobstest AS c

instead of correct convert to iterator [0:2] as in Rasql from WCPS 1.0

select csv(marray i_i in [0:2] values 
avg_cells(c[i_i[0]:(i_i[0])+(1),*:*,*:*])) from eobstest AS c where oid(c)=46081

wcps query "28-construct_histogram_range_condition.test" with query

for c in ( mr )
return
encode( coverage histogram
        over     $n x(-20:20)
        values   condense +
                        over     $px x(10:20),
                                 $py y(10:20)
                        using    (long) c[ i($px), j($py) ]>$n - 1 and c[ i($px), j($py) ]<=$n,
        "csv" )

which is translated to Rasql in WCPS 2.0

SELECT encode(MARRAY n in [-20:20] VALUES 
CONDENSE + OVER px in [10:20,190:200] 
USING (long) c[px[0],px[1]] > n[0] - 1 and c[px[0],px[1]] <= n[0], "csv" )
FROM mr AS c

and it try to calculate boolean expression which returns

{f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,t,f,t,t,t,t,f,t,t,t,t,f,t,f,t,t,t,f,t,f,t}

instead of

{0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,121,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0}

from WCPS 1.0 Rasql

select csv(marray i_i in [-20:20] values
condense + over i_j in [10:20, 10:20]
using (long)((((((c) [i_j[0],i_j[1]])>((i_i[0])-(1))))and((((c) [i_j[0],i_j[1]])<=(i_i[0]))))))
from mr AS c where oid(c)=45569

Now, I'm testing WCPS 2.0 and this ticket still open then I will report to here, test wcps "35-coordinates_in_wgs84_crs.test.out" with WCPS query

for c in (eobstest) return encode(
  (c[
    t(1),
    Long:"http://www.opengis.net/def/crs/EPSG/0/4326" (20:35),
    Lat:"http://www.opengis.net/def/crs/EPSG/0/4326" (10:15)]),
"tiff", "nodata=0")

+ Version 1.0 returns the rasql like (returns TOP-DOWN trimming)

select encode(c[1,-10:20,121:131], "GTiff", 

"nodata=0;xmin=20.0;xmax=35.0;ymin=10.0;ymax=15.0;crs=EPSG:4326") 

from eobstest AS c where oid(c)=46081

+ Version 2.0 returns the Rasql like (returns BOTTOM_UP trimming)

Version 2.0 returns the rasql like 

SELECT encode( ( c[1,-10:19,121:130] ) , "GTiff" , 

"nodata=0;xmin=25.0;xmax=75.5;ymin=-40.5;ymax=75.5;crs=EPSG:4326") 

FROM eobstest AS c

view output in here ​https://drive.google.com/a/fimo.edu.vn/folderview?id=0B_VL2-SVlKPHNHpacVRHUDdQalk&usp=drive_web (file .oracle is WCPS 1.0 and file .out is WCPS 2.0).