Connect points with lines QGISCSV 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

Approximately how much travel time was saved by the opening of the Suez Canal in 1869?

Today is the Center

How much of data wrangling is a data scientist's job?

Two films in a tank, only one comes out with a development error – why?

Why is consensus so controversial in Britain?

Client team has low performances and low technical skills: we always fix their work and now they stop collaborate with us. How to solve?

When a company launches a new product do they "come out" with a new product or do they "come up" with a new product?

How old can references or sources in a thesis be?

Revoked SSL certificate

I'm flying to France today and my passport expires in less than 2 months

Was any UN Security Council vote triple-vetoed?

How can bays and straits be determined in a procedurally generated map?

Uncaught TypeError: 'set' on proxy: trap returned falsish for property Name

Can I ask the recruiters in my resume to put the reason why I am rejected?

DC-DC converter from low voltage at high current, to high voltage at low current

Should the isomorphism theorems be seen as an "interface" between algebra and category theory?

Can I make popcorn with any corn?

Do infinite dimensional systems make sense?

how to check a propriety using r studio

Filter any system log file by date or date range

Replacing matching entries in one column of a file by another column from a different file

Horror movie about a virus at the prom; beginning and end are stylized as a cartoon

Rock identification in KY

Mutually beneficial digestive system symbiotes



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






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








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



enter image description here
Data example:



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









share|improve this question
























  • 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
    Apr 2 at 9:23












  • 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
    Apr 2 at 10:50


















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



enter image description here
Data example:



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









share|improve this question
























  • 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
    Apr 2 at 9:23












  • 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
    Apr 2 at 10:50














1












1








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



enter image description here
Data example:



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









share|improve this question
















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



enter image description here
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















share|improve this question













share|improve this question




share|improve this question








edited Apr 2 at 12:29









Vince

14.8k32849




14.8k32849










asked Apr 2 at 9:18









TobbeTobbe

346210




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
    Apr 2 at 9:23












  • 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
    Apr 2 at 10:50


















  • 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
    Apr 2 at 9:23












  • 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
    Apr 2 at 10:50

















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
Apr 2 at 9:23






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
Apr 2 at 9:23














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
Apr 2 at 10:50






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
Apr 2 at 10:50











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:



enter image description here






