Selecting events and routes by attribute

Use the Select by Attributes widget in the Event Editor web app to select events, routes, or point features on a map by querying the layer's attributes. This method of event selection uses Structured Query Language (SQL) WHERE clauses to select events on the map using one or more criteria.

For example, if you want to select all the events within Route 10054101 that have a speed limit greater than or equal to 40 miles per hour, write an SQL expression such as "Route_ID" = '10054101' AND "Speed_Limit" >= 40.

Learn more about building a query expression

1. Open Event Editor and, if prompted, sign in to Portal for ArcGIS or ArcGIS Online.
2. Click the Edit tab.
3. Click the Layer drop-down arrow and choose the event layer, network layer, or point feature layer on which you want to run the query.

   You can browse the list of layers by keystroke. For example, press the S key in the drop-down menu to jump to the first layer in your list that begins with the letter s.

4. In the Selection group, click the Select drop-down arrow and click Select by Attributes.

   The Select by Attributes widget appears.

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

   If you know the SQL WHERE clause, skip steps 4 through 8 to build the expression and provide the WHERE clause.

10. Click Select.

    The results are shown in a tabulated format and selected features are highlighted on the map.

Once the event or point feature records are selected, you can browse to and edit them using the results grid.

Note:

You cannot edit the selected routes.