Select levees (TQL): Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
Frank@tygron.nl (talk | contribs)
Tygron, Tygron_admin, Bots, Bureaucrats, Interface administrators, Administrators
41,984 edits
Created page with "{{Select TQL|suppresscategory=true|allowselflinks=true| {{Select TQL|type=row|attribute=LEVEES|unit={{M2}}|description=The total Levee surface size.|fixed=No|polygon=true|}} }} {{Param TQL|suppresscategory=true|allowselflinks=true|list=true| {{: Area (TQL Param)}} {{: Area with attribute (TQL Param)}} {{: Levee (TQL Param)}} {{: Map (TQL Param)}} {{: Neighborhood (TQL Param)}} {{: Neighborhood with attribute (TQL Param)}} {{: Stakeholder (TQL Param)}} {{: Stakeholde..."
 
No edit summary
 
(9 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Select TQL|suppresscategory=true|allowselflinks=true|
{{Select TQL|<onlyinclude>
{{Select TQL|type=row|attribute=LEVEES|unit={{M2}}|description=The total [[Levee]] surface size.|fixed=No|polygon=true|}}
{{Select TQL|tabletype=row|attribute=LEVEES|unit={{M2}}|description=Returns the total [[Levee]] surface size|fixed=No|polygon=true|}}</onlyinclude>
}}
}}
 
==Allowed clause parameters==
{{Param TQL|suppresscategory=true|allowselflinks=true|list=true|
{{Param TQL|
{{: Area (TQL Param)}}
{{: Area (TQL Param)}}
{{: Area with attribute (TQL Param)}}
{{: Area with attribute (TQL Param)}}
Line 17: Line 17:
{{: Zone (TQL Param)}}
{{: Zone (TQL Param)}}
{{: Zone with attribute (TQL Param)}}
{{: Zone with attribute (TQL Param)}}
}}
{{article end
|notes=
* This selection query processes [[measures]] with Levee spatials, intersecting the query polygons.
}}
}}
{{TQL nav}}
{{TQL nav}}

Latest revision as of 09:33, 9 June 2026

Select Unit Description Fixed clause amount Polygon based
LEVEES m² Returns the total Levee surface size 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
LEVEE Integer (Item ID),
ID, X, Y, XC, YC
XA, YA, XK or YK		 Levee with ID false
MAP Map Type
X, Y, XA, YA		 Only Items present in this Map Type 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
STAKEHOLDER Integer (Item ID),
ID, X, Y, XC, YC
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
STATE Timestate Only include Buildings and Measures that are in this Timestate false
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

Notes

  • This selection query processes measures with Levee spatials, intersecting the query polygons.
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


Retrieved from "https://support.tygron.com/w/index.php?title=Select_levees_(TQL)&oldid=84925"