Skip To Content

Find Existing Locations

Find Existing Locations is used to find features in your analysis layer based on a query. A query is made up of one or more expressions. There are two types of expressions: attribute and spatial.

An example of an attribute expression is that a parcel must be vacant, which is an attribute of the Parcels layer (where STATUS = 'VACANT'). An example of a spatial expression is that the parcel must also be within a certain distance of a river (Parcels within a distance of 0.75 Miles from Rivers).

Example of spatial and attribute query
Parcels must be close to a river and must also be vacant.

After you build your query, click Run Analysis. Your result layer will contain those features from your analysis layer that meet the conditions of your query.

Building expressions

To build an expression, click the Add Expression button to open the Add Expression dialog box.

Attribute expressions

Add Attribute expression example
Add Expression dialog box for attribute expression

Input layer

Layers you can use in the expression are listed here. Initially, the only choice will be the analysis layer. Once you establish a spatial relationship to other layers (for example, Parcels completely within City Boundaries), the other layers will be listed in the drop-down menu.

Expression type

This is the expression type. For attribute expressions, choose where (attribute query).

Field

Choose the field you want to query against from the list.

Operator

Choose an operator for the expression.

Value, Field, or Unique value

  • If you want to find features based on a specific value, choose Value and enter a value in the input box.
  • If you want to compare the value in one field versus the value in another field, choose Field, click the drop-down arrow, and choose the field for your expression. For example, in the illustration above, features where the value of POP UNDER 18 is greater than the value of POP OVER 18 will be found.
  • If you want to find features based on a specific value in the field you've selected for your expression, choose Unique and select a unique value from your field. Unique value filters require feature services that are published using ArcGIS Desktop 10.1 or later.

Note:

  • If any of your layers has a filter applied, only those features that meet the filter expression will be used in the analysis.

Spatial expressions

Spatial expressions are created by choosing expression types such as completely within or intersects (the complete list can be found below).

When you choose a spatial expression type, the Add Expression dialog box changes depending on the expression type you choose.

Spatial Expression
Add Expression dialog box for spatial expression

First layer

The first layer. Initially, the only choice will be the analysis layer. Once you establish a spatial relationship to other layers (for example, Parcels completely within Community Boundaries), these other layers will be listed in the drop-down menu.

Expression type

The spatial expression type. See below for details about each of the spatial expression types.

Second layer

The second layer. These are the other layers in your map.

Example of a completed query

Here is an example query borrowed from the book Understanding GIS, An ArcGIS Project Workbook. The premise of the book is that you're looking for vacant parcels in the city of Los Angeles suitable for developing public parks. The criteria for a suitable park site includes the following:

  • The parcel must be vacant.
  • It must be within the Los Angeles city limits.
  • It must be greater than one acre in size.
  • Some part of the parcel must be within 0.75 miles of the Los Angeles river.
  • The parcel must be at least 0.25 miles from existing parks.

Below is an illustration of the Find Existing Locations query based on the above criteria using layers named Parcels, Rivers, and City Boundaries:

Query to find parcels

Notes:

  • The order of the expressions does not affect the result of the analysis.
  • You can group and ungroup expressions by clicking the group and ungroup buttons group and ungroup. In order to create groups, select two or more expressions and click the group button. More information about groups can be found below.
  • Clicking and switches the operator to or. Clicking or switches the operator to and.

Spatial expression types

A spatial expression establishes a relationship between two layers. If you need to establish a spatial relationship between features in the same layer (for example, you want to select vacant parcels within a distance of industrial parcels), copy the parcels layer and add it to your map so that you have two layers using the same parcel features.

Within a distance of / Not within a distance of

Within a distance of

The within a distance relationship uses the straight-line distance between features in the first layer to those in the second layer.

  • Within a distance of—A feature in the first layer is selected (included in the output) if any part is within the specified distance of a feature in the second layer; for example, parcels within 100 meters of a river will be included in the output.
  • Not within a distance of—A feature in the first layer is excluded (not included in the output) if it is within a distance of another feature; for example, parcels within 100 meters of a river will not be included in the output. You can think of this relationship as "is farther away than".

Note:

  • Distances are calculated between the closest parts of features. In the example above where parcels had to be within 0.75 miles of the Los Angeles River, parcels are selected if any part of the parcel is within 0.75 miles. If the criteria is that the entire parcel must be within 0.75 miles, you would use the Create Buffers tool with a distance of 0.75 miles around the Los Angeles River to create a new layer. You would then create an expression where parcels are completely within the buffer layer.

Completely contains / Does not completely contain

Completely contains

A feature in the first layer passes this test if it completely surrounds a feature in the second layer. No portion of the contained feature can be outside the containing feature; however, the contained feature is allowed to touch the containing feature (that is, share a common point along its boundary).

  • Completely contains—If a feature in the first layer contains a feature in the second layer, the feature in the first layer is included in the output.
  • Does not completely contain—If a feature in the first layer contains a feature in the second layer, the feature in the first layer is excluded from the output.

Examples:

  • You have a layer of parcels (the first layer) and another layer of points representing wells (the second layer), and you want to find parcels that contain wells. You would use completely contains to find parcels containing wells.
  • You have a layer of parcels and a layer of points representing toxic waste sites. You want to find parcels that do not contain toxic waste sites. You would use does not completely contain to find parcels that do not contain toxic waste sites.

