Clause (TQL)

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	Value	Description	Limits search polygon
AREA	Integer (Item ID), ID, X, Y, XC, YC XA, YA, XK or YK	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	Integer (Item ID), ID, X, Y, XC, YC XA, YA, XK or YK	Neighborhood with ID	true
NEIGHBORHOOD_WITH_ATTRIBUTE	Attribute	Neighborhood with non zero Attribute value	true
TERRAIN	Integer (Item ID), ID, X, Y, XC, YC XA, YA, XK or YK	Terrain of Terrain Type with ID	true
TERRAIN_WITH_ATTRIBUTE	Attribute	Terrain is of Terrain Type with non zero Attribute value	true
ZONE	Integer (Item ID), ID, X, Y, XC, YC XA, YA, XK or YK	Zone with ID	true
ZONE_WITH_ATTRIBUTE	Attribute	Zone with non zero Attribute value	true

Param	Value	Description	Limits search polygon
ATTRIBUTE	Attribute	The Attribute used for Buildings to obtain a value.	false
ATTRIBUTE_MIN	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

---

TQL Clause parameters

Spatial

Area • Area with attribute • Buffer • Layertype • Map • Neighborhood • Neighborhood with attribute • Terrain • Terrain with attribute • Zone • Zone with attribute

Attribute

Attribute • Attribute max • Attribute min • Attribute mult • Index

Grid

Grid • Grid with attribute • Gridtype • Gridvalue • Maxgridvalue • Mingridvalue • Overlay • Resulttype • Timeframe

Item

Address • Building • Building with attribute • Function • Global • Indicator • Levee • Measure • Panel • Relation • Scenario • Stakeholder

Net

Net line • Net type • Net function • Net load • Net cluster

Property

Category • Categorymult • Crs • Functionmult • Layertype • Iteration • Key • Map • Name • Residence • Road system • Stakeholdertype • State • Term

Replacement

X • XA • XC • XK • Y • YA • YC • YK • ID • Relation • Sort

Other

Select • Update