Selecting events by attribute

You can use the Select Events by Attribute tool in the Roadway Characteristics Editor to select events within a map by querying the event layer's attributes. This method of event selection uses Structured Query Language (SQL) to select events on the map using one or more criteria. The selection criteria may consist of attributes, operators, and calculations.

For example, if you want to select all the events within Route 10038401 that have a speed limit greater than 25 miles per hour, you'll write an SQL expression: "Route_ID" = '10038401' AND "Speed_Limit" > 25.

To learn more about building SQL expressions, please see Building a query expression.

  1. Open a web browser and navigate to the Roadway Characteristics Editor.
    Select events by attributes
  2. Click Select > Select by Attribute .
    Selecting events by attribute
  3. Select the event layer on which you want to run the query using the drop-down list.
  4. Choose the selection method.
  5. Selection Type


    Create a new selection

    Creates a new selection set.

    Append to results

    Adds the currently selected features to the previously created selection set.

    Remove from results

    Removes the currently selected features from the previously created selection set.

  6. Double-click a field to add the field name to the expression box.
  7. Click an operator to add it to the expression.
  8. Click Get Unique Values to see the values for the selected field.
  9. Double-click a value to add it to the expression.
  10. Use steps 5–8 to add other conditions to the expression.
  11. Click Select.

    All the records in the SpeedLimit layer with a Route_ID of 10038401 and with a speed limit of 25 are highlighted on the map. The results are shown in a tabulated format.

Once the event records are selected, then you can navigate and edit them using the results grid. See Editing event records for more information.