Select color (TQL)

Select	Unit	Description	Fixed clause amount	Polygon based
COLOR	HEX Color	Returns the value of the Color of an Item in HEX format	1	false

Allowed clause parameters

Param	Type	Description	Limits search polygon
ADDRESS	Item ID	Address with ID	false
AREA	Item ID	Area with ID	true
BUILDING	Item ID	Building with ID	false
CATEGORY	Category	Category with this value Buildings of this category	false
FUNCTION	Item ID	Function with ID	false
INDICATOR	Item ID	Indicator with ID	false
NEIGHBORHOOD	Item ID	Neighborhood with ID	true
NET_FUNCTION	Item ID	Net Function with ID	false
NET_LINE	Item ID	Net line with ID	false
OVERLAY	Item ID	Overlay with ID	false
PANEL	Item ID	Panel with ID	false
STAKEHOLDER	Item ID	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	Item ID	Terrain of Terrain Type with ID	true
ZONE	Item ID	Zone with ID	true

Examples

• SELECT_COLOR_WHERE_AREA_IS_5

Returns the HEX Color of the COLOR Attribute of the Area with Item ID 5.

• SELECT_COLOR_WHERE_STAKEHOLDER_IS_3

Returns the HEX Color of the color parameter of the Stakeholder with Item ID 3.

• SELECT_COLOR_WHERE_STAKEHOLDERTYPE_IS_MUNICIPALITY

Returns the HEX Color of the default color of the Stakeholder Type MUNICIPALITY.

Notes

• Function (TQL Param) and Building (TQL Param) return the color of their first Category.

---

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