I am creating a model so that I can help colleagues visualize the workflow I used on a problem.
My task was find all manholes in a specific area that connect to pipes >= 36". Simple enough, I did this outside of model builder and was able to generate the answer. When I put it in Model Builder and run it, the final solution selects all manholes and all pipes (collectively) in that area. That includes all pipes, regardless of size (1 inch, 6 inch, 12 inch, 18 inch, etc.). In the tools I used the derived data from the steps and used pipes that intersect manholes on a new selection. Not sure what to do!
Gravity Mains --> Select by Attributes * where Diamater >= 36
Pilot Boundaries --> Select by Attributes * where Name = NN05
Manholes --> Select by Location * Where Centroid is in NN05
The last selection is Pipes >= 36" that intersect Manholes that have their centroid in NN05