Water stress (Indicator) - Revision history

Hedi@tygron.com: /* Edit the Excel file */

2023-02-03T10:36:43Z

Edit the Excel file

← Older revision		Revision as of 10:36, 3 February 2023
Line 38:		Line 38:
	[[File:ID_adjustment.PNG\|thumb\|300px\|right\|Figure 2. The [[ID]]'s in queries can be changed through the Name Manager.]]		[[File:ID_adjustment.PNG\|thumb\|300px\|right\|Figure 2. The [[ID]]'s in queries can be changed through the Name Manager.]]
	In the Excel file the ID of the [[Rainfall (Overlay)\|Rainfall Overlay]] needs to be changed in the TQL queries in cells G9, H9, J9 and K9.		In the Excel file the ID of the [[Rainfall (Overlay)\|Rainfall Overlay]] needs to be changed in the TQL queries in cells G9, H9, J9 and K9.
	{{Editor steps\|title=\|Open the downloaded Excel spreadsheet ~~from the Index~~.\|On the Formulas tab, in the Define Names group, click the Name Manager.\|Edit the 4 names containing GRID_IS_5 and change the [[ID]] to the correct number (Fig. 2).\|For clarity adjust the corresponding cell formulas accordingly.\|Save your changes and [[Excel#Uploading_and_Downloading\| update the indicator file]] in your project.\| Hover over the [[Calculation_panel\|Calculation panel]] and choose for ''Reset X Queries (slower)'' to update your project.}}		{{Editor steps\|title=\|Open the downloaded Excel spreadsheet.\|On the Formulas tab, in the Define Names group, click the Name Manager.\|Edit the 4 names containing GRID_IS_5 and change the [[ID]] to the correct number (Fig. 2).\|For clarity adjust the corresponding cell formulas accordingly.\|Save your changes and [[Excel#Uploading_and_Downloading\| update the indicator file]] in your project.\| Hover over the [[Calculation_panel\|Calculation panel]] and choose for ''Reset X Queries (slower)'' to update your project.}}
	{{Indicator nav}}		{{Indicator nav}}
	[[Category:Public GeoShare]]		[[Category:Public GeoShare]]

Hedi@tygron.com at 16:10, 2 February 2023

2023-02-02T16:10:43Z

← Older revision		Revision as of 16:10, 2 February 2023
Line 8:		Line 8:
	By default the area type under consideration are neighborhoods and the inundation threshold is set at 0.05 m (i.e., a 5-cm thick layer of water across the built area of a neighborhood). These parameters can be manually changed according the user's wishes by simply editing the Excel indicator file.		By default the area type under consideration are neighborhoods and the inundation threshold is set at 0.05 m (i.e., a 5-cm thick layer of water across the built area of a neighborhood). These parameters can be manually changed according the user's wishes by simply editing the Excel indicator file.

	This Excel indicator can be downloaded from the [~~https://store.tygron.com/product/water-stress-indicator/ Tygron Index~~]. Read on to find out more about the indicator's calculation method and how to set it up in your project.		This Excel indicator can be downloaded from the Public [[GeoShare]]. Read on to find out more about the indicator's calculation method and how to set it up in your project.

	===Indicator panel===		===Indicator panel===
Line 40:		Line 40:
	{{Editor steps\|title=\|Open the downloaded Excel spreadsheet from the Index.\|On the Formulas tab, in the Define Names group, click the Name Manager.\|Edit the 4 names containing GRID_IS_5 and change the [[ID]] to the correct number (Fig. 2).\|For clarity adjust the corresponding cell formulas accordingly.\|Save your changes and [[Excel#Uploading_and_Downloading\| update the indicator file]] in your project.\| Hover over the [[Calculation_panel\|Calculation panel]] and choose for ''Reset X Queries (slower)'' to update your project.}}		{{Editor steps\|title=\|Open the downloaded Excel spreadsheet from the Index.\|On the Formulas tab, in the Define Names group, click the Name Manager.\|Edit the 4 names containing GRID_IS_5 and change the [[ID]] to the correct number (Fig. 2).\|For clarity adjust the corresponding cell formulas accordingly.\|Save your changes and [[Excel#Uploading_and_Downloading\| update the indicator file]] in your project.\| Hover over the [[Calculation_panel\|Calculation panel]] and choose for ''Reset X Queries (slower)'' to update your project.}}
	{{Indicator nav}}		{{Indicator nav}}
	[[Category:~~Index~~]]		[[Category:Public GeoShare]]

Frank@tygron.nl: /* Edit the Excel file */

2023-01-26T08:58:29Z

Edit the Excel file

← Older revision		Revision as of 08:58, 26 January 2023
Line 39:		Line 39:
	In the Excel file the ID of the [[Rainfall (Overlay)\|Rainfall Overlay]] needs to be changed in the TQL queries in cells G9, H9, J9 and K9.		In the Excel file the ID of the [[Rainfall (Overlay)\|Rainfall Overlay]] needs to be changed in the TQL queries in cells G9, H9, J9 and K9.
	{{Editor steps\|title=\|Open the downloaded Excel spreadsheet from the Index.\|On the Formulas tab, in the Define Names group, click the Name Manager.\|Edit the 4 names containing GRID_IS_5 and change the [[ID]] to the correct number (Fig. 2).\|For clarity adjust the corresponding cell formulas accordingly.\|Save your changes and [[Excel#Uploading_and_Downloading\| update the indicator file]] in your project.\| Hover over the [[Calculation_panel\|Calculation panel]] and choose for ''Reset X Queries (slower)'' to update your project.}}		{{Editor steps\|title=\|Open the downloaded Excel spreadsheet from the Index.\|On the Formulas tab, in the Define Names group, click the Name Manager.\|Edit the 4 names containing GRID_IS_5 and change the [[ID]] to the correct number (Fig. 2).\|For clarity adjust the corresponding cell formulas accordingly.\|Save your changes and [[Excel#Uploading_and_Downloading\| update the indicator file]] in your project.\| Hover over the [[Calculation_panel\|Calculation panel]] and choose for ''Reset X Queries (slower)'' to update your project.}}
			{{Indicator nav}}
	[[Category:Index]]		[[Category:Index]]

Maxim@tygron.com at 15:51, 5 October 2022

2022-10-05T15:51:01Z

← Older revision		Revision as of 15:51, 5 October 2022
Line 1:		Line 1:
	~~{{learned\|what the water stress indicator is\|how the water stress indicator is calculated\| how to adjust your project in order to make the indicator functional.}}~~

	~~==General==~~
	~~===What is the water stress indicator?===~~
	The Water stress indicator yields insight into the flood resilience of built areas (default: neighborhoods) based on the fraction of total built area in that area which inundates beyond the preconfigured threshold inundation level (default: 0.05 m). Despite it being only a rather simplistic measure, it differentiates well between the more resilient (usually greener) areas and those less capable of dealing with excessive inflow of water.		The Water stress indicator yields insight into the flood resilience of built areas (default: neighborhoods) based on the fraction of total built area in that area which inundates beyond the preconfigured threshold inundation level (default: 0.05 m). Despite it being only a rather simplistic measure, it differentiates well between the more resilient (usually greener) areas and those less capable of dealing with excessive inflow of water.

Reijn@tygron.com at 12:34, 18 September 2020

2020-09-18T12:34:11Z

← Older revision		Revision as of 12:34, 18 September 2020
Line 12:		Line 12:
	By default the area type under consideration are neighborhoods and the inundation threshold is set at 0.05 m (i.e., a 5-cm thick layer of water across the built area of a neighborhood). These parameters can be manually changed according the user's wishes by simply editing the Excel indicator file.		By default the area type under consideration are neighborhoods and the inundation threshold is set at 0.05 m (i.e., a 5-cm thick layer of water across the built area of a neighborhood). These parameters can be manually changed according the user's wishes by simply editing the Excel indicator file.

	This Excel indicator can be downloaded from the [https://store.tygron.com/ Tygron Index]. Read on to find out more about the indicator's calculation method and how to set it up in your project.		This Excel indicator can be downloaded from the [https://store.tygron.com/product/water-stress-indicator/ Tygron Index]. Read on to find out more about the indicator's calculation method and how to set it up in your project.

	===Indicator panel===		===Indicator panel===

Rudolf@tygron.nl at 12:02, 9 June 2020

2020-06-09T12:02:09Z

← Older revision		Revision as of 12:02, 9 June 2020
Line 34:		Line 34:

	==Additional configurations==		==Additional configurations==
	In order for the indicator to work properly, a variant of the [[Water Overlay]] needs to be added to the project, and its [[Excel#ID_queries\|ID]] should match the number (#) as it appears in the queries containing WHERE_GRID_IS_# found in the indicator Excel file. Once an overlay is added, e.g., [[Rainfall (Overlay)\|Rainfall Overlay]], its ID can be retrieved through the [[Query Tool]] using the query sequence SELECT_ID_WHERE_OVERLAY_IS_<Rainfall>.		In order for the indicator to work properly, a variant of the [[Water Overlay]] needs to be added to the project, and its [[Excel#ID_queries\|ID]] should match the number (#) as it appears in the queries containing WHERE_GRID_IS_# found in the indicator Excel file. Once an overlay is added, e.g., [[Rainfall (Overlay)\|Rainfall Overlay]], its [[ID]] can be retrieved through the [[Query Tool]] using the query sequence SELECT_ID_WHERE_OVERLAY_IS_<Rainfall>.

	==Add the Overlay==		==Add the Overlay==
Line 40:		Line 40:

	==Edit the Excel file==		==Edit the Excel file==
	[[File:ID_adjustment.PNG\|thumb\|300px\|right\|Figure 2. The ID's in queries can be changed through the Name Manager.]]		[[File:ID_adjustment.PNG\|thumb\|300px\|right\|Figure 2. The [[ID]]'s in queries can be changed through the Name Manager.]]
	In the Excel file the ID of the [[Rainfall (Overlay)\|Rainfall Overlay]] needs to be changed in the TQL queries in cells G9, H9, J9 and K9.		In the Excel file the ID of the [[Rainfall (Overlay)\|Rainfall Overlay]] needs to be changed in the TQL queries in cells G9, H9, J9 and K9.
	{{Editor steps\|title=\|Open the downloaded Excel spreadsheet from the Index.\|On the Formulas tab, in the Define Names group, click the Name Manager.\|Edit the 4 names containing GRID_IS_5 and change the ID to the correct number (Fig. 2).\|For clarity adjust the corresponding cell formulas accordingly.\|Save your changes and [[Excel#Uploading_and_Downloading\| update the indicator file]] in your project.\| Hover over the [[Calculation_panel\|Calculation panel]] and choose for ''Reset X Queries (slower)'' to update your project.}}		{{Editor steps\|title=\|Open the downloaded Excel spreadsheet from the Index.\|On the Formulas tab, in the Define Names group, click the Name Manager.\|Edit the 4 names containing GRID_IS_5 and change the [[ID]] to the correct number (Fig. 2).\|For clarity adjust the corresponding cell formulas accordingly.\|Save your changes and [[Excel#Uploading_and_Downloading\| update the indicator file]] in your project.\| Hover over the [[Calculation_panel\|Calculation panel]] and choose for ''Reset X Queries (slower)'' to update your project.}}

	[[Category:Index]]		[[Category:Index]]

Godelief@tygron.nl: /* Edit the Excel file */

2019-08-16T12:27:38Z

Edit the Excel file

← Older revision		Revision as of 12:27, 16 August 2019
Line 43:		Line 43:
	In the Excel file the ID of the [[Rainfall (Overlay)\|Rainfall Overlay]] needs to be changed in the TQL queries in cells G9, H9, J9 and K9.		In the Excel file the ID of the [[Rainfall (Overlay)\|Rainfall Overlay]] needs to be changed in the TQL queries in cells G9, H9, J9 and K9.
	{{Editor steps\|title=\|Open the downloaded Excel spreadsheet from the Index.\|On the Formulas tab, in the Define Names group, click the Name Manager.\|Edit the 4 names containing GRID_IS_5 and change the ID to the correct number (Fig. 2).\|For clarity adjust the corresponding cell formulas accordingly.\|Save your changes and [[Excel#Uploading_and_Downloading\| update the indicator file]] in your project.\| Hover over the [[Calculation_panel\|Calculation panel]] and choose for ''Reset X Queries (slower)'' to update your project.}}		{{Editor steps\|title=\|Open the downloaded Excel spreadsheet from the Index.\|On the Formulas tab, in the Define Names group, click the Name Manager.\|Edit the 4 names containing GRID_IS_5 and change the ID to the correct number (Fig. 2).\|For clarity adjust the corresponding cell formulas accordingly.\|Save your changes and [[Excel#Uploading_and_Downloading\| update the indicator file]] in your project.\| Hover over the [[Calculation_panel\|Calculation panel]] and choose for ''Reset X Queries (slower)'' to update your project.}}

			[[Category:Index]]

Godelief@tygron.nl: /* General */

2019-08-16T12:27:26Z

General

← Older revision		Revision as of 12:27, 16 August 2019
Line 11:		Line 11:

	By default the area type under consideration are neighborhoods and the inundation threshold is set at 0.05 m (i.e., a 5-cm thick layer of water across the built area of a neighborhood). These parameters can be manually changed according the user's wishes by simply editing the Excel indicator file.		By default the area type under consideration are neighborhoods and the inundation threshold is set at 0.05 m (i.e., a 5-cm thick layer of water across the built area of a neighborhood). These parameters can be manually changed according the user's wishes by simply editing the Excel indicator file.

			This Excel indicator can be downloaded from the [https://store.tygron.com/ Tygron Index]. Read on to find out more about the indicator's calculation method and how to set it up in your project.

	===Indicator panel===		===Indicator panel===

Godelief@tygron.nl: /* Edit the Excel file */

2019-05-09T14:52:46Z

Edit the Excel file

← Older revision		Revision as of 14:52, 9 May 2019
Line 40:		Line 40:
	[[File:ID_adjustment.PNG\|thumb\|300px\|right\|Figure 2. The ID's in queries can be changed through the Name Manager.]]		[[File:ID_adjustment.PNG\|thumb\|300px\|right\|Figure 2. The ID's in queries can be changed through the Name Manager.]]
	In the Excel file the ID of the [[Rainfall (Overlay)\|Rainfall Overlay]] needs to be changed in the TQL queries in cells G9, H9, J9 and K9.		In the Excel file the ID of the [[Rainfall (Overlay)\|Rainfall Overlay]] needs to be changed in the TQL queries in cells G9, H9, J9 and K9.
	{{Editor steps\|title=\|Open the ~~dedicated~~ Excel spreadsheet.\|On the Formulas tab, in the Define Names group, click the Name Manager.\|Edit the 4 names containing GRID_IS_5 and change the ID to the correct number (Fig. 2).\|For clarity adjust the corresponding cell formulas accordingly.\|Save your changes and [[Excel#Uploading_and_Downloading\| update the indicator file]] in your project.\| Hover over the [[Calculation_panel\|Calculation panel]] and choose for ''Reset X Queries (slower)'' to update your project.}}		{{Editor steps\|title=\|Open the downloaded Excel spreadsheet from the Index.\|On the Formulas tab, in the Define Names group, click the Name Manager.\|Edit the 4 names containing GRID_IS_5 and change the ID to the correct number (Fig. 2).\|For clarity adjust the corresponding cell formulas accordingly.\|Save your changes and [[Excel#Uploading_and_Downloading\| update the indicator file]] in your project.\| Hover over the [[Calculation_panel\|Calculation panel]] and choose for ''Reset X Queries (slower)'' to update your project.}}

Jorn@tygron.com: File:ID adjustment.PNG

2019-05-09T14:32:19Z

File:ID adjustment.PNG

← Older revision		Revision as of 14:32, 9 May 2019
Line 38:		Line 38:

	==Edit the Excel file==		==Edit the Excel file==
			[[File:ID_adjustment.PNG\|thumb\|300px\|right\|Figure 2. The ID's in queries can be changed through the Name Manager.]]
	In the Excel file the ID of the [[Rainfall (Overlay)\|Rainfall Overlay]] needs to be changed in the TQL queries in cells G9, H9, J9 and K9.		In the Excel file the ID of the [[Rainfall (Overlay)\|Rainfall Overlay]] needs to be changed in the TQL queries in cells G9, H9, J9 and K9.
	{{Editor steps\|title=\|Open the dedicated Excel spreadsheet.\|On the Formulas tab, in the Define Names group, click the Name Manager.\|Edit the 4 names containing GRID_IS_5 and change the ID to the correct number (Fig. 2).\|For clarity adjust the corresponding cell formulas accordingly.\|Save your changes and [[Excel#Uploading_and_Downloading\| update the indicator file]] in your project.\| Hover over the [[Calculation_panel\|Calculation panel]] and choose for ''Reset X Queries (slower)'' to update your project.}}		{{Editor steps\|title=\|Open the dedicated Excel spreadsheet.\|On the Formulas tab, in the Define Names group, click the Name Manager.\|Edit the 4 names containing GRID_IS_5 and change the ID to the correct number (Fig. 2).\|For clarity adjust the corresponding cell formulas accordingly.\|Save your changes and [[Excel#Uploading_and_Downloading\| update the indicator file]] in your project.\| Hover over the [[Calculation_panel\|Calculation panel]] and choose for ''Reset X Queries (slower)'' to update your project.}}

← Older revision		Revision as of 14:52, 9 May 2019
Line 40:		Line 40:
	[[File:ID_adjustment.PNG\|thumb\|300px\|right\|Figure 2. The ID's in queries can be changed through the Name Manager.]]		[[File:ID_adjustment.PNG\|thumb\|300px\|right\|Figure 2. The ID's in queries can be changed through the Name Manager.]]
	In the Excel file the ID of the [[Rainfall (Overlay)\|Rainfall Overlay]] needs to be changed in the TQL queries in cells G9, H9, J9 and K9.		In the Excel file the ID of the [[Rainfall (Overlay)\|Rainfall Overlay]] needs to be changed in the TQL queries in cells G9, H9, J9 and K9.
	{{Editor steps\|title=\|Open the ~~dedicated~~ Excel spreadsheet.\|On the Formulas tab, in the Define Names group, click the Name Manager.\|Edit the 4 names containing GRID_IS_5 and change the ID to the correct number (Fig. 2).\|For clarity adjust the corresponding cell formulas accordingly.\|Save your changes and [[Excel#Uploading_and_Downloading\| update the indicator file]] in your project.\| Hover over the [[Calculation_panel\|Calculation panel]] and choose for ''Reset X Queries (slower)'' to update your project.}}		{{Editor steps\|title=\|Open the downloaded Excel spreadsheet from the Index.\|On the Formulas tab, in the Define Names group, click the Name Manager.\|Edit the 4 names containing GRID_IS_5 and change the ID to the correct number (Fig. 2).\|For clarity adjust the corresponding cell formulas accordingly.\|Save your changes and [[Excel#Uploading_and_Downloading\| update the indicator file]] in your project.\| Hover over the [[Calculation_panel\|Calculation panel]] and choose for ''Reset X Queries (slower)'' to update your project.}}