Query Tool - Revision history

Maxim@tygron.com at 11:34, 13 July 2026

2026-07-13T11:34:31Z

← Older revision		Revision as of 11:34, 13 July 2026
Line 26:		Line 26:
	* [[TQL]]		* [[TQL]]
	* [[Select (TQL)]], [[Update (TQL)]] and [[Clause (TQL)]]		* [[Select (TQL)]], [[Update (TQL)]] and [[Clause (TQL)]]
	* [[~~Excel indicator~~]]s, [[Panel]]s and [[Global]]s		* [[Indicator]]s, [[Panel]]s and [[Global]]s
	}}		}}

	{{Editor_current_situation_nav}}		{{Editor_current_situation_nav}}
	[[Category:TQL]]		[[Category:TQL]]

Maxim@tygron.com at 11:34, 13 July 2026

2026-07-13T11:34:20Z

← Older revision		Revision as of 11:34, 13 July 2026
Line 1:		Line 1:
	The Query Tool is a support tool in the {{software}} that aids the user by constructing data requests in the [[TQL\|Tygron Query Language (TQL)]] and displaying the query output. By using this tool, the user can quickly verify if the data needed can be extracted from the project data with the available query elements. Also the tool allows for verification of the validity of the retrieved data. All this can be achieved without creating and uploading a dedicated Query Spread Sheet. See also: [[~~Excel (~~Indicator)]]		The Query Tool is a support tool in the {{software}} that aids the user by constructing data requests in the [[TQL\|Tygron Query Language (TQL)]] and displaying the query output. By using this tool, the user can quickly verify if the data needed can be extracted from the project data with the available query elements. Also the tool allows for verification of the validity of the retrieved data. All this can be achieved without creating and uploading a dedicated Query Spread Sheet. See also: [[Indicator]]

	==How does the Query Tool relate to the {{software}}==		==How does the Query Tool relate to the {{software}}==

Frank@tygron.nl at 12:37, 8 July 2026

2026-07-08T12:37:07Z

