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.
Rockbridge County, VA
Geographic Information System
The information contained on this page is NOT to be construed or used as a "legal description". Map information as shown is from county tax maps, subdivision plats and other sources. Property lines as shown may not show precisely where the legal boundary lines are. Please consult with a licensed land surveyor if there are any issues pertaining to the location of boundary lines. Any errors or omissions should be reported to the Rockbridge County Geographic Information Systems Office. In no event will the County of Rockbridge 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.