I have line layer as shown in image 1. I created middle point of line by using the below query in virtual layer.
SELECT ST_StartPoint(ST_Line_Substring(geometry,0.5,1)) FROM "TR_ROAD copy"
The problem is it only creates the middle point without creating data (ids) for middlepoints(nodes).
- Is there are way to create unique ids for each middle point as sample is shown in last image