<p dir="ltr"><br>
Well,<br>
Updating geometries from columns.... Try doing that with MapInfo!!!!</p>
<p dir="ltr">Cool tips!</p>
<p dir="ltr">:)</p>
<p dir="ltr">Nicolas Cadieux M.Sc.</p>
<div class="gmail_quote">On Jan 6, 2016 20:58, "Nathan Woodrow [via OSGeo.org] " <<a href="/user/SendEmail.jtp?type=node&node=5244038&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a>> wrote:<br type='attribution'><blockquote style='border-left:2px solid #CCCCCC;padding:0 1em' class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<p dir="ltr">Or use excel to make a WKT column and import that.</p>
<p dir="ltr">Nathan</p>
<br /><div class="elided-text"><div dir="ltr">On Thu, 7 Jan 2016 11:48 am Nyall Dawson <<a href="/user/SendEmail.jtp?type=node&node=5244032&i=0">[hidden email]</a>> wrote:<br /></div>On 7 January 2016 at 07:08, Joris Hintjens <<a href="/user/SendEmail.jtp?type=node&node=5244032&i=1">[hidden email]</a>> wrote:<br />
> Hello,<br />
> I’m lost.<br />
> I have a list of movements. A table with (among others) a column “FROM” and a column “TO” (both containing coordinates)<br />
><br />
> How can I import this in QGIS so that I have a bunch of lines going from FROM to TO?<br />
><br />
<br />
This is relatively straightforward in QGIS master:<br />
<br />
- import your CSV file<br />
- right click the CSV layer, and choose "Save as"<br />
- change format to "ESRI Shapefile". Choose the correct CRS for your<br />
coordinates.<br />
- expand out the "Geometry" group and change "Geometry type" from<br />
"Automatic" to "LineString"<br />
- click OK, the new LineString shapefile (with all null geometries)<br />
will be added to the project<br />
- now, you need to create the geometries. This is done through the<br />
field calculator.<br />
- tick "update existing field"<br />
- change the field to "<geometry>"<br />
- enter the expression:<br />
'make_line(make_point("x1","y1"),make_point("x2","y2"))' (but replace<br />
x1, y1, ... with the correct columns names from your original CSV<br />
file)<br />
- click OK. Done!<br />
<br />
Nyall<br />
<br />
<br />
> thanks for your comments<br />
><br />
> Joris<br />
><br />
> _______________________________________________<br />
> Qgis-user mailing list<br />
> <a href="/user/SendEmail.jtp?type=node&node=5244032&i=2">[hidden email]</a><br />
> List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br />
> Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br />
_______________________________________________<br />
Qgis-user mailing list<br />
<a href="/user/SendEmail.jtp?type=node&node=5244032&i=3">[hidden email]</a><br />
List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br />
Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></blockquote></div>
<br />_______________________________________________
<br />Qgis-user mailing list
<br /><a href="/user/SendEmail.jtp?type=node&node=5244032&i=4">[hidden email]</a>
<br />List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br />Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
<br />
<br />
<hr noshade="noshade" size="1" />
<div style="color:#444;font:12px 'tahoma' , 'geneva' , 'helvetica' , 'arial' , sans-serif">
<div style="font-weight:bold">If you reply to this email, your message will be added to the discussion below:</div>
<a href="http://osgeo-org.1560.x6.nabble.com/Import-lines-from-cvs-tp5244005p5244032.html" target="_top" rel="nofollow" link="external">http://osgeo-org.1560.x6.nabble.com/Import-lines-from-cvs-tp5244005p5244032.html</a>
</div>
<div style="color:#666;font:11px 'tahoma' , 'geneva' , 'helvetica' , 'arial' , sans-serif;margin-top:0.4em;line-height:1.5em">
To start a new topic under Quantum GIS - User, email ml-node+s1560n4125267h38@n6.nabble.com <br />
To unsubscribe from Quantum GIS - User, <a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4125267&code=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYXw0MTI1MjY3fDYzNDQ4MjQxNg==">click here</a>.<br />
<a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml" style="font:9px serif">NAML</a>
</div></blockquote></div>
<br/><hr align="left" width="300" />
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/Import-lines-from-cvs-tp5244005p5244038.html">Re: Import lines from cvs</a><br/>
Sent from the <a href="http://osgeo-org.1560.x6.nabble.com/Quantum-GIS-User-f4125267.html">Quantum GIS - User mailing list archive</a> at Nabble.com.<br/>