Query Tool: Difference between revisions
Line 9: | Line 9: | ||
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. | 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 already exists, the TQL (Tygron Query Language) has been developed. By using queries with the structure <code>SELECT</code> [[Result Parameter]] <code>WHERE</code> [[TQL#Clauses|Clause]] <code>AND</code> [[TQL#Clauses|Clause]] <code>AND</code> [[TQL#Clauses|Clause]] <code>AND</code>... etc. | To retrieve all sorts of data that are present, but for which no dedicated data structure already exists, the TQL (Tygron Query Language) has been developed. By using queries with the structure <code>SELECT</code> [[TQL#Result Parameter|Result Parameter]] <code>WHERE</code> [[TQL#Clauses|Clause]] <code>AND</code> [[TQL#Clauses|Clause]] <code>AND</code> [[TQL#Clauses|Clause]] <code>AND</code>... etc. | ||
The Query Tool provides an interface in the Editor that allows for quick creation and verification of TQL Queries. | The Query Tool provides an interface in the Editor that allows for quick creation and verification of TQL Queries. |
Revision as of 12:24, 13 August 2015
What is the Query Tool?
The Query Tool is a support tool in the Tygron 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 he needs 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 already exists, the TQL (Tygron Query Language) has been developed. By using queries with the structure SELECT
Result Parameter WHERE
Clause AND
Clause AND
Clause AND
... etc.
The Query Tool provides an interface in the Editor that allows for quick creation and verification of TQL Queries.