I have two layers that I'm trying to conditionally join. One layer JUNCTIONS has junction IDs (NAME) and flooding volumes (Flood_cf) for each junction. I'm interested in identifying and symbolizing only the junctions with a flooding volume that exceeds a threshold (400 cubic feet).
The second layer CONDUITS contains pipe features with starting and ending nodes for each pipe. I would like to use the JUNCTIONS layer to identify the pipes that are surcharging (i.e. flooding). These are the pipes with starting nodes (INLETNODE) that match the NAMES from the JUNCTIONS layer which exceed the set threshold. Then, I would like to add a field to the CONDUITS layer in order to tag these pipes for symbology.
I tried doing a subquery (i.e. SELECT FROM (SELECT FROM) ) but I couldn't get the syntax to work. Alternatively, I could create a new feature class for the nodes that exceed the threshold, join the new layer to the CONDUITS layer, and export the results to a new layer. However, this process is tedious and generates a lot of extra and unnecessary files and fields. Is there a faster and a cleaner way to do this? I'll eventually have to create a model for this process because I need to run it on hundreds of files.
