CQL support¶
Limitations¶
The support to CQL is limited to Simple CQL filter and thus it allows to query with the following predicates:
comparison predicates
spatial predicates
temporal predicates
Formats¶
At the moment pygeoapi supports only the CQL dialect with the JSON encoding CQL-JSON.
Providers¶
As of now the available providers supported for CQL filtering are limited to only Elasticsearch.
Queries¶
The following type of queries are supported right now:
between
predicate queryLogical
and
query withbetween
andeq
expressionSpatial query with
bbox
Examples¶
A between
example for a specific property through an HTTP POST request:
curl --location --request POST 'http://localhost:5000/collections/nhsl_hazard_threat_all_indicators_s_bc/items?f=json&limit=50&filter-lang=cql-json' \
--header 'Content-Type: application/query-cql-json' \
--data-raw '{
"between": {
"value": { "property": "properties.MHn_Intensity" },
"lower": 0.59,
"upper": 0.60
}
}'