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

Did Shadowfax go to Valinor?

What killed these X2 caps?

Is it inappropriate for a student to attend their mentor's dissertation defense?

Were any external disk drives stacked vertically?

Doing something right before you need it - expression for this?

How could indestructible materials be used in power generation?

intersection of two sorted vectors in C++

Blender 2.8 I can't see vertices, edges or faces in edit mode

1960's book about a plague that kills all white people

Neighboring nodes in the network

Brothers & sisters

Can a rocket refuel on Mars from water?

How can I prevent hyper evolved versions of regular creatures from wiping out their cousins?

Has there ever been an airliner design involving reducing generator load by installing solar panels?

Theorems that impeded progress

Why are electrically insulating heatsinks so rare? Is it just cost?

Etiquette around loan refinance - decision is going to cost first broker a lot of money

Is the Joker left-handed?

90's TV series where a boy goes to another dimension through portal near power lines

Why is Collection not simply treated as Collection<?>

Can a virus destroy the BIOS of a modern computer?

Is delete *p an alternative to delete [] p?

What is going on with Captain Marvel's blood colour?

Is Lorentz symmetry broken if SUSY is broken?



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
    2 days 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
    2 days ago


















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
    2 days 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
    2 days ago














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 2 days ago









Vince

14.8k32849




14.8k32849










asked 2 days ago









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
    2 days 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
    2 days ago


















  • 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
    2 days 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
    2 days ago

















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
2 days ago






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
2 days 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
2 days 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
2 days ago











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
    2 days ago











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

    – Tobbe
    yesterday











  • See answer by @JGH

    – HeikkiVesanto
    yesterday


















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
      2 days ago











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

      – Tobbe
      yesterday











    • See answer by @JGH

      – HeikkiVesanto
      yesterday















    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
      2 days ago











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

      – Tobbe
      yesterday











    • See answer by @JGH

      – HeikkiVesanto
      yesterday













    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 2 days ago









    HeikkiVesantoHeikkiVesanto

    9,1652245




    9,1652245












    • Works perfect! Many thanks!

      – Tobbe
      2 days ago











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

      – Tobbe
      yesterday











    • See answer by @JGH

      – HeikkiVesanto
      yesterday

















    • Works perfect! Many thanks!

      – Tobbe
      2 days ago











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

      – Tobbe
      yesterday











    • See answer by @JGH

      – HeikkiVesanto
      yesterday
















    Works perfect! Many thanks!

    – Tobbe
    2 days ago





    Works perfect! Many thanks!

    – Tobbe
    2 days ago













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

    – Tobbe
    yesterday





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

    – Tobbe
    yesterday













    See answer by @JGH

    – HeikkiVesanto
    yesterday





    See answer by @JGH

    – HeikkiVesanto
    yesterday













    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 2 days ago









        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

            getting Checkpoint VPN SSL Network Extender working in the command lineHow to connect to CheckPoint VPN on Ubuntu 18.04LTS?Will the Linux ( red-hat ) Open VPNC Client connect to checkpoint or nortel VPN gateways?VPN client for linux machine + support checkpoint gatewayVPN SSL Network Extender in FirefoxLinux Checkpoint SNX tool configuration issuesCheck Point - Connect under Linux - snx + OTPSNX VPN Ububuntu 18.XXUsing Checkpoint VPN SSL Network Extender CLI with certificateVPN with network manager (nm-applet) is not workingWill the Linux ( red-hat ) Open VPNC Client connect to checkpoint or nortel VPN gateways?VPN client for linux machine + support checkpoint gatewayImport VPN config files to NetworkManager from command lineTrouble connecting to VPN using network-manager, while command line worksStart a VPN connection with PPTP protocol on command linestarting a docker service daemon breaks the vpn networkCan't connect to vpn with Network-managerVPN SSL Network Extender in FirefoxUsing Checkpoint VPN SSL Network Extender CLI with certificate

            Cannot Extend partition with GParted The 2019 Stack Overflow Developer Survey Results Are In Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) 2019 Community Moderator Election ResultsCan't increase partition size with GParted?GParted doesn't recognize the unallocated space after my current partitionWhat is the best way to add unallocated space located before to Ubuntu 12.04 partition with GParted live?I can't figure out how to extend my Arch home partition into free spaceGparted Linux Mint 18.1 issueTrying to extend but swap partition is showing as Unknown in Gparted, shows proper from fdiskRearrange partitions in gparted to extend a partitionUnable to extend partition even though unallocated space is next to it using GPartedAllocate free space to root partitiongparted: how to merge unallocated space with a partition

            NetworkManager fails with “Could not find source connection”Trouble connecting to VPN using network-manager, while command line worksHow can I be notified about state changes to a VPN adapterBacktrack 5 R3 - Refuses to connect to VPNFeed all traffic through OpenVPN for a specific network namespace onlyRun daemon on startup in Debian once openvpn connection establishedpfsense tcp connection between openvpn and lan is brokenInternet connection problem with web browsers onlyWhy does NetworkManager explicitly support tun/tap devices?Browser issues with VPNTwo IP addresses assigned to the same network card - OpenVPN issues?Cannot connect to WiFi with nmcli, although secrets are provided