Setting extraction queries for product classes (Maritime Charting)

Extraction queries allow you to determine which features are going to be included on your products. The queries that are created at the product class level of your product library control what is extracted for the products, instances, and areas of interest within the product class.

If you are using the Nautical Information System (NIS) and the preconfigured product library workspace XML, then the New Nautical Product wizard will construct an extraction query for you based on your inputs. However, if you need to customize the extraction queries, then there are guidelines you need to follow. Once you build a product library, you can set extraction queries for the products you manage in the enterprise production environment.

When constructing your custom query, you will need to include variables that the New Nautical Product wizard will replace with the inputs for the compilation scale and, if necessary, the M_CSCL scale values. The following is a list of the variables and an example of what they look like in a query:

Example of what the query should look like for an ENC product with the variables:

((IS_CONFLATE = 1 AND PLTS_COMP_SCALE >= largest_scale) OR ((IS_CONFLATE = 0 OR IS_CONFLATE IS NULL) AND (PLTS_COMP_SCALE >= product_scale AND PLTS_COMP_SCALE < next_product_scaleband)) additional_mcscl_band_queries) AND NIS_PRODUCTS IN (ALL, ENC))

Steps:
  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 view
  3. If necessary, expand Product Library and Products.
  4. Navigate to the product class for which you want to define extraction queries.
  5. Right-click the product class and click Extraction Settings.

    The Extraction Settings dialog box appears.

    Extraction Settings dialog box

  6. Right-click in the Selections table and click Add Record.
  7. If necessary, click the Series Type cell, click the drop-down arrow that appears, then choose the series type from which you want to extract features.

    For Maritime Charting, use the default value ALL.

    A new row appears in the table.

  8. If necessary, click the Product Type cell, click the drop-down arrow that appears, then choose the series type from which you want to extract features.

    For Maritime Charting, use the default value ALL.

  9. If necessary, click the Instance Type cell, click the drop-down arrow that appears, then choose the instance type from which you want to extract features.

    For Maritime Charting, use the default value ALL.

  10. If necessary, click the AOI Type cell, click the drop-down arrow that appears, then choose the area of interest type from which you want to extract features.

    For Maritime Charting, use the default value ALL.

  11. Click the Tables cell, click the drop-down arrow that appears, then choose a table or feature class from which you want to extract features or records.

    For Maritime Charting, use the default value ALL.

  12. Click the SQL Statement browse button.
    SQL Statement browse button on the Extraction Settings dialog box

    The Query Builder dialog box appears.

    NoteNote:

    The Add Table button is enabled if you selected a particular table instead of ALL in the Extraction Settings dialog box.

  13. Type or paste the WHERE clause you want to use with the table in the cell.

    If you are using Maritime Charting, the Please select a table from which to get field names dialog box appears for the first record with the tables value of ALL, and you can skip this step.

  14. Choose the PLTS_COLLECTIONS table from the default list and click Select.
    TipTip:

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

    The Query Builder dialog box appears.

    PLTS_COLLECTIONS table on the Query Builder dialog box
  15. Check the Edit query text check box to insert your query.
    The Edit query text check box is checked
  16. Click Verify to verify your query.
  17. Click OK to close the Query Builder dialog box.
  18. Repeat the steps starting at step 6 for each extraction query you want to create.
  19. Click OK when you are finished.
12/22/2014