Defining a definition query set

Available with Production Mapping license.

The Definition Queries tab on the Feature Display Settings dialog box provides you with a way to determine which features appear on a map or chart. The queries included in the set indicate what features display on the map or chart.

For example, cartographic features for multiple charts can appear within the extent of a chart. Definition queries are based on a field common to all cartographic feature classes in the Aeronautical Information System (AIS), MapId_Txt. The other cartographic features relating to other charts remain in the database. They are excluded from displaying on the chart based on the chart identification information stored in the MapId_Txt field. If the definition query is removed from the feature layer in the ArcMap table of contents, all cartographic features within that chart extent will display.

When you create definition query sets, you can create queries that work across several feature classes or individual queries for each feature layer. Similar definition queries are used on multiple maps or charts. By storing the definition query sets, you can recall, apply, modify, and save query sets for multiple layers. You do not have to manually create definition queries for all feature layers and apply new queries to additional feature layers in different maps or charts. This means that your set can include several queries for individual feature layers or a single query that includes all feature layers in your map.

1. Start ArcMap.
2. On the main menu, click Customize > Toolbars > Aviation Data Management.
3. Click the Feature Display Settings button on the Aviation Data Management toolbar.

   The Feature Display Settings dialog box appears.

   

4. If necessary, click the Definition Queries tab.
5. Click the name of the feature layer for which you want to define the definition query in the Feature Layers list.

   For example, ADHP_C.

   Note:

   Checking the check box next to the feature layer will not select it.

6. Click SQL.

   The Define Query Expression dialog box appears.

   

7. Double-click the field you want to use in the query.

   The field name appears in the Where text box. For example, MapId_Txt.

8. Click an operator.

   The operator appears in the Where text box. For example, =.

9. Click Get Unique Values.

   The unique values for the field appear.

10. Double-click the value you want to use in the query.

    The unique value appears after the operator in the Where text box.

    For example, Aeronautical::Enroute::Lower::SANFRAN::SANFRAN.

11. Click Verify.

    The Verifying expression message appears and indicates whether or not the expression is valid.

12. Click OK to close the verification message.
13. Click OK on the Define Query Expression dialog box.

    The Definition Queries tab appears.

14. Repeat steps 5 through 13 for each feature layer you want to include in the definition query set.
15. Check the check box next to the layers you want to include in the saved definition query set.
16. Click Save As.

    A message appears notifying you that the settings you want to save have not been applied to the map or verified.

17. Click Yes to continue with the saving process.

    The Feature Display Settings dialog box appears.

    

18. Type a name for the definition query set in the Enter the set name text box.
19. Type a description for the definition query set in the Enter the set description text box.
20. Click OK.

    The Definition Queries tab appears. The layers for which definition queries have been saved will change to bold text once you have saved the query set.

    Tip:

    If you want to use the same definition query for all the feature layers, you can define the definition query once and copy and paste it into the Multiple definition queries (checked items) text box. Check the check boxes next to the layers to which you want to apply the same definition query and click Replace. Each of the checked layers now have the specified definition query applied. Click OK to dismiss the Definition Queries replaced message.

21. Click the Close button to close the Feature Display Settings dialog box.