TQL Examples - Revision history

Frank@tygron.nl at 14:48, 8 July 2026

2026-07-08T14:48:06Z

← Older revision		Revision as of 14:48, 8 July 2026
Line 162:		Line 162:
	<syntaxhighlight copy>SELECT_GRIDMAX_WHERE_GRIDTYPE_IS_HEATSTRESS_AND_RESULTTYPE_IS_PET_AND_TIMEFRAME_IS_X</syntaxhighlight>		<syntaxhighlight copy>SELECT_GRIDMAX_WHERE_GRIDTYPE_IS_HEATSTRESS_AND_RESULTTYPE_IS_PET_AND_TIMEFRAME_IS_X</syntaxhighlight>

	To query the maximum water level for ~~each [[Area]]~~ with the attribute ~~WATER_LEVEL_MEASUREMENT, given~~ a ~~calculated [[~~Rainfall Overlay~~]] that has the result child [[Surface last datum result type (Water Overlay)\|~~ Surface Last Datum~~]], for each timeframe~~, returning an array of arrays of ~~decimal values,~~ one ~~array~~ per Area:		To query the maximum water level per timeframe for Areas with the WATER_LEVEL_MEASUREMENT attribute using a Rainfall Overlay's Surface Last Datum result, returning an array of arrays of decimals (one per Area):
	<syntaxhighlight copy>SELECT_GRIDMIN_WHERE_GRIDTYPE_IS_RAINFALL_AND_RESULTTYPE_IS_SURFACE_LAST_DATUM_AND_TIMEFRAME_IS_X_AND_AREA_IS_YA_WATER_LEVEL_MEASUREMENT</syntaxhighlight>		<syntaxhighlight copy>SELECT_GRIDMIN_WHERE_GRIDTYPE_IS_RAINFALL_AND_RESULTTYPE_IS_SURFACE_LAST_DATUM_AND_TIMEFRAME_IS_X_AND_AREA_IS_YA_WATER_LEVEL_MEASUREMENT</syntaxhighlight>

Line 256:		Line 256:
	{{main\|Select latitude (TQL)}}		{{main\|Select latitude (TQL)}}

	To query the latitude (~~east~~-~~west~~) of the centerpoint of an Area with Item ID 0, in LOCAL coordinates, returning a decimal number:		To query the latitude (north-south) of the centerpoint of an Area with Item ID 0 in LOCAL coordinates, returning a decimal number:
	<syntaxhighlight copy>SELECT_LATITUDE_WHERE_AREA_IS_0</syntaxhighlight>		<syntaxhighlight copy>SELECT_LATITUDE_WHERE_AREA_IS_0</syntaxhighlight>

Line 292:		Line 292:
	{{main\|Select longitude (TQL)}}		{{main\|Select longitude (TQL)}}

	To query the longitude (east-west) of the centerpoint of an Area with Item ID 0, in LOCAL coordinates, returning a decimal number:		To query the longitude (east-west) of the centerpoint of an Area with Item ID 0 in LOCAL coordinates, returning a decimal number:
	<syntaxhighlight copy>SELECT_LONGITUDE_WHERE_AREA_IS_0</syntaxhighlight>		<syntaxhighlight copy>SELECT_LONGITUDE_WHERE_AREA_IS_0</syntaxhighlight>

Line 434:		Line 434:
	==Units==		==Units==
	{{main\|Select units (TQL)}}		{{main\|Select units (TQL)}}
	Use this select to obtain ~~the amount of (~~housing~~) units~~ for ~~a particular [[Building]], Buildings within an area and other conditions~~. ~~As a Building can belong to multiple Building [[Categories]], internally the amount of units of a building is~~ calculated by multiplying ~~the~~ floor space ~~of a building with~~ the [[Unit size (Category Value)]] and ~~the corresponding~~ [[Category weight (Category Value)]].		Use this select to obtain housing unit counts for buildings or areas. Units are calculated by multiplying floor space by the [[Unit size (Category Value)]] and [[Category weight (Category Value)]] of the building's categories.

	To query the amount of units for a particular Building with Item ID 1669, returning a decimal number:		To query the amount of units for a particular Building with Item ID 1669, returning a decimal number:
