I'm new with SQL spatial data processing, so I'm not sure how to solve my task. I have two tables - table with lines and table with points that are located on lines. Lines and points are related by ID value. I need to create another one table with points whee location of points is shifted for specified distance off corresponding line to the left or right (defined as attribute of a point). I.e. like it is shown below.
أكثر...
أكثر...