I would like to find on which side of the line (left or right) my points are located with respect to the direction of the line (like knowing the rivers bank along a meandering river). But, if there are several line, I am only interested in the closest line.
I know that I could use one sided buffers like it is suggested in this post, but this doesn't work well when several lines are close to each other near the point.
For instance, there are sometimes two (or more) lines close to my point of interest, which then create two (or more) overlapping polygons covering this point. In this case, the point could be on the left of one line and on the right of the other line.
I only want to know the side of the closest road to the point (avoiding multiple buffers and selections because the database is very large. A single query maybe)