Ttdfjt

Notepad++ delete until colon for every line with replace all

What's the meaning of "Sollensaussagen"?

Processor speed limited at 0.4 Ghz

Description list Formatting using enumitem

How seriously should I take size and weight limits of hand luggage?

Is it possible to map the firing of neurons in the human brain so as to stimulate artificial memories in someone else?

Unlock My Phone! February 2018

Is there an online compendium of Rav Moshe teshuvos in English that exists?

Expand and Contract

My ex-girlfriend uses my Apple ID to log in to her iPad. Do I have to give her my Apple ID password to reset it?

What historical events would have to change in order to make 19th century "steampunk" technology possible?

How exploitable/balanced is this homebrew spell: Spell Permanency?

how do we prove that a sum of two periods is still a period?

How could indestructible materials be used in power generation?

How to prevent "they're falling in love" trope

Is there a hemisphere-neutral way of specifying a season?

Mathematica command that allows it to read my intentions

In the UK, is it possible to get a referendum by a court decision?

meaning of 腰を落としている

Knowledge-based authentication using Domain-driven Design in C#

How to remove border from elements in the last row?

Venezuelan girlfriend wants to travel the USA to be with me. What is the process?

How do conventional missiles fly?

Avoiding the "not like other girls" trope?

Connect points with lines QGIS

CSV with latitude and longitude to a spatial points with QGIS 1.8Extract coordinates from polyline in QGISHow to automatically connect pointHow connect points with lines in QGIS?Connect multiple 2 points with a line in ArcGIS?Connecting two points in ArcGIS for Desktop?Connect two points with fixed longitudinal slope over DEM - QGISJoin shapefile and csv when identification uses two or more attributesMap point with coordinates to zones in QGISDraw Bounds with coordinates in QGIS from CSV

1

I have a CSV file with 2 columns with coordinates for the A side and 2 columns for the B side.
I have several identifiers in other columns if needed.

I want to connect these with a line between A and B side. Approx 5500 rows.

Column AE identifier

BC & BD used for A side

BE & BF used for B side

Data example:

Longitude Latitude Expr1_Longitud Expr_1_Latitude 
1295791.166 6469378.367 1292369 6474768 
1295791.166 6469378.367 1296158 6470702

qgis line

share|improve this question

edited 18 hours ago

Vince

14.8k32849

asked 21 hours ago

TobbeTobbe

346210

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Just make sure points which belong to each other have the same ID, then load everything into QGIS and use points to path/line. Also, a data-example could be helpful.
  
  – Erik
  21 hours ago
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Please edit your post rather than dumping lines of numbers in the comments which become hard to read. As to how QGIS can connect these points: Add a column which gives each row an ID, then load two points layers, one using the first two coordinates, one using the second pair of coordinates. Join these layers, then use points to lines.
  
  – Erik
  19 hours ago
  
  

  
  
  
  

add a comment | 

1

I have a CSV file with 2 columns with coordinates for the A side and 2 columns for the B side.
I have several identifiers in other columns if needed.

I want to connect these with a line between A and B side. Approx 5500 rows.

Column AE identifier

BC & BD used for A side

BE & BF used for B side

Data example:

Longitude Latitude Expr1_Longitud Expr_1_Latitude 
1295791.166 6469378.367 1292369 6474768 
1295791.166 6469378.367 1296158 6470702

qgis line

share|improve this question

edited 18 hours ago

Vince

14.8k32849

asked 21 hours ago

TobbeTobbe

346210

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Just make sure points which belong to each other have the same ID, then load everything into QGIS and use points to path/line. Also, a data-example could be helpful.
  
  – Erik
  21 hours ago
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Please edit your post rather than dumping lines of numbers in the comments which become hard to read. As to how QGIS can connect these points: Add a column which gives each row an ID, then load two points layers, one using the first two coordinates, one using the second pair of coordinates. Join these layers, then use points to lines.
  
  – Erik
  19 hours ago
  
  

  
  
  
  

add a comment | 

I have a CSV file with 2 columns with coordinates for the A side and 2 columns for the B side.
I have several identifiers in other columns if needed.

I want to connect these with a line between A and B side. Approx 5500 rows.

Column AE identifier

BC & BD used for A side

BE & BF used for B side

Data example:

Longitude Latitude Expr1_Longitud Expr_1_Latitude 
1295791.166 6469378.367 1292369 6474768 
1295791.166 6469378.367 1296158 6470702

qgis line

share|improve this question

edited 18 hours ago

Vince

14.8k32849

asked 21 hours ago

TobbeTobbe

346210

Longitude Latitude Expr1_Longitud Expr_1_Latitude 
1295791.166 6469378.367 1292369 6474768 
1295791.166 6469378.367 1296158 6470702

share|improve this question

edited 18 hours ago

Vince

14.8k32849

asked 21 hours ago

TobbeTobbe

346210

share|improve this question

edited 18 hours ago

Vince

14.8k32849

asked 21 hours ago

TobbeTobbe

346210

edited 18 hours ago

Vince

14.8k32849

edited 18 hours ago

Vince

14.8k32849

