[Qgis-user] Export to vector layer to CSV with coordinates

[Chris Crook]

With version 1.7 you can load text files with a WKT column, so you don't need to convert text to columns (unless need to use the coordinates for processing in the spreadsheet).  This also means you can export and import lines and polygons as well as point layers.

Cheers
Chris

________________________________________
From: Goyo [goyodiaz at gmail.com]
Sent: 27 February 2011 15:54
To: Václav Řehák
Cc: qgis-user at lists.osgeo.org
Subject: Re: [Qgis-user] Export to vector layer to CSV with coordinates

2011/2/25 Václav Řehák <rehakv01 at gmail.com>:
> Hi list,
>
> is there a way how to export vector layer to a csv file including the
> coordinates? The "Save as..." - "Comma Separated Value" command
> exports only the attributes but my users would like to export the
> data, perform some processing (such as filtering) in Excel and load
> the data as a new layer.

This is what I do. Select the features in QGIS, copy, paste into your
spreadsheet app. The geometries are pasted as WKT in the first column.
Use "Text to columns" feature (this depends on your app) if you want
the coordinates as numbers. This works only for points and shouldn't
be necessary since the text import plugin seems to understand WKT. Do
your stuff, then select all cells, copy and paste into a text file for
use with QGIS.

This is indeed a terrible idea for data integrity but if you work with
shapefiles, dbf and text files you haven't got data integrity anyway.

Goyo

______________________________________________________________________________________________________

This message contains information, which is confidential and may be subject to legal privilege. 
If you are not the intended recipient, you must not peruse, use, disseminate, distribute or copy this message.
If you have received this message in error, please notify us immediately (Phone 0800 665 463 or info at linz.govt.nz) and destroy the original message.
LINZ accepts no responsibility for changes to this email, or for any attachments, after its transmission from LINZ.

Thank you.
______________________________________________________________________________________________________