I have a large shapefile of GPS points. Each point has a unique point ID number, but they are all part of different clusters, where each cluster has a unique cluster ID number (there is no overlap between clusters). For example, points 1, 2, and 3 are part of Cluster 100 and points 4, 5, and 6 are part of Cluster 200. I have done a Select by Location query of these points based on their proximity to a road feature class, and now have about 1400 points selected. I would now like to select any additional points that share a common Cluster ID to the already selected points. For example, say I captured points 1 and 2 of Cluster 100 with the locational selection query, how would I capture point 3 of Cluster 100 as well, in an efficient query? Or is there a way to have a subquery in the Select by Location query that would look at the cluster ID attribute?
Here's what I ended up doing: After doing my Select by Location query, I made a selectional layer of those points within the defined proximity of the road. I then ran a Frequency tool with the Cluster ID as the only frequency field and saved the table. I then joined this frequency table to the full set of points based on the Cluster ID, keeping only matching records. I then started an editing session and deleted all the points indicated in the joined table.