Line 481:		Line 481:
	'''Parking requirements of social housing'''		'''Parking requirements of social housing'''

	~~The parking~~ demand ~~is based on a [[function values \| function value]] of each function, and~~ is defined as "parking places per m2"~~. Parking demand is not~~ based on ~~the footprint of a~~ building~~, but the~~ size ~~of a building. i.e. a building 4 floors high needs more parking~~ than ~~a building with the same~~ footprint ~~2 floors high~~.		Parking demand is defined as "parking places per m2" based on total building size rather than footprint.

	<code>SELECT_FLOORSIZE_WHERE_CATEGORY_IS_SOCIAL_AND_CATEGORYMULT_IS_PARKING_LOTS_DEMAND_PER_M2</code>		<code>SELECT_FLOORSIZE_WHERE_CATEGORY_IS_SOCIAL_AND_CATEGORYMULT_IS_PARKING_LOTS_DEMAND_PER_M2</code>

Line 504:		Line 503:
	'''Quality of livability in a neighborhood'''		'''Quality of livability in a neighborhood'''

	The [[livability (Overlay)\|livability overlay]] calculates~~, for each [[grid overlay\|~~grid cell~~]], the average livability~~. ~~The best indication of how well a certain region performs in terms of livability would be to average~~ these values ~~out. That way, its possible to compare places which are not the same size~~. (In this example, the [[neighborhood]] in question has the ID 1, and the [[grid overlay\|grid]] of [[livability (Overlay)\|livability]] has the ID 4.)		The [[livability (Overlay)\|livability overlay]] calculates average livability per grid cell. Averaging these values allows for comparison between regions of different sizes. (In this example, the [[neighborhood]] in question has the ID 1, and the [[grid overlay\|grid]] of [[livability (Overlay)\|livability]] has the ID 4.)

	<code>SELECT_GRIDAVG_WHERE_NEIGHBORHOOD_IS_1_AND_GRID_IS_4</code>		<code>SELECT_GRIDAVG_WHERE_NEIGHBORHOOD_IS_1_AND_GRID_IS_4</code>
Line 517:		Line 516:
	'''The area of open water which is flooded by more than 20 cm of water'''		'''The area of open water which is flooded by more than 20 cm of water'''

	The [[Rainfall (Overlay)\|rainfall overlay]] ~~calculates what amounts of water ends up where. The overlay's~~ results are in meters. ~~If we wish to provide some minimum value~~, ~~it must be in meters as well.~~ 20 cm is 0,2 ~~meters~~. ~~The [[project]] can also contain multiple types of [[terrain\|~~water~~]]. All types of have one thing in common~~, ~~namely that they all have~~ the WATER attribute~~, which can be tested against~~. (In this example, the grid of [[Rainfall (Overlay)\|inundation]] has the ID 4, and has its result type set to water stress.)		The [[Rainfall (Overlay)\|rainfall overlay]] results are in meters (e.g., 20 cm = 0.2 m). To target specific water terrains, use the shared WATER attribute. (In this example, the grid of [[Rainfall (Overlay)\|inundation]] has the ID 4, and has its result type set to water stress.)

	<code>SELECT_LANDSIZE_WHERE_MINGRIDVALUE_IS_0.2_AND_GRID_IS_4_AND_TERRAIN_WITH_ATTRIBUTE_IS_WATER</code>		<code>SELECT_LANDSIZE_WHERE_MINGRIDVALUE_IS_0.2_AND_GRID_IS_4_AND_TERRAIN_WITH_ATTRIBUTE_IS_WATER</code>

Maxim@tygron.com at 15:45, 2 July 2026

2026-07-02T15:45:20Z

