3dcitydb / citydb-tool

3D City Database 5.0 CLI to import/export city model data and to run database operations
Apache License 2.0
9 stars 2 forks source link

Add Filter API #23

Closed clausnagel closed 5 months ago

clausnagel commented 5 months ago

This PR proposes a Filter API for citydb-tool. It allows for defining filter expressions on feature properties stored in the database using boolean, comparison, and spatial predicates as well as arithmetic expressions and functions. The Filter API is fully compatible with the Common Query Language (CQL2) which serves as building block for OGC API - Features - Part 3: Filtering, and even extends CQL2 for more flexibility.

These are the elements added by this PR:

Note that the Filter API is just a first step on the road to a Query API. A next big step is to develop a full mapping of filter expressions onto SQL statements for querying features based on the 3DCityDB v5 schema. Afterwards, more query parameters beyond filters such as feature types, LoDs, appearance themes, etc. will be added.

clausnagel commented 5 months ago

Merging based on offline discussion and review.