Generating start and end points for individual road segments

Question

I have shape file with road network (line layer) as shown in Image 1. The road network contains multiple line segments as shown with blue line in image.

• I am trying to generate start and end point of every road segment.
• Save the start and end point in a seperate layer.

Based on the suggested answer here, I am trying to get the start and end points by using query in virtual layer

Problem:It merges start and end points into single colomn. I am trying to get them in seperate coloumns. For instance, Col 1: start points, Col2: end points

select From_id, st_startpoint(geometry) as geometry from lineshp 
union
select To_id, st_endpoint(geometry) as geometry from lineshp

Attempt with geometry generator:

Problem: It only displays the start and end points. It does not save the data in seperate layer.

union (
    end_point ( $geometry ),
    start_point ( $geometry )
)

Answer 1

Using the virtual layer, you can compute both start and end point in a single row. Beware that your layer will now have 2 geometry fields, which are a pain to display (the 1st one is usually used)

SELECT From_id, st_startpoint(geometry) as geometryFrom, 
       To_id, st_endpoint(geometry) as geometryTO 
FROM lineshp 

Answer 2

you could just use the Vector->Geometry Tools->Extract Verctices tool to make an output of all vertices.

Then you could use a Select by expression to get the min and max vertices:

"vertex_ind" = maximum("vertex_ind", group_by:="[your_id_field]")
OR
"vertex_ind" = 0

Then export the selected features as a new shapefile.

You can add the coordinates to a new field using the formula:

x($geometry)

and

y($geometry)

Answer 3

Run the extract specific vertices tool. Select 0 and -1 for the start and end points to be created as a point layer. Join attributes by location to get both point datasets into the same layer.