Export Spatialite point layer to CSV fails on Geometry AS_XY

[qgib]

Author Name: Jochen Huber (@huber-j)
Original Redmine Issue: 12796
Affected QGIS version: 2.8.2

---

When exporting a Spatialite point layer via "Save as...", geometry is only exported when selecting "AS_WKT". When selecting AS_XY or AS_YX, only the attribute values are exported (see attached files).
When exporting from a Shapefile, the geometry is written correctly with the option AS_XY.

---

• Export_WKT.csv (Jochen Huber)
• Export_XY.csv (Jochen Huber)

---

Related issue(s): #18990 (relates), #19856 (duplicates)
Redmine related issue(s): 10584, 11597

---

[qgib]

Author Name: Saber Razmjooei (@saberraz)

---

Confirmed also in master but not in 2.6.1.

It is a regression bug and marked as blocker.

---

• priority_id was changed from Low to Severe/Regression
• operating_system was changed from OSGeo4W to
• os_version was changed from Windows 7 Prof. x64 to

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• fixed_version_id was configured as Future Release - High Priority

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

Is that spatialite layer multipoint?

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Saber Razmjooei (@saberraz)

---

It is MULTIPOINT, indeed.

[qgib]

Author Name: Jochen Huber (@huber-j)

---

Yes, it is MULTIPOINT. Tested with POINT, and it works okay.

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

Jochen Huber wrote:

Yes, it is MULTIPOINT. Tested with POINT, and it works okay.

So I guess it's another problem. AS_XY doesn't work for MULTIPOINT. Question is how the multipoint layer was created - maybe related to the two related tickets.

---

• status_id was changed from Feedback to Closed
• resolution was changed from to duplicate

[qgib]

Author Name: Saber Razmjooei (@saberraz)

---

I think it is a problem with QSpatialite plugin. The ones converted to Spatialite through ogr2ogr are fine.

[qgib]

Author Name: Jochen Huber (@huber-j)

---

Yes, QSpatialite seems to always (often unnecessarily) generate MULTIPOINT feature sets when importing from QGIS layers.
An error message would be helpful in any case (e.g. "Option AS_XY not supported for MULTIPOINT datasets").
I even think it would be possible to export MULTIPOINT data with AS_XY:
Write one line for every POINT, using the same attributes for every MULTIPOINT part
Add a column "MULTIPART ID" with distinct values für distinct features and shared values for all parts of a MULTIPOINT.

[qgib]

Author Name: Saber Razmjooei (@saberraz)

---

You can always log another ticket as a feature request.
romain974/qspatialite#32