I have 80km of embankments which have been laserscanned. I have a polyline running approximately along the top of the embankment. At regular intervals (20m) along this polyline I have a point feature from which I have created perpendicular lines 10 meters each side of the point. Each perpendicular line has been assigned an ID corresponding to it's distance from the start .ie 0, 20,40,60 etc
From my DEM I need to extract the values along the perpendicular line. I then need to sort the z-values descending and keep the highest z-value. I then need to group the values according to the ID of the perpendicular line thus keeping the highest z-values along the perpendicular line. The resulting value must then be kept as an attribute of the center point (green) of the perpendicular line for a label on a map showing the ridge of the embankment and the highest point.
I have managed to create perpendicular lines each side of the embankment but cannot find a transformer that will extract the values from the DEM and let me order descending and group by the Line's ID.
Could anyone point me in the right direction?