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)

enter image description here

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.

enter image description here

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

enter image description here

I do not know where and how to start :( What I have found so far is st_azimuth, st_makeline, st_translate..

  • ST_Azimuth to get angle, add 90 degrees, use ST_Translate with the x,y values coming from cos and sin of whatever angle you get from the first part. Nov 15 '18 at 15:40
  • @JohnPowell can i get an azimuth of the link at the house address point? if so, how?
    – Pil Kwon
    Nov 16 '18 at 1:41

This site is temporarily in read only mode and not accepting new answers.

Browse other questions tagged .