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" (ST_NAME), select the appropriate
"Operator" (i.e. =, <, >) and then type in a "Value" (GALLOWAY)
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 its 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". Querys 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.
An example of a query is as follows: Making the active layer Mesquite Streets and then
enter the query expression, ST_NAME = GALLOWAY And LENGTH < 145.
- 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.