Query

Home / Tool Buttons /

This tool allows the user to search for a specific value of an attribute from a specified Active Layer.

1. Left Click on this tool.

2. Below the map will be the necessary tools to build a Query statement. The first drop down allows the user to choose which Field to search. Choose from the available attributes of the active layer.  Next indicate which operator to use.  The = will select only the value which matches your criteria exactly. >,<,>=,<=, and LIKE are other options to get ranges of values from your search. 

3. Select the field and the operator.  Click on the “Add to Query String” This will bring down your selections to build the query string.  If you want to see how the values of the field you selected might look click on “Get Samples” This will generate some of the values for your field so that you may see the syntax and case of the letters of your values. This is important because if you do not match the case or the format of a value then the query will come back negative when there actually may be a record you are looking for (See Find option for more general search) Type the value searching for down in the Add to Query String Box.  If the field is a text value then place your criteria between quotation marks.

4. If you want to search for multiple values within one record then you will use the and, or, not, (,and ) buttons. To use these continue to write SQL query statements.  If you are unfamiliar with this style please consult a help page for SQL database query structure or contact the Archaeology in Annapolis GIS Webmaster for help.

5. Once your Query statement is completed click on Execute.

6. All Values that meet your criteria will show up in a table view below the map. A blue underlined number will show up to the left of a record.  If you click on this blue number the map will zoom to that selected object and highlight it.

Example: ADDRESS= “89 MAIN STREET” for the Tax Parcel Layer.