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	Value	Description	Limits search polygon
ADDRESS	Integer (Item ID), ID, X, Y, XC, YC, XA, YA, XK or YK	Address with ID	false
AREA	Integer (Item ID), ID, X, Y, XC, YC, XA, YA, XK or YK	Area with ID	true
BUILDING	Integer (Item ID), ID, X, Y, XC, YC, XA, YA, XK or YK	Building with ID	false
CATEGORY	Category, X, Y, XA, YA	Category with this value. Buildings of this Category.	false
FUNCTION	Integer (Item ID), ID, X, Y, XC, YC, XA, YA, XK or YK	Function with ID	false
INDICATOR	Integer (Item ID), ID, X, Y, XC, YC, XA, YA, XK or YK	Indicator with ID	false
NEIGHBORHOOD	Integer (Item ID), ID, X, Y, XC, YC, XA, YA, XK or YK	Neighborhood with ID	true
NET_FUNCTION	Integer (Item ID), ID, X, Y, XC, YC, XA, YA, XK or YK	Net Function with ID	false
NET_LINE	Integer (Item ID), ID, X, Y, XC, YC, XA, YA, XK or YK	Net Line with ID	false
OVERLAY	Integer (Item ID), ID, X, Y, XC, YC, XA, YA, XK or YK	Overlay with ID	false
PANEL	Integer (Item ID), ID, X, Y, XC, YC, XA, YA, XK or YK	Panel with ID	false
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
TERRAIN	Integer (Item ID), ID, X, Y, XC, YC, XA, YA, XK or YK	Terrain of Terrain Type with ID	true
ZONE	Integer (Item ID), ID, X, Y, XC, YC, XA, YA, XK or YK	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.

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