Modifying extraction queries by overriding

You can replace the exact values as needed in instances where you are using different attribute values to determine which features are going to be extracted from a database. For example, if you are using the compilation scale value for features to determine which features need to be extracted for a chart, you can change the values at the product, instance, or AOI level. The compilation scale used could be 8,000 at the product class level but 40,000 for a specific product in a series.

You can also choose to completely override an existing extraction query with different conditions for the same table or feature class. As an example, you can choose to only select features using the compilation scale at the product level, while the original extraction query uses the compilation scale and specific feature class subtypes.

If you are using the Nautical Information System (NIS), every product must have extraction queries set for replication to know what features to extract from the NIS and maintain in your product. These queries are stored at the class level with default settings for scale. Specifics need to be set with the appropriate scale value.


If your nautical chart will have multiple instances (panels), and each instance is expected to contain a unique scale, you are required to set up a set of extraction queries on the Extraction pane on the Instance Properties dialog box, not the Product Properties. The extraction queries must reference these unique scales for each instance to ensure that the correct scaled data is replicated.

You can also modify extraction queries by appending an AND or an Or operator at the end of the WHERE clause.

  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.

    Product library tree
  3. Navigate to the series, product, instance, or AOI for which you want to override the extraction query.
  4. Right-click the product, instance, or area of interest and click Properties.

    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.

  5. Click Extraction on the left side of the dialog box.

    The extraction properties appear. The Settings area is blank.

  6. Right-click in the Settings table and click Add Record.
    Adding a record in the Extraction pane

    For the Nautical Solution, add a total of two records if you are overriding extraction queries at the product level.

    A new row appears in the Settings table.

  7. 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.

    For the Nautical Solution, leave the first record as ALL and change the second record to PLTS_FREL if you are overriding extraction queries at the product level.

  8. Repeat steps 6–7 for each table that has a query you want to modify.

    The default option for each record you add is OVERRIDE, so you do not have to change it.

    Example of tables for extraction
  9. Click the SQL Statement Browse button.

    If you are using the Nautical Solution, the Please select a table to get field names from dialog box appears for the first record with the tables value of ALL.

  10. Choose the PLTS_COLLECTIONS table from the default list and click Select.

    The default location is C:\Documents and Settings\<user login>\Application Data\ESRI\Production10.0\DMVTemplates.

    The Query Builder dialog box appears.

    Query Builder dialog box
  11. Check the Edit query text check box.

    The query in the WHERE text box becomes editable.

  12. Paste or type the new query you want to use for the table or feature class.

    Fill in the lower_scaleband_value and next_scaleband_value in the WHERE text box to reflect the correct compilation scale values for your product. These values are based on the scale band values defined for your NIS. Contact your NIS administrator for these values.

    For example, if you want to extract a 100,000-scale product and your NIS has the two scale bands of 50,000 and 150,000, your lower_scaleband_value will be 50000, and your next_scaleband_value will be 150000.

    Example of an extraction SQL statement

    You can also click the Load button and browse to sample queries located at Nautical_Data_Samples\Control\Extraction Queries or load your own queries.

  13. Click OK.

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

  14. Repeat steps starting at 9 for each override you want to specify.

    If you a using the Nautical Solution, click the SQL Statement Browse button at the end of the PLTS_FREL row, then click OK to set the PLTS_FREL query and close the Query Builder dialog box.

  15. When you are finished creating new records for each extraction query, the Extraction section should look like the one below (with the appropriate scale values).
    Example of nautical extraction queries
  16. Click OK to close the properties dialog box.