Select landpolygons (TQL)

Representation of select landpolygons.

Select	Unit	Description	Fixed clause amount	Polygon based
LANDPOLYGONS	polygons	Returns Polygons of the total land, including Buildings.	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
BUFFER	decimal	Buffer the limiting search Polygon with this value.	true
GRID	Integer (Item ID), ID, X, Y, 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
LAYERTYPE	Layer, X, Y, XA, YA	Only include Buildings and Terrains that are part of this Layer.	true
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
STAKEHOLDER	Integer (Item ID), ID, X, Y, XA, YA, XK or YK	Stakeholder with ID. Only include Plots that are owned by the stakeholder with this ID. Only include Items that are related to this stakeholder.	true
STAKEHOLDERTYPE	Stakeholder Type	Stakeholder Type with this value. Only include Plots that are owned by this type of Stakeholder.	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 returned result is a MultiPolygon in GeoJSON format.
• When used in a panel and the panel is opened, the first returned Polygon of the MultiPolygon is highlighted in the 3D Visualization. It is also possible to cycle through and highlight the other returned Polygons.
• Similar behavior for executed Select lotpolygons queries can be found in the Query Tool.
• Select landpolygons queries can process Plots, but not Buildings; use Select lotpolygons instead.
• Since a cell in Excel can only hold a limited amount of characters, the value written to named cells with Select landpolygon queries is 1 if any polygons were returned and 0 if not.

API Endpoints

• Api session query

---

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