Query Tool: Difference between revisions
Line 41: | Line 41: | ||
===Verifying available data in a project Area=== | ===Verifying available data in a project Area=== | ||
When a new project has been generated, the Query Tool can quickly check if the area contains data that can be retrieved by a Query. Doing so enables the user to quickly check the available data, without having to create a separate Excel Indicator spreadsheet with queries. | : When a new project has been generated, the Query Tool can quickly check if the area contains data that can be retrieved by a Query. Doing so enables the user to quickly check the available data, without having to create a separate Excel Indicator spreadsheet with queries. | ||
For instance, when a project area has been created with a safe zone terrain, by importing a relevant feature service from ArcGIS, the query tool can quickly verify if the safe zone data can be retrieved with a Query. | : For instance, when a project area has been created with a safe zone terrain, by importing a relevant feature service from ArcGIS, the query tool can quickly verify if the safe zone data can be retrieved with a Query. | ||
===Configuring a Query for an Excel Indicator=== | ===Configuring a Query for an Excel Indicator=== | ||
When setting up an Excel Indicator, the Query Tool can be used to configure Queries, after which the full Query text string can be copied over to the Excel Indicator file. | : When setting up an Excel Indicator, the Query Tool can be used to configure Queries, after which the full Query text string can be copied over to the Excel Indicator file. | ||
===Using the Query Tool to test queries from an Excel Indicator spreadsheet=== | ===Using the Query Tool to test queries from an Excel Indicator spreadsheet=== |
Revision as of 09:37, 14 August 2015
What is the Query Tool?
The Query Tool is a support tool in the Tygron Engine that aids the user by constructing data requests in the 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)
How does the Query Tool relate to the Tygron Engine
A project in the Tygron Engine can use multiple geospatial data sources. In the Netherlands the Tygron Engine uses for instance BAG and Top10NL data, while in New York the Tygron Engine uses the PLUTO data set from the NYC Municipality. Both regions use OpenStreetMaps for the placement of roads etc.
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 Tygron Engine, from which the results can then be calculated in, for instance, an Excel Indicator.
SELECT
Result ParameterWHERE
ClauseAND
ClauseAND
ClauseAND
... etc.
The Query Tool provides an interface in the Editor that allows for quick creation and verification of such TQL Queries.
How to use the Query Tool in the Tygron Engine
The Query Tool can be found in the Tygron Engine Editor, under the ribbon header Tools, by selecting the Query Tool Button. The Query Tool consists of three areas; the construction drop down menus, the actual query as a result from the construction selections and it's result. It is theoretically possible to add an unlimited number of clauses. This being said, only a limited amount (of combinations) of options is available to do so.
- Select Editor → Tools → Query Tool
- Select the desired Result Parameter
- Add clauses, as many as needed
- Select the clause properties from the drop down menus
- Notice the full query string appears in the Query field
- Notice the actual Query result on the bottom of the panel
Uses of the 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 tool can also be used to create queries, which can be copied over to an Excel file to be uploaded as an Excel Indicator. The other way round is also possible, recreating a query from an Excel Indicator file, to verify if the query actually grabs data from the project area.
If you encounter any new use not mentioned here, please let us know! We are very much interested in your new insights in the Tygron Engine!
Verifying available data in a project Area
- When a new project has been generated, the Query Tool can quickly check if the area contains data that can be retrieved by a Query. Doing so enables the user to quickly check the available data, without having to create a separate Excel Indicator spreadsheet with queries.
- For instance, when a project area has been created with a safe zone terrain, by importing a relevant feature service from ArcGIS, the query tool can quickly verify if the safe zone data can be retrieved with a Query.
Configuring a Query for an Excel Indicator
- When setting up an Excel Indicator, the Query Tool can be used to configure Queries, after which the full Query text string can be copied over to the Excel Indicator file.