Find Lat, Long values given STdistance and a point value RRS feed

  • Question

  • DECLARE @pointA geography;
    DECLARE @pointB geography;
    SET @pointA = geography::Parse('POINT('+ CAST(119.93289251 AS VARCHAR) +' '+ CAST(-22.44282786 AS VARCHAR) +')') ;
    SET @pointB = geography::Parse('POINT('+ CAST(119.93289171 AS VARCHAR) +' '+ CAST(-22.44282573 AS VARCHAR) +')') ;
    SELECT @pointA.STDistance(@pointB);

    STDistance value between these two points = 0.249830 meters

    Given two points like above we can find Spatial distance between them. My question is if I know only one of the above points (ex:pointA) and STDistance value can I find the other point (ex:pointB).

    Thank you

    Thursday, January 26, 2017 7:56 PM

All replies

  • Hi Sriupp,

    I hope you can find a lead from the following link.

    Nevertheless, I am looking forward to see a solution posted on this page.



    Please mark this reply as answer if it solved your issue or vote as helpful if it helped.

    Thursday, January 26, 2017 8:28 PM
  • Thank you for the link, Sunit
    Thursday, January 26, 2017 8:57 PM