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 )
|