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.
TOWN OF BLACKSBURG
GEOGRAPHIC INFORMATION SYSTEM MAP
The information contained on this page 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 Town of Blacksburg Geographic Information Systems Office. In no event will the Town of Blacksburg 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.
Site Last Updated November 2013
Site Developed by Anderson & Associates, Inc.Contact Us