cql2 0.5.5

Parse, validate, and convert Common Query Language (CQL2) text and JSON
Documentation 
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
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213

intfield = 50
intfield <> 50
intfield > 90
intfield >= 94
intfield < 7
intfield <= 9

floatfield = 21.1
floatfield <> 32.2
floatfield > 80.7
floatfield >= 90.1
floatfield < 4.0
floatfield <= 5.1

// Math operators on floatfield
floatfield + 1.0 = 21.1
floatfield - 0.1 = 30
floatfield * 2 = 60.2
floatfield / 2 = 1.05
floatfield % 2 between 0.0999 and 0.100001
intfield ^ 2 = 9

// Between
intfield between 1 and 2

// Textfield comparisons
textfield = 'item_1'
textfield <> 'item_2'
textfield > 'item_1'
textfield >= 'item_2'
textfield < 'item_3'
textfield <= 'item_3'
in(textfield, ('item_1', 'item_3', 'Item_50', 'itém_100'))
like(textfield, 'item_%')
like(textfield, 'Item_%')
like(textfield, 'itém_%')
casei(textfield) = 'item_40'
accenti(textfield) = 'item_100'

// Boolfield comparisons
boolfield = true
boolfield <> false
boolfield > false
boolfield >= false
boolfield < true
boolfield <= true


// Spatial operators
s_equals(geom, POLYGON((-164.20711184457008 -62.64591531654267,-172.10355592228504 -48.968872974814005,-187.89644407771496 -48.968872974814005,-195.79288815542992 -62.64591531654267,-187.89644407771496 -76.32295765827133,-172.10355592228504 -76.32295765827133,-164.20711184457008 -62.64591531654267)))
s_intersects(geom, POLYGON((-164.20711184457008 -62.64591531654267,-172.10355592228504 -48.968872974814005,-187.89644407771496 -48.968872974814005,-195.79288815542992 -62.64591531654267,-187.89644407771496 -76.32295765827133,-172.10355592228504 -76.32295765827133,-164.20711184457008 -62.64591531654267)))
s_disjoint(geom, POLYGON((-164.20711184457008 -62.64591531654267,-172.10355592228504 -48.968872974814005,-187.89644407771496 -48.968872974814005,-195.79288815542992 -62.64591531654267,-187.89644407771496 -76.32295765827133,-172.10355592228504 -76.32295765827133,-164.20711184457008 -62.64591531654267)))
s_touches(geom, POLYGON((-164.20711184457008 -62.64591531654267,-172.10355592228504 -48.968872974814005,-187.89644407771496 -48.968872974814005,-195.79288815542992 -62.64591531654267,-187.89644407771496 -76.32295765827133,-172.10355592228504 -76.32295765827133,-164.20711184457008 -62.64591531654267)))
s_within(geom, POLYGON((-164.20711184457008 -62.64591531654267,-172.10355592228504 -48.968872974814005,-187.89644407771496 -48.968872974814005,-195.79288815542992 -62.64591531654267,-187.89644407771496 -76.32295765827133,-172.10355592228504 -76.32295765827133,-164.20711184457008 -62.64591531654267)))
s_overlaps(geom, POLYGON((-164.20711184457008 -62.64591531654267,-172.10355592228504 -48.968872974814005,-187.89644407771496 -48.968872974814005,-195.79288815542992 -62.64591531654267,-187.89644407771496 -76.32295765827133,-172.10355592228504 -76.32295765827133,-164.20711184457008 -62.64591531654267)))
s_crosses(geom, LINESTRING(-170 -90, -170 90))
s_contains(geom, POLYGON((-164.20711184457008 -62.64591531654267,-172.10355592228504 -48.968872974814005,-187.89644407771496 -48.968872974814005,-195.79288815542992 -62.64591531654267,-187.89644407771496 -76.32295765827133,-172.10355592228504 -76.32295765827133,-164.20711184457008 -62.64591531654267)))

// temporal comparisons
datefield = DATE('2020-01-02')
datefield <> DATE('2020-01-02')
datefield > DATE('2020-03-20')
datefield >= DATE('2020-03-20')
datefield < DATE('2020-01-04')
datefield <= DATE('2020-01-04')

ts_start = DATE('2020-01-02')
ts_start <> DATE('2020-01-02')
ts_start > DATE('2020-03-20')
ts_start >= DATE('2020-03-20')
ts_start < DATE('2020-01-04')
ts_start <= DATE('2020-01-04')

datefield = TIMESTAMP('2020-01-02T00:00:00Z')
datefield <> TIMESTAMP('2020-01-02T00:00:00Z')
datefield > TIMESTAMP('2020-03-20T00:00:00Z')
datefield >= TIMESTAMP('2020-03-20T00:00:00Z')
datefield < TIMESTAMP('2020-01-04T00:00:00Z')
datefield <= TIMESTAMP('2020-01-04T00:00:00Z')

