Select landpolygons (TQL)
| 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 is highlighted in the 3D Visualization. It is also possible to cycle through and highlight the other returned polygons. Individual polygons are extracted from the MultiPolygons.
- 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