← Older revision		Revision as of 12:37, 8 July 2026
Line 4:		Line 4:
	[[File:QueryToolPanel-Q3-2015.jpg\|right\|thumb\|400px\|Query Tool Panel]]		[[File:QueryToolPanel-Q3-2015.jpg\|right\|thumb\|400px\|Query Tool Panel]]

	A project in the {{software}} can use multiple geospatial data sources. To retrieve ~~all sorts of~~ data that ~~are present, but for which no dedicated data~~ structure ~~(predefined indicators) already exists, the [[TQL]] (Tygron Query Language) has been developed~~. ~~By using queries with~~ the below ~~structure~~, ~~dedicated~~ data requests ~~can be sent~~ to the {{software}}~~, from which the~~ results ~~can then be calculated~~ in~~, for instance,~~ an Excel Indicator.		A project in the {{software}} can use multiple geospatial data sources. TQL was developed to retrieve data that lacks a predefined indicator structure. Using the structure below, users can send data requests to the {{software}} and calculate results in an Excel Indicator.

	: <code>SELECT</code> [[TQL#Queries\|Result Parameter]] <code>WHERE</code> [[Clause (TQL)\|Clause]] <code>AND</code> [[Clause (TQL)\|Clause]] <code>AND</code> [[Clause (TQL)\|Clause]] <code>AND</code>... etc.		: <code>SELECT</code> [[TQL#Queries\|Result Parameter]] <code>WHERE</code> [[Clause (TQL)\|Clause]] <code>AND</code> [[Clause (TQL)\|Clause]] <code>AND</code> [[Clause (TQL)\|Clause]] <code>AND</code>... etc.
Line 15:		Line 15:
	:*The Query Tool can be used to verify if data is available for queries in the [[project map]].		:*The Query Tool can be used to verify if data is available for queries in the [[project map]].
	:*The tool can also be used to create queries, which can be copied and pasted in an Excel file to be uploaded as an Excel Indicator.		:*The tool can also be used to create queries, which can be copied and pasted in an Excel file to be uploaded as an Excel Indicator.
	:*~~The reverse is~~ also ~~possible, recreating a query in the tool~~ from an Excel Indicator ~~file,~~ to verify ~~if the query actually grabs~~ data from the project map.		:*Users can also recreate queries from Excel Indicator files to verify they retrieve data from the project map.

	{{article end		{{article end

Maxim@tygron.com at 16:00, 9 June 2026

2026-06-09T16:00:21Z

← Older revision		Revision as of 16:00, 9 June 2026
Line 13:		Line 13:
	==Uses of the Query Tool==		==Uses of the Query Tool==
	There are a couple of main uses for the Tygron Query Tool:		There are a couple of main uses for the Tygron Query Tool:
	:*The Query Tool can be used to verify if data is available for queries in the project ~~area~~.		:*The Query Tool can be used to verify if data is available for queries in the [[project map]].
	:*The tool can also be used to create queries, which can be copied and pasted in an Excel file to be uploaded as an Excel Indicator.		:*The tool can also be used to create queries, which can be copied and pasted in an Excel file to be uploaded as an Excel Indicator.
	:*The reverse is also possible, recreating a query in the tool from an Excel Indicator file, to verify if the query actually grabs data from the project ~~area~~.		:*The reverse is also possible, recreating a query in the tool from an Excel Indicator file, to verify if the query actually grabs data from the project map.

	{{article end		{{article end
Line 22:		Line 22:
	* [[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]]
	* [[How to configure a Query for an Excel Indicator]]		* [[How to configure a Query for an Excel Indicator]]
	* [[How to verify available data in a Project ~~Area~~]]		* [[How to verify available data in a Project Map]]
	\|seealso=		\|seealso=
	* [[TQL]]		* [[TQL]]

Maxim@tygron.com at 15:46, 4 March 2026

2026-03-04T15:46:27Z

← Older revision		Revision as of 15:46, 4 March 2026
Line 4:		Line 4:
	[[File:QueryToolPanel-Q3-2015.jpg\|right\|thumb\|400px\|Query Tool Panel]]		[[File:QueryToolPanel-Q3-2015.jpg\|right\|thumb\|400px\|Query Tool Panel]]

	A project in the {{software}} can use multiple geospatial data sources. To retrieve all sorts of data that are present, but for which no dedicated data structure (predefined indicators) already exists, the TQL (Tygron Query Language) has been developed. By using queries with the below structure, dedicated data requests can be sent to the {{software}}, from which the results can then be calculated in, for instance, an Excel Indicator.		A project in the {{software}} can use multiple geospatial data sources. To retrieve all sorts of data that are present, but for which no dedicated data structure (predefined indicators) already exists, the [[TQL]] (Tygron Query Language) has been developed. By using queries with the below structure, dedicated data requests can be sent to the {{software}}, from which the results can then be calculated in, for instance, an Excel Indicator.

	: <code>SELECT</code> [[TQL#Queries\|Result Parameter]] <code>WHERE</code> [[Clause (TQL)\|Clause]] <code>AND</code> [[Clause (TQL)\|Clause]] <code>AND</code> [[Clause (TQL)\|Clause]] <code>AND</code>... etc.		: <code>SELECT</code> [[TQL#Queries\|Result Parameter]] <code>WHERE</code> [[Clause (TQL)\|Clause]] <code>AND</code> [[Clause (TQL)\|Clause]] <code>AND</code> [[Clause (TQL)\|Clause]] <code>AND</code>... etc.

Maxim@tygron.com: /* How does the Query Tool relate to the {{software}} */

2026-03-04T15:40:50Z

How does the Query Tool relate to the {{software}}

← Older revision		Revision as of 15:40, 4 March 2026
Line 4:		Line 4:
	[[File:QueryToolPanel-Q3-2015.jpg\|right\|thumb\|400px\|Query Tool Panel]]		[[File:QueryToolPanel-Q3-2015.jpg\|right\|thumb\|400px\|Query Tool Panel]]

	A project in the {{software}} can use multiple geospatial data sources. In the Netherlands the {{software}} uses for instance BAG and Top10NL data, while in New York the {{software}} uses the PLUTO data set from the NYC Municipality. Both regions use OpenStreetMaps for the placement of roads etc.		A project in the {{software}} can use multiple geospatial data sources. To retrieve all sorts of data that are present, but for which no dedicated data structure (predefined indicators) already exists, the TQL (Tygron Query Language) has been developed. By using queries with the below structure, dedicated data requests can be sent to the {{software}}, from which the results can then be calculated in, for instance, an Excel Indicator.

	To retrieve all sorts of data that are present, but for which no dedicated data structure (predefined indicators) already exists, the TQL (Tygron Query Language) has been developed. By using queries with the below structure, dedicated data requests can be sent to the {{software}}, from which the results can then be calculated in, for instance, an Excel Indicator.

	: <code>SELECT</code> [[TQL#Queries\|Result Parameter]] <code>WHERE</code> [[Clause (TQL)\|Clause]] <code>AND</code> [[Clause (TQL)\|Clause]] <code>AND</code> [[Clause (TQL)\|Clause]] <code>AND</code>... etc.		: <code>SELECT</code> [[TQL#Queries\|Result Parameter]] <code>WHERE</code> [[Clause (TQL)\|Clause]] <code>AND</code> [[Clause (TQL)\|Clause]] <code>AND</code> [[Clause (TQL)\|Clause]] <code>AND</code>... etc.

Frank@tygron.nl at 16:15, 1 February 2024

2024-02-01T16:15:37Z

← Older revision		Revision as of 16:15, 1 February 2024
Line 1:		Line 1:
	~~[[File:Tql_webinar.png\|link=https://www.tygron.com/nl/2019/05/22/tql-en-upgrades/]]~~

	~~==What is the Query Tool?==~~
	The Query Tool is a support tool in the {{software}} that aids the user by constructing data requests in the [[TQL\|Tygron Query Language (TQL)]] and displaying the query output. By using this tool, the user can quickly verify if the data needed can be extracted from the project data with the available query elements. Also the tool allows for verification of the validity of the retrieved data. All this can be achieved without creating and uploading a dedicated Query Spread Sheet. See also: [[Excel (Indicator)]]		The Query Tool is a support tool in the {{software}} that aids the user by constructing data requests in the [[TQL\|Tygron Query Language (TQL)]] and displaying the query output. By using this tool, the user can quickly verify if the data needed can be extracted from the project data with the available query elements. Also the tool allows for verification of the validity of the retrieved data. All this can be achieved without creating and uploading a dedicated Query Spread Sheet. See also: [[Excel (Indicator)]]

Rudolf@tygron.nl at 06:59, 22 December 2023

2023-12-22T06:59:01Z

← Older revision		Revision as of 06:59, 22 December 2023
Line 11:		Line 11:
	To retrieve all sorts of data that are present, but for which no dedicated data structure (predefined indicators) already exists, the TQL (Tygron Query Language) has been developed. By using queries with the below structure, dedicated data requests can be sent to the {{software}}, from which the results can then be calculated in, for instance, an Excel Indicator.		To retrieve all sorts of data that are present, but for which no dedicated data structure (predefined indicators) already exists, the TQL (Tygron Query Language) has been developed. By using queries with the below structure, dedicated data requests can be sent to the {{software}}, from which the results can then be calculated in, for instance, an Excel Indicator.

	: <code>SELECT</code> [[TQL#Queries\|Result Parameter]] <code>WHERE</code> [[TQL~~#Clauses~~\|Clause]] <code>AND</code> [[TQL~~#Clauses~~\|Clause]] <code>AND</code> [[TQL~~#Clauses~~\|Clause]] <code>AND</code>... etc.		: <code>SELECT</code> [[TQL#Queries\|Result Parameter]] <code>WHERE</code> [[Clause (TQL)\|Clause]] <code>AND</code> [[Clause (TQL)\|Clause]] <code>AND</code> [[Clause (TQL)\|Clause]] <code>AND</code>... etc.

	The Query Tool provides an interface in the Editor that allows for quick creation and verification of such TQL Queries.		The Query Tool provides an interface in the Editor that allows for quick creation and verification of such TQL Queries.

Rudolf@tygron.nl at 06:58, 22 December 2023

2023-12-22T06:58:08Z

← Older revision		Revision as of 06:58, 22 December 2023
Line 30:		Line 30:
	\|seealso=		\|seealso=
	* [[TQL]]		* [[TQL]]
	* [[Select (TQL)]], [[Update (TQL)]] and [[Clause (TQL)]]s		* [[Select (TQL)]], [[Update (TQL)]] and [[Clause (TQL)]]
	* [[Excel indicator]]s, [[Panel]]s and [[Global]]s		* [[Excel indicator]]s, [[Panel]]s and [[Global]]s
	}}		}}

	{{~~Template:~~Editor_current_situation_nav}}		{{Editor_current_situation_nav}}
	[[Category:TQL]]		[[Category:TQL]]

Rudolf@tygron.nl at 06:57, 22 December 2023

2023-12-22T06:57:52Z

← Older revision		Revision as of 06:57, 22 December 2023
Line 30:		Line 30:
	\|seealso=		\|seealso=
	* [[TQL]]		* [[TQL]]
	* [[Select (TQL)]], [[Update (TQL)]] and [[Clause ~~parameter~~]]s		* [[Select (TQL)]], [[Update (TQL)]] and [[Clause (TQL)]]s
	* [[Excel indicator]]s, [[Panel]]s and [[Global]]s		* [[Excel indicator]]s, [[Panel]]s and [[Global]]s
	}}		}}