Orientation from 2 X Y points and Distance

• Steve Dell

  SSCarpal Tunnel

  Points: 4623

  More actions

  April 28, 2022 at 1:57 pm

  #4023700

  Hi ,

  Can some one help me in getting the orientation in SQL  for given Source(X1,Y1) ,Destination(X2,Y2) points and Distance(meters)

  Thanks in Advance

   

• ratbak

  Ten Centuries

  Points: 1358

  More actions

  April 28, 2022 at 3:08 pm

  #4023744

  If you're talking geography, this provides a method to get direction using lat/long: https://stackoverflow.com/questions/14736464/determining-cardinal-compass-direction-between-points

  Here's one that is supposed to calculate bearing between two points: https://www.spdba.com.au/cogo-calculating-the-bearing-between-two-points-sql-server-2008-spatial/

  Note: Given origin/source & destination points, distance seems redundant.