Repetitive Select by Attribute

Question

I am looking for a way to speed up my tasks of selecting streets by street names. I need to find and select streets by their name and tag them between certain intersections. Is there a way to not have to select and delete the previous query from the Select by Attribute box so I only have to double click the new query street name and click apply?

ChrisDonohue__GISP · Answer

An alternative workflow that may work better than doing many selections:

1.  Open the attribute table for your streets

2.  Right-click on the "FULLNAME" field heading and choose "Sort Ascending"

3.  Scroll to street of interest and select it.

4.  Use the "Zoom to Selected" tool.

5.  Return to step 3 to repeat for the next street.

Chris Donohue, GISP

AndyMinor · Answer

That won't work. I am tagging sections of streets to highlight routes. I am searching the street data for streets included in the routes. It jumps around and only includes a small percentage of the streets. I am just looking for a way to not have to select the street name to put the next street in the query box. See below. I am trying to save 5+/- seconds for each street by not having to clear the previous query result.

DarrenWiens2 · Answer

Are you just selecting the street in order to zoom to it, and then selecting the portion to update? If so, you could skip the initial selection and use the streets as a data driven page index, instead. This will let you cycle through each street name, zooming to each street in order.