I have a shape (line) that represents the hydromorphology of watercourses and contains several parameters. This morphological study of watercourses has been done on every 100 meters of surface watercourses.
In other side, I have another shape (point) with measurement stations that is superimposed on the watercourses.
For a specific analysis, I need 10 trenches (1000 m) in the upstream of each station to calculate the average of certain parameters.
I did a select by location with the method (are whithin a distance of the source layer feature), but it gives me a selection of 10 trenches in upstream and downstream of the measurement stations.
The id's of trenches are not coded in a logical sequence.
The lines are connected to each other and flow in the source direction