| The
"Select" tool expands on the capability of the "Parcel
Info" and "Search by County Taxlot" tools and also
offers advanced buffering and querying features.
Available
to staff & subscription users only.
Jump to: Selecting a Layer | Buffer
Tool | Query Tool
Selecting a Layer
Using
the "Select" functions you can interactively select tax
lots (from the parcels layer) and export attribute information to
a Microsoft Excel spreadsheet.
To
select the Parcels layer follow the same instructions as the Identify
tool (see Identify) and click on the drop
down arrow to the right of where Selection Layer:
appears (1). Scroll through the list and select Parcels.
Next make sure the Add option is selected (2).
With the Parcels layer selected click on the parcel of interest
on the map. The parcel will now be highlighted with a blue outline
(3).

To
export the parcel information to excel click the "Export Excel"
button (1) and a File Download window opens. Select
Save to save the spreadsheet to your computer (2).

Highlighted
taxlot's can be removed by selecting "Remove" (1) and then clicking
the "Clear" button (2). A message will appear on your
screen informing you that the currently selected layer will be removed
if you press OK (3).

Additionally, other features selected, such as Lakes
or City Limits can be highlighted. It is important
to note that features from only one layer can be highlighted at
a time. For instance, a Lake or several Lakes
can be highlighted; however, a Lake and the City
Limits cannot be highlighted at the same time.
The
export to Excel feature works on any selectable
layer, but is designed primarily for use with the Parcels
layer.

Using the Buffer Tool
The
"Buffer" tool is used to create an area of specified distance
around a single map item. To use the Buffer
tool press the Select tool button in the Advanced
Tools toolbar. The buffer tool is limited
to a search radius of 5280ft (1 mile) and will
only export a maximum of 250 records to excel.
If
you try and enter a value greater than 5280ft an error message will
appear asking you to enter a smaller
value.
If
the buffer distance you enter is greater than 1000ft a second warning
message will appear indicating that it might take a few minutes
to process the request. At this point you can either OK or Cancel
the buffer.
Example:
Choose
a layer, such as Parcels (1) from the Selection Layer drop-down
menu. Using your mouse click on a parcel in the map window (2) and
then press the Buffer button (3).

With
the parcel selected enter a buffer distance (4) i.e. 100
(feet) and press the Mapit button (5). With the
buffer polygon now drawn on the screen (6) and the affected "buffered"
parcels highlighted you can perform a number of options:

A.
Clear the existing buffer and start over. To do this press the Clear
button and then press the Select tool button.
B.
Export the currently buffered features to Excel
(instructions can be found at the top of this section).
C.
Use the currently buffered features as part of a Query
(see instructions below). To do this press the Select
button again, followed by the Query button. This
will launch the query builder pop-up window.

Using the Query Tool
Query
tools provide the means to logically sort through data and obtain
lists of records that match specified search criteria. The "Query"
tool can be used with multiple features selected
in the map window (i.e. 5 parcels). In the previous section it was
also noted that a buffered selection of map features can be used
as an entry point for further analysis using the query tool. The
query tool will only export a maximum of 250 records
to excel.
Queries
are created using Select Fields (1), Select Operators (2), Search
Criteria (3) and Advanced Query Operators (4). The query statement
is listed in the display window (5).
Queries
are built by choosing a Select Field and Select
Operator then adding a Search Criteria
i.e. '5' or 'Smith' into the Enter Search Criteria box.
Next, press the Add to Query String button. Continue
building the query using the AND, OR, NOT and () Advanced
Query Operators, or Clear or Execute
'run' the query.
Example:
Using the parcels layer select 'MAPTAXLOT' from Select Field
(1) and 'EQUAL TO' from the Select Operator
(2). Select Operators are used to narrow your search parameters.
The operators available to you depend on the field in question.
If
the Select Field is text based the Select Operators
are: EQUAL TO, NOT EQUAL TO, LIKE. If the Select Field is number
based the Select Operators are: GREATER THAN, LESS THAN, GREATER
THAN OR EQUAL TO, LESS THAN OR EQUAL TO, EQUAL TO, NOT EQUAL TO
Tip:
The LIKE operator is useful for conducting a broad search. It's
position before or after the search criteria determines the search
type. For example, to select all parcels that start with 141632,
select MAPTAXLOT LIKE '141632%'.
Similarly if you want to find a parcel owned by Mr. & Mrs. Blacksmith
but you aren't sure of the spelling of their name type OWNER
NAME LIKE '%smith'. This would return all properties owned
by person/s with the word Smith in their name i.e. Blacksmith. Typing
a '%' before and after the search criteria i.e. %smith% will
return all possible permutations.
Note:
Remember to type the '%'
character into your search criteria.
Queries
are not limited to just one statement. They can be expanded to include
multiple 'combination' statements using the
AND, OR, NOT and () Advanced Query Operators:
1). ACRES
GREATER THAN 5 AND MAPTAXLOT LIKE '141632%' returns all
parcels greater than 5 acres in size where the maptaxlot number
starts with 141632.
2). ACRES
GREATER THAN 5 OR OWNER NAME LIKE '%SMITH' returns all
parcels greater than 5 acres in size plus all property whose owners
have 'smith' in their name.

|