asked 21 hours ago

TobbeTobbe

346210

asked 21 hours ago

TobbeTobbe

346210

2 Answers
2

active

oldest

votes

4

This is a good place to use a geometry generator as the render.

Simply add in the file as using one set of coordinates as a delimited text layer.

Then open up the layer properties and in the symbology.

Choose, Geometry Generator form the Symbol layer type and using the expression:

make_line( make_point("Longitude", "Latitude"), make_point("Expr1_Longitud", "Expr_1_Latitude"))

Like so:

share|improve this answer

answered 19 hours ago

HeikkiVesantoHeikkiVesanto

9,1652245

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Works perfect! Many thanks!
  
  – Tobbe
  19 hours ago
  

  
  
  
  

add a comment | 

2

If you need the line for analysis (and not just for display), you can use a virtual layer.

The expression is very similar to the one provided by @HeikkiVesanto

go the menu layer / add layer / add - edit virtual layer then insert the query

SELECT referenceID, ST_make_line( ST_make_point("Longitude", "Latitude"), ST_make_point("Expr1_Longitud", "Expr_1_Latitude")) as geometry

share|improve this answer

answered 19 hours ago

JGHJGH

13.4k21139

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f317461%2fconnect-points-with-lines-qgis%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

4

This is a good place to use a geometry generator as the render.

Simply add in the file as using one set of coordinates as a delimited text layer.

Then open up the layer properties and in the symbology.

Choose, Geometry Generator form the Symbol layer type and using the expression:

make_line( make_point("Longitude", "Latitude"), make_point("Expr1_Longitud", "Expr_1_Latitude"))

Like so:

share|improve this answer

answered 19 hours ago

HeikkiVesantoHeikkiVesanto

9,1652245

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Works perfect! Many thanks!
  
  – Tobbe
  19 hours ago
  

  
  
  
  

add a comment | 

4

This is a good place to use a geometry generator as the render.

Simply add in the file as using one set of coordinates as a delimited text layer.

Then open up the layer properties and in the symbology.

Choose, Geometry Generator form the Symbol layer type and using the expression:

make_line( make_point("Longitude", "Latitude"), make_point("Expr1_Longitud", "Expr_1_Latitude"))

Like so:

share|improve this answer

answered 19 hours ago

HeikkiVesantoHeikkiVesanto

9,1652245

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Works perfect! Many thanks!
  
  – Tobbe
  19 hours ago
  

  
  
  
  

add a comment | 

This is a good place to use a geometry generator as the render.

Simply add in the file as using one set of coordinates as a delimited text layer.

Then open up the layer properties and in the symbology.

Choose, Geometry Generator form the Symbol layer type and using the expression:

make_line( make_point("Longitude", "Latitude"), make_point("Expr1_Longitud", "Expr_1_Latitude"))

Like so:

share|improve this answer

answered 19 hours ago

HeikkiVesantoHeikkiVesanto

9,1652245

make_line( make_point("Longitude", "Latitude"), make_point("Expr1_Longitud", "Expr_1_Latitude"))

share|improve this answer

answered 19 hours ago

HeikkiVesantoHeikkiVesanto

9,1652245

answered 19 hours ago

HeikkiVesantoHeikkiVesanto

9,1652245

answered 19 hours ago

HeikkiVesantoHeikkiVesanto

9,1652245

2

If you need the line for analysis (and not just for display), you can use a virtual layer.

The expression is very similar to the one provided by @HeikkiVesanto

go the menu layer / add layer / add - edit virtual layer then insert the query

SELECT referenceID, ST_make_line( ST_make_point("Longitude", "Latitude"), ST_make_point("Expr1_Longitud", "Expr_1_Latitude")) as geometry

share|improve this answer

answered 19 hours ago

JGHJGH

13.4k21139

add a comment | 

2

If you need the line for analysis (and not just for display), you can use a virtual layer.

The expression is very similar to the one provided by @HeikkiVesanto

go the menu layer / add layer / add - edit virtual layer then insert the query

SELECT referenceID, ST_make_line( ST_make_point("Longitude", "Latitude"), ST_make_point("Expr1_Longitud", "Expr_1_Latitude")) as geometry

share|improve this answer

answered 19 hours ago

JGHJGH

13.4k21139

add a comment | 

If you need the line for analysis (and not just for display), you can use a virtual layer.

The expression is very similar to the one provided by @HeikkiVesanto

go the menu layer / add layer / add - edit virtual layer then insert the query

SELECT referenceID, ST_make_line( ST_make_point("Longitude", "Latitude"), ST_make_point("Expr1_Longitud", "Expr_1_Latitude")) as geometry

share|improve this answer

answered 19 hours ago

JGHJGH

13.4k21139

SELECT referenceID, ST_make_line( ST_make_point("Longitude", "Latitude"), ST_make_point("Expr1_Longitud", "Expr_1_Latitude")) as geometry

share|improve this answer

answered 19 hours ago

JGHJGH

13.4k21139

answered 19 hours ago

JGHJGH

13.4k21139

answered 19 hours ago

JGHJGH

13.4k21139