← Older revision		Revision as of 15:45, 2 July 2026
Line 416:		Line 416:
	==Token==		==Token==
	<noinclude>{{main\|Select token (TQL)}}</noinclude>		<noinclude>{{main\|Select token (TQL)}}</noinclude>
	To query the Session's API token to interact with the [[~~REST~~ API]], returning the token as a String:		To query the Session's API token to interact with the [[API]], returning the token as a String:
	<syntaxhighlight copy>SELECT_TOKEN_WHERE_</syntaxhighlight>		<syntaxhighlight copy>SELECT_TOKEN_WHERE_</syntaxhighlight>
	To query the Web token to interact with the [[Endpoints\|Web endpoints]], for the Stakeholder with Item ID 4, returning the token as a String:		To query the Web token to interact with the [[Endpoints\|Web endpoints]], for the Stakeholder with Item ID 4, returning the token as a String:

Frank@tygron.nl: /* Grid Max */

2026-06-25T14:30:16Z

Grid Max

← Older revision		Revision as of 14:30, 25 June 2026
Line 162:		Line 162:
	<syntaxhighlight copy>SELECT_GRIDMAX_WHERE_GRIDTYPE_IS_HEATSTRESS_AND_RESULTTYPE_IS_PET_AND_TIMEFRAME_IS_X</syntaxhighlight>		<syntaxhighlight copy>SELECT_GRIDMAX_WHERE_GRIDTYPE_IS_HEATSTRESS_AND_RESULTTYPE_IS_PET_AND_TIMEFRAME_IS_X</syntaxhighlight>

	To query the maximum water level for each [[Area]] with the attribute WATER_LEVEL_MEASUREMENT, given a calculated [[Rainfall Overlay]] that has the result child [[Surface last datum result type(Water Overlay)\| Surface Last Datum]], for each timeframe, returning an array of arrays of decimal values, one array per Area:		To query the maximum water level for each [[Area]] with the attribute WATER_LEVEL_MEASUREMENT, given a calculated [[Rainfall Overlay]] that has the result child [[Surface last datum result type (Water Overlay)\| Surface Last Datum]], for each timeframe, returning an array of arrays of decimal values, one array per Area:
	<syntaxhighlight copy>SELECT_GRIDMIN_WHERE_GRIDTYPE_IS_RAINFALL_AND_RESULTTYPE_IS_SURFACE_LAST_DATUM_AND_TIMEFRAME_IS_X_AND_AREA_IS_YA_WATER_LEVEL_MEASUREMENT</syntaxhighlight>		<syntaxhighlight copy>SELECT_GRIDMIN_WHERE_GRIDTYPE_IS_RAINFALL_AND_RESULTTYPE_IS_SURFACE_LAST_DATUM_AND_TIMEFRAME_IS_X_AND_AREA_IS_YA_WATER_LEVEL_MEASUREMENT</syntaxhighlight>

Frank@tygron.nl: /* Grid Max */

2026-06-25T14:30:08Z

Grid Max

← Older revision		Revision as of 14:30, 25 June 2026
Line 162:		Line 162:
	<syntaxhighlight copy>SELECT_GRIDMAX_WHERE_GRIDTYPE_IS_HEATSTRESS_AND_RESULTTYPE_IS_PET_AND_TIMEFRAME_IS_X</syntaxhighlight>		<syntaxhighlight copy>SELECT_GRIDMAX_WHERE_GRIDTYPE_IS_HEATSTRESS_AND_RESULTTYPE_IS_PET_AND_TIMEFRAME_IS_X</syntaxhighlight>

	To query the maximum water level for each [[Area]] with the attribute WATER_LEVEL_MEASUREMENT, given a calculated [[Rainfall Overlay]] that has the result child [[Surface last datum (Water Overlay)\| Surface Last Datum]], for each timeframe, returning an array of arrays of decimal values, one array per Area:		To query the maximum water level for each [[Area]] with the attribute WATER_LEVEL_MEASUREMENT, given a calculated [[Rainfall Overlay]] that has the result child [[Surface last datum result type(Water Overlay)\| Surface Last Datum]], for each timeframe, returning an array of arrays of decimal values, one array per Area:
	<syntaxhighlight copy>SELECT_GRIDMIN_WHERE_GRIDTYPE_IS_RAINFALL_AND_RESULTTYPE_IS_SURFACE_LAST_DATUM_AND_TIMEFRAME_IS_X_AND_AREA_IS_YA_WATER_LEVEL_MEASUREMENT</syntaxhighlight>		<syntaxhighlight copy>SELECT_GRIDMIN_WHERE_GRIDTYPE_IS_RAINFALL_AND_RESULTTYPE_IS_SURFACE_LAST_DATUM_AND_TIMEFRAME_IS_X_AND_AREA_IS_YA_WATER_LEVEL_MEASUREMENT</syntaxhighlight>

