USING SPATIAL SQL

Don’t be intimidated by spatial structured query language (SQL). It is very powerful tool, is easy to use once understood, and is way more flexible than any wizard that can be developed. But, it will require you to understand a few simple coding rules and follow the examples provided below. Highlight, right click, and copy the desired SQL statement from below and then right click, paste it into the Custom Query Box on the web page, then modify the variables for your desired search. 

Examples

Select all parcels with "jones" somewhere in the field "name" 
select * from parcels where name LIKE UCASE("%Jones%")

Select all parcels with "jones" at the beginning of the field "name" 
select * from parcels where name LIKE UCASE("Jones%")

Select all parcels that are within a the subdivision "Blue Mesa Estates Ltd".
select * from [parcels] where subname = "BLUE MESA ESTATES LTD"

Select parcels within 500 of a parcel
select * from parcels where distance (parcels.id, (select id from parcels where parcelnb = "370136311001")) <= 500

Select parcels adjacent to an individual parcel
select * from parcels where adjacent((select ID from parcels where parcelnumb = "378702146006"), parcels.id)

Select all parcels that are within 50 feet of a road name
select * from parcels where distance(parcels.id, (select id from roads where road_name = "GOTHIC AV")) < 50

Select all parcels that have an agriculture account type and a land actual value of greater than $100,000
select * from parcels where accttype = "AGRIC" and landact > 100000

Any field in any table is searchable. Use the basic form below and replace the table name after the word "from" and replace the field name after the word "where" in the query.
select * from parcels where reception_ LIKE UCASE("%562585%")
select * from lakes where name LIKE UCASE("%meridian%")
select * from wilderness where name LIKE UCASE("%fossil%")
select * from towns where name LIKE UCASE("%pitkin%")

Use the following SQL rules to further modify the query.

SQL Rules

- Use % with LIKE as a wildcard either before and/or after the text to select records with any characters before and/or after the text
- Use UCASE to remove case sensitivity from your input
- Case sensitivity is not required in SQL execpt for within text strings (ie., "BLUE MESA ESTATES LTD")