To Create a Range Table

A range table specifies a range of actions to take depending on the value of the specified data or property.

To create a range table

  1. In Map Explorer, under Current Drawing, right-click Current Query, and then click Define.
  2. In the Define Query Of Attached Drawings dialog box, click Alter Properties.
  3. If you are creating a range table for a property alteration, in the Set Property Alterations dialog box, select the property to alter.
  4. Move the cursor to the Expression box and specify the location of the value on which to base the alteration.

    Enter a dot variable, a field name, or other valid expression. For example, to modify the color of an object based on its elevation, enter .ELEVATION in the Expression box.

  5. Click Range.
  6. In the Define Range Table dialog box, click New to create a new range table.
  7. Enter a name for the range table and click OK.
  8. In the Define Range Table dialog box, select an operator and a value for the first condition.

    These determines which objects fall in this range.

  9. Specify the return value for the first condition.

    The return value specifies how to modify the selected property. For example, if you are modifying the color of an object based on its elevation, enter the color in the Return Value box.

  10. Click Add to add the condition to the Current Range Table Definition.

    When you run the property alteration, each object that has the specified expression value (for example, elevation > 200) will be modified according to the specified return value (for example, it will be colored red).

  11. Specify the remaining conditions.
  12. Click OK to close the Set Property Alteration dialog box.
  13. Make sure that Alter Properties is selected.
  14. Click Execute Query to retrieve the objects and alter them.

Creating an Example Range Table

The following example creates a range table for a property alteration. The example range table colors lots larger than 6000 red and lots 6000 or smaller blue.

To create a sample range table

  1. In Map Explorer , under Current Drawing, right-click Current Query, and then click Define.
  2. In the Define Query of Attached Drawings dialog box, click Set Property Alteration.
  3. In the Set Property Alterations dialog box, select the property Color.
  4. In the Expression area, click Property and select Area. Click OK.
  5. Click Ranges.
  6. In the Define Range Table dialog box, click New.
  7. Enter the name Color and click OK to close the New Range Table dialog box.
  8. Enter the description Color areas over 6000.
  9. In the Condition area, choose the <= operator.
  10. In the Expression Value area, enter 6000.
  11. In the Return Value area, enter Blue.
  12. Click Add.
  13. In the Condition area, choose the > operator.
  14. In the Expression Value area, leave the 6000 alone.
  15. In the Return Value area, enter Red.
  16. Click Add.
  17. Click OK to close the Define Range Table dialog box.
  18. Make sure that the Color range table is selected.
  19. Click Add to add the color property alteration to the Current Property Alterations list.
  20. Click OK to close the Set Property Alteration dialog box.
  21. Make sure that Alter Properties is selected.
  22. Click Execute Query to retrieve the objects and alter them.