Create Points to Line in QGIS while keep all information of points

Question

I am creating a storm track using HURDAT2 data which provided by NOAA. Provided Storm track information available in points like below snip (only sample)

Earlier with help of Previous version of QGIS plugin these points are converted into lines with all information which showing in attribute snip above.

But in new version of QGIS 3.24.1, plugin is not available and when I am using "Points to Path" option this delete all information between of points like below snip and keeping only first and last point. But I am in need of all information which available for further analysis.

Due to our company policy, we can't install previous version, so I have to use this updated version only.

Please suggest view on this. I have basic understating of R as well if anyone would like to suggest using R.

Answer 1

For this I would recommend using a Virtual Layer (Database --> DB Manager --> Virtual Layers --> Project layers). The cool thing about it is that you would automatically update your line layer whenever a new point is added.

Lets say you have a layer points with attributes windspeed, stormid and time. A virtual layer definition would look like this (You would need to adapt the query accordingly to your data):

SELECT 
    row_number() over() as id,
    windspeed,
    windspeed2,
    stormid,
    setsrid(make_line(geometry, geometry2),4326) as geometry
FROM (
  SELECT 
    windspeed,
    lead(windspeed) OVER w AS windspeed2,
    stormid,
    time,
    geometry, 
    lead(geometry) OVER w AS geometry2
  FROM 
    points WINDOW w AS (PARTITION BY stormid ORDER BY time) 
) as q
WHERE geometry2 IS NOT NULL;

Explanation:

1. Most important: the window function partitions your raw data by stormid and orders the vertices by the time property.
2. The geometry of the next vertex and the windspeed is accessed using the lead function using the window.
3. The outer query creates the line using make_line and adds a unique id using row_number().

Auto-update of lines when adding new data: