Query Tool: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (2 intermediate revisions by 2 users not shown) | |||
| 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: [[ | 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}}== | ||
[[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. | 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. | ||
:* | :*Users can also recreate queries from Excel Indicator files to verify they retrieve data from the project map. | ||
{{article end | {{article end | ||
| Line 26: | Line 26: | ||
* [[TQL]] | * [[TQL]] | ||
* [[Select (TQL)]], [[Update (TQL)]] and [[Clause (TQL)]] | * [[Select (TQL)]], [[Update (TQL)]] and [[Clause (TQL)]] | ||
* [[ | * [[Indicator]]s, [[Panel]]s and [[Global]]s | ||
}} | }} | ||
{{Editor_current_situation_nav}} | {{Editor_current_situation_nav}} | ||
[[Category:TQL]] | [[Category:TQL]] | ||
Latest revision as of 11:34, 13 July 2026
The Query Tool is a support tool in the Tygron Platform 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: Indicator
How does the Query Tool relate to the Tygron Platform
A project in the Tygron Platform 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 Tygron Platform and calculate results in an Excel Indicator.
SELECTResult ParameterWHEREClauseANDClauseANDClauseAND... etc.
The Query Tool provides an interface in the Editor that allows for quick creation and verification of such TQL Queries.
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 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.
- Users can also recreate queries from Excel Indicator files to verify they retrieve data from the project map.
How-to's
- How to use the Query Tool
- 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 verify available data in a Project Map
See also
- TQL
- Select (TQL), Update (TQL) and Clause (TQL)
- Indicators, Panels and Globals
Current Situation
- Buildings • Terrains • Administrative • Areas • Networks • Overlays • Indicators • Panels • Globals • Queries • Geo Import
- Buildings
- Function • Function Override • Section • Category • Custom Geometry • Category Value • Function Value • Function Values Table • List of Functions
- Traffic
- Unit Type • Unit Data • Unit Data Override
- Terrain
- Height sector • Elevation model • Elevation GeoTIFF • Elevation Grid Overlay • Ground Price • Terrain Type • Terrain Type Override • List of Terrain Types
- Administrative
- Neighborhood • Zone • Permission Popup • Plot • Zip Code
- Queries
- Net Cluster • Net Function • Net Line • Net Load • Net Node • Net Setting
- Editor