ArcGIS Desktop

  • ArcGIS Pro
  • ArcMap

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

Modifying extraction queries by appending an AND statement

Available with Production Mapping license.

Instead of overriding the extraction query, you can choose to append a required condition to the original WHERE clause. To append additional required conditions, you would use an AND operator.

For example, if you want to add the map compilation scale as a required condition of the extraction query, you can add

AND M_CSCL = '40000'

to the extraction query that has been created at the product class level. This tells the populator that the features extracted must meet the conditions specified at the product class level as well as have a map compilation scale value of 40000.

  1. Start ArcMap.
  2. If necessary, open the Product Library window by clicking Customize > Production > Product Library on the main menu.

    A tree view of the product library appears.

  3. Expand Product Library and Products.
  4. Navigate to the series, product, instance, or area of interest for which you want to append an AND operator to the extraction query.
  5. Right-click the product, instance, or area of interest and click Properties.

    Tip:

    Extraction queries can be applied at the instance level (common for nautical charts) or at the series level if all the products associated with that series will have the same compilation scale.

    The properties dialog box appears for the series, product, instance, or AOI.

  6. Click the Extraction pane on the left of the dialog box.

    The extraction properties appear. The Settings area is blank.

  7. Right-click in the Settings table and click Add Record.

    Adding a record in the Extraction pane

    A new row appears in the Settings table.

  8. Click the drop-down arrow in the Tables cell and choose the name of the table or feature class for which you want to modify the extraction query.
  9. Repeat steps 7–8 for each table that has a query you want to modify.
  10. Click the cell to the left of the Tables cell to select an entire row.

    Tip:

    You can press and hold CTRL or SHIFT while clicking several rows at once to select more than one row.

  11. Right-click the rows and choose Product Class Where Clause AND.

    Product Class Where Clause AND

    AND appears in the Option cell for the row or rows you have chosen.

  12. Click the ellipsis (...) in the SQL Statement cell.

    The Query Builder dialog box appears.

    An expression that has been appended with both an AND and OR statement
  13. Check the Edit query text check box.

    The query in the WHERE text box becomes editable.

  14. Place your pointer at the end of the query text and click the AND operator.
  15. Paste or type the condition you want to add to the extraction query.

    Tip:

    You can append more than one AND operator and type more conditions.

  16. Click OK.

    The properties dialog box appears for the series, product, instance, or AOI.

  17. Repeat steps 12–16 for each extraction query to which you want to append an AND operator.
  18. Click OK.

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2020 Esri. | Privacy | Legal