Currently I've a table filled with measurements from a certain point. All the rows contain a location in Lat/Lon, a bearing in degrees and some other data containing sensor updates etc. At this moment I'm using the "bearing distance to line tool" in ArcGIS Pro to display the data.

I'm looking for a good method to generate the lines in SQL Server (Spatial). Ultimate goal is to display large amounts of measurements without having to use the tool of ArcGIS Pro.

How can I solve this problem?

  • How long should the lines be? – DPSSpatial Jul 2 '20 at 14:50
  • Around 15 Kilometers – Ben Jul 2 '20 at 16:37
  • What coordinate system are your Lat/Lon in? – DPSSpatial Jul 2 '20 at 17:11
  • The coordinate system is in WGS84 – Ben Jul 2 '20 at 17:17
  • perhaps the geography data type can translate the LAT/LON to kilometers, but I don't know what the SQL would be to utilize the azimuth... – DPSSpatial Jul 2 '20 at 17:23

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.