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

enter image description here

enter image description here enter image description hereenter image description hereenter image description here

  • 1
    This picture doesn't help very much, the tools themselves have been renamed and as such we can't tell what each process is. What is "Select all >= 36"? What is the query? What is Gravity Mains? and its fields? – Michael Stimson Dec 11 '17 at 21:28
  • 3
    To compliment @MichaelStimson avoid renaming tools (yellow boxes), it's OK to rename the inputs and outputs but renaming a tool from the default name which describes what the tool is means other users have no idea what the tool is that is being run. Nor will you in 6 months from now... – Hornbydd Dec 11 '17 at 21:32
  • Sorry about that. Please see edits to the post. – Wazzy24 Dec 11 '17 at 21:34
  • Is you query SELECT * WHERE diameter >= 36? Is diameter a numeric field or string field? (> and < do funny things with numbers as text). – Michael Stimson Dec 11 '17 at 21:35
  • 1
    Could it be something as simple as special characters in the Feature Layer name 'Pipes >= 36"'? Try renaming it to 'Pipes gt 36inch'. If what you're trying to achieve is just for visualisation purposes then MS Word or Visio may be a better option for drawing the workflow. – Dan Dec 12 '17 at 0:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.