Creating rule sets and rules for route processing preferences

Rule sets contain rules. Each rule set contains at least two rules. Rules define selection and processing criteria for a route. Rules use SQL expressions to match routes to a processing instruction. Routes that have attribute values defined within a rule are processed by that rule.

Rules have the following properties:

You can have more than two rules per rule set. You can have more than one rule set per route processing preference. There is also a default rule that is applied if a route meets no rule set's criteria.


The following steps detail how to create new rule sets and rules. These steps are intended to supplement the steps outlined in Creating route processing preferences.

  1. Start ArcMap.
  2. On the main menu, click Customize > Production > Production Properties.

    The Production Properties dialog box appears.

  3. Click Data Management in the list on the left side of the Production Properties dialog box.
  4. Click the drop-down arrow in the cell next to Set Tool Options.
  5. Click the ellipsis (...) next to Route Processing Preferences.

    The Route Processing Preferences dialog box appears.

  6. Click Create.

    A new Rule Set row appears at the top of the Route Rules table.

    A new rule set in the Route Processing Preferences dialog box
  7. Click the button at the right edge of the new Rule Set row.

    The Rule Set Builder dialog box appears.

    The Rule Set Builder dialog box
  8. Click the ellipsis (...) in the Selection Query cell.

    The Query Builder dialog box appears with the expression Master_Id = ATSRoute.GFID listed in the WHERE text box.

  9. Click the mouse pointer after Master_Id = ATSRoute.GFID.
  10. Click the And or Or operator.
  11. In the Fields area, click to choose the field you want to use in the selection or WHERE clause.
  12. Click Add to WHERE.

    The field name is added immediately after the expression Master_Id = ATSRoute.GFID AND.

  13. Click an operator button.

    The operator is added between the field and the expression: Master_Id = ATSRoute.GFID AND CartoModified_Code =.

  14. Click All Values.

    All the unique values for the field appear in the Values list.

  15. Click to choose one of the values in the Values list.
  16. Click Add to Where.

    The expression is complete and should read Master_Id = ATSRoute.GFID AND CartoModified_Code = 1.

  17. Click Verify to validate the SQL statement.
  18. Click OK.

    The Rule Set Builder dialog box appears.

  19. Check Required to specify that one of the overlapping routes must match the criteria specified in the rule.
  20. Check Visible to set a route's IsVisible value to 1-Yes.
  21. Click the ellipsis (...) in the Field Calculation area.

    The Field Calculation dialog box appears.

  22. Click the Field drop-down arrow and choose a field to calculate.
  23. Perform one of the following actions:
    • Depending on the type of field you chose in step 8, type or choose a value in the Value text box or list.
    • Click ATSRoute Field and choose a field from the list.
  24. Click OK.

    The Route Processing Preferences dialog box appears.

  25. Repeat steps 3–18 for each rule in the Rule Set Builder dialog box.
  26. Click OK to close the Rule Set Builder dialog box.

Related Topics