12

I use Python try to write vector layer file to csv file with this code:

QgsVectorFileWriter.writeAsVectorFormat(mylayer, r'c:\temp\xyz.csv', "utf-8", None, "CSV")

It can export to xyz.csv but only attributes show in the csv, not the geometry column.

How can I export both attribute and spatial data into csv file?

PolyGeo
  • 65,136
  • 29
  • 109
  • 338
Anubiz
  • 121
  • 1
  • 4
  • 1
    Here is the same question and the solution link. – mete7 May 25 '13 at 15:00
  • I'm sorry for make question not clear.

    my work use python with pyqgis write vector layer to csv file. I want csv file have geometry but it not. still need answer

     – Anubiz May 26 '13 at 07:55
  • Depends on what type of vector layer you want to export. For point layer you could just add the lat, long values as attribute table columns. For all others you need WKT – Curlew May 26 '13 at 08:39
  • Thank you Curlew, I work with point and polygon layer. for point layer you mean add lat, lon column in attribute table? how about polygon? – Anubiz May 27 '13 at 08:39
  • if anyone mark duplicate question, please show link to right answer for me. thanks – Anubiz Jun 06 '13 at 12:58
  • 3
    Is this really a duplicate? This question here is aimed particularly at python, which is not covered by the linked answer. – Matthias Kuhn Jun 10 '13 at 08:18
  • Thank you Matthias Kuhn, you are right. I can't contact people who mark duplicate my question and and StackExchange.com comment to ask a new question so I make a new question here http://gis.stackexchange.com/questions/63136/can-pyqgis-write-shape-file-to-csv-with-geometry-data-using-python – Anubiz Jun 10 '13 at 09:03
  • You don't need to open a new question just because someone suggested this could be a duplicate. It's fine as it is. – underdark Jun 10 '13 at 13:01

1 Answers1

10

A similar answer was provided from this post:

Save as .csv with coordinates in both QGIS 2.2 and PyqGIS

Just add layerOptions ='GEOMETRY=AS_XYZ at the end:

layer = QgsVectorLayer("path/to/shapefile", "name", "ogr")
QgsVectorFileWriter.writeAsVectorFormat(layer, r'c:\temp\xyz.csv', "utf-8", None, "CSV", layerOptions='GEOMETRY=AS_XYZ')
Community
  • 1
Joseph
  • 75,746
  • 7
  • 171
  • 282
  • Hi, I am facing a problem in this, If I type this in console it does not save the Spatial data but only the attributes. But if I save it manually it works. I am using QGIS 2.14.12. – Sunny Naik Jun 06 '17 at 06:14
  • 2
    @SunnyNaik - The layerOptions parameter now requires a list of string values whereas before a single value was enough (as described in this post). So your last line would look like: QgsVectorFileWriter.writeAsVectorFormat(layer, r'c:\temp\xyz.csv', "utf-8", None, "CSV", layerOptions=['GEOMETRY=AS_XYZ']) – Joseph Jun 06 '17 at 09:14