Work Frequency

The View Work Frequency tool allows users to view how often the agency performs work in an area. The tool uses an Address, X/Y coordinate, or assigned Assets to plot Work Order locations within the map. Then, the tool groups the points together based on proximity. Layer symbology changes based on the number of Work Orders are at a given location.

Enter Work

Search Options

Enables the user to select a set of Work Orders to display based on a date range or a saved filter.

Filter Options

Enables the user to select a filter from the Work Order Standard or Work Order Lite modules when using the Use Filter option. The user can limit the list to only those filters he or she created.

Grouping Option

Enables users to group results based on the values of one or two fields.

Example: If there are five Work Orders at one location, the tool normally displays one dot that is symbolized to represent the five Work Orders. However, if work orders are grouped by Task, and the five Work Orders at the location represent three different Tasks, the tool displays three dots.

X/Y Buffer

Directs the tool to group Work Orders that are within a specified distance of each other.

Work Orders are typically grouped only when they represent the exact same location. To provide a more generalized map, the user can tell the tool to group work orders that are within a given distance of each other.

Example: There are two Work Orders at Location A and four Work Orders at Location B, which is 10 feet away. The program normally puts a point at Location A that is symbolized to represent two Work Orders and a point at Location B that is symbolized to represent four Work Orders.

However, if the user enters an X/Y Buffer of 11, the program reacts differently. After identifying the two Work Orders at Location A, it searches 11 feet* in all directions for other Work Orders. When it discovers the four Work Orders at Location B, it displays a point between the two locations that is symbolized to represent all six Work Orders.

*The unit of measure is based on the scale the map project uses.

Do not plot addresses for ...

Controls how a Work Order is plotted in the results. If a Work Order has an Address and Assets, the system automatically plots both the Address and Asset point in the map. However, when this option is enabled, the system only plots the Asset points when they are present.

How To Plot Work Frequency

  1. Click the View Work Frequency tool Work Frequency.

    frequency message

  2. The following dialog box appears:

    Enter Work

  3. Select either a Date range or saved Filter:
  4. Select fields for the First and Second Grouping Option (optional).
  5. Enter a value for the X/Y Buffer (optional).
  6. By default, the Do not plot addresses for work orders with assets in the asset grid option is checked.
  7. Click OK. The system displays the Work Order frequency that meets the selected criteria. While the system is processing, a progress bar appears in the lower left-hand corner of the map.
  8. Once the process is complete, a grouped layer containing three layers is added to ArcMap . The table of contents shows work order frequency for point, line, and polygon features. The symbology for these layers uses graduated sizing and colors, based on frequency. To change the way the frequency is displayed, right-click on the layer and go to the Symbology tab.

    frequency layers

  9. In some cases, the tool may be unable to map the location of a Work Order. Look in the work frequency layer's Attribute table to determine whether a feature was found in the map (using the InMap field). A value of 1 indicates the feature was found. A value of 0 indicates that it was unable to be located in the map.

    frequency table