3
Once you have the .csv loaded into QGIS, open the Processing Toolbox and go to Vectory geometry > Geometry by expression.
The 'Input layer' should be your .csv, 'Output geometry type' should be 'Line', and write the following in 'Geometry expression':
make_line(make_point("DS_X", "DS_Y"), make_point("US_X", "US_Y"))
...
3
In the layer style panel, use an expression to convert your string type into real.
Insted of using rates, use to_real("rates") and it will work (supposing your field is named "rates").
2
You can speed up CSVs by using the spatial index as stated at QGIS user manual within this chapter.
However, as already stated in comments, using another file format or especially a spatial database like PostGIS can have more effect.
1
I think @romainbh already gave a better answer, but you can also force QGIS to interpret CSV colums as a special datatype by using a CSV-T.
Therefore create a new textfile, fill it with the column-datatypes of your CSV like this:
"Integer(10)","Real(10.5)","String(80)"
You can use Integer, Real, String, Date, Time and DateTime. ...
Only top voted, non community-wiki answers of a minimum length are eligible
