Create geography polyline from points in T-SQL

Detection score: 4.0

<p>What if you had two sensors writing to that table and your data looked like this:</p>

<p><a href="https://i.stack.imgur.com/MrzoT.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MrzoT.jpg" alt="enter image description here"></a></p>

<p>How might one go about converting the points into a geography polyline for each SensorID (so that you would have a SensorID/Polyline record for each SensorID)?</p>
Posted 11 days ago | reported 11 days ago
Posted by user3799279 (52)

Caught by 5 reasons: