How to configure a Query for an Excel Indicator: Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
[[File:QueryErrorMessage-Q3-2015.jpg|thumb|300px|right|Query error message]]
: 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.
The [[Query Tool]] can be used to check the validity of queries that were created outside the {{software}}. For example, consider the following query:
:<code>SELECT_FLOORSIZE_WHERE_CATEGORY_IS_OFFICES_AND_STAKEHOLDER_IS_MUNICIPALITY_AND_TERRAINTYPE_IS_SAFE_ZONE</code>


This query seems to look good on paper, the string makes sense: Give the floor size of all municipal offices that are located in the safe zone. However, when uploading the query in a spread sheet for an Excel Indicator, the query will result in an error. If the user first attempts to recreate the query in the {{software}} Query Tool, he will notice that the clause <code>STAKEHOLDER_IS_MUNICIPALITY</code> is incorrect. The {{software}} assigns fixed numbers to stakeholders, in this case a '0'. The correct clause should read <code>STAKEHOLDER_IS_0</code>, and the full Query should be
: Looking at the above example, it is easy now to copy and paste the just created query <code>SELECT_FLOORSIZE_WHERE_TERAINTYPE_IS_SAFE_ZONE</code> into an appropriate [[Excel (Indicator)#Naming Cells|name field]] on an Excel Indicator spreadsheet.
:<code>SELECT_FLOORSIZE_WHERE_CATEGORY_IS_OFFICES_AND_STAKEHOLDER_IS_0_AND_TERRAINTYPE_IS_SAFE_ZONE</code>.
 
{{Editor steps|title=configure a query for an Excel Indicator spreadsheet|Load or create a project with an ArcGIS safe zone|Select Editor &#8594; Tools &#8594; Query Tool|Select <code>FLOORSIZE</code> as Result Parameter|Add <code>TERRAINTYPE</code> IS <code>SAFE_ZONE</code> as clause|Copy the created Query text string, and paste this in the appropriate name field of the Excel Indicator spreadsheet}}
<br>
<br>
{{Editor steps|title=use the Query Tool to test queries from an Excel Indicator spreadsheet|Create a query outside of the {{software}} (e.g. on a spreadsheet)|Load or create a project with the project area in the Editor|Select Editor &#8594; Tools &#8594; Query Tool|Recreate the query from the spreadsheet in the {{software}} Query Tool|Observe if the Query from the tool matches the query created outside the {{software}}|Observe if the output result matches expectations}}
: [[File:QueryToolConigurefQuery-Q3-2015.jpg|thumb|left|Copy a query for pasting in an Excel Indicator spreadsheet]]
<br clear=all>
[[Category:TQL]][[Category:How-to's]]
[[Category:TQL]][[Category:How-to's]]

Revision as of 13:40, 21 October 2022

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.
Looking at the above example, it is easy now to copy and paste the just created query SELECT_FLOORSIZE_WHERE_TERAINTYPE_IS_SAFE_ZONE into an appropriate name field on an Excel Indicator spreadsheet.
How to configure a query for an Excel Indicator spreadsheet:
  1. Load or create a project with an ArcGIS safe zone
  2. Select Editor → Tools → Query Tool
  3. Select FLOORSIZE as Result Parameter
  4. Add TERRAINTYPE IS SAFE_ZONE as clause
  5. Copy the created Query text string, and paste this in the appropriate name field of the Excel Indicator spreadsheet


Copy a query for pasting in an Excel Indicator spreadsheet


Retrieved from "https://support.tygron.com/w/index.php?title=How_to_configure_a_Query_for_an_Excel_Indicator&oldid=48185"