ArcGIS Pro 2.4.0 - all extensions
I have a dataset showing Water Mains (lines) for an area. I have been tasked with finding water mains that go from a given diameter to a smaller diameter, and back to a larger diameter.
For example: An 8" water main that links into a 6" water main, which then links back into an 8".
Ideally I would want to select just the 6" water main in the example but I'm unsure how to go about this. Another problem I think I might run into is that the water main lines are made up of many small segments. For example a 40 foot line is actually 8 different 5" segments.
I'm unsure whether I can use a tool for this, definition query, or write a Python script which I'm not very good with.