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
42
|
// 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_64 as img
WHERE some_cell ( img[700:799,300:399] = 252c )
// two imgs with some_cell
SELECT img[0:252,0:252]
FROM earth_64 as img
WHERE some_cell ( img[700:799,300:399] = 252c OR img[700:799,300:399] = 251c )
// three imgs with some_cell
SELECT img[0:252,0:252]
FROM earth_64 as img
WHERE some_cell ( img[700:799,300:399] = 252c OR img[700:799,300:399] = 251c
OR img[700:799,300:399] = 250c )
// one img with all_cell
SELECT img[0:252,0:252]
FROM earth_64 as img
WHERE all_cell ( img[700:799,300:399] >= 255c )
// two imgs with all_cell
SELECT img[0:252,0:252]
FROM earth_64 as img
WHERE all_cell ( img[700:799,300:399] >= 254c )
// three imgs with all_cell
SELECT img[0:252,0:252]
FROM earth_64 as img
WHERE all_cell ( img[700:799,300:399] >= 253c )
|