Creating a calculated field specification rule

Calculated fields allow you to determine the appearance of labels and annotation or basic data type values based on attributes you select. The fields are grouped based on the specification you choose.

  1. Start ArcMap.
  2. On the main menu, click Customize > Toolbars > Production Cartography.
  3. If necessary, load data in the map.
  4. Right-click the layer for which you want to define the calculated fields and click Properties.

    The Layer Properties dialog box appears.

  5. Click the Calculated Fields tab.

    Calculated Fields tab

  6. Click the Specification drop-down arrow and choose the specification for which you want to create the rule.
  7. Click Options > New Rule.

    A new row appears in the rule table.

  8. Double-click the Rule Description field.

    The field becomes editable.

  9. Type a name for the rule in the Rule Description text box.
  10. Click the ellipsis (...) in the Field Name field.

    The Field Properties dialog box appears.

    Field Properties dialog box

    When the calculated fields are created, you have the option of overwriting values in an existing field or creating a new field for the calculated values. When you create a new field, the values that result from the SQL statement and VBScript expression populate the field.

  11. If necessary, click the Name drop-down arrow to choose the existing field you want to use.
    1. If you do not want to use an existing field, click Add to create a new field.

      The New Field Name dialog box appears.

      New Field Name dialog box

    2. Type a name in the text box.
    3. Click OK.

      The Field Properties dialog box appears.

  12. Check the Edit Properties check box.

    The following items become available:

    • Alias
    • Type
    • Length

      The Length text box only appears if you choose Text in the Type drop-down list.

  13. Type an alias name for the field in the Alias text box.
  14. Click the Type drop-down arrow and choose one of the following:
    • Double
    • Integer
    • Single
    • Small Integer
    • Text
    Field Properties dialog box with Edit Properties checked
  15. If you choose Text, type a length in the Length text box.
  16. Click OK.

    The Layer Properties dialog box appears.

  17. Click the SQL Statement drop-down arrow and choose Edit SQL statement.

    The Query Builder dialog box appears.

  18. Define a query that includes the fields with values you want to use.
  19. Additionally, you can also include a field in the Select clause that has a domain value description if you want to use the description for labeling the field.
  20. Click OK.

    The Calculated Fields tab appears.

  21. Click the Expression drop-down arrow and click Edit Expression.

    The Expression Parser dialog box appears.

  22. Define an expression that includes the fields you want to use as calculated fields.
  23. Optionally, if any of the fields in the expression contains domain description text that you would like to use for labeling, use $[<field_name>] in the expression.
  24. Click OK.

    The Calculated Fields tab appears.

  25. To ensure that the feature class is updated with the rule information, verify that the Update Feature Class(es) check box is checked.
  26. Click OK.

Related Topics