ts_start = TIMESTAMP('2020-01-02T00:00:00Z')
ts_start <> TIMESTAMP('2020-01-02T00:00:00Z')
ts_start > TIMESTAMP('2020-03-20T00:00:00Z')
ts_start >= TIMESTAMP('2020-03-20T00:00:00Z')
ts_start < TIMESTAMP('2020-01-04T00:00:00Z')
ts_start <= TIMESTAMP('2020-01-04T00:00:00Z')


// t_before
t_before(ts_start, DATE('2020-02-01'))
t_before(ts_start, TIMESTAMP('2020-02-01T00:00:00Z'))
t_before(ts_start, interval('2020-02-01T00:00:00Z', '2020-05-01T00:00:00Z'))
t_before(DATE('2020-04-01'), ts_start)
t_before(TIMESTAMP('2020-04-01T00:00:00Z'), ts_start)
t_before(interval('2019-04-01T00:00:00Z', '2020-03-01T00:00:00Z'), ts_start)
t_before(interval(ts_start, ts_end), interval('2020-03-01T00:00:00Z', '2020-05-01T00:00:00Z'))
t_before(interval('2019-04-01T00:00:00Z', '2020-02-01T00:00:00Z'), interval(ts_start, ts_end))

// t_after
t_after(DATE('2020-02-01'), ts_start)
t_after(TIMESTAMP('2020-02-01T00:00:00Z'), ts_start)
t_after(interval('2020-02-01T00:00:00Z', '2020-05-01T00:00:00Z'), ts_start)
t_after(ts_start, DATE('2020-04-01'))
t_after(ts_start, TIMESTAMP('2020-04-01T00:00:00Z'))
t_after(ts_start, interval('2019-04-01T00:00:00Z', '2020-03-01T00:00:00Z'))
t_after(interval('2020-03-01T00:00:00Z', '2020-05-01T00:00:00Z'), interval(ts_start, ts_end))
t_after(interval(ts_start, ts_end), interval('2019-04-01T00:00:00Z', '2020-02-01T00:00:00Z'))


// t_meets
t_meets(ts_end, TIMESTAMP('2020-04-01T01:00:00Z'))
t_meets(ts_end, interval('2020-03-01T01:00:00Z', '2020-03-01T01:00:00Z'))
t_meets(TIMESTAMP('2020-04-01T01:00:00Z'), ts_end)
t_meets(interval('2020-03-01T00:00:00Z', '2020-04-01T01:00:00Z'), ts_end)
t_meets(interval(ts_start, ts_end), interval('2020-04-01T01:00:00Z', '2020-05-01T00:00:00Z'))
t_meets(interval('2020-03-01T00:00:00Z', '2020-04-01T00:00:00Z'), interval(ts_start, ts_end))

// t_metby
t_metby(TIMESTAMP('2020-04-01T01:00:00Z'), ts_end)
t_metby(interval('2020-03-01T01:00:00Z', '2020-03-01T01:00:00Z'), ts_end)
t_metby(ts_end, TIMESTAMP('2020-04-01T01:00:00Z'))
t_metby(ts_end, interval('2020-03-01T00:00:00Z', '2020-04-01T01:00:00Z'))
t_metby(interval('2020-04-01T01:00:00Z', '2020-05-01T00:00:00Z'), interval(ts_start, ts_end))
t_metby(interval(ts_start, ts_end), interval('2020-03-01T00:00:00Z', '2020-04-01T00:00:00Z'))

// t_overlaps
t_overlaps(ts_start, interval('2020-04-01T00:00:00Z', '2020-05-01T00:00:00Z'))
t_overlaps(TIMESTAMP('2020-02-15T00:30:00Z'), interval(ts_start, ts_end))
t_overlaps(interval(ts_start, ts_end), interval('2020-03-01T00:00:30Z', '2020-03-05T00:00:00Z'))
t_overlaps(interval('2020-03-01T00:00:00Z', '2020-04-01T00:30:00Z'), interval(ts_start, ts_end))

// t_overlappedby
t_overlappedby(interval('2020-04-01T00:00:00Z', '2020-05-01T00:00:00Z'), ts_start)
t_overlappedby(interval(ts_start, ts_end), TIMESTAMP('2020-02-15T00:30:00Z'))
t_overlappedby(interval('2020-03-01T00:00:30Z', '2020-03-05T00:00:00Z'), interval(ts_start, ts_end))
t_overlappedby(interval(ts_start, ts_end), interval('2020-03-01T00:00:00Z', '2020-04-01T00:30:00Z'))

