How to make the Green Garden Indicator - Revision history

Frank@tygron.nl at 14:50, 14 July 2026

2026-07-14T14:50:39Z

← Older revision		Revision as of 14:50, 14 July 2026
Line 3:		Line 3:
	==Steps==		==Steps==
	===First steps===		===First steps===
	The first step of designing the indicator ~~existed out of~~ defining the boundary conditions. Hereby you need to clearly define what do you want to get out of your indicator, in other words, what do you want it to show. Once this is clear you can start working towards shaping your indicator. The reason Amersfoort was chosen as the location for the digital twin, was because of the availability of data of neighborhood composition. The neighborhood Leusderkwartier and ~~some other neighborhoods where~~ mapped by the municipality of Amersfoort ~~in a previous~~. The last step of the use case was implementing the measures so during a session it would be possible to adjust the gardens.		The first step in designing the indicator was defining the boundary conditions. Hereby you need to clearly define what do you want to get out of your indicator, in other words, what do you want it to show. Once this is clear you can start working towards shaping your indicator. The reason Amersfoort was chosen as the location for the digital twin, was because of the availability of data of neighborhood composition. The neighborhood Leusderkwartier and several others were mapped by the municipality of Amersfoort previously. The last step of the use case was implementing the measures so during a session it would be possible to adjust the gardens.
	[https://www.stowa.nl/sites/default/files/assets/PUBLICATIES/Publicaties%202000-2010/Publicaties%202005-2009/STOWA%202009-02%20RIONED.pdf Case Study] about urban precipitation water.		[https://www.stowa.nl/sites/default/files/assets/PUBLICATIES/Publicaties%202000-2010/Publicaties%202005-2009/STOWA%202009-02%20RIONED.pdf Case Study] about urban precipitation water.
	[[File:Use_case_piek.png\|thumb\|500px\|right\|Example of garden improvemenent in Leusderkwartier, Amersfoort.]]		[[File:Use_case_piek.png\|thumb\|500px\|right\|Example of garden improvemenent in Leusderkwartier, Amersfoort.]]
Line 23:		Line 23:

	==Queries==		==Queries==
	The final step of realizing the indicator was defining the queries. ~~An import~~ tool ~~with helping to shape~~ indicators is the [[query tool]]. This tool can also directly shows the calculated outcomes of the query. The queries used in the Green Garden indicator are summed up below an explanation of their creation.		The final step of realizing the indicator was defining the queries. A helpful tool for shaping indicators is the [[query tool]]. This tool can also directly shows the calculated outcomes of the query. The queries used in the Green Garden indicator are summed up below an explanation of their creation.
	====Roofs====		====Roofs====
	The first step in shaping the indicator was setting up the query for the roofs. To obtain this information from the platform, the query selects all the [[Buildings]] in the [[project]] with at least one floor (hence:[[Floor height m (Function Value)\|FLOOR_HEIGHT_M]]) and a minimum floor height of 2m. This floor height was obtained from the model, by making an [[Average_Overlay\|Average Overlay]] based on the [[Floor height m (Function Value)\|FLOOR_HEIGHT_M]] attribute. This is also a useful tool to visualize the area that will be selected.		The first step in shaping the indicator was setting up the query for the roofs. To obtain this information from the platform, the query selects all the [[Buildings]] in the [[project]] with at least one floor (hence:[[Floor height m (Function Value)\|FLOOR_HEIGHT_M]]) and a minimum floor height of 2m. This floor height was obtained from the model, by making an [[Average_Overlay\|Average Overlay]] based on the [[Floor height m (Function Value)\|FLOOR_HEIGHT_M]] attribute. This is also a useful tool to visualize the area that will be selected.

	====Garden (paved)====		====Garden (paved)====
	The paved garden parameter is based on a new [[Function]] made for this use case. Gardens in the {{software}} are by default green gardens, so this query obtains the area value of all the gardens. For paved gardens, a new garden type was created by duplicating a [[Function]] and editing the [[function values]], .		The paved garden parameter is based on a new [[Function]] made for this use case. Gardens in the {{software}} are by default green gardens, so this query obtains the area value of all the gardens. For paved gardens, a new garden type was created by duplicating a [[Function]] and editing the [[function values]].

	====Public Pavement====		====Public Pavement====
Line 34:		Line 34:

	====Garden (green)====		====Garden (green)====
	As explained above, green gardens are currently the default type of garden in the {{software}}. This query, therefore, obtains the lotsize of all the gardens in the model. Subsequently, the area value of the paved garden is ~~substracted of~~ this total.		As explained above, green gardens are currently the default type of garden in the {{software}}. This query, therefore, obtains the lotsize of all the gardens in the model. Subsequently, the area value of the paved garden is subtracted from this total.

	====Public Green====		====Public Green====
	The last category is public green, this category is also a sum function. This parameter sums the surfaces of ~~the categories~~ parks and nature and ~~also add~~ the area of terrain ~~that has~~ no function~~, this is~~ often grassland. By subtracting the total area with the total built environment, the difference will show the undeveloped land.		The last category is public green, this category is also a sum function. This parameter sums the surfaces of parks and nature and adds the area of terrain with no function (often grassland). By subtracting the total area with the total built environment, the difference will show the undeveloped land.
	[[File:Querie2.JPG\|framed\|left\|The Queries used in the Green Garden meter.]]		[[File:Querie2.JPG\|framed\|left\|The Queries used in the Green Garden meter.]]
	<br clear=all>		<br clear=all>

	===Defining the output===		===Defining the output===
	The ~~visible~~ output ~~of the indicator uses a~~ HTML table ~~to show the output~~. The values in the output are percentages, these percentages are obtained by dividing each value with the total area of the project. In the project [[Measures]] were created. During a [[session]], for example transforming a paved garden into a green garden could be done. Because the indicator both calculates the current and future design, the difference between those two parameters shows possible progress and what consequences of a certain measure can be.		The indicator's output is displayed in an HTML table. The values in the output are percentages, these percentages are obtained by dividing each value with the total area of the project. In the project [[Measures]] were created. During a [[session]], for example transforming a paved garden into a green garden could be done. Because the indicator both calculates the current and future design, the difference between those two parameters shows possible progress and what consequences of a certain measure can be.

	==Implementing the Indicator==		==Implementing the Indicator==
	~~The last step~~ was ~~using the step~~ in a scenario session~~, therefor I needed as previously said adjust~~ the standard garden ~~of the platform,~~ to ~~make a distinction~~ between paved and green gardens. The [[How_to_change_Function_Values_for_a_Function\|function]] values of the paved garden are now similar to those of an urban square. In the scenario created for the Amersfoort Green Garden Use Case, it was possible for inhabitants and the municipality to ''upgrade'' their paved gardens to green garden.		Finally, the indicator was used in a scenario session; this required adjusting the platform's standard garden to distinguish between paved and green gardens. The [[How_to_change_Function_Values_for_a_Function\|function]] values of the paved garden are now similar to those of an urban square. In the scenario created for the Amersfoort Green Garden Use Case, it was possible for inhabitants and the municipality to ''upgrade'' their paved gardens to green garden.

	{{article end		{{article end

Maxim@tygron.com at 10:44, 13 July 2026

2026-07-13T10:44:13Z

← Older revision		Revision as of 10:44, 13 July 2026
Line 52:		Line 52:
	* [[Indicator]]		* [[Indicator]]
	* [[Practice#Adding, removing and adjusting an indicator\|Adjusting an Indicator]]		* [[Practice#Adding, removing and adjusting an indicator\|Adjusting an Indicator]]
			* [[Indicators Tutorial]]
	\|howtos=		\|howtos=
	* [[How to configure a Query for an Excel Indicator]]		* [[How to configure a Query for an Excel Indicator]]
	* [[How to implement an Excel Indicator]]
	* [[How to manually adjust Indicators in Excel]]		* [[How to manually adjust Indicators in Excel]]
	* [[How to use the Query Tool to test queries from an Excel Indicator spreadsheet]]		* [[How to use the Query Tool to test queries from an Excel Indicator spreadsheet]]

Frank@tygron.nl: /* Roofs */

2024-01-10T10:32:47Z

Roofs

← Older revision		Revision as of 10:32, 10 January 2024
Line 25:		Line 25:
	The final step of realizing the indicator was defining the queries. An import tool with helping to shape indicators is the [[query tool]]. This tool can also directly shows the calculated outcomes of the query. The queries used in the Green Garden indicator are summed up below an explanation of their creation.		The final step of realizing the indicator was defining the queries. An import tool with helping to shape indicators is the [[query tool]]. This tool can also directly shows the calculated outcomes of the query. The queries used in the Green Garden indicator are summed up below an explanation of their creation.
	====Roofs====		====Roofs====
	The first step in shaping the indicator was setting up the query for the roofs. To obtain this information from the platform, the query selects all the [[Buildings]] in the [[project]] with at least one floor (hence:FLOOR_HEIGHT_M) and a minimum floor height of 2m. This floor height was obtained from the model, by making an [[Average_Overlay\|Average Overlay]] based on the [[Floor height m (Function Value)\|FLOOR_HEIGHT_M]] attribute. This is also a useful tool to visualize the area that will be selected.		The first step in shaping the indicator was setting up the query for the roofs. To obtain this information from the platform, the query selects all the [[Buildings]] in the [[project]] with at least one floor (hence:[[Floor height m (Function Value)\|FLOOR_HEIGHT_M]]) and a minimum floor height of 2m. This floor height was obtained from the model, by making an [[Average_Overlay\|Average Overlay]] based on the [[Floor height m (Function Value)\|FLOOR_HEIGHT_M]] attribute. This is also a useful tool to visualize the area that will be selected.

	====Garden (paved)====		====Garden (paved)====

Frank@tygron.nl at 10:32, 10 January 2024

2024-01-10T10:32:28Z

← Older revision		Revision as of 10:32, 10 January 2024
Line 25:		Line 25:
	The final step of realizing the indicator was defining the queries. An import tool with helping to shape indicators is the [[query tool]]. This tool can also directly shows the calculated outcomes of the query. The queries used in the Green Garden indicator are summed up below an explanation of their creation.		The final step of realizing the indicator was defining the queries. An import tool with helping to shape indicators is the [[query tool]]. This tool can also directly shows the calculated outcomes of the query. The queries used in the Green Garden indicator are summed up below an explanation of their creation.
	====Roofs====		====Roofs====
	The first step in shaping the indicator was setting up the query for the roofs. To obtain this information from the platform, the query selects all the [[Buildings]] in the [[project]] with at least one floor (hence:FLOOR_HEIGHT_M) and a minimum floor height of 2m. This floor height was obtained from the model, by making an [[Average_Overlay\|Average Overlay]] based on the FLOOR_HEIGHT_M attribute. This is also a useful tool to visualize the area that will be selected.		The first step in shaping the indicator was setting up the query for the roofs. To obtain this information from the platform, the query selects all the [[Buildings]] in the [[project]] with at least one floor (hence:FLOOR_HEIGHT_M) and a minimum floor height of 2m. This floor height was obtained from the model, by making an [[Average_Overlay\|Average Overlay]] based on the [[Floor height m (Function Value)\|FLOOR_HEIGHT_M]] attribute. This is also a useful tool to visualize the area that will be selected.

	====Garden (paved)====		====Garden (paved)====

Frank@tygron.nl at 10:31, 10 January 2024

2024-01-10T10:31:56Z

← Older revision		Revision as of 10:31, 10 January 2024
Line 25:		Line 25:
	The final step of realizing the indicator was defining the queries. An import tool with helping to shape indicators is the [[query tool]]. This tool can also directly shows the calculated outcomes of the query. The queries used in the Green Garden indicator are summed up below an explanation of their creation.		The final step of realizing the indicator was defining the queries. An import tool with helping to shape indicators is the [[query tool]]. This tool can also directly shows the calculated outcomes of the query. The queries used in the Green Garden indicator are summed up below an explanation of their creation.
	====Roofs====		====Roofs====
	The first step in shaping the indicator was setting up the query for the roofs. To obtain this information from the platform, the query selects all the [[Buildings]] in the [[project]] with at least one floor (hence:~~FLOOR_HEIGH_M~~) and a minimum floor height of 2m. This floor height was obtained from the model, by making an [[Average_Overlay\|Average Overlay]] based on the ~~FLOOR_HEIGH_M~~ attribute. This is also a useful tool to visualize the area that will be selected.		The first step in shaping the indicator was setting up the query for the roofs. To obtain this information from the platform, the query selects all the [[Buildings]] in the [[project]] with at least one floor (hence:FLOOR_HEIGHT_M) and a minimum floor height of 2m. This floor height was obtained from the model, by making an [[Average_Overlay\|Average Overlay]] based on the FLOOR_HEIGHT_M attribute. This is also a useful tool to visualize the area that will be selected.

	====Garden (paved)====		====Garden (paved)====

Frank@tygron.nl at 10:31, 10 January 2024

2024-01-10T10:31:00Z

← Older revision		Revision as of 10:31, 10 January 2024
Line 1:		Line 1:
	This How-to will explain how the [[Indicator]] in the [https://www.tygron.com/en/2020/10/16/neighbourhood-peak-precipitation-mitigation/ Neighborhood Green Garden Meter] use case was made and which steps were needed to create it. To successfully implement this indicator, knowledge about the [[Tygron_Query_Language \| Tygron Query Language]] and the use of [[Excel\|Excel in the Tygron platform]].		This How-to will explain how the [[Indicator]] in the [https://www.tygron.com/en/2020/10/16/neighbourhood-peak-precipitation-mitigation/ Neighborhood Green Garden Meter] use case was made and which steps were needed to create it. To successfully implement this indicator, knowledge about the [[Tygron_Query_Language \| Tygron Query Language]] and the use of [[Excel\|Excel in the Tygron platform]] is required.

	==Steps==		==Steps==

Frank@tygron.nl: /* Public Pavement */

2023-02-28T16:06:16Z

Public Pavement

← Older revision		Revision as of 16:06, 28 February 2023
Line 31:		Line 31:

	====Public Pavement====		====Public Pavement====
	The third parameter is public pavement, this includes all the public ''hard'' surfaces, like sidewalks and roads. The query, therefore, is a SUM statement in Excel with all the public hard surfaces used in the [[~~3D model~~]] of Leusderkwartier. These parameters included values of bridge, road, paved area and intersections.		The third parameter is public pavement, this includes all the public ''hard'' surfaces, like sidewalks and roads. The query, therefore, is a SUM statement in Excel with all the public hard surfaces used in the [[project]] of Leusderkwartier. These parameters included values of bridge, road, paved area and intersections.

	====Garden (green)====		====Garden (green)====

Frank@tygron.nl at 12:04, 30 January 2023

2023-01-30T12:04:42Z

← Older revision		Revision as of 12:04, 30 January 2023
Line 25:		Line 25:
	The final step of realizing the indicator was defining the queries. An import tool with helping to shape indicators is the [[query tool]]. This tool can also directly shows the calculated outcomes of the query. The queries used in the Green Garden indicator are summed up below an explanation of their creation.		The final step of realizing the indicator was defining the queries. An import tool with helping to shape indicators is the [[query tool]]. This tool can also directly shows the calculated outcomes of the query. The queries used in the Green Garden indicator are summed up below an explanation of their creation.
	====Roofs====		====Roofs====
	The first step in shaping the indicator was setting up the query for the roofs. To obtain this information from the platform, the query selects all the [[Buildings]] in the [[~~3D world~~]] with at least one floor (hence:FLOOR_HEIGH_M) and a minimum floor height of 2m. This floor height was obtained from the model, by making an [[Average_Overlay\|Average Overlay]] based on the FLOOR_HEIGH_M attribute. This is also a useful tool to visualize the area that will be selected.		The first step in shaping the indicator was setting up the query for the roofs. To obtain this information from the platform, the query selects all the [[Buildings]] in the [[project]] with at least one floor (hence:FLOOR_HEIGH_M) and a minimum floor height of 2m. This floor height was obtained from the model, by making an [[Average_Overlay\|Average Overlay]] based on the FLOOR_HEIGH_M attribute. This is also a useful tool to visualize the area that will be selected.

	====Garden (paved)====		====Garden (paved)====

Frank@tygron.nl: /* Implementing the Indicator */

2023-01-27T08:38:22Z

Implementing the Indicator

← Older revision		Revision as of 08:38, 27 January 2023
Line 59:		Line 59:
	* [[How to change Function Values for a Function]], to adjust the effects actions have on Indicators.		* [[How to change Function Values for a Function]], to adjust the effects actions have on Indicators.
	}}		}}
	[[Category:Indicator]]		[[Category:How-to's]][[Category:Indicator]]

Frank@tygron.nl at 08:38, 27 January 2023

2023-01-27T08:38:00Z

← Older revision		Revision as of 08:38, 27 January 2023
Line 59:		Line 59:
	* [[How to change Function Values for a Function]], to adjust the effects actions have on Indicators.		* [[How to change Function Values for a Function]], to adjust the effects actions have on Indicators.
	}}		}}
			[[Category:Indicator]]