Tuesday, July 21, 2015

GTViewer Server Box - Part 2





The final version of the GTViewer Server Box is now finished!  Since the prototype, we have gone through a couple of case designs and power configurations.  The intermediate case provided a power/reset button, but it did not seem like it would be survive actual use.  This off-the-shelf case was really meant to sit on a desk and not go to the field.   The final case is custom laser-cut acrylic that both looks nice and is much more durable.  It also houses an integrated power controller that provides true headless operation (no keyboard, monitor, or mouse required).  The evolution of the hardware is shown below:




All of the features provided by the prototype are still available in the final design.  The box runs a special version of the GTViewer Data Server and GTShare, and it does not need a network connection of any kind.  It provides WiFi access to the GTViewer datasets contained on its removable USB drive allowing applications like GTViewer, GTViewer for iOS, and GTViewer for Android to download or update their GTViewer datasets without accessing the internet or corporate intranet (they just need to be in WiFi range of the box).   The GTViewer Server Box is shown below powered by an external cell phone battery pack:







Thursday, July 02, 2015

Advanced Thematic Queries in GTViewer

Thematic Queries (sometimes referred to as Highlight Queries) are special GTViewer queries that will highlight all features with the same attribute values instead of locating on a specific feature.   For example, you could highlight all Primary Conductor with a specified Circuit Id and Phase.
When you create a Thematic Query, you tell it which attributes will be used to create the themes (groups of features to highlight) and it will generate a unique list of all value combinations and associate their features.  For the Highlight by Circuit Id and Phase example, the query will specify both Circuit Id and Phase as prompt values.   You can enter one or both prompts to narrow down the features you wish to highlight. 

If you only enter a Circuit ID, you will get back a list of all Circuit Id/Phase pairs that contain the specified Circuit Id.   

You can select any record in the search results to highlight all features with those attribute values.


If you select one of the records, it will highlight all features that have that Circuit Id and Phase:



I was recently asked if you could also highlight all of the Phases for a Circuit Id without having to create and run a separate that had only Circuit Id as a prompt.  It turns out that you can do this, but it may not be readily obvious how to create such a query.

GTQuery has long supported the appending of Queries to create more powerful searches. For example, if you wanted to search for a variety of features that came from different tables, you create a query for each individual feature while appending them to each other as you go.  GTQuery supports the “–a” option to append the results of the query you create to a specified .qry file.  The only requirement is that the queries be of the same type and have the same number of prompts.

How does this help get a highlight All Phases into my results?   GTQuery also supports a Constant prompt value feature, so I can create another query that does a Highlight By Circuit Id and provide a second prompt for Phase with a constant value of “[All Phases]”.  Constants values do not affect the records put into the query, so it will behave as though you are creating a highlight query with just one prompt.  When the Highlight by Circuit Id and Phase Query is created, the All Phases version is appended, and you will get a result like the following when you run the query and search for a specific circuit (CCT1A in this example):



I just given a brief overview here so that you can see what is possible.  If you need more detail on setting a Thematic Query like I have described, email support for more info.