Frank@tygron.nl: /* Grid Max */

2026-06-25T14:28:47Z

Grid Max

← Older revision		Revision as of 14:28, 25 June 2026
Line 161:		Line 161:
	To query the maximum temperature each timeframe for a Heat Stress Overlay, return an array of decimal values:		To query the maximum temperature each timeframe for a Heat Stress Overlay, return an array of decimal values:
	<syntaxhighlight copy>SELECT_GRIDMAX_WHERE_GRIDTYPE_IS_HEATSTRESS_AND_RESULTTYPE_IS_PET_AND_TIMEFRAME_IS_X</syntaxhighlight>		<syntaxhighlight copy>SELECT_GRIDMAX_WHERE_GRIDTYPE_IS_HEATSTRESS_AND_RESULTTYPE_IS_PET_AND_TIMEFRAME_IS_X</syntaxhighlight>

			To query the maximum water level for each [[Area]] with the attribute WATER_LEVEL_MEASUREMENT, given a calculated [[Rainfall Overlay]] that has the result child [[Surface last datum (Water Overlay)\| Surface Last Datum]], for each timeframe, returning an array of arrays of decimal values, one array per Area:
			<syntaxhighlight copy>SELECT_GRIDMIN_WHERE_GRIDTYPE_IS_RAINFALL_AND_RESULTTYPE_IS_SURFACE_LAST_DATUM_AND_TIMEFRAME_IS_X_AND_AREA_IS_YA_WATER_LEVEL_MEASUREMENT</syntaxhighlight>

	==Grid Volume==		==Grid Volume==

Frank@tygron.nl: /* Grid Min */

2026-06-25T13:54:46Z

Grid Min

← Older revision		Revision as of 13:54, 25 June 2026
Line 149:		Line 149:
	To query the minimum temperature each timeframe for a Heat Stress Overlay, return an array of decimal values:		To query the minimum temperature each timeframe for a Heat Stress Overlay, return an array of decimal values:
	<syntaxhighlight copy>SELECT_GRIDMIN_WHERE_GRIDTYPE_IS_HEATSTRESS_AND_RESULTTYPE_IS_PET_AND_TIMEFRAME_IS_X</syntaxhighlight>		<syntaxhighlight copy>SELECT_GRIDMIN_WHERE_GRIDTYPE_IS_HEATSTRESS_AND_RESULTTYPE_IS_PET_AND_TIMEFRAME_IS_X</syntaxhighlight>

			To query the minimum temperature each timeframe of a Heat Stress Overlay, for each Area with the Attribute TEMPERATURE_MEASUREMENT, returning an array of arrays of decimal values, one array per Area:
			<syntaxhighlight copy>SELECT_GRIDMIN_WHERE_GRIDTYPE_IS_HEATSTRESS_AND_RESULTTYPE_IS_PET_AND_TIMEFRAME_IS_X_AND_AREA_IS_YA_TEMPERATURE_MEASUREMENT</syntaxhighlight>

	==Grid Max==		==Grid Max==

Frank@tygron.nl: /* Grid Max */

2026-06-25T06:56:12Z

Grid Max