// t_starts
t_starts(TIMESTAMP('2020-04-01T00:00:00Z'), interval(ts_start, ts_end))
t_starts(interval(ts_start, ts_end), interval('2020-04-01T00:00:00Z', '2020-05-01T00:00:00Z'))
t_starts(interval('2020-04-01T00:00:00Z', '2020-04-01T00:30:00Z'), interval(ts_start, ts_end))

// t_startedby
t_startedby(interval('2020-04-01T00:00:00Z', '2020-05-01T00:00:00Z'), ts_start)
t_startedby(interval('2020-04-01T00:00:00Z', '2020-05-01T00:00:00Z'), interval(ts_start, ts_end))
t_startedby(interval(ts_start, ts_end), interval('2020-04-01T00:00:00Z', '2020-04-01T00:30:00Z'))

// t_during
t_during(ts_start, interval('2020-04-01T00:00:00Z', '2020-05-01T00:00:00Z'))
t_during(TIMESTAMP('2020-04-15T00:00:30Z'), interval(ts_start, ts_end))
t_during(interval(ts_start, ts_end), interval('2020-04-01T00:00:20Z', '2020-04-03T00:00:40Z'))
t_during(interval('2020-04-01T00:00:20Z', '2020-04-01T00:00:40Z'), interval(ts_start, ts_end))

// t_contains
t_contains(interval('2020-04-01T00:00:00Z', '2020-05-01T00:00:00Z'), ts_start)
t_contains(interval(ts_start, ts_end), TIMESTAMP('2020-04-15T00:00:30Z'))
t_contains(interval('2020-04-01T00:00:20Z', '2020-04-03T00:00:40Z'), interval(ts_start, ts_end))
t_contains(interval(ts_start, ts_end), interval('2020-04-01T00:00:20Z', '2020-04-01T00:00:40Z'))

// t_finishes
t_finishes(TIMESTAMP('2020-04-01T01:00:00Z'), interval(ts_start, ts_end))
t_finishes(interval(ts_start, ts_end), interval('2020-03-01T00:00:00Z', '2020-04-01T01:00:00Z'))
t_finishes(interval('2020-04-01T00:00:20Z', '2020-04-01T01:00:00Z'), interval(ts_start, ts_end))

// t_finishedby
t_finishedby(interval(ts_start, ts_end), TIMESTAMP('2020-04-01T01:00:00Z'))
t_finishedby(interval('2020-03-01T00:00:00Z', '2020-04-01T01:00:00Z'), interval(ts_start, ts_end))
t_finishedby(interval(ts_start, ts_end), interval('2020-04-01T00:00:20Z', '2020-04-01T01:00:00Z'))

// t_equals
t_equals(ts_start, TIMESTAMP('2020-04-01T00:00:00Z'))
t_equals(TIMESTAMP('2020-04-01T00:00:00Z'), ts_start)
t_equals(interval(ts_start, ts_end), interval('2020-04-01T00:00:00Z', '2020-04-01T01:00:00Z'))
t_equals(interval('2020-04-01T00:00:00Z', '2020-04-01T01:00:00Z'), interval(ts_start, ts_end))

// t_disjoint

t_disjoint(ts_start, interval('2020-01-01T00:00:00Z', '2020-02-01T00:00:00Z'))
t_disjoint(interval('2020-01-01T00:00:00Z', '2020-04-01T00:00:00Z'), ts_start)
t_disjoint(interval(ts_start, ts_end), interval('2020-01-01T00:00:00Z', '2020-03-01T00:00:00Z'))
t_disjoint(interval('2020-04-01T00:00:00Z', '2020-05-01T00:00:00Z'), interval(ts_start, ts_end))



// Boolean logic
boolfield and true
boolfield or false
not boolfield


// Complex multi-level queries
intfield > 1 and floatfield < 5.0
(textfield = 'item_2' or textfield = 'item_3') and boolfield = true
not (intfield <= 2) or (boolfield and floatfield >= 2.0)
floatfield between -23 and 40 and in(textfield, 'item_2', 'item_3')
s_intersects(geom, POINT(-93 45)) or s_disjoint(geom, POINT(-93 45))
t_before(interval(ts_start, ts_end), interval('2020-01-10T00:00:00Z','2022-02-01T00:00:00Z')) and not boolfield

// Array operators
a_equals(intarrayfield, (1, 2, 3))
a_equals((1, 2, 3), intarrayfield)
a_contains(intarrayfield, (2, 3))
a_contains((1, 2, 3, 4), intarrayfield)
a_containedby(intarrayfield, (1, 2, 3, 4))
a_containedby((1, 2), intarrayfield)
a_overlaps(intarrayfield, (2, 4))
a_overlaps((2, 4), intarrayfield)

nfield is null
nfield = true
nfield <> true
nfield is not null
not(nfield = true)