Select gridarea (TQL)

Select	Unit	Description	Fixed clause amount	Polygon based
GRIDAREA	decimal	Returns the count of grid values, multiplied with the grid cell's area size, for the query polygons and a specified Grid	No	true

Allowed 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
GRID	Item ID	Grid of Grid Overlay with ID	false
GRID_WITH_ATTRIBUTE	Attribute	Grid of Grid Overlay with non zero Attribute value	false
GRIDTYPE	Overlay type	Grid of Grid Overlay with specified type	true
MAP	Map Type	Only items present in this Map Type	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
TIMEFRAME	timeframe	Specifies which timeframe to select when processing a particular Grid	false
ZONE	Item ID	Zone with ID	true
ZONE_WITH_ATTRIBUTE	Attribute	Zone with non zero Attribute value	true

Notes

• The Grid should be specified with the Grid (TQL Param) or Grid with attribute (TQL Param)
• The grid cell's area size is dependent on the Grid, not on the GRID_CELL_SIZE_M Setting.

---

TQL

Select

Active • Attribute • Color • Distance • Expenses • Floorsize • Global • Height • ID • Iteration • Iterations • Gridavg • Gridmin • Gridmax • Gridvolume • Gridstdev • Landpolygons • Landsize • Length • Levees

• Lotpolygons • Lotsize • Name • Net State • Revenue • Sessionstate • State • Target • Token • Topfloor • Units

Update

Address • Area • Building • Global • Indicator • Neighborhood • Net Function • Net Line • Net Load • Panel • Terrain • Zone

Other

Update • Clause