1. Search on only one or two fields at a time.
2. Enter as little information as possible to account for spelling variations.
Search for "Club" instead of "West Club Boulevard", in case it is entered as "W Club Blvd".
Search for "Smith, J" instead of "Smith, Jim", it case it is entered as "Smith, James".
3. Don't use periods or other punctuation. Search for "Public John Q" instead of "Public, John Q."
A 13 digit number. Example: 183700401028 If entered, must be at least 6 digits.
Generally entered as last name comma first name. Example: Smith, John
Integer greater than 0. Example: 374
Integer greater than 0. Example: 1455
Generally just the street name, no house number. Example: Main St
4. Enter a value into the box to the right of the operator.
5. Click "Add to Query".
6. Optional: repeat steps 2 thru 5 to build more complex queries.
7. Click "Run".
You can also type directly into the "Query" box to edit a query or to create queries more complex than supported by the interface.
One major stumbling block is data that looks like a number or a date, but is stored as text.
These are difficult to query and get the desired results. A common example: if ACRES is a text field, a query like
will not return any parcels where ACRES=2 because, alphabetically, "2" is greater than "10" or even "1000000". You can try a query like
CAST(ACRES AS FLOAT)<10
which might work, but if there is any non-numeric data in that field (like "10.0AC"), the query will fail. Then you could try
(CHARINDEX('AC',ACRES)>1) AND (CAST(LEFT(ACRES,CHARINDEX('AC',ACRES)-1) as FLOAT)<10)
but any inconsistency in the data will thwart that also, and the required knowedge of both the raw data and SQL quickly goes far beyond the scope of this document.
The information contained on this site is NOT to be construed or used as a "legal description". Map information is believed to be accurate but accuracy is not guaranteed. Any errors or omissions should be reported to the Avery County Mapping Department. In no event will Avery County be liable for any damages, including loss of data, lost profits, business interruption, loss of business information or other pecuniary loss that might arise from the use of this map or the information it contains. For questions, comments, or problems please contact the Avery County Mapping Department.
The information contained on this site was last updated January 2013