Hello,<div><br></div><div>I have 3 columns in my table, with data as</div><div><br></div><div>Latitude Longitude Utc_time</div><div> </div><div><div>56.6474065 12.8533945 132733</div><div>
56.647401 12.8534145 132733</div></div><div><div>56.6473953333 12.8534343333 132733</div></div><div><div>56.6473893333 12.8534556667 132733</div></div><div>56.6473006667 12.8537761667 132737</div>
<div>56.647293 12.8538066667 132737</div><div>56.6472853333 12.8538373333 132737</div><div><br></div><div>I want to create a Geography linestring/multiline column of latitude/longitude values where time is same</div>
<div>for eg. time of first 4 rows is same, hence a line should be created between 1st row and 4th row.</div><div><br></div><div>any idea how can i do this, and a proper syntax is requested , since i am very new in creating a spatial table.</div>