Parent Topic: Attribute Editing and Querying

Query Expression Examples

Assume the current layer has these attribute fields defined:

    Attribute Field Name     Data Type

    Latitude                 float
    Longitude                float
    County                   string
    Population               integer

To find, in the list of highlighted shapes in the Attribute Query panel, the shapes that have both a latitude greater than 45.3 and a longitude less than or equal to 62.7, this is the query expression to use:

    (Latitude > 45.3) and (Longitude <= 62.7)

Other examples of valid query expressions:

    ((Latitude = 37) and (Longitude >= 62.7)) or (Population <= 5000)
    (Latitude>25) or (County = "Tweed Township")

Here are some queries which would produce the same results for the same set of highlighted query shapes:

    Population <= 60000
    not (Population > 60000)
    (Population>0) and (Population<60001)

Parent Topic: Attribute Editing and Querying
About PCI Help Gateway