Using ArcGIS 10.3 I have a dataset containing polylines of a pipe network, along which I have a polygon layer representing a burst every 50m. The burst layer contains a value (p) and a unique ID (the center-point x_y).
For each pipe in the dataset I want to join the max. p value that it intersects, but also take the unique ID so that I know which burst event is the worst for any of the pipes. A standard spatial join will output the max. p value but not the ID.
So, in the image below the highlighted section of pipe intersects 4 burst events, I can do a spatial join to link the max value of 9 to this pipe, but how do I also record the unique ID of X_Y - in this case 4,2?