TQL tutorial - Revision history

Frank@tygron.nl at 12:40, 13 April 2026

2026-04-13T12:40:04Z

Frank@tygron.nl: /* Introduction to TQL */

2026-03-05T13:54:39Z

Introduction to TQL

← Older revision		Revision as of 13:54, 5 March 2026
Line 51:		Line 51:
	Most statements return numerical values which can be used in calculations. Some statements return some form of text.		Most statements return numerical values which can be used in calculations. Some statements return some form of text.

	When statements return numerical values, these values are usually presented in a unitless way. Results are always in the appropriate [[Unit ~~System~~\|SI Unit]], e.g. meters for length or height and square meters for surface areas.		When statements return numerical values, these values are usually presented in a unitless way. Results are always in the appropriate [[Unit system\|SI Unit]], e.g. meters for length or height and square meters for surface areas.

	==Query tool==		==Query tool==

Frank@tygron.nl: /* Introduction to TQL */

2026-03-05T13:54:25Z

Introduction to TQL

← Older revision		Revision as of 13:54, 5 March 2026
Line 51:		Line 51:
	Most statements return numerical values which can be used in calculations. Some statements return some form of text.		Most statements return numerical values which can be used in calculations. Some statements return some form of text.

	When statements return numerical values, these values are usually presented in a unitless way. Results are always in the appropriate [[Unit ~~Type~~]], e.g. meters for length or height and square meters for surface areas.		When statements return numerical values, these values are usually presented in a unitless way. Results are always in the appropriate [[Unit System\|SI Unit]], e.g. meters for length or height and square meters for surface areas.

	==Query tool==		==Query tool==

Frank@tygron.nl: /* Introduction to TQL */

2026-03-05T13:52:56Z

Introduction to TQL

← Older revision		Revision as of 13:52, 5 March 2026
Line 51:		Line 51:
	Most statements return numerical values which can be used in calculations. Some statements return some form of text.		Most statements return numerical values which can be used in calculations. Some statements return some form of text.

	When statements return numerical values, these values are usually presented in a unitless way. Results are always in the appropriate [[~~SI unit~~]], e.g. meters for length or height and square meters for surface areas.		When statements return numerical values, these values are usually presented in a unitless way. Results are always in the appropriate [[Unit Type]], e.g. meters for length or height and square meters for surface areas.

	==Query tool==		==Query tool==

Rudolf@tygron.nl at 14:25, 9 September 2024

2024-09-09T14:25:20Z

← Older revision		Revision as of 14:25, 9 September 2024
Line 5:		Line 5:
	\|Start your project. This can be a pre-existing project, or a newly created project.		\|Start your project. This can be a pre-existing project, or a newly created project.

	{{clear}}{{page break}}		{{page break}} {{clear}}{{page break}}
	===Creating various Grid Overlays===		===Creating various Grid Overlays===
	To experiment with queries for grid calculation results, a [[Grid Overlay]] should be present in the [[Project]]. To experiment appropriately with the various statements, both a [[Heat Stress Overlay]] a [[Water Overlay]] are good [[Grid Overlay]]s to add and experiment with.		To experiment with queries for grid calculation results, a [[Grid Overlay]] should be present in the [[Project]]. To experiment appropriately with the various statements, both a [[Heat Stress Overlay]] a [[Water Overlay]] are good [[Grid Overlay]]s to add and experiment with.

Rudolf@tygron.nl: /* Grid statements */

2024-03-20T09:17:57Z

Grid statements

← Older revision		Revision as of 09:17, 20 March 2024
Line 263:		Line 263:
	; SELECT_GRIDAVG		; SELECT_GRIDAVG
	: The average value of grid values.		: The average value of grid values.

			The grid average is calculated by taking all values in grid cells across the entire indicated region, and averaging them. Due to the uniform nature of grid cells, the average of those values is the same no matter if its considered in relation to a count of grid cells or to a count of surface area.

	Create and execute the following query, with the [[Heat Stress Overlay]]'s [[Pet result type (Heat Overlay)\|PE Temperature]] selected for the GRID clause: {{code\|1=SELECT_GRIDAVG_WHERE_GRID_IS_...}}		Create and execute the following query, with the [[Heat Stress Overlay]]'s [[Pet result type (Heat Overlay)\|PE Temperature]] selected for the GRID clause: {{code\|1=SELECT_GRIDAVG_WHERE_GRID_IS_...}}
