The Query button will allow you to query
for both string and numeric fields on the active theme within the map.
- To create a query on a specific feature
you will need the make a theme active. To make a theme active you must go
to the right side of the web page under Layers, move the mouse cursor over the circle
next to the layer you want to query and select it. You can toggle between
layer and legend list by simply selecting the
layer/legend list button on the toolbar. - Next, select the query
button on the toolbar to begin the query
process. To build a query, use the query builder dialogue interface
located near the bottom of the web page called the text display area.
The
query builder dialog allows you to build the query
expression.
- Select an item from "Field" (AVAILABLE
ENERGY (GJ) ), select the appropriate
"Operator" (i.e. =, <, >) and then type in a "Value"
( 314.99509 ) or click on "Get Samples" for a scrolling listing
of possible values. The query is case sensitive so you will have to know
exactly how it’s entered in the database to get the query to execute. Once
you are satisfied with the query expression click on "Add to Query
String" and then click on "Execute". Query’s can also be
strung together by using "And", "Or", "Not",
"(",
"&", or ")" in the expression
- To search for features according to a text
string value, use the
Find Builder.
- A data table associated with the selected
features will appear in the text display area. At this time you can select
a specific record by moving the mouse cursor over the number which is
located under the field/column called Rec. You know you are in the
correct field/column because you will see the cursor turn into a pointing
hand. When the record is selected the web page will zoom in and highlight
the corresponding selection in red.
- You can drag and drop the results of the
query into any text processing application, such as Microsoft Word or
Excel. With the left mouse button depressed, drag the cursor across the
columns to highlight the column titles as well as the records. When the
records you want are selected, simultaneously press <Ctrl + C> to
copy, then open Microsoft Word or Excel and then simultaneously press
<Ctrl + V> to paste. The result will be a text or table you may edit
and sort.