Note:

  • You can use the contains relationship with points and lines. For example, you have a layer of street centerlines (lines) and a layer of manhole covers (points), and you want to find streets that contain a manhole cover. You could use completely contains to find streets that contain manhole covers, but in order for a line to contain a point, the point must be exactly on the line (that is, in GIS terms, they are snapped to each other). If there is any doubt about this, use the within a distance of relationship with a suitable distance value.

Completely within / Not completely within

Completely within

A feature in the first layer passes this test if it is completely surrounded by a feature in the second layer. The entire feature in the first layer must be within the containing feature; however, the two features are allowed to touch (that is, share a common point along its boundary).

  • Completely within—If a feature in the first layer is completely within a feature in the second layer, the feature in the first layer is included in the output.
  • Not completely within—If a feature in the first layer is completely within a feature in the second layer, the feature in the first layer is excluded from the output.

Examples:

  • You have a layer of houses for sale (points) and a layer containing a particular school district, and you want to only find houses that are completely within the school district.
  • You have a layer of vacant parcels (the first layer) and another layer of city boundaries (the second layer). Your task is to find vacant parcels that are outside city boundaries. You would use not completely within to find parcels not within (that is, are outside) any city boundary.

Note:

  • You can use the within relationship for points and lines, just as you can with the contains relationship. For example, your first layer contains points representing manhole covers and you want to find the manholes that are on street centerlines (as opposed to parking lots or other non-street features). You could use completely within to find manhole points within street centerlines, but in order for a point to contain a line, the point must be exactly on the line (that is, in GIS terms, they are snapped to each other). If there is any doubt about this, use the within a distance of relationship with a suitable distance value.

Intersects / Does not intersect

Intersects

A feature in the first layer passes the intersect test if it overlaps any part of a feature in the second layer, including touches (where features share a common point).

  • Intersects—If a feature in the first layer intersects a feature in the second layer, the feature in the first layer is included in the output.
  • Does not intersect—If a feature in the first layer intersects a feature in the second layer, the feature in the first layer is excluded from the output.

Examples:

  • You have a layer of parcels and a layer of rivers. You want to find parcels that have a perennial river that flows through the parcel, or touches the parcel. You would use intersects to find parcels with rivers flowing through them.
  • You have a layer of parcels and a layer of 100-year flood zones. To find parcels where no portion of the parcel is within the 100-year flood zone, you would use does not intersect.

Grouping

Two or more consecutive expressions can be grouped together using the group button group. Select the expressions to group by pressing the Shift key and clicking expressions.

Here's an example where grouping is needed:

  • You have a point layer of sites containing toxic chemicals. Each point has an attribute, CHEMICAL, containing the name of the toxic chemical known to exist at the site.
  • You want to find toxic sites containing Mercury or Selenium that are near a river.
  • You also want to find toxic sites containing Benzene or Lead that are near a park.

In the above example, two sets of features are created from the same toxic sites layer: toxic sites near parks and toxic sites near rivers. These two sets are distinct from each other.

Since the set of toxic sites near a river is distinct from the toxic sites near a park, you would want to use grouping to construct the query. Figure 1 shows the initial query without any grouping or modification of logical operators (they are all and). This query would result in toxic sites within a kilometer of both a park and a river. This isn't the goal—desired result is one set of toxic sites within a kilometer of a river and another distinct set within a kilometer of a park.

Initial query
Figure 1: Initial query

To construct a query that meets the criteria outlined above, groups need to be created. Each group forms a subquery whose results are combined with the previous expression.

Start by selecting the first two attribute expressions, as shown in Figure 2.

Select the first group of attribute expressions
Figure 2: Select the first group of attribute expressions.

After selecting the two attribute expressions, click the group button group. The group becomes indented, as shown in Figure 3.

Select the second group of attribute expressions, as shown in Figure 3.

Select the next group of attribute expressions
Figure 3: Select the second group of attribute expressions.

After selecting the second group, click the group button.

Finally, select the second group of attribute expressions and the spatial expression to which they belong, as shown in Figure 4.

Select the second group of attribute expressions and the spatial expression to which they belong
Figure 4: Select the second group of attribute selections and the spatial expression to which they belong.

Click the group button and the query becomes indented, as shown in Figure 5. The final step is to switch and to or, as shown in Figure 5.

The final query
Figure 5: The final query

The query shown in Figure 5 will yield the desired result.

  • Toxic Sites with LEAD or BENZENE are found and these features are subset by finding those within one kilometer of Parks.
  • Next, Toxic Sites with SELENIUM or MERCURY are found and these features are subset by finding those within one kilometer of the River.
  • Finally, the two sets of features are combined using a logical or.

Grouping expressions is only necessary when you need to create two or more distinct sets of features from the same layer. One way to think of grouping is that without grouping you would have to execute Find Existing Locations twice, once to find sites near rivers and again to find sites near parks, and then use the Merge tool to combine the two results.

You can click the text button text to view a textual representation of the query. The textual representation uses parentheses to denote groups.