I have address points with house number and their side. For instance, there is a point of house number 10, and it's side is Left (whether Right or Left)
I also have the link that has relationship with the point (it shares same link_id)
what I want to do is translate the location to certain distance away from the link.
I think I probably have to draw perpendicular lines that cross the link at the house address points and move points based on the points side attribute.
I believe the centroid of the perpendicular line is the house address point the link has from node and to node so I think I can calculate the direction yet I do not know how to find out direction of the link in this type of shape
I do not know where and how to start :( What I have found so far is st_azimuth, st_makeline, st_translate..