I have polyline data with line segments for a pipe network and point data for the depths of the pipes at certain (deviant) points. I want to combine these two datasets into a new dataset. Any suggestions on how I can do this efficiently? I tried spatial join where the points and lines intersect, but because only some of the points lie precisely on a line segment, I got very few results. Spatial join by point closest to the line doesn't work for me either, because not every line segment has a point.
What I want is the depth attribute for each point to be added to the attribute table in the row of the closest line. How can I automate this?