Line 272:		Line 274:
	; SELECT_GRIDVOLUME		; SELECT_GRIDVOLUME
	: The volume of grid values. The surface area of each individual grid cell, multiplied by its respective value.		: The volume of grid values. The surface area of each individual grid cell, multiplied by its respective value.

			The grid volume is calculated by taking all values in grid cells across the entire indicated region, and adding them together to a total. The result takes into account the size of grid cells. In other words, the volume returned for a single cell is the surface area of the cell multiplied by the value of the cell. If the value of the cell is (also) in meters (m), the result for the volume of a single cell is in cubic meters (m³).

	Create and execute the following query, with the [[Water Overlay]] selected for the GRID clause: {{code\|1=SELECT_GRIDVOLUME_WHERE_GRID_IS_...}}		Create and execute the following query, with the [[Water Overlay]] selected for the GRID clause: {{code\|1=SELECT_GRIDVOLUME_WHERE_GRID_IS_...}}

Rudolf@tygron.nl at 09:11, 20 March 2024

2024-03-20T09:11:10Z

← Older revision		Revision as of 09:11, 20 March 2024
Line 211:		Line 211:
	{{page break}}		{{page break}}
	{{header\|level=3\|color=#c45911\|Assignments}}		{{header\|level=3\|color=#c45911\|Assignments}}
	# Create a query to find the amount of social housing in the [[Project area]] which is owned by a collective corporation.		# Create a query to find the amount of social housing in the [[Project area]] which is owned by a collective corporation. (Note that the result may be 0, if the [[Project]] has no ownership data.)
	# Create a query to find the surface area in a [[Neighborhood]] which is taken up by shops ~~and restaurants~~.		# Create a query to find the surface area in a [[Neighborhood]] which is taken up by shops.

	{{page break}}		{{page break}}

Rudolf@tygron.nl: /* Statements */

2024-03-06T15:51:55Z

Statements

← Older revision		Revision as of 15:51, 6 March 2024
Line 155:		Line 155:
	The preceding spatial clauses can be summarized in the following overview:		The preceding spatial clauses can be summarized in the following overview:
	<gallery style='margin:auto;width:fit-content;text-align:left;' widths='250px' heights='250px'>		<gallery style='margin:auto;width:fit-content;text-align:left;' widths='250px' heights='250px'>
	File:Tql select landsize representation.png\|thumb\|left~~\|400px~~\|Landsize: surface area.		File:Tql select landsize representation.png\|thumb\|left\|Landsize: surface area.
	File:Tql select lotsize representation.png\|thumb\|left~~\|400px~~\|Lotsize: landsize occupied by Buildings.		File:Tql select lotsize representation.png\|thumb\|left\|Lotsize: landsize occupied by Buildings.
	File:Tql select floorsize representation.png\|thumb\|left~~\|400px~~\|Floorsize: floorspace in buildings based on lotsize and floors.		File:Tql select floorsize representation.png\|thumb\|left\|Floorsize: floorspace in buildings based on lotsize and floors.
	File:Tql select units representation.png\|thumb\|left~~\|400px~~\|Units: housing units based on floorsize.		File:Tql select units representation.png\|thumb\|left\|Units: housing units based on floorsize.
	</gallery>		</gallery>

Rudolf@tygron.nl: /* Statements */

2024-03-06T15:50:13Z

Statements

← Older revision		Revision as of 15:50, 6 March 2024
Line 154:		Line 154:
	{{page break}}		{{page break}}
	The preceding spatial clauses can be summarized in the following overview:		The preceding spatial clauses can be summarized in the following overview:
	<gallery style='margin:auto;width:fit-content;text-align:left;'>		<gallery style='margin:auto;width:fit-content;text-align:left;' widths='250px' heights='250px'>
	File:Tql select landsize representation.png\|thumb\|left\|400px\|Landsize: surface area.		File:Tql select landsize representation.png\|thumb\|left\|400px\|Landsize: surface area.
	File:Tql select lotsize representation.png\|thumb\|left\|400px\|Lotsize: landsize occupied by Buildings.		File:Tql select lotsize representation.png\|thumb\|left\|400px\|Lotsize: landsize occupied by Buildings.

Rudolf@tygron.nl: /* Statements */

2024-03-06T15:48:52Z

Statements

← Older revision		Revision as of 15:48, 6 March 2024
Line 155:		Line 155:
	The preceding spatial clauses can be summarized in the following overview:		The preceding spatial clauses can be summarized in the following overview:
	<gallery style='margin:auto;width:fit-content;text-align:left;'>		<gallery style='margin:auto;width:fit-content;text-align:left;'>
	File:Tql select landsize representation.png\|thumb\|left\|~~300px~~\|Landsize: surface area.		File:Tql select landsize representation.png\|thumb\|left\|400px\|Landsize: surface area.
	File:Tql select lotsize representation.png\|thumb\|left\|~~300px~~\|Lotsize: landsize occupied by Buildings.		File:Tql select lotsize representation.png\|thumb\|left\|400px\|Lotsize: landsize occupied by Buildings.
	File:Tql select floorsize representation.png\|thumb\|left\|~~300px~~\|Floorsize: floorspace in buildings based on lotsize and floors.		File:Tql select floorsize representation.png\|thumb\|left\|400px\|Floorsize: floorspace in buildings based on lotsize and floors.
	File:Tql select units representation.png\|thumb\|left\|~~300px~~\|Units: housing units based on floorsize.		File:Tql select units representation.png\|thumb\|left\|400px\|Units: housing units based on floorsize.
	</gallery>		</gallery>

← Older revision		Revision as of 12:40, 13 April 2026
Line 17:		Line 17:
	Next, ensure a [[Heat Stress Overlay]] is present in the [[Project]].		Next, ensure a [[Heat Stress Overlay]] is present in the [[Project]].

	{{editor location\|Overlays\|dropdown=Environmental\|3=Heat Overlay}}		{{editor location\|Overlays\|dropdown=Environmental\|3=Heat Stress Overlay}}
	[[File:tql-preparation-heat.jpg\|frame\|center\|Adding a [[Heat Overlay]].]]		[[File:tql-preparation-heat.jpg\|frame\|center\|Adding a [[Heat Stress Overlay]].]]

	In addition to a [[Heat Stress Overlay]]'s default [[Pet result type (Heat Overlay)\|PE Temperature]] result, a shade result can be output as well, which will be useful in demonstrating specific query structures.		In addition to a [[Heat Stress Overlay]]'s default [[Pet result type (Heat Stress Overlay)\|PE Temperature]] result, a shade result can be output as well, which will be useful in demonstrating specific query structures.

	After adding the [[Heat Stress Overlay]], it will have been selected in the [[Editor]], and its details are opened in the [[right panel]].		After adding the [[Heat Stress Overlay]], it will have been selected in the [[Editor]], and its details are opened in the [[right panel]].

	Click on "Configuration Wizard" to open the [[Heat Overlay ~~Wizard (Heat Overlay)\|Heat Overlay Configuration~~ Wizard]].		Click on "Configuration Wizard" to open the [[Heat Stress Overlay Wizard]].
	[[File:tql-preparation-heat-configuration.jpg\|frame\|center\|The configuration wizard can be opened from the [[right panel]].]]		[[File:tql-preparation-heat-configuration.jpg\|frame\|center\|The configuration wizard can be opened from the [[right panel]].]]

Line 30:		Line 30:
	Continue to the step regarding "Output Overlays".		Continue to the step regarding "Output Overlays".

	Ensure that, in addition to the default [[Pet result type (Heat Overlay)\|PE Temperature]] result, the [[Shade result type (Heat Overlay)\|Shade]] result type is selected as well.		Ensure that, in addition to the default [[Pet result type (Heat Stress Overlay)\|PE Temperature]] result, the [[Shade result type (Heat Stress Overlay)\|Shade]] result type is selected as well.
	[[File:tql-preparation-heat-outputs.jpg\|frame\|center\|Activate the Shade result type by checking its checkbox.]]		[[File:tql-preparation-heat-outputs.jpg\|frame\|center\|Activate the Shade result type by checking its checkbox.]]

	Close the [[Heat Overlay ~~Wizard (Heat Overlay)\|Heat Overlay Configuration~~ Wizard]]		Close the [[Heat Stress Overlay Wizard]]

	{{page break}}		{{page break}}
Line 233:		Line 233:
	: Consulting only grid cells the value of which is at most the specified value. (Exclusive, so a cell with the exact value is excluded.)		: Consulting only grid cells the value of which is at most the specified value. (Exclusive, so a cell with the exact value is excluded.)

	Create and execute the following query, with the [[Heat Stress Overlay]]'s [[Pet result type (Heat Overlay)\|PE Temperature]] selected for the GRID clause: {{code\|1=SELECT_LANDSIZE_WHERE_MINGRIDVALUE_IS_35.0_AND_MAXGRIDVALUE_IS_45.0_AND_GRID_IS_...}}		Create and execute the following query, with the [[Heat Stress Overlay]]'s [[Pet result type (Heat Stress Overlay)\|PE Temperature]] selected for the GRID clause: {{code\|1=SELECT_LANDSIZE_WHERE_MINGRIDVALUE_IS_35.0_AND_MAXGRIDVALUE_IS_45.0_AND_GRID_IS_...}}

	The result is the surface area in the [[Project area]] which has calculated temperatures in the range of 35°C to 45°C.		The result is the surface area in the [[Project area]] which has calculated temperatures in the range of 35°C to 45°C.
Line 266:		Line 266:
	The grid average is calculated by taking all values in grid cells across the entire indicated region, and averaging them. Due to the uniform nature of grid cells, the average of those values is the same no matter if its considered in relation to a count of grid cells or to a count of surface area.		The grid average is calculated by taking all values in grid cells across the entire indicated region, and averaging them. Due to the uniform nature of grid cells, the average of those values is the same no matter if its considered in relation to a count of grid cells or to a count of surface area.

	Create and execute the following query, with the [[Heat Stress Overlay]]'s [[Pet result type (Heat Overlay)\|PE Temperature]] selected for the GRID clause: {{code\|1=SELECT_GRIDAVG_WHERE_GRID_IS_...}}		Create and execute the following query, with the [[Heat Stress Overlay]]'s [[Pet result type (Heat Stress Overlay)\|PE Temperature]] selected for the GRID clause: {{code\|1=SELECT_GRIDAVG_WHERE_GRID_IS_...}}

	The result is the average temperature in the [[Project area]].		The result is the average temperature in the [[Project area]].
Line 288:		Line 288:
	When working with grids which only output a 0 or 1, some statements can be used in slightly more efficient ways as well.		When working with grids which only output a 0 or 1, some statements can be used in slightly more efficient ways as well.

	Create and execute the following query, with the [[Heat Stress Overlay]]'s [[Shade result type (Heat Overlay)\|Shade Coverage]] selected for the GRID clause: {{code\|1=SELECT_GRIDAVG_WHERE_GRID_IS_...}}		Create and execute the following query, with the [[Heat Stress Overlay]]'s [[Shade result type (Heat Stress Overlay)\|Shade Coverage]] selected for the GRID clause: {{code\|1=SELECT_GRIDAVG_WHERE_GRID_IS_...}}

	The result is the average value of shade coverage in the [[Project area]].		The result is the average value of shade coverage in the [[Project area]].
Line 296:		Line 296:

	{{page break}}		{{page break}}
	Create and execute the following query, with the [[Heat Stress Overlay]]'s [[Shade result type (Heat Overlay)\|Shade Coverage]] selected for the GRID clause: {{code\|1=SELECT_GRIDVOLUME_WHERE_GRID_IS_...}}		Create and execute the following query, with the [[Heat Stress Overlay]]'s [[Shade result type (Heat Stress Overlay)\|Shade Coverage]] selected for the GRID clause: {{code\|1=SELECT_GRIDVOLUME_WHERE_GRID_IS_...}}

	The result is the "volume" of shade coverage in the [[Project area]].		The result is the "volume" of shade coverage in the [[Project area]].