Select gridavg (TQL)

Select	Unit	Description	Fixed clause amount	Polygon based
GRIDAVG	decimal	Returns the average Grid value for the query Polygons an a specified Grid	No	true

Allowed 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
GRID	Integer (Item ID), ID, X, Y, XC, YC XA, YA, XK or YK	Grid of Grid Overlay with ID	false
GRID_WITH_ATTRIBUTE	Attribute	Grid of Grid Overlay with non zero Attribute value	false
GRIDTYPE	Grid Type X, Y, XA, YA	Grid of Grid Overlay with specified type	true
GRIDVALUE	decimal	Only include Grid Overlay cells that have a value equal to the one specified	true
ITERATION	positive integer	Query only executes when the current Iteration matches this value	false
MAP	Map Type X, Y, XA, YA	Only Items present in this Map Type	true
MAXGRIDVALUE	decimal	Only include Grid Overlay cells that have a value smaller than the one specified	true
MINGRIDVALUE	decimal	Only include Grid Overlay cells that have a value larger than or equal to the one specified	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
RESULTTYPE	Result type X, Y, XA, YA	Grid of Grid Overlay with specified Result type	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
TIMEFRAME	timeframe X, Y, XA, YA	Specifies which Timeframe to select when processing a particular Grid	false
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

Notes

• The Grid should be specified with the Grid (TQL Param) or Grid with attribute (TQL Param)

---

TQL

Select

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

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

Update

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

Other

Select • Update • Clause