Using Page Definition Queries

Page Definition Queries allow you to specify which features of a layer draw based on an SQL query. Though similar to other definition queries, Page Definition Queries differ in that they only work with Data Driven Pages and are dynamic. Features are filtered based on the current page. As you iterate through the pages, the query changes, and a new set of features draw appropriate to the new page. If you have features that overlap page extents and want these features to display in multiple pages, you should consider using clip to customize your map.

For example, suppose you want to create a map book showing crop acreage for each state in the United States. Each state has a separate page in the book displaying the crop acreage by county. To simplify your series of maps, you want to only display crop acreage for the state specific to the map book page. Page Definition Queries allows you to do this quickly and easily.

Here is an example of what a couple of the pages would look like without a Page Definition Query:

Examples of Data Driven Pages without a Page Definition Query

As you can see, the map page for Arkansas shows crop acreage information not only for the state of Arkansas but also for the surrounding states. This would be true for all map pages. Using a Page Definition Query can simplify the map such that the crop acreage information is only displayed for the state specific to the page. The example below shows the results when you choose to match features to the page name. You can also choose the inverse, to display features that do not match.

Examples of Data Driven Pages with a Page Definition Query

Each map above contains a locator map of the continental United States in the lower left corner of the page layout. In each locator map, you can see the current feature index for the Data Driven Page highlighted in red. The red outline in the locator map is known as an extent indicator. In these examples, the index features are the states of Arkansas and California.

Learn more about using extent indicators to enhance overview or locator maps

There are some important things to keep in mind when using Page Definition Queries.

For best results

How to create a Page Definition Query

  1. Right-click the layer in the table of contents and click Properties. Do not attempt this with the Data Driven Pages index layer, as Page Definition Queries are not supported for the current index layer.
  2. Click the Definition Query tab on the Layer Properties dialog box.
  3. Click the Page Definition button.
  4. Click the Enable check box.
  5. Select the field that matches the Data Driven Pages Page name field from the Page Name Field drop-down list.
  6. Choose to show either features that Match or Don't Match the page.
  7. Click OK.

Related Topics