share|improve this answer























  • Works perfect! Many thanks!

    – Tobbe
    Apr 2 at 11:24











  • If i want to save the layer as a kml with the lines how do i do that?

    – Tobbe
    2 days ago











  • See answer by @JGH

    – HeikkiVesanto
    2 days ago


















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























    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


















    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















    Required, but never shown

























    2 Answers
    2






    active

    oldest

    votes








    2 Answers
    2






    active

    oldest

    votes









    active

    oldest

    votes






    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:



    enter image description here






    share|improve this answer























    • Works perfect! Many thanks!

      – Tobbe
      Apr 2 at 11:24











    • If i want to save the layer as a kml with the lines how do i do that?

      – Tobbe
      2 days ago











    • See answer by @JGH

      – HeikkiVesanto
      2 days ago















    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:



    enter image description here






    share|improve this answer























    • Works perfect! Many thanks!

      – Tobbe
      Apr 2 at 11:24











    • If i want to save the layer as a kml with the lines how do i do that?

      – Tobbe
      2 days ago











    • See answer by @JGH

      – HeikkiVesanto
      2 days ago













    4












    4








    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:



    enter image description here






    share|improve this answer













    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:



    enter image description here







    share|improve this answer












    share|improve this answer



    share|improve this answer










    answered Apr 2 at 11:15









    HeikkiVesantoHeikkiVesanto

    9,1752245




    9,1752245












    • Works perfect! Many thanks!

      – Tobbe
      Apr 2 at 11:24











    • If i want to save the layer as a kml with the lines how do i do that?

      – Tobbe
      2 days ago











    • See answer by @JGH

      – HeikkiVesanto
      2 days ago

















    • Works perfect! Many thanks!

      – Tobbe
      Apr 2 at 11:24











    • If i want to save the layer as a kml with the lines how do i do that?

      – Tobbe
      2 days ago











    • See answer by @JGH

      – HeikkiVesanto
      2 days ago
















    Works perfect! Many thanks!

    – Tobbe
    Apr 2 at 11:24





    Works perfect! Many thanks!

    – Tobbe
    Apr 2 at 11:24













    If i want to save the layer as a kml with the lines how do i do that?

    – Tobbe
    2 days ago





    If i want to save the layer as a kml with the lines how do i do that?

    – Tobbe
    2 days ago













    See answer by @JGH

    – HeikkiVesanto
    2 days ago





    See answer by @JGH

    – HeikkiVesanto
    2 days ago













    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



























      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

























        2












        2








        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













        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












        share|improve this answer



        share|improve this answer










        answered Apr 2 at 11:21









        JGHJGH

        13.5k21139




        13.5k21139



























            draft saved

            draft discarded
















































            Thanks for contributing an answer to Geographic Information Systems Stack Exchange!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid


            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.

            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            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















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            Romeo and Juliet ContentsCharactersSynopsisSourcesDate and textThemes and motifsCriticism and interpretationLegacyScene by sceneSee alsoNotes and referencesSourcesExternal linksNavigation menu"Consumer Price Index (estimate) 1800–"10.2307/28710160037-3222287101610.1093/res/II.5.31910.2307/45967845967810.2307/2869925286992510.1525/jams.1982.35.3.03a00050"Dada Masilo: South African dancer who breaks the rules"10.1093/res/os-XV.57.1610.2307/28680942868094"Sweet Sorrow: Mann-Korman's Romeo and Juliet Closes Sept. 5 at MN's Ordway"the original10.2307/45957745957710.1017/CCOL0521570476.009"Ram Leela box office collections hit massive Rs 100 crore, pulverises prediction"Archived"Broadway Revival of Romeo and Juliet, Starring Orlando Bloom and Condola Rashad, Will Close Dec. 8"Archived10.1075/jhp.7.1.04hon"Wherefore art thou, Romeo? To make us laugh at Navy Pier"the original10.1093/gmo/9781561592630.article.O006772"Ram-leela Review Roundup: Critics Hail Film as Best Adaptation of Romeo and Juliet"Archived10.2307/31946310047-77293194631"Romeo and Juliet get Twitter treatment""Juliet's Nurse by Lois Leveen""Romeo and Juliet: Orlando Bloom's Broadway Debut Released in Theaters for Valentine's Day"Archived"Romeo and Juliet Has No Balcony"10.1093/gmo/9781561592630.article.O00778110.2307/2867423286742310.1076/enst.82.2.115.959510.1080/00138380601042675"A plague o' both your houses: error in GCSE exam paper forces apology""Juliet of the Five O'Clock Shadow, and Other Wonders"10.2307/33912430027-4321339124310.2307/28487440038-7134284874410.2307/29123140149-661129123144728341M"Weekender Guide: Shakespeare on The Drive""balcony"UK public library membership"romeo"UK public library membership10.1017/CCOL9780521844291"Post-Zionist Critique on Israel and the Palestinians Part III: Popular Culture"10.2307/25379071533-86140377-919X2537907"Capulets and Montagues: UK exam board admit mixing names up in Romeo and Juliet paper"Istoria Novellamente Ritrovata di Due Nobili Amanti2027/mdp.390150822329610820-750X"GCSE exam error: Board accidentally rewrites Shakespeare"10.2307/29176390149-66112917639"Exam board apologises after error in English GCSE paper which confused characters in Shakespeare's Romeo and Juliet""From Mariotto and Ganozza to Romeo and Guilietta: Metamorphoses of a Renaissance Tale"10.2307/37323537323510.2307/2867455286745510.2307/28678912867891"10 Questions for Taylor Swift"10.2307/28680922868092"Haymarket Theatre""The Zeffirelli Way: Revealing Talk by Florentine Director""Michael Smuin: 1938-2007 / Prolific dance director had showy career"The Life and Art of Edwin BoothRomeo and JulietRomeo and JulietRomeo and JulietRomeo and JulietEasy Read Romeo and JulietRomeo and Julieteeecb12003684p(data)4099369-3n8211610759dbe00d-a9e2-41a3-b2c1-977dd692899302814385X313670221313670221

            Creating closest line along the point''s azimuth using PostgreSQL Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?Drawing line between points at specific distance in PostGIS?How to efficiently find the closest point over the dateline?How to find the nearest point by using PostGIS function?PostGIS nearest point with LATERAL JOIN in PostgreSQL 9.3+Creating a table and inserting selected streets using plpgsql functionsCreating a table that stores Distances and other columnSaving select query results (year wise) from PostgreSQL/PostGIS to text filesWhat is the information behind this geometry?How to give start and end vertex ids dynamically in pgr_dijkstra?Point to Polygon nearest distance DS_distance is not using geography index & knn <-> or <#> does not give result in orderLine to point conversion with start point and end point detection?

            Crop image to path created in TikZ? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Crop an inserted image?TikZ pictures does not appear in posterImage behind and beyond crop marks?Tikz picture as large as possible on A4 PageTransparency vs image compression dilemmaHow to crop background from image automatically?Image does not cropTikzexternal capturing crop marks when externalizing pgfplots?How to include image path that contains a dollar signCrop image with left size given