summaryrefslogtreecommitdiffstats
path: root/rasodmg/test/earth_16.ql
blob: c53508a20ac6f09a3240480103137b24c4adec26 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
// Selection of images out of a collection with 15 800x800x8bit 
// images. There is one image each with only 255, 254, 253 as a
// value. And there is one image each with one value each out of
// 250, 251, 252. No other image contains value greater than 249.

// one img with some_cell

SELECT img[0:252,0:252]
FROM   earth_16 as img
WHERE  some_cell ( img = 252c )

// two imgs with some_cell

SELECT img[0:252,0:252]
FROM   earth_16 as img
WHERE  some_cell ( img = 252c OR img = 251c )

// three imgs with some_cell

SELECT img[0:252,0:252]
FROM   earth_16 as img
WHERE  some_cell ( img = 252c OR img = 251c OR img = 250c )

// one img with all_cell

SELECT img[0:252,0:252]
FROM   earth_16 as img
WHERE  all_cell ( img >= 255c )

// two imgs with all_cell

SELECT img[0:252,0:252]
FROM   earth_16 as img
WHERE  all_cell ( img >= 254c )

// three imgs with all_cell

SELECT img[0:252,0:252]
FROM   earth_16 as img
WHERE  all_cell ( img >= 253c )