Clause (TQL)
Revision as of 13:46, 13 February 2023 by Frank@tygron.nl (talk | contribs) (→List of Clause Parameters)
A TQL query statement consists of a command, either Select or Update, and a list of clauses. The clauses provide further specification of the query statement, or a refinement, spatially or property wise. A clause consists of a clause parameter and a clause value, where currently the only supported operator between the parameter and value is IS.
List of Clause Parameters
| Param | Type | Description | Limits search polygon |
|---|---|---|---|
| AREA | Item ID | Area with ID | true |
| AREA_WITH_ATTRIBUTE | Attribute | Area with non zero Attribute value | true |
| BUFFER | decimal | Buffer the limiting search polygon with this value. | true |
| NEIGHBORHOOD | Item ID | Neighborhood with ID | true |
| NEIGHBORHOOD_WITH_ATTRIBUTE | Attribute | Neighborhood with non zero Attribute value | true |
| TERRAIN | Item ID | Terrain of Terrain Type with ID | true |
| TERRAIN_WITH_ATTRIBUTE | Attribute | Terrain is of Terrain Type with non zero Attribute value | true |
| ZONE | Item ID | Zone with ID | true |
| ZONE_WITH_ATTRIBUTE | Attribute | Zone with non zero Attribute value | true |
| Param | Type | Description | Limits search polygon |
|---|---|---|---|
| ATTRIBUTE | Attribute | The attribute used for Buildings to obtain a value. | false |
| ATTRIBUTE_MAX | decimal | Only include Buildings that have an attribute value larger than or equal to this value. | false |
| ATTRIBUTE_MAX | decimal | Only include Buildings that have an attribute value smaller than this value. | false |
| ATTRIBUTE_MULT | Attribute | Multiply the calculated value with the value of this attribute for a Building | false |