1

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. – John Powell 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
  • Do you have a fixed or floating distance, should the transfer point touch buildings or not? – Cyril Jan 21 at 15:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.