← Older revision		Revision as of 06:56, 25 June 2026
Line 152:		Line 152:
	==Grid Max==		==Grid Max==
	{{main\|Select gridmax (TQL)}}		{{main\|Select gridmax (TQL)}}

			To query te maximun value of a Grid Overlay with Item ID 12, return a decimal number:
			<syntaxhighlight copy>SELECT_GRIDMAX_WHERE_GRID_IS_12</syntaxhighlight>

			To query the maximum temperature each timeframe for a Heat Stress Overlay, return an array of decimal values:
			<syntaxhighlight copy>SELECT_GRIDMAX_WHERE_GRIDTYPE_IS_HEATSTRESS_AND_RESULTTYPE_IS_PET_AND_TIMEFRAME_IS_X</syntaxhighlight>

	==Grid Volume==		==Grid Volume==

Frank@tygron.nl: /* Grid Min */

2026-06-25T06:36:29Z

Grid Min

← Older revision		Revision as of 06:36, 25 June 2026
Line 143:		Line 143:
	==Grid Min==		==Grid Min==
	{{main\|Select gridmin (TQL)}}		{{main\|Select gridmin (TQL)}}

			To query the minimum (ignoring {{nodata}} values) of a Grid Overlay with Item ID 10, return a decimal number:
			<syntaxhighlight copy>SELECT_GRIDMIN_WHERE_GRID_IS_10</syntaxhighlight>

			To query the minimum temperature each timeframe for a Heat Stress Overlay, return an array of decimal values:
			<syntaxhighlight copy>SELECT_GRIDMIN_WHERE_GRIDTYPE_IS_HEATSTRESS_AND_RESULTTYPE_IS_PET_AND_TIMEFRAME_IS_X</syntaxhighlight>

	==Grid Max==		==Grid Max==

Frank@tygron.nl: /* Floorsize */

2026-06-24T20:50:12Z

Floorsize

← Older revision		Revision as of 20:50, 24 June 2026
Line 109:		Line 109:
	To query the amount of floor space of residences in areas of low livability (for example -0.5), according to a Livability Overlay, returning a decimal number:		To query the amount of floor space of residences in areas of low livability (for example -0.5), according to a Livability Overlay, returning a decimal number:
	<syntaxhighlight copy>SELECT_FLOORSIZE_WHERE_GRIDTYPE_IS_LIVABILITY_AND_MAXGRIDVALUE_IS_MINUS_0.5_AND_RESIDENCE_IS_TRUE</syntaxhighlight>		<syntaxhighlight copy>SELECT_FLOORSIZE_WHERE_GRIDTYPE_IS_LIVABILITY_AND_MAXGRIDVALUE_IS_MINUS_0.5_AND_RESIDENCE_IS_TRUE</syntaxhighlight>


	===Advanced Floorsize===		===Advanced Floorsize===

Frank@tygron.nl: /* Floorsize */

2026-06-24T20:48:53Z

Floorsize

← Older revision		Revision as of 20:48, 24 June 2026
Line 106:		Line 106:
	To query the amount of parking lots required by residental Buildings, for each Neighborhood, returning an array of decimal numbers:		To query the amount of parking lots required by residental Buildings, for each Neighborhood, returning an array of decimal numbers:
	<syntaxhighlight copy>SELECT_FLOORSIZE_WHERE_CATEGORYMULT_IS_PARKING_LOTS_DEMAND_PER_M2_AND_RESIDENCE_IS_TRUE_AND_NEIGHBORHOOD_IS_X</syntaxhighlight>		<syntaxhighlight copy>SELECT_FLOORSIZE_WHERE_CATEGORYMULT_IS_PARKING_LOTS_DEMAND_PER_M2_AND_RESIDENCE_IS_TRUE_AND_NEIGHBORHOOD_IS_X</syntaxhighlight>

			To query the amount of floor space of residences in areas of low livability (for example -0.5), according to a Livability Overlay, returning a decimal number:
			<syntaxhighlight copy>SELECT_FLOORSIZE_WHERE_GRIDTYPE_IS_LIVABILITY_AND_MAXGRIDVALUE_IS_MINUS_0.5_AND_RESIDENCE_IS_TRUE</syntaxhighlight>


	===Advanced Floorsize===		===Advanced Floorsize===