[GIS] Drawing lines between two points in QGIS

coordinatesexcelpointpolygon-creationqgis

I have an Excel (Fig) which has both "X" & "Y" in projected coordinates (WGS84/UTM). Is it possible to draw lines between the "X" & "Y"in QGIS?

I've tried to create points based on X,From_y and X,To_y. I've created two points by just loading them using add delimiter layer (pasted To_Y below From_Y and loaded it). Then tried with Points 2 paths. But it didn't work out.

Anyone know how to fix this ?

All i need is traverse line between the points

enter image description here

This is what i am looking for. I've coordinates(X1, a1 and X1, a2) for n number of points which has to be connected by a vertical line

enter image description here

Best Answer

The quickest way to do this with a single line would be using the QuickWKT plugin; you can then right-click and Save As to any format you need.

Let's say your two points are in UTM Zone 36S, and here are listed as x (easting), y (northing):

  1. 151930,9593414
  2. 184802,9587212

The WKT format for a line is:

SRID=SRID;LINESTRING (x1 y1, x2 y2, x3 y3, ...)

Thus, for the example above:

SRID=32736;LINESTRING (151930 9593414, 184802 9587212)

Pasted into the QuickWKT plugin text box:

enter image description here

For larger sets of data, you can make an Excel table into a geographic data type by building that WKT string into a column, i.e. (where A2-D2 contain two sets of XY coords):

=CONCATENATE("SRID=32736;LINESTRING (",A2, " ", B2, ",", C2, " ", D2, ")")

You can save from Excel as a CSV and then use the add delimited text in QGIS (with "watch file" selected to keep it updated).

Related Question